# 对照表 import json column_map = { "A": "c1", "B": "c2", "C": "c3", "D": "c4", "E": "c5", "F": "c6", "G": "c7", "H": "c8", "I": "c9", "J": "c10", "K": "c11", "L": "c12", "M": "c13", "N": "c14", "O": "c15", "P": "c16", "Q": "c17", "R": "c18", "S": "c19", "T": "c20", "U": "c21", "V": "c22", "W": "c23", "X": "c24", "Y": "c25", "Z": "c26", "AA": "c27", "AB": "c28", "AC": "c29", "AD": "c30", "AE": "c31", "AF": "c32", "AG": "c33", "AH": "c34", "AI": "c35", "AJ": "c36", "AK": "c37", "AL": "c38", "AM": "c39", "AN": "c40", "AO": "c41", "AP": "c42", "AQ": "c43", "AR": "c44", "AS": "c45", "AT": "c46", "AU": "c47", "AV": "c48", "AW": "c49", "AX": "c50", "AY": "c51", "AZ": "c52", "BA": "c53", "BB": "c54", "BC": "c55", "BD": "c56", "BE": "c57", "BF": "c58", "BG": "c59", "BH": "c60", "BI": "c61", "BJ": "c62", "BK": "c63", "BL": "c64", "BM": "c65", "BN": "c66", "BO": "c67", "BP": "c68", "BQ": "c69", "BR": "c70", "BS": "c71", "BT": "c72", "BU": "c73", "BV": "c74", "BW": "c75", "BX": "c76", "BY": "c77", "BZ": "c78", "CA": "c79", "CB": "c80", "CC": "c81", "CD": "c82", "CE": "c83", "CF": "c84", "CG": "c85", "CH": "c86", "CI": "c87", "CJ": "c88", "CK": "c89", "CL": "c90", "CM": "c91", "CN": "c92", "CO": "c93", "CP": "c94", "CQ": "c95", "CR": "c96", "CS": "c97", "CT": "c98", "CU": "c99", "CV": "c100", "CW": "c101", "CX": "c102", "CY": "c103", "CZ": "c104", "DA": "c105", "DB": "c106", "DC": "c107", "DD": "c108", "DE": "c109", "DF": "c110", "DG": "c111", "DH": "c112", "DI": "c113", "DJ": "c114", "DK": "c115", "DL": "c116", "DM": "c117", "DN": "c118", "DO": "c119", "DP": "c120", "DQ": "c121", "DR": "c122", "DS": "c123", "DT": "c124", "DU": "c125", "DV": "c126", "DW": "c127", "DX": "c128", "DY": "c129", "DZ": "c130", "EA": "c131", "EB": "c132", "EC": "c133", "ED": "c134", "EE": "c135", "EF": "c136", "EG": "c137", "EH": "c138", "EI": "c139", "EJ": "c140", "EK": "c141", "EL": "c142", "EM": "c143", "EN": "c144", "EO": "c145", "EP": "c146", "EQ": "c147", "ER": "c148", "ES": "c149", "ET": "c150", "EU": "c151", "EV": "c152", "EW": "c153", "EX": "c154", "EY": "c155", "EZ": "c156", "FA": "c157", "FB": "c158", "FC": "c159", "FD": "c160", "FE": "c161", "FF": "c162", "FG": "c163", "FH": "c164", "FI": "c165", "FJ": "c166", "FK": "c167", "FL": "c168", "FM": "c169", "FN": "c170", "FO": "c171", "FP": "c172", "FQ": "c173", "FR": "c174", "FS": "c175", "FT": "c176", "FU": "c177", "FV": "c178", "FW": "c179", "FX": "c180", "FY": "c181", "FZ": "c182", "GA": "c183", "GB": "c184", "GC": "c185", "GD": "c186", "GE": "c187", "GF": "c188", "GG": "c189", "GH": "c190", "GI": "c191", "GJ": "c192", "GK": "c193", "GL": "c194", "GM": "c195", "GN": "c196", "GO": "c197", "GP": "c198", "GQ": "c199", "GR": "c200", "GS": "c201", "GT": "c202", "GU": "c203", "GV": "c204", "GW": "c205", "GX": "c206", "GY": "c207", "GZ": "c208", "HA": "c209", "HB": "c210", "HC": "c211", "HD": "c212", "HE": "c213", "HF": "c214", "HG": "c215", "HH": "c216", "HI": "c217", "HJ": "c218", "HK": "c219", "HL": "c220", "HM": "c221", "HN": "c222", "HO": "c223", "HP": "c224", "HQ": "c225", "HR": "c226", "HS": "c227", "HT": "c228", "HU": "c229", "HV": "c230", "HW": "c231", "HX": "c232", "HY": "c233", "HZ": "c234", "IA": "c235", "IB": "c236", "IC": "c237", "ID": "c238", "IE": "c239", "IF": "c240", "IG": "c241", "IH": "c242", "II": "c243", "IJ": "c244", "IK": "c245", "IL": "c246", "IM": "c247", "IN": "c248", "IO": "c249", "IP": "c250", "IQ": "c251", "IR": "c252", "IS": "c253", "IT": "c254", "IU": "c255", "IV": "c256", "IW": "c257", "IX": "c258", "IY": "c259", "IZ": "c260", "JA": "c261", "JB": "c262", "JC": "c263", "JD": "c264", "JE": "c265", "JF": "c266", "JG": "c267", "JH": "c268", "JI": "c269", "JJ": "c270", "JK": "c271", "JL": "c272", "JM": "c273", "JN": "c274", "JO": "c275", "JP": "c276", "JQ": "c277", "JR": "c278", "JS": "c279", "JT": "c280", "JU": "c281", "JV": "c282", "JW": "c283", "JX": "c284", "JY": "c285", "JZ": "c286", "KA": "c287", "KB": "c288", "KC": "c289", "KD": "c290", "KE": "c291", "KF": "c292", "KG": "c293", "KH": "c294", "KI": "c295", "KJ": "c296", "KK": "c297", "KL": "c298", "KM": "c299", "KN": "c300", "KO": "c301", "KP": "c302", "KQ": "c303", "KR": "c304", "KS": "c305", "KT": "c306", "KU": "c307", "KV": "c308", "KW": "c309", "KX": "c310", "KY": "c311", "KZ": "c312", "LA": "c313", "LB": "c314", "LC": "c315", "LD": "c316", "LE": "c317", "LF": "c318", "LG": "c319", "LH": "c320", "LI": "c321", "LJ": "c322", "LK": "c323", "LL": "c324", "LM": "c325", "LN": "c326", "LO": "c327", "LP": "c328", "LQ": "c329", "LR": "c330", "LS": "c331", "LT": "c332", "LU": "c333", "LV": "c334", "LW": "c335", "LX": "c336", "LY": "c337", "LZ": "c338", "MA": "c339", "MB": "c340", "MC": "c341", "MD": "c342", "ME": "c343", "MF": "c344", "MG": "c345", "MH": "c346", "MI": "c347", "MJ": "c348", "MK": "c349", "ML": "c350" } # 需要使用昨天的数据的表 yesterday_columns = { "F", "H", "J", "AC", "BD", "CE", "DF", "EG", "FH", "GI", "HJ", "IK", "JL", "LJ", "LS", "LT", "MA", "MB", } # 公式表 alg_map = { "c3": "=SUM(AL5,BM5,CN5,DO5,EP5,FQ5,GR5,HS5,IT5,JU5,LJ5,LR5,LS5,MX5,ME5)", "c4": "=C5/B5", "c5": "=(LU5+LB5)/B5", "c6": "=(AC5+BD5+CE5+DF5+EG5+FH5+GI5+HJ5+IK5+JL5)/B5", "c7": "=SUM(AL5,BM5,CN5,DO5,EP5,FQ5,GR5,HS5,IT5,JU5)", "c8": "=LJ5+LS5+ME5", "c9": "=LR5+MX5", "c10": "=MA5", "c11": "=E5+F5", "c14": "=Y5+AL5", "c15": "=N5/L5", "c24": "=Y5/T5", "c25": "=(P5/1000)*MA5", "c30": "=AB5/AC5", "c33": "=AC5/L5", "c41": "=AZ5+BM5", "c42": "=AO5/AM5", "c51": "=AZ5/AU5", "c52": "=(AQ5/1000)*MA5", "c57": "=BC5/BD5", "c60": "=BD5/AM5", "c67": "=(BN5-BN7)/BN7", "c68": "=CA5+CN5", "c69": "=BP5/BN5", "c78": "=CA5/BV5", "c79": "=(BR5/1000)*MA5", "c84": "=CD5/CE5", "c87": "=CE5/BN5", "c90": "=CH5/CD5", "c91": "=CN5/CH5", "c95": "=DB5+DO5", "c96": "=CQ5/CO5", "c105": "=DB5/CW5", "c106": "=(CS5/1000)*MA5", "c111": "=DE5/DF5", "c114": "=DF5/CO5", "c122": "=EC5+EP5", "c123": "=DR5/DP5", "c132": "=EC5/DX5", "c133": "=(DT5/1000)*MA5", "c138": "=EF5/EG5", "c141": "=EG5/DP5", "c149": "=FD5+FQ5", "c150": "=ES5/EQ5", "c165": "=FG5/FH5", "c168": "=FH5/EQ5", "c176": "=GE5+GR5", "c177": "=FT5/FR5", "c186": "=GE5/FZ5", "c187": "=(FV5/1000)*MA5", "c192": "=GH5/GI5", "c195": "=GI5/FR5", "c203": "=HF5+HS5", "c204": "=GU5/GS5", "c213": "=HF5/HA5", "c214": "=(GW5/1000)*MA5", "c219": "=HI5/HJ5", "c222": "=HJ5/GS5", "c230": "=IG5+IT5", "c231": "=HV5/HT5", "c240": "=IG5/IB5", "c241": "=(HX5/1000)*MA5", "c246": "=IJ5/IK5", "c249": "=IK5/HT5", "c257": "=JH5+JU5", "c258": "=IW5/IU5", "c267": "=JH5/JC5", "c268": "=(IY5/1000)*MA5", "c273": "=JK5/JL5", "c276": "=JL5/IU5", "c311": "=LJ5+LR5", "c312": "=KY5/KW5", "c321": "=LJ5/LE5", "c333": "=SUM(Q5,AR5,BS5,CT5,DU5,FW5,GX5,HY5,IZ5)", "c334": "=SUM(P5,AQ5,BR5,CS5,DT5,FV5,GW5,HX5,IY5)", "c335": "=LU5/(LU5+AC5+BD5+CE5+DF5+EG5+FH5+GI5+HJ5+IK5+JL5+LL5)", "c336": "=LS5-(LV5/1000*MC5)", "c337": "=SUM(T5,AU5,BV5,CW5,DX5,FC5,FZ5,HA5,IB5,JC5,LE5)", "c338": "=H5/LY5", "c341": "=(AB5*AI5+BC5*BJ5+CD5*CK5+DE5*DL5+EF5*EM5+FG5*FN5+GH5*GO5+HI5*HP5+IJ5*IQ5+JK5*JR5)/(AB5+BC5+CD5+DE5+EF5+FG5+GH5+HI5+IJ5+JK5)", "c342": "=(MA5-MC5)/MC5" }