I don’t have the full spreadsheet filled in.
That's fine. The more recent data is what is important.
He definitely needs food more than just at shot time. He just got 1/4 can but now with my other small meals he’s actually getting 1/2 can after his shot. Is that too much?
If Lenny is not gaining a lot of weight, then it's not too much food. As long as he is at his "ideal" weight, neither too heavy or too light, he's ok.
Sometimes, a cat can develop a bit of insulin resistance, if the amount of the insulin has been held at a particular dose for too long. Lenny has been at the 1.25/1.5/1.75 unit doses back and forth over a long period of time now, months.
He usually ranged in the mid 300s at shot time.
The pre-shot tests are only part of the picture. You need to take those pre-shot tests, in combination with the lows or nadirs, into consideration when adjusting the dose. It's mainly the nadir tests, those lows, that determine the dose changes. Lenny may be "bouncing" a bit, from those blues he has been getting. It usually takes 3 to 6 12 hour cycles for a cat to clear a bounce. His body isn't used to those lower numbers, so a self protection mechanism kicks in, to bring the BG levels back to what it considers a safer level.
Blacks almost ALWAYS mean bouncing, from a low number somewhere. Those lows may only be in the low blues or high greens, or even the yellow ranges, but they still cause the self protection mechanism in a cat's body to kick into action.
You really do want to see Lenny in the greens and blues at nadir. More of the yellow range at pre-shot test time would be good too. How to get there is the question.
You've followed the suggestion to front load the food for Lenny. But what we don't know, is what the BG levels are earlier in the cycle. Would it be possible to test Lenny BEFORE the feedings at +2 and/or +3, to see what the BG is? Please? Try to alternate, but I think if we could see some +3 tests, with your new feeding schedule, that will give us another clue to what is going on.
More importantly, how is Lenny feeling? Are all 5 P's (peeing, pooping, purring, preening, playing) and his appetite doing well?
I'd give it a few days, for the bounce to clear, before you increase the dose again. But I do think that ultimately Lenny will need a dose increase.
Have you planned a curve, testing every 2 hours from one pre-shot test to the next pre-shot test for this weekend? Either Saturday or Sunday?