{"text_format":"2","workbook":"xls","n_sheets":9,"sheets":["Instructions","Data Entry","Form 714 Data","Adjustments","Variable Bias Supplemental Info","BA Form 2 Event Data","TimeZone Ref","Event Frequency Graphs","Frequency Response Initiative"],"not_rendered":{"charts":7,"images":12,"macros":1,"external_links":2,"defined_names":11,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Instructions","index":0,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,8],[2,1,2,8],[4,1,4,8],[7,1,7,8]],"flags":["formulas_cached_only"]}
["Instructions"," "]
[null," "]
["Step 1","Enter data in all green cells on the \"Data Entry\" worksheet.  Cell G1 with the BA name.  Cells R11 through R13 with contact information.  Cell R24 with BA Bias Type, Fixed or Variable."]
[]
["Step 2","For identified events in column C of the \"Data Entry\" worksheet, collect data and complete one FRS Form 2 workbook for each event in the list."]
[null,"Detailed Instructions for utilizing the \"Adjustments\" are located on the \"Adjustments\" worksheet below the table."]
[]
["Step 3","PasteSpecial/Values data from FRS Form 2 \"Form 1 Summary Data\" worksheet into \"BA Form 2 Event Data\" worksheet of this workbook.  Do this for each event in the list."]
[]
["Step 4","Enter FERC Form 714 data from the most recent completed Form 714 in the worksheet \"Form 714 Data\" in cells C7 through D18.  Use Copy/PasteSpecial/Values to enter data."]
[null,"Your current year's Frequency Response Obligation will be calculated in cell R20 of the \"Data Entry\" worksheet."]
[]
["Step 5","a) If a Fixed Bias was selected, cell R27 will calculate the minimum Bias (least negative) allowed based on your Peak Demand or Peak Generation for Generation only BAs."]
[null,"b) If a Fixed Bias was selected, cell R28 will calculate the minimum (in absolute terms) Bias allowed based on 100% of your FRM."]
[null,"c) If a Fixed Bias was selected, cell R29 will calculate the maximum Bias (in absolute terms) allowed based on 125% of your FRM."]
[null,"d) If R29 was more negative than the value in R27, you may choose a Bias setting that is between R29 and the lesser of R27 or R28 and enter it here.  Based on your choice, your Bias Setting will appear in cell R33."]
[]
["Step 6","a) If a Variable Bias was selected, cell R27 will indicate \"not applicable\" where there is no maximum or minimum Bias Setting."]
[null,"b) If a Variable Bias was selected, enter \"Variable\" in cell R31."]
[null,"c) If a Variable Bias was selected, cell R30 will calculate the minimum Bias (in absolute terms) allowed based on your FRM and Peak Demand/Peak Generation.  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."]
[null,"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 this worksheet, R3 of the standard has not been met and cell D14 on the \"Variable Bias Supplementa 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."]
[null,"e) Depending on when the Implementation date is each year for the annual Bias Setting, the ERO may be required to edit the selection of each months' minimum average FBS value.  This should be completed by the ERO before each year's FRS Form 1 is published."]
[null,"f) The comparison to the FBS minimum will be from two previous year's analysis prior to the current year and the dates in the table starting at J3 will indicate the appropriate year's data to use.  For example, if it is Feb 1, 2013 and you are calculating your 2012 FBS time weigted average, the minimum FBS value will be determined from your FRM that you calculated in Feb of 2012 and based on the Peak Demand/Peak Gen reported in June of 2011 for 2010 data.  Enter each field in green using the appropriate year's data."]
[]
["Step 7","Two FRMs are calculated.  One for the BA Bias Setting and one for meeting R1 of the standard."]
[null,"The FRM for the BA Bias Setting will use all selected events and all SEFRD values will use the delta frequency as measured."]
[null,"The FRM for the BA compliance to R1 will limit the delta frequency to no greater than those listed in Table 2 of Attachment A for each Interconnection.  (Eastern +/-0.500 Hz, Western +/-0.500 Hz, ERCOT +/-0.700 Hz and HQ +/-1.500 Hz.)"]
[]
["Step 7","Save this workbook using the following file name format:NYISO_yyyy_FRS_Form_1.9.xlsx. (where NYISO is replaced with your Balancing Authority abbreviation).  See cell \"G74\" on the Data Entry worksheet for your exact file name."]
[]
["Step 8","Send completed Form 1 and each Form 2 to NERC."]

{"sheet":"Data Entry","index":1,"n_rows":74,"n_cols":59,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,57,1,58],[2,57,2,58],[46,44,46,48],[30,19,31,19],[21,44,21,48],[22,44,22,48],[40,44,40,48],[41,44,41,48],[42,44,42,48],[34,44,34,48],[48,44,48,48],[31,44,31,48],[39,44,39,48],[10,44,10,48],[29,44,29,48],[30,44,30,48],[17,44,17,48],[18,44,18,48],[19,44,19,48],[20,44,20,48],[49,44,49,48],[50,44,50,48],[47,44,47,48],[32,44,32,48],[35,44,35,48],[36,44,36,48],[33,44,33,48],[43,44,43,48],[44,44,44,48],[45,44,45,48],[7,44,7,48],[8,44,8,48],[9,44,9,48],[37,44,37,48],[38,44,38,48],[24,44,24,48],[25,44,25,48],[26,44,26,48],[27,44,27,48],[28,44,28,48],[32,18,33,18],[32,19,33,19],[0,52,0,58],[73,6,73,14],[65,6,65,14],[67,6,67,14],[69,6,69,14],[71,6,71,14],[11,44,11,48],[0,21,0,22],[0,8,0,16],[12,44,12,48],[23,44,23,48],[14,44,14,48],[15,44,15,48],[16,44,16,48],[13,44,13,48],[4,44,4,48],[5,44,5,48],[6,44,6,48]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"Balancing Authority","MyBA",null,"NERC FRS FORM 1 20 to 52 second Value B",{"$nulls":9},"Enter Addition Data in column W ==>",null,null,"Information",null," Select Reason(s) for adjustment",{"$nulls":28},"Columns BA, BB, BC, BD, BE, BF and BG are reserved for calculation of the linear regression."]
["Event","UTC (t-0)","Date/Time (t-0)","Time","Date/Time (t-0)","BA",null,"BA ","BA","Relay Lmt"," Value \"A\" Information",null," Value \"B\" Information",null,"SEFRD (FRM)",null,"Exclude for",null,"Enter Data in Green Highlighted Cells",null,null," Value \"A\""," Value \"B\"",{"$nulls":29},"BA Delta","10 X BA","10 X BA","SEFRDB","SEFRDR","Regression"]
[{"$nulls":5},"Time",null,null,"Bias","R1",{"$nulls":4},"for Bias","for R1",{"$nulls":36},"NAI","DelFreq","DelFreq","(MW/0.1Hz)","(MW/0.1Hz)","Statistics"]
["Number","Date / Time\n(MM/DD/YY HH:MM:SS)","(Central Prevailing)","Zone","BA Time","Zone","DelFreq","Time","DelFreq","DelFreq","NAI","Adjustment","NAI","Adjustment","(MW/0.1Hz)","(MW/0.1Hz)","data error *",0.8999999999999999,"Send copy to:","Chris.Scheetz@nerc.net",null,"Load","Load","Reason(s)",{"$nulls":29},"For Bias","For R1",null,null,"For Bias"]
[1,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,{"$error":"#DIV/0!"},0,"N",0,null,null,null,0,0,{"$nulls":17},-0.05776069277810336,23.246720631917327,null,null,"Dynamic schedules for joint-owned units (DS)",{"$nulls":7},0,0,595,{"$error":"#DIV/0!"},0,0,0]
[2,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,{"$error":"#DIV/0!"},0,"N",0,null,null,null,0,0,{"$nulls":17},-0.06609326317200015,27.701624461582725,null,null,"Nonconforming load (NL)",{"$nulls":7},0,0,595,{"$error":"#DIV/0!"},0,0,{"$error":"#N/A"}]
[3,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,{"$error":"#DIV/0!"},0,"N",0,null,null,null,0,0,{"$nulls":17},-0.04023978823700247,10.663229942321777,null,null,"Pumped hydro (PH)",{"$nulls":7},0,0,595,{"$error":"#DIV/0!"},0,1,0]
[4,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,{"$error":"#DIV/0!"},0,"N",0,1901,"Bias Calculation Form 1 for Year",null,0,0,{"$nulls":17},-0.05252492995489888,80.6608905519758,null,null,"Invalid Data (ID)",{"$nulls":7},0,0,595,{"$error":"#DIV/0!"},0,{"$error":"#NUM!"},12]
[5,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,{"$error":"#DIV/0!"},0,"N",0,"Eastern","Interconnection",null,0,0,{"$nulls":17},-0.07090523129419779,-26.897608961377827,null,null,"Transfered Frequency Response (TFR)",{"$nulls":7},0,0,595,{"$error":"#DIV/0!"},0,0,0]
[6,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,{"$error":"#DIV/0!"},0,"N",0,"MyBA","Balancing Authority",null,0,0,{"$nulls":17},-0.05190676734569877,9.955449178814888,null,null,"Contingent BA adjustment for loss of units (CBA)",{"$nulls":7},0,0,595,{"$error":"#DIV/0!"},0]
[7,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,{"$error":"#DIV/0!"},0,"N",0,null,"Contact Name",null,0,0,{"$nulls":17},-0.05804770333430298,3.3670240129743263,null,null,"DS & NL",{"$nulls":7},0,0,595,{"$error":"#DIV/0!"},0,"For R1"]
[8,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,{"$error":"#DIV/0!"},0,"N",0,null,"Contact Phone #",null,0,0,{"$nulls":17},-0.07557242257249897,36.33442687988281,null,null,"DS & PH",{"$nulls":7},0,0,595,{"$error":"#DIV/0!"},0,0,0]
[9,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,{"$error":"#DIV/0!"},0,"N",0,null,"Contact e-mail",null,0,0,{"$nulls":17},-0.05638049897699915,0.4882530443596238,null,null,"DS & ID",{"$nulls":7},0,0,595,{"$error":"#DIV/0!"},0,0,{"$error":"#N/A"}]
[10,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,{"$error":"#DIV/0!"},0,"N",0,null,"MWh Annual GenBA is the annual \"Net Generation (MWh)\", FERC Form 714, line 13, column c of Part II - Schedule 3.",null,0,0,{"$nulls":17},-0.057332901727598085,2.7580369313557895,null,null,"DS & TFR",{"$nulls":7},0,0,595,{"$error":"#DIV/0!"},0,1,0]
[11,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,{"$error":"#DIV/0!"},0,"N",0,null,"MWh Annual LoadBA is the annual \"Net Energy for Load (MWh)\", FERC Form 714, line 13, column e of Part II - Schedule 3.",null,0,0,{"$nulls":17},-0.05176090058829885,13.64341688156128,null,null,"DS & CBA",{"$nulls":7},0,0,595,{"$error":"#DIV/0!"},0,{"$error":"#NUM!"},11]
[12,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,{"$error":"#DIV/0!"},0,"N",0,null,"MWh Annual GenINT is the Sum of all Annual GenBA values in this interconnection",null,0,0,{"$nulls":17},-0.049999237060546875,11.100745916366577,null,null,"DS & NL & PH",{"$nulls":7},0,0,595,{"$error":"#DIV/0!"},0,0,0]
[13,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",null,"MWh Annual LoadINT is the Sum of all Annual LoadBA values in this interconnection",null,0,0,{"$nulls":17},-0.052,-19.90684648354848,null,null,"DS & NL & ID"]
[14,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",-964,"Interconnection Frequency Response Obligation (FRO) MW/0.1 Hz.  Determined by ERO.",null,0,0,{"$nulls":17},-0.055999755859375,12.32546430163913,null,null,"JOU DS & NL & TFR"]
[15,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",1900,"Current data year (December thru November)",null,0,0,{"$nulls":17},-0.058498382568359375,0.7501918474833147,null,null,"DS & NL & CBA"]
[16,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",{"$error":"#DIV/0!"},"1901 BA Frequency Response Obligation (FRO) for next year's FRM",null,0,0,{"$nulls":17},-0.04850006103515625,2.230057779947913,null,null,"DS & NL & PH & ID"]
[17,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",null,"1900 BA Frequency Response Obligation (FRO) for this year's FRM from your last year's Form 1.",null,0,0,{"$nulls":17},-0.04500007629394531,9.477859330177306,null,null,"DS & NL & PH & TFR"]
[18,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",null,null,null,0,0,{"$nulls":17},-0.037502288818359375,0.35530900955200195,null,null,"DS & NL & PH & CBA"]
[19,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",null,"BA Bias Type and Bias Setting",null,0,0,{"$nulls":17},-0.0475006103515625,2.1707018534342453,null,null,"DS & NL & PH & ID & TFR"]
[20,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","","Fixed","Bias Type utilized.",null,0,0,{"$nulls":17},-0.055500030517578125,29.382074276606243,null,null,"DS & NL & PH & ID & CBA"]
[21,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",0.009,"Interconnection Minimum Fixed Frequency Bias Setting % of Peak Demand or Peak Generation (Set by ERO)",null,0,0,{"$nulls":17},-0.047,4.601381301879883,null,null,"DS & NL & PH & ID & TFR & CBA"]
[22,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",621018,"The Sum of the Non-Coincident peak demands for all Bas on the interconnection from FERC Form No. 714, provided by ERO.",null,0,0,{"$nulls":17},-0.060000000000002274,1.5935148795445762,null,null,"NL & PH"]
[23,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",{"$error":"#DIV/0!"},"Your BA's lowest absolute Fixed Frequency Bias Setting based on interconnection non-coincident peak demand.",null,0,0,{"$nulls":17},-0.05999999999999517,52.3709077835083,null,null,"NL & ID"]
[24,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",{"$error":"#DIV/0!"},"Your BA's lowest absolute Fixed Frequency Bias Setting based on 100% of FRM.",null,0,0,{"$nulls":17},-0.05100000000000193,33.947873671849564,null,null,"NL & TFR"]
[25,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",{"$error":"#DIV/0!"},"Your BA's highest absolute Fixed Bias Setting: 125% of FRM.",null,0,0,{"$nulls":17},-0.1,100,null,null,"NL & CBA"]
[26,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","","n/a","Balancing Authority lowest absolute Variable Bias Setting (least negative one minute average Bias while frequency is less than 59.964 or greater than 60.036 Hz).",null,0,0,{"$nulls":21},"NL & PH & ID"]
[27,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",-20.87,"Balancing Authority desired Bias Setting: May be set to a value between 100% to 125% of its FRM if this value is more negative than the minimum Bias based on Peak Demand.  If not more negative, then the Bias must be the minimum Bias based on Peak Demand.  If variable Bias is used, enter \"Variable\".",null,0,0,{"$nulls":21},"NL & PH & TFR"]
[28,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y",""," ",null,null,0,0,{"$nulls":21},"NL & PH & BAA"]
[29,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",{"$error":"#DIV/0!"},"1901 Frequency Bias Setting - (minimum of 100% to 125% of FRM, or 0.9% of Historical Peak Demand if not Variable)",null,0,0,{"$nulls":21},"NL & PH & ID & TFR"]
[30,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",null,null,null,0,0,{"$nulls":18},"N",null,null,"NL & PH & ID & CBA"]
[31,"06:00:00",null,"CST","00:00:00","CST",null,"00:00:00",0,0,0,0,0,0,"","","Y","",{"$error":"#DIV/0!"},"1900 FRM - Average Estimated Frequency Response MW/0.1 Hz using SEFRD for Bias",null,0,0,{"$nulls":18},"Y",null,null,"NL & PH & ID & TFR & CBA"]
[32,{"$nulls":6},"00:00:00",0,0,0,0,0,0,"","","Y","",0,"1900 FRM - Regression Estimated Frequency Response MW/0.1Hz using SEFRD for Bias",null,0,0,{"$nulls":21},"PH & ID"]
[33,{"$nulls":6},"00:00:00",0,0,0,0,0,0,"","","Y","",{"$error":"#DIV/0!"},"1900 FRM - Median Estimated Frequency Response MW/0.1Hz using SEFRD for Bias",null,0,0,{"$nulls":21},"PH & TFR"]
[34,{"$nulls":6},"00:00:00",0,0,0,0,0,0,"","","Y","",0,"1900 FRM - Average Estimated Frequency Response MW/0.1 Hz using SEFRD for R1",null,0,0,{"$nulls":21},"PH & CBA"]
[35,{"$nulls":6},"00:00:00",0,0,0,0,0,0,"","","Y","",0,"1900 FRM - Regression Estimated Frequency Response MW/0.1Hz using SEFRD for R1",null,0,0,{"$nulls":21},"PH & ID & TFR"]
[36,{"$nulls":6},"00:00:00",0,0,0,0,0,0,"","","Y","",0,"1900 FRM - Median Estimated Frequency Response MW/0.1Hz for BA Compliance to R1, minimum Frequency Response",null,0,0,{"$nulls":21},"PH & ID & CBA"]
[37,{"$nulls":6},"00:00:00",0,0,0,0,0,0,"","","Y","","N","Do you RECEIVE Overlap regulation?",null,0,0,{"$nulls":21},"PH & TFR"]
[38,{"$nulls":6},"00:00:00",0,0,0,0,0,0,"","","Y","",null,"If Yes, list the BA name and the associated Bias of that BA in the table below.",null,0,0,{"$nulls":21},"PH & CBA"]
[39,{"$nulls":6},"00:00:00",0,0,0,0,0,0,"","","Y","",null,null,null,0,0,{"$nulls":21},"PH & ID & TFR"]
[40,{"$nulls":6},"00:00:00",0,0,0,0,0,0,"","","Y","","Bias -MW/0.1 Hz","Balancing Authority",null,0,0,{"$nulls":21},"PH & ID & CBA"]
[41,{"$nulls":6},"00:00:00",0,0,0,0,0,0,"","","Y","",null,null,null,0,0,{"$nulls":21},"PH & TFR"]
[42,{"$nulls":6},"00:00:00",0,0,0,0,0,0,"","","Y","",null,null,null,0,0,{"$nulls":21},"PH & CBA"]
[{"$nulls":44},"PH & ID & TFR & CBA"]
[{"$nulls":44},"RU & TFR"]
[{"$nulls":44},"RU & CBA"]
[{"$nulls":44},"RU & TFR & CBA"]
[{"$nulls":44},"TFR & CBA"]
[]
[]
[]
[{"$nulls":18},"N","Do you PROVIDE Overlap regulation?"]
[{"$nulls":19},"If Yes, list the BA name and the associated Bias of that BA",{"$nulls":21},"N"]
[{"$nulls":41},"Y"]
[{"$nulls":18},"Bias -MW/0.1 Hz","Balancing Authority"]
[]
[]
[{"$nulls":41},"Fixed"]
[null,null," ",{"$nulls":38},"Variable"]
[{"$nulls":6}," "]
[null,null,"Instructions",null,null,null," ",{"$nulls":35},"Relay Limits"]
[{"$nulls":6}," ",{"$nulls":34},"Eastern",59.5,60.5]
[null,null,"Step 1",null,null,null,"Enter data in all green cells on this \"Data Entry\" worksheet.",{"$nulls":34},"Western",59.5,60.5]
[{"$nulls":41},"ERCOT",59.3,60.7]
[null,null,"Step 2",null,null,null,"For identified events in column B, collect data and complete FRS Form 2.9 for each event in the list.",{"$nulls":34},"HQ",58.5,61.5]
[]
[null,null,"Step 3",null,null,null,"PasteSpecial/Values data from FRS Form 2.9 \"Form 1 Summary Data\" into \"BA Form 2 Data\" worksheet of this workbook.  Do this for each event in the list."]
[]
[null,null,"Step 4",null,null,null,"Save this workbook using the following file name format:NYISO_yyyy_FRS_Form_1.9.xlsm and send a copy of this workbook and all FRS_Form 2 workbooks to NERC. (where NYISO is replaced with your BA name)"]
[]
[{"$nulls":6},"MyBA_1901_FRS_Form_1.9.xlsm"]

{"sheet":"Form 714 Data","index":2,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,2]],"flags":["formulas_cached_only"]}
[]
[null,"Report 714 Data (in MW)"]
[null,"Part II Schedule 3"]
[]
[null,"Column (b)","Column (j)"]
[null,"Month","Peak Demand"]
[null,"January"]
[null,"February",{"$nulls":4},"Peak Demand: (Your BA from Form 714, column j of Part II - Schedule 3)"]
[null,"March"]
[null,"April"]
[null,"May"]
[null,"June"]
[null,"July"]
[null,"August"]
[null,"September"]
[null,"October"]
[null,"November"]
[null,"December"]
[]
[null,"Average",{"$error":"#DIV/0!"}]
[null,"Maximum",0]

{"sheet":"Adjustments","index":3,"n_rows":54,"n_cols":22,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,18,0,19],[1,11,2,11],[1,14,2,14],[1,17,2,17],[0,3,0,4],[0,6,0,7],[0,9,0,10],[0,12,0,13],[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],[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],[50,2,50,19],[51,2,51,19],[59,2,59,19],[52,2,52,19],[47,2,47,19],[48,2,48,19],[49,2,49,19]],"flags":["formulas_cached_only"]}
[null,"Balancing Authority","MyBA","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","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","(Central Prevailing)","DelFreq","Adjustment","Adjustment",null,"Adjustment","Adjustment",null,"Adjustment","Adjustment",null,"Adjustment","Adjustment",null,"Adjustment","Adjustment",null,"Adjustment","Adjustment"]
[1,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[2,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[3,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[4,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[5,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[6,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[7,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[8,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[9,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[10,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[11,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[12,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[13,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[14,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[15,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[16,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[17,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[18,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[19,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[20,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[21,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[22,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[23,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[24,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[25,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[26,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[27,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[28,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[29,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[30,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[31,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[32,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[33,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[34,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[35,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[36,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[37,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[38,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[39,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[40,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[41,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[42,"","",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,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 are included consistently for all events (e.g. if adjustments for nonconforming load are made for one event, the load must be included for all events, etc.).                                                                                                       "]
[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)","Rampling Units:\n - Values are positive values.\n"]
[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":"Variable Bias Supplemental Info","index":4,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Month","Minimum FBS* for month","Maximum FBS* for month","Time weighted ** average FBS* for month","Time weighted ** minimum average FBS* for month"]
["January",{"$nulls":8},"Balancing Authority:",null,"MyBA"]
["Feburary",{"$nulls":8},1899,"Reporting period FRS Form 1 data"]
["March",{"$nulls":8},0,"1899 Reporting period: Balancinig Authority FRM MW/0.1 Hz, enter from FRS Form 1 for that year's FRM.  If not know enter zero."]
["April",{"$nulls":8},0.01,"1899 Reporting period: Interconnection Minimum Fixed Frequency Bias Setting % of Peak Demand or Peak Generation (Set by ERO)"]
["May ",{"$nulls":9},"1899 Reporting period: Your BA's Annual Peak Demand or Peak Gen for Gen only BAs from your BA Form 714."]
["June",{"$nulls":8},0,"Your BA's lowest absolute Fixed Frequency Bias Setting based on BA Peak Demand (Peak Generation for Generation only BA) MW/0.1 Hz."]
["July",{"$nulls":8},0,"Your BA's lowest absolute Fixed Frequency Bias Setting based on 100% of FRM."]
["August",{"$nulls":8},0,"1900 Minimum, lowest absolute, conditional average Frequency Bias Setting MW/0.1 Hz."]
["September",{"$nulls":9},"1899 Minimum, lowest absolute, conditional average Frequency Bias Setting MW/0.1 Hz."]
["October"]
["November"]
["December"]
[null,null,null,0,0,"1900 Average Annual Bias MW/0.1 Hz"]
[]
["* Frequency Bias Setting (FBS)"]
["** Based on the one minute values used in BAL 001 when frequency is greater than 60.036 Hz or less than 59.964 Hz."]

{"sheet":"BA Form 2 Event Data","index":5,"n_rows":49,"n_cols":47,"rows_kept":49,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[{"$nulls":27},"Average P.U. Performance",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$nulls":4},{"$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.",{"$nulls":5},"Value A Data",null,"BA Performance",{"$nulls":8},"Value B","20 to 52 second Average Period Evaluation",{"$nulls":13},"Frequency Response Initiative - Additional Primary Frequency Response Evaluation Points"]
[{"$nulls":11},"JOU","Non-",null,null,"Transferred","Contingent",{"$nulls":5},"JOU","Non-",null,null,"Transferred","Contingent",{"$nulls":6},"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"]
[{"$nulls":4},"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"]
["Event","Date/Time",{"$nulls":7},"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"]
["Number","(Central Prevailing)","DelFreq",{"$nulls":6},"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"]
[1,"00:00:00",0]
[2,"00:00:00",0]
[3,"00:00:00",0]
[4,"00:00:00",0]
[5,"00:00:00",0]
[6,"00:00:00",0]
[7,"00:00:00",0]
[8,"00:00:00",0]
[9,"00:00:00",0]
[10,"00:00:00",0]
[11,"00:00:00",0]
[12,"00:00:00",0]
[13,"00:00:00",0]
[14,"00:00:00",0]
[15,"00:00:00",0]
[16,"00:00:00",0]
[17,"00:00:00",0]
[18,"00:00:00",0]
[19,"00:00:00",0]
[20,"00:00:00",0]
[21,"00:00:00",0]
[22,"00:00:00",0]
[23,"00:00:00",0]
[24,"00:00:00",0]
[25,"00:00:00",0]
[26,"00:00:00",0]
[27,"00:00:00",0]
[28,"00:00:00",0]
[29,"00:00:00",0]
[30,"00:00:00",0]
[31,"00:00:00",0]
[32,"00:00:00",0]
[33,"00:00:00",0]
[34,"00:00:00",0]
[35,"00:00:00",0]
[36,"00:00:00",0]
[37,"00:00:00",0]
[38,"00:00:00",0]
[39,"00:00:00",0]
[40,"00:00:00",0]
[41,"00:00:00",0]
[42,"00:00:00",0]

{"sheet":"TimeZone Ref","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["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":"Event Frequency Graphs","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Frequency Response Initiative","index":8,"n_rows":24,"n_cols":25,"rows_kept":24,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":24},"FRI - NERC Frequency Response Initiative"]
[]
[{"$nulls":24},"The FRI Report made recommendations to evaluate Primary Frequency Response at additional time intervals during the event recovery period."]
[{"$nulls":24},"Additional evaluations have been added to both Form 1 and Form 2 to evaluate PFR delivery for these suggested time periods."]
[{"$nulls":24},"These evaluations utilize Interconnection frequency at specific times during the recovery period and calculates the BA's delivery of PFR for each selection."]
[{"$nulls":24},"These evaluations are not part of BAL-003 and will not impact compliance to R1 of the draft standard."]
[{"$nulls":24},"The following time selections are evaluated: T+46, T+76, T+106, T+136 and T+166."]
[{"$nulls":24},"Each evaluation is a P.U. measure based on the BA's Bias setting at each of these times."]
[{"$nulls":24},"Performance is the \"best\" performance at the specific time through 10 seconds past each time."]
[{"$nulls":24},"This is intended to account for any delay in data in the measurement.  This measurement may be changed as experience in this effort increases."]
[]
[{"$nulls":24},"Also included is the measure of PFR delivery during the T+20 to T+52 second period, the same as R1 of the standard."]
[{"$nulls":24},"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."]
[]
[{"$nulls":24},"Some basic observations from this data:"]
[]
[{"$nulls":24},"1)  If the P.U. value is close to 1.0, the BA delivered the full amount of PFR equal to its Bias setting."]
[{"$nulls":24},"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"]
[{"$nulls":24},"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."]
[{"$nulls":24},"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."]
[{"$nulls":24},"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."]
[{"$nulls":24},"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."]