The Local Control Funding Formula (LCFF) Calculator for county offices has been produced based on information currently available to FCMAT and our colleagues in the California Department of Education.
The LCFF Announcement for County Offices email list is FCMAT's primary communication tool for sharing information about updates or other material revisions to the county office LCFF Calculator.
FCMAT's online help desk is intended to provide users with direct support for questions pertaining to the Local Control Funding Formula county office calculations and the county office LCFF Calculator. For school district and charter school calculations, please visit the Local Control Funding Formula Resources for School Districts and Charter Schools page.
Links to the CDE's Principal Apportionment and Special Education certified data exhibits and other resources are offered to give users convenient access to the supporting certified data. Users should independently verify prepopulated data in the county office LCFF Calculator from the Principal Apportionment section certified data exhibits. If any inconsistencies are noted, please report them directly to FCMAT using our help desk.
FCMAT extends great appreciation to each member of the county office LCFF Calculator development team for their contributions and commitment to ensuring the quality of this tool. Further appreciation is extended to the administration and the staff of the California Department of Education for their continued support and collaborative partnership in developing the LCFF Calculator for county offices.
Click an FAQ to open the container and view the answer.
Version 23.2a: Release Date: August 19, 2022
Version 23.2: Release Date: August 9, 2022
This update includes the 2021-22 second principal apportionment (P-2), 2020-21 annual principal apportionment revision 1 (AN R1), and the 2019-20 annual principal apportionment revision 3 (AN R3).
The calculator has also been updated to reflect changes to the Local Control Funding Formula for county offices per the 2022-23 enacted state budget. While FCMAT has done its due diligence to ensure the calculation changes in the COE LCFF Calculator reflect the intent of the legislation, minor adjustments to calculation formulas will be required once the CDE has implemented the changes in the calculations used for the principal apportionment. Modifications to calculations in this version of the COE LCFF Calculator include the following:
Data Entry Tab:
Differentiated Assistance Tab:
23.1h: Release Date: June 23, 2022
23.1g: Release Date: June 20, 2022
Updates to version 23.1g of the County Office Calculator include the following changes:
23.1f: Release Date: April 22, 2022
Updates to version 23.1f of the County Office Calculator includes the following changes:
23.1e: Release Date: April 19, 2022
Updates to version 23.1d of the County Office Calculator include corrected formulas on the EPA tab cells H13 through N13 to look to Data Entry tab row 46, total property tax other than special education, instead of row 43, total property tax.
23.1d: Release Date: April 6, 2022
Updates to version 23.1d of the County Office Calculator include corrected formulas on the Calculator tab cells W48 (Property Tax) and W50 (EPA). These formulas were changed for fiscal year 2021-22 calculations to defer to source data located in the Data Entry tab rather than pulling from the 2021-22 certified data. This is necessary to allow for updates to these data elements after certification.
23.1c: Release Date: April 6, 2022
Updates to version 23.1c of the County Office Calculator include changes to cells W48 (Property Tax) and W50 (EPA). The formula changes affect only fiscal year 2021-22 calculations. Changes were necessary to allow for revisions to data elements as the year progresses, rather than pulling data from the 2021-22 exhibit data file.
Version 23.1b: Release date: April 4, 2022
This version contains the following changes:
Version 23.1a: Release date: March 31, 2022
This version of the LCFF Calculator for County Offices is based on the following:
Prepopulated Data: CDE Certified Data 2021-22 First Qtr. (2021-22 P1, 2020-21 AN, 2018-19 AN R2)