{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Cover","Control","Notices","Conventions","Instructions","Information","Home","Version_Control","Assessment","Shared_Advocacy","Shared_Services","Shared_Delivery","Auspicing","Mentoring","Co_Location","Shared_Development","Shared_Distribution","Shared_Marketing","Endorsement","Joint_Venture","Licensing"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":34,"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":"Cover","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"client","v":"National Disability Services WA"}]
[null,{"$f":"title","v":"Collaboration Options Analysis Tool"}]

{"sheet":"Control","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[{"$f":"client","v":"National Disability Services WA"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"\"Version \"&TEXT(version,\"0.0\")&\" (\"&+creation_date&\")\"","v":"Version 1.0 (September 2017)"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A6),LEN(CELL(\"filename\",A6))-FIND(\"]\",CELL(\"filename\",A6)))","v":"Control"}]
[]
[]
[]
[null,"Title","Collaboration Options Analysis Tool"]
[]
[null,"Client","National Disability Services WA"]
[]
[null,"Author","Baxter Lawley Pty Ltd (ABN 98 165 346 369)"]
[]
[null,"Version",1]
[]
[null,"Creation date","September 2017"]
[]
[null,"Purpose","To support quantitative analysis of different types of collaboration"]
[]
[null,"Instructions"]

{"sheet":"Notices","index":2,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[{"$f":"client","v":"National Disability Services WA"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"\"Version \"&TEXT(version,\"0.0\")&\" (\"&+creation_date&\")\"","v":"Version 1.0 (September 2017)"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A6),LEN(CELL(\"filename\",A6))-FIND(\"]\",CELL(\"filename\",A6)))","v":"Notices"}]
[]
[]
[]
[null,"Copyright Notice"]
[]
[null,"This work is licensed under a Creative Commons Attribution-No Derivatives 4.0 International License. "]
[null,"These materials are copyright to Baxter Lawley Pty Ltd (BaxterLawley) and National Disability Services (NDS). They can be accessed and used by anyone, including for supporting commercially provided training. However, when using the materials, please note that:"]
[null,"• The materials cannot be disaggregated – each component of these materials must be presented in a complete format. Components cannot be removed or separately presented."]
[null,"• The logos, colours and graphics must be retained. "]
[null,"• The notes must be retained."]
[null,"• If the materials are being used for a presentation, whether commercially or otherwise, BaxterLawley and NDS must be acknowledged as the authors, owners and copyright holders of these materials."]
[]
[]
[null,"Acknowledgment"]
[null,"This body of work is funded by the 2016 Capacity Building Grants Program of the Department of Finance, Government Procurement, Funding and Contracting Services (FaCS) Directorate. "]
[]
[]
[null,"Legal Disclaimer"]
[null,"The information provided in this course and accompanying document is made available in good faith and is believed accurate at the time of publication. However, these materials are intended to be a guide only and are not a substitute for obtaining appropriate advice or making prudent enquiries. The information is provided solely on the basis that readers will be responsible for making their own assessment of the matters discussed therein and that they should verify all relevant representations, statements and information. Changes in legislation, or other circumstances, after the document has been published may impact on the accuracy of any information or advice contained in the document and readers should not rely on the accuracy of information presented in this document.  Information presented in this document does not constitute, and is not intended as advice nor used as an interpretive instrument. In the event of any inconsistency between this document and relevant legislation, provisions of the relevant legislation will prevail."]
[]
[null,"Neither BaxterLawley Pty Ltd (BaxterLawley), National Disability Services Limited (NDS) nor any employee or agent of either organisation, nor any authors or contributors to this document shall be liable for any loss, damage, personal injury or death however caused (whether caused by any negligent or other unlawful act or omission of BaxterLawley or NDS by or on the part of or otherwise) arising from the use of or reliance on any information, data or advice) expressed or implied in this document."]

{"sheet":"Conventions","index":3,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[{"$f":"client","v":"National Disability Services WA"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"\"Version \"&TEXT(version,\"0.0\")&\" (\"&+creation_date&\")\"","v":"Version 1.0 (September 2017)"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A6),LEN(CELL(\"filename\",A6))-FIND(\"]\",CELL(\"filename\",A6)))","v":"Conventions"}]
[]
[]
[]
[null,"Look and feel"]
[]
[null,"a1",null,"Formula","Black text; protected"]
[]
[null,"a1",null,"Manual data entry","Yellow fill; Blue text; unprotected"]
[]
[null,"a1",null,"Manual data entry not required","Grey fill; bold Red text; unprotected"]
[]
[null,"a1",null,"Select from the dropdown menu","Blue fill; Blue text; unprotected"]
[]
[null,"a1",null,"Administration use only","Pink fill; Blue text; unprotected"]
[]
[null,null,null,"No data ","DarkGrey fill; protected"]
[]
[null,"a1",null,"Model build only","Beige fill; Black text; protected"]
[]
[null,"comment",null,"Comment","Pink text; protected"]
[]
[null,"ERROR",null,"Error check formula indicating error","Red fill; bold White text; protected"]
[]
[]
[]
[]
[null,"Rounding"]
[null,"Calculated values are generally rounded to the accuracy at which they appear."]
[]
[]
[null,"Worksheet protection"]
[null,"Each worksheet is protected to prevent inadvertent changes to or deletion of formulas."]

{"sheet":"Instructions","index":4,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[{"$f":"client","v":"National Disability Services WA"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"\"Version \"&TEXT(version,\"0.0\")&\" (\"&+creation_date&\")\"","v":"Version 1.0 (September 2017)"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A6),LEN(CELL(\"filename\",A6))-FIND(\"]\",CELL(\"filename\",A6)))","v":"Instructions"}]
[]
[]
[]
[null,"Let’s consider the general style of analysis that will be useful here.\n"]
[null,"For the most part, these analyses focus on operating costs and on the scope to reduce operating costs through some form of collaboration.  \n"]
[null,"When thinking about costs you might find it useful to stop thinking about dollar values and start thinking about what it is your organisation consumes—staff time, use of buildings and motor vehicles, insurance coverage, consumables, etcetera—and in what volumes.  This perspective makes the analysis feel very tangible, and consequently more difficult to get wrong.\n"]
[null,"Once you have a good idea of what is being consumed and in what quantities, you can apply rates—that is, the amount being paid for each unit of consumption—to arrive at total operating costs.\n"]
[null,"Operating costs are an important part of the analysis, and probably the most important part for most organisations, but we also need to consider capital costs.  Capital costs are amounts that have been invested in assets.  Examples are cars and software systems.\n"]
[null,"Capital costs will come into consideration if new investments are required for the collaboration to succeed and/or if existing investments are devalued by the proposed collaboration.   As an example: if your organisation just installed a new payroll system at a cost of $50,000 and you’re now looking at outsourcing your payroll function then the value of that investment will be written down to zero—a one-off cost of entering the collaboration of $50,000.\n"]
[null,"The 'Assessment' worksheet consolidates the annual saving results of all the collaboration options.  In this worksheet you can enter capital costs and other one-off costs of both entering and leaving the collaboration.  It is here that you also specify the assessment period in years.\n"]
[null,"It’s important to remember that the tool isn’t a prescription for the analysis you should perform for your organisation.  \n"]
[null,"We do not warrant that it’s either necessary or sufficient.  But we are putting it forward as an example of the style of analysis that will give you meaningful results.\n"]
[null,"Always remember, your objective is to do the analysis that is fit for purpose for your organisation and that will give you comfort to make a high quality decision about which collaboration option is best for you.\n"]
[null,"Note that all values in this tool are in today's dollars.  For simplicity, no attempt is made to acknowledge the time value of money or the timing of expenditure."]

{"sheet":"Information","index":5,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":"client","v":"National Disability Services WA"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"\"Version \"&TEXT(version,\"0.0\")&\" (\"&+creation_date&\")\"","v":"Version 1.0 (September 2017)"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A6),LEN(CELL(\"filename\",A6))-FIND(\"]\",CELL(\"filename\",A6)))","v":"Information"}]
[]
[]
[]
[null,"Organisation","Your organisation's name"]
[]
[null,"Year","Year of review"]
[]
[null,"Prepared by"]
[]
[null,"Reviewed by"]
[]
[null,"Approved by"]

{"sheet":"Home","index":6,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["THIS IS HOME"]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A7),LEN(CELL(\"filename\",A7))-FIND(\"]\",CELL(\"filename\",A7)))","v":"Home"}]
[]
[]
[]
[null,"Types of Collaborations"]
[{"$f":"ROWS($11:11)","v":1},{"$f":"Shared_Advocacy!$A$6","v":"Shared_Advocacy"}]
[{"$f":"ROWS($11:12)","v":2},{"$f":"Shared_Services!$A$6","v":"Shared_Services"}]
[{"$f":"ROWS($11:13)","v":3},{"$f":"Shared_Delivery!$A$6","v":"Shared_Delivery"}]
[{"$f":"ROWS($11:14)","v":4},{"$f":"Auspicing!$A$6","v":"Auspicing"}]
[{"$f":"ROWS($11:15)","v":5},{"$f":"Mentoring!$A$6","v":"Mentoring"}]
[{"$f":"ROWS($11:16)","v":6},{"$f":"Co_Location!$A$6","v":"Co_Location"}]
[{"$f":"ROWS($11:17)","v":7},{"$f":"Shared_Development!$A$6","v":"Shared_Development"}]
[{"$f":"ROWS($11:18)","v":8},{"$f":"Shared_Distribution!$A$6","v":"Shared_Distribution"}]
[{"$f":"ROWS($11:19)","v":9},{"$f":"Shared_Marketing!$A$6","v":"Shared_Marketing"}]
[{"$f":"ROWS($11:20)","v":10},{"$f":"Endorsement!$A$6","v":"Endorsement"}]
[{"$f":"ROWS($11:21)","v":11},{"$f":"Joint_Venture!$A$6","v":"Joint_Venture"}]
[{"$f":"ROWS($11:22)","v":12},{"$f":"Licensing!$A$6","v":"Licensing"}]

{"sheet":"Version_Control","index":7,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Version_Control"}]
[]
[]
["Alpha names indicate draft.  Numeric names indicate final."]
[]
["Rev","Date created","Author","Comments"]
["A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"COUNTA(rev_list)","v":1}]
[{"$f":"INDEX(rev_list,rev_counta)","v":"A"}]

{"sheet":"Assessment","index":8,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Assessment"}]
[]
[]
[]
[null,null,null,"Collaboration option"]
[null,"Item","Unit",{"$f":"Shared_Advocacy!$A$6","v":"Shared_Advocacy"},{"$f":"Shared_Services!$A$6","v":"Shared_Services"},{"$f":"Shared_Delivery!$A$6","v":"Shared_Delivery"},{"$f":"Auspicing!$A$6","v":"Auspicing"},{"$f":"Mentoring!$A$6","v":"Mentoring"},{"$f":"Co_Location!$A$6","v":"Co_Location"},{"$f":"Shared_Development!$A$6","v":"Shared_Development"},{"$f":"Shared_Distribution!$A$6","v":"Shared_Distribution"},{"$f":"Shared_Marketing!$A$6","v":"Shared_Marketing"},{"$f":"Endorsement!$A$6","v":"Endorsement"},{"$f":"Joint_Venture!$A$6","v":"Joint_Venture"},{"$f":"Licensing!$A$6","v":"Licensing"}]
[]
["A","Summary of results"]
[null,"Independent cost per year","$*",{"$f":"Shared_Advocacy!$C$23","v":0},{"$f":"Shared_Services!$G$23","v":0},{"$f":"Shared_Delivery!$C$23","v":0},{"$f":"Auspicing!$C$23","v":0},{"$f":"Mentoring!$C$23","v":0},{"$f":"Co_Location!$C$23","v":0},{"$f":"Shared_Development!$C$23","v":0},{"$f":"Shared_Distribution!$C$23","v":0},{"$f":"Shared_Marketing!$C$23","v":0},{"$f":"Endorsement!$C$23","v":0},{"$f":"Joint_Venture!$C$23","v":0},{"$f":"Licensing!$C$23","v":0}]
[null,"Less: Collaboration cost per year for same scope","$*",{"$f":"-Shared_Advocacy!$D$23","v":0},{"$f":"-Shared_Services!$H$23","v":0},{"$f":"-Shared_Delivery!$D$23","v":0},{"$f":"-Auspicing!$D$23","v":0},{"$f":"-Mentoring!$D$23","v":0},{"$f":"-Co_Location!$D$23","v":0},{"$f":"-Shared_Development!$D$23","v":0},{"$f":"-Shared_Distribution!$D$23","v":0},{"$f":"-Shared_Marketing!$D$23","v":0},{"$f":"-Endorsement!$D$23","v":0},{"$f":"-Joint_Venture!$D$23","v":0},{"$f":"-Licensing!$D$23","v":0}]
[null,"Gross collaboration saving per year (i.e. before management cost)","$*",{"$f":"SUM(D14:D15)","v":0},{"$f":"SUM(E14:E15)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Less: Cost of managing the collaboration","$*",{"$f":"Shared_Advocacy!$E$28","v":0},{"$f":"Shared_Services!$I$28","v":0},{"$f":"Shared_Delivery!$E$28","v":0},{"$f":"Auspicing!$E$28","v":0},{"$f":"Mentoring!$E$28","v":0},{"$f":"Co_Location!$E$28","v":0},{"$f":"Shared_Development!$E$28","v":0},{"$f":"Shared_Distribution!$E$28","v":0},{"$f":"Shared_Marketing!$E$28","v":0},{"$f":"Endorsement!$E$28","v":0},{"$f":"Joint_Venture!$E$28","v":0},{"$f":"Licensing!$E$28","v":0}]
[null,"Net collaboration saving per year (i.e. after management cost)","$*",{"$f":"SUM(D16:D17)","v":0},{"$f":"SUM(E16:E17)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"% Net collaboration saving per year","%",{"$f":"IF(D14=0,0,D18/D14)","v":0},{"$f":"IF(E14=0,0,E18/E14)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["B","Costs of entering and leaving the collaboration"]
[null,"Cost of entering the collaboration","$*"]
[null,"Cost of leaving the collaboration","$*"]
[]
["C","Calculation of comparative results"]
[null,"Assessment period","years"]
[null,{"$f":"B18","v":"Net collaboration saving per year (i.e. after management cost)"},"$*",{"$f":"D18","v":0},{"$f":"E18","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Net collaboration saving for the assessment period","$*",{"$f":"D26*D27","v":0},{"$f":"E26*E27","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"Best case result: remain in collaboration","$*",{"$f":"IF(ISBLANK(D$26),\"\",D28-D22)","v":""},{"$f":"IF(ISBLANK(E$26),\"\",E28-E22)","v":""},"","","","","","","","","",""]
[null,"Best case result ranking (1 is best)","#",{"$f":"IF(ISBLANK(D$26),\"\",RANK(D30,$D30:$O30,0))","v":""},"","","","","","","","","","",""]
[]
[null,"Worst case result: exit collaboration","$*",{"$f":"IF(ISBLANK(D$26),\"\",D28-D22-D23)","v":""},{"$f":"IF(ISBLANK(E$26),\"\",E28-E22-E23)","v":""},"","","","","","","","","",""]
[null,"Worst case result ranking (1 is worst)","#",{"$f":"IF(ISBLANK(D$26),\"\",RANK(D33,$D33:$O33,1))","v":""},"","","","","","","","","","",""]
[]
[]
[null,"* All values are in today's dollars.  For simplicity, no attempt is made to acknowledge the time value of money or the timing of expenditure."]

{"sheet":"Shared_Advocacy","index":9,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Shared_Advocacy"}]
[]
[]
[null,null,"A","B","C"]
[null,null,"Enter","Enter",{"$f":"C9&\" - \"&D9","v":"A - B"}]
[]
["Ref","Item","Independent\ncost\nper year\n$","Collaboration\ncost\nper year\nfor same scope\n$","Gross collaboration\nsaving\nper year\n$"]
[{"$f":"ROWS($12:13)-1","v":1},null,null,null,{"$f":"C13-D13","v":0}]
[{"$f":"ROWS($12:14)-1","v":2},null,null,null,{"$f":"C14-D14","v":0}]
[{"$f":"ROWS($12:15)-1","v":3},null,null,null,0]
[{"$f":"ROWS($12:16)-1","v":4},null,null,null,0]
[{"$f":"ROWS($12:17)-1","v":5},null,null,null,0]
[{"$f":"ROWS($12:18)-1","v":6},null,null,null,0]
[{"$f":"ROWS($12:19)-1","v":7},null,null,null,0]
[{"$f":"ROWS($12:20)-1","v":8},null,null,null,0]
[{"$f":"ROWS($12:21)-1","v":9},null,null,null,0]
[{"$f":"ROWS($12:22)-1","v":10},null,null,null,0]
[null,"Total",{"$f":"SUM(C13:C22)","v":0},0,{"$f":"SUM(E13:E22)","v":0}]
[null,null,"SUM of A","SUM of B","SUM of C"]
[null,null,"D","E","F"]
[null,null,null,null,"⇣"]
[null,"Gross collaboration saving per year (i.e. before management cost)",null,null,{"$f":"E23","v":0},{"$f":"\"+ \"&E25","v":"+ F"}]
[null,"Less: Cost of managing the collaboration",null,null,null,"Enter","G"]
[null,"Net collaboration saving per year (i.e. after management cost)",null,null,{"$f":"SUM(E27:E28)","v":0},{"$f":"E25&\" + \"&G28","v":"F + G"},"H"]
[]
[null,"% Net collaboration saving per year",null,null,{"$f":"IF(C23=0,0,E29/C23)","v":0},{"$f":"G29&\" / \"&C25","v":"H / D"}]

{"sheet":"Shared_Services","index":10,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Shared_Services"}]
[]
[null,"> Group Buying"]
[null,null,null,"A","B","C","D","E","F"]
[null,null,null,"Enter","Enter","Enter",{"$f":"D9&\" x \"&E9","v":"A x B"},{"$f":"D9&\" x \"&F9","v":"A x C"},{"$f":"G9&\" - \"&H9","v":"D - E"}]
[]
["Ref","Item","Unit","Procurement quantity\n per year\nin Units","Independent\ncost\nper unit\n$","Collaboration\ncost\nper unit\n$","Independent\ncost\nper year\n$","Collaboration\ncost\nper year\n$","Gross collaboration\nsaving\nper year\n$"]
[{"$f":"ROWS($12:13)-1","v":1},null,null,null,null,null,{"$f":"ROUND(D13*E13,0)","v":0},{"$f":"ROUND(D13*F13,0)","v":0},{"$f":"G13-H13","v":0}]
[{"$f":"ROWS($12:14)-1","v":2},null,null,null,null,null,{"$f":"ROUND(D14*E14,0)","v":0},{"$f":"ROUND(D14*F14,0)","v":0},{"$f":"G14-H14","v":0}]
[{"$f":"ROWS($12:15)-1","v":3},null,null,null,null,null,{"$f":"ROUND(D15*E15,0)","v":0},{"$f":"ROUND(D15*F15,0)","v":0},0]
[{"$f":"ROWS($12:16)-1","v":4},null,null,null,null,null,0,0,0]
[{"$f":"ROWS($12:17)-1","v":5},null,null,null,null,null,0,0,0]
[{"$f":"ROWS($12:18)-1","v":6},null,null,null,null,null,0,0,0]
[{"$f":"ROWS($12:19)-1","v":7},null,null,null,null,null,0,0,0]
[{"$f":"ROWS($12:20)-1","v":8},null,null,null,null,null,0,0,0]
[{"$f":"ROWS($12:21)-1","v":9},null,null,null,null,null,0,0,0]
[{"$f":"ROWS($12:22)-1","v":10},null,null,null,null,null,0,0,0]
[null,null,null,null,null,"Total",{"$f":"SUM(G13:G22)","v":0},{"$f":"SUM(H13:H22)","v":0},{"$f":"SUM(I13:I22)","v":0}]
[null,null,null,null,null,null,"SUM of D","SUM of E","SUM of F"]
[null,null,null,null,null,null,"G","H","J"]
[null,null,null,null,null,null,null,null,"⇣"]
[null,null,null,null,"Gross collaboration saving per year (i.e. before management cost)",null,null,null,{"$f":"I23","v":0},{"$f":"\"+ \"&I25","v":"+ J"}]
[null,null,null,null,"Less: Cost of managing the collaboration",null,null,null,null,"Enter","K"]
[null,null,null,null,"Net collaboration saving per year (i.e. after management cost)",null,null,null,{"$f":"SUM(I27:I28)","v":0},{"$f":"I25&\" + \"&K28","v":"J + K"},"L"]
[]
[null,null,null,null,"% Net collaboration saving per year",null,null,null,{"$f":"IF(G23=0,0,I29/G23)","v":0},{"$f":"K29&\" / \"&G25","v":"L / G"}]

{"sheet":"Shared_Delivery","index":11,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Shared_Delivery"}]
[]
[]
[null,null,"A","B","C"]
[null,null,"Enter","Enter",{"$f":"C9&\" - \"&D9","v":"A - B"}]
[]
["Ref","Item","Independent\ncost\nper year\n$","Collaboration\ncost\nper year\nfor same scope\n$","Gross collaboration\nsaving\nper year\n$"]
[{"$f":"ROWS($12:13)-1","v":1},null,null,null,{"$f":"C13-D13","v":0}]
[{"$f":"ROWS($12:14)-1","v":2},null,null,null,{"$f":"C14-D14","v":0}]
[{"$f":"ROWS($12:15)-1","v":3},null,null,null,0]
[{"$f":"ROWS($12:16)-1","v":4},null,null,null,0]
[{"$f":"ROWS($12:17)-1","v":5},null,null,null,0]
[{"$f":"ROWS($12:18)-1","v":6},null,null,null,0]
[{"$f":"ROWS($12:19)-1","v":7},null,null,null,0]
[{"$f":"ROWS($12:20)-1","v":8},null,null,null,0]
[{"$f":"ROWS($12:21)-1","v":9},null,null,null,0]
[{"$f":"ROWS($12:22)-1","v":10},null,null,null,0]
[null,"Total",{"$f":"SUM(C13:C22)","v":0},0,{"$f":"SUM(E13:E22)","v":0}]
[null,null,"SUM of A","SUM of B","SUM of C"]
[null,null,"D","E","F"]
[null,null,null,null,"⇣"]
[null,"Gross collaboration saving per year (i.e. before management cost)",null,null,{"$f":"E23","v":0},{"$f":"\"+ \"&E25","v":"+ F"}]
[null,"Less: Cost of managing the collaboration",null,null,null,"Enter","G"]
[null,"Net collaboration saving per year (i.e. after management cost)",null,null,{"$f":"SUM(E27:E28)","v":0},{"$f":"E25&\" + \"&G28","v":"F + G"},"H"]
[]
[null,"% Net collaboration saving per year",null,null,{"$f":"IF(C23=0,0,E29/C23)","v":0},{"$f":"G29&\" / \"&C25","v":"H / D"}]

{"sheet":"Auspicing","index":12,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Auspicing"}]
[]
[]
[null,null,"A","B","C"]
[null,null,"Enter","Enter",{"$f":"C9&\" - \"&D9","v":"A - B"}]
[]
["Ref","Item","Independent\ncost\nper year\n$","Collaboration\ncost\nper year\nfor same scope\n$","Gross collaboration\nsaving\nper year\n$"]
[{"$f":"ROWS($12:13)-1","v":1},null,null,null,{"$f":"C13-D13","v":0}]
[{"$f":"ROWS($12:14)-1","v":2},null,null,null,{"$f":"C14-D14","v":0}]
[{"$f":"ROWS($12:15)-1","v":3},null,null,null,0]
[{"$f":"ROWS($12:16)-1","v":4},null,null,null,0]
[{"$f":"ROWS($12:17)-1","v":5},null,null,null,0]
[{"$f":"ROWS($12:18)-1","v":6},null,null,null,0]
[{"$f":"ROWS($12:19)-1","v":7},null,null,null,0]
[{"$f":"ROWS($12:20)-1","v":8},null,null,null,0]
[{"$f":"ROWS($12:21)-1","v":9},null,null,null,0]
[{"$f":"ROWS($12:22)-1","v":10},null,null,null,0]
[null,"Total",{"$f":"SUM(C13:C22)","v":0},0,{"$f":"SUM(E13:E22)","v":0}]
[null,null,"SUM of A","SUM of B","SUM of C"]
[null,null,"D","E","F"]
[null,null,null,null,"⇣"]
[null,"Gross collaboration saving per year (i.e. before management cost)",null,null,{"$f":"E23","v":0},{"$f":"\"+ \"&E25","v":"+ F"}]
[null,"Less: Cost of managing the collaboration",null,null,null,"Enter","G"]
[null,"Net collaboration saving per year (i.e. after management cost)",null,null,{"$f":"SUM(E27:E28)","v":0},{"$f":"E25&\" + \"&G28","v":"F + G"},"H"]
[]
[null,"% Net collaboration saving per year",null,null,{"$f":"IF(C23=0,0,E29/C23)","v":0},{"$f":"G29&\" / \"&C25","v":"H / D"}]

{"sheet":"Mentoring","index":13,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Mentoring"}]
[]
[]
[null,null,"A","B","C"]
[null,null,"Enter","Enter",{"$f":"C9&\" - \"&D9","v":"A - B"}]
[]
["Ref","Item","Independent\ncost\nper year\n$","Collaboration\ncost\nper year\nfor same scope\n$","Gross collaboration\nsaving\nper year\n$"]
[{"$f":"ROWS($12:13)-1","v":1},null,null,null,{"$f":"C13-D13","v":0}]
[{"$f":"ROWS($12:14)-1","v":2},null,null,null,{"$f":"C14-D14","v":0}]
[{"$f":"ROWS($12:15)-1","v":3},null,null,null,0]
[{"$f":"ROWS($12:16)-1","v":4},null,null,null,0]
[{"$f":"ROWS($12:17)-1","v":5},null,null,null,0]
[{"$f":"ROWS($12:18)-1","v":6},null,null,null,0]
[{"$f":"ROWS($12:19)-1","v":7},null,null,null,0]
[{"$f":"ROWS($12:20)-1","v":8},null,null,null,0]
[{"$f":"ROWS($12:21)-1","v":9},null,null,null,0]
[{"$f":"ROWS($12:22)-1","v":10},null,null,null,0]
[null,"Total",{"$f":"SUM(C13:C22)","v":0},0,{"$f":"SUM(E13:E22)","v":0}]
[null,null,"SUM of A","SUM of B","SUM of C"]
[null,null,"D","E","F"]
[null,null,null,null,"⇣"]
[null,"Gross collaboration saving per year (i.e. before management cost)",null,null,{"$f":"E23","v":0},{"$f":"\"+ \"&E25","v":"+ F"}]
[null,"Less: Cost of managing the collaboration",null,null,null,"Enter","G"]
[null,"Net collaboration saving per year (i.e. after management cost)",null,null,{"$f":"SUM(E27:E28)","v":0},{"$f":"E25&\" + \"&G28","v":"F + G"},"H"]
[]
[null,"% Net collaboration saving per year",null,null,{"$f":"IF(C23=0,0,E29/C23)","v":0},{"$f":"G29&\" / \"&C25","v":"H / D"}]

{"sheet":"Co_Location","index":14,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Co_Location"}]
[]
[]
[null,null,"A","B","C"]
[null,null,"Enter","Enter",{"$f":"C9&\" - \"&D9","v":"A - B"}]
[]
["Ref","Item","Independent\ncost\nper year\n$","Collaboration\ncost\nper year\nfor same scope\n$","Gross collaboration\nsaving\nper year\n$"]
[{"$f":"ROWS($12:13)-1","v":1},null,null,null,{"$f":"C13-D13","v":0}]
[{"$f":"ROWS($12:14)-1","v":2},null,null,null,{"$f":"C14-D14","v":0}]
[{"$f":"ROWS($12:15)-1","v":3},null,null,null,0]
[{"$f":"ROWS($12:16)-1","v":4},null,null,null,0]
[{"$f":"ROWS($12:17)-1","v":5},null,null,null,0]
[{"$f":"ROWS($12:18)-1","v":6},null,null,null,0]
[{"$f":"ROWS($12:19)-1","v":7},null,null,null,0]
[{"$f":"ROWS($12:20)-1","v":8},null,null,null,0]
[{"$f":"ROWS($12:21)-1","v":9},null,null,null,0]
[{"$f":"ROWS($12:22)-1","v":10},null,null,null,0]
[null,"Total",{"$f":"SUM(C13:C22)","v":0},0,{"$f":"SUM(E13:E22)","v":0}]
[null,null,"SUM of A","SUM of B","SUM of C"]
[null,null,"D","E","F"]
[null,null,null,null,"⇣"]
[null,"Gross collaboration saving per year (i.e. before management cost)",null,null,{"$f":"E23","v":0},{"$f":"\"+ \"&E25","v":"+ F"}]
[null,"Less: Cost of managing the collaboration",null,null,null,"Enter","G"]
[null,"Net collaboration saving per year (i.e. after management cost)",null,null,{"$f":"SUM(E27:E28)","v":0},{"$f":"E25&\" + \"&G28","v":"F + G"},"H"]
[]
[null,"% Net collaboration saving per year",null,null,{"$f":"IF(C23=0,0,E29/C23)","v":0},{"$f":"G29&\" / \"&C25","v":"H / D"}]

{"sheet":"Shared_Development","index":15,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Shared_Development"}]
[]
[]
[null,null,"A","B","C"]
[null,null,"Enter","Enter",{"$f":"C9&\" - \"&D9","v":"A - B"}]
[]
["Ref","Item","Independent\ncost\nper year\n$","Collaboration\ncost\nper year\nfor same scope\n$","Gross collaboration\nsaving\nper year\n$"]
[{"$f":"ROWS($12:13)-1","v":1},null,null,null,{"$f":"C13-D13","v":0}]
[{"$f":"ROWS($12:14)-1","v":2},null,null,null,{"$f":"C14-D14","v":0}]
[{"$f":"ROWS($12:15)-1","v":3},null,null,null,0]
[{"$f":"ROWS($12:16)-1","v":4},null,null,null,0]
[{"$f":"ROWS($12:17)-1","v":5},null,null,null,0]
[{"$f":"ROWS($12:18)-1","v":6},null,null,null,0]
[{"$f":"ROWS($12:19)-1","v":7},null,null,null,0]
[{"$f":"ROWS($12:20)-1","v":8},null,null,null,0]
[{"$f":"ROWS($12:21)-1","v":9},null,null,null,0]
[{"$f":"ROWS($12:22)-1","v":10},null,null,null,0]
[null,"Total",{"$f":"SUM(C13:C22)","v":0},0,{"$f":"SUM(E13:E22)","v":0}]
[null,null,"SUM of A","SUM of B","SUM of C"]
[null,null,"D","E","F"]
[null,null,null,null,"⇣"]
[null,"Gross collaboration saving per year (i.e. before management cost)",null,null,{"$f":"E23","v":0},{"$f":"\"+ \"&E25","v":"+ F"}]
[null,"Less: Cost of managing the collaboration",null,null,null,"Enter","G"]
[null,"Net collaboration saving per year (i.e. after management cost)",null,null,{"$f":"SUM(E27:E28)","v":0},{"$f":"E25&\" + \"&G28","v":"F + G"},"H"]
[]
[null,"% Net collaboration saving per year",null,null,{"$f":"IF(C23=0,0,E29/C23)","v":0},{"$f":"G29&\" / \"&C25","v":"H / D"}]

{"sheet":"Shared_Distribution","index":16,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Shared_Distribution"}]
[]
[]
[null,null,"A","B","C"]
[null,null,"Enter","Enter",{"$f":"C9&\" - \"&D9","v":"A - B"}]
[]
["Ref","Item","Independent\ncost\nper year\n$","Collaboration\ncost\nper year\nfor same scope\n$","Gross collaboration\nsaving\nper year\n$"]
[{"$f":"ROWS($12:13)-1","v":1},null,null,null,{"$f":"C13-D13","v":0}]
[{"$f":"ROWS($12:14)-1","v":2},null,null,null,{"$f":"C14-D14","v":0}]
[{"$f":"ROWS($12:15)-1","v":3},null,null,null,0]
[{"$f":"ROWS($12:16)-1","v":4},null,null,null,0]
[{"$f":"ROWS($12:17)-1","v":5},null,null,null,0]
[{"$f":"ROWS($12:18)-1","v":6},null,null,null,0]
[{"$f":"ROWS($12:19)-1","v":7},null,null,null,0]
[{"$f":"ROWS($12:20)-1","v":8},null,null,null,0]
[{"$f":"ROWS($12:21)-1","v":9},null,null,null,0]
[{"$f":"ROWS($12:22)-1","v":10},null,null,null,0]
[null,"Total",{"$f":"SUM(C13:C22)","v":0},0,{"$f":"SUM(E13:E22)","v":0}]
[null,null,"SUM of A","SUM of B","SUM of C"]
[null,null,"D","E","F"]
[null,null,null,null,"⇣"]
[null,"Gross collaboration saving per year (i.e. before management cost)",null,null,{"$f":"E23","v":0},{"$f":"\"+ \"&E25","v":"+ F"}]
[null,"Less: Cost of managing the collaboration",null,null,null,"Enter","G"]
[null,"Net collaboration saving per year (i.e. after management cost)",null,null,{"$f":"SUM(E27:E28)","v":0},{"$f":"E25&\" + \"&G28","v":"F + G"},"H"]
[]
[null,"% Net collaboration saving per year",null,null,{"$f":"IF(C23=0,0,E29/C23)","v":0},{"$f":"G29&\" / \"&C25","v":"H / D"}]

{"sheet":"Shared_Marketing","index":17,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Shared_Marketing"}]
[]
[]
[null,null,"A","B","C"]
[null,null,"Enter","Enter",{"$f":"C9&\" - \"&D9","v":"A - B"}]
[]
["Ref","Item","Independent\ncost\nper year\n$","Collaboration\ncost\nper year\nfor same scope\n$","Gross collaboration\nsaving\nper year\n$"]
[{"$f":"ROWS($12:13)-1","v":1},null,null,null,{"$f":"C13-D13","v":0}]
[{"$f":"ROWS($12:14)-1","v":2},null,null,null,{"$f":"C14-D14","v":0}]
[{"$f":"ROWS($12:15)-1","v":3},null,null,null,0]
[{"$f":"ROWS($12:16)-1","v":4},null,null,null,0]
[{"$f":"ROWS($12:17)-1","v":5},null,null,null,0]
[{"$f":"ROWS($12:18)-1","v":6},null,null,null,0]
[{"$f":"ROWS($12:19)-1","v":7},null,null,null,0]
[{"$f":"ROWS($12:20)-1","v":8},null,null,null,0]
[{"$f":"ROWS($12:21)-1","v":9},null,null,null,0]
[{"$f":"ROWS($12:22)-1","v":10},null,null,null,0]
[null,"Total",{"$f":"SUM(C13:C22)","v":0},0,{"$f":"SUM(E13:E22)","v":0}]
[null,null,"SUM of A","SUM of B","SUM of C"]
[null,null,"D","E","F"]
[null,null,null,null,"⇣"]
[null,"Gross collaboration saving per year (i.e. before management cost)",null,null,{"$f":"E23","v":0},{"$f":"\"+ \"&E25","v":"+ F"}]
[null,"Less: Cost of managing the collaboration",null,null,null,"Enter","G"]
[null,"Net collaboration saving per year (i.e. after management cost)",null,null,{"$f":"SUM(E27:E28)","v":0},{"$f":"E25&\" + \"&G28","v":"F + G"},"H"]
[]
[null,"% Net collaboration saving per year",null,null,{"$f":"IF(C23=0,0,E29/C23)","v":0},{"$f":"G29&\" / \"&C25","v":"H / D"}]

{"sheet":"Endorsement","index":18,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Endorsement"}]
[]
[]
[null,null,"A","B","C"]
[null,null,"Enter","Enter",{"$f":"C9&\" - \"&D9","v":"A - B"}]
[]
["Ref","Item","Independent\ncost\nper year\n$","Collaboration\ncost\nper year\nfor same scope\n$","Gross collaboration\nsaving\nper year\n$"]
[{"$f":"ROWS($12:13)-1","v":1},null,null,null,{"$f":"C13-D13","v":0}]
[{"$f":"ROWS($12:14)-1","v":2},null,null,null,{"$f":"C14-D14","v":0}]
[{"$f":"ROWS($12:15)-1","v":3},null,null,null,0]
[{"$f":"ROWS($12:16)-1","v":4},null,null,null,0]
[{"$f":"ROWS($12:17)-1","v":5},null,null,null,0]
[{"$f":"ROWS($12:18)-1","v":6},null,null,null,0]
[{"$f":"ROWS($12:19)-1","v":7},null,null,null,0]
[{"$f":"ROWS($12:20)-1","v":8},null,null,null,0]
[{"$f":"ROWS($12:21)-1","v":9},null,null,null,0]
[{"$f":"ROWS($12:22)-1","v":10},null,null,null,0]
[null,"Total",{"$f":"SUM(C13:C22)","v":0},0,{"$f":"SUM(E13:E22)","v":0}]
[null,null,"SUM of A","SUM of B","SUM of C"]
[null,null,"D","E","F"]
[null,null,null,null,"⇣"]
[null,"Gross collaboration saving per year (i.e. before management cost)",null,null,{"$f":"E23","v":0},{"$f":"\"+ \"&E25","v":"+ F"}]
[null,"Less: Cost of managing the collaboration",null,null,null,"Enter","G"]
[null,"Net collaboration saving per year (i.e. after management cost)",null,null,{"$f":"SUM(E27:E28)","v":0},{"$f":"E25&\" + \"&G28","v":"F + G"},"H"]
[]
[null,"% Net collaboration saving per year",null,null,{"$f":"IF(C23=0,0,E29/C23)","v":0},{"$f":"G29&\" / \"&C25","v":"H / D"}]

{"sheet":"Joint_Venture","index":19,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Joint_Venture"}]
[]
[]
[null,null,"A","B","C"]
[null,null,"Enter","Enter",{"$f":"C9&\" - \"&D9","v":"A - B"}]
[]
["Ref","Item","Independent\ncost\nper year\n$","Collaboration\ncost\nper year\nfor same scope\n$","Gross collaboration\nsaving\nper year\n$"]
[{"$f":"ROWS($12:13)-1","v":1},null,null,null,{"$f":"C13-D13","v":0}]
[{"$f":"ROWS($12:14)-1","v":2},null,null,null,{"$f":"C14-D14","v":0}]
[{"$f":"ROWS($12:15)-1","v":3},null,null,null,0]
[{"$f":"ROWS($12:16)-1","v":4},null,null,null,0]
[{"$f":"ROWS($12:17)-1","v":5},null,null,null,0]
[{"$f":"ROWS($12:18)-1","v":6},null,null,null,0]
[{"$f":"ROWS($12:19)-1","v":7},null,null,null,0]
[{"$f":"ROWS($12:20)-1","v":8},null,null,null,0]
[{"$f":"ROWS($12:21)-1","v":9},null,null,null,0]
[{"$f":"ROWS($12:22)-1","v":10},null,null,null,0]
[null,"Total",{"$f":"SUM(C13:C22)","v":0},0,{"$f":"SUM(E13:E22)","v":0}]
[null,null,"SUM of A","SUM of B","SUM of C"]
[null,null,"D","E","F"]
[null,null,null,null,"⇣"]
[null,"Gross collaboration saving per year (i.e. before management cost)",null,null,{"$f":"E23","v":0},{"$f":"\"+ \"&E25","v":"+ F"}]
[null,"Less: Cost of managing the collaboration",null,null,null,"Enter","G"]
[null,"Net collaboration saving per year (i.e. after management cost)",null,null,{"$f":"SUM(E27:E28)","v":0},{"$f":"E25&\" + \"&G28","v":"F + G"},"H"]
[]
[null,"% Net collaboration saving per year",null,null,{"$f":"IF(C23=0,0,E29/C23)","v":0},{"$f":"G29&\" / \"&C25","v":"H / D"}]

{"sheet":"Licensing","index":20,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Home!$A$6","v":"Home"}]
[{"$f":"organisation","v":"Your organisation's name"}]
[{"$f":"title","v":"Collaboration Options Analysis Tool"}]
[{"$f":"year&+\" Rev\"&+current_rev","v":"Year of review RevA"}]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Licensing"}]
[]
[]
[null,null,"A","B","C"]
[null,null,"Enter","Enter",{"$f":"C9&\" - \"&D9","v":"A - B"}]
[]
["Ref","Item","Independent\ncost\nper year\n$","Collaboration\ncost\nper year\nfor same scope\n$","Gross collaboration\nsaving\nper year\n$"]
[{"$f":"ROWS($12:13)-1","v":1},null,null,null,{"$f":"C13-D13","v":0}]
[{"$f":"ROWS($12:14)-1","v":2},null,null,null,{"$f":"C14-D14","v":0}]
[{"$f":"ROWS($12:15)-1","v":3},null,null,null,0]
[{"$f":"ROWS($12:16)-1","v":4},null,null,null,0]
[{"$f":"ROWS($12:17)-1","v":5},null,null,null,0]
[{"$f":"ROWS($12:18)-1","v":6},null,null,null,0]
[{"$f":"ROWS($12:19)-1","v":7},null,null,null,0]
[{"$f":"ROWS($12:20)-1","v":8},null,null,null,0]
[{"$f":"ROWS($12:21)-1","v":9},null,null,null,0]
[{"$f":"ROWS($12:22)-1","v":10},null,null,null,0]
[null,"Total",{"$f":"SUM(C13:C22)","v":0},0,{"$f":"SUM(E13:E22)","v":0}]
[null,null,"SUM of A","SUM of B","SUM of C"]
[null,null,"D","E","F"]
[null,null,null,null,"⇣"]
[null,"Gross collaboration saving per year (i.e. before management cost)",null,null,{"$f":"E23","v":0},{"$f":"\"+ \"&E25","v":"+ F"}]
[null,"Less: Cost of managing the collaboration",null,null,null,"Enter","G"]
[null,"Net collaboration saving per year (i.e. after management cost)",null,null,{"$f":"SUM(E27:E28)","v":0},{"$f":"E25&\" + \"&G28","v":"F + G"},"H"]
[]
[null,"% Net collaboration saving per year",null,null,{"$f":"IF(C23=0,0,E29/C23)","v":0},{"$f":"G29&\" / \"&C25","v":"H / D"}]