{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["2011-2012非毕业班教材结算","2011-2012毕业班教材结算"],"not_rendered":{"external_links":1,"defined_names":1,"comments":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"2011-2012非毕业班教材结算","index":0,"n_rows":250,"n_cols":13,"rows_kept":250,"merged":[[0,0,0,12]],"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,-567.3299999999999,null,-567.3299999999999]
["电子系","09自动化(1)  ",null,17600,6142.72,8765.62,14908.34,2691.66,null,2691.66]
["电子系","09自动化(2)  ",null,18360,6507.92,9277.48,15785.4,2574.6000000000004,null,2574.6000000000004]
["电子系","10电气类(1)  ",null,18400,11768.34,6913.26,18681.6,-281.59999999999854,null,-281.59999999999854]
["电子系","10电气类(2)  ",null,17600,11501.87,6672.64,18174.510000000002,-574.510000000002,1295.25,-1869.760000000002]
["电子系","10电气类(3)  ",null,18400,12254.1,5127.16,17381.260000000002,1018.739999999998,1816.53,-797.790000000002]
["电子系","10电气类(4)  ",null,17200,10233.25,4610.28,14843.529999999999,2356.470000000001,1799.85,556.6200000000013]
["电子系","10电气类(5)  ",null,18800,12168.16,4942.62,17110.78,1689.2200000000012,null,1689.2200000000012]
["电子系","10电气类(6)  ",null,17200,11430.6,4530.28,15960.880000000001,1239.119999999999,null,1239.119999999999]
["电子系","11电子信息工程(1)  ",null,22000,20296.36,7445.25,27741.61,-5741.610000000001,null,-5741.610000000001]
["电子系","11电子信息工程(2)  ",null,20200,18955.02,6976.5,25931.52,-5731.52,null,-5731.52]
["电子系","11电子信息工程(2+3)  ",null,10500,7655.55,3673.01,11328.560000000001,-828.5600000000013,null,-828.5600000000013]
["电子系","11通信工程(1)  ",null,21360,14287.24,11324.45,25611.690000000002,-4251.690000000002,null,-4251.690000000002]
["电子系","11通信工程(2)  ",null,22300,14287.24,11090.92,25378.16,-3078.16,null,-3078.16]
["电子系","11自动化(1)  ",null,22500,21266.55,9429.5,30696.05,-8196.05,null,-8196.05]
["电子系","11自动化(2)  ",null,22900,21266.55,9429.5,30696.05,-7796.049999999999,null,-7796.049999999999]
["管理系","09工商管理  ",null,23200,7231.4,6230.06,13461.46,9738.54,null,9738.54]
["管理系","09会计1",null,22400,5244,5253.2,10497.2,11902.8,null,11902.8]
["管理系","09会计2",null,21200,5472,5461.44,10933.439999999999,10266.560000000001,null,10266.560000000001]
["管理系","09财务管理",null,22000,9095.68,7847.84,16943.52,5056.48,null,5056.48]
["管理系","09物流管理",null,22000,8057.52,9010.28,17067.800000000003,4932.199999999997,null,4932.199999999997]
["管理系","09公共事业管理  ",null,20000,7505,9490.12,16995.120000000003,3004.8799999999974,null,3004.8799999999974]
["管理系","09信息管理与信息系统  ",null,19600,6219.08,6736.52,12955.6,6644.4,null,6644.4]
["管理系","10财务管理  ",null,21600,11190.85,7978.5,19169.35,2430.6500000000015,null,2430.6500000000015]
["管理系","10工商管理  ",null,21600,9507.57,8112.71,17620.28,3979.720000000001,null,3979.720000000001]
["管理系","10公共事业管理  ",null,20000,12017.96,7851,19868.96,131.04000000000087,null,131.04000000000087]
["管理系","10会计(1)  ",null,22800,10069.84,4227.12,14296.96,8503.04,null,8503.04]
["管理系","10会计(2)  ",null,19600,10451.76,4227.12,14678.880000000001,4921.119999999999,null,4921.119999999999]
["管理系","10物流管理  ",null,22000,9604.87,8293.45,17898.32,4101.68,null,4101.68]
["管理系","10信息管理与信息系统  ",null,19200,8305.28,3969.12,12274.400000000001,6925.5999999999985,null,6925.5999999999985]
["管理系","11财务管理  ",null,24500,16170.98,15666.27,31837.25,-7337.25,null,-7337.25]
["管理系","11工商管理  ",null,26500,16202.1,4551.64,20753.74,5746.259999999998,null,5746.259999999998]
["管理系","11公共事业管理  ",null,27000,17784.36,4727.7,22512.06,4487.939999999999,null,4487.939999999999]
["管理系","11会计(1)  ",null,22000,20338.56,9207.36,29545.920000000002,-7545.920000000002,null,-7545.920000000002]
["管理系","11会计(2)  ",null,21500,20338.56,8764.06,29102.620000000003,-7602.620000000003,null,-7602.620000000003]
["管理系","11物流管理  ",null,25000,21615,6916,28531,-3531,null,-3531]
["管理系","11物流管理(中外合作)  ",null,29000,1332.28,969.76,2302.04,26697.96,null,26697.96]
["管理系","11信息管理与信息系统  ",null,24000,16212.96,4195.2,20408.16,3591.84,null,3591.84]
["化工系","09粉体材料科学与工程  ",null,18400,7613.68,11532.58,19146.260000000002,-746.260000000002,null,-746.260000000002]
["化工系","09化学工程与工艺(1)  ",null,16800,5913.38,7738.22,13651.6,3148.3999999999996,null,3148.3999999999996]
["化工系","09化学工程与工艺(2)  ",null,17600,6049.04,7891.76,13940.8,3659.2000000000007,null,3659.2000000000007]
["化工系","09化学工程与工艺(3)  ",null,17200,6104.7,8069.3,14174,3026,null,3026]
["化工系","09化学工程与工艺(4)  ",null,16000,5722.06,7279.14,13001.2,2998.7999999999993,null,2998.7999999999993]
["化工系","09无机非金属材料工程(1)  ",null,17200,4902,5227.44,10129.439999999999,7070.560000000001,null,7070.560000000001]
["化工系","09无机非金属材料工程(2)  ",null,18000,5130,5603.68,10733.68,7266.32,null,7266.32]
["化工系","10粉体材料科学与工程(1)  ",null,17200,9054.6,6380.79,15435.39,1764.6100000000006,null,1764.6100000000006]
["化工系","10粉体材料科学与工程(2)  ",null,16800,8407.26,6234.26,14641.52,2158.4799999999996,1458.9,699.5799999999995]
["化工系","10化学工程与工艺(1)  ",null,17200,13976.59,5362.5,19339.09,-2139.09,null,-2139.09]
["化工系","10化学工程与工艺(2)  ",null,18000,13967.79,5410.5,19378.29,-1378.2900000000009,566.53,-1944.8200000000008]
["化工系","10化学工程与工艺(3)  ",null,17600,13786.6,5276.4,19063,-1463,null,-1463]
["化工系","10化学工程与工艺(4)  ",null,17200,13842.6,5394.5,19237.1,-2037.0999999999985,null,-2037.0999999999985]
["化工系","10无机非金属材料工程 ",null,20000,15546.52,5704,21250.52,-1250.5200000000004,null,-1250.5200000000004]
["化工系","11粉体材料科学与工程(1)  ",null,22000,19757.24,6160.76,25918,-3918,null,-3918]
["化工系","11粉体材料科学与工程(2)  ",null,20500,19310.03,6305.54,25615.57,-5115.57,null,-5115.57]
["化工系","11化学工程与工艺(1)  ",null,22000,19469,6043.44,25512.44,-3512.4399999999987,null,-3512.4399999999987]
["化工系","11化学工程与工艺(2)  ",null,20900,18174.8,5789.32,23964.12,-3064.119999999999,null,-3064.119999999999]
["化工系","11化学工程与工艺(3)  ",null,21900,19061.6,6196.9,25258.5,-3358.5,null,-3358.5]
["化工系","11化学工程与工艺(4)  ",null,21000,19900.4,6314.5,26214.9,-5214.9000000000015,null,-5214.9000000000015]
["化工系","11无机非金属材料工程(1)  ",null,22000,15256.92,6826.76,22083.68,-83.68000000000029,null,-83.68000000000029]
["化工系","11无机非金属材料工程(2)  ",null,23500,15720.65,7160.65,22881.3,618.7000000000007,null,618.7000000000007]
["计科系","09计算机科学与技术(1)  ",null,14800,4434.24,6667.56,11101.8,3698.2000000000007,null,3698.2000000000007]
["计科系","09计算机科学与技术(2)  ",null,16400,5545.76,6965.7,12511.46,3888.540000000001,null,3888.540000000001]
["计科系","09计算机科学与技术(3)  ",null,15600,5638.48,7152.14,12790.619999999999,2809.380000000001,null,2809.380000000001]
[null,"09计算机科学与技术4（外包）",null,9200,3202.56,1396.82,4599.38,4600.62,3443.25]
["计科系","09网络工程(1)  ",null,19200,6211.64,8217.51,14429.150000000001,4770.8499999999985,null,4770.8499999999985]
["计科系","09网络工程(2)  ",null,16800,5577.16,7316.59,12893.75,3906.25,null,3906.25]
[null,"10网络(专)",null,0,0,5048,5048,-5048]
["计科系","10计算机科学与技术(1)  ",null,15600,11475.07,5091.58,16566.65,-966.6500000000015,6467.22,-7433.870000000002]
["计科系","10计算机科学与技术(2)  ",null,18800,11416.52,5371,16787.52,2012.4799999999996,1075.84,936.6399999999996]
["计科系","10计算机科学与技术(3) 工程师 ",null,17600,8659.29,5200.13,13859.420000000002,3740.579999999998,null,3740.579999999998]
["计科系","10计算机科学与技术(4)外包  ",null,18400,8919.02,5261.3,14180.32,4219.68,null,4219.68]
["计科系","10网络工程(1)  ",null,18000,9531.05,4992.95,14524,3476,null,3476]
["计科系","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]
[null,"11网络系统管理(合作培养2)",null,18500,11023.8,6225.36,17249.16,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]
["经济系","09金融学",null,22800,9186.12,12569.36,21755.480000000003,1044.5199999999968,null,1044.5199999999968]
["经济系","10国际经济与贸易(1)  ",null,21200,7391.26,9215.64,16606.9,4593.0999999999985,null,4593.0999999999985]
["经济系","10国际经济与贸易(2)  ",null,20800,7920,9041.76,16961.760000000002,3838.239999999998,null,3838.239999999998]
["经济系","10金融学  ",null,24400,11373.68,11450.92,22824.6,1575.4000000000015,null,1575.4000000000015]
["经济系","10经济学(1)  ",null,22800,6998.2,8001.28,14999.48,7800.52,null,7800.52]
["经济系","10经济学(2)  ",null,21600,8277.72,8864.64,17142.36,4457.639999999999,null,4457.639999999999]
["经济系","11国际经济与贸易(1)  ",null,24000,14470.08,6756,21226.08,2773.9199999999983,null,2773.9199999999983]
["经济系","11国际经济与贸易(2)  ",null,25000,15073,7037.5,22110.5,2889.5,null,2889.5]
["经济系","11金融学(1)  ",null,25000,15073,7037.5,22110.5,2889.5,null,2889.5]
["经济系","11金融学(2)  ",null,25400,14470.08,6756,21226.08,4173.919999999998,null,4173.919999999998]
["经济系","11经济学(1)  ",null,25000,18059,6441.81,24500.81,499.1899999999987,null,499.1899999999987]
["经济系","11经济学(2)  ",null,24000,18059,6315.5,24374.5,-374.5,null,-374.5]
["旅游系","09旅游管理(1)  ",null,19600,0,7146.01,7146.01,12453.99,null,12453.99]
["旅游系","09旅游管理(2)  ",null,18400,0,6708.64,6708.64,11691.36,null,11691.36]
["旅游系","09旅游管理(3)  ",null,18800,0,6854.43,6854.43,11945.57,null,11945.57]
[]
["旅游系","09资源环境与城乡规划管理  ",null,20400,13820.04,6633.04,20453.08,-53.080000000001746,null,-53.080000000001746]
["旅游系","10旅游管理(1)  ",null,19600,11259.4,9373.21,20632.61,-1032.6100000000006,null,-1032.6100000000006]
["旅游系","10旅游管理(2)  ",null,19600,10822.92,9373.21,20196.129999999997,-596.1299999999974,null,-596.1299999999974]
["旅游系","10旅游管理(3)  ",null,17200,9842.84,8225.47,18068.309999999998,-868.3099999999977,null,-868.3099999999977]
["旅游系","10旅游管理(专)  ",null,0,null,3249,3249,-3249,null,-3249]
["旅游系",null,null,0,null,null,0,0,null,0]
["旅游系","10资源环境与城乡规划管理  ",null,20800,12254.42,4792.71,17047.13,3752.869999999999,null,3752.869999999999]
["旅游系","11旅游管理(1)  ",null,26000,23871.2,8396.08,32267.28,-6267.279999999999,null,-6267.279999999999]
["旅游系","11旅游管理(2)  ",null,27000,24321.6,8698.86,33020.46,-6020.459999999999,null,-6020.459999999999]
["旅游系","11旅游管理(合作培养1)  ",null,17000,12122.25,1877.05,13999.3,3000.7000000000007,null,3000.7000000000007]
["旅游系","11旅游管理(合作培养2)  ",null,15500,10736.85,1662.53,12399.380000000001,3100.619999999999,null,3100.619999999999]
["旅游系","11旅游管理(专升本)  ",null,14000,11174.45,8363.8,19538.25,-5538.25,null,-5538.25]
["旅游系","11资源环境与城乡规划管理  ",null,26000,17995.12,8215.5,26210.62,-210.61999999999898,null,-210.61999999999898]
["生物系","09环境工程  ",null,18000,7516.08,6408.75,13924.83,4075.17,3739.04,336.1300000000001]
["生物系","09生物工程(1)  ",null,17200,11690.2,11502.34,23192.54,-5992.540000000001,null,-5992.540000000001]
["生物系","09生物工程(2)  ",null,16800,11166.1,10328.54,21494.64,-4694.639999999999,null,-4694.639999999999]
["生物系","09生物技术  ",null,19200,10088.65,12197.64,22286.29,-3086.290000000001,67.29,-3153.580000000001]
["生物系","09食品科学与工程(1)  ",null,16800,6392.59,10177.94,16570.53,229.47000000000116,5585.38,-5355.909999999999]
["生物系","09食品科学与工程(2)  ",null,18000,6924.55,11155.3,18079.85,-79.84999999999854,5299.89,-5379.739999999999]
["生物系","10环境工程  ",null,19800,9471.68,9411.46,18883.14,916.8600000000006,null,916.8600000000006]
["生物系","10生物工程(1)  ",null,13600,11669.57,6832.96,18502.53,-4902.529999999999,null,-4902.529999999999]
["生物系","10生物工程(2)  ",null,16000,12509.61,7606.4,20116.010000000002,-4116.010000000002,null,-4116.010000000002]
["生物系","10生物技术  ",null,15600,8541.12,6098.08,14639.2,960.7999999999993,7901.75,-6940.950000000001]
["生物系","10食品科学与工程  ",null,20000,13480.29,10331.12,23811.410000000003,-3811.4100000000035,null,-3811.4100000000035]
["生物系","11环境工程  ",null,24500,22819.92,8131.19,30951.109999999997,-6451.109999999997,null,-6451.109999999997]
["生物系","11生物工程(1)  ",null,24400,28738.24,8671.2,37409.44,-13009.440000000002,null,-13009.440000000002]
["生物系","11生物工程(2)  ",null,23400,27605.08,8309.9,35914.98,-12514.980000000003,null,-12514.980000000003]
["生物系","11生物技术  ",null,22500,21460.75,8433.9,29894.65,-7394.6500000000015,null,-7394.6500000000015]
["生物系","11食品科学与工程  ",null,24000,19644.65,9848,29492.65,-5492.6500000000015,null,-5492.6500000000015]
["数理系","09数学与应用数学(1)  ",null,16000,4218.13,6095.6,10313.73,5686.27,null,5686.27]
["数理系","09数学与应用数学(2)  ",null,14400,4085.2,5943.21,10028.41,4371.59,null,4371.59]
["数理系","09信息与计算科学",null,19600,7733.6,8420.88,16154.48,3445.5200000000004,null,3445.5200000000004]
["数理系","10数学与应用数学(1)  ",null,15200,5948.32,5377.97,11326.29,3873.709999999999,null,3873.709999999999]
["数理系","10数学与应用数学(2)  ",null,16000,6217.36,5720.31,11937.67,4062.33,null,4062.33]
["数理系","10信息与计算科学  ",null,18400,6815,6100.52,12915.52,5484.48,null,5484.48]
["数理系","11数学与应用数学(1)  ",null,23500,22613.81,3967.96,26581.77,-3081.7700000000004,null,-3081.7700000000004]
["数理系","11数学与应用数学(2)  ",null,21900,22154.98,4054.22,26209.2,-4309.200000000001,null,-4309.200000000001]
["数理系","11信息与计算科学  ",null,28600,19421.64,6710.04,26131.68,2468.3199999999997,null,2468.3199999999997]
["外文系","09德语  ",null,12400,2877.54,4251.06,7128.6,5271.4,null,5271.4]
["外文系","09英语(1)  ",null,11600,6508.18,1989.55,8497.73,3102.2700000000004,null,3102.2700000000004]
["外文系","09英语(2)  ",null,11200,6957.02,2132.45,9089.470000000001,2110.529999999999,null,2110.529999999999]
["外文系","10德语  ",null,12000,8132.4,3691.2,11823.599999999999,176.40000000000146,null,176.40000000000146]
["外文系","10日语  ",null,11600,4846.48,5994.88,10841.36,758.6399999999994,null,758.6399999999994]
["外文系","10英语(1)  ",null,12400,8412.72,6155.98,14568.699999999999,-2168.699999999999,null,-2168.699999999999]
["外文系","10英语(2)  ",null,13200,8953.56,6553.14,15506.7,-2306.7000000000007,null,-2306.7000000000007]
["外文系","11朝鲜语(2+2)  ",null,9000,6676.8,695.97,7372.77,1627.2299999999996,null,1627.2299999999996]
["外文系","11德语  ",null,14500,7981.2,4363.63,12344.83,2155.17,null,2155.17]
["外文系","11德语(经贸2+3)  ",null,5500,3192.48,1805.64,4998.12,501.8800000000001,null,501.8800000000001]
["外文系","11日语  ",null,15000,7142.4,4493.7,11636.099999999999,3363.9000000000015,null,3363.9000000000015]
["外文系","11英语(1)  ",null,15000,8427.4,6342.9,14770.3,229.70000000000073,null,229.70000000000073]
["外文系","11英语(2)  ",null,15000,8718,6342.9,15060.9,-60.899999999999636,null,-60.899999999999636]
["外文系","11英语(3)  ",null,15000,8718,6342.9,15060.9,-60.899999999999636,null,-60.899999999999636]
["艺术系","09工业设计(1)  ",null,11200,3416.2,1117.2,4533.4,6666.6,null,6666.6]
["艺术系","09工业设计(2)  ",null,12400,3416.2,1154.44,4570.639999999999,7829.360000000001,null,7829.360000000001]
["艺术系","09工业设计(工科)  ",null,14000,2420.6,2995.3,5415.9,8584.1,null,8584.1]
["艺术系","09艺术设计(1)  ",null,12800,2592.64,4100.48,6693.119999999999,6106.880000000001,null,6106.880000000001]
["艺术系","09艺术设计(2)  ",null,11600,2511.62,3972.34,6483.96,5116.04,null,5116.04]
["艺术系","09艺术设计(3装饰方向)  ",null,9100,2280,3097.2,5377.2,3722.8,null,3722.8]
["艺术系","09艺术设计(4装饰方向)  ",null,9200,2565,3484.35,6049.35,3150.6499999999996,null,3150.6499999999996]
["艺术系","10动画  ",null,12000,3645.6,3716.4,7362,4638,null,4638]
["艺术系","10工业设计(1)  ",null,11200,3185.36,3394.16,6579.52,4620.48,null,4620.48]
["艺术系","10工业设计(2)  ",null,11600,3185.36,3394.16,6579.52,5020.48,null,5020.48]
["艺术系","10工业设计(3+1)  ",null,4000,1024.4,null,1024.4,2975.6,null,2975.6]
["艺术系","10工业设计(工科)  ",null,15200,6757.44,1559.52,8316.96,6883.040000000001,null,6883.040000000001]
["艺术系","10艺术设计(1)  ",null,11600,5816.24,1527.6,7343.84,4256.16,null,4256.16]
["艺术系","10艺术设计(2)  ",null,10400,5214.56,1323.92,6538.4800000000005,3861.5199999999995,null,3861.5199999999995]
["艺术系","10艺术设计(3装饰)  ",null,12000,3007.2,2435.1,5442.299999999999,6557.700000000001,null,6557.700000000001]
["艺术系","10艺术设计(4装饰)  ",null,11600,2906.96,2353.93,5260.889999999999,6339.110000000001,null,6339.110000000001]
["艺术系","11动画(1)  ",null,14500,12186.96,921.33,13108.289999999999,1391.710000000001,null,1391.710000000001]
["艺术系","11动画(2)  ",null,12500,10506,794.25,11300.25,1199.75,null,1199.75]
["艺术系","11工业设计(1)  ",null,15000,9898.8,4081.2,13980,1020,null,1020]
["艺术系","11工业设计(2)  ",null,13500,9238.88,3673.08,12911.96,588.0400000000009,null,588.0400000000009]
["艺术系","11工业设计（3+1）  ",null,8000,3549.4,1010.88,4560.28,3439.7200000000003,null,3439.7200000000003]
["艺术系","11工业设计(3工科)  ",null,19500,18244.2,7522.71,25766.91,-6266.91,null,-6266.91]
["艺术系","11艺术设计(1)  ",null,15000,9716.4,3260.4,12976.8,2023.2000000000007,null,2023.2000000000007]
["艺术系","11艺术设计(2)  ",null,15000,9777.6,3260.4,13038,1962,null,1962]
["艺术系","11艺术设计(3装饰)  ",null,15000,10810.8,1846.8,12657.599999999999,2342.4000000000015,null,2342.4000000000015]
["艺术系","11艺术设计(4装饰)  ",null,14000,10090.08,1723.68,11813.76,2186.24,null,2186.24]
["中文系","09汉语言文学(1)  ",null,18800,7133.76,4208.4,11342.16,7457.84,null,7457.84]
["中文系","09汉语言文学(2)  ",null,18000,6862.96,4577.9,11440.86,6559.139999999999,null,6559.139999999999]
["中文系","09新闻学  ",null,19600,6969.15,10612.59,17581.739999999998,2018.260000000002,null,2018.260000000002]
["中文系","10汉语言文学(1)  ",null,20000,22580.94,2960.96,25541.899999999998,-5541.899999999998,null,-5541.899999999998]
["中文系","10汉语言文学(2)  ",null,20800,23104.44,2670.64,25775.079999999998,-4975.079999999998,null,-4975.079999999998]
["中文系","10新闻学  ",null,20400,15392.14,2938.11,18330.25,2069.75,null,2069.75]
["中文系","11对外汉语  ",null,20000,14774.37,7205.25,21979.620000000003,-1979.6200000000026,null,-1979.6200000000026]
["中文系","11对外汉语(2+2)  ",null,11000,6306.14,4390.93,10697.07,302.9300000000003,null,302.9300000000003]
["中文系","11汉语言文学(1)  ",null,25000,22008,8794.72,30802.72,-5802.720000000001,null,-5802.720000000001]
["中文系","11汉语言文学(2)  ",null,23500,20687.52,8135.04,28822.56,-5322.560000000001,null,-5322.560000000001]
["中文系","11新闻学  ",null,24500,26303.69,5578.65,31882.339999999997,-7382.3399999999965,null,-7382.3399999999965]
[" ","总计",null,5769970]

{"sheet":"2011-2012毕业班教材结算","index":1,"n_rows":88,"n_cols":13,"rows_kept":88,"merged":[[0,0,0,12]],"flags":["formulas_cached_only"]}
["2011-2012学年毕业班级（含10级对外合作班级）教材费结算表"]
["系部","班级","校区","本学年预交款","第一学期应缴款","第二学期应缴款","本学年应缴款","本学年度结束结余款","该班历年欠费","该班总结余","班主任签名","班长签名","备注 "]
[" 机械系","08材料成型及控制(1)  ",null,14800,5113.28,827.3,5940.58,8859.42,null,8859.42]
[" 机械系","08材料成型及控制(2)  ",null,14500,4916.36,758.5,5674.86,8825.14,null,8825.14]
[" 机械系","08机械设计及自动化(1)  ",null,14000,3612.48,870.8,4483.28,9516.720000000001,null,9516.72]
[" 机械系","08机械设计及自动化(2)  ",null,11200,3835.2,870.8,4706,6494,2367.37,4126.63]
[" 机械系","08机械设计及自动化(3)  ",null,15300,4812.04,863.4,5675.44,9624.560000000001,null,9624.560000000001]
[" 机械系","08机械设计及自动化(4)  ",null,12400,4346.44,934.8,5281.24,7118.76,678.53,6440.2300000000005]
[" 机械系","10机械设计制造及自动化(2+3)  ",null,4800,2465.97,298.56,2764.5299999999997,2035.4700000000003,592.75,1442.7200000000003]
["电子系","08电气信息工程(1)  ",null,16800,7045.73,1552.4,8598.13,8201.87,null,8201.87]
["电子系","08电子信息工程(2)  ",null,17200,7314.99,1594.2,8909.19,8290.81,null,8290.81]
["电子系","08电子信息工程(3)  ",null,17600,7294.28,1630.2,8924.48,8675.52,null,8675.52]
["电子系","08通信工程(1)  ",null,11600,2700.64,1080.4,3781.04,7818.96,null,7818.96]
["电子系","08通信工程(2)  ",null,12800,2580.32,1058.2,3638.5200000000004,9161.48,73.9,9087.58]
["电子系","08自动化(1)  ",null,18000,7842.3,1612.1,9454.4,8545.6,null,8545.6]
["电子系","08自动化(2)  ",null,17990,7906.3,1616.3,9522.6,8467.4,null,8467.4]
["电子系","08自动化(3)  ",null,17190,7906.3,1635.6,9541.9,7648.1,null,7648.1]
["电子系","10电气类(2+3)  ",null,5490,3784.03,777.26,4561.29,928.71,2757.66,-1828.9499999999998]
["管理系","08财务管理",null,22000,6543.6,null,6543.6,15456.4,null,15456.4]
["管理系","08会计(1)",null,22800,3243.68,null,3243.68,19556.32,null,19556.32]
["管理系","08会计(2)",null,20000,3391.12,null,3391.12,16608.88,null,16608.88]
["管理系","08工商管理",null,20800,6450.99,null,6450.99,14349.01,null,14349.01]
["管理系","08物流管理",null,20000,8235.36,null,8235.36,11764.64,null,11764.64]
["管理系","08公共事业管理  ",null,18400,5718.96,null,5718.96,12681.04,null,12681.04]
["管理系","08信息管理与信息系统  ",null,19200,8702,null,8702,10498,null,10498]
["化工系","08粉体材料科学与工程  ",null,15600,9658.44,null,9658.44,5941.5599999999995,null,5941.5599999999995]
["化工系","08化学工程与工艺(1)  ",null,16800,6115.74,null,6115.74,10684.26,null,10684.26]
["化工系","08化学工程与工艺(2)  ",null,14800,5499.96,null,5499.96,9300.04,null,9300.04]
["化工系","08无机非金属材料工程  ",null,12800,6040.99,24,6064.99,6735.01,null,6735.01]
["计科系","08计算机科学与技术(1)  ",null,15200,2421,264,2685,12515,null,12515]
["计科系","08计算机科学与技术(2)  ",null,9200,1695,216,1911,7289,null,7289]
["计科系","08计算机科学与技术(3)  ",null,14400,2604,216,2820,11580,null,11580]
["计科系","08计算机科学与技术(4)  ",null,13200,2313,216,2529,10671,null,10671]
["计科系","08网络工程(1)  ",null,17190,6061.96,null,6061.96,11128.04,null,11128.04]
["计科系","08网络工程(2)  ",null,14400,4365.76,null,4365.76,10034.24,null,10034.24]
["计科系","10计算机科学与技术(2+3)  ",null,2800,1193.36,287.28,1480.6399999999999,1319.3600000000001,null,1319.3600000000001]
["计科系","09网络(专)",null,17600,4491.6,446.4,4938,12662,null,12662]
["建工系","08工程管理(1)  ",null,14100,9990.96,158.6,10149.56,3950.4400000000005,1559.53,2390.9100000000008]
["建工系","08工程管理(2)  ",null,14400,9755.08,152.2,9907.28,4492.719999999999,3750.4,742.3199999999993]
["建工系","08土木工程(1)  ",null,17200,7116.8,177.2,7294,9906,null,9906]
["建工系","08土木工程(2)  ",null,14400,6938.88,173.8,7112.68,7287.32,null,7287.32]
["建工系","08土木工程(3)  ",null,17020,7828.48,189.4,8017.879999999999,9002.12,null,9002.12]
["建工系","08土木工程(4)  ",null,16400,7822.56,68.8,7891.360000000001,8508.64,null,8508.64]
["建工系","10土木工程(2+3)  ",null,3600,1343.24,null,1343.24,2256.76,1222.31,1034.4500000000003]
["教育系","08教育(中)  ",null,17600,6837.34,null,6837.34,10762.66,null,10762.66]
["教育系","08教育(数1)",null,16000,4825.47,null,4825.47,11174.529999999999,null,11174.529999999999]
["教育系","08教育(数2)",null,16000,4852.23,null,4852.23,11147.77,null,11147.77]
["教育系","08小学教育(美术方向)  ",null,15600,3047.53,null,3047.53,12552.47,null,12552.47]
["教育系","08应用心理学  ",null,19000,9719.18,null,9719.18,9280.82,null,9280.82]
["教育系","08学前教育",null,0,462.08,null,462.08,-462.08,-3592.44,-4054.52]
["经济系","08国贸(1)",null,18400,9834.5,null,9834.5,8565.5,null,8565.5]
["经济系","08国贸(2)",null,17600,9637.81,null,9637.81,7962.1900000000005,null,7962.1900000000005]
["经济系","08经济学(1)",null,23200,7821.63,null,7821.63,15378.369999999999,null,15378.369999999999]
["经济系","08经济学(2)",null,20400,10271.4,null,10271.4,10128.6,null,10128.6]
["经济系","08金融学",null,23600,7686.61,null,7686.61,15913.39,null,15913.39]
["旅游系","08旅游管理(1)  ",null,20400,3885,2608.66,6493.66,13906.34,null,13906.34]
["旅游系","08旅游管理(2)  ",null,20000,6734,2559.44,9293.44,10706.56,null,10706.56]
["旅游系","08旅游管理(3)  ",null,20000,6734,2569.04,9303.04,10696.96,null,10696.96]
["旅游系","08资源环境与城乡规划管理  ",null,19600,5806.35,392.7,6199.05,13400.95,null,13400.95]
["旅游系","09旅游(专)",null,16800,5571.28,346.5,5917.78,10882.220000000001,null,10882.220000000001]
["生物系","08环境工程(1)  ",null,16000,7043.6,null,7043.6,8956.4,null,8956.4]
["生物系","08生物工程(1)  ",null,14800,4386.16,null,4386.16,10413.84,null,10413.84]
["生物系","08生物工程(2)  ",null,16000,4594.68,null,4594.68,11405.32,null,11405.32]
["生物系","08生物技术  ",null,14800,1339.75,null,1339.75,13460.25,null,13460.25]
["生物系","08食品科学与工程  ",null,16400,7584.59,null,7584.59,8815.41,null,8815.41]
["数理系","08数学与应用数学(1)  ",null,16400,1423.48,null,1423.48,14976.52,null,14976.52]
["数理系","08数学与应用数学(2)  ",null,18000,1016.12,null,1016.12,16983.88,null,16983.88]
["数理系","08信息与计算科学(1)  ",null,19300,5098.08,null,5098.08,14201.92,null,14201.92]
["数理系","08信息与计算科学(2)  ",null,17600,5196.12,null,5196.12,12403.880000000001,null,12403.880000000001]
["外文系","08德语  ",null,12550,4494.08,null,4494.08,8055.92,null,8055.92]
["外文系","08日语  ",null,12000,4126.8,null,4126.8,7873.2,null,7873.2]
["外文系","08英语(1)  ",null,13600,1574.03,null,1574.03,12025.97,null,12025.97]
["外文系","08英语(2)  ",null,11600,1524.63,null,1524.63,10075.369999999999,null,10075.369999999999]
["外文系","10朝鲜语(2+2)  ",null,9200,4979.96,null,4979.96,4220.04,null,4220.04]
["外文系","10德语(2+3)  ",null,3600,3182,1656,4838,-1238,null,-1238]
["艺术系","08工业设计(1)  ",null,3200,null,null,0,3200,null,3200]
["艺术系","08工业设计(2)  ",null,2800,null,null,0,2800,null,2800]
["艺术系","08工业设计(3)  ",null,2000,null,null,0,2000,null,2000]
["艺术系","08工业设计(工)  ",null,15200,2632.11,null,2632.11,12567.89,null,12567.89]
["艺术系","08艺术设计(1)  ",null,9600,1778.4,null,1778.4,7821.6,null,7821.6]
["艺术系","08艺术设计(2)  ",null,9600,1719.12,null,1719.12,7880.88,null,7880.88]
["艺术系","08艺术设计(3美术方向)  ",null,11600,1675.04,null,1675.04,9924.96,null,9924.96]
["中文系","08对外汉语  ",null,12400,3132.2,null,3132.2,9267.8,null,9267.8]
["中文系","08汉语言文学(1)  ",null,17200,6450.52,null,6450.52,10749.48,null,10749.48]
["中文系","08汉语言文学(2)  ",null,14800,5077.88,null,5077.88,9722.119999999999,null,9722.119999999999]
["中文系","08新闻学  ",null,20000,8305.94,null,8305.94,11694.06,null,11694.06]
["中文系","10对外汉语(2+2)",null,9200,2639.48,1396.56,4036.04,5163.96,null,5163.96]
[{"$nulls":9},777215.3500000001]