Simple mathematical model of an epidemic

	A	B	C	D	E	F	G
1	Simple mathematical model of an epidemic
2
3		Model parameters		Susceptible	Infectious	Recovered	Total
4	Population size	10,000.00
5	Average number of contacts	13.00		Susceptible	Infectious	Recovered	Total
6	Risk of transmission	0.03	1	9,999.00	1	0	10,000.00
7	Recovery rate	0.15	2	9,998.61	1.239961	0.15	10,000.00
8	R0	2.60	3	9,998.13	1.537484424	0.33599415	10,000.00
9	Final number of susceptible	854.35	4	9,997.53	1.906368348	0.5666168135	10,000.00
10	Final number of recovered	9,138.80	5	9,996.78	2.363712889	0.8525720657	10,000.00
11	Peak infection total	2,607.79	6	9,995.86	2.93070749	1.207128999	10,000.00
12	Date of peak	45.00	7	9,994.72	3.633604343	1.646735123	10,000.00
13			8	9,993.30	4.504921105	2.191775774	10,000.00
14			9	9,991.55	5.584925615	2.86751394	10,000.00
15			10	9,989.37	6.923466718	3.705252782	10,000.00
16			11	9,986.67	8.582228815	4.74377279	10,000.00
17			12	9,983.33	10.63750343	6.031107112	10,000.00
18			13	9,979.19	13.18358906	7.626732626	10,000.00
19			14	9,974.06	16.33695061	9.604270985	10,000.00
20			15	9,967.70	20.24129053	12.05481358	10,000.00
21			16	9,959.84	25.07370538	15.09100716	10,000.00
22			17	9,950.10	31.05211863	18.85206296	10,000.00
23			18	9,938.05	38.4441915	23.50988076	10,000.00
24			19	9,923.15	47.57790827	29.27650948	10,000.00
25			20	9,904.73	58.85399993	36.41319572	10,000.00
26			21	9,882.00	72.76029255	45.24129571	10,000.00
27			22	9,853.96	89.88791538	56.15533959	10,000.00
28			23	9,819.41	110.9490417	69.6385269	10,000.00
29			24	9,776.92	136.795407	86.28088315	10,000.00
30			25	9,724.76	168.436188	106.8001942	10,000.00
31			26	9,660.88	207.0528422	132.0656224	10,000.00
32			27	9,582.87	254.007122	163.1235487	10,000.00
33			28	9,487.94	310.8366191	201.224617	10,000.00
34			29	9,372.92	379.2298797	247.8501099	10,000.00
35			30	9,234.29	460.9705595	304.7345918	10,000.00
36			31	9,068.28	557.83776	373.8801758	10,000.00
37			32	8,871.00	671.448672	457.5558398	10,000.00
38			33	8,638.70	803.0316787	558.2731406	10,000.00
39			34	8,368.15	953.1256167	678.7278924	10,000.00
40			35	8,057.09	1121.216671	821.6967349	10,000.00
41			36	7,704.77	1305.350023	989.8792355	10,000.00
42			37	7,312.53	1501.787003	1185.681739	10,000.00
43			38	6,884.24	1704.811664	1410.949789	10,000.00
44			39	6,426.52	1906.806792	1666.671539	10,000.00
45			40	5,948.61	2098.697044	1952.692558	10,000.00
46			41	5,461.72	2270.781399	2267.497114	10,000.00
47			42	4,978.03	2413.856836	2608.114324	10,000.00
48			43	4,509.40	2520.412019	2970.19285	10,000.00
49			44	4,066.14	2585.60603	3348.254653	10,000.00
50			45	3,656.12	2607.789065	3736.095557	10,000.00
51			46	3,284.27	2588.461436	4127.263917	10,000.00
52			47	2,952.73	2531.739733	4515.533132	10,000.00
53			48	2,661.18	2443.524701	4895.294092	10,000.00
54			49	2,407.58	2330.599814	5261.822797	10,000.00
55			50	2,188.74	2199.842719	5611.412769	10,000.00
56			51	2,000.96	2057.647165	5941.389177	10,000.00
57			52	1,840.39	1909.573901	6250.036252	10,000.00
58			53	1,703.33	1760.197872	6536.472337	10,000.00
59			54	1,586.40	1613.097893	6800.502018	10,000.00
60			55	1,486.60	1470.934936	7042.466702	10,000.00
61			56	1,401.32	1335.575585	7263.106942	10,000.00
62			57	1,328.33	1208.230298	7463.44328	10,000.00
63			58	1,265.73	1089.587798	7644.677824	10,000.00
64			59	1,211.95	979.9356489	7808.115994	10,000.00
65			60	1,165.63	879.2629261	7955.106341	10,000.00
66			61	1,125.66	787.3444269	8086.99578	10,000.00
67			62	1,091.09	703.8077595	8205.097444	10,000.00
68			63	1,061.15	628.1855139	8310.668608	10,000.00
69			64	1,035.15	559.9549491	8404.896435	10,000.00
70			65	1,012.54	498.5675338	8488.889678	10,000.00
71			66	992.85	443.4704212	8563.674808	10,000.00
72			67	975.68	394.1216252	8630.195371	10,000.00
73			68	960.69	350.0003545	8689.313615	10,000.00
74			69	947.57	310.6136789	8741.813668	10,000.00
75			70	936.09	275.5004592	8788.40572	10,000.00
76			71	926.04	244.2332671	8829.730789	10,000.00
77			72	917.22	216.4188596	8866.365779	10,000.00
78			73	909.47	191.6976361	8898.828608	10,000.00
79			74	902.67	169.7424055	8927.583253	10,000.00
80			75	896.70	150.2567071	8953.044614	10,000.00
81			76	891.44	132.9728657	8975.58312	10,000.00
82			77	886.82	117.6499126	8995.52905	10,000.00
83			78	882.75	104.071468	9013.176537	10,000.00
84			79	879.17	92.04365032	9028.787257	10,000.00
85			80	876.01	81.39305815	9042.593804	10,000.00
86			81	873.23	71.96485356	9054.802763	10,000.00
87			82	870.78	63.62096511	9065.597491	10,000.00
88			83	868.62	56.23841887	9075.140636	10,000.00
89			84	866.72	49.70780092	9083.576399	10,000.00
90			85	865.04	43.9318497	9091.032569	10,000.00
91			86	863.55	38.82417416	9097.622346	10,000.00
92			87	862.25	34.30809131	9103.445972	10,000.00
93			88	861.09	30.31557609	9108.592186	10,000.00
94			89	860.07	26.78631546	9113.139523	10,000.00
95			90	859.18	23.66685864	9117.15747	10,000.00
96			91	858.38	20.90985542	9120.707499	10,000.00
97			92	857.68	18.47337473	9123.843977	10,000.00
98			93	857.06	16.32029595	9126.614983	10,000.00
99			94	856.52	14.417766	9129.063028	10,000.00
100			95	856.04	12.73671575	9131.225692	10,000.00