{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["總帳"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"總帳","index":0,"n_rows":36,"n_cols":8,"rows_kept":36}
[null,"分類帳科目",{"$nulls":4},"CONTOSO, LTD"]
[]
[{"$nulls":5},"此科目目前",{"$f":"IF(SUM(G7:G1048576)=0,\"結平\",\"未結平\")","v":"未結平"}]
[{"$nulls":5},"結計餘額",{"$f":"SUM(E7:E36)-SUM(F7:F36)","v":{"v":-110,"d":"(110.00)"}}]
[]
[null,"編號","日期","科目","借方 ( + )","貸方 ( - )","餘額","負結餘 (指標)"]
[null,{"$f":"IF(MOD(ROW(),2)=0,\"\",$B5+1)","v":1},{"$f":"TODAY()-10","v":"2017-07-03"},"Fabrikam, Inc. 的付款",{"v":5000,"d":"5,000.00"}]
[null,"",null,"出貨給 Fabrikam, Inc.",null,{"v":5000,"d":"5,000.00"},{"$f":"IF(MOD(ROW(),2)=1,\"\",IF(AND($E7=\"\",$F7=\"\",$E8=\"\",$F8=\"\"),\"\",SUM($E7:$E8)-SUM($F7:$F8)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(MOD(ROW(),2)=1,\"\",IF(SUM(E7:F7)=SUM(E8:F8),0,1))","v":0}]
[null,{"$f":"IF(MOD(ROW(),2)=0,\"\",$B7+1)","v":2},{"$f":"TODAY()-1","v":"2017-07-12"},"Adventure Works 的付款",{"v":2890,"d":"2,890.00"},null,"",""]
[null,{"$f":"IF(MOD(ROW(),2)=0,\"\",$B8+1)","v":""},null,"交貨給 Adventure Works",null,{"v":3000,"d":"3,000.00"},{"v":-110,"d":"(110.00)"},1]
[null,3,{"$nulls":4},"",""]
[null,"",{"$nulls":4},"",0]
[null,4,{"$nulls":4},"",""]
[null,"",{"$nulls":4},"",0]
[null,5,{"$nulls":4},"",""]
[null,"",{"$nulls":4},"",0]
[null,6,{"$nulls":4},"",""]
[null,"",{"$nulls":4},"",0]
[null,7,{"$nulls":4},"",""]
[null,"",{"$nulls":4},"",0]
[null,8,{"$nulls":4},"",""]
[null,"",{"$nulls":4},"",0]
[null,9,{"$nulls":4},"",""]
[null,"",{"$nulls":4},"",0]
[null,10,{"$nulls":4},"",""]
[null,"",{"$nulls":4},"",0]
[null,11,{"$nulls":4},"",""]
[null,"",{"$nulls":4},"",0]
[null,12,{"$nulls":4},"",""]
[null,"",{"$nulls":4},"",0]
[null,13,{"$nulls":4},"",""]
[null,"",{"$nulls":4},"",0]
[null,14,{"$nulls":4},"",""]
[null,{"$f":"IF(MOD(ROW(),2)=0,\"\",$B32+1)","v":""},{"$nulls":4},"",0]
[null,{"$f":"IF(MOD(ROW(),2)=0,\"\",$B33+1)","v":15},{"$nulls":4},"",""]
[null,{"$f":"IF(MOD(ROW(),2)=0,\"\",$B34+1)","v":""},{"$nulls":4},{"$f":"IF(MOD(ROW(),2)=1,\"\",IF(AND($E35=\"\",$F35=\"\",$E36=\"\",$F36=\"\"),\"\",SUM($E35:$E36)-SUM($F35:$F36)))","v":""},{"$f":"IF(MOD(ROW(),2)=1,\"\",IF(SUM(E35:F35)=SUM(E36:F36),0,1))","v":0}]