Find Jobs
Hire Freelancers

Extract Data from .SIM file using Excel Macro

$30-250 USD

Abgesagt
Veröffentlicht vor fast 6 Jahren

$30-250 USD

Bezahlt bei Lieferung
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.
Projekt-ID: 17237708

Über das Projekt

16 Vorschläge
Remote Projekt
Aktiv vor 6 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
16 Freelancer bieten im Durchschnitt $155 USD für diesen Auftrag
Avatar des Nutzers
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 Tagen
4,9 (526 Bewertungen)
8,4
8,4
Avatar des Nutzers
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 Tagen
4,9 (77 Bewertungen)
6,6
6,6
Avatar des Nutzers
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 Tagen
4,6 (81 Bewertungen)
7,0
7,0
Avatar des Nutzers
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 Tagen
4,8 (109 Bewertungen)
6,1
6,1
Avatar des Nutzers
hi I am excel VBA expert......
$88 USD in 1 Tag
4,9 (50 Bewertungen)
5,1
5,1
Avatar des Nutzers
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 Tagen
5,0 (25 Bewertungen)
4,6
4,6
Avatar des Nutzers
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 Tagen
5,0 (15 Bewertungen)
4,1
4,1
Avatar des Nutzers
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 Tagen
5,0 (1 Bewertung)
3,8
3,8
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED STATES
Omaha, United States
5,0
4
Zahlungsmethode verifiziert
Mitglied seit Feb. 16, 2016

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.