tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: hunter_shively__12754__EnovateDPR0204
Sheet: ENOVATE DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENOVATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  |  |  |  |  |  |  | In thousands (000's)
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
ENOVATE
GAS TRADING |  |  | 10 Bcf |  |  | 20 Bcf |  |  |  | 2000
Short Term Trading
Long Term Trading |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  | MTD | QTD | YTD | MTD 12/12 |  | 114
 |  | ENOVATE | 208.3089264000002 | 5942.561065400002 | 4638.0959264 |  |  |  |  | P&L 13th |  | 17
 |  |  |  |  |  |  |  |  |  | MTD 13th |  | 131
 |  | GAS TRADING | 208.3089264000002 | 5942.561065400002 | 4638.0959264
 |  | Short Term Trading | 208.3089264000002 | 5942.561065400002 | 4638.0959264 |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: michelle_lokay__26750__imball0112
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -21436 | -10000 | -24220 | -11950
2 |  | -10000 |  | -11950
3 | -9944 | -10000 | -17203 | -17052
4 | -174 |  | -2179 | -1950
5 |  |  |  | -1950
6 |  |  |  | -1950
7 |  |  |  | -1950
8 |  |  |  | -1950
9 |  |  |  | -1950
10 |  |  |  | -1950
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-11-30 00:00:00 |  |  |  | 10248
 | 2001-12-10 00:00:00
CBS Dollars
 |  |  | -61736
Spreadsheet: 70639d1271346140-conditional-sum-question-excel
Sheet: Sheet1

 | Current Sales
Jan 2010 | 50
Feb 2010 | 75
Mar 2010 | 80
Apr 2010 | 35
May 2010
Jun 2010
 | Prior Sales
Dec 2009 | 80
Nov 2009 | 64
Oct 2009 | 35
Sep 2009 | 50
Aug 2009 | 97
Jul 2009 | 55
Jun 2009 | 37
May 2009 | 68
Apr 2009 | 42
Mar 2009 | 68
Feb 2009 | 46
Current Total
Prior Total
Spreadsheet: 804408d1668068502-correl-if-and-functions-not-working-together-nasdaq-global-smart-airlines-index-
Sheet: Calculations

Sum of Log returns in different periods
 | Nasdaq | Aeroflot
15/07/22 - 11/01/22
03/01/22 - 11/01/22
12/01/22 - 20/01/22
17/02/22 - 24/02/22
24/03/22 - 30/03/22
24/03/22 - 20/09/22
Difference in logs. Lower number = higher correlation with industry |  |  |  |  | Correlation
 | Aeroflot |  |  |  |  | Aeroflot
15/07/22 - 11/01/22 |  |  |  |  | 15/07/22 - 11/01/22
03/01/22 - 11/01/22 |  |  |  |  | 03/01/22 - 11/01/22
12/01/22 - 20/01/22 |  |  |  |  | 12/01/22 - 20/01/22
17/02/22 - 24/02/22 |  |  |  |  | 17/02/22 - 24/02/22
24/03/22 - 30/03/22 |  |  |  |  | 24/03/22 - 30/03/22
24/03/22 - 20/09/22 |  |  |  |  | 24/03/22 - 20/09/22
 |  |  |  |  |  | Irregularities in correlation
the search for insider trading within short periods |  |  |  |  | The search for insider trading within short periods
Measure of short-term effect of invasion |  |  |  |  | Measure of short-term effect of invasion
Measure of long-term effect of invasion |  |  |  |  | Measure of long-term effect of invasion
Spreadsheet: 82865d1282863116-pull-data-from-one-sheet-to-another-macro-help
Sheet: Sheet1

Loan Number | Loan Number | Loan Number | TrancheName | Loan Purpose | Margin / Spread | Original Maturity | Payment Type | Amortization | Index | Days Past Due | Paid Through Date | Tier | Original Commitment | Current Balance
111111 | 555555 | 555555-A | default | Acquisition | 0.014 | 2016-01-31 00:00:00 | Amortizing | 0 | 1 Month LIBOR | 0 |  | 1 | 100000000 | 50000000
111111 | 555555 | 555555-B | default | Other | 0.035 | 2008-02-07 00:00:00 | Interest Only | 0 | 1 Month LIBOR | 0 |  | 1 | 69000000 | 3500000
111111 | 555555 | 555555-C | default | Acquisition | 0.03 | 2009-08-11 00:00:00 | Amortizing | 0 | 1 Month LIBOR | 0 |  | 1 | 200811888 | 196267000
111111 | 555555 | 555555-D | [NAME] | Acquisition | 0.019 | 2011-03-22 00:00:00 | Interest Only | 0 | 3 Month LIBOR | 0 |  | 1 | 70526000 | 70380000
999999 | 9999999 | 9999999-A | default | Acquisition and Development | 0.0185 | 2011-03-08 00:00:00 | Interest Only | 0 | 3 Month LIBOR | 0 |  | 1 | 218000000 | 218000000
999999 | 9999999 | 9999999-B | [NAME] | Construction | 0.0185 | 2011-03-08 00:00:00 | Interest Only | 0 | 3 Month LIBOR | 0 |  | 1 | 98531000 | 34058000
999999 | 9999999 | 9999999-C | default | Interest Reserve | 0.0185 | 2011-03-08 00:00:00 | Interest Only | 0 | 3 Month LIBOR | 0 |  | 1 | 74301000 | 66301000
Spreadsheet: 329678d1404381719-calculation-of-mean-meadian-max-from-data-in-a-range-from-to-of-dates-without-vba-excelproblem_if-date-from-to
Sheet: Tabelle1

HH | date | t1 | t2 | xy (%) |  |  | HH |  | TAG | MONAT |  | datum |  | Mean | Median | [NAME]
e | 2013-05-04 00:00:00 | l | w | 5 |  | write by hand -> | g | von | 4 | 1 |  | 2013-01-04 00:00:00 |  | 6.625 | 6.65 | 8.4
e | 2013-08-08 00:00:00 | l | w | 3 |  |  |  | bis | 5 | 10 |  | 2013-10-05 00:00:00
e | 2013-01-01 00:00:00 | l | w | 2 |  |  |  |  |  |  | New date formula has been used.. |  |  | I have used array formula
e | 2013-01-04 00:00:00 | hs | t | 1 |  |  |  |  |  |  |  |  |  | so use ctrl + shift + enter
g | 2013-02-12 00:00:00 | hs | t | 5.3
g | 2013-05-19 00:00:00 | sss | t | 8 |  |  |  |  |  |  |  |  |  | enter only yellow colored cells…
g | 2013-01-17 00:00:00 | ss | t | 4.8
g | 2013-02-28 00:00:00 | l | w | 8.4 |  |  |  |  |  |  |  |  |  | and please click * if helped…
e | 2013-12-31 00:00:00 | l | w | 0.2
e | 2013-05-04 00:00:00 | l | w | 8.1
e | 2013-08-08 00:00:00 | l | w | 3.6
e | 2013-01-01 00:00:00 | l | w | 2
e | 2013-01-04 00:00:00 | l | t | 8
k | 2013-02-12 00:00:00 | l | w | 8.2
k | 2013-05-19 00:00:00 | hs | t | 6
k | 2013-01-17 00:00:00 | hs | w | 8
i | 2013-02-28 00:00:00 | s | w | 2
i | 2013-12-31 00:00:00 | s | w | 8
i | 2013-02-12 00:00:00 | ss | w | 6
i | 2013-05-19 00:00:00 | sss | t | 8
i | 2013-01-17 00:00:00 | l | t | 5
i | 2013-12-12 00:00:00 | l | w | 4
…etc | …etc | …etc | …etc | …etc
 | >mehrere tausend zeilen [NAME]
Spreadsheet: 132923d1324033890-hyperlink-to-take-me-on-a-worksheet-when-selected-sample
Sheet: 6433

[NAME] Record |  |  | RO NUMBER | 6433
 | TOTAL PARTS/SERVICE |  | VEHICLE MAKE: | Scion
 | TOTAL RECIVABLE | 0 | MODEL: | Xa | OWNER NAME:
 | DEDUCTABLE |  | YEAR: | 2005 | VIN NO:
 | CUSTOMER PAY |  | LICENSE NO: |  | INSURANCE:
 | BALANCE DUE
 | [NAME] | CLOSED |  | IN | OUT | DATE
 |  | OPEN | MILEAGE |  |  | DROPPED OFF | PICKED UP
 |  | CLOSED |  |  |  | 2011-11-16 00:00:00 | 2011-11-21 00:00:00
DATE | INVOICE No. | SUPPLIER | PART DESCRIPTION | USED/NEW/SVC | CHECK NO. | AMOUNT PAID | CUST PAY | DEDUCT | PYMNT RCVD
2011-11-17 00:00:00 | 994966 | import auto glass | ati door glass | a/m new |  | 47.39
2011-11-17 00:00:00 | 103943-1 | cabe scion | fr door glass | new | 21661 | 68.26
2011-11-17 00:00:00 | 103943 | cabe scion | mirror assy, fr door glass | new | 21661 | 135.06
2011-11-18 00:00:00 | 21673 | cabe scion | outer mirror coverm weatherstrip blackout tape | new | 21673 | 57.05
2011-11-21 00:00:00 |  |  | deductable |  |  |  |  | 250
Spreadsheet: 850540d1700908284-textjoin-formula-with-2-expetions-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fish | 0 | 0 | 0 | 0 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | [NAME] | 0 | Gluten | 0 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 0 | Gluten | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | [NAME] | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 108999d1305907771-indexing-to-compare-against-two-columns-example
Sheet: Sheet1

System List |  |  | Database List
User ID | Role |  | User ID | Role
JDOE | User |  | JDOE | Sales
JDOE | Sales |  | JDOE | User
SSMITH | Sales |  | SSMITH | Sales
SSMITH | Manager |  | SSMITH | Super User
SSMITH | Finance |  | SSMITH | User
SSMITH | User |  | SSMITH | Finance
ABROWN | User |  | ABSMITH | User
ABSMITH | Finance |  | ABSMITH | Finance
ABSMITH | User |  | ABSMITH | Manager
Spreadsheet: 797742d1664118994-formula-for-finding-and-matching-values-problem-test-sheet
Sheet: Tracker

Batting Position | Count | Sum
B1
B2
B3
B4
B5
B6
B7
B8
B9
10
11
C1
C2
[NAME]
C4
C5
C6
C7
C8
C9
C10
C11
Spreadsheet: 695689d1600347305-averageifs-div-0-averageifs
Sheet: Sheet1

Town | Name | Prodnr | Revenue 1 | Amount
S | Cardamom | P1 | R1 | 5
S | Cardamom | P1 | R1 | 8
S | Cardamom | P1 | R1 | 6
S | Betel nut | P1 | R1 | 0
L | Betel nut | P1 | R1 | 5
L | [NAME] | P1 | R1 | 4
L | [NAME] | P1 | R1 | 0
L | [NAME] | P1 | R1 | 8
B | [NAME] | P1 | R1 | 9
B | Cardamom | P1 | R1 | 3
B | Cardamom | P1 | R1 | 7
S | Cardamom | P2 | R2 | 7
S | Cardamom | P2 | R2 | 8
S | Cardamom | P2 | R2 | 0
S | Cardamom | P2 | R2 | 9
L | Cardamom | P2 | R2 | 6
L | Cardamom | P2 | R2 | 3
L | [NAME] | P2 | R2 | 2
L | [NAME] | P2 | R2 | 1
B | [NAME] | P2 | R2 | 4
B | [NAME] | P2 | R2 | 7
B | [NAME] | P2 | R2 | 8
Spreadsheet: 93747d1293518845-match-function-copy-of-sample
Sheet: Sheet1

PCP | 2009 Members | 2010 Members | Members in 2009 not in 2010 |  | match
[NAME] | [NAME] | [NAME] | #N/A |  | 6
 | [NAME] | Tomore Sick | #N/A |  | 7
 | [NAME] | [NAME] | #N/A |  | 8
 | Sunny Tute | [NAME] | #N/A |  | 9
 | [NAME] | [NAME] | #N/A |  | #N/A | [NAME]
 | [NAME] | [NAME] | #N/A |  | #N/A | [NAME]
 | Walt Disney | [NAME] | #N/A |  | #N/A | Walt Disney
 | [NAME] | [NAME] | #N/A |  | #N/A | [NAME]
 | Lacy [NAME] | Sunny Tute | #N/A |  | #N/A | Lacy [NAME]
Spreadsheet: 768fa7c3-8616-431b-8166-f8f6f67152d6
Sheet: Sheet1

Depression Among High School and Middle School Students, by Selected Demographics, Maine, 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | High School |  |  |  | Middle School
 |  | weighted number |  | % | 95% CI | weighted number |  | % | 95% CI
Total |  | 13048 |  | 22.7 | 21.7 - 23.6 | 5999 |  | 21.8 | 20.1 - 23.4
Gender
 | Male | 5024 |  | 17.4 | 16.5 - 18.3 | 2286 |  | 16.3 | 14.5 - 18.1
 | Female | 7829 |  | 28 | 26.7 - 29.3 | 3677 |  | 27.6 | 25.4 - 29.8
Race **
 | American Indian or [NAME] | 192 |  | 31.8 | 28.7 - 34.8 | 113 |  | 25.2 | 19.2 - 31.3
 | Asian | 152 |  | 23.4 | 19.8 - 26.9 | 36 |  | 18.6 | 9.5 - 27.7
 | Black or African American | 177 |  | 25 | 21.3 - 28.8 | 57 |  | 29.4 | 17.0 - 41.9
 | Hispanic | 380 |  | 33.5 | 31.0 - 36.1 | 147 |  | 33.9 | 28.5 - 39.2
 | Native Hawaiian or Other Pacific islander | 42 |  | 32.4 | 24.7 - 40.2 | 8 |  | 22.7 | 6.6 - 38.8
 | White | 11096 |  | 22 | 21.0 - 23.0 | 4803 |  | 20.8 | 19.1 - 22.4
 | Multiple races | 235 |  | 31.1 | 28.0 - 34.2 | 143 |  | 29.9 | 24.9 - 35.0
Sexual Orientation
 | Heterosexual | 10497 |  | 20.2 | 19.3 - 21.1
 | Gay/Lesbian | 414 |  | 48.6 | 43.5 - 53.7
 | Bisexual | 1310 |  | 55.9 | 53.1 - 58.7
 | Not Sure | 606 |  | 36.9 | 33.7 - 40.1
Data Source:  Maine Integrated Youth Health Survey. Middle school Survey includes 7th and 8th grades. Based on students who reported that they felt sad or hopeless almost every day for 2 or more weeks and stopped doing some usual activities All percentagess are weighted to be more representative of the population of Maine students and to adjust for non-response.  95% CI = 95% Confidence Interval. NA = not available.  Sexual orientation is not asked in the middle school survey ** All racial categories are non-Hispanic except for "Hispanic."
Spreadsheet: 599342d1542978202-roulette-analysis-r-ana
Sheet: Sheet1

13 |  | 21
29 |  | 26
32 |  | 28
6 |  | 29
3
25
21
26
35
4
9
16
19
5
7
5
27
32
19
28
25
34
21
28
26
12
6
6
13
13
27
1
5
20
3
18
11
0
14
22
20
17
21
29
35
22
10
2
1
16
8
19
10
Spreadsheet: 66841d1267533355-sum-with-various-criteria-copy-of-access-sheet
Sheet: Mar

MONTH / YEAR |  |  |  |  |  |  | DEPT CODE
NAME |  |  |  |  |  |  | REP CODE
CURRENCY |  |  |  |  |  |  | TRANSACTION TYPE*
RECEIPT Nº | CODE | DEPT | REP | [NAME] |  |  |  | AMOUNT |  |  |  | SUB TOTAL | VAT |  |  | SUB TOTAL | TOTAL
 |  |  |  |  |  |  |  | 21 | 13.5 | 17.5 | ZERO |  | 21 | 13.5 | 17.5
1 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
2 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
3 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
4 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
5 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
6 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
7 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
8 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
9 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
10 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
11 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
12 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
13 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
14 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
15 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
16 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
17 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
18 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
19 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
20 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
21 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
22 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
23 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
24 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
25 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
26 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
27 | 6230 | SM |  | Purchases |  |  |  |  |  | 3 |  | 3 |  |  |  | 0 | 3
28 | 6230 | SI |  | Purchases |  |  |  |  |  | 2 |  | 2 |  |  |  | 0 | 2
29 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
30 |  |  |  | - |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
TOTAL |  |  |  |  |  |  |  | 0 | 0 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 5
 |  |  |  |  |  |  |  | 5 |  |  |  |  | 0
SUMMARY
CODE | DEPT | REP | [NAME] |  | VATABLE | ZERO | VAT | TOTAL
6230 | SM |  | Purchases |  | 3 | 0 | 0 | 3
6230 | SM |  | Purchases |  | #N/A | 0 | 0 | 0
 |  |  | - |  | 0.00 | 0 | 0 | 0
 |  |  | - |  | 0.00 | 0 | 0 | 0
 |  |  | - |  | 0.00 | 0 | 0 | 0
 |  |  | - |  | 0.00 | 0 | 0 | 0
 |  |  | - |  | 0.00 | 0 | 0 | 0
 |  |  | - |  | 0.00 | 0 | 0 | 0
 |  |  | - |  | 0.00 | 0 | 0 | 0
TOTAL |  |  |  |  | #N/A | 0 | 0 | 3
CHECK |  |  |  |  | #N/A | P | P | O
Spreadsheet: 170718d1343379226-multiple-unique-counts-depending-on-other-columns-automation-test
Sheet: Summary

Category | Incident | Count | Unique Count |  |  |  | title | Count | Unique Count
DR | Case1 | 5 | 4 |  |  |  | 11
DR | Case2 | 6 | 3 |  |  |  | 12
FG | Case1 | 2 | 1 |  |  |  | 14
FG | Case2 | 1 | 1 |  |  |  | 13
 |  |  |  |  |  |  | 11
Spreadsheet: 887395d1737636801-highlight-the-cells-with-different-day-and-months-after-looking-at-the-day-and-month-in-row-highlight-the-cells-with-different-day-and-months-after-looking-at-all-the-day-and-month-in-the-row
Sheet: Sheet4

Unique ID | Forename | Audiometry Remote | [NAME] | HAVS T2 | HAVS T2 Remote | Nightworker | Nightworker Remote | Respiratory Remote | [NAME] | Safety Critical | Skin Remote | [NAME] |  | Oldest Dates
89421 | [NAME] | 2027-03-27 00:00:00 |  |  | 2029-03-27 00:00:00 |  |  |  |  |  | 2027-03-27 00:00:00 | 2027-03-27 00:00:00 |  | 2027-03-27 00:00:00
101534 | [NAME] | 2029-03-27 00:00:00 |  |  | 2028-03-28 00:00:00 |  |  |  |  |  | 2029-03-27 00:00:00 | 2029-03-27 00:00:00 |  | 2028-03-28 00:00:00
216662 | [NAME] |  | 2024-10-10 00:00:00 | 1984-10-11 00:00:00 |  |  |  |  | 2024-10-10 00:00:00 | 2024-10-10 00:00:00 |  | 2024-10-10 00:00:00 |  | 1984-10-11 00:00:00
229973 | [NAME] | 2024-05-23 00:00:00 |  | 2024-03-04 00:00:00 |  |  |  | 2024-05-23 00:00:00 |  |  |  | 2024-03-04 00:00:00
230044 | [NAME] | 2024-11-03 00:00:00 |  | 2024-03-04 00:00:00 |  |  |  | 2024-11-03 00:00:00 |  |  |  | 2024-03-04 00:00:00
231184 | Julian |  | 2024-11-21 00:00:00 | 2024-11-21 00:00:00 |  |  |  |  | 2024-11-21 00:00:00 | 2024-11-21 00:00:00 |  | 2024-11-21 00:00:00
254346 | [NAME] |  | 2024-04-11 00:00:00 | 2024-04-11 00:00:00 |  |  |  |  | 2024-04-11 00:00:00 | 2024-04-11 00:00:00 |  | 2024-04-11 00:00:00
405221 | [NAME] |  | 2025-02-05 00:00:00 | 2025-02-05 00:00:00 |  |  |  |  | 2025-02-05 00:00:00 |  |  | 2025-02-05 00:00:00
422440 | Wayne |  | 2025-02-09 00:00:00 | 2025-02-09 00:00:00 |  | 2024-03-04 00:00:00 |  |  | 2025-02-09 00:00:00 | 2025-02-09 00:00:00 |  | 2025-02-09 00:00:00
785250 | [NAME] | 2024-04-24 00:00:00 |  | 2024-04-24 00:00:00 |  |  |  | 2024-04-02 00:00:00 |  |  |  | 2024-04-24 00:00:00
817780 | [NAME] | 2022-08-31 00:00:00 |  | 2024-03-04 00:00:00 |  |  |  | 2022-08-31 00:00:00 |  |  |  | 2024-03-04 00:00:00
817791 | Stuart | 2025-01-04 00:00:00 |  | 2024-03-04 00:00:00 |  |  |  | 2025-01-04 00:00:00 |  |  |  | 2024-03-04 00:00:00
817818 | [NAME] |  | 2025-01-10 00:00:00 | 2025-01-10 00:00:00 |  |  |  |  | 2025-01-10 00:00:00 | 2025-01-10 00:00:00 |  | 2025-01-10 00:00:00
831779 | [NAME] |  | 2024-07-25 00:00:00 | 2024-03-04 00:00:00 |  |  |  | 2024-03-04 00:00:00 |  |  |  | 2024-07-25 00:00:00
831792 | [NAME] | 2024-04-21 00:00:00 |  | 2024-03-04 00:00:00 |  |  |  | 2024-04-21 00:00:00 |  |  |  | 2024-03-04 00:00:00
831807 | Alistair |  | 2024-07-06 00:00:00 | 2024-07-06 00:00:00 |  |  |  |  | 2024-07-06 00:00:00 |  |  | 2024-07-06 00:00:00
831819 | Adrian | 2024-06-15 00:00:00 |  | 2024-03-04 00:00:00 |  | 2024-03-04 00:00:00 |  | 2024-06-15 00:00:00 |  |  |  | 2024-03-04 00:00:00
836576 | [NAME] |  | 2024-06-01 00:00:00 | 2024-06-01 00:00:00 |  | 2024-06-01 00:00:00 |  |  | 2024-06-01 00:00:00 | 2024-06-01 00:00:00 |  | 2024-06-01 00:00:00
836588 | [NAME] |  | 2025-02-22 00:00:00 | 2025-02-22 00:00:00 |  | 2025-02-22 00:00:00 |  |  | 2025-02-22 00:00:00 | 2025-02-22 00:00:00 |  | 2025-02-22 00:00:00
Spreadsheet: 64335d1265201538-using-arrays-with-if-and-and-sample-array-problem
Sheet: Sheet1

 |  |  | 2 | 5 | 8 | 11 | 14 | 17
 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  |  | 0
 |  |  | 1 | 2 | 3 | 4 | 0 | 0
 |  |  | 0 | 0 | 3 | 4 | 5 | 6
 |  |  | 4
 |  |  | 6
Spreadsheet: 754247d1636042709-formatting-data-of-an-auto-populating-calendar-workbook-ef1554b_calendar_date_range
Sheet: Calendar

 |  |  | Metal Production
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1 |  |  |  |  |  |  |  |  | Month | 11 |  | <== Enter MONTH - 1 to 12
2 |  |  |  |  |  |  |  |  | Year | 2021 |  | <== Enter YEAR - 2018 to 2030
3
4
5
6
7
8
9
10
 |  |  |  |  |  |  |  |  |  | KEY:
1 |  |  |  |  |  |  |  |  |  | Alonzo
2 |  |  |  |  |  |  |  |  |  | Chepe
3 |  |  |  |  |  |  |  |  |  | Chepe C
4 |  |  |  |  |  |  |  |  |  | [NAME]
5 |  |  |  |  |  |  |  |  |  | [NAME]
6 |  |  |  |  |  |  |  |  |  | [NAME]
7 |  |  |  |  |  |  |  |  |  | Merlin
8 |  |  |  |  |  |  |  |  |  | [NAME]
9 |  |  |  |  |  |  |  |  |  | Rona
10 |  |  |  |  |  |  |  |  |  | Walter
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 140036d1328603450-nested-if-statement-with-multiple-tests-0101
Sheet: Whos Coming

Overview
# of Days | 5
# of People | 6
Boat | The Voyager
Deposit | 600
Per Person | 230.625
Details
Boat Rental | 0 |  | 4254.1065
Groceries | 450
Alcohol | 783.75
[NAME]. | 150
Total | 1383.75
Who's Coming?
Name | [NAME] | Yes/No | Deposit | Paid | Notes
 |  | Yes
 |  | Yes
 |  | Yes
 |  | Yes
 |  | Yes
 |  | Yes
Spreadsheet: 762795d1641823849-how-to-ignore-blanks-with-index-and-how-to-combine-and-consolidate-data-testplanner
Sheet: Lunch

 | Meal | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | U | C
1 | Out
2 | Ham sandwich | Bread | Ham
3 | Cheese sandwhich | Bread | Cheese
4 | Soup | Soup | Bread roll
5 | Chicken salad | Chicken | Salad
6 | Pate on toast | Bread | Pate
Spreadsheet: 831429d1685626873-need-help-with-counting-cells-for-time-sheet-test-time-sheet
Sheet: Sheet1

 |  | DATE: |  |  |  |  |  |  |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTES:
 |  | A shift week one |  |  |  |  |  |  |  |  |  |  | A shift week two
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | these two collums add week one and week two ST and OT cells
 | Name | M | T | W | T | F | S | S | Total Hrs. | ST | OT |  | M | T | W | T | F | S | S | Total Hrs. | ST | OT | total ST | total OT | DT | Hol | Vac | Berv
 | Bell, Fraa | 16 | 12 | 12 | 11 |  |  |  |  |  |  |  | 12 | 12 | 12 | 12
 |  | 12 | 12 | 12 | 12 |  |  |  |  |  |  |  | 0 | 0 | 12 | 12 |  |  | 12
 | Bell, Fraa | 14 | 12 | 12 | 11 |  | 12 |  |  |  |  |  | 0 | 12 | 12 | 16
 |  |  |  |  |  |  |  |  |  |  | This collum  I need to add M-T any number over 12 and F-S |  |  |  |  |  |  |  |  |  |  | This collum  I need to add M-T any number over 12 and F-S
 |  | False | False | False |  | this adds total hrs for the week
 |  |  |  |  |  |  |  |  |  | This collum I need to add up to 40 hours M-T |  |  |  |  |  |  |  |  |  |  | This collum I need to add up to 40 hours M-T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 12 | 12
 |  |  |  |  |  |  |  | cells ST should add M-T 12 hrs only a day to 40 and stops
 |  |  |  |  |  |  |  | then cell OT adds M-T anything over 12 plus any hours F-S
 |  |  |  |  |  |  |  | I have no idea how to make ST and OT collum work???