tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e0c19420-e3bf-4dfa-a921-9c50e133fd9b
Sheet: non-GAAP Op Exp

The NASDAQ OMX Group, Inc.
Reconciliation of GAAP Net Income, Diluted Earnings Per Share, Operating Income and Operating Expenses
to Non-GAAP Net Income, Diluted Earnings Per Share, Operating Income and Operating Expenses
(in millions)
(unaudited)
 |  | Three Months Ended
 |  | March 31, |  | December 31, |  | March 31,
 |  | 2011 |  | 2010 |  | 2010
GAAP operating expenses: |  | 234 |  | 225 |  | 248
Non-GAAP adjustments:
Merger and strategic initiatives |  | -5 |  | -2 |  | 0
[NAME] reserves |  | -2 |  | -1 |  | -2
Asset retirements |  | -1 |  | -2 |  | -3
Workforce reductions |  | 0 |  | -2 |  | -2
Debt repayment |  | 0 |  | 0 |  | -40
Other |  | -1 |  | -2 |  | 0
Total non-GAAP adjustments |  | -9 |  | -9 |  | -47
Non-GAAP operating expenses |  | 225 |  | 216 |  | 201
Spreadsheet: 160699d1339168637-getting-good-pivot-data-pivotexample
Sheet: Original Data

[NAME] | Department | Region | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
[NAME] | A | East | 123 | 365 | 123 | 846 | 123 | 753 | 951 | 852 | 159 | 54 | 222 | 584
Sue | A | South | 365 | 487 | 365 | 123 | 159 | 751 | 159 | 258 | 365 | 487 | 751 | 654
[NAME] | B | East | 258 | 751 | 258 | 159 | 258 | 456 | 365 | 258 | 159 | 48 | 741 | 843
[NAME] | C | South | 159 | 654 | 159 | 753 | 365 | 846 | 123 | 159 | 751 | 789 | 365 | 487
 | Data
Department | Sum of Jan-12 | Sum of Feb-12 | Sum of Mar-12 | Sum of Apr-12 | Sum of May-12 | Sum of Jun-12 | Sum of Jul-12 | Sum of Aug-12 | Sum of Sep-12 | Sum of Oct-12 | Sum of Nov-12 | Sum of Dec-12
A | 488 | 852 | 488 | 969 | 282 | 1504 | 1110 | 1110 | 524 | 541 | 973 | 1238
B | 258 | 751 | 258 | 159 | 258 | 456 | 365 | 258 | 159 | 48 | 741 | 843
C | 159 | 654 | 159 | 753 | 365 | 846 | 123 | 159 | 751 | 789 | 365 | 487
Grand Total | 905 | 2257 | 905 | 1881 | 905 | 2806 | 1598 | 1527 | 1434 | 1378 | 2079 | 2568
Spreadsheet: 117945d1313284880-question-on-removing-duplicate-data-test
Sheet: Sheet1

[NAME] | [NAME] | Status
DT138319 | MS11-050 | StatusNotPatched
DT138319 | MS11-052 | StatusNotPatched
DT138319 | MS11-044 | StatusNotPatched
DT138319 | MS11-039 | StatusNotPatched
DT138319 | MS11-038 | StatusNotPatched
DT138319 | MS11-015 | StatusNotPatched
DT138319 | MS11-006 | StatusNotPatched
DT138319 | MS11-031 | StatusNotPatched
DT141094 | MS11-050 | StatusNotPatched
DT141094 | MS11-052 | StatusNotPatched
DT141094 | MS11-039 | StatusNotPatched
DT141094 | MS11-044 | StatusNotPatched
DT141094 | MS11-029 | StatusNotPatched
DT141094 | MS11-038 | StatusNotPatched
DT141094 | MS11-015 | StatusNotPatched
DT141094 | MS11-006 | StatusNotPatched
DT141094 | MS11-032 | StatusNotPatched
DT141094 | MS11-027 | StatusNotPatched
DT141094 | MS11-020 | StatusNotPatched
DT141094 | MS11-030 | StatusNotPatched
DT141094 | MS11-031 | StatusNotPatched
DT141094 | MS11-042 | StatusNotPatched
DT141094 | MS11-043 | StatusNotPatched
DT141094 | MS10-076 | StatusNotPatched
DT144271 | MS11-039 | StatusNotPatched
DT144271 | MS11-044 | StatusNotPatched
DT144283 | MS11-039 | StatusNotPatched
Spreadsheet: 730578d1619775191-search-for-a-text-and-then-search-for-another-text-after-the-row-containing-the-first-text-sample
Sheet: Sheet1

Description | Product Quantity
some text | some text
some text | some text
some text | some text
Location: TN
Product 2 | 20
Product 5 | 10
Product 8 | 15
Location: AP
Product 2 | 10
Product 1 | 45
Location: KL
Product 5 | 15
Product 1 | 30
Product 2 | 25
Product 8 | 25
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-13-P-0020

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-13-P-0020 |  | 4FC66 | 1P
W912LP-13-P-0020 | 10273581 |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 117682d1312961162-expanding-sum-based-on-months-excel-upload-1-
Sheet: lookup table

 | No | Column | Month | Acutal | Budget | Column
 | 1 | 3 | January | January Acutal | January Budget | D:D
 | 2 | 4 | February | February Acutal | February Budget | D:E
 | 3 | 5 | March | March Acutal | March Budget | D:F
 | 4 | 6 | April | April Acutal | April Budget | D:G
 | 5 | 7 | May | May Acutal | May Budget | D:H
 | 6 | 8 | June | June Acutal | June Budget | D:I
 | 7 | 9 | July | July Acutal | July Budget | D:J
 | 8 | 10 | August | August Acutal | August Budget | D:K
 | 9 | 11 | September | September Acutal | September Budget | D:L
 | 10 | 12 | October | October Acutal | October Budget | D:M
 | 11 | 13 | November | November Acutal | November Budget | D:N
 | 12 | 14 | December | December Acutal | December Budget | D:O
Spreadsheet: 805737d1668873130-if-statements-to-show-expiry-date-values-if-statements-expiry-dates-philipsfn-
Sheet: Sheet1

Lot | Lot [NAME] | Value | [NAME] 100% | Inventory expiring within 6 months @ 75% | Inventory Expiring between 6 to 9 months @ 50% | Inventory Expiring within 1 year @ 25%
[NAME] | 2023-01-31 00:00:00 | 5000
ZLNTA2102A | 2021-12-31 00:00:00 | 1200
ZLNTA2103A | 2023-01-31 00:00:00 | 1300
P321016 | 2020-07-31 00:00:00 | 60000
P321045 | 2023-07-31 00:00:00 | 75000 |  |  |  |  |  | << Date changed for illustrative purposes.
P321046 | 2023-10-31 00:00:00 | 5000
P321047 | 2023-10-31 00:00:00 | 1200
P321048 | 2023-10-31 00:00:00 | 1300
P321049 | 2023-10-31 00:00:00 | 60000
P321054 | 2023-11-30 00:00:00 | 75000
P321055 | 2023-11-30 00:00:00 | 5000
[NAME] | 2023-11-30 00:00:00 | 1200
P321057 | 2023-11-30 00:00:00 | 1300
P321058 | 2023-11-30 00:00:00 | 60000
P322008 | 2024-04-30 00:00:00 | 75000
Spreadsheet: 815039d1674713524-multiple-selections-for-index-match-weekly-ytd-ad-spend_vwip2-1-1-
Sheet: Summary

Campaign | General Awareness Global
Date Range | 2023-01-01 00:00:00 | to | 2023-01-24 00:00:00
 |  |  |  |  |  |  | Expected For General Awareness Campaign |  |  |  | Expected For IBD Awareness Campaign
Platform | Spent | Impressions | CTR | Clicks | CPC |  | Spent | Impressions | Clicks |  | Spent | Impressions | Clicks
Google Ads (Awareness)
Google Ads (Whitepaper)
Google Ads (Jobs)
LinkedIn Awareness Static
LinkedIn Awareness Spotlight
LinkedIn Awareness Text |  |  |  |  |  |  |  |  |  |  |  |  | 1
LinkedIn Awareness Video
LinkedIn Awareness Carousel
LinkedIn (Conferences Static)
LinkedIn (Conferences Video)
LinkedIn (Lead Gen) |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 62.41 | 0 | 0
LinkedIn (Jobs) |  |  |  |  |  |  |  |  | General Awareness LI Spent Spotlight |  |  | 0 | 0 | 114.57 | 27.32 | 0
LinkedIn (Boosted Organic) |  |  |  |  |  |  |  |  | General Awareness LI Spent Static |  |  | 0 | 0 | 115.52 | 64.85 | 0
Programmatic |  |  |  |  |  |  |  |  | General Awareness LI Spent Text |  |  | 0 | 8718 | 109.97 | 82.75 | 0
 |  |  |  |  |  |  |  |  | General Awareness LI Spent Video |  |  | 0 | 11812 | 89.03 | 40.77 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 4798 | 111.14 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 2360 | 87.19 | 12.56 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1869 | 82.16 | 2 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 7538 | 108.66 | 26.18 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 6453 | 112.23 | 15.6 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 3979 | 106.49 | 55.23 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 4543 | 102.81 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 7837 | 102.91 | 55.2 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1444 | 85.05 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 2170 | 77.61 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 7072 | 107 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 6456 | 112.54 | 8.22 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 4163 | 103.55 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 2750 | 106.72 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 6337 | 107.55 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 441 | 84.33 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 968 | 86.11 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 9863 | 106.02 | 25 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 4650 | 105.72 | 55.75 | 0
Spreadsheet: 765122d1643184704-average-nth-for-certain-row-examples-ans1
Sheet: Sheet2

 |  |  |  |  | FORMULA
 | 1 |  |  | Average
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 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
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
 | 101
 | 102
 | 103
 | 104
 | 105
 | 106
 | 107
 | 108
 | 109
 | 110
 | 111
 | 112
 | 113
 | 114
 | 115
 | 116
 | 117
 | 118
 | 119
 | 120
 | 121
 | 122
 | 123
 | 124
 | 125
 | 126
 | 127
 | 128
 | 129
 | 130
 | 131
 | 132
 | 133
 | 134
 | 135
 | 136
 | 137
 | 138
 | 139
 | 140
 | 141
 | 142
 | 143
 | 144
 | 145
 | 146
 | 147
 | 148
 | 149
 | 150
 | 151
 | 152
 | 153
 | 154
 | 155
 | 156
 | 157
 | 158
 | 159
 | 160
 | 161
 | 162
 | 163
 | 164
 | 165
 | 166
 | 167
 | 168
 | 169
 | 170
 | 171
 | 172
 | 173
 | 174
 | 175
 | 176
 | 177
 | 178
 | 179
 | 180
 | 181
 | 182
 | 183
 | 184
 | 185
 | 186
 | 187
 | 188
 | 189
 | 190
 | 191
 | 192
 | 193
 | 194
 | 195
 | 196
 | 197
 | 198
 | 199
 | 200
 | 201
Spreadsheet: 175296d1345481727-conditional-formatting-made-easier-book1
Sheet: Sheet1

 | KATY NEW ARM SALES GOALS
 | Weekly(SUN-SAT) |  |  |  |  | Monthly |  |  |  |  | Quarterly
 | Goal |  | 140 |  |  | Goal |  | 600 |  |  | Goal |  | 1800 |  |  |  |  | Weekly Goal
 | Actual |  | 71 |  |  | Actual |  | 299 |  |  | Actual |  | 1150 |  |  |  |  | Monthly Goal
 | Percentage |  |  |  |  | Percentage |  |  |  |  | Percentage |  |  |  |  |  |  | [NAME]
 | Over 100% |  |  |  |  | Over 100% |  |  |  |  | Over 100%
 | 76% to 100% |  |  |  |  | 76% to 100% |  |  |  |  | 76% to 100%
 | 51% to 75% |  |  |  |  | 51% to 75% |  |  |  |  | 51% to 75%
 | 26% to 50% |  |  |  |  | 26% to 50% |  |  |  |  | 26% to 50%
 | 0% to 25% |  |  |  |  | 0% to 25% |  |  |  |  | 0% to 25%
Spreadsheet: 678172d1589750627-how-to-enlist-specific-information-in-a-tab-referring-to-another-tab-how-to
Sheet: Blad1

Situation tab 1
 |  | nWC | nWC | WC | Tasman | nWC | WC
Ascari | Alberto | 1 | - | 8 | - | 3 | 2
Farina | [NAME] | 6 | 5 | 16 | - | 1 | 1
Heath | [NAME] | 4 | 12 | - | 6 | 8 | -
Watson | [NAME] | - | 7 | 3 | 3 | 4 | 9
 | (WC = World Championship)
Disired situation tab 2
 |  | WC | WC
Ascari | Alberto | 8 | 2
Farina | [NAME] | 16 | 1
Heath | [NAME] | - | -
Watson | [NAME] | 3 | 9
Spreadsheet: 73982d1274561286-trouble-with-laying-out-data-set-dataset_rev2
Sheet: Dataset

INDIRECT to reference the worksheet named with Dept | Filters on Department,Year And Month columns |  |  |  | HLOOKUP & MATCH
Department | Year | Forecast Month | Revenue Category | [NAME] | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Dept1 | 2010 | Jan | Complete
Dept1 | 2010 | Jan | Live
Dept1 | 2010 | Jan | Booked On
Dept1 | 2010 | Jan | High Prob
Dept1 | 2010 | Jan | Indentified
Dept1 | 2010 | Jan | Blue Sky
Dept2 | 2010 | Jan | Complete
Dept2 | 2010 | Jan | Live
Dept2 | 2010 | Jan | Booked On
Dept2 | 2010 | Jan | High Prob
Dept2 | 2010 | Jan | Indentified
Dept2 | 2010 | Jan | Blue Sky
Dept1 | 2011 | Jan | Complete
Dept1 | 2011 | Jan | Live
Dept1 | 2011 | Jan | Booked On
Dept1 | 2011 | Jan | High Prob
Dept1 | 2011 | Jan | Indentified
Dept1 | 2011 | Jan | Blue Sky
Dept2 | 2011 | Jan | Complete
Dept2 | 2011 | Jan | Live
Dept2 | 2011 | Jan | Booked On
Dept2 | 2011 | Jan | High Prob
Dept2 | 2011 | Jan | Indentified
Dept2 | 2011 | Jan | Blue Sky
 |  |  | Will a flat dataset like this work or is there a better format to capture each departments forecast for the year
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 02 April 2012

Daily Morning Staff |  |  |  |  | Monday
 | 07:30-14:30 |  | 2012-04-02 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS | Comp off last year 2011
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS | last year balance leave 2011
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME] | Annual leave
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R36

Ime artikla
Spreadsheet: 860309d1708449022-whats-is-wrong-with-my-formula-copy-of-dec23-design
Sheet: Electric Vehicle

Project | Epic | Issue | Sub-task | User | Key | Logged | 01/Dec/23 | 2023-12-02 00:00:00 | 2023-12-03 00:00:00 | 04/Dec/23 | 05/Dec/23 | 06/Dec/23 | 07/Dec/23 | 2023-12-08 00:00:00 | 2023-12-09 00:00:00 | 2023-12-10 00:00:00 | 2023-12-11 00:00:00 | 2023-12-12 00:00:00 | 2023-12-13 00:00:00 | 2023-12-14 00:00:00 | 2023-12-15 00:00:00 | 2023-12-16 00:00:00 | 2023-12-17 00:00:00 | 2023-12-18 00:00:00 | 2023-12-19 00:00:00 | 2023-12-20 00:00:00 | 21/Dec/23 | 22/Dec/23 | 2023-12-23 00:00:00 | 2023-12-24 00:00:00 | 2023-12-25 00:00:00 | 26/Dec/23 | 27/Dec/23 | 28/Dec/23 | 29/Dec/23 | 2023-12-30 00:00:00 | 2023-12-31 00:00:00
[Design] MS - Electric Vehicles Landing |  |  |  |  | MEVL | 55.5 | 1 |  |  | 10 | 7 | 6 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 |  |  |  | 6.5 | 5.5 | 5.5 | 6
[Design] MS - Electric Vehicles Landing | No Epic |  |  |  |  | 55.5 | 1 |  |  | 10 | 7 | 6 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 |  |  |  | 6.5 | 5.5 | 5.5 | 6
[Design] MS - Electric Vehicles Landing | No Epic | EV - Hi-fi Mobile mock |  |  | MEVL-5 | 7 |  |  |  | 2 | 3 | 2
[Design] MS - Electric Vehicles Landing | No Epic | EV - Hi-fi Mobile mock | No Sub-task |  |  | 7 |  |  |  | 2 | 3 | 2
[Design] MS - Electric Vehicles Landing | No Epic | EV - Hi-fi Mobile mock | No Sub-task | Adam |  | 5 |  |  |  | 2 | 3
[Design] MS - Electric Vehicles Landing | No Epic | EV - Hi-fi Mobile mock | No Sub-task | [NAME] |  | 2 |  |  |  |  |  | 2
[Design] MS - Electric Vehicles Landing | No Epic | EV - Hi-fi mock 1.0 |  |  | MEVL-4 | 28.5 | 1 |  |  | 8 | 4 | 4 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.5 | 3.5 | 2.5
[Design] MS - Electric Vehicles Landing | No Epic | EV - Hi-fi mock 1.0 | No Sub-task |  |  | 28.5 | 1 |  |  | 8 | 4 | 4 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.5 | 3.5 | 2.5
[Design] MS - Electric Vehicles Landing | No Epic | EV - Hi-fi mock 1.0 | No Sub-task | Adam |  | 11 | 1 |  |  | 3 | 2 | 3 | 2
[Design] MS - Electric Vehicles Landing | No Epic | EV - Hi-fi mock 1.0 | No Sub-task | [NAME] |  | 17.5 |  |  |  | 5 | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.5 | 3.5 | 2.5
[Design] MS - Electric Vehicles Landing | No Epic | EV - Hi-Fi Mock 2.0 |  |  | MEVL-6 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 |  |  |  | 3 | 2 | 3 | 6
[Design] MS - Electric Vehicles Landing | No Epic | EV - Hi-Fi Mock 2.0 | No Sub-task |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 |  |  |  | 3 | 2 | 3 | 6
[Design] MS - Electric Vehicles Landing | No Epic | EV - Hi-Fi Mock 2.0 | No Sub-task | Adam |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 |  |  |  | 3 | 2 | 3 | 2
[Design] MS - Electric Vehicles Landing | No Epic | EV - Hi-Fi Mock 2.0 | No Sub-task | [NAME] |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  | 55.5 | 1 |  |  | 10 | 7 | 6 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 |  |  |  | 6.5 | 5.5 | 5.5 | 6
Spreadsheet: andy_zipper__789__Broker & Exchange Detail 10-25-01 EM
Sheet: EXCHANGE DEAL SUMMARY

EnronOnline Exchange Detail for 10/25/2001
Completed Transactions:
TODAY
Date | 2001-10-25 00:00:00
Count
Exchange Party | Counterparty Name | Commodity | Total
Grand Total
No Exchange Activity
LTD
Date | (All)
Count
Exchange Party | Counterparty Name | Commodity | Total
True Quote LLC | PG&E Energy Trading - Power, L.P. | US East Power | 80
 |  | US West Power | 25
 | Tucson Electric Power Company | US West Power | 2
 | Cinergy Marketing & Trading, LLC | Natural Gas | 2
 | Conectiv Energy Supply, Inc. | US East Power | 11
 |  | Natural Gas | 1
 | Tractebel Energy Marketing, Inc. | US East Power | 1
 |  | Natural Gas | 15
 | CMS Marketing, Services and Trading Company | US East Power | 1
 |  | Natural Gas | 3
 | Calpine Energy Services, L.P. | US East Power | 4
 |  | US West Power | 2
 |  | Natural Gas | 9
 | CLECO Marketing and Trading, LLC | Natural Gas | 1
 | PG&E Energy Trading-Gas Corporation | Natural Gas | 127
 | Axia Energy, LP | Natural Gas | 3
 | Entergy-Koch Trading, LP | Natural Gas | 10
 | Conoco Inc. | Natural Gas | 11
 | Richardson Energy Marketing, Ltd. | Natural Gas | 1
True Quote LLC Total |  |  | 309
Grand Total |  |  | 309
Spreadsheet: mark_taylor__25042__Week 13 Lines
Sheet: Sheet1

 |  | Wk 13
Game # | Day | Spread
1 | Friday | Louisville | 7 | TCU
2 |  | Texas | 11.5 | TEXAS A&M
3 |  | California | 12 | RUTGERS
4 |  | LSU | 9.5 | Arkansas
5 |  | ARIZONA STATE | NL | Arizona
6 |  | Nebraska | 10.5 | COLORADO
7 |  | EAST CAROLINA | 3 | So. Mississippi
8 |  | Toledo | 3 | BOWLING GREEN
9 |  | FRESNO STATE | 28 | San Jose. St.
10 | Saturday | TEMPLE | 17 | Connecticut
11 |  | SYRACUSE | 3.5 | Boston College
12 |  | MICHIGAN STATE | NL | Penn State
13 |  | INDIANA | 1 | Purdue
14 |  | Wisconsin | 3 | MINNESOTA
15 |  | N.C. STATE | 25 | Ohio
16 |  | Pittsburgh | 3 | WEST VIRGINIA
17 |  | OKLAHOMA | 27 | Okla. State
18 |  | MICHIGAN | 8.5 | Ohio State
19 |  | MIAMI (FLA.) | 25 | Washington
20 |  | Iowa | 4 | IOWA STATE
21 |  | MEMPHIS | NL | Cincinnati
22 |  | KANSAS | 3.5 | Wyoming
23 |  | KANSAS STATE | 20 | Missouri
24 |  | La. [NAME] | 20 | TULSA
25 |  | [NAME] | 6 | SOU. METHODIST
26 |  | BOISE STATE | 27 | Central Michigan
27 |  | TENNESSEE | 26 | [NAME]
28 |  | Miami (Ohio) | 6 | KENT
29 |  | C. FLORIDA | 28 | La.-Lafayette
30 |  | AKRON | 17 | E. Michigan
31 |  | WESTERN MICH. | 11 | [NAME]
32 |  | WAKE FOREST | 12 | [NAME]
33 |  | SOUTH FLORIDA | NL | Utah State
34 |  | STANFORD | 7.5 | Notre Dame
35 |  | GEORGIA TECH | 2.5 | Georgia
36 |  | NEW MEXICO | 11.5 | New Mexico State
37 |  | TEXAS-EL PASO | NL | Nevada
38 |  | HAWAII | 9 | Air Force
Spreadsheet: 743369d1628445012-list-values-based-on-other-cells-list-valuesrep
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | 7 | 9 | 34 | 38 | 26 | 5 | 36 | 39 | 28
55 | 56 | 57 | 3 | 11 | 22 | 44 | 55 | 38 | 15
18 | 18 | 26 | 5 | 1 | 7 | 5 | 10 | 13 | 38
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] if a2-J2 is between 25 and 40
 |  |  |  |  |  |  |  |  |  | IF(ISNUMBER(VLOOKUP(A2,{1;7;9},1,0)),A1,"")
 |  |  |  |  |  |  |  |  |  | IF(ISNUMBER(VLOOKUP(A2,{1;7;9},1,0)*VLOOKUP(A3,{3;11;22},1,0)*VLOOKUP(A4,{5;10;13},1,0)),A1,"")
Spreadsheet: d5268c5a-d39b-493e-ae3d-0bdf87b10476
Sheet: BU6

Date | Day | Start Time | Field | Home | Visitor |  | Date | Day | Start Time | Field | Home | Visitor
2013-02-10 00:00:00 | Sunday | 11:00AM | PVF 2 | 607 | 601 |  | 2013-03-10 00:00:00 | Sunday | 11:00AM | PVF 2 | 604 | 605
2013-02-10 00:00:00 | Sunday | 12:00PM | PVF 2 | 606 | 602 |  | 2013-03-10 00:00:00 | Sunday | 12:00PM | PVF 2 | 603 | 606
2013-02-10 00:00:00 | Sunday | 1:00PM | PVF 2 | 604 | 608 |  | 2013-03-10 00:00:00 | Sunday | 1:00PM | PVF 2 | 601 | 608
2013-02-10 00:00:00 | Sunday | 2:00PM | PVF 2 | 605 | 603 |  | 2013-03-10 00:00:00 | Sunday | 2:00PM | PVF 2 | 602 | 607
2013-02-17 00:00:00 | Sunday | 11:00AM | PVF 2 | 601 | 602 |  | 2013-03-17 00:00:00 | Sunday | 11:00AM | PVF 2 | 605 | 606
2013-02-17 00:00:00 | Sunday | 12:00PM | PVF 2 | 607 | 603 |  | 2013-03-17 00:00:00 | Sunday | 12:00PM | PVF 2 | 604 | 607
2013-02-17 00:00:00 | Sunday | 1:00PM | PVF 2 | 605 | 608 |  | 2013-03-17 00:00:00 | Sunday | 1:00PM | PVF 2 | 602 | 608
2013-02-17 00:00:00 | Sunday | 2:00PM | PVF 2 | 606 | 604 |  | 2013-03-17 00:00:00 | Sunday | 2:00PM | PVF 2 | 603 | 601
2013-02-24 00:00:00 | Sunday | 11:00AM | PVF 2 | 602 | 603 |  | 2013-04-07 00:00:00 | Sunday | 11:00AM | PVF 2 | 606 | 607
2013-02-24 00:00:00 | Sunday | 12:00PM | PVF 2 | 601 | 604 |  | 2013-04-07 00:00:00 | Sunday | 12:00PM | PVF 2 | 605 | 601
2013-02-24 00:00:00 | Sunday | 1:00PM | PVF 2 | 606 | 608 |  | 2013-04-07 00:00:00 | Sunday | 1:00PM | PVF 2 | 603 | 608
2013-02-24 00:00:00 | Sunday | 2:00PM | PVF 2 | 607 | 605 |  | 2013-04-07 00:00:00 | Sunday | 2:00PM | PVF 2 | 604 | 602
2013-03-03 00:00:00 | Sunday | 11:00AM | PVF 2 | 603 | 604 |  | 2013-04-14 00:00:00 | Sunday | 11:00AM | PVF 2 | 607 | 601
2013-03-03 00:00:00 | Sunday | 12:00PM | PVF 2 | 602 | 605 |  | 2013-04-14 00:00:00 | Sunday | 12:00PM | PVF 2 | 606 | 602
2013-03-03 00:00:00 | Sunday | 1:00PM | PVF 2 | 607 | 608 |  | 2013-04-14 00:00:00 | Sunday | 1:00PM | PVF 2 | 604 | 608
2013-03-03 00:00:00 | Sunday | 2:00PM | PVF 2 | 601 | 606 |  | 2013-04-14 00:00:00 | Sunday | 2:00PM | PVF 2 | 605 | 603
Spreadsheet: 767081d1644276083-need-help-on-spreadsheet-do-i-need-to-use-vlookup-hlookup-index-match-2022-law-dogs-standings
Sheet: Chunky

[NAME]
Wk# | Opponent | W | L | PF | PA | MARGIN
1 | Muckdogs
2 | Pics Hitmen
3 | Deadbirds
4 | Gator Dawgs
5 | Sharks
6 | Capo Crimini
7 | Thundermutts
8 | King of Queens
9 | Cajun Coonasses
10 | Wet Farts
11 | Mudcats
12 | Thundermutts
13 | Capo Crimini
14 | Mudcats
15 | Wet Farts
16 | Sharks
17 | Gator Dawgs
18 | Cajun Coonasses
19 | King of Queens
20 | Deadbirds
21 | Pics Hitmen
22 | Muckdogs
Spreadsheet: 886159d1736190580-simple-count-question-count-etaf
Sheet: Sheet1

COUNTS |  |  |  |  |  |  |  |  |  | < because all are formulas
 |  |  |  |  |  |  |  |  |  | < don't count blank, but even though formula returns "", still counts
 |  |  |  |  |  |  |  |  |  | < basic COUNT counts numbers, but not alpha
 | Table 1 |  |  |  |  |  | Table 2
 | Col A | Col B | Col C | Col D | Col E |  | Col X | Col Y | Col Z
 | A55 | Native | More |  |  |  | [NAME] | Yes | 45
 | [NAME] | Native 2 | More |  |  |  | B22 | Yes
 | B22 | Native | More 1 |  |  |  | C35 | No | 35
 | C35 | Native 2 | More 2 |  |  |  | D11 | Maybe | 25
 | C54 | Native | More 1 |  |  |  | D44 | No | 15
 | D11 | Native | More |  |  |  | E65 | Yes | 55
 | D29 | Native 2 | More 2
 | D44 | Native | More 3
 | D80 | Native 2 | More 1
 | E65 | Native 2 | More
 | F13 | Native 2 | More 3
Spreadsheet: 748577d1632223731-count-unique-text-across-multiple-columns-book6
Sheet: Sheet1

A | B | C
Australia | India | India
Bangladesh | China | [NAME]
China | Australia | Turkey
Germany | China | China
India |  | Vietnam
Indonesia |  | Bangladesh
Italy
Pakistan
Slovakia
Taiwan
Thailand
Turkey
United States
Vietnam