{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","from cost","Formula","IF","ABS+IF","CONCAT","VBA","Conditional"],"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":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Weekly Sales Data of Amigo Super Store"]
[]
[null,"Seller","Timeline","Product","Cost Price","Selling Price"]
[null,"Alex","Jan 2-Jan 8 ,2023","Banana",1800,2500]
[null,"Melissa","Jan 2-Jan 8 ,2023","Orange",2400,2350]
[null,"Sam","Jan 2-Jan 8 ,2023","Banana",1900,1800]
[null,"Sofia","Jan 2-Jan 8 ,2023","Mango",2300,2900]
[null,"Afra","Jan 2-Jan 8 ,2023","Banana",3100,2900]

{"sheet":"from cost","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Weekly Sales Data of Amigo Super Store"]
[]
[null,"Seller","Cost Price","Selling Price","Net","Percentage"]
[null,"Alex",1800,2500,{"$f":"D6-C6","v":700},{"$f":"E6/C6","v":0.3888888888888889}]
[null,"Melissa",2400,2350,{"$f":"D7-C7","v":-50},{"$f":"E7/C7","v":-2.0833333333333332E-2}]
[null,"Sam",1900,1800,-100,-5.2631578947368418E-2]
[null,"Sofia",2300,2900,600,0.2608695652173913]
[null,"Afra",3100,2900,-200,-6.4516129032258063E-2]

{"sheet":"Formula","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Weekly Sales Data of Amigo Super Store"]
[]
[null,"Seller","Cost Price","Selling Price","Profit/Loss"]
[null,"Alex",1800,2500,{"$f":"S6","v":0}]
[null,"Melissa",2400,2350,{"$f":"(D7-C7)/C7","v":-2.0833333333333332E-2}]
[null,"Sam",1900,1800,-5.2631578947368418E-2]
[null,"Sofia",2300,2900,0.2608695652173913]
[null,"Afra",3100,2900,-6.4516129032258063E-2]

{"sheet":"IF","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Weekly Sales Data of Amigo Super Store"]
[]
[null,"Seller","Cost Price","Selling Price","Net","Profit/Loss"]
[null,"Alex",1800,2500,{"$f":"(D6-C6)/C6","v":0.3888888888888889},{"$f":"IF(E6>0,\"Profit\",\"Loss\")","v":"Profit"}]
[null,"Melissa",2400,2350,{"$f":"(D7-C7)/C7","v":-2.0833333333333332E-2},{"$f":"IF(E7>0,\"Profit\",\"Loss\")","v":"Loss"}]
[null,"Sam",1900,1800,-5.2631578947368418E-2,"Loss"]
[null,"Sofia",2300,2900,0.2608695652173913,"Profit"]
[null,"Afra",3100,2900,-6.4516129032258063E-2,"Loss"]

{"sheet":"ABS+IF","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Weekly Sales Data of Amigo Super Store"]
[]
[null,"Seller","Cost Price","Selling Price","Profit/Loss"]
[null,"Alex",1800,2500,{"$f":"ABS((D6-C6)/C6) & IF((D6-C6)/C6>0,\"% Profit\",\"% Loss\")","v":"0.388888888888889% Profit"}]
[null,"Melissa",2400,2350,{"$f":"ABS((D7-C7)/C7) & IF((D7-C7)/C7>0,\"% Profit\",\"% Loss\")","v":"0.0208333333333333% Loss"}]
[null,"Sam",1900,1800,"0.0526315789473684% Loss"]
[null,"Sofia",2300,2900,"0.260869565217391% Profit"]
[null,"Afra",3100,2900,"0.0645161290322581% Loss"]

{"sheet":"CONCAT","index":5,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"Weekly Sales Data of Amigo Super Store"]
[]
[null,"Seller","Cost Price","Selling Price","Net","Profit/Loss","Profit/Loss"]
[null,"Alex",1800,2500,{"$f":"(D6-C6)/C6","v":0.3888888888888889},{"$f":"IF(E6>0,\"Profit\",\"Loss\")","v":"Profit"},{"$f":"_xlfn.CONCAT(E6,\"% \",F6)","v":"0.388888888888889% Profit"}]
[null,"Melissa",2400,2350,{"$f":"(D7-C7)/C7","v":-2.0833333333333332E-2},{"$f":"IF(E7>0,\"Profit\",\"Loss\")","v":"Loss"},{"$f":"_xlfn.CONCAT(E7,\"% \",F7)","v":"-0.0208333333333333% Loss"}]
[null,"Sam",1900,1800,-5.2631578947368418E-2,"Loss","-0.0526315789473684% Loss"]
[null,"Sofia",2300,2900,0.2608695652173913,"Profit","0.260869565217391% Profit"]
[null,"Afra",3100,2900,-6.4516129032258063E-2,"Loss","-0.0645161290322581% Loss"]

{"sheet":"VBA","index":6,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Weekly Sales Data of Amigo Super Store"]
[]
[null,"Seller","Cost Price","Selling Price","Net","Profit/Loss"]
[null,"Alex",1800,2500]
[null,"Melissa",2400,2350]
[null,"Sam",1900,1800]
[null,"Sofia",2300,2900]
[null,"Afra",3100,2900]

{"sheet":"Conditional","index":7,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Weekly Sales Data of Amigo Super Store"]
[]
[null,"Seller","Cost Price","Selling Price","Profit/Loss"]
[null,"Alex",1800,2500,{"$f":"(D6-C6)/C6","v":0.3888888888888889}]
[null,"Melissa",2400,2350,{"$f":"(D7-C7)/C7","v":-2.0833333333333332E-2}]
[null,"Sam",1900,1800,-5.2631578947368418E-2]
[null,"Sofia",2300,2900,0.2608695652173913]
[null,"Afra",3100,2900,-6.4516129032258063E-2]