{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Import","Mapping","Transactions","Investments","Budget","Budget 2024","Net Worth","Setup"],"not_rendered":{"charts":26,"images":32,"macros":1,"external_links":0,"defined_names":82,"comments":7,"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":534,"n_cols":3,"rows_kept":534,"cut":false,"hidden":false,"merged":[]}
["moneyble.com","Read instructions before you begin"]
[]
[null,"Enable Macros \nThis file uses Excel Macros. You won't be able to use this template if Macros are not enabled"]
[]
[null,"You may see red error message like below… This is because this Excel file was downloaded from the internet"]
[null,"Read the article from Microsoft for instructions on how to fix it:"]
[null,"https://support.microsoft.com/en-us/topic/a-potentially-dangerous-macro-has-been-blocked-0952faa0-37e7-4316-b61d-5b5ed6024216"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Make a copy of this file. Use one copy as your master document. Another copy is a back up to look up formulas in case the master file is messed up. It is also a good idea to make back up copies of your master file periodically. Excel is great because it is flexible, but flexibility makes it a fragile tool too"]
[]
[null,"The main idea is to capture and classify all spending. \nWithout turning yourself into a personal finance freak. \nThis Excel file offers 4 ways to enter transactions:\n1) Cell phone transaction entry (iPhone / Android / Any other device with internet browser)\n2) Bank statement import (virtually all banks are supported. Any country. As long as your bank allows downloading transactions as a text file)\n3) Subscriptions that generate transactions based on schedule\n4) Manual entry with automatic formulas (see buttons under Moneyble ribbon)\nYou don't need to be entering transactions in Excel every day or keeping receipts. You can sync up transactions from your bank every couple of weeks. Or you can be entering transactions on the go on a cell phone and pull them into Excel periodically. More details below..."]
[]
["Table of contents","Transactions Sheet"]
[null,"Budgeting"]
[null,"Excel File Management"]
[null,"Import Bank Statements"]
[null,"Mobile Phone Expense Entry"]
[]
["Transactions Sheet","Transactions sheet has 3 sections:"]
["Back to TOC","- Normal regular transactions"]
[null,"- Forecast - Transactions that will happen in the near future (you can adjust horizon in days). \nIt let's you see your account balance on any given day within the horizon. Forecast is created from Subscriptions. You can also add an unplanned forecast transaction yourself"]
[null,"- Subscriptions - Transaction Schedule that generates Forecast Transactions. Example: Bills, Salary, other regular transactions"]
[null,"You can use all 3 sections or you can just use Normal transactions. Do not delete sections to avoid errors in formulas and macros. Just keep the section blank if you don't use it yet."]
[null,"Add all your recurring transactions as subscriptions. This step will take time initially. But it will be a timesaver in the future"]
[]
[null,"Imortant: When adding or deleting transactions - only use Add and Delete buttons on the Moneyble ribbon. Do not insert rows or delete rows with Excel's insert row / delete row. Ribbon buttons ensure the formulas are copied properly. If you add or delete records using normal Excel functions - you have to copy row formulas yourself starting from column R and everything to the right\nMoneyble ribbon comes with this file. It is not installed. It is just part of this file. It is meant to speed up common actions like filtering and editing transactions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hover over each button to see the description of what it does"]
[]
[null,"This template comes with 12 columns designed to hold 6 accounts. You can hide account columns that you don't use. You can add more accounts by copying one of the existing account column pairs. If you create more than 6 accounts - also copy the last column on Transactions sheet (Column \"AE\"). Columns \"Z\" through \"AE\" are used for filtering"]
[null,"You can hide columns or add more columns between \"B\" and \"E\". Keep it simple. This will save you time in the long run. Focus on the Budget, Savings, Net Worth rather than the transaction details"]
[null,"You can hide columns or add more columns in the rolling total section. Columns \"R\" \"S\" \"T\" and \"U\"\nAdjust formulas in columns \"R\" and \"S\" to reflect your account types"]
[null,"Do not remove or hide columns \"V\" through \"AE\". They are used by various buttons. Position of these columns might change if you add or remove columns before them. But they should start with column named \"Month\""]
[null,"You can make a copy of the Transactions sheet. You can keep one sheet for your every day accounts and another sheet for investments / savings. Or you may want to have a separate sheet for a special project. The same column / row structure but for different accounts. Moneyble Ribbon buttons will work on copies of Transactions sheet as long as you maintain the same sheet structure\nOne thing to remember: Import sheet is used to copy bank statements to the Transactions sheet. Import sheet will only import transactions to the original Transactions sheet"]
[null,"If you are using weekly subtotals in the Transactions sheet - you want these subtotal records to be excluded from formulas - put \"S\" in the column A (Date)."]
[null,"If Transactions sheet becomes slow due to a lot of data (2 years of data or more) - perform the following steps:\n1) Select large section of cells with formulas starting with column R: R3 to ACXXXX where XXXX is the row about 3 months in the past. Example if this is January select cells from the beginning of the Transactions sheet till about October of the prior year\n2) Copy (Ctrl +C)\n3) Don't change active cell. Stay where you are. Select Paste Special -> Values \n4) Close the file. Close Excel completely\n5) Reopen the file. It should perform faster now\nSlowliness is due to a lot of forumulas that need to be recalculated. If you replace these formulas with static values - Excel will become much more responsive. Excel can handle a lot of data. It just does not like recalculating a lot of formulas. \nAnd it is very unlikely that you will insert new transactions 3 months in the past. So these formulas in the past don't need to be recalculated"]
[]
["Budgeting","Start with simple (less than 10 categories) budget. You can always make it more complex later. You can also leverage subcategories or vendor/business name for ad-hoc filtering and search. Most people's brain cannot remember more than 5-10 numbers. And it is best if you know your monthly spend by category"]
["Back to TOC","Start with every day accounts first (checking and credit cards). You can add investment accounts, mortgage or other loans later. Best to create separate sheets for such"]
[null,"You can feed balances into the Net Worth sheet from various custom sheets: mortgage schedule, investment portfolio, etc."]
[null,"Create new Budget sheets for every new year by copying last year's Budget sheet and changing the year in column A1"]
[]
[null,"Budget Categories on Transactions Sheet and Budget Sheets are linked with formulas. As you start using new Budget Categories on the Transactions sheet - add them to the Budget sheets. Also add them to them to the bottom of the Setup sheet"]
[null,"As you add or remove budget categories on the Budget sheet - add them in one of the months. Then copy/paste the whole month section to the other months."]
[null,"Important: Make sure only the Budget Categories listed on the Budget sheets are used in the Transactions sheet. The only exceptions are:\n1) Transfers and \n2) Reimbursable expenses, Reimbursement payments. \nTransactions of these two types should net out to zero. This will ensure no transactions are missed when looking at the budget"]
[null,"One of the goals is to make sure your monthly income is always greater than your monthly expenses. Always."]
[]
["Excel File Management","If you place this Excel file in OneDrive or similar cloud - you can open it from a cell phone too."]
["Back to TOC","Columns can be renamed on most sheets"]
[null,"Excel sheets can be placed in any order"]
[null,"New sheets can be added"]
[null,"You can add (or remove) accounts on Net Worth sheet (as rows) and Transactions sheet (as columns)"]
[null,"You can copy columns F and G on Transactions sheet and rename them to create new accounts"]
[null,"Use first row on Net Worth sheet to define what periods (year and quarter) you want to see"]
[null,"Net Worth Sheet can be completely changed or replaced with your existing Net Worth sheet"]
[]
[]
["Import Bank Statements","This Excel template does not use nor store your online banking passwords"]
["Back to TOC","Import and Mapping sheets are used to import transactions from your bank statement into Transactions sheet"]
[null,"Download your bank statement (as CSV/text/Excel) from your online banking. Open it as text or Excel file. Copy-paste transactions to the Import sheet. Starting point is column A the cell right below the grey row"]
[null,"Account Order on Import Sheet (Column \"B\") determins the target columns on the Transactions Sheet (Columns F and G for Account Order = 1, Columns H and I for Account Order = 2, etc.)"]
[null,"Use the grey row to define the type of data in the columns. Check out values in the dropdown list of the cells in the grey row. Use Description 1, 2 and then 3 for columns that describe the vendor or provide any other useful information about the transaction. Text in such columns will be used to assign transactions to your descriptions based on the Mapping sheet"]
[null,"If the column data is not useful keep the column title blank"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Press Validate button. Review proposed transaction description on the right. Change any proposed values to what they should be."]
[null,"If you don't want certain transactions to be imported (they could have been entered already using subscriptions or manually) - Remove the amount in the table on the right-hand side"]
[null,"Use columns J, K, L, M on Import sheet to describe the transaction. You only need to do it once per each new vendor. Once the statement is imported the Mapping sheet will be updated automatically. Next time you import a transaction from the same vendor - it will pull columns J, K, L, M from the Mapping sheet.\nIf you don't want to update Mapping for a specific transaction during import - blank out Update Mapping column"]
[null,"Once you reviewed and adjusted transactions - press Copy to Transactions button"]
[null,"Review copied transactions and the new account balance on the Transactions sheet"]
[null,"Review Mapping sheet periodically. Remove city names, store numbers and other irrelevant information from Description columns (yellow) on the mapping sheet. Keep only the key words.\nExample:\nYour bank statement has a line like this as transaction description:\n\"WHOLEFDS GLA 10336       GLASTONBURY  CT AMT           239.59 \"\nThis whole description is written to the Mapping sheet. Mapped to Groceries - Whole Foods\nAfter you copy transactions - go to the Mapping sheet - remove all words after WHOLEFDS. Keep the mapping. Now all your future transactions in any WHOLEFDS will be mapped to Groceries - Whole Foods.\nIt will take time initially. But it will become faster once your frequently used vendors are in the Mapping sheet"]
[null,"You can use Amount column on the Mapping sheet. This is optional. You can create 2 mapping records that look the same with different amounts and drive them to different Budgets/Place/Tag/Comment combinations\nThis can be useful If you periodically send the same amount to different people. If all transfers look the same on your statement"]
[null,"I suggest importing bank statements for the last 6-12 months starting with the oldest. This will create transaction history and will allow you to analyze your spending / will help identify all subscriptions and frequent vendors in one shot.\nUse this data to set proper budgets suitable for you"]
[null,"Rename hyperlinks on the Import sheet and change account names in the blue row as requied. Use multiple Import Statement sections (1-5) if you are importing bank statements from different banks in different formats"]
[]
["Mobile Phone Expense Entry","Expense entry on a cell phone is done using Google Forms. \nThere is a little bit of work that has to happen. But below is a step-by-step instruction"]
["Back to TOC"]
[null,"High-level steps:"]
[null,"(1) Google Forms: Create Expense Entry Form"]
[null,"(2) Google Forms: Link Form Responses to Google Sheet"]
[null,"(3) Google Sheets: Publish Google Sheet"]
[null,"(4) Excel: Link Google Sheet to Excel"]
[null,"(5) Excel: Import Transaction from Google to Transactions sheet"]
[null,"(6) Excel and Google: Delete Processed Transactions (optional)"]
[]
["(1) Google Forms: Create Expense Entry Form"]
["Back to TOC"]
[null,"(1.1) Use the link below to make your own copy of the Moneyble Google Form.\nIf the link does not work go to step (1.4.1) below"]
[null,"https://docs.google.com/forms/d/1FINGPQZEvU2gZyoJf6akOmLZfLk3J6VGjQbSFwirSqg/copy"]
[]
[null,"The form has the following fields:"]
[null,"Date"]
[null,"Account *"]
[null,"Budget *"]
[null,"Place"]
[null,"Sub-Budget"]
[null,"Comment"]
[null,"Amount *"]
[null,"* - required fields"]
[null,"This Excel file is designed to work with these fields in this order. \nOptional fields can be left blank during form submission. "]
[null,"If the date is blank - today's date is used."]
[null,"(1.2) Rename Account values to match your accounts. Add or remove values as necessary. \nImportant: Choices entered on Google Form should exactly match the account names in the first row on the Transactions sheet in this Excel file. The order does not matter. But the name should be exact match. If you have accounts that you don't plan to use on mobile entry form - skip them. I.e. you can have 5 accounts in the Transactions sheet. But only 3 as choices in the Google Form. You will thank yourself later if you make Google Form simpler"]
[null,"(1.3) Rename Budget field choices to match your Budget. Add or remove values as necessary. \nAgain: Choices should match Expense Budget Categories in Excel on the Budget sheet. Likely you don't need Income Budget Categories on Google Form. But everyone's situation is different. You can change the Google Form later too. Keep the Budget Category called \"Other\" or \"General\" for miscellaneous. Do not use Google's built-in \"Other...\" option. Built-in \"Other...\" option will give you free-form text field. We do not want free-form. We only want specific Budget names as defined in this Excel"]
[null,"(1.4) Repeat above step for Place, Sub-Budget and Comment fields. You can also change field type from radiobutton multiple choice to just a short answer field type. If you keep the radiobuttons - make sure Google's built-in \"Other...\" option is included in all three fields to allow free-form text in addition to mulitple choice. Unlike Budget - these three fields should allow both: radiobuttons (to speed up transaction entry) and free-text values.\nIf you end up with long lists - sort the values alphabetically\nYou can update these values based on transaction histroy later"]
[null,"(1.5) Keep Date and Amount fields as is.\n\nDo not add or remove form fields at this point. Keep these fields. In this order. Once the form is connected to Excel you can add or remove fields. You can make the form as simple as Date, Budget and Amount. Or you can make additional fields to capture say the picture of the receipt."]
[]
[null,"Below steps are for creating Google Form from scratch. If you have completed steps (1.1-1.5) successfully - skip to step (1.6)"]
[]
[null,"(1.4.1) Open google.com"]
[null,"(1.4.2) Click the apps button in the top right corner. Scroll down. Click on Forms"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"(1.4.3) Create new Blank form. Form Title can be anything. Expense Entry sounds simple"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"(1.4.4) Important: Create the following 7 form entry fields. Use exact names as outlined below. Use exact same order and types"]
[]
[null,"1. Name: Date"]
[null,"Type: Date"]
[]
[null,"2. Name: Account"]
[null,"Type: Multiple Choice"]
[null,"Important: Choices entered should exactly match the account names in the first row on the Transactions sheet in this Excel file. If you have accounts that you don't plan to use on mobile entry form - skip them. I.e. you can have 5 accounts in the Transactions sheet. But only 3 as choices in the Google Form. You will thank yourself if you make Google Form simpler"]
[]
[null,"3. Name: Budget"]
[null,"Type: Multiple Choice"]
[null,"Again: Choices should match Expense Budget Categories in Excel on Budget sheet. Likely you don't need Income Budget Categories on Google Form. But everyone's situation is different. You can enter both expenses and income if you like. You can add more budget categories later too."]
[]
[null,"4. Name: Place"]
[null,"Type: Short Answer or Multiple choice with Other… option"]
[]
[null,"5. Name: Sub-Budget"]
[null,"Type: Short Answer or Multiple choice with Other… option"]
[]
[null,"6. Name: Comment"]
[null,"Type: Short Answer or Multiple choice with Other… option"]
[]
[null,"7. Name: Amount"]
[null,"Type: Short Answer"]
[null,"Response Validation: Is Number"]
[]
[null,"That's it for now. You can change this form in the future as you add new accounts or start tracking different budgets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"(1.6) Test your Form by clicking Preview button (top right corner)"]
[]
[]
[]
[]
[]
[]
[]
[null,"(1.7) Fill in the form at least once. Click Submit. We need at least one form response for testing. \nNote: For the first entry provide values in all fields - this will prevent issues with cell type formats in Excel. In the future - you can leave optional fields blank"]
[]
[null,"(1.8) Close Form Preview mode in browser. Go back to the Design mode"]
[null,"https://docs.google.com/forms/u/0/"]
[]
[null,"(1.9) Add this form to your cell phone's home screen. \nClick Send button in Form Design view to get hyperlink to the form. The easiest way is to email the link to yourself. Then open the hyperlink on your cell phone in Chrome or Safari. Follow the screenshots below to add Google Form to you home screen as an app icon"]
[]
[]
[null,"Android Chrome browser","iPhone Safari"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["(2) Google Forms: Link Form Responses to Google Sheet"]
["Back to TOC"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["(3) Google Sheets: Publish Google Sheet to the Web"]
["Back to TOC"]
[null,"(3.1) Google Sheet window will open up automatically. Click Share button"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"(3.2) Change access to \"Anyone with the link\". Then click Copy link"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["(4) Excel: Link Google Sheet to Excel"]
["Back to TOC"]
[null,"(4.1) In this Excel file open Import Sheet. Click Mobile Phone hyperlink (Cell A1). Select cell B2504. Paste Google link in this cell. \nNote: The link contains unique Google Sheet ID of your newly created Google Sheet: long gibberish part after https://docs.google.com/spreadsheets/d/"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"(4.2) Click Create Google Table button"]
[]
[null,"A new table appears in Excel Import sheet. It should contain at least one record for the Form Response you've made previously"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["(5) Excel: Import Transaction from Google to Transactions sheet"]
["Back to TOC"]
[null,"Note: Refresh button will fetch new records from Google. You don't have to click this button at this step since the record(s) were already fetched. But you will use this button in the future"]
[]
[null,"(5.1) Review transaction(s). Make sure Account name (column C) matches exactly the name(s) specified on Transactions sheet in row 1. Update Transactions sheet if necessary"]
[]
[null,"(5.2) Click Copy to Transactions button"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["(6) Excel and Google: Delete Processed Transactions (optional)"]
["Back to TOC"]
[null,"Steps below are completely optional. Expense transactions will remain in Google Form and Google Sheets. But these transactions will be ignored. You can leave them be. Or you can periodically delete them"]
[]
[null,"To delete transactions from Google Sheets click Open Google Sheets and Delete Processed Transactions button"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Accept message to Skip Verification"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"-> Select All Rows with data -> Right-Click -> Delete"]
[]
[]
[null,"This button will clear the table in Excel. But Google Sheets table has to be cleared manually. \nA new browser window will pop up with Google Sheets. Select all rows with data in Google Sheets. Right Click. Delete Rows X-X"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"It is counterintuitive. But Google stores data in the Google Form and Google Sheets separately\nTo delete transactions from Google Form open Google Form -> Responses -> three-dot button -> Delete all responses. Again: completely optional. Nothing will break if they stay there forever"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This is it. You can enter expenses on your cell phone and sync them up to Excel. Enjoy!"]
[]
["Back to TOC"]
[]
[]
["If you have suggestions / improvement ideas - please send me an email at moneyble.com@gmail.com"]

{"sheet":"Import","index":1,"n_rows":2504,"n_cols":100,"rows_kept":2504,"cut":false,"hidden":false,"merged":[]}
["Mobile Phone","Statement 1","Statement 2","Statement 3","Statement 4","Statement 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,15,269,255,254]
[]
["Bank Statement Import"]
["Go to Top"]
[]
["Account Order:",3,null,null,"Import From Date","2024-10-01"]
["Amount Rounding","Round to 5",null,null,"Reverse Amount Column","No"]
[]
["Date Column","Amount Column",null,"Description 2","Description 1",null,null,null,"Date","Budget","Place","Tag","Comment","+","-","Update Mapping"]
["2024-10-07",-17.46,"-","POS Purchase           ","FPOS GRAND BAY HH BLDG CTGRAND",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,5]
["2024-10-10",-59.17,"-","POS Purchase           ","TIM HORTONS #2633        ST. ANDREWS  NB ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,null,19]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bank Statement Import"]
["Go to Top"]
[]
["Account Order:",2,null,null,"Import From Date","2024-08-06"]
["Amount Rounding","Round to 5",null,null,"Reverse Amount Column","No"]
[]
["Date Column","Description 1","Amount Column",null,null,null,null,null,"Date","Budget","Place","Tag","Comment","+","-","Update Mapping"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bank Statement Import"]
["Go to Top"]
[]
["Account Order:",3,null,null,"Import From Date","2024-08-06"]
["Amount Rounding","Round to 5",null,null,"Reverse Amount Column","No"]
[]
["Date Column","Amount Column",null,"Description 2","Description 1",null,null,null,"Date","Budget","Place","Tag","Comment","+","-","Update Mapping"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bank Statement Import"]
["Go to Top"]
[]
["Account Order:",4,null,null,"Import From Date","2024-08-06"]
["Amount Rounding","Round to 5",null,null,"Reverse Amount Column","No"]
[]
["Date Column","Amount Column",null,"Description 2","Description 1",null,null,null,"Date","Budget","Place","Tag","Comment","+","-","Update Mapping"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bank Statement Import"]
["Go to Top"]
[]
["Account Order:",5,null,null,"Import From Date","2024-08-06"]
["Amount Rounding","Round to 5",null,null,"Reverse Amount Column","No"]
[]
["Date Column","Amount Column",null,"Description 2","Description 1",null,null,null,"Date","Budget","Place","Tag","Comment","+","-","Update Mapping"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Transaction Import from Mobile Phone"]
["Go to Top",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Important: Periodically manually delete all rows in the Google Sheets table"]
["Google Sheet ID:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel cannot modify Google Sheets"]
["Google Sheet Link:"]

{"sheet":"Mapping","index":2,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Description 1","Description 2","Description 3","Amount",null,"Budget","Place","Tag","Comment","Columns B, C, D are optional. Fill them only if needed"]
["Mcdonald's",null,null,null,null,"Entertainment","McDonalds","Eat-out","West"]
["Bell Aliant",null,null,null,null,"Bills","Bell","Utilities","Internet"]
["FOODLAND",null,null,null,null,"Groceries","Sobeys"]
["FPOS GRAND BAY HH BLDG CTGRAND",null,null,null,null,"Shopping","HomeHardware"]
["TD ON-LINE",null,null,null,null,"Car","TD","Loan"]
["VIRGIN MOBILE",null,null,null,null,"Bills","Virgin","Utilities","Phone"]
["WWW COSTCO",null,null,null,null,"Groceries","Costco"]
["Ikea",null,null,null,null,"Other","Ikea","House","Closet"]
["CDN TIRE STORE ",null,null,null,null,"Shopping","Canadian Tire","Me","Tools"]
["FREE INTERAC E-TRANSFER","WITHDRAWAL             ",null,105,null,"Reimbursement","Rose","Nata","Acupuncture"]
["FREE INTERAC E-TRANSFER","WITHDRAWAL             ",null,315,null,"Reimbursement","Cheryl","Nata","Acupuncture"]
["HM Hennes  Mauritz Inc.  Toronto      ON ",null,null,null,null,"Shopping","H&M","Nata","Clothes"]
["Amazon.ca Prime Member   amazon.ca/priBC ",null,null,null,null,"Bills","Amazon","Subscription","Prime"]
["PETSMART INC. 2263       MONCTON      NB ",null,null,null,null,"Groceries","Petsmart Inc.","Cat","Food"]
["WHOLEFDS",null,null,null,null,"Groceries","Whole Foods"]
["STAPLES STORE ",null,null,null,null,"Shopping","Staples","Kids","Back to School"]
["PUBLIC MOBILE            855-4782542  BC ",null,null,null,null,"Bills","Public Mobile","Daniella","Cell Phone"]
["TIM HORTONS ",null,null,null,null,"Entertainment","Tim Hortons","Eat-out"]
["SQ *MCGUIRE CHOCOLATE COMSaint AndrewsNB ",null,null,null,null,"Entertainment","St Andrews","Ice-cream"]
["CIRCLE K / IRVING ",null,null,null,null,"Car","Irving","Prius","Gas"]
["HARBOUR STATION          506-632-6103 NB ",null,null,null,null,"Entertainment","Harbour Station","Tickets"]
["Amazon.ca",null,null,null,null,"Shopping","Amazon"]
["TEMU.COM",null,null,null,null,"Shopping","Temu"]
["DESIGNER BRANDS SHOES    NORTH YORK   ON ",null,null,null,null,"Shopping","Shoe Company",null,"Shoes"]
["CAN TIRE STORE ",null,null,null,null,"Shopping","Canadian Tire","Me","Tools"]
["HM Hennes  Mauritz Inc.  Toronto      ON ",null,null,null,null,"Shopping","H&M",null,"Clothes"]
["Amazon.ca Prime Member   amazon.ca/priBC ",null,null,null,null,"Bills","Amazon","Subscription","Prime"]
["PETSMART INC.",null,null,null,null,"Groceries","PetSmart","Cat","Food"]
["NETFLIX.COM              866-716-0414 ON ",null,null,null,null,"Bills","Netflix","Utilities","TV"]
["TIM HORTONS ",null,null,null,null,"Entertainment","Tim Hortons","Eating Out"]
[" AMZN Mktp",null,null,null,null,"Shopping","Amazon"]
["AMAZON*",null,null,null,null,"Shopping","Amazon"]
["SEQUOIA ON TRINITY       MONCTON      NB ",null,null,null,null,"Groceries","Sequoia","Groceries"]
["SOBEYS ",null,null,null,null,"Groceries","Sobeys","Groceries"]
["NO FRILLS",null,null,null,null,"Groceries","Superstore","Groceries"]

{"sheet":"Transactions","index":3,"n_rows":42,"n_cols":104,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Date ↓","Budget","Place","Sub-Budget","Comment","Cash","Cr1","Checking","Cr2","Visa","Cr3","MasterCard","Cr4","Visa2","Cr5","Wife's Checking","Cr6","Debit","Credit Cards","Balance","Reimbursements","Month","Year","Amount","Forecast","Account 1","Account 2","Account 3","Account 4","Account 5","Account 6"]
["2021-12-31","Initial Balance",null,null,null,100,null,5000,null,null,3000,null,0,null,0,0,null,{"$f":"F2+H2+P2-G2-I2-Q2","v":5100},{"$f":"J2+L2+N2-K2-M2-O2","v":-3000},{"$f":"F2+H2+J2+L2+N2+P2-G2-I2-K2-M2-O2-Q2","v":2100},null,{"$f":"MONTH(A2)","v":12},{"$f":"YEAR(A2)","v":2021},{"$f":"F2+H2+J2+L2+N2+P2-G2-I2-K2-M2-O2-Q2","v":2100},null,{"$f":"F2-G2","v":100},{"$f":"H2-I2","v":5000},{"$f":"J2-K2","v":-3000},{"$f":"L2-M2","v":0},{"$f":"N2-O2","v":0},{"$f":"P2-Q2","v":0}]
["2024-10-27","Groceries","Superstore",null,null,null,null,null,null,null,390,null,null,null,null,null,null,{"$f":"R2+F3+H3+P3-G3-I3-Q3","v":5100},{"$f":"S2+J3+L3+N3-K3-M3-O3","v":-3390},{"$f":"T2+F3+H3+J3+L3+N3+P3-G3-I3-K3-M3-O3-Q3","v":1710},{"$f":"IF(B3=\"Reimbursement\",U2+X3,IF(B3=\"Settled\",U2+X3,U2))","v":0},{"$f":"MONTH(A3)","v":10},{"$f":"YEAR(A3)","v":2024},{"$f":"F3+H3+J3+L3+N3+P3-G3-I3-K3-M3-O3-Q3","v":-390},null,{"$f":"F3-G3","v":0},{"$f":"H3-I3","v":0},{"$f":"J3-K3","v":-390},{"$f":"L3-M3","v":0},{"$f":"N3-O3","v":0},{"$f":"P3-Q3","v":0}]
["2024-10-28","Shopping","Amazon","Electronics","Media Player",null,null,null,null,null,95,null,null,null,null,null,null,{"$f":"R3+F4+H4+P4-G4-I4-Q4","v":5100},{"$f":"S3+J4+L4+N4-K4-M4-O4","v":-3485},{"$f":"T3+F4+H4+J4+L4+N4+P4-G4-I4-K4-M4-O4-Q4","v":1615},{"$f":"IF(B4=\"Reimbursement\",U3+X4,IF(B4=\"Settled\",U3+X4,U3))","v":0},10,2024,{"$f":"F4+H4+J4+L4+N4+P4-G4-I4-K4-M4-O4-Q4","v":-95},null,{"$f":"F4-G4","v":0},{"$f":"H4-I4","v":0},{"$f":"J4-K4","v":-95},{"$f":"L4-M4","v":0},{"$f":"N4-O4","v":0},{"$f":"P4-Q4","v":0}]
["2024-10-29","Bills","Virgin","Utilities","Cell Phone",null,null,null,null,null,40,null,null,null,null,null,null,{"$f":"R4+F5+H5+P5-G5-I5-Q5","v":5100},{"$f":"S4+J5+L5+N5-K5-M5-O5","v":-3525},{"$f":"T4+F5+H5+J5+L5+N5+P5-G5-I5-K5-M5-O5-Q5","v":1575},0,10,2024,{"$f":"F5+H5+J5+L5+N5+P5-G5-I5-K5-M5-O5-Q5","v":-40},null,{"$f":"F5-G5","v":0},{"$f":"H5-I5","v":0},{"$f":"J5-K5","v":-40},{"$f":"L5-M5","v":0},{"$f":"N5-O5","v":0},{"$f":"P5-Q5","v":0}]
["2024-10-29","Salary","Employer 1",null,null,null,null,3000,null,null,null,null,null,null,null,null,null,8100,-3525,4575,0,10,2024,3000,null,0,3000,0,0,0,0]
["2024-10-29","Bills","RBC","Mortgage","Interest",null,null,null,400,null,null,null,null,null,null,null,null,{"$f":"R6+F7+H7+P7-G7-I7-Q7","v":7700},{"$f":"S6+J7+L7+N7-K7-M7-O7","v":-3525},{"$f":"T6+F7+H7+J7+L7+N7+P7-G7-I7-K7-M7-O7-Q7","v":4175},0,10,2024,{"$f":"F7+H7+J7+L7+N7+P7-G7-I7-K7-M7-O7-Q7","v":-400},null,{"$f":"F7-G7","v":0},{"$f":"H7-I7","v":-400},{"$f":"J7-K7","v":0},{"$f":"L7-M7","v":0},{"$f":"N7-O7","v":0},{"$f":"P7-Q7","v":0}]
["2024-10-29","Savings","RBC","Mortgage","Principal",null,null,null,1200,null,null,null,null,null,null,null,null,{"$f":"R7+F8+H8+P8-G8-I8-Q8","v":6500},{"$f":"S7+J8+L8+N8-K8-M8-O8","v":-3525},{"$f":"T7+F8+H8+J8+L8+N8+P8-G8-I8-K8-M8-O8-Q8","v":2975},0,10,2024,{"$f":"F8+H8+J8+L8+N8+P8-G8-I8-K8-M8-O8-Q8","v":-1200},null,{"$f":"F8-G8","v":0},{"$f":"H8-I8","v":-1200},{"$f":"J8-K8","v":0},{"$f":"L8-M8","v":0},{"$f":"N8-O8","v":0},{"$f":"P8-Q8","v":0}]
["2024-10-29","Car","TD","Insurance","Auto",null,null,null,null,null,200,null,null,null,null,null,null,{"$f":"R8+F9+H9+P9-G9-I9-Q9","v":6500},{"$f":"S8+J9+L9+N9-K9-M9-O9","v":-3725},{"$f":"T8+F9+H9+J9+L9+N9+P9-G9-I9-K9-M9-O9-Q9","v":2775},0,10,2024,{"$f":"F9+H9+J9+L9+N9+P9-G9-I9-K9-M9-O9-Q9","v":-200},null,{"$f":"F9-G9","v":0},{"$f":"H9-I9","v":0},{"$f":"J9-K9","v":-200},{"$f":"L9-M9","v":0},{"$f":"N9-O9","v":0},{"$f":"P9-Q9","v":0}]
["2024-10-30","Reimbursement","Rose","Me","Acupuncture",null,null,null,100,null,null,null,null,null,null,null,null,{"$f":"R9+F10+H10+P10-G10-I10-Q10","v":6400},{"$f":"S9+J10+L10+N10-K10-M10-O10","v":-3725},{"$f":"T9+F10+H10+J10+L10+N10+P10-G10-I10-K10-M10-O10-Q10","v":2675},-100,10,2024,{"$f":"F10+H10+J10+L10+N10+P10-G10-I10-K10-M10-O10-Q10","v":-100},null,{"$f":"F10-G10","v":0},{"$f":"H10-I10","v":-100},{"$f":"J10-K10","v":0},{"$f":"L10-M10","v":0},{"$f":"N10-O10","v":0},{"$f":"P10-Q10","v":0}]
["2024-10-30","Health","Rose","Me","Acupuncture",null,null,null,20,null,null,null,null,null,null,null,null,{"$f":"R10+F11+H11+P11-G11-I11-Q11","v":6380},{"$f":"S10+J11+L11+N11-K11-M11-O11","v":-3725},{"$f":"T10+F11+H11+J11+L11+N11+P11-G11-I11-K11-M11-O11-Q11","v":2655},{"$f":"IF(B11=\"Reimbursement\",U10+X11,IF(B11=\"Settled\",U10+X11,U10))","v":-100},{"$f":"MONTH(A11)","v":10},{"$f":"YEAR(A11)","v":2024},{"$f":"F11+H11+J11+L11+N11+P11-G11-I11-K11-M11-O11-Q11","v":-20},null,{"$f":"F11-G11","v":0},{"$f":"H11-I11","v":-20},{"$f":"J11-K11","v":0},{"$f":"L11-M11","v":0},{"$f":"N11-O11","v":0},{"$f":"P11-Q11","v":0}]
["2024-11-01","Reimbursement","Rose","Me","Acupuncture",null,null,100,null,null,null,null,null,null,null,null,null,{"$f":"R11+F12+H12+P12-G12-I12-Q12","v":6480},{"$f":"S11+J12+L12+N12-K12-M12-O12","v":-3725},{"$f":"T11+F12+H12+J12+L12+N12+P12-G12-I12-K12-M12-O12-Q12","v":2755},{"$f":"IF(B12=\"Reimbursement\",U11+X12,IF(B12=\"Settled\",U11+X12,U11))","v":0},{"$f":"MONTH(A12)","v":11},{"$f":"YEAR(A12)","v":2024},{"$f":"F12+H12+J12+L12+N12+P12-G12-I12-K12-M12-O12-Q12","v":100},null,{"$f":"F12-G12","v":0},{"$f":"H12-I12","v":100},{"$f":"J12-K12","v":0},{"$f":"L12-M12","v":0},{"$f":"N12-O12","v":0},{"$f":"P12-Q12","v":0}]
["2024-11-01","Transfer","SCOTIA","Credit Card",null,null,null,null,2245,2245,null,null,null,null,null,null,null,{"$f":"R12+F13+H13+P13-G13-I13-Q13","v":4235},{"$f":"S12+J13+L13+N13-K13-M13-O13","v":-1480},{"$f":"T12+F13+H13+J13+L13+N13+P13-G13-I13-K13-M13-O13-Q13","v":2755},{"$f":"IF(B13=\"Reimbursement\",U12+X13,IF(B13=\"Settled\",U12+X13,U12))","v":0},{"$f":"MONTH(A13)","v":11},{"$f":"YEAR(A13)","v":2024},{"$f":"F13+H13+J13+L13+N13+P13-G13-I13-K13-M13-O13-Q13","v":0},null,{"$f":"F13-G13","v":0},{"$f":"H13-I13","v":-2245},{"$f":"J13-K13","v":2245},{"$f":"L13-M13","v":0},{"$f":"N13-O13","v":0},{"$f":"P13-Q13","v":0}]
[null,"Account Balance",null,null,null,null,{"$f":"SUMIFS(F$2:F13,$A$2:$A13,\"<>S\",$A$2:$A13,\"<>\")-SUMIFS(G$2:G13,$A$2:$A13,\"<>S\",$A$2:$A13,\"<>\")","v":100},null,{"$f":"SUMIFS(H$2:H13,$A$2:$A13,\"<>S\",$A$2:$A13,\"<>\")-SUMIFS(I$2:I13,$A$2:$A13,\"<>S\",$A$2:$A13,\"<>\")","v":4135},null,{"$f":"SUMIFS(J$2:J13,$A$2:$A13,\"<>S\",$A$2:$A13,\"<>\")-SUMIFS(K$2:K13,$A$2:$A13,\"<>S\",$A$2:$A13,\"<>\")","v":-1480},null,{"$f":"SUMIFS(L$2:L13,$A$2:$A13,\"<>S\",$A$2:$A13,\"<>\")-SUMIFS(M$2:M13,$A$2:$A13,\"<>S\",$A$2:$A13,\"<>\")","v":0},null,{"$f":"SUMIFS(N$2:N13,$A$2:$A13,\"<>S\",$A$2:$A13,\"<>\")-SUMIFS(O$2:O13,$A$2:$A13,\"<>S\",$A$2:$A13,\"<>\")","v":0},null,{"$f":"SUMIFS(P$2:P13,$A$2:$A13,\"<>S\",$A$2:$A13,\"<>\")-SUMIFS(Q$2:Q13,$A$2:$A13,\"<>S\",$A$2:$A13,\"<>\")","v":0},{"$f":"G14+I14+Q14","v":4235},{"$f":"K14+M14+O14","v":-1480},{"$f":"G14+I14+K14+M14+O14+Q14","v":2755},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Do not delete the values to the left of this text. It's used in macros to identify this row."]
["2024-11-05","Savings","SCOTIA","RESP","Deposit",null,null,null,400,null,null,null,null,null,null,null,null,{"$f":"R14+F15+H15+P15-G15-I15-Q15","v":3835},{"$f":"S14+J15+L15+N15-K15-M15-O15","v":-1480},{"$f":"T14+F15+H15+J15+L15+N15+P15-G15-I15-K15-M15-O15-Q15","v":2355},0,{"$f":"MONTH(A15)","v":11},{"$f":"YEAR(A15)","v":2024},{"$f":"F15+H15+J15+L15+N15+P15-G15-I15-K15-M15-O15-Q15","v":-400},{"$f":"\"F\"","v":"F"},{"$f":"F15-G15","v":0},{"$f":"H15-I15","v":-400},{"$f":"J15-K15","v":0},{"$f":"L15-M15","v":0},{"$f":"N15-O15","v":0},{"$f":"P15-Q15","v":0}]
["2024-11-08","Salary","KIK",null,null,null,null,3000,null,null,null,null,null,null,null,null,null,{"$f":"R15+F16+H16+P16-G16-I16-Q16","v":6835},{"$f":"S15+J16+L16+N16-K16-M16-O16","v":-1480},{"$f":"T15+F16+H16+J16+L16+N16+P16-G16-I16-K16-M16-O16-Q16","v":5355},0,11,2024,{"$f":"F16+H16+J16+L16+N16+P16-G16-I16-K16-M16-O16-Q16","v":3000},"F",{"$f":"F16-G16","v":0},{"$f":"H16-I16","v":3000},{"$f":"J16-K16","v":0},{"$f":"L16-M16","v":0},{"$f":"N16-O16","v":0},{"$f":"P16-Q16","v":0}]
["2024-11-10","Bills","NB Power","Utilities","Electricity",null,null,null,300,null,null,null,null,null,null,null,null,6535,-1480,5055,0,11,2024,{"$f":"F17+H17+J17+L17+N17+P17-G17-I17-K17-M17-O17-Q17","v":-300},"F",{"$f":"F17-G17","v":0},{"$f":"H17-I17","v":-300},{"$f":"J17-K17","v":0},{"$f":"L17-M17","v":0},{"$f":"N17-O17","v":0},{"$f":"P17-Q17","v":0}]
["2024-11-17","Bills","TD","House","Insurance",null,null,null,null,null,175,null,null,null,null,null,null,{"$f":"R17+F18+H18+P18-G18-I18-Q18","v":6535},{"$f":"S17+J18+L18+N18-K18-M18-O18","v":-1655},{"$f":"T17+F18+H18+J18+L18+N18+P18-G18-I18-K18-M18-O18-Q18","v":4880},0,11,2024,-175,"F",0,0,-175,0,0,0]
["2024-11-19","Bills","Aliant","Utilities","TV+Internet",null,null,null,null,null,100,null,null,null,null,null,null,{"$f":"R18+F19+H19+P19-G19-I19-Q19","v":6535},{"$f":"S18+J19+L19+N19-K19-M19-O19","v":-1755},{"$f":"T18+F19+H19+J19+L19+N19+P19-G19-I19-K19-M19-O19-Q19","v":4780},0,11,2024,-100,"F",0,0,-100,0,0,0]
["2024-11-19","Other Income","SCOTIA","Cashback","Visa",null,null,null,null,1000,null,null,null,null,null,null,null,{"$f":"R19+F20+H20+P20-G20-I20-Q20","v":6535},{"$f":"S19+J20+L20+N20-K20-M20-O20","v":-755},{"$f":"T19+F20+H20+J20+L20+N20+P20-G20-I20-K20-M20-O20-Q20","v":5780},0,11,2024,1000,"F",0,0,1000,0,0,0]
["2024-11-22","Salary","Employer 1",null,null,null,null,3000,null,null,null,null,null,null,null,null,null,{"$f":"R20+F21+H21+P21-G21-I21-Q21","v":9535},{"$f":"S20+J21+L21+N21-K21-M21-O21","v":-755},{"$f":"T20+F21+H21+J21+L21+N21+P21-G21-I21-K21-M21-O21-Q21","v":8780},0,11,2024,{"$f":"F21+H21+J21+L21+N21+P21-G21-I21-K21-M21-O21-Q21","v":3000},"F",{"$f":"F21-G21","v":0},{"$f":"H21-I21","v":3000},{"$f":"J21-K21","v":0},{"$f":"L21-M21","v":0},{"$f":"N21-O21","v":0},{"$f":"P21-Q21","v":0}]
["2024-11-29","Bills","Virgin","Utilities","Cell Phone",null,null,null,null,null,40,null,null,null,null,null,null,{"$f":"R21+F22+H22+P22-G22-I22-Q22","v":9535},{"$f":"S21+J22+L22+N22-K22-M22-O22","v":-795},{"$f":"T21+F22+H22+J22+L22+N22+P22-G22-I22-K22-M22-O22-Q22","v":8740},0,11,2024,{"$f":"F22+H22+J22+L22+N22+P22-G22-I22-K22-M22-O22-Q22","v":-40},"F",{"$f":"F22-G22","v":0},{"$f":"H22-I22","v":0},{"$f":"J22-K22","v":-40},{"$f":"L22-M22","v":0},{"$f":"N22-O22","v":0},{"$f":"P22-Q22","v":0}]
["2024-11-29","Bills","RBC","Mortgage","Interest",null,null,null,400,null,null,null,null,null,null,null,null,{"$f":"R22+F23+H23+P23-G23-I23-Q23","v":9135},{"$f":"S22+J23+L23+N23-K23-M23-O23","v":-795},{"$f":"T22+F23+H23+J23+L23+N23+P23-G23-I23-K23-M23-O23-Q23","v":8340},0,11,2024,{"$f":"F23+H23+J23+L23+N23+P23-G23-I23-K23-M23-O23-Q23","v":-400},"F",{"$f":"F23-G23","v":0},{"$f":"H23-I23","v":-400},{"$f":"J23-K23","v":0},{"$f":"L23-M23","v":0},{"$f":"N23-O23","v":0},{"$f":"P23-Q23","v":0}]
["2024-11-29","Savings","RBC","Mortgage","Principal",null,null,null,1200,null,null,null,null,null,null,null,null,{"$f":"R23+F24+H24+P24-G24-I24-Q24","v":7935},{"$f":"S23+J24+L24+N24-K24-M24-O24","v":-795},{"$f":"T23+F24+H24+J24+L24+N24+P24-G24-I24-K24-M24-O24-Q24","v":7140},0,11,2024,{"$f":"F24+H24+J24+L24+N24+P24-G24-I24-K24-M24-O24-Q24","v":-1200},"F",{"$f":"F24-G24","v":0},{"$f":"H24-I24","v":-1200},{"$f":"J24-K24","v":0},{"$f":"L24-M24","v":0},{"$f":"N24-O24","v":0},{"$f":"P24-Q24","v":0}]
["2024-11-29","Car","TD","Insurance","Auto",null,null,null,null,null,200,null,null,null,null,null,null,{"$f":"R24+F25+H25+P25-G25-I25-Q25","v":7935},{"$f":"S24+J25+L25+N25-K25-M25-O25","v":-995},{"$f":"T24+F25+H25+J25+L25+N25+P25-G25-I25-K25-M25-O25-Q25","v":6940},0,11,2024,{"$f":"F25+H25+J25+L25+N25+P25-G25-I25-K25-M25-O25-Q25","v":-200},"F",{"$f":"F25-G25","v":0},{"$f":"H25-I25","v":0},{"$f":"J25-K25","v":-200},{"$f":"L25-M25","v":0},{"$f":"N25-O25","v":0},{"$f":"P25-Q25","v":0}]
["2024-12-01","Transfer","SCOTIA",null,null,null,null,null,3000,3000,null,null,null,null,null,null,null,4935,2005,6940,0,12,2024,0,"F",0,-3000,3000,0,0,0]
[null,"Forecasted Balance",null,null,null,null,{"$f":"SUMIFS(F$2:F26,$A$2:$A26,\"<>S\",$A$2:$A26,\"<>\")-SUMIFS(G$2:G26,$A$2:$A26,\"<>S\",$A$2:$A26,\"<>\")","v":100},null,{"$f":"SUMIFS(H$2:H26,$A$2:$A26,\"<>S\",$A$2:$A26,\"<>\")-SUMIFS(I$2:I26,$A$2:$A26,\"<>S\",$A$2:$A26,\"<>\")","v":4835},null,{"$f":"SUMIFS(J$2:J26,$A$2:$A26,\"<>S\",$A$2:$A26,\"<>\")-SUMIFS(K$2:K26,$A$2:$A26,\"<>S\",$A$2:$A26,\"<>\")","v":2005},null,{"$f":"SUMIFS(L$2:L26,$A$2:$A26,\"<>S\",$A$2:$A26,\"<>\")-SUMIFS(M$2:M26,$A$2:$A26,\"<>S\",$A$2:$A26,\"<>\")","v":0},null,{"$f":"SUMIFS(N$2:N26,$A$2:$A26,\"<>S\",$A$2:$A26,\"<>\")-SUMIFS(O$2:O26,$A$2:$A26,\"<>S\",$A$2:$A26,\"<>\")","v":0},null,{"$f":"SUMIFS(P$2:P26,$A$2:$A26,\"<>S\",$A$2:$A26,\"<>\")-SUMIFS(Q$2:Q26,$A$2:$A26,\"<>S\",$A$2:$A26,\"<>\")","v":0},{"$f":"G27+I27+Q27","v":4935},{"$f":"K27+M27+O27","v":2005},{"$f":"G27+I27+K27+M27+O27+Q27","v":6940},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Do not delete the values to the left of this text. It's used in macros to identify this row."]
[]
[]
["Start Date","Subscriptions","Horizon: 30 days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Do not delete the values to the left of this text. It's used in macros to identify this row."]
["2024-12-06","Salary","Employer 1",null,null,null,null,3000,null,null,null,null,null,null,null,null,null,null,null,"Bi-Weekly"]
["2024-12-05","Savings","SCOTIA","RESP","Deposit",null,null,null,400,null,null,null,null,null,null,null,null,null,null,"Monthly"]
["2025-01-01","Transfer","SCOTIA",null,null,null,null,null,3000,3000,null,null,null,null,null,null,null,null,null,"Monthly"]
["2024-12-17","Bills","TD","House","Insurance",null,null,null,null,null,175,null,null,null,null,null,null,null,null,"Monthly"]
["2024-12-19","Bills","Aliant","Utilities","TV+Internet",null,null,null,null,null,100,null,null,null,null,null,null,null,null,"Monthly"]
["2024-12-29","Bills","RBC","Mortgage","Interest",null,null,null,400,null,null,null,null,null,null,null,null,null,null,"Monthly"]
["2024-12-29","Savings","RBC","Mortgage","Principal",null,null,null,1200,null,null,null,null,null,null,null,null,null,null,"Monthly"]
["2024-12-29","Car","TD","Insurance","Auto",null,null,null,null,null,200,null,null,null,null,null,null,null,null,"Monthly"]
["2024-12-29","Bills","Virgin","Utilities","Cell Phone",null,null,null,null,null,40,null,null,null,null,null,null,null,null,"Monthly"]
["2025-01-15","Other Income","Government","Climate",null,null,null,260,null,null,null,null,null,null,null,null,null,null,null,"Quarterly"]
["2025-09-20","Other","SCOTIA","Cashback","Visa Annual Fee",null,null,null,null,null,120,null,null,null,null,null,null,null,null,"Annual"]
["2025-11-19","Other Income","SCOTIA","Cashback","Visa",null,null,null,null,1000,null,null,null,null,null,null,null,null,null,"Annual"]

{"sheet":"Investments","index":4,"n_rows":42,"n_cols":106,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Date ↓","Budget","Place","Sub-Budget","Comment","Savings","Cr1","RRSP","Cr2","RPP","Cr3","RESP","Cr4","iTrade Me","Cr5","iTrade Wife","Cr6","iTrade Exchange","Cr7","Short-Term","Long-Term","Balance","Month","Year","Amount","Forecast","Savings","RRSP","RPP","RESP","Scotia Me","Scotia Wife","Scotia Exchange",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not delete these values:",4065,4081,4084,2374]
["2021-12-31","Initial Balance",null,null,null,5000,null,150000,null,23180,null,68655,null,null,null,null,null,null,null,{"$f":"F2+N2+P2+R2-G2-O2-Q2-S2","v":5000},{"$f":"H2+J2+L2-I2-K2-M2","v":241835},{"$f":"F2+H2+J2+L2+N2+P2+R2-G2-I2-K2-M2-O2-Q2-S2","v":246835},{"$f":"MONTH(A2)","v":12},{"$f":"YEAR(A2)","v":2021},{"$f":"F2+H2+J2+L2+N2+P2+R2-G2-I2-K2-M2-O2-Q2-S2","v":246835},null,{"$f":"F2-G2","v":5000},{"$f":"H2-I2","v":150000},{"$f":"J2-K2","v":23180},{"$f":"L2-M2","v":68655},{"$f":"N2-O2","v":0},{"$f":"P2-Q2","v":0},{"$f":"R2-S2","v":0}]
["2024-06-21","Pension","Employer 1","RPP","Deposit",null,null,null,null,450,null,null,null,null,null,null,null,null,null,{"$f":"T2+F3+N3+P3+R3-G3-O3-Q3-S3","v":5000},{"$f":"U2+H3+J3+L3-I3-K3-M3","v":242285},{"$f":"V2+F3+H3+J3+L3+N3+P3+R3-G3-I3-K3-M3-O3-Q3-S3","v":247285},{"$f":"MONTH(A3)","v":6},{"$f":"YEAR(A3)","v":2024},{"$f":"F3+H3+J3+L3+N3+P3+R3-G3-I3-K3-M3-O3-Q3-S3","v":450},null,{"$f":"F3-G3","v":0},{"$f":"H3-I3","v":0},{"$f":"J3-K3","v":450},{"$f":"L3-M3","v":0},{"$f":"N3-O3","v":0},{"$f":"P3-Q3","v":0},{"$f":"R3-S3","v":0}]
["2024-06-30","Growth","Manulife","RPP","Interest 5%",null,null,null,null,1515,null,null,null,null,null,null,null,null,null,5000,243800,248800,6,2024,1515,null,0,0,1515,0,0,0,0]
["2024-06-30","Pension","Desjardins","RRSP","Interest 5%",null,null,10665,null,null,null,null,null,null,null,null,null,null,null,5000,254465,259465,6,2024,10665,null,0,10665,0,0,0,0,0]
["2024-07-04","Transfer","Scotia","Contribution","CAD to USD",null,5000,null,null,null,null,null,null,3695,null,null,null,1305,null,5000,254465,259465,{"$f":"MONTH(A6)","v":7},{"$f":"YEAR(A6)","v":2024},{"$f":"F6+H6+J6+L6+N6+P6+R6-G6-I6-K6-M6-O6-Q6-S6","v":0},null,{"$f":"F6-G6","v":-5000},{"$f":"H6-I6","v":0},{"$f":"J6-K6","v":0},{"$f":"L6-M6","v":0},{"$f":"N6-O6","v":3695},{"$f":"P6-Q6","v":0},{"$f":"R6-S6","v":1305}]
["2024-07-04","Stocks","Scotia","Trade","29NVDA@127",null,null,null,null,null,null,null,null,3685,3685,null,null,null,null,5000,254465,259465,7,2024,0,null,0,0,0,0,0,0,0]
["2024-07-05","Kids Education","SCOTIA","RESP","Deposit",null,null,null,null,null,null,400,null,null,null,null,null,null,null,5000,254865,259865,7,2024,400,null,0,0,0,400,0,0,0]
["2024-07-05","Pension","Employer 1","RPP","Deposit",null,null,null,null,450,null,null,null,null,null,null,null,null,null,5000,255315,260315,{"$f":"MONTH(A9)","v":7},{"$f":"YEAR(A9)","v":2024},450,null,0,0,450,0,0,0,0]
["2024-07-22","Pension","Employer 1","RPP","Deposit",null,null,null,null,450,null,null,null,null,null,null,null,null,null,5000,255765,260765,7,2024,{"$f":"F10+H10+J10+L10+N10+P10+R10-G10-I10-K10-M10-O10-Q10-S10","v":450},null,0,0,450,0,0,0,{"$f":"R10-S10","v":0}]
["2024-08-01","Growth","Government","RESP","Grant",null,null,null,null,null,null,80,null,null,null,null,null,null,null,5000,255845,260845,8,2024,80,null,0,0,0,80,0,0,0]
["2024-08-02","Pension","Employer 1","RPP","Deposit",null,null,null,null,450,null,null,null,null,null,null,null,null,null,5000,256295,261295,8,2024,450,null,0,0,450,0,0,0,0]
["2024-08-05","Kids Education","SCOTIA","RESP","Deposit",null,null,null,null,null,null,400,null,null,null,null,null,null,null,5000,256695,261695,8,2024,400,null,0,0,0,400,0,0,0]
["2024-08-16","Pension","Employer 1","RPP","Deposit",null,null,null,null,450,null,null,null,null,null,null,null,null,null,5000,257145,262145,8,2024,450,null,0,0,450,0,0,0,0]
["2024-08-29","Pension","Employer 1","RPP","Deposit",null,null,null,null,450,null,null,null,null,null,null,null,null,null,5000,257595,262595,8,2024,450,null,0,0,450,0,0,0,0]
["2024-09-01","Growth","Government","RESP","Grant",null,null,null,null,null,null,80,null,null,null,null,null,null,null,5000,257675,262675,9,2024,80,null,0,0,0,80,0,0,0]
["2024-09-05","Kids Education","SCOTIA","RESP","Deposit",null,null,null,null,null,null,400,null,null,null,null,null,null,null,5000,258075,263075,9,2024,400,null,0,0,0,400,0,0,0]
["2024-09-13","Pension","Employer 1","RPP","Deposit",null,null,null,null,450,null,null,null,null,null,null,null,null,null,5000,258525,263525,9,2024,450,null,0,0,450,0,0,0,0]
["2024-09-27","Pension","Employer 1","RPP","Deposit",null,null,null,null,450,null,null,null,null,null,null,null,null,null,5000,258975,263975,9,2024,450,null,0,0,450,0,0,0,0]
["2024-09-30","Growth","SCOTIA","RESP","Interest 9%",null,null,null,null,null,null,6010,null,null,null,null,null,null,null,5000,264985,269985,{"$f":"MONTH(A20)","v":9},{"$f":"YEAR(A20)","v":2024},{"$f":"F20+H20+J20+L20+N20+P20+R20-G20-I20-K20-M20-O20-Q20-S20","v":6010},null,0,0,0,6010,0,0,{"$f":"R20-S20","v":0}]
["2024-09-30","Growth","Manulife","RPP","Interest 4%",null,null,null,null,1460,null,null,null,null,null,null,null,null,null,5000,266445,271445,9,2024,1460,null,0,0,1460,0,0,0,0]
["2024-09-30","Pension","Desjardins","RRSP","Interest 4%",null,null,9740,null,null,null,null,null,null,null,null,null,null,null,5000,276185,281185,9,2024,9740,null,{"$f":"F22-G22","v":0},{"$f":"H22-I22","v":9740},{"$f":"J22-K22","v":0},{"$f":"L22-M22","v":0},{"$f":"N22-O22","v":0},{"$f":"P22-Q22","v":0},0]
["2024-09-30","Stocks","Scotia","Growth",null,null,null,null,null,null,null,null,null,485,null,null,null,280,null,5765,276185,281950,9,2024,765,null,{"$f":"F23-G23","v":0},{"$f":"H23-I23","v":0},{"$f":"J23-K23","v":0},{"$f":"L23-M23","v":0},{"$f":"N23-O23","v":485},{"$f":"P23-Q23","v":0},280]
["2024-10-01","Growth","Government","RESP","Grant",null,null,null,null,null,null,80,null,null,null,null,null,null,null,5765,276265,282030,10,2024,80,null,{"$f":"F24-G24","v":0},{"$f":"H24-I24","v":0},{"$f":"J24-K24","v":0},{"$f":"L24-M24","v":80},{"$f":"N24-O24","v":0},{"$f":"P24-Q24","v":0},0]
["2024-10-05","Kids Education","SCOTIA","RESP","Deposit",null,null,null,null,null,null,400,null,null,null,null,null,null,null,5765,276665,282430,{"$f":"MONTH(A25)","v":10},{"$f":"YEAR(A25)","v":2024},{"$f":"F25+H25+J25+L25+N25+P25+R25-G25-I25-K25-M25-O25-Q25-S25","v":400},null,0,0,0,400,0,0,{"$f":"R25-S25","v":0}]
["2024-10-11","Pension","Employer 1","RPP","Deposit",null,null,null,null,450,null,null,null,null,null,null,null,null,null,5765,277115,282880,10,2024,450,null,{"$f":"F26-G26","v":0},{"$f":"H26-I26","v":0},{"$f":"J26-K26","v":450},{"$f":"L26-M26","v":0},{"$f":"N26-O26","v":0},{"$f":"P26-Q26","v":0},0]
["2024-10-25","Pension","Employer 1","RPP","Deposit",null,null,null,null,450,null,null,null,null,null,null,null,null,null,5765,277565,283330,10,2024,450,null,{"$f":"F27-G27","v":0},{"$f":"H27-I27","v":0},{"$f":"J27-K27","v":450},{"$f":"L27-M27","v":0},{"$f":"N27-O27","v":0},{"$f":"P27-Q27","v":0},0]
[null,"Account Balance",null,null,null,null,{"$f":"SUMIFS(F$2:F27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")-SUMIFS(G$2:G27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")","v":0},null,{"$f":"SUMIFS(H$2:H27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")-SUMIFS(I$2:I27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")","v":170405},null,{"$f":"SUMIFS(J$2:J27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")-SUMIFS(K$2:K27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")","v":30655},null,{"$f":"SUMIFS(L$2:L27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")-SUMIFS(M$2:M27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")","v":76505},null,{"$f":"SUMIFS(N$2:N27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")-SUMIFS(O$2:O27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")","v":4180},null,{"$f":"SUMIFS(P$2:P27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")-SUMIFS(Q$2:Q27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")","v":0},null,{"$f":"SUMIFS(R$2:R27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")-SUMIFS(S$2:S27,$A$2:$A27,\"<>S\",$A$2:$A27,\"<>\")","v":1585},{"$f":"G28+O28+Q28+S28","v":5765},{"$f":"I28+K28+M28","v":277565},{"$f":"G28+I28+K28+M28+O28+Q28+S28","v":283330},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Key123","Do not delete the values to the left of this text. It's used in macros to identify this row."]
["2024-11-01","Kids Education","Government","RESP","Grant",null,null,null,null,null,null,80,null,null,null,null,null,null,null,{"$f":"T28+F29+N29+P29+R29-G29-O29-Q29-S29","v":5765},{"$f":"U28+H29+J29+L29-I29-K29-M29","v":277645},{"$f":"V28+F29+H29+J29+L29+N29+P29+R29-G29-I29-K29-M29-O29-Q29-S29","v":283410},{"$f":"MONTH(A29)","v":11},{"$f":"YEAR(A29)","v":2024},{"$f":"F29+H29+J29+L29+N29+P29-G29-I29-K29-M29-O29-Q29","v":80},{"$f":"\"F\"","v":"F"},{"$f":"F29-G29","v":0},{"$f":"H29-I29","v":0},{"$f":"J29-K29","v":0},{"$f":"L29-M29","v":80},{"$f":"N29-O29","v":0},{"$f":"P29-Q29","v":0},{"$f":"R29-S29","v":0}]
["2024-11-05","Kids Education","Me","RESP","Deposit",null,null,null,null,null,null,400,null,null,null,null,null,null,null,5765,278045,283810,{"$f":"MONTH(A30)","v":11},{"$f":"YEAR(A30)","v":2024},{"$f":"F30+H30+J30+L30+N30+P30-G30-I30-K30-M30-O30-Q30","v":400},"F",{"$f":"F30-G30","v":0},{"$f":"H30-I30","v":0},{"$f":"J30-K30","v":0},{"$f":"L30-M30","v":400},{"$f":"N30-O30","v":0},{"$f":"P30-Q30","v":0},{"$f":"R30-S30","v":0}]
["2024-11-08","Pension","Employer 1","RPP","Deposit",null,null,null,null,450,null,null,null,null,null,null,null,null,null,5765,278495,284260,{"$f":"MONTH(A31)","v":11},{"$f":"YEAR(A31)","v":2024},{"$f":"F31+H31+J31+L31+N31+P31+R31-G31-I31-K31-M31-O31-Q31-S31","v":450},"F",{"$f":"F31-G31","v":0},{"$f":"H31-I31","v":0},{"$f":"J31-K31","v":450},{"$f":"L31-M31","v":0},{"$f":"N31-O31","v":0},{"$f":"P31-Q31","v":0},{"$f":"R31-S31","v":0}]
["2024-11-22","Pension","Employer 1","RPP","Deposit",null,null,null,null,450,null,null,null,null,null,null,null,null,null,{"$f":"T31+F32+N32+P32+R32-G32-O32-Q32-S32","v":5765},{"$f":"U31+H32+J32+L32-I32-K32-M32","v":278945},{"$f":"V31+F32+H32+J32+L32+N32+P32+R32-G32-I32-K32-M32-O32-Q32-S32","v":284710},{"$f":"MONTH(A32)","v":11},{"$f":"YEAR(A32)","v":2024},{"$f":"F32+H32+J32+L32+N32+P32-G32-I32-K32-M32-O32-Q32","v":450},"F",{"$f":"F32-G32","v":0},{"$f":"H32-I32","v":0},{"$f":"J32-K32","v":450},{"$f":"L32-M32","v":0},{"$f":"N32-O32","v":0},{"$f":"P32-Q32","v":0},{"$f":"R32-S32","v":0}]
[null,"Forecasted Balance",null,null,null,null,{"$f":"SUMIFS(F$2:F32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")-SUMIFS(G$2:G32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")","v":0},null,{"$f":"SUMIFS(H$2:H32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")-SUMIFS(I$2:I32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")","v":170405},null,{"$f":"SUMIFS(J$2:J32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")-SUMIFS(K$2:K32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")","v":31555},null,{"$f":"SUMIFS(L$2:L32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")-SUMIFS(M$2:M32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")","v":76985},null,{"$f":"SUMIFS(N$2:N32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")-SUMIFS(O$2:O32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")","v":4180},null,{"$f":"SUMIFS(P$2:P32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")-SUMIFS(Q$2:Q32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")","v":0},null,{"$f":"SUMIFS(R$2:R32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")-SUMIFS(S$2:S32,$A$2:$A32,\"<>S\",$A$2:$A32,\"<>\")","v":1585},{"$f":"G33+O33+Q33+S33","v":5765},{"$f":"I33+K33+M33","v":278945},{"$f":"G33+I33+K33+M33+O33+Q33+S33","v":284710},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Key456","Do not delete the values to the left of this text. It's used in macros to identify this row."]
[]
[]
["Start Date","Subscriptions","Horizon: 30 days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Key789","Do not delete the values to the left of this text. It's used in macros to identify this row."]
["2024-12-06","Pension","Employer 1","RPP","Deposit",null,null,null,null,450,null,null,null,null,null,null,null,null,null,null,null,"Bi-Weekly"]
["2024-12-01","Kids Education","Government","RESP","Grant",null,null,null,null,null,null,80,null,null,null,null,null,null,null,null,null,"Monthly"]
["2024-12-05","Kids Education","Me","RESP","Deposit",null,null,null,null,null,null,400,null,null,null,null,null,null,null,null,null,"Monthly"]
["2024-12-30","Growth","Desjardins","RRSP","Interest",null,null,5000,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quarterly"]
["2024-12-30","Growth","Manulife","RPP","Interest",null,null,null,null,1000,null,null,null,null,null,null,null,null,null,null,null,"Quarterly"]
["2024-12-30","Growth","Scotia","RESP","Interest",null,null,null,null,null,null,5000,null,null,null,null,null,null,null,null,null,"Quarterly"]

{"sheet":"Budget","index":5,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Income",null,null,null,null,null,"Expenses"]
["Budget Category","Last Year Same Period","Last Month","Budget","Percent",null,"Budget Category","Last Year Same Period","Last Month","Avg Last \n3 \nMonths","Budget","Percent"]
["Salary",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":3000},6000,{"$f":"IncBudgetTable[[#This Row],[Budget]]/IncBudgetTable[[#Totals],[Budget]]","v":0.89219330855018586},null,"Groceries",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":390},{"$f":"AVERAGE(SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-3,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-4,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]))*-1","v":130},1185,{"$f":"ExpBudgetTable[[#This Row],[Budget]]/ExpBudgetTable[[#Totals],[Budget]]","v":0.24559585492227978}]
["Bonus",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":0},null,{"$f":"IncBudgetTable[[#This Row],[Budget]]/IncBudgetTable[[#Totals],[Budget]]","v":0},null,"Entertainment",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":0},{"$f":"AVERAGE(SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-3,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-4,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]))*-1","v":0},400,{"$f":"ExpBudgetTable[[#This Row],[Budget]]/ExpBudgetTable[[#Totals],[Budget]]","v":8.2901554404145081E-2}]
["Kids",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":0},725,{"$f":"IncBudgetTable[[#This Row],[Budget]]/IncBudgetTable[[#Totals],[Budget]]","v":0.10780669144981413},null,"Shopping",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":95},{"$f":"AVERAGE(SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-3,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-4,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]))*-1","v":31.666666666666668},500,{"$f":"ExpBudgetTable[[#This Row],[Budget]]/ExpBudgetTable[[#Totals],[Budget]]","v":0.10362694300518134}]
["Side Project",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":0},null,{"$f":"IncBudgetTable[[#This Row],[Budget]]/IncBudgetTable[[#Totals],[Budget]]","v":0},null,"Bills",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":440},{"$f":"AVERAGE(SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-3,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-4,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]))*-1","v":146.66666666666666},1500,{"$f":"ExpBudgetTable[[#This Row],[Budget]]/ExpBudgetTable[[#Totals],[Budget]]","v":0.31088082901554404}]
["Other Income",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":0},null,{"$f":"IncBudgetTable[[#This Row],[Budget]]/IncBudgetTable[[#Totals],[Budget]]","v":0},null,"Car",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":200},{"$f":"AVERAGE(SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-3,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-4,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]))*-1","v":66.666666666666671},640,{"$f":"ExpBudgetTable[[#This Row],[Budget]]/ExpBudgetTable[[#Totals],[Budget]]","v":0.13264248704663212}]
[null,null,{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":0},null,null,null,"Charity",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":0},{"$f":"AVERAGE(SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-3,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-4,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]))*-1","v":0},400,{"$f":"ExpBudgetTable[[#This Row],[Budget]]/ExpBudgetTable[[#Totals],[Budget]]","v":8.2901554404145081E-2}]
[null,null,{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":0},null,null,null,"Health",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":20},{"$f":"AVERAGE(SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-3,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-4,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]))*-1","v":6.666666666666667},200,{"$f":"ExpBudgetTable[[#This Row],[Budget]]/ExpBudgetTable[[#Totals],[Budget]]","v":4.145077720207254E-2}]
[null,{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,IncBudgetTable[[#This Row],[Budget Category]])","v":0},null,null,null,"Other",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]])*-1","v":0},{"$f":"AVERAGE(SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-3,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-4,12)+1,Transactions!B:B,ExpBudgetTable[[#This Row],[Budget Category]]))*-1","v":0},null,{"$f":"ExpBudgetTable[[#This Row],[Budget]]/ExpBudgetTable[[#Totals],[Budget]]","v":0},null,"Savings",{"$f":"IncBudgetTable[[#Totals],[Budget]]-ExpBudgetTable[[#Totals],[Budget]]","v":1900}]
["Total",null,null,{"$f":"SUBTOTAL(109,IncBudgetTable[Budget])","v":6725},{"$f":"SUBTOTAL(109,IncBudgetTable[Percent])","v":1},null,"Total",null,null,null,{"$f":"SUBTOTAL(109,ExpBudgetTable[Budget])","v":4825},{"$f":"SUBTOTAL(109,ExpBudgetTable[Percent])","v":1},null,"Savings to Income Ratio",{"$f":"(IncBudgetTable[[#Totals],[Budget]]-ExpBudgetTable[[#Totals],[Budget]])/IncBudgetTable[[#Totals],[Budget]]","v":0.28252788104089221}]
[]
["Investments",null,null,null,null,null,"Savings"]
["Budget Category","Last Year Same Period","Last Month","Budget","Percent",null,"Budget Category","Last Year Same Period","Last Month","Avg Last \n3 \nMonths","Budget","Percent"]
["Stocks",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,InvBudgetTable[[#This Row],[Budget Category]])","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,InvBudgetTable[[#This Row],[Budget Category]])","v":0},null,{"$f":"InvBudgetTable[[#This Row],[Budget]]/InvBudgetTable[[#Totals],[Budget]]","v":0},null,"Mortgage Principal",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]])*-1","v":0},{"$f":"SUM(I10:I14)","v":0},{"$f":"AVERAGE(SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-3,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-4,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]))*-1","v":0},1200,{"$f":"SavBudgetTable[[#This Row],[Budget]]/SavBudgetTable[[#Totals],[Budget]]","v":0.75},null,"Cash Savings",{"$f":"IncBudgetTable[[#Totals],[Budget]]-ExpBudgetTable[[#Totals],[Budget]]-SavBudgetTable[[#Totals],[Budget]]","v":300}]
["RESP Earnings",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,InvBudgetTable[[#This Row],[Budget Category]])","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,InvBudgetTable[[#This Row],[Budget Category]])","v":0},null,{"$f":"InvBudgetTable[[#This Row],[Budget]]/InvBudgetTable[[#Totals],[Budget]]","v":0},null,"RESP",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]])*-1","v":0},{"$f":"SUM(I11:I15)","v":0},{"$f":"AVERAGE(SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-3,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-4,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]))*-1","v":0},400,{"$f":"SavBudgetTable[[#This Row],[Budget]]/SavBudgetTable[[#Totals],[Budget]]","v":0.25},null,"Total Savings",{"$f":"IncBudgetTable[[#Totals],[Budget]]-ExpBudgetTable[[#Totals],[Budget]]+InvBudgetTable[[#Totals],[Budget]]","v":2400}]
["RRSP",{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,YEAR(TODAY())-1,Transactions!V:V,MONTH(TODAY()),Transactions!B:B,InvBudgetTable[[#This Row],[Budget Category]])","v":0},{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,InvBudgetTable[[#This Row],[Budget Category]])","v":0},500,{"$f":"InvBudgetTable[[#This Row],[Budget]]/InvBudgetTable[[#Totals],[Budget]]","v":1},null,null,null,{"$f":"SUM(I12:I16)","v":0},{"$f":"AVERAGE(SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-3,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-4,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]))*-1","v":0},null,{"$f":"SavBudgetTable[[#This Row],[Budget]]/SavBudgetTable[[#Totals],[Budget]]","v":0}]
[null,null,null,null,{"$f":"InvBudgetTable[[#This Row],[Budget]]/InvBudgetTable[[#Totals],[Budget]]","v":0},null,null,null,{"$f":"SUM(I13:I17)","v":0},{"$f":"AVERAGE(SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-3,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-4,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]))*-1","v":0},null,{"$f":"SavBudgetTable[[#This Row],[Budget]]/SavBudgetTable[[#Totals],[Budget]]","v":0},null,"Savings to Income Ratio",{"$f":"O16/IncBudgetTable[[#Totals],[Budget]]","v":0.35687732342007433}]
[null,null,null,null,{"$f":"InvBudgetTable[[#This Row],[Budget]]/InvBudgetTable[[#Totals],[Budget]]","v":0},null,null,null,{"$f":"SUM(I14:I18)","v":0},{"$f":"AVERAGE(SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-2,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-3,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]),SUMIFS(Transactions!X:X,Transactions!W:W,IF(MONTH(TODAY())=1,YEAR(TODAY())-1,YEAR(TODAY())),Transactions!V:V,MOD(MONTH(TODAY())-4,12)+1,Transactions!B:B,SavBudgetTable[[#This Row],[Budget Category]]))*-1","v":0},null,{"$f":"SavBudgetTable[[#This Row],[Budget]]/SavBudgetTable[[#Totals],[Budget]]","v":0}]
["Total",null,null,{"$f":"SUBTOTAL(109,InvBudgetTable[Budget])","v":500},{"$f":"SUBTOTAL(109,InvBudgetTable[Percent])","v":1},null,"Total",null,null,null,{"$f":"SUBTOTAL(109,SavBudgetTable[Budget])","v":1600},{"$f":"SUBTOTAL(109,SavBudgetTable[Percent])","v":1}]

{"sheet":"Budget 2024","index":6,"n_rows":159,"n_cols":55,"rows_kept":159,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[2024,null,"Income Category","Budget","Actual","Variance",null,"Expense Category","Avg Last 3 Months","Last Month","Budget","Actual","Actual w/ Forecast","Available","Savings","KPI",{"$f":"HYPERLINK(\"#\"&\"K2\",\"Go to Top\")","v":"Go to Top"},{"$f":"HYPERLINK(\"#\"&\"K\"&MATCH(MONTH(TODAY()),A:A,0)+9,\"Current Month\")","v":"Current Month"},{"$f":"HYPERLINK(\"#\"&\"K131\",\"Go to Bottom\")","v":"Go to Bottom"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,9,9]
[1,{"$f":"TEXT(A2*28,\"mmmm\")","v":"January"},{"$f":"Budget!$A$3","v":"Salary"},6000,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A2,Transactions!B:B,C2)","v":0},{"$f":"E2-D2","v":-6000},null,{"$f":"Budget!$G$3","v":"Groceries"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H2)*-1","v":0},1185,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H2)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H2)*-1","v":0},{"$f":"K2-M2","v":1185},"Budget Cash Savings",{"$f":"$D11-$K11","v":620}]
[null,null,{"$f":"Budget!$A$4","v":"Bonus"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A2,Transactions!B:B,C3)","v":0},0,null,{"$f":"Budget!$G$4","v":"Entertainment"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H3)*-1","v":0},400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H3)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H3)*-1","v":0},400,"Cash Savings",{"$f":"$E11-$L11","v":0}]
[null,null,{"$f":"Budget!$A$5","v":"Kids"},725,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A2,Transactions!B:B,C4)","v":0},-725,null,{"$f":"Budget!$G$5","v":"Shopping"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H4)*-1","v":0},500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H4)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H4)*-1","v":0},500,"Cash Savings to Income",{"$f":"IF($E11=0,\"\",$P3/$E11)","v":""}]
[null,null,{"$f":"Budget!$A$6","v":"Side Project"},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A2,Transactions!B:B,C5)","v":0},0,null,{"$f":"Budget!$G$6","v":"Bills"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H5)*-1","v":0},1500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H5)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H5)*-1","v":0},1500,"Gross Savings",{"$f":"$E11-$L11+$L10","v":0}]
[null,null,{"$f":"Budget!$A$7","v":"Other Income"},320,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A2,Transactions!B:B,C6)","v":0},-320,null,{"$f":"Budget!$G$7","v":"Car"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H6)*-1","v":0},640,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H6)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H6)*-1","v":0},640,"Gross Savings to Income",{"$f":"IF($E11=0,\"\",$P5/$E11)","v":""}]
[null,null,{"$f":"Budget!$A$8","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A2,Transactions!B:B,C7)","v":0},0,null,{"$f":"Budget!$G$8","v":"Charity"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H7)*-1","v":0},400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H7)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H7)*-1","v":0},400]
[null,null,{"$f":"Budget!$A$9","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A2,Transactions!B:B,C8)","v":0},0,null,{"$f":"Budget!$G$9","v":"Health"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H8)*-1","v":0},200,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H8)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H8)*-1","v":0},200]
[null,null,{"$f":"Budget!$A$10","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A2,Transactions!B:B,C9)","v":0},0,null,{"$f":"Budget!$G$10","v":"Other"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H9)*-1","v":0},null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H9)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H9)*-1","v":0},0]
[null,null,null,null,null,null,null,"Savings",null,{"$f":"SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H10)*-1","v":0},1600,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H10)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A2,Transactions!$B:$B,$H10)*-1","v":0},1600]
[null,null,"Total Income",{"$f":"SUM(D2:D10)","v":7045},{"$f":"SUM(E2:E10)","v":0},{"$f":"SUM(F2:F10)","v":-7045},null,"Total Expenses",{"$f":"SUM(I2:I10)","v":0},{"$f":"L1","v":"Actual"},{"$f":"SUM(K2:K10)","v":6425},{"$f":"SUM(L2:L10)","v":0},{"$f":"SUM(M2:M10)","v":0},{"$f":"SUM(N2:N10)","v":6425}]
[2,{"$f":"TEXT(A12*28,\"mmmm\")","v":"February"},{"$f":"Budget!$A$3","v":"Salary"},6000,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A12,Transactions!B:B,C12)","v":0},{"$f":"E12-D12","v":-6000},null,{"$f":"Budget!$G$3","v":"Groceries"},null,0,1185,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H12)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H12)*-1","v":0},{"$f":"K12-M12","v":1185},"Budget Cash Savings",{"$f":"$D21-$K21","v":300}]
[null,null,{"$f":"Budget!$A$4","v":"Bonus"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A12,Transactions!B:B,C13)","v":0},0,null,{"$f":"Budget!$G$4","v":"Entertainment"},null,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H13)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H13)*-1","v":0},400,"Cash Savings",{"$f":"$E21-$L21","v":0}]
[null,null,{"$f":"Budget!$A$5","v":"Kids"},725,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A12,Transactions!B:B,C14)","v":0},-725,null,{"$f":"Budget!$G$5","v":"Shopping"},null,0,500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H14)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H14)*-1","v":0},500,"Cash Savings to Income",{"$f":"IF($E21=0,\"\",$P13/$E21)","v":""}]
[null,null,{"$f":"Budget!$A$6","v":"Side Project"},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A12,Transactions!B:B,C15)","v":0},0,null,{"$f":"Budget!$G$6","v":"Bills"},null,0,1500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H15)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H15)*-1","v":0},1500,"Gross Savings",{"$f":"$E21-$L21+$L20","v":0}]
[null,null,{"$f":"Budget!$A$7","v":"Other Income"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A12,Transactions!B:B,C16)","v":0},0,null,{"$f":"Budget!$G$7","v":"Car"},null,0,640,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H16)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H16)*-1","v":0},640,"Gross Savings to Income",{"$f":"IF($E21=0,\"\",$P15/$E21)","v":""}]
[null,null,{"$f":"Budget!$A$8","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A12,Transactions!B:B,C17)","v":0},0,null,{"$f":"Budget!$G$8","v":"Charity"},null,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H17)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H17)*-1","v":0},400]
[null,null,{"$f":"Budget!$A$9","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A12,Transactions!B:B,C18)","v":0},0,null,{"$f":"Budget!$G$9","v":"Health"},null,0,200,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H18)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H18)*-1","v":0},200]
[null,null,{"$f":"Budget!$A$10","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A12,Transactions!B:B,C19)","v":0},0,null,{"$f":"Budget!$G$10","v":"Other"},null,0,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H19)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H19)*-1","v":0},0]
[null,null,null,null,null,null,null,"Savings",null,0,1600,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H20)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A12,Transactions!$B:$B,$H20)*-1","v":0},1600]
[null,null,"Total Income",{"$f":"SUM(D12:D20)","v":6725},{"$f":"SUM(E12:E20)","v":0},{"$f":"SUM(F12:F20)","v":-6725},null,"Total Expenses",{"$f":"SUM(I12:I20)","v":0},0,{"$f":"SUM(K12:K20)","v":6425},{"$f":"SUM(L12:L20)","v":0},{"$f":"SUM(M12:M20)","v":0},{"$f":"SUM(N12:N20)","v":6425}]
[3,{"$f":"TEXT(A22*28,\"mmmm\")","v":"March"},{"$f":"Budget!$A$3","v":"Salary"},9000,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A22,Transactions!B:B,C22)","v":0},{"$f":"E22-D22","v":-9000},null,{"$f":"Budget!$G$3","v":"Groceries"},{"$f":"ROUND(AVERAGE(L2,L12,SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H22)*-1),-2)","v":0},0,1185,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H22)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H22)*-1","v":0},{"$f":"K22-M22","v":1185},"Budget Cash Savings",{"$f":"$D31-$K31","v":3900}]
[null,null,{"$f":"Budget!$A$4","v":"Bonus"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A22,Transactions!B:B,C23)","v":0},0,null,{"$f":"Budget!$G$4","v":"Entertainment"},{"$f":"ROUND(AVERAGE(L3,L13,SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H23)*-1),-2)","v":0},0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H23)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H23)*-1","v":0},400,"Cash Savings",{"$f":"$E31-$L31","v":0}]
[null,null,{"$f":"Budget!$A$5","v":"Kids"},725,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A22,Transactions!B:B,C24)","v":0},-725,null,{"$f":"Budget!$G$5","v":"Shopping"},{"$f":"ROUND(AVERAGE(L4,L14,SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H24)*-1),-2)","v":0},0,500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H24)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H24)*-1","v":0},500,"Cash Savings to Income",{"$f":"IF($E31=0,\"\",$P23/$E31)","v":""}]
[null,null,{"$f":"Budget!$A$6","v":"Side Project"},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A22,Transactions!B:B,C25)","v":0},0,null,{"$f":"Budget!$G$6","v":"Bills"},{"$f":"ROUND(AVERAGE(L5,L15,SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H25)*-1),-2)","v":0},0,1500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H25)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H25)*-1","v":0},1500,"Gross Savings",{"$f":"$E31-$L31+$L30","v":0}]
[null,null,{"$f":"Budget!$A$7","v":"Other Income"},600,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A22,Transactions!B:B,C26)","v":0},-600,null,{"$f":"Budget!$G$7","v":"Car"},{"$f":"ROUND(AVERAGE(L6,L16,SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H26)*-1),-2)","v":0},0,640,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H26)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H26)*-1","v":0},640,"Gross Savings to Income",{"$f":"IF($E31=0,\"\",$P25/$E31)","v":""}]
[null,null,{"$f":"Budget!$A$8","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A22,Transactions!B:B,C27)","v":0},0,null,{"$f":"Budget!$G$8","v":"Charity"},{"$f":"ROUND(AVERAGE(L7,L17,SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H27)*-1),-2)","v":0},0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H27)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H27)*-1","v":0},400]
[null,null,{"$f":"Budget!$A$9","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A22,Transactions!B:B,C28)","v":0},0,null,{"$f":"Budget!$G$9","v":"Health"},{"$f":"ROUND(AVERAGE(L8,L18,SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H28)*-1),-2)","v":0},0,200,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H28)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H28)*-1","v":0},200]
[null,null,{"$f":"Budget!$A$10","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A22,Transactions!B:B,C29)","v":0},0,null,{"$f":"Budget!$G$10","v":"Other"},{"$f":"ROUND(AVERAGE(L9,L19,SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H29)*-1),-2)","v":0},0,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H29)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H29)*-1","v":0},0]
[null,null,null,null,null,null,null,"Savings",{"$f":"ROUND(AVERAGE(L10,L20,SUMIFS(Transactions!X:X,Transactions!W:W,$A$1-1,Transactions!V:V,12,Transactions!B:B,H30)*-1),-2)","v":0},0,1600,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H30)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A22,Transactions!$B:$B,$H30)*-1","v":0},1600]
[null,null,"Total Income",{"$f":"SUM(D22:D30)","v":10325},{"$f":"SUM(E22:E30)","v":0},{"$f":"SUM(F22:F30)","v":-10325},null,"Total Expenses",{"$f":"SUM(I22:I30)","v":0},0,{"$f":"SUM(K22:K30)","v":6425},{"$f":"SUM(L22:L30)","v":0},{"$f":"SUM(M22:M30)","v":0},{"$f":"SUM(N22:N30)","v":6425}]
[4,{"$f":"TEXT(A32*28,\"mmmm\")","v":"April"},{"$f":"Budget!$A$3","v":"Salary"},6000,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A32,Transactions!B:B,C32)","v":0},{"$f":"E32-D32","v":-6000},null,{"$f":"Budget!$G$3","v":"Groceries"},{"$f":"ROUND(AVERAGE(L2,L12,L22),-2)","v":0},0,1185,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H32)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H32)*-1","v":0},{"$f":"K32-M32","v":1185},"Budget Cash Savings",{"$f":"$D41-$K41","v":300}]
[null,null,{"$f":"Budget!$A$4","v":"Bonus"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A32,Transactions!B:B,C33)","v":0},0,null,{"$f":"Budget!$G$4","v":"Entertainment"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H33)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H33)*-1","v":0},400,"Cash Savings",{"$f":"$E41-$L41","v":0}]
[null,null,{"$f":"Budget!$A$5","v":"Kids"},725,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A32,Transactions!B:B,C34)","v":0},-725,null,{"$f":"Budget!$G$5","v":"Shopping"},0,0,500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H34)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H34)*-1","v":0},500,"Cash Savings to Income",{"$f":"IF($E41=0,\"\",$P33/$E41)","v":""}]
[null,null,{"$f":"Budget!$A$6","v":"Side Project"},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A32,Transactions!B:B,C35)","v":0},0,null,{"$f":"Budget!$G$6","v":"Bills"},0,0,1500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H35)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H35)*-1","v":0},1500,"Gross Savings",{"$f":"$E41-$L41+$L40","v":0}]
[null,null,{"$f":"Budget!$A$7","v":"Other Income"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A32,Transactions!B:B,C36)","v":0},0,null,{"$f":"Budget!$G$7","v":"Car"},0,0,640,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H36)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H36)*-1","v":0},640,"Gross Savings to Income",{"$f":"IF($E41=0,\"\",$P35/$E41)","v":""}]
[null,null,{"$f":"Budget!$A$8","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A32,Transactions!B:B,C37)","v":0},0,null,{"$f":"Budget!$G$8","v":"Charity"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H37)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H37)*-1","v":0},400]
[null,null,{"$f":"Budget!$A$9","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A32,Transactions!B:B,C38)","v":0},0,null,{"$f":"Budget!$G$9","v":"Health"},0,0,200,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H38)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H38)*-1","v":0},200]
[null,null,{"$f":"Budget!$A$10","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A32,Transactions!B:B,C39)","v":0},0,null,{"$f":"Budget!$G$10","v":"Other"},0,0,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H39)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H39)*-1","v":0},0]
[null,null,null,null,null,null,null,"Savings",0,0,1600,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H40)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A32,Transactions!$B:$B,$H40)*-1","v":0},1600]
[null,null,"Total Income",{"$f":"SUM(D32:D40)","v":6725},{"$f":"SUM(E32:E40)","v":0},{"$f":"SUM(F32:F40)","v":-6725},null,"Total Expenses",{"$f":"SUM(I32:I40)","v":0},0,{"$f":"SUM(K32:K40)","v":6425},{"$f":"SUM(L32:L40)","v":0},{"$f":"SUM(M32:M40)","v":0},{"$f":"SUM(N32:N40)","v":6425}]
[5,{"$f":"TEXT(A42*28,\"mmmm\")","v":"May"},{"$f":"Budget!$A$3","v":"Salary"},6000,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A42,Transactions!B:B,C42)","v":0},{"$f":"E42-D42","v":-6000},null,{"$f":"Budget!$G$3","v":"Groceries"},{"$f":"ROUND(AVERAGE(L12,L22,L32),-2)","v":0},0,1185,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H42)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H42)*-1","v":0},{"$f":"K42-M42","v":1185},"Budget Cash Savings",{"$f":"$D51-$K51","v":300}]
[null,null,{"$f":"Budget!$A$4","v":"Bonus"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A42,Transactions!B:B,C43)","v":0},0,null,{"$f":"Budget!$G$4","v":"Entertainment"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H43)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H43)*-1","v":0},400,"Cash Savings",{"$f":"$E51-$L51","v":0}]
[null,null,{"$f":"Budget!$A$5","v":"Kids"},725,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A42,Transactions!B:B,C44)","v":0},-725,null,{"$f":"Budget!$G$5","v":"Shopping"},0,0,500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H44)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H44)*-1","v":0},500,"Cash Savings to Income",{"$f":"IF($E51=0,\"\",$P43/$E51)","v":""}]
[null,null,{"$f":"Budget!$A$6","v":"Side Project"},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A42,Transactions!B:B,C45)","v":0},0,null,{"$f":"Budget!$G$6","v":"Bills"},0,0,1500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H45)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H45)*-1","v":0},1500,"Gross Savings",{"$f":"$E51-$L51+$L50","v":0}]
[null,null,{"$f":"Budget!$A$7","v":"Other Income"},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A42,Transactions!B:B,C46)","v":0},0,null,{"$f":"Budget!$G$7","v":"Car"},0,0,640,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H46)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H46)*-1","v":0},640,"Gross Savings to Income",{"$f":"IF($E51=0,\"\",$P45/$E51)","v":""}]
[null,null,{"$f":"Budget!$A$8","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A42,Transactions!B:B,C47)","v":0},0,null,{"$f":"Budget!$G$8","v":"Charity"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H47)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H47)*-1","v":0},400]
[null,null,{"$f":"Budget!$A$9","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A42,Transactions!B:B,C48)","v":0},0,null,{"$f":"Budget!$G$9","v":"Health"},0,0,200,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H48)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H48)*-1","v":0},200]
[null,null,{"$f":"Budget!$A$10","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A42,Transactions!B:B,C49)","v":0},0,null,{"$f":"Budget!$G$10","v":"Other"},0,0,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H49)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H49)*-1","v":0},0]
[null,null,null,null,null,null,null,"Savings",0,0,1600,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H50)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A42,Transactions!$B:$B,$H50)*-1","v":0},1600]
[null,null,"Total Income",{"$f":"SUM(D42:D50)","v":6725},{"$f":"SUM(E42:E50)","v":0},{"$f":"SUM(F42:F50)","v":-6725},null,"Total Expenses",{"$f":"SUM(I42:I50)","v":0},0,{"$f":"SUM(K42:K50)","v":6425},{"$f":"SUM(L42:L50)","v":0},{"$f":"SUM(M42:M50)","v":0},{"$f":"SUM(N42:N50)","v":6425}]
[6,{"$f":"TEXT(A52*28,\"mmmm\")","v":"June"},{"$f":"Budget!$A$3","v":"Salary"},6000,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A52,Transactions!B:B,C52)","v":0},{"$f":"E52-D52","v":-6000},null,{"$f":"Budget!$G$3","v":"Groceries"},{"$f":"ROUND(AVERAGE(L22,L32,L42),-2)","v":0},0,1185,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H52)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H52)*-1","v":0},{"$f":"K52-M52","v":1185},"Budget Cash Savings",{"$f":"$D61-$K61","v":300}]
[null,null,{"$f":"Budget!$A$4","v":"Bonus"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A52,Transactions!B:B,C53)","v":0},0,null,{"$f":"Budget!$G$4","v":"Entertainment"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H53)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H53)*-1","v":0},400,"Cash Savings",{"$f":"$E61-$L61","v":0}]
[null,null,{"$f":"Budget!$A$5","v":"Kids"},725,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A52,Transactions!B:B,C54)","v":0},-725,null,{"$f":"Budget!$G$5","v":"Shopping"},0,0,500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H54)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H54)*-1","v":0},500,"Cash Savings to Income",{"$f":"IF($E61=0,\"\",$P53/$E61)","v":""}]
[null,null,{"$f":"Budget!$A$6","v":"Side Project"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A52,Transactions!B:B,C55)","v":0},0,null,{"$f":"Budget!$G$6","v":"Bills"},0,0,1500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H55)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H55)*-1","v":0},1500,"Gross Savings",{"$f":"$E61-$L61+$L60","v":0}]
[null,null,{"$f":"Budget!$A$7","v":"Other Income"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A52,Transactions!B:B,C56)","v":0},0,null,{"$f":"Budget!$G$7","v":"Car"},0,0,640,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H56)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H56)*-1","v":0},640,"Gross Savings to Income",{"$f":"IF($E61=0,\"\",$P55/$E61)","v":""}]
[null,null,{"$f":"Budget!$A$8","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A52,Transactions!B:B,C57)","v":0},0,null,{"$f":"Budget!$G$8","v":"Charity"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H57)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H57)*-1","v":0},400]
[null,null,{"$f":"Budget!$A$9","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A52,Transactions!B:B,C58)","v":0},0,null,{"$f":"Budget!$G$9","v":"Health"},0,0,200,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H58)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H58)*-1","v":0},200]
[null,null,{"$f":"Budget!$A$10","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A52,Transactions!B:B,C59)","v":0},0,null,{"$f":"Budget!$G$10","v":"Other"},0,0,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H59)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H59)*-1","v":0},0]
[null,null,null,null,null,null,null,"Savings",0,0,1600,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H60)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A52,Transactions!$B:$B,$H60)*-1","v":0},1600]
[null,null,"Total Income",{"$f":"SUM(D52:D60)","v":6725},{"$f":"SUM(E52:E60)","v":0},{"$f":"SUM(F52:F60)","v":-6725},null,"Total Expenses",{"$f":"SUM(I52:I60)","v":0},0,{"$f":"SUM(K52:K60)","v":6425},{"$f":"SUM(L52:L60)","v":0},{"$f":"SUM(M52:M60)","v":0},{"$f":"SUM(N52:N60)","v":6425}]
[7,{"$f":"TEXT(A62*28,\"mmmm\")","v":"July"},{"$f":"Budget!$A$3","v":"Salary"},6000,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A62,Transactions!B:B,C62)","v":0},{"$f":"E62-D62","v":-6000},null,{"$f":"Budget!$G$3","v":"Groceries"},{"$f":"ROUND(AVERAGE(L32,L42,L52),-2)","v":0},0,1185,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H62)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H62)*-1","v":0},{"$f":"K62-M62","v":1185},"Budget Cash Savings",{"$f":"$D71-$K71","v":760}]
[null,null,{"$f":"Budget!$A$4","v":"Bonus"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A62,Transactions!B:B,C63)","v":0},0,null,{"$f":"Budget!$G$4","v":"Entertainment"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H63)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H63)*-1","v":0},400,"Cash Savings",{"$f":"$E71-$L71","v":0}]
[null,null,{"$f":"Budget!$A$5","v":"Kids"},725,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A62,Transactions!B:B,C64)","v":0},-725,null,{"$f":"Budget!$G$5","v":"Shopping"},0,0,500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H64)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H64)*-1","v":0},500,"Cash Savings to Income",{"$f":"IF($E71=0,\"\",$P63/$E71)","v":""}]
[null,null,{"$f":"Budget!$A$6","v":"Side Project"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A62,Transactions!B:B,C65)","v":0},0,null,{"$f":"Budget!$G$6","v":"Bills"},0,0,1500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H65)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H65)*-1","v":0},1500,"Gross Savings",{"$f":"$E71-$L71+$L70","v":0}]
[null,null,{"$f":"Budget!$A$7","v":"Other Income"},460,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A62,Transactions!B:B,C66)","v":0},-460,null,{"$f":"Budget!$G$7","v":"Car"},0,0,640,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H66)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H66)*-1","v":0},640,"Gross Savings to Income",{"$f":"IF($E71=0,\"\",$P65/$E71)","v":""}]
[null,null,{"$f":"Budget!$A$8","v":0},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A62,Transactions!B:B,C67)","v":0},0,null,{"$f":"Budget!$G$8","v":"Charity"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H67)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H67)*-1","v":0},400]
[null,null,{"$f":"Budget!$A$9","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A62,Transactions!B:B,C68)","v":0},0,null,{"$f":"Budget!$G$9","v":"Health"},0,0,200,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H68)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H68)*-1","v":0},200]
[null,null,{"$f":"Budget!$A$10","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A62,Transactions!B:B,C69)","v":0},0,null,{"$f":"Budget!$G$10","v":"Other"},0,0,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H69)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H69)*-1","v":0},0]
[null,null,null,null,null,null,null,"Savings",0,0,1600,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H70)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A62,Transactions!$B:$B,$H70)*-1","v":0},1600]
[null,null,"Total Income",{"$f":"SUM(D62:D70)","v":7185},{"$f":"SUM(E62:E70)","v":0},{"$f":"SUM(F62:F70)","v":-7185},null,"Total Expenses",{"$f":"SUM(I62:I70)","v":0},0,{"$f":"SUM(K62:K70)","v":6425},{"$f":"SUM(L62:L70)","v":0},{"$f":"SUM(M62:M70)","v":0},{"$f":"SUM(N62:N70)","v":6425}]
[8,{"$f":"TEXT(A72*28,\"mmmm\")","v":"August"},{"$f":"Budget!$A$3","v":"Salary"},9000,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A72,Transactions!B:B,C72)","v":0},{"$f":"E72-D72","v":-9000},null,{"$f":"Budget!$G$3","v":"Groceries"},{"$f":"ROUND(AVERAGE(L42,L52,L62),-2)","v":0},0,1185,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H72)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H72)*-1","v":0},{"$f":"K72-M72","v":1185},"Budget Cash Savings",{"$f":"$D81-$K81","v":3300}]
[null,null,{"$f":"Budget!$A$4","v":"Bonus"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A72,Transactions!B:B,C73)","v":0},0,null,{"$f":"Budget!$G$4","v":"Entertainment"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H73)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H73)*-1","v":0},400,"Cash Savings",{"$f":"$E81-$L81","v":0}]
[null,null,{"$f":"Budget!$A$5","v":"Kids"},725,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A72,Transactions!B:B,C74)","v":0},-725,null,{"$f":"Budget!$G$5","v":"Shopping"},0,0,500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H74)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H74)*-1","v":0},500,"Cash Savings to Income",{"$f":"IF($E81=0,\"\",$P73/$E81)","v":""}]
[null,null,{"$f":"Budget!$A$6","v":"Side Project"},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A72,Transactions!B:B,C75)","v":0},0,null,{"$f":"Budget!$G$6","v":"Bills"},0,{"$f":"L65","v":0},1500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H75)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H75)*-1","v":0},1500,"Gross Savings",{"$f":"$E81-$L81+$L80","v":0}]
[null,null,{"$f":"Budget!$A$7","v":"Other Income"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A72,Transactions!B:B,C76)","v":0},0,null,{"$f":"Budget!$G$7","v":"Car"},0,0,640,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H76)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H76)*-1","v":0},640,"Gross Savings to Income",{"$f":"IF($E81=0,\"\",$P75/$E81)","v":""}]
[null,null,{"$f":"Budget!$A$8","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A72,Transactions!B:B,C77)","v":0},0,null,{"$f":"Budget!$G$8","v":"Charity"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H77)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H77)*-1","v":0},400]
[null,null,{"$f":"Budget!$A$9","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A72,Transactions!B:B,C78)","v":0},0,null,{"$f":"Budget!$G$9","v":"Health"},0,0,200,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H78)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H78)*-1","v":0},200]
[null,null,{"$f":"Budget!$A$10","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A72,Transactions!B:B,C79)","v":0},0,null,{"$f":"Budget!$G$10","v":"Other"},0,0,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H79)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H79)*-1","v":0},0]
[null,null,null,null,null,null,null,"Savings",0,0,1600,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H80)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A72,Transactions!$B:$B,$H80)*-1","v":0},1600]
[null,null,"Total Income",{"$f":"SUM(D72:D80)","v":9725},{"$f":"SUM(E72:E80)","v":0},{"$f":"SUM(F72:F80)","v":-9725},null,"Total Expenses",{"$f":"SUM(I72:I80)","v":0},0,{"$f":"SUM(K72:K80)","v":6425},{"$f":"SUM(L72:L80)","v":0},{"$f":"SUM(M72:M80)","v":0},{"$f":"SUM(N72:N80)","v":6425}]
[9,{"$f":"TEXT(A82*28,\"mmmm\")","v":"September"},{"$f":"Budget!$A$3","v":"Salary"},6000,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A82,Transactions!B:B,C82)","v":0},{"$f":"E82-D82","v":-6000},null,{"$f":"Budget!$G$3","v":"Groceries"},{"$f":"ROUND(AVERAGE(L52,L62,L72),-2)","v":0},0,1185,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H82)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H82)*-1","v":0},{"$f":"K82-M82","v":1185},"Budget Cash Savings",{"$f":"$D91-$K91","v":300}]
[null,null,{"$f":"Budget!$A$4","v":"Bonus"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A82,Transactions!B:B,C83)","v":0},0,null,{"$f":"Budget!$G$4","v":"Entertainment"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H83)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H83)*-1","v":0},400,"Cash Savings",{"$f":"$E91-$L91","v":0}]
[null,null,{"$f":"Budget!$A$5","v":"Kids"},725,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A82,Transactions!B:B,C84)","v":0},-725,null,{"$f":"Budget!$G$5","v":"Shopping"},0,0,500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H84)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H84)*-1","v":0},500,"Cash Savings to Income",{"$f":"IF($E91=0,\"\",$P83/$E91)","v":""}]
[null,null,{"$f":"Budget!$A$6","v":"Side Project"},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A82,Transactions!B:B,C85)","v":0},0,null,{"$f":"Budget!$G$6","v":"Bills"},0,0,1500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H85)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H85)*-1","v":0},1500,"Gross Savings",{"$f":"$E91-$L91+$L90","v":0}]
[null,null,{"$f":"Budget!$A$7","v":"Other Income"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A82,Transactions!B:B,C86)","v":0},0,null,{"$f":"Budget!$G$7","v":"Car"},0,0,640,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H86)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H86)*-1","v":0},640,"Gross Savings to Income",{"$f":"IF($E91=0,\"\",$P85/$E91)","v":""}]
[null,null,{"$f":"Budget!$A$8","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A82,Transactions!B:B,C87)","v":0},0,null,{"$f":"Budget!$G$8","v":"Charity"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H87)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H87)*-1","v":0},400]
[null,null,{"$f":"Budget!$A$9","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A82,Transactions!B:B,C88)","v":0},0,null,{"$f":"Budget!$G$9","v":"Health"},0,0,200,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H88)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H88)*-1","v":0},200]
[null,null,{"$f":"Budget!$A$10","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A82,Transactions!B:B,C89)","v":0},0,null,{"$f":"Budget!$G$10","v":"Other"},0,0,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H89)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H89)*-1","v":0},0]
[null,null,null,null,null,null,null,"Savings",0,0,1600,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H90)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A82,Transactions!$B:$B,$H90)*-1","v":0},1600]
[null,null,"Total Income",{"$f":"SUM(D82:D90)","v":6725},{"$f":"SUM(E82:E90)","v":0},{"$f":"SUM(F82:F90)","v":-6725},null,"Total Expenses",{"$f":"SUM(I82:I90)","v":0},0,{"$f":"SUM(K82:K90)","v":6425},{"$f":"SUM(L82:L90)","v":0},{"$f":"SUM(M82:M90)","v":0},{"$f":"SUM(N82:N90)","v":6425}]
[10,{"$f":"TEXT(A92*28,\"mmmm\")","v":"October"},{"$f":"Budget!$A$3","v":"Salary"},6000,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A92,Transactions!B:B,C92)","v":3000},{"$f":"E92-D92","v":-3000},null,{"$f":"Budget!$G$3","v":"Groceries"},{"$f":"ROUND(AVERAGE(L62,L72,L82),-2)","v":0},0,1185,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H92)*-1","v":390},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H92)*-1","v":390},{"$f":"K92-M92","v":795},"Budget Cash Savings",{"$f":"$D101-$K101","v":560}]
[null,null,{"$f":"Budget!$A$4","v":"Bonus"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A92,Transactions!B:B,C93)","v":0},0,null,{"$f":"Budget!$G$4","v":"Entertainment"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H93)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H93)*-1","v":0},400,"Cash Savings",{"$f":"$E101-$L101","v":655}]
[null,null,{"$f":"Budget!$A$5","v":"Kids"},725,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A92,Transactions!B:B,C94)","v":0},-725,null,{"$f":"Budget!$G$5","v":"Shopping"},0,0,500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H94)*-1","v":95},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H94)*-1","v":95},405,"Cash Savings to Income",{"$f":"IF($E101=0,\"\",$P93/$E101)","v":0.21833333333333332}]
[null,null,{"$f":"Budget!$A$6","v":"Side Project"},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A92,Transactions!B:B,C95)","v":0},0,null,{"$f":"Budget!$G$6","v":"Bills"},0,0,1500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H95)*-1","v":440},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H95)*-1","v":440},1060,"Gross Savings",{"$f":"$E101-$L101+$L100","v":1855}]
[null,null,{"$f":"Budget!$A$7","v":"Other Income"},260,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A92,Transactions!B:B,C96)","v":0},-260,null,{"$f":"Budget!$G$7","v":"Car"},0,0,640,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H96)*-1","v":200},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H96)*-1","v":200},440,"Gross Savings to Income",{"$f":"IF($E101=0,\"\",$P95/$E101)","v":0.61833333333333329}]
[null,null,{"$f":"Budget!$A$8","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A92,Transactions!B:B,C97)","v":0},0,null,{"$f":"Budget!$G$8","v":"Charity"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H97)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H97)*-1","v":0},400]
[null,null,{"$f":"Budget!$A$9","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A92,Transactions!B:B,C98)","v":0},0,null,{"$f":"Budget!$G$9","v":"Health"},0,0,200,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H98)*-1","v":20},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H98)*-1","v":20},180]
[null,null,{"$f":"Budget!$A$10","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A92,Transactions!B:B,C99)","v":0},0,null,{"$f":"Budget!$G$10","v":"Other"},0,0,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H99)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H99)*-1","v":0},0]
[null,null,null,null,null,null,null,"Savings",0,0,1600,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H100)*-1","v":1200},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A92,Transactions!$B:$B,$H100)*-1","v":1200},400]
[null,null,"Total Income",{"$f":"SUM(D92:D100)","v":6985},{"$f":"SUM(E92:E100)","v":3000},{"$f":"SUM(F92:F100)","v":-3985},null,"Total Expenses",{"$f":"SUM(I92:I100)","v":0},0,{"$f":"SUM(K92:K100)","v":6425},{"$f":"SUM(L92:L100)","v":2345},{"$f":"SUM(M92:M100)","v":2345},{"$f":"SUM(N92:N100)","v":4080}]
[11,{"$f":"TEXT(A102*28,\"mmmm\")","v":"November"},{"$f":"Budget!$A$3","v":"Salary"},6000,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A102,Transactions!B:B,C102)","v":0},{"$f":"E102-D102","v":-6000},null,{"$f":"Budget!$G$3","v":"Groceries"},{"$f":"ROUND(AVERAGE(L72,L82,L92),-2)","v":100},390,1185,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H102)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H102)*-1","v":0},{"$f":"K102-M102","v":1185},"Budget Cash Savings",{"$f":"$D111-$K111","v":1300}]
[null,null,{"$f":"Budget!$A$4","v":"Bonus"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A102,Transactions!B:B,C103)","v":0},0,null,{"$f":"Budget!$G$4","v":"Entertainment"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H103)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H103)*-1","v":0},400,"Cash Savings",{"$f":"$E111-$L111","v":0}]
[null,null,{"$f":"Budget!$A$5","v":"Kids"},725,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A102,Transactions!B:B,C104)","v":0},-725,null,{"$f":"Budget!$G$5","v":"Shopping"},0,95,500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H104)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H104)*-1","v":0},500,"Cash Savings to Income",{"$f":"IF($E111=0,\"\",$P103/$E111)","v":""}]
[null,null,{"$f":"Budget!$A$6","v":"Side Project"},0,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A102,Transactions!B:B,C105)","v":0},0,null,{"$f":"Budget!$G$6","v":"Bills"},100,440,1500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H105)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H105)*-1","v":1015},485,"Gross Savings",{"$f":"$E111-$L111+$L110","v":0}]
[null,null,{"$f":"Budget!$A$7","v":"Other Income"},1000,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A102,Transactions!B:B,C106)","v":0},-1000,null,{"$f":"Budget!$G$7","v":"Car"},100,200,640,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H106)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H106)*-1","v":200},440,"Gross Savings to Income",{"$f":"IF($E111=0,\"\",$P105/$E111)","v":""}]
[null,null,{"$f":"Budget!$A$8","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A102,Transactions!B:B,C107)","v":0},0,null,{"$f":"Budget!$G$8","v":"Charity"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H107)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H107)*-1","v":0},400]
[null,null,{"$f":"Budget!$A$9","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A102,Transactions!B:B,C108)","v":0},0,null,{"$f":"Budget!$G$9","v":"Health"},0,20,200,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H108)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H108)*-1","v":0},200]
[null,null,{"$f":"Budget!$A$10","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A102,Transactions!B:B,C109)","v":0},0,null,{"$f":"Budget!$G$10","v":"Other"},0,0,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H109)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H109)*-1","v":0},0]
[null,null,null,null,null,null,null,"Savings",400,1200,1600,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H110)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A102,Transactions!$B:$B,$H110)*-1","v":1600},0]
[null,null,"Total Income",{"$f":"SUM(D102:D110)","v":7725},{"$f":"SUM(E102:E110)","v":0},{"$f":"SUM(F102:F110)","v":-7725},null,"Total Expenses",{"$f":"SUM(I102:I110)","v":700},2345,{"$f":"SUM(K102:K110)","v":6425},{"$f":"SUM(L102:L110)","v":0},{"$f":"SUM(M102:M110)","v":2815},{"$f":"SUM(N102:N110)","v":3610}]
[12,{"$f":"TEXT(A112*28,\"mmmm\")","v":"December"},{"$f":"Budget!$A$3","v":"Salary"},6000,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A112,Transactions!B:B,C112)","v":0},{"$f":"E112-D112","v":-6000},null,{"$f":"Budget!$G$3","v":"Groceries"},{"$f":"ROUND(AVERAGE(L82,L92,L102),-2)","v":100},0,1185,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H112)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H112)*-1","v":0},{"$f":"K112-M112","v":1185},"Budget Cash Savings",{"$f":"$D121-$K121","v":300}]
[null,null,{"$f":"Budget!$A$4","v":"Bonus"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A112,Transactions!B:B,C113)","v":0},0,null,{"$f":"Budget!$G$4","v":"Entertainment"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H113)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H113)*-1","v":0},400,"Cash Savings",{"$f":"$E121-$L121","v":0}]
[null,null,{"$f":"Budget!$A$5","v":"Kids"},725,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A112,Transactions!B:B,C114)","v":0},-725,null,{"$f":"Budget!$G$5","v":"Shopping"},0,0,500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H114)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H114)*-1","v":0},500,"Cash Savings to Income",{"$f":"IF($E121=0,\"\",$P113/$E121)","v":""}]
[null,null,{"$f":"Budget!$A$6","v":"Side Project"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A112,Transactions!B:B,C115)","v":0},0,null,{"$f":"Budget!$G$6","v":"Bills"},100,0,1500,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H115)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H115)*-1","v":0},1500,"Gross Savings",{"$f":"$E121-$L121+$L120","v":0}]
[null,null,{"$f":"Budget!$A$7","v":"Other Income"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A112,Transactions!B:B,C116)","v":0},0,null,{"$f":"Budget!$G$7","v":"Car"},100,0,640,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H116)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H116)*-1","v":0},640,"Gross Savings to Income",{"$f":"IF($E121=0,\"\",$P115/$E121)","v":""}]
[null,null,{"$f":"Budget!$A$8","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A112,Transactions!B:B,C117)","v":0},0,null,{"$f":"Budget!$G$8","v":"Charity"},0,0,400,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H117)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H117)*-1","v":0},400]
[null,null,{"$f":"Budget!$A$9","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A112,Transactions!B:B,C118)","v":0},0,null,{"$f":"Budget!$G$9","v":"Health"},0,0,200,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H118)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H118)*-1","v":0},200]
[null,null,{"$f":"Budget!$A$10","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!V:V,$A112,Transactions!B:B,C119)","v":0},0,null,{"$f":"Budget!$G$10","v":"Other"},0,0,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H119)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H119)*-1","v":0},0]
[null,null,null,null,null,null,null,"Savings",400,0,1600,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H120)*-1","v":0},{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$W:$W,$A$1,Transactions!$V:$V,$A112,Transactions!$B:$B,$H120)*-1","v":0},1600]
[null,null,"Total Income",{"$f":"SUM(D112:D120)","v":6725},{"$f":"SUM(E112:E120)","v":0},{"$f":"SUM(F112:F120)","v":-6725},null,"Total Expenses",{"$f":"SUM(I112:I120)","v":700},0,{"$f":"SUM(K112:K120)","v":6425},{"$f":"SUM(L112:L120)","v":0},{"$f":"SUM(M112:M120)","v":0},{"$f":"SUM(N112:N120)","v":6425}]
[null,"Full Year",{"$f":"Budget!$A$3","v":"Salary"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!B:B,C122)","v":3000},null,null,{"$f":"Budget!$G$3","v":"Groceries"},{"$f":"ROUND(AVERAGE(L2,L12,L22,L32,L42,L52,L62,L72,L82,L92,L102,L112),-2)","v":0},null,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$B:$B,$H122)*-1","v":390},null,null,"Budget Cash Savings",{"$f":"$D131-$K131","v":0}]
[null,null,{"$f":"Budget!$A$4","v":"Bonus"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!B:B,C123)","v":0},null,null,{"$f":"Budget!$G$4","v":"Entertainment"},{"$f":"ROUND(AVERAGE(L3,L13,L23,L33,L43,L53,L63,L73,L83,L93,L103,L113),-2)","v":0},null,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$B:$B,$H123)*-1","v":0},null,null,"Cash Savings",{"$f":"$E131-$L131","v":655}]
[null,null,{"$f":"Budget!$A$5","v":"Kids"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!B:B,C124)","v":0},null,null,{"$f":"Budget!$G$5","v":"Shopping"},{"$f":"ROUND(AVERAGE(L4,L14,L24,L34,L44,L54,L64,L74,L84,L94,L104,L114),-2)","v":0},null,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$B:$B,$H124)*-1","v":95},null,null,"Cash Savings to Income",{"$f":"IF($E131=0,\"\",$P123/$E131)","v":0.21833333333333332}]
[null,null,{"$f":"Budget!$A$6","v":"Side Project"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!B:B,C125)","v":0},null,null,{"$f":"Budget!$G$6","v":"Bills"},0,null,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$B:$B,$H125)*-1","v":440},null,null,"Gross Savings",{"$f":"$E131-$L131+$L130","v":1855}]
[null,null,{"$f":"Budget!$A$7","v":"Other Income"},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!B:B,C126)","v":0},null,null,{"$f":"Budget!$G$7","v":"Car"},0,null,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$B:$B,$H126)*-1","v":200},null,null,"Gross Savings to Income",{"$f":"IF($E131=0,\"\",$P125/$E131)","v":0.61833333333333329}]
[null,null,{"$f":"Budget!$A$8","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!B:B,C127)","v":0},null,null,{"$f":"Budget!$G$8","v":"Charity"},0,null,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$B:$B,$H127)*-1","v":0}]
[null,null,{"$f":"Budget!$A$9","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!B:B,C128)","v":0},null,null,{"$f":"Budget!$G$9","v":"Health"},0,null,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$B:$B,$H128)*-1","v":20}]
[null,null,{"$f":"Budget!$A$10","v":0},null,{"$f":"SUMIFS(Transactions!X:X,Transactions!Y:Y,\"<>F\",Transactions!W:W,$A$1,Transactions!B:B,C129)","v":0},null,null,{"$f":"Budget!$G$10","v":"Other"},0,null,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$B:$B,$H129)*-1","v":0}]
[null,null,null,null,null,null,null,"Savings",100,null,null,{"$f":"SUMIFS(Transactions!$X:$X,Transactions!$Y:$Y,\"<>F\",Transactions!$W:$W,$A$1,Transactions!$B:$B,$H130)*-1","v":1200}]
[null,null,"Total Income",null,{"$f":"SUM(E122:E130)","v":3000},null,null,"Total Expenses",200,null,null,{"$f":"SUM(L122:L130)","v":2345},{"$f":"SUM(M122:M130)","v":0}]
[]
[]
[]
["Cash Savings Calculation: Total Income minus Total Expenses. As simple as it gets. "]
["No matter how you calculate your savings… From a Cash Flow purspective - money leaving your checking and credit card accounts should never exceed the inflow to these accounts. Per period."]
["Cash Savings can go into a negative territory for a few periods only if you have a cushion. But long term this is not sustainable."]
[]
["Gross Savings: "]
["Consider this example: In Jan your income was 5,000. Total expenses were 4,000. Simple cash savings calculation gives us 1,000 saved. In Jan. "]
["Now consider you have a mortgage. In Feb you decided to make an extra payment on the mortgage. 1,000 goes towards principal."]
["Your account balance becomes zero. Let's assume for simplicity you had no income nor expenses in Feb yet."]
["From the cash flow perspective: you have made 5,000. You have spent 5,000."]
["Jan Cash Savings: 1,000. Feb Cash Savings: -1,000. Year-to-date Cash Savings is zero. But you owe less money to the bank now."]
["Gross Savings calculation removes such savings transactions from expenses category. All you need to do is use Savings as Budget Category on the Transactions sheet."]
["Important: Savings transactions should not be counted twice. I.e. Mortgage extra payment of 1,000 in Feb does NOT increase your YTD savings to 2,000."]
[]
["The same can be said if you put this 1,000 in your personal pension 401K, RRSP, your kids education savings account, etc."]
["Funds become unavailable to you until you cell your house, reach certain age or until your kids will go to college. You have to write an outflow transaction at your checking account."]
["But in general terms putting money aside for retirement or tuition is saving."]
[]
["Now consider you pay 2,000 every month on your mortgage. 1,200 Principal and 800 Interest. 800 is a write off expense. "]
["But 1,200 of principal payment is no different than the extra payment. It reduces the amount you owe to the bank. It can be considered savings."]
["Interest payments deducted from your taxes is a separate conversation. I consider tax refund as Income in the period when it is received"]
[]
["Note: You can completely change formulas on the Budget spreadsheet or even replace it with your own budget sheet driven off of Transactions sheet for actuals"]
[]
[]
["Additional Note: Double-clicking a cell within Actual column opens Transactions sheet filtered by the period and amount you clicked on. The same action can be done using Show Transactions button in Moneyble ribbon"]

{"sheet":"Net Worth","index":7,"n_rows":25,"n_cols":46,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Account Name","2024 Q1","2024 Q2","2024 Q3","2024 Q4","2025 Q1","2025 Q2","2025 Q3","2025 Q4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1]
[{"$f":"Transactions!F1","v":"Cash"},{"$f":"SUMIFS(Transactions!$Z:$Z,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(B$1,1,4),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":100},{"$f":"SUMIFS(Transactions!$Z:$Z,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(C$1,1,4),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":100},{"$f":"SUMIFS(Transactions!$Z:$Z,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(D$1,1,4),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":100},{"$f":"SUMIFS(Transactions!$Z:$Z,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(E$1,1,4),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":100},{"$f":"SUMIFS(Transactions!$Z:$Z,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(F$1,1,4),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":100},{"$f":"SUMIFS(Transactions!$Z:$Z,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(G$1,1,4),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":100},{"$f":"SUMIFS(Transactions!$Z:$Z,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(H$1,1,4),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":100},{"$f":"SUMIFS(Transactions!$Z:$Z,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(I$1,1,4),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":100}]
[{"$f":"Transactions!H1","v":"Checking"},{"$f":"SUMIFS(Transactions!$AA:$AA,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(B$1,1,4),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":5000},{"$f":"SUMIFS(Transactions!$AA:$AA,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(C$1,1,4),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":5000},{"$f":"SUMIFS(Transactions!$AA:$AA,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(D$1,1,4),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":5000},{"$f":"SUMIFS(Transactions!$AA:$AA,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(E$1,1,4),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":4135},{"$f":"SUMIFS(Transactions!$AA:$AA,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(F$1,1,4),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":4135},{"$f":"SUMIFS(Transactions!$AA:$AA,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(G$1,1,4),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":4135},{"$f":"SUMIFS(Transactions!$AA:$AA,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(H$1,1,4),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":4135},{"$f":"SUMIFS(Transactions!$AA:$AA,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(I$1,1,4),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":4135}]
[{"$f":"Transactions!P1","v":"Wife's Checking"},{"$f":"SUMIFS(Transactions!$AE:$AE,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(B$1,1,4),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AE:$AE,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(C$1,1,4),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AE:$AE,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(D$1,1,4),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AE:$AE,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(E$1,1,4),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AE:$AE,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(F$1,1,4),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AE:$AE,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(G$1,1,4),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AE:$AE,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(H$1,1,4),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AE:$AE,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(I$1,1,4),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0}]
[{"$f":"Transactions!$J$1","v":"Visa"},{"$f":"SUMIFS(Transactions!$AB:$AB,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(B$1,1,4),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":-3000},{"$f":"SUMIFS(Transactions!$AB:$AB,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(C$1,1,4),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":-3000},{"$f":"SUMIFS(Transactions!$AB:$AB,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(D$1,1,4),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":-3000},{"$f":"SUMIFS(Transactions!$AB:$AB,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(E$1,1,4),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":-1480},{"$f":"SUMIFS(Transactions!$AB:$AB,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(F$1,1,4),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":-1480},{"$f":"SUMIFS(Transactions!$AB:$AB,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(G$1,1,4),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":-1480},{"$f":"SUMIFS(Transactions!$AB:$AB,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(H$1,1,4),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":-1480},{"$f":"SUMIFS(Transactions!$AB:$AB,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(I$1,1,4),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":-1480}]
[{"$f":"Transactions!$L$1","v":"MasterCard"},{"$f":"SUMIFS(Transactions!$AC:$AC,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(B$1,1,4),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AC:$AC,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(C$1,1,4),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AC:$AC,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(D$1,1,4),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AC:$AC,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(E$1,1,4),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AC:$AC,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(F$1,1,4),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AC:$AC,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(G$1,1,4),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AC:$AC,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(H$1,1,4),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AC:$AC,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(I$1,1,4),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0}]
[{"$f":"Transactions!$N$1","v":"Visa2"},{"$f":"SUMIFS(Transactions!$AD:$AD,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(B$1,1,4),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AD:$AD,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(C$1,1,4),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AD:$AD,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(D$1,1,4),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AD:$AD,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(E$1,1,4),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AD:$AD,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(F$1,1,4),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AD:$AD,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(G$1,1,4),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AD:$AD,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(H$1,1,4),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0},{"$f":"SUMIFS(Transactions!$AD:$AD,Transactions!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(I$1,1,4),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Transactions!$Y:$Y,\"<>F\")","v":0}]
["Everyday",{"$f":"SUM(B2:B7)","v":2100},2100,2100,2755,{"$f":"SUM(F2:F7)","v":2755},2755,2755,2755]
["Savings",{"$f":"SUMIFS(Investments!$AA:$AA,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(B$1,1,4),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":5000},{"$f":"SUMIFS(Investments!$AA:$AA,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(C$1,1,4),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":5000},{"$f":"SUMIFS(Investments!$AA:$AA,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(D$1,1,4),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":0},{"$f":"SUMIFS(Investments!$AA:$AA,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(E$1,1,4),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":0},{"$f":"SUMIFS(Investments!$AA:$AA,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(F$1,1,4),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":0},{"$f":"SUMIFS(Investments!$AA:$AA,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(G$1,1,4),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":0},{"$f":"SUMIFS(Investments!$AA:$AA,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(H$1,1,4),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":0},{"$f":"SUMIFS(Investments!$AA:$AA,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(I$1,1,4),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":0}]
["iTrade",{"$f":"SUMIFS(Investments!$AE:$AE,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(B$1,1,4),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")+SUMIFS(Investments!$AG:$AG,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(B$1,1,4),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":0},{"$f":"SUMIFS(Investments!$AE:$AE,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(C$1,1,4),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")+SUMIFS(Investments!$AG:$AG,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(C$1,1,4),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":0},{"$f":"SUMIFS(Investments!$AE:$AE,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(D$1,1,4),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")+SUMIFS(Investments!$AG:$AG,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(D$1,1,4),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":5765},{"$f":"SUMIFS(Investments!$AE:$AE,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(E$1,1,4),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")+SUMIFS(Investments!$AG:$AG,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(E$1,1,4),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":5765},{"$f":"SUMIFS(Investments!$AE:$AE,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(F$1,1,4),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")+SUMIFS(Investments!$AG:$AG,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(F$1,1,4),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":5765},{"$f":"SUMIFS(Investments!$AE:$AE,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(G$1,1,4),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")+SUMIFS(Investments!$AG:$AG,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(G$1,1,4),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":5765},{"$f":"SUMIFS(Investments!$AE:$AE,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(H$1,1,4),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")+SUMIFS(Investments!$AG:$AG,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(H$1,1,4),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":5765},{"$f":"SUMIFS(Investments!$AE:$AE,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(I$1,1,4),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")+SUMIFS(Investments!$AG:$AG,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(I$1,1,4),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":5765}]
["Savings",{"$f":"SUM(B9:B10)","v":5000},5000,5765,5765,{"$f":"SUM(F9:F10)","v":5765},5765,5765,5765]
["RRSP",{"$f":"SUMIFS(Investments!$AB:$AB,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(B$1,1,4),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":150000},{"$f":"SUMIFS(Investments!$AB:$AB,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(C$1,1,4),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":160665},{"$f":"SUMIFS(Investments!$AB:$AB,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(D$1,1,4),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":170405},{"$f":"SUMIFS(Investments!$AB:$AB,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(E$1,1,4),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":170405},{"$f":"SUMIFS(Investments!$AB:$AB,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(F$1,1,4),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":170405},{"$f":"SUMIFS(Investments!$AB:$AB,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(G$1,1,4),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":170405},{"$f":"SUMIFS(Investments!$AB:$AB,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(H$1,1,4),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":170405},{"$f":"SUMIFS(Investments!$AB:$AB,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(I$1,1,4),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":170405}]
["RPP",{"$f":"SUMIFS(Investments!$AC:$AC,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(B$1,1,4),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":23180},{"$f":"SUMIFS(Investments!$AC:$AC,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(C$1,1,4),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":25145},{"$f":"SUMIFS(Investments!$AC:$AC,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(D$1,1,4),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":29755},{"$f":"SUMIFS(Investments!$AC:$AC,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(E$1,1,4),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":30655},{"$f":"SUMIFS(Investments!$AC:$AC,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(F$1,1,4),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":30655},{"$f":"SUMIFS(Investments!$AC:$AC,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(G$1,1,4),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":30655},{"$f":"SUMIFS(Investments!$AC:$AC,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(H$1,1,4),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":30655},{"$f":"SUMIFS(Investments!$AC:$AC,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(I$1,1,4),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":30655}]
["RESP",{"$f":"SUMIFS(Investments!$AD:$AD,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(B$1,1,4),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(B$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":68655},{"$f":"SUMIFS(Investments!$AD:$AD,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(C$1,1,4),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(C$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":68655},{"$f":"SUMIFS(Investments!$AD:$AD,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(D$1,1,4),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(D$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":76025},{"$f":"SUMIFS(Investments!$AD:$AD,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(E$1,1,4),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(E$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":76505},{"$f":"SUMIFS(Investments!$AD:$AD,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(F$1,1,4),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(F$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":76505},{"$f":"SUMIFS(Investments!$AD:$AD,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(G$1,1,4),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(G$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":76505},{"$f":"SUMIFS(Investments!$AD:$AD,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(H$1,1,4),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(H$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":76505},{"$f":"SUMIFS(Investments!$AD:$AD,Investments!$A:$A,_xlfn.CONCAT(\"<=\",DATE(MID(I$1,1,4),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"3\",\"2\",\"6\",\"3\",\"9\",\"4\",\"12\",\"12\"),_xlfn.SWITCH(MID(I$1,7,1),\"1\",\"31\",\"2\",\"30\",\"3\",\"30\",\"4\",\"31\",\"30\"))),Investments!$Z:$Z,\"<>F\")","v":76505}]
["Investments",{"$f":"SUM(B12:B14)","v":241835},254465,276185,277565,{"$f":"SUM(F12:F14)","v":277565},277565,277565,277565]
["Mortgage",-90800,-87300,-83700,-80000,{"$f":"E16-E16*3%","v":-77600},{"$f":"F16-F16*3%","v":-75272},{"$f":"G16-G16*3%","v":-73013.84},{"$f":"H16-H16*3%","v":-70823.424799999993}]
["House Value",350000,{"$f":"B17","v":350000},350000,350000,{"$f":"E17","v":350000},{"$f":"F17","v":350000},{"$f":"G17","v":350000},{"$f":"H17","v":350000}]
["Prius",15000,{"$f":"B18-B18*3%","v":14550},14113.5,13690.094999999999,{"$f":"E18-E18*3%","v":13279.39215},{"$f":"F18-F18*3%","v":12881.0103855},{"$f":"G18-G18*3%","v":12494.580073935},{"$f":"H18-H18*3%","v":12119.742671716949}]
["Assets",{"$f":"SUM(B16:B18)","v":274200},277250,280413.5,283690.09499999997,285679.39214999997,287609.01038549998,289480.74007393501,291296.31787171698]
["Total Net Worth",{"$f":"B8+B15+B11+B19","v":523135},538815,564463.5,569775.09499999997,571764.39214999997,573694.01038550003,575565.74007393501,577381.31787171704]
[]
["Total Assets",{"$f":"B2+B3+B4+B15+B11+B17+B18","v":616935},{"$f":"C2+C3+C4+C15+C11+C17+C18","v":629115},651163.5,651255.09499999997,650844.39214999997,650446.01038550003,650059.58007393498,649684.74267171696]
["Total Liabilities",{"$f":"B5+B6+B7+B16","v":-93800},-90300,-86700,-81480,-79080,-76752,-74493.84,-72303.424799999993]
[]
["Percent Growth",null,{"$f":"(C20-B20)/B20","v":2.9973142687833923E-2},4.7601681467665156E-2,9.4099884226348952E-3,{"$f":"(F20-E20)/E20","v":3.4913725914959455E-3},{"$f":"(G20-F20)/F20","v":3.3748485599883887E-3},{"$f":"(H20-G20)/G20","v":3.2625923481007734E-3},{"$f":"(I20-H20)/H20","v":3.1544229813762073E-3}]

{"sheet":"Setup","index":8,"n_rows":60,"n_cols":4,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Parameter","Value","Default Value","Description"]
["File Version","2025.1.3",null,"https://moneyble.com/download-moneyble-excel-template/"]
["Download Google Form transactions automatically","No","No","Possible values: Yes/No. When it is set to Yes scheduled macro will sync transactions from Google Form to the Transactions sheet. Once an hour. And also on Activate event (when this file window becomes active)\nBefore enabling automatic mode review Import sheet in this file. Download a few Google transactions using buttons on the Import sheet (Refresh button and Copy to Transactions button). Once you confirm the Google Form is connected / transactions are downloaded - you can turn on automatic mode. \nNote: Automatic mode uses clipboard. Clipboard will be cleared. If this creates problems - turn off automatic mode.\nIf you change this parameter - close and reopen this file"]
["Generate Forecast from Subscriptions automatically","No","No","Future improvement. Possible values: Yes/No"]
["Automatically select  Amount column on Transactions sheet when the sheet is called from Budget by Year","No","No","Show Transactions button in Moneyble ribbon takes you to the transactions that constitute amounts in the actual columns on the Budget by Year sheet(s). You can also double-click on the amount in the Actual columns. This parameter controls if you want amount column to be automatically selected when Transactions sheet is displayed and filtered.\nWhen Amount column is selected - Excel shows the Auto sum at the buttom in the status bar. The Sum on the Transactions screen should match the value in the cell on the Budget by Year.\nIf you don't find this useful - set this to No"]
["Sync in progress","No","No","Do not change this parameter. This parameter is used internally by the macro in the mobile Moneyble Excel file to avoid refreshing mobile file while Transactions are being downloaded/created"]
["Last Activity","2024-11-04T17:36:26",null,"Do not change this parameter. This parameter is used internally by the macro in the mobile Moneyble Excel file to avoid refreshing mobile file while main file is in use"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Column B on Transactions sheet is validated against this list",null,null,"Column B on Investments sheet is validated against this list"]
["Budget Name","Type",null,"Investment Name"]
["Transfer","Other",null,"Pension"]
["Reimbursement","Other",null,"Kids Education"]
["Settled","Other",null,"Stocks"]
["Savings","Other",null,"Growth"]
["Salary","Income",null,"Transfer"]
["Bonus","Income"]
["Kids","Income"]
["Side Project","Income"]
["Other Income","Income"]
["Groceries","Expense"]
["Entertainment","Expense",null,"Do not change records with Type=Other"]
["Shopping","Expense",null,"Change Type=Income and Type=Expense entries as you see fit"]
["Bills","Expense"]
["Car","Expense"]
["Charity","Expense"]
["Health","Expense"]
["Other","Expense"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This list is used by the dropdown boxes that filter by account on Transactions sheet \n(do not change)"]
["Filter Drop Down "]
["Filter"]
["All"]