{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Lookup","MultiLayer","Result"],"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":"Lookup","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Sale Item","Cost Per Unit"]
["Apples",0.4]
["Oranges",0.3]
["Pears",0.6]
["Lemons",0.45]
["Potato",0.12]
["Leeks",0.15]

{"sheet":"MultiLayer","index":1,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Person","Fruit","Year","Type","Price Per Unit","Qty","Amt."]
["Bob","Apples","2015-16","Fruit",{"$f":"VLOOKUP(B2,Lookup!$A$2:$B$20,2,0)","v":0.4},242,{"$f":"F2*E2","v":96.800000000000011}]
["Bob","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B3,Lookup!$A$2:$B$20,2,0)","v":0.3},244,{"$f":"F3*E3","v":73.2}]
["Bob","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B4,Lookup!$A$2:$B$20,2,0)","v":0.3},261,78.3]
["Bob","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B5,Lookup!$A$2:$B$20,2,0)","v":0.3},182,54.6]
["Bob","Apples","2015-16","Fruit",{"$f":"VLOOKUP(B6,Lookup!$A$2:$B$20,2,0)","v":0.4},257,102.80000000000001]
["Bob","Apples","2015-16","Fruit",{"$f":"VLOOKUP(B7,Lookup!$A$2:$B$20,2,0)","v":0.4},137,54.800000000000004]
["Jane","Apples","2015-16","Fruit",{"$f":"VLOOKUP(B8,Lookup!$A$2:$B$20,2,0)","v":0.4},118,47.2]
["Jane","Apples","2015-16","Fruit",{"$f":"VLOOKUP(B9,Lookup!$A$2:$B$20,2,0)","v":0.4},226,90.4]
["Jane","Apples","2015-16","Fruit",{"$f":"VLOOKUP(B10,Lookup!$A$2:$B$20,2,0)","v":0.4},128,51.2]
["Jane","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B11,Lookup!$A$2:$B$20,2,0)","v":0.3},186,55.8]
["Jane","Pears","2015-16","Fruit",{"$f":"VLOOKUP(B12,Lookup!$A$2:$B$20,2,0)","v":0.6},139,83.399999999999991]
["Kev","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B13,Lookup!$A$2:$B$20,2,0)","v":0.3},225,67.5]
["Kev","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B14,Lookup!$A$2:$B$20,2,0)","v":0.3},235,70.5]
["Kev","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B15,Lookup!$A$2:$B$20,2,0)","v":0.3},179,53.699999999999996]
["Kev","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B16,Lookup!$A$2:$B$20,2,0)","v":0.3},225,67.5]
["Kev","Apples","2015-16","Fruit",{"$f":"VLOOKUP(B17,Lookup!$A$2:$B$20,2,0)","v":0.4},194,77.600000000000009]
["Jimbo","Pears","2015-16","Fruit",{"$f":"VLOOKUP(B18,Lookup!$A$2:$B$20,2,0)","v":0.6},229,137.4]
["Jimbo","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B19,Lookup!$A$2:$B$20,2,0)","v":0.3},176,52.8]
["Jimbo","Apples","2015-16","Fruit",{"$f":"VLOOKUP(B20,Lookup!$A$2:$B$20,2,0)","v":0.4},237,94.800000000000011]
["Jimbo","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B21,Lookup!$A$2:$B$20,2,0)","v":0.3},141,42.3]
["Jimbo","Pears","2015-16","Fruit",{"$f":"VLOOKUP(B22,Lookup!$A$2:$B$20,2,0)","v":0.6},232,139.19999999999999]
["Donna","Pears","2015-16","Fruit",{"$f":"VLOOKUP(B23,Lookup!$A$2:$B$20,2,0)","v":0.6},158,94.8]
["Donna","Pears","2015-16","Fruit",{"$f":"VLOOKUP(B24,Lookup!$A$2:$B$20,2,0)","v":0.6},144,86.399999999999991]
["Donna","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B25,Lookup!$A$2:$B$20,2,0)","v":0.3},134,40.199999999999996]
["Donna","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B26,Lookup!$A$2:$B$20,2,0)","v":0.3},187,56.1]
["Donna","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B27,Lookup!$A$2:$B$20,2,0)","v":0.3},218,65.399999999999991]
["Donna","Oranges","2015-16","Fruit",{"$f":"VLOOKUP(B28,Lookup!$A$2:$B$20,2,0)","v":0.3},132,39.6]

{"sheet":"Result","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Person","Fruit","Year","Type","Price Per Unit","Qty","Amt."]
["Bob","Apples","2015-16","Fruit",0.4,636,254.4]
["Bob","Oranges","2015-16","Fruit",0.3,687,206.1]
["Jane","Apples","2015-16","Fruit",0.4,472,188.8]
["Jane","Oranges","2015-16","Fruit",0.3,186,55.8]
["Jane","Pears","2015-16","Fruit",0.6,139,83.4]
["Kev","Oranges","2015-16","Fruit",0.3,864,259.2]
["Kev","Apples","2015-16","Fruit",0.4,194,77.599999999999994]
["Jimbo","Pears","2015-16","Fruit",0.6,461,276.60000000000002]
["Jimbo","Oranges","2015-16","Fruit",0.3,317,95.1]
["Jimbo","Apples","2015-16","Fruit",0.4,237,94.8]
["Donna","Pears","2015-16","Fruit",0.6,302,181.2]
["Donna","Oranges","2015-16","Fruit",0.3,671,201.3]