{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Instructions","HistoryForm","Settings","Sheet1","Base","Final","Summary","Bank Dep","Pers Exp","433-A","Bus Exp","433-B","Assets","Other","ShadowSheet"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":1,"defined_names":309,"comments":1,"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":"Instructions","index":0,"n_rows":298,"n_cols":14,"rows_kept":298,"cut":false,"hidden":true,"merged":[[297,11,303,15],[24,9,32,12],[62,10,68,14],[102,11,106,15],[151,12,159,16],[203,13,212,16],[250,12,254,16]]}
[2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Summary"]
[]
[]
[null,null,null,null,null,null,null,null,null,"There is nothing on the summary sheet that will automatically calculate except the totals.  That is done purposely because as we all know, nothing is \"cut & dry\".  Sometimes we need to make adjustments for some reason or another.  Just make sure you explain it in your history."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bank Deposits"]
[null,null,null,null,null,null,null,null,null,null,"While the bank deposits sheet is broken down into two business accounts & two personal accounts, you can, of course, use it however you want.\n\nThe word \"Account\" is where you identify the account for your own reference.\n\nThis sheet will give you the average of each accounts deposits and also the average deposits of the \"Business\" & the \"Personal\".  If you want the average of all 4, you will have to do it manually."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Personal Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,"On this sheet you can insert every expense the TP gives you & then, under category, select what category it goes to.  The chart on the right will total each category for you.\n\nWhen you go to the 433-A sheet, there is a button you can click to fill in the 433-A with these values."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["433-A"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"This sheet will total the 433-A info for you. \n\nThere are a couple things that are not so obvious.\n\n1. The two \"List\" buttons will take you to a table where you can list the individual expenses for \"Other\".  Other will then populate with that total.\n2. The oval button above allowable expenses selects where you want to get the total.  For example, if you want to simply use the 433-A & input allowables, click the button until the arrow on the right says \"Values are from 433-A\".  Otherwise, click it again & it will populate the numbers from the \"Personal Expenses\" sheet."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["433-B"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Not much to this one.  You just fill in the lighter colored cells & the sheet will total them.\n\nThe \"Other\" expenses list is below the table."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Assets",null,null,null,null,null,null,null,null,null,null,null,"The Assets page you can list assets, input the FMV and encumbrances.  The sheet will automatically calculate the equity, forced sale value and any proceeds we would realize from the sale.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Other"]
[null,null,null,null,null,null,null,null,null,null,null,"This page is for whatever else you may want to get the average of.  Just name it in the \"Item\" field & put the values in the list below.  It will average & total for you."]

{"sheet":"HistoryForm","index":1,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,7,11,7]]}
[{"$f":"COUNTIF(D:D,\"?????\")","v":9},{"$f":"\"Issues to address before closing: \"&A1","v":"Issues to address before closing: 9"},false,null,"NoShow","NoShow",null,null,null,null,null,null,null,null,null,{"$f":"INDEX(CloseType[],MATCH(B2,ClosingTypes,0),3)","v":21}]
["D1","Fully Compliant"]
[{"$f":"IF(B3=\"\",\"\",MATCH(B3,ValidRequirements[Valid Requirements],0))+69","v":92},"History Note / Closing Summary",{"$f":"IF(B3=\"\",FALSE,TRUE)","v":true},{"$f":"IF(HistoryForm!B3=\"\",\"\",INDEX(ValidRequirements[],MATCH(B3,ValidRequirements[Valid Requirements],0),2))","v":"?????"},null," \n \n"]
[{"$f":"IF(B4=\"\",\"\",MATCH(B4,ValidRequirements[Valid Requirements],0))+69","v":111},"Taxpayer Rights must be documented",{"$f":"IF(B4=\"\",FALSE,TRUE)","v":true},{"$f":"IF(HistoryForm!B4=\"\",\"\",INDEX(ValidRequirements[],MATCH(B4,ValidRequirements[Valid Requirements],0),2))","v":"?????"},null," \n \n"]
[{"$f":"IF(B5=\"\",\"\",MATCH(B5,ValidRequirements[Valid Requirements],0))+69","v":72},"3rd party contacts must be documented",true,{"$f":"IF(HistoryForm!B5=\"\",\"\",INDEX(ValidRequirements[],MATCH(B5,ValidRequirements[Valid Requirements],0),2))","v":"?????"},null," \n \n"]
[{"$f":"IF(B6=\"\",\"\",MATCH(B6,ValidRequirements[Valid Requirements],0))+69","v":77},"All IDRS modules addressed",true,{"$f":"IF(HistoryForm!B6=\"\",\"\",INDEX(ValidRequirements[],MATCH(B6,ValidRequirements[Valid Requirements],0),2))","v":"?????"},null," \n \n"]
[{"$f":"IF(B7=\"\",\"\",MATCH(B7,ValidRequirements[Valid Requirements],0))+69","v":70},"1040 INFO : Filing and current ES",true,{"$f":"IF(HistoryForm!B7=\"\",\"\",INDEX(ValidRequirements[],MATCH(B7,ValidRequirements[Valid Requirements],0),2))","v":"?????"},null," \n \n"]
[{"$f":"IF(B8=\"\",\"\",MATCH(B8,ValidRequirements[Valid Requirements],0))+69","v":74},"941 INFO  : Filing, type of depositor and current FTD",true,{"$f":"IF(HistoryForm!B8=\"\",\"\",INDEX(ValidRequirements[],MATCH(B8,ValidRequirements[Valid Requirements],0),2))","v":"?????"},null," \n \n"]
[{"$f":"IF(B9=\"\",\"\",MATCH(B9,ValidRequirements[Valid Requirements],0))+69","v":73},"940 INFO  : Filing and current FTD",true,{"$f":"IF(HistoryForm!B9=\"\",\"\",INDEX(ValidRequirements[],MATCH(B9,ValidRequirements[Valid Requirements],0),2))","v":"?????"},null," \n \n"]
[{"$f":"IF(B10=\"\",\"\",MATCH(B10,ValidRequirements[Valid Requirements],0))+69","v":71},"1120 INFO : Filing and current ES",true,{"$f":"IF(HistoryForm!B10=\"\",\"\",INDEX(ValidRequirements[],MATCH(B10,ValidRequirements[Valid Requirements],0),2))","v":"?????"},null," \n \n"]
[{"$f":"IF(B11=\"\",\"\",MATCH(B11,ValidRequirements[Valid Requirements],0))+69","v":104},"OTHER INFO",true,{"$f":"IF(HistoryForm!B11=\"\",\"\",INDEX(ValidRequirements[],MATCH(B11,ValidRequirements[Valid Requirements],0),2))","v":"?????"},null," \n \n"]
[{"$f":"IF(B12=\"\",\"\",MATCH(B12,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B12=\"\",\"\",INDEX(ValidRequirements[],MATCH(B12,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B13=\"\",\"\",MATCH(B13,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B13=\"\",\"\",INDEX(ValidRequirements[],MATCH(B13,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B14=\"\",\"\",MATCH(B14,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B14=\"\",\"\",INDEX(ValidRequirements[],MATCH(B14,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B15=\"\",\"\",MATCH(B15,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B15=\"\",\"\",INDEX(ValidRequirements[],MATCH(B15,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B16=\"\",\"\",MATCH(B16,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B16=\"\",\"\",INDEX(ValidRequirements[],MATCH(B16,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B17=\"\",\"\",MATCH(B17,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B17=\"\",\"\",INDEX(ValidRequirements[],MATCH(B17,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B18=\"\",\"\",MATCH(B18,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B18=\"\",\"\",INDEX(ValidRequirements[],MATCH(B18,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B19=\"\",\"\",MATCH(B19,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B19=\"\",\"\",INDEX(ValidRequirements[],MATCH(B19,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B20=\"\",\"\",MATCH(B20,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B20=\"\",\"\",INDEX(ValidRequirements[],MATCH(B20,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B21=\"\",\"\",MATCH(B21,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B21=\"\",FALSE,TRUE)","v":false},{"$f":"IF(HistoryForm!B21=\"\",\"\",INDEX(ValidRequirements[],MATCH(B21,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B22=\"\",\"\",MATCH(B22,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B22=\"\",\"\",INDEX(ValidRequirements[],MATCH(B22,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B23=\"\",\"\",MATCH(B23,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B23=\"\",\"\",INDEX(ValidRequirements[],MATCH(B23,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B24=\"\",\"\",MATCH(B24,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B24=\"\",\"\",INDEX(ValidRequirements[],MATCH(B24,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B25=\"\",\"\",MATCH(B25,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B25=\"\",\"\",INDEX(ValidRequirements[],MATCH(B25,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B26=\"\",\"\",MATCH(B26,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B26=\"\",\"\",INDEX(ValidRequirements[],MATCH(B26,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B27=\"\",\"\",MATCH(B27,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B27=\"\",\"\",INDEX(ValidRequirements[],MATCH(B27,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B28=\"\",\"\",MATCH(B28,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B28=\"\",\"\",INDEX(ValidRequirements[],MATCH(B28,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B29=\"\",\"\",MATCH(B29,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B29=\"\",\"\",INDEX(ValidRequirements[],MATCH(B29,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B30=\"\",\"\",MATCH(B30,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B30=\"\",\"\",INDEX(ValidRequirements[],MATCH(B30,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B31=\"\",\"\",MATCH(B31,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B31=\"\",\"\",INDEX(ValidRequirements[],MATCH(B31,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B32=\"\",\"\",MATCH(B32,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B32=\"\",\"\",INDEX(ValidRequirements[],MATCH(B32,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B33=\"\",\"\",MATCH(B33,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B33=\"\",\"\",INDEX(ValidRequirements[],MATCH(B33,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B34=\"\",\"\",MATCH(B34,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B34=\"\",\"\",INDEX(ValidRequirements[],MATCH(B34,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B35=\"\",\"\",MATCH(B35,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,false,{"$f":"IF(HistoryForm!B35=\"\",\"\",INDEX(ValidRequirements[],MATCH(B35,ValidRequirements[Valid Requirements],0),2))","v":""},null," \n \n"]
[{"$f":"IF(B36=\"\",\"\",MATCH(B36,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(B36=\"\",\"\",INDEX(ValidRequirements[[#All],[Valid Requirements]:[Answers]],MATCH(HistoryForm!B36,ValidRequirements[Valid Requirements]),2))","v":""}]
[{"$f":"IF(B37=\"\",\"\",MATCH(B37,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(B37=\"\",\"\",INDEX(ValidRequirements[[#All],[Valid Requirements]:[Answers]],MATCH(HistoryForm!B37,ValidRequirements[Valid Requirements]),2))","v":""}]
[{"$f":"IF(B38=\"\",\"\",MATCH(B38,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(B38=\"\",\"\",INDEX(ValidRequirements[[#All],[Valid Requirements]:[Answers]],MATCH(HistoryForm!B38,ValidRequirements[Valid Requirements]),2))","v":""}]
[{"$f":"IF(B39=\"\",\"\",MATCH(B39,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(B39=\"\",\"\",INDEX(ValidRequirements[[#All],[Valid Requirements]:[Answers]],MATCH(HistoryForm!B39,ValidRequirements[Valid Requirements]),2))","v":""}]
[{"$f":"IF(B40=\"\",\"\",MATCH(B40,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(B40=\"\",\"\",INDEX(ValidRequirements[[#All],[Valid Requirements]:[Answers]],MATCH(HistoryForm!B40,ValidRequirements[Valid Requirements]),2))","v":""}]
[{"$f":"IF(B41=\"\",\"\",MATCH(B41,ValidRequirements[Valid Requirements],0))+69","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(B41=\"\",\"\",INDEX(ValidRequirements[[#All],[Valid Requirements]:[Answers]],MATCH(HistoryForm!B41,ValidRequirements[Valid Requirements]),2))","v":""}]

{"sheet":"Settings","index":2,"n_rows":61,"n_cols":39,"rows_kept":61,"cut":false,"hidden":true,"merged":[[59,14,59,19],[60,14,60,19],[53,14,53,19],[54,14,54,19],[55,14,55,19],[56,14,56,19],[57,14,57,19],[58,14,58,19],[52,14,52,19],[41,14,41,19],[42,14,42,19],[43,14,43,19],[44,14,44,19],[45,14,45,19],[46,14,46,19],[47,14,47,19],[48,14,48,19],[49,14,49,19],[50,14,50,19],[51,14,51,19],[40,14,40,19],[35,14,35,19],[36,14,36,19],[37,14,37,19],[38,14,38,19],[39,14,39,19]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Today:",null,null,941,"Filed","Balance",940,"Filed","Balance","1120 / 1065","Filed","Balance",1040,"Filed","Balance","Other","Filed","Balance",null,null,"Years","Months","Day"]
[null,null,null,null,"First Name","David",null,null,"Title","Revenue Officer",null,null,{"$f":"TODAY()","v":"2022-05-25"},null,null,{"$f":"YEAR(AG3)&TEXT(AK3,\"00\")","v":"202206"},false,null,{"$f":"YEAR($M$3)-1&\"12\"","v":"202112"},null,null,{"$f":"YEAR($M$3)-1&\"12\"","v":"202112"},null,null,{"$f":"YEAR($M$3)-1&\"12\"","v":"202112"},null,null,null,null,null,null,{"$f":"M3","v":"2022-05-25"},{"$f":"DATE(YEAR(AF3), MONTH(AF3), DAY(AF3))","v":"2022-05-25"},{"$f":"DATE(YEAR(AF3), MONTH(AF3), DAY(AF3))","v":"2022-05-25"},{"$f":"DATE(YEAR(AF3), MONTH(AF3), DAY(AF3))","v":"2022-05-25"},{"$f":"_xlfn.XLOOKUP(VALUE(MONTH(AH3)),$AL$3:$AL$14,$AM$3:$AM$14,\"No match\",0)","v":"2nd qtr."},{"$f":"_xlfn.XLOOKUP(AJ3,$AL$16:$AL$19,$AM$16:$AM$19,\"none\",0)","v":6},1,"1st qtr."]
[null,null,null,null,"Last Name","Collins",null,null,"Group Managers Name","George Cupp",null,null,null,null,null,"202103",null,null,{"$f":"YEAR($M$3)-2&\"12\"","v":"202012"},null,null,{"$f":"YEAR($M$3)-2&\"12\"","v":"202012"},null,null,{"$f":"YEAR($M$3)-2&\"12\"","v":"202012"},null,null,null,null,null,null,{"$f":"DATE(YEAR(AF3), MONTH(AF3)-3, DAY(AF3))","v":"2022-02-25"},{"$f":"DATE(YEAR(AF4), MONTH(AF4)-3, DAY(AF4))","v":"2021-11-25"},{"$f":"DATE(YEAR(AF4), MONTH(AF4), DAY(AF4))","v":"2022-02-25"},{"$f":"DATE(YEAR(AF4), MONTH(AF4), DAY(AF4))","v":"2022-02-25"},{"$f":"_xlfn.XLOOKUP(VALUE(MONTH(AH4)),$AL$3:$AL$14,$AM$3:$AM$14,\"No match\",0)","v":"1st qtr."},{"$f":"_xlfn.XLOOKUP(AJ4,$AL$16:$AL$19,$AM$16:$AM$19,\"none\",0)","v":3},2,"1st qtr."]
[null,null,null,null,"SEID","X2DNB",null,null,"Group Managers Email","George.Cupp@irs.gov",null,null,null,null,null,"202112",null,null,{"$f":"YEAR($M$3)-3&\"12\"","v":"201912"},null,null,{"$f":"YEAR($M$3)-3&\"12\"","v":"201912"},null,null,{"$f":"YEAR($M$3)-3&\"12\"","v":"201912"},null,null,null,null,null,null,{"$f":"DATE(YEAR(AF4), MONTH(AF4)-3, DAY(AF4))","v":"2021-11-25"},{"$f":"DATE(YEAR(AF5), MONTH(AF5)-3, DAY(AF5))","v":"2021-08-25"},{"$f":"DATE(YEAR(AF5), MONTH(AF5), DAY(AF5))","v":"2021-11-25"},{"$f":"DATE(YEAR(AF5), MONTH(AF5), DAY(AF5))","v":"2021-11-25"},{"$f":"_xlfn.XLOOKUP(VALUE(MONTH(AH5)),$AL$3:$AL$14,$AM$3:$AM$14,\"No match\",0)","v":"4th qtr."},12,3,"1st qtr."]
[null,null,null,null,"Address Line 1","5740 Uptain Rd, Ste 7800",null,null,"Group Secretary's Name","Paula Jeffreys",null,null,null,null,null,"202109",null,null,{"$f":"YEAR($M$3)-4&\"12\"","v":"201812"},null,null,{"$f":"YEAR($M$3)-4&\"12\"","v":"201812"},null,null,{"$f":"YEAR($M$3)-4&\"12\"","v":"201812"},null,null,null,null,null,null,"2021-08-25","2021-05-25","2021-08-25","2021-08-25","3rd qtr.",9,4,"2nd qtr."]
[null,null,null,null,"Address Line 2",null,null,null,"Group Secretary's Email","Paula.H.Jeffery@irs.gov",null,null,null,null,null,"202106",null,null,{"$f":"YEAR($M$3)-5&\"12\"","v":"201712"},null,null,{"$f":"YEAR($M$3)-5&\"12\"","v":"201712"},null,null,{"$f":"YEAR($M$3)-5&\"12\"","v":"201712"},null,null,null,null,null,null,"2021-05-25","2021-02-25","2021-05-25","2021-05-25","2nd qtr.",6,5,"2nd qtr."]
[null,null,null,null,"Address Line 3",null,null,null,null,null,null,null,null,null,null,"202003",null,null,{"$f":"YEAR($M$3)-6&\"12\"","v":"201612"},null,null,{"$f":"YEAR($M$3)-6&\"12\"","v":"201612"},null,null,{"$f":"YEAR($M$3)-6&\"12\"","v":"201612"},null,null,null,null,null,null,"2021-02-25","2020-11-25","2021-02-25","2021-02-25","1st qtr.",3,6,"2nd qtr."]
[null,null,null,null,"City","Chattanooga",null,null,null,null,null,null,null,null,null,"202012",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-25","2020-08-25","2020-11-25","2020-11-25","4th qtr.",12,7,"3rd qtr."]
[null,null,null,null,"State","TN",null,null,null,null,null,null,null,null,null,"202009",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-08-25","2020-05-25","2020-08-25","2020-08-25","3rd qtr.",9,8,"3rd qtr."]
[null,null,null,null,"Zip",37411,null,null,null,null,null,null,null,null,null,"202006",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-25","2020-02-25","2020-05-25","2020-05-25","2nd qtr.",6,9,"3rd qtr."]
[null,null,null,null,"Phone 1",4238556022,null,null,null,null,null,null,null,null,null,"201903",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-02-25","2019-11-25","2020-02-25","2020-02-25","1st qtr.",3,10,"4th qtr."]
[null,null,null,null,"Cell Phone",4234389989,null,null,null,null,null,null,null,null,null,"201912",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-25","2019-08-25","2019-11-25","2019-11-25","4th qtr.",12,11,"4th qtr."]
[null,null,null,null,"Fax",8176216314,null,null,null,null,null,null,null,null,null,"201909",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-25","2019-05-25","2019-08-25","2019-08-25","3rd qtr.",9,12,"4th qtr."]
[null,null,null,null,"Email","david.collins@irs.gov",null,null,null,null,null,null,null,null,null,"201906",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-25","2019-02-25","2019-05-25","2019-05-25","2nd qtr.",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201803",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-25","2018-11-25","2019-02-25","2019-02-25","1st qtr.",3,"1st qtr.",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201812",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-11-25","2018-08-25","2018-11-25","2018-11-25","4th qtr.",12,"2nd qtr.",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201809",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-08-25","2018-05-25","2018-08-25","2018-08-25","3rd qtr.",9,"3rd qtr.",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201806",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-05-25","2018-02-25","2018-05-25","2018-05-25","2nd qtr.",6,"4th qtr.",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201703",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-02-25","2017-11-25","2018-02-25","2018-02-25","1st qtr.",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201712",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-11-25","2017-08-25","2017-11-25","2017-11-25","4th qtr.",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201709",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-08-25","2017-05-25","2017-08-25","2017-08-25","3rd qtr.",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201706",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-05-25","2017-02-25","2017-05-25","2017-05-25","2nd qtr.",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201603",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-02-25","2016-11-25","2017-02-25","2017-02-25","1st qtr.",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201612",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-11-25","2016-08-25","2016-11-25","2016-11-25","4th qtr.",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201609",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-08-25","2016-05-25","2016-08-25","2016-08-25","3rd qtr.",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201606",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-05-25","2016-02-25","2016-05-25","2016-05-25","2nd qtr.",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201503",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-02-25","2015-11-25","2016-02-25","2016-02-25","1st qtr.",3]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"01 \"&P3","v":"01 202206"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"01 \"&P4","v":"01 202103"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 202112"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 202109"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 202106"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 202003"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 202012"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 202009"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 202006"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201903"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201912"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201909"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201906"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201803"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201812"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201809"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201806"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201703"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201712"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201709"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201706"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201603"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201612"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201609"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201606"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01 201503"]

{"sheet":"Sheet1","index":3,"n_rows":118,"n_cols":16,"rows_kept":118,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,"Label",2," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",4,"\")",null,{"$f":"G4&H4&I4&J4&K4","v":"Label2 = ThisWorkbook.Sheets(\"Settings\").Range(\"P4\")"}]
[null,null,null,null,null,null,"Label",3," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",5,"\")",null,{"$f":"G5&H5&I5&J5&K5","v":"Label3 = ThisWorkbook.Sheets(\"Settings\").Range(\"P5\")"}]
[null,null,null,null,null,null,"Label",4," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",6,"\")",null,{"$f":"G6&H6&I6&J6&K6","v":"Label4 = ThisWorkbook.Sheets(\"Settings\").Range(\"P6\")"}]
[null,null,null,null,null,null,"Label",5," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",7,"\")",null,"Label5 = ThisWorkbook.Sheets(\"Settings\").Range(\"P7\")"]
[null,null,null,null,null,null,"Label",6," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",8,"\")",null,"Label6 = ThisWorkbook.Sheets(\"Settings\").Range(\"P8\")"]
[null,null,null,null,null,null,"Label",7," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",9,"\")",null,"Label7 = ThisWorkbook.Sheets(\"Settings\").Range(\"P9\")"]
[null,null,null,null,null,null,"Label",8," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",10,"\")",null,"Label8 = ThisWorkbook.Sheets(\"Settings\").Range(\"P10\")"]
[null,null,null,null,null,null,"Label",9," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",11,"\")",null,"Label9 = ThisWorkbook.Sheets(\"Settings\").Range(\"P11\")"]
[null,null,null,null,null,null,"Label",10," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",12,"\")",null,"Label10 = ThisWorkbook.Sheets(\"Settings\").Range(\"P12\")"]
[null,null,null,null,null,null,"Label",11," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",13,"\")",null,"Label11 = ThisWorkbook.Sheets(\"Settings\").Range(\"P13\")"]
[null,null,null,null,null,null,"Label",12," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",14,"\")",null,"Label12 = ThisWorkbook.Sheets(\"Settings\").Range(\"P14\")"]
[null,null,null,null,null,null,"Label",13," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",15,"\")",null,"Label13 = ThisWorkbook.Sheets(\"Settings\").Range(\"P15\")"]
[null,null,null,null,null,null,"Label",14," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",16,"\")",null,"Label14 = ThisWorkbook.Sheets(\"Settings\").Range(\"P16\")"]
[null,null,null,null,null,null,"Label",15," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",17,"\")",null,"Label15 = ThisWorkbook.Sheets(\"Settings\").Range(\"P17\")"]
[null,null,null,null,null,null,"Label",16," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",18,"\")",null,"Label16 = ThisWorkbook.Sheets(\"Settings\").Range(\"P18\")"]
[null,null,null,null,null,null,"Label",17," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",19,"\")",null,"Label17 = ThisWorkbook.Sheets(\"Settings\").Range(\"P19\")"]
[null,null,null,null,null,null,"Label",18," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",20,"\")",null,"Label18 = ThisWorkbook.Sheets(\"Settings\").Range(\"P20\")"]
[null,null,null,null,null,null,"Label",19," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",21,"\")",null,"Label19 = ThisWorkbook.Sheets(\"Settings\").Range(\"P21\")"]
[null,null,null,null,null,null,"Label",20," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",22,"\")",null,"Label20 = ThisWorkbook.Sheets(\"Settings\").Range(\"P22\")"]
[null,null,null,null,null,null,"Label",21," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",23,"\")",null,"Label21 = ThisWorkbook.Sheets(\"Settings\").Range(\"P23\")"]
[null,null,null,null,null,null,"Label",22," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",24,"\")",null,"Label22 = ThisWorkbook.Sheets(\"Settings\").Range(\"P24\")"]
[null,null,null,null,null,null,"Label",23," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",25,"\")",null,"Label23 = ThisWorkbook.Sheets(\"Settings\").Range(\"P25\")"]
[null,null,null,null,null,null,"Label",24," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",26,"\")",null,"Label24 = ThisWorkbook.Sheets(\"Settings\").Range(\"P26\")"]
[null,null,null,null,null,null,"Label",25," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",27,"\")",null,{"$f":"G27&H27&I27&J27&K27","v":"Label25 = ThisWorkbook.Sheets(\"Settings\").Range(\"P27\")"}]
[null,null,null,null,null,null,"Label",26," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",28,"\")",null,{"$f":"G28&H28&I28&J28&K28","v":"Label26 = ThisWorkbook.Sheets(\"Settings\").Range(\"P28\")"}]
[]
[]
[]
[]
[null,null,null,null,null,null,"Label",26," = ThisWorkbook.Sheets(\"Settings\").Range(\"P",28,"\")",null,{"$f":"G33&H33&I33&J33&K33","v":"Label26 = ThisWorkbook.Sheets(\"Settings\").Range(\"P28\")"}]
[]
[null,null,null,null,null,null,null,null,"Checkbox",2,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",4,"\")",null,{"$f":"I35&J35&K35&L35&M35&N35","v":"Checkbox2.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q4\")"}]
[null,null,null,null,null,null,null,null,"Checkbox",3,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",5,"\")",null,{"$f":"I36&J36&K36&L36&M36&N36","v":"Checkbox3.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q5\")"}]
[null,null,null,null,null,null,null,null,"Checkbox",4,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",6,"\")",null,"Checkbox4.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q6\")"]
[null,null,null,null,null,null,null,null,"Checkbox",5,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",7,"\")",null,"Checkbox5.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q7\")"]
[null,null,null,null,null,null,null,null,"Checkbox",6,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",8,"\")",null,"Checkbox6.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q8\")"]
[null,null,null,null,null,null,null,null,"Checkbox",7,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",9,"\")",null,"Checkbox7.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q9\")"]
[null,null,null,null,null,null,null,null,"Checkbox",8,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",10,"\")",null,"Checkbox8.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q10\")"]
[null,null,null,null,null,null,null,null,"Checkbox",9,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",11,"\")",null,"Checkbox9.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q11\")"]
[null,null,null,null,null,null,null,null,"Checkbox",10,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",12,"\")",null,"Checkbox10.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q12\")"]
[null,null,null,null,null,null,null,null,"Checkbox",11,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",13,"\")",null,"Checkbox11.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q13\")"]
[null,null,null,null,null,null,null,null,"Checkbox",12,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",14,"\")",null,"Checkbox12.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q14\")"]
[null,null,null,null,null,null,null,null,"Checkbox",13,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",15,"\")",null,"Checkbox13.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q15\")"]
[null,null,null,null,null,null,null,null,"Checkbox",14,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",16,"\")",null,"Checkbox14.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q16\")"]
[null,null,null,null,null,null,null,null,"Checkbox",15,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",17,"\")",null,"Checkbox15.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q17\")"]
[null,null,null,null,null,null,null,null,"Checkbox",16,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",18,"\")",null,"Checkbox16.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q18\")"]
[null,null,null,null,null,null,null,null,"Checkbox",17,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",19,"\")",null,"Checkbox17.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q19\")"]
[null,null,null,null,null,null,null,null,"Checkbox",18,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",20,"\")",null,"Checkbox18.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q20\")"]
[null,null,null,null,null,null,null,null,"Checkbox",19,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",21,"\")",null,"Checkbox19.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q21\")"]
[null,null,null,null,null,null,null,null,"Checkbox",20,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",22,"\")",null,"Checkbox20.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q22\")"]
[null,null,null,null,null,null,null,null,"Checkbox",21,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",23,"\")",null,"Checkbox21.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q23\")"]
[null,null,null,null,null,null,null,null,"Checkbox",22,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",24,"\")",null,"Checkbox22.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q24\")"]
[null,null,null,null,null,null,null,null,"Checkbox",23,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",25,"\")",null,"Checkbox23.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q25\")"]
[null,null,null,null,null,null,null,null,"Checkbox",24,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",26,"\")",null,"Checkbox24.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q26\")"]
[null,null,null,null,null,null,null,null,"Checkbox",25,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",27,"\")",null,"Checkbox25.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q27\")"]
[null,null,null,null,null,null,null,null,"Checkbox",26,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",28,"\")",null,"Checkbox26.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q28\")"]
[null,null,null,null,null,null,null,null,"Checkbox",27,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"Q",29,"\")",null,"Checkbox27.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"Q29\")"]
[]
[]
[null,null,null,null,null,null,null,null,"Note",1,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",36,"\")",null,{"$f":"I63&J63&K63&L63&M63&N63","v":"Note1.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O36\")"}]
[null,null,null,null,null,null,null,null,"Note",2,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",37,"\")",null,{"$f":"I64&J64&K64&L64&M64&N64","v":"Note2.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O37\")"}]
[null,null,null,null,null,null,null,null,"Note",3,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",38,"\")",null,"Note3.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O38\")"]
[null,null,null,null,null,null,null,null,"Note",4,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",39,"\")",null,"Note4.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O39\")"]
[null,null,null,null,null,null,null,null,"Note",5,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",40,"\")",null,"Note5.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O40\")"]
[null,null,null,null,null,null,null,null,"Note",6,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",41,"\")",null,"Note6.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O41\")"]
[null,null,null,null,null,null,null,null,"Note",7,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",42,"\")",null,"Note7.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O42\")"]
[null,null,null,null,null,null,null,null,"Note",8,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",43,"\")",null,"Note8.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O43\")"]
[null,null,null,null,null,null,null,null,"Note",9,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",44,"\")",null,"Note9.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O44\")"]
[null,null,null,null,null,null,null,null,"Note",10,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",45,"\")",null,"Note10.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O45\")"]
[null,null,null,null,null,null,null,null,"Note",11,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",46,"\")",null,"Note11.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O46\")"]
[null,null,null,null,null,null,null,null,"Note",12,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",47,"\")",null,"Note12.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O47\")"]
[null,null,null,null,null,null,null,null,"Note",13,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",48,"\")",null,"Note13.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O48\")"]
[null,null,null,null,null,null,null,null,"Note",14,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",49,"\")",null,"Note14.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O49\")"]
[null,null,null,null,null,null,null,null,"Note",15,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",50,"\")",null,"Note15.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O50\")"]
[null,null,null,null,null,null,null,null,"Note",16,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",51,"\")",null,"Note16.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O51\")"]
[null,null,null,null,null,null,null,null,"Note",17,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",52,"\")",null,"Note17.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O52\")"]
[null,null,null,null,null,null,null,null,"Note",18,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",53,"\")",null,"Note18.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O53\")"]
[null,null,null,null,null,null,null,null,"Note",19,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",54,"\")",null,"Note19.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O54\")"]
[null,null,null,null,null,null,null,null,"Note",20,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",55,"\")",null,"Note20.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O55\")"]
[null,null,null,null,null,null,null,null,"Note",21,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",56,"\")",null,"Note21.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O56\")"]
[null,null,null,null,null,null,null,null,"Note",22,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",57,"\")",null,"Note22.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O57\")"]
[null,null,null,null,null,null,null,null,"Note",23,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",58,"\")",null,"Note23.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O58\")"]
[null,null,null,null,null,null,null,null,"Note",24,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",59,"\")",null,"Note24.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O59\")"]
[null,null,null,null,null,null,null,null,"Note",25,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",60,"\")",null,"Note25.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O60\")"]
[null,null,null,null,null,null,null,null,"Note",26,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"O",61,"\")",null,"Note26.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"O61\")"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Balance",1,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",3,"\")",null,{"$f":"I93&J93&K93&L93&M93&N93","v":"Balance1.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R3\")"}]
[null,null,null,null,null,null,null,null,"Balance",2,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",4,"\")",null,{"$f":"I94&J94&K94&L94&M94&N94","v":"Balance2.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R4\")"}]
[null,null,null,null,null,null,null,null,"Balance",3,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",5,"\")",null,"Balance3.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R5\")"]
[null,null,null,null,null,null,null,null,"Balance",4,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",6,"\")",null,"Balance4.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R6\")"]
[null,null,null,null,null,null,null,null,"Balance",5,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",7,"\")",null,"Balance5.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R7\")"]
[null,null,null,null,null,null,null,null,"Balance",6,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",8,"\")",null,"Balance6.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R8\")"]
[null,null,null,null,null,null,null,null,"Balance",7,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",9,"\")",null,"Balance7.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R9\")"]
[null,null,null,null,null,null,null,null,"Balance",8,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",10,"\")",null,"Balance8.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R10\")"]
[null,null,null,null,null,null,null,null,"Balance",9,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",11,"\")",null,"Balance9.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R11\")"]
[null,null,null,null,null,null,null,null,"Balance",10,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",12,"\")",null,"Balance10.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R12\")"]
[null,null,null,null,null,null,null,null,"Balance",11,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",13,"\")",null,"Balance11.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R13\")"]
[null,null,null,null,null,null,null,null,"Balance",12,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",14,"\")",null,"Balance12.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R14\")"]
[null,null,null,null,null,null,null,null,"Balance",13,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",15,"\")",null,"Balance13.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R15\")"]
[null,null,null,null,null,null,null,null,"Balance",14,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",16,"\")",null,"Balance14.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R16\")"]
[null,null,null,null,null,null,null,null,"Balance",15,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",17,"\")",null,"Balance15.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R17\")"]
[null,null,null,null,null,null,null,null,"Balance",16,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",18,"\")",null,"Balance16.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R18\")"]
[null,null,null,null,null,null,null,null,"Balance",17,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",19,"\")",null,"Balance17.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R19\")"]
[null,null,null,null,null,null,null,null,"Balance",18,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",20,"\")",null,"Balance18.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R20\")"]
[null,null,null,null,null,null,null,null,"Balance",19,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",21,"\")",null,"Balance19.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R21\")"]
[null,null,null,null,null,null,null,null,"Balance",20,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",22,"\")",null,"Balance20.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R22\")"]
[null,null,null,null,null,null,null,null,"Balance",21,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",23,"\")",null,"Balance21.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R23\")"]
[null,null,null,null,null,null,null,null,"Balance",22,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",24,"\")",null,"Balance22.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R24\")"]
[null,null,null,null,null,null,null,null,"Balance",23,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",25,"\")",null,"Balance23.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R25\")"]
[null,null,null,null,null,null,null,null,"Balance",24,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",26,"\")",null,"Balance24.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R26\")"]
[null,null,null,null,null,null,null,null,"Balance",25,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",27,"\")",null,"Balance25.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R27\")"]
[null,null,null,null,null,null,null,null,"Balance",26,".ControlSource=","ThisWorkbook.Sheets(\"Settings\").Range(\"R",28,"\")",null,"Balance26.ControlSource=ThisWorkbook.Sheets(\"Settings\").Range(\"R28\")"]

{"sheet":"Base","index":4,"n_rows":121,"n_cols":29,"rows_kept":121,"cut":false,"hidden":true,"merged":[]}
["Defunct <$25k","Defunct >$25-100k","Defunct>$100k","Defunct>$250k","UTL/UTC <$25k","UTL/UTC >$25k","UTL/UTC >$100k","UTL/UTC >$250k","CNC/Hardship <$10k","CNC/Hardship $10-100k","CNC/Hardship>$100k","CNC/Hardship>$250k","Guaranteed IA","Streamline I","Streamline II","IBTF Express I","IBTF Express II","IBTF IA","Routine IA","PPIA","Fully Compliant","IB53"]
["History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary","History Note / Closing Summary"]
["Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented","Taxpayer Rights must be documented",null,null,null,"Taxpayer Rights must be documented",{"$f":"IF(Z3=\"\",\"\",\"REQ'd\")","v":"REQ'd"},null,{"$f":"IF(AND(AA3=\"REQ'd\",AB3=\"\"),\"?????\",AB3)","v":"?????"}]
["3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented","3rd party contacts must be documented",null,null,null,"3rd party contacts must be documented",{"$f":"IF(Z4=\"\",\"\",\"REQ'd\")","v":"REQ'd"},null,{"$f":"IF(AND(AA4=\"REQ'd\",AB4=\"\"),\"?????\",AB4)","v":"?????"}]
["All IDRS modules addressed","All IDRS modules addressed","All IDRS modules addressed","All IDRS modules addressed","All IDRS modules addressed","All IDRS modules addressed","All IDRS modules addressed","All IDRS modules addressed","All IDRS modules addressed","All IDRS modules addressed","All IDRS modules addressed","All IDRS modules addressed","Type of tax is  Income Tax Only","Type of tax is  IMF, BMF Income, Out of business BMF","Type of tax is  IMF, BMF Income, Out of business BMF","Type of tax is  BMF Trust Fund","Type of tax is  BMF Trust Fund","Type of tax is  BMF Trust Fund","Type of tax is  IMF, BMF Income, Out of business BMF","CIS must be less than 12 months old","All IDRS modules addressed","All IDRS modules addressed",null,null,null,"Research should be commensurate with balance due and  document history as to why not completed.","REQ'd",null,"?????"]
["Make Field Call","Make Field Call","Make Field Call","Make Field Call","NFTL Filing","NFTL Filing","NFTL Filing","NFTL Filing","Make Field Call","NFTL Filing","NFTL Filing","NFTL Filing","Max Payment Term is 3 years & full pay within CSED","Max Payment Term is 72 months & within CSED","Max Payment Term is 72 months & within CSED","Max Payment Term is  24 months & within CSED","Max Payment Term is  24 months & within CSED","Max Payment Term is Within CSED","Max Payment Term is Within CSED","NFTL Filing","1040 INFO : Filing and current ES","Make Field Call",null,null,null,"Need to address levy sources","REQ'd",null,"?????"]
["CIS must be less than 12 months old","CIS must be less than 12 months old","CIS must be less than 12 months old","CIS must be less than 12 months old","Make Field Call","Make Field Call","Make Field Call","Make Field Call","CIS must be less than 12 months old","Make Field Call","Make Field Call","Make Field Call","All IDRS modules addressed","All IDRS modules addressed","Must be DDIA","NFTL Filing","Must be DDIA","CIS must be less than 12 months old","CIS must be less than 12 months old","TFRP, if applicable","941 INFO  : Filing, type of depositor and current FTD","NFTL Filing",null,null,null,"Need to address NFTL Filing","REQ'd",null,"?????"]
["CIS secured on ","CIS secured on ","CIS secured on ","CIS secured on ","Call All Known Telephone Number(s)","Call All Known Telephone Number(s)","Call All Known Telephone Number(s)","Call All Known Telephone Number(s)","CIS secured on ","CIS must be less than 12 months old","CIS must be less than 12 months old","CIS must be less than 12 months old","CIS secured on ","CIS secured on ","All IDRS modules addressed","TFRP, if applicable","NFTL Filing","NFTL Filing","NFTL Filing","Extend CSED if appropriate","940 INFO  : Filing and current FTD","CIS must be less than 12 months old",null,null,null,"Need to make Field Call","REQ'd",null,"?????"]
["Address levy sources","Address levy sources","Address levy sources","Address levy sources","Accurint","Accurint","Accurint","Accurint","Full Compliance Check on Taxpayer/Related Entities","CIS secured on ","CIS secured on ","CIS secured on ","1040 INFO : Filing and current ES","1040 INFO : Filing and current ES","CIS secured on ","All IDRS modules addressed","TFRP, if applicable","TFRP, if applicable","TFRP, if applicable","Verify if TP can pay from available assets","1120 INFO : Filing and current ES","CIS secured on ",null,null,null,"Need to verify that type of tax is  Income Tax Only","REQ'd",null,"?????"]
["TFRP, if applicable","RTVUE, BRTVU, TRDBV Last Filed Return (if filed for one of the immediate two preceding years)","RTVUE, BRTVU, TRDBV Last Filed Return (if filed for one of the immediate two preceding years)","RTVUE, BRTVU, TRDBV Last Filed Return (if filed for one of the immediate two preceding years)","RTVUE, BRTVU, TRDBV Last Filed Return (if filed for one of the immediate two preceding years)","Postal tracers","Postal tracers","Postal tracers","1040 INFO : Filing and current ES","Accurint","Accurint","Accurint","941 INFO  : Filing, type of depositor and current FTD","941 INFO  : Filing, type of depositor and current FTD","1040 INFO : Filing and current ES","CIS secured on ","All IDRS modules addressed","Verify if TP can pay from available assets","Verify if TP can pay from available assets","All IDRS modules addressed","OTHER INFO","RTVUE, BRTVU, TRDBV Last Filed Return (if filed for one of the immediate two preceding years)",null,null,null,"Need to verify that type of tax is  IMF, BMF Income, Out of business BMF","REQ'd",null,"?????"]
["1040 INFO : Filing and current ES","Accurint","Accurint","Accurint","TFRP, if applicable","DMV","DMV","DMV","941 INFO  : Filing, type of depositor and current FTD","RTVUE, BRTVU, TRDBV Last Filed Return (if filed for one of the immediate two preceding years)","RTVUE, BRTVU, TRDBV Last Filed Return (if filed for one of the immediate two preceding years)","RTVUE, BRTVU, TRDBV Last Filed Return (if filed for one of the immediate two preceding years)","940 INFO  : Filing and current FTD","940 INFO  : Filing and current FTD","941 INFO  : Filing, type of depositor and current FTD","1040 INFO : Filing and current ES","CIS secured on ","All IDRS modules addressed","All IDRS modules addressed","CIS secured on ",null,"Accurint",null,null,null,"Need to verify that type of tax is  IMF, Out of business Sole Proprietor","REQ'd",null,"?????"]
["941 INFO  : Filing, type of depositor and current FTD","DMV","DMV","DMV","TC 130 input for Refund Offset and CNC Reactivation - Sole Prop, Gen Ptr, LLC (owner liable)","Courthouse Records Check","Courthouse Records Check","Courthouse Records Check","940 INFO  : Filing and current FTD","IRPTR data","IRPTR data","IRPTR data","1120 INFO : Filing and current ES","1120 INFO : Filing and current ES","940 INFO  : Filing and current FTD","941 INFO  : Filing, type of depositor and current FTD","1040 INFO : Filing and current ES","CIS secured on ","CIS secured on ","1040 INFO : Filing and current ES",null,"DMV",null,null,null,"Need to verify that type of tax is  BMF Trust Fund","REQ'd",null,"?????"]
["940 INFO  : Filing and current FTD","Courthouse Records Check","Courthouse Records Check","Courthouse Records Check","Full Compliance Check on Taxpayer/Related Entities","Employment Commission","Employment Commission","Employment Commission","1120 INFO : Filing and current ES","Full Compliance Check on Taxpayer/Related Entities","DMV","DMV","OTHER INFO","OTHER INFO","1120 INFO : Filing and current ES","940 INFO  : Filing and current FTD","941 INFO  : Filing, type of depositor and current FTD","1040 INFO : Filing and current ES","1040 INFO : Filing and current ES","941 INFO  : Filing, type of depositor and current FTD",null,"Courthouse Records Check",null,null,null,"CIS must be less than 12 months old","REQ'd",null,"?????"]
["1120 INFO : Filing and current ES","Employment Commission","Employment Commission","Employment Commission","1040 INFO : Filing and current ES","FinCEN (when FBAR is filed)","FinCEN (when FBAR is filed)","FinCEN (when FBAR is filed)","OTHER INFO","1040 INFO : Filing and current ES","Courthouse Records Check","Courthouse Records Check",null,null,"OTHER INFO","1120 INFO : Filing and current ES","940 INFO  : Filing and current FTD","941 INFO  : Filing, type of depositor and current FTD","941 INFO  : Filing, type of depositor and current FTD","940 INFO  : Filing and current FTD",null,"Bank Records",null,null,null,"All IDRS modules addressed","REQ'd",null,"?????"]
["OTHER INFO","TFRP, if applicable","Local Licensing authority","Local Licensing authority","941 INFO  : Filing, type of depositor and current FTD","TFRP, if applicable","Local Licensing authority","Local Licensing authority",null,"941 INFO  : Filing, type of depositor and current FTD","Full Compliance Check on Taxpayer/Related Entities","Full Credit Report (IMF)",null,null,null,"OTHER INFO","1120 INFO : Filing and current ES","940 INFO  : Filing and current FTD","940 INFO  : Filing and current FTD","1120 INFO : Filing and current ES",null,"TFRP, if applicable",null,null,null,"Need to call All Known Telephone Number(s)","REQ'd",null,"?????"]
[null,"1040 INFO : Filing and current ES","Bank Records","Bank Records","940 INFO  : Filing and current FTD","TC 130 input for Refund Offset and CNC Reactivation - Sole Prop, Gen Ptr, LLC (owner liable)","Passport (if frequent travel outside the United States)","Passport (if frequent travel outside the United States)",null,"940 INFO  : Filing and current FTD","1040 INFO : Filing and current ES","FinCEN (when FBAR is filed)",null,null,null,null,"OTHER INFO","1120 INFO : Filing and current ES","1120 INFO : Filing and current ES","OTHER INFO",null,"1040 INFO : Filing and current ES",null,null,null,"Need to check IRPTR data","REQ'd",null,"?????"]
[null,"941 INFO  : Filing, type of depositor and current FTD","TFRP, if applicable","Revenue Agent File reviewed (if assessment is for one of the immediate two preceding years)","1120 INFO : Filing and current ES","Full Compliance Check on Taxpayer/Related Entities","TECS reviewed if appropriate","TECS reviewed if appropriate",null,"1120 INFO : Filing and current ES","941 INFO  : Filing, type of depositor and current FTD","CC AMDIS (if -L freeze on account)",null,null,null,null,null,"OTHER INFO","OTHER INFO",null,null,"941 INFO  : Filing, type of depositor and current FTD",null,null,null,"Need to verify that Max Payment Term is 3 years & full pay within CSED","REQ'd",null,"?????"]
[null,"940 INFO  : Filing and current FTD","1040 INFO : Filing and current ES","CC AMDIS (if -L freeze on account)","OTHER INFO","1040 INFO : Filing and current ES","TFRP, if applicable","Full Credit Report (IMF)",null,"OTHER INFO","940 INFO  : Filing and current FTD","Revenue Agent File reviewed (if assessment is for one of the immediate two preceding years)",null,null,null,null,null,null,null,null,null,"940 INFO  : Filing and current FTD",null,null,null,"Need to verify that Max Payment Term is 72 months & within CSED","REQ'd",null,"?????"]
[null,"1120 INFO : Filing and current ES","941 INFO  : Filing, type of depositor and current FTD","TFRP, if applicable",null,"941 INFO  : Filing, type of depositor and current FTD","TC 130 input for Refund Offset and CNC Reactivation - Sole Prop, Gen Ptr, LLC (owner liable)","CC AMDIS (if -L freeze on account)",null,null,"1120 INFO : Filing and current ES","Full Compliance Check on Taxpayer/Related Entities",null,null,null,null,null,null,null,null,null,"1120 INFO : Filing and current ES",null,null,null,"Need to verify that Max Payment Term is  24 months & within CSED","REQ'd",null,"?????"]
[null,"OTHER INFO","940 INFO  : Filing and current FTD","1040 INFO : Filing and current ES",null,"940 INFO  : Filing and current FTD","Full Compliance Check on Taxpayer/Related Entities","TFRP, if applicable",null,null,"OTHER INFO","1040 INFO : Filing and current ES",null,null,null,null,null,null,null,null,null,"OTHER INFO",null,null,null,"Need to verify that Max Payment Term is Within CSED","REQ'd",null,"?????"]
[null,null,"1120 INFO : Filing and current ES","941 INFO  : Filing, type of depositor and current FTD",null,"1120 INFO : Filing and current ES","1040 INFO : Filing and current ES","TC 130 input for Refund Offset and CNC Reactivation - Sole Prop, Gen Ptr, LLC (owner liable)",null,null,null,"941 INFO  : Filing, type of depositor and current FTD",null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to address TFRP, if applicable","REQ'd",null,"?????"]
[null,null,"OTHER INFO","940 INFO  : Filing and current FTD",null,"OTHER INFO","941 INFO  : Filing, type of depositor and current FTD","Full Compliance Check on Taxpayer/Related Entities",null,null,null,"940 INFO  : Filing and current FTD",null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to send postal tracers","REQ'd",null,"?????"]
[null,null,null,"1120 INFO : Filing and current ES",null,null,"940 INFO  : Filing and current FTD","1040 INFO : Filing and current ES",null,null,null,"1120 INFO : Filing and current ES",null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to check Accurint","REQ'd",null,"?????"]
[null,null,null,"OTHER INFO",null,null,"1120 INFO : Filing and current ES","941 INFO  : Filing, type of depositor and current FTD",null,null,null,"OTHER INFO",null,null,null,null,null,null,null,null,null,null,null,null,null,"Utility Companies (UTC)","REQ'd",null,"?????"]
[null,null,null,null,null,null,"OTHER INFO","940 INFO  : Filing and current FTD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to complete full Compliance Check on Taxpayer/Related Entities","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,"1120 INFO : Filing and current ES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to check RTVUE, BRTVU, TRDBV Last Filed Return (if filed for one of the immediate two preceding years)","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,"OTHER INFO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to check DMV","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Must be DDIA","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to check Bank Records","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to input TC 130 for Refund Offset and CNC Reactivation - Sole Prop, Gen Ptr, LLC (owner liable)","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to do Courthouse Records Check","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Can extend CSED if appropriate","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to check Employment Commission","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to check FinCEN (when FBAR is filed)","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verify if TP can pay from available assets","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to check Local Licensing authority","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to check Full Credit Report (IMF)","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to check CC AMDIS (if -L freeze on account)","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to check Revenue Agent File (if assessment is for one of the immediate two preceding years)","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need to check Passport(if frequent travel outside the United States)","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consider checking TECS","REQ'd",null,"?????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0]
[{"$f":"A65&\"2:\"&A65&COUNTA(A1:A63)","v":"A2:A15"},{"$f":"B65&\"2:\"&B65&COUNTA(B1:B63)","v":"B2:B20"},"C2:C22","D2:D24","E2:E18","F2:F22","G2:G25","H2:H27",{"$f":"I65&\"2:\"&I65&COUNTA(I37:I63)","v":"I2:I0"},"J2:J18","K2:K20","L2:L24","M2:M13","N2:N13","O2:O14","P2:P15","Q2:Q16","R2:R17","S2:S17","T2:T16","U2:U10","Y2:Y20","Z2:Z0"]
["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","Y","Z"]
[]
[]
[]
["Valid Requirements","Answers","Answer Input","Indx","Name","Locator"]
["1040 INFO : Filing and current ES",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},"",0,"CNC/Hardship <$10k",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":9}]
["1120 INFO : Filing and current ES",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},"",1,"CNC/Hardship $10-100k",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":10}]
["3rd party contacts must be documented",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},"",2,"CNC/Hardship>$100k",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":11}]
["940 INFO  : Filing and current FTD",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},"",3,"CNC/Hardship>$250k",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":12}]
["941 INFO  : Filing, type of depositor and current FTD",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},"",4,"Defunct <$25k",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":1}]
["Accurint",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,5,"Defunct >$25-100k",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":2}]
["Address levy sources",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,6,"Defunct>$100k",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":3}]
["All IDRS modules addressed",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,7,"Defunct>$250k",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":4}]
["Bank Records",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,20,"Fully Compliant",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":21}]
["Call All Known Telephone Number(s)",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,8,"Guaranteed IA",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":13}]
["CC AMDIS (if -L freeze on account)",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,9,"IB53",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":22}]
["CIS must be less than 12 months old",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},"",10,"IBTF Express I",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":16}]
["CIS secured on ",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},"",11,"IBTF Express II",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":17}]
["CIS verified & equity pursued or explain why not",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,12,"IBTF IA",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":18}]
["Courthouse Records Check",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,13,"PPIA",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":20}]
["DMV",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,14,"Routine IA",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":19}]
["Employment Commission",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,15,"Streamline I",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":14}]
["Extend CSED if appropriate",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,16,"Streamline II",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":15}]
["FinCEN (when FBAR is filed)",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,17,"UTL/UTC <$25k",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":5}]
["Full Compliance Check on Taxpayer/Related Entities",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,18,"UTL/UTC >$25k",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":6}]
["Full Credit Report (IMF)",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,19,"UTL/UTC >$100k",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":7}]
["Full filing compliance",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,21,"UTL/UTC >$250k",{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":8}]
["History Note / Closing Summary",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},"",22,null,{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":{"$error":"#N/A"}}]
["Initiate Mandatory Follow-up",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,23,null,{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":{"$error":"#N/A"}}]
["IRPTR data",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,24,null,{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":{"$error":"#N/A"}}]
["Issue L-903 or explain why not.",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},null,25,null,{"$f":"COLUMN(INDEX($1:$1,1,MATCH(CloseType[[#This Row],[Name]],$1:$1,0)))","v":{"$error":"#N/A"}}]
["Local Licensing authority",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Make Field Call",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Max Payment Term is  24 months & within CSED",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Max Payment Term is 3 years & full pay within CSED",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Max Payment Term is 72 months & within CSED",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Max Payment Term is Within CSED",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Must be DDIA",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["NFTL Filing",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},""]
["OTHER INFO",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},""]
["Passport (if frequent travel outside the United States)",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Postal tracers",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Research should be commensurate with balance due and  document history as to why not completed.",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Revenue Agent File reviewed (if assessment is for one of the immediate two preceding years)",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Review LRF for assets",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["RTVUE, BRTVU, TRDBV Last Filed Return (if filed for one of the immediate two preceding years)",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Taxpayer Rights must be documented",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},""]
["TC 130 input for Refund Offset and CNC Reactivation - Sole Prop, Gen Ptr, LLC (owner liable)",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["TECS reviewed if appropriate",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["TFRP, if applicable",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Type of tax is  BMF Trust Fund",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Type of tax is  IMF, BMF Income, Out of business BMF",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"},""]
["Type of tax is  IMF, Out of business Sole Proprietor",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Type of tax is  Income Tax Only",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Utility Companies (UTC)",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Verify if TP can pay from available assets",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]
["Verify that TP can remain current",{"$f":"IF(ValidRequirements[[#This Row],[Answer Input]]=\"\",\"?????\",ValidRequirements[[#This Row],[Answer Input]])","v":"?????"}]

{"sheet":"Final","index":5,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":true,"merged":[[13,12,14,12],[16,0,32,0],[16,1,16,2],[16,4,16,5],[33,4,33,5],[33,6,33,7],[0,4,0,6],[0,10,0,12],[0,13,0,15],[1,0,14,0],[1,1,1,3],[1,4,1,6],[7,1,7,3],[7,10,7,12],[13,10,14,10],[13,11,14,11]]}
[null,null,null,null,"433-A / S.E.",null,null,null,null,null,"Total Monthly Business Income ",null,null,"Total Monthly Business Expenses "]
["Self Employment","Total Monthly Business Income ",null,null,"Total Monthly Business Expenses",null,null,null,null,null,null,"Source ","Gross Monthly ",null,"Expense Items ","Actual Monthly ","Adjusted Monthly"]
[null,67,"Gross Receipts ",null,77,"Materials Purchased",null,null,null,null,25,"Gross Receipts from Sales/Services ",null,36,"Materials Purchased",null,0]
[null,68,"Gross Rental Income ",null,78,"Inventory Purchased",null,null,null,null,26,"Gross Rental Income ",null,37,"Inventory Purchased",null,0]
[null,69,"Interest ",null,79,"Gross Wages & Salaries",null,null,null,null,27,"Interest Income ",null,38,"Gross Wages & Salaries ",null,0]
[null,70,"Dividends ",null,80,"Rent",null,null,null,null,28,"Dividends ",null,39,"Rent ",null,0]
[null,71,"Cash Receipts not included in lines 67-70",null,81,"Supplies",null,null,null,null,29,"Cash ",null,40,"Supplies",null,0]
[null,"Other Income (Specify below) ",null,null,82,"Utilities/Telephone ",null,null,null,null,"Other Income (Specify below) ",null,null,41,"Utilities/Telephone",null,0]
[null,72,null,null,83,"Vehicle Gasoline/Oil",null,null,null,null,30,null,null,42,"Vehicle Gasoline/Oil ",null,0]
[null,73,null,null,84,"Repairs & Maintenance",null,null,null,null,31,null,null,43,"Repairs & Maintenance ",null,0]
[null,74,null,null,85,"Insurance",null,null,null,null,32,null,null,44,"Insurance ",null,0]
[null,75,null,null,86,"Current Taxes",null,null,null,null,33,null,null,45,"Current Taxes",null,0]
[null,76,"Total Income",0,87,"Other Expenses, (incl. install. pmts)",null,null,null,null,34,null,null,46,"Other Expenses (Specify below) ",{"$f":"SUM(P18:P31)","v":0},{"$f":"SUM(Q18:Q31)","v":0}]
[null,null,null,{"$f":"SUM(D9:D13,D3:D7)","v":0},88,"Total Expenses ",{"$f":"SUM(G3:G13)","v":0},2000,null,null,35,"Total Income (Add lines 25 through 34) ",{"$f":"SUM(M3:M7,M9:M13)","v":0},47,"IRS Use Only Allowable Installment Payments ",0,0]
[null,null,null,null,89,"Net Business Income",{"$f":"D14-G14","v":0},null,null,null,null,null,null,48,"Total Expenses (Add lines 36 through 47) ",{"$f":"SUM(P3:P14)","v":0},{"$f":"SUM(Q3:Q14)","v":0}]
[null,null,null,null,null,null,null,"PerExp"]
["433-A","Source ",null,"Gross Monthly ","Expense Items ",null,"Claimed","Allowable ",null,null,null,null,null,null,"46   List other expenses below","Actual Monthly","Adjusted Monthly"]
[null,20,"Wages (Taxpayer)",null,35,"Food, Clothing, and Misc.",null,{"$f":"IF(G18=\"\",\"\",G18)","v":""},null,null,null,null,null,null,null,null,0]
[null,21,"Wages (Spouse)",null,36,"Housing and Utilities",null,{"$f":"IF(G19=\"\",\"\",G19)","v":""},null,null,null,null,null,null,null,null,0]
[null,22,"Interest - Dividends ",null,37,"Vehicle Ownership Costs",null,"",null,null,null,null,null,null,null,null,0]
[null,23,"Net Business Income ",0,38,"Vehicle Operating Costs",null,"",null,null,null,null,null,null,null,null,0]
[null,24,"Net Rental Income",null,39,"Public Transportation",null,"",null,null,null,null,null,null,null,null,0]
[null,25,"Distributions",null,40,"Health Insurance ",null,"",null,null,null,null,null,null,null,null,0]
[null,26,"Pension (Taxpayer)",null,41,"Out of Pocket Health Care Costs",null,"",null,null,null,null,null,null,null,null,0]
[null,27,"Pension (Spouse)",null,42,"Court Ordered Payments ",null,"",null,null,null,null,null,null,null,null,0]
[null,28,"Social Security (Taxpayer) ",null,43,"Child/Dependent Care ",null,"",null,null,null,null,null,null,null,null,0]
[null,29,"Social Security (Spouse) ",null,44,"Life insurance ",null,"",null,null,null,null,null,null,null,null,0]
[null,30,"Child Support ",null,45,"Current Year Taxes(Income/FICA)",null,"",null,null,null,null,null,null,null,null,0]
[null,31,"Alimony ",null,46,"Secured Debts (Attach List)",null,"",null,null,null,null,null,null,null,null,0]
[null," ","Other (Specifiy below)",null,47,"Delinquent State or Local Taxes",null,"",null,null,null,null,null,null,null,null,0]
[null,32,null,null,48,"Other Expenses (Attach List)",null,"",null,null,null,null,null,null,null,null,0]
[null,33,null,null,49,"Total Living Expenses",{"$f":"SUM(G18:G31)","v":0},{"$f":"SUM(H18:H31)","v":0}]
[null,34,"Total Income (add lines 20-31) ",{"$f":"SUM(D18:D20,D22:D32)","v":0},50,"Net Difference",{"$f":"D33-G32","v":0},{"$f":"D33-H32","v":0}]
[null,null,null,null,"Ability To Pay",null,{"$f":"H33","v":0}]

{"sheet":"Summary","index":6,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["PERSONAL","Personal$","BUSINESS","Business$"]
["Income:",{"$f":"IF(ISERROR(AVERAGE(B3:B7)),\"\",AVERAGE(B3:B7))","v":""},"Income",{"$f":"IF(ISERROR(AVERAGE(D3:D8)),\"\",AVERAGE(D3:D8))","v":""}]
["433-A",null,"433-B"]
["Bank statements",null,"433-A SE"]
["Tax Returns",null,"Bank Statements"]
["Paycheck stubs",null,"P&L's"]
["Other",null,"Tax Returns"]
["Other",null,"Other"]
[null,null,"Other"]
[]
["Expenses:",{"$f":"IF(ISERROR(AVERAGE(B12:B15)),\"\",AVERAGE(B12:B15))","v":""},"Expenses",{"$f":"IF(ISERROR(AVERAGE(D12:D16)),\"\",AVERAGE(D12:D16))","v":""}]
["433-A",null,"433-B"]
["List of  Expenses",null,"433-A SE"]
["Tax Returns",null,"P&L"]
["Other",null,"Tax Returns"]
["Other",null,"Other"]
["Other",null,"Other"]
[]
[]
["Ability to Pay",{"$f":"IF(ISERROR(B2-B11),\"\",B2-B11)","v":""},"Ability to Pay",{"$f":"IF(ISERROR(D2-D11),\"\",D2-D11)","v":""}]

{"sheet":"Bank Dep","index":7,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":true,"merged":[[4,0,5,0],[4,2,5,2],[4,4,5,4],[4,6,5,6],[0,6,0,7],[4,1,5,1],[4,3,5,3],[4,5,5,5],[4,7,5,7],[0,2,0,3]]}
[null,"Average of selected accounts:",{"$f":"IF(ISERROR(SUMIF(A5:G5,TRUE,B5:H5)),0,SUMIF(A5:G5,TRUE,B5:H5))","v":0},null,{"$f":"SUMIF(A6:G6,TRUE,B5:H5)","v":0},{"$f":"COUNTIF(A6:G6,TRUE)","v":0}]
[]
[]
["Account:",null,"Account:",null,"Account:",null,"Account:"]
[true,{"$f":"IF(ISERROR(AVERAGE(B8:B25)),0,AVERAGE(B8:B25))","v":0},false,{"$f":"IF(ISERROR(AVERAGE(D8:D25)),0,AVERAGE(D8:D25))","v":0},true,{"$f":"IF(ISERROR(AVERAGE(F8:F25)),0,AVERAGE(F8:F25))","v":0},true,{"$f":"IF(ISERROR(AVERAGE(H8:H25)),0,AVERAGE(H8:H25))","v":0}]
[]
["Period","Amount","Period","Amount","Period","Amount","Period","Amount"]

{"sheet":"Pers Exp","index":8,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Item","Amount","Category",null,null,"Food, Clothing, and Misc.",0,null,null,null,"Food, Clothing, and Misc."]
[null,null,null,null,null,"Housing and Utilities",0,null,null,null,"Housing and Utilities",0]
[null,null,null,null,null,"Vehicle Ownership Costs",0,null,null,null,"Vehicle Ownership Costs",251]
[null,null,null,null,null,"Vehicle Operating Costs",0,null,null,null,"Vehicle Operating Costs",0]
[null,null,null,null,null,"Public Transportation",0,null,null,null,"Public Transportation",0]
[null,null,null,null,null,"Health Insurance ",0,null,null,null,"Health Insurance ",0]
[null,null,null,null,null,"Out of Pocket Health Care Costs",0,null,null,null,"Out of Pocket Health Care Costs",0]
[null,null,null,null,null,"Court Ordered Payments ",0,null,null,null,"Court Ordered Payments ",0]
[null,null,null,null,null,"Child/Dependent Care ",0,null,null,null,"Child/Dependent Care ",0]
[null,null,null,null,null,"Life insurance ",0,null,null,null,"Life insurance ",0]
[null,null,null,null,null,"Current Year Taxes(Income/FICA)",0,null,null,null,"Current Year Taxes(Income/FICA)",0]
[null,null,null,null,null,"Secured Debts",0,null,null,null,"Secured Debts",0]
[null,null,null,null,null,"Delinquent State or Local Taxes",0,null,null,null,"Delinquent State or Local Taxes",0]
[null,null,null,null,null,"Other Expenses ",0,null,null,null,"Other Expenses ",0]
[null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"433-A","index":9,"n_rows":34,"n_cols":80,"rows_kept":34,"cut":false,"hidden":true,"merged":[[16,1,32,1],[16,2,16,3],[16,5,16,6],[33,5,33,6],[33,7,33,8],[0,5,0,7],[0,52,1,53],[0,78,1,79],[1,1,14,1],[1,2,1,4],[1,5,1,7],[2,52,2,53],[2,78,2,79],[7,2,7,4]]}
["AAAAAAAABABF",null,null,null,null,"433-A / S.E.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BB5:BB32)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CB5:CB32)","v":0}]
[null,"Self Employment","Total Monthly Business Income ",null,null,"Total Monthly Business Expenses"]
[null,null,67,"Gross Receipts ",null,77,"Materials Purchased",null,null,null,{"$f":"\"Claims income from self-employment of \" & TEXT(E13,\"$* #,##0.00\") & \" with expenses of \" & TEXT(H14,\"$* #,##0.00\") & \" giving \" & TEXT(H15,\"$* #,##0.00\") & \" to taxpayer as business income\" & \".\"","v":"Claims income from self-employment of $0.00 with expenses of $0.00 giving $0.00 to taxpayer as business income."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self-Employment (Other)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personal (Other)"]
[null,null,68,"Gross Rental Income ",null,78,"Inventory Purchased",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item","Amount",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item","Amount"]
[null,null,69,"Interest ",null,79,"Gross Wages & Salaries"]
[null,null,70,"Dividends ",null,80,"Rent"]
[null,null,71,"Cash Receipts not included in lines 67-70",null,81,"Supplies"]
[null,null,"Other Income (Specify below) ",null,null,82,"Utilities/Telephone "]
[null,null,72,null,null,83,"Vehicle Gasoline/Oil"]
[null,null,73,null,null,84,"Repairs & Maintenance"]
[null,null,74,null,null,85,"Insurance"]
[null,null,75,null,null,86,"Current Taxes"]
[null,null,76,"Total Income",{"$f":"SUM(E3:E12)","v":0},87,"Other Expenses, (incl. install. pmts)"]
[null,null,null,null,null,88,"Total Expenses ",{"$f":"SUM(H3:H13)","v":0},2000]
[null,null,null,null,null,89,"Net Business Income",{"$f":"E13-H14","v":0}]
[null,null,null,null,null,null,null,null,"PerExp"]
[null,"433-A","Source ",null,"Gross Monthly ","Expense Items ",null,"Claimed","Allowable ","Pers Exp Sheet"]
[null,null,20,"Wages (Taxpayer)",null,35,"Food, Clothing, and Misc.",null,{"$f":"IF(H18=\"\",\"\",H18)","v":""},{"$f":"IF('Pers Exp'!G1=\"\",0,'Pers Exp'!G1)","v":0}]
[null,null,21,"Wages (Spouse)",null,36,"Housing and Utilities",null,{"$f":"IF(H19=\"\",\"\",H19)","v":""},{"$f":"IF('Pers Exp'!G2=\"\",0,'Pers Exp'!G2)","v":0}]
[null,null,22,"Interest - Dividends ",null,37,"Vehicle Ownership Costs",null,"",{"$f":"IF('Pers Exp'!G3=\"\",0,'Pers Exp'!G3)","v":0}]
[null,null,23,"Net Business Income ",{"$f":"H15","v":0},38,"Vehicle Operating Costs",null,"",{"$f":"IF('Pers Exp'!G4=\"\",0,'Pers Exp'!G4)","v":0}]
[null,null,24,"Net Rental Income",null,39,"Public Transportation",null,"",{"$f":"IF('Pers Exp'!G5=\"\",0,'Pers Exp'!G5)","v":0}]
[null,null,25,"Distributions",null,40,"Health Insurance ",null,"",{"$f":"IF('Pers Exp'!G6=\"\",0,'Pers Exp'!G6)","v":0}]
[null,null,26,"Pension (Taxpayer)",null,41,"Out of Pocket Health Care Costs",null,"",{"$f":"IF('Pers Exp'!G7=\"\",0,'Pers Exp'!G7)","v":0}]
[null,null,27,"Pension (Spouse)",null,42,"Court Ordered Payments ",null,"",{"$f":"IF('Pers Exp'!G8=\"\",0,'Pers Exp'!G8)","v":0}]
[null,null,28,"Social Security (Taxpayer) ",null,43,"Child/Dependent Care ",null,"",{"$f":"IF('Pers Exp'!G9=\"\",0,'Pers Exp'!G9)","v":0}]
[null,null,29,"Social Security (Spouse) ",null,44,"Life insurance ",null,"",{"$f":"IF('Pers Exp'!G10=\"\",0,'Pers Exp'!G10)","v":0}]
[null,null,30,"Child Support ",null,45,"Current Year Taxes(Income/FICA)",null,"",{"$f":"IF('Pers Exp'!G11=\"\",0,'Pers Exp'!G11)","v":0}]
[null,null,31,"Alimony ",null,46,"Secured Debts (Attach List)",null,"",{"$f":"IF('Pers Exp'!G12=\"\",0,'Pers Exp'!G12)","v":0}]
[null,null," ","Other (Specifiy below)",null,47,"Delinquent State or Local Taxes",null,"",{"$f":"IF('Pers Exp'!G13=\"\",0,'Pers Exp'!G13)","v":0}]
[null,null,32,null,null,48,"Other Expenses (Attach List)",null,"",{"$f":"IF('Pers Exp'!G14=\"\",0,'Pers Exp'!G14)","v":0}]
[null,null,33,null,null,49,"Total Living Expenses",{"$f":"SUM(H17:H31)","v":0},{"$f":"IF(H32=\"\",\"\",SUM(I18:I31))","v":0},{"$f":"IF(I32=\"\",\"\",SUM(J18:J31))","v":0}]
[null,null,34,"Total Income (add lines 20-31) ",{"$f":"SUM(E18:E32)","v":0},50,"Net Difference",{"$f":"E33-H32","v":0},{"$f":"E33-I32","v":0},{"$f":"E33-J32","v":0}]
[null,null,null,null,null,"Ability To Pay",null,{"$f":"E33-I32","v":0}]

{"sheet":"Bus Exp","index":10,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Item","Amount","Category",null,null,"Materials Purchased",0,null,null,null,"Food, Clothing, and Misc."]
[null,null,null,null,null,"Inventory Purchased",0,null,null,null,"Housing and Utilities",0]
[null,null,null,null,null,"Gross Wages & Salaries",0,null,null,null,"Vehicle Ownership Costs",251]
[null,null,null,null,null,"Rent",0,null,null,null,"Vehicle Operating Costs",0]
[null,null,null,null,null,"Supplies",0,null,null,null,"Public Transportation",0]
[null,null,null,null,null,"Utilities/Telephone",0,null,null,null,"Health Insurance ",0]
[null,null,null,null,null,"Vehicle Gas/Oil",0,null,null,null,"Out of Pocket Health Care Costs",0]
[null,null,null,null,null,"Repairs & Maintenance",0,null,null,null,"Court Ordered Payments ",0]
[null,null,null,null,null,"Insurance",0,null,null,null,"Child/Dependent Care ",0]
[null,null,null,null,null,"Current Taxes",0,null,null,null,"Life insurance ",0]
[null,null,null,null,null,"Other expenses",0,null,null,null,"Current Year Taxes(Income/FICA)",0]
[null,null,null,null,null,null,null,null,null,null,"Secured Debts",0]
[null,null,null,null,null,null,null,null,null,null,"Delinquent State or Local Taxes",0]
[null,null,null,null,null,null,null,null,null,null,"Other Expenses ",0]
[null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"433-B","index":11,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":true,"merged":[[1,1,1,3],[1,4,1,6],[8,1,8,3],[14,1,15,1],[14,2,15,2],[14,3,15,3]]}
[]
[null,"Total Monthly Business Income ",null,null,"Total Monthly Business Expenses "]
[null,null,"Source ","Gross Monthly ",null,"Expense Items ","Actual Monthly ","Adjusted Monthly"]
[null,25,"Gross Receipts from Sales/Services ",null,36,"Materials Purchased",null,{"$f":"G4","v":0}]
[null,26,"Gross Rental Income ",null,37,"Inventory Purchased",null,0]
[null,27,"Interest Income ",null,38,"Gross Wages & Salaries ",null,0]
[null,28,"Dividends ",null,39,"Rent ",null,0]
[null,29,"Cash ",null,40,"Supplies",null,0]
[null,"Other Income (Specify below) ",null,null,41,"Utilities/Telephone",null,0]
[null,30,null,null,42,"Vehicle Gasoline/Oil ",null,0]
[null,31,null,null,43,"Repairs & Maintenance ",null,0]
[null,32,null,null,44,"Insurance ",null,0]
[null,33,null,null,45,"Current Taxes",null,0]
[null,34,null,null,46,"Other Expenses (Specify below) ",{"$f":"SUM(G19:G32)","v":0},{"$f":"SUM(H19:H32)","v":0}]
[null,35,"Total Income (Add lines 25 through 34) ",{"$f":"SUM(D4:D8,D10:D14)","v":0},47,"IRS Use Only Allowable Installment Payments ",{"$f":"D15-G16","v":0},{"$f":"D15-H16","v":0}]
[null,null,null,null,48,"Total Expenses (Add lines 36 through 47) ",{"$f":"SUM(G4:G14)","v":0},{"$f":"SUM(H4:H14)","v":0}]
[]
[null,null,null,null,null,"46   List other expenses below","Actual Monthly","Adjusted Monthly"]
[null,null,null,null,null,null,null,{"$f":"G19","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]

{"sheet":"Assets","index":12,"n_rows":53,"n_cols":33,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["Total Assets:",{"$f":"SUM(Assets!B$3:$B50)","v":0},{"$f":"SUM(Assets!C$3:C50)","v":0},null,"Y"]
["Asset","FMV","Loan Balance","Equity","Use Forced Sale Value?"," Sale Value","Net Proceeds if Seized","Disposition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset","FMV","Loan Balance","Equity","Forced Sale Value","Input Sale Value","Net Proceeds if Seized"]
[null,null,null,null,null,null,null,null,{"$f":"IF(A3=\"\",\"F\",\"T\")","v":"F"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B3","v":0},{"$f":"C3","v":0},{"$f":"IF(OR(B3=\"\",C3=\"\"),\"\",IF(B3-C3<1,\"None\",B3-C3))","v":""},{"$f":"(B3*0.6)","v":0},null,{"$f":"(B3*0.6)-C3","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A4=\"\",\"F\",\"T\")","v":"F"}]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,"F"]

{"sheet":"Other","index":13,"n_rows":24,"n_cols":26,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,7,0,9],[0,14,0,16],[0,21,0,23]]}
["Item",null,null,null,null,null,null,"Item",null,null,null,null,null,null,"Item",null,null,null,null,null,null,"Item"]
[null,"Used Period",null,"Used Amount","Is value a #?",null,null,null,"Used Period",null,"Used Amount","Is value a #?",null,null,null,"Used Period",null,"Used Amount","Is value a #?",null,null,null,"Used Period",null,"Used Amount","Is value a #?"]
["Period1",{"$f":"IF(LEFT(A3,6)=\"Period\",TRUE,FALSE)","v":true},"Amount1",{"$f":"IF(LEFT(C3,6)=\"Amount\",TRUE,FALSE)","v":true},{"$f":"IF(ISNUMBER(C3),TRUE,FALSE)","v":false},null,null,"Period1",{"$f":"IF(LEFT(H3,6)=\"Period\",TRUE,FALSE)","v":true},"Amount1",{"$f":"IF(LEFT(J3,6)=\"Amount\",TRUE,FALSE)","v":true},{"$f":"IF(ISNUMBER(J3),TRUE,FALSE)","v":false},null,null,"Period1",{"$f":"IF(LEFT(O3,6)=\"Period\",TRUE,FALSE)","v":true},"Amount1",{"$f":"IF(LEFT(Q3,6)=\"Amount\",TRUE,FALSE)","v":true},{"$f":"IF(ISNUMBER(Q3),TRUE,FALSE)","v":false},null,null,"Period1",{"$f":"IF(LEFT(V3,6)=\"Period\",TRUE,FALSE)","v":true},"Amount1",{"$f":"IF(LEFT(X3,6)=\"Amount\",TRUE,FALSE)","v":true},{"$f":"IF(ISNUMBER(X3),TRUE,FALSE)","v":false}]
["Period2",true,"Amount2",{"$f":"IF(LEFT(C4,6)=\"Amount\",TRUE,FALSE)","v":true},false,null,null,"Period2",true,"Amount2",{"$f":"IF(LEFT(J4,6)=\"Amount\",TRUE,FALSE)","v":true},false,null,null,"Period2",true,"Amount2",{"$f":"IF(LEFT(Q4,6)=\"Amount\",TRUE,FALSE)","v":true},false,null,null,"Period2",true,"Amount2",{"$f":"IF(LEFT(X4,6)=\"Amount\",TRUE,FALSE)","v":true},false]
["Period3",true,"Amount3",true,false,null,null,"Period3",true,"Amount3",true,false,null,null,"Period3",true,"Amount3",true,false,null,null,"Period3",true,"Amount3",true,false]
["Period4",true,"Amount4",true,false,null,null,"Period4",true,"Amount4",true,false,null,null,"Period4",true,"Amount4",true,false,null,null,"Period4",true,"Amount4",true,false]
["Period5",true,"Amount5",true,false,null,null,"Period5",true,"Amount5",true,false,null,null,"Period5",true,"Amount5",true,false,null,null,"Period5",true,"Amount5",true,false]
["Period6",true,"Amount6",true,false,null,null,"Period6",true,"Amount6",true,false,null,null,"Period6",true,"Amount6",true,false,null,null,"Period6",true,"Amount6",true,false]
["Period7",true,"Amount7",true,false,null,null,"Period7",true,"Amount7",true,false,null,null,"Period7",true,"Amount7",true,false,null,null,"Period7",true,"Amount7",true,false]
["Period8",true,"Amount8",true,false,null,null,"Period8",true,"Amount8",true,false,null,null,"Period8",true,"Amount8",true,false,null,null,"Period8",true,"Amount8",true,false]
["Period9",true,"Amount9",true,false,null,null,"Period9",true,"Amount9",true,false,null,null,"Period9",true,"Amount9",true,false,null,null,"Period9",true,"Amount9",true,false]
["Period10",true,"Amount10",true,false,null,null,"Period10",true,"Amount10",true,false,null,null,"Period10",true,"Amount10",true,false,null,null,"Period10",true,"Amount10",true,false]
["Period11",true,"Amount11",true,false,null,null,"Period11",true,"Amount11",true,false,null,null,"Period11",true,"Amount11",true,false,null,null,"Period11",true,"Amount11",true,false]
["Period12",true,"Amount12",true,false,null,null,"Period12",true,"Amount12",true,false,null,null,"Period12",true,"Amount12",true,false,null,null,"Period12",true,"Amount12",true,false]
["Period13",true,"Amount13",true,false,null,null,"Period13",true,"Amount13",true,false,null,null,"Period13",true,"Amount13",true,false,null,null,"Period13",true,"Amount13",true,false]
["Period14",true,"Amount14",true,false,null,null,"Period14",true,"Amount14",true,false,null,null,"Period14",true,"Amount14",true,false,null,null,"Period14",true,"Amount14",true,false]
["Period15",true,"Amount15",true,false,null,null,"Period15",true,"Amount15",true,false,null,null,"Period15",true,"Amount15",true,false,null,null,"Period15",true,"Amount15",true,false]
["Period16",true,"Amount16",true,false,null,null,"Period16",true,"Amount16",true,false,null,null,"Period16",true,"Amount16",true,false,null,null,"Period16",true,"Amount16",true,false]
["Period17",true,"Amount17",true,false,null,null,"Period17",true,"Amount17",true,false,null,null,"Period17",true,"Amount17",true,false,null,null,"Period17",true,"Amount17",true,false]
["Period18",true,"Amount18",true,false,null,null,"Period18",true,"Amount18",true,false,null,null,"Period18",true,"Amount18",true,false,null,null,"Period18",true,"Amount18",true,false]
["Period19",true,"Amount19",true,false,null,null,"Period19",true,"Amount19",true,false,null,null,"Period19",true,"Amount19",true,false,null,null,"Period19",true,"Amount19",true,false]
["Period20",true,"Amount20",true,false,null,null,"Period20",true,"Amount20",true,false,null,null,"Period20",true,"Amount20",true,false,null,null,"Period20",true,"Amount20",true,false]
[{"$f":"\"TOTAL: \"&A1","v":"TOTAL: Item"},null,{"$f":"SUM(C3:C22)","v":0},null,null,null,null,{"$f":"\"TOTAL: \"&H1","v":"TOTAL: Item"},null,{"$f":"SUM(J3:J22)","v":0},null,null,null,null,{"$f":"\"TOTAL: \"&O1","v":"TOTAL: Item"},null,{"$f":"SUM(Q3:Q22)","v":0},null,null,null,null,{"$f":"\"TOTAL: \"&V1","v":"TOTAL: Item"},null,{"$f":"SUM(X3:X22)","v":0}]
[{"$f":"\"AVERAGE: \"&A1","v":"AVERAGE: Item"},null,{"$f":"IFERROR(SUMIF(E3:E22,TRUE,C3:C22)/COUNTIF(E3:E22,TRUE),\"\")","v":""},null,null,null,null,{"$f":"\"AVERAGE: \"&H1","v":"AVERAGE: Item"},null,{"$f":"IFERROR(SUMIF(L3:L22,TRUE,J3:J22)/COUNTIF(L3:L22,TRUE),\"\")","v":""},null,null,null,null,{"$f":"\"AVERAGE: \"&O1","v":"AVERAGE: Item"},null,{"$f":"IFERROR(SUMIF(S3:S22,TRUE,Q3:Q22)/COUNTIF(S3:S22,TRUE),\"\")","v":""},null,null,null,null,{"$f":"\"AVERAGE: \"&V1","v":"AVERAGE: Item"},null,{"$f":"IFERROR(SUMIF(Z3:Z22,TRUE,X3:X22)/COUNTIF(Z3:Z22,TRUE),\"\")","v":""}]

{"sheet":"ShadowSheet","index":14,"n_rows":53,"n_cols":36,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F1,'Pers Exp'!B:B)","v":0},"Food, Clothing, and Misc."]
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F2,'Pers Exp'!B:B)","v":0},"Housing and Utilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset","FMV","Loan Balance","Equity","Use Forced Sale Value?","Sale Value"," Forced Sale Value","Net Proceeds if Seized","Disposition","Input Sale Value"]
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F3,'Pers Exp'!B:B)","v":0},"Vehicle Ownership Costs",null,null,"Range(\"K",1,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",1,").Value",{"$f":"E3&F3&G3&H3&I3&G3&J3","v":"Range(\"K1\") = Sheets(\"ShadowSheet\").Range(\"B1\").Value"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B3","v":0},{"$f":"Assets!C3","v":0},{"$f":"IF(AB3=\"\",\"\",AB3-AC3)","v":0},{"$f":"Assets!E3","v":0},{"$f":"IF(OR(AE3=0,AE3=\"0\",AE3=\"\",AE3=\"Y\"),AG3,AJ3)","v":0},{"$f":"AB3*0.6","v":0},{"$f":"IF(AND(AF3>AC3,AF3>0),AF3-AC3,0)","v":0},null,{"$f":"IF(AE3=\"N\",Assets!F3,\"\")","v":""}]
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F4,'Pers Exp'!B:B)","v":0},"Vehicle Operating Costs",null,null,"Range(\"K",2,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",2,").Value",{"$f":"E4&F4&G4&H4&I4&G4&J4","v":"Range(\"K2\") = Sheets(\"ShadowSheet\").Range(\"B2\").Value"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B4","v":0},{"$f":"Assets!C4","v":0},{"$f":"IF(AB4=\"\",\"\",AB4-AC4)","v":0},{"$f":"Assets!E4","v":0},{"$f":"IF(OR(AE4=0,AE4=\"0\",AE4=\"\",AE4=\"Y\"),AG4,AJ4)","v":0},{"$f":"AB4*0.6","v":0},{"$f":"IF(AND(AF4>AC4,AF4>0),AF4-AC4,0)","v":0}]
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F5,'Pers Exp'!B:B)","v":0},"Public Transportation",null,null,"Range(\"K",3,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",3,").Value","Range(\"K3\") = Sheets(\"ShadowSheet\").Range(\"B3\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B5","v":0},{"$f":"Assets!C5","v":0},0,{"$f":"Assets!E5","v":0},0,0,0]
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F6,'Pers Exp'!B:B)","v":0},"Health Insurance ",null,null,"Range(\"K",4,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",4,").Value","Range(\"K4\") = Sheets(\"ShadowSheet\").Range(\"B4\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B6","v":0},{"$f":"Assets!C6","v":0},0,{"$f":"Assets!E6","v":0},0,0,0]
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F7,'Pers Exp'!B:B)","v":0},"Out of Pocket Health Care Costs",null,null,"Range(\"K",5,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",5,").Value","Range(\"K5\") = Sheets(\"ShadowSheet\").Range(\"B5\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B7","v":0},{"$f":"Assets!C7","v":0},0,{"$f":"Assets!E7","v":0},0,0,0]
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F8,'Pers Exp'!B:B)","v":0},"Court Ordered Payments ",null,null,"Range(\"K",6,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",6,").Value","Range(\"K6\") = Sheets(\"ShadowSheet\").Range(\"B6\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B8","v":0},{"$f":"Assets!C8","v":0},0,{"$f":"Assets!E8","v":0},0,0,0]
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F9,'Pers Exp'!B:B)","v":0},"Child/Dependent Care ",null,null,"Range(\"K",7,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",7,").Value","Range(\"K7\") = Sheets(\"ShadowSheet\").Range(\"B7\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B9","v":0},{"$f":"Assets!C9","v":0},0,{"$f":"Assets!E9","v":0},0,0,0]
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F10,'Pers Exp'!B:B)","v":0},"Life insurance ",null,null,"Range(\"K",8,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",8,").Value","Range(\"K8\") = Sheets(\"ShadowSheet\").Range(\"B8\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B10","v":0},{"$f":"Assets!C10","v":0},0,{"$f":"Assets!E10","v":0},0,0,0]
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F11,'Pers Exp'!B:B)","v":0},"Current Year Taxes(Income/FICA)",null,null,"Range(\"K",9,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",9,").Value","Range(\"K9\") = Sheets(\"ShadowSheet\").Range(\"B9\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B11","v":0},{"$f":"Assets!C11","v":0},0,{"$f":"Assets!E11","v":0},0,0,0]
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F12,'Pers Exp'!B:B)","v":0},"Secured Debts",null,null,"Range(\"K",10,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",10,").Value","Range(\"K10\") = Sheets(\"ShadowSheet\").Range(\"B10\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B12","v":0},{"$f":"Assets!C12","v":0},0,{"$f":"Assets!E12","v":0},0,0,0]
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F13,'Pers Exp'!B:B)","v":0},"Delinquent State or Local Taxes",null,null,"Range(\"K",11,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",11,").Value","Range(\"K11\") = Sheets(\"ShadowSheet\").Range(\"B11\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B13","v":0},{"$f":"Assets!C13","v":0},0,{"$f":"Assets!E13","v":0},0,0,0]
[{"$f":"SUMIF('Pers Exp'!C:C,'Pers Exp'!F14,'Pers Exp'!B:B)","v":0},"Other Expenses ",null,null,"Range(\"K",12,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",12,").Value","Range(\"K12\") = Sheets(\"ShadowSheet\").Range(\"B12\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B14","v":0},{"$f":"Assets!C14","v":0},0,{"$f":"Assets!E14","v":0},0,0,0]
[null,null,null,null,"Range(\"K",13,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",13,").Value","Range(\"K13\") = Sheets(\"ShadowSheet\").Range(\"B13\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B15","v":0},{"$f":"Assets!C15","v":0},0,{"$f":"Assets!E15","v":0},0,0,0]
[null,null,null,null,"Range(\"K",14,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",14,").Value","Range(\"K14\") = Sheets(\"ShadowSheet\").Range(\"B14\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B16","v":0},{"$f":"Assets!C16","v":0},0,{"$f":"Assets!E16","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B17","v":0},{"$f":"Assets!C17","v":0},0,{"$f":"Assets!E17","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B18","v":0},{"$f":"Assets!C18","v":0},0,{"$f":"Assets!E18","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B19","v":0},{"$f":"Assets!C19","v":0},0,{"$f":"Assets!E19","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B20","v":0},{"$f":"Assets!C20","v":0},0,{"$f":"Assets!E20","v":0},0,0,0]
[{"$f":"SUMIF('Bus Exp'!C:C,'Bus Exp'!F1,'Bus Exp'!B:B)","v":0},"Materials Purchased",null,null,"Range(\"K",21,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",21,").Value",{"$f":"E21&F21&G21&H21&I21&G21&J21","v":"Range(\"K21\") = Sheets(\"ShadowSheet\").Range(\"B21\").Value"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B21","v":0},{"$f":"Assets!C21","v":0},0,{"$f":"Assets!E21","v":0},0,0,0]
[{"$f":"SUMIF('Bus Exp'!C:C,'Bus Exp'!F2,'Bus Exp'!B:B)","v":0},"Inventory Purchased",null,null,"Range(\"K",22,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",22,").Value",{"$f":"E22&F22&G22&H22&I22&G22&J22","v":"Range(\"K22\") = Sheets(\"ShadowSheet\").Range(\"B22\").Value"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B22","v":0},{"$f":"Assets!C22","v":0},0,{"$f":"Assets!E22","v":0},0,0,0]
[{"$f":"SUMIF('Bus Exp'!C:C,'Bus Exp'!F3,'Bus Exp'!B:B)","v":0},"Gross Wages & Salaries",null,null,"Range(\"K",23,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",23,").Value","Range(\"K23\") = Sheets(\"ShadowSheet\").Range(\"B23\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B23","v":0},{"$f":"Assets!C23","v":0},0,{"$f":"Assets!E23","v":0},0,0,0]
[{"$f":"SUMIF('Bus Exp'!C:C,'Bus Exp'!F4,'Bus Exp'!B:B)","v":0},"Rent",null,null,"Range(\"K",24,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",24,").Value","Range(\"K24\") = Sheets(\"ShadowSheet\").Range(\"B24\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B24","v":0},{"$f":"Assets!C24","v":0},0,{"$f":"Assets!E24","v":0},0,0,0]
[{"$f":"SUMIF('Bus Exp'!C:C,'Bus Exp'!F5,'Bus Exp'!B:B)","v":0},"Supplies",null,null,"Range(\"K",25,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",25,").Value","Range(\"K25\") = Sheets(\"ShadowSheet\").Range(\"B25\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B25","v":0},{"$f":"Assets!C25","v":0},0,{"$f":"Assets!E25","v":0},0,0,0]
[{"$f":"SUMIF('Bus Exp'!C:C,'Bus Exp'!F6,'Bus Exp'!B:B)","v":0},"Utilities/Telephone",null,null,"Range(\"K",26,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",26,").Value","Range(\"K26\") = Sheets(\"ShadowSheet\").Range(\"B26\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B26","v":0},{"$f":"Assets!C26","v":0},0,{"$f":"Assets!E26","v":0},0,0,0]
[{"$f":"SUMIF('Bus Exp'!C:C,'Bus Exp'!F7,'Bus Exp'!B:B)","v":0},"Vehicle Gas/Oil",null,null,"Range(\"K",27,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",27,").Value","Range(\"K27\") = Sheets(\"ShadowSheet\").Range(\"B27\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B27","v":0},{"$f":"Assets!C27","v":0},0,{"$f":"Assets!E27","v":0},0,0,0]
[{"$f":"SUMIF('Bus Exp'!C:C,'Bus Exp'!F8,'Bus Exp'!B:B)","v":0},"Repairs & Maintenance",null,null,"Range(\"K",28,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",28,").Value","Range(\"K28\") = Sheets(\"ShadowSheet\").Range(\"B28\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B28","v":0},{"$f":"Assets!C28","v":0},0,{"$f":"Assets!E28","v":0},0,0,0]
[{"$f":"SUMIF('Bus Exp'!C:C,'Bus Exp'!F9,'Bus Exp'!B:B)","v":0},"Insurance",null,null,"Range(\"K",29,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",29,").Value","Range(\"K29\") = Sheets(\"ShadowSheet\").Range(\"B29\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B29","v":0},{"$f":"Assets!C29","v":0},0,{"$f":"Assets!E29","v":0},0,0,0]
[{"$f":"SUMIF('Bus Exp'!C:C,'Bus Exp'!F10,'Bus Exp'!B:B)","v":0},"Current Taxes",null,null,"Range(\"K",30,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",30,").Value","Range(\"K30\") = Sheets(\"ShadowSheet\").Range(\"B30\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B30","v":0},{"$f":"Assets!C30","v":0},0,{"$f":"Assets!E30","v":0},0,0,0]
[{"$f":"SUMIF('Bus Exp'!C:C,'Bus Exp'!F11,'Bus Exp'!B:B)","v":0},"Other expenses",null,null,"Range(\"K",31,"\"",") = Sheets(\"ShadowSheet\").Range(\"B",31,").Value","Range(\"K31\") = Sheets(\"ShadowSheet\").Range(\"B31\").Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B31","v":0},{"$f":"Assets!C31","v":0},0,{"$f":"Assets!E31","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B32","v":0},{"$f":"Assets!C32","v":0},0,{"$f":"Assets!E32","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B33","v":0},{"$f":"Assets!C33","v":0},0,{"$f":"Assets!E33","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B34","v":0},{"$f":"Assets!C34","v":0},0,{"$f":"Assets!E34","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B35","v":0},{"$f":"Assets!C35","v":0},0,{"$f":"Assets!E35","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B36","v":0},{"$f":"Assets!C36","v":0},0,{"$f":"Assets!E36","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B37","v":0},{"$f":"Assets!C37","v":0},0,{"$f":"Assets!E37","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B38","v":0},{"$f":"Assets!C38","v":0},0,{"$f":"Assets!E38","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B39","v":0},{"$f":"Assets!C39","v":0},0,{"$f":"Assets!E39","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B40","v":0},{"$f":"Assets!C40","v":0},0,{"$f":"Assets!E40","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B41","v":0},{"$f":"Assets!C41","v":0},0,{"$f":"Assets!E41","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B42","v":0},{"$f":"Assets!C42","v":0},0,{"$f":"Assets!E42","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B43","v":0},{"$f":"Assets!C43","v":0},0,{"$f":"Assets!E43","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B44","v":0},{"$f":"Assets!C44","v":0},0,{"$f":"Assets!E44","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B45","v":0},{"$f":"Assets!C45","v":0},0,{"$f":"Assets!E45","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B46","v":0},{"$f":"Assets!C46","v":0},0,{"$f":"Assets!E46","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B47","v":0},{"$f":"Assets!C47","v":0},0,{"$f":"Assets!E47","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B48","v":0},{"$f":"Assets!C48","v":0},0,{"$f":"Assets!E48","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B49","v":0},{"$f":"Assets!C49","v":0},0,{"$f":"Assets!E49","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B50","v":0},{"$f":"Assets!C50","v":0},0,{"$f":"Assets!E50","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B51","v":0},{"$f":"Assets!C51","v":0},0,{"$f":"Assets!E51","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B52","v":0},{"$f":"Assets!C52","v":0},0,{"$f":"Assets!E52","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Assets!B53","v":0},{"$f":"Assets!C53","v":0},0,{"$f":"Assets!E53","v":0},0,0,0]