 Good afternoon and welcome to the Green Mountain Care Board meeting. The first item on the agenda is the Executive Director's Report, Susan Barrett. Thank you. Thank you, Mr. Chair. I have a couple of scheduling reminders. Folks should know that our schedule is located in our public meeting section of our website but wanted to call out that on Monday, July 20th, the board will have its first rate review hearing and that's Blue Cross Blue Shield of Vermont. That's starting at 8 a.m. And then on Tuesday, July 21st, we will have the MVP Qualified Health Plan Rate Review hearing. Both of these meetings will be online through Microsoft Teams. And then in addition, on Tuesday, July 21st, starting at 4.30 and going to 6.30, the board will be holding a Qualified Health Plan Rate Review Public Comment Forum. And again, that will be held via Microsoft Teams. The information on how to access that information, again, is on our public meeting section of our website. I'd also like to remind folks that these rate cases are open for public comment. And if you click on our public comment section of our website, you can provide comments to the board on these rate cases. And that is all I have to announce. I'll turn it back to you, Mr. Chair. Thank you, Susan. I'll turn it back to you in a second for the purposes of taking attendance. But prior to that, would some would like to make a motion of the minutes of Wednesday, June 24th? Still moved. Second. It's been moved and seconded to approve the minutes of Wednesday, June 24th without any additions, deletions, or corrections. Is there any discussion? Moving on, all those in favor signify by saying aye. Aye. Any opposed? Okay, Susan. Yes, and I'm looking at the list. And I don't, maybe I can get some technical assistance from Abigail here. So at the bottom, they're just phone numbers. After Spencer's name, there's just phone numbers. Would you like me to call off the last four digits? Would that help you? Why don't you do it? Because they're not showing up on my screen for some reason. You have to hit more. There's a little more link. I don't see those. I think you're going to have to do my job, Kevin. I'm sorry. Okay, 5,001. If your phone number ends up with the last four digits, 5001, if you could introduce yourself. Hi, it's Julia Shaw with the healthcare advocate. Thank you, Julia. 8703. Mike Del Treco. Thank you, Mike. 8869. Toby Howe, MMR. Thank you, Toby. 4534. Walter. I didn't understand it, you. It was Walter. And I did find the numbers, but. Okay. I got this one under control. Walter was checking in. 505. I'm calling CVM Medical Center. Thank you. 6376. Mord-Walterman. Thank you, Mord. 0043. Becky Rondofsky. DRM. Thank you, Becky. 8461. John Olson. Head office of rural health. Thank you, John. 5835. 8461. John Olson. 8461. 8461. John Olson. 8461. 5835. I guess that's Abigail. 2177. I think that might be our office. Yes, it is. Thank you. Okay. 3212. Kathy Mahoney from the General Advisory Committee. Thank you, Kathy. 8888. I believe that's Jeff Hebert. Thank you, Jeff. 5252. Rebecca Copan, Blue Cross Blue Shield. Thank you, Rebecca. 9806. Mike Fisher. Thank you, Mike. I think that's all I have for phone numbers. Everybody else has a name attached to it, I believe. So at this point in time, we're going to go ahead, whoever spoke, I'll take it as an accidental speaking then. At this point in time, we're going to turn the meeting over to Lori Perry and David Glavin and Lori's going to walk us through the health expenditure analysis report for 2018. So whenever the two of you are ready, take it away. Thank you. We're ready. This is the 2018 from our healthcare expenditure analysis and the topic that we will be covering air and introduction, the summary, and then the 2018 Vermont resident analysis, the relationship to the total cost of care, the spending and growth, and how Vermont is compared to the national health expenditures from CMS, the Vermont provider analysis, then the revenues received by those providers and the growth, the hospital revenues, the migration of hospital inpatient discharges, then we compare the resident analysis to the provider analysis, and we also have projections for the resident analysis and provider analysis for 2018 through 2020. Then the appendix will show you some of our sources and methods and other tables, and then we'll also have the Tableau presentation that David Glavin will be presenting for you. Excuse me. One second. Sorry about that. The expenditure analysis has been around since the 1990s, but recently the current statute is 18 VSA, 9375A, and 9383. The report examines trends in spending and sources of funds, analyzes broad sectors, including hospitals, physicians, mental health, home health, and pharmacy, and also analyzes payers such as Medicare, Medicaid, commercial plans, self-insured employers, and HMOs or health maintenance organizations. We also quantify the spending for services for Vermonters within Vermont, having services, and also for out-of-state patients having services within Vermont. We compare Vermont data to the national health accounts, which are with the Centers for Medicare and Medicaid Services, which is CMS. We use CMS's health consumption expenditures, which are a subset of the national health care expenditures, because Vermont doesn't monitor the research, pictures, equipment, and investments in health care that they're represented in the NHE. Vermont residents' spending grew 1.9% in 2018. This was lower than the increase seen in 2017 of 3.7%, and this equates to an average annual increase of 3.4% for the period of 2013 through 2018. We saw commercial insurance spending increase 1.7%, and that was mainly seen in the hospitals, prescription drugs, and other unclassified services. Medicare spending increased 5.1%, and this was in home health, nursing homes, hospitals, physicians, and drugs. Medicaid spending increased 1.1%, mainly due to increases in mental health and other government activities, other professionals, and home health. There have been a payership over time from 2010 through 2018. Commercial insurance decreased from 38% to 33%, out-of-pocket decreased 14% to 13%, but Medicaid grew from 24% to 27%, and Medicare increased from 19% to 24%. We also want to make note for your reference, is this our, with the state of Vermont in the circle, this represents resident analysis, and you'll see that through the whole resident side of this presentation. Then we compare Vermont expenditures to the United States, and as we mentioned, Vermont grew 1.9%. The United States spending grew 4.8%, and this was an average annual increase of 4%, excuse me. This was higher than the 4% realized in 2017. We also look at per capita spending, and Vermont was 9,995, or an increase of 1.4% over 17%. The United States increased 10,640, and Vermont's share of health care for the gross domestic product was 18.8% this year, and the United States was 16.9%. Vermont health care providers received revenues for in and out-of-state patients this year, and that increased 3.2%, and that was an average increase of 3.4% for the period 2013 to 2018. Hospitals grew 3.5%, and this includes hospital-employed physicians. We also saw increases in other licensed professionals of 11%, home health of 9.5%, independent physicians of 3.2%, physician and DME 2.2, and drugs of 1, but we did see a decline for nursing homes of 2.3%. And then this symbol at the bottom of this slide with the P for Vermont means that that is our Vermont providers giving services to in and out-of-state patients. Now we're going to the resident analysis, but first I wanted to let you know what the relationship of the resident analysis is to the total cost of care. The total expenditure analysis measures expenditures on a larger scale in its comprehensive level compared to the total cost of care as described in the All-Pay or Accountable Care Organization model agreement. The expenditure analysis resident analysis estimates all Vermont residents where the total cost of care is a subset of this resident analysis, and it excludes certain populations such as residents without insurance, or they're covered by the federal employee health benefits plan. The expenditure analysis provider estimates includes all populations receiving services in Vermont, regardless of where they live. The total cost of care concentrates on Vermont residents only. The expenditure analysis resident and provider estimates total expenditures. The total cost of care is limited to claim payments for the types of services covered by traditional Medicare or non-claims payments related to direct medical care. Total cost of care does not include retail pharmacy. We also wanted to show you how it relates to each other, so the resident spend on the expenditure analysis is equal to about $6.3 billion. The total cost of care with the All-Pay model is only 46% of that or $2.9 billion, and one care Vermont budget of the total cost of care is $609 million. We just wanted to make sure that everybody can understand this relationship. Also, the ACO represented 10% of the total spending on the resident analysis. We, for this analysis, we look at 2013 through 2018, even though we have data way back to 91, and we always look at the payers, out-of-pocket commercial Medicare, Medicaid, and other government, which is local and federal. And then how do those payers spend on provider and facilities, like hospitals, physicians, and nursing homes? And then we get the average changes, annual changes, and average annual change in a five-year period. By the way, if there's any questions at any time, feel free, and if I can't answer them right now, I'll get back to you as soon as I can. And I would just ask board members, if you do have a question, to click on the hand so that we'll know that your hand is raised. The spending for the resident analysis from 2010 to 2018, this was an average increase of 3%. So in 2010, it was $4.9 billion, now it's $6.3 billion. And as I mentioned before, the change between 17 and 18 was 1.9%. This is showing the in-and-out-of-state spending for us as residents, so we can go to Florida, we can go to New York. This is incorporated in the resident analysis. And these are all the services and the full dollars that were realized this year. So we were seeing most of the increases in spending equated to $114.1 million. And most of that was seen in drugs and supplies in the commercial insurance and out-of-pocket. Possible showed increases in commercial and out-of-pocket. Mental health and other government activities such as mental health clinics, home and community-based services were reported in Medicaid. Home health care increased in Medicare. Physicians increased in Medicare and out-of-pocket. So this is just the larger increases that we're seeing in the analysis this year. Then we also look at the payers, how they rack up. So for instance, the Medicaid payer makes up 27% of the spending and then 22%, excuse me, 25% of the enrollment. And commercial is 33% of the spending and 50% of enrollment. So we also, as you can tell with the enrollment, it doesn't account for out-of-pocket. So all of us, like in Medicare or commercial, would be having some out-of-pocket. And then this is another look. Where did our spending come from? Who paid for it? So health insurance from Medicare, Medicaid and commercial made up 84% of where the funds were coming from, but they spent it on the hospitals, physicians, drugs, mental health and other. And this is looking at commercial insurance and commercial insurance spending increased to $2.1 billion or 1.7% increase. This was $33.4 million. And the increases were seen in hospitals, drugs and supplies and other unclassified services. But we saw decreases in physicians, and net cost of health insurance and other professionals. The in-state spending for commercial insured patients remained at 75% to 76% in the last couple of years. And commercial insurance enrollment decreased to close to 315,000 residents or enrollment. So, Laura, I'm going to interrupt you because Susan texted me to say that Robin has a question. I never saw her hand raised on my screen, but Robin, go ahead. We can go back to it. It's a few slides back now, so don't worry about it. Okay. All right. So, this particular pair includes comprehensive major medical insurance, self-insured, dental, long-term care insurance, workers' comp, Medicare stuff, limited liability insurance. And the enrollment for commercial insurers was decreasing as the other two pairs of Medicare and Medicaid increased. And I'm going to go next to the Medicare pair. And this one increased 73.3 million, or 5.1% to a total of 1.5 billion. And we saw increases in home health, possible physicians, drugs and supplies, but decreases in other unclassified dentists and admin and net cost of health insurance. Other beneficiaries, this was a little bit of a surprise, in 2017, 68% was in state spending and 73% for 2018. And then Medicare enrollment increased 136,567, or 2% from last year. Because of our aging state, Medicare has continued to increase an average inner percent of 6.2% between 2013 and 2018. And in 2012, spending was 1.1 billion, now it's 1.5 billion. And we use V-Cures for this particular source to find the spending on Medicare. And for the last couple of years, we've used V-Cures for the last couple of years. And the ACO accounts for approximately 385 million as Medicare revenue for their calendar year 2018. The Medicaid increased to 1.7 billion, or $18.3 million, 1.1%. We saw increases in mental health and other government activities, other professionals' home health. There was decreases, surprisingly, in hospitals, drugs and supplies, admin and net cost of health insurance. The in-state spending for this particular pair remained at 85% to 86% for the last couple of years. And Medicaid's enrollment increased to almost 155,000 people, or 3% from 2017. The information from Medicaid, we received that from the Agency of Human Services, and they reconciled that to the CMS Global Commitment Waiver. They also report on managed care organizations and the CHIP program, long-term care. And then V-Cures is used to support the claims and non-claim spending. From the resources that I have, the $70.8 million from the ACO was capitation payments for Medicare, Kate, and then that was based on the state fiscal year. And in Medicaid, there is, like we mentioned, mental health and other government activities. I thought I'd give you this slide to show you all of the type of services that are included in that particular category. So like mental health clinics, community rehab treatment, home and community-based services, managed care organization investments, substance abuse services, and all that, and all this spending. We have more, if you would like it, just let me know. We also, there's a big category that's called net cost of health insurance for all the payers, and this is the difference between the premiums earned and benefits incurred, and it includes premium taxes, admin costs, net addition to reserves, and profit and losses. This category kind of is one of the major factors in the swings in the growth by payers and in commercial in particular. And commercial, they also have to pay the ACA fees to the federal government every other year. So that can sometimes account for the swings. In the commercial insurance, they have the two components. It's the admin and then they have change in surplus where Medicare and Medicare do not. We can explain more at another time if anybody needs more information. I have this slide every year to show the percentage of what private payers like you and I will pay for provider services such as dental and vision and durable medical equipment versus other services like home health and nursing home, which is usually funded by public payers. Lori, this is Robin. Can I, before you jump in, I just... On the previous slide, if I'm recalling correctly, we include... One thing that may not be intuitive is we do include state employees and teachers, for example, under commercial insurance, right? Not government funded. That's correct. Okay. I just wanted to make sure I remembered that right. Thank you. Now we're transitioning into comparing the month spending to the United States. And so I wanted to go over our resources. We want to emphasize that when researchers and others compare United States to Vermont and other states, they use the state of residence or state of provider data from CMS. And that is produced every five years. And the most recent was 2014 published in 2017. They get their estimates from census data. And if that's not available, they get it from other population data, wages, employment, and IOS business receipts. Our data is small compared to the United States, and the United States works in thousands of dollars. So ours is more precise and Vermont rich. So I'm just... We'd like to sometimes tell people to be cautious when they're comparing Vermont to the United States, because we're so small, it's hard to compare. We use the Vermont... We use the health consumption expenditures when we are comparing Vermont to the United States, where the United States would normally use national health expenditures. And so we use health consumption because it includes personal health care, administrative net cost of insurance, and public health activity. We don't use the NHE because that also includes the investments in research structures and equipment. This slide is showing you the different comparisons where Vermont is not included under NHE, where you include yourselves under HCE, and then we also have the personal health care. The United States increased 4.8 percent in their spending, where we increased 1.9 percent. And the per capita for the United States increased 4.1 percent and Vermont increased 1.4 percent. Our share, health care share of gross domestic product or gross state product is 18.8 percent, and the United States is 16.9 percent. I included this slide because I was asking the pastor of the history of Vermont statistics compared to the United States. If needed, we can report back to the early 90s if anybody wants his data. The changes in Vermont's administration and net cost of insurance in 2015, 2016, and 2017 were significant enough to cause the swings in the inner percentage of total spending. Again, this may be caused from the ACAPs or insurance cost changes from year to year. But as you see, if you can see the trend line, Vermont is trending downward where the United States is trending upward. And this is, again, we're comparing ourselves to health consumption expenditures. And the per person or per capita growth, we are increasing at 1.4 percent for this year, and the United States is 4.1 percent, and we're trending downward. For gross on average for 2010 to 2018 is 3 percent, and the United States is 3.7 percent. And this slide is just showing the dollars. So Lori, we've had a request from someone following along on the pages. If you could just, as you switch slides, say which slide you are on, so those that are not using the screen, they're just using the actual off the website. Okay, on slide 27, that was the per capita per person slide showing the dollar amounts from 2010 to 2018 for Vermont and the United States. Thank you, Kevin. Slide 28 is showing the gross domestic product and how Vermont has compared itself to the United States since 1996 to 2018. You can see spending in Vermont, we have been pretty high. And for the time period of the last 10 years, it's been about 18 to 19 percent of gross state product. It dropped a little bit in 18, and so did the United States. We have generous Medicaid programs, and of course our aging population can account for some of this growth. Slide 29, I'm transitioning to the provider analysis. So again, we look at 2013 to 2018. In this look, usually we have provider direct reporting telling us how they got paid, who paid us, what payers, Medicare, Medicaid and commercial. And it's different from the resident side because the resident side is payers, commercial Medicaid and Medicare telling us what they paid for. So the revenues received by the providers grew from $4.8 billion in 2010 to $6.4 billion in 2018, and this was an average increase of 3.7 percent. 2016 was 3.2 percent, 2017 was 3.3, and 2018 is 3.2 percent. This was mainly dominated by the growth in the hospitals, which makes up about 47 percent of the revenues. Slide 32, when we talk about provider revenues, we're talking about in and out of state patients having services within Vermont. So this particular slide is trying to show you the total spending for each of the provider categories and what is the percentage of the total spending those categories make up. So our hospitals, we have strong hospital data because we regulate 14 community hospitals. We also have data from the Veterans Hospital in White River, Vermont Psychiatric Care Hospital in Berlin, and the Brattleboro retreat. We also have direct reporting from nursing homes and home health and hospice. The other provider services are from a variety of sources like drugs and supplies from Kaiser, and this is without rebates as we do not have reporting on that. Physicians are net of hospital employed physicians because we report that within the hospitals, the other provider categories are estimated similar to the physician revenues, which is basically taking physicians that are derived from the economic census and the N.H.T. And then we use beacons for reasonableness. The mental health and other government activities category is the same as the resident, and the provider analysis, as you will notice, does not have admin or net cost of insurance at all when we're comparing it to the resident analysis. Slide 33. So we're showing that the revenues increase 3.2% this year, and this was for the largest thing as we've been saying in the hospitals, and the hospitals include hospital employed physicians. The other categories were the licensed professionals of 11% and home health with 9.5% independent physicians at 3.2, vision 2.2, drugs with one. But we saw a decrease in nursing homes of 2.3. This slide, we were able to get information from the Department of Health, their 2018 physician census, and they reported 2,473 physicians were practicing in Vermont, and there's 1,368 are full-time equivalents. And of that is about 82% or 1,132 are employed in the hospitals. We also like to show that the hospital's physician revenue has been increasing from 35% in 2010 to 51% in 2018. We're seeing that the hospitals are employing more and more physicians as the sustainability of independent physician practices are getting harder and harder. With technology and the administrative burden from the payers, some of the physicians are leaving independent practice besides some of the physicians are retiring. Slide 35, this information is from the hospital discharge data set, and we were sometimes in our hospital budget, some of the hospitals mentioned that they were seeing more and more out-of-state patients through the years, but based on this information, the state as a whole has been remaining constant at 13% for the last couple of years. We wanted to show you a little bit of changes between hospitals that we regulate between 2017 and 2018. Slide 36, we're comparing the resident analysis to the provider analysis. If you look closely under the provider services, you'll see hospital positions and the resident analysis is zero. The provider side is over $402 million. That's because that's hospital employed physicians that are seen in the hospital budgets that we regulate. Dropped in supply on the resident side is less than on the provider because it's net of rebates. And the provider side does not have admin and net cost of health insurance. That's a major reason why they're so different. But they're also, as we've mentioned, different populations, different patients. We are tasked with also having a projection of resident and provider spending. And this year, we have directly 18 expenditure analysis that we just showed you. And then we're projecting 2019 and 20. And the main increase was seen from Medicaid. And we got that direct reporting from Medicaid of 3.2% or overall 3.2. But Medicaid is showing an increase of 3.4%. The next slide is 38. This slide we have provider revenues increasing 3.2% from 18 to 19. And this is mainly driven by the hospitals and which make up 47% of the total revenues. We have direct reporting of Vermont community hospitals for the period 2018 through 2020 because we monitor their budgets. And then the rest of the projections are based on NHE and Vermont trends. Don't be like 39 is their appendix to let you know there's more analysis and sources. I can go through this pretty quickly because then we would like to hear from David Glavin about Tableau. This is the matrix of the information I showed you previously. This is slide 40. And it's showing each payer what they said they were spending on for like other professionals, other unclassified positions and things like that. So this is the payer telling us what they paid or spent on. And then we also broke out commercial insurance to show you self-insured, Blue Cross, TVHP, MPP, Worker's Comp and other private. Slide 42 is provider analysis similar but this is where the providers are telling us how they're being paid. Who's paying them commercial medicated Medicare? Slide 43. This is enrollment in our different payer categories. So we have rich data from the annual statement, supplemental statement report. And we also have it from VQRs. We also have data from Vermont Health Hold Health Insurance Survey. So very rich data that we've been using for many years. And so this helps us to understand where people are enrolling and the changes from year to year. So the other thing we want to caution is because of our sources, sometimes people can be counted twice. And that's why we have that note towards the bottom of the slide. And then 44 is my method and sources and technical notes. And we also want to let you know that 2017 expenditure analysis was revised because we had better Medicare data. And so when that's revised, we also revised the out-of-pocket. And also out-of-pocket is a pretty complicated calculation using Vermont data, Medicare allocations, commercial allocations and also the Vermont Health Hold Health Insurance and census data. So it's just not from one place just to let everybody know that. And then I would like to introduce David Glavin for the Tableau Interactive Visualization. Hi, everyone. Hey, David. Are you okay? I'm just going to go right off and share my screen. So in conjunction with Lori's annual report, we developed a tool with the analytics team's developed a tool. And this has been around for about three years. We developed a tool that summarizes some of the information that she's presented within the expenditure analysis. And Lori, you're going to have to remind me of this, but we only have a resident spending only perspective. And I can't remember the reason why we don't do the provider. So if you could step in and remind everyone why we can't create that. I think because the categories could not be relatable sometimes. Correct. And we were trying to do the relationship. And if you found it, made more sense to the total cost of care. And most all of our work is on the resident side. So as a result of that way, this particular visualization is specific to the resident spending. And so it does not include the provider perspective analysis that's included in the entire expenditure analysis report. So first of all, how do we access it? And there's a couple of ways to access the report. The permanent methods are obviously going to be through the board meeting information. Abigail has included a link in today's agenda. So if you just select that, that will launch the Tableau public website, which is where we have several of our visualizations house. And I can actually show you that real quick here. So we have a few other visualizations at this website. You can Google this as well to Google Tableau GMCB Green Mountain Care Board and to get to the site. And in here you have the expenditure analysis report to do in addition to a couple of other reports that we've available. And we're slowly populating this. I shouldn't even say slowly. That's speeding up. We have a few more that are cooking in the oven right now that should be up and running within the next four to six weeks. So anyways, let me show you a couple other ways of accessing. So from the Green Mountain Care Boards main page, if we go to the research and reports link, and then the expenditure analysis enrollment and market share reports. This picture over here and there's a little message here that also says click on the picture, but this picture over here will launch the link to the, the launch the URL to the visualization, the interactive visualization. And then the last location is to the data and analysis link. And then we have a data data reporting link. And on that we scroll down, we have several public reports. And within here is the expenditure analysis as well. And then that will also launch the tool. So the tool is available without, you don't need the, you don't need software. It's like I said, this is interactive and it's, it's just URL based through a web browser. So a couple of limitations on the web browsers. And this is most likely due to a tour for with the Microsoft visualization tool, but Tableau, which obviously is a different company, doesn't play well with Microsoft products. So if you're going to use a browser to, if you're going, when you use your browser to launch the visualization and kind of go through and play with it, we recommend using either Google Chrome, or Fox or Safari to do that. As it doesn't play, the software does not play very well with Microsoft browser products. And like Lori said, if you have any questions, feel free to just cut in at any time. And I'll just try to keep this brief. I just want to give a high overview. I think she's gone through the analytics, analytic elements of it. I just want to show you the tool itself, a couple of features with the tool in terms of download capabilities. And then just to kind of show you the high overview of the visualizations. And at some point if you guys are here, anybody that wants to go in can take a look at it. So on our second tab, so you'll notice that we have a series of tabs across the top here. This is going to take us to the different, what we call dashboards, which has combination of graphs and interactive visualizations. So on this first page here, we have a definitions page just so that we can be clear about what our population descriptions are, the methodology, and this is a very high view of the methodology, our data sources. But what's most important to page is that we have a couple of hyperlinks here, one that will take us to the current expenditure analysis report. So if I click on that, click on that, it'll take you to the report that Lori just presented. And the second one takes you to the more detailed manual. So if you have any questions about a particular graph or something out of the report, this gives a much more deep public description of the methodology and sort of the backbone behind the process that Lori is developing. So that's the, I think the most important element from this. If these are sort of high overview briefs of the data source population and the methodology, but if you want more specifics to the current 2018 report, the hyperlink is here. And so the real methodology and more detail elements are in the manual down here. So the first view that we have is what the residents spend over time. And these views were developed and we had a couple of our board members a couple of years ago helped develop these views and select some of the key graphs out of Lori's report. And then we tried to create them in a, put them into a visually aesthetic format so that you could get lean information based on just looking at visualizations and not digging deep into the report or looking at cross tabs, series of cross tabs. The one highlight I want to mention on these, there are a couple of things I want to mention on this page is we have some highlighting elements here. So if you actually select on one of the payer types, it will highlight that graph on the right hand side. And this is giving us the percent change from the previous year. So one thing to note is that if there's a, what's called a tool tip. So as I hover over this graph, you'll see a little box up here that says 9.5% change. And it gives you detail with respect to which year that changes. So this is, there's a 9.5% change from 2014, which doesn't appear on this graph, but it does appear on this graph. So you can select multiple payer types by either holding the control bar and selecting another payer type. And you'll see that they highlight on the corresponding line graph. If you select again, that will clear the graph. So you have to click a couple of times on it to get the graph to clear. There's also a reset tab. So if I have these collected over here, if you go down to the lower right hand corner, there's a reset. This reset tab will reset the entire workbook back to the original settings. So if you make, and you'll see in subsequent views that there are, you can filter by year and things like that. If you filter by year on another page and then you reset, it will reset the entire workbook. So you'll have to go back and if you, if you think I'll, you'll see that in more detail. I know it's one of the other pages here, but I just want to point out that reset. So if you are uncomfortable with that, so you can't get this to deselect, go down and hit the reset tab here and it will reset the page for you. You can also correspondingly select any one of these graphs, any one of these line graphs, and it will highlight the spend on the, in the bar graph. And then one thing I also want to point out, that we sometimes get questions or in there, sometimes confusion about, for some first time users about like, well, what is that? We don't understand why. We don't understand why. Where is this minus three, minus 3.9% coming from? And if don't, I think a lot of people end up looking at, these are the totals for each year across the top here. The minus not 3.9%, the 6.8% is actually within the commercial group. So if we look, we see that there was a decrease up from 1.92 billion in 2014 to 1.8.5 billion. In the commercial data group in 2015, that's that minus 3.9%. So that's what that is referencing. It's not referencing the total increase over time. Those increases are represented up here. So the actual total values percent changes are highlighted in this table up here. So any questions about that one? And also just pay attention to the notes. When you guys are in here, I put a lot of notes into kind of help define. So what is involved? What is in the commercial bucket? What is in the other sources bucket? So the definitions will be located in some notes or they'll be located in tooltips, those little bars that kind of pop up as I move forward. So that's what we're going to look at. So that's what we're going to look at. Next dashboard is the private versus government compare. On this one here. I just wanted to point out the. This is the two filters on this are filtering for year. The filter obviously will not apply to the. The expenditures over time. So that's what we're going to look at. So that's what we're going to look at. So that's what we're going to look at. So that's what we're going to look at. The expenditures over time because we're not going to be filtering down to a single year here. The filters by year will filter the government versus provider, the payers breakdown or the spend of government provider or private within each one of the providers. And it'll also change the total expenditures graph as well. So if I select a different year here, we'll see that the graph should update for these two graphs here and the two bar graphs here. And then you get detail within providers, the breakdown of the government and private spending within each one of the provider types. The categories are listed over here. So what belongs to government, what belongs to private? I want to point out this is very important that these two provider types are excluded in administration and change in surplus. There's a note down here that the data source does not allow for these values to be distributed between private and government groups. And therefore we excluded them from this page. So the reason I want to point this out is that you may look at this total expenditure value over here, say 5.51 billion. And I'm in 2015. So if I go back to the resident spend over time perspective, I'm looking at 2015. I'll notice that it says 5.72 million, which is the actual total spend that includes, that includes the admins last change in surplus exclusions. That delta is represented down in this note down here. So it says the missing amount from the grand total for these categories is the 206 million. So that 206 million dollars that gets us up to 5.7 billion for 2015 are located down in this note down here. So just pay attention to that. Don't come to the conclusion that we've missed or left something out here or that there's two different spends. The actual total spend is located on the resident time or you can add this 206 million into the 5.51 billion to come up with that total. And then the other piece to this graph or to this particular view is the spend over time. So the breakdown of these categories, except instead of looking at a bar graph for a specific year, we have the spend broken down over time with the total amount. So you can select on hospitals, for example, and we'll give that hospital private. And if you hover over any one of these individual nodules, you'll see that we have the category and the specific spend amount down to the dollar. And then the next tab is the resident spend by provider. This provides a cross tab with a percent breakdown by each of the providers over time. And then down below we have a little bit more detailed view of each of the provider breakdown into the payer types, commercial Medicare, Medicaid, out of pocket and other government spending. The default setting is for hospitals. And if you'll notice that I have dynamic title. So if you change any one of the years, the year should subsequently change so that you know that you're looking at the 2016 resident spend by provider. And then this is the proportion breakdown within the group hospitals. And the tree map over here gives a visualization in rectangles of that proportion. You can give you a quick look. All right, commercial looks like about two thirds. Medicare and Medicaid is there. I'm sorry about half Medicare and Medicaid represents about another third or there are these other four categories represent another quarter. And then that breakdown within those. The actual specific amounts can be found by hovering over each one of the payer types. And that will give you the exact expenditure within the hospital group. To switch the type of provider, just click on one of the bar tabs. And that bar tab will swap out the tree. And you'll see that you get 93% for Medicaid here. And if you hover over this one, because there's not enough space to actually put the other government valuing here, you hover over that. And the tool tip should provide you with what payer type that is. Now, because of that, I also want to point out, I think it's dental. It's a good example. 2016. Yeah, so your nose over here, I have two very tiny little slivers that represent about 0.1%. So that's one of the sort of drawbacks to this. You're really getting a high overview of the spend within each one of the provider types here to give you the main spenders. But if you can actually see those details, if you hover over them, they will show up and you'll see that you do have those point that those missing value, or what appears to be missing dollar values that are represented within them. So with these interactive visualizations, they are interactive. So I do encourage people to kind of play with them and pay attention to a lot of the tips that we've put inside of them. Like I said, if you hover over a particular bar here, you can get the exact spend instead of the spend in billions of dollars. We get the exact spend here, and then also a little note to click on this bar if you want to highlight that in spending and kind of give us just a graphic view of what's the breakdown within that other profession in 2016 category. Like I said, if you need to reset this, just hit the reset button. It'll reset this. But like I said, it'll also reset your other visualizations in each one of the previous steps or any of one of the dashboards. Let's see. Okay. And then the last one I want to show in detail is this resident expenditure analysis Crosstab, which has our providers by payer type breakdown. And I really like this just because it was tricky to put together. But we also provide the year selection filter. And also, if you click on any one of these value types, it will break down the percentage of the spend either by the payer type or you can do it across and it will be by payer type within each one of the provider types. So just another feature that we've added in. I think this was added in last year and I really like this as well too. And also one thing to point out is you hover over this. You'll see this message come up. It says select the plus bar above hospitals category and to the left of the tone. So you'll see this plus bar appears over here. If you click on that plus bar, that brings up a little bit more detail of the sub-provider types within each one of the main provider categories. And this mimics one of Lori's Crosstabs that she has within the report itself. So this also provides that detail as well here. And these percent values across and down also will work with that as well as the year filter. And any questions? Okay, one last thing. So first of all, I want to talk a little bit about just a couple of the download features that people can use for this. So first of all, we have the data for downloads and the data set that I use to build this. This is going to be changed. And I want to point this out on... I'm going to be changing this final tab just to allow for a CSV or an Excel spreadsheet. You'll be able to click on that tab like this and it'll download just a CSV directly. I think it'll be easier for folks. So if you come to our website, you'll see the expenditure analysis vis. I'm going to be adding another tab in here to allow for download of just a CSV slash Excel file to be able to access that data a little bit easier. I do want to point out that you can also do that from this particular page here. And that is located on this download button. And I hope everybody can see this. There's a little download icon in the lower right hand. Not to be confused with this one up here. I spent time with Tableau talking about this. This button up here will download the entire workbook. And so anybody that has the software can download this entire workbook and open it up in the software and be able to manipulate, change some of the visualizations, access the data that's within there. To download the actual data itself, and there's several other options that you're allowed with here. This download icon down here will launch this window and you can download an image. The image will just download the current image or view that you have up. So if I have, so for example, if I'm going to download an image of this particular page, it won't download each individual image of these graphs. What it will do is download the entire dashboard image. So that will open up and then you'll have a dashboard. And that image can be used. It's important to have one. Somebody wanted to use that or embed it on a webpage, et cetera. I think the easiest tool is, I'm going to go back to that. I think the easiest tool to use is this PowerPoint tool. And what the PowerPoint tool will do is allow you to, when it says from this dashboard, it means the specific page that we're looking at right now. If I click on this, it will allow me to pick any one of these four graphs that are located on this page here. So I can select all of these and it'll download a little PowerPoint presentation. I encourage people just to play with this. I'm not going to go into more detail than that, but I just want people to know that there's the capability of actually downloading the entire workbook as well. All of the visualizations and all the work and it'll download an automatic PowerPoint presentation with each one of the graphs in there. You'll also notice this is one of the graphs that's a note that's put in there. So it'll download anything that I've developed into the visualization. But just another nice feature that's accessible. And then like I said, you can also download, let me go back to that data page, the entire data set. So you can do it in two ways. As a cross tab, which I encourage folks to do the cross tab, it'll be a CSV file. So pay attention that the CSV file is not an Excel workbook. So you would need to save this as an Excel workbook if you wanted to create this in Excel. But this is the entire data set that I used. This is the base data set, exactly how it looked when I got it from Lori to build the entire workbook. And so anybody can download this in it. We have, even though the views are limited to five-year views, 2014 through 2018, we have data going back to 2012 available. And then in addition to that, I'm not going to go into detail on the data. This is for more advanced data users. You can download text files and the full data set. And when it says the full data set, if you click on show all columns, this will include every single element that I created building the dashboard. So this would be a little bit more for power users if they want to download the data set in the format that I've created within the workbook itself. So that ends the presentation with regards to our tool and availability of it. If there are any questions, happy to answer them. So a question for either Lori or David from the board. I have a question. Go ahead, Tom. So this is incredibly granular data and congratulations to you all for putting together and for Lori being the backbone of this over the years. As we're going through this, I mean, there were some low numbers that popped up like the 1.9% 2018 over 2017 increase in healthcare spending. And I'm just wondering how hard it would be. I mean, there's some very topside numbers where you take gross spending and divided by the population and you get it per capita number. But how hard would it be to get more granular in that regard so that we could see affordability relative to the Medicaid population? So we have the spending side of Medicaid. Diva has obviously the income side of Medicaid. And is there a marriage there so that we can have more insight into the affordability of Medicare? Similarly, is there a path, which I can't see one, but I'm wondering if anyone's thought about a path relative to affordability of the commercial spend. So affordability is one of our major mantras. And I'm just wondering how this data might be manipulated if it can be a little bit to profile affordability by different groups. We've had that request many times and the concern I have is where do we bucket for a pair out-of-pocket and where do we bucket the other government spending that we get from state and federal? So it's easy to say this is commercial, this is Medicaid and this is Medicare. But where am I going to put uninsured as a population? Where am I going to put the spending for out-of-pocket and other government? If anybody has any ideas, we can try it out. I mean, it's probably just a small percentage change, but I think that that's a great idea to them and we've been trying to think of it. It just doesn't add up, if you know what I mean, to the total spending. But we can do something for you. I have a couple of questions too. Lori, looking at the chart, is there a way to do how much is out-of-state spending for Vermonters and separating any of those charts by out-of-state, the out-of-state spend and the in-state spend and seeing where the changes are? I was able to get that. That's where I was mentioning that in-state versus out-of-state was either 75% or 76% between years. Medicare was like 68 in 2017 and like 73 in 2018. Yes, we can, and I can dive deep for that information if you want, but it would only be that particular bucket. I couldn't do it for the out-of-pocket. Okay. I mean, I don't think, you know, I know we're moving into a busy season with other things, but it would be interesting to see what the trends are for people who are going out-of-state by some of these categories and what's staying in-state and if there's anything we can see from that, you know, so that might be for a future time. Sure. Just one question. When it looked like one of the biggest changes, and I think it was on page 12, was vision and DME, I think went down year over year by 44, I think it was like 44 million. Yet when you look on the other side of it, which was on page 32 or page 15, DME actually was going up slightly. So when we were kind of looking at the differences between the revenue and the expenditures, it seemed like that was an area that had a big change and when I looked at the total spending of that area, it looked like it was only 112 million. So to change 44 million in a year was a lot because of course I like to see the 1.9% in spending, but you know, there's always that disconnect between that spending and the revenue, which was, I think, what, 3.7? I believe most of that was my calculation out of pocket and also taking the allocation from NHE and our Vermont Health Insurance Survey. I was questioning that too, but I didn't have quite enough time to really investigate it. Okay, it just seemed like that was a pretty big change that was down on one side and then on the other side it was fairly flat and on total spending. So, you know, in that 44 million out of, you know, it still was, if that had not changed, it would have been a little bit higher percent in spending change, but... It also depends on what the individual payers were telling me was being spent on that category. Okay. And then one other thing for the future, and I think we've maybe talked a little bit about this before, but the admin and net costs, you know, it sometimes appears like the admin's going down, but it's going down because of changes to surplus and reserves. Right. So, I mean, it's kind of like maybe we should look at admin costs for admin costs and see how that's changing and then surplus to reserves. And that, again, could be for the future, but it just kind of masks the fact that, you know, true admin costs may be going up year over year, and then it's being offset by change to surplus, which is not, to me, necessarily reflective just of admin. Right? That's more probably reflective of claims. Right. And that's why on slide 19, we wanted to emphasize you only see that in commercials. So if you wanted me to just show commercials, like at the bottom of slide 19, it's showing that change in surplus and then change in administration from 12 to the 18. Yeah. Yeah. You're right. Yeah. No, that would be good. Okay. No, it is lots of information. It's always helpful to look through this and it takes a lot to digest. Oh, yeah. Yeah. That's why it's giving it to you just within this last 45 minutes. Yeah. It doesn't tell you what it takes to put it together. And if anybody's interested, just let me know and I can share my resources and data. Yeah. No, thank you. It's obviously a tremendous amount of work and, you know, it gets referred to and a lot of other things. So. Yeah. So thank you for that. That's all I have. Okay. Lori. Okay. Go ahead, Jess. Oh, I was going to say, Lori, first of all, I want to thank you. Thank you. Thank you. And David as well and everybody else who contributed to this, I know it's a monumental task and it's heavily utilized. So I appreciate it. I'm just wondering if you can you go to slide 32 for a quick sec. 32 or 33. Either one of those, I think. Okay. If you want. Sure. I'm just wondering if that's right now. It is. It's perfect for me. Okay. Good. I'm just wondering with respect to healthcare revenues and hospitals and physicians. One of the things that you had mentioned was that hospital employed physicians would be counted in hospital. Right. Is that right? Right. So just wondering, given we've had this shift over the last five or seven years of our physicians moving out of private practice into hospital employment, you know, the slice of physicians is going to look smaller. The slice of hospitals is going to look larger, but it's really just a transfer of employment status to some degree. And I'm wondering, is it possible to slice out of hospitals, you know, the physician component of that so that we can actually see that trend over time and recognize that that's what's happening to some degree. Is that possible? We have, yes, you should see that, at least a slice of it. And on at least for this year for 2018 slide 42, you should see inpatient physician and outpatient physician for our community hospitals. And we have that for as long as we've been reporting it. And we can give you that trend if you want. I guess I was thinking 32 and 33. It doesn't break that out. So, but it talks. So we're talking about hospitals. And that's only a piece of their spending. And also when we're talking about hospitals in that particular slide we were talking about, it included the veterans hospital and the psych hospital. Right. Okay. If you want to get granular, I can. I can. We can talk about it. Yeah. Okay. Thank you. Other questions from the board. If not, we'll open it up for public comments. Are there public comments? Hi, Kevin. It's Kathy. Okay, Kathy. Just a quick follow up on Jessica's question just now and speaking about the physician category. I'm curious as to how you capture our advanced practice folks. They're, I would imagine they're more likely to be employed than the physician. So where do they go? Do they go in the general bucket of hospital expenses or they under a separate provider bucket or, or where are they? It all depends how the census also counts them. So there would be in like the office of physicians and that's basically what this provider revenue analysis is looking at is the offices. So like I just mentioned, if they're a calendar for in the physician office, that's where they would be. If they're in the hospital physician office, they would be in the hospital. Does that help a little? Yes. Thank you very much. And then I had a, another couple of comments on the tableau piece and I wanted to really thank you guys and David, particularly for the presentation. I'm familiar with Tableau and have used it in a few other projects previously. And so I, I totally understand the amount of work and rework it takes to put this together. So thank you. And it has the potential to really inform a lot of decisions that we make. I had a question as an example. So if I click on the, the tab on the Tableau file that says, for example, residents spend by provider. The top spend, as we've said today is in hospitals. And I wonder if there's a way to drill down or is the plan in the future to drill down into hospitals to see, are all hospitals spending at this present rate, which is, I can't see it now in my format, but let's see 2018 it was 36.3%. So do we know that all hospitals, you know, is there one hospital that's 50%, one hospital that's 12%. Are there plans to take a look at that? I'm not sure in Tableau, if you have those percentages in my data, I'm not sure if David, if anybody could download the data and get those percentages, if you open up the hospital category, you might be able to find that. Because I have hospitals, like I mentioned the two psychiatric hospitals, the VA and then our community hospitals. That's the main, a combined total hospital. Yeah, I'm just thinking that that might provide some information where you could look for variation in increases or decreases to try to learn from those changes. Yeah, and those are elements that we can incorporate. You know, if we have the data, we can incorporate those elements into the workbook, the visualization itself, but in this case, it would probably be a different view on a different page, but there would be some relationship between that and possibly build in. Anything's possible. It just is, just take some thinking and some work. Right. Yes, it does. Thank you very much. Thanks, Kathy. Other public comment. And good afternoon, Mr. Chair. This is Susan Aronoff from the Vermont Disabilities Council. Hi. I think I heard Lori about three, maybe four times during your presentation, a reference to something to do with the ACO spend in relation to the slide you were talking about. So there was one point when you said what the residents spend was for Vermont. And then you said some percent, maybe 10 was ACO. And there was a similar reference for the Medicare and Medicaid spend, but I didn't see anything like that on the slides themselves. So I'm wondering if you can shoot me in email or post those references. And if you had some breakout on Tableau or somewhere else, that one could look at these things by, in relationship to the ACO. We could try. The 10% that I was referencing was comparing the resident expenditure analysis and the total cost of care spending and then the one care Vermont budget. And all I did was take that 609 million and compare it to the total spend on the resident side, which equaled about 10%. The other information, I can get it for you, Susan. The other information is not necessarily comparing apples to apples because you're doing state fiscal years and calendar years. But I can get to that information. That would be helpful. It was just odd to go along and hear a reference to the thing that I'm most interested in and think that you guys are going to develop a way to track the expenditures in relation to, but not to see that reflected in the actual documents. So I, if I'm missing a tracking that is ACO related, that would be good to know. It sounds like I'm not, but if you can send me those quotes that you had in the presentation, that would be great. Thank you. All right. Thank you, Susan. I see that more Wasserman has his hand up more. Hi. Thanks. This is such an impressive and presentation. I have a question that may be a little naive. Is there a way to look at expenditures with a little more granularity about the patients? So for instance, I'm interested in age groups. Medicaid includes two very different populations, a population of people, adults with disability, and a population of children. Is there a way to drill down into that? I don't have that information. We would have to drill down into maybe v-cures information to be able to get that for you. Great. Thank you. Thank you. Okay. Rick Dooley had his hand up. Thank you so much for that presentation. This is Rick Dooley representing Health First. And you had mentioned that there are challenges facing the independent practices that are driving independent doctors out and raising the hospital employed. Is there any way to compare, given the reduced costs of the outpatient independent practices compared to the hospital base, is there any way to compare what that difference would be in expenditure if folks remained independent as opposed to becoming hospital employed? It could if I was able to have that rich data sent to us. But that's been a challenge to get the independent physician revenue dollars. I'm using census information. Thanks. Is that into your question? I'd like to be able to get that information if we could have a resource, a direct resource. All right. No, that's good to know because we may be able to help with some of that data production. Thank you. That would be great. Other public comment? Other public comment? Hearing none. I just want to really thank Laurie and David for their hard work. Laurie, you've once again been a rock star preparing this analysis with your team and such short staff. You still were able to deliver it. And we truly appreciate it. Kevin, if I would like to acknowledge the people would be on slide 50. All of the agencies, commercial insurers, VARTA community. And as you mentioned, our teams at the ground care board for helping with this data report. Thank you, Laurie. So with that, is there any new business to come before the board? Is there any new business to come before the board? Again, hearing none. Is there a motion to adjourn? So moved. Second. Second. It's been moved and seconded to adjourn. All those in favor signify by saying aye. Aye. Aye. Any opposed? Thank you, everyone, and have a great rest of the day.