{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Product Selector","Pricing Template","Category","Products","Services"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"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":"Product Selector","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"1: Select Product Type from Menu"]
[null,"2: Select Product from Menu"]
[null,"3: Go To Pricing Template and continue"]
["Product Category (1)","Product Description (2)"]
[null,null,{"$f":"_xlfn.XLOOKUP(B7,INDIRECT(\"'\"&A$7&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$7&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B8,INDIRECT(\"'\"&A$8&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$8&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B9,INDIRECT(\"'\"&A$9&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$9&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B10,INDIRECT(\"'\"&A$10&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$10&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B11,INDIRECT(\"'\"&A$11&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$11&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B12,INDIRECT(\"'\"&A$12&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$12&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B13,INDIRECT(\"'\"&A$13&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$13&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B14,INDIRECT(\"'\"&A$14&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$14&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B15,INDIRECT(\"'\"&A$15&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$15&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B16,INDIRECT(\"'\"&A$16&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$16&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B17,INDIRECT(\"'\"&A$17&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$17&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B18,INDIRECT(\"'\"&A$18&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$18&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B19,INDIRECT(\"'\"&A$19&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$19&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B20,INDIRECT(\"'\"&A$20&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$20&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B21,INDIRECT(\"'\"&A$21&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$21&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B22,INDIRECT(\"'\"&A$22&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$22&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B23,INDIRECT(\"'\"&A$23&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$23&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B24,INDIRECT(\"'\"&A$24&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$24&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"_xlfn.XLOOKUP(B25,INDIRECT(\"'\"&A$25&\"'!\"&\"C6:C150\"),INDIRECT(\"'\"&A$25&\"'!\"&\"B6:B150\"))","v":{"$error":"#REF!"}}]

{"sheet":"Pricing Template","index":1,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Customer Name",null,null,null,null,"Partner Discount",0.3]
[null,"Customer Address 1"]
[null,"Customer Address 2"]
[]
[null,"Product code","Quantity","Description","Unit Price","Total Price","Partner\nDiscount","Total \nPartner Price"]
[null,{"$f":"IFERROR('Product Selector'!C7,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B7,Services!B1:D310,2,0),\nIFERROR(VLOOKUP(B7,Products!B1:D414,2,FALSE),\" - -\"))","v":" - -"},{"$f":"IFERROR(VLOOKUP(B7,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B7,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "},{"$f":"IFERROR(E7*C7,\"- \")","v":"- "},{"$f":"IF(B7=\"1700-9101\",\"20 %\",\nIF(B7=\"1700-9001\",\"20 %\",\nIF(B7=\"1600-0151\",\"20 %\",\nIF(B7=\"1600-0152\",\"20 %\",\nIF(B7=\"1600-0153\",\"20 %\",\nIF(B7=\"1600-0251\",\"20 %\",\nIF(B7=\"1600-0252\",\"20 %\",\nIF(B7=\"1600-0253\",\"20 %\",\nIF(B7=\"1600-0501\",\"20 %\",\nIF(B7=\"1600-0502\",\"20 %\",\nIF(B7=\"1600-0503\",\"20 %\",\nIF(B7=\"1600-0101\",\"20 %\",\nIF(B7=\"1600-0102\",\"20 %\",\nIF(B7=\"1600-0103\",\"20 %\",\nIF(B7=\"0010-1010\",\"20 %\",\nIF(B7=\"0010-0020\",\"20 %\",\nIF(B7=\"0010-1020\",\"20 %\",\nIF(B7=\"0020-1010\",\"20 %\",\nIF(B7=\"0020-1020\",\"20 %\",\nIF(B7=\"0020-1030\",\"20 %\",\nIF(B7=\"0020-1050\",\"20 %\",\nIF(B7=\"3320-9100\",\"0 %\",\nIF(B7=\"2045-9094\",\"0 %\",\nIF(B7=\"2045-9041\",\"0 %\",\nIF(B7=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},{"$f":"IF(AND(C7>0,B7>0),E7*C7*(1-G7),\"\")","v":""}]
[null,{"$f":"IFERROR('Product Selector'!C8,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B8,Services!B1:D310,2,0),\nIFERROR(VLOOKUP(B8,Products!B1:D414,2,FALSE),\" - - \"))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B8,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B8,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "},{"$f":"IFERROR(E8*C8,\" - \")","v":" - "},{"$f":"IF(B8=\"1700-9101\",\"20 %\",\nIF(B8=\"1700-9001\",\"20 %\",\nIF(B8=\"1600-0151\",\"20 %\",\nIF(B8=\"1600-0152\",\"20 %\",\nIF(B8=\"1600-0153\",\"20 %\",\nIF(B8=\"1600-0251\",\"20 %\",\nIF(B8=\"1600-0252\",\"20 %\",\nIF(B8=\"1600-0253\",\"20 %\",\nIF(B8=\"1600-0501\",\"20 %\",\nIF(B8=\"1600-0502\",\"20 %\",\nIF(B8=\"1600-0503\",\"20 %\",\nIF(B8=\"1600-0101\",\"20 %\",\nIF(B8=\"1600-0102\",\"20 %\",\nIF(B8=\"1600-0103\",\"20 %\",\nIF(B8=\"0010-1010\",\"20 %\",\nIF(B8=\"0010-0020\",\"20 %\",\nIF(B8=\"0010-1020\",\"20 %\",\nIF(B8=\"0020-1010\",\"20 %\",\nIF(B8=\"0020-1020\",\"20 %\",\nIF(B8=\"0020-1030\",\"20 %\",\nIF(B8=\"0020-1050\",\"20 %\",\nIF(B8=\"3320-9100\",\"0 %\",\nIF(B8=\"2045-9094\",\"0 %\",\nIF(B8=\"2045-9041\",\"0 %\",\nIF(B8=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},{"$f":"IF(AND(C8>0,B8>0),E8*C8*(1-G8),\"\")","v":""}]
[null,{"$f":"IFERROR('Product Selector'!C9,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B9,Services!B1:D307,2,0),\nIFERROR(VLOOKUP(B9,Products!B1:D411,2,FALSE),\n\" - - \"))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B9,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B9,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "},{"$f":"IFERROR(E9*C9,\" - \")","v":" - "},{"$f":"IF(B9=\"1700-9101\",\"20 %\",\nIF(B9=\"1700-9001\",\"20 %\",\nIF(B9=\"1600-0151\",\"20 %\",\nIF(B9=\"1600-0152\",\"20 %\",\nIF(B9=\"1600-0153\",\"20 %\",\nIF(B9=\"1600-0251\",\"20 %\",\nIF(B9=\"1600-0252\",\"20 %\",\nIF(B9=\"1600-0253\",\"20 %\",\nIF(B9=\"1600-0501\",\"20 %\",\nIF(B9=\"1600-0502\",\"20 %\",\nIF(B9=\"1600-0503\",\"20 %\",\nIF(B9=\"1600-0101\",\"20 %\",\nIF(B9=\"1600-0102\",\"20 %\",\nIF(B9=\"1600-0103\",\"20 %\",\nIF(B9=\"0010-1010\",\"20 %\",\nIF(B9=\"0010-0020\",\"20 %\",\nIF(B9=\"0010-1020\",\"20 %\",\nIF(B9=\"0020-1010\",\"20 %\",\nIF(B9=\"0020-1020\",\"20 %\",\nIF(B9=\"0020-1030\",\"20 %\",\nIF(B9=\"0020-1050\",\"20 %\",\nIF(B9=\"3320-9100\",\"0 %\",\nIF(B9=\"2045-9094\",\"0 %\",\nIF(B9=\"2045-9041\",\"0 %\",\nIF(B9=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},""]
[null,{"$f":"IFERROR('Product Selector'!C10,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B10,Services!B1:D308,2,0),\nIFERROR(VLOOKUP(B10,Products!B1:D412,2,FALSE),\n\" - - \"))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B10,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B10,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "},{"$f":"IFERROR(E10*C10,\" - \")","v":" - "},{"$f":"IF(B10=\"1700-9101\",\"20 %\",\nIF(B10=\"1700-9001\",\"20 %\",\nIF(B10=\"1600-0151\",\"20 %\",\nIF(B10=\"1600-0152\",\"20 %\",\nIF(B10=\"1600-0153\",\"20 %\",\nIF(B10=\"1600-0251\",\"20 %\",\nIF(B10=\"1600-0252\",\"20 %\",\nIF(B10=\"1600-0253\",\"20 %\",\nIF(B10=\"1600-0501\",\"20 %\",\nIF(B10=\"1600-0502\",\"20 %\",\nIF(B10=\"1600-0503\",\"20 %\",\nIF(B10=\"1600-0101\",\"20 %\",\nIF(B10=\"1600-0102\",\"20 %\",\nIF(B10=\"1600-0103\",\"20 %\",\nIF(B10=\"0010-1010\",\"20 %\",\nIF(B10=\"0010-0020\",\"20 %\",\nIF(B10=\"0010-1020\",\"20 %\",\nIF(B10=\"0020-1010\",\"20 %\",\nIF(B10=\"0020-1020\",\"20 %\",\nIF(B10=\"0020-1030\",\"20 %\",\nIF(B10=\"0020-1050\",\"20 %\",\nIF(B10=\"3320-9100\",\"0 %\",\nIF(B10=\"2045-9094\",\"0 %\",\nIF(B10=\"2045-9041\",\"0 %\",\nIF(B10=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},""]
[null,{"$f":"IFERROR('Product Selector'!C11,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B11,Services!B1:D308,2,0),\nIFERROR(VLOOKUP(B11,Products!B1:D412,2,FALSE),\nIFERROR(VLOOKUP(B11,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B11,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B11,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B11,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B11,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B11,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B11,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B11,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "},{"$f":"IFERROR(E11*C11,\" - \")","v":" - "},{"$f":"IF(B11=\"1700-9101\",\"20 %\",\nIF(B11=\"1700-9001\",\"20 %\",\nIF(B11=\"1600-0151\",\"20 %\",\nIF(B11=\"1600-0152\",\"20 %\",\nIF(B11=\"1600-0153\",\"20 %\",\nIF(B11=\"1600-0251\",\"20 %\",\nIF(B11=\"1600-0252\",\"20 %\",\nIF(B11=\"1600-0253\",\"20 %\",\nIF(B11=\"1600-0501\",\"20 %\",\nIF(B11=\"1600-0502\",\"20 %\",\nIF(B11=\"1600-0503\",\"20 %\",\nIF(B11=\"1600-0101\",\"20 %\",\nIF(B11=\"1600-0102\",\"20 %\",\nIF(B11=\"1600-0103\",\"20 %\",\nIF(B11=\"0010-1010\",\"20 %\",\nIF(B11=\"0010-0020\",\"20 %\",\nIF(B11=\"0010-1020\",\"20 %\",\nIF(B11=\"0020-1010\",\"20 %\",\nIF(B11=\"0020-1020\",\"20 %\",\nIF(B11=\"0020-1030\",\"20 %\",\nIF(B11=\"0020-1050\",\"20 %\",\nIF(B11=\"3320-9100\",\"0 %\",\nIF(B11=\"2045-9094\",\"0 %\",\nIF(B11=\"2045-9041\",\"0 %\",\nIF(B11=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},{"$f":"IF(AND(C11>0,B11>0),E11*C11*(1-G11),\"\")","v":""}]
[null,{"$f":"IFERROR('Product Selector'!C12,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B12,Services!B1:D310,2,0),\nIFERROR(VLOOKUP(B12,Products!B1:D414,2,FALSE),\nIFERROR(VLOOKUP(B12,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B12,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B12,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B12,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B12,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B12,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B12,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B12,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "},{"$f":"IFERROR(E12*C12,\" - \")","v":" - "},{"$f":"IF(B12=\"1700-9101\",\"20 %\",\nIF(B12=\"1700-9001\",\"20 %\",\nIF(B12=\"1600-0151\",\"20 %\",\nIF(B12=\"1600-0152\",\"20 %\",\nIF(B12=\"1600-0153\",\"20 %\",\nIF(B12=\"1600-0251\",\"20 %\",\nIF(B12=\"1600-0252\",\"20 %\",\nIF(B12=\"1600-0253\",\"20 %\",\nIF(B12=\"1600-0501\",\"20 %\",\nIF(B12=\"1600-0502\",\"20 %\",\nIF(B12=\"1600-0503\",\"20 %\",\nIF(B12=\"1600-0101\",\"20 %\",\nIF(B12=\"1600-0102\",\"20 %\",\nIF(B12=\"1600-0103\",\"20 %\",\nIF(B12=\"0010-1010\",\"20 %\",\nIF(B12=\"0010-0020\",\"20 %\",\nIF(B12=\"0010-1020\",\"20 %\",\nIF(B12=\"0020-1010\",\"20 %\",\nIF(B12=\"0020-1020\",\"20 %\",\nIF(B12=\"0020-1030\",\"20 %\",\nIF(B12=\"0020-1050\",\"20 %\",\nIF(B12=\"3320-9100\",\"0 %\",\nIF(B12=\"2045-9094\",\"0 %\",\nIF(B12=\"2045-9041\",\"0 %\",\nIF(B12=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},""]
[null,{"$f":"IFERROR('Product Selector'!C13,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B13,Services!B1:D311,2,0),\nIFERROR(VLOOKUP(B13,Products!B1:D415,2,FALSE),\nIFERROR(VLOOKUP(B13,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B13,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B13,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B13,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B13,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B13,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B13,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B13,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "},{"$f":"IFERROR(E13*C13,\" -  \")","v":" -  "},{"$f":"IF(B13=\"1700-9101\",\"20 %\",\nIF(B13=\"1700-9001\",\"20 %\",\nIF(B13=\"1600-0151\",\"20 %\",\nIF(B13=\"1600-0152\",\"20 %\",\nIF(B13=\"1600-0153\",\"20 %\",\nIF(B13=\"1600-0251\",\"20 %\",\nIF(B13=\"1600-0252\",\"20 %\",\nIF(B13=\"1600-0253\",\"20 %\",\nIF(B13=\"1600-0501\",\"20 %\",\nIF(B13=\"1600-0502\",\"20 %\",\nIF(B13=\"1600-0503\",\"20 %\",\nIF(B13=\"1600-0101\",\"20 %\",\nIF(B13=\"1600-0102\",\"20 %\",\nIF(B13=\"1600-0103\",\"20 %\",\nIF(B13=\"0010-1010\",\"20 %\",\nIF(B13=\"0010-0020\",\"20 %\",\nIF(B13=\"0010-1020\",\"20 %\",\nIF(B13=\"0020-1010\",\"20 %\",\nIF(B13=\"0020-1020\",\"20 %\",\nIF(B13=\"0020-1030\",\"20 %\",\nIF(B13=\"0020-1050\",\"20 %\",\nIF(B13=\"3320-9100\",\"0 %\",\nIF(B13=\"2045-9094\",\"0 %\",\nIF(B13=\"2045-9041\",\"0 %\",\nIF(B13=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},""]
[null,{"$f":"IFERROR('Product Selector'!C14,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B14,Services!B1:D312,2,0),\nIFERROR(VLOOKUP(B14,Products!B1:D416,2,FALSE),\nIFERROR(VLOOKUP(B14,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B14,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B14,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B14,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B14,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B14,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B14,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B14,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "}," -  ",{"$f":"IF(B14=\"1700-9101\",\"20 %\",\nIF(B14=\"1700-9001\",\"20 %\",\nIF(B14=\"1600-0151\",\"20 %\",\nIF(B14=\"1600-0152\",\"20 %\",\nIF(B14=\"1600-0153\",\"20 %\",\nIF(B14=\"1600-0251\",\"20 %\",\nIF(B14=\"1600-0252\",\"20 %\",\nIF(B14=\"1600-0253\",\"20 %\",\nIF(B14=\"1600-0501\",\"20 %\",\nIF(B14=\"1600-0502\",\"20 %\",\nIF(B14=\"1600-0503\",\"20 %\",\nIF(B14=\"1600-0101\",\"20 %\",\nIF(B14=\"1600-0102\",\"20 %\",\nIF(B14=\"1600-0103\",\"20 %\",\nIF(B14=\"0010-1010\",\"20 %\",\nIF(B14=\"0010-0020\",\"20 %\",\nIF(B14=\"0010-1020\",\"20 %\",\nIF(B14=\"0020-1010\",\"20 %\",\nIF(B14=\"0020-1020\",\"20 %\",\nIF(B14=\"0020-1030\",\"20 %\",\nIF(B14=\"0020-1050\",\"20 %\",\nIF(B14=\"3320-9100\",\"0 %\",\nIF(B14=\"2045-9094\",\"0 %\",\nIF(B14=\"2045-9041\",\"0 %\",\nIF(B14=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},""]
[null,{"$f":"IFERROR('Product Selector'!C15,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B15,Services!B1:D313,2,0),\nIFERROR(VLOOKUP(B15,Products!B1:D417,2,FALSE),\nIFERROR(VLOOKUP(B15,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B15,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B15,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B15,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B15,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B15,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B15,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B15,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "}," -  ",{"$f":"IF(B15=\"1700-9101\",\"20 %\",\nIF(B15=\"1700-9001\",\"20 %\",\nIF(B15=\"1600-0151\",\"20 %\",\nIF(B15=\"1600-0152\",\"20 %\",\nIF(B15=\"1600-0153\",\"20 %\",\nIF(B15=\"1600-0251\",\"20 %\",\nIF(B15=\"1600-0252\",\"20 %\",\nIF(B15=\"1600-0253\",\"20 %\",\nIF(B15=\"1600-0501\",\"20 %\",\nIF(B15=\"1600-0502\",\"20 %\",\nIF(B15=\"1600-0503\",\"20 %\",\nIF(B15=\"1600-0101\",\"20 %\",\nIF(B15=\"1600-0102\",\"20 %\",\nIF(B15=\"1600-0103\",\"20 %\",\nIF(B15=\"0010-1010\",\"20 %\",\nIF(B15=\"0010-0020\",\"20 %\",\nIF(B15=\"0010-1020\",\"20 %\",\nIF(B15=\"0020-1010\",\"20 %\",\nIF(B15=\"0020-1020\",\"20 %\",\nIF(B15=\"0020-1030\",\"20 %\",\nIF(B15=\"0020-1050\",\"20 %\",\nIF(B15=\"3320-9100\",\"0 %\",\nIF(B15=\"2045-9094\",\"0 %\",\nIF(B15=\"2045-9041\",\"0 %\",\nIF(B15=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},{"$f":"IF(AND(C15>0,B15>0),E15*C15*(1-G15),\"\")","v":""}]
[null,{"$f":"IFERROR('Product Selector'!C16,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B16,Services!B1:D314,2,0),\nIFERROR(VLOOKUP(B16,Products!B1:D418,2,FALSE),\" - - \"))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B16,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B16,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "}," -  ",{"$f":"IF(B16=\"1700-9101\",\"20 %\",\nIF(B16=\"1700-9001\",\"20 %\",\nIF(B16=\"1600-0151\",\"20 %\",\nIF(B16=\"1600-0152\",\"20 %\",\nIF(B16=\"1600-0153\",\"20 %\",\nIF(B16=\"1600-0251\",\"20 %\",\nIF(B16=\"1600-0252\",\"20 %\",\nIF(B16=\"1600-0253\",\"20 %\",\nIF(B16=\"1600-0501\",\"20 %\",\nIF(B16=\"1600-0502\",\"20 %\",\nIF(B16=\"1600-0503\",\"20 %\",\nIF(B16=\"1600-0101\",\"20 %\",\nIF(B16=\"1600-0102\",\"20 %\",\nIF(B16=\"1600-0103\",\"20 %\",\nIF(B16=\"0010-1010\",\"20 %\",\nIF(B16=\"0010-0020\",\"20 %\",\nIF(B16=\"0010-1020\",\"20 %\",\nIF(B16=\"0020-1010\",\"20 %\",\nIF(B16=\"0020-1020\",\"20 %\",\nIF(B16=\"0020-1030\",\"20 %\",\nIF(B16=\"0020-1050\",\"20 %\",\nIF(B16=\"3320-9100\",\"0 %\",\nIF(B16=\"2045-9094\",\"0 %\",\nIF(B16=\"2045-9041\",\"0 %\",\nIF(B16=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},""]
[null,{"$f":"IFERROR('Product Selector'!C17,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B17,Services!B1:D315,2,0),\nIFERROR(VLOOKUP(B17,Products!B1:D419,2,FALSE),\nIFERROR(VLOOKUP(B17,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B17,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B17,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B17,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B17,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B17,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B17,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B17,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "}," -  ",{"$f":"IF(B17=\"1700-9101\",\"20 %\",\nIF(B17=\"1700-9001\",\"20 %\",\nIF(B17=\"1600-0151\",\"20 %\",\nIF(B17=\"1600-0152\",\"20 %\",\nIF(B17=\"1600-0153\",\"20 %\",\nIF(B17=\"1600-0251\",\"20 %\",\nIF(B17=\"1600-0252\",\"20 %\",\nIF(B17=\"1600-0253\",\"20 %\",\nIF(B17=\"1600-0501\",\"20 %\",\nIF(B17=\"1600-0502\",\"20 %\",\nIF(B17=\"1600-0503\",\"20 %\",\nIF(B17=\"1600-0101\",\"20 %\",\nIF(B17=\"1600-0102\",\"20 %\",\nIF(B17=\"1600-0103\",\"20 %\",\nIF(B17=\"0010-1010\",\"20 %\",\nIF(B17=\"0010-0020\",\"20 %\",\nIF(B17=\"0010-1020\",\"20 %\",\nIF(B17=\"0020-1010\",\"20 %\",\nIF(B17=\"0020-1020\",\"20 %\",\nIF(B17=\"0020-1030\",\"20 %\",\nIF(B17=\"0020-1050\",\"20 %\",\nIF(B17=\"3320-9100\",\"0 %\",\nIF(B17=\"2045-9094\",\"0 %\",\nIF(B17=\"2045-9041\",\"0 %\",\nIF(B17=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},{"$f":"IF(AND(C17>0,B17>0),E17*C17*(1-G17),\"\")","v":""}]
[null,{"$f":"IFERROR('Product Selector'!C18,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B18,Services!B1:D316,2,0),\nIFERROR(VLOOKUP(B18,Products!B1:D420,2,FALSE),\nIFERROR(VLOOKUP(B18,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B18,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B18,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B18,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B18,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B18,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B18,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B18,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "}," -  ",{"$f":"IF(B18=\"1700-9101\",\"20 %\",\nIF(B18=\"1700-9001\",\"20 %\",\nIF(B18=\"1600-0151\",\"20 %\",\nIF(B18=\"1600-0152\",\"20 %\",\nIF(B18=\"1600-0153\",\"20 %\",\nIF(B18=\"1600-0251\",\"20 %\",\nIF(B18=\"1600-0252\",\"20 %\",\nIF(B18=\"1600-0253\",\"20 %\",\nIF(B18=\"1600-0501\",\"20 %\",\nIF(B18=\"1600-0502\",\"20 %\",\nIF(B18=\"1600-0503\",\"20 %\",\nIF(B18=\"1600-0101\",\"20 %\",\nIF(B18=\"1600-0102\",\"20 %\",\nIF(B18=\"1600-0103\",\"20 %\",\nIF(B18=\"0010-1010\",\"20 %\",\nIF(B18=\"0010-0020\",\"20 %\",\nIF(B18=\"0010-1020\",\"20 %\",\nIF(B18=\"0020-1010\",\"20 %\",\nIF(B18=\"0020-1020\",\"20 %\",\nIF(B18=\"0020-1030\",\"20 %\",\nIF(B18=\"0020-1050\",\"20 %\",\nIF(B18=\"3320-9100\",\"0 %\",\nIF(B18=\"2045-9094\",\"0 %\",\nIF(B18=\"2045-9041\",\"0 %\",\nIF(B18=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},""]
[null,{"$f":"IFERROR('Product Selector'!C19,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B19,Services!B1:D317,2,0),\nIFERROR(VLOOKUP(B19,Products!B1:D421,2,FALSE),\nIFERROR(VLOOKUP(B19,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B19,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B19,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B19,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B19,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B19,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B19,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B19,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "}," -  ",{"$f":"IF(B19=\"1700-9101\",\"20 %\",\nIF(B19=\"1700-9001\",\"20 %\",\nIF(B19=\"1600-0151\",\"20 %\",\nIF(B19=\"1600-0152\",\"20 %\",\nIF(B19=\"1600-0153\",\"20 %\",\nIF(B19=\"1600-0251\",\"20 %\",\nIF(B19=\"1600-0252\",\"20 %\",\nIF(B19=\"1600-0253\",\"20 %\",\nIF(B19=\"1600-0501\",\"20 %\",\nIF(B19=\"1600-0502\",\"20 %\",\nIF(B19=\"1600-0503\",\"20 %\",\nIF(B19=\"1600-0101\",\"20 %\",\nIF(B19=\"1600-0102\",\"20 %\",\nIF(B19=\"1600-0103\",\"20 %\",\nIF(B19=\"0010-1010\",\"20 %\",\nIF(B19=\"0010-0020\",\"20 %\",\nIF(B19=\"0010-1020\",\"20 %\",\nIF(B19=\"0020-1010\",\"20 %\",\nIF(B19=\"0020-1020\",\"20 %\",\nIF(B19=\"0020-1030\",\"20 %\",\nIF(B19=\"0020-1050\",\"20 %\",\nIF(B19=\"3320-9100\",\"0 %\",\nIF(B19=\"2045-9094\",\"0 %\",\nIF(B19=\"2045-9041\",\"0 %\",\nIF(B19=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},""]
[null,{"$f":"IFERROR('Product Selector'!C20,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B20,Services!B1:D318,2,0),\nIFERROR(VLOOKUP(B20,Products!B1:D422,2,FALSE),\nIFERROR(VLOOKUP(B20,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B20,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B20,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B20,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B20,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B20,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B20,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B20,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "}," -  ",{"$f":"IF(B20=\"1700-9101\",\"20 %\",\nIF(B20=\"1700-9001\",\"20 %\",\nIF(B20=\"1600-0151\",\"20 %\",\nIF(B20=\"1600-0152\",\"20 %\",\nIF(B20=\"1600-0153\",\"20 %\",\nIF(B20=\"1600-0251\",\"20 %\",\nIF(B20=\"1600-0252\",\"20 %\",\nIF(B20=\"1600-0253\",\"20 %\",\nIF(B20=\"1600-0501\",\"20 %\",\nIF(B20=\"1600-0502\",\"20 %\",\nIF(B20=\"1600-0503\",\"20 %\",\nIF(B20=\"1600-0101\",\"20 %\",\nIF(B20=\"1600-0102\",\"20 %\",\nIF(B20=\"1600-0103\",\"20 %\",\nIF(B20=\"0010-1010\",\"20 %\",\nIF(B20=\"0010-0020\",\"20 %\",\nIF(B20=\"0010-1020\",\"20 %\",\nIF(B20=\"0020-1010\",\"20 %\",\nIF(B20=\"0020-1020\",\"20 %\",\nIF(B20=\"0020-1030\",\"20 %\",\nIF(B20=\"0020-1050\",\"20 %\",\nIF(B20=\"3320-9100\",\"0 %\",\nIF(B20=\"2045-9094\",\"0 %\",\nIF(B20=\"2045-9041\",\"0 %\",\nIF(B20=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},""]
[null,{"$f":"IFERROR('Product Selector'!C21,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B21,Services!B1:D319,2,0),\nIFERROR(VLOOKUP(B21,Products!B1:D423,2,FALSE),\nIFERROR(VLOOKUP(B21,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B21,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B21,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B21,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B21,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B21,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B21,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B21,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "}," -  ",{"$f":"IF(B21=\"1700-9101\",\"20 %\",\nIF(B21=\"1700-9001\",\"20 %\",\nIF(B21=\"1600-0151\",\"20 %\",\nIF(B21=\"1600-0152\",\"20 %\",\nIF(B21=\"1600-0153\",\"20 %\",\nIF(B21=\"1600-0251\",\"20 %\",\nIF(B21=\"1600-0252\",\"20 %\",\nIF(B21=\"1600-0253\",\"20 %\",\nIF(B21=\"1600-0501\",\"20 %\",\nIF(B21=\"1600-0502\",\"20 %\",\nIF(B21=\"1600-0503\",\"20 %\",\nIF(B21=\"1600-0101\",\"20 %\",\nIF(B21=\"1600-0102\",\"20 %\",\nIF(B21=\"1600-0103\",\"20 %\",\nIF(B21=\"0010-1010\",\"20 %\",\nIF(B21=\"0010-0020\",\"20 %\",\nIF(B21=\"0010-1020\",\"20 %\",\nIF(B21=\"0020-1010\",\"20 %\",\nIF(B21=\"0020-1020\",\"20 %\",\nIF(B21=\"0020-1030\",\"20 %\",\nIF(B21=\"0020-1050\",\"20 %\",\nIF(B21=\"3320-9100\",\"0 %\",\nIF(B21=\"2045-9094\",\"0 %\",\nIF(B21=\"2045-9041\",\"0 %\",\nIF(B21=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},{"$f":"IF(AND(C21>0,B21>0),E21*C21*(1-G21),\"\")","v":""}]
[null,{"$f":"IFERROR('Product Selector'!C22,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B22,Services!B1:D320,2,0),\nIFERROR(VLOOKUP(B22,Products!B1:D424,2,FALSE),\nIFERROR(VLOOKUP(B22,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B22,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B22,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B22,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B22,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B22,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B22,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B22,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "}," -  ",{"$f":"IF(B22=\"1700-9101\",\"20 %\",\nIF(B22=\"1700-9001\",\"20 %\",\nIF(B22=\"1600-0151\",\"20 %\",\nIF(B22=\"1600-0152\",\"20 %\",\nIF(B22=\"1600-0153\",\"20 %\",\nIF(B22=\"1600-0251\",\"20 %\",\nIF(B22=\"1600-0252\",\"20 %\",\nIF(B22=\"1600-0253\",\"20 %\",\nIF(B22=\"1600-0501\",\"20 %\",\nIF(B22=\"1600-0502\",\"20 %\",\nIF(B22=\"1600-0503\",\"20 %\",\nIF(B22=\"1600-0101\",\"20 %\",\nIF(B22=\"1600-0102\",\"20 %\",\nIF(B22=\"1600-0103\",\"20 %\",\nIF(B22=\"0010-1010\",\"20 %\",\nIF(B22=\"0010-0020\",\"20 %\",\nIF(B22=\"0010-1020\",\"20 %\",\nIF(B22=\"0020-1010\",\"20 %\",\nIF(B22=\"0020-1020\",\"20 %\",\nIF(B22=\"0020-1030\",\"20 %\",\nIF(B22=\"0020-1050\",\"20 %\",\nIF(B22=\"3320-9100\",\"0 %\",\nIF(B22=\"2045-9094\",\"0 %\",\nIF(B22=\"2045-9041\",\"0 %\",\nIF(B22=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},{"$f":"IF(AND(C22>0,B22>0),E22*C22*(1-G22),\"\")","v":""}]
[null,{"$f":"IFERROR('Product Selector'!C23,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B23,Services!B1:D321,2,0),\nIFERROR(VLOOKUP(B23,Products!B1:D425,2,FALSE),\nIFERROR(VLOOKUP(B23,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B23,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B23,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B23,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B23,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B23,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B23,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B23,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "}," -  ",{"$f":"IF(B23=\"1700-9101\",\"20 %\",\nIF(B23=\"1700-9001\",\"20 %\",\nIF(B23=\"1600-0151\",\"20 %\",\nIF(B23=\"1600-0152\",\"20 %\",\nIF(B23=\"1600-0153\",\"20 %\",\nIF(B23=\"1600-0251\",\"20 %\",\nIF(B23=\"1600-0252\",\"20 %\",\nIF(B23=\"1600-0253\",\"20 %\",\nIF(B23=\"1600-0501\",\"20 %\",\nIF(B23=\"1600-0502\",\"20 %\",\nIF(B23=\"1600-0503\",\"20 %\",\nIF(B23=\"1600-0101\",\"20 %\",\nIF(B23=\"1600-0102\",\"20 %\",\nIF(B23=\"1600-0103\",\"20 %\",\nIF(B23=\"0010-1010\",\"20 %\",\nIF(B23=\"0010-0020\",\"20 %\",\nIF(B23=\"0010-1020\",\"20 %\",\nIF(B23=\"0020-1010\",\"20 %\",\nIF(B23=\"0020-1020\",\"20 %\",\nIF(B23=\"0020-1030\",\"20 %\",\nIF(B23=\"0020-1050\",\"20 %\",\nIF(B23=\"3320-9100\",\"0 %\",\nIF(B23=\"2045-9094\",\"0 %\",\nIF(B23=\"2045-9041\",\"0 %\",\nIF(B23=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},""]
[null,{"$f":"IFERROR('Product Selector'!C24,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B24,Services!B1:D322,2,0),\nIFERROR(VLOOKUP(B24,Products!B1:D426,2,FALSE),\nIFERROR(VLOOKUP(B24,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B24,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B24,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B24,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B24,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B24,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B24,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B24,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "}," -  ",{"$f":"IF(B24=\"1700-9101\",\"20 %\",\nIF(B24=\"1700-9001\",\"20 %\",\nIF(B24=\"1600-0151\",\"20 %\",\nIF(B24=\"1600-0152\",\"20 %\",\nIF(B24=\"1600-0153\",\"20 %\",\nIF(B24=\"1600-0251\",\"20 %\",\nIF(B24=\"1600-0252\",\"20 %\",\nIF(B24=\"1600-0253\",\"20 %\",\nIF(B24=\"1600-0501\",\"20 %\",\nIF(B24=\"1600-0502\",\"20 %\",\nIF(B24=\"1600-0503\",\"20 %\",\nIF(B24=\"1600-0101\",\"20 %\",\nIF(B24=\"1600-0102\",\"20 %\",\nIF(B24=\"1600-0103\",\"20 %\",\nIF(B24=\"0010-1010\",\"20 %\",\nIF(B24=\"0010-0020\",\"20 %\",\nIF(B24=\"0010-1020\",\"20 %\",\nIF(B24=\"0020-1010\",\"20 %\",\nIF(B24=\"0020-1020\",\"20 %\",\nIF(B24=\"0020-1030\",\"20 %\",\nIF(B24=\"0020-1050\",\"20 %\",\nIF(B24=\"3320-9100\",\"0 %\",\nIF(B24=\"2045-9094\",\"0 %\",\nIF(B24=\"2045-9041\",\"0 %\",\nIF(B24=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},""]
[null,{"$f":"IFERROR('Product Selector'!C25,\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(B25,Services!B1:D323,2,0),\nIFERROR(VLOOKUP(B25,Products!B1:D427,2,FALSE),\nIFERROR(VLOOKUP(B25,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B25,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B25,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B25,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B25,#REF!,2,FALSE),\nIFERROR(VLOOKUP(B25,#REF!,2,FALSE),\" - - \"))))))))","v":" - - "},{"$f":"IFERROR(VLOOKUP(B25,Services!B1:E16,3,0),\nIFERROR(VLOOKUP(B25,Products!B1:E16,3,FALSE),\" -  \"))","v":" -  "}," -  ",{"$f":"IF(B25=\"1700-9101\",\"20 %\",\nIF(B25=\"1700-9001\",\"20 %\",\nIF(B25=\"1600-0151\",\"20 %\",\nIF(B25=\"1600-0152\",\"20 %\",\nIF(B25=\"1600-0153\",\"20 %\",\nIF(B25=\"1600-0251\",\"20 %\",\nIF(B25=\"1600-0252\",\"20 %\",\nIF(B25=\"1600-0253\",\"20 %\",\nIF(B25=\"1600-0501\",\"20 %\",\nIF(B25=\"1600-0502\",\"20 %\",\nIF(B25=\"1600-0503\",\"20 %\",\nIF(B25=\"1600-0101\",\"20 %\",\nIF(B25=\"1600-0102\",\"20 %\",\nIF(B25=\"1600-0103\",\"20 %\",\nIF(B25=\"0010-1010\",\"20 %\",\nIF(B25=\"0010-0020\",\"20 %\",\nIF(B25=\"0010-1020\",\"20 %\",\nIF(B25=\"0020-1010\",\"20 %\",\nIF(B25=\"0020-1020\",\"20 %\",\nIF(B25=\"0020-1030\",\"20 %\",\nIF(B25=\"0020-1050\",\"20 %\",\nIF(B25=\"3320-9100\",\"0 %\",\nIF(B25=\"2045-9094\",\"0 %\",\nIF(B25=\"2045-9041\",\"0 %\",\nIF(B25=\"4210-9990\",\"0 %\",H2)))))))))))))))))))))))))","v":0.3},{"$f":"IF(AND(C25>0,B25>0),E25*C25*(1-G25),\"\")","v":""}]
[null,null,null,"",{"$f":"IF(ISNA(VLOOKUP(B26,Services!$B$6:$D$306,6,FALSE)),\"\",VLOOKUP(B26,Services!$B$6:$D$306,6,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(C26,Services!$B$6:$D$306,6,FALSE)),\"\",VLOOKUP(C26,Services!$B$6:$D$306,6,FALSE))","v":""},null,{"$f":"IF(AND(C26>0,B26>0),E26*C26*(1-G26),\"\")","v":""}]
[null,null,null,null,"Customer:",{"$f":"SUM(F7:F26)","v":0},"Partner:",{"$f":"SUM(H7:H26)","v":0}]
[]
[]
[null,"NOTE"]
[null,"This quoatation is considered as a draft and may be subject to typos or mistakes."]
[null,"Please contact sales@company.com or your sales representative to get an official quote."]
[null,"TAX/VAT, Shipping or additional cost such as  installation is not included in this  draft."]

{"sheet":"Category","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Category"]
["Products"]
["Services"]

{"sheet":"Products","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Product List"]
[]
[null,"Product code","Product name","EUR"]
[null,"2023-1001","Refrigerator",797]
[null,"2023-1002","Oven",590]
[null,"2023-1003","Air fryer",197]
[null,"2023-1004","Microwave",298]
[null,"2023-1005","Dishwasher",489]
[null,"2023-1006","Washing machine",538]
[null,"2023-1007","Dryer",366]
[null,"2023-1008","Blender",125]
[null,"2023-1009","Coffee maker",238]
[null,"2023-1010","Heater",178]

{"sheet":"Services","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Service list"]
[]
[null,"Product code","Product name","EUR"]
[null,"1001-2023","Home cleaning (1 hour)",99]
[null,"1002-2023","Home cleaning (per day)",820]
[null,"1002-2024","Gardening services (per hour)",68]
[null,"1002-2025","Gardening services (per day)",499]
[null,"1002-2026","Caretaker service (1 hour)",129]
[null,"1002-2027","Caretaker service (per day)",749]
[null,"1002-2028","Massage (1 hour)",90]