Automation + extract messages into a table in google spreadsheet

€12-18 EUR / hour

Complété

Publié

il y a plus de 5 ans

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

Excel

Google App Engine

Java

N° de projet : 17870440

Concernant le projet

6 propositions

Projet à distance

Actif à il y a 6 ans

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

Décerné à :

@sviatsom

Hi, I have already finished similar projects. I can prepare the Python script for you in a couple of days. Best, Sviat

€16 EUR en 10 jours

5,0

(1 commentaire)

2,4

6 freelances proposent en moyenne €16 EUR/heure pour ce travail

@unboltsoft

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 en 40 jours

5,0

(1 commentaire)

5,2

@AlexFaster

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 en 40 jours

5,0

(3 commentaires)

3,8

@MistySarker1144

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 en 40 jours