The Speaker's Desk

Robespierre

The MacMilitant
-
-
-
spk_seal.png


Office of the Speaker
-~-
Statistics on Citizenship: 13 January 2021

If elected, I'd like to publish two "State of the Regional Assembly" reports at bi-monthly intervals in an effort to make more information accessible to North Pacificans about what their Speaker's Office is doing for them. These reports would also serve as a great way for incoming citizens to get up to speed about what's happened previously in the Regional Assembly and having them come directly from the Speaker and their staff at the midterm mark and at the end of term mark means that we could include certain data that the RA Highlights in TNS currently doesn't.
- Me, literally twelve days ago.

Well, this... didn't age well :/ Why? Because we can do you one better, that's why.

That's right! Starting today, I am very pleased to announce the beginning of a new initiative on the part of the Speaker's Office to record actions taken by the Office on a publicly viewable Google spreadsheet that will be available for reference at any point during the term. Much like how the Citizen/Resident registry spreadsheet is currently maintained, members of the Speaker's Office have all been given editing access to enter information into the sheet while the sheet itself can be seen and avoid being tampered with by opening a sharable link that makes use of viewing access.

Everything from processing citizenship applications, to performing daily residency and forum/RMB activity checks, to viewing the aftermath of future audits, to observing changes in the number of nations lost or gained for reasons that are specified on the right hand side of the sheet, will be tracked in what I hope you'll all find to be a comprehensive, complete insight into the day-to-day activities of my staff and I as we look to monitor the health of our region from month to month.

In my campaign, I said that I would be giving a pair of "State of the Regional Assembly" reports from the Speaker's desk at bi-monthly intervals. This will still be the case even with this announcement, as those reports will include compilations and overviews of all Regional Assembly activities during a given timespan (two months prior to the report being given). Having said that, what's better than bi-monthly data dumps and summaries of activity? Real time data entry that can be observed by anyone, for any purpose (Yes, even if just to satisfy curiosity!)

Not only does this sheet aim to promote transparency in governance, but by collecting records of the Speaker's Office's actions, we can eliminate the need for us to scrounge around the application thread for citizenship and in various other places on the forums when the time comes to release a report. When I ran, I assured you all of an active and engaged office in the legislature. Full disclosure: This will require some extra work on our part while fulfilling our various duties. But ultimately, we aren't really too concerned by that, especially not when doing so carries the potential for this data to be usefully applied to other regional projects should the overseers of those projects wish to leverage the cold, hard numerical analytics that we can provide.

As we begin doing this, I will be reminding my Deputy Speakers (and myself) to keep up to date on this sheet and to consistently enter actions as they're carried out by us. If this seems like a terrible burden to have to carry, it's not, as this kind of manual entry is already required at the time of action when we seek to keep the "Pending Citizenship Applications" tab of the registry updated.

Credit where credit is due, @Dreadton has been nice enough to create this spreadsheet for use by the Speaker's Office. He's incorporated formulas that will automaticallhy calculate the totals for the various statistics over any period of time and he's said that the sheet will be tweaked and prettied as we get more use out of it. In other words, it automatically updates upon entry of actions!

A very special thank you to him for working on this with me and we hope that this is an effort that most all of you can appreciate. As always, any questions are welcomed.

Yours,

Robespierre (Francois Isidore)
Speaker of the Regional Assembly
 

Robespierre

The MacMilitant
-
-
-
How exciting! Are you planning to integrate this with the main citizen sheet in the future?
Yes, I am.

Since the spreadsheet linked in my post above was created earlier today by Dreadton, the formulas he put into it were added on a separate sheet as a way to test them and make sure that it worked as it was intended to

Should this go well, as planned, for the next couple weeks or so, I’d love to see it integrated into the Citizen/Resident registry spreadsheet as it’s own tab. This will be the end goal so that everything is in one place and where people are already used to it being, as that spreadsheet is much more established than this new one.

I’ll be speaking with Dreadton when it’s not 1AM in our timezone and see if integrating the two is a possibility.
 

Dreadton

PC Load Letter
-
Deputy Speaker
-
-
I dont see why it could not be added to the exsiting Workbook. But I do believe that the Workbook used for citizenship is under the master control of the Admin team? So I would think we would need to get their ok to add it.
 

Robespierre

The MacMilitant
-
-
-
spk_seal.png


Office of the Speaker
-~-
Successful Spreadsheet Integration: 10 February 2021

Me:
Should this go well, as planned, for the next couple weeks or so, I’d love to see it integrated into the Citizen/Resident registry spreadsheet as it’s own tab. This will be the end goal so that everything is in one place and where people are already used to it being, as that spreadsheet is much more established than this new one.

Just as a note: The citizen stats spreadsheet has been integrated into the Citizen/Resident registry spreadsheet. As I said would be the case in response to the question that was asked to me by @Cretox State after one of my earlier updates in this thread, a tab labeled "Citizen Stats" has now been added to the registry sheet and features the same data that could be found previously in the spreadsheet that was, for a brief few weeks, entirely separate. For those of you who attended the fireside chat that I gave at the beginning of this month (Sorry. It was live NBS broadcast only, so no recording is available), I said that spreadsheet integration would be taking place within the next fifteen days.

Seeing as to how it's currently the tenth of February as I'm writing this, I'm happy to report that my Office has been able to deliver on that timetable slightly ahead of schedule -- as was expected. Anyhow, there's nothing that requires me to go into too much detail here. As always, a thank you goes out to my Deputies for remaining persistent and being willing to do what's asked of them even if it requires a few extra efforts on their part. This'll go a long way towards making everything a bit more cohesive

As was the case originally, everything remains publicly viewable and available for the convenience of citizens and/or anyone who's interested in knowing what the Speaker's Office is doing on a day-to-day basis. If anyone has any questions, feel free to reach out.

Thank you,

Robespierre (Francois Isidore)
Speaker of the Regional Assembly
 

Robespierre

The MacMilitant
-
-
-
spk_seal.png


Office of the Speaker
-~-
A Small Audit: 23 February 2021

Afternoon, all:

Yesterday, the Speaker's Office performed an internal audit in an effort to remedy some of the discrepancies that had been making themselves known on the registered residents tab of the Citizen/Resident registry spreadsheet. Of the fourteen inconsistencies that were found, a list of each, as well as a changelog of fixes performed by my Office to resolve them, can be found below:

Added ACR of Deerfenland to the residents sheet (Was previously only a member of the joinable group)
Added Andrenne to the residents sheet (Was previously only a member of the joinable group)
Removed Entecavir from the residents joinable group
Added FlyingRyan to the residents sheet (Was previously only a member of the joinable group)
Removed Hail Grevious from the citizens sheet and joinable group
Removed Homosexuos from the residents joinable group
Added kodzuken to the residents sheet (Was previously only a member of the joinable group)
Added Leader of Garganton to the residents sheet (Was previously only a member of the joinable group)
Added Libertania Democratica to the residents sheet (Was previously only a member of the joinable group)
Added Mônica to the citizens sheet (Was previously only a member of the joinable group)
Added r3naissanc3r to the residents sheet (Was previously only a member of the joinable group)
Added scubadriver to the residents sheet (Was previously only a member of the joinable group)
Added Sidoneia to the citizens sheet (Was previously only a member of the joinable group)
Removed Yuzhka from the residents joinable group

I will note: The last audit that was announced in this thread and performed by my predecessor was completed on 1 January 2021. At the time of the previous audit, twenty-seven inconsistencies were found, and before that -- in September of 2020 -- there were forty-seven found. We are making progress, even still, and it is my hope that going forward we can reaffirm our commitment to not only maintaining the citizens sheet, the pending applications sheet, and the statistics sheet, but the registered residents sheet as well.

A special thank you to @Kastonvia, who's been an excellent member of my team, for showing the initiative to undertake this task. If you have any questions, or wish to know more about what the Speaker's Office is doing for you, then please feel free to reach out to me or to view the aptly named "Citizens Stats" tab of the spreadsheet to see records of our every action.

In service,

Robespierre (Francois Isidore)
Speaker of the Regional Assembly
 

Robespierre

The MacMilitant
-
-
-
spk_seal.png


Office of the Speaker
-~-
Appointment of a Deputy Speaker: 3 March 2021

Good day, all:

I am pleased to announce that @East Isles will be joining my team as a Deputy Speaker.

As I did with my appointments at the beginning of the term, I will now provide you all with a bit of background as for why I've made this selection:

Since coming to me privately on 1 February with questions of how a citizen could involve themselves further with the Regional Assembly, East Isles has shown an ability to listen to the advice that I gave at the time and has since partaken in the discussions and debates that the Regional Assembly has had over the course of the past month. For the last few votes, including the most recent votes on the confirmations of various Election Commissioners, East Isles could be seen motioning things through the legislature as the situation called for it and their desire to get more experience within the region under their belt has not gone unnoticed.

East Isles will make a terrific edition to the Speaker's Office, as they've cited their keen interest in administrative work and their preferred attention to detail.

Please take your oath at your earliest convenience.

In light of this appointment, the weekly schedule that the Speaker's Office operates off of will be changed to the following:

MondayTuesdayWednesdayThursdayFridaySaturdaySunday
East Isles (Lead) / RobespierreRobespierre (Lead) / BobberinoDreadton (Lead) / PeepsKastonvia (Lead) / DreadtonPeeps (Lead) / Robespierrelol2639 (Lead) / KastonviaBobberino (Lead) / lol2639


Kastonvia removed as lead on Mondays
East Isles added as lead on Mondays

The rest of the schedule will remain the same, with minimal changes as logged above, and the Deputies indicated above will remain as your primary points of contact for the Speaker's Office on their assigned days -- along with myself.

Lastly, a reminder: As I promised during my campaign (and as I reiterated in a previous update from this desk), my first "State of the Regional Assembly" report will be released on 11 March 2021. I ask that you all stay tuned for this, as I will be giving the aforementioned report exactly two months from the day of my term beginning and it, along with all of its contents, will be readily available in this thread come a week and a day from now.

Thank you,

Robespierre (Francois Isidore)
Speaker of the Regional Assembly
 

Robespierre

The MacMilitant
-
-
-
spk_seal.png


Office of the Speaker
-~-
An Even Smaller Audit: 6 April 2021

Good evening, everyone:

Last night, the Speaker's Office performed its second internal audit of the term. Much like the one that was completed back in late-February, we did so in an effort to locate discrepancies that could have previously been found on the registered residents tab of the Citizen/Resident registry spreadsheet and resolve them in as swift a fashion as possible. Ten inconsistencies were found, which is down from the previous finding of fourteen during our last audit, and an 100% matchup was confirmed between the citizenship sheet and the citizens joinable group without issue.

A list of each incontinency as it relates to residents, as well as a changelog of fixes performed by my Office to resolve them, can be found below:

Removed Alsatian Island from the residents sheet and from the residents joinable group
Added Atlae to the residents sheet (Was previously only a member of the joinable group)
Added CommanderInChief-lubeo to the residents sheet (Was previously only a member of the joinable group)
Added Goyanes to the residents sheet (Was previously only a member of the joinable group)
Added Noah's Second Country to the residents sheet (Was previously only a member of the joinable group)
Added PaintedBlue to the residents sheet (Was previously only a member of the joinable group)
Added Seenvorland to the residents sheet (Was previously only a member of the joinable group)
Added Star Kingdom to the residents sheet (Was previously only a member of the joinable group)
Removed Yacoste from the residents sheet and from the residents joinable group
Added Yoshikage Kira to the residents sheet (Was previously only a member of the joinable group)


As an added note: Eight of the ten inconsistencies found stem from one scenario in particular. That scenario being that a former citizen loses citizenship, a Deputy Speaker of myself goes to perform our daily check on them, rightly removes their citizenship, adds resident status if they're still in the region (for nations that fail the posting requirement but don't fail the residency requirement), yet fail to add a row for them on the residents tab of the spreadsheet when they're given the proper masking for it on the forums.

The good news is, this audit found fewer discrepancies than any past audit by either myself or my predecessor in Office. Nonetheless, as we aim to finish out the term strong, the goal is now to eliminate the aforementioned scenario from occurring entirely and simply phase out the need for these audits altogether. Past audits in past terms have been a step in the right direction, as was this one, but going forward we hope to keep things spotless, orderly, and eliminate any possible chances for mistakes.

Working for you,

Robespierre (Francois Isidore)
Speaker of the Regional Assembly
 

St George

Minister
-
-
-
-
yet fail to add a row for them on the residents tab of the spreadsheet when they're given the proper masking for it on the forums.
This can be avoided by adding the row for them on the residents tab before you remove them from the citizens one.

Excellent work on the audit though!
 
Last edited:

Robespierre

The MacMilitant
-
-
-
spk_seal.png


Office of the Speaker
-~-
Resignation of a Deputy Speaker: 11 April 2021
Good evening, all:

Pertinent to Section 3 Clause 1 of the Regional Assembly Rules, I hereby remove @Bobberino as a Deputy Speaker in light of his informing me of his intent to resign.

1. The Speaker may, at their discretion, appoint a citizen as Deputy Speaker. The Speaker may, at their discretion, remove an existing Deputy Speaker.​

This announcement comes after a conversation between Bob and I in which we mutually agreed that his resignation would be accepted. We thank him for his many months of service in the role and wish him the best going forward.

With this removal, the weekly schedule that the Speaker's Office operates off of will be changed to the following:

MondayTuesdayWednesdayThursdayFridaySaturdaySunday
East Isles (Lead) / RobespierreRobespierre (Lead) / DreadtonDreadton (Lead) / PeepsKastonvia (Lead) / DreadtonPeeps (Lead) / Robespierrelol2639 (Lead) / KastonviaEast Isles (Lead) / lol2639


Kastonvia removed as lead on Mondays (effective 3 March 2021)
East Isles added as lead on Mondays (effective 3 March 2021)
Bobberino removed as lead on Sundays (effective 11 April 2021)
East Isles added as lead on Sundays (effective 11 April 2021)
Dreadton added as backup on Tuesdays (effective 11 April 2021)

As a note: Bobberino offered to make their own resignation post in this thread, but has instead deferred to me to make it official.

Thank you,

Robespierre (Francois Isidore)
Speaker of the Regional Assembly
 

Robespierre

The MacMilitant
-
-
-
spk_seal.png


Office of the Speaker
-~-
Dismissal of a Deputy Speaker: 20 April 2021

Citizens,

It brings me no great pleasure to announce that, pertinent to Section 3 Clause 1 of the Regional Assembly Rules, I hereby remove @lol2639 as a Deputy Speaker.

1. The Speaker may, at their discretion, appoint a citizen as Deputy Speaker. The Speaker may, at their discretion, remove an existing Deputy Speaker.​

This decision comes after the numerous attempts that have been made by both my team and I to establish contact with lol2639; attempts that were made to no avail. After a period of inactivity for over two weeks now, including a stint that nearly saw them vacate office, I feel that they've been given ample opportunities to respond to the messages that my deputies and I have sent them in the Speaker's channel and through DMs.

Although their absence was unprompted, lol2639 showed great promise early on in the term. I wish them the best of luck going forward and would be happy to have them join the Office once more in the future should their presumably busy RL schedule allow for it.

As a result of this change, the Speaker's Office must alter the schedule that it operates off of. Hereafter, our weekly schedule is as follows:

MondayTuesdayWednesdayThursdayFridaySaturdaySunday
East Isles (Lead) / RobespierreRobespierre (Lead) / DreadtonDreadton (Lead) / PeepsKastonvia (Lead) / DreadtonPeeps (Lead) / RobespierreKastonvia (Lead) / Robespierre East Isles (Lead) / Kastonvia


Kastonvia removed as lead on Mondays (effective 3 March 2021)
East Isles added as lead on Mondays (effective 3 March 2021)
Bobberino removed as lead on Sundays (effective 11 April 2021)
East Isles added as lead on Sundays (effective 11 April 2021)
Dreadton added as backup on Tuesdays (effective 11 April 2021)
lol2639 removed as lead on Saturdays (effective 20 April 2021)
Kastonvia added as lead on Saturdays (effective 20 April 2021)
Robespierre added as backup on Saturdays (effective 20 April 2021)
Kastonvia added as backup on Sundays (effective 20 April 2021)

Thank you,

Robespierre (Francois Isidore)
Speaker of the Regional Assembly
 

Robespierre

The MacMilitant
-
-
-
Will you be considering appointing another deputy or is that perhaps a conversation to have after the election?
At this point in time, I have no concrete plans to appoint another deputy. However, should someone be interested in fulfilling a role within the Office, I highly encourage them to speak with me privately and inquire.
 
Top