07_Jul_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	IF2200104858	7/16/2022	C Shift	4	43	C Major	1BUILDW	1500000	750000	2250000	10000	5000	15000	1490000	745000	99.33%	99.33%	2235000	948000	474000	1422000	6320	3160	9480	1412520
3	IF2200105100	7/17/2022	C Shift	7	18	D Taylor	1DBLRESW	90000	4000	94000	50000	3000	53000	40000	1000	44.44%	25.00%	41000	98800	49400	148200	54889	37050	91939	56261
4	IF2200101238	7/10/2022	C Shift	5	3	H Stahl	1RESDW	627000	32000	659000	35000	5000	40000	592000	27000	94.42%	84.38%	619000	62700	31350	94050	3500	4898	8398	85652
5	IF2200109721	7/25/2022	B Shift	5	11	H Stahl	1RESDW	116110	2500	118610	10000	60000	70000	106110	-57500	91.39%	0.00%	48610	116100	58050	174150	9999	58050	68049	106101
6	IF2200098187	7/5/2022	C Shift	5	15	H Stahl	1RESDW	76000	40000	116000	20000	10000	30000	56000	30000	73.68%	75.00%	86000	76000	38000	114000	20000	9500	29500	84500
7	IF2200113251	7/31/2022	C Shift	5	27	J Marsh	1RESDW	150000	150	150150	2000	100	2100	148000	50	98.67%	33.33%	148050	231500	150	231650	3087	100	3187	228463
8	IF2200099486	7/7/2022	B Shift	4	55	J McNair	1RESDW	316300	41000	357300	47445	23723	71168	268855	17277	85.00%	42.14%	286132	316300	158150	474450	47445	91507	138952	335498
9	IF2200097307	7/3/2022	B Shift	7	1	J Moellman	1RESDW	82000	20000	102000	50000	15000	65000	32000	5000	39.02%	25.00%	37000	82900	41450	124350	50549	31088	81636	42714
10	IF2200096070	7/1/2022	C Shift	5	11	L Sayre	1DBLRESEW			0			0	0	0	0.00%	0.00%	0	63700	31850	95550	63700	31850	95550	0
11	IF2200107363	7/21/2022	A Shift	4	2	P McCrary	1RESDW	132600	66000	198600	30000	30000	60000	102600	36000	77.38%	54.55%	138600	132600	66300	198900	30000	30136	60136	138764
12	IF2200098948	7/6/2022	B Shift	1	4	S Clegg	1RESDW	239000	30000	269000	100000	10000	110000	139000	20000	58.16%	66.67%	159000	239000	119500	358500	100000	39833	139833	218667
13	IF2200095907	7/1/2022	C Shift	5	3		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
14	IF2200095891	7/1/2022	C Shift	2	6		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
15	IF2200100607	7/9/2022	A Shift	5	11		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
16	IF2200100972	7/9/2022	B Shift	5	11		1RESDW	60300	30150	90450	25000	2000	27000	35300	28150	58.54%	93.37%	63450	60300	30150	90450	25000	2000	27000	63450
17	IF2200109689	7/25/2022	B Shift	5	11		1RESDW	50800	25400	76200	10000	3000	13000	40800	22400	80.31%	88.19%	63200		0	0	0	0	0	0
18	IF2200100614	7/9/2022	A Shift	1	12		1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
19	IF2200112815	7/30/2022	B Shift	7	13		1APARTW	3414000	150000	3564000	100000	20000	120000	3314000	130000	97.07%	86.67%	3444000	3414000	150000	3564000	100000	20000	120000	3444000
20	IF2200107697	7/21/2022	B Shift	7	13		1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
21	IF2200103336	7/14/2022	C Shift	1	14		1RESDW	165100	0	165100	100000	0	100000	65100	0	39.43%	0.00%	65100	165100	0	165100	100000	0	100000	65100
22	IF2200105113	7/17/2022	C Shift	5	15		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
23	IF2200098680	7/5/2022	A Shift	2	17		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
24	IF2200097453	7/4/2022	B Shift	7	19		1RESDW	85000	1000	86000	20000	1000	21000	65000	0	76.47%	0.00%	65000		0	0	0	0	0	0
25	IF2200111243	7/27/2022	B Shift	3	20		1APARTEW	159000	79500	238500	79500	31500	111000	79500	48000	50.00%	60.38%	127500	159000	79500	238500	79500	31500	111000	127500
26	IF2200098893	7/6/2022	A Shift	3	20		1BUILDW	77500	38750	116250	11625	1938	13563	65875	36812	85.00%	95.00%	102687		0	0	0	0	0	0
27	IF2200111784	7/28/2022	C Shift	2	21		1RESDW	116900	0	116900	5800	0	5800	111100	0	95.04%	0.00%	111100	116900	0	116900	5800	0	5800	111100
28	IF2200095686	7/1/2022	B Shift	3	22		1DBLRESW	126300	500	126800	100000	500	100500	26300	0	20.82%	0.00%	26300	126300	500	126800	100000	500	100500	26300
29	IF2200095677	7/1/2022	B Shift	3	22		1DBLRESW	249000	124500	373500	74700	87150	161850	174300	37350	70.00%	30.00%	211650	249000	124500	373500	74700	87150	161850	211650
30	IF2200107401	7/21/2022	A Shift	3	22		1DBLRESW	67800	2000	69800	45000	2000	47000	22800	0	33.63%	0.00%	22800	67800	2000	69800	45000	2000	47000	22800
31	IF2200099396	7/6/2022	B Shift	3	24		1BUILDW	76000	38000	114000	10000	500	10500	66000	37500	86.84%	98.68%	103500	76000	38000	114000	10000	500	10500	103500
32	IF2200103225	7/13/2022	C Shift	6	26		1RESDW	416100	208050	624150	312075	187245	499320	104025	20805	25.00%	10.00%	124830	416100	208050	624150	312075	187245	499320	124830
33	IF2200099400	7/6/2022	B Shift	5	27		1RESDW	96600	48300	144900	50000	22000	72000	46600	26300	48.24%	54.45%	72900	96600	48300	144900	50000	22000	72000	72900
34	IF2200103661	7/14/2022	A Shift	5	27		1RESDW	30000	20000	50000	20000	15000	35000	10000	5000	33.33%	25.00%	15000	57900	28950	86850	38600	21713	60313	26538
35	IF2200099809	7/7/2022	C Shift	5	27		1DBLRESW	200500	100250	300750	40000	5000	45000	160500	95250	80.05%	95.01%	255750	200500	100250	300750	40000	5000	45000	255750
36	IF2200101158	7/10/2022	B Shift	5	27		1RESDW	41400	0	41400	41400	0	41400	0	0	0.00%	0.00%	0	41400	0	41400	41400	0	41400	0
37	IF2200103153	7/13/2022	C Shift	2	28		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
38	IF2200095726	7/1/2022	B Shift	5	29		1BUILDW	406300	203150	609450	10000	1000	11000	396300	202150	97.54%	99.51%	598450		0	0	0	0	0	0
39	IF2200099754	7/7/2022	C Shift	5	29		1RESDW	103500	55000	158500	25000	7500	32500	78500	47500	75.85%	86.36%	126000	103500	51750	155250	25000	7057	32057	123193
40	IF2200097575	7/4/2022	C Shift	5	29		1RESDW	61600	31000	92600	15000	5000	20000	46600	26000	75.65%	83.87%	72600	61600	30800	92400	15000	4968	19968	72432
41	IF2200100515	7/8/2022	A Shift	5	29		1RESDW	19900	15000	34900	19900	15000	34900	0	0	0.00%	0.00%	0	19900	15000	34900	19900	15000	34900	0
42	IF2200105149	7/17/2022	C Shift	1	30		1RESDW	138400	69200	207600	10000	5000	15000	128400	64200	92.77%	92.77%	192600	138400	69200	207600	10000	5000	15000	192600
43	IF2200097189	7/3/2022	B Shift	1	30		1RESDW	94800	47400	142200	18960	9480	28440	75840	37920	80.00%	80.00%	113760	94800	47400	142200	18960	9480	28440	113760
44	IF2200108516	7/23/2022	C Shift	1	31		1RESDW	103400	51700	155100	5000	0	5000	98400	51700	95.16%	100.00%	150100	103400	51700	155100	5000	0	5000	150100
45	IF2200106144	7/18/2022	B Shift	1	31		1DBLRESW	29500	0	29500	10000	0	10000	19500	0	66.10%	0.00%	19500	29500	0	29500	10000	0	10000	19500
46	IF2200112192	7/29/2022	A Shift	6	34		1BUILDW	0	0	0	0	0	0	0	0	0.00%	0.00%	0	0	0	0	0	0	0	0
47	IF2200099904	7/7/2022	C Shift	6	34		1RESDW	301000	150500	451500	15050	7525	22575	285950	142975	95.00%	95.00%	428925	301000	150500	451500	15050	7525	22575	428925
48	IF2200110736	7/27/2022	A Shift	6	35		1APARTW	6162200	10000	6172200	15000	2000	17000	6147200	8000	99.76%	80.00%	6155200	6162200	10000	6172200	15000	2000	17000	6155200
49	IF2200098222	7/5/2022	C Shift	4	41		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
50	IF2200097613	7/4/2022	C Shift	4	41		1RESDW	338600	169300	507900	338600	169300	507900	0	0	0.00%	0.00%	0	338600	169300	507900	338600	169300	507900	0
51	IF2200108778	7/23/2022	A Shift	4	42		1RESDW	36600	500	37100	31110	500	31610	5490	0	15.00%	0.00%	5490	37100	500	37600	31535	500	32035	5565
52	IF2200101938	7/11/2022	A Shift	4	44		1APARTW	1104200	100000	1204200	80000	30000	110000	1024200	70000	92.75%	70.00%	1094200		0	0	0	0	0	0
53	IF2200098184	7/5/2022	C Shift	4	44		1RESDW	147900	73900	221800	7395	3697	11092	140505	70203	95.00%	95.00%	210708	147900	73950	221850	7395	3700	11095	210755
54	IF2200098210	7/5/2022	C Shift	4	44		1RESDW	147900	73900	221800	73900	51700	125600	74000	22200	50.03%	30.04%	96200	152400	76200	228600	76148	53309	129458	99142
55	IF2200102046	7/11/2022	A Shift	4	45		1APARTW	456700	12000	468700	150000	10000	160000	306700	2000	67.16%	16.67%	308700	456700	12000	468700	150000	10000	160000	308700
56	IF2200098206	7/5/2022	C Shift	6	53		1APARTW	1298000	649000	1947000	2000	0	2000	1296000	649000	99.85%	100.00%	1945000	1298000	649000	1947000	2000	0	2000	1945000
57	IF2200096815	7/3/2022	A Shift	6	53		1RESDW	296200	148500	444700	15000	3000	18000	281200	145500	94.94%	97.98%	426700	296200	148100	444300	15000	2992	17992	426308
58	IF2200096874	7/3/2022	A Shift	6	53		1RESDW	151300	75000	226300	151300	65000	216300	0	10000	0.00%	13.33%	10000	151300	75650	226950	151300	65563	216863	10087
59	IF2200097909	7/4/2022	C Shift	5	56		1RESDW	91700	47000	138700	5000	500	5500	86700	46500	94.55%	98.94%	133200	91700	45850	137550	5000	488	5488	132062
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