| 3.01 |
Resize dropdowns on Print Form |
| |
Changed LINKS buttons at bottom of PROGRAM page; Income Statement buttons
were showing up when the section was hidden |
|
Redesigned WWB PA page (was non-functional in version 3.0) (still in
progress at release of 3.01) |
|
Added warning about Excel 97 and digital certficate; now distributing TWO
versions!!!! |
|
Changed "old version" warning from 180 days to 360 days |
| |
Hide "Revalue FA" line on NAVIGATOR |
| |
Corrected version number on REFERENCES; added numeric equivalent so that
IMPORT would work when Windows configured for x.xxx,xx |
| 3.02 |
Correct line 1.32 on VAR ANALYSIS page; sum formula was missing line 1.30 |
| |
Correct import references for offset on MODEL SETUP for row 210 prior to
version 2.97 |
| 3.03 |
Change loan officer calcs for Yrs 3-5; removed one-quarter shift on staffing
requirements |
| |
Fix loan officer calcs for Yrs 3-5; was ignoring caseload override line |
| |
Add formula/comments columns used for technical documentation; major
addition on nearly every sheet! |
| |
Revise spanish translation to match translation of "Using Microfin 3" manual |
| |
Added support for manual programming of initial loans over 24 months for
Product 1 on PRODUCTS page |
| |
Make "auto-width" line on PROGRAM bold to avoid potential ##### after
resizing |
| |
Correct "Number of Loans Disbursed" Graph; was showing Month 0 |
| |
Change OpenMicrofin VBA to correct problem of not finding Help file |
| 3.04 |
Import routine didn't work in 3.03; offset range wasn't set up; won't do
imports from 3.03 |
| |
Further clean-up and documenting of VBA macros |
| |
Changed to right-alignment on loan officer "overcapacity" line on PROGRAM
page |
| |
The ShowPrintGraphMsg wasn't in use; removed it from VBA procedure |
| |
Indexing calculations were screwed up after Month 37 due to changes made in
version 3.03 (additional of TechDoc columns); now corrected |
| |
Investment income lines on FIN FLOWS did have ISBLANK test; changed to
ISNUMBER to avoid text entries |
| |
Continued with formula/comments columns used for technical documentation;
added buttons to show/hide documentation |
| |
If Bal Sheet doesn't balance, now flags an error (in red) on NAVIGATOR |
| |
Add AutowidthAllPages command at end of Import process |
| 3.05 |
Revised spanish translation based on final CGAP review |
| 3.06 |
Correct macro to show TechDoc info |
| |
Formula error: Misc other exp formula was incorrect for
Yrs 3-5. On program it multiplied by 3 and shouldn't have; on Admin it did
not multiply a fixed amount by 3 and should have |
| |
Removed "private" on various VBA procedures to allow users to access them in
emergency situations |
| |
Added "DisableEvents" button on Model Setup |
| |
Fixed: Draw Graph button didn't work for "Avg Loan Size" graph |
| |
Correct formula for 9.52 on PROGRAM (Number new clients per loan officer);
was showing quarterly figure for Yrs 3-5 |
| |
Fix: Automatically change branch sheet names when name is input; avoids
error where user forgets to click the RENAME button (that button is now
unnecessary; left there to avoid confusion) |
| |
On NAVIGATOR, line 4.05, flag error if programmed repayments are not correct |
| |
Eliminated rotating Microfin logo on INTRO page; took too long to redraw in
Excel XP |
| |
Add warning on first open with Excel 97 to use CTRL-ALT-F9 |
| |
Correct problem: Reserves row on compulsory savings was not displaying
properly under some conditions |
| |
Correct problem: Use VBA command on first-time Microfin used to clear
contents of optional FY cell on MODEL SETUP |
| |
Correct problem: Change VBA routines so sheets are renamed properly when
changing languages; was incompatible with Excel XP |
| |
Incorporated French translation changes from Feb 2002 that were left out |
| |
Added Explicit variable declaration to all VBA routines (part of Technical
Documentation requirements) |
| 3.07 |
Correct formula on line 2.40 for Products 3&4 on PROGRAM page; was showing
improper reference number; also affected reference number showing in line
2.32 |
| |
Some VBA corrections for getting SaveName for file; was problem with
explicit variable declaration introduced in 3.06 |
| |
Correct TransferUserSheets routine; wasn't copying formatting of user sheet
during Import process |
| |
Correct VBA when importing data to an earlier version; wasn't flagging the
error, a problem introduced in 3.01, I think |
| |
Solved worksheet renaming problem in Excel XP when switching languages; had
to modify VBA |
| 3.071 |
Fixed ERROR indicator on line 4.05 of NAVIGATOR sheet |
| |
Fixed checkbox control for Advanced Loan Officer input lines on PROGRAM page |
| 3.071a |
Correct FAStepNum variable in VBA code; would crash when opening a
branch-level planning model |
| |
Correct "Compusory Savings on Bal Sheet" section; reserves lines weren't
displaying sometimes |
| |
Note: this version was released with a different release date than 3.071. I
could not change version number because of client needing to import
branch-level planning data, which requires same version |
| 3.072 |
Correct Export routines to close DataWorkbook upon completion |
| |
Added hooks for Compartamos branch process |
| |
Added means to optionally password protect user sheets during export/import
process |
| 3.08 |
Added full support for initial loan balances with terms greater than 24
months |
| |
Modified formula for "number of loans maturing" for Product 1, Yrs 3-5, on
PROGRAM page; revised the change made in version 3.03 |
| |
Add button on INTRO sheet to export Compartamos user-sheet data |
| |
Modify EraseAll VBA procedure to solve FY input cell glitch on MODEL SETUP |
| |
Change Step 5 Eff Int calc to include if int rate method is changed in Month
1 |
| |
Fix penalty income on Products 2/3/4; was double-counted on ADMIN page |
| |
Fix "loan repayment" formula for Product 4, Yrs 3-5 on PROGRAM page; was
only deducting loan write-off for one month each quarter |
| 3.081 |
Modify Export VBA routine to shrink size of hidden EXPORT DATA page |
| |
Correction: PROGRAM, line 5.08 of Product 1, would calculate inaccurate
interest if int rate changed in Month 25 |
| |
Correction: FIN FLOWS sheet "unrestricted loans w/o default" calculation
line only added sources 1,2,&6. Allowed for illiquidity when default
sources activated if sources 3,4, or 5 had activity. |
| |
Added some calculation rows on PROGRAM to determine loan maturation for GAP
analysis (used in Mexico Superintendency reports) |
| |
Modified import/export VBA routines to flag formulas longer than 255
characters in length because they truncated during Export/Import |
| |
Added support for Add-on Tools through Import process that doesn't erase
model or delete existing user sheets |
| |
Modify add-sheet routine to speed up routine; also remove confirmation
during import process |
| |
Add ability to transfer comments on user-sheets during export/import
(validation not working yet) |
| |
Show warning if user-sheet with same name exists during import process |
| 3.1 |
Released 1 April 2004 |
| Major Additions |
ModelSetup: Added support for up to 20 branches in Excel XP and future
versions |
| |
Program/Admin/InstCap: Added additional lines for staffing, other op, and
fixed assets |
| |
FinSources/FinFlows: Added additional input lines for all financing sources |
| |
NOTE: reference line numbers may no longer match those in manual due to
additional input lines added throughout Microfin |
| |
InstCap: Added feature to auto-hide unused rows to make the sections more
concise |
| |
Export: Revised Export Wizard to allow access to new add-on tool creation
feature |
| |
FinFlows: Allow default loan interest rate to vary by month |
| Important Refinements |
Added branch sheet navigation to "Go To" menu on Microfin Toolbar |
| |
ModelSetup: Added ability to add multiple branch sheets at once |
| |
Products: Added option to analyze STEP 5 on PRODUCTS for any month input |
| |
FinFlows: Added "yellow light" warning to liquidity line 5 in top section |
| |
Graphs: Revised Cost Structure graph to match Expenses graph |
| |
Export: Modified message about branch-level planning model on EXPORT Wizard
to minimize user errors |
| |
GraphClipboard: Added GRAPH CLIPBOARD to export/import |
| |
Intro: Added option to load sample FEDA case study data |
| Bug fixes |
FinStatements: Corrected PAR formula in Ratios section; was incorrect
sometime after version 3.03; did not affect projections or graphs |
| |
Graphs: Fixed AROA/AROE graph; wouldn't show trends when all frozen values
were = N/A |
| Minor changes |
Changed "old version" warning from one year to six months |
| |
InstCap: Added autowidth feature to INSTCAP |
| |
Hid calculation rows at bottom of each sheet; add button on MODEL SETUP to
unhide them |
| |
Products: Extended grace, commission, indexing, and floating rate cells
into Init Bals columns |
| |
Products: Improved warning messages for STEP 5 if loan term exceeds 24
months |
| |
Products/Program/Admin: Added more yearly-column totaling |
| |
Graphs: Improved terminology on various graph labels |
| |
Graphs: Improved warning messages on GRAPHS page |
| |
FinSources: Changed recalc method on FIN SOURCES sheet; was too slow in
Excel 2003 |
| |
Program: Improved autowidth function on PROGRAM sheet (was missing some
sections) |
| |
Intro: Deleted all version history prior to 3.0 |
| |
Export: Added percent variance column |
| |
FinFlows: Refined weighted cost of funds formula |
| |
GraphClipboard: Added GRAPH CLIPBOARD to "erase workbook" routine |
| |
References: Removed top section of REFERENCES from the Import/Export
process (maintains previous setup information) |
| |
Improved opening routine to resize columns showing Microfin line numbers |
| |
ModelSetup: Added % of memory used stat when in Branch mode (for Excel
prior to XP) |
| |
GraphClipboard: Changed color scheme |
| |
GraphClipboard: Added worksheet protection |
| 3.11 |
Released 15 April 2004 |
| Bug fixes |
Corrected description formulas on 1.143 and 1.144 of PROGRAM; showed
incorrect Fixed Asset descriptions; all calculations correct |
| |
InstCap: Automated linkages were not working for new rows added for
staffing, other op, fixed assets |
| 3.12 |
Released 20 April 2004 |
| Bug fixes |
Autowidth routine would crash in Excel 2002; solved by unhiding the "autowidth"
row on each sheet |
| 3.13 |
Released 10 June 2004 |
| Bug fixes |
New financing source lines were not being fully picked up in FinFlows
sections; would cause Balance Sheet to get out of balance |
| |
Fin.Statements: new equity lines (lines 4&5) were not being picked up on
"Shareholder Equity" line of Balance Sheet |
| 3.5 |
Released 20 July 2004 |
| |
The following list summarizes all changes from 3.1 to 3.5, by sheet |
| New Rows |
Additions to rows in Microfin may affect formulas that you import from
previous versions. Review this information to correct your formulas |
| Environment |
• Added new INTRODUCTORY mode for new users; makes substantial modifications
throughout the model to simplify input; list of changes appears on MODEL
SETUP |
| |
• Revised Setup Wizard to ask about new features |
| |
• Reorganized OPTIONS menu to reflect new features |
| |
• Hid all support calculation lines at end of sheets; can be accessed via
OPTIONS menu |
| |
• Added option to load FEDA sample data |
| |
• Added option to expose all rows via OPTIONS menu |
| |
• Added option to display technical documentation via OPTIONS menu |
| |
• Added “Go To Branch x” option on GOTO menu on Microfin Toolbar |
| |
• Add error checks throughout model to test for data entered into hidden
lines and for logical inconsistencies |
| |
• Changed "old version" warning from one year to six months |
| |
• Rezoom all sheets to 100% after Erase procedure |
| |
• Added "new user" reminders that show up every 7th time user changes sheets |
| |
• Added "first-time" notices for each sheet |
| |
• Allow user to search for Help file if not found in expected locations |
| |
• Added elapsed time since last save in notice after Microfin opened |
| |
• Incorporated links for new Ford-sponsored self-study tutorials |
| |
• Add option to select language of pop-up help when user-defined language is
enabled |
| Navigator |
Microfin 3.5 
