C# Online Compiler | .NET Fiddle

<no name> by Anonymous

using System;
					
public class Program
{
	
	const double PI = 3.14159265358979;
    const double MEANTEMP = 59.0; //Farenheit
	const double PSIA = 14.7;
	const double DENSITYDRYAIR = 0.077; //Density of Dry Air (lb/ft^3)
	const double KINEMATICVISCOSITY1 = 1.565; //Kinematic Viscosity (ft^2/s*10^-4)
	const double KINEMATICVISCOSITY2 = 1.573; //Kinematic Viscosity (ft^2/s*10^-4)
	String ductPath;
	String identifier;
	String ductElement;
	String description;
	double cfm;
	double weight;
	double height;
	double ductLength;
	double roughness;
	double ashraeFittingNumber;
	double fittingCoefficient;
	double componentPressureDrop;
	
	/* 
	* ----------------------------------
	* TO DO:
	* Error control
	* Import PI value
	* Kinematic Viscosity 1 =(1.2775+0.004542*$J$3+0.0000057007*$J$3^2-0.0000000035*$J$3^3) ------not a constant
	* Kinematic Viscosity 2 =(1.2775+0.004542*$J$3+0.0000057007*$J$3^2-0.0000000035*$J$3^3) ------not a constant
	* Setter methods
	* ----------------------------------
	*/
	
	public static void Main()
	{
		double cfm; //F column
		//Duct Dimensions
		double width, height; //G and H columns
		double ductLength;
		//Materials
		double materialRoughness;
		//Pressure Loss Data
		double ashraeFittingNo, fittingCoefficient, componentPressureDrop;
		
		Console.WriteLine("Hello World");
	}
	
	
	/* 
	* ----------------------------------
	* SETTER METHODS
	* ----------------------------------
	*/
	public static void setDuctPath()
	{
		//='Master- b'!A2
	}
	
	public static void setIdentifier()
	{
		//=IFERROR('Master- b'!B2*1,0)
	}
	
	public static void setDuctElement() {
		//get duct element from the raw input
		//=IF(OR(E8="Air Terminal Device (FPU/ACB)",E8="Fire/Smoke Damper", E8="Louver", E8="Air Terminal Device (VAV)", E8="Air Terminal (Lab) Valve", E8="Air Terminal (Lab) Valve- LP", E8="Reheat Coil Hydronic (2 Row)", E8="Reheat Coil (Electric)", E8="Sound Attenuator", E8="Humidifier", E8="Airflow Station", E8="Manual Volume Damper", E8="Automatic Control Damper", E8="Fire Damper", E8="Smoke Damper", E8="UVGI Lamps", E8="Flex Duct (5 ft.)", E8="Flex Elbow", E8="Flex Connector", E8="Wire-Mesh Screen", E8="Diffuser/ Grille"),"Component",'Master- b'!C2)
	}
	
	public static void setDescription()
	{
		//=IFERROR(IF(AND(D8="Duct",G8=0),"Round Duct",IF(AND(D8="Duct",G8>1),"Rectangular Duct",IF(D8="Component","-",IF(D8="Fitting",INDEX('Fitting Name'!$B$218:
	}
	
	public static void setCFM()
	{
		//=IF(D8="Duct",INDEX('Pressure Calc- Ducts'!$F$7:$F$314,MATCH(C8,'Pressure Calc- Ducts'!$C$7:$C$314,0)),IF(D8="Fitting",INDEX('Pressure Calc- Fittings'!$F$7:$F$314,MATCH(C8,'Pressure Calc- Fittings'!$C$7:$C$314,0)),))
	}
		
	public static void setWidth()
	{
		//
	}
			
	public static void setHeight()
	{
		//
	}
	
	public static void setDuctLength()
	{
		//
	}
	
	public static void setRoughness()
	{
		//=INDEX('Common Tables'!$C$3:$C$16,MATCH(J8,'Common Tables'!$B$3:$B$16,0))
	}
	
	public static void setAshraeFittingNumber()
	{
		//=IF(D8="Duct",INDEX('Pressure Calc- Ducts'!$L$7:$L$314,MATCH(C8,'Pressure Calc- Ducts'!$C$7:$C$314,0)),IF(D8="Fitting",INDEX('Pressure Calc- Fittings'!$L$7:$L$314,
	}
	
	public static void setFittingCoefficient()
	{
		//=IF(D8="Duct",INDEX('Pressure Calc- Ducts'!$M$7:$M$314,MATCH(C8,'Pressure Calc- Ducts'!$C$7:$C$314,0)),IF(D8="Fitting",INDEX('Pressure Calc- Fittings'!$M$7:$M$314,MATCH(C8,'Pressure Calc- Fittings'!$C$7:$C$314,0)),))
	}
	
	public static void setComponentPressureDrop()
	{
		//=IFERROR(IF(D8="Component",INDEX('Common Tables'!$I$4:$I$24,MATCH(E8,'Common Tables'!$H$4:$H$24,0)),),"")
	}
	
	
	/* 
	* ----------------------------------
	* CALCULATE METHODS
	* ----------------------------------
	*/
	
	public static double calculateDiameter(double width, double height)
	{
		double diameter;
		if(width>0){
			diameter = (double) 4*width*height/(2*(width+height));
			//=IF(G8>0,4*G8*H8/((G8+H8)*2),H8)
		} else {
			diameter = height;
		}
		return diameter;
	}
	
	public static double calculateVelocity(double cfm, double width, double height)
	{
		double velocity;
		if(width>0){
			velocity = (double) cfm/(width*height/144);
			//=IFERROR(IF(G8>0,F8/(G8*H8/144), F8/(PI()*(H8/12)^2/4)),0)
		} else {
			velocity = (double) cfm/(PI*Math.Pow(height/12, 2)/4);
		}
		return velocity;
	}
	
	//input: calculateVelocity result
	public static double calculateVelocityPressure(double velocity)
	{
		double velPressure = DENSITYDRYAIR*Math.Pow((velocity/1097), 2);
		//=$L$3*(P8/1097)^2
		
		return velPressure;
	}
	
	/* ----------------------------------
	* FLUID PROPERTIES
	* RN inputs are results of functions: calculateDiameter, calculateVelocity
	* FlowType inputs: RN
	* ----------------------------------
	*/
	public static double calculateReynoldsNumber(double diameter, double velocity)
	{
		double rn = diameter*velocity/(KINEMATICVISCOSITY2*72*0.001);
		//=O8*P8/($N$3*72*0.001)
		
		return rn;
	}
	
	public static String calculateFlowType(double reynoldsNumber)
	{
		String flowType;
		if(reynoldsNumber<2300) {
			flowType = "Laminar";
			//=IF(R8<2300,"Laminar",IF(AND(R8>=2300,R8<=4000),"Transient","Turbulent"))
		} else if(reynoldsNumber>=2300 && reynoldsNumber<4000) {
			flowType = "Transient";
		} else {
			flowType = "Turbulent";
		}
		
		return flowType;
	}
	
	public static double calculateFrictionFactorTurbulent(double reynoldsNumber)
	{
		//=IFERROR(IF(ISNUMBER(T8), (-0.5/LOG10(12*K8/(3.7*O8)+2.51/(R8*T8^0.5)))^2, 1),"")
		
		return 0;
	}
	
	public static double calculateFrictionFactorLaminar(double reynoldsNumber)
	{
		//=IFERROR(IF(ISNUMBER(T8), (-0.5/LOG10(12*K8/(3.7*O8)+2.51/(R8*T8^0.5)))^2, 1),"")
		
		return 0;
	}
	
	public static double calculateFrictionFactor(double reynoldsNumber)
	{
		//=IFERROR(64/R8,"")
		
		return 0;
	}
	
	public static double calculatePressureLoss(double reynoldsNumber)
	{
		//=IF(D8="FITTING", "-", IF(D8="COMPONENT", "-", 12*V8*100*$L$3*(P8/1097)^2/O8))
		
		return 0;
	}
	
	public static double calculateTotalPressureLoss(double ductElement, double compPressureDrop, )
	{
		//=IFERROR(IF($D8="FITTING", $M8*$Q8*$I8, IF($D8="COMPONENT", $N8*$I8, IF($D8="FLEX DUCT", I8/100*W8*(1+58*(1-0.85)*2.7813^(-0.125*O8)),I8*W8/100))),)
		
		return 0;
	}
	
}

 
using System;
                    
public class Program
{
    
    const double PI = 3.14159265358979;
    const double MEANTEMP = 59.0; //Farenheit
    const double PSIA = 14.7;
    const double DENSITYDRYAIR = 0.077; //Density of Dry Air (lb/ft^3)
    const double KINEMATICVISCOSITY1 = 1.565; //Kinematic Viscosity (ft^2/s*10^-4)
    const double KINEMATICVISCOSITY2 = 1.573; //Kinematic Viscosity (ft^2/s*10^-4)
    String ductPath;
    String identifier;
    String ductElement;
    String description;
    double cfm;
    double weight;
    double height;
    double ductLength;
    double roughness;
    double ashraeFittingNumber;
    double fittingCoefficient;
    double componentPressureDrop;
    
    /* 
    * ----------------------------------
    * TO DO:
    * Error control
    * Import PI value
    * Kinematic Viscosity 1 =(1.2775+0.004542*$J$3+0.0000057007*$J$3^2-0.0000000035*$J$3^3) ------not a constant
    * Kinematic Viscosity 2 =(1.2775+0.004542*$J$3+0.0000057007*$J$3^2-0.0000000035*$J$3^3) ------not a constant
    * Setter methods
    * ----------------------------------
    */
    
    public static void Main()
    {
        double cfm; //F column
        //Duct Dimensions
        double width, height; //G and H columns
        double ductLength;
        //Materials
        double materialRoughness;
        //Pressure Loss Data
        double ashraeFittingNo, fittingCoefficient, componentPressureDrop;
        
        Console.WriteLine("Hello World");
    }
    
    
    /* 
    * ----------------------------------
    * SETTER METHODS
    * ----------------------------------
    */
    public static void setDuctPath()
    {
        //='Master- b'!A2
    }
    
    public static void setIdentifier()
    {
        //=IFERROR('Master- b'!B2*1,0)
    }
    
    public static void setDuctElement() {
        //get duct element from the raw input
        //=IF(OR(E8="Air Terminal Device (FPU/ACB)",E8="Fire/Smoke Damper", E8="Louver", E8="Air Terminal Device (VAV)", E8="Air Terminal (Lab) Valve", E8="Air Terminal (Lab) Valve- LP", E8="Reheat Coil Hydronic (2 Row)", E8="Reheat Coil (Electric)", E8="Sound Attenuator", E8="Humidifier", E8="Airflow Station", E8="Manual Volume Damper", E8="Automatic Control Damper", E8="Fire Damper", E8="Smoke Damper", E8="UVGI Lamps", E8="Flex Duct (5 ft.)", E8="Flex Elbow", E8="Flex Connector", E8="Wire-Mesh Screen", E8="Diffuser/ Grille"),"Component",'Master- b'!C2)
    }
    
    public static void setDescription()
    {
        //=IFERROR(IF(AND(D8="Duct",G8=0),"Round Duct",IF(AND(D8="Duct",G8>1),"Rectangular Duct",IF(D8="Component","-",IF(D8="Fitting",INDEX('Fitting Name'!$B$218:
    }
    
    public static void setCFM()
    {
        //=IF(D8="Duct",INDEX('Pressure Calc- Ducts'!$F$7:$F$314,MATCH(C8,'Pressure Calc- Ducts'!$C$7:$C$314,0)),IF(D8="Fitting",INDEX('Pressure Calc- Fittings'!$F$7:$F$314,MATCH(C8,'Pressure Calc- Fittings'!$C$7:$C$314,0)),))
    }
        
    public static void setWidth()
    {
        //
    }
            
    public static void setHeight()
    {
        //
    }
    
    public static void setDuctLength()
    {
        //
    }
    
    public static void setRoughness()
    {
        //=INDEX('Common Tables'!$C$3:$C$16,MATCH(J8,'Common Tables'!$B$3:$B$16,0))
    }
    
    public static void setAshraeFittingNumber()
    {
        //=IF(D8="Duct",INDEX('Pressure Calc- Ducts'!$L$7:$L$314,MATCH(C8,'Pressure Calc- Ducts'!$C$7:$C$314,0)),IF(D8="Fitting",INDEX('Pressure Calc- Fittings'!$L$7:$L$314,
    }
    
    public static void setFittingCoefficient()
    {
        //=IF(D8="Duct",INDEX('Pressure Calc- Ducts'!$M$7:$M$314,MATCH(C8,'Pressure Calc- Ducts'!$C$7:$C$314,0)),IF(D8="Fitting",INDEX('Pressure Calc- Fittings'!$M$7:$M$314,MATCH(C8,'Pressure Calc- Fittings'!$C$7:$C$314,0)),))
    }
    
    public static void setComponentPressureDrop()
    {
        //=IFERROR(IF(D8="Component",INDEX('Common Tables'!$I$4:$I$24,MATCH(E8,'Common Tables'!$H$4:$H$24,0)),),"")
    }
    
    
    /* 
    * ----------------------------------
    * CALCULATE METHODS
    * ----------------------------------
    */
    
    public static double calculateDiameter(double width, double height)
    {
        double diameter;
        if(width>0){
            diameter = (double) 4*width*height/(2*(width+height));
            //=IF(G8>0,4*G8*H8/((G8+H8)*2),H8)
        } else {
            diameter = height;
        }
        return diameter;
    }
    
    public static double calculateVelocity(double cfm, double width, double height)
    {
        double velocity;
        if(width>0){
            velocity = (double) cfm/(width*height/144);
            //=IFERROR(IF(G8>0,F8/(G8*H8/144), F8/(PI()*(H8/12)^2/4)),0)
        } else {
            velocity = (double) cfm/(PI*Math.Pow(height/12, 2)/4);
        }
        return velocity;
    }
    
    //input: calculateVelocity result
    public static double calculateVelocityPressure(double velocity)
    {
        double velPressure = DENSITYDRYAIR*Math.Pow((velocity/1097), 2);
        //=$L$3*(P8/1097)^2
        
        return velPressure;
    }
    
    /* ----------------------------------
    * FLUID PROPERTIES
    * RN inputs are results of functions: calculateDiameter, calculateVelocity
    * FlowType inputs: RN
    * ----------------------------------
    */
    public static double calculateReynoldsNumber(double diameter, double velocity)
    {
        double rn = diameter*velocity/(KINEMATICVISCOSITY2*72*0.001);
        //=O8*P8/($N$3*72*0.001)
        
        return rn;
    }
    
    public static String calculateFlowType(double reynoldsNumber)
    {
        String flowType;
        if(reynoldsNumber<2300) {
            flowType = "Laminar";
            //=IF(R8<2300,"Laminar",IF(AND(R8>=2300,R8<=4000),"Transient","Turbulent"))
        } else if(reynoldsNumber>=2300 && reynoldsNumber<4000) {
            flowType = "Transient";
        } else {
            flowType = "Turbulent";
        }
        
        return flowType;
    }
    
    public static double calculateFrictionFactorTurbulent(double reynoldsNumber)
    {
        //=IFERROR(IF(ISNUMBER(T8), (-0.5/LOG10(12*K8/(3.7*O8)+2.51/(R8*T8^0.5)))^2, 1),"")
        
        return 0;
    }
    
    public static double calculateFrictionFactorLaminar(double reynoldsNumber)
    {
        //=IFERROR(IF(ISNUMBER(T8), (-0.5/LOG10(12*K8/(3.7*O8)+2.51/(R8*T8^0.5)))^2, 1),"")
        
        return 0;
    }
    
    public static double calculateFrictionFactor(double reynoldsNumber)
    {
        //=IFERROR(64/R8,"")
        
        return 0;
    }
    
    public static double calculatePressureLoss(double reynoldsNumber)
    {
        //=IF(D8="FITTING", "-", IF(D8="COMPONENT", "-", 12*V8*100*$L$3*(P8/1097)^2/O8))
        
        return 0;
    }
    
    public static double calculateTotalPressureLoss(double ductElement, double compPressureDrop, )
    {
        //=IFERROR(IF($D8="FITTING", $M8*$Q8*$I8, IF($D8="COMPONENT", $N8*$I8, IF($D8="FLEX DUCT", I8/100*W8*(1+58*(1-0.85)*2.7813^(-0.125*O8)),I8*W8/100))),)
        
        return 0;
    }
    
}

View IL Code