> .- \pPeter Ba== (#8X@"1
Arial1
Arial1
Arial1
Arial1
Arial1
Arial1x
Arial1x
Arial1
Arial19
Arial19
Arial1
Arial1
Arial1
Arial1
Arial10
Arial1
Arial1
Arial1
Arial1
Arial1$
Arial""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-""#,##0.00 + ) , * 1 ,@@ @ P @ 1 l@@ `@ `P @ ` @ h d 1 d hA `A "x@@ A "x@ @ A "x@ @ A "x@ @ A "x@ @ A ,"t@ @ A "|@ @ A "|@ @ A "|@ @ A "|@ @ A "x@ @ A "x@ @ A "p@ @ A "p@ @ A "x@ @ A "x@ @ A "x@ @ A "x@ @ A "x@ @ A ,"t@ @ A ,"|@ @ A ,"|@ @ A 1 l h #t l h h #| l !x
h
!x
l "t h !x l l h !x #| #| h !x ,!t , d , l l + l + | l "x "x "xQ@ @ A "tQ@ @ A "|Q@ @ A "|Q@ @ A "|Q@ @ A "|Q@ @ A "|Q@ @ A "|Q@ @ A "xQ@ @ A "xQ@ @ A "|Q@ @ A "|QQ@ @ A "x@ @ A "x@ @ A ,"|@ @ A "x@ "x "| "| "| | ,!| "| , l , l "| 1 l ,"| #p l h "x "x@ @ "x@ @ "xQ@ @ "t "p@ @ "p@ @ "tQ@ @ "p "x@ @ "x@@ "|@ @ "|Q@ @
"x "x@ @ "x@ @ "x@ @ "x@ @ "|@ @ "|Q@ @ "x "| "x@ @ "x@ @ "|@ @ "|Q@ @ "x "x@ @ "|Q@ @ "x@ @ "x@ @ "|@ @ "|Q@ @ "x@ @ "x ,"t@ @ ,"t@ @ "|Q@ @ ,"|@ @ ,"t ,"|@ @ "xQ@ @ "xQ@ @ "|Q@ @ "|QQ@ @ "p |""@ @
h""@ @
l""@ @
`Sheet16Sheet27Sheet3,CUsersPeterPete's DocsGENERALPrivateSpreadsheetsFINANCES.xlsM&S 2012Flex2012M&S 2013Flex2013 M&S 2014)Flex2014M&S 2015 Flex 2015M&S 2016 Flex 2016HFax14AbbeyISA's Hols 2014PensionTaxYYYYYYYYYY Y
YYY
YY ""
APRIL 2016 JUNE 2016DateWhat1st6th7thd8thb14thd full15th13th16thc17th25th26th27th29th10thaHow manyfxa MAY 2016Fuel used since last fillThe above represents monthly purchases by category, where 'd' is diesel and the adjacent column to the right is the no. of litres purchased.EAs I don't always fill up, when I do so, I use the category 'd full'.I wish to record the total number of litres used since the last time I filled up, which may or may not occur within the same month. iEg in April I used 15+10+20 litres since last filled on the 10th, whereas in May I never fully filled up.^How can I code the yellow cells to give me the no.of litres used since I last filled the tank?*,iI|hHcc^
1@(/V5
dMbP?_*+%"??U}
}
}
1P0
0
:
.
/
/
Zy
z
{
{
|y
.
/
/
ZX;;;;;;6011[}~011[Y< =>
2
$*\}
2
$*\Y???@A=>
2
%*\F
2
%*\Y???@A=>
2
f~
*5@
\}
~
5@
2
f~
*5@
\Y??B@ =>
2
% *\}
2
% *\Y??B@ =>
2
%*\}
2
%*\Y??B@ =>
2
%*\}
2
%*\Y??B@ =>
2
% *\}
2
% *\Y??B@ =>
2
f~
*>@
\}
~
>@
2
f~
*>@
\Y??B@ =>2
% *\}
2
% *\YCCDEF=>3
&+]}
3
&+]YGGHIFJ>
4
'
,^
4
'
,^YKKLM =>
4
g~
,.@
^
~
.@
4
g~
,.@
^YKKLM =>
4
',_}
4
',_YKKLM =>
4
' ,_}
4
' ,_YKKLN =>
5
(-`}
5
(-`YOOPN =>6
',`}
6
',`YKKLN =>
5
(-`}
5
(-`YOOPN =>
7
h~
-$@
a}
~
$@
7
h~
-$@
aYOOPN =>
7
)-a}
7
)-aYOOPN =>
7
)-a}
7
)-aYQRST =>
7
)-a}
7
)-aYSSST =>
7
h~
-4@
a}
~
4@
7
h~
-4@
aYUUVN =>
8
9-a}
8 9-aYOOW =>
bcde}
b cdeYOOW =>6ijklFjjkljjjkmYOOON =>
KKk
KKK
K(K >OOON =>"####>KKpn =>KKoM =>OOON =>"####>KKKn =>KKKM =>KKoM =>"####
K<RKn =>KKoM =>KKKM =>"####Dlr:zzz~r:zBB !"#$%&'()*+,-./0
K< KKn =>KKKM =>KKKM =>"####>!KKKn =>KKKM =>KRKM =>"####
"K<"KKn =>KKKMK=>KRKM =>"####
#K <#KKq =>KKoM =>KKr =>"####>$;s =tKKKM =>KKKu =t"####
%K!<%v !KKKM =>KKKM =>#####>& !KRKM =>;M =t#####>'KKKw =>KKxM =>#####>(;sKKKw =>#####>);s =t#####>*#####>+#####>,############################>-############################>.############################>/############################>0############################&@NBNNBNBBBBBBBBBB>@76
; Charges
6
dMbP?_*+%"??U>@7
7
dMbP?_*+%"??U>@7
Oh+'0@HXh
PeterPeterMicrosoft Excel@,`@x՜.+,0 PXdlt|
Sheet1Sheet2Sheet3Worksheets
!"#$&'()*+,Root Entry FWorkbook8SummaryInformation(DocumentSummaryInformation8%