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.
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!
We have worked on 350+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion.
I can assure the 100% job satisfaction.
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 the first look at the files, I think that the best way to extract the desired data is via Reg. expressions. Please contact me to further discuss the details.
Looking forward to hear from you,
Kind regards,
Chrys
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 discuss further.
Please see below for few similar data extraction related projects I have completed successfully in past:
Crawlers/Extractors:
PHP Screen scraper to post to MySQL DB - https://www.freelancer.com/projects/PHP/PHP-Screen-scraper-post-MySQL/
PHP crawler - https://www.freelancer.com/projects/PHP-Software-Architecture/PHP-crawler.6621450/
PHP Scraper Script - https://www.freelancer.com/projects/PHP-Javascript/PHP-Scraper-Script/
Generic Deals Scrapping Project - https://www.freelancer.com/projects/PHP-Website-Design/Generic-Deals-Scrapping-Project/
Web Scraper - https://www.freelancer.com/projects/PHP/Web-Scraper.4470619/
Scrape data from web site - https://www.freelancer.com/projects/PHP-Perl/Scrape-data-from-web-site/
Dealextreme scraping tool - https://www.freelancer.com/projects/PHP-Joomla/Dealextreme-scraping-tool/
Ebay Screen scraping - https://www.freelancer.com/projects/Web-Scraping/Ebay-Screen-scraping/
Hello.
I have good skills in Excel/VBA.
I have read your project description carefully and i can do it.
Contact me please.
Thanks...............................................................
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 let me say -that- easy.
Of course it is doable. But I just cannot decrease the price.
Best Regards,
Serdar Yalcin
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.
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 daily work using vba, user forms, pivot tables, formulas, etc.
3. I would start by committing to 3 days for completion.
4. I have an extensive background in Excel. I would love to know more about your project.
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
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