tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2d8e772d-fb3c-43c3-a661-688c45234f61
Sheet: In hours

Enter full year entitlement in hours
(if part-time, use calculator 1 on leave calculator if not known) |  |  | Working hours |  |  | INSTRUCTIONS FOR USE
 |  |  | Monday |  |  | 1.  Calculate entitlement (pro-rated if part-time)
Enter date of start of contract e.g. 1 September 2013 | 2013-09-01 00:00:00 |  | Tuesday |  |  | 2. Put your working hours in the table to the left (as a reminder).
(or  start date for annual leave year) |  |  | Wednesday |  |  | 3. Complete the table for Bank and University Holidays, putting in the hours you would normally work on that day. If you do not normally work that day, enter zero.
Enter end date of holiday year  i.e. 31 August 2014 | 2014-08-31 00:00:00 |  | Thursday |  |  | 4. Put zero for any days that occurred before you started work at the University.
 |  |  | Friday |  |  | 5. Add on the further days of bookable annual leave as they are taken, or when they are planned.
Number of days between the these two dates |  |  | Total
Entitlement in hours
HOLIDAY RECORD
 | Normal hours worked on that day(s) | Running total of leave taken | Running total of leave remaining |  |  | Note: The values used are fractions of an hour not minutes e.g. 7hrs 18 mins = 7.3 hours, NOT 7.18 hours
Bank and University Holidays
Wednesday 25th December 2013
Thursday 26th December
Friday 27th December
Monday 30th December
Tuesday 31st December
Wednesday 1st January 2014
Friday 18th April
Monday 21st April
Tuesday 22nd April
Monday 5th May
Monday 26th May
Monday 25th August
Tuesday 26th August
Bookable Leave
Spreadsheet: 695721d1600361484-formula-for-conditional-formatting-time-blocks-in-cells-time-etaf
Sheet: Sheet1

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
06:30:00
06:45:00
07:00:00
07:15:00
07:30:00
07:45:00
08:00:00
08:15:00
08:30:00
08:45:00
09:00:00
09:15:00
09:30:00
09:45:00
10:00:00
10:15:00
10:30:00
10:45:00
11:00:00
11:15:00
11:30:00
11:45:00
12:00:00
12:15:00
12:30:00
12:45:00
13:00:00
13:15:00
13:30:00
13:45:00
14:00:00
14:15:00
14:30:00
14:45:00
15:00:00
15:15:00
15:30:00
15:45:00
16:00:00
16:15:00
16:30:00
16:45:00
17:00:00
17:15:00
17:30:00
17:45:00
18:00:00
18:15:00
18:30:00
18:45:00
19:00:00
19:15:00
19:30:00
19:45:00
20:00:00
20:15:00
20:30:00
20:45:00
21:00:00
21:15:00
21:30:00
21:45:00
22:00:00
22:15:00
22:30:00
22:45:00
23:00:00
23:15:00
23:30:00
23:45:00
1900-01-01 00:00:00
Spreadsheet: d149584e-3e1f-4129-8e04-e3f45951fcca
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FHYCD | Test | FHYCD | [NAME], Quantitative, [NAME] | Hydrocodone, U - Forensic | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) |  |  |  | 10 | mL | 20 mL aliquot of random or spot urine sent refrigerated. | 10 mL NOTE: Submission of the mi | Specimens other than	[NAME] Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Hydrocodone, [NAME]    ng/mL   Reference ranges have not been established for urine specimens.   This specimen was handled by Medtox Laboratories as a Forensic specimen under chain of custody protocol.   Test Performed by: Medtox Laboratories, Inc.                                        402 W. County Road D                                         St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 83925 |  |  |  |  | Medtox Laboratories, Inc
FHYCD | [NAME] | URINE | [NAME] |  |  |  | Refrigerated
FHYCD | Result | Z1211 | Hydrocodone, U | Hydrocodone, U | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 68689d1269280046-auto-complete-in-a-data-validation-cell-technique-feedback-wanted-jbeaucaire
Sheet: Lists

A-Names | B-Names | C-Names | D-Names | E-Names | F-Names | << Named range List |  |  |  | Corrected First | Baines | Baines
Adam | Baines | Candy | [NAME] | [NAME] | Fanny |  |  |  | Adam | Letter Only | [NAME] | #N/A
Alfie | Betty | Cecil | [NAME] | Efram | Fay |  |  |  | [NAME]
Amanda | Billy | Cherise | [NAME] | Egrid | Felix |  |  |  | Alfie |  | Formula for Data Validation in L1:
[NAME] | [NAME] | [NAME] | Doreen | Eloise | [NAME] |  |  |  | [NAME] |  | Baines
[NAME] | [NAME] | Claudia | Drake | Eman | [NAME] |  |  |  | [NAME] |  | #N/A
[NAME] | Brent | Corinne | [NAME] | Ester | [NAME] |  |  |  | [NAME]
Axel | Byron | Cy | Dunston | Eunice | Fred |  |  |  | Axel
 |  |  |  |  |  |  |  |  | Baines
 |  |  |  |  |  |  |  |  | Betty
 |  |  |  |  |  |  |  |  | Billy
 |  |  |  |  |  |  |  |  | [NAME]
Named ranges AList, BList, etc…. |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Brent
 |  |  |  |  |  |  |  |  | Byron
 |  |  |  |  |  |  |  |  | Candy
 |  |  |  |  |  |  |  |  | Cecil
 |  |  |  |  |  |  |  |  | Cherise
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Claudia
 |  |  |  |  |  |  |  |  | Corinne
 |  |  |  |  |  |  |  |  | Cy
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Doreen
 |  |  |  |  |  |  |  |  | Drake
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Dunston
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Efram
 |  |  |  |  |  |  |  |  | Egrid
 |  |  |  |  |  |  |  |  | Eloise
 |  |  |  |  |  |  |  |  | Eman
 |  |  |  |  |  |  |  |  | Ester
 |  |  |  |  |  |  |  |  | Eunice
 |  |  |  |  |  |  |  |  | Fanny
 |  |  |  |  |  |  |  |  | Fay
 |  |  |  |  |  |  |  |  | Felix
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Fred
Spreadsheet: 813283d1673634421-sum-amount-based-on-reference-ef1595_summary_table
Sheet: Sheet1

 |  | Referance # | PF# | SW# | OT# | DATE | AMT | STATUS
 |  | 2014 |  |  |  | 2023-01-08 00:00:00 | 15.23 | Pending |  |  | SUM
 |  | 2014 |  |  |  | 2023-01-08 00:00:00 | 26.84 | Pending |  |  | Pending
 |  | 2014 |  |  |  | 2023-01-08 00:00:00 | 94.23 | Pending |  |  | Due
 |  | 2016 |  |  |  | 2023-01-09 00:00:00 | 17.35 | Due
 |  | 2016 |  |  |  | 2023-01-09 00:00:00 | 57.95 | Due
 |  | 2018 |  |  |  | 2023-01-10 00:00:00 | 156.6 | Due
 |  | 2019 |  |  |  | 2023-01-11 00:00:00 | 28 | Due
 |  | 2020 |  |  |  | 2023-01-12 00:00:00 | 32 | Pending
Spreadsheet: 34245d1231408122-vlookup-problem-108
Sheet: 108-3

 |  |  |  |  |  |  |  | IEC108-3-1
 |  |  |  |  |  |  |  | IEC108-3-2
 |  |  |  |  |  |  |  | IEC108-3-3
 |  |  |  |  |  |  |  | IEC108-3-4
 |  |  |  |  |  |  |  | IEC108-3-5
 |  |  |  |  |  |  |  | IEC108-3-6
 |  |  |  |  |  |  |  | IEC108-3-7
 |  |  |  |  |  |  |  | IEC108-3-8
 |  |  |  |  |  |  |  | IEC108-3-9
 |  |  |  |  |  |  |  | IEC108-3-10
 |  |  |  |  |  |  |  | IEC108-3-11
 |  |  |  |  |  |  |  | IEC108-3-12
 |  |  |  |  |  |  |  | IEC108-3-13
Spreadsheet: 170017d1343140896-search-from-list-of-cells-and-applying-corresponding-values-to-calculate-durationfile
Sheet: Sheet1

Label No. | Type | Start | End | Factor | Duration |  |  | Label | Start | End | Duration
1 | A | 0 | 5 |  |  |  |  | 1 | 3.2 | 4.7
1 | B | 5 | 8
1 | C | 8 | 15
2 | A | 0 | 3
2 | B | 3 | 6
2 | C | 6 | 11
3 | A | 0 | 1
3 | B | 1 | 6
3 | C | 6 | 8
4 | A | 0 | 2
4 | B | 2 | 6
4 | C | 6 | 13
5 | A | 0 | 3
5 | B | 3 | 4
5 | C | 4 | 5
6 | A | 0 | 9
6 | B | 9 | 17
6 | C | 17 | 27
7 | A | 0 | 8
7 | B | 8 | 15
7 | C | 15 | 22
Spreadsheet: 158691d1338352528-insert-numbers-in-a-column-based-on-the-data-in-another-column-reganomics18
Sheet: Sheet1

ID | Name | Count
AB723 | Word 1
AB723 | Word 2
[NAME] | Word 2
AB193 | Word 3
AB193 | Word 1
AB193 | Word 2
AB065 | Word 2
AB204 | Word 3
AB204 | Word 1
AB204 | Word 3
AB204 | Word 4
Spreadsheet: 737239d1624291889-digging-data-out-of-countif-results-help-forums-example
Sheet: Daily hours and adjustments

DAILY TIPS | 8 Hours = | Cage dep: | 6914 | 4565 | 8578
PAY PERIOD ENDING: | 2021-05-01 00:00:00 | DATE: |  |  |  | TOTAL
 |  |  | Sunday | Monday | Tuesday |  | Sunday | Monday | Tuesday
 |  | TOKES/HR |  |  |  | HOURS
NAME | ID # |  | ***RECORD HOURS ONLY*** |  |  |  | ****RECORD DOLLAR AMOUNTS ONLY*****
SMITH, JON | 234546 |  | 7 | 7 | 8
DREW, NANCY | 237554 |  | 8 | 8 | 8
AOL, NAPSTER | 123466 |  |  |  | 8
JIM, SONNY | 776655 |  | 16 | 7 | 8 |  | 10 | 10 | 10
TWO ,FORTY | 445566 |  | 8
SOZE, KAISER | 113355 |  | 7 | 7 | 8 |  |  | 15
TOP, ZEEZEE | 334455 |  | 8 | 8 |  |  |  | 25 |  |  | HEE
GUY, RANDOM | 112634 |  |  |  | 8 |  |  | 66.88
HUSTLE, KUNGFU | 566544 |  | 8 | 2.5 |  |  |  |  | 12
KEN, RYU | 172613 |  |  |  |  |  |  |  | 34
PARKER, CHARLIE | 776676 |  | 8 | 8 |  |  |  |  | 25
QUEST, EVER | 334422 |  | 8 | 8 | 8
NAME, SILLY | 111111 |  | 8 |  |  |  | 15
TIKTOK, MYSPACE | 666666 |  | 8 | 8 | 8
DAILY TOTALS: | [NAME]
Spreadsheet: 86925d1286879832-outstanding-balance-on-each-ref-no-pivot-table-ramzes
Sheet: Output

Ref no.: | Part | Stock
016453 | WBT2241OP3 | 0
014583 | WBT2241OP3 | 50
016823 | WBT2241OP3 | 540
015734 | WBT2241OP3 | 350
016453 | WBT2242OP3 | 250
014583 | WBT2242OP3 | 50
016823 | WBT2242OP3 | 800
015734 | WBT2242OP3 | 350
Spreadsheet: 52b84083-44da-4947-9548-082a20304711
Sheet: Sheet1

Unnamed: 0 | BALLOTS CAST | Unnamed: 2 | Unnamed: 3
 | Regular | Absentee | Total
1998-11-03 00:00:00
Belknap County | 14215 | 928 | 15143
Carroll County | 12942 | 1046 | 13988
Cheshire County | 19573 | 820 | 20393
Coos County | 9266 | 539 | 9805
Grafton County | 21107 | 1411 | 22518
Hillsborough County | 91793 | 4288 | 96081
Merrimack County | 41177 | 1959 | 43136
Rockingham County | 66546 | 3370 | 69916
Strafford County | 26235 | 1132 | 27367
Sullivan County | 11510 | 698 | 12208
Totals | 314364 | 16191 | 330555
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Knott

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 703007d1604669735-vlookup-for-duplicate-row-duplicate
Sheet: Sheet1

Country | City | Remark 1 | Remark 2 | Remark 3 |  |  | Result 1 |  |  |  |  |  |  | Result 2
France | Saint-Denis | 3 | 3 | 0 |  |  | Country | City | Remark 1 | Remark 2 | Remark 3 |  |  | Country | City | Remark 1 | Remark 2 | Remark 3
France | Reims | 0 | 0 | 0 |  |  | France | Saint-Denis | 3 | 3 | 0 |  |  | France | Reims | 0 | 0 | 0
France | Toulon | 2 | 8 | 0 |  |  | France | Toulon | 2 | 8 | 0 |  |  | France | Angers | 0 | 0 | 0
France | Angers | 0 | 0 | 0 |  |  | France | Le Mans | 2 | 9 | 0 |  |  | Russia | Moscow | 0 | 0 | 0
France | Le Mans | 2 | 9 | 0 |  |  | Russia | Krasnoyarsk | 3 | 3 | 0 |  |  | Russia | Kemerovo | 0 | 0 | 0
Russia | Moscow | 0 | 0 | 0 |  |  | Russia | Saint Petersburg | 1 | 1 | 0 |  |  | UK | Birmingham | 0 | 0 | 0
Russia | Saint Petersburg | 1 | 1 | 0 |  |  | Russia | Krasnodar | 1 | 5 | 0 |  |  | UK | Cambridge | 0 | 0 | 0
Russia | Krasnoyarsk | 3 | 3 | 0 |  |  | UK | Bradford | 2 | 6 | 0 |  |  | USA | TEXAS | 0 | 0 | 0
Russia | Krasnodar | 1 | 5 | 0 |  |  | UK | Bristol | 1 | 1 | 0 |  |  | USA | Los Angeles | 0 | 0 | 0
Russia | Kemerovo | 0 | 0 | 0 |  |  | UK | Carlisle | 1 | 1 | 0 |  |  | USA | Indianapolis | 0 | 0 | 0
UK | Birmingham | 0 | 0 | 0 |  |  | USA | Columbus | 2 | 2 | 0
UK | Bradford | 2 | 6 | 0 |  |  | USA | Denver | 2 | 2 | 0
UK | Bristol | 1 | 1 | 0 |  |  | USA | NEW YORK | 1 | 9 | 0
UK | Cambridge | 0 | 0 | 0
UK | Carlisle | 1 | 1 | 0
USA | NEW YORK | 1 | 9 | 0
USA | TEXAS | 0 | 0 | 0
USA | Los Angeles | 0 | 0 | 0
USA | Columbus | 2 | 2 | 0
USA | Indianapolis | 0 | 0 | 0
USA | Denver | 2 | 2 | 0
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: ZEN

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
ZEN WTR 12/1.5L | 08895 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ** 6 pack 1L
ZEN WTR 12/16.9Z BTL | 08896
ZEN WTR 12/23.7Z BTL | 08894
ZEN WTR 12/33.8Z BTL | 08893
ZEN WTR 2/6/33.8Z BTL | 08897
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
ZEN WTR 12/1.5L | 08895
ZEN WTR 12/16.9Z BTL | 08896
ZEN WTR 12/23.7Z BTL | 08894
ZEN WTR 12/33.8Z BTL | 08893
ZEN WTR 2/6/33.8Z BTL | 08897
Spreadsheet: 38103d1236208925-data-print-eleg-fee-collection
Sheet: Print

1.Parent Copy |  |  |  |  |  |  | 2.School Copy |  |  |  |  |  |  | 3.Bank Copy
To, |  |  |  |  |  |  | To, |  |  |  |  |  |  | To,
HBL |  |  |  |  |  |  | HBL |  |  |  |  |  |  | HBL
Please credit : |  |  |  |  |  |  | Please credit : |  |  |  |  |  |  | Please credit :
The Elegance school |  | Dated |  |  |  |  | The Elegance school |  | Dated |  |  |  |  | The Elegance school |  | Dated
A/C No: 997-19 |  | 21/04/2008 |  |  |  |  | A/C No: 997-19 |  | 21/04/2008 |  |  |  |  | A/C No: 997-19 |  | 21/04/2008
Student Name : |  | [NAME] |  |  |  |  | Student Name : |  | [NAME] |  |  |  |  | Student Name : |  | [NAME]
 |  | M.Ayaz |  |  |  |  |  |  | M.Ayaz |  |  |  |  |  |  | M.Ayaz
G.R. No |  | 1 | Ad No | 700 |  |  | G.R. No |  | 0 | Ad No | 700 |  |  | G.R. No |  | 1 | Ad No | 700
Class : |  | Prep Green |  |  |  |  | Class : |  | Prep Green |  |  |  |  | Class : |  | Prep Green
Fee For : |  |  |  |  |  |  | Fee For : |  | 0 |  |  |  |  | Fee For : |  | 0
Particulars |  |  |  | Amount(Rs.) |  |  | Particulars |  |  |  | Amount(Rs.) |  |  | Particulars |  |  |  | Amount(Rs.)
Admission Fee |  |  |  | 0 |  |  | Admission Fee |  |  |  | 0 |  |  | Admission Fee |  |  |  | 0
Monthly Fee |  |  |  | 510 |  |  | Monthly Fee |  |  |  | 510 |  |  | Monthly Fee |  |  |  | 510
Annual Fee |  |  |  | 300 |  |  | Annual Fee |  |  |  | 300 |  |  | Annual Fee |  |  |  | 300
Examination Fee |  |  |  | 0 |  |  | Examination Fee |  |  |  | 0 |  |  | Examination Fee |  |  |  | 0
Computer Fee |  |  |  | 0 |  |  | Computer Fee |  |  |  | 0 |  |  | Computer Fee |  |  |  | 0
Laboratory Fee |  |  |  | 0 |  |  | Laboratory Fee |  |  |  | 0 |  |  | Laboratory Fee |  |  |  | 0
Other Fee |  |  |  | 0 |  |  | Other Fee |  |  |  | 0 |  |  | Other Fee |  |  |  | 0
Book+Note Books |  |  |  | 500 |  |  | Book+Note Books |  |  |  | 500 |  |  | Book+Note Books |  |  |  | 500
Security Fee(Refund able) |  |  |  | 500 |  |  | Security Fee(Refund able) |  |  |  | 500 |  |  | Security Fee(Refund able) |  |  |  | 500
 |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
Arrears |  |  |  | 0 |  |  | Arrears |  |  |  | 0 |  |  | Arrears |  |  |  | 0
Total : |  |  |  | 1810 |  |  | Total : |  |  |  | 1810 |  |  | Total : |  |  |  | 1810
Less Discount : |  |  |  | 0 |  |  | Less Discount : |  |  |  | 0 |  |  | Less Discount : |  |  |  | 0
 |  | Before Due Date : |  | 1810 |  |  |  |  | Before Due Date : |  | 1810 |  |  |  |  | Before Due Date : |  | 1810
 |  | After Due Date : |  | 1885 |  |  |  |  | After Due Date : |  | 1885 |  |  |  |  | After Due Date : |  | 1885
 |  | Due Date : |  | 18/10/2008 |  |  |  |  | Due Date : |  | 18/10/2008 |  |  |  |  | Due Date : |  | 18/10/2008
Fee if not paid upto 15th of month Rs. 75/- fine payable. |  |  |  |  |  |  | Fee if not paid upto 15th of month Rs. 75/- fine payable. |  |  |  |  |  |  | Fee if not paid upto 15th of month Rs. 75/- fine payable.
Bank (signature & Stamp) |  |  |  |  |  |  | Bank (signature & Stamp) |  |  |  |  |  |  | Bank (signature & Stamp)
Spreadsheet: 85043d1285105849-graph-labels-scatter-example
Sheet: Sheet1

 |  |  | x plot | y plot | x label | y label
 |  | A | 1 | 2 | 1 | 2
 |  | B | 2 | 4 | 2 | 4
 |  | C | 3 | 6 | 3 | 6
 |  | D | 4 | 8 | 4 | 8
Spreadsheet: 698493d1602003898-find-column-values-in-rows-and-retrieve-result-index-match-example
Sheet: Feuil1

 |  |  |  |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8
 | Week 1 | 2221
 | Week 2 | 1704
 | Week 3 | 1516
 | Week 4 | 1461
 | Week 5 | 109
 | Week 6 | 776
 | Week 7 | 1687
 | Week 8 | 1320
Spreadsheet: e5533742-5f43-481e-8b32-68ceab193052
Sheet: G5.  Illustrative Rates

Exhibit G5:  Illustrative Rates
[NAME]:
Plan Type(s):
Market Segment:
Rate Effective Date:
Individual Example 1: | Employee Only Rate
Individual Example 2: | Family Rate
Small Group Example 1: | Employee Only Rate
 | Dual Rate
 | Employee + Child(ren) Rate
 | Family Rate
Small Group Example 2: | Employee Only Rate
 | Dual Rate
 | Employee + Child(ren) Rate
 | Family Rate
 | Small Group Example 1 Census:
 |  | Employee Census
 | Subscriber Age | Single | Dual | Employee + Child (ren) | Family | Total
 | 19 |  |  | 1 |  | 1
 | 24 | 2 |  |  |  | 2
 | 32 |  | 2 |  | 1 | 3
 | 37 |  |  | 1 | 1 | 2
 | 40 |  | 1 |  | 1 | 2
 | 47 | 3 | 2 |  | 3 | 8
 | 52 | 2 | 1 |  |  | 3
 | 59 |  | 1 |  |  | 1
 | 64 | 1 |  |  |  | 1
 | Total
 | Small Group Example 2 Census:
 |  | Employee Census
 | Subscriber Age | Single | Dual | Employee + Child (ren) | Family | Total
 | 47 | 1 |  |  |  | 1
 | 52 |  |  |  | 1 | 1
 | 59 | 1 | 1 |  |  | 2
 | 64 | 1 |  | 1 |  | 2
 | Total
Spreadsheet: cara_semperger__1451__ENA_PGE_DEC08_2001
Sheet: LOSSES

From: | EPMI
To: | PGE System Transactions
Date:
HE
ENDING | TOTAL |  | TOTAL
Pacific
Prevailing
Time | NO SCHEDULE POSTED | THIS IS AN UNDER-RETURN
(PPT)
0100
0200
0300
0400
0500
0600
0700
0800
0900
1000
1100
1200
1300
1400
1500
1600
1700
1800
1900
2000
2100
2200
2300
2400
 | PGE | PGE | PGE
 | REAL POWER LOSSES | PGE LOSSES | [NAME] [NAME]
 | PGE | PGE | PGE
 | 640902
 | 640903
 | NEW COLUMN
Spreadsheet: 861259d1709190028-ranking-no-duplicates-wk9128-ans
Sheet: Sheet1

 | [NAME] | [NAME] | wk9128 | Expected results
2.633333333333333
0.9523809523809523
0.07142857142857142
0.1428571428571428
1.130952380952381
2.873809523809524
1
1
1
Spreadsheet: 200444d1355548334-drop-down-boxes-quick-data-validation-tutorial
Sheet: Sheet1

Shift 1 | [NAME] |  |  | Employees
Shift 2 | [NAME] |  |  | [NAME] | <---- | To create a named range here, select cells G2:G7.
Shift 3 | [NAME] |  |  | [NAME] |  | Over to the top-left, where you see the cell address of the current cell
 |  |  |  | [NAME] |  | Like A5, or J2.. Click in that box and type:  Employees
 |  |  |  | Al |  | Then hit Enter
 |  |  |  | [NAME]
 |  |  |  | [NAME] |  | Once that is done, select cells B1:B3, and go to the DATA tab.
 |  |  |  |  |  | Click on Data Validation.
 |  |  |  |  |  | For 'Allow' choose 'List', and make sure 'In cell Drop-Down' is checked
 |  |  |  |  |  | In the 'Source' box, type in:  =Employees
 |  |  |  |  |  | Click OK
 |  |  |  |  |  | You now can select an employee name in cells B1:B3.  =)
Spreadsheet: rick_buy__32925__Group_Netco_MarketRisk
Sheet: EOL Support

 | EOL Support
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  |  |  | Per HC | New HC | Adj Comp | 2002
 |  | YTD Actual |  | Forecast |  | Forecast |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  |  |  | Compensation | 0
 | Analyst & Associate | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  | 0 |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  | 0 |  |  |  | [NAME] | 36000 | 0
ENARENT | Rent |  |  |  |  | 0 |  |  |  | Admins | 48000 | 2
ENATECH | Technology |  |  |  |  |  |  |  |  | Staff | 49200 | 7
ENATRANS | Transportation |  |  |  |  | 0 |  |  |  | Analysts | 57600 | 3
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  |  | Specialist | 62400 | 8
ENATAXES | Taxes Other than Income |  |  |  |  | 0 |  |  |  | Sr Specialist | 74400 | 7
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  |  | Managers | 96000 | 8
 |  |  |  |  |  |  |  |  |  | Directors | 120000 | 3
 | Headcount |  |  | 114 |  |  |  |  |  | Sr Director | 156000 | 0
 |  |  |  |  |  |  |  |  |  | Vice President | 204000 | 1
 | A&A Headcount |  |  | 4 |  |  |  |  |  | [NAME] | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  |  |  |  | Based on information from ENW accounting.
Spreadsheet: 108388d1305441711-if-a-cell-in-a-column-in-any-worksheet-x-copy-entire-row-budget_update
Sheet: Other

Other
 |  |  |  |  | Total Other Budget | Spent So Far | Total Remaining
 |  |  |  |  | 100 | 73.59 | 26.41
Date | Location | Memo | Method | Amount
2011-04-29 00:00:00 | Walmart |  | DISC | 10.22
2011-04-30 00:00:00 | Shopko |  | DISC | 3.49
2011-05-02 00:00:00 | Target |  | DISC | 59.88
Spreadsheet: tracy_geaccone__40534__NNGOrgPLFormatCORP02
Sheet: AssetSale

DETAILS OF PROCEEDS FROM SALE OF ASSETS
Non-Merchant Activities
(Millions of Dollars)
 | PROCEEDS FROM SALE OF ASSETS
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
MOPS | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 7.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Unidentified | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Miscellaneous
Total (line 125)
 | Date |  | Gross |  | (F. Flow) |  | Net |  | Book |  | Gain /
 | of Sale |  | Proceeds |  | Cur. Tax |  | Proceeds |  | Basis |  | Loss
 |  |  |  |  | -2.2 |  |  |  | 0
 |  |  |  |  | -2 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
Spreadsheet: 676048d1588621482-join-rows-and-columns-for-graphs-join
Sheet: Content2

 | Method1 | Method2 |  | Method3 | Method4 |  | Method5
Equipment | Sub-Method 1 | Sub-Method2 | Sub-Method3 | Sub-Method4 | Sub-Method5 | Sub-Method6 | Sub-Method7 | Sub-Method8
Bike | 1 | 4 | 4 | 3 | 1 | 4 | 2 | 1
Car | 2 | 2 | 2 | 3 | 1 | 3 | 1 | 2
Bicycle | 1 | 3 | 1 | 2 | 3 | 2 | 1 | 3
Boat | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 3
Spreadsheet: 65737d1266422450-comparison-get-a-correct-score-uclpl0910
Sheet: Sheet1

 |  | My Prediction |  |  |  | His Prediction |  |  |  | ACTUAL SCORE |  |  |  | My Score |  | His Score
AC Milan | Man Utd | 1 | - | 1 |  | 1 | - | 0 |  | 2 | - | 3
Lyon | Real Madrid | 1 | - | 4 |  | 0 | - | 2 |  | 1 | - | 0
Bayern Munich | Fiorentina | 3 | - | 1 |  |  | - |  |  |  | -
Porto | Arsenal | 0 | - | 2 |  |  | - |  |  |  | -
Olympiakos | Bordeaux | 1 | - | 1 |  |  | - |  |  |  | -
Stuttgart | Barcelona | 0 | - | 3 |  |  | - |  |  |  | -
CSKA Moscow | Sevilla | 0 | - | 1 |  |  | - |  |  |  | -
Inter Milan | Chelsea | 1 | - | 2 |  |  | - |  |  |  | -