Make my rough draft excel chart pretty.... and figure out a couple of formulas

UPDATE: I just uploaded a new rough draft version with a full set of 7 days data (I copy and pasted 24 hrs data 7 times... since I have only been collecting data for 2 days now but eventually it will be in 7 day batches).

This project is really simple excel coding... once you figure it out you just need to replicate it a bunch... the data sheet will have over 10,000 rows.

HOWEVER, please look at the sample file, sheet 3. The challenge (for me) is figuring out how to sort the data whenever the pump fires off over a span of "minute changes". The cycle of the pump is only 30 seconds. When the pump cycles in a single minute span, the data is easy to grab. However, many times the data spills over and I get a half (or 3/4) value in 1 minute and then the remainder in the following minute. When that happens it of course throws off the COUNT function. If you can solve that.... thank you. :-)

When you are figuring out how you would solve that problem, please keep in mind. Right now the East pump is firing off every 13 minutes or so... which means you have at least 10 "0" cells in between important data. However, during rainy season I may get a lot more water so the pump will fire off more.... perhaps only 3-7 "0" cells between important data collection. Please plan your solution accordingly.


I recently installed an Emporia Vue Gen 2. This device monitors amperage use on circuits in a home. I need to monitor how many times each day 2 of my sump pumps activate. Each pump is on a separate circuit. In the Emporia app it is very easy to see the pumps "firing" and the monitored voltages jumps from 0 to 0.2 every 15 minutes. However, it is tedious to scroll throughout the day to count the number of spikes. Luckily Emporia has an export .csv function.

The data is downloadable for the most recent 30 days. I envision downloading the data every week and pasting the relevant sections into a template that I created. The template will then push out and quantify what I need to know. I have roughed it out in LibreOffice and Excel. I would prefer the final version to be in LibreOffice as I use that more and sometimes the conversion doesn't match up.

I'm sure there are easier ways to lay out this data.. so I'm open to suggestions.

Things I need:

Total number of cycles per pump each day

Total number of cycles per pump each hour

Навыки: Excel

Показать больше: excel chart templates download, excel graph templates bar, and line, how to do chart in excel, how do i change the color of my bars in excel based on value, box plot excel 2016, how to create a chart in excel 2016, excel chart template not working, excel load chart template, excel chart graph russia, excel chart generator tool, project status spreadsheet excel chart, excel chart generation php, create excel chart csv file, excel chart provide csv data, excel chart data dynamic 2003, excel chart generate php, excel chart combined 100, project bidding rough draft, show data macro excel chart, bid job rough draft

О работодателе:
( 0 отзыв(-а, -ов) ) Carlsbad, United States

ID проекта: #27409301



I'll get the job done. This is a pretty straightforward request, so anyone with Excel knowledge can do this. I'm from the states, so there won't be any language barriers or huge time differences. I work full time but I Больше

$50 USD за 3 дней(-я)
(0 отзывов(-а))

14 фрилансеров(-а) готовы выполнить эту работу в среднем за $112

(59 отзывов(-а))

Hello? I have worked on Excel/Word/PPT/MACRO projects to what you are looking for, and I am confident I can exceed your expectations. I have attached samples of work very similar to what you are seeking. # create Больше

$155 USD за 3 дней(-я)
(9 отзывов(-а))

Hello. Hope all is well. I'm a statistician with a masters degree in statistics and applied economics and am ready to help you immediately. Happy to chat more to exchange details if interested. Thanks

$30 USD за 1 день
(8 отзывов(-а))

Hi I HAVE FINISHED THE PROJECT, I have figured out a way to get the total number of pumps per day and per hour. It only took a little bit of formatting and a pivot table. Please message me so I can show you my work. Больше

$30 USD за 1 день
(16 отзывов(-а))

Hello. I'm a specialist in Excel and macros programming. I can apply formulas and design so you can access to data you want.

$30 USD за 3 дней(-я)
(6 отзывов(-а))

Hi, I can help you as per your guidance. I am excel + vba specialist who have +10 yrs experience.

$100 USD за 1 день
(2 отзывов(-а))

Hello Sir/Madam, I have Read your Project deeply and I'm interested in your project.. I have 2 year Experience of these type of Work a similar Project also On my Portfolio You Can Check it. I Can Complete Your Project Больше

$45 USD за 3 дней(-я)
(0 отзывов(-а))

Hi there, Do you have any way of directly sending the data from the pumps with it? Do you have a user manual for it (they may explain how it sends data? I can create any kind of app for it to read data and fill in db, Больше

$200 USD за 7 дней(-я)
(0 отзывов(-а))

Hello, I am an engineer, I am used to working with Excel. I have a lot of experience with as I also code in VBA. I am able to complete the task fastly, I am serious and reliable.

$150 USD за 3 дней(-я)
(0 отзывов(-а))

Hello, this is exactly the type of work that I spend most of my internship with the National Cancer Institute this summer working on. I'd love to talk to you about automation and visualization options. One idea would b Больше

$100 USD за 7 дней(-я)
(0 отзывов(-а))

I am highly proficient in excel analysis , with over six years experience. I am an expert in excel automation , vba and data analysis. I'll deliver a great job if you accord me the chance.

$200 USD за 5 дней(-я)
(0 отзывов(-а))

My name is Kathleen Kaye . I am a data entry with an experience of 1 year. I have experience of proven data entry work, MS office, data programs and I am acquainted with administrative duties. Also, I have a high scho Больше

$140 USD за 7 дней(-я)
(0 отзывов(-а))

This is really challenging and I would love to work on this, but I couldn't understand it completely what is needed. Appreciate if you can explain in more details. Thanks.

$140 USD за 7 дней(-я)
(0 отзывов(-а))