tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 12d39878-832c-44d8-bcc5-6a111244c7c6
Sheet: Sheet1

Unnamed: 0 | 2009
4-H Community Club Members | 19608
School Enrichment Contacts | 43422
4-H In-School Club Members | 371
4-H After-School Club Members | 5198
Special Interest/Short Term Program Contacts | 36454
4-H Overnight Camping Members | 3393
4-H Day Camping Members | 1491
Military 4-H Club Members | 2232
School-Aged Child Care Contacts | 1359
Individual Study/ Mentoring Members | 349
Spreadsheet: 197372d1354310742-if-a-cell-equals-x-then-format-that-many-cells-for-input-bracket-help
Sheet: Leaderboard

NAME | Total Points | RD 1 (32) | RD 2 (32) | [NAME] (24) | Elite 8 (16) | Final 4 (12) | Championship (10)
Name 1
Name 2 | Points and name would extend for the number of participants
Name 3
Name 4
Name 5
Spreadsheet: 792484d1660919878-sum-and-count-with-identifiers-research-output-hd
Sheet: Sheet1

 | Output |  |  |  |  |  |  |  |  |  |  |  |  | Input (on different tab)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sex | Country | Q19_11R1 | Q19_11R2 | Q19_11R3 | Q19_1R1 | Q19_1R2 | Q19_1R3
 | Filters |  |  |  |  |  |  |  |  |  |  |  |  | Survey 1 | Male | Germany | 4 | 2 | 1 | 4 | 4 | 4
 | Country | Poland |  |  |  |  |  |  |  |  |  |  |  | Survey 2 | Female | Poland | 3 | 5 | 2 | 4 | 4 | 4
 | Sex | Male |  |  |  |  |  |  |  |  |  |  |  | Survey 3 | Male | Germany | 1 | 5 | 3 | 4 | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Survey 4 | Male | Poland |  |  |  | 3 | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Survey 5 | Male | Poland | 1 | 5 | 3 | 4 | 3 | 4
 | Company1 | Company2 | >> Sum | Company 1 | Company 2 |  |  | >> Count | Company 1 | Company 2
 | Q19_11R1 | Q19_1R1 | Fastest |  |  |  |  | Fastest
 | Q19_11R2 | Q19_1R2 | Cheapest |  |  |  |  | Cheapest
 | Q19_11R3 | Q19_1R3 | Slowest |  |  |  |  | Slowest
Spreadsheet: 06b7be5b-2476-457f-bc83-29c1f11d0eff
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6345.0 Labour Price Index, Australia
 | Hourly Rates of Pay Including Bonuses: Sector, Original (Financial Year Index Numbers for year ended June quarter)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Financial Year Index ;  Ordinary time hourly rates of pay including bonuses ;  Australia ;  Private ;  All industries ; |  |  | Original | A2709868J | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Ordinary time hourly rates of pay including bonuses ;  Australia ;  Public ;  All industries ; |  |  | Original | A2710058C | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Ordinary time hourly rates of pay including bonuses ;  Australia ;  Private and Public ;  All industries ; |  |  | Original | A2709982L | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay including bonuses ;  Australia ;  Private ;  All industries ; |  |  | Original | A2707474F | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay including bonuses ;  Australia ;  Public ;  All industries ; |  |  | Original | A2707664V | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay including bonuses ;  Australia ;  Private and Public ;  All industries ; |  |  | Original | A2707588C | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
© Commonwealth of Australia  2010
Spreadsheet: 39214d1237400545-transpose-2nd-column-based-on-repeats-in-1st-column-sample
Sheet: Sheet1

STATE | CITY
Mississippi | [NAME]
Florida | Orlando
Florida | Tampa
Florida | Jacksonville
Florida | Pensacola
Florida | Miami
Florida | Key West
Georgia | Atlanta
Louisiana | New Orleans
Louisiana | Baton Rouge
Alabama | Birmingham
Alabama | Mobile
Alabama | Montgomery
Spreadsheet: 149189d1333737065-excel-2007-data-table-total-row-wont-calculate-time-employee-2-timecard
Sheet: Payroll 4-20

Client | Cost Code | Hours
Total
Spreadsheet: 8c87826d-5653-42d1-b099-6bf0831b33c5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
6040 | 27987 | Günter | Hammele | GER | 433 | 00:00:00 | 00:00:00 | [NAME] | 00:02:01 | 00:12:47 | 1 | 00:36:25
6040 | 8067 | [NAME] | [NAME] | USA | 435 | 00:00:00 | 00:00:00 | 00:21:03 | 00:02:34 | 00:14:07 | 2 | 00:37:43
6040 | 42729 | [NAME] | Meekings | NZL | 434 | 00:00:00 | 00:00:00 | 00:24:53 | 00:02:08 | 00:12:40 | 3 | 00:39:40
6040 | 7993 | [NAME] | [NAME] | AUS | 430 | 00:00:00 | 00:00:00 | 00:24:27 | 00:02:42 | 00:12:46 | 4 | 00:39:54
6040 | 8036 | [NAME] | Mactaggart | GBR | 432 | 00:00:00 | 00:00:00 | 00:21:37 | [NAME] | 00:15:04 | 5 | 00:39:59
6040 | 43676 | [NAME] | Weaver | USA | 436 | 00:00:00 | 00:00:00 | 00:24:54 | 00:03:32 | 00:14:44 | 6 | 00:43:10
6040 | 8005 | Lachlan | Lewis | AUS | 431 | 00:00:00 | 00:00:00 | 00:40:53 | 00:04:43 | 00:16:59 | 7 | 01:02:35
Spreadsheet: fletcher_sturm__10921__bidfax
Sheet: Bid Sheet

 |  | Alliance Pricing Sheet
 |  | 1150 mmcf/day |  | 664 mmcf/day |  | 1584 mmcf/day |  | 650 mmcf/day |  | 350 mmcf/day |  | 600 mmcf/day
 |  | ANR |  | Vector |  | NGPL |  | Midwestern |  | Nicor/Nigas |  | Peoples
Pricing Date |  | M.I. | D.I. / AOS | M.I. | D.I. / AOS | M.I. | D.I. / AOS | M.I. | D.I. / AOS | M.I. | D.I. / AOS | M.I. | D.I. / AOS
2000-08-31 00:00:00 | Nov/Mar | 0 | -0.005 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Apr-Oct | -0.005 | -0.005 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Nov/Mar
 | Apr-Oct
 | Nov/Mar
 | Apr-Oct
 | Nov/Mar
 | Apr-Oct
 | Nov/Mar
 | Apr-Oct
 | Nov/Mar
 | Apr-Oct
 | Nov/Mar
 | Apr-Oct
 | Nov/Mar
 | Apr-Oct
 | Nov/Mar
 | Apr-Oct
 | Nov/Mar
 | Apr-Oct
 | Nov/Mar
 | Apr-Oct
 | Comments: |  | [NAME],  Add your comments here based on any issues / thoughts you may have on pricing.
 |  |  | ENA bids on this sheet only.
 |  |  | M.I. =  NGI Chicago Monthly Index
 |  |  | D.I.= Gas Daily, Daily Index Midpoint
Spreadsheet: 274965d1383293852-conditional-formatting-for-time-sheet-crew-calling-at-anchor
Sheet: Departure port

Enter Pilot Boarding time | → | 2013-06-03 06:30:00
Enter Distance to Pilot station | → | 10
Enter Speed to Pilot station | → | 9 |  |  |  | time to steer in days
1 Hour notice to Engine room | → |  |  |  |  | 1 hour converted to days
Test Controls at | → |  |  |  |  | 1 hour converted to days
 |  |  |  |  |  | 1.5 hours converted to days
Crew Should be called at | →
Call Master at | →
Engines to be ready by | → |  |  |  |  | 15 mins converted to days
 |  |  |  |  |  | 5 mins converted to days
Commence Heaving anchor at | →
Anchor Should be aweigh at | →
Spreadsheet: 722fc3a1-bb88-4aea-b4ab-8189cf7986d1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-08-08 09:19:04.860000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.484 | 101.359 | 101.234 | 100.859
3.75 | 101.336 | 101.211 | 101.086 | 100.711 |  | Note: | Refer To Price [NAME]
3.625 | 100.924 | 100.799 | 100.674 | 100.299 |  |  | For all Price Adjs
3.5 | 100.274 | 100.149 | 100.024 | 99.399
3.375 | 99.383 | 99.258 | 99.133 | 98.508
3.25 | 98.419 | 98.294 | 98.169 | 97.544
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.058 | 101.933 | 101.808 | 101.433
3.25 | 101.631 | 101.506 | 101.381 | 101.006
3.125 | 101.332 | 101.207 | 101.082 | 100.707
3 | 100.981 | 100.856 | 100.731 | 100.356
2.875 | 100.37 | 100.245 | 100.12 | 99.495
2.75 | 99.711 | 99.586 | 99.461 | 98.836
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-08-22 09:19:04.860000
30 DAY | 2012-09-06 09:19:04.860000
45 DAY | 2012-09-21 09:19:04.860000
60 DAY | 2012-10-06 09:19:04.860000
90 DAY | 2012-11-05 09:19:04.860000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 675338d1588250383-identifying-text-entries-from-a-list-in-a-cell-containing-a-text-string-identifying-entries-from-a-list
Sheet: Sheet1

 |  |  | Attribute list 1 |  | Attribute list 2 |  | Attribute list 3 | … | There are 12 or 15 columns of different potential lists of attribute categories
 |  |  | Gym |  | Online |  | Packet
 |  |  | Racetrack |  | Instore |  | Pallet
 |  |  | Watersports |  | Collect only |  | Carton
 |  |  | Card Games |  |  |  | Van delivery
 | Source data: a list of attributes
 | (Entries aren't always in the same order)
 |  |  | List 1 entry |  | List 2 entry |  | List 3 entry
Example text string 1 | Online; Racetrack; Carton |  | Racetrack |  | Online |  | Carton
Exanmple text string 2 | Packet; Card Games; |  | Card Games |  | <blank> |  | Packet
… |  |  | [NAME] required to return the values in filled cells above
I have a list of 20k attributes strings, which need to be sorted into their relevant columns.
Spreadsheet: hunter_shively__12664__Daily Prices
Sheet: Sheet1

Summary of Central Deals
All Central Deals: 11/26/2001 12:14:18 PM
Product ID | [NAME] | Weighted Average ($/MMBtu) | High Trade ($/MMBtu) | Low Trade ($/MMBtu) | [NAME] (MMBtu/day)
27760 | Consumers Pwr | 2.039419897115561 | 2.14 | 1.935 | 10886
27764 | [NAME] | 2.040973451327434 | 2.16 | 2 | 56500
27812 | ANR | 1.784277527926882 | 1.92 | 1.76 | 27572
27813 | ANR OK | 1.867952188595196 | 1.96 | 1.7 | 125263
27817 | NGPL LA Pool | 1.819572799722539 | 1.825 | 1.8 | 132631
27818 | NGPL Midcont | 1.862115473864429 | 2 | 1.695 | 256413
27822 | NGPL TxOkGCPool | 1.855819328577761 | 2.755 | 1.755 | 24813
27824 | NNG Demarc | 2.073866523541336 | 2.325 | 1.75 | 275749
27826 | PEPL Pool | 1.907167669119596 | 2.08 | 1.835 | 267843
29602 | Dawn | 2.092083333333334 | 2.185 | 2.05 | 120000
29606 | [NAME], TCPL | 2.033649518075214 | 2.08 | 1.97 | 41189
32775 | Trunkline ELA | 1.776358082706767 | 1.8 | 1.73 | 14896
33427 | Trunkline STX | 1.87 | 1.87 | 1.87 | 6264
35041 | NGPL AmarilloML | 1.87 | 1.87 | 1.87 | 8500
36733 | Iroquois, TCPL | 1.976666666666667 | 2.06 | 1.95 | 24000
47095 | NNG Ventura | 2.019245590739832 | 2.185 | 1.775 | 277144
47636 | NBPL/Ventura | 2.17 | 2.17 | 2.17 | 10000
Chicago | Chicago City Gates | 1.925182 | 2.11 | 1.815 | 1045879
Chicago City Gates composed of Peoples, NBPL Nicor, NGPL Nicor, and NIPSCO.
Spreadsheet: 671260d1586331961-update-defining-exact-length-of-string-for-istext-within-aggregate-function-00-wages-template-for-tests
Sheet: 14 SUNDAY

DAY: |  | SUNDAY |  | DATE:
No. |  | NAME |  |  |  | FROM | TO | Wh | VL | SL | OT | F/L | Hr | F/L | Hr | F/L | Hr | F/L | Hr | JOBS | Hr | GR/WS | Hr | CHECK |  | JOBS BREAKDOWN
12 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | GROUPAGE
11 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DRIVERS |  |  | DRIVERS
14 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PART TIMERS |  |  | PART TIMERS
33 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WELDERS |  |  | WELDERS
37 | W
27 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS
53 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
54 | W
50 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
30 | P
31 | P
32 | P
51 | P
52 | P
55 | P
15 | P
23 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPAIRS MT
26 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
6 | D
10 | D
47 | D
[NAME] |  |  |  |  | GROUPAGE |  |  | IDLE TIME |  |  |  |  | JOBS |  |  |  | REPAIRS MT |  |  |  | WORKSHOP WS
JOBS |  |  | HR |  | JOBS | HR |  | JOBS |  |  | HR |  | JOBS |  | HR |  | JOBS |  | HR |  | JOBS |  | HR
TOTAL |  |  |  |  | TOTAL |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 |  |  |  |  | Hours Calculator |  |  |  |  |  |  |  |  |  |  | TOTAL 2 |  |  |  |  | TOTAL 1
Spreadsheet: 680215d1590858422-conditional-formatting-using-multiple-sheets-and-search-function-in-multiple-rows-and-column-2020-05-30-unlimited007-cf-680204d1590855331-conditional-formatting-using-multiple-sheets-and-
Sheet: Equipment

Equipment | Misc | Misc | Misc | Misc | Misc | Misc | Misc | Misc | MISC | Misc | Misc | Misc | Misc | Misc | Misc | Misc | License Required
Hyster A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A3
Hyster B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B4
Hyster C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1
Hyster D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A4
Hyster E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2
Hyster F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1
Hyster G |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B3
Spreadsheet: sally_beck__33918__WEEKLY REPORT
Sheet: Back-up

FROM | 2019-01-01 00:00:00
TO | 2025-01-01 00:00:00
 | TOTAL | IM BC | IM CENTRAL | IM CANADA WEST | IM DENVER | IM MARKET EAST | IM NORTHEAST | IM TEXAS | IM WEST
SUPPLY/MARKET |  | 0 | 28343276 | 15111148 | 150176 | 0 | 32172531 | 5773725 | 21198188
INTERCOMPANY SUPPLY/MARKET |  | 0 | 2373717 | 594380 | 210000 | 0 | 2737856 | 1794150 | 1107722
INTRACOMPANY SUPPLY/MARKET |  | 0 | 4342988 | 1394313 | 459118 | 0 | 6601965 | 174697 | 2026739
EXCHANGE SUPPLY/MARKET |  | 0 | 22699 | 825470 | 0 | 0 | 65863 | 0 | 128600
INTERCONNECT WITHDRAWAL/INJECTION |  | 0 | 611208 | 2554340 | 0 | 0 | 0 | 0 | 0
STORAGE WITHDRAWAL/INJECTION |  | 0 | 0 | 0 | 0 | 0 | 283759 | 0 | 5114
SYNTHETIC STORAGE |  | 0 | 1367749 | 0 | 0 | 0 | 56016 | 0 | 3399
IMBALANCE WITHDRAWAL/INJECTION |  | 0 | 8690520 | 0 | 17257 | 0 | 5082923 | 556511 | 8537212
POINT WITHDRAWAL/INJECTION |  | 0 | 0 | 926429 | 0 | 0 | 1510621 | 19796 | 31413
EXTERNAL POOL WITHDRAWAL/INJECTION |  | 0 | 18127705 | 21603047 | 0 | 0 | 22718344 | 0 | 11565899
INTERNAL POOL WITHDRAWAL/INJECTION |  | 0 | 1615566 | 0 | 0 | 0 | 8477619 | 1400 | 0
FUEL |  | 0 | 119655 | 31388 | 0 | 0 | 115301 | 2618 | 79448
TOTAL THRUPUT
TOTAL SCHEDULED
Spreadsheet: 829693d1684395528-formula-to-get-condition-from-3-columns-multiple-condition-aligw
Sheet: Sheet1

Status | Score | Hours | Output |  |  | Status | Score | Hours | Output
Yes | 0-75 | Less than 60 | Plastic |  |  | Yes | 74 | 59
Yes | 76-114 | Less than 60 | Mass
Yes | 115-185 | Less than 60 | Tool Wire
Yes | 0-75 | above 60 | Mass
Yes | 76-114 | above 60 | Mass
Yes | 115-185 | above 60 | Tool Wire
Spreadsheet: 732129d1620781796-filter-help-sample
Sheet: Sheet1

Assessment | [NAME] | Weighting
Report 1A | 84 | 0.05
Report 1B | 100 | 0.15
Quiz | 90 | 0.1
Mid-Term Exam | 64 | 0.2
Report 2A | 79 | 0.05
Report 2B | 0 | 0.15
Participation | 100 | 0.05
Final Exam | 0 | 0.25
 | 0
Remaining |  | Completed
Spreadsheet: 23328435-3d90-4aae-a52b-af41a7c81f78
Sheet: PAR_PPS

Chapter 9, PAR Guidance
Pretreatment Performance Summary (PPS)
 | 1 | Pretreatment Town Name:
 | 2 | "Primary" NPDES Number |  |  |  | NC00
 |  |  | or Non_Discharge Permit # if applicable =>
 | 3 | PAR begin Date, please enter  01/01/yy  or  07/01/yy |  |  |  |  |  |  | 3. => |  |  |  |  | PSSD
 | 4 | PAR end Date,  please enter   06/30/yy  or  12/31/yy |  |  |  |  |  |  | 4. => |  |  |  |  | PSED
 | 5 | Total number of SIUs, includes CIUs |  |  |  |  |  |  | 5. => |  |  |  |  | SIUS
 | 6 | Number of CIUs |  |  |  |  |  |  | 6. => |  |  |  |  | CIUS
 | 7 |  |  |  |  |  |  |  | Enter the Higher Number, either  (7a) or (7b) here => |  |  |  |  | NOIN
 |  | 7a. | Number of SIUs not sampled by POTW |  |  |  |  |  | 7a. =>
 |  | 7b. | Number of SIUs not inspected by POTW |  |  |  |  |  | 7b. =>
 | 8 | Number of SIUs with no IUP, or with an expired IUP |  |  |  |  |  |  | 8. => |  |  |  |  | NOCM
 | 9 | Total Number of SIUs in SNC due to either IU Reporting violations or
 |  |  | IUP Limit violations.  To avoid double counting some SIUs
 |  |  |  |  |  |  |  |  | Enter  ( 9a + 9b ) - 9c here => |  |  |  |  | PSNC
 |  |  | Enter the Number of SIUs in SNC for :
 |  | 9a. | IU Reporting violations |  |  |  |  |  | 9a. => |  |  |  |  | MSNC
 |  | 9b. | IUP Limit violations |  |  |  |  |  | 9b. => |  |  |  |  | [NAME]
 |  | 9c. | Both IU Reporting & Limit violations |  |  |  |  |  | 9c. =>
 | 10 | Number of SIUs in SNC due to IU Reporting violations
 |  |  |  | that were not sampled or inspected by POTW |  |  |  |  | 10. => |  |  |  |  | SNIN
 | 11 | Number of SIUs in SNC due to violation of |  |  |  |  |  |  | 11. => |  |  |  |  | SSNC
 |  |  |  | Compliance Schedule due dates
 | 12 | Number NOVs, NNCs, [NAME], or similar assesed to SIUs |  |  |  |  |  |  | 12. => |  |  |  |  | FENF
 | 13 | Number Civil or Criminal Penalties assessed to SIUs |  |  |  |  |  |  | 13. => |  |  |  |  | JUDI
 | 14 | Number of SIUs included in public notice |  |  |  |  |  |  | 14. => |  |  |  |  | SVPU
 | 15 | Number of SIUs from which penalties collected |  |  |  |  |  |  | 15. => |  |  |  |  | IUPN
 | 16 | Total Amount of Civil Penalties Collected |  |  |  |  | 16. => | $
 | 17 | Total Number of SIUs on a compliance schedule |  |  |  |  |  |  | 17. => |  |  |  |  | SOCS
 | Foot Notes: |  | AO | Administrative Order |  | NOV | Notice of Violation
 |  |  | CIU | Categorical Industrial User |  | PAR | Pretreatment Annual Report
 |  |  | CO | [NAME] |  | POTW | Public Operated Treatment Works
 |  |  | IUP | Industrial User Pretreatment Permit |  | SIU | Significant Industrial User
 |  |  | NNC | Notice of Non-Compliance |  | SNC | [NAME], formerly RNC
Spreadsheet: jeffrey_a_shankman__13999__Exhibit 14 (Scenario 5)
Sheet: Rate Increase Model

 | CPUC Rate Proceeding |  |  |  |  |  |  |  | Exhibit 14 (Scenario 5)
 | SDG&E A. 01-01-044 |  |  |  |  |  |  |  | Revised with DWR Revenue Requirement
 |  |  |  |  |  |  |  |  | Update August 7, 2001
 | Billing Determinants
 | Original Filing Determinants (July-01 to June-02)
 | Sales (GWh) |  | URG | DWR |  | Total
 | Capped AB 265 Customers | 0.7 | 6987.209349386416 | 4772.273078870193 |  | 11759.48242825661
 | Capped ABX1 43 Customers | 0.3 | 0 | 5039.778183538547 |  | 5039.778183538547
 | Total Bundled Sales |  | 6987.209349386416 | 9812.05126240874 |  | 16799.26061179516
 | Update Determinants (Mar-01 to December-02)
 | Sales (GWh) |  | URG | DWR |  | Total
 | Capped AB 265 Customers | 0.7
 | Capped ABX1 43 Customers | 0.3 | 0
 | Total Bundled Sales
 | Commodity Revenue Requirement |  | ($000s)
 | DWR Rev. Requirement |  | 2068441 |  | <============ | DWR Revenue Requirements Update Letter August 7, 2001
 | SDG&E - URG |  | 670175.3136200698 |  | <============ | Retained Generation Costs Jul-01 to Dec-02
 | SDG&E Ancillary Charges |  | 213045.1524139957 |  | <============ | SDG&E Ancillary Charges Jul 01 to Dec 02
 | SDG&E Other ISO Charges |  | 73149.20836804548 |  | <============ | SDG&E ISO Charges Jul 01 to Dec 02
 | SDG&E Grid Mgmnt Charges (GMC) |  | 30621.4823457456 |  | <============ | SDG&E Grid Mgmnt Charges (GMC) Jul 01 to Dec 02
 | Total URG Revenue Requirement
 | Total Commodity Revenue Requirement
 | Bundled Revenues
 | Revenues at Current Commodity Rate
 | DWR Commodity Revenues @6.5 c/kWh
 | URG Commodity Revenues @ 6.5 c/kWh |  |  | 6.5
 | DWR Revenues Subject to Rate Increase
 | SDG&E Revenues Subject to Rate Increase
 | Total Rate Increase
 | Customer Revenue Allocation
 |  |  | System |  |  | ABX1 43 Customers |  | AB 265 Customers
 | DWR Revenue Requirement
 | Billed Revenues
 | DWR Revenues Subject to Rate Increase
 | [NAME] (GWh) Mar-27 to Dec-02
 | DWR Rate Increase (C/kWh)
 | CTC Rate (C/kWh) |  |  |  |  | -0.66 |  | 0
 | Net DWR Rate Increase (C/kWh)
Spreadsheet: 121435d1316052580-pivot-table-to-roll-up-data-and-display-in-pivot-chart-tickets
Sheet: Sheet4

Sum of Duration | Date
Assigned To | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | Average Time Spent on Tickets per day
[NAME] | 0.5 | 3
[NAME] | 0.25 | 2
[NAME] | 2 | 4
[NAME] | 2.5 | 3
Spreadsheet: 803875d1667759777-weekly-league-score-sheets-help-workbook1
Sheet: 2022 Team Roster

Team Roster September 22/23
TEAM |  | TEAM | STATS
BOB | 1 | MOOK | 2
KATHY |  | DERRICK
ANNIE
DARLENE |  | [NAME]
DAMIAN | 3 | WAYNE | 4
MARY |  | MICHELLE
 |  | BONNIE
ALEX |  | PAULA
VAUGHN | 5 | LIONEL | 6
MARIE |  | MANDY
[NAME] |  | AL
GLENDA |  | ANNE
DON | 7 | ELSA | 8
MARINA |  | GRAHAM
VANDA
CARLOS |  | BRAD
[NAME] | 9 | MARCEL | 10
BILL |  | MIKE
DEBBIE |  | BETTY
TONI |  | [NAME]
Spreadsheet: 217020d1361969207-nested-lookup-or-index-match-or-lookup-question
Sheet: Sheet1

 |  |  |  |  | Event |  |  |  |  |  |  | Total
 |  |  |  |  | AA | AB | AC | AD | AE | AF | AG | Hours
 | Event | Hours |  | Item
 | AA | 22 |  | 1 | x | x | x |  |  |  | x | 22 |  | M5 should = C5+C6+C7
 | AB | 11 |  | 2 | x | x | x | x |  | x | x
 | AC | 45 |  | 3 |  | x | x | x | x
 | AD | 23 |  | 4 |  |  | x | x | x | x | x
 | AE | 6 |  | 5
 | AF | 66 |  | 6
 | AG | 13 |  | 7 | x | x | x | x | x | x | x
 |  |  |  | 8 | x | x | x | x |  | x | x
 |  |  |  |  |  |  |  |  | IF(F5="x",LOOKUP(F3,B5:B11,C5:C11),0)
 |  |  |  |  |  |  |  | Would like to modify the formula in cell M5 to calculate the entire row from F5 to L5