Extract Data from .SIM file using Excel Macro - 12/08/2018 12:15 EDT

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

Hi, I have a project where some data has been exported to a .SIM file from an Energy Modeling program. I need to have the .SIM file parsed and *some* of that data exported in a format that can easily be imported to a MySQL database table. I have sample .SIM files, an Excel spreadsheet with a macro that currently parses the .SIM file to populate cells in itself, and a macro to pull just the data needed that was started that doesn't work. I need an Excel macro expert to get this working.

The attached .zip file has the sample data - a couple of the folders contain .SIM files (use the Proposed Baseline Design files). I also attached a zipped Excel file (ES Database Template) that is the one that currently parses .SIM files to populate some of it's cells.. And lastly, I have attached a .txt file that is a first attempt at a standalone macro that parses the .SIM file for the data needed and exports. The .txt macro does not currently work, but starting at line 500 you can see the data that needs to be extracted. The client uses only Windows computers, so the macro has to work in Windows.

From the Proposed Baseline Design SIM files I need the following data:

Range("D16") = lightsInteriorMeterE

Range("D17") = lightsExteriorMeterE

Range("D18") = spaceHtgElecMeterE

Range("D19") = spaceHtgGasMeterG

Range("D20") = spaceHtgSteamMeterS

Range("D21") = spaceClgElecMeterE

Range("D22") = spaceClgCWMeterC

Range("D23") = pumpsMeterE

Range("D24") = heatRejMeterE

Range("D25") = fansIntVentMeterE

Range("D26") = hpSuppHeatMeterE

Range("D27") = shwElecMeterE

Range("D28") = shwGasMeterG

Range("D29") = shwSteamMeterS

Range("D30") = miscEquipElecMeterE

Range("D31") = miscEquipGasMeterG

Range("D32") = miscEquipSteamMeterS

Range("D33") = miscEquipCWMeterC

Range("D34") = refrigMeterE

Range("E40") = elecCost

Range("E41") = gasCost

Range("E42") = steamCost

Range("E43") = cwCost

Range("R32") = unmetClg

Range("R33") = unmetHtg

Of course those Range values aren't important - those depend on where you store the data pulled from the SIM file, but the data names tell you what data I need... and the sample text macro file has the parsing info for each data point pulled directly from the macro in the Database Template Excel file

Excel MySQL Visual Basic

Project ID: #17559783

About the project

9 proposals Remote project Active 5 years ago

Awarded to:

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$222 USD in 2 days
(780 Reviews)
8.6

9 freelancers are bidding on average $164 for this job

schoudhary1553

Hello, I have the good knowledge of Extract Data from .SIM file using Excel Macro. I have more than 5 years of experience in Excel, MySQL, Visual Basic. I have reviewed your job and can deliver you the job with 100 More

$200 USD in 3 days
(367 Reviews)
8.0
usmanhassan123

PhD in computer science and expert in Excel. I have over seven years of experience in Excel development.

$253 USD in 1 day
(82 Reviews)
6.2
archanaoswal

I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (AP More

$200 USD in 5 days
(91 Reviews)
6.0
vmadhavan15

am not a rnaomd bider.. Please ping me if you are intested with my proposal and share more detail.. thank you..

$250 USD in 3 days
(28 Reviews)
5.0
RemonRamzy04

Hello, sir! (First Bidder to offer this) I hope I will be awarded from you. ************I agree for any price you will set ** You can test me over chat before you award me! give it a try over chat before you award More

$30 USD in 3 days
(17 Reviews)
4.3
engineer131

Hello I am Excel /python expert and have rich experience in Excel processing using python , VBA I can help you with good result and work for you as long term Just waiting for you reply. Thanks

$155 USD in 3 days
(2 Reviews)
1.8