{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Title","Sheet5","Data","Wrap Up"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2160]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: PublicDomainPictures / Pixabay"]

{"sheet":"Sheet5","index":1,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Cost Center","Total"]
[1001,35294.480000000003]
[1002,57067.77]
[1003,27742.230000000003]
[1004,73788.039999999994]
[1005,46298.020000000004]
[1006,46853.649999999994]
[1007,69346.22]
[1008,49418.23000000001]
[1009,18768.900000000001]
[1010,56621.07]
[1011,43407.450000000004]
[1012,49765.24]
[1013,21102.720000000001]
[1014,49126.39]
[1015,20683.55]
[1016,28718.649999999998]
[1017,34115.520000000004]
[1018,37764.92]
[1019,56331.22]
[1020,55926.490000000005]
[1021,41166.050000000003]
[1022,21047.24]
[1023,29955.579999999998]
[1024,47186.259999999995]
[1025,34131.21]
[1026,36788.620000000003]
[1027,19907.810000000001]
[1028,59104.85]
[1029,33623.479999999996]
[1030,34700.53]

{"sheet":"Data","index":2,"n_rows":60,"n_cols":3,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Cost Center","Total","Details"]
[1001,{"$f":"_xlfn.IFNA(VLOOKUP(A2,MyData_1[],2,FALSE),\"\")","v":35294.480000000003},"Elderberry - $4,112.84\nElderberry - $2,389.96\nRaspberry - $1,155.96\nTangerine - $4,725.14\nJackfruit - $6,706.99\nApple - $1,609.90 - Plus a note here\nSomething - $1000 - Just added\nZucchini - $6,909.86\nOrange - $6,683.83 - Don't double dip"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A3,MyData_1[],2,FALSE),\"\")","v":""}]
[1002,{"$f":"_xlfn.IFNA(VLOOKUP(A4,MyData_1[],2,FALSE),\"\")","v":57067.77},"Star fruit - $3,536.84\nFig - $9,720.60\nQuince - $9,022.60\nDate - $3,308.67\nPlum - $9,638.22\nJackfruit - $1,280.15 - Plus a note here\nHoneydew - $7,909.68\nVanilla - $1,623.00 - Don't double dip\nElderberry - $7,697.31\nWatermelon - $3,330.70"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A5,MyData_1[],2,FALSE),\"\")","v":""}]
[1003,{"$f":"_xlfn.IFNA(VLOOKUP(A6,MyData_1[],2,FALSE),\"\")","v":27742.230000000003},"Mango - $627.37\nMango - $7,264.25\nCherry - $6,066.01\nJackfruit - $4,010.66\nStar fruit - $9,773.94"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A7,MyData_1[],2,FALSE),\"\")","v":""}]
[1004,{"$f":"_xlfn.IFNA(VLOOKUP(A8,MyData_1[],2,FALSE),\"\")","v":73788.039999999994},"Quince - $7,406.04\nQuince - $8,409.02\nDate - $7,815.32\nApple - $9,030.06\nQuince - $7,527.13\nQuince - $4,364.88 - Plus a note here\nTangerine - $8,207.25\nBanana - $4,449.09 - Don't double dip\nCherry - $9,169.65\nZucchini - $7,409.60"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A9,MyData_1[],2,FALSE),\"\")","v":""}]
[1005,{"$f":"_xlfn.IFNA(VLOOKUP(A10,MyData_1[],2,FALSE),\"\")","v":46298.020000000004},"Banana - $8,243.90\nOrange - $3,014.10\nQuince - $7,209.86\nCherry - $2,130.98\nTangerine - $8,863.28\nYuzu - $5,912.82 - Plus a note here\nDate - $7,088.12\nPlum - $3,834.96 - Don't double dip"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A11,MyData_1[],2,FALSE),\"\")","v":""}]
[1006,{"$f":"_xlfn.IFNA(VLOOKUP(A12,MyData_1[],2,FALSE),\"\")","v":46853.649999999994},"Cherry - $3,228.38\nYuzu - $1,964.42\nUgli fruit - $8,421.35\nHoneydew - $4,537.74\nBanana - $5,963.49\nXigua - $4,561.36 - Plus a note here\nTangerine - $4,370.96\nOrange - $9,629.53 - Don't double dip\nQuince - $4,176.42"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A13,MyData_1[],2,FALSE),\"\")","v":""}]
[1007,{"$f":"_xlfn.IFNA(VLOOKUP(A14,MyData_1[],2,FALSE),\"\")","v":69346.22},"Lime - $4,133.46\nGuava - $8,585.52\nApple - $7,601.55\nTangerine - $7,294.91\nStar fruit - $9,677.48\nTangerine - $4,612.74 - Plus a note here\nOrange - $9,596.76\nLime - $8,535.12 - Don't double dip\nElderberry - $3,549.50\nOrange - $5,759.18"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A15,MyData_1[],2,FALSE),\"\")","v":""}]
[1008,{"$f":"_xlfn.IFNA(VLOOKUP(A16,MyData_1[],2,FALSE),\"\")","v":49418.23000000001},"Honeydew - $3,439.72\nOrange - $2,214.69\nCherry - $8,864.25\nZucchini - $3,002.03\nKiwi - $7,573.72\nCherry - $8,530.50 - Plus a note here\nJackfruit - $261.66\nBanana - $3,935.73 - Don't double dip\nTangerine - $8,597.18\nYuzu - $2,998.75"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A17,MyData_1[],2,FALSE),\"\")","v":""}]
[1009,{"$f":"_xlfn.IFNA(VLOOKUP(A18,MyData_1[],2,FALSE),\"\")","v":18768.900000000001},"Guava - $1,221.39\nIceberg - $2,791.13\nZucchini - $5,358.31\nNectarine - $5,697.09\nElderberry - $3,700.98"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A19,MyData_1[],2,FALSE),\"\")","v":""}]
[1010,{"$f":"_xlfn.IFNA(VLOOKUP(A20,MyData_1[],2,FALSE),\"\")","v":56621.07},"Quince - $9,421.13\nJackfruit - $3,661.11\nWatermelon - $4,482.45\nVanilla - $9,807.77\nXigua - $5,173.26\nTangerine - $6,278.12 - Plus a note here\nStar fruit - $7,325.56\nOrange - $9,976.75 - Don't double dip\nStar fruit - $494.92"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A21,MyData_1[],2,FALSE),\"\")","v":""}]
[1011,{"$f":"_xlfn.IFNA(VLOOKUP(A22,MyData_1[],2,FALSE),\"\")","v":43407.450000000004},"Star fruit - $1,102.61\nDate - $2,885.45\nMango - $638.30\nIceberg - $8,172.81\nRaspberry - $5,390.42\nFig - $3,439.22 - Plus a note here\nTangerine - $5,207.99\nLime - $8,381.62 - Don't double dip\nStar fruit - $8,189.03"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A23,MyData_1[],2,FALSE),\"\")","v":""}]
[1012,{"$f":"_xlfn.IFNA(VLOOKUP(A24,MyData_1[],2,FALSE),\"\")","v":49765.24},"Raspberry - $5,772.45\nMango - $9,452.73\nNectarine - $2,737.82\nTangerine - $5,869.70\nBanana - $5,515.64\nDate - $4,073.39 - Plus a note here\nWatermelon - $4,468.89\nYuzu - $9,863.41 - Don't double dip\nWatermelon - $2,011.21"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A25,MyData_1[],2,FALSE),\"\")","v":""}]
[1013,{"$f":"_xlfn.IFNA(VLOOKUP(A26,MyData_1[],2,FALSE),\"\")","v":21102.720000000001},"Fig - $1,609.31\nJackfruit - $5,934.18\nRaspberry - $1,123.95\nZucchini - $2,420.19\nLime - $1,566.18\nLime - $7,965.62 - Plus a note here\nJackfruit - $483.29"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A27,MyData_1[],2,FALSE),\"\")","v":""}]
[1014,{"$f":"_xlfn.IFNA(VLOOKUP(A28,MyData_1[],2,FALSE),\"\")","v":49126.39},"Lime - $4,555.10\nDate - $3,215.41\nStar fruit - $2,951.09\nBanana - $7,946.73\nYuzu - $8,484.92\nXigua - $1,748.70 - Plus a note here\nIceberg - $7,585.30\nUgli fruit - $3,566.33 - Don't double dip\nPlum - $9,072.81"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A29,MyData_1[],2,FALSE),\"\")","v":""}]
[1015,{"$f":"_xlfn.IFNA(VLOOKUP(A30,MyData_1[],2,FALSE),\"\")","v":20683.55},"Raspberry - $4,838.07\nCherry - $3,385.94\nHoneydew - $2,293.40\nRaspberry - $6,288.43\nCherry - $3,877.71"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A31,MyData_1[],2,FALSE),\"\")","v":""}]
[1016,{"$f":"_xlfn.IFNA(VLOOKUP(A32,MyData_1[],2,FALSE),\"\")","v":28718.649999999998},"Ugli fruit - $5,735.41\nWatermelon - $5,599.16\nXigua - $2,687.81\nQuince - $308.14\nBanana - $6,237.31\nXigua - $3,196.27 - Plus a note here\nPlum - $450.39\nDate - $4,504.16 - Don't double dip"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A33,MyData_1[],2,FALSE),\"\")","v":""}]
[1017,{"$f":"_xlfn.IFNA(VLOOKUP(A34,MyData_1[],2,FALSE),\"\")","v":34115.520000000004},"Ugli fruit - $5,171.31\nXigua - $1,031.96\nMango - $9,168.43\nPlum - $938.19\nApple - $8,107.31\nBanana - $9,698.32 - Plus a note here"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A35,MyData_1[],2,FALSE),\"\")","v":""}]
[1018,{"$f":"_xlfn.IFNA(VLOOKUP(A36,MyData_1[],2,FALSE),\"\")","v":37764.92},"Iceberg - $5,862.55\nTangerine - $9,028.16\nDate - $9,563.40\nApple - $4,321.75\nOrange - $4,745.68\nGuava - $4,243.38 - Plus a note here"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A37,MyData_1[],2,FALSE),\"\")","v":""}]
[1019,{"$f":"_xlfn.IFNA(VLOOKUP(A38,MyData_1[],2,FALSE),\"\")","v":56331.22},"Zucchini - $9,270.65\nQuince - $4,103.20\nGuava - $2,336.80\nNectarine - $1,873.61\nCherry - $8,369.36\nElderberry - $8,967.15 - Plus a note here\nZucchini - $6,816.69\nElderberry - $1,019.24 - Don't double dip\nYuzu - $5,064.52\nYuzu - $8,510.00"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A39,MyData_1[],2,FALSE),\"\")","v":""}]
[1020,{"$f":"_xlfn.IFNA(VLOOKUP(A40,MyData_1[],2,FALSE),\"\")","v":55926.490000000005},"Jackfruit - $2,238.52\nElderberry - $6,844.03\nNectarine - $9,574.57\nNectarine - $7,070.74\nZucchini - $2,845.14\nElderberry - $3,451.09 - Plus a note here\nXigua - $4,756.92\nTangerine - $8,630.20 - Don't double dip\nBanana - $2,532.50\nYuzu - $7,982.78"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A41,MyData_1[],2,FALSE),\"\")","v":""}]
[1021,{"$f":"_xlfn.IFNA(VLOOKUP(A42,MyData_1[],2,FALSE),\"\")","v":41166.050000000003},"Quince - $3,755.14\nWatermelon - $8,822.95\nApple - $3,514.55\nElderberry - $2,060.21\nGuava - $3,592.43\nQuince - $2,900.98 - Plus a note here\nCherry - $3,107.30\nElderberry - $4,285.95 - Don't double dip\nVanilla - $9,126.54"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A43,MyData_1[],2,FALSE),\"\")","v":""}]
[1022,{"$f":"_xlfn.IFNA(VLOOKUP(A44,MyData_1[],2,FALSE),\"\")","v":21047.24},"Date - $8,377.19\nJackfruit - $524.75\nIceberg - $816.27\nFig - $4,727.68\nTangerine - $6,601.35"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A45,MyData_1[],2,FALSE),\"\")","v":""}]
[1023,{"$f":"_xlfn.IFNA(VLOOKUP(A46,MyData_1[],2,FALSE),\"\")","v":29955.579999999998},"Orange - $7,585.77\nJackfruit - $1,549.96\nMango - $7,171.50\nJackfruit - $7,251.94\nFig - $6,396.41"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A47,MyData_1[],2,FALSE),\"\")","v":""}]
[1024,{"$f":"_xlfn.IFNA(VLOOKUP(A48,MyData_1[],2,FALSE),\"\")","v":47186.259999999995},"Quince - $7,661.57\nJackfruit - $6,723.86\nMango - $3,061.96\nOrange - $3,281.52\nBanana - $4,062.96\nStar fruit - $9,077.73 - Plus a note here\nVanilla - $9,738.02\nDate - $1,357.22 - Don't double dip\nMango - $2,221.42"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A49,MyData_1[],2,FALSE),\"\")","v":""}]
[1025,{"$f":"_xlfn.IFNA(VLOOKUP(A50,MyData_1[],2,FALSE),\"\")","v":34131.21},"Guava - $5,361.73\nJackfruit - $1,530.03\nJackfruit - $2,200.47\nTangerine - $8,756.85\nApple - $6,162.93\nMango - $5,237.57 - Plus a note here\nFig - $3,916.32\nNectarine - $965.31 - Don't double dip"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A51,MyData_1[],2,FALSE),\"\")","v":""}]
[1026,{"$f":"_xlfn.IFNA(VLOOKUP(A52,MyData_1[],2,FALSE),\"\")","v":36788.620000000003},"Watermelon - $2,864.56\nVanilla - $5,078.97\nOrange - $9,620.89\nPlum - $159.58\nGuava - $368.01\nIceberg - $7,384.62 - Plus a note here\nDate - $471.99\nTangerine - $8,928.46 - Don't double dip\nFig - $1,911.54"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A53,MyData_1[],2,FALSE),\"\")","v":""}]
[1027,{"$f":"_xlfn.IFNA(VLOOKUP(A54,MyData_1[],2,FALSE),\"\")","v":19907.810000000001},"Vanilla - $4,812.40\nUgli fruit - $5,714.93\nVanilla - $5,008.34\nPlum - $2,260.73\nYuzu - $2,111.41"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A55,MyData_1[],2,FALSE),\"\")","v":""}]
[1028,{"$f":"_xlfn.IFNA(VLOOKUP(A56,MyData_1[],2,FALSE),\"\")","v":59104.85},"Mango - $8,274.88\nOrange - $6,219.35\nApple - $8,537.17\nKiwi - $3,600.98\nHoneydew - $194.81\nStar fruit - $5,439.41 - Plus a note here\nStar fruit - $6,393.70\nElderberry - $5,427.89 - Don't double dip\nCherry - $7,356.09\nPlum - $7,660.57"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A57,MyData_1[],2,FALSE),\"\")","v":""}]
[1029,{"$f":"_xlfn.IFNA(VLOOKUP(A58,MyData_1[],2,FALSE),\"\")","v":33623.479999999996},"Jackfruit - $8,872.39\nXigua - $5,882.78\nJackfruit - $2,530.34\nGuava - $4,497.39\nStar fruit - $2,003.26\nNectarine - $9,837.32 - Plus a note here"]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(A59,MyData_1[],2,FALSE),\"\")","v":""}]
[1030,{"$f":"_xlfn.IFNA(VLOOKUP(A60,MyData_1[],2,FALSE),\"\")","v":34700.53},"Jackfruit - $6,264.21\nRaspberry - $4,900.77\nHoneydew - $3,391.54\nUgli fruit - $7,958.38\nDate - $2,826.70\nPlum - $3,643.90 - Plus a note here\nQuince - $320.60\nFig - $5,394.43 - Don't double dip"]

{"sheet":"Wrap Up","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Steve has to sum numbers that have been entered in a text column"]
[null,"There are multiple lines in each cell, separated by Alt Enter"]
[null,"Need to split those lines to rows, then parse the dollar amount from the middle of each cell"]
[null,"Summarize by Cost Center"]
[null,"Build a lookup table"]
[null,"Get totals from the lookup table, using IFNA to ignore the errors in the blank row"]
[null,"Bonus: Add an Event macro to update the worksheet when they change a cell."]