Custom Excel Spreadsheet

CLOSED
Bids
16
Avg Bid (USD)
$210
Project Budget (USD)
$100 - $300

Project Description:
I have a spreadsheet attached for your review.
I have one sheet called xls.Building 1. I do a web query to obtain this data daily in 15 min. intervals. I would like the query'd data to be stored into MS SQL if possible. Then, I would like a new sheet with some drop down style menus to allow me to select a date range. Say 10/1/2005 to 10/31/2005. Then be able to select get all buildings or selected buildings data. A macro would query the db and populate all the fields on my other sheets automatically. The query would need to take the difference between the first value on 10/1 and the last value on 10/31. Once the fields are populated. I would like another function to manually enter the cost for Energy (say .05 Cents per kwh)and generate an Invoice for each building. The attached spreadsheet only has data for Building 1, but there would be a similar sheet for all buildings or preferrably a query to MS SQL.

Skills required:
Data Processing, Windows Desktop
Additional Files: Utility Spreadsheet1.xls
Hire wilckent
Project posted by:
wilckent United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.