tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: michelle_lokay__26570__imbalsumm0012
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 105467 |  |  | 77908 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 131083 |  |  | 45263 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 134074 | 161714 |  | 31644 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 147980 | 162355 |  | 16460 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 145971 | 164906 |  | 22551 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 127718 |  |  | 45207 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 172839 |  |  | 8766 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 168553 |  |  | 21417 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 147907 |  |  | 28501 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 156409 |  |  | 11318 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 123568 | 164677 |  | 40741 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 | 166229 | 185212 |  | 22793 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 | 156491 |  |  | 25001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14 | 140824 | 153538 |  | 15227
15 | 159652 | 176538 |  | 19424 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 | 154895 | 164011 |  | 11465 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 | 142559 | 163518 |  | 24182 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18 | 182382 | 185948 |  | 7223
19 | 148178 | 156546 |  | 12871
20 | 153844 | 153538 |  | 2510
21 | 162746 | 167538 |  | 7650
22 | 166258 | 181221
23 | 164668 | 174965 |  | 8893
24 | 141426 | 169219 |  | 27435
25 | 136316 | 167125 |  | 28033
26
27
28
29
30
31
 | 2000-11-30 00:00:00 |  |  |  | -75432
 | 2000-12-25 00:00:00
Spreadsheet: mike_grigsby__27922__HS_WESTminusPA
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NATURAL GAS BASIS POSITIONS
 | 2001-10-22 00:00:00
 | West Region Basis Notional
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1
 | West Region Basis Notional
 | NGI-PGE/CG |  |  |  | NGI-PGE/CG |  | GDP-PG&E/CITIGA | NGI-PGE/CG | GDP-PG&E/LG-PKG |  |  |  | M | D
 | NGI-MALIN |  |  |  | NGI-MALIN |  | GDP-MALIN-CTYGA | NGI-MALIN |  |  |  |  | M | D
 | NGI-SOCAL |  |  |  | NGI-SOCAL | IF-SOCAL | GDP-CAL BORDER | NGI-SOCAL |  |  |  |  | M | D
 | TOPOCK |  |  |  | NGI-SOBDR-PG&E |  | NGI-SOBDR-PG&E |  |  |  |  |  | M | D
 | NWPL-ROCKIES |  |  | NW-STANFIELD | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-WYOMING | GDP-KERN/OPAL | GDP-NW STANFIEL | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-NWPL_ROCKYM | M | D
 | CIG-ROCKIES | IF-CIG/WINDRVR | IF-CIG/WIC | IF-CIG/RKYMTN | IF-CIG/SOUTHERN | IF-CIG/GLENROCK | IF-CIG/ROCKPORT | GDP-CIG/RKYMTN | GDP-CIG/CHEYENN | IM-CIG/SOUTHERN | IM_WINDRIVER |  | M | D
 | PERMIAN |  | IF-TW/PERMIAN |  | IF-ELPO/PERMIAN | IF-NNG/TOK | GDP-ELPO/PERM2 | IF-ELPO/PERMIAN | IF-TW/PERMIAN |  |  |  | M | D
 | SAN JUAN |  | IF-BONDAD(100%) | IF-ELPO/SJ | IF-EPSJ(BONDAD) |  | GDP-ELPO/SANJUA |  | IM-TW/SJ | IF-EPSJ(BONDAD) |  |  | M | D
 | KINGSGATE |  |  |  | CGPR-KINGSGATE |  | CGPR-KINGSGATE |  |  |  |  |  | M | D
 | WAHA |  |  |  | IF-WAHA-TX | IF-WAHA | WAHA KCBT | GDP-WAHA |  |  |  |  | M | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL
 | Western Canada Region Notional
 | SUMAS |  |  |  | IF-NTHWST/CANBR |  | SUMAS-US/IM | GDP-NTHWST/CANB | IF-NTHWST/CANBR |  |  |  | m | D
 | AECO/EMPRESS/STA2 |  |  |  | CGPR-AECO/BASIS |  | GD-CGPR-AECO/AV | GD-AECOCD/FRWKD | GD-AECOUS/FRWKD | [NAME] | GDP-AECO |  | m | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | p
Spreadsheet: 851649d1701833638-generate-unique-list-and-convert-data-layout-unique
Sheet: Sheet1

China | Malaysia | Japan |  |  | *how do I generate the list of unique name base on A2:C5?
[NAME] | [NAME] | [NAME] |  |  | I want to get
[NAME] | [NAME] | [NAME] |  |  | [NAME]
[NAME] | [NAME] | [NAME] |  |  | [NAME]
[NAME] | [NAME] | [NAME] |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | * Is it possible to use formula to convert the data to be like the below?
 |  |  |  |  | [NAME] | China
 |  |  |  |  | [NAME] | Japan
 |  |  |  |  | [NAME] | Malaysia
 |  |  |  |  | [NAME] | China
 |  |  |  |  | [NAME] | Japan
 |  |  |  |  | [NAME] | China
 |  |  |  |  | [NAME] | Malaysia
 |  |  |  |  | [NAME] | Japan
 |  |  |  |  | [NAME] | Malaysia
 |  |  |  |  | [NAME] | China
 |  |  |  |  | [NAME] | Japan
 |  |  |  |  | [NAME] | Malaysia
Spreadsheet: 540904d1507038711-moving-average-help-moving-average-help
Sheet: Sheet1

 | 1995 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 yr Avg | 15yr [NAME] | 10yr [NAME]
JAN | 0.02702705791164917 | -0.00649347440298409 | -0.06382976864055367 | 0.05974847677112294 | 0.1341772967188315 | 0.2261682727933068 | 0.1912257052536592 | -0.1107330881148835 | -0.01854305986788485 | 0.05983476846784419 | -0.08896037693638903 | 0.01350483181595208 | 0.08240227977693415 | -0.0800390531469024 | -0.2970297741472651 | -0.0788896426207808 | 0.0315933692509085 | 0.05549323689070262 | 0.08741678293836475 | -0.09525163491612176 | -0.1365707590157532 | -0.006995581737849865
Spreadsheet: 733548d1621614899-sum-with-duplicates-dates-and-max-classeur2
Sheet: Feuil1

Phase | Clients | End date | Sq meters
Current OA | Client 1 | 2025-03-31 00:00:00 | 1256
Current OA | Client 2 | 2027-03-31 00:00:00 | 474.8
Current OA | Client 3 | 2022-10-31 00:00:00 | 1443.2
Current OA | Vacant | 2025-03-31 00:00:00 | 1263.8
Current OA | Parking | 2046-03-31 00:00:00 | 0
Current OA | Locaux entrepreneur immobilier | 2046-03-31 00:00:00 | 78.9
As Is Renewal | Client 6 | 2025-03-31 00:00:00 | 1443.2
As Is Renewal | Vacant | 2025-03-31 00:00:00 | 2397 |  | Duplicates
As Is Renewal | Vacant | 2046-03-31 00:00:00 | 2764.2
Fit up 100% | Client 1 | 2035-03-31 00:00:00 | 1256
Fit up 100% | Client 2 | 2037-03-31 00:00:00 | 474.8
Fit up 100% | Client 3 | 2035-03-31 00:00:00 | 1076
Current lease | Private client 4 | 2024-03-31 00:00:00 | 1133.2
Current lease | Private client 5 | 2023-11-30 00:00:00 | 0
What I need :
As Is Renewal | 1443,20+2764,20 | [NAME] that gives the addition of sq meter for this phase, but if there are any duplicates, the formula must only take into account the latest date.
 |  | Note that the phases will not be sorted all the time.
Current OA
Fit up 100% |  |  | No problem with these because there will never be duplicates.
Current lease
Spreadsheet: 889132d1739853409-start-a-counter-from-0-based-on-another-cells-value-increasing-test-counter
Sheet: Sheet1

Machine | Total parts produced at machine (manually updated) | Maintanence schedule | Counter starting from 0
1 | 12745 | 1000 | 0 | When counter for each machine gets to its maintanence schdule its will be highlighted triggering maintenance   My team can them perfom maintanence then reset the counter back to 0
2 | 4257 | 1000 | 0
3 | 8654 | 1500 | 0
4 | 414725 | 1500 | 0
5 | 12541 | 1000 | 0
6 | 102451 | 500 | 0
7 | 180507 | 800 | 0
8 | 2056345 | 500 | 0
9 | 230764 | 900 | 0
10 | 2558852 | 800 | 0
11 | 28381 | 1000 | 0
 | each machine has different parts produced rate of increase | different depending on part or machine
Spreadsheet: benjamin_rogers__1141__99 Plants contact numbers
Sheet: Brownsville

 | [NAME]
 | 948 Beech Grove Road, Brownsville, TN 38012
 | General Phone Numbers |  |  | Plant Personnel
 | Control Room | [PHONE] |  | Name | Title | Office | Cellular | Home | [NAME]
 | Control Room Fax | [PHONE] |  | Mitchell Hurt | Plant Manager | [PHONE] | [PHONE]
 | Plant Fax | [PHONE] |  | [NAME] | Plant Supervisor | [PHONE] | [PHONE] | [PHONE]
 | On Call Pager 1 | [PHONE] |  | [NAME] | Admin. [NAME]. |  |  | [PHONE]
 | On Call Pager 2 | [PHONE] |  | [NAME] | Tech | [PHONE] | N/A | [PHONE] |  |  | TVA Control Room | [PHONE]
 |  |  |  | [NAME] | Tech | [PHONE] | N/A | [PHONE]
 |  |  |  | Shane Hanson | Tech | [PHONE] | N/A | [PHONE]
 |  |  |  | [NAME] | Tech | [PHONE] | N/A | [PHONE]
 | Neighboring Control Areas |  |  | [NAME] | [NAME] |  |  | [PHONE]
 | TVA Security Coordinator | [PHONE]
 | TVA Transmission | [PHONE] |  |  | Emergency Numbers
 | TVA Control Room | [PHONE] |  |  | Fire | [PHONE]
 | FAX | [PHONE] |  |  | Ambulance | [PHONE]
 | TVA Marketing | [PHONE] |  |  | Police | [PHONE]
 | FAX | [PHONE] |  |  | Sheriff | [PHONE]
 |  |  |  |  | Chemical Spills | [PHONE]
 | [NAME]
 | Gas Control | [PHONE]
Spreadsheet: 671267d1586335475-update-defining-exact-length-of-string-for-istext-within-aggregate-function-00-wages-template-for-tests
Sheet: 13 SATURDAY

DAY: |  | SATURDAY |  | DATE:
No. |  | NAME |  |  |  | FROM | TO | Wh | VL | SL | OT | F/L | Hr | F/L | Hr | F/L | Hr | F/L | Hr | JOBS | Hr | GR/WS | Hr | CHECK |  | JOBS BREAKDOWN
12 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | GROUPAGE
11 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DRIVERS |  |  | DRIVERS
14 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PART TIMERS |  |  | PART TIMERS
33 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WELDERS |  |  | WELDERS
37 | W
27 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS
53 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
54 | W
50 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
30 | P
31 | P
32 | P
51 | P
52 | P
55 | P
15 | P
23 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPAIRS MT
26 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
6 | D
10 | D
47 | D
[NAME] |  |  |  |  | GROUPAGE |  |  | IDLE TIME |  |  |  |  | JOBS |  |  |  | REPAIRS MT |  |  |  | WORKSHOP WS
JOBS |  |  | HR |  | JOBS | HR |  | JOBS |  |  | HR |  | JOBS |  | HR |  | JOBS |  | HR |  | JOBS |  | HR
TOTAL |  |  |  |  | TOTAL |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 |  |  |  |  | Hours Calculator |  |  |  |  |  |  |  |  |  |  | TOTAL 2 |  |  |  |  | TOTAL 1
Spreadsheet: 526152d1499165882-pick-name-out-of-string-data-pull
Sheet: After

OUTPUT NEEDED | Period | [NAME] | Source | [NAME]
[NAME] | P06-17 | Accrual | Spreadsheet | Reverses "phone Telecoms Accrual GBP"02- May 17 [PHONE] [PHONE] [NAME]
[NAME] | P06-17 | Accrual | Spreadsheet | Reverses "phone Telecoms Accrual GBP"02- May 17 [PHONE] [PHONE] [NAME]
[NAME] | P06-17 | Accrual | Spreadsheet | Reverses "phone Telecoms Accrual GBP"02- May 17 [PHONE] [PHONE] [NAME]
[NAME] | P06-17 | Accrual | Spreadsheet | Reverses "T&E Accrual Accrual - Manual Po T&E Accrual Accrual GBP - Morris, Mr. [NAME] - 09-05-2017 - HELLO
[NAME] | P06-17 | Accrual | Spreadsheet | Reverses "T&E Accrual Accrual - Manual Po T&E Accrual Accrual GBP - Morris, Mr. [NAME] - 09-05-2017 - HELLO
[NAME] | P06-17 | Accrual | Spreadsheet | Reverses "T&E Accrual Accrual - Manual Po T&E Accrual Accrual GBP - Thompson, Miss. [NAME] ([NAME]) - 09-05-2017 - HELLO HELLO
[NAME] | P06-17 | Accrual | Spreadsheet | Reverses "T&E Accrual Accrual - Manual Po T&E Accrual Accrual GBP - Thompson, Miss. [NAME] ([NAME]) - 09-05-2017 - HELLO HELLO
[NAME] | P06-17 | Accrual | INTERNET EXPENSES | OFJ T&E Accrual Accrual GBP Thompson,Annie - 31-MAY-17 - HELLO HELLO HELLO
[NAME] | P06-17 | Accrual | INTERNET EXPENSES | OFJ T&E Accrual Accrual GBP Morris,[NAME] - 31-MAY-17 - HELLO HELLO HELLO
[NAME] | P06-17 | Accrual | INTERNET EXPENSES | OFJ T&E Accrual Accrual GBP Morris,[NAME] - 31-MAY-17 - HELLO HELLO HELLO
[NAME] | P06-17 | Accrual | INTERNET EXPENSES | OFJ T&E Accrual Accrual GBP Thompson,Annie - 31-MAY-17 - HELLO HELLO HELLO
[NAME] | P06-17 | Accrual | INTERNET EXPENSES | OFJ T&E Accrual Accrual GBP Thompson,Annie - 31-MAY-17 - HELLO DOT CO DOT UK
[NAME] | P06-17 | Accrual | INTERNET EXPENSES | OHJ PCARD Accrual Accrual GBP Morris,[NAME] - 17-JUN-17 - HELLO UK LTD
[NAME] | P06-17 | Accrual | INTERNET EXPENSES | OHJ PCARD Accrual Accrual GBP Morris,[NAME] - 17-JUN-17 - HELLO UK LTD
[NAME] | P06-17 | Accrual | INTERNET EXPENSES | OHJ PCARD Accrual Accrual GBP Morris,[NAME] - 17-JUN-17 - HELLO UK LTD
Spreadsheet: 0791d3d9-ae77-4c49-bd54-8b3347914f8a
Sheet: 2008-09

Table N
Students Domiciled within the UK by Method of Study
Country/Region | Undergraduate |  |  | Graduate |  |  | Total
 | Full Time | Part Time | Total | Full Time | Part Time | Total
England
Greater London | 3496 | 99 |  | 1348 | 1368
South East | 2313 | 34 |  | 686 | 617
South West | 558 | 8 |  | 140 | 96
North and Yorkshire | 373 | 3 |  | 100 | 62
North West | 346 | 5 |  | 86 | 48
Midlands | 690 | 10 |  | 145 | 145
East Anglia | 331 | 6 |  | 116 | 101
Not Known | 2 | 0 |  | 5 | 7
Subtotal
Northern Ireland | 70 | 4 |  | 14 | 12
Scotland | 79 | 0 |  | 53 | 22
Wales | 199 | 2 |  | 42 | 27
Channel Isles and Isle of Man | 23 | 1 |  | 0 | 5
Not Known | 12 | 12 |  | 27 | 33
Total
This table is concerned with students whose domicile at the time of application is within the UK irrespective of nationality.
The sum of Tables N and O is equivalent to the total number of students attending UCL.
Spreadsheet: 873677d1720190909-issue-with-if-function-zero-and-blank-cells-sample
Sheet: Sheet1

Bank | Reference | Interim business | Interim tax | Revised interim | Revised tax | Q1 | Q2 | Q3 | [NAME] | Final business | Final tax | Current business | Current tax
Company 1 | A1 | 1 |  | 2 |  | N | N | N | N | 3
Company 2 | A2 | 3 |  | 2 |  | N | N | N | N | 1
Company 3 | A3 | 1 |  | 2 |  | N | N | N | N | 0
Company 4 | A4 | 1 |  |  |  | N | N | N | N | 3
Company 5 | A5 | 3 |  | 2 |  | N | N | N | N
Company 6 | A5 | 3 |  |  |  | N | N | N | N
Company 7 | A5 |  |  |  |  | N | N | N | N | 3
Spreadsheet: 99158d1297888503-formula-to-match-values-rhudgins-complex-lookup
Sheet: Sheet1

 |  |  |  |  |  |  |  | Input Trades
 |  |  |  |  |  |  |  | #
 |  |  |  |  |  |  |  |  | Basket Name | Test
 |  |  |  |  |  |  |  |  | Symbol | Side | Last Activity | Shares | [NAME] | Dollar Value | Index
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  | 20
 | Enab | [NAME] | Symbol | Side | Quantity | Open Quantity | Exec Qty | [NAME] | Notional | Open Notional | % Exec | Exec Notional | [NAME] | % ADV21 | PL1 (Real) | PL1 (Unreal) | PL1 ( Total) | Beta | Prv | Last | % Chg | Bid | Ask | Curr Trade Vol | Rej
 | 0 | TEST | [NAME] | Sell | 100 | 0 | 100 | 0 | 150462 | 0 | 100 | 150441 | 1504.41 | 999 | 290882 | 0 | 290882 | 0 | 50 | 1504.41 | 2908.82 | 1053.09 | 2173.25 | 50900 | 0
 | 0 | TEST | ZWZZT | Buy | 300 | 0 | 300 | 0 | 599844 | 0 | 100 | 600000 | 2000 | 999 | 0 | 0 | 0 | 0 | 2000 | 2000 | 0 | 1999.48 | 2000 | 8400 | 0
 | 0 | TEST | ZVZZT | Buy | 1000 | 0 | 1000 | 0 | 12852380 | 0 | 100 | 10000000 | 10000 | 999 | -40000 | 0 | -40000 | 0 | 2000 | 10000 | 400 | 10000 | 10000.01 | 425800 | 0
 | 0 | Example | IBM | Sell | 100 | 0 | 100 | 0 | 150462 | 0 | 100 | 150441 | 1504.41 | 999 | 290882 | 0 | 290882 | 0 | 50 | 1504.41 | 2908.82 | 1053.09 | 2173.25 | 50900 | 0
 | 0 | Example | LCC | Buy | 300 | 0 | 300 | 0 | 599844 | 0 | 100 | 600000 | 2000 | 999 | 0 | 0 | 0 | 0 | 2000 | 2000 | 0 | 1999.48 | 2000 | 8400 | 0
 | 0 | Example | HPQ | Buy | 1000 | 0 | 1000 | 0 | 12852380 | 0 | 100 | 10000000 | 10000 | 999 | -40000 | 0 | -40000 | 0 | 2000 | 10000 | 400 | 10000 | 10000.01 | 425800 | 0
 | 0 | TEST | AAPL | Buy | 1000 | 0 | 1000 | 0 | 12852380 | 0 | 100 | 10000000 | 10000 | 999 | -40000 | 0 | -40000 | 0 | 2000 | 10000 | 400 | 10000 | 10000.01 | 425800 | 0
Spreadsheet: eric_saibi__9780__013102R
Sheet: Northside 02

Owner Name |  | Jacsonville Electric Authority
Station Name |  | Northside [NAME]
Unit Name |  | Northside 02
NERC Region |  | FRCC
State |  | FL
Fuel Type |  | Coke
Capacity |  | 289 MW
Start Date |  | 1999-05-17 00:00:00
End Date |  | 2002-02-01 00:00:00
Prv. Start Date |  | 1999-05-17 00:00:00
Prv. End Date |  | 2002-03-07 00:00:00
Comments |  | Rebuilt unit to change fuel supply  from fuel oil to coke, however unit will start out on coal then move to coke.
SIC |  | 4911
Plant ID |  | 1021650
Unit ID |  | 1007150
Outage ID |  | 8045
Spreadsheet: 453874d1459502549-retrieve-value-from-list-based-on-2-criteria-incl-date-example2
Sheet: Resources

Date+Rec | Resource | Role | Int/Ext | Per Datum
 | [NAME] | AAA | Internal | 1501
 | [NAME] | AAA | Internal | 1501
 | Bernard | FFF | Internal | 1501
 | Ad van B | GGG | External | 1501
 | [NAME] | EEE | Internal | 1501
 | Frans Ti | HHH | Internal | 1501
 | Lisette | QQQ | Internal | 1501
 | [NAME] | GGG | Internal | 1501
 | Bernard | HHH | Internal | 1506
 | Ad van B | UUU | External | 1506
 | [NAME] | RRR | Internal | 1506
 | Frans Ti | YYY | Internal | 1509
 | [NAME] | ZZZ | External | 1509
Spreadsheet: 750895d1633712955-search-and-find-between-2-sheets-book1
Sheet: Sheet2

Cart 1 | Cart 2 | Cart 3 | Cart 4 | Cart 5
98478
 |  |  |  | 123456
Spreadsheet: 598594d1542620307-formula-used-in-weekly-reduction-of-work-hours-test-workbook-tms
Sheet: SGA-SSO

 | Mar - 01st | Mar - 05th | Mar - 12th | Mar - 19th | [NAME] | Monthly | Hours | Burn
 | Mar - 04th | Mar - 11th | Mar - 18th | Mar - 25th | Mar - 31st | Totals | Balance | Rate
LSSO Authorized
LSSO Billable Hours
[NAME]
LSSO Billable OT
[NAME]
SSO Authorized
SSO Billable Hours
SSO Non-Billable Hours
SSO Billable OT
SSO Non-Billable OT
Burn Rate
Spreadsheet: 845144d1696667394-filter-by-column-and-by-row-competence-matrix-filter
Sheet: Sheet1

Name/skill | Tamplar | Macelar | [NAME] | Mecanic |  |  | FILTER |  | FILTER |  | Result
Marian | C | c | X
George |  | X |  |  |  |  | Tamplar | False | X | True | George
Alina | X |  |  |  |  |  | Macelar | True | C | True | Cristian
Radu |  |  |  |  |  |  | [NAME] | False
Cristian |  | X | C |  |  |  | Mecanic | False
Name/skill | Tamplar | Macelar | [NAME] | Mecanic |  |  | FILTER | FILTER |  |  | Result
Marian | C |  | X |  |  |  |  |  |  |  | Marian
George | C | X |  |  |  |  | Tamplar | X |  |  | George
Alina | X |  |  | C |  |  | Macelar | C |  |  | Alina
Radu | X | X |  |  |  |  | [NAME] |  |  |  | Radu
Cristian |  | X | C |  |  |  | Mecanic
Name/skill | Tamplar | Macelar | [NAME] | Mecanic |  |  | FILTER | FILTER |  |  | Result
Marian | C |  | X |  |  |  |  |  |  |  | George
George | C | X | C |  |  |  | Tamplar | X |  |  | Radu
Alina | X |  |  | C |  |  | Macelar | C
Radu | X | X | X |  |  |  | [NAME]
Cristian |  | X | C |  |  |  | Mecanic
Name/skill | Tamplar | Macelar | [NAME] | Mecanic |  |  | FILTER | FILTER |  |  | Result
Marian | C |  | X |  |  |  | Marian | X |  |  | Mecanic
George | C | X | C |  |  |  | George | C
Alina | X |  |  | C |  |  | Alina
Radu | X | X | X |  |  |  | Radu
Cristian |  | X | C |  |  |  | Cristian
Spreadsheet: benjamin_rogers__1306__site_visit_schedule for Jeff Keenan
Sheet: Schedule

As of…
E2 Site Visit Schedule
 |  |  | [NAME] ([NAME]) | Lincoln (Fred/Ross) | Wheatland (Jeff/Chris) | [NAME] | Pastoria
Week 1 | 2000-10-12 00:00:00 | Thur
 | 2000-10-13 00:00:00 | Fri |  |  | Duke (morning)
 |  |  |  |  | confirm sent
Week 2 | 2000-10-16 00:00:00 | Mon
 | 2000-10-17 00:00:00 | Tue |  |  | DPL (morning)
 |  |  |  |  | confirm sent
 | 2000-10-18 00:00:00 | Wed |  |  | NRG (afternoon)
 |  |  |  |  | [NAME]
 | 2000-10-19 00:00:00 | Thur
 | 2000-10-20 00:00:00 | Fri |  |  | confirm sent
 |  |  |  |  | Allegheny (afternoon)
Week 3 | 2000-10-23 00:00:00 | Mon |  |  | confirm sent
 |  |  |  |  | Cinergy (afternoon)
 | 2000-10-24 00:00:00 | Tue |  |  | Peco
 |  |  |  |  | [NAME]
 | 2000-10-25 00:00:00 | Wed |  |  | LG&E (late morning)
 |  |  |  |  | confirm sent
 | 2000-10-26 00:00:00 | Thur |  |  | [NAME] (morning)
 |  |  |  |  | Confirm sent
 | 2000-10-27 00:00:00 | Fri |  |  | Calpine (morning)
 |  |  |  |  | confirm sent
Spreadsheet: 680241d1590872431-how-to-copy-every-10-rows-from-multiple-sheets-to-one-sheet-rezaworksheet
Sheet: sheet8

29
45
687
432
567
1
3
98
7
456
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Spreadsheet: 801328a2-934c-429e-a234-3cf1a8fbe8d0
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43249457 | 2014-09-21 10:54:12 | AXIS | 0 | 2 | 6 | 911368 | peter.jackson15 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
43249619 | 2014-09-21 11:10:29 | ALLIES | 1 | 6 | 3 | 911368 | peter.jackson15 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
43249845 | 2014-09-21 11:25:49 | AXIS | 1 | 4 | 0 | 1507591 | darckjester | 6151 | western | 1944-07-21 | 1944-07-21 | [NAME] | [NAME]
43249914 | 2014-09-21 11:38:28 | ALLIES | 0 | 3 | 4 | 1507591 | darckjester | 6151 | western | 1944-07-21 | 1944-07-21 | [NAME] | [NAME]
43250059 | 2014-09-21 12:21:37 | AXIS | 1 | 10 | 5 | 535116 | Corporal [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43250391 | 2014-09-21 12:54:48 | ALLIES | 1 | 10 | 6 | 535116 | Corporal [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges