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

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

Skills: Excel, MySQL, Visual Basic

See more: saving grid data xml file using extjs, data net web application excel macro, compare tables using excel macro, edt time, 12:30 am edt, edt to gmt, 10 am edt, 12:30 pm edt to est, 12:30 edt to est, edt to utc, 12:30 pm edt to ist, microsoft excel, methods extract data xml file net, extract data xml file posted web, extract data mat file visual, extract data xml file, vba extract data closed file, extract data xml file using 2008, extract data xml file using net, showing data excel internet explorer using excel macro

About the Employer:
( 3 reviews ) Omaha, United States

Project ID: #17559783

Awarded to:


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 and have been featured by the freelancer community ( More

$222 USD in 2 days
(608 Reviews)

12 freelancers are bidding on average $152 for this job


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
(270 Reviews)

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

$253 USD in 1 day
(37 Reviews)

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
(60 Reviews)

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
(20 Reviews)

How are you,sir? I am quite interested in your project - 'Extract Data from .SIM file using Excel Macro - 12/08/2018 12:15 EDT'. :) I am a ultimate software developer who has rich experience in this field. If you conta More

$155 USD in 2 days
(8 Reviews)

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
(3 Reviews)

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)
$30 USD in 3 days
(1 Review)

Hi, I am VBA Developer...Expertised in VBA Macros & Web Scraping I can Scrape Any Website..either static or dynamic also Experianced in Wordpress Ecommerce Stores & Office Automation tools Thankyou

$45 USD in 1 day
(0 Reviews)

hi,dear. We understand your proposals and I am very interested in this job - 'Extract Data from .SIM file using Excel Macro - 12/08/2018 12:15 EDT'. We are senior software developers and I am able to perform this task More

$155 USD in 10 days
(0 Reviews)
$133 USD in 1 day
(0 Reviews)