{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["A","Expenses","Income"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":37,"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":97,"n_cols":42,"rows_kept":97,"cut":false,"hidden":false,"merged":[[23,35,23,36],[0,32,0,38],[1,32,1,38],[2,32,2,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],[32,9,32,13],[0,0,0,5],[1,0,1,5],[0,15,0,18],[1,15,1,18],[0,24,0,29],[1,24,1,29],[2,0,2,5],[2,20,2,22],[2,24,2,29],[21,32,21,38],[3,20,3,22],[13,20,13,22],[20,32,20,38]],"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 2002",{"$nulls":8},"Calendar Year 2002",{"$nulls":10},"  CRITERIA",null,null,null,"Calendar Year 2002",{"$nulls":7},"December 31, 2002"]
[{"$nulls":20},"Expense Accounts"]
[{"$nulls":15},"ACCOUNTS","ACOUNT #",null,"TYPE",null,"Account","Account","Account",{"$nulls":8},"Previous"]
["Month",{"$nulls":14},"Passbook    #51443-0",161,null,"ECU",null,161,301,300,{"$nulls":8},"Balance","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},9961.05,null,null,795.2099999999991,"     1.  Checking Account #0975 0991",{"$nulls":5},612.6299999999992]
["2002-01-28",null,"Supplemental Health Insurance - AARP","NA",312,122.5,null,null,null,"Check Book Balance - Beginning",null,null,null,795.2099999999991,null,"CD - Mature 8/16/96 #51442 ID 46",164,null,"ECU",null,"Account","Account","Account",{"$nulls":5},10143.63]
[null,null,"Residential Account AANH",1052,300,738.05,{"$nulls":9},"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.:"]
["2002-02-28",null,"Residential Account AANH",1053,300,738.05,null,null,null,"Add:  Receipts",null,null,null,9961.05,null,"Interest",200,null,"Income",{"$nulls":5},"Nursing Home Residence Fee",null,300,null,8118.550000000001,null,"X",1062.21,"     1.  Passbook    #51443-0    Exempt",null,null,null,1077.04]
[null,null,"Supplemental Health Insurance - AARP","NA",312,122.5,{"$nulls":9},"Social Security",201,null,"Income",null,"Account","Account",null,null,"Medication",null,301,null,0,null,"X",6750.54,"     2.  Funeral, Casket, Vault, Trust  #51444-08   Exempt",null,null,null,6848.58]
["2002-03-28",null,"Supplemental Health Insurance - AARP","NA",312,122.5,null,null,null,"Less:  Disbursements",null,null,null,10143.63,null,"Met Life Insurance",202,null,"Income",null,400,308,null,null,"Legal/Accounting Fees",null,305,null,40,null,"X",null,"Total Educator's Credit Union - Racine, Wis.",{"$nulls":5},7925.62]
[null,null,"Residential Account AANH",1054,300,738.05,{"$nulls":9},"Dividends",203,null,"Income",{"$nulls":5},"Guardian/Clerical Fees",null,307,null,537.5799999999999,null,"X"]
["2002-04-28",null,"Supplemental Health Insurance - AARP","NA",312,122.5,null,null,null,"Check Book Balance - Ending (Dec Stmt)",null,null,null,612.6299999999992,null,"Other Income",204,null,"Income",null,"Income Accounts",null,null,null,"Gifts",null,308,null,0,null,"X",null,"Insurance:"]
[null,null,"Residential Account AANH",1055,300,738.05,{"$nulls":9},"Nursing Home Residence Fee",300,null,"Expense",null,"Account","Account","Account",null,"Insurance",null,312,null,1347.5,null,"X",1500,"     Single Premium Whole Life Ins. Policy",{"$nulls":5},1500]
[null,null,"Dawn Jacobson - Annual Report & tax Prep",1056,305,40,null,null,null,"                   DECEMBER BANK STATEMENT",{"$nulls":5},"Medication",301,null,"Expense",null,201,202,204,null,"Miscellaneous",null,400,null,100,null,"X",null,"     Security Insurance Co. - Mpls."]
[null,null,"Ted Jacobson - Expenses Jan-March",1057,307,43.22,null,null,null,"Ending balance on Bank Statement",{"$nulls":5},"Legal/Accounting Fees",305,null,"Expense",{"$nulls":5},"Checking Account #0975 0991",null,190,null,null,10143.63]
[null,null,"AANH - Personal Account",1058,400,50,{"$nulls":9},"Guardian/Clerical Fees",307,null,"Expense",null,"Account",null,null,null,"Checking Account #0975 0991",null,190,null,9961.05,null,null,10107.96,"TOTAL INVENTORY (Assets on Hand)",{"$nulls":5},10038.25,null,"CHECK:  ",-69.70999999999913]
["2002-05-28",null,"Supplemental Health Insurance - AARP","NA",312,122.5,null,null,null,"Add:  Deposits in Transit",null,null,null,0,null,"Gifts",308,null,"Expense",null,161,null,null,null,"Social Security",null,201,null,null,8503,"X",{"$nulls":9},"Profit  ",-69.71000000000095]
[null,null,"Residential Account AANH",1059,300,738.05,{"$nulls":9},"Charitable Contributions",309,null,"Expense",{"$nulls":5},"Met Life Insurance",null,202,null,null,1458.0499999999997,"X",{"$nulls":10},0]
[null,null,"AANH - Personal Account",1060,400,50,null,null,null,"Less:  Checks not yet cancelled at bank",{"$nulls":5},"Medical Expenses",310,null,"Expense",{"$nulls":5},"Passbook    #51443-0",null,161,null,null,0,"X",null,"Income Statement"]
["2002-06-28",null,"Supplemental Health Insurance - AARP","NA",312,122.5,{"$nulls":4},"#",0,null,null,null,"Insurance",312,null,"Expense",{"$nulls":5},"Other Income",null,204,null,null,0,"X",null,"Period Ending:  December 31, 2002"]
[null,null,"Residential Account AANH",1061,300,738.05,{"$nulls":4},"#",0,null,null,null,"Clothing/Makeup Expenses",313,null,"Expense"]
["2002-07-28",null,"Supplemental Health Insurance - AARP","NA",312,122.5,{"$nulls":5},0,null,0,null,"Investment Loss",314,null,"Expense",{"$nulls":5},"Passbook    #51443-0",null,161,null,14.83,null,"X",{"$nulls":4},"Full Year"]
[null,null,"Residential Account AANH",1063,300,738.05,{"$nulls":9},"Miscellaneous",400,null,"Expense",{"$nulls":5},"Funeral, Casket, Vault, Trust  #51444-08",null,162,null,98.04,null,"X",null,"INCOME:",null,null,"$","% Income"]
[null,null,"Ted Jacobson - Expenses Apr-June",1062,307,57.61,null,null,null,"Book Balance",null,null,null,0,{"$nulls":10},"CD - Mature 8/16/96 #51442 ID 46",null,164,null,0,null,"X",null,"Interest",null,null,112.87,0.01120417871096852]
["2002-08-28",null,"Supplemental Health Insurance - AARP","NA",312,122.5,{"$nulls":18},"Interest","(ECU INTEREST)",200,null,null,112.87,"X",null,"Social Security",null,null,8503,0.8440607032813443]
[null,null,"Residential Account AANH",1064,300,738.05,{"$nulls":5},"Check",null,612.63,{"$nulls":18},"Met Life Insurance",null,null,1458.0499999999997,0.14473511800768715]
["2002-09-28",null,"Supplemental Health Insurance - AARP","NA",312,122.5,{"$nulls":18},"Met Life Insurance","March",202,null,null,null,"X",null,"Other Income",null,null,0,0]
[null,null,"Residential Account AANH",1065,300,738.05,{"$nulls":18},"Met Life Insurance","August",202,null,null,null,"X",null,"TOTAL INCOME",null,null,10073.92,1]
["2002-10-28",null,"Supplemental Health Insurance - AARP","NA",312,122.5,{"$nulls":18},"Passbook    #51443-0",null,161,null,0]
[null,null,"Residential Account AANH",1066,300,738.05,null,null,null,"Martha Jacobson Guardianship",{"$nulls":15},"(Deposit to Passbook Account)",{"$nulls":6},"EXPENSES:"]
[null,null,"Ted Jacobson - Expenses July-Sept",1067,307,339.25,null,null,null,"Calendar Year 2002 Summary",{"$nulls":22},"Nursing Home Residence Fee",null,null,8118.550000000001,0.8058978034369938]
["2002-11-28",null,"Supplemental Health Insurance - AARP","NA",312,122.5,{"$nulls":18},"Guardian/Clerical Fees",null,307,null,null,null,"X",null,"Medication",null,null,0,0]
[null,null,"Residential Account AANH",1068,300,738.05,{"$nulls":18},"Legal/Accounting Fees",null,305,null,null,null,"X",null,"Legal/Accounting Fees",null,null,40,0.003970648962866491]
[null,null,"Eau Claire County Finance Dept - Guard Ad Litem",1069,307,97.5,{"$nulls":18},"Met Life Insurance",null,202,null,null,null,"X",null,"Guardian/Clerical Fees",null,null,537.5799999999999,0.05336353673644419]
[{"$nulls":24},"Passbook    #51443-0",null,161,null,null,0,"X",null,"Insurance (Supplementary Health)",null,null,1347.5,0.13376123693656491]
[{"$nulls":4},"TOTAL CASH DISBURSEMENTS   ",10143.63,{"$nulls":19},"(Guardian/Tax Preparation Expenses)",{"$nulls":6},"Gifts",null,null,0,0]
[{"$nulls":9},"Beginning 2002 inventory balance:",null,null,null,10117,{"$nulls":18},"Miscellaneous",null,null,100,0.009926622407166227]
[{"$nulls":28},20217.550000000003,20217.549999999996,null,null,"TOTAL EXPENSES:",null,null,10143.630000000001,1.0069198484800357]
[{"$nulls":9},"Income:",null,null,null,10073.92]
[{"$nulls":27},"Check",0,null,null,null,"INCREASE/(DECREASE)",null,null,-69.71000000000095,-0.006919848480035671]
[{"$nulls":9},"Expenses:",null,null,null,10143.630000000001]
[]
["Martha Jacobson Guardianship",{"$nulls":4}," ",null,null,null,"Ending 2002 inventory balance:",null,null,null,10047.289999999997]
["Receipts",{"$nulls":4}," "]
["Calendar Year 2002",{"$nulls":4}," "]
[]
[]
[]
[]
["Month",null,"Description                ","Account","Total"]
["2002-01-28",null,"Social Security",201,773]
[null,null,"Met Life Insurance",202,132.55]
["2002-02-28",null,"Social Security",201,773]
[null,null,"Met Life Insurance",202,132.55,{"$nulls":18}," "]
["2002-03-28",null,"Social Security",201,773]
[null,null,"Met Life Insurance",202,132.55]
["2002-04-28",null,"Social Security",201,773]
[null,null,"Met Life Insurance",202,132.55]
["2002-05-28",null,"Social Security",201,773]
[null,null,"Met Life Insurance",202,132.55]
["2002-06-28",null,"Social Security",201,773]
[null,null,"Met Life Insurance",202,132.55]
["2002-07-28",null,"Social Security",201,773]
[null,null,"Met Life Insurance",202,132.55]
["2002-08-28",null,"Social Security",201,773,{"$nulls":6},"Check:",null,10038.25]
[null,null,"Met Life Insurance",202,132.55,{"$nulls":8},9.039999999997235]
["2002-09-28",null,"Social Security",201,773]
[null,null,"Met Life Insurance",202,132.55]
["2002-10-28",null,"Social Security",201,773]
[null,null,"Met Life Insurance",202,132.55]
["2002-11-28",null,"Social Security",201,773]
[null,null,"Met Life Insurance",202,132.55]
[]
[null,null,null,"TOTAL CASH RECEIPTS  ",9961.05]
[]
[]
[]
[]
[]
[]
["  \\P:  Reports",null,null,"  \\E:  EXPENSE JOURNAL ENTRY"]
["g:prsSUMM",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":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4]],"flags":["formulas_cached_only"]}
["Martha Jacobson Guardianship"]
["Expenses for Calendar Year 2002"]
[]
[]
[]
[null,"Description                ","Check #","Total"]
["NURSING HOME RESIDENCE FEE (300):"]
[null,"Residential Account AANH - January",1052,738.05]
[null,"Residential Account AANH - February",1053,738.05]
[null,"Residential Account AANH - March",1054,738.05]
[null,"Residential Account AANH - April",1055,738.05]
[null,"Residential Account AANH - May",1059,738.05]
[null,"Residential Account AANH - June",1061,738.05]
[null,"Residential Account AANH - July",1063,738.05]
[null,"Residential Account AANH - August",1064,738.05]
[null,"Residential Account AANH - September",1065,738.05]
[null,"Residential Account AANH - October",1066,738.05]
[null,"Residential Account AANH - November",1068,738.05,8118.550000000001]
["LEGAL/ACCOUNTING FEES (305):"]
[null,"Dawn Jacobson - Annual Report Preparation - April",1056,40,40]
["GUARDIAN/CLERICAL FEES (307):"]
[null,"M & I Bank - Guardian Expenses (Jan-Mar)",1057,43.22]
[null,"M & I Bank - Guardian Expenses (Apr-Jun)",1062,57.61]
[null,"Travel Exp for Funeral Director Visitation",1067,339.25]
[null,"Eau Claire County Finance Dept - Guard Ad Litem",1069,97.5,537.5799999999999]
["INSURANCE (312):"]
[null,"Supplemental Health Insurance - AARP - January","NA",122.5]
[null,"Supplemental Health Insurance - AARP - February","NA",122.5]
[null,"Supplemental Health Insurance - AARP - March","NA",122.5]
[null,"Supplemental Health Insurance - AARP - April","NA",122.5]
[null,"Supplemental Health Insurance - AARP - May","NA",122.5]
[null,"Supplemental Health Insurance - AARP - June","NA",122.5]
[null,"Supplemental Health Insurance - AARP - July","NA",122.5]
[null,"Supplemental Health Insurance - AARP - August","NA",122.5]
[null,"Supplemental Health Insurance - AARP - September","NA",122.5]
[null,"Supplemental Health Insurance - AARP - October","NA",122.5]
[null,"Supplemental Health Insurance - AARP - November","NA",122.5,1347.5]
["MISCELLANEOUS (400):"]
[null,"AANH - Personal Account",1058,50]
[null,"AANH - Personal Account",1060,50,100]
[]
[]
[{"$nulls":4},10143.630000000001]

{"sheet":"Income","index":2,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]],"flags":["formulas_cached_only"]}
["Martha Jacobson Guardianship"]
["Income for Calendar Year 2002"]
[]
[]
[]
[null,"Description                ","Total"]
["INTEREST (200):"]
[null,"ECU Passbook",14.83]
[null,"Funeral, Casket, Vault, Trust  #51444-08",98.04,112.87]
["SOCIAL SECURITY (201):"]
[null,"Social Security - January",773]
[null,"Social Security - February",773]
[null,"Social Security - March",773]
[null,"Social Security - April",773]
[null,"Social Security - May",773]
[null,"Social Security - June",773]
[null,"Social Security - July",773]
[null,"Social Security - August",773]
[null,"Social Security - September",773]
[null,"Social Security - October",773]
[null,"Social Security - November",773,8503]
["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,1458.0499999999997]
[]
[]
[]
[null,null,null,10073.92]