# PI issues today

**URL:** <https://forums.eveonline.com/t/pi-issues-today/466148>\
**Category:** EVE x Microsoft Excel Add-in\
**Created:** [October 29, 2024, 3:18am UTC](https://forums.eveonline.com/t/pi-issues-today/466148 "2024-10-29T03:18:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sara\_Seraph](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/sara_seraph/32/495525_2.png) [@Sara\_Seraph](https://forums.eveonline.com/u/Sara_Seraph)\
**Post date:** [October 29, 2024, 3:18am UTC](https://forums.eveonline.com/t/pi-issues-today/466148/1 "2024-10-29T03:18:44Z")

</div>

So I am tired of waiting on OZ\_eve to do a PI sheet and podcast, 😀

My sheets have been having issues all day, I figure most are from me constantly asking the server to update my PI information as I copy or move the formula all over the page.

I am trying to locate PI products I have throughout the galaxy, so in item hangers, corps hangers, contracts, even ship cargo holds, and then sum that up to give me how much I need to place a buy order to cover next month.

Excel crash maybe five or six times throughout the World Series…

as I type this forum entry…

EVEONLINE.CHARACTER\_PLANETS(me), to get the colonies and the ID, then  
EVEONLINE.CHARACTER\_PLANT(me,Planet) has been stuck in the #busy! mode.

Just a note.  
Sara

---

<div class="post-metadata">

**Author:** ![Orthel\_Toralen](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/orthel_toralen/32/394544_2.png) [@Orthel\_Toralen](https://forums.eveonline.com/u/Orthel_Toralen)\
**Post date:** [November 4, 2024, 3:21pm UTC](https://forums.eveonline.com/t/pi-issues-today/466148/2 "2024-11-04T15:21:30Z")

</div>

The PI endpoint for the ESI is famously lousy. PI information only updates when you actually check it in game. It will usually be wrong. I suspect it’s cycling busy because the ESI is throwing errors back at the Excel plug in.

---

<div class="post-metadata">

**Author:** ![Sara\_Seraph](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/sara_seraph/32/495525_2.png) [@Sara\_Seraph](https://forums.eveonline.com/u/Sara_Seraph)\
**Post date:** [November 4, 2024, 4:43pm UTC](https://forums.eveonline.com/t/pi-issues-today/466148/3 "2024-11-04T16:43:41Z")

</div>

Is the PI interface done: or is there updates coming to the spreadsheet?

The cycling busy seems to have also been tied into my network ISP being very poor that day.

Having to actually view it in-game ‘before’ it updates in the spreadsheet…? As contracts are delivered and moved around the spreadsheet will update but there seems to be some type of delay, similar to the server bounty ticks.

---

<div class="post-metadata">

**Author:** ![Orthel\_Toralen](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/orthel_toralen/32/394544_2.png) [@Orthel\_Toralen](https://forums.eveonline.com/u/Orthel_Toralen)\
**Post date:** [November 8, 2024, 10:51pm UTC](https://forums.eveonline.com/t/pi-issues-today/466148/4 "2024-11-08T22:51:29Z")

</div>

Unfortunately, this is a limitation of CCPs ESI endpoint for PI, not the spreadsheet app.

 ![image](https://global.discourse-cdn.com/eveonline/original/4X/f/e/9/fe9dbe2f320e97b413371e25c915f9ec5b1a8b85.png)

The Excel plug-in can only return what the ESI will give, it. You can find the documentation for the ESI here if you want to understand more about what’s going on under the hood.

[https://esi.evetech.net/ui/](https://esi.evetech.net/ui/)
