{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Register","Statement","BudgetViewer","BudgetVwr_Source","Lists","Ver_Notes","Statement (Example)","DeveloperNotes"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":2},"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":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[4,1,4,5],[1,1,1,5],[2,1,2,5]]}
[null,null,null,"Checkbook Simulation Activity"]
[null,"Check Book Simulation Activity:  This activity provides you with an opportunity to track your expenses and deposits for a month by entering them into a transaction register.  It will provide you with an understanding of the importance of monitoring your account balance to avoid having your account fall below zero.  It also will give you an opportunity to explain the balance difference between what the bank/credit union shows and that of your transaction register.\n"]
[null,"Instructions:  Detailed below is a list of your deposits and withdrawals for a hypothetical month. The transactions are similar to the spending and saving choices you made when completing the budget activity. Follow the steps below to complete the activity.\nStep 1: Register Tab\nUse the information in the table below and enter it in the appropriate field in the checkbook register. As you enter the transactions, the balance of your account will be updated. If the balance falls below zero, it will trigger an overdraft fee.  \nStep 2:  Statement Tab\nOnce you have all of the information entered in the register, click on the Statement tab to review the transactions that have cleared.  \"Cleared\" means the bank has received the transaction and it has been reflected in your account balance. Compare your ending balance on this statement to the ending balance in your transaction register and calculate the difference. What transactions account for the difference between the two? You can use the column labeled “Cleared Y or No” on the Register tab to indicate which transactions cleared and which haven’t. Add up the transactions that have not cleared; this will be your difference from the statement balance.\nStep 3:  Budget Viewer Tab\nReview this tab to see your spending for the month.  Are there any categories you could lower to increase the amount available to save?  What are your largest spending categories?\n"]
[]
[null,"Transactions"]
[null,"Date","Transaction Type","Description","Budget Category","Amount"]
[null,"2016-09-01","Direct Deposit","Pay Day","Deposit",1350]
[null,"2016-09-01","Auto from Checking","September Rent - Due 9/1","Housing/Rent",-650]
[null,"2016-09-01","Auto to Savings","Save for Emergency Fund","Emergency Fund",-75]
[null,"2016-09-07","Debit Card","Groceries","Groceries",-125]
[null,"2016-09-08","ATM Cash","Spending Money","Entertainment",-100]
[null,"2016-09-12","Auto from Checking","Cell Phone","Other",-75]
[null,"2016-09-14","Auto from Checking","Car Loan Payment","Loan Payment",-300]
[null,"2016-09-14","Auto from Checking","Auto Insurance and Renter's Insurance","Insurance",-150]
[null,"2016-09-14","Debit Card","Oil Change","Transportation",-35]
[null,"2016-09-15","Direct Deposit","Pay Day","Deposit",1350]
[null,"2016-09-20","Debit Card","Groceries","Groceries",-125]
[null,"2016-09-22","ATM Cash","Spending Money","Entertainment",-100]
[null,"2016-09-24","Auto from Checking","Utilities","Utilities",-75]
[null,"2016-09-28","Check","Student Loan Payment","Loan Payment",-150]
[null,"2016-09-29","Auto from Checking","Cable/Internet","Utilities",-100]
[null,"2016-09-28","Check","Pay Back Friend for Concert Ticket ","Housing/Rent",-100]
[null,"2016-09-29","Debit Card","Weekend Getaway","Travel",-250]

{"sheet":"Register","index":1,"n_rows":179,"n_cols":17,"rows_kept":179,"cut":false,"hidden":false,"merged":[[3,6,3,9],[7,13,7,14],[5,15,5,16],[1,1,1,10]]}
[]
[null,"Step 1: Register Tab\nUse the information in the table below and enter it in the appropriate field in the checkbook register.  As you enter the transactions, the balance of your account will be updated.  If the balance falls below zero, it will trigger an overdraft fee."]
[]
[null,null,null,null,"CHECK REGISTER","Student Name:","Jackie Student"]
[]
[null,null,"Starting Balance:",100,null,"Overdraft fee:",-35,null,null,null,null,null,null,null,null,"Do not delete these columns."]
[]
[null,"Date","Transaction Type","Transaction Ref.","Description","Budget Category","Cleared\nY or N","Cleared Date\n(automatic)","Withdrawal\nDebit (-)","Deposit\nCredit (+)","Balance\n(automatic)",null,null,"Do not delete these columns.",null,"Deb_Empty","Cr_Empty"]
[null,null,null,null,"Beginning Balance",null,null,null,null,null,{"$f":"D6","v":100}]
[null,"2016-09-01","Direct Deposit",null,"Pay Day","Income",null,{"$f":"IF(E10=\"OVERDRAFT\",H9,IFERROR(B10+LOOKUP(Register!C10,Trans_Type,DaysToClear),\"\"))","v":"2016-09-01"},null,1350,{"$f":"OFFSET(K10,-1,0)+J10+I10","v":1450}," x remove","  + add",{"$f":"IF(AND(OR(OFFSET(K10,-1,0)>=0,OFFSET(J10,-1,0)>0), E10=\"OVERDRAFT\"),\"REMOVE\",\"nothing\")","v":"nothing"},{"$f":"IF(AND(K10<0, E10<>\"OVERDRAFT\",OFFSET(E10,1,0)<>\"OVERDRAFT\",I10<0),\"ADD\",\"nothing\")","v":"nothing"},{"$f":"ISBLANK(I10)","v":true},{"$f":"ISBLANK(J10)","v":false}]
[null,"2016-09-01","Auto from Checking",null,"September Rent - Due 9/1","Housing/Rent",null,{"$f":"IF(E11=\"OVERDRAFT\",H10,IFERROR(B11+LOOKUP(Register!C11,Trans_Type,DaysToClear),\"\"))","v":"2016-09-01"},-650,null,{"$f":"OFFSET(K11,-1,0)+J11+I11","v":800}," x remove","  + add",{"$f":"IF(AND(OR(OFFSET(K11,-1,0)>=0,OFFSET(J11,-1,0)>0), E11=\"OVERDRAFT\"),\"REMOVE\",\"nothing\")","v":"nothing"},{"$f":"IF(AND(K11<0, E11<>\"OVERDRAFT\",OFFSET(E11,1,0)<>\"OVERDRAFT\",I11<0),\"ADD\",\"nothing\")","v":"nothing"},{"$f":"ISBLANK(I11)","v":false},{"$f":"ISBLANK(J11)","v":true}]
[null,"2016-09-01","Auto to Savings",null,"Save for Emergency Fund","Emergency Fund",null,{"$f":"IF(E12=\"OVERDRAFT\",H11,IFERROR(B12+LOOKUP(Register!C12,Trans_Type,DaysToClear),\"\"))","v":"2016-09-01"},-75,null,725," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-07","Debit Card",null,"Groceries","Groceries",null,{"$f":"IF(E13=\"OVERDRAFT\",H12,IFERROR(B13+LOOKUP(Register!C13,Trans_Type,DaysToClear),\"\"))","v":"2016-09-07"},-125,null,600," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-08","ATM Cash",null,"Spending Money","Entertainment",null,{"$f":"IF(E14=\"OVERDRAFT\",H13,IFERROR(B14+LOOKUP(Register!C14,Trans_Type,DaysToClear),\"\"))","v":"2016-09-08"},-100,null,500," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-12","Auto from Checking",null,"Cell Phone","Utilities",null,{"$f":"IF(E15=\"OVERDRAFT\",H14,IFERROR(B15+LOOKUP(Register!C15,Trans_Type,DaysToClear),\"\"))","v":"2016-09-12"},-75,null,425," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-14","Auto from Checking",null,"Car Loan Payment","Loan Payment",null,{"$f":"IF(E16=\"OVERDRAFT\",H15,IFERROR(B16+LOOKUP(Register!C16,Trans_Type,DaysToClear),\"\"))","v":"2016-09-14"},-300,null,125," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-14","Auto from Checking",null,"Auto Insurance and Renter's Insurance","Insurance",null,{"$f":"IF(E17=\"OVERDRAFT\",H16,IFERROR(B17+LOOKUP(Register!C17,Trans_Type,DaysToClear),\"\"))","v":"2016-09-14"},-150,null,-25," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-14","Bank Fee",null,"OVERDRAFT","Bank Fee",null,{"$f":"IF(E18=\"OVERDRAFT\",H17,IFERROR(B18+LOOKUP(Register!C18,Trans_Type,DaysToClear),\"\"))","v":"2016-09-14"},-35,null,-60," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-14","Debit Card",null,"Oil Change","Travel",null,{"$f":"IF(E19=\"OVERDRAFT\",H18,IFERROR(B19+LOOKUP(Register!C19,Trans_Type,DaysToClear),\"\"))","v":"2016-09-14"},-35,null,{"$f":"OFFSET(K19,-1,0)+J19+I19","v":-95}," x remove","  + add",{"$f":"IF(AND(OR(OFFSET(K19,-1,0)>=0,OFFSET(J19,-1,0)>0), E19=\"OVERDRAFT\"),\"REMOVE\",\"nothing\")","v":"nothing"},{"$f":"IF(AND(K19<0, E19<>\"OVERDRAFT\",OFFSET(E19,1,0)<>\"OVERDRAFT\",I19<0),\"ADD\",\"nothing\")","v":"nothing"},{"$f":"ISBLANK(I19)","v":false},{"$f":"ISBLANK(J19)","v":true}]
[null,"2016-09-14","Bank Fee",null,"OVERDRAFT","Bank Fee",null,{"$f":"IF(E20=\"OVERDRAFT\",H19,IFERROR(B20+LOOKUP(Register!C20,Trans_Type,DaysToClear),\"\"))","v":"2016-09-14"},-35,null,-130," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-15","Direct Deposit",null,"Pay Day","Income",null,{"$f":"IF(E21=\"OVERDRAFT\",H20,IFERROR(B21+LOOKUP(Register!C21,Trans_Type,DaysToClear),\"\"))","v":"2016-09-15"},null,1350,{"$f":"OFFSET(K21,-1,0)+J21+I21","v":1220}," x remove","  + add",{"$f":"IF(AND(OR(OFFSET(K21,-1,0)>=0,OFFSET(J21,-1,0)>0), E21=\"OVERDRAFT\"),\"REMOVE\",\"nothing\")","v":"nothing"},{"$f":"IF(AND(K21<0, E21<>\"OVERDRAFT\",OFFSET(E21,1,0)<>\"OVERDRAFT\",I21<0),\"ADD\",\"nothing\")","v":"nothing"},{"$f":"ISBLANK(I21)","v":true},{"$f":"ISBLANK(J21)","v":false}]
[null,"2016-09-20","Debit Card",null,"Groceries","Groceries",null,{"$f":"IF(E22=\"OVERDRAFT\",H21,IFERROR(B22+LOOKUP(Register!C22,Trans_Type,DaysToClear),\"\"))","v":"2016-09-20"},-125,null,1095," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-22","ATM Cash",null,"Spending Money","Entertainment",null,{"$f":"IF(E23=\"OVERDRAFT\",H22,IFERROR(B23+LOOKUP(Register!C23,Trans_Type,DaysToClear),\"\"))","v":"2016-09-22"},-100,null,995," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-24","Auto from Checking",null,"Utilities","Utilities",null,{"$f":"IF(E24=\"OVERDRAFT\",H23,IFERROR(B24+LOOKUP(Register!C24,Trans_Type,DaysToClear),\"\"))","v":"2016-09-24"},-75,null,920," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-28","Check",null,"Student Loan Payment","Loan Payment",null,{"$f":"IF(E25=\"OVERDRAFT\",H24,IFERROR(B25+LOOKUP(Register!C25,Trans_Type,DaysToClear),\"\"))","v":"2016-10-03"},-150,null,770," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-29","Auto from Checking",null,"Cable/Internet","Utilities",null,{"$f":"IF(E26=\"OVERDRAFT\",H25,IFERROR(B26+LOOKUP(Register!C26,Trans_Type,DaysToClear),\"\"))","v":"2016-09-29"},-100,null,670," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-28","Check",null,"Pay back friend for concert ticket ","Entertainment",null,{"$f":"IF(E27=\"OVERDRAFT\",H26,IFERROR(B27+LOOKUP(Register!C27,Trans_Type,DaysToClear),\"\"))","v":"2016-10-03"},-100,null,570," x remove","  + add","nothing","nothing",false,true]
[null,"2016-09-29","Debit Card",null,"Weekend Getaway","Entertainment",null,{"$f":"IF(E28=\"OVERDRAFT\",H27,IFERROR(B28+LOOKUP(Register!C28,Trans_Type,DaysToClear),\"\"))","v":"2016-09-29"},-250,null,320," x remove","  + add","nothing","nothing",false,true]
[null,null,null,null,null,null,null,{"$f":"IF(E29=\"OVERDRAFT\",H28,IFERROR(B29+LOOKUP(Register!C29,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E30=\"OVERDRAFT\",H29,IFERROR(B30+LOOKUP(Register!C30,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E31=\"OVERDRAFT\",H30,IFERROR(B31+LOOKUP(Register!C31,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E32=\"OVERDRAFT\",H31,IFERROR(B32+LOOKUP(Register!C32,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E33=\"OVERDRAFT\",H32,IFERROR(B33+LOOKUP(Register!C33,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E34=\"OVERDRAFT\",H33,IFERROR(B34+LOOKUP(Register!C34,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E35=\"OVERDRAFT\",H34,IFERROR(B35+LOOKUP(Register!C35,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E36=\"OVERDRAFT\",H35,IFERROR(B36+LOOKUP(Register!C36,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E37=\"OVERDRAFT\",H36,IFERROR(B37+LOOKUP(Register!C37,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E38=\"OVERDRAFT\",H37,IFERROR(B38+LOOKUP(Register!C38,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E39=\"OVERDRAFT\",H38,IFERROR(B39+LOOKUP(Register!C39,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E40=\"OVERDRAFT\",H39,IFERROR(B40+LOOKUP(Register!C40,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E41=\"OVERDRAFT\",H40,IFERROR(B41+LOOKUP(Register!C41,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E42=\"OVERDRAFT\",H41,IFERROR(B42+LOOKUP(Register!C42,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E43=\"OVERDRAFT\",H42,IFERROR(B43+LOOKUP(Register!C43,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E44=\"OVERDRAFT\",H43,IFERROR(B44+LOOKUP(Register!C44,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E45=\"OVERDRAFT\",H44,IFERROR(B45+LOOKUP(Register!C45,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E46=\"OVERDRAFT\",H45,IFERROR(B46+LOOKUP(Register!C46,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E47=\"OVERDRAFT\",H46,IFERROR(B47+LOOKUP(Register!C47,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E48=\"OVERDRAFT\",H47,IFERROR(B48+LOOKUP(Register!C48,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E49=\"OVERDRAFT\",H48,IFERROR(B49+LOOKUP(Register!C49,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E50=\"OVERDRAFT\",H49,IFERROR(B50+LOOKUP(Register!C50,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E51=\"OVERDRAFT\",H50,IFERROR(B51+LOOKUP(Register!C51,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E52=\"OVERDRAFT\",H51,IFERROR(B52+LOOKUP(Register!C52,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E53=\"OVERDRAFT\",H52,IFERROR(B53+LOOKUP(Register!C53,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E54=\"OVERDRAFT\",H53,IFERROR(B54+LOOKUP(Register!C54,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E55=\"OVERDRAFT\",H54,IFERROR(B55+LOOKUP(Register!C55,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E56=\"OVERDRAFT\",H55,IFERROR(B56+LOOKUP(Register!C56,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E57=\"OVERDRAFT\",H56,IFERROR(B57+LOOKUP(Register!C57,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E58=\"OVERDRAFT\",H57,IFERROR(B58+LOOKUP(Register!C58,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E59=\"OVERDRAFT\",H58,IFERROR(B59+LOOKUP(Register!C59,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E60=\"OVERDRAFT\",H59,IFERROR(B60+LOOKUP(Register!C60,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E61=\"OVERDRAFT\",H60,IFERROR(B61+LOOKUP(Register!C61,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E62=\"OVERDRAFT\",H61,IFERROR(B62+LOOKUP(Register!C62,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E63=\"OVERDRAFT\",H62,IFERROR(B63+LOOKUP(Register!C63,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E64=\"OVERDRAFT\",H63,IFERROR(B64+LOOKUP(Register!C64,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E65=\"OVERDRAFT\",H64,IFERROR(B65+LOOKUP(Register!C65,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E66=\"OVERDRAFT\",H65,IFERROR(B66+LOOKUP(Register!C66,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E67=\"OVERDRAFT\",H66,IFERROR(B67+LOOKUP(Register!C67,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E68=\"OVERDRAFT\",H67,IFERROR(B68+LOOKUP(Register!C68,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E69=\"OVERDRAFT\",H68,IFERROR(B69+LOOKUP(Register!C69,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E70=\"OVERDRAFT\",H69,IFERROR(B70+LOOKUP(Register!C70,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E71=\"OVERDRAFT\",H70,IFERROR(B71+LOOKUP(Register!C71,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E72=\"OVERDRAFT\",H71,IFERROR(B72+LOOKUP(Register!C72,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E73=\"OVERDRAFT\",H72,IFERROR(B73+LOOKUP(Register!C73,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E74=\"OVERDRAFT\",H73,IFERROR(B74+LOOKUP(Register!C74,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E75=\"OVERDRAFT\",H74,IFERROR(B75+LOOKUP(Register!C75,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E76=\"OVERDRAFT\",H75,IFERROR(B76+LOOKUP(Register!C76,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E77=\"OVERDRAFT\",H76,IFERROR(B77+LOOKUP(Register!C77,Trans_Type,DaysToClear),\"\"))","v":""},null,null,{"$f":"OFFSET(K77,-1,0)+J77+I77","v":320}," x remove","  + add",{"$f":"IF(AND(OR(OFFSET(K77,-1,0)>=0,OFFSET(J77,-1,0)>0), E77=\"OVERDRAFT\"),\"REMOVE\",\"nothing\")","v":"nothing"},{"$f":"IF(AND(K77<0, E77<>\"OVERDRAFT\",OFFSET(E77,1,0)<>\"OVERDRAFT\",I77<0),\"ADD\",\"nothing\")","v":"nothing"},{"$f":"ISBLANK(I77)","v":true},{"$f":"ISBLANK(J77)","v":true}]
[null,null,null,null,null,null,null,{"$f":"IF(E78=\"OVERDRAFT\",H77,IFERROR(B78+LOOKUP(Register!C78,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E79=\"OVERDRAFT\",H78,IFERROR(B79+LOOKUP(Register!C79,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E80=\"OVERDRAFT\",H79,IFERROR(B80+LOOKUP(Register!C80,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E81=\"OVERDRAFT\",H80,IFERROR(B81+LOOKUP(Register!C81,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E82=\"OVERDRAFT\",H81,IFERROR(B82+LOOKUP(Register!C82,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E83=\"OVERDRAFT\",H82,IFERROR(B83+LOOKUP(Register!C83,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E84=\"OVERDRAFT\",H83,IFERROR(B84+LOOKUP(Register!C84,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E85=\"OVERDRAFT\",H84,IFERROR(B85+LOOKUP(Register!C85,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E86=\"OVERDRAFT\",H85,IFERROR(B86+LOOKUP(Register!C86,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E87=\"OVERDRAFT\",H86,IFERROR(B87+LOOKUP(Register!C87,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E88=\"OVERDRAFT\",H87,IFERROR(B88+LOOKUP(Register!C88,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E89=\"OVERDRAFT\",H88,IFERROR(B89+LOOKUP(Register!C89,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E90=\"OVERDRAFT\",H89,IFERROR(B90+LOOKUP(Register!C90,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E91=\"OVERDRAFT\",H90,IFERROR(B91+LOOKUP(Register!C91,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E92=\"OVERDRAFT\",H91,IFERROR(B92+LOOKUP(Register!C92,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E93=\"OVERDRAFT\",H92,IFERROR(B93+LOOKUP(Register!C93,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E94=\"OVERDRAFT\",H93,IFERROR(B94+LOOKUP(Register!C94,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E95=\"OVERDRAFT\",H94,IFERROR(B95+LOOKUP(Register!C95,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E96=\"OVERDRAFT\",H95,IFERROR(B96+LOOKUP(Register!C96,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E97=\"OVERDRAFT\",H96,IFERROR(B97+LOOKUP(Register!C97,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E98=\"OVERDRAFT\",H97,IFERROR(B98+LOOKUP(Register!C98,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E99=\"OVERDRAFT\",H98,IFERROR(B99+LOOKUP(Register!C99,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E100=\"OVERDRAFT\",H99,IFERROR(B100+LOOKUP(Register!C100,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E101=\"OVERDRAFT\",H100,IFERROR(B101+LOOKUP(Register!C101,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E102=\"OVERDRAFT\",H101,IFERROR(B102+LOOKUP(Register!C102,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E103=\"OVERDRAFT\",H102,IFERROR(B103+LOOKUP(Register!C103,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E104=\"OVERDRAFT\",H103,IFERROR(B104+LOOKUP(Register!C104,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E105=\"OVERDRAFT\",H104,IFERROR(B105+LOOKUP(Register!C105,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E106=\"OVERDRAFT\",H105,IFERROR(B106+LOOKUP(Register!C106,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E107=\"OVERDRAFT\",H106,IFERROR(B107+LOOKUP(Register!C107,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E108=\"OVERDRAFT\",H107,IFERROR(B108+LOOKUP(Register!C108,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E109=\"OVERDRAFT\",H108,IFERROR(B109+LOOKUP(Register!C109,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E110=\"OVERDRAFT\",H109,IFERROR(B110+LOOKUP(Register!C110,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E111=\"OVERDRAFT\",H110,IFERROR(B111+LOOKUP(Register!C111,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E112=\"OVERDRAFT\",H111,IFERROR(B112+LOOKUP(Register!C112,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E113=\"OVERDRAFT\",H112,IFERROR(B113+LOOKUP(Register!C113,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E114=\"OVERDRAFT\",H113,IFERROR(B114+LOOKUP(Register!C114,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E115=\"OVERDRAFT\",H114,IFERROR(B115+LOOKUP(Register!C115,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E116=\"OVERDRAFT\",H115,IFERROR(B116+LOOKUP(Register!C116,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E117=\"OVERDRAFT\",H116,IFERROR(B117+LOOKUP(Register!C117,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E118=\"OVERDRAFT\",H117,IFERROR(B118+LOOKUP(Register!C118,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E119=\"OVERDRAFT\",H118,IFERROR(B119+LOOKUP(Register!C119,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E120=\"OVERDRAFT\",H119,IFERROR(B120+LOOKUP(Register!C120,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E121=\"OVERDRAFT\",H120,IFERROR(B121+LOOKUP(Register!C121,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E122=\"OVERDRAFT\",H121,IFERROR(B122+LOOKUP(Register!C122,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E123=\"OVERDRAFT\",H122,IFERROR(B123+LOOKUP(Register!C123,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E124=\"OVERDRAFT\",H123,IFERROR(B124+LOOKUP(Register!C124,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E125=\"OVERDRAFT\",H124,IFERROR(B125+LOOKUP(Register!C125,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E126=\"OVERDRAFT\",H125,IFERROR(B126+LOOKUP(Register!C126,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E127=\"OVERDRAFT\",H126,IFERROR(B127+LOOKUP(Register!C127,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E128=\"OVERDRAFT\",H127,IFERROR(B128+LOOKUP(Register!C128,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E129=\"OVERDRAFT\",H128,IFERROR(B129+LOOKUP(Register!C129,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E130=\"OVERDRAFT\",H129,IFERROR(B130+LOOKUP(Register!C130,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E131=\"OVERDRAFT\",H130,IFERROR(B131+LOOKUP(Register!C131,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E132=\"OVERDRAFT\",H131,IFERROR(B132+LOOKUP(Register!C132,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E133=\"OVERDRAFT\",H132,IFERROR(B133+LOOKUP(Register!C133,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E134=\"OVERDRAFT\",H133,IFERROR(B134+LOOKUP(Register!C134,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E135=\"OVERDRAFT\",H134,IFERROR(B135+LOOKUP(Register!C135,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E136=\"OVERDRAFT\",H135,IFERROR(B136+LOOKUP(Register!C136,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E137=\"OVERDRAFT\",H136,IFERROR(B137+LOOKUP(Register!C137,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E138=\"OVERDRAFT\",H137,IFERROR(B138+LOOKUP(Register!C138,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E139=\"OVERDRAFT\",H138,IFERROR(B139+LOOKUP(Register!C139,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E140=\"OVERDRAFT\",H139,IFERROR(B140+LOOKUP(Register!C140,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E141=\"OVERDRAFT\",H140,IFERROR(B141+LOOKUP(Register!C141,Trans_Type,DaysToClear),\"\"))","v":""},null,null,{"$f":"OFFSET(K141,-1,0)+J141+I141","v":320}," x remove","  + add",{"$f":"IF(AND(OR(OFFSET(K141,-1,0)>=0,OFFSET(J141,-1,0)>0), E141=\"OVERDRAFT\"),\"REMOVE\",\"nothing\")","v":"nothing"},{"$f":"IF(AND(K141<0, E141<>\"OVERDRAFT\",OFFSET(E141,1,0)<>\"OVERDRAFT\",I141<0),\"ADD\",\"nothing\")","v":"nothing"},{"$f":"ISBLANK(I141)","v":true},{"$f":"ISBLANK(J141)","v":true}]
[null,null,null,null,null,null,null,{"$f":"IF(E142=\"OVERDRAFT\",H141,IFERROR(B142+LOOKUP(Register!C142,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E143=\"OVERDRAFT\",H142,IFERROR(B143+LOOKUP(Register!C143,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E144=\"OVERDRAFT\",H143,IFERROR(B144+LOOKUP(Register!C144,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E145=\"OVERDRAFT\",H144,IFERROR(B145+LOOKUP(Register!C145,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E146=\"OVERDRAFT\",H145,IFERROR(B146+LOOKUP(Register!C146,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E147=\"OVERDRAFT\",H146,IFERROR(B147+LOOKUP(Register!C147,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E148=\"OVERDRAFT\",H147,IFERROR(B148+LOOKUP(Register!C148,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E149=\"OVERDRAFT\",H148,IFERROR(B149+LOOKUP(Register!C149,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E150=\"OVERDRAFT\",H149,IFERROR(B150+LOOKUP(Register!C150,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E151=\"OVERDRAFT\",H150,IFERROR(B151+LOOKUP(Register!C151,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E152=\"OVERDRAFT\",H151,IFERROR(B152+LOOKUP(Register!C152,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E153=\"OVERDRAFT\",H152,IFERROR(B153+LOOKUP(Register!C153,Trans_Type,DaysToClear),\"\"))","v":""},null,null,{"$f":"OFFSET(K153,-1,0)+J153+I153","v":320}," x remove","  + add",{"$f":"IF(AND(OR(OFFSET(K153,-1,0)>=0,OFFSET(J153,-1,0)>0), E153=\"OVERDRAFT\"),\"REMOVE\",\"nothing\")","v":"nothing"},{"$f":"IF(AND(K153<0, E153<>\"OVERDRAFT\",OFFSET(E153,1,0)<>\"OVERDRAFT\",I153<0),\"ADD\",\"nothing\")","v":"nothing"},{"$f":"ISBLANK(I153)","v":true},{"$f":"ISBLANK(J153)","v":true}]
[null,null,null,null,null,null,null,{"$f":"IF(E154=\"OVERDRAFT\",H153,IFERROR(B154+LOOKUP(Register!C154,Trans_Type,DaysToClear),\"\"))","v":""},null,null,{"$f":"OFFSET(K154,-1,0)+J154+I154","v":320}," x remove","  + add",{"$f":"IF(AND(OR(OFFSET(K154,-1,0)>=0,OFFSET(J154,-1,0)>0), E154=\"OVERDRAFT\"),\"REMOVE\",\"nothing\")","v":"nothing"},{"$f":"IF(AND(K154<0, E154<>\"OVERDRAFT\",OFFSET(E154,1,0)<>\"OVERDRAFT\",I154<0),\"ADD\",\"nothing\")","v":"nothing"},{"$f":"ISBLANK(I154)","v":true},{"$f":"ISBLANK(J154)","v":true}]
[null,null,null,null,null,null,null,{"$f":"IF(E155=\"OVERDRAFT\",H154,IFERROR(B155+LOOKUP(Register!C155,Trans_Type,DaysToClear),\"\"))","v":""},null,null,{"$f":"OFFSET(K155,-1,0)+J155+I155","v":320}," x remove","  + add",{"$f":"IF(AND(OR(OFFSET(K155,-1,0)>=0,OFFSET(J155,-1,0)>0), E155=\"OVERDRAFT\"),\"REMOVE\",\"nothing\")","v":"nothing"},{"$f":"IF(AND(K155<0, E155<>\"OVERDRAFT\",OFFSET(E155,1,0)<>\"OVERDRAFT\",I155<0),\"ADD\",\"nothing\")","v":"nothing"},{"$f":"ISBLANK(I155)","v":true},{"$f":"ISBLANK(J155)","v":true}]
[null,null,null,null,null,null,null,{"$f":"IF(E156=\"OVERDRAFT\",H155,IFERROR(B156+LOOKUP(Register!C156,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E157=\"OVERDRAFT\",H156,IFERROR(B157+LOOKUP(Register!C157,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E158=\"OVERDRAFT\",H157,IFERROR(B158+LOOKUP(Register!C158,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E159=\"OVERDRAFT\",H158,IFERROR(B159+LOOKUP(Register!C159,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E160=\"OVERDRAFT\",H159,IFERROR(B160+LOOKUP(Register!C160,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E161=\"OVERDRAFT\",H160,IFERROR(B161+LOOKUP(Register!C161,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E162=\"OVERDRAFT\",H161,IFERROR(B162+LOOKUP(Register!C162,Trans_Type,DaysToClear),\"\"))","v":""},null,null,{"$f":"OFFSET(K162,-1,0)+J162+I162","v":320}," x remove","  + add",{"$f":"IF(AND(OR(OFFSET(K162,-1,0)>=0,OFFSET(J162,-1,0)>0), E162=\"OVERDRAFT\"),\"REMOVE\",\"nothing\")","v":"nothing"},{"$f":"IF(AND(K162<0, E162<>\"OVERDRAFT\",OFFSET(E162,1,0)<>\"OVERDRAFT\",I162<0),\"ADD\",\"nothing\")","v":"nothing"},{"$f":"ISBLANK(I162)","v":true},{"$f":"ISBLANK(J162)","v":true}]
[null,null,null,null,null,null,null,{"$f":"IF(E163=\"OVERDRAFT\",H162,IFERROR(B163+LOOKUP(Register!C163,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E164=\"OVERDRAFT\",H163,IFERROR(B164+LOOKUP(Register!C164,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E165=\"OVERDRAFT\",H164,IFERROR(B165+LOOKUP(Register!C165,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E166=\"OVERDRAFT\",H165,IFERROR(B166+LOOKUP(Register!C166,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E167=\"OVERDRAFT\",H166,IFERROR(B167+LOOKUP(Register!C167,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E168=\"OVERDRAFT\",H167,IFERROR(B168+LOOKUP(Register!C168,Trans_Type,DaysToClear),\"\"))","v":""},null,null,{"$f":"OFFSET(K168,-1,0)+J168+I168","v":320}," x remove","  + add","nothing","nothing",{"$f":"ISBLANK(I168)","v":true},{"$f":"ISBLANK(J168)","v":true}]
[null,null,null,null,null,null,null,{"$f":"IF(E169=\"OVERDRAFT\",H168,IFERROR(B169+LOOKUP(Register!C169,Trans_Type,DaysToClear),\"\"))","v":""},null,null,{"$f":"OFFSET(K169,-1,0)+J169+I169","v":320}," x remove","  + add","nothing","nothing",{"$f":"ISBLANK(I169)","v":true},{"$f":"ISBLANK(J169)","v":true}]
[null,null,null,null,null,null,null,{"$f":"IF(E170=\"OVERDRAFT\",H169,IFERROR(B170+LOOKUP(Register!C170,Trans_Type,DaysToClear),\"\"))","v":""},null,null,{"$f":"OFFSET(K170,-1,0)+J170+I170","v":320}," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E171=\"OVERDRAFT\",H170,IFERROR(B171+LOOKUP(Register!C171,Trans_Type,DaysToClear),\"\"))","v":""},null,null,{"$f":"OFFSET(K171,-1,0)+J171+I171","v":320}," x remove","  + add","nothing","nothing",true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E172=\"OVERDRAFT\",H171,IFERROR(B172+LOOKUP(Register!C172,Trans_Type,DaysToClear),\"\"))","v":""},null,null,{"$f":"OFFSET(K172,-1,0)+J172+I172","v":320}," x remove",null,null,null,true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E173=\"OVERDRAFT\",H172,IFERROR(B173+LOOKUP(Register!C173,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove",null,null,null,true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E174=\"OVERDRAFT\",H173,IFERROR(B174+LOOKUP(Register!C174,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove",null,null,null,true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E175=\"OVERDRAFT\",H174,IFERROR(B175+LOOKUP(Register!C175,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove",null,null,null,true,true]
[null,null,null,null,null,null,null,{"$f":"IF(E176=\"OVERDRAFT\",H175,IFERROR(B176+LOOKUP(Register!C176,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove"]
[null,null,null,null,null,null,null,{"$f":"IF(E177=\"OVERDRAFT\",H176,IFERROR(B177+LOOKUP(Register!C177,Trans_Type,DaysToClear),\"\"))","v":""},null,null,320," x remove"]
[null,null,null,null,null,null,null,{"$f":"IF(E178=\"OVERDRAFT\",H177,IFERROR(B178+LOOKUP(Register!C178,Trans_Type,DaysToClear),\"\"))","v":""},null,null,null," x remove"]
[null,null,null,null,null,null,null,{"$f":"IF(E179=\"OVERDRAFT\",H178,IFERROR(B179+LOOKUP(Register!C179,Trans_Type,DaysToClear),\"\"))","v":""},null,null,null," x remove"]

{"sheet":"Statement","index":2,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[6,4,9,5],[1,1,1,5]]}
[]
[null,"Step 2:  Statement Tab\nOnce you have all of the information entered in the register, click on the Statement tab to review the transactions that have cleared.  \"Cleared\" means the bank has received the transaction and it has been reflected in your account balance. Compare your ending balance on this statement to the ending balance in your transaction register and calculate the difference. What transactions account for the difference between the two? You can use the column labeled “Cleared Y or No” on the check register to indicate which transactions cleared and which haven’t. Add up the transactions that have not cleared; this will be your difference from the statement balance. The statement month can be selected using the filter on row 13."]
[]
[null,null,null,null,"My  Bank"]
[null,null,null,null,"Monthly Statement"]
[]
[null,"Beginning Balance",{"$f":"Register!K9+AVERAGEIF(BudgetVwr_Source!K4:K150,\"=\"&C13,BudgetVwr_Source!P4:P150)","v":100}]
[null,"Total Credits",{"$f":"IFERROR(GETPIVOTDATA(\"Amount\",$B$15,\"Credit_Debit\",\"Credit\"),0)","v":2700}]
[null,"Total Debits",{"$f":"IFERROR(GETPIVOTDATA(\"Amount\",$B$15,\"Credit_Debit\",\"Debit\"),0)","v":-2230}]
[null,"Ending Balance",{"$f":"SUM(C7:C9)","v":570}]
[]
[]
[null,"Statement Month","Sep-2016",null,"(adjust filter as desired)"]
[]
[null,"Row Labels","Clear_Date","Date","Description","Sum of Amount"]
[null,"Credit",null,null,null,2700]
[null,"Direct Deposit",null,null,null,2700]
[null,null,"2016-09-01","2016-09-01","Pay Day",1350]
[null,null,"2016-09-15","2016-09-15","Pay Day",1350]
[]
[null,"Debit",null,null,null,-2230]
[null,"Debit Card",null,null,null,-535]
[null,null,"2016-09-07","2016-09-07","Groceries",-125]
[null,null,"2016-09-14","2016-09-14","Oil Change",-35]
[null,null,"2016-09-20","2016-09-20","Groceries",-125]
[null,null,"2016-09-29","2016-09-29","Weekend Getaway",-250]
[]
[null,"Auto from Checking",null,null,null,-1350]
[null,null,"2016-09-01","2016-09-01","September Rent - Due 9/1",-650]
[null,null,"2016-09-12","2016-09-12","Cell Phone",-75]
[null,null,"2016-09-14","2016-09-14","Car Loan Payment",-300]
[null,null,"2016-09-14","2016-09-14","Auto Insurance and Renter's Insurance",-150]
[null,null,"2016-09-24","2016-09-24","Utilities",-75]
[null,null,"2016-09-29","2016-09-29","Cable/Internet",-100]
[]
[null,"Auto to Savings",null,null,null,-75]
[null,null,"2016-09-01","2016-09-01","Save for Emergency Fund",-75]
[]
[null,"ATM Cash",null,null,null,-200]
[null,null,"2016-09-08","2016-09-08","Spending Money",-100]
[null,null,"2016-09-22","2016-09-22","Spending Money",-100]
[]
[null,"Bank Fee",null,null,null,-70]
[null,null,"2016-09-14","2016-09-14","OVERDRAFT",-70]

{"sheet":"BudgetViewer","index":3,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Step 3:  Budget Viewer Tab\nReview this tab to see your spending for the month.  Are there any categories you could lower to increase the amount available to save?  What are your largest spending categories?"]
[]
[null,null,null,"BUDGET VIEWER"]
[null,null,null,"Categories by month"]
[]
[]
[null,"Empty","N"]
[]
[null,"Sum of Amount",null,null,"Column Labels"]
[null,"Category","Date","Description","September - 16","Grand Total"]
[null,"Bank Fee",null,null,-70,-70]
[null,null,"2016-09-14","OVERDRAFT",-70,-70]
[]
[null,"Emergency Fund",null,null,-75,-75]
[null,null,"2016-09-01","Save for Emergency Fund",-75,-75]
[]
[null,"Entertainment",null,null,-550,-550]
[null,null,"2016-09-08","Spending Money",-100,-100]
[null,null,"2016-09-22","Spending Money",-100,-100]
[null,null,"2016-09-28","Pay back friend for concert ticket ",-100,-100]
[null,null,"2016-09-29","Weekend Getaway",-250,-250]
[]
[null,"Groceries",null,null,-250,-250]
[null,null,"2016-09-07","Groceries",-125,-125]
[null,null,"2016-09-20","Groceries",-125,-125]
[]
[null,"Housing/Rent",null,null,-650,-650]
[null,null,"2016-09-01","September Rent - Due 9/1",-650,-650]
[]
[null,"Income",null,null,2700,2700]
[null,null,"2016-09-01","Pay Day",1350,1350]
[null,null,"2016-09-15","Pay Day",1350,1350]
[]
[null,"Insurance",null,null,-150,-150]
[null,null,"2016-09-14","Auto Insurance and Renter's Insurance",-150,-150]
[]
[null,"Loan Payment",null,null,-450,-450]
[null,null,"2016-09-14","Car Loan Payment",-300,-300]
[null,null,"2016-09-28","Student Loan Payment",-150,-150]
[]
[null,"Travel",null,null,-35,-35]
[null,null,"2016-09-14","Oil Change",-35,-35]
[]
[null,"Utilities",null,null,-250,-250]
[null,null,"2016-09-24","Utilities",-75,-75]
[null,null,"2016-09-12","Cell Phone",-75,-75]
[null,null,"2016-09-29","Cable/Internet",-100,-100]
[]
[null,"Grand Total",null,null,220,220]

{"sheet":"BudgetVwr_Source","index":4,"n_rows":150,"n_cols":16,"rows_kept":150,"cut":false,"hidden":true,"merged":[]}
["For Budget viewer",null,"DO NOT DELETE"]
[]
["Year","Month","Amount","Date","Category","Type","Description","Empty","Clear_Date","Clear_YM","Statement Month","Clear_Year","Debit","Credit","Credit_Debit","Upto_M_bal"]
[{"$f":"YEAR(Register!B10)","v":2016},{"$f":"TEXT(Register!B10,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I10+Register!J10","v":1350},{"$f":"IF(Register!B10=\"\",\"\",Register!B10)","v":"2016-09-01"},{"$f":"IF(Register!F10=\"\",\"(blank line)\",Register!F10)","v":"Income"},{"$f":"Register!C10","v":"Direct Deposit"},{"$f":"IF(Register!D10=\"\",IF(Register!E10=\"\",\"(empty description)\",Register!E10),CONCATENATE(Register!D10,\" - \",Register!E10))","v":"Pay Day"},{"$f":"IF(C4=0,\"Y\",\"N\")","v":"N"},{"$f":"Register!H10","v":"2016-09-01"},{"$f":"L4*100+MONTH(I4)","v":201609},{"$f":"TEXT(Register!H10,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H10)","v":2016},{"$f":"Register!I10","v":0},{"$f":"Register!J10","v":1350},{"$f":"IF(M4<0,\"Debit\",\"Credit\")","v":"Credit"},{"$f":"SUMIF(J$4:J$150,\"<\"&J4,C$4:C$150)","v":0}]
[{"$f":"YEAR(Register!B11)","v":2016},{"$f":"TEXT(Register!B11,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I11+Register!J11","v":-650},{"$f":"IF(Register!B11=\"\",\"\",Register!B11)","v":"2016-09-01"},{"$f":"IF(Register!F11=\"\",\"(blank line)\",Register!F11)","v":"Housing/Rent"},{"$f":"Register!C11","v":"Auto from Checking"},{"$f":"IF(Register!D11=\"\",IF(Register!E11=\"\",\"(empty description)\",Register!E11),CONCATENATE(Register!D11,\" - \",Register!E11))","v":"September Rent - Due 9/1"},{"$f":"IF(C5=0,\"Y\",\"N\")","v":"N"},{"$f":"Register!H11","v":"2016-09-01"},{"$f":"L5*100+MONTH(I5)","v":201609},{"$f":"TEXT(Register!H11,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H11)","v":2016},{"$f":"Register!I11","v":-650},{"$f":"Register!J11","v":0},{"$f":"IF(M5<0,\"Debit\",\"Credit\")","v":"Debit"},{"$f":"SUMIF(J$4:J$150,\"<\"&J5,C$4:C$150)","v":0}]
[{"$f":"YEAR(Register!B12)","v":2016},{"$f":"TEXT(Register!B12,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I12+Register!J12","v":-75},{"$f":"IF(Register!B12=\"\",\"\",Register!B12)","v":"2016-09-01"},{"$f":"IF(Register!F12=\"\",\"(blank line)\",Register!F12)","v":"Emergency Fund"},{"$f":"Register!C12","v":"Auto to Savings"},{"$f":"IF(Register!D12=\"\",IF(Register!E12=\"\",\"(empty description)\",Register!E12),CONCATENATE(Register!D12,\" - \",Register!E12))","v":"Save for Emergency Fund"},"N",{"$f":"Register!H12","v":"2016-09-01"},201609,{"$f":"TEXT(Register!H12,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H12)","v":2016},{"$f":"Register!I12","v":-75},{"$f":"Register!J12","v":0},"Debit",0]
[{"$f":"YEAR(Register!B13)","v":2016},{"$f":"TEXT(Register!B13,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I13+Register!J13","v":-125},{"$f":"IF(Register!B13=\"\",\"\",Register!B13)","v":"2016-09-07"},{"$f":"IF(Register!F13=\"\",\"(blank line)\",Register!F13)","v":"Groceries"},{"$f":"Register!C13","v":"Debit Card"},{"$f":"IF(Register!D13=\"\",IF(Register!E13=\"\",\"(empty description)\",Register!E13),CONCATENATE(Register!D13,\" - \",Register!E13))","v":"Groceries"},"N",{"$f":"Register!H13","v":"2016-09-07"},201609,{"$f":"TEXT(Register!H13,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H13)","v":2016},{"$f":"Register!I13","v":-125},{"$f":"Register!J13","v":0},"Debit",0]
[{"$f":"YEAR(Register!B14)","v":2016},{"$f":"TEXT(Register!B14,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I14+Register!J14","v":-100},{"$f":"IF(Register!B14=\"\",\"\",Register!B14)","v":"2016-09-08"},{"$f":"IF(Register!F14=\"\",\"(blank line)\",Register!F14)","v":"Entertainment"},{"$f":"Register!C14","v":"ATM Cash"},{"$f":"IF(Register!D14=\"\",IF(Register!E14=\"\",\"(empty description)\",Register!E14),CONCATENATE(Register!D14,\" - \",Register!E14))","v":"Spending Money"},"N",{"$f":"Register!H14","v":"2016-09-08"},201609,{"$f":"TEXT(Register!H14,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H14)","v":2016},{"$f":"Register!I14","v":-100},{"$f":"Register!J14","v":0},"Debit",0]
[{"$f":"YEAR(Register!B15)","v":2016},{"$f":"TEXT(Register!B15,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I15+Register!J15","v":-75},{"$f":"IF(Register!B15=\"\",\"\",Register!B15)","v":"2016-09-12"},{"$f":"IF(Register!F15=\"\",\"(blank line)\",Register!F15)","v":"Utilities"},{"$f":"Register!C15","v":"Auto from Checking"},{"$f":"IF(Register!D15=\"\",IF(Register!E15=\"\",\"(empty description)\",Register!E15),CONCATENATE(Register!D15,\" - \",Register!E15))","v":"Cell Phone"},"N",{"$f":"Register!H15","v":"2016-09-12"},201609,{"$f":"TEXT(Register!H15,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H15)","v":2016},{"$f":"Register!I15","v":-75},{"$f":"Register!J15","v":0},"Debit",0]
[{"$f":"YEAR(Register!B16)","v":2016},{"$f":"TEXT(Register!B16,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I16+Register!J16","v":-300},{"$f":"IF(Register!B16=\"\",\"\",Register!B16)","v":"2016-09-14"},{"$f":"IF(Register!F16=\"\",\"(blank line)\",Register!F16)","v":"Loan Payment"},{"$f":"Register!C16","v":"Auto from Checking"},{"$f":"IF(Register!D16=\"\",IF(Register!E16=\"\",\"(empty description)\",Register!E16),CONCATENATE(Register!D16,\" - \",Register!E16))","v":"Car Loan Payment"},"N",{"$f":"Register!H16","v":"2016-09-14"},201609,{"$f":"TEXT(Register!H16,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H16)","v":2016},{"$f":"Register!I16","v":-300},{"$f":"Register!J16","v":0},"Debit",0]
[{"$f":"YEAR(Register!B17)","v":2016},{"$f":"TEXT(Register!B17,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I17+Register!J17","v":-150},{"$f":"IF(Register!B17=\"\",\"\",Register!B17)","v":"2016-09-14"},{"$f":"IF(Register!F17=\"\",\"(blank line)\",Register!F17)","v":"Insurance"},{"$f":"Register!C17","v":"Auto from Checking"},{"$f":"IF(Register!D17=\"\",IF(Register!E17=\"\",\"(empty description)\",Register!E17),CONCATENATE(Register!D17,\" - \",Register!E17))","v":"Auto Insurance and Renter's Insurance"},"N",{"$f":"Register!H17","v":"2016-09-14"},201609,{"$f":"TEXT(Register!H17,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H17)","v":2016},{"$f":"Register!I17","v":-150},{"$f":"Register!J17","v":0},"Debit",0]
[{"$f":"YEAR(Register!B18)","v":2016},{"$f":"TEXT(Register!B18,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I18+Register!J18","v":-35},{"$f":"IF(Register!B18=\"\",\"\",Register!B18)","v":"2016-09-14"},{"$f":"IF(Register!F18=\"\",\"(blank line)\",Register!F18)","v":"Bank Fee"},{"$f":"Register!C18","v":"Bank Fee"},{"$f":"IF(Register!D18=\"\",IF(Register!E18=\"\",\"(empty description)\",Register!E18),CONCATENATE(Register!D18,\" - \",Register!E18))","v":"OVERDRAFT"},"N",{"$f":"Register!H18","v":"2016-09-14"},201609,{"$f":"TEXT(Register!H18,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H18)","v":2016},{"$f":"Register!I18","v":-35},{"$f":"Register!J18","v":0},"Debit",0]
[{"$f":"YEAR(Register!B19)","v":2016},{"$f":"TEXT(Register!B19,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I19+Register!J19","v":-35},{"$f":"IF(Register!B19=\"\",\"\",Register!B19)","v":"2016-09-14"},{"$f":"IF(Register!F19=\"\",\"(blank line)\",Register!F19)","v":"Travel"},{"$f":"Register!C19","v":"Debit Card"},{"$f":"IF(Register!D19=\"\",IF(Register!E19=\"\",\"(empty description)\",Register!E19),CONCATENATE(Register!D19,\" - \",Register!E19))","v":"Oil Change"},"N",{"$f":"Register!H19","v":"2016-09-14"},201609,{"$f":"TEXT(Register!H19,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H19)","v":2016},{"$f":"Register!I19","v":-35},{"$f":"Register!J19","v":0},"Debit",0]
[{"$f":"YEAR(Register!B20)","v":2016},{"$f":"TEXT(Register!B20,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I20+Register!J20","v":-35},{"$f":"IF(Register!B20=\"\",\"\",Register!B20)","v":"2016-09-14"},{"$f":"IF(Register!F20=\"\",\"(blank line)\",Register!F20)","v":"Bank Fee"},{"$f":"Register!C20","v":"Bank Fee"},{"$f":"IF(Register!D20=\"\",IF(Register!E20=\"\",\"(empty description)\",Register!E20),CONCATENATE(Register!D20,\" - \",Register!E20))","v":"OVERDRAFT"},"N",{"$f":"Register!H20","v":"2016-09-14"},201609,{"$f":"TEXT(Register!H20,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H20)","v":2016},{"$f":"Register!I20","v":-35},{"$f":"Register!J20","v":0},"Debit",0]
[{"$f":"YEAR(Register!B21)","v":2016},{"$f":"TEXT(Register!B21,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I21+Register!J21","v":1350},{"$f":"IF(Register!B21=\"\",\"\",Register!B21)","v":"2016-09-15"},{"$f":"IF(Register!F21=\"\",\"(blank line)\",Register!F21)","v":"Income"},{"$f":"Register!C21","v":"Direct Deposit"},{"$f":"IF(Register!D21=\"\",IF(Register!E21=\"\",\"(empty description)\",Register!E21),CONCATENATE(Register!D21,\" - \",Register!E21))","v":"Pay Day"},"N",{"$f":"Register!H21","v":"2016-09-15"},201609,{"$f":"TEXT(Register!H21,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H21)","v":2016},{"$f":"Register!I21","v":0},{"$f":"Register!J21","v":1350},"Credit",0]
[{"$f":"YEAR(Register!B22)","v":2016},{"$f":"TEXT(Register!B22,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I22+Register!J22","v":-125},{"$f":"IF(Register!B22=\"\",\"\",Register!B22)","v":"2016-09-20"},{"$f":"IF(Register!F22=\"\",\"(blank line)\",Register!F22)","v":"Groceries"},{"$f":"Register!C22","v":"Debit Card"},{"$f":"IF(Register!D22=\"\",IF(Register!E22=\"\",\"(empty description)\",Register!E22),CONCATENATE(Register!D22,\" - \",Register!E22))","v":"Groceries"},"N",{"$f":"Register!H22","v":"2016-09-20"},201609,{"$f":"TEXT(Register!H22,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H22)","v":2016},{"$f":"Register!I22","v":-125},{"$f":"Register!J22","v":0},"Debit",0]
[{"$f":"YEAR(Register!B23)","v":2016},{"$f":"TEXT(Register!B23,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I23+Register!J23","v":-100},{"$f":"IF(Register!B23=\"\",\"\",Register!B23)","v":"2016-09-22"},{"$f":"IF(Register!F23=\"\",\"(blank line)\",Register!F23)","v":"Entertainment"},{"$f":"Register!C23","v":"ATM Cash"},{"$f":"IF(Register!D23=\"\",IF(Register!E23=\"\",\"(empty description)\",Register!E23),CONCATENATE(Register!D23,\" - \",Register!E23))","v":"Spending Money"},"N",{"$f":"Register!H23","v":"2016-09-22"},201609,{"$f":"TEXT(Register!H23,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H23)","v":2016},{"$f":"Register!I23","v":-100},{"$f":"Register!J23","v":0},"Debit",0]
[{"$f":"YEAR(Register!B24)","v":2016},{"$f":"TEXT(Register!B24,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I24+Register!J24","v":-75},{"$f":"IF(Register!B24=\"\",\"\",Register!B24)","v":"2016-09-24"},{"$f":"IF(Register!F24=\"\",\"(blank line)\",Register!F24)","v":"Utilities"},{"$f":"Register!C24","v":"Auto from Checking"},{"$f":"IF(Register!D24=\"\",IF(Register!E24=\"\",\"(empty description)\",Register!E24),CONCATENATE(Register!D24,\" - \",Register!E24))","v":"Utilities"},"N",{"$f":"Register!H24","v":"2016-09-24"},201609,{"$f":"TEXT(Register!H24,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H24)","v":2016},{"$f":"Register!I24","v":-75},{"$f":"Register!J24","v":0},"Debit",0]
[{"$f":"YEAR(Register!B25)","v":2016},{"$f":"TEXT(Register!B25,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I25+Register!J25","v":-150},{"$f":"IF(Register!B25=\"\",\"\",Register!B25)","v":"2016-09-28"},{"$f":"IF(Register!F25=\"\",\"(blank line)\",Register!F25)","v":"Loan Payment"},{"$f":"Register!C25","v":"Check"},{"$f":"IF(Register!D25=\"\",IF(Register!E25=\"\",\"(empty description)\",Register!E25),CONCATENATE(Register!D25,\" - \",Register!E25))","v":"Student Loan Payment"},"N",{"$f":"Register!H25","v":"2016-10-03"},201610,{"$f":"TEXT(Register!H25,\"mmm-yyyy\")","v":"Oct-2016"},{"$f":"YEAR(Register!H25)","v":2016},{"$f":"Register!I25","v":-150},{"$f":"Register!J25","v":0},"Debit",470]
[{"$f":"YEAR(Register!B26)","v":2016},{"$f":"TEXT(Register!B26,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I26+Register!J26","v":-100},{"$f":"IF(Register!B26=\"\",\"\",Register!B26)","v":"2016-09-29"},{"$f":"IF(Register!F26=\"\",\"(blank line)\",Register!F26)","v":"Utilities"},{"$f":"Register!C26","v":"Auto from Checking"},{"$f":"IF(Register!D26=\"\",IF(Register!E26=\"\",\"(empty description)\",Register!E26),CONCATENATE(Register!D26,\" - \",Register!E26))","v":"Cable/Internet"},"N",{"$f":"Register!H26","v":"2016-09-29"},201609,{"$f":"TEXT(Register!H26,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H26)","v":2016},{"$f":"Register!I26","v":-100},{"$f":"Register!J26","v":0},"Debit",0]
[{"$f":"YEAR(Register!B27)","v":2016},{"$f":"TEXT(Register!B27,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I27+Register!J27","v":-100},{"$f":"IF(Register!B27=\"\",\"\",Register!B27)","v":"2016-09-28"},{"$f":"IF(Register!F27=\"\",\"(blank line)\",Register!F27)","v":"Entertainment"},{"$f":"Register!C27","v":"Check"},{"$f":"IF(Register!D27=\"\",IF(Register!E27=\"\",\"(empty description)\",Register!E27),CONCATENATE(Register!D27,\" - \",Register!E27))","v":"Pay back friend for concert ticket "},"N",{"$f":"Register!H27","v":"2016-10-03"},201610,{"$f":"TEXT(Register!H27,\"mmm-yyyy\")","v":"Oct-2016"},{"$f":"YEAR(Register!H27)","v":2016},{"$f":"Register!I27","v":-100},{"$f":"Register!J27","v":0},"Debit",470]
[{"$f":"YEAR(Register!B28)","v":2016},{"$f":"TEXT(Register!B28,\"mmmm - yy\")","v":"September - 16"},{"$f":"Register!I28+Register!J28","v":-250},{"$f":"IF(Register!B28=\"\",\"\",Register!B28)","v":"2016-09-29"},{"$f":"IF(Register!F28=\"\",\"(blank line)\",Register!F28)","v":"Entertainment"},{"$f":"Register!C28","v":"Debit Card"},{"$f":"IF(Register!D28=\"\",IF(Register!E28=\"\",\"(empty description)\",Register!E28),CONCATENATE(Register!D28,\" - \",Register!E28))","v":"Weekend Getaway"},"N",{"$f":"Register!H28","v":"2016-09-29"},201609,{"$f":"TEXT(Register!H28,\"mmm-yyyy\")","v":"Sep-2016"},{"$f":"YEAR(Register!H28)","v":2016},{"$f":"Register!I28","v":-250},{"$f":"Register!J28","v":0},"Debit",0]
[{"$f":"YEAR(Register!B29)","v":1900},{"$f":"TEXT(Register!B29,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I29+Register!J29","v":0},{"$f":"IF(Register!B29=\"\",\"\",Register!B29)","v":""},{"$f":"IF(Register!F29=\"\",\"(blank line)\",Register!F29)","v":"(blank line)"},{"$f":"Register!C29","v":"00:00:00"},{"$f":"IF(Register!D29=\"\",IF(Register!E29=\"\",\"(empty description)\",Register!E29),CONCATENATE(Register!D29,\" - \",Register!E29))","v":"(empty description)"},"Y",{"$f":"Register!H29","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H29,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H29)","v":{"$error":"#VALUE!"}},{"$f":"Register!I29","v":0},{"$f":"Register!J29","v":0},"Credit",0]
[{"$f":"YEAR(Register!B30)","v":1900},{"$f":"TEXT(Register!B30,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I30+Register!J30","v":0},{"$f":"IF(Register!B30=\"\",\"\",Register!B30)","v":""},{"$f":"IF(Register!F30=\"\",\"(blank line)\",Register!F30)","v":"(blank line)"},{"$f":"Register!C30","v":"00:00:00"},{"$f":"IF(Register!D30=\"\",IF(Register!E30=\"\",\"(empty description)\",Register!E30),CONCATENATE(Register!D30,\" - \",Register!E30))","v":"(empty description)"},"Y",{"$f":"Register!H30","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H30,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H30)","v":{"$error":"#VALUE!"}},{"$f":"Register!I30","v":0},{"$f":"Register!J30","v":0},"Credit",0]
[{"$f":"YEAR(Register!B31)","v":1900},{"$f":"TEXT(Register!B31,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I31+Register!J31","v":0},{"$f":"IF(Register!B31=\"\",\"\",Register!B31)","v":""},{"$f":"IF(Register!F31=\"\",\"(blank line)\",Register!F31)","v":"(blank line)"},{"$f":"Register!C31","v":"00:00:00"},{"$f":"IF(Register!D31=\"\",IF(Register!E31=\"\",\"(empty description)\",Register!E31),CONCATENATE(Register!D31,\" - \",Register!E31))","v":"(empty description)"},"Y",{"$f":"Register!H31","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H31,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H31)","v":{"$error":"#VALUE!"}},{"$f":"Register!I31","v":0},{"$f":"Register!J31","v":0},"Credit",0]
[{"$f":"YEAR(Register!B32)","v":1900},{"$f":"TEXT(Register!B32,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I32+Register!J32","v":0},{"$f":"IF(Register!B32=\"\",\"\",Register!B32)","v":""},{"$f":"IF(Register!F32=\"\",\"(blank line)\",Register!F32)","v":"(blank line)"},{"$f":"Register!C32","v":"00:00:00"},{"$f":"IF(Register!D32=\"\",IF(Register!E32=\"\",\"(empty description)\",Register!E32),CONCATENATE(Register!D32,\" - \",Register!E32))","v":"(empty description)"},"Y",{"$f":"Register!H32","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H32,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H32)","v":{"$error":"#VALUE!"}},{"$f":"Register!I32","v":0},{"$f":"Register!J32","v":0},"Credit",0]
[{"$f":"YEAR(Register!B33)","v":1900},{"$f":"TEXT(Register!B33,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I33+Register!J33","v":0},{"$f":"IF(Register!B33=\"\",\"\",Register!B33)","v":""},{"$f":"IF(Register!F33=\"\",\"(blank line)\",Register!F33)","v":"(blank line)"},{"$f":"Register!C33","v":"00:00:00"},{"$f":"IF(Register!D33=\"\",IF(Register!E33=\"\",\"(empty description)\",Register!E33),CONCATENATE(Register!D33,\" - \",Register!E33))","v":"(empty description)"},"Y",{"$f":"Register!H33","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H33,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H33)","v":{"$error":"#VALUE!"}},{"$f":"Register!I33","v":0},{"$f":"Register!J33","v":0},"Credit",0]
[{"$f":"YEAR(Register!B34)","v":1900},{"$f":"TEXT(Register!B34,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I34+Register!J34","v":0},{"$f":"IF(Register!B34=\"\",\"\",Register!B34)","v":""},{"$f":"IF(Register!F34=\"\",\"(blank line)\",Register!F34)","v":"(blank line)"},{"$f":"Register!C34","v":"00:00:00"},{"$f":"IF(Register!D34=\"\",IF(Register!E34=\"\",\"(empty description)\",Register!E34),CONCATENATE(Register!D34,\" - \",Register!E34))","v":"(empty description)"},"Y",{"$f":"Register!H34","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H34,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H34)","v":{"$error":"#VALUE!"}},{"$f":"Register!I34","v":0},{"$f":"Register!J34","v":0},"Credit",0]
[{"$f":"YEAR(Register!B35)","v":1900},{"$f":"TEXT(Register!B35,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I35+Register!J35","v":0},{"$f":"IF(Register!B35=\"\",\"\",Register!B35)","v":""},{"$f":"IF(Register!F35=\"\",\"(blank line)\",Register!F35)","v":"(blank line)"},{"$f":"Register!C35","v":"00:00:00"},{"$f":"IF(Register!D35=\"\",IF(Register!E35=\"\",\"(empty description)\",Register!E35),CONCATENATE(Register!D35,\" - \",Register!E35))","v":"(empty description)"},"Y",{"$f":"Register!H35","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H35,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H35)","v":{"$error":"#VALUE!"}},{"$f":"Register!I35","v":0},{"$f":"Register!J35","v":0},"Credit",0]
[{"$f":"YEAR(Register!B36)","v":1900},{"$f":"TEXT(Register!B36,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I36+Register!J36","v":0},{"$f":"IF(Register!B36=\"\",\"\",Register!B36)","v":""},{"$f":"IF(Register!F36=\"\",\"(blank line)\",Register!F36)","v":"(blank line)"},{"$f":"Register!C36","v":"00:00:00"},{"$f":"IF(Register!D36=\"\",IF(Register!E36=\"\",\"(empty description)\",Register!E36),CONCATENATE(Register!D36,\" - \",Register!E36))","v":"(empty description)"},"Y",{"$f":"Register!H36","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H36,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H36)","v":{"$error":"#VALUE!"}},{"$f":"Register!I36","v":0},{"$f":"Register!J36","v":0},"Credit",0]
[{"$f":"YEAR(Register!B37)","v":1900},{"$f":"TEXT(Register!B37,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I37+Register!J37","v":0},{"$f":"IF(Register!B37=\"\",\"\",Register!B37)","v":""},{"$f":"IF(Register!F37=\"\",\"(blank line)\",Register!F37)","v":"(blank line)"},{"$f":"Register!C37","v":"00:00:00"},{"$f":"IF(Register!D37=\"\",IF(Register!E37=\"\",\"(empty description)\",Register!E37),CONCATENATE(Register!D37,\" - \",Register!E37))","v":"(empty description)"},"Y",{"$f":"Register!H37","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H37,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H37)","v":{"$error":"#VALUE!"}},{"$f":"Register!I37","v":0},{"$f":"Register!J37","v":0},"Credit",0]
[{"$f":"YEAR(Register!B38)","v":1900},{"$f":"TEXT(Register!B38,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I38+Register!J38","v":0},{"$f":"IF(Register!B38=\"\",\"\",Register!B38)","v":""},{"$f":"IF(Register!F38=\"\",\"(blank line)\",Register!F38)","v":"(blank line)"},{"$f":"Register!C38","v":"00:00:00"},{"$f":"IF(Register!D38=\"\",IF(Register!E38=\"\",\"(empty description)\",Register!E38),CONCATENATE(Register!D38,\" - \",Register!E38))","v":"(empty description)"},"Y",{"$f":"Register!H38","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H38,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H38)","v":{"$error":"#VALUE!"}},{"$f":"Register!I38","v":0},{"$f":"Register!J38","v":0},"Credit",0]
[{"$f":"YEAR(Register!B39)","v":1900},{"$f":"TEXT(Register!B39,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I39+Register!J39","v":0},{"$f":"IF(Register!B39=\"\",\"\",Register!B39)","v":""},{"$f":"IF(Register!F39=\"\",\"(blank line)\",Register!F39)","v":"(blank line)"},{"$f":"Register!C39","v":"00:00:00"},{"$f":"IF(Register!D39=\"\",IF(Register!E39=\"\",\"(empty description)\",Register!E39),CONCATENATE(Register!D39,\" - \",Register!E39))","v":"(empty description)"},"Y",{"$f":"Register!H39","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H39,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H39)","v":{"$error":"#VALUE!"}},{"$f":"Register!I39","v":0},{"$f":"Register!J39","v":0},"Credit",0]
[{"$f":"YEAR(Register!B40)","v":1900},{"$f":"TEXT(Register!B40,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I40+Register!J40","v":0},{"$f":"IF(Register!B40=\"\",\"\",Register!B40)","v":""},{"$f":"IF(Register!F40=\"\",\"(blank line)\",Register!F40)","v":"(blank line)"},{"$f":"Register!C40","v":"00:00:00"},{"$f":"IF(Register!D40=\"\",IF(Register!E40=\"\",\"(empty description)\",Register!E40),CONCATENATE(Register!D40,\" - \",Register!E40))","v":"(empty description)"},"Y",{"$f":"Register!H40","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H40,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H40)","v":{"$error":"#VALUE!"}},{"$f":"Register!I40","v":0},{"$f":"Register!J40","v":0},"Credit",0]
[{"$f":"YEAR(Register!B41)","v":1900},{"$f":"TEXT(Register!B41,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I41+Register!J41","v":0},{"$f":"IF(Register!B41=\"\",\"\",Register!B41)","v":""},{"$f":"IF(Register!F41=\"\",\"(blank line)\",Register!F41)","v":"(blank line)"},{"$f":"Register!C41","v":"00:00:00"},{"$f":"IF(Register!D41=\"\",IF(Register!E41=\"\",\"(empty description)\",Register!E41),CONCATENATE(Register!D41,\" - \",Register!E41))","v":"(empty description)"},"Y",{"$f":"Register!H41","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H41,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H41)","v":{"$error":"#VALUE!"}},{"$f":"Register!I41","v":0},{"$f":"Register!J41","v":0},"Credit",0]
[{"$f":"YEAR(Register!B42)","v":1900},{"$f":"TEXT(Register!B42,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I42+Register!J42","v":0},{"$f":"IF(Register!B42=\"\",\"\",Register!B42)","v":""},{"$f":"IF(Register!F42=\"\",\"(blank line)\",Register!F42)","v":"(blank line)"},{"$f":"Register!C42","v":"00:00:00"},{"$f":"IF(Register!D42=\"\",IF(Register!E42=\"\",\"(empty description)\",Register!E42),CONCATENATE(Register!D42,\" - \",Register!E42))","v":"(empty description)"},"Y",{"$f":"Register!H42","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H42,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H42)","v":{"$error":"#VALUE!"}},{"$f":"Register!I42","v":0},{"$f":"Register!J42","v":0},"Credit",0]
[{"$f":"YEAR(Register!B43)","v":1900},{"$f":"TEXT(Register!B43,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I43+Register!J43","v":0},{"$f":"IF(Register!B43=\"\",\"\",Register!B43)","v":""},{"$f":"IF(Register!F43=\"\",\"(blank line)\",Register!F43)","v":"(blank line)"},{"$f":"Register!C43","v":"00:00:00"},{"$f":"IF(Register!D43=\"\",IF(Register!E43=\"\",\"(empty description)\",Register!E43),CONCATENATE(Register!D43,\" - \",Register!E43))","v":"(empty description)"},"Y",{"$f":"Register!H43","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H43,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H43)","v":{"$error":"#VALUE!"}},{"$f":"Register!I43","v":0},{"$f":"Register!J43","v":0},"Credit",0]
[{"$f":"YEAR(Register!B44)","v":1900},{"$f":"TEXT(Register!B44,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I44+Register!J44","v":0},{"$f":"IF(Register!B44=\"\",\"\",Register!B44)","v":""},{"$f":"IF(Register!F44=\"\",\"(blank line)\",Register!F44)","v":"(blank line)"},{"$f":"Register!C44","v":"00:00:00"},{"$f":"IF(Register!D44=\"\",IF(Register!E44=\"\",\"(empty description)\",Register!E44),CONCATENATE(Register!D44,\" - \",Register!E44))","v":"(empty description)"},"Y",{"$f":"Register!H44","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H44,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H44)","v":{"$error":"#VALUE!"}},{"$f":"Register!I44","v":0},{"$f":"Register!J44","v":0},"Credit",0]
[{"$f":"YEAR(Register!B45)","v":1900},{"$f":"TEXT(Register!B45,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I45+Register!J45","v":0},{"$f":"IF(Register!B45=\"\",\"\",Register!B45)","v":""},{"$f":"IF(Register!F45=\"\",\"(blank line)\",Register!F45)","v":"(blank line)"},{"$f":"Register!C45","v":"00:00:00"},{"$f":"IF(Register!D45=\"\",IF(Register!E45=\"\",\"(empty description)\",Register!E45),CONCATENATE(Register!D45,\" - \",Register!E45))","v":"(empty description)"},"Y",{"$f":"Register!H45","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H45,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H45)","v":{"$error":"#VALUE!"}},{"$f":"Register!I45","v":0},{"$f":"Register!J45","v":0},"Credit",0]
[{"$f":"YEAR(Register!B46)","v":1900},{"$f":"TEXT(Register!B46,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I46+Register!J46","v":0},{"$f":"IF(Register!B46=\"\",\"\",Register!B46)","v":""},{"$f":"IF(Register!F46=\"\",\"(blank line)\",Register!F46)","v":"(blank line)"},{"$f":"Register!C46","v":"00:00:00"},{"$f":"IF(Register!D46=\"\",IF(Register!E46=\"\",\"(empty description)\",Register!E46),CONCATENATE(Register!D46,\" - \",Register!E46))","v":"(empty description)"},"Y",{"$f":"Register!H46","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H46,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H46)","v":{"$error":"#VALUE!"}},{"$f":"Register!I46","v":0},{"$f":"Register!J46","v":0},"Credit",0]
[{"$f":"YEAR(Register!B47)","v":1900},{"$f":"TEXT(Register!B47,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I47+Register!J47","v":0},{"$f":"IF(Register!B47=\"\",\"\",Register!B47)","v":""},{"$f":"IF(Register!F47=\"\",\"(blank line)\",Register!F47)","v":"(blank line)"},{"$f":"Register!C47","v":"00:00:00"},{"$f":"IF(Register!D47=\"\",IF(Register!E47=\"\",\"(empty description)\",Register!E47),CONCATENATE(Register!D47,\" - \",Register!E47))","v":"(empty description)"},"Y",{"$f":"Register!H47","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H47,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H47)","v":{"$error":"#VALUE!"}},{"$f":"Register!I47","v":0},{"$f":"Register!J47","v":0},"Credit",0]
[{"$f":"YEAR(Register!B48)","v":1900},{"$f":"TEXT(Register!B48,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I48+Register!J48","v":0},{"$f":"IF(Register!B48=\"\",\"\",Register!B48)","v":""},{"$f":"IF(Register!F48=\"\",\"(blank line)\",Register!F48)","v":"(blank line)"},{"$f":"Register!C48","v":"00:00:00"},{"$f":"IF(Register!D48=\"\",IF(Register!E48=\"\",\"(empty description)\",Register!E48),CONCATENATE(Register!D48,\" - \",Register!E48))","v":"(empty description)"},"Y",{"$f":"Register!H48","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H48,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H48)","v":{"$error":"#VALUE!"}},{"$f":"Register!I48","v":0},{"$f":"Register!J48","v":0},"Credit",0]
[{"$f":"YEAR(Register!B49)","v":1900},{"$f":"TEXT(Register!B49,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I49+Register!J49","v":0},{"$f":"IF(Register!B49=\"\",\"\",Register!B49)","v":""},{"$f":"IF(Register!F49=\"\",\"(blank line)\",Register!F49)","v":"(blank line)"},{"$f":"Register!C49","v":"00:00:00"},{"$f":"IF(Register!D49=\"\",IF(Register!E49=\"\",\"(empty description)\",Register!E49),CONCATENATE(Register!D49,\" - \",Register!E49))","v":"(empty description)"},"Y",{"$f":"Register!H49","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H49,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H49)","v":{"$error":"#VALUE!"}},{"$f":"Register!I49","v":0},{"$f":"Register!J49","v":0},"Credit",0]
[{"$f":"YEAR(Register!B50)","v":1900},{"$f":"TEXT(Register!B50,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I50+Register!J50","v":0},{"$f":"IF(Register!B50=\"\",\"\",Register!B50)","v":""},{"$f":"IF(Register!F50=\"\",\"(blank line)\",Register!F50)","v":"(blank line)"},{"$f":"Register!C50","v":"00:00:00"},{"$f":"IF(Register!D50=\"\",IF(Register!E50=\"\",\"(empty description)\",Register!E50),CONCATENATE(Register!D50,\" - \",Register!E50))","v":"(empty description)"},"Y",{"$f":"Register!H50","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H50,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H50)","v":{"$error":"#VALUE!"}},{"$f":"Register!I50","v":0},{"$f":"Register!J50","v":0},"Credit",0]
[{"$f":"YEAR(Register!B51)","v":1900},{"$f":"TEXT(Register!B51,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I51+Register!J51","v":0},{"$f":"IF(Register!B51=\"\",\"\",Register!B51)","v":""},{"$f":"IF(Register!F51=\"\",\"(blank line)\",Register!F51)","v":"(blank line)"},{"$f":"Register!C51","v":"00:00:00"},{"$f":"IF(Register!D51=\"\",IF(Register!E51=\"\",\"(empty description)\",Register!E51),CONCATENATE(Register!D51,\" - \",Register!E51))","v":"(empty description)"},"Y",{"$f":"Register!H51","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H51,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H51)","v":{"$error":"#VALUE!"}},{"$f":"Register!I51","v":0},{"$f":"Register!J51","v":0},"Credit",0]
[{"$f":"YEAR(Register!B52)","v":1900},{"$f":"TEXT(Register!B52,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I52+Register!J52","v":0},{"$f":"IF(Register!B52=\"\",\"\",Register!B52)","v":""},{"$f":"IF(Register!F52=\"\",\"(blank line)\",Register!F52)","v":"(blank line)"},{"$f":"Register!C52","v":"00:00:00"},{"$f":"IF(Register!D52=\"\",IF(Register!E52=\"\",\"(empty description)\",Register!E52),CONCATENATE(Register!D52,\" - \",Register!E52))","v":"(empty description)"},"Y",{"$f":"Register!H52","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H52,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H52)","v":{"$error":"#VALUE!"}},{"$f":"Register!I52","v":0},{"$f":"Register!J52","v":0},"Credit",0]
[{"$f":"YEAR(Register!B53)","v":1900},{"$f":"TEXT(Register!B53,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I53+Register!J53","v":0},{"$f":"IF(Register!B53=\"\",\"\",Register!B53)","v":""},{"$f":"IF(Register!F53=\"\",\"(blank line)\",Register!F53)","v":"(blank line)"},{"$f":"Register!C53","v":"00:00:00"},{"$f":"IF(Register!D53=\"\",IF(Register!E53=\"\",\"(empty description)\",Register!E53),CONCATENATE(Register!D53,\" - \",Register!E53))","v":"(empty description)"},"Y",{"$f":"Register!H53","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H53,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H53)","v":{"$error":"#VALUE!"}},{"$f":"Register!I53","v":0},{"$f":"Register!J53","v":0},"Credit",0]
[{"$f":"YEAR(Register!B54)","v":1900},{"$f":"TEXT(Register!B54,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I54+Register!J54","v":0},{"$f":"IF(Register!B54=\"\",\"\",Register!B54)","v":""},{"$f":"IF(Register!F54=\"\",\"(blank line)\",Register!F54)","v":"(blank line)"},{"$f":"Register!C54","v":"00:00:00"},{"$f":"IF(Register!D54=\"\",IF(Register!E54=\"\",\"(empty description)\",Register!E54),CONCATENATE(Register!D54,\" - \",Register!E54))","v":"(empty description)"},"Y",{"$f":"Register!H54","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H54,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H54)","v":{"$error":"#VALUE!"}},{"$f":"Register!I54","v":0},{"$f":"Register!J54","v":0},"Credit",0]
[{"$f":"YEAR(Register!B55)","v":1900},{"$f":"TEXT(Register!B55,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I55+Register!J55","v":0},{"$f":"IF(Register!B55=\"\",\"\",Register!B55)","v":""},{"$f":"IF(Register!F55=\"\",\"(blank line)\",Register!F55)","v":"(blank line)"},{"$f":"Register!C55","v":"00:00:00"},{"$f":"IF(Register!D55=\"\",IF(Register!E55=\"\",\"(empty description)\",Register!E55),CONCATENATE(Register!D55,\" - \",Register!E55))","v":"(empty description)"},"Y",{"$f":"Register!H55","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H55,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H55)","v":{"$error":"#VALUE!"}},{"$f":"Register!I55","v":0},{"$f":"Register!J55","v":0},"Credit",0]
[{"$f":"YEAR(Register!B56)","v":1900},{"$f":"TEXT(Register!B56,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I56+Register!J56","v":0},{"$f":"IF(Register!B56=\"\",\"\",Register!B56)","v":""},{"$f":"IF(Register!F56=\"\",\"(blank line)\",Register!F56)","v":"(blank line)"},{"$f":"Register!C56","v":"00:00:00"},{"$f":"IF(Register!D56=\"\",IF(Register!E56=\"\",\"(empty description)\",Register!E56),CONCATENATE(Register!D56,\" - \",Register!E56))","v":"(empty description)"},"Y",{"$f":"Register!H56","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H56,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H56)","v":{"$error":"#VALUE!"}},{"$f":"Register!I56","v":0},{"$f":"Register!J56","v":0},"Credit",0]
[{"$f":"YEAR(Register!B57)","v":1900},{"$f":"TEXT(Register!B57,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I57+Register!J57","v":0},{"$f":"IF(Register!B57=\"\",\"\",Register!B57)","v":""},{"$f":"IF(Register!F57=\"\",\"(blank line)\",Register!F57)","v":"(blank line)"},{"$f":"Register!C57","v":"00:00:00"},{"$f":"IF(Register!D57=\"\",IF(Register!E57=\"\",\"(empty description)\",Register!E57),CONCATENATE(Register!D57,\" - \",Register!E57))","v":"(empty description)"},"Y",{"$f":"Register!H57","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H57,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H57)","v":{"$error":"#VALUE!"}},{"$f":"Register!I57","v":0},{"$f":"Register!J57","v":0},"Credit",0]
[{"$f":"YEAR(Register!B58)","v":1900},{"$f":"TEXT(Register!B58,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I58+Register!J58","v":0},{"$f":"IF(Register!B58=\"\",\"\",Register!B58)","v":""},{"$f":"IF(Register!F58=\"\",\"(blank line)\",Register!F58)","v":"(blank line)"},{"$f":"Register!C58","v":"00:00:00"},{"$f":"IF(Register!D58=\"\",IF(Register!E58=\"\",\"(empty description)\",Register!E58),CONCATENATE(Register!D58,\" - \",Register!E58))","v":"(empty description)"},"Y",{"$f":"Register!H58","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H58,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H58)","v":{"$error":"#VALUE!"}},{"$f":"Register!I58","v":0},{"$f":"Register!J58","v":0},"Credit",0]
[{"$f":"YEAR(Register!B59)","v":1900},{"$f":"TEXT(Register!B59,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I59+Register!J59","v":0},{"$f":"IF(Register!B59=\"\",\"\",Register!B59)","v":""},{"$f":"IF(Register!F59=\"\",\"(blank line)\",Register!F59)","v":"(blank line)"},{"$f":"Register!C59","v":"00:00:00"},{"$f":"IF(Register!D59=\"\",IF(Register!E59=\"\",\"(empty description)\",Register!E59),CONCATENATE(Register!D59,\" - \",Register!E59))","v":"(empty description)"},"Y",{"$f":"Register!H59","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H59,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H59)","v":{"$error":"#VALUE!"}},{"$f":"Register!I59","v":0},{"$f":"Register!J59","v":0},"Credit",0]
[{"$f":"YEAR(Register!B60)","v":1900},{"$f":"TEXT(Register!B60,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I60+Register!J60","v":0},{"$f":"IF(Register!B60=\"\",\"\",Register!B60)","v":""},{"$f":"IF(Register!F60=\"\",\"(blank line)\",Register!F60)","v":"(blank line)"},{"$f":"Register!C60","v":"00:00:00"},{"$f":"IF(Register!D60=\"\",IF(Register!E60=\"\",\"(empty description)\",Register!E60),CONCATENATE(Register!D60,\" - \",Register!E60))","v":"(empty description)"},"Y",{"$f":"Register!H60","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H60,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H60)","v":{"$error":"#VALUE!"}},{"$f":"Register!I60","v":0},{"$f":"Register!J60","v":0},"Credit",0]
[{"$f":"YEAR(Register!B61)","v":1900},{"$f":"TEXT(Register!B61,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I61+Register!J61","v":0},{"$f":"IF(Register!B61=\"\",\"\",Register!B61)","v":""},{"$f":"IF(Register!F61=\"\",\"(blank line)\",Register!F61)","v":"(blank line)"},{"$f":"Register!C61","v":"00:00:00"},{"$f":"IF(Register!D61=\"\",IF(Register!E61=\"\",\"(empty description)\",Register!E61),CONCATENATE(Register!D61,\" - \",Register!E61))","v":"(empty description)"},"Y",{"$f":"Register!H61","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H61,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H61)","v":{"$error":"#VALUE!"}},{"$f":"Register!I61","v":0},{"$f":"Register!J61","v":0},"Credit",0]
[{"$f":"YEAR(Register!B62)","v":1900},{"$f":"TEXT(Register!B62,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I62+Register!J62","v":0},{"$f":"IF(Register!B62=\"\",\"\",Register!B62)","v":""},{"$f":"IF(Register!F62=\"\",\"(blank line)\",Register!F62)","v":"(blank line)"},{"$f":"Register!C62","v":"00:00:00"},{"$f":"IF(Register!D62=\"\",IF(Register!E62=\"\",\"(empty description)\",Register!E62),CONCATENATE(Register!D62,\" - \",Register!E62))","v":"(empty description)"},"Y",{"$f":"Register!H62","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H62,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H62)","v":{"$error":"#VALUE!"}},{"$f":"Register!I62","v":0},{"$f":"Register!J62","v":0},"Credit",0]
[{"$f":"YEAR(Register!B63)","v":1900},{"$f":"TEXT(Register!B63,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I63+Register!J63","v":0},{"$f":"IF(Register!B63=\"\",\"\",Register!B63)","v":""},{"$f":"IF(Register!F63=\"\",\"(blank line)\",Register!F63)","v":"(blank line)"},{"$f":"Register!C63","v":"00:00:00"},{"$f":"IF(Register!D63=\"\",IF(Register!E63=\"\",\"(empty description)\",Register!E63),CONCATENATE(Register!D63,\" - \",Register!E63))","v":"(empty description)"},"Y",{"$f":"Register!H63","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H63,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H63)","v":{"$error":"#VALUE!"}},{"$f":"Register!I63","v":0},{"$f":"Register!J63","v":0},"Credit",0]
[{"$f":"YEAR(Register!B64)","v":1900},{"$f":"TEXT(Register!B64,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I64+Register!J64","v":0},{"$f":"IF(Register!B64=\"\",\"\",Register!B64)","v":""},{"$f":"IF(Register!F64=\"\",\"(blank line)\",Register!F64)","v":"(blank line)"},{"$f":"Register!C64","v":"00:00:00"},{"$f":"IF(Register!D64=\"\",IF(Register!E64=\"\",\"(empty description)\",Register!E64),CONCATENATE(Register!D64,\" - \",Register!E64))","v":"(empty description)"},"Y",{"$f":"Register!H64","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H64,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H64)","v":{"$error":"#VALUE!"}},{"$f":"Register!I64","v":0},{"$f":"Register!J64","v":0},"Credit",0]
[{"$f":"YEAR(Register!B65)","v":1900},{"$f":"TEXT(Register!B65,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I65+Register!J65","v":0},{"$f":"IF(Register!B65=\"\",\"\",Register!B65)","v":""},{"$f":"IF(Register!F65=\"\",\"(blank line)\",Register!F65)","v":"(blank line)"},{"$f":"Register!C65","v":"00:00:00"},{"$f":"IF(Register!D65=\"\",IF(Register!E65=\"\",\"(empty description)\",Register!E65),CONCATENATE(Register!D65,\" - \",Register!E65))","v":"(empty description)"},"Y",{"$f":"Register!H65","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H65,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H65)","v":{"$error":"#VALUE!"}},{"$f":"Register!I65","v":0},{"$f":"Register!J65","v":0},"Credit",0]
[{"$f":"YEAR(Register!B66)","v":1900},{"$f":"TEXT(Register!B66,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I66+Register!J66","v":0},{"$f":"IF(Register!B66=\"\",\"\",Register!B66)","v":""},{"$f":"IF(Register!F66=\"\",\"(blank line)\",Register!F66)","v":"(blank line)"},{"$f":"Register!C66","v":"00:00:00"},{"$f":"IF(Register!D66=\"\",IF(Register!E66=\"\",\"(empty description)\",Register!E66),CONCATENATE(Register!D66,\" - \",Register!E66))","v":"(empty description)"},"Y",{"$f":"Register!H66","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H66,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H66)","v":{"$error":"#VALUE!"}},{"$f":"Register!I66","v":0},{"$f":"Register!J66","v":0},"Credit",0]
[{"$f":"YEAR(Register!B67)","v":1900},{"$f":"TEXT(Register!B67,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I67+Register!J67","v":0},{"$f":"IF(Register!B67=\"\",\"\",Register!B67)","v":""},{"$f":"IF(Register!F67=\"\",\"(blank line)\",Register!F67)","v":"(blank line)"},{"$f":"Register!C67","v":"00:00:00"},{"$f":"IF(Register!D67=\"\",IF(Register!E67=\"\",\"(empty description)\",Register!E67),CONCATENATE(Register!D67,\" - \",Register!E67))","v":"(empty description)"},"Y",{"$f":"Register!H67","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H67,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H67)","v":{"$error":"#VALUE!"}},{"$f":"Register!I67","v":0},{"$f":"Register!J67","v":0},"Credit",0]
[{"$f":"YEAR(Register!B68)","v":1900},{"$f":"TEXT(Register!B68,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I68+Register!J68","v":0},{"$f":"IF(Register!B68=\"\",\"\",Register!B68)","v":""},{"$f":"IF(Register!F68=\"\",\"(blank line)\",Register!F68)","v":"(blank line)"},{"$f":"Register!C68","v":"00:00:00"},{"$f":"IF(Register!D68=\"\",IF(Register!E68=\"\",\"(empty description)\",Register!E68),CONCATENATE(Register!D68,\" - \",Register!E68))","v":"(empty description)"},"Y",{"$f":"Register!H68","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H68,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H68)","v":{"$error":"#VALUE!"}},{"$f":"Register!I68","v":0},{"$f":"Register!J68","v":0},"Credit",0]
[{"$f":"YEAR(Register!B69)","v":1900},{"$f":"TEXT(Register!B69,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I69+Register!J69","v":0},{"$f":"IF(Register!B69=\"\",\"\",Register!B69)","v":""},{"$f":"IF(Register!F69=\"\",\"(blank line)\",Register!F69)","v":"(blank line)"},{"$f":"Register!C69","v":"00:00:00"},{"$f":"IF(Register!D69=\"\",IF(Register!E69=\"\",\"(empty description)\",Register!E69),CONCATENATE(Register!D69,\" - \",Register!E69))","v":"(empty description)"},"Y",{"$f":"Register!H69","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H69,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H69)","v":{"$error":"#VALUE!"}},{"$f":"Register!I69","v":0},{"$f":"Register!J69","v":0},"Credit",0]
[{"$f":"YEAR(Register!B70)","v":1900},{"$f":"TEXT(Register!B70,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I70+Register!J70","v":0},{"$f":"IF(Register!B70=\"\",\"\",Register!B70)","v":""},{"$f":"IF(Register!F70=\"\",\"(blank line)\",Register!F70)","v":"(blank line)"},{"$f":"Register!C70","v":"00:00:00"},{"$f":"IF(Register!D70=\"\",IF(Register!E70=\"\",\"(empty description)\",Register!E70),CONCATENATE(Register!D70,\" - \",Register!E70))","v":"(empty description)"},"Y",{"$f":"Register!H70","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H70,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H70)","v":{"$error":"#VALUE!"}},{"$f":"Register!I70","v":0},{"$f":"Register!J70","v":0},"Credit",0]
[{"$f":"YEAR(Register!B71)","v":1900},{"$f":"TEXT(Register!B71,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I71+Register!J71","v":0},{"$f":"IF(Register!B71=\"\",\"\",Register!B71)","v":""},{"$f":"IF(Register!F71=\"\",\"(blank line)\",Register!F71)","v":"(blank line)"},{"$f":"Register!C71","v":"00:00:00"},{"$f":"IF(Register!D71=\"\",IF(Register!E71=\"\",\"(empty description)\",Register!E71),CONCATENATE(Register!D71,\" - \",Register!E71))","v":"(empty description)"},"Y",{"$f":"Register!H71","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H71,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H71)","v":{"$error":"#VALUE!"}},{"$f":"Register!I71","v":0},{"$f":"Register!J71","v":0},"Credit",0]
[{"$f":"YEAR(Register!B72)","v":1900},{"$f":"TEXT(Register!B72,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I72+Register!J72","v":0},{"$f":"IF(Register!B72=\"\",\"\",Register!B72)","v":""},{"$f":"IF(Register!F72=\"\",\"(blank line)\",Register!F72)","v":"(blank line)"},{"$f":"Register!C72","v":"00:00:00"},{"$f":"IF(Register!D72=\"\",IF(Register!E72=\"\",\"(empty description)\",Register!E72),CONCATENATE(Register!D72,\" - \",Register!E72))","v":"(empty description)"},"Y",{"$f":"Register!H72","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H72,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H72)","v":{"$error":"#VALUE!"}},{"$f":"Register!I72","v":0},{"$f":"Register!J72","v":0},"Credit",0]
[{"$f":"YEAR(Register!B73)","v":1900},{"$f":"TEXT(Register!B73,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I73+Register!J73","v":0},{"$f":"IF(Register!B73=\"\",\"\",Register!B73)","v":""},{"$f":"IF(Register!F73=\"\",\"(blank line)\",Register!F73)","v":"(blank line)"},{"$f":"Register!C73","v":"00:00:00"},{"$f":"IF(Register!D73=\"\",IF(Register!E73=\"\",\"(empty description)\",Register!E73),CONCATENATE(Register!D73,\" - \",Register!E73))","v":"(empty description)"},"Y",{"$f":"Register!H73","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H73,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H73)","v":{"$error":"#VALUE!"}},{"$f":"Register!I73","v":0},{"$f":"Register!J73","v":0},"Credit",0]
[{"$f":"YEAR(Register!B74)","v":1900},{"$f":"TEXT(Register!B74,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I74+Register!J74","v":0},{"$f":"IF(Register!B74=\"\",\"\",Register!B74)","v":""},{"$f":"IF(Register!F74=\"\",\"(blank line)\",Register!F74)","v":"(blank line)"},{"$f":"Register!C74","v":"00:00:00"},{"$f":"IF(Register!D74=\"\",IF(Register!E74=\"\",\"(empty description)\",Register!E74),CONCATENATE(Register!D74,\" - \",Register!E74))","v":"(empty description)"},"Y",{"$f":"Register!H74","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H74,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H74)","v":{"$error":"#VALUE!"}},{"$f":"Register!I74","v":0},{"$f":"Register!J74","v":0},"Credit",0]
[{"$f":"YEAR(Register!B75)","v":1900},{"$f":"TEXT(Register!B75,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I75+Register!J75","v":0},{"$f":"IF(Register!B75=\"\",\"\",Register!B75)","v":""},{"$f":"IF(Register!F75=\"\",\"(blank line)\",Register!F75)","v":"(blank line)"},{"$f":"Register!C75","v":"00:00:00"},{"$f":"IF(Register!D75=\"\",IF(Register!E75=\"\",\"(empty description)\",Register!E75),CONCATENATE(Register!D75,\" - \",Register!E75))","v":"(empty description)"},{"$f":"IF(C69=0,\"Y\",\"N\")","v":"Y"},{"$f":"Register!H75","v":""},{"$f":"L69*100+MONTH(I69)","v":{"$error":"#VALUE!"}},{"$f":"TEXT(Register!H75,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H75)","v":{"$error":"#VALUE!"}},{"$f":"Register!I75","v":0},{"$f":"Register!J75","v":0},{"$f":"IF(M69<0,\"Debit\",\"Credit\")","v":"Credit"},{"$f":"SUMIF(J$4:J$150,\"<\"&J69,C$4:C$150)","v":0}]
[{"$f":"YEAR(Register!B76)","v":1900},{"$f":"TEXT(Register!B76,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I76+Register!J76","v":0},{"$f":"IF(Register!B76=\"\",\"\",Register!B76)","v":""},{"$f":"IF(Register!F76=\"\",\"(blank line)\",Register!F76)","v":"(blank line)"},{"$f":"Register!C76","v":"00:00:00"},{"$f":"IF(Register!D76=\"\",IF(Register!E76=\"\",\"(empty description)\",Register!E76),CONCATENATE(Register!D76,\" - \",Register!E76))","v":"(empty description)"},"Y",{"$f":"Register!H76","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H76,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H76)","v":{"$error":"#VALUE!"}},{"$f":"Register!I76","v":0},{"$f":"Register!J76","v":0},"Credit",0]
[{"$f":"YEAR(Register!B77)","v":1900},{"$f":"TEXT(Register!B77,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I77+Register!J77","v":0},{"$f":"IF(Register!B77=\"\",\"\",Register!B77)","v":""},{"$f":"IF(Register!F77=\"\",\"(blank line)\",Register!F77)","v":"(blank line)"},{"$f":"Register!C77","v":"00:00:00"},{"$f":"IF(Register!D77=\"\",IF(Register!E77=\"\",\"(empty description)\",Register!E77),CONCATENATE(Register!D77,\" - \",Register!E77))","v":"(empty description)"},"Y",{"$f":"Register!H77","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H77,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H77)","v":{"$error":"#VALUE!"}},{"$f":"Register!I77","v":0},{"$f":"Register!J77","v":0},"Credit",0]
[{"$f":"YEAR(Register!B78)","v":1900},{"$f":"TEXT(Register!B78,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I78+Register!J78","v":0},{"$f":"IF(Register!B78=\"\",\"\",Register!B78)","v":""},{"$f":"IF(Register!F78=\"\",\"(blank line)\",Register!F78)","v":"(blank line)"},{"$f":"Register!C78","v":"00:00:00"},{"$f":"IF(Register!D78=\"\",IF(Register!E78=\"\",\"(empty description)\",Register!E78),CONCATENATE(Register!D78,\" - \",Register!E78))","v":"(empty description)"},"Y",{"$f":"Register!H78","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H78,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H78)","v":{"$error":"#VALUE!"}},{"$f":"Register!I78","v":0},{"$f":"Register!J78","v":0},"Credit",0]
[{"$f":"YEAR(Register!B79)","v":1900},{"$f":"TEXT(Register!B79,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I79+Register!J79","v":0},{"$f":"IF(Register!B79=\"\",\"\",Register!B79)","v":""},{"$f":"IF(Register!F79=\"\",\"(blank line)\",Register!F79)","v":"(blank line)"},{"$f":"Register!C79","v":"00:00:00"},{"$f":"IF(Register!D79=\"\",IF(Register!E79=\"\",\"(empty description)\",Register!E79),CONCATENATE(Register!D79,\" - \",Register!E79))","v":"(empty description)"},"Y",{"$f":"Register!H79","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H79,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H79)","v":{"$error":"#VALUE!"}},{"$f":"Register!I79","v":0},{"$f":"Register!J79","v":0},"Credit",0]
[{"$f":"YEAR(Register!B80)","v":1900},{"$f":"TEXT(Register!B80,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I80+Register!J80","v":0},{"$f":"IF(Register!B80=\"\",\"\",Register!B80)","v":""},{"$f":"IF(Register!F80=\"\",\"(blank line)\",Register!F80)","v":"(blank line)"},{"$f":"Register!C80","v":"00:00:00"},{"$f":"IF(Register!D80=\"\",IF(Register!E80=\"\",\"(empty description)\",Register!E80),CONCATENATE(Register!D80,\" - \",Register!E80))","v":"(empty description)"},"Y",{"$f":"Register!H80","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H80,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H80)","v":{"$error":"#VALUE!"}},{"$f":"Register!I80","v":0},{"$f":"Register!J80","v":0},"Credit",0]
[{"$f":"YEAR(Register!B81)","v":1900},{"$f":"TEXT(Register!B81,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I81+Register!J81","v":0},{"$f":"IF(Register!B81=\"\",\"\",Register!B81)","v":""},{"$f":"IF(Register!F81=\"\",\"(blank line)\",Register!F81)","v":"(blank line)"},{"$f":"Register!C81","v":"00:00:00"},{"$f":"IF(Register!D81=\"\",IF(Register!E81=\"\",\"(empty description)\",Register!E81),CONCATENATE(Register!D81,\" - \",Register!E81))","v":"(empty description)"},"Y",{"$f":"Register!H81","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H81,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H81)","v":{"$error":"#VALUE!"}},{"$f":"Register!I81","v":0},{"$f":"Register!J81","v":0},"Credit",0]
[{"$f":"YEAR(Register!B82)","v":1900},{"$f":"TEXT(Register!B82,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I82+Register!J82","v":0},{"$f":"IF(Register!B82=\"\",\"\",Register!B82)","v":""},{"$f":"IF(Register!F82=\"\",\"(blank line)\",Register!F82)","v":"(blank line)"},{"$f":"Register!C82","v":"00:00:00"},{"$f":"IF(Register!D82=\"\",IF(Register!E82=\"\",\"(empty description)\",Register!E82),CONCATENATE(Register!D82,\" - \",Register!E82))","v":"(empty description)"},"Y",{"$f":"Register!H82","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H82,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H82)","v":{"$error":"#VALUE!"}},{"$f":"Register!I82","v":0},{"$f":"Register!J82","v":0},"Credit",0]
[{"$f":"YEAR(Register!B83)","v":1900},{"$f":"TEXT(Register!B83,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I83+Register!J83","v":0},{"$f":"IF(Register!B83=\"\",\"\",Register!B83)","v":""},{"$f":"IF(Register!F83=\"\",\"(blank line)\",Register!F83)","v":"(blank line)"},{"$f":"Register!C83","v":"00:00:00"},{"$f":"IF(Register!D83=\"\",IF(Register!E83=\"\",\"(empty description)\",Register!E83),CONCATENATE(Register!D83,\" - \",Register!E83))","v":"(empty description)"},"Y",{"$f":"Register!H83","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H83,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H83)","v":{"$error":"#VALUE!"}},{"$f":"Register!I83","v":0},{"$f":"Register!J83","v":0},"Credit",0]
[{"$f":"YEAR(Register!B84)","v":1900},{"$f":"TEXT(Register!B84,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I84+Register!J84","v":0},{"$f":"IF(Register!B84=\"\",\"\",Register!B84)","v":""},{"$f":"IF(Register!F84=\"\",\"(blank line)\",Register!F84)","v":"(blank line)"},{"$f":"Register!C84","v":"00:00:00"},{"$f":"IF(Register!D84=\"\",IF(Register!E84=\"\",\"(empty description)\",Register!E84),CONCATENATE(Register!D84,\" - \",Register!E84))","v":"(empty description)"},"Y",{"$f":"Register!H84","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H84,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H84)","v":{"$error":"#VALUE!"}},{"$f":"Register!I84","v":0},{"$f":"Register!J84","v":0},"Credit",0]
[{"$f":"YEAR(Register!B85)","v":1900},{"$f":"TEXT(Register!B85,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I85+Register!J85","v":0},{"$f":"IF(Register!B85=\"\",\"\",Register!B85)","v":""},{"$f":"IF(Register!F85=\"\",\"(blank line)\",Register!F85)","v":"(blank line)"},{"$f":"Register!C85","v":"00:00:00"},{"$f":"IF(Register!D85=\"\",IF(Register!E85=\"\",\"(empty description)\",Register!E85),CONCATENATE(Register!D85,\" - \",Register!E85))","v":"(empty description)"},"Y",{"$f":"Register!H85","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H85,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H85)","v":{"$error":"#VALUE!"}},{"$f":"Register!I85","v":0},{"$f":"Register!J85","v":0},"Credit",0]
[{"$f":"YEAR(Register!B86)","v":1900},{"$f":"TEXT(Register!B86,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I86+Register!J86","v":0},{"$f":"IF(Register!B86=\"\",\"\",Register!B86)","v":""},{"$f":"IF(Register!F86=\"\",\"(blank line)\",Register!F86)","v":"(blank line)"},{"$f":"Register!C86","v":"00:00:00"},{"$f":"IF(Register!D86=\"\",IF(Register!E86=\"\",\"(empty description)\",Register!E86),CONCATENATE(Register!D86,\" - \",Register!E86))","v":"(empty description)"},"Y",{"$f":"Register!H86","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H86,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H86)","v":{"$error":"#VALUE!"}},{"$f":"Register!I86","v":0},{"$f":"Register!J86","v":0},"Credit",0]
[{"$f":"YEAR(Register!B87)","v":1900},{"$f":"TEXT(Register!B87,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I87+Register!J87","v":0},{"$f":"IF(Register!B87=\"\",\"\",Register!B87)","v":""},{"$f":"IF(Register!F87=\"\",\"(blank line)\",Register!F87)","v":"(blank line)"},{"$f":"Register!C87","v":"00:00:00"},{"$f":"IF(Register!D87=\"\",IF(Register!E87=\"\",\"(empty description)\",Register!E87),CONCATENATE(Register!D87,\" - \",Register!E87))","v":"(empty description)"},"Y",{"$f":"Register!H87","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H87,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H87)","v":{"$error":"#VALUE!"}},{"$f":"Register!I87","v":0},{"$f":"Register!J87","v":0},"Credit",0]
[{"$f":"YEAR(Register!B88)","v":1900},{"$f":"TEXT(Register!B88,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I88+Register!J88","v":0},{"$f":"IF(Register!B88=\"\",\"\",Register!B88)","v":""},{"$f":"IF(Register!F88=\"\",\"(blank line)\",Register!F88)","v":"(blank line)"},{"$f":"Register!C88","v":"00:00:00"},{"$f":"IF(Register!D88=\"\",IF(Register!E88=\"\",\"(empty description)\",Register!E88),CONCATENATE(Register!D88,\" - \",Register!E88))","v":"(empty description)"},"Y",{"$f":"Register!H88","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H88,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H88)","v":{"$error":"#VALUE!"}},{"$f":"Register!I88","v":0},{"$f":"Register!J88","v":0},"Credit",0]
[{"$f":"YEAR(Register!B89)","v":1900},{"$f":"TEXT(Register!B89,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I89+Register!J89","v":0},{"$f":"IF(Register!B89=\"\",\"\",Register!B89)","v":""},{"$f":"IF(Register!F89=\"\",\"(blank line)\",Register!F89)","v":"(blank line)"},{"$f":"Register!C89","v":"00:00:00"},{"$f":"IF(Register!D89=\"\",IF(Register!E89=\"\",\"(empty description)\",Register!E89),CONCATENATE(Register!D89,\" - \",Register!E89))","v":"(empty description)"},"Y",{"$f":"Register!H89","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H89,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H89)","v":{"$error":"#VALUE!"}},{"$f":"Register!I89","v":0},{"$f":"Register!J89","v":0},"Credit",0]
[{"$f":"YEAR(Register!B90)","v":1900},{"$f":"TEXT(Register!B90,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I90+Register!J90","v":0},{"$f":"IF(Register!B90=\"\",\"\",Register!B90)","v":""},{"$f":"IF(Register!F90=\"\",\"(blank line)\",Register!F90)","v":"(blank line)"},{"$f":"Register!C90","v":"00:00:00"},{"$f":"IF(Register!D90=\"\",IF(Register!E90=\"\",\"(empty description)\",Register!E90),CONCATENATE(Register!D90,\" - \",Register!E90))","v":"(empty description)"},"Y",{"$f":"Register!H90","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H90,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H90)","v":{"$error":"#VALUE!"}},{"$f":"Register!I90","v":0},{"$f":"Register!J90","v":0},"Credit",0]
[{"$f":"YEAR(Register!B91)","v":1900},{"$f":"TEXT(Register!B91,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I91+Register!J91","v":0},{"$f":"IF(Register!B91=\"\",\"\",Register!B91)","v":""},{"$f":"IF(Register!F91=\"\",\"(blank line)\",Register!F91)","v":"(blank line)"},{"$f":"Register!C91","v":"00:00:00"},{"$f":"IF(Register!D91=\"\",IF(Register!E91=\"\",\"(empty description)\",Register!E91),CONCATENATE(Register!D91,\" - \",Register!E91))","v":"(empty description)"},"Y",{"$f":"Register!H91","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H91,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H91)","v":{"$error":"#VALUE!"}},{"$f":"Register!I91","v":0},{"$f":"Register!J91","v":0},"Credit",0]
[{"$f":"YEAR(Register!B92)","v":1900},{"$f":"TEXT(Register!B92,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I92+Register!J92","v":0},{"$f":"IF(Register!B92=\"\",\"\",Register!B92)","v":""},{"$f":"IF(Register!F92=\"\",\"(blank line)\",Register!F92)","v":"(blank line)"},{"$f":"Register!C92","v":"00:00:00"},{"$f":"IF(Register!D92=\"\",IF(Register!E92=\"\",\"(empty description)\",Register!E92),CONCATENATE(Register!D92,\" - \",Register!E92))","v":"(empty description)"},"Y",{"$f":"Register!H92","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H92,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H92)","v":{"$error":"#VALUE!"}},{"$f":"Register!I92","v":0},{"$f":"Register!J92","v":0},"Credit",0]
[{"$f":"YEAR(Register!B93)","v":1900},{"$f":"TEXT(Register!B93,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I93+Register!J93","v":0},{"$f":"IF(Register!B93=\"\",\"\",Register!B93)","v":""},{"$f":"IF(Register!F93=\"\",\"(blank line)\",Register!F93)","v":"(blank line)"},{"$f":"Register!C93","v":"00:00:00"},{"$f":"IF(Register!D93=\"\",IF(Register!E93=\"\",\"(empty description)\",Register!E93),CONCATENATE(Register!D93,\" - \",Register!E93))","v":"(empty description)"},"Y",{"$f":"Register!H93","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H93,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H93)","v":{"$error":"#VALUE!"}},{"$f":"Register!I93","v":0},{"$f":"Register!J93","v":0},"Credit",0]
[{"$f":"YEAR(Register!B94)","v":1900},{"$f":"TEXT(Register!B94,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I94+Register!J94","v":0},{"$f":"IF(Register!B94=\"\",\"\",Register!B94)","v":""},{"$f":"IF(Register!F94=\"\",\"(blank line)\",Register!F94)","v":"(blank line)"},{"$f":"Register!C94","v":"00:00:00"},{"$f":"IF(Register!D94=\"\",IF(Register!E94=\"\",\"(empty description)\",Register!E94),CONCATENATE(Register!D94,\" - \",Register!E94))","v":"(empty description)"},"Y",{"$f":"Register!H94","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H94,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H94)","v":{"$error":"#VALUE!"}},{"$f":"Register!I94","v":0},{"$f":"Register!J94","v":0},"Credit",0]
[{"$f":"YEAR(Register!B95)","v":1900},{"$f":"TEXT(Register!B95,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I95+Register!J95","v":0},{"$f":"IF(Register!B95=\"\",\"\",Register!B95)","v":""},{"$f":"IF(Register!F95=\"\",\"(blank line)\",Register!F95)","v":"(blank line)"},{"$f":"Register!C95","v":"00:00:00"},{"$f":"IF(Register!D95=\"\",IF(Register!E95=\"\",\"(empty description)\",Register!E95),CONCATENATE(Register!D95,\" - \",Register!E95))","v":"(empty description)"},"Y",{"$f":"Register!H95","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H95,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H95)","v":{"$error":"#VALUE!"}},{"$f":"Register!I95","v":0},{"$f":"Register!J95","v":0},"Credit",0]
[{"$f":"YEAR(Register!B96)","v":1900},{"$f":"TEXT(Register!B96,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I96+Register!J96","v":0},{"$f":"IF(Register!B96=\"\",\"\",Register!B96)","v":""},{"$f":"IF(Register!F96=\"\",\"(blank line)\",Register!F96)","v":"(blank line)"},{"$f":"Register!C96","v":"00:00:00"},{"$f":"IF(Register!D96=\"\",IF(Register!E96=\"\",\"(empty description)\",Register!E96),CONCATENATE(Register!D96,\" - \",Register!E96))","v":"(empty description)"},"Y",{"$f":"Register!H96","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H96,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H96)","v":{"$error":"#VALUE!"}},{"$f":"Register!I96","v":0},{"$f":"Register!J96","v":0},"Credit",0]
[{"$f":"YEAR(Register!B97)","v":1900},{"$f":"TEXT(Register!B97,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I97+Register!J97","v":0},{"$f":"IF(Register!B97=\"\",\"\",Register!B97)","v":""},{"$f":"IF(Register!F97=\"\",\"(blank line)\",Register!F97)","v":"(blank line)"},{"$f":"Register!C97","v":"00:00:00"},{"$f":"IF(Register!D97=\"\",IF(Register!E97=\"\",\"(empty description)\",Register!E97),CONCATENATE(Register!D97,\" - \",Register!E97))","v":"(empty description)"},"Y",{"$f":"Register!H97","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H97,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H97)","v":{"$error":"#VALUE!"}},{"$f":"Register!I97","v":0},{"$f":"Register!J97","v":0},"Credit",0]
[{"$f":"YEAR(Register!B98)","v":1900},{"$f":"TEXT(Register!B98,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I98+Register!J98","v":0},{"$f":"IF(Register!B98=\"\",\"\",Register!B98)","v":""},{"$f":"IF(Register!F98=\"\",\"(blank line)\",Register!F98)","v":"(blank line)"},{"$f":"Register!C98","v":"00:00:00"},{"$f":"IF(Register!D98=\"\",IF(Register!E98=\"\",\"(empty description)\",Register!E98),CONCATENATE(Register!D98,\" - \",Register!E98))","v":"(empty description)"},"Y",{"$f":"Register!H98","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H98,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H98)","v":{"$error":"#VALUE!"}},{"$f":"Register!I98","v":0},{"$f":"Register!J98","v":0},"Credit",0]
[{"$f":"YEAR(Register!B99)","v":1900},{"$f":"TEXT(Register!B99,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I99+Register!J99","v":0},{"$f":"IF(Register!B99=\"\",\"\",Register!B99)","v":""},{"$f":"IF(Register!F99=\"\",\"(blank line)\",Register!F99)","v":"(blank line)"},{"$f":"Register!C99","v":"00:00:00"},{"$f":"IF(Register!D99=\"\",IF(Register!E99=\"\",\"(empty description)\",Register!E99),CONCATENATE(Register!D99,\" - \",Register!E99))","v":"(empty description)"},"Y",{"$f":"Register!H99","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H99,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H99)","v":{"$error":"#VALUE!"}},{"$f":"Register!I99","v":0},{"$f":"Register!J99","v":0},"Credit",0]
[{"$f":"YEAR(Register!B100)","v":1900},{"$f":"TEXT(Register!B100,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I100+Register!J100","v":0},{"$f":"IF(Register!B100=\"\",\"\",Register!B100)","v":""},{"$f":"IF(Register!F100=\"\",\"(blank line)\",Register!F100)","v":"(blank line)"},{"$f":"Register!C100","v":"00:00:00"},{"$f":"IF(Register!D100=\"\",IF(Register!E100=\"\",\"(empty description)\",Register!E100),CONCATENATE(Register!D100,\" - \",Register!E100))","v":"(empty description)"},"Y",{"$f":"Register!H100","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H100,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H100)","v":{"$error":"#VALUE!"}},{"$f":"Register!I100","v":0},{"$f":"Register!J100","v":0},"Credit",0]
[{"$f":"YEAR(Register!B101)","v":1900},{"$f":"TEXT(Register!B101,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I101+Register!J101","v":0},{"$f":"IF(Register!B101=\"\",\"\",Register!B101)","v":""},{"$f":"IF(Register!F101=\"\",\"(blank line)\",Register!F101)","v":"(blank line)"},{"$f":"Register!C101","v":"00:00:00"},{"$f":"IF(Register!D101=\"\",IF(Register!E101=\"\",\"(empty description)\",Register!E101),CONCATENATE(Register!D101,\" - \",Register!E101))","v":"(empty description)"},"Y",{"$f":"Register!H101","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H101,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H101)","v":{"$error":"#VALUE!"}},{"$f":"Register!I101","v":0},{"$f":"Register!J101","v":0},"Credit",0]
[{"$f":"YEAR(Register!B102)","v":1900},{"$f":"TEXT(Register!B102,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I102+Register!J102","v":0},{"$f":"IF(Register!B102=\"\",\"\",Register!B102)","v":""},{"$f":"IF(Register!F102=\"\",\"(blank line)\",Register!F102)","v":"(blank line)"},{"$f":"Register!C102","v":"00:00:00"},{"$f":"IF(Register!D102=\"\",IF(Register!E102=\"\",\"(empty description)\",Register!E102),CONCATENATE(Register!D102,\" - \",Register!E102))","v":"(empty description)"},"Y",{"$f":"Register!H102","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H102,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H102)","v":{"$error":"#VALUE!"}},{"$f":"Register!I102","v":0},{"$f":"Register!J102","v":0},"Credit",0]
[{"$f":"YEAR(Register!B103)","v":1900},{"$f":"TEXT(Register!B103,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I103+Register!J103","v":0},{"$f":"IF(Register!B103=\"\",\"\",Register!B103)","v":""},{"$f":"IF(Register!F103=\"\",\"(blank line)\",Register!F103)","v":"(blank line)"},{"$f":"Register!C103","v":"00:00:00"},{"$f":"IF(Register!D103=\"\",IF(Register!E103=\"\",\"(empty description)\",Register!E103),CONCATENATE(Register!D103,\" - \",Register!E103))","v":"(empty description)"},"Y",{"$f":"Register!H103","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H103,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H103)","v":{"$error":"#VALUE!"}},{"$f":"Register!I103","v":0},{"$f":"Register!J103","v":0},"Credit",0]
[{"$f":"YEAR(Register!B104)","v":1900},{"$f":"TEXT(Register!B104,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I104+Register!J104","v":0},{"$f":"IF(Register!B104=\"\",\"\",Register!B104)","v":""},{"$f":"IF(Register!F104=\"\",\"(blank line)\",Register!F104)","v":"(blank line)"},{"$f":"Register!C104","v":"00:00:00"},{"$f":"IF(Register!D104=\"\",IF(Register!E104=\"\",\"(empty description)\",Register!E104),CONCATENATE(Register!D104,\" - \",Register!E104))","v":"(empty description)"},"Y",{"$f":"Register!H104","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H104,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H104)","v":{"$error":"#VALUE!"}},{"$f":"Register!I104","v":0},{"$f":"Register!J104","v":0},"Credit",0]
[{"$f":"YEAR(Register!B105)","v":1900},{"$f":"TEXT(Register!B105,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I105+Register!J105","v":0},{"$f":"IF(Register!B105=\"\",\"\",Register!B105)","v":""},{"$f":"IF(Register!F105=\"\",\"(blank line)\",Register!F105)","v":"(blank line)"},{"$f":"Register!C105","v":"00:00:00"},{"$f":"IF(Register!D105=\"\",IF(Register!E105=\"\",\"(empty description)\",Register!E105),CONCATENATE(Register!D105,\" - \",Register!E105))","v":"(empty description)"},"Y",{"$f":"Register!H105","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H105,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H105)","v":{"$error":"#VALUE!"}},{"$f":"Register!I105","v":0},{"$f":"Register!J105","v":0},"Credit",0]
[{"$f":"YEAR(Register!B106)","v":1900},{"$f":"TEXT(Register!B106,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I106+Register!J106","v":0},{"$f":"IF(Register!B106=\"\",\"\",Register!B106)","v":""},{"$f":"IF(Register!F106=\"\",\"(blank line)\",Register!F106)","v":"(blank line)"},{"$f":"Register!C106","v":"00:00:00"},{"$f":"IF(Register!D106=\"\",IF(Register!E106=\"\",\"(empty description)\",Register!E106),CONCATENATE(Register!D106,\" - \",Register!E106))","v":"(empty description)"},"Y",{"$f":"Register!H106","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H106,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H106)","v":{"$error":"#VALUE!"}},{"$f":"Register!I106","v":0},{"$f":"Register!J106","v":0},"Credit",0]
[{"$f":"YEAR(Register!B107)","v":1900},{"$f":"TEXT(Register!B107,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I107+Register!J107","v":0},{"$f":"IF(Register!B107=\"\",\"\",Register!B107)","v":""},{"$f":"IF(Register!F107=\"\",\"(blank line)\",Register!F107)","v":"(blank line)"},{"$f":"Register!C107","v":"00:00:00"},{"$f":"IF(Register!D107=\"\",IF(Register!E107=\"\",\"(empty description)\",Register!E107),CONCATENATE(Register!D107,\" - \",Register!E107))","v":"(empty description)"},"Y",{"$f":"Register!H107","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H107,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H107)","v":{"$error":"#VALUE!"}},{"$f":"Register!I107","v":0},{"$f":"Register!J107","v":0},"Credit",0]
[{"$f":"YEAR(Register!B108)","v":1900},{"$f":"TEXT(Register!B108,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I108+Register!J108","v":0},{"$f":"IF(Register!B108=\"\",\"\",Register!B108)","v":""},{"$f":"IF(Register!F108=\"\",\"(blank line)\",Register!F108)","v":"(blank line)"},{"$f":"Register!C108","v":"00:00:00"},{"$f":"IF(Register!D108=\"\",IF(Register!E108=\"\",\"(empty description)\",Register!E108),CONCATENATE(Register!D108,\" - \",Register!E108))","v":"(empty description)"},"Y",{"$f":"Register!H108","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H108,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H108)","v":{"$error":"#VALUE!"}},{"$f":"Register!I108","v":0},{"$f":"Register!J108","v":0},"Credit",0]
[{"$f":"YEAR(Register!B109)","v":1900},{"$f":"TEXT(Register!B109,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I109+Register!J109","v":0},{"$f":"IF(Register!B109=\"\",\"\",Register!B109)","v":""},{"$f":"IF(Register!F109=\"\",\"(blank line)\",Register!F109)","v":"(blank line)"},{"$f":"Register!C109","v":"00:00:00"},{"$f":"IF(Register!D109=\"\",IF(Register!E109=\"\",\"(empty description)\",Register!E109),CONCATENATE(Register!D109,\" - \",Register!E109))","v":"(empty description)"},"Y",{"$f":"Register!H109","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H109,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H109)","v":{"$error":"#VALUE!"}},{"$f":"Register!I109","v":0},{"$f":"Register!J109","v":0},"Credit",0]
[{"$f":"YEAR(Register!B110)","v":1900},{"$f":"TEXT(Register!B110,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I110+Register!J110","v":0},{"$f":"IF(Register!B110=\"\",\"\",Register!B110)","v":""},{"$f":"IF(Register!F110=\"\",\"(blank line)\",Register!F110)","v":"(blank line)"},{"$f":"Register!C110","v":"00:00:00"},{"$f":"IF(Register!D110=\"\",IF(Register!E110=\"\",\"(empty description)\",Register!E110),CONCATENATE(Register!D110,\" - \",Register!E110))","v":"(empty description)"},"Y",{"$f":"Register!H110","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H110,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H110)","v":{"$error":"#VALUE!"}},{"$f":"Register!I110","v":0},{"$f":"Register!J110","v":0},"Credit",0]
[{"$f":"YEAR(Register!B111)","v":1900},{"$f":"TEXT(Register!B111,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I111+Register!J111","v":0},{"$f":"IF(Register!B111=\"\",\"\",Register!B111)","v":""},{"$f":"IF(Register!F111=\"\",\"(blank line)\",Register!F111)","v":"(blank line)"},{"$f":"Register!C111","v":"00:00:00"},{"$f":"IF(Register!D111=\"\",IF(Register!E111=\"\",\"(empty description)\",Register!E111),CONCATENATE(Register!D111,\" - \",Register!E111))","v":"(empty description)"},"Y",{"$f":"Register!H111","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H111,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H111)","v":{"$error":"#VALUE!"}},{"$f":"Register!I111","v":0},{"$f":"Register!J111","v":0},"Credit",0]
[{"$f":"YEAR(Register!B112)","v":1900},{"$f":"TEXT(Register!B112,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I112+Register!J112","v":0},{"$f":"IF(Register!B112=\"\",\"\",Register!B112)","v":""},{"$f":"IF(Register!F112=\"\",\"(blank line)\",Register!F112)","v":"(blank line)"},{"$f":"Register!C112","v":"00:00:00"},{"$f":"IF(Register!D112=\"\",IF(Register!E112=\"\",\"(empty description)\",Register!E112),CONCATENATE(Register!D112,\" - \",Register!E112))","v":"(empty description)"},"Y",{"$f":"Register!H112","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H112,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H112)","v":{"$error":"#VALUE!"}},{"$f":"Register!I112","v":0},{"$f":"Register!J112","v":0},"Credit",0]
[{"$f":"YEAR(Register!B113)","v":1900},{"$f":"TEXT(Register!B113,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I113+Register!J113","v":0},{"$f":"IF(Register!B113=\"\",\"\",Register!B113)","v":""},{"$f":"IF(Register!F113=\"\",\"(blank line)\",Register!F113)","v":"(blank line)"},{"$f":"Register!C113","v":"00:00:00"},{"$f":"IF(Register!D113=\"\",IF(Register!E113=\"\",\"(empty description)\",Register!E113),CONCATENATE(Register!D113,\" - \",Register!E113))","v":"(empty description)"},"Y",{"$f":"Register!H113","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H113,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H113)","v":{"$error":"#VALUE!"}},{"$f":"Register!I113","v":0},{"$f":"Register!J113","v":0},"Credit",0]
[{"$f":"YEAR(Register!B114)","v":1900},{"$f":"TEXT(Register!B114,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I114+Register!J114","v":0},{"$f":"IF(Register!B114=\"\",\"\",Register!B114)","v":""},{"$f":"IF(Register!F114=\"\",\"(blank line)\",Register!F114)","v":"(blank line)"},{"$f":"Register!C114","v":"00:00:00"},{"$f":"IF(Register!D114=\"\",IF(Register!E114=\"\",\"(empty description)\",Register!E114),CONCATENATE(Register!D114,\" - \",Register!E114))","v":"(empty description)"},"Y",{"$f":"Register!H114","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H114,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H114)","v":{"$error":"#VALUE!"}},{"$f":"Register!I114","v":0},{"$f":"Register!J114","v":0},"Credit",0]
[{"$f":"YEAR(Register!B115)","v":1900},{"$f":"TEXT(Register!B115,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I115+Register!J115","v":0},{"$f":"IF(Register!B115=\"\",\"\",Register!B115)","v":""},{"$f":"IF(Register!F115=\"\",\"(blank line)\",Register!F115)","v":"(blank line)"},{"$f":"Register!C115","v":"00:00:00"},{"$f":"IF(Register!D115=\"\",IF(Register!E115=\"\",\"(empty description)\",Register!E115),CONCATENATE(Register!D115,\" - \",Register!E115))","v":"(empty description)"},"Y",{"$f":"Register!H115","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H115,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H115)","v":{"$error":"#VALUE!"}},{"$f":"Register!I115","v":0},{"$f":"Register!J115","v":0},"Credit",0]
[{"$f":"YEAR(Register!B116)","v":1900},{"$f":"TEXT(Register!B116,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I116+Register!J116","v":0},{"$f":"IF(Register!B116=\"\",\"\",Register!B116)","v":""},{"$f":"IF(Register!F116=\"\",\"(blank line)\",Register!F116)","v":"(blank line)"},{"$f":"Register!C116","v":"00:00:00"},{"$f":"IF(Register!D116=\"\",IF(Register!E116=\"\",\"(empty description)\",Register!E116),CONCATENATE(Register!D116,\" - \",Register!E116))","v":"(empty description)"},"Y",{"$f":"Register!H116","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H116,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H116)","v":{"$error":"#VALUE!"}},{"$f":"Register!I116","v":0},{"$f":"Register!J116","v":0},"Credit",0]
[{"$f":"YEAR(Register!B117)","v":1900},{"$f":"TEXT(Register!B117,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I117+Register!J117","v":0},{"$f":"IF(Register!B117=\"\",\"\",Register!B117)","v":""},{"$f":"IF(Register!F117=\"\",\"(blank line)\",Register!F117)","v":"(blank line)"},{"$f":"Register!C117","v":"00:00:00"},{"$f":"IF(Register!D117=\"\",IF(Register!E117=\"\",\"(empty description)\",Register!E117),CONCATENATE(Register!D117,\" - \",Register!E117))","v":"(empty description)"},"Y",{"$f":"Register!H117","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H117,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H117)","v":{"$error":"#VALUE!"}},{"$f":"Register!I117","v":0},{"$f":"Register!J117","v":0},"Credit",0]
[{"$f":"YEAR(Register!B118)","v":1900},{"$f":"TEXT(Register!B118,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I118+Register!J118","v":0},{"$f":"IF(Register!B118=\"\",\"\",Register!B118)","v":""},{"$f":"IF(Register!F118=\"\",\"(blank line)\",Register!F118)","v":"(blank line)"},{"$f":"Register!C118","v":"00:00:00"},{"$f":"IF(Register!D118=\"\",IF(Register!E118=\"\",\"(empty description)\",Register!E118),CONCATENATE(Register!D118,\" - \",Register!E118))","v":"(empty description)"},"Y",{"$f":"Register!H118","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H118,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H118)","v":{"$error":"#VALUE!"}},{"$f":"Register!I118","v":0},{"$f":"Register!J118","v":0},"Credit",0]
[{"$f":"YEAR(Register!B119)","v":1900},{"$f":"TEXT(Register!B119,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I119+Register!J119","v":0},{"$f":"IF(Register!B119=\"\",\"\",Register!B119)","v":""},{"$f":"IF(Register!F119=\"\",\"(blank line)\",Register!F119)","v":"(blank line)"},{"$f":"Register!C119","v":"00:00:00"},{"$f":"IF(Register!D119=\"\",IF(Register!E119=\"\",\"(empty description)\",Register!E119),CONCATENATE(Register!D119,\" - \",Register!E119))","v":"(empty description)"},"Y",{"$f":"Register!H119","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H119,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H119)","v":{"$error":"#VALUE!"}},{"$f":"Register!I119","v":0},{"$f":"Register!J119","v":0},"Credit",0]
[{"$f":"YEAR(Register!B120)","v":1900},{"$f":"TEXT(Register!B120,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I120+Register!J120","v":0},{"$f":"IF(Register!B120=\"\",\"\",Register!B120)","v":""},{"$f":"IF(Register!F120=\"\",\"(blank line)\",Register!F120)","v":"(blank line)"},{"$f":"Register!C120","v":"00:00:00"},{"$f":"IF(Register!D120=\"\",IF(Register!E120=\"\",\"(empty description)\",Register!E120),CONCATENATE(Register!D120,\" - \",Register!E120))","v":"(empty description)"},"Y",{"$f":"Register!H120","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H120,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H120)","v":{"$error":"#VALUE!"}},{"$f":"Register!I120","v":0},{"$f":"Register!J120","v":0},"Credit",0]
[{"$f":"YEAR(Register!B121)","v":1900},{"$f":"TEXT(Register!B121,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I121+Register!J121","v":0},{"$f":"IF(Register!B121=\"\",\"\",Register!B121)","v":""},{"$f":"IF(Register!F121=\"\",\"(blank line)\",Register!F121)","v":"(blank line)"},{"$f":"Register!C121","v":"00:00:00"},{"$f":"IF(Register!D121=\"\",IF(Register!E121=\"\",\"(empty description)\",Register!E121),CONCATENATE(Register!D121,\" - \",Register!E121))","v":"(empty description)"},"Y",{"$f":"Register!H121","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H121,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H121)","v":{"$error":"#VALUE!"}},{"$f":"Register!I121","v":0},{"$f":"Register!J121","v":0},"Credit",0]
[{"$f":"YEAR(Register!B122)","v":1900},{"$f":"TEXT(Register!B122,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I122+Register!J122","v":0},{"$f":"IF(Register!B122=\"\",\"\",Register!B122)","v":""},{"$f":"IF(Register!F122=\"\",\"(blank line)\",Register!F122)","v":"(blank line)"},{"$f":"Register!C122","v":"00:00:00"},{"$f":"IF(Register!D122=\"\",IF(Register!E122=\"\",\"(empty description)\",Register!E122),CONCATENATE(Register!D122,\" - \",Register!E122))","v":"(empty description)"},"Y",{"$f":"Register!H122","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H122,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H122)","v":{"$error":"#VALUE!"}},{"$f":"Register!I122","v":0},{"$f":"Register!J122","v":0},"Credit",0]
[{"$f":"YEAR(Register!B123)","v":1900},{"$f":"TEXT(Register!B123,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I123+Register!J123","v":0},{"$f":"IF(Register!B123=\"\",\"\",Register!B123)","v":""},{"$f":"IF(Register!F123=\"\",\"(blank line)\",Register!F123)","v":"(blank line)"},{"$f":"Register!C123","v":"00:00:00"},{"$f":"IF(Register!D123=\"\",IF(Register!E123=\"\",\"(empty description)\",Register!E123),CONCATENATE(Register!D123,\" - \",Register!E123))","v":"(empty description)"},"Y",{"$f":"Register!H123","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H123,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H123)","v":{"$error":"#VALUE!"}},{"$f":"Register!I123","v":0},{"$f":"Register!J123","v":0},"Credit",0]
[{"$f":"YEAR(Register!B124)","v":1900},{"$f":"TEXT(Register!B124,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I124+Register!J124","v":0},{"$f":"IF(Register!B124=\"\",\"\",Register!B124)","v":""},{"$f":"IF(Register!F124=\"\",\"(blank line)\",Register!F124)","v":"(blank line)"},{"$f":"Register!C124","v":"00:00:00"},{"$f":"IF(Register!D124=\"\",IF(Register!E124=\"\",\"(empty description)\",Register!E124),CONCATENATE(Register!D124,\" - \",Register!E124))","v":"(empty description)"},"Y",{"$f":"Register!H124","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H124,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H124)","v":{"$error":"#VALUE!"}},{"$f":"Register!I124","v":0},{"$f":"Register!J124","v":0},"Credit",0]
[{"$f":"YEAR(Register!B125)","v":1900},{"$f":"TEXT(Register!B125,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I125+Register!J125","v":0},{"$f":"IF(Register!B125=\"\",\"\",Register!B125)","v":""},{"$f":"IF(Register!F125=\"\",\"(blank line)\",Register!F125)","v":"(blank line)"},{"$f":"Register!C125","v":"00:00:00"},{"$f":"IF(Register!D125=\"\",IF(Register!E125=\"\",\"(empty description)\",Register!E125),CONCATENATE(Register!D125,\" - \",Register!E125))","v":"(empty description)"},"Y",{"$f":"Register!H125","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H125,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H125)","v":{"$error":"#VALUE!"}},{"$f":"Register!I125","v":0},{"$f":"Register!J125","v":0},"Credit",0]
[{"$f":"YEAR(Register!B126)","v":1900},{"$f":"TEXT(Register!B126,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I126+Register!J126","v":0},{"$f":"IF(Register!B126=\"\",\"\",Register!B126)","v":""},{"$f":"IF(Register!F126=\"\",\"(blank line)\",Register!F126)","v":"(blank line)"},{"$f":"Register!C126","v":"00:00:00"},{"$f":"IF(Register!D126=\"\",IF(Register!E126=\"\",\"(empty description)\",Register!E126),CONCATENATE(Register!D126,\" - \",Register!E126))","v":"(empty description)"},"Y",{"$f":"Register!H126","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H126,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H126)","v":{"$error":"#VALUE!"}},{"$f":"Register!I126","v":0},{"$f":"Register!J126","v":0},"Credit",0]
[{"$f":"YEAR(Register!B127)","v":1900},{"$f":"TEXT(Register!B127,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I127+Register!J127","v":0},{"$f":"IF(Register!B127=\"\",\"\",Register!B127)","v":""},{"$f":"IF(Register!F127=\"\",\"(blank line)\",Register!F127)","v":"(blank line)"},{"$f":"Register!C127","v":"00:00:00"},{"$f":"IF(Register!D127=\"\",IF(Register!E127=\"\",\"(empty description)\",Register!E127),CONCATENATE(Register!D127,\" - \",Register!E127))","v":"(empty description)"},"Y",{"$f":"Register!H127","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H127,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H127)","v":{"$error":"#VALUE!"}},{"$f":"Register!I127","v":0},{"$f":"Register!J127","v":0},"Credit",0]
[{"$f":"YEAR(Register!B128)","v":1900},{"$f":"TEXT(Register!B128,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I128+Register!J128","v":0},{"$f":"IF(Register!B128=\"\",\"\",Register!B128)","v":""},{"$f":"IF(Register!F128=\"\",\"(blank line)\",Register!F128)","v":"(blank line)"},{"$f":"Register!C128","v":"00:00:00"},{"$f":"IF(Register!D128=\"\",IF(Register!E128=\"\",\"(empty description)\",Register!E128),CONCATENATE(Register!D128,\" - \",Register!E128))","v":"(empty description)"},"Y",{"$f":"Register!H128","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H128,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H128)","v":{"$error":"#VALUE!"}},{"$f":"Register!I128","v":0},{"$f":"Register!J128","v":0},"Credit",0]
[{"$f":"YEAR(Register!B129)","v":1900},{"$f":"TEXT(Register!B129,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I129+Register!J129","v":0},{"$f":"IF(Register!B129=\"\",\"\",Register!B129)","v":""},{"$f":"IF(Register!F129=\"\",\"(blank line)\",Register!F129)","v":"(blank line)"},{"$f":"Register!C129","v":"00:00:00"},{"$f":"IF(Register!D129=\"\",IF(Register!E129=\"\",\"(empty description)\",Register!E129),CONCATENATE(Register!D129,\" - \",Register!E129))","v":"(empty description)"},"Y",{"$f":"Register!H129","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H129,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H129)","v":{"$error":"#VALUE!"}},{"$f":"Register!I129","v":0},{"$f":"Register!J129","v":0},"Credit",0]
[{"$f":"YEAR(Register!B130)","v":1900},{"$f":"TEXT(Register!B130,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I130+Register!J130","v":0},{"$f":"IF(Register!B130=\"\",\"\",Register!B130)","v":""},{"$f":"IF(Register!F130=\"\",\"(blank line)\",Register!F130)","v":"(blank line)"},{"$f":"Register!C130","v":"00:00:00"},{"$f":"IF(Register!D130=\"\",IF(Register!E130=\"\",\"(empty description)\",Register!E130),CONCATENATE(Register!D130,\" - \",Register!E130))","v":"(empty description)"},"Y",{"$f":"Register!H130","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H130,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H130)","v":{"$error":"#VALUE!"}},{"$f":"Register!I130","v":0},{"$f":"Register!J130","v":0},"Credit",0]
[{"$f":"YEAR(Register!B131)","v":1900},{"$f":"TEXT(Register!B131,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I131+Register!J131","v":0},{"$f":"IF(Register!B131=\"\",\"\",Register!B131)","v":""},{"$f":"IF(Register!F131=\"\",\"(blank line)\",Register!F131)","v":"(blank line)"},{"$f":"Register!C131","v":"00:00:00"},{"$f":"IF(Register!D131=\"\",IF(Register!E131=\"\",\"(empty description)\",Register!E131),CONCATENATE(Register!D131,\" - \",Register!E131))","v":"(empty description)"},"Y",{"$f":"Register!H131","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H131,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H131)","v":{"$error":"#VALUE!"}},{"$f":"Register!I131","v":0},{"$f":"Register!J131","v":0},"Credit",0]
[{"$f":"YEAR(Register!B132)","v":1900},{"$f":"TEXT(Register!B132,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I132+Register!J132","v":0},{"$f":"IF(Register!B132=\"\",\"\",Register!B132)","v":""},{"$f":"IF(Register!F132=\"\",\"(blank line)\",Register!F132)","v":"(blank line)"},{"$f":"Register!C132","v":"00:00:00"},{"$f":"IF(Register!D132=\"\",IF(Register!E132=\"\",\"(empty description)\",Register!E132),CONCATENATE(Register!D132,\" - \",Register!E132))","v":"(empty description)"},"Y",{"$f":"Register!H132","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H132,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H132)","v":{"$error":"#VALUE!"}},{"$f":"Register!I132","v":0},{"$f":"Register!J132","v":0},"Credit",0]
[{"$f":"YEAR(Register!B133)","v":1900},{"$f":"TEXT(Register!B133,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I133+Register!J133","v":0},{"$f":"IF(Register!B133=\"\",\"\",Register!B133)","v":""},{"$f":"IF(Register!F133=\"\",\"(blank line)\",Register!F133)","v":"(blank line)"},{"$f":"Register!C133","v":"00:00:00"},{"$f":"IF(Register!D133=\"\",IF(Register!E133=\"\",\"(empty description)\",Register!E133),CONCATENATE(Register!D133,\" - \",Register!E133))","v":"(empty description)"},"Y",{"$f":"Register!H133","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H133,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H133)","v":{"$error":"#VALUE!"}},{"$f":"Register!I133","v":0},{"$f":"Register!J133","v":0},"Credit",0]
[{"$f":"YEAR(Register!B134)","v":1900},{"$f":"TEXT(Register!B134,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I134+Register!J134","v":0},{"$f":"IF(Register!B134=\"\",\"\",Register!B134)","v":""},{"$f":"IF(Register!F134=\"\",\"(blank line)\",Register!F134)","v":"(blank line)"},{"$f":"Register!C134","v":"00:00:00"},{"$f":"IF(Register!D134=\"\",IF(Register!E134=\"\",\"(empty description)\",Register!E134),CONCATENATE(Register!D134,\" - \",Register!E134))","v":"(empty description)"},"Y",{"$f":"Register!H134","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H134,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H134)","v":{"$error":"#VALUE!"}},{"$f":"Register!I134","v":0},{"$f":"Register!J134","v":0},"Credit",0]
[{"$f":"YEAR(Register!B135)","v":1900},{"$f":"TEXT(Register!B135,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I135+Register!J135","v":0},{"$f":"IF(Register!B135=\"\",\"\",Register!B135)","v":""},{"$f":"IF(Register!F135=\"\",\"(blank line)\",Register!F135)","v":"(blank line)"},{"$f":"Register!C135","v":"00:00:00"},{"$f":"IF(Register!D135=\"\",IF(Register!E135=\"\",\"(empty description)\",Register!E135),CONCATENATE(Register!D135,\" - \",Register!E135))","v":"(empty description)"},"Y",{"$f":"Register!H135","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H135,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H135)","v":{"$error":"#VALUE!"}},{"$f":"Register!I135","v":0},{"$f":"Register!J135","v":0},"Credit",0]
[{"$f":"YEAR(Register!B136)","v":1900},{"$f":"TEXT(Register!B136,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I136+Register!J136","v":0},{"$f":"IF(Register!B136=\"\",\"\",Register!B136)","v":""},{"$f":"IF(Register!F136=\"\",\"(blank line)\",Register!F136)","v":"(blank line)"},{"$f":"Register!C136","v":"00:00:00"},{"$f":"IF(Register!D136=\"\",IF(Register!E136=\"\",\"(empty description)\",Register!E136),CONCATENATE(Register!D136,\" - \",Register!E136))","v":"(empty description)"},"Y",{"$f":"Register!H136","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H136,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H136)","v":{"$error":"#VALUE!"}},{"$f":"Register!I136","v":0},{"$f":"Register!J136","v":0},"Credit",0]
[{"$f":"YEAR(Register!B137)","v":1900},{"$f":"TEXT(Register!B137,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I137+Register!J137","v":0},{"$f":"IF(Register!B137=\"\",\"\",Register!B137)","v":""},{"$f":"IF(Register!F137=\"\",\"(blank line)\",Register!F137)","v":"(blank line)"},{"$f":"Register!C137","v":"00:00:00"},{"$f":"IF(Register!D137=\"\",IF(Register!E137=\"\",\"(empty description)\",Register!E137),CONCATENATE(Register!D137,\" - \",Register!E137))","v":"(empty description)"},"Y",{"$f":"Register!H137","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H137,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H137)","v":{"$error":"#VALUE!"}},{"$f":"Register!I137","v":0},{"$f":"Register!J137","v":0},"Credit",0]
[{"$f":"YEAR(Register!B138)","v":1900},{"$f":"TEXT(Register!B138,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I138+Register!J138","v":0},{"$f":"IF(Register!B138=\"\",\"\",Register!B138)","v":""},{"$f":"IF(Register!F138=\"\",\"(blank line)\",Register!F138)","v":"(blank line)"},{"$f":"Register!C138","v":"00:00:00"},{"$f":"IF(Register!D138=\"\",IF(Register!E138=\"\",\"(empty description)\",Register!E138),CONCATENATE(Register!D138,\" - \",Register!E138))","v":"(empty description)"},"Y",{"$f":"Register!H138","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H138,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H138)","v":{"$error":"#VALUE!"}},{"$f":"Register!I138","v":0},{"$f":"Register!J138","v":0},"Credit",0]
[{"$f":"YEAR(Register!B139)","v":1900},{"$f":"TEXT(Register!B139,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I139+Register!J139","v":0},{"$f":"IF(Register!B139=\"\",\"\",Register!B139)","v":""},{"$f":"IF(Register!F139=\"\",\"(blank line)\",Register!F139)","v":"(blank line)"},{"$f":"Register!C139","v":"00:00:00"},{"$f":"IF(Register!D139=\"\",IF(Register!E139=\"\",\"(empty description)\",Register!E139),CONCATENATE(Register!D139,\" - \",Register!E139))","v":"(empty description)"},{"$f":"IF(C133=0,\"Y\",\"N\")","v":"Y"},{"$f":"Register!H139","v":""},{"$f":"L133*100+MONTH(I133)","v":{"$error":"#VALUE!"}},{"$f":"TEXT(Register!H139,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H139)","v":{"$error":"#VALUE!"}},{"$f":"Register!I139","v":0},{"$f":"Register!J139","v":0},{"$f":"IF(M133<0,\"Debit\",\"Credit\")","v":"Credit"},{"$f":"SUMIF(J$4:J$150,\"<\"&J133,C$4:C$150)","v":0}]
[{"$f":"YEAR(Register!B140)","v":1900},{"$f":"TEXT(Register!B140,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I140+Register!J140","v":0},{"$f":"IF(Register!B140=\"\",\"\",Register!B140)","v":""},{"$f":"IF(Register!F140=\"\",\"(blank line)\",Register!F140)","v":"(blank line)"},{"$f":"Register!C140","v":"00:00:00"},{"$f":"IF(Register!D140=\"\",IF(Register!E140=\"\",\"(empty description)\",Register!E140),CONCATENATE(Register!D140,\" - \",Register!E140))","v":"(empty description)"},"Y",{"$f":"Register!H140","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H140,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H140)","v":{"$error":"#VALUE!"}},{"$f":"Register!I140","v":0},{"$f":"Register!J140","v":0},"Credit",0]
[{"$f":"YEAR(Register!B141)","v":1900},{"$f":"TEXT(Register!B141,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I141+Register!J141","v":0},{"$f":"IF(Register!B141=\"\",\"\",Register!B141)","v":""},{"$f":"IF(Register!F141=\"\",\"(blank line)\",Register!F141)","v":"(blank line)"},{"$f":"Register!C141","v":"00:00:00"},{"$f":"IF(Register!D141=\"\",IF(Register!E141=\"\",\"(empty description)\",Register!E141),CONCATENATE(Register!D141,\" - \",Register!E141))","v":"(empty description)"},"Y",{"$f":"Register!H141","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H141,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H141)","v":{"$error":"#VALUE!"}},{"$f":"Register!I141","v":0},{"$f":"Register!J141","v":0},"Credit",0]
[{"$f":"YEAR(Register!B142)","v":1900},{"$f":"TEXT(Register!B142,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I142+Register!J142","v":0},{"$f":"IF(Register!B142=\"\",\"\",Register!B142)","v":""},{"$f":"IF(Register!F142=\"\",\"(blank line)\",Register!F142)","v":"(blank line)"},{"$f":"Register!C142","v":"00:00:00"},{"$f":"IF(Register!D142=\"\",IF(Register!E142=\"\",\"(empty description)\",Register!E142),CONCATENATE(Register!D142,\" - \",Register!E142))","v":"(empty description)"},"Y",{"$f":"Register!H142","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H142,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H142)","v":{"$error":"#VALUE!"}},{"$f":"Register!I142","v":0},{"$f":"Register!J142","v":0},"Credit",0]
[{"$f":"YEAR(Register!B143)","v":1900},{"$f":"TEXT(Register!B143,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I143+Register!J143","v":0},{"$f":"IF(Register!B143=\"\",\"\",Register!B143)","v":""},{"$f":"IF(Register!F143=\"\",\"(blank line)\",Register!F143)","v":"(blank line)"},{"$f":"Register!C143","v":"00:00:00"},{"$f":"IF(Register!D143=\"\",IF(Register!E143=\"\",\"(empty description)\",Register!E143),CONCATENATE(Register!D143,\" - \",Register!E143))","v":"(empty description)"},"Y",{"$f":"Register!H143","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H143,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H143)","v":{"$error":"#VALUE!"}},{"$f":"Register!I143","v":0},{"$f":"Register!J143","v":0},"Credit",0]
[{"$f":"YEAR(Register!B144)","v":1900},{"$f":"TEXT(Register!B144,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I144+Register!J144","v":0},{"$f":"IF(Register!B144=\"\",\"\",Register!B144)","v":""},{"$f":"IF(Register!F144=\"\",\"(blank line)\",Register!F144)","v":"(blank line)"},{"$f":"Register!C144","v":"00:00:00"},{"$f":"IF(Register!D144=\"\",IF(Register!E144=\"\",\"(empty description)\",Register!E144),CONCATENATE(Register!D144,\" - \",Register!E144))","v":"(empty description)"},"Y",{"$f":"Register!H144","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H144,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H144)","v":{"$error":"#VALUE!"}},{"$f":"Register!I144","v":0},{"$f":"Register!J144","v":0},"Credit",0]
[{"$f":"YEAR(Register!B145)","v":1900},{"$f":"TEXT(Register!B145,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I145+Register!J145","v":0},{"$f":"IF(Register!B145=\"\",\"\",Register!B145)","v":""},{"$f":"IF(Register!F145=\"\",\"(blank line)\",Register!F145)","v":"(blank line)"},{"$f":"Register!C145","v":"00:00:00"},{"$f":"IF(Register!D145=\"\",IF(Register!E145=\"\",\"(empty description)\",Register!E145),CONCATENATE(Register!D145,\" - \",Register!E145))","v":"(empty description)"},"Y",{"$f":"Register!H145","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H145,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H145)","v":{"$error":"#VALUE!"}},{"$f":"Register!I145","v":0},{"$f":"Register!J145","v":0},"Credit",0]
[{"$f":"YEAR(Register!B146)","v":1900},{"$f":"TEXT(Register!B146,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I146+Register!J146","v":0},{"$f":"IF(Register!B146=\"\",\"\",Register!B146)","v":""},{"$f":"IF(Register!F146=\"\",\"(blank line)\",Register!F146)","v":"(blank line)"},{"$f":"Register!C146","v":"00:00:00"},{"$f":"IF(Register!D146=\"\",IF(Register!E146=\"\",\"(empty description)\",Register!E146),CONCATENATE(Register!D146,\" - \",Register!E146))","v":"(empty description)"},"Y",{"$f":"Register!H146","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H146,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H146)","v":{"$error":"#VALUE!"}},{"$f":"Register!I146","v":0},{"$f":"Register!J146","v":0},"Credit",0]
[{"$f":"YEAR(Register!B147)","v":1900},{"$f":"TEXT(Register!B147,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I147+Register!J147","v":0},{"$f":"IF(Register!B147=\"\",\"\",Register!B147)","v":""},{"$f":"IF(Register!F147=\"\",\"(blank line)\",Register!F147)","v":"(blank line)"},{"$f":"Register!C147","v":"00:00:00"},{"$f":"IF(Register!D147=\"\",IF(Register!E147=\"\",\"(empty description)\",Register!E147),CONCATENATE(Register!D147,\" - \",Register!E147))","v":"(empty description)"},"Y",{"$f":"Register!H147","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H147,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H147)","v":{"$error":"#VALUE!"}},{"$f":"Register!I147","v":0},{"$f":"Register!J147","v":0},"Credit",0]
[{"$f":"YEAR(Register!B148)","v":1900},{"$f":"TEXT(Register!B148,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I148+Register!J148","v":0},{"$f":"IF(Register!B148=\"\",\"\",Register!B148)","v":""},{"$f":"IF(Register!F148=\"\",\"(blank line)\",Register!F148)","v":"(blank line)"},{"$f":"Register!C148","v":"00:00:00"},{"$f":"IF(Register!D148=\"\",IF(Register!E148=\"\",\"(empty description)\",Register!E148),CONCATENATE(Register!D148,\" - \",Register!E148))","v":"(empty description)"},"Y",{"$f":"Register!H148","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H148,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H148)","v":{"$error":"#VALUE!"}},{"$f":"Register!I148","v":0},{"$f":"Register!J148","v":0},"Credit",0]
[{"$f":"YEAR(Register!B149)","v":1900},{"$f":"TEXT(Register!B149,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I149+Register!J149","v":0},{"$f":"IF(Register!B149=\"\",\"\",Register!B149)","v":""},{"$f":"IF(Register!F149=\"\",\"(blank line)\",Register!F149)","v":"(blank line)"},{"$f":"Register!C149","v":"00:00:00"},{"$f":"IF(Register!D149=\"\",IF(Register!E149=\"\",\"(empty description)\",Register!E149),CONCATENATE(Register!D149,\" - \",Register!E149))","v":"(empty description)"},"Y",{"$f":"Register!H149","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H149,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H149)","v":{"$error":"#VALUE!"}},{"$f":"Register!I149","v":0},{"$f":"Register!J149","v":0},"Credit",0]
[{"$f":"YEAR(Register!B150)","v":1900},{"$f":"TEXT(Register!B150,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I150+Register!J150","v":0},{"$f":"IF(Register!B150=\"\",\"\",Register!B150)","v":""},{"$f":"IF(Register!F150=\"\",\"(blank line)\",Register!F150)","v":"(blank line)"},{"$f":"Register!C150","v":"00:00:00"},{"$f":"IF(Register!D150=\"\",IF(Register!E150=\"\",\"(empty description)\",Register!E150),CONCATENATE(Register!D150,\" - \",Register!E150))","v":"(empty description)"},"Y",{"$f":"Register!H150","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H150,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H150)","v":{"$error":"#VALUE!"}},{"$f":"Register!I150","v":0},{"$f":"Register!J150","v":0},"Credit",0]
[{"$f":"YEAR(Register!B151)","v":1900},{"$f":"TEXT(Register!B151,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I151+Register!J151","v":0},{"$f":"IF(Register!B151=\"\",\"\",Register!B151)","v":""},{"$f":"IF(Register!F151=\"\",\"(blank line)\",Register!F151)","v":"(blank line)"},{"$f":"Register!C151","v":"00:00:00"},{"$f":"IF(Register!D151=\"\",IF(Register!E151=\"\",\"(empty description)\",Register!E151),CONCATENATE(Register!D151,\" - \",Register!E151))","v":"(empty description)"},"Y",{"$f":"Register!H151","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H151,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H151)","v":{"$error":"#VALUE!"}},{"$f":"Register!I151","v":0},{"$f":"Register!J151","v":0},"Credit",0]
[{"$f":"YEAR(Register!B152)","v":1900},{"$f":"TEXT(Register!B152,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I152+Register!J152","v":0},{"$f":"IF(Register!B152=\"\",\"\",Register!B152)","v":""},{"$f":"IF(Register!F152=\"\",\"(blank line)\",Register!F152)","v":"(blank line)"},{"$f":"Register!C152","v":"00:00:00"},{"$f":"IF(Register!D152=\"\",IF(Register!E152=\"\",\"(empty description)\",Register!E152),CONCATENATE(Register!D152,\" - \",Register!E152))","v":"(empty description)"},"Y",{"$f":"Register!H152","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H152,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H152)","v":{"$error":"#VALUE!"}},{"$f":"Register!I152","v":0},{"$f":"Register!J152","v":0},"Credit",0]
[{"$f":"YEAR(Register!B153)","v":1900},{"$f":"TEXT(Register!B153,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I153+Register!J153","v":0},{"$f":"IF(Register!B153=\"\",\"\",Register!B153)","v":""},{"$f":"IF(Register!F153=\"\",\"(blank line)\",Register!F153)","v":"(blank line)"},{"$f":"Register!C153","v":"00:00:00"},{"$f":"IF(Register!D153=\"\",IF(Register!E153=\"\",\"(empty description)\",Register!E153),CONCATENATE(Register!D153,\" - \",Register!E153))","v":"(empty description)"},"Y",{"$f":"Register!H153","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H153,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H153)","v":{"$error":"#VALUE!"}},{"$f":"Register!I153","v":0},{"$f":"Register!J153","v":0},"Credit",0]
[{"$f":"YEAR(Register!B154)","v":1900},{"$f":"TEXT(Register!B154,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I154+Register!J154","v":0},{"$f":"IF(Register!B154=\"\",\"\",Register!B154)","v":""},{"$f":"IF(Register!F154=\"\",\"(blank line)\",Register!F154)","v":"(blank line)"},{"$f":"Register!C154","v":"00:00:00"},{"$f":"IF(Register!D154=\"\",IF(Register!E154=\"\",\"(empty description)\",Register!E154),CONCATENATE(Register!D154,\" - \",Register!E154))","v":"(empty description)"},"Y",{"$f":"Register!H154","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H154,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H154)","v":{"$error":"#VALUE!"}},{"$f":"Register!I154","v":0},{"$f":"Register!J154","v":0},"Credit",0]
[{"$f":"YEAR(Register!B155)","v":1900},{"$f":"TEXT(Register!B155,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I155+Register!J155","v":0},{"$f":"IF(Register!B155=\"\",\"\",Register!B155)","v":""},{"$f":"IF(Register!F155=\"\",\"(blank line)\",Register!F155)","v":"(blank line)"},{"$f":"Register!C155","v":"00:00:00"},{"$f":"IF(Register!D155=\"\",IF(Register!E155=\"\",\"(empty description)\",Register!E155),CONCATENATE(Register!D155,\" - \",Register!E155))","v":"(empty description)"},"Y",{"$f":"Register!H155","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H155,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H155)","v":{"$error":"#VALUE!"}},{"$f":"Register!I155","v":0},{"$f":"Register!J155","v":0},"Credit",0]
[{"$f":"YEAR(Register!B156)","v":1900},{"$f":"TEXT(Register!B156,\"mmmm - yy\")","v":"January - 00"},{"$f":"Register!I156+Register!J156","v":0},{"$f":"IF(Register!B156=\"\",\"\",Register!B156)","v":""},{"$f":"IF(Register!F156=\"\",\"(blank line)\",Register!F156)","v":"(blank line)"},{"$f":"Register!C156","v":"00:00:00"},{"$f":"IF(Register!D156=\"\",IF(Register!E156=\"\",\"(empty description)\",Register!E156),CONCATENATE(Register!D156,\" - \",Register!E156))","v":"(empty description)"},"Y",{"$f":"Register!H156","v":""},{"$error":"#VALUE!"},{"$f":"TEXT(Register!H156,\"mmm-yyyy\")","v":""},{"$f":"YEAR(Register!H156)","v":{"$error":"#VALUE!"}},{"$f":"Register!I156","v":0},{"$f":"Register!J156","v":0},"Credit",0]

{"sheet":"Lists","index":5,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Trans_Category",null,"Trans_Type","Days to Clear",null,"Cleared"]
["Bank Fee",null,"ATM Cash",0,null,"Y"]
["Clothing",null,"Auto from Checking",0,null,"N"]
["Deposit",null,"Auto to Savings",0]
["Donations",null,"Bank Fee",0]
["Emergency Fund",null,"Check",5]
["Entertainment",null,"Debit Card",0]
["Groceries",null,"Deposit",0]
["Household stuff",null,"Direct Deposit",0]
["Housing/Rent"]
["Income"]
["Insurance"]
["Loan Payment"]
["Medical"]
["Other"]
["Personal care"]
["Savings"]
["Savings 3-5 year "]
["Transportation"]
["Travel"]
["Utilities"]

{"sheet":"Ver_Notes","index":6,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[]
["v30"," - \"Cleared date\" column is present but hidden in Register"]
["(7/24/2016)"," - Statement no sorts by date asc in the pivot table"]
[]
["v29"," - added instructions page at beginning"]
["(7/22/2016)"," - added instruction to the top of register, statement, budget"]
[null," - updated the VB scripts for the row changes"]
[]
["v28"," - consolidated AddNew and RemoveFalse to CleanUpOverdrafts"]
["(7/17/2016)"," - added \"RefreshBudget\" when clear transactions"]
[]
["v27 "," - added \"data validation\" to the \"Cleared Y or N\" column, based on Y,N list "]
[null," - set \"Cleared Y or N\" to be editable (not locked)"]
[null," - added code to refresh \"Cleared date\" column after AddOverdrafts (sometimes gets messed up)"]
[]
["v26"," - unprotect sheet before disable/enable of row add/remove"]
[]
["v25"," - empty"]
[]
["v24"," - changed OVERDRAFT \"cleared date\" to be the same as the line causing the OVERDRAFT"]
[null," - added numeric month (Clear_M) and Upto_M_Bal  (Balance up to that month)"]
[null," - use above new columns to calculate correct beginning balance for the statements (add up everything from a prevous month)"]
[null," - turned off \"Grand Total\" in statement"]
[null," - removed year filter and changed filter name to \"Statement month\""]
[null," - removed \"Refresh\" button from Statement"]
[null," - Hid \"N\" filter on BudgetViewer page"]
[null," - Removed \"Refresh\" button from BudgetViewer"]
[null," - fixed display of blank desription to \"(empty description)\""]
[null," - fixed to category and type dropdowns"]
[null," - added several categories"]
[null," - \"remove\"  and \"add\" disappear when disabled (columns are hidden)"]

{"sheet":"Statement (Example)","index":7,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[null,"My Personal Bank"]
[]
["Statement","9/1/16 - 9/30/16"]
[]
["Description",null,"Summary Amt."]
["Beginning balance as of 05/18/2011",null,73.06]
["Total credits",null,1900.77]
["Total debits",null,-1301.22]
["Ending balance as of 06/09/2011",null,672.61]
[]
["Date","Description","Amount","Running Bal."]
["2011-05-18","Beginning balance as of 05/18/2011",null,73.06]
["2011-05-18","JPMorgan Chase DES:Ext Trnsfr ID:2065436997 INDN: CO ID:9200",300,373.06]
["2011-05-19","Online Banking transfer to Sav 9648 Confirmation# 4084516884",-150,223.06]
["2011-05-23","Counter Credit",100,323.06]
["2011-05-23","FEDLOANSERVICING DES:STDNT LOAN ID:6ISOS36CR11 INDN:SUE SMITH CO ID:9102",-121.92,201.14]
["2011-05-23","BNP 05/22 #000259807 WITHDRWL 497400MONTPELL MONTPELLIER",-42.81,158.33000000000001]
["2011-05-27","AUTOMATIC TRANSFER TO 9648",-25,133.33000000000001]
["2011-05-31","INTERNATIONAL TE DES:Payroll ID:158785467261860 INDN:O ID:7311",1500.77,1634.1]
["2011-05-31","BNP 05/30 #000960667 WITHDRWL 497400MONTPELL MONTPELLIER",-599.91,1034.19]
["2011-05-31","BNP 05/29 #000548855 WITHDRWL 497400MONTPELL MONTPELLIER",-42.85,991.34]
["2011-06-02","JPMorgan Chase DES:Ext Trnsfr ID:2053489976 INDN: CO ID:9200",-100,891.34]
["2011-06-06","BNP 06/05 #000596655 WITHDRWL 497400MONTPELL MONTPELLIER",-218.73,672.61]

{"sheet":"DeveloperNotes","index":8,"n_rows":45,"n_cols":1,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[]
["Worksheets"]
["Register – Main worksheet to be used by the student."]
["Statement – A “pivot” view of data on the BudgetVwr_Source worksheet, providing a simulated bank statement."]
["BudgetViewer – Also a “pivot” view of data on the BudgetVwr_Source worksheet, providing a display by budget category."]
["BudgetVwr_Source – to be hidden and not visible to the student. This is a copy of the Register with extra columns to keep track of the date the transaction “cleared”. Which can be different from the transaction date."]
["Lists – to be hidden and not visible to the student.  These are the lists used for the dropdowns in Register and the “Days to Clear”.  There is also a “Statement Ranges” list that I had thought of using for the statement, but am using filters on the pivot views instead."]
["Statement (Example) – to be hidden and not visible to the student.  Something I was using to think about how a statement could look."]
["DeveloperNotes - to be hidden and not visible to the student.  Where these notes and others could reside."]
[]
["VBA subroutine notes"]
["Two “Private” subroutines associated with “Sheet1” (Register).  They run automatically and activate on all activity on the page."]
["-          Worksheet_Change  - detects when anything changes in columns I and J (debits and credits).  It then calls the “ProcessOverdrafts” subroutine."]
["-          Worksheet_SelectionChange – detects when the user clicks on the add or remove cells, and calls the corresponding subrouting (AddRow or RemoveRow)"]
["-           "]
["Module1"]
["Sub TurnEventsOn – typically only used during debugging and can be activated from Developer-Macro, to reset the state and have the Excel events “active”."]
[]
["Sub ProcessOverdrafts"]
["-          This is called at the end of any credit or debit cell change, from Worksheet_Change.  It checks for a negative balance in the current row and previous row and adds an overdraft row as necessary.  It also calls the following subroutines at the end – RemoveFalseOverdrafts,  AddNewOverdrafts, UpdateSource, RefreshBudget, and RefreshStatement"]
[]
["Sub RemoveFalseOverdrafts"]
["-          This reverifies all the rows and removes unnecessary overdrafts.  This needs to be called each debit/credit transaction in case the person corrected a value above or below the current row."]
[]
["Sub RemoveAllOverdrafts"]
["-          When the overdraft amound changes, this removes all overdrafts and is followed by a call to AddNewOverdrafts."]
[]
["Sub AddNewOverdrafts"]
["-          This re-verifies all the rows and adds necessary overdrafts.  This needs to be called each debit/credit transaction in case the person corrected a value above or below the current row."]
[]
["Sub AddRow – add a new row above the current row"]
[]
["Sub RemoveRow – delete the current row"]
[]
["Module 2"]
["Sub UpdateSource"]
["– updates the BudgetVwr_Source worksheet."]
[]
["Sub RefreshBudget – refresh the pivot view for the Budget"]
[]
["Sub RefreshStatement – refresh the pivot view for the Statement"]
[]
["Hiding a sheet"]
["http://www.techrepublic.com/blog/microsoft-office/hide-excel-sheets-really-hide-them/"]
["-          Use VB Editor, select the sheet, change Visible property to “2 – xlSheetVeryHidden”"]