Battery estimation sheet: Lobaro Wireless M-Bus Gateway V3

	A	B	C	D	E	G	H	I	J	K	L	M
1	Please save your own copy of this sheet!
2	File -> Make a copy / Datei -> Kopie erstellen or Download as e.g. EXCEL file
3	Version: 1.6.0 - 2024-05-07
4
5	Disclaimer: Estimations without any warranties!	Input Fields	This tool is based on a model of measured values and is not showing the actual measurement. The result is therefore an estimate of the expected value. It is meant for evaluation purposes only and will not give the exact numbers in every use case!
6	Battery life-time estimation for Lobaro "LOB-GW-HYB-WMBUS \| Wireless M-Bus Gateway V3" devices with SAFT LSH-20 D-cell battery
7	LTE network signal quality must be at least "Cell Edge => 1/4" -> see: https://doc.lobaro.com/x/UgIJAQ
8
9	NB-IoT signal strength / coverage	Medium	Depends on installation location of the gateway. If unknown worst-case ("Bad") should be choosen.							Bad = 1/4	Medium = 2/4	Good = 3/4+
10
11		Usage Scenario A				Usage Scenario B (comparison)
12		Usage Scenario A				Usage Scenario B (comparison)
13	Count Wake / wMBUS Listen /NB-IoT TX cycles per day	2.00	cycles per day	60	x per month	0.067	cycles per day	2	x per month
14	Total wMBUS listen time each interval (e.g. "cmodeDurSec")	31	seconds			1800	seconds
15	Count different whitelist meters per NB-IoT upload cycle	1	wMBUS meters			250	wMBUS meters
16
17
18	Charge daily status msg (worst case)	0.400	mAh per day			0.400	mAh per day	146.000		1.44	C
19	Charge wmbus listen	0.105	mAh per day			0.204	mAh per day	38.471		0.37944	C
20	Charge LTE-M / NB-IoT uploads	0.320	mAh per day			1.007	mAh per day	116.800		1.152	C
21	Charge processing (3s per upload pase and meter, 3mA)	0.005	mAh per day			0.042	mAh per day	1.825		0.018	C
22	Charge for Sleep (10uA)	0.240	mAh per day			0.240	mAh per day	87.600		0.864	C
23	Sum	1.07	mAh per day			1.89	mAh per day			3.85344	C
24
25	Resulting battery life-time estimation with additional 10% safety margin	7651.3	Days			4328.0	Days
26		20.96	Years			11.86	Years
27		Note: Battery runtimes over 10 years cannot be reliably modelled with this estimator sheet!
28
29
30
31
32
33
34
35
36
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