Completed

MS Excel VBA script for LLS sensors

Our business uses IOT sensors to collect environmental readings. We are requiring VBA script written to convert data from a text file into MS Excel format with column headings as attached. The 2 files attached are the raw data(Raw data 402 .txt) and required output example(Converted sheet xlsx)

Skills: Excel, Visual Basic, Visual Basic for Apps, Data Processing

See more: excel vba lock sheet user script, start vba script excel, run vba script excel, excel vba script modify existing vba, vba script excel xml, excel vba macro calculate business days, excel vba lookup script, simple excel vba script, excel vba script find text, excel vba script merge cells, ms access vba script find table inside db, ms excel vba cut paste, excel vba script scrape website, excel vba script copy paste, create ms excel vba code to produce monthly expense report, excel vba script, freelance trainers in ms excel vba bangalore, ms excel vba, ms excel vba experts sydney, VBA Script with Excel / MS Access

About the Employer:
( 0 reviews ) Arcadia, Australia

Project ID: #20469678

Awarded to:

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

$225 AUD in 3 days
(720 Reviews)
8.5

47 freelancers are bidding on average $107 for this job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$160 AUD in 3 days
(331 Reviews)
7.9
deepbluetech

Hi, I am an Excel VBA expert working in this field for the past 15 years. Had a look at the raw data file and the output template file. I propose to deliver an Excel VBA script to handle the requirements within 2 days More

$100 AUD in 2 days
(222 Reviews)
7.4
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 AUD in 3 days
(307 Reviews)
7.3
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will turn a CSV file into an Excel sheet. I plan to use More

$90 AUD in 1 day
(217 Reviews)
7.3
shoguna2m

Hi there, My name is Mauricio I'm the MS Excel expert from Trascender Global Team, with 4 years of experience in developing VBA and Python projects to extract and convert data. I've read the details of your project More

$200 AUD in 2 days
(107 Reviews)
6.8
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$100 AUD in 7 days
(120 Reviews)
6.9
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom f More

$155 AUD in 3 days
(90 Reviews)
6.7
rinabuoy13

Hello, I am an independent, experienced excel expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

$140 AUD in 1 day
(96 Reviews)
6.1
royalcalif

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfille More

$30 AUD in 1 day
(83 Reviews)
5.7
valor312

VERY EASY FOR ME Hi, Nice to meet you. When it comes to Excel, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/projects/excel/Build-apprais More

$100 AUD in 1 day
(44 Reviews)
5.5
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$100 AUD in 1 day
(114 Reviews)
5.9
sajidkhan45

Hi, I am an excel VBA expert and went through the two files that you have attached here. If the format of the text file remains the same then I am confident that this project can be executed since I do these kinds of More

$120 AUD in 2 days
(54 Reviews)
5.5
vsprybhanu

Hi, I have read your instructions carefully and saw attached Raw data and converted excel file. I can develop a macro to read text file and separate the text as per requirements into different fields of excel file. I More

$45 AUD in 3 days
(81 Reviews)
5.5
DebasisB

Hi there, I am interested in the project. I can deliver the script within 24 hours of bid acceptance. Thank You.

$125 AUD in 2 days
(32 Reviews)
5.4
Taisho

Hello, I can write an Excel VBA macro that will open this JSON data text file and generate the output on a button click. The user will be prompted to select the source file through file picker interface. With the pro More

$50 AUD in 2 days
(65 Reviews)
5.2
StormLion227

Hello Sir. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert VBA programmer on freelancer.com and I do not bid on More

$100 AUD in 1 day
(13 Reviews)
4.9
khoddam

Hello, Your text file is actually in json format. So I can write a program to load this json file into Excel file

$70 AUD in 1 day
(27 Reviews)
5.0
khanicha

Hello, It is a json format data source, so for better, more accuracy, and quick processing, I am offering you to use my JSON Parser tools which is supporting VBA code as well. Using this library, you will have t More

$111 AUD in 1 day
(11 Reviews)
4.8
Sercho56

I am a Canberra based software developer with significant experience in developing Excel VBA solutions. I have examined your raw data and can employ a simple algorithm to convert this txt file into a xls file as provi More

$55 AUD in 2 days
(11 Reviews)
4.6
selopezr

Hello, My name is Shamy López from Bolivia in South America. I'm experienced programming Excel Macros for all types of applications such as importing and processing data from .txt and .csv files. I'd be pleased to ser More

$100 AUD in 3 days
(24 Reviews)
4.6