{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Inputs","Analysis","Summaries","Filtered Summary"],"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":"Inputs","index":0,"n_rows":10,"n_cols":22,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["<command button to start routine here>"]
[]
["Model","Color","Weight","Volume","Change Group"]
[59603,"Blue",17,384,"59603,97196,41444,72306,61772"]
[97196,"Blue",97,637,"59603,97196,41444,72306,61772"]
[41444,"Red",93,275,"59603,97196,41444,72306,61772",null,"<- test row for handling empty rows",null,null,null,59603,"Blue",17,384,"59603,97196,41444,72306,61772",null,null,1,"Blue",17,384,"59603,97196,41444,72306,61772"]
[72306,"Red",42,618,"59603,97196,41444,72306,61772",null,null,null,null,null,97196,"Blue",97,637,"59603,97196,41444,72306,61772",null,null,5,"Green",97,637,"59603,97196,41444,72306,61772"]
[61772,"Green",39,782,"59603,97196,41444,72306,61772",null,null,null,null,null,41444,"Red",93,275,"59603,97196,41444,72306,61772"]
[null,null,null,null,null,null,null,null,null,null,72306,"Red",42,618,"59603,97196,41444,72306,61772"]
[null,null,null,null,null,null,null,null,null,null,61772,"Green",39,782,"59603,97196,41444,72306,61772"]

{"sheet":"Analysis","index":1,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Model","Color","Weight","Volume","Change Group"]
[null,null,null,null,null,null,"* in actual file, need to rework all column equations that reference 'Change Group\" to somehow convert csv's into single cells"]
[]
["Parts","Calculation 1","Calculation 2","Calculation 3","Calculation 4","Calculation 5","Calculation 6","Result 1","Result 2","Result 3",null,"* need to only copy value, not equation"]
[1,1,1,1,1,1,1,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},1,null,"* when routine complete, need to clear contents AND delete all rows except first  ~20 empty rows"]
[2,2,2,2,2,2,2,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},2]
[3,3,3,3,3,3,3,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},3,null,"IF(Model_T[Model]>3,\"No\",\"Yes\")"]
[4,4,4,4,4,4,4,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},4]
[5,5,5,5,5,5,5,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},5]
[null,null,null,null,null,null,null,null,null,null,null,"<- test row for handling empty rows"]
[null,null,null,null,null,null,null,null,null,null,null,"^ will likely still be imported. Need to"]
[null,null,null,null,null,null,null,null,null,null,null,"instead mak sure LEN(wholerow?) = 0"]

{"sheet":"Summaries","index":2,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Parts","Calculation 1","Calculation 2","Calculation 3","Calculation 4","Calculation 5","Calculation 6","Result 1","Result 2","Result 3"]
[1,1,1,1,1,1,1,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},1]
[2,2,2,2,2,2,2,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},2]
[3,3,3,3,3,3,3,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},3]
[4,4,4,4,4,4,4,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},4]
[5,5,5,5,5,5,5,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},5]
[1,1,1,1,1,1,1,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},1]
[2,2,2,2,2,2,2,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},2]
[3,3,3,3,3,3,3,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},3]
[4,4,4,4,4,4,4,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},4]
[5,5,5,5,5,5,5,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},5]
[1,1,1,1,1,1,1,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},1]
[2,2,2,2,2,2,2,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},2]
[3,3,3,3,3,3,3,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},3]
[4,4,4,4,4,4,4,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},4]
[5,5,5,5,5,5,5,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},5]
[1,1,1,1,1,1,1,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},1]
[2,2,2,2,2,2,2,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},2]
[3,3,3,3,3,3,3,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},3]
[4,4,4,4,4,4,4,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},4]
[5,5,5,5,5,5,5,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},5]
[1,1,1,1,1,1,1,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},1]
[2,2,2,2,2,2,2,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},2]
[3,3,3,3,3,3,3,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},3]
[4,4,4,4,4,4,4,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},4]
[5,5,5,5,5,5,5,{"$f":"Model_T[Model]","v":0},{"$f":"IF(Model_T[Model]>3,\"No\",\"Yes\")","v":"Yes"},5]

{"sheet":"Filtered Summary","index":3,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Parts","Result 1","Result 2","Result 3"]
[{"$f":" _xlfn._xlws.FILTER(INDEX(Summaries_T[], _xlfn.SEQUENCE(ROWS(Summaries_T[])), _xlfn.XMATCH(A1:D1, Summaries_T[#Headers])),Summaries_T[Result 2] = \"Yes\")","v":1},0,"Yes",1,null,"<- this is a Range, not a Table since FILTER() cannot spill into Table format"]
[2,0,"Yes",2]
[3,0,"Yes",3]
[4,0,"Yes",4]
[5,0,"Yes",5]
[1,0,"Yes",1]
[2,0,"Yes",2]
[3,0,"Yes",3]
[4,0,"Yes",4]
[5,0,"Yes",5]
[1,0,"Yes",1]
[2,0,"Yes",2]
[3,0,"Yes",3]
[4,0,"Yes",4]
[5,0,"Yes",5]
[1,0,"Yes",1]
[2,0,"Yes",2]
[3,0,"Yes",3]
[4,0,"Yes",4]
[5,0,"Yes",5]
[1,0,"Yes",1]
[2,0,"Yes",2]
[3,0,"Yes",3]
[4,0,"Yes",4]
[5,0,"Yes",5]