tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 84784d1284828653-dynamic-array-lookup-copy-of-excel-challenge
Sheet: Challenge 2

 |  |  |  |  |  |  |  |  | The data in column A contains a series of phrases. Every phrase contains one color in the phrase. The goal of the challenge is to use the lookup table in D2:E10 to assign the phrase to one of the names in column E.
 |  |  |  |  |  |  |  |  | You can use a formula or a macro. The solution should be adaptable to any size data in column A and any length table in columns D:E. Yes, someone with Excel 2007 could nest 8 IF statements to solve the current problem, but this will not extend to a table with 34 entries, so this is not a valid approach.
Phrases | Assigned to |  | Keyword | Assigned to
the ocean is blue | [NAME] |  | blue | [NAME]
I like his blue shirt | [NAME] |  | red | [NAME]
blue is my favorite color | [NAME] |  | yellow | [NAME]
the ocean is red | [NAME] |  | pink | Fred
I like his red shirt | [NAME] |  | orange | [NAME]
red is my favorite color | [NAME] |  | [NAME] | [NAME]
the ocean is yellow | [NAME] |  | white | [NAME]
I like his yellow shirt | [NAME] |  | lavendar | [NAME]
yellow is my favorite color | [NAME] |  | magenta | [NAME]
the ocean is pink | Fred
I like his pink shirt | Fred
pink is my favorite color | Fred
the ocean is orange | [NAME]
I like his orange shirt | [NAME]
orange is my favorite color | [NAME]
the ocean is brown | [NAME]
I like his brown shirt | [NAME]
[NAME] is my favorite color | [NAME]
the ocean is white | [NAME]
I like his white shirt | [NAME]
white is my favorite color | [NAME]
the ocean is lavendar | [NAME]
I like his lavendar shirt | [NAME]
lavendar is my favorite color | [NAME]
Fred
Spreadsheet: 696867d1601020109-fee-increase-by-a-certain-over-every-certain-years-fee-increase-by-a-certain-over-every-certain-years
Sheet: bebo021999

 | Fee increase by a certain % over every certain years
 | Year | 1 |  |  |  |  |  |  |  |  |  |  |  | Checksum
 | Assessment fee | 100
 | Increase every ? years | 5
 | Increase % | 0.05
 | Require a formula in cell D5 that I can drag across to cell N5 all the way, to show increase in assessment fee every 3 years by 5%
 | Also require a formula in cell O5 to check that the cell N5 is computed correctly
 | [NAME]
 | Difference
Spreadsheet: 38115d1236241582-how-to-count-the-sums-of-repetitive-cells-and-then-remove-the-duplicates-example
Sheet: Sheet1

3RD125070442H | 10
3RD125070442H | 10
3RD125070442H | 10
3RE071870493H | 4
3RI100009624T | 12
3RI100009624T | 3
3RKB0624484WH | 8
3RKB0624484WH | 8
3S1250030J42H | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 505 | 100
Spreadsheet: 715926d1611928655-using-vlookup-to-pull-values-into-another-sheet-then-count-vulncounts
Sheet: Sheet1

 | Low | Medium | High
Spreadsheet: 881362d1729449343-formula-to-compute-leave-salary-amount-weekdayswages
Sheet: Sheet2

 |  |  |  |  |  |  | No Fridays or Saturdays
 |  |  |  |  |  | Working Days | Working Days |  | Wage | 740
 |  |  | Start | End | Days | (No weekendsor | (Mon,[NAME],
 | Holidays |  | Date | Date |  | holidays) | Wed,Thur,Sun)
 | 2024-10-06 00:00:00 |  | 2024-08-01 00:00:00 | 2024-08-31 00:00:00
 | 2024-10-25 00:00:00 |  | 2024-09-01 00:00:00 | 2024-09-30 00:00:00
 | 2024-11-06 00:00:00 |  | 2024-10-01 00:00:00 | 2024-10-31 00:00:00
 |  |  | 2024-11-01 00:00:00 | 2024-11-30 00:00:00
 |  |  | 2024-12-01 00:00:00 | 2024-12-31 00:00:00
 |  |  | 2025-01-01 00:00:00 | 2025-01-31 00:00:00
 |  |  | 2025-02-01 00:00:00 | 2025-02-28 00:00:00
 |  |  | 2025-03-01 00:00:00 | 2025-03-31 00:00:00
 |  |  | Start Date" in column "D".
 |  |  | Enter the Start Date under "Start Date in column "D".
 |  |  | Enter the End Date under the "End Date" in column "E".
Spreadsheet: 196860d1354127923-webimport-daily-updated-table-with-variable-number-of-objects-fota1
Sheet: IMPUT28-11

[NAME] | 2.25 | [NAME]
2.25
Army of the Damned | 2.4 | Army of the Damned
2.40
[NAME] | 1.45 | [NAME]
1.45
Champion of the Parish | 1.1 | Champion of the Parish
1.10
Clifftop Retreat | 2.55 | Clifftop Retreat
2.55
Essence of the Wild | 1.1 | Essence of the Wild
1.10
[NAME] | 19.2 | [NAME]
19.20
Gavony Township | 1.1 | Gavony Township
1.10
Geist of Saint Traft | 24.75 | Geist of Saint Traft
24.75
Grimgrin Corpse-Born | 1.45 | Grimgrin Corpse-Born
1.45
Grimoire of the Dead | 1.4 | Grimoire of the Dead
1.40
Hinterland Harbor | 3.1 | Hinterland Harbor
3.10
Isolated Chapel | 3.3 | Isolated Chapel
3.30
[NAME] of the Veil | 22.5 | [NAME] of the Veil
22.50
Mikaeus the Lunarch | 3.6 | Mikaeus the Lunarch
3.60
Mirror-Mad Phantasm | 1 | Mirror-Mad Phantasm
1.00
[NAME] | 11 | [NAME]
11.00
Past in Flames | 5.5 | Past in Flames
5.50
Reaper from the [NAME] | 1.3 | Reaper from the [NAME]
1.30
Runechanter's Pike | 0.78 | Runechanter's Pike
0.78
Sever the Bloodline | 0.62 | Sever the Bloodline
0.62
Skaab Ruinator | 1.15 | Skaab Ruinator
1.15
[NAME] | 6.95 | [NAME]
6.95
Stromkirk Noble | 1.5 | Stromkirk Noble
1.50
[NAME] | 3.1 | [NAME]
3.10
Tree of Redemption | 2.15 | Tree of Redemption
2.15
Woodland Cemetery | 2.85 | Woodland Cemetery
2.85
AAAAAAA | 2.85 | AAAAAAA
2.85
AABBBBB | 0.6 | AABBBBB
0.60
Spreadsheet: 68187d1268745098-report-table-vlookup-match-index-formula-book2-4
Sheet: Sheet1

SETTING | Scheme |  |  | REPORT
Acorn | A |  |  |  | Scheme Count
Bankwood | B |  |  | SETTING | A | B | C
Bankwood | C |  |  | Acorn | 1 | 1 | 0
Acorns C | A |  |  | Acorns C | 2 | 0 | 0
Ashdell | C |  |  | Appletree | 0 | 0 | 0
Acorn | B |  |  | Ashdell | 0 | 0 | 1
Acorns C | A |  |  | Bankwood | 0 | 1 | 1
Spreadsheet: 668666d1584970310-calculating-scores-for-performance-errors-per-call-sample
Sheet: Sheet1

Name | Calls | Errors | [NAME]
Name19 | 16955 | 20 | 0.001179593040401062
Name1 | 18692 | 26 | 0.001390969398673229
Name9 | 17105 | 24 | 0.001403098509207834
Name8 | 17165 | 25 | 0.001456452082726478
[NAME] | 19157 | 28 | 0.001461606723390928
Name4 | 15017 | 22 | 0.001465006326163681
Name5 | 13140 | 21 | 0.001598173515981735
Name3 | 12176 | 20 | 0.00164257555847569
Name10 | 12699 | 21 | 0.001653673517599811
Name15 | 16213 | 28 | 0.001727009190156048
Name18 | 14914 | 30 | 0.002011532787984444
Name12 | 14788 | 31 | 0.002096294292669732
[NAME] | 16496 | 35 | 0.00212172647914646
Name11 | 14921 | 33 | 0.00221164801286777
Name6 | 13446 | 30 | 0.002231146809460063
Name13 | 11933 | 28 | 0.002346434257940166
[NAME] | 12049 | 30 | 0.002489833181176861
Name7 | 14049 | 35 | 0.002491280518186348
Name17 | 10760 | 28 | 0.002602230483271375
Name14 | 12155 | 33 | 0.002714932126696832
Spreadsheet: jonathan_mckay__16922__Sierras West - Buy1
Sheet: Enron Direct Deal Sheet

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | The Owners Condominium Plan #971-2250 |  |  |  |  | Deal Date: |  | 2001-08-13 00:00:00 |  |  |  |  | 3 | March
Originator: |  |  |  |  |  | Deal ID #: |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-11-01 00:00:00 |  |  |  |  | Unit of Measure: |  | GJ |  |  |  |  | 6 | June
Deal End Date: | 2005-10-31 00:00:00 |  |  |  |  | Volume (Monthly/Daily): |  | Monthly |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  |  | Price: |  | 5.3 |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  |  | Buy/Sell: |  | Buy |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Rate 11 Fuel | Rate 13 Fuel | Rate 11 Total |  | Rate 13 Total
 | January |  | 1945 |  | 30
 | February |  | 1406 |  | 22
 | March |  | 1442 |  | 23
 | April |  | 1139 |  | 18
 | May |  | 809 |  | 13
 | June |  | 711 |  | 11
 | July |  | 574 |  | 9
 | August |  | 418 |  | 7
 | September |  | 758 |  | 12
 | October |  | 1213 |  | 19
 | November |  | 1673 |  | 26
 | December |  | 1926 |  | 30
 | TOTAL:
Spreadsheet: 258501d1376687545-complex-vacation-accural-formula-script-needed-vacation-master-log-3-
Sheet: Import

 |  |  |  |  |  |  |  |  | Hide | Hide | Hide | Hide | Hide | Hide |  | Do Not Change
Timestamp | Username | Dates Requested | Number of Days Requested | Allowance | Reason | Approved? | Remaining | Holiday  year  start | Holiday  year  end | in Holiday year | Start year clash | End year clash | Full year | Part year | Holidays  approved
2013-07-25 13:41:15 | [EMAIL] | 2012-09-30 00:00:00 | 5 | 1 | 1 | Y
 | [EMAIL] | 2014-09-30 00:00:00 | 5
 | [EMAIL] | 2013-08-01 00:00:00 | 3
 | [EMAIL] | 2013-08-02 00:00:00 | 4
 | [EMAIL] | 2013-08-05 00:00:00 | 5 |  |  | y
 | [NAME] | 2013-08-06 00:00:00 | 6
 | [EMAIL] | 2013-08-07 00:00:00 | 7
 | [EMAIL] | 2013-08-08 00:00:00 | 8
 | [EMAIL] | 2013-08-09 00:00:00 | 9
 | [NAME] | 2013-08-12 00:00:00 | 10
 | [EMAIL] | 2013-08-13 00:00:00 | 5 |  |  | y
 | [EMAIL] | 2013-08-14 00:00:00 | 2
 | [EMAIL] | 2013-08-15 00:00:00 | 3
 | [EMAIL] | 2013-08-16 00:00:00 | 4
 | [EMAIL] | 2013-08-19 00:00:00 | 5
 | [EMAIL] | 2013-08-20 00:00:00 | 6
 | [EMAIL] | 2013-08-21 00:00:00 | 7
 | [EMAIL] | 2013-07-31 00:00:00 | 4 |  |  | y
 | [EMAIL] | 2013-11-30 00:00:00 | 1 |  |  | y
 | [EMAIL] | 2013-12-01 00:00:00 | 3 |  |  | y
 | [EMAIL] | 2013-08-03 00:00:00 | 4 |  |  | y
Spreadsheet: 00af6a4e-a138-4abf-b9d7-649fbdfd3c75
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 41. OPERATING LEASE FINANCE COMMITMENTS, By Industry: 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
Agriculture, forestry and fishing ; |  |  | Original | A2413817T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2413818V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2413819W | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2413820F | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2413821J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2413823L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2413824R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2413825T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2413826V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Public Administration ; |  |  | Original | A2413827W | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2413828X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2413829A | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413830K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: cec2c20c-7e4f-4b2c-b25e-966ee2bc23b2
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 664497477723 | Heata | Igniting Tha Fire | 2005-02-15 | Compact Disc | Rap | 16.99 | N | To Be Retired
Spreadsheet: 264248d1378828552-extracting-and-sorting-data-from-source-worksheet-excel-2003-index-match-tutorial-for-tailz
Sheet: Tutorial 2

 |  | Ok, we got down the basics. Let's complicate things!
 |  | System ID | Callout Date | Callout Time | [NAME] |  | Unique Rank Maker
 |  | black | 2013-07-01 00:00:00 | 09:30:00 | 2013-07-01 00:00:00
 |  | white | 2013-07-07 00:00:00 | 11:15:00 | 2013-07-07 00:00:00
 |  | black | 2013-07-11 00:00:00 | 08:15:00 | 2013-07-11 00:00:00
 |  | white | 2013-07-16 00:00:00 | 09:45:00 | 2013-07-16 00:00:00
 |  | black | 2013-08-01 00:00:00 | 08:00:00 | 2013-08-01 00:00:00
 |  | white | 2013-08-06 00:00:00 | 09:30:00 | 2013-08-07 00:00:00
 |  | pink | 2013-08-13 00:00:00 | 09:15:00 | 2013-08-13 00:00:00
 |  | pink | 2013-08-17 00:00:00 | 09:30:00 | 2013-08-17 00:00:00
 |  | Black
 | rank | System ID | Callout Date | Callout Time | [NAME]
 |  | White
 |  | System ID | Callout Date | Callout Time | [NAME]
 |  | System ID | Callout Date | Callout Time | [NAME]
Spreadsheet: 08a8d66b-537f-4f7c-8827-8f3bbbdfa9f2
Sheet: Sheet1

 | DODGE COUNTY | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  |  |  | 2013 TAX RATE TABLE
 |  | TOWN | HUSTISFORD | December 4, 2013
 | TAX DISTRICT NUMBER 1 - 2625 HUSTISFORD |  |  | EQUALIZED RATIO
 |  |  |  | 1.014407931
 | TAXING BODY |  | MAJOR STATE AIDS RATES | CURRENT YEARS TAX RATES
1. | STATE OF WISCONSIN |  |  | 0.0001713675641459717
2. | DODGE COUNTY |  | 0.001001177665572419 | 0.00563579720598843
3. | SCHOOL DISTRICT |  | 0.005556700407477124 | 0.01041099721280441
4. | VOCATIONAL SCHOOL |  | 0.0001699665837393826 | 0.001584328509811426
5. | TOWN OF HUSTISFORD |  | 0.000855574038362456 | 0.002951980686284612
6. | OTHER
7. | OTHER
 |  | GROSS RATE | 0.007583418695151382 | 0.02075447117903485
 |  |  | STATE SCHOOL CREDIT | 0.001663037346719465
 |  |  | NET TAX RATE | 0.01909143383231539
PLEASE INDICATE ADDRESS OF LOCAL TREASURER
TO APPEAR ON TAX STATEMENT
 | [NAME] |  | TREASURER
 | NAME |  |  | PLEASE RETURN
 |  |  |  | COMPLETED FORM TO:
 | N4425 COUNTY RD. R
 | ADDRESS |  |  | DODGE COUNTY TREASURER
 |  |  |  | 127 EAST OAK STREET
 | IRON RIDGE, WI  53035 |  |  | JUNEAU, WI  53039
 | CITY | STATE         ZIP
 | 1ST INSTALLMENT DUE  JANUARY 31, 2014 |  |  | HEIDI OHREN
 |  |  |  | MUNICIPAL CLERK
 | Lottery & First Dollar Credit Mill Rate |  |  | December 4, 2013
 |  | 0.010323816 |  | DATE
Spreadsheet: 117881d1313178655-how-to-match-a-group-of-articles-example
Sheet: Blad2

120 DB DUBBEL AFGESCHERMDE HAAKSE COAX KABEL
120 DB DUBBEL AFGESCHERMDE COAX KABEL
120 DB DUBBEL AFGESCHERMDE HAAKSE COAX KABEL
120 DB DUBBEL AFGESCHERMDE COAX KABEL
120 DB DUBBEL AFGESCHERMDE HAAKSE COAX KABEL
120 DB DUBBEL AFGESCHERMDE COAX KABEL
120 DB DUBBEL AFGESCHERMDE HAAKSE COAX KABEL
HAAKSE ANTENNEKABEL
HAAKSE COAX PLUG NAAR HAAKSE COAXPLUG
[NAME]
HAAKSE COAX PLUG NAAR HAAKSE COAXPLUG
COAX-KABEL
90DB ANTENNEKABEL
90DB ANTENNE KABEL
90DB ANTENNE KABEL
[NAME]
COAX KOPPELSTUK
[NAME]
[NAME]
HAAKSE COAX PLUG
Spreadsheet: 798940d1664820780-if-and-formuls-based-off-another-column-excel-sim-help-demo
Sheet: Sheet1

 | Airline | Flight Number | [NAME] | Aircraft to Fly | Distance in NM | A380 | Route | Departure Code | Departure Location | Departure Updated | Scheduled Departure Time (Zulu) | Departure Gate | Arrival Code | [NAME] | [NAME] | [NAME] | Scheduled Arrival Time (Zulu) |  | Est Flight Time | Logged Flight Time | Actual Flight Hours | Pay/Hr | Total Income | XP Earned | Flight date
 | Delta Airlines | 85 | P3D |  | 3816 |  |  | LFPG |  |  | 13:50:00 | [NAME] | KATL |  |  | F3 | 23:10:00 |  |  | 08:19:32 |  | 47.4 |  | 118.8 | 2022-09-18 00:00:00
 | Delta Airlines | 194 | MSFS |  | 3981 |  |  | KATL |  |  | 21:45:00 | E12 | LEBL |  |  | 273 | 06:45:00 |  |  | 08:46:08 |  | 47.4 |  | 109.2 | 2022-09-22 00:00:00
 | Egyptair | 5530 | P3D |  | 1910 |  |  | HECA |  |  | 07:30:00 |  | EGLL |  |  | 323 | 13:00:00 |  |  | 04:31:37 |  | 32.11 |  | 97 | 2022-07-27 00:00:00
Spreadsheet: darron_c_giron__8034__KingsgatetoMalinTransp
Sheet: Terms

 | 9 | Pipeline
 |  | PGT | Receipt | Delivery | Start | End
 |  | Contract # | [NAME] | Malin | 2008-11-01 00:00:00 | 2023-10-31 00:00:00
 |  |  | Tier1 | Tier2 | Tier3 | Tier4
 |  | Months | All | (none) | (none) | (none)
 |  | Volume | 67500 | 0 | 0 | 0
 |  | Commodity | 0 | 0 | 0 | 0
 |  | Fuel Rate | 0.022906 | 0 | 0 | 0
 |  | Demand | 0.12 | 0 | 0 | 0
 |  | Surcharge | 0 | 0 | 0 | 0
 |  | RecPt Index Adj | 0 | 0 | 0 | 0
 |  | [NAME] Index Adj | 0 | 0 | 0 | 0
 |  | [NAME] | CGPR-KINGSGATE Basis Mid | Delivery Basis | NGI-MALIN Basis Mid | Region
 |  | Receipt Index | CGPR-KINGSGATE Index Mid | Delivery Index | NGI-MALIN Index Mid | West/Holst
 |  | [NAME] | NG_OMICRON_9 | [NAME] | NG_OMICRON_8 | Include Variable GRI (Y/N)
 |  | Correlation Col | 10 |  |  | N
 |  | Comments | This is a test comment
Spreadsheet: a01e1409-9af9-4be8-9bc2-fb3457ce1b1a
Sheet: Sheet1

Undistributed Long Term Capital Gains (2439) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
2002 Year-end Tax Reporting Information
DATED:   (01/07/03) |  |  |  | DUE:  Within 45 days after the close of the REIT's taxable year
Please list securities in CUSIP order (Skip Rows Between Entries)
 |  |  |  |  |  |  |  |  | $ Amounts per Each Share (to 6 places)---------------------------------------------------------------------------------------------
 |  |  |  |  |  | Tax |  |  | Total Undistributed |  |  | Long-Term | Unrecaptured
 | CUSIP | Ticker |  |  |  | Identification | Tax Year |  | Long Term | 28 Percent | Qualified | Rate Gain | Section 1250 | Section 1202 | Tax Paid
REIT Name | Number | Symbol | Corrected ("C") | Address | City, State, Zip | Number | Begin Date | End Date | Capital Gain | Rate Gain | 5 Year Gain | (10 or 20 percent) | Gain | Gain | by RIC
(1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10)=(11)+(13)+(14) | (11) | (12) | (13) | (14) | (15) | (16)
Annaly Mortgage Management, Inc.- 1st QTR | 035710409 | NLY |  | 1211 Avenue of the Americas, Suite 2902 | New York, NY 10036 | 22-3479661 | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 |  | 0
Annaly Mortgage Management, Inc.-2nd QTR | 035710409 | NLY |  |  |  |  |  |  |  | 0
Annaly Mortgage Management, Inc.-3rd QTR | 035710409 | NLY | C |  |  |  |  |  |  |  |  | 0.01
Annaly Mortgage Management, Inc.-4th QTR | 035710409 | NLY | C |  |  |  |  |  |  |  |  | 0.05
Totals for 2002 |  |  |  |  |  |  |  |  |  |  |  | 0.06
Spreadsheet: 168167d1342276440-lookup-values-accross-several-sheets-to-create-summary-sheet-example-workbook
Sheet: Season1

 | Division | Standing | Cup | Playoffs | Goals | Cup goals | [NAME]
Team 1 |  | 15 | 4 | 0
Player1 |  |  |  |  | 3
Player2 |  |  |  |  |  | 2
Player3 |  |  |  |  | 1
Team 2 |  | 3 | 1 | 2
Player4 |  |  |  |  |  | 1
Player5 |  |  |  |  | 1
Player6 |  |  |  |  | 1
Team 3 |  | 11 | 2 | 0
Player7
Player8
Player9 |  |  |  |  | 1
Team 4 |  | 7 | 1 | 0
Player10 |  |  |  |  | 1
Player11
Player12
Team 5 |  | 14 | 2 | 0
Player10 |  |  |  |  | 1
Player11
Player12
Team 6 |  | 6 | 1 | 2
Player10 |  |  |  |  | 1 | 1
Player11 |  |  |  |  | 1
Player12
Team 7 |  | 5 | 5 | 1
Player10
Player11 |  |  |  |  | 1
Player12 |  |  |  |  | 2
Team 8 |  | 4 | 3 | 5
Player10 |  |  |  |  | 1 |  | 1
Player11 |  |  |  |  | 1 | 1 | 2
Player12 |  |  |  |  | 2
Team 9 |  | 8 | 3 | 0
Player13
Player14
Player15 |  |  |  |  | 1 | 1
Team 10 |  | 1 | 1 | 3
Player16 |  |  |  |  | 3
Player17 |  |  |  |  | 2
Player18 |  |  |  |  | 1
Team 11 |  | 2 | 1 | 4
Player19 |  |  |  |  | 1
Player20
Player21
Team 12 |  | 13 | 2 | 2
Player22 |  |  |  |  | 1
Player23
Player24
Team 13 |  | 11 | 1 | 0
Player25 |  |  |  |  | 2
Player26
Player27 |  |  |  |  | 1
Team 14 |  | 10 | 2 | 0
Radiscal
Player28 |  |  |  |  |  | 1
Player29 |  |  |  |  | 1
Player30 |  |  |  |  | 1
Team 15 |  | 16 | 1 | 0
Player31
Player32 |  |  |  |  | 2
Player33
Team 16 |  | 9 | 1 | 0
Player34
Player35
Player36
Spreadsheet: 146954d1332436160-formula-help-need-to-deduct-30-min-if-worked-over-6-hours-efg-7-day-timesheet-dummy-sheet
Sheet: Sheet1

 |  |  | EFG Logistics Weekly Time Sheet
 |  |  | Name: | [NAME] | Week Commencing : Date
DATE | DAY OF WEEK | TIME STARTED | TIME FINISHED | HOURS WORKED | JOB LOCATION & NOTES | LUNCH TIMES | PARTNER (S)
 |  |  |  |  |  | 12:30 TIL 1:00
 |  |  |  |  |  | 12:30 TIL 1:00
 |  |  |  |  |  | 12:30 TIL 1:00
 |  |  |  |  |  | 12:30 TIL 1:00
 |  |  |  |  |  | 12:30 TIL 1:00
 |  |  |  |  |  | 12:30 TIL 1:00
 |  |  |  |  |  | 12:30 TIL 1:00
 |  |  | WEEKLY TOTAL |  | HOURS
This time sheet must be submitted to [NAME] or [NAME] by 9.00am on the following Monday
NB: All data submitted within this time sheet must be true and accurate and the providing of false information will be investigated
with the possibility of dismissal on the grounds of gross misconduct.
Inserting times are based on a 24 hour clock. You only need to use :-  start/finish times,job location & partner (s) sections on this time sheet.
other sections are automated,just put your name in the blue section,once in you dont need to change. & change the date accordingly.
30 minutes lunch time will automatically be deleted when you work more than 6 hours a day.
Signature & date : |  | D.K.Gavin [NAME]
Spreadsheet: 0791d3d9-ae77-4c49-bd54-8b3347914f8a
Sheet: 2003-04

Table N
Students Domiciled within the UK by Method of Study
Country/Region | Undergraduate |  |  | Graduate |  |  | Total
 | Full Time | Part Time | Total | Full Time | Part Time | Total
England
Greater London | 4056 | 140 |  | 1154 | 1035
South East | 2454 | 56 |  | 677 | 574
South West | 628 | 3 |  | 127 | 62
North and Yorkshire | 320 | 3 |  | 81 | 46
North West | 310 | 5 |  | 77 | 32
Midlands | 639 | 3 |  | 139 | 84
East Anglia | 316 | 3 |  | 90 | 113
Not Known | 0 | 0 |  | 0 | 4
Subtotal
Northern Ireland | 35 | 2 |  | 12 | 20
Scotland | 91 | 2 |  | 65 | 20
Wales | 204 | 3 |  | 37 | 17
Channel Isles and Isle of Man | 34 | 0 |  | 4 | 5
Not Known | 20 | 5 |  | 14 | 12
Total
This table is concerned with students whose domicile at the time of application is within the UK irrespective of nationality.
The sum of Tables N and O is equivalent to the total number of students attending UCL.