Graph or Spreadsheet

[SteveM]

Big H .... do you have your initial week figure set to 0 or 1? I have mine set to 0 (must be something to do with being a programmer .... everything always starts at 0!!). The way I was looking at this was that the week number was an "end-of-week" ....

I can and will fix this though - it is a simple fix.

[Big H]

Originally Posted by SteveM

Big H .... do you have your initial week figure set to 0 or 1? I have mine set to 0 (must be something to do with being a programmer .... everything always starts at 0!!). The way I was looking at this was that the week number was an "end-of-week" ....

I can and will fix this though - it is a simple fix.

Cheers Steve - I've changed it manually - it was becuase the form jump from week "0" to week "2" when you input your initial details

Have emailed this to everybody in my office who is now using it !!

Top drawer

[SteveM]

Big H - I have fixed this issue. You can now start from 0, 1, whatever you want and it should work okay.

General info for everyone - if you want the graph to just indicate your progress and not "plummet" off the bottom of the graph, all you need to do is to remove the incomplete weight tracking lines from the sheet and the graph will correct itself.

The reason that the graph plummets off the bottom is that it is set to graph the entire data area above it, and if you have lines in there with zero weight ......

What I tend to do is to only have lines filled out, and then cut/paste the last line to create the next one after my weigh-in:

1) Right-Click the last complete weight row in the row number column (far left) (e.g. Row 15)
2) Select Copy from the pop-up menu
3) Right-Click the next line under the data block in the row number column (far left) (e.g. Row 16)
4) Select Insert Copied Cells from the pop-up menu
5) Edit the Date (Column C), and weight (Columns D and E)

[Big H]

Great stuff - cheers !

Are you ssing?

[SteveM]

I was until today - I am moving to 790 for a couple of days, then to 1000, and next week I am working on my uncles farmhouse in France - mixing concrete, shifting rocks, slating a roof, etc etc. I am going armed with enough packs, but I think that the intensity of the work will require a higher calorific intake to keep me going. I will be back to SS on Monday 1st October though.

[Big H]

Originally Posted by SteveM

I was until today - I am moving to 790 for a couple of days, then to 1000, and next week I am working on my uncles farmhouse in France - mixing concrete, shifting rocks, slating a roof, etc etc. I am going armed with enough packs, but I think that the intensity of the work will require a higher calorific intake to keep me going. I will be back to SS on Monday 1st October though.

Yes mate - probabaly do yourself some damage if you try and SS when doing that much exercise. Hard to start from scracth again though (i.e getting back to Ketosis)

[SteveM]

Oh, I know, I know

I suffered this time, and even though I am in ketosis now, I still have the hunger pangs and cravings which make this diet hell on Earth.

Hopefully if I start back 100% on 1st, I can be back in ketosis by 3rd .... If I manage my intake properly so that I only eat enough to stop light-headedness and keep the water intake up, hopefully my body will keep using up the glycogen stores ....

[Dub07]

Originally Posted by SteveM

if you want the graph to just indicate your progress and not "plummet" off the bottom of the graph, all you need to do is to remove the incomplete weight tracking lines from the sheet and the graph will correct itself.

the plummetting line is my favourite thing about the graph, Steve

I'm not changing it. Nope.

[SteveM]

I must admit, I left it there for a while too, but then after a time it started to annoy me ...... being a programmer, it just got to me because I "knew" it was a bug, and I just cannot leave those things out there once I know they are there

[szoes]

Thank you so much !!!!!

You have just saved my CD diet

Seeing it in a graph kicked my butt

Thanks again

[SteveM]

I think I will start putting "Programmer By Appointment to Mini-Mins" after my name

It makes me so happy that this is proving so useful to so many people. I now wish someone had asked the question sooner .....

I just didn't think ..... apparently that is my biggest problem according to my wife

[Big H]

I've put it on the 'Pink' Forum too - everybody is loving it over there too

[wannalose8stone]

wow. only just seen this. Absolutely brilliant. Im going to spend some time putting my losses in as it will be great to chart the progress.

You are a genius. Thank you

[SteveM]

What the heck is the pink forum????

[Big H]

Originally Posted by SteveM

What the heck is the pink forum????

Lol

Cambridge Dieters - powered by vBulletin