tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 153359d1335883901-help-needed-to-revise-a-formula-cricket-results-template
Sheet: Sheet2

TEAM | Pl | W | Wd | T | A | Ld | L | [NAME] | BWL | Dct | Pts
A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | `
G | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
J | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
K | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
L | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 218734d1362564685-conditional-formatting-based-on-selection-and-cell-value-map1
Sheet: Blad1

 |  |  | week 1 | week 2 | week 3 | week 4 | week 5 | week 6 | week 7 | week 8 | week 9 | week 10 | week 11 |  |  |  | dropdown
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | name
 | piet |  | 1 |  |  |  | 3 |  |  |  |  |  | 1
 | jan |  | 2 | 1 |  | 1 | 3
 | kees |  | 3 | 1 | 1 | 2 |  | 1 | 1
 | [NAME] |  |  | 3 |  |  |  | 1 |  | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Legend
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | week 1 | week 2 | week 3 | week 4 | week 5 | week 6 | week 7 | week 8 | week 9 | week 10 | week 11 |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | [NAME]
 | piet |  | 1 |  |  |  | 3 |  |  |  |  |  | 1
 | jan |  | 2 | 1 |  | 1 | 3
 | kees |  | 3 | 1 | 1 | 2 |  | 1 | 1
 | [NAME] |  |  | 3 |  |  |  | 1 |  | 1 | 1 | 1
 |  |  | week 1 | week 2 | week 3 | week 4 | week 5 | week 6 | week 7 | week 8 | week 9 | week 10 | week 11
 | [NAME]
 | piet |  | 1 |  |  |  | 3 |  |  |  |  |  | 1
 | jan |  | 2 | 1 |  | 1 | 3
 | kees |  | 3 | 1 | 1 | 2 |  | 1 | 1
 | [NAME] |  |  | 3 |  |  |  | 1 |  | 1 | 1 | 1
Spreadsheet: 599299d1542960476-sum-until-value-change-in-other-cell-giwi342-installement-schedule_maras
Sheet: Sheet1

 |  |  | Today
 |  |  | This week
 |  |  | Next week |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1253973-sum-until-value-change-in-other-cell.html
nt |  | 2015-02-02 00:00:00 | Past due
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 60%
Order | Year | Client | Project | Salesman | Salesman filter | Start | End | Week | Sale Price 1 | Sale price 2 | sale price total | Manager | Manager fee | Contractor | contractor 2 | Cost 1 | Cost2 | Cost 3 | Total cost | Invoice 1 nr | Invoice 2 nr | Income | Cost/Sale ration | Done? | Warranty? | Comment
1 | 2017 | Client 1 | Doors | [NAME] |  |  | 2018-08-15 00:00:00 |  | 100 | 75 |  | [NAME] | 400 | Comp1 |  | 172.64 |  |  |  | inv1 |  |  |  | [NAME] | [NAME]
1 | 2017 | Client 1 | Windows | [NAME] |  |  | 2018-08-30 00:00:00 |  | hourly |  |  |  |  | Comp2 |  | hourly |  |  |  | inv2 |  |  |  | [NAME]
2 | 2018 | Client 2 | [NAME] | [NAME] |  |  | 2018-04-30 00:00:00 |  | 290 | 240 |  |  |  | Comp1 | [NAME] |  | 23.33 |  |  |  |  |  |  | [NAME]
2 | 2018 | Client 2 | [NAME] | [NAME] |  |  | 2018-08-15 00:00:00 |  | hourly |  |  |  |  | Comp1 | [NAME] | 255 |  | 127.5 |  | inv2 |  |  |  | [NAME]
4 | 2018 | Client 3 | Doors 1 | Ana |  |  | 2018-08-30 00:00:00 |  | 276 |  |  |  |  | Comp2 |  | hourly |  |  |  |  |  |  |  | [NAME]
4 | 2018 | Client 3 | Doors 2 | Ana |  |  | as agreed |  | 1770 |  |  |  |  | Comp2 |  | hourly |  |  |  |  |  |  |  | [NAME]
4 | 2018 | Client 3 | Doors 3 | Ana |  | 2018-11-19 00:00:00 | 2018-11-26 00:00:00 |  | - | 130 |  |  |  | Comp1 |  | hourly
5
6 | 2018 | Client 4 | Windows | [NAME] |  |  | 2018-11-18 00:00:00 |  | 125 | 150 |  |  |  | Comp1 |  | hourly
Spreadsheet: darrell_schoolcraft__7304__imball0201
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -14 |  | -54985 | -54900
2 |  |  | -45523 | -45012
3 | -19469 | -20000 | -31996 | -29900
4 | -10157 | -10000 | -65915 | -65318
5 | -29699 | -29869 | -63672 | -63430
6 | -29789 | -29869 | -64157 | -63430
7 | -29899 | -29869 | -83960 | -83430
8 | -10720 | -10152 | -104080 | -104207
9 | -14972 | -15000 | -57592 | -56846
10 | -14997 | -15000 | -93909 | -93216
11 | -613 |  | -79398 | -78955
12 | -5137 | -5000 | -58921 | -59382
13 | -5527 | -5000 | -59922 | -59382
14 | -5814 | -5000 | -57766 | -57060
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 9676
2002-01-14 00:00:00
CBS $
 |  |  | 19943.24
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: TX-HPLC-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  [NAME]
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 99535201 | 221006148
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 945464 | 2103758
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 100480665 | 223109906
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -107207815 | -234483179
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -560742 | -1235219
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 4897 | 10279
 | Total Purchases: |  | -107763660 | -235708119
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 7432860 | 16558086
12 |  | Purchases | -3016138 | -6891414
 | Total Intra CTS Sales / Purchases |  | 4416722 | 9666672
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 5782004 | 12388086
18 |  | W/D (Purchase from Stg) | -11133135 | -25278604
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -11133135 | -25278604
 | Total Storage: |  | -5351131 | -12890518
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 8217404 | 16825093.1723516
 |  |  | 0 | 0
23 | Fuel: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -2483631.66
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -2483631.66
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -838
36 |  | Asset Group Demand Charges | 0 | -108300
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 348799
 |  | TOTAL INTRA-MTH
Spreadsheet: holden_salisbury__12316__$ Calculator
Sheet: Bal of Month

Balance of Month   (25 MW Block) |  |  |  |  |  |  |  |  | Balance of Month   (25 MW Block)
 |  |  | Days |  | Price |  |  |  |  |  |  | Days |  | Price
 |  | Buy | 25 | at | 33.25 |  |  |  |  |  | Buy | 1 | at | 100
 | and |  |  |  |  |  |  |  |  | and
 |  | Sell | 12 | at | 31 |  |  |  |  |  | Sell | 19 | at | 47
To Breakeven : |  |  |  | at |  |  |  |  | To Breakeven : |  |  |  | at
To Show Profit : |  |  |  | at | 65 |  |  |  | To Show Profit : |  |  |  | at | 45.5
 |  | = |  |  |  |  |  |  |  |  | =
Balance of Month   (25 MW Block)
 |  |  | Days |  | Price
 |  | Buy | 20 | at | 33.75
 | and
 |  | Sell | 2 | at | 20
To Breakeven : |  |  |  | at
To Show Profit : |  |  |  | at | 33
 |  | =
Spreadsheet: 273014d1382576421-vlookup-nested-functions-sample-file_102313
Sheet: Team A

Overall Team Satisfaction
LastName | FirstName | Satisfaction with Team Performance? | Comments
Poppins | [NAME]
Test2 | [NAME]
Test3 | Anna
Test4 | [NAME]
Test5 | Dawson
Test6 | [NAME]
 |  | Team Member % Contribution Summary
 |  | [NAME]
Reviewer |  |  |  |  |  |  |  | Expected Results
 |  |  |  |  |  |  |  | Expected Results
 |  |  |  |  |  |  |  | Continues with all team members
Spreadsheet: 1ff11d99-3cae-4a28-ba98-7af6182e56bf
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7942 | 52617 | Wayne | Fong | USA | 1782 | 00:23:48 | 00:18:49 | 01:13:17 | 00:06:41 | [NAME] | 1 | 02:44:13
Spreadsheet: 153225d1335808721-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: APR 25

DATE | MON | TUES | WED | THUR | FRI | SAT
 | 2011-04-25 00:00:00 | 2011-04-26 00:00:00 | 2011-04-27 00:00:00 | 2011-04-28 00:00:00 | 2011-04-29 00:00:00 | 2011-04-30 00:00:00
[NAME] | off | 9:30-5:30 | 8:00-5:00 | 9:00-5:00 | 8:30-5:30 | 9:15-5:15
 |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00
[NAME] | 8:30-5:30 | 9:30-5:30 | 9:30-5:30 | 8:30-5:30 | 9:30-5:30
 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | 8:00-4:00
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00
Mark | 8:30-5:30 | 8:30-5:00 | 8:30-5:30 | 8:30-5:30 | off | 9:00-5:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 |  | n/l
[NAME] | 8:00-4:00 | off | 8:30-5:30 | 7:00-4:00-HOMER | 8:00-5:00 | 9:15-5:15-ctr
 | 11:00-12:00 |  | 11:00-12:00 | 1UB | 11:00-12:00 | n/l
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 14 - Table 2

Canada results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume ('000 hl) | 8645.44925344 | -571.768 | 0 | -201.2109574399999 | 7872.470296 | -0.08940876694550415 | -0.0249218356687377
Net revenue | 2847.951 | -67.244 | -114.5486065010779 | -39.82339349892199 | 2626.335 | -0.07781594556928828 | -0.01432131954172877
Net revenue/hl | 329.4161953315275 | 15.00005206679623 | -14.55052889298031 | 3.744304937290622 | 333.6100234426341 | 0.01273109267407402 | 0.01087145268428717
[NAME] | -906.8960000000001 | 35.119 | 34.35550659311721 | 49.72049340688284 | -787.701 | -0.1314318290079568 | -0.05703349985934802
[NAME]/hl | -104.8986551669537 | -3.078978905305078 | 4.36400587126677 | 3.555962642033904 | -100.0576655589581 | -0.04614920563367386 | -0.03293240005290585
Gross profit | 1941.055 | -32.125 | -80.19309990796069 | 9.89709990796085 | 1838.634 | -0.05276563518292876 | 0.005184632180310881
Gross margin | 0.6815619369855731 | 0 | 0 | 0 | 0.7000759613682185 | 190 | 140
SG&A excl. deprec.&amort. | -909.523 | 2.539 | 37.50734316742283 | 9.547656832577164 | -859.929 | -0.05452748308728872 | -0.01052681947264468
SG&A deprec.&amort. | -45.427 | 0 | 1.247875685856933 | 15.56812431414307 | -28.611 | -0.3701763268540736 | -0.3427064149986366
SG&A total | -954.95 | 2.539 | 38.75521885327986 | 25.11578114672023 | -888.54 | -0.06954290800565488 | -0.0263707382072658
Other operating income/expenses | 1.153 | 0 | -0.3189582639778996 | 7.1339582639779 | 7.968 | nm | nm
Normalized EBIT | 987.2579999999998 | -29.586 | -41.75683931865873 | 42.14683931865899 | 958.062 | -0.02957281683207413 | 0.04400968110027128
Normalized EBIT margin | 0.3466555428797756 | 0 | 0 | 0 | 0.3647904779854816 | 180 | 200
Normalized EBITDA | 1132.616 | -29.586 | -46.98534728654364 | 21.8953472865436 | 1077.94 | -0.04827408406732725 | 0.01985018293840023
Normalized EBITDA margin | 0.397695044612776 | 0 | 0 | 0 | 0.4104350739719038 | 130 | 140
Spreadsheet: 144564d1331044728-conditional-formatting-based-on-cell-references-not-values-test
Sheet: Summery

 | Quantity | Cost Each | Cost Toal | Freight | Freight Total |  | Total Cost
 | 4
 | 5
 |  |  |  | WidgetB has the wrong freight pulled from the Data Sheet. I want to have a Condittional Formating rule that will show when the wrong Row on the DATA table is referenced in the formula of cell E3. The Cost and the freight are o nthe same rows in the Data sheets.
Spreadsheet: 682695d1592268532-check-the-items-from-a-table-check_from_table
Sheet: BenchMarking_Check

Project total Cost | Project Management % Range
Over $250m | 3.0% - 4.0%
$100m - $250m | 4.0% - 5.5 %
$50m - 100m | 5.5% - 7.5%
Less than $50m | 7.5% - 13%
Project cost | Project management Cost | Project management %
110000000 |  |  | TOO HIGH | The project management for this is 8% but from table above it should be between 4.0 to 5.5%, so need a formula / way for excel to tell me its too high
55000000 |  |  | TOO LOW | The formula should say too low as it should be between 5.5 and 7.5%
Spreadsheet: 798876d1664795135-pasting-dates-do-not-change-bookings-at
Sheet: Bookings

Booking Date | Visit Date | Guest Name | Lead Time | Adults | Children | Infants FOC | Adults FOC | Children FOC | Reason for FOC | Total Pax | Booking Type | Booking Source | Paid
2022-10-31 00:00:00 | 2022-11-01 00:00:00 | [NAME] |  | 2 | 2 |  | 2 | 2 |  |  |  |  | YES
Spreadsheet: 771138d1646440556-conditional-formating-based-on-the-some-values-example-matej1702-
Sheet: Sheet1

Input
2022-01-01 00:00:00 | [NAME] | Dog |  |  | Compare values based on values in column C
2022-01-02 00:00:00 | [NAME] | Dog |  |  | Number of same values is randomly
2022-01-03 00:00:00 | [NAME] | Dog |  |  | i need fill each second entry fill with another colour
2022-01-04 00:00:00 | Persian | Cat
2022-01-05 00:00:00 | Persian | Cat
2022-01-06 00:00:00 | My | Cat
2022-01-07 00:00:00 | Fero | Goose
2022-01-08 00:00:00 | [NAME] | Goose
2022-01-09 00:00:00 | Karol | Dog
2022-01-10 00:00:00 | Matus | dog
2022-01-11 00:00:00 | Karol | [NAME]
2022-01-12 00:00:00 | Jozeg | [NAME]
Output
2022-01-01 00:00:00 | [NAME] | Dog
2022-01-02 00:00:00 | [NAME] | Dog
2022-01-03 00:00:00 | [NAME] | Dog
2022-01-04 00:00:00 | Persian | Cat
2022-01-05 00:00:00 | Persian | Cat
2022-01-06 00:00:00 | My | Cat
2022-01-07 00:00:00 | Fero | Goose
2022-01-08 00:00:00 | [NAME] | Goose
2022-01-09 00:00:00 | Karol | Dog
2022-01-10 00:00:00 | Matus | dog
2022-01-11 00:00:00 | Karol | [NAME]
2022-01-12 00:00:00 | Jozeg | [NAME]
Spreadsheet: 679503d1590460086-how-to-capture-multiple-absences-for-a-specific-employee-and-tabulate-total-time-off-absence-sample-3-
Sheet: Sheet9

PERSON_NUMBER | Leave Type | START_DATE | END_DATE | DURATION in DAYS | Check | Consecutive Days | Comments
1111 | Exception Illness Leave Paid | 2019-07-01 00:00:00 | 2020-06-25 00:00:00 | 329
1111 | Exception Illness Leave Paid | 2019-01-21 00:00:00 | 2019-06-28 00:00:00 | 158
1111 | Exception Illness Leave Paid | 2018-04-23 00:00:00 | 2018-10-17 00:00:00 | 177
2222 | Exception Illness Leave Unpaid | 2018-09-03 00:00:00 | 2020-05-25 00:00:00 | 630
2222 | Exception Illness Leave Unpaid | 2018-04-02 00:00:00 | 2018-08-31 00:00:00 | 151
3333 | General Leave | 2020-04-21 00:00:00 | 2020-07-17 00:00:00 | 87
3333 | General Leave | 2019-09-23 00:00:00 | 2020-01-03 00:00:00 | 102
4444 | General Leave | 2020-04-06 00:00:00 | 2020-06-01 00:00:00 | 53 |  |  | 3 consequtive periods
4444 | General Leave | 2020-01-01 00:00:00 | 2020-04-03 00:00:00 | 4
4444 | General Leave | 2019-01-02 00:00:00 | 2019-12-31 00:00:00 | 363
5555 | Long Term Disability | 2019-05-21 00:00:00 | 2020-05-28 00:00:00 | 370
5555 | Long Term Disability | 2018-05-21 00:00:00 | 2019-05-20 00:00:00 | 364
6666 | Long Term Disability | 2020-01-31 00:00:00 | 2020-05-25 00:00:00 | 115
6666 | Long Term Disability | 2019-07-02 00:00:00 | 2019-12-03 00:00:00 | 154
6666 | Long Term Disability | 2018-03-09 00:00:00 | 2019-02-18 00:00:00 | 346
7777 | Maternity Leave | 2020-02-28 00:00:00 | 2020-05-25 00:00:00 | 87 |  |  | End date past today
7777 | Maternity Leave | 2019-03-01 00:00:00 | 2020-02-27 00:00:00 | 363
8888 | STD NonCompliant | 2020-02-13 00:00:00 | 2020-06-25 00:00:00 | 102
8888 | STD NonCompliant | 2020-01-27 00:00:00 | 2020-02-11 00:00:00 | 15
8888 | STD NonCompliant | 2019-08-26 00:00:00 | 2019-09-30 00:00:00 | 35 |  |  | Continued, but in the past
8888 | STD NonCompliant | 2019-06-20 00:00:00 | 2019-08-25 00:00:00 | 52
Spreadsheet: 687330d1595127948-need-help-to-do-a-look-up-function-base-on-2-criteria-in-two-table-fpl
Sheet: Sheet2

family size | min | [NAME] | FPL
1 | 0 | 12490 | 1
1 | 12491 | 18735 | 1.5
1 | 18736 | 24980 | 2
1 | 24981 | 31225 | 2.5
1 | 31226 | 37470 | 3
1 | 37471 | 49960 | 4
2 | 0 | 16910 | 1
2 | 16911 | 25365 | 1.5
2 | 25366 | 33820 | 2
2 | 33821 | 42275 | 2.5
2 | 42276 | 50730 | 3
2 | 50731 | 67640 | 4
3 | 0 | 21330 | 1
3 | 21331 | 31995 | 1.5
3 | 31996 | 42660 | 2
3 | 42661 | 53325 | 2.5
3 | 53326 | 63990 | 3
3 | 63991 | 85320 | 4
4 | 0 | 25750 | 1
4 | 25751 | 38625 | 1.5
4 | 38626 | 51500 | 2
4 | 51501 | 64375 | 2.5
4 | 64376 | 77250 | 3
4 | 77251 | 103000 | 4
5 | 0 | 30170 | 1
5 | 30171 | 45255 | 1.5
5 | 45256 | 60340 | 2
5 | 60341 | 75425 | 2.5
5 | 75426 | 90510 | 3
5 | 90511 | 120680 | 4
6 | 0 | 34590 | 1
6 | 34591 | 51885 | 1.5
6 | 51886 | 69180 | 2
6 | 69181 | 86475 | 2.5
6 | 86476 | 103770 | 3
6 | 103771 | 138360 | 4
7 | 0 | 39010 | 1
7 | 39011 | 58515 | 1.5
7 | 58516 | 78020 | 2
7 | 78021 | 97525 | 2.5
7 | 97526 | 117030 | 3
7 | 117031 | 156040 | 4
8 | 0 | 43430 | 1
8 | 43431 | 65145 | 1.5
8 | 65146 | 86860 | 2
8 | 86861 | 108575 | 2.5
8 | 108576 | 130290 | 3
8 | 130291 | 173520 | 4
9 | 0 | 47750 | 1
9 | 47751 | 69465 | 1.5
9 | 69466 | 91180 | 2
9 | 91181 | 112895 | 2.5
9 | 112896 | 134610 | 3
9 | 134611 | 177840 | 4
10 | 0 | 52070 | 1
10 | 52071 | 73785 | 1.5
10 | 73786 | 95500 | 2
10 | 95501 | 117215 | 2.5
10 | 117216 | 138930 | 3
10 | 138931 | 182160 | 4
11 | 0 | 56390 | 1
11 | 56391 | 78105 | 1.5
11 | 78106 | 99820 | 2
11 | 99821 | 121535 | 2.5
11 | 121536 | 143250 | 3
11 | 143251 | 186480 | 4
12 | 0 | 60710 | 1
12 | 60711 | 82425 | 1.5
12 | 82426 | 104140 | 2
12 | 104141 | 125855 | 2.5
12 | 125856 | 147570 | 3
12 | 147571 | 190800 | 4
13 | 0 | 65030 | 1
13 | 65031 | 86745 | 1.5
13 | 86746 | 108460 | 2
13 | 108461 | 130175 | 2.5
13 | 130176 | 151890 | 3
13 | 151891 | 195120 | 4
14 | 0 | 69350 | 1
14 | 69351 | 91065 | 1.5
14 | 91066 | 112780 | 2
14 | 112781 | 134495 | 2.5
14 | 134496 | 156210 | 3
14 | 156211 | 199440 | 4
15 | 0 | 73670 | 1
15 | 73671 | 95385 | 1.5
15 | 95386 | 117100 | 2
15 | 117101 | 138815 | 2.5
15 | 138816 | 160530 | 3
15 | 160531 | 203760 | 4
16 | 0 | 77990 | 1
16 | 77991 | 99705 | 1.5
16 | 99706 | 121420 | 2
16 | 121421 | 143135 | 2.5
16 | 143136 | 164850 | 3
16 | 164851 | 208080 | 4
Spreadsheet: 854233d1704192832-looking-for-a-formula-ifs-with-multi-criteria-sample-sheet
Sheet: Detail

[NAME] ([NAME]'s) | ALL | X | Y | Z |  |  | example
0.5 - 5.00 |  | 4 |  |  |  |  | x has 4 enteries from main sheet from weight dimin 0.50 to 5.00
5.50 - 10.00
10.50 - 15.00 |  | 1 |  |  |  |  | x has 1 entry from main sheet from weight dimin 10.50 to 15.00
15.50 - 20.00
20.50 - 25.00
25.50 - 30.00
30.50 - 35.00
35.50 - 40.00
40.50 - 45.00
45.50 - 50.00
TOTAL
 |  | All numbers counted
 |  | Only X numbers should be counted
Spreadsheet: 723444d1615703697-conditional-formatting-and-color-cells-with-formula-testname-7
Sheet: projectlist

Project | Datum | Nr Vlist | [NAME] | Vertrek | Tijd | Aankomst
5154 | 2021-03-18 00:00:00 | 20404500 | 17NLD102 | Loheide | 22:00:00 | [NAME]
5155 | 2021-03-18 00:00:00 | 20401250 | 17nld105 | Loheide | 23:00:00 | [NAME]
5156 | 2021-03-20 00:00:00 | 20401354 | 17NLD109 | Loheide | 23:30:00 | [NAME]
5157 | 2021-03-19 00:00:00 | 20407589 | 17NLD208 | Loheide | 22:00:00 | [NAME]
Spreadsheet: 267129d1379961771-conditional-formatting-highlight-column-nth-case-of-a-letter-example1
Sheet: Sheet1

February | W | Th | F | Sa | Su | M | [NAME] | W | Th | F | Sa | Su | M | [NAME] | W | Th | F | Sa | Su | M | [NAME] | W | Th | F | Sa | Su | M | [NAME] | W | Th | F
Employee | 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
Alvin
[NAME]
Spreadsheet: 57691d1257906006-excel-2007-insert-shapes-based-on-values-symbols-using-fonts
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | space
 | Verdana | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | [ | ] | { | } | < | > | ? | \ |  | ! | @ | # | $ | % | ^ | & | * | ( | ) | _ | + |  | , | . | / | ` | ~
 | Webdings
 | Windings
 | Windings 2
 | Windings 3
 | Symbol
 | System
 | Impact
 | [NAME]
 | [NAME]
 | ptw_graph10.14
 | ptw_europe.8.6
 | [NAME]
 |  |  | 152 | 153 | 154 | 155 | 156 | 157 | 158 | 159 | 160 | 161
 |  |  |  | 
 | Verdana
 | Webdings
 | Windings
 | Windings 2
 | Windings 3
 | Symbol
 | System
 | Impact
 | [NAME]
 | ptw_graph10.14
 | ptw_europe.8.6
 | [NAME]
 | [NAME]
 |  |  |  |  |  |  | 100 | 150 | 200 | 250
Spreadsheet: 55177d1255345184-filter-by-only-first-4-numbers-copy-of-malchemist-1-
Sheet: 31576

Date of Order | Date of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20090403 | 2009-04-03 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 93.75 | 134360 | 31576
20090403 | 2009-04-03 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.5199999999999 | 134360 | 31576
20090403 | 2009-04-03 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 134360 | 31576
20090403 | 2009-04-03 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 134360 | 31576
Spreadsheet: 129549d1321668611-combining-results-like-darts-result
Sheet: Sheet1

Singles 501 Record |  |  |  |  |  |  | Record Against Individual Players
Date | Opponent | [NAME] | Legs Won | Legs Lost | [NAME] |  | Opponent | [NAME] | Legs Won | Legs Lost | [NAME]
14th November 2011 | A |  | 7 | 7 |  |  | A
14th November 2011 | B |  | 8 | 7 |  |  | B
14th November 2011 | C |  | 8 | 2 |  |  | C
16th November 2011 | D |  | 18 | 19 |  |  | D
18th November 2011 | B |  | 13 | 16
Spreadsheet: 842423d1694510784-formula-issues-when-data-input-in-certain-row-its-picking-up-another-formula-book1
Sheet: Inputs

IT scorecard input template |  |  |  |  |  |  |  |  |  | Current Quarter:
 | For the period | June 19, July 19, August 19 |  |  |  |  |  |  |  | (Do Not Delete)
Department | Contact name for metric | Metric name | Q1 | Q2 | Q3 | Q4 | Year to date | Full year target | Last year | Current Quarter Status | YTD Status | Input Required (Red) | Comments if status is not green |  |  |  | Current month status Text | Current Quarter  / YTD trend | YTD status Text
1. Execution and [NAME]
 |  | Test line | 20 |  |  |  | 70 | 85 | 81 |  | ⬤
 |  | Projects to baseline financial budget |  |  |  |  |  | >80% | 0.86 |  | ⬤
2. Service Excellence
 |  | Internal Customer Serice Survey (Annual) ** | 7.1 | 7.1 | 7.1 | 7.1 | 7.1 | 7.5 | 7.1 |  | ⬤ |  | Survey was completed in May 2019 with an improved result of 7.1.
 |  | Customer Experience (Net promotor score) | 100 |  |  |  | 90 | 85 | 81 |  | ⬤
 |  | First Call Resolution |  |  |  |  |  | 0.75 | 0.75 |  | ⬤
 |  | On boarding  ( Less Than 10 Days) |  |  |  |  |  | 0.9 | 0.88 |  | ⬤
 |  | Off boarding (Less Than10 Days) |  |  |  |  |  | 0.7 | 0.88 |  | ⬤