{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Proposal","Tab Calc","Sheet3"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"Proposal","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[18,0,18,7],[19,3,19,4],[20,3,20,4],[23,0,23,7],[36,0,36,4],[21,0,21,7],[22,0,22,7],[38,0,38,4],[25,0,26,7],[28,0,28,7],[29,0,29,7],[32,0,34,4],[32,5,32,7],[34,5,34,7],[30,0,30,6],[0,4,0,7],[1,4,1,7],[2,4,2,7],[3,4,3,7],[0,0,3,3],[7,1,7,3],[4,1,4,3],[4,5,4,7],[5,1,5,3],[5,5,5,7],[6,1,6,3],[6,5,6,7],[7,5,7,7],[9,0,10,7],[16,0,16,7],[15,0,15,3],[13,1,13,2],[12,1,12,2],[12,4,12,5],[13,4,13,5]]}
[null,null,null,null,"1329 E Kemper Rd, Ste 4210"]
[null,null,null,null,{"$f":"'Tab Calc'!AE27","v":"CINCINNATI, OH 45246"}]
[null,null,null,null,"513-860-2050"]
[null,null,null,null,{"$f":"_xlfn.SWITCH('Tab Calc'!AD7,1,'Tab Calc'!AG2,2,'Tab Calc'!AG3,3,'Tab Calc'!AG4,4,'Tab Calc'!AG5,5,'Tab Calc'!AG6,6,'Tab Calc'!AG7)","v":"joe@nationaltab.com"}]
["Client:",{"$f":"IF('Tab Calc'!C3=\"\",\"\",'Tab Calc'!C3)","v":"MSD, Inc."},null,null,"Project:",{"$f":"IF('Tab Calc'!E3=\"\",\"\",'Tab Calc'!E3)","v":"Formica 2nd Floor Fitouts"}]
["Email:",{"$f":"IF('Tab Calc'!C5=\"\",\"\",'Tab Calc'!C5)","v":"estimators@msdinc.net"},null,null,"QUOTE #:",{"$f":"'Tab Calc'!E5&\"-\"&'Tab Calc'!H5","v":"JMH-NT-16089"}]
["ATTN:",{"$f":"IF('Tab Calc'!C6=\"\",\"\",'Tab Calc'!C6)","v":"Rick Vanzile"},null,null,"BID DATE:",{"$f":"'Tab Calc'!AE14","v":"2025-02-07"}]
["Address:",{"$f":"IF('Tab Calc'!C4=\"\",\"\",'Tab Calc'!C4)","v":""},null,null,"Jobsite location:",{"$f":"IF('Tab Calc'!E4=\"\",\"\",'Tab Calc'!E4)","v":"120 E 4th St. - Cincinnati, OH"}]
[]
[{"$f":"\"Thank you for allowing National TAB this opportunity to bid on the testing and balancing of this project. \"&CHAR(10)&\"The following is our understanding of the scope of work and the associated cost.\"","v":"Thank you for allowing National TAB this opportunity to bid on the testing and balancing of this project. \nThe following is our understanding of the scope of work and the associated cost."}]
[]
[]
[null,"Equipment:",null,"Qty.:","Equipment:",null,"Qty.:"]
[null,{"$f":"IF(Sheet3!H2=0,IF(Sheet3!G2>1,CHAR(10),\"\")&Sheet3!A2,\"\")&IF(Sheet3!H3=0,IF(Sheet3!G3>1,CHAR(10),\"\")&Sheet3!A3,\"\")&IF(Sheet3!H4=0,IF(Sheet3!G4>1,CHAR(10),\"\")&Sheet3!A4,\"\")&IF(Sheet3!H5=0,IF(Sheet3!G5>1,CHAR(10),\"\")&Sheet3!A5,\"\")&IF(Sheet3!H6=0,IF(Sheet3!G6>1,CHAR(10),\"\")&Sheet3!A6,\"\")&IF(Sheet3!H7=0,IF(Sheet3!G7>1,CHAR(10),\"\")&Sheet3!A7,\"\")&IF(Sheet3!H8=0,IF(Sheet3!G8>1,CHAR(10),\"\")&Sheet3!A8,\"\")&IF(Sheet3!H9=0,IF(Sheet3!G9>1,CHAR(10),\"\")&Sheet3!A9,\"\")&IF(Sheet3!H10=0,IF(Sheet3!G10>1,CHAR(10),\"\")&Sheet3!A10,\"\")&IF(Sheet3!H11=0,IF(Sheet3!G11>1,CHAR(10),\"\")&Sheet3!A11,\"\")&IF(Sheet3!H12=0,IF(Sheet3!G12>1,CHAR(10),\"\")&Sheet3!A12,\"\")&IF(Sheet3!H13=0,IF(Sheet3!G13>1,CHAR(10),\"\")&Sheet3!A13,\"\")&IF(Sheet3!H14=0,IF(Sheet3!G14>1,CHAR(10),\"\")&Sheet3!A14,\"\")&IF(Sheet3!H15=0,IF(Sheet3!G15>1,CHAR(10),\"\")&Sheet3!A15,\"\")&IF(Sheet3!H16=0,IF(Sheet3!G16>1,CHAR(10),\"\")&Sheet3!A16,\"\")&IF(Sheet3!H17=0,IF(Sheet3!G17>1,CHAR(10),\"\")&Sheet3!A17,\"\")&IF(Sheet3!H18=0,IF(Sheet3!G18>1,CHAR(10),\"\")&Sheet3!A18,\"\")&IF(Sheet3!H19=0,IF(Sheet3!G19>1,CHAR(10),\"\")&Sheet3!A19,\"\")&IF(Sheet3!H20=0,IF(Sheet3!G20>1,CHAR(10),\"\")&Sheet3!A20,\"\")&IF(Sheet3!H21=0,IF(Sheet3!G21>1,CHAR(10),\"\")&Sheet3!A21,\"\")&IF(Sheet3!H22=0,IF(Sheet3!G22>1,CHAR(10),\"\")&Sheet3!A22,\"\")&IF(Sheet3!H23=0,IF(Sheet3!G23>1,CHAR(10),\"\")&Sheet3!A23,\"\")&IF(Sheet3!H24=0,IF(Sheet3!G24>1,CHAR(10),\"\")&Sheet3!A24,\"\")&IF(Sheet3!H25=0,IF(Sheet3!G25>1,CHAR(10),\"\")&Sheet3!A25,\"\")&IF(Sheet3!H26=0,IF(Sheet3!G26>1,CHAR(10),\"\")&Sheet3!A26,\"\")&IF(Sheet3!H27=0,IF(Sheet3!G27>1,CHAR(10),\"\")&Sheet3!A27,\"\")&IF(Sheet3!H28=0,IF(Sheet3!G28>1,CHAR(10),\"\")&Sheet3!A28,\"\")&IF(Sheet3!H29=0,IF(Sheet3!G29>1,CHAR(10),\"\")&Sheet3!A29,\"\")&IF(Sheet3!H30=0,IF(Sheet3!G30>1,CHAR(10),\"\")&Sheet3!A30,\"\")&IF(Sheet3!H31=0,IF(Sheet3!G31>1,CHAR(10),\"\")&Sheet3!A31,\"\")&IF(Sheet3!H32=0,IF(Sheet3!G32>1,CHAR(10),\"\")&Sheet3!A32,\"\")&IF(Sheet3!H33=0,IF(Sheet3!G33>1,CHAR(10),\"\")&Sheet3!A33,\"\")&IF(Sheet3!H34=0,IF(Sheet3!G34>1,CHAR(10),\"\")&Sheet3!A34,\"\")&IF(Sheet3!H35=0,IF(Sheet3!G35>1,CHAR(10),\"\")&Sheet3!A35,\"\")&IF(Sheet3!H36=0,IF(Sheet3!G36>1,CHAR(10),\"\")&Sheet3!A36,\"\")&IF(Sheet3!H37=0,IF(Sheet3!G37>1,CHAR(10),\"\")&Sheet3!A37,\"\")&IF(Sheet3!H38=0,IF(Sheet3!G38>1,CHAR(10),\"\")&Sheet3!A38,\"\")&IF(Sheet3!H39=0,IF(Sheet3!G39>1,CHAR(10),\"\")&Sheet3!A39,\"\")","v":"FCUs\nExhaust Fans "},null,{"$f":"IF(Sheet3!H2=0,IF(Sheet3!G2>1,CHAR(10),\"\")&IF(Sheet3!I2=1,Sheet3!C2,\"\"),\"\")&IF(Sheet3!H3=0,IF(Sheet3!G3>1,CHAR(10),\"\")&IF(Sheet3!I3=1,Sheet3!C3,\"\"),\"\")&IF(Sheet3!H4=0,IF(Sheet3!G4>1,CHAR(10),\"\")&IF(Sheet3!I4=1,Sheet3!C4,\"\"),\"\")&IF(Sheet3!H5=0,IF(Sheet3!G5>1,CHAR(10),\"\")&IF(Sheet3!I5=1,Sheet3!C5,\"\"),\"\")&IF(Sheet3!H6=0,IF(Sheet3!G6>1,CHAR(10),\"\")&IF(Sheet3!I6=1,Sheet3!C6,\"\"),\"\")&IF(Sheet3!H7=0,IF(Sheet3!G7>1,CHAR(10),\"\")&IF(Sheet3!I7=1,Sheet3!C7,\"\"),\"\")&IF(Sheet3!H8=0,IF(Sheet3!G8>1,CHAR(10),\"\")&IF(Sheet3!I8=1,Sheet3!C8,\"\"),\"\")&IF(Sheet3!H9=0,IF(Sheet3!G9>1,CHAR(10),\"\")&IF(Sheet3!I9=1,Sheet3!C9,\"\"),\"\")&IF(Sheet3!H10=0,IF(Sheet3!G10>1,CHAR(10),\"\")&IF(Sheet3!I10=1,Sheet3!C10,\"\"),\"\")&IF(Sheet3!H11=0,IF(Sheet3!G11>1,CHAR(10),\"\")&IF(Sheet3!I11=1,Sheet3!C11,\"\"),\"\")&IF(Sheet3!H12=0,IF(Sheet3!G12>1,CHAR(10),\"\")&IF(Sheet3!I12=1,Sheet3!C12,\"\"),\"\")&IF(Sheet3!H13=0,IF(Sheet3!G13>1,CHAR(10),\"\")&IF(Sheet3!I13=1,Sheet3!C13,\"\"),\"\")&IF(Sheet3!H14=0,IF(Sheet3!G14>1,CHAR(10),\"\")&IF(Sheet3!I14=1,Sheet3!C14,\"\"),\"\")&IF(Sheet3!H15=0,IF(Sheet3!G15>1,CHAR(10),\"\")&IF(Sheet3!I15=1,Sheet3!C15,\"\"),\"\")&IF(Sheet3!H16=0,IF(Sheet3!G16>1,CHAR(10),\"\")&IF(Sheet3!I16=1,Sheet3!C16,\"\"),\"\")&IF(Sheet3!H17=0,IF(Sheet3!G17>1,CHAR(10),\"\")&IF(Sheet3!I17=1,Sheet3!C17,\"\"),\"\")&IF(Sheet3!H18=0,IF(Sheet3!G18>1,CHAR(10),\"\")&IF(Sheet3!I18=1,Sheet3!C18,\"\"),\"\")&IF(Sheet3!H19=0,IF(Sheet3!G19>1,CHAR(10),\"\")&IF(Sheet3!I19=1,Sheet3!C19,\"\"),\"\")&IF(Sheet3!H20=0,IF(Sheet3!G20>1,CHAR(10),\"\")&IF(Sheet3!I20=1,Sheet3!C20,\"\"),\"\")&IF(Sheet3!H21=0,IF(Sheet3!G21>1,CHAR(10),\"\")&IF(Sheet3!I21=1,Sheet3!C21,\"\"),\"\")&IF(Sheet3!H22=0,IF(Sheet3!G22>1,CHAR(10),\"\")&IF(Sheet3!I22=1,Sheet3!C22,\"\"),\"\")&IF(Sheet3!H23=0,IF(Sheet3!G23>1,CHAR(10),\"\")&IF(Sheet3!I23=1,Sheet3!C23,\"\"),\"\")&IF(Sheet3!H24=0,IF(Sheet3!G24>1,CHAR(10),\"\")&IF(Sheet3!I24=1,Sheet3!C24,\"\"),\"\")&IF(Sheet3!H25=0,IF(Sheet3!G25>1,CHAR(10),\"\")&IF(Sheet3!I25=1,Sheet3!C25,\"\"),\"\")&IF(Sheet3!H26=0,IF(Sheet3!G26>1,CHAR(10),\"\")&IF(Sheet3!I26=1,Sheet3!C26,\"\"),\"\")&IF(Sheet3!H27=0,IF(Sheet3!G27>1,CHAR(10),\"\")&IF(Sheet3!I27=1,Sheet3!C27,\"\"),\"\")&IF(Sheet3!H28=0,IF(Sheet3!G28>1,CHAR(10),\"\")&IF(Sheet3!I28=1,Sheet3!C28,\"\"),\"\")&IF(Sheet3!H29=0,IF(Sheet3!G29>1,CHAR(10),\"\")&IF(Sheet3!I29=1,Sheet3!C29,\"\"),\"\")&IF(Sheet3!H30=0,IF(Sheet3!G30>1,CHAR(10),\"\")&IF(Sheet3!I30=1,Sheet3!C30,\"\"),\"\")&IF(Sheet3!H31=0,IF(Sheet3!G31>1,CHAR(10),\"\")&IF(Sheet3!I31=1,Sheet3!C31,\"\"),\"\")&IF(Sheet3!H32=0,IF(Sheet3!G32>1,CHAR(10),\"\")&IF(Sheet3!I32=1,Sheet3!C32,\"\"),\"\")&IF(Sheet3!H33=0,IF(Sheet3!G33>1,CHAR(10),\"\")&IF(Sheet3!I33=1,Sheet3!C33,\"\"),\"\")&IF(Sheet3!H34=0,IF(Sheet3!G34>1,CHAR(10),\"\")&IF(Sheet3!I34=1,Sheet3!C34,\"\"),\"\")&IF(Sheet3!H35=0,IF(Sheet3!G35>1,CHAR(10),\"\")&IF(Sheet3!I35=1,Sheet3!C35,\"\"),\"\")&IF(Sheet3!H36=0,IF(Sheet3!G36>1,CHAR(10),\"\")&IF(Sheet3!I36=1,Sheet3!C36,\"\"),\"\")&IF(Sheet3!H37=0,IF(Sheet3!G37>1,CHAR(10),\"\")&IF(Sheet3!I37=1,Sheet3!C37,\"\"),\"\")&IF(Sheet3!H38=0,IF(Sheet3!G38>1,CHAR(10),\"\")&IF(Sheet3!I38=1,Sheet3!C38,\"\"),\"\")&IF(Sheet3!H39=0,IF(Sheet3!G39>1,CHAR(10),\"\")&IF(Sheet3!I39=1,Sheet3!C39,\"\"),\"\")","v":"10\n5"},{"$f":"IF(Sheet3!H2=1,IF(Sheet3!G2>Sheet3!G43,CHAR(10),\"\")&Sheet3!A2,\"\")&IF(Sheet3!H3=1,IF(Sheet3!G3>Sheet3!G43,CHAR(10),\"\")&Sheet3!A3,\"\")&IF(Sheet3!H4=1,IF(Sheet3!G4>Sheet3!G43,CHAR(10),\"\")&Sheet3!A4,\"\")&IF(Sheet3!H5=1,IF(Sheet3!G5>Sheet3!G43,CHAR(10),\"\")&Sheet3!A5,\"\")&IF(Sheet3!H6=1,IF(Sheet3!G6>Sheet3!G43,CHAR(10),\"\")&Sheet3!A6,\"\")&IF(Sheet3!H7=1,IF(Sheet3!G7>Sheet3!G43,CHAR(10),\"\")&Sheet3!A7,\"\")&IF(Sheet3!H8=1,IF(Sheet3!G8>Sheet3!G43,CHAR(10),\"\")&Sheet3!A8,\"\")&IF(Sheet3!H9=1,IF(Sheet3!G9>Sheet3!G43,CHAR(10),\"\")&Sheet3!A9,\"\")&IF(Sheet3!H10=1,IF(Sheet3!G10>Sheet3!G43,CHAR(10),\"\")&Sheet3!A10,\"\")&IF(Sheet3!H11=1,IF(Sheet3!G11>Sheet3!G43,CHAR(10),\"\")&Sheet3!A11,\"\")&IF(Sheet3!H12=1,IF(Sheet3!G12>Sheet3!G43,CHAR(10),\"\")&Sheet3!A12,\"\")&IF(Sheet3!H13=1,IF(Sheet3!G13>Sheet3!G43,CHAR(10),\"\")&Sheet3!A13,\"\")&IF(Sheet3!H14=1,IF(Sheet3!G14>Sheet3!G43,CHAR(10),\"\")&Sheet3!A14,\"\")&IF(Sheet3!H15=1,IF(Sheet3!G15>Sheet3!G43,CHAR(10),\"\")&Sheet3!A15,\"\")&IF(Sheet3!H16=1,IF(Sheet3!G16>Sheet3!G43,CHAR(10),\"\")&Sheet3!A16,\"\")&IF(Sheet3!H17=1,IF(Sheet3!G17>Sheet3!G43,CHAR(10),\"\")&Sheet3!A17,\"\")&IF(Sheet3!H18=1,IF(Sheet3!G18>Sheet3!G43,CHAR(10),\"\")&Sheet3!A18,\"\")&IF(Sheet3!H19=1,IF(Sheet3!G19>Sheet3!G43,CHAR(10),\"\")&Sheet3!A19,\"\")&IF(Sheet3!H20=1,IF(Sheet3!G20>Sheet3!G43,CHAR(10),\"\")&Sheet3!A20,\"\")&IF(Sheet3!H21=1,IF(Sheet3!G21>Sheet3!G43,CHAR(10),\"\")&Sheet3!A21,\"\")&IF(Sheet3!H22=1,IF(Sheet3!G22>Sheet3!G43,CHAR(10),\"\")&Sheet3!A22,\"\")&IF(Sheet3!H23=1,IF(Sheet3!G23>Sheet3!G43,CHAR(10),\"\")&Sheet3!A23,\"\")&IF(Sheet3!H24=1,IF(Sheet3!G24>Sheet3!G43,CHAR(10),\"\")&Sheet3!A24,\"\")&IF(Sheet3!H25=1,IF(Sheet3!G25>Sheet3!G43,CHAR(10),\"\")&Sheet3!A25,\"\")&IF(Sheet3!H26=1,IF(Sheet3!G26>Sheet3!G43,CHAR(10),\"\")&Sheet3!A26,\"\")&IF(Sheet3!H27=1,IF(Sheet3!G27>Sheet3!G43,CHAR(10),\"\")&Sheet3!A27,\"\")&IF(Sheet3!H28=1,IF(Sheet3!G28>Sheet3!G43,CHAR(10),\"\")&Sheet3!A28,\"\")&IF(Sheet3!H29=1,IF(Sheet3!G29>Sheet3!G43,CHAR(10),\"\")&Sheet3!A29,\"\")&IF(Sheet3!H30=1,IF(Sheet3!G30>Sheet3!G43,CHAR(10),\"\")&Sheet3!A30,\"\")&IF(Sheet3!H31=1,IF(Sheet3!G31>Sheet3!G43,CHAR(10),\"\")&Sheet3!A31,\"\")&IF(Sheet3!H32=1,IF(Sheet3!G32>Sheet3!G43,CHAR(10),\"\")&Sheet3!A32,\"\")&IF(Sheet3!H33=1,IF(Sheet3!G33>Sheet3!G43,CHAR(10),\"\")&Sheet3!A33,\"\")&IF(Sheet3!H34=1,IF(Sheet3!G34>Sheet3!G43,CHAR(10),\"\")&Sheet3!A34,\"\")&IF(Sheet3!H35=1,IF(Sheet3!G35>Sheet3!G43,CHAR(10),\"\")&Sheet3!A35,\"\")&IF(Sheet3!H36=1,IF(Sheet3!G36>Sheet3!G43,CHAR(10),\"\")&Sheet3!A36,\"\")&IF(Sheet3!H37=1,IF(Sheet3!G37>Sheet3!G43,CHAR(10),\"\")&Sheet3!A37,\"\")&IF(Sheet3!H38=1,IF(Sheet3!G38>Sheet3!G43,CHAR(10),\"\")&Sheet3!A38,\"\")&IF(Sheet3!H39=1,IF(Sheet3!G39>Sheet3!G43,CHAR(10),\"\")&Sheet3!A39,\"\")","v":"Air Devices "},null,{"$f":"IF(Sheet3!H2=1,IF(Sheet3!G2>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I2=1,Sheet3!C2,\"\"),\"\")&IF(Sheet3!H3=1,IF(Sheet3!G3>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I3=1,Sheet3!C3,\"\"),\"\")&IF(Sheet3!H4=1,IF(Sheet3!G4>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I4=1,Sheet3!C4,\"\"),\"\")&IF(Sheet3!H5=1,IF(Sheet3!G5>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I5=1,Sheet3!C5,\"\"),\"\")&IF(Sheet3!H6=1,IF(Sheet3!G6>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I6=1,Sheet3!C6,\"\"),\"\")&IF(Sheet3!H7=1,IF(Sheet3!G7>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I7=1,Sheet3!C7,\"\"),\"\")&IF(Sheet3!H8=1,IF(Sheet3!G8>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I8=1,Sheet3!C8,\"\"),\"\")&IF(Sheet3!H9=1,IF(Sheet3!G9>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I9=1,Sheet3!C9,\"\"),\"\")&IF(Sheet3!H10=1,IF(Sheet3!G10>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I10=1,Sheet3!C10,\"\"),\"\")&IF(Sheet3!H11=1,IF(Sheet3!G11>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I11=1,Sheet3!C11,\"\"),\"\")&IF(Sheet3!H12=1,IF(Sheet3!G12>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I12=1,Sheet3!C12,\"\"),\"\")&IF(Sheet3!H13=1,IF(Sheet3!G13>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I13=1,Sheet3!C13,\"\"),\"\")&IF(Sheet3!H14=1,IF(Sheet3!G14>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I14=1,Sheet3!C14,\"\"),\"\")&IF(Sheet3!H15=1,IF(Sheet3!G15>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I15=1,Sheet3!C15,\"\"),\"\")&IF(Sheet3!H16=1,IF(Sheet3!G16>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I16=1,Sheet3!C16,\"\"),\"\")&IF(Sheet3!H17=1,IF(Sheet3!G17>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I17=1,Sheet3!C17,\"\"),\"\")&IF(Sheet3!H18=1,IF(Sheet3!G18>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I18=1,Sheet3!C18,\"\"),\"\")&IF(Sheet3!H19=1,IF(Sheet3!G19>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I19=1,Sheet3!C19,\"\"),\"\")&IF(Sheet3!H20=1,IF(Sheet3!G20>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I20=1,Sheet3!C20,\"\"),\"\")&IF(Sheet3!H21=1,IF(Sheet3!G21>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I21=1,Sheet3!C21,\"\"),\"\")&IF(Sheet3!H22=1,IF(Sheet3!G22>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I22=1,Sheet3!C22,\"\"),\"\")&IF(Sheet3!H23=1,IF(Sheet3!G23>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I23=1,Sheet3!C23,\"\"),\"\")&IF(Sheet3!H24=1,IF(Sheet3!G24>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I24=1,Sheet3!C24,\"\"),\"\")&IF(Sheet3!H25=1,IF(Sheet3!G25>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I25=1,Sheet3!C25,\"\"),\"\")&IF(Sheet3!H26=1,IF(Sheet3!G26>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I26=1,Sheet3!C26,\"\"),\"\")&IF(Sheet3!H27=1,IF(Sheet3!G27>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I27=1,Sheet3!C27,\"\"),\"\")&IF(Sheet3!H28=1,IF(Sheet3!G28>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I28=1,Sheet3!C28,\"\"),\"\")&IF(Sheet3!H29=1,IF(Sheet3!G29>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I29=1,Sheet3!C29,\"\"),\"\")&IF(Sheet3!H30=1,IF(Sheet3!G30>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I30=1,Sheet3!C30,\"\"),\"\")&IF(Sheet3!H31=1,IF(Sheet3!G31>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I31=1,Sheet3!C31,\"\"),\"\")&IF(Sheet3!H32=1,IF(Sheet3!G32>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I32=1,Sheet3!C32,\"\"),\"\")&IF(Sheet3!H33=1,IF(Sheet3!G33>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I33=1,Sheet3!C33,\"\"),\"\")&IF(Sheet3!H34=1,IF(Sheet3!G34>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I34=1,Sheet3!C34,\"\"),\"\")&IF(Sheet3!H35=1,IF(Sheet3!G35>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I35=1,Sheet3!C35,\"\"),\"\")&IF(Sheet3!H36=1,IF(Sheet3!G36>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I36=1,Sheet3!C36,\"\"),\"\")&IF(Sheet3!H37=1,IF(Sheet3!G37>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I37=1,Sheet3!C37,\"\"),\"\")&IF(Sheet3!H38=1,IF(Sheet3!G38>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I38=1,Sheet3!C38,\"\"),\"\")&IF(Sheet3!H39=1,IF(Sheet3!G39>Sheet3!G43,CHAR(10),\"\")&IF(Sheet3!I39=1,Sheet3!C39,\"\"),\"\")","v":""}]
[]
["SCOPE OF WORK:"]
[{"$f":"IF('Tab Calc'!AA10,'Tab Calc'!AC10&\". \"&'Tab Calc'!R4&CHAR(10),\"\")&IF('Tab Calc'!AA11,'Tab Calc'!AC11&\". \"&'Tab Calc'!R6&CHAR(10),\"\")&IF('Tab Calc'!AA12,'Tab Calc'!AC12&\". \"&'Tab Calc'!R8&CHAR(10),\"\")&IF('Tab Calc'!AA13,'Tab Calc'!AC13&\". \"&'Tab Calc'!R10&CHAR(10),\"\")&IF('Tab Calc'!AA14,'Tab Calc'!AC14&\". \"&'Tab Calc'!R12&CHAR(10),\"\")&IF('Tab Calc'!AA15,'Tab Calc'!AC15&\". \"&'Tab Calc'!R14&CHAR(10),\"\")&IF('Tab Calc'!AA16,'Tab Calc'!AC16&\". \"&'Tab Calc'!R16&CHAR(10),\"\")&IF('Tab Calc'!AA17,'Tab Calc'!AC17&\". \"&'Tab Calc'!R18&CHAR(10),\"\")&IF('Tab Calc'!AA18,'Tab Calc'!AC18&\". \"&'Tab Calc'!R20&CHAR(10),\"\")&IF('Tab Calc'!AA19,'Tab Calc'!AC19&\". \"&'Tab Calc'!R22&CHAR(10),\"\")&IF('Tab Calc'!AA20,'Tab Calc'!AC20&\". \"&'Tab Calc'!R24&CHAR(10),\"\")&IF('Tab Calc'!AA21,'Tab Calc'!AC21&\". \"&'Tab Calc'!R26&CHAR(10),\"\")&IF('Tab Calc'!AA22,'Tab Calc'!AC22&\". \"&'Tab Calc'!R28&CHAR(10),\"\")&IF('Tab Calc'!AA23,'Tab Calc'!AC23&\". \"&'Tab Calc'!R30&CHAR(10),\"\")&IF('Tab Calc'!AA24,'Tab Calc'!AC24&\". \"&'Tab Calc'!R32&CHAR(10),\"\")&IF('Tab Calc'!AA25,'Tab Calc'!AC25&\". \"&'Tab Calc'!R34&CHAR(10),\"\")&IF('Tab Calc'!AA26,'Tab Calc'!AC26&\". \"&'Tab Calc'!R36&CHAR(10),\"\")&IF('Tab Calc'!AA27,'Tab Calc'!AC27&\". \"&'Tab Calc'!R38&CHAR(10),\"\")&IF('Tab Calc'!AA28,'Tab Calc'!AC28&\". \"&'Tab Calc'!R40&CHAR(10),\"\")&IF('Tab Calc'!AA29,'Tab Calc'!AC29&\". \"&'Tab Calc'!R42&CHAR(10),\"\")&IF('Tab Calc'!AA30,'Tab Calc'!AC30&\". \"&'Tab Calc'!R44&CHAR(10),\"\")&IF('Tab Calc'!AA31,'Tab Calc'!AC31&\". \"&'Tab Calc'!R46&CHAR(10),\"\")&IF('Tab Calc'!AA32,'Tab Calc'!AC32&\". \"&'Tab Calc'!R48&CHAR(10),\"\")&IF('Tab Calc'!AA33,'Tab Calc'!AC33&\". \"&'Tab Calc'!R50&CHAR(10),\"\")&IF('Tab Calc'!AA34,'Tab Calc'!AC34&\". \"&'Tab Calc'!R52&CHAR(10),\"\")&IF('Tab Calc'!AA35,'Tab Calc'!AC35&\". \"&'Tab Calc'!R54&CHAR(10),\"\")&IF('Tab Calc'!AA36,'Tab Calc'!AC36&\". \"&'Tab Calc'!R56&CHAR(10),\"\")&IF('Tab Calc'!AA37,'Tab Calc'!AC37&\". \"&'Tab Calc'!R58&CHAR(10),\"\")&IF('Tab Calc'!AA38,'Tab Calc'!AC38&\". \"&'Tab Calc'!R60&CHAR(10),\"\")&IF('Tab Calc'!AA39,'Tab Calc'!AC39&\". \"&'Tab Calc'!R62&CHAR(10),\"\")&IF('Tab Calc'!AA40,'Tab Calc'!AC40&\". \"&'Tab Calc'!R64&CHAR(10),\"\")","v":"1. 1st Shift Work Only\n2. TAB of listed equipment\n"}]
[]
["This proposal includes a written report to be submitted upon completion of all work by National TAB."]
[null,null,null,"TOTAL PRICE  = ",null,{"$f":"'Tab Calc'!O58","v":4775}]
[null,null,null,{"$f":"'Tab Calc'!AE61","v":""},null,{"$f":"'Tab Calc'!AF61","v":""}]
["Any parts if required will be additional. However, no parts will be provided without initial approval unless National TAB, LLC"]
["has agreed with the client for a set fee to perform specific task. Lift rental to be additional if required if not provided by owner or GC."]
["Work to be performed 1st shift only. "]
[]
["Not included in price: Prevailing Wage, Sound and Vibration testing, Indoor Air Quality testing, and Pre-testing is not included unless price is specified separately above. "]
[]
[]
["WE HEREBY PROPOSE to furnish labor complete in accordance with NATIONAL TAB specifications,"]
[{"$f":"\"for the sum of: \"&'Tab Calc'!AA60&\" and any selected options stated above. Payment to be made as follows:\"","v":"for the sum of: Four Thousand Seven Hundred Seventy Five US Dollars and Zero Cents and any selected options stated above. Payment to be made as follows:"}]
["Terms as specified by our acct department. New accounts are required to fill out a credit application."]
[]
["Acceptance of proposal - The above prices, specifications and conditions are satisfactory and are hereby accepted.  You are authorized to do the work as specified.  Payment will be made in accordance to terms agreed upon.",null,null,null,null," Authorized Signature for NT:"]
[]
[null,null,null,null,null,{"$f":"_xlfn.SWITCH('Tab Calc'!AD7,1,'Tab Calc'!AE2,2,'Tab Calc'!AE3,3,'Tab Calc'!AE4,4,'Tab Calc'!AE5,5,'Tab Calc'!AE6,6,'Tab Calc'!AE7)","v":"Joe Hertenstein"}]
[]
["Client Signature       ______________________",null,null,null,null," Date:",{"$f":"'Tab Calc'!E6","v":"2025-02-07"}]
[]
["Client Date of Acceptance________________"]

{"sheet":"Tab Calc","index":1,"n_rows":71,"n_cols":38,"rows_kept":71,"cut":false,"hidden":false,"merged":[[13,30,13,31],[43,16,44,16],[45,16,46,16],[57,26,57,27],[51,27,51,29],[17,16,18,16],[37,16,38,16],[55,17,56,23],[57,17,58,23],[53,16,54,16],[55,16,56,16],[51,16,52,16],[39,16,40,16],[41,16,42,16],[47,16,48,16],[49,16,50,16],[27,16,28,16],[29,16,30,16],[31,16,32,16],[33,16,34,16],[9,16,10,16],[15,16,16,16],[35,16,36,16],[59,17,60,23],[61,17,62,23],[57,16,58,16],[59,16,60,16],[61,16,62,16],[43,17,44,23],[45,17,46,23],[47,17,48,23],[49,17,50,23],[51,17,52,23],[74,2,74,14],[72,2,72,14],[73,2,73,14],[1,1,1,14],[4,8,4,14],[26,7,26,8],[42,7,42,8],[54,7,54,8],[2,4,2,14],[55,1,55,2],[56,1,64,3],[6,3,6,7],[3,4,3,14],[5,4,5,7],[27,17,28,23],[29,17,30,23],[31,17,32,23],[3,16,4,16],[5,16,6,16],[23,16,24,16],[23,17,24,23],[15,17,16,23],[19,16,20,16],[17,17,18,23],[25,16,26,16],[25,17,26,23],[11,17,12,23],[11,16,12,16],[7,17,8,23],[7,16,8,16],[1,16,2,23],[3,17,4,23],[5,17,6,23],[21,16,22,16],[21,17,22,23],[19,17,20,23],[13,16,14,16],[13,17,14,23],[9,17,10,23],[33,17,34,23],[35,17,36,23],[37,17,38,23],[39,17,40,23],[41,17,42,23],[60,31,63,31],[53,17,54,23],[63,14,64,14],[56,4,56,8],[57,4,58,8],[57,14,58,14],[63,4,64,7],[59,4,59,7],[60,4,60,7],[61,4,61,7],[62,4,62,7],[58,26,58,27],[60,30,63,30],[63,16,64,16],[63,17,64,23]]}
[]
[null," TAB Quote WKST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCOPE OF WORK:",null,null,null,null,null,null,null,null,null,"KC",null,1,null,"Joe Hertenstein",null,"joe@nationaltab.com"]
[null,"Client:","MSD, Inc.","Project:","Formica 2nd Floor Fitouts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NC/SC",null,"oeu",null,"Dan Hertenstein",null,"dan@nationaltab.com",null,null,{"$f":"_xlfn.SWITCH(AA8,1,AE18,2,AF18,3,AE18,4,AE18,5,AF18,6,AF18)","v":"Kansas City NationalTab Office:"}]
[null,"Address:",null,"Jobsite:","120 E 4th St. - Cincinnati, OH",null,null,null,null,null,null,null,null,null,null,null,1,"Requires Lift to access Air Devices & Assets",null,null,null,null,null,null,null,null,"CINCY",null,{"$f":"2+2","v":4},null,"Scott Springer",null,"scott@nationaltab.com"]
[null,"Email:","estimators@msdinc.net","Quote#:","JMH-NT",null,null,16089,"Choose Region:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEXAS",null,null,null,"Alec Lewis",null,"alec@nationaltab.com"]
[null,"ATTN:","Rick Vanzile","Bid date:",{"$f":"AE14","v":"2025-02-07"},null,null,null,null,null,null,null,null,null,null,null,2,"Temperature Testing across Heating/Cooling Coils of Assets and Specific Spaces ",null,null,null,null,null,null,null,null,"REVIVE",null,null,null,"Will Turnbough",null,"will@nationaltab.com"]
[null,"Quoted By:",null,"          Show All:    |.       Show NONE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Wendy Biggs",null,"wbiggs@nationaltab.com",null,null,null,"show all"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"1st Shift Work Only",null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,false,false]
[null,"Air Equipment","Notes","Output","Show    |   Don't",null,null,"Quantity","Price","KC","NC/SC","CINCY","TEXAS","REVIVE","Total",null,null,null,null,null,null,null,null,null,null,null,"Scope of work "]
[null,"RTUs",null,{"$f":"IF(H10>0,IF(AK10=1,\"Show\",\"Don’t\"),\"\")","v":""},null,false,false,0,190,150,150,150,150,150,{"$f":"(H10*I10)","v":0},null,4,"2nd Shift (Evening Work) as needed",null,null,null,null,null,null,null,1,false,1,{"$f":"IF(AA10,1,0)","v":0},null,{"$f":"YEAR(TODAY())","v":2025},null,null,null,null,"air ",{"$f":"IF(AK8,IF(G10,0,IF(F10,1,IF(AL8,0,1))),IF(G10,0,(IF(AL8,IF(F10,1,0),IF(G10,0,IF(F10,1,0))))))","v":0}]
[null,"AHUs",null,{"$f":"IF(H11>0,IF(AK11=1,\"Show\",\"Don’t\"),\"\")","v":""},null,false,false,0,400,350,375,350,375,375,{"$f":"(H11*I11)","v":0},null,null,null,null,null,null,null,null,null,null,2,false,2,{"$f":"IF(AA11,AC10+1,AC10)","v":0},null,{"$f":"MONTH(TODAY())","v":2},null,null,null,null,null,{"$f":"IF(AK8,IF(G11,0,IF(F11,1,IF(AL8,0,1))),IF(G11,0,(IF(AL8,IF(F11,1,0),IF(G11,0,IF(F11,1,0))))))","v":0}]
[null,"DOAS ",null,"",null,false,false,0,400,375,375,375,375,375,0,null,5,"3rd Shift (Night Work) as needed",null,null,null,null,null,null,null,3,true,3,{"$f":"IF(AA12,AC11+1,AC11)","v":1},null,{"$f":"DAY(TODAY())","v":7},null,null,null,null,null,{"$f":"IF(AK8,IF(G12,0,IF(F12,1,IF(AL8,0,1))),IF(G12,0,(IF(AL8,IF(F12,1,0),IF(G12,0,IF(F12,1,0))))))","v":0}]
[null,"FCUs","ducted change name to what drwg calls it","Show",null,true,false,10,200,120,120,120,120,120,2000,null,null,null,null,null,null,null,null,null,null,4,false,4,{"$f":"IF(AA13,AC12+1,AC12)","v":1},null,null,null,null,null,null,null,{"$f":"IF(AK8,IF(G13,0,IF(F13,1,IF(AL8,0,1))),IF(G13,0,(IF(AL8,IF(F13,1,0),IF(G13,0,IF(F13,1,0))))))","v":1}]
[null,"ERVs ",null,"",null,false,false,0,300,250,250,250,250,250,0,null,6,"Prevailing Wage Rate",null,null,null,null,null,null,null,5,false,5,1,null,{"$f":"TODAY()","v":"2025-02-07"},null,null,null,null,null,{"$f":"IF(AK8,IF(G14,0,IF(F14,1,IF(AL8,0,1))),IF(G14,0,(IF(AL8,IF(F14,1,0),IF(G14,0,IF(F14,1,0))))))","v":0}]
[null,"VRFs",null,"",null,false,false,0,175,75,75,75,75,75,0,null,null,null,null,null,null,null,null,null,null,6,false,6,1,null,null,null,null,null,null,null,{"$f":"IF(AK8,IF(G15,0,IF(F15,1,IF(AL8,0,1))),IF(G15,0,(IF(AL8,IF(F15,1,0),IF(G15,0,IF(F15,1,0))))))","v":0}]
[null,"VAVs",null,"",null,false,false,0,59,40,40,40,50,50,0,null,7,"Space Pressurization Testing throughout the 3rd & 4th Flrs",null,null,null,null,null,null,null,7,false,7,1,null,null,null,null,null,null,null,{"$f":"IF(AK8,IF(G16,0,IF(F16,1,IF(AL8,0,1))),IF(G16,0,(IF(AL8,IF(F16,1,0),IF(G16,0,IF(F16,1,0))))))","v":0}]
[null,"FPVAVs",null,"",null,false,false,0,84,60,60,60,75,75,0,null,null,null,null,null,null,null,null,null,null,8,false,8,1,null,"Office data",null,null,null,null,null,{"$f":"IF(AK8,IF(G17,0,IF(F17,1,IF(AL8,0,1))),IF(G17,0,(IF(AL8,IF(F17,1,0),IF(G17,0,IF(F17,1,0))))))","v":0}]
[null,"MUAs",null,"",null,false,false,0,100,125,125,125,125,125,0,null,8,"HVAC Smoke Detectors Testing",null,null,null,null,null,null,null,9,false,9,1,null,"Kansas City NationalTab Office:","NC/SC Office:","Cincinnati Office:","Texas Office:","revive",null,{"$f":"IF(AK8,IF(G18,0,IF(F18,1,IF(AL8,0,1))),IF(G18,0,(IF(AL8,IF(F18,1,0),IF(G18,0,IF(F18,1,0))))))","v":0}]
[null,"Kitchen Hoods",null,"",null,false,false,0,100,100,100,100,100,100,0,null,null,null,null,null,null,null,null,null,null,10,false,10,1,null,"1126 Swift St.","975 Market St. Suite 205","1329 E KEMPER RD. SUITE 4210","1329 E KEMPER RD. SUITE 4210","1126 Swift St.",null,{"$f":"IF(AK8,IF(G19,0,IF(F19,1,IF(AL8,0,1))),IF(G19,0,(IF(AL8,IF(F19,1,0),IF(G19,0,IF(F19,1,0))))))","v":0}]
[null,"Exhaust Fans ",null,"Show",null,true,false,5,75,50,50,50,50,35,375,null,9,"Fume Hood Airflow Testing with Sash Velocity and/or Smoke Capture Test",null,null,null,null,null,null,null,11,false,11,1,null,"North Kansas City, MO 64116","Fort Mill, SC 29708","CINCINNATI, OH 45246","CINCINNATI, OH 45246","North Kansas City, MO 64116",null,{"$f":"IF(AK8,IF(G20,0,IF(F20,1,IF(AL8,0,1))),IF(G20,0,(IF(AL8,IF(F20,1,0),IF(G20,0,IF(F20,1,0))))))","v":1}]
[null,"Supply Fans ",null,"",null,false,false,0,75,75,75,75,75,50,0,null,null,null,null,null,null,null,null,null,null,12,false,12,1,null,"513-860-2050","513-860-2050","513-860-2050","513-860-2050","513-860-2050",null,{"$f":"IF(AK8,IF(G21,0,IF(F21,1,IF(AL8,0,1))),IF(G21,0,(IF(AL8,IF(F21,1,0),IF(G21,0,IF(F21,1,0))))))","v":0}]
[null,"KEFs",null,"",null,false,false,0,70,18,22,20,25,25,0,null,10,"Kitchen Ventilation (Hoods) smoke Capture & Containment Testing",null,null,null,null,null,null,null,13,false,13,1,null,null,null,null,null,null,null,{"$f":"IF(AK8,IF(G22,0,IF(F22,1,IF(AL8,0,1))),IF(G22,0,(IF(AL8,IF(F22,1,0),IF(G22,0,IF(F22,1,0))))))","v":0}]
[null,"Fume Hoods",null,"",null,false,false,0,150,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,14,false,14,1,null,null,null,null,null,null,null,{"$f":"IF(AK8,IF(G23,0,IF(F23,1,IF(AL8,0,1))),IF(G23,0,(IF(AL8,IF(F23,1,0),IF(G23,0,IF(F23,1,0))))))","v":0}]
[null,"Ceiling Mounted Exhaust Fans",null,"",null,false,false,0,40,50,50,50,50,50,0,null,11,"Sheave & Belt Change on Asset(s)",null,null,null,null,null,null,null,15,false,15,1,null,null,null,null,null,null,null,{"$f":"IF(AK8,IF(G24,0,IF(F24,1,IF(AL8,0,1))),IF(G24,0,(IF(AL8,IF(F24,1,0),IF(G24,0,IF(F24,1,0))))))","v":0}]
[null,"Traverses",null,"",null,false,false,0,55,50,50,50,50,50,0,null,null,null,null,null,null,null,null,null,null,16,false,16,1,null,{"$f":"_xlfn.SWITCH(AA8,1,AE18,2,AF18,3,AG18,4,AH18,5,AI18)","v":"Cincinnati Office:"},null,null,null,null,null,{"$f":"IF(AK8,IF(G25,0,IF(F25,1,IF(AL8,0,1))),IF(G25,0,(IF(AL8,IF(F25,1,0),IF(G25,0,IF(F25,1,0))))))","v":0}]
[null,"Air Devices ",null,"Don’t",null,false,false,76,25,10,20,30,40,50,1900,null,12,"Duct Leakage Testing (Dalt) per specifications",null,null,null,null,null,null,null,17,false,17,1,null,{"$f":"_xlfn.SWITCH(AA8,1,AE19,2,AF19,3,AG19,4,AH19,5,AI19)","v":"1329 E KEMPER RD. SUITE 4210"},null,null,null,null,null,{"$f":"IF(AK8,IF(G26,0,IF(F26,1,IF(AL8,0,1))),IF(G26,0,(IF(AL8,IF(F26,1,0),IF(G26,0,IF(F26,1,0))))))","v":0}]
[null,null,null,null,null,null,null,"Air Total",null,null,null,null,null,null,{"$f":"SUM(O10:O26)","v":4275},null,null,null,null,null,null,null,null,null,null,18,false,18,1,null,{"$f":"_xlfn.SWITCH(AA8,1,AE20,2,AF20,3,AG20,4,AH20,5,AI20)","v":"CINCINNATI, OH 45246"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Commissioning Participation to include assisting Commissioning Team and primary Trades to verify performance and/or results of a portion of HVAC Assets or has specified",null,null,null,null,null,null,null,19,false,19,1,null,{"$f":"_xlfn.SWITCH(AA8,1,AE21,2,AF21,3,AG21,4,AH21,5,AI21)","v":"513-860-2050"}]
[null,"Hydronic Equipment","Notes","Output","Manually Add",null,null,"Quantity","Price","w temps",null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,20,false,20,1]
[null,"Pumps ","(Typical)",{"$f":"IF(H30>0,IF(AK30=1,\"Show\",\"Don’t\"),\"\")","v":""},null,false,null,0,250,125,null,null,null,null,{"$f":"(H30*I30)","v":0},null,14,"Commissioning for Performance (CFP) of HVAC Assets to include Design Review to ensure TAB success, Weekly site review & recommended modifications during Construction Phase, and random % of functional testing. (This is Not LEED Testing)",null,null,null,null,null,null,null,21,false,21,1,null,null,null,null,null,null,"hydronic",{"$f":"IF(F30,1,0)","v":0}]
[null,"Boilers",null,{"$f":"IF(H31>0,IF(AK31=1,\"Show\",\"Don’t\"),\"\")","v":""},null,false,null,0,150,125,null,null,null,null,{"$f":"(H31*I31)","v":0},null,null,null,null,null,null,null,null,null,null,22,true,22,2,null,null,null,null,null,null,null,0]
[null,"Recirc pumps ","(ie AHU Coils)","",null,false,null,0,100,75,null,null,null,null,{"$f":"(H32*I32)","v":0},null,15,"Evaluation & Adjustments of Existing Building and/or Assets to Recommend Mechanical or Design changes to improve space comfort or energy efficiencies",null,null,null,null,null,null,null,23,false,23,2,null,null,null,null,null,null,null,0]
[null,"Chiller",null,"",null,false,null,0,300,125,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,24,false,24,2,null,null,null,null,null,null,null,0]
[null,"Cooling Tower",null,"",null,false,null,0,300,125,null,null,null,null,0,null,16,"As-Built Drawings of Existing HVAC Assets & their associated Distribution System",null,null,null,null,null,null,null,25,false,25,2,null,null,null,null,null,null,null,0]
[null,"Heat Exchanger",null,"",null,false,null,0,150,125,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,26,false,26,2,null,null,null,null,null,null,null,0]
[null,"AHU coil",null,"",null,false,null,0,75,60,null,null,null,null,0,null,17,"Indoor Air Quality (IAQ) testing per specifications",null,null,null,null,null,null,null,27,false,27,2,null,null,null,null,null,null,null,0]
[null,"VAV Reheat",null,"",null,false,null,0,50,50,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,28,false,28,2,null,null,null,null,null,null,null,0]
[null,"FC/UV"," (4-pipe sys)","",null,false,null,0,100,75,null,null,null,null,0,null,18,"Building Envelope (Leakage) Testing",null,null,null,null,null,null,null,29,false,29,2,null,null,null,null,null,null,null,0]
[null,"FC/UV ","(2-pipe sys)","",null,false,null,0,55,50,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,30,false,30,2,null,null,null,null,null,null,null,0]
[null,"UH/CUH",null,"",null,false,null,0,50,50,null,null,null,null,0,null,19,"Sound Testing Per Specifications for Interior Spaces ",null,null,null,null,null,null,null,31,false,31,2,null,null,null,null,null,null,null,0]
[null,"FTR/RP",null,"",null,false,null,0,60,50,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,false,null,0,null,null,null,null,null,null,0,null,20,"Vibration Testing on specific HVAC Assets per Specifications",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,"Hydronic Total",null,null,null,null,null,null,{"$f":"SUM(O30:O42)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"Pretesting of Existing Systems Prior to Demo or to determine current operating parameters"]
[null,"Misc.  ","Notes","Output","Manually ADD",null,null,"Quantity","Price",null,null,null,null,null,"Total"]
[null,"Commissioning Participation","Price Per Day",{"$f":"IF(H46>0,IF(AK46=1,\"Show\",\"Don’t\"),\"\")","v":""},null,false,null,0,1000,null,null,null,null,null,{"$f":"(H46*I46)","v":0},null,22,"TAB of listed equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"misc",{"$f":"IF(F46,1,0)","v":0}]
[null,"Prelim (Pretesting)","Price Per Day",{"$f":"IF(H47>0,IF(AK47=1,\"Show\",\"Don’t\"),\"\")","v":""}," ",false,null,0,1200,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F47,1,0)","v":0}]
[null,"Duct Testing","Price Per Test","",null,false,null,0,650,null,null,null,null,null,0,null,23," No Lift Included. IF needed will be additional",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Union / PW (Ky or WPAFB)","Price / $1000 of base bid","",null,false,null,0,250,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Flight",null,"",null,false,null,0,700,null,null,null,null,null,0,null,24," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Travel/lodge","Price Per night","",null,false,null,0,250,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,"additions",null,null,null,null,null,null,null,null,null,0]
[null,"Equipment Rental",null,"",null,false,null,0,75,null,null,null,null,null,0,null,25,null,null,null,null,null,null,null,null,null,{"$f":"IF(O60>0,E60&CHAR(10),\"\")&IF(O61>0,E61&CHAR(10),\"\")&IF(O62>0,E62&CHAR(10),\"\")&IF(O63>0,E63&CHAR(10),\"\")","v":""},{"$f":"IF(O60>0,\"$      \"&O60&CHAR(10),\"\")&IF(O61>0,\"$      \"&O61&CHAR(10),\"\")&IF(O62>0,\"$      \"&O62&CHAR(10),\"\")&IF(O63>0,\"$      \"&O63&CHAR(10),\"\")","v":""},null,null,null,null,null,null,null,null,0]
[null,"Belt/Sheave Change",null,"",null,false,null,0,75,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Misc Expenses",null,"",null,false,null,0,75,null,null,null,null,null,0,null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F54,1,0)","v":0}]
[null,null,null,null,null,null,null,"Misc. Total",null,null,null,null,null,null,{"$f":"SUM(O46:O54)","v":0}]
[null,"Internal Processing/Estimating Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null," /",null,null,"Esimator suggested adjustment:",null,null,null,null,null,null,null,null,null,500]
[null,null,null,null,"TAB PRICE: ",null,null,null,null,null,null,null,null,null,{"$f":"O27+O43+O55+O57","v":4775},null,28,null,null,null,null,null,null,null,null,null,"Price in words"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"With amazing function",null,null,null,"Additional price situation:","p",null,null,null,null,"custom addition"]
[null,null,null,null,"Custom Addition #1 =",false,null,null,{"$f":"IF(AK60=1,\"Show\",\"\")","v":""},null,null,null,null,null,0,null,29,null,null,null,null,null,null,null,null,null,{"$f":"SpellNumber(O64)","v":"Four Thousand Seven Hundred Seventy Five US Dollars and Zero Cents"},null,null,null,"oeu","price part",null,null,null,null,{"$f":"IF(F60,1,0)","v":0}]
[null,null,null,null,"Custom Addition #2 =",false,null,null,{"$f":"IF(AK61=1,\"Show\",\"\")","v":""},"Custom Addition #1",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK60=1,E60&CHAR(10),\"\")&IF(AK61=1,E61&CHAR(10),\"\")&IF(AK62=1,E62&CHAR(10),\"\")&IF(AK63=1,E63&CHAR(10),\"\")&IF(AK64=1,E64,\"\")&IF(AK65>0,AH61,\"\")","v":""},{"$f":"IF(AK60=1,\"$   \"&O60&\".00\"&CHAR(10),\"\")&IF(AK61=1,\"$   \"&O61&\".00\"&CHAR(10),\"\")&IF(AK62=1,\"$   \"&O62&\".00\"&CHAR(10),\"\")&IF(AK63=1,\"$   \"&O63&\".00\"&CHAR(10),\"\")&IF(AK64=1,\"$   \"&O64&\".00\",\"\")&IF(AK65>0,\"$   \"&AH62&\".00\",\"\")","v":""},null,"Final Adjusted Price =",null,null,{"$f":"IF(F61,1,0)","v":0}]
[null,null,null,null,"Custom Addition #3 = ",false,null,null,{"$f":"IF(AK62=1,\"Show\",\"\")","v":""},null,null,null,null,null,0,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O64","v":4775},null,null,0]
[null,null,null,null,"Custom Addition #4 = ",false,false,null,{"$f":"IF(AK63=1,\"Show\",\"\")","v":""},null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Final Adjusted Price =",null,null,null,null,null,null,null,null,null,{"$f":"SUM(O58:O63)","v":4775},null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G63,1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AK64,\"Show\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sum of above",0]
[null," "]
[null," "]
[]
[]
[]
[null," "]

{"sheet":"Sheet3","index":2,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":true,"merged":[[1,13,15,20]]}
["Equipment","Notes","Quantity","Price","Total",null,"order","0-left, 1 right, 3 not","show ? ","show quantity","functions :"]
[{"$f":"'Tab Calc'!B10","v":"RTUs"},{"$f":"'Tab Calc'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Tab Calc'!H10","v":0},{"$f":"'Tab Calc'!I10","v":190},{"$f":"'Tab Calc'!O10","v":0},null,{"$f":"IF(C2>0,1,0)","v":0},{"$f":"IF(C2>0,IF(G2<G43,0,1),3)","v":3},{"$f":"IF(C2=0,0,'Tab Calc'!AK10)","v":0},{"$f":"IF(I2,C2,\"\")","v":""},{"$f":"IF(C2>0,IF(G2<G43,IF(G2=1,CHAR(10)&A2&CHAR(10),A2&CHAR(10)),\"\"))","v":false},null,null,{"$f":"\"This Sheet Contains Functions and Calculations.\"&CHAR(10)&CHAR(10)&\"Don't Delete this sheet.\"","v":"This Sheet Contains Functions and Calculations.\n\nDon't Delete this sheet."}]
[{"$f":"'Tab Calc'!B11","v":"AHUs"},{"$f":"'Tab Calc'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Tab Calc'!H11","v":0},{"$f":"'Tab Calc'!I11","v":400},{"$f":"'Tab Calc'!O11","v":0},null,{"$f":"IF(C3>0,MAX(G2+1),0)","v":0},{"$f":"IF(C3>0,IF(G3<G43,0,1),3)","v":3},{"$f":"IF(C3=0,0,'Tab Calc'!AK11)","v":0},{"$f":"IF(I3,C3,\"\")","v":""},{"$f":"_xlfn.SWITCH(H2,0,IF(G2>1,CHAR(10),\"\")&A2)","v":{"$error":"#N/A"}}]
[{"$f":"'Tab Calc'!B12","v":"DOAS "},{"$f":"'Tab Calc'!C12","v":0},{"$f":"'Tab Calc'!H12","v":0},{"$f":"'Tab Calc'!I12","v":400},{"$f":"'Tab Calc'!O12","v":0},null,{"$f":"IF(C4>0,MAX(G2:G3)+1,0)","v":0},{"$f":"IF(C4>0,IF(G4<G43,0,1),3)","v":3},{"$f":"IF(C4=0,0,'Tab Calc'!AK12)","v":0},"",{"$f":"IF(Sheet3!H2=0,IF(Sheet3!G2>1,CHAR(10),\"\")&Sheet3!A2,\"\")","v":""}]
[{"$f":"'Tab Calc'!B13","v":"FCUs"},{"$f":"'Tab Calc'!C13","v":"ducted change name to what drwg calls it"},{"$f":"'Tab Calc'!H13","v":10},{"$f":"'Tab Calc'!I13","v":200},{"$f":"'Tab Calc'!O13","v":2000},null,{"$f":"IF(C5>0,MAX(G2:G3:G4)+1,0)","v":1},{"$f":"IF(C5>0,IF(G5<G43,0,1),3)","v":0},{"$f":"IF(C5=0,0,'Tab Calc'!AK13)","v":1},10,{"$f":"IF(Sheet3!H2=1,IF(Sheet3!G2>Sheet3!G42,CHAR(10),\"\")&Sheet3!C2,\"\")&IF(Sheet3!H3=1,IF(Sheet3!G3>Sheet3!G42,CHAR(10),\"\")&Sheet3!C3,\"\")&IF(Sheet3!H4=1,IF(Sheet3!G4>Sheet3!G42,CHAR(10),\"\")&Sheet3!C4,\"\")&IF(Sheet3!H5=1,IF(Sheet3!G5>Sheet3!G42,CHAR(10),\"\")&Sheet3!C5,\"\")&IF(Sheet3!H6=1,IF(Sheet3!G6>Sheet3!G42,CHAR(10),\"\")&Sheet3!C6,\"\")&IF(Sheet3!H7=1,IF(Sheet3!G7>Sheet3!G42,CHAR(10),\"\")&Sheet3!C7,\"\")&IF(Sheet3!H8=1,IF(Sheet3!G8>Sheet3!G42,CHAR(10),\"\")&Sheet3!C8,\"\")&IF(Sheet3!H9=1,IF(Sheet3!G9>Sheet3!G42,CHAR(10),\"\")&Sheet3!C9,\"\")&IF(Sheet3!H10=1,IF(Sheet3!G10>Sheet3!G42,CHAR(10),\"\")&Sheet3!C10,\"\")&IF(Sheet3!H11=1,IF(Sheet3!G11>Sheet3!G42,CHAR(10),\"\")&Sheet3!C11,\"\")&IF(Sheet3!H12=1,IF(Sheet3!G12>Sheet3!G42,CHAR(10),\"\")&Sheet3!C12,\"\")&IF(Sheet3!H13=1,IF(Sheet3!G13>Sheet3!G42,CHAR(10),\"\")&Sheet3!C13,\"\")&IF(Sheet3!H14=1,IF(Sheet3!G14>Sheet3!G42,CHAR(10),\"\")&Sheet3!C14,\"\")&IF(Sheet3!H15=1,IF(Sheet3!G15>Sheet3!G42,CHAR(10),\"\")&Sheet3!C15,\"\")&IF(Sheet3!H16=1,IF(Sheet3!G16>Sheet3!G42,CHAR(10),\"\")&Sheet3!C16,\"\")&IF(Sheet3!H17=1,IF(Sheet3!G17>Sheet3!G42,CHAR(10),\"\")&Sheet3!C17,\"\")&IF(Sheet3!H18=1,IF(Sheet3!G18>Sheet3!G42,CHAR(10),\"\")&Sheet3!C18,\"\")&IF(Sheet3!H19=1,IF(Sheet3!G19>Sheet3!G42,CHAR(10),\"\")&Sheet3!C19,\"\")&IF(Sheet3!H20=1,IF(Sheet3!G20>Sheet3!G42,CHAR(10),\"\")&Sheet3!C20,\"\")&IF(Sheet3!H21=1,IF(Sheet3!G21>Sheet3!G42,CHAR(10),\"\")&Sheet3!C21,\"\")&IF(Sheet3!H22=1,IF(Sheet3!G22>Sheet3!G42,CHAR(10),\"\")&Sheet3!C22,\"\")&IF(Sheet3!H23=1,IF(Sheet3!G23>Sheet3!G42,CHAR(10),\"\")&Sheet3!C23,\"\")&IF(Sheet3!H24=1,IF(Sheet3!G24>Sheet3!G42,CHAR(10),\"\")&Sheet3!C24,\"\")&IF(Sheet3!H25=1,IF(Sheet3!G25>Sheet3!G42,CHAR(10),\"\")&Sheet3!C25,\"\")&IF(Sheet3!H26=1,IF(Sheet3!G26>Sheet3!G42,CHAR(10),\"\")&Sheet3!C26,\"\")&IF(Sheet3!H27=1,IF(Sheet3!G27>Sheet3!G42,CHAR(10),\"\")&Sheet3!C27,\"\")&IF(Sheet3!H28=1,IF(Sheet3!G28>Sheet3!G42,CHAR(10),\"\")&Sheet3!C28,\"\")&IF(Sheet3!H29=1,IF(Sheet3!G29>Sheet3!G42,CHAR(10),\"\")&Sheet3!C29,\"\")&IF(Sheet3!H30=1,IF(Sheet3!G30>Sheet3!G42,CHAR(10),\"\")&Sheet3!C30,\"\")&IF(Sheet3!H31=1,IF(Sheet3!G31>Sheet3!G42,CHAR(10),\"\")&Sheet3!C31,\"\")&IF(Sheet3!H32=1,IF(Sheet3!G32>Sheet3!G42,CHAR(10),\"\")&Sheet3!C32,\"\")&IF(Sheet3!H33=1,IF(Sheet3!G33>Sheet3!G42,CHAR(10),\"\")&Sheet3!C33,\"\")&IF(Sheet3!H34=1,IF(Sheet3!G34>Sheet3!G42,CHAR(10),\"\")&Sheet3!C34,\"\")&IF(Sheet3!H35=1,IF(Sheet3!G35>Sheet3!G42,CHAR(10),\"\")&Sheet3!C35,\"\")&IF(Sheet3!H36=1,IF(Sheet3!G36>Sheet3!G42,CHAR(10),\"\")&Sheet3!C36,\"\")&IF(Sheet3!H37=1,IF(Sheet3!G37>Sheet3!G42,CHAR(10),\"\")&Sheet3!C37,\"\")&IF(Sheet3!H38=1,IF(Sheet3!G38>Sheet3!G42,CHAR(10),\"\")&Sheet3!C38,\"\")&IF(Sheet3!H39=1,IF(Sheet3!G39>Sheet3!G42,CHAR(10),\"\")&Sheet3!C39,\"\")","v":"\n76"}]
[{"$f":"'Tab Calc'!B14","v":"ERVs "},{"$f":"'Tab Calc'!C14","v":0},{"$f":"'Tab Calc'!H14","v":0},{"$f":"'Tab Calc'!I14","v":300},{"$f":"'Tab Calc'!O14","v":0},null,{"$f":"IF(C6>0,MAX(G2:G3:G4:G5)+1,0)","v":0},{"$f":"IF(C6>0,IF(G6<G43,0,1),3)","v":3},{"$f":"IF(C6=0,0,'Tab Calc'!AK14)","v":0},"",{"$f":"IF(Sheet3!H2=1,IF(Sheet3!G2>Sheet3!G42,CHAR(10),\"\")&Sheet3!C2,\"\")","v":""}]
[{"$f":"'Tab Calc'!B15","v":"VRFs"},{"$f":"'Tab Calc'!C15","v":0},{"$f":"'Tab Calc'!H15","v":0},{"$f":"'Tab Calc'!I15","v":175},{"$f":"'Tab Calc'!O15","v":0},null,{"$f":"IF(C7>0,MAX(G2:G3:G4:G5:G6)+1,0)","v":0},{"$f":"IF(C7>0,IF(G7<G43,0,1),3)","v":3},{"$f":"IF(C7=0,0,'Tab Calc'!AK15)","v":0},"",{"$f":"IF(Sheet3!H2=0,IF(Sheet3!G2>1,CHAR(10),\"\")&Sheet3!C2,\"\")&IF(Sheet3!H3=0,IF(Sheet3!G3>1,CHAR(10),\"\")&Sheet3!C3,\"\")&IF(Sheet3!H4=0,IF(Sheet3!G4>1,CHAR(10),\"\")&Sheet3!C4,\"\")&IF(Sheet3!H5=0,IF(Sheet3!G5>1,CHAR(10),\"\")&Sheet3!C5,\"\")&IF(Sheet3!H6=0,IF(Sheet3!G6>1,CHAR(10),\"\")&Sheet3!C6,\"\")&IF(Sheet3!H7=0,IF(Sheet3!G7>1,CHAR(10),\"\")&Sheet3!C7,\"\")&IF(Sheet3!H8=0,IF(Sheet3!G8>1,CHAR(10),\"\")&Sheet3!C8,\"\")&IF(Sheet3!H9=0,IF(Sheet3!G9>1,CHAR(10),\"\")&Sheet3!C9,\"\")&IF(Sheet3!H10=0,IF(Sheet3!G10>1,CHAR(10),\"\")&Sheet3!C10,\"\")&IF(Sheet3!H11=0,IF(Sheet3!G11>1,CHAR(10),\"\")&Sheet3!C11,\"\")&IF(Sheet3!H12=0,IF(Sheet3!G12>1,CHAR(10),\"\")&Sheet3!C12,\"\")&IF(Sheet3!H13=0,IF(Sheet3!G13>1,CHAR(10),\"\")&Sheet3!C13,\"\")&IF(Sheet3!H14=0,IF(Sheet3!G14>1,CHAR(10),\"\")&Sheet3!C14,\"\")&IF(Sheet3!H15=0,IF(Sheet3!G15>1,CHAR(10),\"\")&Sheet3!C15,\"\")&IF(Sheet3!H16=0,IF(Sheet3!G16>1,CHAR(10),\"\")&Sheet3!C16,\"\")&IF(Sheet3!H17=0,IF(Sheet3!G17>1,CHAR(10),\"\")&Sheet3!C17,\"\")&IF(Sheet3!H18=0,IF(Sheet3!G18>1,CHAR(10),\"\")&Sheet3!C18,\"\")&IF(Sheet3!H19=0,IF(Sheet3!G19>1,CHAR(10),\"\")&Sheet3!C19,\"\")&IF(Sheet3!H20=0,IF(Sheet3!G20>1,CHAR(10),\"\")&Sheet3!C20,\"\")&IF(Sheet3!H21=0,IF(Sheet3!G21>1,CHAR(10),\"\")&Sheet3!C21,\"\")&IF(Sheet3!H22=0,IF(Sheet3!G22>1,CHAR(10),\"\")&Sheet3!C22,\"\")&IF(Sheet3!H23=0,IF(Sheet3!G23>1,CHAR(10),\"\")&Sheet3!C23,\"\")&IF(Sheet3!H24=0,IF(Sheet3!G24>1,CHAR(10),\"\")&Sheet3!C24,\"\")&IF(Sheet3!H25=0,IF(Sheet3!G25>1,CHAR(10),\"\")&Sheet3!C25,\"\")&IF(Sheet3!H26=0,IF(Sheet3!G26>1,CHAR(10),\"\")&Sheet3!C26,\"\")&IF(Sheet3!H27=0,IF(Sheet3!G27>1,CHAR(10),\"\")&Sheet3!C27,\"\")&IF(Sheet3!H28=0,IF(Sheet3!G28>1,CHAR(10),\"\")&Sheet3!C28,\"\")&IF(Sheet3!H29=0,IF(Sheet3!G29>1,CHAR(10),\"\")&Sheet3!C29,\"\")&IF(Sheet3!H30=0,IF(Sheet3!G30>1,CHAR(10),\"\")&Sheet3!C30,\"\")&IF(Sheet3!H31=0,IF(Sheet3!G31>1,CHAR(10),\"\")&Sheet3!C31,\"\")&IF(Sheet3!H32=0,IF(Sheet3!G32>1,CHAR(10),\"\")&Sheet3!C32,\"\")&IF(Sheet3!H33=0,IF(Sheet3!G33>1,CHAR(10),\"\")&Sheet3!C33,\"\")&IF(Sheet3!H34=0,IF(Sheet3!G34>1,CHAR(10),\"\")&Sheet3!C34,\"\")&IF(Sheet3!H35=0,IF(Sheet3!G35>1,CHAR(10),\"\")&Sheet3!C35,\"\")&IF(Sheet3!H36=0,IF(Sheet3!G36>1,CHAR(10),\"\")&Sheet3!C36,\"\")&IF(Sheet3!H37=0,IF(Sheet3!G37>1,CHAR(10),\"\")&Sheet3!C37,\"\")&IF(Sheet3!H38=0,IF(Sheet3!G38>1,CHAR(10),\"\")&Sheet3!C38,\"\")&IF(Sheet3!H39=0,IF(Sheet3!G39>1,CHAR(10),\"\")&Sheet3!C39,\"\")","v":"10\n5"}]
[{"$f":"'Tab Calc'!B16","v":"VAVs"},{"$f":"'Tab Calc'!C16","v":0},{"$f":"'Tab Calc'!H16","v":0},{"$f":"'Tab Calc'!I16","v":59},{"$f":"'Tab Calc'!O16","v":0},null,{"$f":"IF(C8>0,MAX(G2:G3:G4:G5:G6:G7)+1,0)","v":0},{"$f":"IF(C8>0,IF(G8<G43,0,1),3)","v":3},{"$f":"IF(C8=0,0,'Tab Calc'!AK16)","v":0},""]
[{"$f":"'Tab Calc'!B17","v":"FPVAVs"},{"$f":"'Tab Calc'!C17","v":0},{"$f":"'Tab Calc'!H17","v":0},{"$f":"'Tab Calc'!I17","v":84},{"$f":"'Tab Calc'!O17","v":0},null,{"$f":"IF(C9>0,MAX(G2:G3:G4:G5:G6:G7:G8)+1,0)","v":0},{"$f":"IF(C9>0,IF(G9<G43,0,1),3)","v":3},{"$f":"IF(C9=0,0,'Tab Calc'!AK17)","v":0},""]
[{"$f":"'Tab Calc'!B18","v":"MUAs"},{"$f":"'Tab Calc'!C18","v":0},{"$f":"'Tab Calc'!H18","v":0},{"$f":"'Tab Calc'!I18","v":100},{"$f":"'Tab Calc'!O18","v":0},null,{"$f":"IF(C10>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9)+1,0)","v":0},{"$f":"IF(C10>0,IF(G10<G43,0,1),3)","v":3},{"$f":"IF(C10=0,0,'Tab Calc'!AK18)","v":0},""]
[{"$f":"'Tab Calc'!B19","v":"Kitchen Hoods"},{"$f":"'Tab Calc'!C19","v":0},{"$f":"'Tab Calc'!H19","v":0},{"$f":"'Tab Calc'!I19","v":100},{"$f":"'Tab Calc'!O19","v":0},null,{"$f":"IF(C11>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10)+1,0)","v":0},{"$f":"IF(C11>0,IF(G11<G43,0,1),3)","v":3},{"$f":"IF(C11=0,0,'Tab Calc'!AK19)","v":0},""]
[{"$f":"'Tab Calc'!B20","v":"Exhaust Fans "},{"$f":"'Tab Calc'!C20","v":0},{"$f":"'Tab Calc'!H20","v":5},{"$f":"'Tab Calc'!I20","v":75},{"$f":"'Tab Calc'!O20","v":375},null,{"$f":"IF(C12>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11)+1,0)","v":2},{"$f":"IF(C12>0,IF(G12<G43,0,1),3)","v":0},{"$f":"IF(C12=0,0,'Tab Calc'!AK20)","v":1},5]
[{"$f":"'Tab Calc'!B21","v":"Supply Fans "},{"$f":"'Tab Calc'!C21","v":0},{"$f":"'Tab Calc'!H21","v":0},{"$f":"'Tab Calc'!I21","v":75},{"$f":"'Tab Calc'!O21","v":0},null,{"$f":"IF(C13>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12)+1,0)","v":0},{"$f":"IF(C13>0,IF(G13<G43,0,1),3)","v":3},{"$f":"IF(C13=0,0,'Tab Calc'!AK21)","v":0},""]
[{"$f":"'Tab Calc'!B22","v":"KEFs"},{"$f":"'Tab Calc'!C22","v":0},{"$f":"'Tab Calc'!H22","v":0},{"$f":"'Tab Calc'!I22","v":70},{"$f":"'Tab Calc'!O22","v":0},null,{"$f":"IF(C14>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13)+1,0)","v":0},{"$f":"IF(C14>0,IF(G14<G43,0,1),3)","v":3},{"$f":"IF(C14=0,0,'Tab Calc'!AK22)","v":0},""]
[{"$f":"'Tab Calc'!B23","v":"Fume Hoods"},{"$f":"'Tab Calc'!C23","v":0},{"$f":"'Tab Calc'!H23","v":0},{"$f":"'Tab Calc'!I23","v":150},{"$f":"'Tab Calc'!O23","v":0},null,{"$f":"IF(C15>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14)+1,0)","v":0},{"$f":"IF(C15>0,IF(G15<G43,0,1),3)","v":3},{"$f":"IF(C15=0,0,'Tab Calc'!AK23)","v":0},""]
[{"$f":"'Tab Calc'!C24","v":0},{"$f":"'Tab Calc'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Tab Calc'!H24","v":0},{"$f":"'Tab Calc'!I24","v":40},{"$f":"'Tab Calc'!O24","v":0},null,{"$f":"IF(C16>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15)+1,0)","v":0},{"$f":"IF(C16>0,IF(G16<G43,0,1),3)","v":3},{"$f":"IF(C16=0,0,'Tab Calc'!AK24)","v":0},""]
[{"$f":"'Tab Calc'!B25","v":"Traverses"},{"$f":"'Tab Calc'!C25","v":0},{"$f":"'Tab Calc'!H25","v":0},{"$f":"'Tab Calc'!I25","v":55},{"$f":"'Tab Calc'!O25","v":0},null,{"$f":"IF(C17>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16)+1,0)","v":0},{"$f":"IF(C17>0,IF(G17<G43,0,1),3)","v":3},{"$f":"IF(C17=0,0,'Tab Calc'!AK25)","v":0},""]
[{"$f":"'Tab Calc'!B26","v":"Air Devices "},{"$f":"'Tab Calc'!C26","v":0},{"$f":"'Tab Calc'!H26","v":76},{"$f":"'Tab Calc'!I26","v":25},{"$f":"'Tab Calc'!O26","v":1900},null,{"$f":"IF(C18>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17)+1,0)","v":3},{"$f":"IF(C18>0,IF(G18<G43,0,1),3)","v":1},{"$f":"IF(C18=0,0,'Tab Calc'!AK26)","v":0},""]
[{"$f":"'Tab Calc'!B30","v":"Pumps "},{"$f":"'Tab Calc'!C30","v":"(Typical)"},{"$f":"'Tab Calc'!H30","v":0},{"$f":"'Tab Calc'!I30","v":250},{"$f":"'Tab Calc'!O30","v":0},null,{"$f":"IF(C19>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18)+1,0)","v":0},{"$f":"IF(C19>0,IF(G19<G43,0,1),3)","v":3},{"$f":"IF(C19=0,0,'Tab Calc'!AK30)","v":0},""]
[{"$f":"'Tab Calc'!B31","v":"Boilers"},{"$f":"'Tab Calc'!C31","v":0},{"$f":"'Tab Calc'!H31","v":0},{"$f":"'Tab Calc'!I31","v":150},{"$f":"'Tab Calc'!O31","v":0},null,{"$f":"IF(C20>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19)+1,0)","v":0},{"$f":"IF(C20>0,IF(G20<G43,0,1),3)","v":3},{"$f":"IF(C20=0,0,'Tab Calc'!AK31)","v":0},""]
[{"$f":"'Tab Calc'!B32","v":"Recirc pumps "},{"$f":"'Tab Calc'!C32","v":"(ie AHU Coils)"},{"$f":"'Tab Calc'!H32","v":0},{"$f":"'Tab Calc'!I32","v":100},{"$f":"'Tab Calc'!O32","v":0},null,{"$f":"IF(C21>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20)+1,0)","v":0},{"$f":"IF(C21>0,IF(G21<G43,0,1),3)","v":3},{"$f":"IF(C21=0,0,'Tab Calc'!AK32)","v":0},""]
[{"$f":"'Tab Calc'!B33","v":"Chiller"},{"$f":"'Tab Calc'!C33","v":0},{"$f":"'Tab Calc'!H33","v":0},{"$f":"'Tab Calc'!I33","v":300},{"$f":"'Tab Calc'!O33","v":0},null,{"$f":"IF(C22>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21)+1,0)","v":0},{"$f":"IF(C22>0,IF(G22<G43,0,1),3)","v":3},{"$f":"IF(C22=0,0,'Tab Calc'!AK33)","v":0},""]
[{"$f":"'Tab Calc'!B34","v":"Cooling Tower"},{"$f":"'Tab Calc'!C34","v":0},{"$f":"'Tab Calc'!H34","v":0},{"$f":"'Tab Calc'!I34","v":300},{"$f":"'Tab Calc'!O34","v":0},null,{"$f":"IF(C23>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22)+1,0)","v":0},{"$f":"IF(C23>0,IF(G23<G43,0,1),3)","v":3},{"$f":"IF(C23=0,0,'Tab Calc'!AK34)","v":0},""]
[{"$f":"'Tab Calc'!B35","v":"Heat Exchanger"},{"$f":"'Tab Calc'!C35","v":0},{"$f":"'Tab Calc'!H35","v":0},{"$f":"'Tab Calc'!I35","v":150},{"$f":"'Tab Calc'!O35","v":0},null,{"$f":"IF(C24>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23)+1,0)","v":0},{"$f":"IF(C24>0,IF(G24<G43,0,1),3)","v":3},{"$f":"IF(C24=0,0,'Tab Calc'!AK35)","v":0},""]
[{"$f":"'Tab Calc'!B36","v":"AHU coil"},{"$f":"'Tab Calc'!C36","v":0},{"$f":"'Tab Calc'!H36","v":0},{"$f":"'Tab Calc'!I36","v":75},{"$f":"'Tab Calc'!O36","v":0},null,{"$f":"IF(C25>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24)+1,0)","v":0},{"$f":"IF(C25>0,IF(G25<G43,0,1),3)","v":3},{"$f":"IF(C25=0,0,'Tab Calc'!AK36)","v":0},""]
[{"$f":"'Tab Calc'!B37","v":"VAV Reheat"},{"$f":"'Tab Calc'!C37","v":0},{"$f":"'Tab Calc'!H37","v":0},{"$f":"'Tab Calc'!I37","v":50},{"$f":"'Tab Calc'!O37","v":0},null,{"$f":"IF(C26>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25)+1,0)","v":0},{"$f":"IF(C26>0,IF(G26<G43,0,1),3)","v":3},{"$f":"IF(C26=0,0,'Tab Calc'!AK37)","v":0},""]
[{"$f":"'Tab Calc'!B38","v":"FC/UV"},{"$f":"'Tab Calc'!C38","v":" (4-pipe sys)"},{"$f":"'Tab Calc'!H38","v":0},{"$f":"'Tab Calc'!I38","v":100},{"$f":"'Tab Calc'!O38","v":0},null,{"$f":"IF(C27>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25:G26)+1,0)","v":0},{"$f":"IF(C27>0,IF(G27<G43,0,1),3)","v":3},{"$f":"IF(C27=0,0,'Tab Calc'!AK38)","v":0},""]
[{"$f":"'Tab Calc'!B39","v":"FC/UV "},{"$f":"'Tab Calc'!C39","v":"(2-pipe sys)"},{"$f":"'Tab Calc'!H39","v":0},{"$f":"'Tab Calc'!I39","v":55},{"$f":"'Tab Calc'!O39","v":0},null,{"$f":"IF(C28>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25:G26:G27)+1,0)","v":0},{"$f":"IF(C28>0,IF(G28<G43,0,1),3)","v":3},{"$f":"IF(C28=0,0,'Tab Calc'!AK39)","v":0},""]
[{"$f":"'Tab Calc'!B40","v":"UH/CUH"},{"$f":"'Tab Calc'!C40","v":0},{"$f":"'Tab Calc'!H40","v":0},{"$f":"'Tab Calc'!I40","v":50},{"$f":"'Tab Calc'!O40","v":0},null,{"$f":"IF(C29>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25:G26:G27:G28)+1,0)","v":0},{"$f":"IF(C29>0,IF(G29<G43,0,1),3)","v":3},{"$f":"IF(C29=0,0,'Tab Calc'!AK40)","v":0},""]
[{"$f":"'Tab Calc'!B41","v":"FTR/RP"},{"$f":"'Tab Calc'!C41","v":0},{"$f":"'Tab Calc'!H41","v":0},{"$f":"'Tab Calc'!I41","v":60},{"$f":"'Tab Calc'!O41","v":0},null,{"$f":"IF(C30>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25:G26:G27:G28:G29)+1,0)","v":0},{"$f":"IF(C30>0,IF(G30<G43,0,1),3)","v":3},{"$f":"IF(C30=0,0,'Tab Calc'!AK41)","v":0},""]
[{"$f":"'Tab Calc'!B46","v":"Commissioning Participation"},{"$f":"'Tab Calc'!C46","v":"Price Per Day"},{"$f":"'Tab Calc'!H46","v":0},{"$f":"'Tab Calc'!I46","v":1000},{"$f":"'Tab Calc'!J46","v":0},null,{"$f":"IF(C31>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25:G26:G27:G28:G29:G30)+1,0)","v":0},{"$f":"IF(C31>0,IF(G31<G43,0,1),3)","v":3},{"$f":"IF(C31=0,0,'Tab Calc'!AK46)","v":0},""]
[{"$f":"'Tab Calc'!B47","v":"Prelim (Pretesting)"},{"$f":"'Tab Calc'!C47","v":"Price Per Day"},{"$f":"'Tab Calc'!H47","v":0},{"$f":"'Tab Calc'!I47","v":1200},{"$f":"'Tab Calc'!J47","v":0},null,{"$f":"IF(C32>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25:G26:G27:G28:G29:G30:G31)+1,0)","v":0},{"$f":"IF(C32>0,IF(G32<G43,0,1),3)","v":3},{"$f":"IF(C32=0,0,'Tab Calc'!AK47)","v":0},""]
[{"$f":"'Tab Calc'!B48","v":"Duct Testing"},{"$f":"'Tab Calc'!C48","v":"Price Per Test"},{"$f":"'Tab Calc'!H48","v":0},{"$f":"'Tab Calc'!I48","v":650},{"$f":"'Tab Calc'!J48","v":0},null,{"$f":"IF(C33>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25:G26:G27:G28:G29:G30:G31:G32)+1,0)","v":0},{"$f":"IF(C33>0,IF(G33<G43,0,1),3)","v":3},{"$f":"IF(C33=0,0,'Tab Calc'!AK48)","v":0},""]
[{"$f":"'Tab Calc'!B49","v":"Union / PW (Ky or WPAFB)"},{"$f":"'Tab Calc'!C49","v":"Price / $1000 of base bid"},{"$f":"'Tab Calc'!H49","v":0},{"$f":"'Tab Calc'!I49","v":250},{"$f":"'Tab Calc'!J49","v":0},null,{"$f":"IF(C34>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25:G26:G27:G28:G29:G30:G31:G32:G33)+1,0)","v":0},{"$f":"IF(C34>0,IF(G34<G43,0,1),3)","v":3},{"$f":"IF(C34=0,0,'Tab Calc'!AK49)","v":0},""]
[{"$f":"'Tab Calc'!B50","v":"Flight"},{"$f":"'Tab Calc'!C50","v":0},{"$f":"'Tab Calc'!H50","v":0},{"$f":"'Tab Calc'!I50","v":700},{"$f":"'Tab Calc'!J50","v":0},null,{"$f":"IF(C35>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25:G26:G27:G28:G29:G30:G31:G32:G33:G34)+1,0)","v":0},{"$f":"IF(C35>0,IF(G35<G43,0,1),3)","v":3},{"$f":"IF(C35=0,0,'Tab Calc'!AK50)","v":0},""]
[{"$f":"'Tab Calc'!B51","v":"Travel/lodge"},{"$f":"'Tab Calc'!C51","v":"Price Per night"},{"$f":"'Tab Calc'!H51","v":0},{"$f":"'Tab Calc'!I51","v":250},{"$f":"'Tab Calc'!J51","v":0},null,{"$f":"IF(C36>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25:G26:G27:G28:G29:G30:G31:G32:G33:G34:G35)+1,0)","v":0},{"$f":"IF(C36>0,IF(G36<G43,0,1),3)","v":3},{"$f":"IF(C36=0,0,'Tab Calc'!AK51)","v":0},""]
[{"$f":"'Tab Calc'!B52","v":"Equipment Rental"},{"$f":"'Tab Calc'!C52","v":0},{"$f":"'Tab Calc'!H52","v":0},{"$f":"'Tab Calc'!I52","v":75},{"$f":"'Tab Calc'!J52","v":0},null,{"$f":"IF(C37>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25:G26:G27:G28:G29:G30:G31:G32:G33:G34:G35:G36)+1,0)","v":0},{"$f":"IF(C37>0,IF(G37<G43,0,1),3)","v":3},{"$f":"IF(C37=0,0,'Tab Calc'!AK52)","v":0},""]
[{"$f":"'Tab Calc'!B53","v":"Belt/Sheave Change"},{"$f":"'Tab Calc'!C53","v":0},{"$f":"'Tab Calc'!H53","v":0},{"$f":"'Tab Calc'!I53","v":75},{"$f":"'Tab Calc'!J53","v":0},null,{"$f":"IF(C38>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25:G26:G27:G28:G29:G30:G31:G32:G33:G34:G35:G36:G37)+1,0)","v":0},{"$f":"IF(C38>0,IF(G38<G43,0,1),3)","v":3},{"$f":"IF(C38=0,0,'Tab Calc'!AK53)","v":0},""]
[{"$f":"'Tab Calc'!B54","v":"Misc Expenses"},{"$f":"'Tab Calc'!C54","v":0},{"$f":"'Tab Calc'!H54","v":0},{"$f":"'Tab Calc'!I54","v":75},{"$f":"'Tab Calc'!J54","v":0},null,{"$f":"IF(C39>0,MAX(G2:G3:G4:G5:G6:G7:G8:G9:G10:G11:G12:G13:G14:G15:G16:G17:G18:G19:G20:G21:G22:G23:G24:G25:G26:G27:G28:G29:G30:G31:G32:G33:G34:G35:G36:G37:G38)+1,0)","v":0},{"$f":"IF(C39>0,IF(G39<G43,0,1),3)","v":3},{"$f":"IF(C39=0,0,'Tab Calc'!AK54)","v":0},""]
[null,null,null,null,null,"total : ",{"$f":"MAX(G2:G39)","v":3}]
[null,null,null,null,null,"devider:",{"$f":"QUOTIENT(G40,2)","v":1}]
[null,null,null,null,null,"less more: ",{"$f":"G40-G41","v":2}]
[null,null,null,null,null,{"$f":"\"+1\"","v":"+1"},{"$f":"(G42+1)","v":3}]
[]
[]
["qt"]
[{"$f":"IF(Sheet3!H2=0,IF(Sheet3!G2>1,CHAR(10),\"\")&IF(Sheet3!I2=1,Sheet3!C2,\"\"))","v":false}]
[]
[]
[]
[]
[{"$f":"IF(Sheet3!H2=1,IF(Sheet3!G2>Sheet3!G42,CHAR(10),\"\")&Sheet3!C2,\"\")&IF(Sheet3!H3=1,IF(Sheet3!G3>Sheet3!G42,CHAR(10),\"\")&Sheet3!C3,\"\")&IF(Sheet3!H4=1,IF(Sheet3!G4>Sheet3!G42,CHAR(10),\"\")&Sheet3!C4,\"\")&IF(Sheet3!H5=1,IF(Sheet3!G5>Sheet3!G42,CHAR(10),\"\")&Sheet3!C5,\"\")&IF(Sheet3!H6=1,IF(Sheet3!G6>Sheet3!G42,CHAR(10),\"\")&Sheet3!C6,\"\")&IF(Sheet3!H7=1,IF(Sheet3!G7>Sheet3!G42,CHAR(10),\"\")&Sheet3!C7,\"\")&IF(Sheet3!H8=1,IF(Sheet3!G8>Sheet3!G42,CHAR(10),\"\")&Sheet3!C8,\"\")&IF(Sheet3!H9=1,IF(Sheet3!G9>Sheet3!G42,CHAR(10),\"\")&Sheet3!C9,\"\")&IF(Sheet3!H10=1,IF(Sheet3!G10>Sheet3!G42,CHAR(10),\"\")&Sheet3!C10,\"\")&IF(Sheet3!H11=1,IF(Sheet3!G11>Sheet3!G42,CHAR(10),\"\")&Sheet3!C11,\"\")&IF(Sheet3!H12=1,IF(Sheet3!G12>Sheet3!G42,CHAR(10),\"\")&Sheet3!C12,\"\")&IF(Sheet3!H13=1,IF(Sheet3!G13>Sheet3!G42,CHAR(10),\"\")&Sheet3!C13,\"\")&IF(Sheet3!H14=1,IF(Sheet3!G14>Sheet3!G42,CHAR(10),\"\")&Sheet3!C14,\"\")&IF(Sheet3!H15=1,IF(Sheet3!G15>Sheet3!G42,CHAR(10),\"\")&Sheet3!C15,\"\")&IF(Sheet3!H16=1,IF(Sheet3!G16>Sheet3!G42,CHAR(10),\"\")&Sheet3!C16,\"\")&IF(Sheet3!H17=1,IF(Sheet3!G17>Sheet3!G42,CHAR(10),\"\")&Sheet3!C17,\"\")&IF(Sheet3!H18=1,IF(Sheet3!G18>Sheet3!G42,CHAR(10),\"\")&Sheet3!C18,\"\")&IF(Sheet3!H19=1,IF(Sheet3!G19>Sheet3!G42,CHAR(10),\"\")&Sheet3!C19,\"\")&IF(Sheet3!H20=1,IF(Sheet3!G20>Sheet3!G42,CHAR(10),\"\")&Sheet3!C20,\"\")&IF(Sheet3!H21=1,IF(Sheet3!G21>Sheet3!G42,CHAR(10),\"\")&Sheet3!C21,\"\")&IF(Sheet3!H22=1,IF(Sheet3!G22>Sheet3!G42,CHAR(10),\"\")&Sheet3!C22,\"\")&IF(Sheet3!H23=1,IF(Sheet3!G23>Sheet3!G42,CHAR(10),\"\")&Sheet3!C23,\"\")&IF(Sheet3!H24=1,IF(Sheet3!G24>Sheet3!G42,CHAR(10),\"\")&Sheet3!C24,\"\")&IF(Sheet3!H25=1,IF(Sheet3!G25>Sheet3!G42,CHAR(10),\"\")&Sheet3!C25,\"\")&IF(Sheet3!H26=1,IF(Sheet3!G26>Sheet3!G42,CHAR(10),\"\")&Sheet3!C26,\"\")&IF(Sheet3!H27=1,IF(Sheet3!G27>Sheet3!G42,CHAR(10),\"\")&Sheet3!C27,\"\")&IF(Sheet3!H28=1,IF(Sheet3!G28>Sheet3!G42,CHAR(10),\"\")&Sheet3!C28,\"\")&IF(Sheet3!H29=1,IF(Sheet3!G29>Sheet3!G42,CHAR(10),\"\")&Sheet3!C29,\"\")&IF(Sheet3!H30=1,IF(Sheet3!G30>Sheet3!G42,CHAR(10),\"\")&Sheet3!C30,\"\")&IF(Sheet3!H31=1,IF(Sheet3!G31>Sheet3!G42,CHAR(10),\"\")&Sheet3!C31,\"\")&IF(Sheet3!H32=1,IF(Sheet3!G32>Sheet3!G42,CHAR(10),\"\")&Sheet3!C32,\"\")&IF(Sheet3!H33=1,IF(Sheet3!G33>Sheet3!G42,CHAR(10),\"\")&Sheet3!C33,\"\")&IF(Sheet3!H34=1,IF(Sheet3!G34>Sheet3!G42,CHAR(10),\"\")&Sheet3!C34,\"\")&IF(Sheet3!H35=1,IF(Sheet3!G35>Sheet3!G42,CHAR(10),\"\")&Sheet3!C35,\"\")&IF(Sheet3!H36=1,IF(Sheet3!G36>Sheet3!G42,CHAR(10),\"\")&Sheet3!C36,\"\")&IF(Sheet3!H37=1,IF(Sheet3!G37>Sheet3!G42,CHAR(10),\"\")&Sheet3!C37,\"\")&IF(Sheet3!H38=1,IF(Sheet3!G38>Sheet3!G42,CHAR(10),\"\")&Sheet3!C38,\"\")&IF(Sheet3!H39=1,IF(Sheet3!G39>Sheet3!G42,CHAR(10),\"\")&Sheet3!C39,\"\")","v":"\n76"}]
[]
[{"$f":"IF(Sheet3!H2=1,IF(Sheet3!G2>Sheet3!G43,CHAR(10),\"\")&Sheet3!C2,\"\")&IF(Sheet3!H3=1,IF(Sheet3!G3>Sheet3!G43,CHAR(10),\"\")&Sheet3!C3,\"\")&IF(Sheet3!H4=1,IF(Sheet3!G4>Sheet3!G43,CHAR(10),\"\")&Sheet3!C4,\"\")&IF(Sheet3!H5=1,IF(Sheet3!G5>Sheet3!G43,CHAR(10),\"\")&Sheet3!C5,\"\")&IF(Sheet3!H6=1,IF(Sheet3!G6>Sheet3!G43,CHAR(10),\"\")&Sheet3!C6,\"\")&IF(Sheet3!H7=1,IF(Sheet3!G7>Sheet3!G43,CHAR(10),\"\")&Sheet3!C7,\"\")&IF(Sheet3!H8=1,IF(Sheet3!G8>Sheet3!G43,CHAR(10),\"\")&Sheet3!C8,\"\")&IF(Sheet3!H9=1,IF(Sheet3!G9>Sheet3!G43,CHAR(10),\"\")&Sheet3!C9,\"\")&IF(Sheet3!H10=1,IF(Sheet3!G10>Sheet3!G43,CHAR(10),\"\")&Sheet3!C10,\"\")&IF(Sheet3!H11=1,IF(Sheet3!G11>Sheet3!G43,CHAR(10),\"\")&Sheet3!C11,\"\")&IF(Sheet3!H12=1,IF(Sheet3!G12>Sheet3!G43,CHAR(10),\"\")&Sheet3!C12,\"\")&IF(Sheet3!H13=1,IF(Sheet3!G13>Sheet3!G43,CHAR(10),\"\")&Sheet3!C13,\"\")&IF(Sheet3!H14=1,IF(Sheet3!G14>Sheet3!G43,CHAR(10),\"\")&Sheet3!C14,\"\")&IF(Sheet3!H15=1,IF(Sheet3!G15>Sheet3!G43,CHAR(10),\"\")&Sheet3!C15,\"\")&IF(Sheet3!H16=1,IF(Sheet3!G16>Sheet3!G43,CHAR(10),\"\")&Sheet3!C16,\"\")&IF(Sheet3!H17=1,IF(Sheet3!G17>Sheet3!G43,CHAR(10),\"\")&Sheet3!C17,\"\")&IF(Sheet3!H18=1,IF(Sheet3!G18>Sheet3!G43,CHAR(10),\"\")&Sheet3!C18,\"\")&IF(Sheet3!H19=1,IF(Sheet3!G19>Sheet3!G43,CHAR(10),\"\")&Sheet3!C19,\"\")&IF(Sheet3!H20=1,IF(Sheet3!G20>Sheet3!G43,CHAR(10),\"\")&Sheet3!C20,\"\")&IF(Sheet3!H21=1,IF(Sheet3!G21>Sheet3!G43,CHAR(10),\"\")&Sheet3!C21,\"\")&IF(Sheet3!H22=1,IF(Sheet3!G22>Sheet3!G43,CHAR(10),\"\")&Sheet3!C22,\"\")&IF(Sheet3!H23=1,IF(Sheet3!G23>Sheet3!G43,CHAR(10),\"\")&Sheet3!C23,\"\")&IF(Sheet3!H24=1,IF(Sheet3!G24>Sheet3!G43,CHAR(10),\"\")&Sheet3!C24,\"\")&IF(Sheet3!H25=1,IF(Sheet3!G25>Sheet3!G43,CHAR(10),\"\")&Sheet3!C25,\"\")&IF(Sheet3!H26=1,IF(Sheet3!G26>Sheet3!G43,CHAR(10),\"\")&Sheet3!C26,\"\")&IF(Sheet3!H27=1,IF(Sheet3!G27>Sheet3!G43,CHAR(10),\"\")&Sheet3!C27,\"\")&IF(Sheet3!H28=1,IF(Sheet3!G28>Sheet3!G43,CHAR(10),\"\")&Sheet3!C28,\"\")&IF(Sheet3!H29=1,IF(Sheet3!G29>Sheet3!G43,CHAR(10),\"\")&Sheet3!C29,\"\")&IF(Sheet3!H30=1,IF(Sheet3!G30>Sheet3!G43,CHAR(10),\"\")&Sheet3!C30,\"\")&IF(Sheet3!H31=1,IF(Sheet3!G31>Sheet3!G43,CHAR(10),\"\")&Sheet3!C31,\"\")&IF(Sheet3!H32=1,IF(Sheet3!G32>Sheet3!G43,CHAR(10),\"\")&Sheet3!C32,\"\")&IF(Sheet3!H33=1,IF(Sheet3!G33>Sheet3!G43,CHAR(10),\"\")&Sheet3!C33,\"\")&IF(Sheet3!H34=1,IF(Sheet3!G34>Sheet3!G43,CHAR(10),\"\")&Sheet3!C34,\"\")&IF(Sheet3!H35=1,IF(Sheet3!G35>Sheet3!G43,CHAR(10),\"\")&Sheet3!C35,\"\")&IF(Sheet3!H36=1,IF(Sheet3!G36>Sheet3!G43,CHAR(10),\"\")&Sheet3!C36,\"\")&IF(Sheet3!H37=1,IF(Sheet3!G37>Sheet3!G43,CHAR(10),\"\")&Sheet3!C37,\"\")&IF(Sheet3!H38=1,IF(Sheet3!G38>Sheet3!G43,CHAR(10),\"\")&Sheet3!C38,\"\")&IF(Sheet3!H39=1,IF(Sheet3!G39>Sheet3!G43,CHAR(10),\"\")&Sheet3!C39,\"\")","v":"76"}]