Custom Excel Spreadsheet

$100-300 USD

Geschlossen

Veröffentlicht

vor mehr als 18 Jahren

$100-300 USD

Bezahlt bei Lieferung

I have a spreadsheet attached for your review. I have one sheet called [login to view URL] 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.

Data Processing

Windows Desktop

Projekt-ID: 31676

Über das Projekt

14 Vorschläge

Remote Projekt

Aktiv vor 17 Jahren

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

14 Freelancer bieten im Durchschnitt $205 USD für diesen Auftrag

@momleetech

We can do it.

$300 USD in 15 Tagen

5,0

(11 Bewertungen)

4,6

@vbgata

Hi plz see PMB

$100 USD in 1 Tag

5,0

(1 Bewertung)

2,2

@ugumugu

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

$292 USD in 7 Tagen

5,0

(1 Bewertung)

1,8

@kmohan1962

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

$100 USD in 4 Tagen

4,5

(2 Bewertungen)

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 in 5 Tagen

0,0

(0 Bewertungen)

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 in 20 Tagen

0,0

(0 Bewertungen)

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 in 10 Tagen

0,0

(0 Bewertungen)

0,0

@superbrain

I can do this project for you.

$300 USD in 10 Tagen

0,0

(0 Bewertungen)

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, MS-Access), Crystal Reports, XML, HTML/DHTML, Java Script, J2EE etc. Our very skilled database administrators have a wide experience with most databases’ types and have completed a lot of similar projects. Please tell us more details, provide us with example and we will give you our firm proposal and estimation. We are always eager to offer the perfect solution to your needs. We are a cooperation oriented company and provide professional and cost-effective solutions for your project. You may ask any questions/queries you have. We are looking forward to providing you the best services. Full payment on 100% client Satisfaction! No advance payment required. Looking forward to working with you. Warm Regards Subbu – CreativeExcellence team.

$175 USD in 7 Tagen

0,0

(0 Bewertungen)

0,0

@manisharajesh

within 7 days.

$250 USD in 7 Tagen

0,0

(0 Bewertungen)

0,0

@amzacharia

I will do it all in Excel sheet

$200 USD in 7 Tagen

0,0

(0 Bewertungen)

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 think we can deliver you the best. We believe in accuracy and quality of work. Thank you for your time. regards, integrity_projects.

$100 USD in 7 Tagen