tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 738647d1625160590-find-ratio-of-cells-with-conditions-bo-trend-backtesting
Sheet: RESULTS

 | GAIN/LOSS |  |  |  |  | WEEKLY |  |  |  |  |  |  | MARKET CAP |  |  | Min 5 results per section
 |  |  |  |  |  | WEEK | TRADES | WIN % | < .50 | G/L | 2 PTS |  | FLOAT
 | Win/Loss % |  |  |  |  | 25 | 19 | 0.5263157894736842 | 4 | 10.14 | 2
 | Trading Days |  |  |  |  | 24 | 14 |  | 3 | 12.87 | 4 |  | WIN % | <1M | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M<
 | Trades |  |  |  |  | 23 | 11 |  | 4 | 8.01 | 4 |  | <100M
 | Wins |  |  |  |  | 22 | 5 |  | 2 | 2.17 | 4 |  | 100-500M
 | Gain /s (Total) |  |  |  |  | 21 | 12 |  | 3 | 7.32 | 3 |  | 500M-1B
 | Gain /s (Ave on wins) |  |  |  |  | 20 | 22 |  | 0 | -1.69 | 0 |  | 1B<
 | SETUP %
 |  | Trades | Traded % | Wins %
 | PM Consolidation
 | Consolidation
 | PMH
 | Pivot
 | HOD
 | POP
 | Daily Resistance
 | HIGHS %
 | Entry-High Ave
 | High-Close Ave
 | ENTRY TIMES (WINNING TRADES)
 |  | Trades | Traded % | Ave Entry
 | 8:00-8:59
 | 9:00-9:29
 | 9:30-9:49
 | 9:50-10:29
 | 10:30-11:29
 | 11:30-14:59
 | ENTRY PRICE (WINNING TRADES)
 |  | Trades | Ave Entry | Ave G/L
 | < 3.00
 | 3.01-5.00
 | 5.01-7.00
 | 7.01-10.00
 | 10.01-15.00
 | 15.01-20.00
 | 20.01-25.00
 | 25.01-30.00
 | 30.01 <
Spreadsheet: 789054d1658862467-separate-and-remove-text-from-a-cell-based-on-data-from-another-sheet-sample_3
Sheet: Data

Bldg |  | Remove
0A |  | -CONF
3A |  | -DECOM
3B |  | DS-
3C |  | LABTRK
3D |  | X
3E
3F
3G
3H
3J
3K
5A
5B
5C
6A
6B
8A
A2
A3
A4
AT
AU
BC
BL
CA
CE
CH
CJ
CL
CT
[NAME]
CZ
D1
D2
D3
DI
EC
FD
FE
FS
GI
GS
H1
H2
HE
HL
HO
HP
HS
[NAME]
IT
JH
KR
LR
LT
LV
OC
PD
SA
SB
SL
SO
ST
TA
TB
TE
TR
TS
TW
UC
VA
VE
WT
XX
A3
A4
AT
CH |  | TV
Spreadsheet: 795971d1663040839-need-formula-to-split-long-string-as-per-header-excel_string
Sheet: Sheet1

 | EXPECTED RESULT
RAWDATA | NAME | ADDRESS | D.O.B | [NAME] | MOBILR | DESINATION
jackhenry 45,BunnryRoad CA USA 3222 |||| 06/06/1988 [EMAIL] 988-4848-858 IT Data Analyst | jackhenry | 45,BunnryRoad CA USA 3222 | 1988-06-06 00:00:00 | [EMAIL] | 988-4848-858 | IT Data Analyst
[NAME] 45,BunnryRoad CA USA [PHONE]-858 IT Data Analyst  [EMAIL] | jackhenry | 45,BunnryRoad CA USA 3222 | 1988-06-06 00:00:00 | [EMAIL] | 988-4848-858 | IT Data Analyst
jackhenry 45,BunnryRoad CA USA 3222 06/06/1988  988-4848-858 %|||| IT Data Analyst | jackhenry | 45,BunnryRoad CA USA 3222 | 1988-06-06 00:00:00 |  | 988-4848-858 | IT Data Analyst
jackhenry 45,BunnryRoad CA USA 3222 06/06/1988 [EMAIL] 988-4848-858 IT Data Analyst | jackhenry | 45,BunnryRoad CA USA 3222 | 1988-06-06 00:00:00 | [EMAIL] | 988-4848-858 | IT Data Analyst
jackhenry 55 2suite SOUTH Drive LA USA 3222 06/06/1988 [EMAIL] 988-4848-858 IT Data Analyst | jackhenry | 55 2suite SOUTH Drive LA USA 3222 | 1988-06-06 00:00:00 | [EMAIL] | 988-4848-858 | IT Data Analyst
jackhenry 45,BunnryRoad CA USA 3222 06/06/1988 [EMAIL] 988-4848-858 sales manager | jackhenry | 45,BunnryRoad CA USA 3222 | 1988-06-06 00:00:00 | [EMAIL] | 988-4848-858 | IT Data Analyst
jackhenry 45,BunnryRoad CA USA 3222 (}||||| 06/06/1988  IT Data Analyst | jackhenry | 45,BunnryRoad CA USA 3222 | 1988-06-06 00:00:00 |  |  | IT Data Analyst
jackhenry *|||||| IT Data Analyst | jackhenry |  |  |  |  | IT Data Analyst
jackhenry45Yarkst NY 3222 06/06/1988 | jackhenry | 45Yarkst NY 3222 | 1988-06-06 00:00:00
jackhenry 45,BunnryRoad CA USA 3222 06/06/1988 [EMAIL] 988-4848-858 IT Data Analyst | jackhenry | 45,BunnryRoad CA USA 3222 | 1988-06-06 00:00:00 | [EMAIL] | 988-4848-858 | IT Data Analyst
jackhenry 45,BunnryRoad CA USA 3222 06/06/1988 [EMAIL] 988-4848-858 IT Data Analyst | jackhenry | 45,BunnryRoad CA USA 3222 | 1988-06-06 00:00:00 | [EMAIL] | 988-4848-858 | IT Data Analyst
jackhenry  [EMAIL] 988-4848-858 IT Data Analyst | jackhenry |  |  | [EMAIL] | 988-4848-858 | IT Data Analyst
jackhenry  06/06/1988 [EMAIL] 988-4848-858 IT Data Analyst | jackhenry |  | 1988-06-06 00:00:00 | [EMAIL] | 988-4848-858 | IT Data Analyst
Spreadsheet: aa9a84cc-5323-41f8-ac1c-a54abc696ee2
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
43201697 | 2014-09-17 22:07:19 | AXIS | 1 | 10 | 4 | 832450 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43256545 | 2014-09-21 21:33:08 | ALLIES | 1 | 6 | 5 | 1611343 | DDB73 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43257065 | 2014-09-21 21:55:25 | AXIS | 1 | 6 | 2 | 1611343 | DDB73 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43298502 | 2014-09-24 21:30:11 | AXIS | 1 | 10 | 6 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43299034 | 2014-09-24 21:59:43 | ALLIES | 1 | 10 | 6 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43311808 | 2014-09-25 21:39:20 | AXIS | 1 | 10 | 6 | 1578168 | kosh100 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43312443 | 2014-09-25 22:07:53 | AXIS | 1 | 10 | 7 | 1088314 | bino_zoet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43312903 | 2014-09-25 22:32:13 | ALLIES | 1 | 10 | 5 | 1088314 | bino_zoet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43368967 | 2014-09-29 21:05:43 | AXIS | 0 | 4 | 6 | 362406 | [NAME] | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
Spreadsheet: 737369d1624374356-rotating-schedule-with-multiple-criteria-cps-2
Sheet: Holidays

Holidays and Non-Working Days |  |  | Start Year: | 2021
Date | Description
 | Christmas
 | Christmas
 | Christmas
 | Christmas
 | Christmas
 | Christmas
 | Christmas
 | Columbus Day
 | Columbus Day
 | Columbus Day
 | Columbus Day
 | Columbus Day
 | Columbus Day
 | Columbus Day
 | Independence Day
 | Independence Day
 | Independence Day
 | Independence Day
 | Independence Day
 | Independence Day
 | Independence Day
 | Labor Day
 | Labor Day
 | Labor Day
 | Labor Day
 | Labor Day
 | Labor Day
 | Labor Day
 | M.L.King Jr. Day
 | M.L.King Jr. Day
 | M.L.King Jr. Day
 | M.L.King Jr. Day
 | M.L.King Jr. Day
 | M.L.King Jr. Day
 | M.L.King Jr. Day
 | Memorial Day
 | Memorial Day
 | Memorial Day
 | Memorial Day
 | Memorial Day
 | Memorial Day
 | Memorial Day
 | New Year's Day
 | New Year's Day
 | New Year's Day
 | New Year's Day
 | New Year's Day
 | New Year's Day
 | New Year's Day
 | Presidents Day
 | Presidents Day
 | Presidents Day
 | Presidents Day
 | Presidents Day
 | Presidents Day
 | Presidents Day
 | Thanksgiving
 | Thanksgiving
 | Thanksgiving
 | Thanksgiving
 | Thanksgiving
 | Thanksgiving
 | Thanksgiving
 | Veterans Day
 | Veterans Day
 | Veterans Day
 | Veterans Day
 | Veterans Day
 | Veterans Day
 | Veterans Day
Spreadsheet: 731491d1620369318-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league
Sheet: ZEC

S.N. | Particulars | Bought  Units | Unit or ZEC Price | Bought/ Sold Price  ($US) | Bought/ Sold Price (BTC) | Token Unit Price During Txn | Activity  Date | Received Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated  Price ($US) | Status | Notes
1 | ZCash @ Bittrex - Purchase 1 | 0.9975 | 0.06689004 |  | -0.06688961 | 4339 | 2017-09-30 00:00:00 | 2017-09-30 00:00:00 |  |  |  |  | SOLD
2 | ZCash @ Bittrex - Purchase 2 | 0.73115091 | 0.06688993 |  | -0.04902888 | 4339 | 2017-09-30 00:00:00 | 2017-09-30 00:00:00 |  |  |  |  | SOLD
3 | [NAME] | -1.72865091 | 0.0517063 |  | 0.0891587 | 4425 | 2017-10-07 00:00:00
4 | ZCash @ Bittrex - Purchase 3 | 13.12773494 | 0.02279524 |  | -0.29999804 | 14090 | 2017-12-06 00:00:00 | 2017-12-06 00:00:00 |  |  |  |  | SOLD
5 | [NAME] | -13.12773494 | 0.01916001 |  | 0.25089879 | 16885.8 | 2017-12-11 00:00:00
6 | ZCash @ Binance - Purchase | 2.693304 | 0.046539 |  | -0.125469 | 13308.1 | 2018-01-11 00:00:00 | 2018-01-11 00:00:00 |  |  |  |  | SOLD
7 | Fees for transferring 2.693304 STRAT from Binance to Ledger | -0.005 |  |  |  |  | 2018-01-20 00:00:00
8 | ZCash @ Bittrex - Purchase | 0.33628832 | 0.03472434 |  | -0.01170658 | 10976.64 | 2018-03-06 00:00:00 | 2018-03-06 00:00:00 |  |  |  |  | SOLD
9 | [NAME] | -0.33628832 | 0.03466198 |  | 0.01162728 | 10000 | 2018-03-07 00:00:00
10 | [NAME] | -2.688 | 0.034742 |  |  | 10000 | 2018-03-07 00:00:00
11
12
13
14
15
16
17
 | Next Buy
 | ZCash in Ledger Nano S | 0.000304
 | ZCash in Bittrex | 0
 | ZCash in Binance | 0
 | Total Investment Loss/Profit ($US)
 | Website: https://
 | Contract address:
 | Symbol:
 | Decimals:
 | About/Idea
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: 750581d1633533951-averaging-results-from-another-tab-pp-data_cl-planning_v3
Sheet: Summary

QUARTILE | Q1 |  | Q2 |  | Q3 |  | Q4 |  | TOTAL |  | Ward | Schools | Priority schools | AverageQ | Crit Q
%UPN | <10% | 10-14% | 15-19% | 20-24% | 25-29% | 30-34% | 35-39% | >40% |  |  | Bitton & Oldland Common
 |  |  |  |  |  |  |  |  |  |  | Boyd Valley
No. of Schools |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
& Schools |  |  |  |  |  |  |  |  |  |  | Charfield
 |  |  |  |  |  |  |  |  |  |  | Charlton & Cribbs
SCHOOL |  |  |  |  |  |  |  |  |  |  | Chipping Sodbury & Cotswold Edge
 |  |  |  |  |  |  |  |  |  |  | Dodington
 |  |  |  |  |  |  |  |  |  |  | Emersons Green
 |  |  |  |  |  |  |  |  |  |  | Filton
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Frenchay & Downend
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Kingswood
 |  |  |  |  |  |  |  |  |  |  | Longwell Green
 |  |  |  |  |  |  |  |  |  |  | New Cheltenham
 |  |  |  |  |  |  |  |  |  |  | Parkwall & Warmley
 |  |  |  |  |  |  |  |  |  |  | Patchway Coniston
 |  |  |  |  |  |  |  |  |  |  | Pilning & Severn Beach
 |  |  |  |  |  |  |  |  |  |  | Severn Vale
 |  |  |  |  |  |  |  |  |  |  | Staple Hill & Mangotsfield
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Stoke Park & Cheswick
 |  |  |  |  |  |  |  |  |  |  | Thornbury
 |  |  |  |  |  |  |  |  |  |  | Winterbourne
 |  |  |  |  |  |  |  |  |  |  | Woodstock
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 781723d1653500996-find-earliest-and-latest-times-in-single-column-2022-05-25-oeldere-john-lute-timesheet
Sheet: LOCIDTable

LOC TYPE | Odd/Even | Aisle | Bay | LOCTYPE | LOCID | Date Cleaned | Cleaned by | Date Helper | Time Helper
STO |  |  |  |  | 005022A01 | 2022-05-25 10:48:15 | [NAME]
STO |  |  |  |  | 005022A02 | 2022-05-25 11:23:33 | [NAME]
STO |  |  |  |  | 005024A01 | 2022-05-25 12:39:31 | [NAME]
STO |  |  |  |  | 005024A02 | 2022-05-25 02:39:31 | Oeldere |  |  |  | > This table pulls data from another worksheet (rows 2-4 were populated for testing). Users use a scanner to scan their names into the other worksheet. A date/time is automatically stamped. They may record up to 100 date/time stamps in one day. I want to find and report their EARLIEST and LATEST times for a given date.
STO |  |  |  |  | 005026A01 | 2022-05-25 20:39:31 | Oeldere |  |  |  | > I want to find the EARLIEST and LATEST times in table column J for name in cell O7 for date in cell L10.
STO |  |  |  |  | 005026A02 | 2022-05-25 20:39:31 | Oeldere |  |  |  |  |  |  | [NAME]
STO |  |  |  |  | 005028A01 | 2022-05-25 20:39:31 | Oeldere |  |  |  | date | earliest | latest
STO |  |  |  |  | 005028A02 | 2022-05-25 22:39:31 | Oeldere |  |  |  | 2022-05-25 00:00:00 | 10:48 AM | 12:39 PM | < These are the earliest/latest values I want to find.
STO |  |  |  |  | 005030A01 |  |  |  |  |  | 2022-05-25 00:00:00 |  |  | < These are the cells I'm testing formulas in.
STO |  |  |  |  | 005030A02
STO |  |  |  |  | 005032A01 |  |  |  |  |  | [NAME]
STO |  |  |  |  | 005032A02
STO |  |  |  |  | 005034A02
STO |  |  |  |  | 005034A01
STO |  |  |  |  | 005036A01
STO |  |  |  |  | 005036A02
STO |  |  |  |  | 005038A01
STO |  |  |  |  | 005038A02
STO |  |  |  |  | 005046A01
STO |  |  |  |  | 005048A01
STO |  |  |  |  | 005048A02
STO |  |  |  |  | 005050A01
STO |  |  |  |  | 005050A02
STO |  |  |  |  | 005052A01
Spreadsheet: 9d1dba48-a42d-4294-8615-08d4dbc9ac5a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
258992 | 57247 | [NAME] | Mulders | NED |  | 01:01:28 | 00:01:37 | 01:41:08 | 00:01:53 | 00:35:16 | 1 | 03:21:21
258992 | 12392 | Miroslav | Krsek | CZE |  | 01:02:58 | 00:01:36 | 01:48:24 | 00:01:57 | 00:34:13 | 2 | 03:29:07
258992 | 13445 | [NAME] | Heikamp | NED |  | 01:02:31 | 00:01:51 | 01:45:36 | 00:02:04 | 00:39:39 | 3 | 03:31:38
258992 | 56480 | [NAME] | Woodcock | GBR |  | 01:04:38 | 00:01:33 | 01:51:11 | 00:01:53 | 00:34:59 | 4 | 03:34:12
258992 | 69914 | [NAME] | Greisel | GER |  | 01:07:51 | 00:01:59 | 01:59:28 | 00:03:11 | 00:36:46 | 5 | 03:49:14
258992 | 57246 | Jan | Vanass | NED |  | 01:13:49 | 00:01:53 | 01:47:17 | 00:01:57 | 00:45:28 | 6 | 03:50:23
Spreadsheet: 800561d1665741577-lookup-with-multiple-criteria-example5
Sheet: Sheet1

Position | Player | Daily H'cap | GA Handicap | Gross | Nett | Gender |  | Daily H'cap |  | Male
1 | Carol | 26 | 23.1 | 93 | 67 | Female | A Grade (M) | -100 | 12
2 | Garry | 30 | 29.2 | 98 | 68 | Male | B Grade (M) | 12 | 18
3 | Trevor | 14 | 14.5 | 83 | 69 | Male | C Grade (M) | 18 | 100
4 | [NAME] | 5 | 3.6 | 76 | 71 | Male
5 | [NAME] | 3 | 1.7 | 74 | 71 | Male |  | Daily H'cap |  | Female
6 | [NAME] | 13 | 10.7 | 84 | 71 | Male | A Grade (F) | -100 | 20
7 | [NAME] | 18 | 18.0 | 89 | 71 | Male | B Grade (F) | 20 | 100
8 | Billy | 14 | 11.5 | 86^^ | 72^^ | Male
9 | Martina | 16 | 14.1 | 88 | 72 | Female
10 | [NAME] | 5 | 3.2 | 77 | 72 | Male
11 | [NAME] | 13 | 13.6 | 86 | 73 | Male
12 | [NAME] | 9 | 7.6 | 82 | 73 | Male
13 | [NAME] | 12 | 9.6 | 85 | 73 | Male
14 | [NAME] | 13 | 11.0 | 86 | 73 | Male
15 | [NAME] | 18 | 18.2 | 91 | 73 | Male
Spreadsheet: 857225d1706250290-filter-with-and-or-criterias-based-on-named-range-value-filter_sample
Sheet: Sheet1

DATE FROM | 2023-10-22 00:00:00 |  |  |  |  |  |  |  | EXCLUDE
DATE TO | 2023-11-21 00:00:00 |  |  |  |  |  |  |  | A
DATA_A | DATA_B | DATA_C | DATA_D |  |  |  |  |  | E
A | 2023-10-16 14:29:00 | 781 | 147000
B | 2023-10-23 12:36:00 | 786 | 309750
C | 2023-10-25 12:41:00 | 556 | 320000
E | 2023-10-26 10:02:00 | 453 | 1585443
D | 2023-10-30 10:10:00 | 641 | 324000
E | 2023-11-02 14:44:00 | 141 | 0
A | 2023-11-06 13:38:00 | 285 | 70675.7805
A | 2023-11-08 15:24:00 | 127 | 176000
E | 2024-01-17 14:52:00 | 179 | 4211.46405
E | 2024-01-18 11:41:00 | 383 | 285563
E | 2024-01-22 09:56:00 | 108 | 9920
D | 2024-01-26 09:15:00 | 156 | 33424.9
A | 2024-01-31 07:46:00 | 285 | 454400
E | 2023-11-28 15:39:00 | 457 | 31250
E | 2024-08-25 23:00:00 | 160 | 308614
D | 2024-09-15 23:00:00 | 51 | 258664
E | 2024-09-18 18:16:00 | 499 | 161800
A | 2024-09-28 16:15:00 | 779 | 58161.6
A | 2024-09-30 07:38:00 | 96 | 0
E | 2024-09-30 08:38:00 | 367 | 135710.4
 |  |  |  |  |  | Filter [DATA_ALL] between DateFrom AND DateTo |  |  |  |  | Filter [DATA_ALL] between DateFrom AND DateTo NOT [DATA_A]=[EXCLUDE]
DATA_A | DATA_B | DATA_C | DATA_D |  |  | DATA_A | DATA_B | DATA_C | DATA_D |  | DATA_A | DATA_B | DATA_C | DATA_D
 | 2023-10-23 12:36:00 | 786 | 309750 |  |  |  | 2023-10-23 12:36:00 | 786 | 309750 |  |  | 2023-10-23 12:36:00 | 786 | 309750
C | 2023-10-25 12:41:00 | 556 | 320000 |  |  | C | 2023-10-25 12:41:00 | 556 | 320000 |  | C | 2023-10-25 12:41:00 | 556 | 320000
D | 2023-10-30 10:10:00 | 641 | 324000 |  |  | E | 2023-10-26 10:02:00 | 453 | 1585443 |  | D | 2023-10-30 10:10:00 | 641 | 324000
 |  |  |  |  |  | D | 2023-10-30 10:10:00 | 641 | 324000
 |  |  |  |  |  | E | 2023-11-02 14:44:00 | 141 | 0
 |  |  |  |  |  | A | 2023-11-06 13:38:00 | 285 | 70675.7805
 |  |  |  |  |  | A | 2023-11-08 15:24:00 | 127 | 176000
Spreadsheet: 810142d1671564245-sum-with-more-than-one-column-criteria-book1
Sheet: Sheet1

Project No. | Root Project | Compensation
000016.000 | 000016 | 80705
000016.001 | 000016 | 8000
000016.002 | 000016 | 2295
000016.003 | 000016 | 16440
000017.000 | 000017 | 35000
000017.001 | 000017 | 1500
Spreadsheet: 733885d1621869853-salary-distribution-and-3-percent-increment-every-year-on-hire-date-salary_increment_calculation
Sheet: Sheet1

Annual Salary | Position Status | Years of Service | Hire Date | Termination Date |  | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00
36275.32 |  |  | 2020-04-20 00:00:00
65048.84816 |  |  | 2010-11-22 00:00:00 | 2021-11-22 00:00:00
166701.316624 |  |  | 2018-02-19 00:00:00
92204.908312 |  |  | 2011-12-06 00:00:00
258068.500312 |  |  | 2013-11-13 00:00:00
24355.88 |  |  | 2019-05-28 00:00:00
52080.49744000001 |  |  | 2020-11-09 00:00:00
149509.816624 |  |  | 2018-03-19 00:00:00
81746.69996800002 |  |  | 2017-12-18 00:00:00
168088.499968 |  |  | 2019-06-03 00:00:00 | 2022-04-14 00:00:00
36275.32 |  |  | 2019-06-07 00:00:00
86323.408312 |  |  | 2020-05-11 00:00:00
80734.8312 |  |  | 2018-10-04 00:00:00
126587.908312 |  |  | 2022-01-02 00:00:00
Desired Result |  |  |  |  | Montyly Amount | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00
36275.32 |  |  | 2020-04-20 00:00:00 |  | 3022.943333333333
65048.84816 |  |  | 2010-11-22 00:00:00 | 2021-11-22 00:00:00 | 5420.737346666667
166701.316624 |  |  | 2018-02-19 00:00:00 |  | 13891.77638533333
92204.908312 |  |  | 2011-12-06 00:00:00 |  | 7683.742359333333
258068.500312 |  |  | 2013-11-13 00:00:00 |  | 21505.70835933333
24355.88 |  |  | 2019-05-28 00:00:00 |  | 2029.656666666667
52080.49744000001 |  |  | 2020-11-09 00:00:00 |  | 4340.041453333334 |  | 4340.041453333334
149509.816624 |  |  | 2018-03-19 00:00:00 |  | 12459.15138533333
81746.69996800002 |  |  | 2017-12-18 00:00:00 |  | 6812.224997333335
168088.499968 |  |  | 2019-06-03 00:00:00 | 2022-04-14 00:00:00 | 14007.37499733333
36275.32 |  |  | 2019-06-07 00:00:00 |  | 3022.943333333333
86323.408312 |  |  | 2020-05-11 00:00:00 |  | 7193.617359333333
80734.8312 |  |  | 2018-10-04 00:00:00 |  | 6727.9026
126587.908312 |  |  | 2022-01-02 00:00:00 |  | 10548.99235933333 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10548.99235933333
Spreadsheet: 145951d1331827532-combine-results-from-one-work-sheet-to-another-with-item-count-test
Sheet: Location PM List

Location | Spartanburg | Choose Location from Drop Down
Annual Due Date | Jan | Choose Due Date from Drop Down
Unit #'s | Location | Brand | Year | Annual Due Date | ESN | Oil | Fuel | Air | Water | Fuel Seperator | Trans Filter | CCV Filter
503-5246 | 1 | Route | 1985 | Jan | D6.9 | [NAME] | FF5019 | AF364 | 0 | FS19798 | TF15002 | CCV
503-6907 | 1 | Spare | 1988 | Jan | [NAME] | LF3970 | FF5245 | AF25130M | WF2074 | FS19798 | TF15002 | CCV
503-7346 | 1 | Route | 1990 | Jan | [NAME] | LF3970 | FF5245 | AF25130M | WF2074 | FS19798 | TF15025 | CCV
507-0405 | 1 | Route | 1995 | Jan | D3116 | LF3630 | FF185 | AF1878 | WF2051 | FS19513 | TF15000 | CCV
507-1244 | 1 | Route | 1995 | Jan | D3116 | LF3630 | FF185 | AF1878 | WF2051 | FS19513 | TF15000 | CCV
507-2023 | 1 | Route | 1996 | Jan | D3116 | LF3630 | FF185 | AF1878 | WF2051 | FS19513 | TF15000 | CCV
507-2163 | 1 | Route | 2001 | Jan | D3126 | LF667 | FF209 | AF1731 | WF2053 | FS19513 | TF15000 | CCV
507-2441 | 1 | Route | 2008 | Jan | MBE906 | LF3313 | ff5035 | AF987 | 0 | FS20403 | TF15025 | CCV
508-0398 | 1 | Route | 2003 | Jan | D3126 | LF3630 | FF209 | AF1731 | WF2053 | FS19798 | TF15002 | CCV
508-0834 | 1 | Route | 2007 | Jan | MBE906 | LF3313 | ff5035 | AF26154 | 0 | FS20403 | TF15025 | CCV
508-1150 | 1 | Route | 2008 | Jan | DISB 200 | LF3883 | ff5035 | AF979M | WF2071 | FS20403 | TF15025 | CCV
Spreadsheet: 141646d1329387395-vba-to-copy-data-from-multiple-workbooks-to-master-workbook-sales-person-1
Sheet: Sales Log

 | No. | Client | Activity | Activity
 | 1 | Client 1 | Activity 1 | Sales Person 1
 | 1.01 | Client 2 | Activity 2 | Sales Person 1
 | 1.02 | Client 3 | Activity 3 | Sales Person 1
 | 1.03 | Client 4 | Activity 4 | Sales Person 1 |  | Named Range
 | 1.04 | Client 5 | Activity 5 | Sales Person 1 |  | Range1
 | 1.05 | Client 6 | Activity 1 | Sales Person 1
 | 1.06 | Client 7 | Activity 2 | Sales Person 1
 | 1.07 | Client 8 | Activity 3 | Sales Person 1
 | 1.08 | Client 9 | Activity 4 | Sales Person 1
 | 1.09 | Client 10 | Activity 5 | Sales Person 1
 | 2
 | 2.01
 | 2.02
 | 2.03
 | 2.04 |  |  |  |  | Named Range
 | 2.05 |  |  |  |  | Range2
 | 2.06
 | 2.07
 | 2.08
 | 2.09
 | 3
 | 3.01
 | 3.02
 | 3.03
 | 3.04 |  |  |  |  | Named Range
 | 3.05 |  |  |  |  | Range3
 | 3.06
 | 3.07
 | 3.08
 | 3.09
Spreadsheet: 130379d1322229623-counting-text-in-a-column-excel-20example-202-1-
Sheet: NCR list

Owner | Load Out/Back Load
Prime Power | Back Load
Unknown | Back Load
Unknown | Back Load
Novagest | Load Out
Novagest | Load Out
Prime Power | Load Out
Prezioso | Load Out
Swire | Back Load
Prezioso | Back Load
Prime Power | Back Load
AES | Back Load
Prime Power | Back Load
Spreadsheet: 2d8e2b74-2c5f-486d-9edc-a42addf38303
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Interdisciplinary
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 68236d1268767626-excel-2007-way-to-make-section-of-document-only-print-once-invoice
Sheet: Sales Rep. Report

 | 0
 | 500 [NAME] #10
 | Mesquite, TX 751149
 | (972)329-1104
 | Date:
 | From
 | To
 | Sales Rep. | Date | P.O. # | Invoice # | Cost | Sales Tax | GST | Shipping | Total | Paid | Subtotal | Balance Due | Due Date
Spreadsheet: darrell_schoolcraft__7314__imball0202
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -13510 | -13500
2 | -19133 | -19000
3 | -17376 | -17500
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
2002-01-31 00:00:00 |  |  | -135557
2002-02-03 00:00:00
CBS Volume
 |  |  | -67034
Spreadsheet: 688865d1595986445-multiple-if-statement-run-formula-help-needed-excel-example
Sheet: INPUT

Despatch Site | Transport Type | TONS | ESTIMATED FREIGHT COST | $/T
A | RIGID(JOE) | 18.554 |  |  |  |  |  |  | A | SEMI(JOE)
D | SEMI(PAUL) | 15.02 |  |  |  |  |  |  | B | RIGID(JOE)
B | RIGID(JOE) | 17.15 |  |  |  |  |  |  | C | SEMI(PAUL)
C | SEMI(PAUL) | 14.06 |  |  |  |  |  |  | D | RIGID 6.5 T(PAUL)
A | SEMI(PAUL) | 13.9 |  |  |  |  |  |  |  | RIGID 6.5T(JOE)
 |  |  |  |  |  |  |  |  |  | RIGID 10.3 T (PAUL)
 |  |  |  |  |  |  |  |  |  | RIGID 10.3T(JOE)