This thread was created for two interlinked purposes:

1) for excelfags to try to collaboratively develop a spreadsheet of POTUS's twats and Q drops sortable by time, minute markers, delta markers, and other subject-content markers in the body of the twats/drops themselves. Input and ideas welcome.

and 2) To further develop a system to address Q's asking us to build the map and use his "markers" in the map

Raw data POTUS twats

Nov. 5, 2016 to Jan. 21, 2019

https://docs.google.com/spreadsheets/d/1vQMvZyhM5n1lf-ACCKErJTOA59mcVBrsaVkU3AkKYro/edit?usp=sharing

Anon's working concept of Marker Theory

DELTA markers are different than regular markers

imo for example, the crumb you are referring to is the pic

[RR-Out] is a marker, but not a delta marker

Q does say to 'wind the clock with ALL markers' though, but I'm specifically focusing on the delta markers

and not all [#] markers are delta markers, many examples

>>4855313

Greeeeeetings codefag.

>>4855131

Yeah, you can have two separate sheets (tabs) in one doc, then link them how you said, and also create template/display sheets for ready-made graphics (macros).

>>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.

>>4856012

Re: your combo ideas for subject-content corroboration, definitely all those. Even for having corroborating/identical timestamp minutes in common even if different dates, could be intentional comms there too.

For delta's (and Anon's Marker Theory delta-markers), my initial understanding was they were the difference in timestamp minutes between a Q drop and a POTUS twat, or a twat and retwat, made within an hour of each other (bc Q clock).

However…

If we have a systematic way of sorting this stuff, we could also look for additional codes, as per this link you gave me >>4591252

I believe by "delta shifts" this anon is suggesting adding the data points of a) deltas between POTUS twats within the same day and b) "time between each tweet and first tweet of the day" (see pic)

>>4855779

AB, what do you think of that?

I'm going to post over there on timestamp thread to let 'em know what we're doing over here (and apologizing for duplicating effort, didn't realize when I made this thread they had that going already)

>>4856159

>If the code is freely available would Anons run a local utility?

I'm not nearly sophisticated enough in computer stuff to know whether this kind of thing would be safe for me to do tbh. While I know quite a lot about excel and a couple other utilities, that's about it. But

>code that scrapes DJT's twitter

to update the spreadsheet at regular intervals would be helpful I imagine

But also may be redundant to some extent given this:

>>4856027

I'm still checking it out

>>4856588

>I'm not even sure what these "deltas" are

You and me both. You can't have a "delta" (difference) unless it's between two things. Not really the kind of data point you just have linked to a single timestamp, which is how it looks to me.

>>4856983

Kek, our first meme!

Our little thread has arrived.

>>4861997

Anon, did you know that's clam baker's old avatar?

>>4881289

>Clambaker? Not me. I just liked the clam.

Got it, thanks anon. Just didn't want anons to get confused. Meme didn't start as an avatar anyway. Came about on a day when someone made clam/calm typo and a rain of memed puns ensued.

>>4950548

Thanks for that, Anon. I'm OP but was only facilitating 2 stated objectives. Anything related to them is good to stay here IMO, but the central theory that inspired the thread, Marker Theory (re: deltas, trannyfaggot) is this Anons:

>38d537.

So I defer the courtesy of OP decision-making to him, kek.

Was just checking in to help another anon do some sorting in excel… Is this you, anon?

>>4897892

>raw data for Q drops

Why don't you work on getting this into an excel doc and I will finish twat sheet code in the meantime. Setting up for sorts by date and minutes will be easy. Writing lookup/comparisons and delta calculations/sorts will take more thought/time, but will try to start with something that can be used sooner than later, even if not as comprehensive in utility as we'd like eventually. I'm workfagging weekdays but will do what I can.