{"store":{"baseInfo":{"podcastTitle":"Unpivot","slug":"unpivot","podcastDescription":"Light-hearted discussion about Excel and Power BI - aimed at the business users of the world","podcastLogo":"https://pbcdn1.podbean.com/imglogo/image-logo/18598305/3000.jpg","podcastShareLogo":"https://d2bwo9zemjwxh5.cloudfront.net/image-logo/18598305/3000_1200x628.jpg?s=be50b5e4a30fc27bd5a1148c3e55dc80&e=jpg","podcastUrl":"https://unpivot.podbean.com","podcastCanSearched":true,"feedUrl":"https://feed.podbean.com/unpivot/feed.xml","theme":"frontrow3","podcastDeepLink":"https://www.podbean.com/pw/pbblog-7jfwm-11bc9a1?from=usersite","removePodbeanBranding":"no","brandingLogo":null,"timeZone":{"timeZoneId":67,"gmtAdjustment":"GMT+08:00","useDaylightTime":0,"value":8,"text":"(GMT+08:00) Perth","daylightStartTime":"Second Sunday Of March +2 Hours","daylightEndTime":"First Sunday Of November +2 Hours","timezone":null},"podcastDownloads":8994,"totalEpisodes":28,"showComments":true,"iOSAppDownloadLink":null,"customizeCssUrl":null,"androidAppDownloadLink":null,"showPostShare":true,"showLike":true,"author":"UnpivotShow","enableEngagementStats":true,"shareEmbedLink":"https://admin5.podbean.com/embed.html?id=pbblog-7jfwm-11bc9a1-playlist","language":"en","sensitivitySessionExpireTime":3600,"podcastApps":[{"name":"Apple Podcasts","link":"https://podcasts.apple.com/us/podcast/unpivot/id1755670498","image":"https://pbcdn1.podbean.com/fs1/site/images/admin5/apple-podcast.png","title":null},{"name":"Podbean App","link":"https://www.podbean.com/pw/pbblog-7jfwm-11bc9a1?from=usersite","image":"https://pbcdn1.podbean.com/fs1/site/images/admin5/podbean-app.png","title":null},{"name":"Spotify","link":"https://open.spotify.com/show/4EYX2SFt4BQ80EZ6SKzhRK","image":"https://pbcdn1.podbean.com/fs1/site/images/admin5/spotify.png","title":null},{"name":"Amazon Music","link":"https://music.amazon.com/podcasts/e2dc47e0-d0c8-4e04-bba8-d90ad8fe1e40","image":"https://pbcdn1.podbean.com/fs1/site/images/admin5/AmazonMusic.png","title":null},{"name":"Podchaser","link":"https://www.podchaser.com/podcasts/unpivot-5783587","image":"https://pbcdn1.podbean.com/fs1/site/images/admin5/Podchaser.webp","title":null}],"components":{"base":[{"id":"MainStyle","val":"light"},{"id":"Font","val":"Lato"},{"id":"SecondaryFont","val":"Lato"},{"id":"PlayerColor","val":"#8fc31f"},{"id":"PlayerStyle","val":"player1"},{"id":"PlayerWave","val":"show"},{"id":"Favicon","val":null},{"id":"CookiesNotice","val":"hide"},{"id":"CookiesNoticeContent","val":"

Cookies Notice

This website uses cookies to improve your experience while you navigate through the website. By using our website you agree to our use of cookies.

"}],"home-header":[{"id":"HomeHeaderTextColor","val":"#ffffff"},{"id":"BackgroundImage","val":"https://mcdn.podbean.com/mf/web/4j67j823dp2b67zg/Thin_Full_Background8a82e281-f120-897e-8e15-aeea6f48cf71.jpeg"},{"id":"BackgroundImageForMobile","val":"https://mcdn.podbean.com/mf/web/g7ajq2bwesig7vgf/Streamyard_Background2390957c-650b-6be5-87d6-ff4f8a84355d.jpg"}],"episode-list":[{"id":"EpisodeListType","val":"list"},{"id":"EpisodesPerPage","val":8},{"id":"EpisodeStats","val":"show"}],"navigation":[{"id":"NavigationFontColor","val":"#FFFFFF"},{"id":"NavigationBackgroundColor","val":"#000000"},{"id":"NavigationSearch","val":"show"},{"id":"NavigationLinks","val":[{"id":"Home","type":"Link","value":"/","text":"Home","subitems":[]},{"id":"Subscribe","type":"Link","value":"https://www.podbean.com/site/podcatcher/index/blog/15andgHaAuDq","text":"Subscribe","subitems":[]},{"id":"Profile","type":"Link","value":"https://www.podbean.com/user-OkE2A1ca6uz2","text":"Profile","subitems":[]}]}],"footer":[{"id":"FooterType","val":"Footer1"},{"id":"FooterFontColor","val":"#ffffff"},{"id":"FooterBackgroundColor","val":"#000000"},{"id":"FooterCopyright","val":"Copyright 2024 All rights reserved."},{"id":"SocialMediaLinks","val":{"facebook_username":"","twitter_username":"","instagram_username":"","youtube_username":"","linkedin_username":""}}],"customize-container1":[],"customize-container2":[{"id":"ComponentImageText-1","val":{"ComponentFontColor":"#000000","ComponentBackgroundColor":"#FFFFFF","ComponentImage":"https://mcdn.podbean.com/mf/web/2fc6c5u26dft3zgz/The_team_Custom_afa2bf16-f1fa-e8a2-b812-c9bde1c53590.png","ComponentContent":"

The Cast

Wyn Hopkins (Australia)

Mark Proctor (UK)

Sue Bayes (UK)

Giles Male (UK)

"}}]},"allLinks":[],"mainStylesDefaultSettings":null,"defaultCustomizeComponents":null,"scripts":[],"metas":null,"appConfig":{"package":"com.podbean.app.podcast","app_store_id":973361050,"app_name":"Podbean","scheme":"podbean"},"customizeCss":null,"canEditCss":null,"enableJsCodeInCustomizeContent":false,"enabledIframeCodeInCustomizeContent":true,"sectionMaxCount":10,"enableEditorLink":true,"enableEditCookiesNotice":true,"siteRedirectToFeed":false,"podcatcherRssUrl":"https://www.podbean.com/site/podcatcher/index/blog/15andgHaAuDq","showFeed":true,"showTopBar":true,"enableWebSiteLike":true,"organizationName":null,"organizationPageLink":null},"backToListUrl":"/","tinymceLoaded":false,"listEpisodes":[],"userLikedEpisodes":[],"userLikeCheckedEpisodes":[],"topBarIframeLoaded":false,"listTotalCount":0,"listTotalPage":0,"listPage":0,"listType":"all","listValue":"","listName":"","pageLoading":false,"apiBaseUrl":"https://unpivot.podbean.com","apiCommonParams":{"t":"6844e44b","clientSignature":"8ab7d0d4c87e6c5e46f85b2beb403142","u":null,"customizing":null},"apiCommonHeaders":{},"comments":[],"commentsTotalCount":0,"commentsTotalPage":0,"commentsPage":1,"commentEpisodeId":"pb23930625-wih9h","episode":{"id":"pb23930625","idTag":"wih9h","title":"Essential Functions and when formulas go wrong","logo":"https://pbcdn1.podbean.com/imglogo/image-logo/18598305/3000_300x300.jpg","shareLogo":"https://d2bwo9zemjwxh5.cloudfront.net/image-logo/18598305/3000_1200x628.jpg?s=be50b5e4a30fc27bd5a1148c3e55dc80&e=jpg","largeLogo":"https://pbcdn1.podbean.com/imglogo/image-logo/18598305/3000.jpg","previewContent":null,"content":"

Links mentioned:

Data Scotland: https://datascotland.org/

Chris Barber: https://www.starschema.co.uk/

Hosts Wyn Hopkins,, Sue Bayes, Giles Male, and Mark Proctor.

YouTube

","publishTimestamp":1726296121,"duration":4187,"mediaUrl":"https://mcdn.podbean.com/mf/web/n7sd94ujnz63p9is/Episode7.mp3","mediaType":"audio/mpeg","shareLink":"https://admin5.podbean.com/embed.html?id=pb-wih9h-16d2701","likedCount":2,"deepLink":"https://www.podbean.com/ew/pb-wih9h-16d2701","transcriptUrl":null,"permalink":"/e/critical-functions-and-when-formulas-go-wrong/","downloadLink":"https://www.podbean.com/media/share/pb-wih9h-16d2701?download=1","fallbackResource":null,"fallbackResourceMimetype":null,"downloadCount":340,"status":"publish","hasMoreContent":false,"chaptersUrl":null,"explicit":false},"episodeShareLink":null,"deepLink":"https://www.podbean.com/ew/pb-wih9h-16d2701","playlist":{"episodes":[],"current":0,"start":0,"stop":0,"playing":true,"playerLoading":true,"playbackRate":1,"playbackRateIndex":1},"toasts":[],"confirm":null,"customizeEditorFormZIndex":999,"lastRequestTime":null,"validateChangesOnBeforeunload":true,"windowWidth":1000,"VITE_FS1_CDN_URL_PREFIX":"https://pbcdn1.podbean.com/fs1","reloadStats":false,"userIdEncrypted":null,"userProfilePicture":null,"username":null,"isVerified":false,"loadUserInfo":false,"loginUrl":"https://www.podbean.com/site/user/login?return=https%253A%252F%252Funpivot.podbean.com%252Fe%252Fcritical-functions-and-when-formulas-go-wrong%252F&rts=6ec1b330e0e2f3c4b4d3d505a2a32bc36ec6368f","recaptchaV3Loaded":false,"recaptchaV2Loaded":false,"likesLoaded":false,"commentLikeMap":{},"commentOffset":0},"episode":{"id":"pb23930625","idTag":"wih9h","title":"Essential Functions and when formulas go wrong","logo":"https://pbcdn1.podbean.com/imglogo/image-logo/18598305/3000_300x300.jpg","shareLogo":"https://d2bwo9zemjwxh5.cloudfront.net/image-logo/18598305/3000_1200x628.jpg?s=be50b5e4a30fc27bd5a1148c3e55dc80&e=jpg","largeLogo":"https://pbcdn1.podbean.com/imglogo/image-logo/18598305/3000.jpg","previewContent":null,"content":"

Links mentioned:

Data Scotland: https://datascotland.org/

Chris Barber: https://www.starschema.co.uk/

Hosts Wyn Hopkins,, Sue Bayes, Giles Male, and Mark Proctor.

YouTube