() Whether you are developing plans for an existing installation or a new facility you will need to understand the compressed air requirement when installing pneumatic scissor lift tables. Many of the Herkules customers complete a comprehensive review of compressed air needs at peak time and off peak times. This information provides the industrial engineers with the knowledge to source the correct size air compressors for the job.
Read more
Below are the details of how Herkules Equipment Corporation calculates cubic feet per minute (CFM) and standard cubic feet per minute (SCFM) for our pneumatic scissor lift tables. CFM and SCFM can be calculated based on a variety of standards. We believe the below calculations work best in most cases.
Given:
Volume: 4.7 ft3 Lift table is full up
Pressure: 50 psi Lift table is full up and maximum load
Atmospheric pressure (ATM): 14.7 Constant
Cycles / minute: 0. Calculated below
Terms:
ATM: Atmospheric pressure:
CFM: Cubic Feet per Minute
SCFM: Standard Cubic Feet per Minute
Formulas:
1 TRUE pressure (psia) = Pressure + ATM
2 Actual Pressure (ft3 TRUE) = (Volume * True psi) / ATM
3 CFM max. = (ft3 TRUE) / minutes
4 SCFM = (Pressure * Volume * cycles/minute) / Raise time
Calculations:
Cycle Sequence
Goto Wonder Machinery to know more.
Air consumption units are per minute: Inputs
a. Speed for full raised: 20 Seconds = 0. Minutes
b. Lift sets ideal at full raised for: Seconds = 60.000 Minutes
c. Number of cycles per minute: 1 Cycles per hour/60 minutes = 0. cycles / minute
TRUE pressure:
TRUE pressure = 50 psi + 14.7 psi
= 64.7 psia
Actual pressure:
Actual Pressure = (4.7 ft3 X 64.7 psia) / 14.7 psi
= 20.69 ft3 TRUE
Cubic Feet Per Minute Maximum:
CFM max. = (20.69 ft3 TRUE) / .333 minutes
= 62.06
Standard Cubic Feet Per Minute:
SCFM = (20.69 ft3 TRUE X 0. cycles / minute) / 0.33 minutes
= 1.04
I want to calculate the lift in the sales numbers if the outside temperature increases. For example if it is 30°C outside you would sell more icecream than when it is 10°C outside. I want to do this by first creating the average of base sales under 20°C and then divide the average sales that occure on days above 20°C with this base. This gives me a lift factor (ex. 1.3 when it is 25°C meaning i would sell 30% more than compared with my base).
I have my sales and temperature data in 1 table (see pbi file below). I now have created 2 extra tables in Power Query, one containing sales data on days below 20°C and one containing sales data on days equal and above 20°C. In DAX in calculate the sales average of both tables and divide them by eachother. I put the data in a matrix and add the temperature (bins) to the columns. I want to see the uplift per weekday so i also added the weekdays in the rows. This gives me the matrix below:
But when adding more and more data my Power BI file gets bigger and slower and the two extra tables i created are not helping. I want to calculate the matrix shown above with only using 1 total sales table and DAX measures. But when i try this and add the data to a matrix i only get the total uplift, not per °C bin because it's shows 'infinity'.
Can you please help me to created the above matrix by only using DAX and the 'Sales_Total' table (and not the two extra tables i created) in the attached PBI file below?
Power BI file (onedrive link): Power BI Example.pbix
Comments
All Comments (0)