1. Forums
  2. Mystery Shopping Discussion

what does your excel spreadsheet look like for shops? what do you title each of your columns?

March 31, 2012 12:36PM
i have a seprate spreadsheet for each msc, a spreadsheet for the route on the give day, a spreadsheet that keeps a running total for the month for all msc's, and one that keeps track of the whole year.

I have them all linked so when I enter info on one sheet it automatically fills it out on the others. So I just enter the info on the route sheet usually for the day, and it will fill in the info onto the others.

Makes tracking very easy when I need to find something.

= + = + = + = + = + = + = + = + = + = + = +
There are no stupid questions, but there are a lot of inquisitive idiots
==--==--==--==--==--==--==--==--==--==
When you try to please everybody, you end up pleasing nobody
Reply
Log In
x

Create an Account or Log In

Membership is free. Simply choose your username, type in your email address, and choose a password. You immediately get full access to the forum.

Already a member? Log In.

More About Excel & Spreadsheets
March 31, 2012 03:06PM
techman01 Wrote:
-------------------------------------------------------
> i have a seprate spreadsheet for each msc, a
> spreadsheet for the route on the give day, a
> spreadsheet that keeps a running total for the
> month for all msc's, and one that keeps track of
> the whole year.
>
> I have them all linked so when I enter info on one
> sheet it automatically fills it out on the others.
> So I just enter the info on the route sheet
> usually for the day, and it will fill in the info
> onto the others.
>
> Makes tracking very easy when I need to find
> something.

what program(s) do you use?
Reply
March 31, 2012 11:16PM
AlwaysAngie Wrote:
-------------------------------------------------------
> Vince, I use the MS Bible and LOVE it. It's an
> Excel sheet that has all that set up for you and I
> believe it's still only $10 and Sherry will email
> it to you. You can go to
> www.MysteryShoppingBible.com to see screen shots
> of what it looks like, the tabs, and such. She
> uses formulas so some of the information transfers
> over to the other tabs.
>
> Definitely track your mileage! And anything you
> buy for MSing. A portion of your computer is
> deductible and your cell phone, etc. Which reminds
> me I need to let my tax lady know that. I bought
> this laptop last year and forgot to add it to my
> expenses.

I just ordered the spread sheet from mysteryshoppingbible.com.
I'm terrible with records and have monthly envelopes with income/expenses on the outside with receipts on the inside for my ebay stuff.
Reply
April 01, 2012 11:07AM
rubypearl Wrote:
-------------------------------------------------------
> AlwaysAngie Wrote:
> --------------------------------------------------
> -----
> > Vince, I use the MS Bible and LOVE it. It's an
> > Excel sheet that has all that set up for you and
> I
> > believe it's still only $10 and Sherry will
> email
> > it to you. You can go to
> > www.MysteryShoppingBible.com to see screen
> shots
> > of what it looks like, the tabs, and such. She
> > uses formulas so some of the information
> transfers
> > over to the other tabs.
> >
> > Definitely track your mileage! And anything you
> > buy for MSing. A portion of your computer is
> > deductible and your cell phone, etc. Which
> reminds
> > me I need to let my tax lady know that. I
> bought
> > this laptop last year and forgot to add it to
> my
> > expenses.
>
> I just ordered the spread sheet from
> mysteryshoppingbible.com.
> I'm terrible with records and have monthly
> envelopes with income/expenses on the outside with
> receipts on the inside for my ebay stuff.

i just ordered one too. smiling smiley
Reply
April 01, 2012 02:42PM
@vince, I use excel, took some time to program it the way I wanted, but worth it as it saves me hours and hours.

= + = + = + = + = + = + = + = + = + = + = +
There are no stupid questions, but there are a lot of inquisitive idiots
==--==--==--==--==--==--==--==--==--==
When you try to please everybody, you end up pleasing nobody
Reply
Sorry, only registered users may post in this forum.

Click here to login