tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 875064d1721635642-making-list-with-variable-length-detailed-example-set
Sheet: Sheet1

This column contains Code AND Device name and looks like this: First goes Code, then device name which is text | This column gets removed and combined in A column | This Columns contains varaible data.Lenght is always known | In here I need to combine values specifially like this. List places cannot be swapped, because then it is imposible to make a copy to other software.
Code |  | Properties(Alarms) | Combined info
[NAME]: Padėtis |  | Nėra maitinimo
HLA30AA251 Antrinio oro ventiliatoriaus dažnio keitiklis |  | [NAME]
HLA40AA251 Temperatūra |  | Nepasileidžia
 |  | Saugos raktas
 |  | Neišsijungia
 |  | Suveikusi sauga
 |  |  | [NAME]: Padėtis Nesisuka
 |  |  | [NAME]: [NAME]
 |  |  | [NAME]: Padėtis Saugos raktas
 |  |  | [NAME]: Padėtis Neišsijungia
 |  |  | [NAME]: [NAME] sauga
 |  |  | HLA30AA251 Antrinio oro ventiliatoriaus dažnio [NAME] maitinimo
 |  |  | HLA30AA251 Antrinio oro ventiliatoriaus dažnio [NAME]
 |  |  | HLA30AA251 Antrinio oro ventiliatoriaus dažnio keitiklis Nepasileidžia
 |  |  | HLA30AA251 Antrinio oro ventiliatoriaus dažnio [NAME] raktas
 |  |  | HLA30AA251 Antrinio oro ventiliatoriaus dažnio [NAME]
 |  |  | HLA30AA251 Antrinio oro ventiliatoriaus dažnio [NAME] sauga
 |  |  | HLA40AA251 Temperatūra Nėra maitinimo
 |  |  | HLA40AA251 Temperatūra Nesisuka
 |  |  | HLA40AA251 [NAME]
 |  |  | HLA40AA251 [NAME] raktas
 |  |  | HLA40AA251 Temperatūra Neišsijungia
 |  |  | HLA40AA251 [NAME] sauga
Spreadsheet: 835370d1688543867-count-cell-with-different-date-and-year-exist-count-cell-with-different-date-and-year-exist-aligw
Sheet: Sheet1

Received Date |  |  | this is the data
 |  |  |  | RESULT I WANT |  | AliGW
2022-01-03 00:00:00 |  |  |  | 2022-01-31 00:00:00 | 6 |  | SUMPRODUCT(--1/COUNTIF(A3:A24;A3:A24))
2022-01-03 00:00:00 |  |  |  |  | 4 |  | EOMONTH
2022-01-05 00:00:00 |  |  |  |  | 2
2022-01-05 00:00:00 |  |  |  |  | 5 |  | Your value is incorrect!
2022-01-20 00:00:00 |  |  |  |  | 4
2022-01-20 00:00:00 |  |  |  | 2023-01-31 00:00:00 | 6
2022-02-01 00:00:00 |  |  |  |  | 4
2022-02-01 00:00:00 |  |  |  |  | 2
2022-02-15 00:00:00 |  |  |  |  | 5 |  | Your value is incorrect!
2022-02-20 00:00:00 |  |  |  |  | 4
2022-03-04 00:00:00
2022-03-05 00:00:00
2022-04-04 00:00:00
2022-04-05 00:00:00
2022-04-06 00:00:00
2022-04-07 00:00:00
2022-05-05 00:00:00
2022-05-06 00:00:00
2022-05-07 00:00:00
2022-05-08 00:00:00
2023-01-03 00:00:00
2023-01-03 00:00:00
2023-01-05 00:00:00
2023-01-05 00:00:00
2023-01-20 00:00:00
2023-01-20 00:00:00
2023-02-01 00:00:00
2023-02-01 00:00:00
2023-02-15 00:00:00
2023-02-20 00:00:00
2023-03-04 00:00:00
2023-03-05 00:00:00
2023-04-04 00:00:00
2023-04-05 00:00:00
2023-04-06 00:00:00
2023-04-07 00:00:00
2023-05-05 00:00:00
2023-05-06 00:00:00
2023-05-07 00:00:00
2023-05-08 00:00:00
Spreadsheet: 821064d1678424609-need-a-formula-to-count-down-hours-worked-vs-next-pay-increase-on-excel-timesheet-beamer2
Sheet: Feb 16-29

[NAME]
 |  | 330 | STS-Thomas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Period 5
 |  |  |  |  |  |  |  |  |  |  |  |  | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step | Running Total | February 16 - 29
 |  |  |  |  |  |  |  |  |  |  |  | Next Step | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800
 |  |  |  |  |  |  |  |  |  |  |  | Hours Remaining |  |  |  |  |  |  |  |  |  | 2023
 |  |  |  | REG | COMP USED | SICK | VAC | HOL USED | WORK HOL | WORK HOL OT | OT | Built in OT |  | EARN COMP | OTHER |  | OT Premium | COACH | TRAINER | COACH OT | TRAINER OT
 | JAB | Thur | 16 | 12
 | sns | Fri |  | 10 |  |  |  |  |  |  |  | 2
 | JAB | Sat |  | Off
 | JAB | Sat | 18 | Off
 | JAB | Sun | 19 | Off
 | JAB | Mon | 20 | Holiday |  |  |  |  |  | 6
 | JAB | Tue |  | Off |  |  |  |  |  |  | 14
 | JAB | Wed |  | 12
 | JAB | Thur |  | 12
 | JAB | Fri |  | 12
 | JAB | Sat |  | 4 |  |  |  |  |  |  |  | 2
 | JAB | Sat | 25 | 6
 | DLE | Sun | 26 | Off
 | DLE | Mon | 27 | Off |  |  |  |  |  |  | 12
 | DLE | Tue |  | Off |  |  |  |  |  |  | 12
 |  | Tue
 |  | TOTALS
 |  |  |  | REG | COMP USED | SICK | VAC | HOL USED | WORK HOL | WORK HOL OT | OT | Built in OT |  | EARN COMP | OTHER | DAILY TOTAL | OT Premium | COACH | TRAINER | COACH OT | TRAINER OT
 |  |  | reg hours forward |  |  |  |  |  |  |  |  |  |  |  |  |  | 50% | 3% | 9%
 |  |  | available leave
 |  |  | I certify that the foregoing payroll is just, true and correct; that the person whose name appears [NAME]
 |  |  | actually worked or was on authorized leave as shown; and that the salaries are due and unpaid.
 |  | EMPLOYEE SIGNATURE |  |  |  |  |  |  |  |  | DATE |  |  |  |  | AUTHORIZING SIGNATURE |  |  |  |  |  | DATE
Spreadsheet: 37950d1236070627-data-validation-problem-cricket
Sheet: TEAM STATS

 |  | TEAM STATISTICS
 |  | For |  |  | Against
 |  | Total Runs | 0 |  | Total Runs | 0
 |  | Highest Total | 0 |  | Highest Total | 0
 |  | Lowest Total | 0 |  | Lowest Total | 0
 |  | Average Run Rate | #N/A |  | Average Run Rate | #N/A
 |  | Highest run rate | 0 |  | Highest run rate | 0
 |  | Lowest run rate | 0 |  | Lowest run rate | 0
 |  | Runs Scored per Wicket | #N/A |  | Runs Conceeded per Wicket | #N/A
 |  | Total Wickets Taken | 0 |  | Total Wickets Lost | 0
 |  | Runs scored in 4's | 0 |  | Runs Conceeded in 4's | #N/A
 |  | Runs scored in 6's | 0 |  | Runs Conceeded in 6's | #N/A
 |  | % Runs Scored in Boundaries | #N/A |  | % Runs Conceeded in Boundaries | #N/A
 |  | Total Extras Gained | 0 |  | Total Extras Conceeded | 0
 |  | Most [NAME] | 0 |  | Most Extras Conceeded | 0
 |  | Least Extras Gained | 0 |  | Least Extras Conceeded | 0
 |  | % Runs Scored in Extras | #N/A |  | % Runs Conceeded in Extras | #N/A
 |  | Coin Tosses Won | 0 |  | Coin Tosses Lost | 0
 |  | [NAME] | #N/A |  | [NAME] | #N/A
 |  | [NAME] | #N/A |  | [NAME] | #N/A
 |  | [NAME] | #N/A |  | [NAME] | #N/A
 |  | [NAME] | #N/A |  | [NAME] | #N/A
Spreadsheet: 676418d1588795193-help-on-a-formula-that-shows-a-score-based-on-achievement-problem_01
Sheet: Sheet1

Achievement | Score
0.01 | 1 |  | If I would like to show the following;
0.02 | 0.99 |  | Achievement: | 0.01 | Score: | 1
0.03 | 0.98
0.04 | 0.97 |  | What would be the correct formula in score?:
0.05 | 0.96 |  | Achievement: | 0.01 | Score: | ?
0.06 | 0.95
0.07 | 0.94
0.08 | 0.93
0.09 | 0.92
0.1 | 0.91
0.11 | 0.9
0.12 | 0.89
0.13 | 0.88
0.14 | 0.87
0.15 | 0.86
0.16 | 0.85
0.17 | 0.84
0.18 | 0.83
0.19 | 0.82
0.2 | 0.81
0.21 | 0.8
0.22 | 0.79
0.23 | 0.78
0.24 | 0.77
0.25 | 0.76
0.26 | 0.75
0.27 | 0.74
0.28 | 0.73
0.29 | 0.72
0.3 | 0.71
0.31 | 0.7
0.32 | 0.69
0.33 | 0.68
0.34 | 0.67
0.35 | 0.66
0.36 | 0.65
0.37 | 0.64
0.38 | 0.63
0.39 | 0.62
0.4 | 0.61
0.41 | 0.6
0.42 | 0.59
0.43 | 0.58
0.44 | 0.57
0.45 | 0.56
0.46 | 0.55
0.47 | 0.54
0.48 | 0.53
0.49 | 0.52
0.5 | 0.51
0.51 | 0.5
0.52 | 0.49
0.53 | 0.48
0.54 | 0.47
0.55 | 0.46
0.56 | 0.45
0.57 | 0.44
0.58 | 0.43
0.59 | 0.42
0.6 | 0.41
0.61 | 0.4
0.62 | 0.39
0.63 | 0.38
0.64 | 0.37
0.65 | 0.36
0.66 | 0.35
0.67 | 0.34
0.68 | 0.33
0.69 | 0.32
0.7 | 0.31
0.71 | 0.3
0.72 | 0.29
0.73 | 0.28
0.74 | 0.27
0.75 | 0.26
0.76 | 0.25
0.77 | 0.24
0.78 | 0.23
0.79 | 0.22
0.8 | 0.21
0.81 | 0.2
0.82 | 0.19
0.83 | 0.18
0.84 | 0.17
0.85 | 0.16
0.86 | 0.15
0.87 | 0.14
0.88 | 0.13
0.89 | 0.12
0.9 | 0.11
0.91 | 0.1
0.92 | 0.09
0.93 | 0.08
0.94 | 0.07
0.95 | 0.06
0.96 | 0.05
0.97 | 0.04
0.98 | 0.03
0.99 | 0.02
1 | 0.01
Spreadsheet: 265640d1379350952-convert-degrees-to-degrees-and-minutes-example
Sheet: Sheet1

 | Date | Time |  |  |  | Angle
 | 2013-09-11 00:00:00 | 08:38:38 |  |  |  | 41 | 45.4
 |  | 08:39:52 |  |  |  | 41 | 50.8
 |  | 08:41:02 |  |  |  | 42 | 0.2
 |  | 08:42:40 |  |  |  | 42 | 16.4
Ave
Date |  |  |  | H(Eye) | 2.5 | Dip | -2.8
EP | S 33 06.05 | E 017 51.01
Time
[NAME] |  |  |  |  | Dec | N | 4 | 26.9
Index Error | 0 | 0 |  |  | (d) - Decr | 0.9 | 0 | -0.6
Observed Angle |  |  |  |  | Dec Tot
Dip | 0
[NAME]
[NAME] |  | 15
Height(Observed)
GHA | 300 | 50.9
GHA Increment | 10 | 8.2 |  |  | EP Long |  | 17 | 51.01
GHA Tot
E=+ |  | 0.9
LHA
Calc Position | S33 | E018 00.9
Spreadsheet: 870238d1716794850-project-resource-planner-lookup-and-count-sum-formulas-project-resource-plan-aligw
Sheet: Summary

 |  |  | 2024-01-23 00:00:00 | 2024-02-23 00:00:00 | 2024-03-23 00:00:00 | 2024-04-23 00:00:00 | 2024-05-23 00:00:00 | 2024-06-23 00:00:00 | 2024-07-23 00:00:00 | 2024-08-23 00:00:00 | 2024-09-23 00:00:00 | 2024-10-23 00:00:00 | 2024-11-23 00:00:00 | 2024-12-23 00:00:00
 |  | Project A
 |  | Project B
 |  | Project C
 |  | Project D
 |  | Project E
 |  | Project F
 |  | Project G
 |  | Project H
 |  | Project A
 |  | Project B
 |  | Project C
 |  | Project D
 |  | Project E
 |  | Project F
 |  | Project G
 |  | Project H
Spreadsheet: 840429d1692723404-is-this-possible-need-help-with-a-formula-to-highlight-matching-values-separated-by-comma-book1updated
Sheet: Sheet1

100-3651, | If any value in a single matches a value in another cell, they need to be grouped togther and highlighted, or any other way to identify a common value | 100-3651,
100-3651, |  | 100-3651,
100-3651, |  | 100-3651,
100-3700, |  | 100-3700,
100-3700,167-0982 |  | 100-3700,167-0982
100-3809, |  | 100-3809,
100-5927, |  | 100-5927,
1009401, |  | 1009401,
1010953,AT131565 |  | 1010953,AT131565
1010953,AT131565 |  | 1010953,AT131565
1010956,4S00540, AT131565 |  | 1010956,4S00540, AT131565
1010956,AT131565 |  | 1010956,AT131565
1010956,AT131565 |  | 1010956,AT131565
1011219, |  | 1011219,
1011396, |  | 1011396,
1012495, |  | 1012495,
1012495,AT200345 |  | 1012495,AT200345
1013941, |  | 1013941,
1013941,9111266 |  | 1013941,9111266
1013942,1017262, 2027494 |  | 1013942,1017262, 2027494
1014036, |  | 1014036,
1014036, |  | 1014036,
1014036, |  | 1014036,
1014036, |  | 1014036,
1014036, |  | 1014036,
1014036, 555655 |  | 1014036, 555655
1014036, |  | 1014036,
Spreadsheet: 197931d1354618663-find-average-of-column-b-based-on-boundaries-applied-to-column-a-example
Sheet: Sheet1

T | B |  |  | Average1 | Average2 | Average3
0.2 | 0.1 |  |  | 0≤x<1 | 1.5≤X<2 | 2≤X<2.5
0.3 | 0.2
0.5 | 0.1
0.6 | 0.1
0.7 | 5
0.8 | 42
0.9 | 354 |  |  |  |  | I want to find the average value in the second column based on a set of boundaries applied to the first column
1 | 354 |  |  |  |  | I have a huge quantity of data, so I want to easily input the boundaries and then find the applicable average
1.1 | 354
1.2 | 354
1.3 | 32
1.4 | 0
1.5 | 657
1.6 | 57
1.7 | 324
1.8 | 324
1.9 | 0
2 | 78
2.1 | 9
2.2 | 4
2.3 | 3
2.4 | 12
Spreadsheet: 671260d1586331961-update-defining-exact-length-of-string-for-istext-within-aggregate-function-00-wages-template-for-tests
Sheet: 01 MONDAY

DAY: |  | MONDAY |  | DATE: | 2020-03-23 00:00:00
No. |  | NAME |  |  |  | FROM | TO | Wh | VL | SL | OT | F/L | Hr | F/L | Hr | F/L | Hr | JOBS | Hr | JOBS | Hr | GR/WS | Hr | CHECK |  | JOBS BREAKDOWN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
12 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | [NAME] |  |  | GROUPAGE
11 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | DRIVERS |  |  | DRIVERS
14 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | PART TIMERS |  |  | PART TIMERS
33 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | WELDERS |  |  | WELDERS
37 | W
27 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS
53 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
54 | W
50 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
30 | P
31 | P
32 | P
51 | P
52 | P
55 | P
15 | P
23 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPAIRS MT
26 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
6 | D | EXMPLOYEE |  |  |  | 07:00:00 | 17:00:00 |  |  |  |  | 19900 | 7 |  |  |  |  |  |  | 1234 | 8
10 | D
47 | D
[NAME] |  |  |  |  | GROUPAGE |  |  | IDLE TIME |  |  |  |  | JOBS |  |  |  | REPAIRS MT |  |  |  | WORKSHOP WS
JOBS |  |  | HR |  | JOBS | HR |  | JOBS |  |  | HR |  | JOBS |  | HR |  | JOBS |  | HR |  | JOBS |  | HR
TOTAL |  |  |  |  | TOTAL |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 |  |  |  |  | Hours Calculator |  |  |  |  |  |  |  |  |  |  | TOTAL 2 |  |  |  |  | TOTAL 1
Spreadsheet: 875214d1721797846-sum-column-data-in-arrays-from-multiple-sheets-test-1-2-3-4-5-6-7-
Sheet: 6

151-26 | 150-66 | 150-74 | 153-11 | 150-19 | 153-14 | 152-16 | 153-20 | 153-19 | 152-14 | 153-18 | 153-23
281 | 325 | 642 | 190 | 204 | 263 | 852 | 137 | 19 | 542 | 732 | 97
25 | 513 | 638 | 596 | 652 | 173 | 426 | 506 | 811 | 584 | 627 | 136
787 | 334 | 699 | 806 | 852 | 707 | 213 | 198 | 687 | 728 | 9 | 529
636 | 476 | 799 | 351 | 488 | 10 | 109 | 393 | 182 | 93 | 811 | 46
270 | 399 | 965 | 378 | 945 | 498 | 753 | 995 | 821 | 551 | 465 | 495
221 | 365 | 2 | 516 | 241 | 233 | 97 | 419 | 781 | 986 | 216 | 482
345 | 589 | 873 | 565 | 707 | 32 | 934 | 90 | 995 | 854 | 814 | 133
184 | 836 | 25 | 997 | 572 | 570 | 395 | 69 | 251 | 677 | 518 | 476
569 | 526 | 732 | 103 | 865 | 720 | 547 | 781 | 295 | 335 | 243 | 191
92 | 503 | 864 | 712 | 254 | 514 | 325 | 312 | 666 | 91 | 976 | 291
464 | 391 | 10 | 590 | 307 | 448 | 805 | 490 | 477 | 253 | 78 | 460
669 | 534 | 965 | 812 | 852 | 148 | 783 | 290 | 230 | 204 | 8 | 74
509 | 822 | 616 | 500 | 266 | 811 | 37 | 687 | 1 | 704 | 285 | 921
954 | 819 | 979 | 905 | 198 | 796 | 893 | 135 | 925 | 333 | 61 | 289
906 | 241 | 136 | 406 | 473 | 257 | 17 | 9 | 40 | 919 | 867 | 977
Spreadsheet: 672921d1587068248-formula-to-give-schedule-visibility-receipt-schedule-database
Sheet: Event Scheduler

 | [NAME]
 |  |  |  | Receipt Date | TIME | Customer | Truck Type | Contact | UNIQUE VALUE (CALCULATED)
 |  |  |  | 2020-04-15 00:00:00 | 07:00:00 | Customer A | 54'
 |  |  |  | 2020-04-15 00:00:00 | 08:00:00 | Customer B | 54'
 |  |  |  | 2020-04-15 00:00:00 | 09:00:00 | Customer C | 54'
 |  |  |  | 2020-04-16 00:00:00 | 08:00:00 | Customer D | Flat-Bed
 |  |  |  | 2020-04-15 00:00:00 | 10:00:00 | Customer A | Pickup
 |  |  |  | 2020-04-15 00:00:00 | 12:00:00 | Customer H | Pickup
 |  |  |  | 2020-04-17 00:00:00 | 13:00:00 | Customer Z | Pickup
 | Select to edit time intervals |  |  | 2020-04-16 00:00:00 | 13:30:00 | Customer X | 54
 |  |  |  | 2020-04-20 00:00:00 | 08:00:00 | Customer XXX | Pickup
 | Select to view Daily Schedule |  |  | 2020-04-20 00:00:00 | 09:00:00 | Customer YYY | 54
 |  |  |  | 2020-04-20 00:00:00 | 10:00:00 | Customer ZZZ | 54
 |  |  |  | 2020-04-20 00:00:00 | 13:00:00 | Customer BBB | Pickup
 |  |  |  | 2020-04-20 00:00:00 | 14:00:00 | [NAME] | Pickup
 |  |  |  | 2020-04-20 00:00:00 | 11:00:00 | Customer B | Pickup
 |  |  |  | 2020-04-21 00:00:00 | 08:00:00 | Customer 123 | 54
 |  |  |  | 2020-04-21 00:00:00 | 09:00:00 | Customer 234 | 54
 |  |  |  | 2020-04-15 00:00:00 | 15:00:00 | Customer last minute | Pickup
 |  |  |  | 2020-04-21 00:00:00 | 11:00:00 | Customer BBBB | 54
Spreadsheet: 821263d1678559055-interpolating-data-using-forecast-function-c172-takeoff
Sheet: Sheet1

 | TEMP  (°C) | PRESSURE ALTITUDE (DRY RUNWAY) - C172S
 |  | 0 |  |  | 1000 |  |  | 2000 |  |  | 3000 |  |  | 4000
 |  | MTOW | GND ROLL | 50 FT OBST | MTOW | GND ROLL | 50 FT OBST | MTOW | GND ROLL | 50 FT OBST | MTOW | GND ROLL | 50 FT OBST | MTOW | GND ROLL | 50 FT OBST
 | 0 | 2550 | 860 | 1465 | 2550 | 940 | 1600 | 2550 | 1025 | 1755 | 2550 | 1125 | 1925 | 2550 | 1235 | 2120
 | 10 | 2550 | 925 | 1575 | 2550 | 1010 | 1720 | 2550 | 1110 | 1890 | 2550 | 1215 | 2080 | 2550 | 1335 | 2295
 | 20 | 2550 | 995 | 1690 | 2550 | 1090 | 1850 | 2550 | 1195 | 2035 | 2550 | 1310 | 2240 | 2550 | 1440 | 2480
 | 30 | 2550 | 1070 | 1810 | 2550 | 1170 | 1990 | 2550 | 1285 | 2190 | 2550 | 1410 | 2420 | 2550 | 1550 | 2685
 | 40 | 2550 | 1150 | 1945 | 2550 | 1260 | 2135 | 2550 | 1380 | 2355 | 2550 | 1515 | 2605 | 2550 | 1660 | 2880
 | 0 | 2400 | 745 | 1275 | 2400 | 810 | 1390 | 2400 | 885 | 1520 | 2400 | 970 | 1665 | 2400 | 1065 | 1830
 | 10 | 2400 | 800 | 1370 | 2400 | 875 | 1495 | 2400 | 955 | 1635 | 2400 | 1050 | 1795 | 2400 | 1150 | 1975
 | 20 | 2400 | 860 | 1470 | 2400 | 940 | 1605 | 2400 | 1030 | 1760 | 2400 | 1130 | 1930 | 2400 | 1240 | 2130
 | 30 | 2400 | 925 | 1570 | 2400 | 1010 | 1720 | 2400 | 1110 | 1890 | 2400 | 1215 | 2080 | 2400 | 1335 | 2295
 | 40 | 2400 | 995 | 1685 | 2400 | 1085 | 1845 | 2400 | 1190 | 2030 | 2400 | 1305 | 2230 | 2400 | 1430 | 2455
 | 0 | 2200 | 610 | 1055 | 2200 | 665 | 1145 | 2200 | 725 | 1250 | 2200 | 795 | 1365 | 2200 | 870 | 1490
 | 10 | 2200 | 655 | 1130 | 2200 | 720 | 1230 | 2200 | 785 | 1340 | 2200 | 860 | 1465 | 2200 | 940 | 1605
 | 20 | 2200 | 705 | 1205 | 2200 | 770 | 1315 | 2200 | 845 | 1435 | 2200 | 925 | 1570 | 2200 | 1010 | 1725
 | 30 | 2200 | 760 | 1290 | 2200 | 830 | 1410 | 2200 | 905 | 1540 | 2200 | 995 | 1685 | 2200 | 1090 | 1855
 | 40 | 2200 | 815 | 1380 | 2200 | 890 | 1505 | 2200 | 975 | 1650 | 2200 | 1065 | 1805 | 2200 | 1165 | 1975
 |  |  |  | [NAME] |  |  |  | Final Result for Temp 15°C at 500 ft elev with takeoff weight 2300 lb
 |  |  |  | Elevation |  | 500
 |  |  |  | Temp |  | 15 |  |  | GNDL ROLL | 50 FT OBST
 |  |  |  | takeoff weight |  | 2300 |  |  | 791 | 1353
Spreadsheet: 837882d1690475615-my-excel-file-is-heavy-for-use-journal-2023-07-27
Sheet: Sheet1

2023-06-24 00:00:00 | 41 |  |  |  |  |  |  | EURUSD |  | 2
2023-06-25 00:00:00 | 58 |  |  |  |  |  |  | [NAME] |  | 2
2023-06-26 00:00:00 | 76 |  |  | 76 | 15 |  |  | AUDUSD |  | 2
2023-06-27 00:00:00 | 97 |  |  |  | 15 |  |  | USDJPY |  | 2
2023-06-28 00:00:00 | 116 |  |  |  | 15 |  |  | WTI |  | 2
2023-06-29 00:00:00 | 128 |  |  |  | 15 |  |  | NZDUSD |  | 2.5
2023-06-30 00:00:00 | 150 |  |  |  | 15 |  |  | USDCHF |  | 2.5
2023-07-01 00:00:00 | 170 |  |  |  | 15 |  |  | USDCAD |  | 2.5
2023-07-02 00:00:00 | 190 |  |  |  | 15 |  |  | EURJPY |  | 3
2023-07-03 00:00:00 | 212 |  |  |  | 15 |  |  | XAUUSD |  | 5
2023-07-04 00:00:00 | 229 |  |  |  | 15
2023-07-05 00:00:00 | 250 |  |  |  | 15
2023-07-06 00:00:00 | 285 |  |  |  | 15
2023-07-07 00:00:00 | 300 |  |  |  | 15
2023-07-08 00:00:00 | 316 |  |  |  | 15
2023-07-09 00:00:00 | 331 |  |  |  | 15
2023-07-10 00:00:00 | 347 |  |  |  | 15
2023-07-11 00:00:00 | 357 |  |  |  | 15
2023-07-12 00:00:00 |  |  |  |  | 15
2023-07-13 00:00:00 |  |  |  |  | 15
2023-07-14 00:00:00 |  |  |  |  | 15
2023-07-15 00:00:00 |  |  |  |  | 15
2023-07-16 00:00:00 |  |  |  |  | 15
2023-07-17 00:00:00 |  |  |  |  | 15
2023-07-18 00:00:00 |  |  |  |  | 15
2023-07-19 00:00:00 |  |  |  |  | 15
2023-07-20 00:00:00 |  |  |  |  | 15
2023-07-21 00:00:00 |  |  |  |  | 15
2023-07-22 00:00:00 |  |  |  |  | 15
Spreadsheet: 840111d1692438491-spill-error-in-unique-formula-question-unique-formula
Sheet: Need

 | Dr_Map | Cr_Map |  |  | Dr_Map | Cr_Map
 | Tax assets | Tax assets |  |  |  | Tax assets |  | This needs to sorted descending
 | Inventories | Trade and other payables |  |  | Inventories | Trade and other payables |  | This needs to sorted descending
 | General and administrative expenses | Trade and other payables |  |  | General and administrative expenses | Trade and other payables |  | This needs to sorted descending
 | Tax assets | Trade and other payables |  |  | Tax assets | Trade and other payables |  | This needs to sorted descending
 | Trade and other payables | Cash and cash equivalents |  |  | Trade and other payables | Cash and cash equivalents |  | This needs to sorted descending
 | Other non-operating expenses | Tax assets |  |  | Other non-operating expenses | Tax assets |  | This needs to sorted descending
 | Cost of sales | Inventories |  |  | Cost of sales | Inventories |  | This needs to sorted descending
 | Trade and other receivables | Tax assets |  |  | Trade and other receivables | Tax assets |  | This needs to sorted descending
 | Trade and other receivables | Revenue |  |  | Trade and other receivables | Revenue |  | This needs to sorted descending
 | Cash and cash equivalents | Trade and other receivables |  |  | Cash and cash equivalents | Trade and other receivables |  | This needs to sorted descending
 | Property, plant, and equipment | Inventories |  |  | Property, plant, and equipment | Inventories |  | This needs to sorted descending
 | Tax assets | Cash and cash equivalents |  |  | Tax assets | Cash and cash equivalents |  | This needs to sorted descending
Spreadsheet: 796311d1663220782-sum-of-unique-values-from-2-tabs-and-93
Sheet: ΣΥΝΟΛΑ 

 | ΑΕΡΟΠΟΡΙΚΗ ΕΤΑΙΡΕΙΑ | ΑΡΙΘΜΟΣ | ΤΥΠΟΣ ΑΕΡΟΣΚΑΦΟΥΣ | ΑΡΙΘΜΟΣ | ΑΕΡΟΔΡΟΜΙΟ | ΑΡΙΘΜΟΣ | ΠΑΡΑΤΗΡΗΣΕΙΣ | ΑΡΙΘΜΟΣ
 | AEGEAN AIRLINES |  | AIRBUS A220-300 |  | LGAV |  | SPECIAL LIVERY
 | AER LINGUS |  | AIRBUS A319-111 |  | LEMD/MADRID
 | AEROLINEAS ARGENTINAS |  | AIRBUS A319-112 |  | LOWS/Salzburg Austria
 | AEROMEXICO |  | AIRBUS A319-131 |  | LOWW/VIENNA
 | AIR ALBANIA |  | AIRBUS A319-132 |  | LOWI/INSBRUCK
 | AIR BALTIC |  | AIRBUS A320-214 |  | LSZH/ZURICH
 | AIR CANADA |  | AIRBUS A320-214(WL)
 | AIR EUROPA |  | AIRBUS A320-216
 | AIR EUROPA EXPRESS |  | AIRBUS A320-232
 | AIR FRANCE |  | AIRBUS A320-232(WL)
 | AIR SERBIA |  | AIRBUS A320-251N
 | AIR X CHARTER |  | AIRBUS A320-271N
 | ALITALIA |  | AIRBUS A321-231
 | AMERICAN AIRLINES |  | AIRBUS A321-251NX
 | ARKIA |  | AIRBUS A321-271NX
 | BLUEBIRD |  | AIRBUS A330-302
 | BRITISH AIRWAYS |  | AIRBUS A330-343
 | BRUSSELS |  | Airbus Helicopters AS365 N3+
 | BULGARIA AIR |  | ATR 42-600
 | DELTA AIRLINES |  | ATR 72-600 (72-212A)
 | EGYPTAIR |  | BOEING 737-3U3
 | EUROWINGS |  | BOEING 737-78J(WL)
 | GULFAIR |  | BOEING 737-84P(WL)
 | HELISTAR |  | BOEING 737-866(WL)
 | IBERIA REGIONAL |  | BOEING 737-8K2(WL)
 | ITA (ALITALIA) |  | BOEING 777-333ER
 | KLM ROYAL DUTCH AIRLINES |  | BOEING 777-3M0ER
 | LAUDA EUROPE |  | BOEING 787-8 DREAMLINER
 | LUFTHANSA |  | BOEING 787-9 DREAMLINER
 | MEA |  | BOMBARDIER CSERIES CS300
 | PRIVATE-BUSINESS |  | DE HAVILLAND CANADA DHC-8-102A DASH 8
 | QATAR AIRWAYS |  | EMBRAER EMB-120FC BRASILIA
 | SKY EXPRESS |  | EMBRAER LINEAGE 1000 (ERJ-190-100 ECJ)
 | SWIFTAIR HELLAS |  | LEARJET 60
 | SWISS |  | Messerschmitt-Bölkow-Blohm-(MBB) BK 117C-1
 | TAROM |  | AIRBUS A330-203
 | TRANSAVIA |  | BOEING 767-375ER(BDSF)
 | VOLOTEA AIRLINES |  | BOEING 737-85P(WL)
 | [NAME] UK |  | EMBRAER ERJ-195LR (ERJ-190-200 LR)
Spreadsheet: 85486d1285603095-getting-pivot-table-to-give-monthly-average-monthly-average-pivottableaverage-1-
Sheet: Sheet1

Category | Date | Value |  |  |  | Data
A | 2010-01-02 00:00:00 | 37 |  | Category | Date | Sum of Value | Average of Value | Average of Month
A | 2010-01-03 00:00:00 | 33 |  | A | Jan | 105 | 35
B | 2010-01-04 00:00:00 | 35 |  |  | Feb | 73 | 36.5
C | 2010-01-05 00:00:00 | 34 |  |  | Mar | 108 | 36
A | 2010-01-06 00:00:00 | 35 |  |  | Apr | 35 | 35
B | 2010-01-07 00:00:00 | 33 |  |  | May | 70 | 35
C | 2010-02-12 00:00:00 | 33 |  | A Total |  | 391 | 35.54545454545455 | 78.2
A | 2010-02-13 00:00:00 | 37 |  | B | Jan | 68 | 34
B | 2010-02-14 00:00:00 | 38 |  |  | Feb | 74 | 37
C | 2010-02-15 00:00:00 | 34 |  |  | Mar | 71 | 35.5
A | 2010-02-16 00:00:00 | 36 |  |  | Apr | 37 | 37
B | 2010-02-17 00:00:00 | 36 |  |  | May | 72 | 36
C | 2010-02-18 00:00:00 | 36 |  | B Total |  | 322 | 35.77777777777778 | 64.4
A | 2010-03-26 00:00:00 | 34 |  | C | Jan | 34 | 34
B | 2010-03-27 00:00:00 | 33 |  |  | Feb | 103 | 34.33333333333334
C | 2010-03-28 00:00:00 | 33 |  |  | Mar | 33 | 33
A | 2010-03-29 00:00:00 | 37 |  |  | Apr | 36 | 36
A | 2010-03-30 00:00:00 | 37 |  |  | May | 105 | 35
B | 2010-03-31 00:00:00 | 38 |  | C Total |  | 311 | 34.55555555555556 | 62.2
C | 2010-04-01 00:00:00 | 36 |  | Grand Total |  | 1024 | 35.31034482758621
A | 2010-04-02 00:00:00 | 35
B | 2010-04-03 00:00:00 | 37
C | 2010-05-09 00:00:00 | 37
A | 2010-05-10 00:00:00 | 37
B | 2010-05-11 00:00:00 | 36
C | 2010-05-12 00:00:00 | 34
A | 2010-05-13 00:00:00 | 33
B | 2010-05-14 00:00:00 | 36
C | 2010-05-15 00:00:00 | 34