PowerHome Formula Functions
abs
acos
asc
asca
asin
atan
b2d
case
ceiling
char
chara
clipboard
cos
d2b
d2h
date
datetime
day
dayname
daynumber
daysafter
dec
double
exp
fact
fill
filla
h2d
h2s
hour
if
int
integer
isdate
isnull
isnumber
istime
lastpos
left
lefta
lefttrim
len
lena
log
logten
long
lower
match
mid
mida
minute
mod
month
now
number
ph_addtoglobal
ph_addtovar
ph_and
ph_backupdb
ph_base64decode
ph_base64encode
ph_ccaction
ph_ccclearchgs
ph_ccdescribe
ph_ccdescribeid
ph_ccimage
ph_ccmapinfo
ph_ccmodify
ph_ccmodifyid
ph_checktrigger
ph_chggrammar
ph_chgspeaker
ph_clearexequeue
ph_clearvars
ph_clearx10hist
ph_closewindow
ph_colorcalc
ph_combuffercount
ph_combufferptr
ph_combufferreset
ph_comclose
ph_comdtr
ph_comopen
ph_comopensimple
ph_comrecvchar
ph_comrecvstring
ph_comrts
ph_comsendchar
ph_comsendstring
ph_concatglobal
ph_concatvar
ph_convertimage
ph_convertir
ph_copyfile
ph_createdirectory
ph_createglobal
ph_createpluginpt
ph_createtimedevent
ph_createtimedevent1
ph_ctlrcmd
ph_ctlrcmd1
ph_ctlrcontrol
ph_ctlrsq
ph_ctof
ph_datetime
ph_dbwhereused
ph_debuginfo
ph_decrypt
ph_delay
ph_deletedata
ph_deletefile
ph_deleteglobal
ph_deletetimedevent
ph_devicebtn
ph_devicecontrol
ph_devicerefreshstat
ph_directsql
ph_disabletrigger
ph_doloop
ph_enabletrigger
ph_encrypt
ph_evalscript
ph_executescript
ph_exportdata
ph_exporteventlog
ph_extendmacrowait
ph_extractval
ph_fileexists
ph_filelength
ph_filelist
ph_fill
ph_filterdata
ph_finddata
ph_findwindow
ph_findwindowex
ph_fixhtmlquotes
ph_fixjsquotes
ph_flattenjson
ph_flattenxml
ph_forloop
ph_forloopwinc
ph_formula
ph_formulabtn
ph_formulabtn_d
ph_formulabtn_dt
ph_formulabtn_n
ph_formulabtn_s
ph_formulabtn_t
ph_formulabtnparm
ph_fromunixtime
ph_ftoc
ph_funcdef
ph_funclist
ph_genctlrtrigger
ph_getanalog
ph_getanalogcalcstat
ph_getanalogstat
ph_getcclastobj
ph_getcclasttab
ph_getccobjbcolor
ph_getccobjborder
ph_getccobjfcolor
ph_getccobjgraphic
ph_getccobjheight
ph_getccobjtext
ph_getccobjwidth
ph_getccobjx
ph_getccobjy
ph_getcctab
ph_getcctabid
ph_getclassname
ph_getcolcount
ph_getcolname
ph_getcoltype
ph_getdata
ph_getdata_cn
ph_getdata_raw
ph_getdatawithmask
ph_getdevicefilter
ph_getdevicesort
ph_getdevicestat
ph_getdeviceval
ph_getdigital
ph_getdigitalstat
ph_getexefromhandle
ph_getforegroundwindow
ph_getglobal_d
ph_getglobal_dt
ph_getglobal_n
ph_getglobal_s
ph_getglobal_t
ph_gethandle
ph_gethtmldata
ph_getinputret
ph_getinsteonctrl
ph_getinsteondt
ph_getinsteonlevel
ph_getinsteonlevelrt
ph_getinsteonseconds
ph_getinsteonstat
ph_getipfromhostname
ph_getitcurl
ph_getlasterror
ph_getlasterrorstring
ph_getline
ph_getmbret
ph_getmd5hash
ph_getmode
ph_getmtret
ph_getparent
ph_getphdir
ph_getphwebdir
ph_getsha1hash
ph_getsha256hash
ph_getsqlrows
ph_getsuntime
ph_getsyspwrstat
ph_getsystemvar
ph_getsysvol
ph_getsysvolmax
ph_getsysvolmin
ph_getteactive
ph_gettetime
ph_gettickcount
ph_gettimeout
ph_gettimezoneinfo
ph_getupbdt
ph_getupblevel
ph_getupblevelrt
ph_getupbseconds
ph_getupbstat
ph_geturl
ph_geturl1
ph_geturlviaproxy
ph_geturlviaproxy1
ph_getvar_d
ph_getvar_dt
ph_getvar_n
ph_getvar_s
ph_getvar_t
ph_getvarsub
ph_getversion
ph_getwburl
ph_getwebauth
ph_getwebbase64auth
ph_getwebcookie
ph_getwebheader
ph_getwebheaderparm
ph_getwebmethod
ph_getwebparm
ph_getwebremoteip
ph_getweburl
ph_getwindow
ph_getwindowsdir
ph_getwindowstate
ph_getwindowtext
ph_getx10dt
ph_getx10level
ph_getx10seconds
ph_getx10stat
ph_getzwavecalcval
ph_getzwavedata
ph_getzwavedataraw
ph_getzwavedt
ph_getzwaverawval
ph_getzwaverawvalrt
ph_guid
ph_handle
ph_handle1
ph_hextonum
ph_highestcontrast
ph_htmlcolor
ph_htmlescape
ph_htmlescape1
ph_htmlunescape
ph_httprequest
ph_huerawcmd
ph_huergbtoxy
ph_huexytorgb
ph_importdata
ph_insertdata
ph_insteon
ph_insteonclearfailed
ph_insteonctrl
ph_insteongroup
ph_insteongroupcu
ph_insteonraw
ph_insteonrawbcast
ph_insteonrawext
ph_insteonrawgroup
ph_insteonrawgroupcu
ph_insteonwithret
ph_insteonwithret1
ph_insteonwithretext
ph_insteonwithretext1
ph_ir
ph_irchain
ph_irdesc
ph_irnumseq
ph_isdaylightsavings
ph_iseven
ph_ismacrowaiting
ph_isnull
ph_isodd
ph_isssrunning
ph_isvalidip
ph_iswslocked
ph_itccancel
ph_itccreate
ph_itcdestroy
ph_itcexecuteftp
ph_itcexecutehttp
ph_itcgetdata
ph_itcisbusy
ph_itcisvalid
ph_itcsavedata
ph_itcseturl
ph_itcsetuserpass
ph_jsontoxml
ph_jsontoyaml
ph_keybd_event
ph_killallmacrowait
ph_killmacrowait
ph_killprocess
ph_latlongcalclat
ph_latlongcalclong
ph_latlongdist
ph_latlongendbearing
ph_latlongmidlat
ph_latlongmidlong
ph_latlongstartbearing
ph_ldapquery
ph_listprocesses
ph_locatehandle
ph_locatehandle1
ph_locateprocess
ph_lockworkstation
ph_luminance
ph_macro
ph_macroparm
ph_macroparmret
ph_minutesafter
ph_minutestostring
ph_modifytimedevent
ph_movefile
ph_mqttpub (General)
ph_mqttpub (MQTT table)
ph_mqttsub
ph_mqttunsub
ph_msgbox
ph_multix
ph_multixtime
ph_n2b
ph_natlang
ph_not
ph_number
ph_numtohex
ph_numtohex1
ph_openframe
ph_openiewindow
ph_openphwin
ph_or
ph_pad
ph_parseline
ph_picmd
ph_pictrl
ph_pid
ph_pidclear
ph_ping
ph_ping1
ph_pitrigger
ph_playlist
ph_playsound
ph_playwinmsg
ph_pos
ph_postcopydata
ph_postexequeue
ph_postformula
ph_postmsg
ph_postmsg_s
ph_posturl1
ph_posturlviaproxy1
ph_powerhomeuptime
ph_powerhomeuptime_s
ph_processemail
ph_processemailthread
ph_processfromhandle
ph_random
ph_readfile
ph_regactivex
ph_regex
ph_regex2
ph_regexdiff
ph_regexdiff1
ph_regexdiff2
ph_regexsnap
ph_regexsnap1
ph_regexsnap2
ph_regexsnap3
ph_reinitialize
ph_relativedatetime
ph_relativedtprecise
ph_relativetime
ph_removedirectory
ph_replaceall
ph_replaceallmulti
ph_replaceallregex
ph_replaceallregex3
ph_replaceregex
ph_replaceregex3
ph_retrievevars
ph_returnallvars
ph_rgb2milight
ph_rtne
ph_rtnes
ph_run
ph_run1
ph_runasuser
ph_runasuser1
ph_runavg
ph_runscript_0
ph_runscript_1
ph_runscript_2
ph_runscript_3
ph_runscript_4
ph_runscript_5
ph_runsync
ph_runsync1
ph_savedesktopimage
ph_saveframe
ph_saveitcurl
ph_saveurl
ph_saveurl1
ph_saveurlviaproxy
ph_saveurlviaproxy1
ph_scrapetext
ph_seconds
ph_secondsafter
ph_secondsdiff
ph_secondsdiffsec
ph_sendcopydata
ph_sendemail
ph_sendemailfile
ph_sendkeys
ph_sendkeysbtn
ph_sendkeysmq
ph_sendmsg
ph_sendmsg_s
ph_sendsmtpemail
ph_sendsmtpemailasync
ph_sendsmtpemailfile
ph_sendsmtpemailfile1
ph_sendsmtpemailfileasync
ph_sendsocketdata
ph_sendsocketdata1
ph_sendudp
ph_setanalogdisplay
ph_setanalogout
ph_setanalogoutraw
ph_setanalogvalue
ph_setccobj
ph_setccobjbcolor
ph_setccobjborder
ph_setccobjfcolor
ph_setccobjgraphic
ph_setccobjheight
ph_setccobjtext
ph_setccobjwidth
ph_setccobjx
ph_setccobjy
ph_setcctab
ph_setcctabid
ph_setdata
ph_setdevicefilter
ph_setdevicesort
ph_setdeviceval
ph_setdigitalout
ph_setfileattrib
ph_setforegroundwindow
ph_setforegroundwindow1
ph_setframe
ph_setglobal_a
ph_setglobal_s
ph_setinputret
ph_setlocals
ph_setmode
ph_setsystemvar
ph_setsysvol
ph_settemps
ph_settimeout
ph_setvar_a
ph_setvar_s
ph_setwebcontenttype
ph_setwebcookie
ph_setwebnexturl
ph_setwebreturn
ph_setzwavedisplay
ph_show
ph_shutdown
ph_snapxml
ph_sortdata
ph_split
ph_sql
ph_sql_d
ph_sql_dt
ph_sql_n
ph_sql_s
ph_sql_t
ph_sqldestroy
ph_sqlselect
ph_sqlselectinto
ph_ssrequest
ph_stacktrace
ph_storevars
ph_sumnum
ph_switchto
ph_system
ph_texttojson
ph_timedeventsctrl
ph_timedeventsinfo
ph_tounixtime
ph_tracemsg
ph_traceoff
ph_traceon
ph_trim
ph_trimeventlog
ph_tts
ph_ttsctrl
ph_ttsgetstatus
ph_ttspause
ph_ttsresume
ph_ttssetvoice
ph_ttssync
ph_ttswait
ph_upb
ph_upblink
ph_upbraw
ph_upbrawlink
ph_updatexml
ph_urlescape
ph_usererrmsg
ph_usermessage
ph_varsub
ph_vrdisable
ph_wcclose
ph_wcgethome
ph_wcgethtml
ph_wcgoback
ph_wcgoforward
ph_wcgohome
ph_wcgourl
ph_wcisbusy
ph_wcopen
ph_wcrefresh
ph_wcsethome
ph_wcsethtml
ph_wcshow
ph_wcstop
ph_webaddblob
ph_webclearblob
ph_webds
ph_webdschg
ph_webml
ph_webmu
ph_websl
ph_whileloop
ph_winampctrl
ph_winampinfo
ph_windowstate
ph_windowsuptime_s
ph_writefile
ph_x10
ph_x10btn
ph_x10lookup
ph_x10other
ph_x10refreshstat
ph_x10setstat
ph_xmltojson
ph_xor
ph_xp2u
ph_xu2p
ph_yamltojson
ph_yp2u
ph_yu2p
ph_zero
ph_zwaveget
ph_zwavegetconfig
ph_zwaverawset
ph_zwaveset
ph_zwavesetcalc
ph_zwavesetconfig
pi
pos
posa
posw
profileint
profilestring
rand
real
relativedate
relativetime
replace
replacea
rgb
right
righta
righttrim
round
s2h
second
secondsafter
setprofilestring
sign
sin
space
sqrt
string
tan
time
today
trim
truncate
upper
wordcap
year