车辆加油管理系统表

,,司机姓名联系电话地址,司机1150-0000-0000小王,司机2151-0000-0000小李,司机3152-0000-0000小何,车牌号品牌可容纳人数保险到期日所属部门,鲁MA0001宝马财务部,鲁MA0002帕萨特,鲁MA0003奥迪,鲁MA0004商务12.0,鲁MA0005奥迪,车辆加油流水登记,序号日期车牌号加油量燃油单价加油金额司机姓名备注,1.043862.0110.62375.0018,2.043927.0100.29339.9831,3.043996.066.37224.9943,4.044011.0鲁MA000495.87324.9993,5.044041.087.02294.9978,6.044042.072.27244.9953,7.044073.094.4320.016,8.044073.0鲁MA000544.25150.0075,9.044104.039.63129.9864,10.044104.019.8265.0096,11.044134.054.88180.0064,12.044134.048.78159.9984,13.044195.027.1388.9864,14.044195.098.8334.932,车 辆 加 油 总 账,2020-12-1~2020-12-31,序号车牌号上期加油量上期加油金额本期加油量本期加油金额累计加油量累计加油金额,1.0鲁MA0001230.73779.994598.8334.932329.531114.9265,2.0鲁MA0002200.4674.996727.1388.9864227.53763.9831,3.0鲁MA0003262.95879.9979262.95879.9979,4.0鲁MA000495.87324.999395.87324.9993,5.0鲁MA000544.25150.007544.25150.0075,合计834.22809.9959125.93423.9184960.133233.9143,车辆加油明细帐,Customer statement,车牌号：起始日期:43831.0截止日期:44196.0,期初金额:本期加油量:329.53本期加油金额:1114.9265,累计加油金额:,日期车牌号加油量燃油单价加油金额司机姓名备注累计金额,上期结转,43862.0司机1,2月,2月,43927.0100.29339.9831司机2,4月100.29339.9831,4月210.91714.9849,44104.019.823.2865.0096司机1,9月19.8265.0096,9月230.73779.9945,44195.098.8334.932司机3,12月98.8334.932,12月329.531114.9265,查询结果→→加油明细记录查询,查询条件↓↓合计：486.211640.0349,开始日期序号日期车牌号加油量燃油单价加油金额司机姓名备注,结束日期1.043862.0鲁MA0001110.62375.0018,司机姓名2.043996.0鲁MA000266.37224.9943,车牌号3.044011.0鲁MA000495.87324.9993,4.044073.0鲁MA000294.4320.016,5.044073.0鲁MA000544.25150.0075,6.044104.0鲁MA000119.823.2865.0096,7.044134.0鲁MA000354.883.28180.0064,司机加油报表,司机：联系电话：150-0000-0000,开始日期：43831.0结束日期：44196.0,序号日期车牌号加油量燃油单价加油金额司机姓名备注,1.043862.0鲁MA0001110.62375.0018,2.043996.0鲁MA000266.37224.9943,3.044011.0鲁MA000495.87324.9993,4.044073.0鲁MA000294.4320.016,5.044073.0鲁MA000544.25150.0075,6.044104.0鲁MA000119.823.2865.0096,7.044134.0鲁MA000354.883.28180.0064,合计486.211640.0349,2450.01800.01850.02850.02550.0305.064.01650.0,1.02.03.04.05.06.07.08.09.010.011.012.0合计,加油量110.62100.29162.24159.29138.6559.45103.66125.93960.13,加油金额375.0018339.9831549.9936539.9931470.0235194.996340.0048423.91843233.9143,合计485.6218440.2731712.2336699.2831608.6735254.446443.6648549.84844194.0443,使用说明,序号操作步骤,1.0【车辆信息】【司机信息】中，录入相应资料,用于辅助窗体选择,2.0【加油登记】日期,车牌，司机信息双击选择，其他手录。3.0【加油总账】点击查询按钮，选择起止日期，自动生成统计报表,4.0【加油明细账】点击查询按钮，选择起止日期和车号，自动生成加油明细账,5.0【加油记录查询】录入检索条件，点击检索按钮，自动筛选明细记录,6.0【加油年报】下拉选择年份，点击查询按钮，图表自动更新,7.0【司机报表】点击年份左右箭头按钮，自动更新报表数据和图表