tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 538370d1505575282-get-names-according-year-of-birth-book
Sheet: SHEET 2

 | Can I have here all children with birth year 2003 and 2004? Dates, surnames and firstnames is an example.
 | CHILDREN YEAR 2003 - 2004
 | Α/Α | DATE BIRTH | SURNAME | FIRSTNAME | ΣΧΟΛΕΙΟ ΦΟΙΤΗΣΗΣ | ΥΨΟΣ | ΒΑΡΟΣ | ΟΝΟΜΑ ΠΑΤΕΡΑ | ΟΝΟΜΑ ΜΗΤΕΡΑΣ | [NAME] | ΤΗΛΕΦΩΝΟ ΟΙΚΙΑΣ
 |  | 2004-01-31 00:00:00 | AIDONIDIS | CHARALAMPOS
 |  | 2003-12-04 00:00:00 | PAPADOPOULOS | ARGYRIOS
Spreadsheet: f3092889-9cb4-4885-b4dd-f37248b24dbe
Sheet: Dropdown-Menüs

Note |  | Note (bestanden)
0 |  | 5
1 |  | 6
2 |  | 7
3 |  | 8
4 |  | 9
5 |  | 10
6 |  | 11
7 |  | 12
8 |  | 13
9 |  | 14
10 |  | 15
11 |  | unbenotet
12
13
14
15
unbenotet
Spreadsheet: 123706d1317818637-formula-for-small-theatre-seating-plan-copy-of-copy-of-seating-plan-sample-1-2
Sheet: MONDAY

SEATING PLAN  MONDAY
 |  |  | A1 | A2 | A3 | A4 | A5 | A6 | A7 | A8 | A9 | A10 | A11 | A12
 |  | A |  |  |  |  |  |  |  |  |  | [NAME] |  |  | A
 |  |  | B1 | B2 | B3 | B4 | B5 | B6 | B7 | B8 | B9 | B10 | B11 | B12
 |  | B |  |  |  |  | [NAME] |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | AISLE
 | C1 | C2 | [NAME] | C4 | C5 | C6 | C7 |  |  | C8 | C9 | C10 | C11 | C12 | C13 | C14 | C15
C |  |  | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | C
 | D1 | D2 | D3 | D4 | D5 | D6 | D7 |  |  | D8 | D9 | D10 | D11 | D12 | D13 | D14 | D15
D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D
 | E1 | E2 | E3 | E4 | E5 | E6 | E7 |  |  | E8 | E9 | E10 | E11 | E12 | [NAME] | E14 | E15
E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
 | F1 | F2 | F3 | F4 | F5 | F6 | F7 |  |  | F8 | F9 | [NAME] | F11 | F12 | F13 | F14 | F15
F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
 | [NAME] | G2 | G3 | G4 | G5 | G6 | G7 |  |  | G8 | G9 | G10 | G11 | G12 | G13 | G14 | [NAME]
G |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | G
 | H1 | H2 | H3 | H4 | H5 | H6 | H7 |  |  | H8 | H9 | H10 | H11 | H12 | [NAME] | H14 | H15
H |  | Aldred Mr R. |  |  | Akers [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | H
 | J1 | J2 | J3 | J4 | J5 | J6 | J7 |  |  | J8 | J9 | J10 | J11 | J12 | J13 | J14 | J15
J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J
 | K1 | K2 | K3 | K4 | K5 | K6 | K7 |  |  | K8 | K9 | K10 | K11 | K12 | K13 | K14 | K15
K |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | K
 | L1 | L2 | L3 | [NAME] | L5 | L6 | L7 |  |  | L8 | L9 | L10 | L11 | L12 | [NAME] | [NAME] | L15
L |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | L
Spreadsheet: 215177d1361296610-transpose-formula-ramesh
Sheet: Sheet2

 |  | 2013-02-18 00:00:00 |  | 3013-02-19 00:00:00 |  | 3013-02-20 00:00:00 |  | 3013-02-21 00:00:00 |  | 3013-02-22 00:00:00
Items | purchased at | quantity | purchased at | quantity | purchased at | quantity | purchased at | quantity | purchased at | quantity
rice | shop1 | 10 | shop2 | 10
wheat | shop1 | 5 | shop2 | 55
apple | shop1 | 44 | shop2 | 22
orange | shop1 | 34 | shop2 | 33
grapes | shop1 | 43 | shop2 | 55
Spreadsheet: 733685d1621708778-how-to-find-the-correct-value-when-considering-two-variables-book2
Sheet: Sheet1

No. | Stop | Lap |  | [NAME] | Driver | # Stops | 1 | 2 | 3 | 4 | 5
3 | 1 | 13 |  | 3 | [NAME] | 2 | 13 | 32 | - | - | -
3 | 2 | 32 |  | 4 | Lando NORRIS | 2 | 12 | 33 | - | - | -
4 | 1 | 12 |  | 5 | [NAME] | 1 | 24 | - | - | - | -
4 | 2 | 33 |  | 6 | [NAME] | 2 | 14 | 32 | - | - | -
5 | 1 | 24 |  | 7 | Kimi RAIKKONEN | 2 | 13 | 29 | - | - | -
6 | 1 | 14 |  | 9 | Nikita MAZEPIN | 0 | - | - | - | - | -
6 | 2 | 32 |  | 10 | [NAME] | 3 | 4 | 19 | 39 | - | -
7 | 1 | 13 |  | 11 | [NAME] | 3 | 2 | 19 | 38 | - | -
7 | 2 | 29 |  | 14 | [NAME] | 2 | 11 | 29 | - | - | -
10 | 1 | 4 |  | 16 | [NAME] | 2 | 12 | 32 | - | - | -
10 | 2 | 19 |  | 18 | Lance STROLL | 2 | 12 | 28 | - | - | -
10 | 3 | 39 |  | 22 | [NAME] | 2 | 15 | 33 | - | - | -
11 | 1 | 2 |  | 31 | Esteban OCON | 2 | 13 | 31 | - | - | -
11 | 2 | 19 |  | 33 | [NAME] | 2 | 17 | 39 | - | - | -
11 | 3 | 38 |  | 44 | [NAME] | 2 | 13 | 28 | - | - | -
14 | 1 | 11 |  | 47 | [NAME] | 2 | 14 | 33 | - | - | -
14 | 2 | 29 |  | 55 | [NAME] | 2 | 15 | 37 | - | - | -
16 | 1 | 12 |  | 63 | [NAME] | 2 | 13 | 36 | - | - | -
16 | 2 | 32 |  | 77 | Valtteri BOTTAS | 3 | 16 | 30 | 54 | - | -
18 | 1 | 12 |  | 99 | [NAME] | 2 | 12 | 30 | - | - | -
18 | 2 | 28
22 | 1 | 15
22 | 2 | 33
31 | 1 | 13
31 | 2 | 31
33 | 1 | 17
33 | 2 | 39
44 | 1 | 13
44 | 2 | 28
47 | 1 | 14
47 | 2 | 33
55 | 1 | 15
55 | 2 | 37
63 | 1 | 13
63 | 2 | 36
77 | 1 | 16
77 | 2 | 30
77 | 3 | 54
99 | 1 | 12
99 | 2 | 30
Spreadsheet: 271568d1381984248-must-merge-every-three-rows-into-one-row-tarosuzuki
Sheet: Data

Index | User ID | Correct | T No
26108 | [NAME] | 27
26108 | [NAME] | 29 |  |  | Index | User ID | T1 | T2 | T3
26108 | [NAME] | 28
26109 | Suzan | 17
26109 | Suzan | 24
26109 | Suzan | 21
26110 | [NAME] | 21
26110 | [NAME] | 23
26110 | [NAME] | 25
26111 | [NAME] | 18
26111 | [NAME] | 19
26111 | [NAME] | 22
Spreadsheet: 65111d1265846286-summarise-data-with-multiple-filters-cyp-accounts-template-ms
Sheet: Trading, Profit & Loss Account

Cambourne Youth Partnership |  |  |  | Start date | End Date
Trading, Profit & Loss Account |  |  |  | 2010-01-01 00:00:00 | 2010-03-31 00:00:00
Year Ended ?
RECEIPTS
Category | Total
Donations, legacies and grants | RECEIPTS |  |  | 0
Fundraising events | 0
Bank interest on deposits | 0
Dividend on investments | 0
Members' subscriptions | 0
Fees for charitable services | 0
Hire of hall and equipment | 0
Sale of fixed assets | 0
Sale of investments | 0
Other | 0
Gross Profit |  | 0
PAYMENTS
Category | Total
Cost of fundraising events | 0
Wages / Salaries and NI | 0
Pension Contributions | 0
Rent / Hire of rooms | 0
Repairs and maintenance | 0
Light and heating | 0
Water and sewerage | 0
Insurance | 0
Telephone, internet and postage | 0
Grants and donations paid | 0
Bank interest and charges | 0
Purchase of fixed assets | 0
Purchase of investments | 0
Other | 0
 |  | 0
Net Profit |  | 0
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 1

 | October 25 | November 1 | November 8 | 2013-11-22 00:00:00 | November 22
Total Interest Rate* | 316545549 | 316965964 | 320090917 | 319484671 | 333271155
Cleared** | 191874160 | 193208931 | 196616542 | 197901056 | 204094707
Uncleared | 124671389 | 123757034 | 123474375 | 121583616 | 129176448
Total Cross-Currency | 13086357 | 13020338 | 13054556 | 12056904 | 13516888
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 13086357 | 13020338 | 13054556 | 12056904 | 13516888
Total Credit | 9212082 | 9443358 | 9052362 | 9147397 | 9419352
Cleared | 2179209 | 2168663 | 2186928 | 2191149 | 2276704
Uncleared | 7243293 | 7274695 | 6865434 | 6956248 | 7142648
Total FX**** | 31450000 | 31450000 | 31450000 | 31450000 | 31450000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity**** | 4420000 | 4420000 | 4420000 | 4420000 | 4420000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity**** | 1700000 | 1700000 | 1700000 | 1700000 | 1700000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 376413988 | 376999660 | 379767835 | 378258972 | 393777395
Weekly snapshot, gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. For cleared swaps, this table reflects only one of the two swaps that results from the clearing process; therefore, the numbers on this table are analogous to the notional value of futures open interest.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
****These numbers are estimates.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 208286d1358784220-changing-currency-format-from-to-or-mailmerge
Sheet: details

Ref | Invoice Client | Invoice No | Branch | Payment Method | Contact Ref | Client Name | Gross | Net | Client Outstanding
1214166 | Client 1 | 42546 | Euro | Cash | 3166410 | sub Client 1 | 1519.2 | 928.4 | 1776
1214166 | Client 1 | 34544 | Euro | Cash | 1217560 | sub Client 2 | 5006.47 | 3379.37 | 2400
1146487 | Client 2 | 1039 | Sterling | Cash | 4431430 | sub Client 3 | 630 | 492.19 | 4465.45
1146487 | Client 2 | 34235 | Sterling | Cash | 5941949 | sub [NAME] | 6301.22 | 4818.59 | 1668.86
1216164 | Client 3 | 9878 | Sterling | Cash | 5298859 | sub Client 5 | 554.7 | 528.9 | 523
1260581 | Client 4 | 34766 | Euro | Cash | 1364535 | sub Client 6 | 3576.48 | 2734.95 | 1908
1148595 | Client 5 | 37377 | Dollar | Cash | 1510528 | sub Client 7 | 8840 | 5720 | 1855
1148595 | Client 5 | 38347 | Dollar | Cash | 1148059 | sub Client 8 | 8500 | 5500 | 1590
1148595 | Client 5 | 41581 | Dollar | Cash | 2553170 | sub Client 9 | 1229.31 | 795.44 | 5770.97
Spreadsheet: mark_whitt__25246__Huber - Existing & Proposed Deals 111201
Sheet: Summary

Existing Deals with Huber
Start | End | Volume (MMBtu/d) | Delivery Point | Contract Price | 55 days payables* | Mark-to-Market Value to ENE
2001-12-01 00:00:00 | 2006-09-30 00:00:00 | 5000 | [NAME] | IF NGPL MidContinent index |  | -90118
2001-12-01 00:00:00 | 2006-09-30 00:00:00 | 5000 | [NAME] | IF NGPL MidContinent index |  | 189775
2002-06-01 00:00:00 | 2013-05-31 00:00:00 | 42000 | Gage | IF NGPL MidContinent Index minus $0.01
 |  |  |  | Total Payables as of Jan 25, 2002
 |  |  |  | Total Payables as of July 25, 2002
Proposed Deals with Huber
Start | End | Volume (MMBtu/d) | Delivery Point | Contract Price | 55 days payables* | Mark-to-Market Value to ENE
2001-12-01 00:00:00 | 2002-05-31 00:00:00 | 45000 | Glenrock | IF CIG Rocky Mtns. index minus $0.03
2001-12-01 00:00:00 | 2006-05-31 00:00:00 | 20000 | PG&E Topock | Gas Daily PG&E Topock index minus $0.02
2001-12-01 00:00:00 | 2002-05-31 00:00:00 | 10000 | [NAME] | Gas Daily El Paso-San Juan index minus $0.10
2001-12-01 00:00:00 | 2002-05-31 00:00:00 | 10000 | [NAME] | Gas Daily NWPL Wyoming Pool index minus $0.10
 |  |  |  | Total Payables as of Jan 25, 2002
 |  |  |  | Total Payables as of July 25, 2002
* The "55 days payable" value above is calculated as 55 days times the Daily Volume times the average 2002  forward curve price (curve date = Nov 9, 2001)
Spreadsheet: 742716d1627988229-weekly-summary-of-values-changed-between-same-day-divided-into-zones-ongoing-weekly-task-summary-revised01-ans1
Sheet: Sheet1

 |  |  | IFERROR(ABS(@INDEX(Database!$H:$H,AGGREGATE(14,6,ROW(Database!$M:$M)/((INT(Database!$M:$M)=INDEX($AE$6:$BF$6,1+4*INT((COLUMNS($C8:C8)-1)/4)))*(Database!$O:$O=$B8)*(Database!$P:$P=C$7)),1))-@INDEX(Database!$H:$H,AGGREGATE(15,6,ROW(Database!$M:$M)/((INT(Database!$M:$M)=INDEX($AE$6:$BF$6,1+4*INT((COLUMNS($C8:C8)-1)/4)))*(Database!$O:$O=$B8)*(Database!$P:$P=C$7)),1)))/100,"")
 | Week # 52 | 2021-06-20 00:00:00 |  |  |  | 2021-06-21 00:00:00 |  |  |  | 2021-06-22 00:00:00 |  |  |  | 2021-06-23 00:00:00 |  |  |  | 2021-06-24 00:00:00 |  |  |  | 2021-06-25 00:00:00 |  |  |  | 2021-06-26 00:00:00 |  |  |  |  | NOTE
 |  | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC |  | [NAME] in table 1 are different from other tables
 | Zone A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From table2 on words formulas are same
 | Zone B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drag down of table1 should not be done
 | Zone C
 | Zone D
 | Zone E
 | Week # 53
 |  | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC
 | Zone A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE
 | Zone B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To extend to week 54
 | Zone C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select B14:AD21
 | Zone D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Use fill handle and drag down.
 | Zone E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Similarly for further weeks
 | Week # 54
 |  | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC
 | Zone A
 | Zone B
 | Zone C
 | Zone D
 | Zone E
Spreadsheet: 79995d1280244289-excel-2007-pivot-table-formulas-test-data-set
Sheet: ORD Pivot (2)

Standard for Review
Order Margin $$ > $1000
Date | (All)
Customer type | (All)
 |  | Values
Order number | WHB | Sum of Sales | Sum of SFCOST | Sum of Actual  Cost | Sum of MGN | Sum of Mgn SFC% | Sum of MGN% | Sum of Order review 2 | =IF(WHB=2,IF(Sales<1000,8,IF(AND(Sales>1000,'MGN%'>75%),6,IF(AND(Sales>1000,'MGN%'<20%),7,5))),IF(Sales<1000,4,IF(AND(Sales>1000,'MGN%'>45%),2,IF(AND(Sales>1000,'MGN%'<15%),3,1))))
477581 | 2 | 114350.67 | 94442.2371 | 94442.2371 | 19908.4329 | 0.1740998360569291 | 0.1740998360569291 | 1
615090 | 2 | 36342.6 | 26901.5 | 26901.5 | 9441.099999999999 | 0.2597805330383627 | 0.2597805330383627 | 5
636583 | 2 | 30808.63 | 25133 | 25133 | 5675.630000000001 | 0.1842220832279787 | 0.1842220832279787 | 7
636593 | 2 | 32800.26 | 26253.81 | 26253.81 | 6546.450000000001 | 0.1995853081652401 | 0.1995853081652401 | 7
741636 | 2 | 25871.4 | 18516.276 | 18516.276 | 7355.124 | 0.2842955541640576 | 0.2842955541640576 | 5
744749 | 2 | 42658.48 | 31219.403 | 31219.403 | 11439.077 | 0.2681548193934712 | 0.2681548193934712 | 5
754199 | 2 | 105146.4 | 72882.9374 | 72882.9374 | 32263.4626 | 0.3068432452276064 | 0.3068432452276064 | 5
756102 | 2 | 36635.14 | 21557.63 |  | 36635.14 | 0.4115586838210527 | 1 | 6
759425 | 2 | 31443.3 | 16898.4105 | 16898.4105 | 14544.8895 | 0.4625751590958963 | 0.4625751590958963 | 5
760506 | 2 | 20736.6 | 17464.2832 | 17464.2832 | 3272.316799999997 | 0.1578039215686273 | 0.1578039215686273 | 7
773101 | 1 | 39200 | 25509.9 | 25509.9 | 13690.1 | 0.3492372448979592 | 0.3492372448979592 | 1
773509 | 1 | 24420 | 16234.6008 | 16234.6008 | 8185.3992 | 0.3351924324324325 | 0.3351924324324325 | 1
776009 | 1 | 20620 | 10906.17 | 10906.17 | 9713.83 | 0.4710877788554801 | 0.4710877788554801 | 2
776793 | 1 | 22414.95 | 8524.44 | 8524.44 | 13890.51 | 0.6196984601794784 | 0.6196984601794784 | 2
777946 | 1 | 46780.34 | 14817.2352 | 14817.2352 | 31963.10479999999 | 0.6832593521124473 | 0.6832593521124473 | 5
 | 2 | 46192.8 | 15218.21 | 15218.21 | 30974.59 | 0.6705501723212276 | 0.6705501723212276 | 5
778162 | 1 | 23265.12 | 10789.08 | 10789.08 | 12476.04 | 0.5362551321463203 | 0.5362551321463203 | 2
781011 | 1 | 20029.18 | 17606.2047 | 17606.2047 | 2422.975300000002 | 0.1209722664632302 | 0.1209722664632302 | 3
784022 | 1 | 20000 | 13655.43 | 13655.43 | 6344.57 | 0.3172285 | 0.3172285 | 1
784200 | 1 | 26636.4 | 15348.21 | 15348.21 | 11288.19 | 0.4237881245213317 | 0.4237881245213317 | 1
785238 | 2 | 21749 | 19065.62 | 19065.62 | 2683.380000000001 | 0.123379465722562 | 0.123379465722562 | 7
788794 | 1 | 22031.77 | 6691.17 | 6691.17 | 15340.6 | 0.6962944874606081 | 0.6962944874606081 | 2
790474 | 1 | 30728.97 | 11574.5 | 11574.5 | 19154.47 | 0.6233358944344702 | 0.6233358944344702 | 2
795067 | 1 | 25101.87 | 5992.18 | 5992.18 | 19109.69 | 0.7612855137884149 | 0.7612855137884149 | 2
Grand Total |  | 865963.88 | 543202.4379000001 | 521644.8079000001 | 344319.0720999999 | 0.3727192895158628 | 0.3976136650179912 | 1
Spreadsheet: 546654d1510149339-pivot-table-with-blanket-rows-pivot-table2
Sheet: Sheet1

AC | Customer | Product | Description | Sales
1 | Amazon | Result |  | 6010.87
 |  | 138 | Fitting H | 989.77
 |  | 135 | Fitting G | 58.6
 |  | 134 | Fitting F | 30.7
 |  | 133 | Fitting E | 78.84
 |  | 129 | Fitting D | 313.36
 |  | 123 | Fitting C | 26.44
 |  | 122 | Fitting B | 4447.46
 |  | 122 | Fitting B | 1965.28
 |  | 121 | Fitting A | 65.7
 |  | 0 | No Code
2 | Ebay | 122 | Fitting B | 122.94
3 | Walmart | Result |  | 1965.28
Spreadsheet: 731148d1620210417-getting-rounded-numbers-to-add-up-test-1-
Sheet: Sheet1

0.417
0.357
0.158
0.056
0.012
11
Spreadsheet: 789854d1659410326-ratio-to-staff-calculator-ratio-calc-copy
Sheet: Sheet1

 |  |  |  | [NAME]'s ratio to staff calcuator
 |  |  |  | Ratio
 |  |  |  | 1 | 2 | 3 | 4
 |  |  |  | 1:1 | 1:2 | 1:3 | 1:4
 |  |  |  | 1 | 1 | 1 | 1
 |  |  | Total | 1 | 1 | 0 | 1
 |  |  | Residual | 0 | 0 | 1 | 0
 |  |  | Total staff | 3
 |  |  | Total + IC | 4
 |  |  | Nursing hours (8hrs) |  | 32
 |  |  | Nursing night (10hrs) |  | 40
 |  |  | Total no of pt |  | 4
Spreadsheet: 704245d1605461304-retrieving-annual-returins-using-lookup-functions-in-big-data-lists-excel-test-function-123
Sheet: Sheet1

 |  |  |  | A | B | C
 |  |  | 2017
 |  |  | 2018
 |  |  | 2019
 |  | A | B | C
 | 2017-01-01 00:00:00 | 100 | 100 | 100
Spreadsheet: 59795d1260347225-league-spreadsheet-vs3_league_spreadsheet_test
Sheet: Preview

Week | 3 |  | preview |  |  |  |  | data entry | enter week number in B1
[NAME] | 3 |  |  |  |  |  |  |  | set up pairing blocks for each pairing and enter the pairing number in the pink cell
number of pairings |  | 5 |  |  |  |  |  |  | all else is calculated.
team # | team name | rank in team | team members | Avg score | [NAME] | Handicap | VS | team # | team name | rank in team | team members | Avg score | [NAME] | Handicap
Pairing # | 1
9 | amber | 1 | monkey | 281.5 | 15 | 0 |  | 10 | mauve | 1 | sheep | 287.5 | 24.5 | 4.800000000000001
 |  | 2 | sloth | 267 | 15 | 0 |  |  |  | 2 | goat | 269 | 20 | 1.6
 |  | 3 | dog | 263 | 13 | 1.6 |  |  |  | 3 | cow | 261 | 38.5 | 0
Pairing # | 2
8 | chartreuse | 1 | snake | 284.5 | 28 | 2.4 |  | 9 | amber | 1 | monkey | 281.5 | 15 | 0
 |  | 2 | gecko | 272 | 21 | 4 |  |  |  | 2 | sloth | 267 | 15 | 0
 |  | 3 | lizzard | 269 | 25 | 4.800000000000001 |  |  |  | 3 | dog | 263 | 13 | 0
Pairing # | 3
7 | pink | 1 | fawn | 290 | 24.5 | 4.4 |  | 8 | chartreuse | 1 | snake | 284.5 | 28 | 0
 |  | 2 | rabbit | 283 | 22 | 8.8 |  |  |  | 2 | gecko | 272 | 21 | 0
 |  | 3 | deer | 262.5 | 19.5 | 0 |  |  |  | 3 | lizzard | 269 | 25 | 5.2
Pairing # | 4
6 | orange | 1 | oliver | 288.5 | 30 | 0 |  | 7 | pink | 1 | fawn | 290 | 24.5 | 1.2
 |  | 2 | bob | 254.25 | 10 | 0 |  |  |  | 2 | rabbit | 283 | 22 | 23
 |  | 3 | [NAME] | 245 | 21.75 | 0 |  |  |  | 3 | deer | 262.5 | 19.5 | 14
Pairing # | 5
5 | purple | 1 | [NAME] | 281.25 | 30.75 | 0 |  | 6 | orange | 1 | oliver | 288.5 | 30 | 5.800000000000001
 |  | 2 | pete | 267.5 | 17.25 | 10.6 |  |  |  | 2 | bob | 254.25 | 10 | 0
 |  | 3 | [NAME] | 264.25 | 30 | 15.4 |  |  |  | 3 | [NAME] | 245 | 21.75 | 0
Standings
Blue | 3 |  | This sheet gives an overview of who plays vs who and what the handicaps are.
red | 0 |  | The Standings overview show the points collected per team up to the week selected above
yellow | 2
green | 1
purple | 4 |  | player's rank within the team is recaclulated every week
orange | 2 |  | players are sorted by rank here to match up teamA #1 vs teamB #1
pink | 2 |  | ranking changes can be studied on the Teams sheet as the weeks progess
chartreuse | 4 |  | compare the blue team pecking order between week 2 and week 3 preview
amber | 4 |  | note that teams end up in different spots each week, because of the pairings ….
mauve | 1
copy the other team
names into this list
and copy the formula in
B30 down
Spreadsheet: 328348d1403876654-formula-to-add-up-totals-from-lots-of-worksheets-testings
Sheet: sheet6

 |  |  | Item | Date of PAT Test | [NAME] |  | [NAME] key
 |  |  | 1 | TBC |  |  | Test Due
 |  |  | 1 | TBC |  |  | Test in 30 days
 |  |  | 1 | TBC
 |  |  | 1 | TBC
 |  |  | 1 | TBC
 |  |  | 1 | 2014-01-30 00:00:00 | 2015-01-30 00:00:00
 |  |  | 1 | 2014-01-30 00:00:00 | 2015-01-30 00:00:00
 |  |  | 1 | 2014-01-30 00:00:00 | 2015-01-30 00:00:00
 |  |  | In need of first test:
 |  |  | Overdue for PAT test:
 |  |  | Total
Spreadsheet: sally_beck__35165__Global Hot List 0921
Sheet: Hotlist - Identified 

E N R O N   G L O B A L   M A R K E T S  -  H O T  L I S T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Results based on activity through September 21, 2000
 |  | Third Quarter 2000 |  |  | Fourth Quarter 2000 |  |  | 3Q - 4Q 2000 Totals |  |  | First Quarter 2001 |  |  | Second Quarter 2001
 | Liquids | Deal | Value |  | Deal | Value |  |  |  |  | Deal | Value |  | Deal | Value
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL
Coal | Origination & Finance | Deal | Value |  | Deal | Value |  |  |  |  | Deal | Value |  | Deal | Value
 |  | ETOL-UK | 500 |  | SynFuel - Pacificorp | 50000 |  |  |  |  | CMS | 30000
 |  | British Steel-Redcar | 500 |  | SynFuel - AIG | 20000 |  |  |  |  | DPR | 5000
 |  | Mission Restructure | 500 |  | Cline-Panther | 5000 |  |  |  |  | AES - UK | 5000
 |  | ENV - Germany | 250 |  | British Energy - UK | 5000
 |  |  |  |  | M&G UK | 3000
 |  |  |  |  | Jupiter / Eagle Energy | 2000
 |  |  |  |  | BEWAG - Germany | 1000
 |  |  |  |  | DRS | 500
 |  |  |  |  | RR Marketing JV - USA | 0
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL
 | Emissions | Deal | Value |  | Deal | Value |  |  |  |  | Deal | Value |  | Deal | Value
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL
 | Weather | Deal | Value |  | Deal | Value |  |  |  |  | Deal | Value |  | Deal | Value
 |  | Sacramento MUD | 500 |  | Washington | 500
 |  | Independence Propane | 100 |  | Harvard | 500
 |  | Dead River | 25 |  | Goldman Sach Risk | 400
 |  |  |  |  | Cornerstone | 25
 |  |  |  |  | Griffin | 10
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL
Global | Risk Markets | Deal | Value |  | Deal | Value |  |  |  |  | Deal | Value |  | Deal | Value
 |  |  |  |  | Project MI - 3 | 15000 |  |  |  |  | Project Taft | 10000
 |  |  |  |  | [NAME] | 15000
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL
 | LNG | Deal | Value |  | Deal | Value |  |  |  |  | Deal | Value |  | Deal | Value
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL
 |  | TOTALS |  |  | TOTALS |  |  | TOTALS |  |  | TOTALS |  |  | TOTALS