matthewoaks
New Member
- Joined
- Jan 31, 2014
- Messages
- 30
Hi,
I am brand new to the forum so please bear with me if I'm a little long winded
I have been looking around on the internet and Youtube to try and figure the best approach I should take for extracting and displaying data. The list is based on observations that come in from auditors and these are recorded to identify trends and repeated observations to try and avoid them in the future.
I'm not sure if this is the best method but I have put the list in a table so that it can be filtered but don't know how to go about summarising the data in either graphical form or a smaller table alongside.
In the table there are 5 main columns; Vessel Name Date of Inspection SIRE VIQ Chapter Question Ref Inspectors Comments
Now each vessel has two inspections per year (6 vessels).
For each inspection a vessel might pick up a number of observations. These obs are split into chapters for the relevant part of the ship ie. 1.General Info, 2.Certification, 3.Crew Management, 4.Navigation and so on (there are 13 chapters in total).
In each chapter there are a number of questions that the auditor surveys the vessel against i.e Chapter 1, Q1.1, 1.2, 1.3, 1.4 and so on for each chapter.
I have been asked to try and display the data so that we can easily spot which vessels are getting repeated observations for a particular chapter and more importantly for a particular question.
If you need me to attach the Excel Workbook then it isn't a problem but I need help on how to do this
Look forward to hearing your suggestions
BRgds
Matt
I am brand new to the forum so please bear with me if I'm a little long winded
I have been looking around on the internet and Youtube to try and figure the best approach I should take for extracting and displaying data. The list is based on observations that come in from auditors and these are recorded to identify trends and repeated observations to try and avoid them in the future.
I'm not sure if this is the best method but I have put the list in a table so that it can be filtered but don't know how to go about summarising the data in either graphical form or a smaller table alongside.
In the table there are 5 main columns; Vessel Name Date of Inspection SIRE VIQ Chapter Question Ref Inspectors Comments
Now each vessel has two inspections per year (6 vessels).
For each inspection a vessel might pick up a number of observations. These obs are split into chapters for the relevant part of the ship ie. 1.General Info, 2.Certification, 3.Crew Management, 4.Navigation and so on (there are 13 chapters in total).
In each chapter there are a number of questions that the auditor surveys the vessel against i.e Chapter 1, Q1.1, 1.2, 1.3, 1.4 and so on for each chapter.
I have been asked to try and display the data so that we can easily spot which vessels are getting repeated observations for a particular chapter and more importantly for a particular question.
If you need me to attach the Excel Workbook then it isn't a problem but I need help on how to do this
Look forward to hearing your suggestions
BRgds
Matt