Tesco/Asda Pricechecker Thread - part 3

scotsgirl_3

Picasso7 wrote: »

I'm having fun with the offline spreadsheet!

At last I have made it go into English. If you are having problems, go to your iGoogle home page and explore all the settings options you can. (Click the little round gear icon if you can see it.) You'll eventually find some account settings and document settings. Change it to English, unless you actually want it in Chinese, Scotsgirl!

Someone asked if you can make it show more rows. There's a box in the top right which says 'rows per page'. To the left of it, it tells you in bold how many lines there are. The version I am viewing says 1-250 of 410. Change the rows per page to 500 and you'll see everything.

Thank you to petrolman for explaining how to save the spreadsheet as something sensible. That only worked for me when I was able to change it from simple view to spreadsheet view. Then at the top of the spreadsheet, not at the top of the internet browser, I got the menu which says File (Edit) View etc. That enabled me to download it as Excel, which is what I wanted to do.

Apologies if everyone knows all this and it is just me who was having problems.

I can't see any indication of when the offline version was saved. If it isn't there, is it possible for editors to create a new row at the very top of the spreadsheet with a cell containing the date and time it was last edited? There are two ways of doing this simply. One is to type =NOW() and the other is to click insert, function, click 'more', click 'date' and then double click the now option in the right hand column. I am presuming this will remain static when it is saved as the offline version but I don't actually know that.

And thank you, everyone, for all the work involved in this. I, for one, am very grateful.

No No, mine was set to English, it just kept changing languages every time I opened it. I had japanese, chinese, spanish, to name but a few. It changed back to english without me doing anything

MillicentBystander

xxxxxlollyxxxxx wrote: »

Must admit the lamb rack does look nicer & meatier in A;)

Aye, if only it was free

scotsgirl_3

Picasso7 wrote: »

I'm having fun with the offline spreadsheet!

At last I have made it go into English. If you are having problems, go to your iGoogle home page and explore all the settings options you can. (Click the little round gear icon if you can see it.) You'll eventually find some account settings and document settings. Change it to English, unless you actually want it in Chinese, Scotsgirl!

Someone asked if you can make it show more rows. There's a box in the top right which says 'rows per page'. To the left of it, it tells you in bold how many lines there are. The version I am viewing says 1-250 of 410. Change the rows per page to 500 and you'll see everything.

Thank you to petrolman for explaining how to save the spreadsheet as something sensible. That only worked for me when I was able to change it from simple view to spreadsheet view. Then at the top of the spreadsheet, not at the top of the internet browser, I got the menu which says File (Edit) View etc. That enabled me to download it as Excel, which is what I wanted to do.

Apologies if everyone knows all this and it is just me who was having problems.

I can't see any indication of when the offline version was saved. If it isn't there, is it possible for editors to create a new row at the very top of the spreadsheet with a cell containing the date and time it was last edited? There are two ways of doing this simply. One is to type =NOW() and the other is to click insert, function, click 'more', click 'date' and then double click the now option in the right hand column. I am presuming this will remain static when it is saved as the offline version but I don't actually know that.

And thank you, everyone, for all the work involved in this. I, for one, am very grateful.

Adding the link in case it helps anyone -- that one may take you straight to the spreadsheet view, by the way.

BTW, this isn't the up to date link. There is a revised version the update link is in post 2 .It is down for a couple of minutes but will be back soon. Would you mind removing this link.

Picasso7

scotsgirl wrote: »

No No, mine was set to English, it just kept changing languages every time I opened it. I had japanese, chinese, spanish, to name but a few. It changed back to english without me doing anything

I'll just have to hope mine doesn't do daft things like that!:rotfl::rotfl::rotfl:

MillicentBystander

Voucher_Queen wrote: »

Price Unchanged

Good basket filler for anyone wishing to top up the DD

Princes Wild Red Salmon 213g T £3.98 A £1.50 DD = 98p profit

:j

We now have a designated Princes Red Salmon Cupboard in our kitchen full of these . Serves T right - if Asda can sell 'em at £1.50 how much are T making at £3.98 from the regulars who know no better?

Picasso7

scotsgirl wrote: »

BTW, this isn't the up to date link. There is a revised version the update link is in post 2 .It is down for a couple of minutes but will be back soon. Would you mind removing this link.

Have done! Sorry...

brand8

i do hope our friday vouchers come today with yesterdays i hope they are early today have parents evening tonight and want to shop b 4 that

Purple1974

brand8 wrote: »

i do hope our friday vouchers come today with yesterdays i hope they are early today have parents evening tonight and want to shop b 4 that

My Sunday vouchers came in, no email, but I checked it again and was able to print it out here at work, but my Friday ones are still missing

KingLarsson

MillicentBystander wrote: »

We now have a designated Princes Red Salmon Cupboard in our kitchen full of these . Serves T right - if Asda can sell 'em at £1.50 how much are T making at £3.98 from the regulars who know no better?

yep - i love red salmon, and the date on it is 2015 so quite safe to stock up, what a rip off MR T

cairnx

anyone know if muller rice is treated as a different product line to muller crunch corners for multi buy offers? - could i buy 3x rice and 3x corners without getting 4 for £2 ?