We do our handover meter reading sheets on the lap top using Excel.

We print off a copy on site for the system records and store a copy at the office

i want my spread sheet to work out standby hours

So here go's

Lets say K5 = load no mains

and K8 =  Battery Size

i want to make excel do this:  Sum=K8/0.K5 giving me approx standby hours.

if the load is 500ma then it needs to be 0.500 in the formula..  

I am not very good with excel.

But the above wont work, Any ideas on how to do this

use brackets

if K5 is 500 then that is realy 0.500

so
 =(K5/1000)

Yes but the sheet is a blank so i need it to work out a reading from any install.

you want the whole formula?

yep as i cant get my head round it   

i know i need to use brackets

James I cant attach excel  can you make it so I can or should I just email whistle? ?

whistle check your email theres one I made earlier!

Please peter

info@wolfsecurity.co.uk

Cheers peter

xls added so upload away
but
Capacity in Amp / Day Current in Amps = Standby Time

this is very approx and needs factors for aging and a correction factor as all A/h rating assume a 20 hour discharge

Sorted it

Its SUM=(K31/K21*1000)


This works every time


thanks to all that looked anyway.

I like these simple questions with several difficult 'answers'!

Who wants my (old) mileage and time sheets for fuel and overtime?

Courtesy of Longcross?

cheers

Why the hell do we want to know where you've been?

Cos ya pedantic person i have the excell docs used for time sheets and ect.
Your loss

xxxxxxxxx

cheers

Dont forget the Karma button

I would like a look at the time sheet mate.

cheers Andy

I'd like a look at the your wage slip!

Minimum Wage mate, being a director you would be daft to take anymore.

I'd like a look at your divvy*










* as individend not the apprentice