{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Question","Start","Bill","Mike","4 Examples","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Product","Prices",null,null,"Product (booms)","Wholesale Prices Upper"]
["Bellen",14,"<<== Allow prices below Upper",null,"Yanaki",15]
["Yanaki",16,"<<== Disallow prices above Upper, or Add a format when above",null,"Bellen",16]
[null,null,null,null,"Aspen",12]
[null,null,null,null,"Quad",19]
[]
[]
[]
[]
[]
[]
[]
[null,null,"aprima at YouTube Asks"]
[null,null,"1) Disallow when there it is above upper"]

{"sheet":"Start","index":1,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Product","Prices",null,null,"Product (booms)","Wholesale Prices Upper"]
["Bellen",14,"<<== Allow prices below Upper",null,"Yanaki",15]
["Yanaki",16,"<<== Disallow prices above Upper, or Add a format when above",null,"Bellen",16]
[null,null,null,null,"Aspen",12]
[null,null,null,null,"Quad",19]

{"sheet":"Bill","index":2,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Product","Prices",null,null,"Product (booms)","Wholesale Prices Upper"]
["Bellen",14,null,null,"Yanaki",15]
["Yanaki",16,null,null,"Bellen",16]
["Aspen",null,null,null,"Aspen",12]
[null,null,null,null,"Quad",19]

{"sheet":"Mike","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Product","Prices",null,null,"Product (booms)","Wholesale Prices Upper"]
["Bellen",14,{"$f":"B2>VLOOKUP(A2,$E$2:$F$5,2,0)","v":false},null,"Yanaki",15]
["Aspen",14.5,{"$f":"B3>VLOOKUP(A3,$E$2:$F$5,2,0)","v":true},null,"Bellen",16]
["Yanaki",11,false,null,"Aspen",12]
["Quad",18,false,null,"Quad",19]
[null,null,{"$error":"#N/A"}]
[null,null,{"$error":"#N/A"}]
[null,null,{"$error":"#N/A"}]
[null,null,{"$error":"#N/A"}]
[null,null,{"$error":"#N/A"},null,"aprima at YouTube Asks"]
[null,null,{"$error":"#N/A"}]

{"sheet":"4 Examples","index":4,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Product","Prices",null,"Product","Prices",null,"Product","Prices",null,"Product (booms)","Wholesale Prices Upper"]
["Bellen",14,null,"Bellen",14,null,"Bellen",14,null,"Yanaki",15]
["Yanaki",16,null,"Yanaki",16,null,"Yanaki",16,null,"Bellen",16]
["Quad",null,null,"Quad",null,null,"Quad",null,null,"Aspen",12]
[null,null,null,null,null,null,null,null,null,"Quad",19]
[]
[]
[]
[]
[]
[]
[]
["Data Validation",null,null,"Conditional Formatting 1",null,null,"Conditional Formatting 2"]
[" =B2<=VLOOKUP(A2,$J$2:$K$5,2,0)",null,null,"Cell Value > Option =VLOOKUP(D2,$J$2:$K$5,2,0)",null,null,"T/F formula: "," =H2>VLOOKUP(G2,$J$2:$K$5,2,0)"]
[]
[null,null,null,null,null,null,"What if a lower AND upper limit"]
[null,null,null,null,null,null,"Product","Prices",null,"Product (booms)","Wholesale Prices Lower","Wholesale Prices Upper"]
[null,null,null,null,null,null,"Bellen",14,{"$f":"OR(AND(H18<>\"\",H18<VLOOKUP(G18,$J$18:$L$21,2,0)),H18>VLOOKUP(G18,$J$18:$L$21,3,0))","v":false},"Yanaki",10,15]
[null,null,null,null,null,null,"Yanaki",16,{"$f":"OR(AND(H19<>\"\",H19<VLOOKUP(G19,$J$18:$L$21,2,0)),H19>VLOOKUP(G19,$J$18:$L$21,3,0))","v":true},"Bellen",9,16]
[null,null,null,null,null,null,"Quad",null,false,"Aspen",8,12]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"},"Quad",12,19]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[]
[null,null,null,null,null,null,"Conditional Formatting 3"]
[null,null,null,null,null,null,"T/F formula: "," =OR(AND(H18<>\"\",H18<VLOOKUP(G18,$J$18:$L$21,2,0)),H18>VLOOKUP(G18,$J$18:$L$21,3,0))"]

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