The KYVL funding formula aims for clarity and simplicity; equity and impartiality within and among member types; and sustainability.

As of July 1, 2022, invoicing, all KYVL member libraries and organizations are in formula, except for two for-profit institutions impacted by a rate change during the previous year.

In F2016-17, the Funding Work Group undertook to develop a new database funding formula characterized by:

- Clarity and simplicity
- Equity and impartiality
- Sustainability.

The formula attempts to apply these principles both within and among member types (academic, K12, public and special libraries).The new formula eliminates usage as a measure for individual members, but seeks to generate member revenues reflecting broad usage across member types.

The resulting formula was approved, and following a straight 5% increase for all members in F17-18, implemented of the new formula began with F18-19 invoicing. The complete implementation timeline follows, subject to the transition rules outlined below.

- F16-17 - Last year of old formula
- F17-18 - Old formula plus 5 percent
- F18-19 - 1
^{st}year of new formula - F19-20 - 2
^{nd}year of new formula - F20-21 - 3
^{rd}year of new formula - F21-22 - 4
^{th}year of new formula **F22-23 - All KYVL members in formula under transition rules**

Individual institutional assessments during implementation of the new formula are governed by the following transition rules:

- Nobody pays less than under the previous funding formula.
- Everyone paying less than the new formula amount reaches new formula as soon as possible, subject to a maximum annual increase of 20 percent, except:
- An annual increase of greater than 20 percent is applied when needed for a member institution to reach new formula in a maximum of five years.

A summary of the effects of these transition rules starting in year one of implementation is as follows:

If in comparison with prior year's bill, increase under new formula is: |
Institution pays: |
---|---|

Less than or equal to 0% | Same as current bill |

More than 0% but less than 20% | New formula amount |

More than 20% but less than 150% (upon year one implementation) | 20% increase annually until new formula is reached |

More than 150% (as of year one) | Uniform annual percentage increase that will result in being in formula in five years |

KYVL members enjoy substantial savings through statewide licensing and collaboration. For an estimate of your institution's annual KYVL database costs, enter the requested information below.

Fiscal year costs are calculated using a three-year rolling average of your institution's **12-month FTE** and **total materials / services expenditures** from the most recent Academic Library Survey from IPEDS Data Center at the time of calculation.

Please note that paid courier stops and costs for KDL storage, if applicable, are not included in this calculation.

12-month FTE: | |
---|---|

Total materials / services expenses: | |

Is your institution for profit? | |

$ |

KYVL members enjoy substantial savings through statewide licensing and collaboration. For an estimate of your district's annual KYVL database costs, enter the requested information below. For a private school estimate, please enter number of students and schools / locations.

Fiscal year costs are calculated using a three-year rolling average of **student headcount** and **A1 schools **count as reported in the most current KDE data sets at the time of calculation, generally on or around November 1. For private schools, KYVL consults the NCES Private School Universe Survey whenever possible.

District headcount: | |
---|---|

Number of (A1) schools: | |

$ |

KYVL members enjoy substantial savings through statewide licensing and collaboration. For an estimate of your library's KYVL database costs, enter the requested information below.

Fiscal year costs are calculated using a three-year rolling average of **county population** reported for your library in KDLA's Kentucky Public Library Statics and the report's **total collection expenditures** figures at the time of calculation.

Please note that paid courier stops and costs for KDL storage, if applicable, are not included in this calculation.

County population: | |
---|---|

Total collection expenditures: | |

$ |

KYVL members enjoy substantial savings through statewide licensing and collaboration.

For an estimate of your hospital or system's annual KYVL database costs, enter the requested information below. KYVL uses data from the American Hospital Directory whenever possible.

No. of locations | Staffed beds | Discharges | |
---|---|---|---|

Acute-care hospitals | |||

Non-acute hospitals | |||

Outpatient clinics | |||

$ |

- Begin at IPEDS > Use the Data > Compare Institutions.
- Final Release Data (
*Change*): select*Use Provisional Release Data*to ensure most current data - In Institution Name, enter NCES Unit IDs to search IPEDS data for KYVL academic library members:
## NCES Unit IDs (need KyCAD, Summit Christian)

156189, 156222, 156213, 156231, 247065, 156286, 156295, 157553, 156392, 156356, 156365, 156408, 156417, 446242, 156620, 156648, 156727, 157438, 156745, 156790, 156851, 156860, 156921, 157100, 157058, 157076, 157207, 157216, 157298, 157304, 157331, 484066, 157377, 157386, 157401, 157447, 247940, 461759, 157711, 156338, 157739, 157748, 157757, 157793, 157809, 157818, 157863, 157085, 157289, 157535, 156541, 157483, 157951

*Copy & Paste*;*Select*;*Check all*;*Continue*;*Continue*-
## Search for variables

**12-month full-time equivalent enrollment******(Frequently used / Derived variables > 12-month enrollment)- Select year(s)
- Select variable

**Total materials/services expenditures******(Academic Libraries > Characteristics, collections, expenditures and services > Expenditures)- Select year(s)
- Select variable

*Continue*;*Continue*; (*Select report options*);*Continue*

Begin at KDE Data Sets (from 2020). (Data release timeline here.)

Download:

- Organization Information > District School List
- Col A - SCHOOL YEAR
- Col E - DISTRICT NAME
- Col M - SCHOOL TYPE
- COUNTIFS A1

- Overview > Students > Enrollment > Student Membership
- Col A - SCHOOL YEAR
- Col E - DISTRICT NAME
- Col G - SCHOOL NAME: ---District Total---
- Col M - GRADE: All Students
- Col AK - Total Membership

Kentucky Public Library Statistics are generally published between March and May for the preceding fiscal year. Following publication, contact Jay Bank at KDLA to request a spreadsheet containing **County**, **Population** and **Collection Expenditures Total**.

Hospital data comes from the American Hospital Directory. The Kentucky Hospital Directory may be consulted for additional information.

*Transition Rules Applied* column formula (AcTab)

F18-19

=ROUND(IF([@[F18-19 Formula Total]]<=[@[F17-18 Baseline]],[@[F17-18 Baseline]],IF([@[F18-19 Formula Total]]<=1.2*[@[F17-18 Baseline]],[@[F18-19 Formula Total]],IF([@[F18-19 Formula Total]]>2.5*[@[F17-18 Baseline]],([@[F18-19 Formula Total]]/[@[F17-18 Baseline]])^(1/5)*[@[F117-18 Baseline]],1.2*[@[F17-18 Baseline]]))),0)

F19-20 (Years change automatically when columns are renamed)

=ROUND(IF([@[F19-20 Formula Total]]<=[@[F18-19 Baseline]],[@[F18-19 Baseline]],IF([@[F19-20 Formula Total]]<=1.2*[@[F18-19 Baseline]],[@[F19-20 Formula Total]],IF([@[F19-20 Formula Total]]>2.0736*[@[F18-19 Baseline]],([@[F19-20 Formula Total]]/[@[F18-19 Baseline]])^(1/4)*[@[F18-19 Baseline]],1.2*[@[F18-19 Baseline]]))),0)

F20-21: 1.728, (1/3)

F21-22: 1.44, (1/2)

F22-23: 1.2, (increase)

*In Formula* column formula (AcTab): CHECK LOGIC

=IF([@[F19-20 Formula % Change]]<0,"F18",IF([@[F19-20 Formula % Change]]<=0.2,"F19",IF([@[F19-20 Formula % Change]]<=0.44,"F20",IF([@[F19-20 Formula % Change]]<=0.728,"F21",IF([@[F19-20 Formula % Change]]<=1.0736,"F22","F23")))))

- If Formula < Baseline: Baseline [already in formula]
- Else If Formula <= 1.2*Baseline: Formula [in formula with this increase]
- Else if Formula > max: root [in formula in F22-23]
- Else: 1.2*Baseline [en route to formula]

- Last Updated: Sep 19, 2023 5:04 PM
- URL: https://kyvl.org/committees
- Print Page

844.400.KYVL • kyvl@ky.gov •

A program of the Council on Postsecondary Education.

100 Airport Road, 2