You may be making it way too complicated for what you're try to accomplish. Thinkorswims's platform is free and I trust their calculations since they were developed by some really smart guys. If you're building out your own Excel sheet for an API the best route is to simply decide what calculation method you want to use (there are a bazillion ways to calculate an options price) and plug it in directly for your calculations.