{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["BSheet","ProfitLoss","PartnerBeneDistn","NetActivity","Livestock","Quantities","BankReconcilation","BankStatement","LivestockCalculator"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BSheet","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Balance Sheet"]
[]
["Instant","2015-06-30"]
["Year",2015]
["Current Assets"]
[]
[]
["Add Row Above"]
["Total",{"$f":"SUM(B7:B8)","v":0}]
["Non Current Assets"]
[]
["Add Row Above"]
["Total ",{"$f":"SUM(B11:B12)","v":0}]
["Current Liabilities"]
[]
["Add Row Above"]
["Total ",{"$f":"SUM(B15:B16)","v":0}]
["Non Current Liabilities"]
[]
["Add Row Above"]
["Total ",{"$f":"SUM(B19:B20)","v":0}]
["Equity"]
[]
["Add Row Above"]
["Total ",{"$f":"SUM(B23:B24)","v":0}]
["Net Assets",{"$f":"B9+B13-B17-B21","v":0}]

{"sheet":"ProfitLoss","index":1,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Profit & Loss"]
[]
["From","2014-07-01"]
["To","2015-06-30"]
["Year",2015]
["Income"]
[]
["Add Row Above"]
["Total",{"$f":"SUM(B7:B8)","v":0}]
["Other Income"]
[]
["Add Row Above"]
["Total ",{"$f":"SUM(B11:B12)","v":0}]
["Non Operating Income"]
[]
["Add Row Above"]
["Total ",{"$f":"SUM(B15:B16)","v":0}]
["Cost of Sales"]
[]
["Add Row Above"]
["Total ",{"$f":"SUM(B19:B20)","v":0}]
["Operating Expenses"]
[]
["Add Row Above"]
["Total ",{"$f":"SUM(B23:B24)","v":0}]
["Non Operating Expenses"]
[]
["Add Row Above"]
["Total ",{"$f":"SUM(B27:B28)","v":0}]
["Gross Profit",{"$f":"B9-B21","v":0}]
["Operating Profit",{"$f":"B30+B13-B25","v":0}]
["Net Profit (Accounting)",{"$f":"B9+B13+B17-B21-B25-B29","v":0}]

{"sheet":"PartnerBeneDistn","index":2,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Profit Distribution","XML","Actual","Required"]
[null,"Output","Expected","Adjustment"]
["Instant","2015-06-30",{"$f":"B3","v":"2015-06-30"},{"$f":"B3","v":"2015-06-30"}]
["Partners"]
["Andrew Noble",0]
["Linda Noble",0]
[]
["Total",{"$f":"SUM(B5:B6)","v":0},{"$f":"SUM(C5:C6)","v":0},{"$f":"B8-C8","v":0}]
["Andrew Noble"]
["Opening Balance",0]
["Capital Introduced",0]
["Share of Profit",{"$f":"B5","v":0}]
["Drawing",0]
["Closing Balance",{"$f":"SUM(B9:B13)","v":0},null,{"$f":"B14-C14","v":0}]
["Linda Noble"]
["Opening Balance",0]
["Capital Introduced",0]
["Share of Profit",{"$f":"B6","v":0}]
["Drawing",0]
["Closing Balance",{"$f":"SUM(B15:B19)","v":0},null,{"$f":"B20-C20","v":0}]

{"sheet":"NetActivity","index":3,"n_rows":55,"n_cols":2,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["General Ledger"]
[]
["From","2014-07-01"]
["To","2015-06-30"]
["Year",2015]
["Current Assets"]
["Some current asset",2]
["Add Row Above"]
["Total",{"$f":"SUM(B7:B8)","v":2}]
["Non Current Assets"]
["Some non current asset",1]
["Add Row Above"]
["Total ",{"$f":"SUM(B11:B12)","v":1}]
["Current Liabilities"]
["Some current liability",-1]
["Add Row Above"]
["Total ",{"$f":"SUM(B15:B16)","v":-1}]
["Non Current Liabilities"]
["Some non current liability",-1]
["Add Row Above"]
["Total ",{"$f":"SUM(B19:B20)","v":-1}]
["Equity"]
["Some equity",-1]
["Add Row Above"]
["Total ",{"$f":"SUM(B23:B24)","v":-1}]
["Income"]
["Some trading income",-6]
["Add Row Above"]
["Total",{"$f":"SUM(B27:B28)","v":-6}]
["Other Income"]
["Some other income",-1]
["Add Row Above"]
["Total ",{"$f":"SUM(B31:B32)","v":-1}]
["Non Operating Income"]
["Some non operating income",2]
["Add Row Above"]
["Total ",{"$f":"SUM(B35:B36)","v":2}]
["Cost of Sales"]
["Some cost of sales",2]
["Add Row Above"]
["Total ",{"$f":"SUM(B39:B40)","v":2}]
["Operating Expenses"]
["Some indirect operating expense",1]
["Add Row Above"]
["Total ",{"$f":"SUM(B43:B44)","v":1}]
["Non Operating Expenses"]
["Some non operating expense",1]
["Add Row Above"]
["Total ",{"$f":"SUM(B47:B48)","v":1}]
["Unclassified"]
["Some unclassified",1]
["Add Row Above"]
["Total ",{"$f":"SUM(B51:B52)","v":1}]
[]
["Total Test",{"$f":"B9+B13+B17+B21+B25+B29+B33+B41+B45+B49+B37+B53","v":0}]

{"sheet":"Livestock","index":4,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["LiveStock"]
[]
["From",null,"2013-07-01"]
["To",null,"2014-06-30"]
["Year","No",2014]
["Cattle"]
["Opening Stock",1306,13974]
["Purchases",5,1750]
["Natural Increase",425]
["Sales",361,16543]
["Rations",10,107]
["Deaths - Sheep",152,0]
["Closing Stock",1213,10990]
["Net Profit",null,{"$f":"SUM(C10:C13)-SUM(C7:C9)","v":11916}]
["Sheep"]
["Opening Stock",1306,13974]
["Purchases",5,1750]
["Natural Increase",425]
["Sales",361,16543]
["Rations",10,107]
["Deaths - Sheep",152,0]
["Closing Stock",1306,10990]
["Net Profit",null,{"$f":"SUM(C19:C22)-SUM(C16:C18)","v":11916}]

{"sheet":"Quantities","index":5,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Generic Quantities"]
[]
["Date","2015-06-30"]
["Quantities"]
["Name","Tag","Change Method","Currency","Field Location","Unit","Unit Value","Quantity","Classified"]
["some generic quantity",null,null,"AUD",null,1,1,1]

{"sheet":"BankReconcilation","index":6,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Bank Reconcilation"]
[]
["Instant","2015-06-30"]
["Bank Account Number",56778855]
["Bank Account Name","Andrew Noble"]
["Bank Account BSB"]
["Bank Balance Per General Ledger",100]
["Computed Bank Statement Balance",{"$f":"B7+B9-B10","v":-1144.45}]
["Outstanding Payments",{"$f":"D16","v":255.55}]
["Outstanding Deposits",{"$f":"C21","v":1500}]
["Transaction ID","Description","Deposit","Payment","Date"]
["Outstanding Payments"]
["Chq005200","Payment to Supplier X",0,105,"2015-06-30"]
["Tfer201","Telstra",0,150.55000000000001]
["Add Row Above"]
["Total ",null,{"$f":"SUM(C13:C15)","v":0},{"$f":"SUM(D13:D15)","v":255.55}]
["Outstanding Deposits"]
["CustomerX","Deposit",500,0,"2015-06-28"]
["Batch 504","Deposit",1000,0,"2015-05-20"]
["Add Row Above"]
["Total ",null,{"$f":"SUM(C18:C20)","v":1500},{"$f":"SUM(D18:D20)","v":0}]

{"sheet":"BankStatement","index":7,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Bank Statement"]
[]
["Instant","2015-06-30"]
["Bank Account Number",56778855]
["Bank Account Name","Andrew Noble"]
["Bank Account BSB"]
["Bank Balance Per Bank Statement",12354]

{"sheet":"LivestockCalculator","index":8,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Livestock Account"]
[]
["From","2014-07-01"]
["To","2015-06-30"]
["Year",2015]
["Livestock Account Description","Cattle"]
["Include value for natural increase $",20]
[null,"Number","$"]
["Gross Sales",6,7663]
["Killed for rations or exchanged for goods",10,{"$f":"B10*C19","v":383.25},"(Average Cost * # taken for rations)"]
["Stock on hand at end of year",24,{"$f":"C19*B11","v":919.80000000000007},"(Closing stock on hand = Closing #*Average Cost)"]
["Losses by death",0]
["Sub-total",{"$f":"SUM(B9:B11)-B12","v":40},{"$f":"SUM(C9:C11)","v":8966.0499999999993}]
["Less:"]
["Stock on hand at beginning of year",25,1233]
["Purchases - at cost",0,0]
["Natural increase",15,0,{"$f":"B17*B7","v":300},"(Natural Increase Value)"]
["Sub-total",{"$f":"SUM(B15:B17)","v":40},{"$f":"SUM(C15:C16)","v":1233},{"$f":"C18+D17","v":1533},"(Natural Increase + Purchases + Opening Stock)"]
["Averate cost",null,{"$f":"D18/B18","v":38.325000000000003},"(Average cost = (Opening Stock + Purchases + Natural Increase (Natural Inc # * $/Natural Increase)/(#Opening +#Purchase+#Natural Increase)"]
[]
["Revenue",null,{"$f":"C9+C10","v":8046.25}]
["Livestock COGS",null,{"$f":"C18-C11","v":313.19999999999993}]
["Gross Profit on Livestock Trading",null,{"$f":"C21-C22","v":7733.05}]