{"id":32307,"date":"2024-11-24T18:15:02","date_gmt":"2024-11-25T02:15:02","guid":{"rendered":"https:\/\/www.podfeet.com\/blog\/?p=32307"},"modified":"2024-11-24T18:15:02","modified_gmt":"2024-11-25T02:15:02","slug":"nc-1020","status":"publish","type":"post","link":"https:\/\/www.podfeet.com\/blog\/2024\/11\/nc-1020\/","title":{"rendered":"NC #1020 EV Pivot Table Fun, Sign Documents from iOS and macOS, Take My Money, Security Bits"},"content":{"rendered":"<p>Hi, this is Allison Sheridan of the NosillaCast Apple Podcast, hosted at Podfeet.com, a technology geek podcast with an EVER so slight Apple bias. Today is  Sunday, November 24, 2024,  and this is show number 1020.<\/p>\n<audio class=\"wp-audio-shortcode\" id=\"audio-32307-1\" preload=\"none\" style=\"width: 100%;\" controls=\"controls\"><source type=\"audio\/mpeg\" src=\"https:\/\/media.blubrry.com\/nosillacast\/traffic.libsyn.com\/nosillacast\/NC_2024_11_24.mp3?_=1\" \/><a href=\"https:\/\/media.blubrry.com\/nosillacast\/traffic.libsyn.com\/nosillacast\/NC_2024_11_24.mp3\">https:\/\/media.blubrry.com\/nosillacast\/traffic.libsyn.com\/nosillacast\/NC_2024_11_24.mp3<\/a><\/audio>\n<p><a title=\"mp3 download\" href=\"https:\/\/media.blubrry.com\/nosillacast\/traffic.libsyn.com\/nosillacast\/NC_2024_11_24.mp3\" target=\"_blank\" rel=\"noopener noreferrer\">mp3 download<\/a><\/p>\n<h3><a href=\"https:\/\/shows.acast.com\/kilowatt\/episodes\/ev-data-made-fun-with-allison-sheridan\" target=\"%5Fblank\" rel=\"noopener\">Kilowatt: EV Data Made Fun with Allison Sheridan<\/a><\/h3>\n<p>You know I love me a good pivot table, right? Well, I found a nifty website from the U.S. Department of Energy that includes a treasure trove of data on EVs and chargers. Of course I told Bodie Grimm of the Kilowatt Podcast about it and I showed him how I took some downloads of data and made a pivot table to see the progress in Level 3 chargers over the past year. He thought this was cool and asked me to come on his show to talk about the data set and how pivot tables helped me analyze this treasure trove of data.<\/p>\n<p>We had a blast (how could you not when talking to Bodie AND getting to nerd out on data?) You can find the episode at the link in the shownotes, or subscribe to the Kilowatt podcast in your podcatcher of choice and look for the episode entitled, &#8220;EV Data Made Fun with Allison Sheridan&#8221;.<\/p>\n<p>I put a <a href =\"https:\/\/1drv.ms\/x\/s!Ahm2TQrc8G9Uq2H8-A7FTLxxbOOc?e=De5OZX\" target=\"_blank\" rel=\"noopener\">link in the shownotes to the pivot table spreadsheet<\/a> I talked about during the conversation with Bodie. There are two tabs with the raw data dump from the DOE about Level 3 chargers for October 2023 and 2024, then two pivot tables for each of the raw data sets. The front page compares the two pivot tables to show the growth by each company in number of chargers.<\/p>\n<p>If you&#8217;d like to download your own data set the <a href =\"https:\/\/afdc.energy.gov\/data_download\" target=\"_blank\" rel=\"noopener\">Alternative Fuels Data Center site from the US DOE<\/a>, check out the link in the shownotes.<\/p>\n<h4><a href =\"https:\/\/pbs.bartificer.net\/pbs173\" target=\"_blank\" rel=\"noopener\">PBS 173 of X: Getting Started with Submodules (Git)<\/a><\/h4>\n<h3>Articles<\/h3>\n<h4><a href=\"https:\/\/www.podfeet.com\/blog\/2024\/11\/sign-docs\/\">How to Sign Documents on macOS and iOS Without Saving Any Files<\/a><\/h4>\n<h4><a href=\"https:\/\/www.podfeet.com\/blog\/2024\/11\/stripe-applepay\/\">Take My Money!<\/a><\/h4>\n<h3><a href=\"https:\/\/podfeet.com\/donate\">Support the Show<\/a><\/h3>\n<p>I bet you&#8217;re wondering what I&#8217;m going to talk about during my quick Support the Show segment, aren&#8217;t you?  Hey I have a wild and crazy idea, how about you go to <a href =\"https:\/\/podfeet.com\/donate\" target=\"_blank\" rel=\"noopener\">podfeet.com\/donate<\/a> and try out my fancy new Apple Pay method of donating money to support the show? Or if you&#8217;re not an Apple Pay person you could use a normal credit card.  You know it would be swell if some people tested this out for me, for research purposes of course&#8230;<\/p>\n<h4><a href=\"https:\/\/www.podfeet.com\/blog\/2024\/11\/sb-2024-11-24\/\">Security Bits \u2014 24 November 2024<\/a><\/h4>\n<h4><a href=\"https:\/\/podfeet.com\/transcripts\/NC_2024_11_24.html\">Transcript of NC_2024_11_24<\/a><\/h4>\n<p>That&#8217;s going to wind this up for this week. Did you know you can email me at <a href=\"mailto:allison@podfeet.com\">allison@podfeet.com<\/a> any time you like? If you have a question or a suggestion just send it on over.  Remember, everything good starts with podfeet.com. You can follow me on Mastodon at <a href=\"https:\/\/chaos.social\/@podfeet\">podfeet.com\/mastodon<\/a>.  If you want to listen to the podcasts on YouTube, you can go to <a href=\"https:\/\/podfeet.com\/youtube\" target=\"_blank\" rel=\"noopener\">podfeet.com\/youtube<\/a>. If you want to join the conversation, you can join our Slack community at  <a href=\"http:\/\/podfeet.com\/slack\" target=\"_blank\" rel=\"noopener\">podfeet.com\/slack<\/a> where you can talk to me and all of the other lovely NosillaCastaways. You can support the show at <a href=\"https:\/\/www.patreon.com\/podfeet\" target=\"_blank\" rel=\"noopener\">podfeet.com\/patreon<\/a> or with a one-time donation at <a href=\"https:\/\/podfeet.com\/donate\">podfeet.com\/donate<\/a> with Apple Pay or any credit card, or through <a href=\"https:\/\/www.paypal.me\/podfeet\" target=\"_blank\" rel=\"noopener noreferrer\">podfeet.com\/paypal<\/a>.\u00a0 And if you want to join in the fun of the live show, head on over to <a href=\"http:\/\/podfeet.com\/live\">podfeet.com\/live<\/a> on Sunday nights at 5 PM Pacific Time and join the friendly and enthusiastic NosillaCastaways.\u00a0\u00a0 Thanks for listening, and stay subscribed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, this is Allison Sheridan of the NosillaCast Apple Podcast, hosted at Podfeet.com, a technology geek podcast with an EVER so slight Apple bias. Today is Sunday, November 24, 2024, and this is show number 1020. mp3 download Kilowatt: EV Data Made Fun with Allison Sheridan You know I love me a good pivot table, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":11358,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[147,173,1],"tags":[1095,3405,4804,50,569,4516],"class_list":["post-32307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-posts","category-nosillacast","category-podcasts","tag-apple-pay","tag-electric-vehicles","tag-pivot-tables","tag-security","tag-security-bits","tag-signature"],"jetpack_featured_media_url":"https:\/\/www.podfeet.com\/blog\/wp-content\/uploads\/2017\/04\/square_skyline_2017.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts\/32307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/comments?post=32307"}],"version-history":[{"count":5,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts\/32307\/revisions"}],"predecessor-version":[{"id":32345,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts\/32307\/revisions\/32345"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/media\/11358"}],"wp:attachment":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/media?parent=32307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/categories?post=32307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/tags?post=32307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}