In QuickBooks Online Advanced, you can customize templates and map them to Word or Excel docs. I can't promise how well it works, but I know it's possible.
Thank you so much, that was very helpful, just had a question, what If I want to get the prices from different sheets with different names and reflects on the same calculator?
Help! This is the closest video I've found on this topic: I have a pricing matrix for screen printing--our print prices change based on the quantity of shirts ordered and the number of colors printed. I have a simple matrix made for pricing estimates, but I'd like the pricing to change dynamically between each price break--will I need to create a table that stretches 1000+ rows down, or am I able to change this in a formula. For example: I charge $6.25 per shirt to print 12 one-color shirts, and $4.28 per shirt if you order 25 shirts. How can I set a formula to adjust the price to be between those two costs if you ordered 16 shirts or 21 shirts?
To accomplish this you would need to define the matrix based on 2 dimensions. So it may just mean figuring every possible combination of # of colors and quantities. Then you could use this process.
To take this one stage further, can you provide a formula that allows four corner pricing? I use various large matrix and would only like to put a price in the four corners and the sheet fill the rest in.
I would need to better understand how those prices would be calculated. Then it would be a matter of writing a formula that uses the amounts in the 4 corners to calculate your prices for everything in between.
@@nerdenterprises we use a width and height matrix for window styles. This may start with a minimum width of 400 and maximum of 1300, the same for the height. i can quickly calculate the price manually for the 400 by 400, 400 by 1300, 400 by 1300 and 1300 by 1300. but it would take me along time to do all those in between for the 50 window designs we use. Hope that makes sense and many thanks for your swift reply.
@@keithchristian77 sounds like something I can probably create for you, but we should get on a Zoom to clarify parameters and then I can quote you on the project. Schedule with me here --> go.oncehub.com/nerd30
@@paulreeves7934 Options and pricing are all laid out on that page I linked you to. 1 hour is $500 and I record the session so you can review it any time.
ty so much! this helped me with my day-to-day work.
Wow, you covered a lot of ground pretty quickly there. Thanks so much, this is exactly what I needed!
Thank you Trevor! So glad this helped!
This was amazing! Thank you for sharing this with us, it will be a big help in streamlining our estimates to our clients.
Thank you! I am so glad you found this helpful!
Great Video Thank You very well explained
Thanks a ZILLION - you just saved me so much frustration! I'm ready to look like a genius to my coworkers
This makes me SO happy!
Please let me know how it goes!
Thank you so much. Solved my problem today!
Incredibly helpful!
Thank you! I am so glad you enjoyed it!
YOU MADE IT LOOK EASY. THANK YOU SIR!
This helped me out a lot! Thank you!
Thank you! So glad it helped!
Thanks for the help... Thank you.
This is great... now how to make it work with an Estimate Template in Excel???
In QuickBooks Online Advanced, you can customize templates and map them to Word or Excel docs. I can't promise how well it works, but I know it's possible.
Life Saver!! Thanks for the Tutorial!
Thank you!
This was a great tutorial !!
Thank you!
Thanks for the video. What if you have customers with more than one product? How do you solve that? thanks again
Each product is listed in the matrix so that that product can be matched with each customer for whatever price you are charging.
Thanks a lot Seth , very interesting content. Already subscribed !
Thanks a lot! excellent stuff. I was just looking for the same logic.
Thank you so much, that was very helpful, just had a question, what If I want to get the prices from different sheets with different names and reflects on the same calculator?
I absolutely love this video!
Thank you Ana!
Help! This is the closest video I've found on this topic:
I have a pricing matrix for screen printing--our print prices change based on the quantity of shirts ordered and the number of colors printed. I have a simple matrix made for pricing estimates, but I'd like the pricing to change dynamically between each price break--will I need to create a table that stretches 1000+ rows down, or am I able to change this in a formula.
For example: I charge $6.25 per shirt to print 12 one-color shirts, and $4.28 per shirt if you order 25 shirts. How can I set a formula to adjust the price to be between those two costs if you ordered 16 shirts or 21 shirts?
To accomplish this you would need to define the matrix based on 2 dimensions. So it may just mean figuring every possible combination of # of colors and quantities.
Then you could use this process.
Thank You! this really helped me out.
Thank you!
To take this one stage further, can you provide a formula that allows four corner pricing? I use various large matrix and would only like to put a price in the four corners and the sheet fill the rest in.
I would need to better understand how those prices would be calculated. Then it would be a matter of writing a formula that uses the amounts in the 4 corners to calculate your prices for everything in between.
@@nerdenterprises we use a width and height matrix for window styles. This may start with a minimum width of 400 and maximum of 1300, the same for the height. i can quickly calculate the price manually for the 400 by 400, 400 by 1300, 400 by 1300 and 1300 by 1300. but it would take me along time to do all those in between for the 50 window designs we use. Hope that makes sense and many thanks for your swift reply.
@@keithchristian77 sounds like something I can probably create for you, but we should get on a Zoom to clarify parameters and then I can quote you on the project.
Schedule with me here --> go.oncehub.com/nerd30
Thank you for sharing this tut.
Thank you!
Thank you so much!
You're welcome!
just Can not get this to work, fine up to pasting in the formula and then just errors every time . is there any other way of calculating this ?
If there was an easier way I would do it, but perhaps a 1:1 session would help clear it up? --> new.nerdenterprises.com/consulting
@@nerdenterprises and how much will that cost me ?
@@paulreeves7934 Options and pricing are all laid out on that page I linked you to. 1 hour is $500 and I record the session so you can review it any time.
Thanks, i have eventually mastered it.
how do you create a price matrix with 3 variables that still only produces a single value?
I don't think that's possible. You might be able to accomplish this with a pivot table, but I would need more details for context.
Both files are in Excel.
Was that not what you expected?
thank you so much!
You're welcome!