PROPOSAL NAME
Update treasury dashboard to reflect pre-allocated funds
TEAM DESCRIPTION
@SmartAPE | DAO member [Trust Level 3 ] | writer-of-many-words
I am an indie software developer who has been in the games industry as a gamer and game dev for over 40 years. I have designed, developed, and published over a dozen games during my career.
My first game, Battlecruiser 3000 AD (aka BC 3 K), was a ground-breaking game that was ahead of its time. Published by Take Two interactive in 1996 , it was one of their portfolio titles when they went public in 1997 . So, you could say that I helped the company succeed to where it is today.
Over the decades, I have worked with some of best software developers and publishers around the world, and my works have been featured in various online and print magazines around the world.
I am also a lifetime member of the International Game Developers Association, and was Florida chapter board member for several years.
You can learn more about me on my professional LinkedIn page.
PROPOSAL DESCRIPTION
This proposal is for the updating of the treasury dashboard on apecoin.com to accurately reflect the amounts remaining in the DAO treasury when pre-allocated funding for proposals are taken into account.
AIP- 267 : Add ‘Treasury’ tab to Apecoin.com added a “treasury dashboard” tab to apecoin.com, and was designed to do the following:
"The purpose of this proposal is to address a lack of transparency around the size of the ApeCoin DAO treasury and the rate at which treasury funds are being spent.
“This proposal requires that the “Treasury” tab include a live counter that tracks the size of the DAO treasury, the amount of the DAO treasury that has been spent, the rate of current spend of DAO funds, and the estimated time when the treasury would be depleted at the current spend rate.”
“While not required in the initial version, a future version of this page could also include a break-down of where DAO funds have been spent, including a visual representation of DAO spend by category.”
However, a vital component of this dashboard is missing. That being, the pre-allocated treasury funds set aside for passed AIPs. This value would show the actual amount of funds left in the treasury when pre-allocated funds are taken into account.
For example, as of this writing, the dashboard shows combined holdings of approx $ 169 M which does not take into account pre-allocated funding for passed AIPs. In fact, if we deducted the combined amounts from recently passed proposals since July 3 rd vote closing, we can conclude that the treasury is in fact depleted to the tune of $ 108 , 372 , 400 . 00 , and thus barely has $ 60 M (!!!) left.
AIP- 267 delegated the updating of this dashboard to the Treasury Working Group (which failed to pass at vote) and the Governance Working Group.
“Future responsibility for proposing updates to this page should fall to the Treasury Working Group, once it is created, and the Governance Working Group, in the meantime.”
$APE (as of this writing, 08 / 14 / 24 @ 11 : 01 ET) :
ape_token_metrics 1277 × 629 89 . 7 KB
BENEFIT TO APECOIN ECOSYSTEM
Transparency in the financial activities of the DAO is, now more than ever, vital to the survival of the DAO. And the treasury dashboard was designed to provide this much-needed transparency.
STEPS TO IMPLEMENT
Within 7 days of this proposal passing, the dashboard should be updated to reflect pre-allocated treasury funds culled from AIPs which have passed at vote.
The dashboard should include a break-down of the AIPs for which funds have been pre-allocated and awaiting disbursement by the APE Foundation. For example, see this table of funded AIPs maintained by the previous DAO secretary.
This section of the dashboard should denote the pre-allocated AIP funds in both $APE and $USD with data extracted from live sources.
Going forward, the dashboard should be updated following the passing of any AIP which requests funding from the DAO.
REPORTING EXPECTATIONS
The expectation is that this proposal would be implemented by the DAO’s administrative team. The community should regularly review the impact of this proposal. If accepted, the administration and the community should review the impact of the updates after the 3 -month period for conflict ends.
OVERALL COST
Total amount requested from the ApeCoin Ecosystem Fund = No Cost
Within 7 days of this proposal passing, the Foundation is expected to coordinate with Nodeblocks and update the ApeCoin DAO Treasury Dashboard to reflect pre-allocated treasury funds from AIPs which have passed at vote. The dashboard should include a breakdown of the AIPs for which funds have been pre-allocated and awaiting disbursement by the APE Foundation. This section of the dashboard should denote the pre-allocated AIP funds in both $APE and $USD with data extracted from live sources. Going forward, the dashboard should be updated following the passing of any AIP which requests funding from the DAO.
The post proposes updating the treasury dashboard on apecoin.com to accurately reflect the remaining funds in the DAO treasury, considering pre-allocated funding for passed proposals. The proposal outlines steps to implement this update within 7 days if passed, with the aim of increasing transparency in the financial activities of the DAO. The implementation cost is expected to be covered by the ApeCoin Ecosystem Fund.
DavidW: SmartAPE:
Going forward, the dashboard should be updated following the passing of any AIP which requests funding from the DAO.
I strongly agree. Without true financial information, there isn’t transparency. This one should be high on the list of priorities.
SmartAPE: SmartAPE:
AIP-267 delegated the updating of this dashboard to the Treasury Working Group (which failed to pass at vote) and the Governance Working Group.
@AllCityBAYC will you guys also be updating this without the need for this AIP?
MemeBrains: SmartAPE:
Transparency in the financial activities of the DAO is, now more than ever, vital to the survival of the DAO. And the treasury dashboard was designed to provide this much-needed transparency.
100% agreed, financial transparency is pivotal for any sort of rational decision making
If there’s a confirmed scope from the Foundation then it should be covered by whatever budgets already exist inside the various org structures of the DAO to implement some changes
Hiisver: SmartAPE:
Transparency in the financial activities of the DAO is, now more than ever, vital to the survival of the DAO. And the treasury dashboard was designed to provide this much-needed transparency.
AGREE!
Through this proactive approach to financial transparency, we aim to reinforce the DAO’s resilience, enhance stakeholder trust, and ensure that our collective resources are managed with the utmost responsibility.
SmartAPE:
Going forward, the dashboard should be updated following the passing of any AIP whic…
SmartAPE:
Going forward, the dashboard should be updated following the passing of any AIP which requests funding from the DAO.
I strongly agree. Without true financial information, there isn’t transparency. This one should be high on the list of priorities.
tbh, I am surprised that this wasn’t already in the treasury dashboard. But @LiveFast 9986 is work…
tbh, I am surprised that this wasn’t already in the treasury dashboard. But @LiveFast 9986 is working on some data tools which will hopefully feed into that dashboard since it’s the same data. You can read more about that over here DAO Secretary To Update AIP Tracking
SmartAPE:
AIP- 267 delegated the updating of this dashboard to the Treasury Working Group (wh…
SmartAPE:
AIP- 267 delegated the updating of this dashboard to the Treasury Working Group (which failed to pass at vote) and the Governance Working Group.
@AllCityBAYC will you guys also be updating this without the need for this AIP?
This one would definitely fall under the Foundation but could look at something similar for dashboa…
This one would definitely fall under the Foundation but could look at something similar for dashboard.apecoingwg.com for sure…
Let me look into this :muscle::muscle:
AC
12GAUGE.Admin - Facilitator, This user is a moderator
Aug. 20, 2024, 1:34 p.m.
Hi @SmartAPE ,
The community feedback period for your proposal would be ending in less than 24 ho…
Hi @SmartAPE ,
The community feedback period for your proposal would be ending in less than 24 hours.
If you’re content with the feedback received, your next steps are to finalize your proposal using the AIP Draft Template.
A moderator will reach out to the author to finalize the AIP Draft. Upon receipt of the final Draft, we will review and provide instructions on the next steps.
Are you ready to proceed to the next phase or do you wish to extend community discussion for another 7 days?
We look forward to hearing from you.
-@Facilitators
12GAUGE.Admin - Facilitator, This user is a moderator
Aug. 21, 2024, 1:34 p.m.
Hi ApeCoin DAO Community,
@SmartAPE has completed editing their AIP Idea to be their AIP Draft.
Thi…
Hi ApeCoin DAO Community,
@SmartAPE has completed editing their AIP Idea to be their AIP Draft.
This proposal has been assigned the AIP ID Number 506 .
Follow this Topic as further updates will be posted here in the comments.
Kind Regards,
-@Facilitators
12GAUGE.Admin - Facilitator, This user is a moderator
Aug. 24, 2024, 5:44 p.m.
Hi ApeCoin DAO Community,
Our team has reviewed and discussed @SmartAPE 's AIP Draft and have sent …
Hi ApeCoin DAO Community,
Our team has reviewed and discussed @SmartAPE 's AIP Draft and have sent a list of initial questions. We await answers.
Follow this Topic as further updates will be posted here in the comments.
Kind Regards,
-@Facilitators
12GAUGE.Admin - Facilitator, This user is a moderator
Aug. 26, 2024, 4:27 p.m.
Hi ApeCoin DAO Community,
@SmartAPE has responded to our questions and they are in our review once …
Hi ApeCoin DAO Community,
@SmartAPE has responded to our questions and they are in our review once again.
Additionally, edits have been made to this Topic, by the author, by the author’s request, or with the author’s consent.
You can click the Pencil icon at the top of the post to see these edits.
Follow this Topic as further updates will be posted here in the comments.
Kind Regards,
-@Facilitators
12GAUGE.Admin - Facilitator, This user is a moderator
Aug. 29, 2024, 1:05 p.m.
Hi ApeCoin DAO Community,
We have sent a list of follow up questions to the author.
Follow this Top…
Hi ApeCoin DAO Community,
We have sent a list of follow up questions to the author.
Follow this Topic as further updates will be posted here in the comments.
Kind Regards,
-@Facilitators
SmartAPE:
Transparency in the financial activities of the DAO is, now more than ever, vital to…
SmartAPE:
Transparency in the financial activities of the DAO is, now more than ever, vital to the survival of the DAO. And the treasury dashboard was designed to provide this much-needed transparency.
100 % agreed, financial transparency is pivotal for any sort of rational decision making
If there’s a confirmed scope from the Foundation then it should be covered by whatever budgets already exist inside the various org structures of the DAO to implement some changes
MemeBrains:
If there’s a confirmed scope from the Foundation then it should be covered by what…
MemeBrains:
If there’s a confirmed scope from the Foundation then it should be covered by whatever budgets already exist inside the various org structures of the DAO to implement some changes
The scope is as per this proposal. I have been notified, during admin review, that I need a commitment from nodeblocks (you guys) to doing this update.
Do you know how we get API access to the figure which needs to be reflected?
I’m wondering who is c…
Do you know how we get API access to the figure which needs to be reflected?
I’m wondering who is coordinating that revolving figure, and where it’s stored. We would need access to it in order to integrate with the Treasury Dashboard and before we can comment properly on the scope or costs.
No clue. I assume the data would come from the Foundation similar to all the other data used in the…
No clue. I assume the data would come from the Foundation similar to all the other data used in the dashboard.
For the other data in the dashboard we did some custom backend work and also plugged into the Coinb…
For the other data in the dashboard we did some custom backend work and also plugged into the Coinbase API
For this update above, if someone wanted to (Foundation or otherwise) commit to tracking and updating all the data into even a simple google spreadsheet possibly, we could potentially just plug that data into the Dashboard. Any mistake on the spreadsheet however would result in a mistake displayed on the Dashboard so it would need to be properly maintained.
Therein lies the rub. Nobody is actually tracking any of that. Plus, for some reason, our new @Boja…
Therein lies the rub. Nobody is actually tracking any of that. Plus, for some reason, our new @BojangleGuy.Admin hasn’t released transparency reports for this year probably because he doesn’t have the data. Which is why I wrote AIP- 507 : APE Foundation DAO Transparency Reports
MemeBrains:
For this update above, if someone wanted to (Foundation or otherwise) commit to tracking and updating all the data into even a simple google spreadsheet possibly, we could potentially just plug that data into the Dashboard. Any mistake on the spreadsheet however would result in a mistake displayed on the Dashboard so it would need to be properly maintained.
In my AIP- 508 : Update AIP Tracking Data proposal, I had required the secretary to update this data, only to learn that it wasn’t actually his job. And so, as of this writing, nobody actually knows whose job it is, other than to just say APE Foundation and let them figure it out back there.
Then I later learned that our resident data guy @LiveFast 9986 was actually working on precisely this aspect behind-the-scenes, which he formally made public as a result of my AIP- 508 discussion. You can find his data at ApeCoin AIP Information Dashboard (WIP)
To that end, obtaining the allocated funds data from his spreadsheet would work just as well since that data is pulled from the passed proposals.
However, we wouldn’t know how much of the funds have actually been disbursed because, as you well know, it can take several weeks - and sometimes months - for funds to be disbursed. And now that we’re making tranche funding the standard as per Facilitator Note # 20 : Apes Gotta’ Eat we also now have to take that into account.
In conclusion:
Funding amounts allocated can be derived from passed proposals via the LiveFast data metrics
Funding amounts disbursed can be obtained directly from the Foundation. Perhaps LiveFast can actually obtain this data himself since he has access to GwG such as @AllCityBAYC
Over the last few weeks and months, I’ve started to wonder if it would be in the DAO’s best interes…
Over the last few weeks and months, I’ve started to wonder if it would be in the DAO’s best interest to take me on full-time to start tracking and maintaining this stuff in a spreadsheet.
SmartAPE: Indeed. As I mentioned in my other AIP, I had no idea that you were actually doing so much work behind-the-scenes. This is data that the DAO needs; and so, in very much the same way that the Foundation hires attorneys, accountants and a variety of other service providers without an AIP, I don’t see why they can’t engage you to do this work. Which is precisely why my proposal puts the onus on the administrative team to get this done.
I suggest that you engage them with now in this regard. Then, between you and membrains team at Nodeblocks, we can get it done efficiently.
Note: as part the Q&A during admin review, I was asked if the Nodeblocks team had agreed to do the work, and if so, they would require a new contract for specifically this. To which I responded that I had in fact been in touch with memebrains team who have agreed to do the dashboard work. So, I believe that your efforts would also fall under the same guidance in that the Foundation would be funding both aspects. tbh, I have no idea why I even needed to write a proposal to do this; but here we are.