{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1. Instructions","2. Summary by Funding Source","3. In-Kind Examples"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":4,"comments":1,"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":"1. Instructions","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[116,1,116,8],[122,1,122,8],[133,1,133,8],[152,1,152,8],[158,1,158,8],[214,1,214,8],[220,1,220,8],[178,1,178,8],[184,1,184,8],[195,1,195,8]]}
["OSC Technology Leadership Project Financial Template: Instructions"]
[]
[1,"Please refer to tab colour legend below. Not all tabs require input.\n                                     - Require input. Please see individual tab for details.\n                                     - For information/reference only; do not require input.\n\n                                                            "]
[2,"Cells within the template are shaded/coloured for different purposes. Some cells require your input (fillable), others contain drop down menus, and there are some cells which are outputs/calculate a figure based on your inputs. "]
[3,"Cells will colour/shade red if information is in the incorrect format or doesn't meet OSC Budget Requirements. In these cases you will need to correct errors. If you click these cells, a message will appear to help indicate what is wrong with the cell input. "]
[4,"Ocean Supercluster Cost Eligibility Guidelines, Foreign Cost Guidelines and In-Kind Guidelines can be found on the OSC Member Portal. "]
[5,"In-Kind examples are provided within this workbook on Tab 3. Please refer to them when filling out details on In-Kind. "]

{"sheet":"2. Summary by Funding Source","index":1,"n_rows":45,"n_cols":23,"rows_kept":45,"cut":false,"hidden":false,"merged":[[9,13,12,13],[2,4,2,5],[4,3,4,8],[5,0,5,8],[6,0,6,8],[7,0,7,2],[1,0,3,0],[1,1,3,3],[47,0,47,8],[7,3,7,6],[7,7,8,9],[9,7,23,9],[30,6,30,7],[31,6,31,7]]}
["You may add rows as required within the box below using the +/- toggles on the left axis. "]
[null,"Lead Participant:"]
[]
[]
["Fillable Cells","Auto-Fill Cells","Drop-Down Menu"]
["Summary by Funding Source"]
["***If a funding source has both an industry matched and non- industry matched component, please enter the source twice and indicate beside the company name in the same cell whether it is (matched) funding or (not-matched) funding. ",null,null,null,null,null,null,null,null,null,"Please do not format areas outside of the box surrounding the input form as this may disrupt the functionality of the spreadsheet. "]
["Project Participant Details",null,null,"Amount of Funding/Contribution",null,null,null,"Notes/Description"]
["Name","Type of Funding","OSC Matched?","Cash","In-Kind","Total","% of Total Matched Industry Contribution"]
["OSC ","OSC Funding","OSC",0,null,{"$f":"D10+E10","v":0}]
["Enter Funding Source","Industry Funding","Yes",0,0,0,{"$f":"IFERROR((IF(AND(B11=\"Industry Funding\", C11=\"Yes\"), F11/$E$29, 0)), 0)","v":0}]
["Enter Funding Source","Industry Funding","Yes",0,0,0,{"$f":"IFERROR((IF(AND(B12=\"Industry Funding\", C12=\"Yes\"), F12/$E$29, 0)), 0)","v":0}]
["Enter Funding Source","Drop-Down Box","Drop-Down Box",0,0,0,0]
["Enter Funding Source","Drop-Down Box","Drop-Down Box",0,0,0,0]
["Enter Funding Source","Drop-Down Box","Drop-Down Box",0,0,0,0]
["Enter Funding Source","Drop-Down Box","Drop-Down Box",0,0,0,0]
["Enter Funding Source","Drop-Down Box","Drop-Down Box",0,0,0,0]
["Enter Funding Source","Drop-Down Box","Drop-Down Box",0,0,0,0]
["Enter Funding Source","Drop-Down Box","Drop-Down Box",0,0,0,0]
["Enter Funding Source","Drop-Down Box","Drop-Down Box",0,0,0,0]
["Enter Funding Source","Drop-Down Box","Drop-Down Box",0,0,0,0]
["Enter Funding Source","Drop-Down Box","Drop-Down Box",0,0,0,0]
["Enter Funding Source","Drop-Down Box","Drop-Down Box",0,0,0,0]
["Enter Funding Source","Drop-Down Box","Drop-Down Box",0,0,0,0]
[null,null,"Total:",{"$f":"SUM(D10:D24)","v":0},{"$f":"SUM(E10:E24)","v":0},{"$f":"SUM(F10:F24)","v":0},{"$f":"IFERROR(F25/$F$25, 0)","v":0}]
[]
[" ",null,null,"Percent Totals for Project"]
[null,null,null,"Total OSC Funding:",{"$f":"SUMIF(B10:B24,\"OSC Funding\",F10:F24)","v":0},{"$f":"IFERROR(E28/$F$25,0)","v":0},"Percent In-Kind for Project"]
[null,null,null,"To. Industry Funding Matched:",{"$f":"SUMIFS(F10:F24, B10:B24,\"Industry Funding\", C10:C24, \"yes\")","v":0},0,"To. Industry Matched In-Kind:",{"$f":"SUMIFS(E10:E24, B10:B24,\"Industry Funding\", C10:C24, \"yes\")","v":0},{"$f":"IFERROR(H29/E29,0)","v":0}]
[null,null,null,"To. Industry Funding Not Matched:",{"$f":"SUMIFS(F10:F24, B10:B24,\"Industry Funding\", C10:C24, \"no\")","v":0},0,"Reimbursement Percentages"]
[null,null,null,"Total Gov't Funding:",{"$f":"SUMIF(B10:B24,\"Gov't Funding\",F10:F24)","v":0},{"$f":"IFERROR(E31/$F$25,0)","v":0},"OSC Reimbursement on Funded Eligible Costs (%):",null,{"$f":"IFERROR(E28/(E28+E29), 0)","v":0}]
[null,null,null,"Total Other Funding",{"$f":"SUMIF(B10:B24, \"Other Funding\", F10:F24)","v":0},{"$f":"IFERROR(E32/$F$25,0)","v":0}," Industry Matched Contribution (%):",null,{"$f":"IFERROR(E29/(E29+E28),0)","v":0}]
[null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"workpackages"]
[null,null,"Drop-Down Box","Drop-Down Box",null,null,null,null,null,null,null,null,null,"Drop-Down Box",null,"Drop-Down Box",null,null,null,"Names","Description","Dates","Value of work package"]
[null,null,"Yes","Industry Funding",null,null,null,null,null,null,null,null,null,"Yes",null,1,null,null,1,null,null,null,500]
[null,null,"No","Gov't Funding","OSC Co-investment Rate:",0.42,null,null,null,null,null,null,null,"No",null,2,null,null,2,null,null,null,1200]
[null,null,"N/A","Other Funding","Max OSC Funding",{"$f":"(E28+E29)*F40","v":0},null,null,null,null,null,null,null,null,null,3,null,null,3,null,null,null,4000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,5]
[]
[null,"Please do not format areas outside of the box surrounding the input form as this may disrupt the functionality of the spreadsheet. "]

{"sheet":"3. In-Kind Examples","index":2,"n_rows":76,"n_cols":9,"rows_kept":76,"cut":false,"hidden":false,"merged":[[72,8,72,9],[73,8,73,9],[74,8,74,9],[75,8,75,9],[69,1,69,9],[70,1,71,1],[70,2,71,2],[70,3,71,3],[70,4,70,7],[70,8,71,9],[14,3,15,3],[14,4,14,7],[14,8,15,9],[16,8,16,9],[2,1,2,4],[2,6,2,8],[3,1,6,9],[13,1,13,9],[14,1,15,1],[14,2,15,2],[17,8,17,9],[18,8,18,9],[19,8,19,9],[22,1,23,9],[24,1,25,1],[24,2,25,2],[24,3,25,3],[24,4,24,7],[24,8,25,9],[26,8,26,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[68,1,68,9],[50,8,50,9],[31,1,32,9],[49,8,49,9],[47,8,47,9],[48,8,48,9],[44,1,44,9],[45,1,46,1],[45,2,46,2],[45,3,46,3],[45,4,45,7],[45,8,46,9]]}
[]
[]
[null,"In-Kind Examples:"]
[null,"The OSC does not reimburse In-Kind contributions, but an Industry Member's In-Kind contribution to a project counts towards the Industry Match totals, which allows the OSC to match/reimburse other Eligible Costs to a higher percentage."]
[]
[]
[]
[null,"1. In-Kind Contribution"]
[null,"Step 1"]
[null,"Member 'A\" wishes to provide use of a ship to run tests and validate new technology to the project for free. "]
[null,"The fair market value of the good/service is $150,000.00 and is supported by market rates. "]
[null,"Member A's contribution would be an In-Kind contribution and recorded in the In-Kind column below.  "]
[null,"The approved OSC Reimbursement Rate for this project is 50%."]
[null,"Summary by Funding Source"]
[null,"Name","Type of Funding","OSC Matched?","Amount of Funding",null,null,null,"Notes/Description"]
[null,null,null,null,"Cash","In-Kind","Total","% of Total"]
[null,"OSC ","OSC Funding","OSC",0,0,{"$f":"E17+F17","v":0},{"$f":"IFERROR(G17/#REF!, 0)","v":0}]
[null,"Member A","Industry Funding","Yes",0,150000,{"$f":"E18+F18","v":150000},{"$f":"IFERROR(G18/#REF!, 0)","v":0}]
[null,"Enter Funding Source","Drop-Down Box","Yes",0,0,0,{"$f":"IFERROR(G19/#REF!, 0)","v":0}]
[null,"Enter Funding Source","Drop-Down Box","Yes",0,0,{"$f":"E20+F20","v":0},{"$f":"IFERROR(G20/#REF!, 0)","v":0}]
[]
[null,"Step 2"]
[null,"In this case, Member A will also be spending $150,000 on wages and salaries for staff working directly on the project. Where the OSC would have otherwise reimbursed/funded this costs at 50%, because Member A is also contributing an In-Kind Contribution of $150,000 (total of $300,000 in eligible costs), the OSC can reimburse/fund up to $150,000 of the wages and salaries."]
[]
[null,"Name","Type of Funding","OSC Matched?","Amount of Funding",null,null,null,"Notes/Description"]
[null,null,null,null,"Cash","In-Kind","Total","% of Total"]
[null,"OSC ","OSC Funding","OSC",150000,0,{"$f":"E27+F27","v":150000},{"$f":"IFERROR(G27/#REF!, 0)","v":0}]
[null,"Member A","Industry Funding","Yes",0,150000,{"$f":"E28+F28","v":150000},{"$f":"IFERROR(G28/#REF!, 0)","v":0}]
[null,"Enter Funding Source","Drop-Down Box","Yes",0,0,0,{"$f":"IFERROR(G29/#REF!, 0)","v":0}]
[null,"Enter Funding Source","Drop-Down Box","Yes",0,0,{"$f":"E30+F30","v":0},{"$f":"IFERROR(G30/#REF!, 0)","v":0}]
[]
[null,"Although the OSC does not reimburse In-Kind contributions directly, the In-kind contribution is included when calculating OSC's overall match/reimbursement."]
[]
[null,"Discounted cash costs - can be used in very special circumstances - please refer to OSC In-kind Contribution Guidance "]
[null,"Requires pre-approval by OSC"]
[]
[null,"Member to OSC"]
[null,"2a. Member wishes to provide software licenses which they sell in their normal course of business to the project in-kind and be reimbursed from the OSC for a portion of the In-Kind contribution."]
[null,"Member B wishes to provide software licenses to the project in-kind, to be used by staff working on the project. "]
[null,"Member B sells software licenses as part of their normal busines model and therefore has accss to market prices. "]
[null,"The FMV of the software licenses is $150,000 and Member B would like to be reimbursed for 50% of FMV"]
[null,"The Member would issue an invoice to the OSC for $150,000 and show the discounted portion of 50% of FMV. "]
[null,"OSC would pay the Member $75,000 and it would be shown as part of the OSC contribution."]
[null,"The remaining $75,000 would be recorded as an In-kind contribution."]
[null,"Summary by Funding Source"]
[null,"Name","Type of Funding","OSC Matched?","Amount of Funding",null,null,null,"Notes/Description"]
[null,null,null,null,"Cash","In-Kind","Total","% of Total"]
[null,"OSC ","OSC Funding","OSC",75000,0,{"$f":"E48+F48","v":75000},{"$f":"IFERROR(G48/#REF!, 0)","v":0}]
[null,"Member A","Industry Funding","Yes",0,0,{"$f":"E49+F49","v":0},{"$f":"IFERROR(G49/#REF!, 0)","v":0}]
[null,"Member B","Industry Funding","Yes",0,75000,{"$f":"E50+F50","v":75000},{"$f":"IFERROR(G50/#REF!, 0)","v":0}]
[null,"Enter Funding Source","Drop-Down Box","Drop-Down Box",0,0,{"$f":"E51+F51","v":0},{"$f":"IFERROR(G51/#REF!, 0)","v":0}]
[null," "]
[]
[null,"Discounted cash costs - can be used in very special circumstances - please refer to OSC In-kind Contribution Guidance "]
[null,"Requires pre-approval by OSC"]
[]
[null,"Member to Member"]
[null,"2b. Member B wishes to be reimbursed for a portion of the FMV of its good/service and another project partner will purchase it at a discount."]
[null,"      Member B sells product as part of their normal business model and has access to market prices. "]
[null," "]
[null,"Fair Market Value is $150,000 and Member B wishes to be reimbursed at 20%"]
[null,"Member B issues invoice to Member C for full FMV of product and shows discounted portion at 20%."]
[null,"Member C pays Member B for balance $150,000- 30,000 discount = $120,000."]
[null,"Member B shows the discount ($30,000) as an In-kind funding contribution "]
[null,"Member C shows the balance ($120,000) as follows "]
[null,"    OSC funding",60000]
[null,"    Member C",60000]
[]
[null,"In the example below, the total Industry Matched funding is equal to $90,000 (Member C's $60,000 and Member B's $30,000). At this time, OSC is only contributing $60,000, however, should the project spend more funding on eligible project costs, OSC could fund/reimburse another $30,000 to match against the Industry Matched funding of $90,000."]
[null,"Summary by Funding Source"]
[null,"Name","Type of Funding","OSC Matched?","Amount of Funding",null,null,null,"Notes/Description"]
[null,null,null,null,"Cash","In-Kind","Total","% of Total"]
[null,"OSC ","OSC Funding","OSC",60000,0,{"$f":"E73+F73","v":60000},{"$f":"IFERROR(G73/#REF!, 0)","v":0}]
[null,"Member A","Industry Funding","Yes",0,0,{"$f":"E74+F74","v":0},{"$f":"IFERROR(G74/#REF!, 0)","v":0}]
[null,"Member B","Industry Funding","Yes",0,30000,{"$f":"E75+F75","v":30000},{"$f":"IFERROR(G75/#REF!, 0)","v":0}]
[null,"Member C","Industry Funding","Yes",60000,0,{"$f":"E76+F76","v":60000},{"$f":"IFERROR(G76/#REF!, 0)","v":0}]