@DerSnoezie: The night shift has been hard at work... I've cleaned up the raw data from your first post, in the following ways: - removed complete serial numbers; just first four characters remain - removed extra spaces - fixed some typos from users - regularized the fine/(reason) text - changed all dates to YYYY-MM-DD (ISO 8601) - converted dates of the form "Month 200x" to YYYY-MM-01 - made sure all ':' are in place, so columns line up My version of the data imports perfectly into Excel, so you can do some sorting/filtering/data mining. Enjoy! ===== Number:Serial N°:Model:Part N°:Firmware:DateCode:MfgDate:SiteCode:PurchaseDate:FailedDate:OEM/RETAIL:UserName:Country of User:fail reason/fine:OS 1:9QM7****:ST3500320AS:9BX154-303:SD15:09146:2008-10-09:KRATSG:2008-10-01:2008-12-24:N/A:poolcarpet:Malaysia:: 2:9QM6****:ST3500320AS:9BX154-303:SD15:09115:2008-09-17:KRATSG:2008-10-01:2008-12-28:N/A:DaftMule:UK:: 3:9QM6****:ST3500320AS:9BX154-303:SD15:N/A:N/A:KRATSG:2008-12-05:2008-12-19:N/A:DerSnoezie:Netherlands:(no detect in bios): 4:9QM4****:ST3500320AS:9BX154-303:SD15:08503:2008-06-16:KRATSG:2008-08-01:2008-11-01:N/A:dskbrk::: 5:9QM3****:ST3500320AS:9BX154-568:SD81:08464:2008-05-20:KRATSG:2008-08-01:2008-12-23:N/A:ToKuRo:Chile:(no detect in bios): 6:9QM7****:ST3500320AS:9BX154-501:SD15:09134:2008-09-30:KRATSG:2008-10-28:2009-01-07:N/A:jeroen__online:Netherlands:: 7:9QM2****:ST3500320AS:9BX154-303:SD15:08406:2008-04-10:KRATSG:2008-04-12:2008-12-23:N/A:quattro150:Malaysia:: 8:9QJ0****:ST31000340AS:9BX158-303:SD15:08496:2008-06-12:KRATSG:2008-09-01:2009-01-08:N/A:Nichev::: 9:9QM7****:ST3500320AS:9BX154-303:SD15:09114:2008-09-16:KRATSG:2008-10-13:2008-12-14:N/A:PrOdiGy1:UK:: 10:9QJ1****:ST31000340AS:9BX158-303:SD15:09063:2008-08-11:KRATSG:2008-11-01:2008-12-27:N/A:AVINNC:USA:: 11:9QJ1****:ST31000340AS:9BX158-303:SD15:08515:2008-07-02:KRATSG:2008-08-01:2009-01-04:N/A:Ruddrage:UK:: 12:9QM6****:ST3500820AS:9BX134-505:SD25:09084:2008-08-26:KRATSG:2008-07-01:2008-12-20:N/A:rainshower:Germany:: 13:9QM3****:STM3500320AS:9GT154-325:MX15:08396:2008-04-03:KRTASG:2008-09-01:2008-12-30:N/A:fabio.cillo:Italy:: 14:9QM*****:ST3500320AS:9BX154-303:SD15:08367:2008-03-14:KRATSG:2007-12-01:2008-12-01:N/A:Death_Angel:Malaysia:: 15:9QK*****:ST3750630AS:9BX146-621:HP24:08511:2008-06-21:TK:2008-10-01:2009-01-07:N/A:Taiketo::: 16:5QJ*****:ST31000340AS:9BX158-303:SD15:09121:2008-09-20:WUXISG:2008-10-01:2008-12-28:N/A:Styleman::: 17:9QM8****:ST3500320AS:9BX154-303:SD15:N/A:2008-10-13:KRATSG:2008-12-06:2008-12-24:N/A:roadstarter:Philippines:: 18:9QM6****:ST3500320AS:9BX154-303:SD15:09076:2008-08-21:KRATSG:2008-10-15:2008-12-29:N/A:labraticmp3:USA:: 19:9QM6****:ST3500320AS:9BX154-303:SD15:N/A:N/A:N/A:2008-10-01:2009-01-02:N/A:eli2k::: 20:9QM5****:ST3500320AS:9BX154-303:SD15:09063:2008-08-11:KRATSG:2008-11-06:2008-11-27:N/A:poim76::: 21:9QM2****:ST3500320AS:9BX154-303:SD15:08382:2008-03-23:KRATSG:2008-08-01:2008-11-30:N/A:caba212:Spain:: 22:9QJ1****:ST31000340AS:9BX158-303:SD15:08496:2008-06-05:KRATSG:2008-07-01:2008-12-26:N/A:GrayGhost:USA:: 23:9QM2****:ST3500320AS:9BX154-303:SD15:08381:2008-03-22:KRATSG:2008-08-12:2009-01-09:N/A:timha::: 24:9QJ0****:ST31000340AS:9BX158-303:SD15:08495:2008-06-11:KRATSG:2008-10-01:2009-01-02:N/A:viniciusferrao:Brazil:: 25:9QM6****:ST3500320AS:9BX154-303:SD15:09076:2008-08-21:KRATSG:2008-10-31:2008-12-01:N/A:RiderZen:Australia:(BSY): 26:9QJ0****:ST31000340AS:9BX158-335:SD15:08457:2008-05-16:KRATSG:2008-07-01:2008-12-20:N/A:Macprk:USA:: 27:9QM5****:ST3500320AS:9BX154-303:SD15:09071:2008-08-16:KRATSG:2008-11-04:2009-01-09:N/A:BigSilverHotdog:USA:: 28:9QM2****:ST3500320AS:9BX154-303:SD15:08382:2008-03-23:KRATSG:2008-08-01:2009-01-01:N/A:Keddar:USA:: 29:5QM1****:ST3500320AS:9BX154-303:SD15:08383:2008-03-24:WUXISG:2008-07-01:2009-01-02:N/A:waly2k1:Argentina:(no detect in bios): 30:9QM5****:ST3500320AS:9BX154-303:SD15:09063:2008-08-11:KRATSG:2008-07-01:2008-12-25:N/A:criverock:Italy:(no detect in bios): 31:9QM*****:ST3500320AS:9BX154-303:SD15:09076:2008-08-21:KRATSG:2008-10-01:2008-12-20:N/A:sarahcoco:France:: 32:9QJ*****:ST31000340AS:9BX158-303:SD15:09104:2008-09-09:KRATSG:2008-10-10:2009-01-03:N/A:artpav:Canada:: 33:9QM*****:ST3500320AS:9BX154-303:SD15:08371:2008-03-15:KRATSG:2008-05-07:2008-12-29:N/A:KillerB:Korea:(no detect in bios): 34:5QJ0****:ST31000340AS:9BX158-303:SD15:09045:2008-07-30:WUXISG:2008-08-01:2008-12-24:N/A:Fuzzy_3D:Canada:: 35:9QJ0****:ST31000340AS:9BX158-303:SD15:08356:2008-03-06:KRATSG:2008-03-01:2008-06-01:N/A:TheName:Croatia:(maxtor!): 36:9QM2****:ST3500320AS:9BX154-303:SD15:08381:2008-03-22:KRATSG:2008-07-01:2009-01-05:OEM:BARAKASPEED:Thailand:: 37:9QM1****:ST3500320AS:9BX154-303:SD15:08364:2008-03-11:KRATSG:2008-05-01:2008-12-12:OEM:taa:Russia:(no detect in bios): 38:9QM6****:ST3500320AS:9BX154-303:SD15:09096:2008-08-12:KRATSG:2008-09-01:2009-01-07:OEM:kiave:Poland:(no detect in bios): 39:9QM0****:ST3500320AS:9BX154-303:SD15:08315:2008-02-06:KRATSG:2008-03-31:2009-01-11:N/A:laz:Canada:(no detect in bios): 40:9QM6****:ST3500320AS:9BX154-303:SD15:09082:2008-08-24:KRATSG:2008-12-01:2009-01-11:OEM:SeaGAYBarracuTARD:Canada:(no detect in bios): 41:9QM0****:ST3500320AS:9BX154-303:SD15:08243:2008-12-17:KRATSG:2008-01-01:N/A:N/A:dragtop:Canada:fine: 42:9QM8****:ST3500320AS:9BX154-303:SD15:09174:2008-10-28:KRATSG:2008-11-14:2008-01-11:OEM:harwin:Singapore:(no detect in bios): 43:9QM*****:ST3500320AS:9BX154-335:SD15:09054:2008-08-05:KRATSG:2008-09-26:2008-12-19:RETAIL:matildasmith:USA:(BSY): 44:9QM*****:ST3500320AS:9BX154-335:SD15:09085:2008-08-27:KRATSG:2008-12-30:N/A:RETAIL:matildasmith:USA:fine: 45:9QM*****:ST3500320AS:9BX154-335:SD15:09085:2008-08-27:KRATSG:2008-12-30:N/A:RETAIL:matildasmith:USA:fine: 46:9QM1****:ST3500320AS:9BX154-303:SD15:08337:2008-02-22:KRATSG:not sure(at least 1 year old):N/A:OEM:harwin:Singapore:fine: 47:9QM6****:ST3500320AS:9BX154-303:SD15:09085:2008-08-27:KRATSG:2008-09-30:2009-01-11:N/A:bp2411:UK:(no detect in bios): 48:9QJ2****:ST31000340AS:9BX158-303:SD15:09086:2008-08-28:KRATSG:2008-09-22:2008-12-26:OEM:Lippy:UK:(BSY): 49:9QM5****:ST3500320AS:9BX154-303:SD15:09062:2008-08-10:KRATSG:2008-04-09:2008-12-01:OEM:prim:Spain:(no detect in bios): 50:5QJ0****:ST31000340AS:9BX158-303:SD15:08516:2008-06-26:WUXISG:2008-11-13:2009-01-14:RETAIL:Karlston:Australia:(no detect in bios): 51:5QJ0****:ST31000340AS:9BX158-302:SD04:08185:2007-11-07:WUXISG:2008-04-06:2008-06-21:RETAIL:hallwal:USA:(0GB reported): 52:9QM8****:ST3500320AS:9BX154-303:SD15:09167:2008-10-24:KRATSG:2008-12-01:2009-01-11:OEM:s1lencer:Malaysia:(no detect in bios): 53:9QJ0****:ST31000340AS:9BX158-303:SD15:09012:2008-07-06:KRATSG:N/A:N/A:OEM:rimask:Singapore:(no detect in bios): 54:9QK0****:ST3750330AS:9BX156-303:SD15:09024:2008-07-15:KRATSG:2008-11-28:2008-12-30:OEM:valdas:Lithuania:(no detect in bios): 55:9QJ1****:ST31000340AS:9BX158-303:SD15:08526:2008-07-03:KRATSG:2008-08-01:N/A:OEM:me0w:Sweden:fine: 56:9QJ1****:ST31000340AS:9BX158-303:SD15:08526:2008-07-03:KRATSG:2008-08-01:N/A:OEM:me0w:Sweden:fine: 57:5QJ0****:ST31000340AS:9BX158-303:SD15:08524:2008-07-01:WUXISG:2008-08-01:N/A:OEM:me0w:Sweden:fine: 58:9QM4****:ST3500320AS:9BX154-303:SD15:08525:2008-07-02:KRATSG:2008-08-01:N/A:OEM:me0w:Sweden:fine: 59:9QM1****:ST3500320AS:9BX154-303:SD15:08345:2008-02-27:KRATSG:2008-03-30:N/A:OEM:me0w:Sweden:fine: 60:5QJ0****:ST31000340AS:9BX158-303:SD15:09133:2008-09-29:WUXISG:2009-01-01:N/A:OEM:jkc120:USA:fine:FreeBSD 7.1 61:5QJ0****:ST31000340AS:9BX158-303:SD15:09133:2008-09-29:WUXISG:2009-01-01:N/A:OEM:jkc120:USA:fine:FReeBSD 7.1 61:5QJ0****:ST31000340AS:9BX158-303:SD15:09133:2008-09-29:WUXISG:2009-01-01:N/A:OEM:jkc120:USA:fine:FReeBSD 7.1 62:9QM7****:ST3500320AS:9BX154-303:SD15:09116:2008-09-18:KRATSG:2008-11-25:2009-01-13:N/A:DeadST3500320AS:USA:(no detect in bios): 63:9QJ1****:ST31000340AS:9BX158-303:SD15:09107:2008-09-12:KRATSG:2008-11-01:2009-02-01:OEM:SSKEV:Greece:(no detect in bios): 64:9QM5****:ST3500320AS:9BX154-303:SD15:09077:2008-08-22:KRATSG:2008-08-30:2009-01-10:N/A:D3m3nt0r:Germany:(no detect in bios): 65:5QM0****:ST3500320AS:9BX154-303:SD15:08225:2007-12-05:WUXISG:2008-01-21:N/A:N/A:Jack_Steel:Austria:fine:WinXP_32bit 66:9QM*****:ST3500320AS:9BX154-303:SD15:09075:2008-08-20:KRATSG:2008-09-01:N/A:OEM:CheshireCat:Israel:fine:xp32pro_vista32ult_now 67:9SZ*****:ST3320613AS:9FZ-162-300:SD11:08391:2008-03-29:TK:2008-08-01:2008-12-22:OEM:kadolf:Germany:(0GB reported):WinServer 2k8 x64 68:9QM2****:ST3500320AS:9BX154-303:SD15:08381:2008-03-22:KRATSG:(unsure):2009-12-01:N/A:AlexLilic:Sweden:(no detect in bios):N/A
