{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Quarterly_MIA_Data","Tabulated_Data","Data_Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Quarterly_MIA_Data","index":0,"n_rows":20,"n_cols":56,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,55],[1,0,1,55],[2,0,2,55],[4,0,4,55],[7,4,7,10],[7,11,7,16],[7,17,7,29],[7,30,7,40],[7,41,7,51],[7,52,7,53]]}
["COMMONWEALTH OF PENNSYLVANIA"]
["DEPARTMENT OF ENVIRONMENTAL PROTECTION"]
["Oil & Gas Management"]
[]
["Mechanical Integrity Assessment Report - Home-Use Well"]
["1. Well Operator/Owner"]
[]
["Issued 4/10/2014"]
["2. Abridged API #","3. Well Type","10. Surface or Coal Casing Set Depth (ft)","4. Quarterly Inspection Date (Place Q1 date in the first box below, Q2 in the second, Q3 in the third, and Q4 in the fourth)","5. Primary Production Gas Pressure (psig)","b. Produced Annular Gas Pressure (psig)","c. Shoe Test Pressure (psig) (OPTIONAL)","d. Annulus","e. Water Level (ft)","f. Average Daily Pumping Time (hours) or Average Daily Pumping Volume (bbls) (If no produced water, indicate \"NPW\")","g. Produced Water Quality -  Specific Conductance (μS or μmhos/cm)","a. If Production Annulus is Inaccessible, Enter \"I\"","b. Production Annulus Flow (scfpd)","c. Production Annulus Pressure (psig)","d. Time Since Annulus was Last Blown Down (days) (OPTIONAL)","e. Cement Top in Production Annulus Above Next Outer Casing Shoe (Y/N) (OPTIONAL)","f. Annulus","a. Annulus","b. Flow (scfpd)","c. Annulus Shut-in (Y/N/I)","d. Annulus","e. Flow (scfpd)","f. Annulus Shut-in (Y/N/I)","g. Annulus","h. Flow (scfpd)","i. Annulus Shut-in (Y/N/I)","j. Annulus","k. Flow (scfpd)","l. Annulus Shut-in (Y/N/I)","6. Escaping Gas from Surface/Wellhead Equipment/Outside Conductor (Y/N)","a. Annulus","b. Annulus Shut-in (Y/N/I)","c. Annulus","d. Annulus Shut-in (Y/N/I)","e. Annulus","f. Annulus Shut-in (Y/N/I)","g. Annulus","h. Annulus Shut-in (Y/N/I)","i. Annulus","j. Annulus Shut-in (Y/N/I)","7. Escaping Oil from Surface/Wellhead Equipment/Outside Conductor (Y/N)","a. Annulus","b. Annulus Shut-in (Y/N/I)","c. Annulus","d. Annulus Shut-in (Y/N/I)","e. Annulus","f. Annulus Shut-in (Y/N/I)","g. Annulus","h. Annulus Shut-in (Y/N/I)","i. Annulus","j. Annulus Shut-in (Y/N/I)","8. Escaping Produced Water from Surface /Wellhead Equipment/ Outside Conductor (Y/N)","9. Wellhead Hydrogen Sulfide (ppm)","10. Wellhead Methane                        (% LEL)","11. Corrosion Problems (Y/N)  ","12. Comments"]
[]
[]
[]
[]
[]
[]
["INSTRUCTIONS:"]
["(1) Fill out all yellow-shaded boxes above.  Each line should contain information for one quarterly inspection."]
["(2) Only fill out red-shaded boxes if escaping gas is noted at well. "]
["(3) After completing all FOUR quarterly inspections, select button labeled \"Create Data Summary Sheet for Annual Report\" and submit report electronically to DEP."]
["(4) Call 717.772.2199 for assistance."]

{"sheet":"Tabulated_Data","index":1,"n_rows":6,"n_cols":139,"rows_kept":6,"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,"P",null,"I",null,null,null,"I1",null,null,null,"I2",null,null,null,"S/C",null,null,null,"S/C1",null,null,null,"S/C2"]
["Well_Own_Oper","API_Num","Well_Type","WL_Acc","FW_Cas_Only","Ann_Prod","Ann_Prod_In_FW_Cas","#_Cas_Stgs","Surf_Cas_Set_Depth","Insp_Date","Prim_Prod_Gas_Press","Ann_Gas_Press","Shoe_Test_Press","Produced_Ann","WL","Avg_Pump_Time","Prod_WQ","Prod_Ann_Status","P_Flow","P_Pressure","Blow_Down_Time","TOC_Above","Production_Ann","P_LHC_Flow","P_NFW_Flow","I_G_Flow","I_Ann_Status","I_LHC_Flow","I_NFW_Flow","I1_G_Flow","I1_Ann_Status","I1_LHC_Flow","I1_NFW_Flow","I2_G_Flow","I2_Ann_Status","I2_LHC_Flow","I2_NFW_Flow","S_C_G_Flow","S_C_Ann_Status","S_C_LHC_Flow","S_C_NFW_Flow","S_C_1_G_Flow","S_C_1_Ann_Status","S_C_1_LHC_Flow","S_C_1_NFW_Flow","S_C_2_G_Flow","S_C_2_Ann_Status","S_C_2_LHC_Flow","S_C_2_NFW_Flow","Surf_Leak_G","Surf_Leak_LHC","Surf_Leak_NFW","H2S","CH4","Corr_Prob","Comments","Notification","Cas_Seat_Press",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annulus",null,"Annulus",null,"Annulus",null,"Annulus",null,"Annulus","Annular Spaces","I","I1","I2","S/C","S/C1","S/C2",null,null,null,null,"Overpressuring"]
[{"$f":"BG3","v":0},{"$f":"BH3","v":0},{"$f":"BI3","v":0},{"$f":"IF(BJ3=\"\",\"NA\",IF(AND(BM3=\"\",BQ3=\"\",BR3=\"\",BP3>0),\"Y\",\"NA\"))","v":"NA"},{"$f":"IF(AND(BJ3>0,BM3=0),\"Y\",\"N\")","v":"N"},{"$f":"IF(BM3=\"\",\"N\",\"Y\")","v":"N"},{"$f":"IF(AND(F3=\"Y\",BJ3>0),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B3>0,DX3=0),\"No well record\",DX3)","v":0},{"$f":"IF(BJ3=\"\",\"NA\",BJ3)","v":"NA"},{"$f":"BK3","v":"00:00:00"},{"$f":"IF(BL3=\"\",\"NA\",BL3)","v":"NA"},"NA","NA","NA","NA","NA","NA",{"$f":"IF(BM3>0,\"NA\",IF(AND(BT3=\"\",BU3=\"\"),\"I\",IF(BT3=\"\",\"SI\",\"V\")))","v":"I"},{"$f":"IF(R3=\"V\",BT3,\"NA\")","v":"NA"},{"$f":"IF(R3=\"SI\",BU3,\"NA\")","v":"NA"},{"$f":"IF(BV3=\"\",\"NA\",BV3)","v":"NA"},{"$f":"IF(BW3=\"\",\"NA\",BW3)","v":"NA"},{"$f":"IF(BX3=\"\",\"NA\",BX3)","v":"NA"},{"$f":"IF(CL3=$X$1,CM3,IF(CN3=$X$1,CO3,IF(CP3=$X$1,CQ3,IF(CR3=$X$1,CS3,IF(CT3=$X$1,CU3,\"NA\")))))","v":"NA"},{"$f":"IF(CW3=$X$1,CX3,IF(CY3=$X$1,CZ3,IF(DA3=$X$1,DB3,IF(DC3=$X$1,DD3,IF(DE3=$X$1,DF3,\"NA\")))))","v":"NA"},{"$f":"IF(BY3=$Z$1,BZ3,IF(CB3=$Z$1,CC3,IF(CE3=$Z$1,CF3,IF(CH3=$Z$1,CI3,\"NA\"))))","v":"NA"},{"$f":"IF(DY3=\"N\",\"V\",IF(DY3=\"Y\",\"SI\",IF(DY3=\"I\",DY3,\"NA\")))","v":"NA"},{"$f":"IF(CL3=$Z$1,CM3,IF(CN3=$Z$1,CO3,IF(CP3=$Z$1,CQ3,IF(CR3=$Z$1,CS3,IF(CT3=$Z$1,CU3,\"NA\")))))","v":"NA"},{"$f":"IF(CW3=$Z$1,CX3,IF(CY3=$Z$1,CZ3,IF(DA3=$Z$1,DB3,IF(DC3=$Z$1,DD3,IF(DE3=$Z$1,DF3,\"NA\")))))","v":"NA"},{"$f":"IF(BY3=$AD$1,BZ3,IF(CB3=$AD$1,CC3,IF(CE3=$AD$1,CF3,IF(CH3=$AD$1,CI3,\"NA\"))))","v":"NA"},{"$f":"IF(DZ3=\"N\",\"V\",IF(DZ3=\"Y\",\"SI\",IF(DZ3=\"I\",DZ3,\"NA\")))","v":"NA"},{"$f":"IF(CL3=$AD$1,CM3,IF(CN3=$AD$1,CO3,IF(CP3=$AD$1,CQ3,IF(CR3=$AD$1,CS3,IF(CT3=$AD$1,CU3,\"NA\")))))","v":"NA"},{"$f":"IF(CW3=$AD$1,CX3,IF(CY3=$AD$1,CZ3,IF(DA3=$AD$1,DB3,IF(DC3=$AD$1,DD3,IF(DE3=$AD$1,DF3,\"NA\")))))","v":"NA"},{"$f":"IF(BY3=$AH$1,BZ3,IF(CB3=$AH$1,CC3,IF(CE3=$AH$1,CF3,IF(CH3=$AH$1,CI3,\"NA\"))))","v":"NA"},{"$f":"IF(EA3=\"N\",\"V\",IF(EA3=\"Y\",\"SI\",IF(EA3=\"I\",EA3,\"NA\")))","v":"NA"},{"$f":"IF(CL3=$AH$1,CM3,IF(CN3=$AH$1,CO3,IF(CP3=$AH$1,CQ3,IF(CR3=$AH$1,CS3,IF(CT3=$AH$1,CU3,\"NA\")))))","v":"NA"},{"$f":"IF(CW3=$AH$1,CX3,IF(CY3=$AH$1,CZ3,IF(DA3=$AH$1,DB3,IF(DC3=$AH$1,DD3,IF(DE3=$AH$1,DF3,\"NA\")))))","v":"NA"},{"$f":"IF(BY3=$AL$1,BZ3,IF(CB3=$AL$1,CC3,IF(CE3=$AL$1,CF3,IF(CH3=$AL$1,CI3,\"NA\"))))","v":"NA"},{"$f":"IF(EB3=\"N\",\"V\",IF(EB3=\"Y\",\"SI\",IF(EB3=\"I\",EB3,\"NA\")))","v":"NA"},{"$f":"IF(CL3=$AL$1,CM3,IF(CN3=$AL$1,CO3,IF(CP3=$AL$1,CQ3,IF(CR3=$AL$1,CS3,IF(CT3=$AL$1,CU3,\"NA\")))))","v":"NA"},{"$f":"IF(CW3=$AL$1,CX3,IF(CY3=$AL$1,CZ3,IF(DA3=$AL$1,DB3,IF(DC3=$AL$1,DD3,IF(DE3=$AL$1,DF3,\"NA\")))))","v":"NA"},{"$f":"IF(BY3=$AP$1,BZ3,IF(CB3=$AP$1,CC3,IF(CE3=$AP$1,CF3,IF(CH3=$AP$1,CI3,\"NA\"))))","v":"NA"},{"$f":"IF(EC3=\"N\",\"V\",IF(EC3=\"Y\",\"SI\",IF(EC3=\"I\",EC3,\"NA\")))","v":"NA"},{"$f":"IF(CL3=$AP$1,CM3,IF(CN3=$AP$1,CO3,IF(CP3=$AP$1,CQ3,IF(CR3=$AP$1,CS3,IF(CT3=$AP$1,CU3,\"NA\")))))","v":"NA"},{"$f":"IF(CW3=$AP$1,CX3,IF(CY3=$AP$1,CZ3,IF(DA3=$AP$1,DB3,IF(DC3=$AP$1,DD3,IF(DE3=$AP$1,DF3,\"NA\")))))","v":"NA"},{"$f":"IF(BY3=$AT$1,BZ3,IF(CB3=$AT$1,CC3,IF(CE3=$AT$1,CF3,IF(CH3=$AT$1,CI3,\"NA\"))))","v":"NA"},{"$f":"IF(ED3=\"N\",\"V\",IF(ED3=\"Y\",\"SI\",IF(ED3=\"I\",ED3,\"NA\")))","v":"NA"},{"$f":"IF(CL3=$AT$1,CM3,IF(CN3=$AT$1,CO3,IF(CP3=$AT$1,CQ3,IF(CR3=$AT$1,CS3,IF(CT3=$AT$1,CU3,\"NA\")))))","v":"NA"},{"$f":"IF(CW3=$AT$1,CX3,IF(CY3=$AT$1,CZ3,IF(DA3=$AT$1,DB3,IF(DC3=$AT$1,DD3,IF(DE3=$AT$1,DF3,\"NA\")))))","v":"NA"},{"$f":"CK3","v":0},{"$f":"CV3","v":0},{"$f":"DG3","v":0},{"$f":"IF(DH3=\"\",\"NA\",DH3)","v":"NA"},{"$f":"IF(DI3=\"\",\"NA\",DI3)","v":"NA"},{"$f":"DJ3","v":0},{"$f":"IF(DK3=\"\",\"None\",DK3)","v":"None"},{"$f":"IF(OR(BC3=\"Y\",EI3=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(EH3=0,\"NA\",EH3+EE3)","v":"NA"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(CW3=\"P\",CW3=\"I\",CW3=\"I1\",CW3=\"I2\",CW3=\"S/C\",CW3=\"S/C1\",CW3=\"S/C2\"),1,0)","v":0},null,{"$f":"IF(OR(CY3=\"P\",CY3=\"I\",CY3=\"I1\",CY3=\"I2\",CY3=\"S/C\",CY3=\"S/C1\",CY3=\"S/C2\"),1,0)","v":0},null,{"$f":"IF(OR(DA3=\"P\",DA3=\"I\",DA3=\"I1\",DA3=\"I2\",DA3=\"S/C\",DA3=\"S/C1\",DA3=\"S/C2\"),1,0)","v":0},null,{"$f":"IF(OR(DC3=\"P\",DC3=\"I\",DC3=\"I1\",DC3=\"I2\",DC3=\"S/C\",DC3=\"S/C1\",DC3=\"S/C2\"),1,0)","v":0},null,{"$f":"IF(OR(DE3=\"P\",DE3=\"I\",DE3=\"I1\",DE3=\"I2\",DE3=\"S/C\",DE3=\"S/C1\",DE3=\"S/C2\"),1,0)","v":0},{"$f":"SUM(DO3:DW3)","v":0},{"$f":"IF($DY$2=BY3,CA3,IF($DY$2=CB3,CD3,IF($DY$2=CE3,CG3,IF($DY$2=CH3,CJ3,\"NA\"))))","v":"NA"},{"$f":"IF($DZ$2=BY3,CA3,IF($DZ$2=CB3,CD3,IF($DZ$2=CE3,CG3,IF($DZ$2=CH3,CJ3,\"NA\"))))","v":"NA"},{"$f":"IF($EA$2=BY3,CA3,IF($EA$2=CB3,CD3,IF($EA$2=CE3,CG3,IF($EA$2=CH3,CJ3,\"NA\"))))","v":"NA"},{"$f":"IF($EB$2=BY3,CA3,IF($EB$2=CB3,CD3,IF($EB$2=CE3,CG3,IF($EB$2=CH3,CJ3,\"NA\"))))","v":"NA"},{"$f":"IF($EC$2=BY3,CA3,IF($EC$2=CB3,CD3,IF($EC$2=CE3,CG3,IF($EC$2=CH3,CJ3,\"NA\"))))","v":"NA"},{"$f":"IF($ED$2=BY3,CA3,IF($ED$2=CB3,CD3,IF($ED$2=CE3,CG3,IF($ED$2=CH3,CJ3,\"NA\"))))","v":"NA"},{"$f":"IF(I3=\"NA\",0,I3*80%*0.433)","v":0},{"$f":"IF(EE3=0,0,K3)","v":0},{"$f":"IF(L3=\"NA\",0,IF(EE3=0,0,L3))","v":0},{"$f":"IF(AND(EF3>0,EG3>0),EG3-EE3,EF3-EE3)","v":0},{"$f":"IF(OR(EH3=0,EH3<0),\"N\",\"Y\")","v":"N"}]
[{"$f":"$A$3","v":0},{"$f":"BH4","v":0},{"$f":"BI4","v":0},{"$f":"IF(BJ4=\"\",\"NA\",IF(AND(BM4=\"\",BQ4=\"\",BR4=\"\",BP4>0),\"Y\",\"NA\"))","v":"NA"},{"$f":"IF(AND(BJ4>0,BM4=0),\"Y\",\"N\")","v":"N"},"N",{"$f":"IF(AND(F4=\"Y\",BJ4>0),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B4>0,DX4=0),\"No well record\",DX4)","v":0},{"$f":"IF(BJ4=\"\",\"NA\",BJ4)","v":"NA"},{"$f":"BK4","v":"00:00:00"},{"$f":"IF(BL4=\"\",\"NA\",BL4)","v":"NA"},{"$f":"IF(BM4=\"\",\"NA\",BM4)","v":"NA"},{"$f":"IF(BN4=\"\",\"NA\",BN4)","v":"NA"},{"$f":"IF(BO4=\"\",\"NA\",BO4)","v":"NA"},{"$f":"IF(BP4=\"\",\"NA\",BP4)","v":"NA"},{"$f":"IF(BQ4=\"\",\"NA\",BQ4)","v":"NA"},{"$f":"IF(BR4=\"\",\"NA\",BR4)","v":"NA"},{"$f":"IF(BM4>0,\"NA\",IF(AND(BT4=\"\",BU4=\"\"),\"I\",IF(BT4=\"\",\"SI\",\"V\")))","v":"I"},{"$f":"IF(R4=\"V\",BT4,\"NA\")","v":"NA"},{"$f":"IF(R4=\"SI\",BU4,\"NA\")","v":"NA"},{"$f":"IF(BV4=\"\",\"NA\",BV4)","v":"NA"},{"$f":"IF(BW4=\"\",\"NA\",BW4)","v":"NA"},{"$f":"IF(BX4=\"\",\"NA\",BX4)","v":"NA"},{"$f":"IF(CL4=$X$1,CM4,IF(CN4=$X$1,CO4,IF(CP4=$X$1,CQ4,IF(CR4=$X$1,CS4,IF(CT4=$X$1,CU4,\"NA\")))))","v":"NA"},{"$f":"IF(CW4=$X$1,CX4,IF(CY4=$X$1,CZ4,IF(DA4=$X$1,DB4,IF(DC4=$X$1,DD4,IF(DE4=$X$1,DF4,\"NA\")))))","v":"NA"},{"$f":"IF(BY4=$Z$1,BZ4,IF(CB4=$Z$1,CC4,IF(CE4=$Z$1,CF4,IF(CH4=$Z$1,CI4,\"NA\"))))","v":"NA"},{"$f":"IF(DY4=\"N\",\"V\",IF(DY4=\"Y\",\"SI\",IF(DY4=\"I\",DY4,\"NA\")))","v":"NA"},{"$f":"IF(CL4=$Z$1,CM4,IF(CN4=$Z$1,CO4,IF(CP4=$Z$1,CQ4,IF(CR4=$Z$1,CS4,IF(CT4=$Z$1,CU4,\"NA\")))))","v":"NA"},{"$f":"IF(CW4=$Z$1,CX4,IF(CY4=$Z$1,CZ4,IF(DA4=$Z$1,DB4,IF(DC4=$Z$1,DD4,IF(DE4=$Z$1,DF4,\"NA\")))))","v":"NA"},{"$f":"IF(BY4=$AD$1,BZ4,IF(CB4=$AD$1,CC4,IF(CE4=$AD$1,CF4,IF(CH4=$AD$1,CI4,\"NA\"))))","v":"NA"},{"$f":"IF(DZ4=\"N\",\"V\",IF(DZ4=\"Y\",\"SI\",IF(DZ4=\"I\",DZ4,\"NA\")))","v":"NA"},{"$f":"IF(CL4=$AD$1,CM4,IF(CN4=$AD$1,CO4,IF(CP4=$AD$1,CQ4,IF(CR4=$AD$1,CS4,IF(CT4=$AD$1,CU4,\"NA\")))))","v":"NA"},{"$f":"IF(CW4=$AD$1,CX4,IF(CY4=$AD$1,CZ4,IF(DA4=$AD$1,DB4,IF(DC4=$AD$1,DD4,IF(DE4=$AD$1,DF4,\"NA\")))))","v":"NA"},{"$f":"IF(BY4=$AH$1,BZ4,IF(CB4=$AH$1,CC4,IF(CE4=$AH$1,CF4,IF(CH4=$AH$1,CI4,\"NA\"))))","v":"NA"},{"$f":"IF(EA4=\"N\",\"V\",IF(EA4=\"Y\",\"SI\",IF(EA4=\"I\",EA4,\"NA\")))","v":"NA"},{"$f":"IF(CL4=$AH$1,CM4,IF(CN4=$AH$1,CO4,IF(CP4=$AH$1,CQ4,IF(CR4=$AH$1,CS4,IF(CT4=$AH$1,CU4,\"NA\")))))","v":"NA"},{"$f":"IF(CW4=$AH$1,CX4,IF(CY4=$AH$1,CZ4,IF(DA4=$AH$1,DB4,IF(DC4=$AH$1,DD4,IF(DE4=$AH$1,DF4,\"NA\")))))","v":"NA"},{"$f":"IF(BY4=$AL$1,BZ4,IF(CB4=$AL$1,CC4,IF(CE4=$AL$1,CF4,IF(CH4=$AL$1,CI4,\"NA\"))))","v":"NA"},{"$f":"IF(EB4=\"N\",\"V\",IF(EB4=\"Y\",\"SI\",IF(EB4=\"I\",EB4,\"NA\")))","v":"NA"},{"$f":"IF(CL4=$AL$1,CM4,IF(CN4=$AL$1,CO4,IF(CP4=$AL$1,CQ4,IF(CR4=$AL$1,CS4,IF(CT4=$AL$1,CU4,\"NA\")))))","v":"NA"},{"$f":"IF(CW4=$AL$1,CX4,IF(CY4=$AL$1,CZ4,IF(DA4=$AL$1,DB4,IF(DC4=$AL$1,DD4,IF(DE4=$AL$1,DF4,\"NA\")))))","v":"NA"},{"$f":"IF(BY4=$AP$1,BZ4,IF(CB4=$AP$1,CC4,IF(CE4=$AP$1,CF4,IF(CH4=$AP$1,CI4,\"NA\"))))","v":"NA"},{"$f":"IF(EC4=\"N\",\"V\",IF(EC4=\"Y\",\"SI\",IF(EC4=\"I\",EC4,\"NA\")))","v":"NA"},{"$f":"IF(CL4=$AP$1,CM4,IF(CN4=$AP$1,CO4,IF(CP4=$AP$1,CQ4,IF(CR4=$AP$1,CS4,IF(CT4=$AP$1,CU4,\"NA\")))))","v":"NA"},{"$f":"IF(CW4=$AP$1,CX4,IF(CY4=$AP$1,CZ4,IF(DA4=$AP$1,DB4,IF(DC4=$AP$1,DD4,IF(DE4=$AP$1,DF4,\"NA\")))))","v":"NA"},{"$f":"IF(BY4=$AT$1,BZ4,IF(CB4=$AT$1,CC4,IF(CE4=$AT$1,CF4,IF(CH4=$AT$1,CI4,\"NA\"))))","v":"NA"},{"$f":"IF(ED4=\"N\",\"V\",IF(ED4=\"Y\",\"SI\",IF(ED4=\"I\",ED4,\"NA\")))","v":"NA"},{"$f":"IF(CL4=$AT$1,CM4,IF(CN4=$AT$1,CO4,IF(CP4=$AT$1,CQ4,IF(CR4=$AT$1,CS4,IF(CT4=$AT$1,CU4,\"NA\")))))","v":"NA"},{"$f":"IF(CW4=$AT$1,CX4,IF(CY4=$AT$1,CZ4,IF(DA4=$AT$1,DB4,IF(DC4=$AT$1,DD4,IF(DE4=$AT$1,DF4,\"NA\")))))","v":"NA"},{"$f":"CK4","v":0},{"$f":"CV4","v":0},{"$f":"DG4","v":0},{"$f":"IF(DH4=\"\",\"NA\",DH4)","v":"NA"},{"$f":"IF(DI4=\"\",\"NA\",DI4)","v":"NA"},{"$f":"DJ4","v":0},{"$f":"IF(DK4=\"\",\"None\",DK4)","v":"None"},{"$f":"IF(OR(BC4=\"Y\",EI4=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(EH4=0,\"NA\",EH4+EE4)","v":"NA"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(CW4=\"P\",CW4=\"I\",CW4=\"I1\",CW4=\"I2\",CW4=\"S/C\",CW4=\"S/C1\",CW4=\"S/C2\"),1,0)","v":0},null,{"$f":"IF(OR(CY4=\"P\",CY4=\"I\",CY4=\"I1\",CY4=\"I2\",CY4=\"S/C\",CY4=\"S/C1\",CY4=\"S/C2\"),1,0)","v":0},null,{"$f":"IF(OR(DA4=\"P\",DA4=\"I\",DA4=\"I1\",DA4=\"I2\",DA4=\"S/C\",DA4=\"S/C1\",DA4=\"S/C2\"),1,0)","v":0},null,{"$f":"IF(OR(DC4=\"P\",DC4=\"I\",DC4=\"I1\",DC4=\"I2\",DC4=\"S/C\",DC4=\"S/C1\",DC4=\"S/C2\"),1,0)","v":0},null,{"$f":"IF(OR(DE4=\"P\",DE4=\"I\",DE4=\"I1\",DE4=\"I2\",DE4=\"S/C\",DE4=\"S/C1\",DE4=\"S/C2\"),1,0)","v":0},{"$f":"SUM(DO4:DW4)","v":0},{"$f":"IF($DY$2=BY4,CA4,IF($DY$2=CB4,CD4,IF($DY$2=CE4,CG4,IF($DY$2=CH4,CJ4,\"NA\"))))","v":"NA"},{"$f":"IF($DZ$2=BY4,CA4,IF($DZ$2=CB4,CD4,IF($DZ$2=CE4,CG4,IF($DZ$2=CH4,CJ4,\"NA\"))))","v":"NA"},{"$f":"IF($EA$2=BY4,CA4,IF($EA$2=CB4,CD4,IF($EA$2=CE4,CG4,IF($EA$2=CH4,CJ4,\"NA\"))))","v":"NA"},{"$f":"IF($EB$2=BY4,CA4,IF($EB$2=CB4,CD4,IF($EB$2=CE4,CG4,IF($EB$2=CH4,CJ4,\"NA\"))))","v":"NA"},{"$f":"IF($EC$2=BY4,CA4,IF($EC$2=CB4,CD4,IF($EC$2=CE4,CG4,IF($EC$2=CH4,CJ4,\"NA\"))))","v":"NA"},{"$f":"IF($ED$2=BY4,CA4,IF($ED$2=CB4,CD4,IF($ED$2=CE4,CG4,IF($ED$2=CH4,CJ4,\"NA\"))))","v":"NA"},{"$f":"IF(I4=\"NA\",0,I4*80%*0.433)","v":0},{"$f":"IF(EE4=0,0,K4)","v":0},{"$f":"IF(L4=\"NA\",0,IF(EE4=0,0,L4))","v":0},{"$f":"IF(AND(EF4>0,EG4>0),EG4-EE4,EF4-EE4)","v":0},{"$f":"IF(OR(EH4=0,EH4<0),\"N\",\"Y\")","v":"N"}]
[{"$f":"$A$3","v":0},0,0,"NA","N","N","N",0,"NA","00:00:00","NA","NA","NA","NA","NA","NA","NA","I","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA",0,0,0,"NA","NA",0,"None","N","NA",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,0,"NA","NA","NA","NA","NA","NA",0,0,0,0,"N"]
[0,0,0,"NA","N","N","N",0,"NA","00:00:00","NA","NA","NA","NA","NA","NA","NA","I","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA",0,0,0,"NA","NA",0,"None","N","NA",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,0,"NA","NA","NA","NA","NA","NA",0,0,0,0,"N"]

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