Do some Excel Work

Completado Publicado Apr 28, 2014 Pagado a la entrega
Completado 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.

Entrada de datos Procesamiento de datos Excel

Nº del proyecto: #5869559

Sobre el proyecto

15 propuestas Proyecto remoto Activo Apr 28, 2014

Adjudicado a:

elqueabandona

Ready to start!........................................................................................................................................

$105 USD en 3 días
(335 comentarios)
7.5

15 freelancers están ofertando un promedio de $144 por este trabajo

zExcel

Hi, I'll be happy to help you with this project Please feel free to message me if you need to discuss any questions you might have prior to award

$105 USD en 1 día
(257 comentarios)
7.7
muzammil21

A proposal has not yet been provided

$210 USD en 30 días
(114 comentarios)
7.0
titukhan13

Dear Sir, My Maximum review is same for your project. I have done similar projects. Please See my work sample If you like then award me. My work will be accurate perfect in time. Waiting for your reply. Thanks

$40 USD en 2 días
(176 comentarios)
6.1
Aan12

La propuesta todavía no ha sido proveída

$105 USD en 3 días
(17 comentarios)
4.1
kevinorin

Good Morning I am interested in your project to complete some excel work. I am available to start working immediately and look forward to speaking with you further about this project. Thank You

$222 USD en 2 días
(1 comentario)
3.0
venkatbudarapu

Respected employer I have gone through your requirements, the work is which I would like to work all the time We will deliver 100% what exactly you need or you specified in the requirements and also we will flexibl Más

$147 USD en 3 días
(2 comentarios)
0.0
rikkarikz

Wala pang naibigay na panukala

$155 USD en 3 días
(0 comentarios)
0.0
manzoorlubna3

A proposal has not yet been provided

$222 USD en 30 días
(0 comentarios)
0.0
krajk030

A proposal has not yet been provided

$155 USD en 3 días
(0 comentarios)
0.0
bogy196

Propunerea nu a fost încă furnizată

$111 USD en 5 días
(0 comentarios)
0.0
imamachmad

I want to know what job you offer I nev worked at dhl supply chain for Unilever as a team project data analyst for 5 years and now I work in wilmar with as a data analyst for warehouse and obtaining an excel program I Más

$155 USD en 3 días
(0 comentarios)
0.0
talhanust

Dear Sir, The task seems pretty interesting. I have strong ability in accurately transferring data from different sources to Excel spreadsheets. I pay great attention to details and double check all entries to ensur Más

$111 USD en 3 días
(0 comentarios)
0.0
nghiaa7pro3

Đề xuất vẫn chưa được gửi

$155 USD en 3 días
(0 comentarios)
0.0
kappaldevkhatri

A proposal has not yet been provided

$155 USD en 3 días
(0 comentarios)
0.0