Microsoft Excel and the Index Formula - How to Create a Customer / Product Price Matrix
Вставка
- Опубліковано 22 сер 2018
- PS this works in Google Sheets too!
This content is for information purposes only and should not be considered legal, accounting or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Nerd Enterprises, Inc. does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Nerd Enterprises, Inc. does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.
![How to Create a Project Priority Matrix [QUICK + EASY]](/img/n.gif)
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!
Thanks a lot! excellent stuff. I was just looking for the same logic.
YOU MADE IT LOOK EASY. THANK YOU SIR!
Thanks a lot Seth , very interesting content. Already subscribed !
Thank You! this really helped me out.
Thank you!
This helped me out a lot! Thank you!
Thank you! So glad it helped!
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!
Great Video Thank You very well explained
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?
ty so much! this helped me with my day-to-day work.
Thank you so much. Solved my problem today!
I absolutely love this video!
Thank you Ana!
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!
Thank you for sharing this tut.
Thank you!
Thanks for the help... Thank you.
Life Saver!! Thanks for the Tutorial!
Thank you!
This was a great tutorial !!
Thank you!
Thank you so much!
You're welcome!
Incredibly helpful!
Thank you! I am so glad you enjoyed it!
thank you so much!
You're welcome!
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.
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.
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
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.
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.
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.
Both files are in Excel.
Was that not what you expected?