Search Results
12 functions found:
| 1. | AddressBlock ( com ; cont ; a1 ; a2 ; a3 ; a4 ; c %3 |
  Average rating:
3.9 |
|
| Steve Gerow, Abrazos Data Consulting | |
| Calculated Address block from separate fields - handles missing elements | |
| 2. | AmtCompounded_cf ( principal ; rate ; iterations ) |
| Average rating:
4.2 |
|
| Steve Gerow, Abrazos Data Consulting | |
| Calculates compounded amount from principal, interest and number of iterations. | |
| 3. | DateDueHolidays ( StartDate ; TransitDays ; HolidayList ) |
 Average rating:
4.7 |
|
| Steve Gerow, Abrazos Data Consulting | |
| Due date from Start Date plus intervening days, adding Holidays from user-entered table | |
| 4. | DateHolidayFlag ( datefield ) |
| Average rating:
4.6 |
|
| Steve Gerow, Abrazos Data Consulting | |
| Holiday Weekend conditional formatting calc for date field | |
| 5. | DatePlusMinus ( datefield ; internal param ) |
| Average rating:
4.6 |
|
| Steve Gerow, Abrazos Data Consulting | |
| Enters current date, subtracts a day or adds a day | |
| 6. | DateShipByHolidays ( DueDate ; TransitDays ; HolidayList ) |
| Average rating:
4.4 |
|
| Steve Gerow, Abrazos Data Consulting | |
| Similar to ShipByDate but includes user-entered holidays from a table. | |
| 7. | ForceZero ( NumExpression ) |
| Average rating:
4.4 |
|
| Steve Gerow, Abrazos Data Consulting | |
| Forces a number calc field to display zero if is empty | |
| 8. | gsp |
| Average rating:
4.4 |
|
| Steve Gerow, Abrazos Data Consulting | |
| Using shorthand for common functions | |
| 9. | NextLetter ( MyNum ) |
| Average rating:
4.3 |
|
| Steve Gerow, Abrazos Data Consulting | |
| Increments letter sequence A - Z. | |
| 10. | TimeEasy ( mytime ; transtime ) |
| Average rating:
4.6 |
|
| Steve Gerow, Abrazos Data Consulting | |
| Time auto-formatting with assumed AM & PM during normal working hours. Allows input of abbreviated numbers, i.e. 7 for 7:00 AM and 3 for 3:00 PM. Allows override by use of one letter, for instance 10p for 10:00 PM. | |
| 11. | ToggleField ( myField ; value ) |
| Average rating:
4.4 |
|
| Steve Gerow, Abrazos Data Consulting | |
| Alternately sets and clears a field | |
| 12. | ToggleFlag_cf ( myfield ; myVL ; pos ; neg ) |
| Average rating:
4.6 |
|
| Steve Gerow, Abrazos Data Consulting | |
| Toggles between All and Clear for setting checkbox sets | |