Building EXCEL charts.
Good day.
There are sensors that record data every second.
date // time // data 1 // data 2 // data 3 // data 4 ........
Data can be recorded for several hours to several days.
Currently, there are 2 sensors, meaning 2 TXT format files.
As we see it,
1. it is necessary to upload these files into the program and obtain graphs.
2. it is necessary to select which data will be on the X axis and which on the Y axis. Also, the main data for the counting will be selected, for example, the serial number of the measurement.
3. select the interval for displaying the graph, for example, from 6 AM to 12 PM, or the serial number, for example, from 1000 to 2000
4. The ability to express intervals. For example, from 7 to 8 AM, similarly with the serial number
This can be done in any other convenient available program.
-
Good evening, can you provide the file for review in what format it is now, and then I will suggest the best way to display the data with various filters.
-
375 Hello. Based on practice, I propose the following:
- If convenient - Google Sheets. If there is a need for urgency, I will write a script for data upload and processing. Visualization in Looker Studio.
- The Excel option, in my opinion, also requires automation. For example, an .exe file that, when launched, will also perform checks for uniqueness, homogeneity, and will write data to an Excel workbook, where visualization with control elements will already be set up.
For a more detailed analysis and conclusion on which path to take, I need a .txt example.
I will supplement the final tool with instructions in the chosen format (video, text) if needed.
… I look forward to meeting and collaborating.
-
2327 61 0 Hello. I will take on your task. I guarantee quality :) Can I take a look at the sample file?
-
91 5 0 I wrote a similar program. I will adjust it to your needs. Filtering, export to Excel and other formats can be discussed. Please provide text samples for study. Price and deadlines are negotiable. Reading from the sensors themselves is possible...
-
1026 15 0 Good day.
I can implement the task using Excel.
I need to clarify a few things, I am ready to discuss in private messages.
-
957 19 0 Good day!
I am interested in the task. I will help create a maximally informative system. On your part, you will just need to add data to the table. Calculations and graphs will be built automatically, and you will be able to adjust the display period (hour, day, week, month), and compare periods. Many functions can be implemented.
Write to me if you are interested, send the file, and I will demonstrate how to visualize the data and suggest options.
If it is possible to implement automatic data transmission (from the sensor via the internet), it will be even more convenient for you.
-
434 9 0 Hello. I can create a program with a graphical interface in Python, there is an example of a similar project in my portfolio. Feel free to contact me.
-
91 Good day, I am ready to help with your task. I have already solved similar problems.
-
2257 35 0 Good day. I am ready to help - I have done similar projects. I will propose an optimal solution. Feel free to reach out.
-
567 28 2 Good day! I can do it directly in Excel using triggers, filters, etc. Write to me, we will communicate.
-
986 12 1 Good day.
I can do it in Excel. I suggest using pivot tables with linked charts. For selecting intervals, use slicers, which will rebuild the charts based on the selections.
-
5894 345 0 I will consider an example file, suggest implementation in Excel, or come up with something else if needed, up to creating my own program.
-
4461 102 0 Good evening. I will be happy to help. I am ready to start working. Can I see an example of the document with the source data?
Current freelance projects in the category Data Processing
Assistance with personal social media, networking, and projects for a monthFor activities in the field of science and scientific publications, I am looking for an assistant to perform basic organizational and operational tasks for a month as an executive assistant. Tasks include, but are not limited to: - working with AI at a deep level with documents… Data Processing, Customer Support ∙ 1 day 12 hours back ∙ 9 proposals |
Setting up and updating dashboards in Looker StudioWe have several dashboards created in Looker Studio that pull data from main Google Sheets.Last year, we regularly maintained and updated these sheets; however, the process was later halted, and the specialist who was managing the system no longer works with us. Currently, some… Data Processing ∙ 2 days 9 hours back ∙ 10 proposals |
Database of hotel owners Ukraine
67 USD
Could you please let me know if you can match a database or find hotel owners in Ukraine for lookalike audiences? Perhaps someone has it and what is the price? Thank you Data Processing, Information Gathering ∙ 8 days 12 hours back ∙ 20 proposals |
Analytics Setup
223 USD
We have GTM and Conversion API connected to Meta. Currently, it is not working correctly everywhere. We need to fix the issues and further develop the amount of analytics on the product. Data Processing ∙ 9 days 6 hours back ∙ 18 proposals |
Integration of HubSpot with lead generation sources (Perspective, WordPress, Meta Ads)
89 USD
Good day! Project goal: To build end-to-end automation for lead collection from a multi-platform ecosystem into HubSpot CRM. It is necessary to ensure the creation/updating of contacts and the automatic opening of deals while preserving the full attribution chain of traffic… Content Management Systems, Data Processing ∙ 10 days 19 hours back ∙ 18 proposals |