tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 7e0123bb-2f09-415a-95a8-0af3745b5c1c
Sheet: Sheet1

2452 Nyársapát-Cegléd | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
(Érvényes: 2011. december 11-től)
Km | Km | Km | Km | VOLÁNBUSZ Zrt. | 2
 |  |  |  |  | I
0 | .. | .. | .. | [NAME], aut.ford. | 15:45:00
1 | .. | .. | .. | Nyársapát, kh. bej.út | 15:47:00
1.7 | .. | .. | .. | Nyársapát, iskola | 15:48:00
2.4 | .. | .. | .. | Nyársapáti elág. | 15:50:00
3.6 | .. | .. | .. | Hosszúdűlő | 15:51:00
4.6 | .. | .. | .. | Csemői bekötő út | 15:52:00
5.5 | .. | .. | .. | T.Nagy tanya | 15:53:00
6.4 | .. | .. | .. | Róna telep | 15:54:00
7.3 | .. | .. | .. | Hoffer telep | 15:55:00
8.5 | .. | 0 | .. | 12. sz. v.bolt | 15:56:00
S | .. | 1.1 | .. | Vett úti általános iskola | S
S | .. | 2 | .. | Csemői sertéstelep | S
S | .. | 3.4 | .. | Csemő, régi vmh. | S
S | .. | 3.9 | .. | Csemő, kh. | S
S | .. | 3.4 | .. | Csemő, régi vmh. | S
S | .. | 2 | .. | Csemői sertéstelep | S
S | .. | 1.1 | .. | Vett úti általános iskola | S
8.5 | .. | 0 | .. | 12. sz. v.bolt | 15:56:00
9.4 | .. | .. | .. | Csemő, Határ út | 15:58:00
9.9 | .. | .. | .. | Szabad Föld Tsz. | 15:59:00
11.2 | .. | .. | .. | [NAME] dűlő | 16:00:00
12 | .. | .. | .. | [NAME] dűlő | 16:01:00
12.7 | .. | .. | .. | 2-es km-kő | 16:02:00
13.9 | .. | .. | .. | [NAME] dűlő | 16:03:00
14.6 | .. | .. | .. | Vett út | 16:04:00
16 | .. | .. | .. | Cegléd, VOLÁNBUSZ telep | 16:06:00
16.3 | .. | .. | .. | Cegléd, köztemető | 16:07:00
16.7 | .. | .. | .. | Cegléd, Vásár tér | 16:08:00
17.4 | .. | .. | .. | Cegléd, [NAME] | 16:10:00
17.9 | .. | .. | .. | Cegléd, Síp u. | 16:11:00
18.5 | .. | .. | .. | Cegléd, posta | 16:13:00
19.3 | .. | .. | .. | Cegléd, Gimnázium u. | 16:15:00
20.1 | .. | .. | .. | Cegléd, aut. áll. | [NAME]
[NAME]:
I | tanítási napokon
S | a járat nem érinti a megállóhelyet, [NAME]
Spreadsheet: 806498d1669348644-match-partial-or-complete-text-and-match-in-another-column-to-extract-index-value-help
Sheet: INDEX-MATCH1

 |  |  | need to match partial title and chn and bring value from index column
 | Employee |  |  | =INDEX(F$7:F$11,MATCH(TRUE,ISNUMBER(SEARCH(B$6:[NAME]))
 | title | chn | expected result | current formula I have | lookup data
 | [NAME] | AAA | Kaisi |  | index value | chn
 | Siyan | GGG | siyani |  | Kaisi | AAA
 | Farq E | AAA | farq |  | siyani | GGG
 | Habs Ep | AAA | habs |  | farq | AAA
 | magar | HHH |  |  | habs | AAA
 | [NAME] | GGG | agar |  | agar | GGG
 | [NAME] | AAA | Kaisi
 | [NAME] | GGG
Spreadsheet: 454101d1459635609-improve-my-index-match-please-more-than-max
Sheet: Sheet1

 |  |  |  |  |  | 1 | 2 | 3 | 4
 | X | X | X |  | 1 | A | A | A | A |  | Col 1 win |  |  | Back 1,1 win |  |  | Row 1 win |  |  | Back 1 win |  |  | Diag 1 win
 | O | O |  |  | 2 |  |  |  |  |  | Col 2 win |  |  | Back 2,2 win |  |  | Row 2 win |  |  | Back 2 win |  |  | Diag 2 win
 | X |  | O |  | 3 |  |  |  |  |  | Col 3 win |  |  | Back 3,3 win |  |  | Row3 win |  |  | Back3 win
 |  |  |  |  | 4 |  |  |  |  |  | Col 4 win |  |  | Back 4,4 win |  |  | Row4 win |  |  | Back4 win
 |  |  |  |  |  | 5 | 6 | 7 | 8 |  | Col 5 win |  |  |  |  |  | Row5 win
Turn |  | Winner |  |  | 5 |  |  |  |  |  | Col 6 win |  |  |  |  |  | Row 6 win
 |  |  |  |  | 6 | A | A | A | A |  | Col 7 win |  |  |  |  |  | Row 7 win
A |  |  |  |  | 7 |  |  |  |  |  | Col 8 win |  |  |  |  |  | Row 8 win
B |  |  |  |  | 8 |  |  |  |  |  | Col 9 win |  |  |  |  |  | Row 9 win
C |  |  |  |  |  | 9 | 10 | 11 | 12 |  | Col 10 win |  |  |  |  |  | Row 10 win
D |  |  |  |  | 9 |  |  |  |  |  | Col 11 win |  |  |  |  |  | Row 11 win
 |  |  |  |  | 10 |  |  |  |  |  | Col 12 win |  |  |  |  |  | Row 12 win
 |  |  |  |  | 11 | A | A | A | A |  | Col 13 win |  |  |  |  |  | Row 13 win
 |  |  |  |  | 12 |  |  |  |  |  | Col 14 win |  |  |  |  |  | Row 14 win
 |  |  |  |  |  | 13 | 14 | 15 | 16 |  | Col 15 win |  |  |  |  |  | Row 15 win
 |  |  |  |  | 13 |  | D | D | D |  | Col 16 win |  |  |  |  |  | Row 16 win
 |  |  |  |  | 14
 |  |  |  |  | 15
 |  |  |  |  | 16 | A | A | A | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 2 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 3 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 4 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 5 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 6 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 7 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 8 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 9 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 10 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 11 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 12 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 13 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 14 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 15 win
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back Col 16 win
Spreadsheet: 165359d1341195777-look-values-with-a-twist-excel_dumbo_841760-look-values-with-a-twist_01jul12_01
Sheet: Data

Account | Cost Center | Amount | Amount
1006109 | X | 0 | 2461.62
1006109 | X | 0 | 262776.51
1006109 | X | 0 | 103308
2203015 | X | 0 | 648.38
2206001 | X | 0 | 35226.13
2206001 | SS | 0 | 10179.58
5000001 | 1405801100 | 8861.25 | 0
5000001 | 1505800650 | 37980.95 | 0
5000001 | 1705800001 | 58436.78 | 0
5000001 | 1705800002 | 130282.09 | 0
5000001 | 1705800012 | 10081.42 | 0
5000001 | 1705800022 | 26357 | 0
5000001 | 1805800005 | 6988.5 | 0
5000001 | 1805800018 | 23385.01 | 0
5000001 | 1805800035 | 6524.8 | 0
5000001 | 1805807100 | 11818.58 | 0
5000001 | 1905800002 | 17259.92 | 0
5000001 | 2305800001 | 19736.79 | 0
5010015 | 1405801100 | 3545 | 0
5010015 | 1505800650 | 6779 | 0
5010015 | 1805800018 | 3803 | 0
5010015 | 1805807100 | 5352 | 0
5010015 | 2305800001 | 2182 | 0
5030008 | 1405801100 | 1205.17 | 0
5030008 | 1505800650 | 4017.03 | 0
5030008 | 1705800001 | 5070.39 | 0
5030008 | 1705800002 | 12388.41 | 0
5030008 | 1705800012 | 839.74 | 0
5030008 | 1705800022 | 2372.13 | 0
5030008 | 1805800005 | 936.4 | 0
5030008 | 1805800018 | 2697.59 | 0
5030008 | 1805800035 | 628.43 | 0
5030008 | 1805807100 | 1663.54 | 0
5030008 | 1905800002 | 1482.26 | 0
5030008 | 2305800001 | 1925.04 | 0
Spreadsheet: 77443d1277912394-extract-room-number-and-student-id-and-put-them-in-other-cells-studenthousing-3-
Sheet: 3709

Building No:- 3709 | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Dr. [NAME]
Date | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo
2010-06-30 00:00:00 | 11B | 11B | 11B | 24B | 33B
OUTSTANDING
SATISFACTORY
UNSATISFACTORY
DOOR UNLOCKED
WINDOW UNLOCKED
LOCKER UNLOCKED
CARPET Not SWEPT
DUST
BEDS UNMADE
MESSY
MICROWAVE DIRTY
FREEZER DIRTY
REFRIGERATOR DIRTY
LIGHTS / APPLIANCES ON
CEILING FAN ON
OPEN FOOD NOT STORED
TRASH IN ROOM / HEAD
MIRROR / SHELF DIRTY
SINK / BRIGHTWORK DIRTY
FLOOR IN BATH DIRTY
TUB / SHOWER DIRTY
SHOWER CURTAIN DIRTY
TOILET DIRTY
ODOR
Dirty TILE
Spreadsheet: 703377d1604960523-help-to-calculate-discounted-price-per-item-based-on-table-on-same-page-tester-1
Sheet: Master 

S No. | Product Name | Unit Price | Ideal Inventory | Available Stock
1 | 00-BM-A-1A | 4 | 20
2 | 00-BM-A-1B | 4 | 20
3 | 00-BM-A-1C | 4 | 20
4 | Bracelet 4 | 4 | 20
5 | Bracelet 5 | 6 | 20
6 | Bracelet  6 | 18 | 15
7 | Necklace 1 | 5 | 15
8 | Necklace 2 | 5 | 15
9 | Necklace 3 | 6 | 15
10 | Necklace 4 | 6 | 10
11 | Necklace 5 | 8 | 10
12 | Necklace 6 | 8 | 10
13 | Necklace 7 | 10 | 10
14 | Bookmarks 1 | 3 | 30
15 | Bookmarks 2 | 2 | 20
16 | Bookmarks 3 | 2 | 20
17 | Bookmarks 4 | 4 | 20
18 | Bead 1 | 8 | 10
19 | Bead 2 | 10 | 10
20 | Bead 3 | 12 | 10
21 | Bead 4 | 7 | 15
22 | Bead 5 | 7 | 15
23 | Bead 6 | 8 | 15
24 | Bead 7 | 8 | 15
25 | Bead 8 | 10 | 15
26 | Paint 1 | 10 | 1
27 | Paint 2 | 15 | 1
28 | Paint 3 | 20 | 1
29 | Paint 4 | 25 | 1
30 | Paint 5 | 18 | 1
31 | Paint 6 | 12 | 1
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 149104d1333698681-if-with-choices-if_choice_example
Sheet: Sheet1

Yes | Yes | Yes | Yes
N | N | NO | N
Yes | Yes | Yes | Yes
N | NO | NO | NO
N | NO | NO | N
N | NO | NO | NO
N | NO | NO | NO
N | NO | NO | NO
N | NO | N | NO
N | N | NO | NO
N | NO | N | NO |  |  |  |  |  | Here there are 12 entries in column A where 10 have "N" and 2 have "Yes". My column need to look at Column A and print based on the rule if (column A = "yes", "yes", if(rand()<0.2,"N", "NO")). Here colmuns B, C, D are all valid. There are many more possibilities. My intent is to pick one of the many possibilities. I would like to avoid the rand function for this.
N | NO | NO | NO
Spreadsheet: 164133d1340655427-excel-2007-need-help-pulling-info-from-several-tabs-into-one-final-tab-orders
Sheet: Sat

STORE #
STORE |  |  |  |  |  | Date: | 2012-06-23 00:00:00
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
STORE #
STORE
ORDER #
# of Pages
Puller |  |  |  | QA |  |  |  | Stacker |  |  |  |  | TOTAL
Start |  |  |  | Start |  |  |  | Start
End |  |  |  | End |  |  |  | End
Total |  |  |  | Total |  |  |  | Total
 | Over Pack | Full Case | Total
Units
Lines
Cartons
Spreadsheet: 553189d1514022947-connecting-data-from-many-cells-based-level-bieuthue2017-gk
Sheet: Sheet2

MÃ HS | length hs | category | MÔ TẢ HÀNG HÓA | ĐƠN VỊ | DESCRIPTIONS
84.18 | 4 | Cold Chain | Tủ lạnh, tủ kết đông và thiết bị làm lạnh hoặc kết đông khác, loại dùng điện hoặc loại khác; bơm nhiệt trừ máy điều [NAME] nhóm 84.15. |  | Refrigerators, freezers and other refrigerating or freezing equipment, electric or other; heat pumps other than air conditioning machines of heading 84.15.
8418.10 | 6 | Cold Chain | - Tủ kết đông lạnh liên [NAME] thiết bị có buồng làm đá và làm lạnh riêng biệt), có các cửa mở riêng biệt: |  | - Combined refrigerator-freezers, fitted with separate external doors:
8418.30 | 6 | Cold Chain | - Tủ kết đông , loại cửa trên, dung tích không quá 800 lít: |  | - Freezers of the chest type, not exceeding 800 l capacity:
8418.40 | 6 | Cold Chain | - Tủ kết đông , [NAME], dung tích không quá 900 lít: |  | - Freezers of the upright type, not exceeding 900 l capacity:
8418.50 | 6 | Cold Chain | [NAME] có kiểu dáng nội thất khác (tủ, tủ ngăn, quầy hàng, tủ bày hàng và loại tương tự) để bảo quản và [NAME], có [NAME] lạnh hoặc [NAME] đông: |  | - Other furniture (chests, cabinets, display counters, show-cases and the like) for storage and display, incorporating refrigerating or freezing equipment:
8418.69 | 6 | Cold Chain | - - Loại khác: |  | - - Other:
8418.99 | 6 | Cold Chain | - - Loại khác: |  | - - Other:
Spreadsheet: 770326d1645993521-indirect-list-help-excelhelp
Sheet: Week 2

 |  |  |  | Week 2
 |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  | [NAME] |  |  |  |  |  | Day Off
 |  |  | [NAME] |  |  |  |  | Day Off
 |  |  | [NAME] |  |  |  | Day Off
 |  |  | Helen |  |  | Day Off
 |  |  | Emily |  | Day Off
 |  |  | [NAME] | Day Off
 |  |  | [NAME] |  |  |  |  |  | Day Off
 |  |  | [NAME] |  |  |  |  | Day Off
 |  |  | [NAME] |  |  |  | Day Off
 |  |  | Trevor |  |  | Day Off
Spreadsheet: 235938d1368642422-excel-how-to-automatically-fill-blank-fields-book1
Sheet: Sheet1

[NAME] | Smith | Blue Group | 2.2 | 45467
 |  |  | 3.4
 |  |  | 6.6
[NAME] | Jones | Green Group | 2.4 | 45767
Helena | [NAME] | Green Group | 2.2 | 45678
Ash | Addleton | Blue Group | 2.3 | 45443
 |  |  | 7.2
 |  |  | 6.4
Bertie | Blogg | Yellow Group | 5.7 | 66778
 |  |  | 4.5
Spreadsheet: 0497bc3f-fdab-4396-93c8-3de2350afe57
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0015931 | Unnamed: 3 | Facility Name: | Unnamed: 5 | The Village at the Point | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Iredell | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder
Monthly Limit: |  |  | 25000
Daily Limit:
Sample Frequency: |  |  | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 184152d1349165850-calculating-the-number-of-days-0a1_fot_example2-1-
Sheet: Sheet1

Route | Exercise | Type | Day | Date | Month | Year | Wk | Distance (Miles) | Time (mins sec) | Run No. This Year | Days Since Last Run | Total Weeks Run Miles | Cycle No. This Year | Days Since Last Cycle | Total Weeks Cycle Miles
Track 2x500m, 3x1k, 2x500m | Run | Reps | Tue | 25 | September | 2012 | 39 | 4.97 | 35.11
Torquay-Newton Abbot | Cycle | Ride | Sat | 22 | September | 2012 | 38 | 14.03 | 67.12
Track Pyramid | Run | Reps | Thu | 20 | September | 2012 | 38 | 5.64 | 49.4
Track 2x1 mile, 3x800m, 4x400m | Run | Reps | Tue | 18 | September | 2012 | 38 | 6.17 | 49.36
Home-Paignton | Cycle | Ride | Mon | 17 | September | 2012 | 38 | 12.32 | 45.12
[NAME] | Run | Run | Sun | 16 | September | 2012 | 37 | 14.52 | 117.18
[NAME] | Cycle | Ride | Fri | 14 | September | 2012 | 37 | 5.22 | 36.45 | 1 |  |  | 1
Spreadsheet: 412147d1438873815-how-to-count-consecutive-dates-for-each-employee-from-a-listing-of-absence-dates-book1-1-
Sheet: Sheet1

Leaves List by Employee
Employee: | Start | End
[NAME] | 2014-06-16 00:00:00 | 2014-06-16 00:00:00
[NAME] | 2014-06-17 00:00:00 | 2014-06-17 00:00:00
[NAME] | 2014-04-04 00:00:00 | 2014-04-04 00:00:00
[NAME] | 2014-04-05 00:00:00 | 2014-04-05 00:00:00
[NAME] | 2014-04-06 00:00:00 | 2014-04-06 00:00:00
[NAME] | 2014-05-02 00:00:00 | 2014-05-02 00:00:00
[NAME] | 2014-04-04 00:00:00 | 2014-04-04 00:00:00
[NAME] | 2014-04-05 00:00:00 | 2014-04-05 00:00:00
[NAME] | 2014-04-06 00:00:00 | 2014-04-06 00:00:00
[NAME] | 2014-04-07 00:00:00 | 2014-04-07 00:00:00
[NAME] | 2014-04-11 00:00:00 | 2014-04-11 00:00:00
[NAME] | 2014-04-12 00:00:00 | 2014-04-12 00:00:00
[NAME] | 2014-04-13 00:00:00 | 2014-04-13 00:00:00
[NAME] | 2014-04-14 00:00:00 | 2014-04-14 00:00:00
DJ | 2014-12-12 00:00:00 | 2014-12-12 00:00:00
DJ | 2014-12-13 00:00:00 | 2014-12-13 00:00:00
DJ | 2014-12-14 00:00:00 | 2014-12-14 00:00:00
BADUAN | 2015-04-28 00:00:00 | 2015-04-28 00:00:00
BADUAN | 2015-04-29 00:00:00 | 2015-04-29 00:00:00
BADUAN | 2015-04-30 00:00:00 | 2015-04-30 00:00:00
BARBAY | 2015-04-20 00:00:00 | 2015-04-20 00:00:00
Beavers | 2015-04-08 00:00:00 | 2015-04-08 00:00:00
Beavers | 2015-04-22 00:00:00 | 2015-04-22 00:00:00
BROUSSARD | 2015-04-29 00:00:00 | 2015-04-29 00:00:00
BROWN | 2015-04-22 00:00:00 | 2015-05-10 00:00:00
Camery | 2015-04-23 00:00:00 | 2015-04-23 00:00:00
Camery | 2015-04-24 00:00:00 | 2015-04-24 00:00:00
EPPERLY | 2015-04-06 00:00:00 | 2015-04-06 00:00:00
EPPERLY | 2015-04-10 00:00:00 | 2015-04-10 00:00:00
EPPERLY | 2015-04-11 00:00:00 | 2015-04-11 00:00:00
EPPERLY | 2015-04-12 00:00:00 | 2015-04-12 00:00:00
EPPERLY | 2015-04-14 00:00:00 | 2015-04-14 00:00:00
Fenner | 2015-04-08 00:00:00 | 2015-04-08 00:00:00
Fenner | 2015-04-09 00:00:00 | 2015-04-09 00:00:00
Fenner | 2015-04-13 00:00:00 | 2015-04-13 00:00:00
Fenner | 2015-04-14 00:00:00 | 2015-04-14 00:00:00
Fenner | 2015-04-15 00:00:00 | 2015-04-15 00:00:00
Guidry | 2015-04-11 00:00:00 | 2015-04-11 00:00:00
Lafleur | 2015-04-23 00:00:00 | 2015-04-23 00:00:00
LANDRY | 2015-04-27 00:00:00 | 2015-04-27 00:00:00
LANGSTON | 2015-04-27 00:00:00 | 2015-04-27 00:00:00
LANGSTON | 2015-04-28 00:00:00 | 2015-04-28 00:00:00
LANGSTON | 2015-04-29 00:00:00 | 2015-04-29 00:00:00
LANGSTON | 2015-04-30 00:00:00 | 2015-04-30 00:00:00
[NAME] | 2015-03-31 00:00:00 | 2015-05-01 00:00:00
MORRIS | 2015-04-27 00:00:00 | 2015-05-10 00:00:00
NUNNELLY | 2015-04-06 00:00:00 | 2015-04-06 00:00:00
NUNNELLY | 2015-04-07 00:00:00 | 2015-04-07 00:00:00
NUNNELLY | 2015-04-08 00:00:00 | 2015-04-08 00:00:00
NUNNELLY | 2015-04-09 00:00:00 | 2015-04-09 00:00:00
NUNNELLY | 2015-04-17 00:00:00 | 2015-04-17 00:00:00
NUNNELLY | 2015-04-18 00:00:00 | 2015-04-18 00:00:00
Spreadsheet: 45b794e0-1c13-4854-82b9-2793680adbc1
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 | Energy Savings Calculator
 | Pumping Energy Cost Comparison for Primary Elements based on Permanent Pressure Loss (PPL)
 | Summary of Input Data
 |  | [NAME]: | Air |  | [NAME] | 120000 | Scf/hr | Scf
 |  | [NAME]: | 8 In (200mm) | Std. Sch. | Normal/Average Flow | 96720 | Scf/hr | hr
 |  | Power Cost | 0.075 | $/KWH | Process Pressure | 850 | psig
 |  | Flowing Density | 1.809505939483643 | lb/ft3 | Process Temperature | 830 | F
 |  | 8 In (200mm)Velocity @Max. Flow | 4.046830654144287 | Feet/Sec.
 |  |  | $ | KWH
 | Primary Element Comparison Results
 |  | Primary Element | DP in | inH2O | PPL in | inH2O | Annual Value of PPL |  | Savings from Annubar
Orifice Plate | 8 In (200mm) | Name | DP @ [NAME] | DP @ Avg. Flow | PPL @ [NAME] | PPL @ Avg Flow | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
5.148 | In | 8 In (200mm) Orifice Plate | 105 | 68.21177673339844 | 61.51926422119141 | 39.96512603759766 | $ 262.11 | $ 500.6 |  |  | 238.49 |  |  | 500.6024780273438 | 262.1187438964844 | $
Annubar | DII+ 25/26 | 8 In (200mm) Annubar DII+ 25/26 | 23 | 14.94162845611572 | 3.141210317611694 | 2.040643453598022 | $ 13.38 | $ 25.56 | $ 248.73 | $ 475.04 | 12.18 |  |  | 25.56105995178223 | 13.38394165039062 | $
8 In (200mm)
 |  |  | Annual Savings
 |  |  | [NAME] | [NAME]
 |  | 8 In (200mm) Annubar DII+ 25/26 | $ 248.73 | $ 475.04
 |  | 8 In (200mm) Orifice Plate
Spreadsheet: 550606d1512464040-sorting-issues-performance
Sheet: Sheet2

Production |  |  |  |  |  |  |  |  |  | Rejects
Date | Shift | [NAME] | Grade | Speed | TPH | Produced Tons | Scaled Tons | Spool loss | Trim loss | Machine Reject | Winder Reject | Grade Change | Spots | Caliper | Size | Scabs | Color | After Break | Insects | Other | Total Rejects | Maint. | Comments
2017-12-03 00:00:00 | Nights | 413165 | .0165-175# Poly Cup WF | 927 | 34.63 | 417.39 | 402.11 | 15.82 | 15.3 | 0 | 16.89 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 6.890000000000001 | 16.89
2017-12-02 00:00:00 | Nights | 413165 | .0165-175# Poly Cup WF | 914.85 | 34.4 | 413.35 | 306.86 | 8.27 | 3.98 | 26.83 | 34.55 | 9.23 |  |  |  |  |  |  | 34.53 | 17.61999999999999 | 61.38
Year to Date Averages
Spreadsheet: richard_ring__31578__Real Time_Day Ahead Scheduling_v2
Sheet: Scheduling

 | Exhibit B | Paste Cells
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday-Saturday
 | Day Definition |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunday & Holiday
 | 2001-10-20 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | Long Term Purchase Quantity | 30.828 | 29.484 | 29.076 | 30.216 | 30.456 | 30.744 | 30.216 | 30.348 | 30.168 | 30.096 | 29.76 | 29.424 | 29.556 | 29.916 | 29.58 | 29.484 | 29.58 | 29.544 | 29.748 | 29.892 | 29.796 | 29.892 | 30.06 | 30.132
 | Expected Usage | 15 | 16 | 17 | 19 | 20 | 21 | 25 | 32 | 32 | 32 | 35 | 40 | 40 | 40 | 35 | 30 | 28 | 27 | 26 | 25 | 22 | 18 | 15 | 10
 | Total Incremental Quantity
 | Total Decremental Quantity
 | Day Ahead Incremental Quantity
 | Day Ahead Decremental Quantity
 | Real Time Incremental Quantity
 | Real Time Decremental Quantity
 | Total Incremental & (Decremental)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-3813 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
Spreadsheet: 232309d1367384920-society-scoring-system-template-society-scoring-system-template
Sheet: stratford

 |  |  | Am Results |  |  |  |  |  |  |  | Pm Results
 | Name        H/caps |  | Front 9 | Back 9 | Total | Points |  |  | Name       H/caps |  | Front 9 | Back 9 | Total | Points
 |  |  | 41 | 43 |  | 8
Leaders in red |  |  | 51 | 55 |  | 9
 |  |  | 43 | 42 |  | 10
 |  |  | 50 | 50 |  | 0
 |  |  | 49 | 50 |  | 0
 |  |  | 44 | 46 |  | 6
 |  |  | 47 | 48 |  | 3
 |  |  | 49 | 49 |  | 1
 |  |  | 49 | 51 |  | 0
 |  |  | 47 | 47 |  | 7
 |  |  | 46 | 50 |  | 5
 |  |  | 51 | 51 |  | 0
 |  |  | 51 | 51 |  | 0
 |  |  | 50 | 49 |  | 9
 |  |  | 48 | 48 |  | 2
 |  |  | 47 | 47 |  | 4
 | Team Ball    Andy walker, [NAME], [NAME] hargreaves, 80 points
 | Handicap change
Spreadsheet: 279294d1385059410-tweaking-a-excel-schedule-dockschedule_reply
Sheet: Schedule

 | DAILY DOCK SCHEDULE |  |  |  |  | For the day of | Show schedule for:
 |  |  |  |  |  | 2013-11-21 00:00:00 | 12
 | TIME | DOOR  3 | DOOR 4 | DOOR 5 | DOOR 6 | DOOR 7 | DOOR 8 | DOOR 9 | DOOR  10 | DOOR 11 | DOOR 12 | DOOR 13 | DOOR 14 | DOOR 15 | DOOR 16
 | 05:00:00
 | 06:00:00
 | 07:00:00
 | 08:00:00
 | 09:00:00
 | 10:00:00
 | 11:00:00
 | 12:00:00
 | 13:00:00
 | 14:00:00
 | 15:00:00
 | 16:00:00
 | 17:00:00
 | 18:00:00
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 22:00:00
 | 23:00:00
 | 1900-01-01 00:00:00
Spreadsheet: 9562eb1e-d3b5-4f08-80fe-936ef0f5ecd9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7484 | 57796 | [NAME] | [NAME] | JPN | 0 | 00:13:58 | 00:01:45 | 01:15:43 | 00:01:18 | 00:54:22 | 1 | 02:27:07