Hello /sci/ I need some guidance.
I have a kitchen remodeling company and I'm trying to streamline an ordering process.
Some quick background: One of our most popular services is re-dooring existing cabinets, where we just replace the doors and re-finish the old frames and boxes which results in a brand-new looking kitchen at a much lower cost.
Anyways the problem is that often times customers want a more modern look (in the USA most homes have "framed" cabinets, where the doors don't fully cover the face of the box, and leave a reveal of the face frame) which means custom ordering larger doors and figuring out new dimensions to achieve a more modern or "euro" look. I can do this very easily by hand, but when dealing with many big kitchens it is lengthy and tedious work.
I am trying to come up with a system where I can input measurements (I only have beginner coding exp. but willing to learn more) and the formula/program can automatically spit out the widths of the new doors. I've tried to figure out a formula on paper but I just end up with a lot of terms and don't know where to go from there.
Pic related is just an example of what I come across. 3 cabinets, all pre-fab so frame widths are all the same. Say I want 1/2" reveals across the whole cabinet run, is it possible to set up a formula where I input opening widths and frame widths and get 3 door widths?
I have a kitchen remodeling company and I'm trying to streamline an ordering process.
Some quick background: One of our most popular services is re-dooring existing cabinets, where we just replace the doors and re-finish the old frames and boxes which results in a brand-new looking kitchen at a much lower cost.
Anyways the problem is that often times customers want a more modern look (in the USA most homes have "framed" cabinets, where the doors don't fully cover the face of the box, and leave a reveal of the face frame) which means custom ordering larger doors and figuring out new dimensions to achieve a more modern or "euro" look. I can do this very easily by hand, but when dealing with many big kitchens it is lengthy and tedious work.
I am trying to come up with a system where I can input measurements (I only have beginner coding exp. but willing to learn more) and the formula/program can automatically spit out the widths of the new doors. I've tried to figure out a formula on paper but I just end up with a lot of terms and don't know where to go from there.
Pic related is just an example of what I come across. 3 cabinets, all pre-fab so frame widths are all the same. Say I want 1/2" reveals across the whole cabinet run, is it possible to set up a formula where I input opening widths and frame widths and get 3 door widths?
