{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Read Me","Depts & Generic descriptors","Generic descriptors expl.","Incl USA","Drop-downs","Creative","Content","Digital & Social","Direct Marketing","PR","Design","Partnership","Events-Experiential"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":246,"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":"Read Me","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[8,2,8,8],[13,2,13,8],[1,1,1,8],[3,2,3,8],[4,2,4,8],[6,1,6,8],[7,2,7,8],[9,2,9,8],[10,2,10,8],[14,2,14,8],[11,2,11,8],[12,2,12,8],[22,2,22,8],[21,2,21,8],[16,2,16,8],[15,2,15,8],[18,1,18,8],[19,2,19,8],[20,2,20,8]]}
[]
[null,"Instructions for the completion of the Fee Template "]
[]
[null,"Context","There are a series of templates for the range of disciplines required to fulfil end to end solutions within this tender.\n\nIn accordance with the process detailed in Attachment 1 - Invitation to Tender, cells highlighted in yellow will be evaluated as part of this procurement, however all cells highlighted in orange (Partnership Marketing and Events & Experiential tabs) should be completed where possible, but will not be evaluated.\n\nFor the avoidance of doubt, all pricing submitted within this matrix will be contractually committed rates for the Client.\n\nAs prices submitted in cells highlighted in yellow will be used for the price evaluation. A failure to insert an applicable price may result in your tender being deemed non-compliant. If a Tender is deemed non-compliant, the Tender may be rejected and excluded from further participation in this procurement.\"\n\nWithin these templates there are a selection of roles across a range of disciplines. You must provide rates for each of these shown (or your equivalent role) and for every template. Many Agencies will be able to offer a range of these disciplines from within the agency, but we are aware that to be able to offer the full suite of services, there may be a need to create a consortium of specialists. \n\nWhere staff grade titles differ from those in your organisation, Potential Agencies are advised to  read the definitions of each grade as set out in the generic descriptors tab and submit an appropriate rate which is based on a comparable grade in the Potential Agencies organisations with comparable roles and responsibilities.\n\nSome of these roles may be shared across disciplines within the agency – but please complete the information for every template and have your consortium partners complete for any discipline that you cannot offer.\n\nThese rates will be used to provide an average rate across all services and this rate will be used for the pricing evaluation and will be shown at the base of the ‘creative’ template once all sheets have been completed.\n\nAll pricing must be in pounds sterling (£GBP) to 2 decimal places    \nAll pricing shall be exclusive of VAT\nA price must be provided for all options (even if they are the same price)    \nZero bids will be deemed non-compliant as outlined in the Invitation to Tender – Attachment 1\n\nPlease note. All rates provided should be the gross hourly rate – see notes below\n\nIn addition, and using the instructions below, we want you to provide your rate card for all other chargeable disciplines in the agency, for each discipline  not captured within the mandated roles (yellow cells), with the exception of partnership marketing and  events and experiential). This information will not be used for any calculations for the pricing evaluation, but will be used to benchmark both within the ‘pool’ of respondents and against industry standards for future reference."]
[null,"Request","Please complete each template IN FULL for each of the disciplines shown in yellow, and where applicable, orange, and then add rates for any non-mandated roles as per the notes below for each specialism (with the exception of partnership marketing and events & experiential).\n\nPlease also note;  Only complete the partnership marketing and events & experiential tabs if you can supply these services from within your consortium excluding the need to specifically select a partnership marketing or events & experiential ‘stand-alone’ member to the consotium. Partnership marketing and events & experiential rates will not form part of your overall score but will be mandated rates should you be selected."]
[]
[null,"Description of key terminology used"]
[null,"Role","Complete your agency rate cards for all additional roles and for each tab/discipline. Please select from the list provided. Where a job title is not listed, please select the role which is the closest fit to the role within that department. A summary of all the Departments and Generic descriptors can be found on the third tab 'Dept & Generic descriptors'. Further explanation for each Generic descriptor can be found on the final tab 'Generic descriptor expl.' Please only use the 'Other' department if it is absolutely required."]
[null,"Special note on digital roles","With the changing nature of communications and agencies’ disciplines, we no longer list “Digital” as a function on its own. Instead we ask that you distribute these digital roles across functions. E.g. a Digital Creative would sit within “Creative” or a Digital Planner within “Analytics, Planning & Strategy”.  The exception to this being within “Production & Technology” where specialisms in execution endure E.g. Flash Developer."]
[null,"Actual job title","Input the job title you use within your agency for the role - this is a free field."]
[null,"Adding roles","If you need to add more roles for a department please add rows using the button provided."]
[null,"Currency",{"$f":"\"Please input the rates in: \" & Currency & \".\"","v":"Please input the rates in: British Pound - GBP."}]
[null,"Ownership","Please select from the options your agency's ownership/holding company."]
[null,"Number of billable hours","Billable hours in a working year at 100% of billable time. This will differ by region. For example, in the UK the industry standard in 1,600 hours."]
[null,"Hourly rate (Gross)","Please input the gross hourly rate. This is the base (salary) rate plus overhead and mark-up. Mark-up is the percentage applied to chargeable staff costs plus your overhead to achieve a profit-margin."]
[null,"Overhead ","Overhead relates to all your ongoing operating business expenses excluding direct costs of employment on chargeable personnel such as office rent/rates, utilities, new business, admin, network management, accounting and legal expenses. It excludes any direct materials or third-party expenses that would be billed directly to Clients. Please input this figure as the percentage of your hourly gross rates it accounts for."]
[null,"Profit margin","The percentage within your total cost that delivers your desired profit."]
[]
[null,"Notes on the Fee Template"]
[null,1,"Please do not amend, alter or remove any of the tabs and/or sheets in this workbook. "]
[null,2,"Please do not amend, alter or remove any of the formulas in this workbook."]
[null,3,"It is important that you read and have understand the worksheet before completing the template."]
[null,4,"All questions regarding this pricing matrix will need to be submitted via the eSourcing suite to CCS during the clarification period of the tender being live. More information on the clarification period and process can be found in Attachment 1 - Invitation to tender"]
[]
[null,"END"]

{"sheet":"Depts & Generic descriptors","index":1,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Departments and Generic descriptors"]
[]
[]
[null,"Agency Management","Account Management","Project Management ","Creative ","Analytics, Planning & Strategy","Production & Technology","Media Buying","Other "]
[null,"CEO","Department Head","Department Head","Department Head","Department Head","Department Head","Department Head","Department Head"]
[null,"Chairman","Senior","Senior","Senior","Senior","Broadcast Production - Senior","Senior","Senior"]
[null,"President","Middle (Upper)","Middle (Upper)","Middle (Upper)","Middle (Upper)","Broadcast Production - Middle (Upper)","Middle (Upper)","Middle (Upper)"]
[null,"Managing Director","Middle (Lower)","Middle (Lower)","Middle (Lower)","Middle (Lower)","Broadcast Production - Middle (Lower)","Middle (Lower)","Middle (Lower)"]
[null,"Other (e.g. Partner, COO, etc.)","Junior","Junior","Junior","Junior","Broadcast Production - Junior","Junior","Junior"]
[null,null,null,"Technology - Senior",null,null,"Print Production - Senior"]
[null,null,null,"Technology - Middle (Upper)",null,null,"Print Production - Middle (Upper)"]
[null,null,null,"Technology - Middle (Lower)",null,null,"Print Production - Middle (Lower)"]
[null,null,null,"Technology - Junior",null,null,"Print Production - Junior"]
[null,null,null,null,null,null,"Digital Production - Senior"]
[null,null,null,null,null,null,"Digital Production - Middle (Upper)"]
[null,null,null,null,null,null,"Digital Production - Middle (Lower)"]
[null,null,null,null,null,null,"Digital Production - Junior"]
[null,null,null,null,null,null,"Other Production - Senior"]
[null,null,null,null,null,null,"Other Production - Middle (Upper)"]
[null,null,null,null,null,null,"Other Production - Middle (Lower)"]
[null,null,null,null,null,null,"Other Production - Junior"]
[]
[null,"END"]

{"sheet":"Generic descriptors expl.","index":2,"n_rows":68,"n_cols":5,"rows_kept":68,"cut":false,"hidden":false,"merged":[[54,1,54,4],[60,1,60,4],[2,1,2,4],[8,1,8,4],[14,1,14,4],[24,1,24,4],[30,1,30,4],[36,1,36,4]]}
[]
[null,"Department/Generic Descriptor","Explanation","Example roles","Suggested years of experience"]
[null,"Agency Management"]
[{"$f":"$B$3&B4","v":"Agency ManagementCEO"},"CEO","Responsibility for the direction of the company, its culture and profitability. A team of senior managers will report into this individual but they ensure appropriate direction and strategies are in place. ","Chief Executive\nChief Executive Officer","10 years + "]
["Agency ManagementChairman","Chairman","Ensures that the agency's management is effective in setting and implementing the agency’s direction and strategy, and acts as the company’s leading representative externally.","Chairman","10 years + "]
["Agency ManagementPresident","President","Ensures that the agency's management is effective in setting and implementing the agency’s direction and strategy, and acts as the company’s leading representative externally.","President","10 years + "]
["Agency ManagementManaging Director","Managing Director","One of the most experienced personnel in an Agency. Provides overall direction in the business and has oversight of multiple client accounts.",null,"10 years + "]
["Agency ManagementOther (e.g. Partner, COO, etc.)","Other (e.g. Partner, COO, etc.)","e.g. COO - often second in command to the CEO with responsibilty for internal running of the agency, profitability, operating budgets","Partner\nChief Operating Officer                 Operations Director       ","10 years + "]
[null,"Account Management"]
[{"$f":"$B$9&B10","v":"Account ManagementDepartment Head"},"Department Head","Functional area leader with ultimate accountability for that discipline within the agency. Reports into agency senior management.","Client Services Directcor                      \nDirector                                        \nDivision Head","10 years + "]
["Account ManagementSenior","Senior","Takes overall responsibility for the development and management of accounts. Lead client-facing role.","Business Director                           \nGroup Account Director                    \n Senior Account Director\nAccount Director\nAssociate Account Director\nAssociate Director\nRegional Director\nSenior Consultant","8 years +"]
["Account ManagementMiddle (Upper)","Middle (Upper)","Second in command on the management of an account. Deputy in the client-facing role and highly operational. Reports into account lead such as account director.  ","Junior Account Director\nAccount Supervisor\nAssociate Consultant\nSenior Account Manager \nConsultant\nClient Services Associate","5 years + "]
["Account ManagementMiddle (Lower)","Middle (Lower)","Experience within marketing services, supports the account under supervision. Responsible for day to day organisation of an account.  ","Account Manager                                    \nSenior Account Executive\nAccount Manager\nAccount Manager Assistant ","3 - 5 years"]
["Account ManagementJunior","Junior","A junior member of the client services team. Their role is to support the main account handling team. In most cases they will work closely and report into an account manager. ","Account Coordinator\nAccount Executive\nJunior Account Executive\nAssistant\nAccount Assistant\nAccount Executive\nAssistant Account Executive","Up to 3 years"]
[null,"Project Management"]
[{"$f":"$B$15&B16","v":"Project ManagementDepartment Head"},"Department Head","Functional area leader with ultimate accountability for that discipline within the agency. Reports into agency senior management.","Group Project Manager                \nHead of Project Management","10 years + "]
["Project ManagementSenior","Senior","Plays a lead role managing a team and provides a link between departments such as client service, creative, and technology. Ensures ideas conceptualised by the creative team can be produced in reality. An external facing role with significant client contact. ","Project Director\nSenior Project Manager                     \nLead Project Manager","8 years +"]
["Project ManagementMiddle (Upper)","Middle (Upper)","Manages the day to day operational and tactical aspects of multiple projects. Generally an internal role, but some client contact required.","Associate Project Manager                        Project Manager","5 years + "]
["Project ManagementMiddle (Lower)","Middle (Lower)","An internal-facing role which supports the account lead in the day to day operational aspects of projects.","Senior Project Executive           \nExecutive Project Manager           \nAssociate Project Manager           \nAssistant Project Manager","3 - 5 years"]
["Project ManagementJunior","Junior","An internal-facing role which provides day to day support to the project management team. ","Trainee\nProject Administrator\nProject Executive","Up to 3 years"]
["Project ManagementTechnology - Senior","Technology - Senior","Plays a lead role managing a team and provides a link between departments such as client service, creative, and technology. Ensures the digital and/or technological ideas conceptualised by the creative team can be produced in reality. An external facing role with significant client contact.","Digital Project Director                              Senior Digital Project Manager            \nLead Digital  Project Manager","8 years +"]
["Project ManagementTechnology - Middle (Upper)","Technology - Middle (Upper)","Manages the day to day technological and/or digital aspects of multiple projects. Generally an internal role, but some client contact required.","Associate Digital Project Manager                                       Digital Project Manager                           Community Manager","5 years + "]
["Project ManagementTechnology - Middle (Lower)","Technology - Middle (Lower)","An internal-facing role which supports the account lead in the day to day technological and/or digital aspects of projects.","Senior Digital Project Executive                 Executive Digital Project Manager                            Associate Digital Project Manager                             Assistant Digital Project Manager \nCommunity Manager                             \nSocial Community Manager                      Social Community Executive ","3 - 5 years"]
["Project ManagementTechnology - Junior","Technology - Junior","An internal-facing role which provides technological and/or digital support to the team to aide project delivery.","Digital Trainee\nDigital Project Administrator\nDigital Project Executive","Up to 3 years"]
[null,"Creative"]
[{"$f":"$B$25&B26","v":"CreativeDepartment Head"},"Department Head","Functional area leader with ultimate accountability for that discipline within the agency. Reports into agency senior management. Responsible for the overall quality and efficacy of the creative product of the agency. ","Chief Creative Director\nChief Creative Officer\nExecutive Creative Director          \nGroup Head Creative\nCreative Group Head\nCreative Partner                            ","10 years + "]
["CreativeSenior","Senior","Conceptualises various creative routes in response to a client brief. Brand guardians from a visual and written perspective. Reports into the head of department.","Creative Director                          \nAssociate Creative Director\nDigital Creative Director\nSenior Creative Director\nCreative Director (Copy) \nCreative Director (Art) \nSenior Art Director\nDesign Director                              \nSenior Digital Designer                   \nHead of Digital\nAssociate Design Director\nSenior Art Director\nSenior Designer\nHead of Design\nSenior Visualiser\nSenior Graphic Designer\nSenior Copywriter \nSenior Content Writer","8 years +"]
["CreativeMiddle (Upper)","Middle (Upper)","Typically works to a brief set to them by a creative director with a remit to originate ideas for the brief for approval by the creative director. ","Art Director                                              Copywriter                               \nIntermediate Illustrator\nIntermediate Copywriter\nCopy Supervisor","5 years + "]
["CreativeMiddle (Lower)","Middle (Lower)","Typically works to a brief set to them by a creative director with a remit to originate ideas for the brief for approval by the creative director. Also supports the creative team to visualise ideas. ","Art Director                                    \nCopywriter                                  \nGraphic Designer\nDesigner\nIllustrator\nVisualiser\nArtworker\nArtist","3 - 5 years"]
["CreativeJunior","Junior","More of an internal-facing role, sometimes working to a brief set to them by a creative director with a remit to originate ideas for approval by the creative director. Often providing day to day support to more senior creative teams. ","Junior Digital Designer\nJunior Visualiser\nJunior Copywriter\nJunior Art Director\nArt Assistant\nDesign Assistant\nCopywriter Executive \nJunior Content Writer\nProofreader","Up to 3 years"]
[null,"Analytics, Planning & Strategy"]
[{"$f":"$B$31&B32","v":"Analytics, Planning & StrategyDepartment Head"},"Department Head","Functional area leader with ultimate accountability for that discipline within the agency. Reports into agency senior management. Leads all client business strategy development. ","Head of Planning                                                  Chief Strategy Officer                          \nHead of Digital Planning                                                 Director of Media Planning                 Analytics & CRM Director                                     ","10 years + "]
["Analytics, Planning & StrategySenior","Senior","Integrates insight, planning and data across client business and oversees work of planning team.  ","Director, User Experience               \nStrategy Director                       \nPlanning Director   \nData Service Director\nHead of Data                                 \nSenior Brand Strategist \nSenior Planner\nSenior Digital Planner\nSenior Comms Planner\nSenior Media Planner\nSenior Analyst                                            \nSocial Media Director                                            Content Strategist","8 years +"]
["Analytics, Planning & StrategyMiddle (Upper)","Middle (Upper)","Undertakes research, provides insight on strategy and approach. Creates integrated communications strategies and carries out evaluation and analysis. ","Planner\nBrand Planner\nSocial Strategist\nAnalyst\nData Analyst\nMedia Planner                                    \nAnalytics & CRM Manager                \nStrategic Planner","5 years + "]
["Analytics, Planning & StrategyMiddle (Lower)","Middle (Lower)","Conducts desk research and works with researchers. Involved in customer journey development, creative or media briefing and guidance, as well as evaluation of communications strategy. ","Planner\nBrand Planner\nSocial Strategist\nAnalyst\nData Analyst\nMedia Planner                                    \nAnalytics & CRM Manager                \nStrategic Planner","3 - 5 years"]
["Analytics, Planning & StrategyJunior","Junior","A more internal facing role providing day to day assistance to the analytics, planning and strategy teams.  Conducts desk research and works with researchers.","Junior Planner\nAssistant Planner\nJunior Brand Strategist\nJunior Strategic Planner\nJunior Strategist\nStrategy Executive\nJunior Data Planner\nJunior Data Analyst","Up to 3 years"]
[null,"Production & Technology"]
[{"$f":"$B$37&B38","v":"Production & TechnologyDepartment Head"},"Department Head","Functional area leader with ultimate accountability for that discipline within the agency. Reports into agency senior management.","Chief Technology Officer\nTechnology Director                        \nChief Digital Officer                           \nHead of Production                                \nHead of Technology                                      Head of Digital                                  \nHead of Broadcast","10 years + "]
["Production & TechnologyBroadcast Production - Senior","Broadcast Production - Senior","Substantial broadcast production and post-production experience with broadcast technology understanding. Use of complex production techniques. Manages a production team. ","Senior Producer\nSenior TV Producer\nFilm Director\nSenior Editor","8 years +"]
["Production & TechnologyBroadcast Production - Middle (Upper)","Broadcast Production - Middle (Upper)","Practical experience running shoots, film crews and edit teams. ","Production Controller\nProducer (TV/Video/Audio Visual/Radio)\nFilm Producer\nFilm Manager                     \nAV Producer\nPost Producer\nProduction Controller Video Producer","5 years + "]
["Production & TechnologyBroadcast Production - Middle (Lower)","Broadcast Production - Middle (Lower)","Practical experience running shoots, film crews and edit teams. ","Production Assistant\nEdit Assistant                                 \nAssistant Production Manager","3 - 5 years"]
["Production & TechnologyBroadcast Production - Junior","Broadcast Production - Junior","Supports the broadcast team in an administrative role. ","TV Admin\nTV Assistant\n TV Coordinator                             \nJunior TV Producer\nJunior Producer","Up to 3 years"]
["Production & TechnologyPrint Production - Senior","Print Production - Senior",null,"Print Production Manager\nHead of Print Production\nChief Producer\nPrint Production Director\nDirector of Print Production","8 years +"]
["Production & TechnologyPrint Production - Middle (Upper)","Print Production - Middle (Upper)",null,"Print Producer Manager\nAssociate Director Print ","5 years + "]
["Production & TechnologyPrint Production - Middle (Lower)","Print Production - Middle (Lower)",null,"Assistant Print Production \nFinishing Artist                                                 Print Production Assistant ","3 - 5 years"]
["Production & TechnologyPrint Production - Junior","Print Production - Junior","Administrative support function to the print production team.    ","Administration\nPrint Junior \nProofreader\nPrint Executive","Up to 3 years"]
["Production & TechnologyDigital Production - Senior","Digital Production - Senior","Leads on several accounts in a client facing role whilst also managing a team. Acts as the linchpin between creative and production. Works across a range of disciplines with extensive experience in creative concept development, technical development and delivery, user experience and design, copywriting and video production. ","Senior User Experience\nSenior Developer\nSenior Web Producer\nSenior Systems Engineer\nSenior Coder\nSenior Technologist\nHead of Digital Production\nTechnology Manager\nDigital Director\nSenior Developer\nSenior Software Engineer\nSenior Technical Producer\nSenior SEO Executive\nHead of UX","8 years +"]
["Production & TechnologyDigital Production - Middle (Upper)","Digital Production - Middle (Upper)","Strong technical skills and experience of software platforms. Understanding of product design, software and digital development and brand strategy.\n","Online Marketing Manager              \nFlash Developer                               \nDigital Producer                             \nTechnical Manager                          \n3D/CGI Artist\n3D Motion Animation\nDigital Developer\nFront End Developer\nWeb Developer\nSoftware Engineer\nQA Manager\nWeb Producer\nColour Retoucher\nContent Engineer                        \nGraphic Designer                           \nMedia Developer                           \nData Analyst                                       \nUX Architect\nContent Manager                            \nGrowth Hacker ","5 years + "]
["Production & TechnologyDigital Production - Middle (Lower)","Digital Production - Middle (Lower)","Skills and experience of software platforms. Understanding of product design, software and digital development and brand strategy.\n","Online Marketing Manager     \nFlash Developer                               \nDigital Producer                   \nTechnical Manager                  \n3D/CGI Artist\n3D Motion Animation\nDigital Developer\nFront End Developer\nWeb Developer\nSoftware Engineer\nQA Manager\nWeb Producer\nColour Retoucher\nContent Engineer                  \nGraphic Designer                           \nMedia Developer                    \nData Analyst                               \nUX Architect\nContent Manager                            \nGrowth Hacker ","3 - 5 years"]
["Production & TechnologyDigital Production - Junior","Digital Production - Junior","Provides day to day support to the digital production team in an administrative role.","System Administrator\nSupport Analyst\nWeb Administration\nExecutive Digital Producer\nEcommerce Admin Assistant        \nJunior User Experience ","Up to 3 years"]
["Production & TechnologyOther Production - Senior","Other Production - Senior","Experienced in integration and production. Works on a range of creative projects. Leads a team of Producers and works closely with the creative director.  ","Senior Producer                              \nStudio Director                                \nTraffic Director                             \nDirector of Photography","8 years +"]
["Production & TechnologyOther Production - Middle (Upper)","Other Production - Middle (Upper)","Integrated producer, involved in the creative development through to delivery.","Art Studio Manager\nCreative Producer\nEvents Producer                                 \nArt Buyer\nTalent Coordinator\nMusic Production","5 years + "]
["Production & TechnologyOther Production - Middle (Lower)","Other Production - Middle (Lower)","Integrated producer, involved in the creative development through to delivery.","Art Studio Manager\nCreative Producer\nEvents Producer                                 \nArt Buyer\nTalent Coordinator\nMusic Production","3 - 5 years"]
["Production & TechnologyOther Production - Junior","Other Production - Junior","Supports the production team on a day to day basis in an administrative role. ","Assistant Studio Manager\nJunior Quality Assurance","Up to 3 years"]
[null,"Media Buying"]
[{"$f":"$B$55&B56","v":"Media BuyingDepartment Head"},"Department Head","Functional area leader with ultimate accountability for that discipline within the agency. Reports into agency senior management.","Head of Media ","10 years + "]
["Media BuyingSenior","Senior","Negotiate, purchase and monitor advertising space and airtime. Works on multiple accounts. Campaign bookings, campaign evaluation, media value, understanding of a media portfolio and strategy planning. \n","Senior Media Buyer\nSenior PPC\nSenior SEO\nSenior Digital Buyer\nBuying Director\nSenior TV Buyer","8 years +"]
["Media BuyingMiddle (Upper)","Middle (Upper)","Negotiate, purchase and monitor advertising space and airtime. Experience working on different accounts. Campaign bookings, campaign evaluation, media value, understanding of a media portfolio. ","Media Buyer\nDigital Buyer\nDigital Media Buyer \nPPC\nSEO","5 years + "]
["Media BuyingMiddle (Lower)","Middle (Lower)","Knowledge of media trading industry, able to manage day-to-day commercial relationships with contractors. Operates the booking process. ","Assistant Media Buyer","3 - 5 years"]
["Media BuyingJunior","Junior","Supports planning and buying campaigns. ","Junior Media Buyer\nJunior Digital Buyer\nJunior PPC\nJunior SEO\nExecutive Buyer\nPrint Planner Buyer","Up to 3 years"]
[null,"Other"]
[{"$f":"$B$61&B62","v":"OtherDepartment Head"},"Department Head","Please only select this option if the role truly does not fit under any other department. The role is a functional area leader with ultimate accountability for the discipline within the agency. Reports into agency senior management.","n/a","10 years + "]
["OtherSenior ","Senior ","Please only select this option if the role truly does not fit under any other department. ","n/a","8 years +"]
["OtherMiddle (Upper)","Middle (Upper)","Please only select this option if the role truly does not fit under any other department. ","n/a","5 years + "]
["OtherMiddle (Lower)","Middle (Lower)","Please only select this option if the role truly does not fit under any other department. ","n/a","3 - 5 years"]
["OtherJunior","Junior","Please only select this option if the role truly does not fit under any other department. ","n/a","Up to 3 years"]
[]
[null,"END"]

{"sheet":"Incl USA","index":3,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":true,"merged":[[2,0,2,7]]}
["Note to AM - the difference between this and tab 3 that Department Overall is included. Department Overall will be in GARD but we won’t want it as a drop down for all our offices bar US. Note we do not need a template for the US at this time. "]
[]
["Departments and Generic descriptors"]
[]
[]
["Agency Management","Account Management","Project Management ","Creative ","Analytics, Planning and Strategy","Production & Technology ","Media Buying","Other "]
["Department Overall FTE (USA only)","Department Overall FTE (USA only)","Department Overall FTE (USA only)","Department Overall FTE (USA only)","Department Overall FTE (USA only)","Department Overall FTE (USA only)","Department Overall FTE (USA only)","Department Overall FTE (USA only)"]
["CEO","Department Head","Department Head","Department Head","Department Head","Department Head","Department Head","Department Head"]
["Chairman","Senior","Senior","Senior","Senior","Broadcast Production - Senior","Senior","Senior"]
["President","Middle (Upper)","Middle (Upper)","Middle (Upper)","Middle (Upper)","Broadcast Production - Middle (Upper)","Middle (Upper)","Middle (Upper)"]
["Managing Director","Middle (Lower)","Middle (Lower)","Middle (Lower)","Middle (Lower)","Broadcast Production - Middle (Lower)","Middle (Lower)","Middle (Lower)"]
["Other (e.g. Partner, COO, etc.)","Junior","Junior","Junior","Junior","Broadcast Production - Junior","Junior","Junior"]
[null,null,"Technology - Senior",null,null,"Print Production - Senior"]
[null,null,"Technology - Middle (Upper)",null,null,"Print Production - Middle (Upper)"]
[null,null,"Technology - Middle (Lower)",null,null,"Print Production - Middle (Lower)"]
[null,null,"Technology - Junior",null,null,"Print Production - Junior"]
[null,null,null,null,null,"Digital Production - Senior"]
[null,null,null,null,null,"Digital Production - Middle (Upper)"]
[null,null,null,null,null,"Digital Production - Middle (Lower)"]
[null,null,null,null,null,"Digital Production - Junior"]
[null,null,null,null,null,"Other Production - Senior"]
[null,null,null,null,null,"Other Production - Middle (Upper)"]
[null,null,null,null,null,"Other Production - Middle (Lower)"]
[null,null,null,null,null,"Other Production - Junior"]
[]
["END"]

{"sheet":"Drop-downs","index":4,"n_rows":197,"n_cols":8,"rows_kept":197,"cut":false,"hidden":true,"merged":[]}
[]
[null,{"$f":"COUNTA(B4:B303)","v":163},null,{"$f":"COUNTA(D4:D303)","v":194},null,{"$f":"COUNTA(F4:F303)","v":6},null,{"$f":"COUNTA(H4:H303)","v":8}]
[null,"Currency of rates",null,"Country",null,"Number of agency employees",null,"Agency ownership"]
[null,"Australian Dollar - AUD",null,"Afghanistan",null,"1 to 10",null,"Dentsu/Aegis"]
[null,"British Pound - GBP",null,"Albania",null,"11 to 50",null,"Havas"]
[null,"Euro - EUR",null,"Algeria",null,"51 to 100",null,"IPG"]
[null,"Japanese Yen - JPY",null,"Andorra",null,"101 to 250",null,"Omnicom"]
[null,"Swiss Franc - CHF",null,"Angola",null,"251 to 400",null,"Publicis"]
[null,"US Dollar - USD",null,"Antigua and Barbuda",null,"401 +",null,"WPP"]
[null,"Afghanistan Afghani - AFN",null,"Argentina",null,null,null,"Independent"]
[null,"Albanian Lek - ALL",null,"Armenia",null,null,null,"Other Group"]
[null,"Algerian Dinar - DZD",null,"Australia"]
[null,"Angolan Kwanza - AOA",null,"Austria"]
[null,"Argentine Peso - ARS",null,"Azerbaijan"]
[null,"Armenian Dram - AMD",null,"Bahamas"]
[null,"Aruban Florin - AWG",null,"Bahrain"]
[null,"Australian Dollar - AUD",null,"Bangladesh"]
[null,"Azerbaijan New Manat - AZN",null,"Barbados"]
[null,"Bahamian Dollar - BSD",null,"Belarus"]
[null,"Bahraini Dinar - BHD",null,"Belgium"]
[null,"Bangladeshi Taka - BDT",null,"Belize"]
[null,"Barbados Dollar - BBD",null,"Benin"]
[null,"Belarusian Ruble - BYR",null,"Bhutan"]
[null,"Belize Dollar - BZD",null,"Bolivia"]
[null,"Bermudian Dollar - BMD",null,"Bosnia and Herzegovina"]
[null,"Bhutan Ngultrum - BTN",null,"Botswana"]
[null,"Bolivian Boliviano - BOB",null,"Brazil"]
[null,"Bosnian Mark - BAM",null,"Brunei"]
[null,"Botswana Pula - BWP",null,"Bulgaria"]
[null,"Brazilian Real - BRL",null,"Burkina"]
[null,"British Pound - GBP",null,"Burma (Myanmar)"]
[null,"Brunei Dollar - BND",null,"Burundi"]
[null,"Bulgarian Lev - BGN",null,"Cambodia"]
[null,"Burundi Franc - BIF",null,"Cameroon"]
[null,"CFA Franc BCEAO - XOF",null,"Canada"]
[null,"CFA Franc BEAC - XAF",null,"Cape Verde"]
[null,"CFP Franc - XPF",null,"Central African Republic"]
[null,"Cambodian Riel - KHR",null,"Chad"]
[null,"Canadian Dollar - CAD",null,"Chile"]
[null,"Cape Verde Escudo - CVE",null,"China"]
[null,"Cayman Islands Dollar - KYD",null,"Colombia"]
[null,"Chilean Peso - CLP",null,"Comoros"]
[null,"Chinese Yuan/Renminbi - CNY",null,"Congo"]
[null,"Colombian Peso - COP",null,"Congo, Democratic Republic of"]
[null,"Comoros Franc - KMF",null,"Costa Rica"]
[null,"Congolese Franc - CDF",null,"Croatia"]
[null,"Costa Rican Colon - CRC",null,"Cuba"]
[null,"Croatian Kuna - HRK",null,"Cyprus"]
[null,"Cuban Convertible Peso - CUC",null,"Czech Republic"]
[null,"Cuban Peso - CUP",null,"Denmark"]
[null,"Czech Koruna - CZK",null,"Djibouti"]
[null,"Danish Krone - DKK",null,"Dominica"]
[null,"Djibouti Franc - DJF",null,"Dominican Republic"]
[null,"Dominican R Peso - DOP",null,"East Timor"]
[null,"East Caribbean Dollar - XCD",null,"Ecuador"]
[null,"Egyptian Pound - EGP",null,"Egypt"]
[null,"El Salvador Colon - SVC",null,"El Salvador"]
[null,"Ethiopian Birr - ETB",null,"Equatorial Guinea"]
[null,"Euro - EUR",null,"Eritrea"]
[null,"Falkland Islands Pound - FKP",null,"Estonia"]
[null,"Fiji Dollar - FJD",null,"Ethiopia"]
[null,"Gambian Dalasi - GMD",null,"Fiji"]
[null,"Georgian Lari - GEL",null,"Finland"]
[null,"Ghanaian New Cedi - GHS",null,"France"]
[null,"Gibraltar Pound - GIP",null,"Gabon"]
[null,"Gold (oz) - XAU",null,"Gambia"]
[null,"Guatemalan Quetzal - GTQ",null,"Georgia"]
[null,"Guinea Franc - GNF",null,"Germany"]
[null,"Guyanese Dollar - GYD",null,"Ghana"]
[null,"Haitian Gourde - HTG",null,"Greece"]
[null,"Honduran Lempira - HNL",null,"Grenada"]
[null,"Hong Kong Dollar - HKD",null,"Guatemala"]
[null,"Hungarian Forint - HUF",null,"Guinea"]
[null,"Iceland Krona - ISK",null,"Guinea-Bissau"]
[null,"Indian Rupee - INR",null,"Guyana"]
[null,"Indonesian Rupiah - IDR",null,"Haiti"]
[null,"Iranian Rial - IRR",null,"Honduras"]
[null,"Iraqi Dinar - IQD",null,"Hungary"]
[null,"Israeli New Shekel - ILS",null,"Iceland"]
[null,"Jamaican Dollar - JMD",null,"India"]
[null,"Japanese Yen - JPY",null,"Indonesia"]
[null,"Jordanian Dinar - JOD",null,"Iran"]
[null,"Kazakhstan Tenge - KZT",null,"Iraq"]
[null,"Kenyan Shilling - KES",null,"Ireland"]
[null,"Kuwaiti Dinar - KWD",null,"Israel"]
[null,"Kyrgyzstanian Som - KGS",null,"Italy"]
[null,"Lao Kip - LAK",null,"Ivory Coast"]
[null,"Latvian Lats - LVL",null,"Jamaica"]
[null,"Lebanese Pound - LBP",null,"Japan"]
[null,"Lesotho Loti - LSL",null,"Jordan"]
[null,"Liberian Dollar - LRD",null,"Kazakhstan"]
[null,"Libyan Dinar - LYD",null,"Kenya"]
[null,"Lithuanian Litas - LTL",null,"Kiribati"]
[null,"Macau Pataca - MOP",null,"Korea, North"]
[null,"Macedonian Denar - MKD",null,"Korea, South"]
[null,"Malagasy Ariary - MGA",null,"Kuwait"]
[null,"Malawi Kwacha - MWK",null,"Kyrgyzstan"]
[null,"Malaysian Ringgit - MYR",null,"Laos"]
[null,"Maldive Rufiyaa - MVR",null,"Latvia"]
[null,"Mauritanian Ouguiya - MRO",null,"Lebanon"]
[null,"Mauritius Rupee - MUR",null,"Lesotho"]
[null,"Mexican Peso - MXN",null,"Liberia"]
[null,"Moldovan Leu - MDL",null,"Libya"]
[null,"Mongolian Tugrik - MNT",null,"Liechtenstein"]
[null,"Moroccan Dirham - MAD",null,"Lithuania"]
[null,"Mozambique New Metical - MZN",null,"Luxembourg"]
[null,"Myanmar Kyat - MMK",null,"Macedonia"]
[null,"NL Antillian Guilder - ANG",null,"Madagascar"]
[null,"Namibia Dollar - NAD",null,"Malawi"]
[null,"Nepalese Rupee - NPR",null,"Malaysia"]
[null,"New Zealand Dollar - NZD",null,"Maldives"]
[null,"Nicaraguan Cordoba Oro - NIO",null,"Mali"]
[null,"Nigerian Naira - NGN",null,"Malta"]
[null,"North Korean Won - KPW",null,"Marshall Islands"]
[null,"Norwegian Kroner - NOK",null,"Mauritania"]
[null,"Omani Rial - OMR",null,"Mauritius"]
[null,"Pakistan Rupee - PKR",null,"Mexico"]
[null,"Panamanian Balboa - PAB",null,"Micronesia"]
[null,"Papua New Guinea Kina - PGK",null,"Moldova"]
[null,"Paraguay Guarani - PYG",null,"Monaco"]
[null,"Peruvian Nuevo Sol - PEN",null,"Mongolia"]
[null,"Philippine Peso - PHP",null,"Montenegro"]
[null,"Polish Zloty - PLN",null,"Morocco"]
[null,"Qatari Rial - QAR",null,"Mozambique"]
[null,"Romanian New Lei - RON",null,"Namibia"]
[null,"Russian Rouble - RUB",null,"Nauru"]
[null,"Rwandan Franc - RWF",null,"Nepal"]
[null,"Samoan Tala - WST",null,"Netherlands"]
[null,"Sao Tome/Principe Dobra - STD",null,"New Zealand"]
[null,"Saudi Riyal - SAR",null,"Nicaragua"]
[null,"Serbian Dinar - RSD",null,"Niger"]
[null,"Seychelles Rupee - SCR",null,"Nigeria"]
[null,"Sierra Leone Leone - SLL",null,"Norway"]
[null,"Silver (oz) - XAG",null,"Oman"]
[null,"Singapore Dollar - SGD",null,"Pakistan"]
[null,"Solomon Islands Dollar - SBD",null,"Palau"]
[null,"Somali Shilling - SOS",null,"Panama"]
[null,"South African Rand - ZAR",null,"Papua New Guinea"]
[null,"South-Korean Won - KRW",null,"Paraguay"]
[null,"Sri Lanka Rupee - LKR",null,"Peru"]
[null,"St Helena Pound - SHP",null,"Philippines"]
[null,"Sudanese Pound - SDG",null,"Poland"]
[null,"Suriname Dollar - SRD",null,"Portugal"]
[null,"Swaziland Lilangeni - SZL",null,"Qatar"]
[null,"Swedish Krona - SEK",null,"Romania"]
[null,"Swiss Franc - CHF",null,"Russia"]
[null,"Syrian Pound - SYP",null,"Rwanda"]
[null,"Taiwan Dollar - TWD",null,"Saint Kitts and Nevis"]
[null,"Tanzanian Shilling - TZS",null,"Saint Lucia"]
[null,"Thai Baht - THB",null,"Saint Vincent & the Grenadines"]
[null,"Tonga Pa'anga - TOP",null,"Samoa"]
[null,"Trinidad/Tobago Dollar - TTD",null,"San Marino"]
[null,"Tunisian Dinar - TND",null,"Sao Tome and Principe"]
[null,"Turkish New Lira - TRY",null,"Saudi Arabia"]
[null,"Turkmenistan Manat - TMT",null,"Senegal"]
[null,"US Dollar - USD",null,"Serbia"]
[null,"Uganda Shilling - UGX",null,"Seychelles"]
[null,"Ukraine Hryvnia - UAH",null,"Sierra Leone"]
[null,"Uruguayan Peso - UYU",null,"Singapore"]
[null,"United Arab Emir Dirham - AED",null,"Slovakia"]
[null,"Vanuatu Vatu - VUV",null,"Slovenia"]
[null,"Venezuelan Bolivar - VEF",null,"Solomon Islands"]
[null,"Vietnamese Dong - VND",null,"Somalia"]
[null,"Yemeni Rial - YER",null,"South Africa"]
[null,"Zambian Kwacha - ZMK",null,"South Sudan"]
[null,"Zimbabwe Dollar - ZWD",null,"Spain"]
[null,null,null,"Sri Lanka"]
[null,null,null,"Sudan"]
[null,null,null,"Suriname"]
[null,null,null,"Swaziland"]
[null,null,null,"Sweden"]
[null,null,null,"Switzerland"]
[null,null,null,"Syria"]
[null,null,null,"Tajikistan"]
[null,null,null,"Tanzania"]
[null,null,null,"Thailand"]
[null,null,null,"Togo"]
[null,null,null,"Tonga"]
[null,null,null,"Trinidad and Tobago"]
[null,null,null,"Tunisia"]
[null,null,null,"Turkey"]
[null,null,null,"Turkmenistan"]
[null,null,null,"Tuvalu"]
[null,null,null,"Uganda"]
[null,null,null,"Ukraine"]
[null,null,null,"United Arab Emirates"]
[null,null,null,"United Kingdom"]
[null,null,null,"United States"]
[null,null,null,"Uruguay"]
[null,null,null,"Uzbekistan"]
[null,null,null,"Vanuatu"]
[null,null,null,"Vatican City"]
[null,null,null,"Venezuela"]
[null,null,null,"Vietnam"]
[null,null,null,"Yemen"]
[null,null,null,"Zambia"]
[null,null,null,"Zimbabwe"]

{"sheet":"Creative","index":5,"n_rows":132,"n_cols":9,"rows_kept":132,"cut":false,"hidden":false,"merged":[[3,4,3,5],[8,4,8,5],[1,4,1,6],[122,4,122,5]]}
[null,"Hide this column","Hide this column","Hide this column"]
[null,null,null,null,"Agency Fee Template - Creative"]
[]
[]
[null,null,null,null,"Client name","CCS"]
[null,null,null,null,"Client brand","Lot 1 - End to End Campaign Management"]
[null,null,null,null,"Currency of rates","British Pound - GBP"]
[]
[null,null,null,null,"Agency to complete"]
[null,null,null,null,"Agency name"]
[null,null,null,null,"Contact name"]
[null,null,null,null,"Job title"]
[null,null,null,null,"Email address"]
[null,null,null,null,"Date"]
[null,null,null,null,"Country"]
[null,null,null,null,"City"]
[null,null,null,null,"Number of employees"]
[null,null,null,null,"Number of billable hours in a working year"]
[null,null,null,null,"Ownership"]
[null,null,null,null,"Ownership where \"Other Group\""]
[null,null,null,null,"Overhead (% of base)"]
[null,null,null,null,"Profit margin (%)"]
[]
[null,null,null,null,"Role (click to select closest match)","Actual job title",{"$f":"\"Hourly rate (Gross, \" & IF(F7=\"\",\"TBC\",RIGHT(F7,3)) & \")\"","v":"Hourly rate (Gross, GBP)"}]
[]
[null,null,null,null,"Agency Management","Click to add additional rows"]
["Hide this row",null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,1001,"Agency Management_CEO_\nChief Executive Officer\n",{"$f":"$E$26","v":"Agency Management"},"CEO","\nChief Executive Officer\n"]
[null,1002,"Agency Management_Managing Director_Managing Director","Agency Management","Managing Director","Managing Director"]
[null,1003,"Agency Management_Other (e.g. Partner, COO, etc.)_Executive Creative Director","Agency Management","Other (e.g. Partner, COO, etc.)","Executive Creative Director"]
[null,1004,"Agency Management_Other (e.g. Partner, COO, etc.)_Chief Strategy Officer","Agency Management","Other (e.g. Partner, COO, etc.)","Chief Strategy Officer"]
[null,1005,"Agency Management_Other (e.g. Partner, COO, etc.)_Chief Technology Officer","Agency Management","Other (e.g. Partner, COO, etc.)","Chief Technology Officer"]
[null,null,null,"Agency Management",null,null,null,null,"û"]
[null,null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,null,"",null,"Account Management","Click to add additional rows"]
["Hide this row",1010,"",{"$f":"$E$35","v":"Account Management"},null,null,null,null,"û"]
[null,1011,"Account Management_Department Head_Department Head","Account Management","Department Head","Business Director/Client Partner"]
[null,1012,"Account Management_Senior_Senior Account Director","Account Management","Senior","Senior Account Director"]
[null,1013,"Account Management_Senior_Account Director","Account Management","Senior","Account Director"]
[null,1014,"Account Management_Middle (Upper)_Account Supervisor","Account Management","Middle (Upper)","Account Supervisor"]
[null,1015,"Account Management_Middle (Upper)_Senior Account Manager ","Account Management","Middle (Upper)","Senior Account Manager "]
[null,1016,"Account Management_Middle (Lower)_Account Manager","Account Management","Middle (Lower)","Account Manager"]
[null,1017,"Account Management_Middle (Lower)_Project Manager","Account Management","Middle (Lower)","Project Manager"]
[null,1018,"Account Management_Junior_Account Executive","Account Management","Junior","Account Executive"]
[null,1019,"Account Management_Junior_Account Assistant","Account Management","Junior","Account Assistant"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"",null,"Project Management","Click to add additional rows"]
["Hide this row",1041,"",{"$f":"$E$49","v":"Project Management"},null,null,null,null,"û"]
[null,1042,"Project Management_Department Head_Head of Project Management","Project Management","Department Head","Head of Project Management"]
[null,1043,"Project Management_Senior_Project Director","Project Management","Senior","Project Director"]
[null,1044,"Project Management_Senior_Senior Project Manager","Project Management","Senior","Senior Project Manager"]
[null,1045,"Project Management_Middle (Upper)_Project Manager","Project Management","Middle (Upper)","Project Manager"]
[null,1046,"Project Management_Junior_Project Administrator","Project Management","Junior","Project Administrator"]
[null,1047,"Project Management_Junior_Project Executive","Project Management","Junior","Project Executive"]
[null,1048,"Project Management_Technology - Senior_Digital Project Director","Project Management","Technology - Senior","Digital Project Director"]
[null,1049,"Project Management_Technology - Senior_Senior Social Community Manager","Project Management","Technology - Senior","Senior Social Community Manager"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"",null,"Creative","Click to add additional rows"]
["Hide this row",1060,"",{"$f":"$E$62","v":"Creative"},null,null,null,null,"û"]
[null,1061,"Creative_Senior_Senior Art Director","Creative","Senior","Senior Art Director"]
[null,1062,"Creative_Senior_Senior Writer","Creative","Senior","Senior Writer"]
[null,1063,"Creative_Middle (Upper)_Art Director","Creative","Middle (Upper)","Art Director"]
[null,1064,"Creative_Middle (Upper)_Writer","Creative","Middle (Upper)","Writer"]
[null,1065,"Creative_Middle (Lower)_Graphic Designer","Creative","Middle (Lower)","Graphic Designer"]
[null,1066,"Creative_Middle (Lower)_Artworker","Creative","Middle (Lower)","Artworker"]
[null,1067,"Creative_Junior_Junior Writer","Creative","Junior","Junior Writer"]
[null,1068,"Creative_Junior_Junior Art Director","Creative","Junior","Junior Art Director"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"",null,"Analytics, Planning & Strategy","Click to add additional rows"]
["Hide this row",1073,"",{"$f":"$E$75","v":"Analytics, Planning & Strategy"},null,null,null,null,"û"]
[null,1074,"Analytics, Planning & Strategy_Senior_Strategy Director",{"$f":"$E$75","v":"Analytics, Planning & Strategy"},"Senior","Strategy Director"]
[null,1075,"Analytics, Planning & Strategy_Senior_Senior Planner","Analytics, Planning & Strategy","Senior","Senior Planner"]
[null,1076,"Analytics, Planning & Strategy_Middle (Upper)_Planner","Analytics, Planning & Strategy","Middle (Upper)","Planner"]
[null,1077,"Analytics, Planning & Strategy_Middle (Upper)_Social Strategist","Analytics, Planning & Strategy","Middle (Upper)","Data Planner"]
[null,1078,"Analytics, Planning & Strategy_Middle (Lower)_Assistant Planner","Analytics, Planning & Strategy","Middle (Lower)","Assistant Planner"]
[null,1079,"Analytics, Planning & Strategy_Middle (Lower)_Assistant Data Analyst","Analytics, Planning & Strategy","Middle (Lower)","Assistant Data Analyst"]
[null,1080,"Analytics, Planning & Strategy_Junior_Junior Planner","Analytics, Planning & Strategy","Junior","Junior Planner"]
[null,1081,"Analytics, Planning & Strategy_Junior_Junior Data Analyst","Analytics, Planning & Strategy","Junior","Junior Data Analyst"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"",null,"Production & Technology","Click to add additional rows"]
["Hide this row",1086,"",{"$f":"$E$88","v":"Production & Technology"},null,null,null,null,"û"]
[null,1087,"Production & Technology_Department Head_Head of Production","Production & Technology","Department Head","Head of Production"]
[null,1089,"Production & Technology_Broadcast Production - Senior_Senior Producer","Production & Technology","Broadcast Production - Senior","Senior Producer"]
[null,1090,"Production & Technology_Broadcast Production - Middle (Upper)_Producer","Production & Technology","Broadcast Production - Middle (Upper)","Producer"]
[null,1091,"Production & Technology_Broadcast Production - Middle (Lower)_Production Assistant","Production & Technology","Broadcast Production - Middle (Lower)","Production Assistant"]
[null,1092,"Production & Technology_Print Production - Middle (Upper)_Print Production Manager","Production & Technology","Print Production - Middle (Upper)","Print Production Manager"]
[null,1093,"Production & Technology_Print Production - Middle (Lower)_Print Production Assistant ","Production & Technology","Print Production - Middle (Lower)","Print Production Assistant "]
[null,1094,"Production & Technology_Print Production - Junior_Proofreader","Production & Technology","Print Production - Junior","Proofreader"]
[null,1095,"Production & Technology_Digital Production - Senior_Digital Director","Production & Technology","Digital Production - Senior","Digital Director"]
[null,1096,"Production & Technology_Digital Production - Senior_Senior SEO Executive","Production & Technology","Digital Production - Senior","SEO Director"]
[null,1097,"Production & Technology_Digital Production - Middle (Upper)_Digital Producer","Production & Technology","Digital Production - Middle (Upper)","Digital Producer"]
[null,1098,"Production & Technology_Digital Production - Middle (Upper)_Senior Content Manager","Production & Technology","Digital Production - Middle (Upper)","Senior Content Manager"]
[null,1099,"Production & Technology_Digital Production - Middle (Lower)_Digital Producer","Production & Technology","Digital Production - Middle (Lower)","Digital Producer"]
[null,1100,"Production & Technology_Digital Production - Middle (Lower)_Content Manager","Production & Technology","Digital Production - Middle (Lower)","Content Manager"]
[null,1101,"Production & Technology_Digital Production - Junior_System Administrator","Production & Technology","Digital Production - Junior","System Administrator"]
[null,1102,"Production & Technology_Digital Production - Junior_Support Analyst","Production & Technology","Digital Production - Junior","Support Analyst"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"",null,"Media Buying","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$108","v":"Media Buying"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$108","v":"Media Buying"},null,"hide it",null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"",null,"Other","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$114","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$114","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$114","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$114","v":"Other"},null,null,null,null,"û"]
[]
[]
[null,null,null,null,"END"]
[null,6666661,null,null,"Averaged Hourly Rate Creative",null,{"$f":"IF(F125<>E125,\"Not all essential rates are completed\",AVERAGE(G90:G96,G77:G84,G64:G71,G51:G58,G37:G45,G28:G32))","v":"Not all essential rates are completed"}]
[null,null,null,null,"Averaged Hourly Rate - Consurtium. N.B. This figure will be used for evaluation of pricing",null,{"$f":"IF(SUM(F125:F130)<>SUM(E125:E130),\"Not all essential rates are completed\",AVERAGE(G90:G96,G77:G84,G64:G71,G51:G58,G37:G45,G28:G32,\nContent!G28,Content!G33:G41,Content!G47:G60,Content!G66:G73,Content!G79:G86,Content!G92:G107,\n'Digital & Social'!G28:G32,'Digital & Social'!G37:G44,'Digital & Social'!G50:G57,'Digital & Social'!G63:G70,'Digital & Social'!G76:G83,'Digital & Social'!G89:G96,\n'Direct Marketing'!G28:G32,'Direct Marketing'!G37:G45,'Direct Marketing'!G51:G64,'Direct Marketing'!G70:G77,'Direct Marketing'!G83:G90,'Direct Marketing'!G96:G111,\nPR!G28:G29,PR!G34:G42,PR!G48:G61,PR!G77:G88,\nDesign!G28:G32,Design!G37:G45,Design!G51:G61,Design!G66:G73,Design!G79:G83,Design!G89:G97,\nPartnership!G28:G32,Partnership!G37:G45,Partnership!G51:G64,Partnership!G70:G77,Partnership!G83:G90,Partnership!G96:G111,\n'Events-Experiential'!G28:G29,'Events-Experiential'!G32:G38,'Events-Experiential'!G46:G51,'Events-Experiential'!G65:G70,'Events-Experiential'!G73:G79))","v":"Not all essential rates are completed"}]
[null,6666662,null,null," ",null,{"$f":"IF(G123<>\"Not all essential rates are completed\",\"\",\"Rates missing from:\")","v":"Rates missing from:"}]
["Creative",null,null,null,45,{"$f":"COUNT(G90:G96,G77:G84,G64:G71,G51:G58,G37:G45,G28:G32)","v":0},{"$f":"IF(E125<>F125,A125,\"\")","v":"Creative"}]
["Content",null,null,null,56,{"$f":"COUNT(Content!G28,Content!G33:G41,Content!G47:G60,Content!G66:G73,Content!G79:G86,Content!G92:G107)","v":0},"Content"]
["Digital & Social",null,null,null,45,{"$f":"COUNT('Digital & Social'!G28:G32,'Digital & Social'!G37:G44,'Digital & Social'!G50:G57,'Digital & Social'!G63:G70,'Digital & Social'!G76:G83,'Digital & Social'!G89:G96)","v":0},"Digital & Social"]
["Direct Marketing",null,null,null,60,{"$f":"COUNT('Direct Marketing'!G28:G32,'Direct Marketing'!G37:G45,'Direct Marketing'!G51:G64,'Direct Marketing'!G70:G77,'Direct Marketing'!G83:G90,'Direct Marketing'!G96:G111)","v":0},"Direct Marketing"]
["PR",null,null,null,37,{"$f":"COUNT(PR!G28:G29,PR!G34:G42,PR!G48:G61,PR!G77:G88)","v":0},"PR"]
["Design",null,null,null,47,{"$f":"COUNT(Design!G28:G32,Design!G37:G45,Design!G51:G61,Design!G66:G73,Design!G79:G83,Design!G89:G97)","v":0},"Design"]
["Partnership"]
["Events-Experimental"]

{"sheet":"Content","index":6,"n_rows":126,"n_cols":9,"rows_kept":126,"cut":false,"hidden":false,"merged":[[1,4,1,6],[3,4,3,5],[8,4,8,5]]}
[null,"Hide this column","Hide this column","Hide this column"]
[null,null,null,null,"Agency Fee Template - Content"]
[]
[]
[null,null,null,null,"Client name","CCS"]
[null,null,null,null,"Client brand","Lot 1 - End to End Campaign Management"]
[null,null,null,null,"Currency of rates","British Pound - GBP"]
[]
[null,null,null,null,"Agency to complete"]
[null,null,null,null,"Agency name"]
[null,null,null,null,"Contact name"]
[null,null,null,null,"Job title"]
[null,null,null,null,"Email address"]
[null,null,null,null,"Date"]
[null,null,null,null,"Country"]
[null,null,null,null,"City"]
[null,null,null,null,"Number of employees"]
[null,null,null,null,"Number of billable hours in a working year"]
[null,null,null,null,"Ownership"]
[null,null,null,null,"Ownership where \"Other Group\""]
[null,null,null,null,"Overhead (% of base)"]
[null,null,null,null,"Profit margin (%)"]
[]
[null,null,null,null,"Role (click to select closest match)","Actual job title",{"$f":"\"Hourly rate (Gross, \" & IF(F7=\"\",\"TBC\",RIGHT(F7,3)) & \")\"","v":"Hourly rate (Gross, GBP)"}]
[]
[null,null,null,null,"Agency Management","Click to add additional rows"]
["Hide this row",null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,1002,"Agency Management_Managing Director_Managing Director",{"$f":"$E$26","v":"Agency Management"},"Managing Director","Managing Director"]
[null,null,null,"Agency Management",null,null,null,null,"û"]
[null,null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,null,"",null,"Account Management","Click to add additional rows"]
["Hide this row",1010,"",{"$f":"$E$31","v":"Account Management"},null,null,null,null,"û"]
[null,1011,"Account Management_Department Head_Department Head","Account Management","Department Head","Department Head"]
[null,1012,"Account Management_Senior_Senior Account Director","Account Management","Senior","Senior Account Director"]
[null,1013,"Account Management_Senior_Account Director","Account Management","Senior","Account Director"]
[null,1014,"Account Management_Middle (Upper)_Account Supervisor","Account Management","Middle (Upper)","Account Supervisor"]
[null,1015,"Account Management_Middle (Upper)_Senior Account Manager ","Account Management","Middle (Upper)","Senior Account Manager "]
[null,1016,"Account Management_Middle (Lower)_Account Manager","Account Management","Middle (Lower)","Account Manager"]
[null,1017,"Account Management_Middle (Lower)_Project Manager","Account Management","Middle (Lower)","Project Manager"]
[null,1018,"Account Management_Junior_Account Executive","Account Management","Junior","Account Executive"]
[null,1019,"Account Management_Junior_Account Assistant","Account Management","Junior","Account Assistant"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"",null,"Project Management","Click to add additional rows"]
["Hide this row",1041,"",{"$f":"$E$45","v":"Project Management"},null,null,null,null,"û"]
[null,1042,"Project Management_Department Head_Head of Project Management","Project Management","Department Head","Head of Project Management"]
[null,1043,"Project Management_Senior_Project Director","Project Management","Senior","Project Director"]
[null,1044,"Project Management_Senior_Senior Project Manager","Project Management","Senior","Senior Project Manager"]
[null,1045,"Project Management_Middle (Upper)_Project Manager","Project Management","Middle (Upper)","Project Manager"]
[null,1046,"Project Management_Junior_Project Administrator","Project Management","Junior","Project Administrator"]
[null,1047,"Project Management_Junior_Project Executive","Project Management","Junior","Project Executive"]
[null,1048,"Project Management_Technology - Senior_Digital Project Director","Project Management","Technology - Senior","Digital Project Director"]
[null,1049,"Project Management_Technology - Senior_Senior Social Community Manager","Project Management","Technology - Senior","Senior Social Community Manager"]
[null,1050,"Project Management_Technology - Middle (Upper)_Digital Project Manager","Project Management","Technology - Middle (Upper)","Digital Project Manager"]
[null,1051,"Project Management_Technology - Middle (Upper)_Community Manager ","Project Management","Technology - Middle (Upper)","Community Manager "]
[null,1052,"Project Management_Technology - Middle (Lower)_Digital Project Executive","Project Management","Technology - Middle (Lower)","Digital Project Executive"]
[null,1053,"Project Management_Technology - Middle (Lower)_Social Community Manager","Project Management","Technology - Middle (Lower)","Social Community Manager"]
[null,1054,"Project Management_Technology - Junior_Junior project Manager","Project Management","Technology - Junior","Junior project Manager"]
[null,1055,"Project Management_Technology - Junior_Digital Project Administrator","Project Management","Technology - Junior","Digital Project Administrator"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"",null,"Creative","Click to add additional rows"]
["Hide this row",1060,"",{"$f":"$E$64","v":"Creative"},null,null,null,null,"û"]
[null,1061,"Creative_Senior_Senior Art Director","Creative","Senior","Senior Art Director"]
[null,1062,"Creative_Senior_Senior Writer","Creative","Senior","Senior Writer"]
[null,1063,"Creative_Middle (Upper)_Art Director","Creative","Middle (Upper)","Art Director"]
[null,1064,"Creative_Middle (Upper)_Writer","Creative","Middle (Upper)","Writer"]
[null,1065,"Creative_Middle (Lower)_Graphic Designer","Creative","Middle (Lower)","Graphic Designer"]
[null,1066,"Creative_Middle (Lower)_Artworker","Creative","Middle (Lower)","Artworker"]
[null,1067,"Creative_Junior_Junior Writer","Creative","Junior","Junior Writer"]
[null,1068,"Creative_Junior_Junior Art Director","Creative","Junior","Junior Art Director"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"",null,"Analytics, Planning & Strategy","Click to add additional rows"]
["Hide this row",1073,"",{"$f":"$E$77","v":"Analytics, Planning & Strategy"},null,null,null,null,"û"]
[null,1074,"Analytics, Planning & Strategy_Senior_Strategy Director",{"$f":"$E$77","v":"Analytics, Planning & Strategy"},"Senior","Strategy Director"]
[null,1075,"Analytics, Planning & Strategy_Senior_Senior Planner","Analytics, Planning & Strategy","Senior","Senior Planner"]
[null,1076,"Analytics, Planning & Strategy_Middle (Upper)_Planner","Analytics, Planning & Strategy","Middle (Upper)","Planner"]
[null,1077,"Analytics, Planning & Strategy_Middle (Upper)_Social Strategist","Analytics, Planning & Strategy","Middle (Upper)","Social Strategist"]
[null,1078,"Analytics, Planning & Strategy_Middle (Lower)_Assistant Planner","Analytics, Planning & Strategy","Middle (Lower)","Assistant Planner"]
[null,1079,"Analytics, Planning & Strategy_Middle (Lower)_Assistant Data Analyst","Analytics, Planning & Strategy","Middle (Lower)","Assistant Data Analyst"]
[null,1080,"Analytics, Planning & Strategy_Junior_Junior Planner","Analytics, Planning & Strategy","Junior","Junior Planner"]
[null,1081,"Analytics, Planning & Strategy_Junior_Junior Data Analyst","Analytics, Planning & Strategy","Junior","Junior Data Analyst"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"",null,"Production & Technology","Click to add additional rows"]
["Hide this row",1086,"",{"$f":"$E$90","v":"Production & Technology"},null,null,null,null,"û"]
[null,1087,"Production & Technology_Department Head_Head of Production","Production & Technology","Department Head","Head of Production"]
[null,1088,"Production & Technology_Department Head_Head of Digital","Production & Technology","Department Head","Head of Digital"]
[null,1089,"Production & Technology_Broadcast Production - Senior_Senior Producer","Production & Technology","Broadcast Production - Senior","Senior Producer"]
[null,1090,"Production & Technology_Broadcast Production - Middle (Upper)_Producer","Production & Technology","Broadcast Production - Middle (Upper)","Producer"]
[null,1091,"Production & Technology_Broadcast Production - Middle (Lower)_Production Assistant","Production & Technology","Broadcast Production - Middle (Lower)","Production Assistant"]
[null,1092,"Production & Technology_Print Production - Middle (Upper)_Print Production Manager","Production & Technology","Print Production - Middle (Upper)","Print Production Manager"]
[null,1093,"Production & Technology_Print Production - Middle (Lower)_Print Production Assistant ","Production & Technology","Print Production - Middle (Lower)","Print Production Assistant "]
[null,1094,"Production & Technology_Print Production - Junior_Proofreader","Production & Technology","Print Production - Junior","Proofreader"]
[null,1095,"Production & Technology_Digital Production - Senior_Digital Director","Production & Technology","Digital Production - Senior","Digital Director"]
[null,1096,"Production & Technology_Digital Production - Senior_Senior SEO Executive","Production & Technology","Digital Production - Senior","SEO Director"]
[null,1097,"Production & Technology_Digital Production - Middle (Upper)_Digital Producer","Production & Technology","Digital Production - Middle (Upper)","Digital Producer"]
[null,1098,"Production & Technology_Digital Production - Middle (Upper)_Senior Content Manager","Production & Technology","Digital Production - Middle (Upper)","Senior Content Manager"]
[null,1099,"Production & Technology_Digital Production - Middle (Lower)_Digital Producer","Production & Technology","Digital Production - Middle (Lower)","Digital Producer"]
[null,1100,"Production & Technology_Digital Production - Middle (Lower)_Content Manager","Production & Technology","Digital Production - Middle (Lower)","Content Manager"]
[null,1101,"Production & Technology_Digital Production - Junior_System Administrator","Production & Technology","Digital Production - Junior","System Administrator"]
[null,1102,"Production & Technology_Digital Production - Junior_Support Analyst","Production & Technology","Digital Production - Junior","Support Analyst"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"",null,"Media Buying","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$111","v":"Media Buying"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$111","v":"Media Buying"},null,"hide it",null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"",null,"Other","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$117","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$117","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$117","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$117","v":"Other"},null,null,null,null,"û"]
[]
[]
[null,null,null,null,"END"]
[null,6666661,null,null,"Averaged Hourly Rate",null,{"$f":"IF(COUNT(G28,G33:G41,G47:G60,G66:G73,G79:G86,G92:G107)<>56,\"Not all essential rates are completed\",AVERAGE(G28,G33:G41,G47:G60,G66:G73,G79:G86,G92:G107))","v":"Not all essential rates are completed"}]
[null,6666662]

{"sheet":"Digital & Social","index":7,"n_rows":115,"n_cols":9,"rows_kept":115,"cut":false,"hidden":false,"merged":[[1,4,1,6],[3,4,3,5],[8,4,8,5]]}
[null,"Hide this column","Hide this column","Hide this column"]
[null,null,null,null,"Agency Fee Template - Digital and Social"]
[]
[]
[null,null,null,null,"Client name","CCS"]
[null,null,null,null,"Client brand","Lot 1 - End to End Campaign Management"]
[null,null,null,null,"Currency of rates","British Pound - GBP"]
[]
[null,null,null,null,"Agency to complete"]
[null,null,null,null,"Agency name"]
[null,null,null,null,"Contact name"]
[null,null,null,null,"Job title"]
[null,null,null,null,"Email address"]
[null,null,null,null,"Date"]
[null,null,null,null,"Country"]
[null,null,null,null,"City"]
[null,null,null,null,"Number of employees"]
[null,null,null,null,"Number of billable hours in a working year"]
[null,null,null,null,"Ownership"]
[null,null,null,null,"Ownership where \"Other Group\""]
[null,null,null,null,"Overhead (% of base)"]
[null,null,null,null,"Profit margin (%)"]
[]
[null,null,null,null,"Role (click to select closest match)","Actual job title",{"$f":"\"Hourly rate (Gross, \" & IF(F7=\"\",\"TBC\",RIGHT(F7,3)) & \")\"","v":"Hourly rate (Gross, GBP)"}]
[]
[null,null,null,null,"Agency Management","Click to add additional rows"]
["Hide this row",null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,1001,"Agency Management_CEO_\nChief Executive Officer\n",{"$f":"$E$26","v":"Agency Management"},"CEO","\nChief Executive Officer\n"]
[null,1002,"Agency Management_Managing Director_Managing Director","Agency Management","Managing Director","Managing Director"]
[null,1003,"Agency Management_Other (e.g. Partner, COO, etc.)_Executive Creative Director","Agency Management","Other (e.g. Partner, COO, etc.)","Executive Creative Director"]
[null,1004,"Agency Management_Other (e.g. Partner, COO, etc.)_Chief Strategy Officer","Agency Management","Other (e.g. Partner, COO, etc.)","Chief Strategy Officer"]
[null,1005,"Agency Management_Other (e.g. Partner, COO, etc.)_Chief Technology Officer","Agency Management","Other (e.g. Partner, COO, etc.)","Chief Technology Officer"]
[null,null,null,"Agency Management",null,null,null,null,"û"]
[null,null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,null,"",null,"Account Management","Click to add additional rows"]
["Hide this row",1010,"",{"$f":"$E$35","v":"Account Management"},null,null,null,null,"û"]
[null,1012,"Account Management_Senior_Senior Account Director","Account Management","Senior","Senior Account Director"]
[null,1013,"Account Management_Senior_Account Director","Account Management","Senior","Account Director"]
[null,1014,"Account Management_Middle (Upper)_Account Supervisor","Account Management","Middle (Upper)","Account Supervisor"]
[null,1015,"Account Management_Middle (Upper)_Senior Account Manager ","Account Management","Middle (Upper)","Senior Account Manager "]
[null,1016,"Account Management_Middle (Lower)_Account Manager","Account Management","Middle (Lower)","Account Manager"]
[null,1017,"Account Management_Middle (Lower)_Project Manager","Account Management","Middle (Lower)","Project Manager"]
[null,1018,"Account Management_Junior_Account Executive","Account Management","Junior","Account Executive"]
[null,1019,"Account Management_Junior_Account Assistant","Account Management","Junior","Account Assistant"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"",null,"Project Management","Click to add additional rows"]
["Hide this row",1041,"",{"$f":"$E$48","v":"Project Management"},null,null,null,null,"û"]
[null,1048,"Project Management_Technology - Senior_Digital Project Director","Project Management","Technology - Senior","Digital Project Director"]
[null,1049,"Project Management_Technology - Senior_Senior Social Community Manager","Project Management","Technology - Senior","Senior Social Community Manager"]
[null,1050,"Project Management_Technology - Middle (Upper)_Digital Project Manager","Project Management","Technology - Middle (Upper)","Digital Project Manager"]
[null,1051,"Project Management_Technology - Middle (Upper)_Community Manager ","Project Management","Technology - Middle (Upper)","Community Manager "]
[null,1052,"Project Management_Technology - Middle (Lower)_Digital Project Executive","Project Management","Technology - Middle (Lower)","Digital Project Executive"]
[null,1053,"Project Management_Technology - Middle (Lower)_Social Community Manager","Project Management","Technology - Middle (Lower)","Social Community Manager"]
[null,1054,"Project Management_Technology - Junior_Junior project Manager","Project Management","Technology - Junior","Junior project Manager"]
[null,1055,"Project Management_Technology - Junior_Digital Project Administrator","Project Management","Technology - Junior","Digital Project Administrator"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"",null,"Creative","Click to add additional rows"]
["Hide this row",1060,"",{"$f":"$E$61","v":"Creative"},null,null,null,null,"û"]
[null,1061,"Creative_Senior_Senior Art Director","Creative","Senior","Senior Art Director"]
[null,1062,"Creative_Senior_Senior Writer","Creative","Senior","Senior Writer"]
[null,1063,"Creative_Middle (Upper)_Art Director","Creative","Middle (Upper)","Art Director"]
[null,1064,"Creative_Middle (Upper)_Writer","Creative","Middle (Upper)","Writer"]
[null,1065,"Creative_Middle (Lower)_Graphic Designer","Creative","Middle (Lower)","Graphic Designer"]
[null,1066,"Creative_Middle (Lower)_Artworker","Creative","Middle (Lower)","Artworker"]
[null,1067,"Creative_Junior_Junior Writer","Creative","Junior","Junior Writer"]
[null,1068,"Creative_Junior_Junior Art Director","Creative","Junior","Junior Art Director"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"",null,"Analytics, Planning & Strategy","Click to add additional rows"]
["Hide this row",1073,"",{"$f":"$E$74","v":"Analytics, Planning & Strategy"},null,null,null,null,"û"]
[null,1074,"Analytics, Planning & Strategy_Senior_Strategy Director",{"$f":"$E$74","v":"Analytics, Planning & Strategy"},"Senior","Strategy Director"]
[null,1075,"Analytics, Planning & Strategy_Senior_Senior Planner","Analytics, Planning & Strategy","Senior","Senior Planner"]
[null,1076,"Analytics, Planning & Strategy_Middle (Upper)_Planner","Analytics, Planning & Strategy","Middle (Upper)","Planner"]
[null,1077,"Analytics, Planning & Strategy_Middle (Upper)_Social Strategist","Analytics, Planning & Strategy","Middle (Upper)","Social Strategist"]
[null,1078,"Analytics, Planning & Strategy_Middle (Lower)_Assistant Planner","Analytics, Planning & Strategy","Middle (Lower)","Assistant Planner"]
[null,1079,"Analytics, Planning & Strategy_Middle (Lower)_Assistant Data Analyst","Analytics, Planning & Strategy","Middle (Lower)","Assistant Data Analyst"]
[null,1080,"Analytics, Planning & Strategy_Junior_Junior Planner","Analytics, Planning & Strategy","Junior","Junior Planner"]
[null,1081,"Analytics, Planning & Strategy_Junior_Junior Data Analyst","Analytics, Planning & Strategy","Junior","Junior Data Analyst"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"",null,"Production & Technology","Click to add additional rows"]
["Hide this row",1086,"",{"$f":"$E$87","v":"Production & Technology"},null,null,null,null,"û"]
[null,1095,"Production & Technology_Digital Production - Senior_Digital Director","Production & Technology","Digital Production - Senior","Digital Director"]
[null,1096,"Production & Technology_Digital Production - Senior_Senior SEO Executive","Production & Technology","Digital Production - Senior","SEO Director"]
[null,1097,"Production & Technology_Digital Production - Middle (Upper)_Digital Producer","Production & Technology","Digital Production - Middle (Upper)","Digital Producer"]
[null,1098,"Production & Technology_Digital Production - Middle (Upper)_Senior Content Manager","Production & Technology","Digital Production - Middle (Upper)","Senior Content Manager"]
[null,1099,"Production & Technology_Digital Production - Middle (Lower)_Digital Producer","Production & Technology","Digital Production - Middle (Lower)","Digital Producer"]
[null,1100,"Production & Technology_Digital Production - Middle (Lower)_Content Manager","Production & Technology","Digital Production - Middle (Lower)","Content Manager"]
[null,1101,"Production & Technology_Digital Production - Junior_System Administrator","Production & Technology","Digital Production - Junior","System Administrator"]
[null,1102,"Production & Technology_Digital Production - Junior_Support Analyst","Production & Technology","Digital Production - Junior","Support Analyst"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"",null,"Media Buying","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$100","v":"Media Buying"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$100","v":"Media Buying"},null,"hide it",null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"",null,"Other","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$106","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$106","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$106","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$106","v":"Other"},null,null,null,null,"û"]
[]
[]
[null,null,null,null,"END"]
[null,6666661,null,null,"Averaged Hourly Rate",null,{"$f":"IF(COUNT(G28:G32,G37:G44,G50:G57,G63:G70,G76:G83,G89:G96)<>45,\"Not all essential rates are completed\",AVERAGE(G28:G32,G37:G44,G50:G57,G63:G70,G76:G83,G89:G96))","v":"Not all essential rates are completed"}]
[null,6666662]

{"sheet":"Direct Marketing","index":8,"n_rows":130,"n_cols":9,"rows_kept":130,"cut":false,"hidden":false,"merged":[[1,4,1,6],[3,4,3,5],[8,4,8,5]]}
[null,"Hide this column","Hide this column","Hide this column"]
[null,null,null,null,"Agency Fee Template - Direct Marketing"]
[]
[]
[null,null,null,null,"Client name","CCS"]
[null,null,null,null,"Client brand","Lot 1 - End to End Campaign Management"]
[null,null,null,null,"Currency of rates","British Pound - GBP"]
[]
[null,null,null,null,"Agency to complete"]
[null,null,null,null,"Agency name"]
[null,null,null,null,"Contact name"]
[null,null,null,null,"Job title"]
[null,null,null,null,"Email address"]
[null,null,null,null,"Date"]
[null,null,null,null,"Country"]
[null,null,null,null,"City"]
[null,null,null,null,"Number of employees"]
[null,null,null,null,"Number of billable hours in a working year"]
[null,null,null,null,"Ownership"]
[null,null,null,null,"Ownership where \"Other Group\""]
[null,null,null,null,"Overhead (% of base)"]
[null,null,null,null,"Profit margin (%)"]
[]
[null,null,null,null,"Role (click to select closest match)","Actual job title",{"$f":"\"Hourly rate (Gross, \" & IF(F7=\"\",\"TBC\",RIGHT(F7,3)) & \")\"","v":"Hourly rate (Gross, GBP)"}]
[]
[null,null,null,null,"Agency Management","Click to add additional rows"]
["Hide this row",null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,1001,"Agency Management_CEO_\nChief Executive Officer\n",{"$f":"$E$26","v":"Agency Management"},"CEO","\nChief Executive Officer\n"]
[null,1002,"Agency Management_Managing Director_Managing Director","Agency Management","Managing Director","Managing Director"]
[null,1003,"Agency Management_Other (e.g. Partner, COO, etc.)_Executive Creative Director","Agency Management","Other (e.g. Partner, COO, etc.)","Executive Creative Director"]
[null,1004,"Agency Management_Other (e.g. Partner, COO, etc.)_Chief Strategy Officer","Agency Management","Other (e.g. Partner, COO, etc.)","Chief Strategy Officer"]
[null,1005,"Agency Management_Other (e.g. Partner, COO, etc.)_Chief Technology Officer","Agency Management","Other (e.g. Partner, COO, etc.)","Chief Technology Officer"]
[null,null,null,"Agency Management",null,null,null,null,"û"]
[null,null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,null,"",null,"Account Management","Click to add additional rows"]
["Hide this row",1010,"",{"$f":"$E$35","v":"Account Management"},null,null,null,null,"û"]
[null,1011,"Account Management_Department Head_Department Head","Account Management","Department Head","Department Head"]
[null,1012,"Account Management_Senior_Senior Account Director","Account Management","Senior","Senior Account Director"]
[null,1013,"Account Management_Senior_Account Director","Account Management","Senior","Account Director"]
[null,1014,"Account Management_Middle (Upper)_Account Supervisor","Account Management","Middle (Upper)","Account Supervisor"]
[null,1015,"Account Management_Middle (Upper)_Senior Account Manager ","Account Management","Middle (Upper)","Senior Account Manager "]
[null,1016,"Account Management_Middle (Lower)_Account Manager","Account Management","Middle (Lower)","Account Manager"]
[null,1017,"Account Management_Middle (Lower)_Project Manager","Account Management","Middle (Lower)","Project Manager"]
[null,1018,"Account Management_Junior_Account Executive","Account Management","Junior","Account Executive"]
[null,1019,"Account Management_Junior_Account Assistant","Account Management","Junior","Account Assistant"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"",null,"Project Management","Click to add additional rows"]
["Hide this row",1041,"",{"$f":"$E$49","v":"Project Management"},null,null,null,null,"û"]
[null,1042,"Project Management_Department Head_Head of Project Management","Project Management","Department Head","Head of Project Management"]
[null,1043,"Project Management_Senior_Project Director","Project Management","Senior","Project Director"]
[null,1044,"Project Management_Senior_Senior Project Manager","Project Management","Senior","Senior Project Manager"]
[null,1045,"Project Management_Middle (Upper)_Project Manager","Project Management","Middle (Upper)","Project Manager"]
[null,1046,"Project Management_Junior_Project Administrator","Project Management","Junior","Project Administrator"]
[null,1047,"Project Management_Junior_Project Executive","Project Management","Junior","Project Executive"]
[null,1048,"Project Management_Technology - Senior_Digital Project Director","Project Management","Technology - Senior","Digital Project Director"]
[null,1049,"Project Management_Technology - Senior_Senior Social Community Manager","Project Management","Technology - Senior","Senior Social Community Manager"]
[null,1050,"Project Management_Technology - Middle (Upper)_Digital Project Manager","Project Management","Technology - Middle (Upper)","Digital Project Manager"]
[null,1051,"Project Management_Technology - Middle (Upper)_Community Manager ","Project Management","Technology - Middle (Upper)","Community Manager "]
[null,1052,"Project Management_Technology - Middle (Lower)_Digital Project Executive","Project Management","Technology - Middle (Lower)","Digital Project Executive"]
[null,1053,"Project Management_Technology - Middle (Lower)_Social Community Manager","Project Management","Technology - Middle (Lower)","Social Community Manager"]
[null,1054,"Project Management_Technology - Junior_Junior project Manager","Project Management","Technology - Junior","Junior project Manager"]
[null,1055,"Project Management_Technology - Junior_Digital Project Administrator","Project Management","Technology - Junior","Digital Project Administrator"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"",null,"Creative","Click to add additional rows"]
["Hide this row",1060,"",{"$f":"$E$68","v":"Creative"},null,null,null,null,"û"]
[null,1061,"Creative_Senior_Senior Art Director","Creative","Senior","Senior Art Director"]
[null,1062,"Creative_Senior_Senior Writer","Creative","Senior","Senior Writer"]
[null,1063,"Creative_Middle (Upper)_Art Director","Creative","Middle (Upper)","Art Director"]
[null,1064,"Creative_Middle (Upper)_Writer","Creative","Middle (Upper)","Writer"]
[null,1065,"Creative_Middle (Lower)_Graphic Designer","Creative","Middle (Lower)","Graphic Designer"]
[null,1066,"Creative_Middle (Lower)_Artworker","Creative","Middle (Lower)","Artworker"]
[null,1067,"Creative_Junior_Junior Writer","Creative","Junior","Junior Writer"]
[null,1068,"Creative_Junior_Junior Art Director","Creative","Junior","Junior Art Director"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"",null,"Analytics, Planning & Strategy","Click to add additional rows"]
["Hide this row",1073,"",{"$f":"$E$81","v":"Analytics, Planning & Strategy"},null,null,null,null,"û"]
[null,1074,"Analytics, Planning & Strategy_Senior_Strategy Director",{"$f":"$E$81","v":"Analytics, Planning & Strategy"},"Senior","Strategy Director"]
[null,1075,"Analytics, Planning & Strategy_Senior_Senior Planner","Analytics, Planning & Strategy","Senior","Senior Planner"]
[null,1076,"Analytics, Planning & Strategy_Middle (Upper)_Planner","Analytics, Planning & Strategy","Middle (Upper)","Planner"]
[null,1077,"Analytics, Planning & Strategy_Middle (Upper)_Social Strategist","Analytics, Planning & Strategy","Middle (Upper)","Social Strategist"]
[null,1078,"Analytics, Planning & Strategy_Middle (Lower)_Assistant Planner","Analytics, Planning & Strategy","Middle (Lower)","Assistant Planner"]
[null,1079,"Analytics, Planning & Strategy_Middle (Lower)_Assistant Data Analyst","Analytics, Planning & Strategy","Middle (Lower)","Assistant Data Analyst"]
[null,1080,"Analytics, Planning & Strategy_Junior_Junior Planner","Analytics, Planning & Strategy","Junior","Junior Planner"]
[null,1081,"Analytics, Planning & Strategy_Junior_Junior Data Analyst","Analytics, Planning & Strategy","Junior","Junior Data Analyst"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"",null,"Production & Technology","Click to add additional rows"]
["Hide this row",1086,"",{"$f":"$E$94","v":"Production & Technology"},null,null,null,null,"û"]
[null,1087,"Production & Technology_Department Head_Head of Production","Production & Technology","Department Head","Head of Production"]
[null,1088,"Production & Technology_Department Head_Head of Digital","Production & Technology","Department Head","Head of Digital"]
[null,1089,"Production & Technology_Broadcast Production - Senior_Senior Producer","Production & Technology","Broadcast Production - Senior","Senior Producer"]
[null,1090,"Production & Technology_Broadcast Production - Middle (Upper)_Producer","Production & Technology","Broadcast Production - Middle (Upper)","Producer"]
[null,1091,"Production & Technology_Broadcast Production - Middle (Lower)_Production Assistant","Production & Technology","Broadcast Production - Middle (Lower)","Production Assistant"]
[null,1092,"Production & Technology_Print Production - Middle (Upper)_Print Production Manager","Production & Technology","Print Production - Middle (Upper)","Print Production Manager"]
[null,1093,"Production & Technology_Print Production - Middle (Lower)_Print Production Assistant ","Production & Technology","Print Production - Middle (Lower)","Print Production Assistant "]
[null,1094,"Production & Technology_Print Production - Junior_Proofreader","Production & Technology","Print Production - Junior","Proofreader"]
[null,1095,"Production & Technology_Digital Production - Senior_Digital Director","Production & Technology","Digital Production - Senior","Digital Director"]
[null,1096,"Production & Technology_Digital Production - Senior_Senior SEO Executive","Production & Technology","Digital Production - Senior","SEO Director"]
[null,1097,"Production & Technology_Digital Production - Middle (Upper)_Digital Producer","Production & Technology","Digital Production - Middle (Upper)","Digital Producer"]
[null,1098,"Production & Technology_Digital Production - Middle (Upper)_Senior Content Manager","Production & Technology","Digital Production - Middle (Upper)","Senior Content Manager"]
[null,1099,"Production & Technology_Digital Production - Middle (Lower)_Digital Producer","Production & Technology","Digital Production - Middle (Lower)","Digital Producer"]
[null,1100,"Production & Technology_Digital Production - Middle (Lower)_Content Manager","Production & Technology","Digital Production - Middle (Lower)","Content Manager"]
[null,1101,"Production & Technology_Digital Production - Junior_System Administrator","Production & Technology","Digital Production - Junior","System Administrator"]
[null,1102,"Production & Technology_Digital Production - Junior_Support Analyst","Production & Technology","Digital Production - Junior","Support Analyst"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"",null,"Media Buying","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$115","v":"Media Buying"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$115","v":"Media Buying"},null,"hide it",null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"",null,"Other","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$121","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$121","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$121","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$121","v":"Other"},null,null,null,null,"û"]
[]
[]
[null,null,null,null,"END"]
[null,6666661,null,null,"Averaged Hourly Rate",null,{"$f":"IF(COUNT(G28:G32,G37:G45,G51:G64,G70:G77,G83:G90,G96:G111)<>60,\"Not all essential rates are completed\",AVERAGE(G28:G32,G37:G45,G51:G64,G70:G77,G83:G90,G96:G111))","v":"Not all essential rates are completed"}]
[null,6666662]

{"sheet":"PR","index":9,"n_rows":107,"n_cols":9,"rows_kept":107,"cut":false,"hidden":false,"merged":[[1,4,1,6],[3,4,3,5],[8,4,8,5]]}
[null,"Hide this column","Hide this column","Hide this column"]
[null,null,null,null,"Agency Fee Template - PR"]
[]
[]
[null,null,null,null,"Client name","CCS"]
[null,null,null,null,"Client brand","Lot 1 - End to End Campaign Management"]
[null,null,null,null,"Currency of rates","British Pound - GBP"]
[]
[null,null,null,null,"Agency to complete"]
[null,null,null,null,"Agency name"]
[null,null,null,null,"Contact name"]
[null,null,null,null,"Job title"]
[null,null,null,null,"Email address"]
[null,null,null,null,"Date"]
[null,null,null,null,"Country"]
[null,null,null,null,"City"]
[null,null,null,null,"Number of employees"]
[null,null,null,null,"Number of billable hours in a working year"]
[null,null,null,null,"Ownership"]
[null,null,null,null,"Ownership where \"Other Group\""]
[null,null,null,null,"Overhead (% of base)"]
[null,null,null,null,"Profit margin (%)"]
[]
[null,null,null,null,"Role (click to select closest match)","Actual job title",{"$f":"\"Hourly rate (Gross, \" & IF(F7=\"\",\"TBC\",RIGHT(F7,3)) & \")\"","v":"Hourly rate (Gross, GBP)"}]
[]
[null,null,null,null,"Agency Management","Click to add additional rows"]
["Hide this row",null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,1001,"Agency Management_CEO_\nChief Executive Officer\n",{"$f":"$E$26","v":"Agency Management"},"CEO","\nChief Executive Officer\n"]
[null,1002,"Agency Management_Managing Director_Managing Director","Agency Management","Managing Director","Managing Director"]
[null,null,null,"Agency Management",null,null,null,null,"û"]
[null,null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,null,"",null,"Account Management","Click to add additional rows"]
["Hide this row",1010,"",{"$f":"$E$32","v":"Account Management"},null,null,null,null,"û"]
[null,1011,"Account Management_Department Head_Department Head","Account Management","Department Head","Buisness Director"]
[null,1012,"Account Management_Senior_Senior Account Director","Account Management","Senior","Senior Account Director"]
[null,1013,"Account Management_Senior_Account Director","Account Management","Senior","Account Director"]
[null,1014,"Account Management_Middle (Upper)_Account Supervisor","Account Management","Middle (Upper)","Account Supervisor"]
[null,1015,"Account Management_Middle (Upper)_Senior Account Manager ","Account Management","Middle (Upper)","Senior Account Manager "]
[null,1016,"Account Management_Middle (Lower)_Account Manager","Account Management","Middle (Lower)","Account Manager"]
[null,1017,"Account Management_Middle (Lower)_Project Manager","Account Management","Middle (Lower)","Project Manager"]
[null,1018,"Account Management_Junior_Account Executive","Account Management","Junior","Account Executive"]
[null,1019,"Account Management_Junior_Account Assistant","Account Management","Junior","Account Assistant"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"",null,"Project Management","Click to add additional rows"]
["Hide this row",1041,"",{"$f":"$E$46","v":"Project Management"},null,null,null,null,"û"]
[null,1042,"Project Management_Department Head_Head of Project Management","Project Management","Department Head","Head of Project Management"]
[null,1043,"Project Management_Senior_Project Director","Project Management","Senior","Project Director"]
[null,1044,"Project Management_Senior_Senior Project Manager","Project Management","Senior","Senior Project Manager"]
[null,1045,"Project Management_Middle (Upper)_Project Manager","Project Management","Middle (Upper)","Project Manager"]
[null,1046,"Project Management_Junior_Project Administrator","Project Management","Junior","Project Administrator"]
[null,1047,"Project Management_Junior_Project Executive","Project Management","Junior","Project Executive"]
[null,1048,"Project Management_Technology - Senior_Digital Project Director","Project Management","Technology - Senior","Digital Project Director"]
[null,1049,"Project Management_Technology - Senior_Senior Social Community Manager","Project Management","Technology - Senior","Senior Social Community Manager"]
[null,1050,"Project Management_Technology - Middle (Upper)_Digital Project Manager","Project Management","Technology - Middle (Upper)","Digital Project Manager"]
[null,1051,"Project Management_Technology - Middle (Upper)_Community Manager ","Project Management","Technology - Middle (Upper)","Community Manager "]
[null,1052,"Project Management_Technology - Middle (Lower)_Digital Project Executive","Project Management","Technology - Middle (Lower)","Digital Project Executive"]
[null,1053,"Project Management_Technology - Middle (Lower)_Social Community Manager","Project Management","Technology - Middle (Lower)","Social Community Manager"]
[null,1054,"Project Management_Technology - Junior_Junior project Manager","Project Management","Technology - Junior","Junior project Manager"]
[null,1055,"Project Management_Technology - Junior_Digital Project Administrator","Project Management","Technology - Junior","Digital Project Administrator"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"",null,"Creative","Click to add additional rows"]
["Hide this row",1060,"",{"$f":"$E$65","v":"Creative"},null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"",null,"Analytics, Planning & Strategy","Click to add additional rows"]
["Hide this row",1073,"",{"$f":"$E$70","v":"Analytics, Planning & Strategy"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$70","v":"Analytics, Planning & Strategy"},null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"",null,"Production & Technology","Click to add additional rows"]
["Hide this row",1086,"",{"$f":"$E$75","v":"Production & Technology"},null,null,null,null,"û"]
[null,1088,"Production & Technology_Department Head_Head of Digital","Production & Technology","Department Head","Head of Digital"]
[null,1089,"Production & Technology_Broadcast Production - Senior_Senior Producer","Production & Technology","Broadcast Production - Senior","Senior Producer"]
[null,1090,"Production & Technology_Broadcast Production - Middle (Upper)_Producer","Production & Technology","Broadcast Production - Middle (Upper)","Producer"]
[null,1091,"Production & Technology_Broadcast Production - Middle (Lower)_Production Assistant","Production & Technology","Broadcast Production - Middle (Lower)","Production Assistant"]
[null,1095,"Production & Technology_Digital Production - Senior_Digital Director","Production & Technology","Digital Production - Senior","Digital Director"]
[null,1096,"Production & Technology_Digital Production - Senior_Senior SEO Executive","Production & Technology","Digital Production - Senior","SEO Director"]
[null,1097,"Production & Technology_Digital Production - Middle (Upper)_Digital Producer","Production & Technology","Digital Production - Middle (Upper)","Digital Producer"]
[null,1098,"Production & Technology_Digital Production - Middle (Upper)_Senior Content Manager","Production & Technology","Digital Production - Middle (Upper)","Senior Content Manager"]
[null,1099,"Production & Technology_Digital Production - Middle (Lower)_Digital Producer","Production & Technology","Digital Production - Middle (Lower)","Digital Producer"]
[null,1100,"Production & Technology_Digital Production - Middle (Lower)_Content Manager","Production & Technology","Digital Production - Middle (Lower)","Content Manager"]
[null,1101,"Production & Technology_Digital Production - Junior_System Administrator","Production & Technology","Digital Production - Junior","System Administrator"]
[null,1102,"Production & Technology_Digital Production - Junior_Support Analyst","Production & Technology","Digital Production - Junior","Support Analyst"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"",null,"Media Buying","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$92","v":"Media Buying"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$92","v":"Media Buying"},null,"hide it",null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"",null,"Other","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$98","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$98","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$98","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$98","v":"Other"},null,null,null,null,"û"]
[]
[]
[null,null,null,null,"END"]
[null,6666661,null,null,"Averaged Hourly Rate",null,{"$f":"IF(COUNT(G28:G29,G34:G42,G48:G61,G77:G88)<>37,\"Not all essential rates are completed\",AVERAGE(G28:G29,G34:G42,G48:G61,G77:G88))","v":"Not all essential rates are completed"}]
[null,6666662]

{"sheet":"Design","index":10,"n_rows":116,"n_cols":9,"rows_kept":116,"cut":false,"hidden":false,"merged":[[1,4,1,6],[3,4,3,5],[8,4,8,5]]}
[null,"Hide this column","Hide this column","Hide this column"]
[null,null,null,null,"Agency Fee Template - Design"]
[]
[]
[null,null,null,null,"Client name","CCS"]
[null,null,null,null,"Client brand","Lot 1 - End to End Campaign Management"]
[null,null,null,null,"Currency of rates","British Pound - GBP"]
[]
[null,null,null,null,"Agency to complete"]
[null,null,null,null,"Agency name"]
[null,null,null,null,"Contact name"]
[null,null,null,null,"Job title"]
[null,null,null,null,"Email address"]
[null,null,null,null,"Date"]
[null,null,null,null,"Country"]
[null,null,null,null,"City"]
[null,null,null,null,"Number of employees"]
[null,null,null,null,"Number of billable hours in a working year"]
[null,null,null,null,"Ownership"]
[null,null,null,null,"Ownership where \"Other Group\""]
[null,null,null,null,"Overhead (% of base)"]
[null,null,null,null,"Profit margin (%)"]
[]
[null,null,null,null,"Role (click to select closest match)","Actual job title",{"$f":"\"Hourly rate (Gross, \" & IF(F7=\"\",\"TBC\",RIGHT(F7,3)) & \")\"","v":"Hourly rate (Gross, GBP)"}]
[]
[null,null,null,null,"Agency Management","Click to add additional rows"]
["Hide this row",null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,1001,"Agency Management_CEO_\nChief Executive Officer\n",{"$f":"$E$26","v":"Agency Management"},"CEO","\nChief Executive Officer\n"]
[null,1002,"Agency Management_Managing Director_Managing Director","Agency Management","Managing Director","Managing Director"]
[null,1003,"Agency Management_Other (e.g. Partner, COO, etc.)_Executive Creative Director","Agency Management","Other (e.g. Partner, COO, etc.)","Executive Creative Director"]
[null,1004,"Agency Management_Other (e.g. Partner, COO, etc.)_Chief Strategy Officer","Agency Management","Other (e.g. Partner, COO, etc.)","Chief Strategy Officer"]
[null,1005,"Agency Management_Other (e.g. Partner, COO, etc.)_Chief Technology Officer","Agency Management","Other (e.g. Partner, COO, etc.)","Chief Technology Officer"]
[null,null,null,"Agency Management",null,null,null,null,"û"]
[null,null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,null,"",null,"Account Management","Click to add additional rows"]
["Hide this row",1010,"",{"$f":"$E$35","v":"Account Management"},null,null,null,null,"û"]
[null,1011,"Account Management_Department Head_Department Head","Account Management","Department Head","Business Director/Client Partner"]
[null,1012,"Account Management_Senior_Senior Account Director","Account Management","Senior","Senior Account Director"]
[null,1013,"Account Management_Senior_Account Director","Account Management","Senior","Account Director"]
[null,1014,"Account Management_Middle (Upper)_Account Supervisor","Account Management","Middle (Upper)","Account Supervisor"]
[null,1015,"Account Management_Middle (Upper)_Senior Account Manager ","Account Management","Middle (Upper)","Senior Account Manager "]
[null,1016,"Account Management_Middle (Lower)_Account Manager","Account Management","Middle (Lower)","Account Manager"]
[null,1017,"Account Management_Middle (Lower)_Project Manager","Account Management","Middle (Lower)","Project Manager"]
[null,1018,"Account Management_Junior_Account Executive","Account Management","Junior","Account Executive"]
[null,1019,"Account Management_Junior_Account Assistant","Account Management","Junior","Account Assistant"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"",null,"Project Management","Click to add additional rows"]
["Hide this row",1041,"",{"$f":"$E$49","v":"Project Management"},null,null,null,null,"û"]
[null,1042,"Project Management_Department Head_Head of Project Management","Project Management","Department Head","Head of Project Management"]
[null,1043,"Project Management_Senior_Project Director","Project Management","Senior","Project Director"]
[null,1044,"Project Management_Senior_Senior Project Manager","Project Management","Senior","Senior Project Manager"]
[null,1045,"Project Management_Middle (Upper)_Project Manager","Project Management","Middle (Upper)","Project Manager"]
[null,1046,"Project Management_Junior_Project Administrator","Project Management","Junior","Project Administrator"]
[null,1047,"Project Management_Junior_Project Executive","Project Management","Junior","Project Executive"]
[null,1048,"Project Management_Technology - Senior_Digital Project Director","Project Management","Technology - Senior","Digital Project Director"]
[null,1050,"Project Management_Technology - Middle (Upper)_Digital Project Manager","Project Management","Digital Production - Senior","Digital Director"]
[null,1052,"Project Management_Technology - Middle (Lower)_Digital Project Executive","Project Management","Digital Production - Middle (Upper)","Digital Producer"]
[null,1054,"Project Management_Technology - Junior_Junior project Manager","Project Management","Digital Production - Middle (Lower)","Digital Producer"]
[null,1055,"Project Management_Technology - Junior_Junior System administrator","Project Management","Digital Production - Junior","System Administrator",null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"",null,"Creative","Click to add additional rows"]
["Hide this row",1060,"",{"$f":"$E$64","v":"Creative"},null,null,null,null,"û"]
[null,1061,"Creative_Senior_Senior Art Director","Creative","Senior","Senior Designer"]
[null,1062,"Creative_Senior_Senior Writer","Creative","Senior","Senior Writer"]
[null,1063,"Creative_Middle (Upper)_Art Director","Creative","Middle (Upper)","Designer"]
[null,1064,"Creative_Middle (Upper)_Writer","Creative","Middle (Upper)","Writer"]
[null,1065,"Creative_Middle (Lower)_Graphic Designer","Creative","Middle (Lower)","Graphic Designer"]
[null,1066,"Creative_Middle (Lower)_Artworker","Creative","Middle (Lower)","Artworker"]
[null,1067,"Creative_Junior_Junior Writer","Creative","Junior","Junior Writer"]
[null,1068,"Creative_Junior_Junior Art Director","Creative","Junior","Junior Art Director"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"",null,"Analytics, Planning & Strategy","Click to add additional rows"]
["Hide this row",1073,"",{"$f":"$E$77","v":"Analytics, Planning & Strategy"},null,null,null,null,"û"]
[null,1074,"Analytics, Planning & Strategy_Senior_Strategy Director","Analytics, Planning & Strategy","Senior","Strategy Director"]
[null,1075,"Analytics, Planning & Strategy_Senior_Senior Planner","Analytics, Planning & Strategy","Senior","Senior Planner"]
[null,1076,"Analytics, Planning & Strategy_Middle (Upper)_Planner","Analytics, Planning & Strategy","Middle (Upper)","Planner"]
[null,1078,"Analytics, Planning & Strategy_Middle (Lower)_Assistant Planner","Analytics, Planning & Strategy","Middle (Lower)","Assistant Planner"]
[null,1080,"Analytics, Planning & Strategy_Junior_Junior Planner","Analytics, Planning & Strategy","Junior","Junior Planner"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"",null,"Production & Technology","Click to add additional rows"]
["Hide this row",1086,"",{"$f":"$E$87","v":"Production & Technology"},null,null,null,null,"û"]
[null,1087,"Production & Technology_Department Head_Head of Production","Production & Technology","Department Head","Head of Production"]
[null,1088,"Production & Technology_Department Head_Head of Digital","Production & Technology","Department Head","Head of Digital"]
[null,1092,"Production & Technology_Print Production - Middle (Upper)_Print Production Manager","Production & Technology","Print Production - Middle (Upper)","Print Production Manager"]
[null,1093,"Production & Technology_Print Production - Middle (Lower)_Print Production Assistant ","Production & Technology","Print Production - Middle (Lower)","Print Production Assistant "]
[null,1094,"Production & Technology_Print Production - Junior_Proofreader","Production & Technology","Print Production - Junior","Proofreader"]
[null,1095,"Production & Technology_Digital Production - Senior_Digital Director","Production & Technology","Digital Production - Senior","Digital Director"]
[null,1097,"Production & Technology_Digital Production - Middle (Upper)_Digital Producer","Production & Technology","Digital Production - Middle (Upper)","Digital Producer"]
[null,1099,"Production & Technology_Digital Production - Middle (Lower)_Digital Producer","Production & Technology","Digital Production - Middle (Lower)","Digital Producer"]
[null,1101,"Production & Technology_Digital Production - Junior_System Administrator","Production & Technology","Digital Production - Junior","System Administrator"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"",null,"Media Buying","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$101","v":"Media Buying"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$101","v":"Media Buying"},null,"hide it",null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"",null,"Other","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$107","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$107","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$107","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$107","v":"Other"},null,null,null,null,"û"]
[]
[]
[null,null,null,null,"END"]
[null,6666661,null,null,"Averaged Hourly Rate",null,{"$f":"IF(COUNT(G28:G32,G37:G45,G51:G61,G66:G73,G79:G83,G89:G97)<>47,\"Not all essential rates are completed\",AVERAGE(G28:G32,G37:G45,G51:G61,G66:G73,G79:G83,G89:G97))","v":"Not all essential rates are completed"}]
[null,6666662]

{"sheet":"Partnership","index":11,"n_rows":130,"n_cols":9,"rows_kept":130,"cut":false,"hidden":false,"merged":[[1,4,1,6],[3,4,3,5],[8,4,8,5]]}
[null,"Hide this column","Hide this column","Hide this column"]
[null,null,null,null,"Agency Fee Template - Partnership Marketing"]
[]
[]
[null,null,null,null,"Client name","CCS"]
[null,null,null,null,"Client brand","Lot 1 - End to End Campaign Management"]
[null,null,null,null,"Currency of rates","British Pound - GBP"]
[]
[null,null,null,null,"Agency to complete"]
[null,null,null,null,"Agency name"]
[null,null,null,null,"Contact name"]
[null,null,null,null,"Job title"]
[null,null,null,null,"Email address"]
[null,null,null,null,"Date"]
[null,null,null,null,"Country"]
[null,null,null,null,"City"]
[null,null,null,null,"Number of employees"]
[null,null,null,null,"Number of billable hours in a working year"]
[null,null,null,null,"Ownership"]
[null,null,null,null,"Ownership where \"Other Group\""]
[null,null,null,null,"Overhead (% of base)"]
[null,null,null,null,"Profit margin (%)"]
[]
[null,null,null,null,"Role (click to select closest match)","Actual job title",{"$f":"\"Hourly rate (Gross, \" & IF(F7=\"\",\"TBC\",RIGHT(F7,3)) & \")\"","v":"Hourly rate (Gross, GBP)"}]
[]
[null,null,null,null,"Agency Management","Click to add additional rows"]
["Hide this row",null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,1001,"Agency Management_CEO_\nChief Executive Officer\n",{"$f":"$E$26","v":"Agency Management"},"CEO","\nChief Executive Officer\n"]
[null,1002,"Agency Management_Managing Director_Managing Director","Agency Management","Managing Director","Managing Director"]
[null,1003,"Agency Management_Other (e.g. Partner, COO, etc.)_Executive Creative Director","Agency Management","Other (e.g. Partner, COO, etc.)","Executive Creative Director"]
[null,1004,"Agency Management_Other (e.g. Partner, COO, etc.)_Chief Strategy Officer","Agency Management","Other (e.g. Partner, COO, etc.)","Chief Strategy Officer"]
[null,1005,"Agency Management_Other (e.g. Partner, COO, etc.)_Chief Technology Officer","Agency Management","Other (e.g. Partner, COO, etc.)","Chief Technology Officer"]
[null,null,null,"Agency Management",null,null,null,null,"û"]
[null,null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,null,"",null,"Account Management","Click to add additional rows"]
["Hide this row",1010,"",{"$f":"$E$35","v":"Account Management"},null,null,null,null,"û"]
[null,1011,"Account Management_Department Head_Department Head","Account Management","Department Head","Business Director/Client Partner"]
[null,1012,"Account Management_Senior_Senior Account Director","Account Management","Senior","Senior Account Director"]
[null,1013,"Account Management_Senior_Account Director","Account Management","Senior","Account Director"]
[null,1014,"Account Management_Middle (Upper)_Account Supervisor","Account Management","Middle (Upper)","Account Supervisor"]
[null,1015,"Account Management_Middle (Upper)_Senior Account Manager ","Account Management","Middle (Upper)","Senior Account Manager "]
[null,1016,"Account Management_Middle (Lower)_Account Manager","Account Management","Middle (Lower)","Account Manager"]
[null,1017,"Account Management_Middle (Lower)_Project Manager","Account Management","Middle (Lower)","Project Manager"]
[null,1018,"Account Management_Junior_Account Executive","Account Management","Junior","Account Executive"]
[null,1019,"Account Management_Junior_Account Assistant","Account Management","Junior","Account Assistant"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"","Account Management",null,null,null,null,"û"]
[null,null,"",null,"Project Management","Click to add additional rows"]
["Hide this row",1041,"",{"$f":"$E$49","v":"Project Management"},null,null,null,null,"û"]
[null,1042,"Project Management_Department Head_Head of Project Management","Project Management","Department Head","Head of Project Management"]
[null,1043,"Project Management_Senior_Project Director","Project Management","Senior","Project Director"]
[null,1044,"Project Management_Senior_Senior Project Manager","Project Management","Senior","Senior Project Manager"]
[null,1045,"Project Management_Middle (Upper)_Project Manager","Project Management","Middle (Upper)","Project Manager"]
[null,1046,"Project Management_Junior_Project Administrator","Project Management","Junior","Project Administrator"]
[null,1047,"Project Management_Junior_Project Executive","Project Management","Junior","Project Executive"]
[null,1048,"Project Management_Technology - Senior_Digital Project Director","Project Management","Technology - Senior","Digital Project Director"]
[null,1049,"Project Management_Technology - Senior_Senior Social Community Manager","Project Management","Technology - Senior","Senior UX Developer"]
[null,1050,"Project Management_Technology - Middle (Upper)_Digital Project Manager","Project Management","Technology - Middle (Upper)","Digital Project Manager"]
[null,1051,"Project Management_Technology - Middle (Upper)_Community Manager ","Project Management","Technology - Middle (Upper)","Information Architect"]
[null,1052,"Project Management_Technology - Middle (Lower)_Digital Project Executive","Project Management","Technology - Middle (Lower)","Digital Project Executive"]
[null,1053,"Project Management_Technology - Middle (Lower)_Social Community Manager","Project Management","Technology - Middle (Lower)","Social Community Manager"]
[null,1054,"Project Management_Technology - Junior_Junior project Manager","Project Management","Technology - Junior","Junior project Manager"]
[null,1055,"Project Management_Technology - Junior_Digital Project Administrator","Project Management","Technology - Junior","Digital Project Administrator"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"",null,"Creative","Click to add additional rows"]
["Hide this row",1060,"",{"$f":"$E$68","v":"Creative"},null,null,null,null,"û"]
[null,1061,"Creative_Senior_Senior Art Director","Creative","Senior","Senior Art Director"]
[null,1062,"Creative_Senior_Senior Writer","Creative","Senior","Senior Writer"]
[null,1063,"Creative_Middle (Upper)_Art Director","Creative","Middle (Upper)","Art Director"]
[null,1064,"Creative_Middle (Upper)_Writer","Creative","Middle (Upper)","Writer"]
[null,1065,"Creative_Middle (Lower)_Graphic Designer","Creative","Middle (Lower)","Graphic Designer"]
[null,1066,"Creative_Middle (Lower)_Artworker","Creative","Middle (Lower)","Artworker"]
[null,1067,"Creative_Junior_Junior Writer","Creative","Junior","Junior Writer"]
[null,1068,"Creative_Junior_Junior Art Director","Creative","Junior","Junior Art Director"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"","Creative",null,null,null,null,"û"]
[null,null,"",null,"Analytics, Planning & Strategy","Click to add additional rows"]
["Hide this row",1073,"",{"$f":"$E$81","v":"Analytics, Planning & Strategy"},null,null,null,null,"û"]
[null,1074,"Analytics, Planning & Strategy_Senior_Strategy Director",{"$f":"$E$81","v":"Analytics, Planning & Strategy"},"Senior","Strategy Director"]
[null,1075,"Analytics, Planning & Strategy_Senior_Senior Planner","Analytics, Planning & Strategy","Senior","Senior Planner"]
[null,1076,"Analytics, Planning & Strategy_Middle (Upper)_Planner","Analytics, Planning & Strategy","Middle (Upper)","Planner"]
[null,1077,"Analytics, Planning & Strategy_Middle (Upper)_Social Strategist","Analytics, Planning & Strategy","Middle (Upper)","Social Strategist"]
[null,1078,"Analytics, Planning & Strategy_Middle (Lower)_Assistant Planner","Analytics, Planning & Strategy","Middle (Lower)","Assistant Planner"]
[null,1079,"Analytics, Planning & Strategy_Middle (Lower)_Assistant Data Analyst","Analytics, Planning & Strategy","Middle (Lower)","Assistant Data Analyst"]
[null,1080,"Analytics, Planning & Strategy_Junior_Junior Planner","Analytics, Planning & Strategy","Junior","Junior Planner"]
[null,1081,"Analytics, Planning & Strategy_Junior_Junior Data Analyst","Analytics, Planning & Strategy","Junior","Junior Data Analyst"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"","Analytics, Planning & Strategy",null,null,null,null,"û"]
[null,null,"",null,"Production & Technology","Click to add additional rows"]
["Hide this row",1086,"",{"$f":"$E$94","v":"Production & Technology"},null,null,null,null,"û"]
[null,1087,"Production & Technology_Department Head_Head of Production","Production & Technology","Department Head","Head of Production"]
[null,1088,"Production & Technology_Department Head_Head of Digital","Production & Technology","Department Head","Head of Digital"]
[null,1089,"Production & Technology_Broadcast Production - Senior_Senior Producer","Production & Technology","Broadcast Production - Senior","Senior Producer"]
[null,1090,"Production & Technology_Broadcast Production - Middle (Upper)_Producer","Production & Technology","Broadcast Production - Middle (Upper)","Producer"]
[null,1091,"Production & Technology_Broadcast Production - Middle (Lower)_Production Assistant","Production & Technology","Broadcast Production - Middle (Lower)","Production Assistant"]
[null,1092,"Production & Technology_Print Production - Middle (Upper)_Print Production Manager","Production & Technology","Print Production - Middle (Upper)","Print Production Manager"]
[null,1093,"Production & Technology_Print Production - Middle (Lower)_Print Production Assistant ","Production & Technology","Print Production - Middle (Lower)","Print Production Assistant "]
[null,1094,"Production & Technology_Print Production - Junior_Proofreader","Production & Technology","Print Production - Junior","Proofreader"]
[null,1095,"Production & Technology_Digital Production - Senior_Digital Director","Production & Technology","Digital Production - Senior","Digital Director"]
[null,1096,"Production & Technology_Digital Production - Senior_Senior SEO Executive","Production & Technology","Digital Production - Senior","Senior SEO Executive"]
[null,1097,"Production & Technology_Digital Production - Middle (Upper)_Digital Producer","Production & Technology","Digital Production - Middle (Upper)","Digital Producer"]
[null,1098,"Production & Technology_Digital Production - Middle (Upper)_Senior Content Manager","Production & Technology","Digital Production - Middle (Upper)","Senior Content Manager"]
[null,1099,"Production & Technology_Digital Production - Middle (Lower)_Digital Producer","Production & Technology","Digital Production - Middle (Lower)","Digital Producer"]
[null,1100,"Production & Technology_Digital Production - Middle (Lower)_Content Manager","Production & Technology","Digital Production - Middle (Lower)","Content Manager"]
[null,1101,"Production & Technology_Digital Production - Junior_System Administrator","Production & Technology","Digital Production - Junior","System Administrator"]
[null,1102,"Production & Technology_Digital Production - Junior_Support Analyst","Production & Technology","Digital Production - Junior","Support Analyst"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"","Production & Technology",null,null,null,null,"û"]
[null,null,"",null,"Media Buying","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$115","v":"Media Buying"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$115","v":"Media Buying"},null,"hide it",null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"","Media Buying",null,null,null,null,"û"]
[null,null,"",null,"Other","Click to add additional rows"]
["Hide this row",null,"",{"$f":"$E$121","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$121","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$121","v":"Other"},null,null,null,null,"û"]
[null,null,"",{"$f":"$E$121","v":"Other"},null,null,null,null,"û"]
[]
[]
[null,null,null,null,"END"]
[null,6666661,null,null,"Averaged Hourly Rate",null,{"$f":"IF(COUNT(G28:G32,G37:G45,G51:G64,G70:G77,G83:G90,G96:G111)<>60,\"-\",AVERAGE(G28:G32,G37:G45,G51:G64,G70:G77,G83:G90,G96:G111))","v":"-"}]
[null,6666662]

{"sheet":"Events-Experiential","index":12,"n_rows":92,"n_cols":9,"rows_kept":92,"cut":false,"hidden":false,"merged":[[1,4,1,6],[3,4,3,5],[8,4,8,5]]}
[null,"Hide this column","Hide this column","Hide this column"]
[null,null,null,null,"Agency Fee Template - Events & Experiential"]
[]
[]
[null,null,null,null,"Client name","CCS"]
[null,null,null,null,"Client brand","Lot 1 - End to End Campaign Management"]
[null,null,null,null,"Currency of rates","British Pound - GBP"]
[]
[null,null,null,null,"Agency to complete"]
[null,null,null,null,"Agency name"]
[null,null,null,null,"Contact name"]
[null,null,null,null,"Job title"]
[null,null,null,null,"Email address"]
[null,null,null,null,"Date"]
[null,null,null,null,"Country"]
[null,null,null,null,"City"]
[null,null,null,null,"Number of employees"]
[null,null,null,null,"Number of billable hours in a working year"]
[null,null,null,null,"Ownership"]
[null,null,null,null,"Ownership where \"Other Group\""]
[null,null,null,null,"Overhead (% of base)"]
[null,null,null,null,"Profit margin (%)"]
[]
[null,null,null,null,"Role (click to select closest match)","Actual job title",{"$f":"\"Hourly rate (Gross, \" & IF(F7=\"\",\"TBC\",RIGHT(F7,3)) & \")\"","v":"Hourly rate (Gross, GBP)"}]
[]
[null,null,null,null,"Agency Management"]
["Hide this row",null,null,{"$f":"$E$26","v":"Agency Management"},null,null,null,null,"û"]
[null,1002,"Agency Management_Managing Director_Managing Director",{"$f":"$E$26","v":"Agency Management"},"Managing Director","Managing Director"]
[null,1003,"Agency Management_Other (e.g. Partner, COO, etc.)_Executive Creative Director","Agency Management","Other (e.g. Partner, COO, etc.)","Executive Creative Director"]
[null,null,"",null,"Account Management"]
["Hide this row",1010,"",{"$f":"$E$30","v":"Account Management"},null,null,null,null,"û"]
[null,1011,"Account Management_Department Head_Department Head","Account Management","Department Head","Group Account Director"]
[null,1012,"Account Management_Senior_Senior Account Director","Account Management","Senior","Senior Account Director"]
[null,1013,"Account Management_Senior_Account Director","Account Management","Senior","Lead Account Director"]
[null,1016,"Account Management_Middle (Lower)_Account Manager","Account Management","Middle (Lower)","Account Manager"]
[null,1017,"Account Management_Middle (Lower)_Project Manager","Account Management","Middle (Lower)","Account Co-ordinator"]
[null,1018,"Account Management_Junior_Account Executive","Account Management","Junior","Junior Account Manager"]
[null,1019,"Account Management_Junior_Account Assistant","Account Management","Junior","Senior Account Executive"]
[null,null,"",null,"Project Management","Click to add additional rows"]
["Hide this row",1041,"",{"$f":"$E$39","v":"Project Management"},null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"","Project Management",null,null,null,null,"û"]
[null,null,"",null,"Creative"]
["Hide this row",1060,"",{"$f":"$E$44","v":"Creative"},null,null,null,null,"û"]
[null,1061,"Creative_Senior_Senior Art Director","Creative","Senior","Creative Director"]
[null,1063,"Creative_Middle (Upper)_Art Director","Creative","Middle (Upper)","Senior 3D Designer"]
[null,1064,"Creative_Middle (Upper)_Writer","Creative","Middle (Upper)","Set Designer"]
[null,1065,"Creative_Middle (Lower)_Graphic Designer","Creative","Middle (Lower)","3D Designer"]
[null,1066,"Creative_Middle (Lower)_Artworker","Creative","Middle (Lower)","Artworker"]
[null,1067,"Creative_Junior_Junior Writer","Creative","Junior","Junior 3D designer"]
[null,1068,"",null,"Analytics, Planning & Strategy","Click to add additional rows"]
["Hide this row",1069,"",{"$f":"$E$52","v":"Analytics, Planning & Strategy"},null,null,null,null,"û"]
[null,1070,"",{"$f":"$E$52","v":"Analytics, Planning & Strategy"},null,null,null,null,"û"]
[null,1071,"",{"$f":"$E$52","v":"Analytics, Planning & Strategy"},null,null,null,null,"û"]
[null,1072,"",{"$f":"$E$52","v":"Analytics, Planning & Strategy"},null,null,null,null,"û"]
[null,1073,"",null,"Production & Technology","Click to add additional rows"]
["Hide this row",1074,"",{"$f":"$E$57","v":"Production & Technology"},null,null,null,null,"û"]
[null,1075,"",{"$f":"$E$57","v":"Production & Technology"},null,null,null,null,"û"]
[null,1076,"",{"$f":"$E$57","v":"Production & Technology"},null,null,null,null,"û"]
[null,1077,"",{"$f":"$E$57","v":"Production & Technology"},null,null,null,null,"û"]
[null,null,null,null,"Producers"]
["Hide this row",null,null,{"$f":"$E$62","v":"Producers"},null,null,null,null,"û"]
["Hide this row",null,null,"Producers",null,"hide it",null,null,"û"]
[null,1081,{"$f":"_xlfn.CONCAT(D65,\"_\",E65,\"_\",F65)","v":"Producers_Department Head_Senior Executive Producer"},"Producers","Department Head","Senior Executive Producer"]
[null,1082,{"$f":"_xlfn.CONCAT(D66,\"_\",E66,\"_\",F66)","v":"Producers_Senior_Senior Content Producer"},"Producers","Senior","Senior Content Producer"]
[null,1083,"Producers_Middle (Upper)_Senior Producer","Producers","Middle (Upper)","Senior Producer"]
[null,1084,"Producers_Middle (Upper)_Producer","Producers","Middle (Upper)","Producer"]
[null,1085,"Producers_Middle (Upper)_Content Producer","Producers","Middle (Upper)","Content Producer"]
[null,1086,"Producers_Middle (Lower)_Junior Producer","Producers","Middle (Lower)","Junior Producer"]
[null,null,null,null,"Technical Production"]
["Hide this row",null,null,{"$f":"$E$71","v":"Technical Production"},null,null,null,null,"û"]
[null,1089,{"$f":"_xlfn.CONCAT(D73,\"_\",E73,\"_\",F73)","v":"Technical Production_Department Head_Production Director"},"Technical Production","Department Head","Production Director"]
[null,1090,"Technical Production_Senior_Technical Director","Technical Production","Senior","Technical Director"]
[null,1091,"Technical Production_Senior_Senior Production Manager","Technical Production","Senior","Senior Production Manager"]
[null,1092,"Technical Production_Middle (Upper)_Production Manager","Technical Production","Middle (Upper)","Production Manager"]
[null,1093,"Technical Production_Middle (Upper)_Technical Manager","Technical Production","Middle (Upper)","Technical Manager"]
[null,1094,"Technical Production_Middle (Lower)_Production Project Manager","Technical Production","Middle (Lower)","Production Project Manager"]
[null,1095,"Technical Production_Middle (Lower)_Warehouse Manager","Technical Production","Middle (Lower)","Warehouse Manager"]
[]
[]
[null,null,null,null,"END"]
[null,6666661,null,null,"Averaged Hourly Rate",null,{"$f":"IF(COUNT(G73:G79,G65:G70,G46:G51,G32:G38,G28:G29)<>28,\"-\",AVERAGE(G73:G79,G65:G70,G46:G51,G32:G38,G28:G29))","v":"-"}]
[]
[null,6666662]
["Creative"]
["Content"]
["Digital & Social"]
["Direct Marketing"]
["PR",null,null,null,37]
["Design",null,null,null,47]
["Partnership",null,null,null,60]