tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: ba31ab41-1d92-41e5-ac33-68f72a2870a4
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Third Party Entity Merch | 602537735099 | Various | Son Of God: Original Motion Picture Soundtrack | 2014-03-19 | Compact Disc | Soundtrack | 12.99 | Y | Available
Wea-Ada | 854727002386 | Various | Machine Gun Preacher Soundtrack | 2011-11-08 | Compact Disc | Soundtrack | 12.98 | Y | Available
Spreadsheet: 865086d1712158872-sum-based-on-two-conditions-data-equation-question
Sheet: Data

Material | Order | Quantity | Ship Date
F1000 | 1 | 50 | 2024-03-05 00:00:00
F1000 | 6 | 40 | 2023-12-08 00:00:00
F1000 | 4 | 90 | 2024-04-02 00:00:00
F2000 | 9 | 10 | 2024-03-28 00:00:00
F3000 | 8 | 20 | 2023-01-05 00:00:00
F5000 | 5 | 50 | 2024-02-05 00:00:00
 |  |  | Need to pull sum of quantity for certain Material (e.g. F1000) after certain date (e.g. 02/05/2024)
F1000 | 2024-02-05 00:00:00
Spreadsheet: 43994d1242661190-how-to-compare-dates-date-campare
Sheet: Sheet1

2009-02-15 00:00:00 | 2009-02-15 00:00:00 | Y
2009-02-25 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-05 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-15 00:00:00 | 2009-02-15 00:00:00 | Y
2009-02-25 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-05 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-15 00:00:00 | 2009-02-15 00:00:00 | Y
2009-02-25 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-05 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-15 00:00:00 | 2009-02-15 00:00:00 | Y
2009-02-25 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-05 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-15 00:00:00 | 2009-02-15 00:00:00 | Y
2009-02-25 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-05 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-15 00:00:00 | 2009-02-15 00:00:00 | Y
2009-02-25 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-05 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-15 00:00:00 | 2009-02-15 00:00:00 | Y
2009-02-25 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-05 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-15 00:00:00 | 2009-02-15 00:00:00 | Y
2009-02-25 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-05 00:00:00 | 2009-02-26 00:00:00 | N
2009-02-15 00:00:00 | 2009-02-15 00:00:00 | Y
2009-02-25 00:00:00 | 2009-02-26 00:00:00 | N
Spreadsheet: 879519d1727097055-better-formula-please-monthly-timesheet-rayman_blackz-sep-2024-365-aligw
Sheet: 2

 | Company Name |  |  |  |  |  |  | Helper Columns |  |  |  | Dayshift |  |  |  | 08:00 - 17:00 | 8
 | Monthly Time Sheet |  |  | 2024-09-11 00:00:00 |  |  |  | Saturday
 | Employee Name |  |  | N | Surname |  |  | Sunday |  |  |  | Rate per Hr |  |  |  | 47
 | Site Working |  |  | Site A |  |  |  |  |  |  |  | Allowance |  |  |  | 0
 | Date | Day | Shift |  | Hours |  |  |  |  | Comments |  | Hours worked and Night Shift Allowance
 |  |  | Day | Night | Start Time | End Time | Actual Hrs |  | OT |  |  | Normal Hrs | [NAME] | OverTime | [NAME] | PPH | Allowance
 | 2024-09-01 00:00:00 |  | False | False | 8:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 | 17:00:00
 | 2024-09-02 00:00:00 |  | False | False | 6:00:00 | 18:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 17:00:00
 | 2024-09-03 00:00:00 |  | False | False | 8:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 18:00:00
 | 2024-09-04 00:00:00 |  | False | False | 6:00:00 | 21:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00 | 16:00:00
PPH | 2024-09-05 00:00:00 |  | False | False | 7:00:00 | 17:00:00
 | 2024-09-06 00:00:00 |  | False | False
 | 2024-09-07 00:00:00 |  | False | False | 8:00:00 | 18:00:00
 | 2024-09-08 00:00:00 |  | False | False | 8:00:00 | 17:00:00
 | 2024-09-09 00:00:00 |  | False | False
 | 2024-09-10 00:00:00 |  | False | False
 | 2024-09-11 00:00:00 |  | False | False
 | 2024-09-12 00:00:00 |  | False | False
 | 2024-09-13 00:00:00 |  | False | False
 | 2024-09-14 00:00:00 |  | False | False
 | 2024-09-15 00:00:00 |  | False | False
 | 2024-09-16 00:00:00 |  | False | False
 | 2024-09-17 00:00:00 |  | False | False
 | 2024-09-18 00:00:00 |  | False | False
 | 2024-09-19 00:00:00 |  | False | False
 | 2024-09-20 00:00:00 |  | False | False
 | 2024-09-21 00:00:00 |  | False | False
 | 2024-09-22 00:00:00 |  | False | False
 | 2024-09-23 00:00:00 |  | False | False
 | 2024-09-24 00:00:00 |  | False | False | 8:00:00 | 17:00:00
 | 2024-09-25 00:00:00 |  | False | False
 | 2024-09-26 00:00:00 |  | False | False
 | 2024-09-27 00:00:00 |  | False | False
 | 2024-09-28 00:00:00 |  | False | False
 | 2024-09-29 00:00:00 |  | False | False
 | 2024-09-30 00:00:00 |  | False | False
 |  |  | False | False
 | Starting Date:
Spreadsheet: 160968d1339341588-separating-home-and-away-results-from-an-overall-set-of-results-copy-of-09_10_results_epl_edit
Sheet: Sheet2

 |  | <Select From Drop-down |  |  |  |  | [NAME]
Sort ID | Team | GF | GA | [NAME] | Tie-Break |  | Team | GF | GA | [NAME]
1 | Arsenal |  |  |  | #N/A
2 | [NAME] |  |  |  | #N/A
3 | Birmingham |  |  |  | #N/A
4 | [NAME] |  |  |  | #N/A
5 | [NAME] |  |  |  | #N/A
6 | Burnley |  |  |  | #N/A
7 | Chelsea |  |  |  | #N/A
8 | Everton |  |  |  | #N/A
9 | Fulham |  |  |  | #N/A
10 | Hull |  |  |  | #N/A
11 | Liverpool |  |  |  | #N/A
12 | Man City |  |  |  | #N/A
13 | Man United |  |  |  | #N/A
14 | Portsmouth |  |  |  | #N/A
15 | Stoke |  |  |  | #N/A
16 | Sunderland |  |  |  | #N/A
17 | Tottenham |  |  |  | #N/A
18 | West Ham |  |  |  | #N/A
19 | [NAME] |  |  |  | #N/A
20 | Wolves |  |  |  | #N/A
Spreadsheet: 166084d1341465485-replace-last-x-characters-in-cell-a-with-characters-in-cell-b-sample
Sheet: After

4043777 | 800 | 4043800 | SAMPLE-4043800
4043777 | 800 | 4043800 | SAMPLE-4043800
3351712 | 17 | 3351717 | SAMPLE-3351717
3351712 | 17 | 3351717 | SAMPLE-3351717
2737048 | 56 | 2737056 | SAMPLE-2737056
2737048 | 56 | 2737056 | SAMPLE-2737056
3341411 | 508 | 3341508 | SAMPLE-3341508
33341501 | 18 | 33341518 | [NAME]
4044444 | 50 | 4044450 | SAMPLE-4044450
3357814 | 0 | 3357810 | SAMPLE-3357810
4050421 | 8578 | 4058578 | SAMPLE-4058578
4354438 | 44 | 4354444 | SAMPLE-4354444
3344242 | 248 | 3344248 | [NAME]
3344242 | 248 | 3344248 | [NAME]
Spreadsheet: 163300d1340270985-searching-two-columns-for-one-word-sample
Sheet: Sheet1

Job Title | Job Description | Placements | GP
1 | .Net Developer | 6 | 78042.8386314
1.NET (C#) Developer | Developer | 1 | 10372.2581336
SAS Programmer | Programmer | 3 | 25000
Developer | SAS Developer | 2 | 15000
This is ideally how I'd like the information to return……..
Job Skill | Placements | GP
.Net | 7 | 88415
SAS | 5 | 40000
Spreadsheet: 847431d1698354474-how-to-update-a-worksheet-after-replacing-another-referenced-sheet-with-new-version-updatingworksheetsautomatically
Sheet: Analisis

 |  |  | From MyStock Sheet | From Client Demands |  |  | LOCK | LOCK | Our Historical |  |  |  | LOCK
 |  |  |  | This affects our turnover stock
 |  |  | TODAY | October | November | December | Quarterly | Projected |  |  |  |  | Projected Stock
 |  | Product code |  | Total Demand | Total Demand | Total Demand | Total Demand | Stock EOQ |  |  |  |  | + 3M Order
 |  | 123
 |  | 456
 |  | 789
 |  |  | 1. Analisis tab brings together all data from other worksheets
 |  |  | 2. [NAME] worksheet is updated on a monthly, sometimes weekly basis with the latest stock data for all 3 products as well as sales for the current month + next 2 months for a total of 3 months view
 |  |  | 3. ClientDemand worksheet is updated monthly or maybe weekly basis with their latest forecast consumption
 |  |  | 4. How can I make it so the Analysis worksheet reads from a newly imported MyStock & ClientDemand worksheets?
Spreadsheet: 838460d1691031316-calculate-conditional-standard-deviations-in-a-running-list-of-values-dstdev-example-v2-mark-m-
Sheet: Sheet1

 |  |  |  |  |  |  | Manual Calculations
Player | Country | Runs | Date | [NAME] | SD (Runs) |  | Player | Country | Runs | Date | [NAME] | SD (Runs)
[NAME] | AUS | 31 | 2009-01-03 00:00:00
[NAME] | AUS | 47 | 2009-01-03 00:00:00
[NAME] | AUS | 0 | 2009-01-03 00:00:00
[NAME] | AUS | 30 | 2009-01-03 00:00:00
[NAME] | AUS | 138 | 2009-01-03 00:00:00
[NAME] | SA | 23 | 2009-01-03 00:00:00
GC Smith | SA | 30 | 2009-01-03 00:00:00
HM Amla | SA | 51 | 2009-01-03 00:00:00
[NAME] | SA | 37 | 2009-01-03 00:00:00
AB de Villiers | SA | 11 | 2009-01-03 00:00:00
[NAME] | AUS | 56 | 2009-01-10 00:00:00
[NAME] | AUS | 22 | 2009-01-10 00:00:00
[NAME] | AUS | 3 | 2009-01-10 00:00:00
[NAME] | AUS | 46 | 2009-01-10 00:00:00
[NAME] | AUS | 24 | 2009-01-10 00:00:00
[NAME] | SA | 94 | 2009-01-10 00:00:00
GC Smith | SA | 65 | 2009-01-10 00:00:00
HM Amla | SA | 24 | 2009-01-10 00:00:00
[NAME] | SA | 32 | 2009-01-10 00:00:00
AB de Villiers | SA | 28 | 2009-01-10 00:00:00
[NAME] | AUS | 2 | 2009-01-17 00:00:00
[NAME] | AUS | 124 | 2009-01-17 00:00:00
[NAME] | AUS | 66 | 2009-01-17 00:00:00
[NAME] | AUS | 2 | 2009-01-17 00:00:00
[NAME] | AUS | 35 | 2009-01-17 00:00:00 |  |  |  |  |  |  |  |  |  | Examples of what the formula would filter:
[NAME] | SA | 6 | 2009-01-17 00:00:00
GC Smith | SA | 85 | 2009-01-17 00:00:00 |  |  |  |  |  |  |  |  |  | [NAME] | AUS | Runs
HM Amla | SA | 40 | 2009-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 31
[NAME] | SA | 30 | 2009-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 56
AB de Villiers | SA | 21 | 2009-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2
[NAME] | AUS | 17 | 2009-01-24 00:00:00 |  |  |  | [NAME] | AUS | 2 | 2009-01-17 00:00:00
[NAME] | AUS | 65 | 2009-01-24 00:00:00
[NAME] | AUS | 47 | 2009-01-24 00:00:00
[NAME] | AUS | 33 | 2009-01-24 00:00:00
[NAME] | AUS | 68 | 2009-01-24 00:00:00
[NAME] | SA | 123 | 2009-01-24 00:00:00 |  |  |  |  |  |  |  |  |  | [NAME] | AUS | Runs
GC Smith | SA | 4 | 2009-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 31
HM Amla | SA | 39 | 2009-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 56
[NAME] | SA | 95 | 2009-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2
AB de Villiers | SA | 14 | 2009-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 17
[NAME] | AUS | 156 | 2009-01-31 00:00:00 |  |  |  | [NAME] | AUS | 156 | 2009-01-31 00:00:00
Spreadsheet: 697095d1601167484-formulas-i-want-applied-between-certain-levels-with-some-dependencies-formulas-applied-between-certain-levels
Sheet: Blad1

 | AAA | 0.3 |  | 10 | 14 | 16 |  | Formula 1
 | BBB | 0.3 |  |  |  | 18 |  | Formula 2
 | AAA | 0.2 |  | 4 |  | 2 |  | Formula 3
 | AAA | 0.6 |  | 33 | 32 | 5 |  | Formula 4
 | BBB | 0.4 |  | 64 |  | 13 |  | Formula 5
 | AAA | 0.2 |  | 1 | 4 |  |  | Formula 6
 | AAA | 0 | Formula 1 |  | AAA | 0 | Formula 1
 | AAA | 0.1 | Formula 1 |  | AAA | 0.1 | Formula 1
 | AAA | 0.2 | Formula 1 |  | AAA | 0.2 | Formula 1
 | AAA | 0.3 | Formula 1 |  | BBB | 0.2 | Formula 2 |  | 1. The values in cells H1:H6 are depended on what is written in cells B1:B6.
 | BBB | 0.3 | Formula 2 |  | BBB | 0.3 | Formula 2
 | BBB | 0.4 | Formula 2 |  | BBB | 0.4 | Formula 2 |  | 2. I want the formula in cell H1 applied in cell D8:D11 and then formula in cell H2 applied on the cells D12:D15 and then formula in cell H3 applied on the cells D16:D18 and so on
 | BBB | 0.5 | Formula 2 |  | BBB | 0.5 | Formula 2
 | BBB | 0.6 | Formula 2 |  | BBB | 0.6 | Formula 2 |  | 3. Pay attention that the values in cells D1:D6 are applied on cells C8:C33. Whenever there is a border, the number is repeated one time (i have highlighted the repeated numbers in green)
 | AAA | 0.6 | Formula 3 |  | AAA | 0.6 | Formula 3
 | AAA | 0.7 | Formula 3 |  | AAA | 0.7 | Formula 3 |  | PAY ATTENTION THAT Everything in cell F8:H34 are just for another example if D1=0,2, D2=0,4, D3=0,2, [NAME], D5=0,4, D6=0,7
 | AAA | 0.8 | Formula 3 |  | AAA | 0.8 | Formula 3
 | AAA | 0.8 | Formula 4 |  | AAA | 0.8 | Formula 4
 | AAA | 0.9 | Formula 4 |  | AAA | 0.9 | Formula 4
 | AAA | 1 | Formula 4 |  | AAA | 1 | Formula 4
 | AAA | 1.1 | Formula 4 |  | BBB | 1 | Formula 5
 | AAA | 1.2 | Formula 4 |  | BBB | 1.1 | Formula 5
 | AAA | 1.3 | Formula 4 |  | BBB | 1.2 | Formula 5
 | AAA | 1.4 | Formula 4 |  | BBB | 1.3 | Formula 5
 | BBB | 1.4 | Formula 5 |  | BBB | 1.4 | Formula 5
 | BBB | 1.5 | Formula 5 |  | AAA | 1.4 | Formula 6
 | BBB | 1.6 | Formula 5 |  | AAA | 1.5 | Formula 6
 | BBB | 1.7 | Formula 5 |  | AAA | 1.6 | Formula 6
 | BBB | 1.8 | Formula 5 |  | AAA | 1.7 | Formula 6
 | AAA | 1.8 | Formula 6 |  | AAA | 1.8 | Formula 6
 | AAA | 1.9 | Formula 6 |  | AAA | 1.9 | Formula 6
 | AAA | 2 | Formula 6 |  | AAA | 2 | Formula 6
 |  |  |  |  | AAA | 2.1 | Formula 6
Spreadsheet: 131084d1322733543-sumifs-forum-excel
Sheet: Feuil1

 | Date | Montant
 | 2009-06-22 00:00:00
 | 2009-06-08 00:00:00
 | 2009-01-03 00:00:00
 | 2009-01-04 00:00:00
 | 2009-01-05 00:00:00
 | 2009-01-06 00:00:00
 | 2009-01-07 00:00:00
 | 2009-01-08 00:00:00
 | 2009-01-09 00:00:00
 | 2009-01-10 00:00:00
 | 2009-01-11 00:00:00
 | 2009-01-12 00:00:00
 | 2009-01-13 00:00:00
 | 2009-01-14 00:00:00
 | 2009-01-15 00:00:00
 | 2009-01-16 00:00:00
 | 2009-01-17 00:00:00
 | 2009-01-18 00:00:00
 | 2009-01-19 00:00:00
Spreadsheet: 586949d1534764476-return-multiple-rows-values-for-two-search-criteria-using-index-match-function-register-sample
Sheet: Summary

 | Company | No. of PDC's Given | No. of Active PDC's | PDC Amount |  | Supplier | Contractor | Depositor | Employee | Bank
1
2 |  |  |  | a
3
4
5
6
7
PDC's DUE THIS WEEK
 | TODAY | THIS WEEK NUMBER
 |  |  | Active
 | Cheque Date | Cheque Number | Bank | Company | Cheque Given to | Cheque Amount | Cheque Given For:
Spreadsheet: 133545d1324474903-excel-2007-combine-multiple-files-to-one-table-sumproduct-211211-
Sheet: 2010 total

Account | 2010-04-29 00:00:00 | 2010-05-17 00:00:00 | 2010-07-02 00:00:00 | 2010 total |  | Account | 2010-04-29 00:00:00 | 2010-05-17 00:00:00 | 2010-07-02 00:00:00 | 2010 total
0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  | 0
842 | 0 | 0 | 0 | 0 |  | 842 | 0 |  |  | 0
1065 | 0 | 0 | 0 | 0 |  | 1065 | 0 |  |  | 0
1066 | 1548 | 708 | 0 | 2256 |  | 1066 | 1548 |  |  | 1548
1105 | 0 | 0 | 0 | 0 |  | 1105 | 0 |  |  | 0
1163 | 1653 | 560 | 0 | 2213 |  | 1163 | 1653 |  |  | 1653
1340 | 0 | 0 | 0 | 0 |  | 1340 | 0 |  |  | 0
1646 | 0 | 0 | 0 | 0 |  | 1646 | 0 |  |  | 0
1667 | 2032 | 283 | 0 | 2315 |  | 1667 | 2032 |  |  | 2032
10493 | 0 | 0 | 0 | 0 |  | 10493 | 0 |  |  | 0
10555 | 210 | 0 | 0 | 210 |  | 10555 | 210 |  |  | 210
10571 | 0 | 0 | 0 | 0 |  | 10571 | 0 |  |  | 0
10716 | 0 | 0 | 0 | 0 |  | 10716 | 0 |  |  | 0
10952 | 0 | 0 | 0 | 0 |  | 10952 | 0 |  |  | 0
Spreadsheet: 675685d1588422725-forcing-time-to-round-to-single-decimal-flight-calculator-flight-log-example
Sheet: Sheet1

T/O date | 2020-05-05 00:00:00
T/O time | 19:03:00 |  | 19:03 to 04:23 is 9 hours and 20 mins. I need it to say 9.4 (19-24 mins = 0.4 from chart below), not 9.3.
Land date | 2020-05-06 00:00:00
Land time | 04:23:00
Flight time
 |  |  |  |  |  | Minutes | What I need it to equal
 |  |  |  |  |  | 1-6 | 0.1
 |  |  | What Excel calculates | Rounded x.x |  | 7-12 | 0.2
 |  | 1 min | 0.01666666666666661 |  |  | 13-18 | 0.3
 |  | 2 min | 0.03333333333333321 |  |  | 19-24 | 0.4
 |  | 3 min | 0.04999999999999982 |  |  | 25-30 | 0.5
 |  | 4 min | 0.06666666666666643 |  |  | 31-36 | 0.6
 |  | 5 min | 0.08333333333333304 |  |  | 37-42 | 0.7
 |  | 6 min | 0.09999999999999964 |  |  | 43-48 | 0.8
 |  |  |  |  |  | 49-54 | 0.9
 |  |  |  |  |  | 55-60 | 1
Spreadsheet: 58959d1259261178-use-drop-menu-to-control-data-sample-book
Sheet: Operations Manager Audit Trail

 |  |  |  |  |  | Month |  |  | January | February | March | April | May | June | July | August | September | October | November | December
 |  |  |  |  |  | Date
 |  |  |  |  |  | Initials
1 | Have the Team Manager and workplace audits been completed in the required timescales?
2 | Do any 'No's on from the Team Manager checklist, have identified actions for improvement on the 3Cs?
3 | Have the SDM workplace audits been completed in the required timescales?
4 | Do all the non compliances from the SDM checklists have identified actions for improvement with owners and target timescales?
5 | Have any KPI failures been investigated, addressed and corrective actions implemented?
6 | Is there evidence the Team Managers are effectively sharing resources across different aspects of the operation?
7 | Are all Comm Cell documents up to date?
8 | Have you been part of at least one comms cell briefing?
9 | Have you attended at least one problem solving session?
10 | Have you reviewed the SIP (Workstreams) with the SDMs and Team Managers and agreed future improvements with expected benefits?
11 | Have agreed actions within the Service Improvement Plan been completed in the required timescales including communication of achievements (including Fujitsu benefit and  customer value terms) to SDM and Stream Manager and Lean Programme (where appropriate
12 | Is there evidence of staff contributions to service improvement?
13 | Is there evidence that staff 1-2-1s are taking place on a monthly basis with agents having pdps, objectives and feedback against team and individual targets?
14 | Is there evidence of new processes or amendments being updated on the knowledge database/[NAME]?
15 | Is there evidence of standards being reviewed for accuracy and use?
16 | Have all proposed changes followed Best Practice for intro into Live Service?
17 | Have Service Desk achievements have been communicated to the customer and account team and included in the monthly service report?
18 | Have you recognised and rewarded team / individual(s) for outstanding performance?
19 | Have 'soundbites' and case studies been produced for all major achievements?
 | QUARTERLY CHECKS
20 | Have the current KPIs across the service been reviewed in line with the custome requirements?
Spreadsheet: 162149d1339747735-looking-up-data-and-providing-the-difference-plus-a-word-below-and-above-example
Sheet: Sheet1

 | target | achieved | difference |  | Range
Example | 4a | 5c | above (1) |  | 2A
Example | 4a | 4a | achieved |  | 3C
Example | 5b | 4c | below (4) |  | 3B
 |  |  |  |  | 3A
 |  |  |  |  | 4C
 |  |  |  |  | 4B
 |  |  |  |  | 4A
 |  |  |  |  | 5C
 |  |  |  |  | 5B
 |  |  |  |  | 5A
 |  |  |  |  | 6C
 |  |  |  |  | 6B
 |  |  |  |  | 6A
 |  |  |  |  | 7C
 |  |  |  |  | 7B
 |  |  |  |  | 7A
 |  |  |  |  | 8C
 |  |  |  |  | 8B
 |  |  |  |  | 8A
Spreadsheet: 102775d1300729254-data-copying-from-one-sheet-to-another-sheet-based-on-cell-value-processtemplate_sample
Sheet: Data Input Sheet

Organization: |  |  |  | Department / Function
Process Name:
Process description:
Desired outcome: |  |  |  | KPI's
Sl. Number | Activity |  | Actor | Pain points | Dependencies
1 | Activity 1, 2,3 |  | Actor 1
 | Activity 2 |  | System
 | Activity 3 |  | Actor2
 | Activity 4 |  | Actor 1
 | Activity 5 |  | Actor 1
 | Activity 6 |  | System
 | Activity 7 |  | Actor 3
 | Activity 8 |  | Actor 4
 | Activity 9 |  | System
 | Activity 10
 | Activity 11
12 | Activity 12
Pain Point Rationalization (3-6 major pain points)
High | >65%
Medium
Low
Spreadsheet: 691977d1597990108-round-up-to-the-nearest-0-5-percentage-value-examplehelp
Sheet: Sheet1

Value | Expected Rounding Result
0.995 | 0.995
0.994 | 0.995
0.993 | 0.995
0.992 | 0.995
0.991 | 0.995
0.99 | 0.995
0.989 | 0.995
 | 0.995
 | 0.995
 | 0.995
 | 0.985
 | 0.985
 | 0.985
 | 0.985
 | 0.985
 | 0.985
 | 0.985
 | 0.985
 | 0.985
 | 0.985
 | 0.975
 | 0.975
 | 0.975
 | 0.975
 | 0.975
 | 0.975
 | 0.975
 | 0.975
 | 0.975
 | 0.975
Spreadsheet: 769178d1645370340-extract-specific-characters-from-a-cell-based-on-criteria-lookup-max-workbookexample-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Event | Start
 |  |  | Event | Expected Answer | Automatic Answer |  |  |  |  |  |  |  |  | FP1 | 2022-02-01 00:00:00
 |  |  | FP5 - Bananas & Apples;FP3 - Bananas & Apples;FP4 - Bananas & Apples | FP5 |  | <-- Please insert automatic formula here |  |  |  |  |  |  |  | FP2
 |  |  | FP5 - Bananas & Apples;FP6 - Bananas & Apples | FP6 |  |  |  |  |  |  |  |  |  | FP3
 |  |  | FP6 - Orange & Pear;FP5 - Orange & Pear | FP6 |  |  |  |  |  |  |  |  |  | FP4
 |  |  | FP10 - [NAME] | FP11 |  |  |  |  |  |  |  |  |  | FP5
 |  |  | VS3- Bananas & Apples;VS2 - Bananas & Apples;VS4 - Bananas & Apples | VS4 |  |  |  |  |  |  |  |  |  | FP6
 |  |  | FP8 - Orange & Pear | FP8 |  |  |  |  |  |  |  |  |  | FP7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP11
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP12
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FP15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS11
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS12
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VS15
Spreadsheet: darrell_schoolcraft__7809__imbalsumm0108
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 837969 | 866891
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 797231 | 778531 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 1087473 | 1136200
500293 | 364041 | 505957
500302 |  | 9400
500303 | 220958 | 278806
500305 | 854605 | 1109622
500307 | 91997 | 100368
500313 |  | 2621
500314
500655 | 563490
500657 | 124714 | 137449
INDEX
2001-07-31 00:00:00 |  |  | -131785.95
2001-08-25 00:00:00
CBS Volume
 |  |  | -81746
Spreadsheet: 872521d1718889054-help-with-complex-formula-sor-template
Sheet: Breakdown of Costs

Works | W (mm) | H ([NAME]) | Area (m2) | Qty | SOR code | Unit | SOR Description | Unit Price | Total Cost (£)
Fire Stopping | 100 | 900 |  | 1 |  | ITEM | seal floor or wall (one face) Opening up to 0.1m2 | 10
Fire Stopping | 250 | 750 |  | 2 | Rate 2 | ITEM | seal floor or wall (one face) Opening up to 0.2m2 | 20
Fire Stopping | 500 | 600 |  | 3 | Rate 3 | ITEM | seal floor or wall (one face) Opening up to 0.4m2 | 100
Fire Stopping | 500 | 900 |  | 1 | Rate 4 | ITEM | seal floor or wall (one face) Opening up to 0.6m2 | 200
Fire Stopping | 700 | 1000 |  | 2 | Rate 5 | ITEM | seal floor or wall (one face) Opening up to 0.8m2 | 250
Fire Stopping | 1000 | 900 |  | 5 | Rate 6 | ITEM | seal floor or wall (one face) Opening up to 0.9m2 | 290
Fire Stopping | 1000 | 1000 |  | 10 | Fixed Rate |  |  | 325
Spreadsheet: 795620d1662804517-i-need-to-get-the-number-of-instances-in-a-row-with-the-same-column-heading-excel-help
Sheet: Sheet1

 |  | Check on instances of result |  |  |  |  |  |  |  | September |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | July
Flight Number | Total Charges | Service Fee | Ground Transportation | Passenger Fees | Fuel surcharge | Internet | [NAME] | High Density Airport Fee | Landing & Handling | Service Fee | Ground Transportation | Passenger Fees | Fuel surcharge | Internet | [NAME] | High Density Airport Fee | Landing & Handling | Service Fee | Ground Transportation | Passenger Fees | Fuel surcharge | Internet | [NAME] | High Density Airport Fee | Landing & Handling | Service Fee | Ground Transportation | Passenger Fees | Fuel surcharge | Internet | [NAME] | High Density Airport Fee | Landing & Handling
1 |  | 2 |  |  |  |  |  |  |  | 800 |  |  |  |  |  |  |  | 800 |  |  |  |  |  |  |  |  |  |  | 100
2 |  |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  | 100
3 |  |  |  |  |  |  |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  | 5220
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 800 |  |  |  |  |  |  |  | 800 |  |  |  |  |  |  |  | 1000
5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000
6 |  |  |  |  |  |  |  |  |  | 100 |  | 500 |  |  | 555500 |  |  |  |  | 500 |  |  | 555220 |  |  | 15236 |  |  |  |  | 1000