Tracker: handle new gID statuses

[bthuronyi]

gIDs can have some new Statuses, e.g. "Status: wait - part(s) need new stock", and these should be classified as "pipeline" or "intervention" appropriately.

[shen2333333]

working on it

[shen2333333]

Just to clarify, I looked at the tracker's tracker tab and we currently have the column "next action" which reference the "status" column from registry in main sheet Do you mean by modifying "status" column over there and then modify next action column or?

[bthuronyi]

In general, the Tracker should read from and correctly classify whatever Status is shown in main CC. We shouldn't modify main CC's Status to fit the Tracker but the other way around. In this case I gather that means changing the "next action" column in Tracker to accommodate how GG Status has changed from main.

[shen2333333]

Notes for own use : Modify tracker to fit CC

1. modify columns related to golden gate statuses (if GG construct)
2. The status formula display the status for each part, i.e. part 1 need new stock, part 2 OK, etc...
3. Modify next action so that it recognizes the statuses column, and output, part x,y,z needs new stock?

[shen2333333]

brainstorming : Particularly expand on this code; waiting on parts, expand and clarify

1. Did any of the parts (mID) simply ran out? if so, then pipeline , and indicate which part need to be remade
2. Did any of the parts having issues? Then more like intervention
3. I don't know how common, some parts both pipeline and intervention; maybe just indicate intervention

[shen2333333]

https://docs.google.com/spreadsheets/d/1gPSnZTona39zSAr1sYyr5wdzejMtVRuvfN5xKToaiSI/edit?usp=sharing

Current draft, each gID has parts of mIDs, also added the mID statuses for a gID, like this.