{"text_format":"1","workbook":"xlsx","n_sheets":38,"sheets":["VALIDATION","SUMMARY","JAN12","FEB12","MAR12","APR12","MAY12","JUNE12","JULY12","AUG12","SEP12","OCT12","NOV12","DEC12","JAN13","FEB13","MAR13","APR13","MAY13","JUNE13","JULY13","SEP13","AUG13","OCT13","NOV13","DEC13","JAN14","FEB14","MAR14","APR14","MAY14","JUNE14","JULY14","AUG14","SEP14","OCT14","NOV14","DEC14"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"VALIDATION","index":0,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["(Pull-Down and Select)",null,null,"2012-01-12",null,null,null,"(Pull-Down)","(Pull-Down for Month)",null,null,null,"No Carryover"]
["Incurred",null,null,{"$f":"SUMIFS('JAN12'!I19:I186,'JAN12'!C19:C186,\"Paid by Customer\")","v":0},null,null,null,"Yes","2012-01-01",null,"2012-01-01","From"]
["Paid by Customer",null,null,{"$f":"IF(D2>='JAN12'!I5,0,'JAN12'!F10)","v":"no data"},null,null,null,"No","2012-02-01",null,"2012-02-01","From"]
["Not Covered by MHD",null,null,null,null,null,null,null,"2012-03-01",null,"2012-03-01","From"]
["Check Received",null,null,null,null,null,null,null,"2012-04-01",null,"2012-04-01","From"]
[null,null,null,null,null,null,null,null,"2012-05-01",null,"2012-05-01","From"]
["(Pull-Down and Select)",null,null,null,null,null,null,null,"2012-06-01",null,"2012-06-01","From"]
["A - Incurred",null,"SUMIFS(I19:I100,C19:C100,\"Paid by Customer\")",null,null,null,null,null,"2012-07-01",null,"2012-07-01","From"]
["B - Not Covered by MHD",null,null,null,null,null,null,null,"2012-08-01",null,"2012-08-01","From"]
["C - Paid by Customer",null,null,null,null,null,null,null,"2012-09-01",null,"2012-09-01","From"]
["D - Check Received",null,null,null,null,null,null,null,"2012-10-01",null,"2012-10-01","From"]
[null,null,null,null,null,null,null,null,"2012-11-01",null,"2012-11-01","From"]
[{"$f":"IF(AND(AND(K9>=I5,I5<>F10,A19<>K2)),\"ERROR!\",\"no data\")","v":"ERROR!"},null,null,null,null,null,null,null,"2012-12-01",null,"2012-12-01","From"]
[{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,null,null,null,null,null,null,"2013-01-01",null,"2013-01-01","From"]
["None",null,null,null,null,null,null,null,"2013-02-01",null,"2013-02-01","From"]
["HOH",null,null,null,null,null,null,null,"2013-03-01",null,"2013-03-01","From"]
["Spouse",null,null,null,null,null,null,null,"2013-04-01",null,"2013-04-01","From"]
["Both",null,null,null,null,null,null,null,"2013-05-01",null,"2013-05-01","From"]
[null,null,null,null,null,null,null,null,"2013-06-01",null,"2013-06-01","From"]
[null,null,null,null,null,null,null,null,"2013-07-01",null,"2013-07-01","From"]
[null,null,null,null,null,null,null,null,"2013-08-01",null,"2013-08-01","From"]
[null,null,null,null,null,null,null,null,"2013-09-01",null,"2013-09-01","From"]
[null,null,null,null,null,null,null,null,"2013-10-01",null,"2013-10-01","From"]
[null,null,null,null,null,null,null,null,"2013-11-01",null,"2013-11-01","From"]
[null,null,null,null,null,null,null,null,"2013-12-01",null,"2013-12-01","From"]
[null,null,null,null,null,null,null,null,"2014-01-01",null,"2014-01-01","From"]
[null,null,null,null,null,null,null,null,"2014-02-01",null,"2014-02-01","From"]
[null,null,null,null,null,null,null,null,"2014-03-01",null,"2014-03-01","From"]
[null,null,null,null,null,null,null,null,"2014-04-01",null,"2014-04-01","From"]
[null,null,null,null,null,null,null,null,"2014-05-01",null,"2014-05-01","From"]
[null,null,null,null,null,null,null,null,"2014-06-01",null,"2014-06-01","From"]
[null,null,null,null,null,null,null,null,"2014-07-01",null,"2014-07-01","From"]
[null,null,null,null,null,null,null,null,"2014-08-01",null,"2014-08-01","From"]
[null,null,null,null,null,null,null,null,"2014-09-01",null,"2014-09-01","From"]
[null,null,null,null,null,null,null,null,"2014-10-01",null,"2014-10-01","From"]
[null,null,null,null,null,null,null,null,"2014-11-01",null,"2014-11-01","From"]
[null,null,null,null,null,null,null,null,"2014-12-01",null,"2014-12-01","From"]

{"sheet":"SUMMARY","index":1,"n_rows":49,"n_cols":21,"rows_kept":49,"cut":false,"hidden":false,"merged":[[47,0,47,1],[48,0,48,1],[2,5,2,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[27,0,27,1],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[41,0,41,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[36,0,36,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[11,0,11,1],[7,0,7,5],[2,0,2,2],[8,0,8,1],[9,0,9,1],[10,0,10,1],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[48,7,48,8],[43,7,43,8],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8]]}
["MODSS FSD SPEND DOWN CALCULATOR - SUMMARY",null,null,null,null,null,null,"Rev. 8/5/12 - jm",null,null,null,null,null,null,null,null,null,null,null,null,"(pull down)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incurred"]
[null,null,null,null,"Customer:","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paid by Customer"]
[null,null,null,null,"Customer DCN:","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not covered by MHD"]
[null,null,null,null,"Spouse (if applicable):",""]
[null,null,null,null,"Spouse DCN:",""]
[]
["Monthly Status:"]
["Select Month:",null,"Status:","Liability:","Needed to Meet Spend Down:","Carryover Used:","Carryover Used From:","Comments:"]
["2012-01-01",null,{"$f":"'JAN12'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C10=\"Spend down Met\",'JAN12'!$F$10,'JAN12'!$I$5-'JAN12'!$I$6)","v":1},{"$f":"'JAN12'!$I$5-'JAN12'!$I$6","v":1},"No","No Carryover",""]
["2012-02-01",null,{"$f":"'FEB12'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C11=\"Spend down Met\",'FEB12'!$F$10,'FEB12'!$I$5-'FEB12'!$I$6)","v":1},{"$f":"'FEB12'!$I$5-'FEB12'!$I$6","v":1},"No","No Carryover",""]
["2012-03-01",null,{"$f":"'MAR12'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C12=\"Spend down Met\",'MAR12'!$F$10,'MAR12'!$I$5-'MAR12'!$I$6)","v":1},{"$f":"'MAR12'!$I$5-'MAR12'!$I$6","v":1},"No","No Carryover",""]
["2012-04-01",null,{"$f":"'APR12'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C13=\"Spend down Met\",'APR12'!$F$10,'APR12'!$I$5-'APR12'!$I$6)","v":1},{"$f":"'APR12'!$I$5-'APR12'!$I$6","v":1},"No","No Carryover",""]
["2012-05-01",null,{"$f":"'MAY12'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C14=\"Spend down Met\",'MAY12'!$F$10,'MAY12'!$I$5-'MAY12'!$I$6)","v":1},{"$f":"'MAY12'!$I$5-'MAY12'!$I$6","v":1},"No","No Carryover",""]
["2012-06-01",null,{"$f":"JUNE12!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C15=\"Spend down Met\",JUNE12!$F$10,JUNE12!$I$5-JUNE12!$I$6)","v":1},{"$f":"JUNE12!$I$5-JUNE12!$I$6","v":1},"No","No Carryover",""]
["2012-07-01",null,{"$f":"JULY12!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C16=\"Spend down Met\",JULY12!$F$10,JULY12!$I$5-JULY12!$I$6)","v":1},{"$f":"JULY12!$I$5-JULY12!$I$6","v":1},"No","No Carryover",""]
["2012-08-01",null,{"$f":"'AUG12'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C17=\"Spend down Met\",'AUG12'!$F$10,'AUG12'!$I$5-'AUG12'!$I$6)","v":1},{"$f":"'AUG12'!$I$5-'AUG12'!$I$6","v":1},"No","No Carryover",""]
["2012-09-01",null,{"$f":"'SEP12'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C18=\"Spend down Met\",'SEP12'!$F$10,'SEP12'!$I$5-'SEP12'!$I$6)","v":1},{"$f":"'SEP12'!$I$5-'SEP12'!$I$6","v":1},"No","No Carryover",""]
["2012-10-01",null,{"$f":"'OCT12'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C19=\"Spend down Met\",'OCT12'!$F$10,'OCT12'!$I$5-'OCT12'!$I$6)","v":1},{"$f":"'OCT12'!$I$5-'OCT12'!$I$6","v":1},"No","No Carryover",""]
["2012-11-01",null,{"$f":"'NOV12'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C20=\"Spend down Met\",'NOV12'!$F$10,'NOV12'!$I$5-'NOV12'!$I$6)","v":1},{"$f":"'NOV12'!$I$5-'NOV12'!$I$6","v":1},"No","No Carryover",""]
["2012-12-01",null,{"$f":"'DEC12'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C21=\"Spend down Met\",'DEC12'!$F$10,'DEC12'!$I$5-'DEC12'!$I$6)","v":1},{"$f":"'DEC12'!$I$5-'DEC12'!$I$6","v":1},"No","No Carryover",""]
[]
["Select Month:",null,"Status:","Liability:","Needed to Meet Spend Down:","Carryover Used:","Carryover Used From:","Comments:"]
["2013-01-01",null,{"$f":"'JAN13'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C24=\"Spend down Met\",'JAN13'!$F$10,'JAN13'!$I$5-'JAN13'!$I$6)","v":1},{"$f":"'JAN13'!$I$5-'JAN13'!$I$6","v":1},"No","No Carryover",""]
["2013-02-01",null,{"$f":"'FEB13'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C25=\"Spend down Met\",'FEB13'!$F$10,'FEB13'!$I$5-'FEB13'!$I$6)","v":1},{"$f":"'FEB13'!$I$5-'FEB13'!$I$6","v":1},"No","No Carryover",""]
["2013-03-01",null,{"$f":"'MAR13'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C26=\"Spend down Met\",'MAR13'!$F$10,'MAR13'!$I$5-'MAR13'!$I$6)","v":1},{"$f":"'MAR13'!$I$5-'MAR13'!$I$6","v":1},"No","No Carryover",""]
["2013-04-01",null,{"$f":"'APR13'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C27=\"Spend down Met\",'APR13'!$F$10,'APR13'!$I$5-'APR13'!$I$6)","v":1},{"$f":"'APR13'!$I$5-'APR13'!$I$6","v":1},"No","No Carryover",""]
["2013-05-01",null,{"$f":"'MAY13'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C28=\"Spend down Met\",'MAY13'!$F$10,'MAY13'!$I$5-'MAY13'!$I$6)","v":1},{"$f":"'MAY13'!$I$5-'MAY13'!$I$6","v":1},"No","No Carryover",""]
["2013-06-01",null,{"$f":"JUNE13!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C29=\"Spend down Met\",JUNE13!$F$10,JUNE13!$I$5-JUNE13!$I$6)","v":1},{"$f":"JUNE13!$I$5-JUNE13!$I$6","v":1},"No","No Carryover",""]
["2013-07-01",null,{"$f":"JULY13!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C30=\"Spend down Met\",JULY13!$F$10,JULY13!$I$5-JULY13!$I$6)","v":1},{"$f":"JULY13!$I$5-JULY13!$I$6","v":1},"No","No Carryover",""]
["2013-08-01",null,{"$f":"'AUG13'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C31=\"Spend down Met\",'AUG13'!$F$10,'AUG13'!$I$5-'AUG13'!$I$6)","v":1},{"$f":"'AUG13'!$I$5-'AUG13'!$I$6","v":1},"No","No Carryover",""]
["2013-09-01",null,{"$f":"'SEP13'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C32=\"Spend down Met\",'SEP13'!$F$10,'SEP13'!$I$5-'SEP13'!$I$6)","v":1},{"$f":"'SEP13'!$I$5-'SEP13'!$I$6","v":1},"No","No Carryover",""]
["2013-10-01",null,{"$f":"'OCT13'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C33=\"Spend down Met\",'OCT13'!$F$10,'OCT13'!$I$5-'OCT13'!$I$6)","v":1},{"$f":"'OCT13'!$I$5-'OCT13'!$I$6","v":1},"No","No Carryover",""]
["2013-11-01",null,{"$f":"'NOV13'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C34=\"Spend down Met\",'NOV13'!$F$10,'NOV13'!$I$5-'NOV13'!$I$6)","v":1},{"$f":"'NOV13'!$I$5-'NOV13'!$I$6","v":1},"No","No Carryover",""]
["2013-12-01",null,{"$f":"'DEC13'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C35=\"Spend down Met\",'DEC13'!$F$10,'DEC13'!$I$5-'DEC13'!$I$6)","v":1},{"$f":"'DEC13'!$I$5-'DEC13'!$I$6","v":1},"No","No Carryover",""]
[]
["Select Month:",null,"Status:","Liability:","Needed to Meet Spend Down:","Carryover Used:","Carryover Used From:","Comments:"]
["2014-01-01",null,{"$f":"'JAN14'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C38=\"Spend down Met\",'JAN14'!$F$10,'JAN14'!$I$5-'JAN14'!$I$6)","v":1},{"$f":"'JAN14'!$I$5-'JAN14'!$I$6","v":1},"No","No Carryover",""]
["2014-02-01",null,{"$f":"'FEB14'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C39=\"Spend down Met\",'FEB14'!$F$10,'FEB14'!$I$5-'FEB14'!$I$6)","v":1},{"$f":"'FEB14'!$I$5-'FEB14'!$I$6","v":1},"No","No Carryover",""]
["2014-03-01",null,{"$f":"'MAR14'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C40=\"Spend down Met\",'MAR14'!$F$10,'MAR14'!$I$5-'MAR14'!$I$6)","v":1},{"$f":"'MAR14'!$I$5-'MAR14'!$I$6","v":1},"No","No Carryover",""]
["2014-04-01",null,{"$f":"'APR14'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C41=\"Spend down Met\",'APR14'!$F$10,'APR14'!$I$5-'APR14'!$I$6)","v":1},{"$f":"'APR14'!$I$5-'APR14'!$I$6","v":1},"No","No Carryover",""]
["2014-05-01",null,{"$f":"'MAY14'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C42=\"Spend down Met\",'MAY14'!$F$10,'MAY14'!$I$5-'MAY14'!$I$6)","v":1},{"$f":"'MAY14'!$I$5-'MAY14'!$I$6","v":1},"No","No Carryover",""]
["2014-06-01",null,{"$f":"JUNE14!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C43=\"Spend down Met\",JUNE14!$F$10,JUNE14!$I$5-JUNE14!$I$6)","v":1},{"$f":"JUNE14!$I$5-JUNE14!$I$6","v":1},"No","No Carryover",""]
["2014-07-01",null,{"$f":"JULY14!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C44=\"Spend down Met\",JULY14!$F$10,JULY14!$I$5-JULY14!$I$6)","v":1},{"$f":"JULY14!$I$5-JULY14!$I$6","v":1},"No","No Carryover",""]
["2014-08-01",null,{"$f":"'AUG14'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C45=\"Spend down Met\",'AUG14'!$F$10,'AUG14'!$I$5-'AUG14'!$I$6)","v":1},{"$f":"'AUG14'!$I$5-'AUG14'!$I$6","v":1},"No","No Carryover",""]
["2014-09-01",null,{"$f":"'SEP14'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C46=\"Spend down Met\",'SEP14'!$F$10,'SEP14'!$I$5-'SEP14'!$I$6)","v":1},{"$f":"'SEP14'!$I$5-'SEP14'!$I$6","v":1},"No","No Carryover",""]
["2014-10-01",null,{"$f":"'OCT14'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C47=\"Spend down Met\",'OCT14'!$F$10,'OCT14'!$I$5-'OCT14'!$I$6)","v":1},{"$f":"'OCT14'!$I$5-'OCT14'!$I$6","v":1},"No","No Carryover",""]
["2014-11-01",null,{"$f":"'NOV14'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C48=\"Spend down Met\",'NOV14'!$F$10,'NOV14'!$I$5-'NOV14'!$I$6)","v":1},{"$f":"'NOV14'!$I$5-'NOV14'!$I$6","v":1},"No","No Carryover",""]
["2014-12-01",null,{"$f":"'DEC14'!$A$8","v":"Spend Down Not Met"},{"$f":"IF(C49=\"Spend down Met\",'DEC14'!$F$10,'DEC14'!$I$5-'DEC14'!$I$6)","v":1},{"$f":"'DEC14'!$I$5-'DEC14'!$I$6","v":1},"No","No Carryover",""]

{"sheet":"JAN12","index":2,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,7,0,8],[11,0,13,1],[2,5,2,7],[3,5,3,7],[2,2,2,4],[3,2,3,4],[0,4,0,5],[0,0,0,1],[5,5,5,7],[4,2,4,4],[5,2,5,4],[17,3,17,4],[17,7,17,8],[7,4,7,8],[9,0,9,1],[9,3,9,4],[11,8,15,8],[10,4,10,5],[14,4,14,5],[15,4,15,5],[12,4,12,5],[11,4,11,5],[13,4,13,5],[16,4,16,5],[16,6,16,7],[7,0,7,1],[7,2,7,3]]}
["Back to Summary",null,null,null,null,null,null,"2012-01-01",null,null,null,"Liability","Spend Down Met",null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"JAN12 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":"00:00:00"},"All Incurred","All Incurred",null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":"00:00:00"},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF($I$6>=$I$5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":"00:00:00"},null,"Some expenses paid"]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1},"2012-01-03",null,{"$f":"IF(AND(OR($I$6>=$I$5,#REF!=\"Paid by Customer\",#REF!=\"Not Covered by MHD\")),\"Spend Down Met\",\"Spend Down Not Met\")","v":{"$error":"#REF!"}}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0},null,null,null,"Partial Payment"]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($I$6>=$I$5,#REF!=\"Check Received\"),\"Spend Down Met with Payment\",\"Spend Down Not Met\")","v":{"$error":"#REF!"}}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF($C$8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"$I$5-$K$9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0},{"$f":"SUMIF($C$19:$C$188,\"C - Paid by Customer\",$I$19:$I$188)","v":0},{"$f":"SUMIF(#REF!,\"C - Paid by Customer\",#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"},{"$f":"SUMIF($C$19:$C$188,\"D - Check Received\",$I$19:$I$188)","v":0},{"$f":"SUMIF(#REF!,\"D - Check Received\",#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0},{"$f":"IF(#REF!=\"A - Incurred\",M3, \"Spend Down Not Met\")","v":{"$error":"#REF!"}}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(OR(#REF!=\"B - Paid by Customer\",#REF!= \"C - Not Covered by MHD\"),$M$5, \"Spend Down Not Met\")","v":{"$error":"#REF!"}}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":"00:00:00"}]
["List of January Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"FEB12","index":3,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,3,17,4],[17,7,17,8],[11,0,13,1],[10,4,10,5],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[16,6,16,7],[9,0,9,1],[9,3,9,4],[0,7,0,8],[2,2,2,4],[2,5,2,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[0,0,0,1],[0,4,0,5]]}
["Back to Summary",null,null,null,null,null,null,"2012-02-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"FEB12 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":"00:00:00"}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spenddown Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of February Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"MAR12","index":4,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,3,17,4],[17,7,17,8],[11,0,13,1],[10,4,10,5],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[16,6,16,7],[9,0,9,1],[9,3,9,4],[0,7,0,8],[2,2,2,4],[2,5,2,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[0,0,0,1],[0,4,0,5]]}
["Back to Summary",null,null,null,null,null,null,"2012-03-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"MAR12 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of March Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"APR12","index":5,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,3,17,4],[17,7,17,8],[11,0,13,1],[10,4,10,5],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[16,6,16,7],[9,0,9,1],[9,3,9,4],[0,7,0,8],[2,2,2,4],[2,5,2,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[0,0,0,1],[0,4,0,5]]}
["Back to Summary",null,null,null,null,null,null,"2012-04-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"APR12 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of April Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"MAY12","index":6,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[11,0,13,1],[10,4,10,5],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[194,0,194,1],[194,4,194,5],[194,7,194,8],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[0,7,0,8],[2,2,2,4],[2,5,2,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[0,0,0,1],[0,4,0,5]]}
["Back to Summary",null,null,null,null,null,null,"2012-05-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"MAY12 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of May Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"JUNE12","index":7,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,3,17,4],[17,7,17,8],[11,0,13,1],[10,4,10,5],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[16,6,16,7],[9,0,9,1],[9,3,9,4],[0,7,0,8],[2,2,2,4],[2,5,2,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[0,0,0,1],[0,4,0,5]]}
["Back to Summary",null,null,null,null,null,null,"2012-06-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"JUNE12 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of June Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"JULY12","index":8,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,3,17,4],[17,7,17,8],[11,0,13,1],[10,4,10,5],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[16,6,16,7],[9,0,9,1],[9,3,9,4],[0,7,0,8],[2,2,2,4],[2,5,2,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[0,0,0,1],[0,4,0,5]]}
["Back to Summary",null,null,null,null,null,null,"2012-07-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"JULY12 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of July Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"AUG12","index":9,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,3,17,4],[17,7,17,8],[11,0,13,1],[10,4,10,5],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[16,6,16,7],[9,0,9,1],[9,3,9,4],[0,7,0,8],[2,2,2,4],[2,5,2,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[0,0,0,1],[0,4,0,5]]}
["Back to Summary",null,null,null,null,null,null,"2012-08-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"AUG12 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of August Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"SEP12","index":10,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,3,17,4],[17,7,17,8],[11,0,13,1],[10,4,10,5],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[16,6,16,7],[9,0,9,1],[9,3,9,4],[0,7,0,8],[2,2,2,4],[2,5,2,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[0,0,0,1],[0,4,0,5]]}
["Back to Summary",null,null,null,null,null,null,"2012-09-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"SEP12 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of September Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"OCT12","index":11,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,3,17,4],[17,7,17,8],[11,0,13,1],[10,4,10,5],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[16,6,16,7],[9,0,9,1],[9,3,9,4],[0,7,0,8],[2,2,2,4],[2,5,2,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[0,0,0,1],[0,4,0,5]]}
["Back to Summary",null,null,null,null,null,null,"2012-10-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"OCT12 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of October Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"NOV12","index":12,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,3,17,4],[17,7,17,8],[11,0,13,1],[10,4,10,5],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[16,6,16,7],[9,0,9,1],[9,3,9,4],[0,7,0,8],[2,2,2,4],[2,5,2,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[0,0,0,1],[0,4,0,5]]}
["Back to Summary",null,null,null,null,null,null,"2012-11-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"NOV12 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of November Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"DEC12","index":13,"n_rows":18,"n_cols":21,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,3,17,4],[17,7,17,8],[11,0,13,1],[10,4,10,5],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[16,6,16,7],[9,0,9,1],[9,3,9,4],[0,7,0,8],[2,2,2,4],[2,5,2,7],[3,2,3,4],[3,5,3,7],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[0,0,0,1],[0,4,0,5]]}
["Back to Summary",null,null,null,null,null,null,"2012-12-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"DEC12 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes",null,null,null,null,null,"(Pull Down)"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of December Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"JAN13","index":14,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2013-01-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"JAN13 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},"SD Carryover ",null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0},{"$f":"$L$2&$L$3","v":"SD Carryover 0"}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of January Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"FEB13","index":15,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2013-02-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"FEB13 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of February Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"MAR13","index":16,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2013-03-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"MAR13 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of March Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"APR13","index":17,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2013-04-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"APR13 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of April Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"MAY13","index":18,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2013-05-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"MAY13 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of May Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"JUNE13","index":19,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2013-06-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"JUNE13 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of June Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"JULY13","index":20,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2013-07-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"JULY13 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of July Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"SEP13","index":21,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2013-09-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"SEP13 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of September Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"AUG13","index":22,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2013-08-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"AUG13 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of August Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"OCT13","index":23,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2013-10-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"OCT13 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of October Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"NOV13","index":24,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2013-11-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"NOV13 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of November Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"DEC13","index":25,"n_rows":18,"n_cols":21,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2013-12-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"DEC13 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes",null,null,null,null,null,"(Pull Down)"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of December Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"JAN14","index":26,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2014-01-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"JAN14 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},"SD Carryover ",null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0},{"$f":"$L$2&$L$3","v":"SD Carryover 0"}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of January Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"FEB14","index":27,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2014-02-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"FEB14 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of February Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"MAR14","index":28,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2014-03-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"MAR14 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of March Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"APR14","index":29,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2014-04-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"APR14 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of April Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"MAY14","index":30,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2014-05-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"MAY14 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of May Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"JUNE14","index":31,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2014-06-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"JUNE14 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of June Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"JULY14","index":32,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2014-07-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"JULY14 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of July Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"AUG14","index":33,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2014-08-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"AUG14 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of August Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"SEP14","index":34,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2014-09-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"SEP13 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of September Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"OCT14","index":35,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2014-10-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"OCT14 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of October Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"NOV14","index":36,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2014-11-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"NOV14 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of November Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]

{"sheet":"DEC14","index":37,"n_rows":18,"n_cols":21,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,16,5],[16,6,16,7],[17,3,17,4],[17,7,17,8],[9,0,9,1],[9,3,9,4],[10,4,10,5],[11,0,13,1],[11,4,11,5],[11,8,15,8],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[4,2,4,4],[5,2,5,4],[5,5,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,8],[3,2,3,4],[3,5,3,7],[0,0,0,1],[0,4,0,5],[0,7,0,8],[2,2,2,4],[2,5,2,7]]}
["Back to Summary",null,null,null,null,null,null,"2014-12-01",null,null,null,null,null,null,""]
["MODSS FSD SPEND DOWN CALCULATOR",null,null,null,null,"   Apply Carryover To:",null,null,"DEC14 Carryover",{"$f":"INDEX($C$19:$C$200,MATCH(TRUE,$C$19:$C$200=\"\",0)-1)","v":0},{"$f":"INDEX($A$19:$A$200,MATCH(TRUE,$A$19:$A$200=\"\",0)-1)","v":0},null,null,null,"Yes",null,null,null,null,null,"(Pull Down)"]
[null,"Customer:",{"$f":"SUMMARY!F3","v":""},null,null,"Carryover Amount:",null,null,{"$f":"IF($C$19=\"B - Not Covered by MHD\",IF(K15=0,ROUNDUP($J$5,0)-$I$5,ROUNDUP($J$5,0)),0)","v":0},{"$f":"IF(AND($A$8=\"Spend Down Met\",$C$19<>\"Incurred\"),$I$19-$K$10,0)","v":0},{"$f":"IF(OR(AND($G$17=\"D - Check Received\",$G$17=\"C - Paid by Customer\"),$A$19>0),$K$2,$G$11)","v":0},{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":"00:00:00"},null,null,"No"]
[null,"Customer DCN:",{"$f":"SUMMARY!F4","v":""},null,null,"Medicare/3rd Party Insurance:",null,null,"None",{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0},{"$f":"IF(AND($G$17=\"D - Check Received\",$A$19>0),$H$1,$G$11)","v":0}]
[null,"Spouse (if applicable):",{"$f":"SUMMARY!F5","v":""},null,null,"  Enter Spend Down Amount",null,null,1,{"$f":"IF(A19=K2,SUM($I$19:$I$200)-$I$5,J3)","v":-1}]
[null,"Spouse DCN:",{"$f":"SUMMARY!F6","v":""},null,null,"Total Expenses For Month:",null,null,{"$f":"IF(K11>I5,I5,K11)","v":0}]
["Message Center:",null,null,null,{"$f":"IF(AND(I3>0,$C$19=\"B - Not Covered by MHD\"),\"Carryover exists.  Apply to a future month listed above.\",\"\")","v":""}]
[{"$f":"IF(I6>=I5,\"Spend Down Met\",\"Spend Down Not Met\")","v":"Spend Down Not Met"},null,{"$f":"IF(AND(AND($K$9>=$I$5,$I$5<>$F$10,$A$19<>$A$20)),\"ERROR!\",\"no data\")","v":"no data"},null,{"$f":"IF(C8=\"ERROR!\",\"Too many expenses entered.  Press Delete Expense.\",\"no data\")","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Not Met\",\"Spend down has not been met.  Enter additional expenses.\",\"No Data\")","v":"Spend down has not been met.  Enter additional expenses."},null,null,null,null,null,{"$f":"IF($G$12=\"SDCO\",\"Carryover entered.  Enter Spend down\",\"no data\")","v":"no data"},null,null,null,{"$f":"IF($A$19=$A$20,SUMIFS($I$19:$I$200,$A$19:$A$200,$A$19),SUM($I$19:$I$250)-$I$19)","v":0},{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"}]
[{"$f":"IF(A8=\"Spend Down Met\",\"Spend down met on\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spend Down Met\",IF(AND($J$2=\"D - Check Received\",COUNTA($A$19:$A$200)<1), $K$2,$A$19),\"no data\")","v":"no data"},{"$f":"IF(A8=\"Spend Down Met\",  \"with a liability of\",\"no data\")","v":"no data"},null,{"$f":"IF(SUM($L$11:$L$12)>$I$5,0,$L$10)","v":"no data"},{"$f":"IF($G$12=\"SDCO\",\"amount and Commit New Expense.\",\"no data\")","v":"no data"},null,null,null,{"$f":"I5-K9","v":1},{"$f":"IF(AND($C$19=\"C - Paid by Customer\",$A$8=\"Spend Down Met\"),0,$K$15)","v":"no data"}]
["Insert New Expense Here",null,null,null,"Service Date:",null,null,null,null,null,{"$f":"SUM($I$19:$I$200)","v":0}]
[{"$f":"IF(C8=\"ERROR!\",\"H\",\"no data\")","v":"no data"},null,null,null,"Service Type/Code:",null,null,null,{"$f":"IF(A8=\"Spend Down Met\",\"C\",\"no data\")","v":"no data"},null,{"$f":"IF($A$8=\"Spenddown Met\",$K$10,\"no data\")","v":"no data"}]
[null,null,null,null,"Provider:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"Paid by Customer\")","v":0}]
[null,null,null,null,"Total Expense:",null,null,null,null,null,{"$f":"SUMIFS($I$19:$I$200,$C$19:$C$200,\"C - Paid by Customer\",$C$19:$C$200,\"D - Check Received\")","v":0}]
[null,null,null,null,"3rd Party Responsibility:",null,null,null,null,null,{"$f":"IF(AND($A$19=$A$20,$A$8=\"Spend Down Met\"),IF($A$19=$A$20,$I$5-SUMIFS($I$19:$I$200,$A$19:$A$200,\"<>\"&$A$19),$K$12),IF($A$8=\"Spend Down Met\",$K$10,\"no data\"))","v":"no data"}]
[null,null,null,null,"Customer Responsibility:",null,{"$f":"G14-G15","v":0},null,null,null,{"$f":"IF($J$2=\"D - Check Received\",$H$1,$A$19)","v":0}]
["List of December Charges:",null,null,null,"Billing:",null,"(Pull-Down and Select)"]
["Date","Service Type/Code","Billing","Provider",null,"Total Expense","Medicare/3rd Party Paid","Customer Responsibility"]