Đã Đóng

Custom Excel Spreadsheet

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.

Kỹ năng: Xử lí dữ liệu, Màn hình Windows

Xem thêm: sql get date, spreadsheet on web, range query, min range, min cost, me excel, has attached, first energy, excel energy, new excel, say, macro excel, macro + excel, invoice processing, excel to sql, excel to my sql, excel function, do excel, d custom, d buildings, sql stored function, populate excel spreadsheet spreadsheet, kwh spreadsheet, range macro excel, custom review

Về Bên Thuê:
( 0 nhận xét ) Castle Rock, United States

Mã Dự Án: #31676

16 freelancer đang chào giá trung bình $210 cho công việc này

Iwin

Hi I am vast in Office automation and Have done several such projects. Although I am new to [url removed, login to view] I have been using [url removed, login to view] to for a while now and I have such jobs there please look up my profile on ren Thêm

$300 USD trong 20 ngày
(32 Đánh Giá)
5.2
momleetech

We can do it.

$300 USD trong 15 ngày
(11 Đánh Giá)
4.6
vbgata

Hi plz see PMB

$100 USD trong 1 ngày
(1 Đánh Giá)
2.2
ugumugu

Hi It will be my great plessure to work for you Thanks

$292 USD trong 7 ngày
(1 Đánh Giá)
1.8
kmohan1962

It'll be done by VB macro & Cell referencing in excel itself.

$100 USD trong 4 ngày
(2 Đánh Giá)
0.7
VerveSoft

Could you give us more details about the project. We'll ensure that you get the best of service from us.

$100 USD trong 5 ngày
(0 Đánh Giá)
0.0
efprog

I can do it, see PMB. Best regards, Dmitry Dmitriev

$200 USD trong 10 ngày
(0 Đánh Giá)
0.0
SkySoft

We will doing all that you want (and more... :-))). Quickly, Professional, Quality - our answer you and your organization. We work more than 10 years.. There are questions? Examples of jobs http://portfolio.pixy-tix Thêm

$300 USD trong 14 ngày
(0 Đánh Giá)
0.0
egero1

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.

$150 USD trong 20 ngày
(0 Đánh Giá)
0.0
jvl2005

Could you give us more details about the project. We'll ensure that you get the best of service from us.

$200 USD trong 10 ngày
(0 Đánh Giá)
0.0
enggdatasoft

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

$300 USD trong 15 ngày
(0 Đánh Giá)
0.0
superbrain

I can do this project for you.

$300 USD trong 10 ngày
(0 Đánh Giá)
0.0
Creative100

We are a software development company based at India having 4+ years of experience in developing web site as well as desktop applications. We especialize in Microsoft Technologies (ASP.NET, VB.NET, VB, ASP, SQL Server, Thêm

$175 USD trong 7 ngày
(0 Đánh Giá)
0.0
manisharajesh

within 7 days.

$250 USD trong 7 ngày
(0 Đánh Giá)
0.0
amzacharia

I will do it all in Excel sheet

$200 USD trong 7 ngày
(0 Đánh Giá)
0.0
Integritypro7

Hi, thank you for the opportunity to bid on this project. We are and indian company and have lots of experience in handling various web based research projects and have served few US clients.. With our experience we t Thêm

$100 USD trong 7 ngày
(0 Đánh Giá)
0.0