tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 869714d1716301441-rota-generator-rota-test
Sheet: Sheet2

 |  | Name | Number of shifts per week
 |  | [NAME] | 5
 |  | [NAME] | 5
 |  | [NAME] | 5
 |  | Anna | 5
 |  | Becci | 5
 |  | Benet | 5
 |  | Edita | 5
 |  | [NAME] | 2
 |  | Gemma | 2
 |  | [NAME] | 5
 |  | [NAME] | 2
 |  | Greeshma | 5
 |  | Hosni | 5
 |  | Isabel | 4
 |  | [NAME] | 5
 |  | Jimble | 5
 |  | [NAME] | 5
 |  | Joyal | 5
 |  | Jubna | 5
 |  | Maria | 5
 |  | [NAME] | 5
 |  | [NAME] | 3
 |  | Omotola | 5
 |  | [NAME] | 4
 |  | Vanese | 5
Spreadsheet: 755223d1636727065-nearest-coordinates-3d-distance-surveyor-forum-1
Sheet: Sheet1

DESIGN |  |  |  |  |  |  |  |  |  |  |  |  | SURVEY
Id | X | Y | Z | nearest survey | ID nearest survey | ID 2nd | ID 3rd |  |  |  |  |  | ID | X | Y | Z
V4 | 1997.082 | 6023.74 | 19.646 |  |  |  |  |  |  |  |  |  | PT001.1 | 1976.647116 | 6005.177557 | 19.652581
V7 | 1994.621 | 6023.299 | 19.64 |  |  |  |  |  |  |  |  |  | PT001.2 | 1977.0646 | 6006.7925 | 16.9092
V9 | 1993.015 | 6022.864 | 19.648 |  |  |  |  |  |  |  |  |  | PT001.3 | 1977.0646 | 6006.7925 | 19.6542
V15 | 1988.403 | 6020.92 | 19.638 |  |  |  |  |  |  |  |  |  | PT001.4 | 1977.4528 | 6007.9881 | 16.9091
V17 | 1986.792 | 6019.954 | 19.636 |  |  |  |  |  |  |  |  |  | PT001.5 | 1977.4528 | 6007.9881 | 19.6541
V21 | 1984.151 | 6017.914 | 18.779 |  |  |  |  |  |  |  |  |  | PT001.6 | 1977.980703 | 6009.342911 | 19.654937
V22 | 1984.143 | 6017.912 | 19.637 |  |  |  |  |  |  |  |  |  | PT001.7 | 1978.687 | 6010.858811 | 19.655
V27 | 1980.8906 | 6014.3947 | 19.6454 |  |  |  |  |  |  |  |  |  | PT001.8 | 1979.93911 | 6013.027871 | 19.655
V29 | 1979.9293 | 6013.0326 | 19.6391 |  |  |  |  |  |  |  |  |  | PT001.9 | 1980.897 | 6014.394811 | 19.655
V32 | 1978.685 | 6010.863 | 24.046 |  |  |  |  |  |  |  |  |  | PT001.10 | 1984.1534 | 6017.9178 | 19.6533
V34 | 1977.977 | 6009.343 | 24.046 |  |  |  |  |  |  |  |  |  | PT001.11 | 1984.1539 | 6017.9181 | 18.7983
V36 | 1977.452 | 6007.993 | 24.067 |  |  |  |  |  |  |  |  |  | PT001.12 | 1986.794792 | 6019.944708 | 19.652556
V36 | 1977.4381 | 6007.9841 | 19.6625 |  |  |  |  |  |  |  |  |  | PT001.13 | 1988.399492 | 6020.918273 | 19.654615
V37 | 1977.064 | 6006.796 | 24.034 |  |  |  |  |  |  |  |  |  | PT001.14 | 1993.006818 | 6022.874324 | 19.655404
V38 | 1977.065 | 6006.793 | 19.633 |  |  |  |  |  |  |  |  |  | PT001.15 | 1994.61929 | 6023.307041 | 19.655
V39 | 1976.642 | 6005.181 | 24.028 |  |  |  |  |  |  |  |  |  | PT001.16 | 1997.085 | 6023.741811 | 19.655
Spreadsheet: 489235d1479151206-urgent-help-vlookup-scorecard-november
Sheet: Sheet2

 |  | Name | Monthly Productivity | % | Cumulative
 |  | [NAME] | 310
 |  | [NAME] | 300
 |  | [NAME] | 289
 |  | [NAME] | 280
 |  | Isabella Comia | 275
 |  | [NAME] | 275
 |  | Maicah Delos Reyes | 275
 |  | [NAME] | 275
 |  | [NAME] | 275
 |  | [NAME] | 233
 |  | [NAME] | 210
 |  | [NAME] | 210
 |  | [NAME] | 200
 |  | [NAME] | 195
 |  | [NAME] | 190
 |  | [NAME] | 190
 |  | Morena Untiveros | 180
 |  | [NAME] | 177
 |  | [NAME] | 145
 |  | [NAME] | 135
 |  | [NAME] | 113
 |  | [NAME] | 100
 |  | [NAME] | 80
 |  |  | 4912 | 1
Spreadsheet: 730830d1619979119-vpm-mix-sub-calculations-vpm-mix-sub-calculations
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  | Sales Category 1 |  | 1 |  | Sales Cateogry 2 |  | 2
Team | Region | SalesCat | Amount |  |  |  |  |  |  |  |  | Team | 100-399 | 400-699 | 700-1000 |  | 100-399 | 400-699 | 700-1000
A | East | 1 | 100 |  |  |  |  |  |  |  |  | A
B | West | 2 | 200 |  |  |  |  |  |  |  |  | B
A | East | 2 | 300
B | West | 1 | 400
A | East | 2 | 415
B | West | 2 | 600
A | East | 1 | 1000
B | West | 2 | 200
A | East | 1 | 1000
B | West | 2 | 250
A | East | 1 | 750
B | West | 1 | 800
A | East | 2 | 901
B | West | 2 | 1000
A | East | 1 | 700
B | West | 2 | 850
A | East | 1 | 905
B | West | 2 | 900
A | East | 2 | 201
B | West | 2 | 1000
B | West | 1 | 1000
Spreadsheet: darrell_schoolcraft__7779__imbalsumm0106
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 | -1 | -10450
500046 | -650 |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 | -252 | -380
500528
500529
500619
INDEX
2001-05-31 00:00:00 |  |  | -843943.02
2001-06-23 00:00:00
Spreadsheet: 867302d1714135444-question-about-lambda-text-1-
Sheet: Sheet1

Name | Ctry |  |  |  |  |  |  | DDD | EEE
A | China |  |  | China, SG |  |  |  | A | China, SG |  | <---- How do I convert this back to A1:[NAME]??? |  |  |  |  |  |  |  | China
A | SG |  | B | SG, Msia |  |  |  | B | SG, Msia |  |  |  |  |  |  |  |  | A | SG
B | SG |  | C | Msia, SG, Usa |  |  |  | C | Msia, SG, Usa |  |  |  |  |  |  |  |  | B | SG
B | Msia |  | D | Vietnam, SG |  |  |  | D | Vietnam, SG |  |  |  |  |  |  |  |  | B | Msia
C | Msia |  |  |  |  |  |  |  |  |  |  |  |  |  | China | A |  | C | Msia
C | SG |  |  |  |  |  |  |  |  |  |  |  |  |  | SG | A |  | C | SG
C | Usa |  |  |  |  |  |  |  |  |  |  |  |  |  | SG | B |  | C | Usa
D | Vietnam |  |  |  |  |  |  |  |  |  |  |  |  |  | Msia | B |  | D | Vietnam
D | SG |  |  |  |  |  |  |  |  |  |  |  |  |  | Msia | C |  | D | SG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SG | C
 |  |  | My formula in D2 as below |  |  |  |  |  |  |  |  |  |  |  | Usa | D
 |  |  | LET(x,UNIQUE(Table1[Name]),HSTACK(x,BYROW(x,[NAME],TEXTJOIN(", ",TRUE,IF((Table1[Name]=q),Table1[Ctry],"")))))) |  |  |  |  |  |  |  |  |  |  |  | Vietnam | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SG
 |  |  |  |  |  |  |  |  |  | What does q mean?
 |  |  |  |  |  |  |  |  |  | *Why not Table1[Name]=x??
Spreadsheet: darrell_schoolcraft__7470__MARKET2001
Sheet: GRAPH

 | %
 | DEVIATION |  | FLOW
JAN |  | JAN
FEB |  | FEB
MAR |  | MAR
APR |  | APR
MAY |  | MAY
JUN |  | JUN
JUL |  | JUL
AUG |  | AUG
SEP |  | SEP
OCT |  | OCT
NOV |  | NOV
DEC |  | DEC
AVERAGE |  | AVERAGE
Spreadsheet: 141444d1329264760-sumif-book2
Sheet: Sheet1

text | helper |  |  |  | unique list
a
b
b
b
b
b
b
c
c
c
a
b
c
d
d
d
b
c
d
e
e
a
c
d
e
Spreadsheet: 42188d1240764174-help-with-table-rcps-blank2
Sheet: Sheet1

Name | [NAME] | [NAME] | [NAME] | [NAME] | Rnd 5 | Total | Bonus | Overall
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 15d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other | HY | IG | Other
Index Tranche | 1210 | 13912 | 21631 | 510 | 1147 | 135
Index | 62894 | 197978 | 189239 | 50765 | 116948 | 85930
Europe | - | - | 187048 | - | - | 84023
North America/Asia | 62894 | 197978 | 1259 | 50765 | 116948 | 691
Other | - | - | 932 | - | - | 1216
OTHER* | - | - | 96921 | - | - | 53817
TOTAL | 64104 | 211890 | 307791 | 51275 | 118095 | 139882
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 858867d1707379371-iferror-if-and-lookup-automated-v9-copy-aligw
Sheet: Sheet2

Semester | Module Code | Lvl | [NAME] | CR | School | ! | OT | [NAME] | !! | Class Mark | Final Exam mark | ITS Final Mark | ITS Final Result | PI
84 days, 3:01:00 | [NAME] | 1 | Chemistry for Engineers 1A | 8 | 2182 |  | HA | Registered |  | 62 | 56 | 58 | P
84 days, 3:01:00 | ENCH1TCH1 | 1 | Technical Communication for Engineers | 8 | 2183 |  | HA | Registered |  | 77 | 77 | 77 | P
84 days, 3:01:00 | ENME1DRH1 | 1 | Engineering Drawing | 8 | 2183 |  | HA | Registered |  | 89 | 75 | 82 | P
84 days, 3:01:00 | [NAME] | 1 | Mathematics 1A (Eng) | 16 | 2185 |  | HA | Registered |  | 55 | 38 | 44 | FS
84 days, 3:01:00 | MATH132H1 | 1 | Applied Mathematics 1A (Eng) | 16 | 2185 |  | HA | Registered |  | 35 | 46 | 42 | FS
84 days, 3:01:00 | PHYS151H1 | 1 | Engineering Physics 1A | 16 | 2182 |  | HA | Registered |  | 57 | 35 | 42 | FS
84 days, 3:02:00 | CHEM191H2 | 1 | Chemistry for Engineers 1B | 8 | 2182 |  | HA | Registered |  | 80 | 66.2 | 71 | P
84 days, 3:02:00 | [NAME] | 1 | Introduction to Civil Design | 8 | 2183 |  | HA | Registered |  | 68 | 49 | 57 | P
84 days, 3:02:00 | ENCV1EPH2 | 1 | Engineering Practice Workshop | 0 | 2183 |  | HA | Registered |  |  |  |  | P
84 days, 3:02:00 | ENME1EMH2 | 1 | Introduction to Engineering Materials | 8 | 2183 |  | HA | Registered |  | 54 | 34 | 40 | FS
84 days, 3:02:00 | MATH141H2 | 1 | Mathematics 1B (Eng) | 16 | 2185 |  | HA | Registered |  | 49 | 59 | 56 | P
84 days, 3:02:00 | MATH142H2 | 1 | Applied Mathematics 1B (Eng) | 16 | 2185 |  | HA | Registered |  | 32 | 18 | 23 | F
84 days, 3:02:00 | PHYS152H2 | 1 | Engineering Physics 1B | 16 | 2182 |  | HA | Registered |  | 49 | 41.7 | 44 | FS
2019:S1 | [NAME] | 1 | Mathematics 1A (Eng) | 16 | 2185 |  | HA | Registered |  | 55 | 50 | 52 | P
2019:S1 | MATH132HS1 | 1 | Applied Mathematics 1A (Eng) | 16 | 2185 |  | HA | Registered |  | 35 | 45 | 42 | F
2019:S1 | PHYS151HS1 | 1 | Engineering Physics 1A | 16 | 2182 |  | HA | Registered |  | 57 | 31.7 | 39 | F
2019:S2 | ENME1EMHS2 | 1 | Introduction to Engineering Materials | 8 | 2183 |  | HA | Registered |  | 54 | 45 | 48 | F
2019:S2 | PHYS152HS2 | 1 | Engineering Physics 1B | 16 | 2182 |  | HA | Registered |  | 49 | 41.7 | 44 | F
84 days, 4:01:00 | [NAME] | 1 | Mathematics 1A (Eng) | 16 | 2185 |  | HA | 1 2020-02-12 00:00:00
84 days, 4:01:00 | MATH132H1 | 1 | Applied Mathematics 1A (Eng) | 16 | 2185 |  | HA | Registered |  | 70 | 70 | 70 | P
Spreadsheet: darrell_schoolcraft__7302__imball0201
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -492632 | -494656
2 | -501900 | -485325
3 | -540213 | -539549
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
2001-12-31 00:00:00 |  |  |  |  | 104420
2002-01-03 00:00:00
CBS Dollars
 |  |  | 331917
Spreadsheet: 820023d1677828194-split-column-nowy-microsoft-excel-worksheet-2-ans
Sheet: Arkusz1

1 | 2 | 3 | 4 | 5
looks like this | Looks like this |  | Should look like this COLUMN | OR EVEN BETTER TO LOOK LIKE THIS COLUMN |  | FORMULA
41-203 | SŁONECZNA 14 SOSNOWIEC | →→ | SŁONECZNA 14 | [NAME], 41-203 SOSNOWIEC, POLSKA
40-315 | AL. ROŹDZIEŃSKIEGO 210 KATOWICE | →→ | AL. ROŹDZIEŃSKIEGO 210 | AL. ROŹDZIEŃSKIEGO 210, 40-315 KATOWICE, POLSKA
40-315 | GEN. [NAME] PSZCZYNA | →→ | GEN. [NAME] | GEN. [NAME], 40-315 PSZCZYNA, POLSKA
43-500 | 1 MAJA 7 GOLESZÓW | →→ | 1 MAJA 7 | 1 MAJA 7, 43-500 GOLESZÓW, POLSKA
40-212 | ROLNA 14 KATOWICE | →→ | ROLNA 14 | ROLNA 14, 40-212 KATOWICE, POLSKA
Spreadsheet: 771319d1646611004-count-if-multiple-strings-and-words-are-found-in-2-columns-sample-file
Sheet: Sheet1

Count Formula |  |  | Filter | Location
 | <----count should be 6 |  | 2.0-Walls | East
 |  |  | 1.5-Rails | South
[NAME] |  |  | 3.1-Chairs | East
Sidewalk |  |  | 2.2-Sidewalk | West
Benches |  |  | 2.5-Grills | South
Walls |  |  | 2.5-Fixtures | North
Rails |  |  | 1.6-Benches | West
 |  |  | 1.8-Chairs | South
 |  |  | 2.2-Walls | North
 |  |  | 2.3-Rails | South
 |  |  | 1.7-Fixtures | East
 |  |  | 2.8-Benches | West
 |  |  | 2.6-Sidewalk | North
 |  |  | 7.2-Fixtures | East
 |  |  | 1.0-Walls | North
 |  |  | 2.7-Grills | South
Spreadsheet: 474284d1470707070-copy-multiple-columns-to-another-workbook-master
Sheet: 2015 Catalogue

 | Catalogue 2015 Australian Price List - June 2016
Pg | Landscape Architect
5 | ORB3-2000
5 | ORB8-2000
6 | SS4-1000
6 | ORB4-2004
7 | SS3-1000
7 | SS2-1008
7 | ORB4-2000
8 | ORB10-2001
8 | SS4-1002
8 | ORB15-2000
10 | ORB18-2000
10 | SS9-1000
Spreadsheet: 197770d1354556371-chart-needs-to-auto-populate-items-from-master-referance-chart-based-on-job-description-job-desc
Sheet: Sheet1

 |  |  |  |  |  |  |  | Employee | Job | First aid | Forklift training | PPE
 | Job | First aid | Forklift training | PPE |  |  |  | [NAME] | driver
 | Warehouse | y | y | y |  |  |  | Jo | driver
 | Driver | y | n | y |  |  |  | [NAME] | warehouse
 | Office | y | n | n |  |  |  | [NAME] | office
Spreadsheet: 115115d1310735428-accurate-calculation-of-the-difference-between-two-dates-hopefully-the-best-date-difference-calculator-ever
Sheet: Sheet2

Date difference calculator |  | Input start date | Input end date |  | get the starting year |  | End of starting year date is |  | Days till the end of the starting year |  | get the ending year |  | get the start of ending year |  | Days till the start of ending year |  | Difference between the years |  | Add the days |  | the decimal in days | Yearfrac gives... |  | the decimal in days | 365.25 rounded to 2dp gives |  | the decimal in days
 |  | 1973-03-17 00:00:00 | 2011-03-18 00:00:00
Spreadsheet: 873272d1719755800-sumproduct-countef
Sheet: Sheet1

[NAME] | Yes | No | Yes | Yes | Yes | Yes
[NAME] | No | Yes | No | No | No | No
[NAME] | No | No | Yes | No | No | Yes
[NAME] | No | No | No | Yes | No | No
[NAME] | Yes | No | No | No | Yes | No
[NAME] | Yes | No | Yes | Yes | No | Yes
[NAME] | Yes | No | Yes | No | No | Yes
[NAME] | Yes | Yes | Yes | No | No | Yes
[NAME] | No | No | No | No | No | Yes
[NAME] | No | No | Yes | Yes | Yes | No
[NAME] | Yes | Yes | Yes | No | No | No
 | Yes | No
[NAME]
[NAME]
[NAME]
Spreadsheet: 26647a9f-a009-41a3-a0d8-d9c8e0d414cf
Sheet: Balance Sheet

 |  | Event Budget Spreadsheet
 |  | Income |  |  |  |  |  |  |  |  |  | Expenses
 |  | Starting Budget |  |  |  |  |  |  |  |  |  | Total Expenses
 |  | Registration |  |  |  |  |  |  |  |  |  | Facility Rental/Venue
 |  | Sponsor 1 |  |  |  |  |  |  |  |  |  | Equipment
 |  | Sponsor 2 |  |  |  |  |  |  |  |  |  | Marketing Materials
 |  | Sponsor 3 |  |  |  |  |  |  |  |  |  | Coaches/Multi-Sport Professionals
 |  | Sponsor 4 |  |  |  |  |  |  |  |  |  | Licenses/Usage Fees
 |  | USAT Memberships |  |  |  |  |  |  |  |  |  | Lunches/Meals
 |  | Other Income |  |  |  |  |  |  |  |  |  | Audio/Visual Equipment
 |  |  |  |  |  |  |  |  |  |  |  | Emergency Services
 |  | In-Kind Donations (List Here) |  |  |  |  |  |  |  |  |  | Other Expenses
 |  |  |  |  |  |  |  |  |  |  |  | Other Expenses
Spreadsheet: 871141d1717570569-how-do-i-store-a-batterys-state-of-charge-past-midnight-example
Sheet: Sheet1

Existing - no loop |  |  |  |  | How it should look - looped |  |  |  |  | How it actually looks - looped |  |  |  |  |  | [NAME] battery state | Min battery state
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 0
Jan | Energy Consumption | Battery State |  |  | Jan | Energy Consumption | Looping Battery State |  |  | Jan | Energy Consumption | Looping Battery State
Midnight |  |  |  |  | Midnight |  |  |  |  | Midnight
00:00:00 | 1 |  |  |  | 00:00:00 | 5 |  |  |  | 00:00:00 | 5
00:05:00 | 1 |  |  |  | 00:05:00 | 5 |  |  |  | 00:05:00 | 5
00:10:00 | 1 |  |  |  | 00:10:00 | 5 |  |  |  | 00:10:00 | 5
00:15:00 | 1 |  |  |  | 00:15:00 | 5 |  |  |  | 00:15:00 | 5
00:20:00 | 1 |  |  |  | 00:20:00 | 5 |  |  |  | 00:20:00 | 5
00:25:00 | 1 |  |  |  | 00:25:00 | 5 |  |  |  | 00:25:00 | 5
00:30:00 | 1 |  |  |  | 00:30:00 | 5 |  |  |  | 00:30:00 | 5
Sunrise |  |  |  |  | Sunrise |  |  |  |  | Sunrise
13:00:00 | -5 |  |  |  | 13:00:00 | -5 |  |  |  | 13:00:00 | -5
13:05:00 | -5 |  |  |  | 13:05:00 | -5 |  |  |  | 13:05:00 | -5
13:10:00 | -5 |  |  |  | 13:10:00 | -5 |  |  |  | 13:10:00 | -5
13:15:00 | -5 |  |  |  | 13:15:00 | -5 |  |  |  | 13:15:00 | -5
13:20:00 | -5 |  |  |  | 13:20:00 | -5 |  |  |  | 13:20:00 | -5
13:25:00 | -5 |  |  |  | 13:25:00 | -5 |  |  |  | 13:25:00 | -5
Sunset |  |  |  |  | Sunset |  |  |  |  | Sunset
23:40:00 | 1 |  |  |  | 23:40:00 | 2 |  |  |  | 23:40:00 | 2
23:45:00 | 1 |  |  |  | 23:45:00 | 2 |  |  |  | 23:45:00 | 2
23:50:00 | 1 |  |  |  | 23:50:00 | 2 |  |  |  | 23:50:00 | 2
23:55:00 | 1 |  |  |  | 23:55:00 | 2 |  |  |  | 23:55:00 | 2
Midnight |  |  |  |  | Midnight |  |  |  |  | Midnight
Spreadsheet: 161189d1339439435-excel-2007-problem-with-countif-and-sumif-non-continuous-cells-sample
Sheet: TNSR

TOTAL DE  NOTAS DE LOS ESTUDIANTES SEGUNDO R
[NAME] |  |  |  |  | 1ER SEMESTRE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2DO SEMESTRE
 |  |  |  |  | PROYECTOS O EXAMENES |  |  |  | PUNTOS [NAME] SUMATIVAS |  |  |  |  |  |  |  |  |  |  |  |  | PROYECTOS O EXAMENES |  |  |  | PUNTOS [NAME] SUMATIVAS
NOMBRE DEL ALUMNO |  |  |  | [NAME] | 50 |  |  |  |  |  |  |  |  |  |  |  |  | RESUMEN 1ER SEM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RESUMEN 2DO SEM |  |  |  | TOTAL
 |  |  |  |  | A
Apellido 1ro |  | Apellido 2do | Nombre |  | N1 | N2 | N3 | N4 | SUMATIVA1 | SUMATIVA2 | SUMATIVA3 | [NAME] | SUMATIVA5 | SUMATIVA6 | SUMATIVA7 | SUMATIVA8 | SUMATIVA9 | [NAME] | [NAME] | [NAME] | NOTA | N5 | [NAME] | N7 | N8 | SUMATIVA10 | [NAME] | SUMATIVA12 | SUMATIVA13 | [NAME] | SUMATIVA15 | SUMATIVA16 | SUMATIVA17 | SUMATIVA18 | [NAME] | [NAME] | [NAME] | NOTA | [NAME] | [NAME] | [NAME] | NOTA |  |  | SEXO
 |  |  |  |  |  | A
 |  |  |  |  |  | D
 |  |  |  |  | N | N | N | N | N | N |  |  | N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  | 1 | 50
 |  |  |  | 2 | 35
 |  |  |  | 3 | 40
 |  |  |  | 4 | 30
 |  |  |  | 5 | 25
 |  |  |  | 6 | 45
 |  |  |  | 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
 |  |  |  | 34
 |  |  |  | 35
 |  | I tried  with this also->
Spreadsheet: 817245d1676070951-automated-e-mail-on-change-in-cell-value-with-no-manual-intervention-spreadsheet-for-e-mail-example
Sheet: Sheet1

 |  | How many alerts were created? | Average alerts per minute? |  | Average per second?
 |  | 4416
 |  | How many ip addresses contacted you? | How many ip addresses were known? |  | Percent Known
 |  | 125060
 |  | How many ip addresses you contacted? | How many known IP address(es) did your systems respond to? |  | Percent Unknown
 |  | 63112
 |  | What is most common alert types? | % of Alerts
 |  | Known IP | 0.5046601500340987
 |  | Related IP | 0.4130484200954763
 |  | Unknown IP | 0.08229142987042509
Spreadsheet: phillip_m_love__30145__200003_OA
Sheet: TX-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 14334003 | 37623502.06999999
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 231232 | 623375.39
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 120000
 | Total Sales: |  | 14565235 | 38366877.45999999
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -4774355 | -12227599.22999999
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -19000 | -50650
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 15686 | 42585.12
 | Total Purchases: |  | -4777669 | -12235664.10999999
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 24311564 | 67805876.08
12 |  | Purchases | -25280680 | -70510817.64
 | Total Intra CTS Sales / Purchases |  | -969116 | -2704941.56
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | -231232 | -623375.45
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -231232 | -623375.45
 | Total Storage: |  | -231232 | -623375.45
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -8587218 | -21814188.70260814
 |  |  | 0 | 0
23 | Fuel: |  | -15686 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -551397
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -551397
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | -8691498.19
31 |  | Prior Month Book Balance | 0 | 7489615
 |  | Total MTM Income | 0 | -1201883.19
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 1296213.95
34 |  | Originations | 0 | 2584
35 |  | Broker Fees | 0 | -1075
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 102711
 |  | TOTAL INTRA-MTH
FT-South Texas
 |  | Current Month MTM | 0 | -166392
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 718913d1613412122-pulling-missing-rows-from-different-sheet-book123
Sheet: Sheet1

ID | fee
123 | 34
456 | 56
564 | 89
654 | 1
Spreadsheet: larry_campbell__20970__PG&E Samples
Sheet: PG&E Page 6

CONFIDENTIAL
[NAME] and PG&E Samples and Analytical Results
Date | Sample ID |  | Volume Drained |  | Comments |  |  |  | PG&E PCB | TW PCB | Location of sample point
 |  |  |  |  |  |  |  |  |  |  | Filter Scrubbers Downstream of
1999-04-15 00:00:00 | SLX-TW | 4-15-99-L |  |  |  |  |  |  |  |  | Solexol Plant
 |  |  |  |  |  |  |  |  |  |  | TW's Filter Scrubber at TW/PG&E
1999-04-15 00:00:00 | PGE-TW2 | 4-15-99-L |  |  |  |  |  |  |  |  | Metering Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Seperator at PG&E's
1999-04-15 00:00:00 | PGE-Top3 | 4-15-99-L |  |  |  |  |  |  |  |  | Compressor Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line A TCS
1999-04-15 00:00:00 | PGE-A6 | 4-15-99-L |  |  |  |  |  |  |  |  | Downstream Scrubber
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line B TCS
1999-04-15 00:00:00 | PGE-B6 | 4-15-99-L |  |  |  |  |  |  |  |  | Downstream Scrubber
1999-04-15 00:00:00 | PGE 10.84A | 4-15-99-L |  |  |  |  |  |  |  |  | PG&E's 34" Line A
1999-04-15 00:00:00 | PGE 10.84B | 4-15-99-L |  |  |  |  |  |  |  |  | PG&E's 34" Line B
1999-04-15 00:00:00 | PGE 8.58A | 4-15-99-L |  |  |  |  |  |  |  |  | PG&E's 34" Line B
1999-04-15 00:00:00 | PGE-TW4 | 4-15-99-L |  |  |  |  |  |  |  |  | TW 20" 1st Siphon
1999-04-15 00:00:00 | PGE-TW5 | 4-15-99-L |  |  |  |  |  |  |  |  | TW 20" 2nd siphon
1999-04-15 00:00:00 | PGE-TW6 | 4-15-99-L |  |  |  |  |  |  |  |  | TW 20" 3rd Siphon
 |  |  |  |  |  |  |  |  |  |  | Filter Scrubbers Downstream of
1999-04-22 00:00:00 | SLX-TW | 4-22-99-L |  |  |  |  |  |  |  |  | Solexol Plant
 |  |  |  |  |  |  |  |  |  |  | TW's Filter Scrubber at TW/PG&E
1999-04-22 00:00:00 | PGE-TW2 | 4-22-99-L |  |  |  |  |  |  |  |  | Metering Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Seperator at PG&E's
1999-04-22 00:00:00 | PGE-Top3 | 4-22-99-L |  |  |  |  |  |  |  |  | Compressor Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line A TCS
1999-04-22 00:00:00 | PGE-A6 | 4-22-99-L |  |  |  |  |  |  |  |  | Downstream Scrubber
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line B TCS
1999-04-22 00:00:00 | PGE-B6 | 4-22-99-L |  |  |  |  |  |  |  |  | Downstream Scrubber
1999-04-22 00:00:00 | PGE 10.84A | 4-22-99-L |  |  |  |  |  |  |  |  | PG&Es 34" Line A
1999-04-22 00:00:00 | PGE 10.84B | 4-22-99-L |  |  |  |  |  |  |  |  | PG&E's 34" Line B
1999-04-22 00:00:00 | PGE 8.58A | 4-22-99-L |  |  |  |  |  |  |  |  | PG&E's 34" Line B
1999-04-22 00:00:00 | PGE-TW4 | 4-22-99-L |  |  |  |  |  |  |  |  | TW 20" 1st Siphon
1999-04-22 00:00:00 | PGE-TW5 | 4-22-99-L |  |  |  |  |  |  |  |  | TW 20" 2nd siphon
1999-04-22 00:00:00 | PGE-TW6 | 4-22-99-L |  |  |  |  |  |  |  |  | TW 20" 3rd Siphon
Spreadsheet: 146059d1331886369-get-sum-of-multiple-amount-in-column-book1
Sheet: Sheet1

[NAME] | 2436 |  |  |  | [NAME] | 114175.64
[NAME] | 46987.47 |  |  |  | item2 | 103446.18
[NAME] | 2529.75 |  |  |  | item3 | 116351.59
[NAME] | 4587.4
[NAME] | 257
[NAME] | 32
[NAME] | 54987.32
[NAME] | 2358.7
item2 | 3264.87
item2 | 23587.25
item2 | 16987.4
item2 | 2365.14
item2 | 7854.21
item2 | 6597.41
item2 | 1459.25
item2 | 4789
item2 | 36541.65
item3 | 1468.74
item3 | 9833.14
item3 | 65874.21
item3 | 2673
item3 | 9821
item3 | 367
item3 | 26314.5
item3 | 168.7