{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Unable to Recognize","Thousand and Decimal","Formatted as Text","Text to Number","Excel VBA"],"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":"Dataset","index":0,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,4,11,5],[1,1,1,6],[12,4,12,5]]}
[]
[null,"Overview of Datasets"]
[]
[null,"Sales Rep","Salary ($)",null,"Sales Rep","Product","Price ($)"]
[null,"Olivia","1.499,00",null,"Olivia","Laptop",1499]
[null,"Noah","3.138,00",null,"Noah","Headset",138]
[null,"Emma","469,00",null,"Emma","Mouse",69]
[null,"Oliver","974,00",null,"Oliver","Keyboard",74]
[null,"Charlotte","2.388,00",null,"Charlotte","Webcam",88]
[null,"Elijah","2.103,00",null,"Elijah","Monitor",103]
[]
[null,"Total Salary ($)",{"$f":"SUM(C5:C10)","v":0},null,"Total Price ($)",null,{"$f":"SUM(G5:G10)","v":1971}]
[null,"Formula",{"$f":"_xlfn.FORMULATEXT(C12)","v":"=SUM(C5:C10)"},null,"Formula",null,{"$f":"_xlfn.FORMULATEXT(G12)","v":"=SUM(G5:G10)"}]

{"sheet":"Unable to Recognize","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Unable to Recognize Numbers"]
[]
[null,"Sales Rep","Salary ($)"]
[null,"Olivia","1.499,00"]
[null,"Noah","3.138,00"]
[null,"Emma","469,00"]
[null,"Oliver","974,00"]
[null,"Charlotte","2.388,00"]
[null,"Elijah","2.103,00"]
[]
[null,"Total Salary($)",{"$f":"SUM(C5:C10)","v":0}]

{"sheet":"Thousand and Decimal","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,1,11,2],[1,1,1,3]]}
[]
[null,"Romoving Thousand and Decimal Separators"]
[]
[null,"Sales Rep","Salary ($)","Formatted Salary"]
[null,"Olivia","1.499,00",1499]
[null,"Noah","3.138,00",3138]
[null,"Emma","469,00",469]
[null,"Oliver","974,00",974]
[null,"Charlotte","2.388,00",2388]
[null,"Elijah","2.103,00",2103]
[]
[null,"Total Salary ($)",null,{"$f":"SUM(D5:D10)","v":10571}]

{"sheet":"Formatted as Text","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2]]}
[]
[null,"Number are Formatted as Text"]
[]
[null,"Sales Rep","Product","Price ($)"]
[null,"Olivia","Laptop","1499.00"]
[null,"Noah","Headset","138.00"]
[null,"Emma","Mouse","69.00"]
[null,"Oliver","Keyboard","74.00"]
[null,"Charlotte","Webcam","88.00"]
[null,"Elijah","Monitor","103.00"]
[]
[null,"Total Price ($)",null,{"$f":"SUM(D5:D10)","v":0}]

{"sheet":"Text to Number","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,1,11,2],[1,1,1,3]]}
[]
[null,"Utilizing Error Sign Option"]
[]
[null,"Sales Rep","Product","Price ($)"]
[null,"Olivia","Laptop",1499]
[null,"Noah","Headset",138]
[null,"Emma","Mouse",69]
[null,"Oliver","Keyboard",74]
[null,"Charlotte","Webcam",88]
[null,"Elijah","Monitor",103]
[]
[null,"Total Price ($)",null,{"$f":"SUM(D5:D10)","v":1971}]

{"sheet":"Excel VBA","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2]]}
[]
[null,"Running Excel VBA Code"]
[]
[null,"Sales Rep","Product","Price ($)"]
[null,"Olivia","Laptop",1499]
[null,"Noah","Headset",138]
[null,"Emma","Mouse",69]
[null,"Oliver","Keyboard",74]
[null,"Charlotte","Webcam",88]
[null,"Elijah","Monitor",103]
[]
[null,"Total Price ($)",null,{"$f":"SUM(D5:D10)","v":1971}]