{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["notes","Options","Calcs","24VNA9_23","24VNA9_24","24VNA9_25","24VNA9_36","24VNA9_48","24VNA9_60","Form","Instructions","Prompt","Sheet1"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

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

{"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":"24VNA9_23","index":3,"n_rows":19,"n_cols":45,"rows_kept":19,"cut":false,"hidden":true,"merged":[[2,0,2,1],[2,2,2,15],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[4,0,6,0],[4,1,6,1],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[5,15,6,15],[4,10,4,11],[4,12,4,13],[4,14,4,15],[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],[7,0,10,0],[11,0,14,0],[15,0,18,0],[31,0,34,0],[35,0,38,0],[41,0,42,1],[44,12,45,12],[44,13,45,13],[44,14,45,14],[44,15,45,15],[46,0,49,0],[50,0,53,0],[43,12,43,13],[43,14,43,15],[44,4,45,4],[44,5,45,5],[44,6,45,6],[44,7,45,7],[44,8,45,8],[44,9,45,9],[44,10,45,10],[44,11,45,11],[43,0,45,0],[43,1,45,1],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[54,0,57,0],[60,0,61,1],[60,4,60,15],[61,4,61,5],[61,6,61,7],[61,8,61,9],[61,10,61,11],[61,12,61,13],[61,14,61,15],[63,12,64,12],[63,13,64,13],[63,14,64,14],[63,15,64,15],[65,0,68,0],[69,0,72,0],[62,12,62,13],[62,14,62,15],[63,4,64,4],[63,5,64,5],[63,6,64,6],[63,7,64,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[63,11,64,11],[62,0,64,0],[62,1,64,1],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[73,0,76,0],[79,0,80,1],[79,4,79,15],[80,4,80,5],[80,6,80,7],[80,8,80,9],[80,10,80,11],[80,12,80,13],[80,14,80,15],[82,12,83,12],[82,13,83,13],[82,14,83,14],[82,15,83,15],[84,0,87,0],[88,0,91,0],[81,12,81,13],[81,14,81,15],[82,4,83,4],[82,5,83,5],[82,6,83,6],[82,7,83,7],[82,8,83,8],[82,9,83,9],[82,10,83,10],[82,11,83,11],[81,0,83,0],[81,1,83,1],[81,4,81,5],[81,6,81,7],[81,8,81,9],[81,10,81,11],[92,0,95,0],[98,0,99,1],[98,4,98,15],[99,4,99,5],[99,6,99,7],[99,8,99,9],[99,10,99,11],[99,12,99,13],[99,14,99,15],[101,12,102,12],[101,13,102,13],[101,14,102,14],[101,15,102,15],[103,0,106,0],[107,0,110,0],[100,12,100,13],[100,14,100,15],[101,4,102,4],[101,5,102,5],[101,6,102,6],[101,7,102,7],[101,8,102,8],[101,9,102,9],[101,10,102,10],[101,11,102,11],[100,0,102,0],[100,1,102,1],[100,4,100,5],[100,6,100,7],[100,8,100,9],[100,10,100,11],[111,0,114,0],[117,0,118,1],[117,4,117,15],[118,4,118,5],[118,6,118,7],[118,8,118,9],[118,10,118,11],[118,12,118,13],[118,14,118,15],[130,0,133,0],[120,12,121,12],[120,13,121,13],[120,14,121,14],[120,15,121,15],[122,0,125,0],[126,0,129,0],[119,12,119,13],[119,14,119,15],[120,4,121,4],[120,5,121,5],[120,6,121,6],[120,7,121,7],[120,8,121,8],[120,9,121,9],[120,10,121,10],[120,11,121,11],[119,0,121,0],[119,1,121,1],[119,4,119,5],[119,6,119,7],[119,8,119,9],[119,10,119,11]]}
[]
["24VNA9_23",null,"23=24A"]
["Evaporator Air Flow",null,"Condenser  Entering Air Temperature ˚F"]
[825,"CFM",65,null,75,null,85,null,95,null,100,null,105,null,115]
["Evap. Air °F DB","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"]
[75,72,{"$f":"R8*$I$17","v":29.26},{"$f":"IF(AM8>C8,C8,AM8)","v":12.02},{"$f":"S8*$I$17","v":27.98},{"$f":"IF(AN8>E8,E8,AN8)","v":11.54},{"$f":"T8*$I$17","v":26.67},{"$f":"IF(AO8>G8,G8,AO8)","v":11.04},{"$f":"U8*$I$17","v":25.33},{"$f":"IF(AP8>I8,I8,AP8)","v":10.54},{"$f":"V8*$I$17","v":24.674999999999997},{"$f":"IF(AQ8>K8,K8,AQ8)","v":10.295},{"$f":"W8*$I$17","v":24.02},{"$f":"IF(AR8>M8,M8,AR8)","v":10.050000000000001},{"$f":"X8*$I$17","v":22.6},{"$f":"IF(AS8>O8,O8,AS8)","v":9.5299999999999994},null,1.2721739130434784,1.2165217391304348,1.1595652173913045,1.1013043478260869,1.0728260869565216,1.0443478260869565,0.98260869565217401,0.41079972658920022,0.41243745532523229,0.41394825646794142,0.41610738255033558,0.41722391084093219,0.4184013322231474,0.4216814159292035,1,1,1,1,1,1,1,{"$f":"Y8*C8*AF8","v":12.02},{"$f":"Z8*E8*AG8","v":11.54},{"$f":"AA8*G8*AH8","v":11.04},{"$f":"AB8*I8*AI8","v":10.54},{"$f":"AC8*K8*AJ8","v":10.295},{"$f":"AD8*M8*AK8","v":10.050000000000001},{"$f":"AE8*O8*AL8","v":9.5299999999999994}]
[null,67,26.73,15.95,25.550000000000004,{"$f":"IF(AN9>E9,E9,AN9)","v":15.410000000000004},24.34,{"$f":"IF(AO9>G9,G9,AO9)","v":14.86},23.099999999999998,{"$f":"IF(AP9>I9,I9,AP9)","v":14.309999999999997},22.490000000000002,{"$f":"IF(AQ9>K9,K9,AQ9)","v":14.035000000000002},21.88,{"$f":"IF(AR9>M9,M9,AR9)","v":13.76},20.56,{"$f":"IF(AS9>O9,O9,AS9)","v":13.19},null,1.1621739130434783,1.1108695652173914,1.0582608695652174,1.0043478260869565,0.97782608695652184,0.95130434782608686,0.89391304347826084,0.5967078189300411,0.60313111545988263,0.61051766639276905,0.61948051948051941,0.62405513561582926,0.62888482632541132,0.6415369649805448,1,1,1,1,1,1,1,{"$f":"Y9*C9*AF9","v":15.95},{"$f":"Z9*E9*AG9","v":15.410000000000004},{"$f":"AA9*G9*AH9","v":14.86},{"$f":"AB9*I9*AI9","v":14.309999999999997},{"$f":"AC9*K9*AJ9","v":14.035000000000002},{"$f":"AD9*M9*AK9","v":13.76},{"$f":"AE9*O9*AL9","v":13.19}]
[null,63,24.85,19.010000000000002,23.74,18.440000000000001,22.61,17.850000000000001,21.44,17.25,20.865000000000002,16.954999999999998,20.29,16.66,19.059999999999999,16.04,null,1.0804347826086957,1.0321739130434782,0.98304347826086957,0.9321739130434783,0.90717391304347839,0.88217391304347825,0.82869565217391294,0.76498993963782702,0.77674810446503806,0.78947368421052644,0.80457089552238803,0.81260484064222371,0.82109413504189255,0.84155299055613852,1,1,1,1,1,1,1,19.010000000000002,18.440000000000001,17.850000000000001,17.25,16.954999999999998,16.66,16.04]
[null,57,22.78,22.78,21.89,21.89,20.97,20.97,20.04,20.04,19.564999999999998,19.564999999999998,19.09,19.09,18.100000000000001,18.100000000000001,null,0.99043478260869566,0.95173913043478264,0.91173913043478261,0.8713043478260869,0.85065217391304337,0.83,0.78695652173913044,1,1,1,1,1,1,1,1,1,1,1,1,1,1,22.78,21.89,20.97,20.04,19.564999999999998,19.09,18.100000000000001]
[77.5,72,29.164999999999999,13.93,27.89,13.425000000000001,26.58,12.904999999999999,25.24,12.385,24.587499999999995,12.129999999999997,23.935000000000002,11.875,22.520000000000003,11.335000000000001,null,1.2680434782608696,1.212608695652174,1.1556521739130434,1.0973913043478261,1.0690217391304346,1.0406521739130437,0.97913043478260886,0.47762729298817075,0.48135532448906421,0.48551542513167795,0.49068938193343903,0.4933401118454499,0.49613536661792351,0.50333037300177619,1,1,1,1,1,1,1,13.93,13.425000000000001,12.904999999999999,12.385,12.129999999999997,11.875,11.335000000000001]
[null,67,26.675000000000001,17.84,25.5,17.28,24.289999999999996,16.709999999999997,23.05,16.135000000000002,22.442500000000003,15.852500000000001,21.835000000000001,15.57,20.52,14.975000000000001,null,1.1597826086956522,1.1086956521739131,1.056086956521739,1.0021739130434784,0.97576086956521746,0.94934782608695656,0.89217391304347826,0.66879100281162129,0.67764705882352949,0.68793742280773984,0.70000000000000007,0.70636069956555636,0.71307533776047627,0.72977582846003908,1,1,1,1,1,1,1,17.84,17.28,16.709999999999997,16.135000000000002,15.852500000000001,15.57,14.975000000000001]
[null,63,24.85,20.89,23.744999999999994,20.294999999999998,22.619999999999997,19.68,21.465,19.05,20.897500000000001,18.734999999999999,20.329999999999998,18.420000000000002,19.16,17.649999999999999,null,1.0804347826086957,1.0323913043478259,0.98347826086956514,0.93326086956521737,0.90858695652173915,0.88391304347826083,0.83304347826086955,0.84064386317907447,0.85470625394819977,0.87002652519893908,0.88749126484975549,0.89651872233520746,0.90605017215937056,0.92118997912317324,1,1,1,1,1,1,1,20.89,20.294999999999998,19.68,19.05,18.734999999999999,18.420000000000002,17.649999999999999]
[null,57,23.439999999999998,23.439999999999998,22.535,22.535,21.6,21.6,20.645,20.645,20.164999999999999,20.164999999999999,19.685000000000002,19.685000000000002,18.664999999999999,18.664999999999999,null,1.0191304347826087,0.97978260869565215,0.93913043478260871,0.89760869565217394,0.87673913043478258,0.85586956521739144,0.81152173913043479,1,1,1,1,1,1,1,1,1,1,1,1,1,1,23.439999999999998,22.535,21.6,20.645,20.164999999999999,19.685000000000002,18.664999999999999]
[80,72,29.07,15.84,27.800000000000004,15.310000000000002,26.49,14.77,25.15,14.23,24.5,13.964999999999998,23.85,13.7,22.44,13.14,null,1.2639130434782608,1.2086956521739132,1.1517391304347826,1.0934782608695652,1.0652173913043479,1.0369565217391306,0.97565217391304349,0.54489164086687303,0.55071942446043165,0.55756889392223485,0.56580516898608357,0.56999999999999995,0.57442348008385735,0.58556149732620322,1,1,1,1,1,1,1,15.84,15.310000000000002,14.77,14.23,13.964999999999998,13.7,13.14]
[null,67,26.62,19.73,25.45,19.149999999999999,24.24,18.559999999999999,23,17.96,22.395,17.670000000000002,21.79,17.38,20.48,16.760000000000002,null,1.1573913043478261,1.1065217391304347,1.0539130434782609,1,0.97369565217391307,0.94739130434782604,0.89043478260869569,0.74117205108940643,0.75245579567779952,0.76567656765676573,0.78086956521739137,0.78901540522438052,0.79761358421294171,0.81835937500000011,1,1,1,1,1,1,1,19.73,19.149999999999999,18.559999999999999,17.96,17.670000000000002,17.38,16.760000000000002]
[null,63,24.85,22.77,23.75,22.15,22.63,21.51,{"$f":"U18*$I$17","v":21.49},20.85,20.93,20.515000000000001,20.37,20.18,19.260000000000002,19.260000000000002,null,1.0804347826086957,1.0326086956521738,0.98391304347826081,0.93434782608695643,0.91,0.88565217391304352,0.83739130434782616,0.91629778672032192,0.93263157894736837,0.95050817498895279,0.97021870637505825,0.98017200191113241,0.99067255768286688,1,1,1,1,1,1,1,1,22.77,22.15,21.51,20.85,20.515000000000001,20.18,19.260000000000002]
[null,57,24.100000000000005,24.100000000000005,23.18,23.18,22.23,22.23,{"$f":"U19*$I$17","v":21.25},21.25,20.765000000000001,20.765000000000001,20.28,20.28,19.23,19.23,null,1.0478260869565219,1.0078260869565216,0.96652173913043482,0.92391304347826086,0.90282608695652178,0.88173913043478269,0.83608695652173914,1,1,1,1,1,1,1,1,1,1,1,1,1,1,24.100000000000005,23.18,22.23,21.25,20.765000000000001,20.28,19.23]

{"sheet":"24VNA9_24","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],[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],[7,0,10,0],[11,0,14,0],[15,0,18,0],[31,0,34,0],[35,0,38,0],[41,0,42,1],[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]]}
[]
["24VNA9_24",null,"24=24B"]
["Evaporator Air Flow",null,"Condenser  Entering Air Temperature ˚F"]
[825,"CFM",65,null,75,null,85,null,95,null,100,null,105,null,115]
["Evap. Air °F DB","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"]
[75,72,{"$f":"R8*$I$17","v":29.717916666666671},{"$f":"IF(AM8>C8,C8,AM8)","v":12.199583333333335},{"$f":"S8*$I$17","v":28.280416666666671},{"$f":"IF(AN8>E8,E8,AN8)","v":11.653333333333334},{"$f":"T8*$I$17","v":26.833333333333336},{"$f":"IF(AO8>G8,G8,AO8)","v":11.116666666666667},{"$f":"U8*$I$17","v":25.357500000000002},{"$f":"IF(AP8>I8,I8,AP8)","v":10.560833333333333},{"$f":"V8*$I$17","v":24.672291666666666},{"$f":"IF(AQ8>K8,K8,AQ8)","v":10.306874999999998},{"$f":"W8*$I$17","v":23.987083333333334},{"$f":"IF(AR8>M8,M8,AR8)","v":10.052916666666667},{"$f":"X8*$I$17","v":22.453749999999999},{"$f":"IF(AS8>O8,O8,AS8)","v":9.4875000000000007},null,1.2920833333333335,1.2295833333333335,1.1666666666666667,1.1025,1.0727083333333334,1.0429166666666667,0.97624999999999995,0.41051273782650755,0.41206370721789221,0.41428571428571426,0.41647770219198788,0.41775101961545924,0.41909708349980024,0.42253521126760568,1,1,1,1,1,1,1,{"$f":"Y8*C8*AF8","v":12.199583333333335},{"$f":"Z8*E8*AG8","v":11.653333333333334},{"$f":"AA8*G8*AH8","v":11.116666666666667},{"$f":"AB8*I8*AI8","v":10.560833333333333},{"$f":"AC8*K8*AJ8","v":10.306874999999998},{"$f":"AD8*M8*AK8","v":10.052916666666667},{"$f":"AE8*O8*AL8","v":9.4875000000000007}]
[null,67,27.015416666666667,16.004166666666666,25.702499999999997,{"$f":"IF(AN9>E9,E9,AN9)","v":15.429166666666665},24.399166666666666,{"$f":"IF(AO9>G9,G9,AO9)","v":14.854166666666666},23.067083333333333,{"$f":"IF(AP9>I9,I9,AP9)","v":14.269583333333333},22.439374999999998,{"$f":"IF(AQ9>K9,K9,AQ9)","v":13.996458333333333},21.811666666666667,{"$f":"IF(AR9>M9,M9,AR9)","v":13.723333333333334},20.412500000000001,{"$f":"IF(AS9>O9,O9,AS9)","v":13.129166666666666},null,1.1745833333333333,1.1174999999999999,1.0608333333333333,1.0029166666666667,0.97562499999999996,0.94833333333333336,0.88750000000000007,0.59240865555161404,0.60029828486204329,0.60879811468970935,0.61861238055670964,0.62374546231048478,0.62917398945518455,0.64319248826291076,1,1,1,1,1,1,1,{"$f":"Y9*C9*AF9","v":16.004166666666666},{"$f":"Z9*E9*AG9","v":15.429166666666665},{"$f":"AA9*G9*AH9","v":14.854166666666666},{"$f":"AB9*I9*AI9","v":14.269583333333333},{"$f":"AC9*K9*AJ9","v":13.996458333333333},{"$f":"AD9*M9*AK9","v":13.723333333333334},{"$f":"AE9*O9*AL9","v":13.129166666666666}]
[null,63,25.022083333333335,18.994166666666668,23.814583333333331,18.399999999999999,22.597499999999997,17.796250000000001,21.361249999999998,17.192499999999999,20.776666666666667,16.905000000000001,20.192083333333333,16.6175,18.917499999999997,15.994583333333333,null,1.0879166666666666,1.0354166666666667,0.98249999999999993,0.92874999999999996,0.90333333333333332,0.87791666666666668,0.8224999999999999,0.75909613175028723,0.77263581488933597,0.78753180661577615,0.80484522207267839,0.8136531365313654,0.8229710488846701,0.84549138804457968,1,1,1,1,1,1,1,18.994166666666668,18.399999999999999,17.796250000000001,17.192499999999999,16.905000000000001,16.6175,15.994583333333333]
[null,57,22.750833333333333,22.750833333333333,21.830833333333334,21.830833333333334,20.88208333333333,20.88208333333333,19.914166666666667,19.914166666666667,19.449375000000003,19.449375000000003,18.98458333333333,18.98458333333333,17.959166666666665,17.959166666666665,null,0.98916666666666664,0.94916666666666671,0.90791666666666659,0.86583333333333334,0.84562500000000007,0.82541666666666658,0.78083333333333327,1,1,1,1,1,1,1,1,1,1,1,1,1,1,22.750833333333333,21.830833333333334,20.88208333333333,19.914166666666667,19.449375000000003,18.98458333333333,17.959166666666665]
[77.5,72,29.684375000000003,14.097083333333336,28.246875000000003,13.536458333333334,26.799791666666668,12.980625000000002,25.323958333333334,12.410416666666665,24.638750000000002,12.149270833333334,23.953541666666666,11.888125,22.420208333333331,11.308333333333334,null,1.2906250000000001,1.2281250000000001,1.1652083333333334,1.1010416666666667,1.07125,1.0414583333333334,0.97479166666666661,0.47489911218724778,0.47921967769296009,0.48435544430538174,0.49006622516556286,0.49309607156748347,0.49629925985197043,0.50438127805086563,1,1,1,1,1,1,1,14.097083333333336,13.536458333333334,12.980625000000002,12.410416666666665,12.149270833333334,11.888125,11.308333333333334]
[null,67,26.981874999999999,17.887291666666666,25.673749999999998,17.293125,24.365624999999998,16.703749999999996,23.033541666666668,16.104791666666667,22.405833333333334,15.822083333333333,21.778124999999999,15.539374999999998,20.383749999999999,14.926041666666665,null,1.173125,1.11625,1.059375,1.0014583333333333,0.97416666666666663,0.94687500000000002,0.88624999999999998,0.66293731131237787,0.67357222844344911,0.68554572271386427,0.69918868317037652,0.70615911035072709,0.71353135313531346,0.73225199811941699,1,1,1,1,1,1,1,17.887291666666666,17.293125,16.703749999999996,16.104791666666667,15.822083333333333,15.539374999999998,14.926041666666665]
[null,63,25.017291666666665,20.853333333333332,23.819375000000001,20.230416666666667,22.611874999999998,19.602708333333332,21.39,18.960625,20.817395833333336,18.64916666666667,20.244791666666668,18.337708333333332,19.022916666666667,17.561458333333334,null,1.0877083333333333,1.035625,0.98312499999999992,0.93,0.90510416666666671,0.88020833333333337,0.82708333333333339,0.83355678988699478,0.84932609132971226,0.86692095783004874,0.88642473118279574,0.89584532167107844,0.90579881656804728,0.9231738035264484,1,1,1,1,1,1,1,20.853333333333332,20.230416666666667,19.602708333333332,18.960625,18.64916666666667,18.337708333333332,17.561458333333334]
[null,57,23.436041666666664,23.436041666666664,22.492083333333333,22.492083333333333,21.519374999999997,21.519374999999997,20.532291666666666,20.532291666666666,20.055520833333336,20.055520833333336,19.578749999999999,19.578749999999999,18.529375000000002,18.529375000000002,null,1.0189583333333332,0.97791666666666666,0.93562499999999993,0.89270833333333333,0.87197916666666675,0.85124999999999995,0.80562500000000004,1,1,1,1,1,1,1,1,1,1,1,1,1,1,23.436041666666664,22.492083333333333,21.519374999999997,20.532291666666666,20.055520833333336,19.578749999999999,18.529375000000002]
[80,72,29.650833333333335,15.994583333333333,28.213333333333335,15.419583333333335,26.766250000000003,14.844583333333334,25.290416666666665,14.26,24.605208333333334,13.991666666666667,23.92,13.723333333333333,22.386666666666667,13.129166666666666,null,1.2891666666666668,1.2266666666666668,1.1637500000000001,1.0995833333333334,1.0697916666666667,1.04,0.97333333333333327,0.53943115707821587,0.54653532608695654,0.55460078768349441,0.56384994316028803,0.56864654333008768,0.57371794871794868,0.58647260273972601,1,1,1,1,1,1,1,15.994583333333333,15.419583333333335,14.844583333333334,14.26,13.991666666666667,13.723333333333333,13.129166666666666]
[null,67,26.948333333333334,19.770416666666666,25.645,19.157083333333329,24.332083333333333,18.553333333333335,23,17.939999999999998,22.372291666666666,17.647708333333334,21.744583333333335,17.355416666666667,20.354999999999997,16.722916666666666,null,1.1716666666666666,1.115,1.0579166666666666,1,0.97270833333333329,0.94541666666666668,0.8849999999999999,0.73364153627311512,0.74701046337817623,0.76250492319810947,0.77999999999999992,0.78881987577639756,0.79814896430145432,0.82156308851224114,1,1,1,1,1,1,1,19.770416666666666,19.157083333333329,18.553333333333335,17.939999999999998,17.647708333333334,17.355416666666667,16.722916666666666]
[null,63,25.012500000000003,22.712499999999999,23.824166666666667,22.060833333333335,22.626249999999999,21.409166666666668,{"$f":"U18*$I$17","v":21.418749999999999},20.728749999999998,20.858125000000001,20.393333333333334,20.297499999999999,20.057916666666667,19.128333333333334,19.128333333333334,null,1.0875000000000001,1.0358333333333334,0.98375000000000001,0.93125000000000002,0.90687499999999999,0.88249999999999995,0.83166666666666667,0.90804597701149414,0.92598551890587288,0.9462092333756883,0.96778523489932877,0.97771651734436027,0.98819641170915962,1,1,1,1,1,1,1,1,22.712499999999999,22.060833333333335,21.409166666666668,20.728749999999998,20.393333333333334,20.057916666666667,19.128333333333334]
[null,57,24.121250000000003,24.121250000000003,23.153333333333332,23.153333333333332,22.156666666666666,22.156666666666666,{"$f":"U19*$I$17","v":21.150416666666665},21.150416666666665,20.661666666666669,20.661666666666669,20.172916666666666,20.172916666666666,19.099583333333335,19.099583333333335,null,1.0487500000000001,1.0066666666666666,0.96333333333333337,0.91958333333333331,0.89833333333333343,0.87708333333333333,0.83041666666666669,1,1,1,1,1,1,1,1,1,1,1,1,1,1,24.121250000000003,23.153333333333332,22.156666666666666,21.150416666666665,20.661666666666669,20.172916666666666,19.099583333333335]

{"sheet":"24VNA9_25","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],[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],[7,0,10,0],[11,0,14,0],[15,0,18,0],[31,0,34,0],[35,0,38,0],[41,0,42,1],[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]]}
[]
["24VNA9_25"]
["Evaporator Air Flow",null,"Condenser  Entering Air Temperature ˚F"]
[825,"CFM",65,null,75,null,85,null,95,null,100,null,105,null,115]
["Evap. Air °F DB","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"]
[75,72,{"$f":"R8*$I$17","v":29.075833333333332},{"$f":"IF(AM8>C8,C8,AM8)","v":11.950416666666666},{"$f":"S8*$I$17","v":27.868333333333332},{"$f":"IF(AN8>E8,E8,AN8)","v":11.490416666666667},{"$f":"T8*$I$17","v":26.612916666666663},{"$f":"IF(AO8>G8,G8,AO8)","v":11.020833333333332},{"$f":"U8*$I$17","v":25.328750000000003},{"$f":"IF(AP8>I8,I8,AP8)","v":10.541666666666668},{"$f":"V8*$I$17","v":24.701041666666669},{"$f":"IF(AQ8>K8,K8,AQ8)","v":10.306875},{"$f":"W8*$I$17","v":24.073333333333334},{"$f":"IF(AR8>M8,M8,AR8)","v":10.072083333333332},{"$f":"X8*$I$17","v":22.693333333333335},{"$f":"IF(AS8>O8,O8,AS8)","v":9.5737500000000004},null,1.2641666666666667,1.2116666666666667,1.1570833333333332,1.1012500000000001,1.0739583333333333,1.0466666666666666,0.98666666666666669,0.41100856954515491,0.41231086657496563,0.4141159524666907,0.41619371925841847,0.41726479146459744,0.41839171974522288,0.421875,1,1,1,1,1,1,1,{"$f":"Y8*C8*AF8","v":11.950416666666666},{"$f":"Z8*E8*AG8","v":11.490416666666667},{"$f":"AA8*G8*AH8","v":11.020833333333332},{"$f":"AB8*I8*AI8","v":10.541666666666668},{"$f":"AC8*K8*AJ8","v":10.306875},{"$f":"AD8*M8*AK8","v":10.072083333333332},{"$f":"AE8*O8*AL8","v":9.5737500000000004}]
[null,67,26.565000000000001,15.850833333333334,25.443749999999998,{"$f":"IF(AN9>E9,E9,AN9)","v":15.342916666666667},24.293750000000003,{"$f":"IF(AO9>G9,G9,AO9)","v":14.835000000000001},23.095833333333331,{"$f":"IF(AP9>I9,I9,AP9)","v":14.307916666666664},22.511250000000004,{"$f":"IF(AQ9>K9,K9,AQ9)","v":14.049166666666668},21.926666666666666,{"$f":"IF(AR9>M9,M9,AR9)","v":13.790416666666667},20.652083333333334,{"$f":"IF(AS9>O9,O9,AS9)","v":13.244166666666667},null,1.155,1.10625,1.0562500000000001,1.0041666666666667,0.97875000000000012,0.95333333333333325,0.8979166666666667,0.5966810966810967,0.60301318267419968,0.61065088757396446,0.61950207468879659,0.6240953597275436,0.62893356643356646,0.64129930394431556,1,1,1,1,1,1,1,{"$f":"Y9*C9*AF9","v":15.850833333333334},{"$f":"Z9*E9*AG9","v":15.342916666666667},{"$f":"AA9*G9*AH9","v":14.835000000000001},{"$f":"AB9*I9*AI9","v":14.307916666666664},{"$f":"AC9*K9*AJ9","v":14.049166666666668},{"$f":"AD9*M9*AK9","v":13.790416666666667},{"$f":"AE9*O9*AL9","v":13.244166666666667}]
[null,63,24.696249999999999,18.89833333333333,23.642083333333336,18.361666666666668,22.559166666666666,17.815416666666668,21.447500000000002,17.25,20.891666666666666,16.976875,20.335833333333333,16.703749999999999,19.137916666666666,16.109583333333333,null,1.07375,1.0279166666666668,0.98083333333333333,0.9325,0.90833333333333321,0.88416666666666666,0.83208333333333329,0.76523088863019006,0.77665180381029586,0.78971962616822433,0.80428954423592491,0.81261467889908268,0.82139491046182844,0.84176264396594891,1,1,1,1,1,1,1,18.89833333333333,18.361666666666668,17.815416666666668,17.25,16.976875,16.703749999999999,16.109583333333333]
[null,57,22.635833333333334,22.635833333333334,21.802083333333332,21.802083333333332,20.93,20.93,20.03875,20.03875,19.588333333333331,19.588333333333331,19.137916666666666,19.137916666666666,18.170000000000002,18.170000000000002,null,0.98416666666666675,0.94791666666666663,0.91,0.87124999999999997,0.85166666666666657,0.83208333333333329,0.79,1,1,1,1,1,1,1,1,1,1,1,1,1,1,22.635833333333334,21.802083333333332,20.93,20.03875,19.588333333333331,19.137916666666666,18.170000000000002]
[77.5,72,28.984791666666663,13.843125000000001,27.777291666666667,13.36875,26.526666666666667,12.88,25.2425,12.386458333333335,24.614791666666665,12.144479166666667,23.987083333333334,11.9025,22.616666666666667,11.385,null,1.2602083333333332,1.2077083333333334,1.1533333333333333,1.0974999999999999,1.0702083333333332,1.0429166666666667,0.98333333333333339,0.47759960324020506,0.48128342245989303,0.48554913294797691,0.49069855732725898,0.49338135098306407,0.49620455453455853,0.50338983050847452,1,1,1,1,1,1,1,13.843125000000001,13.36875,12.88,12.386458333333335,12.144479166666667,11.9025,11.385]
[null,67,26.512291666666663,17.729166666666664,25.395833333333336,17.206875,24.241041666666668,16.679791666666667,23.047916666666669,16.138333333333332,22.463333333333335,15.872395833333332,21.878749999999997,15.606458333333332,20.608958333333334,15.036249999999999,null,1.1527083333333332,1.1041666666666667,1.0539583333333333,1.0020833333333334,0.97666666666666668,0.95124999999999993,0.89604166666666674,0.66871498283029096,0.67754716981132068,0.68808064834947613,0.70020790020790014,0.70659129692832756,0.7133158125273763,0.72959776796093923,1,1,1,1,1,1,1,17.729166666666664,17.206875,16.679791666666667,16.138333333333332,15.872395833333332,15.606458333333332,15.036249999999999]
[null,63,24.696249999999999,20.767083333333336,23.646874999999998,20.21125,22.573541666666667,19.641041666666666,21.471458333333334,19.051666666666669,20.922812499999999,18.756979166666664,20.374166666666664,18.462291666666665,19.243333333333332,17.729166666666668,null,1.07375,1.028125,0.98145833333333332,0.93354166666666671,0.90968749999999998,0.88583333333333325,0.83666666666666656,0.84090027163368264,0.8547112462006079,0.87009127573763523,0.88730194153090836,0.89648459864880337,0.90616180620884301,0.92131474103585664,1,1,1,1,1,1,1,20.767083333333336,20.21125,19.641041666666666,19.051666666666669,18.756979166666664,18.462291666666665,17.729166666666668]
[null,57,23.297083333333333,23.297083333333333,22.444166666666668,22.444166666666668,21.557708333333331,21.557708333333331,20.637708333333336,20.637708333333336,20.182499999999997,20.182499999999997,19.72729166666667,19.72729166666667,18.740208333333335,18.740208333333335,null,1.0129166666666667,0.97583333333333344,0.93729166666666652,0.89729166666666671,0.87749999999999995,0.85770833333333341,0.81479166666666669,1,1,1,1.0004643603436267,1.0002374169040835,1,1,1,1,1,1,1,1,1,23.297083333333333,22.444166666666668,21.557708333333331,20.647291666666671,20.187291666666663,19.72729166666667,18.740208333333335]
[80,72,28.893749999999997,15.735833333333334,27.686250000000001,15.247083333333336,26.440416666666668,14.739166666666668,25.15625,14.231250000000001,24.528541666666666,13.982083333333334,23.900833333333335,13.732916666666666,22.54,13.196249999999999,null,1.2562499999999999,1.2037500000000001,1.1495833333333334,1.09375,1.0664583333333333,1.0391666666666668,0.98,0.54461028192371486,0.55070958809276571,0.55744835085175792,0.56571428571428573,0.57003320961125226,0.57457898957497988,0.58545918367346939,1,1,1,1,1,1,1,15.735833333333334,15.247083333333336,14.739166666666668,14.231250000000001,13.982083333333334,13.732916666666666,13.196249999999999]
[null,67,26.459583333333335,19.607500000000002,25.347916666666666,19.070833333333333,24.188333333333329,18.524583333333329,23,17.96875,22.415416666666665,17.695625,21.830833333333334,17.422499999999999,20.565833333333334,16.828333333333333,null,1.1504166666666666,1.1020833333333333,1.0516666666666665,1,0.97458333333333336,0.94916666666666671,0.89416666666666667,0.74103585657370519,0.75236294896030242,0.76584786053882725,0.78125,0.78943993159469861,0.79806848112379269,0.81826654240447338,1,1,1,1,1,1,1,19.607500000000002,19.070833333333333,18.524583333333329,17.96875,17.695625,17.422499999999999,16.828333333333333]
[null,63,24.696249999999999,22.635833333333334,23.651666666666667,22.060833333333335,22.587916666666665,21.466666666666665,{"$f":"U18*$I$17","v":21.495416666666667},20.853333333333335,20.953958333333336,20.537083333333332,20.412500000000001,20.220833333333335,19.348750000000003,19.348750000000003,null,1.07375,1.0283333333333333,0.98208333333333331,0.93458333333333332,0.91104166666666675,0.88750000000000007,0.84125000000000005,0.9165696546371751,0.9327390599675851,0.95036062791684339,0.97012929112795376,0.9801051909444316,0.99061032863849774,1,1,1,1,1,1,1,1,22.635833333333334,22.060833333333335,21.466666666666665,20.853333333333335,20.537083333333332,20.220833333333335,19.348750000000003]
[null,57,23.958333333333336,23.958333333333336,23.08625,23.08625,22.185416666666665,22.185416666666665,{"$f":"U19*$I$17","v":21.236666666666668},21.236666666666668,20.776666666666667,20.776666666666667,20.316666666666666,20.316666666666666,19.310416666666665,19.310416666666665,null,1.0416666666666667,1.0037499999999999,0.96458333333333324,0.92333333333333334,0.90333333333333332,0.8833333333333333,0.83958333333333324,1,1,1,1.0009025270758123,1.000461254612546,1,1,1,1,1,1,1,1,1,23.958333333333336,23.08625,22.185416666666665,21.255833333333335,20.786249999999999,20.316666666666666,19.310416666666665]

{"sheet":"24VNA9_36","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],[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],[7,0,10,0],[11,0,14,0],[15,0,18,0],[31,0,34,0],[35,0,38,0],[41,0,42,1],[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]]}
[]
["24VNA9_36"]
["Evaporator Air Flow",null,"Condenser  Entering Air Temperature ˚F"]
[1050,"CFM",65,null,75,null,85,null,95,null,100,null,105,null,115]
["Evap. Air °F DB","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"]
[75,72,{"$f":"R8*$I$17","v":29.032571428571426},{"$f":"IF(AM8>C8,C8,AM8)","v":11.815428571428571},{"$f":"S8*$I$17","v":27.783999999999999},{"$f":"IF(AN8>E8,E8,AN8)","v":11.329142857142855},{"$f":"T8*$I$17","v":26.482857142857139},{"$f":"IF(AO8>G8,G8,AO8)","v":10.823142857142855},{"$f":"U8*$I$17","v":25.162000000000003},{"$f":"IF(AP8>I8,I8,AP8)","v":10.974285714285715},{"$f":"V8*$I$17","v":24.54428571428571},{"$f":"IF(AQ8>K8,K8,AQ8)","v":10.41242857142857},{"$f":"W8*$I$17","v":23.926571428571428},{"$f":"IF(AR8>M8,M8,AR8)","v":9.8505714285714294},{"$f":"X8*$I$17","v":22.50057142857143},{"$f":"IF(AS8>O8,O8,AS8)","v":9.3182857142857127},null,1.2622857142857142,1.208,1.1514285714285712,1.0940000000000001,1.0671428571428569,1.0402857142857143,0.97828571428571431,0.40697148030783159,0.40775780510879844,0.40868486352357319,0.436145207626012,0.4242302543507363,0.41170008239494649,0.41413551401869153,1,1,1,1,1,1,1,{"$f":"Y8*C8*AF8","v":11.815428571428571},{"$f":"Z8*E8*AG8","v":11.329142857142855},{"$f":"AA8*G8*AH8","v":10.823142857142855},{"$f":"AB8*I8*AI8","v":10.974285714285715},{"$f":"AC8*K8*AJ8","v":10.41242857142857},{"$f":"AD8*M8*AK8","v":9.8505714285714294},{"$f":"AE8*O8*AL8","v":9.3182857142857127}]
[null,67,26.62742857142857,15.25885714285714,25.490571428571428,{"$f":"IF(AN9>E9,E9,AN9)","v":14.733142857142859},24.307714285714287,{"$f":"IF(AO9>G9,G9,AO9)","v":14.194285714285714},23.085428571428572,{"$f":"IF(AP9>I9,I9,AP9)","v":13.635714285714286},22.50057142857143,{"$f":"IF(AQ9>K9,K9,AQ9)","v":13.372857142857143},21.915714285714287,{"$f":"IF(AR9>M9,M9,AR9)","v":13.11},20.621142857142857,{"$f":"IF(AS9>O9,O9,AS9)","v":12.531714285714287},null,1.1577142857142857,1.1082857142857143,1.0568571428571429,1.0037142857142858,0.97828571428571431,0.95285714285714285,0.89657142857142857,0.57305034550839085,0.57798401649909781,0.58394160583941601,0.59066325078280668,0.59433411214953269,0.59820089955022482,0.60771191841937544,1,1,1,1,1,1,1,{"$f":"Y9*C9*AF9","v":15.25885714285714},{"$f":"Z9*E9*AG9","v":14.733142857142859},{"$f":"AA9*G9*AH9","v":14.194285714285714},{"$f":"AB9*I9*AI9","v":13.635714285714286},{"$f":"AC9*K9*AJ9","v":13.372857142857143},{"$f":"AD9*M9*AK9","v":13.11},{"$f":"AE9*O9*AL9","v":12.531714285714287}]
[null,63,24.83342857142857,17.953142857142858,23.768857142857147,17.394571428571428,22.658285714285714,16.816285714285716,21.514857142857146,16.231428571428573,20.966142857142856,15.94885714285714,20.417428571428569,15.666285714285713,19.195142857142859,15.04857142857143,null,1.0797142857142856,1.0334285714285716,0.9851428571428571,0.9354285714285715,0.91157142857142859,0.88771428571428568,0.83457142857142863,0.72294257740142898,0.73182195189383459,0.7421693735498841,0.75442883323152099,0.76069581570286782,0.76729964596073386,0.7839780896953098,1,1,1,1,1,1,1,17.953142857142858,17.394571428571428,16.816285714285716,16.231428571428573,15.94885714285714,15.666285714285713,15.04857142857143]
[null,57,22.395428571428571,21.823714285714289,21.455714285714286,21.192857142857143,20.502857142857145,20.502857142857145,19.615714285714287,19.615714285714287,19.172142857142859,19.172142857142859,18.728571428571428,18.728571428571428,17.775714285714287,17.775714285714287,null,0.97371428571428564,0.93285714285714283,0.89142857142857146,0.85285714285714287,0.83357142857142863,0.81428571428571428,0.77285714285714291,0.97447183098591561,0.98774885145482394,1,1,1,1,1,1,1,1,1,1,1,1,21.823714285714289,21.192857142857143,20.502857142857145,19.615714285714287,19.172142857142859,18.728571428571428,17.775714285714287]
[77.5,72,28.96685714285714,13.468142857142857,27.718285714285713,12.965428571428568,26.417142857142856,12.439714285714285,25.09628571428571,12.242571428571425,24.478571428571428,11.835142857142856,23.860857142857146,11.427714285714288,22.434857142857144,10.875714285714286,null,1.2594285714285713,1.2051428571428571,1.1485714285714286,1.091142857142857,1.0642857142857143,1.0374285714285716,0.97542857142857142,0.46495009074410165,0.46775723091512555,0.47089552238805965,0.4878240377062058,0.48348993288590597,0.47893142385017901,0.48476859988283538,1,1,1,1,1,1,1,13.468142857142857,12.965428571428568,12.439714285714285,12.242571428571425,11.835142857142856,11.427714285714288,10.875714285714286]
[null,67,26.584714285714288,16.898428571428571,25.447857142857139,16.353000000000002,24.264999999999997,15.794428571428572,23.042714285714283,15.219428571428571,22.459499999999995,14.948357142857143,21.876285714285714,14.677285714285714,20.578428571428571,14.079285714285716,null,1.1558571428571429,1.1064285714285713,1.0549999999999999,1.0018571428571428,0.97649999999999981,0.95114285714285707,0.89471428571428568,0.63564454331973796,0.64260813428018093,0.65091401489505762,0.66048766576358198,0.66556945358788688,0.67092219885851612,0.68417691202299225,1,1,1,1,1,1,1,16.898428571428571,16.353000000000002,15.794428571428572,15.219428571428571,14.948357142857143,14.677285714285714,14.079285714285716]
[null,63,24.810428571428567,19.58285714285714,23.749142857142861,19.007857142857144,22.641857142857141,18.409857142857142,21.501714285714286,17.802,20.956285714285713,17.509571428571427,20.410857142857143,17.217142857142857,19.195142857142859,16.576428571428576,null,1.0787142857142855,1.0325714285714287,0.98442857142857143,0.93485714285714283,0.91114285714285714,0.88742857142857146,0.83457142857142863,0.78929943053900153,0.80035971223021574,0.81308953707734732,0.82793398533007334,0.83552837880213227,0.84352865421764323,0.8635741184525848,1,1,1,1,1,1,1,19.58285714285714,19.007857142857144,18.409857142857142,17.802,17.509571428571427,17.217142857142857,16.576428571428576]
[null,57,22.908000000000001,22.622142857142858,22.00114285714286,21.869714285714284,21.077857142857145,21.077857142857145,20.167714285714286,20.167714285714286,19.717571428571429,19.717571428571429,19.267428571428571,19.267428571428571,18.288285714285713,18.288285714285713,null,0.996,0.95657142857142874,0.91642857142857148,0.87685714285714289,0.85728571428571432,0.83771428571428574,0.79514285714285704,0.9875215146299483,0.99402628434886486,1,1,1,1,1,1,1,1,1,1,1,1,22.622142857142858,21.869714285714284,21.077857142857145,20.167714285714286,19.717571428571429,19.267428571428571,18.288285714285713]
[80,72,28.901142857142855,15.120857142857144,27.652571428571427,14.601714285714285,26.351428571428571,14.056285714285714,25.030571428571427,13.510857142857141,24.412857142857145,13.257857142857141,23.79514285714286,13.004857142857144,22.369142857142855,12.433142857142858,null,1.2565714285714285,1.2022857142857142,1.1457142857142857,1.0882857142857143,1.0614285714285716,1.0345714285714287,0.97257142857142853,0.52319236016371085,0.52804182509505704,0.53341645885286781,0.53977421895510624,0.54306864064602944,0.54653410660038659,0.55581668625146896,1,1,1,1,1,1,1,15.120857142857144,14.601714285714285,14.056285714285714,13.510857142857141,13.257857142857141,13.004857142857144,12.433142857142858]
[null,67,26.541999999999998,18.537999999999997,25.405142857142856,17.972857142857144,24.222285714285714,17.394571428571428,23,16.803142857142856,22.418428571428567,16.523857142857143,21.836857142857141,16.24457142857143,20.535714285714288,15.626857142857146,null,1.1539999999999999,1.1045714285714285,1.0531428571428572,1,0.97471428571428553,0.94942857142857129,0.8928571428571429,0.69844020797227035,0.70744956026901196,0.71812262615301137,0.73057142857142854,0.73706580682984035,0.74390610893770692,0.76096000000000008,1,1,1,1,1,1,1,18.537999999999997,17.972857142857144,17.394571428571428,16.803142857142856,16.523857142857143,16.24457142857143,15.626857142857146]
[null,63,24.78742857142857,21.21257142857143,23.729428571428574,20.621142857142857,22.625428571428571,20.003428571428572,{"$f":"U18*$I$17","v":21.488571428571429},19.37257142857143,20.946428571428569,19.070285714285713,20.404285714285713,18.767999999999997,19.195142857142859,18.104285714285716,null,1.0777142857142856,1.0317142857142858,0.98371428571428565,0.93428571428571439,0.9107142857142857,0.88714285714285712,0.83457142857142863,0.85577942735949108,0.86901135419551367,0.88411269241940171,0.90152905198776756,0.91043137254901962,0.91980676328502409,0.94317014720985959,1,1,1,1,1,1,1,21.21257142857143,20.621142857142857,20.003428571428572,19.37257142857143,19.070285714285713,18.767999999999997,18.104285714285716]
[null,57,23.420571428571428,23.420571428571428,22.546571428571429,22.546571428571429,21.652857142857144,21.652857142857144,{"$f":"U19*$I$17","v":20.719714285714286},20.719714285714286,20.263000000000002,20.263000000000002,19.806285714285714,19.806285714285714,18.800857142857144,18.800857142857144,null,1.0182857142857142,0.98028571428571432,0.9414285714285715,0.90085714285714291,0.88100000000000001,0.86114285714285721,0.81742857142857139,1,1,1,1,1,1,1,1,1,1,1,1,1,1,23.420571428571428,22.546571428571429,21.652857142857144,20.719714285714286,20.263000000000002,19.806285714285714,18.800857142857144]

{"sheet":"24VNA9_48","index":7,"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],[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],[7,0,10,0],[11,0,14,0],[15,0,18,0],[31,0,34,0],[35,0,38,0],[41,0,42,1],[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]]}
[]
["24VNA9_48"]
["Evaporator Air Flow",null,"Condenser  Entering Air Temperature ˚F"]
[1400,"CFM",65,null,75,null,85,null,95,null,100,null,105,null,115]
["Evap. Air °F DB","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"]
[75,72,{"$f":"R8*$I$17","v":29.465665236051503},{"$f":"IF(AM8>C8,C8,AM8)","v":11.988626609442059},{"$f":"S8*$I$17","v":28.078755364806863},{"$f":"IF(AN8>E8,E8,AN8)","v":11.445708154506438},{"$f":"T8*$I$17","v":26.642489270386264},{"$f":"IF(AO8>G8,G8,AO8)","v":10.887982832618025},{"$f":"U8*$I$17","v":25.166738197424895},{"$f":"IF(AP8>I8,I8,AP8)","v":10.32038626609442},{"$f":"V8*$I$17","v":24.418991416309016},{"$f":"IF(AQ8>K8,K8,AQ8)","v":10.03658798283262},{"$f":"W8*$I$17","v":23.67124463519313},{"$f":"IF(AR8>M8,M8,AR8)","v":9.7527896995708154},{"$f":"X8*$I$17","v":22.121459227467813},{"$f":"IF(AS8>O8,O8,AS8)","v":9.1654506437768255},null,1.2811158798283262,1.2208154506437767,1.1583690987124462,1.0942060085836911,1.0616952789699572,1.0291845493562231,0.96180257510729616,0.40686767169179228,0.40762875725083497,0.40866987773249353,0.41008040792312217,0.4110156644770086,0.41201000834028362,0.41432396251673359,1,1,1,1,1,1,1,{"$f":"Y8*C8*AF8","v":11.988626609442059},{"$f":"Z8*E8*AG8","v":11.445708154506438},{"$f":"AA8*G8*AH8","v":10.887982832618025},{"$f":"AB8*I8*AI8","v":10.32038626609442},{"$f":"AC8*K8*AJ8","v":10.03658798283262},{"$f":"AD8*M8*AK8","v":9.7527896995708154},{"$f":"AE8*O8*AL8","v":9.1654506437768255}]
[null,67,26.948497854077253,15.433690987124463,25.670171673819741,{"$f":"IF(AN9>E9,E9,AN9)","v":14.826609442060086},24.362231759656652,{"$f":"IF(AO9>G9,G9,AO9)","v":14.214592274678113},23.024678111587981,{"$f":"IF(AP9>I9,I9,AP9)","v":13.592703862660942},22.336158798283261,{"$f":"IF(AQ9>K9,K9,AQ9)","v":13.276824034334764},21.647639484978541,{"$f":"IF(AR9>M9,M9,AR9)","v":12.960944206008584},20.231115879828327,{"$f":"IF(AS9>O9,O9,AS9)","v":12.314377682403432},null,1.1716738197424892,1.1160944206008583,1.0592274678111588,1.0010729613733904,0.97113733905579391,0.94120171673819741,0.8796137339055794,0.57271062271062267,0.57758123437800424,0.58346839546191254,0.5903536977491961,0.59440945751850627,0.59872321021431829,0.60868504513295918,1,1,1,1,1,1,1,{"$f":"Y9*C9*AF9","v":15.433690987124463},{"$f":"Z9*E9*AG9","v":14.826609442060086},{"$f":"AA9*G9*AH9","v":14.214592274678113},{"$f":"AB9*I9*AI9","v":13.592703862660942},{"$f":"AC9*K9*AJ9","v":13.276824034334764},{"$f":"AD9*M9*AK9","v":12.960944206008584},{"$f":"AE9*O9*AL9","v":12.314377682403432}]
[null,63,25.063090128755366,18.123605150214591,23.873605150214587,17.472103004291842,22.659442060085837,16.815665236051505,21.405793991416306,16.149356223175964,20.76909871244635,15.813733905579397,20.132403433476394,15.478111587982832,18.819527896995709,14.792060085836908,null,1.0896995708154507,1.0379828326180256,0.98519313304721023,0.93068669527896986,0.90300429184549347,0.87532188841201708,0.81824034334763951,0.72311933832217401,0.73185859003514575,0.74210411675016341,0.75443855199446619,0.76140684410646386,0.76881588624662911,0.78599527930763169,1,1,1,1,1,1,1,18.123605150214591,17.472103004291842,16.815665236051505,16.149356223175964,15.813733905579397,15.478111587982832,14.792060085836908]
[null,57,22.555793991416309,22.007939914163089,21.509442060085835,21.267596566523604,20.458154506437769,20.458154506437769,19.47596566523605,19.47596566523605,18.970064377682405,18.970064377682405,18.464163090128753,18.464163090128753,17.417811158798283,17.417811158798283,null,0.98068669527897001,0.93519313304721019,0.88948497854077258,0.84678111587982829,0.82478540772532194,0.80278969957081536,0.75729613733905576,0.97571115973741795,0.98875631023405242,1,1,1,1,1,1,1,1,1,1,1,1,22.007939914163089,21.267596566523604,20.458154506437769,19.47596566523605,18.970064377682405,18.464163090128753,17.417811158798283]
[77.5,72,29.411373390557941,13.661802575107295,28.021995708154503,13.09173819742489,26.588197424892702,12.506866952789698,25.112446351931329,11.91212446351931,24.36469957081545,11.613519313304721,23.616952789699567,11.314914163090128,22.067167381974247,10.700429184549355,null,1.278755364806867,1.2183476394849784,1.156008583690987,1.0918454935622317,1.0593347639484978,1.0268240343347639,0.95944206008583688,0.4645074676959221,0.4671950682518714,0.47039168368294043,0.47435141509433953,0.47665349944292518,0.47910135841170326,0.48490270632968013,1,1,1,1,1,1,1,13.661802575107295,13.09173819742489,12.506866952789698,11.91212446351931,11.613519313304721,11.314914163090128,10.700429184549355]
[null,67,26.911480686695281,17.089592274678111,25.633154506437766,16.457832618025748,24.325214592274673,15.821137339055792,23.012339055793991,15.172103004291845,22.311480686695276,14.842650214592274,21.610622317596565,14.513197424892704,20.194098712446355,13.841952789699572,null,1.1700643776824036,1.1144849785407724,1.0576180257510728,1.0005364806866952,0.97006437768240339,0.93959227467811146,0.87800429184549367,0.63502980284273258,0.64205256570713387,0.65040073044536884,0.6593029490616622,0.66524720716734875,0.67157702409500974,0.68544543565929361,1,1,1,1,1,1,1,17.089592274678111,16.457832618025748,15.821137339055792,15.172103004291845,14.842650214592274,14.513197424892704,13.841952789699572]
[null,63,25.043347639484978,19.772103004291846,23.856330472103004,19.095922746781117,22.64216738197425,18.415793991416308,21.395922746781114,17.716416309012875,20.760461373390555,17.365987124463516,20.124999999999996,17.015557939914164,18.819527896995709,16.294957081545064,null,1.0888412017167381,1.0372317596566523,0.9844420600858369,0.9302575107296136,0.9026287553648068,0.87499999999999989,0.81824034334763951,0.7895151754040205,0.80045515671873391,0.81334059945504078,0.82802768166089968,0.83649331352154532,0.84549356223175975,0.86585365853658536,1,1,1,1,1,1,1,19.772103004291846,19.095922746781117,18.415793991416308,17.716416309012875,17.365987124463516,17.015557939914164,16.294957081545064]
[null,57,23.078969957081547,22.805042918454934,22.067167381974247,21.946244635193132,21.040557939914162,21.040557939914162,20.033690987124466,20.033690987124466,19.517918454935621,19.517918454935621,19.002145922746781,19.002145922746781,17.928648068669528,17.928648068669528,null,1.0034334763948498,0.95944206008583688,0.91480686695278968,0.87103004291845498,0.84860515021459226,0.82618025751072954,0.77950643776824036,0.98813088109495284,0.99452024155669883,1,1,1,1,1,1,1,1,1,1,1,1,22.805042918454934,21.946244635193132,21.040557939914162,20.033690987124466,19.517918454935621,19.002145922746781,17.928648068669528]
[80,72,29.357081545064375,15.334978540772532,27.965236051502146,14.737768240343348,26.533905579399139,14.125751072961375,25.058154506437766,13.503862660944204,24.310407725321888,13.190450643776824,23.562660944206009,12.877038626609442,22.012875536480689,12.235407725321888,null,1.2763948497854076,1.2158798283261802,1.1536480686695278,1.0894849785407725,1.0569742489270386,1.0244635193133047,0.9570815450643777,0.52236045729657032,0.52700317684433462,0.53236607142857151,0.53890092574354931,0.54258450918688461,0.54650188521156262,0.55582959641255603,1,1,1,1,1,1,1,15.334978540772532,14.737768240343348,14.125751072961375,13.503862660944204,13.190450643776824,12.877038626609442,12.235407725321888]
[null,67,26.874463519313309,18.745493562231761,25.59613733905579,18.089055793991413,24.288197424892704,17.427682403433476,23,16.751502145922743,22.286802575107295,16.408476394849782,21.573605150214593,16.065450643776824,20.157081545064379,15.369527896995709,null,1.1684549356223177,1.1128755364806866,1.0560085836909872,1,0.96899141630901287,0.93798283261802573,0.87639484978540783,0.69752066115702471,0.70671037408407245,0.71753708595813859,0.72832618025751061,0.73624183368397733,0.74468085106382975,0.76248775710088146,1,1,1,1,1,1,1,18.745493562231761,18.089055793991413,17.427682403433476,16.751502145922743,16.408476394849782,16.065450643776824,15.369527896995709]
[null,63,25.023605150214596,21.420600858369099,23.839055793991417,20.719742489270384,22.624892703862663,20.015922746781118,{"$f":"U18*$I$17","v":21.386051502145921},19.283476394849785,20.751824034334764,18.918240343347637,20.117596566523606,18.553004291845497,18.819527896995709,17.79785407725322,null,1.0879828326180259,1.0364806866952789,0.98369098712446357,0.92982832618025746,0.90225321888412013,0.87467811158798281,0.81824034334763951,0.8560157790927021,0.86915113871635608,0.88468586387434556,0.9016847449803832,0.91164228802473535,0.92222767419038287,0.94571203776553892,1,1,1,1,1,1,1,21.420600858369099,20.719742489270384,20.015922746781118,19.283476394849785,18.918240343347637,18.553004291845497,17.79785407725322]
[null,57,23.602145922746779,23.602145922746779,22.624892703862663,22.624892703862663,21.622961373390559,21.622961373390559,{"$f":"U19*$I$17","v":20.591416309012875},20.591416309012875,20.065772532188841,20.065772532188841,19.540128755364808,19.540128755364808,18.439484978540772,18.439484978540772,null,1.0261802575107295,0.98369098712446357,0.94012875536480689,0.89527896995708145,0.8724248927038627,0.84957081545064383,0.80171673819742484,1,1,1,1,1,1,1,1,1,1,1,1,1,1,23.602145922746779,22.624892703862663,21.622961373390559,20.591416309012875,20.065772532188841,19.540128755364808,18.439484978540772]

{"sheet":"24VNA9_60","index":8,"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],[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],[7,0,10,0],[11,0,14,0],[15,0,18,0],[31,0,34,0],[35,0,38,0],[41,0,42,1],[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]]}
[]
["24VNA9_60"]
["Evaporator Air Flow",null,"Condenser  Entering Air Temperature ˚F"]
[1600,"CFM",65,null,75,null,85,null,95,null,100,null,105,null,115]
["Evap. Air °F DB","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"]
[75,72,{"$f":"R8*$I$17","v":29.290701754385964},{"$f":"IF(AM8>C8,C8,AM8)","v":11.887368421052631},{"$f":"S8*$I$17","v":27.963157894736842},{"$f":"IF(AN8>E8,E8,AN8)","v":11.36280701754386},{"$f":"T8*$I$17","v":26.615438596491224},{"$f":"IF(AO8>G8,G8,AO8)","v":10.838245614035086},{"$f":"U8*$I$17","v":25.235438596491228},{"$f":"IF(AP8>I8,I8,AP8)","v":10.301578947368421},{"$f":"V8*$I$17","v":24.521228070175439},{"$f":"IF(AQ8>K8,K8,AQ8)","v":17.054298245614035},{"$f":"W8*$I$17","v":23.807017543859651},{"$f":"IF(AR8>M8,M8,AR8)","v":23.807017543859651},{"$f":"X8*$I$17","v":22.346315789473685},{"$f":"IF(AS8>O8,O8,AS8)","v":9.1959649122807008},null,1.2735087719298246,1.2157894736842105,1.1571929824561402,1.0971929824561404,1.0661403508771929,1.0350877192982457,0.9715789473684211,0.40584102493456398,0.40634920634920635,0.40721649484536088,0.40821874000639591,0.69549119631397072,1,0.41152040447815091,1,1,1,1,1,1,1,{"$f":"Y8*C8*AF8","v":11.887368421052631},{"$f":"Z8*E8*AG8","v":11.36280701754386},{"$f":"AA8*G8*AH8","v":10.838245614035086},{"$f":"AB8*I8*AI8","v":10.301578947368421},{"$f":"AC8*K8*AJ8","v":17.054298245614035},{"$f":"AD8*M8*AK8","v":23.807017543859651},{"$f":"AE8*O8*AL8","v":9.1959649122807008}]
[null,67,26.716315789473683,15.083157894736845,25.521929824561404,{"$f":"IF(AN9>E9,E9,AN9)","v":14.522280701754388},24.299298245614036,{"$f":"IF(AO9>G9,G9,AO9)","v":13.949298245614036},23.048421052631575,{"$f":"IF(AP9>I9,I9,AP9)","v":13.372280701754384},22.408859649122803,{"$f":"IF(AQ9>K9,K9,AQ9)","v":17.570789473684208},21.769298245614035,{"$f":"IF(AR9>M9,M9,AR9)","v":21.769298245614035},20.429649122807017,{"$f":"IF(AS9>O9,O9,AS9)","v":12.177894736842104},null,1.161578947368421,1.1096491228070176,1.0564912280701755,1.0021052631578946,0.974298245614035,0.94649122807017549,0.88824561403508773,0.56456728590847316,0.56901185770750995,0.57406177349717702,0.5801820728291317,0.78410011704330607,1,0.59608927513332011,1,1,1,1,1,1,1,{"$f":"Y9*C9*AF9","v":15.083157894736845},{"$f":"Z9*E9*AG9","v":14.522280701754388},{"$f":"AA9*G9*AH9","v":13.949298245614036},{"$f":"AB9*I9*AI9","v":13.372280701754384},{"$f":"AC9*K9*AJ9","v":17.570789473684208},{"$f":"AD9*M9*AK9","v":21.769298245614035},{"$f":"AE9*O9*AL9","v":12.177894736842104}]
[null,63,24.823859649122809,17.584912280701754,23.718245614035087,16.99175438596491,22.592456140350876,16.390526315789472,21.438421052631579,15.785263157894736,20.843245614035087,18.016666666666666,20.248070175438595,20.248070175438595,19.009298245614033,14.526315789473683,null,1.0792982456140352,1.0312280701754386,0.98228070175438598,0.93210526315789477,0.9062280701754386,0.88035087719298244,0.82649122807017539,0.70838751625487639,0.71640013610071451,0.72548669405250932,0.73630717108977972,0.86438873293969598,1,0.76416896624920405,1,1,1,1,1,1,1,17.584912280701754,16.99175438596491,16.390526315789472,15.785263157894736,18.016666666666666,20.248070175438595,14.526315789473683]
[null,57,22.297894736842103,21.232631578947366,21.329473684210527,20.58298245614035,20.352982456140349,19.921228070175438,19.356315789473683,19.219122807017545,18.868070175438596,18.799473684210529,18.379824561403506,18.379824561403506,17.415438596491228,17.415438596491228,null,0.96947368421052627,0.92736842105263162,0.88491228070175432,0.84157894736842098,0.82035087719298239,0.79912280701754379,0.75719298245614031,0.95222584147665579,0.96500189178963292,0.97878667724028545,0.99291223681467589,0.99636441402908482,1,1,1,1,1,1,1,1,1,21.232631578947366,20.58298245614035,19.921228070175438,19.219122807017545,18.799473684210529,18.379824561403506,17.415438596491228]
[77.5,72,29.26043859649123,13.461052631578948,27.932894736842101,12.914298245614036,26.587192982456134,12.367543859649121,25.207192982456142,11.808684210526316,24.49298245614035,17.793728070175437,23.778771929824558,23.778771929824558,22.318070175438599,10.658684210526316,null,1.2721929824561404,1.2144736842105261,1.1559649122807014,1.0959649122807018,1.0649122807017544,1.0338596491228069,0.97035087719298252,0.46004274977590842,0.46233297219212721,0.46516922142965555,0.46846486313430447,0.7264827018121911,1,0.4775809076116434,1,1,1,1,1,1,1,13.461052631578948,12.914298245614036,12.367543859649121,11.808684210526316,17.793728070175437,23.778771929824558,10.658684210526316]
[null,67,26.694122807017543,16.636666666666667,25.497719298245613,16.055614035087721,24.275087719298245,15.462456140350879,23.024210526315791,14.863245614035087,22.384649122807016,18.304166666666667,21.745087719298247,21.745087719298247,20.403421052631579,13.628508771929825,null,1.1606140350877192,1.1085964912280701,1.0554385964912281,1.0010526315789474,0.97324561403508758,0.94543859649122808,0.88710526315789473,0.62323331569798202,0.62968824181041316,0.63696808510638303,0.64554854539081663,0.81771068048670581,1,0.6679521408088599,1,1,1,1,1,1,1,16.636666666666667,16.055614035087721,15.462456140350879,14.863245614035087,18.304166666666667,21.745087719298247,13.628508771929825]
[null,63,24.807719298245619,19.132368421052632,23.702105263157897,18.517017543859652,22.576315789473686,17.895614035087718,21.426315789473684,17.26614035087719,20.832149122807017,18.752061403508769,20.237982456140351,20.237982456140351,19.005263157894738,15.958771929824561,null,1.0785964912280703,1.0305263157894737,0.98157894736842111,0.93157894736842106,0.90574561403508769,0.87991228070175442,0.82631578947368423,0.77122641509433953,0.78123935989104532,0.7926720285969614,0.8058380414312617,0.90015011379594201,1,0.83970276008492561,1,1,1,1,1,1,1,19.132368421052632,18.517017543859652,17.895614035087718,17.26614035087719,18.752061403508769,20.237982456140351,15.958771929824561]
[null,57,22.69736842105263,22.164736842105263,21.773333333333333,21.400087719298245,20.83517543859649,20.619298245614033,19.868771929824558,19.80017543859649,19.383552631578947,19.349254385964915,18.89833333333333,18.89833333333333,17.911754385964912,17.911754385964912,null,0.98684210526315785,0.94666666666666666,0.90587719298245606,0.86385964912280688,0.84276315789473677,0.82166666666666655,0.77877192982456145,0.97653333333333336,0.98285767234988874,0.98963881088409023,0.99654752233956145,0.99823054905022135,1,1,1,1,1,1,1,1,1,22.164736842105263,21.400087719298245,20.619298245614033,19.80017543859649,19.349254385964915,18.89833333333333,17.911754385964912]
[80,72,29.23017543859649,15.034736842105263,27.902631578947371,14.465789473684213,26.558947368421052,13.896842105263158,25.178947368421053,13.315789473684211,24.464736842105264,18.533157894736846,23.750526315789472,23.750526315789472,22.28982456140351,12.12140350877193,null,1.270877192982456,1.2131578947368422,1.1547368421052631,1.0947368421052632,1.0636842105263158,1.0326315789473683,0.96912280701754394,0.51435670900055219,0.51843817787418656,0.52324521422060166,0.52884615384615385,0.75754576942107876,1,0.54380883417813175,1,1,1,1,1,1,1,15.034736842105263,14.465789473684213,13.896842105263158,13.315789473684211,18.533157894736846,23.750526315789472,12.12140350877193]
[null,67,26.671929824561399,18.190175438596487,25.473508771929829,17.588947368421056,24.250877192982454,16.975614035087716,23,16.354210526315789,22.360438596491228,19.037543859649123,21.720877192982456,21.720877192982456,20.37719298245614,15.079122807017544,null,1.1596491228070174,1.1075438596491229,1.0543859649122806,1,0.97219298245614039,0.94438596491228066,0.88596491228070173,0.68199697428139183,0.69047996198320927,0.7,0.71105263157894738,0.85139402688802668,1,0.74,1,1,1,1,1,1,1,18.190175438596487,17.588947368421056,16.975614035087716,16.354210526315789,19.037543859649123,21.720877192982456,15.079122807017544]
[null,63,24.791578947368421,20.67982456140351,23.685964912280703,20.042280701754386,22.560175438596492,19.400701754385967,{"$f":"U18*$I$17","v":21.414210526315788},18.747017543859648,20.821052631578947,19.487456140350879,20.227894736842106,20.227894736842106,19.00122807017544,17.391228070175437,null,1.0778947368421052,1.0298245614035089,0.98087719298245613,0.93105263157894735,0.90526315789473688,0.87947368421052641,0.82614035087719306,0.83414713541666674,0.84616695059625213,0.85995349669111076,0.87544752214056909,0.93594961240310082,1,0.91526863452962404,1,1,1,1,1,1,1,20.67982456140351,20.042280701754386,19.400701754385967,18.747017543859648,19.487456140350879,20.227894736842106,17.391228070175437]
[null,57,23.096842105263157,23.096842105263157,22.21719298245614,22.21719298245614,21.317368421052631,21.317368421052631,{"$f":"U19*$I$17","v":20.381228070175435},20.381228070175435,19.899035087719298,19.899035087719298,19.416842105263157,19.416842105263157,18.408070175438596,18.408070175438596,null,1.0042105263157894,0.9659649122807018,0.92684210526315791,0.88614035087719289,0.86517543859649115,0.84421052631578941,0.80035087719298237,1,1,1,1,1,1,1,1,1,1,1,1,1,1,23.096842105263157,22.21719298245614,21.317368421052631,20.381228070175435,19.899035087719298,19.416842105263157,18.408070175438596]

{"sheet":"Form","index":9,"n_rows":53,"n_cols":17,"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],[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,10,27,11],[28,12,29,12],[27,0,29,0],[28,11,29,11],[46,12,46,14],[38,0,41,0],[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],[27,8,27,9],[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],[1,10,1,12]]}
[]
[null,null,"Select Carrier Condenser:  ",null,null,null,null,null,null,null,"Efficiency Mode / Stage 5"]
[null,null,"ADP Evaporator:  ",null,null,null,null,null,null,null,null,null,null,24]
[null,null,"Nominal Capacity:  ",null,"(Mbtuh)","Note:  23 = 24A / 24 = 24B",null,null,null,null,null,"Condenser Entering Air Temperature: ",null,"(°F) Dry Bulb, 65°F to 115°F"]
[null,null,"AHRI Rated Capacity:  ",null,"(Mbtuh) @ 95 ˚F & 80/67 ˚F conditions",null,null,null,null,null,null,"Entering Evaporator Air (DB):  ",null,null,"to",null,"(°F) Dry Bulb -- 80°F Standard"]
[null,null,"Evaporator Air Flow (CFM): ","Fixed by OEM data",null,null,null,null,null,null,null,"Entering Evaporator Air (WB):  ",null,"(°F) Wet Bulb, 57°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,"Carrier Condenser :  "]
[null,null,null,null,null,"ADP Evaporator:  "]
[null,null,null,null,null,"Condenser Entering Air Temperature: ",null,"(°F) Dry Bulb, 65°F to 115°F"]
[null,null,null,null,null,"Entering Evaporator Air (DB):  ",null,"(°F) Dry Bulb, 75°F to 80°F"]
[null,null,null,null,null,"Evaporator Air Flow:",null,"CFM (Fixed by OEM data)"]
[null,null,null,null,null,"Entering Evaporator Air (WB):  ",null,"(°F) Wet Bulb, 57°F to 72°F"]
[null,null,null,null,null,"AHRI Rated Capacity:  ",null,"(Mbtuh) @ 95 ˚F & 80/67 ˚F conditions"]
[]
["Evaporator Air Flow",null,"Condenser  Entering Air Temperature ˚F"]
[825,"CFM",65,null,75,null,85,null,95,null,100,null,105,null,115]
["Evap. Air °F DB","EWB†\n˚F","Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh",null,"Capacity Mbtuh"]
[null,null,"Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens.","Total","Sens."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Condenser Entering Air Temperature: ",null,"(°F) Dry Bulb, 65°F to 115°F",null,null,null,"CAPACITY IN MBTUH UNDER SPECIFIC CONDITIONS LISTED"]
[null,null,null,"Entering Evaporator Air (DB):  ",null,"(°F) Dry Bulb, 75°F to 80°F",null,null,null,null,"TOTAL"]
[null,null,null,"Entering Evaporator Air (WB):  ",null,"(°F) Wet Bulb, 57°F to 72°F",null,null,null,null,"SENSIBLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Efficiency Mode / Stage 5"]
["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."]
[]
[]
["Printed:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CV-19-A"]

{"sheet":"Instructions","index":10,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"This spreadsheet generates capacity information for ADP rated matches at other than nominal conditions."]
[null,"The information is provided is not certified and is provided for engineering use only."]
[]
[null,"The latest version will always 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,"Versions:","CV-15-A","2015-05-18","Initial public release"]
[null,null,"CV-16-A","2016-03-22","Renewed date key through 2016"]
[null,null,"CV-19-A","2019-05-20","New version"]

{"sheet":"Prompt","index":11,"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":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}