{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["销售表","销售图","副表","Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"销售表","index":0,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"R35","v":123754664000}]
[null,"一月","二月","三月","第一季度","四月","五月","六月","第二季度","七月","八月","九月","第三季度","十月","十一月","十二月","第四季度","总计"]
["中型"]
["帕萨特",340491000,259697000,384833000,{"$f":"SUM(B5:D5)","v":985021000},798300000,974237000,83470000,{"$f":"SUM(F5:H5)","v":1856007000},90151000,94868000,955420000,{"$f":"SUM(J5:L5)","v":1140439000},817056000,82067000,216727000,{"$f":"SUM(N5:P5)","v":1115850000},{"$f":"SUM(Q5,M5,I5,E5)","v":5097317000}]
["迈腾",937033000,771692000,866755000,2575480000,620418000,496938000,40267000,{"$f":"SUM(F6:H6)","v":1157623000},645726000,169666000,716347000,1531739000,173387000,319287000,395591000,888265000,{"$f":"SUM(Q6,M6,I6,E6)","v":6153107000}]
["小计",{"$f":"SUM(B5:B6)","v":1277524000},1031389000,1251588000,{"$f":"SUM(E5:E6)","v":3560501000},1418718000,1471175000,123737000,{"$f":"SUM(I5:I6)","v":3013630000},735877000,264534000,1671767000,{"$f":"SUM(M5:M6)","v":2672178000},990443000,401354000,612318000,{"$f":"SUM(Q5:Q6)","v":2004115000},{"$f":"SUM(R5:R6)","v":11250424000}]
[]
["中大型"]
["奥迪A6L",340491000,259697000,384833000,985021000,798300000,974237000,83470000,1856007000,90151000,94868000,955420000,1140439000,817056000,82067000,216727000,1115850000,{"$f":"SUM(Q10,M10,I10,E10)","v":5097317000}]
["索纳塔八",937033000,771692000,866755000,2575480000,620418000,496938000,40267000,1157623000,645726000,169666000,716347000,1531739000,173387000,319287000,395591000,888265000,6153107000]
["宝马5系",340491000,259697000,384833000,985021000,798300000,974237000,83470000,1856007000,90151000,94868000,955420000,1140439000,817056000,82067000,216727000,1115850000,5097317000]
["奔驰E级",937033000,771692000,866755000,2575480000,620418000,496938000,40267000,1157623000,645726000,169666000,716347000,1531739000,173387000,319287000,395591000,888265000,6153107000]
["小计",{"$f":"SUM(B10:B13)","v":2555048000},2062778000,2503176000,{"$f":"SUM(E10:E13)","v":7121002000},2837436000,2942350000,247474000,{"$f":"SUM(I10:I13)","v":6027260000},1471754000,529068000,3343534000,{"$f":"SUM(M10:M13)","v":5344356000},1980886000,802708000,1224636000,{"$f":"SUM(Q10:Q13)","v":4008230000},{"$f":"SUM(R10:R13)","v":22500848000}]
[]
["SUV"]
["哈弗H6",340491000,259697000,384833000,985021000,798300000,974237000,83470000,1856007000,90151000,94868000,955420000,1140439000,817056000,82067000,216727000,1115850000,{"$f":"SUM(Q17,M17,I17,E17)","v":5097317000}]
["途观",937033000,771692000,866755000,2575480000,620418000,496938000,40267000,1157623000,645726000,169666000,716347000,1531739000,173387000,319287000,395591000,888265000,6153107000]
["ix35",340491000,259697000,384833000,985021000,798300000,974237000,83470000,1856007000,90151000,94868000,955420000,1140439000,817056000,82067000,216727000,1115850000,5097317000]
["逍客",937033000,771692000,866755000,2575480000,620418000,496938000,40267000,1157623000,645726000,169666000,716347000,1531739000,173387000,319287000,395591000,888265000,6153107000]
["哈弗M3",340491000,259697000,384833000,985021000,798300000,974237000,83470000,1856007000,90151000,94868000,955420000,1140439000,817056000,82067000,216727000,1115850000,5097317000]
["翼虎",937033000,771692000,866755000,2575480000,620418000,496938000,40267000,1157623000,645726000,169666000,716347000,1531739000,173387000,319287000,395591000,888265000,6153107000]
["比亚迪S6",340491000,259697000,384833000,985021000,798300000,974237000,83470000,1856007000,90151000,94868000,955420000,1140439000,817056000,82067000,216727000,1115850000,5097317000]
["奥迪Q5",937033000,771692000,866755000,2575480000,620418000,496938000,40267000,1157623000,645726000,169666000,716347000,1531739000,173387000,319287000,395591000,888265000,6153107000]
["汉兰达",340491000,259697000,384833000,985021000,798300000,974237000,83470000,1856007000,90151000,94868000,955420000,1140439000,817056000,82067000,216727000,1115850000,5097317000]
["CS35",937033000,771692000,866755000,2575480000,620418000,496938000,40267000,1157623000,645726000,169666000,716347000,1531739000,173387000,319287000,395591000,888265000,6153107000]
["翼搏",340491000,259697000,384833000,985021000,798300000,974237000,83470000,1856007000,90151000,94868000,955420000,1140439000,817056000,82067000,216727000,1115850000,5097317000]
["智跑",937033000,771692000,866755000,2575480000,620418000,496938000,40267000,1157623000,645726000,169666000,716347000,1531739000,173387000,319287000,395591000,888265000,6153107000]
["新胜达-进口",340491000,259697000,384833000,985021000,798300000,974237000,83470000,1856007000,90151000,94868000,955420000,1140439000,817056000,82067000,216727000,1115850000,5097317000]
["奔腾X80",937033000,771692000,866755000,2575480000,620418000,496938000,40267000,1157623000,645726000,169666000,716347000,1531739000,173387000,319287000,395591000,888265000,6153107000]
["昂科拉",340491000,259697000,384833000,985021000,798300000,974237000,83470000,1856007000,90151000,94868000,955420000,1140439000,817056000,82067000,216727000,1115850000,5097317000]
["瑞虎",937033000,771692000,866755000,2575480000,620418000,496938000,40267000,1157623000,645726000,169666000,716347000,1531739000,173387000,319287000,395591000,888265000,6153107000]
["小计",{"$f":"SUM(B17:B32)","v":10220192000},8251112000,10012704000,{"$f":"SUM(E17:E32)","v":28484008000},11349744000,11769400000,989896000,{"$f":"SUM(I17:I32)","v":24109040000},5887016000,2116272000,13374136000,{"$f":"SUM(M17:M32)","v":21377424000},7923544000,3210832000,4898544000,{"$f":"SUM(Q17:Q32)","v":16032920000},{"$f":"SUM(R17:R32)","v":90003392000}]
[]
["总计",{"$f":"B7+B14+B33","v":14052764000},11345279000,13767468000,39165511000,15605898000,16182925000,1361107000,33149930000,8094647000,2909874000,18389437000,29393958000,10894873000,4414894000,6735498000,22045265000,123754664000]

{"sheet":"销售图","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["2014年第一季度销售表"]
[]
["地区","一月","二月","三月","四月","五月","六月","小计"]
["华北",1200,1131,1014.5999999999999,838,1339,458,{"$f":"SUM(B4:G4)","v":5980.6}]
["东北",521,1116,372.29999999999995,1798,416,1216,5439.3]
["华东",1000,1354,991.59999999999991,1882,896,916,7039.6]
["中南",1500,894,1091.0999999999999,1035,1683,699,6902.1]
["西南",810,1268,822.09999999999991,1844,990,1857,7591.1]
["西北",564,986,1350.1,1149,903,722,5674.1]
["总计",{"$f":"SUBTOTAL(109,B4:B9)","v":5595},6749,5641.7999999999993,8546,6227,5868,38626.799999999996]

{"sheet":"副表","index":2,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["2013款奥迪A4L ",null,"销售提成金"]
["30TFSI手动舒适型",27.28,{"$f":"B2*0.02","v":0.54560000000000008},null,null,"月份","销量","售价","金额"]
["30TFSI自动舒适型",29.1,0.58200000000000007,null,null,1,14,27.28,{"$f":"G3*H3","v":381.92}]
["35TFSI自动标准型",30.98,0.61960000000000004,null,null,2,18,29.1,523.80000000000007]
["35TFSI自动舒适型",32.99,0.65980000000000005,null,null,3,22,30.98,681.56000000000006]
["40TFSI quattro 个性运动型",34.9,0.69799999999999995,null,null,4,8,32.99,263.92]
["35TFSI自动技术型",36.979999999999997,0.73959999999999992,null,null,5,17,34.9,593.29999999999995]
["35TFSI自动豪华型",39.9,0.79800000000000004,null,null,6,23,36.979999999999997,850.54]
["40TFSI quattro 运动型",46.96,0.93920000000000003,null,null,7,15,39.9,598.5]
[null,"总计",{"$f":"SUM(C2:C9)","v":5.5817999999999994},null,null,8,21,46.96,986.16]
[null,null,null,null,null,9,22,27.28,600.16000000000008]
[null,null,null,null,null,10,22,29.1,640.20000000000005]
[null,null,null,null,null,11,16,30.98,495.68]
[null,null,null,null,null,12,24,32.99,791.76]
[null,null,null,null,null,null,null,"总计",{"$f":"SUM(I3:I14)","v":7407.5}]
[null,null,"综合油耗(L/100km)","最高车速(km/h)"]
[]
[" 30TFSI手动舒适型",null,6.5,220]
[" 30TFSI自动舒适型",null,6.5,218]
[]
[" 35TFSI自动标准型",null,6.6,230]
[" 35TFSI自动舒适型",null,6.6,230]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet2","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}