tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0f0ad938-56c8-4462-b8bc-8f292ca48fc1
Sheet: Disabilities Codes

 |  | SFY 2013 STATE CODE SHEET
SFY 2013 STATE EDRS-UFARS codes crosswalk
UFARS Program Code to EDRS Disability Code
UFARS PROGRAM CODE | EDRS DISABILITY CODE | [NAME]
401 | 401 | Speech or Language Impairments
402 | 402 | Developmental Cognitive Disability - Mild -Moderate
403 | 403 | Developmental Cognitive Disability - Severe-Profound
404 | 404 | Physically Impaired
405 | 405 | Deaf and Hard of Hearing
406 | 406 | Visually Impaired
407 | 407 | Specific Learning Disability
408 | 408 | Emotional or Behavioral Disorders
409 | 409 | Deaf-Blind
410 | 410 | Other Health Disabilities
411 | 411 | Autism Spectrum Disorders
412 | 412 | Developmentally Delayed
414 | 414 | Traumatic Brian Injury
416 | 416 | Severely Multiply Impaired
420 | 420 | Special Education - Aggregate (3 or more Disabilities)
422 | 422 | Non-Disabled (no IEP/IFSP/IIIP) (use FSC C and FSC N only)
Spreadsheet: 0631d7b6-9649-410f-8baf-7baf5f9d96bf
Sheet: +60 Seeding List

 |  |  |  | Revised Seeding List updated 28 Aug
60+ MS (49)
No | Member ID | LastName | FirstName | Country | Gender | Seed
1 | 86591 | MIRANDA | [NAME] | IND | M | 1
2 | 58209 | OSTHASSEL | Terje  Dag | NOR | M | 2
3 | 50074 | HANSEN | Christian | DEN | M | 3/4
4 | 5083 | PAYNTER | [NAME] | CAN | M | 3/4
5 | 89392 | ROBINSON | [NAME] | ENG | M | 5/8
6 | 2770 | EMPTAGE | [NAME] | ENG | M | 5/8
 | 94140 | WOON | [NAME] | MAS | M |  | withdrawn
7 | 65347 | INGEDAHL | Curt | SWE | M | 5/8
8 | 52508 | CHERNIK | Oleg | RUS | M | 5/8
60+ WS (21)
No | Member ID | LastName | FirstName | Country | Gender | Seed
1 | 91532 | NIELSEN | Jette | DEN | F | 1
2 | 92602 | HAVELAAR | Jessy, [NAME] | NED | F | 2
3 | 88181 | WENGBERG | Lieselotte | SWE | F | 3/4
4 | 59205 | YAMAMOTO | Mieko | JPN | F | 3/4
60+ MD (32) |  |  |  |  |  |  |  | Updated 28 Aug
No | Member ID 1 | Member ID 2 | Lastname 1 | Firstname 1 | Lastname 2 | Firstname 2 | Country 1 | Country 2 | Seed
1 | 52420 | 84122 | HAMBLETT | [NAME] | HOLT | [NAME] | ENG | ENG | 1
2 | 62649 | 61590 | FAHRENHOLZ | Henrik | JESPEN | [NAME] | DEN | DEN | 2
3 | 89392 | 2770 | ROBINSON | [NAME] | EMPTAGE | [NAME] | ENG | ENG | 3/4
4 | 72038 | 94140 | ONG | [NAME] | WOON | [NAME] | MAS | MAS |  | withdrawn
4 | 50074 | 77892 | HANSEN | Christian | GJELSTRUP | Arne | DEN | DEN | 3/4
5 | 90310 | 98294 | YAMAMOTO | Hideo | MIYAMOTO | Katsuhiro | JPN | JPN | 5/8
6 | 97981 | 71999 | TOSHIJIMA | [NAME] | FURUHASHI | Masaki | JPN | JPN | 5/8
7 | 58209 | 58494 | OSTHASSEL | Terje  Dag | DABELSTEEN | Per | NOR | DEN | 5/8
8 | 65347 | 52392 | INGEDAHL | Curt | WINNBERG | Lars | SWE | SWE | 5/8
60+ WD (13)
No | Member ID 1 | Member ID 2 | Lastname 1 | Firstname 1 | Lastname 2 | Firstname 2 | Country 1 | Country 2 | Gender 1 | Gender 2 | Seed
1 | 91532 | 89552 | NIELSEN | Jette | RASMUSSEN | [NAME] | DEN | DEN | F | F | 1
2 | 61054 | 52534 | CREASEY | [NAME] | BARTLETT | Betty | ENG | ENG | F | F | 2
60+ XD (30)
No | Member ID 1 | Member ID 2 | Lastname 1 | Firstname 1 | Lastname 2 | Firstname 2 | Country 1 | Country 2 | Gender 1 | Gender 2 | Seed
1 | 2770 | 52534 | EMPTAGE | [NAME] | BARTLETT | Betty | ENG | ENG | M | F | 1
2 | 89552 | 50074 | RASMUSSEN | [NAME] | HANSEN | Christian | DEN | DEN | F | M | 2
3 | 52420 | 70164 | HAMBLETT | [NAME] | HURST | [NAME] | ENG | ENG | M | F | 3/4
4 | 84122 | 73004 | HOLT | [NAME] | WITTY | Margo Jane | ENG | ENG | M | F | 3/4
Spreadsheet: 67130d1267730457-excel-2007-excel-two-category-multi-data-stacked-chart-pt-2003
Sheet: Pivot

 |  | Data
Month | Type | Sum of A | Sum of B | Sum of C
1 | Actual | 19 | 19 | 11
 | Planned | 18 | 19 | 13
1 Total |  | 37 | 38 | 24
2 | Actual | 16 | 12 | 13
 | Planned | 15 | 16 | 16
2 Total |  | 31 | 28 | 29
3 | Actual | 10 | 14 | 15
 | Planned | 12 | 11 | 14
3 Total |  | 22 | 25 | 29
4 | Actual | 17 | 13 | 15
 | Planned | 12 | 19 | 10
4 Total |  | 29 | 32 | 25
5 | Actual | 17 | 17 | 15
 | Planned | 16 | 16 | 16
5 Total |  | 33 | 33 | 31
6 | Actual | 16 | 18 | 20
 | Planned | 10 | 17 | 10
6 Total |  | 26 | 35 | 30
7 | Actual | 16 | 10 | 12
 | Planned | 13 | 18 | 18
7 Total |  | 29 | 28 | 30
8 | Actual | 12 | 14 | 14
 | Planned | 11 | 12 | 20
8 Total |  | 23 | 26 | 34
9 | Actual | 11 | 17 | 18
 | Planned | 20 | 12 | 10
9 Total |  | 31 | 29 | 28
10 | Actual | 18 | 10 | 15
 | Planned | 10 | 10 | 14
10 Total |  | 28 | 20 | 29
11 | Actual | 19 | 16 | 17
 | Planned | 17 | 12 | 17
11 Total |  | 36 | 28 | 34
12 | Actual | 12 | 18 | 10
 | Planned | 19 | 17 | 11
12 Total |  | 31 | 35 | 21
Grand Total |  | 356 | 357 | 344
Spreadsheet: 845270d1696802024-show-a-list-of-values-from-one-column-with-a-value-match-in-another-column-copy-of-copy-of-show-a-list-of-values-from-one-column-with-a-value-match-in-another-column-v6
Sheet: Sheet1

Store | Apple | Pear | Orange | [NAME] | Lemon | Kiwi | Duran
Wal-Mart | Yes | No | No | Yes | Yes | No | No
Target | Yes | Yes | Yes | No | No | No | No
Kroger | No | No | Yes | No | Yes | Yes | Yes
Aldi | Yes | No | Yes | Yes | Yes | Yes | No
[NAME]'s | Yes | Yes | No | Yes | No | No | Yes
Item | Pear | Duran
Store
 | Yes | No
 | No | Yes
 | No | No
 | Yes | Yes
Spreadsheet: 99124d1297867297-autopopulate-using-a-dropdown-menu-vendortemplate
Sheet: Sheet1

Voucher
 |  | VENDOR EXPENSE VOUCHER |  |  |  | PAY METHOD: | ACH (           )   Credit Card (            )  Check (            )  Wire (            )
 |  |  |  |  |  | (A/P Use only)
VENDOR NUMBER: |  |  | PAY ENTITY: |  |  | P.O. #:
 |  |  | (A/P Use only)
VENDOR NAME: | X |  |  |  |  | PROJECT#: |  |  |  | TASK #:
( "Please use the REMIT TO NAME on Invoice")
PURPOSE OF EXPENSE: | X |  |  |  |  | EXPENSE TYPE: |  |  |  | EXPENSE ORG:
REMIT COMMENTS: | X |  |  |  |  | F/A DESC.
 |  |  |  |  |  | (For [NAME]. Exp. Only) | Major    -   Minor    -   Center   -  Prod/Cust    -   Location
Invoice | Invoice | Invoice | Distribution | Distribution | Distribution | Distribution | Prod/Cust | Future | InterCo | Distribution | Employee | Analysis | Tax
Number | Date | Amount | Entity | GL Account | Cost Center | Location | Code | Code | Code | Amount | Number | Code | Code
0216110 | 2011-02-16 00:00:00 | 0 | 0 | 0 | 000000 | 00 | 00000 | 000 | 000 | 0
 |  |  | 0 | 0 | 000000 | 00 | 00000 | 000 | 000 | 0
X
X
X
X
X
X
 | Vouch Total: | 0 |  |  |  |  |  | Dist Total: |  | 0
 |  |  | 1) |  |  |  | 3)
Prepared by: | Date: |  | Department Approval |  | Date |  | Leadership Committee |  |  |  |  | Date
 |  |  |  |  |  |  | 4)
 |  |  | 2) |  |  |  | Executive Committee |  |  |  |  | Date
 |  |  | Department Approval |  | Date
 |  |  |  |  |  |  | 5)
 |  |  |  |  |  |  | Finance Review Sign-off |  |  |  |  | Date
Accounts Payable CANNOT accept handwritten vouchers, please type.  Questions regarding this form, please call the A/P Supv.
Spreadsheet: 134597d1325506038-add-up-col-add
Sheet: Sheet1

 | 61.8 |  | 61.8
10.1 |  | 10.1
$6.4
$7.8
$1.9
$12.3
$3.3
$2.6
12.7 |  | 12.7
$9.5
$2.1
9.7 |  | 9.7
$24.1
$3.2
$2.4
$7.6
$4.0
$4.1
$8.6
$20.4
$4.2
$6.3
$22.0
$11.5
$1.9
$11.5
3.4 |  | 3.4
$14.6
4.5 |  | 4.5
$3.7
$6.9
$12.2
$2.6
$5.8
$1.8
$5.2
$1.8
$2.4
$1.9
$4.3
$5.8
$6.9
$2.7
$14.7
$58.1
$6.0
$12.6
$4.8
$3.7
$10.0
3.3 |  | 3.3
$9.1
$15.8
$13.2
$5.4
$3.3
$4.6
$7.8
$3.5
3.5 |  | 3.5
$12.8
$3.6
$6.2
$5.1
$34.5
$31.9
$1.0
14.6 |  | 14.6
$4.1
$6.2
$12.7
$10.2
0
$7.3
$3.6
$2.2
$7.7
Spreadsheet: ffc10450-8fd1-482b-be7a-463c6bd8da74
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: December 21, 2014 (6:27 am)
Period | Value
Jan-2008
Feb-2008
Mar-2008
Apr-2008
May-2008
Jun-2008
Jul-2008
Aug-2008
Sep-2008
Oct-2008
Nov-2008
Dec-2008
Jan-2009
Feb-2009
Mar-2009
Apr-2009
May-2009
Jun-2009
Jul-2009
Aug-2009
Sep-2009
Oct-2009
Nov-2009
Dec-2009
[NAME]
[NAME]
Mar-2010
Apr-2010
[NAME]
[NAME]
[NAME]
Aug-2010
Sep-2010
Oct-2010
Nov-2010
Dec-2010
Jan-2011
Feb-2011
Mar-2011
Apr-2011
May-2011
Jun-2011
Jul-2011
Aug-2011
Sep-2011
Oct-2011
Nov-2011
Dec-2011
Jan-2012
Feb-2012
Mar-2012
Apr-2012
May-2012
Jun-2012
Jul-2012
Aug-2012
Sep-2012
Oct-2012
Nov-2012
Dec-2012
Spreadsheet: 789889d1659428492-insert-real-time-currency-exchange-rates-in-excel-2019-exchange-rates-usd-to-eur-aligw
Sheet: Handy Conversion Data Table

Dollars to Euros | Dollars to Euros2 | Euros to Dollars | Euros to Dollars2
1 USD | 0.9784 EUR | 1 EUR | 1.0221 USD
2 USD | 1.9567 EUR | 2 EUR | 2.0443 USD
5 USD | 4.8918 EUR | 5 EUR | 5.1106 USD
10 USD | 9.7835 EUR | 10 EUR | 10.2213 USD
15 USD | 14.6753 EUR | 15 EUR | 15.3319 USD
20 USD | 19.567 EUR | 20 EUR | 20.4426 USD
25 USD | 24.4588 EUR | 25 EUR | 25.5532 USD
50 USD | 48.9175 EUR | 50 EUR | 51.1064 USD
100 USD | 97.8351 EUR | 100 EUR | 102.2128 USD
500 USD | 489.1755 EUR | 500 EUR | 511.064 USD
1000 USD | 978.351 EUR | 1000 EUR | 1022.1281 USD
2500 USD | 2445.8775 EUR | 2500 EUR | 2555.3201 USD
5000 USD | 4891.755 EUR | 5000 EUR | 5110.6403 USD
10000 USD | 9783.51 EUR | 10000 EUR | 10221.2805 USD
Spreadsheet: mary_fischer__25633__31P
Sheet: E11.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031P
COMPANY NAME    Limbach Holdings, Inc.
ANALYSIS OF OTHER CURRENT LIABILITIES
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-11
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Accrued Job reserves |  | -3888000 |  | 0 |  |  |  | 0
Worker's comp (remapped to acct 620) |  | 1402500 |  | -1402500
Total Other Current Liabilities
(must tie to Hyperion account 655) | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Income Accts:  DR/(CR)
Reverse signs from Hyperion
Spreadsheet: 68341d1268857407-problem-creating-an-if-formula-data-sample-for-formula-problem
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
P1 |  | 33 |  |  |  | 12 | F5 | F4 | 1 | F4 |  |  | 2 | F5 | F4 |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 10 | 0 | 0 | 85 |  | 1 | 1.000000000000001
P2 | F7 |  | 27 | F4 | 14 |  |  |  |  |  | F4 | F6 |  |  |  | F5 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 5 | 6 | 7 | 70
P1 | F4 |  | 1 | 10 |  |  |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 | 47 |  | 1 | 2.000000000000002
P2 |  | 5 |  |  | 1 | 24 | F4 | F4 | F4 | 1 | F4 | F4 | F4 | F4 | F4 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 0 | 0 | 0 | 68
 | In Rows 2 and 3, I want a formula to ignore F7 in Cell B3 and find the first cell in a column which is numerical - in this example it is 33 in cell C2.
 | It should then look at the total in AJ2 and if that is greater than AJ3 it would return a Value of "1" or if it is smaller it would return a Value of "0".
 | Similarly in Rows 4 and 5, the formula needs to ignore the value of F4 in Cell B4 and find the value of 5 in cell C5. Then if AJ5 > AJ4 return "1" or "0"
 | if AJ4>AJ5.
P1 | F4 | F4 | F4 | F4 | F4 | 1 |  | 1 |  | 1 | 5 | 1 |  | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 0 | 0 | 0 | 66 | 0.9999999999999964 | 0
P2 |  |  |  |  |  |  | 33 |  | 4 |  |  |  | F4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 | 41
P1 | F4 | 4 | F4 | F4 | F4 | 1 |  | 1 |  | 1 | 5 | 1 |  | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 0 | 0 | 0 | 66 | 1.000000000000001 | 1
P2 |  |  |  |  |  |  | 33 |  | 4 |  |  |  | F4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 | 41
Spreadsheet: 115679d1311216994-excel-2007-conditional-formatting-delta-tracking-example
Sheet: Sheet1

Test | Throughput | Parameter 1 | Parameter 2 | Parameter 3 | Remarks
1 | 15 | 2G | 1024 | 8 | Baseline Test so nothing highlighted. Original state of the data
2 | 25 | 2G | 1024 | 8 | First change is in Throughput so it highlights.
3 | 25 | 2G | 2048 | 8 | Next change in Column D, so it highlights (unique colour per column for ease of reading. As B4 = B4 no highlight there
4 | 15 | 2G | 2048 | 8 | Throughput drops in B5 so highlight.
5 | 18 | 2G | 2048 | 8 | Throughput increases in B6 so highlight.
6 | 18 | 3G | 2048 | 8 | Parameter 1 changes in value from the established pattern so it highlights. B7 is the same as [NAME] so it doesn't.
7 | 18 | 3G | 2048 | 8 | Nothing changes so nothing is highlighted.
8 | 15 | 3G | 2048 | 8 | B9 throughput drops so highlighted.
9 | 15 | 3G | 2048 | 8 | Nothing changes so nothing is highlighted.
10 | 23 | 3G | 2048 | 16 | Throughput changes and Parameter 3 changes so highlighted.
Spreadsheet: 129381d1321564469-fill-cells-randomly-constraining-restricting-row-and-column-sum-prob_e
Sheet: Basic

WORD | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | TOTAL
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | THE SUM OF EACH ROW IS LESS THAN OR EQUAL TO 4
 | 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 | 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 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL
 | THE SUM OF EACH COLUMN IS LESS THAN OR EQUAL TO 28
"HAND-MADE" EXAMPLE:
WORD | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | TOTAL
 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 2 | 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
TOTAL
Spreadsheet: 756568d1637644506-nested-ifs-error-examplenest-1-
Sheet: Group Info

ID | Set |  | Set2 | PP | H | Scores | PP | H | Marks
12345 | AA |  | Fam |  |  | 0 |  |  | 0
54321 | CG |  | Fam |  |  | 0 |  |  | 0
15432 | CE |  | Fam |  |  | 48.66 |  |  | 82
25431 | FA |  | Fam |  |  | 62 |  |  | 80.5
35421 | OO |  | [NAME] |  |  | 75.09 |  |  | 78
45321 | RA |  | [NAME] |  |  | 73.66 |  |  | 0
35214 | TG |  | [NAME] |  |  | 62 |  |  | 80.5
25134 | CK |  | [NAME] |  |  | 59 |  |  | 87
Spreadsheet: 747185d1631273815-agent-state-vs-schedule-state-time-calculation-login-time-help
Sheet: DataList

 |  | [NAME] |  | Skill |  | [NAME]
 |  | Absent |  | C_CCC |  | Absent
 |  | Annual Full Unauth |  | C_HP |  | [NAME]
 |  | Annual Leave |  | C_KC_CORE |  | Annual Unauth - Half
 |  | Annual Leave Override |  | C_PreAuth |  | Break (15 min) (10:00 - 10:15)
 |  | COVID 19 Protocol |  | C_HIV/CIB |  | Break (15) 14:30
 |  | [NAME]. Unauth Full |  | C_BM_CORE |  | Break 2 15:30-15:415
 |  | Maternity Leave |  | C_BM_HIV/CIB/ONC |  | Break(15 min) 09:00 - 09:15
 |  | Paternity Leave |  | C_BM_PREAUTH |  | Break1
 |  | Payback |  | C_BM_SPEC |  | Break2
 |  | [NAME] |  |  |  | Break3
 |  | Study |  |  |  | Coaching
 |  | Study Leave |  |  |  | [NAME]. Unauth Full
 |  | Day Off |  |  |  | [NAME]. Unauth Half
 |  |  |  |  |  | Lunch (60 min) 12:15  - 13:15
 |  |  |  |  |  | Lunch (60 min) 13:15
 |  |  |  |  |  | Lunch (60) 11:15
 |  |  |  |  |  | Lunch (60) 12:45
 |  |  |  |  |  | [NAME] (30)
 |  |  |  |  |  | Lunch(30)
 |  |  |  |  |  | Lunch(45 Min) 12:30 - 13:15
 |  |  |  |  |  | Lunch(45)
 |  |  |  |  |  | [NAME])
 |  |  |  |  |  | Training
Spreadsheet: 58583d1258822472-need-help-making-excel-distribute-hours-differently-after-working-40-hours-correct-pay-worksheet
Sheet: Sheet1

Enter your hours worked in the light green cells
 |  | Worked | Call | Holiday | Vacation | Sick | Regular | Overtime | Dbl Time |  | Pay Period
Saturday |  | 13 |  |  |  |  | 8 | 4 | 1 |  | Enter the pay period start date
Sunday |  | 13 |  |  |  |  | 8 | 4 | 1
Monday |  | 12 |  |  |  |  | 8 | 4
Tuesday |  | 12 |  |  |  |  | 2 | 4 | 6
Wednesday |  | 12 |  |  |  |  | 0 | 4 | 8
Thursday |  | 12 |  |  |  |  | 0 | 4 | 8
Friday |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | Hourly Rates
Saturday |  |  |  |  |  |  | 0 |  |  |  | Enter your pay rates in the light green cells
Sunday |  |  |  |  |  |  | 0
Monday |  |  |  |  |  |  | 0 |  |  |  | Your Pay Rate
Tuesday |  |  |  |  |  |  | 0 |  |  |  | Regular |  | 10
Wednesday |  |  |  |  |  |  | 0 |  |  |  | Overtime |  | 15
Thursday |  |  |  |  |  |  | 0 |  |  |  | Double Time |  | 20
Friday |  |  |  |  |  |  | 0 |  |  |  | Call Hours |  | 2
Cumlative Hours |  | 74 | 0 | 0 | 0 | 0 | 26 | 24 | 24
Total Pay |  | N/A | 0 | 0 | 0 | 0 | 260 | 360 | 480
WA Grose |  | 1100 |  | [NAME] |  | 1100
Weighted Average |  | 14.86486486486486 |  | Total Hours Worked |  | 74
What You Were Paid |  |  |  |  |  |  | Overages & Shortages
Enter the total hours / dollars from your paycheck in the light green cells |  |  |  |  |  |  | Negative numbers means you were underpaid, positive means you were over paid
Regular |  |  |  |  |  |  | Regular |  | -26
Overtime |  |  |  |  |  |  | Overtime |  | -24
Doubletime |  |  |  |  |  |  | Doubletime |  | -24
CALL |  |  |  |  |  |  | CALL |  | 0
Vacation |  |  |  |  |  |  | Vacation |  | 0
Holiday |  |  |  |  |  |  | Holiday |  | 0
Sick |  |  |  |  |  |  | Sick |  | 0
Weighted Averg $ |  |  |  |  |  |  | Weighted Averg $ |  | -14.86486486486486
[NAME] |  |  |  |  |  |  | [NAME] |  | -1100
1
Spreadsheet: 838352d1690950290-splitting-days-across-a-range-allocating-nights-to-blocks
Sheet: Sheet1

Guest Name | [NAME] date | checkout date | total nights stayed | night block 1 | night block 2 | night block 3 | night block 4 | night block 5 | Nights allocated Check
 |  |  |  | 1 Jan to 15 Jan | 16 Jan to 31 Jan | 1 Feb to 15 Feb | 16 Feb to 28 Feb (or 29 Feb Leap yr) | 1 March to 15 March
J Bairstow | 2023-01-17 00:00:00 | 2023-01-18 00:00:00 |  |  | 1
S Smith | 2023-01-12 00:00:00 | 2023-01-19 00:00:00 |  | 4 | 3
[NAME] | 2023-01-10 00:00:00 | 2023-03-03 00:00:00 |  | 6 | 16 | 15 | 13 | 2
A Border | 2023-02-15 00:00:00 | 2023-02-16 00:00:00 |  |  |  | 1
Spreadsheet: 72048d1272733418-sum-if-cells-are-equal-ship
Sheet: Sheet1

 |  | box | weight |  | total
 |  | 1 | 41 |  | 41 | sample
 |  | 2 | 56 |  | 56 | sample
 |  | 3 | 67 |  | 103 | sample
 |  | 3 | 36 |  | "blank" | sample
 |  | 4 | 46 |  | 46 | sample
 |  | 5 | 57
 |  | 6 | 58
 |  | 6 | 79
 |  | 7 | 2
 |  | 8 | 45
 |  | 8 | 38
 |  | 9 | 26
Spreadsheet: 760025d1639925271-cant-get-index-match-to-populate-down-correctly-chris-book2-aligw
Sheet: Sheet1

taTaskActivitiesID_PK | wdWorkDay_FK | tTaskCode | taTaskNumber | taTaskStartTime | taTaskStopTime | taTaskTrips | taStandard
81190 | 74486 | 6 |  | 01:30:00 | 04:10:00 | 14 | 7.98000001907349
81191 | 74486 | 5 |  | 04:10:00 | 04:30:00 | 2 | 6.09999990463257
81192 | 74486 | 26 |  | 04:30:00 | 06:11:00 | 0 | 2.35999989509583
81193 | 74486 | 26 |  | 06:11:00 | 08:25:00 | 24 | 2.35999989509583
81194 | 74486 | 26 |  | 08:25:00 | 08:40:00 | 0 | 2.35999989509583
81195 | 74486 | 26 |  | 08:40:00 | 11:30:00 | 28 | 2.35999989509583
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: WTG inc

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -316 | -260
2 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -544 | -260
3 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -307 | -260
4 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -634 | -260
5 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -440 | -260
6 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -143 | -260
7 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -372 | -260
8 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -1467 | -260
9 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -54 | -260
10 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -671 | -260
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 |  |  |  |  |  |  |  |  |  |  |  |  | 28367.49
2001-12-10 00:00:00
CBS Volume
 |  |  | 10205
Spreadsheet: 105298d1302703276-counting-based-on-other-columns-subtotalsandcounts
Sheet: Sheet2

 |  |  |  | Sold via |  |  |  |  |  | Team
 | Team | members | Website | Telephone | Shop | Cables | Cartridges | Paper |  | Team A
 | Team D | 5 | 60 | 0 | 0 | 35 | 6 | 19 |  | Team B
 |  |  |  |  |  |  |  |  |  | Team C
 |  |  |  |  |  |  |  |  |  | Team E
 |  |  |  |  |  |  |  |  |  | Team D
Date | Team | Member? | Sold Via Website | Sold Via Telephone | Sold Via Shop | Cables | Cartridges | Paper
2011-01-01 00:00:00 | Team A | 1 | 0 | 0 | 1 | 1 | 0 | 0
2011-01-01 00:00:00 | Team B | 1 | 0 | 0 | 1 | 0 | 0 | 1
2011-01-01 00:00:00 | Team B | 2 | 28 | 0 | 0 | 17 | 2 | 8
2011-01-01 00:00:00 | Team B | 3 | 1 | 0 | 0 | 0 | 0 | 1
2011-01-01 00:00:00 | Team A | 2 | 7 | 0 | 0 | 4 | 0 | 3
2011-01-01 00:00:00 | Team C | 1 | 1 | 0 | 0 | 1 | 1 | 0
2011-01-01 00:00:00 | Team E | 1 | 12 | 0 | 0 | 7 | 3 | 6
2011-01-01 00:00:00 | Team D | 1 | 18 | 0 | 0 | 10 | 1 | 6
2011-01-01 00:00:00 | Team D | 2 | 1 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | Team D | 3 | 1 | 0 | 0 | 1 | 0 | 0
2011-01-02 00:00:00 | Team B | 4 | 0 | 0 | 1 | 0 | 0 | 0
2011-01-02 00:00:00 | Team B | 5 | 36 | 0 | 0 | 26 | 9 | 16
2011-01-02 00:00:00 | Team A | 3 | 12 | 0 | 0 | 8 | 2 | 1
2011-01-02 00:00:00 | Team C | 2 | 3 | 0 | 0 | 3 | 1 | 1
2011-01-02 00:00:00 | Team E | 2 | 19 | 0 | 0 | 17 | 3 | 6
2011-01-02 00:00:00 | Team D | 4 | 39 | 0 | 0 | 24 | 5 | 12
2011-01-02 00:00:00 | Team D | 5 | 1 | 0 | 0 | 0 | 0 | 1
Subtotals > | 5 | 5 | 60 | 0 | 0 | 35 | 6 | 19