
Fechado
Publicado
Pago na entrega
I have a cloud based Excel Workbood that is to serve as an ordering tool for various food subcategories. There are 39 lines in total. The structure and data is done, but I need help with some of the formulas to predict orders.I want to get it to a point where total weekly sales can be input, and the output is orders in the frequency required (daily for most). The tolerence for waste is 7% of category revenue. The formulas created should consider shelf life, prior sales (which will be the average of the last 4 weeks), cateogy revenue, sales velocity etc.
ID do Projeto: 40148951
17 propostas
Projeto remoto
Ativo há 23 dias
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
17 freelancers estão ofertando em média $24 AUD for esse trabalho

As a long-standing Full Stack Developer with a particular expertise in Excel, I believe I can bring immense value to your project. My 7 years' experience has seen me navigate through complex Excel formulas, VBA coding, data organization, and macros - all skills indubitably vital in crafting the required order predictions for your cloud-based ordering tool. Furthermore, my experience extends into businesses data analysis to provide tailored and effective solutions incorporating shrewd considerations like average sales in the last four weeks, sales velocity, category revenue etc just like your project requires. I tackle tasks with meticulous attention to detail and my vast repertoire of skills enables me to approach projects from various angles; this means I can design and build workbooks that cater individually to each of the 39 food subcategories while sticking to your desired weekly inputs. My job is not done until you're satisfied and I guarantee no vague demands or guesswork. If given the opportunity to work with you, I'll be empathetically oriented towards you as an employer ensuring quick turnaround times without compromising quality or accuracy.
$80 AUD em 2 dias
8,6
8,6

Hi, I am a skilled Excel professional from Vietnam with 25+ years of experience. I can help you with formulas and calculations. I am currently available and ready to commence work immediately. How can I help you with your Excel task? Best regards, Duong
$30 AUD em 3 dias
6,9
6,9

Hello, I can help refine your Excel workbook by designing clear, practical formulas that translate weekly sales inputs into accurate order quantities across your food subcategories. I’m comfortable working with inventory and sales models that factor in sales velocity, prior 4-week averages, shelf life, category revenue, and a defined waste tolerance. I’d be happy to review the workbook structure and discuss how you currently calculate sales and frequency so we can finalize formulas that meet your goals. Thank you!
$10 AUD em 2 dias
5,2
5,2

As an longtime Excel specialist, I bring not only a broad range of skills to the table, but also a deep understanding of how to design and implement effective tools for data analysis and management. My expertise in Advanced Excel Formulas, Pivot Tables and Data Analysis, can take your cloud-based ordering tool to the next level of functionality. My proficiency in VLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS paired with my analytical mindset enable me to create intricate formulas that are tailored specifically for your requirements. Furthermore, my past experience with inventory management, data forecasting and financial modelling are all directly applicable to this project - you can rely on me to create formulas that address each unique aspect such as shelf life and prior sales trends. In addition to my technical expertise, I'm incredibly attentive to detail and extremely precise in my work. This will ensure accurate order predictions that factor in all relevant parameters as well as the 7% waste tolerance. When you hire me, you’re not only getting an expert who delivers on-time and within budget - you’re getting a partner who wants to make your life easier by simplifying complex business challenges through strategic data solutions. Let's set up a call so we can discuss your project further and design precise solutions together!
$10 AUD em 1 dia
4,4
4,4

Hello there,, I have advanced experience in Data Mining, Statistics, Statistical Analysis and Data Science. With my vast background in data analysis and management, I am confident in my ability to handle your categorical data project effectively and efficiently. I have extensive experience in collecting, cleaning, analyzing, and visualizing data using Python programming, an invaluable asset for a project of this nature. Additionally, I am well-versed with CRISP-DM framework and adept at identifying patterns within datasets Choosing me means benefitting from not only my expertise but also my personal approach to projects. I understand that each task is unique, requiring tailored skills, and so I'm willing to go the extra mile to provide you with results that meet and exceed your expectations. Let's join forces in this project as our combined strengths will surely produce a result that's efficient, elegant and insightful! Let's not waste any more time! Together, we can mine this data efficiently and answer the questions to achieve your goals. Best Regards, Thanks
$10 AUD em 1 dia
4,5
4,5

Hello there, With extensive experience in statistical and predictive analytics, My proficiency in SPSS combined with my programming skills in Python will not only ensure an effective data analysis but also allow for flexibility and automation, optimizing efficiency throughout the process. Throughout my career, I have consistently proven my problem-solving mindset transforming complex datasets into clear and actionable insights that clients can use to drive their business forward. Data cleaning and transformation is an often-overlooked area of importance; however, it's where precise analysis begins. My vast experience in this area ensures thorough sorting of your data for accurate analysis - leaving no stone unturned. Lastly, I recognize that clear communication is vital to successful project completion. I assure you of my commitment in communicating regularly and effectively throughout this project, leaving no room for ambiguities. Trusting me with this project will not just avail you of a qualified individual but also someone who is dedicated in leveraging their knowledge and experience for unparalleled client satisfaction.
$10 AUD em 1 dia
3,5
3,5

Hello there, As an experienced researcher and data scientist, data analyst, my qualitative analysis skills perfectly align with your job requirements. My profound knowledge of Python and R Studio guarantees fast learning and adaptation to new tools. Moreover, my advanced skills in Excel make me highly competent in handling large datasets efficiently—making me proficient in extracting the best insights from your transcripts. I fully comprehend the importance of working papers and meticulously preparing financial statements, especially within strict timelines. my sharp analytical skills and extensive knowledge of excel ensure that I leave no stone unturned in making sure every detail is covered under evaluation. My passion for quality, originality and meeting deadlines makes me an excellent choice for this project. I cannot wait to prove my extensive skills to you through providing actionable insights that will help guide your decision making regarding domestic charter flights. Best Regards
$10 AUD em 1 dia
3,5
3,5

Greetings, I can improve your Excel ordering tool by building accurate, easy to maintain formulas that convert weekly sales into daily order quantities. The logic will account for sales history, shelf life, sales speed, and your 7% waste target. I focus on clean formulas and smooth performance. Best regards,
$25 AUD em 3 dias
3,0
3,0

I have reviewed the job description and am available to start immediately. Based on my experience with similar projects, I can guarantee high-quality results. I’m also happy to offer a 10% discount for this project. Please feel free to contact me so we can discuss the details and get started.
$20 AUD em 1 dia
3,0
3,0

Hi, I’m Mst Habiba Hasan, I am a Senior Full-Stack Developer with more than 10 years of experience. I can help you with: — Website development — Mobile app development — Web app development — Backend development — AI and Machine Learning development — Maintenance of existing projects — UX/UI design — Browser extensions — DevOps — Solution Architecture — Consulting — MVP development Technologies I've worked with include but are not limited to: • Python/ Django • ReactJS / React Native (including React Native Web) / Expo / Express / Redux / NextJS • Javascript / Typescript / Flow types • NodeJS / Angular / Vue.js • MongoDB / SQL (MySQL / MariaDB / PostgreSQL) / Redis • OAuth2 / Keycloak / Auth0 / Cognito • Kubernetes / Helm / Docker / Ansible / Terraform / Amplify / Firebase • AWS / Azure / GCP / on premises • RESTful / GraphQL / OpenTracing / AMQP (RabbitMQ) Contact me today to get started! I’m excited to collaborate and bring your vision to life. Best regards, Mst Habiba Hasan
$20 AUD em 1 dia
0,0
0,0

Helensvale, Australia
Método de pagamento verificado
Membro desde jun. 20, 2019
$30-250 AUD
$10-30 AUD
$30-250 AUD
$30-250 USD
$10-30 AUD
₹12500-37500 INR
$20-30 USD
₹100-400 INR / hora
₹100-400 INR / hora
£10-15 GBP / hora
£10-15 GBP / hora
₹100-400 INR / hora
₹1500-12500 INR
$15-25 USD / hora
$1500-3000 USD
₹12500-37500 INR
€30-250 EUR
₹1500-12500 INR
₹12500-37500 INR
₹600-1500 INR
$1500-3000 USD
$30-250 USD
$15-25 USD / hora
₹750-1250 INR / hora
₹1500-12500 INR