I hope this HTML stuff shows up! If you look at the bay totals, how do I get rid of the negative value that always carries over?
Woodlot bays addin.xls | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
7 | WoodlotBays&RainGauge | ||||||||||||||
8 | |||||||||||||||
9 | ReadingDay | Tuesday | Wednesday | Thursday | Friday | Friday | Monday | ||||||||
10 | Morning | Morning | Morning | Morning | Afternoon | Morning | |||||||||
11 | Bay1 | Bay2 | Bay3 | Bay4 | Bay5 | Bay6 | RainGauge | ||||||||
12 | Week | Monday | r/g | Tuesday | r/g | Wednesday | r/g | Thursday | r/g | Friday | r/g | Sat/Sun | Weekly | ||
13 | 29/7/02-4/8/02 | 50,001,000 | 50,002,000 | 50,003,000 | 50,004,000 | 50,005,000 | 50,006,000 | ||||||||
14 | 5/8/02-11/8/02 | 50,007,000 | 50,008,000 | 50,020,000 | 50,025,000 | 50,040,000 | 50,070,000 | ||||||||
15 | 12/8/02-18/8/02 | 50,090,000 | 50,110,000 | ||||||||||||
16 | 19/8/02-25/8/02 | ||||||||||||||
17 | 26/8/02-1/9/02 | ||||||||||||||
18 | YearlyTotals | 21,000 | 22,000 | -50,097,000 | 6,000 | 16,000 | 31,000 | ||||||||
Sheet1 |