{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Gross","Operating","Net","Table","VBA","Practice"],"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":[[1,1,1,6]]}
[]
[null,"\"XYZ\" Company"]
[]
[null,"Product","Selling Price","Cost of \nGoods","Operational\n Cost","Interest","Tax"]
[null,"Shirt1",2721,1045,300,90,30]
[null,"Shirt2",2172,1000,296,98,45]
[null,"Shirt3",2958,1200,345,100,39]
[null,"Jacket1",3405,1245,350,110,45]
[null,"Jacket2",2154,780,290,68,20]
[null,"Jacket3",2580,890,256,63,29]
[null,"Pant1",4316,2560,430,100,39]
[null,"Pant2",4815,2600,500,87,40]
[null,"Pant3",4792,2220,480,90,38]

{"sheet":"Gross","index":1,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Gross Profit Margin Percentage"]
[]
[null,"Product","Selling Price","Cost of \nGoods","Gross Profit Margin"]
[null,"Shirt1",2721,1045,{"$f":"(C5-D5)/C5","v":0.61595001837559715}]
[null,"Shirt2",2172,1000,{"$f":"(C6-D6)/C6","v":0.53959484346224673}]
[null,"Shirt3",2958,1200,0.59432048681541583]
[null,"Jacket1",3405,1245,0.63436123348017626]
[null,"Jacket2",2154,780,0.63788300835654599]
[null,"Jacket3",2580,890,0.65503875968992253]
[null,"Pant1",4316,2560,0.40685820203892492]
[null,"Pant2",4815,2600,0.46002076843198336]
[null,"Pant3",4792,2220,0.53672787979966607]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Operating","index":2,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Operating Profit Margin Percentage"]
[]
[null,"Product","Selling Price","Cost of \nGoods","Operational\n Cost","Operating \nProfit Margin"]
[null,"Shirt1",2721,1045,300,{"$f":"(C5-D5-E5)/C5","v":0.50569643513414186}]
[null,"Shirt2",2172,1000,296,{"$f":"(C6-D6-E6)/C6","v":0.40331491712707185}]
[null,"Shirt3",2958,1200,345,0.47768762677484788]
[null,"Jacket1",3405,1245,350,0.53157121879588842]
[null,"Jacket2",2154,780,290,0.50324976787372333]
[null,"Jacket3",2580,890,256,0.55581395348837215]
[null,"Pant1",4316,2560,430,0.30722891566265059]
[null,"Pant2",4815,2600,500,0.35617860851505712]
[null,"Pant3",4792,2220,480,0.43656093489148579]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Net","index":3,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Net Profit Margin Percentage"]
[]
[null,"Product","Selling Price","Cost of \nGoods","Operational\n Cost","Interest","Tax","Net Profit \nMargin"]
[null,"Shirt1",2721,1045,300,90,30,{"$f":"(C5-D5-E5-F5-G5)/C5","v":0.46159500183755969}]
[null,"Shirt2",2172,1000,296,98,45,{"$f":"(C6-D6-E6-F6-G6)/C6","v":0.33747697974217311}]
[null,"Shirt3",2958,1200,345,100,39,0.43069641649763352]
[null,"Jacket1",3405,1245,350,110,45,0.48604992657856094]
[null,"Jacket2",2154,780,290,68,20,0.46239554317548748]
[null,"Jacket3",2580,890,256,63,29,0.52015503875968994]
[null,"Pant1",4316,2560,430,100,39,0.27502316960148288]
[null,"Pant2",4815,2600,500,87,40,0.32980269989615785]
[null,"Pant3",4792,2220,480,90,38,0.40984974958263776]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Table","index":4,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Table Option"]
[]
[null,"Product","Selling Price","Cost of \nGoods","Gross Profit Margin"]
[null,"Shirt1",2721,1045,{"$f":"(Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost of \nGoods]])/Table1[[#This Row],[Selling Price]]","v":0.61595001837559715}]
[null,"Shirt2",2172,1000,{"$f":"(Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost of \nGoods]])/Table1[[#This Row],[Selling Price]]","v":0.53959484346224673}]
[null,"Shirt3",2958,1200,{"$f":"(Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost of \nGoods]])/Table1[[#This Row],[Selling Price]]","v":0.59432048681541583}]
[null,"Jacket1",3405,1245,{"$f":"(Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost of \nGoods]])/Table1[[#This Row],[Selling Price]]","v":0.63436123348017626}]
[null,"Jacket2",2154,780,{"$f":"(Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost of \nGoods]])/Table1[[#This Row],[Selling Price]]","v":0.63788300835654599}]
[null,"Jacket3",2580,890,{"$f":"(Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost of \nGoods]])/Table1[[#This Row],[Selling Price]]","v":0.65503875968992253}]
[null,"Pant1",4316,2560,{"$f":"(Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost of \nGoods]])/Table1[[#This Row],[Selling Price]]","v":0.40685820203892492}]
[null,"Pant2",4815,2600,{"$f":"(Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost of \nGoods]])/Table1[[#This Row],[Selling Price]]","v":0.46002076843198336}]
[null,"Pant3",4792,2220,{"$f":"(Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost of \nGoods]])/Table1[[#This Row],[Selling Price]]","v":0.53672787979966607}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"VBA","index":5,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using VBA Code"]
[]
[null,"Product","Selling Price","Cost of \nGoods","Operational\n Cost","Interest","Tax","Net Profit \nMargin"]
[null,"Shirt1",2721,1045,300,90,30,{"$f":"margin(C5,D5,E5,F5,G5)","v":0.46159500183755969}]
[null,"Shirt2",2172,1000,296,98,45,{"$f":"margin(C6,D6,E6,F6,G6)","v":0.33747697974217311}]
[null,"Shirt3",2958,1200,345,100,39,{"$f":"margin(C7,D7,E7,F7,G7)","v":0.43069641649763352}]
[null,"Jacket1",3405,1245,350,110,45,{"$f":"margin(C8,D8,E8,F8,G8)","v":0.48604992657856094}]
[null,"Jacket2",2154,780,290,68,20,{"$f":"margin(C9,D9,E9,F9,G9)","v":0.46239554317548748}]
[null,"Jacket3",2580,890,256,63,29,{"$f":"margin(C10,D10,E10,F10,G10)","v":0.52015503875968994}]
[null,"Pant1",4316,2560,430,100,39,{"$f":"margin(C11,D11,E11,F11,G11)","v":0.27502316960148288}]
[null,"Pant2",4815,2600,500,87,40,{"$f":"margin(C12,D12,E12,F12,G12)","v":0.32980269989615785}]
[null,"Pant3",4792,2220,480,90,38,{"$f":"margin(C13,D13,E13,F13,G13)","v":0.40984974958263776}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Practice","index":6,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Practice"]
[]
[null,"Product","Selling Price","Cost of \nGoods","Operational\n Cost","Interest","Tax"]
[null,"Shirt1",2721,1045,300,90,30]
[null,"Shirt2",2172,1000,296,98,45]
[null,"Shirt3",2958,1200,345,100,39]
[null,"Jacket1",3405,1245,350,110,45]
[null,"Jacket2",2154,780,290,68,20]
[null,"Jacket3",2580,890,256,63,29]
[null,"Pant1",4316,2560,430,100,39]
[null,"Pant2",4815,2600,500,87,40]
[null,"Pant3",4792,2220,480,90,38]