{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["SVBA_Exercise"],"not_rendered":{"charts":0,"images":2,"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":"SVBA_Exercise","index":0,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,9,25,15],[17,9,19,10],[17,11,17,15],[18,11,18,15],[19,11,19,15],[6,9,16,10],[13,11,13,15],[16,11,16,15],[6,11,10,15],[11,11,11,12],[12,11,12,12]]}
[]
["Hats","Price","Price Adjustment","New Price","Discount","Price Variation","Final Price"]
["Beret",14.5,null,{"$f":"SUM(B3:C3)","v":14.5},null,{"$f":"G3-B3","v":0},{"$f":"B3+C3-E3","v":14.5}]
["Topper",37.25,null,{"$f":"SUM(B4:C4)","v":37.25},null,0,{"$f":"B4+C4-E4","v":37.25}]
["Cloche",16.75,null,16.75,null,0,16.75]
["Bowler",20.75,null,20.75,null,0,20.75]
["Western",13.25,null,13.25,null,0,13.25,null,null,"Instructions:",null,"A hat store intents to make a Black Friday sales promotion. However, before lowering the prices, the store manager decides to adjust the prices up so the given discounts will not reduce the store's margin of sales by much. To do that, he decided that he would follow the following rules:"]
["Especial",10.75,null,10.75,null,0,10.75]
["Fedora",28,null,28,null,0,28]
["Gambler",37.25,null,37.25,null,0,37.25]
["Bucket ",32,null,32,null,0,32]
["Floppy",22.5,null,22.5,null,0,22.5,null,null,null,null,"Initial Price",null,"6 to 15","15,01 a 25","25,01 or more"]
["Wool Cap",15.5,null,15.5,null,0,15.5,null,null,null,null,"Raise",null,0.15,0.25,0.35]
["Kids",6.75,null,6.75,null,0,6.75,null,null,null,null,"The discount is given after the price increase"]
["Straw",15.75,null,15.75,null,0,15.75,null,null,null,null,"New Price","6 to 15","15,01 to 22","22,01 to 33","33,01 or more"]
["Palheta",34,null,34,null,0,34,null,null,null,null,"Disocunt",0.1,0.17499999999999999,0.25,0.3]
["Panama",36.25,null,36.25,null,0,36.25,null,null,null,null,"The items that actually had their prices lowered should be colored green"]
["Homburg",16.5,null,16.5,null,0,16.5,null,null,"Reminder:",null,"ALT + F11 - Open VBE"]
["Fishing",12,null,12,null,0,12,null,null,null,null,"Write the code in Exercise_Module"]
["Pork Pie",31.25,null,31.25,null,0,31.25,null,null,null,null,"When ready press F5 to execute the code"]
["Beach",14.75,null,14.75,null,0,14.75]
["Visor",7.5,null,7.5,null,0,7.5]