![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Create an Excel Spreadsheet or Database Program
- or -
Post a project like this3233
$$
- Posted:
- Proposals: 17
- Remote
- #874883
- Awarded
66526698968666003486706848746310322091015125964756529922761931024343963451
![Simon P.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/add6ce030a9b86d7954c8944708b94c7_70x70.jpg)
![Barkat M.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/41141384cb7b175053a5f982977af431_70x70.jpg)
![Eldon C.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/2c335c2b6823a6b700d2717700a96548_70x70.jpg)
![Pranjal N.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/564d122842f89ad600153013bfb2126e_70x70.jpg)
![ExcelStudioWorks A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/f3f8612cc541cf2525f45f1385c8e053_70x70.jpg)
Description
Experience Level: Intermediate
I currently run a vending company that has 9 routes and services approximately 1700 machines. All 9 routes are broken down into Master Lists. After the money is counted, I get a summary sheet called the Money Room Balance.
I would like to be able to import this data daily to update a database with all the machines. I want to be able to see each machines sales, route sales, average daily sales, etc.
Using the sales data, I would like to be able to see a table listing the machines by route with their average daily sales. I also want to see the days since last service with a projection of the income expected.
I would like to be able to import this data daily to update a database with all the machines. I want to be able to see each machines sales, route sales, average daily sales, etc.
Using the sales data, I would like to be able to see a table listing the machines by route with their average daily sales. I also want to see the days since last service with a projection of the income expected.
![Christopher S.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/68a0384ce545ca4915b82a6f09637bbb_150x150.jpg)
Christopher S.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
29 Apr 2018
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies