Fixed a bug which might cause Summary IRR to be shown as 0 due to retired funds; by using workaround which places dummy values on retired rows without affecting the actual IRR value
Fixed the data validation for Transaction Amount column for type=Dividend (now properly rejects non-positive values)
Updated Data Validation for ""Sales Charge / Redemption Fee"" field from accepting values between 0% - 100% to accepting values between 0% - 200% (semua salah investment-linked insurance policy)
Added ""Unit Split"" and ""Transfer In"" type. The transaction type has the same treatment as per current set-up for Dividends (Add additional units directly to the fund).
Updated formulas and data validation to accomodate the new units
Slight tweak to the formating of ""FACT SHEET DATE"" to Month & Year only.
Separately built FSM CONVERSION TOOL (for copy-pasta from FSM HISTORIC transactions) - compatible with spreadsheet v1.4 or higher (v1.4 spreadsheet will need to manually change some of the Transaction Types, as it is not existing in v1.4 yet)

Initial Version
Tested and working for Spreadsheet v1.4 or higher.
For spreadsheet version 1.4; ""minor tweaks"" to the converted data will be required - if your transactions has ""Transfer In"" or ""Unit Split"" type. This is because v1.4 spreadsheet does not have these T-Type yet.

Special thanks to contributors whom have contributed their sample FSM data to speed up the development & testing of this tool.