架管租金自动计算1.1.xlsx

《架管租金自动计算1.1.xlsx》由会员分享，可在线阅读，更多相关《架管租金自动计算1.1.xlsx（29页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、手手 动动 输输 入入 区区0 00 00 00 00 00 00 0日期1M1.2M1.5M2M2.5M3M3.5M4M2020年4月0 00 00 00.010.010.0080.0080.020.020.030.034.5M5M6M架管合计扣件套管70CM顶托结账日期0000000000000000000000000000000手手 动动 输输 入入 区区自自 动动 计计 算算 区区架管扣件套管顶托天数1000010000100001000010000100001000010000100001000010000100001000010000100001000010000100001000

2、010000100001000010000100001000010000100001000010000100001000010000手手 动动 输输 入入 区区0 00 00 00 00 00 00 0日期1M0.6M0.9M1.2M1.6M1.8M1.9M2.2M2020年4月自自 动动 计计 算算 区区0 0轮扣2.5M轮扣总数结账日期天数10010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010手手 动动 输输 入入 区区架架 管管扣扣 件件架架 管管 单单

3、 日日 租租 金金 ：0.010.01 元元/米米扣扣 件件 单单 日日 租租 金金 ：架管日期单次米数计租米数计租日期金额扣件日期单次个数0 00 00.000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00顶顶 托托0.0080.008 元元/个个顶顶 托托 单单

4、日日 租租 金金 ：0.030.03 元元/支支计租个数计租日期金额顶托日期单次支数计租米数计租日期金额0 00 00.000.000 00 00.000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.

5、00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00扣扣 件件套套 管管套套 管管 单单 日日 租租 金金 ：0.020.02 元元/支支顶托日期单次支数计租米数计租日期金额0 00 00.000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.000

6、00.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00手手 动动 输输 入入 区区80478047947394733733373346504650448844882752275247514751日期1M1.2M1.5M2M2.5M3M3.5M4M2018年12月2018/12/9650650502018/12/1015002018/12/112202502502018/12/125002018/12/147002018/12

7、/183921002018/12/193003653002002018/12/232004892018/12/232152018/12/246003003003007022018/12/255001001002018/12/254202018/12/2718612018/12/271501504972018/12/288002019年1月2019/1/12019/1/63002019/1/76001001502001002019/1/96002002019/1/121002003001002019/1/121501007981002002019/1/132019/1/1430010030020

8、01502019/1/151004731004002002019/1/173001002004002019/1/234002019年2月2019/2/12019/2/157002019/2/153002019/2/153003002019/2/1511795002019/2/162019/2/212019/2/222019/2/232002019/2/242019/2/242019/2/254001001002019/2/2619702019/2/273002019年3月2019/3/12019/3/42019/3/82002405005002019/3/141202019/3/1770020

9、19/3/1715361003002019/3/172019/3/244701002019/3/276102019/3/292019年4月2019/4/12019/4/62019/4/1930050501002019/4/191302019/4/212002019/4/252002019/4/263002019/4/264002019/4/274002019/4/281502019/4/2810002019/4/292019/4/295002019/4/3-442-92019/4/4-206-31-752019/4/4-240-81-1362019/4/13-74-88-50-402019/4

10、/14-66-682019年5月2019/5/12019/5/22002019/5/32019/5/43603002019/5/112002019/5/123002019/5/122019/5/142002019/5/203002019/5/272019/5/212019/5/7-6472019/5/112019/5/14-1-1-2-1-52019/5/16-4842019年6月2019/6/12019/6/3-2-4-2-2-8-12-82019/6/3912019/6/8-11-532019/6/9-200-25-82-203-137-842019/6/14-227-522019/6/1

11、4-100-304-139-192019/6/15-35-109-156-77-234-188-772019/6/15-5-16-25-57-93-217-11-282019/6/152019/6/16-16.5-24-70-69-69-162-37-302019/6/16-19-108-118-33-57-10-402019/6/18-84-106-35-77-232019/6/19-20-80-93-54-79-412019/6/20-22-39-133-83-1102019/6/20-49-141-309-422019/6/235612501301002019年7月2019/7/1201

12、9/7/62019/7/62002019/7/61002019/7/144052019/7/162002002019/7/203202002019/7/201002019/7/293002019/7/302019/7/62019/7/14-2-2-6-2-32019/7/29-18-1-18-11-11-10-7-132019/7/30-6-24-132-8-17-132-51-492019年8月2019年8月2019/8/72019/8/77475064002019/8/92019/8/14150492019/8/142019/8/262002002019/8/26-33-377-30-63

13、2019/8/29-31-265-25-312019/8/292019/8/302019年9月2019/9/12019/9/4-7.5-10-2-8-8-6-72019/9/42752019年10月2019/10/12019/10/12019/10/182019/10/222002019/10/22-18.5-4-5-4-10-6-172019/10/241982002012019/10/301003002019/10/305092092019年11月2019/11/12019/11/92002002002019/11/12110127115921202019/11/122019/11/122

14、019/11/152019/11/175032002019/11/17-5.5-1-2-3-12019/11/17362019/11/182019/11/192019/11/206572019/11/242019/11/257002019/11/258492019/11/262019/11/267632019/11/274588502019/11/286626202019/11/272019/11/292019年12月2019/12/12019/12/13003002019/12/19062019/12/42002019/12/520002019/12/52002019/12/61100150

15、2019/12/98002002019/12/101004042019/12/107522019/12/142019/12/113002004102019/12/1427611002019/12/152003502802019/12/163341834752019/12/21-8-3-9-32019/12/22336964622019/12/236707692019/12/231627492907949452019/12/243852019/12/25489.52019/12/278312019/12/284002020年1月2020/1/12020/1/22003002020/1/11202

16、0/1/152020年2月2020/2/12020/2/27-4-6-6-18-15-192020/2/28-451-4502020年3月2020/3/12020/3/2731.52020/3/102020/3/132020/3/192020/3/21500602020/3/255001002020/3/2910010002020/3/6-7742020/3/102020/3/16-6802020/3/252020/3/28-275-4392020年4月2020/4/12020/4/12020/4/42020/4/65002020/4/82020/4/122020/4/225002020/4/

17、265002020/4/6-10-17-12-7-5-42020/4/8-137.5-188-167-162020/4/15-83.5-289-75-113-532020/4/17-187-49-81-395-1282020/4/18-11-279-197-282020/4/18-55-314-32-110-463-562020/4/20-55.5-180-85-179-262-442020/4/21-429-75-67-392020/4/21-308-12020/4/22-165-149-692020/4/22-821-3442020/4/23-594-226-135-252020/4/24

18、-317-87-38-318-972020/4/26-334-145-246-177-1302020/4/262020/4/272020/4/28-316-132-82-93-68-852020/4/29-391-218-125-65-80-140-242020/4/29-318-263-294-223-112-602020/4/30-175-215-323-112-88-170-68-132020年5月2020/5/12020/5/1-598-192-94-85-113-105-262020/5/1-185.5-6-69-45-26-56-44-372020/5/22020/5/52020/

19、5/62020/5/105502020/5/14-253-17-702020/5/142020/5/1510402020/5/172020/5/19-262-9-22-3-4-3-6-82020/5/255012020年6月2020/6/12020/6/1-243.5-228-115-136-38-91-25-472020/6/1-280.5-41-13-52-23-122020/6/2-269-1356-112020/6/710002032020/6/102020/6/112020/6/13-143-43-63-21-220-312020/6/152020/6/15-832020/6/16-

20、148-52-175-124-146-412020/6/192020/6/21-49-31-267-43-15-126-25-422020/6/215002020/6/222020/6/26-122-27-219-38-29-472020/6/27-11-9-288-52-284-110-38-582020/6/28211121111258125810264102644.5M5M6M架管合计扣件套管70CM顶托结账日期100300570026002018/12/3122502018/12/31181512002018/12/31200300480010010072018/12/31245034

21、005002018/12/31100222230002018/12/311461604829.520008002018/12/312211.527002018/12/311252002622.53002018/12/3156072018/12/31160216012002018/12/3133824442018/12/312791.52018/12/31266323002018/12/31240030005002018/12/3102018/12/314696621400110021072019/1/319004002019/1/3110010233852019/1/3110024502000

22、2019/1/31300395020005002019/1/31100439410004007002019/1/31058005003002019/1/3115034056152002019/1/312104254.53002019/1/31235010003003002019/1/31100180020002019/1/3176064.535500320036072019/2/2821008002019/2/2830025502019/2/28180050002019/2/282768.52019/2/2845027002019/2/2850025001005002019/2/2805002

23、019/2/28300230024002019/2/28019683002019/2/28400200036004002019/2/28100175025683992019/2/2823642019/2/28100140022001502019/2/2810029753836425051062019/3/31624285483026405902019/3/31手手 动动 输输 入入 区区425022002019/3/3140027602019/3/31210091007007002019/3/3132542019/3/3141124662019/3/3110015031607302019/3/

24、3118303752019/3/311502019/3/3112494767776620563962019/4/30020002019/4/3025024752019/4/305202019/4/3021020602019/4/3028024802019/4/3030022502019/4/3014005002002019/4/3040040002019/4/304501502019/4/3012002019/4/3028016802019/4/3075020006002019/4/30-1-248-28552019/4/30-23-11-11852019/4/30-41-5-17572019

25、/4/30-48-152-53-20782019/4/30-88-281-75-27542019/4/3012998376268620573462019/5/3120024002019/5/31041002019/5/31144010002019/5/3120014002002019/5/3140024002019/5/3135021002019/5/3120014005002019/5/31310306030010002019/5/31503002019/5/3105002019/5/31-2264.52019/5/31-5-302019/5/31-3-4-71.52019/5/31-169

26、42019/5/3113822383768620598462019/6/30-6-43-400-312019/6/3020013641002886002019/6/30-37-53-206-1890.52019/6/30-40-24-1-2285.52019/6/30-107-112-87-2452.52019/6/30-6-1-1656.52019/6/30-83-2633.82019/6/30-68-24-3-1653.72019/6/300-6892-183-1712019/6/30-27-132-77-2439.82019/6/30-3-57-127-1834.62019/6/30-2

27、2-218-2306.52019/6/30-2-29-10202019/6/30-68-34-131-25112019/6/30-765.7-4000-40-402019/6/305020112019/6/30117747.9729456270102352019/7/3108005002019/7/3130226122019/7/312002019/7/31100181531002019/7/3111002019/7/3172045004002019/7/313502019/7/3130030002019/7/311006002019/7/310-505-112019/7/31-1-51-17

28、232019/7/31-7-3-1-254.7-2576-6942019/7/31-12-4-1135.82019/7/31124003.4795415576111242019/8/310-1762-1202019/8/31100350646102019/8/3105002019/8/31507962019/8/310-210-9802019/8/311200602019/8/31-51-51-106-2641.52019/8/31-80-80-88-23722019/8/310-2533-540-2342019/8/3103502019/8/31124491.9805564916991020

29、19/9/30-6-1-15-245-1220-215-2402019/9/3027510102019/9/30124521.980346470196702019/10/31020002019/10/31400240021002019/10/31100100145022002019/10/31-6-7-235.5-22019/10/3166179620002002019/10/31115022002019/10/311001990.52002019/10/31133072.990844490198702019/11/30100180037002019/11/30862016.52019/11/

30、30401240622002019/11/3008002019/11/30046002019/11/3020321682019/11/30-1-33.5-22019/11/304020415482019/11/30050002019/11/301004505102019/11/301642.52019/11/30046009302019/11/3024502019/11/3025471852019/11/3050030002019/11/302289133212102019/11/3017332019/11/3028742019/11/3042525502019/11/30030002019/

31、11/30162513.41152746296121102019/12/31180040002019/12/3127186902019/12/31207194224002019/12/3130002019/12/3180030002019/12/316020005002019/12/3120024002019/12/31161451002019/12/3122562019/12/3151630962019/12/3140041402019/12/311105039062019/12/3128456502019/12/311266.12019/12/31-7-4-117.5-122019/12/

32、3175753733662.52019/12/3125432019/12/3158211002214.32019/12/31142129162019/12/313672324.52019/12/3124932172019/12/3110002019/12/31213332.31297626796136672020/1/314833873.530002020/1/310-18202020/1/31-7402020/1/31217205.81327626796111072020/2/29-3-1-12-306-2132020/2/29-2928-234-4342020/2/29213971.813

33、25286796104602020/3/31731.52020/3/3135017502020/3/3140024004102020/3/3102020/3/31149173428002020/3/3185020002002020/3/3113005002020/3/31-2322-860-3322020/3/310-365-6782020/3/31-20402020/3/310-1902020/3/31-2361.52020/3/31216013.8138238558194502020/4/30020002020/4/3005002020/4/3060025102020/4/30050020

34、20/4/3003302020/4/306002020/4/306002020/4/30-3-5-12-220.52020/4/30-77-31-21-1977.5-105-1082020/4/30-33-2-102-19622020/4/30-26-45-2462.5-1680-6382020/4/30-34-5-1827.5-205-2242020/4/30-17-19-2621.52020/4/30-30-25-1-2391.52020/4/30-142-135-5-2260.52020/4/30-290-254-1-28922020/4/30-41-61-13432020/4/30-1

35、919.52020/4/30-61-59-5-22512020/4/30-20382020/4/30-23922020/4/300-890-8542020/4/300-140-5392020/4/30-18002020/4/30-3-1-19762020/4/30-30392020/4/30-3-21752020/4/30180264.8143143266679172020/5/31-16-21772020/5/31-37-33-149-2146.72020/5/310-1034-11462020/5/3106022020/5/310-3072020/5/3153014638119002020

36、/5/31-366-69-25762020/5/3105002020/5/3131031082020/5/3103982020/5/31-5-3-10-481.3-225-300-122020/5/311252.54004002020/5/31181055.3145718133268522020/6/30-47-51-85-2581.62020/6/30-27-35-109-16302020/6/30-2378.82020/6/3020122020/6/300-875-1082020/6/3004402020/6/30-21-68-51-1910.52020/6/3037422442020/6

37、/30-83-2200-3992020/6/30-120-70-3-2718.52020/6/3022013202020/6/30-11-31-26-1604.2-129-17-152020/6/306003002020/6/300-470-1402020/6/30-63-80-1951.52020/6/30-117-4-2-2521.32020/6/300-3374-4712020/6/30自自 动动 计计 算算 区区架管扣件套管顶托天数2019年1月30日结 9500元2322212018141399877554312625232020191817159281414141413876554

38、323131092.0713351.32826354748.58281352.4591.360495.6241020422.40018496.800015315109221031515488.100015369.90008252.80116.80591.5037.50300903037484.116266.2437235756.425040000122970001262.4000102060006148.80005112.50005702003041612800313.50013.5336000233.60002153203628-799.400027-319.9500027-474.3900

39、018-374.0400017-468.180003140294.7318914.4643847.16831.78306057600290951.20028403.2008402129433.600204800002042000018252720012367.228.803605150001100016525-566.12500021-6.300018-12.8700016-271.0400003041466.920104.3237238861.428-112-6.9440028381.9222.4161.2850423-434.81500022-502.8100017-416.9250001

40、7-281.60500016-421.40800016-264.592000160-882.176-58.56-82.0815-365.9700015-275.1900013-299.84500012-122.400011-276.2100011-84.227-352-8.8-13.28160.880003136501.84918090.363887.49518.55260166.4039026679.12000265200018326.7446.400161760001286.443201441242000397200212000260-105.040-8.5818-9.18-248.112

41、003-7.641-61.824-41.6402-22.7160003138441.05419726.1683457.1210345.32250-352.4-60025876.592200230920018143.28000180-30.240-529.26722.88006-158.490003-71.1600030-60.792-32.4-21.06205.6003037347.5719333.442949.6891927-66.15-263.52-116.1-194.42774.25218.16003138601.78919925.8082914.628993.1310496001433

42、6235.200101451760010-23.55-0.16008143.6812804822335.200239.810803039921.8721802.562940.6888322396651.20019383.13500019457.14334.40019000456160588.80014303.5200014-4.69-0.2240014216.7200013052000125400183.611180.67500070257.60195.361470006152.82022.2051500005114.4553.281210469.32000386.22000410200020

43、48003150379.15428587.9523903.5211262.3315589920031842.5800641.728543.76537.60027810000272166480026520026002355200022355.08897.60022496.3200018557.2800021869.400018703.0800017483.6500331.516202.57600011-12.925-1.0560010366.250009228.870009199.2870008233.280007162.7150005124.650032.554400003166133.013

44、32180.9764213.5212710.31301162.057200021000-1146.617000-377.42962989.68230800.7843941.689663.093-9.1800-19.172-58.56-3.7440-26.043166331.25832866.9444213.529727.830219.45000223850001945662.320013000011190.74246.400759.5112280339120026-603.720-447.2-258.962200-160.6-447.4816-326.4000700-26.604-94.460

45、003064804.1433177.123348.6850530048000270004052515050200230920019000188.195400053000025-55.12500023-454.825-19.320-74.5216-313.9200014-344.750-470.4-267.9613-237.5750-53.3-87.3613-340.79500011-263.06500010-226.0500010-289.20009-120.870009-172.7550008-180.080007-142.660005-119.6000500-89-128.1400-11.

46、2-64.683-540002-39.520002-60.780001-21.750003155882.08835499.4641652.927362.8131-674.8700031-665.4770003000-620.4-1031.4270130.0320026000-239.4622838.42158.40018-463.68000180720017528.3600015047.760013-62.569-23.4-78-4.68787.67522.40843054316.5934972.32799.26166.830-774.4800030-48900029-689.85200024482.88000210-147-45.36020070.40018-343.8900016359.0400016-13.28-281.60-191.5215-407.77500012158.400010-160.42-10.32-3.4-4.51060240090-33.840-37.85-97.5750004-100.85200030-80.9760-42.39