MoseleyCabinets
New member
- Local time
- Today, 06:02
- Joined
- Apr 6, 2020
- Messages
- 5
Ok, I've banged my head against the desk for a couple of hours now..
I'm trying to turn my old, clunky excel calculator into a db that I can search and modify as needed. I have a Table with all the information per job (feet of base cabinets, feet of upper cabinets, etc etc), I have a table with the cost per foot per material (so a column of Oak-base, upper, vanity, a column or Ash-base, upper, vanity, etc) - how do I get the form to use the correct column (material type) to do the math. 10' of oak base cabinet is $765.00 at $76.5/ft but Alder is $71/ft. I'm probably overlooking the easy solution, and I'm ok with the math taking place on the form.
TLDR - I need help implementing a pricing matrix for a cabinet shop.
Semper Fi,
Jim
I'm trying to turn my old, clunky excel calculator into a db that I can search and modify as needed. I have a Table with all the information per job (feet of base cabinets, feet of upper cabinets, etc etc), I have a table with the cost per foot per material (so a column of Oak-base, upper, vanity, a column or Ash-base, upper, vanity, etc) - how do I get the form to use the correct column (material type) to do the math. 10' of oak base cabinet is $765.00 at $76.5/ft but Alder is $71/ft. I'm probably overlooking the easy solution, and I'm ok with the math taking place on the form.
TLDR - I need help implementing a pricing matrix for a cabinet shop.
Semper Fi,
Jim