I looked at your spreadsheet and here are the immediate problems that I see.
1) you changed the lantus dose from 1 to 2 units - based on only 1 test. This is not how to change doses. You need to get mid-cycle tests in (yes I understand you are having testing issues), but the only way to know how the insulin is working is to get mid-cycle tests - Lantus dose changes is based on the nadir (or lowest point in the cycle), not just one test at the end of the cycle.
2) When changing doses, NEVER increase by full units. We recommend changing doses by 0.25 or 0.50 units at a time. NEVER by 1 unit at a time.
3) Please read the lantus protocol and other starred information on the lantus forum:
viewtopic.php?f=9&t=1581
It is important that you understand how Lantus works and the proper way to handle it, dosing, etc.
4) While in the beginning of this process, please feed the cat as much as he wants. He is not processing food correctly and therefore, needs more than normal in order to maintain. As he settles into to the insulin and dose, the need for food may diminish to what is considered normal. But for now, in order to keep him safe, please feed him.
Yes, you can leave canned food out for 12+hours at a time. Because he has trace ketones, add a lot of water to the food (ie. one can of water to one can of food). Ketones need to be flushed out the body and if you can get him to drink lots of water, this will help to eliminate the need for an ER vist.
Dry food - honestly - forget it even exists. If he never eats dry food again, that is best for him and any cat.
5) Speaking of ketones - please read this about ketones and DKA -
http://petdiabetes.wikia.com/wiki/Ketones
It is important to continue giving insulins when ketones are present, so as not to blow up into DKA.
6) You say you are struggling with home testing. Can you tell us what you are/are not doing and maybe we can help make it easier for you.
I see you are in Wilmington. Venita (from DCIN ) is local to you and if you need in person assistance, she may be able to help. WE can alert her if you like.