钢管扣件租赁费计算Excel表格与租赁软件计算结果相同.xls

2023/1/25至2024/9/11钢管小计 410.50 租金： 2,646.79 顶丝小计 105.00 租金： 30,782.50 类别单位日期根数规格折合米数单价计算天数金额结余量类别单位日期根数规格折合米数单价计算天数金额结余量钢管米2023/01/2511.5 1.50 0.011 595 9.82 1.50 顶丝个2023/01/2511 1.00 0.500 595 297.50 1.00 钢管米2023/01/2622 4.00 0.011 594 26.14 5.50 顶丝个2023/01/2621 2.00 0.500 594 594.00 3.00 钢管米2023/01/2733 9.00 0.011 593 58.71 14.50 顶丝个2023/01/2731 3.00 0.500 593 889.50 6.00 钢管米2023/01/2844 16.00 0.011 592 104.19 30.50 顶丝个2023/01/2841 4.00 0.500 592 1,184.00 10.00 钢管米2023/01/2954 20.00 0.011 591 130.02 50.50 顶丝个2023/01/2951 5.00 0.500 591 1,477.50 15.00 钢管米2023/01/3064 24.00 0.011 590 155.76 74.50 顶丝个2023/01/3061 6.00 0.500 590 1,770.00 21.00 钢管米2023/01/3174 28.00 0.011 589 181.41 102.50 顶丝个2023/01/3171 7.00 0.500 589 2,061.50 28.00 钢管米2023/02/0184 32.00 0.011 588 206.98 134.50 顶丝个2023/02/0181 8.00 0.500 588 2,352.00 36.00 钢管米2023/02/0294 36.00 0.011 587 232.45 170.50 顶丝个2023/02/0291 9.00 0.500 587 2,641.50 45.00 钢管米2023/02/03104 40.00 0.011 586 257.84 210.50 顶丝个2023/02/03101 10.00 0.500 586 2,930.00 55.00 钢管米2023/02/04114 44.00 0.011 585 283.14 254.50 顶丝个2023/02/04111 11.00 0.500 585 3,217.50 66.00 钢管米2023/02/05124 48.00 0.011 584 308.35 302.50 顶丝个2023/02/05121 12.00 0.500 584 3,504.00 78.00 钢管米2023/02/06134 52.00 0.011 583 333.48 354.50 顶丝个2023/02/06131 13.00 0.500 583 3,789.50 91.00 钢管米2023/02/07144 56.00 0.011 582 358.51 410.50 顶丝个2023/02/07141 14.00 0.500 582 4,074.00 105.00