Find Jobs
Hire Freelancers

Automation + extract messages into a table in google spreadsheet

€12-18 EUR / hour

Completed
Posted over 5 years ago

€12-18 EUR / hour

i get messages from different devices into a google spreadsheet. These messages are different depends on source device name and time interval and status.. I need someone with google spreadsheet scripting knowledge (google apps script), to write a script to automate reading the messages in sheet one and put the status in a table in sheet two : 1- search sheet1 in a loop for each of these 4 Devices and get the string. 2- extract from that string The TAG name , STATUS and time interval 3- put status in an existing table in the device row under the correspondent TAG and interval . The status of a device should then be updated if there is a new message for that device. 4- give color green to positive status and red to negative status.
Project ID: 17870440

About the project

6 proposals
Remote project
Active 5 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
Awarded to:
User Avatar
Hi, I have already finished similar projects. I can prepare the Python script for you in a couple of days. Best, Sviat
€16 EUR in 10 days
5.0 (1 review)
2.4
2.4
6 freelancers are bidding on average €16 EUR/hour for this job
User Avatar
A young Ukrainian software development company that employs several passionate engineers. Our main direction is the engineering, development and implementation of custom software with a deep scientific focus that requires strong skills in mathematical and natural sciences. The technical leadership of the company is held by two keen scientists with Ph.D. degrees in physics, mathematics and technical sciences. During the last 5 years we have been involved in several projects related to cloud computing, math libraries, machine learning, parallel computing, CAD/CAE, engineering drawing, production costing, computer vision, remote device control, brain physics modeling, natural language processing, satellite imagery and more. We use MPI, OpenMP, COM and other technologies while working in C++, C#, Python, Matlab, Java, Mathematica and other languages. We develop applications for Windows, Linux and Android. We would be happy to take care of your boldest and most complicated projects!
€20 EUR in 40 days
5.0 (1 review)
5.2
5.2
User Avatar
Hi. I'm professional programmer with experience over 20 years. I need to look to your spreadsheets and discuss another questions. See my completion rate and feedbacks. Regards, Alex.
€18 EUR in 40 days
5.0 (3 reviews)
3.8
3.8
User Avatar
Hi.. I saw your project and want to help with it if you will accept my proposal. Of course I cannot convince you but I can give you an assurance of a good job. Thanks.
€16 EUR in 40 days
0.0 (0 reviews)
0.5
0.5
User Avatar
I have bachelor's degree in software development. Moreover, I have skills in scripting google apps. Do not hesitate to contact me.
€12 EUR in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NETHERLANDS
Assen, Netherlands
5.0
2
Payment method verified
Member since Sep 30, 2018

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)
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.