hubmapconsortium/ccf-asct-reporter

Code and config file in the Reporter should be refactored to accommodate ASCT+b tables in their new location.

Closed this issue · 9 comments

Currently, all of the ASCT+B tables are stored in a single Google Sheets workbook with many sheets.

Now, in ASCt+B Google Drive, we're making a dedicated folder for ASCT+B tables, with organ names as subfolders, and version-specific files for each organ in the dedicated folders.

@emquardokus Please, provide a link once you have everything ready, in order for us to begin

@vutukuriajay2241 @bherr2
Here are the folder urls and individual ASCT+B organ table versions.
They are named according to what the ccf-release name is for those that are already DOI'd.
The ones with DRAFT at the end are the current quarter's working draft and should NOT be published YET in the ASCT+B reporter---authors will use the playground feature or the compare feature to visualize new tables until we publish them for next CCF-release v1.2.

Outer folder + ALL organ folders including NEW template:

n Folder name URL
1 Official_ASCT+B_Tables https://drive.google.com/drive/u/1/folders/1g9cZs_qLYcXxv0dKUSq9VIQUVv1WS1jz
2 ASCT+B_Template_01_18_2022 https://drive.google.com/drive/u/1/folders/1eGb4ERDXFwbqzeLc97Hlx7C4R6LWi_ck
3 Blood https://drive.google.com/drive/u/1/folders/1yauKcef04iAHRQ2rK8yd-r3aXYOpGDKv
4 Blood_Vasculature https://drive.google.com/drive/u/1/folders/1C50EZ1FROPkRagAWGDkfVVKIr3ei0KkY
5 Bone_Marrow https://drive.google.com/drive/u/1/folders/1442zmPQbTy7N7Oeis1HrjZ_0Ss6s5WnX
6 Brain https://drive.google.com/drive/u/1/folders/1Fv51Nrjb2tuxPePyj20HQ-74oZI9oEd9
7 Breast https://drive.google.com/drive/u/1/folders/1bG_YQKtPk7DQ_fOegKLPQ1vTMBuldrFO
8 Eye https://drive.google.com/drive/u/1/folders/1lgKDCvXjaae_0RP1lJcrVwX-Z8-3YJji
9 Fallopian_Tube https://drive.google.com/drive/u/1/folders/1E1Qn7C9f7WiPsKbSxMcqzkSjt0HXKNvr
10 Heart https://drive.google.com/drive/u/1/folders/16ZQOPtB1iG04B5Ets96eZzzs-SpusVq_
11 Kidney https://drive.google.com/drive/u/1/folders/1zQ_j22VtfHAh0hncHt3WvOe323tXHM-i
12 Knee https://drive.google.com/drive/u/1/folders/1b4hg5kSf-RI-_yFGiDBVNoCHZuwhxV9R
13 Large_Intestine https://drive.google.com/drive/u/1/folders/1Lbi1xJtIITSSiDDgSKt7zucNC_TTjlC8
14 Liver https://drive.google.com/drive/u/1/folders/1Iixpzp9erjy7Mv9dXup7SPrfTXcA-v0i
15 Lung https://drive.google.com/drive/u/1/folders/1fdL5tL4dQgBH_g1lzLJSLFgfKwK-9MD_
16 Lymph_Node https://drive.google.com/drive/u/1/folders/1dkFA_uaU0QEGT_rL5vYQMU7jB-aZLGO6
17 Lymph_Vasculature https://drive.google.com/drive/u/1/folders/1-rVPtfGH08qEWjA6BQWxYacqzv0NemyX
18 Ovary https://drive.google.com/drive/u/1/folders/1-ToiJOEWfZFp8W6JxxfXZg3a_xweI0qi
19 Pancreas https://drive.google.com/drive/u/1/folders/1xeT38A4nUgDzwItJmFQGXXpnfwdpn3Ri
20 Perpheral_Nervous_System https://drive.google.com/drive/u/1/folders/1LLmM0fwTAdqRLw7xFzkXNNrIyM1W9AgD
21 Placenta https://drive.google.com/drive/u/1/folders/1YjRrlbN9RjZ4lWFKGqu22VtgAEQs0KS_
22 Prostate https://drive.google.com/drive/u/1/folders/1Xwb_5HdMuEAFZXlKLGwIm-b8jIFS-Y2h
23 Skin https://drive.google.com/drive/u/1/folders/10TDYGgLx03G2G8rMohnCf1PySdJhC8ff
24 Small_Intestine https://drive.google.com/drive/u/1/folders/1PpELg4bkG-yqjdJMabEabKBnq7oSmuyh
25 Spinal_Cord https://drive.google.com/drive/u/1/folders/1-awny9Vu80oTHZri1Uh-9KfFVmhVpL-w
26 Spleen https://drive.google.com/drive/u/1/folders/1M5jiq19wQ5nZLsit98YyVEDlnHXhXXk1
27 Thymus https://drive.google.com/drive/u/1/folders/1vGlf5Jc5voVqmhx6MaY7gMfrwfD2PCCq
28 Ureter https://drive.google.com/drive/u/1/folders/1SHM8mn5HFjKZgJ-QclNi7VLY7vW9JbX4
29 Urinary_Bladder https://drive.google.com/drive/u/1/folders/1wea2eI9kWzzin68YF1Yu0S4kzkzrKKSR
30 Uterus https://drive.google.com/drive/u/1/folders/1he8HzN9GD5ay7lfvV3_w__3ddNaYvb49

CCF Release v1.2 DRAFT tables ONLY

n Folder name Sub-folder ASCT+B table name CCF-release Version URL
Official_ASCT+B_Tables Blood Blood_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1LRgU3VGi7Jlxh4EtHZaQiHtzcPYvvxYLGXrMB6oxdvQ/edit#gid=543201897
2 Official_ASCT+B_Tables Blood_Vasculature Blood_Vasculature_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1pBO70FENOlSyPJukxHYjeMXW0SYTLj4lbcw2oGsjuf0/edit#gid=997949803
3 Official_ASCT+B_Tables Bone_Marrow Bone_Marrow_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/16MUBNsMrE1kAyoY1sjCKsGSIHCRw7TnwTys8DHM17j0/edit#gid=771476671
4 Official_ASCT+B_Tables Brain Brain_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1Dzbu_yNfQ-AyOgiScZq7rcoG4oINqO1qEU-MnEE4mPw/edit#gid=2056967441
5 Official_ASCT+B_Tables Breast Breast_v1.0_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1Ac7C4dX7eYSMyR75AA2uVY9ZgNGOZZgbqgR8wmp-wdk/edit#gid=928286522
6 Official_ASCT+B_Tables Eye Eye_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1SFGfjkZeDxY_9FaQqNERzq4XRjWDUpwKC9FCqONlbuk/edit#gid=695483621
7 Official_ASCT+B_Tables Fallopian_Tube Fallopian_Tube_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1DFGmDSU75eMF6Fgwzk7W2u20DGJRdXN00TP7sO3kTug/edit#gid=991519552
8 Official_ASCT+B_Tables Heart Heart_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1eSzDzv_wOpMGTrSShmy_S7IXs8_H_Kp3QZg-gfKyUWk/edit#gid=1759721736
9 Official_ASCT+B_Tables Kidney Kidney_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1NMfu1bEGNFcTYTFT-jCao_lSbFD8n0ti630iIpRj-hw/edit#gid=949267305
10 Official_ASCT+B_Tables Knee Knee_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1zDCnaoMdSx09OGxjeeG2Sxokw4c_0bnNyDOJC6IMPCw/edit#gid=1815525900
11 Official_ASCT+B_Tables Large_Intestine Large_Intestine_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1d_KWKnQq3HT5nzDmfhlvFG4P_qdviu0vyhGZ6QHgNIk/edit#gid=2043181688
12 Official_ASCT+B_Tables Liver Liver_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1F8ZXt1naE1pJFjfsAd6wK7x22D3qRW5O0E2d9gUKAik/edit#gid=1694828397
13 Official_ASCT+B_Tables Lung Lung_v1.2_DRAFT v1.2< https://docs.google.com/spreadsheets/d/1iF4vx9EuQ2tQMBOm6awd9sf-2e_EHsPlcgzrF_YDtis/edit#gid=1523836586>
14 Official_ASCT+B_Tables Lymph_Vasculature Lymph_Vasculature_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1FNoQthhgP0OXEZuwIVL0XZA8SVYzCcVPm4_n20dt--8/edit#gid=2087685463
15 Official_ASCT+B_Tables Lymph_Vasculature Lymph_Vasculature_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1FNoQthhgP0OXEZuwIVL0XZA8SVYzCcVPm4_n20dt--8/edit#gid=2087685463
16 Official_ASCT+B_Tables Ovary Ovary_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1K5LWhMaT_IryNxuK1Vko0Ud49VUB8RnMltL5jYhJUak/edit#gid=756296951
17 Official_ASCT+B_Tables Pancreas Pancreas_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1_cmA0CWUzVz1lNMpNOXqzrnmWgXv3GANqN7W18N4crA/edit#gid=439021026
18 Official_ASCT+B_Tables Perpheral_Nervous_System Peripheral_Nervous_System_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1TQsd657v-Jfcme4ftmpq7Zaegu0HxHOmGJKUPL8QqyU/edit#gid=917578386
19 Official_ASCT+B_Tables Placenta Placenta_v1.0_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1TqatRIsZZ5QwvWdz6H4Un-sukbzSd21_x41Gqnn5UEY/edit#gid=231591207
20 Official_ASCT+B_Tables Prostate Prostate_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1hlSptGNXzyM7vxsH930YMf6gZkHVgHUE-Qc_4uFAmoU/edit#gid=1239199370
21 Official_ASCT+B_Tables Skin Skin_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/16E07Ia3opnjBzBVswS7iQccd2Y_fw7m8-mNUNjwv80E/edit#gid=269383687
22 Official_ASCT+B_Tables Small_Intestine Small_Intestine_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1pZDLDiAHD-QDi-OTF4GtUHf6bkKkDc2qc0eIFnIqS_s/edit#gid=247140941
23 Official_ASCT+B_Tables Spinal_Cord Spinal_Cord_v1.0_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1B8Yacpa0S_KuNqGGtKb83HTodKY_XGnIMy8tFCEIEdE/edit#gid=243784891
24 Official_ASCT+B_Tables Spleen Spleen_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1bairJs37srg0hF4MGIfsdtb000YtrA1hI45D8KI5Gxc/edit#gid=69626346
25 Official_ASCT+B_Tables Thymus Thymus_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/14KY4dp6YwVf0GSiCOcxhuy9L_aJ8FjTX_jidrIq7E_c/edit#gid=863370556
26 Official_ASCT+B_Tables Ureter Ureter_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1ZUmHX22NYMfBgFoni4zK6bsEYFn4rGSk9oYBNPcebZQ/edit#gid=73126811
27 Official_ASCT+B_Tables Urinary_Bladder Urinary_Bladder_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1iCZpti7fYupWhQjDz_tE01ii2WH23hIno9kYggMjDZo/edit#gid=1057183099
28 Official_ASCT+B_Tables Uterus Uterus_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1RasOQCB4oP_1kvZL7Xv40TID6_365FQ-cgX2fGR54gw/edit#gid=603441642

All versions of ASCT+B tables including working DRAFT

n Folder name Sub-folder ASCT+B table name CCF-release Version URL
1 Official_ASCT+B_Tables Template_Update_01_18_2022 v3.0 https://drive.google.com/drive/u/1/folders/1yxGyyQnIiPS6suWIEhpIcQ_nxnv_MLFf
2 Official_ASCT+B_Tables Blood Blood_v1.1 v1.1 https://drive.google.com/drive/u/1/folders/1g9cZs_qLYcXxv0dKUSq9VIQUVv1WS1jz
3 Official_ASCT+B_Tables Blood Blood_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1LRgU3VGi7Jlxh4EtHZaQiHtzcPYvvxYLGXrMB6oxdvQ/edit#gid=543201897>
4 Official_ASCT+B_Tables Blood_Vasculature Vasculature_v1 v1.0 https://docs.google.com/spreadsheets/d/1P4PPdZb1WaooBf2HYk8ySUTicbb98xISnC2v5Pzyvpc/edit#gid=2033154070
5 Official_ASCT+B_Tables Blood_Vasculature Blood_Vasculature_v1.1 v1.1 https://docs.google.com/spreadsheets/d/1IlELzPwpWoHUcDAmNBWofXfislAaF_oR8yVpwy-zl18/edit#gid=997949803
6 Official_ASCT+B_Tables Blood_Vasculature Blood_Vasculature_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1pBO70FENOlSyPJukxHYjeMXW0SYTLj4lbcw2oGsjuf0/edit#gid=997949803
7 Official_ASCT+B_Tables Bone_Marrow Bone Marrow_Blood_v1 v1.0 https://docs.google.com/spreadsheets/d/1lfZKW0cMYifC_cf3KGDf8zuJiYSx7B7D3Ux0IcanoZQ/edit#gid=567303828
8 Official_ASCT+B_Tables Bone_Marrow Bone_Marrow_v1.1 v1.1 https://docs.google.com/spreadsheets/d/1tnqtCAWSA6atiUBUOOjAHdOrjDw_fsIoCd5RkAmw310/edit#gid=771476671
9 Official_ASCT+B_Tables Bone_Marrow Bone_Marrow_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/16MUBNsMrE1kAyoY1sjCKsGSIHCRw7TnwTys8DHM17j0/edit#gid=771476671
10 Official_ASCT+B_Tables Brain Brain_v1 v1.0 https://docs.google.com/spreadsheets/d/18J89Ir5HWStCrTWKhGNnh3aPOy5UZ5HFZFcCzBfWmGA/edit#gid=1858363173
11 Official_ASCT+B_Tables Brain Brain_v1.1 v1.1 https://docs.google.com/spreadsheets/d/1TiwW1NZJ5kdCzJ4zwCpY3Gzv3WE5WUoBDWIAkU5gXd0/edit#gid=2056967441c
12 Official_ASCT+B_Tables Brain Brain_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1Dzbu_yNfQ-AyOgiScZq7rcoG4oINqO1qEU-MnEE4mPw/edit#gid=2056967441
13 Official_ASCT+B_Tables Breast Breast_v1.0_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1Ac7C4dX7eYSMyR75AA2uVY9ZgNGOZZgbqgR8wmp-wdk/edit#gid=928286522
14 Official_ASCT+B_Tables Eye Eye_v1.0 v1.1 https://docs.google.com/spreadsheets/d/1u7IbxnPABRpYL5rFxOba8cmlvG1yGp-dwD3TV3V26K4/edit#gid=44026578c
15 Official_ASCT+B_Tables Eye Eye_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1SFGfjkZeDxY_9FaQqNERzq4XRjWDUpwKC9FCqONlbuk/edit#gid=695483621
16 Official_ASCT+B_Tables Fallopian_Tube Fallopian_Tube_v1.0 v1.1< https://docs.google.com/spreadsheets/d/16tAvAmjwKwbq5SDz7UZ-T1N_KUHRGqPDbMqffFuInMI/edit#gid=1739942440>
17 Official_ASCT+B_Tables Fallopian_Tube Fallopian_Tube_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1DFGmDSU75eMF6Fgwzk7W2u20DGJRdXN00TP7sO3kTug/edit#gid=991519552
18 Official_ASCT+B_Tables Heart Heart_v1 v1.0 https://docs.google.com/spreadsheets/d/1jVU7LiNjf4X-UzSrFCEkt174NaD423b7fK_4MRItDyg/edit#gid=1457978850
19 Official_ASCT+B_Tables Heart Heart_v1.1 v1.1 https://docs.google.com/spreadsheets/d/1UhEZpDxQLCJLLx0gnWYDMQP8M-dwjZo_vIyPfjBCcVM/edit#gid=1759721736
20 Official_ASCT+B_Tables Heart Heart_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1eSzDzv_wOpMGTrSShmy_S7IXs8_H_Kp3QZg-gfKyUWk/edit#gid=1759721736
21 Official_ASCT+B_Tables Kidney Kidney_v1 v1.0 https://docs.google.com/spreadsheets/d/1J4nObDGqPP3JHhQ4H7_mNNQ_61KMpwM-59qqva7HYOQ/edit#gid=122248124
22 Official_ASCT+B_Tables Kidney Kidney_v1.1 v1.1 https://docs.google.com/spreadsheets/d/1PgjYp4MEWANfbxGIxFsJ9vkfEU90MP-v3p5oVlH8U-E/edit#gid=949267305
23 Official_ASCT+B_Tables Kidney Kidney_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1NMfu1bEGNFcTYTFT-jCao_lSbFD8n0ti630iIpRj-hw/edit#gid=949267305
24 Official_ASCT+B_Tables Knee Knee_v1.0 v1.1 https://docs.google.com/spreadsheets/d/1QidDho8DxBYjsxaqApiIZA__Z7aWnB61KvC422g2kx8/edit#gid=1824489301
25 Official_ASCT+B_Tables Knee Knee_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1zDCnaoMdSx09OGxjeeG2Sxokw4c_0bnNyDOJC6IMPCw/edit#gid=1815525900
26 Official_ASCT+B_Tables Large_Intestine Large_Intestine_v1 v1.0 https://docs.google.com/spreadsheets/d/1fmLUQGxPa4E0FcdzWNVJs1Jxi2Qpu-xoZ6FS64EqHZU/edit#gid=152701026
27 Official_ASCT+B_Tables Large_Intestine Large_Intestine_v1.1 v1.1 https://docs.google.com/spreadsheets/d/1vU6mQmnzAAxctbNYPoFxJ8NvbUql8pbipsGdt7YCOQQ/edit#gid=2043181688
28 Official_ASCT+B_Tables Large_Intestine Large_Intestine_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1d_KWKnQq3HT5nzDmfhlvFG4P_qdviu0vyhGZ6QHgNIk/edit#gid=2043181688
29 Official_ASCT+B_Tables Liver Liver_v1.0 v1.1 https://docs.google.com/spreadsheets/d/1tPDKw_znxqWhZYPTeVN4AN2_F4-JecsdeUgp2lj4P8g/edit#gid=1460762432
30 Official_ASCT+B_Tables Liver Liver_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1F8ZXt1naE1pJFjfsAd6wK7x22D3qRW5O0E2d9gUKAik/edit#gid=1694828397
31 Official_ASCT+B_Tables Lung Lung_v1 v1.0 https://docs.google.com/spreadsheets/d/15MfX3G4PpeldII4p7OiqBwUkdbsNJ7aO0n3a1fAj_H8/edit#gid=1119895453
32 Official_ASCT+B_Tables Lung Lung_v1.1 v1.1 https://docs.google.com/spreadsheets/d/1OBw0k7PUclVX2oG-L1Qx3LQCDb03tyn-rquMOJFN5uo/edit#gid=1523836586
33 Official_ASCT+B_Tables Lung Lung_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1iF4vx9EuQ2tQMBOm6awd9sf-2e_EHsPlcgzrF_YDtis/edit#gid=1523836586
34 Official_ASCT+B_Tables Lymph_Node Lymph_Node_v1 v1.0 https://docs.google.com/spreadsheets/d/1O30L6BdFUrgDpKXEi1v-t1tD7rxuGfhkE8aaG-uUPdY/edit#gid=113237877
35 Official_ASCT+B_Tables Lymph_Node Lymph_Node_v1.1 v1.1 https://docs.google.com/spreadsheets/d/1aK9gJ2_kMb2B8zrQgScDgxpEWAcCs7kl-gnQGwV3LHM/edit#gid=1223566381
36 Official_ASCT+B_Tables Lymph_Node Lymph_Node_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1_VWj_dD1dbmnBf8t0wptXvpy1oyyllZ1tXc0aKo2MSA/edit#gid=1223566381
37 Official_ASCT+B_Tables Lymph_Vasculature Lymph_Vasculature_v1.0 v1.1 https://docs.google.com/spreadsheets/d/1SILRNUI71BEVWl1fpsi_32DSuSA-bAPgXv5pTfKnrOE/edit#gid=1700987638
38 Official_ASCT+B_Tables Lymph_Vasculature Lymph_Vasculature_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1FNoQthhgP0OXEZuwIVL0XZA8SVYzCcVPm4_n20dt--8/edit#gid=2087685463
39 Official_ASCT+B_Tables Ovary Ovary_v1.0 v1.1 https://docs.google.com/spreadsheets/d/1FE2XufrruExUWqcai3XRFqtMjeEdzoLKJ-YNa-nRZ1M/edit#gid=1997082517
40 Official_ASCT+B_Tables Ovary Ovary_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1K5LWhMaT_IryNxuK1Vko0Ud49VUB8RnMltL5jYhJUak/edit#gid=756296951
41 Official_ASCT+B_Tables Pancreas Pancreas_v1.0 v1.1 https://docs.google.com/spreadsheets/d/1CIWqIygz2OzxMECIvhudFN14Kt7-JFUBLpzn5uuH5Xs/edit#gid=801179416
42 Official_ASCT+B_Tables Pancreas Pancreas_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1_cmA0CWUzVz1lNMpNOXqzrnmWgXv3GANqN7W18N4crA/edit#gid=439021026
43 Official_ASCT+B_Tables Perpheral_Nervous_System Peripheral_Nervous_System_v1.0 v1.1 https://docs.google.com/spreadsheets/d/1KifiEDn3PpJ8pjz9_ka4TWkT085wLIzIQP5NKSvb2Ac/edit#gid=714133140
44 Official_ASCT+B_Tables Perpheral_Nervous_System Peripheral_Nervous_System_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1TQsd657v-Jfcme4ftmpq7Zaegu0HxHOmGJKUPL8QqyU/edit#gid=917578386
45 Official_ASCT+B_Tables Placenta Placenta_v1.0_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1TqatRIsZZ5QwvWdz6H4Un-sukbzSd21_x41Gqnn5UEY/edit#gid=231591207
46 Official_ASCT+B_Tables Prostate Prostate_v1.0 v1.1 https://docs.google.com/spreadsheets/d/1_O5yXOesG93dobMHRSIvVAt9xj7mDnEAYdRJcHYJ84U/edit#gid=1757780481
47 Official_ASCT+B_Tables Prostate Prostate_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1hlSptGNXzyM7vxsH930YMf6gZkHVgHUE-Qc_4uFAmoU/edit#gid=1239199370
48 Official_ASCT+B_Tables Skin Skin_v1 v1.0 https://docs.google.com/spreadsheets/d/1hy-YloznDmN9EX-eL_peNxw3suRjQdLcJTw0fABMXeU/edit#gid=1378102034
49 Official_ASCT+B_Tables Skin Skin_v1.1 v1.1 https://docs.google.com/spreadsheets/d/1Pmi3g26vhbg9HU6GDpIvxKbIP985JM-5eytOHxJUdZs/edit#gid=269383687
50 Official_ASCT+B_Tables Skin Skin_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/16E07Ia3opnjBzBVswS7iQccd2Y_fw7m8-mNUNjwv80E/edit#gid=269383687
51 Official_ASCT+B_Tables Small_Intestine Small_Intestine_v1.0 v1.1 https://docs.google.com/spreadsheets/d/1Xlds8FzZ8ecmy3cxYJt1ijQC9FifamZRZ5KzH4Yt-MQ/edit#gid=1762589435
52 Official_ASCT+B_Tables Small_Intestine Small_Intestine_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1pZDLDiAHD-QDi-OTF4GtUHf6bkKkDc2qc0eIFnIqS_s/edit#gid=247140941
53 Official_ASCT+B_Tables Spinal_Cord Spinal_Cord_v1.0_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1B8Yacpa0S_KuNqGGtKb83HTodKY_XGnIMy8tFCEIEdE/edit#gid=243784891
54 Official_ASCT+B_Tables Spleen Spleen_v1 v1.0 https://docs.google.com/spreadsheets/d/1h1YdIyMv5fizD-NfKjaT9DtN5SlHG47LNTRKP5JNVXo/edit#gid=475760339
55 Official_ASCT+B_Tables Spleen Spleen_v1.1 v1.1 https://docs.google.com/spreadsheets/d/1HL7aHx5A2KOa1KsJ0PIagqxdshVavFIEJZP6_YDtUww/edit#gid=69626346
56 Official_ASCT+B_Tables Spleen Spleen_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1bairJs37srg0hF4MGIfsdtb000YtrA1hI45D8KI5Gxc/edit#gid=69626346
57 Official_ASCT+B_Tables Thymus Thymus_v1 v1.0 https://docs.google.com/spreadsheets/d/14uB40YMrp6hFdf06Vwlqj-Tii3GTdLZyl3n6-sxCsfM/edit#gid=1710828471
58 Official_ASCT+B_Tables Thymus Thymus_v1.1 v1.1 https://docs.google.com/spreadsheets/d/1nSiz2yFDMJSqIXbnAP_EXIQZfN6ZflOs-WBdZ6LVhUY/edit#gid=863370556
59 Official_ASCT+B_Tables Thymus Thymus_v1.2_DRAFT v1.2 https://docs.google.com/spreadsheets/d/14KY4dp6YwVf0GSiCOcxhuy9L_aJ8FjTX_jidrIq7E_c/edit#gid=863370556
60 Official_ASCT+B_Tables Ureter Ureter_v1.0 v1.1 https://docs.google.com/spreadsheets/d/1ivVU53FPInUwK4ZIha8YUvJM_8keizoJGaM3rT-TZRY/edit#gid=676299490
61 Official_ASCT+B_Tables Ureter Ureter_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1ZUmHX22NYMfBgFoni4zK6bsEYFn4rGSk9oYBNPcebZQ/edit#gid=73126811
62 Official_ASCT+B_Tables Urinary_Bladder Urinary_Bladder_v1.0 v1.1 https://docs.google.com/spreadsheets/d/1ohOG5jMf9d9eqjbVK6_u3CvgfG3wcLfs_pxB2838wOo/edit#gid=1342577957c
63 Official_ASCT+B_Tables Urinary_Bladder Urinary_Bladder_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1iCZpti7fYupWhQjDz_tE01ii2WH23hIno9kYggMjDZo/edit#gid=1057183099
64 Official_ASCT+B_Tables Uterus Uterus_v1.0 v1.1 https://docs.google.com/spreadsheets/d/1yEcbJMrUIzJY-4JNtF1Y_eUpAQsgKF6DX2-5Z3UXBeE/edit#gid=1434605386c
65 Official_ASCT+B_Tables Uterus Uterus_v1.1_DRAFT v1.2 https://docs.google.com/spreadsheets/d/1RasOQCB4oP_1kvZL7Xv40TID6_365FQ-cgX2fGR54gw/edit#gid=603441642

@emquardokus new locations are now on staging https://ccf-asct-reporter.netlify.app/. You can close this after you've reviewed.

@bherr2
There are problems with staging and not sure the origin as the original tables, links and versions listed in this ticket that I provided are correct.

From Master Tables drop down listing of versioned tables (
NOTE, the "go to visualization is correctly listing ONLY published tables)

**The issues I'm seeing at the staging site are as follows: **

  1. original 11 organs should have 3 versions, but in some cases the v1.2 DRAFT is missing; the exception are Blood and Bone marrow because v1 was together and v1.1 were split and blood vasculature v1.1 was published as vasculature v1.0, but both should have v1.2 DRAFT

Blood,Blood Vasculature, Bone marrow, Brain, Heart, Kidney, Large intestine, Lymph node, Lung, Skin, Spleen, Thymus

should have v1.0, v1.1 and v1.2 DRAFT

  1. organ tables that had their first v1.0 published in December 2021 will have v1.1 DRAFT
    Eye, Fallopian tube, Ovary, Pancreas, Prostate,Small intestine, Ureter, Urinary bladder, Uterus,
    should have v1.0 and v1.1 DRAFT

  2. organ tables that will be brand new for Q3 will have v1.0 DRAFT
    Placenta, Spinal cord and Breast
    Should have v1.0 DRAFT only
    =========
    These organs are missing their DRAFT versions entirely: Lung
    Lung should have 3 versions: v1, v1.1, v1.2 DRAFT

Screen Shot 2022-02-07 at 11 38 21 AM

==========
These are the organs are missing the word "DRAFT" after their latest versions. (I think some confusion may be occurring in that NOT all v1 and v1.1 are published for all organs) This gets back to the CCF_release version numbering vs the ASCT+B table version numbering.

These table names should be denoted as "v1.1DRAFT" as they are the working versions for Q3:
Eye, Fallopian Tube, Heart, knee, liver, lymph vasculature, ovary, pancreas, peripheral nervous system, prostate, small intestine, urinary bladder, uterus

ureter is missing the draft table altogether

Screen Shot 2022-02-07 at 11 12 46 AM

Screen Shot 2022-02-07 at 11 13 47 AM

Screen Shot 2022-02-07 at 11 15 17 AM

v1.2_DRAFT;

Screen Shot 2022-02-07 at 11 32 47 AM

Screen Shot 2022-02-07 at 11 50 56 AM

=========
Placenta, Spinal cord and Breast are new for quarter 3, first version tables, all are DRAFT.
v1.0 DRAFT
Placenta is currently showing v1.0 needs to be updated v1.0 DRAFT
Spinal cord is correct showing v1.0 DRAFT
Breast is correct showing v1.0 DRAFT

============
These have incorrect DRAFT numbers: Brain v1.1DRAFT should be Brain_v1.2_DRAFT, Heart v1.1DRAFT should be Heart_v1.2_DRAFT, Large_Intestine_v1.1_DRAFT should be Large_Intestine_v1.2_DRAFT, Lymph node
Brain, large intestine, lymph node,

Screen Shot 2022-02-07 at 11 11 09 AM

Screen Shot 2022-02-07 at 11 14 34 AM

Screen Shot 2022-02-07 at 11 22 26 AM

Screen Shot 2022-02-07 at 11 49 26 AM

@Nikhil-lab let us know if you have any questions about these changes.

@bherr2, @emquardokus, @katyb
We have three options for the Draft versions. Please let @Nikhil-lab and me know which one need to be done.

  1. Do we need completely remove Draft tables from the config file?
  2. Do we need have in both the config file and show them on the UI?
  3. Do we need have in both the config file and hide them on the UI?

Sheet configs should only be in sheet-config.json (and not in configuration.json). Keep drafts. In the visualization chooser, hide DRAFTs unless 'visible' = true (sort by Label). In Master Tables dropdown, do not filter out Drafts.

@Nikhil-lab Are you clear now? Please let us know if you have any questions?