CGS Survey: Regional Roll-Up Template

Survey respondents often ask how they can effectively compile contributions information from multiple regions or departments within their company.  In response, CECP is now providing a dynamic Excel tool to assist survey completers in assembling the necessary information.   Based on an innovative template designed by a member company, the department spreadsheet captures the critical CGS giving data from each office/region.  The master spreadsheet offers a roll-up template to aggregate the responses.

The first tab of both spreadsheets offers guidance and instructions. Please feel free to contact This e-mail address is being protected from spambots. You need JavaScript enabled to view it with any questions on how to use these Excel spreadsheets. While these are designed to be tools to assist giving officers in compiling information, the spreadsheets depend on specific formulas and links to calculate correctly. Please be sure to double check that the spreadsheets are calculating properly and that the functions have remained intact.

> Department Spreadsheet – Distribute to Offices/Regions

> Master Template to Roll-Up Responses