tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 737401d1624395207-help-with-index-and-match-functions-that-act-dynamically-example
Sheet: Refill Staff Cost Savings

 | REFILL MANAGEMENT ROI
 | ANNUAL REFILL VOLUME |  |  | 70791
 | TOTAL # OF PROVIDERS |  |  | 249
 | CENTRALIZED REFILL CENTER
 |  |  |  |  | DAILY | ANNUAL
 | REFILLS PROCESSED |  |  |  |  | 0
 | PROVIDERS SUPPORTED |  |  |  | 150
 | STAFF | % | REFILLS/DAY | MINS/REFILL | FTE | TOTAL COST
 | RN | 0 |  |  | 0
 | CURRENT STATE WITHOUT HEALTHFINCH |  |  |  |  |  | FUTURE STATE WITH HEALTHFINCH
 |  |  |  |  | DAILY | ANNUAL |  |  |  |  | DAILY | ANNUAL
 | REFILLS PROCESSED |  |  |  |  | 538140 | REFILLS PROCESSED |  |  |  |  | 538140
 | STAFF | % | REFILLS/DAY | MINS/REFILL | FTE | TOTAL COST | STAFF | % | REFILLS/DAY | MINS/REFILL | FTE | TOTAL COST
 | MA | 0.13 | 269 | 6 |  |  | MA | 0.13 | 269 | 2
 | LPN | 0.78 | 1614 | 6 |  |  | LPN | 0.78 | 1614 | 2
 | RN | 0.09 | 187 | 6 |  |  | RN | 0.09 | 187 | 2
 | CURRENT STAFF ESTIMATE |  |  |  |  |  | FUTURE STAFF ESTIMATE
 | ESTIMATED DUPLICATE SAVINGS
 | TOTAL # OF DUPLICATES |  |  |  |  |  |  | Average Duplicate Request Rate |  |  |  | 0.15
 | MINUTES SAVED*
 | MINIMUM $ SAVINGS** |  |  |  |  |  |  | *Assuming 5 minutes per request
 |  |  |  |  |  |  |  | ** At [NAME]Future State" Work Rates
 | RETURN ON INVESTMENT SUMMARY
 | Current Staff Costs
 | Future Staffing Costs
 | Duplicate Savings
 | Annual Staff Hours Saved
 | Annual Savings
Spreadsheet: 848167d1698937784-need-help-on-sum-and-indirect-function-combined-sample-file-5-
Sheet: Summary 2

Emp name | Designation | Total Exp in Month | Billing | Per Month ctc in rs. | Per Month CTC in GBP
aakash | Sr exexcutive | 50 | 874.32 | 32000
[NAME] | Sr exexcutive | 25 | 1290.19 | 40000
prajakta | Trainee | 22 | 1312 | 23000
ratan | Sr exexcutive | 24 | 600 | 33000
suresh | Trainee | 4 | 1100 | 17000
mahes | Trainee | 5 | 120 | 15000
[NAME] | Trainee | 4 | 120 | 13500
neena | Sr exexcutive | 3 | 120 | 50000
kapil | Sr exexcutive | 2 | 120 | 30000
Spreadsheet: 2bda9201-ff73-4b09-9709-b8cb1e6d0102
Sheet: Sheet1

COMMUNITY PROJECT/ZONING | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 060763 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Case No. 215-S-16 |  |  | Companion Cases 13590-P and 13590-PD-1
Brief Title |  |  | Approval Deadline |  | Reason
 | Amending the Gashland Area Plan by changing the recommended land use from low density residential to commercial
Details |  |  |  |  | Positions/Recommendations
 | Specific Address |  |  |  | Sponsor | [NAME], Fairfield
 |  |  |  |  |  | Second District
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  | 2nd District
 |  |  |  |  | or Groups |  | (Cooper, Fairfield)
 | Reason for Legislation |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | none known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  |  |  | For
 |  |  |  |  |  |  | X |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  |  |  | oppose change in recommended land use
 |  |  |  |  | Board or |  | City Plan Commission |  |  |  |  |  |  |  | (5-0)    8-15-06
 |  |  |  |  | Commission |  | By |  |  | ([NAME], Graf, Jenks, Macy,
 |  |  |  |  | Recommendation |  | Martin aye, [NAME] recused)
 |  |  |  |  |  |  | X |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  |  |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  |  |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Fact Sheet Prepared By: |  |  | Date:   8-29-06
 | [NAME] |  |  |  | Initial application filed 6-30-2006
 | Planner
Reviewed by: |  |  | Date:   8-29-06
 | [NAME], Manager
 | Development Management
Reference Numbers
 | Case No. 215-S-16 |  |  | Companion Cases 13590-P and 13590-PD-1
Spreadsheet: 58706d1258985547-conditional-formatting-over-2-worksheets-sample
Sheet: PSE

 | Version | Draft 1.0
 | Originator | L.Pritchard
 | Date | 2008-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ref.
 | Duty PSE |  |  |  | Day: | M | T | W | T | F |  | M | T | W | T | F |  | M | T | W | T | F |  | M | T | W | T | F |  | M | T | W | T | F
 | HSD |  |  |  | Date: | 2 | 3 | 4 | 5 | 6 |  | 9 | 10 | 11 | 12 | 13 |  | 16 | 17 | 18 | 19 | 20 |  | 23 | 24 | 25 | 26 | 27
 | April/May |  |  |  | Initials:
 |  | DAILY CHECKS (end of day)
 | 1 | Have the comm cell documents been updated? |  |  |  | ü
 | 2 | Did the comm cell meetings take place? |  |  |  | ü
 | 3 | Are any reasons for over/under achieving captured, documented and communicated (KPI performance / lessons learnt / success register) ? |  |  |  | ü
 | 4 | Are the actions for failing kpi's being progressed to plan? |  |  |  | ü
 | 5 | Are actions in place to resolve comm cell issues (3c's and problem solving being used effectively)? |  |  |  | ü
 | 6 | Are the actions on the 3C's being progressed to plan? |  |  |  | ü
 | 7 | Has the skills matrix been updated? |  |  |  | ü
 | 8 | Have any Back To Work's been completed (if required)? |  |  |  | ü
 | 9 | Are SOP's being adhered to? |  |  |  | ü
 | 10 | Are housekeeping (5S) standards being adhered to? |  |  |  | ü
 | 11 | Agent performance stats produced and published / reviewed against best practice targets |  |  |  | ü
 | 12 | Did the duty PSE follow correct procedures to escalte major incidents? |  |  |  | ü
 |  | CHECKS DURING THE MONTH (Must be complete by end of the month) |  |  |  | ü
 | 2 | Agent call coaching complete |  |  |  | ü
 | 3 | Agent 1-2-1's are complete with updated personal development plans |  |  |  | ü
 | 5 | New processes are documented, communicated and available on HSD One. |  |  |  | ü
 | 9 | Has a Problem Solving session been run to identify Cause, Concern and [NAME] measure and plan to address
 | 10 | For any repeat Concerns, has a check been made to see if solution identified has been successful or has the problem been replicated.
 |  | Area specific
 |  |  |  |  | Yes to Question    = |  |  |  |  |  |  |  |  |  | No to Question   = |  |  |  |  |  |  | X |  | ( transfer to 3C sheet)
 | Remember to move the magnet on the audit board
Spreadsheet: 882013d1730280797-conditional-format-of-zero-numbers-conditional
Sheet: Sheet1

BENZ | 0 | 0 | 0 | 70 | 0 | 0 | 0 | 0 | 1.043478260869565 | 0 | 0 | 122 | 0 | 21 | 0 | 0
BMW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FORD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: elizabeth_sager__9474__Deal Charts
Sheet: Gas

Physical Gas
Deal Ref No | Commodity | Buyer | [NAME] | Trade Date | Start Date | End Date | Daily Volume | Index | Location | Deal Type | Strike | Confirm
QB8206 | NG | PG&E | ENA | 2000-11-27 00:00:00 | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 | 10000 | NGI - Socal | TW - San Juan | forward | -0.99 | Enfolio
Invoice No | Month | Invoice Date | Invoice Due Date | Amount
24153SA | 2001-03-01 00:00:00 | 2001-04-06 00:00:00 | 2001-04-25 00:00:00 | 7750279.91
24154SA | 2001-03-01 00:00:00 | 2001-04-10 00:00:00 | 2001-04-25 00:00:00 | 4233813.88
24155SA | 2001-03-01 00:00:00 | 2001-04-06 00:00:00 | 2001-04-25 00:00:00 | 1841797.69
TEMP_75591 | 2001-03-01 00:00:00 | 2001-04-10 00:00:00 | 2001-04-25 00:00:00 | -1916245
Spreadsheet: 192936d1352638799-3-level-matrix-matrix-artiko-oeldere-
Sheet: Sheet2

Type | [NAME] | ListB | [NAME] |  |  |  | [NAME] |  | Pick ListB |  | Pick ListC
40 | 40 | 40 | 40 |  |  |  | 60 |  | 40
45 | 45 | 45 | 60
50 | 50 | 40 | 30
60 | 50 | 50 | 70
120 | 50 | 50 | 120
 | 60 | 40 | 30
 | 60 | 40 | 40
 | 60 | 50 | 90
 | 60 | 50 | 120
 | 120 | 80 | 80
if I choose for H2=60 and J2=40 L2= should return in dropdown list 30 and 40 (exactly how B7=60, C7=40, D7=30 D8=40)
Please accept my Apologize if i'm not so clear, my language is not English!!
thank you
Spreadsheet: 806582d1669393099-filter-date-bounded-between-two-ranges-test-date66
Sheet: Sheet2

 |  | start date | end date
 |  | 2022-11-26 00:00:00 | 2022-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | output
 | 2022.11.24 | 2022.11.25 | 2022.11.26 | 2022.11.27 | 2022.11.28 | 2022.11.29 | 2022.11.30 | 2022.12.01 | 2022.12.02 |  | 2022.11.26 | 2022.11.27 | 2022.11.28 | 2022.11.29 | 2022.11.30 | 2022.12.01
 | 3 | 4 | 0 | 2 | 0 | 3 | 8 | 9 | 13 |  | 0 | 2 | 0 | 3 | 8 | 9
 | 6 | 13 | 20 | 27 | 34 | 41 | 48 | 55 | 62 |  | 20 | 27 | 34 | 41 | 48 | 55
 | 6 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 |  | 56 | 56 | 56 | 56 | 56 | 56
 | 8 | 33 | 58 | 83 | 108 | 133 | 158 | 183 | 208 |  | 58 | 83 | 108 | 133 | 158 | 183
 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  | 9 | 9 | 9 | 9 | 9 | 9
Spreadsheet: 149014d1333648857-vlookup-to-return-column-header-name-draft2
Sheet: SUMMARY

 | Search User's Information
 | Enter 7 Digits Employee # | 5200309
 | User's Basic Information
 | Name: | BAINES, ROLTO
 | LAN ID: | RBAINES
 | Mainframe ID: | 0
 | Adjuster ID: | 0
 | Status: | Active
 | Job Code: | 29001
 | CBD Code: | 1111-2356-3000
 | Team: | PC
 | Applications: | I need all applications to be presented here. |  | the raw data range is upto row 700
Spreadsheet: 877217d1723947124-fully-automatic-seating-plan-exam-hall-for-various-group-input
Sheet: 5th bba

S. No | Register No | Student Name
1 | 127118001 | Adhi
2 | 127118002 | Akhi
3 | 127118003 | Akul
4 | 127118004 | [NAME]
5 | 127118005 | [NAME]
6 | 127118006 | Apar
7 | 127118007 | Arvi
8 | 127118008 | Banu
9 | 127118009 | Basi
10 | 127118010 | Brin
11 | 127118011 | Dhan
12 | 127118012 | Gudi
13 | 127118013 | [NAME]
14 | 127118014 | [NAME]
15 | 127118015 | King
16 | 127118016 | G La
17 | 127118017 | Madu
18 | 127118018 | Mait
19 | 127118019 | Nand
20 | 127118020 | Padm
21 | 127118021 | Pooj
22 | 127118022 | Priy
23 | 127118023 | Ragh
24 | 127118024 | Shah
25 | 127118025 | Shum
26 | 127118026 | Smri
27 | 127118027 | Srin
28 | 127118028 | Swar
29 | 127118029 | Tanu
30 | 127118030 | Veen
31 | 127118031 | Vidy
32 | 127118032 | Vign
33 | 127118033 | Vyas
Spreadsheet: 146491d1332207905-populate-new-file-with-multiple-excel-files-sample-invoice
Sheet: Sheet1

 |  |  |  |  | Invoice
 |  |  |  |  | Date
Name |  |  |  | Phone
 |  |  |  | Cell
Street |  |  |  | Work
City
State
Zip
Room | Material | Style | Color | Length | [NAME] | Yards | Pad
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  | Total: | 0
Transitions |  | Custom |  | Other
Quantity | Type
 |  |  |  |  | Amount Due
 |  |  |  |  | Materials | 0
 |  |  |  |  | Labor | 0
 |  |  |  |  | Total | 0
Spreadsheet: 4b21f7e0-e782-435d-aab5-7e4b54907df9
Sheet: Hollister

REGIONAL DIRECTORY 2014/2015
HOLLISTER ELEMENTARY SCHOOL DISTRICT
Dr. [NAME], [NAME] | [NAME], Director of Ed Services | [NAME],Accountant
2690 Cienega Road | 2690 Cienega Road | 2690 Cienega Road
Hollister, CA 95023 | Hollister, CA 95023 | Hollister, CA 95023
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [EMAIL]
[NAME], MEP Coordinator | [NAME], MEP Secretary/Health | TBD, [NAME]
2690 Cienega Road | 2690 Cienega Road | 2690 Cienega Road
Hollister, CA 95023 | Hollister, CA 95023 | Hollister, CA 95023
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL]
[NAME], [NAME] | [NAME], [NAME] | [NAME], [NAME]
2690 Cienega Road | 2690 Cienega Road | 2690 Cienega Road
Hollister, CA 95023 | Hollister, CA 95023 | Hollister, CA 95023
O: [PHONE] or 636-4420 | O: [PHONE] or 636-4450 | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [EMAIL]
[NAME], MEP Intervention Specialist | [NAME], Preschool Specialist | [NAME], Preschool Specialist
2690 Cienega Road | 881 Line Street | 1475 Memorial Drive
Hollister, CA 95023 | Hollister, CA 95023 | Hollister, CA 95023
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [EMAIL]
Krystal Meza, Preschool Specialist | TBD, Preschool Aide | [NAME], Preschool Aide
1011 Line Street | 881 Line Street | 1011 Line Street
Hollister, CA 95023 | Hollister, CA 95023 | Hollister, CA 95023
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [EMAIL]
[NAME], Preschool Aide
1475 Memorial Drive
Hollister, CA 95023
O: [PHONE]
F: [PHONE]
Spreadsheet: mark_haedicke__24600__105655 - O&M 053101
Sheet: Headcount - 105657

 | ENRON NORTH AMERICA
 | CC 105657
 | HEADCOUNT AS OF 05-31-01
EMPLOYEE |  |  | TOTAL
BAILEY,[NAME] |  | hOther Non-Commercial | 1
[NAME], SAMANTHA |  | hOther Non-Commercial | 1
COOK, MARY |  | hOther Non-Commercial | 1
GONZALEZ, ESMERALDA |  | hOther Non-Commercial | 1
GREENBERG, MARK |  | hOther Non-Commercial | 1
HEARD, MARIE |  | hOther Non-Commercial | 1
HENDRY, BRENT |  | hOther Non-Commercial | 1
JONES,TANA L |  | hOther Non-Commercial | 1
KEISER, HOLLY |  | hOther Non-Commercial | 1
KOEHLER, ANNE |  | hOther Non-Commercial | 1
NELSON, CHERYL |  | hOther Non-Commercial | 1
PANUS, STEPHANIE |  | hOther Non-Commercial | 1
PINTO-LEITE, FRANCISCO |  | hOther Non-Commercial | 1
SAYRE, FRANK |  | hOther Non-Commercial | 1
SHACKLETON,SARA |  | hOther Non-Commercial | 1
SPENCER, REBECCA |  | hOther Non-Commercial | 1
TAYLOR,MARK E |  | hOther Non-Commercial | 1
ZUCHA, THERESA |  | hOther Non-Commercial | 1
Spreadsheet: 106058d1303298556-duplicate-text-add-data-to-correct-column-or-add-new-row-excelquery
Sheet: Sheet1

1. | initial data | Text | Week 1
 |  | xxx | 4
 |  | yyy | 5
 |  | zzz | 6
 |  |  | Week 1 | Week 2 | Week 3
2. | first week | Text
 |  | xxx | 4
 |  | yyy | 5
 |  | zzz | 6
3. | second weeks data | Text | Week 2
 |  | xxx | 7
 |  | aaa | 8
 |  | bbb | 9
4. | ideal output |  | Week 1 | Week 2 | Week 3
 |  | Text
 |  | xxx | 4 | 7
 |  | yyy | 5
 |  | zzz | 6
 |  | aaa |  | 8
 |  | bbb |  | 9
Spreadsheet: 796467d1663294296-formula-for-min-date-that-shows-5-times-with-2-conditions-examplebook2
Sheet: Sheet1

 | Physical Stores
 | Store | Work Type | Oldest Date |  | Working Days | Total Volume | INDICATOR
 | Houston | Priority 1 |  |  |  |  |  |  |  |  |  | Houston_1 | P1
Current |  | All Other Priority |  |  |  |  | N/A
 |  | Emails
 | New York | Priority 1 |  |  |  |  |  |  |  |  |  | NewYork_1 | P1
 |  | All Other Tasks |  |  |  |  | N/A
 |  | Emails
 | Physical Stores
 | Store | Work Type | Oldest Date |  | Working Days | Total Volume | INDICATOR
 | Houston | Priority 1 | 2022-09-13 00:00:00
Ideal |  | All Other Priority | 2022-08-29 00:00:00 |  |  |  | N/A
 |  | Emails
 | New York | Priority 1 | 2022-09-14 00:00:00
 |  | All Other Tasks |  |  |  |  | N/A
 |  | Emails
Spreadsheet: 587385d1534995708-duplicates-duplicates-in-3-columns-using-helper
Sheet: Sheet1

A | B | C | Helper
 |  |  |  |  | Use a Helper column which concatinates all columns
 |  |  |  |  | Then use Conditional Formatting to find duplicates
 |  |  |  |  | Press F9 a few times to generate more random numbers and see my results
 |  |  |  |  | Duplicates will be in red background
Spreadsheet: 274979d1383301749-sumproduct-indirect-array-containing-both-ors-and-ands-example
Sheet: example1

 | THIS WOULD BE THE IDEAL TABLE CONFIGURATION |  |  |  |  |  |  |  |  |  |  | BUT THIS IS HOW I ENDED UP CREATING THE TABLE FOR THE SUMPRODUCT
 | OR |  |  |  | AND | AND | Result of Values that meet criteria to be included in INDIRECT TEST sumproduct |  |  |  |  | OR 1 |  | OR 2 |  | OR 3 |  | OR 4 |  | AND | AND | Result of Values that meet criteria to be included in INDIRECT TEST sumproduct
 | 11111 | 22222 | ABCDE | 99999 | YEAR | Random Number |  |  |  |  |  |  |  |  |  |  |  |  |  | YEAR | Random Number
 | 0 | 0.6 | 0 | 0 | 2016 | 100 |  |  |  |  |  | 11111 | 0 | 22222 | 0.6 | ABCDE | 0 | 99999 | 0 | 2016 | 100
 | 0.5 | 0 | 0 | 0 | 2017 | 300 | 150 |  |  |  |  | 11111 | 0.5 | 22222 | 0 | ABCDE | 0 | 99999 | 0 | 2017 | 300 | 150
 | 0 | 0 | 0.4 | 0 | 2014 | 400 |  |  |  |  |  | 11111 | 0 | 22222 | 0 | ABCDE | 0.4 | 99999 | 0 | 2014 | 400
 | 0 | 0.4 | 0 | 0 | 2017 | 600 | 0 |  |  |  |  | 11111 | 0 | 22222 | 0.4 | ABCDE | 0 | 99999 | 0 | 2017 | 600 | 0
 | 0 | 0 | 0 | 0.5 | 2017 | 300 | 0 |  |  |  |  | 11111 | 0 | 22222 | 0 | ABCDE | 0 | 99999 | 0.5 | 2017 | 300 | 0
 | 1 | 0 | 0 | 0 | 2018 | 50 |  |  |  |  |  | 11111 | 1 | 22222 | 0 | ABCDE | 0 | 99999 | 0 | 2018 | 50
 | 0 | 0 | 0.5 | 0 | 2014 | 350 |  |  |  |  |  | 11111 | 0 | 22222 | 0 | ABCDE | 0.5 | 99999 | 0 | 2014 | 350
 | 0 | 0.5 | 0 | 0 | 2012 | 4000 |  |  |  |  |  | 11111 | 0 | 22222 | 0.5 | ABCDE | 0 | 99999 | 0 | 2012 | 4000
 | 0.4 | 0 | 0 | 0 | 2017 | 1000 | 400 |  |  |  |  | 11111 | 0.4 | 22222 | 0 | ABCDE | 0 | 99999 | 0 | 2017 | 1000 | 400
 | 0 | 0 | 0.4 | 0 | 2014 | 1000 |  |  |  |  |  | 11111 | 0 | 22222 | 0 | ABCDE | 0.4 | 99999 | 0 | 2014 | 1000
 | 0 | 0 | 0 | 0 | 2013 | 2013 |  |  |  |  |  | 11111 | 0 | 22222 | 0 | ABCDE | 0 | 99999 | 0 | 2013 | 2013
 | 0 | 0 | 0.8 | 0 | 2015 | 400 |  |  |  |  |  | 11111 | 0 | 22222 | 0 | ABCDE | 0.8 | 99999 | 0 | 2015 | 400
 | 0 | 0 | 0.4 | 0 | 2014 | 600 |  |  |  |  |  | 11111 | 0 | 22222 | 0 | ABCDE | 0.4 | 99999 | 0 | 2014 | 600
 | 0.2 | 0 | 0 | 0 | 2013 | 300 |  |  |  |  |  | 11111 | 0.2 | 22222 | 0 | ABCDE | 0 | 99999 | 0 | 2013 | 300
 | 0 | 0 | 0 | 0.4 | 2015 | 800 |  |  |  |  |  | 11111 | 0 | 22222 | 0 | ABCDE | 0 | 99999 | 0.4 | 2015 | 800
 | 0 | 0 | 0 | 0.3 | 2017 | 600 | 0 |  |  |  |  | 11111 | 0 | 22222 | 0 | ABCDE | 0 | 99999 | 0.3 | 2017 | 600 | 0
 | 0 | 0 | 0 | 0.2 | 2013 | 600 |  |  |  |  |  | 11111 | 0 | 22222 | 0 | ABCDE | 0 | 99999 | 0.2 | 2013 | 600
 | 0 | 0 | 0.4 | 0 | 2015 | 600 |  |  |  |  |  | 11111 | 0 | 22222 | 0 | ABCDE | 0.4 | 99999 | 0 | 2015 | 600
 | 0 | 0.5 | 0 | 0 | 2018 | 4 |  |  |  |  |  | 11111 | 0 | 22222 | 0.5 | ABCDE | 0 | 99999 | 0 | 2018 | 4
 | Blue cells meet criteria within sumproduct but green is whole rows that meet all criteria on Overview sheet
Spreadsheet: 101847d1299877273-populating-a-summary-table-schedule-problem
Sheet: Sheet1

 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | TITLE 1 |  |  |  | 1 | 1 | 1
 |  | A | 2
 |  | D | 1
 |  | G | 1
 |  | TITLE 2 |  |  |  |  |  |  |  | 1 | 1
 |  | B | 1
 |  | C | 1
 |  | TITLE 3 |  |  | 1 | 1 | 1
 |  | H | 1
 |  | K | 1
 |  | P | 1
 |  | TITLE 4 |  |  |  |  | 1 | 1 | 1 | 1
 |  | A | 1
 |  | B | 2
 |  | K | 1
 |  | END RESULT NEEDED
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | F
 |  | G
 |  | H
 |  | I
 |  | J
 |  | K
 |  | L
 |  | M
 |  | N
 |  | O
 |  | P
Spreadsheet: rick_buy__32843__Summary Oct 08
Sheet: summary 0904

SUMMARY BY WEEK FOR  09/04-09/07
TOTAL ISSUES
Category |  | Description
A |  | Deal Capture
B |  | Deal Valuation
C |  | Breakdown in Officializing Process- Human
D1 |  | Breakdown in Officializing Process- IT (UK)
D2 |  | Breakdown in Officializing Process- IT (US)
E |  | Curve Issues
F |  | Uncontrollable-System Needs to Change
G |  | Miscellaneous
H |  | Not identified
Breakdown By Group |  |  |  |  |  |  |  | # of Issues |  | Biggest Problem
EIM
EGM
EEL
EA-CAN
EA - GAS
EA - POWER
EES
EBS
Other
TOTAL ISSUES
Spreadsheet: 59377d1259862698-countif-total-and-percentage-datasheet
Sheet: Sheet2

Location | Eastern Region Teams | National Team Rank in Scoring Offense
Connecticut | Connecticut | 11
North Carolina | North Carolina | 13
Indiana | Notre Dame | 13
South Carolina | Charleston So. | 15
Virginia | Virginia | 17
Florida | Miami (FL) | 18
New York | St. John's (NY) | 21
Illinois | [NAME] | 22
New York | Syracuse | 27
Florida | Florida St. | 35
Virginia | [NAME] | 38
Ohio | Xavier | 40
Maryland | Maryland | 44
North Carolina | Duke | 47
Pennsylvania | Duquesne | 49
Vermont | Vermont | 53
District of Columbia | Georgetown | 55
Rhode Island | Providence | 62
Massachusetts | Boston College | 66
Virginia | VCU | 68
Tennessee | Louisville | 70
North Carolina | North Carolina St. | 75
Pennsylvania | Pittsburgh | 81
Maryland | UMBC | 88
Virginia | [NAME] | 91
Massachusetts | Harvard | 91
New York | Cornell | 91
North Carolina | Gardner-Webb | 96
New Jersey | Princeton | 100
New York | Marist | 107
Georgia | Georgia St. | 107
Ohio | Dayton | 115
Pennsylvania | Lehigh | 116
Connecticut | [NAME] | 116
New York | Long Island | 122
West Virginia | West Virginia | 122
South Carolina | Clemson | 122
Massachusetts | Northeastern | 126
North Carolina | Wake Forest | 131
Virginia | Liberty | 133
New York | Manhattan | 136
North Carolina | Coastal Caro. | 139
Florida | South Fla. | 149
North Carolina | High Point | 151
Pennsylvania | Temple | 155
North Carolina | UNC Asheville | 166
Connecticut | Hartford | 168
New York | [NAME] | 170
New York | Boston U. | 175
West Virginia | Rutgers | 175
New York | Columbia | 179
New York | [NAME] | 181
New York | Wagner | 186
New York | St. Bonaventure | 186
District of Columbia | American | 189
New York | Hofstra | 195
Wisconsin | Marquette | 196
Virginia | William & Mary | 196
Delaware | Delaware | 196
District of Columbia | [NAME] | 200
Georgia | Georgia Tech | 205
Ohio | Cincinnati | 206
Connecticut | Fairfield | 210
Pennsylvania | [NAME] | 211
Connecticut | St. Joseph's | 215
Pennsylvania | Drexel | 215
New York | Colgate | 215
Missouri | St. Louis | 218
North Carolina | [NAME] | 218
New York | Iona | 225
Massachusetts | Massachusetts | 228
New Jersey | [NAME] | 228
New York | Albany (NY) | 235
Connecticut | Yale | 238
New Jersey | St. Peter's | 238
Pennsylvania | Bucknell | 243
New York | Quinnipiac | 244
Virginia | Richmond | 248
North Carolina | Charlotte | 252
USA | Navy | 253
Rhode Island | [NAME] | 264
New Hampshire | New Hampshire | 268
Pennsylvania | St. Francis (PA) | 270
Connecticut | Central Conn. St. | 274
New Jersey | [NAME] | 280
District of Columbia | [NAME] | 283
New York | Siena | 285
New Jersey | NJIT | 287
Maine | Maine | 290
Louisiana | Loyola (MD) | 291
Maryland | Towson | 293
Virginia | Old Dominion | 293
New York | [NAME] | 293
New Jersey | Rider | 301
New York | [NAME] | 306
New York | Canisius | 308
USA | Army | 311
Rhode Island | Holy Cross | 314
Pennsylvania | [NAME] | 315
Pennsylvania | Villanova | 320
New York | Mt. St. Mary's | 323
New Jersey | Monmouth | 324
New York | Rhode Island | 324
New York | St. Francis (NY) | 327
North Carolina | Winthrop | 329
New Hampshire | Dartmouth | 330