Candle Business Training.com
 

Roy Juers & Stephanie Sterling,
Senior Director

 Inc Inc
"Flame and Fortune"
Team Founders

Thanks for all your patience, enthusiasm, suggestions, donations, and testimonials!

It means so much!

REMEMBER:
The Tracker is an Excel 2003-based document.

Your computer must have Microsoft Excel
©, or a program capable of "reading and writing" Excel documents
(such as OpenOffice
©)
in order for you to use it.

 

Getting Started Using Your
Candle Business Tracker Spreadsheet

The Candle Business Tracker (or CBT) is easy-to-use, even for beginners, so long as you take the time to familiarize yourself with it, and review the Training Series.

There are a few basic things you should know, and do, to get started on the right track when you begin using it.  Here are some things that will help you get started;

Please review them all, before contacting us for support!  That will help us a lot!

--------------------------------------------------------------

Go Through the Training Lessons-

Even if you're experienced with Excel®, it helps to go through the training lessons  on the Training Audio Series page.

You can probably skip the Excel Basics lesson if you know Excel pretty well, but it helps to familiarize yourself with all the functionality of the Tracker, before you contact us for support.   Many answers can be found there.

Top of Page^

--------------------------------------------------------------

Size Matters

The CBT for 2009 has grown into a whopping 8.12 MB, due to the 12 new 2008 scents in it, among the other new stuff I added.  So downloading it, even with high-speed internet will take 15-30 seconds... for those with dial-up, you might as well get a cup of coffee or throw some laundry in, 'cause it'll take awhile!   At 56Kbps (Dial-up speed), it'll take at least several minutes.

The CBT is so big, it can take Excel 10-20 seconds, just to open it.  This is normal!

 --------------------------------------------------------------

Entering Your Inventory into the CBT for the First Time:

When you first start using the Tracker, here's what you'll want to do first:

  • Use a sheet of paper to tally all products you currently have, but keep any Candle of the Month (COTM) products separate.

  • Open the CBT and click on the JAN tab.

  • Enter your inventory (except the COTM products) in the Beginning Inventory column of the JAN tab of the spreadsheet.

  • Add your COTM products in the appropriate tab of the month they were released, on the day your COTM is run (typically 1st, 5th, or 10th).

  • Add COTM scents names, in the month they are released.  Add the name just one time, in Column B, where ReplaceNameHere appears sideways. Just click on that cell, type the scent name, and hit Enter.   You'll notice the scent name will then copy throughout the rest of the CBT.

  • Enter your mileage from business trips, and see it automatically transfer to your expense spreadsheet

  • Enter your State Sales Tax rate in the CUSTOMERS (7.5% is pre-populated, but you can change it to your current rate).

Top of Page^

--------------------------------------------------------------

Transferring Inventory from 2008 to 2009

This is still a manual process, but it's very simple.  To move your Ending Inventory from 2008 to the Beginning Inventory of 2009;

  1. Print the 2008 SCENTS tab, which will contain your Ending Inventory figures for all products currently in production, as of 12/31/08.

  2. Open the 2009 Tracker, and be sure to make sure you are in the JAN tab.

  3. Manually type in your Inventory from the SCENTS tab printout, into the 2009 Tracker's Beginning Inventory column of the JAN tab.

Top of Page^

--------------------------------------------------------------

The Most Common Misconception About Entering Data:

If you try to enter something in, and you get a warning from Excel that says,
"The cell you are trying to change is protected and therefore read-only...",
it simply means the data you're trying to enter really belongs in a different place.

Hidden underneath the hood of the Tracker are many complex formulas.  You don't have to worry about them, but they are locked to prevent them from being deleted or corrupted by accident... hey, it happens!

So you won't need the password, and there should almost never be a need to unlock the document!

Please go through the audio training lessons, to avoid having trouble in this area.

Top of Page^

--------------------------------------------------------------

Backup, Backup, Backup!!

Remember to back up a copy of your CBT to an external hard drive or a rewritable CD, if possible, every time you make changes to it.  It's easy to do, and will soon become habit.

When you're finished working with your main version, hit "Save", and then, hit "Save As...", and save it as your backup copy (whatever you decide to call it).

Unfortunately things happen with computers, and I can't stress enough, the importance of backing up all your data.  Typically, an external hard drive large enough to store your entire computer's capacity (say 500GB or so) can be had for under a hundred bucks... a small price to pay for security if the Tracker crashes, or if your computer crashes, or otherwise gets destroyed or stolen.

--------------------------------------------------------------

Donations for Future Enhancements

Many of you know, it took months & hundreds of hours to create the Tracker, its  complete support website, the Audio Training Lessons and the Tax Deduction Guide.  Maintaining, updating and testing them all simultaneously has been a massive project.  Between that, and supporting everyone who uses them, it's consumed an incredible amount of time over the past 18 months or so.

Please consider donating towards the Tracker's future.  Think about the value these tools provide for you, the time invested in creating them, and what it might normally cost to have a professional build them.  It's not required, but any donation is greatly appreciated.  If you choose to give, we thank you in advance!!

To donate, you can either;

  • Send a check to Roy Juers, PO Box 4012, Woodbridge, VA 22194, or

  • Donate electronically using the PayPal Donate button below:

 

Top of Page^

-------------------------------------------------------------

Getting Support-

I'm here to help answer any questions you have about using the CBT, but I can't  diagnose things that may be happening on your computer itself.  I can assist you better if you provide me with a little information... things like:

  • Which version of the CBT you are currently using?

  • What kind of computer you use (PC or Mac) and what Operating System?

  • Do you have Microsoft Excel® installed on your computer, and if so, which version (2003, 2007, etc.)?   Or do you have an Excel-friendly program like Open Office installed on your computer?

  • What tab of the CBT you were in when you began experiencing trouble?

  • Exactly what you were trying to do when you began experiencing trouble?

  • Have you gone through the Training Audio Series yet?

This information helps me a lot, so when writing for support for the first time, please try to include that info. 

Top of Page^

--------------------------------------------------------------

Do Not Call the Company for CBT Support-

While this website is linked to, through your company back office, and even though the company has approved this document, their Customer Service and IT Support teams cannot provide support for the CBT, and this is by design. 

One thing I wanted to ensure, is that the company doesn't get burdened with questions about the CBT, because they don't know the document, and their time is too valuable helping us maintain our distributorships. 
That's why the CBT document itself is not in the back office.

Since this website was built exclusively for CBT distribution, training and support, it's here where you should initiate any contacts to get help... and I'll be happy to provide it... this baby's my pride & joy, so I'd love to see lots of people using it!

--------------------------------------------------------------

 

 

Quick Links:

Main Page

Need Help?  Contact Me Directly for Quick Answers

Donate via Pay Pal

Get Started

How-To Section

Questions & Answers

Site Map

Suggestions for Future Enhancements

Support

Tips & Tricks Archive

Training Audio Series

Updates

What Goes Where??

 

Main Page ~ Contact Us ~ Donate ~ Get Started ~ How-To
Q & A ~
Site Map ~ Suggestions ~ Support ~ Tips & Tricks
Tracker Training ~ Updates ~ What Goes Where?

 

 

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,
 Flame and Fortune Team, Mia Bella Team Builders