Home Articles Forums Gallery Marketplace Videos

WoodCentral Forums

Knowledge You Can Build On — Est. 1998

Need a tree taken down or milled?

OT Excel Question OT

Posts

OT Excel Question OT

#1

OT Excel Question OT

Barbara Gill

I am trying to create a spread sheet that will compute flow based on a meter reading. The problem I am running into is that the meter is not read everyday so the formulas in the calculating cells need to take that into consideration. I have searched the help but so far I am unable to find the answer.

If anyone knows how to do this could you email me? Thanks.

Re: OT Excel Question OT

#2

Re: OT Excel Question OT

Stuart Johnson

Barbara, it's been a bunch of years since I've done any spreadsheet work so somebody else will hopefully have a better answer.

It sounds like you need to know the number of days between meter readings. If so you can enter the dates (be sure your cells are formatted date) and do a calculation to determine the number of days. Use that number in your ending formula. When calculating the number of days be sure to take into account if you want them inclusive. For example 6/1/2012 minus 5/1/2012 is 31 but if you want to include both 6/1 and 5/1 you need to add 1.

Re: OT Excel Question OT

#3

Re: OT Excel Question OT

Barbara Gill

The gap varies Stuart. I think it is an "If--Then" formula but I need to find the part that tells the formula to skip that cell and move on.

Re: OT Excel Question OT

#4

Re: OT Excel Question OT

Dinyar Chavda

This should work. Just keep copying the formula down (in the flow column).

Re: OT Excel Question OT

#5

Mike Mills

Re: OT Excel Question OT

mike mills

Not sure if this will help or not...

A1 would be the 1021 or whatever the ititial reading is

A2 would be the first new reading of 1345

B2 would be = (A2–A1) Copy down (Fill) the formula for all of column B

For days missed row 3, 4, and 5 copy down the last value (fill) which is 1345 (or retype the new number in each block)

New data on day five 1657

You can use the Average command in Column B, in this case 127.20 if you wish.

Chart would look like this..

1021 First Data

1345.0 -------324.00

1345.0 ----------0.00

1345.0 ----------0.00

1345.0 ----------0.00

1657 ---------312.00

-------------- 127.20 Average

Re: OT Excel Question OT

#6

Re: OT Excel Question OT *LINK*

Bill Turpin in WNC mountains

Convert the date to Julian date. This is the numver of the date in the year. Do a Google search on J dates. December 31 is 365.


Julian convertor

Re: OT Excel Question OT

#7

Thanks Everyone

Barbara Gill

I didn't want to take up space explaining that it is a form to be submitted to the state and the other variables so none of the suggestions will work. Randy has contacted me by email and is helping. Thanks so much.

Re: OT Excel Question OT

#8

Re: OT Excel Question OT

Dave Paine

Barbara, if Randy is not able to solve send me an email.

I am an expert in Excel and Visual Basic macros. This may need VB rather than formula in the cell. VB can easily do a "for each" loop and test if the contents of the cell are blank, > a value etc.