{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["A","Expenses","Income"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":33,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"A","index":0,"n_rows":96,"n_cols":42,"rows_kept":96,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[1,24,1,29],[0,32,0,38],[1,32,1,38],[46,0,46,4],[44,0,44,4],[45,0,45,4],[0,9,0,13],[1,9,1,13],[2,9,2,13],[31,9,31,13],[0,15,0,18],[1,15,1,18],[2,24,2,29],[22,32,22,38],[3,20,3,22],[21,32,21,38],[13,20,13,22],[2,32,2,38],[2,20,2,22],[0,24,0,29]],"flags":["formulas_cached_only"]}
["Martha Jacobson Guardianship",{"$nulls":8},"Martha Jacobson Guardianship",{"$nulls":5},"Martha Jacobson Guardianship",{"$nulls":8},"Martha Jacobson Guardianship",{"$nulls":7},"Martha Jacobson Guardianship"]
["Cash Disbursements",{"$nulls":8},"  Cash Statement",{"$nulls":5}," Chart of Accounts",{"$nulls":8},"Journal Entry",{"$nulls":7},"   Assets on Hand"]
["Calendar Year 1999",{"$nulls":8},"Calendar Year 1999",{"$nulls":10},"  CRITERIA",null,null,null,"Calendar Year 1999",{"$nulls":7},"December 31, 1999"]
[{"$nulls":20},"Expense Accounts"]
[{"$nulls":15},"ACCOUNTS","ACOUNT #",null,"TYPE",null,"Account","Account","Account"]
["Month",{"$nulls":14},"Passbook    #51443-0",161,null,"ECU",null,161,301,300,{"$nulls":8},"Previous","M & I Bank - Racine"]
["Paid",null,"Description                ","Check #","Account","Total",null,null,null,"M & I BANK OF RACINE",{"$nulls":5},"Funeral, Casket, Vault, Trust  #51444-08",162,null,"ECU",{"$nulls":9},9658.63,null,null,"Balance","     1.  Checking Account #0975 0991",{"$nulls":5},506.0599999999995]
["1999-01-28",null,"Supplemental Health Insurance - AARP","NA",312,120,"Jan",null,null,"Check Book Balance - Beginning",null,null,null,768.79,null,"CD - Mature 8/16/96 #51442 ID 46",164,null,"ECU",null,"Account","Account","Account",{"$nulls":5},9921.36,null,null,768.79]
[null,null,"Residential Account AANH",1001,300,686.55,"Jan",{"$nulls":8},"Checking Account #0975 0991",190,null,"M & I Bank",null,305,307,312,null,"Description",null,"     Account #",null,"         Debit","       Credit",null,null,"Educator's Credit Union - Racine, Wis.:"]
["1999-02-28",null,"Residential Account AANH",1002,300,686.55,"Feb",null,null,"Add:  Receipts",null,null,null,9658.63,null,"Interest",200,null,"Income",{"$nulls":5},"Nursing Home Residence Fee",null,300,null,8166.600000000001,null,"X",null,"     1.  Passbook    #51443-0    Exempt",null,null,null,1497.4499999999998]
[null,null,"Supplemental Health Insurance - AARP","NA",312,120,"Feb",{"$nulls":8},"Social Security",201,null,"Income",null,"Account",null,null,null,"Medication",null,301,null,2.03,null,"X",1876.59,"     2.  Funeral, Casket, Vault, Trust  #51444-08   Exempt",null,null,null,6384.13]
["1999-03-28",null,"Supplemental Health Insurance - AARP","NA",312,120,"Mar",null,null,"Less:  Disbursements",null,null,null,9921.359999999999,null,"Met Life Insurance",202,null,"Income",null,400,null,null,null,"Legal/Accounting Fees",null,305,null,142,null,"X",6198.14,"     3.  CD - Mature 8/16/96 #51442 ID 46",null,null,null,0]
[null,null,"Erwin Seehafer - Tax Preparation",1004,305,20,"Apr",{"$nulls":8},"Dividends",203,null,"Income",{"$nulls":5},"Guardian/Clerical Fees",null,307,null,124.73,null,"X",18.59,"Total Educator's Credit Union - Racine, Wis.",{"$nulls":5},7881.58]
[null,null,"Residential Account AANH",1001,300,686.55,"Mar",null,null,"Check Book Balance - Ending (Dec Stmt)",null,null,null,506.0599999999995,null,"Other Income",204,null,"Income",null,"Income Accounts",null,null,null,"Insurance",null,312,null,1440,null,"X"]
["1999-04-28",null,"M & I Bank - Guardian Expenses (Jan-Mar)",1005,307,41.45,"Apr",{"$nulls":8},"Nursing Home Residence Fee",300,null,"Expense",null,"Account","Account","Account",null,"Miscellaneous",null,400,null,46,null,"X",null,"Insurance:"]
[null,null,"Supplemental Health Insurance - AARP","NA",312,120,"Apr",null,null,"                   DECEMBER BANK STATEMENT",{"$nulls":5},"Medication",301,null,"Expense",null,201,202,204,null,"Checking Account #0975 0991",null,190,null,null,9921.359999999999,null,null,"     Single Premium Whole Life Ins. Policy",{"$nulls":5},1500]
[null,null,"Residential Account AANH",1006,300,686.55,"Apr",null,null,"Ending balance on Bank Statement",null,null,null,506.06,null,"Legal/Accounting Fees",305,null,"Expense",{"$nulls":5},"Checking Account #0975 0991",null,190,null,9658.63,null,null,1500,"     Security Insurance Co. - Mpls."]
[null,null,"Personal Account",1007,400,46,"Apr",{"$nulls":8},"Guardian/Clerical Fees",307,null,"Expense",null,"Account",null,null,null,"Social Security",null,201,null,null,7854,"X",{"$nulls":9},"CHECK:  ",-474.47000000000116]
[null,null,"Dawn Jacobson - Annual Report Preparation",1008,305,50,"Apr",null,null,"Add:  Deposits in Transit",null,null,null,0,null,"Gifts",308,null,"Expense",null,161,null,null,null,"Met Life Insurance",null,202,null,null,1458.0499999999997,"X",null,"TOTAL INVENTORY (Assets on Hand)",{"$nulls":5},9887.64,null,"Profit  ",-474.47000000000116]
["1999-05-28",null,"Supplemental Health Insurance - AARP","NA",312,120,"May",{"$nulls":8},"Charitable Contributions",309,null,"Expense",{"$nulls":5},"Passbook    #51443-0",null,161,null,null,233,"X",10362.11,{"$nulls":9},0]
[null,null,"Residential Account AANH",1009,300,686.55,"May",null,null,"Less:  Checks not yet cancelled at bank",{"$nulls":5},"Medical Expenses",310,null,"Expense",{"$nulls":5},"Other Income",null,204,null,null,113.58,"X"]
["1999-06-28",null,"Supplemental Health Insurance - AARP","NA",312,120,"June",null,null,null,"#",0,null,null,null,"Insurance",312,null,"Expense",{"$nulls":13},"Income Statement"]
[null,null,"Residential Account AANH",1010,300,686.55,"June",null,null,null,"#",0,null,null,null,"Clothing/Makeup Expenses",313,null,"Expense",{"$nulls":5},"Passbook    #51443-0",null,161,null,52.800000000000004,null,"X",null,"Period Ending:  December 31, 1999"]
["1999-07-28",null,"Supplemental Health Insurance - AARP","NA",312,120,"July",{"$nulls":4},0,null,0,null,"Investment Loss",314,null,"Expense",{"$nulls":5},"Funeral, Casket, Vault, Trust  #51444-08",null,162,null,185.99,null,"X"]
[null,null,"Residential Account AANH",1011,300,686.55,"July",{"$nulls":8},"Miscellaneous",400,null,"Expense",{"$nulls":5},"CD - Mature 8/16/96 #51442 ID 46",null,164,null,0,null,"X",{"$nulls":4},"Full Year"]
[null,null,"M & I Bank - Guardian Expenses (Apr-June)",1012,307,31.19,"July",null,null,"Book Balance",null,null,null,506.06,{"$nulls":10},"Interest","(ECU INTEREST)",200,null,null,238.79000000000002,"X",null,"INCOME:",null,null,"$","% Income"]
["1999-08-28",null,"Supplemental Health Insurance - AARP","NA",312,120,"Aug",{"$nulls":25},"Interest",null,null,238.79000000000002,0.02437386253096621]
[null,null,"Residential Account AANH",1013,300,686.55,"Aug",{"$nulls":4},"Check",null,0,{"$nulls":10},"Guardian/Clerical Fees",null,307,null,331.49,null,"X",null,"Social Security",null,null,7854,0.8016764366942024]
[null,null,"Shong Drug - Medication/Prescriptions",1014,301,2.03,"Aug",{"$nulls":17},"Met Life Insurance",null,202,null,null,132.55,"X",null,"Met Life Insurance",null,null,1590.5999999999997,0.16235632037252332]
["1999-09-28",null,"Supplemental Health Insurance - AARP","NA",312,120,"Sept",{"$nulls":17},"Passbook    #51443-0",null,161,null,null,198.94,"X",null,"Other Income",null,null,113.58,0.01159338040230806]
[null,null,"Residential Account AANH",1015,300,686.55,"Sept",{"$nulls":25},"TOTAL INCOME",null,null,9796.97,1]
[null,null,"M & I Bank - Guardian Expenses (July-Sept)",1017,307,52.09,"Sept",null,null,"Martha Jacobson Guardianship",{"$nulls":14},"Miscellaneous",null,400,null,18.59,null,"X"]
["1999-10-28",null,"Supplemental Health Insurance - AARP","NA",312,120,"Oct",{"$nulls":17},"CD - Mature 8/16/96 #51442 ID 46",null,164,null,null,18.59,"X",null,"EXPENSES:"]
[null,null,"Residential Account AANH",1016,300,686.55,"Oct",{"$nulls":18},"(Lost Funds)",{"$nulls":6},"Nursing Home Residence Fee",null,null,8166.600000000001,0.8335842612562866]
["1999-11-28",null,"Supplemental Health Insurance - AARP","NA",312,120,"Nov",{"$nulls":25},"Medication",null,null,2.03,0.00020720692214021272]
[null,null,"Residential Account AANH",1019,300,614.55,"Nov",{"$nulls":21},20168.86,20168.86,null,null,"Legal/Accounting Fees",null,null,142,0.01449427731227104]
[null,null,"Eau Claire County Treasury",1018,305,72,"Nov",null,null,"1999 SUMMARY:",{"$nulls":22},"Guardian/Clerical Fees",null,null,456.22,0.04656745912256545]
["1999-12-28",null,"Supplemental Health Insurance - AARP","NA",312,120,"Dec",{"$nulls":20},"Check",0,null,null,null,"Insurance (Supplementary Health)",null,null,1440,0.14698422063148098]
[null,null,"Residential Account AANH",1020,300,686.55,"Dec",null,null,"Beginning 1999 inventory balance:",null,null,null,10362.11,{"$nulls":18},"Miscellaneous",null,null,64.59,0.006592854729574553]
[{"$nulls":32},"TOTAL EXPENSES:",null,null,10271.44,1.0484302799743188]
[{"$nulls":4},"TOTAL CASH DISBURSEMENTS   ",9921.359999999999,null,null,null,"Income:",null,null,null,9796.97]
[{"$nulls":32},"INCREASE/(DECREASE)",null,null,-474.47000000000116,-0.048430279974318716]
[{"$nulls":9},"Expenses:",null,null,null,10271.44]
[]
["Martha Jacobson Guardianship",{"$nulls":4}," ",null,null,null,"Ending 1999 inventory balance:",null,null,null,9887.640000000001]
["Receipts",{"$nulls":4}," "]
["Calendar Year 1999",{"$nulls":4}," "]
[]
[]
[]
[]
["Month",null,"Description                ","Account","Total"]
["1999-01-28",null,"Met Life Insurance",202,132.55,"Jan"]
[null,null,"Deposit from ECU Checking",161,100,"Jan"]
["1999-02-28",null,"Social Security",201,714,"Feb"]
[null,null,"Met Life Insurance",202,132.55,"Feb",{"$nulls":17}," "]
["1999-03-28",null,"Social Security",201,714,"Mar"]
[null,null,"Met Life Insurance",202,132.55,"Mar"]
["1999-04-28",null,"Social Security",201,714,"Apr"]
[null,null,"Met Life Insurance",202,132.55,"Apr"]
["1999-05-28",null,"Social Security",201,714,"May"]
[null,null,"Met Life Insurance",202,132.55,"May"]
["1999-06-28",null,"Social Security",201,714,"June"]
[null,null,"Met Life Insurance",202,132.55,"June"]
["1999-07-28",null,"Social Security",201,714,"July"]
[null,null,"Met Life Insurance",202,132.55,"July",{"$nulls":5},"Check:",null,9887.64]
["1999-08-28",null,"Social Security",201,714,"Aug",{"$nulls":7},0]
[null,null,"Met Life Insurance",202,132.55,"Aug"]
["1999-09-28",null,"Social Security",201,714,"Sept"]
[null,null,"Met Life Insurance",202,132.55,"Sept"]
[null,null,"Deposit from ECU Checking",161,133,"Sept"]
["1999-10-28",null,"Social Security",201,714,"Oct"]
[null,null,"Met Life Insurance",202,132.55,"Nov"]
["1999-11-28",null,"Social Security",201,714,"Nov"]
[null,null,"Met Life Insurance",202,132.55,"Nov"]
["1999-12-28",null,"Social Security",201,714,"Dec"]
[null,null,"Disbursement from Winthrop Hospital Settlement",204,113.58,"Dec"]
[]
[null,null,null,"TOTAL CASH RECEIPTS  ",9658.63]
[]
[]
["  \\P:  Reports",null,null,"  \\E:  EXPENSE JOURNAL ENTRY"]
[":pcopqrsDISB1~g",null,null,"{goto}FORMULA~{down 2}{left 2}"]
[":prsRECEIPTS~g",null,null,"{if @cellpointer(\"contents\")=190}{INCOME}"]
[":prsJOURNAL~g",null,null,"/rv~CRIT#~"]
[":prsBAL_PL~g",null,null,"{right 2}/cFORMULA~~/rf,2~~/rv~~"]
[":pcopqrsACCOUNTS~g",null,null,"{down}{left 2}{REDO}"]
[":prsCASH~g"]
[":prsSUMM~g"]
[]
["INCOME:"]
["{down 2}"]
["{if @cellpointer(\"contents\")=\"             ***\"}{QUIT}"]
["/rv~CRIT#~"]
["{right 3}/cFORMULA2~~/rf,2~~/rv~~"]
["{down}{left 3}{REDO2}"]

{"sheet":"Expenses","index":1,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4]],"flags":["formulas_cached_only"]}
["Martha Jacobson Guardianship"]
["Expenses for Calendar Year 1999"]
[]
[]
[]
[null,"Description                ","Check #","Total"]
["NURSING HOME RESIDENCE FEE (300):"]
[null,"Residential Account AANH - January",1001,686.55]
[null,"Residential Account AANH - February",1002,686.55]
[null,"Residential Account AANH - March",1001,686.55]
[null,"Residential Account AANH - April",1006,686.55]
[null,"Residential Account AANH - May",1009,686.55]
[null,"Residential Account AANH - June",1010,686.55]
[null,"Residential Account AANH - July",1011,686.55]
[null,"Residential Account AANH - August",1013,686.55]
[null,"Residential Account AANH - September",1015,686.55]
[null,"Residential Account AANH - November",1016,686.55]
[null,"Residential Account AANH - November",1019,614.55]
[null,"Residential Account AANH - December",1020,686.55,8166.600000000001]
["MEDICATION (301):"]
[null,"Shong Drug - Medication/Prescriptions - August",1014,2.03,2.03]
["LEGAL/ACCOUNTING FEES (305):"]
[null,"Erwin Seehafer - Tax Preparation - March",1004,20]
[null,"Dawn Jacobson - Annual Report Preparation - April",1008,50]
[null,"Eau Claire County Treasury - November",1018,72,142]
["GUARDIAN/CLERICAL FEES (307):"]
[null,"M & I Bank - Guardian Expenses (Jan-Mar)",1005,41.45]
[null,"M & I Bank - Guardian Expenses (Apr-June)",1012,31.19]
[null,"M & I Bank - Guardian Expenses (July-Sept)",1017,52.09]
[null,"M & I Bank - Guardian Expenses (Oct-Dec)",null,331.49,456.22]
["INSURANCE (312):"]
[null,"Supplemental Health Insurance - AARP - January","NA",120]
[null,"Supplemental Health Insurance - AARP - February","NA",120]
[null,"Supplemental Health Insurance - AARP - March","NA",120]
[null,"Supplemental Health Insurance - AARP - April","NA",120]
[null,"Supplemental Health Insurance - AARP - May","NA",120]
[null,"Supplemental Health Insurance - AARP - June","NA",120]
[null,"Supplemental Health Insurance - AARP - July","NA",120]
[null,"Supplemental Health Insurance - AARP - August","NA",120]
[null,"Supplemental Health Insurance - AARP - September","NA",120]
[null,"Supplemental Health Insurance - AARP - October","NA",120]
[null,"Supplemental Health Insurance - AARP - November","NA",120]
[null,"Supplemental Health Insurance - AARP - December","NA",120,1440]
["MISCELLANEOUS (400):"]
[null,"Personal Account",1007,46]
[null,"Lost Funds",null,18.59,64.59]
[]
[{"$nulls":4},10271.44]

{"sheet":"Income","index":2,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]],"flags":["formulas_cached_only"]}
["Martha Jacobson Guardianship"]
["Income for Calendar Year 1999"]
[]
[]
[]
[null,"Description                ","Total"]
["INTEREST (200):"]
[null,"ECU Passbook",52.8]
[null,"Funeral, Casket, Vault, Trust  #51444-08",185.99,238.79000000000002]
["SOCIAL SECURITY (201):"]
[null,"Social Security - February",714]
[null,"Social Security - March",714]
[null,"Social Security - April",714]
[null,"Social Security - May",714]
[null,"Social Security - June",714]
[null,"Social Security - July",714]
[null,"Social Security - August",714]
[null,"Social Security - September",714]
[null,"Social Security - October",714]
[null,"Social Security - November",714]
[null,"Social Security - December",714,7854]
["MET LIFE INSURANCE (202):"]
[null,"Met Life Insurance - January",132.55]
[null,"Met Life Insurance - February",132.55]
[null,"Met Life Insurance - March",132.55]
[null,"Met Life Insurance - April",132.55]
[null,"Met Life Insurance - May",132.55]
[null,"Met Life Insurance - June",132.55]
[null,"Met Life Insurance - July",132.55]
[null,"Met Life Insurance - August",132.55]
[null,"Met Life Insurance - September",132.55]
[null,"Met Life Insurance - October",132.55]
[null,"Met Life Insurance - November",132.55]
[null,"Met Life Insurance - December",132.55,1590.5999999999997]
["OTHER INCOME (204):"]
[null,"Disbursement from Winthrop Hospital Settlement",113.58,113.58]
[]
[null,null,null,9796.97]