{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["notes","Options","Calcs","PSH4BG_24","PSH4BG_36","PSH4BG_48","PSH4BG_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":80},{"$f":"Form!I27","v":85},{"$f":"Form!K27","v":90},{"$f":"Form!M27","v":95},{"$f":"Form!O27","v":105}]
[{"$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},80,85,90,95,105]
[{"$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":[]}
["PSH4BG"]

{"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":"PSH4BG_24","index":3,"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]]}
[]
["PSH4BG_24F_24"]
["Evaporator Air \n",null,"Condenser  Entering Air Temperature ˚F"]
[80,"°F DB",65,null,75,null,80,null,85,null,90,null,95,null,105]
["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*$M$14","v":29.961290322580648},{"$f":"IF(AM8>C8,C8,AM8)","v":14.022580645161293},{"$f":"S8*$M$14","v":28.91612903225807},{"$f":"IF(AN8>E8,E8,AN8)","v":13.587096774193549},{"$f":"T8*$M$14","v":28.306451612903228},{"$f":"IF(AO8>G8,G8,AO8)","v":13.369354838709679},{"$f":"U8*$M$14","v":27.696774193548389},{"$f":"IF(AP8>I8,I8,AP8)","v":13.151612903225807},{"$f":"V8*$M$14","v":27.000000000000004},{"$f":"IF(AQ8>K8,K8,AQ8)","v":12.933870967741937},{"$f":"W8*$M$14","v":26.303225806451614},{"$f":"IF(AR8>M8,M8,AR8)","v":12.716129032258065},{"$f":"X8*$M$14","v":24.822580645161292},{"$f":"IF(AS8>O8,O8,AS8)","v":12.193548387096774},null,1.2329749103942653,1.1899641577060933,1.1648745519713262,1.1397849462365592,1.1111111111111112,1.0824372759856631,1.021505376344086,0.46802325581395354,0.46987951807228912,0.47230769230769232,0.47484276729559749,0.4790322580645161,0.48344370860927155,0.49122807017543857,1.0285714285714291,0.94285714285714306,0.91428571428571515,0.88571428571428623,0.87142857142857166,0.8571428571428571,0.8571428571428571,{"$f":"Y8*C8+($A$4-80)*AF8*$A$8/1000","v":14.022580645161293},{"$f":"Z8*E8+($A$4-80)*AG8*$A$8/1000","v":13.587096774193549},{"$f":"AA8*G8+($A$4-80)*AH8*$A$8/1000","v":13.369354838709679},{"$f":"AB8*I8+($A$4-80)*AI8*$A$8/1000","v":13.151612903225807},{"$f":"AC8*K8+($A$4-80)*AJ8*$A$8/1000","v":12.933870967741937},{"$f":"AD8*M8+($A$4-80)*AK8*$A$8/1000","v":12.716129032258065},{"$f":"AE8*O8+($A$4-80)*AL8*$A$8/1000","v":12.193548387096774}]
[null,69.5,{"$f":"R9*$M$14","v":28.567741935483873},15.590322580645164,{"$f":"S9*$M$14","v":27.435483870967744},15.111290322580647,{"$f":"T9*$M$14","v":26.825806451612905},14.893548387096777,{"$f":"U9*$M$14","v":26.216129032258067},14.675806451612907,{"$f":"V9*$M$14","v":25.58467741935484},14.436290322580644,{"$f":"W9*$M$14","v":24.953225806451613},14.196774193548388,{"$f":"X9*$M$14","v":23.603225806451615},13.717741935483872,null,1.1756272401433692,1.1290322580645162,1.1039426523297491,1.0788530465949822,1.0528673835125448,1.0268817204301075,0.97132616487455203,0.54573170731707321,0.55079365079365084,0.55519480519480524,0.5598006644518273,0.56425531914893612,0.56893542757417104,0.58118081180811809,1.0285714285714291,0.94285714285714306,0.91428571428571515,0.88571428571428623,0.87142857142857166,0.8571428571428571,0.8571428571428571,{"$f":"Y9*C9+($A$4-80)*AF9*$A$8/1000","v":15.590322580645164},{"$f":"Z9*E9+($A$4-80)*AG9*$A$8/1000","v":15.111290322580647},{"$f":"AA9*G9+($A$4-80)*AH9*$A$8/1000","v":14.893548387096777},{"$f":"AB9*I9+($A$4-80)*AI9*$A$8/1000","v":14.675806451612907},{"$f":"AC9*K9+($A$4-80)*AJ9*$A$8/1000","v":14.436290322580644},{"$f":"AD9*M9+($A$4-80)*AK9*$A$8/1000","v":14.196774193548388},{"$f":"AE9*O9+($A$4-80)*AL9*$A$8/1000","v":13.717741935483872}]
[null,67,27.174193548387102,17.158064516129034,25.954838709677421,16.635483870967743,25.345161290322586,16.417741935483875,24.735483870967744,16.200000000000006,24.16935483870968,15.938709677419357,23.603225806451615,15.677419354838712,22.383870967741938,15.24193548387097,null,1.1182795698924732,1.0681003584229392,1.0430107526881722,1.0179211469534051,0.9946236559139785,0.97132616487455203,0.92114695340501795,0.63141025641025639,0.64093959731543626,0.64776632302405501,0.65492957746478886,0.6594594594594595,0.66420664206642066,0.68093385214007784,1.0285714285714291,0.94285714285714306,0.91428571428571515,0.88571428571428623,0.87142857142857166,0.8571428571428571,0.8571428571428571,{"$f":"Y10*C10+($A$4-80)*AF10*$A$8/1000","v":17.158064516129034},{"$f":"Z10*E10+($A$4-80)*AG10*$A$8/1000","v":16.635483870967743},{"$f":"AA10*G10+($A$4-80)*AH10*$A$8/1000","v":16.417741935483875},{"$f":"AB10*I10+($A$4-80)*AI10*$A$8/1000","v":16.200000000000006},{"$f":"AC10*K10+($A$4-80)*AJ10*$A$8/1000","v":15.938709677419357},{"$f":"AD10*M10+($A$4-80)*AK10*$A$8/1000","v":15.677419354838712},{"$f":"AE10*O10+($A$4-80)*AL10*$A$8/1000","v":15.24193548387097}]
[null,62,25.432258064516134,20.467741935483875,24.038709677419359,19.858064516129037,23.385483870967747,19.553225806451618,22.732258064516131,19.248387096774195,22.079032258064519,18.943548387096776,21.425806451612907,18.638709677419353,20.119354838709679,18.029032258064518,null,1.0465949820788532,0.98924731182795711,0.96236559139784961,0.93548387096774199,0.90860215053763449,0.88172043010752699,0.82795698924731187,0.8047945205479452,0.82608695652173914,0.83612662942271887,0.84674329501915713,0.85798816568047331,0.86991869918699172,0.89610389610389607,1.0285714285714291,0.94285714285714306,0.91428571428571515,0.88571428571428623,0.87142857142857166,0.8571428571428571,0.8571428571428571,{"$f":"Y11*C11+($A$4-80)*AF11*$A$8/1000","v":20.467741935483875},{"$f":"Z11*E11+($A$4-80)*AG11*$A$8/1000","v":19.858064516129037},{"$f":"AA11*G11+($A$4-80)*AH11*$A$8/1000","v":19.553225806451618},{"$f":"AB11*I11+($A$4-80)*AI11*$A$8/1000","v":19.248387096774195},{"$f":"AC11*K11+($A$4-80)*AJ11*$A$8/1000","v":18.943548387096776},{"$f":"AD11*M11+($A$4-80)*AK11*$A$8/1000","v":18.638709677419353},{"$f":"AE11*O11+($A$4-80)*AL11*$A$8/1000","v":18.029032258064518}]
[800,72,30.658064516129038,14.719354838709679,29.612903225806452,14.370967741935484,28.95967741935484,14.153225806451612,28.306451612903228,13.935483870967744,27.609677419354838,13.674193548387096,26.912903225806449,13.412903225806451,25.345161290322586,12.890322580645163,null,1.2616487455197134,1.2186379928315412,1.1917562724014337,1.1648745519713262,1.1362007168458781,1.10752688172043,1.0430107526881722,0.4801136363636363,0.48529411764705882,0.48872180451127817,0.49230769230769234,0.4952681388012618,0.49838187702265374,0.50859106529209619,1,0.92499999999999982,0.89999999999999947,0.87499999999999989,0.84999999999999964,0.82499999999999929,0.82500000000000018,{"$f":"Y12*C12+($A$4-80)*AF12*$A$12/1000","v":14.719354838709679},{"$f":"Z12*E12+($A$4-80)*AG12*$A$12/1000","v":14.370967741935484},{"$f":"AA12*G12+($A$4-80)*AH12*$A$12/1000","v":14.153225806451612},{"$f":"AB12*I12+($A$4-80)*AI12*$A$12/1000","v":13.935483870967744},{"$f":"AC12*K12+($A$4-80)*AJ12*$A$12/1000","v":13.674193548387096},{"$f":"AD12*M12+($A$4-80)*AK12*$A$12/1000","v":13.412903225806451},{"$f":"AE12*O12+($A$4-80)*AL12*$A$12/1000","v":12.890322580645163}]
[null,69.5,29.351612903225814,16.461290322580648,28.21935483870968,16.025806451612905,27.587903225806453,15.808064516129031,26.956451612903226,15.590322580645161,26.281451612903222,15.329032258064515,25.606451612903225,15.067741935483873,24.212903225806453,14.588709677419356,null,1.2078853046594984,1.1612903225806452,1.1353046594982079,1.1093189964157706,1.0815412186379927,1.053763440860215,0.99641577060931907,0.56083086053412456,0.5679012345679012,0.57300710339384364,0.57835218093699514,0.58326429163214588,0.58843537414965996,0.60251798561151082,1,0.92499999999999982,0.89999999999999947,0.87499999999999989,0.84999999999999964,0.82499999999999929,0.82500000000000018,{"$f":"Y13*C13+($A$4-80)*AF13*$A$12/1000","v":16.461290322580648},{"$f":"Z13*E13+($A$4-80)*AG13*$A$12/1000","v":16.025806451612905},{"$f":"AA13*G13+($A$4-80)*AH13*$A$12/1000","v":15.808064516129031},{"$f":"AB13*I13+($A$4-80)*AI13*$A$12/1000","v":15.590322580645161},{"$f":"AC13*K13+($A$4-80)*AJ13*$A$12/1000","v":15.329032258064515},{"$f":"AD13*M13+($A$4-80)*AK13*$A$12/1000","v":15.067741935483873},{"$f":"AE13*O13+($A$4-80)*AL13*$A$12/1000","v":14.588709677419356}]
[null,67,28.045161290322586,18.203225806451616,26.825806451612905,17.680645161290322,26.216129032258067,17.462903225806453,25.606451612903225,17.245161290322581,24.953225806451613,16.983870967741936,24.3,16.72258064516129,23.080645161290324,16.287096774193547,null,1.1541218637992834,1.1039426523297491,1.0788530465949822,1.053763440860215,1.0268817204301075,1,0.94982078853046603,0.64906832298136641,0.65909090909090906,0.66611295681063121,0.67346938775510212,0.68062827225130895,0.68817204301075274,0.70566037735849052,1,0.92499999999999982,0.89999999999999947,0.87499999999999989,0.84999999999999964,0.82499999999999929,0.82500000000000018,{"$f":"Y14*C14+($A$4-80)*AF14*$A$12/1000","v":18.203225806451616},{"$f":"Z14*E14+($A$4-80)*AG14*$A$12/1000","v":17.680645161290322},{"$f":"AA14*G14+($A$4-80)*AH14*$A$12/1000","v":17.462903225806453},{"$f":"AB14*I14+($A$4-80)*AI14*$A$12/1000","v":17.245161290322581},{"$f":"AC14*K14+($A$4-80)*AJ14*$A$12/1000","v":16.983870967741936},{"$f":"AD14*M14+($A$4-80)*AK14*$A$12/1000","v":16.72258064516129},{"$f":"AE14*O14+($A$4-80)*AL14*$A$12/1000","v":16.287096774193547}]
[null,62,26.390322580645165,21.861290322580651,24.99677419354839,21.251612903225809,24.3,20.946774193548386,23.603225806451615,20.641935483870967,22.906451612903229,20.293548387096774,{"$f":"W15*$M$14","v":22.20967741935484},19.945161290322581,20.816129032258065,19.248387096774195,null,1.0860215053763442,1.0286738351254481,1,0.97132616487455203,0.94265232974910407,0.91397849462365599,0.85663082437275984,0.82838283828382842,0.85017421602787457,0.86200716845878134,0.8745387453874538,0.88593155893536113,0.89803921568627443,0.92468619246861938,1,0.92499999999999982,0.89999999999999947,0.87499999999999989,0.84999999999999964,0.82499999999999929,0.82500000000000018,{"$f":"Y15*C15+($A$4-80)*AF15*$A$12/1000","v":21.861290322580651},{"$f":"Z15*E15+($A$4-80)*AG15*$A$12/1000","v":21.251612903225809},{"$f":"AA15*G15+($A$4-80)*AH15*$A$12/1000","v":20.946774193548386},{"$f":"AB15*I15+($A$4-80)*AI15*$A$12/1000","v":20.641935483870967},{"$f":"AC15*K15+($A$4-80)*AJ15*$A$12/1000","v":20.293548387096774},{"$f":"AD15*M15+($A$4-80)*AK15*$A$12/1000","v":19.945161290322581},{"$f":"AE15*O15+($A$4-80)*AL15*$A$12/1000","v":19.248387096774195}]
[900,72,31.35483870967742,15.416129032258064,30.222580645161294,15.067741935483872,29.612903225806452,14.85,29.003225806451614,14.632258064516131,28.262903225806458,14.414516129032261,27.522580645161291,14.196774193548388,25.86774193548387,13.587096774193549,null,1.2903225806451613,1.2437275985663083,1.2186379928315412,1.1935483870967742,1.1630824372759858,1.1326164874551972,1.064516129032258,0.49166666666666664,0.49855907780979825,0.50147058823529411,0.50450450450450457,0.51001540832049308,0.51582278481012656,0.5252525252525253,0.97777777777777841,0.91111111111111143,0.88888888888888895,0.86666666666666625,0.83333333333333337,0.80000000000000038,0.80000000000000038,{"$f":"Y16*C16+($A$4-80)*AF16*$A$16/1000","v":15.416129032258064},{"$f":"Z16*E16+($A$4-80)*AG16*$A$16/1000","v":15.067741935483872},{"$f":"AA16*G16+($A$4-80)*AH16*$A$16/1000","v":14.85},{"$f":"AB16*I16+($A$4-80)*AI16*$A$16/1000","v":14.632258064516131},{"$f":"AC16*K16+($A$4-80)*AJ16*$A$16/1000","v":14.414516129032261},{"$f":"AD16*M16+($A$4-80)*AK16*$A$16/1000","v":14.196774193548388},{"$f":"AE16*O16+($A$4-80)*AL16*$A$16/1000","v":13.587096774193549}]
[null,69.5,30.222580645161294,17.41935483870968,29.133870967741942,17.11451612903226,28.545967741935485,16.896774193548389,27.958064516129031,16.679032258064517,27.23951612903226,16.43951612903226,26.52096774193549,16.200000000000003,24.866129032258065,15.546774193548391,null,1.2437275985663083,1.198924731182796,1.174731182795699,1.150537634408602,1.120967741935484,1.0913978494623657,1.0232974910394266,0.57636887608069165,0.58744394618834073,0.59191456903127382,0.59657320872274144,0.60351718625099915,0.61083743842364535,0.62521891418563935,0.97777777777777841,0.91111111111111143,0.88888888888888895,0.86666666666666625,0.83333333333333337,0.80000000000000038,0.80000000000000038,{"$f":"Y17*C17+($A$4-80)*AF17*$A$16/1000","v":17.41935483870968},{"$f":"Z17*E17+($A$4-80)*AG17*$A$16/1000","v":17.11451612903226},{"$f":"AA17*G17+($A$4-80)*AH17*$A$16/1000","v":16.896774193548389},{"$f":"AB17*I17+($A$4-80)*AI17*$A$16/1000","v":16.679032258064517},{"$f":"AC17*K17+($A$4-80)*AJ17*$A$16/1000","v":16.43951612903226},{"$f":"AD17*M17+($A$4-80)*AK17*$A$16/1000","v":16.200000000000003},{"$f":"AE17*O17+($A$4-80)*AL17*$A$16/1000","v":15.546774193548391}]
[null,67,29.090322580645161,19.422580645161293,28.045161290322586,19.161290322580648,27.479032258064521,18.943548387096776,26.912903225806449,18.725806451612904,26.216129032258067,18.464516129032258,25.519354838709678,18.203225806451613,23.86451612903226,17.506451612903227,null,1.1971326164874552,1.1541218637992834,1.1308243727598568,1.10752688172043,1.0788530465949822,1.0501792114695341,0.98207885304659504,0.66766467065868274,0.68322981366459623,0.68938193343898568,0.69579288025889974,0.70431893687707636,0.71331058020477811,0.73357664233576647,0.97777777777777841,0.91111111111111143,0.88888888888888895,0.86666666666666625,0.83333333333333337,0.80000000000000038,0.80000000000000038,{"$f":"Y18*C18+($A$4-80)*AF18*$A$16/1000","v":19.422580645161293},{"$f":"Z18*E18+($A$4-80)*AG18*$A$16/1000","v":19.161290322580648},{"$f":"AA18*G18+($A$4-80)*AH18*$A$16/1000","v":18.943548387096776},{"$f":"AB18*I18+($A$4-80)*AI18*$A$16/1000","v":18.725806451612904},{"$f":"AC18*K18+($A$4-80)*AJ18*$A$16/1000","v":18.464516129032258},{"$f":"AD18*M18+($A$4-80)*AK18*$A$16/1000","v":18.203225806451613},{"$f":"AE18*O18+($A$4-80)*AL18*$A$16/1000","v":17.506451612903227}]
[null,62,25.114525139664806,21.503810662716191,23.756983240223466,20.807290690262835,23.078212290502798,20.527252728167426,22.399441340782126,20.247181852521919,21.788547486033522,19.949514120239868,21.177653631284919,19.653504316912141,19.820111731843578,19.014416132988149,null,1.0335195530726258,0.97765363128491622,0.94972067039106156,0.92178770949720679,0.89664804469273751,0.87150837988826824,0.81564245810055869,0.85623003194888181,0.87583892617449666,0.88946459412780643,0.90391459074733083,0.91559633027522935,0.92803030303030309,0.95934959349593496,0.97777777777777841,0.91111111111111143,0.88888888888888895,0.86666666666666625,0.83333333333333337,0.80000000000000038,0.80000000000000038,{"$f":"Y19*C19+($A$4-80)*AF19*$A$16/1000","v":21.503810662716191},{"$f":"Z19*E19+($A$4-80)*AG19*$A$16/1000","v":20.807290690262835},{"$f":"AA19*G19+($A$4-80)*AH19*$A$16/1000","v":20.527252728167426},{"$f":"AB19*I19+($A$4-80)*AI19*$A$16/1000","v":20.247181852521919},{"$f":"AC19*K19+($A$4-80)*AJ19*$A$16/1000","v":19.949514120239868},{"$f":"AD19*M19+($A$4-80)*AK19*$A$16/1000","v":19.653504316912141},{"$f":"AE19*O19+($A$4-80)*AL19*$A$16/1000","v":19.014416132988149}]

{"sheet":"PSH4BG_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]]}
[]
["CSA4BF_36"]
["Evaporator Air \n",null,"Condenser  Entering Air Temperature ˚F"]
[80,"°F DB",65,null,75,null,80,null,85,null,90,null,95,null,105]
["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"]
[1050,72,{"$f":"R8*$M$14","v":27.825388601036273},{"$f":"IF(AM8>C8,C8,AM8)","v":13.220207253886011},{"$f":"S8*$M$14","v":27.951295336787563},{"$f":"IF(AN8>E8,E8,AN8)","v":13.4720207253886},{"$f":"T8*$M$14","v":27.699481865284977},{"$f":"IF(AO8>G8,G8,AO8)","v":13.409067357512953},{"$f":"U8*$M$14","v":27.447668393782383},{"$f":"IF(AP8>I8,I8,AP8)","v":13.346113989637304},{"$f":"V8*$M$14","v":26.912564766839377},{"$f":"IF(AQ8>K8,K8,AQ8)","v":13.157253886010363},{"$f":"W8*$M$14","v":26.377461139896372},{"$f":"IF(AR8>M8,M8,AR8)","v":12.968393782383421},{"$f":"X8*$M$14","v":24.614766839378241},{"$f":"IF(AS8>O8,O8,AS8)","v":12.275906735751295},null,1.145077720207254,1.1502590673575128,1.1398963730569949,1.1295336787564767,1.1075129533678756,1.0854922279792745,1.0129533678756477,0.47511312217194568,0.48198198198198194,0.48409090909090902,0.48623853211009171,0.48888888888888887,0.49164677804295948,0.49872122762148335,1.0666666666666662,1.0857142857142863,1.0761904761904764,1.0666666666666669,1.038095238095238,1.0095238095238088,0.93333333333333313,{"$f":"Y8*C8+($A$4-80)*AF8*$A$8/1000","v":13.220207253886011},{"$f":"Z8*E8+($A$4-80)*AG8*$A$8/1000","v":13.4720207253886},{"$f":"AA8*G8+($A$4-80)*AH8*$A$8/1000","v":13.409067357512953},{"$f":"AB8*I8+($A$4-80)*AI8*$A$8/1000","v":13.346113989637304},{"$f":"AC8*K8+($A$4-80)*AJ8*$A$8/1000","v":13.157253886010363},{"$f":"AD8*M8+($A$4-80)*AK8*$A$8/1000","v":12.968393782383421},{"$f":"AE8*O8+($A$4-80)*AL8*$A$8/1000","v":12.275906735751295}]
[null,69.5,{"$f":"R9*$M$14","v":27.195854922279793},15.171761658031087,{"$f":"S9*$M$14","v":26.975518134715021},15.203238341968909,{"$f":"T9*$M$14","v":26.629274611398962},15.093069948186528,{"$f":"U9*$M$14","v":26.283031088082904},14.982901554404146,{"$f":"V9*$M$14","v":25.684974093264248},14.762564766839379,{"$f":"W9*$M$14","v":25.086917098445593},14.542227979274612,{"$f":"X9*$M$14","v":23.387176165803112},13.849740932642487,null,1.1191709844559585,1.1101036269430049,1.0958549222797926,1.0816062176165804,1.0569948186528497,1.0323834196891191,0.96243523316062185,0.55787037037037035,0.56359393232205368,0.56678486997635935,0.57005988023952092,0.57475490196078438,0.57967377666248443,0.59219380888290707,1.0666666666666662,1.0857142857142863,1.0761904761904764,1.0666666666666669,1.038095238095238,1.0095238095238088,0.93333333333333313,{"$f":"Y9*C9+($A$4-80)*AF9*$A$8/1000","v":15.171761658031087},{"$f":"Z9*E9+($A$4-80)*AG9*$A$8/1000","v":15.203238341968909},{"$f":"AA9*G9+($A$4-80)*AH9*$A$8/1000","v":15.093069948186528},{"$f":"AB9*I9+($A$4-80)*AI9*$A$8/1000","v":14.982901554404146},{"$f":"AC9*K9+($A$4-80)*AJ9*$A$8/1000","v":14.762564766839379},{"$f":"AD9*M9+($A$4-80)*AK9*$A$8/1000","v":14.542227979274612},{"$f":"AE9*O9+($A$4-80)*AL9*$A$8/1000","v":13.849740932642487}]
[null,67,26.566321243523319,17.123316062176169,25.999740932642482,16.934455958549218,25.559067357512948,16.7770725388601,25.118393782383418,16.619689119170982,24.457383419689116,16.367875647668395,23.796373056994817,16.116062176165805,22.159585492227979,15.423575129533676,null,1.0932642487046633,1.0699481865284972,1.0518134715025904,1.0336787564766838,1.0064766839378236,0.97927461139896366,0.91191709844559588,0.64454976303317535,0.65133171912832932,0.65640394088669951,0.66165413533834583,0.66924066924066938,0.67724867724867732,0.69602272727272718,1.0666666666666662,1.0857142857142863,1.0761904761904764,1.0666666666666669,1.038095238095238,1.0095238095238088,0.93333333333333313,{"$f":"Y10*C10+($A$4-80)*AF10*$A$8/1000","v":17.123316062176169},{"$f":"Z10*E10+($A$4-80)*AG10*$A$8/1000","v":16.934455958549218},{"$f":"AA10*G10+($A$4-80)*AH10*$A$8/1000","v":16.7770725388601},{"$f":"AB10*I10+($A$4-80)*AI10*$A$8/1000","v":16.619689119170982},{"$f":"AC10*K10+($A$4-80)*AJ10*$A$8/1000","v":16.367875647668395},{"$f":"AD10*M10+($A$4-80)*AK10*$A$8/1000","v":16.116062176165805},{"$f":"AE10*O10+($A$4-80)*AL10*$A$8/1000","v":15.423575129533676}]
[null,62,24.614766839378241,20.648704663212435,23.670466321243524,20.208031088082901,23.103886010362697,19.893264248704664,22.537305699481863,19.578497409326424,21.907772020725385,19.200777202072537,21.278238341968908,18.82305699481865,19.893264248704664,17.941709844559586,null,1.0129533678756477,0.97409326424870468,0.95077720207253891,0.92746113989637291,0.90155440414507759,0.87564766839378227,0.81865284974093266,0.83887468030690526,0.85372340425531912,0.8610354223433242,0.86871508379888274,0.87643678160919547,0.88461538461538469,0.90189873417721511,1.0666666666666662,1.0857142857142863,1.0761904761904764,1.0666666666666669,1.038095238095238,1.0095238095238088,0.93333333333333313,{"$f":"Y11*C11+($A$4-80)*AF11*$A$8/1000","v":20.648704663212435},{"$f":"Z11*E11+($A$4-80)*AG11*$A$8/1000","v":20.208031088082901},{"$f":"AA11*G11+($A$4-80)*AH11*$A$8/1000","v":19.893264248704664},{"$f":"AB11*I11+($A$4-80)*AI11*$A$8/1000","v":19.578497409326424},{"$f":"AC11*K11+($A$4-80)*AJ11*$A$8/1000","v":19.200777202072537},{"$f":"AD11*M11+($A$4-80)*AK11*$A$8/1000","v":18.82305699481865},{"$f":"AE11*O11+($A$4-80)*AL11*$A$8/1000","v":17.941709844559586}]
[1200,72,27.762435233160623,13.472020725388601,27.888341968911913,13.660880829015543,27.668005181347151,13.660880829015543,27.447668393782383,13.660880829015543,26.975518134715024,13.534974093264246,26.503367875647672,13.409067357512956,24.929533678756481,12.905440414507773,null,1.1424870466321244,1.1476683937823833,1.1386010362694301,1.1295336787564767,1.1101036269430051,1.0906735751295338,1.0259067357512954,0.48526077097505665,0.48984198645598198,0.49374288964732643,0.49770642201834858,0.50175029171528585,0.50593824228028506,0.51767676767676762,0.96666666666666734,0.99999999999999933,1,1,0.98333333333333373,0.96666666666666623,0.91666666666666674,{"$f":"Y12*C12+($A$4-80)*AF12*$A$12/1000","v":13.472020725388601},{"$f":"Z12*E12+($A$4-80)*AG12*$A$12/1000","v":13.660880829015543},{"$f":"AA12*G12+($A$4-80)*AH12*$A$12/1000","v":13.660880829015543},{"$f":"AB12*I12+($A$4-80)*AI12*$A$12/1000","v":13.660880829015543},{"$f":"AC12*K12+($A$4-80)*AJ12*$A$12/1000","v":13.534974093264246},{"$f":"AD12*M12+($A$4-80)*AK12*$A$12/1000","v":13.409067357512956},{"$f":"AE12*O12+($A$4-80)*AL12*$A$12/1000","v":12.905440414507773}]
[null,69.5,27.258808290155439,15.580958549222798,27.132901554404139,15.738341968911916,26.818134715025906,15.691126943005177,26.503367875647672,15.643911917098448,25.952525906735751,15.470790155440413,25.401683937823833,15.297668393782384,23.733419689119174,14.668134715025907,null,1.1217616580310881,1.1165803108808288,1.1036269430051813,1.0906735751295338,1.0680051813471503,1.0453367875647668,0.97668393782383423,0.57159353348729791,0.5800464037122971,0.58509389671361489,0.59026128266033251,0.59611885991510005,0.60223048327137552,0.61803713527851456,0.96666666666666734,0.99999999999999933,1,1,0.98333333333333373,0.96666666666666623,0.91666666666666674,{"$f":"Y13*C13+($A$4-80)*AF13*$A$12/1000","v":15.580958549222798},{"$f":"Z13*E13+($A$4-80)*AG13*$A$12/1000","v":15.738341968911916},{"$f":"AA13*G13+($A$4-80)*AH13*$A$12/1000","v":15.691126943005177},{"$f":"AB13*I13+($A$4-80)*AI13*$A$12/1000","v":15.643911917098448},{"$f":"AC13*K13+($A$4-80)*AJ13*$A$12/1000","v":15.470790155440413},{"$f":"AD13*M13+($A$4-80)*AK13*$A$12/1000","v":15.297668393782384},{"$f":"AE13*O13+($A$4-80)*AL13*$A$12/1000","v":14.668134715025907}]
[null,67,26.755181347150259,17.689896373056996,26.377461139896372,17.815803108808289,25.968264248704664,17.721373056994818,25.559067357512951,17.626943005181346,24.929533678756481,17.406606217616584,24.3,17.186269430051812,22.537305699481863,16.430829015544042,null,1.1010362694300517,1.0854922279792745,1.0686528497409327,1.0518134715025906,1.0259067357512954,1,0.92746113989637291,0.66117647058823537,0.67541766109785206,0.68242424242424238,0.68965517241379304,0.6982323232323232,0.70725388601036265,0.72905027932960909,0.96666666666666734,0.99999999999999933,1,1,0.98333333333333373,0.96666666666666623,0.91666666666666674,{"$f":"Y14*C14+($A$4-80)*AF14*$A$12/1000","v":17.689896373056996},{"$f":"Z14*E14+($A$4-80)*AG14*$A$12/1000","v":17.815803108808289},{"$f":"AA14*G14+($A$4-80)*AH14*$A$12/1000","v":17.721373056994818},{"$f":"AB14*I14+($A$4-80)*AI14*$A$12/1000","v":17.626943005181346},{"$f":"AC14*K14+($A$4-80)*AJ14*$A$12/1000","v":17.406606217616584},{"$f":"AD14*M14+($A$4-80)*AK14*$A$12/1000","v":17.186269430051812},{"$f":"AE14*O14+($A$4-80)*AL14*$A$12/1000","v":16.430829015544042}]
[null,62,24.992487046632128,21.530051813471506,24.048186528497411,21.278238341968912,23.513082901554405,21.026424870466322,22.977979274611396,20.774611398963728,22.379922279792744,20.42836787564767,{"$f":"W15*$M$14","v":21.781865284974092},20.082124352331604,20.396891191709845,19.20077720207254,null,1.028497409326425,0.98963730569948194,0.96761658031088082,0.94559585492227971,0.92098445595854916,0.89637305699481862,0.8393782383419689,0.8614609571788413,0.88481675392670145,0.89424364123159295,0.90410958904109584,0.91279887482419142,0.9219653179190751,0.9413580246913581,0.96666666666666734,0.99999999999999933,1,1,0.98333333333333373,0.96666666666666623,0.91666666666666674,{"$f":"Y15*C15+($A$4-80)*AF15*$A$12/1000","v":21.530051813471506},{"$f":"Z15*E15+($A$4-80)*AG15*$A$12/1000","v":21.278238341968912},{"$f":"AA15*G15+($A$4-80)*AH15*$A$12/1000","v":21.026424870466322},{"$f":"AB15*I15+($A$4-80)*AI15*$A$12/1000","v":20.774611398963728},{"$f":"AC15*K15+($A$4-80)*AJ15*$A$12/1000","v":20.42836787564767},{"$f":"AD15*M15+($A$4-80)*AK15*$A$12/1000","v":20.082124352331604},{"$f":"AE15*O15+($A$4-80)*AL15*$A$12/1000","v":19.20077720207254}]
[1350,72,28.01424870466321,13.912694300518135,28.391968911917097,14.353367875647667,28.234585492227978,14.416321243523313,28.077202072538856,14.47927461139896,27.573575129533676,14.353367875647669,27.069948186528496,14.227461139896372,25.370207253886008,13.597927461139896,null,1.1528497409326424,1.1683937823834196,1.1619170984455958,1.1554404145077719,1.1347150259067356,1.1139896373056994,1.044041450777202,0.49662921348314609,0.50554323725055428,0.51059085841694529,0.51569506726457393,0.52054794520547953,0.52558139534883719,0.53598014888337475,0.88888888888888884,0.9185185185185184,0.9333333333333329,0.94814814814814807,0.94814814814814807,0.94814814814814807,0.9037037037037039,{"$f":"Y16*C16+($A$4-80)*AF16*$A$16/1000","v":13.912694300518135},{"$f":"Z16*E16+($A$4-80)*AG16*$A$16/1000","v":14.353367875647667},{"$f":"AA16*G16+($A$4-80)*AH16*$A$16/1000","v":14.416321243523313},{"$f":"AB16*I16+($A$4-80)*AI16*$A$16/1000","v":14.47927461139896},{"$f":"AC16*K16+($A$4-80)*AJ16*$A$16/1000","v":14.353367875647669},{"$f":"AD16*M16+($A$4-80)*AK16*$A$16/1000","v":14.227461139896372},{"$f":"AE16*O16+($A$4-80)*AL16*$A$16/1000","v":13.597927461139896}]
[null,69.5,27.510621761658033,16.08458549222798,27.573575129533676,16.525259067357513,27.306023316062177,16.556735751295335,27.038471502590674,16.588212435233164,26.471891191709844,16.430829015544045,25.905310880829017,16.273445595854927,24.174093264248704,15.549481865284976,null,1.1321243523316062,1.1347150259067356,1.1237046632124352,1.1126943005181347,1.0893782383419688,1.0660621761658031,0.99481865284974091,0.58466819221967958,0.59931506849315075,0.60634005763688759,0.61350407450523869,0.62068965517241392,0.62818955042527347,0.64322916666666674,0.88888888888888884,0.9185185185185184,0.9333333333333329,0.94814814814814807,0.94814814814814807,0.94814814814814807,0.9037037037037039,{"$f":"Y17*C17+($A$4-80)*AF17*$A$16/1000","v":16.08458549222798},{"$f":"Z17*E17+($A$4-80)*AG17*$A$16/1000","v":16.525259067357513},{"$f":"AA17*G17+($A$4-80)*AH17*$A$16/1000","v":16.556735751295335},{"$f":"AB17*I17+($A$4-80)*AI17*$A$16/1000","v":16.588212435233164},{"$f":"AC17*K17+($A$4-80)*AJ17*$A$16/1000","v":16.430829015544045},{"$f":"AD17*M17+($A$4-80)*AK17*$A$16/1000","v":16.273445595854927},{"$f":"AE17*O17+($A$4-80)*AL17*$A$16/1000","v":15.549481865284976}]
[null,67,27.006994818652849,18.256476683937823,26.755181347150259,18.697150259067357,26.377461139896372,18.69715025906736,25.999740932642482,18.697150259067357,25.370207253886008,18.508290155440413,24.740673575129531,18.319430051813473,22.977979274611396,17.501036269430049,null,1.1113989637305699,1.1010362694300517,1.0854922279792745,1.0699481865284972,1.044041450777202,1.0181347150259066,0.94559585492227971,0.67599067599067597,0.69882352941176473,0.70883054892601438,0.71912832929782089,0.72952853598014888,0.7404580152671757,0.76164383561643834,0.88888888888888884,0.9185185185185184,0.9333333333333329,0.94814814814814807,0.94814814814814807,0.94814814814814807,0.9037037037037039,{"$f":"Y18*C18+($A$4-80)*AF18*$A$16/1000","v":18.256476683937823},{"$f":"Z18*E18+($A$4-80)*AG18*$A$16/1000","v":18.697150259067357},{"$f":"AA18*G18+($A$4-80)*AH18*$A$16/1000","v":18.69715025906736},{"$f":"AB18*I18+($A$4-80)*AI18*$A$16/1000","v":18.697150259067357},{"$f":"AC18*K18+($A$4-80)*AJ18*$A$16/1000","v":18.508290155440413},{"$f":"AD18*M18+($A$4-80)*AK18*$A$16/1000","v":18.319430051813473},{"$f":"AE18*O18+($A$4-80)*AL18*$A$16/1000","v":17.501036269430049}]
[null,62,25.370207253886008,22.411398963730569,24.488860103626944,22.348445595854923,23.953756476683935,22.191062176165801,23.418652849740937,22.033678756476686,22.820595854922281,21.718911917098449,22.222538860103626,21.404145077720209,20.837564766839382,20.459844559585495,null,1.044041450777202,1.0077720207253886,0.9857512953367874,0.96373056994818662,0.93911917098445596,0.91450777202072531,0.8575129533678757,0.88337468982630285,0.91259640102827766,0.92641261498028915,0.94086021505376338,0.9517241379310345,0.96317280453257803,0.98187311178247727,0.88888888888888884,0.9185185185185184,0.9333333333333329,0.94814814814814807,0.94814814814814807,0.94814814814814807,0.9037037037037039,{"$f":"Y19*C19+($A$4-80)*AF19*$A$16/1000","v":22.411398963730569},{"$f":"Z19*E19+($A$4-80)*AG19*$A$16/1000","v":22.348445595854923},{"$f":"AA19*G19+($A$4-80)*AH19*$A$16/1000","v":22.191062176165801},{"$f":"AB19*I19+($A$4-80)*AI19*$A$16/1000","v":22.033678756476686},{"$f":"AC19*K19+($A$4-80)*AJ19*$A$16/1000","v":21.718911917098449},{"$f":"AD19*M19+($A$4-80)*AK19*$A$16/1000","v":21.404145077720209},{"$f":"AE19*O19+($A$4-80)*AL19*$A$16/1000","v":20.459844559585495}]

{"sheet":"PSH4BG_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]]}
[]
["CSA4BF_48"]
["Evaporator Air \n",null,"Condenser  Entering Air Temperature ˚F"]
[80,"°F DB",65,null,75,null,80,null,85,null,90,null,95,null,105]
["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"]
[1200,72,{"$f":"R8*$M$14","v":28.396551724137929},{"$f":"IF(AM8>C8,C8,AM8)","v":13.360344827586205},{"$f":"S8*$M$14","v":27.97758620689655},{"$f":"IF(AN8>E8,E8,AN8)","v":13.174137931034483},{"$f":"T8*$M$14","v":27.535344827586211},{"$f":"IF(AO8>G8,G8,AO8)","v":13.011206896551727},{"$f":"U8*$M$14","v":27.093103448275865},{"$f":"IF(AP8>I8,I8,AP8)","v":12.848275862068967},{"$f":"V8*$M$14","v":26.418103448275861},{"$f":"IF(AQ8>K8,K8,AQ8)","v":12.61551724137931},{"$f":"W8*$M$14","v":25.743103448275861},{"$f":"IF(AR8>M8,M8,AR8)","v":12.382758620689657},{"$f":"X8*$M$14","v":23.927586206896549},{"$f":"IF(AS8>O8,O8,AS8)","v":11.73103448275862},null,1.1685823754789271,1.1513409961685823,1.1331417624521074,1.1149425287356323,1.0871647509578544,1.0593869731800765,0.98467432950191558,0.4704918032786885,0.47088186356073214,0.47252747252747251,0.47422680412371132,0.4775330396475771,0.48101265822784817,0.49027237354085601,0.83333333333333337,0.84999999999999909,0.86666666666666703,0.88333333333333419,0.89166666666666794,0.89999999999999969,0.94999999999999984,{"$f":"Y8*C8+($A$4-80)*AF8*$A$8/1000","v":13.360344827586205},{"$f":"Z8*E8+($A$4-80)*AG8*$A$8/1000","v":13.174137931034483},{"$f":"AA8*G8+($A$4-80)*AH8*$A$8/1000","v":13.011206896551727},{"$f":"AB8*I8+($A$4-80)*AI8*$A$8/1000","v":12.848275862068967},{"$f":"AC8*K8+($A$4-80)*AJ8*$A$8/1000","v":12.61551724137931},{"$f":"AD8*M8+($A$4-80)*AK8*$A$8/1000","v":12.382758620689657},{"$f":"AE8*O8+($A$4-80)*AL8*$A$8/1000","v":11.73103448275862}]
[null,69.5,{"$f":"R9*$M$14","v":27.65172413793103},15.10603448275862,{"$f":"S9*$M$14","v":27.139655172413789},14.943103448275862,{"$f":"T9*$M$14","v":26.697413793103451},14.780172413793105,{"$f":"U9*$M$14","v":26.255172413793105},14.617241379310345,{"$f":"V9*$M$14","v":25.603448275862071},14.372844827586208,{"$f":"W9*$M$14","v":24.951724137931031},14.128448275862068,{"$f":"X9*$M$14","v":23.252586206896552},13.406896551724136,null,1.1379310344827585,1.1168582375478926,1.0986590038314177,1.0804597701149425,1.053639846743295,1.0268199233716473,0.9568965517241379,0.54629629629629639,0.55060034305317329,0.55361813426329554,0.55673758865248224,0.5613636363636364,0.56623134328358216,0.57657657657657646,0.83333333333333337,0.84999999999999909,0.86666666666666703,0.88333333333333419,0.89166666666666794,0.89999999999999969,0.94999999999999984,{"$f":"Y9*C9+($A$4-80)*AF9*$A$8/1000","v":15.10603448275862},{"$f":"Z9*E9+($A$4-80)*AG9*$A$8/1000","v":14.943103448275862},{"$f":"AA9*G9+($A$4-80)*AH9*$A$8/1000","v":14.780172413793105},{"$f":"AB9*I9+($A$4-80)*AI9*$A$8/1000","v":14.617241379310345},{"$f":"AC9*K9+($A$4-80)*AJ9*$A$8/1000","v":14.372844827586208},{"$f":"AD9*M9+($A$4-80)*AK9*$A$8/1000","v":14.128448275862068},{"$f":"AE9*O9+($A$4-80)*AL9*$A$8/1000","v":13.406896551724136}]
[null,67,26.906896551724135,16.851724137931033,26.301724137931036,16.71206896551724,25.85948275862069,16.549137931034483,25.417241379310344,16.386206896551723,24.788793103448274,16.130172413793105,24.160344827586208,15.874137931034486,22.577586206896552,15.082758620689654,null,1.1072796934865898,1.0823754789272031,1.064176245210728,1.0459770114942528,1.0201149425287355,0.99425287356321834,0.92911877394636011,0.62629757785467133,0.6353982300884955,0.63996399639963997,0.64468864468864473,0.65070422535211281,0.65703275529865135,0.66804123711340202,0.83333333333333337,0.84999999999999909,0.86666666666666703,0.88333333333333419,0.89166666666666794,0.89999999999999969,0.94999999999999984,{"$f":"Y10*C10+($A$4-80)*AF10*$A$8/1000","v":16.851724137931033},{"$f":"Z10*E10+($A$4-80)*AG10*$A$8/1000","v":16.71206896551724},{"$f":"AA10*G10+($A$4-80)*AH10*$A$8/1000","v":16.549137931034483},{"$f":"AB10*I10+($A$4-80)*AI10*$A$8/1000","v":16.386206896551723},{"$f":"AC10*K10+($A$4-80)*AJ10*$A$8/1000","v":16.130172413793105},{"$f":"AD10*M10+($A$4-80)*AK10*$A$8/1000","v":15.874137931034486},{"$f":"AE10*O10+($A$4-80)*AL10*$A$8/1000","v":15.082758620689654}]
[null,62,24.346551724137928,19.225862068965515,23.229310344827585,18.760344827586206,22.717241379310344,18.504310344827587,22.205172413793104,18.248275862068965,21.739655172413794,17.992241379310347,21.274137931034485,17.736206896551725,20.43620689655172,17.22413793103448,null,1.0019157088122603,0.95593869731800762,0.93486590038314166,0.91379310344827591,0.8946360153256705,0.87547892720306519,0.84099616858237536,0.78967495219885275,0.80761523046092176,0.81454918032786894,0.82180293501048218,0.8276231263383298,0.83369803063457326,0.84282460136674264,0.83333333333333337,0.84999999999999909,0.86666666666666703,0.88333333333333419,0.89166666666666794,0.89999999999999969,0.94999999999999984,{"$f":"Y11*C11+($A$4-80)*AF11*$A$8/1000","v":19.225862068965515},{"$f":"Z11*E11+($A$4-80)*AG11*$A$8/1000","v":18.760344827586206},{"$f":"AA11*G11+($A$4-80)*AH11*$A$8/1000","v":18.504310344827587},{"$f":"AB11*I11+($A$4-80)*AI11*$A$8/1000","v":18.248275862068965},{"$f":"AC11*K11+($A$4-80)*AJ11*$A$8/1000","v":17.992241379310347},{"$f":"AD11*M11+($A$4-80)*AK11*$A$8/1000","v":17.736206896551725},{"$f":"AE11*O11+($A$4-80)*AL11*$A$8/1000","v":17.22413793103448}]
[1350,72,28.582758620689653,13.732758620689653,28.396551724137929,13.639655172413793,28.024137931034481,13.523275862068964,27.65172413793103,13.406896551724136,26.976724137931033,13.174137931034481,26.301724137931036,12.941379310344828,24.393103448275859,12.243103448275861,null,1.1762452107279693,1.1685823754789271,1.1532567049808429,1.1379310344827585,1.1101532567049808,1.0823754789272031,1.0038314176245209,0.48045602605863191,0.48032786885245904,0.48255813953488369,0.48484848484848486,0.48835202761000862,0.49203539823008852,0.50190839694656486,0.87407407407407389,0.87407407407407389,0.88148148148148076,0.88888888888888884,0.88888888888888884,0.88888888888888884,0.88888888888888884,{"$f":"Y12*C12+($A$4-80)*AF12*$A$12/1000","v":13.732758620689653},{"$f":"Z12*E12+($A$4-80)*AG12*$A$12/1000","v":13.639655172413793},{"$f":"AA12*G12+($A$4-80)*AH12*$A$12/1000","v":13.523275862068964},{"$f":"AB12*I12+($A$4-80)*AI12*$A$12/1000","v":13.406896551724136},{"$f":"AC12*K12+($A$4-80)*AJ12*$A$12/1000","v":13.174137931034481},{"$f":"AD12*M12+($A$4-80)*AK12*$A$12/1000","v":12.941379310344828},{"$f":"AE12*O12+($A$4-80)*AL12*$A$12/1000","v":12.243103448275861}]
[null,69.5,27.768103448275863,15.501724137931035,27.395689655172415,15.408620689655173,26.988362068965518,15.28060344827586,26.581034482758618,15.152586206896551,25.94094827586207,14.896551724137931,25.300862068965518,14.64051724137931,23.578448275862069,13.918965517241379,null,1.1427203065134099,1.1273946360153257,1.110632183908046,1.0938697318007662,1.0675287356321839,1.0411877394636015,0.97030651340996166,0.55825649622799667,0.56244689889549704,0.56619232427770583,0.57005253940455347,0.57424854194706143,0.57865685372585096,0.59032576505429413,0.87407407407407389,0.87407407407407389,0.88148148148148076,0.88888888888888884,0.88888888888888884,0.88888888888888884,0.88888888888888884,{"$f":"Y13*C13+($A$4-80)*AF13*$A$12/1000","v":15.501724137931035},{"$f":"Z13*E13+($A$4-80)*AG13*$A$12/1000","v":15.408620689655173},{"$f":"AA13*G13+($A$4-80)*AH13*$A$12/1000","v":15.28060344827586},{"$f":"AB13*I13+($A$4-80)*AI13*$A$12/1000","v":15.152586206896551},{"$f":"AC13*K13+($A$4-80)*AJ13*$A$12/1000","v":14.896551724137931},{"$f":"AD13*M13+($A$4-80)*AK13*$A$12/1000","v":14.64051724137931},{"$f":"AE13*O13+($A$4-80)*AL13*$A$12/1000","v":13.918965517241379}]
[null,67,26.953448275862065,17.270689655172415,26.394827586206898,17.177586206896549,25.952586206896552,17.037931034482753,25.510344827586206,16.898275862068964,24.905172413793103,16.618965517241378,24.3,16.339655172413792,22.763793103448275,15.594827586206895,null,1.1091954022988504,1.0862068965517242,1.0680076628352491,1.0498084291187739,1.024904214559387,1,0.93678160919540221,0.64075993091537142,0.6507936507936507,0.65650224215246622,0.66240875912408759,0.66728971962616823,0.67241379310344829,0.68507157464212676,0.87407407407407389,0.87407407407407389,0.88148148148148076,0.88888888888888884,0.88888888888888884,0.88888888888888884,0.88888888888888884,{"$f":"Y14*C14+($A$4-80)*AF14*$A$12/1000","v":17.270689655172415},{"$f":"Z14*E14+($A$4-80)*AG14*$A$12/1000","v":17.177586206896549},{"$f":"AA14*G14+($A$4-80)*AH14*$A$12/1000","v":17.037931034482753},{"$f":"AB14*I14+($A$4-80)*AI14*$A$12/1000","v":16.898275862068964},{"$f":"AC14*K14+($A$4-80)*AJ14*$A$12/1000","v":16.618965517241378},{"$f":"AD14*M14+($A$4-80)*AK14*$A$12/1000","v":16.339655172413792},{"$f":"AE14*O14+($A$4-80)*AL14*$A$12/1000","v":15.594827586206895}]
[null,62,25.091379310344823,20.529310344827586,24.020689655172415,20.017241379310345,23.462068965517243,19.737931034482759,22.903448275862068,19.45862068965517,22.344827586206897,19.156034482758621,{"$f":"W15*$M$14","v":21.786206896551722},18.853448275862068,20.622413793103448,18.201724137931034,null,1.0325670498084289,0.9885057471264368,0.96551724137931039,0.94252873563218387,0.91954022988505746,0.89655172413793094,0.84865900383141757,0.81818181818181823,0.83333333333333326,0.84126984126984117,0.84959349593495925,0.85729166666666667,0.86538461538461542,0.88261851015801362,0.87407407407407389,0.87407407407407389,0.88148148148148076,0.88888888888888884,0.88888888888888884,0.88888888888888884,0.88888888888888884,{"$f":"Y15*C15+($A$4-80)*AF15*$A$12/1000","v":20.529310344827586},{"$f":"Z15*E15+($A$4-80)*AG15*$A$12/1000","v":20.017241379310345},{"$f":"AA15*G15+($A$4-80)*AH15*$A$12/1000","v":19.737931034482759},{"$f":"AB15*I15+($A$4-80)*AI15*$A$12/1000","v":19.45862068965517},{"$f":"AC15*K15+($A$4-80)*AJ15*$A$12/1000","v":19.156034482758621},{"$f":"AD15*M15+($A$4-80)*AK15*$A$12/1000","v":18.853448275862068},{"$f":"AE15*O15+($A$4-80)*AL15*$A$12/1000","v":18.201724137931034}]
[1500,72,28.768965517241373,14.105172413793102,28.815517241379311,14.198275862068966,28.489655172413791,14.105172413793101,28.163793103448278,14.012068965517242,27.512068965517241,13.75603448275862,26.860344827586207,13.5,24.812068965517241,12.708620689655172,null,1.1839080459770113,1.185823754789272,1.1724137931034482,1.1590038314176245,1.132183908045977,1.1053639846743295,1.0210727969348659,0.49029126213592239,0.49273021001615508,0.49509803921568624,0.49752066115702481,0.5,0.50259965337954937,0.51219512195121952,0.89333333333333276,0.90666666666666629,0.90666666666666629,0.90666666666666629,0.89333333333333365,0.88000000000000012,0.81333333333333346,{"$f":"Y16*C16+($A$4-80)*AF16*$A$16/1000","v":14.105172413793102},{"$f":"Z16*E16+($A$4-80)*AG16*$A$16/1000","v":14.198275862068966},{"$f":"AA16*G16+($A$4-80)*AH16*$A$16/1000","v":14.105172413793101},{"$f":"AB16*I16+($A$4-80)*AI16*$A$16/1000","v":14.012068965517242},{"$f":"AC16*K16+($A$4-80)*AJ16*$A$16/1000","v":13.75603448275862},{"$f":"AD16*M16+($A$4-80)*AK16*$A$16/1000","v":13.5},{"$f":"AE16*O16+($A$4-80)*AL16*$A$16/1000","v":12.708620689655172}]
[null,69.5,27.907758620689656,15.920689655172414,27.675000000000001,15.920689655172415,27.290948275862068,15.804310344827583,26.906896551724135,15.687931034482759,26.278448275862068,15.431896551724137,25.650000000000002,15.175862068965518,23.881034482758619,14.384482758620688,null,1.1484674329501916,1.1388888888888888,1.1230842911877394,1.1072796934865898,1.0814176245210727,1.0555555555555556,0.98275862068965503,0.57047539616346954,0.57527333894028598,0.57910447761194017,0.58304498269896199,0.58724534986713905,0.59165154264972775,0.60233918128654973,0.89333333333333276,0.90666666666666629,0.90666666666666629,0.90666666666666629,0.89333333333333365,0.88000000000000012,0.81333333333333346,{"$f":"Y17*C17+($A$4-80)*AF17*$A$16/1000","v":15.920689655172414},{"$f":"Z17*E17+($A$4-80)*AG17*$A$16/1000","v":15.920689655172415},{"$f":"AA17*G17+($A$4-80)*AH17*$A$16/1000","v":15.804310344827583},{"$f":"AB17*I17+($A$4-80)*AI17*$A$16/1000","v":15.687931034482759},{"$f":"AC17*K17+($A$4-80)*AJ17*$A$16/1000","v":15.431896551724137},{"$f":"AD17*M17+($A$4-80)*AK17*$A$16/1000","v":15.175862068965518},{"$f":"AE17*O17+($A$4-80)*AL17*$A$16/1000","v":14.384482758620688}]
[null,67,27.046551724137935,17.736206896551728,26.534482758620687,17.643103448275859,26.092241379310341,17.503448275862063,25.650000000000002,17.363793103448277,25.044827586206893,17.107758620689651,24.439655172413794,16.851724137931036,22.949999999999996,16.060344827586206,null,1.1130268199233717,1.0919540229885056,1.0737547892720305,1.0555555555555556,1.0306513409961684,1.0057471264367817,0.94444444444444431,0.65576592082616181,0.66491228070175434,0.67082961641391603,0.67695099818511795,0.68308550185873607,0.68952380952380954,0.69979716024340777,0.89333333333333276,0.90666666666666629,0.90666666666666629,0.90666666666666629,0.89333333333333365,0.88000000000000012,0.81333333333333346,{"$f":"Y18*C18+($A$4-80)*AF18*$A$16/1000","v":17.736206896551728},{"$f":"Z18*E18+($A$4-80)*AG18*$A$16/1000","v":17.643103448275859},{"$f":"AA18*G18+($A$4-80)*AH18*$A$16/1000","v":17.503448275862063},{"$f":"AB18*I18+($A$4-80)*AI18*$A$16/1000","v":17.363793103448277},{"$f":"AC18*K18+($A$4-80)*AJ18*$A$16/1000","v":17.107758620689651},{"$f":"AD18*M18+($A$4-80)*AK18*$A$16/1000","v":16.851724137931036},{"$f":"AE18*O18+($A$4-80)*AL18*$A$16/1000","v":16.060344827586206}]
[null,62,25.836206896551722,21.832758620689656,24.76551724137931,21.320689655172412,24.160344827586208,21.018103448275863,23.555172413793102,20.71551724137931,22.903448275862068,20.366379310344826,22.251724137931031,20.017241379310345,20.855172413793102,19.132758620689657,null,1.0632183908045976,1.0191570881226053,0.99425287356321845,0.96934865900383138,0.94252873563218387,0.91570881226053624,0.85823754789272022,0.84504504504504507,0.86090225563909761,0.86994219653179183,0.87944664031620556,0.8892276422764227,0.89958158995815907,0.91741071428571441,0.89333333333333276,0.90666666666666629,0.90666666666666629,0.90666666666666629,0.89333333333333365,0.88000000000000012,0.81333333333333346,{"$f":"Y19*C19+($A$4-80)*AF19*$A$16/1000","v":21.832758620689656},{"$f":"Z19*E19+($A$4-80)*AG19*$A$16/1000","v":21.320689655172412},{"$f":"AA19*G19+($A$4-80)*AH19*$A$16/1000","v":21.018103448275863},{"$f":"AB19*I19+($A$4-80)*AI19*$A$16/1000","v":20.71551724137931},{"$f":"AC19*K19+($A$4-80)*AJ19*$A$16/1000","v":20.366379310344826},{"$f":"AD19*M19+($A$4-80)*AK19*$A$16/1000","v":20.017241379310345},{"$f":"AE19*O19+($A$4-80)*AL19*$A$16/1000","v":19.132758620689657}]

{"sheet":"PSH4BG_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]]}
[]
["CSA4BF_60"]
["Evaporator Air \n",null,"Condenser  Entering Air Temperature ˚F"]
[80,"°F DB",65,null,75,null,80,null,85,null,90,null,95,null,105]
["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"]
[1350,72,{"$f":"R8*$M$14","v":27.203773584905662},{"$f":"IF(AM8>C8,C8,AM8)","v":12.379245283018866},{"$f":"S8*$M$14","v":27.280188679245285},{"$f":"IF(AN8>E8,E8,AN8)","v":12.570283018867922},{"$f":"T8*$M$14","v":27.012735849056604},{"$f":"IF(AO8>G8,G8,AO8)","v":12.512971698113208},{"$f":"U8*$M$14","v":26.745283018867926},{"$f":"IF(AP8>I8,I8,AP8)","v":12.455660377358493},{"$f":"V8*$M$14","v":26.191273584905659},{"$f":"IF(AQ8>K8,K8,AQ8)","v":12.245518867924527},{"$f":"W8*$M$14","v":25.637264150943391},{"$f":"IF(AR8>M8,M8,AR8)","v":12.035377358490564},{"$f":"X8*$M$14","v":23.917924528301889},{"$f":"IF(AS8>O8,O8,AS8)","v":11.347641509433963},null,1.1194968553459119,1.1226415094339623,1.1116352201257862,1.10062893081761,1.0778301886792452,1.0550314465408803,0.98427672955974843,0.45505617977528084,0.46078431372549011,0.46322489391796323,0.46571428571428575,0.46754194018964257,0.4694485842026826,0.4744408945686901,1.0074074074074069,0.96296296296296302,0.94814814814814807,0.93333333333333401,0.92592592592592693,0.91851851851851907,0.94814814814814807,{"$f":"Y8*C8+($A$4-80)*AF8*$A$8/1000","v":12.379245283018866},{"$f":"Z8*E8+($A$4-80)*AG8*$A$8/1000","v":12.570283018867922},{"$f":"AA8*G8+($A$4-80)*AH8*$A$8/1000","v":12.512971698113208},{"$f":"AB8*I8+($A$4-80)*AI8*$A$8/1000","v":12.455660377358493},{"$f":"AC8*K8+($A$4-80)*AJ8*$A$8/1000","v":12.245518867924527},{"$f":"AD8*M8+($A$4-80)*AK8*$A$8/1000","v":12.035377358490564},{"$f":"AE8*O8+($A$4-80)*AL8*$A$8/1000","v":11.347641509433963}]
[null,69.5,{"$f":"R9*$M$14","v":26.496933962264148},14.213207547169812,{"$f":"S9*$M$14","v":26.496933962264148},14.404245283018868,{"$f":"T9*$M$14","v":26.20082547169811},14.337382075471698,{"$f":"U9*$M$14","v":25.904716981132072},14.270518867924528,{"$f":"V9*$M$14","v":25.322051886792455},14.022169811320756,{"$f":"W9*$M$14","v":24.73938679245283},13.773820754716981,{"$f":"X9*$M$14","v":22.962735849056603},12.933254716981134,null,1.0904088050314464,1.0904088050314464,1.0782232704402515,1.0660377358490565,1.042059748427673,1.0180817610062893,0.94496855345911945,0.53640951694304262,0.54361932227829857,0.54721108275610653,0.55088495575221241,0.55375330064126749,0.55675675675675673,0.56322795341098175,1.0074074074074069,0.96296296296296302,0.94814814814814807,0.93333333333333401,0.92592592592592693,0.91851851851851907,0.94814814814814807,{"$f":"Y9*C9+($A$4-80)*AF9*$A$8/1000","v":14.213207547169812},{"$f":"Z9*E9+($A$4-80)*AG9*$A$8/1000","v":14.404245283018868},{"$f":"AA9*G9+($A$4-80)*AH9*$A$8/1000","v":14.337382075471698},{"$f":"AB9*I9+($A$4-80)*AI9*$A$8/1000","v":14.270518867924528},{"$f":"AC9*K9+($A$4-80)*AJ9*$A$8/1000","v":14.022169811320756},{"$f":"AD9*M9+($A$4-80)*AK9*$A$8/1000","v":13.773820754716981},{"$f":"AE9*O9+($A$4-80)*AL9*$A$8/1000","v":12.933254716981134}]
[null,67,25.790094339622645,16.047169811320757,25.713679245283018,16.238207547169811,25.388915094339616,16.161792452830188,25.064150943396228,16.085377358490568,24.452830188679247,15.798820754716983,23.841509433962266,15.512264150943398,22.007547169811321,14.518867924528301,null,1.0613207547169812,1.0581761006289307,1.0448113207547167,1.0314465408805031,1.0062893081761006,0.98113207547169812,0.90566037735849059,0.62222222222222223,0.6315007429420505,0.63656884875846509,0.6417682926829269,0.64609375000000002,0.65064102564102566,0.65972222222222221,1.0074074074074069,0.96296296296296302,0.94814814814814807,0.93333333333333401,0.92592592592592693,0.91851851851851907,0.94814814814814807,{"$f":"Y10*C10+($A$4-80)*AF10*$A$8/1000","v":16.047169811320757},{"$f":"Z10*E10+($A$4-80)*AG10*$A$8/1000","v":16.238207547169811},{"$f":"AA10*G10+($A$4-80)*AH10*$A$8/1000","v":16.161792452830188},{"$f":"AB10*I10+($A$4-80)*AI10*$A$8/1000","v":16.085377358490568},{"$f":"AC10*K10+($A$4-80)*AJ10*$A$8/1000","v":15.798820754716983},{"$f":"AD10*M10+($A$4-80)*AK10*$A$8/1000","v":15.512264150943398},{"$f":"AE10*O10+($A$4-80)*AL10*$A$8/1000","v":14.518867924528301}]
[null,62,23.688679245283019,18.874528301886791,22.657075471698114,18.339622641509436,22.141273584905662,18.072169811320755,21.625471698113209,17.804716981132078,21.090566037735851,17.518160377358491,20.555660377358489,17.231603773584908,19.447641509433964,16.658490566037738,null,0.97484276729559749,0.9323899371069182,0.91116352201257866,0.88993710691823902,0.86792452830188682,0.84591194968553451,0.80031446540880502,0.79677419354838708,0.8094435075885329,0.81622088006902493,0.82332155477031799,0.83061594202898548,0.8382899628252789,0.85658153241650303,1.0074074074074069,0.96296296296296302,0.94814814814814807,0.93333333333333401,0.92592592592592693,0.91851851851851907,0.94814814814814807,{"$f":"Y11*C11+($A$4-80)*AF11*$A$8/1000","v":18.874528301886791},{"$f":"Z11*E11+($A$4-80)*AG11*$A$8/1000","v":18.339622641509436},{"$f":"AA11*G11+($A$4-80)*AH11*$A$8/1000","v":18.072169811320755},{"$f":"AB11*I11+($A$4-80)*AI11*$A$8/1000","v":17.804716981132078},{"$f":"AC11*K11+($A$4-80)*AJ11*$A$8/1000","v":17.518160377358491},{"$f":"AD11*M11+($A$4-80)*AK11*$A$8/1000","v":17.231603773584908},{"$f":"AE11*O11+($A$4-80)*AL11*$A$8/1000","v":16.658490566037738}]
[1500,72,27.394811320754716,13.028773584905661,27.547641509433962,12.990566037735849,27.318396226415096,12.895047169811322,27.089150943396231,12.799528301886793,26.554245283018869,12.608490566037736,26.019339622641507,12.41745283018868,24.3,11.806132075471698,null,1.1273584905660377,1.1336477987421383,1.1242138364779874,1.1147798742138366,1.0927672955974843,1.070754716981132,1,0.47559274755927478,0.47156726768377255,0.47202797202797203,0.47249647390691113,0.47482014388489208,0.47723935389133632,0.48584905660377353,1.0266666666666662,0.97333333333333294,0.95999999999999941,0.94666666666666699,0.93999999999999961,0.93333333333333335,0.94666666666666699,{"$f":"Y12*C12+($A$4-80)*AF12*$A$12/1000","v":13.028773584905661},{"$f":"Z12*E12+($A$4-80)*AG12*$A$12/1000","v":12.990566037735849},{"$f":"AA12*G12+($A$4-80)*AH12*$A$12/1000","v":12.895047169811322},{"$f":"AB12*I12+($A$4-80)*AI12*$A$12/1000","v":12.799528301886793},{"$f":"AC12*K12+($A$4-80)*AJ12*$A$12/1000","v":12.608490566037736},{"$f":"AD12*M12+($A$4-80)*AK12*$A$12/1000","v":12.41745283018868},{"$f":"AE12*O12+($A$4-80)*AL12*$A$12/1000","v":11.806132075471698}]
[null,69.5,26.783490566037734,14.805424528301888,26.859905660377361,14.843632075471701,26.59245283018868,14.748113207547171,26.325000000000003,14.652594339622643,25.742334905660375,14.423349056603772,25.15966981132075,14.194103773584905,23.38301886792453,13.46816037735849,null,1.1022012578616351,1.1053459119496856,1.0943396226415094,1.0833333333333335,1.0593553459119496,1.0353773584905659,0.96226415094339623,0.55278174037089878,0.55263157894736847,0.5545977011494253,0.55660377358490565,0.56029684601113172,0.56416097190584669,0.5759803921568627,1.0266666666666662,0.97333333333333294,0.95999999999999941,0.94666666666666699,0.93999999999999961,0.93333333333333335,0.94666666666666699,{"$f":"Y13*C13+($A$4-80)*AF13*$A$12/1000","v":14.805424528301888},{"$f":"Z13*E13+($A$4-80)*AG13*$A$12/1000","v":14.843632075471701},{"$f":"AA13*G13+($A$4-80)*AH13*$A$12/1000","v":14.748113207547171},{"$f":"AB13*I13+($A$4-80)*AI13*$A$12/1000","v":14.652594339622643},{"$f":"AC13*K13+($A$4-80)*AJ13*$A$12/1000","v":14.423349056603772},{"$f":"AD13*M13+($A$4-80)*AK13*$A$12/1000","v":14.194103773584905},{"$f":"AE13*O13+($A$4-80)*AL13*$A$12/1000","v":13.46816037735849}]
[null,67,26.172169811320753,16.582075471698111,26.172169811320753,16.69669811320755,25.866509433962264,16.601179245283021,25.560849056603779,16.505660377358492,24.930424528301888,16.238207547169811,24.3,15.970754716981132,22.466037735849056,15.130188679245284,null,1.0770440251572326,1.0770440251572326,1.0644654088050314,1.0518867924528303,1.0259433962264151,1,0.92452830188679236,0.63357664233576638,0.63795620437956213,0.64180206794682426,0.64573991031390132,0.65134099616858232,0.65723270440251569,0.67346938775510212,1.0266666666666662,0.97333333333333294,0.95999999999999941,0.94666666666666699,0.93999999999999961,0.93333333333333335,0.94666666666666699,{"$f":"Y14*C14+($A$4-80)*AF14*$A$12/1000","v":16.582075471698111},{"$f":"Z14*E14+($A$4-80)*AG14*$A$12/1000","v":16.69669811320755},{"$f":"AA14*G14+($A$4-80)*AH14*$A$12/1000","v":16.601179245283021},{"$f":"AB14*I14+($A$4-80)*AI14*$A$12/1000","v":16.505660377358492},{"$f":"AC14*K14+($A$4-80)*AJ14*$A$12/1000","v":16.238207547169811},{"$f":"AD14*M14+($A$4-80)*AK14*$A$12/1000","v":15.970754716981132},{"$f":"AE14*O14+($A$4-80)*AL14*$A$12/1000","v":15.130188679245284}]
[null,62,24.147169811320754,19.791509433962261,23.153773584905661,19.294811320754715,22.618867924528303,19.046462264150943,22.083962264150941,18.798113207547168,21.52995283018868,18.511556603773588,{"$f":"W15*$M$14","v":20.975943396226416},18.225000000000001,19.791509433962265,17.575471698113208,null,0.99371069182389937,0.95283018867924529,0.9308176100628931,0.90880503144654079,0.88600628930817604,0.8632075471698113,0.81446540880503138,0.81962025316455689,0.83333333333333326,0.84206081081081074,0.85121107266435991,0.85980479148181022,0.86885245901639352,0.88803088803088803,1.0266666666666662,0.97333333333333294,0.95999999999999941,0.94666666666666699,0.93999999999999961,0.93333333333333335,0.94666666666666699,{"$f":"Y15*C15+($A$4-80)*AF15*$A$12/1000","v":19.791509433962261},{"$f":"Z15*E15+($A$4-80)*AG15*$A$12/1000","v":19.294811320754715},{"$f":"AA15*G15+($A$4-80)*AH15*$A$12/1000","v":19.046462264150943},{"$f":"AB15*I15+($A$4-80)*AI15*$A$12/1000","v":18.798113207547168},{"$f":"AC15*K15+($A$4-80)*AJ15*$A$12/1000","v":18.511556603773588},{"$f":"AD15*M15+($A$4-80)*AK15*$A$12/1000","v":18.225000000000001},{"$f":"AE15*O15+($A$4-80)*AL15*$A$12/1000","v":17.575471698113208}]
[1650,72,27.547641509433962,13.29622641509434,27.815094339622643,13.372641509433963,27.624056603773585,13.315330188679248,27.433018867924527,13.25801886792453,26.917216981132068,13.086084905660375,26.401415094339619,12.914150943396224,24.682075471698113,12.302830188679247,null,1.1336477987421383,1.1446540880503144,1.1367924528301887,1.1289308176100628,1.107704402515723,1.0864779874213835,1.0157232704402515,0.48266296809986131,0.48076923076923078,0.48201936376210242,0.48328690807799451,0.48616039744499651,0.48914616497829233,0.49845201238390102,1.018181818181819,0.98181818181818203,0.96969696969696983,0.9575757575757573,0.95151515151515087,0.9454545454545451,0.93333333333333279,{"$f":"Y16*C16+($A$4-80)*AF16*$A$16/1000","v":13.29622641509434},{"$f":"Z16*E16+($A$4-80)*AG16*$A$16/1000","v":13.372641509433963},{"$f":"AA16*G16+($A$4-80)*AH16*$A$16/1000","v":13.315330188679248},{"$f":"AB16*I16+($A$4-80)*AI16*$A$16/1000","v":13.25801886792453},{"$f":"AC16*K16+($A$4-80)*AJ16*$A$16/1000","v":13.086084905660375},{"$f":"AD16*M16+($A$4-80)*AK16*$A$16/1000","v":12.914150943396224},{"$f":"AE16*O16+($A$4-80)*AL16*$A$16/1000","v":12.302830188679247}]
[null,69.5,27.050943396226415,15.283018867924529,27.222877358490564,15.416745283018868,26.984080188679247,15.349882075471697,26.745283018867926,15.283018867924529,26.172169811320753,15.063325471698111,25.599056603773583,14.843632075471694,23.803301886792454,14.079481132075475,null,1.1132075471698113,1.1202830188679245,1.1104559748427674,1.10062893081761,1.0770440251572326,1.0534591194968552,0.97955974842767291,0.56497175141242939,0.56631578947368422,0.56884955752212385,0.5714285714285714,0.57554744525547441,0.57985074626865662,0.59149277688603541,1.018181818181819,0.98181818181818203,0.96969696969696983,0.9575757575757573,0.95151515151515087,0.9454545454545451,0.93333333333333279,{"$f":"Y17*C17+($A$4-80)*AF17*$A$16/1000","v":15.283018867924529},{"$f":"Z17*E17+($A$4-80)*AG17*$A$16/1000","v":15.416745283018868},{"$f":"AA17*G17+($A$4-80)*AH17*$A$16/1000","v":15.349882075471697},{"$f":"AB17*I17+($A$4-80)*AI17*$A$16/1000","v":15.283018867924529},{"$f":"AC17*K17+($A$4-80)*AJ17*$A$16/1000","v":15.063325471698111},{"$f":"AD17*M17+($A$4-80)*AK17*$A$16/1000","v":14.843632075471694},{"$f":"AE17*O17+($A$4-80)*AL17*$A$16/1000","v":14.079481132075475}]
[null,67,26.554245283018869,17.269811320754716,26.630660377358488,17.46084905660377,26.344103773584909,17.384433962264151,26.057547169811325,17.308018867924531,25.427122641509438,17.040566037735847,24.796698113207551,16.773113207547169,22.924528301886795,15.856132075471699,null,1.0927672955974843,1.0959119496855345,1.084119496855346,1.0723270440251573,1.0463836477987423,1.0204402515723272,0.94339622641509435,0.65035971223021583,0.65566714490674316,0.65989847715736039,0.66422287390029322,0.67017280240420718,0.67642526964560856,0.69166666666666665,1.018181818181819,0.98181818181818203,0.96969696969696983,0.9575757575757573,0.95151515151515087,0.9454545454545451,0.93333333333333279,{"$f":"Y18*C18+($A$4-80)*AF18*$A$16/1000","v":17.269811320754716},{"$f":"Z18*E18+($A$4-80)*AG18*$A$16/1000","v":17.46084905660377},{"$f":"AA18*G18+($A$4-80)*AH18*$A$16/1000","v":17.384433962264151},{"$f":"AB18*I18+($A$4-80)*AI18*$A$16/1000","v":17.308018867924531},{"$f":"AC18*K18+($A$4-80)*AJ18*$A$16/1000","v":17.040566037735847},{"$f":"AD18*M18+($A$4-80)*AK18*$A$16/1000","v":16.773113207547169},{"$f":"AE18*O18+($A$4-80)*AL18*$A$16/1000","v":15.856132075471699}]
[null,62,24.567452830188675,20.708490566037735,23.612264150943396,20.288207547169812,23.077358490566038,20.03985849056604,22.54245283018868,19.791509433962261,21.96933962264151,19.504952830188678,21.39622641509434,19.218396226415091,20.135377358490565,18.492452830188679,null,1.0110062893081759,0.97169811320754707,0.94968553459119498,0.92767295597484278,0.90408805031446537,0.88050314465408808,0.82861635220125784,0.84292379471228629,0.85922330097087385,0.86837748344370869,0.87796610169491518,0.88782608695652165,0.89821428571428563,0.91840607210626179,1.018181818181819,0.98181818181818203,0.96969696969696983,0.9575757575757573,0.95151515151515087,0.9454545454545451,0.93333333333333279,{"$f":"Y19*C19+($A$4-80)*AF19*$A$16/1000","v":20.708490566037735},{"$f":"Z19*E19+($A$4-80)*AG19*$A$16/1000","v":20.288207547169812},{"$f":"AA19*G19+($A$4-80)*AH19*$A$16/1000","v":20.03985849056604},{"$f":"AB19*I19+($A$4-80)*AI19*$A$16/1000","v":19.791509433962261},{"$f":"AC19*K19+($A$4-80)*AJ19*$A$16/1000","v":19.504952830188678},{"$f":"AD19*M19+($A$4-80)*AK19*$A$16/1000","v":19.218396226415091},{"$f":"AE19*O19+($A$4-80)*AL19*$A$16/1000","v":18.492452830188679}]

{"sheet":"Form","index":7,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":true,"merged":[[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],[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],[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],[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]]}
[]
[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 105°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 105°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,80,null,85,null,90,null,95,null,105]
["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 105°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,"M-19-A"]

{"sheet":"Instructions","index":8,"n_rows":39,"n_cols":5,"rows_kept":39,"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:","M-14-A","2014-05-27","Initial public release"]
[null,null,"M-15-A","2015-01-31","Renewed date key through 2015"]
[null,null,"M-16-A","2016-03-22","Renewed date key through 2016"]
[null,null,"M-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":[]}