excel考试素材

教材发放情况统计表系别班级名称学号姓名册数已用金额已收金额化学系商检技术066607501001陈发珍43¥862.1¥1,100.0生物系城市园林066608401002陈俊娥46¥1,028.4¥1,100.0生物系城市园林066608401008陈康富50¥1,143.3¥1,100.0化学系精细化工066607501003陈少莲45¥923.1¥1,100.0生物系城市园林066608401001甘杏燕48¥1,117.6¥1,100.0政法系法律事务066602501002龚巧玲45¥1,112.9¥1,100.0政法系法律事务066602501001何卓筠46¥1,140.4¥1,100.0政法系法律事务066602501005黄平珍46¥1,113.8¥1,100.0生物系园艺技术066608401003黄雄女46¥1,027.5¥1,100.0化学系精细化工066607501002黄亚曼45¥948.3¥1,100.0生物系园艺技术066608401004蒋华珍47¥1,038.4¥1,100.0政法系行政管理066602501004黎钻仪39¥1,191.2¥1,100.0生物系城市园林066608401005罗汇玲46¥1,028.4¥1,100.0政法系法律事务066602501006罗金芸46¥1,121.4¥1,100.0政法系行政管理066602501003麦绮罗46¥1,112.0¥1,100.0生物系园艺技术066608401007魏碧珊37¥1,018.7¥1,100.0政法系行政管理066602501007肖伟梅46¥1,107.7¥1,100.0化学系商检技术066607501006严志强45¥922.4¥1,100.0化学系精细化工056607502040曾红莲40¥820.6¥1,100.0政法系行政管理066602501008曾泳静46¥1,132.9¥1,100.0化学系商检技术066607501005张丽莉44¥895.2¥1,100.0统计出教材发放册数低于40和超过48的人数3结余书本情况多多多多多多多多多多多多学号学生姓名册数已用金额收费学生姓名066608401007陈碧珊371018.741100陈066607501001陈发珍57862.111100陈066602501003陈绮罗521112.021100册数5040系别班级名称学号姓名册数已用金额收费化学系商检技术066607501001陈发珍43862.111100生物系城市园林066608401002陈俊娥461028.431100生物系城市园林066608401008陈康富501143.281100化学系精细化工066607501003陈少莲45923.081100生物系城市园林066608401001甘杏燕481117.631100政法系法律事务066602501002龚巧玲451112.871100政法系法律事务066602501001何卓筠461140.421100政法系法律事务066602501005黄平珍461113.821100生物系园艺技术066608401003黄雄女461027.481100化学系精细化工066607501002黄亚曼45948.291100生物系园艺技术066608401004蒋华珍471038.411100政法系行政管理066602501004黎钻仪391191.241100生物系城市园林066608401005罗汇玲461028.431100政法系法律事务066602501006罗金芸461121.431100政法系行政管理066602501003麦绮罗461112.021100生物系园艺技术066608401007魏碧珊371018.741100政法系行政管理066602501007肖伟梅461107.651100化学系商检技术066607501006严志强45922.361100化学系精细化工056607502040曾红莲40820.611100政法系行政管理066602501008曾泳静461132.911100化学系商检技术066607501005张丽莉44895.191100教材发放情况统计表