Latest Contributions by JayLarsen

‎03-14-2023

Thanks! I'll try ASAP!

‎03-08-2023

I was using my old machine with the old Excel plugin v2020.1.2 as it has a easy workflow we use quite a lot. Everything works and renders, but I could not upload the map or layer? Is something broken somewhere? Did they turn off this product as the new M365 plug is out? (Which breaks our vital workflow...)

‎03-08-2023

Actually, the "turning it into a pivot table" thing is critical problem. We often make large custom tables, with ZIP the first column, and the name of a location the rest of the columns. That way with one table upload, we can do a style for each column--huge timesaver. The nonsense pivot table destroys this ability. Is there a way to avoid making the pivot table--as there used to be before the AppSource and 2022.1? The alternative workflow is load the excel file table up to AGOL, make it service, put it in a map, then do a JOIN with ZIP layer. But this is a lot more typing and fussing than it used to be, and quite time-consuming. Any other ideas?

‎02-23-2023

I figured out the workflow myself. It actually makes sense, but is way different than the old way. This plugin version has a drop-down menu for location type, so select "Geography". Then select 2022 ZIP Codes. This defaults weirdly to USA_Country, so change it back to USA_ZIP_Code. Then select the next drop-down selector for "ZIP Code" which is the field in the geography layer to bind to the ZIP column in your excel data. Weirdly, it forces you to turn it into a pivot table, and then select the column to style by. So, I can use it. But turning it into a pivot table clobbers the labels, which is not great. If I can get using the Office365 version, I hope it is better? Or at least as good? So, I don't have to try and make a support case with ESRI! But if anybody has more knowledge or comments, please reply as I'd love to get them.

‎02-23-2023

No worries. I figured it out myself. I was confused because the NEW workflow makes sense and involves no hidden weird features--unlike the old one. Wow, that Excel plugin really had a lot of features added for 2022.1. Too bad it's already DOA for the Office365 version--which I hope I can get working at some point. Thanks! Good luck!

‎02-23-2023

Hi! Saw this answer and wondered if you know the workflow for a ZIP choropleth map using just the Excel plugin from ArcGIS for Office v2022.1?

‎02-23-2023

Hello. We have a very important workflow we do all the time in the previous versions of the ArcGIS for Office plugins. I finally had to get a new computer, and installed foung out we CANNOT use the new "Office 365" version of the Excel plugin, so we have to use the legacy 2022.1 version. This version does not seem to support our workflow for making quick choropleth maps from ZIP data. Previously, we could add a new "location type" in the old plugin, and select the ESRI ZIP shapes from the browser, and then select that new location type and make the map. There seems to be no way to add to location types in the new 2022.1 plugin? Am I missing something? Anybody know the workflow now? If we can authorization to run the Office365 version, does it support the workflow I mentioned? (Yes, I know I can go into AGOL, upload a table of my ZIP data, and then do a JOIN to the ZIP outlines, but this is very time-consuming and inconvenient for my users.) Any help?

‎08-10-2022

OH....in that case, do you have the rights to extract data? It is a specific right that must be granted on layers, etc.

‎08-10-2022

I get this occasionally as well. Always at the wrong moment. I can never tell if it is me and my corporate firewalls or ESRI being weird. Logging in and out of AGOL and/or the computer sometimes clears it. Sometimes just keep hitting "redo" button or setting up the calc again does it. Very frustrating! Good luck!

‎06-01-2022

Thanks! I can hardly wait...I've never been in this biz with ESRI during a census year!

‎06-01-2022

When will ESRI release their proprietary 2022 USA demographics projections? I assume this will not be the US Census data, which will be in a separate release and series? Usually ESRI releases sometime around UC...is that still the case?

‎03-08-2022

Yeah, this is an old bug I reported years ago, which they had fixed, but it seems broken again as of a few months ago. Seems to affect old map viewer and new one. Please fix again, ESRI! This bug makes group work in AGOL very frustrating!

‎02-23-2022

I was hoping to use Plan Routes for a problem, but the parameters don't seem to allow it? Anybody do anything like: 1. Drivers may start from same HQ building, but I don't care where they end up? Can just hit return to start, but not not necessary. 2. I have a 8 drivers, but I don't care how many hours or days it takes to complete a route. That is, I know they will take multiple days, and I just need to split among 8-10 consultants that will hit the targets over a period of a month or whatever it takes. Is there a way to set up parameters so that I could get answers?

‎02-23-2022

Yeah, absurdly to some degree, the Office plugins don't understand even a simple crosstab. You only see the total column. I don't think they ever fixed this? So, we still have to copy/paste into text, turn to Excel table, then use Office plugins. I can understand the thing not understanding complex, more than 1 level crosstabs, but sheesh.

‎10-13-2021

I hope not!!! It's the only way to do calculations. And I find the new UI in the new thing to be crazy. Cheers!

Online Status	Offline
Date Last Visited	3 weeks ago

My Ideas

Latest Contributions by JayLarsen

Re: Is old Excel plugin 2020.1.2 broken now?

Is old Excel plugin 2020.1.2 broken now?

Re: make choropleth ZIP map in Excel plugin v2022.1

Re: make choropleth ZIP map in Excel plugin v2022.1

Re: Can't create a choropleth map - just get the points - why?

Re: Can't create a choropleth map - just get the points - why?

make choropleth ZIP map in Excel plugin v2022.1

Re: Unnamed "error" after every attempt to use "analyze" in ArcGIS Online

Re: Unnamed "error" after every attempt to use "analyze" in ArcGIS Online

Re: release of 2022 ESRI data

release of 2022 ESRI data

Re: Layer does not updated sharing in web map

Use Plan Routes not caring about total time?

Re: Maps for Office Pivot Table Missing Fields

Re: Classic Map Viewer EOL

creating new hosted feature from existing is weird...

Re: City Code

Re: Hosted Feature Layer Error: There was an error...

Re: how to get ESRI demographics by city?

how to get ESRI demographics by city?