Cleaning environment, removing graphs and setting the required libraries:

Connecting to google sheets and extracting the information from each one of the tabs separate dataframes:

## [1] 1

FOOD BOXES ORDERED TAB:

Data formatting:

## Reading layer `Zip_Codes' from data source `D:\Respaldo Pablo\Upwork\SacCollab\SacCollab\Zip_Codes.shp' using driver `ESRI Shapefile'
## Simple feature collection with 63 features and 5 fields
## geometry type:  MULTIPOLYGON
## dimension:      XY
## bbox:           xmin: 6601073 ymin: 1768501 xmax: 6840876 ymax: 2030220
## projected CRS:  NAD83 / California zone 2 (ftUS)

Daily stats Number of People per client household bar chart:

Cumulative stats Number of People per client household bar chart

Cumulative stats map:total number of people per client household

Creating a dataframe with the relevant information: Data from google sheets +shapefile of Sacramento County divided by zipcodes

FAMILY MEALS ORDERED TAB:

Data formatting:

Daily stats-Number of family meals ordered-bar chart

Daily stats-Family meal boxes per client household-bar chart

Daily stats -Client Househod Size & Number of Individual Family Meals per Client Household

Cumulative stats-Total number of family meals ordered -bar chart

Cumulative stats-Total number of family meal boxes per client household -bar chart

Cumulative stats -Client Househod Size & Number of Individual Family Meals per Client Household

Map: total Total number of family meals ordered

Map: total Total number of family meals ordered

DOORDASH TAB:

Daily stats -Number of DoorDash deliveries -bar chart

Daily stats -Money spent on DoorDash deliveries -bar chart

Cumulative stats -Number of DoorDash deliveries -bar chart

Cumulative stats -Money spent on DoorDash deliveries -bar chart

Map: total Total USD spent on DoorDash deliveries by zip code:

RALEY’S TAB:

Daily stats -Number of Raley’s orders -bar chart

Daily stats -Money spent on Raley’s orders -bar chart

Cumulative stats -Number of Raley’s orders -bar chart

Cumulative stats -Money spent on Raley’s orders -bar chart

Cumulative Map , Money spent on raley’s orders by zip code:

HEALTHCARE/CALFRESH TAB:

Daily stats -Number of services requested -bar chart

Cumulative stats - Total number of services requested -bar chart

Cumulative stats -Total number of requested services divided by type-Pie chart

UNITED WAY FINANCIAL ASSISTANCE TAB:

Daily stats Number of services requested bar chart

Daily stats amount of United Way Financial Assistance requested

Cumulative stats Number of services requested bar chart

Cumulative stats total amount requested bar chart

Cumulative Map , Amount of money requested by zip code

Cumulative stats, reason for the request, donut chart

UNITED WAY + CBO FINANCIAL ASSISTANCE TAB:

Daily stats Number of services requested bar chart

Daily stats amount of United Way + CBO Financial Assistance requested

Cumulative stats Number of services requested bar chart

Cumulative stats total amount requested bar chart

Cumulative Map , Amount of money requested by zip code

Cumulative stats, reason for the request, donut chart

HER HEALTH FIRST PREGNANCY TAB:

Daily stats Number of services requested bar chart:

Cumulative stats Number of services provided

Cumulative Map ,Number of services provided by zip code

Parenting families and childrens with ages under 1

MENTAL HEALTH TAB:

Daily stats Number of mental health services by type provided bar chart:

Cumulative stats Number of mental health services by type provided bar chart:

Cumulative Map Number of mental health services by type provided bar chart:

UNITED WAY FII ISSUED BY ARI TAB:

Daily stats amount provided bar chart

Cumulative stats amount provided bar chart

Reasons for Financial Assistance Donut Chart

Ethnicity distribution of clients Donut Chart

Cumulative Map Amount provided by zip code

ONBOARDING TAB:

Daily stats number of clients by organization bar chart

Cumulative stats number of clients by organization bar chart