{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","one cell","Multiple Cells","Format","Multiple Conditions","VBA"],"not_rendered":{"charts":0,"images":1,"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":"Dataset","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"List of Products"]
[]
[null,"Product","Sales","Profit/Loss"]
[null,"Kiwi",4419,67]
[null,"Cherries",3596,39]
[null,"Guava",3955,-98]
[null,"Apple",2012,145]
[null,"Orange",3980,147]
[null,"Strawberries",3648,-37]
[null,"Tomato",4688,47]
[null,"Lemon",2695,-194]

{"sheet":"one cell","index":1,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,15,1,17]]}
[]
[null,"Linking One Cell to a Text Box",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Product","Sales","Profit/Loss",null,null,null,null,null,null,null,null,null,null,null,"Product","Sales","Profit/Loss"]
[null,"Kiwi",4419,67,null,null,null,null,null,null,null,null,null,null,null,"Kiwi",4419,67]
[null,"Cherries",3596,39,null,null,null,null,null,null,null,null,null,null,null,"Cherries",3596,39]
[null,"Guava",3955,-98,null,null,null,null,null,null,null,null,null,null,null,"Guava",3955,-98]
[null,"Apple",2012,145,null,null,null,null,null,null,null,null,null,null,null,"Apple",2012,145]
[null,"Orange",3980,147,null,null,null,null,null,null,null,null,null,null,null,"Orange",3980,147]
[null,"Strawberries",3648,-37,null,null,null,null,null,null,null,null,null,null,null,"Strawberries",3648,-37]
[null,"Tomato",4688,47,null,null,null,null,null,null,null,null,null,null,null,"Tomato",4688,47]
[null,"Lemon",2695,-194,null,null,null,null,null,null,null,null,null,null,null,"Lemon",2695,-194]
[null,"Total",{"$f":"SUM(C5:C12)","v":28993},null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q5:Q12)","v":28993}]

{"sheet":"Multiple Cells","index":2,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,15,1,17]]}
[]
[null,"Linking Multiple Cells to a Text Box",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Product","Sales","Profit/Loss",null,null,null,null,null,null,null,null,null,null,null,"Product","Sales","Profit/Loss"]
[null,"Kiwi",4419,67,null,null,null,null,null,null,null,null,null,null,null,"Kiwi",4419,67]
[null,"Cherries",3596,39,null,null,null,null,null,null,null,null,null,null,null,"Cherries",3596,39]
[null,"Guava",3955,-98,null,null,null,null,null,null,null,null,null,null,null,"Guava",3955,-98]
[null,"Apple",2012,145,null,null,null,null,null,null,null,null,null,null,null,"Apple",2012,145]
[null,"Orange",3980,147,null,null,null,null,null,null,null,null,null,null,null,"Orange",3980,147]
[null,"Strawberries",3648,-37,null,null,null,null,null,null,null,null,null,null,null,"Strawberries",3648,-37]
[null,"Tomato",4688,47,null,null,null,null,null,null,null,null,null,null,null,"Tomato",4688,47]
[null,"Lemon",2695,-194,null,null,null,null,null,null,null,null,null,null,null,"Lemon",2695,-194]
[null,"Total",{"$f":"SUM(C5:C12)","v":28993},null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q5:Q12)","v":28993}]
[null,{"$f":"CONCATENATE($B$13, \" \",$C$13)","v":"Total 28993"}]

{"sheet":"Format","index":3,"n_rows":15,"n_cols":19,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[14,1,14,3],[1,16,1,18]]}
[]
[null,"Linking Values with Formatting to a Text Box",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Product","Sales","Profit/Loss",null,null,null,null,null,null,null,null,null,null,null,null,"Product","Sales","Profit/Loss"]
[null,"Kiwi",4419,67,null,null,null,null,null,null,null,null,null,null,null,null,"Kiwi",4419,67]
[null,"Cherries",3596,39,null,null,null,null,null,null,null,null,null,null,null,null,"Cherries",3596,39]
[null,"Guava",3955,-98,null,null,null,null,null,null,null,null,null,null,null,null,"Guava",3955,-98]
[null,"Apple",2012,145,null,null,null,null,null,null,null,null,null,null,null,null,"Apple",2012,145]
[null,"Orange",3980,147,null,null,null,null,null,null,null,null,null,null,null,null,"Orange",3980,147]
[null,"Strawberries",3648,-37,null,null,null,null,null,null,null,null,null,null,null,null,"Strawberries",3648,-37]
[null,"Tomato",4688,47,null,null,null,null,null,null,null,null,null,null,null,null,"Tomato",4688,47]
[null,"Lemon",2695,-194,null,null,null,null,null,null,null,null,null,null,null,null,"Lemon",2695,-194]
[null,"Total",{"$f":"SUM(C5:C12)","v":28993},null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R5:R12)","v":28993}]
[]
[null,{"$f":"\"The Total Sales Value is \"&TEXT(C13,\"$##,##0.00\")","v":"The Total Sales Value is $28,993.00"}]

{"sheet":"Multiple Conditions","index":4,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[14,1,14,3],[1,15,1,17]]}
[]
[null,"Linking Values with Multiple Conditions to a Text Box",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Product","Sales","Profit/Loss",null,null,null,null,null,null,null,null,null,null,null,"Product","Sales","Profit/Loss"]
[null,"Kiwi",4419,67,null,null,null,null,null,null,null,null,null,null,null,"Kiwi",4419,67]
[null,"Cherries",3596,39,null,null,null,null,null,null,null,null,null,null,null,"Cherries",3596,39]
[null,"Guava",3955,-98,null,null,null,null,null,null,null,null,null,null,null,"Guava",3955,-98]
[null,"Apple",2012,145,null,null,null,null,null,null,null,null,null,null,null,"Apple",2012,145]
[null,"Orange",3980,147,null,null,null,null,null,null,null,null,null,null,null,"Orange",3980,147]
[null,"Strawberries",3648,-37,null,null,null,null,null,null,null,null,null,null,null,"Strawberries",3648,-37]
[null,"Tomato",4688,47,null,null,null,null,null,null,null,null,null,null,null,"Tomato",4688,47]
[null,"Lemon",2695,-194,null,null,null,null,null,null,null,null,null,null,null,"Lemon",2695,-194]
[null,null,"Total",{"$f":"SUM(D5:D12)","v":116},null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R5:R12)","v":116}]
[]
[null,{"$f":"IF(D13<0,\"The Loss value is \"&TEXT(-D13,\"$##,##0.00\"),\" The Profit Value is \"&TEXT(D13,\"$##,##0.00\"))","v":" The Profit Value is $116.00"}]

{"sheet":"VBA","index":5,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,15,1,17]]}
[]
[null,"Utilizing ActiveX Control Text Box",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Product","Sales","Profit/Loss",null,null,null,null,null,null,null,null,null,null,null,"Product","Sales","Profit/Loss"]
[null,"Kiwi",4419,67,null,null,null,null,null,null,null,null,null,null,null,"Kiwi",4419,67]
[null,"Cherries",3596,39,null,null,null,null,null,null,null,null,null,null,null,"Cherries",3596,39]
[null,"Guava",3955,-98,null,null,null,null,null,null,null,null,null,null,null,"Guava",3955,-98]
[null,"Apple",2012,145,null,null,null,null,null,null,null,null,null,null,null,"Apple",2012,145]
[null,"Orange",3980,147,null,null,null,null,null,null,null,null,null,null,null,"Orange",3980,147]
[null,"Strawberries",3648,-37,null,null,null,null,null,null,null,null,null,null,null,"Strawberries",3648,-37]
[null,"Tomato",4688,47,null,null,null,null,null,null,null,null,null,null,null,"Tomato",4688,47]
[null,"Lemon",2695,-194,null,null,null,null,null,null,null,null,null,null,null,"Lemon",2695,-194]
[null,"Total",{"$f":"SUM(C5:C12)","v":28993},null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q5:Q12)","v":28993}]