Okay, so I couldn't quite come up with the most cost efficient packs for my SD and HD boxes by just looking at the Base Pack, Addon and a-la-carte prices in the website.
So I went ahead and created an extensive excel worksheet, consisting of all the channels that I wanted, and the different base packs and addon/a-la-carte combinations that could be used to get those channels.
I am sharing the excel sheet here. Feel free to download it, and edit/update it with your own required channels. You can insert/delete rows to suit your need.
I have used 'auto filters' at the topmost row. This can be used to view channels of specific type/add-ons/price, etc.,.
I have also used simple formulas (sum and product) in the excel sheet for calculating the addons+base pack total, GST and then Grand Total. This calculation could be found at the bottom most part of every DPO section of the sheets.
So hopefully, no matter how many rows you add/delete to the sheet, the calculation should still stay correct. Just make sure, that whenever you update an add-on to the sheet, that you are updating the price for ONLY one of its channels (meaning, update the price in only one row for each add-on). Update the price as 0 (zero) for the remaining channels belonging to that add-on. This way, an add-on's price won't be considered more than once for the final calculation.
Below are the packs that were most cost effective for me. Let me know if I could save money anywhere
SD Box:
Base Pack
Tamil DPO 2
Addon Packs
Mavis Satcom Bouquet 1 SD/HD
Star English Premium Pack
Sony Happy India English 12
Zee Prime Pack English SD
Discovery SD Bouquet 5 SD Basic Infotainment (Tamil) Pack
a-la-carte Channel
Travel XP Tamil
HD Box:
Base Pack
HD Tamil DPO 1
Addon Packs
Mavis Satcom Bouquet 1 SD/HD
Turner HD
Star English Premium Pack HD
Discovery HD Bouquet 3 Infotainment High Definition Pack
Sony Happy India English HD 20
Disney HD Bouquet
Zee Prime Pack English HD
Bennet Coleman Bouquet-3
a-la-carte Channels
Zee Tamil
Travel XP Tamil
Discovery Tamil
History TV 18 HD
Travel XP HD
VH1 HD
HBO SD Channel
Excel Sheet:
Firefox Send