So I have a table, it looks kinda like this:
I have considered a problem I may have in the future. Serial numbers that are sent to the awaiting parts status will eventually be brought back into the system and tracked for a second repair cycle. The point of this spreadsheet is to track my awaiting install units and their misdiagnoses status.
I understand that my key for this table will need to be composite, It would include serial number, the assigned technician, and finally something else. One thing to understand is taht a unit may be prequoted and put back into the repair cycle on the same day, so date is not a valid option for a third part of the composite key.
What I want to do is keep track of unit cycles, when I scan in serial numbers, i'd like it to check for duplicates, and if so, increment the cycle, starting at one, and onwards, for how many times the unit went to and from a hold status.
What are some options I have for doing this? Which paths should I research in order to accomplish my goal?
Code:
[TABLE="width: 1089"]
<tbody>[TR]
[TD]Serial Number[/TD]
[TD]Tote[/TD]
[TD]Date Assigned[/TD]
[TD]Assigned To[/TD]
[TD]Disposition[/TD]
[TD]Last Modified[/TD]
[TD]Actual Age[/TD]
[TD]Misdiagnosed[/TD]
[TD]Problem[/TD]
[/TR]
[TR]
[TD]CND8451VPS[/TD]
[TD]T33999[/TD]
[TD="align: right"]9/10/2014[/TD]
[TD]Parent[/TD]
[TD]OOW Approved[/TD]
[TD]Parent[/TD]
[TD="align: right"]23[/TD]
[TD]N[/TD]
[TD]Wrong Part[/TD]
[/TR]
[TR]
[TD]6CZ325B3HJ[/TD]
[TD]T48188[/TD]
[TD="align: right"]9/18/2014[/TD]
[TD]TITO[/TD]
[TD]Pre-Quoting[/TD]
[TD]TITO[/TD]
[TD="align: right"]23[/TD]
[TD]N[/TD]
[TD]Wrong Part[/TD]
[/TR]
[TR]
[TD]4E164097P[/TD]
[TD]T34964[/TD]
[TD="align: right"]9/10/2014[/TD]
[TD]Chris W[/TD]
[TD]Awaiting instal[/TD]
[TD]Chris W[/TD]
[TD="align: right"]21[/TD]
[TD]N[/TD]
[TD]DOA Part[/TD]
[/TR]
[TR]
[TD]CNU02639VQ[/TD]
[TD]T37959[/TD]
[TD="align: right"]9/15/2014[/TD]
[TD]Parent[/TD]
[TD]Unit Repairing[/TD]
[TD]Bowlin[/TD]
[TD="align: right"]20[/TD]
[TD]Y[/TD]
[TD]Triage[/TD]
[/TR]
[TR]
[TD]NXY3NAA003342228E43400[/TD]
[TD]T61882[/TD]
[TD="align: right"]9/10/2014[/TD]
[TD]Booth[/TD]
[TD]Awaiting instal[/TD]
[TD]Parent[/TD]
[TD="align: right"]17[/TD]
[TD]Y[/TD]
[TD]Root Cause[/TD]
[/TR]
[TR]
[TD]NXRN5AA00322705C623400[/TD]
[TD]T90975[/TD]
[TD="align: right"]9/23/2014[/TD]
[TD]CODY[/TD]
[TD]Pre-Quoting[/TD]
[TD]MIKE YI[/TD]
[TD="align: right"]17[/TD]
[TD]Y[/TD]
[TD]Triage[/TD]
[/TR]
[TR]
[TD]5CD2216JDF[/TD]
[TD]T58016[/TD]
[TD="align: right"]9/17/2014[/TD]
[TD]MINA[/TD]
[TD]Awaiting instal[/TD]
[TD]TONY[/TD]
[TD="align: right"]16[/TD]
[TD]N[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]G7CV0X1[/TD]
[TD]T21462[/TD]
[TD="align: right"]9/23/2014[/TD]
[TD]BARRY[/TD]
[TD]Final Testing[/TD]
[TD]TYLER[/TD]
[TD="align: right"]16[/TD]
[TD]N[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6CC3482Y5J[/TD]
[TD]T58477[/TD]
[TD="align: right"]9/23/2014[/TD]
[TD]CODY[/TD]
[TD]Final Tested[/TD]
[TD]CODY[/TD]
[TD="align: right"]16[/TD]
[TD]Y[/TD]
[TD]Triage[/TD]
[/TR]
[TR]
[TD]CND3521W0D[/TD]
[TD]T19073[/TD]
[TD="align: right"]9/23/2014[/TD]
[TD]RON[/TD]
[TD]Final Testing[/TD]
[TD]LUCAS[/TD]
[TD="align: right"]16[/TD]
[TD]N[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CCG7YC1[/TD]
[TD]T79640[/TD]
[TD="align: right"]9/9/2014[/TD]
[TD]Chris Fox[/TD]
[TD]Final Testing[/TD]
[TD]Chris Fox[/TD]
[TD="align: right"]14[/TD]
[TD]N[/TD]
[TD]BOM Issue[/TD]
[/TR]
[TR]
[TD]CCG7YC1[/TD]
[TD]T79640[/TD]
[TD="align: right"]9/23/2014[/TD]
[TD]TYLER[/TD]
[TD]Final Testing[/TD]
[TD]TYLER[/TD]
[TD="align: right"]14[/TD]
[TD]N[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CNU00137FQ[/TD]
[TD]T80987[/TD]
[TD="align: right"]9/9/2014[/TD]
[TD]Parent[/TD]
[TD]Awaiting Parts[/TD]
[TD]Parent[/TD]
[TD="align: right"]13[/TD]
[TD]Y[/TD]
[TD]Triage[/TD]
[/TR]
[TR]
[TD]NXWZFAA00122115CF61601[/TD]
[TD]T91115[/TD]
[TD="align: right"]9/12/2014[/TD]
[TD]Booth[/TD]
[TD]Awaiting instal[/TD]
[TD]Mark[/TD]
[TD="align: right"]13[/TD]
[TD]Y[/TD]
[TD]Root Cause[/TD]
[/TR]
[TR]
[TD]NXMABAA0153360A0237601[/TD]
[TD]T91111[/TD]
[TD="align: right"]9/17/2014[/TD]
[TD]RON[/TD]
[TD]Awaiting instal[/TD]
[TD]RON[/TD]
[TD="align: right"]13[/TD]
[TD]Y[/TD]
[TD]Triage[/TD]
[/TR]
[TR]
[TD]7D024198Q[/TD]
[TD]T60336[/TD]
[TD="align: right"]9/10/2014[/TD]
[TD]BEN[/TD]
[TD]Awaiting instal[/TD]
[TD]Tyler[/TD]
[TD="align: right"]12[/TD]
[TD]N[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7D024198Q[/TD]
[TD]T60336[/TD]
[TD="align: right"]9/17/2014[/TD]
[TD]TYLER[/TD]
[TD]Awaiting instal[/TD]
[TD]TYLER[/TD]
[TD="align: right"]12[/TD]
[TD]Y[/TD]
[TD]Root Cause[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col></colgroup>[/TABLE]
I have considered a problem I may have in the future. Serial numbers that are sent to the awaiting parts status will eventually be brought back into the system and tracked for a second repair cycle. The point of this spreadsheet is to track my awaiting install units and their misdiagnoses status.
I understand that my key for this table will need to be composite, It would include serial number, the assigned technician, and finally something else. One thing to understand is taht a unit may be prequoted and put back into the repair cycle on the same day, so date is not a valid option for a third part of the composite key.
What I want to do is keep track of unit cycles, when I scan in serial numbers, i'd like it to check for duplicates, and if so, increment the cycle, starting at one, and onwards, for how many times the unit went to and from a hold status.
What are some options I have for doing this? Which paths should I research in order to accomplish my goal?