Charlie Gallant Spreadsheet

	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
1	Diagnosed:			12/22/2020			Dosing Method (SLGS or TR):					SLGS
2	Current Insulin:			Lantis			Meter:					One Touch Human Meter
3	BG>500				BG 400 - 499				BG 300 - 399				BG 200 - 299				BG 100 - 199				BG 50 - 99				BG < 50			Remarks
4	Date	AMPS	U	+ 1	+ 2	+ 3	+ 4	+ 5	+ 6	+ 7	+ 8	+ 9	+ 10	+11	PMPS	U	+ 1	+ 2	+ 3	+ 4	+ 5	+ 6	+ 7	+ 8	+ 9	+ 10	+11	Remarks
5	12/29/2020	241	1.00	0	0	234	0	0	0	0	0	0	0	0	347	1.00	0	0	0	0	0	0	0	0	0	0	0
6	12/30/2020	394	1.00	0	0	0	0	0	0	0	0	0	0	0	324	1.00	0	0	0	0	0	0	0	0	0	0	0
7	12/31/2020	270	1.00	0	0	0	0	0	0	0	0	0	0	0	108@PMPS, 106@0.20, 115@0.35	0.50	115	146	0	0	0	0	0	0	0	0	0	Gave 0.5 units in PM because his numbers were only 108
8	01/01/2021	261	1.00	0	0	0	0	0	0	0	0	0	0	0	275	1.00	0	0	0	0	0	0	0	0	0	0	0
9	01/02/2021	292	1.00	0	0	0	0	0	0	0	0	0	0	0	198	1.00	0	0	0	0	0	0	0	0	0	0	0
10	01/03/2021	351	1.00	0	0	0	0	0	0	0	0	0	0	0	238	1.00	0	0	0	0	0	0	0	0	0	0	0
11	01/04/2021	385	1.00	0	0	0	0	0	0	0	0	0	0	0	351	1.00	0	0	0	0	0	0	0	0	0	0	0
12	01/05/2021	274	1.50	0	0	189	0	0	0	0	67	83	0	0	310	1.00	0	0	0	0	0	0	0	0	0	0	0	Gave 1.5 units to help with his high numbers but he went to low at a 3.7
13	01/06/2021	338	1.00	0	0	0	0	0	0	0	0	0	0	0	185	1.00	0	0	0	0	0	0	0	0	0	0	0
14	01/07/2021	317	1.00	0	0	0	0	0	0	0	0	0	0	0	148	1.00	0	0	0	0	0	0	0	0	0	0	0
15	01/08/2021	275	1.00	0	221	0	139	0	70	0	83	0	0	115	121	0.50	135	0	157	0	0	0	0	0	0	0	0	Gave 1 Unit in AM and 0.5 in PM
16	01/09/2021	371	0.75	0	0	0	0	0	0	0	0	0	0	0	202	0.75	0	0	0	0	0	0	0	0	0	0	0	Gave 0.75 Unit in AM and 0.75Unit in PM
17	01/10/2021	198	0.75	0	0	0	0	0	0	0	0	0	0	0	112	0.50	0	0	0	88	0	97	0	104	0	0	0	Gave 0.75 in AM and 0.5 in PM went below 90 at +4 in PM
18	01/11/2021	117	0.25	126	0	0	0	97	0	0	0	0	0	94	104	0.25	0	0	0	0	0	0	0	0	0	0	0	Gave 0.25 in AM because he went below 90 the night before
19	01/12/2021	74	NS	68	0	0	70	0	0	0	94	0	130	0	139	0.25	137	139	92	0	79	0	0	0	0	0	126
20	01/13/2021	131	0.25	0	0	0	0	0	101	0	0	0	0	0	121	0.25	0	117	0	0	0	0	0	0	0	0	81
21	01/14/2021	77	0.25	0	74	0	65	0	0	0	0	88	0	0	92	0.25	0	0	0	0	0	0	0	0	0	0	68
22	01/15/2021	61	0.25	0	47@+2,61@+2.25,59@+2.5	65	56	0	76	0	94	0	0	0	83	0.10	0	0	83	0	0	70	0	0	0	0	0	AM +2(47)fed 1tsp HC +2.25(61)+2.5(59) 1tsp HC
23	01/16/2021	85	0.10	0	0		0	0	0	67	0	0	0	0	65	0.10	0	77	0	0	0	0	0	0	0	0	0
24	01/17/2021	76	0.10	0	0	0	0	0	0	0	0	0	59	0	72	0.10	0	0	0	0	0	0	0	79	0	0	0
25	01/18/2021	59	NS	0	0	77	0	77	0	0	0	0	0	0	74	0.10	0	0	0	0	0	0	0	0	0	0	0
26	01/19/2021	74	0.10	0	0	0	0	0	0	65	0	0	0	0	76	0.10	0	0	0	61	0	0	0	0	0	0	0
27	01/20/2021	70	0.10	0	0	0	0	72	0	0	0	0	0	0	61	0.10	0	0	65	0	0	0	0	0	0	0	0
28	01/21/2021	52	NS	86	0	0	72	0	0	0	0	0	0	0	65	1 drop	0	0	0	0	0	0	0	0	0	77	0
29	01/22/2021	61	possible fur shot	0	0	0	0	0	0	0	0	0	0	67	70	1 drop	0	0	0	0	0	0	0	0	0	0	0
30	01/23/2021	61	1 drop	0	0	0	0	63	0	0	0	0	0	0	65	1 drop	0	0	77	0	0		0	0	0	0	65
31	01/24/2021	58	1 drop	0	0	0	0	0	0	0	0	77	0	0	59	1 drop	0	0	0	0	0	0	76	0	0	0	0
32	01/25/2021	59	1 drop	0	0	0	0	0	0	0	63	0	0	0	58	1 drop	0	0	0	0	0	74	0	0	0	0	0
33	01/26/2021	50 @0.25(54)	1 drop	@0.75 (76)	56	0	52		43@0.50(70) @0.75(70)	0	58	0	58	0	58	OTJ	0	0	0	0	0	0	0	0	0	0	0
34	01/27/2021	79	OTJ trial		0	0	0		0		0	0	0	0	54	OTJ trial	0	0	0	0	0	0	0	0	0	0	0
35	01/28/2021	63	OTJ day2	0	0	0	0	0	0	0	0	0	0	0	50	OTJ trial Day 2		0	0	0	0	0	0	0	0	0	0
36	01/29/2021	56	OTJ day3	0	0	0	0	0	0	0	0	0	0	0	70	OTJ triql day3	0	0	0	0	0	0	0	0	0	0	0
37	01/30/2021	58	OTJ day 4	0	0	0	0	0	0	0	0	0	0	0	65	OTJ trial Day4	0	0	0	0	0	0	0	0	0	0	0
38	01/31/2021	74	OTJ trial Day5	0	0	0	0	0	0	0	0	0	0	0	74	OTJ trial Day5	0	0	0	0	0	0	0	0	0	0	0
39	02/01/2021	58	OTJ trial Day 6	0	0	0	0	0	0	0	0	0	0	0	74	OTJ trial Day 6	0	0	0	0	0	0	0	0	0	0	0
40	02/02/2021	67	OTJ trial Day 7	0	0	0	0	0	0	0	0	0	0	0	52	OTJ trial Day 7	0	65	0	0	0	0	0	0	0	0	0
41	02/03/2021	59	OTJ trial Day 8	0	0	0	0	0	0	0	0	0	0	0	65	OTJ trial Day8	0	0	0	0	0	0	0	0	0	0	0
42	02/04/2021	61	OTJ trial Day 9	0	0	0	0	0	0	0	0	0	0	0	65	OTJ trial Day 9	0	0	0	0	0	0	0	0	0	0	0
43	02/05/2021	59	OTJ trial Day 10	0	0	0	0	0	0	0	0	0	0	0	70	OTJ trial Day 10	0	0	0	0	0	0	0	0	0	0	0
44	02/06/2021	70	OTJ trial Day 11	0	0	0	0	0	0	0	0	0	0	0	61	OTJ trial Day 11	0	0	0	0	0	0	0	0	0	0	0
45	02/07/2021	59	OTJ trial Dat 12	0	0	0	0	0	0	0	0	0	0	0	81	OTJ trial Day 12	0	0	0	0	0	0	0	0	0	0	0
46	02/08/2021	58	OTJ trial Day 13	0	0	0	0	0	0	0	0	0	0	0	59	OTJ trial Day 13	0	0	0	0	0	0	0	0	0	0	0
47	02/09/2021	77	OTJ trial Day 14	0	0	0	0	0	0	0	0	0	0	0	59	OTJ trial Day 14	0	0	0	0	0	0	0	0	0	0	0
48	02/10/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	65	0	0	0	0	0	0	0	0	0
49	02/11/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	68	0	0	0	0	0	0
50	02/12/2021	0		0	0	0	0	0	0	0	0	65	0	0	0		0	0	0	0	0	0	0	0	0	0	0
51	02/13/2021	0		0	0	61	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
52	02/14/2021	0		0	0	0	0	0	0	0	0	0	0	0	79		0	0	0	0	0	0	0	0	0	0	0
53	02/15/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		67	0	0	0	0	0	0	0	0	0	0
54	02/16/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	70	0	0	0	0	0	0	0	0	0
55	02/17/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
56	02/18/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
57	02/19/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
58	02/20/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
59	02/21/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
60	02/22/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
61	02/23/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
62	02/24/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
63	02/25/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
64	02/26/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
65	02/27/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
66	02/28/2021	0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
67		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
68		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
69		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
70		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
71		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
72		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
73		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
74		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
75		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
76		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
77		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
78		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
79		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
80		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
81		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
82		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
83		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
84		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
85		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
86		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
87		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
88		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
89		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
90		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
91		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
92		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
93		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
94		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
95		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
96		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
97		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
98		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
99		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
100		0		0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0