Search Results
17 functions found:
| 1. | Easter ( theYear ; method1J2O3G ) |
  Average rating:
4.5 |
|
| Lewis Lorenz, Lorenz Companies | |
| Returns Julian, Orthodox, or Gregorian Easter dates for years 326 to 4000 (or 4099). | |
| 2. | FormatDateTime ( dateValue ; timeValue ; format ) |
 Average rating:
3.9 |
|
| Lewis Lorenz, Lorenz Companies | |
| Returns the dateValue and/or timeValue formatted as specified in format, using PHP-like coding, and allowing for escaped non-formatted text. | |
| 3. | FormatNumber ( number ; format ) |
| Average rating:
4.0 |
|
| Lewis Lorenz, Lorenz Companies | |
| Non-recursive function returns a text string of the 'number' in the requested 'format'. | |
| 4. | FormatTimestamp ( timestampValue , format ) |
| Average rating:
0.0 |
|
| Lewis Lorenz, Lorenz Companies | |
| Returns the Timestamp date and/or time formatted as specified in format. | |
| 5. | GetValueIndex ( valueList ; valueString ; matchCase ; occurrence ) |
| Average rating:
3.9 |
|
| Lewis Lorenz, Lorenz Companies | |
| Return index to value in valuelist. Search case sensitive or insensitive. Search for occurrence from front or end. | |
| 6. | GetValueIndexByPosition ( valueList ; valueString ; matchCase ; occurrence ; positionLCR ) |
| Average rating:
4.2 |
|
| Lewis Lorenz, Lorenz Companies | |
| Retrieve the index of the matching valueString in valueList by comparing valueString against the left, center (middle), or right of each value in valueList. | |
| 7. | IRR ( cashFlowsList ; guessRate ) |
| Average rating:
4.3 |
|
| Lewis Lorenz, Lorenz Companies | |
| Calculate Internal Rate of Return of a value list of cash flows with an initial guessed rate-of-return, using the Newton-Raphson method. | |
| 8. | NetPresentValueCF ( cashFlowsList, interestRate ) |
| Average rating:
0.0 |
|
| Lewis Lorenz, Lorenz Companies | |
| Calculate Net Present Value of a value list of cash flows (cashFlowsList) with a specified rate of return (interestRate). | |
| 9. | NPVV ( cashFlowsList ; interestRate ) |
| Average rating:
4.8 |
|
| Lewis Lorenz, Lorenz Companies | |
| Calculate Net Present Value of a value list (not a repeating field) of cash flows with a specified rate of return. | |
| 10. | PathMaker ( thePath ; theFile ; pathSeparator ) |
| Average rating:
4.8 |
|
| Lewis Lorenz, Lorenz Companies | |
| Returns a properly formatted folder and/or file path by processing and combining thePath, theFile, and pathSeparator. | |
| 11. | PathParser ( thePath ; returnElementPHFNE ) |
| Average rating:
4.3 |
|
| Lewis Lorenz, Lorenz Companies | |
| PathParser returns the directory path, home directory, full filename and extension, filename, or extension from a folder and/or file path string. | |
| 12. | StopwatchMilliseconds ( ctrlStartTimeLapListStopClear ; prefixText ; variableName ) |
| Average rating:
3.3 |
|
| Lewis Lorenz, Lorenz Companies | |
| Creates and manages a value list variable to track milliseconds with full stopwatch controls: Start, Time, Lap, List, Stop, or Clear. | |
| 13. | StopwatchSeconds ( ctrlStartTimeLapListStopClear ; prefixText ; variableName ) |
| Average rating:
3.7 |
|
| Lewis Lorenz, Lorenz Companies | |
| Creates and manages a value list variable to track seconds with complete stopwatch controls: Start, Time, Lap, List, Stop, or Clear. | |
| 14. | UniqueWindowName ( name ) |
| Average rating:
0.0 |
|
| Lewis Lorenz, Lorenz Companies | |
| Starting with | |
| 15. | ValueIndex ( valueList , valueString , matchCase , occurrence ) |
| Average rating:
0.0 |
|
| Lewis Lorenz, Lorenz Companies | |
| Returns the index/position of the matching valueString in the valueList. Returns 0 if not found. | |
| 16. | ValueIndexByPosition ( valueList, searchValue, matchCase, occurrence, positionLCR ) |
| Average rating:
0.0 |
|
| Lewis Lorenz, Lorenz Companies | |
| Retrieve the index of the value in valueList containing the matching searchValue. | |
| 17. | XIRR ( cashFlowList ; cashFlowDateList ; guessRate ) |
| Average rating:
4.4 |
|
| Lewis Lorenz, Lorenz Companies | |
| Returns extended internal rate of return - XIRR. Mimics Excel XIRR function. | |