{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["IRI_WorkspaceStorage","Margin Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"IRI_WorkspaceStorage","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Margin Calculator","index":1,"n_rows":16,"n_cols":30,"rows_kept":16,"cut":false,"hidden":false,"merged":[[6,11,6,14],[7,6,8,6],[7,7,8,7],[0,1,0,19],[4,3,4,11],[7,11,8,11],[7,12,8,12],[6,18,8,18],[6,19,8,19],[7,8,7,9],[7,13,7,14],[6,6,6,9]]}
[null,"Blended Margin Calculator"]
[]
[null,"Click Button to Choose Form of Currency"]
[null," "]
[null,"Retailer's Name:",null,"enter name"]
[]
[null,null,null," ",null,null,"Non-Promoted",null,null,null,null,"Promoted",null,null,null,null,"Blended","Blended",{"$f":"\"Blended Gross Margin \"&IF(type=\"yen\",\"Yen\",type&\"s\")","v":"Blended Gross Margin Dollars"},"Blended Gross Margin Percent"]
[null,null,null,"% Bought ","% Sold",null,"Price to Retailer (Cost)","Price to Consumer (Price)","Gross Margin",null,null,"Price to Retailer (Cost)","Price to Consumer (Price)","Gross Margin",null,null,"Cost","Sales"]
[null,"Key Brand / Packages",null,"on Deal","on Deal",null,null,null,{"$f":"IF(type=\"yen\",\"Yen\",type&\"s\")","v":"Dollars"},"Percent",null,null,null,{"$f":"IF(type=\"yen\",\"Yen\",type&\"s\")","v":"Dollars"},"Percent",null," ",null,null,null,null,null,null,null,null,null,"Selected (\"X\")","Symbol","Region","Currency Type"]
[null,"enter product",null,0,0,null,0,0,{"$f":"+H10-G10","v":0},{"$f":"+I10/H10","v":{"$error":"#DIV/0!"}},null,0,0,{"$f":"+M10-L10","v":0},{"$f":"+N10/M10","v":{"$error":"#DIV/0!"}},null,{"$f":"((+D10*L10)+((1-D10)*G10))","v":0},0,{"$f":"(+R10-Q10)","v":0},{"$f":"(+R10-Q10)/R10","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"X","$","US","Dollar"]
[null,"enter product",null,0,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,0,{"$f":"+M11-L11","v":0},{"$f":"+N11/M11","v":{"$error":"#DIV/0!"}},null,0,0,{"$f":"(+R11-Q11)","v":0},{"$f":"(+R11-Q11)/R11","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"€","European","Euro"]
[null,"enter product",null,0,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"¥","Japanese","Yen"]
[null,"enter product",null,0,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"£","British","Pound"]
[null,"enter product",null,0,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"CHF","Swiss","Franc"]
[null,"enter product",null,0,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,{"$f":"INDEX(AB10:AB14,MATCH(\"x\",AA10:AA14,0))","v":"$"},{"$f":"INDEX(AC10:AC14,MATCH(\"x\",AA10:AA14,0))","v":"US"},{"$f":"INDEX(AD10:AD14,MATCH(\"x\",AA10:AA14,0))","v":"Dollar"}]
[null,"enter product",null,0,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"}]