{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Database Format","AQ Rulemaking Schedule"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Database Format","index":0,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Rule","Task #","Date"]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},1,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F7,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H7,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J7)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},{"$f":"B2+1","v":2},{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F8,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H8,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J8)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},{"$f":"B3+1","v":3},{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F9,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H9,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J9)))","v":"2009-07-31"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},4,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F10,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H10,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J10)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},5,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F11,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H11,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J11)))","v":"2009-08-10"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},6,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F13,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H13,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J13)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},7,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F14,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H14,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J14)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},8,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F16,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H16,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J16)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},9,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F17,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H17,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J17)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},10,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F18,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H18,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J18)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},11,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F19,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H19,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J19)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},12,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F21,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H21,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J21)))","v":"2010-05-24"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},13,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F22,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H22,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J22)))","v":"2010-05-25"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},14,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F23,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H23,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J23)))","v":"2010-05-28"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},15,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F24,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H24,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J24)))","v":"2010-06-04"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},16,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F25,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H25,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J25)))","v":"2010-06-07"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},17,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F26,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H26,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J26)))","v":"2010-06-09"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},18,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F28,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H28,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J28)))","v":"2010-06-15"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},19,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F29,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H29,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J29)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},20,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F30,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H30,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J30)))","v":"2010-06-15"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},21,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F31,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H31,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J31)))","v":"2010-06-16"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},22,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F32,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H32,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J32)))","v":"2010-07-01"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},23,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F33,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H33,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J33)))","v":"2010-07-15"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},24,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F34,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H34,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J34)))","v":"2010-07-21"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},25,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F37,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H37,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J37)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},26,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F38,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H38,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J38)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},27,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F39,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H39,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J39)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},28,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F40,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H40,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J40)))","v":"00:00:00"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},29,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F42,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H42,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J42)))","v":"2010-08-03"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},30,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F43,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H43,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J43)))","v":"2010-08-10"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},31,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F44,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H44,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J44)))","v":"2010-08-20"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},32,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F45,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H45,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J45)))","v":"2010-08-26"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},33,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F46,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H46,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J46)))","v":"2010-09-02"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},34,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F47,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H47,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J47)))","v":"2010-09-13"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},35,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F48,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H48,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J48)))","v":"2010-09-30"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},36,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F50,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H50,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J50)))","v":"2010-10-05"}]
[{"$f":"MID('AQ Rulemaking Schedule'!$A$2,13,255)","v":"RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)"},37,{"$f":"IF('AQ Rulemaking Schedule'!$V$14=1,'AQ Rulemaking Schedule'!F51,IF('AQ Rulemaking Schedule'!$V$14=2,'AQ Rulemaking Schedule'!H51,IF('AQ Rulemaking Schedule'!$V$14=3,'AQ Rulemaking Schedule'!J51)))","v":"2010-10-21"}]

{"sheet":"AQ Rulemaking Schedule","index":1,"n_rows":54,"n_cols":22,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,0,18],[1,0,1,4],[2,0,2,4],[2,16,2,18],[2,12,2,14],[2,5,2,9],[1,5,1,7]]}
["Air Quality Worksheet for Rulemaking Schedule"]
["Rule Title: RAI-874 Expand GHG Reporting & Establish Fee Schedule (Permanent)",null,null,null,null,"Clear All Blackouts"]
["Project Lead & Phone: Andrea Curtis  503.229.6866",null,null,null,null,"Date",null,null,null,null,null,null,"Day of Week",null,null,null,"Days since previous act"]
["DA ","#","DB ","Develop Rulemaking ","N/A","Option 1","Calc 1","Option 2","Calc 2","Option 3","Calc 3",null,"Option 1","Option 2","Option 3",null,"Option 1","Option 2","Option 3"]
[null,null,null,"Current Option in Use >"]
[null,null,null,"Start Rulemaking Proposal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Sunday"]
[null,{"$f":"IF(E7=\"\",IF($V$14=1,IF(OR(F7=\"\",$F$8=\"\"),0,$F$8-F7),IF($V$14=2,IF(OR(H7=\"\",$H$8=\"\"),0,$H$8-H7),IF($V$14=3,IF(OR(J7=\"\",$J$8=\"\"),0,$J$8-J7),\"NA\"))),\"NA\")","v":0},null,"Route Start Rulemaking Proposal to Section Mgr (at least 5 days prior to DA due date)",null,null,{"$f":"IF(F7<>\"\",F7,\"\")","v":""},null,{"$f":"IF(H7<>\"\",H7,\"\")","v":""},null,{"$f":"IF(J7<>\"\",J7,\"\")","v":""},null,{"$f":"IF(F7=\"\",\"\",LOOKUP(WEEKDAY(G7),DayArray))","v":""},{"$f":"IF(H7=\"\",\"\",LOOKUP(WEEKDAY(I7),DayArray))","v":""},{"$f":"IF(J7=\"\",\"\",LOOKUP(WEEKDAY(J7),DayArray))","v":""},null,null,null,null,null,2,"Monday"]
["IN",{"$f":"IF(E8=\"\",IF($V$14=1,IF(OR(F8=\"\",$F$9=\"\"),0,$F$9-F8),IF($V$14=2,IF(OR(H8=\"\",$H$9=\"\"),0,$H$9-H8),IF($V$14=3,IF(OR(J8=\"\",$J$9=\"\"),0,$J$9-J8),\"NA\"))),\"NA\")","v":0},null,"Route Start Rulemaking Proposal to Division Administrator  (at least 1 week prior to OD due date)",null,null,{"$f":"IF(E8=\"\",IF(F8<>\"\",F8,\"\"),G7)","v":""},null,{"$f":"IF(E8=\"\",IF(H8<>\"\",H8,\"\"),I7)","v":""},null,{"$f":"IF(E8=\"\",IF(J8<>\"\",J8,\"\"),K7)","v":""},null,"","","",null,{"$f":"IF(E8<>\"\",\"\",IF(AND(G7<>\"\",G8<>\"\"),G8-G7,\"\"))","v":""},{"$f":"IF(E8<>\"\",\"\",IF(AND(I7<>\"\",I8<>\"\"),I8-I7,\"\"))","v":""},{"$f":"IF(E8<>\"\",\"\",IF(AND(K7<>\"\",K8<>\"\"),K8-K7,\"\"))","v":""},null,3,"Tuesday"]
["OUT",null,1,"Submit Start Rulemaking Proposal to OD (9:00 a.m.)  ",null,null,"","2009-07-31","2009-07-31",null,"",null,"","Friday","",null,{"$f":"IF(E9<>\"\",\"\",IF(AND(G8<>\"\",G9<>\"\"),G9-G8,\"\"))","v":""},{"$f":"IF(E9<>\"\",\"\",IF(AND(I8<>\"\",I9<>\"\"),I9-I8,\"\"))","v":""},{"$f":"IF(E9<>\"\",\"\",IF(AND(K8<>\"\",K9<>\"\"),K9-K8,\"\"))","v":""},null,4,"Wednesday"]
["APT",null,null,"Dry Run Start Rulemaking Proposal w/Division Administrator & others (the Thursday before the EMT meeting) ",null,null,"",null,"",null,"",null,"","","",null,{"$f":"IF(E10<>\"\",\"\",IF(AND(G9<>\"\",G10<>\"\"),G10-G9,\"\"))","v":""},{"$f":"IF(E10<>\"\",\"\",IF(AND(I9<>\"\",I10<>\"\"),I10-I9,\"\"))","v":""},{"$f":"IF(E10<>\"\",\"\",IF(AND(K9<>\"\",K10<>\"\"),K10-K9,\"\"))","v":""},null,5,"Thursday"]
[null,null,2,"Start Rulemaking Proposal meeting – EMT  ",null,null,"","2009-08-10","2009-08-10",null,"",null,"","Monday","",null,{"$f":"IF(E11<>\"\",\"\",IF(AND(G10<>\"\",G11<>\"\"),G11-G10,\"\"))","v":""},{"$f":"IF(E11<>\"\",\"\",IF(AND(I10<>\"\",I11<>\"\"),I11-I10,\"\"))","v":""},{"$f":"IF(E11<>\"\",\"\",IF(AND(K10<>\"\",K11<>\"\"),K11-K10,\"\"))","v":""},null,6,"Friday"]
[null,null,null,"Fee Approval",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Saturday"]
[null,{"$f":"IF(E13=\"\",IF($V$14=1,IF(OR(F13=\"\",F28=\"\"),0,F28-F13-1),IF($V$14=2,IF(OR(H13=\"\",H28=\"\"),0,H28-H13-1),IF($V$14=3,IF(OR(J13=\"\",J28=\"\"),0,J28-J13-1),\"NA\"))),\"NA\")","v":"NA"},null,"*Request DAS to approve new & increased fees (at least 30 days prior to filing notice w/SOS or date rule is effective)","x",null,{"$f":"IF(E13=\"\",IF(F13<>\"\",F13,\"\"),G11)","v":""},null,{"$f":"IF(E13=\"\",IF(H13<>\"\",H13,\"\"),I11)","v":"2009-08-10"},null,{"$f":"IF(E13=\"\",IF(J13<>\"\",J13,\"\"),K11)","v":""},null,"","","",null,{"$f":"IF(E13<>\"\",\"\",IF(AND(G11<>\"\",G13<>\"\"),G13-G11,\"\"))","v":""},{"$f":"IF(E13<>\"\",\"\",IF(AND(I11<>\"\",I13<>\"\"),I13-I11,\"\"))","v":""},{"$f":"IF(E13<>\"\",\"\",IF(AND(K11<>\"\",K13<>\"\"),K13-K11,\"\"))","v":""}]
[null,null,null,"*Obtain DAS approval or denial of fees  (goal = within 30 days of submittal)  If DAS Approval is Not Required, DAS must still be notified of Fee Changes. DAS enters all agency fees into a database.","x",null,"",null,"2009-08-10",null,"",null,{"$f":"IF(F14=\"\",\"\",LOOKUP(WEEKDAY(G14),DayArray))","v":""},"","",null,{"$f":"IF(E14<>\"\",\"\",IF(AND(G13<>\"\",G14<>\"\"),G14-G13,\"\"))","v":""},{"$f":"IF(E14<>\"\",\"\",IF(AND(I13<>\"\",I14<>\"\"),I14-I13,\"\"))","v":""},{"$f":"IF(E14<>\"\",\"\",IF(AND(K13<>\"\",K14<>\"\"),K14-K13,\"\"))","v":""},null,1,2]
[null,null,null,"Draft Notice of Proposed Rulemaking Package"]
[null,{"$f":"IF(E16=\"\",IF($V$14=1,IF(OR(F16=\"\",$F$17=\"\"),0,$F$17-F16),IF($V$14=2,IF(OR(H16=\"\",$H$17=\"\"),0,$H$17-H16),IF($V$14=3,IF(OR(J16=\"\",$J$17=\"\"),0,$J$17-J16),\"NA\"))),\"NA\")","v":"NA"},null,"Route draft Notice of Proposed Rulemaking package to Section Mgr (at least 5 days prior to DA due date)","x",null,{"$f":"IF(E16=\"\",IF(F16<>\"\",F16,\"\"),G14)","v":""},null,{"$f":"IF(E16=\"\",IF(H16<>\"\",H16,\"\"),I14)","v":"2009-08-10"},null,{"$f":"IF(E16=\"\",IF(J16<>\"\",J16,\"\"),K14)","v":""},null,{"$f":"IF(F16=\"\",\"\",LOOKUP(WEEKDAY(G16),DayArray))","v":""},"","",null,{"$f":"IF(E16<>\"\",\"\",IF(AND(G14<>\"\",G16<>\"\"),G16-G14,\"\"))","v":""},{"$f":"IF(E16<>\"\",\"\",IF(AND(I14<>\"\",I16<>\"\"),I16-I14,\"\"))","v":""},{"$f":"IF(E16<>\"\",\"\",IF(AND(K14<>\"\",K16<>\"\"),K16-K14,\"\"))","v":""},null,"Project Lead & Phone: "]
["IN",{"$f":"IF(E17=\"\",IF($V$14=1,IF(OR(F17=\"\",$F$18=\"\"),0,$F$18-F17),IF($V$14=2,IF(OR(H17=\"\",$H$18=\"\"),0,$H$18-H17),IF($V$14=3,IF(OR(J17=\"\",$J$18=\"\"),0,$J$18-J17),\"NA\"))),\"NA\")","v":"NA"},null,"Route draft Notice of Proposed Rulemaking package to Division Administrator (at least 1 week prior to submitting to reviewers)","x",null,{"$f":"IF(E17=\"\",IF(F17<>\"\",F17,\"\"),G16)","v":""},null,"2009-08-10",null,"",null,"","","",null,{"$f":"IF(E17<>\"\",\"\",IF(AND(G16<>\"\",G17<>\"\"),G17-G16,\"\"))","v":""},{"$f":"IF(E17<>\"\",\"\",IF(AND(I16<>\"\",I17<>\"\"),I17-I16,\"\"))","v":""},{"$f":"IF(E17<>\"\",\"\",IF(AND(K16<>\"\",K17<>\"\"),K17-K16,\"\"))","v":""},null,"Andrea Curtis  503.229.6866",{"$f":"$U$16&U17","v":"Project Lead & Phone: Andrea Curtis  503.229.6866"}]
["OUT",null,3,"Submit draft Notice of Proposed Rulemaking package to reviewers (author)","x",null,{"$f":"IF(E18=\"\",IF(F18<>\"\",F18,\"\"),G17)","v":""},null,"2009-08-10",null,"",null,"","","",null,{"$f":"IF(E18<>\"\",\"\",IF(AND(G17<>\"\",G18<>\"\"),G18-G17,\"\"))","v":""},{"$f":"IF(E18<>\"\",\"\",IF(AND(I17<>\"\",I18<>\"\"),I18-I17,\"\"))","v":""},{"$f":"IF(E18<>\"\",\"\",IF(AND(K17<>\"\",K18<>\"\"),K18-K17,\"\"))","v":""},null,"Brandy Albertson  503.229.6459",{"$f":"$U$16&U18","v":"Project Lead & Phone: Brandy Albertson  503.229.6459"}]
[null,null,null,"Reviewer comments to author","x",null,"",null,"2009-08-10",null,"",null,"","","",null,{"$f":"IF(E19<>\"\",\"\",IF(AND(G18<>\"\",G19<>\"\"),G19-G18,\"\"))","v":""},{"$f":"IF(E19<>\"\",\"\",IF(AND(I18<>\"\",I19<>\"\"),I19-I18,\"\"))","v":""},{"$f":"IF(E19<>\"\",\"\",IF(AND(K18<>\"\",K19<>\"\"),K19-K18,\"\"))","v":""},null,"Brian Finneran  503.229.6278","Project Lead & Phone: Brian Finneran  503.229.6278"]
[null,null,null,"Final Notice of Proposed Rulemaking Package",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dave Nordberg  503.229.5519","Project Lead & Phone: Dave Nordberg  503.229.5519"]
[null,{"$f":"IF(E21=\"\",IF($V$14=1,IF(OR(F21=\"\",$F$22=\"\"),0,$F$22-F21),IF($V$14=2,IF(OR(H21=\"\",$H$22=\"\"),0,$H$22-H21),IF($V$14=3,IF(OR(J21=\"\",$J$22=\"\"),0,$J$22-J21),\"NA\"))),\"NA\")","v":1},null,"Route final Notice of Proposed Rulemaking package to Section Mgr (at least 5 days prior to DA due date)",null,null,{"$f":"IF(E21=\"\",IF(F21<>\"\",F21,\"\"),G19)","v":""},"2010-05-24",{"$f":"IF(E21=\"\",IF(H21<>\"\",H21,\"\"),I19)","v":"2010-05-24"},null,{"$f":"IF(E21=\"\",IF(J21<>\"\",J21,\"\"),K19)","v":""},null,{"$f":"IF(F21=\"\",\"\",LOOKUP(WEEKDAY(G21),DayArray))","v":""},"Monday","",null,{"$f":"IF(E21<>\"\",\"\",IF(AND(G19<>\"\",G21<>\"\"),G21-G19,\"\"))","v":""},{"$f":"IF(E21<>\"\",\"\",IF(AND(I19<>\"\",I21<>\"\"),I21-I19,\"\"))","v":287},{"$f":"IF(E21<>\"\",\"\",IF(AND(K19<>\"\",K21<>\"\"),K21-K19,\"\"))","v":""},null,"David Collier 503.229.5177","Project Lead & Phone: David Collier 503.229.5177"]
["IN",{"$f":"IF(E22=\"\",IF($V$14=1,IF(OR(F22=\"\",$F$23=\"\"),0,$F$23-F22),IF($V$14=2,IF(OR(H22=\"\",$H$23=\"\"),0,$H$23-H22),IF($V$14=3,IF(OR(J22=\"\",$J$23=\"\"),0,$J$23-J22),\"NA\"))),\"NA\")","v":3},null,"Route final Notice of Proposed Rulemaking package to Division Administrator (at least 1 week prior to submitting to reviewers)",null,null,"","2010-05-25","2010-05-25",null,"",null,"","Tuesday","",null,{"$f":"IF(E22<>\"\",\"\",IF(AND(G21<>\"\",G22<>\"\"),G22-G21,\"\"))","v":""},{"$f":"IF(E22<>\"\",\"\",IF(AND(I21<>\"\",I22<>\"\"),I22-I21,\"\"))","v":1},{"$f":"IF(E22<>\"\",\"\",IF(AND(K21<>\"\",K22<>\"\"),K22-K21,\"\"))","v":""},null,"Ed Druback  503.667.8414 x55014","Project Lead & Phone: Ed Druback  503.667.8414 x55014"]
["OUT",null,4,"Submit final Notice of Proposed Rulemaking package for concurrence review",null,null,"","2010-05-28","2010-05-28",null,"",null,"","Friday","",null,{"$f":"IF(E23<>\"\",\"\",IF(AND(G22<>\"\",G23<>\"\"),G23-G22,\"\"))","v":""},{"$f":"IF(E23<>\"\",\"\",IF(AND(I22<>\"\",I23<>\"\"),I23-I22,\"\"))","v":3},{"$f":"IF(E23<>\"\",\"\",IF(AND(K22<>\"\",K23<>\"\"),K23-K22,\"\"))","v":""},null,"Gregg Dahmen  503.229.5108","Project Lead & Phone: Gregg Dahmen  503.229.5108"]
[null,null,null,"Concurrence reviews due to author",null,null,"","2010-06-04","2010-06-04",null,"",null,"","Friday","",null,{"$f":"IF(E24<>\"\",\"\",IF(AND(G23<>\"\",G24<>\"\"),G24-G23,\"\"))","v":""},{"$f":"IF(E24<>\"\",\"\",IF(AND(I23<>\"\",I24<>\"\"),I24-I23,\"\"))","v":7},{"$f":"IF(E24<>\"\",\"\",IF(AND(K23<>\"\",K24<>\"\"),K24-K23,\"\"))","v":""},null,"Jerry Coffer  503.731.3050 x229","Project Lead & Phone: Jerry Coffer  503.731.3050 x229"]
[null,null,null,"Submit final Notice of Proposed Rulemaking package for Division Administrator for approval",null,null,"","2010-06-07","2010-06-07",null,"",null,"","Monday","",null,{"$f":"IF(E25<>\"\",\"\",IF(AND(G24<>\"\",G25<>\"\"),G25-G24,\"\"))","v":""},{"$f":"IF(E25<>\"\",\"\",IF(AND(I24<>\"\",I25<>\"\"),I25-I24,\"\"))","v":3},{"$f":"IF(E25<>\"\",\"\",IF(AND(K24<>\"\",K25<>\"\"),K25-K24,\"\"))","v":""},null,"Jerry Ebersole 503.229.6974","Project Lead & Phone: Jerry Ebersole 503.229.6974"]
["IN",null,null,"Division Administrator authorizes publication of Notice",null,null,"","2010-06-09","2010-06-09",null,"",null,"","Wednesday","",null,{"$f":"IF(E26<>\"\",\"\",IF(AND(G25<>\"\",G26<>\"\"),G26-G25,\"\"))","v":""},{"$f":"IF(E26<>\"\",\"\",IF(AND(I25<>\"\",I26<>\"\"),I26-I25,\"\"))","v":2},{"$f":"IF(E26<>\"\",\"\",IF(AND(K25<>\"\",K26<>\"\"),K26-K25,\"\"))","v":""},null,"Karen White-Fallon  503.378.5315","Project Lead & Phone: Karen White-Fallon  503.378.5315"]
[null,null,null,"Public Notice, Hearing & Comment",null,null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,"Kevin Downing  503.229.6549","Project Lead & Phone: Kevin Downing  503.229.6549"]
["OUT",null,5,"Send Notice to Secretary of State for Bulletin (by 15th;earlier if weekend/holiday)",null,null,{"$f":"IF(E28=\"\",IF(F28<>\"\",F28,\"\"),G26)","v":""},"2010-06-15",{"$f":"IF(E28=\"\",IF(H28<>\"\",H28,\"\"),I26)","v":"2010-06-15"},null,{"$f":"IF(E28=\"\",IF(J28<>\"\",J28,\"\"),K26)","v":""},null,"","Tuesday",{"$f":"IF(J28=\"\",\"\",LOOKUP(WEEKDAY(J28),DayArray))","v":""},null,{"$f":"IF(E28<>\"\",\"\",IF(AND(G26<>\"\",G28<>\"\"),G28-G26,\"\"))","v":""},{"$f":"IF(E28<>\"\",\"\",IF(AND(I26<>\"\",I28<>\"\"),I28-I26,\"\"))","v":6},{"$f":"IF(E28<>\"\",\"\",IF(AND(K26<>\"\",K28<>\"\"),K28-K26,\"\"))","v":""},null,"Larry Calkins  541.567.8297 x25","Project Lead & Phone: Larry Calkins  541.567.8297 x25"]
[null,{"$f":"IF(E29=\"\",IF($V$14=1,IF(OR(F29=\"\",F33=\"\"),0,F33-F29),IF($V$14=2,IF(OR(H29=\"\",H33=\"\"),0,H33-H29),IF($V$14=3,IF(OR(J29=\"\",J33=\"\"),0,J33-J29),\"NA\"))),\"NA\")","v":"NA"},null,"Send Notice to EPA (at least 45 days prior to hearing)  Only applies to SIP rules – make sure the AG’s office has reviewed the rule prior to submitting it to EPA","x",null,"",null,"2010-06-15",null,"",null,{"$f":"IF(F29=\"\",\"\",LOOKUP(WEEKDAY(G29),DayArray))","v":""},"","",null,{"$f":"IF(E29<>\"\",\"\",IF(AND(G28<>\"\",G29<>\"\"),G29-G28,\"\"))","v":""},{"$f":"IF(E29<>\"\",\"\",IF(AND(I28<>\"\",I29<>\"\"),I29-I28,\"\"))","v":""},{"$f":"IF(E29<>\"\",\"\",IF(AND(K28<>\"\",K29<>\"\"),K29-K28,\"\"))","v":""},null,"Marianne Fitzgerald  503.229.5946","Project Lead & Phone: Marianne Fitzgerald  503.229.5946"]
[null,{"$f":"IF(E30=\"\",IF($V$14=1,IF(OR(F30=\"\",F33=\"\"),0,F33-F30-1),IF($V$14=2,IF(OR(H30=\"\",H33=\"\"),0,H33-H30-1),IF($V$14=3,IF(OR(J30=\"\",J33=\"\"),0,J33-J30-1),\"NA\"))),\"NA\")","v":29},null,"Mail Notice to mailing & e-mail lists  (at least 28 days prior to hearing, excluding mailing date, if a SIP rule, must be mailed 30 days prior to hearing)",null,null,"","2010-06-15","2010-06-15",null,"",null,"","Tuesday","",null,"",0,"",null,"Melinda Mahoney  503.731.3050 x","Project Lead & Phone: Melinda Mahoney  503.731.3050 x"]
[null,{"$f":"IF(E31=\"\",IF($V$14=1,IF(OR(F31=\"\",F33=\"\"),0,F33-F31-1),IF($V$14=2,IF(OR(H31=\"\",H33=\"\"),0,H33-H31-1),IF($V$14=3,IF(OR(J31=\"\",J33=\"\"),0,J33-J31-1),\"NA\"))),\"NA\")","v":28},null,"Publish legal ad in local newspapers (at least 30 days prior to hearing,  excluding publication and hearing date)  Applies whenever hearings held.",null,null,"","2010-06-16","2010-06-16",null,"",null,"","Wednesday","",null,"",1,"",null,"Phil Allen  503.229.6904","Project Lead & Phone: Phil Allen  503.229.6904"]
[null,{"$f":"IF(E32=\"\",IF($V$14=1,IF(OR(F32=\"\",$F$51=\"\"),0,$F$51-F32),IF($V$14=2,IF(OR(H32=\"\",$H$51=\"\"),0,$H$51-H32),IF($V$14=3,IF(OR(J32=\"\",$J$51=\"\"),0,$J$51-J32),\"NA\"))),\"NA\")","v":112},6,"Notice published in Bulletin (1st of Month; 21 days before effective date)",null,null,"","2010-07-01","2010-07-01",null,"",null,"",{"$f":"IF(H32=\"\",\"\",LOOKUP(WEEKDAY(I32),DayArray))","v":"Thursday"},"",null,"",15,"",null,"Rachel Sakata  503.229.5659","Project Lead & Phone: Rachel Sakata  503.229.5659"]
[null,{"$f":"IF(E33=\"\",IF($V$14=1,IF(OR(F32=\"\",F33=\"\"),0,F33-F32-1),IF($V$14=2,IF(OR(H32=\"\",H33=\"\"),0,H33-H32-1),IF($V$14=3,IF(OR(J32=\"\",J33=\"\"),0,J33-J32-1),\"NA\"))),\"NA\")","v":13},7,"Public Hearing(s)  (At least 15 days after notice in Bulletin, excluding pub date) (An evening time slot will allow the working public a greater opportunity to attend. This is STRONGLY advised!)",null,null,"","2010-07-15","2010-07-15",null,"",null,"","Thursday","",null,"",14,"",null,"Sarah Armitage  503.229.5186","Project Lead & Phone: Sarah Armitage  503.229.5186"]
[null,{"$f":"IF(E34=\"\",IF($V$14=1,IF(OR(F33=\"\",$F$34=\"\"),0,$F$34-F33),IF($V$14=2,IF(OR(H33=\"\",$H$34=\"\"),0,$H$34-H33),IF($V$14=3,IF(OR(J33=\"\",$J$34=\"\"),0,$J$34-J33),\"NA\"))),\"NA\")","v":6},8,"Public Comment deadline  (usually 3 to 7 days after  hearing)",null,null,"","2010-07-21","2010-07-21",null,"",null,"","Wednesday","",null,"",6,"",null,"Shari Jay  503.731.3050 x","Project Lead & Phone: Shari Jay  503.731.3050 x"]
[null,null,null,"Adopt Rule  - EQC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNKNOWN AT THIS TIME","Project Lead & Phone: UNKNOWN AT THIS TIME"]
[null,null,null,"Draft Final Rulemaking Package"]
[null,{"$f":"IF(E37=\"\",IF($V$14=1,IF(OR(F37=\"\",$F$38=\"\"),0,$F$38-F37),IF($V$14=2,IF(OR(H37=\"\",$H$38=\"\"),0,$H$38-H37),IF($V$14=3,IF(OR(J37=\"\",$J$38=\"\"),0,$J$38-J37),\"NA\"))),\"NA\")","v":"NA"},null,"Route draft Final Rulemaking package to Section Mgr (at least 5 days prior to DA due date)","x",null,{"$f":"IF(E37=\"\",IF(F37<>\"\",F37,\"\"),G34)","v":""},null,{"$f":"IF(E37=\"\",IF(H37<>\"\",H37,\"\"),I34)","v":"2010-07-21"},null,{"$f":"IF(E37=\"\",IF(J37<>\"\",J37,\"\"),K34)","v":""},null,"","","",null,{"$f":"IF(E37<>\"\",\"\",IF(AND(G34<>\"\",G37<>\"\"),G37-G34,\"\"))","v":""},{"$f":"IF(E37<>\"\",\"\",IF(AND(I34<>\"\",I37<>\"\"),I37-I34,\"\"))","v":""},{"$f":"IF(E37<>\"\",\"\",IF(AND(K34<>\"\",K37<>\"\"),K37-K34,\"\"))","v":""}]
["IN",{"$f":"IF(E38=\"\",IF($V$14=1,IF(OR(F38=\"\",$F$39=\"\"),0,$F$39-F38),IF($V$14=2,IF(OR(H38=\"\",$H$39=\"\"),0,$H$39-H38),IF($V$14=3,IF(OR(J38=\"\",$J$39=\"\"),0,$J$39-J38),\"NA\"))),\"NA\")","v":"NA"},null,"Route draft Final Rulemaking package to Division Administrator (at least 1 week prior to submitting to reviewers)","x",null,"",null,"2010-07-21",null,"",null,"","","",null,{"$f":"IF(E38<>\"\",\"\",IF(AND(G37<>\"\",G38<>\"\"),G38-G37,\"\"))","v":""},{"$f":"IF(E38<>\"\",\"\",IF(AND(I37<>\"\",I38<>\"\"),I38-I37,\"\"))","v":""},{"$f":"IF(E38<>\"\",\"\",IF(AND(K37<>\"\",K38<>\"\"),K38-K37,\"\"))","v":""}]
["OUT",null,9,"Distribute draft Final Rulemaking package to reviewers (author)","x",null,"",null,"2010-07-21",null,"",null,"","","",null,{"$f":"IF(E39<>\"\",\"\",IF(AND(G38<>\"\",G39<>\"\"),G39-G38,\"\"))","v":""},{"$f":"IF(E39<>\"\",\"\",IF(AND(I38<>\"\",I39<>\"\"),I39-I38,\"\"))","v":""},{"$f":"IF(E39<>\"\",\"\",IF(AND(K38<>\"\",K39<>\"\"),K39-K38,\"\"))","v":""}]
[null,null,10,"Reviewer comments due to author","x",null,"",null,"2010-07-21",null,"",null,"","","",null,{"$f":"IF(E40<>\"\",\"\",IF(AND(G39<>\"\",G40<>\"\"),G40-G39,\"\"))","v":""},{"$f":"IF(E40<>\"\",\"\",IF(AND(I39<>\"\",I40<>\"\"),I40-I39,\"\"))","v":""},{"$f":"IF(E40<>\"\",\"\",IF(AND(K39<>\"\",K40<>\"\"),K40-K39,\"\"))","v":""}]
[null,null,null,"Final Rulemaking Package"]
[null,{"$f":"IF(E42=\"\",IF($V$14=1,IF(OR(F42=\"\",$F$43=\"\"),0,$F$43-F42),IF($V$14=2,IF(OR(H42=\"\",$H$43=\"\"),0,$H$43-H42),IF($V$14=3,IF(OR(J42=\"\",$J$43=\"\"),0,$J$43-J42),\"NA\"))),\"NA\")","v":7},null,"Route Final Rulemaking package to Section Mgr (at least 5 days prior to DA due date)",null,null,{"$f":"IF(E42=\"\",IF(F42<>\"\",F42,\"\"),G40)","v":""},"2010-08-03",{"$f":"IF(E42=\"\",IF(H42<>\"\",H42,\"\"),I40)","v":"2010-08-03"},null,{"$f":"IF(E42=\"\",IF(J42<>\"\",J42,\"\"),K40)","v":""},null,{"$f":"IF(F42=\"\",\"\",LOOKUP(WEEKDAY(G42),DayArray))","v":""},"Tuesday","",null,{"$f":"IF(E42<>\"\",\"\",IF(AND(G40<>\"\",G42<>\"\"),G42-G40,\"\"))","v":""},{"$f":"IF(E42<>\"\",\"\",IF(AND(I40<>\"\",I42<>\"\"),I42-I40,\"\"))","v":13},{"$f":"IF(E42<>\"\",\"\",IF(AND(K40<>\"\",K42<>\"\"),K42-K40,\"\"))","v":""}]
["IN",{"$f":"IF(E43=\"\",IF($V$14=1,IF(OR(F43=\"\",$F$44=\"\"),0,$F$44-F43),IF($V$14=2,IF(OR(H43=\"\",$H$44=\"\"),0,$H$44-H43),IF($V$14=3,IF(OR(J43=\"\",$J$44=\"\"),0,$J$44-J43),\"NA\"))),\"NA\")","v":10},null,"Route Final Rulemaking package to Division Administrator (at least 1 week prior to submitting to reviewers)",null,null,"","2010-08-10","2010-08-10",null,"",null,{"$f":"IF(F43=\"\",\"\",LOOKUP(WEEKDAY(G43),DayArray))","v":""},"Tuesday","",null,{"$f":"IF(E43<>\"\",\"\",IF(AND(G42<>\"\",G43<>\"\"),G43-G42,\"\"))","v":""},{"$f":"IF(E43<>\"\",\"\",IF(AND(I42<>\"\",I43<>\"\"),I43-I42,\"\"))","v":7},{"$f":"IF(E43<>\"\",\"\",IF(AND(K42<>\"\",K43<>\"\"),K43-K42,\"\"))","v":""}]
["OUT",null,11,"Route Final Rulemaking package for concurrence review",null,null,"","2010-08-20","2010-08-20",null,"",null,"","Friday","",null,"",10,""]
[null,null,12,"Concurrence reviews due to author",null,null,"","2010-08-26","2010-08-26",null,"",null,{"$f":"IF(F45=\"\",\"\",LOOKUP(WEEKDAY(G45),DayArray))","v":""},"Thursday","",null,"",6,""]
["IN",null,13,"Route Final Rulemaking package to Division Administrator for approval for submittal to OD",null,null,"","2010-09-02","2010-09-02",null,"",null,{"$f":"IF(F46=\"\",\"\",LOOKUP(WEEKDAY(G46),DayArray))","v":""},"Thursday","",null,"",7,""]
["OUT",{"$f":"IF(E47=\"\",IF($V$14=1,IF(OR(F47=\"\",$F$48=\"\"),0,$F$48-F47),IF($V$14=2,IF(OR(H47=\"\",$H$48=\"\"),0,$H$48-H47),IF($V$14=3,IF(OR(J47=\"\",$J$48=\"\"),0,$J$48-J47),\"NA\"))),\"NA\")","v":17},null,"Submit Final Rulemaking package to OD for signature and distribution (5:00 p.m.)  (e-mail and 1 hard copy w/signed staff report) (At least 21 days before mailing to EQC.",null,null,"","2010-09-13","2010-09-13",null,"",null,{"$f":"IF(F47=\"\",\"\",LOOKUP(WEEKDAY(G47),DayArray))","v":""},"Monday","",null,"",11,""]
[null,{"$f":"IF(E48=\"\",IF($V$14=1,IF(OR(F48=\"\",$F$51=\"\"),0,$F$51-F48),IF($V$14=2,IF(OR(H48=\"\",$H$51=\"\"),0,$H$51-H48),IF($V$14=3,IF(OR(J48=\"\",$J$51=\"\"),0,$J$51-J48),\"NA\"))),\"NA\")","v":21},14,"OD mails EQC Staff Report w/attachments to EQC (At least 24 days before EQC meeting date.",null,null,"","2010-09-30","2010-09-30",null,"",null,{"$f":"IF(F48=\"\",\"\",LOOKUP(WEEKDAY(G48),DayArray))","v":""},"Thursday","",null,"",17,""]
[null,null,null,"EQC Meeting"]
["APT",null,null,"Dry run EQC Presentation  w/ Division Administrator  & others",null,null,{"$f":"IF(E50=\"\",IF(F50<>\"\",F50,\"\"),G48)","v":""},"2010-10-05",{"$f":"IF(E50=\"\",IF(H50<>\"\",H50,\"\"),I48)","v":"2010-10-05"},null,{"$f":"IF(E50=\"\",IF(J50<>\"\",J50,\"\"),K48)","v":""},null,{"$f":"IF(F50=\"\",\"\",LOOKUP(WEEKDAY(G50),DayArray))","v":""},"Tuesday","",null,{"$f":"IF(E50<>\"\",\"\",IF(AND(G48<>\"\",G50<>\"\"),G50-G48,\"\"))","v":""},{"$f":"IF(E50<>\"\",\"\",IF(AND(I48<>\"\",I50<>\"\"),I50-I48,\"\"))","v":5},{"$f":"IF(E50<>\"\",\"\",IF(AND(K48<>\"\",K50<>\"\"),K50-K48,\"\"))","v":""}]
[null,null,15,"EQC meeting date",null,null,"","2010-10-21","2010-10-21",null,"",null,"","Thursday","",null,{"$f":"IF(E51<>\"\",\"\",IF(AND(G50<>\"\",G51<>\"\"),G51-G50,\"\"))","v":""},{"$f":"IF(E51<>\"\",\"\",IF(AND(I50<>\"\",I51<>\"\"),I51-I50,\"\"))","v":16},{"$f":"IF(E51<>\"\",\"\",IF(AND(K50<>\"\",K51<>\"\"),K51-K50,\"\"))","v":""}]
[null,null,"Key:","Column 'DA' are dates rulemaking involves the DA. Some are by appointment."]
[null,null,null,"Column '#' is the calculation of days for the row requirement. Red is bad!","Days",{"$f":"IF(AND(F7<>\"\",F51<>\"\"),F51-F7,\"\")","v":""},null,{"$f":"IF(AND(H7<>\"\",H51<>\"\"),H51-H7,\"\")","v":""},null,{"$f":"IF(AND(J7<>\"\",J51<>\"\"),J51-J7,\"\")","v":""}]
[null,null,null,"Column 'DB' is for the rule coordinator.","Mths",{"$f":"IF(F53<>\"\",F53/365*12,\"\")","v":""},null,{"$f":"IF(H53<>\"\",H53/365*12,\"\")","v":""},null,{"$f":"IF(J53<>\"\",J53/365*12,\"\")","v":""}]