tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A40

TABLE A40 FREQUENCY OF PRICE SPIKES IN THE NEW ENGLAND TEN-MINUTE SPINNING RESERVE MARKET DURING JUNE, JULY, AND AUGUST OF 1998, 1999, AND 2000 BEFORE ISO-NE REVISIONS
Price Equals or Exceeds | # of hours |  |  | # of hours |  |  | # of hours
 | % of available hours |  |  | % of available hours |  |  | % of available hours
 | 1998-06-01 00:00:00 | 1999-06-01 00:00:00 | 2000-06-01 00:00:00 | 1998-07-01 00:00:00 | 1999-07-01 00:00:00 | 2000-07-01 00:00:00 | 1998-08-01 00:00:00 | 1999-08-01 00:00:00 | 2000-08-01 00:00:00
100 | NA | 26 | 1 | NA | 30 | 0 | NA | 3 | 0
 |  | 0.03611 | 0.00139 |  | 0.04032 | 0 |  | 0.00403 | 0
250 | NA | 13 | 0 | NA | 22 | 0 | NA | 0 | 0
 |  | 0.01806 | 0 |  | 0.02957 | 0 |  | 0 | 0
500 | NA | 5 | 0 | NA | 14 | 0 | NA | 0 | 0
 |  | 0.00694 | 0 |  | 0.01882 | 0 |  | 0 | 0
750 | NA | 4 | 0 | NA | 9 | 0 | NA | 0 | 0
 |  | 0.00556 | 0.00011 |  | 0.0121 | 0 |  | 0 | 0
1000 | NA | 0 | 0 | NA | 0 | 0 | NA | 0 | 0
 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Source:  ISO-NE Website (www.iso-ne.com). Data was only available through August 15, 2000.
Spreadsheet: 829424d1684222899-formula-that-continues-to-count-random-colored-cells-as-more-cells-are-added-sample-5-15-23-1-
Sheet: Sample

 | 43.9375 | 43.96875 |  |  |  |  | H1 | H2 | [NAME] | H1 | H2 | [NAME]
 | 44.25 | 43.96875 |  |  | 1
 | 44.34375 | 44.21875 |  |  |  | 1
 | 44.8125 | 44.40625
 | 45 | 44.96875
 | 44.96875 | 44.96875
 | 44.96875 | 44.96875
 | 44.65625 | 44.8125 |  |  | 5
 | 44.71875 | 44.65625 |  |  |  | 1
 | 44.9375 | 44.78125
 | 44.59375 | 44.875
 | 43.46875 | 44.46875
 | 43.4375 | 43.46875 |  |  | 4
 | 43.40625 | 43.9375
 | 43.5625 | 43.40625 |  |  |  | 2
 | 43.71875 | 43.6875 |  |  | 1
 | 43.6875 | 43.84375 |  |  |  | 1
 | 44.25 | 43.71875 |  |  | 1
 | 44.34375 | 44.21875 |  |  |  | 1
 | 44.40625 | 44.4375 |  |  | 1
 | 44.28125 | 44.5625 |  |  |  | 1
 | 44.9375 | 44.3125
 | 45.125 | 45 |  |  | 2
 | 44.875 | 45.1875
 | 44.75 | 44.9375 |  |  |  | 2
 | 45.75 | 44.84375
 | 45.59375 | 45.65625 |  |  | 2
 | 45.6875 | 45.59375
 | 45.5625 | 45.71875 |  |  |  | 2
 | 45.09375 | 45.1875 |  |  | 1
 | 45.3125 | 45.0625 |  |  |  | 1
Spreadsheet: 43317d1241957581-analysing-survel-data-mode-or-count-survey-analysis
Sheet: Sheet2

5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
6 | 436 | 4 | 4 | 4 | 4 | 4 | 4 | 5346 | 4 | 4 | 4
27 | 9 | 7 | 4 | 4 | 4 | 4 | 4 | 4 | 8 | 440 | 8
332 | 8 | 8 | 13 | 11 | 8 | 8 | 4333 | 53 | 8 | 12 | 8
40 | 8 | 8 | 13 | 12 | 8 | 42 | 8 | 8 | 8 | 8 | 251
12 | 8 | 8 | 42 | 8 | 8 | 12 | 8 | 460 | 8 | 8 | 12
551 | 8 | 8 | 8 | 40 | 12 | 8 | 8 | 8 | 60 | 8 | 8
5332 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
9 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
9 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
10 | 440 | 8 | 8 | 8 | 8 | 8 | 8 | 5350 | 8 | 8 | 8
31 | 13 | 11 | 8 | 8 | 8 | 8 | 8 | 8 | 12 | 440 | 8
332 | 8 | 8 | 13 | 11 | 8 | 8 | 4333 | 53 | 8 | 12 | 8
40 | 8 | 8 | 13 | 12 | 8 | 42 | 8 | 8 | 8 | 8 | 251
12 | 8 | 8 | 42 | 8 | 8 | 12 | 8 | 460 | 8 | 8 | 12
551 | 8 | 8 | 8 | 40 | 12 | 8 | 8 | 8 | 60 | 8 | 8
5332 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
Spreadsheet: 29046d1223706124-two-dimensional-help-jg-master
Sheet: Champion-Sat

DIVISION:      JUNIOR GIRLS
 | NAME | Home Town | Total Points
ALL AROUND:
RUNNER UP:
EVENT:  Trail Course |  | Home Town | Score or Time
PLACE
1 | CallieRuth Bridgforth | Anywhere, NY | 0
2 | --- | --- | ---
3 | --- | --- | ---
4 | --- | --- | ---
5 | --- | --- | ---
6 | --- | --- | ---
7 | --- | --- | ---
EVENT: Pole Bending |  | Home Town | Score or Time
PLACE
1 | CallieRuth Bridgforth | Anywhere, NY | 0
2 | --- | --- | ---
3 | --- | --- | ---
4 | --- | --- | ---
5 | --- | --- | ---
6 | --- | --- | ---
7 | --- | --- | ---
EVENT:  GOAT TYING |  | Home Town | Score or Time
PLACE
1 | CallieRuth Bridgforth | Anywhere, NY | 0
2 | --- | --- | ---
3 | --- | --- | ---
4 | --- | --- | ---
5 | --- | --- | ---
6 | --- | --- | ---
7 | --- | --- | ---
EVENT: Barrels |  | Home Town | Score or Time
PLACE
1 | CallieRuth Bridgforth | Anywhere, NY | 9.876
2 | --- | --- | ---
3 | --- | --- | ---
4 | --- | --- | ---
5 | --- | --- | ---
6 | --- | --- | ---
7 | --- | --- | ---
EVENT:  Breakaway |  | Home Town | Score or Time
PLACE
1 | CallieRuth Bridgforth | Anywhere, NY | 0
2 | --- | --- | ---
3 | --- | --- | ---
4 | --- | --- | ---
5 | --- | --- | ---
6 | --- | --- | ---
7 | --- | --- | ---
Spreadsheet: 63037d1264004263-duplicate-rows-combining-and-flipping-class_pivot
Sheet: Sheet1

Student | Class | Grade | Quarter
[NAME] | Chemistry | 70 | 1
[NAME] | Chemistry | 80 | 2
[NAME] | Math | 95 | 1
[NAME] | Math | 100 | 2
[NAME] | Chemistry | 67 | 1
[NAME] | Chemistry | 47 | 2
[NAME] | Math | 88 | 1
[NAME] | Math | 85 | 2
[NAME] | Chemistry | 70 | 1
[NAME] | Chemistry | 64 | 2
[NAME] | Math | 60 | 1
[NAME] | Math | 52 | 2
[NAME] | Chemistry | 93 | 1
[NAME] | Chemistry | 68 | 2
[NAME] | Math | 94 | 1
[NAME] | Math | 77 | 2
[NAME] | Chemistry | 88 | 1
[NAME] | Chemistry | 94 | 2
[NAME] | Math | 79 | 1
[NAME] | Math | 73 | 2
Millie | Chemistry | 75 | 1
Millie | Chemistry | 64 | 2
Millie | Math | 72 | 1
Millie | Math | 75 | 2
[NAME] | English | 91 | 1
[NAME] | English | 56 | 2
[NAME] | Geography | 81 | 1
[NAME] | Geography | 59 | 2
[NAME] | English | 71 | 1
[NAME] | English | 75 | 2
[NAME] | Geography | 79 | 1
[NAME] | Geography | 72 | 2
[NAME] | English | 85 | 1
[NAME] | English | 88 | 2
[NAME] | Geography | 60 | 1
[NAME] | Geography | 58 | 2
[NAME] | English | 86 | 1
[NAME] | English | 93 | 2
[NAME] | Geography | 65 | 1
[NAME] | Geography | 75 | 2
[NAME] | English | 87 | 1
[NAME] | English | 60 | 2
[NAME] | Geography | 85 | 1
[NAME] | Geography | 71 | 2
Millie | English | 64 | 1
Millie | English | 90 | 2
Millie | Geography | 89 | 1
Millie | Geography | 55 | 2
Spreadsheet: 865257d1712307704-complex-conditional-formatting-formula-sample
Sheet: Components

No | ID 1 | Category | ID 2 | Product Name | Component Name | [NAME] | [NAME] | [NAME] | [NAME]
1 | 1 | Category 1 | 1.1.1 | Product A | Component 1 | TEXT | TEXT | TEXT | TEXT
2 | 1 | Category 1 | 1.1.2 | Product A | Component 2 | TEXT | TEXT | TEXT | TEXT
3 | 1 | Category 1 | 1.1.3 | Product A | Component 3 | TEXT | TEXT | TEXT | TEXT
4 | 1 | Category 1 | 1.1.4 | Product A | Component 4 | TEXT | TEXT | TEXT | TEXT
5 | 1 | Category 1 | 1.1.5 | Product A | Component 5 | TEXT | TEXT | TEXT | TEXT
6 | 1 | Category 1 | 1.1.6 | Product A | Component 6 | TEXT | TEXT | TEXT | TEXT
7 | 1 | Category 1 | 1.2.1 | Product B | Component 7 | TEXT | TEXT | TEXT | TEXT
8 | 1 | Category 1 | 1.2.2 | Product B | Component 8 | TEXT | TEXT | TEXT | TEXT
9 | 1 | Category 1 | 1.2.3 | Product B | Component 9 | TEXT | TEXT | TEXT | TEXT
10 | 1 | Category 1 | 1.2.4 | Product B | Component 10 | TEXT | TEXT | TEXT | TEXT
11 | 1 | Category 1 | 1.2.5 | Product B | Component 11 | TEXT | TEXT | TEXT | TEXT
12 | 1 | Category 1 | 1.2.6 | Product B | Component 12 | TEXT | TEXT | TEXT | TEXT
13 | 1 | Category 1 | 1.2.7 | Product B | Component 13 | TEXT | TEXT | TEXT | TEXT
14 | 1 | Category 1 | 1.2.8 | Product B | Component 14 | TEXT | TEXT | TEXT | TEXT
15 | 1 | Category 1 | 1.2.9 | Product B | Component 15 | TEXT | TEXT | TEXT | TEXT
16 | 2 | Category 2 | 2.1.1 | Product C | Component 16 | TEXT | TEXT | TEXT | TEXT
17 | 2 | Category 2 | 2.1.2 | Product C | Component 17 | TEXT | TEXT | TEXT | TEXT
18 | 2 | Category 2 | 2.1.3 | Product C | Component 18 | TEXT | TEXT | TEXT | TEXT
19 | 2 | Category 2 | 2.1.4 | Product C | Component 19 | TEXT | TEXT | TEXT | TEXT
20 | 2 | Category 2 | 2.1.5 | Product C | Component 20 | TEXT | TEXT | TEXT | TEXT
Spreadsheet: 117125d1312467004-selective-columns-farthingstone-updated-old-format-
Sheet: sc

Shaw. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 122079b7-f22d-4ade-bde8-0c8adc5908ac
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0033816 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Hasentree Golf Community | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Wake | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did conjunctive utilization occur at this facility? |  |  |  |  |  | Field Name: |  | GCH&V and RF#19 |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 18.2 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage             (if applicable) | 5-Day Upset              (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading (gallons): |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Spreadsheet: 220387d1363138992-sorting-data-from-largest-to-smallest-workbook2
Sheet: Sheet1

[NAME] | Jared | [NAME] | [NAME] | [NAME]
8 | 10 | 7 | 2 | 3
Name | Value
Spreadsheet: 116835d1312214549-if-function-between-sheets-with-text-and-numbers-load-board
Sheet: BOW

Driver # | Book Date | Company | Load # | [NAME] | Fuel | [NAME] | Shared | PU Date | PU Time | City, State | Drop Date | Drop Time | City, State | Truck | Trailer #(s) | Percentage | BOLs | Location? | Billed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Received? | CH or ME or DM
BOW001 | 2011-07-31 00:00:00 | CH [NAME] | 94950354 | 750 | 261 |  | HET005 | 2011-08-03 00:00:00 | Apt | Lakeville, MN | 2011-08-04 00:00:00 | 6:00 - 14:00 | Albertville, MN | 2 | 126784
BOW002 | 2011-07-29 00:00:00 | [NAME] | 102407050 |  | 132 |  |  | 2011-08-03 00:00:00 | 14:00:00 | Chanhassen, MN | 2011-08-04 00:00:00 | 09:00:00 | Fargo, ND | 3 | 120485
Spreadsheet: 863568d1711006136-searching-the-correct-month-and-filling-in-the-corresponding-values-in-the-correct-columns-excel-test
Sheet: Summary

 |  |  | Date | Name | Breakfast | Lunch | Dinner | Remark
 |  |  | 2026-01-02 00:00:00 | ABC | Western | 90 | Home | Happy
 |  |  | 2026-01-04 00:00:00 | [NAME] | Chinese | 200 | Restaurants | Nice
 |  |  | 2026-01-08 00:00:00 | Viann | Japan | 180 | Home | Welcome
 |  |  | 2026-02-01 00:00:00 | Leo | Chinese | 300 | Office | Happy
 |  |  | 2026-02-06 00:00:00 | Akon | Chinese | 64 | Restaurants | Nice
 |  |  | 2026-02-10 00:00:00 | [NAME] | Western | 1000 | Office
Spreadsheet: 851448d1701687951-if-function-with-multiple-conditions-sample
Sheet: Sheet1

Sl.No. | REF. | comm | ABC
 |  |  | Rev. | Subm. | TX | Resp. DATE | RESPONSE | STATUS
1 | 123-23 | FA | 00 | 2023-12-04 00:00:00 | XYZ |  |  | Open
2 | 125-23 | FA | 0 | 2023-11-01 00:00:00 | XYZ |  |  | Overdue
3 | 126-23 | A | 0 | 2023-10-30 00:00:00 | XYZ | 2023-12-03 00:00:00 | abc | Closed
4 | 124-23 | R | 00 | 2023-10-01 00:00:00 | XYZ | 2023-12-03 00:00:00 | abc | Closed
5 | 124-23 | FA | 1 | 2023-12-04 00:00:00 | XYZ |  |  | Open
Spreadsheet: 845645d1697061446-simple-dynamic-calendar-questions-calendar-main-1-
Sheet: Calendar

October
1 | 2 | 3 | 4 | 5 | 6 | 7
S | M | T | W | T | F | S
Spreadsheet: 845175d1696690509-creating-a-report-to-display-missing-data-raw-data-copy
Sheet: Report examples

W/C | 2023-06-11 00:00:00 | (11/06/23-17/06/23)
Case ref | First Name(s) | Last Name | Who1 | Who1 Report received
6 | FirstName6 | LastName6 | Person18
Case ref | First Name(s) | Last Name | Who1 | Who1 Report received
55 | FirstName55 | LastName55 | Person15
W/C | 2023-07-23 00:00:00 | (23/07/23-29/07/2023)
Case ref | First Name(s) | Last Name | ReportF who | ReportF due | ReportF received
3 | FirstName3 | LastName3 | E | 2023-07-24 00:00:00
Case ref | First Name(s) | Last Name | ReportF who | ReportF due | ReportF received
77 | FirstName77 | LastName77 | B | 2023-07-27 00:00:00
Case ref | First Name(s) | Last Name | ReportA due | ReportA received | ReportD who | ReportD due | PersonD report pt1 | PersonD report pt2 | PersonD report pt3 | PersonD report pt4 | ReportF who | ReportF due | ReportF received
43 | FirstName43 | LastName43 | 2023-07-27 00:00:00 |  | Person30 | 2023-07-27 00:00:00 |  |  |  |  | B | 2023-07-27 00:00:00
Case ref | First Name(s) | Last Name | ReportD who | ReportD due | PersonD report pt1 | PersonD report pt2 | PersonD report pt3 | PersonD report pt4
57 | FirstName57 | LastName57 | [NAME] | 2023-07-27 00:00:00
Case ref | First Name(s) | Last Name | ReportA due | ReportA received | ReportB who | ReportB due | ReportB received | ReportC due | ReportC received | ReportD who | ReportD due | PersonD report pt1 | PersonD report pt2 | PersonD report pt3 | PersonD report pt4
62 | FirstName62 | LastName62 | 2023-07-27 00:00:00 |  | 3294 | 2023-07-27 00:00:00 |  | 2023-07-27 00:00:00 |  | Person9 | 2023-07-27 00:00:00
Spreadsheet: 786243d1657058634-extracting-a-value-from-a-long-string-using-left-right-mid-voorbeeldblad
Sheet: Blad1

Jun 26, 2022 9:42:52 AM 55 LOAN DEPOSIT 20.70 EUR SUCCESS_USER_O |  |  |  |  |  |  |  | <- Need this to show €20,70
PERATION
REDACTED c1010-1 REDACTED:4:8
Jun 26, 2022 11:01:35 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O |  |  |  |  |  |  |  | <- Need this to show €0,00
PERATION
REDACTED appos-1 REDACTED:22:62
Jun 26, 2022 11:01:35 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O |  |  |  |  |  |  |  | <- Need this to show €0,00
PERATION
REDACTED c1010-1 REDACTED:22:62
Jun 26, 2022 11:01:35 AM 55 PAYMENT DEPOSIT 50.00 EUR SUCCESS_USER_O |  |  |  |  |  |  |  | <- Need this to show €50,00
PERATION
REDACTED appos-1 REDACTED:22:62
Jun 26, 2022 11:01:35 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O |  |  |  |  |  |  |  | <- Need this to show €0,00
PERATION
REDACTED c1010-1 REDACTED:22:62
Jun 26, 2022 11:01:35 AM 55 PAYMENT DISPENSE -5.00 EUR SUCCESS_USER_O |  |  |  |  |  |  |  | <- Need this to show -€5,00
PERATION
REDACTED appos-1 REDACTED:22:62
Jun 26, 2022 11:01:35 AM 55 PAYMENT DISPENSE -3.10 EUR SUCCESS_USER_O
PERATION
REDACTED c1010-1 REDACTED:22:62
Jun 26, 2022 11:10:22 AM 55 PAYMENT DEPOSIT 1,760.00 EUR SUCCESS_USER_O
PERATION
REDACTED appos-1 REDACTED:26:147
Jun 26, 2022 11:10:22 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O
PERATION
REDACTED c1010-1 REDACTED:26:147
Jun 26, 2022 11:15:52 AM 55 PAYMENT DEPOSIT 70.00 EUR SUCCESS_USER_O
PERATION
REDACTED appos-1 REDACTED:27:38
Jun 26, 2022 11:15:52 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O
PERATION
REDACTED c1010-1 REDACTED:27:38
Jun 26, 2022 11:15:52 AM 55 PAYMENT DISPENSE -10.00 EUR SUCCESS_USER_O
PERATION
REDACTED appos-1 REDACTED:27:38
Jun 26, 2022 11:15:52 AM 55 PAYMENT DISPENSE -1.55 EUR SUCCESS_USER_O
PERATION
REDACTED c1010-1 REDACTED:27:38
Jun 26, 2022 11:59:36 AM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O
PERATION
REDACTED appos-1 REDACTED:43:18
Jun 26, 2022 11:59:36 AM 55 PAYMENT DEPOSIT 1.00 EUR SUCCESS_USER_O
PERATION
REDACTED c1010-1 REDACTED:43:18
Jun 26, 2022 11:59:36 AM 55 PAYMENT DISPENSE -0.50 EUR SUCCESS_USER_O
PERATION
REDACTED c1010-1 REDACTED:43:18
Jun 26, 2022 12:07:45 PM 55 PAYMENT DEPOSIT 50.00 EUR SUCCESS_USER_O
PERATION
REDACTED appos-1 REDACTED:45:24
Jun 26, 2022 12:07:45 PM 55 PAYMENT DEPOSIT 0.00 EUR SUCCESS_USER_O
PERATION
REDACTED c1010-1 REDACTED:45:24
Jun 26, 2022 12:07:45 PM 55 PAYMENT DISPENSE -10.00 EUR SUCCESS_USER_O
PERATION
REDACTED appos-1 REDACTED:45:24
Jun 26, 2022 12:07:45 PM 55 PAYMENT DISPENSE -1.00 EUR SUCCESS_USER_O
PERATION
REDACTED c1010-1 REDACTED:45:24
Spreadsheet: 875943d1722565722-identify-data-and-make-it-automatic-fill-the-column-as-long-as-it-match-the-criteria-fill-columns-and-row-with-criteria
Sheet: Sheet1

#Net | Density(Kg/m) |  |  | Result I want it
 | Total | Final |  | Density Total
GD03 | 15 | 32.22717065083484 |  | 20 | 30 | 35 | 40
GC11 | 32.95913609166359 | 31.12656603674264
GD02 | 34.02185558700951 | 34.02185558700951 |  |  |  |  |  | automatically fill this with criteria,
GF05 | 33.80879546770543 | 31.10661902756576 |  |  |  |  |  | is there any flexible formula so I can
GD04 | 36.84723663862022 | 35.57256559461089 |  |  |  |  |  | change if there is any additional criteria.
GD05 | 42.27008102156481 | 38.31264322436876
GD06 | 37.24232334930078 | 33.40996604727063
GA01 | 31.33142545411653 | 31.33142545411653
GD01 | 28.47824565542187 | 28.47824565542187
GD08 | 35.43907788071801 | 30.67475566317489
GB05 | 28.97608196908284 | 25.42645549297258 |  |  |  | instan fill if there is data ve been added
Spreadsheet: 48961d1248251079-cell-validation-blitz-day-august
Sheet: Sheet1

# | Product | Reference Number | Client ID Number
1 | Transactional Accounts |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Transactional Accounts
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notify Me
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enhanced Notify Me
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
32
33
Spreadsheet: 586530d1534433682-formula-working-in-reverse-oii-ctr_opg-cvx-angola-flexible-pipeline-2
Sheet: Sheet1

 | COST TIME RESOURCE (CTR) FORM
Project Number |  | Project Title |  |  |  |  |  | Client
Work Scope:
Install 3.5km of 7.1” internal diameter composite pipe in water depths of between 125 and 150 feet from platform to platform.  Preliminary utilization of [NAME] or vessel of opportunity. |  |  |  | Note:  This CTR is budgetary only.  No SOW document to reference.
 |  |  |  |  |  |  |  |  |  |  | Total Hrs
Activities/Deliverables | Resources | Location | No. | Hrs/Week | Weeks | $/Hour | Labor $ | Misc. Expense | Total |  | Eng | PM
1.1 Flowline Installation Analysis | Project Engineer | Houston/Angola | 2 | 40 | 5 | 0
 | Drafting | Houston/Angola | 1 | 20 | 1 | 0
 | Project Manager | Angola | 1 | 40 | 1 | 1
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
1.2 Pipe Manufacturer Interface | Project Engineer | Angola | 1 | 40 | 2 | 0
 | Drafting | Angola | 1 | 20 | 1 | 0
 | Project Manager | Angola | 1 | 40 | 2 | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
1.3 Installation Package | Project Engineer | Houston/Angola | 1 | 40 | 6 | 0
 | Drafting | Houston/Angola | 1 | 40 | 4 | 0
 | Project Manager | Angola | 1 | 40 | 2 | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
1.4 Procedures | Project Engineer | Angola | 1 | 40 | 2 | 0
 | Project Manager | Angola | 1 | 40 | 8 | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
1.5 Installation Aids | Project Engineer | Houston/Angola | 1 | 40 | 4 | 0
 | Drafting | Houston/Angola | 1 | 40 | 4 | 0
 | Project Manager | Angola | 1 | 40 | 2 | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
1.6 Mobe of Equipment to Country | Project Engineer | Angola | 1 | 40 | 2 | 0
 | Drafting | Angola | 1 | 40 | 1 | 0
 | Project Manager | Angola | 1 | 40 | 2 | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
1.7 Installation Vessel Mobe & Demobe | Project Engineer | Angola | 2 | 84 | 2 | 0 |  |  |  |  |  |  | This is 12hr days X 7 days/week
 | Project Manager | Angola | 1 | 84 | 2 | 0 |  |  |  |  |  |  | This is 12hr days X 7 days/week
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
1.8 Offshore Operations | Project Engineer | Angola | 2 | 84 | 2 | 0 |  |  |  |  |  |  | This is 12hr days X 7 days/week
 | Project Manager | Angola | 1 | 84 | 2 | 0 |  |  |  |  |  |  | This is 12hr days X 7 days/week
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
1.9 Project Closeout | Project Manager | Angola | 1 | 40 | 2 | 0
Document Control | Document Control | Houston | 1 | 40 | 2 | 0
TOTALS: |  |  |  |  |  |  |  |  |  | total w/o offshore
Data Required from Others: |  |  |  | Client Resources: |  |  |  |  |  | Totals
APPROVAL |  |  |  |  |  | CLIENT APPROVAL
[NAME]: |  | Client Manager: |  |  |  | Approved By:
Signature: |  | Signature: |  |  |  | Signature:
Date: |  | Date: |  |  |  | Date:
Spreadsheet: 146663d1332289593-how-to-copy-column-values-and-fill-in-sequentially-arranged-records-in-excel-2010-student
Sheet: student_score

 | A | B | C | D | E
1 | [NAME] | Date | Test | paper | score
2 | P115 | 2009-04-22 00:00:00 | english | paper 1 | 88
3 |  |  |  | paper 2 | 89
4 |  |  |  | paper 3 | 91
5 | P116 | 2008-04-01 00:00:00 | english | paper 1 | 45
6 |  |  |  | paper 2 | 46
7 |  |  |  | paper 3 | 47
8 | P117 | 2007-04-23 00:00:00 | english | paper 1 | 22
9 |  |  |  | paper 2 | 22
10 |  |  |  | paper 3 | 23
11 | P115 | 2008-05-12 00:00:00 | math | paper 1 | 62
12 |  |  |  | paper 2 | 99
13 |  |  |  | paper 3 | 87
Spreadsheet: darrell_schoolcraft__7278__saledoc03_06aTW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2002-03-05 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 3/06/02 |  |  | FAX Number:
Total Quantity |  |  | 20000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.38
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
3/06/2002 | 2002-03-06 00:00:00 | 20000 |  | 20000 |  | 20000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 20000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 132516d1323797302-reading-months-and-finding-a-total-number-of-bookings-in-a-month-pttwotabledatecount2
Sheet: Sheet1

Table1 | Count1 | Table
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1 |  | Count of Table | Column Labels
 |  | 1 |  | Row Labels | 1 | 2 | Grand Total
 |  | 1 |  | 2010
 |  | 1 |  | Jan |  | 2 | 2
 |  | 1 |  | Feb | 1 |  | 1
 |  | 1 |  | Mar | 2 | 1 | 3
 |  | 1 |  | Apr | 1 | 2 | 3
 |  | 1 |  | May | 1 | 2 | 3
 |  | 1 |  | Jun | 2 | 1 | 3
 |  | 1 |  | Jul | 2 |  | 2
 |  | 1 |  | Aug |  | 1 | 1
 |  | 1 |  | Sep | 1 | 1 | 2
 |  | 1 |  | Oct | 3 | 1 | 4
 |  | 1 |  | Nov | 1 |  | 1
 |  | 1 |  | Dec | 1 |  | 1
 |  | 1 |  | 2011
 |  | 1 |  | Jan |  | 4 | 4
 |  | 1 |  | Feb | 2 |  | 2
 |  | 1 |  | Mar | 3 | 1 | 4
 |  | 1 |  | Apr | 5 | 2 | 7
 |  | 1 |  | May | 1 | 3 | 4
 |  | 1 |  | Jun |  | 1 | 1
 |  | 1 |  | Aug | 2 | 3 | 5
 |  | 1 |  | Sep | 1 | 1 | 2
 |  | 1 |  | Oct | 3 | 3 | 6
 |  | 1 |  | Nov | 1 | 1 | 2
 |  | 1 |  | Dec |  | 3 | 3
 |  | 2 |  | Grand Total | 33 | 33 | 66
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2
 |  | 2