Closed

Excel form to intake metabolic and physiological data

I have a large excel sheet that is already pre-formatted with some documentation based on inputs on a "data" tab. However, I also import tables from my metabolic cart and a separate heart rate variability app. Once imported, I need to manually work with the data to create the charts because some athletes go shorter and others go longer, so I'm always adjusting the input row length based on their test duration.

I'm looking for a solution where I can paste these CSV tables into one excel document, set a few parameters (e.g., I want the "time" column auto-split into 3 minute segments, or 4 minute segments, etc.) and then I want that data pulled so I can get a minute by minute average, plus stage average for every 1, 3, or 4 minutes, whatever time length I specify.

I would like to have this all work in one document with as many tabs as it takes, but it's more about the input. Once I can have the sheet "ingest" the data quickly with my specified parameters, I can more easily take that and put the results into the necessary documentation for review with the athlete.

The attached screenshot is one of the tables that I would like to have ingested into the sheet. There would be a total of likely 2 or 3 separate large pieces to ingest like this.

Thank you

Skills: Excel, Visual Basic, Data Processing, Software Architecture, PHP

About the Employer:
( 0 reviews ) Boulder, United States

Project ID: #32695814

32 freelancers are bidding on average $412 for this job

(588 Reviews)
8.6
(290 Reviews)
8.1
(1117 Reviews)
8.3
AwaisChaudhry

Hi, I have read the details I believe I can do this job. While I believe I have some queries which need to be clarified. For that I would request you to start the chat so we could clarify those. We can discuss the time More

$750 USD in 17 days
(95 Reviews)
8.1
helmot

Hi, I am a C# developer using .net6 to develop Modern web applications with Blazor. It is possible to develop mobile Apps for Android, iPhone and Windows platforms with a Blazor code in MAUI. It is also possible to de More

$500 USD in 10 days
(201 Reviews)
8.2
(342 Reviews)
7.2
(68 Reviews)
7.1
(206 Reviews)
6.6
ayesha0124

Hello, I have working experience of 7 years on this platform and i believe i can help u with getting this job done as i have the great knowledge of Data Processing, Software Architecture, Visual Basic, Excel and PHP. More

$750 USD in 24 days
(18 Reviews)
6.6
DeveloperDaut

***Excel Specialist*** Hello, How are you? I've read your project description carefully. As a senior software developer, I have rich experience in this kind of works. I am sure I can handle your project as you expected More

$500 USD in 5 days
(28 Reviews)
6.3
(171 Reviews)
6.5
(40 Reviews)
6.3
(24 Reviews)
6.2
(145 Reviews)
6.3
Ayo25

I am a data entry specialist and statistician. I have advanced knowledge of Microsoft excel and R language. Please check out my portfolio for my past projects and reviews.

$450 USD in 7 days
(13 Reviews)
5.9
(129 Reviews)
6.1
(66 Reviews)
6.1
utkarsh7238

Hey, I can make Excel Form to intake your huge metabolic and physioogical data In how much time you want it to be completed?? Let's talk about your project Waiting for your response!!

$250 USD in 3 days
(34 Reviews)
4.7
ivanovatale

Hello and thank you for checking my proposal. I am an Excel and Access expert. I have been working for over 10 years in the field of workflow automation, using Excel, Access, Python, VBA, SQL for this. I worked with ma More

$250 USD in 3 days
(5 Reviews)
4.7
nenadudovicic111

Hello? I have worked on Excel macro with formula and vba code 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 seek More

$300 USD in 10 days
(9 Reviews)
4.2