DigDB site

how do you want the records formatted?

    email,  remaining half-year units

yes?

Yes.  But of course you should round up.

Here is the records: https://docs.google.com/spreadsheets/d/1-_TP-Kp-me_Yc8vN9hxXqvd5AIjWRM5RrEQz16Pqc2w/edit?usp=sharing

I had an additional column "Purchase Date" there. Can you process the data this way?

I think when paypal sends you the notification, you get the same data, e.g. purchase date, email, and units purchased. so you can process the history the same way?

the only problem I forsee, is that we lost all the records when the initial activation date is. so for that, how about we just apply a simple logic, the activation date is just the purchase date?

The easiest for me is to just get email and units.  With excel, should be able subtract the numbers of units you think they used up based on their purchase date.  So the database will start only with account records, no licenses.  When the user uses DigDB in Excel, it will contact the server which will then subtract from units to create licenses.

I don't know anything about spreadsheets, so the best for me is to get the data as text.  This would be a good format:

"fschmidt@gmail.com", 10
"bob@gmail.com", 22