{"id":152,"date":"2013-04-28T08:47:21","date_gmt":"2013-04-28T08:47:21","guid":{"rendered":"https:\/\/surgerytoday.com\/education\/?p=152"},"modified":"2013-06-08T16:15:52","modified_gmt":"2013-06-08T16:15:52","slug":"top-10-zip-codes-coming-to-surgical-artistry-ripon-included","status":"publish","type":"post","link":"https:\/\/surgerytoday.com\/education\/top-10-zip-codes-coming-to-surgical-artistry-ripon-included\/","title":{"rendered":"Top 10 Zip Codes coming to Surgical Artistry: Ripon, Turlock, Oakdale, More"},"content":{"rendered":"\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
zip<\/strong><\/span><\/td>\nTown<\/strong><\/span><\/td>\n<\/td>\n<\/tr>\n
95356<\/td>\nModesto<\/td>\n10%<\/td>\n<\/tr>\n
95355<\/td>\nModesto<\/td>\n18%<\/td>\n<\/tr>\n
95357<\/td>\nModesto<\/td>\n3%<\/td>\n<\/tr>\n
95350<\/td>\nModesto<\/td>\n10%<\/td>\n<\/tr>\n
95361<\/td>\nOakdale<\/td>\n6%<\/td>\n<\/tr>\n
95326<\/td>\nHughson<\/td>\n1%<\/td>\n<\/tr>\n
95367<\/td>\nRiverbank<\/td>\n4%<\/td>\n<\/tr>\n
95354<\/td>\nModesto<\/td>\n4%<\/td>\n<\/tr>\n
95366<\/td>\nRipon<\/td>\n2%<\/td>\n<\/tr>\n
95382<\/td>\nTurlock<\/td>\n5%<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nTotal<\/td>\n62%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The percentages shown is a percent of the total number of patients seen at Surgical Artistry from inception in 2006 to 4\/27\/13. \u00a0Sorted based on percentage of population served per zip code. \u00a0Population data is in the chart below. \u00a095355 is our zip code<\/em> of our plastic surgery office (2336 Sylvan Ave. Suite C, Modesto, CA 95355).<\/p>\n

Let’s not forget about Oakdale, Hughson, Riverbank, Ripon, and Turlock.<\/h3>\n

I guess it’s no big surprise that most of our patients come from Modesto<\/a>,\u00a0because we are located in Modesto.<\/p>\n

44% of our patients come from Modesto and the remaining popular cities making up 18% of our patients come from: \u00a0Oakdale, Hughson, Riverbank, Ripon, and Turlock.<\/p>\n

I like to exercise my knowledge of spreadsheets<\/h3>\n

Spreadsheets are very useful for keeping track of medical data, especially for experiments. \u00a0I value spreadsheet skills as a doctor, and feel that if I can efficiently track things, I can eventually improve upon them.<\/p>\n

Today I practiced using a pivot table to extract data from our electronic medical record. \u00a0I figured out the top 10 zip codes of our Surgical Artistry Patients (including acupuncture, veins, Botox, fillers, breast augmentation, tummy tucks, and other plastic surgery patients).<\/p>\n

I got help from this page on Pivot Tables<\/p>\n

http:\/\/office.microsoft.com\/en-us\/excel-help\/count-how-often-a-value-occurs-HP001127779.aspx<\/a><\/p>\n

    \n
  1. Select the column containing the data<\/span><\/li>\n
  2. On the Data menu, click Pivot Table and Pivot Chart<\/li>\n
  3. Click Finish<\/li>\n
  4. Drag and drop the column label (in this case it was “zip”) into the drop Row Fields Here (from Pivot Table Field List)<\/li>\n
  5. Drag and drop the same column label above into the Drop Data Items Here (from Pivot Table Field List)<\/li>\n<\/ol>\n

    Zip Codes of various parts of Cities<\/h3>\n

    These were tallied up with an absolute count and I used further spreadsheet skills to convert that into a percentage of our patients.<\/p>\n

    2010 Census Data<\/h3>\n

    I went to www.zip-codes.com for fun to see the total population and I sorted above chart in order of percentage of the entire population which we served. I didn’t show the data here because it’s boring data. \u00a0But for example we could say that of the area code 95356, Surgical Artistry has served about 1.1% of that population. \u00a0Below’s chart shows the top 24 zip codes served by Surgical Artistry. \u00a0Avg = Average House Cost \/ Value as determined by 2010 census and source is zip-codes.com.<\/p>\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    Zip<\/span><\/strong><\/td>\nTown<\/span><\/strong><\/td>\nPopulation<\/span><\/strong><\/td>\nAvg House Value<\/span><\/strong><\/td>\n<\/tr>\n
    95356<\/td>\nModesto<\/td>\n32,288<\/td>\n\u00a0$305,400.00<\/td>\n<\/tr>\n
    95355<\/td>\nModesto<\/td>\n59,031<\/td>\n\u00a0$247,700.00<\/td>\n<\/tr>\n
    95357<\/td>\nModesto<\/td>\n11,708<\/td>\n\u00a0$253,500.00<\/td>\n<\/tr>\n
    95350<\/td>\nModesto<\/td>\n51,331<\/td>\n\u00a0$205,600.00<\/td>\n<\/tr>\n
    95361<\/td>\nOakdale<\/td>\n31,533<\/td>\n\u00a0$327,200.00<\/td>\n<\/tr>\n
    95326<\/td>\nHughson<\/td>\n8,376<\/td>\n\u00a0$249,100.00<\/td>\n<\/tr>\n
    95367<\/td>\nRiverbank<\/td>\n24,089<\/td>\n\u00a0$214,300.00<\/td>\n<\/tr>\n
    95354<\/td>\nModesto<\/td>\n25,877<\/td>\n\u00a0$191,700.00<\/td>\n<\/tr>\n
    95366<\/td>\nRipon<\/td>\n16,857<\/td>\n\u00a0$352,000.00<\/td>\n<\/tr>\n
    95382<\/td>\nTurlock<\/td>\n36,319<\/td>\n\u00a0$275,900.00<\/td>\n<\/tr>\n
    95320<\/td>\nEscalon<\/td>\n12,658<\/td>\n\u00a0$279,000.00<\/td>\n<\/tr>\n
    95368<\/td>\nSalida<\/td>\n13,230<\/td>\n\u00a0$221,700.00<\/td>\n<\/tr>\n
    95358<\/td>\nModesto<\/td>\n31,086<\/td>\n\u00a0$215,000.00<\/td>\n<\/tr>\n
    95386<\/td>\nWaterford<\/td>\n10,399<\/td>\n\u00a0$205,100.00<\/td>\n<\/tr>\n
    95307<\/td>\nCeres<\/td>\n44,056<\/td>\n\u00a0$210,200.00<\/td>\n<\/tr>\n
    95360<\/td>\nNewman<\/td>\n12,107<\/td>\n\u00a0$172,900.00<\/td>\n<\/tr>\n
    95363<\/td>\nPatterson<\/td>\n26,709<\/td>\n\u00a0$216,300.00<\/td>\n<\/tr>\n
    95380<\/td>\nTurlock<\/td>\n42,005<\/td>\n\u00a0$207,000.00<\/td>\n<\/tr>\n
    95351<\/td>\nModesto<\/td>\n47,691<\/td>\n\u00a0$160,200.00<\/td>\n<\/tr>\n
    95370<\/td>\nSonora<\/td>\n26,210<\/td>\n\u00a0$308,600.00<\/td>\n<\/tr>\n
    95337<\/td>\nManteca<\/td>\n33,348<\/td>\n\u00a0$285,300.00<\/td>\n<\/tr>\n
    95301<\/td>\nAtwater<\/td>\n37,809<\/td>\n\u00a0$220,400.00<\/td>\n<\/tr>\n
    95340<\/td>\nMerced<\/td>\n33,672<\/td>\n\u00a0$226,400.00<\/td>\n<\/tr>\n
    95336<\/td>\nManteca<\/td>\n44,655<\/td>\n\u00a0$243,700.00<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    <\/h3>\n

    Visit our Plastic Surgery Website<\/h3>\n

    Thanks for visiting my self-educational blog. \u00a0For serious stuff, please visit our web site:<\/p>\n

    Surgical Artistry Plastic Surgery Home Page<\/a><\/p>\n

    \"Bee\"
    \n<\/a><\/p>\n

    Buzzing around looking for zip codes?<\/p>\n","protected":false},"excerpt":{"rendered":"

    zip Town 95356 Modesto 10% 95355 Modesto 18% 95357 Modesto 3% 95350 Modesto 10% 95361 Oakdale 6% 95326 Hughson 1% 95367 Riverbank 4% 95354 Modesto 4% 95366 Ripon 2% 95382 Turlock 5% Total 62% The percentages shown is a percent of the total number of patients seen at Surgical Artistry from inception in 2006 to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[30,26,25,377,23,29,21,22,27,28,24,20],"class_list":["post-152","post","type-post","status-publish","format-standard","hentry","category-statistics","tag-average-house-cost","tag-excel","tag-hughson","tag-modesto","tag-oakdale","tag-plastic-surgery-office","tag-ripon","tag-riverbank","tag-spreadsheet","tag-statistics-2","tag-turlock","tag-zip-codes"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/surgerytoday.com\/education\/wp-json\/wp\/v2\/posts\/152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/surgerytoday.com\/education\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/surgerytoday.com\/education\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/surgerytoday.com\/education\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/surgerytoday.com\/education\/wp-json\/wp\/v2\/comments?post=152"}],"version-history":[{"count":7,"href":"https:\/\/surgerytoday.com\/education\/wp-json\/wp\/v2\/posts\/152\/revisions"}],"predecessor-version":[{"id":155,"href":"https:\/\/surgerytoday.com\/education\/wp-json\/wp\/v2\/posts\/152\/revisions\/155"}],"wp:attachment":[{"href":"https:\/\/surgerytoday.com\/education\/wp-json\/wp\/v2\/media?parent=152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/surgerytoday.com\/education\/wp-json\/wp\/v2\/categories?post=152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/surgerytoday.com\/education\/wp-json\/wp\/v2\/tags?post=152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}