Find Jobs
Hire Freelancers

Excel Operational Analytics

£20-250 GBP

Dibatalkan
Disiarkan sekitar 1 bulan yang lalu

£20-250 GBP

Dibayar semasa penghantaran
Tasks : 1. Construct a queueing model that replicates a week of collecting and processing DNA samples. a. First develop a flow diagram of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interest – a DNA sample collected by a CSI. That is, each sample must be modelled individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many of those samples will result in a DNA match? b. What is the mean time to process a sample? c. What percentage of samples meet the police force’s ambition to process samples in less than one day? d. Is there any stage of the process that looks under-resourced? Why? 4. Construct a simulation model using the information provided to you above, and your average model as the starting point. a. Unit of interest – a DNA sample collected by a CSI. That is, each sample must be modelled individually. b. Each iteration of the simulation is one week of processing samples. c. Use the same assumptions as for the Task 2 model. d. You MUST use @RISK. Do NOT save raw simulation data in the file. e. You must save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. f. You will need to determine the appropriate probability distribution for each input. g. Run the model for 10,000 iterations. h. Set the random number seed to the last four digits of your Student ID number. 4. Results to find for the simulation model: a. Present all time units in minutes. b. Summarise* the distribution for the mean time a sample waits in the queue for the: CSI to arrive; for sample preparation; for DNA sequencing; and finally for validation. c. Comment on any observations/insights from the queueing time distributions you have plotted and summarised in Task 4a. d. Summarise* the distribution for the mean number of samples processed, and the mean number of samples matched to the DNA database, in one week. e. Plot and summarise the distribution for the mean time to process a sample. f. Plot and summarise the distribution for the percentage of samples that are processed in under 24 hours (each iteration being one week of sampling). g. How confident are we that at least half of all samples in one week will be processed in 24 hours or less? h. Conduct an appropriate Sensitivity Analysis that shows the main influence on the time it takes a sample to be processed. i. Conduct any other relevant, ad-hoc analyses that you think will yield useful insights to help reduce the time to process samples further. 5. What-if Scenario modelling a. Taking your further analyses from Tasks 4f and 4g as the basis for improving the model, construct 2-3 plausible scenarios that will improve the confidence that at least half of all samples from one week are processed in 24 hours or less. b. Modify at least two stages of the model (these must be reasonably unique – do not copy scenarios from others). c. Rerun simulation model with the same random number seed and compare results to that produced in Task 4. d. By plotting and comparing relevant probability distributions, explain how your modified scenario has reduced the time taken to process samples, and how it has impacted the likelihood of processing samples in under one day. 6. Insights and recommendations a. In your report, provide a short summary of your insights and recommendations for how to improve the Rapid DNA process that was trialled over the past few months. *Appropriate metrics to summarise a distribution are either mean(5th percentile;95th percentile) or median(5th percentile;95th percentile), depending on the skewness of the distribution.
ID Projek: 38012799

Tentang projek

30 cadangan
Projek jarak jauh
Aktif 1 bulan yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
30 pekerja bebas membida secara purata £137 GBP untuk pekerjaan ini
Avatar Pengguna
Hello there, With over five years of experience in the field, my expertise in Data Processing and Excel complements your project requirements excellently. The successful design and construction of complex yet user-friendly spreadsheets are much within my capabilities, thanks to my extensive fluency with Excel tools, including Macros and Visual Basic. It's worth noting that I prioritize data integrity and flexibility which is especially essential for this project's specifications. Moreover, my proficiency in @Data Entry, @Web Scraping, @Data Mining and related skills would enable me to develop a highly accurate model solution utilizing Excel for Task 2. Through meticulous calculation, I will recreate a typical week of DNA sample processing with the average time efficiency, number of samples processed/matched & the mean processing time. Assuredly, the “average” model will replicable by any user efficiently. Can we talk now? Waiting for your valuable reply! Regards, Ritika Kumari
£220 GBP dalam 7 hari
4.8 (118 ulasan)
6.1
6.1
Avatar Pengguna
Hey! I have gone through your description. I have done MPhil in statistics. I have expertise in statistical analysis. I have command on excel. I can provide you quality work that meets all of your requirements. I can do this job with full accuracy and on time. Looking forward to see your interest. Thank-you.
£30 GBP dalam 1 hari
5.0 (111 ulasan)
5.9
5.9
Avatar Pengguna
Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh
£200 GBP dalam 3 hari
4.7 (51 ulasan)
5.9
5.9
Avatar Pengguna
As an experienced Academic Writer with exceptional skills in Business Analysis, Excel, and Statistics, I am the ideal candidate to take on your Excel Operational Analytics project. My skills and expertise align perfectly with the tasks outlined. Over my many years of work, I've become adept at flowcharting complex processes like your DNA sample collection and processing operations for seamless replication by others. I find drafting relevant equations for each step of a process -- such as calculating the overall time in system -- intellectually fulfilling. Moreover, utilizing spreadsheets like Excel to construct models is not just something I'm competent in but have truly honed as part of my daily workflow. I understand the importance of accurately implementing every unit of measure, all while maintaining clarity, comprehensibility, and replicability. This is something that sets me apart from other candidates who may be technically skilled but lacking a background in academic writing and replication standards. Additionally, my skills extend beyond what is explicitly defined in the project as I am proficient in Python,R Programming, and Java—all of which could come into play during ad-hoc analyses that may help reduce the DNA processing time further.
£100 GBP dalam 5 hari
4.8 (37 ulasan)
5.7
5.7
Avatar Pengguna
Hi, I have gone through the Job details and am interested in taking it up. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
£150 GBP dalam 4 hari
5.0 (42 ulasan)
5.3
5.3
Avatar Pengguna
I am a seasoned MBA writer with over seven years of experience in various writing fields. I have completed thousands of projects, ensuring 100% accuracy and meeting client requirements. You can trust me to deliver plagiarism-free work within the agreed deadline while maintaining your privacy. I specialize in creating diverse content, from assignments and quizzes to business plans, sales and marketing plans, SEO articles, blogs, and more. Feel free to join the chat box and give me a try. I am dedicated to fulfilling and surpassing all your expectations, and I guarantee you won't be let down. I'm looking forward to hearing back from you. It's my portfolio link. https://www.freelancer.com/u/Stopsolution?w=f&ngsw-bypass=
£20 GBP dalam 1 hari
4.4 (66 ulasan)
5.3
5.3
Avatar Pengguna
Hi there, I have an M.B.A in Business and Finance, and more than 10 years of experience as a business consultant, I have helped clients take off their businesses and reach new heights by optimizing the strategy, research, analyzing their market and competitive position, and creating a clear and compelling business plan to articulate their opportunity. I can surely assist you in writing a business plan. While working on this, I will ensure to provide extensively researched content, which will specifically include an Executive Summary, a Business Overview, an effective Operations Plan, Market analysis and Cost Analysis, Product and Services description, Sales and Marketing strategies, a Competitive Analysis, Management Team, Financial Plan and estimated Projections. My top priority will be helping you with a high-quality write-up for this business plan. As a professional business strategist, carrying a decade of experience in the writing industry, I will be crafting a perfect plan for you that helps you focus on both short-term and long-term goals, making sure your ideas succeed. I have had the pleasure of working on several similar projects with multiple clients over different freelancing platforms; I can deliver quality work to tight deadlines. You can see an example of one of those projects in my portfolio. Feel free to engage me by sending a single text. Regards,
£201 GBP dalam 1 hari
4.9 (18 ulasan)
4.3
4.3
Avatar Pengguna
Hi Sara M., Good afternoon! My name is Jane an expert data analyst with skills including Statistics, Business Analysis, Excel, Data Processing and Data Analytics. I have over 5 years in tutoring data analysis and statistics. Having completed similar project, I am confident in my ability to deliver high-quality results for this project. I am eager to discuss further details and see how I can contribute to your team. I am happy to offer a free consultation and a 10% discount for first-time clients. Please contact me to discuss more regarding this project. Regards Jane
£150 GBP dalam 3 hari
5.0 (10 ulasan)
3.7
3.7
Avatar Pengguna
With my comprehensive understanding and astute knowledge in Business Analysis, I will construct an advanced simulation model for your Operational Analytics project using excel and @RISK with utmost precision. My excellent proficiency in handling large datasets, robust data analytics, deep statistical abilities, and mastery of Excel will prove advantageous at every stage of this project. Moreover, I am a strategic thinker who effortlessly connects the dots between different processes and create solutions to overcome operational challenges. By evaluating each parameter precisely using the provided information, I will determine suitable probability distributions for the simulation based on our average model. Running it over 10,000 iterations, I anticipate obtaining insights that will offer a comprehensive understanding into potential shortcomings in the current DNA sample processing system, their causes, and possible remedies. In summary, my project delivery approachencompasses ingenuity, precisionality, and strategic thinking which are crucial for this project.I guarantee rock-solid deliverables that you can confidently replicate and utilize in your future endeavors. Let's collaborate to nail this data-heavy mission!
£120 GBP dalam 1 hari
4.9 (10 ulasan)
3.9
3.9
Avatar Pengguna
I am an award-winning content and copywriter passionate about creating engaging and compelling blogs, articles, business and sales plans, marketing plans, feasibility studies, technical writing, creative writing, speech writing, online writing, etc. I've been privileged to work with people and businesses of all backgrounds. I aim to provide impactful, reader-friendly, and compelling content for your needs. With more than 4 years of experience in this field, I provided many top-notch solutions to clients according to their needs and requirements. it is my responsibility to provide you with plagiarism-free, error-free solutions which help in achieving good grades and a reputation in your batch. A strong vocabulary, attention to detail, clarity, and being open to changes/suggestions is what make me a good fit for this project. Here is my portfolio you can check my achievements: https://www.freelancer.com/u/QualityHub If your project is deleted, hit me with this link: https://www.freelancer.com/u/QualityHub I await your text.
£20 GBP dalam 1 hari
4.8 (17 ulasan)
3.7
3.7
Avatar Pengguna
Drawing upon my 15 years of hands-on experience in the industry, I can confidently say there's no challenge in the Excel realm that I cannot handle. My knowledge spans from advanced formulae, representing complex data visually to creating efficient flowcharts and simulations using VBA. Having worked on multiple Power BI projects with varied data sources including SQL server and Oracle, I possess a unique comprehension of business analytics and data processing. Finally, I would like to emphasize my emphasis on delivering results that are both actionable and reproducible. Being able to craft reports accessible to any reader, they can follow and recreate my results is something that comes naturally to me. My goal through my analysis is not just generating insights but enabling informed decision making which aligns perfectly with your project aims. Selecting me would prove instrumental in achieving your desired system efficiencies through robust queue modeling, profound scenario analysis and reliable ad-hoc analyses.
£135 GBP dalam 2 hari
5.0 (9 ulasan)
3.2
3.2
Avatar Pengguna
Hello, I am a Excel Expert. DM me so that I can help you. I will wait for your response. Regards, Sangamesh KS
£21 GBP dalam 1 hari
5.0 (16 ulasan)
3.0
3.0
Avatar Pengguna
Hello, Kindly consider initiating a CHAT to transform your aspirations into tangible reality, as I am eager to delve into the intricacies of your project and collaborate effectively to achieve your desired outcome. Here's what I offer:  Automation (Macro/VBA)  Financial Analysis  Formulas and Functions  Data Analysis (PivotTables, Charts)  Charts and Graphs  Reports and Dashboards  Data Entry and Management  Conditional Formatting  Tables Creation  Data Validation  Collaborative Work  Data Import/Export  Filtering and Sorting  Scenario Analysis  Solver Optimization The initial bid is flexible as we aim to understand your project fully. Let's work closely for exceptional results. Best regards, Tayyab Dastgir
£50 GBP dalam 1 hari
5.0 (5 ulasan)
2.9
2.9
Avatar Pengguna
you need: 1. a model for dna samples 2. by csi and individually right?
£250 GBP dalam 1 hari
4.9 (5 ulasan)
2.8
2.8
Avatar Pengguna
Affordable, Early Delivery. ★★★★★★★★★★★★★★I hold a Masters degree which gives me the requisite background to handle writing from various subjects. I am a highly committed person towards my work. You can rely on QualityXenter for quality and consistency in writing. We never violate copyright rules. I have vast amount of experience in this industry since I am working from 2015 as a professional writer. I provide many modifications till to get your satisfactions. I have access to enough journals to use in your research project. I always produce quality work at VERY LOW RATES so, don't worry if you have a low budget for your work, I will be very happy to make a new client like you. I am producing quality work for my clients including ARTICLE WRITING, REPORT WRITING, ESSAY WRITING, RESEARCH PAPERS, BUSINESS PLAN, TECHNICAL WRITING, MATLAB, THESIS, ACCOUNTING & FINANCE work ETC. Go through my profile link https://www.freelancer.com/u/qualityxenter
£30 GBP dalam 1 hari
5.0 (4 ulasan)
2.4
2.4
Avatar Pengguna
InstantQuality─── ⋆⋅☆⋅⋆ ── I am a specialized Master's degree holder equipped to tackle writing across various subjects. My commitment to work is unwavering, ensuring TOP RATED EXPERT delivers consistent and high-quality writing while strictly adhering to copyright regulations. With extensive experience in the industry since 2009, I am a seasoned professional. Client satisfaction is paramount, and I am open to multiple revisions until your contentment is achieved. Access to ample journals aids in comprehensive research projects. Despite low budget constraints, I take pride in offering quality work at very reasonable rates. Specializing in various writing tasks such as ARTICLE WRITING, REPORT WRITING, ESSAY WRITING, RESEARCH PAPERS, BUSINESS PLAN, TECHNICAL WRITING, MATLAB, THESIS, ACCOUNTING & FINANCE, etc. Best regards
£20 GBP dalam 1 hari
5.0 (1 ulasan)
1.7
1.7
Avatar Pengguna
Yes I have read your project and understood requirements but have some doubts. please message me so we can discuss in detail. i am ready to start work
£135 GBP dalam 7 hari
5.0 (1 ulasan)
1.0
1.0
Avatar Pengguna
Dear Sara M., I’ve read all of your requirements fully and I'm really interested in Excel Operational Analytics. I have rich experience in Data Analytics, Business Analysis, Excel, Data Processing and Statistics with over 9 years. I am always ready to discuss more detail this project with you and I can start working immediately. Looking forward to working with you soon. For the best result and a long term in the future. Regards, Mikael.
£20 GBP dalam 3 hari
0.0 (0 ulasan)
1.4
1.4
Avatar Pengguna
Hi there, I believe I can help you with this project as i have the experience with Excel, Statistics, Business Analysis, Data Analytics and Data Processing. here is my portfolio: https://www.freelancer.com/u/ayesha0124
£250 GBP dalam 9 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
As a seasoned professional I have worked with diverse range of client on projects involving Operation Research I and II, Supply Chain, Logistics optimization, Inventory Management, Staffing, Scheduling, Simulation and other optimization and Linear Programming related projects. I will assist you with following: Operation research I & II Dynamic Programming Monte Carlo Simulation Stochastic Models Queuing Models Linear programming (Non-Linear) Simplex method Duality and post-optimal analysis Transportation problems Dual simplex method Sensitivity analysis Decision tree Analysis Integer linear programming Goal Programming Game theory Queuing systems Network model Decision analysis Shortest path and Travelling Sales Person Assignment Problems Markov chain Inventory management Probabilistic OR and Queuing theory PERT/ CPM diagrams Time Series Analysis & Forecasting Supply Chain and Logistics
£150 GBP dalam 7 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera UNITED KINGDOM
Guildford, United Kingdom
0.0
0
Ahli sejak Apr 19, 2024

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.