search

opensandiego / mealscount-backend

Optimizing a free-meal reimbursement program for K-12 schools
MIT License
12 stars 15 forks source link

Make rates a drop-down for each grouping of rates by school. #60

Closed nikolajbaer closed 3 years ago

nikolajbaer commented 4 years ago

Current Fed Reimbursement rates are editable fiels, but really this is a set rate table, so this should just be a dropdown selection that triggers everything.

Rates / selections are available in CEP Calculator from USDA.

This might be fine to do as a UI feature in the DistrictSummary edit, and leave all the under-the-hood bits as specific values.

pmelendez2 commented 4 years ago
  1. Select a School District, select a school, Federal Reimbursement Rates are displayed on screen.

FederalReimburesementRates

  1. At bottom of page, select Edit button, Federal Reimbursement Rates are displayed in an Editable form. EditFederalReimbrsementRate
  2. Goal is to make editable Federal Reimbursement Rates populated with per-defined values
pmelendez2 commented 4 years ago

@nikolajbaer , Provide link to "Rates / selections are available in CEP Calculator from USDA.", where rates are provided.

nikolajbaer commented 4 years ago

https://www.fns.usda.gov/nslp/community-eligibility-provision-resource-center

Direct Link: https://www.fns.usda.gov/sites/default/files/resource-files/CEPEstimatorTool.xlsx

The bottom of the 2nd Tab "Federal Estimator" has a grid of rate types based on different classifications. There is a formula on the third sheet that I think helps navigate it, but it alll requires Excel (doesn't appear to work in LibreOffice or Google Sheets for me).

nikolajbaer commented 4 years ago

Note the current rates might not be up to date to the most recent estimator tool, so worth double checking that.

nikolajbaer commented 3 years ago

Additional Note from: https://www.isbe.net/Documents/cep-plan-implement-guidance1601.pdf

nikolajbaer commented 3 years ago

Closing this in favor of #94 , as rate determination is actually not simple and might require changes to include fields at the school level.