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.
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
* OM SAI RAM *
Respected Sir/Mam,
I have read the project completely and I have understood my responsibilities (If awarded) clearly.
To tell more about myself, I am dedicated and sincere in working on the projects awarded to me here. I can understand the urgency of the employers and work to finish the project in time.
Moreover, As you can see my profile, I am quite a new freelancer. I love to keep my reputation up to the mark.
If you wish to award the project to me trusting my abilities, you are always welcome to contact me anytime of the day. Let us have a chat on the project details before I take the responsibilities, As this will help me understand the project clearly. So that We won't be in a situation where our time won't be wasted later.
Lastly, I would like to tell that I stand by my words and I assure you that your expectations will be satisfied completely by my work. You will be happy with my work at the end.
As a request, I ask you kindly to offer me this project's responsibilities and pave me a path to stand out of the crowd in Freelancer.
Thanks in advance.
With regards,
SathyaNarayana Singh. J.
I'm able to get your work done 100% as requirements. We will firstly talk together to let you understand my solution and then making your hiring decision.
Respected Concern!
Please try me and get your maximum satisfaction. I am sure that you will try me again if you give me this chance to prove and honor my words.
Warm regards,
Hello Sir,
I am interested in your project. I assure you, my typing will be 100% error free & correctly written...
No word will be missed from original copy... My work will be proper and timely supplied...
Let me know if i get chance...
Thanks,
Ashique
Hello..
My name is mukhlis and i can work with excel formula and data entry.
I hope i can get this job.
I f you want, you can send me a data sample and the instruction. i will work on it and send the result to you. you can review my work and decide to award me with this job or not.
thank you
Mukhlis Rambe
I love working in Excel and I am doing this almost daily, so I do think I am the perfect one for this job. I may not have yet reviews, but you'll be very pleased with the result.
I have a lot of spare time and i spend most of this on the internet.
I have a fast web connection 100mbs which will help to ensure that i am available 100% of the time
I have a high attention to detail and a good work ethic.
I have done work like this in the past and an example can be seen in my portfolio
Lastly, I am fast and proficient at any given task i undertake
I am an individual, new to freelancer.com and freelancing, but I am very experienced in the Microsoft technologies with over 10 years of experience. English is my first language and I am currently living in Indianapolis, IN.
Currently I am a member of Microsoft’s Bizspark Entrepreneur Program looking to build a consulting/development company and team. I am also a past Microsoft Solution Provider. I have a through knowledge of VB.NET, Visual Basic 6.0, C#, Microsoft Access, VBA and SQL Server. I have used VBA in MS Excel, MS Word and MS Access and used Visual Basic as the shell. .
Most of my work has been in a corporate environment under non-disclosure-agreements. My freelancer.com portfolio has samples of my independent work. As a Bizspark Entrepreneur I have access through the Microsoft Developer Network to all of the latest tools, technologies and extensive support. If selected I will work diligently to insure our success. Please contact me for further info.
Thank You
Otha Northington
i am thinking of using a reference method wherein , when one spreadsheet is updated, the rest will also be updated in consideration of the revenue adjustments for some of the files. In just a click of the file, it will be updated as per the updated inventory/sale count.
We can use a macro for the summary part wherein the values only will be presented.
