Spreadsheet: 742075d1627503488-virtual-pivot-table-example-grading-for-excelforum
Sheet: Sheet1

 |  |  |  |  | Rating | Code
 |  |  |  |  | Satisfactory | 1
 |  |  |  |  | Requires Attention | 2
 |  |  |  |  | Priority Item | 3
Section 2
 |  |  |  |  | Focus Area | Rating |  |  |  |  | Yes | No | Weekly | Bi-Weekly | Semi-Monthly | Monthly | As Needed | Payroll Check | Separate Check |  | Results for Current Answers
Sales Tax Groups Used | No |  |  |  | Focus Area 1 |  |  |  |  |  | 2 | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | Select Option | Yes | No
What is your Payroll Cycle? | Semi-Monthly |  |  |  | Focus Area 2 |  |  |  |  |  |  |  | If T&E Periods = Weekly, 1, else 3 | If T&E Periods = Weekly or Bi-Weekly, 1, else 3 | If T&E Periods = Semi-Monthly, 1, else 3 | If T&E Periods = Semi-Monthly or Monthly, 1, else 3 |  |  |  |  | 3 |  |  |  |  | Select Option | Weekly | Bi-Weekly | Semi-Monthly | Monthly
T&E Periods | Weekly |  |  |  | Focus Area 3 |  |  |  |  |  |  |  | If Payroll Cycle = Weekly or Bi-Weekly, 1, else 3 | If Payroll Cycle = Bi-Weekly, 1, else 3 | If Payroll Cycle = Semi-Monthly or Monthly, 1, else 3 | If Payroll Cycle = Monthly, 1, else 3 |  |  |  |  | 3 |  |  |  |  | Select Option | Weekly | Bi-Weekly | Semi-Monthly | Monthly
Invoice Emails in HTML Format | No |  |  |  | Focus Area 4 |  |  |  |  |  | 1 | 2 |  |  |  |  |  |  |  |  | 2 |  |  |  |  | Select Option | Yes | No
[NAME] Separately | No |  |  |  | Focus Area 5 |  |  |  |  |  | 2 | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | Select Option | Yes | No
[NAME] After Closed | Yes |  |  |  | Focus Area 6 |  |  |  |  |  | If T&E Periods = Weekly or Bi-Weekly, 1, else 3 | If T&E Periods = Semi-Monthly or Monthly, 1, else 3 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | Select Option | Yes | No
[NAME] | Yes |  |  |  | Customer Invoicing | 2 |  |  |  |  | If T&E Periods = Semi-Monthly or Monthly, 1, else 3 | If T&E Periods = Weekly or Bi-Weekly, 1, else 3 |  |  |  |  |  |  |  |  | 3 |  |  |  |  | Select Option | Yes | No
Frequency of S & P Invoicing | Weekly |  |  |  | Focus Area 8 |  |  |  |  |  |  |  | If T&E Periods = Weekly, 1, else 3 | If T&E Periods = Weekly or Bi-Weekly, 1, else 3 | If T&E Periods = Semi-Monthly, 1, else 3 | If T&E Periods = Semi-Monthly or Monthly, 1, else 3 |  |  |  |  | 1 |  |  |  |  | Select Option | Weekly | Bi-Weekly | Semi-Monthly | Monthly
Frequency of Product Invoicing | As Needed |  |  |  | Focus Area 9 |  |  |  |  |  |  |  | If Frequency of S & P Invoicing = Weekly, 1, else 3 | If Frequency of S & P Invoicing = Bi-Weekly, 1, else 3 | If Frequency of S & P Invoicing = Semi-Monthly, 1, else 3 | If Frequency of S & P Invoicing = Monthly, 1, else 3 | 1 |  |  |  | 1 |  |  |  |  | Select Option | Weekly | Bi-Weekly | Semi-Monthly | Monthly | As Needed
Do you use Expenses | Yes |  |  |  | Focus Area 10 |  |  |  |  |  | 1 | 2 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | Select Option | Yes | No
How are expenses reimbursed | Separate Check |  |  |  | Focus Area 11 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | 2 |  |  |  |  | Select Option | Payroll Check | Separate Check
Frequency of expense reimbursement, if paid with Separate Check | Monthly |  |  |  | Section Rating |  |  |  |  |  |  |  | 3 | 3 | 3 | 1 |  |  |  |  | 1 |  |  |  |  | Select Option | Weekly | Bi-Weekly | Semi-Monthly | Monthly
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average |  | <= This goes in G14