MarkMc

Web Meeting-Using Chief to get to a cabinet order.

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

Update to to the plan for this-

  1. Cabinet defaults setting up OIP fields and some macros. The macros are very simple since I'm no wiz in the dark arts.
  2. Schedule default and how to get an alternate for use in pricing (and where the rocks are so you don't trip)
  3. 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.
  4. Saved cabinets in the user library, how much data to include when. Using replace from library.
  5. Change schedule to alternate, copy schedule, paste to sheet. Revert schedule to default for printing.
  6. 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)
  7. Using the sheet data in an online ordering system
  8. Using the sheet data in 2020
  9. 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.

  • Upvote 1

Share this post


Link to post
Share on other sites

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:

  • 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.

 

 

  • Upvote 1

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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.

  • Upvote 2

Share this post


Link to post
Share on other sites

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.  

 

 

  • Upvote 1

Share this post


Link to post
Share on other sites
9 hours ago, johnny said:

I would love to attend!

Got your email,(thought that was you, just saw this) invite sent

  • Upvote 1

Share this post


Link to post
Share on other sites

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. 

Share this post


Link to post
Share on other sites

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. :)

Share this post


Link to post
Share on other sites

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.

  • Like 1

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
9 hours ago, 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.

Here are the files from the meeting. 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. In any case the files might point someone in the right direction.

Samples_JZ.zip

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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

 

Share this post


Link to post
Share on other sites
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. 

Share this post


Link to post
Share on other sites

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!!

 

 

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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? :)

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

  • Member Statistics

    27825
    Total Members
    6254
    Most Online
    ChiefDallas
    Newest Member
    ChiefDallas
    Joined
  • Similar Content

    • By Renerabbitt
      After Photo
    • By CHROMATICGA17
      Need to set default pricing for product/materials to use as default template. This way generating my materials list will be quicker.  I do not want to enter vendor specific pricing.  I want to enter labor pricing for specific materials.  I want this to default to my setting per item/sf/etc. each time i choose that template to start a plan. 
       
      I hope this question makes sense.  Please help.
    • By AlisonWD
      Hello, 
      I am applying a wood material to kitchen cabinets and the wood grain is going vertical in the doors and horizontal in the drawers.
      I checked the cabinet specifications and it shows only one material for doors.
      How can I do the wood grain the same direction in the doors and drawers?
      Thank you. 

    • By MPhillips
      Gentlemen,
       
      I have placed a dishwasher in a cabinet, and it fits fine, but when I do an interior iso, tt move to the back of the cabinet.  I pull back into place, but it moves on its own back to the translated position.  I have included two screen snips showing the problem.
       
      Does anyone have an idea of what I am doing wrong.
       
      Merlin