tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 60803d1261400422-excel-graphs-711406-excel-graphs
Sheet: Sheet4

Search Engine | (All)
Sum of Work Rank | Month
Keyword | January | February | Grand Total
keyword13 | 82 | 82 | 164
[NAME] | 79 | 79 | 158
keyword34 | 60 | 60 | 120
keyword25 | 41 | 41 | 82
keyword10 | 40 | 40 | 80
keyword4 | 37 | 37 | 74
keyword20 | 31 | 31 | 62
[NAME] | 29 | 29 | 58
keyword6 | 26 | 26 | 52
[NAME] | 23 | 23 | 46
keyword7 | 23 | 23 | 46
keyword12 | 21 | 21 | 42
keyword28 | 21 | 21 | 42
keyword32 | 20 | 20 | 40
keyword9 | 18 | 18 | 36
keyword24 | 17 | 17 | 34
keyword1 | 16 | 16 | 32
keyword22 | 14 | 14 | 28
keyword5 | 12 | 12 | 24
[NAME] | 11 | 11 | 22
keyword18 | 10 | 10 | 20
[NAME] | 9 | 9 | 18
keyword8 | 9 | 9 | 18
keyword2 | 8 | 8 | 16
keyword30 | 8 | 8 | 16
keyword33 | 8 | 8 | 16
keyword11 | 7 | 7 | 14
keyword3 | 7 | 7 | 14
keyword17 | 6 | 6 | 12
[NAME] | 6 | 6 | 12
keyword21 | 0 | 0 | 0
keyword23 | 0 | 0 | 0
[NAME] | 0 | 0 | 0
keyword29 | 0 | 0 | 0
Grand Total | 699 | 699 | 1398
Spreadsheet: 123673d1317801706-average-vlookup-over-multiple-sheets-test-data-file2
Sheet: TOTALS

Flight | [NAME]
vx921
vx751
VX917
VX29
vx357
1
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
Spreadsheet: 811651d1672732595-similars-where-last-3-letters-equal-to-first-3-temp
Sheet: Sheet1

KAFILAS
TAILFAN
INFANTA
SIFAKAS
ALFAQUI
FANTAIL
Spreadsheet: 84953d1285054130-one-payment-multiple-dates-summation-one-payment-multiple-dates
Sheet: Original Sample

Payment | date | date | date
25 | 5/14/2009 | 2009-07-14 00:00:00 | 09/14/2009
50 | 05/15/2009 | 09/15/2009 | 01/15/2010
 | Sum amt Month
2009-05-01 00:00:00 | 75
2009-06-01 00:00:00 | 0
 | 25
 | 0
 | 75
 | 0
 | 0
 | 0
 | 50
Spreadsheet: 0791d3d9-ae77-4c49-bd54-8b3347914f8a
Sheet: 1999-00

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 | 3334 | 86 |  | 1047 | 778
South East | 2399 | 35 |  | 567 | 372
South West | 705 | 2 |  | 130 | 47
North and Yorkshire | 318 | 4 |  | 103 | 32
North West | 368 | 3 |  | 78 | 15
Midlands | 611 | 8 |  | 136 | 61
East Anglia | 298 | 3 |  | 81 | 125
Not Known | 1 | 0 |  | 13 | 6
Subtotal
Northern Ireland | 34 | 0 |  | 13 | 33
Scotland | 94 | 1 |  | 64 | 19
Wales | 207 | 5 |  | 46 | 10
Channel Isles and Isle of Man | 39 | 0 |  | 2 | 0
Not Known | 27 | 19 |  | 3 | 24
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.
Spreadsheet: 81827d1281979696-dynamic-lists-lists
Sheet: Sheet1

 | 4
 | 4th_ListValue_14 | <<<< Do You mean like this??? |  | List | 1 | 2 | 3 | 4 | 5
 |  |  |  | 1 | 1stListValue_1 | 2nd_ListValue_1 | 3rd_ListValue_1 | 4th_ListValue_1 | 5th_ListValue_1
 |  |  |  | 2 | 1stListValue_2 | 2nd_ListValue_2 | 3rd_ListValue_2 | 4th_ListValue_2 | 5th_ListValue_2
 |  |  |  | 3 | 1stListValue_3 | 2nd_ListValue_3 | 3rd_ListValue_3 | 4th_ListValue_3 | 5th_ListValue_3
 |  |  |  | 4 | 1stListValue_4 | 2nd_ListValue_4 | 3rd_ListValue_4 | 4th_ListValue_4 | 5th_ListValue_4
 |  |  |  | 5 | 1stListValue_5 | 2nd_ListValue_5 | 3rd_ListValue_5 | 4th_ListValue_5 | 5th_ListValue_5
 |  |  |  |  | 1stListValue_6 | 2nd_ListValue_6 | 3rd_ListValue_6 | 4th_ListValue_6 | 5th_ListValue_6
 |  |  |  |  | 1stListValue_7 | 2nd_ListValue_7 | 3rd_ListValue_7 | 4th_ListValue_7 | 5th_ListValue_7
 |  |  |  |  | 1stListValue_8 | 2nd_ListValue_8 | 3rd_ListValue_8 | 4th_ListValue_8 | 5th_ListValue_8
 |  |  |  |  | 1stListValue_9 | 2nd_ListValue_9 | 3rd_ListValue_9 | 4th_ListValue_9 | 5th_ListValue_9
 |  |  |  |  | 1stListValue_10 | 2nd_ListValue_10 | 3rd_ListValue_10 | 4th_ListValue_10 | 5th_ListValue_10
 |  |  |  |  | 1stListValue_11 | 2nd_ListValue_11 | 3rd_ListValue_11 | 4th_ListValue_11 | 5th_ListValue_11
 |  |  |  |  | 1stListValue_12 | 2nd_ListValue_12 | 3rd_ListValue_12 | [NAME] | 5th_ListValue_12
 |  |  |  |  | 1stListValue_13 | 2nd_ListValue_13 | 3rd_ListValue_13 | 4th_ListValue_13 | 5th_ListValue_13
 |  |  |  |  | 1stListValue_14 | 2nd_ListValue_14 | 3rd_ListValue_14 | 4th_ListValue_14 | 5th_ListValue_14
 |  |  |  |  | 1stListValue_15 | 2nd_ListValue_15 | 3rd_ListValue_15 | 4th_ListValue_15 | 5th_ListValue_15
 | Used [NAME]
Spreadsheet: 750089d1633240526-find-a-text-in-a-sentence-column-search-text_gw-ans
Sheet: Main

FACT_TABLE | CORE_TABLE | QUERY | Expected | Flame-1 | Flame-2 | GW | [NAME] | kvsrinivasamurthy
RESI_ADDR | EMP_DEMO | SELECT A.SAL, A.ADDR FROM EMP_DSI A GROUP BY 1,2 | True
COUNTY | EMP_QUAL | SELECT A.BAL, B.HLTH FROM EMP_FI A, EMP_SE B WHERE A.ID = B.ID | False
EDUCATION | EMP_BIO | SELECT A.RESI_ADDR, A.LOC FROM EMP_DEMO A GROUP BY 1,2 | False
Spreadsheet: 0ea30a4d-9206-4b83-ba79-169357a5490c
Sheet: SCC Year One

 | Budget FY2012-13 Period
Code:
District: |  |  | FUNDING IS DEPENDENT ON APPROPRIATIONS MADE EACH YEAR
 |  | YEAR 1               7/1/14 - 6/30/15 | Description of YEAR ONE Period Expenditure Activity-MUST INCLUDE FTE OR [NAME] AND ESTIMATED HOURS TO BE WORK
1 | Current Year Allocation
2 | Prior Year Carryover
2a | (Carryover is Estimate or Actual)
3 | Total Funds Available (lines 1, 2, 2a, & 3)
Instructional Program   (0010 – 2000)
 | Salaries (0100) | 0
 | Employee Benefits (0200) | 0
 | Purchased Professional & Technical Services (0300) | 0
 | Other Purchased Services (0500) |  | 0
 | Supplies (0600) | 0
 | Other (0800) | 0
 | Subtotal Instructional Program (lines 4 through 9)(not allowed on this Part)
Support Program   (2100, 2200, 2600, 2700, 2800, 2900, and 3300)
 | Salaries (0100) | 0
 | Employee Benefits (0200) | 0
 | Purchased Professional & Technical Services (0300) | 0
 | Purchased Property Services (0400) | 0
 | Other Purchased Services (0500) | 0
 | Supplies (0600) | 0
 | Other (0800) | 0
 | Subtotal Support Program (lines 11 through 17)(not allowed on this Part)
Improvement of Instructional Services (2210)
 | Salaries (0100) | 0
 | Employee Benefits (0200) | 0
 | Purchased Professional & Technical Services (0300) | 0
 | Other Purchased Services (0500) | 0
 | Supplies (0600) | 0
 | Other (0800) | 0
 | Equipment | 0
 | TOTAL BUDGET REQUESTED:
 | [NAME] IS NOT ALLOWED ON THIS GRANT
Spreadsheet: 715230d1611615316-sumif-and-eomonth-formula-commissiontracker_sample
Sheet: NEWTRACKER

Creation Date | Decedent | Sale Amount | Amt. Paid | Running Total (MTD) | Potential Commission | Referral | Referred By | Date Paid In Full | Referral Fee | Referral Fee Paid | Done | Paid For | Actual Earned | Advance % | Advance $ | Month | Year | PRODUCT CALC
2021-01-21 00:00:00 | reese | 2000 | 1146.37 |  |  | NO |  |  |  |  | True
2021-01-21 00:00:00 | [NAME] | 5000 | 2500 |  |  | YES | Jes
2021-01-21 00:00:00 | [NAME] | 50000 | 10000 |  |  | YES | [NAME]
2021-01-21 00:00:00 | JONES | 6000
2021-01-21 00:00:00 | another | 5000 | 100
Spreadsheet: 808469d1670487548-combine-2-sheets-analysis3
Sheet: SHEET4

HALMASHAURI YA WILAYA [NAME]
MATOKEO YA MTIHANI WA KUMALIZA MUHULA WA PILI DARASA LA TATU, NOVEMBA 2022
D. NAFASI YA SHULE KWA ASILIMIA [NAME] MWANAFUNZI
NA | SHULE | KATA | WALIOFANYA |  |  | WALIOFAULU |  |  | A |  |  | B |  |  | C |  |  | % [NAME] | WASTANI WA ALAMA | D |  |  | E |  |  | % YA WALIOFELI | [NAME] SHULE
 |  |  | WAV | WAS | JML | WAV | WAS | JML | WAV | WAS | JML | WAV | WAS | JML | WAV | WAS | JML |  |  | WAV | WAS | JML | WAV | WAS | JML
1 | KALOLENI
2 | SHEKINA |  | 4 | 2 | 6 | 4 | 2 | 6 | 4 | 2 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 288 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 05484fe2-fce9-42ae-9f93-5108eb901d1c
Sheet: GPA Calculator

SBE Undergraduate Admissions GPA Calculator
Course | Course Title | SBE                                  Letter Grade | Numerical Grade | Credits |  |  |  |  | [NAME]. | Lookup Table |  | Type in your letter grades, with + or - designations, in the pink cells for the appropriate courses (with no spaces) and your SBE admission GPA and total credits will be automatically computed.
ECN 2102 | Principles of Microeconomics |  |  |  |  |  |  |  |  | A | 4
ECN 2102 | Principles of Macroeconomics |  |  |  |  |  |  |  |  | A- | 3.7
ACCT 2361 | Financial Accounting |  |  |  |  |  |  |  |  | B | 3
ACCT 2362 | Managerial Accounting |  |  |  |  |  |  |  |  | B- | 2.7
BUS 1700 | Spreadsheets |  |  |  |  |  |  |  |  | [NAME] | 3.3
BUS 2000 | Purpose & Practice of Business |  |  |  |  |  |  |  |  | C | 2
BUS 2414 | Legal Environment of Business |  |  |  |  |  |  |  |  | C- | 1.7 | You may only type letter grades in the  pink cells.
BUS 2600 | Managerial Communication |  |  |  |  |  |  |  |  | C+ | 2.3
BUS 2700 | Statistics for Business & Econ |  |  |  |  |  |  |  |  | D | 1
BUS 2910 | Internship & Career Strategies |  |  |  |  |  |  |  |  | [NAME] | 1.3
BUS 3250 | Business Finance |  |  |  |  |  |  |  |  | E | 1e-10
BUS 3541 | Marketing and Society
BUS 3620 | Management Information Systems
BUS 3828 | International Business
 | Other SBE course (1 credit)
 | Other SBE course (3 credits)
 | Other SBE course (5 credits)
 | Other SBE course (5 credits)
 | Other SBE course (5 credits)
 | Total SBE credits =
 | SBE GPA =
 |  |  |  |  |  |  |  |  |  |  |  | To the SBE Home page.
Please contact Dr. [NAME] if you have questions about this SBE grade calculator. |  |  |  |  |  |  |  |  |  |  |  | To the SPU Home page.
Spreadsheet: 605370d1547051723-alphabetize-column-while-moving-associated-data-alphabetize-help-please
Sheet: Summary

PartnerName | 2019-01-01 00:00:00 | 2019-01-02 00:00:00 | 2019-01-03 00:00:00 | 2019-01-04 00:00:00 | 2019-01-05 00:00:00 | 2019-01-06 00:00:00 | 2019-01-07 00:00:00 | 2019-01-08 00:00:00 | 2019-01-09 00:00:00 | 2019-01-10 00:00:00 | 2019-01-11 00:00:00 | 2019-01-12 00:00:00 | 2019-01-13 00:00:00 | 2019-01-14 00:00:00 | 2019-01-15 00:00:00 | 2019-01-16 00:00:00 | 2019-01-17 00:00:00 | 2019-01-18 00:00:00 | 2019-01-19 00:00:00 | 2019-01-20 00:00:00 | 2019-01-21 00:00:00 | 2019-01-22 00:00:00 | 2019-01-23 00:00:00 | 2019-01-24 00:00:00 | 2019-01-25 00:00:00 | 2019-01-26 00:00:00 | 2019-01-27 00:00:00 | 2019-01-28 00:00:00 | 2019-01-29 00:00:00 | 2019-01-30 00:00:00 | 2019-01-31 00:00:00
ABC
DEF
GHI
JKL
MNO
Spreadsheet: 772187d1647056120-trading-journal-set-up-trading-journal
Sheet: Sheet1

Trade # | Date Open | Symbol | L/S | Qty | Entry | Stop Loss | Stop Loss 1 | Stop Loss 2 | Stop Loss 3 | Target | Exit | Total Charges | P&L | Initial Risk | Target R Multiple | Actual R Multiple | Trade Size | Trade Setup | % P/L | Initial % Risk | W/L | Closed | Date Closed
1 | 2022-01-18 00:00:00 | DISCA | L | 50 | 30 | 27.99 |  |  |  | 35 | 27.99 |  |  |  |  |  |  |  |  |  |  | Y | 2022-01-20 00:00:00
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
1
2
3
4
5
6
7
8
9
10
1 | 2022-03-08 00:00:00 | PBF | L | 50 | 20.45 | 19.95 |  |  |  | 21.75 | 19.94
2 | 2022-03-11 00:00:00 | SGMA | L | 25 | 8.44 | 7.56 | 7.97 | 8.31 |  | 12 | 12
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
1
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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 794501d1662081535-return-percentage-of-cells-with-values-trade-sample
Sheet: Session Values

Date (Zulu) | Session 1 |  | Session 2 |  | Session 3 |  | Session 4 |  |  | Data Entry Performance
 | Base | Upgrade | Base | Upgrade | Base | Upgrade | Base | Upgrade |  | (Accumulative)
2022-08-01 00:00:00 |  |  |  |  | 121 | 114 | 87 | 94
2022-08-02 00:00:00 | 123 | 125 | 91 | 83 | 133 | 125 | 93 | 86
2022-08-03 00:00:00 | 134 | 136 | 96 | 89 | 140 | 131 | 100 | 104
2022-08-04 00:00:00 | 142 | 146 | 109 | 108 | 70 | 67 | 113 | 109
2022-08-05 00:00:00 | 71 | 75 | 116 | 109 | 75 | 69 | 119 | 126
2022-08-06 00:00:00 | 78 | 69 | 128 | 131 | 88 | 91 | 89 | 97
2022-08-07 00:00:00 | 134 | 133 | 95 | 90 | 137 | 129 | 91 | 91
2022-08-08 00:00:00 | 141 | 141 |  |  | 106 | 106 | 67 | 62
2022-08-09 00:00:00 | 102 | 97 | 69 | 65 | 113 | 108 | 74 | 66
2022-08-10 00:00:00 | 119 | 114 | 76 | 72 | 120 | 116 | 80 | 84
2022-08-11 00:00:00 | 120 | 112 | 89 | 89 | 133 | 139 | 92 | 96
2022-08-12 00:00:00 | 133 | 138 | 96 | 102 | 144 | 150 | 142 | 146
2022-08-13 00:00:00 | 100 | 108 | 133 | 128 | 89 | 89 | 131 | 130
2022-08-14 00:00:00 | 89 | 96 | 126 | 124 | 78 | 76 | 124 | 123
2022-08-15 00:00:00 | 86 | 85 | 115 | 111 | 71 | 66 | 111 | 111
2022-08-16 00:00:00 | 71 | 72 | 108 | 103 | 65 | 57 | 99 | 98
2022-08-17 00:00:00 | 142 | 139 | 96 | 98 | 135 | 128 | 92 | 97
2022-08-18 00:00:00 | 140 | 147 | 89 | 98 | 129 | 119 | 85 | 92
2022-08-19 00:00:00 | 133 | 124 | 82 | 82 | 117 | 110 | 74 | 73
2022-08-20 00:00:00 | 121 | 118 | 71 | 67 | 111 | 113 | 67 | 72
2022-08-21 00:00:00 | 110 | 104 | 125 | 128 | 82 | 78 | 123 | 121
2022-08-22 00:00:00 | 85 | 83 |  |  | 131 | 126 | 88 | 94
2022-08-23 00:00:00 | 129 | 135 | 78 | 79 | 119 | 112 | 75 | 84
2022-08-24 00:00:00 | 119 | 128 |  |  | 112 | 103
2022-08-25 00:00:00 |  |  |  |  | 101 | 108 | 140 | 148
2022-08-26 00:00:00 | 99 | 89 |  |  | 94 | 101 | 128 | 119
2022-08-27 00:00:00 | 92 | 91 |  |  | 81 | 82 | 122 | 112
2022-08-28 00:00:00 | 81 | 89 |  |  | 76 | 79 | 110 | 115
2022-08-29 00:00:00 | 73 | 66 | 98 | 92 | 139 | 135 | 92 | 85
2022-08-30 00:00:00 | 135 | 135 | 138 | 138 | 93 | 88 | 134 | 141
2022-08-31 00:00:00 | 89 | 80 | 131 | 131 | 82 | 78 | 121 | 125
Spreadsheet: 852415d1702468587-problem-with-if-formula-excel-workbook-aligw
Sheet: Sheet1

 | 1999 |  | 1999 |  | 1999
 |  |  |  |  | 99
 | click for notes: |  | click for notes: |  | click for notes:
 | above example |  | not working now |  | now working
 | works fine |  | with new formula |  | same formula
 |  |  | in D3 |  | in F3 but formula
 |  |  |  |  | removed from F2
 | PROBLEM: HOW CAN I KEEP  THE FORMULA IN B2 TO RUN WITH D2?
Spreadsheet: 118165d1313501864-sum-cells-based-on-text-dummy-ot-report
Sheet: Jan.

SENIORITY # | EMPLOYEE | PAY PERIOD 1                                                                     January 1, 2012 to January 7, 2012 |  |  |  |  |  |  | (AC) Acting Captain     $ value | (APC) Acting P/C     $ value | OT Standard (OT)     hour value | OT Other (OTOT)     hour value | OT Acting Captain (OTAC)      hour value | OT Acting P/C (OTAPC)      hour value | OT Stat Standard (OTSTAT)        hour value | OT Stat - Acting Captain (ACSTAT)    $ value | OT Stat - Acting P/C (APCSTAT)     $ value | OT Tech (OTTECH)     hour value | Tech Acting Captain (ACTECH)     $ value |  | Late Entries
 |  | PAY PERIOD 1 - January 1, 2012 to January 7, 2012 |  |  |  |  |  |  | 5.39 | 4.67 | x 0 | x 1.5 | x 1.5 | x 1.5 | x 0.5 | $5.39 x 2 | $4.67 x 2 | x 1.5 | 5.39
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Pay Period 1
##### | Personel 1 | 15 OTSTAT |  | 10 APC |  |  | 8 AC | 6 AC | 75.46 | 46.7 | 0 | 0 | 0 | 0 | 7.5 | 0 | 0 | 0 | 0
##### | Personel 2 |  |  |  | 15 OT |  |  |  | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
##### | Personel 3 |  | 8 OTOT LB1 | 8 OTOT | 8 OTOT |  |  |  | 0 | 0 | 0 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0
##### | Personel 4 | 10 AC |  |  |  |  |  |  | 53.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
##### | Personel 5 | 10 OTSTAT |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0
##### | Personel 6 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
##### | Personel 7 | 15 OTSTAT LB1 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
##### | Personel 8 |  |  |  |  |  | 10 OT LB2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
##### | Personel 9 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: sally_beck__35336__2002 Energy Ops IT budget split
Sheet: Sheet1

2002 IT Budget
[NAME]
 |  |  |  | Direct Project | Indirect Project | Capital | Total
 |  |  |  | Expense | Expense
Production Support |  |  |  |  |  | 105057
[NAME] (unify)
Software & Licenses |  |  |  | 16305 | 11919 | 200512
Development Projects
Hardware (Unify & DECAF) |  |  |  |  |  | 647800
 | rounding |  |  | 22 | 21 | 20
TOTAL
Spreadsheet: darrell_schoolcraft__7786__imbalsumm0107
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 |  | -10000
2 |  | -10000
3
4
5
6
7
8
9 | 60
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | 95102
2001-07-10 00:00:00
Spreadsheet: 725548d1616739224-locating-a-corresponding-value-by-looking-for-a-value-in-a-previous-cell-locating-a-corresponding-value-from-previous-cells-values
Sheet: Sheet1

 | Present | Prev 1 | Prev 2 | Prev 3 | Prev 4 | Helper |  | Prev 1 | Prev 2 | Prev 3 | Prev 4
[NAME] | 0
[NAME] | 0.15
[NAME] | 0.02
[NAME] | -0.11
[NAME] | 0.06
[NAME] | 0 | 0
[NAME] | -0.04
[NAME] | -0.02 | 0.06 | 0.02
[NAME] | -0.01 | 0 | 0.15
[NAME] | -0.03
[NAME] | 0.02 | 0
[NAME] | 0.07 | -0.02 | 0.06 | 0.02
[NAME] | -0.03 | -0.01 | 0 | 0.15
[NAME] | 0.04 | -0.03
 | [NAME] required in cells C2:F15 to return values as shown above
 | The table above is in chronological order. [NAME] at the top is the first event. [NAME] at the bottom is the most recent event
 | Starting from the most recent event [NAME] (row 15) and then working upwards, I would like to locate all the other [NAME]' and place them in cells C15:F15 within the grid
 | ..then do the same for [NAME] in A14 and place all the previous [NAME] values in C14:F14… and so on
 | Examples
 | Cell C15 needs to return -0.03 because it looks at cell A15 ([NAME]) and searches for the most recent [NAME] in A:A (A11) and places the B row equivalent value (which is -0.03 found in B11) into that cell
 | Cell C14 returns -0.01 because it looks for the previous [NAME] in A10 and returns B10. Then, [NAME] looks for the next previous [NAME] (A7) therefore returning the value in B7. E14 returns 0.15. F15 returns nothing because there are no more [NAME]'s in the list
Spreadsheet: 119117d1314204503-excel-2008-almost-solved-vlookup-offset-match-and-countif-student-records-and-database
Sheet: Pictures

MemberName | Ajob | Atkins | Carlton | [NAME] | Constanine | Edwards | [NAME] | [NAME] | Goldstein | Green | [NAME] | Hanratty | Henroit | Ithard | National | Member | Nolan | Nutbush | Percival | Richman | Royce | Saying | Scott | Silverton | Western | Witchman | Willis
Picture
Member [NAME]
Spreadsheet: andy_zipper__244__DYNEGY-ICE VOL Jun4
Sheet: E-Mail

 | 2001-06-04 00:00:00
 | Intercontinental Exchange |  |  |  | Enron's Activity on ICE
 | Commodity | ICE Volume | EOL US Volume (approx) |  | Enron Entity | Commodity | Deals | Volume
 | TOTAL POWER (MWH) |  |  |  | EPM | POWER
 | TOTAL GAS (MMBTU) |  |  |  | ENA | GAS
 | >ICE PHYSICAL GAS |  |  |  | ENA | CRUDE
 | >ICE FINANCIAL GAS |  |  |  | ECC
 | TOTAL CRUDE PRODUCTS (BBL)
 |  |  |  |  | Enron's Activity on Dynegy Direct
 |  |  |  |  | Enron Entity | Commodity | Deals | Volume
 |  |  |  |  | EPM | POWER
 |  |  |  |  | ENA | POWER
 |  |  |  |  | ENA | US NATURAL GAS
 |  |  |  |  | ENA | COAL
 |  |  |  |  | EGL | NATURAL GAS LIQUIDS
Spreadsheet: ce146d34-faf9-47d5-b5dd-14b395a763c5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | As of Apr 17, 2014 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
ETF Name | Ticker | Management fee | NAV | Price | Net assets ($[NAME]) | Distribution yield | Listing date
PowerShares Tactical Bond ETF | PTB | 0.49% | $19.27 | $19.29 | 164.3 | 4.26% | Aug 24, 2012
PowerShares 1-5 Year Laddered Investment Grade Corporate Bond Index ETF | PSB | 0.25% | $19.57 | $19.62 | 254.5 | 4.31% | Jun 15, 2011
PowerShares Ultra Liquid Long Term Government Bond Index ETF | PGL | 0.25% | $21.02 | $20.99 | 663.6 | 3.73% | Jun 15, 2011
PowerShares Senior Loan (CAD Hedged) Index ETF | BKL | 0.80% | $20.32 | $20.31 | 75.2 | 4.05% | Apr 16, 2012
PowerShares Fundamental High Yield Corporate Bond (CAD Hedged) Index ETF | PFH | 0.65% | $21.03 | $21.05 | 134.1 | 4.34% | Jun 21, 2011
PowerShares Canadian Preferred Share Index ETF | PPS | 0.45% | $18.09 | $18.05 | 162.5 | 4.35% | [NAME]
PowerShares Canadian Dividend Index ETF | PDC | 0.50% | $24.99 | $24.67 | 22.5 | 3.48% | [NAME]
PowerShares S&P/TSX Composite Low Volatility Index ETF | TLV | 0.30% | $23.63 | $23.63 | 21.9 | 3.86% | Apr 24, 2012
PowerShares S&P 500 Low Volatility (CAD Hedged) Index ETF | ULV | 0.35% | $26.64 | $26.64 | 63.3 | 1.99% | Jan 24, 2012
PowerShares FTSE RAFI Canadian Fundamental Index ETF | PXC | 0.45% | $24.33 | $24.33 | 120.4 | 2.52% | Jan 26, 2012
PowerShares FTSE RAFI US Fundamental (CAD Hedged) Index ETF | PXU | 0.55% | $29.66 | $29.70 | 111.2 | 1.24% | Jan 26, 2012
PowerShares S&P/TSX Composite High Beta Index ETF | THB | 0.30% | $14.68 | $14.67 | 3.3 | 0.72% | Apr 24, 2012
PowerShares S&P 500 High Beta (CAD Hedged) Index ETF | UHB | 0.35% | $29.02 | $28.65 | 2.2 | 0.64% | Apr 24, 2012
PowerShares QQQ (CAD Hedged) Index ETF | QQC | 0.32% | $31.00 | $31.01 | 17.0 | 0.81% | [NAME]
Spreadsheet: 812862d1673428547-dates-to-be-list-all-in-one-cell-mini-table-dates-
Sheet: Table

Row Labels | Date in Whitespace
Aylesford | 05-06-2023 & 06-06-2023 & 07-06-2023
Belper
Birmingham
[NAME]
Burscough
Central
Clay Cross
Crumlin
Devizes
[NAME]
Featherstone
[NAME]
Hinckley
Industrial
KETTERING
[NAME]
[NAME]
Lockerbie
London - Mill Street
Louth - Aries House
Louth - Grimsby Road
Louth - Windsor Road
[NAME]
Neath
Newcastle
PLC
PLYMOUTH
Redditch
Retail Marketing
Retail North
Retail South
Sheerness
Wellingborough
Wirral
Spreadsheet: 808560d1670517530-how-to-calculate-result-by-skipping-blank-cells-book1-3-
Sheet: Sheet1

STUDENT NO | ENGLISH | PHYSICS | CHEMISTRY | MATHS | BIO | IT | YOGA | RESULT
1 | 34 | 33 | 45 |  | 33
2 | 45 | 31 | 32 | 33 |  | 21
3 | 31 | 45 | 34 | 23 |  | 37
4
Spreadsheet: 101440d1299565151-bonus-calculation-sample_bonus
Sheet: Bonus %

 |  | ISE Bonus and Comission Payout
 |  | Per Plan Achievement |  |  |  | Bonus Payout |  |  |  | > | <=
 |  | 1.5 |  |  |  | 4500 |  |  |  | 1.5
 |  | 1.4 | to | 1.4999 |  | 3250 |  |  |  | 1.4 | 1.4999
 |  | 1.3 | to | 1.3499 |  | 2500 |  |  |  | 1.3 | 1.3499
 |  | 1.2 | to | 1.2499 |  | 2000 |  |  |  | 1.2 | 1.2499
 |  | 1.15 | to | 1.1999 |  | 1500 |  |  |  | 1.15 | 1.1999
 |  | 1.1 | to | 1.1499 |  | 1300 |  |  |  | 1.1 | 1.1499
 |  | 1.05 | to | 1.0999 |  | 1160 |  |  |  | 1.05 | 1.0999
 |  | 1 | to | 1.0499 |  | 1000 |  |  |  | 1 | 1.0499
 |  | 0.9 | to | 0.9999 |  | 500 |  |  |  | 0.9 | 0.9999
 |  | < 90.00% |  |  |  | 0 |  |  |  | 0.9
Spreadsheet: 859161d1707629015-more-than-one-occurrences-but-not-consecutive-more-than-one-occurrences-but-not-consecutive-ans-edited-ans
Sheet: Sheet1

date | code | type | info |  |  | FORMULA
2024-01-01 00:00:00 | 100 | tea | test | I want this true because it is duplicated and not consecutive |  |  | This row formula is different
2024-01-02 00:00:00 | 200 | tea
2024-01-03 00:00:00 | 100 | water
2024-01-01 00:00:00 | 100 | tea | test | I want this true because it is duplicated and not consecutive
2024-01-05 00:00:00 | 200 | milk
2024-01-06 00:00:00 | 100 | tea | test | I want this false because it is duplicated and it is consecutive
2024-01-06 00:00:00 | 100 | tea | test | I want this false because it is duplicated and it is consecutive
2024-01-08 00:00:00 | 100 | water
2024-01-09 00:00:00 | 100 | tea
2024-01-10 00:00:00 | 200 | milk
2024-01-11 00:00:00 | 200 | ice | test | this should stay true with last 2 records because it is dupliacted and not consecutive
2024-01-12 00:00:00 | 100 | water
2024-01-13 00:00:00 | 100 | tea
2024-01-11 00:00:00 | 200 | ice | test
2024-01-11 00:00:00 | 200 | ice | test