Every cat is different with how Lantus works on them. On some, it can last longer and you can get some overlap, which is great for keeping #'s down. You'll start to learn how Lantus works on your Max.
On your vet, if he's a good vet and you are happy with him and he's willing to work with you, that's great, really. I have a great vet that I've been seeing for years and years. I've stuck with him. He's not as knowledgeable on feline diabetes, but he's still a great vet and willing to work with and listen to me... most important. In fact, he recently added a vet to his practice more versed in diabetes and recommended I see her too. You want to use all the tools and knowledge at your disposal, and you're doing that by finding this site, starting a spreadsheet, and working closely with your vet. That really is a great start.
On testing, I totally and completely sympathize. My Max, especially at first, was a bear to test, a real bear. He's terrible to give any kind of medication to. For the longest time, I couldn't test him on my own. I needed someone to help hold him still, so I could have my hands free to test. He just would not sit still. For me, treats have been key. My Max loves, loves the low carb treats (freeze dried chicken). I am now finally able to test him on my own, which, in the beginning I really, really did not think I would ever be able to do. It took a lot of time and patience. Now, if I shake the treat container and show Max the test tools (don't want to trick him on what is up), he will always still come even knowing what's involved. He'll still be wiggly sometimes but doable most of the time. Just do what you can do and be patient. I specifically joined the "relaxed" group because I'm not able to test as much as some. You do what you can.