tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 798407d1664464450-excel-calculate-working-days-between-2-dates-monthly-workday-absence-per-month-
Sheet: Working days

 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Bank Holidays: |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | New Year's Day | 2022-01-03 00:00:00 |  |  |  | Start date | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
 | Good Friday | 2022-04-15 00:00:00 |  |  |  | End date | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00
 | Easter Monday | 2022-04-18 00:00:00 |  |  |  | Working days
 | Early May bank holiday | 2022-05-02 00:00:00
 | Spring bank holiday | 2022-06-02 00:00:00 |  |  | Date of absence
 | Platinum Jubilee bank holiday | 2022-06-03 00:00:00 |  |  | Start | End | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total
 | Summer bank holiday | 2022-08-29 00:00:00 |  | [NAME] | 2022-01-10 00:00:00 | 2022-05-05 00:00:00
 | Funeral of Queen Elizabeth II | 2022-09-19 00:00:00 |  | [NAME] | 2022-03-30 00:00:00 | 2022-07-07 00:00:00
 | Boxing Day | 2022-12-26 00:00:00 |  | [NAME] | 2022-04-01 00:00:00 | 2022-09-29 00:00:00
 | Christmas Day (Substitute) | 2022-12-27 00:00:00 |  | Ang | 2022-05-15 00:00:00 | 2022-07-06 00:00:00
 |  |  |  | [NAME] | 2022-08-01 00:00:00 | 2022-08-12 00:00:00
Spreadsheet: 178122d1346668460-putting-data-in-other-worksheets-corbinsbere-gundogs-competition
Sheet: Spaniel Special Puppy

ENTRANTS NUMBER | HANDLERS NAME | DOGS NAME | TEST 1 | TEST 2 | TEST 3 | SCORE | POSITION
1 | [NAME] | Storm | 10 | 19 | 6 | 35 | 2
 |  |  |  |  |  | 0 | 5
3 | [NAME] | Poppy | 12 | 5 | 16 | 33 | 3
 |  |  |  |  |  | 0 | 5
5 | [NAME] | Trish | 14 | 3 | 19 | 36 | 1
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
8 | [NAME] | Chick | 15 | 6 | 9 | 30 | 4
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
 |  |  |  |  |  | 0 | 5
Spreadsheet: 164550d1340808986-creating-easy-to-read-groupings-form-an-excel-table-test-modified-by-tigeravatar-
Sheet: Sheet1

Original table (simplified)
Item | Group |  | Group
Overview | About the new process |  | About the new process
Further reading | About the new process |  | Further reading
Recruitment | About the new process |  | How we got here
Overview of roles | About the new process |  | Overview
How we got here | About the new process |  | Overview of roles
The Team | About the new process |  | Recruitment
Administrators | Audience specific support |  | The Team
Managers | Audience specific support |  | Audience specific support
Operators | Audience specific support |  | Administrators
Contractors | Audience specific support |  | Contractors
Vacancies | Vacancies |  | Managers
Secondments | Vacancies |  | Operators
 |  |  | Vacancies
 |  |  | Secondments
 |  |  | Vacancies
Spreadsheet: 112051d1308233012-matching-question-sheet-size-thickness-selector
Sheet: Sheet2

Item # | Type | Color | Sweetness Level |  | Example 1 | Desired Characteristics |  |  |  | This will only work on sorted data > | J Beaucaire Formula |  | Types | Colors | Sweetness Levels
AR8 | Apple | Red | 8 |  | AR3 | Apple | Red | 1 |  |  | AR12 |  | Apple | Red | 1
AR11 | Apple | Red | 11 |  | AR3 | Apple | Red | 2 |  |  | AR12 |  | Orange | Yellow | 2
AR3 | Apple | Red | 3 |  | AR3 | Apple | Red | 3 |  |  | AR12 |  |  |  | 3
AY10 | Apple | Yellow | 10 |  | AR8 | Apple | Red | 4 |  |  | AR12 |  |  |  | 4
AY5 | Apple | Yellow | 5 |  | AR8 | Apple | Red | 5 |  |  | AR12 |  |  |  | 5
OR10 | Orange | Red | 10 |  | AR8 | Apple | Red | 6 |  |  | AR12 |  |  |  | 6
OR5 | Orange | Red | 5 |  | AR8 | Apple | Red | 7 |  |  | AR12 |  |  |  | 7
OY10 | Orange | Yellow | 10 |  | AR8 | Apple | Red | 8 |  |  | AR12 |  |  |  | 8
OY5 | Orange | Yellow | 5 |  | AR11 | Apple | Red | 9 |  |  | AR12 |  |  |  | 9
AR12 | Apple | Red | 12 |  | AR11 | Apple | Red | 10 |  |  | AR12 |  |  |  | 10
 |  |  |  |  | AR11 | Apple | Red | 11 |  |  | AR12 |  |  |  | 11
 |  |  |  |  | AR12 | Apple | Red | 12 |  |  | #N/A |  |  |  | 12
 |  |  |  |  | #N/A | Apple | Red | 13 |  |  | #N/A |  |  |  | 13
 |  |  |  |  | #N/A | Apple | Red | 14 |  |  | #N/A |  |  |  | 14
 |  |  |  |  | #N/A | Apple | Red | 15 |  |  | #N/A |  |  |  | 15
 |  |  |  |  |  | [NAME] |  | AR12
 |  |  |  |  | Example 2 | Desired Characteristics
 |  |  |  |  | AR3 | Apple | Red | 1 |  |  | AR12
 |  |  |  |  | AR3 | Apple | Red | 2 |  |  | AR12
 |  |  |  |  | AR3 | Apple | Red | 3 |  |  | AR12
 |  |  |  |  | AR8 | Apple | Red | 4 |  |  | AR12
 |  |  |  |  | AR8 | Apple | Red | 5 |  |  | AR12
 |  |  |  |  | AR8 | Apple | Red | 6 |  |  | AR12
 |  |  |  |  | AR8 | Apple | Red | 7 |  |  | AR12
 |  |  |  |  | AR8 | Apple | Red | 8 |  |  | AR12
 |  |  |  |  | AR11 | Apple | Red | 9 |  |  | AR12
 |  |  |  |  | AR11 | Apple | Red | 10 |  |  | AR12
 |  |  |  |  | AR11 | Apple | Red | 11 |  |  | AR12
 |  |  |  |  | AR12 | Apple | Red | 12 |  |  | #N/A
 |  |  |  |  | #N/A | Apple | Red | 13 |  |  | #N/A
 |  |  |  |  | #N/A | Apple | Red | 14 |  |  | #N/A
 |  |  |  |  | #N/A | Apple | Red | 15 |  |  | #N/A
 |  |  |  |  |  | [NAME] |  | AR12
Spreadsheet: 824612d1680710308-if-countif-pm-formula-question
Sheet: Sheet1

PM File Customer | N&A [NAME] | N&A [NAME] | [NAME] | Category | Branch | PM Salesman | N&A Salesman | PM Salesman Name | PM Contract # | Make | Model | Serial # | [NAME] | [NAME] | [NAME] | [NAME] | Salesman Match | Frequency | Salesman Override | [NAME] | Commission Salesman | Commission Customer | Sales Commission | Tech Commission
671570 |  | 670975A | Customer 1 | TR | 35 | 225 | 225 | Salesman 1 | N 030823 | GN | GS1930 | NA | 90 | 365 | 0 | 0 |  |  | Salesman 2
670975A |  | 671570 | Customer 2 | TR | 35 | 525 | 225 | Salesman 2 | N 030823 | ZZ | SL63FF | 1A1119 | 90 | 0 | 0 | 0
670975A |  | 671570 | Customer 2 | TR | 35 | 525 | 225 | Salesman 2 | N 030823 | HY | S150A | A024D039034 | 90 | 0 | 0 | 0 |  |  |  | Tech 1
670975A |  | 671570 | Customer 2 | TR | 35 | 525 | 225 | Salesman 2 | N 030823 | HY | E45Z33 | G108V01529B | 90 | 0 | 0 | 0
670975A |  | 671570 | Customer 2 | TR | 35 | 525 | 225 | Salesman 2 | N 030823 | HY | E45Z33 | G108V01531B | 90 | 0 | 0 | 0
670975A |  | 671570 | Customer 2 | TR | 35 | 525 | 225 | Salesman 2 | N 030823 | HY | E45Z33 | G108V01540B | 90 | 0 | 0 | 0
670975A |  | 671570 | Customer 2 | TR | 35 | 525 | 225 | Salesman 2 | N 030823 | HY | E80XN | A099N01927M | 90 | 0 | 0 | 0
670975A |  | 671570 | Customer 2 | TR | 35 | 525 | 225 | Salesman 2 | N 030823 | HY | E80XN | A099N01928M | 90 | 0 | 0 | 0
670975A |  | 671570 | Customer 2 | TR | 35 | 525 | 225 | Salesman 2 | N 030823 | HY | E80XN | A099N01948M | 90 | 0 | 0 | 0
Spreadsheet: 855154d1704824116-rolling-12-month-absence-caculator-attendance-tracker-template
Sheet: Mar

 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March 2024
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Leave this month | Working days this month | Absence this month
 |  | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  |  |  |  |  |  | P
 |  |  |  |  |  | H
 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  |  |  | V
 |  |  |  |  |  |  |  |  |  |  |  |  | S |  |  |  |  |  |  |  |  |  | H
 |  | Legend: W- Working day, P- Part-time, A- [NAME], V- Vacation, H-Holiday, S-Sickness
 | The attendance tracker is provided to you by LeaveBoard.
 | https://leaveboard.com/attendance-tracker/
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Mark Woodward

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
I'd like to explain my position
Explain your health care reform position, if you choose
Just  not sure how this will play out . I tend to think teachers would be better off not having to negotiate for health benifits.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | [NAME]. [NAME] | State Rep | Yes |  | Lamoille
Spreadsheet: larry_campbell__21440__AssociateAnalystFoosball
Sheet: Game Chart

 | Associate/Analyst Foosball Tournament
 | Players |  | Round One Winners |  | Round Two Winners |  | Round Three Winners |  | Final Round
 | [NAME] |  | Game 1
 | Game 1
 | [NAME]/Crystal Hyde |  |  |  | Game 8
 | [NAME]/mateo [NAME] |  | Game 2
 | Game 2
 | [NAME] |  |  |  |  |  | Game 12
 | [NAME] |  | Game 3
 | Game 3
 | [NAME]/[NAME] |  |  |  | Game 9
 | Hector Alviar/[NAME] |  | Game 4 |  |  |  |  |  | Winners:
 | Game 4
 | Kendell Sprott/Philip Berry |  |  |  |  |  |  |  | Game 14
 | [NAME] |  | Game 5
 | Game 5
 | [NAME] |  |  |  | Game 10
 | [NAME]/[NAME] |  | Game 6
 | Game 6 |  |  |  |  |  | Game 13
 | [NAME]
 | [NAME][NAME] |  | Game 7
 | Game 7
 | [NAME] |  |  |  | Game 11
 | [NAME]
 | Table One: |  | Monday, November 6th |  | Tuesday, November 7th |  | Wednesday, November 8th
 |  |  | 11:30 - 12:00 - Game 1 |  | 11:30 - 12:00 - Game 8 |  | 11:30 - 12:00 - Game 14
 |  |  | 12:00 - 12:30 - Game 2 |  | 12:00 - 12:30 - Game 12
 |  |  | 12:30 - 1:00 - Game 3
 |  |  | 1:00 - 1:30 - Game 4
 | Table Two: |  | Monday, November 6th |  | Tuesday, November 7th
 |  |  | 11:30 - 12:00 - Game 5 |  | 11:30 - 12:00 - Game 9
 |  |  | 12:00 - 12:30 - Game 6 |  | 12:00 - 12:30 - Game 10
 |  |  | 12:30 - 1:00 - Game 7 |  | 12:30 - 1:00 - Game 11
 |  |  |  |  | 1:00 - 1:30 - Game 13
Spreadsheet: 876275d1722959840-show-hide-rows-of-teams-as-match-pairs-regarding-data-1_show_or_hide_football_matches_pairs
Sheet: Sheet1 (EPL Week 17)

A1 | [NAME] | 0
A2 | [NAME] | 2
B1 | Newcastle United | 3
B2 | Fulham | 0 |  | 1- | I want to show or hide as pairs in terms of home team scores 2 or more goals in that match
C1 | Manchester City | 2 |  |  | So Newcastle-Fulham match rows no.4 and no.5 will be shown because home team score cell C4 equals to 3
C2 | Crystal Palace | 2 |  |  | But, rows no.2 and no.3 will be hided because home team score cell C2 is 0.
D1 | Chelsea | 2 |  |  | As Sheet2, you can see five matches together which fits the rule.
D2 | Sheffield United | 0
E1 | Bournemouth | 1 |  | 2- | I want to show or hide rows as pairs in terms of total goals scored over 2.5 or under 2.5 by two teams in that match.
E2 | [NAME] | 1 |  |  | So, first match [NAME] listed on row no.2 and no.3 will be hided because sum of C2 and [NAME] cells equals to 0+2=2, less than 3 goals
F1 | Burnley | 0 |  |  | And, row no.4 and row no.5 will be shown as a match of Newcastle and Fulham, because C4+C5 equals to 3, more than 2 goals.
F2 | Everton | 2 |  |  | As Sheet3, four matches need to be shown, rest six matches will be hided.
[NAME] | West Ham United | 3
G2 | [NAME] | 0 |  |  | How can we formulaize these two scenarios to filter data?
H1 | Brentford | 1
H2 | [NAME] | 2
I1 | Arsenal | 2
I2 | Brighton & Hove Albion | 0
J1 | Liverpool | 0
J2 | [NAME] | 0
Spreadsheet: 491017d1480265359-adding-cumulative-weekly-totals-avk-excel-forum-question1
Sheet: 11-28-16

 | DAILY HEARING ROSTER
 | MEETINGS TODAY:
Rank | Stenographer | Notes | Time In | Time Out | Time In | Time Out | Subtotal | Total Hours | NewRank | Cumulative | Cum_rank | Judge | Employee Name | Board No.
1
2
3
4
5
6
 | Travel
 |  |  |  | TOTAL TIME (Today): |  |  |  |  |  |  |  | TOTAL HEARINGS Today):
 |  |  |  | TIME (Week End Total): |  |  |  |  |  |  |  | HEARINGS (Week End Total):
Spreadsheet: 209978d1359333814-finding-cellson-1-sheet-and-posting-in-another-2013-est
Sheet: 13

0 | 0 |  |  | 0 | 0 | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Sizes | Shorts | 0 | Socks | 0 | Shirt | 0
 | 13 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Round | jumper No | Date | Versus |  | Team | Result | score | Payment | Trys | Goals | F/Goal | [NAME] | Sent off | B/F  points | Players player | [NAME] | Shirt sox | Doubles | raffle | Other | early Pay | fines | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expenses
1 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
3 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
4 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
5 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
6 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
7 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
0 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
8 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
9 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
0 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
10 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
11 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
12 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
13 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
14 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
15 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
16 |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
17 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
18 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Elimination Final |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Qualifying Final |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1st Semi Final |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
2nd Semi Final |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Preliminary Final |  | 1900-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Grand Final |  | 1900-01-01 00:00:00 |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | After 12 games
 |  |  |  |  | signon fee |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | TOTAL PAYMENT  DUE |  |  | 0
 |  |  | Player Signature:…………………. |  |  |  |  |  | Date Received………………………..
 |  |  | Cheque No:…………………………. |  |  |  |  |  | President Signature:…………………
Spreadsheet: 62f3e7df-9b04-47c7-b058-73eca5cdf98c
Sheet: Sheet1

IV. Inland Water Fisheries | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
1. Total Number of Inland Water Fishery Management Entities
 |  |  |  |  | Unit: Entity
Nationwide, prefecture |  | Total number of management entities | Lake fishery management entities | Aquaculture management entities | Management entities engaged in both lake fishery and aquaculture
Japan |  | 6478 | 2850 | 3764 | 136
Hokkaido |  | 341 | 284 | 114 | 57
Aomori |  | 467 | 445 | 22 | -
Iwate |  | 83 | - | 83 | -
Miyagi |  | 28 | - | 28 | -
Akita |  | 221 | 180 | 42 | 1
Yamagata |  | 99 | - | 99 | -
[NAME] |  | 92 | 20 | 73 | 1
Ibaraki |  | 549 | 527 | 70 | 48
Tochigi |  | 82 | 35 | 48 | 1
Gunma |  | 55 | 2 | 53 | -
Saitama |  | 116 | - | 116 | -
Chiba |  | 135 | 29 | 106 | -
Tokyo |  | 27 | - | 27 | -
Kanagawa |  | 28 | 11 | 17 | -
Niigata |  | 490 | - | 490 | -
Toyama |  | 36 | - | 36 | -
Ishikawa |  | 40 | 13 | 27 | -
Fukui |  | 63 | 43 | 20 | -
Yamanashi |  | 70 | 21 | 51 | 2
Nagano |  | 335 | 87 | 252 | 4
[NAME] |  | 153 | - | 153 | -
Shizuoka |  | 138 | - | 138 | -
[NAME] |  | 341 | - | 341 | -
Mie |  | 63 | - | 63 | -
Shiga |  | 662 | 612 | 71 | 21
Kyoto |  | 16 | - | 16 | -
Osaka |  | 21 | - | 21 | -
Hyogo |  | 32 | - | 32 | -
Nara |  | 77 | - | 77 | -
Wakayama |  | 23 | - | 23 | -
Tottori |  | 182 | 108 | 75 | 1
Shimane |  | 460 | 403 | 57 | -
[NAME] |  | 75 | 30 | 45 | -
Hiroshima |  | 88 | - | 88 | -
Yamaguchi |  | 27 | - | 27 | -
Tokushima |  | 166 | - | 166 | -
Kagawa |  | 64 | - | 64 | -
Ehime |  | 42 | - | 42 | -
Kochi |  | 72 | - | 72 | -
Fukuoka |  | 80 | - | 80 | -
Saga |  | 18 | - | 18 | -
Nagasaki |  | 19 | - | 19 | -
[NAME] |  | 83 | - | 83 | -
Oita |  | 61 | - | 61 | -
Miyazaki |  | 88 | - | 88 | -
[NAME] |  | 67 | - | 67 | -
[NAME] |  | 3 | - | 3 | -
Note: Includes private fishery households that engaged in operations on lakes for 29 or fewer days.
Spreadsheet: 815062d1674724930-xlookup-multiple-criteria-xlookup_multiple_criteria
Sheet: Tab_1

Product | Scale Quantity | Purchase Price
20000840 | 5616 | 150
20000840 | 73008 | 100
20000840 | 252720 | 50
20002695 | 1 | 100
20002695 | 10000 | 90
20002695 | 20000 | 80
20002695 | 30000 | 70
20002695 | 50000 | 60
20002695 | 100000 | 50
Spreadsheet: 329558d1404334915-comparing-two-columns-in-two-different-sheets-and-get-the-common-in-the-first-sheet-docregister
Sheet: Incoming

In coming Document ref. | [NAME]. ref.
GOV/ADG/001 | ADG/GOV/002
DEC/ADG/001
TTC/ADG/001
GOV/ADG/002
DEC/ADG/002
TTC/ADG/002
GOV/ADG/003
DEC/ADG/003
TTC/ADG/003
GOV/ADG/004
DEC/ADG/004
TTC/ADG/004
GOV/ADG/005
DEC/ADG/005
TTC/ADG/005
GOV/ADG/006
DEC/ADG/006
TTC/ADG/006
GOV/ADG/007
DEC/ADG/007
TTC/ADG/007
GOV/ADG/008
DEC/ADG/008
Spreadsheet: lindy_donoho__21978__tw_priority_rate
Sheet: Eff Jan 1, 2001 - Sep 30, 2001

Transwestern Pipeline Company
Contracts Under the Global Settlement
Priority Rates (Reservation and Demand Surcharges)
Contract | Shipper | Receipt to Delivery | Reservation | Shared Cost | TCR II No. 1 | TCR II No. 2 | GRI Demand | Total |  | Commodity | ACA | GRI
Number | Name | Area | Rate | Surcharge | Surcharge | Surcharge | Surcharge | Rate |  | Rate | Surcharge | Surcharge
8255 | Southern California Gas Company | East of Thoreau to California (W. of Thoreau) | 0.3232 |  | 0.0051 | 0.0007 | 0.003 |  |  | 0.0238 | 0.0022 | 0.007
20834 | Citizens Utilities Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - | - |  |  | 0.0011 | - | -
20835 | Conoco Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - | - |  |  | 0.0011 | - | -
21175 | Pacific Gas & Electric Company(Gas) | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - | - |  |  | 0.0011 | - | -
26677 | El Paso Energy Marketing Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - | - |  |  | 0.0011 | - | -
26371 | Duke Energy Trading and Marketing. LLC | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - | - |  |  | 0.0011 | - | -
25923 | Texaco Natural Gas Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - | - |  |  | 0.0011 | - | -
20715 | Southern California Gas Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - | - |  |  | 0.0011 | - | -
20747 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2606 | 0.0369 | 0.005 | 0.0007 | 0.003 |  |  | 0.0162 | 0.0022 | 0.007
20748 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2606 | 0.0369 | 0.005 | 0.0007 | 0.0018 |  |  | 0.0162 | 0.0022 | 0.007
21165 | Pacific Gas & Electric Company(Gas) | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2606 | 0.0443 | 0.0052 | 0.0007 | 0.003 |  |  | 0.0162 | 0.0022 | 0.007
26678 | El Paso Energy Marketing Company | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2606 | 0.0443 | 0.004 | 0.0005 | 0.003 |  |  | 0.0162 | 0.0022 | 0.007
26372 | Duke Energy Trading and Marketing. LLC | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2606 | 0.0443 | 0.0051 | 0.0007 | 0.003 |  |  | 0.0162 | 0.0022 | 0.007
25924 | Texaco Natural Gas Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2606 | 0.0443 | 0.0053 | 0.0007 | - |  |  | 0.0162 | 0.0022 | -
20822 | Citizens Utilities Company | Thoreau/San Juan Pt. to East of California (W. of Thoreau) | 0.1681 | 0.0369 | 0.0025 | 0.0003 | 0.0018 |  |  | 0.0162 | 0.0022 | 0.007
NOTE --- | Per CBS Negotiated Rate System, the termination date for the rates listed above are as follows:
 | Reservation | Recalculation eff every Nov 1st
 | SCS | 2001-10-31 00:00:00
 | TCR II No. 1 | 2005-10-31 00:00:00
 | TCR II No. 2 | 2006-10-31 00:00:00
 | GRI Demand | Recalculation eff every Jan 1st **
 | ** Calculation made every year to determine which contracts are High Load vs. Low Load
Spreadsheet: 159719d1338826046-time-intervals-sum-unexpected-result-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Expected
 |  |  |  |  |  |  |  |  |  | 08:00:00
 |  |  |  |  |  |  |  | Morning | Aternoon | Worked | Difference | SIGN | ABS
09:35:00 | 12:50:00 |  |  | 14:00:00 | 18:45:00
09:35:00 | 12:50:00 |  |  | 14:00:00 | 18:00:00
09:35:00 | 12:50:00 |  |  | 14:00:00 | 19:00:00