Hello, I run a handyman and small construction company and always working to be more efficient. What i'm looking to do is create a "master calculator" of sorts by categorizing tabs for specific jobs (Fencing/Decking, Bathroom Remodels, etc) and have it update with realtime price data.
For example:
Lets say I'm doing a takeoff for a deck build and I have different line items.
For my Support Posts I'd have that as an enterable amount (lets say 4). For each Support Post I'd need hardware, lumber, sonotubes, 4 bags concrete, etc. So I'd like my entered quantity to affect the quantities of each of those material line items. To make it really just the greatest tool I could have in my arsenal, I'd like to be able to link a product SKU number from Lowes or something to automatically adjust price.
With this it would take me a fraction of the time to estimate jobs and with these blueprints I'll be able to tweak and add on different services and whatnot. My knowledge of spreadsheets is pretty basic, but it is worth the time for me to learn. So, is this possible? TIA