Open Source Visual Basic for Applications (VBA) Financial Software - Page 2

Create a roster by copying a list of email addresses from Outlook or consolidate multiple columns into one or two columns. Sheet control allows you to prefix all the sheets with numbers, sort the sheets alphabetically, or delete the desired sheets.

MyDataBars is a Microsoft Excel add-in program that draws data bars in worksheet cells. This program will enable you to create data bars in Excel prior to 2007.

So far this project can download options data from Google Finance, and show you the price and Greeks in a straddle view. let you run your options strategies in the Strategy tab, and show you the 3D diagram of price and Greeks along time and price.

Picartesius is a VBA library created by Lorenz Schiffmann for integrating Picat in Excel Spreadsheets. https://sourceforge.net/projects/picartesius Picat is a simple, and yet powerful, logic-based multi-paradigm programming language created by Neng-Fa Zhou and Jonathan Fruhman aimed for general-purpose applications. http://picat-lang.org

Full set of progams to create, edit and view SEPA documents.

This is a sample/educational demo payroll program, for learning payroll and MS-Access programming. It is similar to the web app WebPayAS2019, written in PHP/MySQL. WinPayXL is for a small business, with 1-15 employees. It should give you practice in learning payroll, installing on the Windows Desktop, and learning MS-Access. The WinPayXL App calculates payroll, and produces reports for tax and accounting purposes. New features for 2020 include this years Tax Percentages, and ability to print W2 forms at year end. Updates in AFPay3a.exe fixes deduction problem. Read the readme file, and manual, for greatest use of this App. Find this and/or other free programs at: dndlearning.com/marcusacademy/marcusmain/index.php Enjoy!

Depreciation is an accounting method, by which the dollar value of an asset (e.g. piece of equipment) is reduced, and applied to expense, as the asset is used and ages. When you buy an asset, the cost of it is debited to an asset account at the top of the balance sheet. This is true even if you pay cash for it. This is in contrast to applying the asset cost all at once to an expense account. The reason is that the asset is of value to the business. However, as the asset is used, and ages, it is correct accounting wise to decrease it’s value on the balance sheet, and apply the change in value during say, a month, to a cost account on the income statement. This APP calculates Straightline or Double Declining Balance book monthly depreciation.

If you are selling and/or repairing equipment you want to track (like computers, tractors, boats, snowmobiles, TV's, dishwashers or other things like that), this might be a good app for you. It should give you practice in learning/use of Invoicing, and installing on the desktop, and programming in vba and MS-Access. Note that the free MS-Access Runtime is with the download . You need MS-Access if you want to work with the program code (part of Office 365). The program processes Invoicing, Appointments, and Quotes, and produces reports for A/R, Inventory, History and Accounting Purposes. See the readme file, and manual for greatest use of this App. Find other free programs at: https://gotomarcus.com/marcusacademy/marcusmain/index.php

AF - Payables is a Windows Based Payables APP written as a sample application for programmers who want to learn VBA and the MS-Access database. So you can use it to help if you are programmer . You can also use it to do Payables for a small business (1 – 15 employees). Before beginning, please note that setting up, and logging into the APP, is described in the Appendix. Also read the readme.txt file in the program directory. Note that the program is a conversion of the Invoicing APP. So variable names, and tables, may, or may not, be converted from the original APP. (For example the old variable may have been m_cust, and is now m_vend. If you are reviewing the code, remember some of this code may be somewhat odd.) Now Ver 1b has been updated to 1c. You can now change the Fiscal Year Month on the Company Information screen.

This excel application allows you to manage your finances better! This tool allows you to record all your income and expenditures so you can see how much money you earn and spend. The tool also allows you to manage a budget.