Find Jobs
Hire Freelancers

Extract Data from .SIM file using Excel Macro

$30-250 USD

Cancelled
Posted almost 6 years ago

$30-250 USD

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.
Project ID: 17237708

About the project

16 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average $155 USD for this job
User Avatar
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.
$180 USD in 3 days
4.9 (526 reviews)
8.4
8.4
User Avatar
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
$200 USD in 5 days
4.9 (77 reviews)
6.6
6.6
User Avatar
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/
$250 USD in 5 days
4.6 (81 reviews)
7.0
7.0
User Avatar
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
4.8 (109 reviews)
6.1
6.1
User Avatar
hi I am excel VBA expert......
$88 USD in 1 day
4.9 (50 reviews)
5.1
5.1
User Avatar
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
$140 USD in 5 days
5.0 (25 reviews)
4.6
4.6
User Avatar
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.
$130 USD in 3 days
5.0 (15 reviews)
4.1
4.1
User Avatar
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.
$155 USD in 3 days
5.0 (1 review)
3.8
3.8
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Omaha, United States
5.0
4
Payment method verified
Member since Feb 16, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.