{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["2011-2012非毕业班教材结算","2011-2012毕业班教材结算"],"not_rendered":{"external_links":1,"defined_names":4},"unopened":[{"sheet":"2011-2012毕业班教材结算","index":1,"reason":"part_missing"}],"read":"biff_walk_short","date_system":"1900","formulas":"cached_only"}

{"sheet":"2011-2012非毕业班教材结算","index":0,"n_rows":144,"n_cols":13,"rows_kept":144,"read":"biff_walk_short","flags":["formulas_cached_only"]}
["2011-2012学年非毕业班教材费结算表"]
["系部","班级","校区","本学年预交款","第一学期应缴款","第二学期应缴款","本学年应缴款","本学年度结束结余款","该班历年欠费","该班总结余","班主任签名","班长签名","备注 "]
[" 机械系","09材料成型及控制(1)  ",null,15600,8626.88,7894.06,16520.94,-920.9399999999987,null,-920.9399999999987]
[" 机械系","09材料成型及控制(2)  ",null,14900,8426.24,7929.06,16355.3,-1455.2999999999993,1167.6,-2622.899999999999]
[" 机械系","09机械设计制造及自动化(1)  ",null,18800,7613.38,11687.36,19300.74,-500.7400000000016,null,-500.7400000000016]
[" 机械系","09机械设计制造及自动化(2)  ",null,17700,7491.35,11674.36,19165.71,-1465.7099999999991,null,-1465.7099999999991]
[" 机械系","09机械设计制造及自动化(3)  ",null,14800,7369.32,11150.57,18519.89,-3719.8899999999994,null,-3719.8899999999994]
[" 机械系","09机械设计制造及自动化(4)  ",null,17600,7937.44,12033.79,19971.23,-2371.2299999999996,1097.57,-3468.7999999999993]
[" 机械系","10材料成型机控制(1)  ",null,18000,13891.54,5354.1,19245.64,-1245.6399999999994,1675.8,-2921.4399999999996]
[" 机械系","10材料成型机控制(2)  ",null,16000,13472.34,5029.92,18502.260000000002,-2502.260000000002,144.04,-2646.300000000002]
[" 机械系","10机械设计制造及自动化(1)  ",null,18000,10526.33,7734.39,18260.72,-260.72000000000116,2653.94,-2914.660000000001]
[" 机械系","10机械设计制造及自动化(2)  ",null,17300,11111.31,7481.95,18593.26,-1293.2599999999984,1767.52,-3060.7799999999984]
[" 机械系","10机械设计制造及自动化(3)  ",null,17400,10666.95,7401.95,18068.9,-668.9000000000015,1677.52,-2346.4200000000014]
[" 机械系","10机械设计制造及自动化(3+1)  ",null,5200,3176.42,978.2,4154.62,1045.38,null,1045.38]
[" 机械系","10机械设计制造及自动化(4)  ",null,15200,10474.38,7076.53,17550.91,-2350.91,367.17,-2718.08]
[" 机械系","11材料成型机控制(1)  ",null,22000,22326.75,5737.55,28064.3,-6064.299999999999,null,-6064.299999999999]
[" 机械系","11材料成型机控制(2)  ",null,22700,22326.75,5986.49,28313.239999999998,-5613.239999999998,null,-5613.239999999998]
[" 机械系","11机械设计制造及其自动化(3+1)  ",null,10500,4806.34,5483.47,10289.810000000001,210.1899999999987,null,210.1899999999987]
[" 机械系","11机械设计制造及自动化(1)  ",null,22800,22501.07,5986.49,28487.559999999998,-5687.559999999998,null,-5687.559999999998]
[" 机械系","11机械设计制造及自动化(2)  ",null,22500,22326.75,5735.15,28061.9,-5561.9000000000015,null,-5561.9000000000015]
[" 机械系","11机械设计制造及自动化(2+3)  ",null,6500,3601.06,2090.53,5691.59,808.4099999999999,null,808.4099999999999]
[" 机械系","11机械设计制造及自动化(3)  ",null,22500,22326.75,5742.35,28069.1,-5569.0999999999985,null,-5569.0999999999985]
[" 机械系","11机械设计制造及自动化(4)  ",null,22000,22326.75,5749.55,28076.3,-6076.299999999999,null,-6076.299999999999]
["电子系","09电子信息工程(1)  ",null,16400,6708.43,10755.2,17463.63,-1063.630000000001,null,-1063.630000000001]
["电子系","09电子信息工程(2)  ",null,17600,6644.43,10903.7,17548.13,51.86999999999898,null,51.86999999999898]
["电子系","09通信工程(1)  ",null,15200,7703.2,7885,15588.2,-388.2000000000007,null,-388.2000000000007]
["电子系","09通信工程(2)  ",null,15200,7703.2,8064.13,15767.33,1.9350528857192695e-284]
{"$rows_empty":71}
[null,"10网络工程(2)  ",null,17200,9868.29,4711.13,14579.420000000002,2620.579999999998,null,2620.579999999998]
["计科系","11计算机科学与技术(1)  ",null,21580,18296.4,8054.9,26351.300000000003,-4771.300000000003,null,-4771.300000000003]
["计科系","11计算机科学与技术(2)  ",null,21900,18318.2,7706.06,26024.260000000002,-4124.260000000002,null,-4124.260000000002]
["计科系","11计算机科学与技术(2+3)  ",null,2500,2198.58,804.05,3002.63,-502.6300000000001,null,-502.6300000000001]
["计科系","11计算机科学与技术(3)  ",null,21500,21998.97,5039,27037.97,-5537.970000000001,null,-5537.970000000001]
["计科系","11计算机科学与技术(4)  ",null,21000,21998.97,5039,27037.97,-6037.970000000001,null,-6037.970000000001]
["计科系","11网络工程(1)  ",null,24860,18702,9026.6,27728.6,-2868.5999999999985,null,-2868.5999999999985]
["计科系","11网络工程(2)  ",null,24190,17664.68,8334.94,25999.620000000003,-1809.6200000000026,null,-1809.6200000000026]
["计科系","11网络系统管理(合作培养1)  ",null,19500,11604,6548.8,18152.8,1347.2000000000007,null,1347.2000000000007]
["计科系","11网络系统管理(合作培养2)",null,18500,11023.8,6225.36,17249.16,1250.84,null,1250.84]
["建工系","09工程管理(1)  ",null,18400,11349.92,8153.28,19503.2,-1103.2000000000007,null,-1103.2000000000007]
["建工系","09工程管理(2)  ",null,18400,11504.71,8323.14,19827.85,-1427.8499999999985,175,-1602.8499999999985]
["建工系","09土木工程(1)  ",null,18800,13229.5,7593,20822.5,-2022.5,5329.23,-7351.73]
["建工系","09土木工程(2)  ",null,18000,13756.64,8156.48,21913.12,-3913.119999999999,7417.45,-11330.57]
["建工系","09土木工程(3)  ",null,19600,12964.93,7336.56,20301.49,-701.4900000000016,4707.86,-5409.350000000001]
["建工系","09土木工程(4)  ",null,18400,12963.93,7444.56,20408.49,-2008.4900000000016,4439.83,-6448.3200000000015]
["建工系","10工程管理(1)  ",null,17200,10796.99,4085,14881.99,2318.01,164.1,2153.9100000000003]
["建工系","10工程管理(2)  ",null,15600,10973.17,4355,15328.17,271.8299999999999,831.23,-559.4000000000001]
["建工系","10建筑学  ",null,12800,7404.76,4069.04,11473.8,1326.2000000000007,69.76,1256.4400000000007]
["建工系","10土木工程(1)  ",null,18800,12622.01,9327.48,21949.489999999998,-3149.489999999998,null,-3149.489999999998]
["建工系","10土木工程(2)  ",null,19600,12749.52,9069.54,21819.06,-2219.0600000000013,null,-2219.0600000000013]
["建工系","10土木工程(3)  ",null,19600,12102.16,9413,21515.16,-1915.1599999999999,null,-1915.1599999999999]
["建工系","10土木工程(4)  ",null,18800,11888.96,9333,21221.96,-2421.959999999999,2955.51,-5377.469999999999]
["建工系","11工程管理(1)  ",null,22500,24720.99,4995.68,29716.670000000002,-7216.670000000002,null,-7216.670000000002]
["建工系","11工程管理(2)  ",null,21500,22702.95,4594.4,27297.35,-5797.3499999999985,null,-5797.3499999999985]
["建工系","11建筑学  ",null,13500,11419.2,4970.4,16389.6,-2889.5999999999985,null,-2889.5999999999985]
["建工系","11土木工程(1)  ",null,22000,20486.7,6793.55,27280.25,-5280.25,null,-5280.25]
["建工系","11土木工程(2)  ",null,21390,20486.7,6873.55,27360.25,-5970.25,null,-5970.25]
["建工系","11土木工程(2+3)  ",null,7000,3554.02,2772.7,6326.719999999999,673.2800000000007,null,673.2800000000007]
["建工系","11土木工程(3)  ",null,22500,20486.7,6793.55,27280.25,-4780.25,null,-4780.25]
["建工系","11土木工程(4)  ",null,21000,19576.18,6495.17,26071.35,-5071.3499999999985,null,-5071.3499999999985]
["教育系","09小学教育  ",null,22000,9563.95,8831.53,18395.480000000003,3604.519999999997,2571.15,1033.3699999999967]
["教育系","09小学教育(美术方向)  ",null,17200,3619.44,3578.08,7197.52,10002.48,null,10002.48]
["教育系","09学前教育  ",null,18800,6840,4715.9,11555.9,7244.1,null,7244.1]
["教育系","09应用心理学  ",null,23600,10984.33,10879.02,21863.35,1736.6500000000015,null,1736.6500000000015]
["教育系","10小学教育(数学)  ",null,18800,9964.11,4475.81,14439.920000000002,4360.079999999998,null,4360.079999999998]
["教育系","10小学教育(中文)  ",null,16800,9057.47,7144,16201.47,598.5300000000007,null,598.5300000000007]
["教育系","10应用心理学  ",null,19200,9081.28,6100.01,15181.29,4018.709999999999,null,4018.709999999999]
["教育系","11小学教育  ",null,30000,27447.6,6376.13,33823.729999999996,-3823.729999999996,null,-3823.729999999996]
["教育系","11学前教育  ",null,30000,17883.46,5207.4,23090.86,6909.139999999999,null,6909.139999999999]
["教育系","11学前教育(专升本)  ",null,9200,6025.77,4630.36,10656.130000000001,-1456.130000000001,null,-1456.130000000001]
["教育系","11应用心理学  ",null,25000,19142.5,4355,23497.5,1502.5,null,1502.5]
["经济系","09国贸1",null,21600,14164.72,12246.12,26410.84,-4810.84,null,-4810.84]
["经济系","09国贸2",null,22000,13204.4,11401.56,24605.96,-2605.959999999999,null,-2605.959999999999]
["经济系","09经济学1",null,22000,12793.76,10485.2,23278.96,-1278.9599999999991,null,-1278.9599999999991]
["经济系","09经济学2",null,22400,8943.4,9580.28,18523.68,3876.3199999999997,null,3876.3199999999997]