Look at the top of the page for “Prioritized Article II Amendments” just to the right of “General Assembly 2023.” Clicking on that puts you in the listing of all of them.
Wow. Thanks for pulling all this together! Works fine for me …
2 Likes
I have the same question
I’ve created a copy of your sheet (thx so much for it!) with fields: Original Amdt #, Priority in 6/15 List, replaces your Amendment field with Proposed By (with simply the person’s name), and keeps all remaining fields intact. This preserves all your information, deletes repetitive text, and adds the field to cross reference each amendment to its original priority in the 06/15 list. I haven’t yet made the original amendment number into hotlines (like your original); working that now. Would this be of interest to you as a “friendly spreadsheet amendment”?
2 Likes
I have started working on one.
I started something similar; separated amendment number from proposer in 2 columns, easier to read, but then mine are not live links. . . .
Hi, I’m not understanding what you mean here – do you mean you are returning to the original numbering? but are you also showing the number of the Priority amendment?
want to email it to me? president@uufp.org. Or post here so I can see? actually if you post, that just gives a second kind of view… whichever.
I can’t tell if I’d change ours to that until I see it. Maybe duplication is fine. Actually you could simply change the TEXT of the hotlinks as you describe, instead of having to make the whole list hot again…
lmk…
bek
1 Like
@jmccargar , I’m also a bit confused, as the prioritization order has not been specified yet (the numbering relates to the order in which the amendments were received). Are you suggesting a field to add the prioritization order when it is published? In which case maybe it should be an additional column? Or are you saying that the person’s name “proposed by” should be removed?
@BekWheeler and @clandrum and @uurockrev , thanks for all this hard work!
k
1 Like
Thanks. #10 also adds an 8th principle
Yes, indeed, that is clearly shown in the spreadsheet, yes? Just checked, verified. However, if Rev. Cindy and I have omitted anything key, we greatly welcome any corrections – we will then input.
My edit maps the original amendment number (which was assigned chronologically) to the order of the so-called prioritized list as published for us by GA. on 06/14. It also eliminates repetitive or moot text, preserves the section citations and summaries, sortability and searchability, and the hot linking to amendment & comments from their original. As I can do it, I hope to make the amendment numbers themselves hot links, rather than preserving the original Amendment field, but shrunk down to serve simply as a clickable link. I emailed copies to Bek for review a short while ago.
1 Like
Hey, James. Check the email address you used? This is 5 hours later and nothing came through. And I’ve checked my spam filter.
President @uufp.org. Sometimes people put com or whatever else (no space before the @ sign)
I’m off to the airport this morning. Maybe I can look at the airport. Then family reunion for the weekend.
Looking forward to seeing your work
Bek
this is simply copied from my original email…
Dear Bek!
I’m so sorry I’m so late getting back. Helluva day here.
I’ve published my edited Google Sheets version on the Google Drive for the 12 delegates in our Ann Arbor delegation. I tried to post it to you as well, with edit privileges, but your above email chokes through Google. If you’ve got a sharable linked Google email (even a non-gmail address), I’ll try that instead. Meanwhile, I’ve pasted identical Excel and Numbers files below. If you think they help, I’ll do what you wish (our delegation has found this version, and yours, useful).
The 2nd field is for the priority order implicit (though apparently incompletely curated) in the original list published for us by UUA in their 6/14 list. This allows cross-referencing the original amendment number (which is chronological) with the order in the original PRIORTIZED list. Together with your summaries and the ability to sort the list by Article II section, this greatly speeds analysis. Note that your field called AMENDMENTS is still there, just made narrow TO SHOW ONLY ‘AMEND’, because I didn’t have time today to run a script to make the amendment numbers hot linked, so this is my temporary way to preserve the (useful!) hot link functionality until I make that field moot.
(Attachment Prioritized Amendments to Article II - by Rev. Cindy Landrum & Bek Wheeler Edited by jmccargar.numbers is missing)
(Attachment Prioritized Amendments to Article II - by Rev. Cindy Landrum & Bek Wheeler Edited by jmccargar v2.xlsx is missing)
1 Like
Yes, meant comment for spreadsheet put together by another person. Sorry for the confusion!
looks like the ga email intermediary rejected passing through my attachments in my second attempt.
in my message last night i simply copied your president@uufp.org address. The cc of that email i automatically sent myself worked. Maybe it’s the attachment size? if you have a suggestion, i’ll give it a shot:
Jim McCargar he/him/his
jmccargar@comcast.net@
734.272.2275 (cell, text)
oh wow, right. absolutely. well my gmail is
please do send me by gmail so I can see, but like I said, today is a travel day and weekend for me. I’m so pleased you have adapted as works for you and that you have shared with your 12 delegates! YES!!!
(your attachment doesn’t come through on discuss-uua-org so send along in email).
So glad you are adapting to fit your needs. I know Rev. Cindy is blasted with work so I don’t know when we will further respond. but Green Light to you!
bek
You should now have an email invite with edit access to our sheet through Shared With Me in Google Drive. I also sent Excel & Numbers versions to you using your gmail address, in separate emails.Note you have an email kickback message enabled, so you may not see the actual access invite and spreadsheet emails unless you dig a bit.
Safe travels!
Thank you! This is super helpful!
3 posts were merged into an existing topic: Preliminary list of Priority Article II Amendments