tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 842080d1694151769-alternative-to-indirect-for-referencing-named-ranges-sample-excel-1
Sheet: Comm

Headcount |  | Basic | Comm
16 | 144 | 1200 | 0
145 | 224 | 1300 | 0.5
225 | 304 | 1300 | 1
305 | 384 | 1400 | 1.25
385 | 464 | 1400 | 1.5
465 | 544 | 1500 | 1.75
545 | 624 | 1500 | 2
625 | 704 | 1600 | 2.25
705 | 784 | 1600 | 2.5
785 | 864 | 1700 | 2.75
865 | 944 | 1700 | 3
945 | 1024 | 1800 | 3.25
Spreadsheet: 61155d1261934585-excel-2007-dropdown-sheet-selection-drop-down-test
Sheet: a

a | b | c | d
175.98 | 180.16 | 166.11 | 175.12 |  |  | Average
175.07 | 178.92 | 170.35 | 170.89
171.24 | 173.4 | 162.08 | 163.09
163.07 | 168.2 | 162.75 | 165.58
164.92 | 175.24 | 164.22 | 173.29
173.31 | 179.76 | 170.22 | 174.22
173.96 | 174.4 | 164.24 | 169.89
164.58 | 170.18 | 163.62 | 167.75
167.48 | 170.85 | 156.45 | 161.54
161.6 | 163.76 | 156.27 | 160.98
160.75 | 166.3 | 159.29 | 163.97
163.96 | 165.88 | 152.96 | 154.39
154.37 | 159.85 | 148.2 | 159.55
159.66 | 160.18 | 153.47 | 157.84
157.83 | 158.6 | 151.53 | 157.35
157.35 | 171.84 | 157.23 | 170.83
170.84 | 177.68 | 169.02 | 170.71
170.66 | 171.57 | 165.39 | 169.64
Spreadsheet: 191565d1352145089-duplicate-data-show-as-one-with-unique-id-training-registration-db
Sheet: Participant

ID | Date | Event | Component | Name | Surname | Position | Organization | Ethnicity | M/F | Contact
1 | 2011-03-06 00:00:00 | Workshop | 4.1 USAID Forward | Arian | Veliu | Instructors | MoJ | Others | Male
2 |  |  |  | Arian | Veliu |  | MoJ | ALB | Male
3 |  |  |  | Bujar | Dervari
4 | 2012-09-11 00:00:00 | Training | 1.1 Kosovo Judicial Council | Arian | Veliu | Executive Branch | MoJ | ALB | Male
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
Spreadsheet: 708451d1607845798-formula-for-combination-of-multiple-if-conditions-testbook
Sheet: Sheet1

Productivity (A ranging 0 - 35) | Quality (B ranging 0 - 35) | Others (C Ranging 0 - 8) | Total (A+B+C) | Score |  |  | Conditions:
32 | 34 | 8 |  | 7
30 | 35 | 7 |  | 6
30 | 31 | 1 |  | 5
25 | 23 | 5 |  | 4 |  |  | If D >= 74, E = 7
22 | 21 | 1 |  | 3 |  |  | if D >= 68, and <74, E = 6
19 | 23 | 5 |  | 3 |  |  | if D>=60 and <68, E = 5
23 | 19 | 5 |  | 3 |  |  | if D >=49 and <60, E=4
16 | 25 | 2 |  | 2 |  |  | if D >=44 and <49 or A <20 or B < 20, E=3 | Check
14 | 27 | 4 |  | 2 |  |  | if D >=30 and <44 or A <15 or B < 15, E=2 | Check
12 | 20 | 8 |  | 1 |  |  | if D < 30 or A <15 or B < 15, E=1
15 | 15 | 0 |  | 2
Spreadsheet: 606030d1547466654-if-and-criteria-formula-if-and-formula-finished
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 1 | 4
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 1
Spreadsheet: 234430d1368103776-conditional-formatting-time-example
Sheet: Sheet1

00:01:00
01:01:00
02:01:00
03:01:00
04:01:00
05:01:00
06:01:00
07:01:00
08:01:00
09:01:00
10:01:00
11:01:00
12:01:00
13:01:00
14:01:00
15:01:00
16:01:00
17:01:00
18:01:00
19:01:00
20:01:00
21:01:00
22:01:00
23:01:00
Spreadsheet: 62999d1263980413-amendments-in-function-convert-digits-to-words-sample-file
Sheet: Sheet1

 |  |  | 12 |  | Twelve Only
 |  |  | 48 |  | Forty Eight Only
 |  |  | 4 |  | Four Only
 |  |  | 22 |  | Twenty Two Only
 |  |  | 78 |  | Seventy Eight Only
 |  |  | 99 |  | Ninety Nine Only
 |  |  | 48 |  | Forty Eight Only
 |  |  | 87 |  | Eighty Seven Only
 |  |  | 799 |  | Seven Hundred Ninety Nine Only
 |  |  | 88 |  | Eighty Eight Only
 |  |  | 212 |  | Two Hundred Twelve Only
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 15c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | - | 23095 | - | 24714
Index | 167144 | 57981 | 82885 | 24881
Asia | - | 1742 | 20 | 295
Europe | 88134 | 15477 | 37093 | 4939
North America | 78745 | 39594 | 45487 | 19214
Other | 265 | 1168 | 285 | 433
OTHER* | 11233 | 45186 | 5339 | 13620
TOTAL | 178377 | 126262 | 88224 | 63215
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 709747d1608541784-help-with-if-and-formula-sample
Sheet: Sheet1

 | Totals
 | Kills | Damage | Results (WIN OR LOSE)
Team One | 5 | 600 |  | (should be win, more kills)
Team Two | 3 | 800
 | Totals
 | Kills | Damage | Results (WIN OR LOSE)
Team One | 5 | 600
Team Two | 5 | 800 |  | (should be win, equal on kills but more damage)
Spreadsheet: 865103d1712166505-count-unique-values-for-a-group-of-criteria-forum-exampleapr-3
Sheet: Sheet1

Date | Value |  | Date | No. Unique values
2024-01-01 00:00:00 | 10 |  | 2024-01-01 00:00:00 | 3
2024-01-01 00:00:00 | 11 |  | 2024-02-01 00:00:00 | 3
2024-01-01 00:00:00 | 13 |  | 2024-03-01 00:00:00 | 2
2024-02-01 00:00:00 | 14 |  | 2024-04-01 00:00:00 | 1
2024-02-01 00:00:00 | 15
2024-02-01 00:00:00 | 16
2024-03-01 00:00:00 | 11
2024-03-01 00:00:00 | 11
2024-03-01 00:00:00 | 12
2024-04-01 00:00:00 | 22
2024-04-01 00:00:00 | 22
Spreadsheet: 102555d1300474912-index-match-returning-a-0-that-is-causing-problems-ncaa-bracket-and-squares-test
Sheet: Square Entry

 |  | FIRST ALPHABETICAL TEAM
 |  | 3 | pd | 2 | pd | 5 | pd | 7 | pd | 0 | pd | 9 | pd | 8 | pd | 6 | pd | 4 | pd | 1 | pd
SECOND ALPHABETICAL TEAM | 4 | [NAME] and [NAME] | a | [NAME] | a | [NAME] |  | [NAME] |  | [NAME] | a | [NAME] | a | Teri & Nick Goldammer |  | [NAME] |  | [NAME] | a | [NAME] |  |  | 8 |  | 390 | 2007-02-24 00:00:00
 | 9 | [NAME] | a | [NAME] | a | Robyn Snider | a | [NAME] | a | [NAME] |  | [NAME] |  | Eric & Robin |  | Junaid |  | [NAME] |  | [NAME] |  |  | 9 |  | 305 | 2007-02-25 00:00:00
 | 0 | [NAME] | a | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | a | Brad S & Cathy B | a | [NAME] |  | [NAME] |  | [NAME] | a | [NAME] |  |  | 9 |  | 260
 | 5 | [NAME] | a | [NAME] |  | [NAME] |  | [NAME] |  | Bill & Debbie Bell | a | [NAME] |  | [NAME] | a | [NAME] | a | Sue & Mike Riggs |  | Melinda & Jason |  |  | 8 |  | 65
 | 2 | [NAME] |  | [NAME] |  | Trevor Recchi | a | [NAME] |  | [NAME] |  | [NAME] | a | [NAME] |  | Parker | a | Visions Catering |  | [NAME] |  |  | 9 |  | 1240 | 2007-03-03 00:00:00
 | 7 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | a | Mesteller Yoder |  | Julie & Joe Lang |  | [NAME] | a | [NAME] |  | [NAME] |  | [NAME] |  |  | 10 |  | 760 | 2007-03-05 00:00:00
 | 6 | Jen Tanner |  | [NAME] | a | [NAME] | a | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | a | [NAME] |  | [NAME] |  |  | 10 |  | 715 | 2007-03-07 00:00:00
 | 1 | [NAME] |  | [NAME] |  | Hines |  | [NAME] | a | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | a |  | 10 |  | 1170 | 2007-03-10 00:00:00
 | 3 | [NAME] |  | [NAME] | a | [NAME] | a | [NAME] |  | Amy & Mike Turner | a | [NAME] |  | [NAME] ([NAME]) |  | [NAME] | a | [NAME] | a | Ryan & Dannie |  |  | 9 |  | 715 | 2007-03-13 00:00:00
 | 8 | [NAME] |  | [NAME] |  | [NAME] |  | Patrick & Lisa |  | Kay & Todd C |  | Frank & Julie Grubb |  | [NAME] |  | [NAME] | a | [NAME] |  | [NAME] |  |  | 10
 | 33 |  | 4 |  | 4 |  | 4 |  | 3 |  | 4 |  | 3 |  | 2 |  | 5 |  | 3 |  | 1
 | 100 | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10
 |  | [NAME] with a Lower Case "a".
 | [NAME] Bar & Grill 2nd NCAA Invitational
 |  | 100 Entries |  | 70 | Per Square: |  |  | 33 Entries Paid |  | 2310 |  |  |  | 600 | Won
 |  | All Sold |  | 100 | PAY-OUT ON FINAL SCORE EACH GAME. |  |  |  |  |  |  | PERSON HAS SAME NUMBERS FOR ENTIRE TOURNAMENT.
 |  |  |  | 200 | PAY-OUT for SEMI FINALS and FINAL GAME. |  |  |  |  |  |  | GAME LISTINGS WILL BE POSTED PRIOR TO EACH ROUND.
Spreadsheet: 3084a24f-bd6f-4d21-adaa-3c98c3ffe651
Sheet: Sheet1

PCTRC INPATIENT BUDGET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
PCTRC Classification Guide:
TYPE A = Research purposes only; Studies initiated by the investigator:  PCTRC supported
TYPE B = Diagnostic/treatment for medical condition:  Participation in research:  Third party
TYPE D = Subjects involved in industry initiated study; Industry supported
Total No.of Patients to be Studied during this Year:
No. of Inpatient Days Per Patient Per Year: |  |  |  | Type A |  | Type B |  | Type D
Total Days Per Year (# Pts x Days Per Pt): |  |  |  | Type A | 0 | Type B | 0 | Type D | 0
Please indicate below only ancillaries that you are requesting the PCTRC to pay for:
Please list each test requested on its own line.  The CDM code can be found on your PCAR-Fiscal review form.
 |  |  |  |  | FOR PCTRC USE ONLY
Testing |  |  | CHP CDM Code/Source (Esoterix, Heinz lab etc.) | Number of Specimens | Hospital Charge/Test |  | Research Rate/Test | Total
Laboratory:
Radiology/Nuclear Medicine:
Pharmacy:
Medical Supplies:
Special Studies:
TOTAL INPATIENT BUDGET REQUESTED: |  |  |  |  |  |  |  | 0
Spreadsheet: 0a4d5c46-56eb-48b6-bfcb-3b0f6b44c822
Sheet: BS

X | Dell Incorporated
 | Balance Sheet
 | FY Ended Feb. 3
 | $ in Millions
 |  | 2008 |  |  |  |  | 2013E | 2014E | 2015E | 2016E | 2017E
 | Current Assets:
 | Cash & Cash Equivalents | 7764 | 8352 | 10635 | 13913 | 13852
 | Short-term Investments | 208 | 740 | 373 | 452 | 966 |  | 548 | 548 | 548 | 548
 | Accounts Receivable | 5961 | 4731 | 5837 | 6493 | 6476 | 6476 | 6476 | 6476 | 6476 | 6476
 | Financing Receivables | 1732 | 1712 | 2706 | 3643 | 3327 | 3327 | 3327 | 3327 | 3327 | 3327
 | Inventories | 1180 | 867 | 1051 | 1301 | 1404 | 1500 | 1600 | 1700 | 1800 | 1900
 | Other Current Assets | 3035 | 3749 | 3643 | 3219 | 3423 | 3423 | 3423 | 3423 | 3423 | 3423
 | Total Current Assets
 | PP&E | 2668 | 2277 | 2181 | 1953 | 2124
 | Investments | 1560 | 454 | 781 | 704 | 3404 |  | 1381 | 1381 | 1381 | 1381
 | LT Financing Receivables | 407 | 500 | 332 | 799 | 1372 | 1400 | 1500 | 1500 | 1550 | 1550
 | Goodwill | 1648 | 1737 | 4074 | 4365 | 5838 | 6000 | 6000 | 6000 | 6000 | 6000
 | Intangibles | 780 | 724 | 1694 | 1495 | 1857 | 1857 | 1857 | 1857 | 1857 | 1857
 | Other Non-current Assets | 618 | 657 | 345 | 262 | 490 | 500 | 500 | 500 | 500 | 500
 | Total Assets
 | Current Liabilities:
 | Short-Term Debt | 225 | 113 | 663 | 851 | 2867 | 2867 | 2867 | 2867 | 2867 | 2867
 | Accounts Payable | 11492 | 8309 | 11373 | 11293 | 11656 | 11700 | 11800 | 12000 | 12200 | 12300
 | Accrued and Other | 4323 | 3736 | 3884 | 4181 | 3934 | 4000 | 4100 | 4100 | 4200 | 4200
 | ST Deferred Revenue | 2486 | 2701 | 3040 | 3158 | 3544 | 3544 | 3544 | 3700 | 3700 | 3700
 | Total Current Liabilities
 | LT Debt | 362 | 1898 | 3417 | 5146 | 6387 | 6387 | 6387 | 6387 | 6387 | 6387
 | LT Deferred Revenue | 2774 | 3000 | 3029 | 3518 | 3836 | 4000 | 4100 | 4200 | 4300 | 4300
 | Other Non-current Liabilities | 2070 | 2472 | 2605 | 2686 | 3392 | 3300 | 3300 | 3300 | 3300 | 3300
 | Total Liabilities
 | Redeemable Common Stock | 94 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Common Stock | 10589 | 11189 | 11472 | 11797 | 12187 | 10906 | 12790 | 13822 | 15841 | 18358
 | Treasury Stock | -25037 | -27904 | -27904 | -28704 | -31445
 | [NAME] | 18199 | 20677 | 22110 | 24744 | 28236
 | AOCI | -16 | 309 | -37 | -71 | -61 | -61 | -61 | -61 | -61 | -61
 | Total Shareholders' Equity | 3735 | 4271 | 5641 | 7766
 | Total L + SE
 | Stock Price (Dec. 31) | 10.08 | 14.13 | 13.34 | 14.4 | 10.14
 | Total Shares (millions)
 | Market Cap ($ millions)
 | Debt to Capital Ratio
Spreadsheet: 4d4755bd-88b0-4d7c-a1a4-14718a2ca645
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
MLHMS | Test | MLHMS | MLH1 Mutation Screen | MLH1 Mutation Screen | Polymerase Chain Reaction (PCR) Followed by DNA Sequence Analysis and Gene Dosage Analysis by [NAME] (MLPA) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant  [NAME]: 3 mL  Collection Instructions:	 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. [NAME] (Supply T519) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Friday; 10 a.m. | 14 days | 20 days |  | Profile |  |  |  |  | Rochester
MLHMS | [NAME] | VARIES | Varies |  |  |  | Ambient
MLHMS | Result | 17327 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
MLHMS | Result | 17329 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38536-9
MLHMS | Result | 17330 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
MLHMS | Result | 17328 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MLHMS | Result | 17331 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MLHMS | Result | 17323 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
MLHMS | Result | 17325 | Source | Source | Alphanumeric
MLHMS | Result | 17332 | Reviewed By: | Reviewed By: | Alphanumeric
MLHMS | Result | 17333 | Release Date | Release Date | Alphanumeric
MLHMS | Billing Component | MLHMS |  | MLH1 GENE DUP/DELETE VARIANT |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81294
MLHMS | Billing Component | MLHMS |  | MLH1 GENE FULL SEQ |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81292
Spreadsheet: 0604b1a6-1cd7-4c00-ad7e-e51dc28c46df
Sheet: Sheet1

วิทยาลัยเทคนิคดอนเมือง        แผนกวิชา ช่างยนต์ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
ระดับ ปวส. 2   กลุ่ม1ครูที่ปรึกษานาง [NAME] 1   ปีการศึกษา2555
วิทยาลัยเทคนิคดอนเมือง        แผนกวิชา ยานยนต์    ปีการศึกษา 2555
ระดับ ปวช. 1     กลุ่ม 1        ครูที่ปรึกษา นาย ประเสริฐ   ทองรอด        ภาคเรียนที่ 1/2555
เลขที่ | รหัสนักศึกษา | ชื่อ - สกุล |  |  | หมายเหตุ
1 | 5431010001 | นาย | นัฐพงษ์ | ร่วมรักษ์
2 | 5431010002 | นาย | ศุภกฤต | วงศ์สาร
3 | 5431010003 | นาย | ฉัตรชัย | สินสมุทร
4 | 5431010004 | นาย | วุฒิพงษ์ | ทรัพย์ถนอม
5 | 5431010005 | นาย | ภาณุวัฒน์ | สำลีม่วง
6 | 5431010006 | นาย | วีระพงษ์ | พันธวารี
7 | 5431010007 | นาย | กนกศักดิ์ | คำมี
8 | 5431010008 | นาย | สุทธิพงศ์ | เสพสุข
9 | 5431010009 | นาย | เจตน์จำรูญ | จิตร์กลาง
10 | 5431010010 | นาย | ศราวุธ | บุญเริ่ม
11 | 5431010012 | นาย | สรายุทธ | ทองประศรี
12 | 5431010013 | นาย | ถิรภาพ | เสนฤทธิ์
13 | 5431010014 | นาย | กิตติศัพท์ | พูลสาย
14 | 5431010015 | นาย | ภูมิวัฒน์ | เงินลา
15 | 5431010017 | นาย | สมมาตร | [NAME]
16 | 5431010018 | นาย | ยศวรรธน์ | อาจหาญ
17 | 5431010019 | นาย | วิทวัส | ราชไชย
18 | 5431010020 | นาย | อนุรักษ์ | นนท์ปู่
19 | 5431010021 | นาย | ชยุตพล | แซ่ลือ
20 | 5431010036 | นาย | สุทัช | บุญประสิทธิ์
21 | 5431010039 | นาย | สว่างพงศ์ | หนูคำสวน
22 | 5431010033 | นาย | นาวิน | บุญสกุล
23 | 5431010040 | นาย | ชัชชนะ | อิ่มเนตร์
24 | 5431010041 | นาย | วีรยุทธ | แสนชา
25 | 5431010022 | นาย | รชำพงษ์ | ภักดีบาง
26
 |  | รวม
 | ลงชื่อ..........................................................................................(ครูที่ปรึกษา)  วันที่.......................เดือน...........................................................พ.ศ...........................
Spreadsheet: 158475d1338277408-how-to-combine-if-and-offset-match-countif-together-0excel-data-validation-techniques-1-
Sheet: Data Validation - Change Lists

 | Advanced Data Validation - Changing Lists Based on Previous Selection
 | Created by Pointy Haired Dilbert - http://chandoo.org/wp | feel free to share, copy and extend
 | Select Area |  | Select Project |  |  |  |  | Many thanks to [NAME] for asking this question
 | FullList |  | HuntDown
 |  |  |  |  |  |  |  | Learn How this works?
 |  |  |  |  |  |  |  | » [NAME] the cell D6
 | Area | Project |  |  |  |  |  | » Go to menu > data > validation
 | Marketing | Horizon2010 |  |  |  |  |  | » See how the validation formula is used (shown below)
 | Marketing | Bingo19x
 | Marketing | Cosmos
 | Marketing | Spring2009
 | Ops | Kayak
 | Ops | KarmicOn
 | Ops | Chain2Customer
 | Sales | CallTag
 | Sales | HuntDown
 | Sales | DarkNight
 | IT | Burrow
 | IT | sITcom
 | IT | excelLENT
Spreadsheet: 43664d1242295874-automatically-adding-tables-upload
Sheet: Handicap Groups

 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  | Old Links |  | Group 1 (0-13.4) = Black
 | x | 6 | 7.2 | 7.2 | 7 | 7 |  |  |  |  |  |  |  |  | Group 2 (13.6 - 20.4) = Blue
 | x | 9 | 7.4 | 7.600000000000001 | 7.600000000000001 | 7.800000000000001 |  |  |  |  |  |  | Fairhaven |  | Group 3 (20.6 - 33.4) = [NAME]
 | x | 11 | 8.4 | 8.6 | 8.799999999999999 | 8.799999999999999 |  |  |  |  |  |  |  |  | Group 4 (33.6 - 40) = Green
 | x | 4 | 13 | 13.2 | 13.2 | 12.6 |  |  |  |  |  |  | Clitheroe
 | x | 1 | 12.6 | 12.8 | 13 | 13.2
 | x | 10 | 12.8 | 12.8 | 13 | 13.2 |  |  |  |  |  |  | Lancaster
 | x | 7 | 13 | 13.2 | 13.4 | 13.6
 | x | 8 | 19.4 | 17 | 17.4 | 16.6 |  |  |  |  |  |  | Pleasington
 | x | 2 | 16 | 16 | 16.4 | 16.8
 | x | 14 | 17 | 17 | 17.4 | 17.8 |  |  |  |  |  |  | Fleetwood
 | x | 13 | 18 | 18.4 | 18.8 | 19.2
 | x | 5 | 26 | 24.8 | 25.4 | 25.4 |  |  |  |  |  |  | Shaw Hill
 | x | 12 | 27.4 | 27.4 | 27.4 | 26.2
 |  | 3 | 29.6 | 30.2 | 30.8 | 31.40000000000001 |  |  |  |  |  |  | Green Drive
 |  | #N/A
Spreadsheet: darrell_schoolcraft__7300__imball0112
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 | 115 | 240
2 | 58 | 240
3 | 44 | 240
4 | 2 | 240
5 | 35 | 240
6 | 41 | 240
7 | 245 | 240
8 | 171 | 240
9 | 110 | 240
10 | 144 | 240
11 | 166 | 240
12 | 139 | 240
13 | 2 | 240
14 | 178 | 240
15 | 141 | 240
16 | 46 | 240
17 | 191 | 240
18 | 248 | 240
19 | 256 | 240
20 | 243 | 240
21 | 198 | 240
22 | 228 | 239
23 | 192 | 239
24 | 171 | 239
25 | 15 | 239
26 | 247 | 239
27 | 194 | 240
28 | 238 | 240
29 | 164 | 240
30 | 291 | 240
31 | 167 | 240
2001-11-30 00:00:00 |  |  | 173805.23
2001-12-31 00:00:00
CBS Volume
 |  |  | 76238
Spreadsheet: 60464d1260992806-using-countif-to-calculate-the-number-of-days-in-a-column-copy-of-variance-tracking-test-5-
Sheet: Employee Search

Employee Variances |  |  |  | [NAME]…
Employee: | Employee #47 |  |  | Sunday
Track Back: | 180 |  |  | Monday
Month Tracking: |  |  |  | Tuesday
Total NET: |  |  |  | Wednesday
Total ABS: |  |  |  | Thursday
# of Variances: |  |  |  | Friday
 |  |  |  | Saturday
Day | Date | [NAME] |  |  |  |  |  |  |  | 2009-03-01 00:00:00
 |  |  |  |  |  |  |  |  | 30 | 2009-04-01 00:00:00
 |  |  |  |  |  |  |  |  | 60 | 2009-05-01 00:00:00
 |  |  |  |  |  |  |  |  | 90 | 2009-06-01 00:00:00
 |  |  |  |  |  |  |  |  | 180 | 2009-07-01 00:00:00
 |  |  |  |  |  |  |  |  | 365 | 2009-08-01 00:00:00
 |  |  |  |  |  |  |  |  | 730 | 2009-09-01 00:00:00
 |  |  |  |  |  |  |  |  | 1095 | 2009-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2009-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2010-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2010-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2010-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2010-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2010-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2010-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2010-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2010-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2010-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2010-12-01 00:00:00
Spreadsheet: 4cc147cc-0037-43ff-8f4b-571ae2b11532
Sheet: Utility function

a | 1
b | 1
increment: |  |  | 0.2
y
 | 0
 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Spreadsheet: eric_saibi__9855__101101U
Sheet: Vienna 08

Owner Name |  | NRG Energy Incorporated
Station Name |  | Vienna Power Station
Unit Name |  | Vienna 08
NERC Region |  | MAAC
State |  | MD
Fuel Type |  | Fuel Oil No. 6
Capacity |  | 162 MW
Start Date |  | 2001-10-11 00:00:00
End Date |  | 2001-10-14 00:00:00
Comments |  | Unit  is down with [NAME].
SIC |  | 4931
Plant ID |  | 1015555
Unit ID |  | 1005937
Outage ID |  | 18636
Spreadsheet: 210628d1359507234-automatic-conditional-formatting-in-matrix-of-information-example
Sheet: Sheet1

 |  | How it is now |  |  | Product | Customer | Week 1 | Week 2 | Week 3 | Week 4 | Week 5
 |  |  |  |  | Product A | Freds store | 200 |  |  |  | 400
 |  |  |  |  | Product A | Bills store |  | 100 |  | 30
 |  |  |  |  | Product A | Kevins store |  | 100 |  |  | 300
 |  |  |  |  | Product B | Freds store |  | 100 |  |  | 50
 |  |  |  |  | Product B | Bills store |  | 100 |  | 40
 |  |  |  |  | Product B | Kevins store |  | 20
 |  | What I want it to be |  |  | Product | Customer | Week 1 | Week 2 | Week 3 | Week 4 | Week 5
 |  |  |  |  | Product A | Freds store | 200 |  |  |  | 400
 |  |  |  |  | Product A | Bills store |  | 100 |  | 30
 |  |  |  |  | Product A | Kevins store |  | 100 |  |  | 300
 |  |  |  |  | Product B | Freds store |  | 100 |  |  | 50
 |  |  |  |  | Product B | Bills store |  | 100 |  | 40
 |  |  |  |  | Product B | Kevins store |  | 20
Spreadsheet: 717186d1612526655-how-do-i-create-a-single-cell-including-multiple-information-of-a-list-of-checkboxes-book3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Include
 |  |  | False |  | Yadda |  |  |  | X | Yadda
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | False |  | [NAME] |  |  |  | X | This is nonsense
 |  |  |  |  |  |  |  |  |  | So is this
 |  |  | True |  | This is nonsense |  |  |  | X | Happy Christmas
 |  |  |  |  |  |  |  |  |  | La La La
 |  |  | True |  | So is this |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Rabbit rabbit rabbit
 |  |  | False |  | Happy Christmas |  |  |  | x | Other stuff
Spreadsheet: 145057d1331289432-base-on-first-sheet-second-sheet-data-auto-arrange-manufacturing-report_mahju
Sheet: Summary Report

09.03.2012 |  |  | Daily summary report - Manufacturing
[NAME] Yesterday
Customer | Cones |  | Substrate | Cones |  | Order in by yarn(kg)
TEXPORT I | 126 |  | SSP | 961.5 |  | 40/2SSP
TEXPORT C | 64.5 |  | PP | 30 |  | 537
AZAIBA | 303 |  | EMB | 4
THRID | 406.5
ASEEL | 92.5
KWUN | 3
Total
Spreadsheet: 135316d1325925694-display-annual-leave-dates-by-employee-2012-staff-planner
Sheet: INDEX

Colour | Code | Description | Category | Leave is tracked as | Day Value
 | H | Annual Leave Full Day | Annual Leave | Entitlement | 1
 | Hh | Annual Leave Half Day | Annual Leave | Entitlement | 0.5
 | M | Maternity Leave Full Day | Maternity Leave | Count | 0
 | Mh | Maternity Leave Half Day | Maternity Leave | Count | 0
 | S | [NAME] | [NAME] | Count | 1
 | Sh | Sick Leave Half Day | [NAME] | Count | 0.5
 | w | Worked Bank Holiday | Bank Holiday | Count | 1