>>4855404
>What can I do for you?
Ty anon. I'm just giving my ideas here, I don't want it to sound like I'm ordering from a menu thinking you can just make appear whatever we want. I know we're all volunteers, whatever you want to do is appreciated.
We may need to develop the spreadsheets themselves moar to get specific enough for you to start on template/display macro's, and Anon's Marker theory is still developing, so I'm not sure what we'd want to display yet here but here's what I'm thinking:
Final product for template/display:
Essentially, Side-by-sides, Q proofs
Two choices of selective input:
A. Corroborating/identical data, selected sort field
1) Sorting the twat & drop sheets by date, minute, or keyword/person-of-interest etc. incl Anon's "Markers," (not delta's)
2) One sheet (either twats or drops) returns matches in same selected sort criteria from other sheet
3) User manually selects 2 or more twats/drops to be displayed on the side-by-side macro page
4) Macro displays both with the selected corroborating data highlighted in some way and arrows pointing to both connecting to a text box anon can enter brief explanation/narration
5) Text box up top for Anon to enter title
6) Ideally caps of the drops twats would be nice, but anons might have to manually enter those – unless we could eventually build a bank of those into the spreadsheets too.
B. Deltas in minutes btwn a twat and drop
1) Sorting the twat & drop sheets either by date/minute, or date/min AND keyword/person-of-interest etc. incl Anon's non-delta "Markers"
2) One sheet (either twats or drops) returns matches on the same day from other sheet
3) In additional column, delta in timestamp minutes is displayed
4) User manually selects 2 or more twats/drops to be displayed on the side-by-side macro page
5) Macro displays both with the timestamp minutes highlighted in some way and arrows pointing to both connecting to a display of the delta (text box where anon can enter brief explanation/narration needed?)
7) Text box up top for Anon to enter title
8) Ideally caps of the drops twats would be nice, but anons might have to manually enter those – unless we could eventually build a bank of those into the spreadsheets too.