{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","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":"Sheet1","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Inserting Shapes Icon Based on Percentage"]
[]
[null,"Name","Math Score","Percentage"]
[null,"Ricky",90,{"$f":"C5/100","v":0.9}]
[null,"Ponting",25,{"$f":"C6/100","v":0.25}]
[null,"Mike",80,0.8]
[null,"Hussey",12,0.08]
[null,"Adam",65,0.65]
[null,"Gilchrist",100,1]
[null,"Brett",30,0.3]
[null,"Lee",60,0.6]

{"sheet":"Sheet2","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Inserting Indicators Icon Sets Based on Percentage"]
[]
[null,"Tasks","Completion"]
[null,"Task 1",1]
[null,"Task 2",0.25]
[null,"Task 3",0]
[null,"Task 4",1]
[null,"Task 5",0.12]
[null,"Task 6",0]
[null,"Task 7",1]
[null,"Task 8",0.6]

{"sheet":"Sheet3","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Inserting Directional Sets Icon Based on Percentage"]
[]
[null,"Company","Price","Change"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B5,\"Price\")","v":137.83000000000001},{"$f":"_FV(B5,\"Change (%)\",TRUE)","v":-1.1332999999999999E-2}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B6,\"Price\")","v":196.65},{"$f":"_FV(B6,\"Change (%)\",TRUE)","v":2.856E-3}]
[null,{"$error":"#VALUE!"},196.65,{"$f":"_FV(B7,\"Change (%)\",TRUE)","v":7.0630000000000007E-3}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B8,\"Price\")","v":164.85},{"$f":"_FV(B8,\"Change (%)\",TRUE)","v":-6.2690000000000003E-3}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B9,\"Price\")","v":164.92},0]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B10,\"Price\")","v":128.87},{"$f":"_FV(B10,\"Change (%)\",TRUE)","v":9.8740000000000008E-3}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B11,\"Price\")","v":117.5},{"$f":"_FV(B11,\"Change (%)\",TRUE)","v":-5.4169999999999999E-3}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B12,\"Price\")","v":428.55},0]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B13,\"Price\")","v":34.520000000000003},{"$f":"_FV(B13,\"Change (%)\",TRUE)","v":-2.4308E-2}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B14,\"Price\")","v":63.05},{"$f":"_FV(B14,\"Change (%)\",TRUE)","v":1.2700000000000001E-3}]

{"sheet":"Sheet4","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Inserting Ratings Icon Sets Based on Percentage"]
[]
[null,"Tasks","Completion"]
[null,"Task 1",1]
[null,"Task 2",0.4]
[null,"Task 3",0]
[null,"Task 4",1]
[null,"Task 5",0.12]
[null,"Task 6",0.2]
[null,"Task 7",1]
[null,"Task 8",0.6]

{"sheet":"VBA","index":4,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using VBA"]
[]
[null,"Product Id","Quantity","Unit Price","Cost","Revenue","Profit Margin"]
[null,"A-051456",35,785,{"$f":"D5*C5","v":27475},29000,{"$f":"(F5-E5)/F5","v":5.2586206896551725E-2}]
[null,"A-021547",54,6582,355428,356890,4.0965003222281377E-3]
[null,"A-031021",45,156,7020,7020,0]
[null,"C-012145",73,145,10585,11000,-0.02]
[null,"B-000154",85,45,3825,3550,-7.746478873239436E-2]
[null,"A-032145",15,351,5265,6500,0.19]
[null,"C-001458",95,254,24130,22000,-9.6818181818181817E-2]
[null,"D-562314",82,265,21730,23000,5.5217391304347829E-2]
[null,"F-652154",25,25,625,625,0]