Do some Excel Work
$30-250 USD
Pagado a la entrega
The objective of this project is to replicate 31 pre-supplied and pre-configured spreadsheets 24 times, producing a total of 744 spreadsheets, and then make slight alterations to each of the spreadsheets.
Each spreadsheet contains a list of 28 items that a restaurant would typically offer its customers, along with two columns of revenue data that represents a single day’s income for the sale of those products.
The “ACTUAL” column depicts the revenue typically obtained without the customer using a coupon.
The “IMM” column represents the revenue associated with customers using coupons.
The “QTY” column is the quantity of each of the 28 products that were sold each day.
The “Price” is the price for which those products were sold.
Changing the number in the QTY cell will automatically change the ACTUAL and IMM summation values.
The first objective of this project, is to replicate the 31 pre-configured spreadsheets 24 times, while keeping the spreadsheet naming convention sequential for each spreadsheet. In other words, the number in the name of the spreadsheet will reflect the number of the actual replicated spreadsheet.
Next, the QTY values in the spreadsheets need to be altered slightly. This is done by changing each of the QTY values up or down. ie; Change Beer QTY sold on each spreadsheet from, for example 55 to 45, or 60, or 53, or 49, etc, to show that the quantity of the product sold, varied each day. Then repeat this process for each of the 28 products on that same spreadsheet. Then, repeat this overall process for all spreadsheets.
The overall revenue numbers in the first 12 times, needs to be 20% less than the revenue numbers provided in the supplied spreadsheets.
The overall revenue numbers in the second 12 times, needs to be 20% less than the first 12 times
Lastly, the spreadsheets QTY and Price columns should be removed, as well as the macros in the ACTUAL and IMM columns, while maintaining the numeric values presented in the cells. The QTY and Price columns were supplied
The final deliverable would represent simulated revenue obtainment, received for those products over the period of a year.
We are also looking to award this project to the Freelancer "elqueabandona" as follow on work from the previous project we awarded him.
This project price has set at $105.
Nº del proyecto: #5869638
Sobre el proyecto
23 freelancers están ofertando un promedio de $134 por este trabajo
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Más
Yes I can, and I will help you if you pick me for your project. Check my profile, see my reviews and award me now. Thanks, Tom
I will surely complete your work within specified days and amount. please give me priority to give this work I will definitely give you satisfied completion of this work. we also can establish long term plan bond if re Más
i'm working as a data entry operator in my company. so this task is easy for me. i can finish it very soon.
My excel is very good. I will do this task with 100% accuracy. I can start right now. I will satisfy you if you will give me opportunity to work for you.
Hello miatama2005, I'm skilled Excel specialist with a lot of experiences with data edit and Excel automation. If you send me your file I can better estimate the time necessary for edits you want to do in the file. Más
Dear Miatama2005, I would like to receive this projekt. I am reliable and very good in Excel. I am looking forward hearing from you. Ildiko
Hi, If i find this job, i do it Confidently & within short time, i m so much experenced for this types of job, i think i m the perfect match for this job. thanks Kaium
Hi thank you for posting this kind of job and i am able to do this type of work so please give me this kind of opportunity.
My 8+ experience in advance excel and financial modelling will help me to work on this project in the desired manner and to complete it with in time frame
I worked at rigid deadline jobs until 3 years ago. I like these types of competitions. If you were give the job for me i will pleased to work.