11_Nov_Save Loss Data_2022.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE
1	Incident Number	Date	Shift	BN	Station Area	Officer in Charge	Desription	Original Property Value	Original Contents value	Original Total Value	Original Property Value Loss	Original Contents Value Loss	Original Total Loss	Property Value Saved	Contents Value Saved	Percentage Property Saved	Percentage Contents Saved	Original Total Dollar Save	New Property Value	New Contents Value	New Total Value	New Property Value Loss	New Content Loss	New Total Loss	New Total Save	No address found	Not 111	No values / Fire side	Large Value discrepancy	Garage Fire	Vacant

2	IF2200163547	11/1/2022	C Shift	4	44		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
3	IF2200163965	11/2/2022	A Shift	1	33	E Hofmeister	1APARTW	9149100	2000	9151100	45000	5000	50000	9104100	-3000	99.51%	0.00%	9101100	304970	152485	457455	1500	152485	153985	303470
4	IF2200164199	11/2/2022	A Shift	4	44	P McCrary	1RESDW	102400	20000	122400	50000	10000	60000	52400	10000	51.17%	50.00%	62400	102400	51200	153600	50000	25600	75600	78000
5	IF2200164772	11/4/2022	B Shift	5	3		1RESDW	230500	115250	345750	230500	115250	345750	0	0	0.00%	0.00%	0	230500	115250	345750	230500	115250	345750	0
6	IF2200164804	11/4/2022	B Shift	5	3		1DBLRESW	149200	0	149200	149200	74600	223800	0	-74600	0.00%	0.00%	-74600	149200	0	149200	149200	0	149200	0
7	IF2200165207	11/4/2022	C Shift	5	29		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
8	IF2200165309	11/4/2022	C Shift	3	20		1RESDW	43300	21650	64950	5000	1500	6500	38300	20150	88.45%	93.07%	58450	43300	21650	64950	5000	1500	6500	58450
9	IF2200165943	11/6/2022	A Shift	4	2		1APARTW	101745	5000	106745	30000	5000	35000	71745	0	70.51%	0.00%	71745	101745	5000	106745	30000	5000	35000	71745
10	IF2200166035	11/6/2022	A Shift	1	14	S Olofson	1RESDW	150000	15000	165000	25000	15000	40000	125000	0	83.33%	0.00%	125000	150000	75000	225000	25000	75000	100000	125000
11	IF2200166036	11/6/2022	A Shift	3	10		1RESDW	33900	0	33900	15000	0	15000	18900	0	55.75%	0.00%	18900	33900	0	33900	15000	0	15000	18900
12	IF2200166276	11/6/2022	B Shift	5	27		1RESDW	121500	0	121500	6075	0	6075	115425	0	95.00%	0.00%	115425	121500	0	121500	6075	0	6075	115425
13	IF2200167051	11/8/2022	C Shift	6	53	J Ermert	1APARTW	7807940	1951985	9759925	500000	100000	600000	7307940	1851985	93.60%	94.88%	9159925	487996	243998	731994	31250	12500	43750	688244
14	IF2200167052	11/8/2022	C Shift	7	18	D Taylor	1RESDW	30000	1000	31000	5000	500	5500	25000	500	83.33%	50.00%	25500	132000	66000	198000	22000	33000	55000	143000
15	IF2200167172	11/8/2022	A Shift	1	14		1RESDW	153700	76850	230550	12200	3050	15250	141500	73800	92.06%	96.03%	215300	153700	76850	230550	12200	3050	15250	215300
16	IF2200167273	11/8/2022	A Shift	3	24		1APARTW	422971	211486	634457	12000	3000	15000	410971	208486	97.16%	98.58%	619457	422971	211486	634457	12000	3000	15000	619457
17	IF2200167612	11/9/2022	A Shift	3	24		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
18	IF2200167702	11/9/2022	B Shift	1	30		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
19	IF2200168519	11/10/2022	C Shift	1	12	M Mullins	1RESDW	120000	20000	140000	5000	5000	10000	115000	15000	95.83%	75.00%	130000	184500	92250	276750	7687	23063	30750	246000
20	IF2200168883	11/11/2022	A Shift	3	25		1RESDW	63400	0	63400	31700		31700	31700	0	50.00%	0.00%	31700	63400	0	63400	31700	0	31700	31700
21	IF2200169272	11/12/2022	A Shift	3	10		1DBLRESW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
22	IF2200169996	11/13/2022	C Shift	6	26	G Jackson	1RESDW	237600	50000	287600	68400	30000	98400	169200	20000	71.21%	40.00%	189200	237600	118800	356400	68400	71280	139680	216720
23	IF2200170130	11/14/2022	C Shift	3	25	J Kelly	1DBLRESW	200000	20000	220000	2000	1000	3000	198000	19000	99.00%	95.00%	217000	186500	93250	279750	1865	4663	6528	273223
24	IF2200170461	11/14/2022	A Shift	4	44		1RESDW	81400	40700	122100	81400	40700	122100	0	0	0.00%	0.00%	0	81400	40700	122100	81400	40700	122100	0
25	IF2200170620	11/15/2022	A Shift	7	19		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
26	IF2200170837	11/15/2022	B Shift	6	35		1APARTW	514290	257000	771290	5000	500	5500	509290	256500	99.03%	99.81%	765790	514290	257145	771435	5000	500	5500	765935
27	IF2200170993	11/15/2022	B Shift	5	29		1RESDW	108000	54000	162000	15000	5000	20000	93000	49000	86.11%	90.74%	142000	108000	54000	162000	15000	5000	20000	142000
28	IF2200171017	11/15/2022	B Shift	2	17	D Williams	1RESDW	274000	30000	304000	60000	10000	70000	214000	20000	78.10%	66.67%	234000	247000	123500	370500	54088	41167	95254	275246
29	IF2200171499	11/16/2022	C Shift	6	23		1APARTW	419740	209870	629610	15000	5000	20000	404740	204870	96.43%	97.62%	609610	419740	209870	629610	15000	5000	20000	609610
30	IF2200171835	11/17/2022	A Shift	5	27		1DBLRESW	64000	5000	69000	25000	5000	30000	39000	0	60.94%	0.00%	39000		0	0	0	0	0	0
31	IF2200172197	11/18/2022	B Shift	5	3		1RESDW	155700	77850	233550	75000	5000	80000	80700	72850	51.83%	93.58%	153550	150700	75350	226050	72592	4839	77431	148619
32	IF2200172800	11/19/2022	C Shift	3	22	J Ermert	1BUILDW	1033500	5000000	6033500	50000	0	50000	983500	5000000	95.16%	100.00%	5983500	2342100	1171050	3513150	113309	0	113309	3399841
33	IF2200172890	11/19/2022	C Shift	3	22		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
34	IF2200173003	11/19/2022	C Shift	4	42		1RESDW	163000	80000	243000	32000	16000	48000	131000	64000	80.37%	80.00%	195000	163100	81550	244650	32020	16310	48330	196320
35	IF2200173129	11/20/2022	C Shift	6	53	R McClara	1RESDW	140000	50000	190000	50000	5000	55000	90000	45000	64.29%	90.00%	135000	194500	97250	291750	69464	9725	79189	212561
36	IF2200173131	11/20/2022	C Shift	4	42		1RESDW	160000	80000	240000	0	0	0	160000	80000	100.00%	100.00%	240000		0	0	0	0	0	0
37	IF2200173191	11/20/2022	C Shift	1	30	J Ermert	1DBLRESW	71200	12000	83200	26000	6000	32000	45200	6000	63.48%	50.00%	51200	113000	56500	169500	41264	28250	69514	99986
38	IF2200173243	11/20/2022	A Shift	4	41		1RESDW	141000	72500	15000	2000		2000	139000	72500	98.58%	100.00%	13000	141000	70500	211500	2000	0	2000	209500
39	IF2200173690	11/21/2022	A Shift	1	14	S Clegg	1RESDW	133000	5000	138000	10000	1000	11000	123000	4000	92.48%	80.00%	127000	83400	41700	125100	6271	8340	14611	110489
40	IF2200173733	11/21/2022	A Shift	4	45		1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
41	IF2200174526	11/22/2022	C Shift	2	6		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
42	IF2200174825	11/23/2022	C Shift	5	27		1RESDEW	108000	0	108000	10000	0	10000	98000	0	90.74%	0.00%	98000	108000	0	108000	10000	0	10000	98000
43	IF2200174877	11/23/2022	A Shift	3	22		1RESDW	17400	30000	47400	12000	15000	27000	5400	15000	31.03%	50.00%	20400		0	0	0	0	0	0
44	IF2200175538	11/24/2022	B Shift	5	11		1DBLRESW	82000	41000	123000	15000	5000	20000	67000	36000	81.71%	87.80%	103000	82000	41000	123000	15000	5000	20000	103000
45	IF2200176704	11/26/2022	A Shift	5	29	M White	1RESDW	80000	5000	85000	20000	2500	22500	60000	2500	75.00%	50.00%	62500	37500	18750	56250	9375	9375	18750	37500
46	IF2200177925	11/29/2022	C Shift	7	19	D Taylor	1BUILDW	400000	5000	405000	10000	5000	15000	390000	0	97.50%	0.00%	390000	470000	235000	705000	11750	235000	246750	458250
47	IF2200178034	11/29/2022	A Shift	3	10	S Grass	1RESDW	79900	10000	89900	5000	5000	10000	74900	5000	93.74%	50.00%	79900	79900	39950	119850	5000	19975	24975	94875
48	IF2200178575	11/30/2022	A Shift	7	19		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
49	IF2200178981	11/30/2022	B Shift	5	15		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
50	IF2200178999	11/30/2022	B Shift	2	9	C Womock	1BUILDW	22376000	3000	22379000	30000	2000	32000	22346000	1000	99.87%	33.33%	22347000	2376000	1188000	3564000	3186	792000	795186	2768814
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100