I am looking for someone that knows how to use excel spread sheets and can creat me some tables that will store data and update a page that will show statistics I have a excel spread sheet that has a number of cells. Each month i open a new tab on the footer of same sheet and give it a month name. I then add the data to the sheet. What im looking for is the following. On the very first tab of the spread sheet im looking for a reports page. this will list all the clients i have the telephone number and the prioduct they are on and the price they are paying. I want the sheet to update this main page if i change any data on any of the tabs for each of the month. When i add a new tab with a new month and add a new customer to that month i need it to add to the list of customers on the 1st page. I would also like a reports section that will show new customers that month customers on each package and what the proffit is made up of ie subscriptions new connections connection fees, routers and ip addresses.i would like the reports to be in the shape of a pie chart and may be some bar graphs. This is not a hard project for some one that knows what they are doing. I have attatched a file that we use at the moment. we would need all the calcuations to remain . but youmay need to change things for this to work correctly
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
excel