tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 79065449-6605-4d44-b674-98a5a16d619c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
3549 | 10229 | Ragnhild | Bolstad | NOR | 7 | 00:19:55 | [NAME] | 00:21:57 | 00:00:54 | 00:22:32 | 1 | 01:06:01
3549 | 21542 | Beate | Cekoni-Hutter | AUT | 6 | 00:20:31 | 00:00:34 | 00:24:19 | [NAME] | 00:25:41 | 2 | 01:11:59
3549 | 21543 | Anneliese | Autherit | AUT | 5 | 00:24:37 | 00:00:46 | 00:32:20 | 00:01:04 | 00:37:43 | 3 | 01:36:34
Spreadsheet: d8c1a780-1b0f-4679-b521-13c8ebb5addb
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
43186701 | 2014-09-16 19:36:20 | AXIS | 1 | 7 | 1 | 377160 | docsteve | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43186940 | 2014-09-16 19:57:47 | ALLIES | 1 | 7 | 4 | 377160 | docsteve | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43199232 | 2014-09-17 18:29:57 | AXIS | 0 | 4 | 6 | 692398 | Morgiliath | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43199379 | 2014-09-17 18:45:36 | ALLIES | 1 | 6 | 3 | 692398 | Morgiliath | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43217948 | 2014-09-19 02:40:31 | ALLIES | 1 | 6 | 5 | 1502391 | Benaiah3 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43218128 | 2014-09-19 03:01:30 | AXIS | 0 | 1 | 6 | 1502391 | Benaiah3 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43218327 | 2014-09-19 03:15:55 | AXIS | 1 | 6 | 4 | 601280 | player601280 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43218433 | 2014-09-19 03:34:06 | ALLIES | 1 | 6 | 4 | 601280 | player601280 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43323419 | 2014-09-26 18:33:08 | AXIS | 1 | 6 | 3 | 1601827 | [NAME] | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43341929 | 2014-09-28 00:21:37 | ALLIES | 0 | 4 | 6 | 417473 | aikobo | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
43342091 | 2014-09-28 00:39:00 | AXIS | 0 | 3 | 6 | 417473 | aikobo | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
43343760 | 2014-09-28 03:24:48 | ALLIES | 1 | 6 | 3 | 1373296 | player1373296 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
43366774 | 2014-09-29 18:16:52 | AXIS | 1 | 6 | 0 | 1622839 | spitfire62 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
Spreadsheet: 124668d1318530625-excel-2007-nesting-vlookup-function-or-alternative-test
Sheet: Sheet1

 | J1
 |  | 0 | N/A | N/A | N/A | N/A
 |  | 20000 | 40 | 80 | 90 | 110
 |  | 20700 | 50 | 100 | 120 | 140
 |  | 20800 | 40 | 80 | 90 | 110 |  |  | J1 | 20900
 |  | 21000 | 55 | 110 | 130 | 150 |  |  | J2 | 21500
 |  | 24000 | N/A | N/A | N/A | N/A
 | J2
 |  | 0 | N/A | N/A | N/A | N/A
 |  | 20000 | 41 | 82 | 93 | 140
 |  | 20700 | 51 | 102 | 124 | 144
 |  | 20800 | 41 | 82 | 93 | 140
 |  | 21000 | 60 | 120 | 140 | 160
 |  | 24000 | N/A | N/A | N/A | N/A
 | J2
 |  | 0 | N/A | N/A | N/A | N/A
 |  | 20000 | 45 | 90 | 100 | 120
 |  | 20700 | 50 | 100 | 120 | 140
 |  | 20800 | 45 | 90 | 100 | 120
 |  | 21000 | 55 | 110 | 130 | 150
 |  | 24000 | N/A | N/A | N/A | N/A
Spreadsheet: 23157d1212572539-getting-the-date-for-the-start-of-the-week-646082
Sheet: Sheet1

2008-06-24 00:00:00 | 2008-06-22 00:00:00 | 2008-06-23 00:00:00
2008-06-25 00:00:00 | 2008-06-22 00:00:00 | 2008-06-23 00:00:00
2008-06-26 00:00:00 | 2008-06-22 00:00:00 | 2008-06-23 00:00:00
2008-06-27 00:00:00 | 2008-06-22 00:00:00 | 2008-06-23 00:00:00
2008-06-29 00:00:00 | 2008-06-29 00:00:00 | 2008-06-23 00:00:00
2008-06-30 00:00:00 | 2008-06-29 00:00:00 | 2008-06-30 00:00:00
2008-07-01 00:00:00 | 2008-06-29 00:00:00 | 2008-06-30 00:00:00
Spreadsheet: 777532d1650458894-make-complete-blank-example_date
Sheet: Sheet1

Item | Open date | Received date | Days taken to receive return
A | 2022-04-01 00:00:00
B | 2022-03-01 00:00:00 | 2022-04-05 00:00:00 |  |  |  | Row Labels | Average of Days taken to receive return
C | 2022-02-02 00:00:00 |  |  |  |  | A | -44652
D | 2022-03-03 00:00:00 | 2022-04-04 00:00:00 |  |  |  | B | 35
E | 2022-02-05 00:00:00 |  |  |  |  | C | -44594
F | 2022-01-01 00:00:00 |  |  |  |  | D | 32
 |  |  |  |  |  | E | -44597
 |  |  |  |  |  | F | -44562
 |  |  |  |  |  | Grand Total | -29723
Spreadsheet: 289b27f3-ee27-41ed-9e56-88012f6c3301
Sheet: $ e-books

Purchases of E-Books FY12
Title | Publisher | Package or Individual? | Owned or Leased? | No. of Titles | Platform | Fund Code | Purchase Price | Annual Access Fee
Coastal Informatics: Web Atlas Design and Implementation (2011) | IGI Global | Individual | Owned | 1 | IGI Global | maff | 255 | 0
Early American Imprints Series I: Evans 1639-1800 | [NAME] | Package | Owned | 36605 | [NAME] of Americana | zzwp | 79268 | 1500
Early English Books Online (EEBO) | ProQuest | Package | Owned | 125117 | Chadwyk-Healey | zzwp | 65964 | 1329
Encyclopedia of Associations: National Organizations of the U.S., 51st ed. | Gale | Individual | Owned | 1 | [NAME] (GDL) | [NAME] | 1763.71 | 0
Encyclopedia of Fish Physiology: From Genome to Environment (2011) | Elsevier | Individual | Owned | 1 | ScienceDirect | biop | 1497 | 0
[NAME] and Gale Virtual Reference Library Hosting Fee, 1-10 e-books | Gale | Package | — | 0 | n/a | feep | 0 | 100
Gale Directory of Publications and Broadcast Media, [NAME]. | Gale | Individual | Owned | 1 | [NAME] (GDL) | [NAME] | 1519.29 | 0
[NAME] of Daily Life - Slavery in America (2008) | Gale | Individual | Owned | 1 | Gale Virtual Reference Library (GVRL) | hisf | 353.16 | 0
Market Share Reporter 2012 | Gale | Individual | Owned | 1 | [NAME] (GDL) | busp | 797.51 | 0
Morgan & Claypool Synthesis Collection 1 | Morgan & Claypool | Package | Owned | 100 | Morgan & Claypool | zzwp | 3000 | 0
Morgan & Claypool Synthesis Collection 2 | Morgan & Claypool | Package | Owned | 125 | Morgan & Claypool | zzwp | 3000 | 0
Morgan & Claypool Synthesis Collection 3 | Morgan & Claypool | Package | Owned | 125 | Morgan & Claypool | zzwp | 3000 | 0
Safari Tech Books Online | ProQuest | Package | Leased | 100 | Safari Books Online | zzwp | 0 | 4640
Stat!Ref | — | Individual | Leased | 10 | Stat!Ref | zzwp | 0 | 613.8
UPCC Book Collections on Project MUSE -- 2012 Complete Collection | — | Package | Owned | 1825 | ProjectMuse | zzaf | 52072.02 | 0
TOTAL
Spreadsheet: 08782997-81e9-4e59-9299-2c1f41006348
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 12. LEASE FINANCE COMMITMENTS, For Plant and Equipment: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Transport equipment ; |  |  | Original | A2413515K | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Construction and earthmoving equipment ; |  |  | Original | A2413516L | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Agricultural machinery and equipment ; |  |  | Original | A2413517R | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Manufacturing equipment ; |  |  | Original | A2413518T | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Electronic data processing equipment ; |  |  | Original | A2413519V | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Office machines ; |  |  | Original | A2413520C | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Shop and office furniture, fittings and equipment ; |  |  | Original | A2413521F | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Other goods ; |  |  | Original | A2413522J | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Lease Finance - Total ; |  |  | Original | A2413523K | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 729892d1619431688-rankif-function-which-can-take-formulas-giving-dynamic-ranges-as-arguments-rankif
Sheet: RANKIF

Category | Numbers to be ranked | Last 15 digits from numbers to be ranked | Rank
15022505 | 100000000000421730 |  |  |  |  |  |  | Considerations:
15022505 | 100000000000421731
15022505 | 100000000000421731 |  |  |  |  |  |  | 1. A descending "RANKIF" of column B with respect to column A is needed.
15022505 | 100000000000421731 |  |  |  |  |  |  | 2. Numbers (in text format) to be ranked consists of 18 digits, but Excel only keeps the 15 first digits, while turning the rest into zeroes except when the string is kept as text format.
15022505 | 100000000000421732 |  |  |  |  |  |  | 3. There is no need for all the digits for the proposed use, so a workaround is to create a column which extracts only the 15 last digits and turns them into numbers.
15022505 | 100000000000421732 |  |  |  |  |  |  | 4. Functions like COUNTIFS, RANK and SUMPRODUCT cannot take calculation of dynamic ranges as arguments, e.g.: NUMBERVALUE(RIGHT(B2:B33;15))
15022505 | 100000000000421732 |  |  |  |  |  |  | 5. Therefore, a formula to calculate the rank of these numbers must be entered in yet another separate column.
15022505 | 100000000000421733
15022505 | 100000000000421733 |  |  |  |  |  |  | Need:
15022505 | 100000000000421733
15022505 | 100000000000421734 |  |  |  |  |  |  | [NAME] to calculate rank directly without helper column and with a dynamic array as output. (The LET function is unfortunately not available in my version of Excel yet).
15022505 | 100000000000421734
15022505 | 100000000000421734
15022507 | 100000000000421864
15022507 | 100000000000421865
15022507 | 100000000000421865
15022507 | 100000000000421865
15022507 | 100000000000421866
15022507 | 100000000000421866
15022507 | 100000000000421866
15022507 | 100000000000421866
15022507 | 100000000000421867
15022507 | 100000000000421867
15022507 | 100000000000421867
15022507 | 100000000000421867
15022507 | 100000000000421868
15022507 | 100000000000421868
15022507 | 100000000000421868
15022507 | 100000000000421868
15022507 | 100000000000421869
15022507 | 100000000000421869
15022507 | 100000000000421869
Spreadsheet: phillip_m_love__30134__Sithe 0301 GL
Sheet: Sithe

Enron North America
SITHE  Desk
Summary of [NAME] to Actual Variance
(Income)/ Expense to Desk
 |  |  |  |  | Pre 2000 | 0001 | 0002 | 0003 | 0004 | 0005 | 0006 | 0007 | 0008 | 0009 | 0010 | 0011 | 0012 | 0101 | 0201 | 0301 |  | Total
Total Flash to Actual Variance |  |  |  |  | -14792 | 1 | -2 | -1 | 368 | -1 | -62 | 133862 | 339423 | 276692 | 91053 | 568600 | -141918 | 338837 | 14491772 | 4152864
 | stated as of 3/31/01 GL
 | Proposed Adjustments to NGP&L, 4/30/01
 |  | Current Month |  |  | -14791.82 |  |  |  | 369.32 |  | -62 | 88590 |  |  |  |  | -2485 | -23325 | -4343
 |  | Union Storage - Tagg#NX8240 (presithe)
 |  | PMAs
 | Outstanding Variances
 |  | Economics -  agreed upon  not yet taken
 | Outstanding Variances
 |  | Economics
 |  | Physical liquidations-difference between OA flash and details
 |  | Storage value adjustments
 |  | Market to Market-Prior Month Book Balance
 |  | DPR vs. Consol. [NAME]
 |  | Sithe Purchase Variance |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18255 | 31745
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 78285
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 904919 | 284808
 |  | Union Storage Variance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58780
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -173910
 |  | Settlements
 |  | Special Revenue - Sithe Credit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -200419 | -15000
 |  | Sithe Sales/Purchases Variance - (pre Sithe)
 |  | Sithe Sales/Purchases Variance - (Sithe) |  |  |  |  |  |  |  |  |  |  |  | 351769 |  |  |  | -125761 | 10957819
 |  | Enron Canada Purchase Variance |  |  |  |  |  |  |  |  |  |  | -496127 |  |  |  | -153540 | -357492
 |  | Volume Management
 |  | Fuel volume variance
 |  | Purchases or sales from Storage
 |  | Synthetic Storage
 |  | Transporation - Commodity, Demand |  |  |  |  |  |  |  |  |  |  |  |  |  | -31685.55
 |  | Imbalance - In Kind |  |  |  |  |  |  |  |  |  |  |  |  | 351569 |  |  |  | 509879
 |  | Gas Accounting
 |  | Manual entry made by gas accounting
 |  | Missing UA4 entry on 3/01 GL PMA |  |  |  |  |  |  |  |  |  |  |  | -232590
 |  | Financial Liquidations - in GL not in Flash |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | OA Group Not Analyzed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4152864
 | Outstanding Variances, resolution expected 4/01 GL
 |  | Settlements
 |  | Requested entries - Various |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 714984
 |  | Gas Accounting
 |  | Interdesk purchase variance
 |  | Interdesk sales variance
 |  | 4.6a never been reversed out
 |  | Deferred revenue for trans saving sharing (sec 4.6)
 |  | Financial Liquidations - Reclass to/from East
 |  | Requested Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -492879 | -2776482 | 2757880
 |  | Requested entries - Various |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1388241
 |  | Reclass to deferred revenue
 |  | Financial Liquidations - Reclass to/from Ontario
Total Identified Flash to Actual Variances
Unexplained Variance
Spreadsheet: john_griffith__15891__11_13_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 21.5 | 75 | 90 | 83.5 | 100.2 | 1.24 | 2001-11-13 09:58:00
 | CL F2 | 21.5 | 260 | 275 | 52.2 | 55.2 | 0.73 | 2001-11-13 09:58:00
 | CL G2 | 21.5 | 370 | 385 | 51.9 | 54.1 | 0.72 | 2001-11-13 09:58:00
 | CL H2 | 21.5 | 435 | 450 | 50.9 | 52.6 | 0.7 | 2001-11-13 09:58:00
 | CL J2 | 21.5 | 475 | 490 | 48.7 | 50.2 | 0.67 | 2001-11-13 09:58:00
 | CL K2 | 21.5 | 505 | 525 | 46.1 | 48 | 0.64 | 2001-11-13 09:58:00
 | CL M2 | 21.5 | 535 | 550 | 45.1 | 46.3 | 0.62 | 2001-11-13 09:58:00
 | CL N2 | 21.5 | 550 | 565 | 42.9 | 44.1 | 0.59 | 2001-11-13 09:58:00
 | CL Q2 | 21.5 | 550 | 570 | 40.3 | 41.8 | 0.55 | 2001-11-13 09:58:00
 | CL U2 | 21.5 | 555 | 575 | 38.7 | 40.1 | 0.53 | 2001-11-13 09:58:00
 | [NAME] | 21.5 | 558 | 578 | 36.9 | 38.2 | 0.51 | 2001-11-13 09:58:00
 | CL X2 | 21.5 | 560 | 580 | 35.5 | 36.8 | 0.49 | 2001-11-13 09:58:00
 | [NAME] | 21.5 | 562 | 582 | 34.4 | 35.6 | 0.47 | 2001-11-13 09:58:00
 | CL M3 | 21.5 | 560 | 580 | 28.8 | 29.8 | 0.4 | 2001-11-13 09:58:00
 | CL Z3 | 21.5 | 560 | 580 | 25.5 | 26.5 | 0.35 | 2001-11-13 09:58:00
Spreadsheet: mary_hain__25844__4th qtr 2000 GENCO FERC
Sheet: Lincoln Center Operations

Des Plaines Green Land Development, L.L.C.
FERC Filing
Generation Sales:
Organization Name | Transaction Type | Firm/Interruptable | Volume (MW) | Min Price | [NAME] | Point Name
Enron Power Marketing Inc. | S | F | -588 | 56 | 112 | ENLC-LincolnCenter(CE)-EPMI
Total Generation Sales
Spreadsheet: 219362d1362736422-using-offset-and-or-transpose-functions-to-copy-multiple-rows-of-data-into-multiple-columns-problem
Sheet: Sheet1

0.942 | 0.867 | 1.023
1.147 | 0.953 | 1.38
0.762 | 0.652 | 0.892
1.895 | 1.413 | 2.542
1.145 | 1.043 | 1.257
0.752 | 0.623 | 0.907
0.868 | 0.748 | 1.008
1.494 | 0.873 | 2.557
[…~2,000 rows of data]
[NAME] I've tried to get this sort this problem out:
OFFSET(A$1,(ROWS($1:1)-ROW($1:1))*2,,)
OFFSET($A$1,((ROW()-1)*2)+COLUMN()-2,0)
OFFSET($A$1,COLUMN()-2,ROW()-2)
The result I am getting now (using first formula above)
The result I want:
0.942 | 0.867 | 1.023 | 0.762 | 0.652 | 0.892 | 1.145 | 1.043 | 1.257 | 0.868 | 0.748 | 1.008
Spreadsheet: 127403d1320338115-help-when-vlookups-just-arent-enough-data-test-sheet
Sheet: Master List

Item ID Number | Activity Description | Project X Link
0100-100A | Activity 1
0100-100B | Activity 2
0100-100C | Activity 3
0100-100D | Activity 4
0100-101A | Activity 5
0100-101B | Activity 6
0100-101C | Activity 7
0100-101D | Activity 8
0200-074A | Activity 9
0200-074B | Activity 10
0200-074C | Activity 11
0200-074D | Activity 12
0200-075A | Activity 13
0200-075B | Activity 14
1100-392A | Activity 15
1100-392B | Activity 16
1100-392C | Activity 17
1100-392D | Activity 18
1100-395A | Activity 19
1100-395B | Activity 20
1100-395C | Activity 21
1100-395D | Activity 22
1112-102A | Activity 23
1112-102B | Activity 24
1112-102C | Activity 25
1112-102D | Activity 26
1300-305A | Activity 27
1300-305B | Activity 28
1300-305C | Activity 29
1300-305D | Activity 30
1300-395A | Activity 31
1300-395B | Activity 32
1300-395C | Activity 33
1300-395D | Activity 34
5000-234A | Activity 35
5000-234B | Activity 36
5000-234C | Activity 37
5000-234D | Activity 38
5100105A | Activity 39
5100105B | Activity 40
5100105C | Activity 41
0600105A | Activity 42
0600105B | Activity 43
Spreadsheet: scott_neal__38019__MgmtSum-Q2_2001_0511
Sheet: CapChrg

ENRON NORTH AMERICA
2nd QUARTER 2001 CAPITAL CHARGE
 |  | Capital Charge
Business Team |  | Forecast | Plan | [NAME] | Explanation
 |  |  | 0
 |  | 74 | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  | 0 | 0
 |  | 49 | 0
 |  |  | 0
 |  |  | 0
Total East Power
 |  | 0 | 111
 |  | 2419 | 4139
 |  | 419 | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Total West Power
West (Allen/Tycholiz) |  |  | 0
Central (Shively/Luce) |  | 234 | 144
East (Neal/Vickers) |  | 776 | 1572
Texas (Martin) |  |  | 0
Financial (Arnold) |  |  | 0
Derivatives (Lagrasta) |  |  | 0
NG Structuring (McMicheal) |  |  | 0
NG Fundamentals (Gaskill) |  |  | 0
Management |  |  | 0 | 0
Total Natural Gas
Natural Gas (McKay/LeDain) |  | -8 | 99
Finance (Kitagawa) |  | 1966 | 304
Alberta Power (Zufferli/Davies) |  |  | 0
Ontario Power (Devries) |  | 0 | 447
Retail (Milnthorp) |  |  | 0
Executive (Milnthorp) |  |  | 0
Total Canada
Upstream Executive (Mrha) |  |  | 0
Compression Services ([NAME]) |  |  | 0
Offshore (Byargeon) |  | -66 | 653
Storage (Bieniawski) |  |  | 0
[NAME] (Grass) |  | 27 | 0
[NAME] (Mrha) |  |  | 0
Bridgeline (Mrha) |  | 7864 | 6282
HPL (Redmond) |  |  | 0
LT Fundamentals/Transport ([NAME]) |  |  | 0
Mexico (Yzaguirre) |  | 40 | 0
Generation Investments (Duran) |  | 21941 | 15210
Principal Investing ([NAME]) |  | 4912 | 7109
Energy Capital Svcs (Thompson/Josey) |  | 10100 | 7606
Corporate Development (Detmering) |  | 14074 | 13627
Restructuring (Redmond/Lydecker) |  | 8120 | 13372
[NAME] |  | 16296 | 32888
Cross Commodity (Lavorato) |  |  | 0
Office of the Chairman (Lavorato/Kitchen) |  |  | 0
TVA Settlement |  |  | 0
Overview |  |  | 0
Total Commercial
Other Interest Related |  | 0 | 0
Capital Charge Offset
Americas Capital Charge
Interest Expense/(Income) |  | 0 | 0 | 0
TOTAL
Unallocable Cap Charge |  |  |  | items not identifiable to a specific team- IT P,P&E, build-outs, broker cash, etc.
Original Delainey number
HPL |  |  | 81259
Spreadsheet: 668466d1584834869-match-different-variables-to-different-sheets-vlookup-2-column-from-sheet2
Sheet: Sheet1

Link | Code | Decription
www.refineyourwellness.com | 145 |  | << [NAME] here and pull down
 | 2
alironandmetal.com | 53
 | 83
 | 38
www.a1vinylsignsllc.com | 35
 | 29
Spreadsheet: 203594d1357179451-drop-down-list-exclusionlist
Sheet: Sheet2

Datavalidation |  | List of not-yet-selected
8
11
16
19
Spreadsheet: 712777d1610396243-sumif-formula-pulling-0-test-
Sheet: Team Roster, Bill Rate, and Bil

Worker | Current [NAME] [ST/Hr] | Location | Business Unit | Billback IO |  | Regions | Team Members
[NAME] | 22.8 | Edmonton | CSPE | 5077464
[NAME] | 22.8 | Edmonton | Agriculture |  |  | Calgary
[NAME] | 25 | Vancouver | Health |  |  | Edmonton
[NAME] | 23.16 | Vancouver | MDU |  |  | Fraser Valley
[NAME] | 23.16 | Fraser Valley | MET |  |  | Kelowna
[NAME] | 25 | Vancouver | NGM |  |  | Vancouver
[NAME] | 23.17 | Calgary | SBS/MTU |  |  | Victoria
Carmen Risselada | 25.1 | Edmonton | SHS
[NAME] | 23.16 | Vancouver | Team Meeting | 5077464
[NAME] | 23.16 | Fraser Valley | [NAME] | 5077464
Harman Dhillon | 23.16 | Fraser Valley | Clothing | 5077464
Harshith bheemavarapu | 23.14 | Victoria | Tablet | 5077464
[NAME] | 22.79 | Calgary | Shipping | 5077464
[NAME] | 25 | Fraser Valley | Training | 5077464
[NAME] | 23.16 | Fraser Valley | Compliancy | 5077464
[NAME] | 22.8 | Edmonton
[NAME] | 25 | Calgary
[NAME] | 25 | Kelowna
[NAME] | 23.16 | Vancouver
[NAME] | 24.42 | Vancouver
[NAME] | 24.98 | Vancouver
Milan Tiwana | 23.14 | Vancouver
[NAME] | 24.64 | Edmonton
Navdeep Gill | 23.16 | Fraser Valley
[NAME] | 23.16 | Vancouver
[NAME] | 23.16 | Vancouver
[NAME] |  | Victoria
[NAME] | 22.3 | Edmonton
Ray Siluch | 25 | Victoria
[NAME] | 28 | Vancouver
Robyn Fabbi | 24.37 | Victoria
[NAME] | 23.6 | Calgary
[NAME] | 22.79 | Edmonton
[NAME] | 22.8 | Calgary
Toni Tsim | 22.8 | Calgary
Spreadsheet: 775724d1649270484-golf-poker-sorting-of-values-golf-poker
Sheet: Sheet1

 |  | POKER
 |  | NAME | HOLE # | 7 | 15 | 16 | 14 | 1 |  | HAND
 | 452 | SMITH, JOE |  | 4 | 5 | 4 | 6 | 4 |  |  |  | 44465
 | 457 | JONES, GARY |  | 5 | 6 | 3 | 6 | 4 |  |  |  | 66543
 | 456 | ROONEY, ART |  | 6 | 5 | 3 | 6 | 3 |  |  |  | 66335
 | 360 | WALKER, LARRY |  | 5 | 5 | 4 | 6 | 5 |  |  | W | 55564
 | 256 | CARREY, JIM |  | 5 | 5 | 3 | 6 | 4 |  |  |  | 55643
 | 253 | HALL, FRED |  | 5 | 6 | 3 | 6 | 7 |  |  |  | 66753
 | 195 | DAVIS, BILL |  | 5 | 4 | 5 | 8 | 6 |  |  |  | 55864
 | 355 | MONROE, BOB |  | 4 | 6 | 4 | 5 | 7 |  |  | Z | 44765
Spreadsheet: 269976d1381337421-huge-problem-with-the-indirect-function-trying-to-create-dependent-drop-downs-pcard-amounts-removed
Sheet: August

 |  |  |  |  |  |  |  |  |  |  |  |  | Validation Codes | R110 | R210 | R310 | R410
 |  |  |  |  |  |  |  |  |  |  |  |  | CodeR110 | 701 | 720 | 730 | 740
 |  |  |  |  |  |  |  |  |  |  |  |  | CodeR210 | 702 | 721 | 731 | 741
Purpose: September, 2013 | September Statement |  |  |  |  |  |  |  |  |  |  |  | CodeR310 | 703 | 722 | 732 | 750
 |  |  |  |  |  |  |  |  |  |  |  |  | CodeR410 | 704 | 723
Description (Project Code title) | Retailer | Line Description | Total | GST | Fund | Org | Activity | Acct | Project | [NAME] |  |  | CodeR510 | 706 | 724
 |  |  |  |  |  | 0000 | CodeR210 | 64202 | =INDIRECT(CodeR110, H7) | 00 |  |  |  | 707
 |  |  |  |  |  | 0000 | R110 | 64210 | 711 | 00 |  |  |  | 708
 |  |  |  |  |  | 0000 | R210 | 64202 | 721 | 00 |  |  |  | 709
 |  |  |  |  |  | 0000 | R310 | 64115 | 732 | 00 |  |  |  | 710
 |  |  |  |  |  | 0000 | R110 | 64115 | 709 | 00 |  |  |  | 711
 |  |  |  |  |  | 0000 | R210 | 64202 | 721 | 00 |  |  |  | 712
 |  |  |  |  |  | 0000 | R210 | 64115 | 721 | 00 |  |  |  | 713
 |  |  |  |  |  | 0000 | R210 | 64202 | 721 | 00 |  |  |  | 714
 |  |  |  |  |  | 0000 | R310 | 64115 | 732 | 00 |  |  |  | 715
 |  |  |  |  |  | 0000 | R310 | 64601 | 730 | 00
 |  |  |  |  |  | 0000 | R310 | 68102 | 730 | 00
 |  |  |  |  |  | 0000 | R310 | 64216 | 732 | 00
 |  |  |  |  |  | 0000 | R210 | 64202 | 721 | 00
 |  |  |  |  |  | 0000 | R210 | 64202 | 721 | 00
 |  |  |  |  |  | 0000 | R210 | 64115 | 722 | 00
 |  |  |  |  |  | 0000 | R210 | 64216 | 720 | 00
 |  |  |  |  |  | 0000 | R110 | 64216 | 706 | 00
 |  |  |  |  |  | 0000 | R210 | 64202 | 721 | 00
 |  |  |  |  |  | 0000 | R310 | 64115 | 730 | 00
 |  |  |  |  |  | 0000 | R310 | 64115 | 730 | 00
 |  |  |  |  |  | 0000 | R110 | 68102 | 711 | 00
 |  |  |  |  |  | 0000 | R310 | 61561 | 732 | 00
TOTAL RECEIPTS