Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Wrongly assuming you might even be less familiar with databases (which I had to "respect" for some time, but didn't like myself), I made an example for the running subtotal regarding the hints I gave in my comment above.

The result does neither emphasize "prettysheeting" nor strict closeness to the structure shown in the images attached to the question. My concern was to exemplfy an idea how to do such things with spreadsheets without disregarding the most basic principles of databasing.

As I very rarely designed a (even extremely simple) database myself, I may not be the best advisor in this case. Since the mentioned example once was made, however, I now attach it here with due modesty.