MarkMc Posted June 26, 2018 Share Posted June 26, 2018 Going to have a web meeting (free, using Zoom.us) July 11th at 2 pm Eastern Time ends at 4 pm Eastern, limit 25 attendees. Will be recorded (if I don’t muck that up). If interested get in touch - markmc at markjamesandco.com Please include: what you do (KD, dealer, builder, etc) anything in particular you are interested in (no promises but I’ll see if I can make adjustments) how long you’ve used Chief, current version and what you used before if anything. This is open to all but keep in mind it’s meant for kitchen designers and others who need to create a cabinet order or develop pricing working in Chief Architect (call it a 2020 refugee camp In general- creating a schedule with all the information needed generate an order in a spreadsheet template of using an online ordering system. It’s based on part of the system I’ve used with Chief for the last few years as a kitchen designer/dealer updated for X10 (70% of it will work in X9-time to upgrade) The general idea at this point it: Basic cabinet configuration Using the OIP for mods and accessories Defaults-basic face configuration, OIP for defaults, few quirks & gotchas in the default settings More cabinet configurations, saving to library, library management for brands and projects and defaults Q&A-roundtable Quick design sample using hotkeys and replace from library Adjusting the modifications per item Getting non-cabinet items into the schedule -moldings, millwork, corbels, etc. Q&A-roundtable Schedule and Export Schedule set up, multiple schedules Checking the schedule against intent Exporting the schedule, adjusting the spreadsheet tricks to speed pricing, using pdf catalog for lookup, in a spreadsheet template, checking (brief) Using an online system (the only online order system I currently have access to is a complete custom brand I’m going to use a portion of a recording I made in the past for this but may reach out to someone to work in that part) Q & A IF time allows I can touch on creating detail drawing for the manufacturer, checking the details against the print. Current attendees not all are forum regulars- CharlesVolz, Cheryl_C_Crane, scottharris, Susan Durling, Andrew, GerryT, Paul Machado (maybe on vacation), Robert Zebrowski, a few folks from QCCI (on a single feed), Tim_Houston, Johnny Link to comment Share on other sites More sharing options...
Cheryl_C_Crane Posted June 26, 2018 Share Posted June 26, 2018 MarkMc, Please hold a place for me, I really want to know how to price using CA! BIG Thank You for doing this, it is much appreciated, Cheryl Link to comment Share on other sites More sharing options...
MarkMc Posted June 27, 2018 Author Share Posted June 27, 2018 9 hours ago, Cheryl_C_Crane said: MarkMc, Please hold a place for me, I really want to know how to price using CA! BIG Thank You for doing this, it is much appreciated, Cheryl Send an email so I can send an invite. markmc at markjamesandco.com Link to comment Share on other sites More sharing options...
MarkMc Posted July 6, 2018 Author Share Posted July 6, 2018 Update to to the plan for this- Cabinet defaults setting up OIP fields and some macros. The macros are very simple since I'm no wiz in the dark arts. Schedule default and how to get an alternate for use in pricing (and where the rocks are so you don't trip) Generating mfg cabinet/mod codes from pdf catalog, formatting entries for OIP field used for pricing using a spreadsheet template (provided), a little copy paste special, convert to table stuff and tools used to quickly get the codes where you want them. Saved cabinets in the user library, how much data to include when. Using replace from library. Change schedule to alternate, copy schedule, paste to sheet. Revert schedule to default for printing. Adjusting pasted columns to match a spreadsheet order form. What's worth having to look up and fill in (IOW what is not worth automating) Using the sheet data in an online ordering system Using the sheet data in 2020 A very brief section on generating cabinet details need for order submission and a method to check accuracy (avoid mistakes). I'd like to present each section and follow that with a Q & A, then move on to the next section. I'd originally intended to barely mention much about macros. However in the process of putting the presentation together something came up. While the way I've been moving data from Chief to order for the last few years has been fine for me it can be a bit complicated, cumbersome. An easier method occurred to me, requiring far less spreadsheet manipulation after the fact. (in some case none). While working that out I found a way to also include prices for "some" things; mdoifications and accessories in particular. I was already in the process of updating my user library cabinets per brands to coincide with changes I've made in X10. I've spent the better part of the last week fiddling with this newer approach. I should have it all together by the webinar. However far I get I will send each attendee a zip file ahead of time with the macros, sample plan with OIP fields and schedule, and a spreadsheet template I'm using (as both open/libra office and excel). IF you sent me a PM instead of an email please email me so I can send you the file. 1 Link to comment Share on other sites More sharing options...
MarkMc Posted July 8, 2018 Author Share Posted July 8, 2018 I had not intended to bump this but felt the need to add some more specifics that could be useful to a few people I spoke with and referred to this thread. An overview - How it works-the short answer is pretty well. I could possibly price simple projects; ones with few changes or mods, using brands with limited offerings, faster in 2020 or ProKitchen. OTOH for most of my work generating on the whole generating a complete project (design, drawings, renderings and order) is faster, cleaner, more complete and easier than using anything else I have tried. The system is designed to: generate a ballpark price quickly be usable by folks with modest computer skills maximize the time saved compared to require to adapt and use adapt to any brand of cabinets (though where it shines is if you use modifications) keep code entry as simple as possible minimize the need to look up pricing- pricing for modifications and pre-configured cabinets is kept in the system (including moldings and millwork) minimize the time spent configuring cabinets and accessing them from the library organize the user library to minimize time negotiating the library when changes are made provide data that can be used in any of three ways of creating and order (spreadsheet, online order form, 2020) minimize the possibility of mistakes, allow for easy checking prior to export and stay “live” based on the design to minimize typing-entry of data is drag and drop (or copy/paste) into fields. At the same time be adaptable to custom entry when needed provide a means of having readily available header information (brand, construction, style, species, finish, etc.) At first glance there are some aspects of setting this up that will appear complicated. Since I did the heavy lifting and handing you what you need to set it up; it is not difficult to use and fulfills the stated goals well. The presentation is a one time deal and a thank you to the hard working folks at Chief and this forum. I’m undecided what I’ll do with the session recording aside from distributing to the attendees. I’ve got more time into this than I intended and I don’t want do a lot of follow up (lacking restraint, I likely couldn’t resist). What you will be given to use: The files have expired, been removed. any macros required to make the system work including mulitple dimension formats to suit your mfg requirements (to 1/16th in fractions & decimal, Rounded to the inch, rounded to 3” increments) a spreadsheet template to format your codes to work within the system a sample plan with default cabinets configured to work with the system assorted static instructions for when you can’t remember how (text, images, maybe a pdf) so you don’t have to go back and rummage through the video What you need (besides Chief Architect): spreadsheet software (plenty of free choics if you don’t have one) you won’t need to know a lot about it ideally a pdf catalog of your mfg catalog (other formats can be as even better but I”ve never managed to acquire any) a pdf reader -optional: the ability to export to a spreadsheet can be useful optional- a program called Stickies; free from www.zhornsoftware.co.uk What you will need to do for your work: place your mfg codes and some pricing into the provided spreadsheet template and save the only spreadsheet actions you will need to know are-insert row(s) or column(s); copy/past; paste special (exact example provided); and lock a spreadsheet (optional) Design as you normally would If you need order data not already in your saved mfg spreadsheet add it (to only one cell) Either drag and drop pre-configured cabinets OR use “Replace from Library” Your moldings and other accessories needed for the order are placed from the library. Quantities is changed using copy and paste in place Set the order of your cabinet schedule and check it change the columns shown in the schedule, copy and paste to a spreadsheet undo the column change and set your schedule columns for final print in Chief Use the exported data in the method you prefer for final pricing: spreadsheet order template (an example supplied), online ordering or 2020 (will work best in versions before they tied catalogs to support)or ProKitchen (but that may be different to work with and I’m not dealing with it) When using the “spreadsheet order template” method you will still have to look up “some” pricing. (for me that amounts to 6-10 lines per order, mostly wall cabinets) I've been getting the data I need to order cabinets out of Chief for 5 years, with 6 manufacturers, with varied order requirements and systems for submission. At first that was limited, then a bit complicated, currently this is the best I've worked out. 1 Link to comment Share on other sites More sharing options...
Cheryl_C_Crane Posted July 8, 2018 Share Posted July 8, 2018 Mark, I know that you have invested hundreds of hours over the last 5 years working out a way to price (estimate) quickly using CA, not to mention all the great suggestions that you made and Chief incorporated into the Cabinets components. And, I can tell that this is causing you to invest more of your time to help the CA community. I truly, truly, appreciate to opportunity to learn from you, ~Cheryl Link to comment Share on other sites More sharing options...
scottharris Posted July 10, 2018 Share Posted July 10, 2018 On 6/26/2018 at 8:22 AM, MarkMc said: Going to have a web meeting (free, using Zoom.us) July 11th at 2 pm Eastern Time ends at 4 pm Eastern, limit 25 attendees. Will be recorded (if I don’t muck that up). If interested get in touch - markmc at markjamesandco.com Mark, thanks much for setting up this webinar July 11 - looking forward to it. 2 Link to comment Share on other sites More sharing options...
dshall Posted July 11, 2018 Share Posted July 11, 2018 Mark, I would love to attend but as of now, that is something I would not use. But I do thank You for what you are doing and hopefully you can help CA take businesss away from you know who. 1 Link to comment Share on other sites More sharing options...
johnny Posted July 11, 2018 Share Posted July 11, 2018 I would love to attend! Link to comment Share on other sites More sharing options...
MarkMc Posted July 11, 2018 Author Share Posted July 11, 2018 9 hours ago, johnny said: I would love to attend! Got your email,(thought that was you, just saw this) invite sent 1 Link to comment Share on other sites More sharing options...
Cheryl_C_Crane Posted July 11, 2018 Share Posted July 11, 2018 Mark, Thanks for putting on the meeting. I will be 'digesting" the information and looking at the Templates & Spreadsheets closely. If I could conquer Cabinet pricing using CA without also using 2020 I'd become an independent rep for a dealer. Currently, I work for the big orange box. I love consulting with their customers and showing how their space may be reconfigured, repurposed, or simply updated to reflect how we live in our homes today. Watching customers see their thoughts come to life with PBR is a buzz. Loading (redrawing) the design in 2020 is a buzz-kill! It's easy to verify that I am the designer with the highest sales/hour goal in the HD Region although I've only been with the company for 3 years. I'd leave in a heartbeat to be more productive (no time spent on 2020). CA gives me the JuJu. Link to comment Share on other sites More sharing options...
Chopsaw Posted July 11, 2018 Share Posted July 11, 2018 Thanks for sharing all that you have done. You sure have put a lot of work into this. Nice to know this can all be done in CA. Link to comment Share on other sites More sharing options...
Kbird1 Posted June 25, 2019 Share Posted June 25, 2019 5 hours ago, MarkMc said: Someone asked for video from this session-here is the one for using an online ordering system. I'm still messing with Ruby macros to streamline the process but have not had much time to dedicate to this since I don't need it myself, it looks like I several variations will be needed, working on learning Ruby, selling my house, have real work and a life....so eventually I'll have something, then will decide what to do with it. For anyone who was at the web meeting the system can also be used to go from a schedule into a spreadsheet template that is a cabinet order form. Thanks Mark , guess I missed this last year , thought it was next month at 1st , do you still have the files from the Workshop , so I can follow along? thanks, M. Link to comment Share on other sites More sharing options...
MarkMc Posted June 25, 2019 Author Share Posted June 25, 2019 On 6/24/2019 at 9:47 PM, Kbird1 said: Thanks Mark , guess I missed this last year , thought it was next month at 1st , do you still have the files from the Workshop , so I can follow along? thanks, M. The vid I posted is not of the meeting it was made prior for use during it. The vid from the meeting was something like 125 MB and I'd figured out a that there was better way to do all this the day before the meeting so things were a little choppy. Link to comment Share on other sites More sharing options...
Gravity58 Posted June 25, 2019 Share Posted June 25, 2019 Thanks Mark! really helpful Link to comment Share on other sites More sharing options...
Cheryl_C_Crane Posted June 25, 2019 Share Posted June 25, 2019 Seeing this thread spawned a couple of reminders: 1. We were using X10 last year and you may need your X10 key, 2. Mark has been a tireless stalwart in improving CA for practical Kitchen & Bath work. He ALWAYS responds to the needs of other CA Users QUICKLY. He is the EverReady Bunny (showing my age) of K&B help. He's an amazing Human Bean! Link to comment Share on other sites More sharing options...
EsteeChief Posted July 3, 2019 Share Posted July 3, 2019 MarkMc: Wowowow I just saw it. What a treat for KD. I would love to attend...(though leaving that evening for a trip but I'll organize myself so I can Make it). I started using CA on Feb this year. I have used AuCad and 2020... Thanks! Pls add me to your list: puredesign2000@videotron.ca Link to comment Share on other sites More sharing options...
MarkMc Posted July 3, 2019 Author Share Posted July 3, 2019 6 minutes ago, EsteeChief said: MarkMc: Wowowow I just saw it. What a treat for KD. I would love to attend...(though leaving that evening for a trip but I'll organize myself so I can Make it). I started using CA on Feb this year. I have used AuCad and 2020... Thanks! Pls add me to your list: puredesign2000@videotron.ca That meeting was a year ago. A partial video is posted above as is a zip folder with files from it. There's other useful things in this section and symbols. May go back as much as 3 years. Look around. Link to comment Share on other sites More sharing options...
EsteeChief Posted July 3, 2019 Share Posted July 3, 2019 Thanks ! I did not see the '2018'... Link to comment Share on other sites More sharing options...
CUChris81 Posted March 10, 2020 Share Posted March 10, 2020 Marc -- Is this webinar archived somewhere? I'm highly interested in moving from 2020 to CA exclusively... I've been on these forums for an hour just reading much of what you said and I'm intrigued. Are there any other tutorials or videos in addiiton to this that you can possibly recommend? I snagged the sample files off this site but would love to see what else is available. Thanks!! Link to comment Share on other sites More sharing options...
MarkMc Posted March 10, 2020 Author Share Posted March 10, 2020 12 hours ago, CUChris81 said: Marc -- Is this webinar archived somewhere? Video is posted above. 12 hours ago, CUChris81 said: I'm highly interested in moving from 2020 to CA exclusively... Just do it. I did. I got laid off from a hi-end kitchen dealer at end of 09, started a business Jan 1 2010, switched to Chief in Dec 2010. First job in Chief was a whole house of hi end custom cabinets-kitchen, two baths, media/LR, entry foyer, Master BR, and Office. File was a mess but it helped sell the job. I credit Chief with helping me establish myself, get better work and keep afloat starting with nothing (dogged perseverance and innate brilliance may have played a role too 12 hours ago, CUChris81 said: Are there any other tutorials or videos in addiiton to this that you can possibly recommend? While there are no Chief tutorials on pricing they do offer quite a bit for kitchens. I took an online class, twice in the first year. Had my assistant take one when I was training them. They offer live classes around the country that are useful, I've sat in on some and seen lot's of presentations at shows. The rest-I read the forum everyday and have since the beginning. For years I read almost everything even if it did not appear relevant to me. Use the Reference Manual and Help both are excellent. Learn how the software thinks then use that to your advantage. IF you are doing anything in the way of better middle to hi end kitchens it's a no brainer. Maybe, just maybe, if you are a kitchen mill turning out a basic kitchen a day the other software makes sense-maybe. Link to comment Share on other sites More sharing options...
Ridge_Runner Posted March 10, 2020 Share Posted March 10, 2020 2 hours ago, MarkMc said: (dogged perseverance and innate brilliance may have played a role too Which one of those would you say played the most important role, Mark? Link to comment Share on other sites More sharing options...
MarkMc Posted March 10, 2020 Author Share Posted March 10, 2020 1 hour ago, Ridge_Runner said: Which one of those would you say played the most important role, Mark? vbg-has to be perseverance, never learned to avoid rabbit holes and only talent is I read directions. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now