{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,0,6,3]]}
[null,null,"Enter this value in Margins"]
["Enter your mark-up -->",0.25]
["Margin",{"$f":"C11","v":0.2},{"$f":"C11","v":0.2}]
[]
[]
[]
["Here's an example of how the math works, assuming AdWords spend is $100"]
[]
[null,"AdWords Spend","Markup","Total Spend"]
[null,100.0,{"$f":"B2*B10","v":25},{"$f":"B10+C10","v":125}]
["Margin Calculation (highlighted in yellow)",{"$f":"B10/D10","v":0.8},{"$f":"C10/D10","v":0.2},1]
[]
[]
[]
["Raw AdWords  Spend",100.0]
["Cost to Advertiser with 20% Margin",125.0]
["In agency pocket",{"$f":"0.2*B16","v":25},"(20% of $125)"]
[]
["Raw AdWords  Spend",100.0]
["Cost to Advertiser with 20% Markup",20.0]
["In agency pocket",null,"(20% of $100)"]