First, I apologize. I am new here and haven't properly introduced myself, nor have I spent a great amount of time searching for the answers to the questions for which I am about to ask, however a can give a quick answer to both.
I work aboard a deep sea offshore driling rig. I am here now. Our internet is extremely slow and even then its is only available to myself briefly throughout the course of a day.
I have a table of values which corresponds strappings (measurements by measuring tape) to volume and weight measurements. My department is asked to provide conversions for these strappings regularly. Because we all failed math and ended up out here on a drilling rig in the middle of the ocean, no two of us can regularly provide consistent conversions, which results in very aggravated supervisors.
What I would like to do is provide a very simple calculator which would only require two inputs (strappings in inches and product) and spit out the interpolated results for each of other columns. Additionally for cement, I would like a column which converts the metric tonnage column into sacks of cement. In this case we generally use the following calculation: {resultant tons x 2204.6 (metric ton to lbs)}/94lbs (pounds in a sack of cement = sacks.
Ideally, so as not cause unnecessary confusion for my marginally slow collegues and myself, I would either hide the table completely or place it on a separate worksheet. Only the calculator would be visible. I am willing to do all the leg work on this I just need to be pointed in the right direction. Again, I apologize if this has been covered earlier. I am not a complete forum newbie and I know that there is a lot of spite for those that do not know how or are not willing to use the search function. I hope you can find it in your spreadsheet hearts to just this once, give me bit of a pass, I am already getting looks for how long I've been on the internet.
Thanks,
RigMaster
Bulk Barite Cement & Gel Conversion Table 16 december 2016.xlsx
Bookmarks