You started at 1 unit according to your spreadsheet.
So let's check that starting dose.
1) How much does he weigh (8 lb 13 oz) and what is his ideal weight?
2) Which is lower?
3) Convert the lower to kilograms (pounds / 2.2)
4) multiply by 0.25, then round down to the nearest half unit.
Is that higher or lower than 1.0?
Next, review dose increases.
1) Did you stay with a given dose for 10 shots on 1 unit and 6 shots on later dose levels?
- no, 1 unit was given 1 day, then increased to 1.5 units by the next day.
2) Were the increases 0.25 or larger? Larger
3) Were the increases based on nadir test values, ie the lowest test value between shots?
- appears to have been increased without knowledge of nadirs, possibly based on pre-shot levels, which doesn't assess how low the insulin is dropping the glucose between shots.