wsnyder_pwmd

Need Help formatting this formula

Discussion created by wsnyder_pwmd on May 26, 2012
Latest reply on Jun 4, 2012 by jgcobb
Any help with this would be apprectiated


I need to calculate this excel formula using field calculator grabbing the roughness from one field its a 'double' type, grabbing the Nominal Diameter from another field its a 'long type' and has a specific domain 'ssdomainmaindistributiondiameter'
and the slope which is in another field and is a 'Double type'


Roughess = [Roughness]
Nominaldiameter = [NominalDiameter]
Slope = [Slope]

numeric_fields = ["Double", "Long", "Number"]

=1.486/Roughness*((IF(Nominaldiameter*0.75>(Nominaldiameter/2),((Nominaldiameter^2)/8)*((PI()*2-(PI()*IF(Nominaldiameter*0.75>(Nominaldiameter/2),4*(ACOS((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()),4*(ASIN((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()))/180)+(SIN(IF(Nominaldiameter*0.75>(Nominaldiameter/2),4*(ACOS((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()),4*(ASIN((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()))*2*PI()/360))))/144,((Nominaldiameter)^2)/8*((PI()*IF(Nominaldiameter*0.75>(Nominaldiameter/2),4*(ACOS((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()),4*(ASIN((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()))/180-SIN(IF(Nominaldiameter*0.75>(Nominaldiameter/2),4*(ACOS((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()),4*(ASIN((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()))*2*PI()/360)))/144)/IF(Nominaldiameter*0.75>(Nominaldiameter/2),(PI()*Nominaldiameter*(360-IF(Nominaldiameter*0.75>(Nominaldiameter/2),4*(ACOS((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()),4*(ASIN((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI())))/360)/12,(PI()*Nominaldiameter*IF(Nominaldiameter*0.75>(Nominaldiameter/2),4*(ACOS((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()),4*(ASIN((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI())))/360/12))^0.6667*Slope^0.5)*IF(Nominaldiameter*0.75>(Nominaldiameter/2),((Nominaldiameter^2)/8)*((PI()*2-(PI()*IF(Nominaldiameter*0.75>(Nominaldiameter/2),4*(ACOS((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()),4*(ASIN((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()))/180)+(SIN(IF(Nominaldiameter*0.75>(Nominaldiameter/2),4*(ACOS((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()),4*(ASIN((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()))*2*PI()/360))))/144,((Nominaldiameter)^2)/8*((PI()*IF(Nominaldiameter*0.75>(Nominaldiameter/2),4*(ACOS((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()),4*(ASIN((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()))/180-SIN(IF(Nominaldiameter*0.75>(Nominaldiameter/2),4*(ACOS((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()),4*(ASIN((Nominaldiameter*0.75/Nominaldiameter)^0.5))*360/(2*PI()))*2*PI()/360)))/144)*448.8

Outcomes