{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["notes","Options","Calcs","PSA4BG_24","PSA4BG_36","PSA4BG_48","PSA4BG_60","Form","Instructions","Prompt","Sheet1"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":7,"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":"notes","index":0,"n_rows":65,"n_cols":16,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H3:H8)","v":0}]
[null,null,600,24,600,1000,{"$f":"IF(Form!$D$4=D3,1,0)","v":0},{"$f":"IF(G3=1,IF(OR(E3>Form!M$5,F3<Form!M$5),1,0),0)","v":0}]
[null,null,800,30,800,1200,{"$f":"IF(Form!$D$4=D4,1,0)","v":0},{"$f":"IF(G4=1,IF(OR(E4>Form!M$5,F4<Form!M$5),1,0),0)","v":0}]
[null,null,1000,36,1000,1400,{"$f":"IF(Form!$D$4=D5,1,0)","v":0},{"$f":"IF(G5=1,IF(OR(E5>Form!M$5,F5<Form!M$5),1,0),0)","v":0}]
[null,null,1200,42,1200,1600,{"$f":"IF(Form!$D$4=D6,1,0)","v":0},{"$f":"IF(G6=1,IF(OR(E6>Form!M$5,F6<Form!M$5),1,0),0)","v":0}]
[null,null,1400,48,1400,1800,{"$f":"IF(Form!$D$4=D7,1,0)","v":0},{"$f":"IF(G7=1,IF(OR(E7>Form!M$5,F7<Form!M$5),1,0),0)","v":0}]
[null,null,1600,60,1600,2000,{"$f":"IF(Form!$D$4=D8,1,0)","v":0},{"$f":"IF(G8=1,IF(OR(E8>Form!M$5,F8<Form!M$5),1,0),0)","v":0}]
[null,null,1800]
[null,null,2000]
[]
[]
[null,null,null,"Total"]
[null,{"$f":"Form!M5+Form!M6","v":0},null,null,{"$f":"E31","v":0},{"$f":"F31","v":0},0,0,0,0,0,{"$f":"SUM(E14:K14)","v":0},null,null,null,58]
[null,null,null,null,{"$f":"Form!C27","v":65},{"$f":"Form!E27","v":75},{"$f":"Form!G27","v":85},{"$f":"Form!I27","v":95},{"$f":"Form!K27","v":100},{"$f":"Form!M27","v":105},{"$f":"Form!O27","v":115}]
[{"$f":"C16+D16","v":0},{"$f":"P16","v":0},{"$f":"Form!A31","v":0},{"$f":"Form!B31","v":0},{"$f":"Form!C31","v":0},{"$f":"Form!E31","v":0},{"$f":"Form!G31","v":0},{"$f":"Form!I31","v":0},{"$f":"Form!K31","v":0},{"$f":"Form!M31","v":0},{"$f":"Form!O31","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C16+D16=Form!M$5+Form!M$6,1,0)","v":1},{"$f":"IF(A16<L16,1,0)","v":0},{"$f":"IF(A16>L16,2,0)","v":0},{"$f":"IF(AND(N16=1,N17=0),1,0)+IF(AND(O15=0,O16=2),2,0)","v":0}]
[{"$f":"C17+D17","v":0},{"$f":"P17","v":0},{"$f":"C16","v":0},{"$f":"Form!B32","v":0},{"$f":"Form!C32","v":0},{"$f":"Form!E32","v":0},{"$f":"Form!G32","v":0},{"$f":"Form!I32","v":0},{"$f":"Form!K32","v":0},{"$f":"Form!M32","v":0},{"$f":"Form!O32","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C17+D17=Form!M$5+Form!M$6,1,0)","v":1},{"$f":"IF(A17<L17,1,0)","v":0},{"$f":"IF(A17>L17,2,0)","v":0},{"$f":"IF(AND(N17=1,N18=0),1,0)+IF(AND(O16=0,O17=2),2,0)","v":0}]
[0,0,{"$f":"C17","v":0},{"$f":"Form!B33","v":0},{"$f":"Form!C33","v":0},{"$f":"Form!E33","v":0},{"$f":"Form!G33","v":0},{"$f":"Form!I33","v":0},{"$f":"Form!K33","v":0},{"$f":"Form!M33","v":0},{"$f":"Form!O33","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C18+D18=Form!M$5+Form!M$6,1,0)","v":1},0,{"$f":"IF(A18>L18,2,0)","v":0},{"$f":"IF(AND(N18=1,N19=0),1,0)+IF(AND(O17=0,O18=2),2,0)","v":0}]
[0,0,{"$f":"C18","v":0},{"$f":"Form!B34","v":0},{"$f":"Form!C34","v":0},{"$f":"Form!E34","v":0},{"$f":"Form!G34","v":0},{"$f":"Form!I34","v":0},{"$f":"Form!K34","v":0},{"$f":"Form!M34","v":0},{"$f":"Form!O34","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C19+D19=Form!M$5+Form!M$6,1,0)","v":1},0,{"$f":"IF(A19>L19,2,0)","v":0},{"$f":"IF(AND(N19=1,N20=0),1,0)+IF(AND(O18=0,O19=2),2,0)","v":0}]
[0,0,{"$f":"Form!A35","v":0},{"$f":"Form!B35","v":0},{"$f":"Form!C35","v":0},{"$f":"Form!E35","v":0},{"$f":"Form!G35","v":0},{"$f":"Form!I35","v":0},{"$f":"Form!K35","v":0},{"$f":"Form!M35","v":0},{"$f":"Form!O35","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C20+D20=Form!M$5+Form!M$6,1,0)","v":1},0,{"$f":"IF(A20>L20,2,0)","v":0},{"$f":"IF(AND(N20=1,N21=0),1,0)+IF(AND(O19=0,O20=2),2,0)","v":0}]
[0,0,{"$f":"C20","v":0},{"$f":"Form!B36","v":0},{"$f":"Form!C36","v":0},{"$f":"Form!E36","v":0},{"$f":"Form!G36","v":0},{"$f":"Form!I36","v":0},{"$f":"Form!K36","v":0},{"$f":"Form!M36","v":0},{"$f":"Form!O36","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C21+D21=Form!M$5+Form!M$6,1,0)","v":1},0,{"$f":"IF(A21>L21,2,0)","v":0},{"$f":"IF(AND(N21=1,N22=0),1,0)+IF(AND(O20=0,O21=2),2,0)","v":0}]
[0,0,{"$f":"C21","v":0},{"$f":"Form!B37","v":0},{"$f":"Form!C37","v":0},{"$f":"Form!E37","v":0},{"$f":"Form!G37","v":0},{"$f":"Form!I37","v":0},{"$f":"Form!K37","v":0},{"$f":"Form!M37","v":0},{"$f":"Form!O37","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C22+D22=Form!M$5+Form!M$6,1,0)","v":1},0,0,0]
[0,0,{"$f":"C22","v":0},{"$f":"Form!B38","v":0},{"$f":"Form!C38","v":0},{"$f":"Form!E38","v":0},{"$f":"Form!G38","v":0},{"$f":"Form!I38","v":0},{"$f":"Form!K38","v":0},{"$f":"Form!M38","v":0},{"$f":"Form!O38","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C23+D23=Form!M$5+Form!M$6,1,0)","v":1},0,0,0]
[0,0,{"$f":"Form!A39","v":0},{"$f":"Form!B39","v":0},{"$f":"Form!C39","v":0},{"$f":"Form!E39","v":0},{"$f":"Form!G39","v":0},{"$f":"Form!I39","v":0},{"$f":"Form!K39","v":0},{"$f":"Form!M39","v":0},{"$f":"Form!O39","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C24+D24=Form!M$5+Form!M$6,1,0)","v":1},0,0,0]
[0,0,{"$f":"C24","v":0},{"$f":"Form!B40","v":0},{"$f":"Form!C40","v":0},{"$f":"Form!E40","v":0},{"$f":"Form!G40","v":0},{"$f":"Form!I40","v":0},{"$f":"Form!K40","v":0},{"$f":"Form!M40","v":0},{"$f":"Form!O40","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C25+D25=Form!M$5+Form!M$6,1,0)","v":1},0,0,0]
[0,0,{"$f":"C25","v":0},{"$f":"Form!B41","v":0},{"$f":"Form!C41","v":0},{"$f":"Form!E41","v":0},{"$f":"Form!G41","v":0},{"$f":"Form!I41","v":0},{"$f":"Form!K41","v":0},{"$f":"Form!M41","v":0},{"$f":"Form!O41","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C26+D26=Form!M$5+Form!M$6,1,0)","v":1},0,0,0]
[0,0,{"$f":"C26","v":0},{"$f":"Form!B42","v":0},{"$f":"Form!C42","v":0},{"$f":"Form!E42","v":0},{"$f":"Form!G42","v":0},{"$f":"Form!I42","v":0},{"$f":"Form!K42","v":0},{"$f":"Form!M42","v":0},{"$f":"Form!O42","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C27+D27=Form!M$5+Form!M$6,1,0)","v":1},0,0,0]
[0,{"$f":"SUM(B16:B27)","v":0}]
[null,null,null,null,null,{"$f":"IF(AND(F15>Form!$M$4,E15<Form!$M$4),2,0)","v":0},{"$f":"IF(AND(G15>Form!$M$4,F15<Form!$M$4),2,0)","v":0},{"$f":"IF(AND(H15>Form!$M$4,G15<Form!$M$4),2,0)","v":0},{"$f":"IF(AND(I15>Form!$M$4,H15<Form!$M$4),2,0)","v":0},{"$f":"IF(AND(J15>Form!$M$4,I15<Form!$M$4),2,0)","v":0},{"$f":"IF(AND(K15>Form!$M$4,J15<Form!$M$4),2,0)","v":0}]
[null,null,{"$f":"HLOOKUP(1,E14:K15,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(F29=2,1,0)","v":0},{"$f":"IF(G29=2,1,0)","v":0},0,0,0,0,0]
[null,null,{"$f":"HLOOKUP(2,E14:K15,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"SUM(E29:E30)","v":0},0,0,0,0,0,0]
[null,{"$f":"(VLOOKUP(1,B14:K27,3,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(B32),0,B32)","v":0},null,{"$f":"(C34-C35)/(C32-C33)*(Form!$M$6-C33)+C35","v":{"$error":"#N/A"}},{"$f":"(C36-C37)/(C32-C33)*(Form!M6-C33)+C37","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(2,B14:K27,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(B33),0,B33)","v":0},null,{"$f":"IF(AND(B28=0,L14=3),VLOOKUP(Form!$M$5+Form!$M$6,notes!A14:K27,MATCH(1,notes!A14:K14,FALSE),FALSE),0)","v":0},{"$f":"IF(AND(B28=0,L14=3),VLOOKUP(Form!$M$5+Form!$M$6,notes!A14:K27,MATCH(2,notes!A14:K14,FALSE),FALSE),0)","v":0},null,null,"exactly"]
[null,{"$f":"VLOOKUP(1,B14:K27,MATCH(1,B14:K14,FALSE),FALSE)","v":{"$error":"#N/A"}},{"$f":"MIN(B34,B36)","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(E32),E33,E32)","v":0},{"$f":"IF(ISERROR(F32),F33,F32)","v":0},null,null,"x","y","err1","err2","err3","ans"]
[null,{"$f":"VLOOKUP(2,B14:K27,MATCH(1,B14:K14,FALSE),FALSE)","v":{"$error":"#N/A"}},{"$f":"MAX(B35,B37)","v":{"$error":"#N/A"}},null,{"$f":"MIN(E34:F34)","v":0},{"$f":"MAX(E34:F34)","v":0},null,null,"y","y",{"$f":"IF(ISERROR(VLOOKUP(Form!$M$5+Form!$M$6,notes!A15:K27,MATCH(Form!$M$4,notes!A15:K15,FALSE),FALSE)),0,VLOOKUP(Form!$M$5+Form!$M$6,notes!A15:K27,MATCH(Form!$M$4,notes!A15:K15,FALSE),FALSE))","v":0},null,null,{"$f":"SUM(K35:M35)","v":0}]
[null,{"$f":"VLOOKUP(1,B14:K27,MATCH(2,B14:K14,FALSE),FALSE)","v":{"$error":"#N/A"}},{"$f":"MAX(B36,B34)","v":{"$error":"#N/A"}},null,{"$f":"(E35-F35)/(C31-C30)*(Form!$M$4-C30)+F35","v":{"$error":"#N/A"}},null,null,null,"y","n",null,null,null,{"$f":"SUM(K36:M36)","v":0}]
[null,{"$f":"VLOOKUP(2,B14:K27,MATCH(2,B14:K14,FALSE),FALSE)","v":{"$error":"#N/A"}},{"$f":"MIN(B35,B37)","v":{"$error":"#N/A"}},null,null,null,null,null,"n","n",{"$f":"IF(OR(E36>100000,E36<=0),0,E36)","v":{"$error":"#N/A"}},{"$f":"IF(K37<>0,0,MIN(E32:F32))","v":{"$error":"#N/A"}},{"$f":"IF(AND(L37=0,K37=0),C34,0)","v":{"$error":"#N/A"}},{"$f":"SUM(K37:M37)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(N37),N35,N37)","v":0}]
[]
[]
["sens",null,null,null,{"$f":"E58","v":0},{"$f":"F58","v":0},0,0,0,0,0,{"$f":"SUM(E41:K41)","v":0}]
[null,null,null,null,{"$f":"E15","v":65},{"$f":"F15","v":75},85,95,100,105,115]
[{"$f":"C43+D43","v":0},{"$f":"P43","v":0},{"$f":"C16","v":0},{"$f":"D16","v":0},{"$f":"Form!D31","v":0},{"$f":"Form!F31","v":0},{"$f":"Form!H31","v":0},{"$f":"Form!J31","v":0},{"$f":"Form!L31","v":0},{"$f":"Form!N31","v":0},{"$f":"Form!P31","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C43+D43=Form!M$5+Form!M$6,1,0)","v":1},{"$f":"IF(A43<L43,1,0)","v":0},{"$f":"IF(A43>L43,2,0)","v":0},{"$f":"IF(AND(N43=1,N44=0),1,0)+IF(AND(O42=0,O43=2),2,0)","v":0}]
[{"$f":"C44+D44","v":0},{"$f":"P44","v":0},{"$f":"C17","v":0},{"$f":"D17","v":0},{"$f":"Form!D32","v":0},{"$f":"Form!F32","v":0},{"$f":"Form!H32","v":0},{"$f":"Form!J32","v":0},{"$f":"Form!L32","v":0},{"$f":"Form!N32","v":0},{"$f":"Form!P32","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C44+D44=Form!M$5+Form!M$6,1,0)","v":1},{"$f":"IF(A44<L44,1,0)","v":0},{"$f":"IF(A44>L44,2,0)","v":0},{"$f":"IF(AND(N44=1,N45=0),1,0)+IF(AND(O43=0,O44=2),2,0)","v":0}]
[{"$f":"C45+D45","v":0},0,0,0,{"$f":"Form!D33","v":0},{"$f":"Form!F33","v":0},{"$f":"Form!H33","v":0},{"$f":"Form!J33","v":0},{"$f":"Form!L33","v":0},{"$f":"Form!N33","v":0},{"$f":"Form!P33","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C45+D45=Form!M$5+Form!M$6,1,0)","v":1},0,{"$f":"IF(A45>L45,2,0)","v":0},{"$f":"IF(AND(N45=1,N46=0),1,0)+IF(AND(O44=0,O45=2),2,0)","v":0}]
[0,0,0,0,{"$f":"Form!D34","v":0},{"$f":"Form!F34","v":0},{"$f":"Form!H34","v":0},{"$f":"Form!J34","v":0},{"$f":"Form!L34","v":0},{"$f":"Form!N34","v":0},{"$f":"Form!P34","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C46+D46=Form!M$5+Form!M$6,1,0)","v":1},0,{"$f":"IF(A46>L46,2,0)","v":0},{"$f":"IF(AND(N46=1,N47=0),1,0)+IF(AND(O45=0,O46=2),2,0)","v":0}]
[0,0,0,0,{"$f":"Form!D35","v":0},{"$f":"Form!F35","v":0},{"$f":"Form!H35","v":0},{"$f":"Form!J35","v":0},{"$f":"Form!L35","v":0},{"$f":"Form!N35","v":0},{"$f":"Form!P35","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C47+D47=Form!M$5+Form!M$6,1,0)","v":1},0,{"$f":"IF(A47>L47,2,0)","v":0},{"$f":"IF(AND(N47=1,N48=0),1,0)+IF(AND(O46=0,O47=2),2,0)","v":0}]
[0,0,0,0,{"$f":"Form!D36","v":0},{"$f":"Form!F36","v":0},{"$f":"Form!H36","v":0},{"$f":"Form!J36","v":0},{"$f":"Form!L36","v":0},{"$f":"Form!N36","v":0},{"$f":"Form!P36","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C48+D48=Form!M$5+Form!M$6,1,0)","v":1},0,{"$f":"IF(A48>L48,2,0)","v":0},{"$f":"IF(AND(N48=1,N49=0),1,0)+IF(AND(O47=0,O48=2),2,0)","v":0}]
[0,0,0,0,{"$f":"Form!D37","v":0},{"$f":"Form!F37","v":0},{"$f":"Form!H37","v":0},{"$f":"Form!J37","v":0},{"$f":"Form!L37","v":0},{"$f":"Form!N37","v":0},{"$f":"Form!P37","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C49+D49=Form!M$5+Form!M$6,1,0)","v":1},0,0,0]
[0,0,0,0,{"$f":"Form!D38","v":0},{"$f":"Form!F38","v":0},{"$f":"Form!H38","v":0},{"$f":"Form!J38","v":0},{"$f":"Form!L38","v":0},{"$f":"Form!N38","v":0},{"$f":"Form!P38","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C50+D50=Form!M$5+Form!M$6,1,0)","v":1},0,0,0]
[0,0,0,0,{"$f":"Form!D39","v":0},{"$f":"Form!F39","v":0},{"$f":"Form!H39","v":0},{"$f":"Form!J39","v":0},{"$f":"Form!L39","v":0},{"$f":"Form!N39","v":0},{"$f":"Form!P39","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C51+D51=Form!M$5+Form!M$6,1,0)","v":1},0,0,0]
[0,0,0,0,{"$f":"Form!D40","v":0},{"$f":"Form!F40","v":0},{"$f":"Form!H40","v":0},{"$f":"Form!J40","v":0},{"$f":"Form!L40","v":0},{"$f":"Form!N40","v":0},{"$f":"Form!P40","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C52+D52=Form!M$5+Form!M$6,1,0)","v":1},0,0,0]
[0,0,0,0,{"$f":"Form!D41","v":0},{"$f":"Form!F41","v":0},{"$f":"Form!H41","v":0},{"$f":"Form!J41","v":0},{"$f":"Form!L41","v":0},{"$f":"Form!N41","v":0},{"$f":"Form!P41","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C53+D53=Form!M$5+Form!M$6,1,0)","v":1},0,0,0]
[0,0,0,0,{"$f":"Form!D42","v":0},{"$f":"Form!F42","v":0},{"$f":"Form!H42","v":0},{"$f":"Form!J42","v":0},{"$f":"Form!L42","v":0},{"$f":"Form!N42","v":0},{"$f":"Form!P42","v":0},{"$f":"Form!$M$5+Form!M$6","v":0},{"$f":"IF(C54+D54=Form!M$5+Form!M$6,1,0)","v":1},0,0,0]
[0,{"$f":"SUM(B43:B54)","v":0}]
[null,null,null,null,null,{"$f":"IF(AND(F42>Form!$M$4,E42<Form!$M$4),2,0)","v":0},{"$f":"IF(AND(G42>Form!$M$4,F42<Form!$M$4),2,0)","v":0},{"$f":"IF(AND(H42>Form!$M$4,G42<Form!$M$4),2,0)","v":0},{"$f":"IF(AND(I42>Form!$M$4,H42<Form!$M$4),2,0)","v":0},{"$f":"IF(AND(J42>Form!$M$4,I42<Form!$M$4),2,0)","v":0},{"$f":"IF(AND(K42>Form!$M$4,J42<Form!$M$4),2,0)","v":0}]
[null,null,{"$f":"HLOOKUP(1,E41:K42,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(F56=2,1,0)","v":0},{"$f":"IF(G56=2,1,0)","v":0},0,0,0,0,0]
[null,null,{"$f":"HLOOKUP(2,E41:K42,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"SUM(E56:E57)","v":0},0,0,0,0,0,0]
[null,{"$f":"(VLOOKUP(1,B41:K54,3,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(B59),0,B59)","v":0},null,{"$f":"(C61-C62)/(C59-C60)*(Form!$M$6-C60)+C62","v":{"$error":"#N/A"}},{"$f":"(C63-C64)/(C59-C60)*(Form!M6-C60)+C64","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(2,B41:K54,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(B60),0,B60)","v":0},null,{"$f":"IF(AND(B55=0,L41=3),VLOOKUP(Form!$M$5+Form!$M$6,notes!A41:K54,MATCH(1,notes!A41:K41,FALSE),FALSE),0)","v":0},{"$f":"IF(AND(B55=0,L41=3),VLOOKUP(Form!$M$5+Form!$M$6,notes!A41:K54,MATCH(2,notes!A41:K41,FALSE),FALSE),0)","v":0},null,null,"exactly"]
[null,{"$f":"VLOOKUP(1,B41:K54,MATCH(1,B41:K41,FALSE),FALSE)","v":{"$error":"#N/A"}},{"$f":"MIN(B61,B63)","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(E59),E60,E59)","v":0},{"$f":"IF(ISERROR(F59),F60,F59)","v":0},null,null,"x","y","err1","err2","err3","ans"]
[null,{"$f":"VLOOKUP(2,B41:K54,MATCH(1,B41:K41,FALSE),FALSE)","v":{"$error":"#N/A"}},{"$f":"MAX(B62,B64)","v":{"$error":"#N/A"}},null,{"$f":"MIN(E61:F61)","v":0},{"$f":"MAX(E61:F61)","v":0},null,null,"y","y",{"$f":"IF(ISERROR(VLOOKUP(Form!$M$5+Form!$M$6,notes!A42:K54,MATCH(Form!$M$4,notes!A42:K42,FALSE),FALSE)),0,VLOOKUP(Form!$M$5+Form!$M$6,notes!A42:K54,MATCH(Form!$M$4,notes!A42:K42,FALSE),FALSE))","v":0},null,null,{"$f":"SUM(K62:M62)","v":0}]
[null,{"$f":"VLOOKUP(1,B41:K54,MATCH(2,B41:K41,FALSE),FALSE)","v":{"$error":"#N/A"}},{"$f":"MAX(B63,B61)","v":{"$error":"#N/A"}},null,{"$f":"(E62-F62)/(C58-C57)*(Form!$M$4-C57)+F62","v":{"$error":"#N/A"}},null,null,null,"y","n",null,null,null,{"$f":"SUM(K63:M63)","v":0}]
[null,{"$f":"VLOOKUP(2,B41:K54,MATCH(2,B41:K41,FALSE),FALSE)","v":{"$error":"#N/A"}},{"$f":"MIN(B62,B64)","v":{"$error":"#N/A"}},null,null,null,null,null,"n","n",{"$f":"IF(OR(E63>100000,E63<=0),0,E63)","v":{"$error":"#N/A"}},{"$f":"IF(K64<>0,0,MIN(E59:F59))","v":{"$error":"#N/A"}},{"$f":"IF(AND(L64=0,K64=0),C61,0)","v":{"$error":"#N/A"}},{"$f":"SUM(K64:M64)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(Form!M32+Form!M33,A41:K54,MATCH(2,A41:K41,FALSE),FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(N64),N62,N64)","v":0}]

{"sheet":"Options","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["PSA4BG"]

{"sheet":"Calcs","index":2,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":true,"merged":[[0,4,0,9],[1,4,1,9]]}
[null,null,null,"Condenser :  "]
[null,null,null,"ADP Evaporator:  "]
[null,null,null,"Condenser Entering Air Temperature: ",100,"(°F) Dry Bulb, 85°F to 115°F"]
[null,null,null,"Evaporator Air Flow:",1265,"CFM"]
[null,null,null,"Entering Evaporator Air (DB):  ",77.5,"(°F) Dry Bulb"]
[null,null,null,"Entering Evaporator Air (WB):  ",60.6,"(°F) Wet Bulb, 63°F to 71°F"]
[]
[]
["Total"]
[28.549999999999997,"1200 60.6"]
[]
[null,"Diff 200",{"$f":"A10-A14","v":0.30799999999999983},"Diff 1 cfm",{"$f":"C12/200","v":1.5399999999999991E-3},"  1265 total",{"$f":"A10-(65*E12)","v":28.449899999999996}]
[]
[28.241999999999997,"1400 60.6"]
[]
["Sens"]
[25.319999999999997,"1200 60.6"]
[]
[null,"Diff 200",{"$f":"A17-A21","v":0.55439999999999756},"Diff 1 cfm",{"$f":"C19/200","v":2.771999999999988E-3},"  1265 Sens",{"$f":"A17-(65*E19)","v":25.139819999999997}]
[]
[24.765599999999999,"1400 60.6"]

{"sheet":"PSA4BG_24","index":3,"n_rows":19,"n_cols":45,"rows_kept":19,"cut":false,"hidden":true,"merged":[[2,0,2,1],[2,2,2,15],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[4,0,6,0],[4,1,6,1],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[5,15,6,15],[4,10,4,11],[4,12,4,13],[4,14,4,15],[7,0,10,0],[11,0,14,0],[15,0,18,0],[22,4,22,15],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[25,12,26,12],[25,13,26,13],[25,14,26,14],[25,15,26,15],[27,0,30,0],[31,0,34,0],[24,12,24,13],[24,14,24,15],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[25,8,26,8],[25,9,26,9],[25,10,26,10],[25,11,26,11],[24,0,26,0],[24,1,26,1],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[35,0,38,0],[41,0,42,1],[41,4,41,15],[42,4,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,11],[42,12,42,13],[42,14,42,15],[44,12,45,12],[44,13,45,13],[44,14,45,14],[44,15,45,15],[46,0,49,0],[50,0,53,0],[43,12,43,13],[43,14,43,15],[44,4,45,4],[44,5,45,5],[44,6,45,6],[44,7,45,7],[44,8,45,8],[44,9,45,9],[44,10,45,10],[44,11,45,11],[43,0,45,0],[43,1,45,1],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[54,0,57,0],[60,0,61,1],[60,4,60,15],[61,4,61,5],[61,6,61,7],[61,8,61,9],[61,10,61,11],[61,12,61,13],[61,14,61,15],[63,12,64,12],[63,13,64,13],[63,14,64,14],[63,15,64,15],[65,0,68,0],[69,0,72,0],[62,12,62,13],[62,14,62,15],[63,4,64,4],[63,5,64,5],[63,6,64,6],[63,7,64,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[63,11,64,11],[62,0,64,0],[62,1,64,1],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[73,0,76,0],[79,0,80,1],[79,4,79,15],[80,4,80,5],[80,6,80,7],[80,8,80,9],[80,10,80,11],[80,12,80,13],[80,14,80,15],[82,12,83,12],[82,13,83,13],[82,14,83,14],[82,15,83,15],[84,0,87,0],[88,0,91,0],[81,12,81,13],[81,14,81,15],[82,4,83,4],[82,5,83,5],[82,6,83,6],[82,7,83,7],[82,8,83,8],[82,9,83,9],[82,10,83,10],[82,11,83,11],[81,0,83,0],[81,1,83,1],[81,4,81,5],[81,6,81,7],[81,8,81,9],[81,10,81,11],[92,0,95,0],[98,0,99,1],[98,4,98,15],[99,4,99,5],[99,6,99,7],[99,8,99,9],[99,10,99,11],[99,12,99,13],[99,14,99,15],[101,12,102,12],[101,13,102,13],[101,14,102,14],[101,15,102,15],[103,0,106,0],[107,0,110,0],[100,12,100,13],[100,14,100,15],[101,4,102,4],[101,5,102,5],[101,6,102,6],[101,7,102,7],[101,8,102,8],[101,9,102,9],[101,10,102,10],[101,11,102,11],[100,0,102,0],[100,1,102,1],[100,4,100,5],[100,6,100,7],[100,8,100,9],[100,10,100,11],[111,0,114,0],[117,0,118,1],[117,4,117,15],[118,4,118,5],[118,6,118,7],[118,8,118,9],[118,10,118,11],[118,12,118,13],[118,14,118,15],[130,0,133,0],[120,12,121,12],[120,13,121,13],[120,14,121,14],[120,15,121,15],[122,0,125,0],[126,0,129,0],[119,12,119,13],[119,14,119,15],[120,4,121,4],[120,5,121,5],[120,6,121,6],[120,7,121,7],[120,8,121,8],[120,9,121,9],[120,10,121,10],[120,11,121,11],[119,0,121,0],[119,1,121,1],[119,4,119,5],[119,6,119,7],[119,8,119,9],[119,10,119,11]]}
[]
["PSA4BG_24"]
["Evaporator Air \n",null,"Condenser  Entering Air Temperature ˚F"]
[80,"°F DB",65,null,75,null,85,null,95,null,100,null,105,null,115]
["CFM","EWB†\n˚F","Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh"]
[null,null,"Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Factors",null,null,null,null,null,null,"Sens. %",null,null,null,null,null,null,"IDB Adj",null,null,null,null,null,null,"Sens Calc"]
[700,72,{"$f":"R8*$I$14","v":29.544100801832762},{"$f":"IF(AM8>C8,C8,AM8)","v":14.313860252004581},{"$f":"S8*$I$14","v":28.416953035509735},{"$f":"IF(AN8>E8,E8,AN8)","v":13.809851088201603},{"$f":"T8*$I$14","v":27.179839633447877},{"$f":"IF(AO8>G8,G8,AO8)","v":13.333333333333332},{"$f":"U8*$I$14","v":25.832760595647194},{"$f":"IF(AP8>I8,I8,AP8)","v":12.865979381443298},{"$f":"V8*$I$14","v":25.09049255441008},{"$f":"IF(AQ8>K8,K8,AQ8)","v":12.627720504009162},{"$f":"W8*$I$14","v":24.348224513172966},{"$f":"IF(AR8>M8,M8,AR8)","v":12.389461626575029},{"$f":"X8*$I$14","v":22.707903780068726},{"$f":"IF(AS8>O8,O8,AS8)","v":11.876288659793813},null,1.231004200076365,1.1840397098129056,1.1324933180603283,1.0763650248186332,1.0454371897670867,1.0145093547155402,0.94616265750286366,0.48449131513647636,0.48597226701064172,0.49055967633175995,0.49804895352962036,0.50328707085463831,0.50884456153556645,0.52300242130750607,0.94857142857142862,0.91428571428571415,0.91428571428571415,0.91714285714285737,0.89999999999999958,0.88285714285714278,0.76571428571428557,{"$f":"Y8*C8+($A$4-80)*AF8*$A$8/1000","v":14.313860252004581},{"$f":"Z8*E8+($A$4-80)*AG8*$A$8/1000","v":13.809851088201603},{"$f":"AA8*G8+($A$4-80)*AH8*$A$8/1000","v":13.333333333333332},{"$f":"AB8*I8+($A$4-80)*AI8*$A$8/1000","v":12.865979381443298},{"$f":"AC8*K8+($A$4-80)*AJ8*$A$8/1000","v":12.627720504009162},{"$f":"AD8*M8+($A$4-80)*AK8*$A$8/1000","v":12.389461626575029},{"$f":"AE8*O8+($A$4-80)*AL8*$A$8/1000","v":11.876288659793813}]
[null,69.5,28.160366552119129,15.894616265750285,27.097365406643753,15.404352806414661,25.846506300114545,14.877434135166093,24.485681557846505,14.34135166093929,23.786941580756015,14.093928980526917,23.088201603665521,13.846506300114548,21.722794959908359,13.429553264604811,null,1.173348606338297,1.1290568919434898,1.0769377625047727,1.0202367315769376,0.99112256586483394,0.96200840015273004,0.90511645666284835,0.56443215099251542,0.56848156915793036,0.57560716185073568,0.58570359281437134,0.59250698256765855,0.59972216709664616,0.61822400337481553,0.94857142857142862,0.91428571428571415,0.91428571428571415,0.91714285714285737,0.89999999999999958,0.88285714285714278,0.76571428571428557,{"$f":"Y9*C9+($A$4-80)*AF9*$A$8/1000","v":15.894616265750285},{"$f":"Z9*E9+($A$4-80)*AG9*$A$8/1000","v":15.404352806414661},{"$f":"AA9*G9+($A$4-80)*AH9*$A$8/1000","v":14.877434135166093},{"$f":"AB9*I9+($A$4-80)*AI9*$A$8/1000","v":14.34135166093929},{"$f":"AC9*K9+($A$4-80)*AJ9*$A$8/1000","v":14.093928980526917},{"$f":"AD9*M9+($A$4-80)*AK9*$A$8/1000","v":13.846506300114548},{"$f":"AE9*O9+($A$4-80)*AL9*$A$8/1000","v":13.429553264604811}]
[null,67,26.776632302405496,17.475372279495989,25.777777777777775,16.998854524627721,24.513172966781212,16.421534936998853,23.138602520045819,15.816723940435281,22.483390607101946,15.560137457044672,21.828178694158076,15.303550973654067,20.737686139747993,14.982817869415808,null,1.1156930126002289,1.074074074074074,1.0213822069492171,0.9641084383352424,0.9368079419625811,0.90950744558991981,0.86407025582283303,0.65263518138261467,0.65943832207607544,0.66990654205607481,0.68356435643564362,0.69207254941919705,0.70109151973131822,0.72249226690234214,0.94857142857142862,0.91428571428571415,0.91428571428571415,0.91714285714285737,0.89999999999999958,0.88285714285714278,0.76571428571428557,{"$f":"Y10*C10+($A$4-80)*AF10*$A$8/1000","v":17.475372279495989},{"$f":"Z10*E10+($A$4-80)*AG10*$A$8/1000","v":16.998854524627721},{"$f":"AA10*G10+($A$4-80)*AH10*$A$8/1000","v":16.421534936998853},{"$f":"AB10*I10+($A$4-80)*AI10*$A$8/1000","v":15.816723940435281},{"$f":"AC10*K10+($A$4-80)*AJ10*$A$8/1000","v":15.560137457044672},{"$f":"AD10*M10+($A$4-80)*AK10*$A$8/1000","v":15.303550973654067},{"$f":"AE10*O10+($A$4-80)*AL10*$A$8/1000","v":14.982817869415808}]
[null,62,24.009163802978232,19.958762886597935,23.083619702176403,19.491408934707902,22.029782359679267,18.987399770904926,20.920962199312712,18.492554410080182,20.384879725085909,18.272623138602519,19.848797250859107,18.052691867124857,18.877434135166094,17.741122565864835,null,1.000381825124093,0.96181748759068342,0.91790759831996938,0.87170675830469635,0.84936998854524615,0.82703321878579605,0.7865597556319206,0.83129770992366414,0.84438269154426349,0.86189683860232946,0.88392466053438468,0.89638120926050802,0.90951061865189287,0.93980582524271838,0.94857142857142862,0.91428571428571415,0.91428571428571415,0.91714285714285737,0.89999999999999958,0.88285714285714278,0.76571428571428557,{"$f":"Y11*C11+($A$4-80)*AF11*$A$8/1000","v":19.958762886597935},{"$f":"Z11*E11+($A$4-80)*AG11*$A$8/1000","v":19.491408934707902},{"$f":"AA11*G11+($A$4-80)*AH11*$A$8/1000","v":18.987399770904926},{"$f":"AB11*I11+($A$4-80)*AI11*$A$8/1000","v":18.492554410080182},{"$f":"AC11*K11+($A$4-80)*AJ11*$A$8/1000","v":18.272623138602519},{"$f":"AD11*M11+($A$4-80)*AK11*$A$8/1000","v":18.052691867124857},{"$f":"AE11*O11+($A$4-80)*AL11*$A$8/1000","v":17.741122565864835}]
[800,72,30.387170675830465,15.239404352806412,29.223367697594497,14.735395189003432,27.903780068728519,14.240549828178693,26.455899198167238,13.764032073310421,25.681557846506298,13.525773195876289,24.907216494845358,13.287514318442152,23.276059564719358,12.82016036655212,null,1.266132111492936,1.2176403207331041,1.1626575028636883,1.1023291332569682,1.0700649102710957,1.0378006872852232,0.96983581519663986,0.50150784077201449,0.50423330197554084,0.51034482758620692,0.52026324904745402,0.52667261373773422,0.53348050036791761,0.55078740157480321,0.97250000000000014,0.95499999999999996,0.92250000000000021,0.89499999999999957,0.88499999999999979,0.87499999999999989,0.87999999999999989,{"$f":"Y12*C12+($A$4-80)*AF12*$A$12/1000","v":15.239404352806412},{"$f":"Z12*E12+($A$4-80)*AG12*$A$12/1000","v":14.735395189003432},{"$f":"AA12*G12+($A$4-80)*AH12*$A$12/1000","v":14.240549828178693},{"$f":"AB12*I12+($A$4-80)*AI12*$A$12/1000","v":13.764032073310421},{"$f":"AC12*K12+($A$4-80)*AJ12*$A$12/1000","v":13.525773195876289},{"$f":"AD12*M12+($A$4-80)*AK12*$A$12/1000","v":13.287514318442152},{"$f":"AE12*O12+($A$4-80)*AL12*$A$12/1000","v":12.82016036655212}]
[null,69.5,28.953035509736537,17.049255441008015,27.862542955326461,16.568155784650628,26.611683848797249,16.06872852233677,25.227949599083619,15.555555555555557,24.481099656357387,15.282932416953033,23.734249713631154,15.010309278350515,22.139747995418098,14.43298969072165,null,1.2063764795723557,1.1609392898052693,1.108820160366552,1.0511645666284841,1.0200458190148911,0.9889270714012981,0.92248949980908734,0.58885899667668928,0.59463903963163944,0.60382231404958675,0.61660007264802041,0.62427475201197824,0.63243243243243252,0.65190397350993379,0.97250000000000014,0.95499999999999996,0.92250000000000021,0.89499999999999957,0.88499999999999979,0.87499999999999989,0.87999999999999989,{"$f":"Y13*C13+($A$4-80)*AF13*$A$12/1000","v":17.049255441008015},{"$f":"Z13*E13+($A$4-80)*AG13*$A$12/1000","v":16.568155784650628},{"$f":"AA13*G13+($A$4-80)*AH13*$A$12/1000","v":16.06872852233677},{"$f":"AB13*I13+($A$4-80)*AI13*$A$12/1000","v":15.555555555555557},{"$f":"AC13*K13+($A$4-80)*AJ13*$A$12/1000","v":15.282932416953033},{"$f":"AD13*M13+($A$4-80)*AK13*$A$12/1000","v":15.010309278350515},{"$f":"AE13*O13+($A$4-80)*AL13*$A$12/1000","v":14.43298969072165}]
[null,67,27.51890034364261,18.859106529209619,26.501718213058421,18.400916380297822,25.319587628865975,17.896907216494846,24,17.347079037800686,23.280641466208476,17.040091638029779,22.561282932416955,16.733104238258878,21.003436426116838,16.04581901489118,null,1.1466208476517754,1.1042382588774342,1.0549828178694156,1,0.97002672775868648,0.94005345551737307,0.87514318442153494,0.6853146853146852,0.69432918395573984,0.70684039087947892,0.72279495990836196,0.73194253099783502,0.74167343623070681,0.76396160558464221,0.97250000000000014,0.95499999999999996,0.92250000000000021,0.89499999999999957,0.88499999999999979,0.87499999999999989,0.87999999999999989,{"$f":"Y14*C14+($A$4-80)*AF14*$A$12/1000","v":18.859106529209619},{"$f":"Z14*E14+($A$4-80)*AG14*$A$12/1000","v":18.400916380297822},{"$f":"AA14*G14+($A$4-80)*AH14*$A$12/1000","v":17.896907216494846},{"$f":"AB14*I14+($A$4-80)*AI14*$A$12/1000","v":17.347079037800686},{"$f":"AC14*K14+($A$4-80)*AJ14*$A$12/1000","v":17.040091638029779},{"$f":"AD14*M14+($A$4-80)*AK14*$A$12/1000","v":16.733104238258878},{"$f":"AE14*O14+($A$4-80)*AL14*$A$12/1000","v":16.04581901489118}]
[null,62,24.925544100801833,21.773195876288664,23.917525773195877,21.223367697594501,22.753722794959906,20.563573883161514,{"$f":"U15*$I$14","v":21.580756013745706},19.922107674684995,21.063001145475369,19.674684994272621,20.545246277205042,19.42726231386025,19.821305841924399,19.225658648339063,null,1.0385643375334097,0.99656357388316152,0.9480717831233294,0.89919816723940438,0.87762504772814043,0.8560519282168767,0.82588774341351656,0.873529411764706,0.88735632183908042,0.90374546919049548,0.92314225053078547,0.93408744833587121,0.94558429973238167,0.96994914470642635,0.97250000000000014,0.95499999999999996,0.92250000000000021,0.89499999999999957,0.88499999999999979,0.87499999999999989,0.87999999999999989,{"$f":"Y15*C15+($A$4-80)*AF15*$A$12/1000","v":21.773195876288664},{"$f":"Z15*E15+($A$4-80)*AG15*$A$12/1000","v":21.223367697594501},{"$f":"AA15*G15+($A$4-80)*AH15*$A$12/1000","v":20.563573883161514},{"$f":"AB15*I15+($A$4-80)*AI15*$A$12/1000","v":19.922107674684995},{"$f":"AC15*K15+($A$4-80)*AJ15*$A$12/1000","v":19.674684994272621},{"$f":"AD15*M15+($A$4-80)*AK15*$A$12/1000","v":19.42726231386025},{"$f":"AE15*O15+($A$4-80)*AL15*$A$12/1000","v":19.225658648339063}]
[900,72,31.239404352806417,16.192439862542955,30.029782359679267,15.688430698739976,28.618556701030926,15.184421534936996,{"$f":"U16*$I$14","v":27.079037800687285},14.689576174112258,26.268041237113401,14.45589919816724,25.457044673539521,14.222222222222223,23.844215349369989,13.791523482245132,null,1.3016418480336007,1.2512409316533029,1.1924398625429553,1.1282932416953035,1.0945017182130583,1.0607101947308133,0.99350897289041618,0.51833382223525959,0.52242905096124503,0.53057957092539221,0.54247038917089685,0.55032269317983606,0.55867530597552195,0.57840122982321296,1.0022222222222228,0.99555555555555575,0.93777777777777749,0.88222222222222202,0.87888888888888861,0.87555555555555586,0.97777777777777752,{"$f":"Y16*C16+($A$4-80)*AF16*$A$16/1000","v":16.192439862542955},{"$f":"Z16*E16+($A$4-80)*AG16*$A$16/1000","v":15.688430698739976},{"$f":"AA16*G16+($A$4-80)*AH16*$A$16/1000","v":15.184421534936996},{"$f":"AB16*I16+($A$4-80)*AI16*$A$16/1000","v":14.689576174112258},{"$f":"AC16*K16+($A$4-80)*AJ16*$A$16/1000","v":14.45589919816724},{"$f":"AD16*M16+($A$4-80)*AK16*$A$16/1000","v":14.222222222222223},{"$f":"AE16*O16+($A$4-80)*AL16*$A$16/1000","v":13.791523482245132}]
[null,69.5,29.809851088201601,18.272623138602519,28.659793814432987,17.727376861397477,27.303550973654069,17.168384879725089,{"$f":"U17*$I$14","v":25.823596792668958},16.609392898052693,25.051546391752574,16.348224513172966,24.279495990836196,16.087056128293238,22.76746849942726,15.624284077892325,null,1.2420771286750667,1.1941580756013745,1.1376479572355862,1.0759831996945399,1.0438144329896906,1.0116456662848414,0.94864452080946915,0.61297264063940982,0.61854516386890479,0.62879677798288303,0.64318665720369061,0.65258344764517606,0.66257784487639171,0.68625477963372916,1.0022222222222228,0.99555555555555575,0.93777777777777749,0.88222222222222202,0.87888888888888861,0.87555555555555586,0.97777777777777752,{"$f":"Y17*C17+($A$4-80)*AF17*$A$16/1000","v":18.272623138602519},{"$f":"Z17*E17+($A$4-80)*AG17*$A$16/1000","v":17.727376861397477},{"$f":"AA17*G17+($A$4-80)*AH17*$A$16/1000","v":17.168384879725089},{"$f":"AB17*I17+($A$4-80)*AI17*$A$16/1000","v":16.609392898052693},{"$f":"AC17*K17+($A$4-80)*AJ17*$A$16/1000","v":16.348224513172966},{"$f":"AD17*M17+($A$4-80)*AK17*$A$16/1000","v":16.087056128293238},{"$f":"AE17*O17+($A$4-80)*AL17*$A$16/1000","v":15.624284077892325}]
[null,67,28.380297823596791,20.352806414662087,27.289805269186708,19.76632302405498,25.988545246277205,19.152348224513172,{"$f":"U18*$I$14","v":24.568155784650628},18.529209621993125,23.83505154639175,18.240549828178697,23.101947308132875,17.951890034364258,21.690721649484537,17.457044673539517,null,1.1825124093165329,1.1370752195494462,1.0828560519282169,1.0236731576937761,0.99312714776632294,0.96258113783886978,0.90378006872852235,0.71714562479819188,0.72431161853593018,0.73695345557122705,0.75419619544945915,0.76528258362168411,0.7770725902419674,0.8048162230671736,1.0022222222222228,0.99555555555555575,0.93777777777777749,0.88222222222222202,0.87888888888888861,0.87555555555555586,0.97777777777777752,{"$f":"Y18*C18+($A$4-80)*AF18*$A$16/1000","v":20.352806414662087},{"$f":"Z18*E18+($A$4-80)*AG18*$A$16/1000","v":19.76632302405498},{"$f":"AA18*G18+($A$4-80)*AH18*$A$16/1000","v":19.152348224513172},{"$f":"AB18*I18+($A$4-80)*AI18*$A$16/1000","v":18.529209621993125},{"$f":"AC18*K18+($A$4-80)*AJ18*$A$16/1000","v":18.240549828178697},{"$f":"AD18*M18+($A$4-80)*AK18*$A$16/1000","v":17.951890034364258},{"$f":"AE18*O18+($A$4-80)*AL18*$A$16/1000","v":17.457044673539517}]
[null,62,25.84192439862543,23.679266895761742,24.751431844215347,23.028636884306984,23.477663230240548,22.203894616265746,{"$f":"U19*$I$14","v":22.231386025200457},21.40664375715922,21.741122565864835,21.127147766323024,21.250859106529209,20.847651775486824,20.765177548682704,20.765177548682704,null,1.0767468499427262,1.0313096601756395,0.97823596792668954,0.92630775105001906,0.90588010691103471,0.88545246277205036,0.86521573119511264,0.91631205673758864,0.93039614957423167,0.94574551131928175,0.96290189612530908,0.9717597471022128,0.98102630444156957,1,1.0022222222222228,0.99555555555555575,0.93777777777777749,0.88222222222222202,0.87888888888888861,0.87555555555555586,0.97777777777777752,{"$f":"Y19*C19+($A$4-80)*AF19*$A$16/1000","v":23.679266895761742},{"$f":"Z19*E19+($A$4-80)*AG19*$A$16/1000","v":23.028636884306984},{"$f":"AA19*G19+($A$4-80)*AH19*$A$16/1000","v":22.203894616265746},{"$f":"AB19*I19+($A$4-80)*AI19*$A$16/1000","v":21.40664375715922},{"$f":"AC19*K19+($A$4-80)*AJ19*$A$16/1000","v":21.127147766323024},{"$f":"AD19*M19+($A$4-80)*AK19*$A$16/1000","v":20.847651775486824},{"$f":"AE19*O19+($A$4-80)*AL19*$A$16/1000","v":20.765177548682704}]

{"sheet":"PSA4BG_36","index":4,"n_rows":19,"n_cols":45,"rows_kept":19,"cut":false,"hidden":true,"merged":[[130,0,133,0],[120,12,121,12],[120,13,121,13],[120,14,121,14],[120,15,121,15],[122,0,125,0],[126,0,129,0],[119,12,119,13],[119,14,119,15],[120,4,121,4],[120,5,121,5],[120,6,121,6],[120,7,121,7],[120,8,121,8],[120,9,121,9],[120,10,121,10],[120,11,121,11],[119,0,121,0],[119,1,121,1],[119,4,119,5],[119,6,119,7],[119,8,119,9],[119,10,119,11],[111,0,114,0],[117,0,118,1],[117,4,117,15],[118,4,118,5],[118,6,118,7],[118,8,118,9],[118,10,118,11],[118,12,118,13],[118,14,118,15],[101,12,102,12],[101,13,102,13],[101,14,102,14],[101,15,102,15],[103,0,106,0],[107,0,110,0],[100,12,100,13],[100,14,100,15],[101,4,102,4],[101,5,102,5],[101,6,102,6],[101,7,102,7],[101,8,102,8],[101,9,102,9],[101,10,102,10],[101,11,102,11],[100,0,102,0],[100,1,102,1],[100,4,100,5],[100,6,100,7],[100,8,100,9],[100,10,100,11],[92,0,95,0],[98,0,99,1],[98,4,98,15],[99,4,99,5],[99,6,99,7],[99,8,99,9],[99,10,99,11],[99,12,99,13],[99,14,99,15],[82,12,83,12],[82,13,83,13],[82,14,83,14],[82,15,83,15],[84,0,87,0],[88,0,91,0],[81,12,81,13],[81,14,81,15],[82,4,83,4],[82,5,83,5],[82,6,83,6],[82,7,83,7],[82,8,83,8],[82,9,83,9],[82,10,83,10],[82,11,83,11],[81,0,83,0],[81,1,83,1],[81,4,81,5],[81,6,81,7],[81,8,81,9],[81,10,81,11],[73,0,76,0],[79,0,80,1],[79,4,79,15],[80,4,80,5],[80,6,80,7],[80,8,80,9],[80,10,80,11],[80,12,80,13],[80,14,80,15],[63,12,64,12],[63,13,64,13],[63,14,64,14],[63,15,64,15],[65,0,68,0],[69,0,72,0],[62,12,62,13],[62,14,62,15],[63,4,64,4],[63,5,64,5],[63,6,64,6],[63,7,64,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[63,11,64,11],[62,0,64,0],[62,1,64,1],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[54,0,57,0],[60,0,61,1],[60,4,60,15],[61,4,61,5],[61,6,61,7],[61,8,61,9],[61,10,61,11],[61,12,61,13],[61,14,61,15],[44,12,45,12],[44,13,45,13],[44,14,45,14],[44,15,45,15],[46,0,49,0],[50,0,53,0],[43,12,43,13],[43,14,43,15],[44,4,45,4],[44,5,45,5],[44,6,45,6],[44,7,45,7],[44,8,45,8],[44,9,45,9],[44,10,45,10],[44,11,45,11],[43,0,45,0],[43,1,45,1],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[35,0,38,0],[41,0,42,1],[41,4,41,15],[42,4,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,11],[42,12,42,13],[42,14,42,15],[25,12,26,12],[25,13,26,13],[25,14,26,14],[25,15,26,15],[27,0,30,0],[31,0,34,0],[24,12,24,13],[24,14,24,15],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[25,8,26,8],[25,9,26,9],[25,10,26,10],[25,11,26,11],[24,0,26,0],[24,1,26,1],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[7,0,10,0],[11,0,14,0],[15,0,18,0],[22,4,22,15],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[5,15,6,15],[4,10,4,11],[4,12,4,13],[4,14,4,15],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[4,0,6,0],[4,1,6,1],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[5,9,6,9],[2,0,2,1],[2,2,2,15],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15]]}
[]
["PSA4BG_36"]
["Evaporator Air \n",null,"Condenser  Entering Air Temperature ˚F"]
[80,"°F DB",65,null,75,null,85,null,95,null,100,null,105,null,115]
["CFM","EWB†\n˚F","Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh"]
[null,null,"Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Factors",null,null,null,null,null,null,"Sens. %",null,null,null,null,null,null,"IDB Adj",null,null,null,null,null,null,"Sens Calc"]
[940,72,{"$f":"R8*$I$14","v":27.82836951034831},{"$f":"IF(AM8>C8,C8,AM8)","v":13.550731953558811},{"$f":"S8*$I$14","v":27.985865724381625},{"$f":"IF(AN8>E8,E8,AN8)","v":13.459868753154971},{"$f":"T8*$I$14","v":27.137809187279153},{"$f":"IF(AO8>G8,G8,AO8)","v":13.017667844522968},{"$f":"U8*$I$14","v":25.756688541140843},{"$f":"IF(AP8>I8,I8,AP8)","v":12.448258455325595},{"$f":"V8*$I$14","v":25.04492680464412},{"$f":"IF(AQ8>K8,K8,AQ8)","v":12.20595658758203},{"$f":"W8*$I$14","v":24.333165068147402},{"$f":"IF(AR8>M8,M8,AR8)","v":11.963654719838466},{"$f":"X8*$I$14","v":23.345784957092377},{"$f":"IF(AS8>O8,O8,AS8)","v":11.781928319030794},null,1.1595153962645128,1.1660777385159011,1.1307420494699647,1.0731953558808685,1.0435386168601717,1.0138818778394751,0.97274103987884908,0.48693948628646067,0.48095238095238091,0.47968749999999999,0.48330197554092191,0.48736243802152618,0.49166044311675378,0.5046704722366373,1.0723404255319147,1.0638297872340425,1.0574468085106381,1.0510638297872337,1.0478723404255319,1.0446808510638297,1.0382978723404261,{"$f":"Y8*C8+($A$4-80)*AF8*$A$8/1000","v":13.550731953558811},{"$f":"Z8*E8+($A$4-80)*AG8*$A$8/1000","v":13.459868753154971},{"$f":"AA8*G8+($A$4-80)*AH8*$A$8/1000","v":13.017667844522968},{"$f":"AB8*I8+($A$4-80)*AI8*$A$8/1000","v":12.448258455325595},{"$f":"AC8*K8+($A$4-80)*AJ8*$A$8/1000","v":12.20595658758203},{"$f":"AD8*M8+($A$4-80)*AK8*$A$8/1000","v":11.963654719838466},{"$f":"AE8*O8+($A$4-80)*AL8*$A$8/1000","v":11.781928319030794}]
[null,69.5,27.016658253407371,15.056032306915702,26.768298838970217,14.82281675921252,25.917213528520946,14.39273094396769,24.693589096415952,13.874810701665826,24.019687026754166,13.618879353861688,23.345784957092377,13.362948006057549,22.113074204946997,12.960121150933873,null,1.1256940938919737,1.1153457849570925,1.0798838970217062,1.028899545683998,1.0008202927814236,0.97274103987884908,0.92137809187279152,0.55728699551569516,0.55374519121973298,0.55533481360289816,0.56187906292162393,0.56698821007502687,0.57239231966787762,0.58608409806875772,1.0723404255319147,1.0638297872340425,1.0574468085106381,1.0510638297872337,1.0478723404255319,1.0446808510638297,1.0382978723404261,{"$f":"Y9*C9+($A$4-80)*AF9*$A$8/1000","v":15.056032306915702},{"$f":"Z9*E9+($A$4-80)*AG9*$A$8/1000","v":14.82281675921252},{"$f":"AA9*G9+($A$4-80)*AH9*$A$8/1000","v":14.39273094396769},{"$f":"AB9*I9+($A$4-80)*AI9*$A$8/1000","v":13.874810701665826},{"$f":"AC9*K9+($A$4-80)*AJ9*$A$8/1000","v":13.618879353861688},{"$f":"AD9*M9+($A$4-80)*AK9*$A$8/1000","v":13.362948006057549},{"$f":"AE9*O9+($A$4-80)*AL9*$A$8/1000","v":12.960121150933873}]
[null,67,26.204946996466433,16.561332660272591,25.55073195355881,16.185764765270065,24.696617869762747,15.767794043412417,23.630489651691065,15.301362948006057,22.994447248864205,15.031802120141343,22.358404846037356,14.762241292276631,20.880363452801614,14.13831398283695,null,1.0918727915194346,1.0646138313982838,1.0290257445734479,0.98460373548712776,0.95810196870267528,0.93160020191822313,0.87001514386673395,0.63199260286638925,0.63347558084400191,0.63845965170468477,0.64752627531402207,0.65371443624868297,0.66025467353020872,0.67711053089643169,1.0723404255319147,1.0638297872340425,1.0574468085106381,1.0510638297872337,1.0478723404255319,1.0446808510638297,1.0382978723404261,{"$f":"Y10*C10+($A$4-80)*AF10*$A$8/1000","v":16.561332660272591},{"$f":"Z10*E10+($A$4-80)*AG10*$A$8/1000","v":16.185764765270065},{"$f":"AA10*G10+($A$4-80)*AH10*$A$8/1000","v":15.767794043412417},{"$f":"AB10*I10+($A$4-80)*AI10*$A$8/1000","v":15.301362948006057},{"$f":"AC10*K10+($A$4-80)*AJ10*$A$8/1000","v":15.031802120141343},{"$f":"AD10*M10+($A$4-80)*AK10*$A$8/1000","v":14.762241292276631},{"$f":"AE10*O10+($A$4-80)*AL10*$A$8/1000","v":14.13831398283695}]
[null,62,24.115093387178195,19.341746592629985,23.127713276123174,18.851085310449271,22.134275618374559,18.360424028268554,21.128722867238771,17.863705199394246,20.625946491670874,17.609288238263506,20.12317011610298,17.354871277132762,19.105502271580008,16.827864714790508,null,1.0047955577990915,0.96365471983846551,0.92226148409893993,0.88036345280161543,0.85941443715295307,0.83846542150429082,0.79606259464916707,0.80205978397387589,0.81508643268727088,0.82950191570881227,0.84547018348623848,0.85374449339207059,0.8624322697170379,0.88078630310716555,1.0723404255319147,1.0638297872340425,1.0574468085106381,1.0510638297872337,1.0478723404255319,1.0446808510638297,1.0382978723404261,{"$f":"Y11*C11+($A$4-80)*AF11*$A$8/1000","v":19.341746592629985},{"$f":"Z11*E11+($A$4-80)*AG11*$A$8/1000","v":18.851085310449271},{"$f":"AA11*G11+($A$4-80)*AH11*$A$8/1000","v":18.360424028268554},{"$f":"AB11*I11+($A$4-80)*AI11*$A$8/1000","v":17.863705199394246},{"$f":"AC11*K11+($A$4-80)*AJ11*$A$8/1000","v":17.609288238263506},{"$f":"AD11*M11+($A$4-80)*AK11*$A$8/1000","v":17.354871277132762},{"$f":"AE11*O11+($A$4-80)*AL11*$A$8/1000","v":16.827864714790508}]
[1080,72,28.119131751640587,14.01716304896517,28.537102473498233,14.041393235739525,27.743563856638062,13.623422513881879,26.307925290257451,13.02978293791015,25.56284704694599,12.775365976779407,24.817768803634529,12.520949015648664,23.842503785966684,12.381625441696116,null,1.1716304896516911,1.1890459363957597,1.1559818273599192,1.096163553760727,1.0651186269560828,1.0340737001514386,0.99343765774861181,0.49849202929771652,0.49203990660157076,0.49104803493449783,0.49527976053419298,0.49976303317535548,0.50451549914571647,0.51930894308943099,1.0169811320754718,1.0056603773584902,0.99811320754717037,0.99245283018867891,0.99245283018867947,0.99245283018867947,0.99245283018867891,{"$f":"Y12*C12+($A$4-80)*AF12*$A$12/1000","v":14.01716304896517},{"$f":"Z12*E12+($A$4-80)*AG12*$A$12/1000","v":14.041393235739525},{"$f":"AA12*G12+($A$4-80)*AH12*$A$12/1000","v":13.623422513881879},{"$f":"AB12*I12+($A$4-80)*AI12*$A$12/1000","v":13.02978293791015},{"$f":"AC12*K12+($A$4-80)*AJ12*$A$12/1000","v":12.775365976779407},{"$f":"AD12*M12+($A$4-80)*AK12*$A$12/1000","v":12.520949015648664},{"$f":"AE12*O12+($A$4-80)*AL12*$A$12/1000","v":12.381625441696116}]
[null,69.5,27.280161534578493,15.634528016153457,27.186269560827867,15.489146895507323,26.380615850580515,15.101463907117619,25.153962645128722,14.595658758202926,24.475517415446749,14.345784957092381,23.797072185764765,14.095911155981831,22.591620393740538,13.729429581019689,null,1.1366733972741039,1.1327612317011611,1.0991923271075215,1.0480817768803634,1.0198132256436145,0.99154467440686522,0.9413175164058557,0.57310980348617746,0.56974153297682717,0.57244546498277848,0.5802528597230584,0.58612795446108157,0.59233804250986399,0.60772221477409838,1.0169811320754718,1.0056603773584902,0.99811320754717037,0.99245283018867891,0.99245283018867947,0.99245283018867947,0.99245283018867891,{"$f":"Y13*C13+($A$4-80)*AF13*$A$12/1000","v":15.634528016153457},{"$f":"Z13*E13+($A$4-80)*AG13*$A$12/1000","v":15.489146895507323},{"$f":"AA13*G13+($A$4-80)*AH13*$A$12/1000","v":15.101463907117619},{"$f":"AB13*I13+($A$4-80)*AI13*$A$12/1000","v":14.595658758202926},{"$f":"AC13*K13+($A$4-80)*AJ13*$A$12/1000","v":14.345784957092381},{"$f":"AD13*M13+($A$4-80)*AK13*$A$12/1000","v":14.095911155981831},{"$f":"AE13*O13+($A$4-80)*AL13*$A$12/1000","v":13.729429581019689}]
[null,67,26.441191317516406,17.251892983341747,25.835436648157497,16.936900555275116,25.017667844522968,16.579505300353361,24,16.161534578495711,23.388187783947501,15.916203937405351,22.776375567895002,15.670873296314992,21.340737001514384,15.077233720343262,null,1.1017163048965168,1.0764765270065624,1.0424028268551238,1,0.97450782433114591,0.94901564866229182,0.88919737506309937,0.65246277205040093,0.65556858147713959,0.66271186440677976,0.67339727410398798,0.6805231805231805,0.68803191489361704,0.70650014192449628,1.0169811320754718,1.0056603773584902,0.99811320754717037,0.99245283018867891,0.99245283018867947,0.99245283018867947,0.99245283018867891,{"$f":"Y14*C14+($A$4-80)*AF14*$A$12/1000","v":17.251892983341747},{"$f":"Z14*E14+($A$4-80)*AG14*$A$12/1000","v":16.936900555275116},{"$f":"AA14*G14+($A$4-80)*AH14*$A$12/1000","v":16.579505300353361},{"$f":"AB14*I14+($A$4-80)*AI14*$A$12/1000","v":16.161534578495711},{"$f":"AC14*K14+($A$4-80)*AJ14*$A$12/1000","v":15.916203937405351},{"$f":"AD14*M14+($A$4-80)*AK14*$A$12/1000","v":15.670873296314992},{"$f":"AE14*O14+($A$4-80)*AL14*$A$12/1000","v":15.077233720343262}]
[null,62,24.739020696617871,20.444220090863201,23.763755678950023,19.947501261988894,22.758202927814235,19.444724886421,{"$f":"U15*$I$14","v":21.716304896516913},18.923775870772339,21.177183240787482,18.654215042907623,20.638061585058054,18.384654215042911,19.523472993437657,17.809187279151946,null,1.0307925290257447,0.99015648662291766,0.94825845532559316,0.90484603735487135,0.88238263503281178,0.85991923271075221,0.81347804139323576,0.82639569049951023,0.83940861585521287,0.85440511046047385,0.87140864714086463,0.88086384439359267,0.8908130319929557,0.91219360843934227,1.0169811320754718,1.0056603773584902,0.99811320754717037,0.99245283018867891,0.99245283018867947,0.99245283018867947,0.99245283018867891,{"$f":"Y15*C15+($A$4-80)*AF15*$A$12/1000","v":20.444220090863201},{"$f":"Z15*E15+($A$4-80)*AG15*$A$12/1000","v":19.947501261988894},{"$f":"AA15*G15+($A$4-80)*AH15*$A$12/1000","v":19.444724886421},{"$f":"AB15*I15+($A$4-80)*AI15*$A$12/1000","v":18.923775870772339},{"$f":"AC15*K15+($A$4-80)*AJ15*$A$12/1000","v":18.654215042907623},{"$f":"AD15*M15+($A$4-80)*AK15*$A$12/1000","v":18.384654215042911},{"$f":"AE15*O15+($A$4-80)*AL15*$A$12/1000","v":17.809187279151946}]
[1160,72,28.415951539626448,14.48965169106512,29.100454316002022,14.647147905098436,28.367491166077738,14.247349823321555,{"$f":"U16*$I$14","v":26.883392226148416},13.629480060575471,26.104997476022213,13.369005552751139,25.326602725896016,13.108531044926805,24.363452801615345,13.005552751135788,null,1.1839979808177687,1.2125189298334176,1.1819787985865724,1.1201413427561839,1.0877082281675923,1.0552751135790006,1.0151438667339727,0.5099125985930506,0.50333055786844294,0.50224215246636772,0.50698512843623256,0.51212437637777009,0.51757952642908389,0.53381402287419188,0.97457627118644141,0.95932203389830517,0.95084745762711864,0.94915254237288105,0.95084745762711864,0.95254237288135601,0.95762711864406747,{"$f":"Y16*C16+($A$4-80)*AF16*$A$16/1000","v":14.48965169106512},{"$f":"Z16*E16+($A$4-80)*AG16*$A$16/1000","v":14.647147905098436},{"$f":"AA16*G16+($A$4-80)*AH16*$A$16/1000","v":14.247349823321555},{"$f":"AB16*I16+($A$4-80)*AI16*$A$16/1000","v":13.629480060575471},{"$f":"AC16*K16+($A$4-80)*AJ16*$A$16/1000","v":13.369005552751139},{"$f":"AD16*M16+($A$4-80)*AK16*$A$16/1000","v":13.108531044926805},{"$f":"AE16*O16+($A$4-80)*AL16*$A$16/1000","v":13.005552751135788}]
[null,69.5,27.546693589096414,16.216052498738012,27.607269056032308,16.167592125189298,26.859162039374056,15.819283190307926,{"$f":"U17*$I$14","v":25.629480060575471},15.325593134780416,24.944977284199901,15.083291267036852,24.260474507824334,14.840989399293289,23.08531044926805,14.513881877839477,null,1.1477788995456839,1.1503028773346795,1.1191317516405856,1.067895002523978,1.0393740535083291,1.0108531044926805,0.96188793538616868,0.5886750962067071,0.58562808557323087,0.58897158322056831,0.59796738359725832,0.60466245750364256,0.61173533083645448,0.62870637627919179,0.97457627118644141,0.95932203389830517,0.95084745762711864,0.94915254237288105,0.95084745762711864,0.95254237288135601,0.95762711864406747,{"$f":"Y17*C17+($A$4-80)*AF17*$A$16/1000","v":16.216052498738012},{"$f":"Z17*E17+($A$4-80)*AG17*$A$16/1000","v":16.167592125189298},{"$f":"AA17*G17+($A$4-80)*AH17*$A$16/1000","v":15.819283190307926},{"$f":"AB17*I17+($A$4-80)*AI17*$A$16/1000","v":15.325593134780416},{"$f":"AC17*K17+($A$4-80)*AJ17*$A$16/1000","v":15.083291267036852},{"$f":"AD17*M17+($A$4-80)*AK17*$A$16/1000","v":14.840989399293289},{"$f":"AE17*O17+($A$4-80)*AL17*$A$16/1000","v":14.513881877839477}]
[null,67,26.677435638566383,17.942453306410904,26.114083796062594,17.68803634528016,25.350832912670374,17.3912165572943,{"$f":"U18*$I$14","v":24.375567895002526},17.021706208985361,23.784957092377589,16.797576981322567,23.194346289752652,16.573447753659767,21.807168096920748,16.022211004543159,null,1.1115598182735993,1.0880868248359414,1.0562847046945989,1.015648662291772,0.99103987884906619,0.96643109540636052,0.90863200403836453,0.67257039055404177,0.6773370447691951,0.6860215053763441,0.69831013916500995,0.70622691964854201,0.71454687908069991,0.73472222222222217,0.97457627118644141,0.95932203389830517,0.95084745762711864,0.94915254237288105,0.95084745762711864,0.95254237288135601,0.95762711864406747,{"$f":"Y18*C18+($A$4-80)*AF18*$A$16/1000","v":17.942453306410904},{"$f":"Z18*E18+($A$4-80)*AG18*$A$16/1000","v":17.68803634528016},{"$f":"AA18*G18+($A$4-80)*AH18*$A$16/1000","v":17.3912165572943},{"$f":"AB18*I18+($A$4-80)*AI18*$A$16/1000","v":17.021706208985361},{"$f":"AC18*K18+($A$4-80)*AJ18*$A$16/1000","v":16.797576981322567},{"$f":"AD18*M18+($A$4-80)*AK18*$A$16/1000","v":16.573447753659767},{"$f":"AE18*O18+($A$4-80)*AL18*$A$16/1000","v":16.022211004543159}]
[null,62,25.356890459363957,21.583038869257951,24.399798081776879,21.074204946996463,23.382130237253914,20.553255931347806,{"$f":"U19*$I$14","v":22.297829379101465},20.014134275618375,21.7223624432105,19.729429581019687,21.146895507319535,19.444724886421,19.935386168601717,18.820797576981324,null,1.0565371024734982,1.01665825340737,0.9742554265522464,0.92907622412922775,0.90509843513377086,0.88112064613831398,0.83064109035840483,0.85117056856187301,0.86370407149950346,0.87901554404145077,0.89758217875577284,0.90825432236475179,0.9195073044972788,0.94408994226678833,0.97457627118644141,0.95932203389830517,0.95084745762711864,0.94915254237288105,0.95084745762711864,0.95254237288135601,0.95762711864406747,{"$f":"Y19*C19+($A$4-80)*AF19*$A$16/1000","v":21.583038869257951},{"$f":"Z19*E19+($A$4-80)*AG19*$A$16/1000","v":21.074204946996463},{"$f":"AA19*G19+($A$4-80)*AH19*$A$16/1000","v":20.553255931347806},{"$f":"AB19*I19+($A$4-80)*AI19*$A$16/1000","v":20.014134275618375},{"$f":"AC19*K19+($A$4-80)*AJ19*$A$16/1000","v":19.729429581019687},{"$f":"AD19*M19+($A$4-80)*AK19*$A$16/1000","v":19.444724886421},{"$f":"AE19*O19+($A$4-80)*AL19*$A$16/1000","v":18.820797576981324}]

{"sheet":"PSA4BG_48","index":5,"n_rows":19,"n_cols":45,"rows_kept":19,"cut":false,"hidden":true,"merged":[[130,0,133,0],[120,12,121,12],[120,13,121,13],[120,14,121,14],[120,15,121,15],[122,0,125,0],[126,0,129,0],[119,12,119,13],[119,14,119,15],[120,4,121,4],[120,5,121,5],[120,6,121,6],[120,7,121,7],[120,8,121,8],[120,9,121,9],[120,10,121,10],[120,11,121,11],[119,0,121,0],[119,1,121,1],[119,4,119,5],[119,6,119,7],[119,8,119,9],[119,10,119,11],[111,0,114,0],[117,0,118,1],[117,4,117,15],[118,4,118,5],[118,6,118,7],[118,8,118,9],[118,10,118,11],[118,12,118,13],[118,14,118,15],[101,12,102,12],[101,13,102,13],[101,14,102,14],[101,15,102,15],[103,0,106,0],[107,0,110,0],[100,12,100,13],[100,14,100,15],[101,4,102,4],[101,5,102,5],[101,6,102,6],[101,7,102,7],[101,8,102,8],[101,9,102,9],[101,10,102,10],[101,11,102,11],[100,0,102,0],[100,1,102,1],[100,4,100,5],[100,6,100,7],[100,8,100,9],[100,10,100,11],[92,0,95,0],[98,0,99,1],[98,4,98,15],[99,4,99,5],[99,6,99,7],[99,8,99,9],[99,10,99,11],[99,12,99,13],[99,14,99,15],[82,12,83,12],[82,13,83,13],[82,14,83,14],[82,15,83,15],[84,0,87,0],[88,0,91,0],[81,12,81,13],[81,14,81,15],[82,4,83,4],[82,5,83,5],[82,6,83,6],[82,7,83,7],[82,8,83,8],[82,9,83,9],[82,10,83,10],[82,11,83,11],[81,0,83,0],[81,1,83,1],[81,4,81,5],[81,6,81,7],[81,8,81,9],[81,10,81,11],[73,0,76,0],[79,0,80,1],[79,4,79,15],[80,4,80,5],[80,6,80,7],[80,8,80,9],[80,10,80,11],[80,12,80,13],[80,14,80,15],[63,12,64,12],[63,13,64,13],[63,14,64,14],[63,15,64,15],[65,0,68,0],[69,0,72,0],[62,12,62,13],[62,14,62,15],[63,4,64,4],[63,5,64,5],[63,6,64,6],[63,7,64,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[63,11,64,11],[62,0,64,0],[62,1,64,1],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[54,0,57,0],[60,0,61,1],[60,4,60,15],[61,4,61,5],[61,6,61,7],[61,8,61,9],[61,10,61,11],[61,12,61,13],[61,14,61,15],[44,12,45,12],[44,13,45,13],[44,14,45,14],[44,15,45,15],[46,0,49,0],[50,0,53,0],[43,12,43,13],[43,14,43,15],[44,4,45,4],[44,5,45,5],[44,6,45,6],[44,7,45,7],[44,8,45,8],[44,9,45,9],[44,10,45,10],[44,11,45,11],[43,0,45,0],[43,1,45,1],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[35,0,38,0],[41,0,42,1],[41,4,41,15],[42,4,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,11],[42,12,42,13],[42,14,42,15],[25,12,26,12],[25,13,26,13],[25,14,26,14],[25,15,26,15],[27,0,30,0],[31,0,34,0],[24,12,24,13],[24,14,24,15],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[25,8,26,8],[25,9,26,9],[25,10,26,10],[25,11,26,11],[24,0,26,0],[24,1,26,1],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[7,0,10,0],[11,0,14,0],[15,0,18,0],[22,4,22,15],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[5,15,6,15],[4,10,4,11],[4,12,4,13],[4,14,4,15],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[4,0,6,0],[4,1,6,1],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[5,9,6,9],[2,0,2,1],[2,2,2,15],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15]]}
[]
["PSA4BG_48"]
["Evaporator Air \n",null,"Condenser  Entering Air Temperature ˚F"]
[80,"°F DB",65,null,75,null,85,null,95,null,100,null,105,null,115]
["CFM","EWB†\n˚F","Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh"]
[null,null,"Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Factors",null,null,null,null,null,null,"Sens. %",null,null,null,null,null,null,"IDB Adj",null,null,null,null,null,null,"Sens Calc"]
[1285,72,{"$f":"R8*$I$14","v":27.434490696336084},{"$f":"IF(AM8>C8,C8,AM8)","v":13.595242662574334},{"$f":"S8*$I$14","v":28.009975062344139},{"$f":"IF(AN8>E8,E8,AN8)","v":13.618262037214654},{"$f":"T8*$I$14","v":26.969499328601572},{"$f":"IF(AO8>G8,G8,AO8)","v":13.065797045846919},{"$f":"U8*$I$14","v":25.427201227699975},{"$f":"IF(AP8>I8,I8,AP8)","v":12.471897180126604},{"$f":"V8*$I$14","v":24.964511797429498},{"$f":"IF(AQ8>K8,K8,AQ8)","v":12.4143487435258},{"$f":"W8*$I$14","v":24.501822367159026},{"$f":"IF(AR8>M8,M8,AR8)","v":12.356800306924995},{"$f":"X8*$I$14","v":19.741415691540382},{"$f":"IF(AS8>O8,O8,AS8)","v":10.377134087857279},null,1.1431037790140035,1.1670822942643391,1.1237291386917321,1.0594667178208323,1.0401879915595624,1.0209092652982927,0.82255898714751585,0.49555294512502096,0.48619329388560151,0.48446568794810513,0.4904942965779468,0.49727985246657452,0.50432168357760243,0.52565298507462677,1.0396887159533073,1.0708171206225672,1.1066147859922177,1.0583657587548634,0.94708171206225678,0.83579766536964939,0.85603112840466933,{"$f":"Y8*C8+($A$4-80)*AF8*$A$8/1000","v":13.595242662574334},{"$f":"Z8*E8+($A$4-80)*AG8*$A$8/1000","v":13.618262037214654},{"$f":"AA8*G8+($A$4-80)*AH8*$A$8/1000","v":13.065797045846919},{"$f":"AB8*I8+($A$4-80)*AI8*$A$8/1000","v":12.471897180126604},{"$f":"AC8*K8+($A$4-80)*AJ8*$A$8/1000","v":12.4143487435258},{"$f":"AD8*M8+($A$4-80)*AK8*$A$8/1000","v":12.356800306924995},{"$f":"AE8*O8+($A$4-80)*AL8*$A$8/1000","v":10.377134087857279}]
[null,69.5,26.723192019950126,15.271053136389794,26.946479953961251,15.201995012468826,25.954344906963357,14.713984270093993,24.366008056781119,14.087857279877229,23.583349319010161,13.836946096297716,22.800690581239209,13.586034912718205,19.175139075388454,12.082869748705159,null,1.1134663341645885,1.1227699980817187,1.0814310377901399,1.0152503356992133,0.98263955495875677,0.95002877421830034,0.79896412814118556,0.57145318287535529,0.564155134119255,0.56691796008869177,0.57817666509211152,0.58672523182040026,0.59586067642604745,0.63013205282112827,1.0396887159533073,1.0708171206225672,1.1066147859922177,1.0583657587548634,0.94708171206225678,0.83579766536964939,0.85603112840466933,{"$f":"Y9*C9+($A$4-80)*AF9*$A$8/1000","v":15.271053136389794},{"$f":"Z9*E9+($A$4-80)*AG9*$A$8/1000","v":15.201995012468826},{"$f":"AA9*G9+($A$4-80)*AH9*$A$8/1000","v":14.713984270093993},{"$f":"AB9*I9+($A$4-80)*AI9*$A$8/1000","v":14.087857279877229},{"$f":"AC9*K9+($A$4-80)*AJ9*$A$8/1000","v":13.836946096297716},{"$f":"AD9*M9+($A$4-80)*AK9*$A$8/1000","v":13.586034912718205},{"$f":"AE9*O9+($A$4-80)*AL9*$A$8/1000","v":12.082869748705159}]
[null,67,26.011893343564164,16.946863610205256,25.882984845578363,16.785727987723,24.939190485325149,16.362171494341069,23.304814885862264,15.703817379627852,22.202186840590826,15.25954344906963,21.099558795319389,14.81526951851141,18.608862459236523,13.788605409553039,null,1.0838288893151735,1.0784577018990984,1.0391329368885478,0.97103395357759437,0.9250911183579511,0.87914828313830795,0.77536926913485515,0.65150442477876114,0.64852365706154391,0.65608270260291668,0.67384433030422763,0.68729911871435978,0.7021601571023347,0.74096981692231567,1.0396887159533073,1.0708171206225672,1.1066147859922177,1.0583657587548634,0.94708171206225678,0.83579766536964939,0.85603112840466933,{"$f":"Y10*C10+($A$4-80)*AF10*$A$8/1000","v":16.946863610205256},{"$f":"Z10*E10+($A$4-80)*AG10*$A$8/1000","v":16.785727987723},{"$f":"AA10*G10+($A$4-80)*AH10*$A$8/1000","v":16.362171494341069},{"$f":"AB10*I10+($A$4-80)*AI10*$A$8/1000","v":15.703817379627852},{"$f":"AC10*K10+($A$4-80)*AJ10*$A$8/1000","v":15.25954344906963},{"$f":"AD10*M10+($A$4-80)*AK10*$A$8/1000","v":14.81526951851141},{"$f":"AE10*O10+($A$4-80)*AL10*$A$8/1000","v":13.788605409553039}]
[null,62,24.161135622482252,19.897947439094569,23.410704009207748,19.557260694417799,22.577402647228084,19.184346825244582,21.449453289852293,18.585843084596199,20.639171302512946,18.074812967581042,19.828889315173605,17.563782850565893,17.011317859198158,15.436792633800113,null,1.0067139842700938,0.97544600038365625,0.94072511030117012,0.89372722041051222,0.85996547093803943,0.82620372146556686,0.70880491079992325,0.82355182926829273,0.83539823008849545,0.84971451876019577,0.86649495599914128,0.87575284407762655,0.88576735546784302,0.90744248985115017,1.0396887159533073,1.0708171206225672,1.1066147859922177,1.0583657587548634,0.94708171206225678,0.83579766536964939,0.85603112840466933,{"$f":"Y11*C11+($A$4-80)*AF11*$A$8/1000","v":19.897947439094569},{"$f":"Z11*E11+($A$4-80)*AG11*$A$8/1000","v":19.557260694417799},{"$f":"AA11*G11+($A$4-80)*AH11*$A$8/1000","v":19.184346825244582},{"$f":"AB11*I11+($A$4-80)*AI11*$A$8/1000","v":18.585843084596199},{"$f":"AC11*K11+($A$4-80)*AJ11*$A$8/1000","v":18.074812967581042},{"$f":"AD11*M11+($A$4-80)*AK11*$A$8/1000","v":17.563782850565893},{"$f":"AE11*O11+($A$4-80)*AL11*$A$8/1000","v":15.436792633800113}]
[1480,72,27.443698446192208,13.986572031459811,28.198733934394781,14.225973527719161,27.314789948206403,13.797813159409166,25.882984845578363,13.236140418185308,25.436408977556113,13.157874544408209,24.989833109533855,13.079608670631114,20.6713984270094,11.182812200268561,null,1.1434874352580087,1.1749472472664493,1.1381162478419335,1.0784577018990984,1.059850374064838,1.0412430462305773,0.86130826779205827,0.50964603254487506,0.50448979591836729,0.50514073824372152,0.51138384916399859,0.51728506787330308,0.52339719970523213,0.54097995545657018,1.0040540540540541,1.0337837837837838,1.0729729729729727,1.041891891891892,0.947972972972973,0.85405405405405399,0.97162162162162125,{"$f":"Y12*C12+($A$4-80)*AF12*$A$12/1000","v":13.986572031459811},{"$f":"Z12*E12+($A$4-80)*AG12*$A$12/1000","v":14.225973527719161},{"$f":"AA12*G12+($A$4-80)*AH12*$A$12/1000","v":13.797813159409166},{"$f":"AB12*I12+($A$4-80)*AI12*$A$12/1000","v":13.236140418185308},{"$f":"AC12*K12+($A$4-80)*AJ12*$A$12/1000","v":13.157874544408209},{"$f":"AD12*M12+($A$4-80)*AK12*$A$12/1000","v":13.079608670631114},{"$f":"AE12*O12+($A$4-80)*AL12*$A$12/1000","v":11.182812200268561}]
[null,69.5,26.835986955687702,15.812008440437367,27.303280260886247,16.044504124304623,26.522923460579321,15.73374256666027,24.941492422789178,15.054671014770767,24.070209092652981,14.680606176865526,23.198925762516787,14.306541338960294,19.796662190677154,12.727412238634184,null,1.1181661231536542,1.1376366775369269,1.1051218108574716,1.0392288509495491,1.0029253788605408,0.9666219067715327,0.82486092461154803,0.58920912677989368,0.58764016524744955,0.59321298385696919,0.60359944623904027,0.609907712905848,0.61668981940861289,0.64290697674418606,1.0040540540540541,1.0337837837837838,1.0729729729729727,1.041891891891892,0.947972972972973,0.85405405405405399,0.97162162162162125,{"$f":"Y13*C13+($A$4-80)*AF13*$A$12/1000","v":15.812008440437367},{"$f":"Z13*E13+($A$4-80)*AG13*$A$12/1000","v":16.044504124304623},{"$f":"AA13*G13+($A$4-80)*AH13*$A$12/1000","v":15.73374256666027},{"$f":"AB13*I13+($A$4-80)*AI13*$A$12/1000","v":15.054671014770767},{"$f":"AC13*K13+($A$4-80)*AJ13*$A$12/1000","v":14.680606176865526},{"$f":"AD13*M13+($A$4-80)*AK13*$A$12/1000","v":14.306541338960294},{"$f":"AE13*O13+($A$4-80)*AL13*$A$12/1000","v":12.727412238634184}]
[null,67,26.228275465183192,17.637444849414923,26.407826587377706,17.863034720890077,25.731056972952231,17.669671973911374,24,16.873201611356222,22.704009207749856,16.203337809322846,21.408018415499711,15.533474007289469,18.921925954344907,14.272012276999808,null,1.0928448110492996,1.1003261078074045,1.0721273738730097,1,0.94600038365624395,0.89200076731248801,0.78841358143103779,0.67245918904686686,0.6764295676429567,0.68670602970119887,0.70305006713984264,0.71367738010747239,0.72559139784946236,0.75425790754257904,1.0040540540540541,1.0337837837837838,1.0729729729729727,1.041891891891892,0.947972972972973,0.85405405405405399,0.97162162162162125,{"$f":"Y14*C14+($A$4-80)*AF14*$A$12/1000","v":17.637444849414923},{"$f":"Z14*E14+($A$4-80)*AG14*$A$12/1000","v":17.863034720890077},{"$f":"AA14*G14+($A$4-80)*AH14*$A$12/1000","v":17.669671973911374},{"$f":"AB14*I14+($A$4-80)*AI14*$A$12/1000","v":16.873201611356222},{"$f":"AC14*K14+($A$4-80)*AJ14*$A$12/1000","v":16.203337809322846},{"$f":"AD14*M14+($A$4-80)*AK14*$A$12/1000","v":15.533474007289469},{"$f":"AE14*O14+($A$4-80)*AL14*$A$12/1000","v":14.272012276999808}]
[null,62,24.685977364281605,21.127182044887782,24.041434874352579,20.961442547477461,23.139075388451946,20.560905428735854,{"$f":"U15*$I$14","v":21.946671782083254},19.879531939382314,21.187032418952615,19.373105697295223,20.42739305582198,18.866679455208132,17.526951851141376,16.514099366967194,null,1.0285823901784001,1.0017264530980241,0.96412814118549772,0.91444465758680227,0.88279301745635896,0.85114137732591588,0.73028966046422406,0.85583737411413652,0.87188816545384917,0.88857938718662954,0.90581078246276481,0.91438504997827041,0.92359702501690333,0.94221171526136061,1.0040540540540541,1.0337837837837838,1.0729729729729727,1.041891891891892,0.947972972972973,0.85405405405405399,0.97162162162162125,{"$f":"Y15*C15+($A$4-80)*AF15*$A$12/1000","v":21.127182044887782},{"$f":"Z15*E15+($A$4-80)*AG15*$A$12/1000","v":20.961442547477461},{"$f":"AA15*G15+($A$4-80)*AH15*$A$12/1000","v":20.560905428735854},{"$f":"AB15*I15+($A$4-80)*AI15*$A$12/1000","v":19.879531939382314},{"$f":"AC15*K15+($A$4-80)*AJ15*$A$12/1000","v":19.373105697295223},{"$f":"AD15*M15+($A$4-80)*AK15*$A$12/1000","v":18.866679455208132},{"$f":"AE15*O15+($A$4-80)*AL15*$A$12/1000","v":16.514099366967194}]
[1610,72,27.448302321120273,14.244389027431421,28.3000191828122,14.621906771532709,27.512756570113176,14.276616151927872,{"$f":"U16*$I$14","v":26.145405716478034},13.733358910416266,25.705735660847882,13.638979474390947,25.266065605217726,13.544600038365624,20.745060425858433,11.436025321312107,null,1.1436792633800115,1.1791674659505083,1.1463648570880489,1.0893919048532514,1.0710723192019951,1.0527527335507385,0.86437751774410132,0.51895337135189534,0.51667480071579641,0.51890896921017404,0.52526853319246347,0.53058117668129312,0.53607871720116618,0.55126498002663116,0.98757763975155222,1.0161490683229812,1.0583850931677024,1.0360248447204974,0.95217391304347898,0.8683229813664598,1.0360248447204969,{"$f":"Y16*C16+($A$4-80)*AF16*$A$16/1000","v":14.244389027431421},{"$f":"Z16*E16+($A$4-80)*AG16*$A$16/1000","v":14.621906771532709},{"$f":"AA16*G16+($A$4-80)*AH16*$A$16/1000","v":14.276616151927872},{"$f":"AB16*I16+($A$4-80)*AI16*$A$16/1000","v":13.733358910416266},{"$f":"AC16*K16+($A$4-80)*AJ16*$A$16/1000","v":13.638979474390947},{"$f":"AD16*M16+($A$4-80)*AK16*$A$16/1000","v":13.544600038365624},{"$f":"AE16*O16+($A$4-80)*AL16*$A$16/1000","v":11.436025321312107}]
[null,69.5,27.033953577594474,16.242470746211396,27.572606944178016,16.606176865528486,26.70938039516593,16.304623057740262,{"$f":"U17*$I$14","v":25.118741607519663},15.671590255131402,24.30385574525225,15.359677728755033,23.488969882984843,15.047765202378669,19.934778438519086,13.383464415883369,null,1.1264147323997697,1.148858622674084,1.1128908497985803,1.0466142336466526,1.0126606560521771,0.97870707845770177,0.83061576827162853,0.60081743869209814,0.60227082985473368,0.61044557442040848,0.62390029325513197,0.63198522447433225,0.64063112504900044,0.67136258660508086,0.98757763975155222,1.0161490683229812,1.0583850931677024,1.0360248447204974,0.95217391304347898,0.8683229813664598,1.0360248447204969,{"$f":"Y17*C17+($A$4-80)*AF17*$A$16/1000","v":16.242470746211396},{"$f":"Z17*E17+($A$4-80)*AG17*$A$16/1000","v":16.606176865528486},{"$f":"AA17*G17+($A$4-80)*AH17*$A$16/1000","v":16.304623057740262},{"$f":"AB17*I17+($A$4-80)*AI17*$A$16/1000","v":15.671590255131402},{"$f":"AC17*K17+($A$4-80)*AJ17*$A$16/1000","v":15.359677728755033},{"$f":"AD17*M17+($A$4-80)*AK17*$A$16/1000","v":15.047765202378669},{"$f":"AE17*O17+($A$4-80)*AL17*$A$16/1000","v":13.383464415883369}]
[null,67,26.619604834068674,18.240552464991367,26.845194705543832,18.590446959524268,25.906004220218684,18.332629963552655,{"$f":"U18*$I$14","v":24.092077498561288},17.609821599846537,22.901975829656628,17.080375983119126,21.711874160751965,16.550930366391714,19.124496451179741,15.330903510454631,null,1.109150201419528,1.1185497793976598,1.0794168425091117,1.0038365624400536,0.95424899290235943,0.90466142336466515,0.79685401879915585,0.685230024213075,0.69250557365803467,0.70765949884485513,0.73093827632333275,0.74580359835159316,0.76229855810008496,0.80163697640828113,0.98757763975155222,1.0161490683229812,1.0583850931677024,1.0360248447204974,0.95217391304347898,0.8683229813664598,1.0360248447204969,{"$f":"Y18*C18+($A$4-80)*AF18*$A$16/1000","v":18.240552464991367},{"$f":"Z18*E18+($A$4-80)*AG18*$A$16/1000","v":18.590446959524268},{"$f":"AA18*G18+($A$4-80)*AH18*$A$16/1000","v":18.332629963552655},{"$f":"AB18*I18+($A$4-80)*AI18*$A$16/1000","v":17.609821599846537},{"$f":"AC18*K18+($A$4-80)*AJ18*$A$16/1000","v":17.080375983119126},{"$f":"AD18*M18+($A$4-80)*AK18*$A$16/1000","v":16.550930366391714},{"$f":"AE18*O18+($A$4-80)*AL18*$A$16/1000","v":15.330903510454631}]
[null,62,25.035871858814502,21.969691156723574,24.455783617878382,21.92365240744293,23.511989257625167,21.504699788989065,{"$f":"U19*$I$14","v":22.273546901975827},20.763475925570685,21.54843660080568,20.261653558411666,20.823326299635525,19.759831191252637,17.872242470746208,17.246115480529443,null,1.0431613274506042,1.0189909840782658,0.97966621906771534,0.92806445424899287,0.89785152503356991,0.86763859581814684,0.74467676961442542,0.87752850312614927,0.89646084337349397,0.91462698257293906,0.93220338983050843,0.94028415767546214,0.94892770285208938,0.96496651210716122,0.98757763975155222,1.0161490683229812,1.0583850931677024,1.0360248447204974,0.95217391304347898,0.8683229813664598,1.0360248447204969,{"$f":"Y19*C19+($A$4-80)*AF19*$A$16/1000","v":21.969691156723574},{"$f":"Z19*E19+($A$4-80)*AG19*$A$16/1000","v":21.92365240744293},{"$f":"AA19*G19+($A$4-80)*AH19*$A$16/1000","v":21.504699788989065},{"$f":"AB19*I19+($A$4-80)*AI19*$A$16/1000","v":20.763475925570685},{"$f":"AC19*K19+($A$4-80)*AJ19*$A$16/1000","v":20.261653558411666},{"$f":"AD19*M19+($A$4-80)*AK19*$A$16/1000","v":19.759831191252637},{"$f":"AE19*O19+($A$4-80)*AL19*$A$16/1000","v":17.246115480529443}]

{"sheet":"PSA4BG_60","index":6,"n_rows":19,"n_cols":45,"rows_kept":19,"cut":false,"hidden":true,"merged":[[130,0,133,0],[120,12,121,12],[120,13,121,13],[120,14,121,14],[120,15,121,15],[122,0,125,0],[126,0,129,0],[119,12,119,13],[119,14,119,15],[120,4,121,4],[120,5,121,5],[120,6,121,6],[120,7,121,7],[120,8,121,8],[120,9,121,9],[120,10,121,10],[120,11,121,11],[119,0,121,0],[119,1,121,1],[119,4,119,5],[119,6,119,7],[119,8,119,9],[119,10,119,11],[111,0,114,0],[117,0,118,1],[117,4,117,15],[118,4,118,5],[118,6,118,7],[118,8,118,9],[118,10,118,11],[118,12,118,13],[118,14,118,15],[101,12,102,12],[101,13,102,13],[101,14,102,14],[101,15,102,15],[103,0,106,0],[107,0,110,0],[100,12,100,13],[100,14,100,15],[101,4,102,4],[101,5,102,5],[101,6,102,6],[101,7,102,7],[101,8,102,8],[101,9,102,9],[101,10,102,10],[101,11,102,11],[100,0,102,0],[100,1,102,1],[100,4,100,5],[100,6,100,7],[100,8,100,9],[100,10,100,11],[92,0,95,0],[98,0,99,1],[98,4,98,15],[99,4,99,5],[99,6,99,7],[99,8,99,9],[99,10,99,11],[99,12,99,13],[99,14,99,15],[82,12,83,12],[82,13,83,13],[82,14,83,14],[82,15,83,15],[84,0,87,0],[88,0,91,0],[81,12,81,13],[81,14,81,15],[82,4,83,4],[82,5,83,5],[82,6,83,6],[82,7,83,7],[82,8,83,8],[82,9,83,9],[82,10,83,10],[82,11,83,11],[81,0,83,0],[81,1,83,1],[81,4,81,5],[81,6,81,7],[81,8,81,9],[81,10,81,11],[73,0,76,0],[79,0,80,1],[79,4,79,15],[80,4,80,5],[80,6,80,7],[80,8,80,9],[80,10,80,11],[80,12,80,13],[80,14,80,15],[63,12,64,12],[63,13,64,13],[63,14,64,14],[63,15,64,15],[65,0,68,0],[69,0,72,0],[62,12,62,13],[62,14,62,15],[63,4,64,4],[63,5,64,5],[63,6,64,6],[63,7,64,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[63,11,64,11],[62,0,64,0],[62,1,64,1],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[54,0,57,0],[60,0,61,1],[60,4,60,15],[61,4,61,5],[61,6,61,7],[61,8,61,9],[61,10,61,11],[61,12,61,13],[61,14,61,15],[44,12,45,12],[44,13,45,13],[44,14,45,14],[44,15,45,15],[46,0,49,0],[50,0,53,0],[43,12,43,13],[43,14,43,15],[44,4,45,4],[44,5,45,5],[44,6,45,6],[44,7,45,7],[44,8,45,8],[44,9,45,9],[44,10,45,10],[44,11,45,11],[43,0,45,0],[43,1,45,1],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[35,0,38,0],[41,0,42,1],[41,4,41,15],[42,4,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,11],[42,12,42,13],[42,14,42,15],[25,12,26,12],[25,13,26,13],[25,14,26,14],[25,15,26,15],[27,0,30,0],[31,0,34,0],[24,12,24,13],[24,14,24,15],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[25,8,26,8],[25,9,26,9],[25,10,26,10],[25,11,26,11],[24,0,26,0],[24,1,26,1],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[7,0,10,0],[11,0,14,0],[15,0,18,0],[22,4,22,15],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[5,15,6,15],[4,10,4,11],[4,12,4,13],[4,14,4,15],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[4,0,6,0],[4,1,6,1],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[5,9,6,9],[2,0,2,1],[2,2,2,15],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15]]}
[]
["PSA4BG_60"]
["Evaporator Air \n",null,"Condenser  Entering Air Temperature ˚F"]
[80,"°F DB",65,null,75,null,85,null,95,null,100,null,105,null,115]
["CFM","EWB†\n˚F","Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh"]
[null,null,"Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Factors",null,null,null,null,null,null,"Sens. %",null,null,null,null,null,null,"IDB Adj",null,null,null,null,null,null,"Sens Calc"]
[1480,72,{"$f":"R8*$I$14","v":27.590187590187593},{"$f":"IF(AM8>C8,C8,AM8)","v":14.183742183742186},{"$f":"S8*$I$14","v":27.617123617123617},{"$f":"IF(AN8>E8,E8,AN8)","v":13.956709956709959},{"$f":"T8*$I$14","v":26.901394901394902},{"$f":"IF(AO8>G8,G8,AO8)","v":13.444925444925445},{"$f":"U8*$I$14","v":25.685425685425685},{"$f":"IF(AP8>I8,I8,AP8)","v":12.767676767676768},{"$f":"V8*$I$14","v":24.944684944684944},{"$f":"IF(AQ8>K8,K8,AQ8)","v":12.402116402116404},{"$f":"W8*$I$14","v":24.203944203944204},{"$f":"IF(AR8>M8,M8,AR8)","v":12.036556036556037},{"$f":"X8*$I$14","v":22.695526695526695},{"$f":"IF(AS8>O8,O8,AS8)","v":11.359307359307358},null,1.1495911495911497,1.1507134840468174,1.1208914542247876,1.0702260702260702,1.0393618726952061,1.0084976751643417,0.94564694564694562,0.51408647140864716,0.50536435836700577,0.49978543842082679,0.49707865168539328,0.49718472811415354,0.49729729729729732,0.50050864699898268,1.1148648648648647,1.0702702702702704,1.0662162162162161,1.0797297297297299,1.082432432432433,1.0851351351351355,1.0554054054054058,{"$f":"Y8*C8+($A$4-80)*AF8*$A$8/1000","v":14.183742183742186},{"$f":"Z8*E8+($A$4-80)*AG8*$A$8/1000","v":13.956709956709959},{"$f":"AA8*G8+($A$4-80)*AH8*$A$8/1000","v":13.444925444925445},{"$f":"AB8*I8+($A$4-80)*AI8*$A$8/1000","v":12.767676767676768},{"$f":"AC8*K8+($A$4-80)*AJ8*$A$8/1000","v":12.402116402116404},{"$f":"AD8*M8+($A$4-80)*AK8*$A$8/1000","v":12.036556036556037},{"$f":"AE8*O8+($A$4-80)*AL8*$A$8/1000","v":11.359307359307358}]
[null,69.5,27.091871091871091,15.465127465127464,26.776334776334778,15.20923520923521,25.906685906685901,14.728234728234726,24.658008658008654,14.108706108706105,23.931697931697933,13.77008177008177,23.205387205387204,13.43145743145743,21.721981721981724,12.783068783068781,null,1.1288279621612956,1.1156806156806158,1.0794452461119126,1.0274170274170273,0.99715408048741394,0.96689113355780021,0.90508257174923845,0.57084013919465948,0.56801034705755549,0.56851095432603049,0.57217540574282144,0.57539092334284681,0.57880772738578889,0.58848538529672267,1.1148648648648647,1.0702702702702704,1.0662162162162161,1.0797297297297299,1.082432432432433,1.0851351351351355,1.0554054054054058,{"$f":"Y9*C9+($A$4-80)*AF9*$A$8/1000","v":15.465127465127464},{"$f":"Z9*E9+($A$4-80)*AG9*$A$8/1000","v":15.20923520923521},{"$f":"AA9*G9+($A$4-80)*AH9*$A$8/1000","v":14.728234728234726},{"$f":"AB9*I9+($A$4-80)*AI9*$A$8/1000","v":14.108706108706105},{"$f":"AC9*K9+($A$4-80)*AJ9*$A$8/1000","v":13.77008177008177},{"$f":"AD9*M9+($A$4-80)*AK9*$A$8/1000","v":13.43145743145743},{"$f":"AE9*O9+($A$4-80)*AL9*$A$8/1000","v":12.783068783068781}]
[null,67,26.593554593554593,16.746512746512746,25.935545935545939,16.461760461760463,24.911976911976915,16.011544011544014,23.630591630591631,15.449735449735451,22.918710918710921,15.13804713804714,22.206830206830208,14.826358826358828,20.748436748436752,14.206830206830208,null,1.1080647747314414,1.080647747314414,1.037999037999038,0.9846079846079846,0.95494628827962169,0.92528459195125867,0.86451819785153128,0.62972073506004922,0.63471810089020764,0.64272474513438371,0.6538023123269826,0.66051040967092012,0.66764858776641833,0.68471810089020768,1.1148648648648647,1.0702702702702704,1.0662162162162161,1.0797297297297299,1.082432432432433,1.0851351351351355,1.0554054054054058,{"$f":"Y10*C10+($A$4-80)*AF10*$A$8/1000","v":16.746512746512746},{"$f":"Z10*E10+($A$4-80)*AG10*$A$8/1000","v":16.461760461760463},{"$f":"AA10*G10+($A$4-80)*AH10*$A$8/1000","v":16.011544011544014},{"$f":"AB10*I10+($A$4-80)*AI10*$A$8/1000","v":15.449735449735451},{"$f":"AC10*K10+($A$4-80)*AJ10*$A$8/1000","v":15.13804713804714},{"$f":"AD10*M10+($A$4-80)*AK10*$A$8/1000","v":14.826358826358828},{"$f":"AE10*O10+($A$4-80)*AL10*$A$8/1000","v":14.206830206830208}]
[null,62,24.611832611832611,19.763347763347763,23.688311688311693,19.247715247715252,22.664742664742665,18.735930735930737,21.54882154882155,18.220298220298222,20.94853294853295,17.950937950937956,20.34824434824435,17.681577681577686,19.070707070707073,17.104377104377107,null,1.0254930254930255,0.98701298701298712,0.944364277697611,0.89786756453423122,0.87285553952220618,0.84784351451018125,0.79461279461279466,0.80300187617260788,0.81254061078622486,0.82665534804753815,0.84553571428571428,0.85690668626010302,0.86894856278366117,0.89689265536723162,1.1148648648648647,1.0702702702702704,1.0662162162162161,1.0797297297297299,1.082432432432433,1.0851351351351355,1.0554054054054058,{"$f":"Y11*C11+($A$4-80)*AF11*$A$8/1000","v":19.763347763347763},{"$f":"Z11*E11+($A$4-80)*AG11*$A$8/1000","v":19.247715247715252},{"$f":"AA11*G11+($A$4-80)*AH11*$A$8/1000","v":18.735930735930737},{"$f":"AB11*I11+($A$4-80)*AI11*$A$8/1000","v":18.220298220298222},{"$f":"AC11*K11+($A$4-80)*AJ11*$A$8/1000","v":17.950937950937956},{"$f":"AD11*M11+($A$4-80)*AK11*$A$8/1000","v":17.681577681577686},{"$f":"AE11*O11+($A$4-80)*AL11*$A$8/1000","v":17.104377104377107}]
[1610,72,27.828763828763826,14.337662337662337,28.040404040404042,14.256854256854256,27.378547378547381,13.822029822029823,26.108706108706105,13.164021164021163,25.300625300625299,12.788840788840787,24.492544492544489,12.413660413660411,22.787878787878789,11.682539682539682,null,1.1595318261984928,1.1683501683501685,1.1407728074394743,1.087862754529421,1.0541927208593875,1.0205226871893538,0.9494949494949495,0.51521017699115046,0.50843968711403864,0.5048489107519325,0.50420044215180548,0.50547528517110263,0.50683424980361347,0.51266464032421477,1.1105590062111808,1.0621118012422366,1.0571428571428567,1.0683229813664596,1.0695652173913044,1.0708074534161496,1.0360248447204974,{"$f":"Y12*C12+($A$4-80)*AF12*$A$12/1000","v":14.337662337662337},{"$f":"Z12*E12+($A$4-80)*AG12*$A$12/1000","v":14.256854256854256},{"$f":"AA12*G12+($A$4-80)*AH12*$A$12/1000","v":13.822029822029823},{"$f":"AB12*I12+($A$4-80)*AI12*$A$12/1000","v":13.164021164021163},{"$f":"AC12*K12+($A$4-80)*AJ12*$A$12/1000","v":12.788840788840787},{"$f":"AD12*M12+($A$4-80)*AK12*$A$12/1000","v":12.413660413660411},{"$f":"AE12*O12+($A$4-80)*AL12*$A$12/1000","v":11.682539682539682}]
[null,69.5,27.36892736892737,15.807599807599805,27.211159211159213,15.667147667147669,26.364598364598365,15.224627224627225,25.054353054353051,14.593554593554591,24.277056277056282,14.240500240500243,23.499759499759499,13.887445887445889,21.920153920153922,13.217893217893218,null,1.1403719737053071,1.1337983004649672,1.0985249318582653,1.0439313772647105,1.0115440115440117,0.97915664582331252,0.91333974667308004,0.57757469244288218,0.57576186099130311,0.57746478873239437,0.58247581016740901,0.58658265969250278,0.59096119207466846,0.6030018432370754,1.1105590062111808,1.0621118012422366,1.0571428571428567,1.0683229813664596,1.0695652173913044,1.0708074534161496,1.0360248447204974,{"$f":"Y13*C13+($A$4-80)*AF13*$A$12/1000","v":15.807599807599805},{"$f":"Z13*E13+($A$4-80)*AG13*$A$12/1000","v":15.667147667147669},{"$f":"AA13*G13+($A$4-80)*AH13*$A$12/1000","v":15.224627224627225},{"$f":"AB13*I13+($A$4-80)*AI13*$A$12/1000","v":14.593554593554591},{"$f":"AC13*K13+($A$4-80)*AJ13*$A$12/1000","v":14.240500240500243},{"$f":"AD13*M13+($A$4-80)*AK13*$A$12/1000","v":13.887445887445889},{"$f":"AE13*O13+($A$4-80)*AL13*$A$12/1000","v":13.217893217893218}]
[null,67,26.909090909090914,17.277537277537277,26.381914381914385,17.07744107744108,25.350649350649348,16.627224627224628,24,16.023088023088025,23.253487253487254,15.692159692159693,22.506974506974508,15.361231361231361,21.052429052429055,14.753246753246755,null,1.1212121212121213,1.099246432579766,1.0562770562770563,1,0.96889530222863562,0.93779060445727125,0.87718454385121059,0.64207064207064202,0.64731621936989503,0.6558894960534305,0.66762866762866768,0.67483038226046665,0.68250983074029747,0.70078596234692014,1.1105590062111808,1.0621118012422366,1.0571428571428567,1.0683229813664596,1.0695652173913044,1.0708074534161496,1.0360248447204974,{"$f":"Y14*C14+($A$4-80)*AF14*$A$12/1000","v":17.277537277537277},{"$f":"Z14*E14+($A$4-80)*AG14*$A$12/1000","v":17.07744107744108},{"$f":"AA14*G14+($A$4-80)*AH14*$A$12/1000","v":16.627224627224628},{"$f":"AB14*I14+($A$4-80)*AI14*$A$12/1000","v":16.023088023088025},{"$f":"AC14*K14+($A$4-80)*AJ14*$A$12/1000","v":15.692159692159693},{"$f":"AD14*M14+($A$4-80)*AK14*$A$12/1000","v":15.361231361231361},{"$f":"AE14*O14+($A$4-80)*AL14*$A$12/1000","v":14.753246753246755}]
[null,62,25.096681096681099,20.582972582972587,24.169312169312171,20.090428090428091,23.088023088023089,19.528619528619529,{"$f":"U15*$I$14","v":21.906685906685908},18.924482924482923,21.2987012987013,18.620490620490621,20.690716690716691,18.316498316498318,19.493987493987493,17.73929773929774,null,1.0456950456950458,1.0070546737213404,0.96200096200096208,0.9127785794452461,0.88744588744588748,0.86211319544652887,0.81224947891614552,0.82014719411223558,0.83123706416175769,0.84583333333333333,0.8638679079571403,0.87425474254742541,0.88525199925609077,0.9099881563363601,1.1105590062111808,1.0621118012422366,1.0571428571428567,1.0683229813664596,1.0695652173913044,1.0708074534161496,1.0360248447204974,{"$f":"Y15*C15+($A$4-80)*AF15*$A$12/1000","v":20.582972582972587},{"$f":"Z15*E15+($A$4-80)*AG15*$A$12/1000","v":20.090428090428091},{"$f":"AA15*G15+($A$4-80)*AH15*$A$12/1000","v":19.528619528619529},{"$f":"AB15*I15+($A$4-80)*AI15*$A$12/1000","v":18.924482924482923},{"$f":"AC15*K15+($A$4-80)*AJ15*$A$12/1000","v":18.620490620490621},{"$f":"AD15*M15+($A$4-80)*AK15*$A$12/1000","v":18.316498316498318},{"$f":"AE15*O15+($A$4-80)*AL15*$A$12/1000","v":17.73929773929774}]
[1805,72,28.186628186628187,14.56854256854257,28.675324675324674,14.707070707070708,28.098124098124096,14.395382395382393,{"$f":"U16*$I$14","v":26.747474747474751},13.775853775853776,25.83549783549784,13.383357383357385,24.923520923520925,12.990860990860991,22.934102934102935,12.171236171236171,null,1.1744428411095078,1.1948051948051948,1.1707551707551707,1.1144781144781146,1.0764790764790766,1.0384800384800386,0.95558762225428895,0.51686006825938569,0.51288244766505642,0.51232539030402624,0.51503380808516752,0.51802204349121239,0.5212289640265555,0.53070469798657716,1.1700831024930751,1.1534626038781168,1.0891966759002769,1.0193905817174518,0.98891966759002814,0.9584487534626045,0.8354570637119112,{"$f":"Y16*C16+($A$4-80)*AF16*$A$16/1000","v":14.56854256854257},{"$f":"Z16*E16+($A$4-80)*AG16*$A$16/1000","v":14.707070707070708},{"$f":"AA16*G16+($A$4-80)*AH16*$A$16/1000","v":14.395382395382393},{"$f":"AB16*I16+($A$4-80)*AI16*$A$16/1000","v":13.775853775853776},{"$f":"AC16*K16+($A$4-80)*AJ16*$A$16/1000","v":13.383357383357385},{"$f":"AD16*M16+($A$4-80)*AK16*$A$16/1000","v":12.990860990860991},{"$f":"AE16*O16+($A$4-80)*AL16*$A$16/1000","v":12.171236171236171}]
[null,69.5,27.763347763347767,16.332852332852333,27.830687830687829,16.375180375180378,27.03799903799904,16.001924001923999,{"$f":"U17*$I$14","v":25.650793650793652},15.35930735930736,24.797498797498797,14.975468975468978,23.944203944203945,14.591630591630594,22.195286195286194,13.84126984126984,null,1.1568061568061569,1.1596119929453261,1.12658329324996,1.0687830687830688,1.0332291165624499,0.99767516434183101,0.92480359147025815,0.58828828828828827,0.58838575872796417,0.59183092578097196,0.59878487848784878,0.6039104628156885,0.60940136601044603,0.6236130374479889,1.1700831024930751,1.1534626038781168,1.0891966759002769,1.0193905817174518,0.98891966759002814,0.9584487534626045,0.8354570637119112,{"$f":"Y17*C17+($A$4-80)*AF17*$A$16/1000","v":16.332852332852333},{"$f":"Z17*E17+($A$4-80)*AG17*$A$16/1000","v":16.375180375180378},{"$f":"AA17*G17+($A$4-80)*AH17*$A$16/1000","v":16.001924001923999},{"$f":"AB17*I17+($A$4-80)*AI17*$A$16/1000","v":15.35930735930736},{"$f":"AC17*K17+($A$4-80)*AJ17*$A$16/1000","v":14.975468975468978},{"$f":"AD17*M17+($A$4-80)*AK17*$A$16/1000","v":14.591630591630594},{"$f":"AE17*O17+($A$4-80)*AL17*$A$16/1000","v":13.84126984126984}]
[null,67,27.340067340067343,18.097162097162101,26.986050986050984,18.043290043290042,25.977873977873983,17.608465608465611,{"$f":"U18*$I$14","v":24.554112554112557},16.942760942760945,23.759499759499764,16.567580567580571,22.964886964886965,16.192400192400193,21.456469456469456,15.511303511303513,null,1.1391694725028059,1.1244187910854577,1.0824114157447493,1.0230880230880233,0.98997915664582348,0.95687029020362357,0.89401956068622734,0.66192821956368764,0.66861542848994726,0.677825507332247,0.69001723867732334,0.69730342537857315,0.70509383378016088,0.722919655667145,1.1700831024930751,1.1534626038781168,1.0891966759002769,1.0193905817174518,0.98891966759002814,0.9584487534626045,0.8354570637119112,{"$f":"Y18*C18+($A$4-80)*AF18*$A$16/1000","v":18.097162097162101},{"$f":"Z18*E18+($A$4-80)*AG18*$A$16/1000","v":18.043290043290042},{"$f":"AA18*G18+($A$4-80)*AH18*$A$16/1000","v":17.608465608465611},{"$f":"AB18*I18+($A$4-80)*AI18*$A$16/1000","v":16.942760942760945},{"$f":"AC18*K18+($A$4-80)*AJ18*$A$16/1000","v":16.567580567580571},{"$f":"AD18*M18+($A$4-80)*AK18*$A$16/1000","v":16.192400192400193},{"$f":"AE18*O18+($A$4-80)*AL18*$A$16/1000","v":15.511303511303513}]
[null,62,25.823953823953826,21.845117845117848,24.892736892736892,21.391053391053394,23.719095719095719,20.744588744588743,{"$f":"U19*$I$14","v":22.445406445406444},20.005772005772005,21.823953823953826,19.647907647907648,21.202501202501203,19.29004329004329,20.125060125060124,18.712842712842711,null,1.0759980759980761,1.0371973705307038,0.98829565496232163,0.93522526855860189,0.90933140933140943,0.88343755010421687,0.83854417187750518,0.84592460140068548,0.85932910805379514,0.87459441920830627,0.89130807474712848,0.90029092832583968,0.90980036297640654,0.92982791586998093,1.1700831024930751,1.1534626038781168,1.0891966759002769,1.0193905817174518,0.98891966759002814,0.9584487534626045,0.8354570637119112,{"$f":"Y19*C19+($A$4-80)*AF19*$A$16/1000","v":21.845117845117848},{"$f":"Z19*E19+($A$4-80)*AG19*$A$16/1000","v":21.391053391053394},{"$f":"AA19*G19+($A$4-80)*AH19*$A$16/1000","v":20.744588744588743},{"$f":"AB19*I19+($A$4-80)*AI19*$A$16/1000","v":20.005772005772005},{"$f":"AC19*K19+($A$4-80)*AJ19*$A$16/1000","v":19.647907647907648},{"$f":"AD19*M19+($A$4-80)*AK19*$A$16/1000","v":19.29004329004329},{"$f":"AE19*O19+($A$4-80)*AL19*$A$16/1000","v":18.712842712842711}]

{"sheet":"Form","index":7,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":true,"merged":[[1,3,1,8],[2,3,2,8],[13,0,13,15],[26,14,26,15],[26,10,26,11],[18,6,18,11],[26,4,26,5],[26,12,26,13],[26,8,26,9],[25,2,25,15],[25,0,25,1],[26,2,26,3],[17,6,17,11],[26,6,26,7],[52,1,52,4],[28,2,29,2],[28,3,29,3],[28,9,29,9],[28,8,29,8],[27,1,29,1],[27,2,27,3],[27,6,27,7],[46,9,46,14],[38,0,41,0],[27,12,27,13],[28,4,29,4],[28,5,29,5],[28,6,29,6],[28,7,29,7],[30,0,33,0],[27,8,27,9],[27,10,27,11],[28,12,29,12],[27,0,29,0],[28,11,29,11],[28,15,29,15],[27,4,27,5],[34,0,37,0],[28,13,29,13],[28,10,29,10],[27,14,27,15],[28,14,29,14]]}
[]
[null,null,"Select Maytag Condenser:  ",null,null,null,null,null,null,"Second Stage (Boost Speed C5) Cooling"]
[null,null,"ADP Evaporator:  ",null,null,null,null,null,null,null,null,null,null,24]
[null,null,"Nominal Capacity:  ",null,"(Mbtuh)",null,null,null,null,null,null,"Condenser Entering Air Temperature: ",null,"(°F) Dry Bulb, 65°F to 115°F"]
[null,null,"AHRI Rated Capacity:  ",null,"(Mbtuh) @ 95 ˚F & 80/67 ˚F conditions",null,null,null,null,null,null,"Evaporator Air Flow (CFM): ",null,null,"to"]
[null,null,"Entering Evaporator Air (DB):  ",null,"(°F) Dry Bulb -- 80°F Standard",null,null,null,null,null,null,"Entering Evaporator Air (WB):  ",null,"(°F) Wet Bulb, 62°F to 72°F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CFM"]
[]
[]
[]
[]
[]
["Extended Ratings"]
[]
[]
[]
[null,null,null,null,null,"Maytag Condenser :  "]
[null,null,null,null,null,"ADP Evaporator:  "]
[null,null,null,null,null,"Condenser Entering Air Temperature: ",null,"(°F) Dry Bulb, 65°F to 115°F"]
[null,null,null,null,null,"Evaporator Air Flow:",null,"CFM"]
[null,null,null,null,null,"Entering Evaporator Air (DB):  ",null,"(°F) Dry Bulb"]
[null,null,null,null,null,"Entering Evaporator Air (WB):  ",null,"(°F) Wet Bulb, 62°F to 72°F"]
[null,null,null,null,null,"AHRI Rated Capacity:  ",null,"(Mbtuh) @ 95 ˚F & 80/67 ˚F conditions"]
[]
["Evaporator Air \n",null,"Condenser  Entering Air Temperature ˚F"]
[80,"°F DB",65,null,75,null,85,null,95,null,100,null,105,null,115]
["CFM","EWB†\n˚F","Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh"]
[null,null,"Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Condenser Entering Air Temperature: ",null,"(°F) Dry Bulb, 65°F to 115°F",null,null,null,"CAPACITY IN MBTUH UNDER SPECIFIC CONDITIONS LISTED"]
[null,null,null,"Evaporator Air Flow:",null,"CFM",null,null,null,null,"TOTAL"]
[null,null,null,"Entering Evaporator Air (WB):  ",null,"(°F) Wet Bulb, 62°F to 72°F",null,null,null,null,"SENSIBLE"]
[null,null,null,null,null,null,null,null,null,"Second Stage (Boost Speed C5) Cooling"]
["Notes:","† Entering Wet Bulb"]
[null,"Extended ratings are not certified.  They are calculated based upon typical condenser performance curves and are for engineering information only."]
[null,"When the required data fall between the published data, interpolation may be performed. Extrapolation is not an acceptable practice."]
[null,"Displayed sensible capacity has been adjusted based upon indoor DB.  Sensible capacity will increase with higher indoor DB and decrease with lower indoor DB."]
[null,"The magnitude of the adjustment depends partially on evaporator air flow, with greater adjustment at higher CFM."]
["Printed:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MP-19-A"]

{"sheet":"Instructions","index":8,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"This spreadsheet generates capacity information for ADP rated matches at other than nominal conditions."]
[null,"The information is provided is not certified and is provided for engineering use only."]
[]
[null,"The latest version will allways be available at:  www.adpnow.com/extratings/"]
[]
[null,"In order to generate an extended rating, you will need the following information:"]
[null,null,"Condenser model number"]
[null,null,"ADP coil model number"]
[null,null,"Nominal capacity"]
[null,null,"Rated capacity (from AHRI database)"]
[null,null,"Condenser entering air dry bulb temperature"]
[null,null,"Indoor entering air dry bulb temperature"]
[null,null,"Indoor entering air wet bulb temperature"]
[null,null,"Indoor airflow"]
[]
[null,"Select the condenser series and nominal tonnage form the drop down lists."]
[null,"Enter the remaining information in the correct cells. Note there are limits on the range of values allowed."]
[null,"Click on \"Calculate\" to calculate the extended ratings."]
[null,"The table will show capacities for various conditions.  The capacities at the specific design point are "]
[null,"at the bottom of the page."]
[null,"From this point you may:"]
[null,null,"Click \"Clear\" to clear the form and start over."]
[null,null,"Click \"Print\" to print a copy of the data."]
[null,null,"Click \"Copy\" to copy the data to a new spreadsheet and save it in the same directory."]
[]
[null,"Notes:","Displayed sensible capacity has been adjusted based upon indoor DB. Sensible capacity will"]
[null,null,"increase with higher indoor DB and decrease with lower indoor DB.  The magnitude of the "]
[null,null,"adjustment depends partially on evaporator air flow, with greater adjustment at higher CFM."]
[]
[null,"Versions:","MP-15-A","2015-05-01","Initial public release"]
[null,null,"MP-16-A","2016-03-22","Renewed date key through 2016"]
[null,null,"MP-19-A","2019-05-20","New Version"]

{"sheet":"Prompt","index":9,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"In order to use this spreadsheet, "]
[null,"Please enable Macros in your security settings."]
[]
[null,"Enabling Macros in Excel 2007"]
[null,"1. In Excel, click the Office button in the upper left corner of the screen."]
[null,"2. Click the \"Excel Options\" button in the lower right."]
[null,"3. Click the \"Trust Center\" button on the left. Then, at the bottom right, select \"Trust Center Settings\" as shown below."]
[null,"4. In the next window, select \"Macro Settings,\" then select the radio button for \"Disable all macros with notification.\""]
[null,"5. When openning this spreadsheet, you will see a warning like this in the menu bar:"]
[]
[]
[null,"6. Select \"Enable this content\" and click \"Okay\".  The spreadsheet will now be functional."]

{"sheet":"Sheet1","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}