I work in manufacturing and we create parts. Every time we make a part we have to check hardness of a set number of parts (depending on how many total we make). I want to make a table that capture the part number, the manufacture data, and then all the hardness we got for that date. How do I make a table to account for this variable number of hardness data points?
Can I store an array of data for each cell in a column (e.g. Column 4 - Hardness)?
Hi,
To facilitate subsequent analysis keep your data is a normalised flat table with columns for
Date
PartNumber
Manufacture Data
Hardness Value
it will mean that you have a row for every observation of a part number and hardness value.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
So just 1 massively large table with all the data for all parts and dates combined?Originally Posted by Richard Buttrey
Indeed.
You'll have stuff entered in somewhat more cells than if you only had one row for a date/partnumber combination and used successive columns to record different hardness measures for the date/partno combo, but subsequent analysis and summarisation will be extremely simple, plus you'll be able to use a pivot table which will mean you'll be able to analyse your data in ways you've not yet thought of.
The way I often do this sort of stuff is have a dedicated row in which I enter the 4 values, and then click a button to kick off a macro that copies that new data to the table. It avoids having to scroll up & down to enter stuff. And if your part numbers and hardness values are somewhat standard and can be held as values in two other tables you could have drop downs in the input cells so that you can simply pick the values from the drop down and save time typing.
Last edited by Richard Buttrey; 01-14-2015 at 12:07 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks