<?xml version='1.0' encoding='UTF-8'?><rss xmlns:atom="http://www.w3.org/2005/Atom" xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/" xmlns:blogger="http://schemas.google.com/blogger/2008" xmlns:georss="http://www.georss.org/georss" xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr="http://purl.org/syndication/thread/1.0" version="2.0"><channel><atom:id>tag:blogger.com,1999:blog-41055356227119045</atom:id><lastBuildDate>Mon, 07 Oct 2024 06:01:03 +0000</lastBuildDate><category>custom graphs</category><category>account selection</category><category>peer groups</category><category>save time</category><category>custom built</category><category>share</category><category>CRC</category><category>Excel</category><category>analysis</category><category>benchmarking</category><category>built-in displays</category><category>dynamic</category><category>formatting</category><category>formula wizard</category><category>formulas</category><category>jedi</category><category>loan portfolio</category><category>static</category><category>user error</category><category>5300</category><category>CUtv</category><category>First Look</category><category>Peer 2.0</category><category>YTD</category><category>alpha listing</category><category>column charts</category><category>data formats</category><category>decisions</category><category>efficiency</category><category>error message</category><category>investments</category><category>leader table</category><category>mortgages</category><category>personnel</category><category>shares</category><category>simple</category><category>standing report</category><category>suppliers</category><category>test</category><title>Peerific</title><description>This blog covers the really cool things users can do with Peer-to-Peer 2.0, a credit union financial analysis tool created by Callahan &amp;amp; Associates, Inc.</description><link>http://peerific.blogspot.com/</link><managingEditor>noreply@blogger.com (Alix)</managingEditor><generator>Blogger</generator><openSearch:totalResults>26</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-8422887663063882949</guid><pubDate>Fri, 28 Aug 2009 13:38:00 +0000</pubDate><atom:updated>2009-08-28T17:13:43.871-04:00</atom:updated><title>2Q Data is Live!</title><description>Info online at &lt;a href=&quot;http://www.p2psoftware.com/P2P/DataLive.asp&quot;&gt;http://www.p2psoftware.com/P2P/DataLive.asp&lt;/a&gt;</description><link>http://peerific.blogspot.com/2009/08/2q-data-is-live.html</link><author>noreply@blogger.com (Alix)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-3375384713287956014</guid><pubDate>Wed, 19 Aug 2009 18:46:00 +0000</pubDate><atom:updated>2009-08-19T14:47:34.945-04:00</atom:updated><title>Strong Performance in 2Q by the $1B+ Peer Group</title><description>&lt;p&gt;At June, there are 154 credit unions in the &quot;Billion Dollar Club.&quot; &lt;a href=&quot;http://www.creditunions.com/Data/firstlook/firstlook.aspx&quot;&gt;Callahan&#39;s  First Look&lt;/a&gt; program provides early insight into the performance of the  nation’s largest credit unions. These represent roughly 44% of all credit union  assets. View the entire list &lt;a href=&quot;http://www.creditunions.com/Data/firstlook/firstlook.aspx&quot;&gt;here&lt;/a&gt;.&lt;/p&gt; &lt;p&gt;Most of these credit unions (124) saw positive member growth, with Alliant  (IL) posting the largest gain of 17.6%, nearly tripling the group&#39;s average of  6%. Patelco (16.7%) and SchoolsFirst (14.6%), both in California, come in second  and third at success in attracting new members. (While mergers contributed to  the growth of some credit unions we have removed credit unions whose mergers  were the dominant factor in their annual growth.)&lt;/p&gt; &lt;p&gt;Trumark Financial (PA) led the group in share growth, posting an increase of  35.4%. Right behind was Teachers (NY) with 30.4% and Anheuser-Busch Employees  (MO) with 28.9%. The distribution of share growth had greater variation than  member growth, as some credit unions pulled back on share promotions to preserve  their capital ratio. Beyond increased personal savings rates, Anheuser-Busch  Employees saw increased flows due to Anheuser-Busch&#39;s sale (and the resulting  stock sale) to InBev. Twenty-three credit unions saw a decline in total  shares.&lt;/p&gt; &lt;p&gt;The fastest growth on the share side came from IRA/Keoghs (18.2% annual  growth) and money market accounts (13.8%). Over 50 of the Billion Dollar Club  credit unions now offer Health Savings Accounts (included in the share totals  above).&lt;/p&gt; &lt;p&gt;On the lending side, four credit unions grew their loan portfolios by more  than 20% for the 12 months ending June 2009:&lt;/p&gt; &lt;ol&gt;&lt;li&gt;Public Service Employees (CO) 25.73%  &lt;/li&gt;&lt;li&gt;Randolph-Brooks (TX) 21.97%  &lt;/li&gt;&lt;li&gt;Teachers (NY) 20.66%  &lt;/li&gt;&lt;li&gt;Chevron (CA) 20.48% &lt;/li&gt;&lt;/ol&gt; &lt;p&gt;Mortgages were a primary but not exclusive factor in their growth. A diverse  strategy across a variety of products, including auto and business loans,  propelled these credit unions to the top of this list. The top three credit  unions above grew auto loans double digits with Teachers nearly doubling their  portfolio from last year.&lt;/p&gt; &lt;p&gt;Record 1st mortgage sales on the secondary market did keep balance sheet loan  growth down for some, even as origination volume soared. Bank-Fund Staff (DC)  posted an almost two-fold growth in loan originations and is on pace to exceed  its record loan originations set in 2003.&lt;/p&gt;</description><link>http://peerific.blogspot.com/2009/08/strong-performance-in-2q-by-1b-peer.html</link><author>noreply@blogger.com (Alix)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-6049209071390808936</guid><pubDate>Mon, 03 Aug 2009 12:30:00 +0000</pubDate><atom:updated>2009-08-03T08:30:00.796-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">alpha listing</category><category domain="http://www.blogger.com/atom/ns#">custom built</category><category domain="http://www.blogger.com/atom/ns#">custom graphs</category><category domain="http://www.blogger.com/atom/ns#">leader table</category><title>First Look Data is ready! A Look at Alpha &amp; Leader Tables</title><description>Sorry for the absence--I was waiting for First Look data to continue my custom graphing explanation. OK, OK...that&#39;s not true...I just got behind on other things and neglected the blog. I apologize to the Custom Graphing Jedi-in-training. I hope you continued your studies while I was gone.&lt;br /&gt;&lt;br /&gt;But, it is true that First Look is ready. I just &lt;a href=&quot;http://peerific.blogspot.com/2009/08/downloading-first-look-data.html&quot;&gt;downloaded the First Look file&lt;/a&gt; and now have over 3,000 credit unions to analyze using 2Q data. For you data &amp;amp; analysis nerds out there, now is the time to start raggin&#39; on your colleagues that DON&#39;T use Peer. Light up the CFO listserv with 2Q fun facts that only YOU know, while they struggle to use NCUA.gov to get data. Ok, enough trash talking. Back to Custom Graphing.&lt;br /&gt;&lt;br /&gt;Where were we? I&#39;ve covered all the Single Credit Union or Peer Group charts, as well as the various Historical tables. Let&#39;s move on to Lists under both All Comparisons and Detailed. First a quick note about the difference between the two sections.&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;All Comparisons:&lt;/span&gt; By default, these graphs will show data for the primary and any comparisons you have selected. The CUs within those Peer Groups, by default, do NOT  show on these charts. However, you can add them simply by selecting &quot;Include all credit unions that comprise the selected comparisons&quot; on the Account Selection screen. In essense, you&#39;ve just upgraded to the Detailed group of graphs.&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Detailed:&lt;/span&gt; By default, these graphs will &lt;span style=&quot;font-weight: bold;&quot;&gt;show data for the primary and ALL the CUs that make up the comparisons&lt;/span&gt;, but NOT show the comparisons if they are an aggregated Peer Group. You can also add in the Peer Group averages by selecting &quot;Just show selected comparisons&quot; on the Account Selection screen. This is really mislabled in this case and should &quot;&lt;span style=&quot;font-style: italic;&quot;&gt;Also include &lt;/span&gt;selected comparisons&quot;. I&#39;ll suggest that to the team.&lt;br /&gt;&lt;br /&gt;Wow. I&#39;m tired just writing that. Ok, on to the custom graphs. Alpha &amp;amp; Leader Tables.&lt;br /&gt;&lt;br /&gt;Basically the same thing, but one sorts the data alphabetically by default; the other sorts by the first account code, highest to lowest, to create a ranking report. Pretty straightforward. In addition to the difference listed above (All Comparisons v. Detailed), you can always click on any column header to sort the data by that row. So, for accounts where LOWER is better (delinquency, efficiency etc.), just click that column header to reverse the listing.</description><link>http://peerific.blogspot.com/2009/08/first-look-data-is-ready-look-at-alpha.html</link><author>noreply@blogger.com (Alix)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-8208266840265395249</guid><pubDate>Sun, 02 Aug 2009 18:15:00 +0000</pubDate><atom:updated>2009-08-03T08:29:38.056-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">First Look</category><title>Downloading First Look Data</title><description>&lt;span style=&quot;font-weight: bold;&quot;&gt;First, check for software updates&lt;/span&gt; (Under Tools, or the program will just prompt you with that crazy bouncing window in the corner). &lt;span style=&quot;font-weight: bold;&quot;&gt;You need to be on version 2.0.5.7 &lt;/span&gt;(don&#39;t know what version you have installed? Go to Help --&gt; About Peer to Peer 2.0 --&gt; ) If it&#39;s been a while since you&#39;ve updated, you might need to take a break and go eat lunch while the scripts load. The software team has been busy with upgrades and fixes, so depending on the last time you used Peer, you might have to wait a bit (but before you complain, it&#39;s a lot less waiting than when we used to send disks in the mail!)&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Now that you&#39;re ready for First Look data, go to&lt;/span&gt; &lt;span style=&quot;font-weight: bold;&quot;&gt;File --&gt; Import --&gt; First Look Data&lt;/span&gt;. Follow the prompts and you&#39;re done! That was easy. Reminder: The First Look file is not the complete 5300 (it&#39;s about 90% of it). So, every once in a while, you may click on a graph or table and get a message that says &quot;this data is not available in the First Look data file&quot; (ex. the CUSO investments schedule).&lt;br /&gt;&lt;br /&gt;You&#39;ll now see First Look 2Q on the cycle pull down menu. Three things to note:&lt;br /&gt;1. I&lt;span style=&quot;font-weight: bold;&quot;&gt;f you want your primary to be a CU that isn&#39;t in the First Look file&lt;/span&gt;, you need to &quot;cycle back&quot; to 1Q before you go to select them on the Primary/Comparisons screen. Why would you do this? Well, for me, I still need to look up credit unions that may not yet be loaded for other reasons that evaluating 2Q performance.&lt;br /&gt;2. &lt;span style=&quot;font-weight: bold;&quot;&gt;If you get a weird &quot;there is no data at row 0&quot; message, &lt;/span&gt;cycle back to 1Q and click around on some graphs. Then go back to 2Q data and all should be fine. No one I have talked got this error, but I did on my laptop at home. Might as well give you a workaround if you&#39;re in the 1% like me that got this weird error.&lt;br /&gt;3. &lt;span style=&quot;font-weight: bold;&quot;&gt;Check back soon&lt;/span&gt;...as I type this, more CUs are being processed for the next load.</description><link>http://peerific.blogspot.com/2009/08/downloading-first-look-data.html</link><author>noreply@blogger.com (Alix)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-5321101070128006254</guid><pubDate>Tue, 28 Jul 2009 02:21:00 +0000</pubDate><atom:updated>2009-07-28T08:53:45.211-04:00</atom:updated><title>Success!! NCUA re-releases 4Q data</title><description>&lt;a href=&quot;http://creditunionsrising.com/Home/LatestAnalysis/tabid/102/EntryId/26/Protecting-the-Currency-of-the-Realm-The-Integrity-of-Financial-Reporting.aspx&quot;&gt;Chip Filson wrote on CreditUnionsRising.com &lt;/a&gt;&quot;&lt;span id=&quot;dnn_ctr528_MainView_ViewEntry_lblEntry&quot;&gt;The incoming NCUA Chair faces many challenges. Restoring financial integrity to the call report process is an immediate one. In a dramatically increased uncertain world, the new Chair can be sure of two things: first, losses and therefore asset values, will be hard to estimate for quite some time; and second, capturing these elusive values thru the call report process will continue to be problematic.&lt;br /&gt;&lt;br /&gt;New approaches and better action steps to handle both valuation and accounting treatment of loss estimates are needed. To date, NCUA has handled neither well. There will, however, be opportunities to improve the current situation and define new approaches in the months ahead.&lt;br /&gt;&lt;br /&gt;The immediate issue is understanding how the uncertainty and muddied waters now surrounding the call reports occurred.&quot;&lt;br /&gt;&lt;br /&gt;We submitted a FOIA request to NCUA to re-release the data and almost 100 peer-users supported this effort by emailing NCUA their support of this effort. Now, the first step has been taken. NCUA has re-released 4Q data with all of the refiled reports. The software is preparing this data file for use in Peer so you can also have access to the complete data. More information to be sent later this week.&lt;br /&gt;&lt;br /&gt;Tomorrow...back to custom graphing!&lt;br /&gt;&lt;/span&gt;</description><link>http://peerific.blogspot.com/2009/07/success-ncua-agreed-to-release-4q.html</link><author>noreply@blogger.com (Alix)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-5293768455724312481</guid><pubDate>Thu, 23 Jul 2009 22:24:00 +0000</pubDate><atom:updated>2009-07-23T18:31:44.278-04:00</atom:updated><title>New Deposit Analysis CRC available</title><description>I&#39;m back! Just returned from overseas so am getting caught up on everything. Here&#39;s a quick post about a new CRC file available for Peer Users on deposit analysis.&lt;br /&gt;&lt;br /&gt;A colleague of mine, Dane Coalson, hosted an event on analyzing deposits. I regret to say I missed it (was overseas) and if you did too, you can still watch the recording on CUtv. &lt;a href=&quot;http://www.creditunions.com/cutv/individual.aspx?eventid=507&quot;&gt;Click here&lt;/a&gt;.&lt;br /&gt;Password: Deposits507&lt;br /&gt;&lt;br /&gt;Dane also posted a CRC file with 11 graphs from this event. You can get it on www.p2psoftware.com under Resources. Or &lt;a href=&quot;http://p2psoftware.com/P2P/Resources.asp?pid=4&quot;&gt;click here&lt;/a&gt;.&lt;br /&gt;&lt;br /&gt;You can read more on CreditUnions.com in his article &lt;a href=&quot;http://www.creditunions.com/article.aspx?articleid=3132&quot;&gt;Using the Power of Data to Identify Trends and Opportunities in the Share Portfolio&lt;/a&gt;</description><link>http://peerific.blogspot.com/2009/07/new-deposit-analysis-crc-available.html</link><author>noreply@blogger.com (Alix)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-6888114968094272573</guid><pubDate>Tue, 21 Jul 2009 12:00:00 +0000</pubDate><atom:updated>2009-07-21T08:00:03.435-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">custom graphs</category><category domain="http://www.blogger.com/atom/ns#">Excel</category><category domain="http://www.blogger.com/atom/ns#">jedi</category><title>Custom Graphing: Historical Charts (love these...)</title><description>While you toil away at your Jedi training, I am (probably) enjoying a view of the Swiss Alps. At least that&#39;s the plan. I&#39;ll let you know the reality when I&#39;m back State-side on Thursday.&lt;br /&gt;&lt;br /&gt;Ok, today&#39;s lesson: History tables. There are two...and a great way to access data that you can export to excel to manipulate (for good....not evil...keep repeating.) I demonstrate a way to use this report to calculate quarterly values for accounts reported YTD in a &lt;a href=&quot;http://peerific.blogspot.com/2009/07/calculating-graphing-accounts-reported.html&quot;&gt;previous blog post&lt;/a&gt;.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNeTa90Kpf36YPyJWudlWzaJKQDP1zgHFurXau4jn29EgcftYCUV6aC5BrX-UWlaLE6vWfCfW-O3XEinpscAiEgoO7VIoMI5f2pKz13kqYjYK8Mggx-fSUzYqvutxZFBIe0scG1zk/s1600-h/Slide1.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 222px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNeTa90Kpf36YPyJWudlWzaJKQDP1zgHFurXau4jn29EgcftYCUV6aC5BrX-UWlaLE6vWfCfW-O3XEinpscAiEgoO7VIoMI5f2pKz13kqYjYK8Mggx-fSUzYqvutxZFBIe0scG1zk/s400/Slide1.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358475040448456466&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;With the first option, Single CU/PG History, you create a table of values for multiple accounts for a single entity over time.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMwjsMJtn0dsHxDZ4uaHfeHKjxZYfszA6Ed1VR_aULQ-wUANGUkzKYgjyyfSO2pNmWi9CwRTKcCvoBosZ3XqNZdAh_azQO-BneNje4nsHvrU4zFiaCmVHnSpTkYo5ocUKjLPmbo24/s1600-h/Slide2.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 264px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMwjsMJtn0dsHxDZ4uaHfeHKjxZYfszA6Ed1VR_aULQ-wUANGUkzKYgjyyfSO2pNmWi9CwRTKcCvoBosZ3XqNZdAh_azQO-BneNje4nsHvrU4zFiaCmVHnSpTkYo5ocUKjLPmbo24/s400/Slide2.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358475046988745010&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;The second option, All Comparisons History, creates a grid of historical values for a &lt;span style=&quot;font-weight: bold;&quot;&gt;single&lt;/span&gt; account for all your comparisons. WARNING: Do NOT select &quot;Include all comparisons that comprise the selected comparisons&quot; on the &lt;a href=&quot;http://peerific.blogspot.com/2009/07/custom-graphing-account-selection.html&quot;&gt;Account Selection&lt;/a&gt; screen unless you have a SMALL peer group selected or PLENTY of time to let Peer run. (I don&#39;t think the original specifications even meant for that option to be available ... )&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_YJDnQk7BzGHImPQwAbs9ZDPP2V7q6QNN1azl5eAB9YvR9aMh_N2_iXlVGlFbEFqwFebeDhOp4zFbIejb1wWCWUaKT4h7X1PXDGcYz77dE9cGF1PgI0F7Nzka8dN4P2dDUokJMXs/s1600-h/Slide3.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 209px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_YJDnQk7BzGHImPQwAbs9ZDPP2V7q6QNN1azl5eAB9YvR9aMh_N2_iXlVGlFbEFqwFebeDhOp4zFbIejb1wWCWUaKT4h7X1PXDGcYz77dE9cGF1PgI0F7Nzka8dN4P2dDUokJMXs/s400/Slide3.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358475047280675202&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Why would you use this? Couple reasons I can think of...As I said in a previous blog post, Peer can do a lot but sometimes you need to put data in Excel to create a specific graph. This report allows for a quick pull and export.&lt;br /&gt;&lt;br /&gt;I use this report a lot to spot data inconsistencies. Example: I was helping a client pull data on mortgage sales on the secondary. There was a huge bump in one quarter so I pulled an All Comparisons Historical report to see the underlying data. Found that one CU had reported their YTD sales incorrectly back in 2003 by adding an extra zero (I verified against NCUA&#39;s report--it&#39;s still wrong there too).&lt;br /&gt;&lt;br /&gt;How do you use these reports? Would love your feedback. Please comment.</description><link>http://peerific.blogspot.com/2009/07/custom-graphing-historical-charts-love.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNeTa90Kpf36YPyJWudlWzaJKQDP1zgHFurXau4jn29EgcftYCUV6aC5BrX-UWlaLE6vWfCfW-O3XEinpscAiEgoO7VIoMI5f2pKz13kqYjYK8Mggx-fSUzYqvutxZFBIe0scG1zk/s72-c/Slide1.JPG" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-5902952649478100327</guid><pubDate>Fri, 17 Jul 2009 12:00:00 +0000</pubDate><atom:updated>2009-07-17T08:00:09.225-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">account selection</category><category domain="http://www.blogger.com/atom/ns#">column charts</category><category domain="http://www.blogger.com/atom/ns#">custom graphs</category><category domain="http://www.blogger.com/atom/ns#">loan portfolio</category><category domain="http://www.blogger.com/atom/ns#">shares</category><title>Custom Graphing: 3 Column Charts for Single CU/Peer Group?</title><description>There are 3 different column charts under Single CU/Peer Group. Let&#39;s take a look at the difference between them:&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXijHOr6t2fFrWK1OktZBZrt6aAnhP5_bdBoy7v7lqJ3mCwzVOYPQCJwGntAvgRbFl7KRhPP4T-nNiw3UAtvlLexFZ8RGI4KAt-vDXWs4i8IAoFhGmL2SCWgsFRUuml1nfkhdiYVI/s1600-h/Slide2.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 87px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXijHOr6t2fFrWK1OktZBZrt6aAnhP5_bdBoy7v7lqJ3mCwzVOYPQCJwGntAvgRbFl7KRhPP4T-nNiw3UAtvlLexFZ8RGI4KAt-vDXWs4i8IAoFhGmL2SCWgsFRUuml1nfkhdiYVI/s400/Slide2.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358450976733403202&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;1. &lt;span style=&quot;font-weight: bold;&quot;&gt;Single Cycle&lt;/span&gt;: This one shows you a different column for each account in a single cycle. Not sure how often you&#39;d use...but here&#39;s an example to show the total $ outstanding for various components of the loan portfolio.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_TWtouOhVo8pcw4S8t327JbxaJf1dlixzyFBHtobnJ8tnKGybGgdyAFSF8P3BM3DkTAhNR4Lo8vQyvcDvtQBhPjYa8nPB2TCwkJ_LwYpLv573vDV5hGZK6HQ-7zE1lOhr0yvYaL8/s1600-h/Slide3.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 219px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_TWtouOhVo8pcw4S8t327JbxaJf1dlixzyFBHtobnJ8tnKGybGgdyAFSF8P3BM3DkTAhNR4Lo8vQyvcDvtQBhPjYa8nPB2TCwkJ_LwYpLv573vDV5hGZK6HQ-7zE1lOhr0yvYaL8/s400/Slide3.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358450980320892114&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;2. &lt;span style=&quot;font-weight: bold;&quot;&gt;Historica&lt;/span&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;l&lt;/span&gt;: This one is more useful. It shows you multiple accounts going back over time for a single CU or PG. This is the same as the line chart next to it. I usually use columns when measuring balances and the line for ratios. Not sure why...Here are 2 examples:&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifC7D0_q4R8w2iJ54uI1QWoJTJIiCwghP1fFkbjQJoYyso0idAcz-Rh6VUsGaISjKvXlo35dyv7ks8eBSgJx5NFKOyIWetci4I5B36Jldq9GYPl_vNjEQD8yqUAhuVu6B67fIEzr0/s1600-h/Slide4.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 220px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifC7D0_q4R8w2iJ54uI1QWoJTJIiCwghP1fFkbjQJoYyso0idAcz-Rh6VUsGaISjKvXlo35dyv7ks8eBSgJx5NFKOyIWetci4I5B36Jldq9GYPl_vNjEQD8yqUAhuVu6B67fIEzr0/s400/Slide4.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358450982612772370&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1jtg0PONwJdX8cvXgQrA4ld51grRDSq9_gxCbDWIN5ptsIVXgZv87hKRE2yl6oUcrVeko14QQqwhyp4tmgKKAfGGm5okFXB6W1qPdFhVVgDM8CY4jFnRDK-ccsK39SWQlBg19ioM/s1600-h/Slide5.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 218px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1jtg0PONwJdX8cvXgQrA4ld51grRDSq9_gxCbDWIN5ptsIVXgZv87hKRE2yl6oUcrVeko14QQqwhyp4tmgKKAfGGm5okFXB6W1qPdFhVVgDM8CY4jFnRDK-ccsK39SWQlBg19ioM/s400/Slide5.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358450986968470466&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;3. &lt;span style=&quot;font-weight: bold;&quot;&gt;Stacked Column (Historical)&lt;/span&gt;: My favorite. Use this to look at &lt;span style=&quot;font-weight: bold;&quot;&gt;composition &lt;/span&gt;changes historically. Here is an example showing the changing composition of the average credit union share portfolio over time. (I&#39;m using the &quot;All US&quot; peer group...thus the &#39;average&#39; composition for the entire industry). Note the shift toward share certificates starting in 2006...&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrjJfBg3VEqs6TfTh6Ll8kcPmJZpeqlBEhm9Pl18hpbAeOZr1peZhmqD5rvldbDXTewB8o_Vu8kahqGVSrBJUdhNAwdW1vBc7gKNKSgtvkMseatzE6cvWM9CLJt3o6EucuckNrDzU/s1600-h/Slide6.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 218px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrjJfBg3VEqs6TfTh6Ll8kcPmJZpeqlBEhm9Pl18hpbAeOZr1peZhmqD5rvldbDXTewB8o_Vu8kahqGVSrBJUdhNAwdW1vBc7gKNKSgtvkMseatzE6cvWM9CLJt3o6EucuckNrDzU/s400/Slide6.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358450988409011570&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Bonus! I just learned something myself. You can use the Type menu above this chart to turn it into a stacked area chart. This yields the same result as having selected the &lt;span style=&quot;font-weight: bold;&quot;&gt;Area Char&lt;/span&gt;t. Yay. Once less blog post.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfvrXKIpxDE6NrxuKHHC9WHBPt9k0uX3loqI6WT8WVNnD6_ejQ4AyP4vSgIfyDbanSBgPBRk6o7_OCqxzZCnpztCDkYxZJL6uHKJQ6tzJ5Lzf9yOPdxvsP5UvmZztJ3mH_pMTC5LA/s1600-h/slide7.jpg&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 218px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfvrXKIpxDE6NrxuKHHC9WHBPt9k0uX3loqI6WT8WVNnD6_ejQ4AyP4vSgIfyDbanSBgPBRk6o7_OCqxzZCnpztCDkYxZJL6uHKJQ6tzJ5Lzf9yOPdxvsP5UvmZztJ3mH_pMTC5LA/s400/slide7.jpg&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358457112253963090&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;Note: the &lt;a href=&quot;http://peerific.blogspot.com/2009/07/custom-graphing-account-selection.html&quot;&gt;Account Selection&lt;/a&gt; screen is the same for all of them...just realize when you select type 2, each account code you is a different column. For type 3, each account code is stacked on top of the others, rather than next to them.&lt;br /&gt;&lt;br /&gt;And with that bonus find, I&#39;m treating myself to a 3-day weekend (I&#39;m actually on a 7-day vacation as you read this but I felt compelled to prepare tips for my 3 loyal Jedi-in-training while I am overseas.) My next post will be on Tuesday, July 21 and cover Historical Tables.</description><link>http://peerific.blogspot.com/2009/07/custom-graphing-3-column-charts-for.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXijHOr6t2fFrWK1OktZBZrt6aAnhP5_bdBoy7v7lqJ3mCwzVOYPQCJwGntAvgRbFl7KRhPP4T-nNiw3UAtvlLexFZ8RGI4KAt-vDXWs4i8IAoFhGmL2SCWgsFRUuml1nfkhdiYVI/s72-c/Slide2.JPG" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-5493287160344222204</guid><pubDate>Thu, 16 Jul 2009 12:33:00 +0000</pubDate><atom:updated>2009-07-16T08:33:00.344-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">account selection</category><category domain="http://www.blogger.com/atom/ns#">custom built</category><category domain="http://www.blogger.com/atom/ns#">custom graphs</category><category domain="http://www.blogger.com/atom/ns#">efficiency</category><category domain="http://www.blogger.com/atom/ns#">formulas</category><category domain="http://www.blogger.com/atom/ns#">save time</category><category domain="http://www.blogger.com/atom/ns#">standing report</category><title>Custom Graphing: Ranking Report (ex. Productivity &amp; Efficiency)</title><description>The Standing Report is easy to explain and one of the most helpful and powerful tables you can build in Peer 2. Understanding its power is key to gaining Jedi Knight status. But this post comes with a warning: you must use this Force for Good. Do not lured to the Dark Side. There is great temptation to keep its power secret from your colleagues so that you look all-knowing and powerful, while they slave away using excel spreadsheets for hours to produce similar information.&lt;br /&gt;&lt;br /&gt;This report answers the question &quot;What is your &lt;span style=&quot;font-style: italic;&quot;&gt;standing&lt;/span&gt; compared to your peers?.&quot;&lt;br /&gt;&lt;br /&gt;So what does it show? The Standing Report compares your primary CUs performance in however many areas you want against all other CUs in the comparison sets.  It shows your actual performance, rank out of the total # of CUs, the other CUs&#39; average performance and what percentile your performance falls into.&lt;br /&gt;&lt;br /&gt;Let&#39;s look at Productivity &amp;amp; Efficiency to tie together what you learned earlier in the week with the Formula Wizard post and today&#39;s lesson.&lt;br /&gt;&lt;br /&gt;Begin by selecting the Standing Report. Click on the binocular image on the first line and navigate to Ratio &amp;amp; Scoring --&gt; Productivity &amp;amp; Efficiency.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLkj99JaonR6fGlrmwbmPvLoe0GD-GrySCgooy97bQn9uKvkOk80CanM9ALNbnZNuIwbnew5j31W_pfAf-6MuArl4VTxfMfnJSeOh9oeuQ78QDnw3x3scZ89FKOE3XizREAU_AJZI/s1600-h/Slide1.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 219px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLkj99JaonR6fGlrmwbmPvLoe0GD-GrySCgooy97bQn9uKvkOk80CanM9ALNbnZNuIwbnew5j31W_pfAf-6MuArl4VTxfMfnJSeOh9oeuQ78QDnw3x3scZ89FKOE3XizREAU_AJZI/s400/Slide1.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358114442141450514&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Double-click on each formula you want to include on the report (you&#39;ll see each one you select pop into the window at the bottom.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgy39U9JHHaO7pu7XGF5r4bcDC_YTECGiTlOcM_NBwBkXkCdbXUQijpIBDl0Zu6h_hyphenhyphenpOtTxfcRpcXE7EEknXq92aUMbiF33zebpBTiyhpLAb6izdWCakhikfvp4q2VcHlnwolR6yY/s1600-h/Slide2.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 219px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgy39U9JHHaO7pu7XGF5r4bcDC_YTECGiTlOcM_NBwBkXkCdbXUQijpIBDl0Zu6h_hyphenhyphenpOtTxfcRpcXE7EEknXq92aUMbiF33zebpBTiyhpLAb6izdWCakhikfvp4q2VcHlnwolR6yY/s400/Slide2.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358114447233571602&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;If you want to do more than 15 rows, you&#39;ll have to go back to the Account Selection screen and click &quot;insert&quot; for each new line you want to add (annoying).&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrbVD1ikAjITVOpd38nnsr3dkExyxJcIcUCUmuB29c5dDvbPM0Sl8mGj5voozDoX7K3XIHDm3hiN2I3Nq0t5f5NkNJWVylYL0oSmLDCxva1BrE8X0lw9WumIJmqLZb9VX2A2dtd6c/s1600-h/Slide3.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 260px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrbVD1ikAjITVOpd38nnsr3dkExyxJcIcUCUmuB29c5dDvbPM0Sl8mGj5voozDoX7K3XIHDm3hiN2I3Nq0t5f5NkNJWVylYL0oSmLDCxva1BrE8X0lw9WumIJmqLZb9VX2A2dtd6c/s400/Slide3.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358114450378507266&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;When done, give your table a title and select either Preview or Save. Voila! (my new favorite word).&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWBYKgFdLqaaoudYKYeo-fqVR2wSqqxVODbcyh7nQn73J0fafJZ8XPO-HJwK1zEYUwYyL9fYSaobt0xnt5PVU5u-zFvtC_5ldi_5dcKnU5FJ8Sa91AU61K22avnJrKL6r5-5FIWwA/s1600-h/Slide4.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 170px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWBYKgFdLqaaoudYKYeo-fqVR2wSqqxVODbcyh7nQn73J0fafJZ8XPO-HJwK1zEYUwYyL9fYSaobt0xnt5PVU5u-zFvtC_5ldi_5dcKnU5FJ8Sa91AU61K22avnJrKL6r5-5FIWwA/s400/Slide4.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358114454746563282&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;If you want to see how another CU in the comparison set performs, just use the drop down menu on the graph (which regrettably is sorting in descending asset order rather than alphabetically...submitted to fix desk).&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7qGZdkJO-j8jQ4sAhN4gkLEbfRimAv1I2Xbv-IYc7fmrwi9i4AR4z214VcjimmUbav8ekxYOuBa3mn9SCXO8XpH1Y_zHL5TXBUsRhbdrWy9-kdcUXfGzD8c5QZcwyRz4plOoEsGQ/s1600-h/Slide5.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 173px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7qGZdkJO-j8jQ4sAhN4gkLEbfRimAv1I2Xbv-IYc7fmrwi9i4AR4z214VcjimmUbav8ekxYOuBa3mn9SCXO8XpH1Y_zHL5TXBUsRhbdrWy9-kdcUXfGzD8c5QZcwyRz4plOoEsGQ/s400/Slide5.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5358114457699423634&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;</description><link>http://peerific.blogspot.com/2009/07/custom-graphing-ranking-report-ex.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLkj99JaonR6fGlrmwbmPvLoe0GD-GrySCgooy97bQn9uKvkOk80CanM9ALNbnZNuIwbnew5j31W_pfAf-6MuArl4VTxfMfnJSeOh9oeuQ78QDnw3x3scZ89FKOE3XizREAU_AJZI/s72-c/Slide1.JPG" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-1368554055372282589</guid><pubDate>Thu, 16 Jul 2009 12:00:00 +0000</pubDate><atom:updated>2009-07-16T08:00:06.800-04:00</atom:updated><title>Free &quot;Power of Data&quot; Webinar Today!  Special Focus: Deposits</title><description>&lt;p&gt;&lt;a href=&quot;http://www.creditunions.com/cutv/webplate.aspx?eventid=507&amp;amp;wt.mc_id=peerific&quot;&gt;REGISTER&lt;/a&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;Join Callahan Industry Analysts as they discuss how to analyze a share portfolio, strategically examine the components of deposit acquisition, compare your credit union&#39;s performance to peers, and highlight how you can use data resources from outside the credit union industry to supplement your analysis.&lt;br /&gt;       &lt;br /&gt;We&#39;ll unlock a world of resources and provide you with a cheat sheet of deposit data sources to keep handy when evaluating your portfolio&#39;s performance. Then, we&#39;ll drill down to showcase different ways to analyze your credit union&#39;s share portfolio relative to the credit union industry as whole, regionally and by best performance.&lt;/p&gt;       &lt;p&gt;&lt;strong&gt;Agenda:&lt;/strong&gt;&lt;/p&gt;       &lt;ul&gt;&lt;li&gt;External Comparisons:           &lt;ul&gt;&lt;li&gt;Market Share&lt;/li&gt;&lt;li&gt;Current Deposit Product Rate Trends&lt;/li&gt;&lt;li&gt;Savings Trends&lt;/li&gt;&lt;/ul&gt;         &lt;/li&gt;&lt;li&gt;Credit Union Industry Analysis:           &lt;ul&gt;&lt;li&gt;Share Portfolio Analysis &lt;/li&gt;&lt;li&gt;Cost of Funds&lt;/li&gt;&lt;li&gt;Market Share &amp;amp; Branch Analysis &lt;/li&gt;&lt;li&gt;Member Relationship Metrics&lt;/li&gt;&lt;/ul&gt;         &lt;/li&gt;&lt;li&gt;Creating Comparisons           &lt;ul&gt;&lt;li&gt;Averages v. Best Performance&lt;/li&gt;&lt;li&gt;Regional Variations&lt;/li&gt;&lt;li&gt;&quot;Traditional&quot; Asset or FOM-based&lt;/li&gt;&lt;/ul&gt;         &lt;/li&gt;&lt;/ul&gt;                               &lt;span style=&quot;color:#ffffff;&quot;&gt;Industry Insight from:&lt;/span&gt;</description><link>http://peerific.blogspot.com/2009/07/free-power-of-data-webinar-today.html</link><author>noreply@blogger.com (Alix)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-2573086664882798256</guid><pubDate>Wed, 15 Jul 2009 12:00:00 +0000</pubDate><atom:updated>2009-07-15T08:00:08.828-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">analysis</category><category domain="http://www.blogger.com/atom/ns#">custom graphs</category><category domain="http://www.blogger.com/atom/ns#">loan portfolio</category><category domain="http://www.blogger.com/atom/ns#">share</category><title>Custom Graphing: Single CU or PG + Composition Pie/Bar</title><description>My dear Padawan, I&#39;m so glad you have expressed interest in being a Custom Graphing Jedi Master. Let us begin our training with the &quot;Single Credit Union or Peer Group&quot; section of Peer 2.0.&lt;br /&gt;&lt;br /&gt;I am going to begin out of order, tackling the 2 composition charts in the middle first. They are the easiest to understand.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv3JUE-dOepU-0d61_AoPdrN6_00OnaT5xal_hERUhxLguAzCnxKV2N-uCN2juQ9SIhP9D7EOazGlIQbfHC5EMK5EbVA4HTn-1VgJsoUhAVZ0JFQnTFR_rGyXjuRhyC1_Y3Irqi50/s1600-h/Slide1.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 134px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv3JUE-dOepU-0d61_AoPdrN6_00OnaT5xal_hERUhxLguAzCnxKV2N-uCN2juQ9SIhP9D7EOazGlIQbfHC5EMK5EbVA4HTn-1VgJsoUhAVZ0JFQnTFR_rGyXjuRhyC1_Y3Irqi50/s400/Slide1.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357343950075547810&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;Say you want to look at current composition of your loan, share or investment portfolio (or that of your &quot;competitor&quot;--another CU or a peer group). &lt;span style=&quot;font-weight: bold;&quot;&gt;Composition: Pie&lt;/span&gt; and &lt;span style=&quot;font-weight: bold;&quot;&gt;Composition: Bar&lt;/span&gt; display the same information, just in different formats. Pies are traditional but honestly not nearly as easy to interpret as bar charts which make it very easy to see the relative size of each component. Let&#39;s do an example using the Loan Portfolio and the Pie chart.&lt;br /&gt;&lt;br /&gt;First, click on the Pie image and Peer will take you to the Account Selection screen.  Now, type in the formulas you want to include in the pie chart and the titles you want shown on the legend.&lt;br /&gt;a396+a397 = unsecured debt&lt;br /&gt;a385+a370+a002 = auto loans &amp;amp; leases&lt;br /&gt;a703+a386= mortgage loans&lt;br /&gt;a698 = other&lt;br /&gt;&lt;br /&gt;(Not sure how to figure out &lt;a href=&quot;http://peerific.blogspot.com/2009/07/custom-graphing-account-selection.html&quot;&gt;account codes&lt;/a&gt;? That&#39;s another entry all together...&lt;a href=&quot;http://peerific.blogspot.com/2009/07/custom-graphing-account-selection.html&quot;&gt;click here&lt;/a&gt;.)&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9OKuFAsKyppWvn9145xB-P9N8peKTDQlmGnmoohsZYJsg4Zw2jMm_OsBGSfz4ZYHnrancssB1QBuslEceDHt1JfBWZyWK2Rr0H6xYRlbYIVPmMDNgSJpRSn1KleSJC-47pnvS0sg/s1600-h/Slide2.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 340px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9OKuFAsKyppWvn9145xB-P9N8peKTDQlmGnmoohsZYJsg4Zw2jMm_OsBGSfz4ZYHnrancssB1QBuslEceDHt1JfBWZyWK2Rr0H6xYRlbYIVPmMDNgSJpRSn1KleSJC-47pnvS0sg/s400/Slide2.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357343961615054722&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;span&gt;For now, keep &quot;Just show selected comparisons&quot; checked. I&#39;ll explain the other option in a minute. &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;Select &quot;Preview&quot; or &quot;Save.&quot; &lt;span style=&quot;font-weight: bold;&quot;&gt;Preview&lt;/span&gt; puts it in your Temporary Displays, &lt;span style=&quot;font-weight: bold;&quot;&gt;Save&lt;/span&gt; will prompt you to select a folder in which to save it. Done.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGb9qQznlhsmIPdigOoPe93xIBV0_ip3Gaklv1hR3GNDERHaGmNpFLC_RDvBfinxzwEi1OlqlYdhpn5Vn9XcqBVzgUL4E-SQ2r9oSMMnY8E5RrNovNFL-3Bzgg0hEXf6EKM-3MtdI/s1600-h/customgraphs.jpg&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 220px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGb9qQznlhsmIPdigOoPe93xIBV0_ip3Gaklv1hR3GNDERHaGmNpFLC_RDvBfinxzwEi1OlqlYdhpn5Vn9XcqBVzgUL4E-SQ2r9oSMMnY8E5RrNovNFL-3Bzgg0hEXf6EKM-3MtdI/s400/customgraphs.jpg&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357618185129493138&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Ok, 3 things to play with.&lt;br /&gt;&lt;br /&gt;1. By default, the graph is showing the actual $ values. If you&#39;d rather see the %, simply use the Data Format drop down.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjm4xKHGRFY8uaAqfNJkhXaCFdgFii85I7PWVpecvNZl0ScKNvCqjghvE3Me3_ikjAxCRUj7jRBDDSp-dBsf5hcCXgHXpZ6TntFcBt4vB0TPMWa0tNqJE2zwQFan_uD0Roa0pApwA/s1600-h/Slide3.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 237px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjm4xKHGRFY8uaAqfNJkhXaCFdgFii85I7PWVpecvNZl0ScKNvCqjghvE3Me3_ikjAxCRUj7jRBDDSp-dBsf5hcCXgHXpZ6TntFcBt4vB0TPMWa0tNqJE2zwQFan_uD0Roa0pApwA/s400/Slide3.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357343964148427090&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;2. Change your mind and would rather see the bar chart? Select Type--&gt; Bar.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikaMZSYODLn1PpKuolUtY22m3dkil9ppFHuLNFMIJ6fI8BiVOY5Rqxq7POwVGcWWcze2DPgBvJuPkX0NihT4ih2De0SGF-46L0TP9L9UsJqt6X8F8c5GIeVz-4KrHvcc39EM-JIVg/s1600-h/Slide4.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 213px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikaMZSYODLn1PpKuolUtY22m3dkil9ppFHuLNFMIJ6fI8BiVOY5Rqxq7POwVGcWWcze2DPgBvJuPkX0NihT4ih2De0SGF-46L0TP9L9UsJqt6X8F8c5GIeVz-4KrHvcc39EM-JIVg/s400/Slide4.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357343968383923266&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbk8p28NtCZb9zj3MmLAvR_HxvdpLpiBvs4493W99BXOgmLQHmrnCXGUcRS-FHefO1JpMgmfMkk72bqr7LSAJunltYNvwiA78jO2O7XS8kHoIfIvq0MsaPjKe6jjAV7WPhiPQu0oY/s1600-h/Slide5.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 255px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbk8p28NtCZb9zj3MmLAvR_HxvdpLpiBvs4493W99BXOgmLQHmrnCXGUcRS-FHefO1JpMgmfMkk72bqr7LSAJunltYNvwiA78jO2O7XS8kHoIfIvq0MsaPjKe6jjAV7WPhiPQu0oY/s400/Slide5.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357343969447942450&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Hmm....bar charts should always sort largest to smallest...I&#39;ll have to submit a fix.&lt;br /&gt;&lt;br /&gt;3.  Want to look at one of your other comparisons? Simply use the drop down menu on the chart to change. Your primary and all of your comparisons will be on the list.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhC-hN4P_D0VjSlO-qpqyp57A2U2cMdTPl0JXopZhoCgvVjQI3Ob4b_uCL2WYgiZszAc6w8YrhV6YV3E7POZ4ozFeOQIyTZ9SRlNYlNZYdxvmt3p-p-1cECs0k826Xdb8aECJKZHFs/s1600-h/Slide6.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 179px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhC-hN4P_D0VjSlO-qpqyp57A2U2cMdTPl0JXopZhoCgvVjQI3Ob4b_uCL2WYgiZszAc6w8YrhV6YV3E7POZ4ozFeOQIyTZ9SRlNYlNZYdxvmt3p-p-1cECs0k826Xdb8aECJKZHFs/s400/Slide6.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357344929838321378&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Ok, this brings us back to the radio buttons on the Account Selection Screen:&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhz-bdzVhNCtUziM-5NPLLgqI2-e6IIY0LTdvvQaTO_pYPfmHiHK3RDAUKjAXB3eTbLRJ_9fUk5UwJDcErHKbP9j2V6c4so_4k7miNwOwE41gmyFzWQnAVOjG9dIijieykQgzg680s/s1600-h/Slide7.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 58px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhz-bdzVhNCtUziM-5NPLLgqI2-e6IIY0LTdvvQaTO_pYPfmHiHK3RDAUKjAXB3eTbLRJ_9fUk5UwJDcErHKbP9j2V6c4so_4k7miNwOwE41gmyFzWQnAVOjG9dIijieykQgzg680s/s400/Slide7.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357344934373006258&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;These radio buttons dictate what comparisons will be shown on the drop down menu on the chart (#3 above). If you just want to see your primary &amp;amp; comparisons, leave the top option selected. If you want to look at the individual credit unions that comprise your peer group comparisons, go ahead and add the second button. The only problem: your drop down menu will be mighty long depending on how big your peer group is.&lt;span style=&quot;font-weight: bold;&quot;&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;</description><link>http://peerific.blogspot.com/2009/07/custom-graphing-single-cu-or-pg.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv3JUE-dOepU-0d61_AoPdrN6_00OnaT5xal_hERUhxLguAzCnxKV2N-uCN2juQ9SIhP9D7EOazGlIQbfHC5EMK5EbVA4HTn-1VgJsoUhAVZ0JFQnTFR_rGyXjuRhyC1_Y3Irqi50/s72-c/Slide1.JPG" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-8944629172602680095</guid><pubDate>Tue, 14 Jul 2009 12:00:00 +0000</pubDate><atom:updated>2009-07-14T08:00:04.115-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">custom graphs</category><category domain="http://www.blogger.com/atom/ns#">jedi</category><category domain="http://www.blogger.com/atom/ns#">test</category><title>Custom Graphing: An Overview</title><description>&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6WQ88aelqAw4W7FkmZmOAiWeNTiqPBBAkefhRgcCMsULiqID99wjex62CcMiichYRaH1_VHYbPg1Dk8rO8alQn8I_9UlP_T9ObzQJfu2xftam0ZfDh5TxoBq3XMeqH64818qmPRg/s1600-h/Slide1.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6WQ88aelqAw4W7FkmZmOAiWeNTiqPBBAkefhRgcCMsULiqID99wjex62CcMiichYRaH1_VHYbPg1Dk8rO8alQn8I_9UlP_T9ObzQJfu2xftam0ZfDh5TxoBq3XMeqH64818qmPRg/s400/Slide1.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357330736278224098&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;Ok, for those of you ready to go beyond the built-in graphs, the next week will be devoted to custom graphing. The chart above is intimidating but once you get the hang of it, you&#39;ll be a Peer Jedi Master (I have 5 &amp;amp; 6 year-old boys...our world revolves around Star Wars the Clone Wars).&lt;br /&gt;&lt;br /&gt;To become a Jedi requires the deepest commitment and most serious mind. It is not a venture to be undertaken lightly. As such, Jedi instruction is rigidly structured and codified to enforce discipline and hinder transgression. First, you are a Padawan; then you advance to Knight. The next level of rank in the Jedi order is the Jedi Master, reserved for those who have shown exceptional devotion and skill in the Force. May the force be with you.&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Today&lt;/span&gt;: A quick overview of each &quot;section&quot; of the custom graphing.&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Tomorrow and beyond, &lt;/span&gt; I&#39;ll do sample graphs from each section. (yes, I&#39;m trying to spread out my posts...after all, I don&#39;t actually get paid for this but I may start negotiating with the software team! My motto: &quot;I work for food&quot;).&lt;br /&gt;&lt;br /&gt;To get to the custom graphing feature, go to &quot;&lt;span style=&quot;font-weight: bold;&quot;&gt;My Displays&lt;/span&gt;&quot; on the left navigation pane. Click on &lt;span style=&quot;font-weight: bold;&quot;&gt;Create New&lt;/span&gt;.  You will be presented with the screen at the top of this post.&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;&lt;br /&gt;Single Credit Union or Peer Group&lt;/span&gt;&lt;br /&gt;Use this set of graphs when you want to look at the performance of 1 credit union or 1 peer group on a graph or chart.  The first set, &lt;span style=&quot;font-weight: bold;&quot;&gt;Single/Current Cycle&lt;/span&gt;, allows you evaluate how you did in one particular quarter (by default, it&#39;s this quarter, but you can &quot;cycle back&quot;). The second set, &lt;span style=&quot;font-weight: bold;&quot;&gt;Historical/Over-Time&lt;/span&gt;, allows you to see how your CU or PG performance changed over time, on multiple facets, for example loan growth v. share growth v. member growth.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkKGJIHVct46tnQldqMFT3uObhXjtEYUieLGZ2qMrviUwJ_lyjcs6ZXOPMLuYsS-Hs8UeHAMbSMwlHMVgFfhvuw4dPa5qVguAEcx3zWBDVfCJgOxyJaQrw7SY3MICQtu1UuhVm0NI/s1600-h/Slide2.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 95px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkKGJIHVct46tnQldqMFT3uObhXjtEYUieLGZ2qMrviUwJ_lyjcs6ZXOPMLuYsS-Hs8UeHAMbSMwlHMVgFfhvuw4dPa5qVguAEcx3zWBDVfCJgOxyJaQrw7SY3MICQtu1UuhVm0NI/s400/Slide2.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357330355177027170&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;All Comparisons&lt;/span&gt;&lt;br /&gt;This set of graphs will plot your primary v. however many comparisons you selected. So, let&#39;s say you have 1 credit union as the primary and 4 peer groups (a standard asset based one, a geographic one, a FOM-based one and maybe a hand-selected set of CUs). The first set, &lt;span style=&quot;font-weight: bold;&quot;&gt;Single/Current Cycle&lt;/span&gt;, will show you data points for all 5 comparisons for a single performance quarter. As above, the second set, &lt;span style=&quot;font-weight: bold;&quot;&gt;Historical/Over-Time&lt;/span&gt;, allows you to see how all your selections performed over time, but this time in just a single facet.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0UCth2k4wXghfA3p0JpRTfVULJ8nRPCD5OsgYvgkIExQ4ZZ1qaBhutFSKUTkDWAV1Jf8cz_Xpf6eYUCMzCG2aYPS08m5TA6k3wKNG_xKH4ol8V0T121x6B5xNyaCblgLOAYthLtM/s1600-h/Slide3.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 117px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0UCth2k4wXghfA3p0JpRTfVULJ8nRPCD5OsgYvgkIExQ4ZZ1qaBhutFSKUTkDWAV1Jf8cz_Xpf6eYUCMzCG2aYPS08m5TA6k3wKNG_xKH4ol8V0T121x6B5xNyaCblgLOAYthLtM/s400/Slide3.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357330356119977666&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;So, quick example: The difference between the line chart under the top row and the line chart in the second row is this:&lt;br /&gt;&lt;br /&gt;Top row: you can show multiple &quot;lines&quot; (eg accounts) for the same CU or PG on a single graph (loan growth v. share growth v. member growth). 3 Lines all for the same CU or PG. The middle row graph will also show performance over time, but rather than each line representing a different performance measure as above, this time, each line represents a specific performance attribute for each comparisons (share growth for the 1 CU and 4 PGs in the previous example.)&lt;br /&gt;&lt;br /&gt;(Don&#39;t give up...the Force is with you...)&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Detailed&lt;/span&gt;&lt;br /&gt;Detailed graphs are similar in a lot of ways to the middle row, but rather than show the 5 comparisons selected in the previous example, these charts/graphs will show the data for ALL the credit unions within those 5 comparisons. So, Peer looks at your asset-based peer group and includes all those CUs in the table or chart; then it looks at your geographic one and throws the missing CUs on the chart; then it looks at the FOM and the hand-selected ones and adds any other CUs that are in those groups and not yet included. So, each PG might have 20 CUs (4 x 20 = 80), but collectively it&#39;s really just 60 different ones, not 80 when dupes are excluded. So these charts/tables will show 60 CUs.&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWlvw5TkqQCI8DYBODf55bSsb8FFVEfqZSDKdUI3PdLs5IJeJSnEHdR1yczjId4vvl4WHWxcF77Yp7lRawyjyerIMEGZxH6UaqwUD1BeL_qtKt_lN0XfbMk8IxuQv7CRQSp6liK0M/s1600-h/Slide4.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 110px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWlvw5TkqQCI8DYBODf55bSsb8FFVEfqZSDKdUI3PdLs5IJeJSnEHdR1yczjId4vvl4WHWxcF77Yp7lRawyjyerIMEGZxH6UaqwUD1BeL_qtKt_lN0XfbMk8IxuQv7CRQSp6liK0M/s400/Slide4.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357330360116529330&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;One more confusing point: you can chose to include the Peer Group averages or not. That&#39;s what those options at the top of the account screen are for...more on that later.&lt;br /&gt;&lt;br /&gt;Perfectly clear? Probably not...but until you start playing with these graphs, it won&#39;t be easy. Stay tuned, my young Padawan.</description><link>http://peerific.blogspot.com/2009/07/custom-graphing-overview.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6WQ88aelqAw4W7FkmZmOAiWeNTiqPBBAkefhRgcCMsULiqID99wjex62CcMiichYRaH1_VHYbPg1Dk8rO8alQn8I_9UlP_T9ObzQJfu2xftam0ZfDh5TxoBq3XMeqH64818qmPRg/s72-c/Slide1.JPG" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-7754965281349788992</guid><pubDate>Mon, 13 Jul 2009 12:00:00 +0000</pubDate><atom:updated>2009-07-13T08:00:00.698-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">custom built</category><category domain="http://www.blogger.com/atom/ns#">dynamic</category><category domain="http://www.blogger.com/atom/ns#">peer groups</category><category domain="http://www.blogger.com/atom/ns#">simple</category><category domain="http://www.blogger.com/atom/ns#">static</category><title>More on Peer Groups: Simple v. Custom, Dynamic v. Static...</title><description>On Friday, I described the difference between a Dynamic and a Static Peer Group. How does this relate to Simple v. Custom? Let&#39;s take a look.&lt;br /&gt;&lt;br /&gt;Simple Build: this is great for credit unions that want to hand-select a list of credit unions to use as a Peer Group. This is pretty common...a CEO has a set of credit unions s/he likes to keep an eye on. Use simple build to just select them one-by-one.&lt;br /&gt;&lt;br /&gt;What does this have to do with Dynamic v. Static? Well, all Simple Build PGs are considered &quot;static&quot; because the only criteria you chose was the credit unions themselves. The program stores the secret-ID and you&#39;re off to the races.&lt;br /&gt;&lt;br /&gt;Now, with Custom Built PGs, you have a choice. You can save the criteria (all CUs between $20 and 50 million, in California, who use Fiserv as a DP) by choosing &quot;Dynamic&quot;; or you can chose &quot;static&quot; so you can compare the performance of these same 28 credit unions over time, even if at some point they grow above the $50m or chose a different Data Processor. (Try to build this group...see if you get the same answer...)&lt;br /&gt;&lt;br /&gt;One thing to note: when you save a Custom Built PG as a Static PG and you decide to edit it at any point in the future, Peer 2.0 will open the PG using the Simple Build feature. (Confused?) That&#39;s because when you chose &quot;Static&quot; it just saved the secret-IDs...so the next time around, Peer doesn&#39;t remember the criteria you originally selected. It would be cool if it did (eg. It still opens in Simple Build but says &quot;the original criteria was...&quot; But that&#39;s for the upgrade list. Daniel? are you listening? :))&lt;br /&gt;&lt;br /&gt;One last thing: custom peer groups are saved with a (D) or an (S) after the name...can you now guess what that stands for?&lt;br /&gt;&lt;br /&gt;Tomorrow....Custom graphing.</description><link>http://peerific.blogspot.com/2009/07/more-on-peer-groups-simple-v-custom.html</link><author>noreply@blogger.com (Alix)</author><thr:total>1</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-6843414357668602587</guid><pubDate>Sun, 12 Jul 2009 18:00:00 +0000</pubDate><atom:updated>2009-07-12T15:35:16.470-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">account selection</category><category domain="http://www.blogger.com/atom/ns#">custom graphs</category><category domain="http://www.blogger.com/atom/ns#">data formats</category><category domain="http://www.blogger.com/atom/ns#">formula wizard</category><title>Custom Graphing: The Account Selection Screen</title><description>The Account Selection screen is a necessary evil in the creation of custom graphs. Here&#39;s a quick overview.&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjSzeVpRokpAYT8ngJBaHBf0qZaZuT-YNJyY3K2N7T5x24QWmbZ5tVMX9-LrMN0N6ngAvS1qi-aN_n8Np56j2M35QvOCtYNpJkVR-f-xJW1aU8p92L9Xh1UdTeOcDR7lKo_Qe-aRA/s1600-h/Slide2.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 261px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjSzeVpRokpAYT8ngJBaHBf0qZaZuT-YNJyY3K2N7T5x24QWmbZ5tVMX9-LrMN0N6ngAvS1qi-aN_n8Np56j2M35QvOCtYNpJkVR-f-xJW1aU8p92L9Xh1UdTeOcDR7lKo_Qe-aRA/s400/Slide2.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357619665109117762&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Graph Title:&lt;/span&gt; Ok, this one is obvious. It&#39;s the title on the graph.&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Formula:&lt;/span&gt; This is where you type in account codes from the 5300 form credit unions report to NCUA as well as many &quot;formula shortcuts&quot; (eg. &quot;assets&quot;, &quot;loans&quot;, &quot;shares&quot;. More on these shortly). I keep a print out of the 5300 on my desk, earmarked and highlighted. Don&#39;t have one? You can go to the help menu on Peer and print one out (including instructions).  OR, you can use the binoculars, or &quot;Formula Wizard&quot;. (I&#39;ll get to that at the end...I&#39;m tackling the easy stuff in this post.)&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Titles to Use:&lt;/span&gt; This is what will show on the legend or chart labels. If you just type in a simple account code like a703, Peer will automatically fill in a label for you (in this case &quot;Total 1st Mortgage Loans  Outstanding&quot;). I usually retype them in shorter formats.&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Format Type: &lt;/span&gt;This helps you format the output. Peer &lt;span style=&quot;font-style: italic;&quot;&gt;usually &lt;/span&gt;gets the format correct, but if not, you can change it yourself.&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Arrows: &lt;/span&gt;Major upgrade from Peer 1--you can easily rearrange the items on your list using these arrows. Simply put your cursor on the item you want to move, and click up or down until it&#39;s in the right place.&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Delete: &lt;/span&gt;Obvious--you can delete a row.  Simply put your cursor on the item you want to delete.&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Insert: &lt;/span&gt;By default, there is only space 15 items. You can add more by clicking Insert. It adds another row to the bottom.&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHMd5BdB8l0b630CAPvNT7APzpmzl94lHvDXjWrCvzwyazatsdYZhwWAKYDIDinnQDUn86J_H02sV5trLKufEg9eFV9-yw2xz__G4i3qsc3iXWv78fTAqupu3yjWikbw0mxjltdTc/s1600-h/Slide7.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 58px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHMd5BdB8l0b630CAPvNT7APzpmzl94lHvDXjWrCvzwyazatsdYZhwWAKYDIDinnQDUn86J_H02sV5trLKufEg9eFV9-yw2xz__G4i3qsc3iXWv78fTAqupu3yjWikbw0mxjltdTc/s400/Slide7.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357624649474458418&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;These radio buttons dictate what comparisons will be shown on your table or graph. The output depends on the type of chart you selected, but in general: if you just want to see your primary &amp;amp; comparisons, leave the top option selected. If you want to look at the individual credit unions that comprise your peer group comparisons, go ahead and add the second button. &lt;span style=&quot;font-weight: bold;&quot;&gt;If you don&#39;t want to see the Peer Group averages, &lt;/span&gt;uncheck the top option and only select the bottom one. This will remove the Peer Group averages from the display.&lt;br /&gt;&lt;br /&gt;&lt;a href=&quot;http://peerific.blogspot.com/2009/07/formula-wizard.html&quot;&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Binoculars/Formula Wizard&lt;/span&gt;&lt;/a&gt;: A bit of history: In Peer 1, rather than show a set of binoculars as the icon, it was a magic wand...thus the name &quot;Formula Wizard&quot;. It really needs a new name like &quot;Account Look-up Tool.&quot; In any case, this deserves a post of its own. &lt;a href=&quot;http://peerific.blogspot.com/2009/07/formula-wizard.html&quot;&gt;Click here&lt;/a&gt;.</description><link>http://peerific.blogspot.com/2009/07/custom-graphing-account-selection.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjSzeVpRokpAYT8ngJBaHBf0qZaZuT-YNJyY3K2N7T5x24QWmbZ5tVMX9-LrMN0N6ngAvS1qi-aN_n8Np56j2M35QvOCtYNpJkVR-f-xJW1aU8p92L9Xh1UdTeOcDR7lKo_Qe-aRA/s72-c/Slide2.JPG" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-3413069518954579344</guid><pubDate>Sun, 12 Jul 2009 17:22:00 +0000</pubDate><atom:updated>2009-07-12T15:31:51.632-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">5300</category><category domain="http://www.blogger.com/atom/ns#">account selection</category><category domain="http://www.blogger.com/atom/ns#">formula wizard</category><category domain="http://www.blogger.com/atom/ns#">formulas</category><category domain="http://www.blogger.com/atom/ns#">personnel</category><category domain="http://www.blogger.com/atom/ns#">save time</category><category domain="http://www.blogger.com/atom/ns#">suppliers</category><category domain="http://www.blogger.com/atom/ns#">user error</category><title>The &quot;Formula Wizard&quot;</title><description>Most long-time Peer users are familiar with the phrase &quot;Formula Wizard&quot; to describe the tool that allows you to find accounts when building custom graphs or peer groups. In Peer 1, the icon used to a be a little magic wand (I&#39;ll bet many of you never even realized that...it took me 2 years to figure it out).&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBB0W2cvCc2g-QYwoTqLp0MARV5C3rbY6g_pZAaFhbsh1NgxO_rVaeTtwoA8H4VHN-03r4PG90NtqccxZk5jeiIn-k8v_NneABOBpDd6-xGnlf447u3R1bmlfKNORko5wxnRfRgcM/s1600-h/slide4.jpg&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 97px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBB0W2cvCc2g-QYwoTqLp0MARV5C3rbY6g_pZAaFhbsh1NgxO_rVaeTtwoA8H4VHN-03r4PG90NtqccxZk5jeiIn-k8v_NneABOBpDd6-xGnlf447u3R1bmlfKNORko5wxnRfRgcM/s400/slide4.jpg&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357658294446580258&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;The icon for Peer 2&#39;s Formula Wizard (FW) is a set of binoculars so now we need a new name for it. Ideas?&lt;br /&gt;&lt;br /&gt;Admission: the new FW isn&#39;t as comprehensive in some ways as Peer 1 (yes, we&#39;ve heard from those of you who liked the Simple mode in Peer 1) but it&#39;s better in other ways. Bear with the software team as they balance the need to make something very complicated user friendly &lt;span style=&quot;font-weight: bold;&quot;&gt;and&lt;/span&gt; comprehensive at the same time.&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;So, what is the Formula Wizard (FW)? &lt;/span&gt;The FW is designed to give Peer users quick access to the most commonly used account codes on the 5300, as well as dozens (hundreds?) of formulas and shortcuts to make your analysis easier. Ok, so how does it work? When you click on the binoculars, you are presented with this screen:&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjs9WP1UXdqApRKkZEp_OB2FDl4EdpvPiS9_pbqJIDDR-n_kT5BsZq34MnVrkCd7mbiGAposdMYSkJOLNmCXASloIu5p4wyQ0NHPiySUkPwgN7KK6Y-PnhCTh4oAqlBCjqmWkx_eT8/s1600-h/Slide1.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 221px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjs9WP1UXdqApRKkZEp_OB2FDl4EdpvPiS9_pbqJIDDR-n_kT5BsZq34MnVrkCd7mbiGAposdMYSkJOLNmCXASloIu5p4wyQ0NHPiySUkPwgN7KK6Y-PnhCTh4oAqlBCjqmWkx_eT8/s400/Slide1.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357648134511314530&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;As you can see, it&#39;s organized like the 5300 itself.  I&#39;ll discuss the Loan section in some detail (already highlighted in the above image), and you can extrapolate from there for the Other Assets, Liabilities and Income/Expense sections. At the bottom of this post, I&#39;ll cover Ratios &amp;amp; Scoring, Contacts &amp;amp; My Formula(s) (Typo....programmers, please fix!).&lt;br /&gt;&lt;br /&gt;As you can see above, when you highlight the main Loan folder, there is a list general loan formulas: loan growth, average loan balance, etc.  To drill down into specific areas of the Loan portfolio, highlight the sub-sections. Here is an example from the Real Estate section. (Note, if you&#39;re familiar with Schedule A, you know that there are multiple &quot;704&quot; codes...704a, 704b, etc. we&#39;ve combined them into a704 so you don&#39;t have to type them all in. )&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibT2VG-7UeCZUC8E0LfZIt4zPtpi28KURcnx0aNwaJzPsUq4HV13aEDsmYcIM9_vadeGzliA7a98fmvaQVc1dWYJQ4msfx6rt-IyPrU3RkscEq0IB4w_r2qUGXlpEr8rHVL4MVlNI/s1600-h/Slide2.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 220px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibT2VG-7UeCZUC8E0LfZIt4zPtpi28KURcnx0aNwaJzPsUq4HV13aEDsmYcIM9_vadeGzliA7a98fmvaQVc1dWYJQ4msfx6rt-IyPrU3RkscEq0IB4w_r2qUGXlpEr8rHVL4MVlNI/s400/Slide2.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357648148446096498&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;If you got to the FW from the custom graphing page, just double click on any account to add it to the Account Selection screen. You&#39;ll see it added to the list on the bottom right (where a703 is listed).&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Ratios &amp;amp; Scoring&lt;/span&gt;: This section contains our world-famous &lt;a href=&quot;http://www.creditunions.com/article.aspx?articleid=2851&quot;&gt;ROM ranking&lt;/a&gt;, as well as NCUA&#39;s Financial Performance Ratios (FPR), shortcuts for the PCA calculations and some of our favorite productivity &amp;amp; efficiency ratios.&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Contacts, Services &amp;amp; Partners: &lt;/span&gt;This section contains 2 types of proprietary, non-5300 data that Callahan &amp;amp; Associates collects, as well as information from the CUSO and IT schedules of the 5300. The proprietary data includes 9 personnel titles (ranging from CEO to CLO to CMO) and a dozen supplier relationships (what company the credit union uses for the data processing or home banking platforms for example...new field including mobile banking and RDC will be coming in the next data cycle).&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;My Formulas: &lt;/span&gt;Here is where you can create your own shortcuts. For example, there are 10 accounts that make-up &quot;Equity&quot; and no shortcut (yes, I&#39;ve added it to the request list). In the meantime, you can add it to your own shortcuts under My Formulas. Now, going forward, all you ever have to type is &quot;Equity&quot; rather than a940+a931+a668+a658+a658a+&lt;br /&gt;a996+a945+a945a+a945b+a602 (Whew!).&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkIBdXubSVb3QAB3nzi8M3p7aWoXKdAUDitPbfE3_SPePPIL8MK6wfJGKLFzSMXNsgYGU0STea8SpshhWZzLDsPteOK5Gxu5UFMmATrS_feLNrOtOO5NyEax6MKR4JLtmq4Ucmdwg/s1600-h/slide3.jpg&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 221px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkIBdXubSVb3QAB3nzi8M3p7aWoXKdAUDitPbfE3_SPePPIL8MK6wfJGKLFzSMXNsgYGU0STea8SpshhWZzLDsPteOK5Gxu5UFMmATrS_feLNrOtOO5NyEax6MKR4JLtmq4Ucmdwg/s400/slide3.jpg&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5357651259765849154&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;One cautionary note: if you create your own formulas or custom graphs, be sure to check all formulas each time NCUA releases new accounts. In the above Equity example, I was helping a client convert their Peer 1 custom displays and we found out they had never updated their formula for equity and were missing accounts added in the last year.&lt;br /&gt;&lt;br /&gt;Our analysts review all the accounts before we release each quarter to make sure the same shortcuts reflect any changes in the call report. So, if you use our built-in formulas, we take care of that for you. For example, &quot;Mutual Funds &amp;amp; Common Trusts&quot; were grouped together under a743c until 1Q09. Now they are, respectively, a743d and a743e.</description><link>http://peerific.blogspot.com/2009/07/formula-wizard.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBB0W2cvCc2g-QYwoTqLp0MARV5C3rbY6g_pZAaFhbsh1NgxO_rVaeTtwoA8H4VHN-03r4PG90NtqccxZk5jeiIn-k8v_NneABOBpDd6-xGnlf447u3R1bmlfKNORko5wxnRfRgcM/s72-c/slide4.jpg" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-6201346283072003916</guid><pubDate>Fri, 10 Jul 2009 12:00:00 +0000</pubDate><atom:updated>2009-07-10T08:00:04.707-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">benchmarking</category><category domain="http://www.blogger.com/atom/ns#">dynamic</category><category domain="http://www.blogger.com/atom/ns#">peer groups</category><category domain="http://www.blogger.com/atom/ns#">static</category><title>Dynamic v. Static</title><description>What&#39;s a dynamic v. a static peer group? This is a question that stumps a lot of people. Here&#39;s an example...&lt;br /&gt;&lt;br /&gt;A dynamic peer group will update its &quot;members&quot; each quarter. So, say you built a group of credit unions over $1 billion in assets back in February when 4Q data was the latest cycle. At that point, Peer built you a group of 146 credit unions and calculated their average performance to show on the charts and tables.&lt;br /&gt;&lt;br /&gt;If you saved it as a &quot;Dynamic&quot; peer group, when you loaded 1Q09 data, Peer took at look at the new data and said &quot;hm..there are now 153 credit unions.&quot; At that time, it recalculated the average performance of &lt;span style=&quot;font-style: italic;&quot;&gt;those&lt;/span&gt; 153 credit unions so your graphs/tables displayed the current $1b+ credit unions&#39; performance.&lt;br /&gt;&lt;br /&gt;If you had saved it as a &quot;Static&quot; peer group, Peer stored the super-secret-never-changing-ID-number for those 146 credit unions. When you loaded 1Q data, it took the new data for those 146, &lt;span style=&quot;font-style: italic;&quot;&gt;whether or not they fit the original criteria of being larger than $1billion&lt;/span&gt;, and recalculated the peer group performance.&lt;br /&gt;&lt;br /&gt;Ok, now that that&#39;s clear... (ha ha) More on Dynamic v. Static and Simple v. Custom on Monday. Have a good weekend.</description><link>http://peerific.blogspot.com/2009/07/dynamic-v-static.html</link><author>noreply@blogger.com (Alix)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-2841572018542416013</guid><pubDate>Thu, 09 Jul 2009 12:00:00 +0000</pubDate><atom:updated>2009-07-09T08:00:02.046-04:00</atom:updated><title>Did you know...you can do county level comparisons?</title><description>There&#39;s a really easy way to select credit unions by county when building Peer Groups. (If you already know how to do this, Kudos! But keep reading--or at least skip to the end of this post for a special offer the Peer team said I could extend to see who was paying attention to this blog!)&lt;br /&gt;&lt;br /&gt;So, say you are hosting a webinar on the &lt;a href=&quot;http://www.creditunions.com/cutv/play.aspx?eventid=453&quot;&gt;Allowance for Loan Losses&lt;/a&gt; (theoretically). You want to make a point about how some counties are hit harder than others, and you decide to pick on Riverside County (theoretically). To prove your point, you want to show Riverside County CUs vs the State of California. Simply go to Peer Groups--&gt;New--&gt;Custom Build.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmPHZU-jTjEvaoTbVaj1AuRrKfwrI8Jw-_0xiriZkzXW31Dpwlc6O4BAOzping1fnD8nECOLXSDDOOXat8ZDsDtkJejdg52JIx_Z2jqbQl08VPWzeWfoU6xG0yGmcbzPv9CZHQuY8/s1600-h/Slide1.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 103px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmPHZU-jTjEvaoTbVaj1AuRrKfwrI8Jw-_0xiriZkzXW31Dpwlc6O4BAOzping1fnD8nECOLXSDDOOXat8ZDsDtkJejdg52JIx_Z2jqbQl08VPWzeWfoU6xG0yGmcbzPv9CZHQuY8/s400/Slide1.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5356254733321580690&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;Click on the Geography tab, and select &quot;Clear All&quot; on the map to deselect all states.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGVm4eRJo3IBXDh_GWnF1WcC3Bn5CatKFPwCYuui8T_UHbgjmk1rkgI8rW6EHogtw-9Kb8Anv1zwnLIkKD23ffQ_utQb_Xw211Z0f8DyfU7ryqN4A6xYJ2amDtxKBWzkUbCxYXgpc/s1600-h/Slide2.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGVm4eRJo3IBXDh_GWnF1WcC3Bn5CatKFPwCYuui8T_UHbgjmk1rkgI8rW6EHogtw-9Kb8Anv1zwnLIkKD23ffQ_utQb_Xw211Z0f8DyfU7ryqN4A6xYJ2amDtxKBWzkUbCxYXgpc/s400/Slide2.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5356254725562517026&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;Then, (and here&#39;s the little-known secret) double-click on the state of California. Voila! A county map. Click on Riverside county (ok, you need a magnifying glass to read the county names, but I&#39;m guessing that if you are drilling down to the county level, you know generally where they are in the state. If not, select from the alpha list on the right). &lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSsF5RfRyIK6rPQX79bAkkh-FfhstBpjTdfDUWd_70zo6YmBisWWIEUmpXzv4v9nzandiJIk8NLfPeE4HxjYklnkqYkF3yzRcrCm1MorkkTPYVFzVkO7F8Ap3QDm2LaKd5CLJ9y_8/s1600-h/Slide3.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSsF5RfRyIK6rPQX79bAkkh-FfhstBpjTdfDUWd_70zo6YmBisWWIEUmpXzv4v9nzandiJIk8NLfPeE4HxjYklnkqYkF3yzRcrCm1MorkkTPYVFzVkO7F8Ap3QDm2LaKd5CLJ9y_8/s400/Slide3.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5356254732254836386&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Done. Save the Peer Group. Make it your primary and add another custom peer group (the entire state). Run some analysis. Prove (or disprove) your point.&lt;br /&gt;&lt;br /&gt;Ok, now to the special offer. If this analysis is interesting to you, you might also be interested in Branch Analyzer. BA is part of Callahan&#39;s online software tool CUAnalyzer and contains data on the nation&#39;s 100,000+ bank and credit union branches (no, that&#39;s not a typo). It is crazy useful in analyzing branch level performance and can help you detect trends and opportunities for credit unions to capture market share.&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEji6iIQi0QI6s7SJlVNnG5RFKHyPqbe4M5Kr1QKTuSmeP7OQ-uPgNnukagzaqgkxPrMJvfqUxdCbxcmh_2UjVIVyc2dEkOsDaBtLsezeGuFbAVdsjMCYrnV6ecw6FmwJZGG2F_8Nt4/s1600-h/Slide4.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEji6iIQi0QI6s7SJlVNnG5RFKHyPqbe4M5Kr1QKTuSmeP7OQ-uPgNnukagzaqgkxPrMJvfqUxdCbxcmh_2UjVIVyc2dEkOsDaBtLsezeGuFbAVdsjMCYrnV6ecw6FmwJZGG2F_8Nt4/s400/Slide4.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5356254721654799426&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;The screenshot above is just one report from BA. It&#39;s too small to read, so here are the fields shown:&lt;br /&gt;&lt;br /&gt;Institution Name&lt;br /&gt;Number of Branches at 6/08&lt;br /&gt;Number of Branches at 6/07&lt;br /&gt;Branch change from previous year&lt;br /&gt;Total $ Deposits 6/08&lt;br /&gt;Total $ Deposits 6/07&lt;br /&gt;Deposit change from previous year&lt;br /&gt;12 mo. Dep. Growth&lt;br /&gt;Market Share 6/08&lt;br /&gt;Market Share 6/07&lt;br /&gt;Market Share change from previous year&lt;br /&gt;&lt;br /&gt;So, if you&#39;re reading this blog and want to get a county analysis (for free), you only have to email me at alix @ creditunions.com. I&#39;ll have someone do the legwork for you. You&#39;ll look brilliant to your colleagues; I&#39;ll prove I have at least 1 follower.</description><link>http://peerific.blogspot.com/2009/07/drill-down-to-county-level.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmPHZU-jTjEvaoTbVaj1AuRrKfwrI8Jw-_0xiriZkzXW31Dpwlc6O4BAOzping1fnD8nECOLXSDDOOXat8ZDsDtkJejdg52JIx_Z2jqbQl08VPWzeWfoU6xG0yGmcbzPv9CZHQuY8/s72-c/Slide1.JPG" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-8495971289763223137</guid><pubDate>Wed, 08 Jul 2009 12:32:00 +0000</pubDate><atom:updated>2009-07-08T08:32:17.401-04:00</atom:updated><title>Exporting graphs to PPT...a workaround</title><description>A feature missing in Peer 2 is the ability to export an entire folder of graphs to PPT. Currently, you must do each one individually and if you click on the PPT icon, it opens a new instance of the program each time. The programmers have this on the fix list, but in the meantime I thought I&#39;d share a shortcut that someone &#39;accidentally&#39; stumbled on.&lt;br /&gt;&lt;br /&gt;The first step is to click on &quot;Copy&quot; not &quot;PowerPoint&quot;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMfjG2q8zkyKl-W1eEvovrqd2wsGKXLYnoRisPy-M_Ogi6tra4D8SLoU2z5wuX_c2pK_LrWGTn-gzexhfmzSu92Ix50z_uwmdYTbmp4iDsHdZgWUw4FbWDdAOlMiRUUgRVucnhAzU/s1600-h/Slide1.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 67px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMfjG2q8zkyKl-W1eEvovrqd2wsGKXLYnoRisPy-M_Ogi6tra4D8SLoU2z5wuX_c2pK_LrWGTn-gzexhfmzSu92Ix50z_uwmdYTbmp4iDsHdZgWUw4FbWDdAOlMiRUUgRVucnhAzU/s400/Slide1.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5355849626693578658&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;Next, open a new PPT presentation and select the layout that has a title box and content box, as seen below. Click&lt;span style=&quot;font-style: italic;&quot;&gt; &lt;/span&gt;inside the box like you were going to type in text. &lt;span style=&quot;font-weight: bold;&quot;&gt;This is the critical step &lt;/span&gt;(and what had me jumping for joy when I found it)&lt;span style=&quot;font-weight: bold;&quot;&gt;. &lt;/span&gt;If you &lt;span style=&quot;font-style: italic;&quot;&gt;don&#39;t&lt;/span&gt; highlight the box, the image pastes too large for the slide and you have re-size each one (don&#39;t ask how many presentations I built this way before figuring it out...)&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXdxD12sjHHSPUEvNAViQaTi0IldusVxL-6afe6varSqx5WI3uoCa8A0lVytrAoYpdnUBxaXJ4ihNECfiyRyCiOA1KwQdcjC8EGPi1tZ-zIkrBXUdWJqXBdTWBx7ACjHOe6y07ioM/s1600-h/Slide2.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXdxD12sjHHSPUEvNAViQaTi0IldusVxL-6afe6varSqx5WI3uoCa8A0lVytrAoYpdnUBxaXJ4ihNECfiyRyCiOA1KwQdcjC8EGPi1tZ-zIkrBXUdWJqXBdTWBx7ACjHOe6y07ioM/s400/Slide2.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5355848672698531058&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Hit CTRL + V (for paste). The graph image is inserted in the box. Type in a title (hint: the graph already has a description--eg. &quot;Loan Composition&quot;--so make a statement about what you want the audience to take away from the graph).&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFPjQQ0fWa-zcCB7rnC_l7gO9skI9KnGleG6TDfpKiPmZkY6yRi8zwH_iCU-CXbOEysNSdAwPSPzcCwz8fYrVf16Nfp58NVBqQnFo5CMC4kwgD2PWosXu2wV1QexMpxK22AurtC50/s1600-h/Slide3.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFPjQQ0fWa-zcCB7rnC_l7gO9skI9KnGleG6TDfpKiPmZkY6yRi8zwH_iCU-CXbOEysNSdAwPSPzcCwz8fYrVf16Nfp58NVBqQnFo5CMC4kwgD2PWosXu2wV1QexMpxK22AurtC50/s400/Slide3.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5355848677149302690&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Repeat as necessary. Not quite as simple and clean as Peer 1, but it&#39;s a decent work around until that upgrade is done.</description><link>http://peerific.blogspot.com/2009/07/exporting-graphs-to-ppta-workaround.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMfjG2q8zkyKl-W1eEvovrqd2wsGKXLYnoRisPy-M_Ogi6tra4D8SLoU2z5wuX_c2pK_LrWGTn-gzexhfmzSu92Ix50z_uwmdYTbmp4iDsHdZgWUw4FbWDdAOlMiRUUgRVucnhAzU/s72-c/Slide1.JPG" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-7453266326505039472</guid><pubDate>Wed, 08 Jul 2009 11:03:00 +0000</pubDate><atom:updated>2009-07-08T07:03:02.397-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">built-in displays</category><category domain="http://www.blogger.com/atom/ns#">custom graphs</category><category domain="http://www.blogger.com/atom/ns#">formatting</category><title>Ooo....Pretty colors...</title><description>This is a post for all those designer types who don&#39;t just like what the data has to say, you want it to LOOK good too. (Or, you sit 10 feet from a designer who always gives you an earful when presentations aren&#39;t professional looking, like I do). In either case, this post is for you!&lt;br /&gt;&lt;br /&gt;As you may have figured out by now, the default color settings for graphs in Peer 2.0 match Office 2007. That was purposeful. There is a lot you can do in Peer 2, but sometimes you need to export data and manipulate it in Excel or PowerPoint. With the default settings you don&#39;t have to do a lot of editing of colors to make it match between Peer 2 graphs and those created in Office 2007.&lt;br /&gt;&lt;br /&gt;But what if you have a credit union &quot;brand style sheet&quot; that your presentations are supposed to match? Here&#39;s a quick way to change your default colors.&lt;br /&gt;&lt;br /&gt;Go to Tools --&gt; Graphics Settings --&gt; Color Palette. Select New Palette.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-8J8bpiKpvO52uTM2aZTIi8uXI_CzkV9h1gdN7axoWO2eu-47PHFuN3Olf9jlZ_GgMomXUQjm_-5yJqCy9Ciuh350BRXdJ2DfIyzCP5SqQQ6MKIBRBBUu56Kolh6Vwt2BRuSIrGw/s1600-h/Slide1.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 127px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-8J8bpiKpvO52uTM2aZTIi8uXI_CzkV9h1gdN7axoWO2eu-47PHFuN3Olf9jlZ_GgMomXUQjm_-5yJqCy9Ciuh350BRXdJ2DfIyzCP5SqQQ6MKIBRBBUu56Kolh6Vwt2BRuSIrGw/s400/Slide1.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5354611227320971330&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhG6RyJtJ4J3st5rjlApCMC3Y9duuZ9dY-UHGNqDVQmje_xJqcIRe0W62ldfHVtSh4Lq-7nYtr9lnEop3Ni12TaoYBfbh9HeIrdAV53Pg8U8Bo_aBU5zkTfJXFWY2WHsNVyWCTCr9E/s1600-h/Slide2.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhG6RyJtJ4J3st5rjlApCMC3Y9duuZ9dY-UHGNqDVQmje_xJqcIRe0W62ldfHVtSh4Lq-7nYtr9lnEop3Ni12TaoYBfbh9HeIrdAV53Pg8U8Bo_aBU5zkTfJXFWY2WHsNVyWCTCr9E/s400/Slide2.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5354611232606202402&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Click on the little box next to Color 1 to get the standard Window&#39;s color picker. If you don&#39;t like the 48 default options, get creative and select Define Custom Colors. Here you can play around with all sorts of colors and shades, or just ask your Marketing Department for the RGB breakdown of your credit union&#39;s primary colors.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCbl39-_UFdcmQYwfZBIfOCiI3u8H55azxU1VCE1KKJqp5q-EBSmwhE22osRnukdmi7Sg2_wp34ZSZT40Ty-s5XQcFrZFQspmaMJ5XzLozyKGAx9fcQx0PPP6_9HP5GHUm3Qciyag/s1600-h/Slide3.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCbl39-_UFdcmQYwfZBIfOCiI3u8H55azxU1VCE1KKJqp5q-EBSmwhE22osRnukdmi7Sg2_wp34ZSZT40Ty-s5XQcFrZFQspmaMJ5XzLozyKGAx9fcQx0PPP6_9HP5GHUm3Qciyag/s400/Slide3.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5354611235262658658&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Repeat for all 10 colors. Name your palette and select &quot;Save as Default&quot; (you can always switch back to the Windows Palette).&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPnzXcWnVqaEbyyVtC7_uoSBuCr4uLnq7e5Kb6BXNINgFpRoMZr5qMJQTpf-ZiVaO0MMyyrSwBGEn0Ww15hkJv6c_XIeJM4N5qkR1Xehlyvky1UoWxCnhEOzvvKYOrb2F04sVyq1A/s1600-h/Slide4.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPnzXcWnVqaEbyyVtC7_uoSBuCr4uLnq7e5Kb6BXNINgFpRoMZr5qMJQTpf-ZiVaO0MMyyrSwBGEn0Ww15hkJv6c_XIeJM4N5qkR1Xehlyvky1UoWxCnhEOzvvKYOrb2F04sVyq1A/s400/Slide4.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5354611239269404738&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Voila!&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdPXcRmTBDF6sP2AYDa-PaCze-FNJPNoP4GWr6H2meiFIGb6OjsFs_8tLuwcF2DfTbLbpzJr8hC79AKQ7cC10TaGElztQQd-Rt9z7_yLIFIpd7mVeoZtKPPlKn7SAefu8JvNlikgs/s1600-h/Slide5.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdPXcRmTBDF6sP2AYDa-PaCze-FNJPNoP4GWr6H2meiFIGb6OjsFs_8tLuwcF2DfTbLbpzJr8hC79AKQ7cC10TaGElztQQd-Rt9z7_yLIFIpd7mVeoZtKPPlKn7SAefu8JvNlikgs/s400/Slide5.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5354611244170981330&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMFkwthDKWYHsF2nKbVooX7gGXtUfNw1fJtstx6GQxXGZCgnk2ziT36bk2XROE3ApCz4K9S8g2klJpT759ePpWp4cRaD86DNn5YPxTsw707vtcj3yE8lqWjoE-5WlxFLPPfBs6O2o/s1600-h/Slide6.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMFkwthDKWYHsF2nKbVooX7gGXtUfNw1fJtstx6GQxXGZCgnk2ziT36bk2XROE3ApCz4K9S8g2klJpT759ePpWp4cRaD86DNn5YPxTsw707vtcj3yE8lqWjoE-5WlxFLPPfBs6O2o/s400/Slide6.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5354611622754461362&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;</description><link>http://peerific.blogspot.com/2009/07/ooopretty-colors.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-8J8bpiKpvO52uTM2aZTIi8uXI_CzkV9h1gdN7axoWO2eu-47PHFuN3Olf9jlZ_GgMomXUQjm_-5yJqCy9Ciuh350BRXdJ2DfIyzCP5SqQQ6MKIBRBBUu56Kolh6Vwt2BRuSIrGw/s72-c/Slide1.JPG" height="72" width="72"/><thr:total>1</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-1221680443360626299</guid><pubDate>Tue, 07 Jul 2009 12:03:00 +0000</pubDate><atom:updated>2009-07-07T08:03:02.955-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">error message</category><category domain="http://www.blogger.com/atom/ns#">peer groups</category><category domain="http://www.blogger.com/atom/ns#">user error</category><title>Funny Error Message: &quot;List that this enumerator...&quot;</title><description>This is for all you Peer 1.0 Users who may remember some truly bizarre error messages encountered over the years.&lt;br /&gt;&lt;br /&gt;First, I have to admit that this error was prompted by User (my own) error--I tried to delete a Peer Group that I was using in my comparison set. Peer didn&#39;t like that and told me so with a nice straight forward explanation. But then I got this explanation, in case the original &quot;you can&#39;t delete a peer group in your current comparison set&quot; wasn&#39;t clear:&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg04ioKSkd8CvTwcmoS2AHKKNttq6bwSRTGN9tzCfFe4mxK1X02itQY5Oe_DuWDzWherVChnhpB3_w9iO-IxTmWUh8dda39ioHqX47dg_9ZRnofNKsLljuaxfBcUSgw2SnrLyjIMRs/s1600-h/error.jpg&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 72px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg04ioKSkd8CvTwcmoS2AHKKNttq6bwSRTGN9tzCfFe4mxK1X02itQY5Oe_DuWDzWherVChnhpB3_w9iO-IxTmWUh8dda39ioHqX47dg_9ZRnofNKsLljuaxfBcUSgw2SnrLyjIMRs/s400/error.jpg&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5354588817866556530&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;Have you encountered any good ones? Tell me! (Regrettably, your confession may come at the expense of others not being able to enjoy a good laugh because the programming team is monitoring this blog. They will end up re-writing the error messages.)</description><link>http://peerific.blogspot.com/2009/07/funny-error-message-list-that-this.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg04ioKSkd8CvTwcmoS2AHKKNttq6bwSRTGN9tzCfFe4mxK1X02itQY5Oe_DuWDzWherVChnhpB3_w9iO-IxTmWUh8dda39ioHqX47dg_9ZRnofNKsLljuaxfBcUSgw2SnrLyjIMRs/s72-c/error.jpg" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-1900441047320713737</guid><pubDate>Mon, 06 Jul 2009 16:24:00 +0000</pubDate><atom:updated>2009-07-06T12:24:00.142-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">benchmarking</category><category domain="http://www.blogger.com/atom/ns#">peer groups</category><category domain="http://www.blogger.com/atom/ns#">save time</category><category domain="http://www.blogger.com/atom/ns#">share</category><title>Share your custom peer groups</title><description>Peer 2.0 comes with 10 standard (ie. asset-based) Peer Groups already built-in. Usually though, credit unions build a custom peer group against which to benchmark their performance (isn&#39;t this the reason you bought Peer after all?). Rather than make every analyst on your team go through the effort of re-creating the Peer Group, simply share the one you already built! Here&#39;s how.&lt;br /&gt;&lt;br /&gt;(Assumption: You&#39;ve already created the Peer Group). Go to the Peer Groups menu and Select Share.&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCwK_p_sZl1sGWaS527aPW7bdh6IJeInUkRK4_r05Dn7QR9w7L_gdnWSeFtY8fBmhTGWemusua8kqAL2izDrNbfhgNjzVlEI-LgpWGD0XySazTE1r_2QweHdqPwVuJaVIlZkl-r0I/s1600-h/Slide1.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 380px; height: 185px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCwK_p_sZl1sGWaS527aPW7bdh6IJeInUkRK4_r05Dn7QR9w7L_gdnWSeFtY8fBmhTGWemusua8kqAL2izDrNbfhgNjzVlEI-LgpWGD0XySazTE1r_2QweHdqPwVuJaVIlZkl-r0I/s400/Slide1.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5354247661152736466&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Here you will see a list of Peer Groups available in your desktop version of Peer. Select the one you wish to share with others (Peer will show you the credit unions in the group in the window below).&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkD4bqy-t0ASqgfs5rd9Bx4uRm4c_p2_SXQ9FAq6yuw3ZRJPBWAuYT57IwFLSrGYvtfok7sAvqm4JvE_wZ6Ww9q19SREhOzfz5SrgnqyD_DGswPrHnyfUfrMra2uiFz8l2Y348owA/s1600-h/Slide2.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 397px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkD4bqy-t0ASqgfs5rd9Bx4uRm4c_p2_SXQ9FAq6yuw3ZRJPBWAuYT57IwFLSrGYvtfok7sAvqm4JvE_wZ6Ww9q19SREhOzfz5SrgnqyD_DGswPrHnyfUfrMra2uiFz8l2Y348owA/s400/Slide2.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5354247658038090114&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Now, you have a couple of options. If you want other analysts to import the Peer Group into their version of Peer, select either Export .p2p (this exports the .P2P to a location of your choice) or Email (which attaches the .P2P file to an email message in your default email program). Done!&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Want to import a Peer Group someone else created?&lt;/span&gt; On the Peer groups menu, select Manage OR from the File Menu select Import --&gt; Peer Groups. Either way, you&#39;ll get a new window with one option being Import.  Click on it.&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0OkyqX-KlgngLo-_PVM6Uym3OZScuT8WrAXPqk3lmXy-M3IDmESPsXmsPILnvGT24CLOsSXcnfwmLnfEhQDRXtLhFjKfOo1bqAnqcfbX6ua-pbKH5FPTTQvmhU3wzSCKW0IYyUeY/s1600-h/Slide3.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 349px; height: 400px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0OkyqX-KlgngLo-_PVM6Uym3OZScuT8WrAXPqk3lmXy-M3IDmESPsXmsPILnvGT24CLOsSXcnfwmLnfEhQDRXtLhFjKfOo1bqAnqcfbX6ua-pbKH5FPTTQvmhU3wzSCKW0IYyUeY/s400/Slide3.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5354247655673856194&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Find the .P2P file you received from someone else (I assume here you already saved it somewhere). Click Open and you will be prompted to name and save the Peer Group.&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4jSc1ud_l1GqoecE5PU-Cfaf7uLjILMhNto7d3BXTgC-Ybtb7tr66O_nPkdcQhNiUgJPwMTVxDGsiALMG2ZDvCWgBrny3P36DFREVYdp6OB5a8tIs-uzDY-GoIE5fFY-N-q6CZjo/s1600-h/Slide4.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4jSc1ud_l1GqoecE5PU-Cfaf7uLjILMhNto7d3BXTgC-Ybtb7tr66O_nPkdcQhNiUgJPwMTVxDGsiALMG2ZDvCWgBrny3P36DFREVYdp6OB5a8tIs-uzDY-GoIE5fFY-N-q6CZjo/s400/Slide4.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5354247648344819346&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Done!</description><link>http://peerific.blogspot.com/2009/07/share-your-custom-peer-groups.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCwK_p_sZl1sGWaS527aPW7bdh6IJeInUkRK4_r05Dn7QR9w7L_gdnWSeFtY8fBmhTGWemusua8kqAL2izDrNbfhgNjzVlEI-LgpWGD0XySazTE1r_2QweHdqPwVuJaVIlZkl-r0I/s72-c/Slide1.JPG" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-6085832298089363137</guid><pubDate>Fri, 03 Jul 2009 14:12:00 +0000</pubDate><atom:updated>2009-07-03T10:39:05.115-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">CRC</category><category domain="http://www.blogger.com/atom/ns#">custom graphs</category><category domain="http://www.blogger.com/atom/ns#">save time</category><category domain="http://www.blogger.com/atom/ns#">share</category><title>How to share custom graphs with others (and import someone else&#39;s)</title><description>A .crc file is a way for Peer users to share custom displays (graphs, charts, tables) they created in their desktop version of Peer with other users. This way, users save time and energy by eliminating the needless duplication of effort. Here&#39;s how to create and share a CRC file.&lt;br /&gt;&lt;br /&gt;First, I&#39;m going to start with the assumption that you already have created custom graphs that you want to share. (Not sure? Go to My Displays in the left sidebar and check).&lt;br /&gt;&lt;br /&gt;Now, to export the graphs is easy. Simply go to the File menu (top left as usual) --&gt; Export --&gt; Custom Displays. Select the folder of graphs you wish to export from the list on your screen. You have 2 options: Export, which will save the file to your desktop or anywhere you designate (a shared drive for example); or Email, which will open your default email browser with the .crc file as an attachment.  Done!&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoHrysaPh5EyfG8H5bbLZEH7nJVcizQhxJrN-MOaeWGElHJJ2A4pVufMv9A_N-X1Tkyd2vrR_z_cUKSQQdbGOr6pLMQUD_dvsSmblG-6w99A8SfRxrVWjvgStrVBFtGOrDa_XXkbs/s1600-h/Slide1.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 356px; height: 400px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoHrysaPh5EyfG8H5bbLZEH7nJVcizQhxJrN-MOaeWGElHJJ2A4pVufMv9A_N-X1Tkyd2vrR_z_cUKSQQdbGOr6pLMQUD_dvsSmblG-6w99A8SfRxrVWjvgStrVBFtGOrDa_XXkbs/s400/Slide1.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5354241549766980850&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Want to import graphs from someone else? &lt;/span&gt;I assume they sent you a .crc or you downloaded one from &lt;a href=&quot;http://www.p2psoftware.com/&quot;&gt;www.p2psoftware.com&lt;/a&gt;. Save the .crc somewhere you can find it (your desktop, for example). Now, simply go to File --&gt; Import --&gt; Custom Displays. Click Browse to find the file you just saved. Name it and click on Import. Done! These graphs will be saved under My Displays in the left navigation.&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiRf8VX09WT-wJ_ZeysdwWrHWaiAQz-olSbXoM5i1NUseK-h0OCCPKOLlkNFcfk1WNgZBQ5NaVutfFzixd-bjVMYDCJM3dX7RDFqJvgwShTpEMFABW4l0IyTBAzVTgVR3yGitu0B4/s1600-h/Slide2.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 235px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiRf8VX09WT-wJ_ZeysdwWrHWaiAQz-olSbXoM5i1NUseK-h0OCCPKOLlkNFcfk1WNgZBQ5NaVutfFzixd-bjVMYDCJM3dX7RDFqJvgwShTpEMFABW4l0IyTBAzVTgVR3yGitu0B4/s400/Slide2.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5354241552730488834&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;</description><link>http://peerific.blogspot.com/2009/07/how-to-share-custom-graphs-with-others.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoHrysaPh5EyfG8H5bbLZEH7nJVcizQhxJrN-MOaeWGElHJJ2A4pVufMv9A_N-X1Tkyd2vrR_z_cUKSQQdbGOr6pLMQUD_dvsSmblG-6w99A8SfRxrVWjvgStrVBFtGOrDa_XXkbs/s72-c/Slide1.JPG" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-8338319637952038703</guid><pubDate>Thu, 02 Jul 2009 18:22:00 +0000</pubDate><atom:updated>2009-07-02T15:39:43.187-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">custom graphs</category><category domain="http://www.blogger.com/atom/ns#">Excel</category><category domain="http://www.blogger.com/atom/ns#">formatting</category><category domain="http://www.blogger.com/atom/ns#">YTD</category><title>Calculating &amp; graphing accounts reported as YTD amounts</title><description>For YTD account codes (such as 1st mortgage originations), there isn&#39;t an easy way to get quarterly numbers (this wasn&#39;t possible in Peer 1 either...i&#39;ve already suggested a fix), so you need to use Excel to calculate and graph the data. Here&#39;s how to do it.&lt;br /&gt;&lt;br /&gt;First, pull the data in a custom chart and export it to Excel. (Side note: to pull 1st mortgage originations, you can use the formula &quot;a720+a721&quot; even though the 5300 has a720a, a720b etc. We&#39;ve created the shortcut for you).&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi07A1FJsAJn3_jPoSWnuhufwc43ypF_DBM2Jc3ni2r6R65gX8rn4LzCS0SF1PQGYCTuLLhMZ_wH9-KC3bDdlGhyphenhyphenf1Th6RcQ4vNHuwKeVRzoqIUrmkhRQyqOqsIBpKdHAfGDOWZmTs/s1600-h/Slide1.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 97px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi07A1FJsAJn3_jPoSWnuhufwc43ypF_DBM2Jc3ni2r6R65gX8rn4LzCS0SF1PQGYCTuLLhMZ_wH9-KC3bDdlGhyphenhyphenf1Th6RcQ4vNHuwKeVRzoqIUrmkhRQyqOqsIBpKdHAfGDOWZmTs/s320/Slide1.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5353937507256615794&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgb374bnWECckD5ScFeeqFlhLzuwRjGc-qMKYXJzdITLZVrLCcbSTOYxpKpQlGZHg__bVPyb3wPnC0TuZmpyQxQDZE9BsRxmEakxhwDamck1hSL2bpyXt7qbJpS9INLqKMdYsMCy4/s1600-h/Slide2.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 240px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgb374bnWECckD5ScFeeqFlhLzuwRjGc-qMKYXJzdITLZVrLCcbSTOYxpKpQlGZHg__bVPyb3wPnC0TuZmpyQxQDZE9BsRxmEakxhwDamck1hSL2bpyXt7qbJpS9INLqKMdYsMCy4/s320/Slide2.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5353937509615931874&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Next, in Excel, calculate the quarterly originations.&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihseJSSuSVuSuwQsOAlGd3iDmkYPsrw-i5lV4X6Wi7gIFd33cMKemCcOTIl1W5aLI8NAeDXnTbe808-7ZSMNTAbgwl8W7wCVot4u6TLwxw7VOn4ezoi3DhIHfnAD7iSEYxgE43pAk/s1600-h/Slide3.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 240px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihseJSSuSVuSuwQsOAlGd3iDmkYPsrw-i5lV4X6Wi7gIFd33cMKemCcOTIl1W5aLI8NAeDXnTbe808-7ZSMNTAbgwl8W7wCVot4u6TLwxw7VOn4ezoi3DhIHfnAD7iSEYxgE43pAk/s320/Slide3.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5353939825476342802&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Graph it. But, wait! The x-axis has the data formatted in reverse order--the graph has 2009 on the left and 2002 on the right.&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqYzyAUH_79UsdtlZIzU0Mk1LFmJ8SDanDequ1iHhS-nUfBOW2u1EfCyVqsGl1aIeqcqdUJtjJoQFAYW1VzAO4hQnIHkqbVgJKDDh1ZknMMdhP8meTYEc5p-Wcyj8T25BBVMeWCUo/s1600-h/Slide4.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 240px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqYzyAUH_79UsdtlZIzU0Mk1LFmJ8SDanDequ1iHhS-nUfBOW2u1EfCyVqsGl1aIeqcqdUJtjJoQFAYW1VzAO4hQnIHkqbVgJKDDh1ZknMMdhP8meTYEc5p-Wcyj8T25BBVMeWCUo/s320/Slide4.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5353940460405524162&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Fix it: Right click on the x-axis. Under Axis Options select &quot;Categories in reverse order&quot;.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJAoDESI-y5243HFt77ETEb6qk80dXhwujOfOKbLRziUzFmdY1ku9pqAtCtfGFEwhfVnJzS7712dpo9fwZkKLqt56IDwGQEngv-N0lCGSQUrwbBDeMpi_fTYr61_cO8rhsFXYIQj0/s1600-h/Slide6.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 240px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJAoDESI-y5243HFt77ETEb6qk80dXhwujOfOKbLRziUzFmdY1ku9pqAtCtfGFEwhfVnJzS7712dpo9fwZkKLqt56IDwGQEngv-N0lCGSQUrwbBDeMpi_fTYr61_cO8rhsFXYIQj0/s320/Slide6.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5353937520456877890&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;ACK! The y-axis labels are now on the wrong side.&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWDm2YJnz1BEo44uxN71Ofk8suHirM1Pq99jevt0uHgSFWTbKBNt5HI_8XMFzbelw30dzf1Y6LYSJyvohhDNqJxAKj9_Q85g8I2t_x26YPMsGMleIBtE0GA82ZGQUYZERdX3tE-r4/s1600-h/slide5.jpg&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 240px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWDm2YJnz1BEo44uxN71Ofk8suHirM1Pq99jevt0uHgSFWTbKBNt5HI_8XMFzbelw30dzf1Y6LYSJyvohhDNqJxAKj9_Q85g8I2t_x26YPMsGMleIBtE0GA82ZGQUYZERdX3tE-r4/s320/slide5.jpg&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5353942355977597554&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;Fix it: Right click on the y-axis. Under Axis Options select &quot;Axis labels: High&quot; (I have no idea why...this one I had to figure out with experimentation.)&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQ1iGSBPHLbnR0tEGFHM-A2TGSD9-r0kAHcKJwizAwjewlwP5WAcVQ_swTwzXhb9v7vqjEZzROjwMwDWmwaEQFmkMyWUDAeIXKWgH_xyrERyr3YFNNkJu1lPJF7xOfdhV5V9RIbV4/s1600-h/Slide8.jpg&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 240px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQ1iGSBPHLbnR0tEGFHM-A2TGSD9-r0kAHcKJwizAwjewlwP5WAcVQ_swTwzXhb9v7vqjEZzROjwMwDWmwaEQFmkMyWUDAeIXKWgH_xyrERyr3YFNNkJu1lPJF7xOfdhV5V9RIbV4/s320/Slide8.jpg&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5353939828828521954&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;Voila! A gorgeous graph that shows the Quarterly 1st Mortgage Originations.&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzfmmH5lKn0X5MbA2ZGIEMbsg2ToDJhI3f4mAc3kwp-ECMvBgeB_SG6gTXK6tucYklYK-KRK_4AlWsXe5rA7klr5uoOBxF4C_n7OLRTABlZNLlrgCQKnqcDPN1tVXSAndd4lI-JMo/s1600-h/Slide7.JPG&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 240px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzfmmH5lKn0X5MbA2ZGIEMbsg2ToDJhI3f4mAc3kwp-ECMvBgeB_SG6gTXK6tucYklYK-KRK_4AlWsXe5rA7klr5uoOBxF4C_n7OLRTABlZNLlrgCQKnqcDPN1tVXSAndd4lI-JMo/s320/Slide7.JPG&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5353942838011060706&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;</description><link>http://peerific.blogspot.com/2009/07/calculating-graphing-accounts-reported.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi07A1FJsAJn3_jPoSWnuhufwc43ypF_DBM2Jc3ni2r6R65gX8rn4LzCS0SF1PQGYCTuLLhMZ_wH9-KC3bDdlGhyphenhyphenf1Th6RcQ4vNHuwKeVRzoqIUrmkhRQyqOqsIBpKdHAfGDOWZmTs/s72-c/Slide1.JPG" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-1282001459143128489</guid><pubDate>Thu, 02 Jul 2009 12:20:00 +0000</pubDate><atom:updated>2009-07-04T14:53:50.049-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">built-in displays</category><category domain="http://www.blogger.com/atom/ns#">investments</category><title>Changes in Balance Sheet Composition over time</title><description>Ok, I have a confession. I didn&#39;t find this &quot;little wow&quot; myself...but it was too good not to share.&lt;br /&gt;&lt;br /&gt;Peer has built-in pie charts to show the composition for different aspects of the balance sheet. This image shows you the typical (&#39;average&#39;) investment compostion for all Arizona CUs.&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2MNvboGFcqzKHcpuL2lTRdToUbo8EHWn_33AfcgX69-QM8vjk39kEQ1z8BZ46qCXUwRM8ULXxhvEUOb8UG6WQn0CALJWgyxBMJ0weL0B4rZkPdqfvadW264Po0zsSn1M4RRyDTV8/s1600-h/Pie.jpg&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 383px; height: 276px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2MNvboGFcqzKHcpuL2lTRdToUbo8EHWn_33AfcgX69-QM8vjk39kEQ1z8BZ46qCXUwRM8ULXxhvEUOb8UG6WQn0CALJWgyxBMJ0weL0B4rZkPdqfvadW264Po0zsSn1M4RRyDTV8/s400/Pie.jpg&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5353840857538081586&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;Want to know how that&#39;s changed over time? You can convert this pie chart into a stacked area chart to view historical trends. Simply go to Type on the chart menu and select Stacked Area.&lt;br /&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2STmSuOogdyNW6SUzfh19TbaAJgeQfJxfsskGadDpGTtzJaqNuKUiNq52QkhnkZwCjan0RSdGWSNKRZjINUcpCta1UeRv8_SmTd8gmQQvj6jXvMOE6EOjbPzX2JO8xLo2q8dRPis/s1600-h/how.jpg&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 384px; height: 288px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2STmSuOogdyNW6SUzfh19TbaAJgeQfJxfsskGadDpGTtzJaqNuKUiNq52QkhnkZwCjan0RSdGWSNKRZjINUcpCta1UeRv8_SmTd8gmQQvj6jXvMOE6EOjbPzX2JO8xLo2q8dRPis/s400/how.jpg&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5353841041467348610&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh71wExgCtLste4HGfg_Y9e8xMrDcbWQRT2NgxilgwPJdlxnXmD-71A1vHWGbnbsfWNuXlimssY5kIukPzbMFWz2nZAl65qWw3xE_jYwS-gCkZGXcGR-9XglDAxUmPYwDrBCqZslsM/s1600-h/historical.jpg&quot;&gt;&lt;img style=&quot;margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 383px; height: 276px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh71wExgCtLste4HGfg_Y9e8xMrDcbWQRT2NgxilgwPJdlxnXmD-71A1vHWGbnbsfWNuXlimssY5kIukPzbMFWz2nZAl65qWw3xE_jYwS-gCkZGXcGR-9XglDAxUmPYwDrBCqZslsM/s400/historical.jpg&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5353841035510896162&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;Looking at the data this way shows me how the CU&#39;s strategy has changed over time.&lt;br /&gt;&lt;br /&gt;One thing to be aware of: Peer 2 will &quot;allow&quot; you to change all pie charts this way but should not be used for accounts that are reported YTD (eg. on the income statement).</description><link>http://peerific.blogspot.com/2009/07/changes-in-balance-sheet-composition.html</link><author>noreply@blogger.com (Alix)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2MNvboGFcqzKHcpuL2lTRdToUbo8EHWn_33AfcgX69-QM8vjk39kEQ1z8BZ46qCXUwRM8ULXxhvEUOb8UG6WQn0CALJWgyxBMJ0weL0B4rZkPdqfvadW264Po0zsSn1M4RRyDTV8/s72-c/Pie.jpg" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-41055356227119045.post-1380333861196297169</guid><pubDate>Wed, 01 Jul 2009 17:39:00 +0000</pubDate><atom:updated>2009-07-03T12:38:16.729-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">CRC</category><category domain="http://www.blogger.com/atom/ns#">CUtv</category><category domain="http://www.blogger.com/atom/ns#">mortgages</category><title>Mortgage Analysis</title><description>Credit unions reached record mortgage origination market share in the first quarter of 2009. The industry&#39;s delinquency rate on mortgages is also well below that of FDIC-insured institutions and their success at modifying loans is much better.&lt;br /&gt;&lt;br /&gt;How do I know? Well...there is a lot of information about mortgages out there but it takes some digging to find it all. So, 2 weeks ago, I hosted a free webinar for &lt;a href=&quot;http://cutv.creditunions.com/&quot;&gt;CUtv/CreditUnions.com&lt;/a&gt; on how to get started with mortgage analysis. My colleague Elliott Kashner and I provided a &quot;cheat sheet&quot; of useful sources then spent 30 minutes demonstrating all the new RE account codes from the 5300 using Peer 2.0.  &lt;span id=&quot;lblBody&quot;&gt;&lt;br /&gt;&lt;br /&gt;You can watch the event (it&#39;s free for Peer 2.0 subscribers) &lt;a href=&quot;http://www.creditunions.com/cutv/individual.aspx?eventid=495&quot;&gt;here&lt;/a&gt; (password: &lt;span style=&quot;font-weight: bold;&quot;&gt;061109Mortgage&lt;/span&gt;.) If you like all 26 of the graphs and charts we show, you can download them into your own version of Peer using this &lt;a href=&quot;http://p2psoftware.com/downloads/MortgageWebinar.zip&quot;&gt;.CRC file&lt;/a&gt;. (Don&#39;t know what a CRC file is? Ok. I&#39;ll blog about that next.)&lt;br /&gt;&lt;/span&gt;</description><link>http://peerific.blogspot.com/2009/07/mortgage-analysis.html</link><author>noreply@blogger.com (Alix)</author><thr:total>0</thr:total></item></channel></rss>