Comment by ivirshup
5 years ago
Were you using excel to translate their data to the map, or some external script to create the file? If it's the latter, why not use a plotting library? If it's the former, how did you acquire this unholy power?
5 years ago
Were you using excel to translate their data to the map, or some external script to create the file? If it's the latter, why not use a plotting library? If it's the former, how did you acquire this unholy power?
Not sure what you mean by plotting library but I cannot install any software so all I could use was Excel
> Not sure what you mean by plotting library but I cannot install any software so all I could use was Excel
I believe you, but isn't it baffling that your superiors couldn't recognize that giving you access to some Python or whatever would vastly improve your productivity, what you produce, and your happiness, all for a grant total of €0 and some de-rigidifying of arbitrary rules?
Generally these rules are institutional policy which are there for legal or security reasons. In a 1000-person organization, preventing 990 of them from installing malware is more important than allowing 10 of them to be more productive. A middle-manager does not have the ability to change that policy.
I was thinking something like matplotlib or gnuplot, but I think we may exist in very different ecosystems.
But also, thinking about this a bit more, doesn't excel have the ability to plot geographic data?
Imagine using python without pip or conda. That's what using excel vba feels like.
All the data is in the spreadsheet. When it gets updated so does the map view (along with a bunch of other charts)