{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Reference Sheet","Concealed Grid Estimator"],"not_rendered":{"charts":0,"images":26,"macros":1,"external_links":0,"defined_names":26,"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":"Reference Sheet","index":0,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["Stock Code "]
["38C06060"]
["N47"]
["N74"]
["4H58"]
["08PC"]
["BW"]
["BSN"]
["10M06"]
["N60"]
["N24N"]
["LPS"]
[]
["N5143"]
["N39"]
["Empty"]
["N27"]
["N28"]
["Empty"]
["N23"]
["N29"]
["N08"]
["N18"]
[]
["N21"]
["AT6"]
[]
["Enter Preferred Suspension Method "]
["08PC",null,null,null,"Purlin Clip - Designed to clip onto the flange of a Steel Purlin "]
["38C06060",null,null,null,"Trubolt Tie Wire Anchor 60mm - Used for suspending ceilings below concrete slabs."]
["BSN",null,null,null,"Bonnut - Used for suspending threaded rod from the profile in Bondeck "]
["BW",null,null,null,"Bonwedge - Used for suspending plain rod from the profile in Bondeck "]
["N47",null,null,null,"Suspension Rod Bracket 90 deg - Fixed to underside of Steel Purlin or Timber Truss"]
["N74",null,null,null,"Suspension Rod Bracket - Fixed to side of Steel Purlin or Timber Truss"]
[]
["Enter Preferred Suspension Hanger "]
[{"$f":"IF('Concealed Grid Estimator'!E14=\"BSN\",\"-\",IF('Concealed Grid Estimator'!E17=\"N28\",\"-\",\"LPS\"))","v":"LPS"},null,null,null,"Low Profile TCR to Suspension Rod SpringHanger suits N27 - Suspension Hanger in ceiling cavitys with minimal room "]
[{"$f":"IF('Concealed Grid Estimator'!E14=\"BSN\",\"N24N\",\"-\")","v":"-"},null,null,null,"Threaded Direct Fix Clip for TCR suits N27/N28 - Used for suspending TCR from threaded rod."]
[{"$f":"IF('Concealed Grid Estimator'!E14=\"BSN\",\"-\",\"N60\")","v":"N60"},null,null,null,"TCR to Suspension Rod Springhanger suits N27/N28 - General purpose suspension hanger"]
[]
["Enter TCR ",null,"Enter Preferred TCR Length "]
["N27",null,{"$f":"IF('Concealed Grid Estimator'!E17=\"N27\",3.6,\"-\")","v":3.6},null,"25mm x 0.75bmt Top Cross Rail "]
[{"$f":"IF('Concealed Grid Estimator'!K14=\"LPS\",\"-\",\"N28\")","v":"N28"},null,{"$f":"IF(OR('Concealed Grid Estimator'!E17=\"N27\",'Concealed Grid Estimator'!E17=\"N28\"),4.8,\"-\")","v":4.8},null,"38mm x 0.75bmt Heavy Top cross Rail"]
[null,null,{"$f":"IF('Concealed Grid Estimator'!E17=\"N27\",6,\"-\")","v":6}]
[]
["Enter Furring Channel "]
[null,null,"Enter Preferred Furring Channel Length "]
["N08",null,{"$f":"IF(OR('Concealed Grid Estimator'!M17=\"N29\",'Concealed Grid Estimator'!M17=\"N08\",'Concealed Grid Estimator'!M17=\"N23\"),2.7,\"-\")","v":2.7},null,"16mm Furring Channel "]
["N18",null,{"$f":"IF(OR('Concealed Grid Estimator'!M17=\"N29\",'Concealed Grid Estimator'!M17=\"N08\"),3,\"-\")","v":3},null,"16.5mm Furring Channel "]
["N23",null,{"$f":"IF(OR('Concealed Grid Estimator'!M17=\"N29\",'Concealed Grid Estimator'!M17=\"N08\",'Concealed Grid Estimator'!M17=\"N23\"),3.6,\"-\")","v":3.6},null,"23mm Furring Channel "]
["N29",null,{"$f":"IF(OR('Concealed Grid Estimator'!M17=\"N29\",'Concealed Grid Estimator'!M17=\"N08\",'Concealed Grid Estimator'!M17=\"N18\"),4.8,\"-\")","v":4.8},null,"28mm Furring Channel"]
[null,null,{"$f":"IF('Concealed Grid Estimator'!M17=\"N23\",5,\"-\")","v":"-"}]
[null,null,{"$f":"IF(OR('Concealed Grid Estimator'!M17=\"N29\",'Concealed Grid Estimator'!M17=\"N08\",'Concealed Grid Estimator'!M17=\"N18\"),6,\"-\")","v":6}]
[]
["AT6",null,null,null,"6mm Threaded Galvanised Rod "]
["N21",null,null,null,"5mm Gal Suspension Rod"]
[]
["N39",null,null,null,"TCR to Furring Channel Locking Key suits N08/N29"]
["N5143",null,null,null,"TCR to Furring Channel Locking Key suits N23/N18"]

{"sheet":"Concealed Grid Estimator","index":1,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":false,"merged":[[36,2,36,16],[39,7,40,11],[34,4,34,9],[34,13,34,14],[33,2,33,16],[8,6,8,7],[13,2,13,3],[16,2,16,3],[28,4,28,9],[27,2,27,16],[3,16,3,17],[1,10,2,17],[29,2,29,16],[13,7,13,9],[6,2,6,3],[6,10,6,11],[6,14,6,15],[8,2,8,3],[6,6,6,7],[13,13,13,14],[20,4,20,9],[22,4,22,9],[24,4,24,9],[26,4,26,9],[23,2,23,16],[25,2,25,16],[31,2,31,16],[32,4,32,9],[20,13,20,14],[22,13,22,14],[24,13,24,14],[26,13,26,14],[28,13,28,14],[30,13,30,14],[32,13,32,14],[21,2,21,16],[30,4,30,9]]}
[]
[null,null,null,null,null,null,null,null,null,null,"NASHCO CONCEALED GRID ESTIMATOR "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v0.05"]
[null,null,"Ceiling Details "]
[]
[null,null,"Enter Total Square Area (m2)",null,null,null,"Enter Number of Rooms",null,null,null,"Enter Hanger Fixing Centres (TCR Span) (m)",null,null,null,"Enter TCR Centers (Furring Chanel Span) (m)"]
[]
[null,null,"Enter Furring Channel Centres (m)",null,null,null,"Enter Average Dropper Length (m)",null,null,null,{"$f":"IF(avg_drop>4,\"! - N54 - Suspension Rod Joiners Required\",\"\")","v":""}]
[]
[]
[null,null,"Product Details"]
[]
[null,null,"Enter Preferred Suspension Method ",null,"N47",null,null,"Enter Preferred Suspension Hanger ",null,null,"N60",null,null,null,null,{"$f":"IF(E14=\"bsn\",\"AT6\", \"N21\")","v":"N21"}]
[]
[]
[null,null,"Enter TCR Type",null,"N27",null,null,"Enter Preferred TCR Length ",4.8,null,"Enter Furring Channel ",null,"N29",null,null,"Enter Preferred Furring Channel Length ",6]
[]
[null,null,"Estimation "]
[]
[null,null,"Part No. ",null,"Description ",null,null,null,null,null,"Length (m)",null,"Qty Req.","In Stock (left over from Last Job)",null,"Min. Pack Size ","No. Packs Needed "]
[]
[null,null,{"$f":"E14","v":"N47"},null,{"$f":"VLOOKUP(C23,'Reference Sheet'!A29:E34,5)","v":"Suspension Rod Bracket 90 deg - Fixed to underside of Steel Purlin or Timber Truss"},null,null,null,null,null,"-",null,{"$f":"ROUNDUP(((ROUNDUP((SQRT(Total_m2)/tcr_centres),0)+1)*(SQRT(Total_m2)))/tcr_span,0)","v":{"$error":"#DIV/0!"}},null,null,100,{"$f":"ROUNDUP((M23-N23)/P23,0)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"P14","v":"N21"},null,{"$f":"VLOOKUP(P14,'Reference Sheet'!A55:E56,5)","v":"5mm Gal Suspension Rod"},null,null,null,null,null,{"$f":"IF(C25=\"N21\",4,3)","v":4},null,{"$f":"IF(avg_drop<=K25,ROUNDUP(number_of_drops/(ROUNDDOWN(K25/avg_drop,0)),0),ROUNDUP((number_of_drops/(ROUNDDOWN(K25/(avg_drop-K25),0))+(number_of_drops*1)),0))","v":{"$error":"#DIV/0!"}},null,null,40,{"$f":"ROUNDUP(M25/P25,0)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"K14","v":"N60"},null,{"$f":"VLOOKUP(C27,'Reference Sheet'!A37:E39,5,)","v":"TCR to Suspension Rod Springhanger suits N27/N28 - General purpose suspension hanger"},null,null,null,null,null,"-",null,{"$f":"ROUNDUP(((ROUNDUP((SQRT(Total_m2)/tcr_centres),0)+1)*(SQRT(Total_m2)))/tcr_span,0)","v":{"$error":"#DIV/0!"}},null,null,100,{"$f":"ROUNDUP(M27/P27,0)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"E17","v":"N27"},null,{"$f":"VLOOKUP(C29,'Reference Sheet'!A42:E43,5)","v":"25mm x 0.75bmt Top Cross Rail "},null,null,null,null,null,{"$f":"Enter_Preferred_TCR_Length","v":4.8},null,{"$f":"ROUNDUP(((ROUNDUP((SQRT(Total_m2))/tcr_centres,0)+1)*(SQRT(Total_m2))/Enter_Preferred_TCR_Length),0)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(C29=\"N28\",5,10)","v":10},{"$f":"ROUNDUP(M29/P29,0)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"IF(OR(M17=\"N29\",M17=\"N08\"),\"N39\",IF(OR(M17=\"N23\",M17=\"N18\"),\"N5143\",\"Enter Furring Channel Type\"))","v":"N39"},null,{"$f":"VLOOKUP(C31,'Reference Sheet'!A58:E59,5)","v":"TCR to Furring Channel Locking Key suits N08/N29"},null,null,null,null,null,"-",null,{"$f":"ROUNDUP((ROUNDUP((SQRT(Total_m2)/furring_channel_centres),0)+1)*(SQRT(Total_m2))/tcr_centres,0)","v":{"$error":"#DIV/0!"}},null,null,100,{"$f":"ROUNDUP(M31/P31,0)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"M17","v":"N29"},null,{"$f":"VLOOKUP(C33,'Reference Sheet'!A48:E51,5)","v":"28mm Furring Channel"},null,null,null,null,null,{"$f":"Enter_Preferred_Furring_Channel_Length","v":6},null,{"$f":"ROUNDUP((ROUNDUP((SQRT(Total_m2)/furring_channel_centres),0))*(SQRT(Total_m2))/Enter_Preferred_Furring_Channel_Length,0)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(OR(C33=\"N23\",C33=\"N18\"),12,8)","v":8},{"$f":"ROUNDUP(M33/P33,0)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"IF(M17=\"N29\",\"N40\",IF(OR(M17=\"N08\",M17=\"N18\"),\"N42\",\"N41\"))","v":"N40"},null,{"$f":"IF(C35=\"N40\",\"28mm Wall Track\",IF(C35=\"N42\",\"16mm Wall Track\",\"23mm Wall Track\"))","v":"28mm Wall Track"},null,null,null,null,null,{"$f":"IF(C35=\"N40\",\"3\",IF(C35=\"N42\",\"3\",\"3.6\"))","v":"3"},null,{"$f":"ROUNDUP(((SQRT((Total_m2/No_rooms))*4)*No_rooms)/K35,0)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(OR(C35=\"N40\",C35=\"N41\"),10,20)","v":10},{"$f":"ROUNDUP(M35/P35,0)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,"NASHCO",null,null,null,null,null,null,null,null,null,null,null,null,"sales@nashco.com.au"]
[null,null,"28 Carrington Street Queanbyean, NSW, 2620",null,null,null,null,"www.nashco.com.au"]
[null,null,"P 02 6124 3400  |  F 02 6124 3400"]
[null,null,"E sales@nashco.com.au "]