O T: Spreadsheet help

Hi

You don't say what to do if C23 is not less than 670. Assuming '0' for now:-

=IIF(c23

I'll go one further and say that I have no idea whatsoever on how to use spreadsheets. I have Microsoft Excel as part of the Office suite but never used it - opened it once, scratched me 'ed, and shut it down again :o) So, if anyone would be considerate enough to write out a complete step-by-step idiots guide on how to do this from scratch, I would be eternally grateful.

Cheers,

Pete

I suspect possible solutions depend on whose spreadsheet app you're using, and you don't say...

Hi Pete,

I just did a google and came up with this for you:

Jim

Using OpenOffice Spreadsheet prog comes up with err509 Steve

Kindest regards,

Jim

Using OpenOffice spreadsheet program show ERR508 for the above

Assuming you're using excel, and that the 670 threshold applies to each = charging period (qtrly?), and noting the beauty of s/sheets is you can = just change selected variables when appropriate, I would suggest...

Label stuff (for future ref) e.g.

----------------------------------------- cell C1 =3D Price 1 (pence/KwH) cell C2 =3D Price 2 (pence/KwH) cell C3 =3D Threshold cell C5 =3D KWh used cell C7 =3D Total price

Enter inital values in adjacent cells, e.g.

-------------------------------------------------------- cell D1 =3D 0.653=20 cell D2 =3D 0.050 cell D3 =3D 670 cell D5 =3D 1200 cell D7 =3D =3DMIN(D3,D5)*D1+MAX(0,D5-D3)*D2

Explanation....

--------------------- D2 - whatever price the "excess" units are charged at

D5 - your actual consumption

D7 - the "Min" bit caters for actual total consumption being less than =

Other things...

-------------------- You'll also need some formulas to convert meter reading to KWh, via = "correction factor", "calorific value", "feet to metres" etc....

And at the end, add any standing charge and 5% VAT.

Tweak number formats so you get req'd number of decimals etc.

Take care not to mix up pounds and pence ...!

HTH - but re-post if anything's not clear.

--=20 Martin

C32 is the cell which deals with KWh above 670, thus:

=(c23-670)*c29

Where c29=0.03557

Thanks Jim. I'll give the pdf a good coat of looking at but I don't know as I'm interested enough to buy a book - after all, I've managed 51 years without knowing how to use spreadsheets. It just seemed that working out gas and electric costs may be OK but I can't think of anything else I'd need to use a spreadsheet for.

Cheers mate and good luck in sorting it :o)

Providing C23 >=3D 670 .... ;-)

--=20 Martin

Fine here using OO 3.0.1 on Ubuntu 9.04.

This might help

Things are different in Excel, but in cell c31 try

=IF(c23

Excel - far and away best of MS's efforts IMO. I don't think that pdf will be too useful except as a reference - try to learn using an example as the basis - especially if you already use Word (many of the menu commands are similar).

Rob

I suspect (in excel) you need to use comma separators, not semi-colons.

Also, "" will normally display 0, so I suggest use 0 anyway - and hence = ensure the cell is numeric, for any subsequent calcs whcih depend on it.

--=20 Martin

I think =IF(B3

In Excel you would :-)

OpenOffice uses semi colons not commas =MIN(C23*C27;670*C27)

or even

=MIN(C23;670)*C27

Works fine with commas here; straight out the box, no changes.

OO 3.0.1