{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["直接成本","间接成本","一般以及行政支出"],"not_rendered":{"charts":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"直接成本","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3],[5,1,5,3],[10,1,10,3],[11,1,11,3],[13,1,13,3]]}
[null,"基于活动的成本跟踪表"]
[null,"公司名称"]
[null,"日期"]
[null,null,"产品 A","产品 B"]
[null,"成本","经济型轿车","运动跑车"]
[]
[null,"直接成本","产品 A","产品 B"]
[null,"定制塑料",{"v":6000,"d":"¥6,000.00"},{"v":8000,"d":"¥8,000.00"}]
[null,"制造",{"v":8000,"d":"¥8,000.00"},{"v":9000,"d":"¥9,000.00"}]
[null,"胶水",{"v":1000,"d":"¥1,000.00"},{"v":1000,"d":"¥1,000.00"}]
[]
[null,"汇总"]
[]
[null,"此单元格中为比较两个产品单位成本的饼图。"]
[]
[null,"每单位产品成本",{"$f":"SUM(一般及行政支出[产品 A],间接成本[产品 A],直接成本[产品 A])","v":{"v":27500,"d":"¥27,500.00"}},{"$f":"SUM(一般及行政支出[产品 B],间接成本[产品 B],直接成本[产品 B])","v":{"v":32000,"d":"¥32,000.00"}}]
[null,"每周生产单位数",10,5]
[null,"每周的总生产成本",{"$f":"C16*C17","v":{"v":275000,"d":"¥275,000.00"}},{"$f":"D16*D17","v":{"v":160000,"d":"¥160,000.00"}}]

{"sheet":"间接成本","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3],[5,1,5,3]]}
[null,"基于活动的成本跟踪表"]
[null,{"$f":"直接成本!B2","v":"公司名称"}]
[null,{"$f":"直接成本!B3","v":"日期"}]
[null,null,"产品 A","产品 B"]
[null,"成本",{"$f":"直接成本!C5","v":"经济型轿车"},{"$f":"直接成本!D5","v":"运动跑车"}]
[]
[null,"间接成本","产品 A","产品 B"]
[null,"运费",{"v":3000,"d":"¥3,000.00"},{"v":3000,"d":"¥3,000.00"}]
[null,"律师费",{"v":3000,"d":"¥3,000.00"},{"v":3000,"d":"¥3,000.00"}]
[null,"责任保险",{"v":500,"d":"¥500.00"},{"v":1000,"d":"¥1,000.00"}]
[null,"牌照",{"v":1000,"d":"¥1,000.00"},{"v":1000,"d":"¥1,000.00"}]

{"sheet":"一般以及行政支出","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3],[5,1,5,3]]}
[null,"基于活动的成本跟踪表"]
[null,{"$f":"直接成本!B2","v":"公司名称"}]
[null,{"$f":"直接成本!B3","v":"日期"}]
[null,null,"产品 A","产品 B"]
[null,"成本",{"$f":"直接成本!C5","v":"经济型轿车"},{"$f":"直接成本!D5","v":"运动跑车"}]
[]
[null,"一般以及行政支出","产品 A","产品 B"]
[null,"应收帐款",{"v":1500,"d":"¥1,500.00"},{"v":1500,"d":"¥1,500.00"}]
[null,"应付帐款",{"v":1500,"d":"¥1,500.00"},{"v":1500,"d":"¥1,500.00"}]
[null,"销售额",{"v":2000,"d":"¥2,000.00"},{"v":3000,"d":"¥3,000.00"}]