{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Template","RCCA Example","Calculations"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Template","index":0,"n_rows":48,"n_cols":40,"rows_kept":48,"cut":false,"hidden":false,"merged":[[12,37,14,37],[2,1,2,6],[3,14,3,15],[3,17,3,18],[3,27,3,28],[3,37,11,37],[35,9,35,10],[15,37,19,37],[17,9,18,10],[19,9,19,10],[20,37,24,37],[23,9,23,10],[23,12,23,13],[23,17,23,18]]}
[null,"Pricing Worksheet",null,null," "]
[null,"Instructions:  A.  Complete yellow cells in Project Plan. B.  Enter outside costs and mark-up (if any).  C.  Enter additional IC's (if any).  D. Complete sales commisision box (if applicable). E. Enter Final Sale Price"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Outside Costs","Item","Markup"]
[null,"Project Plan Phase","Description","Resource Class","Resource Person","Estimated Hours","Sale Price","Cost",null,"Description or Vendor","Outside Cost ($)","Mark-Up","Cost with Mark Up",null,"Project Summary",null,null,"Resource Class",null,"Hourly Cost","Hourly Rate","MarkUp",null,null,"Approved By","Date",null,"Personnel Class",null,null,"Resource Lookup",null,"Total","Cost",null,"Mark-Up",null,"Production","Printing",0.15]
[null,null,null,null,null,null,{"$f":"F5*IF(AE5=$R$5,$U$5,IF(AE5=$R$6,$U$6,IF(AE5=$R$7,$U$7,IF(AE5=$R$8,$U$8,IF(AE5=$R$9,$U$9,IF(AE5=$R$10,$U$10,IF(AE5=$R$11,$U$11,IF(AE5=$R$12,$U$12,IF(AE5=$R$13,$U$13,IF(AE5=$R$14,$U$14,IF(AE5=$R$15,$U$15,IF(AE5=$R$16,$U$16,IF(AE5=$R$17,$U$17,IF(AE5=$R$18,$U$18,IF(AE5=$R$19,$U$19,IF(AE5=$R$20,$U$20,IF(AE5=$R$21,$U$21,IF(AE5=$R$22,$U$22,))))))))))))))))))","v":0},{"$f":"F5*IF(AE5=$R$5,$T$5,IF(AE5=$R$6,$T$6,IF(AE5=$R$7,$T$7,IF(AE5=$R$8,$T$8,IF(AE5=$R$9,$T$9,IF(AE5=$R$10,$T$10,IF(AE5=$R$11,$T$11,IF(AE5=$R$12,$T$12,IF(AE5=$R$13,$T$13,IF(AE5=$R$14,$T$14,IF(AE5=$R$15,$T$15,IF(AE5=$R$16,$T$16,IF(AE5=$R$17,$T$17,IF(AE5=$R$18,$T$18,IF(AE5=$R$19,$T$19,IF(AE5=$R$20,$T$20,IF(AE5=$R$21,$T$21,IF(AE5=$R$22,$T$22,))))))))))))))))))","v":0},null,null,null,null,{"$f":"K5*(1+L5)","v":0},null,"Dept","Hours",null,1.1000000000000001,"Account Coordintor",{"$f":"Calculations!E19","v":25},120,{"$f":"U5/T5","v":4.8},null,"Jeff",null,null,null,"Aurora",{"$f":"R5","v":1.1000000000000001},null,{"$f":"IF(D5=$S$5,$R$5,IF(D5=$S$6,$R$6,IF(D5=$S$7,$R$7,IF(D5=$S$8,$R$8,IF(D5=$S$9,$R$9,IF(D5=$S$10,$R$10,IF(D5=$S$11,$R$11,IF(D5=$S$12,$R$12,IF(D5=$S$13,$R$13,IF(D5=$S$14,$R$14,IF(D5=$S$15,$R$15,IF(D5=$S$16,$R$16,IF(D5=$S$17,$R$17,IF(D5=$S$18,$R$18,IF(D5=$S$19,$R$19,IF(D5=$S$20,$R$20,IF(D5=$S$21,$R$21,IF(D5=$S$22,$R$22,\"\"))))))))))))))))))","v":""},null,{"$f":"R5","v":1.1000000000000001},{"$f":"SUMIF($AE$5:$AE$44,R5,$H$5:$H$44)","v":0},null,0,null,null,"Photographer",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,0,null,"AM",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">1\",$AE$5:$AE$44,\"<2\")","v":0},null,1.2,"Account Manager",{"$f":"Calculations!E11","v":44},140,{"$f":"U6/T6","v":3.1818181818181817},null,"Robert",null,null,null,"Kyle",{"$f":"R5","v":1.1000000000000001},null,"",null,1.2,0,null,0.1,null,null,"Videographer",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,0,null,"PM",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">2\",$AE$5:$AE$44,\"<3\")","v":0},null,1.3,"Sr. Account Manager",{"$f":"Calculations!E9","v":72},150,2.0833333333333335,null,"Stewart",null,null,null,"Leslie",{"$f":"R7","v":1.3},null,"",null,1.3,0,null,0.15,null,null,"Animation",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,0,null,"Creative",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">5\",$AE$5:$AE$44,\"<6\")","v":0},null,1.4,"Account Supervisor",{"$f":"Calculations!E9","v":72},175,2.4305555555555554,null," ",null,null,null,"Chloe",{"$f":"R7","v":1.3},null,"",null,1.4,0,null,0.2,null,null,"Sound/Video Editor",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,0,null,"Digital",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">4\",$AE$5:$AE$44,\"<5\")","v":0},null,1.5,"Dir. Client Services",{"$f":"Calculations!E10","v":83},200,2.4096385542168677,null,null,null,null,null,"Bryce",{"$f":"R8","v":1.4},null,"",null,1.5,0,null,0.25,null,null,"Voice-over",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,0,null,"Dev",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">3\",$AE$5:$AE$44,\"<4\")","v":0},null,2.1,"Project Manager",{"$f":"Calculations!E16","v":57},140,2.4561403508771931,null,null,null,null,null,"Megan",{"$f":"R8","v":1.4},null,"",null,2.1,0,null,null,null,null,"Stock Photo/Video",0]
[null,null,null,null,null,null,0,0,null,null,null,null,0,null,"ICs",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">6\",$AE$5:$AE$44,\"<7\")","v":0},null,3.1,"Developer 1",{"$f":"Calculations!E15","v":38},150,3.9473684210526314,null,null,null,null,null,"Melissa",{"$f":"R9","v":1.5},null,"",null,3.1,0,null,null,null,null,"Vanity phone #'s or URLs",0.15]
[null,null,null,null,null,null,0,0,null,"Total",{"$f":"SUM(K5:K11)","v":0},{"$f":"SUM(L5:L11)","v":0},{"$f":"SUM(M5:M11)","v":0},null,"MD/CEO",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">7\",$AE$5:$AE$44,\"<8\")","v":0},null,3.2,"Developer 2",{"$f":"Calculations!E14","v":57},175,3.0701754385964914,null,null,null,null,null,"Roya",{"$f":"R10","v":2.1},null,"",null,3.2,0,null,null,null,null,"Station Produced Spots",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,"Total",{"$f":"SUM(P6:P12)","v":0},null,4.0999999999999996,"Digital AS/Ops",{"$f":"Calculations!E7","v":49},150,3.0612244897959182,null,null,null,null,null,"Tamila",{"$f":"R10","v":2.1},null,"",null,4.0999999999999996,0,null,null,null,"T&E","Travel",0]
[null,null,null,null,null,null,0,0,null,null,"Name/Vendor","Hourly Cost","Hourly To Client",null,null,null,null,4.2,"Digital Head",{"$f":"Calculations!E6","v":77},185,2.4025974025974026,null,null,null,null,null,"Eddie",{"$f":"R11","v":3.1},null,"",null,4.2,0,null,null,null,null,"Meals",0]
[null,null,null,null,null,null,0,0,null,"Other IC 1",null,null,{"$f":"L15*2","v":0},null,null,null,null,5.0999999999999996,"Exec. Creative Director",{"$f":"Calculations!E13","v":98},200,2.0408163265306123,null,null,null,null,null,"Sean",{"$f":"R12","v":3.2},null,"",null,5.0999999999999996,0,null,null,null,null,"Hotels",0]
[null,null,null,null,null,null,0,0,null,"Other IC 2",null,null,null,null,null,null,null,6.1,"IC Anne",85,175,2.0588235294117645,null,null,null,null,null,"Garrick",{"$f":"R13","v":4.0999999999999996},null,"",null,6.1,0,null,null,null,"Market Research","Research - Moderator",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,6.2,"IC Chris",75,200,2.6666666666666665,null,null,null,null,null,"Regina",{"$f":"R13","v":4.0999999999999996},null,"",null,6.2,0,null,null,null,null,"Research - Honorarium",0]
[null,null,null,null,null,null,0,0,null,"Enter \"X\" in yellow box below  if sales commission applies",null,null,null,null,null,null,null,6.3,"IC Charlie",50,175,3.5,null,null,null,null,null,"Raheim",4.2,null,"",null,6.3,0,null,null,null,null,"Research - Facilities",0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,6.4,"IC Darlene",100,250,2.5,null,null,null,null,null,"Dana",5.0999999999999996,null,"",null,6.4,0,null,null,null,null,"Research - Recruiting",0.15]
[null,null,null,null,null,null,0,0,null,"x",null,null,null,null,null,null,null,6.5,"IC Other 1",{"$f":"IF(L15=\"\",0,L15)","v":0},{"$f":"IF(M15=\"\",0,M15)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,"Anne",6.1,null,"",null,6.5,0,null,null,null,null,"Platforms (e.g. MailChimp)",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,6.6,"IC Other 2",{"$f":"IF(L16=\"\",0,L16)","v":0},{"$f":"IF(M16=\"\",0,M16)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,"Chris",6.2,null,"",null,6.6,0,null,null,null,"Other","Shipping",0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,7.1,"MD/CEO",{"$f":"Calculations!E22","v":149},275,1.8456375838926173,null,null,null,null,null,"Charlie",6.3,null,"",null,7.1,0,null,null,null,null,"Postage",0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Darlene",6.4,null,"",null,null,null,null,null,null,null,"Software",0]
[null,null,null,null,null,null,0,0,null,"Finanical Summary",null,null,"FINAL Pricing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Robert",{"$f":"R22","v":7.1},null,"",null,null,null,null,null,null,null,"TBD - 0%",0]
[null,null,null,null,null,null,0,0,null,"Suggested Sale Price",{"$f":"G45+M12","v":0},null,"Final Sale Price",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stewart",{"$f":"R22","v":7.1},null,"",null,null,null,null,null,null,null,"TBD - 15%",0.15]
[null,null,null,null,null,null,0,0,null,"Costs",null,null,"Costs",{"$f":"K26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Internal Labor",{"$f":"SUM(AH5:AH5:AH15)+AH22","v":0},null,"Internal Labor",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"External Labor",{"$f":"SUM(AH16:AH21)","v":0},null,"External Labor",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Sales Comp",{"$f":"IF(J20=\"x\",K25*0.1,0)","v":0},null,"Sales Comp",{"$f":"IF(J20=\"x\",N25*0.1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Outside Costs",{"$f":"M12","v":0},null,"Outside Costs",0,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Total Costs",{"$f":"SUM(K27:K30)","v":0},null,"Total Costs",{"$f":"SUM(N27:N30)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Profit",{"$f":"K25-K31","v":0},null,"Profit",{"$f":"N25-N31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Profit Margin",{"$f":"K32/K25","v":{"$error":"#DIV/0!"}},null,"Profit Margin",{"$f":"N32/N25","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Profit Ratio",{"$f":"K25/K31","v":{"$error":"#DIV/0!"}},null,"Profit Ratio",{"$f":"N25/N31","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,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,null,null,null,0,0,null,"\"3:1\" Price Scenario ",null,null,null,"Approval","Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Sale Price",{"$f":"(K39*3)+(K40*3)+K41+K42","v":0},null,"Jeff",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Costs",null,null,"Robert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Internal Labor",{"$f":"K27","v":0},null,"Stewart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"External Labor",{"$f":"K28","v":0},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,0,0,null,"Sales Comp",{"$f":"K29","v":0},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,0,0,null,"Outside Costs",{"$f":"K30","v":0},null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Total Costs",{"$f":"K31","v":0},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,0,0,null,"Profit",{"$f":"K37-K43","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Total Hours",{"$f":"SUM(F5:F44)","v":0},{"$f":"SUM(G5:G44)","v":0},{"$f":"SUM(H5:H44)","v":0},null,"Profit Margin",{"$f":"K44/K37","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,"Profit Ratio",{"$f":"K37/K43","v":{"$error":"#DIV/0!"}},null,null,null," "]
[]
[null,null,null,null,null," "]

{"sheet":"RCCA Example","index":1,"n_rows":48,"n_cols":40,"rows_kept":48,"cut":false,"hidden":false,"merged":[[35,9,35,10],[15,37,19,37],[17,9,18,10],[19,9,19,10],[20,37,24,37],[23,9,23,10],[23,12,23,13],[23,17,23,18],[12,37,14,37],[2,1,2,6],[3,14,3,15],[3,17,3,18],[3,27,3,28],[3,37,11,37]]}
[null,"Pricing Worksheet",null,null," "]
[null,"Instructions:  A.  Complete yellow cells in Project Plan. B.  Enter outside costs and mark-up (if any).  C.  Enter additional IC's (if any).  D. Complete sales commisision box (if applicable). E. Enter Final Sale Price"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Outside Costs","Item","Markup"]
[null,"Project Plan Phase","Description","Resource Class","Resource Person","Estimated Hours","Sale Price","Cost",null,"Description or Vendor","Outside Cost ($)","Mark-Up","Cost with Mark Up",null,"Project Summary",null,null,"Resource Class",null,"Hourly Cost","Hourly Rate","MarkUp",null,null,"Approved By","Date",null,"Personnel Class",null,null,"Resource Lookup",null,"Total","Cost",null,"Mark-Up",null,"Production","Printing",0.15]
[null,"Discovery","Assessment & SWOT","Exec. Creative Director",null,11,{"$f":"F5*IF(AE5=$R$5,$U$5,IF(AE5=$R$6,$U$6,IF(AE5=$R$7,$U$7,IF(AE5=$R$8,$U$8,IF(AE5=$R$9,$U$9,IF(AE5=$R$10,$U$10,IF(AE5=$R$11,$U$11,IF(AE5=$R$12,$U$12,IF(AE5=$R$13,$U$13,IF(AE5=$R$14,$U$14,IF(AE5=$R$15,$U$15,IF(AE5=$R$16,$U$16,IF(AE5=$R$17,$U$17,IF(AE5=$R$18,$U$18,IF(AE5=$R$19,$U$19,IF(AE5=$R$20,$U$20,IF(AE5=$R$21,$U$21,IF(AE5=$R$22,$U$22,))))))))))))))))))","v":2200},{"$f":"F5*IF(AE5=$R$5,$T$5,IF(AE5=$R$6,$T$6,IF(AE5=$R$7,$T$7,IF(AE5=$R$8,$T$8,IF(AE5=$R$9,$T$9,IF(AE5=$R$10,$T$10,IF(AE5=$R$11,$T$11,IF(AE5=$R$12,$T$12,IF(AE5=$R$13,$T$13,IF(AE5=$R$14,$T$14,IF(AE5=$R$15,$T$15,IF(AE5=$R$16,$T$16,IF(AE5=$R$17,$T$17,IF(AE5=$R$18,$T$18,IF(AE5=$R$19,$T$19,IF(AE5=$R$20,$T$20,IF(AE5=$R$21,$T$21,IF(AE5=$R$22,$T$22,))))))))))))))))))","v":1078},null,null,0,0,{"$f":"K5*(1+L5)","v":0},null,"Dept","Hours",null,1.1000000000000001,"Account Coordintor",{"$f":"Calculations!E19","v":25},120,{"$f":"U5/T5","v":4.8},null,"Jeff",null,null,null,"Aurora",{"$f":"R5","v":1.1000000000000001},null,{"$f":"IF(D5=$S$5,$R$5,IF(D5=$S$6,$R$6,IF(D5=$S$7,$R$7,IF(D5=$S$8,$R$8,IF(D5=$S$9,$R$9,IF(D5=$S$10,$R$10,IF(D5=$S$11,$R$11,IF(D5=$S$12,$R$12,IF(D5=$S$13,$R$13,IF(D5=$S$14,$R$14,IF(D5=$S$15,$R$15,IF(D5=$S$16,$R$16,IF(D5=$S$17,$R$17,IF(D5=$S$18,$R$18,IF(D5=$S$19,$R$19,IF(D5=$S$20,$R$20,IF(D5=$S$21,$R$21,IF(D5=$S$22,$R$22,\"\"))))))))))))))))))","v":5.0999999999999996},null,{"$f":"R5","v":1.1000000000000001},{"$f":"SUMIF($AE$5:$AE$44,R5,$H$5:$H$44)","v":0},null,0,null,null,"Photographer",0.15]
[null,null,null,"IC Anne",null,8,1400,680,null,null,null,null,0,null,"AM",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">1\",$AE$5:$AE$44,\"<2\")","v":141},null,1.2,"Account Manager",{"$f":"Calculations!E11","v":44},140,{"$f":"U6/T6","v":3.1818181818181817},null,"Robert",null,null,null,"Kyle",{"$f":"R5","v":1.1000000000000001},null,6.1,null,1.2,2816,null,0.1,null,null,"Videographer",0.15]
[null,null,null,"Account Supervisor",null,14,2450,1008,null,null,null,null,0,null,"PM",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">2\",$AE$5:$AE$44,\"<3\")","v":0},null,1.3,"Sr. Account Manager",{"$f":"Calculations!E9","v":72},150,2.0833333333333335,null,"Stewart",null,null,null,"Leslie",{"$f":"R7","v":1.3},null,1.4,null,1.3,0,null,0.15,null,null,"Animation",0.15]
[null,null,null,"Account Manager",null,7,980,308,null,null,null,null,0,null,"Creative",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">5\",$AE$5:$AE$44,\"<6\")","v":94},null,1.4,"Account Supervisor",{"$f":"Calculations!E9","v":72},175,2.4305555555555554,null," ",null,null,null,"Chloe",{"$f":"R7","v":1.3},null,1.2,null,1.4,4536,null,0.2,null,null,"Sound/Video Editor",0.15]
[null,null,null,"Dir. Client Services",null,3,600,249,null,null,null,null,0,null,"Digital",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">4\",$AE$5:$AE$44,\"<5\")","v":0},null,1.5,"Dir. Client Services",{"$f":"Calculations!E10","v":83},200,2.4096385542168677,null,null,null,null,null,"Bryce",{"$f":"R8","v":1.4},null,1.5,null,1.5,1162,null,0.25,null,null,"Voice-over",0.15]
[null,null,"Personas","Exec. Creative Director",null,8,1600,784,null,null,null,null,0,null,"Dev",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">3\",$AE$5:$AE$44,\"<4\")","v":0},null,2.1,"Project Manager",{"$f":"Calculations!E16","v":57},140,2.4561403508771931,null,null,null,null,null,"Megan",{"$f":"R8","v":1.4},null,5.0999999999999996,null,2.1,0,null,null,null,null,"Stock Photo/Video",0]
[null,null,null,"IC Anne",null,11.5,2012.5,977.5,null,null,null,null,0,null,"ICs",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">6\",$AE$5:$AE$44,\"<7\")","v":183.5},null,3.1,"Developer 1",{"$f":"Calculations!E15","v":38},150,3.9473684210526314,null,null,null,null,null,"Melissa",{"$f":"R9","v":1.5},null,6.1,null,3.1,0,null,null,null,null,"Vanity phone #'s or URLs",0.15]
[null,null,null,"Account Supervisor",null,5,875,360,null,"Total",{"$f":"SUM(K5:K11)","v":0},{"$f":"SUM(L5:L11)","v":0},{"$f":"SUM(M5:M11)","v":0},null,"MD/CEO",{"$f":"SUMIFS($F$5:$F$44,$AE$5:$AE$44,\">7\",$AE$5:$AE$44,\"<8\")","v":0},null,3.2,"Developer 2",{"$f":"Calculations!E14","v":57},175,3.0701754385964914,null,null,null,null,null,"Roya",{"$f":"R10","v":2.1},null,1.4,null,3.2,0,null,null,null,null,"Station Produced Spots",0.15]
[null," "," ","Account Manager",null,5,700,220,null,null,null,null,null,null,"Total",{"$f":"SUM(P6:P12)","v":418.5},null,4.0999999999999996,"Digital AS/Ops",{"$f":"Calculations!E7","v":49},150,3.0612244897959182,null,null,null,null,null,"Tamila",{"$f":"R10","v":2.1},null,1.2,null,4.0999999999999996,0,null,null,null,"T&E","Travel",0]
[null,null,null,"Dir. Client Services",null,2,400,166,null,null,"Name/Vendor","Hourly Cost","Hourly To Client",null,null,null,null,4.2,"Digital Head",{"$f":"Calculations!E6","v":77},185,2.4025974025974026,null,null,null,null,null,"Eddie",{"$f":"R11","v":3.1},null,1.5,null,4.2,0,null,null,null,null,"Meals",0]
[null,null,"Competitive Audit","Account Supervisor",null,4,700,288,null,"Other IC 1","Erin",85,150,null,null,null,null,5.0999999999999996,"Exec. Creative Director",{"$f":"Calculations!E13","v":98},200,2.0408163265306123,null,null,null,null,null,"Sean",{"$f":"R12","v":3.2},null,1.4,null,5.0999999999999996,9212,null,null,null,null,"Hotels",0]
[null,null,null,"Account Manager",null,10,1400,440,null,"Other IC 2",null,null,null,null,null,null,null,6.1,"IC Anne",85,175,2.0588235294117645,null,null,null,null,null,"Garrick",{"$f":"R13","v":4.0999999999999996},null,1.2,null,6.1,9987.5,null,null,null,"Market Research","Research - Moderator",0.15]
[null,null,null,"Exec. Creative Director",null,8,1600,784,null,null,null,null,null,null,null,null,null,6.2,"IC Chris",75,200,2.6666666666666665,null,null,null,null,null,"Regina",{"$f":"R13","v":4.0999999999999996},null,5.0999999999999996,null,6.2,0,null,null,null,null,"Research - Honorarium",0]
[null,"Strategy","Brand Architecture","Exec. Creative Director",null,15,3000,1470,null,"Enter \"X\" in yellow box below  if sales commission applies",null,null,null,null,null,null,null,6.3,"IC Charlie",50,175,3.5,null,null,null,null,null,"Raheim",4.2,null,5.0999999999999996,null,6.3,0,null,null,null,null,"Research - Facilities",0]
[null,null,null,"IC Anne",null,18,3150,1530,null,null,null,null,null,null,null,null,null,6.4,"IC Darlene",100,250,2.5,null,null,null,null,null,"Dana",5.0999999999999996,null,6.1,null,6.4,0,null,null,null,null,"Research - Recruiting",0.15]
[null,null,null,"Dir. Client Services",null,3,600,249,null," ",null,null,null,null,null,null,null,6.5,"IC Other 1",{"$f":"IF(L15=\"\",0,L15)","v":85},{"$f":"IF(M15=\"\",0,M15)","v":150},1.7647058823529411,null,null,null,null,null,"Anne",6.1,null,1.5,null,6.5,5610,null,null,null,null,"Platforms (e.g. MailChimp)",0.15]
[null,null,null,"Account Supervisor",null,7,1225,504,null,null,null,null,null,null,null,null,null,6.6,"IC Other 2",{"$f":"IF(L16=\"\",0,L16)","v":0},{"$f":"IF(M16=\"\",0,M16)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,"Chris",6.2,null,1.4,null,6.6,0,null,null,null,"Other","Shipping",0]
[null,null,null,"Account Manager",null,5,700,220,null,null,null,null,null,null,null,null,null,7.1,"MD/CEO",{"$f":"Calculations!E22","v":149},275,1.8456375838926173,null,null,null,null,null,"Charlie",6.3,null,1.2,null,7.1,0,null,null,null,null,"Postage",0]
[null,null,"Positioning","Exec. Creative Director",null,18,3600,1764,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Darlene",6.4,null,5.0999999999999996,null,null,null,null,null,null,null,"Software",0]
[null,null,null,"IC Anne",null,21,3675,1785,null,"Finanical Summary",null,null,"FINAL Pricing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Robert",{"$f":"R22","v":7.1},null,6.1,null,null,null,null,null,null,null,"TBD - 0%",0]
[null,null,null,"Dir. Client Services",null,2,400,166,null,"Suggested Sale Price",{"$f":"G45+M12","v":72047.5},null,"Final Sale Price",61500,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stewart",{"$f":"R22","v":7.1},null,1.5,null,null,null,null,null,null,null,"TBD - 15%",0.15]
[null," "," ","Account Supervisor",null,7,1225,504,null,"Costs",null,null,"Costs",{"$f":"K26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4]
[null,null,null,"Account Manager",null,5,700,220,null,"Internal Labor",{"$f":"SUM(AH5:AH5:AH15)+AH22","v":17726},null,"Internal Labor",17726,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,"Creative Dev","Name & Logo","Exec. Creative Director",null,22,4400,2156,null,"External Labor",{"$f":"SUM(AH16:AH21)","v":15597.5},null,"External Labor",15597.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.0999999999999996]
[null,null,null,"IC Anne",null,43,7525,3655,null,"Sales Comp",{"$f":"IF(J20=\"x\",K25*0.1,0)","v":0},null,"Sales Comp",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.1]
[null,null,null,"Dir. Client Services",null,4,800,332,null,"Outside Costs",{"$f":"M12","v":0},null,"Outside Costs",0,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,1.5]
[null,null,null,"IC Other 1",null,36,5400,3060,null,"Total Costs",{"$f":"SUM(K27:K30)","v":33323.5},null,"Total Costs",33323.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.5]
[null,null,null,"Account Supervisor",null,14,2450,1008,null,"Profit",{"$f":"K25-K31","v":38724},null,"Profit",{"$f":"N25-N31","v":28176.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4]
[null,null,null,"Account Manager",null,14,1960,616,null,"Profit Margin",{"$f":"K32/K25","v":0.53747874666018947},null,"Profit Margin",{"$f":"N32/N25","v":0.45815447154471545},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,"Reseach","Exec. Creative Director",null,6,1200,588,null,"Profit Ratio",{"$f":"K25/K31","v":2.1620628085285158},null,"Profit Ratio",{"$f":"N25/N31","v":1.8455444356085045},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.0999999999999996]
[null,null,null,"Account Supervisor",null,4,700,288,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4]
[null,null,null,"Account Manager",null,6,840,264,null,"\"3:1\" Price Scenario ",null,null,null,"Approval","Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,"Brand Guidelines","Exec. Creative Director",null,6,1200,588,null,"Sale Price",{"$f":"(K39*3)+(K40*3)+K41+K42","v":99970.5},null,"Jeff",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.0999999999999996]
[null,null,null,"IC Anne",null,16,2800,1360,null,"Costs",null,null,"Robert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.1]
[null,null,null,"IC Other 1",null,30,4500,2550,null,"Internal Labor",{"$f":"K27","v":17726},null,"Stewart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.5]
[null,null,null,"Account Supervisor",null,8,1400,576,null,"External Labor",{"$f":"K28","v":15597.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4]
[null,null,null,"Account Manager",null,12,1680,528,null,"Sales Comp",{"$f":"K29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,0,0,null,"Outside Costs",{"$f":"K30","v":0},null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Total Costs",{"$f":"K31","v":33323.5},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,0,0,null,"Profit",{"$f":"K37-K43","v":66647},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Total Hours",{"$f":"SUM(F5:F44)","v":418.5},{"$f":"SUM(G5:G44)","v":72047.5},{"$f":"SUM(H5:H44)","v":33323.5},null,"Profit Margin",{"$f":"K44/K37","v":0.66666666666666663}]
[null,null,null,null,null,null,null,null,null,"Profit Ratio",{"$f":"K37/K43","v":3},null,null,null," "]
[]
[null,null,null,null,null," "]

{"sheet":"Calculations","index":2,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Dept/Employee","Total"]
[]
[null,"Salary","Sal + Benefits","Hourly Cost","Hourly Cost (Rounded)"]
["    Director Digital Marketing - Raheim Bundle",118125,{"$f":"B6*1.3","v":153562.5},{"$f":"C6/2000","v":76.78125},{"$f":"ROUND(D6,0)","v":77}]
["    Digital Account Manager - Regina Sirko",75416,{"$f":"B7*1.3","v":98040.8},49.020400000000002,49]
["    Digital Account Supervisor - Garrick Gaffney",97500,126750,63.375,63]
["     Account Supervisor - Megan",110000.00000000001,143000.00000000003,71.500000000000014,72]
["     Acct Director - Melissa Martinez",128333,166832.9,83.416449999999998,83]
["     Account Manager  - Leslie Hines",67999.999999999985,88399.999999999985,44.199999999999996,44]
["     Account Coordinator  - Chloé Ribotsky",52083,67707.900000000009,33.853950000000005,34]
["     Creative Director - Dana",150000,195000,97.5,98,null," "]
["     Web Programmer - Eddie Olivas",87125,113262.5,56.631250000000001,57]
["     Web Programmer - Sean Mee",58333,75832.900000000009,37.916450000000005,38]
["     Project Manager - Tamila Kahng",87916,114290.8,57.145400000000002,57]
["     Associate Project Mgr/Media Coordinator - Celeste Ethington",50749.999999999993,65975,32.987499999999997,33]
["    Business Dev - Kathy Gaughran",0,0,0,0]
["    Lead Generation/Research - Aurora Olivas",38376,49888.800000000003,24.944400000000002,25]
["     Marketing & Office Administrator - Kyle Hojem",37187,48343.1,24.17155,24]
["     CEO - Stewart Gandolf",300000,390000,195,195]
["     Managing Director - TBD",229166,297915.8,148.9579,149]
["     CFO - Jeff Mancino",205000.00000000003,266500.00000000006,133.25000000000003,133]
["     Sr. Accountant - Elisa Negrete",67237,87408.1,43.704050000000002,44]