{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["VLOOKUP 1","VLOOKUP 2","Parties","MACROS","MACROS 2"],"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":"VLOOKUP 1","index":0,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Supplier ID","Product ID","Product","Unit Price","Units",null,"Enter Product ID",134]
["B291",134,"apples",0.53,"Individual",null,"Unit Price",{"$f":"VLOOKUP(H1,$B$2:$D$14,3,FALSE)","v":0.53}]
["H736",860,"pears",0.76,"Individual"]
["K902",732,"peaches",1.04,"Individual"]
["M399",458,"strawberries",3.71,"quart"]
["A882",109,"raspberries",5.03,"pint",null,"Enter Product ID",504]
["D704",372,"grapes",2.17,"pound",null,"Sold by",{"$f":"VLOOKUP(H6,$B$2:$E$14,4,FALSE)","v":"pound"}]
["G494",504,"bananas",1.58,"pound"]
["K914",118,"kiwis",3.82,"pound"]
["S750",792,"blueberries",4.75,"pint"]
["Z228",639,"pineapples",4.2300000000000004,"Individual"]
["R187",240,"oranges",0.89,"Individual"]
["W609",317,"apricots",1.43,"pound"]
["T271",518,"blackberries",4.5,"pint"]

{"sheet":"VLOOKUP 2","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Last","First","Pcode","Party"]
["Smith","Jane","D",{"$f":"VLOOKUP(C2,Parties!$A$1:$B$10,2,)","v":"Socialist"}]
["Williams","John","A",{"$f":"VLOOKUP(C3,Parties!$A$1:$B$10,2,)","v":"Democrat"}]
["Robinson","Cathy","F",{"$f":"VLOOKUP(C4,Parties!$A$1:$B$10,2,)","v":"Independent"}]
["James","Douglas","E",{"$f":"VLOOKUP(C5,Parties!$A$1:$B$10,2,)","v":"Communist"}]
["Jones","Lisa","G",{"$f":"VLOOKUP(C6,Parties!$A$1:$B$10,2,)","v":"Green"}]
["Black","Erin","A",{"$f":"VLOOKUP(C7,Parties!$A$1:$B$10,2,)","v":"Democrat"}]
["Brown","Fred","C",{"$f":"VLOOKUP(C8,Parties!$A$1:$B$10,2,)","v":"Libertarian"}]
["White","Shana","H",{"$f":"VLOOKUP(C9,Parties!$A$1:$B$10,2,)","v":"Peace"}]
["Douglas","William","A",{"$f":"VLOOKUP(C10,Parties!$A$1:$B$10,2,)","v":"Democrat"}]
["Hooper","Dana","B",{"$f":"VLOOKUP(C11,Parties!$A$1:$B$10,2,)","v":"Republican"}]
["Larson","Gary","J",{"$f":"VLOOKUP(C12,Parties!$A$1:$B$10,2,)","v":"Liberal"}]

{"sheet":"Parties","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["A","Democrat"]
["B","Republican"]
["C","Libertarian"]
["D","Socialist"]
["E","Communist"]
["F","Independent"]
["G","Green"]
["H","Peace"]
["I","Conservative"]
["J","Liberal"]

{"sheet":"MACROS","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Banyan Treatment Center"]
[null,null,"Banyan Treatment Center"]
[]
["Banyan Treatment Center"]
[]
[null,null,null,null,null,null,"Banyan Treatment Center"]
[null,null,null,null,"Banyan Treatment Center"]
[null,null,null,"Banyan Treatment Center"]
[]
["Banyan Treatment Center"]
["Banyan Treatment Center"]
[]
["Banyan Treatment Center"]
[null,null,null,null,"Banyan Treatment Center"]

{"sheet":"MACROS 2","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Mon","Tue","Wed","Thu","Fri"]
["08:00:00"]
["09:00:00"]
["10:00:00"]
["11:00:00"]
["12:00:00"]
["01:00:00"]
["02:00:00"]
["03:00:00"]
["04:00:00"]
["05:00:00"]
["06:00:00"]