tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 877761d1724664900-sort-w-o-helper-column-new-microsoft-excel-2013-3-
Sheet: List3

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXCEL 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | with duplicates | sorted/helper | without duplicates | Sorted w/o helper
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rezultati:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<<AGGREGATE would be nice to have.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | These are fine results, it s just that sort that i need S-6,10,11…
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | List1!A1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-08-02 00:00:00
Spreadsheet: 738735d1625222582-formula-to-calculate-total-amount-of-previous-invoice-error-formula
Sheet: Numbering

Project Name | Sequence | https://www.extendoffice.com/documents/excel/3617-excel-increment-when-value-changes.html | Project Name-DSequence | Project Name-IAFSequence |  | DSequence | Project Name-DSequence | Project Name-IAFSequence | Invoice Total Amount | filter |  |  |  | Current IAF | PO No. | Total amount of Previous Invoice
Lab-[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  | Lab-[PHONE]-IAF15
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 22054.032 |  |  |  |  |  |  | with filter formula
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 211088.592 |  |  |  | Lab-[PHONE]-IAF10000
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 54419.04
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 44762.0472
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 219681.072
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 239785.778
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 45636.5
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 9680.8608
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 211088.592
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 54419.04
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 53026.3422
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 17602.65
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 8592.48
Lab-[PHONE] |  |  |  |  |  |  |  |  |  | 40375.1088
Spreadsheet: fd92dd61-3365-4a22-b665-588ea3d14751
Sheet: Sheet1

Figure 3.1 | Unnamed: 1 | Unnamed: 2
Norwegian participation in EU's sixth framework programme by thematic priorities.
 | Requested grant in short-listed projects | Requested grant in applications
Information Society Technologies | 264 | 1536
Sustainable Energy Systems | 312 | 712
Life sciences, genomics and biotechnology for health | 120 | 656
Food quality and safety | 160 | 536
Sustainable development, global change and ecosystems | 176 | 464
Sustainable Transport Systems | 184 | 288
Nanotechnologies and nanosciences, knowledge-based multifunctional materials and new production processes and devices | 32 | 256
Aeronautics and space | 96 | 176
Citizens and governance in a knowledge based society | 16 | 120
Spreadsheet: 148065d1333122468-excel-2007-referencing-particular-cells-book2
Sheet: Sheet1

WEEK 5/1 | TOTAL | FUNDING ESTIMATE
DATE |  | FACTOR % | $
2012-02-27 00:00:00 | 1843307.55
2012-02-28 00:00:00 | 5441692.09
2012-02-29 00:00:00 | 9714099.439999996
2012-03-01 00:00:00 | 13168771.55
2012-03-02 00:00:00 | 3370765.63
WEEKLY TOTAL | 33538636.25999999 | 0.65 | 21800113.569
Week 2 | TOTAL | FUNDING ESTIMATE
DATE |  | FACTOR % | $
2012-03-05 00:00:00 | 2372236.84
2012-03-06 00:00:00 | 1610105.74
2012-03-07 00:00:00 | 2087084.79
2012-03-08 00:00:00 | 2897997.72
2012-03-09 00:00:00 | 7172714.7
WEEKLY TOTAL | 16140139.79 | 0.65 | 10491090.8635
Week 3 | TOTAL | FUNDING ESTIMATE
DATE |  | FACTOR % | $
2012-03-12 00:00:00 | 2690387.63
2012-03-13 00:00:00 | 786331.87
2012-03-14 00:00:00 | 1564544.39
2012-03-15 00:00:00 | 8235377.390000002
2012-03-16 00:00:00 | 8668242.399999999
WEEKLY TOTAL | 21944883.68 | 0.65 | 14264174.392
WEEK 4 | TOTAL | FUNDING ESTIMATE
DATE |  | FACTOR % | $
2012-03-19 00:00:00 | 1524720.93
2012-03-20 00:00:00 | 3338391.41
2012-03-21 00:00:00 | 1186970.62
2012-03-22 00:00:00 | 2385216.03
2012-03-23 00:00:00 | 6318728.56
WEEKLY TOTAL | 14754027.55 | 0.65 | 9590117.9075
WEEK 5 | TOTAL | FUNDING ESTIMATE
DATE |  | FACTOR % | $
2012-03-26 00:00:00 | 3047480.899999999
2012-03-27 00:00:00 | 1640845.54
2012-03-28 00:00:00 | 5017592.73
2012-03-29 00:00:00 | 8038728.710000001
2012-03-30 00:00:00 | 19560314.63
WEEKLY TOTAL | 37304962.51 | 0.65 | 24248225.6315
Spreadsheet: 709466d1608312903-do-i-use-index-and-match-to-count-products-on-different-sheets-stock-check-blanks-2
Sheet: Z Aisle

 | Product code | Qty |  |  | Product code | Qty
Z1A |  |  |  | [NAME]
Z1B |  |  |  | [NAME]
Z1C |  |  |  | Z4C
Z1D |  |  |  | Z4D
Z1E |  |  |  | Z4E
Z1F |  |  |  | Z4F
Z2A |  |  |  | Z5A
[NAME] |  |  |  | Z5B
Z2C |  |  |  | Z5C
Z2D |  |  |  | Z5D
Z2E |  |  |  | Z5E
Z2F |  |  |  | Z5F
Z3A |  |  |  | Z6A
Z3B |  |  |  | Z6B
Z3C |  |  |  | Z6C
Z3D |  |  |  | [NAME]
Z3E |  |  |  | Z6E
Z3F |  |  |  | Z6F
 | Product code | Qty |  |  | Product code | Qty
Z7A |  |  |  | [NAME]
Z7B |  |  |  | Z10B
Z7C |  |  |  | Z10C
Z7D |  |  |  | Z10D
[NAME] |  |  |  | Z10E
Z7F |  |  |  | [NAME]
Z8A |  |  |  | Z11A
Z8B |  |  |  | Z11B
Z8C |  |  |  | Z11C
Z8D |  |  |  | Z11D
Z8E |  |  |  | Z11E
Z8F |  |  |  | Z11F
Z9A |  |  |  | Z12A
Z9B |  |  |  | Z12B
[NAME] |  |  |  | Z12C
Z9D |  |  |  | Z12D
Z9E |  |  |  | Z12E
Z9F |  |  |  | Z12F
Spreadsheet: 716405d1612197081-sum-values-with-criteria-sample
Sheet: PAYDAY 28th May

Week: | Hours: | Pay: | Notes: |  |  | Break Down: |  |  |  |  |  |  | WEEKLY PAY:
BASE PAY: |  | 1845.16 |  |  |  |  |  |  |  |  |  |  | 461.54
 |  |  |  |  |  | Natwest:
 |  |  |  |  |  | Entertainment:
 |  |  |  |  |  | Car:
[NAME]: |  | 0 |  |  |  | Loan:
 |  |  |  |  |  | Phone:
Est Tax: |  |  |  |  |  | Credit Improver:
Est NI: |  |  |  |  |  | Rent:
Total: |  |  |  |  |  | Credit Card:
 |  |  |  |  |  | Total:
Total Est Pay Before Tax:
Total Est Pay After Tax: |  |  |  |  |  | Monzo:
Actual Pay: |  |  |  |  |  | Predicted: |  |  | Actual:
 |  |  |  |  |  | Amount L/O |  |  | Amount L/O
Deductions: |  |  |  |  |  | Days till next pay | 28 |  | Days till next pay | 28
Rent |  | 120 |  |  |  | Budget |  |  | Budget
Fuel |  | 160
Car Insurance |  | 181.68
Phone |  | 56.45
Loan |  | 130.08
Spotify |  | 9.99
Credit Improver |  | 12
Credit Card
Other
Budget: |  | 320 |  |  |  | NI Calculator:
Total: |  |  |  |  |  | PA: | 791.99
 |  |  |  |  |  | BT - PA:
Total Est Left On 28th May:
Total Acc Left On 28th May: |  |  |  |  |  | Total:
 |  |  |  |  |  | Tax Calculator:
 |  |  |  |  |  | PA: | 950.18
 |  |  |  |  |  | BT - PA:
 |  |  |  |  |  | Est Tax:
Spreadsheet: 98967d1297775730-circular-reference-and-its-solution-excelforum-help
Sheet: Sheet1

T1 | T2 | Demand | Capacity | [NAME] (demand - capacity) | Queued vehicles
0 | 1 |  |  | 0 | 0
1 | 2 |  |  | 0 | 0
2 | 3 |  |  | 0 | 0
3 | 4 |  |  | 0 | 0
4 | 5 |  |  | 0 | 0
5 | 6 |  |  | 0 | 0
6 | 7 |  |  | 0 | 0
7 | 8 |  |  | 0 | 0
8 | 9 |  |  | 0 | 0
9 | 10 |  |  | 0 | 0
10 | 11 |  |  | 0 | 0
11 | 12 |  |  | 0 | 0
12 | 13 |  |  | 0 | 0
13 | 14 |  |  | 0 | 0
14 | 15 |  |  | 0 | 0
15 | 16 |  |  | 0 | 0
16 | 17 |  |  | 0 | 0
17 | 18 |  |  | 0 | 0
18 | 19 |  |  | 0 | 0
19 | 20 |  |  | 0 | 0
20 | 21 |  |  | 0 | 0
21 | 22 |  |  | 0 | 0
22 | 23 |  |  | 0 | 0
23 | 24 |  |  | 0 | 0
Queued vehicles = 0 if [NAME] rate is negative.
= [NAME] rate (for the first positive Queue rate value)
= Current [NAME] rate + Previous Queued vehicles (as long as their sum is positive)
Thus I used the formula, Queued vehicles = IF ([NAME] rate current + Queued vehicle previuos > 0 THEN [NAME] rate current + Queued vehicle previuos ELSE 0)
This obviously gives rise to circular reference. Its troublesome even with changing the no. of iteration and selecting manual calculations.
These values (Queued vehicles) are further used and thus make results haywired.
Spreadsheet: 267989d1380334539-create-a-searchable-excel-document-spreadsheet-example-mlcb
Sheet: search

search
99206
 | first name | last name | address | city | state | zip | phone
Spreadsheet: 49416d1248782362-horizental-to-vertical-data-arrangment-excelforumdone
Sheet: OUTPUT

Part | FPS | OEM | [NAME] | OEM2 | [NAME] | OEM4 | OEM5 | TRIDEX
135740070 |  |  |  |  |  | FBH6220
135740080 |  |  |  | 510222 |  | FBH6221
135740090 |  |  |  | 510224 | LH0961 | FBH6223 | PHA117
135740120 |  |  |  |  |  | FBH6224
135740140 |  |  |  | 510237 | LH3287 | PHA305
and so on
Spreadsheet: fa485ff0-d7a9-4d00-8aae-43607c7064d9
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
FMIDZ | Test | FMIDZ | [NAME] (Versed), serum | [NAME] (Versed) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Submit only 1 of the following specimens:  Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL sodium heparin plasma refrigerated in a plastic vial.  Serum Draw blood in a plain red-top tube(s), serum gel tube is not acceptable. Spin down and send 2 mL of serum refrigerated in a plastic vial. | 0.3 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | [NAME]: 50 - 600 ng/mL   Test Performed By:	Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 80154 |  |  |  |  | Medtox Laboratories, Inc.
FMIDZ | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FMIDZ | Result | Z1145 | [NAME] (Versed) | [NAME] (Versed) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 67293d1267897097-select-item-thru-combobox-to-edit-userform-data-input-data
Sheet: Sheet1

First Name | Last Name | Savings No | Loan No | Dt of Open
T | SRINIVASA RAO | 1 | 111111 | 2009-01-01 00:00:00
T | SITA RAVAMMA | 2 | 414141 | 2009-02-10 00:00:00
TDVRS | SASTRY | 3 | 131313 | 2009-04-06 00:00:00
TVA | SIVA KANTH | 4 | 363636 | 2010-09-01 00:00:00
TVRM | JAYAPRADA | 5 | 147 | 2009-08-08 00:00:00
GK | RAGHAVA | 6 | 852 | 1996-02-04 00:00:00
P | [NAME] | 7 | 654 | 2009-10-04 00:00:00
G | MANJ | 8 | 214 | 2009-09-08 00:00:00
D | KAPADIA | 9 | 145 | 1963-07-14 00:00:00
J | Bhanu | 10 | 65 | 1991-03-06 00:00:00
J | KM | 11 | 1 | 1988-06-03 00:00:00
M | MNJ | 12 | 4 | 1988-06-03 00:00:00
T | JAYAPRADA | 13 | 4 | 1948-07-14 00:00:00
T | MANJULA | 14 | 45 | 1963-07-14 00:00:00
T | ANUSHKA | 15 | 369 | 2009-02-28 00:00:00
PRK | RAO | 16 | 741 | 1947-08-15 00:00:00
Spreadsheet: 197524d1354409173-randomizing-variables-in-lists-pokerdrills
Sheet: Sheet1

 | [NAME]
 |  |  | Fish Stealing |  |  |  |  |  |  | Isolating
 |  |  | F2ST+F2CB-1/2(Donk+CR) |  | F2 STEAL | F2CB | 1/2(Donk+CR) |  |  | Pos#+3B(oop)+Limper |  | Pos# | 3B% (OOP) | [NAME]
 |  |  |  |  | 44 | 47 | 16 |  |  |  |  | IP vs 1 opponent | 19 | 80
 |  |  | 36% <150 |  |  |  |  |  |  | 3B% (OOP) -[a.b,c] |  |  |  | 65
 |  |  | 50% 150-169 |  |  |  |  |  |  | a) <15
 |  |  | 75% 170+ |  |  |  |  |  |  | b) 16-20
 |  |  |  |  |  |  |  |  |  | c) 21+
 |  |  |  |  |  |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  |  |  | Limper stats
 |  |  | Reg Stealing |  |  |  |  |  |  | F2 iso (-10) + F2 Cbet
 |  |  |  |  |  |  |  |  |  | (-10) is due to SB freq
 |  |  | BTN vs Blinds (F2ST) | SB vs BB (F2ST)
 |  |  | <139 - 29% | <59 - 20% |  |  |  |  |  | a) 60+
 |  |  | 140-159 - 43% | 60-64 - 25% |  |  |  |  |  | b) 60-
 |  |  | 160-169 - 56% | 65-69 - 29% |  |  |  |  |  | a) 140+
 |  |  | >170 - 100% | 70-74 - 43% |  |  |  |  |  | b) 140-
 |  |  |  | >75 - 100%
 |  |  | 3-Betting (4 & 5)
 |  |  | 1/ Sample |  | Low |  |  | 1K+ |  |  |  | 3K+
 |  |  | 2/ [NAME]
 |  |  | 3B-5B ranges (Villain's 4B) | --> If sample low
 |  |  | Vs EP/MP | Use assumption
 |  |  | <3.4 - 1% (KK+) | [NAME] use 2.5% range
 |  |  | 3.5 - 4.4 - 2.5% (QQ+,AK)
 |  |  | >4.5 - 3% (JJ+,AK [JJ vs MP])
 |  |  | Vs other Pos (count it) | --> If sample low
 |  |  | <3 - 1% (KK+) | Use assumption
 |  |  | 3.1-3.9 - 2.5% (QQ+,AK) | [NAME] use 3% range
 |  |  | 4-4.9 - 3% (JJ+,AK)
 |  |  | 5-6.9 - 3.5% (TT+,AK)
 |  |  | >7 - 4.5% (TT+,AQ+)
Spreadsheet: 6762ae8f-2a3c-472c-8087-2d01cd94bbcd
Sheet: Income Statement

Netflix, Inc.
Consolidated Statements of Operations
(unaudited)
(in thousands, except per share data)
 |  |  |  |  | Three Months Ended |  |  |  | Twelve Months Ended | Three Months Ended |  |  |  | Twelve Months Ended | Three Months Ended
 |  |  |  |  | March 31, | June 30, | September 30, | December 31, | December 31, | March 31, | June 30, | September 30, | December 31, | December 31, | March 31,
 |  |  |  |  | 2010 | 2010 | 2010 | 2010 | 2010 | 2011 | 2011 | 2011 | 2011 | 2011 | 2012
Revenues |  |  |  |  | 493665 | 519819 | 553219 | 595922 | 2162625 | 718553 | 788610 | 821839 | 875575 |  | 869791
Cost of revenues:
 | Subscription |  |  |  | 259560 | 265387 | 292406 | 336756 | 1154109 | 376992 | 428203 | 471823 | 512578 |  | 564015
 | Fulfillment expenses |  |  |  | 47602 | 49547 | 52063 | 54034 | 203246 | 61159 | 61775 | 64794 | 62577 |  | 59918
 |  | Total cost of revenues |  |  | 307162 | 314934 | 344469 | 390790 | 1357355 | 438151 | 489978 | 536617
Gross profit |  |  |  |  | 186503 | 204885 | 208750 | 205132 | 805270 | 280402 | 298632 | 285222
Operating expenses:
 | Marketing |  |  |  | 75219 | 74533 | 81238 | 62849 | 293839 | 104259 | 94983 | 89108 | 114288 |  | 135900
 | Technology and development |  |  |  | 37399 | 37863 | 42108 | 45959 | 163329 | 50905 | 57865 | 69480 | 80783 |  | 82801
 | General and administrative |  |  |  | 15540 | 15147 | 15903 | 17871 | 64461 | 22998 | 30670 | 29792 | 34477 |  | 29092
 | Legal settlement |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9000 |  | 0
 |  | Total operating expenses |  |  | 128158 | 127543 | 139249 | 126679 | 521629 | 178162 | 183518 | 188380
Operating income (loss) |  |  |  |  | 58345 | 77342 | 69501 | 78453 | 283641 | 102240 | 115114 | 96842
Other income (expense):
 | Interest expense |  |  |  | -4959 | -4893 | -4945 | -4832 |  | -4865 | -5303 | -4915 | -4942 |  | -4974
 | Interest and other income (expense) |  |  |  | 972 | 921 | 853 | 938 |  | 865 | 1013 | 1696 | -95 |  | -116
Income (loss) before income taxes |  |  |  |  | 54358 | 73370 | 65409 | 74559 | 267696 | 98240 | 110824 | 93623
Provision (benefit) for income taxes |  |  |  |  | 22086 | 29851 | 27442 | 27464 | 106843 | 38007 | 42610 | 31163 | 21616 |  | -2441
Net income (loss) |  |  |  |  | 32272 | 43519 | 37967 | 47095 | 160853 | 60233 | 68214 | 62460
Net income (loss) per share:
 | Basic |  |  |  | 0.6099298822551076 | 0.8291544411843158 | 0.7281462161021826 | 0.8956146356306101 | 3.062175179424699 | 1.141663033795182 | 1.300057175528874 | 1.19 | 0.66 | 4.28 | -0.08
 | Diluted |  |  |  | 0.5891738931994523 | 0.8011008025918562 | 0.7039921381023901 | 0.8690076392220542 | 2.962083824395993 | 1.110367584706706 | 1.26 | 1.16 | 0.64 | 4.16 | -0.08
Weighted average common shares outstanding:
 | Basic |  |  |  | 52911 | 52486 | 52142 | 52584 | 52529 | 52759 | 52470 | 52569 | 53582 | 52847 | 55456
 | Diluted |  |  |  | 54775 | 54324 | 53931 | 54194 | 54304 | 54246 | 53909 | 53870 | 55439 | 54369 | 55456
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Financial w-o AA

 | Financial Gas
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other |  |  |  |  | Quigley, [NAME] | ASSOCIATE | ENA FINANCIAL
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  |  |  |  |  | Maggi, [NAME] | DIRECTOR | ENA FINANCIAL
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | May, [NAME] | DIRECTOR | ENA FINANCIAL
ENAOUTSV | Outside Services |  |  |  |  |  |  |  |  |  |  |  | Griffith, [NAME] | MANAGER | ENA FINANCIAL
ENASUPP | Supplies Expense |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | VICE PRESIDENT | ENA FINANCIAL
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000 |  |  |  | Zipper, [NAME] | VICE PRESIDENT | ENA FINANCIAL
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0 |  |  | [NAME], [NAME] ([NAME]) | Specialist | ENA FINANCIAL
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 1
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 1
 |  |  |  |  |  |  |  | Director | 143000 | 2
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 2
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 162026d1339696280-having-a-row-of-information-show-if-using-a-dropdown-list-of-names-list-template
Sheet: Master List

Name | Position | Salary | Hours per week
[NAME] | teacher | 25 | 8
[NAME] | admin | 50 | 35
[NAME] | staff | 17 | 35
Adam | teacher | 25 | 8
[NAME] | teacher | 25 | 8
Maria | admin | 50 | 35
[NAME] | staff | 17 | 35
[NAME] | teacher | 25 | 8
Spreadsheet: sally_beck__33912__Global Hot List 0118
Sheet: Hotlist - Completed

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 |  |  |  |  |  |  |  |  |  |  |  | 1Q01 DEALS COMPLETED
 |  | Crude & Products
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | SUBTOTAL
 |  |  |  |  |  |  |  | SUBTOTAL
 |  | Coal Origination & Finance
 |  | Deal |  | Value |  |  |  | Global Risk Markets
 |  |  |  |  |  |  |  | Deal |  | Value
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  |  |  |  |  |  |  | TOTAL DEALS COMPLETED
Spreadsheet: 818176d1676633443-check-equal-values-in-range-array-check_values
Sheet: Feuil1

A | B |  | expected result
a test | a test
a test | a test |  | A
a test | a test |  | ALL EQUAL |  |  |  |  | Same
a test | a test |  |  |  |  |  | B | Different
a test | a test |  | B
a test | a test |  | SOME DIFFERENTS
a test | a test
a test | b test
a test | a test
a test | a test
a test | c test
a test | a test
a test | a test
Spreadsheet: 52089d1251802989-90-day-average-that-changes-90d-average
Sheet: Overview

# | Raider | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | 90 Day Average
1 | Addar |  | 0.8 | 0.9231 | 1 | 0.8571428571428571 | 0.8461538461538461
2 | [NAME] |  |  |  |  |  | 1
3 | Alfadirr | 1 | 1 | 1 | 1 | 1 | 1
4 | Ameron |  |  |  | 1 | 0.8571428571428571 | 0.384615384615385
5 | [NAME] |  |  |  |  | 1 | 1
6 | Blazingsoul |  | 0.9167 | 0.8462 | 0.75 | 0.6428571428571429 | 0.6153846153846154
7 | [NAME] | 1 | 1 | 1 | 1 | 0.9285714285714286 | 1
8 | Caliwrap |  |  | 0 | 0.25 | 0.1428571428571428 | 0
9 | Celestad | 0.8462 | 1 | 1 | 1 | 1 | 0.9090909090909091
10 | Cybille | 1 | 1 | 1 | 1 | 1 | 1
11 | [NAME] |  |  |  | 0.75 | 1 | 0.6153846153846154
12 | Energizer |  |  |  |  |  | 0.7
13 | Enuwy |  |  | 0.75 | 0.9167 | 0.1428571428571428 | 0
14 | Findom |  |  |  |  |  | 1
15 | Gigime |  |  |  |  | 0 | 0.6923076923076923
16 | Glarbal |  |  |  |  |  | 1
17 | Invisibob |  |  |  |  |  | 1
18 | Joria |  |  |  |  |  | 0.8
19 | Kas |  |  |  |  | 1 | 0.3076923076923077
20 | Katarayea |  |  |  |  | 1 | 1
21 | Kazenomiko |  |  |  |  |  | 1
22 | Kortezz |  |  |  |  |  | 0.6666666666666666
23 | [NAME] |  |  |  | 0.6667 | 0.2857142857142857 | 0.6923076923076923
24 | Kirune |  |  |  |  | 1 | 0.9230769230769231
25 | [NAME] |  |  |  |  | 1 | 1
26 | Parapet |  |  |  |  | 1 | 1
27 | Paximus |  |  |  |  | 1 | 1
28 | Rutan | 1 | 0.75 | 0.6923 | 0.75 | 0.8571428571428571 | 1
29 | Shadowgnome |  |  |  |  |  | 1
30 | Shum |  |  |  | 1 | 1 | 1
31 | Starck |  |  |  |  | 0.6666666666666666 | 0.6153846153846154
32 | Toosoldier |  |  |  |  |  | 1
33 | Varack |  |  |  |  | 0.75 | 0.5384615384615384
34 | Yme | 0.6923 | 0.5833 | 0.7692 | 0.8333 | 0.7857142857142857 | 0.8461538461538461
35 | Zinthous |  |  |  |  |  | 1
Spreadsheet: 101260d1299418736-index-match-match-formula-expense-log
Sheet: Expense Log

 |  | 2011-03-06 00:00:00 |  | [NAME]
Code |  |  |  |  |  |  |  | PMT |  | Date Pd. | Method |  |  |  | Billed |  | Paid | Due |  | Food
 |  |  |  |  |  |  |  | 7.5 |  | 2011-02-10 00:00:00 | Cash
 |  |  |  |  |  |  |  | 11 |  | 2011-02-11 00:00:00 | Visa
 |  |  |  |  |  |  |  | 11 |  | 2011-02-11 00:00:00 | Visa
 |  |  |  |  |  |  |  | 6 |  | 2011-02-12 00:00:00 | Visa
 |  |  |  |  |  |  |  | 8 |  | 2011-03-03 00:00:00 | Visa
 |  |  |  |  |  |  |  | 18 |  | 2011-02-14 00:00:00 | Visa
 |  |  |  |  |  |  |  | 3 |  | 2011-02-15 00:00:00 | Cash
 |  |  |  |  |  |  |  | 13 |  | 2011-02-16 00:00:00 | Visa
 |  |  |  |  |  |  |  | 205.72 |  | 2011-02-17 00:00:00
 |  |  |  |  |  |  |  | 92.7 |  | 2011-02-17 00:00:00 | Check
 |  |  |  |  |  |  |  | 102.35 |  | 2011-02-17 00:00:00
 |  |  |  |  |  |  |  | 23 |  | 2011-02-18 00:00:00 | Visa | [NAME] |  |  | Jan-00 | Feb-11 | Feb-11
 |  |  |  |  |  |  |  | 6.47 |  | 2011-02-19 00:00:00 | Visa |  |  |  | Jan-00 | Feb-11 | Feb-11
 |  |  |  |  |  |  |  | 5 |  | 2011-02-20 00:00:00 | Cash | [NAME] |  |  | Jan-00 | Feb-11 | Feb-11
 |  |  |  |  |  |  |  | 8 |  | 2011-02-21 00:00:00 | Visa | Fish |  |  | Jan-00 | Feb-11 | Feb-11
 |  |  |  |  |  |  |  | 5 |  | 2011-02-23 00:00:00 | Cash | Carrie |  |  | Jan-00 | Feb-11 | Feb-11
 |  |  |  |  |  |  |  | 5 |  | 2011-03-04 00:00:00 | Cash | Tracie |  |  | Jan-00 | Mar-11 | Mar-11
 |  |  |  |  |  |  |  | 10.88 |  | 2011-02-24 00:00:00 | Cash | Carrie |  |  | Jan-00 | Feb-11 | Feb-11
 |  |  |  |  |  |  |  | 9 |  | 2011-02-24 00:00:00 | Cash | [NAME] |  |  | Jan-00 | Feb-11 | Feb-11
 |  |  |  |  |  |  |  | 15 |  | 2011-02-24 00:00:00 | Cash | [NAME] |  |  | Jan-00 | Feb-11 | Feb-11
 |  |  |  |  |  |  |  | 3.78 |  | 2011-02-24 00:00:00 | Cash |  |  |  | Jan-00 | Feb-11 | Feb-11
 |  |  |  |  |  |  |  | 16.22 |  | 2011-02-25 00:00:00 | Cash
 |  |  |  |  |  |  |  | 20 |  | 2011-02-22 00:00:00 | Cash | [NAME]
 |  |  |  |  |  |  |  | 15 |  | 2011-02-26 00:00:00 | Cash | E
 |  |  |  |  |  |  |  | 5.15 |  | 2011-02-27 00:00:00 | Cash
 |  |  |  |  |  |  |  | 1.29 |  | 2011-02-28 00:00:00 | Cash
 |  |  |  |  |  |  |  | 9 |  | 2011-03-01 00:00:00 | Cash | Fish
 |  |  |  |  |  |  |  | 12 |  | 2011-02-25 00:00:00 | Cash | [NAME]
 |  |  |  |  |  |  |  | 14 |  | 2011-03-02 00:00:00 | Visa | Carrie
 |  |  |  |  |  |  |  | 11 |  | 2011-03-03 00:00:00 | Visa | [NAME]
Spreadsheet: 189224d1351120261-highlight-group-of-dates-if-dates-match-list-of-other-dates-highlightcells
Sheet: Sheet1

Dates |  | Highlighted Dates
2012-01-01 00:00:00 |  | 2012-01-01 00:00:00 | <this date should be highlighted
2012-01-02 00:00:00 |  | 2012-01-02 00:00:00 | <this date should be highlighted
2012-01-26 00:00:00 |  | 2012-04-03 00:00:00
2012-04-06 00:00:00 |  | 2012-12-26 00:00:00 | <this date should be highlighted
2012-04-07 00:00:00 |  | 2013-01-01 00:00:00 | <this date should be highlighted
2012-04-08 00:00:00 |  | 2013-04-02 00:00:00
2012-04-09 00:00:00 |  | 2013-06-10 00:00:00 | <this date should be highlighted
2012-04-25 00:00:00 |  | 2013-08-05 00:00:00 | <this date should be highlighted
2012-06-11 00:00:00
2012-08-06 00:00:00
2012-10-01 00:00:00
2012-12-25 00:00:00
2012-12-26 00:00:00
2013-01-01 00:00:00
2013-01-28 00:00:00
2013-03-29 00:00:00
2013-03-30 00:00:00
2013-03-31 00:00:00
2013-04-01 00:00:00
2013-04-25 00:00:00
2013-06-10 00:00:00
2013-08-05 00:00:00
2013-10-07 00:00:00
2013-12-25 00:00:00
2013-12-26 00:00:00
2014-01-01 00:00:00
2014-01-27 00:00:00
2014-04-18 00:00:00
2014-04-19 00:00:00
2014-04-20 00:00:00
2014-04-21 00:00:00
2014-04-25 00:00:00
2014-06-09 00:00:00
2014-08-04 00:00:00
2014-10-06 00:00:00
2014-12-25 00:00:00
2014-12-26 00:00:00