{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Donation Tracker","calculations"],"not_rendered":{"charts":2,"images":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Donation Tracker","index":0,"n_rows":21,"n_cols":9,"rows_kept":21,"merged":[[1,1,1,3],[2,6,2,7]]}
[]
[null,2013,{"$nulls":4},"YEARLY TOTAL"]
[null,"DONATION TRACKER",{"$nulls":4},{"$f":"SUBTOTAL(109,Donations[VALUE])","v":{"v":2775,"d":"$2,775"}},null," "]
[]
[{"$nulls":8}," "]
[]
[{"$nulls":8}," "]
{"$rows_empty":8}
[null,"DATE","VALUE","RECEIPT","APPRAISED","ORGANIZATION","ITEM"," "]
[null,"2013-02-04",{"v":500,"d":"$500"},"NO",null,"Coho Foundation","Cash",{"$f":"(Donations[[#This Row],[VALUE]]>=250)*(Donations[[#This Row],[RECEIPT]]<>\"yes\")","v":1}]
[null,"2013-03-17",{"v":750,"d":"$750"},"YES","YES","Retail Charity","Furniture",{"$f":"(Donations[[#This Row],[VALUE]]>=250)*(Donations[[#This Row],[RECEIPT]]<>\"yes\")","v":0}]
[null,"2013-04-12",{"v":1000,"d":"$1,000"},null,null,"My Church","Cash",{"$f":"(Donations[[#This Row],[VALUE]]>=250)*(Donations[[#This Row],[RECEIPT]]<>\"yes\")","v":1}]
[null,"2013-05-01",{"v":150,"d":"$150"},null,null,"Emergency Aid","Cash",{"$f":"(Donations[[#This Row],[VALUE]]>=250)*(Donations[[#This Row],[RECEIPT]]<>\"yes\")","v":0}]
[null,"2013-05-16",{"v":375,"d":"$375"},"YES",null,"Emergency Aid","Cash",{"$f":"(Donations[[#This Row],[VALUE]]>=250)*(Donations[[#This Row],[RECEIPT]]<>\"yes\")","v":0}]

{"sheet":"calculations","index":1,"n_rows":36,"n_cols":6,"rows_kept":36,"hidden":true}
["This sheet should  remain hidden"]
[]
[]
[]
[null,null,"DONATIONS BY MONTH"]
[null,null,"Month",null,null,"Donation"]
[null,1,"JAN",{"$f":"DATE(Year,B7,1)","v":"2013-01-01"},{"$f":"EOMONTH(D7,0)","v":"2013-01-31"},{"$f":"SUMIFS(Donations[VALUE],Donations[DATE],\">=\"&calculations!D7,Donations[DATE],\"<=\"&calculations!E7)","v":{"v":0,"d":"$0"}}]
[null,2,"FEB","2013-02-01",{"$f":"EOMONTH(D8,0)","v":"2013-02-28"},{"$f":"SUMIFS(Donations[VALUE],Donations[DATE],\">=\"&calculations!D8,Donations[DATE],\"<=\"&calculations!E8)","v":{"v":500,"d":"$500"}}]
[null,3,"MAR","2013-03-01","2013-03-31",{"$f":"SUMIFS(Donations[VALUE],Donations[DATE],\">=\"&calculations!D9,Donations[DATE],\"<=\"&calculations!E9)","v":{"v":750,"d":"$750"}}]
[null,4,"APR","2013-04-01","2013-04-30",{"$f":"SUMIFS(Donations[VALUE],Donations[DATE],\">=\"&calculations!D10,Donations[DATE],\"<=\"&calculations!E10)","v":{"v":1000,"d":"$1,000"}}]
[null,5,"MAY","2013-05-01","2013-05-31",{"$f":"SUMIFS(Donations[VALUE],Donations[DATE],\">=\"&calculations!D11,Donations[DATE],\"<=\"&calculations!E11)","v":{"v":525,"d":"$525"}}]
[null,6,"JUN","2013-06-01","2013-06-30",{"$f":"SUMIFS(Donations[VALUE],Donations[DATE],\">=\"&calculations!D12,Donations[DATE],\"<=\"&calculations!E12)","v":{"v":0,"d":"$0"}}]
[null,7,"JUL","2013-07-01","2013-07-31",{"$f":"SUMIFS(Donations[VALUE],Donations[DATE],\">=\"&calculations!D13,Donations[DATE],\"<=\"&calculations!E13)","v":{"v":0,"d":"$0"}}]
[null,8,"AUG","2013-08-01","2013-08-31",{"$f":"SUMIFS(Donations[VALUE],Donations[DATE],\">=\"&calculations!D14,Donations[DATE],\"<=\"&calculations!E14)","v":{"v":0,"d":"$0"}}]
[null,9,"SEP","2013-09-01","2013-09-30",{"$f":"SUMIFS(Donations[VALUE],Donations[DATE],\">=\"&calculations!D15,Donations[DATE],\"<=\"&calculations!E15)","v":{"v":0,"d":"$0"}}]
[null,10,"OCT","2013-10-01","2013-10-31",{"$f":"SUMIFS(Donations[VALUE],Donations[DATE],\">=\"&calculations!D16,Donations[DATE],\"<=\"&calculations!E16)","v":{"v":0,"d":"$0"}}]
[null,11,"NOV","2013-11-01","2013-11-30",{"$f":"SUMIFS(Donations[VALUE],Donations[DATE],\">=\"&calculations!D17,Donations[DATE],\"<=\"&calculations!E17)","v":{"v":0,"d":"$0"}}]
[null,12,"DEC","2013-12-01","2013-12-31",{"$f":"SUMIFS(Donations[VALUE],Donations[DATE],\">=\"&calculations!D18,Donations[DATE],\"<=\"&calculations!E18)","v":{"v":0,"d":"$0"}}]
[]
[]
[]
[]
[null,null,"DONATIONS BY ORGANIZATION"]
[null,{"$f":"COUNT(IF(LEN(D25:D45)>0,1))","v":4},null,"Organization",null,"Donation"]
[null,1,{"$f":"INDEX('Donation Tracker'!$F$17:$F$21, MATCH(0, COUNTIF($D$24:D24, 'Donation Tracker'!$F$17:$F$21), 0))","v":"Coho Foundation"},{"$f":"IFERROR(REPT(C25,ISTEXT(C25)),\"\")","v":"Coho Foundation"},null,{"$f":"SUMIFS(Donations[VALUE],Donations[ORGANIZATION],D25)","v":{"v":500,"d":"$500"}}]
[null,2,{"$f":"INDEX('Donation Tracker'!$F$17:$F$21, MATCH(0, COUNTIF($C$24:C25, 'Donation Tracker'!$F$17:$F$21), 0))","v":"Retail Charity"},{"$f":"IFERROR(REPT(C26,ISTEXT(C26)),\"\")","v":"Retail Charity"},null,{"$f":"SUMIFS(Donations[VALUE],Donations[ORGANIZATION],D26)","v":{"v":750,"d":"$750"}}]
[null,3,{"$f":"INDEX('Donation Tracker'!$F$17:$F$21, MATCH(0, COUNTIF($C$24:C26, 'Donation Tracker'!$F$17:$F$21), 0))","v":"My Church"},{"$f":"IFERROR(REPT(C27,ISTEXT(C27)),\"\")","v":"My Church"},null,{"$f":"SUMIFS(Donations[VALUE],Donations[ORGANIZATION],D27)","v":{"v":1000,"d":"$1,000"}}]
[null,4,{"$f":"INDEX('Donation Tracker'!$F$17:$F$21, MATCH(0, COUNTIF($C$24:C27, 'Donation Tracker'!$F$17:$F$21), 0))","v":"Emergency Aid"},{"$f":"IFERROR(REPT(C28,ISTEXT(C28)),\"\")","v":"Emergency Aid"},null,{"$f":"SUMIFS(Donations[VALUE],Donations[ORGANIZATION],D28)","v":{"v":525,"d":"$525"}}]
[null,5,{"$f":"INDEX('Donation Tracker'!$F$17:$F$21, MATCH(0, COUNTIF($C$24:C28, 'Donation Tracker'!$F$17:$F$21), 0))","v":{"$error":"#N/A"}},{"$f":"IFERROR(REPT(C29,ISTEXT(C29)),\"\")","v":""},null,{"$f":"SUMIFS(Donations[VALUE],Donations[ORGANIZATION],D29)","v":{"v":0,"d":"$0"}}]
[null,6,{"$f":"INDEX('Donation Tracker'!$F$17:$F$21, MATCH(0, COUNTIF($C$24:C29, 'Donation Tracker'!$F$17:$F$21), 0))","v":{"$error":"#N/A"}},{"$f":"IFERROR(REPT(C30,ISTEXT(C30)),\"\")","v":""},null,{"$f":"SUMIFS(Donations[VALUE],Donations[ORGANIZATION],D30)","v":{"v":0,"d":"$0"}}]
[null,7,{"$f":"INDEX('Donation Tracker'!$F$17:$F$21, MATCH(0, COUNTIF($C$24:C30, 'Donation Tracker'!$F$17:$F$21), 0))","v":{"$error":"#N/A"}},{"$f":"IFERROR(REPT(C31,ISTEXT(C31)),\"\")","v":""},null,{"$f":"SUMIFS(Donations[VALUE],Donations[ORGANIZATION],D31)","v":{"v":0,"d":"$0"}}]
[null,8,{"$f":"INDEX('Donation Tracker'!$F$17:$F$21, MATCH(0, COUNTIF($C$24:C31, 'Donation Tracker'!$F$17:$F$21), 0))","v":{"$error":"#N/A"}},{"$f":"IFERROR(REPT(C32,ISTEXT(C32)),\"\")","v":""},null,{"$f":"SUMIFS(Donations[VALUE],Donations[ORGANIZATION],D32)","v":{"v":0,"d":"$0"}}]
[null,9,{"$f":"INDEX('Donation Tracker'!$F$17:$F$21, MATCH(0, COUNTIF($C$24:C32, 'Donation Tracker'!$F$17:$F$21), 0))","v":{"$error":"#N/A"}},{"$f":"IFERROR(REPT(C33,ISTEXT(C33)),\"\")","v":""},null,{"$f":"SUMIFS(Donations[VALUE],Donations[ORGANIZATION],D33)","v":{"v":0,"d":"$0"}}]
[null,10,{"$f":"INDEX('Donation Tracker'!$F$17:$F$21, MATCH(0, COUNTIF($C$24:C33, 'Donation Tracker'!$F$17:$F$21), 0))","v":{"$error":"#N/A"}},{"$f":"IFERROR(REPT(C34,ISTEXT(C34)),\"\")","v":""},null,{"$f":"SUMIFS(Donations[VALUE],Donations[ORGANIZATION],D34)","v":{"v":0,"d":"$0"}}]
[null,11,{"$f":"INDEX('Donation Tracker'!$F$17:$F$21, MATCH(0, COUNTIF($C$24:C34, 'Donation Tracker'!$F$17:$F$21), 0))","v":{"$error":"#N/A"}},{"$f":"IFERROR(REPT(C35,ISTEXT(C35)),\"\")","v":""},null,{"$f":"SUMIFS(Donations[VALUE],Donations[ORGANIZATION],D35)","v":{"v":0,"d":"$0"}}]
[null,12,{"$f":"INDEX('Donation Tracker'!$F$17:$F$21, MATCH(0, COUNTIF($C$24:C35, 'Donation Tracker'!$F$17:$F$21), 0))","v":{"$error":"#N/A"}},{"$f":"IFERROR(REPT(C36,ISTEXT(C36)),\"\")","v":""},null,{"$f":"SUMIFS(Donations[VALUE],Donations[ORGANIZATION],D36)","v":{"v":0,"d":"$0"}}]