tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 216392d1361753734-counting-cells-that-contain-data-in-a-range-site-g-roster
Sheet: Calculation Page

 | DAY | NIGHT | ON CALL | MALE | FEMALE
HHB
BRAVO
CHARLIE
CPN
NATO
USAF |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HHB |  | Bravo |  | [NAME]
CIVILIANS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Orduevi | OnSite | Orduevi | OnSite | Orduevi | OnSite
243 ENG DET |  |  |  |  |  |  |  |  |  |  |  |  |  | LTC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | MAJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CPT
NIGHT SHIFT |  |  |  | DAY SHIFT |  |  |  |  | Mission Personnel Summary |  |  |  |  | 1LT
 | Males | Females |  |  | Males | Females |  |  | 3-2 ADA BN: |  |  |  |  | 2LT
HHB |  |  |  | HHB |  |  |  |  | CIVILIANS: |  |  |  |  | WO1
BRAVO |  |  |  | BRAVO |  |  |  |  | USAF: |  |  |  |  | CW2
CHARLIE |  |  |  | CHARLIE |  |  |  |  | 243 ENG DET: |  |  |  |  | CW3
TOTAL: |  |  |  | TOTAL: |  |  |  |  | NATO |  |  |  |  | CW4
NOTE: HHB numbers include all attached personnel from NATO, JPN, ENG, CIVs and USAF |  |  |  | NOTE: HHB numbers include all attached personnel from NATO, JPN, ENG, CIVs and USAF |  |  |  |  | CPN |  |  |  |  | CW5
 |  |  |  |  |  |  |  |  | TOTAL: |  |  |  |  | CSM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SGM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1SG
 |  |  |  |  |  |  |  |  |  |  |  |  |  | MSG
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SFC
HHB RANK BREAKDOWN |  |  |  |  |  |  | BRAVO RANK BREAKDOWN |  |  |  |  |  |  | SSG
Officers |  | NCOS |  | Soldiers |  |  | Officers |  | NCOS |  | Soldiers |  |  | SGT
LTC |  | CSM |  | SPC |  |  | LTC |  | CSM |  | SPC |  |  | CPL
MAJ |  | SGM |  | PFC |  |  | MAJ |  | SGM |  | PFC |  |  | SPC
CPT |  | 1SG |  | PV2 |  |  | CPT |  | 1SG |  | PV2 |  |  | PFC
1LT |  | MSG |  | PVT |  |  | 1LT |  | MSG |  | PVT |  |  | PV2
2LT |  | SFC |  |  |  |  | 2LT |  | SFC |  |  |  |  | PVT
WO1 |  | SSG |  |  |  |  | WO1 |  | SSG
CW2 |  | SGT |  |  |  |  | CW2 |  | SGT
CW3 |  | CPL |  |  |  |  | CW3 |  | CPL
CW4 |  |  |  |  |  |  | CW4
CW5 |  |  |  |  |  |  | CW5
TOTAL: |  | TOTAL: |  | TOTAL: |  |  | TOTAL: |  | TOTAL: |  | TOTAL:
Note: HHB numbers DO NOT reflect the civilians
 |  |  |  |  |  |  | CHARLIE RANK BREAKDOWN
 |  |  |  |  |  |  | Officers |  | NCOS |  | Soldiers
 |  |  |  |  |  |  | LTC |  | CSM |  | SPC
 |  |  |  |  |  |  | MAJ |  | SGM |  | PFC
 |  |  |  |  |  |  | CPT |  | 1SG |  | PV2
 |  |  |  |  |  |  | 1LT |  | MSG |  | PVT
 |  |  |  |  |  |  | 2LT |  | SFC
 |  |  |  |  |  |  | WO1 |  | SSG
 |  |  |  |  |  |  | CW2 |  | SGT
 |  |  |  |  |  |  | CW3 |  | CPL
 |  |  |  |  |  |  | CW4
 |  |  |  |  |  |  | CW5
 |  |  |  |  |  |  | TOTAL: |  | TOTAL: |  | TOTAL:
Spreadsheet: 62120d1263031578-advanced-filter-for-several-text-strings-advanced-filter2
Sheet: Sheet1

list |  |  | zz |  | ac |  | ab
a |  |  |  | put things you want to exclude here
ab
ac |  |  | list | list | list | list | list | list | list
d |  |  | <>zz |  | <>ac |  | <>ab
e
f |  |  |  |  | this is the criteria list
ab
ac
a
ab
ac
d
e
f
ab
ac
zz
zzz
ggg
Spreadsheet: 756895d1637856148-search-depending-on-criteria-searcher
Sheet: Pivot Table

Name | Apple
Location | Quantity
Shop1 | 1 |  |  | Shop | Name | Sum of Qty
Shop2 | 45 |  |  | shop1 | Apple | 1
Shop4 | 3 |  |  |  | Grapes | 546
 |  |  |  |  | Lemon | 21
 |  |  |  |  | Pineapple | 7
 |  |  |  | shop1 Total |  | 575
 |  |  |  | shop2 | Apple | 45
 |  |  |  |  | Pear | 31
 |  |  |  |  | Pineapple | 32
 |  |  |  |  | Watermelon | 32
 |  |  |  | shop2 Total |  | 140
 |  |  |  | shop3 | Grapes | 678
 |  |  |  |  | Orange | 439
 |  |  |  | shop3 Total |  | 1117
 |  |  |  | shop4 | Apple | 3
 |  |  |  |  | Grapes | 9
 |  |  |  |  | Pineapple | 4
 |  |  |  | shop4 Total |  | 16
 |  |  |  | shop5 | Orange | 213
 |  |  |  |  | Pineapple | 9
 |  |  |  |  | Watermelon | 42
 |  |  |  | shop5 Total |  | 264
 |  |  |  | Grand Total |  | 2112
Spreadsheet: 273376d1382696620-sum-of-different-lines-prosba_rebuilt
Sheet: B

 |  | 1
10101 |  | 12 | 78 | 56 | 9 | 45 | 848 | 45 | 45 | 78 | 46
11111 |  | 15 | 5 | 46 | 78 | 56 | 9 | 45 | 848 | 8 | 245
15465 |  | 78 | 56 | 9 | 45 | 848 | 98 | 65 | 8 | 8 | 45
12345 |  | 65 | 8 | 65 | 8 | 8 | 45 | 65 | 8 | 8 | 45
Spreadsheet: b3c4e5bd-4cb2-4084-a6a9-489694c7097e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FPHEN | Test | FPHEN | Benzene as Phenol, Occupational Exposure, [NAME] | Benzene as Phenol, Occ Exposure, U | Gas Chromatography/Flame Ionization Detection (GC-FID) Spectrophotometry (SPEC) | Plastic, urine tube: PlUrTb |  |  | 10 | mL | Collect 10 mL random urine without preservatives. Ship refrigerated in a plastic container. | 1.2 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Creatinine:  >50 mg/dL  Phenol: mg/L Phenol: mg/G creat   Normal (unexposed population): 	less than 10 mg/L   Exposed: 	Biological Exposure Index (BEI): 50 mg/g creatinine	(End of Shift)   Toxic: 	Not Established   Test Performed By:  Medtox Laboratories, Inc.                                402 W. County Road D                                St. Paul, MN  55112 | Monday through Sunday | 7 days | 9 - 11 days |  | Profile |  |  |  |  | Medtox Laboratories, Inc.
FPHEN | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
FPHEN | Result | Z1201 | Creatinine | Creatinine | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPHEN | Result | Z1063 | Phenol | Phenol | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPHEN | Result | Z1064 | Phenol | Phenol | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPHEN | Billing Component | FPHEN |  | ASSAY OF URINE CREATININE |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 82570
FPHEN | Billing Component | FPHEN |  | Volatiles |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84600
Spreadsheet: eric_saibi__9766__012302
Sheet: Unit 07 CTHRSG

Owner Name | NRG Energy Incorporated
Station Name | Long Beach Power Station
Unit Name | Unit 07 CT/HRSG
NERC Region | WSCC
State | CA
Fuel Type | Natural Gas / Jet Fuel
Capacity | 63 MW
Start Date | 2002-01-23 00:00:00
End Date | 2002-01-25 00:00:00
Comments | Inspection
SIC | 4931
Plant ID | 1021594
Unit ID | 1007067
Outage ID | 19590
Spreadsheet: 02d1dae1-973a-43a7-8632-adf467bd0460
Sheet: NI

Table | Nicaragua |  | Latin America and the Caribbean
 | Grain | Root | Commercial | Food aid |  | Aggregate
Year | production | production | imports | receipts |  | availability
 |  | (grain equiv.) | (grains) | (grain equiv.) |  | of all food
 |  |  | ---1,000 tons ---
2002 | 812.96 | 35.3204100974685 | 259.980826 | 64.14858600000001 |  | 1337.438875343758
2003 | 902.929 | 35.13532862770894 | 274.746893 | 43.03426 |  | 1367.735468793158
2004 | 712.739 | 29.50480275510572 | 302.864658 | 57.930694 |  | 1399.92406359657
2005 | 858.188 | 37.98856201293385 | 328.328768 | 42.820326 |  | 1441.275882972474
2006 | 788.197 | 35.91252703092147 | 301.018763 | 47.424517 |  | 1469.241721492698
2007 | 774.3 | 40.0042906829019 | 425.112636 | 56.059258 |  | 1500.080871676348
2008 | 787.835 | 40.34106499315838 | 373.613053 | 36.72947 |  | 1562.908199247518
2009 | 830.7 | 40.34106499315838 | 407.930485 | 9.344325000000001 |  | 1594.762322794865
2010(e) | 830 | 38.6278141481209 | 388.5994662467933 | 34.044351 |  | 1610.857533697325
Projections |  |  |  | Food gaps*
 |  |  |  | NG | DG
2011 | 832.4539371292531 | 39.25175082754509 | 382.9575798599922 | 0 | 33.20828186667376 | 1603.549844644352
2016 | 878.5301804543046 | 42.47500335589539 | 427.3948627337844 | 0 | 22.47036477733466 | 1775.065924179234
2021 | 925.2430231153465 | 45.87698658239155 | 452.2689365382034 | 0 | 15.43889388430462 | 1939.98039099992
Source: Economic Research Service, using data from FAOSTAT (grain and root and tuber production and imports), and the World Food Program (food aid).
*NR stands for nutritional requirements and describes the amount of grain equivalent needed to support nutritional standards on
*NG stands for nutritional gap and describes the amount of grain equivalent needed to support nutritional standards on
income quintile to reach the nutrional requirement.
Spreadsheet: eric_saibi__9945__110201R
Sheet: Arkansas Nuclear 02

Owner Name |  | Entergy Arkansas Inc.
Station Name |  | Arkansas Nuclear One
Unit Name |  | Arkansas Nuclear 02
NERC Region |  | SERC
State |  | AR
Fuel Type |  | Nuclear
Capacity |  | 943 MW
Start Date |  | 2001-11-01 00:00:00
End Date |  | 2001-11-04 00:00:00
Prv. Start Date |  | 2001-11-01 00:00:00
Prv. End Date |  | 2001-11-02 00:00:00
Comments |  | Rod problem.  Hoping to be back on line by the weekend.
SIC |  | 4911
Plant ID |  | 1521401
Unit ID |  | 1006260
Outage ID |  | 18783
Spreadsheet: 583761d1532629190-returning-names-in-ranked-order-with-ties-leaderboard
Sheet: Registration

Seat | Team | Username | Paid
1 | Team 1 | guy 1
2 | Team 1 | guy 2
3
4 | Team 2 | guy 3
5 | Team 2 | guy 4
6 | Team 3 | guy 5
7 | Team 3 | guy 6
8
9 | Team 4 | guy 7
10 | Team 4 | guy 8
11 | Team 5 | guy 9
12 | Team 5 | guy 10
13
14 | Team 6 | guy 11
15 | Team 6 | guy 12
16 | Team 7 | guy 13
17 | Team 7 | guy 14
18
19
20
21
22
23
24
25
26
27
28
29
30
31
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
Spreadsheet: 876857d1723571028-i-want-condition-based-relative-date-if-condition-is-in-a-range-then-first-date-and-last-under-work-1
Sheet: TEST

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  | 1234 |  | CL
PK | NM | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2024-01-11 00:00:00
1234 | AC | P | P | CL | LL | LL | P | P | CL | CL | CL | P
 | From | To
 | 2024-01-03 00:00:00 | 2024-01-03 00:00:00
 | 2024-01-08 00:00:00 | 2024-01-10 00:00:00
 | I want this out put only
Spreadsheet: b9a7719d-409d-463c-a902-117fdb766370
Sheet: Table 3.3

Monthly Statistical Bulletin
3.3  Wages and profits share
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012-13 | 2013-14
Wages share (a) (b) – per cent
September | 53.1 | 52.2 | 52.1 | 54 | 53.7
December | 52.5 | 52.1 | 52.5 | 54.4 | 53.3
March | 52.5 | 52.9 | 53.7 | 53.9
June | 51.9 | 52.3 | 54 | 53.8
Annual average | 52.53093372957724 | 52.41680044613256 | 53.02463229567655 | 54.02701204748986
Profits share (a) (c) – per cent
September | 26.9 | 28.3 | 28.9 | 26.7 | 26.7
December | 27.5 | 28.6 | 28.3 | 26.3 | 27.3
March | 27.3 | 27.4 | 27.3 | 26.5
June | 28.8 | 28.3 | 26.8 | 26.7
Annual average | 27.57535709883729 | 28.15684800109488 | 27.84569398396416 | 26.52409497972638
(a) Quarterly figures are seasonally adjusted.
(b) Compensation of employees as a proportion of total factor income.
(c) Gross operating surplus of financial and non-financial corporations as a proportion of total factor income.
Source: ABS, Australian national accounts: national income, expenditure and product, | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
Cat. no. 5206.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-06-04 00:00:00
Spreadsheet: 73837d1274390509-goal-seek-as-a-formula-goalseek
Sheet: Sheet1

Numer of Items | 120 | << change number of items then run macro
Auction End Price | 275
Shipping In | 70.66
Buyer Premium | 0.05 | << change percentage then run macro
Selling Price | 0.636
Shipping Out | 4.99
Shipping Costs Per Item | 2.26
Mailers | 0.1
Revenue | 675.12
Merchandise | 275
Shipping In | 70.66
Buyer Premium | 13.75
Mailers | 12
Fees | 32.44728000000001
Shipping Out | 271.2
Expenses | 675.05728
Profit | 0.06272000000001299
Break Even Sales Price | 0.636
Break Even Sales | 489
IRR | 0.0001688699819606715
Spreadsheet: 194885d1353351650-complex-lookup-functions-causing-slowdown-jobs
Sheet: Test

JOB: | Quickenings: | Espers:
Monk | [NAME] |  |  | MAGICK: | TECHNICKS: | KNOWLEDGE: | WEAPONS: | ARMOURS/SHIELDS: | ACCESSORIES:
 | Q100
 | Q125
Spreadsheet: 50174d1249562217-getting-a-formula-to-show-zero-until-it-is-used-sample-timesheet
Sheet: Total

Overall work record |  |  |  | Monthly break down of hours
Your weekly hours | 37 |  |  | Worked | Holidays | Sick
Your remaining holidays | 28 |  | October | 0 | 0 | 0
 |  |  | November | 0 | 0 | 0
 |  |  | December | 0 | 0 | 0
 |  |  | January | 0 | 0 | 0
 |  |  | February | 0 | 0 | 0
 |  |  | March | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 | [NAME] | Hols remaining
Total varience to date
October | -148 | 28
November | -148 | 28
December | -185 | 28
January | -148 | 28
February | -148 | 28
March | -148 | 28
Spreadsheet: chris_germany__2676__200004strg
Sheet: Sheet3

CGAS Storage Injection Activity
SCQ | 6050607
MDIQ | 36304
MMIQ (April) | 907591
SST | 54327
 |  |  |  |  |  |  |  |  |  |  |  |  | Per Navigator
 | Choice | Choice |  | SST k MDQ=54327 |  |  | Storage | Storage |  | Net | Proxy |  |  |  |  | Cummulative
 | Actual | Forcast |  | MDQ | Sched |  | Withdrawal | Inj |  | [NAME] | Target |  | Injection | Withdrawal |  | Balance
1 | 30299 | 38986 |  | 54327 | 37744 |  | 11052 | 56242 |  |  | 20519 |  | 45113 | 0
2 | 37204 | 37908 |  |  | 47578 |  | 16720 | 56164 |  |  | 20519 |  | 39377 | 0
 | 41096 | 41807 |  |  | 25156 |  | 2415 | 55338 |  |  | 20519 |  | 52833 | 0
 | 83570 | 76971 |  |  | 59041 |  | 38219 | 46449 |  |  | 20519 |  | 8216 | 0
 | 49566 | 55556 |  |  | 48901 |  | 34605 | 56298 |  |  | 20519 |  | 21656 | 0
 | 42494 | 43990 |  |  | 49829 |  | 20951 | 63893 |  |  | 20519 |  | 42869 | 0
 | 52536 | 43244 |  |  | 53590 |  | 31675 | 51003 |  |  | 20519 |  | 19295 | 0
 | 90509 | 83062 |  |  | 61337 |  | 41841 | 60943 |  |  | 20519 |  | 19070 | 0
 | 73759 | 71875 |  |  | 54593 |  | 41031 | 51047 |  |  | 20519 |  | 9460 | 0
 | 69462 | 69462 |  |  | 54383 |  | 28405 | 50031 |  |  | 20519 |  | 26401 | 0
 | 75922 | 77523 |  |  |  |  |  |  |  |  |  |  | 33816 | 0
 | 77765 | 66248 |  |  |  |  |  |  |  |  |  |  | 18070 | 0
 |  | 51061 |  |  |  |  |  |  |  |  |  |  | 13187 | 0
 |  | 34541 |  |  |  |  |  |  |  |  |  |  | 23070 | 0
 |  | 21000 |  |  |  |  |  |  |  |  |  |  | 23776 | 0
 |  | 24000 |  |  |  |  |  |  |  |  |  |  | 24577 | 0
 |  | 46000 |  |  |  |  |  |  |  |  |  |  | 24542 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 747675d1631638146-counting-text-across-multiple-rows-and-columns-sample2
Sheet: Location A

 | Go to Summary
Floor | Room | DEPARTMENT | MONDAY AM | MONDAY PM | TUESDAY AM | TUESDAY PM | WEDNESDAY AM | WEDNESDAY PM | THURSDAY AM | THURSDAY PM | FRIDAY AM | FRIDAY PM
1 | 1 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 2 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 3 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 4 | URGENT CARE | Test | Test | Hold | Test | Hold | Test | Test | Test | Test | Test
1 | 5 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 6 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Hold | Test | Test
1 | 7 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Hold
1 | 8 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 1 | CARDIOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 2 | CARDIOLOGY | Test | Hold | Test | Test | Test | Test | Test | Test | Test | Test
1 | 3 | CARDIOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 1 | GENERAL SURGERY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 2 | GENERAL SURGERY | Test | Test | HOLD | Test | Test | Test | Test | Test | Test | Test
2 | 1 | NEUROLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 2 | NEUROLOGY | Test | Test | Test | Hold | Test | Test | Test | Test | Test | Test
2 | 3 | NEUROLOGY | Test | Test | Test | Hold | Test | Test | Test | Test | Test | Test
3 | 1 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 2 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 3 | PEDIATRICS | Test | hold | Test | Test | Test | Test | Test | Test | Test | Test
3 | 4 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
Spreadsheet: 802250d1666727377-series-on-different-columns-example-serie
Sheet: Sheet1

 | ElementA | ElementB | A |  |  |  | As should be
1 | TeamA | TeamB | 1 |  | 1 | Team A Series | 1
1 | TeamC | TeamD | 0 |  | 2 |  | 2
2 | TeamA | TeamB | 1 |  | 3 |  | 0
2 | TeamD | TeamC | 1 |  | 4 |  | 1
3 | TeamB | TeamA | 0 |  | 5 |  | 2
3 | TeamD | TeamC | 1 |  | 6 |  | 3
4 | TeamA | TeamB | 1 |  | 7 |  | 4
4 | TeamD | TeamC | 0 |  | 8 |  | 0
5 | TeamA | TeamB | 1 |  | 9 |  | 1
5 | TeamC | TeamD | 1 |  | 10 |  | 2
6 | TeamB | TeamA | 1
6 | TeamD | TeamC | 1
7 | TeamA | TeamB | 1
7 | TeamD | TeamC | 0
8 | TeamB | TeamA | 0
8 | TeamC | TeamD | 1
9 | TeamA | TeamB | 1
9 | TeamD | TeamC | 1
10 | TeamA | TeamB | 1
10 | TeamD | TeamC | 0
Spreadsheet: theresa_staab__39599__Kennedy email
Sheet: Summary

 |  | [NAME] To: |  |  | Remit To:
 |  |  |  |  |  | Verification Date:
 |  | Enron North America Corp. |  |  | Kennedy Oil
 |  |  |  |  | Bank:  First Interstate Bank
 |  |  |  |  | ABA:  102300129 | Due Date:
 |  |  |  |  | Acct:  362170342 | 2001-12-31 00:00:00
 |  |  |  |  |  | Payment Method:
 |  | Contact:  [NAME] |  |  | Contact:  [NAME] | Wire
 |  | Tel:  (303) 575-6485 |  |  | Tel:  (307) 682-8726 | Terms:
Enron North America Corp. |  | Fax: (303) 534-0552 |  |  | Fax: (307) 682-6060 | Last Day of Month
Delivery Period: | Contract # | Meter # / Meter Name
 |  |  |  | Net Volume Mmbtu | WT. Average Price
2001-11-01 00:00:00 | 96023720 | [NAME]
 |  | South Kitty
 |  | TOTAL
 | Index | Discount / Premium | Price/MMBtu | Mcf Quantity | MMBtu Quantity | Amount Due
 | FOM CIG GD Box Draw
 | FOM IF NGPL-Midcont. Box Draw
 | FOM IF CIG - Rockies Box Draw
 | Add'l CIG GD +.10 - Box Draw
 | Add'l CIG GD - Box Draw
 | FOM CIG GD South Kitty
 | FOM IF NGPL-Midcont. South Kitty
 | FOM IF CIG - Rockies South Kitty
 | Add'l CIG GD -South Kitty
 | Add'l CIG GD +.10 - South Kitty
 | [NAME] | Fuel Loss | $             0.00 |  |  | $                                        0.00
 | [NAME] | Fuel Loss | $             0.00 |  |  | $                                        0.00
Total
 |  |  | TOTAL PAYMENT
Spreadsheet: sally_beck__35761__MgmtSum-Q1-0320
Sheet: CapChrg-AllocExp

PLAN2000
CAP_CHRG | ENRON NORTH AMERICA
TOT_ALLOCATION | 1ST QUARTER 2000 CAPITAL CHARGE & ALLOCATED EXPENSES
2000-03-01 00:00:00
M.QTD
ENA
 |  |  | Capital Charge |  |  |  |  |  |  | Allocated Expenses
 | Business Team |  | Forecast | Plan | [NAME] | Explanation |  |  |  | Forecast | Plan | [NAME] | Explanation
[NAME] | Gas Trading
[NAME] | Power Trading
IR_FX | Financial Drift
[NAME] | Financial Trading
CANADA | Canada |  | 198
COAL | Coal |  | 618
WEATHER | Weather
SO2 | Emissions
INSURANCE | Insurance Group |  |  |  |  |  |  |  |  | 469 |  |  | Plan only includes BA&R allocation
EXEC_TRD | Executive Trading
 | Total Trading & Risk Mgmt
E_ORG | East Midstream
W_ORIG | West Midstream |  | 892 |  |  | Big Horn investment
PAPER | Industrial Downstream - Paper |  | 285 |  |  | Merlin (City Forest, Oconto Falls) & Repap sale 2 months early
CHEMICALS | Industrial Downstream - Chemicals |  | 78 |  |  | Lower 1999 investing activity
MDSTRM_IPP_ORIG | Midstream IPP
MEXICO | Mexico
EXEC_ORIG | Executive Origination
 | Total Origination
GENCOS | Genco
N_BS_DEV | Generation Investments |  | 5778 |  |  | Merlin (ECP)
ASST_ORIG | Gas Assets |  | 8582 |  |  | Hurricane delay & Nahanni credit
ASST_TRD | Gas Assets - Trading
 | Total Assets
EQUITY | Principal Investing |  | 972 |  |  | Condor (Quanta)
PROD_FIN | Energy Investments |  | 6918 |  |  | Merlin (HV Marine, LSI, Ridgelake)
ENVR_ENGY | Investment Management |  | 1863 |  |  | Merlin (CanFibre, Heartland, Kafus Bridge) & Condor (Heartland)
RESTRUCTURING | Restructuring |  | 1477 |  |  | Carrizo sale
FIN | Canada - Investing
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman |  |  |  |  |  |  |  |  | 3789
 | Capital Charge Offset
 | Total Commercial
GROUP | Group
 | Total
Spreadsheet: 818409d1676816257-display-the-result-from-my-summary-table-to-dynamic-calendar-dynamic-calendar-excel-forum-
Sheet: Summary Sheet

 | 2023-03-01 00:00:00
Spreadsheet: 25687d1217164271-continuation-of-car-ownership-database-2-car-ownership-database
Sheet: MOT's Due List

MOT's Due List
Is MOT due? | Yes
Surname | Forename | [NAME] | Car Registration | Car Model | Home Phone No | Mobile No
Bloggs | [NAME] | Bentley | 1ZY 6NU | 5TX | 01428 724657 | [PHONE]
[NAME] | [NAME] | Audi | 1ny 7ui | SX2 | 01224 593922 | [PHONE]
Here I would like a list of cars which are due for a MOT after 6 months. To find this value I would like to use the MOT due on the value in the '2008' spreadsheet.
If the car is due for an MOT I would like the Surname & first name of the person, the car make & model to appear, also telephone number
Spreadsheet: 869533d1716126134-empty-row-after-every-group-of-data-book1-gk-v2
Sheet: Sheet1

 |  | User Enter three columns
 |  | Region | Employee | Product |  |  |  | Employee | Pro-1 | Pro-2 | Pro-3 | Pro-4
 |  | REG-1 | Emp-1 | Pro-1 |  |  | REG-1 | Emp-1 | x
 |  | REG-1 | Emp-2 | Pro-2 |  |  | REG-1 | Emp-2 |  | x
 |  | REG-1 | Emp-3 | Pro-4 |  |  | REG-1 | Emp-3 |  |  |  | x
 |  | REG-1 | Emp-4 | Pro-2 |  |  | REG-1 | Emp-4 |  | x
 |  | REG-1 | Emp-5 | Pro-1 |  |  | REG-1 | Emp-5 | x
 |  | REG-1 | Emp-6 | Pro-2 |  |  | REG-1 | Emp-6 |  | x
 |  | [NAME] | Emp-1 | Pro-3 |  |  | REG-1 Total |  | 0.3333333333333333 | 0.5 | 0 | 0.1666666666666667
 |  | [NAME] | Emp-2 | Pro-2 |  |  | [NAME] | Emp-1 |  |  | x
 |  | [NAME] | Emp-3 | Pro-3 |  |  | [NAME] | Emp-2 |  | x
 |  | [NAME] | Emp-4 | Pro-2 |  |  | [NAME] | Emp-3 |  |  | x
 |  | REG-3 | Emp-1 | Pro-3 |  |  | [NAME] | Emp-4 |  | x
 |  | REG-3 | Emp-2 | Pro-2 |  |  | REG-2 Total |  | 0 | 0.5 | 0.5 | 0
 |  | REG-3 | Emp-3 | Pro-3 |  |  | REG-3 | Emp-1 |  |  | x
 |  | REG-3 | Emp-4 | Pro-2 |  |  | REG-3 | Emp-2 |  | x
 |  | REG-4 | Emp-1 | Pro-3 |  |  | REG-3 | Emp-3 |  |  | x
 |  | REG-4 | Emp-2 | Pro-1 |  |  | REG-3 | Emp-4 |  | x
 |  | REG-4 | Emp-3 | Pro-3 |  |  | REG-3 Total |  | 0 | 0.5 | 0.5 | 0
 |  | REG-4 | Emp-4 | Pro-2 |  |  | REG-4 | Emp-1 |  |  | x
 |  | REG-5 | Emp-5 | Pro-1 |  |  | REG-4 | Emp-2 | x
 |  | REG-5 | Emp-6 | Pro-3 |  |  | REG-4 | Emp-3 |  |  | x
 |  |  |  |  |  |  | REG-4 | Emp-4 |  | x
 |  |  |  |  |  |  | REG-4 Total |  | 0.25 | 0.25 | 0.5 | 0
 |  |  |  |  |  |  | REG-5 | Emp-5 | x
 |  |  |  |  |  |  | REG-5 | Emp-6 |  |  | x
 |  |  |  |  |  |  | REG-5 Total |  | 0.5 | 0 | 0.5 | 0
 |  |  |  |  |  |  | Grand Total |  | 0.2 | 0.4 | 0.35 | 0.05