Automation + extract messages into a table in google spreadsheet

€12-18 EUR / hour

Dokončeno

Zveřejněno

před více než 5 roky

€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

IČ projektu: 17870440

O projektu

6 nabídky

Vzdálený projekt

Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@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 v 10 dnech

5,0

(1 recenze)

2,4

6 freelanceři nabízejí v průměru €16 EUR/hodinu za tuto práci

@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 v 40 dnech

5,0

(1 recenze)

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 v 40 dnech

5,0

(3 recenze)

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 v 40 dnech