{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Arc Worksheet","Drop Table"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"Arc Worksheet","index":0,"n_rows":111,"n_cols":26,"rows_kept":111,"cut":false,"hidden":false,"merged":[[100,2,101,25],[99,2,99,25],[33,23,35,24],[43,23,45,24],[92,2,94,21],[36,18,36,21],[37,18,40,21],[43,3,43,6],[43,8,43,11],[43,18,43,21],[56,13,56,16],[55,18,55,21],[55,3,55,6],[55,8,55,11],[55,13,55,16],[56,3,56,6],[56,8,56,11],[47,3,47,6],[47,8,47,11],[47,13,47,16],[47,18,50,21],[44,3,44,6],[44,8,44,11],[44,13,44,16],[26,18,26,21],[27,18,30,21],[36,13,36,16],[37,13,37,16],[33,3,33,6],[33,8,33,11],[33,13,33,16],[33,18,33,21],[34,3,34,6],[34,8,34,11],[34,13,34,16],[34,18,34,21],[37,3,37,6],[37,8,37,11],[36,3,36,6],[36,8,36,11],[27,3,27,6],[27,13,27,16],[27,8,27,11],[43,13,43,16],[44,18,44,21],[46,3,46,6],[46,8,46,11],[46,13,46,16],[46,18,46,21],[59,3,60,21],[62,3,62,6],[62,8,62,11],[68,13,73,21],[73,8,73,11],[74,8,74,11],[65,3,65,6],[66,3,66,6],[68,8,68,11],[69,8,69,11],[68,3,68,6],[69,3,69,6],[71,3,71,6],[72,3,72,6],[74,3,74,6],[2,1,2,26],[24,3,24,6],[23,3,23,6],[24,13,24,16],[23,13,23,16],[4,2,5,25],[7,3,7,6],[8,3,8,6],[7,8,7,11],[8,8,8,11],[8,13,8,16],[7,13,7,16],[8,18,8,21],[10,18,10,21],[24,8,24,11],[23,8,23,11],[7,18,7,21],[9,3,9,4],[9,5,9,6],[10,3,10,4],[10,5,10,6],[9,8,9,11],[102,2,102,26],[107,2,107,26],[96,2,96,26],[10,8,10,11],[9,13,9,16],[10,13,10,16],[9,18,9,21],[13,3,17,21],[12,3,12,21],[23,18,23,21],[24,18,24,21],[26,3,26,6],[22,2,22,25],[26,13,26,16],[26,8,26,11],[23,23,25,24],[75,3,75,6],[77,3,78,21],[63,3,63,6],[63,8,63,11],[63,13,66,21],[65,8,65,11],[66,8,66,11],[62,13,62,21]]}
[]
[]
[null,"Mirror Arc Worksheet"]
[]
[null,null,"Project Information"]
[]
[]
[null,null,null,"Architect/ Designer",null,null,null,null,"Project Name",null,null,null,null,"Email ",null,null,null,null,"Phone"]
[]
[null,null,null,"Country",null,"State/Province",null,null,"Location Details",null,null,null,null,"Sloan Representative",null,null,null,null,"Cloud for Sales ID#"]
[]
[]
[null,null,null," Description of Purchase Phases and Expected Timing"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Mirror Information"]
[null,null,null,"Mirror 1 Quantity",null,null,null,null,"Mirror Type",null,null,null,null,"Mirror Size Inches (Width) ",null,null,null,null,"Mirror Size Inches (Height)",null,null,null,null,"Width x Height can not exceed 2,500 "]
[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,{"$f":"N25*S25","v":0}]
[]
[null,null,null,"BAA/BABAA Required?",null,null,null,null,"Mirror Design",null,null,null,null,"Frame Mirror Finish ",null,null,null,null,"Custom Design?  Specify Details "]
[]
[]
[]
[]
[]
[]
[null,null,null,"Mirror 2 Quantity ",null,null,null,null,"Mirror Type",null,null,null,null,"Mirror Size (Width) ",null,null,null,null,"Mirror Size (Height)",null,null,null,null,"The combined size WxH can not exceed 2,500"]
[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,{"$f":"N35*S35","v":0}]
[]
[null,null,null,"BAA/BABAA Required?",null,null,null,null,"Mirror Design",null,null,null,null,"Frame Mirror Finish ",null,null,null,null,"Custom Aesthetic?  Specify (If Applicable)"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Mirror 3 Quantity",null,null,null,null,"Mirror Type",null,null,null,null,"Mirror Size (Width) ",null,null,null,null,"Mirror Size (Height)",null,null,null,null,"The combined size WxH can not exceed 2,500"]
[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,{"$f":"N45*S45","v":0}]
[]
[null,null,null,"BAA/BABAA Required?",null,null,null,null,"Mirror Design",null,null,null,null,"Frame Mirror Finish ",null,null,null,null,"Custom Aesthetic?  Specify (If Applicable)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Approval Name",null,null,null,null,"Approvers Title",null,null,null,null,"Date (mm/dd/yyyy)"]
[]
[]
[]
[null,null,null,"Internal Use Only"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V25.02.21-1"]
[null,null,null,"Internal Sloan Representative",null,null,null,null,"Compliance Notes",null,null,null,null,"Additional Notes:"]
[]
[]
[null,null,null,"Quote Expiration ",null,null,null,null,"Quote Number"]
[]
[]
[null,null,null,"List Price Per Mirror 1"]
[]
[]
[null,null,null,"List Price Per Mirror 2"]
[]
[]
[null,null,null,"List Price Per Mirror 3"]
[]
[]
[null,null,null,"Lead Time Starts upon Sloan's receipt of order          Changes to Order after sign-off may impact price and/or lead time"]
[]
[]
[]
[]
[null,null,"Note:"]
[null,null,"This quote is applicable to the request that accompanied it. Any changes may result in price and lead time changes and requires a new quote. "]
[null,null,"After order has been placed any changes may result in extension of the lead time and/or fees up to the full price of the product. "]
[]
[null,null,"Cancellation and Return Policy:"]
[null,null,"In the event of an order cancellation the following items may apply:"]
[null,null,"-If the  order is cancelled more than 5 working days from order placement it will result in a minimum of a 25% fee, up to the full price of that product. "]
[null,null,"-If the order is 5 working days or less from scheduled shipment any cancelations result in the full price of the sink. "]
[]
[null,null,"Signed Document Submittal:"]
[null,null,"Sloan requires a signed architectural worksheet or signed drawing (if applicable) to be able to place an order. If an order is placed without these documents submitted to Sloan it will result in an order hold that will extend any previously agreed upon lead time commitments. Once the documents are received the order will be reinstated and an updated ship date will be provided."]
[]
[]
[null,null,"Claim Process: "]
[null,null,"For all Sloan mirrors if you receive a damaged mirror or suspect damage (crate broken, etc.). Send the below information to designermirrors@sloan.com within 1 week of receipt of mirrors to be considered for a full credit replacement mirror. Incomplete claims and/or late claims  will not be eligible for full credit replacement mirrors."]
[]
[null,null,"Information to be provided:"]
[null,null,"1.    Upon notification of a cargo claim, Sloan and our manufacture’s reps should instruct the notifying party that they must keep all original packaging, including cartons and contents, until the claim resolution process is completed. It may be necessary to make the packaging / contents available for inspection by the carrier’s representative. Keep merchandise and all packaging materials. "]
[null,null,"NOTE: It is imperative that the receiver keep the merchandise segregated and available for inspection until the claim is settled. If the claim is for full replacement value, and the claim is successfully paid, the carrier has the right to the cargo and may elect to collect it for sale or salvage to recoup a portion of their costs. "]
[]
[null,null,"2.    Explanation of what we are filing a claim for (i.e. damage, lost, shortage), against whom we should file, and the value of the claim being filed. For a  damage claim, provide as much detail as possible specifically describing the damage to the product."]
[null,null,"3.    Account Number"]
[null,null,"4.    Customer Name, Customer Contact Name, Customer Address, Customer Phone Number"]
[null,null,"5.    Signed copy of carrier bill of lading, or delivery receipt from recipient (copy should be signed by receiver noting that the cargo was short or damaged when delivered) and photos. "]
[null,null,"6.    Sloan Delivery Number and/or Sales Order Number"]
[null,null,"7.    Copies of all documentation related to proof of claim value. This can be a copy of original invoice from vendor or supplier, copy of retail invoice or receipt, final confirmation screen if online order with proof of payment, itemized repair invoice or statement of non-repair, appraisals, expense statement, or any other applicable documentation."]
[null,null,"8.    Copy of any inspection form that may have been completed noting damage and cost of repair."]
[null,null,"9.    Copies of any photos showing damage. "]
[null,null,"If you have a shortage, please contact Sloan’s customer service. Please have ready your order number and the item name and quantity that you are missing. "]

{"sheet":"Drop Table","index":1,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Frame Type","LED Type","Certifications","Finish","Rep Groups","Country","CA State List","US State List","Other State List"]
["Thin Frame","4 Edge","BAA","Graphite","BADGERLAND TRADING OF WISCONSIN INC","United States","Alberta","Alabama","Enter in Location Details Box"]
["Angle Frame","4 Inset","BABAA","Polished Chrome","BBN SALES INC","Canada","British Columbia","Alaska",null,null,null,null,"Indirects: "]
["Wide Frame","2 Edge",null,"Brushed Nickel","BILLINGSLEY BWC","Other","Manitoba","Arkansas",null,null,null,null,"Frame Type 1",{"$f":"IF('Arc Worksheet'!I25=\"LED\",\"LED\",\"Frame\")","v":"Frame"}]
[null,"2 Inset",null,null,"BONGARD",null,"New Brunswick","Arizona",null,null,null,null,"Frame Type 2",{"$f":"IF('Arc Worksheet'!I35=\"LED\",\"LED\",\"Frame\")","v":"Frame"}]
[null,"Back Lit",null,null,"BRALEY-GRAY & ASSOCIATES-AK",null,"Newfoundland & Labrador","California",null,null,null,null,"Frame Type 3",{"$f":"IF('Arc Worksheet'!I45=\"LED\",\"LED\",\"Frame\")","v":"Frame"}]
[null,null,null,null,"BRALEY-GRAY & ASSOCIATES-OR",null,"Northwest Territories","Colorado",null,null,null,null,"Frame Finish 1",{"$f":"IF('Arc Worksheet'!I25=\"Frame\",\"Frame_Finish\", \"N/A\")","v":"N/A"}]
[null,null,null,null,"BRALEY-GRAY & ASSOCIATES-WA",null,"Nova Scotia","Connecticut",null,null,null,null,"Frame Finish 2",{"$f":"IF('Arc Worksheet'!I35=\"Frame\",\"Frame_Finish\", \"N/A\")","v":"N/A"}]
[null,null,null,null,"BURNS COPE",null,"Nunavut","Delaware",null,null,null,null,"Frame Finish 3",{"$f":"IF('Arc Worksheet'!I45=\"Frame\",\"Frame_Finish\", \"N/A\")","v":"N/A"}]
[null,null,null,null,"C A RINER CO INC",null,"Ontario","Florida",null,null,null,null,"State List",{"$f":"IF('Arc Worksheet'!D11=\"United States\",\"US\",IF('Arc Worksheet'!D11=\"Canada\",\"Canada\",\"Other\"))","v":"Other"}]
[null,null,null,null,"DELCO SALES-CA",null,"Prince Edward Island","Georgia"]
[null,null,null,null,"DELCO SALES-HI",null,"Quebec","Hawaii"]
[null,null,null,null,"DILLARD ASSOCIATES-Dallas",null,"Saskatchewan","Idaho"]
[null,null,null,null,"DILLARD ASSOCIATES-San Antonio",null,"Yukon","Illinois"]
[null,null,null,null,"DIVERSIFIED SPEC SALES INC",null,null,"Indiana"]
[null,null,null,null,"EDWARDS PLATT & DEELY INC",null,null,"Iowa"]
[null,null,null,null,"ENGINEERED CONCEPTS",null,null,"Kansas"]
[null,null,null,null,"HEBCO",null,null,"Kentucky"]
[null,null,null,null,"HYDRO SPEC",null,null,"Louisiana"]
[null,null,null,null,"J B O'CONNOR CO INC",null,null,"Maine"]
[null,null,null,null,"J H POKORNY ASSOC, LLC",null,null,"Maryland"]
[null,null,null,null,"JOYCE AGENCY INC ",null,null,"Massachusetts"]
[null,null,null,null,"JOYCE AGENCY INC -S. VA",null,null,"Michigan"]
[null,null,null,null,"KLIMAN SALES INC",null,null,"Minnesota"]
[null,null,null,null,"M & M SALES",null,null,"Mississippi"]
[null,null,null,null,"M R ASSOCIATES",null,null,"Missouri"]
[null,null,null,null,"MALONEY & CURCIO INC.",null,null,"Montana"]
[null,null,null,null,"MARSHALL-RODENO ASSOCIATES",null,null,"Nebraska"]
[null,null,null,null,"MIDWEST SPEC",null,null,"Nevada"]
[null,null,null,null,"PANNELL ASSOCIATES SALES INC",null,null,"New Hampshire"]
[null,null,null,null,"P-M ASSOCIATES",null,null,"New Jersey"]
[null,null,null,null,"R E FITZPATRICK",null,null,"New Mexico"]
[null,null,null,null,"REPCO INC",null,null,"New York"]
[null,null,null,null,"REPCO SOUTH",null,null,"North Carolina"]
[null,null,null,null,"SERVICE REPS INC -Iowa",null,null,"North Dakota"]
[null,null,null,null,"SERVICE REPS INC -Nebraska",null,null,"Ohio"]
[null,null,null,null,"SMITH & STEVENSON",null,null,"Oklahoma"]
[null,null,null,null,"SOUTHERN SPEC",null,null,"Oregon"]
[null,null,null,null,"SOUTHWESTERN MECH -AZ",null,null,"Pennsylvania"]
[null,null,null,null,"SOUTHWESTERN MECH-Las Vegas",null,null,"Rhode Island"]
[null,null,null,null,"TRI REPS",null,null,"South Carolina"]
[null,null,null,null,"VEMCO",null,null,"South Dakota"]
[null,null,null,null,"WILL & PIERCE AGENCY INC",null,null,"Tennessee"]
[null,null,null,null,"WMS SALES INC",null,null,"Texas"]
[null,null,null,null,"YOST ASSOCIATES",null,null,"Utah"]
[null,null,null,null,"R.G. DOBBIN",null,null,"Vermont"]
[null,null,null,null,null,null,null,"Virginia"]
[null,null,null,null,null,null,null,"Washington"]
[null,null,null,null,null,null,null,"West Virginia"]
[null,null,null,null,null,null,null,"Wisconsin"]
[null,null,null,null,null,null,null,"Wyoming"]