|
Candle Business Training.com |
|||||
|
Candle Business Tracker Questions & Answers So many of you have asked valuable questions, either about how the Tracker works, whether certain features are able to be added, or to check whether an unexpected result might be due to a programming error, etc. As a former IT guy, I know that no one is better at identifying issues and suggesting enhancements better than the people in the field. So for that, we honor those who've given their opinions or advice, by creating this Q & A section. Hopefully if someone else has the same question, they'll have this as a resource, and they'll have you to thank for it! ------------------------------------------------- Here's some questions received so far. Click on them to see the answers: ----------------------------------------------------------------
Annette
Hoffstatter writes: A1) Great question, Annette! In the beginning, I didn't really think about printing formats, because I was so busy with everything else, I barely gave any thought to how it would print until after I already released the document. Silly me! Yes there IS a way to format the spreadsheet so it will print just 1 page wide. I've prepared instructions on how to do it, and posted them in the How-To page of this site...
----------------------------------------------------------------
---------------------------------------------------------------- ---------------------------------------------------------------- A Distributor wrote: A4) Since Mia Melts are sold by the company in bags of 10, the Tracker is programmed to deal with Mia Melt inventory by the bag of 10. You'll notice, though, that in all Mia Melts rows of the Tracker, there is a decimal point, which helps you as an individual, manage Melts individually. For example, I buy 10 bags of melts from the Back Office. I add those 10.0 bags into my inventory. I then use 6 melts out of a bag to make samples. I then put 0.6 in my PROMO column, which leaves me with 9.4 bags remaining. So if you break apart bags of Mia Melts for any reason, treat each individual melt as 0.1, or one-tenth of a bag. ---------------------------------------------------------------- Q5) How do I enter my Candle of the Month each time? A5) Entering COTM scents is as easy as it can possibly get in the Tracker, because you only need to enter the scent name one time, and it copies throughout the rest of the year's remaining months automatically. It will also copy to the COTM section of the SCENTS tab. To enter the scent name, go to the month's tab where the COTM is needed, and look in column B, where ReplaceNameHere appears sideways (vertically);
Then, simply type in the scent name, and despite seeing the name entering in a little weird looking, as you can see below, everything will be okay;
Hit Enter, and the name appears "across the board" in all the appropriate places:
---------------------------------------------------------------- Q6) Can I delete the Retired scents I see, since I don't have any and won't be getting any? A6) Yes, if you choose to, you can delete or add Retired scents to the RETIRED tab. Any changes you make to the RETIRED tab will be automatically applied to the SCENTS tab's Retired Scents section. If you see zeroes in the SCENTS tab, it's because there's no scent name for the Tracker to "bring in", from the matching row of the RETIRED tab. Don't Worry! All you have to do is re-sort the RETIRED tab, and the zeros will drop to the bottom of the SCENTS list. You can then hide the rows you're not using. ---------------------------------------------------------------- Q7) I have some scents that are discontinued in my inventory, but I don't see their names on the RETIRED tab... can I add discontinued scents to the RETIRED tab? A7) Yes. I was only able to add the scents that I knew of, when I built the Tracker for the first time. If you have already-discontinued scents that are not shown, you can add them to the list, and then re-sort the list, so they're in alphabetical order. However, don't add newly-announced discontinued scents during the year. Keep them in the main list of scents, and the following year, the scent will be moved to the RETIRED tab. ---------------------------------------------------------------- Q8) I can't seem to open the Tracker at all... what gives? A8) INSERT ANSWER HERE ---------------------------------------------------------------- Q9) How Do I Transfer My Inventory From Year to Year? A9) At the moment, the only way to transfer Ending Inventory from one year, to the Beginning Inventory of the next year, is to type it in manually. The easiest way to do this is to print out the SCENTS tab, which has all the Ending Inventory numbers for all the fragrances, and all the Bakery & Boutique products (at least the ones in production at the start of the year). Then, just add those amounts to the new year, crossing them off your print as you go. ---------------------------------------------------------------- A Distributor wrote: A10) INSERT ANSWER HERE ---------------------------------------------------------------- A Distributor wrote: A11) INSERT ANSWER HERE ---------------------------------------------------------------- A Distributor wrote: A12) INSERT ANSWER HERE ---------------------------------------------------------------- A Distributor wrote: A13) INSERT ANSWER HERE ---------------------------------------------------------------- A Distributor wrote: A14) INSERT ANSWER HERE ---------------------------------------------------------------- A Distributor wrote: A15) INSERT ANSWER HERE ---------------------------------------------------------------- When you go to the website to download a new version, just check the date extension first (at the end of the file name)... If the date on the website is later, that'll mean there's an updated version available for you to download... The Audio Series pages will give you an overview of how to use the individual tabs of the spreadsheet, until it becomes second nature. I recommend going through the entire series of Lessons at least once before you dig into the Tracker. We hope to host another conference call soon, to go over the spreadsheet in more detail. We'll send an announcement through all the Yahoo Groups we belong to. Thanks for all your questions... Keep 'Em Coming!
------------------------------ Roy |
|
|||
|
Main Page
~
Contact Us ~
Donate
~
Get Started
~
How-To
Roy Juers & Stephanie Sterling, Senior Director Spreadsheet Author, The Flame and Fortune Team Founders PO Box 4012, Woodbridge, VA 22194 (703) 497-4727 E-Mail: RoyJuers@mac.com
© All Rights Reserved, MMIII-MMX
Candle Business Tracker,
Tax Deduction Guide,
|
