OK, here it goes. I'm a helicopter pilot and in the operator's manual of the aircraft is a performance section. What I'm trying to do is take the performance charts and convert them to excel. basically its a scatter chart with different variables. In short you take the temperature match it up to...
I have a column on sheet 1 with different numbers in it (150, 300, 600, 900, 1500, 2500) ad would like to filter it based on the number given on sheet 2, cell B5 (I have the criteria listed on sheet 2 as well). I've tried manually writing the advanced filter macro, and when that...
I've got a question on sheet 2 asking for a pressure, and a column on sheet 1 with multiple flange ratings. What I'd like the script to do is filter the flange ratings based on the pressure entered.
For example, if the user entered 350 psi it would filter out everything below...
How can calculate the Humidity with Enthalpy, Temperature, and pressure given
Enthalpy= 71.4, Temperature= 32, Pressure= 1013.25
I need an equation to calculate the humidity using Enthalpy, Temperature, and pressure
thanks in advance!
Hi I have a machine log of 10000 events. I previously got help on this forum to count the events, see below (apologies about dots working on mobile) :
Event . . . . Count
start . . . . . . . 0
Over pressure 1
over pressure 2
start . . . . . . . . 0
over pressure 1
start . . . . . . . . 0...
I am trying to count how many times an event (over pressure) occurs between a recurring event (start), I have >10000 entries. My column looks like,
In some instances...
A skills assessment questionnaire has been sent to staff and I now need to collate the information for each different site. I am a bit unsure the best way to set up the spreadsheet and then how to combine the information for all sites
Job Title & Team