GunshotLocalizer.xlsx

	B	C	D	E	F
1	🔫 ACOUSTIC GUNSHOT LOCALIZER
2	Enter TDOA values from the web app · Set sensor positions · Run Solver on the Results sheet
3
4	ENVIRONMENTAL CONDITIONS
5	Parameter	Value	Unit	Notes
6	Air Temperature	20	°C	Range –40 to +60
7	Relative Humidity	50	%	0 – 100
8	Wind Speed	0	m/s	0 = calm
9	Wind Direction	0	°	0 = from North
10	Altitude (ASL)	0	m	Above sea level
11
12	COMPUTED SPEED OF SOUND
13	Speed of sound c	344.04	m/s
14
15	SENSOR POSITIONS (metres relative to Sensor A at origin 0, 0)
16	Sensor	X (m east of A)	Y (m north of A)	Z (m above A)	Loaded?
17	Sensor A (origin / reference)	0.00	0.00	0.00	← fixed origin
18	Sensor B	50.00	0.00	0.00	YES
19	Sensor C	50.00	50.00	0.00	YES
20	Sensor D	0.00	50.00	0.00	YES
21	Sensor E	25.00	25.00	0.00	YES
22
23	TIME DIFFERENCE OF ARRIVAL (TDOA) — paste from web app
24	Sensor Pair	Δt (milliseconds)	Δt (seconds)	Dist diff (m)
25	A → B	0.146	0.000146	0.050
26	A → C	0.292	0.000292	0.100
27	A → D	0.146	0.000146	0.050
28	A → E	0.000	0.000000	0.000
29
30	HOW TO USE THIS FILE
31	1. Use the Acoustic Gunshot Localizer web app to upload your WAV files.
32	2. Copy the TDOA values (milliseconds) from the web app into cells C25:C28 above.
33	3. Enter your sensor X/Y positions (metres) in cells C17:D21.
34	4. Adjust temperature, humidity, altitude if needed.
35	5. Go to the Results sheet — the estimated position updates automatically.
36	6. To refine with Solver: Data → Solver → set objective = Results!B18 (min) → OK.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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