tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5660__HPLN0104
Sheet: Sheet1

HPLN0104.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - Januar 4, 2001
 |  |  |  |  |  | **Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-01-04 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL | 30 | 0 | *
 |  | Firm Summary
Enron (S) |  | Texoma |  | Enron | 15 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 39488d1237695264-excel-2007-pie-chart-that-responds-to-filtering-675289
Sheet: Sheet1

 |  |  |  |  |  |  |  | Choose month |  | Choose year |  |  |  |  |  |  |  |  |  | Choose Week |  | 11
 |  |  |  |  |  |  |  | March |  | 2009 |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  | 1 | Sun
[NAME] |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 2 | Mon
[NAME] |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 3 | Tue
[NAME] |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  | 4 | Wed
 |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 5 | Thur
Start Date | End Date |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 6 | Fri
2009-03-04 00:00:00 | 2009-03-10 00:00:00 |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  | 7 | Sat
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 11
 |  |  |  |  |  |  | 12
 |  |  |  |  |  |  | 13
 |  |  |  |  |  |  | 14
 |  |  |  |  |  |  | 15
 |  |  |  |  |  |  | 16
 |  |  |  |  |  |  | 17
SALESMAN | DATE |  | COMMISION |  |  |  | 18
[NAME] | 2009-03-09 00:00:00 |  | 200 |  |  |  | 19
[NAME] | 2009-03-04 00:00:00 |  | 300 |  |  |  | 20
[NAME] | 2009-03-09 00:00:00 |  | 400 |  |  |  | 21
[NAME] | 2009-03-04 00:00:00 |  | 250 |  |  |  | 22
[NAME] | 2009-03-04 00:00:00 |  | 200 |  |  |  | 23
[NAME] | 2009-03-04 00:00:00 |  | 250 |  |  |  | 24
[NAME] | 2009-03-05 00:00:00 |  | 250 |  |  |  | 25
[NAME] | 2009-03-02 00:00:00 |  | 200 |  |  |  | 26
[NAME] | 2009-03-05 00:00:00 |  | 300 |  |  |  | 27
[NAME] | 2009-03-06 00:00:00 |  | 300 |  |  |  | 28
[NAME] | 2009-03-05 00:00:00 |  | 200 |  |  |  | 29
[NAME] | 2009-03-06 00:00:00 |  | 200 |  |  |  | 30
[NAME] | 2009-03-06 00:00:00 |  | 300 |  |  |  | 31
[NAME] | 2009-03-11 00:00:00 |  | 200
[NAME] | 2009-03-06 00:00:00 |  | 400
[NAME] | 2009-03-02 00:00:00 |  | 400
[NAME] | 2009-03-06 00:00:00 |  | 200
[NAME] | 2009-03-11 00:00:00 |  | 400
[NAME] | 2009-03-02 00:00:00 |  | 400
[NAME] | 2009-03-05 00:00:00 |  | 400
[NAME] | 2009-03-11 00:00:00 |  | 200
[NAME] | 2009-03-09 00:00:00 |  | 250
[NAME] | 2009-03-06 00:00:00 |  | 250
[NAME] | 2009-03-11 00:00:00 |  | 250
[NAME] | 2009-03-02 00:00:00 |  | 250
[NAME] | 2009-03-05 00:00:00 |  | 300
Spreadsheet: 126e1ff5-54ed-4186-a213-f5a9349645c0
Sheet: T40

الجدول 40: [NAME] الولادة للجنسين ، 2000-2010
Table 40: Life expectancy at birth for both sexes, 2000-2010
Country | [NAME] (بالسنوات) |  |  |  |  |  |  |  |  |  |  | البلد
 | Life expectancy at birth for both sexes (years)
 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
Bahrain | … | … | … | … | … | … | … | … | … | … | … | البحرين
Egypt | 68.9 | 69.3 | 69.7 | 70.1 | 70.6 | 71 | 71.4 | 71.8 | 72.15 | 69.15 | … | مصر
Iraq | … | … | … | … | … | … | … | … | … | … | … | العراق
Jordan | … | … | … | … | … | … | … | … | 73 | … | … | الأردن
Kuwait | … | … | … | … | … | … | … | … | … | … | … | الكويت
Lebanon | … | … | … | … | … | … | … | … | … | … | … | لبنان
Oman | 73.4 | 73.8 | 73.8 | 74.3 | 74.3 | 74.3 | 74.3 | 72 | 71.6 | 72.7 | … | عمان
Palestine | … | … | … | … | … | … | … | 71.3 | 71.5 | 71.8 | 72.4 | فلسطين
Qatar | … | … | … | … | … | … | 77 | 77.6 | 78 | 78.2 | 78.2 | قطر
Saudi Arabia | … | … | … | … | 72.8 | 73 | 73.1 | 73.3 | 73.4 | 73.5 | … | المملكة العربية السعودية
Sudan | … | … | … | … | … | … | … | … | … | … | … | السودان
Syrian Arab Republic | … | … | … | … | 72.8 | … | … | … | … | 73.1 | … | سوريا
United Arab Emirates | 78.01 | 77.39 | 78.14 | 77.88 | 79.33 | 77.9 | 77.62 | 76.88 | 77.4 | 77.7 | … | الإمارات العربية المتحدة
Yemen | … | … | … | … | 61.1 | … | … | … | … | 62 | … | اليمن
Spreadsheet: vkaminski__40641__Dec2299
Sheet: Sheet3

 | European Option Pricing
 | Function: EURO
 |  |  |  |  |  |  |  |  | 5393258
 | EffDt
 |  | INPUTS |  |  |  |  |  | OUTPUTS
 |  |  |  |  |  |  |  | 0
Fwd Price | Strike | Ann.IntRt | Yield | Ann.Vol | ExpDt | Call=1/Put=0 |  | Price
27 | 65 | 0.064 | 0 | 0.61 | 2000-06-30 00:00:00 | 0
27 | 65 | 0.064 | 0 | 0.8 | 2000-06-30 00:00:00 | 0
27 | 65 | 0.064 | 0 | 0.9 | 2000-06-30 00:00:00 | 0
27 | 65 | 0.064 | 0 | 1 | 2000-06-30 00:00:00 | 0
Spreadsheet: 739659d1625846257-dependent-drop-down-lists-dd-with-duplicates
Sheet: Material Lists

Material | Colour | Brand | Cost | Roll Weight | Roll Unit | Pr_List | Sec_Help_1 | Sec_Help_2 | Sec_List | Ter_Help_1 | Ter_Help_2 | Ter_Help_3 | Ter_List
PETG | Gray | Zyltech | 84.95 | 5 | Kg
PETG | White | Zyltech | 19.95 | 1 | Kg
PETG | White | Zyltech | 84.95 | 5 | Kg
PETG_ESD | Black | 3DXSTAT | 110 | 1 | Kg
PLA | White | Zyltech | 14.95 | 1 | Kg
[NAME] | Clear | AnyCubic | 34 | 1 | Kg
[NAME] | Green | AnyCubic | 35 | 1 | Kg
TPU | Black | Zyltech | 23.95 | 1 | Kg
TPU | Blue | Zyltech | 23.95 | 1 | Kg
Spreadsheet: 773341d1647800552-extracting-predecessor-as-a-list-data
Sheet: Sheet1

Task ID | Task Name | Predecessor ID | Predecessor List (this is the example of what I need)
1 | Task 1
2 | Task 2
3 | Task 3 | 2 | 2
4 | Task 4 | 3 | 3,2
5 | Task 5 | 3 | 3,2
6 | Task 6 | 5 | 5,3,2
7 | Task 7 | 3 | 3,2
8 | Task 8 | 7 | 7,3,2
9 | Task 9 | 8 | 8,7,3,2
Spreadsheet: 3d359711-151b-4b88-a645-6a91b38eedfc
Sheet: Sheet1

Release: U.S. Import and Export Price Indexes | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=188
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-12-11 11:01 AM CST
 | Real-Time | Period
Name: | Start | End
U.S. Import and Export Price Indexes | 2010-03-16 00:00:00 | Current
Link:
http://www.bls.gov/mxp/ | 2010-03-16 00:00:00 | Current
Source:
U.S. Department of Labor: Bureau of Labor Statistics | 2010-03-16 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-03-16 00:00:00
2010-04-13 00:00:00
2010-05-13 00:00:00
2010-06-15 00:00:00
2010-07-14 00:00:00
2010-08-12 00:00:00
2010-09-15 00:00:00
2010-10-13 00:00:00
2010-11-10 00:00:00
2010-12-10 00:00:00
2011-01-12 00:00:00
2011-02-15 00:00:00
2011-03-15 00:00:00
2011-04-12 00:00:00
2011-05-10 00:00:00
2011-06-10 00:00:00
2011-07-13 00:00:00
2011-08-16 00:00:00
2011-09-13 00:00:00
2011-10-14 00:00:00
2011-11-10 00:00:00
2011-12-14 00:00:00
2012-01-13 00:00:00
2012-02-14 00:00:00
2012-03-14 00:00:00
2012-04-11 00:00:00
2012-05-10 00:00:00
2012-06-12 00:00:00
2012-07-12 00:00:00
2012-08-10 00:00:00
2012-09-12 00:00:00
2012-10-11 00:00:00
2012-11-09 00:00:00
2012-12-12 00:00:00
2013-01-11 00:00:00
2013-02-13 00:00:00
2013-03-13 00:00:00
2013-04-11 00:00:00
2013-05-14 00:00:00
2013-06-13 00:00:00
2013-07-11 00:00:00
2013-08-13 00:00:00
2013-09-12 00:00:00
2013-10-23 00:00:00
2013-11-15 00:00:00
Spreadsheet: 767081d1644276083-need-help-on-spreadsheet-do-i-need-to-use-vlookup-hlookup-index-match-2022-law-dogs-standings
Sheet: Wet Farts

Wet Farts
Wk# | Opponent | W | L | PF | PA | MARGIN
1 | Mudcats
2 | Gator Dawgs
3 | Sharks
4 | Capo Crimini
5 | Thundermutts
6 | King of Queens
7 | Cajun Coonasses
8 | Pics Hitmen
9 | Deadbirds
10 | [NAME]
11 | Muckdogs
12 | Cajun Coonasses
13 | King of Queens
14 | Muckdogs
15 | [NAME]
16 | Thundermutts
17 | Capo Crimini
18 | Deadbirds
19 | Pics Hitmen
20 | Sharks
21 | Gator Dawgs
22 | Mudcats
Spreadsheet: 721165d1614538356-calculation-of-current-year-vs-prior-year-pseudo-slicer-pearl_022-
Sheet: Pivot

Site | (All)
Years | (All)
Row Labels | Sum of Damage | Sum of Injuries | Sum of Reports
Jan | 0 | 10 | 39
Feb | 0 | 3 | 5
Mar | 0 | 4 | 4
Apr | 0 | 2 | 2
May | 0 | 4 | 6
Jun | 0 | 5 | 11
Jul | 0 | 0 | 1
Aug | 0 | 1 | 3
Sep | 0 | 4 | 6
Oct | 0 | 1 | 2
Nov | 0 | 4 | 27
Dec | 0 | 9 | 25
Grand Total | 0 | 47 | 131
Spreadsheet: 69652d1270207848-formatting-problem-attaching-consolidate-target-updated
Sheet: VAS

 | Innovative Private Limited |  | 2009-07-01 00:00:00
 | FORTNIGHT COLLECTION REPORT
 | Value- Added Services
 | 2010-04-02 00:00:00 |  | 275
 | STATIONS | ACTUAL | TARGET | [NAME] | %AGE ACHIVED |  |  | ACTUAL | LAST YEAR AVG | [NAME] | %AGE
 | LHR | 0 | 0 | 0 | #N/A |  |  | 0 | N/A | #N/A | #N/A
 | KHI | 9896325 | 22602739.7260274 | -12706414.7260274 | 0.4378374090909091 |  |  | 9896325 | N/A | #N/A | #N/A
 | ISB | 0 | 0 | 0 | #N/A |  |  | 0 | N/A | #N/A | #N/A
 |  | 9896325 | 22602739.7260274 | -12706414.7260274 | 0.4378374090909091 |  |  | 9896325 | 0 | #N/A | #N/A
Spreadsheet: 704513d1605609265-extract-and-return-a-values-in-a-summary-sheet-from-various-sheets-book1
Sheet: 01.11.2020

Ref | Description |  |  |  |  |  |  |  |  | Man Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plant Hours | Tender-Labour | Tender-Plant | Actual-Labour | Actual-Plant
C001.1 | Labour -Site Related Activities | item |  |  |  |  | 0 | 2 | 10 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 219.2 | 0
C001.1 | Labour -Site Related Activities | item |  |  |  |  | 0 | 3 | 10 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 328.8 | 0
A022 | Backfilling for Utilites | m3 | 36 | 5 | 0.2 | 1 | 36 | 2 | 10 | 20 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2 | 525.6 | 333 | 219.2 | 320
A021 | Excavation for Utilities | m3 | 15 | 8 | 2 | 1 | 240 | 5 | 10 | 50 |  | 25 |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  | 35 | 936 | 2644.8 | 548 | 2825
A021 | Excavation for Utilities | m3 | 10 | 8 | 2.5 | 1 | 200 | 4 | 10 | 40 |  | 20 |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 28 | 780 | 2204 | 438.4 | 2580
A045 | Other-General Works | N/A |  |  |  |  | 0 | 4 | 10 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 438.4 | 0
A032 | 1400mm dia. Pipe laying | m | 15 |  |  | 1 | 15 | 5 | 8.8 | 44 |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 8 | 354.0802993527508 | 477.1475323624596 | 482.24 | 1240
Spreadsheet: 728886d1618764161-count-duplicate-values-if-they-appear-in-the-same-month-example-1
Sheet: Sheet1

Customer Email Address |  |  | Date |  |  |  |  |  | Multiple Subscription
Email Address T |  |  | 2020-12-01 00:00:00
Email Address T |  |  | 2020-12-04 00:00:00
Email Address T |  |  | 2020-12-25 00:00:00
Email Address T |  |  | 2021-01-08 00:00:00
Email Address V |  |  | 2021-01-28 00:00:00
[NAME] |  |  | 2021-02-12 00:00:00
Email Address X |  |  | 2021-01-16 00:00:00
Email Address Y |  |  | 2021-02-05 00:00:00
Email Address Y |  |  | 2021-02-12 00:00:00
Email Address Z |  |  | 2021-01-06 00:00:00
Email Address Z |  |  | 2021-02-06 00:00:00
Spreadsheet: 155207d1336722449-combining-two-functions-weekly-backlog-report-20120424-test-1-
Sheet: Raw Data

TRACKING_ID | CREATED_DATE | SHORT_DESCRIPTION | ASSIGNED_TO | EXPECTED_RESOLUTION_DATE | ACTUAL_DATE | SEVERITY | TYPE | RESOLUTION_DATE | STATUS | SUB_STATUS | SUBTYPE | SUBQUEUE | DIFF | ACTUAL RES DATE | MONTH CREATED | TEAM | [NAME] | MONTH CLOSED | EXP_RES_DATE | Calc | Met SLA | Sev3 (-2) | PH Singapore | PH Malaysia
 | 2012-03-01 00:00:00 | [NAME] | DummyApp | 01-MAR-12 | 04-MAR-12 | Severity 1 | Helpdesk | 04-MAR-12 | Resolved | Closed | Duplicate |  |  | 2012-03-04 00:00:00
 | 2012-03-01 00:00:00 | [NAME] | DummyGov | 01-MAR-12 | 04-MAR-12 | Severity 1 | Helpdesk | 04-MAR-12 | Resolved | Closed | Duplicate |  |  | 2012-03-04 00:00:00 |  |  |  |  |  |  |  | 0
 | 2012-04-01 00:00:00 | [NAME] | DummyApp | 01-APR-12 | 04-APR-12 | Severity 1 | Helpdesk | 04-APR-12 | Resolved | Closed | Duplicate |  |  | 2012-03-04 00:00:00 |  |  |  |  |  |  |  | 0
WO# 10021 | 2012-06-01 00:00:00 | Test 1-July - Process not starting | [NAME] , Anand | 05-JUL-11 | 03-OCT-11 | Severity 3 | Helpdesk | 01-JUL-11 | Resolved | Closed | Information
WO# 12088 | 2011-06-02 00:00:00 | oracle  password locked | [NAME] , Thiruchelvam a/l | 07-JUL-11 | 02-JUL-11 | Severity 3 | [NAME] | 02-JUL-11 | Resolved | Closed | Oracle |  |  | 2011-06-02 00:00:00
WO# 12091 | 2011-06-02 00:00:00 | Your Oracle Account | Vyveganathan , [NAME] a/l | 07-JUL-11 | 02-JUL-11 | Severity 3 | [NAME] | 02-JUL-11 | Resolved | Closed | Oracle |  |  | 2011-06-02 00:00:00
WO# 12137 | 2011-06-02 00:00:00 | BB0 - URGENT for Mth-end Closing | Arumugam , [NAME] | 07-JUL-11 | 12-JUL-11 | Severity 3 | Oracle | 12-JUL-11 | Resolved | Closed | [NAME] (Costing) |  |  | 2011-06-12 00:00:00
WO# 12305 | 2011-06-03 00:00:00 | Cannot Log on via VPN nor to owa.kns.com | Ng , [NAME] | 08-JUL-11 | 03-JUL-11 | Severity 3 | [NAME] | 03-JUL-11 | Resolved | Closed | Network/Cognos/Portal/TWIKI |  |  | 2011-06-03 00:00:00
WO# 12309 | 2011-06-03 00:00:00 | HRIS report - 02 July 2011 | Ng , Yohan | 08-JUL-11 | 12-JUL-11 | Severity 3 | Helpdesk | 12-JUL-11 | Resolved | Closed | HRIS |  |  | 2011-06-12 00:00:00
Spreadsheet: 704996d1605835188-sorting-cell-content-based-on-text-within-text-sorting-cell-content-based-on-text-within-text
Sheet: Sheet1

 | [NAME] | Sort order/Criteria | [NAME], but auto sorted correctly based on Column B's info
 | dpsiliulu01 | dll | dpsdllulu01 |  | Column B contains a string of text that exists in each cell on Column A. "dll" exists in A3, for example.  What I want is to basically sort A2, [NAME], and A4 using B2, B3 and B4 as a guide.  This would be output as seen on Column C.  Hopefully this is possible, thank you for any help you can provide!
 | dpsdllulu01 | rrr | dpsrrrulu01
 | dpsrrrulu01 | ili | dpsiliulu01
 | [NAME] |  | [NAME]
 | [NAME] |  | dpsrrrulu02
 | dpsrrrulu02 |  | [NAME]
sort duplicate criteria
 | dpsiliulu03 |  | dpsdllulu03
 | [NAME] |  | [NAME]
 | dpsdllulu03 |  | dpsiliulu03
Spreadsheet: 147744d1332951883-i-need-to-match-information-from-one-table-to-information-in-another-example
Sheet: Sheet1

 | Table one |  |  |  |  |  | Table two
Category | Keyword |  |  |  |  | Category | Keyword
GENERIC | currency exchange |  |  |  |  |  | currency exchange
Pure Brand | count cash |  |  |  |  |  | ipayfx login
BRAND | www.countcash.com |  |  |  |  |  | www.countcash.com
GENERIC | ipayfx |  |  |  |  |  | ipayfx
BRAND | currenciesdirect |  |  |  |  |  | [NAME] group
GENERIC | money exchange |  |  |  |  |  | money exchange
GENERIC | dollars to pounds |  |  |  |  |  | dollars to pounds
GENERIC | telegraphic transfer |  |  |  |  |  | currencies direct uk
GENERIC | i payfx |  |  |  |  |  | i payfx
GENERIC | forward contract |  |  |  |  |  | forward contract
BRAND | currencies direct uk |  | Need to fill this column |  |  |  | commercial currency
BRAND | foreign currency direct |  |  |  |  |  | foreign currency direct
BRAND | currenciesdirect.com |  |  |  |  |  | currenciesdirect.com
GENERIC | ipayfx login |  |  |  |  |  | foreign currency dealers
GENERIC | pounds to dollars |  |  |  |  |  | pounds to dollars
BRAND | https://countcash |  |  |  |  |  | https://countcash
BRAND | currencies direct exchange rates |  |  |  |  |  | currencies direct exchange rates
BRAND | currencies direct online |  |  |  |  |  | currenciesdirect
BRAND | www.currenciesdirect.co.uk |  |  |  |  |  | urrencies direct
BRAND | currencies direct login |  |  |  |  |  | www.i-payfx.com
BRAND | curenciesdirect |  |  |  |  |  | curenciesdirect
GENERIC | current currency rates |  |  |  |  |  | current currency rates
GENERIC | www.i-payfx.com |  |  |  |  |  | international currency exchange
GENERIC | ipay fx |  |  |  |  |  | ipay fx
GENERIC | gbp to usd |  |  |  |  |  | gbp to usd
BRAND | http://www.countcash.com/info-centre/todays-rates/ |  |  |  |  |  | http://www.countcash.com/info-centre/todays-rates/
BRAND | currencies direct rates |  |  |  |  |  | currencies direct rates
BRAND | currency direct exchange rates |  |  |  |  |  | www.currenciesdirect.co.uk
Spreadsheet: 34219d1231358954-multiple-cells-in-new-row-multiple-cells-in-new-row
Sheet: Sheet2

[NAME] | Assignment1
[NAME] | Assignment2
[NAME] | Assignment3
[NAME] | Assignment1
[NAME] | Assignment2
[NAME] | Assignment1
[NAME] | Assignment2
[NAME] | Assignment3
[NAME] | Assignment4
#N/A | #N/A
#N/A | #N/A
#N/A | #N/A
#N/A | #N/A
#N/A | #N/A
#N/A | #N/A
#N/A | #N/A
#N/A | #N/A
#N/A | #N/A
Spreadsheet: 725851d1616929874-lookup-first-instance-w-criteria-sample-vlookup-w-criteria
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CIM |  | Result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLAT | Desired Result is in Row 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flat |  |  |  | Agnc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I would like to find the first instance of "Flat" That Matches the Symbol Criteria. In my Case would Be Symbol CIM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basically Asking formula to:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Open |  |  |  | NLY |  | Look up Symboly CIM in Column AA then if [NAME] in Column W = "Flat" then result should be "Flat" orelse 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | And the formula will eventually be copied down In column AD With last Row Locked
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flat |  |  |  | CIM |  | In Cell AG39 is the actual formula I am currently using
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thank you:)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Closed |  |  |  | CIM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flat |  |  |  | FSK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Open |  |  |  | CIM
Spreadsheet: 138619d1327768574-excel-2007-performing-calculations-in-cells-2012-income
Sheet: last nov

2011-11-21 00:00:00
0 |  | yes | Amount | Taxable Merch | Shipping Taxable | Sales Tax Payable | Non- taxable Merch | Shipping Non-Taxable | Income Tax Income | MiscellaneousNon- Taxable | Owner Loan
Received From | Check No | Invoices Paid | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 838214d1690821777-proportional-distribution-of-leave-taking-team-1-attendance-sheet-dph
Sheet: Lookups

[NAME] | [NAME] | Lead SEHO
WAH | 0.5 UCSL WAH | TRACES
RD | 0.5 CSL WAH | [NAME]
AL | 0.5 AL 0.5 PHL | Handover
0.5 AL | 0.5 Comp 0.5 PHL | Absent
PHL | 0.5 AL 0.5 Comp
0.5 PHL | 0.5 AL 0.5 WAH | PE
Comp | 0.5 PHL 0.5 Yard 4 | IHR
0.5 Comp | 0.5 Comp 0.5 Yard 4 | Manifest
USL | 0.5 AL WAH | MDOH
CSL | [NAME] | Control Reports
Training | Other | PH Inbox
Meeting | 0.5 T 0.5 AL | Booking in LoLo
PRTL L | 0.5 T 0.5 Comp | Detention
SWY | 0.5 T 0.5 PHT
UPL | Compassionate
[NAME] | WAH
PRTS L | RD
0.5 UCSL WAH | AL
0.5 CSLWAH | 0.5 AL
0.5 AL 0.5 PHL | PHL
0.5 Comp 0.5 PHL | 0.5 PHL
0.5 AL 0.5 Comp | Comp
0.5 AL 0.5 WAH | 0.5 Comp
0.5 PHL 0.5 WAH | 0.5 Comp WAH
[NAME] | CSL
Other | Training
0.5 T 0.5 AL | Meeting
0.5 T 0.5 Comp | Prt L
0.5 T 0.5 PHL | SWY
Compassionate | UPL
0.5 Comp WAH | [NAME]
0.5 AL WAH | Prts L
0.5 T 0.5 WAH
Spreadsheet: 330761d1404845452-formula-to-lookup-and-sum-data-on-different-sheets-sample-survey-1-
Sheet: Day 1

 |  |  | Total Participants: | 6
Date | Facilitator(s): |  | Evaluations Received: | 6
 | Instructor 1 |  | Topics Covered:
 | Instructor 2
Trainer Feedback
Question | [NAME] | [NAME] | [NAME] | Disagree Strongly | n/a
All of my questions were answered or documented for followup | 6 | 0 | 0 | 0 | 0
The speaker presented the material at a pace that was appropriate | 4 | 2 | 0 | 0 | 0
The speaker was confident in the delivery of the subject matter | 6 | 0 | 0 | 0 | 0
The speaker demonstrated a good understanding of the material | 6 | 0 | 0 | 0 | 0
Participation and interaction were encouraged | 3 | 3 | 0 | 0 | 0
Course Content Feedback
Question | [NAME] | [NAME] | [NAME] | Disagree Strongly | n/a
The training aids used assisted in my learning | 3 | 3 | 0 | 0 | 0
I will be able to apply the skills/information to my work | 4 | 2 | 0 | 0 | 0
The material was the right level of complexity for my background | 4 | 2 | 0 | 0 | 0
The content was organized and easy to follow | 3 | 3 | 0 | 0 | 0
The time allotted for training was sufficient | 3 | 2 | 1 | 0 | 0
 | Yes | No | No Answer
Would you recommend this presentation to your co-workers? | 6 | 0 | 0
Additional Comments
Spreadsheet: 711631d1609815070-add-values-each-month-based-on-a-ramp-up-model-rampup-model
Sheet: Sheet1

MODEL - STANDARD SALESMAN PERFORMANCE
"Standard" months |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Sales |  | 0 | 10 | 15 | 30 | 35 | 40 | 50 | 60 | 80 | 120 | 150 | 200
Variable Costs
Fixed Costs |  | -5 | -5 | -5 | -5 | -5 | -10 | -10 | -10 | -10 | -10 | -10 | -10
 | Gross Profit (Sales - Variable Costs - Fixed Costs
Month | Hires | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
2021-01-01 00:00:00 | 0
2021-02-01 00:00:00 | 0
2021-03-01 00:00:00 | 1
2021-04-01 00:00:00 | 1
2021-05-01 00:00:00 | 0
2021-06-01 00:00:00 | 0
2021-07-01 00:00:00 | 1
2021-08-01 00:00:00 | 1
2021-09-01 00:00:00 | 1
2021-10-01 00:00:00 | 0
2021-11-01 00:00:00 | 1
2021-12-01 00:00:00 | 0
GROSS PROFIT:
Spreadsheet: 779864d1652156499-populate-calendars-based-on-office-location-daf-office-scheduling-draft-aligw
Sheet: WFH

Month: | May
Year: | 2022
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2 | 3 | 4 | 5 | 6 | 7
Spreadsheet: 129928d1321977343-how-do-i-get-a-cell-to-sum-based-on-two-criteria-drainage-material-pipe
Sheet: Drain order

 |  | Pipework
 |  | [NAME] | Length | m less junct, soc, spig rocker | No of Pipes | Type
 |  | 0.15 | 1.25 |  |  |  | Plastic |  | This needs to look up the correct pipe size | but also only sum it if it is plastic
 |  | 0.15 | 1.25 |  |  |  | Clay |  | This needs to look up the correct pipe size | but also only sum it if it is clay
 |  | 0.225 | 1.25 |  |  |  | Plastic |  | This needs to look up the correct pipe size | but also only sum it if it is plastic
 |  | 0.225 | 1.25 |  |  |  | Clay |  | This needs to look up the correct pipe size | but also only sum it if it is clay
 |  | 0.3 | 1.25 |  |  |  | Plastic |  | This needs to look up the correct pipe size | but also only sum it if it is plastic
 |  | 0.3 | 1.25 |  |  |  | Clay |  | This needs to look up the correct pipe size | but also only sum it if it is clay
 |  | 0.3 | 1.25 |  |  |  | Concrete |  | This needs to look up the correct pipe size | but also only sum it if it is concrete
 |  | 0.375 | 2.5
 |  | 0.45 | 2.5
 |  | 0.525 | 2.5
 |  | 0.6 | 2.5
 |  | 0.675 | 2.5
 |  | 0.75 | 2.5
 |  | 0.825 | 2.5
 |  | 0.9 | 2.5
 |  | 1.05 | 2.5
 |  | 1.2 | 2.5
 |  | 1.5 | 2.5
 |  | 1.6 | 2.5
 |  | 1.8 | 2.5