{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["授权专利年费管理","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"授权专利年费管理","index":0,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["公司内部案件号","专利名称","申请日","专利号/申请号","专利类型","授权日","专利权人数量","第几次减免","第几年年费","当年计算缴费","实际缴费","专利申请日","失效期","有效性","本年度是否完成及备注"]
[null,null,19901020,199010041251.20001,1,19931120,1,{"$f":"IF(RIGHT(F2,\"4\")<RIGHT(C2,\"4\"),TEXT(TODAY(),\"YYYY\")-LEFT(F2,\"4\")+2,TEXT(TODAY(),\"YYYY\")-LEFT(F2,\"4\")+1)","v":25},{"$f":"IF(C2>1,TEXT(TODAY(),\"YYYY\")+1-LEFT(C2,\"4\"),0)","v":28},{"$f":"IF(AND(E2=1,G2=1,H2<=6,I2<=3),135,IF(AND(E2=1,G2=1,H2<=6,I2<=6,I2>=4),180,IF(AND(E2=1,G2=1,H2<=6,I2<=9,I2>=7),300,IF(AND(E2=1,G2=1,H2<=6,I2<=12,I2>=10),600,IF(AND(E2=1,G2=1,H2<=6,I2<=15,I2>=13),900,IF(AND(G2=1,E2=1,H2<=6,I2<=20,I2>=16),1200,IF(AND(G2=1,E2=1,H2>=7,I2<=3),600,IF(AND(E2=1,G2=1,H2>=7,I2>=4,I2<=6),900,IF(AND(G2=1,E2=1,H2>=7,I2>=7,I2<10),2000,IF(AND(G2=1,E2=1,H2>=7,I2>9,I2<13),4000,IF(AND(G2=1,E2=1,H2>=7,I2>12,I2<16),6000,IF(AND(G2=1,E2=1,H2>=7,I2>15,I2<21),8000,IF(AND(E2=1,G2>=2,H2<=6,I2<=3),270,IF(AND(E2=1,G2>=2,H2<=6,I2<=6,I2>=4),360,IF(AND(E2=1,G2>=2,H2<=6,I2<=9,I2>=7),600,IF(AND(E2=1,G2>=2,H2<=6,I2<=12,I2>=10),1200,IF(AND(E2=1,G2>=2,H2<=6,I2<=15,I2>=13),1800,IF(AND(E2=1,G2>=2,H2<=6,I2<21,I2>15),2400,IF(AND(E2=1,G2>=2,H2>=7,I2<=3),600,IF(AND(E2=1,G2>=2,H2>=7,I2>=4,I2<=6),900,IF(AND(E2=1,G2>=2,H2>=7,I2>=7,I2<10),2000,IF(AND(E2=1,G2>=2,H2>=7,I2>9,I2<13),4000,IF(AND(E2=1,G2>=2,H2>=7,I2>12,I2<16),6000,IF(AND(E2=1,G2>=2,H2>=7,I2>15,I2<21),8000,IF(AND(E2=2,G2=1,H2<=6,I2<=3),90,IF(AND(E2=2,G2=1,H2<=6,I2<=5,I2>=4),135,IF(AND(E2=2,G2=1,H2<=6,I2<=8,I2>=6),180,IF(AND(E2=2,G2=1,H2<=6,I2<=10,I2>=9),300,IF(AND(E2=2,G2=1,H2>=7,I2>=4,I2<=5),900,IF(AND(E2=2,G2=1,H2>=7,I2>=6,I2<=8),1200,IF(AND(E2=2,G2=1,H2>=7,I2>=9,I2<=10),2000,IF(AND(E2=2,G2>=2,H2<=6,I2<4),180,IF(AND(E2=2,G2>=2,H2<=6,I2<=5,I2>=4),270,IF(AND(E2=2,G2>=2,E2=2,H2<=6,I2<=8,I2>=6),360,IF(AND(E2=2,G2>=2,H2<=6,I2<=10,I2>=9),600,IF(AND(E2=2,G2>=2,H2>=7,I2>=4,I2<=5),900,IF(AND(E2=2,G2>=2,H2>=7,I2>=6,I2<=8),1200,IF(AND(E2=2,G2>=2,H2>=7,I2>=9,I2<=10),2000,IF(AND(G2=1,E2=3,H2<=6,I2<=3),90,IF(AND(G2=1,E2=3,H2<=6,I2<=5,I2>=4),135,IF(AND(G2=1,E2=3,H2<=6,I2<=8,I2>=6),180,IF(AND(G2=1,E2=3,H2<=6,I2<=10,I2>=9),300,IF(AND(G2=1,E2=3,H2>=7,I2<=5,I2>=4),900,IF(AND(G2=1,E2=3,H2>=7,I2<=8,I2>=6),1200,IF(AND(G2=1,E2=3,H2>=7,I2>=9,I2<=10),2000,IF(AND(E2=3,G2>=2,H2<=6,I2<=4),180,IF(AND(G2>=2,E2=3,H2<=6,I2<=5,I2>=4),270,IF(AND(G2>=2,E2=3,H2<=6,I2<=8,I2>=6),360,IF(AND(G2>=2,E2=3,H2<=6,I2<=10,I2>=9),600,IF(AND(G2>=2,E2=3,H2>=7,I2>=4,#REF!<=5),900,IF(AND(G2>=2,E2=3,H2>=7,I2>=6,I2<=8),1200,IF(AND(G2>=2,E2=3,H2>=7,I2>=9,I2<=10),2000))))))))))))))))))))))))))))))))))))))))))))))))))))","v":{"$error":"#REF!"}},null,"1990-10-20",{"$f":"IF(AND(E2=1),DATE(YEAR($L2)+20,MONTH($L2),DAY($L2)),DATE(YEAR($L2)+10,MONTH($L2),DAY($L2)))","v":"2010-10-20"},{"$f":"IF(AND(F2>1,E2=1,I2<21),\"有效\",IF(AND(F2>1,E2=2,I2<11),\"有效\",IF(AND(F2>1,E2=3,I2<11),\"有效\")))","v":false},"完成"]
[null,null,20021212,200210241562.10001,1,20060314,1,13,{"$f":"IF(C3>1,TEXT(TODAY(),\"YYYY\")+1-LEFT(C3,\"4\"),0)","v":16},{"$f":"IF(AND(E3=1,G3=1,H3<=6,I3<=3),135,IF(AND(E3=1,G3=1,H3<=6,I3<=6,I3>=4),180,IF(AND(E3=1,G3=1,H3<=6,I3<=9,I3>=7),300,IF(AND(E3=1,G3=1,H3<=6,I3<=12,I3>=10),600,IF(AND(E3=1,G3=1,H3<=6,I3<=15,I3>=13),900,IF(AND(G3=1,E3=1,H3<=6,I3<=20,I3>=16),1200,IF(AND(G3=1,E3=1,H3>=7,I3<=3),600,IF(AND(E3=1,G3=1,H3>=7,I3>=4,I3<=6),900,IF(AND(G3=1,E3=1,H3>=7,I3>=7,I3<10),2000,IF(AND(G3=1,E3=1,H3>=7,I3>9,I3<13),4000,IF(AND(G3=1,E3=1,H3>=7,I3>12,I3<16),6000,IF(AND(G3=1,E3=1,H3>=7,I3>15,I3<21),8000,IF(AND(E3=1,G3>=2,H3<=6,I3<=3),270,IF(AND(E3=1,G3>=2,H3<=6,I3<=6,I3>=4),360,IF(AND(E3=1,G3>=2,H3<=6,I3<=9,I3>=7),600,IF(AND(E3=1,G3>=2,H3<=6,I3<=12,I3>=10),1200,IF(AND(E3=1,G3>=2,H3<=6,I3<=15,I3>=13),1800,IF(AND(E3=1,G3>=2,H3<=6,I3<21,I3>15),2400,IF(AND(E3=1,G3>=2,H3>=7,I3<=3),600,IF(AND(E3=1,G3>=2,H3>=7,I3>=4,I3<=6),900,IF(AND(E3=1,G3>=2,H3>=7,I3>=7,I3<10),2000,IF(AND(E3=1,G3>=2,H3>=7,I3>9,I3<13),4000,IF(AND(E3=1,G3>=2,H3>=7,I3>12,I3<16),6000,IF(AND(E3=1,G3>=2,H3>=7,I3>15,I3<21),8000,IF(AND(E3=2,G3=1,H3<=6,I3<=3),90,IF(AND(E3=2,G3=1,H3<=6,I3<=5,I3>=4),135,IF(AND(E3=2,G3=1,H3<=6,I3<=8,I3>=6),180,IF(AND(E3=2,G3=1,H3<=6,I3<=10,I3>=9),300,IF(AND(E3=2,G3=1,H3>=7,I3>=4,I3<=5),900,IF(AND(E3=2,G3=1,H3>=7,I3>=6,I3<=8),1200,IF(AND(E3=2,G3=1,H3>=7,I3>=9,I3<=10),2000,IF(AND(E3=2,G3>=2,H3<=6,I3<4),180,IF(AND(E3=2,G3>=2,H3<=6,I3<=5,I3>=4),270,IF(AND(E3=2,G3>=2,E3=2,H3<=6,I3<=8,I3>=6),360,IF(AND(E3=2,G3>=2,H3<=6,I3<=10,I3>=9),600,IF(AND(E3=2,G3>=2,H3>=7,I3>=4,I3<=5),900,IF(AND(E3=2,G3>=2,H3>=7,I3>=6,I3<=8),1200,IF(AND(E3=2,G3>=2,H3>=7,I3>=9,I3<=10),2000,IF(AND(G3=1,E3=3,H3<=6,I3<=3),90,IF(AND(G3=1,E3=3,H3<=6,I3<=5,I3>=4),135,IF(AND(G3=1,E3=3,H3<=6,I3<=8,I3>=6),180,IF(AND(G3=1,E3=3,H3<=6,I3<=10,I3>=9),300,IF(AND(G3=1,E3=3,H3>=7,I3<=5,I3>=4),900,IF(AND(G3=1,E3=3,H3>=7,I3<=8,I3>=6),1200,IF(AND(G3=1,E3=3,H3>=7,I3>=9,I3<=10),2000,IF(AND(E3=3,G3>=2,H3<=6,I3<=4),180,IF(AND(G3>=2,E3=3,H3<=6,I3<=5,I3>=4),270,IF(AND(G3>=2,E3=3,H3<=6,I3<=8,I3>=6),360,IF(AND(G3>=2,E3=3,H3<=6,I3<=10,I3>=9),600,IF(AND(G3>=2,E3=3,H3>=7,I3>=4,#REF!<=5),900,IF(AND(G3>=2,E3=3,H3>=7,I3>=6,I3<=8),1200,IF(AND(G3>=2,E3=3,H3>=7,I3>=9,I3<=10),2000))))))))))))))))))))))))))))))))))))))))))))))))))))","v":8000},null,"2002-12-12",{"$f":"IF(AND(E3=1),DATE(YEAR($L3)+20,MONTH($L3),DAY($L3)),DATE(YEAR($L3)+10,MONTH($L3),DAY($L3)))","v":"2022-12-12"},{"$f":"IF(AND(F3>1,E3=1,I3<21),\"有效\",IF(AND(F3>1,E3=2,I3<11),\"有效\",IF(AND(F3>1,E3=3,I3<11),\"有效\")))","v":"有效"},"完成"]
[null,null,20080215,200815415246.20001,1,20100410,1,8,10,{"$f":"IF(AND(E4=1,G4=1,H4<=6,I4<=3),135,IF(AND(E4=1,G4=1,H4<=6,I4<=6,I4>=4),180,IF(AND(E4=1,G4=1,H4<=6,I4<=9,I4>=7),300,IF(AND(E4=1,G4=1,H4<=6,I4<=12,I4>=10),600,IF(AND(E4=1,G4=1,H4<=6,I4<=15,I4>=13),900,IF(AND(G4=1,E4=1,H4<=6,I4<=20,I4>=16),1200,IF(AND(G4=1,E4=1,H4>=7,I4<=3),600,IF(AND(E4=1,G4=1,H4>=7,I4>=4,I4<=6),900,IF(AND(G4=1,E4=1,H4>=7,I4>=7,I4<10),2000,IF(AND(G4=1,E4=1,H4>=7,I4>9,I4<13),4000,IF(AND(G4=1,E4=1,H4>=7,I4>12,I4<16),6000,IF(AND(G4=1,E4=1,H4>=7,I4>15,I4<21),8000,IF(AND(E4=1,G4>=2,H4<=6,I4<=3),270,IF(AND(E4=1,G4>=2,H4<=6,I4<=6,I4>=4),360,IF(AND(E4=1,G4>=2,H4<=6,I4<=9,I4>=7),600,IF(AND(E4=1,G4>=2,H4<=6,I4<=12,I4>=10),1200,IF(AND(E4=1,G4>=2,H4<=6,I4<=15,I4>=13),1800,IF(AND(E4=1,G4>=2,H4<=6,I4<21,I4>15),2400,IF(AND(E4=1,G4>=2,H4>=7,I4<=3),600,IF(AND(E4=1,G4>=2,H4>=7,I4>=4,I4<=6),900,IF(AND(E4=1,G4>=2,H4>=7,I4>=7,I4<10),2000,IF(AND(E4=1,G4>=2,H4>=7,I4>9,I4<13),4000,IF(AND(E4=1,G4>=2,H4>=7,I4>12,I4<16),6000,IF(AND(E4=1,G4>=2,H4>=7,I4>15,I4<21),8000,IF(AND(E4=2,G4=1,H4<=6,I4<=3),90,IF(AND(E4=2,G4=1,H4<=6,I4<=5,I4>=4),135,IF(AND(E4=2,G4=1,H4<=6,I4<=8,I4>=6),180,IF(AND(E4=2,G4=1,H4<=6,I4<=10,I4>=9),300,IF(AND(E4=2,G4=1,H4>=7,I4>=4,I4<=5),900,IF(AND(E4=2,G4=1,H4>=7,I4>=6,I4<=8),1200,IF(AND(E4=2,G4=1,H4>=7,I4>=9,I4<=10),2000,IF(AND(E4=2,G4>=2,H4<=6,I4<4),180,IF(AND(E4=2,G4>=2,H4<=6,I4<=5,I4>=4),270,IF(AND(E4=2,G4>=2,E4=2,H4<=6,I4<=8,I4>=6),360,IF(AND(E4=2,G4>=2,H4<=6,I4<=10,I4>=9),600,IF(AND(E4=2,G4>=2,H4>=7,I4>=4,I4<=5),900,IF(AND(E4=2,G4>=2,H4>=7,I4>=6,I4<=8),1200,IF(AND(E4=2,G4>=2,H4>=7,I4>=9,I4<=10),2000,IF(AND(G4=1,E4=3,H4<=6,I4<=3),90,IF(AND(G4=1,E4=3,H4<=6,I4<=5,I4>=4),135,IF(AND(G4=1,E4=3,H4<=6,I4<=8,I4>=6),180,IF(AND(G4=1,E4=3,H4<=6,I4<=10,I4>=9),300,IF(AND(G4=1,E4=3,H4>=7,I4<=5,I4>=4),900,IF(AND(G4=1,E4=3,H4>=7,I4<=8,I4>=6),1200,IF(AND(G4=1,E4=3,H4>=7,I4>=9,I4<=10),2000,IF(AND(E4=3,G4>=2,H4<=6,I4<=4),180,IF(AND(G4>=2,E4=3,H4<=6,I4<=5,I4>=4),270,IF(AND(G4>=2,E4=3,H4<=6,I4<=8,I4>=6),360,IF(AND(G4>=2,E4=3,H4<=6,I4<=10,I4>=9),600,IF(AND(G4>=2,E4=3,H4>=7,I4>=4,#REF!<=5),900,IF(AND(G4>=2,E4=3,H4>=7,I4>=6,I4<=8),1200,IF(AND(G4>=2,E4=3,H4>=7,I4>=9,I4<=10),2000))))))))))))))))))))))))))))))))))))))))))))))))))))","v":4000},null,"2008-02-15","2028-02-15","有效","完成"]
[null,null,20110805,201110014445.10001,1,20131105,1,5,7,{"$f":"IF(AND(E5=1,G5=1,H5<=6,I5<=3),135,IF(AND(E5=1,G5=1,H5<=6,I5<=6,I5>=4),180,IF(AND(E5=1,G5=1,H5<=6,I5<=9,I5>=7),300,IF(AND(E5=1,G5=1,H5<=6,I5<=12,I5>=10),600,IF(AND(E5=1,G5=1,H5<=6,I5<=15,I5>=13),900,IF(AND(G5=1,E5=1,H5<=6,I5<=20,I5>=16),1200,IF(AND(G5=1,E5=1,H5>=7,I5<=3),600,IF(AND(E5=1,G5=1,H5>=7,I5>=4,I5<=6),900,IF(AND(G5=1,E5=1,H5>=7,I5>=7,I5<10),2000,IF(AND(G5=1,E5=1,H5>=7,I5>9,I5<13),4000,IF(AND(G5=1,E5=1,H5>=7,I5>12,I5<16),6000,IF(AND(G5=1,E5=1,H5>=7,I5>15,I5<21),8000,IF(AND(E5=1,G5>=2,H5<=6,I5<=3),270,IF(AND(E5=1,G5>=2,H5<=6,I5<=6,I5>=4),360,IF(AND(E5=1,G5>=2,H5<=6,I5<=9,I5>=7),600,IF(AND(E5=1,G5>=2,H5<=6,I5<=12,I5>=10),1200,IF(AND(E5=1,G5>=2,H5<=6,I5<=15,I5>=13),1800,IF(AND(E5=1,G5>=2,H5<=6,I5<21,I5>15),2400,IF(AND(E5=1,G5>=2,H5>=7,I5<=3),600,IF(AND(E5=1,G5>=2,H5>=7,I5>=4,I5<=6),900,IF(AND(E5=1,G5>=2,H5>=7,I5>=7,I5<10),2000,IF(AND(E5=1,G5>=2,H5>=7,I5>9,I5<13),4000,IF(AND(E5=1,G5>=2,H5>=7,I5>12,I5<16),6000,IF(AND(E5=1,G5>=2,H5>=7,I5>15,I5<21),8000,IF(AND(E5=2,G5=1,H5<=6,I5<=3),90,IF(AND(E5=2,G5=1,H5<=6,I5<=5,I5>=4),135,IF(AND(E5=2,G5=1,H5<=6,I5<=8,I5>=6),180,IF(AND(E5=2,G5=1,H5<=6,I5<=10,I5>=9),300,IF(AND(E5=2,G5=1,H5>=7,I5>=4,I5<=5),900,IF(AND(E5=2,G5=1,H5>=7,I5>=6,I5<=8),1200,IF(AND(E5=2,G5=1,H5>=7,I5>=9,I5<=10),2000,IF(AND(E5=2,G5>=2,H5<=6,I5<4),180,IF(AND(E5=2,G5>=2,H5<=6,I5<=5,I5>=4),270,IF(AND(E5=2,G5>=2,E5=2,H5<=6,I5<=8,I5>=6),360,IF(AND(E5=2,G5>=2,H5<=6,I5<=10,I5>=9),600,IF(AND(E5=2,G5>=2,H5>=7,I5>=4,I5<=5),900,IF(AND(E5=2,G5>=2,H5>=7,I5>=6,I5<=8),1200,IF(AND(E5=2,G5>=2,H5>=7,I5>=9,I5<=10),2000,IF(AND(G5=1,E5=3,H5<=6,I5<=3),90,IF(AND(G5=1,E5=3,H5<=6,I5<=5,I5>=4),135,IF(AND(G5=1,E5=3,H5<=6,I5<=8,I5>=6),180,IF(AND(G5=1,E5=3,H5<=6,I5<=10,I5>=9),300,IF(AND(G5=1,E5=3,H5>=7,I5<=5,I5>=4),900,IF(AND(G5=1,E5=3,H5>=7,I5<=8,I5>=6),1200,IF(AND(G5=1,E5=3,H5>=7,I5>=9,I5<=10),2000,IF(AND(E5=3,G5>=2,H5<=6,I5<=4),180,IF(AND(G5>=2,E5=3,H5<=6,I5<=5,I5>=4),270,IF(AND(G5>=2,E5=3,H5<=6,I5<=8,I5>=6),360,IF(AND(G5>=2,E5=3,H5<=6,I5<=10,I5>=9),600,IF(AND(G5>=2,E5=3,H5>=7,I5>=4,#REF!<=5),900,IF(AND(G5>=2,E5=3,H5>=7,I5>=6,I5<=8),1200,IF(AND(G5>=2,E5=3,H5>=7,I5>=9,I5<=10),2000))))))))))))))))))))))))))))))))))))))))))))))))))))","v":300},null,"2011-08-05","2031-08-05","有效","完成"]
[null,null,20020304,200220142541.20001,2,20030121,2,16,16,{"$f":"IF(AND(E6=1,G6=1,H6<=6,I6<=3),135,IF(AND(E6=1,G6=1,H6<=6,I6<=6,I6>=4),180,IF(AND(E6=1,G6=1,H6<=6,I6<=9,I6>=7),300,IF(AND(E6=1,G6=1,H6<=6,I6<=12,I6>=10),600,IF(AND(E6=1,G6=1,H6<=6,I6<=15,I6>=13),900,IF(AND(G6=1,E6=1,H6<=6,I6<=20,I6>=16),1200,IF(AND(G6=1,E6=1,H6>=7,I6<=3),600,IF(AND(E6=1,G6=1,H6>=7,I6>=4,I6<=6),900,IF(AND(G6=1,E6=1,H6>=7,I6>=7,I6<10),2000,IF(AND(G6=1,E6=1,H6>=7,I6>9,I6<13),4000,IF(AND(G6=1,E6=1,H6>=7,I6>12,I6<16),6000,IF(AND(G6=1,E6=1,H6>=7,I6>15,I6<21),8000,IF(AND(E6=1,G6>=2,H6<=6,I6<=3),270,IF(AND(E6=1,G6>=2,H6<=6,I6<=6,I6>=4),360,IF(AND(E6=1,G6>=2,H6<=6,I6<=9,I6>=7),600,IF(AND(E6=1,G6>=2,H6<=6,I6<=12,I6>=10),1200,IF(AND(E6=1,G6>=2,H6<=6,I6<=15,I6>=13),1800,IF(AND(E6=1,G6>=2,H6<=6,I6<21,I6>15),2400,IF(AND(E6=1,G6>=2,H6>=7,I6<=3),600,IF(AND(E6=1,G6>=2,H6>=7,I6>=4,I6<=6),900,IF(AND(E6=1,G6>=2,H6>=7,I6>=7,I6<10),2000,IF(AND(E6=1,G6>=2,H6>=7,I6>9,I6<13),4000,IF(AND(E6=1,G6>=2,H6>=7,I6>12,I6<16),6000,IF(AND(E6=1,G6>=2,H6>=7,I6>15,I6<21),8000,IF(AND(E6=2,G6=1,H6<=6,I6<=3),90,IF(AND(E6=2,G6=1,H6<=6,I6<=5,I6>=4),135,IF(AND(E6=2,G6=1,H6<=6,I6<=8,I6>=6),180,IF(AND(E6=2,G6=1,H6<=6,I6<=10,I6>=9),300,IF(AND(E6=2,G6=1,H6>=7,I6>=4,I6<=5),900,IF(AND(E6=2,G6=1,H6>=7,I6>=6,I6<=8),1200,IF(AND(E6=2,G6=1,H6>=7,I6>=9,I6<=10),2000,IF(AND(E6=2,G6>=2,H6<=6,I6<4),180,IF(AND(E6=2,G6>=2,H6<=6,I6<=5,I6>=4),270,IF(AND(E6=2,G6>=2,E6=2,H6<=6,I6<=8,I6>=6),360,IF(AND(E6=2,G6>=2,H6<=6,I6<=10,I6>=9),600,IF(AND(E6=2,G6>=2,H6>=7,I6>=4,I6<=5),900,IF(AND(E6=2,G6>=2,H6>=7,I6>=6,I6<=8),1200,IF(AND(E6=2,G6>=2,H6>=7,I6>=9,I6<=10),2000,IF(AND(G6=1,E6=3,H6<=6,I6<=3),90,IF(AND(G6=1,E6=3,H6<=6,I6<=5,I6>=4),135,IF(AND(G6=1,E6=3,H6<=6,I6<=8,I6>=6),180,IF(AND(G6=1,E6=3,H6<=6,I6<=10,I6>=9),300,IF(AND(G6=1,E6=3,H6>=7,I6<=5,I6>=4),900,IF(AND(G6=1,E6=3,H6>=7,I6<=8,I6>=6),1200,IF(AND(G6=1,E6=3,H6>=7,I6>=9,I6<=10),2000,IF(AND(E6=3,G6>=2,H6<=6,I6<=4),180,IF(AND(G6>=2,E6=3,H6<=6,I6<=5,I6>=4),270,IF(AND(G6>=2,E6=3,H6<=6,I6<=8,I6>=6),360,IF(AND(G6>=2,E6=3,H6<=6,I6<=10,I6>=9),600,IF(AND(G6>=2,E6=3,H6>=7,I6>=4,#REF!<=5),900,IF(AND(G6>=2,E6=3,H6>=7,I6>=6,I6<=8),1200,IF(AND(G6>=2,E6=3,H6>=7,I6>=9,I6<=10),2000))))))))))))))))))))))))))))))))))))))))))))))))))))","v":{"$error":"#REF!"}},null,"2002-03-04","2012-03-04",{"$f":"IF(AND(F6>1,E6=1,I6<21),\"有效\",IF(AND(F6>1,E6=2,I6<11),\"有效\",IF(AND(F6>1,E6=3,I6<11),\"有效\")))","v":false}]
[null,null,20130618,201330564215.39999,3,20131105,1,5,5,{"$f":"IF(AND(E7=1,G7=1,H7<=6,I7<=3),135,IF(AND(E7=1,G7=1,H7<=6,I7<=6,I7>=4),180,IF(AND(E7=1,G7=1,H7<=6,I7<=9,I7>=7),300,IF(AND(E7=1,G7=1,H7<=6,I7<=12,I7>=10),600,IF(AND(E7=1,G7=1,H7<=6,I7<=15,I7>=13),900,IF(AND(G7=1,E7=1,H7<=6,I7<=20,I7>=16),1200,IF(AND(G7=1,E7=1,H7>=7,I7<=3),600,IF(AND(E7=1,G7=1,H7>=7,I7>=4,I7<=6),900,IF(AND(G7=1,E7=1,H7>=7,I7>=7,I7<10),2000,IF(AND(G7=1,E7=1,H7>=7,I7>9,I7<13),4000,IF(AND(G7=1,E7=1,H7>=7,I7>12,I7<16),6000,IF(AND(G7=1,E7=1,H7>=7,I7>15,I7<21),8000,IF(AND(E7=1,G7>=2,H7<=6,I7<=3),270,IF(AND(E7=1,G7>=2,H7<=6,I7<=6,I7>=4),360,IF(AND(E7=1,G7>=2,H7<=6,I7<=9,I7>=7),600,IF(AND(E7=1,G7>=2,H7<=6,I7<=12,I7>=10),1200,IF(AND(E7=1,G7>=2,H7<=6,I7<=15,I7>=13),1800,IF(AND(E7=1,G7>=2,H7<=6,I7<21,I7>15),2400,IF(AND(E7=1,G7>=2,H7>=7,I7<=3),600,IF(AND(E7=1,G7>=2,H7>=7,I7>=4,I7<=6),900,IF(AND(E7=1,G7>=2,H7>=7,I7>=7,I7<10),2000,IF(AND(E7=1,G7>=2,H7>=7,I7>9,I7<13),4000,IF(AND(E7=1,G7>=2,H7>=7,I7>12,I7<16),6000,IF(AND(E7=1,G7>=2,H7>=7,I7>15,I7<21),8000,IF(AND(E7=2,G7=1,H7<=6,I7<=3),90,IF(AND(E7=2,G7=1,H7<=6,I7<=5,I7>=4),135,IF(AND(E7=2,G7=1,H7<=6,I7<=8,I7>=6),180,IF(AND(E7=2,G7=1,H7<=6,I7<=10,I7>=9),300,IF(AND(E7=2,G7=1,H7>=7,I7>=4,I7<=5),900,IF(AND(E7=2,G7=1,H7>=7,I7>=6,I7<=8),1200,IF(AND(E7=2,G7=1,H7>=7,I7>=9,I7<=10),2000,IF(AND(E7=2,G7>=2,H7<=6,I7<4),180,IF(AND(E7=2,G7>=2,H7<=6,I7<=5,I7>=4),270,IF(AND(E7=2,G7>=2,E7=2,H7<=6,I7<=8,I7>=6),360,IF(AND(E7=2,G7>=2,H7<=6,I7<=10,I7>=9),600,IF(AND(E7=2,G7>=2,H7>=7,I7>=4,I7<=5),900,IF(AND(E7=2,G7>=2,H7>=7,I7>=6,I7<=8),1200,IF(AND(E7=2,G7>=2,H7>=7,I7>=9,I7<=10),2000,IF(AND(G7=1,E7=3,H7<=6,I7<=3),90,IF(AND(G7=1,E7=3,H7<=6,I7<=5,I7>=4),135,IF(AND(G7=1,E7=3,H7<=6,I7<=8,I7>=6),180,IF(AND(G7=1,E7=3,H7<=6,I7<=10,I7>=9),300,IF(AND(G7=1,E7=3,H7>=7,I7<=5,I7>=4),900,IF(AND(G7=1,E7=3,H7>=7,I7<=8,I7>=6),1200,IF(AND(G7=1,E7=3,H7>=7,I7>=9,I7<=10),2000,IF(AND(E7=3,G7>=2,H7<=6,I7<=4),180,IF(AND(G7>=2,E7=3,H7<=6,I7<=5,I7>=4),270,IF(AND(G7>=2,E7=3,H7<=6,I7<=8,I7>=6),360,IF(AND(G7>=2,E7=3,H7<=6,I7<=10,I7>=9),600,IF(AND(G7>=2,E7=3,H7>=7,I7>=4,#REF!<=5),900,IF(AND(G7>=2,E7=3,H7>=7,I7>=6,I7<=8),1200,IF(AND(G7>=2,E7=3,H7>=7,I7>=9,I7<=10),2000))))))))))))))))))))))))))))))))))))))))))))))))))))","v":135},null,"2013-09-18",{"$f":"IF(AND(E7=1),DATE(YEAR($L7)+20,MONTH($L7),DAY($L7)),DATE(YEAR($L7)+10,MONTH($L7),DAY($L7)))","v":"2023-09-18"},"有效"]
[null,null,19991120,199910041251.20001,1,20031120,1,15,19,{"$f":"IF(AND(E8=1,G8=1,H8<=6,I8<=3),135,IF(AND(E8=1,G8=1,H8<=6,I8<=6,I8>=4),180,IF(AND(E8=1,G8=1,H8<=6,I8<=9,I8>=7),300,IF(AND(E8=1,G8=1,H8<=6,I8<=12,I8>=10),600,IF(AND(E8=1,G8=1,H8<=6,I8<=15,I8>=13),900,IF(AND(G8=1,E8=1,H8<=6,I8<=20,I8>=16),1200,IF(AND(G8=1,E8=1,H8>=7,I8<=3),600,IF(AND(E8=1,G8=1,H8>=7,I8>=4,I8<=6),900,IF(AND(G8=1,E8=1,H8>=7,I8>=7,I8<10),2000,IF(AND(G8=1,E8=1,H8>=7,I8>9,I8<13),4000,IF(AND(G8=1,E8=1,H8>=7,I8>12,I8<16),6000,IF(AND(G8=1,E8=1,H8>=7,I8>15,I8<21),8000,IF(AND(E8=1,G8>=2,H8<=6,I8<=3),270,IF(AND(E8=1,G8>=2,H8<=6,I8<=6,I8>=4),360,IF(AND(E8=1,G8>=2,H8<=6,I8<=9,I8>=7),600,IF(AND(E8=1,G8>=2,H8<=6,I8<=12,I8>=10),1200,IF(AND(E8=1,G8>=2,H8<=6,I8<=15,I8>=13),1800,IF(AND(E8=1,G8>=2,H8<=6,I8<21,I8>15),2400,IF(AND(E8=1,G8>=2,H8>=7,I8<=3),600,IF(AND(E8=1,G8>=2,H8>=7,I8>=4,I8<=6),900,IF(AND(E8=1,G8>=2,H8>=7,I8>=7,I8<10),2000,IF(AND(E8=1,G8>=2,H8>=7,I8>9,I8<13),4000,IF(AND(E8=1,G8>=2,H8>=7,I8>12,I8<16),6000,IF(AND(E8=1,G8>=2,H8>=7,I8>15,I8<21),8000,IF(AND(E8=2,G8=1,H8<=6,I8<=3),90,IF(AND(E8=2,G8=1,H8<=6,I8<=5,I8>=4),135,IF(AND(E8=2,G8=1,H8<=6,I8<=8,I8>=6),180,IF(AND(E8=2,G8=1,H8<=6,I8<=10,I8>=9),300,IF(AND(E8=2,G8=1,H8>=7,I8>=4,I8<=5),900,IF(AND(E8=2,G8=1,H8>=7,I8>=6,I8<=8),1200,IF(AND(E8=2,G8=1,H8>=7,I8>=9,I8<=10),2000,IF(AND(E8=2,G8>=2,H8<=6,I8<4),180,IF(AND(E8=2,G8>=2,H8<=6,I8<=5,I8>=4),270,IF(AND(E8=2,G8>=2,E8=2,H8<=6,I8<=8,I8>=6),360,IF(AND(E8=2,G8>=2,H8<=6,I8<=10,I8>=9),600,IF(AND(E8=2,G8>=2,H8>=7,I8>=4,I8<=5),900,IF(AND(E8=2,G8>=2,H8>=7,I8>=6,I8<=8),1200,IF(AND(E8=2,G8>=2,H8>=7,I8>=9,I8<=10),2000,IF(AND(G8=1,E8=3,H8<=6,I8<=3),90,IF(AND(G8=1,E8=3,H8<=6,I8<=5,I8>=4),135,IF(AND(G8=1,E8=3,H8<=6,I8<=8,I8>=6),180,IF(AND(G8=1,E8=3,H8<=6,I8<=10,I8>=9),300,IF(AND(G8=1,E8=3,H8>=7,I8<=5,I8>=4),900,IF(AND(G8=1,E8=3,H8>=7,I8<=8,I8>=6),1200,IF(AND(G8=1,E8=3,H8>=7,I8>=9,I8<=10),2000,IF(AND(E8=3,G8>=2,H8<=6,I8<=4),180,IF(AND(G8>=2,E8=3,H8<=6,I8<=5,I8>=4),270,IF(AND(G8>=2,E8=3,H8<=6,I8<=8,I8>=6),360,IF(AND(G8>=2,E8=3,H8<=6,I8<=10,I8>=9),600,IF(AND(G8>=2,E8=3,H8>=7,I8>=4,#REF!<=5),900,IF(AND(G8>=2,E8=3,H8>=7,I8>=6,I8<=8),1200,IF(AND(G8>=2,E8=3,H8>=7,I8>=9,I8<=10),2000))))))))))))))))))))))))))))))))))))))))))))))))))))","v":8000},null,"1990-11-20",{"$f":"IF(AND(E8=1),DATE(YEAR($L8)+20,MONTH($L8),DAY($L8)),DATE(YEAR($L8)+10,MONTH($L8),DAY($L8)))","v":"2010-11-20"},"有效"]
[null,null,20021212,200210241562.10001,1,20060314,1,13,16,{"$f":"IF(AND(E9=1,G9=1,H9<=6,I9<=3),135,IF(AND(E9=1,G9=1,H9<=6,I9<=6,I9>=4),180,IF(AND(E9=1,G9=1,H9<=6,I9<=9,I9>=7),300,IF(AND(E9=1,G9=1,H9<=6,I9<=12,I9>=10),600,IF(AND(E9=1,G9=1,H9<=6,I9<=15,I9>=13),900,IF(AND(G9=1,E9=1,H9<=6,I9<=20,I9>=16),1200,IF(AND(G9=1,E9=1,H9>=7,I9<=3),600,IF(AND(E9=1,G9=1,H9>=7,I9>=4,I9<=6),900,IF(AND(G9=1,E9=1,H9>=7,I9>=7,I9<10),2000,IF(AND(G9=1,E9=1,H9>=7,I9>9,I9<13),4000,IF(AND(G9=1,E9=1,H9>=7,I9>12,I9<16),6000,IF(AND(G9=1,E9=1,H9>=7,I9>15,I9<21),8000,IF(AND(E9=1,G9>=2,H9<=6,I9<=3),270,IF(AND(E9=1,G9>=2,H9<=6,I9<=6,I9>=4),360,IF(AND(E9=1,G9>=2,H9<=6,I9<=9,I9>=7),600,IF(AND(E9=1,G9>=2,H9<=6,I9<=12,I9>=10),1200,IF(AND(E9=1,G9>=2,H9<=6,I9<=15,I9>=13),1800,IF(AND(E9=1,G9>=2,H9<=6,I9<21,I9>15),2400,IF(AND(E9=1,G9>=2,H9>=7,I9<=3),600,IF(AND(E9=1,G9>=2,H9>=7,I9>=4,I9<=6),900,IF(AND(E9=1,G9>=2,H9>=7,I9>=7,I9<10),2000,IF(AND(E9=1,G9>=2,H9>=7,I9>9,I9<13),4000,IF(AND(E9=1,G9>=2,H9>=7,I9>12,I9<16),6000,IF(AND(E9=1,G9>=2,H9>=7,I9>15,I9<21),8000,IF(AND(E9=2,G9=1,H9<=6,I9<=3),90,IF(AND(E9=2,G9=1,H9<=6,I9<=5,I9>=4),135,IF(AND(E9=2,G9=1,H9<=6,I9<=8,I9>=6),180,IF(AND(E9=2,G9=1,H9<=6,I9<=10,I9>=9),300,IF(AND(E9=2,G9=1,H9>=7,I9>=4,I9<=5),900,IF(AND(E9=2,G9=1,H9>=7,I9>=6,I9<=8),1200,IF(AND(E9=2,G9=1,H9>=7,I9>=9,I9<=10),2000,IF(AND(E9=2,G9>=2,H9<=6,I9<4),180,IF(AND(E9=2,G9>=2,H9<=6,I9<=5,I9>=4),270,IF(AND(E9=2,G9>=2,E9=2,H9<=6,I9<=8,I9>=6),360,IF(AND(E9=2,G9>=2,H9<=6,I9<=10,I9>=9),600,IF(AND(E9=2,G9>=2,H9>=7,I9>=4,I9<=5),900,IF(AND(E9=2,G9>=2,H9>=7,I9>=6,I9<=8),1200,IF(AND(E9=2,G9>=2,H9>=7,I9>=9,I9<=10),2000,IF(AND(G9=1,E9=3,H9<=6,I9<=3),90,IF(AND(G9=1,E9=3,H9<=6,I9<=5,I9>=4),135,IF(AND(G9=1,E9=3,H9<=6,I9<=8,I9>=6),180,IF(AND(G9=1,E9=3,H9<=6,I9<=10,I9>=9),300,IF(AND(G9=1,E9=3,H9>=7,I9<=5,I9>=4),900,IF(AND(G9=1,E9=3,H9>=7,I9<=8,I9>=6),1200,IF(AND(G9=1,E9=3,H9>=7,I9>=9,I9<=10),2000,IF(AND(E9=3,G9>=2,H9<=6,I9<=4),180,IF(AND(G9>=2,E9=3,H9<=6,I9<=5,I9>=4),270,IF(AND(G9>=2,E9=3,H9<=6,I9<=8,I9>=6),360,IF(AND(G9>=2,E9=3,H9<=6,I9<=10,I9>=9),600,IF(AND(G9>=2,E9=3,H9>=7,I9>=4,#REF!<=5),900,IF(AND(G9>=2,E9=3,H9>=7,I9>=6,I9<=8),1200,IF(AND(G9>=2,E9=3,H9>=7,I9>=9,I9<=10),2000))))))))))))))))))))))))))))))))))))))))))))))))))))","v":8000},null,"2002-12-12","2022-12-12","有效"]

{"sheet":"Sheet3","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}