plenty of flexibility to help you get just the color scale that you are looking for. now that you are familiar with color scales, select cells c4 to c10 and d4 to d10 to create color scales for treatments 2 and 3, respectively. treatments 2 and 3 have different reimbursement ranges, so it makes sense to select each treatment and apply the color scale separately. if you conditionally format both treatment columns at the same time, treatments 2 and 3 will be included in the same color scale calculation, resulting in all of the red cells being in the “treatment 2” column and all of the green cells in the “treatment 3” column. the “mar apr 13 answers” tab on the sample spreadsheet has my solution. chbme QuiZ Questions You can now earn 0.5 credits towards your CHBME by answering quiz questions in each issue of Billing. Go to www.hbma.org/ceu or use your smart phone to go directly to the site. 50 hbma billing • march.aPril.2013 there are many great ways to use conditional formatting in dashboards. in the next issue of Billing, we’ll use conditional formatting to add icons like arrows, stoplights, and other shapes to your spreadsheets. to learn more about conditional formatting, watch the free videos found in the playlist for conditional formatting, excel Videos 44 – 60, at mooresolutionsinc.com/videos.php. Nate Moore, CPA, MBA, FACMPE connects practice management data to custom Excel reports for practices throughout the country. His free Excel Videos have been viewed over 300,000 times and are available at mooresolutionsinc.com. Want to be the first to know each time a new Excel Video is released? Like PivotTableGuy on Facebook and follow PivotTableGuy on Twitter. (Conditional Formatting continued) 1. Setting up payment plans for patients with a high deductible is not an efficient way of collecting their outstanding debt. a. true b. false 2. The adoption of the HPID rule will eliminate the ambiguity that makes healthcare transactions so costly today and will reduce administrative costs through increased transparency and automate coordination of benefits. a. true b. false 3. The only way for a small group or solo physician to survive health system reform is to align themselves with a large medical group or hospital system. a. true b. false 4. You should spend at least 15% of your time marketing your business. a. true b. false 5. The potential for a HIPAA breach when texting lies with : a. the sending device b. the receiving device c. the carrier’s systems d. all of the above 6. In 2013, the maximum contribution for a 401(k) contribution increased from $17,000 to $17,500 if you are under age 50. a. true b. false 7. Collection agencies often deduct closed accounts from returns to bolster their reports. a. true b. false 8. Large company leaders have decided that resources used on performance reviews could be spent more productively. a. true b. false 9. You can control the minimum and midpoint and maximum values in a three-color scale. a. true b. false 10. Services and client expectations changed along with the term “Revenue Cycle Management.” a. true b. false
Billing_MA13
To see the actual publication please follow the link above