MYSTERY SHOPPING THREAD 19 - please don't mention client names or fees on here!!

Skiergirl

Amber Arch have paid today

StacFace

kst101 wrote: »

Am getting a little worried as Gap sent me an email about a burger shop I did for them checking timings and what I was wearing. Have replied (did not fit their description at all) and they have said it doesn't fit and they will check CCTV.

So if they do sack me, will I still get paid for May jobs I have done (at least I got paid for April jobs today).

I had this on my first GAP job, which was a burger one, told them the description didn't match me and pointed out how (I have a different hair colour to description and didn't have a handbag with me that day). They didn't reply back but I noticed the job status changed to 'rejected' in my completed jobs. I emailed asking for it to be changed as the job wasn't cancelled/rejected and they didn't reply, but I was paid, job still says 'cancelled/rejected' in my job history though.

pinkprincess39

pinkprincess39 wrote: »

i use microsoft excel to log my work. It was sent to me with formulas already included. Now that mileage has gone up to 45 p mile I need to change the column to reflect this. I am able to do each line 1 by 1 but cant see how to change the entire column! Anyone know how to do this? Thanks in advance!

sorry to bump! Anyone???

Miss_Qwerty

pinkprincess39 wrote: »

sorry to bump! Anyone???

Are you talking about Monkeys spreadsheet? It's on one of the other tabs but i'm not home so can't tell you the name of it. I think it might be under the personal details one but not 100% sure.

pinkprincess39

Miss_Qwerty wrote: »

Are you talking about Monkeys spreadsheet? It's on one of the other tabs but i'm not home so can't tell you the name of it. I think it might be under the personal details one but not 100% sure.

no its not monkeys 1. but thanks for replying

Lil_Me_2

pinkprincess39 wrote: »

i use microsoft excel to log my work. It was sent to me with formulas already included. Now that mileage has gone up to 45 p mile I need to change the column to reflect this. I am able to do each line 1 by 1 but cant see how to change the entire column! Anyone know how to do this? Thanks in advance!

When you click on the box in the column you should see the formula that's been used. e.g "=(K2*0.4)" the next box down would be "=(K3*0.4)".

1. Change the 0.4 to 0.45 in both of these boxes.
2. Highlight both of these boxes.
3. Hover over the bottom right corner of these boxes and you should see a bold + sign.
4. Click on this + sign, and drag it down to cover all of the columns.

Excel should recognise that the difference in the two boxes is the K2 to K3 element of the equation and carry this down through the rest of the column.

Hope that works!

TractorGirl327

pinkprincess39 wrote: »

i use microsoft excel to log my work. It was sent to me with formulas already included. Now that mileage has gone up to 45 p mile I need to change the column to reflect this. I am able to do each line 1 by 1 but cant see how to change the entire column! Anyone know how to do this? Thanks in advance!

Lil_Me wrote: »

When you click on the box in the column you should see the formula that's been used. e.g "=(K2*0.4)" the next box down would be "=(K3*0.4)".

1. Change the 0.4 to 0.45 in both of these boxes.
2. Highlight both of these boxes.
3. Hover over the bottom right corner of these boxes and you should see a bold + sign.
4. Click on this + sign, and drag it down to cover all of the columns.

Excel should recognise that the difference in the two boxes is the K2 to K3 element of the equation and carry this down through the rest of the column.

Hope that works!

I've just given you a slightly different "Elite" way of doing it!!!

pinkprincess39

Lil_Me wrote: »

When you click on the box in the column you should see the formula that's been used. e.g "=(K2*0.4)" the next box down would be "=(K3*0.4)".

1. Change the 0.4 to 0.45 in both of these boxes.
2. Highlight both of these boxes.
3. Hover over the bottom right corner of these boxes and you should see a bold + sign.
4. Click on this + sign, and drag it down to cover all of the columns.

Excel should recognise that the difference in the two boxes is the K2 to K3 element of the equation and carry this down through the rest of the column.

Hope that works!

thanks so much!!! worked xxxxxxxxx:j

debsjc

I've recently submitted my first GFK reports, and would appreciate help with a couple of questions please.

How will I know if they are happy with my report, do they contact me at all after checking it?

Do GFk often ask to see the paper report they ask you to fill out, as a reminded to yourself for the online input? I did complete it right after the assignment, but it's not very neat & tidy.

mimi1234

Has anyone had the paperwork through for the phone shops on TNS? I'm still waiting and my first visit is this Friday! Eeeek.