Extract Data from .SIM file using Excel Macro

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.

Skills: Excel, MySQL, Visual Basic

See more: macro to extract data from excel, how to extract data from excel without opening, extract data from multiple excel files into single file, excel vba get data from closed workbook, excel macro pull data from another workbook, excel extract data from multiple closed workbooks, excel vba import data from closed workbook, extract data from multiple cells of closed excel files, saving grid data xml file using extjs, data net web application excel macro, compare tables using excel macro, data oracle batch using excel vba, extract mdb text file using vb6, extract images pdf file using php, extract data xml file using 2008, combine text files using excel macro, extracting pdf data xml file using vbnet, data analysis interpretation using excel, extract data xml file using net, showing data excel internet explorer using excel macro

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

Project ID: #17237708

18 freelancers are bidding on average $152 for this job


Hello, I can help with you in your project Extract Data from .SIM file using Excel Macro. I have more than 5 years of experience in Excel, MySQL, Visual Basic. We have worked on several similar projects before! W More

$180 USD in 3 days
(260 Reviews)
$155 USD in 3 days
(326 Reviews)

Hello, I'm ready to work on "extract data from .sim file using excel macro" project. I have 5 years experience in Visual Basic, Excel, MySQL. 150 USD - proposed project budget, including coding and clean modern UI de More

$150 USD in 2 days
(117 Reviews)

Hello, My name is Chrys. As you can see from my profile, I have 17+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. From t More

$200 USD in 5 days
(73 Reviews)

Hi, I have experience of working on similar projects, I can help to develop a script to extract data from .SIM file to store in MySQL database. Please let me know about time when you would be available so we can dis More

$250 USD in 5 days
(78 Reviews)
$155 USD in 1 day
(67 Reviews)
$222 USD in 3 days
(41 Reviews)

Hello, I have completed similar projects at the past. But it is not easy to pull data from the SIM files, because the file has several sections, and I need to get through step by step how to make it. So it is not le More

$140 USD in 5 days
(21 Reviews)

1. Excel expert with extensive vba programming experience. I work extensively in macros daily for several different projects and can debug your extract. 2. I have worked for several years in excel and perform dai More

$155 USD in 3 days
(1 Review)

I have been programming in VBA for more than 20 years. The project can also be programmed in C# or VB.NET I will help you with your project, please contact me via chat to talk about your needs and project details More

$130 USD in 3 days
(10 Reviews)

Hello. I have good skills in Excel/VBA. I have read your project description carefully and i can do it. Contact me please. Thanks...............................................................

$155 USD in 3 days
(3 Reviews)

hi I am excel VBA expert......

$88 USD in 1 day
(3 Reviews)
$111 USD in 2 days
(1 Review)
$167 USD in 5 days
(0 Reviews)

Use parsing tools and Hex editor tools to extract data from files to be used for processing. Relevant Skills and Experience Worked as a coder for Assembly and C language

$155 USD in 3 days
(0 Reviews)

Hello, I am +5 years experienced developer I parsed many foremats before and I will finalize this in the least time with the best quality for good review from you as I am new on freelancer websitea

$111 USD in 3 days
(0 Reviews)
$155 USD in 3 days
(0 Reviews)
$55 USD in 3 days
(0 Reviews)