BPI Challenge 2017 (filtered2).xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	case	event	startTime	completeTime	LoanGoal	ApplicationType	RequestedAmount	Action	FirstWithdrawalAmount	NumberOfTerms	Accepted	OfferID	org:resource	MonthlyCost	EventOrigin	EventID	Selected	CreditScore	OfferedAmount
2	Application_74089970	A_Create Application	1/5/16 22:44	1/5/16 22:44	Existing loan takeover	New credit	15000	Created					User_1		Application	Application_74089970
3	Application_74089970	A_Submitted	1/5/16 22:44	44:41.4	Existing loan takeover	New credit	15000	statechange					User_1		Application	ApplState_1912615885
4	Application_74089970	A_Submitted	44:41.4	44:41.4	Existing loan takeover	New credit	15000	statechange					User_1		Application	ApplState_1912615885
5	Application_74089970	A_Submitted	44:41.4	44:41.4	Existing loan takeover	New credit	15000	statechange					User_1		Application	ApplState_1912615885
6	Application_74089970	A_Concept	46:10.0	46:10.0	Existing loan takeover	New credit	15000	statechange					User_1		Application	ApplState_1183649475
7	Application_74089970	W_Complete application	18:59.3	04:24.5	Existing loan takeover	New credit	15000	Deleted					User_37		Workflow	Workitem_1457825988
8	Application_74089970	W_Complete application	18:59.3	04:24.5	Existing loan takeover	New credit	15000	Deleted					User_37		Workflow	Workitem_1457825988
9	Application_74089970	W_Complete application	18:59.3	04:24.5	Existing loan takeover	New credit	15000	Deleted					User_37		Workflow	Workitem_1457825988
10	Application_74089970	A_Accepted	1/7/16 17:51	51:36.7	Existing loan takeover	New credit	15000	statechange					User_37		Application	ApplState_1335931596
11	Application_74089970	O_Create Offer	1/7/16 17:58	58:53.5	Existing loan takeover	New credit	15000	Created	0	127	FALSE		User_37	150	Offer	Offer_238690222	FALSE	0	15000
12	Application_74089970	O_Created	58:54.7	58:54.7	Existing loan takeover	New credit	15000	statechange	0	127	FALSE	Offer_238690222	User_37	150	Offer	OfferState_155222374	FALSE	0	15000
13	Application_1688279534	A_Create Application	02:40.7	02:40.7	Existing loan takeover	New credit	7000	Created					User_1		Application	Application_1688279534
14	Application_1688279534	A_Submitted	02:40.7	02:40.7	Existing loan takeover	New credit	7000	statechange					User_1		Application	ApplState_1535038961
15	Application_1688279534	A_Submitted	02:40.7	02:40.7	Existing loan takeover	New credit	7000	statechange					User_1		Application	ApplState_1535038961
16	Application_1688279534	A_Submitted	02:40.7	02:40.7	Existing loan takeover	New credit	7000	statechange					User_1		Application	ApplState_1535038961
17	Application_1688279534	W_Complete application	06:54.9	00:24.3	Existing loan takeover	New credit	7000	Deleted					User_71		Workflow	Workitem_1717198859
18	Application_1688279534	A_Concept	06:54.9	06:54.9	Existing loan takeover	New credit	7000	statechange					User_2		Application	ApplState_1302242220
19	Application_1688279534	A_Concept	06:54.9	06:54.9	Existing loan takeover	New credit	7000	statechange					User_2		Application	ApplState_1302242220
20	Application_1688279534	A_Accepted	52:07.5	52:07.5	Existing loan takeover	New credit	7000	statechange					User_71		Application	ApplState_1867708463
21	Application_1688279534	O_Create Offer	58:15.0	58:15.0	Existing loan takeover	New credit	7000	Created	0	39	FALSE		User_71	200	Offer	Offer_1996633450	FALSE	0	7000
22	Application_1688279534	O_Created	58:16.6	58:16.6	Existing loan takeover	New credit	7000	statechange	0	39	FALSE	Offer_1996633450	User_71	200	Offer	OfferState_365928443	FALSE	0	7000
23	Application_1688279534	O_Sent (mail and online)	00:24.3	00:24.3	Existing loan takeover	New credit	7000	statechange	0	39	FALSE	Offer_1996633450	User_71	200	Offer	OfferState_1181714633	FALSE	0	7000
24	Application_1688279534	O_Sent (mail and online)	00:24.3	00:24.3	Existing loan takeover	New credit	7000	statechange	0	39	FALSE	Offer_1996633450	User_71	200	Offer	OfferState_1181714633	FALSE	0	7000
25	Application_1688279534	W_Call after offers	00:24.3	32:37.5	Existing loan takeover	New credit	7000	Deleted	0	39	FALSE	Offer_1996633450	User_4	200	Workflow	Workitem_730934958	FALSE	0	7000
26	Application_1688279534	A_Complete	00:24.4	00:24.4	Existing loan takeover	New credit	7000	statechange	0	39	FALSE	Offer_1996633450	User_71	200	Application	ApplState_147712357	FALSE	0	7000
27	Application_1688279534	A_Cancelled	32:37.4	32:37.4	Existing loan takeover	New credit	7000	statechange	0	39	FALSE	Offer_1996633450	User_4	200	Application	ApplState_1673444558	FALSE	0	7000
28	Application_1688279534	O_Cancelled	32:37.5	32:37.5	Existing loan takeover	New credit	7000	statechange	0	39	FALSE	Offer_1996633450	User_4	200	Offer	OfferState_1885978377	FALSE	0	7000
29	Application_224758141	A_Create Application	52:12.8	52:12.8	Home improvement	New credit	30000	Created					User_14		Application	Application_224758141
30	Application_224758141	A_Create Application	52:12.8	52:12.8	Home improvement	New credit	30000	Created					User_14		Application	Application_224758141
31	Application_224758141	W_Complete application	52:12.9	00:14.7	Home improvement	New credit	30000	Deleted					User_14		Workflow	Workitem_861515498
32	Application_224758141	A_Concept	52:12.9	52:12.9	Home improvement	New credit	30000	statechange					User_14		Application	ApplState_1089094319
33	Application_224758141	A_Accepted	57:43.5	57:43.5	Home improvement	New credit	30000	statechange					User_14		Application	ApplState_681110571
34	Application_224758141	O_Create Offer	00:01.1	00:01.1	Home improvement	New credit	30000	Created	30000	120	TRUE		User_14	313.78	Offer	Offer_889838345	FALSE	0	30000
35	Application_224758141	O_Created	00:02.3	00:02.3	Home improvement	New credit	30000	statechange	30000	120	TRUE	Offer_889838345	User_14	313.78	Offer	OfferState_851582360	FALSE	0	30000
36	Application_224758141	O_Sent (mail and online)	00:14.7	00:14.7	Home improvement	New credit	30000	statechange	30000	120	TRUE	Offer_889838345	User_14	313.78	Offer	OfferState_535703419	FALSE	0	30000
37	Application_224758141	O_Sent (mail and online)	00:14.7	00:14.7	Home improvement	New credit	30000	statechange	30000	120	TRUE	Offer_889838345	User_14	313.78	Offer	OfferState_535703419	FALSE	0	30000
38	Application_224758141	W_Call after offers	00:14.7	02:38.1	Home improvement	New credit	30000	Deleted	30000	120	TRUE	Offer_889838345	User_14	313.78	Workflow	Workitem_2088878625	FALSE	0	30000
39	Application_224758141	A_Complete	00:14.7	00:14.7	Home improvement	New credit	30000	statechange	30000	120	TRUE	Offer_889838345	User_14	313.78	Application	ApplState_499890271	FALSE	0	30000
40	Application_224758141	A_Cancelled	02:38.0	02:38.0	Home improvement	New credit	30000	statechange	30000	120	TRUE	Offer_889838345	User_14	313.78	Application	ApplState_1222327434	FALSE	0	30000
41	Application_224758141	O_Cancelled	02:38.1	02:38.1	Home improvement	New credit	30000	statechange	30000	120	TRUE	Offer_889838345	User_14	313.78	Offer	OfferState_1847956814	FALSE	0	30000
42	Application_1565253423	A_Create Application	34:24.3	34:24.3	Unknown	New credit	0	Created					User_75		Application	Application_1565253423
43	Application_1565253423	A_Create Application	34:24.3	34:24.3	Unknown	New credit	0	Created					User_75		Application	Application_1565253423
44	Application_1565253423	W_Complete application	34:24.4	03:43.2	Unknown	New credit	0	Deleted					User_19		Workflow	Workitem_1837382175
45	Application_1565253423	A_Concept	34:24.4	34:24.4	Unknown	New credit	0	statechange					User_75		Application	ApplState_186312604
46	Application_1565253423	A_Accepted	45:19.2	45:19.2	Unknown	New credit	0	statechange					User_75		Application	ApplState_261996057
47	Application_1565253423	O_Create Offer	10:28.3	10:28.3	Unknown	New credit	0	Created	6875	120	TRUE		User_75	366.08	Offer	Offer_2146771547	FALSE	0	35000
48	Application_1565253423	O_Created	10:29.7	10:29.7	Unknown	New credit	0	statechange	6875	120	TRUE	Offer_2146771547	User_75	366.08	Offer	OfferState_426996525	FALSE	0	35000
49	Application_1565253423	O_Created	10:29.7	10:29.7	Unknown	New credit	0	statechange	6875	120	TRUE	Offer_2146771547	User_75	366.08	Offer	OfferState_426996525	FALSE	0	35000
50	Application_1565253423	O_Cancelled	33:49.7	33:49.7	Unknown	New credit	0	statechange	6875	120	TRUE	Offer_2146771547	User_19	366.08	Offer	OfferState_1439055872	FALSE	0	35000
51	Application_1565253423	A_Cancelled	03:43.1	03:43.1	Unknown	New credit	0	statechange	6875	120	TRUE	Offer_2146771547	User_19	366.08	Application	ApplState_2143480611	FALSE	0	35000
52	Application_1896170333	A_Create Application	27:53.6	27:53.6	Home improvement	New credit	25000	Created					User_1		Application	Application_1896170333
53	Application_1896170333	A_Submitted	27:53.7	27:53.7	Home improvement	New credit	25000	statechange					User_1		Application	ApplState_734226332
54	Application_1896170333	A_Submitted	27:53.7	27:53.7	Home improvement	New credit	25000	statechange					User_1		Application	ApplState_734226332
55	Application_1896170333	A_Submitted	27:53.7	27:53.7	Home improvement	New credit	25000	statechange					User_1		Application	ApplState_734226332
56	Application_1896170333	A_Concept	29:29.1	29:29.1	Home improvement	New credit	25000	statechange					User_1		Application	ApplState_1974216061
57	Application_1896170333	W_Complete application	38:45.6	50:34.9	Home improvement	New credit	25000	Deleted					User_36		Workflow	Workitem_619123484
58	Application_1896170333	A_Accepted	43:59.1	43:59.1	Home improvement	New credit	25000	statechange					User_36		Application	ApplState_1629994130
59	Application_1896170333	O_Create Offer	50:19.7	50:19.7	Home improvement	New credit	25000	Created	0	126	TRUE		User_36	250	Offer	Offer_1103777676	FALSE	0	25000
60	Application_1896170333	O_Created	50:21.2	50:21.2	Home improvement	New credit	25000	statechange	0	126	TRUE	Offer_1103777676	User_36	250	Offer	OfferState_1920611368	FALSE	0	25000
61	Application_1896170333	O_Sent (mail and online)	50:34.9	50:34.9	Home improvement	New credit	25000	statechange	0	126	TRUE	Offer_1103777676	User_36	250	Offer	OfferState_1944702458	FALSE	0	25000
62	Application_1896170333	O_Sent (mail and online)	50:34.9	50:34.9	Home improvement	New credit	25000	statechange	0	126	TRUE	Offer_1103777676	User_36	250	Offer	OfferState_1944702458	FALSE	0	25000
63	Application_1896170333	W_Call after offers	50:34.9	52:29.6	Home improvement	New credit	25000	Deleted	0	126	TRUE	Offer_1103777676	User_36	250	Workflow	Workitem_1979719415	FALSE	0	25000
64	Application_1896170333	A_Complete	50:34.9	50:34.9	Home improvement	New credit	25000	statechange	0	126	TRUE	Offer_1103777676	User_36	250	Application	ApplState_626608515	FALSE	0	25000
65	Application_1896170333	O_Cancelled	52:22.4	52:22.4	Home improvement	New credit	25000	statechange	0	126	TRUE	Offer_1103777676	User_36	250	Offer	OfferState_1822374328	FALSE	0	25000
66	Application_1896170333	A_Cancelled	52:29.5	52:29.5	Home improvement	New credit	25000	statechange	0	126	TRUE	Offer_1103777676	User_36	250	Application	ApplState_869868349	FALSE	0	25000
67	Application_203309822	A_Create Application	29:49.9	29:49.9	Unknown	New credit	0	Created					User_86		Application	Application_203309822
68	Application_203309822	A_Create Application	29:49.9	29:49.9	Unknown	New credit	0	Created					User_86		Application	Application_203309822
69	Application_203309822	W_Complete application	29:49.9	55:53.2	Unknown	New credit	0	Deleted					User_86		Workflow	Workitem_1730815160
70	Application_203309822	A_Concept	29:49.9	29:49.9	Unknown	New credit	0	statechange					User_86		Application	ApplState_1705475678
71	Application_203309822	A_Accepted	34:40.8	34:40.8	Unknown	New credit	0	statechange					User_86		Application	ApplState_496571713
72	Application_203309822	O_Create Offer	54:20.9	54:20.9	Unknown	New credit	0	Created	50000	120	TRUE		User_86	522.97	Offer	Offer_1771222002	FALSE	0	50000
73	Application_203309822	O_Created	54:22.1	54:22.1	Unknown	New credit	0	statechange	50000	120	TRUE	Offer_1771222002	User_86	522.97	Offer	OfferState_1932361733	FALSE	0	50000
74	Application_203309822	O_Create Offer	54:51.2	54:51.2	Unknown	New credit	0	Created	0	126	TRUE	Offer_1771222002	User_86	500	Offer	Offer_587535462	FALSE	0	50000
75	Application_203309822	O_Created	54:52.5	54:52.5	Unknown	New credit	0	statechange	0	126	TRUE	Offer_587535462	User_86	500	Offer	OfferState_268307969	FALSE	0	50000
76	Application_203309822	O_Sent (mail and online)	55:53.2	55:53.2	Unknown	New credit	0	statechange	0	126	TRUE	Offer_587535462	User_86	500	Offer	OfferState_491367011	FALSE	0	50000
77	Application_203309822	O_Sent (mail and online)	55:53.2	55:53.2	Unknown	New credit	0	statechange	0	126	TRUE	Offer_1771222002	User_86	500	Offer	OfferState_1254109328	FALSE	0	50000
78	Application_203309822	O_Sent (mail and online)	55:53.2	55:53.2	Unknown	New credit	0	statechange	0	126	TRUE	Offer_1771222002	User_86	500	Offer	OfferState_1254109328	FALSE	0	50000
79	Application_203309822	W_Call after offers	55:53.2	05:24.6	Unknown	New credit	0	Deleted	0	126	TRUE	Offer_1771222002	User_142	500	Workflow	Workitem_1503290605	FALSE	0	50000
80	Application_203309822	A_Complete	55:53.2	55:53.2	Unknown	New credit	0	statechange	0	126	TRUE	Offer_1771222002	User_86	500	Application	ApplState_1364121338	FALSE	0	50000
81	Application_203309822	O_Cancelled	37:53.2	37:53.2	Unknown	New credit	0	statechange	0	126	TRUE	Offer_587535462	User_86	500	Offer	OfferState_939216472	FALSE	0	50000
82	Application_203309822	O_Cancelled	37:53.2	37:53.2	Unknown	New credit	0	statechange	0	126	TRUE	Offer_1771222002	User_86	500	Offer	OfferState_1659764038	FALSE	0	50000
83	Application_203309822	O_Create Offer	38:28.3	38:28.3	Unknown	New credit	0	Created	0	126	TRUE	Offer_1771222002	User_86	500	Offer	Offer_1492567221	FALSE	0	50000
84	Application_203309822	O_Created	38:29.5	38:29.5	Unknown	New credit	0	statechange	0	126	TRUE	Offer_1492567221	User_86	500	Offer	OfferState_1571524142	FALSE	0	50000
85	Application_203309822	O_Create Offer	38:47.5	38:47.5	Unknown	New credit	0	Created	50000	120	TRUE	Offer_1492567221	User_86	522.97	Offer	Offer_2023101042	FALSE	0	50000
86	Application_203309822	O_Created	38:48.8	38:48.8	Unknown	New credit	0	statechange	50000	120	TRUE	Offer_2023101042	User_86	522.97	Offer	OfferState_2003516853	FALSE	0	50000
87	Application_203309822	O_Sent (mail and online)	39:08.4	39:08.4	Unknown	New credit	0	statechange	50000	120	TRUE	Offer_2023101042	User_86	522.97	Offer	OfferState_1552396401	FALSE	0	50000
88	Application_203309822	O_Sent (mail and online)	39:08.4	39:08.4	Unknown	New credit	0	statechange	50000	120	TRUE	Offer_1492567221	User_86	522.97	Offer	OfferState_1775748158	FALSE	0	50000
89	Application_203309822	A_Cancelled	05:24.4	05:24.4	Unknown	New credit	0	statechange	50000	120	TRUE	Offer_1492567221	User_142	522.97	Application	ApplState_740792829	FALSE	0	50000
90	Application_203309822	O_Cancelled	05:24.5	05:24.5	Unknown	New credit	0	statechange	50000	120	TRUE	Offer_2023101042	User_142	522.97	Offer	OfferState_659994659	FALSE	0	50000
91	Application_203309822	O_Cancelled	05:24.5	05:24.5	Unknown	New credit	0	statechange	50000	120	TRUE	Offer_1492567221	User_142	522.97	Offer	OfferState_595526304	FALSE	0	50000
92	Application_772295828	A_Create Application	41:21.9	41:21.9	Car	New credit	10300	Created					User_74		Application	Application_772295828
93	Application_772295828	A_Create Application	41:21.9	41:21.9	Car	New credit	10300	Created					User_74		Application	Application_772295828
94	Application_772295828	W_Complete application	41:21.9	52:42.8	Car	New credit	10300	Deleted					User_74		Workflow	Workitem_2114314449
95	Application_772295828	A_Concept	41:21.9	41:21.9	Car	New credit	10300	statechange					User_74		Application	ApplState_621799280
96	Application_772295828	A_Accepted	46:35.6	46:35.6	Car	New credit	10300	statechange					User_74		Application	ApplState_1145737703
97	Application_772295828	O_Create Offer	52:14.2	52:14.2	Car	New credit	10300	Created	6000	60	TRUE		User_74	197.01	Offer	Offer_168300670	FALSE	0	10300
98	Application_772295828	O_Created	52:15.6	52:15.6	Car	New credit	10300	statechange	6000	60	TRUE	Offer_168300670	User_74	197.01	Offer	OfferState_1996334469	FALSE	0	10300
99	Application_772295828	O_Sent (mail and online)	52:42.8	52:42.8	Car	New credit	10300	statechange	6000	60	TRUE	Offer_168300670	User_74	197.01	Offer	OfferState_1603423225	FALSE	0	10300
100	Application_772295828	O_Sent (mail and online)	52:42.8	52:42.8	Car	New credit	10300	statechange	6000	60	TRUE	Offer_168300670	User_74	197.01	Offer	OfferState_1603423225	FALSE	0	10300