{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["INSTRUCTIONS","BUDGET","Journal","Outbound Details","Inbound Details","Inbound Budget Report","Welcome","Escapade Eskimo","Museum of History","Curling-Ice fishing","Winterlude","Omega Park","Parliament","Event 8","Farewell","SUMMARY-SOURCE & USE OF FUNDS"],"not_rendered":{"charts":0,"images":27,"macros":1,"external_links":0,"defined_names":3,"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":"INSTRUCTIONS","index":0,"n_rows":389,"n_cols":11,"rows_kept":389,"cut":false,"hidden":false,"merged":[]}
[null,"BEWARE",null,"OVERVIEW:",null,null,"SPECIAL NOTES",null,null,"PROGRAMMING NOTES"]
[null,"Macros must be enabled for full functionality",null,null,"Each Journey is required to plan, monitor and report on their activities.  The following forms",null,null,"If Macros are enabled, only the applicable worksheets and the "]
[null,"Refer to Macros Setting and Macros Enabling",null,null,"are designed to help Journey Treasurers (JT) perform this function in a consistent and uniform ",null,null,"applicable Budget rows will appear when \"Inbound\" or ",null,"1.       ","Differences between the Excel and the Calc templates:"]
[null,null,null,null,"fashion. ",null,null,"\"Outbound\" is selected in cell B1 of the Budget worksheet"]
[null,"Table of Content",null,null,null,null,null,null,null,"a.   ","The Macros are written in a different language which are not "]
[null,null,null,null,"There is usually more involved in the reporting of an Inbound Journey than an Outbound ",null,null,"Macros must be enable for the Inbound Budget Report button to ",null,null,"compatible with each other (specially the API):"]
[1,"Overview","D1",null,"Journey. The forms have been developed therefore to meet the needs of an Inbound Journey.  ",null,null,"work",null,null,"    Excel macros are writen in Visual Basic for Applications"]
[1.1000000000000001,"Budget tab","D42",null,"Having said that, the same forms can equally be used for an Outbound Journey, although some ",null,null,null,null,null,"    Calc macros are written in OpenOffice Basic"]
[1.2,"Event Planner tabs","D63",null,"of the elements may not be populated.",null,null,"All income should be recorded in column C of the journal as "]
[1.3,"Journal tab","D70",null,null,null,null,"either Ambassador Receipts, Host Receipts or Miscellaneous ",null,"b.   ","Inbound Budget Report macros"]
[1.4,"Outbound Detailed Tracking","D107",null,"We have developed a set of documents to allow the JT to properly plan, monitor and report on ",null,null,"Receipts with a detailed description in column H.",null,"1) ","For Excel – The set of macros is located in Module6"]
[1.5,"Inbound Detailed Tracking","D116",null,"the activities of their Journeys. For JTs with some computer skills and access to a computer "]
[1.6,"Inbound Budget Summary","D134",null,"and Microsoft Excel or LibreOffice Calc, the forms have also been somewhat automated ",null,"SOFTWARE VERSIONS",null,null,"i.","To access this set of macros, macros must be enabled, select "]
[1.7,"Summary-Source and Use of Fund","D150",null,"where much of the work has been preprogrammed.",null,null,"The Excel version of the templates were developed and work on ",null,null," “Developer” tab, select Macros, "]
[1.8,"Own Use","D160",null,null,null,null,"Excel 2007 in a windows environment and which has an xlsm",null,null,"select “Inbound_Budget_Report” which is the main macro, "]
[2,"Worksheet Protection","D163",null,"The yellow shaded cells of the worksheets are where user inputs data.",null,null,"extension.  The templates were also tested on Excel for Macintosh. ",null,null,"select “Edit”; then scroll up to view the global declarations."]
[3,"Macros Setting","D203",null,"The light yellow shaded cells of the Budget and Event Planner tabs contains formulas to ",null,null,"A tested version is also available for LibreOffice and OpenOffice Calc "]
[3.1,"Macros Enabling","D335",null,"automatically insert the number of Ambassadors from cell I2 of the Budget tab. These cells are unlocked ",null,null,"in a windows environment for anyone who does not have Excel. ",null,"ii.","To connect the Inbound Budget Report button to the macro, "]
[4,"Special Notes","G1",null,"are unlocked allowing the user to insert different numbers as required.",null,null,"LibreOffice is a more updated version of OpenOffice. Both are free.  ",null,null,"Unprotect the Inbound Budget report worksheet,"]
[5,"Software Versions","G13",null,"The light blue shaded cells contain user instructions and are protected to prevent accidental ",null,null,"Each is an office suite which basically mirrors the Microsoft Office ",null,null,"Select the “Developer” tab, Click “Design Mode” on, "]
[6,"Template Versions","G26",null,"changes or erasures. ",null,null,"suite with Calc being the spreadsheet.",null,null,"Right Click on the “Click Here to automatically fill-out this "]
[null,null,null,null,"Unhighlighted cells contain formulas and are protected to prevent accidental changes or ",null,null,"LibreOffice / OpenOffice requires a vesion of the templates different",null,null,"worksheet” button, Select “Assign Macro...”, select "]
[null,null,null,null,"erasures. ",null,null,"from Excel because they use a different language than Excel for ",null,null,"“Inbound_Budget_Report” which is the main macro, then "]
[null,null,null,null,null,null,null,"coding macros.",null,null,"click “Design Mode” off."]
[null,null,null,null,"We have also provided a sample completed documents which one can follow to see how "]
[null,null,null,null,"everything links together. See Toolbox on FFO website",null,"TEMPLATE VERSIONS",null,null,"2) ","For LibreOffice Calc – The set of macros for this function  "]
[null,null,null,null,null,null,null,null,null,null,"is located in Module1.  "]
[null,null,null,null,"The following instructions will detail and provide guidance for the completion of each of the ",null,"2019-02-24 VERSION 5"]
[null,null,null,null,"documents.  We have tried to make it as clear as possible and also make it applicable for both ",null,null,null,null,"i.","To access this set of macros, macros must be enabled, select "]
[null,null,null,null,"manual and electronic completion.  Each FORM or DOCUMENT to be completed manually ",null,"General",null,null,null,"the “Tools” tab, select “Macros”, select “Edit Macros”"]
[null,null,null,null,"is represented by a TAB in Excel.  If you are familiar with Excel, you know what TABs are.  If ",null,"1.  ","Made formulas compatible to both Excel and Calc.",null,null,"Click on the “+” icon to expand the name of the spreadsheet"]
[null,null,null,null,"you are not familiar with Excel, you only have to think of a TAB as representing a ",null,"2.  ","Two versions of the template are required and created, one for Excel ",null,null,"such as “JT_Financial_Templates_v_5.ods”, click on the "]
[null,null,null,null,"DOCUMENT.  EG the Budget Tab is the same as saying the Budget Document.",null,null,"and the other for Calc because: ",null,null," “+” icon of “VBAProject”, click on the “+” icon of "]
[null,null,null,null,null,null,null,"a) they each use different mean to create the active button that ",null,null," “Modules”, click on the “+” icon of “Module1”, double"]
[null,null,null,null,"There are two main documents to be completed by the JT, the Budget and Journal documents.  ",null,null,"initiate the macros for filling the Inbound Budget Report,  ",null,null,"click on “Inbound_Budget_Report” which is the main  "]
[null,null,null,null,"There is also detailed accounting documents to manage payment and expenses of FFO ",null,null,"b) they use a different way to link the required trigger to the macro ",null,null,"macro for this function.  then scroll up to view the global "]
[null,null,null,null,"personnel (one for outbound and a different one for inbound journeys).  For inbound, Event ",null,null,"used for diplaying only the Budget elements associated with either ",null,null,"declarations."]
[null,null,null,null,"Planners are available to help plan more complex events that are represented in the Budget as a ",null,null,"an Inbound or an Outbound journey;"]
[null,null,null,null,"single line as opposed to the many, many components of the event. The following explains each ",null,null,"c) they use a different programming language to code the required ",null,"ii.","To connect the Inbound Budget Report button to the macro, "]
[null,null,null,null,"documents.",null,null,"macros; and",null,null,"unprotect the Inbound Budget Report worksheet,"]
[null,null,null,null,null,null,null,"d) different instructions are required nad provided to amend the ",null,null,"select the “Tools” tab, select “Forms”, "]
[null,null,null,"BUDGET tab",null,null,null,"name of each Event planner tab.",null,null,"select “Design Mode” to turn it on, right click on the button, "]
[null,null,null,null,"The Budget tab contains the results of the 6 Event Plans and some standard revenues and ",null,null,null,null,null,"select “Control...”, select “Event” tab, select the “...”"]
[null,null,null,null,"expenses (where the first column indicates weather the item applies to inbound, outbound or ",null,"Budget tab",null,null,null,"button for  “Execute action”, left click on “Macro...”, "]
[null,null,null,null,"both types of journeys), plus there are sufficient additional spaces to add other revenues and ",null,"1.  ","Minor errors corrected  ",null,null,"Click on the “+” icon to expand the name of the spreadsheet"]
[null,null,null,null,"expenses that are not complex in nature.  Items similar to gift bags, photos, and booklets.",null,"2.  ","Added a field in cell I2 to input the number of ambassador such that ",null,null,"such as “JT_Financial_Templates_v_5.ods”, click on the "]
[null,null,null,null,null,null,null,"a change to this number would be replicated in cells D15, D21, D22, ",null,null," “+” icon of “VBAProject”, click on “Module1”, click on"]
[null,null,null,null,"It also contains a section setup to calculate exchange rate conversion for both CAD to USD for ",null,null,"D25, D30 and G19 when the associated condition is met.",null,null,"“Inbound Budjet Report”, click “OK”, click “OK”, close "]
[null,null,null,null,"an inbound exchange and various currencies to CAD for an outbound exchange.",null,"3.  ","Created the light yellow cells which are not locked and contain ",null,null,"the “Properties: Push Button” menu; select the “Tools” tab, "]
[null,null,null,null,"Budgeting is the single most important part of having a successful journey.  Poor budgeting ",null,null,"a formula that the user can overide by entering either another ",null,null,"Select “Forms”, and select “Design Mode” to turn it off. "]
[null,null,null,null,"(planning) can lead to some unpleasant surprises.  The purpose of the Event planner  is NOT ",null,null,"formula or a number."]
[null,null,null,null,"to provide the AC/HC/JT with an all encompassing list.  Rather, it is to provide a memory ",null,null,null,null,"c.   ","Budget Inbound/Outbound Selection macro "]
[null,null,null,null,"jog so one thinks of the possible things they need to plan for.",null,"Journal tab"]
[null,null,null,null,null,null,"1.  ","Middle aligned the text in rows 3 to 76 for better optic when the ",null,"1) ","For Excel – the macro is located on Sheet2(BUDGET)"]
[null,null,null,null,"For example, some of the things that have been forgotten in the past include:",null,null,"comment in a row requires multiple lines."]
[null,null,null,null,"     -forgetting to include taxes",null,"2.  ","Amended the title of column D, E and F",null,"i.","To access this macros, macros must be enabled, right click "]
[null,null,null,null,"     -forgetting to include exchange rates or take into account fluctuating exchange rates",null,"3.  ","Formatted columns I and J, to ease the reconciliation with the bank ",null,null,"on the “BUDGET” tab, and select “View Code”."]
[null,null,null,null,"     -forgetting to include tips for staff",null,null,"statement"]
[null,null,null,null,"     -forgetting to include miscellaneous items like postage/stationary/etc.",null,null,null,null,"ii.","The connection to the macro is related to the name of the "]
[null,null,null,null,null,null,"Event Planner tabs",null,null,null,"macro, in this case, the macro is accessed when the content "]
[null,null,null,null,"Note that cell B1 contains a drop-down list to select either Inbound or Outbound",null,"1.  ","Cell F19 has a formula to get the number of Ambassadors from the ",null,null,"of a cell in the “BUDGET” tab is changed.  Access the "]
[null,null,null,null,null,null,null,"Cell I2 of the Budget worksheet.",null,null,"macro as per c. 1) i. above."]
[null,null,null,"EVENT Planner tabs",null,null,null,null,null,null,"In the left dropdown menu select “Worksheet”, in the right "]
[null,null,null,null,"There are 6 Event Planning tabs.  Use these tabs to plan more complex events such as the ",null,"Outbound Details",null,null,null,"drop down menu, select the type of trigger, in this case "]
[null,null,null,null,"Welcome and Farewell parties. The Event Planners are detailed enough to ensure one captures ",null,"1.  ","Reordered and added more payments and expenses columns",null,null,"“Change” which created the stub into which to write the "]
[null,null,null,null,"all anticipated expenses and revenues. There are blank lines for additional items or one can ",null,"2.  ","Locked the uncoloured cells",null,null,"macro. Since the required actions are to be peformed only"]
[null,null,null,null,"change the description of an unused item.  Place the name of the event in the cell C1. All data ",null,"3.  ","More entries added to Shared cost items (L40 - M51)",null,null,"when the content of cell “B1” is changed, therefore the first "]
[null,null,null,null,"transfers to the Budget worksheet.",null,"4.  ","Corrected the formula of cell M52 to include the first row of Shared ",null,null,"lines of code is to bypass the main body of the code when"]
[null,null,null,null,null,null,null,"cost items as part of the addition.",null,null,"there are no change to the content of cell “B1”."]
[null,null,null,"JOURNAL tab"]
[null,null,null,null,"Once the Budget is completed and approved by the Journey's planning committee, then the next ",null,"2018-06-10 VERSION 4",null,null,"2) ","For LibreOffice Calc – The set of macros for this function  "]
[null,null,null,null,"element is to maintain a Journal of actual receipts and expenditures.  This Journal is similar to ",null,null,null,null,null,"is located in Module1.  "]
[null,null,null,null,"a bank book that records the entries of the journey.  It starts with an opening balance and then ",null,"Instructions tab"]
[null,null,null,null,"one simply adds cheques or deposits to the Journal as they occur.   ",null,"1.  ","Added the description for the new tab Inbound Budget Summary ",null,"i.","To access this set of macros, macros must be enabled, select "]
[null,null,null,null,null,null,null,null,null,null,"the “Tools” tab, select “Macros”, select “Edit Macros”"]
[null,null,null,null,"When completing, it is suggested that the Deposit slips be numbered starting with 101 (to ",null,"Budget tab",null,null,null,"Click on the “+” icon to expand the name of the spreadsheet"]
[null,null,null,null,"difference them from cheque #) and that these numbers be used  in the Journal entry as cross-",null,"1.  ","Added  input field in F2 to enter departure date",null,null,"such as “JT_Financial_Templates_v_5.ods”, click on the "]
[null,null,null,null,"references in the Deposit # column.  If writing a cheque, include the cheque number in the ",null,"2.  ","Amended formulas of cells I6-I14 such that the number of Hosts will ",null,null," “+” icon of “VBAProject”, click on the “+” icon of "]
[null,null,null,null,"cheque number column but also include the invoice/receipt number of the document that ",null,null,"be displayed only when the filled entries of an action planned tab ",null,null," “Modules”, click on the “+” icon of “Module1”, double"]
[null,null,null,null,"supports the payment.  ",null,null,"contain the same number of Hosts",null,null,"click on “Budget_Cell_B1_Content_Change” which is the "]
[null,null,null,null,null,null,"3.  ","Amended formulas of cells J6-J14 such that the total of the Host cost",null,null,"main macro for this function.  Then scroll up to view the "]
[null,null,null,null,"There are two additional columns, an Item column and a Description column: ",null,null,"unit prices will be displayed when the filled entries of an action ",null,null,"global declarations."]
[null,null,null,null,null,null,null,"planned tab contain the same number of Hosts"]
[null,null,null,null,"The Item column is special.  If you look at the bottom of the page under the Journal, you will ",null,"4.  ","Amended formulas of cell M50 to roundup to the next cent the",null,"ii.","The connection of the macro is trough a Calc event, in this "]
[null,null,null,null,"note the column contains the budget descriptions is also called Item.  Whenever one inputs an ",null,null," total Ambassadors' cost divided by the number of Ambassadors",null,null,"case, the macro is accessed when the content of a Budget tab "]
[null,null,null,null,"entry in the Journal, they need to indicate to which budget Item it applies.  The spelling must ",null,"5.  ","Amended formulas of cell M49 to roundup to the next dollar the",null,null,"cell is changed.  "]
[null,null,null,null,"be exact.  This allows a Summary Source and Use of Funds statement to be produced ",null,null,"Ambassador's cost in Canadian dollar divided by the exchange rate",null,null,"To connect the macro to “Change” event of the BUDGET "]
[null,null,null,null,"automatically. An easy way to match the exact spelling is enter the cell such as  \"=C$84\" which ",null,"6.  ","Amended formulas of cell M46 to be the rounded Ambassador's cost ",null,null,"tab, Right click on the Budget tab, select “Sheet Event...”, "]
[null,null,null,null,"means the content of column C row 84 for \"Ambassador Receipts\".",null,null,"multiplied by the number of Ambassadors",null,null,"Scroll down the set of events and select “Content changed”, "]
[null,null,null,null,null,null,"7.  ","Put label on left of input cells for Journey # and arrival/departure ",null,null,"left click on the “Macro...” button, Click on the “+” icon to "]
[null,null,null,null,"The Description column allows one to provide some detail of what the entry represents.",null,null,"dates",null,null,"expand the name of the spreadsheet such as "]
[null,null,null,null,null,null,"8.  ","Added currency conversion area for second outbound hosting",null,null,"“JT_Financial_Templates_v_5.ods”, click on the “+” icon of "]
[null,null,null,null,"There are 75 lines for input which should be sufficient.  Additional lines can be added ",null,"9.  ","Added ability to select currency type for both outbound hostings",null,null," “VBAProject”, click on the “+” icon of “Modules”, click "]
[null,null,null,null,"once the Journal sheet is unprotected (see row 8 above) but one must remember to copy down ",null,null,null,null,null,"on “Module1”, Left click on "]
[null,null,null,null,"the formulas in the Accumulated Total column.",null,"Journal tab",null,null,null,"“Budget_Cell_B1_Content_Change” which is the main "]
[null,null,null,null,null,null,"1.  ","Removed \"FFO Journey Registration Fee\" and ",null,null,"macro for this function.  Then click the “OK” button to exit "]
[null,null,null,null,"At the bottom of the Journal, there is a Summary that adds all numbers according to the Item ",null,null,"\"Assured Space Deposit\" from list of expense items because they are ",null,null,"the “Macro Selector” panel and again to exit the "]
[null,null,null,null,"descriptions typed.  Note however that this only totals Items that the item name agrees with an ",null,null,"income items to be recorded as \"Ambassador Receipts\"",null,null,"“Assign Action” panel."]
[null,null,null,null,"Item name from the Budget.  Therefore, if one types an Item that is not in the Budget (or not ",null,"2.  ","Added 25 extra input lines"]
[null,null,null,null,"spelled the same), it will not add it in the Summary on this tab and it will generate the error ",null,null,null,null,"d.   ","For the Calc version, special instructions on how to rename "]
[null,null,null,null,"message \"ERROR, Item name does not match Budget\", highlighted in red.  If  all Items are ",null,"Event Planner tabs",null,null,null,"each Event Planner worksheet are provided in each Event "]
[null,null,null,null,"typed properly, then the message \"Item names match Budget\" highlighted in green, will be ",null,"1.  ","Replaced \"Ambassador\" for  the event name  in cell G19",null,null,"Planner worksheet."]
[null,null,null,null,"displayed. ",null,"2.  ","Locked cell H19 and amended its formula to subtract from the total "]
[null,null,null,null,null,null,null,"event cost, the Ambassador's cost and the miscellaneous sources of ",null,"e.   ","Note that I made all the changes to the macros, the  button"]
[null,null,null,null,"If it is discovered that an item was missed in the budgetting process, just add the item name in ",null,null,"funds, then dividing the result by the number of ambassadors",null,null,"and the links to the macros using LibreOffice, that is why in "]
[null,null,null,null,"the Budget tab without a budget amount which will result in a \"Item names match Budget\" message.",null,"3.  ","Added two extra Host cost entries to account for up to three cost ",null,null,"the above, I did not provide the instructions for OpenOffice."]
[null,null,null,null,"message.",null,null,"activities attended by Hosts during an event (cells F25-I26)"]
[null,null,null,null,null,null,"4.  "," Cells G24-G26 were unlocked to allow user entry of the "]
[null,null,null,"Outbound Detailed Tracking",null,null,null,"Ambassador's cost item which must match one of the cost items"]
[null,null,null,null,"This tab tracks outbound journey income and expenses associated with each Ambassador.",null,null,"listed in column B, otherwise an error message is displayed"]
[null,null,null,null,"The crosscheck indicate an error resulting in rounding the balance amount to two decimal."]
[null,null,null,null,"If the cross check is less than zero, 0ne cent must be substracted from the balance of one or ",null,"Inbound Budget Report tab"]
[null,null,null,null,"more individual untill the crosscheck reach zero. If rhe crosscheck is greater than zero then the ",null,"1.  ","New tab added to provide concise budget information to present at  "]
[null,null,null,null,"cent must be added.",null,null,"the committee meetings"]
[]
[null,null,null,"Inbound Detailed Tracking",null,null,"Summary-Source and Use of Funds tab"]
[null,null,null,null,"This tab tracks incomes and expenses by individual FFO member signing-up/participating in BUT NOT by",null,"1.  ","Removed \"FFO Journey Registration Fee\" and "]
[null,null,null,null,"the inbound  journey events that are not free of charge; including any subsaequen tcancellations.",null,null,"\"Assured Space Deposit\" from list of expense items because they are "]
[null,null,null,null,null,null,null,"income items accounted as \"Ambassador Receipts\""]
[null,null,null,null,"In row 1, replace \"Event Name\" with the actual event name"]
[null,null,null,null,"In row 2, replace \"Cost/pers.\" with event actual cost per person when known",null,"2018-05-31 VERSION 3B"]
[null,null,null,null,"In row 3-60, enter the participanl's name and the amount paid for each event they participate"]
[null,null,null,null,"In the remark column identify the bank deposit the payment is part.  If an individual makes ",null,"Instructions tab"]
[null,null,null,null," two payments that are part of different bank deposits include the amount for each deposit.",null,"1.  ","Added a note for cell B1 drop-down list"]
[]
[null,null,null,null,"If an individual subsequently cancel from an event and a full amount for an event is refunded ",null,"Budget tab"]
[null,null,null,null,"in accordance with the JT guidelines, indicate the activity(ites) being withdrawn and reference ",null,"1.  ","Moved the critical dates to enable a longer Journey name"]
[null,null,null,null,"the refund cheque; then delete that amount paid from the cancelled activiries.",null,"2.  ","Amended Column A to indicate whether the budget line is "]
[null,null,null,null,null,null,null,"applicable to Inbound, Outbound  or both types of journey"]
[null,null,null,null,"If an individual pays for another person, the paid activity(ies) are marked as if the individual ",null,"3.  ","Amended cell B1 into a drop-down list to choose eiher Inbound or"]
[null,null,null,null,"paid for himself, but indicate in the remark column the amount and who actually made the ",null,null," Outbound. Cells W2-W4 contain the list "]
[null,null,null,null,"payment.",null,"4.  ","Added missing formula in cell E17, H17 & N17"]
[null,null,null,null,null,null,"5.  ","Unlocked cells O15 to O20 for data input"]
[null,null,null,"Inbound Budget Summary",null,null,"6.  ","Amended formula of cells M46, M49, M56 & M59 to round up "]
[null,null,null,null,"This tab provides the budget information in a concise format for presentation at committee ",null,null,"to the nearest dollar."]
[null,null,null,null,"meetings.",null,"7.  ","Switched B30 with B31 to keep B31 and B32 together"]
[null,null,null,null,null,null,"8.  ","Locked  cells C18, C31-C32, D18, D31-D32, F18, F31-F32, G18, "]
[null,null,null,null,"An error will be displayed and the cell selected for:",null,null,"G31-G32, I23-I32, J23-J32, L18, L30-L32, M18, M30-M32, O18 "]
[null,null,null,null,"      a) a budget worksheet without an arrival or departure date, an inbound exchange rate or ",null,null,"and O31-O32 because B18, B31 and B32  budget names are required "]
[null,null,null,null,"          number of Ambassadors; and",null,null,"for journaling purposes only."]
[null,null,null,null,"      b) an event worksheet containing expenses without the event date",null,"9.  ","Deleted the formula from E18-E20, E31-E32, H18, H31-H32, "]
[null,null,null,null,"and the report will abort to allow the user to make the appropriate change.",null,null,"K23-K32 and N18, N30-N32 because associated C & D,  F & G, "]
[null,null,null,null,null,null,null,"I & J and L & M are locked and contain no data "]
[null,null,null,null,"Note For the button initiating the macros to work, macros must be enabled. With the ",null,"10.  ","Frozen pane at C6 such that top and left headers are always in view"]
[null,null,null,null,"Disable macros with notification setting, you get a security alert if there are macros present."]
[null,null,null,null,"This way, you can choose to enable these macros on an as required basis.",null,"Event Planner tabs"]
[null,null,null,null,"Macro settings are located in the Trust Centre under Excel options accessible through the Office Button (top left corner)",null,"1.  ","Amended cell B2 to contain its tab name followed by the "]
[null,null,null,null,"Office Button (top left corner).",null,null,"abbreviated day of the week of the date in cell B1 and the date from "]
[null,null,null,null,null,null,null,"cell B1, if B1 contains a valid date. Otherwise \"Above date is "]
[null,null,null,"SUMMARY-SOURCE AND USE OF FUNDS tab",null,null,null,"invalid\" will be displayed."]
[null,null,null,null,"The Summary-Source and Use of Funds tab generates a report that takes budgeted numbers "]
[null,null,null,null,"from the Budget tab and actual numbers from the Journal tab and consolidates everything into ",null,"Summary-Source and Use of Funds tab"]
[null,null,null,null,"a single Journey Report showing Actual vs Budgets and Variances.  This report is entirely ",null,"1.  ","Corrected the formula of cells E37-E44"]
[null,null,null,null,"formula driven and does not require any input.  "]
[null,null,null,null,null,null,"Outbound Details"]
[null,null,null,null,"If however you are completing the documents by hand, this report will also need to be ",null,"1.  ","Corrected the formula in cells O3-O8"]
[null,null,null,null,"completed.  The objective is to categorize and add up all entries for each category to be ",null,"2.  ","Added the double line below cell O26"]
[null,null,null,null,"compared to the same categories in the budget. ",null,"3.  ","Reformatted the Withdrawal area - Cells D33 - J51"]
[]
[null,null,null,"Own Use Tab",null,null,"Inbound Details"]
[null,null,null,null,"You can add additional tab(s) to track any other details, as required",null,"1.  ","Amended the number format of E3-E71 and B73-I73 to display any "]
[null,null,null,null,null,null,null,"negative numbers in red"]
[null,null,null,"Worksheet Protection"]
[null,null,null,null,"The spreadsheets are protected to prevent accidental changes or erasures of formulas.",null,"2018-05-04 VERSION 3"]
[null,null,null,null,"If required, they can be unprotected for Excel by going to Home/Format/Unprotect Sheet;"]
[null,null,null,null,"for LibreOffice Calc by going to Tools/Protect Sheet…  and ",null,"Instructions tab"]
[null,null,null,null,"for OpenOffice Calc by going to Tools/Protect Document/Sheet…",null,"1.  ","Added section for template versions describing the changes "]
[null,null,null,null,"There are no passwords required.",null,null,"implemented"]
[null,null,null,null,null,null,"2.  ","Reformatted  to one line of text per row"]
[null,null,null,null,"       Excel           ",null,"3.  ","Corrected the explanation of the Journal tab error message"]
[null,null,null,null,null,null,"4.  ","Added the explanation to obtain a crosscheck = 0 for the Outbound "]
[null,null,null,null,null,null,null,"Details tab"]
[]
[null,null,null,null,null,null,"Budget tab"]
[null,null,null,null,"       LibreOffice Calc",null,"1.  ","Amended the background of cell containing instructions to light blue"]
[]
[null,null,null,null,null,null,"Journal tab"]
[null,null,null,null,null,null,"1.  ","Amended the background of cell containing instructions to light blue"]
[null,null,null,null,"       OpenOffice Calc"]
[null,null,null,null,null,null,"Event Planner tabs"]
[null,null,null,null,null,null,"1.  ","Amended the background of cell containing instructions to light blue"]
[]
[null,null,null,null,"Use the same sequence to reprotect the unprotected worksheet:",null,"Outbound Details tab"]
[null,null,null,null,"for Excel by going to Home / Format / Protect Sheet  and click \"OK\"  on the popup dialog;",null,"1.  ","Inserted  Column E for FFI payments"]
[null,null,null,null,"for LibreOffice Calc by going to Tools / Protect Sheet…  and click \"OK\"  on the popup ",null,"2.  ","Renamed Column F for Host program payment"]
[null,null,null,null,"dialog; and",null,"3.  ","Inserted Column L as an extra column for possible other expenses"]
[null,null,null,null,"for OpenOffice Calc by going to Tools / Protect Document / Sheet…  and click \"OK\"  on ",null,"4.  ","Amended the formula of each cells of column M to include the "]
[null,null,null,null,"the popup dialog.",null,null,"added columns E and L"]
[null,null,null,null,null,null,"5.  ","Added the crosscheck and associated formula and explanation of the "]
[null,null,null,null,"       Excel",null,null,"result"]
[]
[null,null,null,null,null,null,"Inbound Details tab"]
[null,null,null,null,null,null,"1.  ","Amended the background of cell containing instructions to light blue"]
[null,null,null,null,null,null,"2.  ","Amended the format to accounting for row 2, columns B through I"]
[null,null,null,null,"       LibreOffice Calc",null,"3.  ","Amended column K to display negative numbers in red"]
[null,null,null,null,null,null,"4.  ","Amended the \"Event Surplus/Deficit\" row to not show an error "]
[null,null,null,null,null,null,null,"when no event data is entered in the column"]
[null,null,null,null,null,null,"5.  ","Added the error \"Row 2, event actual cost/pers. is missing\" when "]
[null,null,null,null,"       OpenOffice Calc",null,null,"event payment is entered but not the actual cost per individual"]
[]
[null,null,null,null,null,null,"2018-04-13 VERSION 2"]
[]
[null,null,null,"Macros Setting",null,null,"Budget Tab"]
[null,null,null,null,null,null,"1.  ","Amended cell B1 to accept the input of the journey type (Inbound "]
[null,null,null,"1.  ","Macros must be enabled for:",null,null,"or Outbound)"]
[null,null,null,"a. ","applicable worksheets to appear  when \"Inbound\" or \"Outbound\" is selected in cell B1 of",null,"2.  ","Amended cell D1 to accept the input of the journey number"]
[null,null,null,null,"the Budget worksheet; and",null,null,"Amended cell B3 to display: Budget for 'journey type from cell B1' "]
[null,null,null,"b. ","the Inbound Budget Report to work",null,null,"Journey # 'journey number from cell D1', 'Club name(s) from cell B2'"]
[null,null,null,null,null,null,"3.  ","Amended cell I1 to accept the input of the journey start date with"]
[null,null,null,"2.  ","The safe way to run macros is to require confirmation before executing them",null,null,"specification in cell I2 on the date format to use"]
[null,null,null,null,"To set up for being able to provide comfirmation to run macros",null,"4.  ","Added calculations of critical dates prior to the start of the journey"]
[null,null,null,"a. ","for Excel by left clicking on the Office button at the top left of the screen, selecting ",null,null,"(60 days, 90 days and 6 months)"]
[null,null,null,null,"Excel Options at the bottom of the scroll down dialog / Trust Centre / ",null,"5.  ","Additional budget items are listed as a reminder"]
[null,null,null,null,"Trust Centre Settings… / Macros Settings / Disable all macros with notification; then ",null,"6.  ","Added for each budjet item an indicator in column A as to the type "]
[null,null,null,null,"click \"OK\" to close the dialog boxes.",null,null,"of journey (Inbound, outbound or both), it applies"]
[null,null,null,null,null,null,"7.  ","Two areas to calculate exchange rate were added, one for sell rate for "]
[null,null,null,null,null,null,null,"inbound journeys and one for buy rate for outbound journeys"]
[]
[null,null,null,null,null,null,"Journal tab"]
[null,null,null,null,null,null,"1.  ","Amended the error message to remove confusion when the the item "]
[null,null,null,null,null,null,null,"name does not match the budget line item name"]
[null,null,null,null,null,null,"2.  ","Added instructions in cell H53 on the steps to take to add extra lines "]
[null,null,null,null,null,null,null,"of journal entry, if required"]
[]
[null,null,null,null,null,null,"Event Planner tabs"]
[null,null,null,null,null,null,"1.  ","Added three additional event planner tabs "]
[null,null,null,null,null,null,"2.  ","Amended cell B1 to accept the entry of the event date"]
[]
[null,null,null,null,null,null,"Outbound Details tab"]
[null,null,null,null,null,null,null,"This is a new tab added to record income and expenses associated "]
[null,null,null,null,null,null,null,"with each ambassador to determine any refund due"]
[]
[null,null,null,null,null,null,"Inbound Details tab"]
[null,null,null,null,null,null,null,"This is a new tab added to record income and expenses associated "]
[null,null,null,"b. ","for LibreOffice Calc by going to Tools / Options… / LibreOffice / Security / ",null,null,"with each FFO member attending journey events with an associated "]
[null,null,null,null,"Macro Security… / Medium; then click \"OK\" to close the dialog boxes.",null,null,"cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"c. ","for OpenOffice Calc by going to Tools / Options… / OpenOffice / Security / "]
[null,null,null,null,"Macro Security… / Medium; then click \"OK\" to close the dialog boxes."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Macros Enabling"]
[null,null,null,"1.  ","Macros must be enabled so that:"]
[null,null,null,"a. ","only the applicable worksheets and the applicable Budget rows will appear  when \"Inbound\" "]
[null,null,null,null,"or \"Outbound\" is selected in cell B1 of the Budget worksheet; and"]
[null,null,null,"b. ","the Inbound Budget Report button will work."]
[]
[null,null,null,"2.  ","Once Macros setting is done, close and reopen the template for the enabling option to appear."]
[]
[null,null,null,"3.  ","Once the macros setting is set for confirmation before executing them, upon opening a "]
[null,null,null,null,"spreadsheet with macros, a dialog box will appear to allow you to enable the macros for that "]
[null,null,null,null,"spreadsheet"]
[null,null,null,"a. ","For Excel, a security warning will appear below the menus, click on Options…, and "]
[null,null,null,null,"select Enable this content and Click \"OK\" to close the dialog box."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"b. ","for LibreOffice Calc, a security warning will appear when you open a file containing macros."]
[null,null,null,null,"select Enable Macros."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"c. ","for OpenOffice Calc, a security warning will appear when you open a file containing macros."]
[null,null,null,null,"select Enable Macros."]

{"sheet":"BUDGET","index":1,"n_rows":66,"n_cols":25,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,7,1,7],[57,11,57,12],[62,11,62,12],[41,1,41,7],[3,12,3,14],[3,6,3,8],[3,3,3,5],[3,9,3,11],[41,8,41,14]]}
[null,"Choose Inbound or Outbound",null,"Journey #: ",41248,"Arrival date: ","2020-02-05","Number of Ambassadors:",null,null,"60 days prior start:  ",{"$f":"IF(ISNUMBER(G1),G1-60,\"\")","v":"2019-12-07"},null,"6 months prior start:  ",{"$f":"IF(ISNUMBER(G1),G1-180,\"\")","v":"2019-08-09"},null,null,null,null,null,null,null,"B1 Drop Down  menu list","K58 & K63 Drop Down menu list","Prev. cell B1 content"]
["Club name: ","FF Saturnalia",null,"Date format: ","dd mmm yyyy","Departure date: ","2020-02-12",null,15,null,"90 days prior start:  ",{"$f":"IF(ISNUMBER(G1),G1-90,\"\")","v":"2019-11-07"},null,null,null,null,null,null,null,null,null,null,"Choose Inbound or Outbound","Click to Select Currency","Choose Inbound or Outbound"]
[null,{"$f":"\"BUDGET for \" & IF(B1 = \"Choose Inbound or Outbound\",\"\",B1& \" \") & \"Journey \" &IF(ISNUMBER(E1),\"# \"&E1& \", \"& B2,\"\")","v":"BUDGET for Journey # 41248, FF Saturnalia"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inbound","American Dollar (USD)"]
[null,null,null,"ESTIMATED EXPENSE BUDGET",null,null,"TO COLLECT FROM AMBASSADORS",null,null,"TO COLLECT FROM HOSTS",null,null,"Miscellaneous Funds",null,null,"Remarks",null,null,null,null,null,null,"Outbound","European Euro (EUR)"]
["Inbound Outbound or both","Item",null,"Qty","Unit Price","Total Cost","Qty","Unit Price","Total Funds from Ambassadors","Qty","Unit Price","Total Funds from Hosts","Qty","Unit Price","Total Misc. Funds",null,null,null,null,null,null,null,null,"New Zealand Dollar (NZD)"]
["Inbound",{"$f":"Welcome!G19","v":"Welcome"},null,null,null,{"$f":"IF(Welcome!N$21>0,Welcome!N$21,\"\")","v":498.88},{"$f":"IF(Welcome!H$19>0,Welcome!F$19,\" \")","v":15},{"$f":"IF(Welcome!H$19>0,Welcome!H$19,\" \")","v":23.925333333333334},{"$f":"IF(Welcome!N$7>0,Welcome!N$7,\"\")","v":358.88},null,null,{"$f":"IF(Welcome!N$8>0,Welcome!N$8,\"\")","v":140},null,null,{"$f":"IF(Welcome!N$9>0,Welcome!N$9,\"\")","v":""},null,null,null,null,null,null,null,null,"Australian Dollar (AUD)"]
["Inbound",{"$f":"'Escapade Eskimo'!G19","v":"Escapade Eskimo"},null,null,null,{"$f":"IF('Escapade Eskimo'!N$21>0,'Escapade Eskimo'!N$21,\"\")","v":1555},{"$f":"IF('Escapade Eskimo'!H$19>0,'Escapade Eskimo'!F$19,\" \")","v":15},{"$f":"IF('Escapade Eskimo'!H$19>0,'Escapade Eskimo'!H$19,\" \")","v":85.333333333333329},{"$f":"IF('Escapade Eskimo'!N$7>0,'Escapade Eskimo'!N$7,\"\")","v":1280},null,null,{"$f":"IF('Escapade Eskimo'!N$8>0,'Escapade Eskimo'!N$8,\"\")","v":275},null,null,{"$f":"IF('Museum of History'!N$9>0,'Museum of History'!N$9,\"\")","v":""}]
["Inbound",{"$f":"'Museum of History'!G19","v":"Museum of History"},null,null,null,{"$f":"IF('Museum of History'!N$21>0,'Museum of History'!N$21,\"\")","v":675},{"$f":"IF('Museum of History'!H$19>0,'Museum of History'!F$19,\" \")","v":15},{"$f":"IF('Museum of History'!H$19>0,'Museum of History'!H$19,\" \")","v":38.666666666666664},{"$f":"IF('Museum of History'!N$7>0,'Museum of History'!N$7,\"\")","v":580},null,null,{"$f":"IF('Museum of History'!N$8>0,'Museum of History'!N$8,\"\")","v":95},null,null,{"$f":"IF('Curling-Ice fishing'!N$9>0,'Curling-Ice fishing'!N$9,\"\")","v":""}]
["Inbound",{"$f":"'Curling-Ice fishing'!G19","v":"Curling-Ice fishing"},null,null,null,{"$f":"IF('Curling-Ice fishing'!N$21>0,'Curling-Ice fishing'!N$21,\"\")","v":550.98},{"$f":"IF('Curling-Ice fishing'!H$19>0,'Curling-Ice fishing'!F$19,\" \")","v":15},{"$f":"IF('Curling-Ice fishing'!H$19>0,'Curling-Ice fishing'!H$19,\" \")","v":35.532000000000004},{"$f":"IF('Curling-Ice fishing'!N$7>0,'Curling-Ice fishing'!N$7,\"\")","v":532.98},null,null,{"$f":"IF('Curling-Ice fishing'!N$8>0,'Curling-Ice fishing'!N$8,\"\")","v":18},null,null,{"$f":"IF(Winterlude!N$9>0,Winterlude!N$9,\"\")","v":""}]
["Inbound",{"$f":"Winterlude!G19","v":"Winterlude"},null,null,null,{"$f":"IF(Winterlude!N$21>0,Winterlude!N$21,\"\")","v":150},{"$f":"IF(Winterlude!H$19>0,Winterlude!F$19,\" \")","v":15},{"$f":"IF(Winterlude!H$19>0,Winterlude!H$19,\" \")","v":10},{"$f":"IF(Winterlude!N$7>0,Winterlude!N$7,\"\")","v":150},null,null,{"$f":"IF(Winterlude!N$8>0,Winterlude!N$8,\"\")","v":""},null,null,{"$f":"IF('Omega Park'!N$9>0,'Omega Park'!N$9,\"\")","v":""}]
["Inbound",{"$f":"'Omega Park'!G19","v":"Omega Park"},null,null,null,{"$f":"IF('Omega Park'!N$21>0,'Omega Park'!N$21,\"\")","v":1527},{"$f":"IF('Omega Park'!H$19>0,'Omega Park'!F$19,\" \")","v":15},{"$f":"IF('Omega Park'!H$19>0,'Omega Park'!H$19,\" \")","v":91.666666666666671},{"$f":"IF('Omega Park'!N$7>0,'Omega Park'!N$7,\"\")","v":1375},null,null,{"$f":"IF('Omega Park'!N$8>0,'Omega Park'!N$8,\"\")","v":152},null,null,{"$f":"IF(Parliament!N$9>0,Parliament!N$9,\"\")","v":""}]
["Inbound",{"$f":"Parliament!G19","v":"Parliament"},null,null,null,{"$f":"IF(Parliament!N$21>0,Parliament!N$21,\"\")","v":150},{"$f":"IF(Parliament!H$19>0,Parliament!F$19,\" \")","v":15},{"$f":"IF(Parliament!H$19>0,Parliament!H$19,\" \")","v":10},{"$f":"IF(Parliament!N$7>0,Parliament!N$7,\"\")","v":150},null,null,{"$f":"IF(Parliament!N$8>0,Parliament!N$8,\"\")","v":""},null,null,{"$f":"IF('Event 8'!N$9>0,'Event 8'!N$9,\"\")","v":""}]
["Inbound",{"$f":"'Event 8'!G19","v":"Event 8"},null,null,null,{"$f":"IF('Event 8'!N$21>0,'Event 8'!N$21,\"\")","v":""},{"$f":"IF('Event 8'!H$19>0,'Event 8'!F$19,\" \")","v":" "},{"$f":"IF('Event 8'!H$19>0,'Event 8'!H$19,\" \")","v":" "},{"$f":"IF('Event 8'!N$7>0,'Event 8'!N$7,\"\")","v":""},{"$f":"IF('Event 8'!F$24>0,IF('Event 8'!F$28>0,IF('Event 8'!F$24='Event 8'!F$28,IF('Event 8'!F$29>0,IF('Event 8'!F$24='Event 8'!F$29,'Event 8'!F$24,\"\"),'Event 8'!F$24),\"\"),'Event 8'!F$24),\"\")","v":""},{"$f":"IF('Event 8'!F$24>0,IF('Event 8'!F$28>0,IF('Event 8'!F$24='Event 8'!F$28,IF('Event 8'!F$29>0,IF('Event 8'!F$24='Event 8'!F$29,'Event 8'!H$24+'Event 8'!H$28+'Event 8'!H$29,\"\"),'Event 8'!H$24+'Event 8'!H$28),\"\"),'Event 8'!H$24),\"\")","v":""},{"$f":"IF('Event 8'!N$8>0,'Event 8'!N$8,\"\")","v":""},null,null,{"$f":"IF(Farewell!N$9>0,Farewell!N$9,\"\")","v":""}]
["Inbound",{"$f":"Farewell!G19","v":"Farewell"},null,null,null,{"$f":"IF(Farewell!N$21>0,Farewell!N$21,\"\")","v":1200},{"$f":"IF(Farewell!H$19>0,Farewell!F$19,\" \")","v":15},{"$f":"IF(Farewell!H$19>0,Farewell!H$19,\" \")","v":40},{"$f":"IF(Farewell!N$7>0,Farewell!N$7,\"\")","v":600},{"$f":"IF(Farewell!F$24>0,IF(Farewell!F$28>0,IF(Farewell!F$24=Farewell!F$28,IF(Farewell!F$29>0,IF(Farewell!F$24=Farewell!F$29,Farewell!F$24,\"\"),Farewell!F$24),\"\"),Farewell!F$24),\"\")","v":15},{"$f":"IF(Farewell!F$24>0,IF(Farewell!F$28>0,IF(Farewell!F$24=Farewell!F$28,IF(Farewell!F$29>0,IF(Farewell!F$24=Farewell!F$29,Farewell!H$24+Farewell!H$28+Farewell!H$29,\"\"),Farewell!H$24+Farewell!H$28),\"\"),Farewell!H$24),\"\")","v":40},{"$f":"IF(Farewell!N$8>0,Farewell!N$8,\"\")","v":600},null,null,{"$f":"IF('Escapade Eskimo'!N$9>0,'Escapade Eskimo'!N$9,\"\")","v":""},null,null,null,null,null,null,null,null,"UK Pound Sterling (GBP)"]
["Inbound","Gift Bags",null,{"$f":"IF(E15 > 0,I2,\"\")","v":15},8,{"$f":"IF(ISNUMBER(D15),IF(ISNUMBER(E15),E15*D15,\"\"),\"\")","v":120},{"$f":"IF(D15 > 0,D15,\"\")","v":15},{"$f":"IF(E15 > 0,E15,\"\")","v":8},{"$f":"IF(ISNUMBER(G15),IF(ISNUMBER(H15),H15*G15,\"\"),\"\")","v":120},null,null,{"$f":"\"\"","v":""},null,null,{"$f":"IF(ISNUMBER(M15),IF(ISNUMBER(N15),N15*M15,\"\"),\"\")","v":""}]
["Inbound","Photographs",null,null,null,{"$f":"IF(ISNUMBER(D16),IF(ISNUMBER(E16),E16*D16,\"\"),\"\")","v":""},{"$f":"IF(D16 > 0,D16,\"\")","v":""},{"$f":"IF(E16 > 0,E16,\"\")","v":""},{"$f":"IF(ISNUMBER(G16),IF(ISNUMBER(H16),H16*G16,\"\"),\"\")","v":""},null,null,{"$f":"\"\"","v":""},null,null,{"$f":"IF(ISNUMBER(M16),IF(ISNUMBER(N16),N16*M16,\"\"),\"\")","v":""}]
["Inbound","Parking",null,null,null,{"$f":"IF(ISNUMBER(D17),IF(ISNUMBER(E17),E17*D17,\"\"),\"\")","v":""},{"$f":"IF(D17 > 0,D17,\"\")","v":""},"",{"$f":"IF(ISNUMBER(G17),IF(ISNUMBER(H17),H17*G17,\"\"),\"\")","v":""},null,null,{"$f":"\"\"","v":""},null,null,{"$f":"IF(ISNUMBER(M17),IF(ISNUMBER(N17),N17*M17,\"\"),\"\")","v":""}]
["Inbound","Host Refund",null,null,null,"",null,null,null,null,null,{"$f":"\"\"","v":""},null,null,{"$f":"\"\"","v":""},"Item name required for journaling purposes only"]
["Outbound","Ambassador Receipts",null,null,null,{"$f":"\"\"","v":""},{"$f":"IF(B1=\"Outbound\",IF(I2>0,I2,\"\"),\"\")","v":""},35,{"$f":"IF(ISNUMBER(G19),IF(ISNUMBER(H19),H19*G19,\"\"),\"\")","v":""},null,null,{"$f":"\"\"","v":""},null,null,{"$f":"\"\"","v":""},"FFO Journey Registration Fee"]
["Outbound","Ambassador Receipts",null,null,null,{"$f":"\" \"","v":" "},null,300,"",null,null,{"$f":"\"\"","v":""},null,null,{"$f":"\"\"","v":""},"FFO Assured Space Deposit"]
["Outbound","FFI Fees",null,{"$f":"IF(E21 > 0,I2,\"\")","v":""},null,{"$f":"IF(ISNUMBER(D21),IF(ISNUMBER(E21),E21*D21,\"\"),\"\")","v":""},{"$f":"IF(D21 > 0,D21,\"\")","v":""},"","",null,null,{"$f":"\"\"","v":""},null,null,{"$f":"IF(ISNUMBER(M21),IF(ISNUMBER(N21),N21*M21,\"\"),\"\")","v":""}]
["Outbound","Hosting Fees",null,{"$f":"IF(E22 > 0,I2,\"\")","v":""},null,"","","","",null,null,{"$f":"\"\"","v":""},null,null,""]
["Outbound","Post Journey Party",null,null,null,"",null,null,"",null,null,{"$f":"\"\"","v":""},null,null,""]
["Both","Wire Transfer Fee",null,1,14,14,{"$f":"IF(B$1 <> \"Outbound\",IF(D24 > 0,D24,\"\"),\"\")","v":1},{"$f":"IF(G24 <>\"\",E24,\"\")","v":14},14,null,null,{"$f":"\"\"","v":""},null,null,""]
["Both","Ambassador Booklets",null,{"$f":"IF(E25 > 0,I2,\"\")","v":15},2.5,37.5,{"$f":"IF(B$1 <> \"Outbound\",IF(D25 > 0,D25,\"\"),\"\")","v":15},2.5,37.5,null,null,{"$f":"\"\"","v":""},null,null,""]
["Both","Host Booklets",null,null,null,"",null,null,"",{"$f":"IF($B$1=\"Inbound\",IF(D26 > 0,D26,\"\"),\"\")","v":""},{"$f":"IF(J26<>\"\",E26,\"\")","v":""},{"$f":"IF(ISNUMBER(J26),IF(ISNUMBER(K26),K26*J26,\"\"),\"\")","v":""},null,null,""]
["Both","Club Gift",null,1,15,15,{"$f":"IF(B$1 <> \"Outbound\",IF(D27 > 0,D27,\"\"),\"\")","v":1},15,15,null,null,{"$f":"\"\"","v":""},null,null,""]
["Both","Bank Fees",null,5,2.5,12.5,5,2.5,12.5,null,null,{"$f":"\"\"","v":""},null,null,""]
["Both","Committee Expenses",null,null,null,"","","","",null,null,{"$f":"\"\"","v":""},null,null,""]
["Both","Contingency",null,{"$f":"IF(E30 > 0,I2,\"\")","v":15},10,150,15,10,150,null,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,{"$f":"\"\"","v":""}]
["Both","Ambassador Refund",null,null,null,{"$f":"\"\"","v":""},null,null,{"$f":"\"\"","v":""},null,null,{"$f":"\"\"","v":""},null,null,{"$f":"\"\"","v":""},"Item name required for journaling purposes only"]
["Both","Surplus to FFO",null,null,null,{"$f":"\"\"","v":""},null,null,{"$f":"\"\"","v":""},null,null,{"$f":"\"\"","v":""},null,null,{"$f":"\"\"","v":""},"Item name required for journaling purposes only"]
[null,"Memory Stick",null,{"$f":"I2","v":15},2,{"$f":"IF(ISNUMBER(D33),IF(ISNUMBER(E33),E33*D33,\"\"),\"\")","v":30},{"$f":"IF(B$1 <> \"Outbound\",IF(D33 > 0,D33,\"\"),\"\")","v":15},{"$f":"IF(G33 <>\"\",E33,\"\")","v":2},{"$f":"IF(ISNUMBER(G33),IF(ISNUMBER(H33),H33*G33,\"\"),\"\")","v":30},null,null,{"$f":"IF(ISNUMBER(J33),IF(ISNUMBER(K33),K33*J33,\"\"),\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(M33),IF(ISNUMBER(N33),N33*M33,\"\"),\"\")","v":""}]
[null,"Exp blank 2",null,null,null,"","","","",null,null,"",null,null,""]
[null,"Exp blank 3",null,null,null,"","","","",null,null,"",null,null,""]
[null,"Exp blank 4",null,null,null,"","","","",null,null,"",null,null,""]
[null,"Exp blank 5",null,null,null,"","","","",null,null,"",null,null,""]
[null,"Exp blank 6",null,null,null,"","","","",null,null,"",null,null,""]
[null,"Exp blank 7",null,null,null,"","","","",null,null,"",null,null,""]
[null,"TOTALS",null,null,null,{"$f":"SUM(F6:F39)","v":6685.8600000000006},null,null,{"$f":"SUM(I6:I39)","v":5405.8600000000006},null,null,{"$f":"SUM(L6:L39)","v":1280},null,null,{"$f":"SUM(O6:O39)","v":0}]
[]
[null,{"$f":"+B3","v":"BUDGET for Journey # 41248, FF Saturnalia"},null,null,null,null,null,null,"Exchange Rate Conversion"]
[null,null,null,"Source of Funds"]
[null,null,null,null,"     Ambassador Receipts",{"$f":"+I40","v":5405.8600000000006},null,null,"Inbound"]
[null,null,null,null,"     Host Receipts",{"$f":"+L40","v":1280},null,null,null,null,"USD buy exchange rate: ",1.3548,{"$f":"IF(ISNUMBER(L45),IF(B1<>\"Inbound\",\"Error - Journey type not Inbound in B1\",\"\"),\"\")","v":"Error - Journey type not Inbound in B1"}]
[null,null,null,null,"     Miscellaneous Receipts",{"$f":"+O40","v":0},null,null,null,null,null,null,"Ambassador's fee in USD @ the above exchange rate: ",{"$f":"IF(ISNUMBER(L48),IF(ISNUMBER(N49),N49*L48,\"\"),\"\")","v":4005}]
[null,null,null,null,"Total Source of Funds",{"$f":"SUM(F44:F46)","v":6685.8600000000006}]
[null,null,null,null,null,null,null,null,null,null,"Number of Ambassadors: ",{"$f":"IF(L45 > 0,I2,\"\")","v":15}]
[null,null,null,null,"Total Expenses",{"$f":"+F40","v":6685.8600000000006},null,null,null,null,null,null,"USD Cost/Ambassador (rounded to the next dollar): ",{"$f":"IF(ISNUMBER(L45),IF(ISNUMBER(N50),ROUNDUP(N50/L45,0),\"\"),\"\")","v":267}]
[null,null,null,null,null,null,null,null,null,null,null,null,"CAD Cost/Ambassador: ",{"$f":"IF(ISNUMBER(L48),ROUNDUP(I40/L48,2),\"\")","v":360.4}]
[null,null,null,null,"Net Surplus / (Deficit)",{"$f":"+F47-F49","v":0}]
[]
[null,null,null,null,null,null,null,null,"Outbound"]
[null,null,null,null,null,null,null,null,null,null,"USD sell exchange rate: ",null,{"$f":"IF(ISNUMBER(L54),IF(B1<>\"Outbound\",\"Error - Journey type not Outbound in B1\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Individual FFI Fee amount (USD): "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Individual FFI Fee (CAD) @ the above exchange rate: ",{"$f":"IF(ISNUMBER(L55),IF(ISNUMBER(L54),ROUNDUP(L55*L54,0),\"\"),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"1st Journey - Requested Currency: ","Click to Select Currency"]
[null,null,null,null,null,null,null,null,null,null,"      sell exchange rate: ",null,{"$f":"IF(ISNUMBER(L59),IF(B1<>\"Outbound\",\"Error - Journey type not Outbound in B1\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Individual Hosting Fee amount \" & RIGHT(L58,5) & \":\"","v":"Individual Hosting Fee amount rency:"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hosting Fee (CAD) @ the above exchange rate: ",{"$f":"IF(ISNUMBER(L60),IF(ISNUMBER(L59),ROUNDUP(L60*L59,0),\"\"),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"2nd Journey - Requested Currency: ","Click to Select Currency"]
[null,null,null,null,null,null,null,null,null,null,"      sell exchange rate: ",null,{"$f":"IF(ISNUMBER(L64),IF(B1<>\"Outbound\",\"Error - Journey type not Outbound in B1\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Individual Hosting Fee amount \" & RIGHT(L63,5) & \":\"","v":"Individual Hosting Fee amount rency:"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hosting Fee (CAD) @ the above exchange rate: ",{"$f":"IF(ISNUMBER(L65),IF(ISNUMBER(L64),ROUNDUP(L65*L64,0),\"\"),\"\")","v":""}]

{"sheet":"Journal","index":2,"n_rows":119,"n_cols":10,"rows_kept":119,"cut":false,"hidden":false,"merged":[[0,8,0,9]]}
["JOURNAL",null,{"$f":"IF(ROUND(F119-F77,2)=0,\"Item names match Budget\",\"ERROR, Item name does not match Budget\")","v":"Item names match Budget"},null,null,null,null,null,"Bank Reconciliation"]
["Date","chq # Deposit #","Item\n(exactly as typed in Budget otherwise ERROR)","Deposit","Withdrawal","Balance","Receipt #","Description","If item is in bank Statement","Bank\nBalance"]
["2019-12-01",null,"Opening Balance",null,null,0,null,null,"Enter \"y\" ",{"$f":"F3","v":0}]
["2019-12-01","Dep 01","Host Receipts",1280,null,{"$f":"ROUND(+F3+D4-E4,2)","v":1280},null,"Payment from the 15 hosts participating in the events","y",{"$f":"IF(UPPER(I4)=\"Y\",ROUND(J3+D4-E4,2),J3)","v":1280}]
["2019-12-07","WT 01","Ambassador Receipts",5285.8,null,{"$f":"ROUND(+F4+D5-E5,2)","v":6565.8},1,"Ambassador's hosting fee $4005 USD @ 1.3198","y",{"$f":"IF(UPPER(I5)=\"Y\",ROUND(J4+D5-E5,2),J4)","v":6565.8}]
["2019-12-07","WT 01","Wire Transfer Fee",null,14,6551.8,1,null,"y",6551.8]
["2019-12-15","CK 01","Escapade Eskimo",null,200,6351.8,2,"Deposit Payment to Eskim Inc.","y",6351.8]
["2019-12-31","SC","Bank Fees",null,2.5,6349.3,null,null,"y",6349.3]
["2020-01-17","CK 02","Ambassador Booklets",null,49.18,6300.12,3,"Translation Cost $8.50 and printing cost $40.68 paid to CL","y",6300.12]
["2020-01-17","CK 03","Farewell",null,250,6050.12,4,"Deposit Payment to John's Golf Club","y",6050.12]
["2019-01-31","SC","Bank Fees",null,2.5,6047.62,null,null,"y",6047.62]
["2020-02-04","WD 01","Winterlude",null,150,5897.62,null,"Lunch Money $10 per Ambassador","y",5897.62]
["2020-02-04","WD 01","Museum of History",null,150,5747.62,null,"Lunch Money $10 per Ambassador","y",5747.62]
["2020-02-04","WD 01","Curling-Ice Fishing",null,225,5522.62,null,"Lunch Money $15 per Ambassador","y",5522.62]
["2020-02-04","WD 01","Parliament",null,150,5372.62,null,"Lunch Money $10 per Ambassador","y",5372.62]
["2020-02-04","WD 01","Museum of History",null,75,5297.62,null,"15 donation @ $5 participants to Nunavut Sivuniksavut","y",5297.62]
["2020-02-04","WD 01","Escapade Eskimo",null,30,5267.62,null,"Bus Driver Tips 15 @ $2","y",5267.62]
["2020-02-04","WD 01","Omega Park",null,30,5237.62,null,"Bus Driver Tips 15 @ $2","y",5237.62]
["2020-02-06","CK 04","Welcome",null,348.89,4888.7299999999996,5,"Lunch $308 + Tips $40.89 to Jim's Catering","y",4888.7299999999996]
["2020-02-06","CK 05","Welcome",null,100,4788.7299999999996,6,"Hall rental to God's Church","y",4788.7299999999996]
["2020-02-06","CK 06","Welcome",null,50,4738.7299999999996,6,"God's Church Caretaker services to George Teboul","y",4738.7299999999996]
["2020-02-06","CK 07","Club Gift",null,18.32,4720.41,7,"To HC","y",4720.41]
["2020-02-07","CK 08","Escapade Eskimo",null,425,4295.41,8,"Bus cost to Lemieux Transport Inc.","y",4295.41]
["2020-02-07","CK 09","Escapade Eskimo",null,704,3591.41,9,"Day Activities 19 @ $45.20 - deposit, to Eskim Inc ","y",3591.41]
["2020-02-09","CK 10","Curling-Ice Fishing",null,254.25,3337.16,10,"Ice Sheet rental to Cumberland Curling Ass.","y",3337.16]
["2020-02-09","CK 11","Curling-Ice Fishing",null,72.72,3264.44,11,"3 Bottles of Caribou @ 21.45 + tax to NH9","y",3264.44]
["2020-02-09","CK 12","Museum of History",null,10,3254.44,12,"To D2H3 for parking","y",3254.44]
["2020-02-09","CK 13","Memory Stick",null,22.6,3231.84,13,"To CL","y",3231.84]
["2020-02-09","CK 13","Gift Bags",null,138.75,3093.09,14,"To CL","y",3093.09]
["2020-02-09","CK 14","Museum of History",null,382.40000000000003,2710.69,15,"Museum entrance 20 @ $16 & guide 20 @ $3.12 to HC","y",2710.69]
["2020-02-09","CK 14","Museum of History",null,10,2700.69,16,"To HC for parking","y",2700.69]
["2020-02-11","CK 15","Omega Park",null,419.91999999999996,2280.77,17,"Entrance Fee 19 @ $15.70 + tax & Guide $72 + tax to Parc  Omega Inc.","y",2280.77]
["2020-02-11","CK 16","Omega Park",null,700,1580.77,18,"Bus cost to Lemieux Transport Inc.","y",1580.77]
["2020-02-11","CK 17","Omega Park",null,380,1200.77,19,"Lunch 19 @ $20.00  to NH5","y",1200.77]
["2020-02-12","CK 18","Escapade Eskimo",null,192.1,1008.67,20,"Lunch 20 @ $8.50 + tax to HL","y",1008.67]
["2020-02-12","CK 18","Museum of History",null,10,998.67,21,"To HL for parking","y",998.67]
["2020-02-12","CK 19","Museum of History",null,10,988.67,22,"To NH6 for parking","y",988.67]
["2020-02-12","CK 20","Museum of History",null,10,978.67,23,"To NH10 for parking","y",978.67]
["2020-02-12","CK 21","Museum of History",null,10,968.67,24,"To D2H7 for parking","y",968.67]
["2020-02-12","CK 22","Museum of History",null,10,958.67,25,"To DH8 for parking","y",958.67]
["2020-02-12","CK 23","Farewell",null,950,8.67,26,"Farewell Dinner 30 @ $ 40 - deposit, to John's Golf Course","y",8.67]
["2020-02-29","CK 24","Committee Expenses",null,2,6.67,27,"To Self, for envelope & stamp 2 @ $0.10 + $0.90 for both deposit payments","y",6.67]
["2020-02-29","CK 25","Surplus to FFO",null,1.67,5,null,null,"y",5]
["2020-02-29","SC","Bank Fees",null,2.5,2.5,null,null,"y",2.5]
["2020-03-15","SC","Bank Fees",null,2.5,0,null,null,"y",0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"ROUND(+F68+D69-E69,2)","v":0},null,null,null,{"$f":"IF(UPPER(I69)=\"Y\",ROUND(J68+D69-E69,2),J68)","v":0}]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,"Insert required number of lines above this line*"]
["2020-03-15",null,null,"Closing Balance",null,{"$f":"+F75","v":0}]
[null,null,null,"less opening Balance",null,{"$f":"F3","v":0},null,"* if you insert one or more lines, do not forget to copy the formula"]
[null,null,null,"Net Surplus/Deficit",null,{"$f":"+F77-F78","v":0},null,"in column \"F\" above the added lines and paste it into column\"F\""]
[null,null,null,null,null,null,null,"on the added line(s) and also in the line below the added line(s)."]
[null,null,null,null,null,null,null,"You must unprotect the worksheet to amend colimn F"]
[null,null,"Item (from Budget)",{"$f":"+D2","v":"Deposit"},{"$f":"+E2","v":"Withdrawal"},{"$f":"+F2","v":"Balance"}]
[null,null,{"$f":"+C3","v":"Opening Balance"},null,null,{"$f":"F3","v":0}]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C4","v":"Ambassador Receipts"},{"$f":"SUMIF($C$3:$C$76,C84,$D$3:$D$76)","v":5285.8},{"$f":"SUMIF($C$3:$C$76,C84,$E$3:$E$76)","v":0},{"$f":"D84-E84","v":5285.8}]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C5","v":"Host Receipts"},1280,0,1280]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C6","v":"Miscellaneous Receipts"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C11","v":"Welcome"},0,498.89,-498.89]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C12","v":"Escapade Eskimo"},0,1551.1,-1551.1]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C13","v":"Museum of History"},0,677.40000000000009,-677.40000000000009]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C14","v":"Curling-Ice fishing"},0,551.97,-551.97]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C15","v":"Winterlude"},0,150,-150]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C16","v":"Omega Park"},0,1529.92,-1529.92]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C17","v":"Parliament"},0,150,-150]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C18","v":"Event 8"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C19","v":"Farewell"},0,1200,-1200]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C20","v":"Gift Bags"},0,138.75,-138.75]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C21","v":"Photographs"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C22","v":"Parking"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C23","v":"Host Refund"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C24","v":"FFI Fees"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C25","v":"Hosting Fees"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C26","v":"Post Journey Party"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C27","v":"Wire Transfer Fee"},0,14,-14]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C28","v":"Ambassador Booklets"},0,49.18,-49.18]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C29","v":"Host Booklets"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C30","v":"Club Gift"},0,18.32,-18.32]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C31","v":"Bank Fees"},0,10,-10]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C32","v":"Committee Expenses"},0,2,-2]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C33","v":"Contingency"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C34","v":"Ambassador Refund"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C35","v":"Surplus to FFO"},0,1.67,-1.67]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C36","v":"Memory Stick"},0,22.6,-22.6]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C37","v":"Exp blank 2"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C38","v":"Exp blank 3"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C39","v":"Exp blank 4"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C40","v":"Exp blank 5"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C41","v":"Exp blank 6"},0,0,0]
[null,null,{"$f":"'SUMMARY-SOURCE & USE OF FUNDS'!C42","v":"Exp blank 7"},0,0,0]
[null,null,null,null,null,{"$f":"ROUND(SUM(F83:F118),2)","v":0}]

{"sheet":"Outbound Details","index":3,"n_rows":57,"n_cols":21,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,19,1,19],[0,20,1,20],[0,2,0,7],[0,9,0,17],[0,0,1,0],[0,1,1,1],[0,18,1,18],[56,3,56,4],[56,5,56,9],[53,3,53,4],[53,5,53,9],[54,3,54,4],[54,5,54,9],[55,3,55,4],[55,5,55,9],[50,3,50,4],[50,5,50,9],[51,3,51,4],[51,5,51,9],[52,3,52,4],[52,5,52,9],[47,3,47,4],[47,5,47,9],[48,3,48,4],[48,5,48,9],[49,3,49,4],[49,5,49,9],[38,3,38,4],[38,5,38,9],[39,3,39,4],[39,5,39,9],[40,3,40,4],[40,5,40,9],[41,3,41,4],[41,5,41,9],[42,3,42,4],[42,5,42,9],[43,3,43,4],[43,5,43,9],[44,3,44,4],[44,5,44,9],[45,3,45,4],[45,5,45,9],[46,3,46,4],[46,5,46,9],[38,11,38,13],[39,11,39,12],[40,11,40,12],[41,11,41,12],[42,11,42,12],[50,11,50,12],[51,11,51,12],[43,11,43,12],[46,11,46,12],[47,11,47,12],[48,11,48,12],[49,11,49,12],[44,11,44,12],[45,11,45,12]]}
["Ambassador #","Ambassador Name\n(Assured Seat)","Payments",null,null,null,null,null,null,"Expenses",null,null,null,null,null,null,null,null,"Balance","Exchange rate","Comments"]
[null,null,"Journey Registration Fee","Assured Space Deposit","FFI Fee $Cdn ","Host 1 Program Fee $Cdn ","Host 2 Program Fee $Cdn ",null,"FFI Fee $Cdn ","Host 1 Program Fee $Cdn ","Host 2 Program Fee $Cdn ",null,null,null,null,"Shared cost Items","Transfer to FFO","Refund"]
[1,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(C3:H3),2)-ROUND(SUM(I3:R3),2)","v":0}]
[2,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(C4:H4),2)-ROUND(SUM(I4:R4),2)","v":0}]
[3,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[5,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[7,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[8,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[9,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[10,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[11,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[12,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[14,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[15,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[16,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[17,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[18,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[19,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[20,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[21,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[22,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[23,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[25,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[26,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[27,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[28,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[29,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[30,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(C32:H32),2)-ROUND(SUM(I32:R32),2)","v":0}]
[null,"Totals in $CAD",{"$f":"SUM(C3:C32)","v":0},{"$f":"SUM(D3:D32)","v":0},0,0,0,{"$f":"SUM(H3:H32)","v":0},{"$f":"SUM(I3:I32)","v":0},{"$f":"SUM(J3:J32)","v":0},{"$f":"SUM(K3:K32)","v":0},0,0,0,0,0,0,{"$f":"SUM(R3:R32)","v":0},{"$f":"SUM(S3:S32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crosscheck:  ",{"$f":"ROUND(SUM(C33:H33),2)-ROUND(SUM(I33:R33),2)","v":0},"Crosscheck must be zero, otherwiseadjustment of $0.01 needed "]
[null,"Total $CAD. Funds Due     ",{"$f":"SUM(I33:R33)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"to the an expense amount of the required number of Ambassador. "]
[null,"Total $CAD. Funds Paid     ",{"$f":"SUM(C33:H33)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If the crosscheck amount greater than 0, then subtract $0.01; or "]
[null," Balance due     ",{"$f":"ROUND(C36-C35,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"if the crosscheck is less than 0, then add $0.01"]
[]
[null,"Waiting list",null,"Date",null,"Withdrawals",null,null,null,null,null,"Shared cost items"]
[{"$f":"INDIRECT(\"A\"&ROW()-1)+1","v":1},null,null,null,null,"Jane Doe replaced by Joe Schnuck"]
[{"$f":"INDIRECT(\"A\"&ROW()-1)+1","v":2}]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13,null,null,null,null,null,null,null,null,null,null,"Total   ","Total",{"$f":"SUM(N40:N51)","v":0}]
[14]
[15]
[16]
[17]
[18]

{"sheet":"Inbound Details","index":4,"n_rows":77,"n_cols":13,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,10,1,10],[0,11,1,11],[0,12,1,12],[73,4,73,6],[73,1,73,3],[74,2,74,4],[75,3,75,5],[74,5,74,7],[73,7,73,9],[74,8,74,10],[75,6,75,8],[75,9,75,11]]}
["Participant's Name","Welcome","Escapade Eskimo","Museum of History","Curling\nIce Fishing","Omega Park","Event name","Event name","Event name","Farewell","Total paid","Balance","Remarks"]
["(See instructions in L71)",13.96,54.81,19.12,2,37.803799999999995,"Cost/Pers.","Cost/Pers.","Cost/Pers.",40]
["HC",14,0,19,2,0,0,0,0,40,{"$f":"SUM(B3:J3)","v":75},{"$f":"ROUND(K3-SUMIF(B3:J3,\">0\",B$2:J$2),2)","v":-0.08}]
["Self",14,0,0,2,0,0,0,0,40,{"$f":"SUM(B4:J4)","v":56},0.04]
["NH3",14,0,0,2,0,0,0,0,40,56,0.04]
["HL",0,55,19,0,0,0,0,0,40,114,7.0000000000000007E-2]
["NH5",14,0,0,2,38,0,0,0,40,94,0.24]
["NH6",14,0,19,0,0,0,0,0,40,73,-0.08]
["NH7",14,0,0,2,38,0,0,0,40,94,0.24]
["NH8",14,0,0,2,38,0,0,0,40,94,0.24]
["NH9",14,0,0,2,38,0,0,0,40,94,0.24]
["NH10",14,0,19,0,0,0,0,0,40,73,-0.08]
["CL",0,55,0,2,0,0,0,0,40,97,0.19]
["DH1",0,55,0,0,0,0,0,0,40,95,0.19]
["D2H2",0,55,0,0,0,0,0,0,40,95,0.19]
["D2H3",0,0,19,2,0,0,0,0,40,61,-0.12]
["DH4",14,55,0,0,0,0,0,0,40,109,0.23]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(K35-SUMIF(B35:J35,\">0\",B$2:J$2),2)","v":0}]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(K67-SUMIF(B67:J67,\">0\",B$2:J$2),2)","v":0}]
[null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B68:J68)","v":0},{"$f":"ROUND(K68-SUMIF(B68:J68,\">0\",B$2:J$2),2)","v":0}]
[null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B69:J69)","v":0},{"$f":"ROUND(K69-SUMIF(B69:J69,\">0\",B$2:J$2),2)","v":0}]
[null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B70:J70)","v":0},{"$f":"ROUND(K70-SUMIF(B70:J70,\">0\",B$2:J$2),2)","v":0}]
["Event Total Payment     ",{"$f":"SUM(B3:B70)","v":140},{"$f":"SUM(C3:C70)","v":275},95,18,152,0,0,{"$f":"SUM(I3:I70)","v":0},600,{"$f":"SUM(K3:K70)","v":1280},{"$f":"SUM(L3:L70)","v":1.5499999999999998}]
["Number of Participants     ",{"$f":"COUNTIF(B3:B70,\">0\")","v":10},{"$f":"COUNTIF(C3:C70,\">0\")","v":5},5,9,4,0,0,{"$f":"COUNTIF(I3:I70,\">0\")","v":0},15,{"$f":"COUNTIF(K3:K70,\">0\")","v":15},null,"Note - For columns B through I:"]
["Event Surplus/Deficit     ",{"$f":"IF(ISNUMBER(B2),B71-B72*B2,\"\")","v":0.39999999999997726},0.94999999999998863,-0.60000000000000853,0,0.78480000000001837,"","",null,{"$f":"IF(ISNUMBER(J2),J71-J72*J2,\"\")","v":0},{"$f":"IF(ISNUMBER(K2),K72*K2-K71,\"\")","v":""},null,"     Fill row 1 with the name of each event with an associated host's cost"]
[null,{"$f":"IF(B72>0,IF(B73=\"\",\"Cell B2, event actual cost/pers. is missing\",\"\"),\"\")","v":""},null,null,{"$f":"IF(E72>0,IF(E73=\"\",\"Cell E2, event actual cost/pers. is missing\",\"\"),\"\")","v":""},null,null,{"$f":"IF(H72>0,IF(H73=\"\",\"Cell H2, event actual cost/pers. is missing\",\"\"),\"\")","v":""},null,null,null,null,"     Fill row 2 with the actual cost of the event when known"]
[null,null,{"$f":"IF(C72>0,IF(C73=\"\",\"Cell C2, event actual cost/pers. is missing\",\"\"),\"\")","v":""},null,null,{"$f":"IF(F72>0,IF(F73=\"\",\"Cell F2, event actual cost/pers. is missing\",\"\"),\"\")","v":""},null,null,{"$f":"IF(I72>0,IF(I73=\"\",\"Cell I2, event actual cost/pers. is missing\",\"\"),\"\")","v":""},null,null,null,"In row 3 through 70:"]
[null,null,null,{"$f":"IF(D72>0,IF(D73=\"\",\"Cell D2, event actual cost/pers. is missing\",\"\"),\"\")","v":""},null,null,{"$f":"IF(G72>0,IF(G73=\"\",\"Cell G2, event actual cost/pers. is missing\",\"\"),\"\")","v":""},null,null,{"$f":"IF(J72>0,IF(J73=\"\",\"Cell J2, event actual cost/pers. is missing\",\"\"),\"\")","v":""},null,null,"     Fill column A with the name of each participating host/FFO Member"]
[null,null,null,null,null,null,null,null,null,null,null,null,"     For each event, fill columns B through I with the amount paid by each Host."]

{"sheet":"Inbound Budget Report","index":5,"n_rows":70,"n_cols":13,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,8,0,12],[1,8,1,12],[3,0,3,2],[4,0,4,2],[4,11,4,13],[3,3,3,5],[4,3,4,5],[3,11,3,13],[4,8,4,10],[3,8,3,10]]}
[null,null,null,null,null,null,null,null,"FF Saturnalia/41248/15 Ambassadors"]
[null,null,null,null,null,null,null,null,"Wednesday, 05 Feb to Wednesday, 12 Feb 2020"]
[]
["FFO HC Name: ",null,null,"Jane Doe",null,null,null,null,"Incoming AC Name: ",null,null,"John Smith"]
["FFO Journey Treasurer Name:",null,null,"Your name",null,null,null,null,"Incoming Treasurer Name:",null,null,"Joe Blow"]
[]
["Events # and Dates",null,null,"Events",null,null,null,null,null,"FFO Revenue"]
[null,"Expense  Items",null,null,"Attendance","Unit cost","Total",null,null,"Attendance",null,"Unit cost","Total"]
[]
["#1 Wednesday, 5 Feb 2020",null,null,"Welcome"]
[null,"Room and hall fees",null,null,null,null,100]
[null,"Site staff",null,null,null,null,50]
[null,"Lunch",null,null,25,12.32,308,null,null,10,null,12.32,123.2]
[null,"Staff and gratuities",null,null,25,1.64,40.880000000000003,null,null,10,null,1.6799999999999997,16.799999999999997]
[null,null,null,null,null,null,498.88,null,null,null,null,null,140]
["#2 Thursday, 6 Feb 2020",null,null,"Escapade Eskimo"]
[null,"Lunch",null,null,20,10,200,null,null,5,null,10,50]
[null,"Escapade Eskimo Activities",null,null,20,45,900,null,null,5,null,45,225]
[null,"Transportation",null,null,null,null,425]
[null,"Bus Driver Gratuities",null,null,null,null,30]
[null,null,null,null,null,null,1555,null,null,null,null,null,275]
["#3 Friday, 7 Feb 2020",null,null,"Museum of History"]
[null,"Museum of History Admission",null,null,20,16,320,null,null,5,null,16,80]
[null,"Lunch",null,null,null,null,150]
[null,"Guided Tour",null,null,20,3,60,null,null,5,null,3,15]
[null,"Nunavut Sivuniksavut",null,null,null,null,75]
[null,"Parking",null,null,null,null,70]
[null,null,null,null,null,null,675,null,null,null,null,null,95]
["#4 Saturday, 8 Feb 2020",null,null,"Curling-Ice fishing"]
[null,"Curling Sheet",null,null,null,null,250]
[null,"Ice Fishing Hut ",null,null,null,null,24]
[null,"Lunch",null,null,null,null,225]
[null,"Drinks",null,null,24,2,48,null,null,9,null,2,18]
[null,"Plastic cups",null,null,null,null,3.98]
[null,null,null,null,null,null,550.98,null,null,null,null,null,18]
[]
[]
["Events # and Dates",null,null,"Events",null,null,null,null,null,"FFO Revenue"]
[null,"Expense  Items",null,null,"Attendance","Unit cost","Total",null,null,"Attendance",null,"Unit cost","Total"]
[]
["#5 Sunday, 9 Feb 2020",null,null,"Winterlude"]
[null,"Lunch",null,null,null,null,150]
[null,null,null,null,null,null,150,null,null,null,null,null,0]
["#6 Monday, 10 Feb 2020",null,null,"Omega Park"]
[null,"Omega Park Entrance Fee",null,null,19,18,342,null,null,4,null,18,72]
[null,"Lunch",null,null,19,20,380,null,null,4,null,20,80]
[null,"Guide",null,null,null,null,75]
[null,"Transportation",null,null,null,null,700]
[null,"Bus Driver Gratuities",null,null,null,null,30]
[null,null,null,null,null,null,1527,null,null,null,null,null,152]
["#7 Tuesday, 11 Feb 2020",null,null,"Parliament"]
[null,"Lunch-Snack",null,null,null,null,150]
["#8 Tuesday, 11 Feb 2020",null,null,"Farewell"]
[null,"Food",null,null,30,40,1200,null,null,15,null,40,600]
[null,null,null,null,null,null,1350,null,null,null,null,null,600]
["Administrative Costs"]
[null,"Gift Bags",null,null,15,8,120]
[null,"Wire Transfer Fee",null,null,1,14,14]
[null,"Ambassador Booklets",null,null,15,2.5,37.5]
[null,"Club Gift",null,null,1,15,15]
[null,"Bank Fees",null,null,5,2.5,12.5]
[null,"Contingency",null,null,15,10,150]
[null,"Memory Stick",null,null,15,2,30]
[null,null,null,null,null,null,379,null,null,null,null,null,0]
[]
["Total Journey Cost in CAD ",null,null,null,null,null,6685.86,null,"Total paid by Hosts in CAD ",null,null,null,1280]
["Total paid by 15 Ambassadors in CAD ",null,null,null,null,null,5405.86]
["Ambassador each pay in CAD (divide by 15)",null,null,null,null,null,360.4]
["Ambassador each pay in USD (divide by 1.3548)",null,null,null,null,null,267,null,"(rounded up to next dollar)"]
["Total paid by Ambassadors in USD (multiply by 15)",null,null,null,null,null,4005]

{"sheet":"Welcome","index":6,"n_rows":78,"n_cols":14,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,"2020-02-05",null,null,"In cell B1, enter the date in the format: day month year, such as: 25 Oct 2018."]
[null,{"$f":"IF(ISBLANK(B1),G19,IF(TYPE(B1)=1,G19&\" - \"&TEXT(B1,\"ddd\")&\", \"&TEXT(B1,\"dd mmm yyyy\"),\"Above date is invalid\"))","v":"Welcome - Wed, 05 Feb 2020"},null,null,null,null,null,{"$f":"\"In cell B2, to change the event name ''\"&G19&\"\"\", rename the tab\"","v":"In cell B2, to change the event name ''Welcome\", rename the tab"}]
[]
["Expenses",null,"Estimated $",null,"Source of Funds",null,null,null,"Estimated $",null,"Summary - Source and Use of Funds"]
[null,{"$f":"+B24","v":"Total Site"},{"$f":"+C24","v":150},null,null,null,{"$f":"+F20","v":"Total Admissions-Ambassadors"},null,{"$f":"+I20","v":358.88}]
[null,{"$f":"+B33","v":"Total Decorations"},{"$f":"+C33","v":0},null,null,null,{"$f":"+F30","v":"Total Admissions-Hosts"},null,{"$f":"+I30","v":140},null,null,{"$f":"+E4","v":"Source of Funds"},null,"Estimated $"]
[null,{"$f":"+B42","v":"Total Publicity"},{"$f":"+C42","v":0},null,null,null,{"$f":"+F40","v":"Total Miscellaneous Source of Funds"},null,{"$f":"+I40","v":0},null,null,null,{"$f":"+G5","v":"Total Admissions-Ambassadors"},{"$f":"+I5","v":358.88}]
[null,{"$f":"+B51","v":"Total Refreshments"},{"$f":"+C51","v":348.88},null,null,null,null,null,null,null,null,null,{"$f":"+G6","v":"Total Admissions-Hosts"},{"$f":"+I6","v":140}]
[null,{"$f":"+B60","v":"Total Program"},{"$f":"+C60","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G7","v":"Total Miscellaneous Source of Funds"},{"$f":"+I7","v":0}]
[null,{"$f":"+B69","v":"Total Prizes"},{"$f":"+C69","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G12","v":"Total Source of Funds"},{"$f":"+I12","v":498.88}]
[null,{"$f":"+B78","v":"Total Miscellaneous"},{"$f":"+C78","v":0}]
[null,{"$f":"+\"Total \"&A4","v":"Total Expenses"},{"$f":"SUM(C5:C11)","v":498.88},null,null,null,{"$f":"+\"Total \"&E4","v":"Total Source of Funds"},null,{"$f":"SUM(I5:I11)","v":498.88}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A4","v":"Expenses"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B5","v":"Total Site"},{"$f":"+C5","v":150}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Decorations",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Publicity",0]
["Site",null,"Estimated",null,"Admissions-Ambassadors",null,null,null,"Estimated",null,null,null,"Total Refreshments",348.88]
[null,"Room and hall fees",100,null,null,"Estimated #","what","unit price",null,null,null,null,"Total Program",0]
[null,"Site staff",50,null,null,{"$f":"IF(BUDGET!I2>0,BUDGET!I2,\"\")","v":15},{"$f":"MID(CELL(\"filename\",A1),IF(ISNUMBER(FIND(\"]\",CELL(\"filename\",A1))),FIND(\"]\",CELL(\"filename\",A1))+1,FIND(\"#$\",CELL(\"filename\",A1))+2),31)","v":"Welcome"},{"$f":"IF(F19=\"\",0,(C12-I30-I40)/F19)","v":23.925333333333334},{"$f":"IF(F19<>\"\",+H19*F19,0)","v":358.88},null,null,null,"Total Prizes",0]
[null,"Equipment",null,null,null,{"$f":"+\"Total \"&E17","v":"Total Admissions-Ambassadors"},null,null,{"$f":"+I19","v":358.88},null,null,null,"Total Miscellaneous",0]
[null,"Tables and chairs",null,null,null,null,null,null,null,null,null,null,"Total Expenses",498.88]
[null,"blank",null,null,"Admissions-Hosts"]
[null,"blank",null,null,null,"Estimated #","what","unit price",null,null,null,"Net Source and Use of Funds",null,{"$f":"+N10-N21","v":0}]
[null,{"$f":"+\"Total \"&A17","v":"Total Site"},{"$f":"SUM(C17:C23)","v":150},null,null,10,"Lunch",12.32,{"$f":"+H24*F24","v":123.2}]
[null,null,null,null,null,10,"Staff and gratuities",{"$f":"ROUND((H24/1.13*0.15)+H24,0)-H24","v":1.6799999999999997},16.799999999999997]
["Decorations",null,null,null,null,null,null,null,0]
[null,"Flowers",null,null,null,null,null,null,0]
[null,"Candles",null,null,null,null,null,null,0]
[null,"Lighting",null,null,null,null,null,null,0]
[null,"Balloons",null,null,null,{"$f":"+\"Total \"&E22","v":"Total Admissions-Hosts"},null,null,{"$f":"SUM(I24:I29)","v":140}]
[null,"Paper supplies"]
[null,"blank",null,null,"Miscellaneous Source of Funds"]
[null,{"$f":"+\"Total \"&A26","v":"Total Decorations"},{"$f":"SUM(C26:C32)","v":0},null,null,"Estimated #","what","unit price"]
[null,null,null,null,null,null,null,null,{"$f":"+H34*F34","v":0}]
["Publicity",null,null,null,null,null,null,null,0]
[null,"Graphics work",null,null,null,null,null,null,0]
[null,"Photocopying/Printing",null,null,null,null,null,null,0]
[null,"Postage",null,null,null,null,null,null,0]
[null,"blank",null,null,null,null,null,null,0]
[null,"blank",null,null,null,{"$f":"+\"Total \"&E32","v":"Total Miscellaneous Source of Funds"},null,null,{"$f":"SUM(I34:I39)","v":0}]
[null,"blank"]
[null,{"$f":"+\"Total \"&A35","v":"Total Publicity"},{"$f":"SUM(C35:C41)","v":0}]
[]
["Refreshments"]
[null,"Lunch",{"$f":"(F19+F24)*12.32","v":308}]
[null,"Drinks"]
[null,"Linens"]
[null,"Staff and gratuities",{"$f":"ROUND(C45/1.13*0.15,2)","v":40.880000000000003}]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A44","v":"Total Refreshments"},{"$f":"SUM(C44:C50)","v":348.88}]
[]
["Program"]
[null,"Performers"]
[null,"Speakers"]
[null,"Travel"]
[null,"Hotel"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A53","v":"Total Program"},{"$f":"SUM(C53:C59)","v":0}]
[]
["Prizes"]
[null,"Ribbons/Plaques/Trophies"]
[null,"Gifts"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A62","v":"Total Prizes"},{"$f":"SUM(C62:C68)","v":0}]
[]
["Miscellaneous"]
[null,"Telephone"]
[null,"Transportation"]
[null,"Stationery supplies"]
[null,"Fax services"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A71","v":"Total Miscellaneous"},{"$f":"SUM(C71:C77)","v":0}]

{"sheet":"Escapade Eskimo","index":7,"n_rows":78,"n_cols":14,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,"2020-02-06",null,null,"In cell B1, enter the date in the format: day month year, such as: 25 Oct 2018."]
[null,{"$f":"IF(ISBLANK(B1),G19,IF(TYPE(B1)=1,G19&\" - \"&TEXT(B1,\"ddd\")&\", \"&TEXT(B1,\"dd mmm yyyy\"),\"Above date is invalid\"))","v":"Escapade Eskimo - Thu, 06 Feb 2020"},null,null,null,null,null,{"$f":"\"In cell B2, to change the event name ''\"&G19&\"\"\", rename the tab\"","v":"In cell B2, to change the event name ''Escapade Eskimo\", rename the tab"}]
[]
["Expenses",null,"Estimated $",null,"Source of Funds",null,null,null,"Estimated $",null,"Summary - Source and Use of Funds"]
[null,{"$f":"+B24","v":"Total Site"},{"$f":"+C24","v":0},null,null,null,{"$f":"+F20","v":"Total Admissions-Ambassadors"},null,{"$f":"+I20","v":1280}]
[null,{"$f":"+B33","v":"Total Decorations"},{"$f":"+C33","v":0},null,null,null,{"$f":"+F30","v":"Total Admissions-Hosts"},null,{"$f":"+I30","v":275},null,null,{"$f":"+E4","v":"Source of Funds"},null,"Estimated $"]
[null,{"$f":"+B42","v":"Total Publicity"},{"$f":"+C42","v":0},null,null,null,{"$f":"+F40","v":"Total Miscellaneous Source of Funds"},null,{"$f":"+I40","v":0},null,null,null,{"$f":"+G5","v":"Total Admissions-Ambassadors"},{"$f":"+I5","v":1280}]
[null,{"$f":"+B51","v":"Total Refreshments"},{"$f":"+C51","v":200},null,null,null,null,null,null,null,null,null,{"$f":"+G6","v":"Total Admissions-Hosts"},{"$f":"+I6","v":275}]
[null,{"$f":"+B60","v":"Total Program"},{"$f":"+C60","v":900},null,null,null,null,null,null,null,null,null,{"$f":"+G7","v":"Total Miscellaneous Source of Funds"},{"$f":"+I7","v":0}]
[null,{"$f":"+B69","v":"Total Prizes"},{"$f":"+C69","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G12","v":"Total Source of Funds"},{"$f":"+I12","v":1555}]
[null,{"$f":"+B78","v":"Total Miscellaneous"},{"$f":"+C78","v":455}]
[null,{"$f":"+\"Total \"&A4","v":"Total Expenses"},{"$f":"SUM(C5:C11)","v":1555},null,null,null,{"$f":"+\"Total \"&E4","v":"Total Source of Funds"},null,{"$f":"SUM(I5:I11)","v":1555}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A4","v":"Expenses"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B5","v":"Total Site"},0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Decorations",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Publicity",0]
["Site",null,"Estimated",null,"Admissions-Ambassadors",null,null,null,"Estimated",null,null,null,"Total Refreshments",200]
[null,"Room and hall fees",null,null,null,"Estimated #","what","unit price",null,null,null,null,"Total Program",900]
[null,"Site staff",null,null,null,{"$f":"IF(BUDGET!I2>0,BUDGET!I2,\"\")","v":15},{"$f":"MID(CELL(\"filename\",A1),IF(ISNUMBER(FIND(\"]\",CELL(\"filename\",A1))),FIND(\"]\",CELL(\"filename\",A1))+1,FIND(\"#$\",CELL(\"filename\",A1))+2),31)","v":"Escapade Eskimo"},{"$f":"IF(F19=\"\",0,(C12-I30-I40)/F19)","v":85.333333333333329},{"$f":"IF(F19<>\"\",+H19*F19,0)","v":1280},null,null,null,"Total Prizes",0]
[null,"Equipment",null,null,null,{"$f":"+\"Total \"&E17","v":"Total Admissions-Ambassadors"},null,null,{"$f":"+I19","v":1280},null,null,null,"Total Miscellaneous",455]
[null,"Tables and chairs",null,null,null,null,null,null,null,null,null,null,"Total Expenses",1555]
[null,"blank",null,null,"Admissions-Hosts"]
[null,"blank",null,null,null,"Estimated #","what","unit price",null,null,null,"Net Source and Use of Funds",null,{"$f":"+N10-N21","v":0}]
[null,{"$f":"+\"Total \"&A17","v":"Total Site"},{"$f":"SUM(C18:C23)","v":0},null,null,5,"Escapade Eskimo Activities",45,{"$f":"+H24*F24","v":225}]
[null,null,null,null,null,5,"Lunch",10,50]
["Decorations",null,null,null,null,null,null,null,0]
[null,"Flowers",null,null,null,null,null,null,0]
[null,"Candles",null,null,null,null,null,null,0]
[null,"Lighting",null,null,null,null,null,null,0]
[null,"Balloons",null,null,null,{"$f":"+\"Total \"&E22","v":"Total Admissions-Hosts"},null,null,{"$f":"SUM(I24:I29)","v":275}]
[null,"Paper supplies"]
[null,"blank",null,null,"Miscellaneous Source of Funds"]
[null,{"$f":"+\"Total \"&A26","v":"Total Decorations"},{"$f":"SUM(C27:C32)","v":0},null,null,"Estimated #","what","unit price"]
[null,null,null,null,null,null,null,null,{"$f":"+H34*F34","v":0}]
["Publicity",null,null,null,null,null,null,null,0]
[null,"Graphics work",null,null,null,null,null,null,0]
[null,"Photocopying/Printing",null,null,null,null,null,null,0]
[null,"Postage",null,null,null,null,null,null,0]
[null,"blank",null,null,null,null,null,null,0]
[null,"blank",null,null,null,{"$f":"+\"Total \"&E32","v":"Total Miscellaneous Source of Funds"},null,null,{"$f":"SUM(I34:I39)","v":0}]
[null,"blank"]
[null,{"$f":"+\"Total \"&A35","v":"Total Publicity"},{"$f":"SUM(C36:C41)","v":0}]
[]
["Refreshments"]
[null,"Lunch",{"$f":"(F19+F25)*10","v":200}]
[null,"Drinks"]
[null,"Linens"]
[null,"Staff and gratuities"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A44","v":"Total Refreshments"},{"$f":"SUM(C45:C50)","v":200}]
[]
["Program"]
[null,"Performers"]
[null,"Speakers"]
[null,"Travel"]
[null,"Hotel"]
[null,"Escapade Eskimo Activities",{"$f":"(F19+F24)*45","v":900}]
[null,"blank"]
[null,{"$f":"+\"Total \"&A53","v":"Total Program"},{"$f":"SUM(C54:C59)","v":900}]
[]
["Prizes"]
[null,"Ribbons/Plaques/Trophies"]
[null,"Gifts"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A62","v":"Total Prizes"},{"$f":"SUM(C63:C68)","v":0}]
[]
["Miscellaneous"]
[null,"Telephone"]
[null,"Transportation",425]
[null,"Stationery supplies"]
[null,"Fax services"]
[null,"Bus Driver Gratuities",{"$f":"2*F19","v":30}]
[null,"blank"]
[null,{"$f":"+\"Total \"&A71","v":"Total Miscellaneous"},{"$f":"SUM(C72:C77)","v":455}]

{"sheet":"Museum of History","index":8,"n_rows":78,"n_cols":15,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,"2020-02-07",null,null,"In cell B1, enter the date in the format: day month year, such as: 25 Oct 2018."]
[null,{"$f":"IF(ISBLANK(B1),G19,IF(TYPE(B1)=1,G19&\" - \"&TEXT(B1,\"ddd\")&\", \"&TEXT(B1,\"dd mmm yyyy\"),\"Above date is invalid\"))","v":"Museum of History - Fri, 07 Feb 2020"},null,null,null,null,null,{"$f":"\"In cell B2, to change the event name ''\"&G19&\"\"\", rename the tab\"","v":"In cell B2, to change the event name ''Museum of History\", rename the tab"}]
[]
["Expenses",null,"Estimated $",null,"Source of Funds",null,null,null,"Estimated $",null,"Summary - Source and Use of Funds"]
[null,{"$f":"+B24","v":"Total Site"},{"$f":"+C24","v":320},null,null,null,{"$f":"+F20","v":"Total Admissions-Ambassadors"},null,{"$f":"+I20","v":580}]
[null,{"$f":"+B33","v":"Total Decorations"},{"$f":"+C33","v":0},null,null,null,{"$f":"+F30","v":"Total Admissions-Hosts"},null,{"$f":"+I30","v":95},null,null,{"$f":"+E4","v":"Source of Funds"},null,"Estimated $"]
[null,{"$f":"+B42","v":"Total Publicity"},{"$f":"+C42","v":0},null,null,null,{"$f":"+F40","v":"Total Miscellaneous Source of Funds"},null,{"$f":"+I40","v":0},null,null,null,{"$f":"+G5","v":"Total Admissions-Ambassadors"},{"$f":"+I5","v":580}]
[null,{"$f":"+B51","v":"Total Refreshments"},{"$f":"+C51","v":150},null,null,null,null,null,null,null,null,null,{"$f":"+G6","v":"Total Admissions-Hosts"},{"$f":"+I6","v":95}]
[null,{"$f":"+B60","v":"Total Program"},{"$f":"+C60","v":135},null,null,null,null,null,null,null,null,null,{"$f":"+G7","v":"Total Miscellaneous Source of Funds"},{"$f":"+I7","v":0}]
[null,{"$f":"+B69","v":"Total Prizes"},{"$f":"+C69","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G12","v":"Total Source of Funds"},{"$f":"+I12","v":675}]
[null,{"$f":"+B78","v":"Total Miscellaneous"},{"$f":"+C78","v":70}]
[null,{"$f":"+\"Total \"&A4","v":"Total Expenses"},{"$f":"SUM(C5:C11)","v":675},null,null,null,{"$f":"+\"Total \"&E4","v":"Total Source of Funds"},null,{"$f":"SUM(I5:I11)","v":675}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A4","v":"Expenses"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B5","v":"Total Site"},320]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Decorations",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Publicity",0]
["Site",null,"Estimated",null,"Admissions-Ambassadors",null,null,null,"Estimated",null,null,null,"Total Refreshments",150]
[null,"Room and hall fees",null,null,null,"Estimated #","what","unit price",null,null,null,null,"Total Program",135]
[null,"Site staff",null,null,null,{"$f":"IF(BUDGET!I2>0,BUDGET!I2,\"\")","v":15},{"$f":"MID(CELL(\"filename\",A1),IF(ISNUMBER(FIND(\"]\",CELL(\"filename\",A1))),FIND(\"]\",CELL(\"filename\",A1))+1,FIND(\"#$\",CELL(\"filename\",A1))+2),31)","v":"Museum of History"},{"$f":"IF(F19=\"\",0,(C12-I30-I40)/F19)","v":38.666666666666664},{"$f":"IF(F19<>\"\",+H19*F19,0)","v":580},null,null,null,"Total Prizes",0]
[null,"Equipment",null,null,null,{"$f":"+\"Total \"&E17","v":"Total Admissions-Ambassadors"},null,null,{"$f":"+I19","v":580},null,null,null,"Total Miscellaneous",70]
[null,"Tables and chairs",null,null,null,null,null,null,null,null,null,null,"Total Expenses",675]
[null,"Museum of History Admission",{"$f":"(F19+F24)*16","v":320},null,"Admissions-Hosts"]
[null,"blank",null,null,null,"Estimated #","what","unit price",null,null,null,"Net Source and Use of Funds",null,{"$f":"+N10-N21","v":0}]
[null,{"$f":"+\"Total \"&A17","v":"Total Site"},{"$f":"SUM(C17:C23)","v":320},null,null,5,"Museum of History Admission",16,{"$f":"+H24*F24","v":80}]
[null,null,null,null,null,5,"Guided Tour",3,15]
["Decorations",null,null,null,null,null,null,null,0]
[null,"Flowers",null,null,null,null,null,null,0]
[null,"Candles",null,null,null,null,null,null,0,null,null,null,null,null,19]
[null,"Lighting",null,null,null,null,null,null,0,null,null,null,null,"Unit cost","Total"]
[null,"Balloons",null,null,null,{"$f":"+\"Total \"&E22","v":"Total Admissions-Hosts"},null,null,{"$f":"SUM(I24:I29)","v":95},null,null,"ambassadors"]
[null,"Paper supplies",null,null,null,null,null,null,null,null,null,null,"entrance",12.65,{"$f":"N31*O28","v":240.35}]
[null,"blank",null,null,"Miscellaneous Source of Funds",null,null,null,null,null,null,null,"tip",2,{"$f":"N32*O28","v":38}]
[null,{"$f":"+\"Total \"&A26","v":"Total Decorations"},{"$f":"SUM(C26:C32)","v":0},null,null,"Estimated #","what","unit price",null,null,null,null,"Total",null,{"$f":"O32+O31","v":278.35000000000002}]
[null,null,null,null,null,null,null,null,{"$f":"+H34*F34","v":0},null,null,null,"cost per person",null,{"$f":"O33/O28","v":14.65}]
["Publicity",null,null,null,null,null,null,null,0]
[null,"Graphics work",null,null,null,null,null,null,0,null,null,"hosts",null,null,7]
[null,"Photocopying/Printing",null,null,null,null,null,null,0,null,null,null,"entrance",{"$f":"N31","v":12.65},{"$f":"N37*O36","v":88.55}]
[null,"Postage",null,null,null,null,null,null,0,null,null,null,"Tip",2,12]
[null,"blank",null,null,null,null,null,null,0,null,null,null,"Total",null,{"$f":"O38+O37","v":100.55}]
[null,"blank",null,null,null,{"$f":"+\"Total \"&E32","v":"Total Miscellaneous Source of Funds"},null,null,{"$f":"SUM(I34:I39)","v":0},null,null,null,"cost per person",null,{"$f":"O39/O36","v":14.364285714285714}]
[null,"blank"]
[null,{"$f":"+\"Total \"&A35","v":"Total Publicity"},{"$f":"SUM(C35:C41)","v":0}]
[]
["Refreshments"]
[null,"Lunch",{"$f":"F19*10","v":150}]
[null,"Drinks"]
[null,"Linens"]
[null,"Staff and gratuities"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A44","v":"Total Refreshments"},{"$f":"SUM(C44:C50)","v":150}]
[]
["Program"]
[null,"Performers"]
[null,"Speakers"]
[null,"Travel"]
[null,"Hotel"]
[null,"Guided Tour",{"$f":"(F19+F25)*3","v":60}]
[null,"Nunavut Sivuniksavut",{"$f":"F19*5","v":75}]
[null,{"$f":"+\"Total \"&A53","v":"Total Program"},{"$f":"SUM(C53:C59)","v":135}]
[]
["Prizes"]
[null,"Ribbons/Plaques/Trophies"]
[null,"Gifts"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A62","v":"Total Prizes"},{"$f":"SUM(C62:C68)","v":0}]
[]
["Miscellaneous"]
[null,"Telephone"]
[null,"Transportation"]
[null,"Stationery supplies"]
[null,"Fax services"]
[null,"Parking",{"$f":"7*10","v":70}]
[null,"blank"]
[null,{"$f":"+\"Total \"&A71","v":"Total Miscellaneous"},{"$f":"SUM(C71:C77)","v":70}]

{"sheet":"Curling-Ice fishing","index":9,"n_rows":78,"n_cols":14,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,"2020-02-08",null,null,"In cell B1, enter the date in the format: day month year, such as: 25 Oct 2018."]
[null,{"$f":"IF(ISBLANK(B1),G19,IF(TYPE(B1)=1,G19&\" - \"&TEXT(B1,\"ddd\")&\", \"&TEXT(B1,\"dd mmm yyyy\"),\"Above date is invalid\"))","v":"Curling-Ice fishing - Sat, 08 Feb 2020"},null,null,null,null,null,{"$f":"\"In cell B2, to change the event name ''\"&G19&\"\"\", rename the tab\"","v":"In cell B2, to change the event name ''Curling-Ice fishing\", rename the tab"}]
[]
["Expenses",null,"Estimated $",null,"Source of Funds",null,null,null,"Estimated $",null,"Summary - Source and Use of Funds"]
[null,{"$f":"+B24","v":"Total Site"},{"$f":"+C24","v":274},null,null,null,{"$f":"+F20","v":"Total Admissions-Ambassadors"},null,{"$f":"+I20","v":532.98}]
[null,{"$f":"+B33","v":"Total Decorations"},{"$f":"+C33","v":0},null,null,null,{"$f":"+F30","v":"Total Admissions-Hosts"},null,{"$f":"+I30","v":18},null,null,{"$f":"+E4","v":"Source of Funds"},null,"Estimated $"]
[null,{"$f":"+B42","v":"Total Publicity"},{"$f":"+C42","v":0},null,null,null,{"$f":"+F40","v":"Total Miscellaneous Source of Funds"},null,{"$f":"+I40","v":0},null,null,null,{"$f":"+G5","v":"Total Admissions-Ambassadors"},{"$f":"+I5","v":532.98}]
[null,{"$f":"+B51","v":"Total Refreshments"},{"$f":"+C51","v":276.98},null,null,null,null,null,null,null,null,null,{"$f":"+G6","v":"Total Admissions-Hosts"},{"$f":"+I6","v":18}]
[null,{"$f":"+B60","v":"Total Program"},{"$f":"+C60","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G7","v":"Total Miscellaneous Source of Funds"},{"$f":"+I7","v":0}]
[null,{"$f":"+B69","v":"Total Prizes"},{"$f":"+C69","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G12","v":"Total Source of Funds"},{"$f":"+I12","v":550.98}]
[null,{"$f":"+B78","v":"Total Miscellaneous"},{"$f":"+C78","v":0}]
[null,{"$f":"+\"Total \"&A4","v":"Total Expenses"},{"$f":"SUM(C5:C11)","v":550.98},null,null,null,{"$f":"+\"Total \"&E4","v":"Total Source of Funds"},null,{"$f":"SUM(I5:I11)","v":550.98}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A4","v":"Expenses"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B5","v":"Total Site"},274]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Decorations",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Publicity",0]
["Site",null,"Estimated",null,"Admissions-Ambassadors",null,null,null,"Estimated",null,null,null,"Total Refreshments",276.98]
[null,"Room and hall fees",null,null,null,"Estimated #","what","unit price",null,null,null,null,"Total Program",0]
[null,"Site staff",null,null,null,{"$f":"IF(BUDGET!I2>0,BUDGET!I2,\"\")","v":15},{"$f":"MID(CELL(\"filename\",A1),IF(ISNUMBER(FIND(\"]\",CELL(\"filename\",A1))),FIND(\"]\",CELL(\"filename\",A1))+1,FIND(\"#$\",CELL(\"filename\",A1))+2),31)","v":"Curling-Ice fishing"},{"$f":"IF(F19=\"\",0,(C12-I30-I40)/F19)","v":35.532000000000004},{"$f":"IF(F19<>\"\",+H19*F19,0)","v":532.98},null,null,null,"Total Prizes",0]
[null,"Equipment",null,null,null,{"$f":"+\"Total \"&E17","v":"Total Admissions-Ambassadors"},null,null,{"$f":"+I19","v":532.98},null,null,null,"Total Miscellaneous",0]
[null,"Tables and chairs",null,null,null,null,null,null,null,null,null,null,"Total Expenses",550.98]
[null,"Curling Sheet",250,null,"Admissions-Hosts"]
[null,"Ice Fishing Hut ",24,null,null,"Estimated #","what","unit price",null,null,null,"Net Source and Use of Funds",null,{"$f":"+N10-N21","v":0}]
[null,{"$f":"+\"Total \"&A17","v":"Total Site"},{"$f":"SUM(C17:C23)","v":274},null,null,9,"Drinks",2,{"$f":"+H24*F24","v":18}]
[null,null,null,null,null,null,null,null,0]
["Decorations",null,null,null,null,null,null,null,0]
[null,"Flowers",null,null,null,null,null,null,0]
[null,"Candles",null,null,null,null,null,null,0]
[null,"Lighting",null,null,null,null,null,null,0]
[null,"Balloons",null,null,null,{"$f":"+\"Total \"&E22","v":"Total Admissions-Hosts"},null,null,{"$f":"SUM(I24:I29)","v":18}]
[null,"Paper supplies"]
[null,"blank",null,null,"Miscellaneous Source of Funds"]
[null,{"$f":"+\"Total \"&A26","v":"Total Decorations"},{"$f":"SUM(C26:C32)","v":0},null,null,"Estimated #","what","unit price"]
[null,null,null,null,null,null,null,null,{"$f":"+H34*F34","v":0}]
["Publicity",null,null,null,null,null,null,null,0]
[null,"Graphics work",null,null,null,null,null,null,0]
[null,"Photocopying/Printing",null,null,null,null,null,null,0]
[null,"Postage",null,null,null,null,null,null,0]
[null,"blank",null,null,null,null,null,null,0]
[null,"blank",null,null,null,{"$f":"+\"Total \"&E32","v":"Total Miscellaneous Source of Funds"},null,null,{"$f":"SUM(I34:I39)","v":0}]
[null,"blank"]
[null,{"$f":"+\"Total \"&A35","v":"Total Publicity"},{"$f":"SUM(C35:C41)","v":0}]
[]
["Refreshments"]
[null,"Lunch",{"$f":"F19*15","v":225}]
[null,"Drinks",{"$f":"2*24","v":48}]
[null,"Linens"]
[null,"Staff and gratuities"]
[null,"Plastic cups",3.98]
[null,"blank"]
[null,{"$f":"+\"Total \"&A44","v":"Total Refreshments"},{"$f":"SUM(C44:C50)","v":276.98}]
[]
["Program"]
[null,"Performers"]
[null,"Speakers"]
[null,"Travel"]
[null,"Hotel"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A53","v":"Total Program"},{"$f":"SUM(C53:C59)","v":0}]
[]
["Prizes"]
[null,"Ribbons/Plaques/Trophies"]
[null,"Gifts"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A62","v":"Total Prizes"},{"$f":"SUM(C62:C68)","v":0}]
[]
["Miscellaneous"]
[null,"Telephone"]
[null,"Transportation"]
[null,"Stationery supplies"]
[null,"Fax services"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A71","v":"Total Miscellaneous"},{"$f":"SUM(C71:C77)","v":0}]

{"sheet":"Winterlude","index":10,"n_rows":78,"n_cols":14,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,"2020-02-09",null,null,"In cell B1, enter the date in the format: day month year, such as: 25 Oct 2018."]
[null,{"$f":"IF(ISBLANK(B1),G19,IF(TYPE(B1)=1,G19&\" - \"&TEXT(B1,\"ddd\")&\", \"&TEXT(B1,\"dd mmm yyyy\"),\"Above date is invalid\"))","v":"Winterlude - Sun, 09 Feb 2020"},null,null,null,null,null,{"$f":"\"In cell B2, to change the event name ''\"&G19&\"\"\", rename the tab\"","v":"In cell B2, to change the event name ''Winterlude\", rename the tab"}]
[]
["Expenses",null,"Estimated $",null,"Source of Funds",null,null,null,"Estimated $",null,"Summary - Source and Use of Funds"]
[null,{"$f":"+B24","v":"Total Site"},{"$f":"+C24","v":0},null,null,null,{"$f":"+F20","v":"Total Admissions-Ambassadors"},null,{"$f":"+I20","v":150}]
[null,{"$f":"+B33","v":"Total Decorations"},{"$f":"+C33","v":0},null,null,null,{"$f":"+F30","v":"Total Admissions-Hosts"},null,{"$f":"+I30","v":0},null,null,{"$f":"+E4","v":"Source of Funds"},null,"Estimated $"]
[null,{"$f":"+B42","v":"Total Publicity"},{"$f":"+C42","v":0},null,null,null,{"$f":"+F40","v":"Total Miscellaneous Source of Funds"},null,{"$f":"+I40","v":0},null,null,null,{"$f":"+G5","v":"Total Admissions-Ambassadors"},{"$f":"+I5","v":150}]
[null,{"$f":"+B51","v":"Total Refreshments"},{"$f":"+C51","v":150},null,null,null,null,null,null,null,null,null,{"$f":"+G6","v":"Total Admissions-Hosts"},{"$f":"+I6","v":0}]
[null,{"$f":"+B60","v":"Total Program"},{"$f":"+C60","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G7","v":"Total Miscellaneous Source of Funds"},{"$f":"+I7","v":0}]
[null,{"$f":"+B69","v":"Total Prizes"},{"$f":"+C69","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G12","v":"Total Source of Funds"},{"$f":"+I12","v":150}]
[null,{"$f":"+B78","v":"Total Miscellaneous"},{"$f":"+C78","v":0}]
[null,{"$f":"+\"Total \"&A4","v":"Total Expenses"},{"$f":"SUM(C5:C11)","v":150},null,null,null,{"$f":"+\"Total \"&E4","v":"Total Source of Funds"},null,{"$f":"SUM(I5:I11)","v":150}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A4","v":"Expenses"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B5","v":"Total Site"},0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Decorations",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Publicity",0]
["Site",null,"Estimated",null,"Admissions-Ambassadors",null,null,null,"Estimated",null,null,null,"Total Refreshments",150]
[null,"Room and hall fees",null,null,null,"Estimated #","what","unit price",null,null,null,null,"Total Program",0]
[null,"Site staff",null,null,null,{"$f":"IF(BUDGET!I2>0,BUDGET!I2,\"\")","v":15},{"$f":"MID(CELL(\"filename\",A1),IF(ISNUMBER(FIND(\"]\",CELL(\"filename\",A1))),FIND(\"]\",CELL(\"filename\",A1))+1,FIND(\"#$\",CELL(\"filename\",A1))+2),31)","v":"Winterlude"},{"$f":"IF(F19=\"\",0,(C12-I30-I40)/F19)","v":10},{"$f":"IF(F19<>\"\",+H19*F19,0)","v":150},null,null,null,"Total Prizes",0]
[null,"Equipment",null,null,null,{"$f":"+\"Total \"&E17","v":"Total Admissions-Ambassadors"},null,null,{"$f":"+I19","v":150},null,null,null,"Total Miscellaneous",0]
[null,"Tables and chairs",null,null,null,null,null,null,null,null,null,null,"Total Expenses",150]
[null,"blank",null,null,"Admissions-Hosts"]
[null,"blank",null,null,null,"Estimated #","what","unit price",null,null,null,"Net Source and Use of Funds",null,{"$f":"+N10-N21","v":0}]
[null,{"$f":"+\"Total \"&A17","v":"Total Site"},{"$f":"SUM(C17:C23)","v":0},null,null,null,null,null,{"$f":"+H24*F24","v":0}]
[null,null,null,null,null,null,null,null,0]
["Decorations",null,null,null,null,null,null,null,0]
[null,"Flowers",null,null,null,null,null,null,0]
[null,"Candles",null,null,null,null,null,null,0]
[null,"Lighting",null,null,null,null,null,null,0]
[null,"Balloons",null,null,null,{"$f":"+\"Total \"&E22","v":"Total Admissions-Hosts"},null,null,{"$f":"SUM(I24:I29)","v":0}]
[null,"Paper supplies"]
[null,"blank",null,null,"Miscellaneous Source of Funds"]
[null,{"$f":"+\"Total \"&A26","v":"Total Decorations"},{"$f":"SUM(C26:C32)","v":0},null,null,"Estimated #","what","unit price"]
[null,null,null,null,null,null,null,null,{"$f":"+H34*F34","v":0}]
["Publicity",null,null,null,null,null,null,null,0]
[null,"Graphics work",null,null,null,null,null,null,0]
[null,"Photocopying/Printing",null,null,null,null,null,null,0]
[null,"Postage",null,null,null,null,null,null,0]
[null,"blank",null,null,null,null,null,null,0]
[null,"blank",null,null,null,{"$f":"+\"Total \"&E32","v":"Total Miscellaneous Source of Funds"},null,null,{"$f":"SUM(I34:I39)","v":0}]
[null,"blank"]
[null,{"$f":"+\"Total \"&A35","v":"Total Publicity"},{"$f":"SUM(C35:C41)","v":0}]
[]
["Refreshments"]
[null,"Lunch",{"$f":"F19*10","v":150}]
[null,"Drinks"]
[null,"Linens"]
[null,"Staff and gratuities"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A44","v":"Total Refreshments"},{"$f":"SUM(C44:C50)","v":150}]
[]
["Program"]
[null,"Performers"]
[null,"Speakers"]
[null,"Travel"]
[null,"Hotel"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A53","v":"Total Program"},{"$f":"SUM(C53:C59)","v":0}]
[]
["Prizes"]
[null,"Ribbons/Plaques/Trophies"]
[null,"Gifts"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A62","v":"Total Prizes"},{"$f":"SUM(C62:C68)","v":0}]
[]
["Miscellaneous"]
[null,"Telephone"]
[null,"Transportation"]
[null,"Stationery supplies"]
[null,"Fax services"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A71","v":"Total Miscellaneous"},{"$f":"SUM(C71:C77)","v":0}]

{"sheet":"Omega Park","index":11,"n_rows":78,"n_cols":14,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,"2020-02-10",null,null,"In cell B1, enter the date in the format: day month year, such as: 25 Oct 2018."]
[null,{"$f":"IF(ISBLANK(B1),G19,IF(TYPE(B1)=1,G19&\" - \"&TEXT(B1,\"ddd\")&\", \"&TEXT(B1,\"dd mmm yyyy\"),\"Above date is invalid\"))","v":"Omega Park - Mon, 10 Feb 2020"},null,null,null,null,null,{"$f":"\"In cell B2, to change the event name ''\"&G19&\"\"\", rename the tab\"","v":"In cell B2, to change the event name ''Omega Park\", rename the tab"}]
[]
["Expenses",null,"Estimated $",null,"Source of Funds",null,null,null,"Estimated $",null,"Summary - Source and Use of Funds"]
[null,{"$f":"+B24","v":"Total Site"},{"$f":"+C24","v":342},null,null,null,{"$f":"+F20","v":"Total Admissions-Ambassadors"},null,{"$f":"+I20","v":1375}]
[null,{"$f":"+B33","v":"Total Decorations"},{"$f":"+C33","v":0},null,null,null,{"$f":"+F30","v":"Total Admissions-Hosts"},null,{"$f":"+I30","v":152},null,null,{"$f":"+E4","v":"Source of Funds"},null,"Estimated $"]
[null,{"$f":"+B42","v":"Total Publicity"},{"$f":"+C42","v":0},null,null,null,{"$f":"+F40","v":"Total Miscellaneous Source of Funds"},null,{"$f":"+I40","v":0},null,null,null,{"$f":"+G5","v":"Total Admissions-Ambassadors"},{"$f":"+I5","v":1375}]
[null,{"$f":"+B51","v":"Total Refreshments"},{"$f":"+C51","v":380},null,null,null,null,null,null,null,null,null,{"$f":"+G6","v":"Total Admissions-Hosts"},{"$f":"+I6","v":152}]
[null,{"$f":"+B60","v":"Total Program"},{"$f":"+C60","v":75},null,null,null,null,null,null,null,null,null,{"$f":"+G7","v":"Total Miscellaneous Source of Funds"},{"$f":"+I7","v":0}]
[null,{"$f":"+B69","v":"Total Prizes"},{"$f":"+C69","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G12","v":"Total Source of Funds"},{"$f":"+I12","v":1527}]
[null,{"$f":"+B78","v":"Total Miscellaneous"},{"$f":"+C78","v":730}]
[null,{"$f":"+\"Total \"&A4","v":"Total Expenses"},{"$f":"SUM(C5:C11)","v":1527},null,null,null,{"$f":"+\"Total \"&E4","v":"Total Source of Funds"},null,{"$f":"SUM(I5:I11)","v":1527}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A4","v":"Expenses"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B5","v":"Total Site"},342]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Decorations",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Publicity",0]
["Site",null,"Estimated",null,"Admissions-Ambassadors",null,null,null,"Estimated",null,null,null,"Total Refreshments",380]
[null,"Room and hall fees",null,null,null,"Estimated #","what","unit price",null,null,null,null,"Total Program",75]
[null,"Site staff",null,null,null,{"$f":"IF(BUDGET!I2>0,BUDGET!I2,\"\")","v":15},{"$f":"MID(CELL(\"filename\",A1),IF(ISNUMBER(FIND(\"]\",CELL(\"filename\",A1))),FIND(\"]\",CELL(\"filename\",A1))+1,FIND(\"#$\",CELL(\"filename\",A1))+2),31)","v":"Omega Park"},{"$f":"IF(F19=\"\",0,(C12-I30-I40)/F19)","v":91.666666666666671},{"$f":"IF(F19<>\"\",+H19*F19,0)","v":1375},null,null,null,"Total Prizes",0]
[null,"Equipment",null,null,null,{"$f":"+\"Total \"&E17","v":"Total Admissions-Ambassadors"},null,null,{"$f":"+I19","v":1375},null,null,null,"Total Miscellaneous",730]
[null,"Tables and chairs",null,null,null,null,null,null,null,null,null,null,"Total Expenses",1527]
[null,"Omega Park Entrance Fee",{"$f":"(F19+F24)*18","v":342},null,"Admissions-Hosts"]
[null,"blank",null,null,null,"Estimated #","what","unit price",null,null,null,"Net Source and Use of Funds",null,{"$f":"+N10-N21","v":0}]
[null,{"$f":"+\"Total \"&A17","v":"Total Site"},{"$f":"SUM(C17:C23)","v":342},null,null,4,"Omega Park Entrance Fee",18,{"$f":"+H24*F24","v":72}]
[null,null,null,null,null,4,"Lunch",20,80]
["Decorations",null,null,null,null,null,null,null,0]
[null,"Flowers",null,null,null,null,null,null,0]
[null,"Candles",null,null,null,null,null,null,0]
[null,"Lighting",null,null,null,null,null,null,0]
[null,"Balloons",null,null,null,{"$f":"+\"Total \"&E22","v":"Total Admissions-Hosts"},null,null,{"$f":"SUM(I24:I29)","v":152}]
[null,"Paper supplies"]
[null,"blank",null,null,"Miscellaneous Source of Funds"]
[null,{"$f":"+\"Total \"&A26","v":"Total Decorations"},{"$f":"SUM(C26:C32)","v":0},null,null,"Estimated #","what","unit price"]
[null,null,null,null,null,null,null,null,{"$f":"+H34*F34","v":0}]
["Publicity",null,null,null,null,null,null,null,0]
[null,"Graphics work",null,null,null,null,null,null,0]
[null,"Photocopying/Printing",null,null,null,null,null,null,0]
[null,"Postage",null,null,null,null,null,null,0]
[null,"blank",null,null,null,null,null,null,0]
[null,"blank",null,null,null,{"$f":"+\"Total \"&E32","v":"Total Miscellaneous Source of Funds"},null,null,{"$f":"SUM(I34:I39)","v":0}]
[null,"blank"]
[null,{"$f":"+\"Total \"&A35","v":"Total Publicity"},{"$f":"SUM(C35:C41)","v":0}]
[]
["Refreshments"]
[null,"Lunch",{"$f":"(F19+F25)*20","v":380}]
[null,"Drinks"]
[null,"Linens"]
[null,"Staff and gratuities"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A44","v":"Total Refreshments"},{"$f":"SUM(C44:C50)","v":380}]
[]
["Program"]
[null,"Performers"]
[null,"Speakers"]
[null,"Travel"]
[null,"Hotel"]
[null,"Guide",75]
[null,"blank"]
[null,{"$f":"+\"Total \"&A53","v":"Total Program"},{"$f":"SUM(C53:C59)","v":75}]
[]
["Prizes"]
[null,"Ribbons/Plaques/Trophies"]
[null,"Gifts"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A62","v":"Total Prizes"},{"$f":"SUM(C62:C68)","v":0}]
[]
["Miscellaneous"]
[null,"Telephone"]
[null,"Transportation",700]
[null,"Stationery supplies"]
[null,"Fax services"]
[null,"Bus Driver Gratuities",{"$f":"F19*2","v":30}]
[null,"blank"]
[null,{"$f":"+\"Total \"&A71","v":"Total Miscellaneous"},{"$f":"SUM(C71:C77)","v":730}]

{"sheet":"Parliament","index":12,"n_rows":78,"n_cols":14,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,"2020-02-11",null,null,"In cell B1, enter the date in the format: day month year, such as: 25 Oct 2018."]
[null,{"$f":"IF(ISBLANK(B1),G19,IF(TYPE(B1)=1,G19&\" - \"&TEXT(B1,\"ddd\")&\", \"&TEXT(B1,\"dd mmm yyyy\"),\"Above date is invalid\"))","v":"Parliament - Tue, 11 Feb 2020"},null,null,null,null,null,{"$f":"\"In cell B2, to change the event name ''\"&G19&\"\"\", rename the tab\"","v":"In cell B2, to change the event name ''Parliament\", rename the tab"}]
[]
["Expenses",null,"Estimated $",null,"Source of Funds",null,null,null,"Estimated $",null,"Summary - Source and Use of Funds"]
[null,{"$f":"+B24","v":"Total Site"},{"$f":"+C24","v":0},null,null,null,{"$f":"+F20","v":"Total Admissions-Ambassadors"},null,{"$f":"+I20","v":150}]
[null,{"$f":"+B33","v":"Total Decorations"},{"$f":"+C33","v":0},null,null,null,{"$f":"+F30","v":"Total Admissions-Hosts"},null,{"$f":"+I30","v":0},null,null,{"$f":"+E4","v":"Source of Funds"},null,"Estimated $"]
[null,{"$f":"+B42","v":"Total Publicity"},{"$f":"+C42","v":0},null,null,null,{"$f":"+F40","v":"Total Miscellaneous Source of Funds"},null,{"$f":"+I40","v":0},null,null,null,{"$f":"+G5","v":"Total Admissions-Ambassadors"},{"$f":"+I5","v":150}]
[null,{"$f":"+B51","v":"Total Refreshments"},{"$f":"+C51","v":150},null,null,null,null,null,null,null,null,null,{"$f":"+G6","v":"Total Admissions-Hosts"},{"$f":"+I6","v":0}]
[null,{"$f":"+B60","v":"Total Program"},{"$f":"+C60","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G7","v":"Total Miscellaneous Source of Funds"},{"$f":"+I7","v":0}]
[null,{"$f":"+B69","v":"Total Prizes"},{"$f":"+C69","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G12","v":"Total Source of Funds"},{"$f":"+I12","v":150}]
[null,{"$f":"+B78","v":"Total Miscellaneous"},{"$f":"+C78","v":0}]
[null,{"$f":"+\"Total \"&A4","v":"Total Expenses"},{"$f":"SUM(C5:C11)","v":150},null,null,null,{"$f":"+\"Total \"&E4","v":"Total Source of Funds"},null,{"$f":"SUM(I5:I11)","v":150}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A4","v":"Expenses"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B5","v":"Total Site"},0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Decorations",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Publicity",0]
["Site",null,"Estimated",null,"Admissions-Ambassadors",null,null,null,"Estimated",null,null,null,"Total Refreshments",150]
[null,"Room and hall fees",null,null,null,"Estimated #","what","unit price",null,null,null,null,"Total Program",0]
[null,"Site staff",null,null,null,{"$f":"IF(BUDGET!I2>0,BUDGET!I2,\"\")","v":15},{"$f":"MID(CELL(\"filename\",A1),IF(ISNUMBER(FIND(\"]\",CELL(\"filename\",A1))),FIND(\"]\",CELL(\"filename\",A1))+1,FIND(\"#$\",CELL(\"filename\",A1))+2),31)","v":"Parliament"},{"$f":"IF(F19=\"\",0,(C12-I30-I40)/F19)","v":10},{"$f":"IF(F19<>\"\",+H19*F19,0)","v":150},null,null,null,"Total Prizes",0]
[null,"Equipment",null,null,null,{"$f":"+\"Total \"&E17","v":"Total Admissions-Ambassadors"},null,null,{"$f":"+I19","v":150},null,null,null,"Total Miscellaneous",0]
[null,"Tables and chairs",null,null,null,null,null,null,null,null,null,null,"Total Expenses",150]
[null,"blank",null,null,"Admissions-Hosts"]
[null,"blank",null,null,null,"Estimated #","what","unit price",null,null,null,"Net Source and Use of Funds",null,{"$f":"+N10-N21","v":0}]
[null,{"$f":"+\"Total \"&A17","v":"Total Site"},{"$f":"SUM(C17:C23)","v":0},null,null,null,null,null,{"$f":"+H24*F24","v":0}]
[null,null,null,null,null,null,null,null,0]
["Decorations",null,null,null,null,null,null,null,0]
[null,"Flowers",null,null,null,null,null,null,0]
[null,"Candles",null,null,null,null,null,null,0]
[null,"Lighting",null,null,null,null,null,null,0]
[null,"Balloons",null,null,null,{"$f":"+\"Total \"&E22","v":"Total Admissions-Hosts"},null,null,{"$f":"SUM(I24:I29)","v":0}]
[null,"Paper supplies"]
[null,"blank",null,null,"Miscellaneous Source of Funds"]
[null,{"$f":"+\"Total \"&A26","v":"Total Decorations"},{"$f":"SUM(C26:C32)","v":0},null,null,"Estimated #","what","unit price"]
[null,null,null,null,null,null,null,null,{"$f":"+H34*F34","v":0}]
["Publicity",null,null,null,null,null,null,null,0]
[null,"Graphics work",null,null,null,null,null,null,0]
[null,"Photocopying/Printing",null,null,null,null,null,null,0]
[null,"Postage",null,null,null,null,null,null,0]
[null,"blank",null,null,null,null,null,null,0]
[null,"blank",null,null,null,{"$f":"+\"Total \"&E32","v":"Total Miscellaneous Source of Funds"},null,null,{"$f":"SUM(I34:I39)","v":0}]
[null,"blank"]
[null,{"$f":"+\"Total \"&A35","v":"Total Publicity"},{"$f":"SUM(C35:C41)","v":0}]
[]
["Refreshments"]
[null,"Lunch-Snack",{"$f":"F19*10","v":150}]
[null,"Drinks"]
[null,"Linens"]
[null,"Staff and gratuities"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A44","v":"Total Refreshments"},{"$f":"SUM(C44:C50)","v":150}]
[]
["Program"]
[null,"Performers"]
[null,"Speakers"]
[null,"Travel"]
[null,"Hotel"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A53","v":"Total Program"},{"$f":"SUM(C53:C59)","v":0}]
[]
["Prizes"]
[null,"Ribbons/Plaques/Trophies"]
[null,"Gifts"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A62","v":"Total Prizes"},{"$f":"SUM(C62:C68)","v":0}]
[]
["Miscellaneous"]
[null,"Telephone"]
[null,"Transportation"]
[null,"Stationery supplies"]
[null,"Fax services"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A71","v":"Total Miscellaneous"},{"$f":"SUM(C71:C77)","v":0}]

{"sheet":"Event 8","index":13,"n_rows":78,"n_cols":14,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"In cell B1, enter the date in the format: day month year, such as: 25 Oct 2018."]
[null,{"$f":"IF(ISBLANK(B1),G19,IF(TYPE(B1)=1,G19&\" - \"&TEXT(B1,\"ddd\")&\", \"&TEXT(B1,\"dd mmm yyyy\"),\"Above date is invalid\"))","v":"Event 8"},null,null,null,null,null,{"$f":"\"In cell B2, to change the event name ''\"&G19&\"\"\", rename the tab\"","v":"In cell B2, to change the event name ''Event 8\", rename the tab"}]
[]
["Expenses",null,"Estimated $",null,"Source of Funds",null,null,null,"Estimated $",null,"Summary - Source and Use of Funds"]
[null,{"$f":"+B24","v":"Total Site"},{"$f":"+C24","v":0},null,null,null,{"$f":"+F20","v":"Total Admissions-Ambassadors"},null,{"$f":"+I20","v":0}]
[null,{"$f":"+B33","v":"Total Decorations"},{"$f":"+C33","v":0},null,null,null,{"$f":"+F30","v":"Total Admissions-Hosts"},null,{"$f":"+I30","v":0},null,null,{"$f":"+E4","v":"Source of Funds"},null,"Estimated $"]
[null,{"$f":"+B42","v":"Total Publicity"},{"$f":"+C42","v":0},null,null,null,{"$f":"+F40","v":"Total Miscellaneous Source of Funds"},null,{"$f":"+I40","v":0},null,null,null,{"$f":"+G5","v":"Total Admissions-Ambassadors"},{"$f":"+I5","v":0}]
[null,{"$f":"+B51","v":"Total Refreshments"},{"$f":"+C51","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G6","v":"Total Admissions-Hosts"},{"$f":"+I6","v":0}]
[null,{"$f":"+B60","v":"Total Program"},{"$f":"+C60","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G7","v":"Total Miscellaneous Source of Funds"},{"$f":"+I7","v":0}]
[null,{"$f":"+B69","v":"Total Prizes"},{"$f":"+C69","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G12","v":"Total Source of Funds"},{"$f":"+I12","v":0}]
[null,{"$f":"+B78","v":"Total Miscellaneous"},{"$f":"+C78","v":0}]
[null,{"$f":"+\"Total \"&A4","v":"Total Expenses"},{"$f":"SUM(C5:C11)","v":0},null,null,null,{"$f":"+\"Total \"&E4","v":"Total Source of Funds"},null,{"$f":"SUM(I5:I11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A4","v":"Expenses"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B5","v":"Total Site"},0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Decorations",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Publicity",0]
["Site",null,"Estimated",null,"Admissions-Ambassadors",null,null,null,"Estimated",null,null,null,"Total Refreshments",0]
[null,"Room and hall fees",null,null,null,"Estimated #","what","unit price",null,null,null,null,"Total Program",0]
[null,"Site staff",null,null,null,{"$f":"IF(BUDGET!I2>0,BUDGET!I2,\"\")","v":15},{"$f":"MID(CELL(\"filename\",A1),IF(ISNUMBER(FIND(\"]\",CELL(\"filename\",A1))),FIND(\"]\",CELL(\"filename\",A1))+1,FIND(\"#$\",CELL(\"filename\",A1))+2),31)","v":"Event 8"},{"$f":"IF(F19=\"\",0,(C12-I30-I40)/F19)","v":0},{"$f":"IF(F19<>\"\",+H19*F19,0)","v":0},null,null,null,"Total Prizes",0]
[null,"Equipment",null,null,null,{"$f":"+\"Total \"&E17","v":"Total Admissions-Ambassadors"},null,null,{"$f":"+I19","v":0},null,null,null,"Total Miscellaneous",0]
[null,"Tables and chairs",null,null,null,null,null,null,null,null,null,null,"Total Expenses",0]
[null,"blank",null,null,"Admissions-Hosts"]
[null,"blank",null,null,null,"Estimated #","what","unit price",null,null,null,"Net Source and Use of Funds",null,{"$f":"+N10-N21","v":0}]
[null,{"$f":"+\"Total \"&A17","v":"Total Site"},{"$f":"SUM(C17:C23)","v":0},null,null,null,null,null,{"$f":"+H24*F24","v":0}]
[null,null,null,null,null,null,null,null,0]
["Decorations",null,null,null,null,null,null,null,0]
[null,"Flowers",null,null,null,null,null,null,0]
[null,"Candles",null,null,null,null,null,null,0]
[null,"Lighting",null,null,null,null,null,null,0]
[null,"Balloons",null,null,null,{"$f":"+\"Total \"&E22","v":"Total Admissions-Hosts"},null,null,{"$f":"SUM(I24:I29)","v":0}]
[null,"Paper supplies"]
[null,"blank",null,null,"Miscellaneous Source of Funds"]
[null,{"$f":"+\"Total \"&A26","v":"Total Decorations"},{"$f":"SUM(C26:C32)","v":0},null,null,"Estimated #","what","unit price"]
[null,null,null,null,null,null,null,null,{"$f":"+H34*F34","v":0}]
["Publicity",null,null,null,null,null,null,null,0]
[null,"Graphics work",null,null,null,null,null,null,0]
[null,"Photocopying/Printing",null,null,null,null,null,null,0]
[null,"Postage",null,null,null,null,null,null,0]
[null,"blank",null,null,null,null,null,null,0]
[null,"blank",null,null,null,{"$f":"+\"Total \"&E32","v":"Total Miscellaneous Source of Funds"},null,null,{"$f":"SUM(I34:I39)","v":0}]
[null,"blank"]
[null,{"$f":"+\"Total \"&A35","v":"Total Publicity"},{"$f":"SUM(C35:C41)","v":0}]
[]
["Refreshments"]
[null,"Food"]
[null,"Drinks"]
[null,"Linens"]
[null,"Staff and gratuities"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A44","v":"Total Refreshments"},{"$f":"SUM(C44:C50)","v":0}]
[]
["Program"]
[null,"Performers"]
[null,"Speakers"]
[null,"Travel"]
[null,"Hotel"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A53","v":"Total Program"},{"$f":"SUM(C53:C59)","v":0}]
[]
["Prizes"]
[null,"Ribbons/Plaques/Trophies"]
[null,"Gifts"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A62","v":"Total Prizes"},{"$f":"SUM(C62:C68)","v":0}]
[]
["Miscellaneous"]
[null,"Telephone"]
[null,"Transportation"]
[null,"Stationery supplies"]
[null,"Fax services"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A71","v":"Total Miscellaneous"},{"$f":"SUM(C71:C77)","v":0}]

{"sheet":"Farewell","index":14,"n_rows":78,"n_cols":14,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,"2020-02-11",null,null,"In cell B1, enter the date in the format: day month year, such as: 25 Oct 2018."]
[null,{"$f":"IF(ISBLANK(B1),G19,IF(TYPE(B1)=1,G19&\" - \"&TEXT(B1,\"ddd\")&\", \"&TEXT(B1,\"dd mmm yyyy\"),\"Above date is invalid\"))","v":"Farewell - Tue, 11 Feb 2020"},null,null,null,null,null,{"$f":"\"In cell B2, to change the event name ''\"&G19&\"\"\", rename the tab\"","v":"In cell B2, to change the event name ''Farewell\", rename the tab"}]
[]
["Expenses",null,"Estimated $",null,"Source of Funds",null,null,null,"Estimated $",null,"Summary - Source and Use of Funds"]
[null,{"$f":"+B24","v":"Total Site"},{"$f":"+C24","v":0},null,null,null,{"$f":"+F20","v":"Total Admissions-Ambassadors"},null,{"$f":"+I20","v":600}]
[null,{"$f":"+B33","v":"Total Decorations"},{"$f":"+C33","v":0},null,null,null,{"$f":"+F30","v":"Total Admissions-Hosts"},null,{"$f":"+I30","v":600},null,null,{"$f":"+E4","v":"Source of Funds"},null,"Estimated $"]
[null,{"$f":"+B42","v":"Total Publicity"},{"$f":"+C42","v":0},null,null,null,{"$f":"+F40","v":"Total Miscellaneous Source of Funds"},null,{"$f":"+I40","v":0},null,null,null,{"$f":"+G5","v":"Total Admissions-Ambassadors"},{"$f":"+I5","v":600}]
[null,{"$f":"+B51","v":"Total Refreshments"},{"$f":"+C51","v":1200},null,null,null,null,null,null,null,null,null,{"$f":"+G6","v":"Total Admissions-Hosts"},{"$f":"+I6","v":600}]
[null,{"$f":"+B60","v":"Total Program"},{"$f":"+C60","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G7","v":"Total Miscellaneous Source of Funds"},{"$f":"+I7","v":0}]
[null,{"$f":"+B69","v":"Total Prizes"},{"$f":"+C69","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+G12","v":"Total Source of Funds"},{"$f":"+I12","v":1200}]
[null,{"$f":"+B78","v":"Total Miscellaneous"},{"$f":"+C78","v":0}]
[null,{"$f":"+\"Total \"&A4","v":"Total Expenses"},{"$f":"SUM(C5:C11)","v":1200},null,null,null,{"$f":"+\"Total \"&E4","v":"Total Source of Funds"},null,{"$f":"SUM(I5:I11)","v":1200}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A4","v":"Expenses"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B5","v":"Total Site"},{"$f":"+C5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Decorations",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Publicity",0]
["Site",null,"Estimated",null,"Admissions-Ambassadors",null,null,null,"Estimated",null,null,null,"Total Refreshments",1200]
[null,"Room and hall fees",null,null,null,"Estimated #","what","unit price",null,null,null,null,"Total Program",0]
[null,"Site staff"," ",null,null,{"$f":"IF(BUDGET!I2>0,BUDGET!I2,\"\")","v":15},{"$f":"MID(CELL(\"filename\",A1),IF(ISNUMBER(FIND(\"]\",CELL(\"filename\",A1))),FIND(\"]\",CELL(\"filename\",A1))+1,FIND(\"#$\",CELL(\"filename\",A1))+2),31)","v":"Farewell"},{"$f":"IF(F19=\"\",0,(C12-I30-I40)/F19)","v":40},{"$f":"IF(F19<>\"\",+H19*F19,0)","v":600},null,null,null,"Total Prizes",0]
[null,"Equipment",null,null,null,{"$f":"+\"Total \"&E17","v":"Total Admissions-Ambassadors"},null,null,{"$f":"+I19","v":600},null,null,null,"Total Miscellaneous",0]
[null,"Tables and chairs",null,null,null,null,null,null,null,null,null,null,"Total Expenses",1200]
[null,"blank",null,null,"Admissions-Hosts"]
[null,"blank",null,null,null,"Estimated #","what","unit price",null,null,null,"Net Source and Use of Funds",null,{"$f":"+N10-N21","v":0}]
[null,{"$f":"+\"Total \"&A17","v":"Total Site"},{"$f":"SUM(C17:C23)","v":0},null,null,15,"Food",40,{"$f":"+H24*F24","v":600}]
[null,null,null,null,null,null,null,null,0]
["Decorations",null,null,null,null,null,null,null,0]
[null,"Flowers",null,null,null,null,null,null,0]
[null,"Candles",null,null,null,null,null,null,0]
[null,"Lighting",null,null,null,null,null,null,0]
[null,"Balloons",null,null,null,{"$f":"+\"Total \"&E22","v":"Total Admissions-Hosts"},null,null,{"$f":"SUM(I24:I29)","v":600}]
[null,"Paper supplies"]
[null,"blank",null,null,"Miscellaneous Source of Funds"]
[null,{"$f":"+\"Total \"&A26","v":"Total Decorations"},{"$f":"SUM(C26:C32)","v":0},null,null,"Estimated #","what","unit price"]
[null,null,null,null,null,null,null,null,{"$f":"+H34*F34","v":0}]
["Publicity",null,null,null,null,null,null,null,0]
[null,"Graphics work",null,null,null,null,null,null,0]
[null,"Photocopying/Printing",null,null,null,null,null,null,0]
[null,"Postage",null,null,null,null,null,null,0]
[null,"blank",null,null,null,null,null,null,0]
[null,"blank",null,null,null,{"$f":"+\"Total \"&E32","v":"Total Miscellaneous Source of Funds"},null,null,{"$f":"SUM(I34:I39)","v":0}]
[null,"blank"]
[null,{"$f":"+\"Total \"&A35","v":"Total Publicity"},{"$f":"SUM(C35:C41)","v":0}]
[]
["Refreshments"]
[null,"Food",{"$f":"(F19+F24)*40","v":1200}]
[null,"Drinks"]
[null,"Linens"]
[null,"Staff and gratuities"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A44","v":"Total Refreshments"},{"$f":"SUM(C44:C50)","v":1200}]
[]
["Program"]
[null,"Performers"]
[null,"Speakers"]
[null,"Travel"]
[null,"Hotel"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A53","v":"Total Program"},{"$f":"SUM(C53:C59)","v":0}]
[]
["Prizes"]
[null,"Ribbons/Plaques/Trophies"]
[null,"Gifts"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A62","v":"Total Prizes"},{"$f":"SUM(C62:C68)","v":0}]
[]
["Miscellaneous"]
[null,"Telephone"]
[null,"Transportation"]
[null,"Stationery supplies"]
[null,"Fax services"]
[null,"blank"]
[null,"blank"]
[null,{"$f":"+\"Total \"&A71","v":"Total Miscellaneous"},{"$f":"SUM(C71:C77)","v":0}]

{"sheet":"SUMMARY-SOURCE & USE OF FUNDS","index":15,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Summary - Source and Use of Funds"]
[]
[null,"Source of Funds",null,"Estimated $","Actual $","Variance"]
[null,null,"Ambassador Receipts",{"$f":"IF(BUDGET!I40=\"\",0,BUDGET!I40)","v":5405.8600000000006},{"$f":"Journal!F84","v":5285.8},{"$f":"ROUND(E4-D4,2)","v":-120.06}]
[null,null,"Host Receipts",{"$f":"IF(BUDGET!L40=\"\",0,BUDGET!L40)","v":1280},{"$f":"Journal!F85","v":1280},{"$f":"ROUND(E5-D5,2)","v":0}]
[null,null,"Miscellaneous Receipts",{"$f":"IF(BUDGET!O40=\"\",0,BUDGET!O40)","v":0},{"$f":"Journal!F86","v":0},0]
[null,null,"Total Source of Funds",{"$f":"SUM(D4:D6)","v":6685.8600000000006},{"$f":"SUM(E4:E6)","v":6565.8},{"$f":"ROUND(SUM(F4:F6),2)","v":-120.06}]
[]
[]
[null,"Expenses"]
[null,null,{"$f":"+BUDGET!B6","v":"Welcome"},{"$f":"IF(BUDGET!F6=\"\",0,BUDGET!F6)","v":498.88},{"$f":"-Journal!F87","v":498.89},{"$f":"ROUND(E11-D11,2)","v":0.01}]
[null,null,{"$f":"+BUDGET!B7","v":"Escapade Eskimo"},{"$f":"IF(BUDGET!F7=\"\",0,BUDGET!F7)","v":1555},{"$f":"-Journal!F88","v":1551.1},-3.9]
[null,null,{"$f":"+BUDGET!B8","v":"Museum of History"},{"$f":"IF(BUDGET!F8=\"\",0,BUDGET!F8)","v":675},{"$f":"-Journal!F89","v":677.40000000000009},2.4]
[null,null,{"$f":"+BUDGET!B9","v":"Curling-Ice fishing"},{"$f":"IF(BUDGET!F9=\"\",0,BUDGET!F9)","v":550.98},{"$f":"-Journal!F90","v":551.97},0.99]
[null,null,{"$f":"+BUDGET!B10","v":"Winterlude"},{"$f":"IF(BUDGET!F10=\"\",0,BUDGET!F10)","v":150},{"$f":"-Journal!F91","v":150},0]
[null,null,{"$f":"+BUDGET!B11","v":"Omega Park"},{"$f":"IF(BUDGET!F11=\"\",0,BUDGET!F11)","v":1527},{"$f":"-Journal!F92","v":1529.92},2.92]
[null,null,{"$f":"+BUDGET!B12","v":"Parliament"},{"$f":"IF(BUDGET!F12=\"\",0,BUDGET!F12)","v":150},{"$f":"-Journal!F93","v":150},0]
[null,null,{"$f":"+BUDGET!B13","v":"Event 8"},{"$f":"IF(BUDGET!F13=\"\",0,BUDGET!F13)","v":0},{"$f":"-Journal!F94","v":0},0]
[null,null,{"$f":"+BUDGET!B14","v":"Farewell"},{"$f":"IF(BUDGET!F14=\"\",0,BUDGET!F14)","v":1200},{"$f":"-Journal!F95","v":1200},0]
[null,null,{"$f":"+BUDGET!B15","v":"Gift Bags"},{"$f":"IF(BUDGET!F15=\"\",0,BUDGET!F15)","v":120},{"$f":"-Journal!F96","v":138.75},18.75]
[null,null,{"$f":"+BUDGET!B16","v":"Photographs"},{"$f":"IF(BUDGET!F16=\"\",0,BUDGET!F16)","v":0},{"$f":"-Journal!F97","v":0},0]
[null,null,{"$f":"+BUDGET!B17","v":"Parking"},{"$f":"IF(BUDGET!F17=\"\",0,BUDGET!F17)","v":0},{"$f":"-Journal!F98","v":0},0]
[null,null,{"$f":"+BUDGET!B18","v":"Host Refund"},{"$f":"IF(BUDGET!F18=\"\",0,BUDGET!F18)","v":0},{"$f":"-Journal!F99","v":0},0]
[null,null,{"$f":"+BUDGET!B21","v":"FFI Fees"},{"$f":"IF(BUDGET!F21=\"\",0,BUDGET!F21)","v":0},{"$f":"-Journal!F100","v":0},0]
[null,null,{"$f":"+BUDGET!B22","v":"Hosting Fees"},{"$f":"IF(BUDGET!F22=\"\",0,BUDGET!F22)","v":0},{"$f":"-Journal!F101","v":0},0]
[null,null,{"$f":"+BUDGET!B23","v":"Post Journey Party"},{"$f":"IF(BUDGET!F23=\"\",0,BUDGET!F23)","v":0},{"$f":"-Journal!F102","v":0},0]
[null,null,{"$f":"+BUDGET!B24","v":"Wire Transfer Fee"},{"$f":"IF(BUDGET!F24=\"\",0,BUDGET!F24)","v":14},{"$f":"-Journal!F103","v":14},0]
[null,null,{"$f":"+BUDGET!B25","v":"Ambassador Booklets"},{"$f":"IF(BUDGET!F25=\"\",0,BUDGET!F25)","v":37.5},{"$f":"-Journal!F104","v":49.18},11.68]
[null,null,{"$f":"+BUDGET!B26","v":"Host Booklets"},{"$f":"IF(BUDGET!F26=\"\",0,BUDGET!F26)","v":0},{"$f":"-Journal!F105","v":0},0]
[null,null,{"$f":"+BUDGET!B27","v":"Club Gift"},{"$f":"IF(BUDGET!F27=\"\",0,BUDGET!F27)","v":15},{"$f":"-Journal!F106","v":18.32},3.32]
[null,null,{"$f":"+BUDGET!B28","v":"Bank Fees"},{"$f":"IF(BUDGET!F28=\"\",0,BUDGET!F28)","v":12.5},{"$f":"-Journal!F107","v":10},-2.5]
[null,null,{"$f":"+BUDGET!B29","v":"Committee Expenses"},{"$f":"IF(BUDGET!F29=\"\",0,BUDGET!F29)","v":0},{"$f":"-Journal!F108","v":2},2]
[null,null,{"$f":"+BUDGET!B30","v":"Contingency"},{"$f":"IF(BUDGET!F30=\"\",0,BUDGET!F30)","v":150},{"$f":"-Journal!F109","v":0},-150]
[null,null,{"$f":"+BUDGET!B31","v":"Ambassador Refund"},{"$f":"IF(BUDGET!F31=\"\",0,BUDGET!F31)","v":0},{"$f":"-Journal!F110","v":0},0]
[null,null,{"$f":"+BUDGET!B32","v":"Surplus to FFO"},{"$f":"IF(BUDGET!F32=\"\",0,BUDGET!F32)","v":0},{"$f":"-Journal!F111","v":1.67},1.67]
[null,null,{"$f":"+BUDGET!B33","v":"Memory Stick"},{"$f":"IF(BUDGET!F33=\"\",0,BUDGET!F33)","v":30},{"$f":"-Journal!F112","v":22.6},-7.4]
[null,null,{"$f":"+BUDGET!B34","v":"Exp blank 2"},{"$f":"IF(BUDGET!F34=\"\",0,BUDGET!F34)","v":0},{"$f":"-Journal!F113","v":0},0]
[null,null,{"$f":"+BUDGET!B35","v":"Exp blank 3"},{"$f":"IF(BUDGET!F35=\"\",0,BUDGET!F35)","v":0},{"$f":"-Journal!F114","v":0},0]
[null,null,{"$f":"+BUDGET!B36","v":"Exp blank 4"},{"$f":"IF(BUDGET!F36=\"\",0,BUDGET!F36)","v":0},{"$f":"-Journal!F115","v":0},0]
[null,null,{"$f":"+BUDGET!B37","v":"Exp blank 5"},{"$f":"IF(BUDGET!F37=\"\",0,BUDGET!F37)","v":0},{"$f":"-Journal!F116","v":0},0]
[null,null,{"$f":"+BUDGET!B38","v":"Exp blank 6"},{"$f":"IF(BUDGET!F38=\"\",0,BUDGET!F38)","v":0},{"$f":"-Journal!F117","v":0},0]
[null,null,{"$f":"+BUDGET!B39","v":"Exp blank 7"},{"$f":"IF(BUDGET!F39=\"\",0,BUDGET!F39)","v":0},{"$f":"-Journal!F118","v":0},0]
[null,null,"Total Expenses",{"$f":"SUM(D11:D42)","v":6685.8600000000006},{"$f":"SUM(E11:E42)","v":6565.8},{"$f":"ROUND(SUM(F11:F42),2)","v":-120.06}]
[]
[null,"Net Source and Use of Funds",null,{"$f":"+D7-D43","v":0},{"$f":"+E7-E43","v":0},{"$f":"ROUND(+F7-F43,2)","v":0}]