Find Jobs
Hire Freelancers

Extract Data from .SIM file using Excel Macro

$30-250 USD

Dibatalkan
Dibuat hampir 6 tahun yang lalu

$30-250 USD

Dibayar ketika dikirim
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.
ID Proyek: 17237708

Tentang proyek

16 proposal
Proyek remot
Aktif 6 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
16 freelancer menawar dengan rata-rata $155 USD untuk pekerjaan ini
Avatar Pengguna
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 dalam 3 hari
4,9 (526 ulasan)
8,4
8,4
Avatar Pengguna
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 dalam 5 hari
4,9 (77 ulasan)
6,6
6,6
Avatar Pengguna
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 dalam 5 hari
4,6 (81 ulasan)
7,0
7,0
Avatar Pengguna
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 dalam 3 hari
4,8 (109 ulasan)
6,1
6,1
Avatar Pengguna
hi I am excel VBA expert......
$88 USD dalam 1 hari
4,9 (50 ulasan)
5,1
5,1
Avatar Pengguna
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 dalam 5 hari
5,0 (25 ulasan)
4,6
4,6
Avatar Pengguna
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 dalam 3 hari
5,0 (15 ulasan)
4,1
4,1
Avatar Pengguna
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 dalam 3 hari
5,0 (1 ulasan)
3,8
3,8
Avatar Pengguna
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 dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 3 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED STATES
Omaha, United States
5,0
4
Memverifikasi Metode pembayaran
Anggota sejak Feb 16, 2016

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.