tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 186336d1349991647-i-need-help-with-auto-summing-unique-groups-and-formatting-automatically-myworkbook
Sheet: Sheet3

AZ | test one | Name | Name | [NAME] | 2012-10-01 00:00:00 | 10
AZ | test one | Name | Name | [NAME] | 2012-10-02 00:00:00 | 10
TX | test one | Name | Name | [NAME] | 2012-10-03 00:00:00 | 10
 |  |  |  |  |  | 30
CA | test two | Name | Name | [NAME] | 2012-10-04 00:00:00 | 20
CA | test two | Name | Name | [NAME] | 2012-10-05 00:00:00 | 20
NM | test two | Name | Name | [NAME] | 2012-10-06 00:00:00 | 20
 |  |  |  |  |  | 60
NM | test three | Name | Name | [NAME] | 2012-10-07 00:00:00 | 30
NY | test three | Name | Name | [NAME] | 2012-10-08 00:00:00 | 30
NY | test three | Name | Name | [NAME] | 2012-10-09 00:00:00 | 30
NY | test three | Name | Name | [NAME] | 2012-10-10 00:00:00 | 30
 |  |  |  |  |  | 120
PA | test four | Name | Name | [NAME] | 2012-10-11 00:00:00 | 40
PA | test four | Name | Name | [NAME] | 2012-10-12 00:00:00 | 40
 |  |  |  |  |  | 80
Spreadsheet: 889154d1739881537-i-want-to-know-each-security-code-number-on-a-specific-date-excel-query-17-02-2025
Sheet: Pivot

Maturity Date | (All)
Currency | (All)
Tenure | (All)
Security Code | Values | Total
[PHONE] | Count of Issue Date | 21
 | Sum of Investment  Amount | 48076000
[PHONE] | Count of Issue Date | 24
 | Sum of Investment  Amount | 215552000
[PHONE] | Count of Issue Date | 5
 | Sum of Investment  Amount | 5200000
[PHONE] | Count of Issue Date | 4
 | Sum of Investment  Amount | 1480000
[PHONE] | Count of Issue Date | 1
 | Sum of Investment  Amount | 2100000
[PHONE] | Count of Issue Date | 4
 | Sum of Investment  Amount | 246000
[PHONE] | Count of Issue Date | 3
 | Sum of Investment  Amount | 196000
[PHONE] | Count of Issue Date | 2
 | Sum of Investment  Amount | 1324000
[PHONE] | Count of Issue Date | 2
 | Sum of Investment  Amount | 149000
[PHONE] | Count of Issue Date | 1
 | Sum of Investment  Amount | 88000
Total Count of Issue Date |  | 67
Total Sum of Investment  Amount |  | 274411000
Spreadsheet: 0a586f89-4511-40f3-a1ff-dfbd714b44e5
Sheet: Sheet1

N | Not available or not comparable
D | Withheld to avoid disclosing data for individual companies; data are included in higher level totals
a | 0 to 19 employees
b | 20 to 99 employees
c | 100 to 249 employees
e | 250 to 499 employees
f | 500 to 999 employees
g | 1,000 to 2,499 employees
h | 2,500 to 4,999 employees
i | 5,000 to 9,999 employees
j | 10,000 to 24,999 employees
k | 25,000 to 49,999 employees
Spreadsheet: 758419d1638866874-sum-each-nth-cell-b-visibility-and-condition-formula-help
Sheet: 1. Iroda-Office

370 |  | 325
 | 1 Irodaépület / Office building |  | [NAME] | MENNY QUANTITY | Material Price | LABOUR | Transportation | TOTAL UNIT PRICE | TOTAL (Cost) | Material Price | LABOUR | Transportation | TOTAL UNIT PRICE | TOTAL (Cost) | Material Price | LABOUR | Transportation | TOTAL UNIT PRICE | TOTAL (Cost) | Material Price | LABOUR | Transportation | TOTAL UNIT PRICE | TOTAL (Cost) | Material Price | LABOUR | Transportation | TOTAL UNIT PRICE | TOTAL (Cost) | Material Price | LABOUR | Transportation | TOTAL UNIT PRICE | TOTAL (Cost) | Material Price | LABOUR | Transportation | TOTAL UNIT PRICE | TOTAL (Cost)
PLASTERBOARD | 1 Irodaépület / Office building | 5.1. | Plasterboard | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000 | 20000 | INC
Porotherm_Wall | 1 Irodaépület / Office building | 5.3. | Masonry partition wall | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000 | 20000 | INC
Curtain_Wall | 1 Irodaépület / Office building | 4.1.2 | Curtain Wall | 50 | 500000 | NOT INC | INC |  |  | 500000 | 20000 | INC
DOOR | 1 Irodaépület / Office building | 4.1.3 | Aluminium Exterior Doors | 2 |  |  |  |  |  | 500000 | 20000 | INC
DOOR | 1 Irodaépület / Office building | 4.1.4 | Fire Rated Exterior door EI30 | 2 |  |  |  |  |  |  |  |  |  |  | 500000 | NOT INC | INC |  |  | 500000 | 20000 | INC
DOOR | 1 Irodaépület / Office building | 4.1.5 | steel band frames DI | 2 |  |  |  |  |  | 500000 | 20000 | INC |  |  | 500000 | NOT INC | INC |  |  |  |  |  |  |  | 500000 | 20000 | INC
DOOR | 1 Irodaépület / Office building | 4.1.6 | Aluminium interior Door | 2 |  |  |  |  |  | 500000 | 20000 | INC |  |  | 500000 | NOT INC | INC |  |  |  |  |  |  |  | 500000 | 20000 | INC
DOOR | 1 Irodaépület / Office building | 4.1.7 | Fire Rated interiro steel door EI30 | 2 |  |  |  |  |  |  |  |  |  |  | 500000 | NOT INC | INC |  |  | 500000 | 20000 | INC
DOOR | 1 Irodaépület / Office building | 4.1.8 | Fire Rated interior door EI60 (surface laminate) | 2 |  |  |  |  |  |  |  |  |  |  | 500000 | NOT INC | INC |  |  |  |  |  |  |  | 500000 | 20000 | INC
Spreadsheet: 856167d1705511645-sum-of-subintervals-without-counting-gaps-nor-double-counting-overlaps-time-overlaps-and-gaps
Sheet: Sheet1

Section 1 |  |  |  | Section 2 |  |  |  | Section 3
Start | Stop | Duration |  | Start spill range | Stop spill range | Duration spill range |  | Day 1 start | Day 1 stop | Duration day 1 | Day 1 stop | Day 2 stop | Duration day 2
2023-09-01 09:12:00 | 2023-09-01 17:04:00
2023-09-03 21:44:00 | 2023-09-04 01:40:00 |  |  | 2023-09-03 21:44:00 | 2023-09-04 01:40:00 | 3.933333333407063 |  | 2023-09-03 21:44:00 | 2023-09-04 00:00:00 | 2.266666666720994 | 2023-09-04 00:00:00 | 2023-09-04 01:40:00 | 1.666666666686069
2023-09-04 11:33:00 | 2023-09-05 02:00:00 |  |  | 2023-09-04 11:33:00 | 2023-09-05 02:00:00 | 14.45000000012806 |  | 2023-09-04 11:33:00 | 2023-09-05 00:00:00 | 12.45000000006985 | 2023-09-05 00:00:00 | 2023-09-05 02:00:00 | 2.000000000058208
2023-09-05 05:08:00 | 2023-09-05 21:03:00 |  |  | 2023-09-05 05:08:00 | 2023-09-05 21:03:00 | 15.91666666668607 |  | 2023-09-05 05:08:00 | 2023-09-05 21:03:00 | 15.91666666668607 | N/A | N/A | 0
2023-09-05 05:08:00 | 2023-09-05 21:03:00 |  |  | 2023-09-05 05:08:00 | 2023-09-05 21:03:00 | 15.91666666668607 |  | 2023-09-05 05:08:00 | 2023-09-05 21:03:00 | 15.91666666668607 | N/A | N/A | 0
2023-09-05 22:49:00 | 2023-09-06 10:08:00 |  |  | 2023-09-05 22:49:00 | 2023-09-06 10:08:00 | 11.31666666670935 |  | 2023-09-05 22:49:00 | 2023-09-06 00:00:00 | 1.183333333348855 | 2023-09-06 00:00:00 | 2023-09-06 10:08:00 | 10.1333333333605
2023-09-06 20:10:00 | 2023-09-06 21:22:00 |  |  | 2023-09-06 20:10:00 | 2023-09-06 21:22:00 | 1.199999999895226 |  | 2023-09-06 20:10:00 | 2023-09-06 21:22:00 | 1.199999999895226 | N/A | N/A | 0
2023-09-08 15:02:00 | 2023-09-08 19:31:00 |  |  | 2023-09-08 15:02:00 | 2023-09-08 19:31:00 | 4.483333333453629 |  | 2023-09-08 15:02:00 | 2023-09-08 19:31:00 | 4.483333333453629 | N/A | N/A | 0
2023-09-09 08:55:00 | 2023-09-09 23:27:00 |  |  | 2023-09-09 08:55:00 | 2023-09-09 23:27:00 | 14.53333333320916 |  | 2023-09-09 08:55:00 | 2023-09-09 23:27:00 | 14.53333333320916 | N/A | N/A | 0
Test start time | Test stop time | Duration
2023-09-05 00:00:00 | 2023-09-06 00:00:00
[NAME] for calculating time that fits between test start time (A17) and test stop time (B17): |  |  |  |  |  |  |  | This setup/formula sums the duration of each Section of each phase that fits. It works as long as there are no overlapping time in Section 3, and as long as the original durations in Section 1 / 2 does not last more than two days.
[NAME] for calculating time that fits between test start time (A17) and test stop time (B17): |  |  |  |  |  |  |  | This formula finds the duration between the latest and earliest times that fit within the test duration. It works as long as there are no time overlaps or time gaps in Section 2.
[NAME] needed for calculating the amount of duration from Section 2 that falls between the test start time (A17) and test stop time (B17), without counting time gaps and without double counting time overlaps: |  |  |  |  |  |  | 19.10000000009313
Spreadsheet: 841169d1693406256-flag-org-dup-triplicates-in-a-list-based-on-values-in-two-columns-flag_org_dup
Sheet: Sheet1

Code | Item | Flag
100-10 | NY | ORG
100-20 | SA | ORG
100-10 | SA | ORG
100-20 | NY | ORG
100-30 | CA | ORG
100-10 | NY | DUP
100-10 | SA | DUP
100-20 | NY | DUP
100-20 | SA | DUP
100-10 | NY | TRIP
100-10 | SA | TRIP
Spreadsheet: darrell_schoolcraft__7316__imball0202
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -42385 | -39000 |  |  |  |  |  |  |  | San Juan
2 | -42398 | -40000 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 | -42710 | -40000 |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 |  |  |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 |  |  |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 |  |  |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 |  |  |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 |  |  |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 |  |  |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10
11
12
13
14 |  |  |  |  |  | 9/1 - 9/25
15
16
17
18
19 |  |  |  |  |  | Accumulated @ 9/25/01
20
21 |  |  |  |  |  | Equilalent volumes at 9/25/01
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | -2220
2002-02-03 00:00:00
CBS Volume
 |  |  | 86032
Spreadsheet: 05e41bd9-353f-4021-8d1a-638f59e092c1
Sheet: READ

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | Program | 1 | X | 1 | X | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
1 | READ 078X2 | 1 | X | 1 | X | 1 | 5 | 1 | 3 | 1
5 | READ 100 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | READ 925X2 | 1 | X | 1 | X | 1 | 4 | 1 | 2 | 1
1 | READ 956X2 | 1 | X | 1 | X | 1 | 4 | 1 | 2 | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 5d9bf106-68e5-48ab-88c3-6c79760b7607
Sheet: 65AA

ISA SENIOR WORLD
COLUMBUS, IN
JULY 26-27-28, 2013
 | MEN'S 65 AA DIVISION
 |  |  |  |  | WON |  | LOSS
1.  INDIANA LEGENDS/COLUMBUS |  |  |  |  | II
2.  KENTUCKIANA 65'S |  |  |  |  |  |  | II
3.  DAYTON LEGENDS 65 |  |  |  |  | I |  | I
4.  US JOBS/INDY 65 |  |  |  |  | II
5.  Mid State Seniors, 70AAA |  |  |  |  |  |  | II
FRIDAY 7-26, 2013 - DUNN SPORTS COMPLEX
TIME |  | RUNS |  | TEAM # |  | RUNS |  | DIA. #
9AM |  | 22 |  | 1 v 2 |  | 10 |  | #1
9AM |  | 16 |  | 3 v 4 |  | 23 |  | #2
10:30am |  | 16 |  | 2 v 4 |  | 17 |  | #1
NOON |  | 11 |  | 5 v 1 |  | 26 |  | #1
1:30pm |  | 11 |  | 5 v 3 |  | 21 |  | #1
[NAME]:
Teams will play 2 seed games for seeding into a 3 game guarantee bracket
Team #5 play heads up in this division.
HOME RUN RULE - AA is 1 per team per game then outs
RUN RULE- 5 RUNS PER 1/2 INNING + OPEN INNING
TIME LIMITS - SEED GAMES 65 MIN. + OPEN INNING - BRACKET PLAY 70 MIN.+ OPEN | Championship game is 7 innings
[NAME] FLIP
ROSTER IS SUBJECT TO APPROVAL OF SSUSA
YOU MUST WIN YOUR DIVISION TO RECEIVE THE SSUSA TOC BERTH
Spreadsheet: louise_kitchen__23140__Canada reconciliation
Sheet: Devries

CES Originations Paper Deals
2001 Income Summary  USD
 |  | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | Total Q1 |  | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | Total  Q2 |  | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | Total  Q3 |  | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Total  Q4 |  | Total
F/X |  | 1.4975 | 1.5352 | 1.5756 |  |  | 1.5368 |  | 1.513 |  |  | 1.533 | 1.5505 | 1.578 |  |  | 1.5123 | 1.5422 | 1.522436842105263
Calger RC #236
Paper Swaps Interco
Paper Swaps 3rd Party
Deferred charge amortization (SAP 42000000) |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Net Paper Swaps |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Papier [NAME]
Interest Income (PML)
Other Income (Papier [NAME])
F/X Liquidations - Interco
F/X Liquidations - Papier Masson
Net F/X
Subtotal
(Revenue)/Expense from Hedge (28C) |  | 0 | 0
Total (Revenue)/Expense RC #236 |  | -204048.5275459099 | 315756.4551849922 | -514147.4232038589 | -889253.4155751986 |  | 987394.8073919832 | -302237.7634660422 | -91408.90284203572 | 593748.1410839054
Total (Revenue)/Expense |  | -204048.5275459099 | 315756.4551849922 | -514147.4232038589 | -889253.4155751986 |  | 987394.8073919832 | -302237.7634660422 | -91408.90284203572 | 593748.1410839054
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total for Devries per Canada
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total for Devries detail - PML Service |  |  |  |  |  |  |  | 500000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 703509d1605025360-need-to-convert-schedule-from-workday-to-now-or-hours-machine-shop-schedules_excel-forum-2003-2-
Sheet: Plating Cost Calculator

 |  |  |  |  | PURCHASE ORDER ENTRY (Do not populate gray cells)
CNC / LASER ENTRY (Do not populate gray cells) |  |  |  |  | PO SUBTOTAL | 195 |  | Expedite: SAME DAY
 |  |  |  |  | PO WASTE FEE (5% of SUBTTL) | 39 |  | Expedite: NEXT DAY
P/N | L | W | REV | QTY | Total Dimensions | Cost per Part | Total QTY Cost
PN 5 | 8.423 | 6.762 | A1 | 4 | 126 | 8.82 | 35.28
PN 8 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
www.atlaspm.xxx/toms-tutorials-for-excel/toms-tutorials-for-excel-listing-noncontiguous-data-without-blanks/ |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
Spreadsheet: 758457d1638885314-populate-data-based-on-selection-from-dropdown-project-planning
Sheet: Profit Loss

 | Jeddah
 | Sales |  |  |  | Project Expense
 | Invoice No | [NAME] | Unit Rate | TOTAL
 | 6698
 | 6731
 | 6699
 | 6712
 | 6714
 | 6723
 | 6729
 | 6725
 | 6724
 | 6724
 | 6724
 | 6724
 | 6725
 | 6730
 | 6641
 | 6733
 | 6733
 | 6733
 | 6725
Spreadsheet: 330291d1404693538-looking-for-way-to-calculate-golf-tournament-results-golf-par
Sheet: Sheet1

hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | total
par | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 5 | 3 | 4 | 3 | 4 | 4 | 3 | 5 | 4 | 4 | 5
Player 1 | 5 | 3 | 4 | 3 | 5 | 4 | 4 | 4 | 6 | 7 | 5 | 8 | 9 | 3 | 5 | 4 | 4 | 6
diff (worst highlighted)
new score | 5 | 3 | 4 | 3 | 5 | 4 | 4 | 4 | 6 | 4 | 5 | 4 | 4 | 3 | 5 | 4 | 4 | 6
Player 2 | 5 | 6 | 7 | 5 | 8 | 4 | 3 | 4 | 5 | 6 | 4 | 6 | 10 | 4 | 5 | 4 | 4 | 4
diff (worst highlighted)
new score | 5 | 6 | 4 | 5 | 3 | 4 | 3 | 4 | 5 | 6 | 4 | 6 | 4 | 4 | 5 | 4 | 4 | 4
Player 3 | 8 | 9 | 6 | 7 | 9 | 8 | 14 | 6 | 7 | 5 | 6 | 7 | 9 | 6 | 5 | 5 | 5 | 5
diff (worst highlighted)
new score | 8 | 4 | 6 | 7 | 3 | 8 | 4 | 6 | 7 | 5 | 6 | 7 | 9 | 6 | 5 | 5 | 5 | 5
 |  |  |  | orange not done as they are duplicate 3rd worst
Spreadsheet: 737417d1624403307-sumproduct-with-multiple-variables-sample-set
Sheet: Sheet1

2021
 |  | Forecast
 | Plumbing |  |  |  |  |  | [NAME] in "Total" returns value for budget if no value entered into estimate or change order. If so, returns the sum of those values for the year 2021.
 | Electrical
 | Carpentry |  |  |  |  |  | I want a formula that can do the above but also include another criteria that if the final amount has a value, that is to be subtracted from the total to arrive at a forecast of potential future expense.
 |  |  |  |  |  |  | Then, I want a formula that can return ths "forecast" per trade. Same concept as total, but with an additional criteria, "Plumbing"
 | Total
Year | Trade | Budget | Estimate | [NAME] | Final Amount
2021 | Plumbing | 2500 | 2250 |  | 2250
2021 | Plumbing | 2500 | 2500
2021 | Plumbing | 1500 | 1000 | 500 | 1500
2021 | Electrical | 1000
2021 | Electrical | 500 | 250 |  | 250
2021 | Electrical | 2000
2021 | Electrical | 1000 | 500 |  | 500
2021 | Electrical | 3000 | 3000 | 500
2021 | Carpentry | 1000 | 500
2021 | Carpentry | 5000 | 3750
2021 | Carpentry | 4000
Spreadsheet: 109305d1306212557-sumproduct-and-sumif-j-morrow_master_2
Sheet: Data Returns

PM2 Required | Base Location | Page | Section | Total
REQUIRED | Base1 | Hostile | Swivels | 0 |  |  | SUMPRODUCT(--(Master!$B$2:$B$2500=$A2),--(Master!$G$2:$G$2500=$B2),--(Master!$H$2:$H$2500=$C2),--(Master!$I$2:$I$2500=$D2))
GOOD | Base1 | Cal_Test | Bridle | 0
GOOD | Base1 | Cal_Test | Bridle | 0
GOOD | Base1 | Cal_Test | Bridle | 0
GOOD | Base1 | Cal_Test | Bridle | 0
GOOD | Base1 | Cal_Test | Bridle | 0
Total OTSD NOMEM | 156 |  |  |  |  |  | SUM(IF(LEN(TRIM('Master'!j2:[NAME]:[NAME]:j199," ",""))+1))
Total Other Open NTFY | 342 |  |  |  |  |  | Note: to make the above array formula work, after typing in the formula, press ctrl+shift_enter
Spreadsheet: 86792d1286766828-counting-frequency-of-transactions-by-time-sample-1-
Sheet: Sheet1

Name | Date/Time
[NAME] | 2014-09-30 16:40:00
[NAME] | 2014-10-01 16:19:43
[NAME] | 2014-10-02 17:50:39
[NAME] | 2014-10-02 07:18:00
[NAME] | 2014-10-02 09:16:00
1 |  |  | 2 |  |  | 3
12:00:00 | 2 |  | list without duplicates |  |  | 01:00:00 | 2
01:00:00 | 2 |  | 12:00:00 | 2 |  | 02:00:00 | 5
02:00:00 | 5 |  | 01:00:00 | 2 |  | 03:00:00 | 1
02:00:00 | 5 |  | 02:00:00 | 5 |  | 04:00:00 | 1
02:00:00 | 5 |  | 03:00:00 | 1 |  | 05:00:00 | 1
05:00:00 | 1 |  | 04:00:00 | 1 |  | 06:00:00 | 2
06:00:00 | 2 |  | 05:00:00 | 1 |  | 07:00:00 | 2
07:00:00 | 2 |  | 06:00:00 | 2 |  | 08:00:00 | 2
08:00:00 | 2 |  | 07:00:00 | 2 |  | 09:00:00 | 2
09:00:00 | 2 |  | 08:00:00 | 2 |  | 10:00:00 | 2
10:00:00 | 2 |  | 09:00:00 | 2 |  | 11:00:00 | 2
11:00:00 | 2 |  | 10:00:00 | 2 |  | 12:00:00 | 2
12:00:00 | 2 |  | 11:00:00 | 2 |  | 13:00:00 | 0
01:00:00 | 2 |  |  |  |  | 14:00:00 | 0
02:00:00 | 5 |  |  |  |  | 15:00:00 | 0
03:00:00 | 1 |  |  |  |  | 16:00:00 | 0
04:00:00 | 1 |  |  |  |  | 17:00:00 | 0
02:00:00 | 5 |  |  |  |  | 18:00:00 | 0
06:00:00 | 2 |  |  |  |  | 19:00:00 | 0
07:00:00 | 2 |  |  |  |  | 20:00:00 | 0
08:00:00 | 2 |  |  |  |  | 21:00:00 | 0
09:00:00 | 2 |  |  |  |  | 22:00:00 | 0
10:00:00 | 2 |  |  |  |  | 23:00:00 | 0
11:00:00 | 2 |  |  |  |  | 1904-01-02 00:00:00 | 0
Spreadsheet: 485861d1477117179-find-trends-in-employee-data-example
Sheet: page 14

Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
2 7 |  | 6:00     15:00 | 4:17     11:17 |  | 16:00    23:59 | 14:00    22:00 | 21:25     6:54
 | 23:00     7:21 |  | 15:00    24:00 | 15:00     1:00
 | 6:40     15:54 |  |  | 6:00     15:00 | 6:00     14:00 | 5:20     14:47 | 16:32    23:47
 | 12:50    22:02 | 15:40    22:17 |  | 6:00     15:00 | 4:17     10:27
 |  |  | 14:00    22:24 | 23:01     6:41 | 21:31     7:17 |  | 14:00    22:00
 | 13:49    22:31 | 23:31     7:41 | 22:49     6:11
Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
2 8 | 6:32     15:47 | 6:00     15:00 |  |  | 13:50    22:47 | 13:55    23:54 | 14:00    22:00
 | 12:05    21:47 | 15:02    21:49 | 14:00    22:00 | 12:00    20:48
 | 11:55    20:41 |  |  | 22:49     6:11 | 23:01     7:11 |  | 15:00     1:00
 |  | 7:00     16:00 | 6:00     14:00 | 4:17     11:17 | 7:19     14:25
 |  | 23:02     5:41 | 23:27     6:54 |  |  | 6:27     15:17 | 20:57     6:21
 | 23:01     6:41 |  | 14:00    22:00 | 15:00     1:00
Spreadsheet: 812745d1673355898-formula-for-finding-the-number-of-entries-per-month-by-category-please-help-case-log-test-1
Sheet: Summary 

Formal CASE BY MONTH |  |  | Formal CASE BY MONTH |  |  | LTS CASE BY AREA |  |  | GRIEVANCE CASE BY AREA
 | LOGGED CASES |  |  | LOGGED CASES
JANUARY |  |  | JANUARY
FEBRUARY |  |  | FEBRUARY
[NAME] |  |  | [NAME]
APRIL |  |  | APRIL
MAY |  |  | MAY
[NAME] |  |  | [NAME]
JULY |  |  | JULY
AUGUST |  |  | AUGUST
SEPTEMBER |  |  | SEPTEMBER
OCTOBER |  |  | OCTOBER
NOVEMBER |  |  | NOVEMBER
DECEMBER |  |  | DECEMBER
YEAR TO DATE |  |  | YEAR TO DATE
 |  |  | CASE BY POLICY
CONDUCT  CASE BY AREA |  |  | Grievance |  |  | STS CASE BY AREA |  |  | PROBATION  CASE BY AREA
 |  |  | Probation
 |  |  | Absence
 |  |  | Advice
 |  |  | Bullying/Harassment
 |  |  | Occ Health
 |  |  | Stess Risk Assessment
 |  |  | Capbility
 |  |  | Managament Instruction
 |  |  | Flexible Working
 |  |  | Other
 |  |  | PIP
 |  |  | ACAS
 |  |  | ET
 |  |  | DSAR
FLEXIBLE WORKING BY AREA |  |  | CAPABILITY CASE BY AREA
Spreadsheet: 758607d1638968996-rolling-total-for-previous-12-months-hours-sample
Sheet: Annual Summary

 | Logbook Summary 12 months: January 2021 - January 2022
 | Aircraft Type | Date when last
 |  | Flown | Dual | PIC | Co-Pilot | Instruction
 | BE58 |  |  |  |  |  |  | AC50
 | BE76 |  |  |  |  |  |  | BE20
 | C172 |  |  |  |  |  |  | BE58
 | C208 |  |  |  |  |  |  | BE76
 | C210 |  |  |  |  |  |  | C172
 | FNPT2 |  |  |  |  |  |  | C182
 |  |  |  |  |  |  |  | C206
 | Totals |  |  |  |  |  |  | C208
 | Grand Total |  |  |  |  |  |  | C210
 |  |  |  |  |  |  |  | C72R
 | Logbook Summary 12 months: May 2018 - May 2019 |  |  |  |  |  |  | RA72
 | Aircraft Type | Date when last |  |  |  |  |  | P28A
 |  | Flown | Dual | PIC | Co-Pilot |  |  | P28R
 | BE58 |  |  |  |  |  |  | P28T
 |  |  |  |  |  |  |  | SR20
 |  |  |  |  |  |  |  | X324
 |  |  |  |  |  |  |  | FNPT2
 |  |  |  |  |  |  |  | IPT200
 | Totals
 | Grand Total
Spreadsheet: 145629d1331667603-forecast-by-using-index-match-formulas-sample_forecast_ind_match
Sheet: Sheet1

Forecast
110
120
130
140 | #N/A
150
160
170
180
Known values
166 | 500
142 | 600
145 | 450
188 | 300
199 | 200
Spreadsheet: 812495d1673189653-help-with-copying-the-formulas-across-the-row-to-a-column-sample-book-ans
Sheet: Sheet1

 |  | 2023-01-01 00:00:00 | 2023-01-02 00:00:00 | 2023-01-03 00:00:00 | 2023-01-04 00:00:00 | 2023-01-05 00:00:00 | 2023-01-06 00:00:00 | 2023-01-07 00:00:00 | 2023-01-08 00:00:00 | 2023-01-09 00:00:00 | 2023-01-10 00:00:00 | 2023-01-11 00:00:00 | 2023-01-12 00:00:00 | 2023-01-13 00:00:00 | 2023-01-14 00:00:00 | 2023-01-15 00:00:00
 | A | 5000 |  |  | 8000 | 5000 |  |  | 8000 | 5000 |  |  | 8000 |  |  | 5000
 | B | 6500 | 2500 |  | 1500 | 6500 | 2500 |  | 1500 | 6500 | 2500 |  | 1500 | 2500 |  | 6500
 | C |  |  | 3000 | 2500 |  |  | 3000 | 2500 |  |  | 3000 | 2500 |  | 3000
 | D |  | 7000 |  | 10000 |  | 7000 |  | 10000 |  | 7000 |  | 10000 | 7000
 | E |  |  | 5000 | 7000 |  |  | 5000 | 7000 |  |  | 5000 | 7000 |  | 5000
 | F |  |  | 6000 | 50000 |  |  | 6000 | 50000 |  |  | 6000 | 50000 |  | 6000
 | G |  |  |  | 32 |  |  |  | 32 |  |  |  | 32
 |  |  |  |  | 2023-01-01 00:00:00
 |  |  |  |  | 2023-01-02 00:00:00
 |  |  |  |  | 2023-01-03 00:00:00
 |  |  |  |  | 2023-01-04 00:00:00
 |  |  |  |  | 2023-01-05 00:00:00
 |  |  |  |  | 2023-01-06 00:00:00
 |  |  |  |  | 2023-01-07 00:00:00
 |  |  |  |  | 2023-01-08 00:00:00
 |  |  |  |  | 2023-01-09 00:00:00
 |  |  |  |  | 2023-01-10 00:00:00
 |  |  |  |  | 2023-01-11 00:00:00
 |  |  |  |  | 2023-01-12 00:00:00
 |  |  |  |  | 2023-01-13 00:00:00
 |  |  |  |  | 2023-01-14 00:00:00
 |  |  |  |  | 2023-01-15 00:00:00