2020年考勤表

2020年5月考勤表,2020.0,备注:"1"表示正常出勤1天,"0.5"表示请假0.5天,正常出勤0.5天,"病"表示病假,"伤"表示工伤假期,"孕"表示产假;"亲"表示探亲假;"年"表示年假;"婚"表示婚假,序号工号姓名43952.043953.043954.043955.043956.043957.043958.043959.043960.043961.043962.043963.043964.043965.043966.043967.043968.043969.043970.043971.043972.043973.043974.043975.043976.043977.043978.043979.043980.043981.043982.0周末加班节假日加班事假病假工伤孕假探亲假年假婚假出勤合计计工天数,类别节假日,123456.0text111.014.0,123457.0text217.518.520.5,3.0123458.0text3,4.0123459.0text4,123460.0text53.0,123461.0text6,7.0123462.0text7,8.0123463.0text8,123464.0text9,10.0123465.0text10,11.0123466.0text11,123467.0text12,13.0123472.0text17,14.0123473.0text18,123474.0text19亲亲16.5,16.0123475.0text20,123476.0text21,123477.0text22,123478.0text23,123479.0text24,123480.0text2517.518.520.5,22.0123481.0text2622.0,23.0123482.0text27,24.0123483.0text2833.0,123484.0text297.026.035.0,使用说明:,1.节假日和周末,不存在请假;0.5仅仅表示出勤加班;,2.周末和节假日的填充色是自动生成的;,3.如更改日期,通过第二列的调整按钮更改,考勤表中的日期会自动变更;,4.如果周末和节假日的计工天数有变,在"基础数据"中进行变更;,5.日期数据中仅仅识别了周末和正常班,节假日需要根据实际情况手动变更;,6.有使用的疑问可以咨询qq2423664812;仅仅负责解答疑问,不负责改制表格;,日期星期类别,43831.0,43832.0备注:按照实际情况,对节假日的类别进行修改,43833.0,43834.0,43835.0,43836.0,43837.0,43838.0,43839.0,43840.0,43841.0,43842.0,43843.0,43844.0,43845.0,43846.0,43847.0,43848.0,43849.0,43850.0,43851.0,43852.0,43853.0,43854.0,43855.0,43856.0,43857.0,43858.0,43859.0,43860.0,43861.0,43862.0,43863.0,43864.0,43865.0,43866.0,43867.0,43868.0,43869.0,43870.0,43871.0,43872.0,43873.0,43874.0,43875.0,43876.0,43877.0,43878.0,43879.0,43880.0,43881.0,43882.0,43883.0,43884.0,43885.0,43886.0,43887.0,43888.0,43889.0,43890.0,43891.0,43892.0,43893.0,43894.0,43895.0,43896.0,43897.0,43898.0,43899.0,43900.0,43901.0,43902.0,43903.0,43904.0,43905.0,43906.0,43907.0,43908.0,43909.0,43910.0,43911.0,43912.0,43913.0,43914.0,43915.0,43916.0,43917.0,43918.0,43919.0,43920.0,43921.0,43922.0,43923.0,43924.0,43925.0,43926.0,43927.0,43928.0,43929.0,43930.0,43931.0,43932.0,43933.0,43934.0,43935.0,43936.0,43937.0,43938.0,43939.0,43940.0,43941.0,43942.0,43943.0,43944.0,43945.0,43946.0,43947.0,43948.0,43949.0,43950.0,43951.0,43952.0节假日,43953.0,43954.0,43955.0,43956.0,43957.0,43958.0,43959.0,43960.0,43961.0,43962.0,43963.0,43964.0,43965.0,43966.0,43967.0,43968.0,43969.0,43970.0,43971.0,43972.0,43973.0,43974.0,43975.0,43976.0,43977.0,43978.0,43979.0,43980.0,43981.0,43982.0,43983.0,43984.0,43985.0,43986.0,43987.0,43988.0,43989.0,43990.0,43991.0,43992.0,43993.0,43994.0,43995.0,43996.0,43997.0,43998.0,43999.0,44000.0,44001.0,44002.0,44003.0,44004.0,44005.0,44006.0,44007.0,44008.0,44009.0,44010.0,44011.0,44012.0,44013.0,44014.0,44015.0,44016.0,44017.0,44018.0,44019.0,44020.0,44021.0,44022.0,44023.0,44024.0,44025.0,44026.0,44027.0,44028.0,44029.0,44030.0,44031.0,44032.0,44033.0,44034.0,44035.0,44036.0,44037.0,44038.0,44039.0,44040.0,44041.0,44042.0,44043.0,44044.0,44045.0,44046.0,44047.0,44048.0,44049.0,44050.0,44051.0,44052.0,44053.0,44054.0,44055.0,44056.0,44057.0,44058.0,44059.0,44060.0,44061.0,44062.0,44063.0,44064.0,44065.0,44066.0,44067.0,44068.0,44069.0,44070.0,44071.0,44072.0,44073.0,44074.0,44075.0,44076.0,44077.0,44078.0,44079.0,44080.0,44081.0,44082.0,44083.0,44084.0,44085.0,44086.0,44087.0,44088.0,44089.0,44090.0,44091.0,44092.0,44093.0,44094.0,44095.0,44096.0,44097.0,44098.0,44099.0,44100.0,44101.0,44102.0,44103.0,44104.0,44105.0,44106.0,44107.0,44108.0,44109.0,44110.0,44111.0,44112.0,44113.0,44114.0,44115.0,44116.0,44117.0,44118.0,44119.0,44120.0,44121.0,44122.0,44123.0,44124.0,44125.0,44126.0,44127.0,44128.0,44129.0,44130.0,44131.0,44132.0,44133.0,44134.0,44135.0,44136.0,44137.0,44138.0,44139.0,44140.0,44141.0,44142.0,44143.0,44144.0,44145.0,44146.0,44147.0,44148.0,44149.0,44150.0,44151.0,44152.0,44153.0,44154.0,44155.0,44156.0,44157.0,44158.0,44159.0,44160.0,44161.0,44162.0,44163.0,44164.0,44165.0,44166.0,44167.0,44168.0,44169.0,44170.0,44171.0,44172.0,44173.0,44174.0,44175.0,44176.0,44177.0,44178.0,44179.0,44180.0,44181.0,44182.0,44183.0,44184.0,44185.0,44186.0,44187.0,44188.0,44189.0,44190.0,44191.0,44192.0,44193.0,44194.0,44195.0,44196.0,班次计工数/天,正常班1.0,周末2.0,节假日3.0