{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["CTS Metaline Order Form","Sheet2"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"CTS Metaline Order Form","index":0,"n_rows":51,"n_cols":28,"rows_kept":51,"cut":false,"hidden":false,"merged":[[12,1,12,3],[12,14,12,20],[9,1,9,4],[44,2,44,3],[9,5,9,10],[9,11,9,13],[9,14,9,17],[37,17,37,18],[38,16,38,18],[40,16,40,18],[32,19,32,16383],[45,2,45,3],[49,2,49,16],[14,5,14,8],[14,10,14,13],[46,15,46,20],[43,2,43,3],[34,16,34,18],[35,16,35,18],[36,16,36,18],[2,20,2,21],[3,20,3,21],[5,16,5,20],[7,8,7,9],[0,15,0,16],[2,8,2,9],[3,16,3,17],[2,1,2,2],[3,1,3,2],[3,3,3,9],[4,1,4,2],[4,3,4,5],[4,6,4,7],[4,8,4,9],[2,3,2,5],[2,6,2,7],[5,1,5,2],[5,3,5,9],[6,1,6,2],[6,3,6,9],[7,1,7,2],[7,3,7,6]]}
[]
[]
[null,"Contact Name:**",{"$nulls":4},"Your Ref /Order #:",{"$nulls":12},"Phone:","03 5337 3633"]
[null,"Company Name:**",{"$nulls":18},"03 5337 3688 "]
[null,"Account Number:**",{"$nulls":4},"Phone Number **"]
[null,"Email:** ",{"$nulls":13},"EMAIL ORDER TO: ","CutToSize@laminex.com.au "]
[null,"Delivery Address:**"]
[{"$nulls":7},"Date:**"]
[]
[null,"MATERIAL**",null,null,null,"4mm METALINE",{"$nulls":5},"COLOUR**"]
[]
[{"$nulls":14},"SPECIAL REQUIREMENTS"]
[null,"Metaline Profiles",null,null,"V-Groove = VGR",null,null,"Square\nEdge = SQR"]
[]
[{"$nulls":5},"Edging Profile",{"$nulls":4},"Fabrication Processes"]
[null,"Line","Qty","Height mm","Width mm","Left","Right","Top","Bot",null,"V Grooved\nLineal Metres","Qty \nPOWER POINT Cut-Outs",null,"Qty Pattern \nSet ups","PANEL SHAPE","COMMENTS","Laminex\nASW code","Total M2","$M2","Each","  Line Total*","Line Total\nWith Disc.",null,null,"Left","Right","Top Bottom","Right"]
[null,1,{"$nulls":8},{"$f":"IF(C17=\"\",\"\",SUM(Y17:AB17))","v":""},{"$nulls":5},{"$f":"IF(C17=\"\",\"\",968582)","v":""},{"$f":"IF(C17=\"\",\"\",C17*D17*E17/1000000)","v":""},{"$f":"IF(C17=\"\",\"\",Sheet2!$C$1)","v":""},{"$f":"IF(C17=\"\",\"\",R17/C17*S17)","v":""},{"$f":"IF(C17=\"\",\"\",C17*T17)","v":""},{"$f":"IF(C17=\"\",\"\",U17*(1-$T$33))","v":""},null,null,{"$f":"IF(F17=\"VGR\",(D17/1000)*C17,0)","v":0},{"$f":"IF(G17=\"VGR\",(D17/1000)*C17,0)","v":0},{"$f":"IF(H17=\"VGR\",(E17/1000)*C17,0)","v":0},{"$f":"IF(I17=\"VGR\",(E17/1000)*C17,0)","v":0}]
[null,2,{"$nulls":8},{"$f":"IF(C18=\"\",\"\",SUM(Y18:AB18))","v":""},{"$nulls":5},{"$f":"IF(C18=\"\",\"\",968582)","v":""},{"$f":"IF(C18=\"\",\"\",C18*D18*E18/1000000)","v":""},{"$f":"IF(C18=\"\",\"\",Sheet2!$C$1)","v":""},{"$f":"IF(C18=\"\",\"\",R18/C18*S18)","v":""},{"$f":"IF(C18=\"\",\"\",C18*T18)","v":""},"",null,null,{"$f":"IF(F18=\"VGR\",(D18/1000)*C18,0)","v":0},{"$f":"IF(G18=\"VGR\",(D18/1000)*C18,0)","v":0},{"$f":"IF(H18=\"VGR\",(E18/1000)*C18,0)","v":0},{"$f":"IF(I18=\"VGR\",(E18/1000)*C18,0)","v":0}]
[null,3,{"$nulls":8},"",{"$nulls":5},"","",{"$f":"IF(C19=\"\",\"\",Sheet2!$C$1)","v":""},"","","",null,null,0,0,0,0]
[null,4,{"$nulls":8},"",{"$nulls":5},"","",{"$f":"IF(C20=\"\",\"\",Sheet2!$C$1)","v":""},"","","",null,null,0,0,0,0]
[null,5,{"$nulls":8},"",{"$nulls":5},"","",{"$f":"IF(C21=\"\",\"\",Sheet2!$C$1)","v":""},"","","",null,null,0,0,0,0]
[null,6,{"$nulls":8},"",{"$nulls":5},"","",{"$f":"IF(C22=\"\",\"\",Sheet2!$C$1)","v":""},"","","",null,null,0,0,0,0]
[null,7,{"$nulls":8},"",{"$nulls":5},"","",{"$f":"IF(C23=\"\",\"\",Sheet2!$C$1)","v":""},"","","",null,null,0,0,0,0]
[null,8,{"$nulls":8},"",{"$nulls":5},"","",{"$f":"IF(C24=\"\",\"\",Sheet2!$C$1)","v":""},"","","",null,null,0,0,0,0]
[null,9,{"$nulls":8},"",{"$nulls":5},"","",{"$f":"IF(C25=\"\",\"\",Sheet2!$C$1)","v":""},"","","",null,null,0,0,0,0]
[null,10,{"$nulls":8},"",{"$nulls":5},"","",{"$f":"IF(C26=\"\",\"\",Sheet2!$C$1)","v":""},"","","",null,null,0,0,0,0]
[null,11,{"$nulls":8},"",{"$nulls":5},"","",{"$f":"IF(C27=\"\",\"\",Sheet2!$C$1)","v":""},"","","",null,null,0,0,0,0]
[null,12,{"$nulls":8},"",{"$nulls":5},"","",{"$f":"IF(C28=\"\",\"\",Sheet2!$C$1)","v":""},"","","",null,null,0,0,0,0]
[null,13,{"$nulls":8},"",{"$nulls":5},"","",{"$f":"IF(C29=\"\",\"\",Sheet2!$C$1)","v":""},"","","",null,null,0,0,0,0]
[null,14,{"$nulls":8},"",{"$nulls":5},"","",{"$f":"IF(C30=\"\",\"\",Sheet2!$C$1)","v":""},"","","",null,null,0,0,0,0]
[null,15,{"$nulls":8},"",{"$nulls":5},"","",{"$f":"IF(C31=\"\",\"\",Sheet2!$C$1)","v":""},"","","",null,null,0,0,0,0]
[null,null,{"$f":"SUM(C17:C31)","v":0},"TOTAL PANELS",{"$nulls":6},{"$f":"SUM(K17:K31)","v":0},{"$f":"SUM(L17:L31)","v":0},{"$f":"SUM(M17:M31)","v":0},{"$f":"SUM(N17:N31)","v":0},null,null,"TOTAL M2:",{"$f":"SUM(R17:R31)","v":0},null,"BOARD TOTAL:",{"$f":"SUM(U17:U31)","v":0},{"$f":"SUM(V17:V31)","v":0}]
[{"$nulls":18},"DISCOUNT % "]
[{"$nulls":15},"FABRICATION CHARGES"]
[{"$nulls":15},"Qty","Process",null,null,"LMX Code","Each","Price"]
[{"$nulls":15},{"$f":"IF(K32<0,\"\",K32)","v":0},"V-GROOVE lineal metre(LM)",null,null,969644,39,{"$f":"IF(P36=\"\",\"\",P36*U36)","v":0}]
[{"$nulls":14},{"$f":"P37","v":""},{"$f":"IF(L32<1,\"\",SUM(L17:L31))","v":""},"Power Point Cut Outs (Each)",null,null,969645,39,{"$f":"IF(P37=\"\",\"\",P37*U37)","v":""}]
[{"$nulls":15},{"$f":"IF(M32<1,\"\",SUM(M17:M31))","v":""},{"$nulls":5},{"$f":"IF(P38=\"\",\"\",P38*U38)","v":""}]
[{"$nulls":15},{"$f":"IF(N32<1,\"\",SUM(N17:N31))","v":""},"Pattern Set Up Costs",null,null,973130,41.2,{"$f":"IF(P39=\"\",\"\",P39*U39)","v":""}]
[5]
[{"$nulls":15},1,"Laminex Logistics / Delivery",null,null,null,31.5,31.5]
[{"$nulls":21},{"$f":"SUM(V36:V41)","v":31.5}]
[{"$nulls":20},"PROCESS/LOGISTICS TOTAL:",{"$f":"SUM(V36:V41)","v":31.5}]
[]
[{"$nulls":20},"OVERALL TOTAL (excl.GST):",{"$f":"V32+V43","v":31.5}]
[]
[{"$nulls":15},"QUOTES VALID for 60 days, changes to order attributes will change pricing accordingly. "]
[]
[]
[]
[null,null," "]

{"sheet":"Sheet2","index":1,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Splbk Met 4 Glo ArgPer 3600x15","Argente Perle",713,null,"Southern region branches",null,"VGR","Square",1,"Square"]
["Splbk Met 4 Glo AutPer 3600x15","Autumn Perle",713,null,"Melbourne Airport",null,"SQR","1mm",2,"Rectangle"]
["Splbk Met 4 Glo BlaIce 3600x15","Black Ice",713,null,"Ballarat ",null,null,"2mm",3,"Round"]
["Splbk Met 4 Glo DiaIce 3600x15","Diamond Ice",713,null,"Hobart ",null,null,"3mm",4,"Custom Shape"]
["SplbkMet 4 Glo Icicl Met 36x15","Icicle Metallic",713,null,"Launceston",null,null,"5mm",5,"Other.."]
["Splbk Met 4 Glo NimMet 3600x15","Nimbus Metallic",713,null,"Shepparton",null,null,"10mm"]
["Splbk Met 4 Glo PalPer 3600x15","Palladium Perle",713,null,"Traralgon"]
["Splbk Met 4 Glo SiStP 3600x15","Silver Stream Perle",713,null,"Wodonga"]
["Splbk Met 4 Glo SmSiP 3600x15","Smoked Silver Perle",713,null,"Wagga Wagga"]
["SplbkMet 4 Glo TBC 36x15","TBC",713,null,"Adelaide (Currie ST)"]
[{"$nulls":4},"Adelaide (Wingfield)"]