EOF

Hi,

This site has been merged into FrontierDigest.
See you there :-)


Regards,
**

HP-calculator equation, financial investment

This equation is for quick calculation of buying/selling stocks.

IF(S(AMT) OR S(VOL): AMT-VOL*PRICE :
(VOL*PRICE-ABS(VOL*PRICE*COM%/100*(1+VAT%/100)))-TOTAL)

Input negative value either AMT or VOL to indicate buying.
Note that I use '*' and '/' for multiply and divide operators respectively (the calculator uses exact arithmatic symbols).

I should add more from HP 200LX later.

Cheers,
[vps]

LotusNotes: asset aging formula

This formula calcaluates age from field 'Purchase_date' and rounds to 0.5-year interval.

y0 := @Today;
y1 := @Year(y0) +(@Month(y0)/12);
x0 := @If(Purchase_date=""; y0; @TextToTime(Purchase_date));
x1 := @Year(x0) +(@Month(x0)/12);
@If(Purchase_date=""; -1; @Round(y1 - x1 -0.24; 0.5))

Actually the formula of y1 (and x1) would be "... +((@month(y0) -1) /12)". However, when (y1 - x1) is computed, result will be correct value.

Offset value 0.24 is used to implement "round down" or "floor" function. It is 0.24 instead of 0.25 in order to avoid case when the item has just been purchased (where result will be calculated to -0.25 and then rounded down to -0.5). If quarterly-basis is preferred, @round's arguments become (y1 - x1 -0.124; 0.25).

In this context, the field Purchase_date is text type. Formula returns -1 when Purchase_date has no value.

How to break "prevent copying" setting from sender

Solution: remove field "$KeepPrivate".

Refer IBM/Lotus KB Document# 1097631: Is "Disable Printing/Forwarding/Copying to Clipboard" a security feature?

... You can prevent Notes mail recipients from copying a Notes mail message that you send. This includes copying with the clipboard, forwarding, replying with history, and printing. However, this option is merely a deterrent to copying. Recipients can still use other means to copy the message.

Agent formula "etc\Remove $KeepPrivate"

FIELD $KeepPrivate := ""

How to set icon to mail sent in Lotus Notes

Solution: Set field "_ViewIcon" before sending.

1. Compose mail and save as draft.
2. In Drafts folder, select the mail and run agent.
3. Open the mail and send it out.

You can also preset mail icon in stationery.

Refer IBM/Lotus document# 1089446.

Agent formula "etc\Set mail icon"

FIELD _ViewIcon := @TextToNumber(@Prompt([OkCancelEdit]; "Set mail icon";
"Input the icon#."; 99));
SELECT @All

Hello world

Test