The 'standard' Warre hive is a top bar hive, of course, as are it's variants - such as the Russian Alpine Hive, of which I have a couple. Would you want to include these ? But - how then can the size of each hive be calculated, when they are expandable ?
All of my hives (both vertical and horizontal, fixed-size and expandable) can take frames and/or top bars - and currently several of them do indeed have a mix of top bars and frames. Again - would you want to include these ?
Not wishing to labour the point much further, ALL hives may be run as top bar hives - even the Langstroth (which I don't have ...).
Perhaps you may need to define the inclusive limits of your spreadsheet ?
LJ
BTW - you cannot calculate hive volume from external measurements, as wall thicknesses chosen by constructors will invariably be different.