{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Data Entry","BA Form 2 Event Data","FRO Data","Adjustments","BA Form 1 Results Data","TimeZone Ref","Frequency Response Initiative","Change History","Frequency Event Graphs"],"not_rendered":{"charts":7,"images":0,"macros":1,"external_links":1,"defined_names":21,"comments":0,"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":"Instructions","index":0,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":false,"merged":[[33,1,33,8],[3,1,3,8],[6,1,6,8],[10,1,10,8],[7,1,7,8]]}
["Balancing Area FRS Form 1-2018 Instructions"]
["2018-05-01"]
["Each Balancing Authority (BA) including those within a Frequency Response Sharing Group (FRSG) provides data for the determination of the appropriate Interconnection’s Resource Loss Protection Criteria (RLPC). In addition to the current practice of providing their frequency response sampling for all four quarters and their Frequency Bias Setting (FBS) calculation, each BA provides requested information regarding determination of resource losses and potential maximum resource loss due to Remedial Action Scheme (RAS) actions as detailed in the “Procedure for ERO Support of Frequency Response and Frequency Bias Setting Standard”. For BAs that do not have facilities that meet the defined criteria, the entity would enter “0” in the appropriate cell. It would be expected that “load only” BAs would not have resources to report, as well as “generation only” BAs that have only a single resource. It is also expected that most BAs would not have RAS actions that include loss of resources larger than their reported resource losses. To facilitate the collection of data, the FRS Form 1 has been modified with the addition of the following fields."]
["1.       Enter data in all green Cells on the \"BA Data Entry\" worksheet."]
["  a.       Cell E1 – Select your BA acronym from the drop-down list."]
["  b.      Cells S9 through S11 – Enter with contact information."]
["  c.       Cell S33 – Select the Bias Type (Fixed or Variable) used by your BA from the drop-down list."]
["  d.      Cells Q14 through Q19 - Enter the three resource losses as applicable per details outlined in the \"Procedure for ERO Support of Frequency Response and Frequency Bias Settings Standard\"- Link to Document"]
["2.       For frequency events identified in Column B of the \"BA Data Entry\" worksheet, collect data and complete one FRS Form 2 workbook for each event in the list."]
["Detailed Instructions for utilizing the \"Adjustments\" are located on the \"Adjustments\" worksheet below the table."]
["3.       Copy the data for each event in the list from FRS Form 2 \"Form 1 Summary Data\" sheet to the \"BA Form 2 Event Data\" worksheet of this workbook using the PasteSpecial/Values (only) function."]
["4.       As you enter data on the \"BA Form 2 Event Data\" sheet, the FRM performance results for the current Operating Year will be displayed in Cells S15-S16. This allows the BA to track its performance as the year progresses."]
["5.       Your current year's Frequency Response Obligation is displayed in Cell S17 of the \"BA Data Entry\" worksheet using the allocation method described in Standard BAL-003. FERC Form 714 data from the most recent completed Form 714 contained in the worksheet \"Form 714 Data\" will update automatically based on the Interconnection and BA name selected."]
["6.       If Fixed Bias type was selected in Cell S34:"]
["  a.       Cell S40 will display “n/a” since Variable Bias was not selected."]
["  b.      Cell S37 will automatically calculate the minimum Bias (least negative) allowed based on your Peak Demand and Peak Generation data in FERC Form 714 in accordance with the Standard."]
["  c.       Cell S38 will automatically calculate the minimum (in absolute terms) Bias allowed, based on 100% of your FRM, if it is more negative than the minimum Bias."]
["  d.      Cell S39 will automatically calculate the maximum Bias (in absolute terms) allowed, based on 125% of your FRM."]
["  e.     If your FRM is more negative than the minimum Bias value calculated in Cell S37, Cell S38 will display 100% of your FRM and Cell S38 will display your 125% of your FRM. You may then choose a Bias setting that is between 100% of your FRM (Cell S38) and 125% of your FRM (Cell S39) and enter it in Cell S41-S42."]
["  f.       Based on your choice, your selected Bias Setting will appear in Cell S43-S44."]
["7.       If Variable Bias type was selected in Cell S34:"]
["  a.       Cells S37 through S39 will display “n/a” since Fixed Bias was not selected."]
["  b.       Cell S40 will calculate the minimum Bias (in absolute terms) allowed based on your FRM and Peak Demand/Peak Generation.  "]
["  c.     Calculate your monthly one minute average Variable Bias setting when frequency is lower than 59.964 Hz or higher than 60.036 Hz and enter these monthly values on the \"Variable Bias Supplemental Info\" worksheet in Cells B2 through D13."]
["  d.     If the \"average annual Variable Bias Setting\" in Cell D14 on the \"Variable Bias Supplemental Info\" worksheet is less negative than Cell E14 of that worksheet, R3 of the standard has not been met and Cell D14 on the \"Variable Bias Supplemental Info\" worksheet will turn red.  The average minimum Bias Setting will cover two different reporting periods and Cells J3 through K10 require past year's data from those year's Form 1s for this evaluation."]
["8.       Two FRMs are calculated for use in the Bias setting:"]
["  a.       One for the BA Bias Setting and one for meeting R1 of the standard."]
["9.       If you RECEIVE Overlap Regulation, select “Y” in Cell S48 and enter Bias Setting data in Cells S52 through T60."]
["10.   If you PROVIDE Overlap Regulation, select “Y” in Cell S62 and enter Bias Setting data in Cells S66 through T74."]
["11.   Save the FRS Form 1 workbook using the following file name format:"]
["         MyBA_FRS_Form_1-2018.xlsx"]
["Where:"]
["  a.     MyBA is replaced with your Balancing Authority abbreviation from Cell C2."]
["  b.     See Cell F72 on the “BA Data Entry” worksheet for your exact file name."]
["12.   Upload completed Form 1 and all Form 2s for the events in Column B to the NERC BAS Site."]

{"sheet":"Data Entry","index":1,"n_rows":68,"n_cols":56,"rows_kept":68,"cut":false,"hidden":false,"merged":[[42,16,43,16],[42,17,43,17],[21,17,22,17],[38,16,39,16],[38,17,39,17],[40,16,41,16],[27,16,27,17],[24,16,25,16],[24,17,25,17],[34,16,35,17],[36,16,37,17],[40,17,41,17],[44,16,45,16],[44,17,45,17],[0,50,0,56],[11,42,11,46],[0,19,0,20],[12,42,12,46],[23,42,23,46],[14,42,14,46],[15,42,15,46],[18,42,18,46],[19,42,19,46],[20,42,20,46],[21,42,21,46],[21,16,22,16],[33,42,33,46],[34,42,34,46],[49,42,49,46],[50,42,50,46],[47,42,47,46],[48,42,48,46],[38,42,38,46],[39,42,39,46],[44,42,44,46],[45,42,45,46],[40,42,40,46],[41,42,41,46],[42,42,42,46],[43,42,43,46],[46,42,46,46],[37,42,37,46],[27,42,27,46],[31,42,31,46],[36,42,36,46],[1,55,1,56],[2,55,2,56],[32,42,32,46],[35,42,35,46],[28,42,28,46],[13,42,13,46],[4,42,4,46],[5,42,5,46],[6,42,6,46],[7,42,7,46],[8,42,8,46],[9,42,9,46],[10,42,10,46],[29,42,29,46],[30,42,30,46],[17,42,17,46],[24,42,24,46],[25,42,25,46],[26,42,26,46],[16,42,16,46],[22,42,22,46],[0,5,0,15],[1,8,2,9],[1,10,2,11],[5,16,5,17],[20,16,20,17],[12,16,12,17],[17,16,18,16],[17,17,18,17],[15,16,16,16],[15,17,16,17],[13,16,14,16],[13,17,14,17]]}
[null,"Select Balancing Authority","AEC",null,null,{"$f":"\"NERC Eastern FRS FORM 1 - Data Entry for Operating Year \"&DataYear","v":"NERC Eastern FRS FORM 1 - Data Entry for Operating Year 2018"},null,null,null,null,null,null,null,null,null,null,"Enter Addition Data in columns V through X ==>",null,null,"Enter Load Information",null," Select Reason(s) for adjustment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Columns BA, BB, BC, BD, BE, BF and BG are reserved for calculation of the linear regression."]
[null,"UTC (t-0)",null,"BA",null,"BA ","BA","Relay Lmt"," Value \"A\" Information",null," Value \"B\" Information",null,"SEFRD (FRM)",null,"Exclude",null,"Enter Data in Green Highlighted Cells",null,null," Value \"A\""," Value \"B\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BA Delta","10 X BA","10 X BA","SEFRDB","SEFRDR","Regression"]
["Event","Date / Time","Date/Time (t-0)","Time","B to A",null,"Bias","R1",null,null,null,null,"for Bias","for R1","for data",null,"Grey and light blue cells are calculated or set by the ERO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NAI","DelFreq","DelFreq","(MW/0.1Hz)","(MW/0.1Hz)","Statistics"]
["Number","(MM/DD/YY HH:MM:SS)","BA Time","Zone","DelFreq","Time","DelFreq","DelFreq","NAI","Adj.","NAI","Adj.","(MW/0.1Hz)","(MW/0.1Hz)","error *",{"$f":"#REF!*100","v":{"$error":"#REF!"}},null,null,null,"Load","Load","Reason(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Bias","For R1",null,null,"For Bias"]
[1,"2017-12-05T22:18:52",{"$f":"IF(B5=\"\",\" \",B5-LOOKUP(D5,TimeZones,'TimeZone Ref'!C$2:C$11))","v":"2017-12-05T17:18:52"},"EST",-3.9000000000001478E-2,{"$f":"'BA Form 2 Event Data'!E8","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!$U8-'BA Form 2 Event Data'!$J8","v":0},{"$f":"IF('Data Entry'!E5<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U8<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J8,'BA Form 2 Event Data'!U8-'BA Form 2 Event Data'!J8)),(IF('BA Form 2 Event Data'!U8<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J8,'BA Form 2 Event Data'!U8-'BA Form 2 Event Data'!J8)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U8>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J8,'BA Form 2 Event Data'!U8-'BA Form 2 Event Data'!J8)),(IF('BA Form 2 Event Data'!U8>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J8,'BA Form 2 Event Data'!U8-'BA Form 2 Event Data'!J8)))))","v":59.5},{"$f":"'BA Form 2 Event Data'!K8","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V4) = \"v\",(Adjustments!$D4+Adjustments!$G4+Adjustments!$J4+Adjustments!$M4+Adjustments!$P4+Adjustments!$S4),0)","v":0},{"$f":"'BA Form 2 Event Data'!V8","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V4) = \"v\",(Adjustments!$E4+Adjustments!$H4+Adjustments!$K4+Adjustments!$N4+Adjustments!$Q4+Adjustments!$T4),0)","v":0},{"$f":"IF($O5=\"y\", \"\",IF(CELL(\"type\",$G5) = \"v\",(($K5-$L5+Adjustments!$Q4)-($I5-$J5+Adjustments!$P4))/(10*$G5),\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O5=\"y\", \"\",IF(CELL(\"type\",$G5) = \"v\",(($K5-$L5)-($I5-$J5))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U8<AO$65,AO$65,IF('BA Form 2 Event Data'!U8>AP$65,AP$65,'BA Form 2 Event Data'!U8-'BA Form 2 Event Data'!J8))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U8<AO$66,AO$66,IF('BA Form 2 Event Data'!U8>AP$66,AP$66,'BA Form 2 Event Data'!U8-'BA Form 2 Event Data'!J8))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U8<AO$67,AO$67,IF('BA Form 2 Event Data'!U8>AP$67,AP$67,'BA Form 2 Event Data'!U8-'BA Form 2 Event Data'!J8))),(IF('BA Form 2 Event Data'!U8<AO$68,AO$68,IF('BA Form 2 Event Data'!U8>AP$68,AP$68,'BA Form 2 Event Data'!U8-'BA Form 2 Event Data'!J8)))))))))),\"\"))","v":0},"N",{"$f":"IF($O5=\"y\", \"\",IF(CELL(\"type\",$G5) = \"v\",(($K5-$L5)-($I5-$J5)),\"\"))","v":0},null,null,null,{"$f":"'BA Form 2 Event Data'!S8","v":0},{"$f":"'BA Form 2 Event Data'!AG8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.7760692778103362E-2,23.246720631917327,null,null,"Dynamic schedules for joint-owned units (DS)",null,null,null,null,null,null,null,{"$f":" ($M5-$N5)-($K5-($L5-Adjustments!O5))","v":{"$error":"#DIV/0!"}},{"$f":" 10*$I5","v":0},null,null,null,{"$f":"LINEST(AY5:AY29,AZ5:AZ29,0,0)","v":{"$error":"#VALUE!"}}]
[2,"2017-12-06T23:27:12",{"$f":"IF(B6=\"\",\" \",B6-LOOKUP(D6,TimeZones,'TimeZone Ref'!C$2:C$11))","v":"2017-12-06T18:27:12"},"EST",-4.8000000000001819E-2,{"$f":"'BA Form 2 Event Data'!E9","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U9-'BA Form 2 Event Data'!J9","v":0},{"$f":"IF('Data Entry'!E6<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U9<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J9,'BA Form 2 Event Data'!U9-'BA Form 2 Event Data'!J9)),(IF('BA Form 2 Event Data'!U9<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J9,'BA Form 2 Event Data'!U9-'BA Form 2 Event Data'!J9)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U9>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J9,'BA Form 2 Event Data'!U9-'BA Form 2 Event Data'!J9)),(IF('BA Form 2 Event Data'!U9>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J9,'BA Form 2 Event Data'!U9-'BA Form 2 Event Data'!J9)))))","v":59.5},{"$f":"'BA Form 2 Event Data'!K9","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V5) = \"v\",(Adjustments!$D5+Adjustments!$G5+Adjustments!$J5+Adjustments!$M5+Adjustments!$P5+Adjustments!$S5),0)","v":0},{"$f":"'BA Form 2 Event Data'!V9","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V5) = \"v\",(Adjustments!$E5+Adjustments!$H5+Adjustments!$K5+Adjustments!$N5+Adjustments!$Q5+Adjustments!$T5),0)","v":0},{"$f":"IF($O6=\"y\", \"\",IF(CELL(\"type\",$G6) = \"v\",(($K6-$L6+Adjustments!$Q5)-($I6-$J6+Adjustments!$P5))/(10*$G6),\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O6=\"y\", \"\",IF(CELL(\"type\",$G6) = \"v\",(($K6-$L6)-($I6-$J6))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U9<AO$65,AO$65,IF('BA Form 2 Event Data'!U9>AP$65,AP$65,'BA Form 2 Event Data'!U9-'BA Form 2 Event Data'!J9))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U9<AO$66,AO$66,IF('BA Form 2 Event Data'!U9>AP$66,AP$66,'BA Form 2 Event Data'!U9-'BA Form 2 Event Data'!J9))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U9<AO$67,AO$67,IF('BA Form 2 Event Data'!U9>AP$67,AP$67,'BA Form 2 Event Data'!U9-'BA Form 2 Event Data'!J9))),(IF('BA Form 2 Event Data'!U9<AO$68,AO$68,IF('BA Form 2 Event Data'!U9>AP$68,AP$68,'BA Form 2 Event Data'!U9-'BA Form 2 Event Data'!J9)))))))))),\"\"))","v":0},"N",0,"BA and Contact information",null,null,{"$f":"'BA Form 2 Event Data'!S9","v":0},{"$f":"'BA Form 2 Event Data'!AG9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-6.609326317200015E-2,27.701624461582725,null,null,"Nonconforming load (NL)",null,null,null,null,null,null,null,{"$f":" ($M6-$N6)-($K6-($L6-Adjustments!O6))","v":{"$error":"#DIV/0!"}},{"$f":" 10*$I6","v":0}]
[3,"2017-12-11T13:58:57",{"$f":"IF(B7=\"\",\" \",B7-LOOKUP(D7,TimeZones,'TimeZone Ref'!C$2:C$11))","v":"2017-12-11T08:58:57"},"EST",-5.1999999999999602E-2,{"$f":"'BA Form 2 Event Data'!E10","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U10-'BA Form 2 Event Data'!J10","v":0},{"$f":"IF('Data Entry'!E7<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U10<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J10,'BA Form 2 Event Data'!U10-'BA Form 2 Event Data'!J10)),(IF('BA Form 2 Event Data'!U10<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J10,'BA Form 2 Event Data'!U10-'BA Form 2 Event Data'!J10)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U10>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J10,'BA Form 2 Event Data'!U10-'BA Form 2 Event Data'!J10)),(IF('BA Form 2 Event Data'!U10>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J10,'BA Form 2 Event Data'!U10-'BA Form 2 Event Data'!J10)))))","v":59.5},{"$f":"'BA Form 2 Event Data'!K10","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V6) = \"v\",(Adjustments!$D6+Adjustments!$G6+Adjustments!$J6+Adjustments!$M6+Adjustments!$P6+Adjustments!$S6),0)","v":0},{"$f":"'BA Form 2 Event Data'!V10","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V6) = \"v\",(Adjustments!$E6+Adjustments!$H6+Adjustments!$K6+Adjustments!$N6+Adjustments!$Q6+Adjustments!$T6),0)","v":0},{"$f":"IF($O7=\"y\", \"\",IF(CELL(\"type\",$G7) = \"v\",(($K7-$L7+Adjustments!$Q6)-($I7-$J7+Adjustments!$P6))/(10*$G7),\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O7=\"y\", \"\",IF(CELL(\"type\",$G7) = \"v\",(($K7-$L7)-($I7-$J7))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U10<AO$65,AO$65,IF('BA Form 2 Event Data'!U10>AP$65,AP$65,'BA Form 2 Event Data'!U10-'BA Form 2 Event Data'!J10))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U10<AO$66,AO$66,IF('BA Form 2 Event Data'!U10>AP$66,AP$66,'BA Form 2 Event Data'!U10-'BA Form 2 Event Data'!J10))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U10<AO$67,AO$67,IF('BA Form 2 Event Data'!U10>AP$67,AP$67,'BA Form 2 Event Data'!U10-'BA Form 2 Event Data'!J10))),(IF('BA Form 2 Event Data'!U10<AO$68,AO$68,IF('BA Form 2 Event Data'!U10>AP$68,AP$68,'BA Form 2 Event Data'!U10-'BA Form 2 Event Data'!J10)))))))))),\"\"))","v":0},"N",0,"Eastern","Interconnection",null,{"$f":"'BA Form 2 Event Data'!S10","v":0},{"$f":"'BA Form 2 Event Data'!AG10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4.0239788237002472E-2,10.663229942321777,null,null,"Pumped hydro (PH)",null,null,null,null,null,null,null,{"$f":" ($M7-$N7)-($K7-($L7-Adjustments!O7))","v":{"$error":"#DIV/0!"}},0]
[4,"2018-01-03T07:59:40",{"$f":"IF(B8=\"\",\" \",B8-LOOKUP(D8,TimeZones,'TimeZone Ref'!C$2:C$11))","v":"2018-01-03T02:59:40"},"EST",-5.5999999999997385E-2,{"$f":"'BA Form 2 Event Data'!E11","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U11-'BA Form 2 Event Data'!J11","v":0},{"$f":"IF('Data Entry'!E8<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U11<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J11,'BA Form 2 Event Data'!U11-'BA Form 2 Event Data'!J11)),(IF('BA Form 2 Event Data'!U11<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J11,'BA Form 2 Event Data'!U11-'BA Form 2 Event Data'!J11)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U11>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J11,'BA Form 2 Event Data'!U11-'BA Form 2 Event Data'!J11)),(IF('BA Form 2 Event Data'!U11>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J11,'BA Form 2 Event Data'!U11-'BA Form 2 Event Data'!J11)))))","v":59.5},{"$f":"'BA Form 2 Event Data'!K11","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V7) = \"v\",(Adjustments!$D7+Adjustments!$G7+Adjustments!$J7+Adjustments!$M7+Adjustments!$P7+Adjustments!$S7),0)","v":0},{"$f":"'BA Form 2 Event Data'!V11","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V7) = \"v\",(Adjustments!$E7+Adjustments!$H7+Adjustments!$K7+Adjustments!$N7+Adjustments!$Q7+Adjustments!$T7),0)","v":0},{"$f":"IF($O8=\"y\", \"\",IF(CELL(\"type\",$G8) = \"v\",(($K8-$L8+Adjustments!$Q7)-($I8-$J8+Adjustments!$P7))/(10*$G8),\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O8=\"y\", \"\",IF(CELL(\"type\",$G8) = \"v\",(($K8-$L8)-($I8-$J8))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U11<AO$65,AO$65,IF('BA Form 2 Event Data'!U11>AP$65,AP$65,'BA Form 2 Event Data'!U11-'BA Form 2 Event Data'!J11))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U11<AO$66,AO$66,IF('BA Form 2 Event Data'!U11>AP$66,AP$66,'BA Form 2 Event Data'!U11-'BA Form 2 Event Data'!J11))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U11<AO$67,AO$67,IF('BA Form 2 Event Data'!U11>AP$67,AP$67,'BA Form 2 Event Data'!U11-'BA Form 2 Event Data'!J11))),(IF('BA Form 2 Event Data'!U11<AO$68,AO$68,IF('BA Form 2 Event Data'!U11>AP$68,AP$68,'BA Form 2 Event Data'!U11-'BA Form 2 Event Data'!J11)))))))))),\"\"))","v":0},"N",0,{"$f":"C1","v":"AEC"},"Balancing Authority",null,{"$f":"'BA Form 2 Event Data'!S11","v":0},{"$f":"'BA Form 2 Event Data'!AG11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.252492995489888E-2,80.660890551975797,null,null,"Invalid Data (ID)",null,null,null,null,null,null,null,{"$f":" ($M8-$N8)-($K8-($L8-Adjustments!O8))","v":{"$error":"#DIV/0!"}},0]
[5,"2018-01-27T21:17:41",{"$f":"IF(B9=\"\",\" \",B9-LOOKUP(D9,TimeZones,'TimeZone Ref'!C$2:C$11))","v":"2018-01-27T16:17:41"},"EST",-4.399999999999693E-2,{"$f":"'BA Form 2 Event Data'!E12","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U12-'BA Form 2 Event Data'!J12","v":0},{"$f":"IF('Data Entry'!E9<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U12<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J12,'BA Form 2 Event Data'!U12-'BA Form 2 Event Data'!J12)),(IF('BA Form 2 Event Data'!U12<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J12,'BA Form 2 Event Data'!U12-'BA Form 2 Event Data'!J12)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U12>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J12,'BA Form 2 Event Data'!U12-'BA Form 2 Event Data'!J12)),(IF('BA Form 2 Event Data'!U12>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J12,'BA Form 2 Event Data'!U12-'BA Form 2 Event Data'!J12)))))","v":59.5},{"$f":"'BA Form 2 Event Data'!K12","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V8) = \"v\",(Adjustments!$D8+Adjustments!$G8+Adjustments!$J8+Adjustments!$M8+Adjustments!$P8+Adjustments!$S8),0)","v":0},{"$f":"'BA Form 2 Event Data'!V12","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V8) = \"v\",(Adjustments!$E8+Adjustments!$H8+Adjustments!$K8+Adjustments!$N8+Adjustments!$Q8+Adjustments!$T8),0)","v":0},{"$f":"IF($O9=\"y\", \"\",IF(CELL(\"type\",$G9) = \"v\",(($K9-$L9+Adjustments!$Q8)-($I9-$J9+Adjustments!$P8))/(10*$G9),\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O9=\"y\", \"\",IF(CELL(\"type\",$G9) = \"v\",(($K9-$L9)-($I9-$J9))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U12<AO$65,AO$65,IF('BA Form 2 Event Data'!U12>AP$65,AP$65,'BA Form 2 Event Data'!U12-'BA Form 2 Event Data'!J12))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U12<AO$66,AO$66,IF('BA Form 2 Event Data'!U12>AP$66,AP$66,'BA Form 2 Event Data'!U12-'BA Form 2 Event Data'!J12))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U12<AO$67,AO$67,IF('BA Form 2 Event Data'!U12>AP$67,AP$67,'BA Form 2 Event Data'!U12-'BA Form 2 Event Data'!J12))),(IF('BA Form 2 Event Data'!U12<AO$68,AO$68,IF('BA Form 2 Event Data'!U12>AP$68,AP$68,'BA Form 2 Event Data'!U12-'BA Form 2 Event Data'!J12)))))))))),\"\"))","v":0},"N",0,null,"Contact Name",null,{"$f":"'BA Form 2 Event Data'!S12","v":0},{"$f":"'BA Form 2 Event Data'!AG12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-7.090523129419779E-2,-26.897608961377827,null,null,"Transfered Frequency Response (TFR)",null,null,null,null,null,null,null,{"$f":" ($M9-$N9)-($K9-($L9-Adjustments!O9))","v":{"$error":"#DIV/0!"}},0]
[6,"2018-02-03T13:35:19",{"$f":"IF(B10=\"\",\" \",B10-LOOKUP(D10,TimeZones,'TimeZone Ref'!C$2:C$11))","v":"2018-02-03T08:35:19"},"EST",-5.1999999999999602E-2,{"$f":"'BA Form 2 Event Data'!E13","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U13-'BA Form 2 Event Data'!J13","v":0},{"$f":"IF('Data Entry'!E10<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U13<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J13,'BA Form 2 Event Data'!U13-'BA Form 2 Event Data'!J13)),(IF('BA Form 2 Event Data'!U13<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J13,'BA Form 2 Event Data'!U13-'BA Form 2 Event Data'!J13)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U13>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J13,'BA Form 2 Event Data'!U13-'BA Form 2 Event Data'!J13)),(IF('BA Form 2 Event Data'!U13>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J13,'BA Form 2 Event Data'!U13-'BA Form 2 Event Data'!J13)))))","v":59.5},{"$f":"'BA Form 2 Event Data'!K13","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V9) = \"v\",(Adjustments!$D9+Adjustments!$G9+Adjustments!$J9+Adjustments!$M9+Adjustments!$P9+Adjustments!$S9),0)","v":0},{"$f":"'BA Form 2 Event Data'!V13","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V9) = \"v\",(Adjustments!$E9+Adjustments!$H9+Adjustments!$K9+Adjustments!$N9+Adjustments!$Q9+Adjustments!$T9),0)","v":0},{"$f":"IF($O10=\"y\", \"\",IF(CELL(\"type\",$G10) = \"v\",(($K10-$L10+Adjustments!$Q9)-($I10-$J10+Adjustments!$P9))/(10*$G10),\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O10=\"y\", \"\",IF(CELL(\"type\",$G10) = \"v\",(($K10-$L10)-($I10-$J10))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U13<AO$65,AO$65,IF('BA Form 2 Event Data'!U13>AP$65,AP$65,'BA Form 2 Event Data'!U13-'BA Form 2 Event Data'!J13))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U13<AO$66,AO$66,IF('BA Form 2 Event Data'!U13>AP$66,AP$66,'BA Form 2 Event Data'!U13-'BA Form 2 Event Data'!J13))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U13<AO$67,AO$67,IF('BA Form 2 Event Data'!U13>AP$67,AP$67,'BA Form 2 Event Data'!U13-'BA Form 2 Event Data'!J13))),(IF('BA Form 2 Event Data'!U13<AO$68,AO$68,IF('BA Form 2 Event Data'!U13>AP$68,AP$68,'BA Form 2 Event Data'!U13-'BA Form 2 Event Data'!J13)))))))))),\"\"))","v":0},"N",0,null,"Contact Phone #",null,{"$f":"'BA Form 2 Event Data'!S13","v":0},{"$f":"'BA Form 2 Event Data'!AG13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.1906767345698768E-2,9.955449178814888,null,null,"Contingent BA adjustment for loss of units (CBA)",null,null,null,null,null,null,null,{"$f":" ($M10-$N10)-($K10-($L10-Adjustments!O10))","v":{"$error":"#DIV/0!"}},0]
[7,"2018-02-16T15:14:21",{"$f":"IF(B11=\"\",\" \",B11-LOOKUP(D11,TimeZones,'TimeZone Ref'!C$2:C$11))","v":"2018-02-16T10:14:21"},"EST",-5.0000000000004263E-2,{"$f":"'BA Form 2 Event Data'!E14","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U14-'BA Form 2 Event Data'!J14","v":0},{"$f":"IF('Data Entry'!E11<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U14<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J14,'BA Form 2 Event Data'!U14-'BA Form 2 Event Data'!J14)),(IF('BA Form 2 Event Data'!U14<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J14,'BA Form 2 Event Data'!U14-'BA Form 2 Event Data'!J14)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U14>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J14,'BA Form 2 Event Data'!U14-'BA Form 2 Event Data'!J14)),(IF('BA Form 2 Event Data'!U14>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J14,'BA Form 2 Event Data'!U14-'BA Form 2 Event Data'!J14)))))","v":59.5},{"$f":"'BA Form 2 Event Data'!K14","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V10) = \"v\",(Adjustments!$D10+Adjustments!$G10+Adjustments!$J10+Adjustments!$M10+Adjustments!$P10+Adjustments!$S10),0)","v":0},{"$f":"'BA Form 2 Event Data'!V14","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V10) = \"v\",(Adjustments!$E10+Adjustments!$H10+Adjustments!$K10+Adjustments!$N10+Adjustments!$Q10+Adjustments!$T10),0)","v":0},{"$f":"IF($O11=\"y\", \"\",IF(CELL(\"type\",$G11) = \"v\",(($K11-$L11+Adjustments!$Q10)-($I11-$J11+Adjustments!$P10))/(10*$G11),\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O11=\"y\", \"\",IF(CELL(\"type\",$G11) = \"v\",(($K11-$L11)-($I11-$J11))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U14<AO$65,AO$65,IF('BA Form 2 Event Data'!U14>AP$65,AP$65,'BA Form 2 Event Data'!U14-'BA Form 2 Event Data'!J14))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U14<AO$66,AO$66,IF('BA Form 2 Event Data'!U14>AP$66,AP$66,'BA Form 2 Event Data'!U14-'BA Form 2 Event Data'!J14))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U14<AO$67,AO$67,IF('BA Form 2 Event Data'!U14>AP$67,AP$67,'BA Form 2 Event Data'!U14-'BA Form 2 Event Data'!J14))),(IF('BA Form 2 Event Data'!U14<AO$68,AO$68,IF('BA Form 2 Event Data'!U14>AP$68,AP$68,'BA Form 2 Event Data'!U14-'BA Form 2 Event Data'!J14)))))))))),\"\"))","v":0},"N",0,null,"Contact e-mail",null,{"$f":"'BA Form 2 Event Data'!S14","v":0},{"$f":"'BA Form 2 Event Data'!AG14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.804770333430298E-2,3.3670240129743263,null,null,"DS & NL",null,null,null,null,null,null,null,{"$f":" ($M11-$N11)-($K11-($L11-Adjustments!O11))","v":{"$error":"#DIV/0!"}},0]
[8,"2018-02-21T00:17:40",{"$f":"IF(B12=\"\",\" \",B12-LOOKUP(D12,TimeZones,'TimeZone Ref'!C$2:C$11))","v":"2018-02-20T19:17:40"},"EST",-3.399999999999892E-2,{"$f":"'BA Form 2 Event Data'!E15","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U15-'BA Form 2 Event Data'!J15","v":0},{"$f":"IF('Data Entry'!E12<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U15<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J15,'BA Form 2 Event Data'!U15-'BA Form 2 Event Data'!J15)),(IF('BA Form 2 Event Data'!U15<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J15,'BA Form 2 Event Data'!U15-'BA Form 2 Event Data'!J15)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U15>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J15,'BA Form 2 Event Data'!U15-'BA Form 2 Event Data'!J15)),(IF('BA Form 2 Event Data'!U15>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J15,'BA Form 2 Event Data'!U15-'BA Form 2 Event Data'!J15)))))","v":59.5},{"$f":"'BA Form 2 Event Data'!K15","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V11) = \"v\",(Adjustments!$D11+Adjustments!$G11+Adjustments!$J11+Adjustments!$M11+Adjustments!$P11+Adjustments!$S11),0)","v":0},{"$f":"'BA Form 2 Event Data'!V15","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V11) = \"v\",(Adjustments!$E11+Adjustments!$H11+Adjustments!$K11+Adjustments!$N11+Adjustments!$Q11+Adjustments!$T11),0)","v":0},{"$f":"IF($O12=\"y\", \"\",IF(CELL(\"type\",$G12) = \"v\",(($K12-$L12+Adjustments!$Q11)-($I12-$J12+Adjustments!$P11))/(10*$G12),\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O12=\"y\", \"\",IF(CELL(\"type\",$G12) = \"v\",(($K12-$L12)-($I12-$J12))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U15<AO$65,AO$65,IF('BA Form 2 Event Data'!U15>AP$65,AP$65,'BA Form 2 Event Data'!U15-'BA Form 2 Event Data'!J15))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U15<AO$66,AO$66,IF('BA Form 2 Event Data'!U15>AP$66,AP$66,'BA Form 2 Event Data'!U15-'BA Form 2 Event Data'!J15))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U15<AO$67,AO$67,IF('BA Form 2 Event Data'!U15>AP$67,AP$67,'BA Form 2 Event Data'!U15-'BA Form 2 Event Data'!J15))),(IF('BA Form 2 Event Data'!U15<AO$68,AO$68,IF('BA Form 2 Event Data'!U15>AP$68,AP$68,'BA Form 2 Event Data'!U15-'BA Form 2 Event Data'!J15)))))))))),\"\"))","v":0},"N",0,null,null,null,{"$f":"'BA Form 2 Event Data'!S15","v":0},{"$f":"'BA Form 2 Event Data'!AG15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-7.5572422572498965E-2,36.334426879882812,null,null,"DS & PH",null,null,null,null,null,null,null,{"$f":" ($M12-$N12)-($K12-($L12-Adjustments!O12))","v":{"$error":"#DIV/0!"}},0]
[9,"2018-03-08T05:15:50",{"$f":"IF(B13=\"\",\" \",B13-LOOKUP(D13,TimeZones,'TimeZone Ref'!C$2:C$11))","v":"2018-03-08T00:15:50"},"EST",-5.700000000000216E-2,{"$f":"'BA Form 2 Event Data'!E16","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U16-'BA Form 2 Event Data'!J16","v":0},{"$f":"IF('Data Entry'!E13<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U16<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J16,'BA Form 2 Event Data'!U16-'BA Form 2 Event Data'!J16)),(IF('BA Form 2 Event Data'!U16<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J16,'BA Form 2 Event Data'!U16-'BA Form 2 Event Data'!J16)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U16>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J16,'BA Form 2 Event Data'!U16-'BA Form 2 Event Data'!J16)),(IF('BA Form 2 Event Data'!U16>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J16,'BA Form 2 Event Data'!U16-'BA Form 2 Event Data'!J16)))))","v":59.5},{"$f":"'BA Form 2 Event Data'!K16","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V12) = \"v\",(Adjustments!$D12+Adjustments!$G12+Adjustments!$J12+Adjustments!$M12+Adjustments!$P12+Adjustments!$S12),0)","v":0},{"$f":"'BA Form 2 Event Data'!V16","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V12) = \"v\",(Adjustments!$E12+Adjustments!$H12+Adjustments!$K12+Adjustments!$N12+Adjustments!$Q12+Adjustments!$T12),0)","v":0},{"$f":"IF($O13=\"y\", \"\",IF(CELL(\"type\",$G13) = \"v\",(($K13-$L13+Adjustments!$Q12)-($I13-$J13+Adjustments!$P12))/(10*$G13),\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O13=\"y\", \"\",IF(CELL(\"type\",$G13) = \"v\",(($K13-$L13)-($I13-$J13))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U16<AO$65,AO$65,IF('BA Form 2 Event Data'!U16>AP$65,AP$65,'BA Form 2 Event Data'!U16-'BA Form 2 Event Data'!J16))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U16<AO$66,AO$66,IF('BA Form 2 Event Data'!U16>AP$66,AP$66,'BA Form 2 Event Data'!U16-'BA Form 2 Event Data'!J16))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U16<AO$67,AO$67,IF('BA Form 2 Event Data'!U16>AP$67,AP$67,'BA Form 2 Event Data'!U16-'BA Form 2 Event Data'!J16))),(IF('BA Form 2 Event Data'!U16<AO$68,AO$68,IF('BA Form 2 Event Data'!U16>AP$68,AP$68,'BA Form 2 Event Data'!U16-'BA Form 2 Event Data'!J16)))))))))),\"\"))","v":0},"N",0,"Interconnection RLPC Data Submittal",null,null,{"$f":"'BA Form 2 Event Data'!S16","v":0},{"$f":"'BA Form 2 Event Data'!AG16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.6380498976999149E-2,0.4882530443596238,null,null,"DS & ID",null,null,null,null,null,null,null,{"$f":" ($M13-$N13)-($K13-($L13-Adjustments!O13))","v":{"$error":"#DIV/0!"}},0]
[10,"2018-03-14T12:38:10",{"$f":"IF(B14=\"\",\" \",B14-LOOKUP(D14,TimeZones,'TimeZone Ref'!C$2:C$11))","v":"2018-03-14T08:38:10"},"EDT",-4.5999999999999375E-2,{"$f":"'BA Form 2 Event Data'!E17","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U17-'BA Form 2 Event Data'!J17","v":0},{"$f":"IF('Data Entry'!E14<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U17<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J17,'BA Form 2 Event Data'!U17-'BA Form 2 Event Data'!J17)),(IF('BA Form 2 Event Data'!U17<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J17,'BA Form 2 Event Data'!U17-'BA Form 2 Event Data'!J17)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U17>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J17,'BA Form 2 Event Data'!U17-'BA Form 2 Event Data'!J17)),(IF('BA Form 2 Event Data'!U17>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J17,'BA Form 2 Event Data'!U17-'BA Form 2 Event Data'!J17)))))","v":59.5},{"$f":"'BA Form 2 Event Data'!K17","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V13) = \"v\",(Adjustments!$D13+Adjustments!$G13+Adjustments!$J13+Adjustments!$M13+Adjustments!$P13+Adjustments!$S13),0)","v":0},{"$f":"'BA Form 2 Event Data'!V17","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V13) = \"v\",(Adjustments!$E13+Adjustments!$H13+Adjustments!$K13+Adjustments!$N13+Adjustments!$Q13+Adjustments!$T13),0)","v":0},{"$f":"IF($O14=\"y\", \"\",IF(CELL(\"type\",$G14) = \"v\",(($K14-$L14+Adjustments!$Q13)-($I14-$J14+Adjustments!$P13))/(10*$G14),\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O14=\"y\", \"\",IF(CELL(\"type\",$G14) = \"v\",(($K14-$L14)-($I14-$J14))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U17<AO$65,AO$65,IF('BA Form 2 Event Data'!U17>AP$65,AP$65,'BA Form 2 Event Data'!U17-'BA Form 2 Event Data'!J17))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U17<AO$66,AO$66,IF('BA Form 2 Event Data'!U17>AP$66,AP$66,'BA Form 2 Event Data'!U17-'BA Form 2 Event Data'!J17))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U17<AO$67,AO$67,IF('BA Form 2 Event Data'!U17>AP$67,AP$67,'BA Form 2 Event Data'!U17-'BA Form 2 Event Data'!J17))),(IF('BA Form 2 Event Data'!U17<AO$68,AO$68,IF('BA Form 2 Event Data'!U17>AP$68,AP$68,'BA Form 2 Event Data'!U17-'BA Form 2 Event Data'!J17)))))))))),\"\"))","v":0},"N",0," ","Largest potential resource loss within the Balancing Authority Area for the next operating year as detailed in the \"Procedure for ERO Support of Frequency Response and Frequency Bias Settings Standard\"",null,{"$f":"'BA Form 2 Event Data'!S17","v":0},{"$f":"'BA Form 2 Event Data'!AG17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.7332901727598085E-2,2.7580369313557895,null,null,"DS & TFR",null,null,null,null,null,null,null,{"$f":" ($M14-$N14)-($K14-($L14-Adjustments!O14))","v":{"$error":"#DIV/0!"}},0]
[11,"2018-03-18T16:59:10",{"$f":"IF(B15=\"\",\" \",B15-LOOKUP(D15,TimeZones,'TimeZone Ref'!C$2:C$11))","v":"2018-03-18T12:59:10"},"EDT",-4.5999999999999375E-2,{"$f":"'BA Form 2 Event Data'!E18","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U18-'BA Form 2 Event Data'!J18","v":0},{"$f":"IF('Data Entry'!E15<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U18<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J18,'BA Form 2 Event Data'!U18-'BA Form 2 Event Data'!J18)),(IF('BA Form 2 Event Data'!U18<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J18,'BA Form 2 Event Data'!U18-'BA Form 2 Event Data'!J18)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U18>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J18,'BA Form 2 Event Data'!U18-'BA Form 2 Event Data'!J18)),(IF('BA Form 2 Event Data'!U18>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J18,'BA Form 2 Event Data'!U18-'BA Form 2 Event Data'!J18)))))","v":59.5},{"$f":"'BA Form 2 Event Data'!K18","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V14) = \"v\",(Adjustments!$D14+Adjustments!$G14+Adjustments!$J14+Adjustments!$M14+Adjustments!$P14+Adjustments!$S14),0)","v":0},{"$f":"'BA Form 2 Event Data'!V18","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V14) = \"v\",(Adjustments!$E14+Adjustments!$H14+Adjustments!$K14+Adjustments!$N14+Adjustments!$Q14+Adjustments!$T14),0)","v":0},{"$f":"IF($O15=\"y\", \"\",IF(CELL(\"type\",$G15) = \"v\",(($K15-$L15+Adjustments!$Q14)-($I15-$J15+Adjustments!$P14))/(10*$G15),\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O15=\"y\", \"\",IF(CELL(\"type\",$G15) = \"v\",(($K15-$L15)-($I15-$J15))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U18<AO$65,AO$65,IF('BA Form 2 Event Data'!U18>AP$65,AP$65,'BA Form 2 Event Data'!U18-'BA Form 2 Event Data'!J18))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U18<AO$66,AO$66,IF('BA Form 2 Event Data'!U18>AP$66,AP$66,'BA Form 2 Event Data'!U18-'BA Form 2 Event Data'!J18))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U18<AO$67,AO$67,IF('BA Form 2 Event Data'!U18>AP$67,AP$67,'BA Form 2 Event Data'!U18-'BA Form 2 Event Data'!J18))),(IF('BA Form 2 Event Data'!U18<AO$68,AO$68,IF('BA Form 2 Event Data'!U18>AP$68,AP$68,'BA Form 2 Event Data'!U18-'BA Form 2 Event Data'!J18)))))))))),\"\"))","v":0},"N",0,null,null,null,{"$f":"'BA Form 2 Event Data'!S18","v":0},{"$f":"'BA Form 2 Event Data'!AG18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.1760900588298853E-2,13.643416881561279,null,null,"DS & CBA",null,null,null,null,null,null,null,{"$f":" ($M15-$N15)-($K15-($L15-Adjustments!O15))","v":{"$error":"#DIV/0!"}},0]
[12,"2018-04-07T12:36:00",{"$f":"IF(B16=\"\",\" \",B16-LOOKUP(D16,TimeZones,'TimeZone Ref'!C$2:C$11))","v":"2018-04-07T08:36:00"},"EDT",-5.5999999999997385E-2,{"$f":"'BA Form 2 Event Data'!E19","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U19-'BA Form 2 Event Data'!J19","v":0},{"$f":"IF('Data Entry'!E16<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U19<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J19,'BA Form 2 Event Data'!U19-'BA Form 2 Event Data'!J19)),(IF('BA Form 2 Event Data'!U19<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J19,'BA Form 2 Event Data'!U19-'BA Form 2 Event Data'!J19)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U19>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J19,'BA Form 2 Event Data'!U19-'BA Form 2 Event Data'!J19)),(IF('BA Form 2 Event Data'!U19>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J19,'BA Form 2 Event Data'!U19-'BA Form 2 Event Data'!J19)))))","v":59.5},{"$f":"'BA Form 2 Event Data'!K19","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V15) = \"v\",(Adjustments!$D15+Adjustments!$G15+Adjustments!$J15+Adjustments!$M15+Adjustments!$P15+Adjustments!$S15),0)","v":0},{"$f":"'BA Form 2 Event Data'!V19","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V15) = \"v\",(Adjustments!$E15+Adjustments!$H15+Adjustments!$K15+Adjustments!$N15+Adjustments!$Q15+Adjustments!$T15),0)","v":0},{"$f":"IF($O16=\"y\", \"\",IF(CELL(\"type\",$G16) = \"v\",(($K16-$L16+Adjustments!$Q15)-($I16-$J16+Adjustments!$P15))/(10*$G16),\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O16=\"y\", \"\",IF(CELL(\"type\",$G16) = \"v\",(($K16-$L16)-($I16-$J16))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U19<AO$65,AO$65,IF('BA Form 2 Event Data'!U19>AP$65,AP$65,'BA Form 2 Event Data'!U19-'BA Form 2 Event Data'!J19))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U19<AO$66,AO$66,IF('BA Form 2 Event Data'!U19>AP$66,AP$66,'BA Form 2 Event Data'!U19-'BA Form 2 Event Data'!J19))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U19<AO$67,AO$67,IF('BA Form 2 Event Data'!U19>AP$67,AP$67,'BA Form 2 Event Data'!U19-'BA Form 2 Event Data'!J19))),(IF('BA Form 2 Event Data'!U19<AO$68,AO$68,IF('BA Form 2 Event Data'!U19>AP$68,AP$68,'BA Form 2 Event Data'!U19-'BA Form 2 Event Data'!J19)))))))))),\"\"))","v":0},"N",0," ","Second largest potential resource loss within the Balancing Authority Area for the next operating year as detailed in the Procedure for ERO Support of Frequency Response and Frequency Bias Settings Standard",null,{"$f":"'BA Form 2 Event Data'!S19","v":0},{"$f":"'BA Form 2 Event Data'!AG19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4.9999237060546875E-2,11.100745916366577,null,null,"DS & NL & PH",null,null,null,null,null,null,null,{"$f":" ($M16-$N16)-($K16-($L16-Adjustments!O16))","v":{"$error":"#DIV/0!"}},0]
[13,"2018-04-12T17:26:13",{"$f":"IF(B17=\"\",\" \",B17-LOOKUP(D17,TimeZones,'TimeZone Ref'!C$2:C$11))","v":"2018-04-12T13:26:13"},"EDT",-3.0999999999998806E-2,{"$f":"'BA Form 2 Event Data'!E20","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U20-'BA Form 2 Event Data'!J20","v":0},{"$f":"IF('Data Entry'!E17<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U20<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J20,'BA Form 2 Event Data'!U20-'BA Form 2 Event Data'!J20)),(IF('BA Form 2 Event Data'!U20<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J20,'BA Form 2 Event Data'!U20-'BA Form 2 Event Data'!J20)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U20>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J20,'BA Form 2 Event Data'!U20-'BA Form 2 Event Data'!J20)),(IF('BA Form 2 Event Data'!U20>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J20,'BA Form 2 Event Data'!U20-'BA Form 2 Event Data'!J20)))))","v":59.5},{"$f":"'BA Form 2 Event Data'!K20","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V16) = \"v\",(Adjustments!$D16+Adjustments!$G16+Adjustments!$J16+Adjustments!$M16+Adjustments!$P16+Adjustments!$S16),0)","v":0},{"$f":"'BA Form 2 Event Data'!V20","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V16) = \"v\",(Adjustments!$E16+Adjustments!$H16+Adjustments!$K16+Adjustments!$N16+Adjustments!$Q16+Adjustments!$T16),0)","v":0},{"$f":"IF($O17=\"y\", \"\",IF(CELL(\"type\",$G17) = \"v\",(($K17-$L17+Adjustments!$Q16)-($I17-$J17+Adjustments!$P16))/(10*$G17),\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O17=\"y\", \"\",IF(CELL(\"type\",$G17) = \"v\",(($K17-$L17)-($I17-$J17))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U20<AO$65,AO$65,IF('BA Form 2 Event Data'!U20>AP$65,AP$65,'BA Form 2 Event Data'!U20-'BA Form 2 Event Data'!J20))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U20<AO$66,AO$66,IF('BA Form 2 Event Data'!U20>AP$66,AP$66,'BA Form 2 Event Data'!U20-'BA Form 2 Event Data'!J20))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U20<AO$67,AO$67,IF('BA Form 2 Event Data'!U20>AP$67,AP$67,'BA Form 2 Event Data'!U20-'BA Form 2 Event Data'!J20))),(IF('BA Form 2 Event Data'!U20<AO$68,AO$68,IF('BA Form 2 Event Data'!U20>AP$68,AP$68,'BA Form 2 Event Data'!U20-'BA Form 2 Event Data'!J20)))))))))),\"\"))","v":0},"N",0,null,null,null,{"$f":"'BA Form 2 Event Data'!S20","v":0},{"$f":"'BA Form 2 Event Data'!AG20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.1999999999999998E-2,-19.906846483548481,null,null,"DS & NL & ID",null,null,null,null,null,null,null,{"$f":" ($M17-$N17)-($K17-($L17-Adjustments!O17))","v":{"$error":"#DIV/0!"}},0]
[14,null,{"$f":"IF(B18=\"\",\" \",B18-LOOKUP(D18,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E21","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U21-'BA Form 2 Event Data'!J21","v":0},{"$f":"IF('Data Entry'!E18<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U21<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J21,'BA Form 2 Event Data'!U21-'BA Form 2 Event Data'!J21)),(IF('BA Form 2 Event Data'!U21<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J21,'BA Form 2 Event Data'!U21-'BA Form 2 Event Data'!J21)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U21>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J21,'BA Form 2 Event Data'!U21-'BA Form 2 Event Data'!J21)),(IF('BA Form 2 Event Data'!U21>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J21,'BA Form 2 Event Data'!U21-'BA Form 2 Event Data'!J21)))))","v":0},{"$f":"'BA Form 2 Event Data'!K21","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V17) = \"v\",(Adjustments!$D17+Adjustments!$G17+Adjustments!$J17+Adjustments!$M17+Adjustments!$P17+Adjustments!$S17),0)","v":0},{"$f":"'BA Form 2 Event Data'!V21","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V17) = \"v\",(Adjustments!$E17+Adjustments!$H17+Adjustments!$K17+Adjustments!$N17+Adjustments!$Q17+Adjustments!$T17),0)","v":0},{"$f":"IF($O18=\"y\", \"\",IF(CELL(\"type\",$G18) = \"v\",(($K18-$L18+Adjustments!$Q17)-($I18-$J18+Adjustments!$P17))/(10*$G18),\"\"))","v":""},{"$f":"IF($O18=\"y\", \"\",IF(CELL(\"type\",$G18) = \"v\",(($K18-$L18)-($I18-$J18))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U21<AO$65,AO$65,IF('BA Form 2 Event Data'!U21>AP$65,AP$65,'BA Form 2 Event Data'!U21-'BA Form 2 Event Data'!J21))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U21<AO$66,AO$66,IF('BA Form 2 Event Data'!U21>AP$66,AP$66,'BA Form 2 Event Data'!U21-'BA Form 2 Event Data'!J21))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U21<AO$67,AO$67,IF('BA Form 2 Event Data'!U21>AP$67,AP$67,'BA Form 2 Event Data'!U21-'BA Form 2 Event Data'!J21))),(IF('BA Form 2 Event Data'!U21<AO$68,AO$68,IF('BA Form 2 Event Data'!U21>AP$68,AP$68,'BA Form 2 Event Data'!U21-'BA Form 2 Event Data'!J21)))))))))),\"\"))","v":""},"Y",""," ","The largest resource loss within the Balancing Authority Area that results from a RAS action initiated by a multiple contingency (N-2) event as detailed in the Procedure for ERO Support of Frequency Response and Frequency Bias Settings Standard",null,{"$f":"'BA Form 2 Event Data'!S21","v":0},{"$f":"'BA Form 2 Event Data'!AG21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.5999755859375E-2,12.32546430163913,null,null,"JOU DS & NL & TFR",null,null,null,null,null,null,null,{"$f":" ($M18-$N18)-($K18-($L18-Adjustments!O18))","v":{"$error":"#VALUE!"}},0]
[15,null,{"$f":"IF(B19=\"\",\" \",B19-LOOKUP(D19,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E22","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U22-'BA Form 2 Event Data'!J22","v":0},{"$f":"IF('Data Entry'!E19<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U22<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J22,'BA Form 2 Event Data'!U22-'BA Form 2 Event Data'!J22)),(IF('BA Form 2 Event Data'!U22<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J22,'BA Form 2 Event Data'!U22-'BA Form 2 Event Data'!J22)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U22>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J22,'BA Form 2 Event Data'!U22-'BA Form 2 Event Data'!J22)),(IF('BA Form 2 Event Data'!U22>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J22,'BA Form 2 Event Data'!U22-'BA Form 2 Event Data'!J22)))))","v":0},{"$f":"'BA Form 2 Event Data'!K22","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V18) = \"v\",(Adjustments!$D18+Adjustments!$G18+Adjustments!$J18+Adjustments!$M18+Adjustments!$P18+Adjustments!$S18),0)","v":0},{"$f":"'BA Form 2 Event Data'!V22","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V18) = \"v\",(Adjustments!$E18+Adjustments!$H18+Adjustments!$K18+Adjustments!$N18+Adjustments!$Q18+Adjustments!$T18),0)","v":0},{"$f":"IF($O19=\"y\", \"\",IF(CELL(\"type\",$G19) = \"v\",(($K19-$L19+Adjustments!$Q18)-($I19-$J19+Adjustments!$P18))/(10*$G19),\"\"))","v":""},{"$f":"IF($O19=\"y\", \"\",IF(CELL(\"type\",$G19) = \"v\",(($K19-$L19)-($I19-$J19))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U22<AO$65,AO$65,IF('BA Form 2 Event Data'!U22>AP$65,AP$65,'BA Form 2 Event Data'!U22-'BA Form 2 Event Data'!J22))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U22<AO$66,AO$66,IF('BA Form 2 Event Data'!U22>AP$66,AP$66,'BA Form 2 Event Data'!U22-'BA Form 2 Event Data'!J22))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U22<AO$67,AO$67,IF('BA Form 2 Event Data'!U22>AP$67,AP$67,'BA Form 2 Event Data'!U22-'BA Form 2 Event Data'!J22))),(IF('BA Form 2 Event Data'!U22<AO$68,AO$68,IF('BA Form 2 Event Data'!U22>AP$68,AP$68,'BA Form 2 Event Data'!U22-'BA Form 2 Event Data'!J22)))))))))),\"\"))","v":""},"Y","",null,null,null,{"$f":"'BA Form 2 Event Data'!S22","v":0},{"$f":"'BA Form 2 Event Data'!AG22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.8498382568359375E-2,0.75019184748331469,null,null,"DS & NL & CBA",null,null,null,null,null,null,null,{"$f":" ($M19-$N19)-($K19-($L19-Adjustments!O19))","v":{"$error":"#VALUE!"}},0]
[16,null,{"$f":"IF(B20=\"\",\" \",B20-LOOKUP(D20,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E23","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U23-'BA Form 2 Event Data'!J23","v":0},{"$f":"IF('Data Entry'!E20<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U23<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J23,'BA Form 2 Event Data'!U23-'BA Form 2 Event Data'!J23)),(IF('BA Form 2 Event Data'!U23<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J23,'BA Form 2 Event Data'!U23-'BA Form 2 Event Data'!J23)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U23>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J23,'BA Form 2 Event Data'!U23-'BA Form 2 Event Data'!J23)),(IF('BA Form 2 Event Data'!U23>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J23,'BA Form 2 Event Data'!U23-'BA Form 2 Event Data'!J23)))))","v":0},{"$f":"'BA Form 2 Event Data'!K23","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V19) = \"v\",(Adjustments!$D19+Adjustments!$G19+Adjustments!$J19+Adjustments!$M19+Adjustments!$P19+Adjustments!$S19),0)","v":0},{"$f":"'BA Form 2 Event Data'!V23","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V19) = \"v\",(Adjustments!$E19+Adjustments!$H19+Adjustments!$K19+Adjustments!$N19+Adjustments!$Q19+Adjustments!$T19),0)","v":0},{"$f":"IF($O20=\"y\", \"\",IF(CELL(\"type\",$G20) = \"v\",(($K20-$L20+Adjustments!$Q19)-($I20-$J20+Adjustments!$P19))/(10*$G20),\"\"))","v":""},{"$f":"IF($O20=\"y\", \"\",IF(CELL(\"type\",$G20) = \"v\",(($K20-$L20)-($I20-$J20))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U23<AO$65,AO$65,IF('BA Form 2 Event Data'!U23>AP$65,AP$65,'BA Form 2 Event Data'!U23-'BA Form 2 Event Data'!J23))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U23<AO$66,AO$66,IF('BA Form 2 Event Data'!U23>AP$66,AP$66,'BA Form 2 Event Data'!U23-'BA Form 2 Event Data'!J23))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U23<AO$67,AO$67,IF('BA Form 2 Event Data'!U23>AP$67,AP$67,'BA Form 2 Event Data'!U23-'BA Form 2 Event Data'!J23))),(IF('BA Form 2 Event Data'!U23<AO$68,AO$68,IF('BA Form 2 Event Data'!U23>AP$68,AP$68,'BA Form 2 Event Data'!U23-'BA Form 2 Event Data'!J23)))))))))),\"\"))","v":""},"Y","",null,null,null,{"$f":"'BA Form 2 Event Data'!S23","v":0},{"$f":"'BA Form 2 Event Data'!AG23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4.850006103515625E-2,2.2300577799479129,null,null,"DS & NL & PH & ID",null,null,null,null,null,null,null,{"$f":" ($M20-$N20)-($K20-($L20-Adjustments!O20))","v":{"$error":"#VALUE!"}},0]
[17,null,{"$f":"IF(B21=\"\",\" \",B21-LOOKUP(D21,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E24","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U24-'BA Form 2 Event Data'!J24","v":0},{"$f":"IF('Data Entry'!E21<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U24<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J24,'BA Form 2 Event Data'!U24-'BA Form 2 Event Data'!J24)),(IF('BA Form 2 Event Data'!U24<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J24,'BA Form 2 Event Data'!U24-'BA Form 2 Event Data'!J24)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U24>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J24,'BA Form 2 Event Data'!U24-'BA Form 2 Event Data'!J24)),(IF('BA Form 2 Event Data'!U24>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J24,'BA Form 2 Event Data'!U24-'BA Form 2 Event Data'!J24)))))","v":0},{"$f":"'BA Form 2 Event Data'!K24","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V20) = \"v\",(Adjustments!$D20+Adjustments!$G20+Adjustments!$J20+Adjustments!$M20+Adjustments!$P20+Adjustments!$S20),0)","v":0},{"$f":"'BA Form 2 Event Data'!V24","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V20) = \"v\",(Adjustments!$E20+Adjustments!$H20+Adjustments!$K20+Adjustments!$N20+Adjustments!$Q20+Adjustments!$T20),0)","v":0},{"$f":"IF($O21=\"y\", \"\",IF(CELL(\"type\",$G21) = \"v\",(($K21-$L21+Adjustments!$Q20)-($I21-$J21+Adjustments!$P20))/(10*$G21),\"\"))","v":""},{"$f":"IF($O21=\"y\", \"\",IF(CELL(\"type\",$G21) = \"v\",(($K21-$L21)-($I21-$J21))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U24<AO$65,AO$65,IF('BA Form 2 Event Data'!U24>AP$65,AP$65,'BA Form 2 Event Data'!U24-'BA Form 2 Event Data'!J24))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U24<AO$66,AO$66,IF('BA Form 2 Event Data'!U24>AP$66,AP$66,'BA Form 2 Event Data'!U24-'BA Form 2 Event Data'!J24))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U24<AO$67,AO$67,IF('BA Form 2 Event Data'!U24>AP$67,AP$67,'BA Form 2 Event Data'!U24-'BA Form 2 Event Data'!J24))),(IF('BA Form 2 Event Data'!U24<AO$68,AO$68,IF('BA Form 2 Event Data'!U24>AP$68,AP$68,'BA Form 2 Event Data'!U24-'BA Form 2 Event Data'!J24)))))))))),\"\"))","v":""},"Y","",{"$f":"\" FRM Performance Results for \"&Q$31","v":" FRM Performance Results for 2018"},null,null,{"$f":"'BA Form 2 Event Data'!S24","v":0},{"$f":"'BA Form 2 Event Data'!AG24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4.5000076293945313E-2,9.4778593301773064,null,null,"DS & NL & PH & TFR",null,null,null,null,null,null,null,{"$f":" ($M21-$N21)-($K21-($L21-Adjustments!O21))","v":{"$error":"#VALUE!"}},0]
[18,null,{"$f":"IF(B22=\"\",\" \",B22-LOOKUP(D22,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E25","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U25-'BA Form 2 Event Data'!J25","v":0},{"$f":"IF('Data Entry'!E22<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U25<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J25,'BA Form 2 Event Data'!U25-'BA Form 2 Event Data'!J25)),(IF('BA Form 2 Event Data'!U25<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J25,'BA Form 2 Event Data'!U25-'BA Form 2 Event Data'!J25)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U25>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J25,'BA Form 2 Event Data'!U25-'BA Form 2 Event Data'!J25)),(IF('BA Form 2 Event Data'!U25>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J25,'BA Form 2 Event Data'!U25-'BA Form 2 Event Data'!J25)))))","v":0},{"$f":"'BA Form 2 Event Data'!K25","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V21) = \"v\",(Adjustments!$D21+Adjustments!$G21+Adjustments!$J21+Adjustments!$M21+Adjustments!$P21+Adjustments!$S21),0)","v":0},{"$f":"'BA Form 2 Event Data'!V25","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V21) = \"v\",(Adjustments!$E21+Adjustments!$H21+Adjustments!$K21+Adjustments!$N21+Adjustments!$Q21+Adjustments!$T21),0)","v":0},{"$f":"IF($O22=\"y\", \"\",IF(CELL(\"type\",$G22) = \"v\",(($K22-$L22+Adjustments!$Q21)-($I22-$J22+Adjustments!$P21))/(10*$G22),\"\"))","v":""},{"$f":"IF($O22=\"y\", \"\",IF(CELL(\"type\",$G22) = \"v\",(($K22-$L22)-($I22-$J22))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U25<AO$65,AO$65,IF('BA Form 2 Event Data'!U25>AP$65,AP$65,'BA Form 2 Event Data'!U25-'BA Form 2 Event Data'!J25))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U25<AO$66,AO$66,IF('BA Form 2 Event Data'!U25>AP$66,AP$66,'BA Form 2 Event Data'!U25-'BA Form 2 Event Data'!J25))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U25<AO$67,AO$67,IF('BA Form 2 Event Data'!U25>AP$67,AP$67,'BA Form 2 Event Data'!U25-'BA Form 2 Event Data'!J25))),(IF('BA Form 2 Event Data'!U25<AO$68,AO$68,IF('BA Form 2 Event Data'!U25>AP$68,AP$68,'BA Form 2 Event Data'!U25-'BA Form 2 Event Data'!J25)))))))))),\"\"))","v":""},"Y","",{"$f":"MEDIAN(N$5:N$46)","v":0},{"$f":"Q$31&\" FRM - Median Estimated Frequency Response MW/0.1Hz for BA Compliance to R1, minimum Frequency Response\"","v":"2018 FRM - Median Estimated Frequency Response MW/0.1Hz for BA Compliance to R1, minimum Frequency Response"},null,{"$f":"'BA Form 2 Event Data'!S25","v":0},{"$f":"'BA Form 2 Event Data'!AG25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.7502288818359375E-2,0.35530900955200195,null,null,"DS & NL & PH & CBA",null,null,null,null,null,null,null,{"$f":" ($M22-$N22)-($K22-($L22-Adjustments!O22))","v":{"$error":"#VALUE!"}},0]
[19,null,{"$f":"IF(B23=\"\",\" \",B23-LOOKUP(D23,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E26","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U26-'BA Form 2 Event Data'!J26","v":0},{"$f":"IF('Data Entry'!E23<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U26<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J26,'BA Form 2 Event Data'!U26-'BA Form 2 Event Data'!J26)),(IF('BA Form 2 Event Data'!U26<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J26,'BA Form 2 Event Data'!U26-'BA Form 2 Event Data'!J26)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U26>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J26,'BA Form 2 Event Data'!U26-'BA Form 2 Event Data'!J26)),(IF('BA Form 2 Event Data'!U26>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J26,'BA Form 2 Event Data'!U26-'BA Form 2 Event Data'!J26)))))","v":0},{"$f":"'BA Form 2 Event Data'!K26","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V22) = \"v\",(Adjustments!$D22+Adjustments!$G22+Adjustments!$J22+Adjustments!$M22+Adjustments!$P22+Adjustments!$S22),0)","v":0},{"$f":"'BA Form 2 Event Data'!V26","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V22) = \"v\",(Adjustments!$E22+Adjustments!$H22+Adjustments!$K22+Adjustments!$N22+Adjustments!$Q22+Adjustments!$T22),0)","v":0},{"$f":"IF($O23=\"y\", \"\",IF(CELL(\"type\",$G23) = \"v\",(($K23-$L23+Adjustments!$Q22)-($I23-$J23+Adjustments!$P22))/(10*$G23),\"\"))","v":""},{"$f":"IF($O23=\"y\", \"\",IF(CELL(\"type\",$G23) = \"v\",(($K23-$L23)-($I23-$J23))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U26<AO$65,AO$65,IF('BA Form 2 Event Data'!U26>AP$65,AP$65,'BA Form 2 Event Data'!U26-'BA Form 2 Event Data'!J26))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U26<AO$66,AO$66,IF('BA Form 2 Event Data'!U26>AP$66,AP$66,'BA Form 2 Event Data'!U26-'BA Form 2 Event Data'!J26))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U26<AO$67,AO$67,IF('BA Form 2 Event Data'!U26>AP$67,AP$67,'BA Form 2 Event Data'!U26-'BA Form 2 Event Data'!J26))),(IF('BA Form 2 Event Data'!U26<AO$68,AO$68,IF('BA Form 2 Event Data'!U26>AP$68,AP$68,'BA Form 2 Event Data'!U26-'BA Form 2 Event Data'!J26)))))))))),\"\"))","v":""},"Y","",null,null,null,{"$f":"'BA Form 2 Event Data'!S26","v":0},{"$f":"'BA Form 2 Event Data'!AG26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4.75006103515625E-2,2.1707018534342453,null,null,"DS & NL & PH & ID & TFR",null,null,null,null,null,null,null,{"$f":" ($M23-$N23)-($K23-($L23-Adjustments!O23))","v":{"$error":"#VALUE!"}},0]
[20,null,{"$f":"IF(B24=\"\",\" \",B24-LOOKUP(D24,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E27","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U27-'BA Form 2 Event Data'!J27","v":0},{"$f":"IF('Data Entry'!E24<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U27<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J27,'BA Form 2 Event Data'!U27-'BA Form 2 Event Data'!J27)),(IF('BA Form 2 Event Data'!U27<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J27,'BA Form 2 Event Data'!U27-'BA Form 2 Event Data'!J27)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U27>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J27,'BA Form 2 Event Data'!U27-'BA Form 2 Event Data'!J27)),(IF('BA Form 2 Event Data'!U27>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J27,'BA Form 2 Event Data'!U27-'BA Form 2 Event Data'!J27)))))","v":0},{"$f":"'BA Form 2 Event Data'!K27","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V23) = \"v\",(Adjustments!$D23+Adjustments!$G23+Adjustments!$J23+Adjustments!$M23+Adjustments!$P23+Adjustments!$S23),0)","v":0},{"$f":"'BA Form 2 Event Data'!V27","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V23) = \"v\",(Adjustments!$E23+Adjustments!$H23+Adjustments!$K23+Adjustments!$N23+Adjustments!$Q23+Adjustments!$T23),0)","v":0},{"$f":"IF($O24=\"y\", \"\",IF(CELL(\"type\",$G24) = \"v\",(($K24-$L24+Adjustments!$Q23)-($I24-$J24+Adjustments!$P23))/(10*$G24),\"\"))","v":""},{"$f":"IF($O24=\"y\", \"\",IF(CELL(\"type\",$G24) = \"v\",(($K24-$L24)-($I24-$J24))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U27<AO$65,AO$65,IF('BA Form 2 Event Data'!U27>AP$65,AP$65,'BA Form 2 Event Data'!U27-'BA Form 2 Event Data'!J27))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U27<AO$66,AO$66,IF('BA Form 2 Event Data'!U27>AP$66,AP$66,'BA Form 2 Event Data'!U27-'BA Form 2 Event Data'!J27))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U27<AO$67,AO$67,IF('BA Form 2 Event Data'!U27>AP$67,AP$67,'BA Form 2 Event Data'!U27-'BA Form 2 Event Data'!J27))),(IF('BA Form 2 Event Data'!U27<AO$68,AO$68,IF('BA Form 2 Event Data'!U27>AP$68,AP$68,'BA Form 2 Event Data'!U27-'BA Form 2 Event Data'!J27)))))))))),\"\"))","v":""},"Y","",{"$f":"FRO","v":-2},{"$f":"Q$31&\" BA Frequency Response Obligation (FRO)\"","v":"2018 BA Frequency Response Obligation (FRO)"},null,{"$f":"'BA Form 2 Event Data'!S27","v":0},{"$f":"'BA Form 2 Event Data'!AG27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.5500030517578125E-2,29.382074276606243,null,null,"DS & NL & PH & ID & CBA",null,null,null,null,null,null,null,{"$f":" ($M24-$N24)-($K24-($L24-Adjustments!O24))","v":{"$error":"#VALUE!"}},0]
[21,null,{"$f":"IF(B25=\"\",\" \",B25-LOOKUP(D25,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E28","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U28-'BA Form 2 Event Data'!J28","v":0},{"$f":"IF('Data Entry'!E25<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U28<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J28,'BA Form 2 Event Data'!U28-'BA Form 2 Event Data'!J28)),(IF('BA Form 2 Event Data'!U28<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J28,'BA Form 2 Event Data'!U28-'BA Form 2 Event Data'!J28)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U28>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J28,'BA Form 2 Event Data'!U28-'BA Form 2 Event Data'!J28)),(IF('BA Form 2 Event Data'!U28>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J28,'BA Form 2 Event Data'!U28-'BA Form 2 Event Data'!J28)))))","v":0},{"$f":"'BA Form 2 Event Data'!K28","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V24) = \"v\",(Adjustments!$D24+Adjustments!$G24+Adjustments!$J24+Adjustments!$M24+Adjustments!$P24+Adjustments!$S24),0)","v":0},{"$f":"'BA Form 2 Event Data'!V28","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V24) = \"v\",(Adjustments!$E24+Adjustments!$H24+Adjustments!$K24+Adjustments!$N24+Adjustments!$Q24+Adjustments!$T24),0)","v":0},{"$f":"IF($O25=\"y\", \"\",IF(CELL(\"type\",$G25) = \"v\",(($K25-$L25+Adjustments!$Q24)-($I25-$J25+Adjustments!$P24))/(10*$G25),\"\"))","v":""},{"$f":"IF($O25=\"y\", \"\",IF(CELL(\"type\",$G25) = \"v\",(($K25-$L25)-($I25-$J25))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U28<AO$65,AO$65,IF('BA Form 2 Event Data'!U28>AP$65,AP$65,'BA Form 2 Event Data'!U28-'BA Form 2 Event Data'!J28))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U28<AO$66,AO$66,IF('BA Form 2 Event Data'!U28>AP$66,AP$66,'BA Form 2 Event Data'!U28-'BA Form 2 Event Data'!J28))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U28<AO$67,AO$67,IF('BA Form 2 Event Data'!U28>AP$67,AP$67,'BA Form 2 Event Data'!U28-'BA Form 2 Event Data'!J28))),(IF('BA Form 2 Event Data'!U28<AO$68,AO$68,IF('BA Form 2 Event Data'!U28>AP$68,AP$68,'BA Form 2 Event Data'!U28-'BA Form 2 Event Data'!J28)))))))))),\"\"))","v":""},"Y","",{"$f":"AVERAGE(N$5:N$46)","v":0},{"$f":"Q$31&\" FRM - Average Estimated Frequency Response MW/0.1 Hz using SEFRD for R1\"","v":"2018 FRM - Average Estimated Frequency Response MW/0.1 Hz using SEFRD for R1"},null,{"$f":"'BA Form 2 Event Data'!S28","v":0},{"$f":"'BA Form 2 Event Data'!AG28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4.7E-2,4.6013813018798828,null,null,"DS & NL & PH & ID & TFR & CBA",null,null,null,null,null,null,null,{"$f":" ($M25-$N25)-($K25-($L25-Adjustments!O25))","v":{"$error":"#VALUE!"}},0]
[22,null,{"$f":"IF(B26=\"\",\" \",B26-LOOKUP(D26,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E29","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U29-'BA Form 2 Event Data'!J29","v":0},{"$f":"IF('Data Entry'!E26<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U29<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J29,'BA Form 2 Event Data'!U29-'BA Form 2 Event Data'!J29)),(IF('BA Form 2 Event Data'!U29<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J29,'BA Form 2 Event Data'!U29-'BA Form 2 Event Data'!J29)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U29>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J29,'BA Form 2 Event Data'!U29-'BA Form 2 Event Data'!J29)),(IF('BA Form 2 Event Data'!U29>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J29,'BA Form 2 Event Data'!U29-'BA Form 2 Event Data'!J29)))))","v":0},{"$f":"'BA Form 2 Event Data'!K29","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V25) = \"v\",(Adjustments!$D25+Adjustments!$G25+Adjustments!$J25+Adjustments!$M25+Adjustments!$P25+Adjustments!$S25),0)","v":0},{"$f":"'BA Form 2 Event Data'!V29","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V25) = \"v\",(Adjustments!$E25+Adjustments!$H25+Adjustments!$K25+Adjustments!$N25+Adjustments!$Q25+Adjustments!$T25),0)","v":0},{"$f":"IF($O26=\"y\", \"\",IF(CELL(\"type\",$G26) = \"v\",(($K26-$L26+Adjustments!$Q25)-($I26-$J26+Adjustments!$P25))/(10*$G26),\"\"))","v":""},{"$f":"IF($O26=\"y\", \"\",IF(CELL(\"type\",$G26) = \"v\",(($K26-$L26)-($I26-$J26))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U29<AO$65,AO$65,IF('BA Form 2 Event Data'!U29>AP$65,AP$65,'BA Form 2 Event Data'!U29-'BA Form 2 Event Data'!J29))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U29<AO$66,AO$66,IF('BA Form 2 Event Data'!U29>AP$66,AP$66,'BA Form 2 Event Data'!U29-'BA Form 2 Event Data'!J29))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U29<AO$67,AO$67,IF('BA Form 2 Event Data'!U29>AP$67,AP$67,'BA Form 2 Event Data'!U29-'BA Form 2 Event Data'!J29))),(IF('BA Form 2 Event Data'!U29<AO$68,AO$68,IF('BA Form 2 Event Data'!U29>AP$68,AP$68,'BA Form 2 Event Data'!U29-'BA Form 2 Event Data'!J29)))))))))),\"\"))","v":""},"Y","",null,null,null,{"$f":"'BA Form 2 Event Data'!S29","v":0},{"$f":"'BA Form 2 Event Data'!AG29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-6.0000000000002274E-2,1.5935148795445762,null,null,"NL & PH",null,null,null,null,null,null,null,{"$f":" ($M26-$N26)-($K26-($L26-Adjustments!O26))","v":{"$error":"#VALUE!"}},0]
[23,null,{"$f":"IF(B27=\"\",\" \",B27-LOOKUP(D27,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E30","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U30-'BA Form 2 Event Data'!J30","v":0},{"$f":"IF('Data Entry'!E27<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U30<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J30,'BA Form 2 Event Data'!U30-'BA Form 2 Event Data'!J30)),(IF('BA Form 2 Event Data'!U30<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J30,'BA Form 2 Event Data'!U30-'BA Form 2 Event Data'!J30)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U30>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J30,'BA Form 2 Event Data'!U30-'BA Form 2 Event Data'!J30)),(IF('BA Form 2 Event Data'!U30>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J30,'BA Form 2 Event Data'!U30-'BA Form 2 Event Data'!J30)))))","v":0},{"$f":"'BA Form 2 Event Data'!K30","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V26) = \"v\",(Adjustments!$D26+Adjustments!$G26+Adjustments!$J26+Adjustments!$M26+Adjustments!$P26+Adjustments!$S26),0)","v":0},{"$f":"'BA Form 2 Event Data'!V30","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V26) = \"v\",(Adjustments!$E26+Adjustments!$H26+Adjustments!$K26+Adjustments!$N26+Adjustments!$Q26+Adjustments!$T26),0)","v":0},{"$f":"IF($O27=\"y\", \"\",IF(CELL(\"type\",$G27) = \"v\",(($K27-$L27+Adjustments!$Q26)-($I27-$J27+Adjustments!$P26))/(10*$G27),\"\"))","v":""},{"$f":"IF($O27=\"y\", \"\",IF(CELL(\"type\",$G27) = \"v\",(($K27-$L27)-($I27-$J27))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U30<AO$65,AO$65,IF('BA Form 2 Event Data'!U30>AP$65,AP$65,'BA Form 2 Event Data'!U30-'BA Form 2 Event Data'!J30))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U30<AO$66,AO$66,IF('BA Form 2 Event Data'!U30>AP$66,AP$66,'BA Form 2 Event Data'!U30-'BA Form 2 Event Data'!J30))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U30<AO$67,AO$67,IF('BA Form 2 Event Data'!U30>AP$67,AP$67,'BA Form 2 Event Data'!U30-'BA Form 2 Event Data'!J30))),(IF('BA Form 2 Event Data'!U30<AO$68,AO$68,IF('BA Form 2 Event Data'!U30>AP$68,AP$68,'BA Form 2 Event Data'!U30-'BA Form 2 Event Data'!J30)))))))))),\"\"))","v":""},"Y","",null,null,null,{"$f":"'BA Form 2 Event Data'!S30","v":0},{"$f":"'BA Form 2 Event Data'!AG30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.9999999999995168E-2,52.370907783508301,null,null,"NL & ID",null,null,null,null,null,null,null,{"$f":" ($M27-$N27)-($K27-($L27-Adjustments!O27))","v":{"$error":"#VALUE!"}},0]
[24,null,{"$f":"IF(B28=\"\",\" \",B28-LOOKUP(D28,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E31","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U31-'BA Form 2 Event Data'!J31","v":0},{"$f":"IF('Data Entry'!E28<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U31<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J31,'BA Form 2 Event Data'!U31-'BA Form 2 Event Data'!J31)),(IF('BA Form 2 Event Data'!U31<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J31,'BA Form 2 Event Data'!U31-'BA Form 2 Event Data'!J31)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U31>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J31,'BA Form 2 Event Data'!U31-'BA Form 2 Event Data'!J31)),(IF('BA Form 2 Event Data'!U31>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J31,'BA Form 2 Event Data'!U31-'BA Form 2 Event Data'!J31)))))","v":0},{"$f":"'BA Form 2 Event Data'!K31","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V27) = \"v\",(Adjustments!$D27+Adjustments!$G27+Adjustments!$J27+Adjustments!$M27+Adjustments!$P27+Adjustments!$S27),0)","v":0},{"$f":"'BA Form 2 Event Data'!V31","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V27) = \"v\",(Adjustments!$E27+Adjustments!$H27+Adjustments!$K27+Adjustments!$N27+Adjustments!$Q27+Adjustments!$T27),0)","v":0},{"$f":"IF($O28=\"y\", \"\",IF(CELL(\"type\",$G28) = \"v\",(($K28-$L28+Adjustments!$Q27)-($I28-$J28+Adjustments!$P27))/(10*$G28),\"\"))","v":""},{"$f":"IF($O28=\"y\", \"\",IF(CELL(\"type\",$G28) = \"v\",(($K28-$L28)-($I28-$J28))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U31<AO$65,AO$65,IF('BA Form 2 Event Data'!U31>AP$65,AP$65,'BA Form 2 Event Data'!U31-'BA Form 2 Event Data'!J31))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U31<AO$66,AO$66,IF('BA Form 2 Event Data'!U31>AP$66,AP$66,'BA Form 2 Event Data'!U31-'BA Form 2 Event Data'!J31))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U31<AO$67,AO$67,IF('BA Form 2 Event Data'!U31>AP$67,AP$67,'BA Form 2 Event Data'!U31-'BA Form 2 Event Data'!J31))),(IF('BA Form 2 Event Data'!U31<AO$68,AO$68,IF('BA Form 2 Event Data'!U31>AP$68,AP$68,'BA Form 2 Event Data'!U31-'BA Form 2 Event Data'!J31)))))))))),\"\"))","v":""},"Y","",{"$f":"\" FRO Calculation Worksheet for \"&Q$31+1","v":" FRO Calculation Worksheet for 2019"},null,null,{"$f":"'BA Form 2 Event Data'!S31","v":0},{"$f":"'BA Form 2 Event Data'!AG31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.1000000000001933E-2,33.947873671849564,null,null,"NL & TFR",null,null,null,null,null,null,null,{"$f":" ($M28-$N28)-($K28-($L28-Adjustments!O28))","v":{"$error":"#VALUE!"}},0]
[25,null,{"$f":"IF(B29=\"\",\" \",B29-LOOKUP(D29,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E32","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U32-'BA Form 2 Event Data'!J32","v":0},{"$f":"IF('Data Entry'!E29<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U32<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J32,'BA Form 2 Event Data'!U32-'BA Form 2 Event Data'!J32)),(IF('BA Form 2 Event Data'!U32<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J32,'BA Form 2 Event Data'!U32-'BA Form 2 Event Data'!J32)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U32>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J32,'BA Form 2 Event Data'!U32-'BA Form 2 Event Data'!J32)),(IF('BA Form 2 Event Data'!U32>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J32,'BA Form 2 Event Data'!U32-'BA Form 2 Event Data'!J32)))))","v":0},{"$f":"'BA Form 2 Event Data'!K32","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V28) = \"v\",(Adjustments!$D28+Adjustments!$G28+Adjustments!$J28+Adjustments!$M28+Adjustments!$P28+Adjustments!$S28),0)","v":0},{"$f":"'BA Form 2 Event Data'!V32","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V28) = \"v\",(Adjustments!$E28+Adjustments!$H28+Adjustments!$K28+Adjustments!$N28+Adjustments!$Q28+Adjustments!$T28),0)","v":0},{"$f":"IF($O29=\"y\", \"\",IF(CELL(\"type\",$G29) = \"v\",(($K29-$L29+Adjustments!$Q28)-($I29-$J29+Adjustments!$P28))/(10*$G29),\"\"))","v":""},{"$f":"IF($O29=\"y\", \"\",IF(CELL(\"type\",$G29) = \"v\",(($K29-$L29)-($I29-$J29))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U32<AO$65,AO$65,IF('BA Form 2 Event Data'!U32>AP$65,AP$65,'BA Form 2 Event Data'!U32-'BA Form 2 Event Data'!J32))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U32<AO$66,AO$66,IF('BA Form 2 Event Data'!U32>AP$66,AP$66,'BA Form 2 Event Data'!U32-'BA Form 2 Event Data'!J32))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U32<AO$67,AO$67,IF('BA Form 2 Event Data'!U32>AP$67,AP$67,'BA Form 2 Event Data'!U32-'BA Form 2 Event Data'!J32))),(IF('BA Form 2 Event Data'!U32<AO$68,AO$68,IF('BA Form 2 Event Data'!U32>AP$68,AP$68,'BA Form 2 Event Data'!U32-'BA Form 2 Event Data'!J32)))))))))),\"\"))","v":""},"Y","",{"$f":"C1","v":"AEC"},"Balancing Authority",null,{"$f":"'BA Form 2 Event Data'!S32","v":0},{"$f":"'BA Form 2 Event Data'!AG32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.1,100,null,null,"NL & CBA",null,null,null,null,null,null,null,{"$f":" ($M29-$N29)-($K29-($L29-Adjustments!O29))","v":{"$error":"#VALUE!"}},0]
[26,null,{"$f":"IF(B30=\"\",\" \",B30-LOOKUP(D30,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E33","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U33-'BA Form 2 Event Data'!J33","v":0},{"$f":"IF('Data Entry'!E30<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U33<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J33,'BA Form 2 Event Data'!U33-'BA Form 2 Event Data'!J33)),(IF('BA Form 2 Event Data'!U33<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J33,'BA Form 2 Event Data'!U33-'BA Form 2 Event Data'!J33)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U33>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J33,'BA Form 2 Event Data'!U33-'BA Form 2 Event Data'!J33)),(IF('BA Form 2 Event Data'!U33>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J33,'BA Form 2 Event Data'!U33-'BA Form 2 Event Data'!J33)))))","v":0},{"$f":"'BA Form 2 Event Data'!K33","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V29) = \"v\",(Adjustments!$D29+Adjustments!$G29+Adjustments!$J29+Adjustments!$M29+Adjustments!$P29+Adjustments!$S29),0)","v":0},{"$f":"'BA Form 2 Event Data'!V33","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V29) = \"v\",(Adjustments!$E29+Adjustments!$H29+Adjustments!$K29+Adjustments!$N29+Adjustments!$Q29+Adjustments!$T29),0)","v":0},{"$f":"IF($O30=\"y\", \"\",IF(CELL(\"type\",$G30) = \"v\",(($K30-$L30+Adjustments!$Q29)-($I30-$J30+Adjustments!$P29))/(10*$G30),\"\"))","v":""},{"$f":"IF($O30=\"y\", \"\",IF(CELL(\"type\",$G30) = \"v\",(($K30-$L30)-($I30-$J30))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U33<AO$65,AO$65,IF('BA Form 2 Event Data'!U33>AP$65,AP$65,'BA Form 2 Event Data'!U33-'BA Form 2 Event Data'!J33))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U33<AO$66,AO$66,IF('BA Form 2 Event Data'!U33>AP$66,AP$66,'BA Form 2 Event Data'!U33-'BA Form 2 Event Data'!J33))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U33<AO$67,AO$67,IF('BA Form 2 Event Data'!U33>AP$67,AP$67,'BA Form 2 Event Data'!U33-'BA Form 2 Event Data'!J33))),(IF('BA Form 2 Event Data'!U33<AO$68,AO$68,IF('BA Form 2 Event Data'!U33>AP$68,AP$68,'BA Form 2 Event Data'!U33-'BA Form 2 Event Data'!J33)))))))))),\"\"))","v":""},"Y","",{"$f":"IF(Interconnection=\"Western\",'FRO Data'!F3,'FRO Data'!F2)","v":-1015},"Interconnection Frequency Response Obligation (FRO) MW/0.1 Hz.  Determined by ERO.",null,{"$f":"'BA Form 2 Event Data'!S33","v":0},{"$f":"'BA Form 2 Event Data'!AG33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NL & PH & ID",null,null,null,null,null,null,null,{"$f":" ($M30-$N30)-($K30-($L30-Adjustments!O30))","v":{"$error":"#VALUE!"}},0]
[27,null,{"$f":"IF(B31=\"\",\" \",B31-LOOKUP(D31,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E34","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U34-'BA Form 2 Event Data'!J34","v":0},{"$f":"IF('Data Entry'!E31<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U34<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J34,'BA Form 2 Event Data'!U34-'BA Form 2 Event Data'!J34)),(IF('BA Form 2 Event Data'!U34<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J34,'BA Form 2 Event Data'!U34-'BA Form 2 Event Data'!J34)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U34>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J34,'BA Form 2 Event Data'!U34-'BA Form 2 Event Data'!J34)),(IF('BA Form 2 Event Data'!U34>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J34,'BA Form 2 Event Data'!U34-'BA Form 2 Event Data'!J34)))))","v":0},{"$f":"'BA Form 2 Event Data'!K34","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V30) = \"v\",(Adjustments!$D30+Adjustments!$G30+Adjustments!$J30+Adjustments!$M30+Adjustments!$P30+Adjustments!$S30),0)","v":0},{"$f":"'BA Form 2 Event Data'!V34","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V30) = \"v\",(Adjustments!$E30+Adjustments!$H30+Adjustments!$K30+Adjustments!$N30+Adjustments!$Q30+Adjustments!$T30),0)","v":0},{"$f":"IF($O31=\"y\", \"\",IF(CELL(\"type\",$G31) = \"v\",(($K31-$L31+Adjustments!$Q30)-($I31-$J31+Adjustments!$P30))/(10*$G31),\"\"))","v":""},{"$f":"IF($O31=\"y\", \"\",IF(CELL(\"type\",$G31) = \"v\",(($K31-$L31)-($I31-$J31))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U34<AO$65,AO$65,IF('BA Form 2 Event Data'!U34>AP$65,AP$65,'BA Form 2 Event Data'!U34-'BA Form 2 Event Data'!J34))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U34<AO$66,AO$66,IF('BA Form 2 Event Data'!U34>AP$66,AP$66,'BA Form 2 Event Data'!U34-'BA Form 2 Event Data'!J34))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U34<AO$67,AO$67,IF('BA Form 2 Event Data'!U34>AP$67,AP$67,'BA Form 2 Event Data'!U34-'BA Form 2 Event Data'!J34))),(IF('BA Form 2 Event Data'!U34<AO$68,AO$68,IF('BA Form 2 Event Data'!U34>AP$68,AP$68,'BA Form 2 Event Data'!U34-'BA Form 2 Event Data'!J34)))))))))),\"\"))","v":""},"Y","",2018,"Operating Year FRM (December thru November) for calculating 2017 Bias",null,{"$f":"'BA Form 2 Event Data'!S34","v":0},{"$f":"'BA Form 2 Event Data'!AG34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NL & PH & TFR",null,null,null,null,null,null,null,{"$f":" ($M31-$N31)-($K31-($L31-Adjustments!O31))","v":{"$error":"#VALUE!"}},0]
[28,null,{"$f":"IF(B32=\"\",\" \",B32-LOOKUP(D32,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E35","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U35-'BA Form 2 Event Data'!J35","v":0},{"$f":"IF('Data Entry'!E32<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U35<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J35,'BA Form 2 Event Data'!U35-'BA Form 2 Event Data'!J35)),(IF('BA Form 2 Event Data'!U35<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J35,'BA Form 2 Event Data'!U35-'BA Form 2 Event Data'!J35)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U35>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J35,'BA Form 2 Event Data'!U35-'BA Form 2 Event Data'!J35)),(IF('BA Form 2 Event Data'!U35>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J35,'BA Form 2 Event Data'!U35-'BA Form 2 Event Data'!J35)))))","v":0},{"$f":"'BA Form 2 Event Data'!K35","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V31) = \"v\",(Adjustments!$D31+Adjustments!$G31+Adjustments!$J31+Adjustments!$M31+Adjustments!$P31+Adjustments!$S31),0)","v":0},{"$f":"'BA Form 2 Event Data'!V35","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V31) = \"v\",(Adjustments!$E31+Adjustments!$H31+Adjustments!$K31+Adjustments!$N31+Adjustments!$Q31+Adjustments!$T31),0)","v":0},{"$f":"IF($O32=\"y\", \"\",IF(CELL(\"type\",$G32) = \"v\",(($K32-$L32+Adjustments!$Q31)-($I32-$J32+Adjustments!$P31))/(10*$G32),\"\"))","v":""},{"$f":"IF($O32=\"y\", \"\",IF(CELL(\"type\",$G32) = \"v\",(($K32-$L32)-($I32-$J32))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U35<AO$65,AO$65,IF('BA Form 2 Event Data'!U35>AP$65,AP$65,'BA Form 2 Event Data'!U35-'BA Form 2 Event Data'!J35))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U35<AO$66,AO$66,IF('BA Form 2 Event Data'!U35>AP$66,AP$66,'BA Form 2 Event Data'!U35-'BA Form 2 Event Data'!J35))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U35<AO$67,AO$67,IF('BA Form 2 Event Data'!U35>AP$67,AP$67,'BA Form 2 Event Data'!U35-'BA Form 2 Event Data'!J35))),(IF('BA Form 2 Event Data'!U35<AO$68,AO$68,IF('BA Form 2 Event Data'!U35>AP$68,AP$68,'BA Form 2 Event Data'!U35-'BA Form 2 Event Data'!J35)))))))))),\"\"))","v":""},"Y","",{"$f":"INDEX('FRO Data'!$G$10:$G$83,MATCH(MyBA,'FRO Data'!$C$10:$C$83,0))","v":0},{"$f":"\"Operating Year \"&Q$31+1&\" BA Frequency Response Obligation (FRO) for next year's FRM\"","v":"Operating Year 2019 BA Frequency Response Obligation (FRO) for next year's FRM"},null,{"$f":"'BA Form 2 Event Data'!S35","v":0},{"$f":"'BA Form 2 Event Data'!AG35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NL & PH & BAA",null,null,null,null,null,null,null,{"$f":" ($M32-$N32)-($K32-($L32-Adjustments!O32))","v":{"$error":"#VALUE!"}},0]
[29,null,{"$f":"IF(B33=\"\",\" \",B33-LOOKUP(D33,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E36","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U36-'BA Form 2 Event Data'!J36","v":0},{"$f":"IF('Data Entry'!E33<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U36<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J36,'BA Form 2 Event Data'!U36-'BA Form 2 Event Data'!J36)),(IF('BA Form 2 Event Data'!U36<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J36,'BA Form 2 Event Data'!U36-'BA Form 2 Event Data'!J36)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U36>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J36,'BA Form 2 Event Data'!U36-'BA Form 2 Event Data'!J36)),(IF('BA Form 2 Event Data'!U36>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J36,'BA Form 2 Event Data'!U36-'BA Form 2 Event Data'!J36)))))","v":0},{"$f":"'BA Form 2 Event Data'!K36","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V32) = \"v\",(Adjustments!$D32+Adjustments!$G32+Adjustments!$J32+Adjustments!$M32+Adjustments!$P32+Adjustments!$S32),0)","v":0},{"$f":"'BA Form 2 Event Data'!V36","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V32) = \"v\",(Adjustments!$E32+Adjustments!$H32+Adjustments!$K32+Adjustments!$N32+Adjustments!$Q32+Adjustments!$T32),0)","v":0},{"$f":"IF($O33=\"y\", \"\",IF(CELL(\"type\",$G33) = \"v\",(($K33-$L33+Adjustments!$Q32)-($I33-$J33+Adjustments!$P32))/(10*$G33),\"\"))","v":""},{"$f":"IF($O33=\"y\", \"\",IF(CELL(\"type\",$G33) = \"v\",(($K33-$L33)-($I33-$J33))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U36<AO$65,AO$65,IF('BA Form 2 Event Data'!U36>AP$65,AP$65,'BA Form 2 Event Data'!U36-'BA Form 2 Event Data'!J36))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U36<AO$66,AO$66,IF('BA Form 2 Event Data'!U36>AP$66,AP$66,'BA Form 2 Event Data'!U36-'BA Form 2 Event Data'!J36))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U36<AO$67,AO$67,IF('BA Form 2 Event Data'!U36>AP$67,AP$67,'BA Form 2 Event Data'!U36-'BA Form 2 Event Data'!J36))),(IF('BA Form 2 Event Data'!U36<AO$68,AO$68,IF('BA Form 2 Event Data'!U36>AP$68,AP$68,'BA Form 2 Event Data'!U36-'BA Form 2 Event Data'!J36)))))))))),\"\"))","v":""},"Y","",{"$f":"INDEX('FRO Data'!$F$10:$F$83,MATCH(MyBA,'FRO Data'!$C$10:$C$83,0))","v":-2},{"$f":"\"Operating Year \"&Q$31&\" BA Frequency Response Obligation (FRO).\"","v":"Operating Year 2018 BA Frequency Response Obligation (FRO)."},null,{"$f":"'BA Form 2 Event Data'!S36","v":0},{"$f":"'BA Form 2 Event Data'!AG36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NL & PH & ID & TFR",null,null,null,null,null,null,null,{"$f":" ($M33-$N33)-($K33-($L33-Adjustments!O33))","v":{"$error":"#VALUE!"}},0]
[30,null,{"$f":"IF(B34=\"\",\" \",B34-LOOKUP(D34,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E37","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U37-'BA Form 2 Event Data'!J37","v":0},{"$f":"IF('Data Entry'!E34<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U37<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J37,'BA Form 2 Event Data'!U37-'BA Form 2 Event Data'!J37)),(IF('BA Form 2 Event Data'!U37<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J37,'BA Form 2 Event Data'!U37-'BA Form 2 Event Data'!J37)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U37>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J37,'BA Form 2 Event Data'!U37-'BA Form 2 Event Data'!J37)),(IF('BA Form 2 Event Data'!U37>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J37,'BA Form 2 Event Data'!U37-'BA Form 2 Event Data'!J37)))))","v":0},{"$f":"'BA Form 2 Event Data'!K37","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V33) = \"v\",(Adjustments!$D33+Adjustments!$G33+Adjustments!$J33+Adjustments!$M33+Adjustments!$P33+Adjustments!$S33),0)","v":0},{"$f":"'BA Form 2 Event Data'!V37","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V33) = \"v\",(Adjustments!$E33+Adjustments!$H33+Adjustments!$K33+Adjustments!$N33+Adjustments!$Q33+Adjustments!$T33),0)","v":0},{"$f":"IF($O34=\"y\", \"\",IF(CELL(\"type\",$G34) = \"v\",(($K34-$L34+Adjustments!$Q33)-($I34-$J34+Adjustments!$P33))/(10*$G34),\"\"))","v":""},{"$f":"IF($O34=\"y\", \"\",IF(CELL(\"type\",$G34) = \"v\",(($K34-$L34)-($I34-$J34))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U37<AO$65,AO$65,IF('BA Form 2 Event Data'!U37>AP$65,AP$65,'BA Form 2 Event Data'!U37-'BA Form 2 Event Data'!J37))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U37<AO$66,AO$66,IF('BA Form 2 Event Data'!U37>AP$66,AP$66,'BA Form 2 Event Data'!U37-'BA Form 2 Event Data'!J37))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U37<AO$67,AO$67,IF('BA Form 2 Event Data'!U37>AP$67,AP$67,'BA Form 2 Event Data'!U37-'BA Form 2 Event Data'!J37))),(IF('BA Form 2 Event Data'!U37<AO$68,AO$68,IF('BA Form 2 Event Data'!U37>AP$68,AP$68,'BA Form 2 Event Data'!U37-'BA Form 2 Event Data'!J37)))))))))),\"\"))","v":""},"Y","",null,null,null,{"$f":"'BA Form 2 Event Data'!S37","v":0},{"$f":"'BA Form 2 Event Data'!AG37","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,null,"NL & PH & ID & CBA"]
[31,null,{"$f":"IF(B35=\"\",\" \",B35-LOOKUP(D35,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E38","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U38-'BA Form 2 Event Data'!J38","v":0},{"$f":"IF('Data Entry'!E35<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U38<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J38,'BA Form 2 Event Data'!U38-'BA Form 2 Event Data'!J38)),(IF('BA Form 2 Event Data'!U38<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J38,'BA Form 2 Event Data'!U38-'BA Form 2 Event Data'!J38)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U38>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J38,'BA Form 2 Event Data'!U38-'BA Form 2 Event Data'!J38)),(IF('BA Form 2 Event Data'!U38>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J38,'BA Form 2 Event Data'!U38-'BA Form 2 Event Data'!J38)))))","v":0},{"$f":"'BA Form 2 Event Data'!K38","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V34) = \"v\",(Adjustments!$D34+Adjustments!$G34+Adjustments!$J34+Adjustments!$M34+Adjustments!$P34+Adjustments!$S34),0)","v":0},{"$f":"'BA Form 2 Event Data'!V38","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V34) = \"v\",(Adjustments!$E34+Adjustments!$H34+Adjustments!$K34+Adjustments!$N34+Adjustments!$Q34+Adjustments!$T34),0)","v":0},{"$f":"IF($O35=\"y\", \"\",IF(CELL(\"type\",$G35) = \"v\",(($K35-$L35+Adjustments!$Q34)-($I35-$J35+Adjustments!$P34))/(10*$G35),\"\"))","v":""},{"$f":"IF($O35=\"y\", \"\",IF(CELL(\"type\",$G35) = \"v\",(($K35-$L35)-($I35-$J35))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U38<AO$65,AO$65,IF('BA Form 2 Event Data'!U38>AP$65,AP$65,'BA Form 2 Event Data'!U38-'BA Form 2 Event Data'!J38))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U38<AO$66,AO$66,IF('BA Form 2 Event Data'!U38>AP$66,AP$66,'BA Form 2 Event Data'!U38-'BA Form 2 Event Data'!J38))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U38<AO$67,AO$67,IF('BA Form 2 Event Data'!U38>AP$67,AP$67,'BA Form 2 Event Data'!U38-'BA Form 2 Event Data'!J38))),(IF('BA Form 2 Event Data'!U38<AO$68,AO$68,IF('BA Form 2 Event Data'!U38>AP$68,AP$68,'BA Form 2 Event Data'!U38-'BA Form 2 Event Data'!J38)))))))))),\"\"))","v":""},"Y","","Note- Calculations for determination of BA Bias will be included in the FINAL FRS Form 1 spreadsheet posted prior to March 2019",null,null,{"$f":"'BA Form 2 Event Data'!S38","v":0},{"$f":"'BA Form 2 Event Data'!AG38","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",null,null,"NL & PH & ID & TFR & CBA"]
[32,null,{"$f":"IF(B36=\"\",\" \",B36-LOOKUP(D36,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E39","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U39-'BA Form 2 Event Data'!J39","v":0},{"$f":"IF('Data Entry'!E36<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U39<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J39,'BA Form 2 Event Data'!U39-'BA Form 2 Event Data'!J39)),(IF('BA Form 2 Event Data'!U39<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J39,'BA Form 2 Event Data'!U39-'BA Form 2 Event Data'!J39)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U39>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J39,'BA Form 2 Event Data'!U39-'BA Form 2 Event Data'!J39)),(IF('BA Form 2 Event Data'!U39>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J39,'BA Form 2 Event Data'!U39-'BA Form 2 Event Data'!J39)))))","v":0},{"$f":"'BA Form 2 Event Data'!K39","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V35) = \"v\",(Adjustments!$D35+Adjustments!$G35+Adjustments!$J35+Adjustments!$M35+Adjustments!$P35+Adjustments!$S35),0)","v":0},{"$f":"'BA Form 2 Event Data'!V39","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V35) = \"v\",(Adjustments!$E35+Adjustments!$H35+Adjustments!$K35+Adjustments!$N35+Adjustments!$Q35+Adjustments!$T35),0)","v":0},{"$f":"IF($O36=\"y\", \"\",IF(CELL(\"type\",$G36) = \"v\",(($K36-$L36+Adjustments!$Q35)-($I36-$J36+Adjustments!$P35))/(10*$G36),\"\"))","v":""},{"$f":"IF($O36=\"y\", \"\",IF(CELL(\"type\",$G36) = \"v\",(($K36-$L36)-($I36-$J36))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U39<AO$65,AO$65,IF('BA Form 2 Event Data'!U39>AP$65,AP$65,'BA Form 2 Event Data'!U39-'BA Form 2 Event Data'!J39))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U39<AO$66,AO$66,IF('BA Form 2 Event Data'!U39>AP$66,AP$66,'BA Form 2 Event Data'!U39-'BA Form 2 Event Data'!J39))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U39<AO$67,AO$67,IF('BA Form 2 Event Data'!U39>AP$67,AP$67,'BA Form 2 Event Data'!U39-'BA Form 2 Event Data'!J39))),(IF('BA Form 2 Event Data'!U39<AO$68,AO$68,IF('BA Form 2 Event Data'!U39>AP$68,AP$68,'BA Form 2 Event Data'!U39-'BA Form 2 Event Data'!J39)))))))))),\"\"))","v":""},"Y","",null,null,null,{"$f":"'BA Form 2 Event Data'!S39","v":0},{"$f":"'BA Form 2 Event Data'!AG39","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH & ID"]
[33,null,{"$f":"IF(B37=\"\",\" \",B37-LOOKUP(D37,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E40","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U40-'BA Form 2 Event Data'!J40","v":0},{"$f":"IF('Data Entry'!E37<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U40<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J40,'BA Form 2 Event Data'!U40-'BA Form 2 Event Data'!J40)),(IF('BA Form 2 Event Data'!U40<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J40,'BA Form 2 Event Data'!U40-'BA Form 2 Event Data'!J40)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U40>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J40,'BA Form 2 Event Data'!U40-'BA Form 2 Event Data'!J40)),(IF('BA Form 2 Event Data'!U40>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J40,'BA Form 2 Event Data'!U40-'BA Form 2 Event Data'!J40)))))","v":0},{"$f":"'BA Form 2 Event Data'!K40","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V36) = \"v\",(Adjustments!$D36+Adjustments!$G36+Adjustments!$J36+Adjustments!$M36+Adjustments!$P36+Adjustments!$S36),0)","v":0},{"$f":"'BA Form 2 Event Data'!V40","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V36) = \"v\",(Adjustments!$E36+Adjustments!$H36+Adjustments!$K36+Adjustments!$N36+Adjustments!$Q36+Adjustments!$T36),0)","v":0},{"$f":"IF($O37=\"y\", \"\",IF(CELL(\"type\",$G37) = \"v\",(($K37-$L37+Adjustments!$Q36)-($I37-$J37+Adjustments!$P36))/(10*$G37),\"\"))","v":""},{"$f":"IF($O37=\"y\", \"\",IF(CELL(\"type\",$G37) = \"v\",(($K37-$L37)-($I37-$J37))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U40<AO$65,AO$65,IF('BA Form 2 Event Data'!U40>AP$65,AP$65,'BA Form 2 Event Data'!U40-'BA Form 2 Event Data'!J40))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U40<AO$66,AO$66,IF('BA Form 2 Event Data'!U40>AP$66,AP$66,'BA Form 2 Event Data'!U40-'BA Form 2 Event Data'!J40))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U40<AO$67,AO$67,IF('BA Form 2 Event Data'!U40>AP$67,AP$67,'BA Form 2 Event Data'!U40-'BA Form 2 Event Data'!J40))),(IF('BA Form 2 Event Data'!U40<AO$68,AO$68,IF('BA Form 2 Event Data'!U40>AP$68,AP$68,'BA Form 2 Event Data'!U40-'BA Form 2 Event Data'!J40)))))))))),\"\"))","v":""},"Y","","Instructions",null,null,{"$f":"'BA Form 2 Event Data'!S40","v":0},{"$f":"'BA Form 2 Event Data'!AG40","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH & TFR"]
[34,null,{"$f":"IF(B38=\"\",\" \",B38-LOOKUP(D38,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E41","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U41-'BA Form 2 Event Data'!J41","v":0},{"$f":"IF('Data Entry'!E38<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U41<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J41,'BA Form 2 Event Data'!U41-'BA Form 2 Event Data'!J41)),(IF('BA Form 2 Event Data'!U41<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J41,'BA Form 2 Event Data'!U41-'BA Form 2 Event Data'!J41)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U41>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J41,'BA Form 2 Event Data'!U41-'BA Form 2 Event Data'!J41)),(IF('BA Form 2 Event Data'!U41>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J41,'BA Form 2 Event Data'!U41-'BA Form 2 Event Data'!J41)))))","v":0},{"$f":"'BA Form 2 Event Data'!K41","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V37) = \"v\",(Adjustments!$D37+Adjustments!$G37+Adjustments!$J37+Adjustments!$M37+Adjustments!$P37+Adjustments!$S37),0)","v":0},{"$f":"'BA Form 2 Event Data'!V41","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V37) = \"v\",(Adjustments!$E37+Adjustments!$H37+Adjustments!$K37+Adjustments!$N37+Adjustments!$Q37+Adjustments!$T37),0)","v":0},{"$f":"IF($O38=\"y\", \"\",IF(CELL(\"type\",$G38) = \"v\",(($K38-$L38+Adjustments!$Q37)-($I38-$J38+Adjustments!$P37))/(10*$G38),\"\"))","v":""},{"$f":"IF($O38=\"y\", \"\",IF(CELL(\"type\",$G38) = \"v\",(($K38-$L38)-($I38-$J38))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U41<AO$65,AO$65,IF('BA Form 2 Event Data'!U41>AP$65,AP$65,'BA Form 2 Event Data'!U41-'BA Form 2 Event Data'!J41))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U41<AO$66,AO$66,IF('BA Form 2 Event Data'!U41>AP$66,AP$66,'BA Form 2 Event Data'!U41-'BA Form 2 Event Data'!J41))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U41<AO$67,AO$67,IF('BA Form 2 Event Data'!U41>AP$67,AP$67,'BA Form 2 Event Data'!U41-'BA Form 2 Event Data'!J41))),(IF('BA Form 2 Event Data'!U41<AO$68,AO$68,IF('BA Form 2 Event Data'!U41>AP$68,AP$68,'BA Form 2 Event Data'!U41-'BA Form 2 Event Data'!J41)))))))))),\"\"))","v":""},"Y","",null,null,null,{"$f":"'BA Form 2 Event Data'!S41","v":0},{"$f":"'BA Form 2 Event Data'!AG41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH & CBA"]
[35,null,{"$f":"IF(B39=\"\",\" \",B39-LOOKUP(D39,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E42","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U42-'BA Form 2 Event Data'!J42","v":0},{"$f":"IF('Data Entry'!E39<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U42<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J42,'BA Form 2 Event Data'!U42-'BA Form 2 Event Data'!J42)),(IF('BA Form 2 Event Data'!U42<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J42,'BA Form 2 Event Data'!U42-'BA Form 2 Event Data'!J42)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U42>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J42,'BA Form 2 Event Data'!U42-'BA Form 2 Event Data'!J42)),(IF('BA Form 2 Event Data'!U42>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J42,'BA Form 2 Event Data'!U42-'BA Form 2 Event Data'!J42)))))","v":0},{"$f":"'BA Form 2 Event Data'!K42","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V38) = \"v\",(Adjustments!$D38+Adjustments!$G38+Adjustments!$J38+Adjustments!$M38+Adjustments!$P38+Adjustments!$S38),0)","v":0},{"$f":"'BA Form 2 Event Data'!V42","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V38) = \"v\",(Adjustments!$E38+Adjustments!$H38+Adjustments!$K38+Adjustments!$N38+Adjustments!$Q38+Adjustments!$T38),0)","v":0},{"$f":"IF($O39=\"y\", \"\",IF(CELL(\"type\",$G39) = \"v\",(($K39-$L39+Adjustments!$Q38)-($I39-$J39+Adjustments!$P38))/(10*$G39),\"\"))","v":""},{"$f":"IF($O39=\"y\", \"\",IF(CELL(\"type\",$G39) = \"v\",(($K39-$L39)-($I39-$J39))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U42<AO$65,AO$65,IF('BA Form 2 Event Data'!U42>AP$65,AP$65,'BA Form 2 Event Data'!U42-'BA Form 2 Event Data'!J42))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U42<AO$66,AO$66,IF('BA Form 2 Event Data'!U42>AP$66,AP$66,'BA Form 2 Event Data'!U42-'BA Form 2 Event Data'!J42))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U42<AO$67,AO$67,IF('BA Form 2 Event Data'!U42>AP$67,AP$67,'BA Form 2 Event Data'!U42-'BA Form 2 Event Data'!J42))),(IF('BA Form 2 Event Data'!U42<AO$68,AO$68,IF('BA Form 2 Event Data'!U42>AP$68,AP$68,'BA Form 2 Event Data'!U42-'BA Form 2 Event Data'!J42)))))))))),\"\"))","v":""},"Y","","Step 1","Enter data in all green cells on this \"Data Entry\" worksheet.",null,{"$f":"'BA Form 2 Event Data'!S42","v":0},{"$f":"'BA Form 2 Event Data'!AG42","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH & ID & TFR"]
[36,null,{"$f":"IF(B40=\"\",\" \",B40-LOOKUP(D40,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E43","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U43-'BA Form 2 Event Data'!J43","v":0},{"$f":"IF('Data Entry'!E40<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U43<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J43,'BA Form 2 Event Data'!U43-'BA Form 2 Event Data'!J43)),(IF('BA Form 2 Event Data'!U43<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J43,'BA Form 2 Event Data'!U43-'BA Form 2 Event Data'!J43)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U43>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J43,'BA Form 2 Event Data'!U43-'BA Form 2 Event Data'!J43)),(IF('BA Form 2 Event Data'!U43>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J43,'BA Form 2 Event Data'!U43-'BA Form 2 Event Data'!J43)))))","v":0},{"$f":"'BA Form 2 Event Data'!K43","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V39) = \"v\",(Adjustments!$D39+Adjustments!$G39+Adjustments!$J39+Adjustments!$M39+Adjustments!$P39+Adjustments!$S39),0)","v":0},{"$f":"'BA Form 2 Event Data'!V43","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V39) = \"v\",(Adjustments!$E39+Adjustments!$H39+Adjustments!$K39+Adjustments!$N39+Adjustments!$Q39+Adjustments!$T39),0)","v":0},{"$f":"IF($O40=\"y\", \"\",IF(CELL(\"type\",$G40) = \"v\",(($K40-$L40+Adjustments!$Q39)-($I40-$J40+Adjustments!$P39))/(10*$G40),\"\"))","v":""},{"$f":"IF($O40=\"y\", \"\",IF(CELL(\"type\",$G40) = \"v\",(($K40-$L40)-($I40-$J40))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U43<AO$65,AO$65,IF('BA Form 2 Event Data'!U43>AP$65,AP$65,'BA Form 2 Event Data'!U43-'BA Form 2 Event Data'!J43))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U43<AO$66,AO$66,IF('BA Form 2 Event Data'!U43>AP$66,AP$66,'BA Form 2 Event Data'!U43-'BA Form 2 Event Data'!J43))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U43<AO$67,AO$67,IF('BA Form 2 Event Data'!U43>AP$67,AP$67,'BA Form 2 Event Data'!U43-'BA Form 2 Event Data'!J43))),(IF('BA Form 2 Event Data'!U43<AO$68,AO$68,IF('BA Form 2 Event Data'!U43>AP$68,AP$68,'BA Form 2 Event Data'!U43-'BA Form 2 Event Data'!J43)))))))))),\"\"))","v":""},"Y","",null,null,null,{"$f":"'BA Form 2 Event Data'!S43","v":0},{"$f":"'BA Form 2 Event Data'!AG43","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH & ID & CBA"]
[37,null,{"$f":"IF(B41=\"\",\" \",B41-LOOKUP(D41,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E44","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U44-'BA Form 2 Event Data'!J44","v":0},{"$f":"IF('Data Entry'!E41<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U44<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J44,'BA Form 2 Event Data'!U44-'BA Form 2 Event Data'!J44)),(IF('BA Form 2 Event Data'!U44<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J44,'BA Form 2 Event Data'!U44-'BA Form 2 Event Data'!J44)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U44>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J44,'BA Form 2 Event Data'!U44-'BA Form 2 Event Data'!J44)),(IF('BA Form 2 Event Data'!U44>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J44,'BA Form 2 Event Data'!U44-'BA Form 2 Event Data'!J44)))))","v":0},{"$f":"'BA Form 2 Event Data'!K44","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V40) = \"v\",(Adjustments!$D40+Adjustments!$G40+Adjustments!$J40+Adjustments!$M40+Adjustments!$P40+Adjustments!$S40),0)","v":0},{"$f":"'BA Form 2 Event Data'!V44","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V40) = \"v\",(Adjustments!$E40+Adjustments!$H40+Adjustments!$K40+Adjustments!$N40+Adjustments!$Q40+Adjustments!$T40),0)","v":0},{"$f":"IF($O41=\"y\", \"\",IF(CELL(\"type\",$G41) = \"v\",(($K41-$L41+Adjustments!$Q40)-($I41-$J41+Adjustments!$P40))/(10*$G41),\"\"))","v":""},{"$f":"IF($O41=\"y\", \"\",IF(CELL(\"type\",$G41) = \"v\",(($K41-$L41)-($I41-$J41))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U44<AO$65,AO$65,IF('BA Form 2 Event Data'!U44>AP$65,AP$65,'BA Form 2 Event Data'!U44-'BA Form 2 Event Data'!J44))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U44<AO$66,AO$66,IF('BA Form 2 Event Data'!U44>AP$66,AP$66,'BA Form 2 Event Data'!U44-'BA Form 2 Event Data'!J44))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U44<AO$67,AO$67,IF('BA Form 2 Event Data'!U44>AP$67,AP$67,'BA Form 2 Event Data'!U44-'BA Form 2 Event Data'!J44))),(IF('BA Form 2 Event Data'!U44<AO$68,AO$68,IF('BA Form 2 Event Data'!U44>AP$68,AP$68,'BA Form 2 Event Data'!U44-'BA Form 2 Event Data'!J44)))))))))),\"\"))","v":""},"Y","","Step 2","For identified events in column B, collect data and complete FRS Form 2-2018 for each event in the list.",null,{"$f":"'BA Form 2 Event Data'!S44","v":0},{"$f":"'BA Form 2 Event Data'!AG44","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH & TFR"]
[38,null,{"$f":"IF(B42=\"\",\" \",B42-LOOKUP(D42,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E45","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U45-'BA Form 2 Event Data'!J45","v":0},{"$f":"IF('Data Entry'!E42<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U45<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J45,'BA Form 2 Event Data'!U45-'BA Form 2 Event Data'!J45)),(IF('BA Form 2 Event Data'!U45<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J45,'BA Form 2 Event Data'!U45-'BA Form 2 Event Data'!J45)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U45>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J45,'BA Form 2 Event Data'!U45-'BA Form 2 Event Data'!J45)),(IF('BA Form 2 Event Data'!U45>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J45,'BA Form 2 Event Data'!U45-'BA Form 2 Event Data'!J45)))))","v":0},{"$f":"'BA Form 2 Event Data'!K45","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V41) = \"v\",(Adjustments!$D41+Adjustments!$G41+Adjustments!$J41+Adjustments!$M41+Adjustments!$P41+Adjustments!$S41),0)","v":0},{"$f":"'BA Form 2 Event Data'!V45","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V41) = \"v\",(Adjustments!$E41+Adjustments!$H41+Adjustments!$K41+Adjustments!$N41+Adjustments!$Q41+Adjustments!$T41),0)","v":0},{"$f":"IF($O42=\"y\", \"\",IF(CELL(\"type\",$G42) = \"v\",(($K42-$L42+Adjustments!$Q41)-($I42-$J42+Adjustments!$P41))/(10*$G42),\"\"))","v":""},{"$f":"IF($O42=\"y\", \"\",IF(CELL(\"type\",$G42) = \"v\",(($K42-$L42)-($I42-$J42))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U45<AO$65,AO$65,IF('BA Form 2 Event Data'!U45>AP$65,AP$65,'BA Form 2 Event Data'!U45-'BA Form 2 Event Data'!J45))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U45<AO$66,AO$66,IF('BA Form 2 Event Data'!U45>AP$66,AP$66,'BA Form 2 Event Data'!U45-'BA Form 2 Event Data'!J45))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U45<AO$67,AO$67,IF('BA Form 2 Event Data'!U45>AP$67,AP$67,'BA Form 2 Event Data'!U45-'BA Form 2 Event Data'!J45))),(IF('BA Form 2 Event Data'!U45<AO$68,AO$68,IF('BA Form 2 Event Data'!U45>AP$68,AP$68,'BA Form 2 Event Data'!U45-'BA Form 2 Event Data'!J45)))))))))),\"\"))","v":""},"Y","",null,null,null,{"$f":"'BA Form 2 Event Data'!S45","v":0},{"$f":"'BA Form 2 Event Data'!AG45","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH & CBA"]
[39,null,{"$f":"IF(B43=\"\",\" \",B43-LOOKUP(D43,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E46","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U46-'BA Form 2 Event Data'!J46","v":0},{"$f":"IF('Data Entry'!E43<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U46<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J46,'BA Form 2 Event Data'!U46-'BA Form 2 Event Data'!J46)),(IF('BA Form 2 Event Data'!U46<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J46,'BA Form 2 Event Data'!U46-'BA Form 2 Event Data'!J46)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U46>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J46,'BA Form 2 Event Data'!U46-'BA Form 2 Event Data'!J46)),(IF('BA Form 2 Event Data'!U46>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J46,'BA Form 2 Event Data'!U46-'BA Form 2 Event Data'!J46)))))","v":0},{"$f":"'BA Form 2 Event Data'!K46","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V42) = \"v\",(Adjustments!$D42+Adjustments!$G42+Adjustments!$J42+Adjustments!$M42+Adjustments!$P42+Adjustments!$S42),0)","v":0},{"$f":"'BA Form 2 Event Data'!V46","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V42) = \"v\",(Adjustments!$E42+Adjustments!$H42+Adjustments!$K42+Adjustments!$N42+Adjustments!$Q42+Adjustments!$T42),0)","v":0},{"$f":"IF($O43=\"y\", \"\",IF(CELL(\"type\",$G43) = \"v\",(($K43-$L43+Adjustments!$Q42)-($I43-$J43+Adjustments!$P42))/(10*$G43),\"\"))","v":""},{"$f":"IF($O43=\"y\", \"\",IF(CELL(\"type\",$G43) = \"v\",(($K43-$L43)-($I43-$J43))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U46<AO$65,AO$65,IF('BA Form 2 Event Data'!U46>AP$65,AP$65,'BA Form 2 Event Data'!U46-'BA Form 2 Event Data'!J46))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U46<AO$66,AO$66,IF('BA Form 2 Event Data'!U46>AP$66,AP$66,'BA Form 2 Event Data'!U46-'BA Form 2 Event Data'!J46))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U46<AO$67,AO$67,IF('BA Form 2 Event Data'!U46>AP$67,AP$67,'BA Form 2 Event Data'!U46-'BA Form 2 Event Data'!J46))),(IF('BA Form 2 Event Data'!U46<AO$68,AO$68,IF('BA Form 2 Event Data'!U46>AP$68,AP$68,'BA Form 2 Event Data'!U46-'BA Form 2 Event Data'!J46)))))))))),\"\"))","v":""},"Y","","Step 3","PasteSpecial/Values data from FRS Form 2-2018 \"Form 1 Summary Data\" into \"BA Form 2 Data\" worksheet of this workbook. Do this for each event in the list.",null,{"$f":"'BA Form 2 Event Data'!S46","v":0},{"$f":"'BA Form 2 Event Data'!AG46","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH & ID & TFR"]
[40,null,{"$f":"IF(B44=\"\",\" \",B44-LOOKUP(D44,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E47","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U47-'BA Form 2 Event Data'!J47","v":0},{"$f":"IF('Data Entry'!E44<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U47<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J47,'BA Form 2 Event Data'!U47-'BA Form 2 Event Data'!J47)),(IF('BA Form 2 Event Data'!U47<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J47,'BA Form 2 Event Data'!U47-'BA Form 2 Event Data'!J47)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U47>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J47,'BA Form 2 Event Data'!U47-'BA Form 2 Event Data'!J47)),(IF('BA Form 2 Event Data'!U47>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J47,'BA Form 2 Event Data'!U47-'BA Form 2 Event Data'!J47)))))","v":0},{"$f":"'BA Form 2 Event Data'!K47","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V43) = \"v\",(Adjustments!$D43+Adjustments!$G43+Adjustments!$J43+Adjustments!$M43+Adjustments!$P43+Adjustments!$S43),0)","v":0},{"$f":"'BA Form 2 Event Data'!V47","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V43) = \"v\",(Adjustments!$E43+Adjustments!$H43+Adjustments!$K43+Adjustments!$N43+Adjustments!$Q43+Adjustments!$T43),0)","v":0},{"$f":"IF($O44=\"y\", \"\",IF(CELL(\"type\",$G44) = \"v\",(($K44-$L44+Adjustments!$Q43)-($I44-$J44+Adjustments!$P43))/(10*$G44),\"\"))","v":""},{"$f":"IF($O44=\"y\", \"\",IF(CELL(\"type\",$G44) = \"v\",(($K44-$L44)-($I44-$J44))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U47<AO$65,AO$65,IF('BA Form 2 Event Data'!U47>AP$65,AP$65,'BA Form 2 Event Data'!U47-'BA Form 2 Event Data'!J47))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U47<AO$66,AO$66,IF('BA Form 2 Event Data'!U47>AP$66,AP$66,'BA Form 2 Event Data'!U47-'BA Form 2 Event Data'!J47))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U47<AO$67,AO$67,IF('BA Form 2 Event Data'!U47>AP$67,AP$67,'BA Form 2 Event Data'!U47-'BA Form 2 Event Data'!J47))),(IF('BA Form 2 Event Data'!U47<AO$68,AO$68,IF('BA Form 2 Event Data'!U47>AP$68,AP$68,'BA Form 2 Event Data'!U47-'BA Form 2 Event Data'!J47)))))))))),\"\"))","v":""},"Y","",null,null,null,{"$f":"'BA Form 2 Event Data'!S47","v":0},{"$f":"'BA Form 2 Event Data'!AG47","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH & ID & CBA"]
[41,null,{"$f":"IF(B45=\"\",\" \",B45-LOOKUP(D45,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E48","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U48-'BA Form 2 Event Data'!J48","v":0},{"$f":"IF('Data Entry'!E45<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U48<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J48,'BA Form 2 Event Data'!U48-'BA Form 2 Event Data'!J48)),(IF('BA Form 2 Event Data'!U48<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J48,'BA Form 2 Event Data'!U48-'BA Form 2 Event Data'!J48)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U48>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J48,'BA Form 2 Event Data'!U48-'BA Form 2 Event Data'!J48)),(IF('BA Form 2 Event Data'!U48>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J48,'BA Form 2 Event Data'!U48-'BA Form 2 Event Data'!J48)))))","v":0},{"$f":"'BA Form 2 Event Data'!K48","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V44) = \"v\",(Adjustments!$D44+Adjustments!$G44+Adjustments!$J44+Adjustments!$M44+Adjustments!$P44+Adjustments!$S44),0)","v":0},{"$f":"'BA Form 2 Event Data'!V48","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V44) = \"v\",(Adjustments!$E44+Adjustments!$H44+Adjustments!$K44+Adjustments!$N44+Adjustments!$Q44+Adjustments!$T44),0)","v":0},{"$f":"IF($O45=\"y\", \"\",IF(CELL(\"type\",$G45) = \"v\",(($K45-$L45+Adjustments!$Q44)-($I45-$J45+Adjustments!$P44))/(10*$G45),\"\"))","v":""},{"$f":"IF($O45=\"y\", \"\",IF(CELL(\"type\",$G45) = \"v\",(($K45-$L45)-($I45-$J45))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U48<AO$65,AO$65,IF('BA Form 2 Event Data'!U48>AP$65,AP$65,'BA Form 2 Event Data'!U48-'BA Form 2 Event Data'!J48))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U48<AO$66,AO$66,IF('BA Form 2 Event Data'!U48>AP$66,AP$66,'BA Form 2 Event Data'!U48-'BA Form 2 Event Data'!J48))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U48<AO$67,AO$67,IF('BA Form 2 Event Data'!U48>AP$67,AP$67,'BA Form 2 Event Data'!U48-'BA Form 2 Event Data'!J48))),(IF('BA Form 2 Event Data'!U48<AO$68,AO$68,IF('BA Form 2 Event Data'!U48>AP$68,AP$68,'BA Form 2 Event Data'!U48-'BA Form 2 Event Data'!J48)))))))))),\"\"))","v":""},"Y","","Step 4","Save this workbook using the following file name format: MyBA_FRS_Form_1-2018.xlsm and send a copy of this workbook and all FRS_Form 2-2018 workbooks to NERC. (where MyBA is replaced with your BA name)",null,{"$f":"'BA Form 2 Event Data'!S48","v":0},{"$f":"'BA Form 2 Event Data'!AG48","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH & TFR"]
[42,null,{"$f":"IF(B46=\"\",\" \",B46-LOOKUP(D46,TimeZones,'TimeZone Ref'!C$2:C$11))","v":" "},null,null,{"$f":"'BA Form 2 Event Data'!E49","v":"00:00:00"},{"$f":"'BA Form 2 Event Data'!U49-'BA Form 2 Event Data'!J49","v":0},{"$f":"IF('Data Entry'!E46<0,(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U49<'Data Entry'!AO$65,'Data Entry'!AO$65-'BA Form 2 Event Data'!J49,'BA Form 2 Event Data'!U49-'BA Form 2 Event Data'!J49)),(IF('BA Form 2 Event Data'!U49<'Data Entry'!AO$66,'Data Entry'!AO$66-'BA Form 2 Event Data'!J49,'BA Form 2 Event Data'!U49-'BA Form 2 Event Data'!J49)))),(IF('Data Entry'!Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U49>'Data Entry'!AP$65,'Data Entry'!AP$65-'BA Form 2 Event Data'!J49,'BA Form 2 Event Data'!U49-'BA Form 2 Event Data'!J49)),(IF('BA Form 2 Event Data'!U49>'Data Entry'!AP$66,'Data Entry'!AP$66-'BA Form 2 Event Data'!J49,'BA Form 2 Event Data'!U49-'BA Form 2 Event Data'!J49)))))","v":0},{"$f":"'BA Form 2 Event Data'!K49","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V45) = \"v\",(Adjustments!$D45+Adjustments!$G45+Adjustments!$J45+Adjustments!$M45+Adjustments!$P45+Adjustments!$S45),0)","v":0},{"$f":"'BA Form 2 Event Data'!V49","v":0},{"$f":"IF(CELL(\"type\",Adjustments!$V45) = \"v\",(Adjustments!$E45+Adjustments!$H45+Adjustments!$K45+Adjustments!$N45+Adjustments!$Q45+Adjustments!$T45),0)","v":0},{"$f":"IF($O46=\"y\", \"\",IF(CELL(\"type\",$G46) = \"v\",(($K46-$L46+Adjustments!$Q45)-($I46-$J46+Adjustments!$P45))/(10*$G46),\"\"))","v":""},{"$f":"IF($O46=\"y\", \"\",IF(CELL(\"type\",$G46) = \"v\",(($K46-$L46)-($I46-$J46))/(10*(IF(Q$7=\"Eastern\",(IF('BA Form 2 Event Data'!U49<AO$65,AO$65,IF('BA Form 2 Event Data'!U49>AP$65,AP$65,'BA Form 2 Event Data'!U49-'BA Form 2 Event Data'!J49))),(IF(Q$7=\"Western\",(IF('BA Form 2 Event Data'!U49<AO$66,AO$66,IF('BA Form 2 Event Data'!U49>AP$66,AP$66,'BA Form 2 Event Data'!U49-'BA Form 2 Event Data'!J49))),(IF(Q$7=\"ERCOT\",(IF('BA Form 2 Event Data'!U49<AO$67,AO$67,IF('BA Form 2 Event Data'!U49>AP$67,AP$67,'BA Form 2 Event Data'!U49-'BA Form 2 Event Data'!J49))),(IF('BA Form 2 Event Data'!U49<AO$68,AO$68,IF('BA Form 2 Event Data'!U49>AP$68,AP$68,'BA Form 2 Event Data'!U49-'BA Form 2 Event Data'!J49)))))))))),\"\"))","v":""},"Y","",null,null,null,{"$f":"'BA Form 2 Event Data'!S49","v":0},{"$f":"'BA Form 2 Event Data'!AG49","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH & CBA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q8&\"__FRS_Form_1-2018.xlsm\"","v":"AEC__FRS_Form_1-2018.xlsm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH & ID & TFR & CBA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RU & TFR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RU & CBA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RU & TFR & CBA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TFR & CBA"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Relay Limits"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eastern",59.5,60.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western",59.5,60.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ERCOT",59.3,60.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Québec",58.5,61.5]

{"sheet":"BA Form 2 Event Data","index":2,"n_rows":49,"n_cols":48,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,3,1,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average P.U. Performance",{"$f":"AVERAGE(AC8:AC49)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(AD8:AD49)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,{"$f":"AVERAGE(AJ8:AJ49)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"PasteSpecial/Values the data copied from FRS Form 2 for each event.",null,null,null,null,null,"Value A Data",null,"BA Performance",null,null,null,null,null,null,null,null,"Value B","20 to 52 second Average Period Evaluation",null,null,null,null,null,null,null,null,null,null,null,null,null,"Frequency Response Initiative - Additional Primary Frequency Response Evaluation Points"]
[null,null,null,null,null,null,null,null,null,null,null,"JOU","Non-",null,null,"Transferred","Contingent",null,null,null,null,null,"JOU","Non-",null,null,"Transferred","Contingent",null,null,null,null,null,null,"Average","Unadjusted","Unadjusted","Unadjusted","Unadjusted","Unadjusted","Adjusted","Adjusted","Adjusted","Adjusted","Adjusted"]
[null,null,null,"Date","A Point","FPointA","A Value","t(0) Time","C Value",null,"Net","Dynamic","Conforming","Pumped","Ramping","Frequency","BA","BA","BA","Bias",null,"Net","Dynamic","Conforming","Pumped","Ramping","Frequency","BA","Initial","Initial","Sustained","BA","BA","Bias","Bias While","PFR","PFR","PFR","PFR","PFR","PFR","PFR","PFR","PFR","PFR"]
[null,null,null,null,"Time","Hz","Hz",null,"Hz",null,"Actual","Schedules","Load","Hydro","Units","Response","Lost Generation","Bias","Load","Setting",null,"Actual","Schedules","Load","Hydro","Units","Response","Lost Generation","Performance","Performance","Performance","Bias","Load","Setting","Hz > +/-0.036","Performance","Performance","Performance","Performance","Performance","Performance","Performance","Performance","Performance","Performance","Maximum","Minimum","Load"]
["Event","Date/Time","B-A",null,null,null,null,null,null,"Frequency","Interchange","Imp(-) Exp (+)","Load (-)","Load (-) Gen (+)","Gen (+)","Rec (-) Del (+)","Load (-) Gen (+)","Setting",null,"EPFR","Frequency","Interchange","Imp(-) Exp (+)","Load (-)","Load (-) Gen (+)","Gen (+)","Rec (-) Del (+)","Load (-) Gen (+)","Adjusted","Unadjusted",null,"Setting",null,"EPFR","Hz","@ T(+46)","@ T(+76)","@ T(+106)","@ T(+136)","@ T(+166)","@ T(+46)","@ T(+76)","@ T(+106)","@ T(+136)","@ T(+166)","Bias Setting","Bias Setting","Dampening"]
["Number","(BA Time)","DelFreq",null,null,null,null,null,null,"Hz","MW","MW","MW","MW","MW","MW","MW","MW/0.1 Hz","MW","MW","Hz","MW","MW","MW","MW","MW","MW","MW","P.U.","P.U.","P.U.","MW/0.1 Hz","MW","MW","MW/0.1 Hz","P.U.","P.U.","P.U.","P.U.","P.U.","P.U.","P.U.","P.U.","P.U.","P.U.","MW/0.1 Hz","MW/0.1 Hz","MW/0.1 Hz"]
[1,{"$f":"'Data Entry'!C5","v":"2017-12-05T17:18:52"},{"$f":"'Data Entry'!E5","v":-3.9000000000001478E-2}]
[2,{"$f":"'Data Entry'!C6","v":"2017-12-06T18:27:12"},{"$f":"'Data Entry'!E6","v":-4.8000000000001819E-2}]
[3,{"$f":"'Data Entry'!C7","v":"2017-12-11T08:58:57"},{"$f":"'Data Entry'!E7","v":-5.1999999999999602E-2}]
[4,{"$f":"'Data Entry'!C8","v":"2018-01-03T02:59:40"},{"$f":"'Data Entry'!E8","v":-5.5999999999997385E-2}]
[5,{"$f":"'Data Entry'!C9","v":"2018-01-27T16:17:41"},{"$f":"'Data Entry'!E9","v":-4.399999999999693E-2}]
[6,{"$f":"'Data Entry'!C10","v":"2018-02-03T08:35:19"},{"$f":"'Data Entry'!E10","v":-5.1999999999999602E-2}]
[7,{"$f":"'Data Entry'!C11","v":"2018-02-16T10:14:21"},{"$f":"'Data Entry'!E11","v":-5.0000000000004263E-2}]
[8,{"$f":"'Data Entry'!C12","v":"2018-02-20T19:17:40"},{"$f":"'Data Entry'!E12","v":-3.399999999999892E-2}]
[9,{"$f":"'Data Entry'!C13","v":"2018-03-08T00:15:50"},{"$f":"'Data Entry'!E13","v":-5.700000000000216E-2}]
[10,{"$f":"'Data Entry'!C14","v":"2018-03-14T08:38:10"},{"$f":"'Data Entry'!E14","v":-4.5999999999999375E-2}]
[11,{"$f":"'Data Entry'!C15","v":"2018-03-18T12:59:10"},{"$f":"'Data Entry'!E15","v":-4.5999999999999375E-2}]
[12,{"$f":"'Data Entry'!C16","v":"2018-04-07T08:36:00"},{"$f":"'Data Entry'!E16","v":-5.5999999999997385E-2}]
[13,{"$f":"'Data Entry'!C17","v":"2018-04-12T13:26:13"},{"$f":"'Data Entry'!E17","v":-3.0999999999998806E-2}]
[14,{"$f":"'Data Entry'!C18","v":" "},{"$f":"'Data Entry'!E18","v":0}]
[15,{"$f":"'Data Entry'!C19","v":" "},{"$f":"'Data Entry'!E19","v":0}]
[16,{"$f":"'Data Entry'!C20","v":" "},{"$f":"'Data Entry'!E20","v":0}]
[17,{"$f":"'Data Entry'!C21","v":" "},{"$f":"'Data Entry'!E21","v":0}]
[18,{"$f":"'Data Entry'!C22","v":" "},{"$f":"'Data Entry'!E22","v":0}]
[19,{"$f":"'Data Entry'!C23","v":" "},{"$f":"'Data Entry'!E23","v":0}]
[20,{"$f":"'Data Entry'!C24","v":" "},{"$f":"'Data Entry'!E24","v":0}]
[21,{"$f":"'Data Entry'!C25","v":" "},{"$f":"'Data Entry'!E25","v":0}]
[22,{"$f":"'Data Entry'!C26","v":" "},{"$f":"'Data Entry'!E26","v":0}]
[23,{"$f":"'Data Entry'!C27","v":" "},{"$f":"'Data Entry'!E27","v":0}]
[24,{"$f":"'Data Entry'!C28","v":" "},{"$f":"'Data Entry'!E28","v":0}]
[25,{"$f":"'Data Entry'!C29","v":" "},{"$f":"'Data Entry'!E29","v":0}]
[26,{"$f":"'Data Entry'!C30","v":" "},{"$f":"'Data Entry'!E30","v":0}]
[27,{"$f":"'Data Entry'!C31","v":" "},{"$f":"'Data Entry'!E31","v":0}]
[28,{"$f":"'Data Entry'!C32","v":" "},{"$f":"'Data Entry'!E32","v":0}]
[29,{"$f":"'Data Entry'!C33","v":" "},{"$f":"'Data Entry'!E33","v":0}]
[30,{"$f":"'Data Entry'!C34","v":" "},{"$f":"'Data Entry'!E34","v":0}]
[31,{"$f":"'Data Entry'!C35","v":" "},{"$f":"'Data Entry'!E35","v":0}]
[32,{"$f":"'Data Entry'!C36","v":" "},{"$f":"'Data Entry'!E36","v":0}]
[33,{"$f":"'Data Entry'!C37","v":" "},{"$f":"'Data Entry'!E37","v":0}]
[34,{"$f":"'Data Entry'!C38","v":" "},{"$f":"'Data Entry'!E38","v":0}]
[35,{"$f":"'Data Entry'!C39","v":" "},{"$f":"'Data Entry'!E39","v":0}]
[36,{"$f":"'Data Entry'!C40","v":" "},{"$f":"'Data Entry'!E40","v":0}]
[37,{"$f":"'Data Entry'!C41","v":" "},{"$f":"'Data Entry'!E41","v":0}]
[38,{"$f":"'Data Entry'!C42","v":" "},{"$f":"'Data Entry'!E42","v":0}]
[39,{"$f":"'Data Entry'!C43","v":" "},{"$f":"'Data Entry'!E43","v":0}]
[40,{"$f":"'Data Entry'!C44","v":" "},{"$f":"'Data Entry'!E44","v":0}]
[41,{"$f":"'Data Entry'!C45","v":" "},{"$f":"'Data Entry'!E45","v":0}]
[42,{"$f":"'Data Entry'!C46","v":" "},{"$f":"'Data Entry'!E46","v":0}]

{"sheet":"FRO Data","index":3,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Operating Year 2017","IFROs"]
[null,null,null,null,"Eastern Interconnection",-1015,null,"EI e1",1.7999999999999999E-2]
[null,null,null,null,"Western Interconnection",-858,null,"EI e10",5.7000000000000002E-3]
[null,null,null,null,"ERCOT Interconnection",-381]
[null,null,null,null,"HQT Interconnection",-179,null,"WI e1",2.2800000000000001E-2]
[null,null,null,null,null,"MW/0.1 Hz",null,"WI e10",7.3000000000000001E-3]
[]
[]
[null,"Interconnection","Balancing Authority","FRSG","FRO DATA","Posted\nBA 2017 Operating Year FRO (MW/0.1 Hz)","Posted\nBA 2018 Operating Year FRO (MW/0.1 Hz)","Balancing Authority"," 2016 Maximum  Monthly Peak Demand (MW)"]
[1,"Eastern","AEC",null,"PowerSouth Energy Cooperative (Alabama Electric Cooperative Inc.)",-2,null,"AEC",2372]
[2,"Eastern","AECI",null,"Associated Electric Cooperative, Inc.",-6.7,null,"AECI",4655]
[3,"Eastern","CHC",null,"Cube Hydro Carolinas (Formerly Yadkin YAD)",-0.1,null,"CHC",9]
[4,"Eastern","CPLE",null,"Duke Energy Progress, Inc. (Progress Energy (Carolina Power & Light Company))",-22.2,null,"CPLE",15569]
[5,"Eastern","DUK",null,"Duke Energy Carolinas",-34.9,null,"DUK",21101]
[6,"Eastern","EEI",null,"Electric Energy, Inc.",-0.5,null,"EEI",0]
[7,"Eastern","FMPP",null,"Florida Municipal Power Pool 170",-5.6,null,"FMPP",3406]
[8,"Eastern","FPC",null,"Duke Energy Florida, Inc. (Progress Energy (Florida Power Corp.))",-15.5,null,"FPC",11622]
[9,"Eastern","FPL",null,"Florida Power & Light Co.",-40.6,null,"FPL",22852]
[10,"Eastern","GVL",null,"Gainesville Regional Utilities",-0.6,null,"GVL",425]
[11,"Eastern","HST",null,"Homestead, City of",-0.1,null,"HST",102]
[12,"Eastern","IESO",null,"Ontario IESO",-47.3,null,"IESO",22516]
[13,"Eastern","ISNE",null,"ISO-NE",-37.6,null,"ISNE",24437]
[14,"Eastern","JEA",null,"JEA",-4,null,"JEA",2863]
[15,"Eastern","LGEE",null,"LG&E and KU Services Company as agent for Louisville Gas and Electric Company and Kentucky Utilities Company",-12.3,null,"LGEE",7236]
[16,"Eastern","MAR",null,"New Brunswick Power Corporation",-5.3,null,"MAR",5391]
[17,"Eastern","MHEB",null,"Manitoba Hydro",-10.4,null,"MHEB",4746.8391121525237]
[18,"Eastern","MISO",null,"Midcontinent Independent System Operator, Inc.",-209.8,null,"MISO",117393]
[19,"Eastern","NSB",null,"New Smyrna Beach, Utilities Commission of",-0.1,null,"NSB",101]
[20,"Eastern","NSPI",null,"Nova Scotia Power Inc.",-3.4,null,"NSPI",2002]
[21,"Eastern","NYIS",null,"New York Independent System Operator",-49.2,null,"NYIS",31139]
[22,"Eastern","OVEC",null,"Ohio Valley Electric Corporation",-1.7,null,"OVEC",145]
[23,"Eastern","PJM",null,"PJM Interconnection, LLC",-257.10000000000002,null,"PJM",143633]
[24,"Eastern","SC",null,"South Carolina Public Service Authority",-7.1,null,"SC",5869]
[25,"Eastern","SCEG",null,"South Carolina Electric & Gas Company",-8.5,null,"SCEG",4970]
[26,"Eastern","SEC",null,"Seminole Electric Cooperative",-2.1,null,"SEC",291]
[27,"Eastern","SEPA",null,"Southeastern Power Administration",-0.3,null,"SEPA",0]
[28,"Eastern","SOCO",null,"Southern Company Services, Inc. - Trans",-73.900000000000006,null,"SOCO",46350]
[29,"Eastern","SPA",null,"Southwestern Power Administration",-1.2,null,"SPA",210]
[30,"Eastern","SPC",null,"Saskatchewan Power Corporation",-7.9,null,"SPC",3534]
[31,"Eastern","SWPP",null,"Southwest Power Pool",-85.7,null,"SWPP",49546]
[32,"Eastern","TAL",null,"Tallahassee, City of",-0.9,null,"TAL",600]
[33,"Eastern","TEC",null,"Tampa Electric Company",-6.9,null,"TEC",4013]
[34,"Eastern","TVA",null,"Tennessee Valley Authority",-53.5,null,"TVA",32751]
[]
[null,null,null,null,null,-1013.7999999999998,null,null,591849.83911215258]
[1,"Western","AESO","WFRSG","Alberta Electric System Operator",-79.099999999999994,null,"AESO",11536.107421875]
[2,"Western","AVA","WFRSG","Avista Corporation",-11.8,null,"AVA",2273]
[3,"Western","AZPS",null,"Arizona Public Service Company",-30.8,null,"AZPS",7275]
[4,"Western","BANC","WFRSG","Balancing Authority of Northern California (Sacramento Municipal Utility District & City of Redding Electric Utility)",-15.3,null,"BANC",4426]
[5,"Western","BCHA",null,"British Columbia Hydro and Power Authority",-64.5,null,"BCHA",10991]
[6,"Western","BPAT","WFRSG","Bonneville Power Administration",-80.7,null,"BPAT",9739]
[7,"Western","CFE",null,"Comision Federal de Electricidad",-12.9,null,"CFE",2620.5509999999999]
[8,"Western","CHPD","WFRSG","Public Utility District No. 1 of Chelan County",-3.7,null,"CHPD",437]
[9,"Western","CISO",null,"California Independent System Operator",-194.2,null,"CISO",46008]
[10,"Western","DEAA",null,"Arlington Valley, LLC - AVBA (Duke Energy Control Area Services LLC)",0,null,"DEAA",0]
[11,"Western","DOPD","WFRSG","PUD No. 1 of Douglas County",-2,null,"DOPD",386]
[12,"Western","EPE",null,"El Paso Electric Company",-6.1,null,"EPE",1877]
[13,"Western","GCPD","WFRSG","Public Utility District No. 2 of Grant County Washington",-6.5,null,"GCPD",779]
[14,"Western","GRID","WFRSG","Gridforce Energy Management, LLC (Formerly CSTO",-3.5,null,"GRID",0]
[15,"Western","GRIF",null,"Griffith Energy, LLC",-0.3,null,"GRIF",0]
[16,"Western","GRMA",null,"Gila River Power, LLC",-0.9,null,"GRMA",0]
[17,"Western","GWA","WFRSG","NaturEner Power Watch, LLC (Glacier Wind Balancing Authority)",-0.3,null,"GWA",0]
[18,"Western","HGMA",null,"New Harquahala Generating Company LLC - HGBA",-1.7,null,"HGMA",0]
[19,"Western","IID",null,"Imperial Irrigation District",-2.6,null,"IID",1060]
[20,"Western","IPCO","WFRSG","Idaho Power Company",-16.2,null,"IPCO",3657]
[21,"Western","LDWP",null,"Los Angeles Department of Water and Power",-26,null,"LDWP",6692]
[22,"Western","NEVP","WFRSG","Nevada Power Company",-33.1,null,"NEVP",9059]
[23,"Western","NWMT","WFRSG","NorthWestern Corporation (NorthWestern Energy)",-10.6,null,"NWMT",1808]
[24,"Western","PACE","WFRSG","PacifiCorp_East",-48.1,null,"PACE",8628]
[25,"Western","PACW","WFRSG","PacifiCorp_West",-19.399999999999999,null,"PACW",3700]
[26,"Western","PGE","WFRSG","Portland General Electric Company",-16.600000000000001,null,"PGE",3713]
[27,"Western","PNM",null,"Public Service Company of New Mexico",-14.4,null,"PNM",2608]
[28,"Western","PSCO",null,"Public Service Company of Colorado",-40.4,null,"PSCO",7980]
[29,"Western","PSEI","WFRSG","Puget Sound Energy, Inc.",-19.7,null,"PSEI",4574]
[30,"Western","SCL",null,"Seattle City Light",-8.3000000000000007,null,"SCL",1783]
[31,"Western","SRP",null,"Salt River Project Agricultural Improvement and Power District",-28.2,null,"SRP",6954]
[32,"Western","TEPC",null,"Tucson Electric Power",-14.5,null,"TEPC",3200]
[33,"Western","TIDC","WFRSG","Turlock Irrigation District",-2.1,null,"TIDC",619]
[34,"Western","TPWR","WFRSG","City of Tacoma, Department of Public Utilities, Light Division",-4.0999999999999996,null,"TPWR",912]
[35,"Western","WACM",null,"Western Area Power Administration - Rocky Mountain Region",-31.1,null,"WACM",4057]
[36,"Western","WALC",null,"Western Area Power Administration - Desert Southwest Region",-7.6,null,"WALC",1363]
[37,"Western","WAUW","WFRSG","Western Area Power Administration - Upper Great Plains Region",-0.6,null,"WAUW",147]
[38,"Western","WWA","WFRSG","NaturEner Wind Watch, LLC",-0.3,null,"WWA",0]
[39,"Western","WFRSG",null,"Western Frequency Response Sharing Group",-361.4,-373.70000000000005]
[null,null,null,null,null,-857.29999999999984,null,null,170861.65842187501]
[]
[null,"ERCO","ERCO",null,"Electric Reliability Council of Texas, Inc.",-381,null,"ERCO",69877]
[]
[null,"HQT","HQT",null,"Hydro-Québec TransEnergie",-179,null,"HQT",37715]

{"sheet":"Adjustments","index":4,"n_rows":54,"n_cols":22,"rows_kept":54,"cut":false,"hidden":false,"merged":[[47,2,47,19],[48,2,48,19],[60,2,60,19],[53,2,53,19],[54,2,54,19],[55,2,55,19],[56,2,56,19],[57,2,57,19],[58,2,58,19],[49,2,49,19],[50,2,50,19],[51,2,51,19],[59,2,59,19],[52,2,52,19],[1,11,2,11],[1,14,2,14],[1,17,2,17],[1,21,2,21],[45,1,45,2],[45,3,45,4],[45,6,45,7],[45,9,45,10],[45,12,45,13],[45,18,45,19],[1,5,2,5],[1,8,2,8],[1,20,2,20],[0,3,0,4],[0,6,0,7],[0,9,0,10],[0,12,0,13],[0,18,0,19]]}
[null,{"$f":"'Data Entry'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry'!$C$1","v":"AEC"},"JOU \nDynamic Schedules",null,null,"Non conforming Load",null,null,"Pumped Hydro",null,null,"Not Used",null,null,"Transferred Frequency Response",null,null,"Contingent BA Adjustment",null,null,"Net Total Adjustments"]
["Event",{"$f":"'Data Entry'!C3","v":"Date/Time (t-0)"},null,"Value A","Value B",null,"Value A","Value B",null,"Value A","Value B",null,"Value A","Value B",null,"Value A","Value B",null,"Value A","Value B",null,"Value B 20 to 52 seconds"]
["Number",{"$f":"'Data Entry'!C4","v":"BA Time"},{"$f":"'Data Entry'!$E$4","v":"DelFreq"},"Adjustment","Adjustment",null,"Adjustment","Adjustment",null,"Adjustment","Adjustment",null,"Adjustment","Adjustment",null,"Adjustment","Adjustment",null,"Adjustment","Adjustment"]
[1,{"$f":"IF(CELL(\"type\",'Data Entry'!$C5) = \"v\",'Data Entry'!$C5,\"\")","v":"2017-12-05T17:18:52"},{"$f":"IF(CELL(\"type\",'Data Entry'!$E5)=\"v\",'Data Entry'!$E5,\"\")","v":-3.9000000000001478E-2},{"$f":"'BA Form 2 Event Data'!L8","v":0},{"$f":"'BA Form 2 Event Data'!W8","v":0},null,{"$f":"'BA Form 2 Event Data'!M8","v":0},{"$f":"'BA Form 2 Event Data'!X8","v":0},null,{"$f":"'BA Form 2 Event Data'!N8","v":0},{"$f":"'BA Form 2 Event Data'!Y8","v":0},null,{"$f":"'BA Form 2 Event Data'!O8","v":0},{"$f":"'BA Form 2 Event Data'!Z8","v":0},null,{"$f":"'BA Form 2 Event Data'!P8","v":0},{"$f":"'BA Form 2 Event Data'!AA8","v":0},null,{"$f":"'BA Form 2 Event Data'!Q8","v":0},{"$f":"'BA Form 2 Event Data'!AB8","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G5) = \"v\",((E4+H4+K4+N4+Q4+T4)-(D4+G4+J4+M4+P4+S4)),\"\")","v":0}]
[2,{"$f":"IF(CELL(\"type\",'Data Entry'!$C6) = \"v\",'Data Entry'!$C6,\"\")","v":"2017-12-06T18:27:12"},{"$f":"IF(CELL(\"type\",'Data Entry'!$E6)=\"v\",'Data Entry'!$E6,\"\")","v":-4.8000000000001819E-2},{"$f":"'BA Form 2 Event Data'!L9","v":0},{"$f":"'BA Form 2 Event Data'!W9","v":0},null,{"$f":"'BA Form 2 Event Data'!M9","v":0},{"$f":"'BA Form 2 Event Data'!X9","v":0},null,{"$f":"'BA Form 2 Event Data'!N9","v":0},{"$f":"'BA Form 2 Event Data'!Y9","v":0},null,{"$f":"'BA Form 2 Event Data'!O9","v":0},{"$f":"'BA Form 2 Event Data'!Z9","v":0},null,{"$f":"'BA Form 2 Event Data'!P9","v":0},{"$f":"'BA Form 2 Event Data'!AA9","v":0},null,{"$f":"'BA Form 2 Event Data'!Q9","v":0},{"$f":"'BA Form 2 Event Data'!AB9","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G6) = \"v\",((E5+H5+K5+N5+Q5+T5)-(D5+G5+J5+M5+P5+S5)),\"\")","v":0}]
[3,{"$f":"IF(CELL(\"type\",'Data Entry'!$C7) = \"v\",'Data Entry'!$C7,\"\")","v":"2017-12-11T08:58:57"},{"$f":"IF(CELL(\"type\",'Data Entry'!$E7)=\"v\",'Data Entry'!$E7,\"\")","v":-5.1999999999999602E-2},{"$f":"'BA Form 2 Event Data'!L10","v":0},{"$f":"'BA Form 2 Event Data'!W10","v":0},null,{"$f":"'BA Form 2 Event Data'!M10","v":0},{"$f":"'BA Form 2 Event Data'!X10","v":0},null,{"$f":"'BA Form 2 Event Data'!N10","v":0},{"$f":"'BA Form 2 Event Data'!Y10","v":0},null,{"$f":"'BA Form 2 Event Data'!O10","v":0},{"$f":"'BA Form 2 Event Data'!Z10","v":0},null,{"$f":"'BA Form 2 Event Data'!P10","v":0},{"$f":"'BA Form 2 Event Data'!AA10","v":0},null,{"$f":"'BA Form 2 Event Data'!Q10","v":0},{"$f":"'BA Form 2 Event Data'!AB10","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G7) = \"v\",((E6+H6+K6+N6+Q6+T6)-(D6+G6+J6+M6+P6+S6)),\"\")","v":0}]
[4,{"$f":"IF(CELL(\"type\",'Data Entry'!$C8) = \"v\",'Data Entry'!$C8,\"\")","v":"2018-01-03T02:59:40"},{"$f":"IF(CELL(\"type\",'Data Entry'!$E8)=\"v\",'Data Entry'!$E8,\"\")","v":-5.5999999999997385E-2},{"$f":"'BA Form 2 Event Data'!L11","v":0},{"$f":"'BA Form 2 Event Data'!W11","v":0},null,{"$f":"'BA Form 2 Event Data'!M11","v":0},{"$f":"'BA Form 2 Event Data'!X11","v":0},null,{"$f":"'BA Form 2 Event Data'!N11","v":0},{"$f":"'BA Form 2 Event Data'!Y11","v":0},null,{"$f":"'BA Form 2 Event Data'!O11","v":0},{"$f":"'BA Form 2 Event Data'!Z11","v":0},null,{"$f":"'BA Form 2 Event Data'!P11","v":0},{"$f":"'BA Form 2 Event Data'!AA11","v":0},null,{"$f":"'BA Form 2 Event Data'!Q11","v":0},{"$f":"'BA Form 2 Event Data'!AB11","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G8) = \"v\",((E7+H7+K7+N7+Q7+T7)-(D7+G7+J7+M7+P7+S7)),\"\")","v":0}]
[5,{"$f":"IF(CELL(\"type\",'Data Entry'!$C9) = \"v\",'Data Entry'!$C9,\"\")","v":"2018-01-27T16:17:41"},{"$f":"IF(CELL(\"type\",'Data Entry'!$E9)=\"v\",'Data Entry'!$E9,\"\")","v":-4.399999999999693E-2},{"$f":"'BA Form 2 Event Data'!L12","v":0},{"$f":"'BA Form 2 Event Data'!W12","v":0},null,{"$f":"'BA Form 2 Event Data'!M12","v":0},{"$f":"'BA Form 2 Event Data'!X12","v":0},null,{"$f":"'BA Form 2 Event Data'!N12","v":0},{"$f":"'BA Form 2 Event Data'!Y12","v":0},null,{"$f":"'BA Form 2 Event Data'!O12","v":0},{"$f":"'BA Form 2 Event Data'!Z12","v":0},null,{"$f":"'BA Form 2 Event Data'!P12","v":0},{"$f":"'BA Form 2 Event Data'!AA12","v":0},null,{"$f":"'BA Form 2 Event Data'!Q12","v":0},{"$f":"'BA Form 2 Event Data'!AB12","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G9) = \"v\",((E8+H8+K8+N8+Q8+T8)-(D8+G8+J8+M8+P8+S8)),\"\")","v":0}]
[6,{"$f":"IF(CELL(\"type\",'Data Entry'!$C10) = \"v\",'Data Entry'!$C10,\"\")","v":"2018-02-03T08:35:19"},{"$f":"IF(CELL(\"type\",'Data Entry'!$E10)=\"v\",'Data Entry'!$E10,\"\")","v":-5.1999999999999602E-2},{"$f":"'BA Form 2 Event Data'!L13","v":0},{"$f":"'BA Form 2 Event Data'!W13","v":0},null,{"$f":"'BA Form 2 Event Data'!M13","v":0},{"$f":"'BA Form 2 Event Data'!X13","v":0},null,{"$f":"'BA Form 2 Event Data'!N13","v":0},{"$f":"'BA Form 2 Event Data'!Y13","v":0},null,{"$f":"'BA Form 2 Event Data'!O13","v":0},{"$f":"'BA Form 2 Event Data'!Z13","v":0},null,{"$f":"'BA Form 2 Event Data'!P13","v":0},{"$f":"'BA Form 2 Event Data'!AA13","v":0},null,{"$f":"'BA Form 2 Event Data'!Q13","v":0},{"$f":"'BA Form 2 Event Data'!AB13","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G10) = \"v\",((E9+H9+K9+N9+Q9+T9)-(D9+G9+J9+M9+P9+S9)),\"\")","v":0}]
[7,{"$f":"IF(CELL(\"type\",'Data Entry'!$C11) = \"v\",'Data Entry'!$C11,\"\")","v":"2018-02-16T10:14:21"},{"$f":"IF(CELL(\"type\",'Data Entry'!$E11)=\"v\",'Data Entry'!$E11,\"\")","v":-5.0000000000004263E-2},{"$f":"'BA Form 2 Event Data'!L14","v":0},{"$f":"'BA Form 2 Event Data'!W14","v":0},null,{"$f":"'BA Form 2 Event Data'!M14","v":0},{"$f":"'BA Form 2 Event Data'!X14","v":0},null,{"$f":"'BA Form 2 Event Data'!N14","v":0},{"$f":"'BA Form 2 Event Data'!Y14","v":0},null,{"$f":"'BA Form 2 Event Data'!O14","v":0},{"$f":"'BA Form 2 Event Data'!Z14","v":0},null,{"$f":"'BA Form 2 Event Data'!P14","v":0},{"$f":"'BA Form 2 Event Data'!AA14","v":0},null,{"$f":"'BA Form 2 Event Data'!Q14","v":0},{"$f":"'BA Form 2 Event Data'!AB14","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G11) = \"v\",((E10+H10+K10+N10+Q10+T10)-(D10+G10+J10+M10+P10+S10)),\"\")","v":0}]
[8,{"$f":"IF(CELL(\"type\",'Data Entry'!$C12) = \"v\",'Data Entry'!$C12,\"\")","v":"2018-02-20T19:17:40"},{"$f":"IF(CELL(\"type\",'Data Entry'!$E12)=\"v\",'Data Entry'!$E12,\"\")","v":-3.399999999999892E-2},{"$f":"'BA Form 2 Event Data'!L15","v":0},{"$f":"'BA Form 2 Event Data'!W15","v":0},null,{"$f":"'BA Form 2 Event Data'!M15","v":0},{"$f":"'BA Form 2 Event Data'!X15","v":0},null,{"$f":"'BA Form 2 Event Data'!N15","v":0},{"$f":"'BA Form 2 Event Data'!Y15","v":0},null,{"$f":"'BA Form 2 Event Data'!O15","v":0},{"$f":"'BA Form 2 Event Data'!Z15","v":0},null,{"$f":"'BA Form 2 Event Data'!P15","v":0},{"$f":"'BA Form 2 Event Data'!AA15","v":0},null,{"$f":"'BA Form 2 Event Data'!Q15","v":0},{"$f":"'BA Form 2 Event Data'!AB15","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G12) = \"v\",((E11+H11+K11+N11+Q11+T11)-(D11+G11+J11+M11+P11+S11)),\"\")","v":0}]
[9,{"$f":"IF(CELL(\"type\",'Data Entry'!$C13) = \"v\",'Data Entry'!$C13,\"\")","v":"2018-03-08T00:15:50"},{"$f":"IF(CELL(\"type\",'Data Entry'!$E13)=\"v\",'Data Entry'!$E13,\"\")","v":-5.700000000000216E-2},{"$f":"'BA Form 2 Event Data'!L16","v":0},{"$f":"'BA Form 2 Event Data'!W16","v":0},null,{"$f":"'BA Form 2 Event Data'!M16","v":0},{"$f":"'BA Form 2 Event Data'!X16","v":0},null,{"$f":"'BA Form 2 Event Data'!N16","v":0},{"$f":"'BA Form 2 Event Data'!Y16","v":0},null,{"$f":"'BA Form 2 Event Data'!O16","v":0},{"$f":"'BA Form 2 Event Data'!Z16","v":0},null,{"$f":"'BA Form 2 Event Data'!P16","v":0},{"$f":"'BA Form 2 Event Data'!AA16","v":0},null,{"$f":"'BA Form 2 Event Data'!Q16","v":0},{"$f":"'BA Form 2 Event Data'!AB16","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G13) = \"v\",((E12+H12+K12+N12+Q12+T12)-(D12+G12+J12+M12+P12+S12)),\"\")","v":0}]
[10,{"$f":"IF(CELL(\"type\",'Data Entry'!$C14) = \"v\",'Data Entry'!$C14,\"\")","v":"2018-03-14T08:38:10"},{"$f":"IF(CELL(\"type\",'Data Entry'!$E14)=\"v\",'Data Entry'!$E14,\"\")","v":-4.5999999999999375E-2},{"$f":"'BA Form 2 Event Data'!L17","v":0},{"$f":"'BA Form 2 Event Data'!W17","v":0},null,{"$f":"'BA Form 2 Event Data'!M17","v":0},{"$f":"'BA Form 2 Event Data'!X17","v":0},null,{"$f":"'BA Form 2 Event Data'!N17","v":0},{"$f":"'BA Form 2 Event Data'!Y17","v":0},null,{"$f":"'BA Form 2 Event Data'!O17","v":0},{"$f":"'BA Form 2 Event Data'!Z17","v":0},null,{"$f":"'BA Form 2 Event Data'!P17","v":0},{"$f":"'BA Form 2 Event Data'!AA17","v":0},null,{"$f":"'BA Form 2 Event Data'!Q17","v":0},{"$f":"'BA Form 2 Event Data'!AB17","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G14) = \"v\",((E13+H13+K13+N13+Q13+T13)-(D13+G13+J13+M13+P13+S13)),\"\")","v":0}]
[11,{"$f":"IF(CELL(\"type\",'Data Entry'!$C15) = \"v\",'Data Entry'!$C15,\"\")","v":"2018-03-18T12:59:10"},{"$f":"IF(CELL(\"type\",'Data Entry'!$E15)=\"v\",'Data Entry'!$E15,\"\")","v":-4.5999999999999375E-2},{"$f":"'BA Form 2 Event Data'!L18","v":0},{"$f":"'BA Form 2 Event Data'!W18","v":0},null,{"$f":"'BA Form 2 Event Data'!M18","v":0},{"$f":"'BA Form 2 Event Data'!X18","v":0},null,{"$f":"'BA Form 2 Event Data'!N18","v":0},{"$f":"'BA Form 2 Event Data'!Y18","v":0},null,{"$f":"'BA Form 2 Event Data'!O18","v":0},{"$f":"'BA Form 2 Event Data'!Z18","v":0},null,{"$f":"'BA Form 2 Event Data'!P18","v":0},{"$f":"'BA Form 2 Event Data'!AA18","v":0},null,{"$f":"'BA Form 2 Event Data'!Q18","v":0},{"$f":"'BA Form 2 Event Data'!AB18","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G15) = \"v\",((E14+H14+K14+N14+Q14+T14)-(D14+G14+J14+M14+P14+S14)),\"\")","v":0}]
[12,{"$f":"IF(CELL(\"type\",'Data Entry'!$C16) = \"v\",'Data Entry'!$C16,\"\")","v":"2018-04-07T08:36:00"},{"$f":"IF(CELL(\"type\",'Data Entry'!$E16)=\"v\",'Data Entry'!$E16,\"\")","v":-5.5999999999997385E-2},{"$f":"'BA Form 2 Event Data'!L19","v":0},{"$f":"'BA Form 2 Event Data'!W19","v":0},null,{"$f":"'BA Form 2 Event Data'!M19","v":0},{"$f":"'BA Form 2 Event Data'!X19","v":0},null,{"$f":"'BA Form 2 Event Data'!N19","v":0},{"$f":"'BA Form 2 Event Data'!Y19","v":0},null,{"$f":"'BA Form 2 Event Data'!O19","v":0},{"$f":"'BA Form 2 Event Data'!Z19","v":0},null,{"$f":"'BA Form 2 Event Data'!P19","v":0},{"$f":"'BA Form 2 Event Data'!AA19","v":0},null,{"$f":"'BA Form 2 Event Data'!Q19","v":0},{"$f":"'BA Form 2 Event Data'!AB19","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G16) = \"v\",((E15+H15+K15+N15+Q15+T15)-(D15+G15+J15+M15+P15+S15)),\"\")","v":0}]
[13,{"$f":"IF(CELL(\"type\",'Data Entry'!$C17) = \"v\",'Data Entry'!$C17,\"\")","v":"2018-04-12T13:26:13"},{"$f":"IF(CELL(\"type\",'Data Entry'!$E17)=\"v\",'Data Entry'!$E17,\"\")","v":-3.0999999999998806E-2},{"$f":"'BA Form 2 Event Data'!L20","v":0},{"$f":"'BA Form 2 Event Data'!W20","v":0},null,{"$f":"'BA Form 2 Event Data'!M20","v":0},{"$f":"'BA Form 2 Event Data'!X20","v":0},null,{"$f":"'BA Form 2 Event Data'!N20","v":0},{"$f":"'BA Form 2 Event Data'!Y20","v":0},null,{"$f":"'BA Form 2 Event Data'!O20","v":0},{"$f":"'BA Form 2 Event Data'!Z20","v":0},null,{"$f":"'BA Form 2 Event Data'!P20","v":0},{"$f":"'BA Form 2 Event Data'!AA20","v":0},null,{"$f":"'BA Form 2 Event Data'!Q20","v":0},{"$f":"'BA Form 2 Event Data'!AB20","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G17) = \"v\",((E16+H16+K16+N16+Q16+T16)-(D16+G16+J16+M16+P16+S16)),\"\")","v":0}]
[14,{"$f":"IF(CELL(\"type\",'Data Entry'!$C18) = \"v\",'Data Entry'!$C18,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E18)=\"v\",'Data Entry'!$E18,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L21","v":0},{"$f":"'BA Form 2 Event Data'!W21","v":0},null,{"$f":"'BA Form 2 Event Data'!M21","v":0},{"$f":"'BA Form 2 Event Data'!X21","v":0},null,{"$f":"'BA Form 2 Event Data'!N21","v":0},{"$f":"'BA Form 2 Event Data'!Y21","v":0},null,{"$f":"'BA Form 2 Event Data'!O21","v":0},{"$f":"'BA Form 2 Event Data'!Z21","v":0},null,{"$f":"'BA Form 2 Event Data'!P21","v":0},{"$f":"'BA Form 2 Event Data'!AA21","v":0},null,{"$f":"'BA Form 2 Event Data'!Q21","v":0},{"$f":"'BA Form 2 Event Data'!AB21","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G18) = \"v\",((E17+H17+K17+N17+Q17+T17)-(D17+G17+J17+M17+P17+S17)),\"\")","v":0}]
[15,{"$f":"IF(CELL(\"type\",'Data Entry'!$C19) = \"v\",'Data Entry'!$C19,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E19)=\"v\",'Data Entry'!$E19,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L22","v":0},{"$f":"'BA Form 2 Event Data'!W22","v":0},null,{"$f":"'BA Form 2 Event Data'!M22","v":0},{"$f":"'BA Form 2 Event Data'!X22","v":0},null,{"$f":"'BA Form 2 Event Data'!N22","v":0},{"$f":"'BA Form 2 Event Data'!Y22","v":0},null,{"$f":"'BA Form 2 Event Data'!O22","v":0},{"$f":"'BA Form 2 Event Data'!Z22","v":0},null,{"$f":"'BA Form 2 Event Data'!P22","v":0},{"$f":"'BA Form 2 Event Data'!AA22","v":0},null,{"$f":"'BA Form 2 Event Data'!Q22","v":0},{"$f":"'BA Form 2 Event Data'!AB22","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G19) = \"v\",((E18+H18+K18+N18+Q18+T18)-(D18+G18+J18+M18+P18+S18)),\"\")","v":0}]
[16,{"$f":"IF(CELL(\"type\",'Data Entry'!$C20) = \"v\",'Data Entry'!$C20,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E20)=\"v\",'Data Entry'!$E20,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L23","v":0},{"$f":"'BA Form 2 Event Data'!W23","v":0},null,{"$f":"'BA Form 2 Event Data'!M23","v":0},{"$f":"'BA Form 2 Event Data'!X23","v":0},null,{"$f":"'BA Form 2 Event Data'!N23","v":0},{"$f":"'BA Form 2 Event Data'!Y23","v":0},null,{"$f":"'BA Form 2 Event Data'!O23","v":0},{"$f":"'BA Form 2 Event Data'!Z23","v":0},null,{"$f":"'BA Form 2 Event Data'!P23","v":0},{"$f":"'BA Form 2 Event Data'!AA23","v":0},null,{"$f":"'BA Form 2 Event Data'!Q23","v":0},{"$f":"'BA Form 2 Event Data'!AB23","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G20) = \"v\",((E19+H19+K19+N19+Q19+T19)-(D19+G19+J19+M19+P19+S19)),\"\")","v":0}]
[17,{"$f":"IF(CELL(\"type\",'Data Entry'!$C21) = \"v\",'Data Entry'!$C21,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E21)=\"v\",'Data Entry'!$E21,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L24","v":0},{"$f":"'BA Form 2 Event Data'!W24","v":0},null,{"$f":"'BA Form 2 Event Data'!M24","v":0},{"$f":"'BA Form 2 Event Data'!X24","v":0},null,{"$f":"'BA Form 2 Event Data'!N24","v":0},{"$f":"'BA Form 2 Event Data'!Y24","v":0},null,{"$f":"'BA Form 2 Event Data'!O24","v":0},{"$f":"'BA Form 2 Event Data'!Z24","v":0},null,{"$f":"'BA Form 2 Event Data'!P24","v":0},{"$f":"'BA Form 2 Event Data'!AA24","v":0},null,{"$f":"'BA Form 2 Event Data'!Q24","v":0},{"$f":"'BA Form 2 Event Data'!AB24","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G21) = \"v\",((E20+H20+K20+N20+Q20+T20)-(D20+G20+J20+M20+P20+S20)),\"\")","v":0}]
[18,{"$f":"IF(CELL(\"type\",'Data Entry'!$C22) = \"v\",'Data Entry'!$C22,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E22)=\"v\",'Data Entry'!$E22,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L25","v":0},{"$f":"'BA Form 2 Event Data'!W25","v":0},null,{"$f":"'BA Form 2 Event Data'!M25","v":0},{"$f":"'BA Form 2 Event Data'!X25","v":0},null,{"$f":"'BA Form 2 Event Data'!N25","v":0},{"$f":"'BA Form 2 Event Data'!Y25","v":0},null,{"$f":"'BA Form 2 Event Data'!O25","v":0},{"$f":"'BA Form 2 Event Data'!Z25","v":0},null,{"$f":"'BA Form 2 Event Data'!P25","v":0},{"$f":"'BA Form 2 Event Data'!AA25","v":0},null,{"$f":"'BA Form 2 Event Data'!Q25","v":0},{"$f":"'BA Form 2 Event Data'!AB25","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G22) = \"v\",((E21+H21+K21+N21+Q21+T21)-(D21+G21+J21+M21+P21+S21)),\"\")","v":0}]
[19,{"$f":"IF(CELL(\"type\",'Data Entry'!$C23) = \"v\",'Data Entry'!$C23,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E23)=\"v\",'Data Entry'!$E23,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L26","v":0},{"$f":"'BA Form 2 Event Data'!W26","v":0},null,{"$f":"'BA Form 2 Event Data'!M26","v":0},{"$f":"'BA Form 2 Event Data'!X26","v":0},null,{"$f":"'BA Form 2 Event Data'!N26","v":0},{"$f":"'BA Form 2 Event Data'!Y26","v":0},null,{"$f":"'BA Form 2 Event Data'!O26","v":0},{"$f":"'BA Form 2 Event Data'!Z26","v":0},null,{"$f":"'BA Form 2 Event Data'!P26","v":0},{"$f":"'BA Form 2 Event Data'!AA26","v":0},null,{"$f":"'BA Form 2 Event Data'!Q26","v":0},{"$f":"'BA Form 2 Event Data'!AB26","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G23) = \"v\",((E22+H22+K22+N22+Q22+T22)-(D22+G22+J22+M22+P22+S22)),\"\")","v":0}]
[20,{"$f":"IF(CELL(\"type\",'Data Entry'!$C24) = \"v\",'Data Entry'!$C24,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E24)=\"v\",'Data Entry'!$E24,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L27","v":0},{"$f":"'BA Form 2 Event Data'!W27","v":0},null,{"$f":"'BA Form 2 Event Data'!M27","v":0},{"$f":"'BA Form 2 Event Data'!X27","v":0},null,{"$f":"'BA Form 2 Event Data'!N27","v":0},{"$f":"'BA Form 2 Event Data'!Y27","v":0},null,{"$f":"'BA Form 2 Event Data'!O27","v":0},{"$f":"'BA Form 2 Event Data'!Z27","v":0},null,{"$f":"'BA Form 2 Event Data'!P27","v":0},{"$f":"'BA Form 2 Event Data'!AA27","v":0},null,{"$f":"'BA Form 2 Event Data'!Q27","v":0},{"$f":"'BA Form 2 Event Data'!AB27","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G24) = \"v\",((E23+H23+K23+N23+Q23+T23)-(D23+G23+J23+M23+P23+S23)),\"\")","v":0}]
[21,{"$f":"IF(CELL(\"type\",'Data Entry'!$C25) = \"v\",'Data Entry'!$C25,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E25)=\"v\",'Data Entry'!$E25,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L28","v":0},{"$f":"'BA Form 2 Event Data'!W28","v":0},null,{"$f":"'BA Form 2 Event Data'!M28","v":0},{"$f":"'BA Form 2 Event Data'!X28","v":0},null,{"$f":"'BA Form 2 Event Data'!N28","v":0},{"$f":"'BA Form 2 Event Data'!Y28","v":0},null,{"$f":"'BA Form 2 Event Data'!O28","v":0},{"$f":"'BA Form 2 Event Data'!Z28","v":0},null,{"$f":"'BA Form 2 Event Data'!P28","v":0},{"$f":"'BA Form 2 Event Data'!AA28","v":0},null,{"$f":"'BA Form 2 Event Data'!Q28","v":0},{"$f":"'BA Form 2 Event Data'!AB28","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G25) = \"v\",((E24+H24+K24+N24+Q24+T24)-(D24+G24+J24+M24+P24+S24)),\"\")","v":0}]
[22,{"$f":"IF(CELL(\"type\",'Data Entry'!$C26) = \"v\",'Data Entry'!$C26,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E26)=\"v\",'Data Entry'!$E26,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L29","v":0},{"$f":"'BA Form 2 Event Data'!W29","v":0},null,{"$f":"'BA Form 2 Event Data'!M29","v":0},{"$f":"'BA Form 2 Event Data'!X29","v":0},null,{"$f":"'BA Form 2 Event Data'!N29","v":0},{"$f":"'BA Form 2 Event Data'!Y29","v":0},null,{"$f":"'BA Form 2 Event Data'!O29","v":0},{"$f":"'BA Form 2 Event Data'!Z29","v":0},null,{"$f":"'BA Form 2 Event Data'!P29","v":0},{"$f":"'BA Form 2 Event Data'!AA29","v":0},null,{"$f":"'BA Form 2 Event Data'!Q29","v":0},{"$f":"'BA Form 2 Event Data'!AB29","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G26) = \"v\",((E25+H25+K25+N25+Q25+T25)-(D25+G25+J25+M25+P25+S25)),\"\")","v":0}]
[23,{"$f":"IF(CELL(\"type\",'Data Entry'!$C27) = \"v\",'Data Entry'!$C27,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E27)=\"v\",'Data Entry'!$E27,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L30","v":0},{"$f":"'BA Form 2 Event Data'!W30","v":0},null,{"$f":"'BA Form 2 Event Data'!M30","v":0},{"$f":"'BA Form 2 Event Data'!X30","v":0},null,{"$f":"'BA Form 2 Event Data'!N30","v":0},{"$f":"'BA Form 2 Event Data'!Y30","v":0},null,{"$f":"'BA Form 2 Event Data'!O30","v":0},{"$f":"'BA Form 2 Event Data'!Z30","v":0},null,{"$f":"'BA Form 2 Event Data'!P30","v":0},{"$f":"'BA Form 2 Event Data'!AA30","v":0},null,{"$f":"'BA Form 2 Event Data'!Q30","v":0},{"$f":"'BA Form 2 Event Data'!AB30","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G27) = \"v\",((E26+H26+K26+N26+Q26+T26)-(D26+G26+J26+M26+P26+S26)),\"\")","v":0}]
[24,{"$f":"IF(CELL(\"type\",'Data Entry'!$C28) = \"v\",'Data Entry'!$C28,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E28)=\"v\",'Data Entry'!$E28,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L31","v":0},{"$f":"'BA Form 2 Event Data'!W31","v":0},null,{"$f":"'BA Form 2 Event Data'!M31","v":0},{"$f":"'BA Form 2 Event Data'!X31","v":0},null,{"$f":"'BA Form 2 Event Data'!N31","v":0},{"$f":"'BA Form 2 Event Data'!Y31","v":0},null,{"$f":"'BA Form 2 Event Data'!O31","v":0},{"$f":"'BA Form 2 Event Data'!Z31","v":0},null,{"$f":"'BA Form 2 Event Data'!P31","v":0},{"$f":"'BA Form 2 Event Data'!AA31","v":0},null,{"$f":"'BA Form 2 Event Data'!Q31","v":0},{"$f":"'BA Form 2 Event Data'!AB31","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G28) = \"v\",((E27+H27+K27+N27+Q27+T27)-(D27+G27+J27+M27+P27+S27)),\"\")","v":0}]
[25,{"$f":"IF(CELL(\"type\",'Data Entry'!$C29) = \"v\",'Data Entry'!$C29,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E29)=\"v\",'Data Entry'!$E29,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L32","v":0},{"$f":"'BA Form 2 Event Data'!W32","v":0},null,{"$f":"'BA Form 2 Event Data'!M32","v":0},{"$f":"'BA Form 2 Event Data'!X32","v":0},null,{"$f":"'BA Form 2 Event Data'!N32","v":0},{"$f":"'BA Form 2 Event Data'!Y32","v":0},null,{"$f":"'BA Form 2 Event Data'!O32","v":0},{"$f":"'BA Form 2 Event Data'!Z32","v":0},null,{"$f":"'BA Form 2 Event Data'!P32","v":0},{"$f":"'BA Form 2 Event Data'!AA32","v":0},null,{"$f":"'BA Form 2 Event Data'!Q32","v":0},{"$f":"'BA Form 2 Event Data'!AB32","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G29) = \"v\",((E28+H28+K28+N28-Q28*10*'Data Entry'!$G29+T28)-(D28+G28+J28+M28+S28)),\"\")","v":0}]
[26,{"$f":"IF(CELL(\"type\",'Data Entry'!$C30) = \"v\",'Data Entry'!$C30,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E30)=\"v\",'Data Entry'!$E30,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L33","v":0},{"$f":"'BA Form 2 Event Data'!W33","v":0},null,{"$f":"'BA Form 2 Event Data'!M33","v":0},{"$f":"'BA Form 2 Event Data'!X33","v":0},null,{"$f":"'BA Form 2 Event Data'!N33","v":0},{"$f":"'BA Form 2 Event Data'!Y33","v":0},null,{"$f":"'BA Form 2 Event Data'!O33","v":0},{"$f":"'BA Form 2 Event Data'!Z33","v":0},null,{"$f":"'BA Form 2 Event Data'!P33","v":0},{"$f":"'BA Form 2 Event Data'!AA33","v":0},null,{"$f":"'BA Form 2 Event Data'!Q33","v":0},{"$f":"'BA Form 2 Event Data'!AB33","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G30) = \"v\",((E29+H29+K29+N29-Q29*10*'Data Entry'!$G30+T29)-(D29+G29+J29+M29+S29)),\"\")","v":0}]
[27,{"$f":"IF(CELL(\"type\",'Data Entry'!$C31) = \"v\",'Data Entry'!$C31,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E31)=\"v\",'Data Entry'!$E31,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L34","v":0},{"$f":"'BA Form 2 Event Data'!W34","v":0},null,{"$f":"'BA Form 2 Event Data'!M34","v":0},{"$f":"'BA Form 2 Event Data'!X34","v":0},null,{"$f":"'BA Form 2 Event Data'!N34","v":0},{"$f":"'BA Form 2 Event Data'!Y34","v":0},null,{"$f":"'BA Form 2 Event Data'!O34","v":0},{"$f":"'BA Form 2 Event Data'!Z34","v":0},null,{"$f":"'BA Form 2 Event Data'!P34","v":0},{"$f":"'BA Form 2 Event Data'!AA34","v":0},null,{"$f":"'BA Form 2 Event Data'!Q34","v":0},{"$f":"'BA Form 2 Event Data'!AB34","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G31) = \"v\",((E30+H30+K30+N30-Q30*10*'Data Entry'!$G31+T30)-(D30+G30+J30+M30+S30)),\"\")","v":0}]
[28,{"$f":"IF(CELL(\"type\",'Data Entry'!$C32) = \"v\",'Data Entry'!$C32,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E32)=\"v\",'Data Entry'!$E32,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L35","v":0},{"$f":"'BA Form 2 Event Data'!W35","v":0},null,{"$f":"'BA Form 2 Event Data'!M35","v":0},{"$f":"'BA Form 2 Event Data'!X35","v":0},null,{"$f":"'BA Form 2 Event Data'!N35","v":0},{"$f":"'BA Form 2 Event Data'!Y35","v":0},null,{"$f":"'BA Form 2 Event Data'!O35","v":0},{"$f":"'BA Form 2 Event Data'!Z35","v":0},null,{"$f":"'BA Form 2 Event Data'!P35","v":0},{"$f":"'BA Form 2 Event Data'!AA35","v":0},null,{"$f":"'BA Form 2 Event Data'!Q35","v":0},{"$f":"'BA Form 2 Event Data'!AB35","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G32) = \"v\",((E31+H31+K31+N31-Q31*10*'Data Entry'!$G32+T31)-(D31+G31+J31+M31+S31)),\"\")","v":0}]
[29,{"$f":"IF(CELL(\"type\",'Data Entry'!$C33) = \"v\",'Data Entry'!$C33,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E33)=\"v\",'Data Entry'!$E33,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L36","v":0},{"$f":"'BA Form 2 Event Data'!W36","v":0},null,{"$f":"'BA Form 2 Event Data'!M36","v":0},{"$f":"'BA Form 2 Event Data'!X36","v":0},null,{"$f":"'BA Form 2 Event Data'!N36","v":0},{"$f":"'BA Form 2 Event Data'!Y36","v":0},null,{"$f":"'BA Form 2 Event Data'!O36","v":0},{"$f":"'BA Form 2 Event Data'!Z36","v":0},null,{"$f":"'BA Form 2 Event Data'!P36","v":0},{"$f":"'BA Form 2 Event Data'!AA36","v":0},null,{"$f":"'BA Form 2 Event Data'!Q36","v":0},{"$f":"'BA Form 2 Event Data'!AB36","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G33) = \"v\",((E32+H32+K32+N32-Q32*10*'Data Entry'!$G33+T32)-(D32+G32+J32+M32+S32)),\"\")","v":0}]
[30,{"$f":"IF(CELL(\"type\",'Data Entry'!$C34) = \"v\",'Data Entry'!$C34,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E34)=\"v\",'Data Entry'!$E34,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L37","v":0},{"$f":"'BA Form 2 Event Data'!W37","v":0},null,{"$f":"'BA Form 2 Event Data'!M37","v":0},{"$f":"'BA Form 2 Event Data'!X37","v":0},null,{"$f":"'BA Form 2 Event Data'!N37","v":0},{"$f":"'BA Form 2 Event Data'!Y37","v":0},null,{"$f":"'BA Form 2 Event Data'!O37","v":0},{"$f":"'BA Form 2 Event Data'!Z37","v":0},null,{"$f":"'BA Form 2 Event Data'!P37","v":0},{"$f":"'BA Form 2 Event Data'!AA37","v":0},null,{"$f":"'BA Form 2 Event Data'!Q37","v":0},{"$f":"'BA Form 2 Event Data'!AB37","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G34) = \"v\",((E33+H33+K33+N33-Q33*10*'Data Entry'!$G34+T33)-(D33+G33+J33+M33+S33)),\"\")","v":0}]
[31,{"$f":"IF(CELL(\"type\",'Data Entry'!$C35) = \"v\",'Data Entry'!$C35,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E35)=\"v\",'Data Entry'!$E35,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L38","v":0},{"$f":"'BA Form 2 Event Data'!W38","v":0},null,{"$f":"'BA Form 2 Event Data'!M38","v":0},{"$f":"'BA Form 2 Event Data'!X38","v":0},null,{"$f":"'BA Form 2 Event Data'!N38","v":0},{"$f":"'BA Form 2 Event Data'!Y38","v":0},null,{"$f":"'BA Form 2 Event Data'!O38","v":0},{"$f":"'BA Form 2 Event Data'!Z38","v":0},null,{"$f":"'BA Form 2 Event Data'!P38","v":0},{"$f":"'BA Form 2 Event Data'!AA38","v":0},null,{"$f":"'BA Form 2 Event Data'!Q38","v":0},{"$f":"'BA Form 2 Event Data'!AB38","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G35) = \"v\",((E34+H34+K34+N34-Q34*10*'Data Entry'!$G35+T34)-(D34+G34+J34+M34+S34)),\"\")","v":0}]
[32,{"$f":"IF(CELL(\"type\",'Data Entry'!$C36) = \"v\",'Data Entry'!$C36,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E36)=\"v\",'Data Entry'!$E36,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L39","v":0},{"$f":"'BA Form 2 Event Data'!W39","v":0},null,{"$f":"'BA Form 2 Event Data'!M39","v":0},{"$f":"'BA Form 2 Event Data'!X39","v":0},null,{"$f":"'BA Form 2 Event Data'!N39","v":0},{"$f":"'BA Form 2 Event Data'!Y39","v":0},null,{"$f":"'BA Form 2 Event Data'!O39","v":0},{"$f":"'BA Form 2 Event Data'!Z39","v":0},null,{"$f":"'BA Form 2 Event Data'!P39","v":0},{"$f":"'BA Form 2 Event Data'!AA39","v":0},null,{"$f":"'BA Form 2 Event Data'!Q39","v":0},{"$f":"'BA Form 2 Event Data'!AB39","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G36) = \"v\",((E35+H35+K35+N35-Q35*10*'Data Entry'!$G36+T35)-(D35+G35+J35+M35+S35)),\"\")","v":0}]
[33,{"$f":"IF(CELL(\"type\",'Data Entry'!$C37) = \"v\",'Data Entry'!$C37,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E37)=\"v\",'Data Entry'!$E37,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L40","v":0},{"$f":"'BA Form 2 Event Data'!W40","v":0},null,{"$f":"'BA Form 2 Event Data'!M40","v":0},{"$f":"'BA Form 2 Event Data'!X40","v":0},null,{"$f":"'BA Form 2 Event Data'!N40","v":0},{"$f":"'BA Form 2 Event Data'!Y40","v":0},null,{"$f":"'BA Form 2 Event Data'!O40","v":0},{"$f":"'BA Form 2 Event Data'!Z40","v":0},null,{"$f":"'BA Form 2 Event Data'!P40","v":0},{"$f":"'BA Form 2 Event Data'!AA40","v":0},null,{"$f":"'BA Form 2 Event Data'!Q40","v":0},{"$f":"'BA Form 2 Event Data'!AB40","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G37) = \"v\",((E36+H36+K36+N36-Q36*10*'Data Entry'!$G37+T36)-(D36+G36+J36+M36+S36)),\"\")","v":0}]
[34,{"$f":"IF(CELL(\"type\",'Data Entry'!$C38) = \"v\",'Data Entry'!$C38,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E38)=\"v\",'Data Entry'!$E38,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L41","v":0},{"$f":"'BA Form 2 Event Data'!W41","v":0},null,{"$f":"'BA Form 2 Event Data'!M41","v":0},{"$f":"'BA Form 2 Event Data'!X41","v":0},null,{"$f":"'BA Form 2 Event Data'!N41","v":0},{"$f":"'BA Form 2 Event Data'!Y41","v":0},null,{"$f":"'BA Form 2 Event Data'!O41","v":0},{"$f":"'BA Form 2 Event Data'!Z41","v":0},null,{"$f":"'BA Form 2 Event Data'!P41","v":0},{"$f":"'BA Form 2 Event Data'!AA41","v":0},null,{"$f":"'BA Form 2 Event Data'!Q41","v":0},{"$f":"'BA Form 2 Event Data'!AB41","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G38) = \"v\",((E37+H37+K37+N37-Q37*10*'Data Entry'!$G38+T37)-(D37+G37+J37+M37+S37)),\"\")","v":0}]
[35,{"$f":"IF(CELL(\"type\",'Data Entry'!$C39) = \"v\",'Data Entry'!$C39,\"\")","v":""},null,{"$f":"'BA Form 2 Event Data'!L42","v":0},{"$f":"'BA Form 2 Event Data'!W42","v":0},null,{"$f":"'BA Form 2 Event Data'!M42","v":0},{"$f":"'BA Form 2 Event Data'!X42","v":0},null,{"$f":"'BA Form 2 Event Data'!N42","v":0},{"$f":"'BA Form 2 Event Data'!Y42","v":0},null,{"$f":"'BA Form 2 Event Data'!O42","v":0},{"$f":"'BA Form 2 Event Data'!Z42","v":0},null,{"$f":"'BA Form 2 Event Data'!P42","v":0},{"$f":"'BA Form 2 Event Data'!AA42","v":0},null,{"$f":"'BA Form 2 Event Data'!Q42","v":0},{"$f":"'BA Form 2 Event Data'!AB42","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G39) = \"v\",((E38+H38+K38+N38-Q38*10*'Data Entry'!$G39+T38)-(D38+G38+J38+M38+S38)),\"\")","v":0}]
[36,{"$f":"IF(CELL(\"type\",'Data Entry'!$C40) = \"v\",'Data Entry'!$C40,\"\")","v":""},null,{"$f":"'BA Form 2 Event Data'!L43","v":0},{"$f":"'BA Form 2 Event Data'!W43","v":0},null,{"$f":"'BA Form 2 Event Data'!M43","v":0},{"$f":"'BA Form 2 Event Data'!X43","v":0},null,{"$f":"'BA Form 2 Event Data'!N43","v":0},{"$f":"'BA Form 2 Event Data'!Y43","v":0},null,{"$f":"'BA Form 2 Event Data'!O43","v":0},{"$f":"'BA Form 2 Event Data'!Z43","v":0},null,{"$f":"'BA Form 2 Event Data'!P43","v":0},{"$f":"'BA Form 2 Event Data'!AA43","v":0},null,{"$f":"'BA Form 2 Event Data'!Q43","v":0},{"$f":"'BA Form 2 Event Data'!AB43","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G40) = \"v\",((E39+H39+K39+N39-Q39*10*'Data Entry'!$G40+T39)-(D39+G39+J39+M39+S39)),\"\")","v":0}]
[37,{"$f":"IF(CELL(\"type\",'Data Entry'!$C41) = \"v\",'Data Entry'!$C41,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E41)=\"v\",'Data Entry'!$E41,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L44","v":0},{"$f":"'BA Form 2 Event Data'!W44","v":0},null,{"$f":"'BA Form 2 Event Data'!M44","v":0},{"$f":"'BA Form 2 Event Data'!X44","v":0},null,{"$f":"'BA Form 2 Event Data'!N44","v":0},{"$f":"'BA Form 2 Event Data'!Y44","v":0},null,{"$f":"'BA Form 2 Event Data'!O44","v":0},{"$f":"'BA Form 2 Event Data'!Z44","v":0},null,{"$f":"'BA Form 2 Event Data'!P44","v":0},{"$f":"'BA Form 2 Event Data'!AA44","v":0},null,{"$f":"'BA Form 2 Event Data'!Q44","v":0},{"$f":"'BA Form 2 Event Data'!AB44","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G41) = \"v\",((E40+H40+K40+N40-Q40*10*'Data Entry'!$G41+T40)-(D40+G40+J40+M40+S40)),\"\")","v":0}]
[38,{"$f":"IF(CELL(\"type\",'Data Entry'!$C42) = \"v\",'Data Entry'!$C42,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E42)=\"v\",'Data Entry'!$E42,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L45","v":0},{"$f":"'BA Form 2 Event Data'!W45","v":0},null,{"$f":"'BA Form 2 Event Data'!M45","v":0},{"$f":"'BA Form 2 Event Data'!X45","v":0},null,{"$f":"'BA Form 2 Event Data'!N45","v":0},{"$f":"'BA Form 2 Event Data'!Y45","v":0},null,{"$f":"'BA Form 2 Event Data'!O45","v":0},{"$f":"'BA Form 2 Event Data'!Z45","v":0},null,{"$f":"'BA Form 2 Event Data'!P45","v":0},{"$f":"'BA Form 2 Event Data'!AA45","v":0},null,{"$f":"'BA Form 2 Event Data'!Q45","v":0},{"$f":"'BA Form 2 Event Data'!AB45","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G42) = \"v\",((E41+H41+K41+N41-Q41*10*'Data Entry'!$G42+T41)-(D41+G41+J41+M41+S41)),\"\")","v":0}]
[39,{"$f":"IF(CELL(\"type\",'Data Entry'!$C43) = \"v\",'Data Entry'!$C43,\"\")","v":""},null,{"$f":"'BA Form 2 Event Data'!L46","v":0},{"$f":"'BA Form 2 Event Data'!W46","v":0},null,{"$f":"'BA Form 2 Event Data'!M46","v":0},{"$f":"'BA Form 2 Event Data'!X46","v":0},null,{"$f":"'BA Form 2 Event Data'!N46","v":0},{"$f":"'BA Form 2 Event Data'!Y46","v":0},null,{"$f":"'BA Form 2 Event Data'!O46","v":0},{"$f":"'BA Form 2 Event Data'!Z46","v":0},null,{"$f":"'BA Form 2 Event Data'!P46","v":0},{"$f":"'BA Form 2 Event Data'!AA46","v":0},null,{"$f":"'BA Form 2 Event Data'!Q46","v":0},{"$f":"'BA Form 2 Event Data'!AB46","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G43) = \"v\",((E42+H42+K42+N42-Q42*10*'Data Entry'!$G43+T42)-(D42+G42+J42+M42+S42)),\"\")","v":0}]
[40,{"$f":"IF(CELL(\"type\",'Data Entry'!$C44) = \"v\",'Data Entry'!$C44,\"\")","v":""},null,{"$f":"'BA Form 2 Event Data'!L47","v":0},{"$f":"'BA Form 2 Event Data'!W47","v":0},null,{"$f":"'BA Form 2 Event Data'!M47","v":0},{"$f":"'BA Form 2 Event Data'!X47","v":0},null,{"$f":"'BA Form 2 Event Data'!N47","v":0},{"$f":"'BA Form 2 Event Data'!Y47","v":0},null,{"$f":"'BA Form 2 Event Data'!O47","v":0},{"$f":"'BA Form 2 Event Data'!Z47","v":0},null,{"$f":"'BA Form 2 Event Data'!P47","v":0},{"$f":"'BA Form 2 Event Data'!AA47","v":0},null,{"$f":"'BA Form 2 Event Data'!Q47","v":0},{"$f":"'BA Form 2 Event Data'!AB47","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G44) = \"v\",((E43+H43+K43+N43-Q43*10*'Data Entry'!$G44+T43)-(D43+G43+J43+M43+S43)),\"\")","v":0}]
[41,{"$f":"IF(CELL(\"type\",'Data Entry'!$C45) = \"v\",'Data Entry'!$C45,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E37)=\"v\",'Data Entry'!$E37,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L48","v":0},{"$f":"'BA Form 2 Event Data'!W48","v":0},null,{"$f":"'BA Form 2 Event Data'!M48","v":0},{"$f":"'BA Form 2 Event Data'!X48","v":0},null,{"$f":"'BA Form 2 Event Data'!N48","v":0},{"$f":"'BA Form 2 Event Data'!Y48","v":0},null,{"$f":"'BA Form 2 Event Data'!O48","v":0},{"$f":"'BA Form 2 Event Data'!Z48","v":0},null,{"$f":"'BA Form 2 Event Data'!P48","v":0},{"$f":"'BA Form 2 Event Data'!AA48","v":0},null,{"$f":"'BA Form 2 Event Data'!Q48","v":0},{"$f":"'BA Form 2 Event Data'!AB48","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G45) = \"v\",((E44+H44+K44+N44-Q44*10*'Data Entry'!$G45+T44)-(D44+G44+J44+M44+S44)),\"\")","v":0}]
[42,{"$f":"IF(CELL(\"type\",'Data Entry'!$C46) = \"v\",'Data Entry'!$C46,\"\")","v":""},{"$f":"IF(CELL(\"type\",'Data Entry'!$E38)=\"v\",'Data Entry'!$E38,\"\")","v":""},{"$f":"'BA Form 2 Event Data'!L49","v":0},{"$f":"'BA Form 2 Event Data'!W49","v":0},null,{"$f":"'BA Form 2 Event Data'!M49","v":0},{"$f":"'BA Form 2 Event Data'!X49","v":0},null,{"$f":"'BA Form 2 Event Data'!N49","v":0},{"$f":"'BA Form 2 Event Data'!Y49","v":0},null,{"$f":"'BA Form 2 Event Data'!O49","v":0},{"$f":"'BA Form 2 Event Data'!Z49","v":0},null,{"$f":"'BA Form 2 Event Data'!P49","v":0},{"$f":"'BA Form 2 Event Data'!AA49","v":0},null,{"$f":"'BA Form 2 Event Data'!Q49","v":0},{"$f":"'BA Form 2 Event Data'!AB49","v":0},null,{"$f":"IF(CELL(\"type\",'Data Entry'!$G46) = \"v\",((E45+H45+K45+N45-Q45*10*'Data Entry'!$G46+T45)-(D45+G45+J45+M45+S45)),\"\")","v":0}]
[null,"Sign Convention for scan data collected in Form 2",null,"Imports: MWs are -\nExports: MWs are +",null,null,"Loads in MW as -",null,null,"Load MW as -\nGeneration MW as +",null,null,"Enter Gen MW as +",null,null,"The transactional amount in \nMW Receiver enters - Deliverer enters +\non Form 2 Data sheet",null,null,"Generation MW as +\n(If demand occurs due to gen loss, enter MW as - at value B)"]
[null,"Instructions for utilizing Adjustments:"]
[null,"1)","Balancing Authorities making adjustments must retain evidence to verify:\n  - Adjustment values are determined from scan-cycle data using Value A and Value B averaging periods. Scan-cycle data must be available if adjustments are made.\n  - Adjustments are necessary to improve accuracy of calculations compared to using Net Actual Interchange solely. \n    Said differently, unless an adjustment compensates for significant known error, it should not be made. However, as noted in the next item, once a decision to include an\n    adjustment for one or more of the five types is made for one event, the entity must calculate adjustments for that (those) type(s) for all events except for the Contengent BA Adjustment which is only utilized for the events that you are contengent during that event.\n  - Adjustments for nonconforming load must be included consistently for all events."]
[null,"2)","Dynamic Schedules: \n  - Values use schedule sign convention. \n  - Adjustments should include only dynamic schedules accounting for joint-owned units. Other dynamic schedules should be ignored.\n"]
[null,"3)","Nonconforming Loads:\n  - Values must be negative numbers.\n"]
[null,"4)","Pumped Hydro:\n - Values for pumping must be negative values.\n - Values for generating must be positive values.\n"]
[null,"5)","Not Used."]
[null,"6)","Transferred Frequency Response:\n - This value is the amount agreed upon between the entities expressed in MW/0.1 Hz. Form 2 will adjust this amount for the frequency deviation experienced.\n   (e.g., if an entity agrees to provide 20 MW/0.1 Hz to another entity and a frequency event with a deviation of 50 mHz occurs, the delivering entity should enter +20 in the\n   data column of Form 2 and the receiving entity should enter - 20. The spreadsheet will adjust the SEFRD for each entity by the 10 for this event.)\n - Values for the entity receiving the response must be entered as a negative number.\n - Values for the entity delivering the response must be entered as a positive number. \n - Values between entities must sum to zero.\n"]
[null,"7)","Contingent Balancing Authority Adjustment:\n - Data for Value A is the pre-contingency scan rate generation (+MW values) from the contingent unit(s).  \n - Data for Value B is usually 0 MW, but may be the demand (-MW values) that remains on the system that was \"netted\" out by the now offline generation.\n"]

{"sheet":"BA Form 1 Results Data","index":5,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Balancing Authority","Interconnection","Operating Year","FRO","Avg FRM for R1","Median FRM for R1"]
[{"$f":"'Data Entry'!Q29","v":"AEC"},{"$f":"Interconnection","v":"Eastern"},{"$f":"DataYear","v":2018},{"$f":"FRO","v":-2},{"$f":"'Data Entry'!Q25","v":0},{"$f":"FRMr1","v":0}]

{"sheet":"TimeZone Ref","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Full name","Abbreviation","Offset","Time zone"]
["Atlantic Daylight Time","ADT","03:00:00","UTC - 3 hours"]
["Atlantic Standard Time","AST","04:00:00","UTC - 4 hours"]
["Central Daylight Time","CDT","05:00:00","UTC - 5 hours"]
["Central Standard Time","CST","06:00:00","UTC - 6 hours"]
["Eastern Daylight Time","EDT","04:00:00","UTC - 4 hours"]
["Eastern Standard Time","EST","05:00:00","UTC - 5 hours"]
["Mountain Daylight Time","MDT","06:00:00","UTC - 6 hours"]
["Mountain Standard Time","MST","07:00:00","UTC - 7 hours"]
["Pacific Daylight Time","PDT","07:00:00","UTC - 7 hours"]
["Pacific Standard Time","PST","08:00:00","UTC - 8 hours"]

{"sheet":"Frequency Response Initiative","index":7,"n_rows":24,"n_cols":25,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FRI - NERC Frequency Response Initiative"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The FRI Report made recommendations to evaluate Primary Frequency Response at additional time intervals during the event recovery period."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional evaluations have been added to both Form 1 and Form 2 to evaluate PFR delivery for these suggested time periods."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"These evaluations utilize Interconnection frequency at specific times during the recovery period and calculates the BA's delivery of PFR for each selection."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"These evaluations are not part of BAL-003 and will not impact compliance to R1 of the draft standard."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The following time selections are evaluated: T+46, T+76, T+106, T+136 and T+166."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Each evaluation is a P.U. measure based on the BA's Bias setting at each of these times."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performance is the \"best\" performance at the specific time through 10 seconds past each time."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This is intended to account for any delay in data in the measurement.  This measurement may be changed as experience in this effort increases."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Also included is the measure of PFR delivery during the T+20 to T+52 second period, the same as R1 of the standard."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The measure (P.U.) here is based on the BA Bias setting and not the FRO.  This was done to provide comparison to the additional measurement times."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Some basic observations from this data:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1)  If the P.U. value is close to 1.0, the BA delivered the full amount of PFR equal to its Bias setting."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2)  The average performance of the Eastern Interconnection in PFR is about 40% of the total Interconnection Bias setting.  If the BA's average score is greater"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"than 0.40 P.U. then they are providing more PFR than the average BA.  If the P.U. is less than 40% then they are providing less than average PFR."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3)  If the P.U. value at T+46 is consistently less than the P.U. value at T+20 to T+52, then the PFR of the BA is not being sustained."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4)  If the P.U. value at later time interval measures is consistently less, then withdrawal of PFR is occurring at a slower rate, but still being withdrawn."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5)  If the P.U. value at T+20 to T+52, T+46, or T+76 is consistently greater than 1.0, this indicates that the BA Bias setting is too low."]

{"sheet":"Change History","index":8,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Date","Worksheet","Change"]
[]
["2014-11-17","Variable Bias Supplemental Info","Fixed the calculation of the Average Annual Bias for the \"Time weighted average FBS\""]
[null,null,"Fixed the calculation of the Average Annual Bias for the \"Time weighted minimum average FBS\""]
[null,null,"Fixed K4 typo: \"If not now enter zero.\""]
[null,null,"Fixed A3 typo: \"Feburary\""]
[null,"Data Entry","Changed HQ interconnection name to Québec"]
[null,null,"Fixed broken borders caused by copy-and-paste errors"]
[null,null,"Fixed column heading row spacing"]
[null,null,"Removed warning message about protected cells with formulas"]
["2015-11-12","Data Entry","Added Drop down list for BA name selection."]
[null,null,"Added Form 714 data to auto fill based on BA name selection."]
[null,"Form 714 Data","Added BA name list."]
[null,null,"Added FERC Form 714 data for each BA for year 2014."]
["2015-11-23","Form 714 Data","Added BA non-coincident montly peak demand MW data.  "]
[null,null,"Added BA Bias calculated based on non-coincident monthly peak demand including previous year's Bias and L10"]
["2015-12-17","Data Entry","Corrected formula for adjustments for Transferred Frequency Response in column L rows 5 through 46."]
["2016-05-13","2016 Data Entry","Changed \"Data Entry\" sheet name to \"2016 Data Entry\" "]
[null,"2014 Form 714 Data","Changed \"Form 714 Data\" sheet name to \"2014 Form 714 Data\" "]
[null,"2016 Data Entry","Removed the effect of transferred frequency response from the SEFRD FRM that is used to calculate Bias, so that only FRM for R1 changes"]
[null,"All","Locked all worksheets"]
["2016-08-16","2016 Data Entry","Removed links to external files. Added 2016 Q1& Q2 event dates and times."]
[null,"BA Form 2 Event Data","Unlocked input cells that were locked."]
["2016-11-15","2016 Data Entry","Added 2016 Q3 event dates and times."]
["2017-01-07","2016 Data Entry","Input 2016 Final selection of Frequency Events"]
[null,"2015 Form 714 Data","Added 2015 data sheet for use in calculating and selecting 2017 FBS."]
[null,"All","Locked all worksheets"]
["2017-05-08","All","Rearanged Tabs into a more logical order"]
[null,"Various","Hid several Columns and Worksheets that are either source data or are background information."]
[null,"Various","Reformatting"]
[null,"Various","Updated for event data entry for Operating Year 2017"]
[null,"Data Entry","Corrected formulae in Column P to correctly exclude Frequency Respons Transfers from the Bias Calculations."]
[null,"All","Locked all worksheets"]

{"sheet":"Frequency Event Graphs","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}