{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["SB1383 Edible Definitions","Business Data Needed","Methodology","SUMMARY RESULTS","SELECT SECTOR EDIBLE BREAKDOWN","Food Waste Calcs","Rescue Potential Calcs","Sheet2","Lookup"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":1,"defined_names":17,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SB1383 Edible Definitions","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Summary of Business Information to Gather for Identifying SB1383 Edible Food Generators and Estimating Edible Food Recovery"]
[]
["Definitions: "]
[" “Tier one commercial edible food generator” means a commercial edible food generator that is one of the following: "]
[null,"(A) Supermarket. "]
[null,null,"“Supermarket” means a full-line, self-service retail store with gross annual sales of two million dollars ($2,000,000), or more, and which sells a line of dry grocery, canned goods, or nonfood items and some perishable items."]
[null,"(B) Grocery store with a total facility size equal to or greater than 10,000 square feet.  "]
[null,null,"“Grocery store” means a store primarily engaged in the retail sale of canned food; dry goods; fresh fruits and vegetables; fresh meats, fish, and poultry; and any area that is not separately owned within the store where the food is prepared and served, including a bakery, deli, and meat and seafood departments"]
[null,"(C) Food service provider. "]
[null,null,"Food service provider means an entity primarily engaged in providing food services to institutional, governmental, commercial, or industrial locations of others based on contractual arrangements with these types of organizations"]
[null,"(D) Food distributor. "]
[null,null,"“Food Distributor” means a company that distributes food to entities including, but not limited to, supermarkets and grocery stores"]
[null,"(E) Wholesale food vendor.  "]
[null,null,"“Wholesale food vendor” means a business or establishment engaged in the merchant wholesale distribution of food, where food (including fruits and vegetables) is received, shipped, stored, prepared for distribution to a retailer, warehouse, distributor, or other destination."]
[]
["“Tier two commercial edible food generator” means a commercial edible food generator that is one of the following: "]
[null,"(A) Restaurant with 250 or more seats, or a total facility size equal to or greater than 5,000 square feet. "]
[null,null,"“Restaurant” means an establishment primarily engaged in the retail sale of food and drinks for on-premises or immediate consumption."]
[null,"(B) Hotel with an on-site food facility and 200 or more rooms.  "]
[null,null,"“Hotel” has the same meaning as in \"Hotel” has the same meaning as in Section 17210 of the Business and Professions code.."]
[null,"(C) Health facility with an on-site food facility and 100 or more beds. "]
[null,null,"“Health facility” has the same meaning as in Section 1250 of the Health and Safety Code."]
[null,"(D) Large venue.  "]
[null,null,"“Large venue” means a permanent venue facility that annually seats or serves an average of more than 2,000 individuals within the grounds of the facility per day of operation of the venue facility. "]
[null,null,"For the purposes of this chapter, a venue facility includes, but is not limited to, a public, nonprofit, or privately owned or operated stadium, amphitheater, arena, hall, amusement park, conference or civic center, zoo, aquarium, airport, racetrack, horse track, performing arts center, fairground, museum, theater, or other public attraction facility. For the purposes of this chapter, a site under common ownership or control that includes more than one large venue that is 1 contiguous with other large venues in the site, is a single large venue."]
[null,"(E) Large event.  "]
[null,null,"“Large event” means an event, including, but not limited to, a sporting event or a flea market, that charges an admission price, or is operated by a local agency, and serves an average of more than 2,000 individuals per day of operation of the event, at a location that includes, but is not limited to, a public, nonprofit, or privately owned park, parking lot, golf course, street system, or other open space when being used for an event."]
[null,"(F) A state agency with a cafeteria with 250 or more seats or a total cafeteria facility size equal. to or greater than 5,000 square feet.  "]
[]
[null,"(G) A local education agency with an on-site food facility."]
[null,null,"“Local education agency” means a school district, charter school, or county office of education that is not subject to the control of city or county regulations related to solid waste. "]
[]
["Other definitions provided:"]
[null,"“Food facility” has the same meaning as in Section 113789 of the Health and Safety Code."]
[null,"“Non-local entity” means an entity that is an organic waste generator but is not subject to the control of a jurisdiction’s regulations related to solid waste. These entities may include, but are not limited to, special districts, federal facilities, prisons, facilities operated by the state parks system, public universities, including community colleges, county fairgrounds, and state agencies."]

{"sheet":"Business Data Needed","index":1,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[21,10,22,11],[12,0,12,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[21,2,21,9],[22,4,22,5],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[21,0,22,0],[21,1,22,1]]}
["Information to Gather for Identifying SB1383 Edible Food Generators and Estimating Edible Food Recovery for the Planning Period January 1, 2022 - December 31, 2024"]
[]
["*NEW* Population Data"]
["The jurisdiction will need the current population as of January 1, 2022 to estimate current disposal by Commerical Edible Food Generators. "]
["The jurisdiction will also need the future projected population at the end of the planning period, December 31, 2024, for purposes of estimating the projected future disposal. "]
[]
["Types of Business Data to Gather: "]
["General Information to include with all facilities returned in search results, as available. Ideally this information will be in excel format with columns for each of the following. That way the data can easily be sorted.",null,"Other sector-specific information identified via other research/ audits"]
["Facility/ business name, ",null,"Hotels and Lodging: general information plus"]
["address, ",null,"# of rooms"]
["contact info, ",null,"Onsite food facility?  "]
["primary NAICS or SIC code, ",null,"Licensed Health Care Facilities: general information plus"]
["additional NAICS or SIC codes…",null,"# of beds"]
["facility square footage, ",null,"Onsite food facility? "]
["Annual gross sales, ",null,"Entertainment/ Venues: general information plus"]
["# of employees",null,"# annual visitors "]
["# of seats or seating capacity or visitor capacity",null,"Special Events: general information plus"]
[null,null,"# visitors per day "]
["If a business has multiple locations, then return above for each location in the jurisdiction."]
[]
["Details on Potential Commercial Edible Food Generators and Demographic Data Needed to Estimate Potential Food Recovery"]
["Facility Type","SB 1383 Notes","Identify Commercial Edible Food Generators ",null,null,null,null,null,null,null,"Other demographics to use this tool"]
[null,null,"Seats","Visitors","Facility Size",null,"Gross Sales","Rooms","Beds","Onsite Food Facility"]
["Tier 1 Commercial Edible Food Generators"]
["Supermarkets ","Gross sales. CalRecycle already identifies Supermarkets in CRV Program. ",null,null,null,null,2000000,null,null,null,"# employees"]
["Grocery Stores","Facility size",null,null,10000,"sf",null,null,null,null,"# employees"]
["Food Service Providers ",null,null,null,null,null,null,null,null,null,"# employees"]
["Food Wholesale Vendors and Distributors ",null,null,null,null,null,null,null,null,null,"# employees"]
["Tier 2 Commercial Edible Food Generators"]
["Restaurants","Seats or facility size",250,null,5000,"sf",null,null,null,null,"# employees"]
["Health Facilities","# beds, onsite food facility ",null,null,null,null,null,null,100,"X","# employees","# permitted beds (online lookup)"]
["Large Venues ","# seats and/or annual average of daily visitors","2000*","2000*",null,null,null,null,null,null,"# employees","# seats or # annual visitors"]
["Large Events ","attendees/ day. Sum up annual total",null,2000,null,null,null,null,null,null,null,"# annual visitors- permit information"]
["Hotel ","# rooms, onsite food facility",null,null,null,null,null,200,null,"X","# employees"]
["State agencies","Onsite cafeteria seats or cafeteria facility size",250,null,5000,"sf",null,null,null,"X","# FTE employees (College + University), # total employees (other), or # food service employees","# students (College + University, online lookup)"]
["Local Education Agencies","Onsite food facilities. Public schools and central kitchens",null,null,null,null,null,null,null,"X","# FTE employees","# students (online lookup)"]
["Other (might fit into one of the above)"]
["Food Production","Include those that are wholesale food vendors and/ or distributors. Growers and producers are not necessarily Commercial Edible Food Generators . Very dependent on individual businesses. "]
["Corporate Sites w/ Food Service ","Could fall under Restaurant definition or Food Service Provider",null,null,null,null,null,null,null,"X","# employees at the facility or number of food service staff"]
["Other government agencies w/ onsite food facilities","Could fall under Restaurant definition or Food Service Provider",null,null,null,null,null,null,null,"X","# employees at the facility or number of food service staff"]
["Prisons/ correctional facilities ","# inmates. Also note central production facilities",null,null,null,null,null,null,null,"X",null,"# inmates (online lookup)"]
[]
["Other areas  to consider: ","Retail variety stores, discount and dollar stores, and other stores carrying groceries. These may be included as \"Grocery Stores\" for purposes of SB 1383 enrollment as Tier 1 Generators. "]
[null,"Use discretion in including them. Do they dispose of edible food in significant quantity? "]
[null,"May consider including them for now and later confirming via audits, etc."]
[]
[null,"Businesses may not outright meet its primary Tier 1 or Tier 2 definition, but an activity at the business or site could. "]
[null,"For example, a hotel may have less than 200 rooms, but it could have other amenities or services onsite could meet other Tier 1 or 2 generator definitions (Large Venue, Restaurant)"]
[null,"In the above example of hotel with less than 200 rooms, the specific venue or restaurant would be the generator required to comply with the edible food recovery requirements. The whole hotel itself, is not the generator. "]
[]
[null,"Caterers are not Commercial Edible Food Generators"]

{"sheet":"Methodology","index":2,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[24,2,25,16]]}
["Edible Food Rescue Potential Methodology "]
["This page explains the methodology followed by County of San Diego staff and contractors to identify generators and estimate edible food rescue potential"]
[]
[1,"Determine how jurisdiction will use this tool. For example, County of San Diego initially ran this tool to estimate edible food rescue potential from SB 1383 Tier 1 and Tier 2 generators. The tool can also be used to estimate jurisdiction-wide edible food rescue potential from ALL generators, or certain sectors. "]
[2,"The methodology that follows explains estimating edible food rescue from SB 1383 Tier 1 and Tier 2 Generators. "]
[3,"Identify generators and aggregate their business data by sector"]
[null,"a","Review hauler account records, business license records, economic development data, food facility licensees from the health department, etc. to identify what records are readily available for food generating businesses"]
[null,"i. ","Refer to \"Business Data Needed\" tab to identify information needed for each business sector of interest such as facility size, sales revenue, etc. "]
[null,"ii. ","Review the \"Food Waste Calcs\" and \"Rescue Potential Calcs\" tab herein and note which specific data is also needed by sector to populate the tool. "]
[null,"b","Commercial Business Lists: "]
[null,"i. ","Access business database records for free via public library (may need library card). Will need to enter search criteria such as NAICS codes. For example, Data Axle. "]
[null,"ii. ","Commercial business lists may also be purchased. County of San Diego purchased a list from a local firm, Spectrum Data Services. ",null,null,null,null,null,null,null,null,"https://sds.com/  "]
[null,"iii.","Hoovers Database (Dun & Bradstreet), available for purchase",null,null,null,null,null,null,"https://www.dnbsame.com/hoovers.php"]
[null,"iv.","The search criteria needs to be pre-defined and provided to the listing firm. They can help define the search criteria"]
[null,"c","The generators will likely be identified through a combination of the sources identified above. It takes general knowledge of the businesses in the jurisdiction along with combing through available data, to develop a compilation of potential businesses"]
[null,"i. ","Create a master list of businesses organized by their business sector"]
[null,"ii. ","Aggregate the required data by business sector, i.e., total number of employees, total number of students, etc. "]
[null,"d","Some helpful websites to gather additional information for certain sectors (note, you will need to have a list of these facilities on hand through your prior facility search): "]
[null,null,"Public Schools, number of students and FTE employees: ",null,null,null,null,null,null,"https://nces.ed.gov/","https://dq.cde.ca.gov/dataquest/"]
[null,null,"Universities and Colleges, # of students and FTE employees: obtain directly from their website",null,null,null,null,null,null,null,"https://www.universityofcalifornia.edu/infocenter/employee-fte"]
[null,null,"Community Colleges, number of students and FTE employees: ",null,null,null,null,null,null,"https://datamart.cccco.edu/Faculty-Staff/Default.aspx"]
[null,null,"Prisons and Correctional Facilities, number of inmates: obtain directly from facility, and: ",null,null,null,null,null,null,null,"http://www.prisonpro.com/correctional-facilities-by-state"]
[null,null,"Healthcare, number of licensed beds:",null,null,null,null,null,null,"https://www.cdph.ca.gov/Programs/CHCQ/LCP/CalHealthFind/Pages/SearchResult.aspx ",null,null,"https://www.ahd.com"]
[4,"a","Enter the aggregated business data into the calculations tabs to populate the tool. "]
[null,"i. ","Note the tool is organized by sector types and do not exactly follow Commercial Edible Food Definitions. For example, \"State Agency.\" The user will identify the state agency for purposes of ID'ing it as a Tier 2 generator. For purposes of estimating food disposal/ recovery, the user will assign the best matching sector, such as \"restaurant\" or \"food service provider\" or \"prison,\" etc. "]
[]
[5,"Population Data"]
[null,"a","California DOF records may be used to determine population forecasts at the County level."]
[null,"b","Or, the jurisdiction's planning department can provide existing and projected population for the planning period."]
[null,"c","Ensure the population projection covers the three-year planning period. This tool will apply the % change in population over the planning period to estimate the future projected disposal. "]
["Notes: "]
[null,"This tool is adapted from NRDC's calculator: \"City Wasted Food and Rescue Potential Calculator\""]
[]
[null,"The calculation is developed using food waste disposal and generation metrics identified in CalRecycle's 2014 Generator Study, with some select sector data from thier 2018 Waste Characterization Study.  Some detailed sector data was extrapolated from CalRecycle's 2012 Commercial Climate Calculator (noted as Cascadia model herein)"]
[null,"The rescue scenarios are largely sources from narrative descriptions of food recovery potential in NRDC's report: \"Modeling the Potential to Increase Food Rescue: Denver, New York and Nashville.\" "]
[]
[null,"The tool may not reflect existing diversion/ recovery practices at individual facilities.  "]
[null,"The tool is static and won't estimate changes over time. "]

{"sheet":"SUMMARY RESULTS","index":3,"n_rows":180,"n_cols":40,"rows_kept":180,"cut":false,"hidden":false,"merged":[[52,7,52,21],[52,23,52,37],[53,23,53,31],[53,32,53,37],[54,23,55,23],[54,24,55,24],[54,26,55,26],[54,27,55,27],[54,29,55,29],[54,30,55,30],[54,33,55,33],[54,35,55,35],[54,36,55,36],[116,2,116,21],[53,16,53,21],[54,39,55,39],[54,8,55,8],[54,10,55,10],[54,17,55,17],[54,19,55,19],[54,20,55,20],[53,7,53,15],[54,14,55,14],[53,2,55,6],[58,2,59,2],[101,2,102,2],[54,11,55,11],[54,13,55,13],[54,7,55,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Moderate Recoverable Potential",null,null,null,null,"Maximum Recoverable Potential",null,null,null,null,null,null,null,null,null,null,null,null,"Maximum Recoverable Potential"]
[]
[null,null,"Total tons of rescue potential",{"$f":"L113","v":0},null,null,null,"Total tons of rescue potential",null,null,null,null,null,null,{"$f":"O113","v":165},null,null,null,null,null,"Total tons of rescue potential",null,null,null,{"$f":"U113","v":165}]
[null,null,"Total meals potentially rescued",{"$f":"L113*2000/1.2","v":0},null,null,null,"Total meals potentially rescued",null,null,null,null,null,null,{"$f":"O113*2000/1.2","v":275000},null,null,null,null,null,"Total meals potentially rescued",null,null,null,{"$f":"U113*2000/1.2","v":275000}]
[null,null,"Potential meal gap filled",{"$f":"D46/(A70/A68)","v":0},null,null,null,"Potential meals gap filled",null,null,null,null,null,null,{"$f":"O46/($A$70/$A$68)","v":8.3849760222725347E-2},null,null,null,null,null,"Potential meals gap filled",null,null,null,{"$f":"Y46/($A$70/$A$68)","v":8.3849760222725347E-2}]
[]
[]
[]
[]
[null,null,"Overall Food Disposal and Potential Edible Food Recovery",null,null,null,null,null,"DRAFT MODEL. METHODOLOGY AND RESULTS SUBJECT TO CHANGE. REVISED APRIL 2022."]
[null,null,null,null,null,null,null,"BEGINNING REPORTING YEAR RESULTS: YEAR 2022",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TARGET REPORTING YEAR RESULTS: YEAR 2024"]
["Enter Jurisdiction Name Here",null,"Sector Summaries",null,null,null,null,"Disposal Based Results",null,null,null,null,null,null,null,null,"Generation Based Results",null,null,null,null,null,null,"Disposal Based Results",null,null,null,null,null,null,null,null,"Generation Based Results"]
[null,null,null,null,null,null,null,null,"Estimated tons of food waste disposed per sector per year",null,null,"Moderate tons of additional rescue potential per sector per year",null,null,"Maximum tons of rescue potential per sector per year",null,null,"Upper limit of estimated tons of food waste that may be disposed per sector per year ",null,null,"Upper limit tons of rescue potential per sector per year",null,null,null,"Estimated tons of food waste disposed per sector per year",null,null,"Moderate tons of additional rescue potential per sector per year",null,null,"Maximum tons of rescue potential per sector per year",null,null,"Upper limit of estimated tons of food waste that may be disposed per sector per year ",null,null,"Upper limit tons of rescue potential per sector per year",null,null,"Additional Notes "]
["Residents"]
["Total Residential Population",null,"Tier 1 Commercial Edible Food Generators (Note 1)"]
[null,null,"Grocery Stores and Supermarkets"]
["Meals gap",null,"Includes \"typical\" supermarkets and groceries for purposes of estimating disposal/ potential recovery",{"$f":"'Food Waste Calcs'!B6","v":0},null,"Employees",null,null,{"$f":"'Food Waste Calcs'!F6","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F7","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I7","v":0},null,null,{"$f":"'Food Waste Calcs'!I6","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M7","v":0},null,null,null,{"$f":"I59*'Food Waste Calcs'!$F$55+I59","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L59*'Food Waste Calcs'!$F$55+L59","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O59*'Food Waste Calcs'!$F$55+O59","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R59*'Food Waste Calcs'!$F$55+R59","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U59*'Food Waste Calcs'!$F$55+U59","v":{"$error":"#DIV/0!"}}]
["Information about food insecurity at the county level can be found at:"]
["http://map.feedingamerica.org/"]
["City-specific estimates may be available from",null,"Warehouse Clubs and Supercenters (1383 Supermarkets or Grocery)"]
["local agencies or social service providers.",null,"Warehouse Clubs and Big Box Stores",{"$f":"'Food Waste Calcs'!B8","v":0},null,"Employees",null,null,{"$f":"'Food Waste Calcs'!F8","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F8","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I8","v":0},null,null,{"$f":"'Food Waste Calcs'!I8","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M8","v":0},null,null,null,{"$f":"I63*'Food Waste Calcs'!$F$55+I63","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L63*'Food Waste Calcs'!$F$55+L63","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O63*'Food Waste Calcs'!$F$55+O63","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R63*'Food Waste Calcs'!$F$55+R63","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U63*'Food Waste Calcs'!$F$55+U63","v":{"$error":"#DIV/0!"}}]
["Please locate the data for your area and enter the corresponding information below"]
["Number of Food Insecure People in City"]
[null,null," Food Service Providers "]
["Average Meal Cost",null,"Contract Food Service, Corporate Kitchens and Banquet Halls",{"$f":"'Food Waste Calcs'!B10","v":0},null,"Employees (Food Service Staff)",null,null,{"$f":"SUM('Food Waste Calcs'!F10:F11)","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F9","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I9","v":0},null,null,{"$f":"SUM('Food Waste Calcs'!I10:I11)","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M9","v":0},null,null,null,{"$f":"I67*'Food Waste Calcs'!$F$55+I67","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L67*'Food Waste Calcs'!$F$55+L67","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O67*'Food Waste Calcs'!$F$55+O67","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R67*'Food Waste Calcs'!$F$55+R67","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U67*'Food Waste Calcs'!$F$55+U67","v":{"$error":"#DIV/0!"}}]
[3.23,null,"or",{"$f":"'Food Waste Calcs'!B11","v":0},null,"Employees (Of the business served)"]
["Annual Food Budget Shortfall"]
[{"$f":"188159000*0.0563","v":10593351.700000001},null,"Food Distributors"]
["County Population",null,"Includes food packing, wholesale distributors and suppliers",{"$f":"'Food Waste Calcs'!B13","v":0},null,"Employees",null,null,{"$f":"'Food Waste Calcs'!F13","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F11","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I11","v":0},null,null,{"$f":"'Food Waste Calcs'!I13","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M11","v":0},null,null,null,{"$f":"I71*'Food Waste Calcs'!$F$55+I71","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L71*'Food Waste Calcs'!$F$55+L71","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O71*'Food Waste Calcs'!$F$55+O71","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R71*'Food Waste Calcs'!$F$55+R71","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U71*'Food Waste Calcs'!$F$55+U71","v":{"$error":"#DIV/0!"}}]
[3344430]
[null,null,"Wholesale Food Vendors"]
[null,null,"Includes food manufacturing and processing",{"$f":"'Food Waste Calcs'!B15","v":0},null,"Employees",null,null,{"$f":"'Food Waste Calcs'!F15","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F10","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I10","v":0},null,null,{"$f":"'Food Waste Calcs'!I15","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M10","v":0},null,null,null,{"$f":"I74*'Food Waste Calcs'!$F$55+I74","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L74*'Food Waste Calcs'!$F$55+L74","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O74*'Food Waste Calcs'!$F$55+O74","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R74*'Food Waste Calcs'!$F$55+R74","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U74*'Food Waste Calcs'!$F$55+U74","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Tier 2 Commercial Edible Food Generators (Note 1)"]
[null,null,"Colleges and Universities "]
[null,null,"May include public and private institutions. ",{"$f":"'Food Waste Calcs'!B19","v":0},null,"employees"]
[null,null,"or",{"$f":"'Food Waste Calcs'!B21","v":0},null,"students",null,null,{"$f":"SUM('Food Waste Calcs'!F19:F21)","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F13","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I13","v":0},null,null,{"$f":"SUM('Food Waste Calcs'!I19:I21)","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M13","v":0},null,null,null,{"$f":"I79*'Food Waste Calcs'!$F$55+I79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L79*'Food Waste Calcs'!$F$55+L79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O79*'Food Waste Calcs'!$F$55+O79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R79*'Food Waste Calcs'!$F$55+R79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U79*'Food Waste Calcs'!$F$55+U79","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"K-12 Schools (Local Education Agencies)"]
[null,null,"(may include private schools that meet other definitions)",{"$f":"'Food Waste Calcs'!B24","v":0},null,"Employees"]
[null,null,"or",{"$f":"'Rescue Potential Calcs'!C14","v":0},null,"students",null,null,{"$f":"SUM('Food Waste Calcs'!F24:F25)","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F14","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I14","v":0},null,null,{"$f":"SUM('Food Waste Calcs'!I24:I25)","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M14","v":0},null,null,null,{"$f":"I83*'Food Waste Calcs'!$F$55+I83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L83*'Food Waste Calcs'!$F$55+L83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O83*'Food Waste Calcs'!$F$55+O83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R83*'Food Waste Calcs'!$F$55+R83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U83*'Food Waste Calcs'!$F$55+U83","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Hotels   "]
[null,null,"Hotels including lodging and tourism businesses",{"$f":"'Food Waste Calcs'!B27","v":0},null,"Employees",null,null,{"$f":"SUM('Food Waste Calcs'!F27:F28)","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F15","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I15","v":0},null,null,{"$f":"SUM('Food Waste Calcs'!I27:I28)","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M15","v":0},null,null,null,{"$f":"I86*'Food Waste Calcs'!$F$55+I86","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L86*'Food Waste Calcs'!$F$55+L86","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O86*'Food Waste Calcs'!$F$55+O86","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R86*'Food Waste Calcs'!$F$55+R86","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U86*'Food Waste Calcs'!$F$55+U86","v":{"$error":"#DIV/0!"}}]
[null,null,"or",{"$f":"'Food Waste Calcs'!B28","v":0},null,"Rooms"]
[]
[null,null,"Health Care"]
[null,null,"Includes hospitals and skilled nursing facilities. Includes beds of residential living (i.e., assisted living) if shared onsite with licensed health facility ",{"$f":"'Food Waste Calcs'!B30","v":0},null,"Employees",null,null,{"$f":"SUM('Food Waste Calcs'!F30:F31)","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F16","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I16","v":0},null,null,{"$f":"SUM('Food Waste Calcs'!I30:I31)","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M16","v":0},null,null,null,{"$f":"I90*'Food Waste Calcs'!$F$55+I90","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L90*'Food Waste Calcs'!$F$55+L90","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O90*'Food Waste Calcs'!$F$55+O90","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R90*'Food Waste Calcs'!$F$55+R90","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U90*'Food Waste Calcs'!$F$55+U90","v":{"$error":"#DIV/0!"}}]
[null,null,"or",{"$f":"'Food Waste Calcs'!B31","v":0},null,"Beds"]
[]
[null,null,"Other Retail w/ Grocery"]
[null,null,"Other Retail Stores w/ Grocery, Discount Stores, etc.",{"$f":"'Food Waste Calcs'!B33","v":0},null,"employees",null,null,{"$f":"'Food Waste Calcs'!F33","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F17","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I17","v":0},null,null,{"$f":"'Food Waste Calcs'!I33","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M17","v":0},null,null,null,{"$f":"I94*'Food Waste Calcs'!$F$55+I94","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L94*'Food Waste Calcs'!$F$55+L94","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O94*'Food Waste Calcs'!$F$55+O94","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R94*'Food Waste Calcs'!$F$55+R94","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U94*'Food Waste Calcs'!$F$55+U94","v":{"$error":"#DIV/0!"}},null,null,"User to apply discretion in assigning "]
[]
[null,null,"Restaurants"]
[null,null,null,{"$f":"'Food Waste Calcs'!B39","v":0},null,"Employees"]
[null,null,"Full Service",{"$f":"'Food Waste Calcs'!B37","v":0},null,"Employees",null,null,{"$f":"'Food Waste Calcs'!F37","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F18","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I18","v":0},null,null,{"$f":"'Food Waste Calcs'!I37","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M18","v":0},null,null,null,{"$f":"I98*'Food Waste Calcs'!$F$55+I98","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L98*'Food Waste Calcs'!$F$55+L98","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O98*'Food Waste Calcs'!$F$55+O98","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R98*'Food Waste Calcs'!$F$55+R98","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U98*'Food Waste Calcs'!$F$55+U98","v":{"$error":"#DIV/0!"}}]
[null,null,"Limited Service",{"$f":"'Food Waste Calcs'!B38","v":0},null,"Employees",null,null,{"$f":"'Food Waste Calcs'!F38","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F19","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I19","v":0},null,null,{"$f":"'Food Waste Calcs'!I38","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M19","v":0},null,null,null,{"$f":"I99*'Food Waste Calcs'!$F$55+I99","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L99*'Food Waste Calcs'!$F$55+L99","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O99*'Food Waste Calcs'!$F$55+O99","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R99*'Food Waste Calcs'!$F$55+R99","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U99*'Food Waste Calcs'!$F$55+U99","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Event and Recreation Facilities"]
[null,null,"Includes sports and event spaces",{"$f":"'Food Waste Calcs'!B41","v":0},null,"Employees",null,null,{"$f":"'Food Waste Calcs'!F41+'Food Waste Calcs'!F42","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F20","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I20","v":0},null,null,{"$f":"'Food Waste Calcs'!I41+'Food Waste Calcs'!I42","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M20","v":0},null,null,null,{"$f":"I102*'Food Waste Calcs'!$F$55+I102","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L102*'Food Waste Calcs'!$F$55+L102","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O102*'Food Waste Calcs'!$F$55+O102","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R102*'Food Waste Calcs'!$F$55+R102","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U102*'Food Waste Calcs'!$F$55+U102","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"'Food Waste Calcs'!B42","v":0},null,"Annual visitors"]
[]
[null,null,"Correctional Facilities (Tier 1 or Tier 2, User to Confirm)"]
[null,null,"Includes prisons and jails",{"$f":"'Food Waste Calcs'!B44","v":0},null,"Inmates",null,null,{"$f":"'Food Waste Calcs'!F44","v":0},null,null,{"$f":"'Rescue Potential Calcs'!F21","v":0},null,null,{"$f":"'Rescue Potential Calcs'!I21","v":0},null,null,{"$f":"'Food Waste Calcs'!I44","v":0},null,null,{"$f":"'Rescue Potential Calcs'!M21","v":0},null,null,null,{"$f":"I106*'Food Waste Calcs'!$F$55+I106","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L106*'Food Waste Calcs'!$F$55+L106","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O106*'Food Waste Calcs'!$F$55+O106","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R106*'Food Waste Calcs'!$F$55+R106","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U106*'Food Waste Calcs'!$F$55+U106","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Other Commercial Edible Food Generators "]
[null,null,"Other- (Tier 1 or Tier 2, as determined by user)",null,null,null,null,null,null,null,null,"manually enter food recovery estimate",null,null,"manually enter food recovery estimate",null,null,null,null,null,"manually enter food recovery estimate"]
[null,null,"Other- Enter Note of Other Facilities. See Food Waste Calcs for Details",{"$f":"'Food Waste Calcs'!B51","v":0},null,"Tons of food wasted",null,null,{"$f":"'Food Waste Calcs'!F51","v":0},null,null,null,null,null,165,null,null,{"$f":"'Food Waste Calcs'!I51","v":0},null,null,{"$f":"O110","v":165},null,null,null,{"$f":"I110*'Food Waste Calcs'!$F$55+I110","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L110*'Food Waste Calcs'!$F$55+L110","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O110*'Food Waste Calcs'!$F$55+O110","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R110*'Food Waste Calcs'!$F$55+R110","v":{"$error":"#DIV/0!"}},null,null,{"$f":"U110*'Food Waste Calcs'!$F$55+U110","v":{"$error":"#DIV/0!"}},null,null,"User may manually enter current and future potential recovery estimates, if estimated"]
[]
[]
[null,null,null,null,null,"Total Estimated Tons",null,null,{"$f":"SUM(I57:I111)","v":0},null,null,{"$f":"SUM(L57:L111)","v":0},null,null,{"$f":"SUM(O57:O111)","v":165},null,null,{"$f":"SUM(R57:R111)","v":0},null,null,{"$f":"SUM(U57:U111)","v":165},null,null,null,{"$f":"SUM(Y57:Y111)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AB57:AB111)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AE57:AE111)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AH57:AH111)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AK57:AK111)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"*adapted from NRDC's \"City Wasted Food and Rescue Potential Calculator\""]
[]
[null,null,"(1) Generators are generally organized by Tier 1 and Tier 2 sector designations, though some generators do not neatly fit into a Tier 1 and Tier 2 sector. User may need to extract or reorganize results to gain an accurate picture of Tier 1 and Tier 2. For example, \"Retail Variety Store\" is not a Tier 1 or Tier 2 generator in itself, nor are \"Colleges and Universities.\" The specific food sectors of Non-Local Entities would need to be used as well. "]
[]
[null,null,"(2) Column AE, Target Reporting Year Results: Year 2024, Maximum Pounds of Rescue Potential…, is the edible food disposal result for purposes of capacity planning. "]
[]
[null,null,"(3) Users may elect to incorporate results from this Calculator tool into CalRecycle's Edible Food Calculator Tool for purposes of quantifying the edible food recovery capacity surplus or deficit. "]
[null,null,"If incorporating results into CalRecycle's tool, user will need to use the Beginning Reporting Year Results: Year 2022. Maximum Tons of Rescue Potential... from Column O, as well as re-enter the population data. The target reporting year projection disposal will automatically calculate in CalRecycle's tool. "]
[]
[null,null,"(4) \"Moderate Pounds of Rescue Potential…\" in Columns L and AB represent lower participation by generators and less than maximum amounts of edible food being recovered. Thes figures might help jurisdictions plan how to ramp up their program over time until they achieve thier planned capacity"]
[]
[null,null,"(5) Generation-Based results are hidden in columns Q-V, and AG-AL. "]
[null,null,"The estimates for edible food recovery were derived from landfill disposal data, not food waste generation. The actual recovery potential at the generation level may vary significantly. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"will hide"]
[null,null,"Sectors",null,null,"Sectors",null,null,"Tons of food waste disposed",null,null,"AG",null,null,"MP additional rescue potential",null,null,"Tons of food waste generated",null,null,"MP additional rescue potential"]
[null,null,{"$f":"C58","v":"Grocery Stores and Supermarkets"},null,null,{"$f":"C166","v":"Grocery Stores and Supermarkets"},null,null,{"$f":"Y59+Y63","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB59+AB63","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE59+AE63","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R59+R63","v":0},null,null,{"$f":"U59+U63","v":0}]
[null,null,{"$f":"C93","v":"Other Retail w/ Grocery"},null,null,{"$f":"C167","v":"Other Retail w/ Grocery"},null,null,{"$f":"Y94","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB94","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE94","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R94","v":0},null,null,{"$f":"U94","v":0}]
[null,null,{"$f":"C66","v":" Food Service Providers "},null,null," Food Service Providers ",null,null,{"$f":"Y67","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB67","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE67","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R67","v":0},null,null,{"$f":"U67","v":0}]
[null,null,{"$f":"C70","v":"Food Distributors"},null,null,"Food Distributors",null,null,{"$f":"Y71","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB71","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE71","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R71","v":0},null,null,{"$f":"U71","v":0}]
[null,null,{"$f":"C73","v":"Wholesale Food Vendors"},null,null,"Wholesale Food Vendors",null,null,{"$f":"Y74","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB74","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE74","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R74","v":0},null,null,{"$f":"U74","v":0}]
[null,null,{"$f":"C77","v":"Colleges and Universities "},null,null,"Colleges and Universities ",null,null,{"$f":"Y79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R79","v":0},null,null,{"$f":"U79","v":0}]
[null,null,{"$f":"C81","v":"K-12 Schools (Local Education Agencies)"},null,null,"K-12 Schools (Local Education Agencies)",null,null,{"$f":"Y83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R83","v":0},null,null,{"$f":"U83","v":0}]
[null,null,{"$f":"C85","v":"Hotels   "},null,null,"Hotels   ",null,null,{"$f":"Y86","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB86","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE86","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R86","v":0},null,null,{"$f":"U86","v":0}]
[null,null,{"$f":"C89","v":"Health Care"},null,null,"Health Care",null,null,{"$f":"Y90","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB90","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE90","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R90","v":0},null,null,{"$f":"U90","v":0}]
[null,null,{"$f":"C96","v":"Restaurants"},null,null,"Restaurants",null,null,{"$f":"Y98+Y99","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB98+AB99","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE98+AE99","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R98+R99","v":0},null,null,{"$f":"U98+U99","v":0}]
[null,null,{"$f":"C101","v":"Event and Recreation Facilities"},null,null,"Event and Recreation Facilities",null,null,{"$f":"Y102","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB102","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE102","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R102","v":0},null,null,{"$f":"U102","v":0}]
[null,null,{"$f":"C105","v":"Correctional Facilities (Tier 1 or Tier 2, User to Confirm)"},null,null,"Correctional Facilities (Tier 1 or Tier 2, User to Confirm)",null,null,{"$f":"Y106","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB106","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE106","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R106","v":0},null,null,{"$f":"U106","v":0}]
[null,null,"Other",null,null,"Other",null,null,{"$f":"Y110","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB110","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE110","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R110","v":0},null,null,{"$f":"U110","v":165}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I166:I178)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(L166:L178)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(O166:O178)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(R166:R178)","v":0},null,null,{"$f":"SUM(U166:U178)","v":165}]

{"sheet":"SELECT SECTOR EDIBLE BREAKDOWN","index":4,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,8,2,12],[3,8,3,10],[3,11,3,12],[3,0,4,1],[3,5,3,6],[3,2,3,4],[1,2,2,6]]}
["NEW  APRIL 2022 UPDATE"]
[null,null,"BEGINNING REPORTING YEAR RESULTS: YEAR 2022",null,null,null,null,null,"TARGET REPORTING YEAR RESULTS: YEAR 2024"]
[]
["Percent of All Potentially Donatable Food Waste Disposed to Landfill by Food Type",null,"Disposal Based Results",null,null,"Generation Based Results",null,null,"Disposal Based Results",null,null,"Generation Based Results"]
[null,null,"Estimated pounds of food waste disposed per sector per year","Moderate pounds of additional rescue potential per sector per year","Maximum pounds of rescue potential per sector per year","Upper limit of estimated pounds of food waste that may be disposed per sector per year ","Upper limit pounds of rescue potential per sector per year",null,"Estimated pounds of food waste disposed per sector per year","Moderate pounds of additional rescue potential per sector per year","Maximum pounds of rescue potential per sector per year","Upper limit of estimated pounds of food waste that may be disposed per sector per year ","Upper limit pounds of rescue potential per sector per year"]
["Supermarkets and Grocery Stores*"]
["Vegetative",0.61,{"$f":"$B7*('SUMMARY RESULTS'!$I$59+'SUMMARY RESULTS'!$I$63)*2000","v":0},{"$f":"$B7*('SUMMARY RESULTS'!$L$59+'SUMMARY RESULTS'!$L$63)*2000","v":0},{"$f":"$B7*('SUMMARY RESULTS'!$O$59+'SUMMARY RESULTS'!$O$63)*2000","v":0},{"$f":"$B7*('SUMMARY RESULTS'!$R$59+'SUMMARY RESULTS'!$R$63)*2000","v":0},{"$f":"$B7*('SUMMARY RESULTS'!$U$59+'SUMMARY RESULTS'!$U$63)*2000","v":0},null,{"$f":"C7*'Food Waste Calcs'!$F$55+C7","v":{"$error":"#DIV/0!"}},{"$f":"D7*'Food Waste Calcs'!$F$55+D7","v":{"$error":"#DIV/0!"}},{"$f":"E7*'Food Waste Calcs'!$F$55+E7","v":{"$error":"#DIV/0!"}},{"$f":"F7*'Food Waste Calcs'!$F$55+F7","v":{"$error":"#DIV/0!"}},{"$f":"G7*'Food Waste Calcs'!$F$55+G7","v":{"$error":"#DIV/0!"}}]
["Meat",0.08,{"$f":"$B8*('SUMMARY RESULTS'!$I$59+'SUMMARY RESULTS'!$I$63)*2000","v":0},{"$f":"$B8*('SUMMARY RESULTS'!$L$59+'SUMMARY RESULTS'!$L$63)*2000","v":0},{"$f":"$B8*('SUMMARY RESULTS'!$O$59+'SUMMARY RESULTS'!$O$63)*2000","v":0},{"$f":"$B8*('SUMMARY RESULTS'!$R$59+'SUMMARY RESULTS'!$R$63)*2000","v":0},{"$f":"$B8*('SUMMARY RESULTS'!$U$59+'SUMMARY RESULTS'!$U$63)*2000","v":0},null,{"$f":"C8*'Food Waste Calcs'!$F$55+C8","v":{"$error":"#DIV/0!"}},{"$f":"D8*'Food Waste Calcs'!$F$55+D8","v":{"$error":"#DIV/0!"}},{"$f":"E8*'Food Waste Calcs'!$F$55+E8","v":{"$error":"#DIV/0!"}},{"$f":"F8*'Food Waste Calcs'!$F$55+F8","v":{"$error":"#DIV/0!"}},{"$f":"G8*'Food Waste Calcs'!$F$55+G8","v":{"$error":"#DIV/0!"}}]
["Eggs, Dairy, and Dairy Alternatives",7.0000000000000007E-2,{"$f":"$B9*('SUMMARY RESULTS'!$I$59+'SUMMARY RESULTS'!$I$63)*2000","v":0},{"$f":"$B9*('SUMMARY RESULTS'!$L$59+'SUMMARY RESULTS'!$L$63)*2000","v":0},{"$f":"$B9*('SUMMARY RESULTS'!$O$59+'SUMMARY RESULTS'!$O$63)*2000","v":0},{"$f":"$B9*('SUMMARY RESULTS'!$R$59+'SUMMARY RESULTS'!$R$63)*2000","v":0},{"$f":"$B9*('SUMMARY RESULTS'!$U$59+'SUMMARY RESULTS'!$U$63)*2000","v":0},null,{"$f":"C9*'Food Waste Calcs'!$F$55+C9","v":{"$error":"#DIV/0!"}},{"$f":"D9*'Food Waste Calcs'!$F$55+D9","v":{"$error":"#DIV/0!"}},{"$f":"E9*'Food Waste Calcs'!$F$55+E9","v":{"$error":"#DIV/0!"}},{"$f":"F9*'Food Waste Calcs'!$F$55+F9","v":{"$error":"#DIV/0!"}},{"$f":"G9*'Food Waste Calcs'!$F$55+G9","v":{"$error":"#DIV/0!"}}]
["Cooked/Baked/Prepared Perishable Items",0.18,{"$f":"$B10*('SUMMARY RESULTS'!$I$59+'SUMMARY RESULTS'!$I$63)*2000","v":0},{"$f":"$B10*('SUMMARY RESULTS'!$L$59+'SUMMARY RESULTS'!$L$63)*2000","v":0},{"$f":"$B10*('SUMMARY RESULTS'!$O$59+'SUMMARY RESULTS'!$O$63)*2000","v":0},{"$f":"$B10*('SUMMARY RESULTS'!$R$59+'SUMMARY RESULTS'!$R$63)*2000","v":0},{"$f":"$B10*('SUMMARY RESULTS'!$U$59+'SUMMARY RESULTS'!$U$63)*2000","v":0},null,{"$f":"C10*'Food Waste Calcs'!$F$55+C10","v":{"$error":"#DIV/0!"}},{"$f":"D10*'Food Waste Calcs'!$F$55+D10","v":{"$error":"#DIV/0!"}},{"$f":"E10*'Food Waste Calcs'!$F$55+E10","v":{"$error":"#DIV/0!"}},{"$f":"F10*'Food Waste Calcs'!$F$55+F10","v":{"$error":"#DIV/0!"}},{"$f":"G10*'Food Waste Calcs'!$F$55+G10","v":{"$error":"#DIV/0!"}}]
["Packaged Non-Perishable",0.06,{"$f":"$B11*('SUMMARY RESULTS'!$I$59+'SUMMARY RESULTS'!$I$63)*2000","v":0},{"$f":"$B11*('SUMMARY RESULTS'!$L$59+'SUMMARY RESULTS'!$L$63)*2000","v":0},{"$f":"$B11*('SUMMARY RESULTS'!$O$59+'SUMMARY RESULTS'!$O$63)*2000","v":0},{"$f":"$B11*('SUMMARY RESULTS'!$R$59+'SUMMARY RESULTS'!$R$63)*2000","v":0},{"$f":"$B11*('SUMMARY RESULTS'!$U$59+'SUMMARY RESULTS'!$U$63)*2000","v":0},null,{"$f":"C11*'Food Waste Calcs'!$F$55+C11","v":{"$error":"#DIV/0!"}},{"$f":"D11*'Food Waste Calcs'!$F$55+D11","v":{"$error":"#DIV/0!"}},{"$f":"E11*'Food Waste Calcs'!$F$55+E11","v":{"$error":"#DIV/0!"}},{"$f":"F11*'Food Waste Calcs'!$F$55+F11","v":{"$error":"#DIV/0!"}},{"$f":"G11*'Food Waste Calcs'!$F$55+G11","v":{"$error":"#DIV/0!"}}]
[null,"Total Supermarkets and Grocery Stores",{"$f":"SUM(C7:C11)","v":0},{"$f":"SUM(D7:D11)","v":0},0,0,0,null,{"$f":"SUM(I7:I11)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J7:J11)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"*Assumes to include Supercenters and Warehouse Clubs"]
["Merchant Wholesalers*"]
["Vegetative",0.77,{"$f":"$B15*'SUMMARY RESULTS'!$I$74*2000","v":0},{"$f":"$B15*'SUMMARY RESULTS'!$L$74*2000","v":0},{"$f":"$B15*'SUMMARY RESULTS'!$O$74*2000","v":0},{"$f":"$B15*'SUMMARY RESULTS'!$R$74*2000","v":0},{"$f":"$B15*'SUMMARY RESULTS'!$U$74*2000","v":0},null,{"$f":"C15*'Food Waste Calcs'!$F$55+C15","v":{"$error":"#DIV/0!"}},{"$f":"D15*'Food Waste Calcs'!$F$55+D15","v":{"$error":"#DIV/0!"}},{"$f":"E15*'Food Waste Calcs'!$F$55+E15","v":{"$error":"#DIV/0!"}},{"$f":"F15*'Food Waste Calcs'!$F$55+F15","v":{"$error":"#DIV/0!"}},{"$f":"G15*'Food Waste Calcs'!$F$55+G15","v":{"$error":"#DIV/0!"}}]
["Meat",0,{"$f":"$B16*'SUMMARY RESULTS'!$I$74*2000","v":0},{"$f":"$B16*'SUMMARY RESULTS'!$L$74*2000","v":0},{"$f":"$B16*'SUMMARY RESULTS'!$O$74*2000","v":0},{"$f":"$B16*'SUMMARY RESULTS'!$R$74*2000","v":0},{"$f":"$B16*'SUMMARY RESULTS'!$U$74*2000","v":0},null,{"$f":"C16*'Food Waste Calcs'!$F$55+C16","v":{"$error":"#DIV/0!"}},{"$f":"D16*'Food Waste Calcs'!$F$55+D16","v":{"$error":"#DIV/0!"}},{"$f":"E16*'Food Waste Calcs'!$F$55+E16","v":{"$error":"#DIV/0!"}},{"$f":"F16*'Food Waste Calcs'!$F$55+F16","v":{"$error":"#DIV/0!"}},{"$f":"G16*'Food Waste Calcs'!$F$55+G16","v":{"$error":"#DIV/0!"}}]
["Eggs, Dairy, and Dairy Alternatives",0.06,{"$f":"$B17*'SUMMARY RESULTS'!$I$74*2000","v":0},{"$f":"$B17*'SUMMARY RESULTS'!$L$74*2000","v":0},{"$f":"$B17*'SUMMARY RESULTS'!$O$74*2000","v":0},{"$f":"$B17*'SUMMARY RESULTS'!$R$74*2000","v":0},{"$f":"$B17*'SUMMARY RESULTS'!$U$74*2000","v":0},null,{"$f":"C17*'Food Waste Calcs'!$F$55+C17","v":{"$error":"#DIV/0!"}},{"$f":"D17*'Food Waste Calcs'!$F$55+D17","v":{"$error":"#DIV/0!"}},{"$f":"E17*'Food Waste Calcs'!$F$55+E17","v":{"$error":"#DIV/0!"}},{"$f":"F17*'Food Waste Calcs'!$F$55+F17","v":{"$error":"#DIV/0!"}},{"$f":"G17*'Food Waste Calcs'!$F$55+G17","v":{"$error":"#DIV/0!"}}]
["Cooked/Baked/Prepared Perishable Items",0.09,{"$f":"$B18*'SUMMARY RESULTS'!$I$74*2000","v":0},{"$f":"$B18*'SUMMARY RESULTS'!$L$74*2000","v":0},{"$f":"$B18*'SUMMARY RESULTS'!$O$74*2000","v":0},{"$f":"$B18*'SUMMARY RESULTS'!$R$74*2000","v":0},{"$f":"$B18*'SUMMARY RESULTS'!$U$74*2000","v":0},null,{"$f":"C18*'Food Waste Calcs'!$F$55+C18","v":{"$error":"#DIV/0!"}},{"$f":"D18*'Food Waste Calcs'!$F$55+D18","v":{"$error":"#DIV/0!"}},{"$f":"E18*'Food Waste Calcs'!$F$55+E18","v":{"$error":"#DIV/0!"}},{"$f":"F18*'Food Waste Calcs'!$F$55+F18","v":{"$error":"#DIV/0!"}},{"$f":"G18*'Food Waste Calcs'!$F$55+G18","v":{"$error":"#DIV/0!"}}]
["Packaged Non-Perishable",0.09,{"$f":"$B19*'SUMMARY RESULTS'!$I$74*2000","v":0},{"$f":"$B19*'SUMMARY RESULTS'!$L$74*2000","v":0},{"$f":"$B19*'SUMMARY RESULTS'!$O$74*2000","v":0},{"$f":"$B19*'SUMMARY RESULTS'!$R$74*2000","v":0},{"$f":"$B19*'SUMMARY RESULTS'!$U$74*2000","v":0},null,{"$f":"C19*'Food Waste Calcs'!$F$55+C19","v":{"$error":"#DIV/0!"}},{"$f":"D19*'Food Waste Calcs'!$F$55+D19","v":{"$error":"#DIV/0!"}},{"$f":"E19*'Food Waste Calcs'!$F$55+E19","v":{"$error":"#DIV/0!"}},{"$f":"F19*'Food Waste Calcs'!$F$55+F19","v":{"$error":"#DIV/0!"}},{"$f":"G19*'Food Waste Calcs'!$F$55+G19","v":{"$error":"#DIV/0!"}}]
[null,"Total Wholesalers",{"$f":"SUM(C15:C19)","v":0},{"$f":"SUM(D15:D19)","v":0},{"$f":"SUM(E15:E19)","v":0},{"$f":"SUM(F15:F19)","v":0},{"$f":"SUM(G15:G19)","v":0},null,{"$f":"SUM(I15:I19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J15:J19)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"*Does not include Distributors"]
["Full-Service Restaurants"]
["Vegetative",0.45,{"$f":"$B23*'SUMMARY RESULTS'!$I$98*2000","v":0},{"$f":"$B23*'SUMMARY RESULTS'!$L$98*2000","v":0},{"$f":"$B23*'SUMMARY RESULTS'!$O$98*2000","v":0},{"$f":"$B23*'SUMMARY RESULTS'!$R$98*2000","v":0},{"$f":"$B23*'SUMMARY RESULTS'!$U$98*2000","v":0},null,{"$f":"C23*'Food Waste Calcs'!$F$55+C23","v":{"$error":"#DIV/0!"}},{"$f":"D23*'Food Waste Calcs'!$F$55+D23","v":{"$error":"#DIV/0!"}},{"$f":"E23*'Food Waste Calcs'!$F$55+E23","v":{"$error":"#DIV/0!"}},{"$f":"F23*'Food Waste Calcs'!$F$55+F23","v":{"$error":"#DIV/0!"}},{"$f":"G23*'Food Waste Calcs'!$F$55+G23","v":{"$error":"#DIV/0!"}}]
["Meat",0.33,{"$f":"$B24*'SUMMARY RESULTS'!$I$98*2000","v":0},{"$f":"$B24*'SUMMARY RESULTS'!$L$98*2000","v":0},{"$f":"$B24*'SUMMARY RESULTS'!$O$98*2000","v":0},{"$f":"$B24*'SUMMARY RESULTS'!$R$98*2000","v":0},{"$f":"$B24*'SUMMARY RESULTS'!$U$98*2000","v":0},null,{"$f":"C24*'Food Waste Calcs'!$F$55+C24","v":{"$error":"#DIV/0!"}},{"$f":"D24*'Food Waste Calcs'!$F$55+D24","v":{"$error":"#DIV/0!"}},{"$f":"E24*'Food Waste Calcs'!$F$55+E24","v":{"$error":"#DIV/0!"}},{"$f":"F24*'Food Waste Calcs'!$F$55+F24","v":{"$error":"#DIV/0!"}},{"$f":"G24*'Food Waste Calcs'!$F$55+G24","v":{"$error":"#DIV/0!"}}]
["Eggs, Dairy, and Dairy Alternatives",0,{"$f":"$B25*'SUMMARY RESULTS'!$I$98*2000","v":0},{"$f":"$B25*'SUMMARY RESULTS'!$L$98*2000","v":0},{"$f":"$B25*'SUMMARY RESULTS'!$O$98*2000","v":0},{"$f":"$B25*'SUMMARY RESULTS'!$R$98*2000","v":0},{"$f":"$B25*'SUMMARY RESULTS'!$U$98*2000","v":0},null,{"$f":"C25*'Food Waste Calcs'!$F$55+C25","v":{"$error":"#DIV/0!"}},{"$f":"D25*'Food Waste Calcs'!$F$55+D25","v":{"$error":"#DIV/0!"}},{"$f":"E25*'Food Waste Calcs'!$F$55+E25","v":{"$error":"#DIV/0!"}},{"$f":"F25*'Food Waste Calcs'!$F$55+F25","v":{"$error":"#DIV/0!"}},{"$f":"G25*'Food Waste Calcs'!$F$55+G25","v":{"$error":"#DIV/0!"}}]
["Cooked/Baked/Prepared Perishable Items",0.14000000000000001,{"$f":"$B26*'SUMMARY RESULTS'!$I$98*2000","v":0},{"$f":"$B26*'SUMMARY RESULTS'!$L$98*2000","v":0},{"$f":"$B26*'SUMMARY RESULTS'!$O$98*2000","v":0},{"$f":"$B26*'SUMMARY RESULTS'!$R$98*2000","v":0},{"$f":"$B26*'SUMMARY RESULTS'!$U$98*2000","v":0},null,{"$f":"C26*'Food Waste Calcs'!$F$55+C26","v":{"$error":"#DIV/0!"}},{"$f":"D26*'Food Waste Calcs'!$F$55+D26","v":{"$error":"#DIV/0!"}},{"$f":"E26*'Food Waste Calcs'!$F$55+E26","v":{"$error":"#DIV/0!"}},{"$f":"F26*'Food Waste Calcs'!$F$55+F26","v":{"$error":"#DIV/0!"}},{"$f":"G26*'Food Waste Calcs'!$F$55+G26","v":{"$error":"#DIV/0!"}}]
["Packaged Non-Perishable",0.08,{"$f":"$B27*'SUMMARY RESULTS'!$I$98*2000","v":0},{"$f":"$B27*'SUMMARY RESULTS'!$L$98*2000","v":0},{"$f":"$B27*'SUMMARY RESULTS'!$O$98*2000","v":0},{"$f":"$B27*'SUMMARY RESULTS'!$R$98*2000","v":0},{"$f":"$B27*'SUMMARY RESULTS'!$U$98*2000","v":0},null,{"$f":"C27*'Food Waste Calcs'!$F$55+C27","v":{"$error":"#DIV/0!"}},{"$f":"D27*'Food Waste Calcs'!$F$55+D27","v":{"$error":"#DIV/0!"}},{"$f":"E27*'Food Waste Calcs'!$F$55+E27","v":{"$error":"#DIV/0!"}},{"$f":"F27*'Food Waste Calcs'!$F$55+F27","v":{"$error":"#DIV/0!"}},{"$f":"G27*'Food Waste Calcs'!$F$55+G27","v":{"$error":"#DIV/0!"}}]
[null,"Total Full Service Restaurants",{"$f":"SUM(C23:C27)","v":0},{"$f":"SUM(D23:D27)","v":0},{"$f":"SUM(E23:E27)","v":0},{"$f":"SUM(F23:F27)","v":0},{"$f":"SUM(G23:G27)","v":0},null,{"$f":"SUM(I23:I27)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J23:J27)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Overall Commercial Sector"]
["Vegetative, 54%",0.54,{"$f":"$B30*'SUMMARY RESULTS'!$I$113*2000","v":0},{"$f":"$B30*'SUMMARY RESULTS'!$L$113*2000","v":0},{"$f":"$B30*'SUMMARY RESULTS'!$O$113*2000","v":178200.00000000003},{"$f":"$B30*'SUMMARY RESULTS'!$R$113*2000","v":0},{"$f":"$B30*'SUMMARY RESULTS'!$U$113*2000","v":178200.00000000003},null,{"$f":"C30*'Food Waste Calcs'!$F$55+C30","v":{"$error":"#DIV/0!"}},{"$f":"D30*'Food Waste Calcs'!$F$55+D30","v":{"$error":"#DIV/0!"}},{"$f":"E30*'Food Waste Calcs'!$F$55+E30","v":{"$error":"#DIV/0!"}},{"$f":"F30*'Food Waste Calcs'!$F$55+F30","v":{"$error":"#DIV/0!"}},{"$f":"G30*'Food Waste Calcs'!$F$55+G30","v":{"$error":"#DIV/0!"}}]
["Meat, 8%",0.08,{"$f":"$B31*'SUMMARY RESULTS'!$I$113*2000","v":0},{"$f":"$B31*'SUMMARY RESULTS'!$L$113*2000","v":0},{"$f":"$B31*'SUMMARY RESULTS'!$O$113*2000","v":26400.000000000004},{"$f":"$B31*'SUMMARY RESULTS'!$R$113*2000","v":0},{"$f":"$B31*'SUMMARY RESULTS'!$U$113*2000","v":26400.000000000004},null,{"$f":"C31*'Food Waste Calcs'!$F$55+C31","v":{"$error":"#DIV/0!"}},{"$f":"D31*'Food Waste Calcs'!$F$55+D31","v":{"$error":"#DIV/0!"}},{"$f":"E31*'Food Waste Calcs'!$F$55+E31","v":{"$error":"#DIV/0!"}},{"$f":"F31*'Food Waste Calcs'!$F$55+F31","v":{"$error":"#DIV/0!"}},{"$f":"G31*'Food Waste Calcs'!$F$55+G31","v":{"$error":"#DIV/0!"}}]
["Eggs, Dairy, and Dairy Alternatives, 6%",0.06,{"$f":"$B32*'SUMMARY RESULTS'!$I$113*2000","v":0},{"$f":"$B32*'SUMMARY RESULTS'!$L$113*2000","v":0},{"$f":"$B32*'SUMMARY RESULTS'!$O$113*2000","v":19800},{"$f":"$B32*'SUMMARY RESULTS'!$R$113*2000","v":0},{"$f":"$B32*'SUMMARY RESULTS'!$U$113*2000","v":19800},null,{"$f":"C32*'Food Waste Calcs'!$F$55+C32","v":{"$error":"#DIV/0!"}},{"$f":"D32*'Food Waste Calcs'!$F$55+D32","v":{"$error":"#DIV/0!"}},{"$f":"E32*'Food Waste Calcs'!$F$55+E32","v":{"$error":"#DIV/0!"}},{"$f":"F32*'Food Waste Calcs'!$F$55+F32","v":{"$error":"#DIV/0!"}},{"$f":"G32*'Food Waste Calcs'!$F$55+G32","v":{"$error":"#DIV/0!"}}]
["Cooked/Baked/Prepared Perishable Items, 11%",0.11,{"$f":"$B33*'SUMMARY RESULTS'!$I$113*2000","v":0},{"$f":"$B33*'SUMMARY RESULTS'!$L$113*2000","v":0},{"$f":"$B33*'SUMMARY RESULTS'!$O$113*2000","v":36300},{"$f":"$B33*'SUMMARY RESULTS'!$R$113*2000","v":0},{"$f":"$B33*'SUMMARY RESULTS'!$U$113*2000","v":36300},null,{"$f":"C33*'Food Waste Calcs'!$F$55+C33","v":{"$error":"#DIV/0!"}},{"$f":"D33*'Food Waste Calcs'!$F$55+D33","v":{"$error":"#DIV/0!"}},{"$f":"E33*'Food Waste Calcs'!$F$55+E33","v":{"$error":"#DIV/0!"}},{"$f":"F33*'Food Waste Calcs'!$F$55+F33","v":{"$error":"#DIV/0!"}},{"$f":"G33*'Food Waste Calcs'!$F$55+G33","v":{"$error":"#DIV/0!"}}]
["Packaged Non-Perishable, 21%",0.21,{"$f":"$B34*'SUMMARY RESULTS'!$I$113*2000","v":0},{"$f":"$B34*'SUMMARY RESULTS'!$L$113*2000","v":0},{"$f":"$B34*'SUMMARY RESULTS'!$O$113*2000","v":69300},{"$f":"$B34*'SUMMARY RESULTS'!$R$113*2000","v":0},{"$f":"$B34*'SUMMARY RESULTS'!$U$113*2000","v":69300},null,{"$f":"C34*'Food Waste Calcs'!$F$55+C34","v":{"$error":"#DIV/0!"}},{"$f":"D34*'Food Waste Calcs'!$F$55+D34","v":{"$error":"#DIV/0!"}},{"$f":"E34*'Food Waste Calcs'!$F$55+E34","v":{"$error":"#DIV/0!"}},{"$f":"F34*'Food Waste Calcs'!$F$55+F34","v":{"$error":"#DIV/0!"}},{"$f":"G34*'Food Waste Calcs'!$F$55+G34","v":{"$error":"#DIV/0!"}}]
[null,"Overall Commercial Total",{"$f":"SUM(C30:C34)","v":0},{"$f":"SUM(D30:D34)","v":0},{"$f":"SUM(E30:E34)","v":330000},{"$f":"SUM(F30:F34)","v":0},{"$f":"SUM(G30:G34)","v":330000},null,{"$f":"SUM(I30:I34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J30:J34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Source: "]
["Table 5: Breakdown of Total Potentially Donated Food Waste Disposed by Food Type for from 2018 Generator-Based Waste Characterization Sub-Study for Some Commercial Edible Food Generator Types"]
["Estimating Factors for Edible Food Disposed by Commercial Edible Food Generators",null,null,"Last updated: June 9, 2021","CalRecycle"]
[]
["\"Maximum Pounds of Rescue Potential...\" in Columns E and K are the planning results for purposes of reporting capacity planning. "]
["\"Moderate Pounds of Rescue Potential…\" in Columns D and J represent lower participation and less than maximum amounts of edible food being recovered. "]
[]
["Generation-Based results are hidden in columsn F-G, and L-M. "]
["Note that the percent breakdowns are for landfill disposal, not food waste generation. The actual percent breakdown at the generation level may vary. "]

{"sheet":"Food Waste Calcs","index":5,"n_rows":59,"n_cols":23,"rows_kept":59,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,4],[3,6,3,7],[58,0,58,8]]}
[]
["Food Disposal Estimates by Business Group"]
["*adapted from NRDC's \"City Wasted Food and Rescue Potential Calculator,\" CalRecycle's 2014 Generator Study and some data from CalRecycle's 2021 Guidance Document"]
["Business Group","ENTER DATA HERE",null,"Conversion factor to tons of food waste DISPOSAL (Note 1)",null,"Tons food waste disposed per year","Conversion factor to tons of food waste GENERATION",null,"Tons food waste generated per year"]
["Tier 1 Commercial Edible Food Generators (Note 2)"]
["Grocery Stores and Supermarkets",null,"employees",0.4,null,{"$f":"B6*D6","v":0},1.5443199999999999,null,{"$f":"B6*G6","v":0},null,"Total Employee Conversion",null,"2014 CalRecycle aligns w/ 2021","Assumes existing diversion"]
["Conventional Stores. Do Not Double Count w/ Others Below! "]
["Warehouse Clubs and Supercenters ",null,"employees",{"$f":"D6*0.667","v":0.26680000000000004},null,{"$f":"B8*D8","v":0},{"$f":"G6*0.667","v":1.0300614400000001},null,{"$f":"B8*G8","v":0},null,"Total Employee Conversion",null,"Applied 2/3 Grocery Stores and Supermarkets since warehouse & big box stores are larger and have more employees not necessarily related to food. Lack of data to be able to quantify specifically for a Big Box store or Warehouse Club.",null,null,null,null,null,null,null,null,null,"Assumes existing diversion"]
["Big Box and Warehouse Stores w/ Grocery Sections"]
["Food Service Providers- (3rd Party Sites, Corporate Cafeterias, Banquets, etc.) ",null,"employees (food service employees)",{"$f":"3000/2000","v":1.5},"tons/kitchen employee/year",{"$f":"B10*'Food Waste Calcs'!D10","v":0},{"$f":"3000/2000","v":1.5},"tons/kitchen employee/year",{"$f":"B10*'Food Waste Calcs'!G10","v":0},null,"Applied catering. "]
["Enter Food Service Employees or Facility Employees (not both)",null,"total employees at facility",40,"pounds/employee/year",{"$f":"D11/2000*B11","v":0},40,"pounds/employee/year",{"$f":"G11*B11/2000","v":0},null,"Adapted from NRDC findings "]
[]
["Food Distributors ",null,"employees",{"$f":"47000/18/0.73/2000","v":1.7884322678843227},null,{"$f":"B13*D13","v":0},{"$f":"D13*0.816/0.474","v":3.078820106737568},null,{"$f":"B13*G13","v":0},null,"Total Employee Conversion",null,"2021 CalRecycle","Assumes some existing diversion, applied 2014 CalRecycle generation ratio to diversion"]
[]
["Wholesale Food Vendors",null,"employees",{"$f":"47000/18/0.73/2000","v":1.7884322678843227},null,{"$f":"B15*D15","v":0},{"$f":"D15*0.816/0.474","v":3.078820106737568},null,{"$f":"B15*G15","v":0},null,"Total Employee Conversion",null,"2021 CalRecycle","Assumes some existing diversion, applied 2014 CalRecycle generation ratio to diversion"]
[]
[]
["Tier 2 Commercial Edible Food Generators (Note 2)"]
["Colleges and Universities",null,"FTE employees",0.15313000000000002,"tons/employee/year",{"$f":"D19*B19","v":0},{"$f":"D19","v":0.15313000000000002},"tons/employee/year",{"$f":"G19*B19","v":0},null,"Applied FTE Conversion",null,null,"Assumes little to no existing diversion"]
["If more specific information about food service is known, user may elect to select the other appropriate sector such as Food Service Provider, or Restaurants. "]
["Enter FTE or Students (not both)",null,"students",1.13832,"tons/100 students/year",{"$f":"D21*B21/100","v":0},{"$f":"D21","v":1.13832},"tons/100 students/year",{"$f":"G21*B21/100","v":0}]
[]
[]
["K-12 Schools (Local Education Agencies)",null,"FTE employees",0.15313000000000002,"tons/employee/year",{"$f":"D24*B24","v":0},{"$f":"D24","v":0.15313000000000002},"tons/employee/year",{"$f":"G24*B24","v":0},null,"Applied FTE Conversion",null,null,"Assumes little to no existing diversion"]
["Enter FTE or Students (not both)",null,"students",1.13832,"tons/100 students/year",{"$f":"D25*B25/100","v":0},{"$f":"D25","v":1.13832},"tons/100 students/year",{"$f":"G25*B25/100","v":0}]
[]
["Hotels ",null,"employees",{"$f":"0.46468*0.83","v":0.38568439999999998},"tons/employee/year",{"$f":"B27*D27","v":0},{"$f":"0.49104*0.991","v":0.48662063999999999},"tons/employee/year",{"$f":"B27*G27","v":0},null,"Total Employee Conversion ",null,"Hybrid 2014 CalRecycle/ Cascadia","Assumes some existing diversion"]
["Enter Employees or Rooms (not both)",null,"rooms",{"$f":"D27/1.47","v":0.26237034013605443},"tons/guest room/year",{"$f":"B28*D28","v":0},{"$f":"G27/1.34","v":0.36314973134328354},"tons/guest room/year",{"$f":"B28*G28","v":0},null,"Hybrid 2014 CalRecycle/ Cascadia"]
[null,null,null,null,"tons/employee/year"]
["Health Care",null,"employees",0.12359999999999999,"tons/employee/year",{"$f":"B30*D30","v":0},0.12852,"tons/employee/year",{"$f":"B30*G30","v":0},null,"Total Employee Conversion",null,null,"Assumes little to no existing diversion"]
["Enter Employees or Beds (not both)",null,"beds",0.11963,"tons/bed/year",{"$f":"D31*B31","v":0},{"$f":"D31","v":0.11963},"tons/bed/year",{"$f":"B31*G31","v":0}]
[]
["Other Retail w/ Grocery",null,"employees",0.31383999999999995,null,{"$f":"B33*D33","v":0},0.31556000000000001,null,{"$f":"B33*G33","v":0},null,"Total Employee Conversion",null,null,"Assume existing diversion not significant"]
["Other retail variety stores that sell food"]
[]
["Restaurants "]
["Full Service Restaurants",null,"employees",{"$f":"0.895*1.14","v":1.0203},"tons/employee/year",{"$f":"D37*B37","v":0},{"$f":"0.906*1.15","v":1.0419},"tons/employee/year",{"$f":"G37*B37","v":0},null,"Total Employee Conversion ",null,"Hybrid 2014 CalRecycle/ Cascadia",null,null,null,"Assumes little to no existing diversion"]
["Limited Service Restaurants",null,"employees",{"$f":"0.895*0.859","v":0.76880499999999996},"tons/employee/year",{"$f":"D38*B38","v":0},{"$f":"0.906*0.848","v":0.76828799999999997},"tons/employee/year",{"$f":"G38*B38","v":0},null,"Total Employee Conversion ",null,"Hybrid 2014 CalRecycle/ Cascadia",null,null,null,"Assumes little to no existing diversion"]
["Food Service Sector Subtotal",{"$f":"SUM(B37:B38)","v":0},"employees",null,null,{"$f":"SUM(F37:F38)","v":0},null,null,{"$f":"SUM(I37:I38)","v":0}]
[]
["Event and Recreation Facilities",null,"employees",0.65400000000000003,"tons/employee/year",{"$f":"D41*B41","v":0},0.7014999999999999,"tons/employee/year",{"$f":"G41*B41","v":0},null,"Total Employee Conversion for venues",null,null,"Assumes some existing diversion"]
["Enter employees and annual visitors. Only apply one of the metrics per venue or event.",null,"Visitors",0.14502000000000001,"tons/1000 visitors/year",{"$f":"B42*D42/1000","v":0},0.16165000000000002,"tons/1000 visitors/year",{"$f":"B42*G42/1000","v":0},null,"Assumes visitors at events or venues"]
[]
["Correctional Facilities (Tier 1 or Tier 2, User to Confirm)",null,"Inmates",{"$f":"1*365/2000","v":0.1825},"tons/inmate/year",{"$f":"B44*D44","v":0},{"$f":"D44","v":0.1825},"tons/inmate/year",{"$f":"B44*G44","v":0},null,"Not a CalRecycle business group, using local data from audit of East Mesa. Similar results as NRDC findings. "]
[null,null,null,null," ",null,null," "]
["Other Food Facilities not included above (Tier 1 or Tier 2)"]
["East Mesa Central Production Center ",null,"enter tons/year "]
["East Mesa Detention Facilities ",null,"enter tons/year "]
["Enter Facility Name and Tier 1 or Tier 2",null,"enter tons/year "]
["Enter Facility Name and Tier 1 or Tier 2",null,"enter tons/year "]
["Other Food Facilities subtotal",{"$f":"SUM(B47:B50)","v":0},"subtotal tons/ year",null,null,{"$f":"B51","v":0},null,null,{"$f":"B51","v":0}]
[null,null,null,null,"subtotals",{"$f":"SUM(F6:F51)-F39","v":0},null,null,{"$f":"SUM(I6:I51)-I39","v":0}]
["NEW* Population Projections"]
["Enter Beginning Reporting Year Population (January 1, 2022)",null,"Current Population"]
["Enter Projected Population in Target Year (December 31, 2024)",null,"Target Population",null,"Percent Change in Population",{"$f":"(B55-B54)/B54","v":{"$error":"#DIV/0!"}},"Apply populations from 1/1/18-1/1/21, DOF Data, to represent forecasted projection"]
[]
[]
["(1) Generator disposal metrics applied to reflect little to no curbside diversion (exception is Grocery, Supermarkets, Warehouse Clubs and Supercenters that do backhaul).  Any curbside diversion results for food waste were added back to disposal. "]
["(2) Generators are generally organized by Tier 1 and Tier 2 sector designations, though some generators do not neatly fit into a Tier 1 and Tier 2 sector. User may need to extract or reorganize results to gain an accurate picture of Tier 1 and Tier 2. For example, \"Retail Variety Store\" is not a Tier 1 or Tier 2 generator in itself, nor are \"Colleges and Universities.\" The specific food sectors of Non-Local Entities would need to be used as well. "]

{"sheet":"Rescue Potential Calcs","index":6,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,13,1,15]]}
["Edible Food Recovery Estimates by Business Group"]
["Sectors and Inputs",null,"Disposal Based",null,null,null,null,null,null,"Generation Based",null,null,null,"User can enter their own scenarios here. Results not shown on Summary tab"]
[null,"Needed Input Data","User",null,null,null,null,null,null,"User",null,null,null,"User","User","User"]
[null," ","Input ","Moderate","Moderate","Moderate ","Maximum","Maximum","Maximum","Input ","Maximum","Maximum","Maximum","Scenario","Scenario","Scenario"]
["Sector:",null,"Figure","Donation Metric","Participation Rate","Tons","Donation Metric","Participation Rate","Tons","Figure","Donation Metric","Participation Rate","Tons","Donation Metric","Participation Rate","Tons"]
["Tier 1 Commercial Edible Food Generators"]
["Grocery Stores and Supermarkets (D)","tons food disposed",{"$f":"'Food Waste Calcs'!F6","v":0},0.3,0.8,{"$f":"$C7*D7*E7","v":0},0.3,1,{"$f":"$C7*G7*H7","v":0},{"$f":"'Food Waste Calcs'!I6","v":0},0.3,1,{"$f":"$J7*K7*L7","v":0},0.6,0.9,{"$f":"C7*N7*O7","v":0},null," "]
["Warehouse Clubs and Supercenters (D) (Likely SB1383 Supermarkets)","tons food disposed",{"$f":"'Food Waste Calcs'!F8","v":0},0.3,0.8,{"$f":"$C8*D8*E8","v":0},0.3,1,{"$f":"$C8*G8*H8","v":0},{"$f":"'Food Waste Calcs'!I8","v":0},0.3,1,0,0.6,0.9,0]
["Food Service Providers (G)","tons food disposed",{"$f":"SUM('Food Waste Calcs'!F10:F11)","v":0},0.05,0.5,{"$f":"C9*D9*E9","v":0},0.1,1,{"$f":"C9*G9*H9","v":0},{"$f":"SUM('Food Waste Calcs'!I10:I11)","v":0},0.1,1,{"$f":"J9*K9*L9","v":0},0.04,0.25,{"$f":"C9*N9*O9","v":0}]
["Wholesale Food Vendors (J)","tons food disposed",{"$f":"'Food Waste Calcs'!F15","v":0},0.73,0.5,{"$f":"C10*D10*E10","v":0},0.73,1,{"$f":"C10*G10*H10","v":0},{"$f":"'Food Waste Calcs'!I15","v":0},0.73,1,{"$f":"J10*K10*L10","v":0},0.75,0.25,{"$f":"C10*N10*O10","v":0}]
["Food Distributors (K)","tons food disposed",{"$f":"'Food Waste Calcs'!F13","v":0},0.73,0.5,{"$f":"C11*D11*E11","v":0},0.73,1,{"$f":"C11*G11*H11","v":0},{"$f":"'Food Waste Calcs'!I13","v":0},0.73,1,{"$f":"J11*K11*L11","v":0},0.75,0.25,{"$f":"C11*N11*O11","v":0}]
["Tier 2 Commercial Edible Food Generators"]
["University and Colleges (A)","tons food disposed",{"$f":"SUM('Food Waste Calcs'!F19:F21)","v":0},0.01,0.5,{"$f":"$C13*D13*E13","v":0},0.03,1,{"$f":"$C13*G13*H13","v":0},{"$f":"SUM('Food Waste Calcs'!I19:I21)","v":0},0.03,1,{"$f":"$J13*K13*L13","v":0},0.15,0.7,{"$f":"C13*N13*O13","v":0}," "]
["K-12 (B)","Enter # of students",null,1,0.5,{"$f":"$C14*D14*E14/2000","v":0},4,1,{"$f":"$C14*G14*H14/2000","v":0},{"$f":"C14","v":0},6,1,{"$f":"$J14*K14*L14/2000","v":0},5,1,{"$f":"C14*N14*O14/2000","v":0}]
["Hospitality (C)","tons food disposed",{"$f":"SUM('Food Waste Calcs'!F27:F28)","v":0},0.05,0.5,{"$f":"$C15*D15*E15","v":0},0.1,1,{"$f":"$C15*G15*H15","v":0},{"$f":"SUM('Food Waste Calcs'!I27:I28)","v":0},0.1,1,{"$f":"$J15*K15*L15","v":0},0.06,0.25,{"$f":"C15*N15*O15","v":0}]
["Healthcare (C)","tons food disposed",{"$f":"SUM('Food Waste Calcs'!F30:F31)","v":0},0.05,0.5,{"$f":"$C16*D16*E16","v":0},0.1,1,{"$f":"$C16*G16*H16","v":0},{"$f":"SUM('Food Waste Calcs'!I30:I31)","v":0},0.1,1,{"$f":"$J16*K16*L16","v":0},0.06,0.8,{"$f":"C16*N16*O16","v":0}]
["Other Retail Stores w/ Grocery (E) ","tons food disposed",{"$f":"'Food Waste Calcs'!F33","v":0},0.3,0.5,{"$f":"$C17*D17*E17","v":0},0.5,1,{"$f":"$C17*G17*H17","v":0},{"$f":"'Food Waste Calcs'!I33","v":0},0.5,1,{"$f":"$J17*K17*L17","v":0},0.9,0.6,{"$f":"C17*N17*O17","v":0}]
["FS Restaurants (F)","tons food disposed",{"$f":"'Food Waste Calcs'!F37","v":0},0.03,0.5,{"$f":"$C18*D18*E18","v":0},0.06,1,0,{"$f":"'Food Waste Calcs'!I37","v":0},0.06,1,0,0.1,0.6,0]
["LS Restaurants (F)","tons food disposed",{"$f":"'Food Waste Calcs'!F38","v":0},0.01,0.5,{"$f":"$C19*D19*E19","v":0},0.03,1,0,{"$f":"'Food Waste Calcs'!I38","v":0},0.03,1,0,0.1,0.6,0]
["Events and Recreational Facilities (H)","tons food disposed",{"$f":"SUM('Food Waste Calcs'!F41:F42)","v":0},0.03,0.25,{"$f":"C20*D20*E20","v":0},0.1,1,{"$f":"C20*G20*H20","v":0},{"$f":"SUM('Food Waste Calcs'!I41:I42)","v":0},0.1,1,{"$f":"J20*K20*L20","v":0},0.04,0.25,0]
["Correction Facilities (I). Could be Tier 1 or 2. Confirm. ","Number Inmates",{"$f":"'Food Waste Calcs'!B44","v":0},0.13500000000000001,0.5,{"$f":"C21*1*365*D21*E21/2000","v":0},0.25,1,{"$f":"C21*1*365*G21*H21/2000","v":0},{"$f":"C21","v":0},0.25,1,{"$f":"J21*1*365*K21*L21/2000","v":0},0.04,0.25,0]
[]
["*adapted from NRDC's \"City Wasted Food and Rescue Potential Calculator\""]
["The range of metrics are primarily based on narrative descriptions of food recovery potential from within the body of NRDC's report \"MODELING THE POTENTIAL\nTO INCREASE FOOD RESCUE: DENVER, NEW YORK CITY AND NASHVILLE\""]
["(A) For university and colleges:  Per report descriptives, applied 1% to 3% of food waste may be edible/recoverable. Depends on type of food service provided and whether students live on or off campus. Assumed to include community colleges"]
["(B) K-12 schools: Per report, up to 16% potentially recoverable. Unclear how share tables impact recovery potential. Range is 1 to 4 pounds per student per school year"]
["(C) Hospitality and Healthcare: Per report, 5% to 10% of total food waste may be edible/recoverable"]
["(D) For Grocery, report indicated more than 1/3 of disposed food waste is potentially edible/recoverable. Applied the same for Warehouse Clubs and Supercenters"]
["(E) Other Retail w/ Food- Assume edible food recovery potential is high based on products typically carried (packaged and baked goods, some fresh produce). "]
["(F) Restaurants: Per report, 1% to 3% of food waste may be edible/recoverable. CalRecycle found up to 6% recoverable at Full Service Restaurants."]
["(G) Food Service Providers: Applied 5% to 10% similar to hospitality and healthcare"]
["(H) Events, Venues and Recreation: Assumed 3% to 10% of food waste is edible/recoverable."]
["(I) Per local audit results, where ~ 25% of daily food waste resulted from over-production.  Many of the meals were pre-portioned and packaged. "]
["(J) Wholesale Food Vendors: Per CalRecycle Guidance document 73% of total merchant wholesaler food waste was potentially donatable"]
["(K) Food Distributors: Applied same metrics as Wholesale Food Vendors. Lack of consistent data. "]
["\"Participation rate\" indicates the percentage of all entities within a given sector that are assumed to donate for a given scenario"]
["The maximum scenario is set to 100% participation due to SB 1383 mandating large generators to recover edible food. "]

{"sheet":"Sheet2","index":7,"n_rows":101,"n_cols":13,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
[]
["Name","Non resident","Resident","Total","Location","Founded","Enrollment","References",null,null,null,null,"BON SECOURS HOSPITAL"]
["Coppin State University",null,null,3108,"Baltimore",1900,4357,"[1]","Public 4 year",null,null,null,"(member, Bon Secours Baltimore Health System)"]
["Morgan State University",null,null,7725,"Baltimore",1867,6616,"[2][3][4]","Public 4 year",null,null,null,"2000 West Baltimore St., Baltimore, MD 21223 - 1597"]
["University of Baltimore",6229,null,null,"Baltimore",1925,5009,"[6]","Public 4 year",null,null,null,"(410) 362-3000"]
["University of Maryland, Baltimore",null,null,6329,"Baltimore",1807,5874,"[7]","Public 4 year",null,null,null,"web: http://bonsecoursbaltimore.com/"]
["Johns Hopkins University",null,null,22686,"Baltimore",1876,18753,"[10]","Private ",null,null,null,"GOOD SAMARITAN HOSPITAL OF MARYLAND"]
["Loyola University Maryland",null,null,6050,"Baltimore",1852,6028,"[11]","Private ",null,null,null,"(member, MedStar Health)"]
["Maryland Institute College of Art",null,null,2197,"Baltimore",1826,1899,"[12]","Private ",null,null,null,"5601 Loch Raven Blvd., Baltimore, MD 21239 - 2995"]
["Notre Dame of Maryland University",null,null,2612,"Baltimore",1873,4878,"[13]","Private ",null,null,null,"(443) 444-8000; 1-855-633-5655 (toll free)"]
["Sojourner-Douglass College",null,null,"?","Baltimore",1972,1324,"[14]","Private ",null,null,null,"web: www.medstargoodsam.org/#q={}"]
[]
["All-State Career",599]
["Brightwood College",566,null,null,null,null,null,null,null,null,null,null,"HARBOR HOSPITAL"]
["Hair Design",55,null,null,null,null,null,null,null,null,null,null,"(member, MedStar Health)"]
["Baltimore City Community College",4060,null,null,null,null,null,null,null,null,null,null,"3001 South Hanover St., Baltimore, MD 21225 - 1290"]
["Holistic Massage",28,null,null,null,null,null,null,null,null,null,null,"(410) 350-3200; 1-855-633-0363 (toll free)"]
["Faith Theological",150,null,null,null,null,null,null,null,null,null,null,"web: www.medstarharbor.org/#q={}"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"JOHNS HOPKINS BAYVIEW MEDICAL CENTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(member, Johns Hopkins Health System)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"4940 Eastern Ave., Baltimore, MD 21224 - 2780"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(410) 550-0100"]
[null,null,null,null,null,null,null,null,null,null,null,null,"web: www.hopkinsmedicine.org/johns_hopkins_bayview/"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"THE JOHNS HOPKINS HOSPITAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(member, Johns Hopkins Health System)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"1800 Orleans St., Baltimore, MD 21287 - 0010"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(410) 955-5000"]
[null,null,null,null,null,null,null,null,null,null,null,null,"web: www.hopkinsmedicine.org/the_johns_hopkins_hospital/index.html"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"KENNEDY KRIEGER INSTITUTE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"707 North Broadway, Baltimore, MD 21205 - 1890"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(443) 923-9200; 1-800-873-3377 (toll free)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(443) 923-9400 (local referral); 1-888-554-2080 (toll-free referral)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"e-mail: info@kennedykrieger.org"]
[null,null,null,null,null,null,null,null,null,null,null,null,"web: www.kennedykrieger.org/"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"LEVINDALE HEBREW GERIATRIC CENTER & HOSPITAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(member, LifeBridge Health)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2434 West Belvedere Ave., Baltimore, MD 21215 - 5299"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(410) 601-2400"]
[null,null,null,null,null,null,null,null,null,null,null,null,"web: www.lifebridgehealth.org/Levindale/Levindale2.aspx"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"MERCY MEDICAL CENTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"345 St. Paul Place, Baltimore, Md 21202 - 2165"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(410) 332-9000"]
[null,null,null,null,null,null,null,null,null,null,null,null,"web: https://mdmercy.com/"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"MT. WASHINGTON PEDIATRIC HOSPITAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(affiliate, University of Maryland Medical System & Johns Hopkins Medicine)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"1708 West Rogers Ave., Baltimore, MD 21209 - 4596"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(410) 578-8600"]
[null,null,null,null,null,null,null,null,null,null,null,null,"web: www.mwph.org/"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ST. AGNES HOSPITAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(member, Ascension Health)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"900 Caton Ave., Baltimore, MD 21229 - 5299"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(667) 234-6000"]
[null,null,null,null,null,null,null,null,null,null,null,null,"web: www.stagnes.org/"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"SINAI HOSPITAL OF BALTIMORE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(member, LifeBridge Health)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2401 West Belvedere Ave., Baltimore, MD 21215 - 5271"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(410) 601-9000"]
[null,null,null,null,null,null,null,null,null,null,null,null,"web: www.lifebridgehealth.org/Sinai/Sinai1.aspx"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"UNION MEMORIAL HOSPITAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(member, MedStar Health)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"201 East University Parkway, Baltimore, MD 21218 - 2895"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(410) 554-2000; 1-855-633-0199 (toll free)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"web: www.medstarunionmemorial.org/#q={}"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"UNIVERSITY OF MARYLAND MEDICAL CENTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(formerly Maryland General Hospital)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(member, University of Maryland Medical System)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"22 South Greene St., Baltimore, MD 21201 - 1595"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(410) 328-8667; 1-800-492-5538 (toll free)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"web: http://umm.edu/"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"UNIVERSITY OF MARYLAND MEDICAL CENTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MIDTOWN CAMPUS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(member, University of Maryland Medical System)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"827 Linden Ave., Baltimore, MD 21201 - 4681"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(410) 225-8000"]
[null,null,null,null,null,null,null,null,null,null,null,null,"web: http://ummidtown.org/"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"UNIVERSITY OF MARYLAND"]
[null,null,null,null,null,null,null,null,null,null,null,null,"REHABILITATION & ORTHOPAEDIC INSTITUTE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(formerly James Lawrence Kernan Hospital)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(member, University of Maryland Medical System)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2200 Kernan Drive, Baltimore, MD 21207 - 5597"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(410) 448-2500; 1-888-453-7626 (toll free)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"web: http://umrehabortho.org/"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"VA MARYLAND HEALTH CARE SYSTEM"]
[null,null,null,null,null,null,null,null,null,null,null,null,"10 North Greene St., Baltimore, MD 21201 - 1524"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(410) 605-7000; 1-800-463-6295 (toll free); fax: (410) 605-7901"]
[null,null,null,null,null,null,null,null,null,null,null,null,"web: www.maryland.va.gov/locations/Baltimore_VA_Medical_Center.asp"]

{"sheet":"Lookup","index":8,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
["Sector",null,"School",null,"Hospitality","Sector","School","Healthcare","Correctional"]
["School",null,"College/University nonresident",null,"Hospital","School","College and University","Hospital","Correctional"]
["Correctional",null,"College/University resident",null,"Skilled Nursing","Correctional","Elementary","Nursing home"]
["Event and Recreational",null,"Elementary",null,null,"Event and Recreational","Middle"]
["Food Manufacturing and Processing",null,"Middle",null,null,"Food Manufacturing and Processing","High"]
["Food Service",null,"High",null,null,"Food Service","Elementary/Middle"]
["Food Wholesale and Distribution",null,"Elementary/Middle",null,null,"Food Wholesale and Distribution","Middle/High"]
["Grocers",null,"Middle/High",null,null,"Grocers","K-12"]
["Healthcare",null,"All K-12",null,null,"Healthcare"]
["Hospitality",null,null,null,null,"Hospitality"]