HEXelon calculator   Contact  Functions (formulas) created by HEXelon MAX users. Select for using in the program: Menu>Edit>Functions>Download. Also you can create your own function: Menu>Edit>Functions>New and next publish in the Internet:Menu>Edit>Functions>Publish. Every function can use in the program by downloadig from web server: Menu>Edit>Functions>Download. More details about users functions in the program help (F1 key) or here.   find: no. function data description 485 AccelerationEarth variables: szerokosc,wysokosc formula: 9,780318*(1+0,0053024*Sin(szerokosc)^2-5 ... author: MF Oblicza przyśpieszenie ziemskie na podstawie szerokosci geograficznej i wysokosci 505 Act_P variables: U,I,fi formula: U*I*Cos(fi*Pi/180) author: Srbin Derives Active Power (watts) out of current (Amps), voltage (volts) and angle (degrees) U*I*Cos(fi*Pi/180) 506 Act_P variables: U,I,fi formula: U*I*Cos(fi*Pi/180) author: Srbin Derives Active Power(watts) out of current (Amps), voltage (volts) and angle (degrees) U*I*Cos(fi*Pi/180) 440 ADCresultForAVR variables: Vref,Vin formula: (Vin*1024)/Vref author: tomm Calculates ADC conversion result for AVR uC with ADC unit. 502 ADCresultForAVR variables: Vref,Vin formula: (Vin*1024)/Vref author: tomm Calculates ADC conversion result for AVR uC with ADC unit. 530 Ampare variables: Watts,Volt formula: Watts/Volt author: Hye-Won Ŕü·ů(A)=Ŕü·Â(W)/ŔüľĐ(V) 409 Amperes variables: Volts,Ohms formula: Volts/Ohms author: Sorin Stoenescu Calculate electric current for a given voltage and resistance 410 Amperes2 variables: Watts,Volts formula: Watts/Volts author: Sorin Stoenescu stoenescusorin@yahoo.com Calculate electric current for a given power (watts) and voltage 476 ArcLenDMS variables: D1,M1,S1,D2,M2,S2,r formula: r*((D1+M1*(1/60)+S1*(1/3600))-(D2+M2*(1/ ... author: Craig/relki@Hotmail.com Arc Length with DMS as input 439 arcoingradi variables: nm formula: nm/3440.07*180/Pi author: perego trovare l’arco in gradi partendo dalle miglia 319 AreaCircle variables: dia formula: Pi*dia^2/4 author: Gregory Psychogyios Restituisce l’area del cerchio di cui si conosce il diametro 575 Bitrate variables: Seconds formula: Div(699*1024*1024/1000*8/Seconds;8)*8 author: Maple Input length in seconds to retrieve required bitrate per 700 MiB 285 BitToMbyte variables: bit formula: bit/8192 author: Peter Converting bits to megabayte For the ever confusing discusions about how fast your DLS modem is. 357 BMI variables: height_m,weight_kg formula: weight_kg/(height_m*height_m) author: The body mass index (BMI), or Quetelet index is a statistical measurement which compares a person’s weight and height. More info: http://en.wikipedia.org/wiki/Body_mass_index 289 Boltzman variables: formula: 1.380662E-23 author: unknown Boltzman constant 549 CCTV_LensAngle variables: width,distance formula: 2*ATan((width/2)/distance) author: daniel ATan ¸¦ ŔĚżëÇŃ CCTV ·»ÁîŔÇ Č­°˘ ±¸Çϱâ. Č­¸éżˇ ĂÔ»óµČ ÇÇ»çĂĽŔÇ ĽöĆňĆř=width Ä«¸Ţ¶ó ·»Áî ĂĘÁˇżˇĽ­şÎĹÍ ÇÇ»çĂĽ±îÁö ĽöÁ÷°Ĺ¸®=distance 551 CCTV_Resolution variables: max_voltage,min_voltage formula: ((max_voltage-min_voltage)/(max_voltage+ ... author: daniel CCTV Ä«¸Ţ¶ó ÇŘ»óµµ °č»ę CCTV Lab. CCTV Camera Resolution. Ľ±ĹĂÇŃ ¶óŔÎżˇĽ­ °ˇŔĺ łôŔş ŔüľĐ°ú °ˇŔĺł·Ŕş ŔüŔ»Ŕ» ŔÔ·ÂÇŃ´Ů. 343 Ceiling variables: x,DecimalPlaces formula: (Div(x*10^DecimalPlaces;1)+1)/10^Decimal ... author: Will Pittenger Like floor, removes the decimal places to the specified point, but adds 1 to the result. 134 CelsiusToFarengheit variables: celsius formula: 1,8*celsius+32 author: Knoppix/knoppix@starlink.ru Converts temperature from Celsius to Farengheit. 157 CircleCircumference1 variables: radius formula: 2*Pi*radius author: author unknown Circumference of circle - given radius. 397 CircleDiameterToSquareSide variables: CircleDiameter formula: (Cos(45)*(CircleDiameter/2))*2 author: unknown The side of the largest square within a circle with given the diameter. 513 Cnr variables: number1,number2 formula: (number1!)/(number2!*((number1-number2)! ... author: Lonbo/uniking0617@gmail.com C(n;r)=n!/(m!*(n-m)!) 179 Consumption variables: FuelLitre,DistanceKm formula: FuelLitre/(DistanceKm/100) author: Patyi/bobafett@hdsnet.hu Calculates avarage fuel consumption in (litre in 100km). 356 CoolingLoadChiller variables: gpm,dt formula: (500*gpm*dt)/12000 author: Leon P Find tons of cooling required (tons of cooling) 156 DiskArea1 variables: radius formula: Pi*radius^2 author: author unknown Area of disk - given radius length. 501 Dosis variables: X,Y formula: (X*5)/Y author: Dr. Migue Edo. Poblete Sepúlveda X: CANTIDAD Y: CONCENTRACIÓN 284 dse_off_angle variables: PanStroke,AngleOfAttack,AngleOfDrive formula: (PanStroke/2)*Cos(AngleOfAttack-AngleOfD ... author: unknown Calculate drive shaft eccentric. 550 Dynamic_Range variables: max_illumination,min_illumination formula: 20*Log10(max_illumination/min_illuminati ... author: daniel ´ŮŔĚłŞąÍ ·ąŔÎÁö(dB) °č»ę °ˇŔĺ ąŕŔş şÎşĐ = max_illumination °ˇŔĺ ľîµÎżî şÎşĐ = min_illumination 261 ElectronCharge variables: formula: 1.602176487E-19 author: unknown Electric charge of electron [C] 383 EllipseX variables: Y,EllipseMajR,EllipseMinR formula: EllipseMajR*Root(1-(Y/EllipseMinR)^2) author: Sergey A Shilov Calculate Ellipse X coordinate by input known Y coordinate, Ellipse Semimajor and Semiminor Radiuses. 384 EllipseY variables: X,EllipseMajR,EllipseMinR formula: EllipseMinR*Root(1-(X/EllipseMajR)^2) author: Sergey A Shilov Calculate Ellipse Y coordinate by input known X coordinate, Ellipse Semimajor and Semiminor Radiuses. 424 ExtcoeffToAbscoeffCm1 variables: k formula: k*4*Pi/4E-5 author: matthew/mat.matthew@wp.pl Calculate absorption coefficient from extinction coefficient for wavelength of 400 nm 558 FindCommValue variables: PrezzoA,QuantA,Min,Max,Perc formula: If(QuantA*PrezzoA*Percauthor: sIMPLYmE4U4Free Dati i valori del Minimale, Massimale e del Tasso di comm.ne applicabilii ad un ordine, la q.tŕ ed il prezzo del bene, stabilisce quale caso viene applicato e l’entitŕ della comm.ne stessa. Es. Min=2; Max=25; Perc=0.00175 (0.175%) 497 Floor variables: Value,DecimalPlaces formula: Div(Value*10^DecimalPlaces;1)/10^Decimal ... author: Will Pittenger Similar to Round, but simply truncates the number at the specified point. 230 fpm variables: dia,rpm formula: Pi*(dia/12)*rpm author: unknown 318 gainN_AV variables: quantita,prezzo1,prezzo2 formula: quantita*(prezzo2-prezzo1)-25,9 author: valter Calcola il guadagno netto di una operazione di Acquisto -> Vendita 481 Ganho variables: venda,compra formula: ((venda/compra)-1)*100 author: Luis Dias Calcula em percentagem a variaçao entre o Valor de compra e o Valor de venda. 143 GPM variables: wholesale,retail formula: ((retail-wholesale)/retail)*100 author: Bob S. Gross Profit Margin calculation 366 GreatDistance variables: latitude1,longitude1,latitude2,longitude2 formula: 6372.795*2*ASin((Sin((latitude2-latitude ... author: rafalroman@gmail.com The shortest distance between any two points on the surface of a sphere measured along a path on the surface of the sphere. 205 Hypotenuse variables: kathete1,kathete2 formula: (kathete1^2+kathete2^2)^0,5 author: selbst Satz des Pythagoras, Bestimmung der Hypotenuse 560 IRE_to_mV variables: IRE formula: (714*IRE)/100 author: daniel 206 Kathete variables: hypotenuse,kathete formula: (hypotenuse^2-kathete^2)^0,5 author: goedde-meesker/an@franzgoed.de Satz des Pythagoras, Bestimmung einer Kathete 344 km2m variables: x formula: x*1000 author: Will Pittenger Converts kilometers to meters 434 KmLiter2MileGallon variables: Km_Liter formula: Km_Liter*0,354 author: Ursus Convert Km/Liter to Mile/Gallon 321 LCUavg variables: T1,Slope,First,Last formula: T1*((Last+0.5)^(Ln(Slope)/Ln(2)+1)-(Firs ... author: Timark Learning curve calculation, unit curve theory, lot average unit result. T1 = first unit value, Slope = learning curve slope as decimal value (eg: use 0.85 for 85% slope), First = first unit in lot, Last = last unit in lot. 322 LCUlot variables: T1,Slope,First,Last formula: T1*((Last+0.5)^(Ln(Slope)/Ln(2)+1)-(Firs ... author: timark Learning curve calculation, unit curve theory, total lot result. T1 = first unit value, Slope = learning curve slope as decimal value (eg: use 0.85 for 85% slope), First = first unit in lot, Last = last unit in lot. 345 m2km variables: x formula: x/1000 author: Will Pittenger Converts meters to kilometers 449 Marge variables: PV,PR formula: (PV-PR)/PV*100 author: Nurun-Hervé Folleau Calcul de la Marge par rapport ŕ un Prix de Vente et un Prix de Revient (ou Prix d’Achat) exemple : Marge(1230;850) = 30,89% 142 Margin variables: cost,sell formula: ((sell-cost)/sell*100) author: Bob S Returns gross profit margin. 99 MarginKr variables: koeb,salg formula: salg-(koeb/1,16*1,25*7,46) author: Kenneth Řstergaard Beregner margin i DKK udfra: Křbspris (koeb) i EUR inkl. tysk moms (16%) Salgspris (salg) i DKK inkl. dansk moms (25%) 100 MarginPct variables: koeb,salg formula: (salg-(koeb/1,16*1,25*7,46))/salg author: Kenneth Řstergaard Beregner margin i procent udfra: Křbspris (koeb) i EUR inkl. tysk moms (16%) Salgspris (salg) i DKK inkl. dansk moms (25%) 286 MbyteToBit variables: bit formula: bit*8192 author: unknown 435 Meters2Yards variables: meters formula: meters/0.9144 author: Will Pittenger Converts meters to yards. 503 mi2yd variables: x formula: x*1760 author: Will Pittenger Converts miles into yards 556 MidPrice variables: QuantI,QuotI,QuantA,QuotA formula: ((QuantI*QuotI)+(QuantA*QuotA))/(QuantI+ ... author: sIMPLYmE4U4Free Calcola Il PrezzoMedio tra due Acquisti Successivi a Quotazioni Differenti. QuantI = Quantitŕ Iniziale (giŕ in possesso o di 1° Acquisto) QuotI = Prezzo Iniziale (prezzo del 1° Acquisto) QuantA = Quantitŕ 2° Acquisto QuotA = Prezzo del 2° Acquisto. 433 MileGallon2KmLiter variables: Mile_Gallon formula: Mile_Gallon/0,354 author: Ursus Convert Mile/Gallon to Km/Liter 346 Miles2Kilometers variables: miles formula: miles*1.609344 author: Will Pittenger Converts statute miles to kilometers. 561 mV_to_IRE variables: mV formula: (100*mV)/714 author: daniel 341 nm_to_eV variables: lambda formula: 1239.84190820754/lambda author: matthew/mat.matthew@wp.pl Returns bandgap in [eV] for wavelength in [nm] 511 P variables: number1,number2 formula: number1!/((number1-number2)!) author: Lonbo/uniking0617@gmail.com P(n,r)=n!/((n-r)!) 163 PDV variables: Iznos formula: Iznos*1,18 author: author unknown Iznos + PDV = Iznos + 18%(Iznos) 196 Phi variables: formula: (1+Root(5))/2 author: unknown Golden ratio 489 PipeSedimentVolume variables: Diameter,Depth,Length formula: ((Diameter/2)^2*ACos(1-2*Depth/Diameter) ... author: Tony Lorton, tlorton@absamail.co.za Calculates the volume of sediment in a drainage pipe given: - Diameter of pipe, in metres, - Depth (average) of sediment, in metres - Length of pipe, in metres. Note: deg/rad/grad must be set to ”rad”. 573 PKrug variables: Precnik_R formula: (((Precnik_R/2)^2)*Pi)/2 author: nebojsa4@gmail.com Povrsina kruga - upisati precnik (R) 315 power variables: v,r0 formula: 10*Log10(v^2/(2*r0)) author: lsh Çóą¦ÂĘ 401 Power variables: Volts,Ohms formula: Volts^2/Ohms author: Sorin Stoenescu Calculate electric power for a given voltage and resistance 402 Power2 variables: Amperes,Ohms formula: Amperes^2*Ohms author: Sorin Stoenescu Calculate electric power for a given ampere and resistance 403 Power3 variables: Volts,Amperes formula: Volts*Amperes author: Sorin Stoenescu Calculate electric power for a given voltage and amperes 310 PPM variables: Reject,Built formula: (Reject/Built)*1000000 author: Jackie Parts per Million PPM(Reject/Built)*1000000 Example: PPM(10;100) = 100,000 539 PrezzoLordoACommMinMaxPerc variables: NumA,PrezzoA,MinA,MaxA,PercA formula: If(NumA*PrezzoA*PercAauthor: sIMPLYmE4U4Free Es.: NumA = Numero di Azioni comprate; PrezzoA = Quotazione; MinA = Minimale Comm. di Acq.; MaxA = Massimale Comm. di Acq.; PercA = % di Comm. di Acq. Es.: 100 az. a 1€; Minimale 2€; Massimale 25€; Tasso Comm.= 0,0017 (0,17%) 540 PrezzoLordoCommA variables: NumA,PrezzoA,CommA formula: (PrezzoA*NumA+CommA)/NumA author: sIMPLYmE4U4Free Calcola il prezzo Lordo di Acquisto di un Bene, noti La Quantitŕ di beni acquistata (NumA) il Prezzo netto (PrezzoA), e il valore economico della Commissione di Acquisto CommA (es.: Quotaz. netta di un’azione + le commissioni ---> Quotaz. Lorda). 541 PrezzoLordoCommV variables: NumV,PrezzoV,CommV formula: (NumV*PrezzoV-CommV)/NumV author: sIMPLYmE4U4Free Calcola il prezzo Lordo di Vendita di un Bene, noti La Quantitŕ di beni venduta (NumV) il Prezzo netto (PrezzoV), e il valore economico della Commissione di Vendita CommV (es.: Quotaz. netta di un’azione - le commissioni ---> Quotaz. Lorda). 542 PrezzoLordoVCommMinMaxPerc variables: NumV,PrezzoV,MinV,MaxV,PercV formula: If(NumV*PrezzoV*PercVauthor: sIMPLYmE4U4Free Calcolo della quotazione effettiva di vendita di un lotto di azioni al netto delle commissioni di Vendita applicate sulla base del Minimale, e/o Massimale e/o Percentuale di commissioni applicate dall’intermediario (Banca o Broker) 257 ProdVec variables: rx,ry,rz,fx,fy,fz formula: Root((ry*fz-fy*rz)^2+(rx*fz-fx*rz)^2+(rx ... author: TOP Industries Vector product F1 x F2 in absolute value 543 ProfitLossAV variables: PrezzoA,PrezzoV formula: ((PrezzoV/PrezzoA)-1)*100 author: sIMPLYmE4U4Free Calcola il Valore percentile di Profitto o di Perdita di una operazione di Acquisto e Vendita di un bene. Inserire nell’ordine i Parametri: PrezzoA (prezzo di Acquisto) e PrezzoV (Prezzo di Vendita) del Bene. Es.: ((110/100)-1)*100 = 10(%) 544 ProfitLossAVTasso variables: PrezzoA,PrezzoV formula: (PrezzoV/PrezzoA)-1 author: sIMPLYmE4U4Free Calcola il Valore del Tasso percentuale di Profitto o di Perdita di una operazione di Acquisto e Vendita di un bene. Inserire nell’ordine i Parametri: PrezzoA (prezzo di Acquisto) e PrezzoV (Prezzo di Vendita) del Bene. Es.: 110/100-1 = 0,1 509 quadratic1 variables: number1,number2,number3 formula: (Root(number2*number2-4*number1*number3) ... author: Lonbo/uniking0617@gmail.com quadratic formula (-b+(b^2-4*a*c)^(1/2))/(2*a) quadratic1(a;b;c) 389 RePercent variables: Size1,Size2 formula: (Size1/Size2)*100 author: Nimto 406 Resistance variables: Volts,Amperes formula: Volts/Amperes author: Sorin Stoenescu Calculate resistance for a given voltage and amperes 407 Resistance2 variables: Volts,Watts formula: Volts^2/Watts author: Sorin Stoenescu Calculate resistance for a given voltage and power (watts) 408 Resistance3 variables: Watts,Amperes formula: Watts/Amperes^2 author: Sorin Stoenescu stoenescusorin@yahoo.com Calculate resistance for a given power (watts) and amperes 432 Round variables: Value,AfterComa formula: If(Value>0;Int(Value*10^AfterComa+0,5)/( ... author: Jerzy Znamirowski Returns the rounded value to the given position after coma. If AfterComa is negative value, returns rounded value to the dozens, hundreds, ect. Examples: Round(1,234;2) = 1,23 Round(-1,235;2) = -1,24 Round(1234;2) = 1200 Round(1254;2) = 1300 283 SANF variables: Age formula: 118,1-(0,57*Age) author: nom Cardiac Seno-atrial node frequency. (beats per minute) Age >= 70. 238 shl variables: Value,Bits formula: Value*(2^Bits) author: Lillyann.Chaplin@yahoo.de Shifts the value ’Bits’ to the left 239 shr variables: Value,Bits formula: Value/(2^Bits) author: Lillyann.Chaplin@yahoo.de Shifts the value ’Bits’ to the right 478 Speed_RPM variables: speed_ms,ratio,diameter_mm formula: (speed_ms/(diameter_mm/2/1000))*ratio*(6 ... author: Nicolas Speed in [PRM] from Speed in [m/seg], Gearbox Ratio, and Wheel diameter [mm]. 201 TVx variables: diagonal_inch formula: 16*2,54*diagonal_inch/Root(16^2+9^2) author: Robert Płoucha Width of a TV screen in 16:9 standard. Result in [cm]. 487 TVy variables: diagonal_inch formula: 9*2,54*diagonal_inch/Root(16^2+9^2) author: Marek F. Height of TV screen 16:9. 387 TwosComp variables: number,bit formula: If(number<2^bit;If(number>2^bit/2-1;-(2^ ... author: Didier Jonkers / didier.jonkers@gmail.com Returns the two’s complement of a binary number stored in a given amount of bits. Example: To find the two’s complement of a 4-bit number with the value 12 i.e. binary (1100): TwoComp(12;4) = -4 OR TwoComp(Bin(1100);4) = -4 Note: Out of range = 0 368 Val_rezolutie variables: maxdim_cm formula: 10000/(maxdim_cm/2.54) author: Adrian Calculul rezolutiei optime pt printare 574 VCevi variables: Precnik_R,Duzina formula: ((((Precnik_R/2)^2)*Pi)/2)*Duzina author: nebojsa4@gmail.com Zapremina valjka - cevi. Upisati precnik (R) kruga/cevi i duzinu. 576 Videoquality variables: Height,Width,Framerate,Bitspersecond formula: Bitspersecond*1000/(Height*Width*Framera ... author: Maple Gives a quality factor based on the height, width, frame rate and bits per second for compressed video. (For H.264/MPEG-4 AVC keep the quality factor above 0.10 for an acceptable result and for regular MPEG-4, like Xvid, keep the factor above 0.15.) 525 Vn variables: di,w,T formula: ((di/1000)^2*Pi/4*w*3600)*273,15/(273,15 ... author: ortner.franz@inode.at Berechnung Nennvolumenstrom in Rohrleitungen 404 Volts variables: Watts,Amperes formula: Watts/Amperes author: Sorin Stoenescu stoenescusorin@yahoo.com Calculate voltage for a given power(watts) and amperes 405 Volts2 variables: Amperes,Ohms formula: Amperes*Ohms author: Sorin Stoenescu stoenescusorin@yahoo.com Calculate voltage for a given amperes and resistance 324 VolumeEmLitros variables: comprimento,altura,largura formula: (comprimento*altura*largura)*1000 author: Silvio Ricardo (ricardokurt@hotmail.com) Calcula o volume de um recipiente em litros (medidas recebidas em metros). 282 VolumeOfRectangularTankInImpGall variables: length,width,height,heightloss formula: (length*width*(height-heightloss)*6.232) author: Anthony Albert To calculate Effective capacity of a tank Dimensions in feet Result in Imperial Gallons 482 WaveEMC variables: x formula: 299792458/x author: Marek.F Calculates the length of electromagnetic wave in the air. 486 WaveEMC variables: Frequency_Hz formula: 299792458/(Frequency_Hz*1,0003) author: Marek F. EM wave lenght [meters] in air. 347 Yards2Meters variables: x formula: x*0.9144 author: Will Pittenger Converts yards to meters. 1009 © Jerzy Znamirowski