tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 198751d1354887891-match-and-vlookup-matchlookup-problem
Sheet: Personnel Details

Employee ID | FirstName | KnownAs | Surname | Status | JobTitle | Department | Address1 | Address2 | Address3 | Address4 | Address5 | PostCode
Here we go…
I want to be able to add an employees Job Title to F2 using some sort of lookup. The data in the other two sheets contains imported information from a piece of software, which I will then use to populate this sheet.
I need a formula that will look at cell [NAME], recognise it as employee ID "8", then look into the "t_Employee_UDF_data" sheet to match the ID's. Then it needs to recognise that we are looking for
employee ID "8"'s job title which is displayed in column D (UDF Sheet). Catch being, column D contains other information so we need to look at column "I" for the "01 - Current Job Title" row, then display column D of that specific row
Little bit complicated, and I was having trouble even describing that. The general gist is display the job title of column D (UDF Sheet) in F9 (Above) but make sure its for the relevant employee and make sure its not data refering to for instance "06 - Contracted Hours"
Sorry I can't be more descriptive than this.
Spreadsheet: shelley_corman__38749__Cashinoutmajorityminority
Sheet: May 2001

May 2001 Production Month
Cash In\Out After Bookout | 21 | Majority Due FGT
 | 19 | Minority Due shippers
le_nm | [NAME] | inv_amt | sum_mmbtu_qty
CF INDUSTRIES,  INC | CIO | -94.07 | -23
CITRUS TRADING CORPORATION | CIO | -26801.77 | -6553
DYNEGY GAS TRANSPORTATION, INC. | CIO | -4372.21 | -1069
ENRON NORTH AMERICA CORP. | CIO | -9772.67 | -496
[NAME], L.P. | CIO | -1734.16 | -424
FLORIDA POWER CORPORATION | CIO | -130123.35 | -31815
FLORIDA PUBLIC UTILITIES COMPANY | CIO | -1550.11 | -379
INFINITE ENERGY, INC. | CIO | -35258.47 | -5683
INFINITE ENERGY, INC. | CIO | -23180.38 | -5683
LAFARGE GYPSUM | CIO | -159.51 | -39
NATIONAL GYPSUM COMPANY | CIO | -59131.58 | -16064
NOBLE GAS MARKETING, INC. | CIO | -47812.1 | -11690
ORLANDO COGEN FUEL, INC | CIO | -48143.39 | -11771
ORLANDO UTILITIES COMMISSION | CIO | -1374.24 | -336
PEOPLES GAS SYSTEM, A DIVISION OF TAMPA | CIO | -361220.62 | -88318
REEDY CREEK IMPROVEMENT DISTRICT | CIO | -21468.41 | -5249
RELIANT ENERGY SERVICES, INC. | CIO | -28065.58 | -6862
SOUTH FLORIDA NATURAL GAS, INC. | CIO | -347.65 | -85
ST. JOE NATURAL GAS COMPANY | CIO | -4380.39 | -1071
TALLAHASSEE, CITY OF | CIO | -136160.19 | -33291
Total due 19 shippers
ADAMS RESOURCES MARKETING, LTD. | CIO | 201.12 | 40
ALABAMA POWER COMPANY | CIO | 12544.55 | 2990
BAPTIST MEDICAL CENTER | CIO | 854.76 | 204
BP ENERGY COMPANY | CIO | 58.66 | 14
CARGILL FERTILIZER,  INC | CIO | 4.19 | 1
CELOTEX CORPORATION | CIO | 829.62 | 198
CINERGY MARKETING & TRADING, LLC | CIO | 1432.98 | 342
CLARKE-MOBILE COUNTIES GAS DISTRICT | CIO | 6207.91 | 1471
CORAL ENERGY RESOURCES, L.P. | CIO | 4.19 | 1
DYNEGY GAS TRANSPORTATION, INC. | CIO | 1304960 | 254875
EL PASO MERCHANT ENERGY, L.P. | CIO | 15201.19 | 3594
HIGHLAND ENERGY COMPANY OF TEXAS | CIO | 6350.36 | 1263
INFINITE ENERGY, INC. | CIO | 23180.38 | 5683
MIRANT AMERICAS ENERGY MARKETING, LP | CIO | 6955.4 | 1660
ONYX GAS MARKETING COMPANY, L.C. | CIO | 125.7 | 30
ORLANDO COGEN FUEL, INC | CIO | 48143.39 | 11771
ORLANDO COGEN II | CIO | 4.19 | 1
PRIOR INTRASTATE CORPORATION | CIO | 917.46 | 180
TEXACO NATURAL GAS, INC. | CIO | 577500 | 120000
TEXICAN NATURAL GAS COMPANY | CIO | 79.61 | 19
TEXLA ENERGY MANAGEMENT, INC. | CIO | 24134.4 | 4800
Total due FGT  21 shippers
Spreadsheet: 196546d1354035976-trying-to-play-with-relationships-and-easy-way-to-manipulate-sheets-after
Sheet: After

id | fieldid | field_value | entry_id
28 | 1 | SOME COMPANY | 3
29 | 2 | 34678 somewhere st | 3
30 | 11 | t2n 2j2 | 3
31 | 3 | london | 3
32 | 4 | England | 3
33 | 5 | [EMAIL] | 3
34 | 6 | http://www.***********.com | 3
35 | 7 | [PHONE] | 3
36 | 8 | [PHONE] | 3
37 | 10 | uk | 3
38 | 1 | Another Company | 4
39 | 2 | 324 nowhere road | 4
40 | 11 | u4k 2l3 | 4
41 | 3 | london | 4
42 | 4 | England | 4
43 | 5 | [EMAIL] | 4
44 | 6 | http://www.***********.com | 4
45 | 7 | [PHONE] | 4
46 | 8 | [PHONE] | 4
47 | 10 | uk | 4
Spreadsheet: 759347d1639499648-unique-deduplication-revisedworksheetexample
Sheet: Sheet1

 | [NAME] | Doe |  | * [NAME]
 | [NAME] | [NAME] |  | * [NAME]
 | [NAME] | Smith |  | Willy Wonka
 | [NAME] | Doe |  | [NAME]
 | Willy | Wonka |  | [NAME]
 | George | Smith |  | * [NAME]
 | Alfred | Neuman |  | * [NAME]
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | Adams |  | [NAME]
 | George | Washington
 | [NAME] | Willis
 | [NAME] | Smith
 | [NAME] | Smith |  | MJ Jones
 | Alfred | Neuman
 | MJ | Jones
 | [NAME] | Adams
 | [NAME] | Adams
 | [NAME] | [NAME]
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | J Doe
 | Clint | Eastwood
 | J | Doe
 | MJ | Jones
Spreadsheet: 787054d1657620038-move-rows-to-another-sheet-based-on-latest-entry-for-each-item-2022-07-12-oeldere-geobeck-sandbox-im-dashboard
Sheet: Full list

Date | Name | Type | Current info | Action needed | Action By | Action deadline | Complete? | criteria
2022-07-08 00:00:00 | Eleanor Shellstrop | LTI | New FAF saved to injury mgmt folder. Restrictions now 10 kf lift floor to waist 5 kg above waist, push/pull 40 kg. | Adjust workload to fit within restrictions. New FAF to be sent in 2 weeks. | Supervisors | 2022-07-22 00:00:00 | Yes
2022-07-08 00:00:00 | Chidi Anagonye | NTL | Chidi has physio appt on Monday July 11. Needs to leave at 2:30 PM. | Adjust schedule to accommodate appointment. | Coordinators | 2022-07-11 00:00:00 | Yes
2022-07-08 00:00:00 | [NAME] | ICBC | Mid-back pain from rear-end collision last weekend. No lifting above shoulder height. Hours limited to 4h/3d | Adjust schedule to M-W-F, determine best time to come in. [NAME] will on Tue-Thu afternoons. | Coordinators | 2022-07-15 00:00:00 | Yes
2022-07-09 00:00:00 | Chidi Anagonye | NTL | Chidi rescheduled his appointment for Monday July 11. | Adjust schedule to accommodate appointment. | Coordinators |  | Yes
2022-07-10 00:00:00 | Eleanor Shellstrop | LTI | Received updated FAF from doctor. Restrictions now 10 kg floor to waist and waist to shoulder. | Adjust workload to fit within restrictions. New FAF to be sent in 2 weeks. | Supervisors | 2022-07-22 00:00:00 | No
2022-07-10 00:00:00 | Chidi Anagonye | NTL | Doctor's appointment has been rescheduled for July 12 at 10:30 AM. | Adjust schedule to accommodate appointment. | Coordinators | 2022-07-12 00:00:00 | Yes
2022-07-11 00:00:00 | [NAME] | ICBC | Physiotherapist suspects fracture. Tahani will be off for 2 weeks until X-ray is assessed. | [NAME] off until 2022-07-25 | Coordinators | 2022-07-25 00:00:00 | No
2022-07-11 00:00:00 | Chidi Anagonye | NTL | Chidi has rescheduled his appointment AGAIN. New appt: July 14. | Adjust schedule to accommodate appointment. | Coordinators | 2022-07-14 00:00:00 | No
Spreadsheet: 860944d1708959540-less-than-or-greater-than-with-time-shift-log-aligw
Sheet: Sheet2

Start 1st shift | End 1st Shift | 1st Shift Length | Start 2nd Shift | End 2nd Shift | Break | Total (Hrs)
 |  |  | 19:45:00 | 05:30:00
12:00:00 | 13:30:00 |  | 19:00:00 | 05:30:00
 |  |  | 19:00:00 | 05:30:00 | 01:00:00
 |  | 01:30:00 | 19:00:00 | 05:30:00
 |  |  | 19:45:00 | 07:30:00 | 03:00:00
 |  | 02:00:00 | 20:00:00 | 06:30:00
 |  |  | 19:45:00 | 07:30:00
 |  | 02:00:00 | 20:00:00 | 06:30:00
 |  |  | 20:00:00 | 07:30:00
 |  | 00:40:00 | 21:00:00 | 07:30:00 | 02:00:00
 |  | 01:00:00 | 19:00:00 | 04:30:00
 |  | 02:00:00 | 19:30:00 | 05:30:00
 |  |  | 20:00:00 | 05:30:00
 |  |  | 20:30:00 | 05:30:00
 |  |  | 19:45:00 | 05:30:00
 |  |  | 20:45:00 | 05:30:00
 |  | 02:30:00 | 19:30:00 | 06:00:00
 |  |  | 19:45:00 | 07:00:00
 |  | 02:00:00 | 19:30:00 | 06:00:00
 |  | 00:45:00 | 19:45:00 | 05:45:00
 |  | 02:00:00 | 19:45:00 | 06:00:00 | 01:00:00
 |  | 00:45:00 | 20:00:00 | 08:37:00
 |  | 01:00:00 | 20:00:00 | 08:00:00 | 01:40:00
 |  |  | 20:00:00 | 05:30:00
 |  | 01:00:00 | 20:00:00 | 05:31:00
 |  | 02:30:00 | 19:00:00 | 06:30:00
 |  | 00:45:00 | 20:00:00 | 06:15:00
 |  | 00:40:00 | 20:20:00 | 07:00:00
 |  | 01:40:00 | 20:30:00 | 06:30:00 | 01:00:00
 |  | 01:30:00 | 20:00:00 | 06:15:00
 |  |  | 20:20:00 | 06:15:00
 |  | 01:30:00 | 22:30:00 | 06:00:00
 |  | 01:00:00 | 20:00:00 | 06:15:00
 |  |  | 20:20:00 | 09:00:00 | 01:00:00
 |  | 01:30:00 | 20:45:00 | 06:00:00
 |  | 00:45:00 | 19:45:00 | 05:55:00
 |  | 01:50:00 | 19:30:00 | 07:00:00
 |  | 02:00:00 | 19:30:00 | 07:00:00 | 00:30:00
 |  | 01:45:00 | 20:00:00 | 05:20:00 | 01:00:00
13:30:00 | 15:00:00 |  | 19:50:00 | 08:30:00 | 02:30:00
00:00:00 | 00:00:00 |  | 19:00:00 | 05:50:00 | 00:00:00
12:00:00 | 12:45:00 |  | 19:20:00 | 05:30:00
12:00:00 | 12:45:00 |  | 19:30:00 | 05:30:00 | 00:30:00
 |  |  | 19:40:00 | 05:57:00
 |  |  | 19:35:00
12:30:00 | 13:30:00 |  | 19:40:00 | 06:30:00 | 01:40:00
12:00:00 | 13:50:00 |  | 20:00:00 | 06:25:00 | 00:00:00
12:05:00 | 13:40:00 |  | 19:45:00 | 07:45:00 | 01:45:00
 |  |  | 19:05:00 | 07:00:00 | 00:40:00
12:30:00 | 13:45:00 |  | 20:00:00 | 07:45:00 | 00:00:00
13:00:00 | 15:00:00 |  | 20:15:00 | 06:50:00 | 03:30:00
Spreadsheet: 52761d1252590721-if-statement-to-accumulate-an-amount-in-a-cell-personal-20accounts2-1-
Sheet: Day to Day

 | Day to Day Balance Sheet |  |  | September 09 | Todays Date | 2009-09-10 00:00:00 |  | Key Item Balance
 | Date | Type | Description | Comments | Credit | Debit |  | Description | Spend | Balance
 | 2009-09-01 00:00:00 |  | Food |  | 2 | 1 |  | Food | 4 | -426
 | 2009-09-10 00:00:00 |  | Food |  | 2 |  |  | Socialising | 0 | -100
 |  |  |  |  |  |  |  | Sundries | 0 | -100
 |  |  |  |  |  |  |  | Spending Balance
 |  |  |  |  |  |  |  | Overall Spend to Date | 4
Spreadsheet: 159198d1338547020-consolidating-names-and-values-advname
Sheet: SR1

 |  |  |  |  |  |  |  |  |  |  | Sample Manual Entry
Date | Hd2 | Hd3 | Name / Code |  | Value |  | Emp Name | 1st to 15th | 16th to 31st |  | Emp Name | 1st to 15th | 16th to 31st
2012-04-01 00:00:00 | other data | other data | [NAME] / Some text | other data | 10 |  |  |  |  |  | [NAME]
2012-04-02 00:00:00 |  |  | [NAME] / Some text |  | 20 |  |  |  |  |  | [NAME]
2012-04-03 00:00:00 |  |  | Apple |  | 40 |  |  |  |  |  | [NAME]
2012-04-04 00:00:00 |  |  | [NAME] / Some text |  | 5 |  |  |  |  |  | Franchis
2012-04-05 00:00:00 |  |  | Mango |  | 50 |  |  |  |  |  | George
2012-04-06 00:00:00 |  |  | Grapes |  | 12
2012-04-07 00:00:00 |  |  | Franchis / Some text |  | 30
2012-04-08 00:00:00 |  |  | [NAME] text |  | 10
2012-04-09 00:00:00 |  |  | [NAME] / Some text |  | 20
2012-04-10 00:00:00 |  |  | Apple |  | 40
2012-04-11 00:00:00 |  |  | [NAME] / Some text |  | 5
2012-04-12 00:00:00 |  |  | Mango |  | 50
2012-04-13 00:00:00 |  |  | Grapes |  | 12
2012-04-14 00:00:00 |  |  | Franchis / Some text |  | 30
2012-04-15 00:00:00 |  |  | [NAME] text |  | 10
2012-04-16 00:00:00 |  |  | [NAME] / Some text |  | 20
2012-04-17 00:00:00 |  |  | Apple |  | 40
2012-04-18 00:00:00 |  |  | [NAME] / Some text |  | 5
2012-04-19 00:00:00 |  |  | Mango |  | 50
2012-04-20 00:00:00 |  |  | Grapes |  | 12
2012-04-21 00:00:00 |  |  | Franchis / Some text |  | 30
Spreadsheet: 119291d1314301201-excel-2007-how-do-i-total-cell-values-using-different-values-supplierreport
Sheet: Data

Date | Month | Transport | Order Id | Tracking No | Rate | Entered By | Supplier | Invoice No. | Mat No.
2011-01-01 00:00:00 | 1 | Air | 123 |  |  |  | ABC
2011-02-01 00:00:00 | 2 | Road | 124 |  |  |  | BCD
2011-03-01 00:00:00 | 3 | Sea | 125 |  |  |  | CDE
2011-04-01 00:00:00 | 4 | Air | 126 |  |  |  | DEF
Spreadsheet: 55096d1255192990-removing-empty-rows-with-a-macro-example
Sheet: Sheet1

 | Hardware and Software
 | Part Number | Description | Qty | Unit Price | Sub Total
 | cp-7941g | Cisco IP Phone 7941 | 2 | 23.53 | 47.06
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 | Total
 | Major [NAME]
 | Part Number | Description | Qty | Unit Price | Sub Total
 | 0 | 0 | 0 | Unit Sale | Total Sale
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 |  | Total
 | Professional Services
 |  | Description | Qty | Unit Price | Sub Total
 |  | Total
 |  | Support
 |  | Description | Qty | Unit Price | Sub Total
 |  | Total
Spreadsheet: 07ff2045-923f-46e5-a323-5f5d11c695a7
Sheet: Sheet1

City Officials Report: Personal Gifts Received | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
For Quarter Ending 12/31/2012
(As of 1/25/2013)
Official | Title | Date | Lobbying Entity | Lobbyist(s) | Subject(s) | Other | Value | Description
Adams, Sam | Mayor | 2012-10-02 00:00:00 | Unregistered Entity | Highlight This Line, Enter Data in | Education | Speak at Conference | 640 | Catalyst Space (GA)
Adams, Sam | Mayor | 2012-10-12 00:00:00 | Unregistered Entity | Highlight This Line, Enter Data in | Other | Speak at Annual LGBTQ Dinner | 150 | Basic Rights Oregon
Adams, Sam | Mayor | 2012-11-10 00:00:00 | Unregistered Entity | Highlight This Line, Enter Data in | Transportation: streets, sidewalks and street lighting | Speak at Annual Awards Gathering | 35 | Weston Pedestrian Coalition
Adams, Sam | Mayor | 2012-12-07 00:00:00 | Unregistered Entity | Highlight This Line, Enter Data in | Arts and Culture | Speak at Annual RACC Gathering | 175 | Regional Arts & Culture Council
Brewster, Stacy | At-will staff for Comm. Saltzman | 2012-10-12 00:00:00 | Unregistered Entity | Highlight This Line, Enter Data in | Other | Travel Portland | 65.03 | [NAME]
Fish, [NAME] | Commissioner | 2012-11-14 00:00:00 | Unregistered Entity | Highlight This Line, Enter Data in | Labor |  | 24.99 | Book rec'd in the mail, Shadowbosses by Mallory Factor, from Center for Union Facts, WA DC. Received on behalf of the City.
Fish, [NAME] | Commissioner | 2012-12-17 00:00:00 | Unregistered Entity | Highlight This Line, Enter Data in | Arts and Culture |  | 191.84 | Framed print of a train from Oregon Rail Heritage Foundation. Received on behalf of the City
Fritz, Amanda | Commissioner | 2012-11-04 00:00:00 | Unregistered Entity | Highlight This Line, Enter Data in | Other |  | 100 | Guest of The Standard at PHAME fundraiser
[NAME], [NAME] | International Affairs Director | 2012-10-24 00:00:00 | Unregistered Entity | Highlight This Line, Enter Data in | International Affairs |  | 10 | Tie from Suzhou delegation
[NAME], [NAME] | International Affairs Director | 2012-10-25 00:00:00 | Unregistered Entity | Highlight This Line, Enter Data in | International Affairs |  | 25 | Tie from Utrecht delegation
Spreadsheet: 686520d1594665780-identifying-top-vendors-who-contribute-to-refunds-and-top-70-items-for-refunds-power-pivot-sample-data
Sheet: Top 70% items for Pre-sell

Itemid | Count of orders | Sum of Refunds | Backorder | itemid | Total Refund |  | TicketReason | Backorder
 |  |  |  | 6549 | 6898
 |  |  |  | 3856 | 6762 |  | itemid | Sum of Refunds | Sum of Refunds 2
 |  |  |  | 7639 | 6067 |  | 6549 | 6898 | 0.1404487518833734
 |  |  |  | 6566 | 5856 |  | 3856 | 6762 | 0.278128435883862
 |  |  |  | 8839 | 5456 |  | 7639 | 6067 | 0.4016573685710795
 |  |  |  |  |  |  | 6566 | 5856 | 0.5208901738811744
 |  |  |  |  |  |  | 8839 | 5456 | 0.6319786618886671
 |  |  |  |  |  |  | 2369 | 5140 | 0.7366331392271043
 |  |  |  |  |  |  | 3571 | 5001 | 0.8384574663028872
 |  |  |  |  |  |  | 8570 | 2915 | 0.8978091786456001
 |  |  |  |  |  |  | 2478 | 2718 | 0.9531498147167814
 |  |  |  |  |  |  | 3811 | 2091 | 0.9957242334161339
 |  |  |  |  |  |  | 6825 | 210 | 1
 |  |  |  |  |  |  | Grand Total | 49114
Spreadsheet: lisa_gang__22237__Edwards December Schedule
Sheet: December

December
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | [NAME] | [NAME] | [NAME]
1 | 22 |  |  |  |  |  | 15
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 192404d1352397071-need-help-with-formulas-from-one-sheet-to-another-sheet-ww-working-book-v1
Sheet: Internal

Internal Wall Walk
2012-11-05 00:00:00
Task A
 | Task B
 | Task D | Task D
Spreadsheet: 764949d1643091321-1-how-to-create-a-list-based-on-user-input-2-previous-values-based-on-the-last-occurance-questions-ans-v1
Sheet: Q1

Name | Profit | Most profitable List | Total Profit |  | UNIQUE NAMES | Total Profit | Profit Rank | USER INPUT: | 8 | PLEASE ENTER A VALUE TO KNOW THE MOST PROFITABLE NAMES
ABC | 600 |  |  |  |  |  | 3
RST | 400 |  |  |  |  |  | 2
XYZ | 300 |  |  |  |  |  | 1
ABC | -50 |  |  |  |  |  | 6
MNO | 200 |  |  |  |  |  | 8
RST | 600 |  |  |  |  |  | 5 | [NAME] needed for J1 such that:
QWE | 150 |  |  |  |  |  | 11 | if user input is, let's say, 5, then list of top 5 profitable names should appear in Col C along with their respective total profit in Col D
RST | -150 |  |  |  |  |  | 4 | but if user input is, let's say 7, then top 7 names along with their total profits to appear in Col C & D
LKJ | 300 |  |  |  |  |  | 9 | The list shd appear such that most profitable name shd be on the top (decending profit)
DFG | -350 |  |  |  |  |  | 7
UYT | 400 |  |  |  |  |  | 10
HGY | 100
ZXC | 200
BVC | 50
XYZ | 800
ABC | 200
 |  | List is more than 8 because there are 2 companies with profit 600 and 400
Spreadsheet: 04cf6079-2572-440f-8027-56a1ae1977db
Sheet: T30

الجدول 30: تقديرات السكان حسب فئات العمر والمواطنون/غير مواطنين وحضر/ريف والجنس  في الأردن، 2011
Table 30: Population etimates by age groups, nationals/non-nationals, urban/rural and sex in Jordan,  2011
 | Nationals | المواطنون | Non- Nationals | [NAME] | Urban | حضر | Rural | ريف | Total | المجموع | المجموع
[NAME] | رجال | نساء | رجال | نساء | رجال | نساء | رجال | نساء | رجال | نساء | [NAME]
Age group | Men | Women | Men | Women | Men | Women | Men | Women | Men | Women | Both sexes
0-4 | ... | ... | ... | ... | ... | ... | ... | ... | 409070 | 387890
5-9 | ... | ... | ... | ... | ... | ... | ... | ... | 403930 | 383640
10-14 | ... | ... | ... | ... | ... | ... | ... | ... | 384600 | 363350
15-19 | ... | ... | ... | ... | ... | ... | ... | ... | 353030 | 332770
20-24 | ... | ... | ... | ... | ... | ... | ... | ... | 343050 | 318830
25-29 | ... | ... | ... | ... | ... | ... | ... | ... | 294410 | 264940
30-34 | ... | ... | ... | ... | ... | ... | ... | ... | 254470 | 234960
35-39 | ... | ... | ... | ... | ... | ... | ... | ... | 206150 | 190450
40-44 | ... | ... | ... | ... | ... | ... | ... | ... | 152040 | 143520
45-49 | ... | ... | ... | ... | ... | ... | ... | ... | 106940 | 102040
50-54 | ... | ... | ... | ... | ... | ... | ... | ... | 79230 | 77820
55-59 | ... | ... | ... | ... | ... | ... | ... | ... | 68290 | 70850
60-64 | ... | ... | ... | ... | ... | ... | ... | ... | 63780 | 57220
65-69 | ... | ... | ... | ... | ... | ... | ... | ... | 45444 | 42383
70-74 | ... | ... | ... | ... | ... | ... | ... | ... | 28748 | 28504
75+ | ... | ... | ... | ... | ... | ... | ... | ... | 27918 | 28733
المجموع Total | ... | ... | ... | ... | ... | ... | ... | ... | 3221100 | 3027900
Spreadsheet: a3b49eb7-68e8-46f8-9eb5-ce2c98df4d6e
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
VIP | Test | VIP | Vasoactive Intestinal Polypeptide (VIP), Plasma | Vasoactive Intestinal Polypeptide,P | Radioimmunoassay (RIA) | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Collection Container/Tube: Lavender top (EDTA) Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Fasting (8 hours) 2. Spin down and immediately freeze. Additional Information: This test should not be requested on patients who have recently received radioactive material. | 0.55 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK - refreeze Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <75 pg/mL | Monday, Wednesday; 2 p.m. | 3 days | 8 days | 1 | 84586 |  |  |  |  | Rochester
VIP | [NAME] | PLEDTA | [NAME] |  |  |  | Frozen | 90 days
VIP | Result | 8150 | Vasoactive Intestinal Polypeptide,P | Vasoactive Intestinal Polypeptide,P | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 3125-2 | Vasoactive intestinal peptide:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 14a6a830-835b-4a81-9440-3389ef828f66
Sheet: 3

 | Oct 26 | Nov 2 | Nov 9 | Nov 16 | Nov 23
Total Interest Rates* | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A*** | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equities | 2546944 | 2527141 | 2520234 | 2530602 | 2534908
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Commodities | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated net notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 180590d1347648091-macro-for-copy-and-pasting-duplicates-sample
Sheet: rey

Survey# | Question | Response
1 | rey | I don’t know
2 | rey | yes you know
3 | rey | no I don’t
4 | rey | maybe I do
5 | rey | im not sure
6 | rey | yes im sure
7 | rey | maybe im sure
8 | rey | maybe im not sure
9 | rey | im ok
10 | rey | im not ok
11 | rey | maybe im ok
12 | rey | maybe im not ok
13 | rey | im good
14 | rey | im not good
15 | rey | maybe im good
16 | rey | maybe im not good
17 | rey | im cold
18 | rey | im not cold
19 | rey | maybe im cold
20 | rey | maybe im not cold
 | expected outcome
Spreadsheet: cab29d86-b099-49f5-b8ac-1b21c201a6f5
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43927950 | 2014-11-08 09:18:28 | ALLIES | 1 | 7 | 4 | 979406 | homez | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44028408 | 2014-11-15 07:38:11 | ALLIES | 1 | 5 | 3 | 1254858 | Hougoumont | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
44041554 | 2014-11-16 02:15:04 | AXIS | 1 | 6 | 2 | 1515794 | Bodega28 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44041731 | 2014-11-16 02:33:18 | ALLIES | 0 | 2 | 6 | 1515794 | Bodega28 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44041909 | 2014-11-16 02:55:11 | AXIS | 1 | 6 | 3 | 1659842 | j_intrepid | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
44042103 | 2014-11-16 03:12:44 | ALLIES | 0 | 0 | 6 | 1659842 | j_intrepid | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut