{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["人事表","副表","Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":29,"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":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["销售点","品牌","销售员","员工编号","入职时间","工作年限","员工级别","基本工资"]
["天津","宝马","刘佳佳",892979,"2001-06-13",11,"C类",6400]
["沈阳","奔驰","钱明杰",356268,"2006-03-14",7,"B类",8900]
["长春","别克","崔靖易",748898,"2007-06-27",5,"A类",8300]
["哈尔滨","本田","康含玉",743899,"2000-05-21",13,"B类",6200]
["上海","比亚迪","张慕青",379405,"2000-05-06",13,"A类",8800]
["南京","标致","李若雁",382097,"2007-04-27",11,"A类",9600]
["北京","奥迪","唐宇盈",557954,"2002-11-29",10,"A类",6200]
["杭州","奔腾","李诗",869305,"2006-03-24",7,"A类",7500]
["合肥","保时捷","李诗诗",494578,"2001-08-31",11,"C类",9100]
["郑州","现代","康梦菡",361307,"2001-04-19",12,"B类",9600]
["武汉","雪佛兰","张凡蕾",571797,"2002-01-18",11,"C类",7500]
["长沙","雪铁龙","康水桃",948592,"2003-12-13",9,"B类",8300]
["广州","宾利","康熠彤",514741,"2002-03-20",11,"C类",9900]
["重庆","大众","钱友易",273846,"2005-07-05",7,"B类",8100]
["成都","帝豪","李青槐",874727,"2001-04-15",12,"A类",7400]
["贵阳","丰田","崔夜蓉",392639,"2010-12-31",2,"A类",8600]
["西安","福特","李元风",293939,"2011-05-22",2,"A类",7000]
["兰州","法拉利","崔峻熙",753018,"2009-07-23",3,"B类",7100]
["哈尔滨","菲亚特","张山兰",315388,"2010-06-19",2,"C类",8700]
["上海","凯迪拉克","崔安蕾",669939,"2003-06-19",9,"C类",8000]
["南京","克莱斯勒","钱梦琪",467138,"2007-10-03",5,"C类",6000]
["杭州","雷克萨斯","李如波",521419,"2006-06-15",6,"B类",9400]
["合肥","雷诺","康如彤",391628,"2002-03-18",11,"A类",7000]
["郑州","路虎","张语蓉",139074,"2001-03-06",12,"C类",6500]
["武汉","马自达","张之柔",224795,"2006-01-04",7,"C类",9700]
["长沙","MINI","康傲珊",788526,"2011-06-26",1,"C类",7700]
["北京","迈巴赫","钱鑫鹏",147112,"2009-12-08",3,"B类",6700]
["天津","玛莎拉蒂","刘之桃",497552,"2009-05-18",4,"A类",9500]
["沈阳","欧宝","刘昊天",846146,"2001-09-02",11,"B类",8800]
["长春","讴歌","王夏青",813392,"2007-12-11",5,"A类",9800]
["哈尔滨","起亚","王芷波",644227,"2005-05-21",8,"A类",9700]
["上海","全球鹰","周又晴",782070,"2007-07-04",5,"C类",7300]
["南京","奇瑞","赵弘文",834750,"2006-12-23",6,"B类",7900]
["杭州","日产","赵天荷",821812,"2012-11-20",0,"B类",6200]
["合肥","荣威","代曼文",174665,"2005-02-05",8,"B类",8700]
["郑州","三菱","代采枫",524623,"2004-10-12",8,"C类",6100]
["沈阳","斯巴鲁","周昊然",591045,"2012-01-24",1,"A类",8400]
["长春","Smart","周冰枫",427743,"2002-03-25",11,"B类",6200]
["哈尔滨","沃尔沃","王海安",489643,"2009-09-04",3,"A类",7300]

{"sheet":"副表","index":1,"n_rows":37,"n_cols":10,"rows_kept":37,"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,null,null,null,null,8,21,46.96,986.16]
["车身参数"," 30TFSI手动舒适型",null," 35TFSI自动标准型",null,9,22,27.28,600.16000000000008]
["长",4761,null,4761,null,10,22,29.1,640.20000000000005]
["宽",1826,null,1826,null,11,16,30.98,495.68]
["高",1439,null,1439,null,12,24,32.99,791.76]
["轴距",2869,null,2869]
["消费税",{"$f":"B2*0.05","v":1.3640000000000001},null,{"$f":"B4*0.05","v":1.5490000000000002},null,null,null,null,"综合油耗(L/100km)","最高车速(km/h)"]
[]
["车身参数"," 30TFSI自动舒适型",null," 35TFSI自动舒适型",null,null," 30TFSI手动舒适型",null,6.5,220]
["长",4761,null,4761,null,null," 30TFSI自动舒适型",null,6.5,218]
["宽",1826,null,1826]
["高",1439,null,1439,null,null," 35TFSI自动标准型",null,6.6,230]
["轴距",2869,null,2869,null,null," 35TFSI自动舒适型",null,6.6,230]
[null,{"$f":"B3*0.05","v":1.4550000000000001},null,{"$f":"B5*0.05","v":1.6495000000000002}]
[null,null,null,null,null,null,"总计","销量",{"$f":"SUM(G3:G14)","v":222}]
["车身参数"," 40TFSI quattro 个性运动型",null," 35TFSI自动技术型",null,null,null,"金额",{"$f":"SUM(I3:I14)","v":7407.5}]
["长",4761,null,4761]
["宽",1826,null,1826]
["高",1439,null,1439]
["轴距",2869,null,2869]
[null,{"$f":"B9*0.05","v":2.3480000000000003},null,{"$f":"B5*0.05","v":1.6495000000000002}]
[]
["车身参数"," 35TFSI自动豪华型",null," 40TFSI quattro 运动型"]
["长",4761,null,4761]
["宽",1826,null,1826]
["高",1439,null,1439]
["轴距",2869,null,2869]
[null,{"$f":"B8*0.05","v":1.9950000000000001},null,{"$f":"B9*0.05","v":2.3480000000000003}]

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

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

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