Static Damage Reduction vs. OSR Damage Rolls

Under a Reddit post concerning damage reduction in OSR systems a commenter proposed the idea that maximum damage rolls could bypass armour, ensuring that even low damage weapons (such as daggers) wouldn't be rendered completely inefficient against armoured foes. The nerd I am, I made a spreadsheet to calculate the modified average damage outputs (a perfect pastime for a lazy holiday): column A shows the die size, columns B-M the reduced damage output corresponding to the roll, and column N the average. The first sheet assumes armour may completely negata a hit (cf. zero damage), while on the second a single point of damage always goes through. These rules are summarised in column P on both sheets.