{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Question","Start","Bill","Mike","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Question","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Data I have to process","Question 1: Function is looking for \"Top Load\" or \"Front Load\"","Question 2: Function is looking for \"Cu.\" and returns the value"]
["Description","Value that I want to return","Value that I want to return"]
["24\" 2.6 cu ft., Portable Top Load Washer, Stainless Steel Wash Tub, I-Sensor, 9 Wash Cycles, 7 Waster Level. ","Top Load","2,6"]
["HE Top Load Washer, 5.2 cu. ft, Stainless Steel Wash Tub, Wave force, VCM,","Top Load","5,2"]
["Coldwash, 6 motion"]
["4.0 cu.ft., 1100rpm, None Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design (Neo Pro)","Top Load","4,0"]
["Front Load, 4.3 cu.ft., 1150 rpm, Non Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design, Truebalance,  6 Motion, Smart Diagnosis™,","Front Load","4,3"]
["Order prevention Package, TTM Color"]
["Front Load, 4.3 cu.ft., 1150 rpm, Non Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design, Truebalance,  6 Motion™, Smart Diagnosis™,","Front Load","4,3"]
["Order prevention Package, White Color"]
["Front Load, 4.3 cu.ft., 1200 rpm, Direct Drive, Painted Top Plate, 12 Washer Cycles, Front Console design, HEATER, STS Drum,Truebalance, Smart Diagnosis ™, Odor reduction Package, Coldwash™, 6 Motion™, TTM","Top Load","4,3"]

{"sheet":"Start","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Data I have to process","Question 1: Function is looking for \"Top Load\" or \"Front Load\"","Question 2: Function is looking for \"Cu.\" and returns the value"]
["Description","Value that I want to return","Value that I want to return"]
["24\" 2.6 cu ft., Portable Top Load Washer, Stainless Steel Wash Tub, I-Sensor, 9 Wash Cycles, 7 Waster Level. "]
["HE Top Load Washer, 5.2 cu. ft, Stainless Steel Wash Tub, Wave force, VCM,"]
["Coldwash, 6 motion"]
["4.0 cu.ft., 1100rpm, None Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design (Neo Pro)"]
["Front Load, 4.3 cu.ft., 1150 rpm, Non Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design, Truebalance,  6 Motion, Smart Diagnosis™,"]
["Order prevention Package, TTM Color"]
["Front Load, 4.3 cu.ft., 1150 rpm, Non Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design, Truebalance,  6 Motion™, Smart Diagnosis™,"]
["Order prevention Package, White Color"]
["Front Load, 4.3 cu.ft., 1200 rpm, Direct Drive, Painted Top Plate, 12 Washer Cycles, Front Console design, HEATER, STS Drum,Truebalance, Smart Diagnosis ™, Odor reduction Package, Coldwash™, 6 Motion™, TTM"]

{"sheet":"Bill","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Data I have to process","Question 1: Function is looking for \"Top Load\" or \"Front Load\"","Question 2: Function is looking for \"Cu.\" and returns the value"]
["Description","Value that I want to return","Value that I want to return"]
["24\" 2.6 cu ft., Portable Top Load Washer, Stainless Steel Wash Tub, I-Sensor, 9 Wash Cycles, 7 Waster Level. ",{"$f":"IF(ISERROR(FIND(\"top load\",LOWER(A3))),\"\",\"Top Load\")&IF(ISERROR(FIND(\"front load\",LOWER(A3))),\"\",\"Front Load\")","v":"Top Load"},{"$f":"CF(A3)","v":"2,6"}]
["HE Top Load Washer, 5.2 cu. ft, Stainless Steel Wash Tub, Wave force, VCM,",{"$f":"IF(ISERROR(FIND(\"top load\",LOWER(A4))),\"\",\"Top Load\")&IF(ISERROR(FIND(\"front load\",LOWER(A4))),\"\",\"Front Load\")","v":"Top Load"},"5,2"]
["Coldwash, 6 motion","",""]
["4.0 cu.ft., 1100rpm, None Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design (Neo Pro)","","4,0"]
["Front Load, 4.3 cu.ft., 1150 rpm, Non Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design, Truebalance,  6 Motion, Smart Diagnosis™,","Front Load","4,3"]
["Order prevention Package, TTM Color","",""]
["Front Load, 4.3 cu.ft., 1150 rpm, Non Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design, Truebalance,  6 Motion™, Smart Diagnosis™,","Front Load","4,3"]
["Order prevention Package, White Color","",""]
["Front Load, 4.3 cu.ft., 1200 rpm, Direct Drive, Painted Top Plate, 12 Washer Cycles, Front Console design, HEATER, STS Drum,Truebalance, Smart Diagnosis ™, Odor reduction Package, Coldwash™, 6 Motion™, TTM",null,"4,3"]

{"sheet":"Mike","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Data I have to process","Question 1: Function is looking for \"Top Load\" or \"Front Load\"","Question 2: Function is looking for \"Cu.\" and returns the value"]
["Description","Value that I want to return","Value that I want to return"]
["24\" 2.6 cu ft., Portable Top Load Washer, Stainless Steel Wash Tub, I-Sensor, 9 Wash Cycles, 7 Waster Level. ",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A3),{\"Top Load\",\"Front Load\"}),\"\")","v":"Top Load"},{"$f":"SUBSTITUTE(TRIM(MID(A3,SEARCH(\" cu\",A3)-4,4)),\".\",\",\")","v":"2,6"},{"$f":"LEN(C3)","v":3}]
["HE Top Load Washer, 5.2 cu. ft, Stainless Steel Wash Tub, Wave force, VCM,",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A4),{\"Top Load\",\"Front Load\"}),\"\")","v":"Top Load"},{"$f":"SUBSTITUTE(TRIM(MID(A4,SEARCH(\" cu\",A4)-4,4)),\".\",\",\")","v":"5,2"}]
["Coldwash, 6 motion",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A5),{\"Top Load\",\"Front Load\"}),\"\")","v":""},{"$error":"#VALUE!"}]
["4.0 cu.ft., 1100rpm, None Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design (Neo Pro)",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A6),{\"Top Load\",\"Front Load\"}),\"\")","v":""},{"$error":"#VALUE!"}]
["Front Load, 4.3 cu.ft., 1150 rpm, Non Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design, Truebalance,  6 Motion, Smart Diagnosis™,",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A7),{\"Top Load\",\"Front Load\"}),\"\")","v":"Front Load"},"4,3"]
["Order prevention Package, TTM Color",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A8),{\"Top Load\",\"Front Load\"}),\"\")","v":""},{"$error":"#VALUE!"}]
["Front Load, 4.3 cu.ft., 1150 rpm, Non Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design, Truebalance,  6 Motion™, Smart Diagnosis™,",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A9),{\"Top Load\",\"Front Load\"}),\"\")","v":"Front Load"},"4,3"]
["Order prevention Package, White Color",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A10),{\"Top Load\",\"Front Load\"}),\"\")","v":""},{"$error":"#VALUE!"}]
["Front Load, 4.3 cu.ft., 1200 rpm, Direct Drive, Painted Top Plate, 12 Washer Cycles, Front Console design, HEATER, STS Drum,Truebalance, Smart Diagnosis ™, Odor reduction Package, Coldwash™, 6 Motion™, TTM",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A11),{\"Top Load\",\"Front Load\"}),\"\")","v":"Front Load"},"4,3"]

{"sheet":"Sheet2","index":4,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Data I have to process","Question 1: Function is looking for \"Top Load\" or \"Front Load\"","Question 2: Function is looking for \"Cu.\" and returns the value"]
["Description","Value that I want to return","Value that I want to return"]
["24\" 2.6 cu ft., Portable Top Load Washer, Stainless Steel Wash Tub, I-Sensor, 9 Wash Cycles, 7 Waster Level. ",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A3),{\"Top Load\",\"Front Load\"}),\"\")","v":"Top Load"},{"$f":"IFERROR(MID(A3,SEARCH(\" cu\",A3)-4,5)+0,\"\")","v":2.6}]
["HE Top Load Washer, 5.2 cu. ft, Stainless Steel Wash Tub, Wave force, VCM,",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A4),{\"Top Load\",\"Front Load\"}),\"\")","v":"Top Load"},{"$f":"IFERROR(MID(A4,SEARCH(\" cu\",A4)-4,5)+0,\"\")","v":5.2}]
["Coldwash, 6 motion",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A5),{\"Top Load\",\"Front Load\"}),\"\")","v":""},""]
["4.0 cu.ft., 1100rpm, None Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design (Neo Pro)",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A6),{\"Top Load\",\"Front Load\"}),\"\")","v":""},""]
["Front Load, 4.3 cu.ft., 1150 rpm, Non Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design, Truebalance,  6 Motion, Smart Diagnosis™,",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A7),{\"Top Load\",\"Front Load\"}),\"\")","v":"Front Load"},4.3]
["Order prevention Package, TTM Color",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A8),{\"Top Load\",\"Front Load\"}),\"\")","v":""},""]
["Front Load, 4.3 cu.ft., 1150 rpm, Non Heater, Direct Drive, Painted Top Plate, 7 Washer Cycles, Front Console design, Truebalance,  6 Motion™, Smart Diagnosis™,",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A9),{\"Top Load\",\"Front Load\"}),\"\")","v":"Front Load"},4.3]
["Order prevention Package, White Color",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A10),{\"Top Load\",\"Front Load\"}),\"\")","v":""},""]
["Front Load, 4.3 cu.ft., 1200 rpm, Direct Drive, Painted Top Plate, 12 Washer Cycles, Front Console design, HEATER, STS Drum,Truebalance, Smart Diagnosis ™, Odor reduction Package, Coldwash™, 6 Motion™, TTM",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A11),{\"Top Load\",\"Front Load\"}),\"\")","v":"Front Load"},4.3]
["Other Product 1 Front Load 3.3 cu",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A12),{\"Top Load\",\"Front Load\"}),\"\")","v":"Front Load"},3.3]
["Other Product 2 4.5 cu Top Load",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A13),{\"Top Load\",\"Front Load\"}),\"\")","v":"Top Load"},4.5]
["Other Product 3 Front  Load 3.3 cu",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A14),{\"Top Load\",\"Front Load\"}),\"\")","v":""},3.3]
["Other Product 2 4.5 c u Top Load",{"$f":"IFERROR(LOOKUP(2^15,SEARCH({\"Top Load\",\"Front Load\"},A15),{\"Top Load\",\"Front Load\"}),\"\")","v":"Top Load"},""]

{"sheet":"Sheet3","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}