How do I automatically send data into a custom table to be calculated into totals?

Question

For my job, I measure blueprints and send those measurements in a CSV to excel to get categorized into an easy to read model. Is there a way for me to create a template that I can import the data automatically for totals? What I'm currently doing is copying over the model from a former project, deleting the data, adding in my formulas to be copied over into each slot and manually selecting the cells to be referenced for the totals. An example of one of the common formulas I use is =roundup(1.07 x sum(x,y,z),0).

My goal is to specifically automate the x,y,z part.

The image upload isn't working but the imported data looks like this:

Subject	Layer	Measurement (x,y,z section)	Unit
Handrail	Stair 1	5.48	ft
---	---	---	---
Handrail	Stair 1	49.55	ft
Handrail	Stair 2	185.21	ft
Wall Cap	Stair 1	9.78	ft

Answer 1

Which sheet is to put the result and which sheet is the source sheet?

Answer 2

I think this could significantly improve my use of time on this task. It's not quite what I was looking for, but it's much better than what I'm currently doing!

Thank you!

If you're up to it, please view my file linked to Jeovanny's question. This is a finished product that I'd like to partially automate.

Answer 3

Here's a link to one of my finished spreadsheets. I transferred it over to google sheets, but the formulas remain.

https://docs.google.com/spreadsheets/d/1K9N6YI1YT86cR9Oh2tt_MTFGf-Cojod6/edit?usp=sharing&ouid=114289586212255419397&rtpof=true&sd=true

Instead of organizing the data into different sections and then selecting the cells for each section, I'd like to just add on the CSV and have the program organize and calculate it for me to audit.

Answer 4

Hi David

Kindly suggest preparing:

1) Copies of the CSV files with the blueprint measures. (3 if possible)

2) A copy of the current Excel file with the formulas, and manually enter the values in the result table in the way you expect

Drop them in a folder, and upload them to Onedrive, Dropbox,...etc, and share the link here.

This will help us to give you a prompt and right solution.

If you need help with how to upload the file please, click the link below

https://support.office.com/en-us/article/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07

You may also follow the instructions in this video

https://www.youtube.com/watch?v=NnXsE0SNuCc&t=14s

Regards

Jeovany

Answer 5

This one? Could you show an expected result? How do you want to the template do?

=ROUNDUP(SUM(FILTER(C2:C5,A2:A5=F2))*1.07,0)