I have a spreadsheet attached for your review.
I have one sheet called [url removed, login to view] 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.
16 freelancers are bidding on average $210 for this job
I have worked extensively with Excel Automation, MS SQL, ASP. I work as a software developer for a national compnay, but this is my first freelance project.
Dear Sir, Your budget seems to be low but as we can do the work professionaly so we would like to do the [url removed, login to view] are data specialist so we are the right provider for you . Thanks