计件工资表-公式自动计算

,,,,,,,,,,,,,,,

工厂(车间)计件工资统计明细表,,,,,,,,,选择查询年月：,,2020年,05月,,

,,,,,,,,,,,,,,,

序号,日期,姓名,工作内容,数量,单价,金额,已付金额,,序号,姓名,记录条数,应发总金额,已发总金额,未发金额

1,2020-05-02,张三三,拉链,1000,0.23,230.00,200.00,,1,张三三,2,434.70,200,234.70

2,2020-05-03,张三三,拉链,890,0.23,204.70,,,2,李四_1,0,0.00,0,0.00

3,2020-05-03,李四_2,衣服,20,13,260.00,,,3,李四_2,1,260.00,0,260.00

,,,,,,0.00,,,4,李四_3,0,0.00,0,0.00

,,,,,,0.00,,,5,李四_4,0,0.00,0,0.00

,,,,,,0.00,,,6,李四_5,0,0.00,0,0.00

,,,,,,0.00,,,7,李四_6,0,0.00,0,0.00

,,,,,,0.00,,,8,李四_7,0,0.00,0,0.00

,,,,,,0.00,,,9,李四_8,0,0.00,0,0.00

,,,,,,0.00,,,10,李四_9,0,0.00,0,0.00

,,,,,,0.00,,,11,李四_10,0,0.00,0,0.00

,,,,,,0.00,,,12,李四_11,0,0.00,0,0.00

,,,,,,0.00,,,13,李四_12,0,0.00,0,0.00

,,,,,,0.00,,,14,李四_13,0,0.00,0,0.00

,,,,,,0.00,,,15,李四_14,0,0.00,0,0.00

,,,,,,0.00,,,16,李四_15,0,0.00,0,0.00

,,,,,,0.00,,,17,李四_16,0,0.00,0,0.00

,,,,,,0.00,,,18,李四_17,0,0.00,0,0.00

,,,,,,0.00,,,19,李四_18,0,0.00,0,0.00

,,,,,,0.00,,,20,李四_19,0,0.00,0,0.00

,,,,,,0.00,,,21,李四_20,0,0.00,0,0.00

,,,,,,0.00,,,22,李四_21,0,0.00,0,0.00

,,,,,,0.00,,,23,李四_22,0,0.00,0,0.00

,,,,,,0.00,,,24,李四_23,0,0.00,0,0.00

,,,,,,0.00,,,25,李四_24,0,0.00,0,0.00

,,,,,,0.00,,,26,李四_25,0,0.00,0,0.00

,,,,,,0.00,,,27,李四_26,0,0.00,0,0.00

,,,,,,0.00,,,28,李四_27,0,0.00,0,0.00

,,,,,,0.00,,,29,李四_28,0,0.00,0,0.00

,,,,,,0.00,,,30,李四_29,0,0.00,0,0.00

,,,,,,0.00,,,31,李四_30,0,0.00,0,0.00

,,,,,,0.00,,,32,李四_31,0,0.00,0,0.00

,,,,,,0.00,,,33,李四_32,0,0.00,0,0.00

,,,,,,0.00,,,34,李四_33,0,0.00,0,0.00

,,,,,,0.00,,,35,李四_34,0,0.00,0,0.00

,,,,,,0.00,,,36,李四_35,0,0.00,0,0.00

,,,,,,0.00,,,37,李四_36,0,0.00,0,0.00

,,,,,,0.00,,,38,李四_37,0,0.00,0,0.00

,,,,,,0.00,,,39,李四_38,0,0.00,0,0.00

,,,,,,0.00,,,40,李四_39,0,0.00,0,0.00

,,,,,,0.00,,,41,李四_40,0,0.00,0,0.00

,,,,,,0.00,,,42,李四_41,0,0.00,0,0.00

,,,,,,0.00,,,43,李四_42,0,0.00,0,0.00

,,,,,,0.00,,,44,李四_43,0,0.00,0,0.00

,,,,,,0.00,,,45,李四_44,0,0.00,0,0.00

,,,,,,0.00,,,46,李四_45,0,0.00,0,0.00

,,,,,,0.00,,,47,李四_46,0,0.00,0,0.00

,,,,,,0.00,,,48,李四_47,0,0.00,0,0.00

,,,,,,0.00,,,49,李四_48,0,0.00,0,0.00

,,,,,,0.00,,,50,李四_49,0,0.00,0,0.00

,,,,,,0.00,,,51,李四_50,0,0.00,0,0.00

,,,,,,0.00,,,52,李四_51,0,0.00,0,0.00

,,,,,,0.00,,,53,李四_52,0,0.00,0,0.00

,,,,,,0.00,,,54,李四_53,0,0.00,0,0.00

,,,,,,0.00,,,55,李四_54,0,0.00,0,0.00

,,,,,,0.00,,,56,李四_55,0,0.00,0,0.00

,,,,,,0.00,,,57,李四_56,0,0.00,0,0.00

,,,,,,0.00,,,58,李四_57,0,0.00,0,0.00

,,,,,,0.00,,,59,李四_58,0,0.00,0,0.00

,,,,,,0.00,,,60,李四_59,0,0.00,0,0.00

,,,,,,0.00,,,61,李四_60,0,0.00,0,0.00

,,,,,,0.00,,,62,李四_61,0,0.00,0,0.00

,,,,,,0.00,,,63,李四_62,0,0.00,0,0.00

,,,,,,0.00,,,64,李四_63,0,0.00,0,0.00

,,,,,,0.00,,,65,李四_64,0,0.00,0,0.00

,,,,,,0.00,,,66,李四_65,0,0.00,0,0.00

,,,,,,0.00,,,67,李四_66,0,0.00,0,0.00

,,,,,,0.00,,,68,李四_67,0,0.00,0,0.00

,,,,,,0.00,,,69,李四_68,0,0.00,0,0.00

,,,,,,0.00,,,70,李四_69,0,0.00,0,0.00

,,,,,,0.00,,,71,李四_70,0,0.00,0,0.00

,,,,,,0.00,,,72,李四_71,0,0.00,0,0.00

,,,,,,0.00,,,73,李四_72,0,0.00,0,0.00

,,,,,,0.00,,,74,李四_73,0,0.00,0,0.00

,,,,,,0.00,,,75,李四_74,0,0.00,0,0.00

,,,,,,0.00,,,76,李四_75,0,0.00,0,0.00

,,,,,,0.00,,,77,李四_76,0,0.00,0,0.00

,,,,,,0.00,,,78,李四_77,0,0.00,0,0.00

,,,,,,0.00,,,79,李四_78,0,0.00,0,0.00

,,,,,,0.00,,,80,李四_79,0,0.00,0,0.00

,,,,,,0.00,,,81,李四_80,0,0.00,0,0.00

,,,,,,0.00,,,82,李四_81,0,0.00,0,0.00

,,,,,,0.00,,,83,李四_82,0,0.00,0,0.00

,,,,,,0.00,,,84,李四_83,0,0.00,0,0.00

,,,,,,0.00,,,85,李四_84,0,0.00,0,0.00

,,,,,,0.00,,,86,李四_85,0,0.00,0,0.00

,,,,,,0.00,,,87,李四_86,0,0.00,0,0.00

,,,,,,0.00,,,88,李四_87,0,0.00,0,0.00

,,,,,,0.00,,,89,李四_88,0,0.00,0,0.00

,,,,,,0.00,,,90,李四_89,0,0.00,0,0.00

,,,,,,0.00,,,91,李四_90,0,0.00,0,0.00

,,,,,,0.00,,,92,李四_91,0,0.00,0,0.00

,,,,,,0.00,,,93,李四_92,0,0.00,0,0.00

,,,,,,0.00,,,94,李四_93,0,0.00,0,0.00

,,,,,,0.00,,,95,李四_94,0,0.00,0,0.00

,,,,,,0.00,,,96,李四_95,0,0.00,0,0.00

,,,,,,0.00,,,97,李四_96,0,0.00,0,0.00

,,,,,,0.00,,,98,李四_97,0,0.00,0,0.00

,,,,,,0.00,,,99,李四_98,0,0.00,0,0.00

,,,,,,0.00,,,100,李四_99,0,0.00,0,0.00

,,,,,,0.00,,,101,李四_100,0,0.00,0,0.00

,,,,,,0.00,,,102,李四_101,0,0.00,0,0.00

,,,,,,0.00,,,103,李四_102,0,0.00,0,0.00

,,,,,,0.00,,,104,李四_103,0,0.00,0,0.00

,,,,,,0.00,,,105,李四_104,0,0.00,0,0.00

,,,,,,0.00,,,106,李四_105,0,0.00,0,0.00

,,,,,,0.00,,,107,李四_106,0,0.00,0,0.00

,,,,,,0.00,,,108,李四_107,0,0.00,0,0.00

,,,,,,0.00,,,109,李四_108,0,0.00,0,0.00

,,,,,,0.00,,,110,李四_109,0,0.00,0,0.00

,,,,,,0.00,,,111,李四_110,0,0.00,0,0.00

,,,,,,0.00,,,112,李四_111,0,0.00,0,0.00

,,,,,,0.00,,,113,李四_112,0,0.00,0,0.00

,,,,,,0.00,,,114,李四_113,0,0.00,0,0.00

,,,,,,0.00,,,115,李四_114,0,0.00,0,0.00

,,,,,,0.00,,,116,李四_115,0,0.00,0,0.00

,,,,,,0.00,,,117,李四_116,0,0.00,0,0.00

,,,,,,0.00,,,118,李四_117,0,0.00,0,0.00

,,,,,,0.00,,,119,李四_118,0,0.00,0,0.00

,,,,,,0.00,,,120,李四_119,0,0.00,0,0.00

,,,,,,0.00,,,121,李四_120,0,0.00,0,0.00

,,,,,,0.00,,,122,李四_121,0,0.00,0,0.00

,,,,,,0.00,,,123,李四_122,0,0.00,0,0.00

,,,,,,0.00,,,124,李四_123,0,0.00,0,0.00

,,,,,,0.00,,,125,李四_124,0,0.00,0,0.00

,,,,,,0.00,,,126,李四_125,0,0.00,0,0.00

,,,,,,0.00,,,127,李四_126,0,0.00,0,0.00

,,,,,,0.00,,,128,李四_127,0,0.00,0,0.00

,,,,,,0.00,,,129,李四_128,0,0.00,0,0.00

,,,,,,0.00,,,130,李四_129,0,0.00,0,0.00

,,,,,,0.00,,,131,李四_130,0,0.00,0,0.00

,,,,,,0.00,,,132,李四_131,0,0.00,0,0.00

,,,,,,0.00,,,133,李四_132,0,0.00,0,0.00

,,,,,,0.00,,,134,李四_133,0,0.00,0,0.00

,,,,,,0.00,,,135,李四_134,0,0.00,0,0.00

,,,,,,0.00,,,136,李四_135,0,0.00,0,0.00

,,,,,,0.00,,,137,李四_136,0,0.00,0,0.00

,,,,,,0.00,,,138,李四_137,0,0.00,0,0.00

,,,,,,0.00,,,139,李四_138,0,0.00,0,0.00

,,,,,,0.00,,,140,李四_139,0,0.00,0,0.00

,,,,,,0.00,,,141,李四_140,0,0.00,0,0.00

,,,,,,0.00,,,142,李四_141,0,0.00,0,0.00

,,,,,,0.00,,,143,李四_142,0,0.00,0,0.00

,,,,,,0.00,,,144,李四_143,0,0.00,0,0.00

,,,,,,0.00,,,145,李四_144,0,0.00,0,0.00

,,,,,,0.00,,,146,李四_145,0,0.00,0,0.00

,,,,,,0.00,,,147,李四_146,0,0.00,0,0.00

,,,,,,0.00,,,148,李四_147,0,0.00,0,0.00

,,,,,,0.00,,,149,李四_148,0,0.00,0,0.00

,,,,,,0.00,,,150,李四_149,0,0.00,0,0.00

,,,,,,0.00,,,151,李四_150,0,0.00,0,0.00

,,,,,,0.00,,,152,李四_151,0,0.00,0,0.00

,,,,,,0.00,,,153,李四_152,0,0.00,0,0.00

,,,,,,0.00,,,154,李四_153,0,0.00,0,0.00

,,,,,,0.00,,,155,李四_154,0,0.00,0,0.00

,,,,,,0.00,,,156,李四_155,0,0.00,0,0.00

,,,,,,0.00,,,157,李四_156,0,0.00,0,0.00

,,,,,,0.00,,,158,李四_157,0,0.00,0,0.00

,,,,,,0.00,,,159,李四_158,0,0.00,0,0.00

,,,,,,0.00,,,160,李四_159,0,0.00,0,0.00

,,,,,,0.00,,,161,李四_160,0,0.00,0,0.00

,,,,,,0.00,,,162,李四_161,0,0.00,0,0.00

,,,,,,0.00,,,163,李四_162,0,0.00,0,0.00

,,,,,,0.00,,,164,李四_163,0,0.00,0,0.00

,,,,,,0.00,,,165,李四_164,0,0.00,0,0.00

,,,,,,0.00,,,166,李四_165,0,0.00,0,0.00

,,,,,,0.00,,,167,李四_166,0,0.00,0,0.00

,,,,,,0.00,,,168,李四_167,0,0.00,0,0.00

,,,,,,0.00,,,169,李四_168,0,0.00,0,0.00

,,,,,,0.00,,,170,李四_169,0,0.00,0,0.00

,,,,,,0.00,,,171,李四_170,0,0.00,0,0.00

,,,,,,0.00,,,172,李四_171,0,0.00,0,0.00

,,,,,,0.00,,,173,李四_172,0,0.00,0,0.00

,,,,,,0.00,,,174,李四_173,0,0.00,0,0.00

,,,,,,0.00,,,175,李四_174,0,0.00,0,0.00

,,,,,,0.00,,,176,李四_175,0,0.00,0,0.00

,,,,,,0.00,,,177,李四_176,0,0.00,0,0.00

,,,,,,0.00,,,178,李四_177,0,0.00,0,0.00

,,,,,,0.00,,,179,李四_178,0,0.00,0,0.00

,,,,,,0.00,,,180,李四_179,0,0.00,0,0.00

,,,,,,0.00,,,181,李四_180,0,0.00,0,0.00

,,,,,,0.00,,,182,李四_181,0,0.00,0,0.00

,,,,,,0.00,,,183,李四_182,0,0.00,0,0.00

,,,,,,0.00,,,184,李四_183,0,0.00,0,0.00

,,,,,,0.00,,,185,李四_184,0,0.00,0,0.00

,,,,,,0.00,,,186,李四_185,0,0.00,0,0.00

,,,,,,0.00,,,187,李四_186,0,0.00,0,0.00

,,,,,,0.00,,,188,李四_187,0,0.00,0,0.00

,,,,,,0.00,,,189,李四_188,0,0.00,0,0.00

,,,,,,0.00,,,190,李四_189,0,0.00,0,0.00

,,,,,,0.00,,,191,李四_190,0,0.00,0,0.00

,,,,,,0.00,,,192,李四_191,0,0.00,0,0.00

,,,,,,0.00,,,193,李四_192,0,0.00,0,0.00

,,,,,,0.00,,,194,李四_193,0,0.00,0,0.00

,,,,,,0.00,,,195,李四_194,0,0.00,0,0.00

,,,,,,0.00,,,196,李四_195,0,0.00,0,0.00

,,,,,,0.00,,,197,李四_196,0,0.00,0,0.00

,,,,,,0.00,,,198,李四_197,0,0.00,0,0.00

,,,,,,0.00,,,199,李四_198,0,0.00,0,0.00

,,,,,,0.00,,,200,李四_199,0,0.00,0,0.00

,,,,,,0.00,,,201,李四_200,0,0.00,0,0.00

,,,,,,0.00,,,202,李四_201,0,0.00,0,0.00

,,,,,,0.00,,,203,李四_202,0,0.00,0,0.00

,,,,,,0.00,,,204,李四_203,0,0.00,0,0.00

,,,,,,0.00,,,205,李四_204,0,0.00,0,0.00

,,,,,,0.00,,,206,李四_205,0,0.00,0,0.00

,,,,,,0.00,,,207,李四_206,0,0.00,0,0.00

,,,,,,0.00,,,208,李四_207,0,0.00,0,0.00

,,,,,,0.00,,,209,李四_208,0,0.00,0,0.00

,,,,,,0.00,,,210,李四_209,0,0.00,0,0.00

,,,,,,0.00,,,211,李四_210,0,0.00,0,0.00

,,,,,,0.00,,,212,李四_211,0,0.00,0,0.00

,,,,,,0.00,,,213,李四_212,0,0.00,0,0.00

,,,,,,0.00,,,214,李四_213,0,0.00,0,0.00

,,,,,,0.00,,,215,李四_214,0,0.00,0,0.00

,,,,,,0.00,,,216,李四_215,0,0.00,0,0.00

,,,,,,0.00,,,217,李四_216,0,0.00,0,0.00

,,,,,,0.00,,,218,李四_217,0,0.00,0,0.00

,,,,,,0.00,,,219,李四_218,0,0.00,0,0.00

,,,,,,0.00,,,220,李四_219,0,0.00,0,0.00

,,,,,,0.00,,,221,李四_220,0,0.00,0,0.00

,,,,,,0.00,,,222,李四_221,0,0.00,0,0.00

,,,,,,0.00,,,223,李四_222,0,0.00,0,0.00

,,,,,,0.00,,,224,李四_223,0,0.00,0,0.00

,,,,,,0.00,,,225,李四_224,0,0.00,0,0.00

,,,,,,0.00,,,226,李四_225,0,0.00,0,0.00

,,,,,,0.00,,,227,李四_226,0,0.00,0,0.00

,,,,,,0.00,,,228,李四_227,0,0.00,0,0.00

,,,,,,0.00,,,229,李四_228,0,0.00,0,0.00

,,,,,,0.00,,,230,李四_229,0,0.00,0,0.00

,,,,,,0.00,,,231,李四_230,0,0.00,0,0.00

,,,,,,0.00,,,232,李四_231,0,0.00,0,0.00

,,,,,,0.00,,,233,李四_232,0,0.00,0,0.00

,,,,,,0.00,,,234,李四_233,0,0.00,0,0.00

,,,,,,0.00,,,235,李四_234,0,0.00,0,0.00

,,,,,,0.00,,,236,李四_235,0,0.00,0,0.00

,,,,,,0.00,,,237,李四_236,0,0.00,0,0.00

,,,,,,0.00,,,238,李四_237,0,0.00,0,0.00

,,,,,,0.00,,,239,李四_238,0,0.00,0,0.00

,,,,,,0.00,,,240,李四_239,0,0.00,0,0.00

,,,,,,0.00,,,241,李四_240,0,0.00,0,0.00

,,,,,,0.00,,,242,李四_241,0,0.00,0,0.00

,,,,,,0.00,,,243,李四_242,0,0.00,0,0.00

,,,,,,0.00,,,244,李四_243,0,0.00,0,0.00

,,,,,,0.00,,,245,李四_244,0,0.00,0,0.00

,,,,,,0.00,,,246,李四_245,0,0.00,0,0.00

,,,,,,0.00,,,247,李四_246,0,0.00,0,0.00

,,,,,,0.00,,,248,李四_247,0,0.00,0,0.00

,,,,,,0.00,,,249,李四_248,0,0.00,0,0.00

,,,,,,0.00,,,250,李四_249,0,0.00,0,0.00

,,,,,,0.00,,,251,李四_250,0,0.00,0,0.00

,,,,,,0.00,,,252,李四_251,0,0.00,0,0.00