Extracting specific numerical values from a table of data.

I'm pretty new to Excel so any help would be appreciated.

The Picture below is part of a duty chart for a railway crane. Basically it provides the maximum safe working loads that a specific crane can lift at a specific radius, height and sector within a 360 radius. For example if I needed the crane to lift a pallet of materials from ground level to a raised platform 4m away. I would simply look at the Height values between 0 - 4 under the 4m radius column to see if the machine/crane could indeed lift the pallet of materials safely.
Duty Chart.PNG

Basically there are many tables like this one. There's a table of values for every 15 degree increment. Making 24 tables in total.

As I work in the railway industry all of the machines I work with are fitted to work on railway track, which means there are another 24 tables depending different variables such as the cant of the track, or on the machines specific configuration. Basically I have hundreds of these data tables in PDF form which can make finding values within a specific range pretty tedious and time consuming.

So in an effort to streamline things I was hoping to put all these data tables into Excel. My only problem being I don't know how to set it all up so I can easily find data within a specific range. Does anyone have any idea on how I could do this?

Thankyou for your reply. Sadly the PDFs are simply scans of the paper copies that accompanied the Road Rail Vehicle when it was built. I will have to work on inputting all the tables into to Excel which may take a while since I'll have to do it when I'm not as busy.

I'll be inputting everything the old fashion way.
The below picture is my first attempt at inputting the tables into excel. Like I said I'm quite new to excel so I'm still figuring out the best way to attack it.
First draft.PNG

Basically I'm looking to do something similar for each radius.

Say I wanted to find the lowest values within a certain range. How do I set up excel to quickly tell me the lowest value?

For example, regarding the picture above, I wanted to find the lowest value in the height range 0 to 4 for each row of degrees. Is there a way for excel to quickly tell me this?

Test.xlsx

I've attached the sample table I'm experimenting with. Turns out most people in my office don't know how to work excel, so we are all a little lost.

Thanks guys. You legends.

I appreciate the input from everyone.

However In an effort to improve the layout could anyone show me how I would do the same thing as before but with the data tables on a different tab and including another variable.

Basically when creating a lift plan for the machine, I will decide the radius, then decide the height range. I would then consult each table for the different 15 degree increments picking the lowest value within the range. So if anyone could show me how to do it for the 0 degree table I will be able to replicate it for the others (hopefully). Again any pointers and help will be greatly appreciated.

My data input will be on the first sheet and the Output will be on the second sheet. I've set it up like this so if anyone else wishes to use it there's less risk of them accidently changing a value from the table.

Testv2.xlsx

So Ideally I would want to input the Radius, The Height range (start and finish). Then in the yellow highlighted box under "Min value from table", I would like for Excel to find the minimum value in the inputted radius column from the 0 degrees table, located on the other sheet.

I will then replicate that method for every other table. I hope I'm making sense. Testv3.xlsx

Could anyone point me to a tutorial on how I could complete something like this?

Capture 1.PNG
Basically on page 2 I would input the values into the Yellow highlighted boxes

Capture 2.PNG
On Page 1 I will type out every Data table for each 15 degree increment from 0 to 345, in the format of the picture above. When I insert the data into Page 2 I would like excel to go to page one and get me the lowest value within the range of the data I inputted on page 2. So for example, I have put 4m as the radius and a height range of 0 to 4m.

In the picture above I have highlighted, in yellow, the values within this range. I'm looking for excel to find the lowest value and then put it into the table on page 2 under the "Min Value from table" column. As you can see from the first picture, the expected result for 0 degrees is 7.7 based on the variables in the yellow highlighted boxes.


Testv4.xlsx

I've put the raw data on a different sheet so when people come to use this at work there's less of a chance they will accidently edit any of the tables.

Don't think my last post made it through.

My line manager has got me bogged down working on other things at the moment. So I will upload a new copy before the weekend.

Regarding the layout I was simply copying it from the Original PDF, so forgive me for making it a pain in the *** to work with.

Is the layout in the picture below any better?
Layout.PNG

Originally Posted by XOR LX

Much better, though better still if you don't repeat the Radius headers and fill the Degrees down so that they apply to each row within that set.

Regards

Thanks for your advice and I'll get right on sorting it as soon as I can.

So it took a while but I finally sorted the layout on sheet 1..... I hope.



Testv5.xlsx

Works a treat. Thanks for all your help.