tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 804195d1667931022-why-is-this-simple-excel-logic-if-then-escaping-me-please-help-sample_excel_query-2-
Sheet: Sheet1

 | SAMPLE #1
 |  | Items | Rating
 |  | A | Optimal
 |  | B | Effective
 |  | C | Adequate
 |  | D | Weak
 |  | E | Ineffective
 |  | F | Adequate |  | <-- Lowest Rating - to - Highest Rating -->
 |  | G | Weak |  | Ineffective | Weak | Adequate | Effective | Optimal
 | Final Group Rating
 | Since the lowest rating of "Ineffective" had one vote, the next higher rating of "Weak" was assigned
 | SAMPLE #2
 |  | Items | Rating
 |  | A | Adequate
 |  | B | Weak
 |  | C | Optimal
 |  | D | Adequate
 |  | E | Optimmal
 |  | F | Adequate |  | <-- Lowest Rating - to - Highest Rating -->
 |  | G | Weak |  | Ineffective | Weak | Adequate | Effective | Optimal
 | Final Group Rating
 | Since the lowest, non-zero rating of "weak" was voted more than once, the rating assigned will be "Weak"
 | Note: The logic must run from the lowest rating to the highest rating.
Spreadsheet: 61442d1262285338-pulling-from-one-sheet-to-another-based-on-date-dc
Sheet: Cash Flow

Personal Cash Flow
 | January (Budget) | January (Actual) | Febuary (budget)
Balance forward
Work | 3000 | 3000 | 3000
Other | 0 |  | 8000
Investment income | 0 |  | 0
Cash in (total)
Phone | -154 |  | -154
Federal | -228
State | -99 |  | 99
Electric | -202 |  | -100
Gas | -85 |  | -85
Trash | 0 |  | 0
Water | 0 |  | -60
Insurance | -145 |  | -145
Furniture | -1000 |  | -500
Gym | -42 |  | -42
Cigarettes | -160 |  | -160
Gasoline | -160 |  | -160
Rent | -550 |  | -550
Improvements | -500 |  | -3000
Entertainment | 0 |  | 0
Food | -400 |  | -400
Car Maintenance | 0 |  | 0
Investment Activities | -500 |  | -500
Cash out (total)
Cash flow
Spreadsheet: 825261d1681217966-help-with-formula-to-return-top-5-from-raid-log-filter-function-20230411_dynamic-raid_v2
Sheet: RAID Dashboard

 | Directorate |  | No. Risks & Issues |  | Impact
 |  |  |  |  | 1 - Very Low | 2 - Low | 3 - Moderate | 4 - High | 5 - Very High
 |  |  | Likelihood | 1 - Rare
 | Programme |  |  | 2 - Unlikely
 |  |  |  | 3 - Possible
 |  |  |  | 4 - Likely
 | Status |  |  | 5 - Very Likely
 |  |  |  | Total
 |  |  | Top 5 Risks / Issues
 |  |  | ID |  | Risk Description |  | Date Raised | Current Proximity | Current Score
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
Spreadsheet: 148379d1333378755-creating-a-formula-for-dining-analysis-brunos-dining-analysis
Sheet: Sheet2

Eastside Location
 | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total
Dine-In | 45000 | 41000 | 38000 | 33000
Pick-up | 19000 | 21000 | 20000 | 20000
Delivery | 25000 | 35000 | 45000 | 55000
Total
Spreadsheet: 771714d1646812164-next-available-date-next-available-time-1-aligw
Sheet: Sheet1

Today | Block1 | Created Date1 | Block2 | Created Date2 | Block3 | Created Date3 | Next Available Date
 | 2022-03-09 00:00:00 |  | 2022-03-15 00:00:00 |  | 2022-03-20 00:00:00
 | 2022-03-09 00:00:00 |  | 2022-03-10 00:00:00 |  | 2022-03-21 00:00:00
 |  | 2022-03-09 00:00:00 |  |  | 2022-03-20 00:00:00
Spreadsheet: 62274d1263247046-pull-every-instance-index-match-criteria-into-consecutive-rows-directors-intervention-report-template
Sheet: Paste Logs

[01]lastfirst | Discipline Reporter | Outreach | Subtype | Entry Date | Custom | [NAME] | [NAME]
AAASFM, Test Student | Melehan | Brooks | 01-Classroom Visit | 2009-08-10 00:00:00 | [NAME] |  | 0
AAASFM, Test Student | Brooks | Brooks | 01-Classroom Visit | 2009-08-10 00:00:00 | Test student became upset because he or she isnt real and began swearing at me | No grades available | 4
AA, Test | Thompson | Bland | 04-Lead Counseling | 2009-08-10 00:00:00 | [NAME] is an awesome student. |  | 0
AA, Test | Mughannam | Melehan | 09-Other | 2009-08-12 00:00:00 | AA test isn't so awesome anymore. Failed 3 classes. |  | 0
Spreadsheet: 76350d1276856184-check-for-repeated-series-test
Sheet: Sheet1

fill in series |  |  | helper column | alter
12 | 22 | 90 | 122290
49 | 12 | 5 | 51249 | 0
11 | 32 | 50 | 113250 | 0
23 | 1 | 49 | 12349 | 0
12 | 5 | 49 | 51249 | 1
Spreadsheet: 188089d1350672882-matching-two-columns-of-data-in-two-different-worksheets-dummy-worksheet
Sheet: MON, DEC 31

 |  | DAILY DEPOSIT
 |  | Monday
 |  | Check Totals
 |  |  | Cash Totals
 |  | Deposit Total
[NAME] |  | Clerk2 |  | clerk3 |  | clerk4 |  | clerk5
Checks |  | Checks |  | Checks |  | Checks |  | Checks
No. | Amount | No. | Amount | No. | Amount | No. | Amount | No. | Amount
4269425 | 500 | 45902 | 600 | 79345 | 580
Checks |  | Checks |  | Checks |  | Checks |  | Checks
Cash |  | Cash |  | Cash |  | Cash |  | Cash
Spreadsheet: 111315d1307705984-excel-2007-looking-up-values-with-multiple-conditions-lookup_multiple_conditions
Sheet: Blad2

 | Daily score per person
 | Name | Day
 |  | mon | tue | wed | [NAME] | fri | sat | [NAME]
 | Henk | 50 | 60 | 20 | 50 | 40 | 60 | 50
 | Klaas | 20 | 50 | 20 | 0 | 20 | 30 | 20
 | Piet | 10 | 50 | 50 | 10 | 20 | 20 | 20
 | Kees | 50 | 40 | 50 | 10 | 20 | 50 | 40
 | Trees | 60 | 40 | 20 | 20 | 10 | 60 | 10
 | Klazina | 20 | 20 | 0 | 10 | 20 | 10 | 30
 | Trudi | 20 | 20 | 10 | 10 | 30 | 30 | 20
 | Hans | 10 | 10 | 20 | 20 | 30 | 20 | 10
 | Score per day lookup
 | Select Day |  | [NAME]
 |  | score:
 | Henk
 | Klaas
 | Piet
 | Kees
 | Trees
 | Klazina
 | Trudi
 | Hans
Spreadsheet: 077db0fc-e47d-4633-b9c3-b449efdf450f
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
RTUP | Test | RTUP | Rat [NAME], IgE | Rat [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
RTUP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
RTUP | Result | RTUP | Rat [NAME], IgE | Rat [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6226-5
Spreadsheet: 545161d1509325465-conditionally-summing-across-a-varying-number-of-worksheets-copy-of-example-book-allisonns-
Sheet: 1

Stock = | Stock 1 |  |  |  |  | Type = | Fund Type |  |  | These merged cells are successfully pulled by indirectly refernceing B1 and H1
Date |  | Event |  | Units |  | Transaction amount |  | CU | Year | <- there are other colomuns of data which are calculated but I cannot disclose what they are so in this example the year in column J is the reference to AJ in the post
2011-01-01 00:00:00 |  | Buy |  | 6000 |  | 7000
2011-01-20 00:00:00 |  | Dividend |  | 0 |  | 50
2011-02-28 00:00:00 |  | Sell |  | -500 |  | 580
2011-03-20 00:00:00 |  | Dividend |  | 0 |  | 45
2012-04-20 00:00:00 |  | Dividend |  | 0 |  | 45
2012-05-02 00:00:00 |  | Sell |  | -450 |  | 470
2013-05-20 00:00:00 |  | Dividend |  | 0 |  | 40
2013-06-20 00:00:00 |  | Dividend |  | 0 |  | 40
2015-07-20 00:00:00 |  | Dividend |  | 0 |  | 40
2015-08-05 00:00:00 |  | Sell |  | -1500 |  | 1740
2015-08-20 00:00:00 |  | Dividend |  | 0 |  | 20
2015-09-20 00:00:00 |  | Dividend |  | 0 |  | 20
2015-10-20 00:00:00 |  | Dividend |  | 0 |  | 20
2015-11-20 00:00:00 |  | Dividend |  | 0 |  | 20
2015-12-20 00:00:00 |  | Sell |  | -2000 |  | 2000
2016-01-01 00:00:00 |  | Buy |  | 400 |  | 400
2016-01-20 00:00:00 |  | Dividend |  | 0 |  | 20
2016-02-28 00:00:00 |  | Buy |  | 50 |  | 52
2016-03-20 00:00:00 |  | Dividend |  | 0 |  | 25
2016-04-20 00:00:00 |  | Dividend |  | 0 |  | 25
2016-05-02 00:00:00 |  | ROC |  | 0 |  | 25
2016-05-20 00:00:00 |  | Dividend |  | 0 |  | 25
2016-06-20 00:00:00 |  | Dividend |  | 0 |  | 25
2016-07-20 00:00:00 |  | Dividend |  | 0 |  | 25
2016-08-05 00:00:00 |  | Buy |  | 500 |  | 506
2016-08-20 00:00:00 |  | Dividend |  | 0 |  | 35
2016-09-20 00:00:00 |  | Dividend |  | 0 |  | 35
2016-10-20 00:00:00 |  | Dividend |  | 0 |  | 35
2016-11-20 00:00:00 |  | Dividend |  | 0 |  | 35
2016-12-20 00:00:00 |  | Dividend |  | 0 |  | 35
Spreadsheet: 881109d1729021693-calculating-number-of-winter-workdays-between-two-dats-revised-structural-erection-worksheet-test
Sheet: Sell Rate

 | COST CODE | [NAME] | WC CODE | SC TYPE | COST P/HR | PRICE P/HR | MARGIN P/HR | PROFIT P/HR
 | 18560 | [NAME]. EO13706 | 5221
 | 36010 | Unload & Shakeout under 30'-0" | 5040
 | 36020 | Erection under 30'-0" | 5040
 | 36030 | Plumb Bldg. under 30'-0" | 5040
 | 36040 | [NAME] Up under 30'-0" | 5040
 | 36050 | Decking under 30'-0" | 5040
 | 36060 | Welding under 30'-0" | 5040
 | 36070 | Studs under 30'-0" | 5040
 | 36080 | Trim/misc. under 30'-0" | 5040
 | 36090 | Install Wall Panels under 30'0" | 5040
 | 36100 | Install [NAME] under 30'-0" | 5040
 | 37010 | Unload & Shakeout 30'-0" and over | 5059
 | 37020 | Erection 30'-0" and over | 5059
 | 37030 | Plumb Bldg. 30'-0" and over | 5059
 | 37040 | [NAME] Up 30'-0" and over | 5059
 | 37050 | Decking 30'-0" and over | 5059
 | 37060 | Welding 30'-0" and over | 5059
 | 37070 | Studs 30'-0" and over | 5059
 | 37080 | Trim/misc. 30'-0" and over | 5059
 | 37090 | Install Wall Panels 30'-0" and over | 5059
 | 37100 | Install Roof Panels 30'-0" and over | 5059
Spreadsheet: 175201d1345455448-finding-data-that-match-in-two-different-sheets-or-list-updated-example
Sheet: Subscribers

Name | Address | Phone number | MAC Address | Location | Connected Port
A | 1 | 123456 | 00 00 00 00 01 | North | 1
B | 2 | 123457 | 00 00 00 00 02 | East | 1
C | 3 | 123458 | 00 00 00 00 03 | North | 2
D | 4 | 123459 | 00 00 00 00 04 | East | 2
E | 5 | 123460 | 00 00 00 00 05 | North | 3
F | 6 | 123461 | 00 00 00 00 06 | East | 3
G | 7 | 123462 | 00 00 00 00 07 | North | 4
H | 8 | 123463 | 00 00 00 00 08 | East | 4
I | 9 | 123464 | 00 00 00 00 09 | North | 5
J | 10 | 123465 | 00 00 00 00 10 | East | 5
K | 11 | 123466 | 00 00 00 00 11 | North | 6
L | 12 | 123467 | 00 00 00 00 12 | East | 6
M | 13 | 123468 | 00 00 00 00 13 | North | 7
N | 14 | 123469 | 00 00 00 00 14 | East | 7
O | 15 | 123470 | 00 00 00 00 15 | North | 8
P | 16 | 123471 | 00 00 00 00 16 | South | 6
Q | 17 | 123472 | 00 00 00 00 17 | South | 1
R | 18 | 123473 | 00 00 00 00 18 | South | 4
S | 19 | 123474 | 00 00 00 00 19 | South | 3
T | 20 | 123475 | 00 00 00 00 20 | South | 2
U | 21 | 123476 | 00 00 00 00 21 | South | 5
V | 22 | 123477 | 00 00 00 00 22 | West | 1
W | 23 | 123478 | 00 00 00 00 23 | West | 2
X | 24 | 123479 | 00 00 00 00 24 | West | 3
Y | 25 | 123480 | 00 00 00 00 25 | West | 4
Z | 26 | 123481 | 00 00 00 00 26 | West | 5
AA | 27 | 123482 | 00 00 00 00 27 | Centre | 1
AB | 28 | 123483 | 00 00 00 00 28 | Centre | 2
AC | 29 | 123484 | 00 00 00 00 29 | Centre | 3
AD | 30 | 123485 | 00 00 00 00 30 | Centre | 4
Spreadsheet: kate_symes__18221__EESSales_dailymarch
Sheet: 3-6

POSITIVE [NAME] = LONG POSITION
NEGATIVE VARIANCE = SHORT POSITION
NP15 | 2001-03-06 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak Long | 341 | Fixed Off Peak Long | 221.5 |  |  |  | Fixed Peak Long | 334.6 |  | Fixed Off Peak Long | 231.5 |  |  | Fixed Peak Long | 334.6 |  | Fixed Off Peak Long | 231.5
Fixed Peak Short | 351 | Fixed Off Peak Short | 231.5 |  |  |  | Fixed Peak Short | 344.6 |  | Fixed Off Peak Short | 236.5 |  |  | Fixed Peak Short | 344.6 |  | Fixed Off Peak Short | 236.5
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | 5.06 | 0 | 0 | -5.06 |  |  | 1 | -22.45 | 0 | 18 | -12.55 |  |  | 1 | 1.98 | 0 | 0 | -1.98
2 | 4.28 | 0 | 0 | -4.28 |  |  | 2 | -21.86 | 0 | 18 | -9.139999999999986 |  |  | 2 | 1.95 | 0 | 0 | -1.95
3 | 3.86 | 0 | 0 | -3.86 |  |  | 3 | -21.33 | 0 | 18 | -7.669999999999987 |  |  | 3 | 1.93 | 0 | 0 | -1.93
4 | 3.85 | 0 | 0 | -3.85 |  |  | 4 | -21.1 | 0 | 18 | -7.900000000000006 |  |  | 4 | 1.93 | 0 | 0 | -1.93
5 | 4 | 0 | 0 | -4 |  |  | 5 | -21.51 | 0 | 18 | -11.49 |  |  | 5 | 1.94 | 0 | 0 | -1.94
6 | 6.18 | 0 | 0 | -6.18 |  |  | 6 | -24.07 | 0 | 18 | -6.930000000000007 |  |  | 6 | 2.03 | 0 | 0 | -2.03
7 | 9.95 | 0 | 0 | -9.95 |  |  | 7 | 45.44 | 0 | 18 | -18.44 |  |  | 7 | 2.18 | 0 | 0 | -2.18
8 | 12.32 | 0 | 0 | -12.32 |  |  | 8 | 42.89 | 0 | 18 | -29.89 |  |  | 8 | 2.29 | 0 | 0 | -2.29
9 | 12.68 | 0 | 0 | -12.68 |  |  | 9 | 42.89 | 0 | 18 | -39.89 |  |  | 9 | 2.3 | 0 | 0 | -2.3
10 | 11.83 | 0 | 0 | -11.83 |  |  | 10 | 43.88 | 0 | 18 | -45.88 |  |  | 10 | 2.27 | 0 | 0 | -2.27
11 | 11.65 | 0 | 0 | -11.65 |  |  | 11 | 43.86 | 0 | 18 | -49.86 |  |  | 11 | 2.26 | 0 | 0 | -2.26
12 | 12.99 | 0 | 0 | -12.99 |  |  | 12 | 42.19 | 0 | 18 | -51.19 |  |  | 12 | 2.31 | 0 | 0 | -2.31
13 | 12.97 | 0 | 0 | -12.97 |  |  | 13 | 54.41 | 0 | 18 | -52.41 |  |  | 13 | 2.31 | 0 | 0 | -2.31
14 | 12.85 | 0 | 0 | -12.85 |  |  | 14 | 68.88 | 0 | 18 | -52.88 |  |  | 14 | 2.3 | 0 | 0 | -2.3
15 | 12.46 | 0 | 0 | -12.46 |  |  | 15 | 70.08 | 0 | 18 | -52.08 |  |  | 15 | 2.29 | 0 | 0 | -2.29
16 | 12.56 | 0 | 0 | -12.56 |  |  | 16 | 69.44 | 0 | 18 | -49.44 |  |  | 16 | 2.3 | 0 | 0 | -2.3
17 | 12.79 | 0 | 0 | -12.79 |  |  | 17 | 69.57 | 0 | 18 | -44.57 |  |  | 17 | 2.3 | 0 | 0 | -2.3
18 | 14.25 | 0 | 0 | -14.25 |  |  | 18 | 67.75 | 0 | 18 | -44.75 |  |  | 18 | 2.37 | 0 | 0 | -2.37
19 | 16.4 | 0 | 0 | -16.4 |  |  | 19 | 65.47 | 0 | 18 | -43.47 |  |  | 19 | 2.45 | 0 | 0 | -2.45
20 | 15.01 | 0 | 0 | -15.01 |  |  | 20 | 66.83 | 0 | 18 | -38.83 |  |  | 20 | 2.4 | 0 | 0 | -2.4
21 | 13.51 | 0 | 0 | -13.51 |  |  | 21 | 68.8 | 0 | 18 | -33.8 |  |  | 21 | 2.34 | 0 | 0 | -2.34
22 | 11.93 | 0 | 0 | -11.93 |  |  | 22 | 69.91 | 0 | 18 | -24.91 |  |  | 22 | 2.27 | 0 | 0 | -2.27
23 | 9.49 | 0 | 0 | -9.49 |  |  | 23 | 0.210000000000008 | 0 | 18 | -17.21 |  |  | 23 | 2.17 | 0 | 0 | -2.17
24 | 6.98 | 0 | 0 | -6.98 |  |  | 24 | 2.800000000000011 | 0 | 18 | -4.800000000000011 |  |  | 24 | 2.06 | 0 | 0 | -2.06
Spreadsheet: 34576d1231885107-grouping-patients-by-age-in-a-pivot-table-the-way-i-want-agegroup
Sheet: Sheet1

Patient | Age | AgeGroup | Surgery | Etc |  |  |  |  | AgeGroup Table
A | 82 | 76-105 | etc. |  |  |  |  |  | 5 | 5-12
B | 47 | 46-55 |  |  |  |  |  |  | 13 | 13-18
C | 74 | 66-75 |  |  |  |  |  |  | 19 | 19-25
D | 97 | 76-105 |  |  |  |  |  |  | 26 | 26-35
E | 55 | 46-55 |  |  |  |  |  |  | 36 | 36-45
F | 66 | 66-75 |  |  |  |  |  |  | 46 | 46-55
G | 14 | 13-18 |  |  |  |  |  |  | 56 | 56-65
H | 52 | 46-55 |  |  |  |  |  |  | 66 | 66-75
I | 19 | 19-25 |  |  |  |  |  |  | 76 | 76-105
J | 29 | 26-35
K | 47 | 46-55
L | 40 | 36-45
M | 31 | 26-35
N | 49 | 46-55
O | 75 | 66-75
P | 13 | 13-18
Q | 36 | 36-45
R | 72 | 66-75
S | 21 | 19-25
T | 28 | 26-35
U | 86 | 76-105
V | 9 | 5-12
W | 10 | 5-12
X | 34 | 26-35
Y | 85 | 76-105
Z | 43 | 36-45
Spreadsheet: 811900d1672853105-advanced-lookup-and-exclusions-230104-excel-help-1
Sheet: Sheet1

Window |  |  |  | CUT | CUT | WINDOW
Tag | MARK |  | [NAME] | WIDTH | HEIGHT | MODEL |  |  | Mark | QTY | [NAME] | Height | Model |  |  |  | QDH
15-1 | A | S | Room 1 | 51.5 | 101.5 | Marchand C.II |  |  | A |  |  |  |  |  |  |  | PDH
15-2 | A | S | Room 2 | 51.5 | 101.5 | Marchand C.II |  |  | H |  |  |  |  |  |  |  | PTBRDH
15-3 | B | S | Room 3 | 41.75 | 101.5 | Marchand C.II |  |  | B |  |  |  |  |  |  |  | PTBREGHDH
15-4 | B | S | Room 4 | 41.75 | 101.5 | Marchand C.II |  |  |  |  |  |  |  |  |  |  | DHPIC
15-5 | A | S | Room 5 | 51.5 | 101.5 | Marchand C.II |  |  |  |  |  |  |  |  |  |  | VPL
15-6 | A | S | Room 6 | 51.5 | 101.5 | Marchand C.II |  |  |  |  |  |  |  |  |  |  | VPR |  | Items to exclude from model range
15-7 | C | S | Room 7 | 36 | 72 | QDH |  |  |  |  |  |  |  |  |  |  | HP
15-8 | D | S | Room 8 | 42 | 72 | PDH |  |  |  |  |  |  |  |  |  |  | CPPIC
15-9 | A | S | Room 9 | 51.5 | 101.5 | Marchand C.II |  |  |  |  |  |  |  |  |  |  | VPLE
15-10 | E | S | Room 10 | 48 | 72 | VPR |  |  |  |  |  |  |  |  |  |  | VPRE
15-11 | F | S | Room 11 | 60 | 72 | CPPIC |  |  |  |  |  |  |  |  |  |  | HPE
15-12 | G | S | Room 12 | 38 | 72 | PTBRDH |  |  |  |  |  |  |  |  |  |  | CPPICE
15-13 | A | S | Room 13 | 51.5 | 101.5 | Marchand C.II |  |  |  |  |  |  |  |  |  |  | Choice 1
15-14 | H | S | Room 14 | 51.5 | 101.5 | Choice 1 |  |  |  |  |  |  |  |  |  |  | Choice 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 6 |  | Items I would like to pull from
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marchand C.II
Spreadsheet: darron_c_giron__8050__2000
Sheet: Aug 2000

Done after bid-week:
Telerate/Price Basis/Quotes/Deals/OTC/Pub Posting
Pull up Crude Merc value & update cell E9 |  |  |  |  | Date,F5,%Nxavcprompt,F3
Update following cells from Gas Market Report
 |  | Note: Insert the #'s in blue to calculate the customer price
 |  | Crude Merc | IF-Elpaso Perm | IF-HH | IF-Elpaso/SJ | IF-TW-Permian
 |  | 31.138 | 3.77 | 3.83 | 3.5 | 3.8
CPR# | Sitara # | TAGG # | PanEnergy/Duke | Facility | Term | Calculated Price
98063 | 27258 | E21728 | 2,500/day | 506767 | 7/95-12/2001
CPR# | Sitara # | TAGG # | Union Pacific | Facility | Term | Calculated Price
48853 | 106622 | E11400 | 2,500/day | 506767 | 1/92-12/2003
CPR# | Sitara # | TAGG # | Union Pacific | Facility | Term | Calculated Price
3217 | 106624 | E22656 | 7,000/day | 506767 | 1/95-12/2001
CPR# | Sitara # | TAGG # | Vastar | Facility | Term | Calculated Price
394674 | 27253 | E21977 | 10,000/day | 506766 | 6/96-4/2002
CPR# | Sitara # | TAGG # | Agave/Yates | Facility | Term | Calculated Price
93788 | 27245 | E20337 | 10,000/day | 58649 | 1/93-12/2002 |  | * moved to Central desk for March
 |  | Last Update:
Spreadsheet: 646750d1572009590-sales-commission-formula-help-sales-commission-plan-mike
Sheet: Sheet1

[NAME] | January | February | March | April | May | June | July | August | September | October | November | December | 2020 Revenue
Target
Earned | 150000 |  | 150000 |  |  |  |  |  |  | 210000
Commission
Salary
Total
Should be
Accum
0.03 |  |  |  |  |  |  |  |  |  |  |  |  | 3% of delivered revenue if under target
0.05 |  |  |  |  |  |  |  |  |  |  |  |  | 5% of delivered revenue if on target
Over
0.05
0.1
Total Over |  |  |  |  |  |  |  |  |  |  |  |  | 10% of revenue delivered that is over target (so you get 5% for hitting and then 10% for anything delivered above target)
Once hit 1.5m accumulative that month should be, 5% up to the 1.5m then 10% |  |  |  |  |  |  |  |  | 10% @
So in October that is hit so commission should be |  |  |  |  |  |  |  |  | 5% @
 | Target | Commission
Q1
Q2 |  |  |  |  |  |  |  |  | October commission should be
Q3
Q4
Commission Structure
3% of delivered revenue if under target
5% of delivered revenue if on target
10% of revenue delivered that is over target (so you get 5% for hitting and then 10% for anything delivered above target)
10% of revenue delivered after $1.5m
Spreadsheet: 214384d1360881176-populating-1st-and-2nd-highest-occurence-of-an-instance-per-category-book-1-sample-solution
Sheet: Team Employees

 | Retail_FL_Orlando
 | Name | Late to Work | No lunch taken | Complaint-Communication | Complaint-Attire Violation | Complaint-Ethical Conduct
Spreadsheet: ce52f423-657a-461e-9034-489a438aa733
Sheet: Sheet1

Release: ADP National Employment Report | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=194
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-12-20 1:41 PM CST
 | Real-Time | Period
Name: | Start | End
ADP National Employment Report | 2011-02-02 00:00:00 | Current
Link:
http://www.adpemploymentreport.com/ | 2011-02-02 00:00:00 | Current
Source:
Automatic Data Processing, Inc. | 2011-02-02 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:
2011-02-02 00:00:00
2011-03-02 00:00:00
2011-03-30 00:00:00
2011-05-04 00:00:00
2011-06-01 00:00:00
2011-07-07 00:00:00
2011-08-03 00:00:00
2011-08-31 00:00:00
2011-10-05 00:00:00
2011-11-02 00:00:00
2011-11-30 00:00:00
2012-01-05 00:00:00
2012-02-01 00:00:00
2012-03-07 00:00:00
2012-04-04 00:00:00
2012-05-02 00:00:00
2012-05-31 00:00:00
2012-07-05 00:00:00
2012-08-01 00:00:00
2012-09-06 00:00:00
2012-10-03 00:00:00
2012-10-24 00:00:00
2012-11-01 00:00:00
2012-12-05 00:00:00
2013-01-03 00:00:00
2013-01-30 00:00:00
2013-03-06 00:00:00
2013-04-03 00:00:00
2013-05-01 00:00:00
2013-06-05 00:00:00
2013-07-03 00:00:00
2013-07-31 00:00:00
2013-09-05 00:00:00
2013-10-02 00:00:00
2013-10-30 00:00:00
2013-12-04 00:00:00
2014-01-08 00:00:00
2014-02-05 00:00:00
2014-03-05 00:00:00
2014-04-02 00:00:00
2014-04-30 00:00:00
2014-06-04 00:00:00
2014-07-02 00:00:00
2014-07-30 00:00:00
2014-09-04 00:00:00
2014-10-01 00:00:00
2014-11-05 00:00:00
2014-12-03 00:00:00
Spreadsheet: 847056d1698154710-calculating-hours-worked-overtime-test
Sheet: Sheet1

 |  | Enter start time: 24hr clock | Enter time work over lunch. ie 00:30 minuets worked | Enter finish time: 24hr clock | Hours worked | Running total of overtime. | Final running total of overtime
Date | Day | Start | Lunch | Finish | Hours | Overtime | Total
2023-10-25 00:00:00 | Wed | 08:00:00 |  | 17:00:00 |  | 01:00:00 | 01:00:00
2023-10-26 00:00:00 | Thu | 08:00:00 |  | 17:00:00 |  | 02:00:00 | 02:00:00
2023-10-27 00:00:00 | Fri | 09:00:00 |  | 15:00:00 |  | 02:00:00 | 00:00:00
2023-10-28 00:00:00 | Sat
2023-10-29 00:00:00 | Sun
2023-10-30 00:00:00 | Mon
2023-10-31 00:00:00 | Tue
2023-11-01 00:00:00 | Wed
2023-11-02 00:00:00 | Thu
2023-11-03 00:00:00 | Fri
2023-11-04 00:00:00 | Sat
2023-11-05 00:00:00 | Sun
2023-11-06 00:00:00 | Mon
2023-11-07 00:00:00 | Tue
2023-11-08 00:00:00 | Wed
2023-11-09 00:00:00 | Thu
2023-11-10 00:00:00 | Fri
2023-11-11 00:00:00 | Sat
2023-11-12 00:00:00 | Sun
2023-11-13 00:00:00 | Mon
2023-11-14 00:00:00 | Tue
2023-11-15 00:00:00 | Wed
2023-11-16 00:00:00 | Thu
2023-11-17 00:00:00 | Fri
2023-11-18 00:00:00 | Sat
2023-11-19 00:00:00 | Sun
2023-11-20 00:00:00 | Mon
2023-11-21 00:00:00 | Tue
2023-11-22 00:00:00 | Wed
2023-11-23 00:00:00 | Thu
2023-11-24 00:00:00 | Fri
2023-11-25 00:00:00 | Sat
2023-11-26 00:00:00 | Sun
2023-11-27 00:00:00 | Mon
2023-11-28 00:00:00 | Tue
2023-11-29 00:00:00 | Wed
2023-11-30 00:00:00 | Thu
2023-12-01 00:00:00 | Fri
Spreadsheet: 727989d1618240828-match-randomly-selected-rows-of-data-test-sheet
Sheet: random

Randomly selected numbers
147
215
236
277
284
300
308
316
346
362
366
393
410
485
491
538
542
547
549
569
577
591
617
630
633
641
671
684
685
686
707
720
731
802
816
817
865
866
887
959
961
963
984