- I need a spreadsheet to keep track of my finances from app sales (I develop iPhone apps)

- The spreadsheet must be made in Excel and work on a Mac

- Any freelancer who wishes to take on this project should therefore be familiar with the sales report generated by iTunes (I will be providing copies to test with etc)

- I need to be able to update the spreadsheet every week with my latest sales report and therefore all formulae need to be dynamic so that all figures and graphs change as figures are added

Main Sheet

- The main sheet will only be used for full sales report data

- Each week I will be importing a new sales report so all formulae on other sheets must take account of this

Sheet 1

- This sheet must list the profit made from each app based on the sales reports

- This should be in rows with one row listing all the app names and the others listing the profit made for each one

- I have numerous apps so the profit report must recognise the name of the app and list the appropriate profit for each one

- The profit report must also be able to automatically recognise new apps. So when I add a new app and it's name comes up in a sales report, it automatically appears in the profit report

- There must be different rows for different currencies and therefore the formulae need to be able to distinguish between different currencies (the report will specify the number of apps sold in different currencies)

- Beneath these rows must then be a total where the total number of apps sold and the total amount made in each currency must be listed (if new apps are added though they must appear in rows above the total)

Sheet 2

- Sheet two will have graphs which outline the average weekly sales in a number of ways

- One line graph must show the average weekly sales year-on-year: each app must be represented as a different colour, when new apps are added they must automatically appear on the graph. The idea is that time is on the x-axis with the number downloaded on the y-axis. Therefore I can see how the download numbers change over the course of a year. Obviously as I import weekly sales reports, the chart needs to update to take account of the new weeks added

- Each app must also have its own bar chart which shows the average weekly sales when the app is sold at different prices (for example, one app was sold at both &pound;0.59 and &pound;1.19. This bar chart must therefore find the average number sold for each price in a week.)

- Another bar chart must also show the number of each app which have been sold to different countries (for example: Japan: App 1 - 3, App 2 - 10, South Africa App 1 - 4, App 2 - 8 etc)

- All the above charts must ignore updates (product type identifier: 7) but should include free apps

Evner: Dataindførsel, Databehandling, Excel, Salg

Om arbejdsgiveren:
( 20 bedømmelser ) Stanford, United States

Projekt ID: #611060

## Tildelt til:

cdumitru

Hello, please see PMB. Regards CDumitru

\$30 USD på 1 dag
(5 bedømmelser)
3.2

## 12 freelancere byder i gennemsnit \$136 på dette job

dev3dworx

Kindly check PMB for details.

\$575 USD in 30 dage
(19 bedømmelser)
4.7
amrutabhosale

I know excel formulas well. Also have handled a few cells reports in excel. Please PM me further details. Thank you

\$30 USD in 2 dage
(0 bedømmelser)
0.0
dmaity

\$30 USD in 3 dage
(0 bedømmelser)
0.0
husasd

i am very hardworker and good date entry operator.

\$230 USD in 7 dage
(0 bedømmelser)
0.0
Eranga76

can provide quality report

\$30 USD in 10 dage
(0 bedømmelser)
0.0
prowesstechinc1

\$175 USD in 5 dage
(0 bedømmelser)
0.0
iburakov

\$120 USD in 3 dage
(0 bedømmelser)
0.0
Priti16

\$30 USD in 5 dage
(0 bedømmelser)
0.0
surens007

I have more than 5 yrs experience in excel spreadsheet, various reports, and sales reports. i think, i done this work within 7 days

\$130 USD in 7 dage
(0 bedømmelser)
0.0
Moorthigoodboynn

I will complete the project in 2 days

\$100 USD in 2 dage
(0 bedømmelser)
0.0
quaribul

I am working in Accounts job in a superstore. I hope its relevant to work and I believe I can do your task as you want.

\$150 USD in 7 dage
(0 bedømmelser)
0.0