{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Example","RELOAD","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Example","index":0,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,9,18,12]]}
["Date_ID","Fruit","Index","Shop_ID","Volume"]
["2018-02-15","Juniper berry","0x000AAB10","2U2VHA8",43795.12]
["2018-05-22","Passionfruit","0x000A9CA8","9V0AQ92",67253.490000000005]
["2018-05-26","Lime","0x0003C3E6","XCHO0S5",86333.96]
["2018-02-15","Bilberry","0x00074E71","K52BTKE",56574.46]
["2018-04-16","Jostaberry","0x0008EF2C","ARM6G4O",43138.400000000001]
["2018-02-19","Mulberry","0x00075F08","VIR5H0G",61073.53]
["2018-03-03","Marionberry","0x0009BEE6","GE0TE06",77565.64]
["2018-05-26","Prune","0x0004C032","2VQY49C",8743.81]
["2018-04-12","Honeydew","0x00073462","6PCGV7S",98654.400000000009]
["2018-06-15","Feijoa","0x00054D38","BO6CF9U",96513.91]
["2018-07-17","Jambul","0x00057AB7","QIPJ9L8",27805.91]
["2018-05-14","Blueberry","0x00081D89","T4F2L1E",81024.17]
["2018-07-25","Honeyberry","0x0008FF7A","3IEVQ6X",3881.9900000000002]
["2018-03-15","Melon","0x0004BAE2","SIB9FD1",94722.69]
["2018-05-10","Plantain","0x00070AAD","1M6618I",6307.41]
["2018-03-31","Cloudberry","0x0008ECE7","Q63YSRE",88845.26]
["2018-02-15","Durian","0x000573C3","P8RNHIJ",23796.9]
["2018-07-17","Watermelon","0x0008C6FF","2Q77D53",53458.28,null,null,null,null,"TRANS_ID"]
["2018-07-13","Plum","0x00040272","1QVFYK5",82933.570000000007]
["2018-02-11","Jabuticaba","0x00083C3E","6W8XLAR",3713.67]

{"sheet":"RELOAD","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Index","Fruit","Trans_ID","Shop_ID","Date_ID","Volume"]
["0x000AAB10","Juniper berry","7y1r1I7","2U2VHA8","2018-02-15",43795.12]
["0x000A9CA8","Passionfruit","81PegA4","9V0AQ92","2018-05-22",67253.490000000005]
["0x0003C3E6","Lime","VjFuY8W","XCHO0S5","2018-05-26",86333.96]
["0x00074E71","Bilberry","f1vV5gP","K52BTKE","2018-02-15",56574.46]
["0x0008EF2C","Jostaberry","ClP2Nd7","ARM6G4O","2018-04-16",43138.400000000001]
["0x00075F08","Mulberry","399c9eO","VIR5H0G","2018-02-19",61073.53]
["0x0009BEE6","Marionberry","igGYQig","GE0TE06","2018-03-03",77565.64]
["0x0004C032","Prune","3RtEahI","2VQY49C","2018-05-26",8743.81]
["0x00073462","Honeydew","a649HVX","6PCGV7S","2018-04-12",98654.400000000009]
["0x00054D38","Feijoa","k2y3f16","BO6CF9U","2018-06-15",96513.91]
["0x00057AB7","Jambul","pjT9sUk","QIPJ9L8","2018-07-17",27805.91]
["0x00081D89","Blueberry","s0YwT1G","T4F2L1E","2018-05-14",81024.17]
["0x0008FF7A","Honeyberry","m9r96sP","3IEVQ6X","2018-07-25",3881.9900000000002]
["0x0004BAE2","Melon","hnxR85L","SIB9FD1","2018-03-15",94722.69]
["0x00070AAD","Plantain","SB740Kk","1M6618I","2018-05-10",6307.41]
["0x0008ECE7","Cloudberry","4yBMo88","Q63YSRE","2018-03-31",88845.26]
["0x000573C3","Durian","Wa2ReVL","P8RNHIJ","2018-02-15",23796.9]
["0x0008C6FF","Watermelon","JyP5fn6","2Q77D53","2018-07-17",53458.28]
["0x00040272","Plum","B0dWqWb","1QVFYK5","2018-07-13",82933.570000000007]
["0x00083C3E","Jabuticaba","4Ab7bVu","6W8XLAR","2018-02-11",3713.67]

{"sheet":"Sheet2","index":2,"n_rows":114,"n_cols":4,"rows_kept":114,"cut":false,"hidden":true,"merged":[]}
["Açaí",{"$f":"\"case \"&C1&\": FruitName=£\"&A1&\"£ \"","v":"case 1: FruitName=£Açaí£ "},1,{"$f":"[1]!FruitName(C1)=A1","v":true}]
["Apple",{"$f":"\"case \"&C2&\": FruitName=£\"&A2&\"£ \"","v":"case 2: FruitName=£Apple£ "},2,{"$f":"[1]!FruitName(C2)=A2","v":true}]
["Akee","case 3: FruitName=£Akee£ ",3,{"$f":"[1]!FruitName(C3)=A3","v":true}]
["Apricot","case 4: FruitName=£Apricot£ ",4,{"$f":"[1]!FruitName(C4)=A4","v":true}]
["Avocado","case 5: FruitName=£Avocado£ ",5,{"$f":"[1]!FruitName(C5)=A5","v":true}]
["Banana","case 6: FruitName=£Banana£ ",6,{"$f":"[1]!FruitName(C6)=A6","v":true}]
["Bilberry","case 7: FruitName=£Bilberry£ ",7,{"$f":"[1]!FruitName(C7)=A7","v":true}]
["Blackberry","case 8: FruitName=£Blackberry£ ",8,{"$f":"[1]!FruitName(C8)=A8","v":true}]
["Blackcurrant","case 9: FruitName=£Blackcurrant£ ",9,{"$f":"[1]!FruitName(C9)=A9","v":true}]
["Black sapote","case 10: FruitName=£Black sapote£ ",10,{"$f":"[1]!FruitName(C10)=A10","v":true}]
["Blueberry","case 11: FruitName=£Blueberry£ ",11,{"$f":"[1]!FruitName(C11)=A11","v":true}]
["Boysenberry","case 12: FruitName=£Boysenberry£ ",12,{"$f":"[1]!FruitName(C12)=A12","v":true}]
["Buddha's hand","case 13: FruitName=£Buddha's hand£ ",13,{"$f":"[1]!FruitName(C13)=A13","v":true}]
["Crab apples","case 14: FruitName=£Crab apples£ ",14,{"$f":"[1]!FruitName(C14)=A14","v":true}]
["Currant","case 15: FruitName=£Currant£ ",15,{"$f":"[1]!FruitName(C15)=A15","v":true}]
["Cherry","case 16: FruitName=£Cherry£ ",16,{"$f":"[1]!FruitName(C16)=A16","v":true}]
["Cherimoya","case 17: FruitName=£Cherimoya£ ",17,{"$f":"[1]!FruitName(C17)=A17","v":true}]
["Chico fruit","case 18: FruitName=£Chico fruit£ ",18,{"$f":"[1]!FruitName(C18)=A18","v":true}]
["Cloudberry","case 19: FruitName=£Cloudberry£ ",19,{"$f":"[1]!FruitName(C19)=A19","v":true}]
["Coconut","case 20: FruitName=£Coconut£ ",20,{"$f":"[1]!FruitName(C20)=A20","v":true}]
["Cranberry","case 21: FruitName=£Cranberry£ ",21,{"$f":"[1]!FruitName(C21)=A21","v":true}]
["Cucumber","case 22: FruitName=£Cucumber£ ",22,{"$f":"[1]!FruitName(C22)=A22","v":true}]
["Damson","case 23: FruitName=£Damson£ ",23,{"$f":"[1]!FruitName(C23)=A23","v":true}]
["Date","case 24: FruitName=£Date£ ",24,{"$f":"[1]!FruitName(C24)=A24","v":true}]
["Dragonfruit","case 25: FruitName=£Dragonfruit£ ",25,{"$f":"[1]!FruitName(C25)=A25","v":true}]
["Durian","case 26: FruitName=£Durian£ ",26,{"$f":"[1]!FruitName(C26)=A26","v":true}]
["Elderberry","case 27: FruitName=£Elderberry£ ",27,{"$f":"[1]!FruitName(C27)=A27","v":true}]
["Feijoa","case 28: FruitName=£Feijoa£ ",28,{"$f":"[1]!FruitName(C28)=A28","v":true}]
["Fig","case 29: FruitName=£Fig£ ",29,{"$f":"[1]!FruitName(C29)=A29","v":true}]
["Goji berry","case 30: FruitName=£Goji berry£ ",30,{"$f":"[1]!FruitName(C30)=A30","v":true}]
["Gooseberry","case 31: FruitName=£Gooseberry£ ",31,{"$f":"[1]!FruitName(C31)=A31","v":true}]
["Grape","case 32: FruitName=£Grape£ ",32,{"$f":"[1]!FruitName(C32)=A32","v":true}]
["Raisin","case 33: FruitName=£Raisin£ ",33,{"$f":"[1]!FruitName(C33)=A33","v":true}]
["Grapefruit","case 34: FruitName=£Grapefruit£ ",34,{"$f":"[1]!FruitName(C34)=A34","v":true}]
["Guava","case 35: FruitName=£Guava£ ",35,{"$f":"[1]!FruitName(C35)=A35","v":true}]
["Honeyberry","case 36: FruitName=£Honeyberry£ ",36,{"$f":"[1]!FruitName(C36)=A36","v":true}]
["Huckleberry","case 37: FruitName=£Huckleberry£ ",37,{"$f":"[1]!FruitName(C37)=A37","v":true}]
["Jabuticaba","case 38: FruitName=£Jabuticaba£ ",38,{"$f":"[1]!FruitName(C38)=A38","v":true}]
["Jackfruit","case 39: FruitName=£Jackfruit£ ",39,{"$f":"[1]!FruitName(C39)=A39","v":true}]
["Jambul","case 40: FruitName=£Jambul£ ",40,{"$f":"[1]!FruitName(C40)=A40","v":true}]
["Japanese plum","case 41: FruitName=£Japanese plum£ ",41,{"$f":"[1]!FruitName(C41)=A41","v":true}]
["Jostaberry","case 42: FruitName=£Jostaberry£ ",42,{"$f":"[1]!FruitName(C42)=A42","v":true}]
["Jujube","case 43: FruitName=£Jujube£ ",43,{"$f":"[1]!FruitName(C43)=A43","v":true}]
["Juniper berry","case 44: FruitName=£Juniper berry£ ",44,{"$f":"[1]!FruitName(C44)=A44","v":true}]
["Kiwano","case 45: FruitName=£Kiwano£ ",45,{"$f":"[1]!FruitName(C45)=A45","v":true}]
["Kiwifruit","case 46: FruitName=£Kiwifruit£ ",46,{"$f":"[1]!FruitName(C46)=A46","v":true}]
["Kumquat","case 47: FruitName=£Kumquat£ ",47,{"$f":"[1]!FruitName(C47)=A47","v":true}]
["Lemon","case 48: FruitName=£Lemon£ ",48,{"$f":"[1]!FruitName(C48)=A48","v":true}]
["Lime","case 49: FruitName=£Lime£ ",49,{"$f":"[1]!FruitName(C49)=A49","v":true}]
["Loquat","case 50: FruitName=£Loquat£ ",50,{"$f":"[1]!FruitName(C50)=A50","v":true}]
["Longan","case 51: FruitName=£Longan£ ",51,{"$f":"[1]!FruitName(C51)=A51","v":true}]
["Lychee","case 52: FruitName=£Lychee£ ",52,{"$f":"[1]!FruitName(C52)=A52","v":true}]
["Mango","case 53: FruitName=£Mango£ ",53,{"$f":"[1]!FruitName(C53)=A53","v":true}]
["Mangosteen","case 54: FruitName=£Mangosteen£ ",54,{"$f":"[1]!FruitName(C54)=A54","v":true}]
["Marionberry","case 55: FruitName=£Marionberry£ ",55,{"$f":"[1]!FruitName(C55)=A55","v":true}]
["Melon","case 56: FruitName=£Melon£ ",56,{"$f":"[1]!FruitName(C56)=A56","v":true}]
["Cantaloupe","case 57: FruitName=£Cantaloupe£ ",57,{"$f":"[1]!FruitName(C57)=A57","v":true}]
["Honeydew","case 58: FruitName=£Honeydew£ ",58,{"$f":"[1]!FruitName(C58)=A58","v":true}]
["Watermelon","case 59: FruitName=£Watermelon£ ",59,{"$f":"[1]!FruitName(C59)=A59","v":true}]
["Miracle fruit","case 60: FruitName=£Miracle fruit£ ",60,{"$f":"[1]!FruitName(C60)=A60","v":true}]
["Mulberry","case 61: FruitName=£Mulberry£ ",61,{"$f":"[1]!FruitName(C61)=A61","v":true}]
["Nectarine","case 62: FruitName=£Nectarine£ ",62,{"$f":"[1]!FruitName(C62)=A62","v":true}]
["Nance","case 63: FruitName=£Nance£ ",63,{"$f":"[1]!FruitName(C63)=A63","v":true}]
["Olive","case 64: FruitName=£Olive£ ",64,{"$f":"[1]!FruitName(C64)=A64","v":true}]
["Orange","case 65: FruitName=£Orange£ ",65,{"$f":"[1]!FruitName(C65)=A65","v":true}]
["Blood orange",{"$f":"\"case \"&C66&\": FruitName=£\"&A66&\"£ \"","v":"case 66: FruitName=£Blood orange£ "},66,{"$f":"[1]!FruitName(C66)=A66","v":true}]
["Clementine","case 67: FruitName=£Clementine£ ",67,{"$f":"[1]!FruitName(C67)=A67","v":true}]
["Mandarine","case 68: FruitName=£Mandarine£ ",68,{"$f":"[1]!FruitName(C68)=A68","v":true}]
["Tangerine","case 69: FruitName=£Tangerine£ ",69,{"$f":"[1]!FruitName(C69)=A69","v":true}]
["Papaya","case 70: FruitName=£Papaya£ ",70,{"$f":"[1]!FruitName(C70)=A70","v":true}]
["Passionfruit","case 71: FruitName=£Passionfruit£ ",71,{"$f":"[1]!FruitName(C71)=A71","v":true}]
["Peach","case 72: FruitName=£Peach£ ",72,{"$f":"[1]!FruitName(C72)=A72","v":true}]
["Pear","case 73: FruitName=£Pear£ ",73,{"$f":"[1]!FruitName(C73)=A73","v":true}]
["Persimmon","case 74: FruitName=£Persimmon£ ",74,{"$f":"[1]!FruitName(C74)=A74","v":true}]
["Plantain","case 75: FruitName=£Plantain£ ",75,{"$f":"[1]!FruitName(C75)=A75","v":true}]
["Plum","case 76: FruitName=£Plum£ ",76,{"$f":"[1]!FruitName(C76)=A76","v":true}]
["Prune","case 77: FruitName=£Prune£ ",77,{"$f":"[1]!FruitName(C77)=A77","v":true}]
["Pineapple","case 78: FruitName=£Pineapple£ ",78,{"$f":"[1]!FruitName(C78)=A78","v":true}]
["Pineberry","case 79: FruitName=£Pineberry£ ",79,{"$f":"[1]!FruitName(C79)=A79","v":true}]
["Plumcot","case 80: FruitName=£Plumcot£ ",80,{"$f":"[1]!FruitName(C80)=A80","v":true}]
["Pomegranate","case 81: FruitName=£Pomegranate£ ",81,{"$f":"[1]!FruitName(C81)=A81","v":true}]
["Pomelo","case 82: FruitName=£Pomelo£ ",82,{"$f":"[1]!FruitName(C82)=A82","v":true}]
["Purple mangosteen","case 83: FruitName=£Purple mangosteen£ ",83,{"$f":"[1]!FruitName(C83)=A83","v":true}]
["Quince","case 84: FruitName=£Quince£ ",84,{"$f":"[1]!FruitName(C84)=A84","v":true}]
["Raspberry","case 85: FruitName=£Raspberry£ ",85,{"$f":"[1]!FruitName(C85)=A85","v":true}]
["Salmonberry","case 86: FruitName=£Salmonberry£ ",86,{"$f":"[1]!FruitName(C86)=A86","v":true}]
["Rambutan","case 87: FruitName=£Rambutan£ ",87,{"$f":"[1]!FruitName(C87)=A87","v":true}]
["Redcurrant","case 88: FruitName=£Redcurrant£ ",88,{"$f":"[1]!FruitName(C88)=A88","v":true}]
["Salal berry","case 89: FruitName=£Salal berry£ ",89,{"$f":"[1]!FruitName(C89)=A89","v":true}]
["Salak","case 90: FruitName=£Salak£ ",90,{"$f":"[1]!FruitName(C90)=A90","v":true}]
["Satsuma","case 91: FruitName=£Satsuma£ ",91,{"$f":"[1]!FruitName(C91)=A91","v":true}]
["Soursop","case 92: FruitName=£Soursop£ ",92,{"$f":"[1]!FruitName(C92)=A92","v":true}]
["Star apple","case 93: FruitName=£Star apple£ ",93,{"$f":"[1]!FruitName(C93)=A93","v":true}]
["Star fruit","case 94: FruitName=£Star fruit£ ",94,{"$f":"[1]!FruitName(C94)=A94","v":true}]
["Strawberry","case 95: FruitName=£Strawberry£ ",95,{"$f":"[1]!FruitName(C95)=A95","v":true}]
["Surinam cherry","case 96: FruitName=£Surinam cherry£ ",96,{"$f":"[1]!FruitName(C96)=A96","v":true}]
["Tamarillo","case 97: FruitName=£Tamarillo£ ",97,{"$f":"[1]!FruitName(C97)=A97","v":true}]
["Tamarind","case 98: FruitName=£Tamarind£ ",98,{"$f":"[1]!FruitName(C98)=A98","v":true}]
["Ugli fruit","case 99: FruitName=£Ugli fruit£ ",99,{"$f":"[1]!FruitName(C99)=A99","v":true}]
["White currant","case 100: FruitName=£White currant£ ",100,{"$f":"[1]!FruitName(C100)=A100","v":true}]
["White sapote","case 101: FruitName=£White sapote£ ",101,{"$f":"[1]!FruitName(C101)=A101","v":true}]
["Yuzu","case 102: FruitName=£Yuzu£ ",102,{"$f":"[1]!FruitName(C102)=A102","v":true}]
["Avocado","case 103: FruitName=£Avocado£ ",103,{"$f":"[1]!FruitName(C103)=A103","v":true}]
["Chili pepper","case 104: FruitName=£Chili pepper£ ",104,{"$f":"[1]!FruitName(C104)=A104","v":true}]
["Corn kernel","case 105: FruitName=£Corn kernel£ ",105,{"$f":"[1]!FruitName(C105)=A105","v":true}]
["Cucumber","case 106: FruitName=£Cucumber£ ",106,{"$f":"[1]!FruitName(C106)=A106","v":true}]
["Eggplant","case 107: FruitName=£Eggplant£ ",107,{"$f":"[1]!FruitName(C107)=A107","v":true}]
["Olive","case 108: FruitName=£Olive£ ",108,{"$f":"[1]!FruitName(C108)=A108","v":true}]
["Pea","case 109: FruitName=£Pea£ ",109,{"$f":"[1]!FruitName(C109)=A109","v":true}]
["Pumpkin","case 110: FruitName=£Pumpkin£ ",110,{"$f":"[1]!FruitName(C110)=A110","v":true}]
["Squash","case 111: FruitName=£Squash£ ",111,{"$f":"[1]!FruitName(C111)=A111","v":true}]
["Tomato","case 112: FruitName=£Tomato£ ",112,{"$f":"[1]!FruitName(C112)=A112","v":true}]
["Zucchini","case 113: FruitName=£Zucchini£ ",113,{"$f":"[1]!FruitName(C113)=A113","v":true}]
[null,null,null,{"$f":"[1]!FruitName(C114)","v":"Durian"}]