tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 770582d1646162193-how-to-calculate-time-spend-on-a-task-vlook_up-sart-time_confirmedtimexlsx
Sheet: Waves

[NAME] | Queue | Wave | Whse Order Status | Created By | Created On | Created At | Processor | Resource | Start Date | Start Time | Confirmation Date | Confirmed Time
[PHONE] | FWDPICK | [PHONE] | C | FMESSIER | 2022-02-21 00:00:00 | 11:33:41 | [NAME] | W63 | 2022-02-22 00:00:00 | 07:32:48 | 2022-02-22 00:00:00 | 07:43:38
[PHONE] | FWDPICK | [PHONE] | C | FMESSIER | 2022-02-21 00:00:00 | 11:33:41 | [NAME] | W63 | 2022-02-22 00:00:00 | 07:45:18 | 2022-02-22 00:00:00 | 07:46:12
[PHONE] | FWDPICK | [PHONE] | C | FMESSIER | 2022-02-21 00:00:00 | 11:33:41 | [NAME] | W63 | 2022-02-22 00:00:00 | 07:46:57 | 2022-02-22 00:00:00 | 07:48:00
[PHONE] | FWDPICK | [PHONE] | C | FMESSIER | 2022-02-21 00:00:00 | 11:33:41 | [NAME] | W63 | 2022-02-22 00:00:00 | 07:48:09 | 2022-02-22 00:00:00 | 07:50:15
[PHONE] | FWDPICK | [PHONE] | C | FMESSIER | 2022-02-21 00:00:00 | 11:33:41 | [NAME] | W63 | 2022-02-22 00:00:00 | 07:51:17 | 2022-02-22 00:00:00 | 07:54:08
[PHONE] | FWDPICK | [PHONE] | C | FMESSIER | 2022-02-21 00:00:00 | 11:33:41 | [NAME] | W63 | 2022-02-22 00:00:00 | 07:54:14 | 2022-02-22 00:00:00 | 07:55:52
[PHONE] | FWDPICK | [PHONE] | C | FMESSIER | 2022-02-21 00:00:00 | 11:33:41 | [NAME] | W63 | 2022-02-22 00:00:00 | 07:56:49 | 2022-02-22 00:00:00 | 07:57:36
[PHONE] | FWDPICK | [PHONE] | C | FMESSIER | 2022-02-21 00:00:00 | 11:33:41 | [NAME] | W63 | 2022-02-22 00:00:00 | 07:58:13 | 2022-02-22 00:00:00 | 07:59:34
[PHONE] | FWDPICK | [PHONE] | C | MSIKHUMBUO | 2022-02-21 00:00:00 | 12:36:24 | CDUFOUR | W39 | 2022-02-22 00:00:00 | 07:46:43 | 2022-02-22 00:00:00 | 10:43:29
Spreadsheet: barry_tycholiz__846__NPC Inventory Valuation
Sheet: Sheet1

NewPower Storage Inventory Valuation
Pipeline Storage |  |  | Inventory as of:
Pipeline | LDC | Type | 2001-07-31 00:00:00 | 2001-08-31 00:00:00 | 2001-09-30 00:00:00 | 2001-10-31 00:00:00 | 2001-11-30 00:00:00 | 2001-12-31 00:00:00 | 2001-01-31 00:00:00 | 2001-02-28 00:00:00 | 2001-03-31 00:00:00
Columbia Gas | COH | FSS | 5243772 | 6138531 | 7066081 | 7338781 | 6604903 | 4403269 | 1834696 | 733879 | 0
Columbia Gas | COH (AES) | FSS | 685595 | 804415 | 927845 | 946834 | 696834 | 696834 | 696834 | 250000 | 0
Sonat | AGL | CSS | 612335 | 860335 | 1100335 | 1293235 | 1173000 | 763000 | 353000 | 50000 | 0
Transco | AGL | WSS | 265291 | 337867 | 410443 | 483019 | 438019 | 298019 | 153019 | 58019 | 0
Transco | AGL | ESS | 14700 | 18600 | 22500 | 25350 | 20280 | 15210 | 10140 | 5070 | 0
 |  | Sub-Total
LDC / Virtual Storage |  |  | Inventory as of:
LDC | Description | Type | 2001-07-31 00:00:00 | 2001-08-31 00:00:00 | 2001-09-30 00:00:00 | 2001-10-31 00:00:00 | 2001-11-30 00:00:00 | 2001-12-31 00:00:00 | 2001-01-31 00:00:00 | 2001-02-28 00:00:00 | 2001-03-31 00:00:00
AGL | Peaking | On-system | 314500 | 425500 | 518000 | 518000 | 483000 | 355000 | 195000 | 65000 | 0
AGL | PRS | On-System | 152567 | 202167 | 247167 | 293667 | 268667 | 172167 | 75667 | 25667 | 0
BG&E | Col. Gas | FSS | 32946 | 41546 | 46546 | 46546 | 43924 | 31624 | 18504 | 9648 | 0
BG&E | Dominion | GSS | 4873 | 6445 | 7966 | 9538 | 8998 | 6498 | 3862 | 2118 | 0
CG&E  (AES) | Imbalance | On-system | 28028 | 13303 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EOG  (AES) |  | On-system | 13152 | 16274 | 19309 | 21672 | 20588 | 14086 | 7584 | 2166 | 0
MichCon |  | On-system | 369499 | 378786 | 409868 | 393164 | 339741 | 243091 | 201131 | 137358 | 100595
Nipsco |  | On-system | 258836 | 312812 | 367412 | 390000 | 335400 | 241800 | 148200 | 54600 | 0
PNG  (AES) | Dominion | GSS | 222016 | 273110 | 322785 | 354719 | 301511 | 248303 | 159623 | 53207 | 0
PNG  (AES) |  | On-system | 152717 | 180145 | 195818 | 195818 | 186027 | 127282 | 68537 | 19582 | 0
WGL | Col. Gas | FSS | 75990 | 86990 | 97990 | 101990 | 86635 | 60254 | 31673 | 11892 | 0
WGL  (AES) | Col. Gas | FSS | 22988 | 20187 | 15410 | 15410 | 13098 | 9708 | 6318 | 2928 | 0
 |  | Sub-Total
 | Total  Volumes
 |  | Current NYMEX |  | 3.14 | 3.19 | 3.42 | 3.7 | 3.82 | 3.76 | 3.65
 |  | Value
 |  | Winter NYMEX
 |  | Value
Spreadsheet: 126075d1319509593-showing-ratio-percentage-on-an-excel-chart-bs-1-it-lab-
Sheet: Clients

Name | E-Mail | Phone Number
[NAME] | [EMAIL] | 044100218
Ard Gafurri | [EMAIL] | 044100210
[NAME] | [EMAIL] | 044100214
[NAME] | [EMAIL] | 044100215
Egzon Batusha | [EMAIL] | 044100209
Elion Gerguri | [EMAIL] | 044100212
Ferid Shpici | [EMAIL] | 044100225
[NAME] | [EMAIL] | 044100224
[NAME] | [EMAIL] | 044100211
Hanemshaje Muqiqi | [EMAIL] | 044100220
Ibish Kaqaniku | [EMAIL] | 044100204
[NAME] | [EMAIL] | 044100216
[NAME] | [EMAIL] | 044100202
[NAME] | [EMAIL] | 044100200
[NAME] | [EMAIL] | 044100222
Mazllum Krasniqi | [EMAIL] | 044100203
Mehmet [NAME] | [EMAIL] | 044100207
Naim Shaci | [EMAIL] | 044100219
[NAME] | [EMAIL] | 044100208
[NAME] | [EMAIL] | 044100213
[NAME] | [EMAIL] | 044100205
[NAME] | [EMAIL] | 044100206
[NAME] | [EMAIL] | 044100217
[NAME] | [EMAIL] | 044100221
Xhihad Rexhepi | [EMAIL] | 044100201
[NAME] | [EMAIL] | 044100223
Spreadsheet: 0d6363c7-a289-4ecf-8408-be30ae45c355
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | [NAME]: [NAME]
 | Nº registro: [NAME]
 | Campos Obligatorios |  |  |  |  | Campos opcionales
 | Requisitos para asegurar cámaras fotográficas
 | Nombre y Apellidos:
 | Direccion y codigo postal:
 | [NAME] Foro: |  |  |  |  | Nº Suscriptor:
 | DNI: |  |  |  |  | [NAME] de contacto:
 | Nº cuenta: |  |  |  |  | Mail:
 | CÁMARA |  |  | MODELO |  | Nº SERIE |  | IMPORTE
 | OBJETIVO |  |  | MODELO |  | Nº SERIE |  | IMPORTE
 | FLASH |  |  | MODELO |  | Nº SERIE |  | IMPORTE
 | ACCESORIOS |  |  | MODELO |  | REFERENCIA |  | IMPORTE (*)
 | (*) Nota: El importe minimo por accesorio debera ser de 150€
 | COBERTURAS (marcar con X):
 |  |  |  | ROBO
 |  |  |  | ROBO + ROTURAS
 | ÁMBITO TERRITORIAL (marcar con X):
 |  |  | España (Peninsula, Baleares, Canarias, Ceuta y Melilla) y Andorra
 |  |  | Union Europea
 | Nota: Para garantizar el pago en caso de robo es impresincibel adjuntar una foto con todo el equipo fotografico a asegurar y [NAME].
Spreadsheet: 823826d1680158080-listing-the-winner-s-of-a-golf-skin-in-separate-cell-money-hole-formula-aligw
Sheet: Sheet2

Player | CC |  | TL |  | CR |  | SH |  |  | WINNERS OF CC |  |  |  |  | AliGW
A | 5 |  |  |  | 5 |  | 5 |  |  | B | C | D | F |  |  | C | D | F
B
C
D
E | 5
F | 3
G | 5
As you can see above, the winners for Round 1 (column B) were players B, C, D, and F because they all have a score less than a "4". I would love a formula that automatically places them under WINNERS over on the right.
Spreadsheet: 77933d1278424741-matching-data-and-multiple-if-statements-multiple-if-
Sheet: Sheet1

Code A | Code A- Target Not Target | Code B
23232 | Yes | 8934
3424 | No | 23477
345456 | Yes | 43334
34565 | Yes | 477394
9005 | Yes | 23232
2456 | No | 3424
8989 | Yes | 345456
345660 | No | 34565
34558 | No | 9005
8547547 | Yes | 2456
453634 | No | 8547547
8934234 | Yes | 453634
Spreadsheet: 746726d1630983337-problems-with-dataset-index-formula-sheet1
Sheet: Ark1

Storename | Product |  | Storename | 1 | 2 | 3 | 4 | 5
Foodstore 1 | Apple |  |  |  | Pear | [NAME] | Lemon
Foodstore 1 | Pear |  | Foodstore 2 |  | Blueberry
Foodstore 1 | [NAME]
Foodstore 1 | Lemon
Foodstore 2 | Grass
Foodstore 2 | Blueberry
Spreadsheet: 695220d1600101334-staff-absence-tracker-showing-number-of-days-and-number-of-occasions-sample-workbook
Sheet: Sheet1

SICKNESS RECORDS |  |  |  |  | SUMMARY
EMPLOYEE NAME | START DATE | END DATE | TOTAL DAYS BY OCCASION |  |  | TOTAL DAYS (LAST 6 MONTHS) | TOTAL DAYS (LAST 12 MONTHS) | TOTAL OCCASIONS (LAST 6 MONTHS) | TOTAL OCCASIONS (LAST 12 MONTHS) | BRADFORD FACTOR | TRIGGER POINT REACHED | WHICH TRIGGER POINT |  | TRIGGER KEY
Employee 1 | 2020-01-06 00:00:00 | 2020-01-08 00:00:00 |  |  | Employee 1 |  |  |  |  |  |  |  |  | TRIGGER 1 | 50
Employee 2 | 2020-01-07 00:00:00 | 2020-01-08 00:00:00 |  |  | Employee 2 |  |  |  |  |  |  |  |  | TRIGGER 2 | 100
Employee 1 | 2020-02-12 00:00:00 | 2020-02-14 00:00:00 |  |  | Employee 3 |  |  |  |  |  |  |  |  | TRIGGER 3 | 200
Employee 4 | 2020-03-03 00:00:00 | 2020-03-05 00:00:00 |  |  | Employee 4
Employee 5 | 2020-03-06 00:00:00 | 2020-03-12 00:00:00 |  |  | Employee 5
Employee 1 | 2020-05-04 00:00:00 | 2020-05-08 00:00:00
Employee 1 | 2020-07-09 00:00:00 | 2020-08-12 00:00:00
Employee 5 | 2020-03-06 00:00:00 | 2020-03-12 00:00:00
Employee 1 | 2020-05-04 00:00:00 | 2020-05-08 00:00:00
Employee 1 | 2020-05-09 00:00:00 | 2020-05-12 00:00:00
Employee 5 | 2020-03-06 00:00:00 | 2020-03-12 00:00:00
Employee 1 | 2020-05-04 00:00:00 | 2020-05-08 00:00:00
Spreadsheet: 857713d1706646013-please-help-excel-formula-issue-excel-table
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Current level
Account | Ccy | Interest Rate | Lower Account Limit | Upper Account Limit | Current Level Check | Current Level | Target |  |  | Target level |  |  |  | VBA copies non default account Interest rates to column O cells below to avoid circular reference
Ski | USD | 5.09 | 0 | 8 |  | 10.77083248262643 |  |  |  | Should equal 0 |  |  |  | 5.09
Snow | USD | 4.08 | 0.5 | 6 |  | 3.857072964281247 |  |  |  |  |  |  |  | 4.08
Sea | USD | 3.83 | 0.5 | 22 |  | 1.452503148962015 |  |  |  |  |  |  |  | 3.83
Sky | USD | 0 | 0 | 0.5 |  | 0.001172570953467052 |  |  |  |  |  |  |  | 0
Base/Default | USD | 2.5 | 1.5 | 10 |  | 14.63350928840657 | 3 | Cell H8 is dynamic its the default bank account it has to be >= D8 (lower account limit) |  |  |  |  |  | 2.5
 |  | Dynamic formula in C column which updates from a different tab | Static | Static | column F is needed for something else and should be left. N/A for this purpose | Dynamic formula in G column which updates from a different tab |  | As cash gets allocated out to get a higher interest it reduces the base/default account
 |  | Target cells in H4-H7 should be formula that I can drag down to all cell in yellow which allocates any spare cash from default account (H8) according to where it can get the highest interest rate.  Important though cash can't be reallocated past when [NAME] is less than its lower acocunt limit (cell D8). Each account (non default) can be allocated to the upper account limit once that its is hit then next highest interest rate account will get the remianing spare cash until H8 <D8
 |  | Please note formula in cell H4 to H7 is my attempt but it puts default into negative
 |  | Can't allocate more cash than there is currentlly - check in J5
Spreadsheet: 848415d1699142358-how-to-calculate-a-pay-rate-that-is-affected-by-2-different-pay-conditions-pay-calculator_normal-pay-without-extra-days_rev-03
Sheet: ADO Build-Up Time

DATE | DAY | SHIFT [NAME] |  | TOTAL HOURS WORKED | DEFAULT HOURS |  |  | BUILD-UP TIME BASED ON DEFAULT HOURS |  | BUILD-UP TIME BASED ON WORK HOURS |  |  | BALANCE RE-CALCULATED BASED ON WORK DAYS |  |  |  | DEDUCT TO ZERO IF AN ADOC
 |  |  |  | Hrs:mins | hrs:mins format | Decimal format |  | TIME DEDUCTED (Decimal) | [NAME] | TIME DEDUCTED hrs:mins | RE-DISTRIBUTED BALANCE                                 hrs:mins |  | NOS. DAYS NOT DEDUCTED | DAYS DEDUCTED | DAILY BALANCE TO BE ADDED
WEEK 1
 | Monday | 'Work Calculator'!C10 | 'Work Calculator'!C10
 | Tuesday | 'Work Calculator'!C11
 | Wednesday
 | Thursday
 | Friday
 |  | WEEK 1 Sub-Total :
WEEK 2
 | Monday
 | Tuesday
 | Wednesday |  |  |  |  |  |  |  |  |  |  |  | 04:00:00 | Hours to be deducted for this 2 week pay period
 | Thursday |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Friday |  |  |  |  |  |  |  |  |  |  |  |  | Balance to be re-distributed over each day for the pay period
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Days worked over the pay period
 |  | WEEK 2 Sub-Total :
Spreadsheet: e936f190-d1d9-404e-baa4-7c939503f5d8
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
11/02/2013 | Wrestling | Gardner-Webb (UVA Duals) | W, 24-14
11/02/2013 | Wrestling | [NAME] (UVA Duals) | W, 46-0
11/02/2013 | Wrestling | at Virginia (UVA Duals) | L, 41-6
11/09/2013 | Wrestling | at Mercyhurst Laker Open | Results
11/15/2013 | Wrestling | at Iowa State | L, 22-12
11/15/2013 | Wrestling | Midland | W, 34-6
11/16/2013 | Wrestling | [NAME] (Ames, Iowa) | Results
11/23/2013 | Wrestling | Navy Classic | 9th/14
12/07/2013 | Wrestling | Drexel ([NAME]) | 10 a.m.
12/07/2013 | Wrestling | VMI ([NAME]) | Noon
12/07/2013 | Wrestling | [NAME] ([NAME]) | 2 p.m.
12/08/2013 | Wrestling | at Indiana ([NAME]) | 11 a.m.
12/08/2013 | Wrestling | Northern Colorado ([NAME]) | 1 p.m.
12/22/2013 | Wrestling | Tournament of Champions (Reno, Nev.) | All Day
01/04/2014 | Wrestling | Lock Haven | 7 p.m.
01/10/2014 | Wrestling | NC State | 7:30 p.m.
01/18/2014 | Wrestling | Oklahoma State | 7:30 p.m.
02/01/2014 | Wrestling | Pittsburgh | 7 p.m.
02/06/2014 | Wrestling | Oklahoma | 7 p.m.
02/07/2014 | Wrestling | [NAME] | 7:30 p.m.
02/14/2014 | Wrestling | Clarion University (Beauty and Beast) | 6 p.m.
02/16/2014 | Wrestling | at Ohio | 2 p.m.
[NAME] | Wrestling | at Edinboro | 7 p.m.
03/08/2014 | Wrestling | Big 12 Tournament (Norman, Okla.) | All Day
03/20/2014 | Wrestling | [NAME] (Oklahoma City) | All Day
Spreadsheet: 855348d1704950146-find-value-return-sheet-colum-and-row-name-searchexample_excelforum
Sheet: Sheet2

 | A | B | C | D | E | F | G | H | I | J
1 | 26 | 453 | 1984 | 35198 | 52551
2 | 354 | 453 | 98841 | 6549 | 65
3 | 354 | 456 | 16544 | 545 | 36
4 | 36 | 78995 | 564 | 165 | 658
5 | 15 | 42786 | 654 | 4 | 81
6 | 15864 | 7852 | 98 | 6941 | 549
7 | 5456 | 68786527 | 2654 | 74447 | 125
8 | 245421 | 852155 | 897 | 5789 | 549
9 | 4564 | 456421 | 84984 | 147 | 15658
10 | 4564 | 32165 | 7897 | 89 | 149
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: B17

Local 17
Nom: | [NAME]
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-10-07 00:00:00
[NAME]: | 91
Réservé: | réservé
Prix: | 130
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 752229d1634657415-formula-simplification-help-sum-specific-rows-based-on-cell-tracking
Sheet: Main

 | 2021-10-31 00:00:00 |  | thru
Project | Hours | Allotted | Remaining | Rate | Urgency | [NAME]
Project 1
Project 2
Project 3
Project 4
Project 5
Special Project 1 |  |  |  | 10
Special Project 2 |  |  |  | 20
Special Project 3 |  |  |  | 30
Special Project 4 |  |  |  | 40
Special Project 5 |  |  |  | 50
Other 1
Other 2
Other 3
Spreadsheet: 687971d1595511816-return-sheet-name-when-value-is-found-on-that-sheet-students-example
Sheet: Stefan Van Ael

Maand
[NAME]
To Do
 | Totaal aantal lessen
 | 0
 | 30 |  | maand
 |  | Januari | 0 | 0
 | 0 | Februari | 0 | 0
 |  | [NAME] | 0 | 0
 |  | april | 0 | 0
 |  | mei | 0 | 0
 |  | juni | 0 | 0
 |  | [NAME] | 0 | 0
 |  | augustus | 0 | 0
 |  | september | 0 | 0
 |  | oktober | 0 | 0
 |  | november | 0 | 0
 |  | december | 0 | 0
 |  |  |  | 0
 | cash
Spreadsheet: 873924d1720527122-countifs-fx-for-3-columns-excel-help
Sheet: Sheet1

Date Table
Item | Type | Status |  | Item | Type | 1 | 2
A | AA | 1 |  | A | AA
B | AB | 1 |  | B | AB
C | AB | 2 |  | C | AC
D | AC | 1 |  | D | AD
C | AC | 2
D | AA | 2
D | AD | 2
B | AD | 2
C | AB | 1
A | AC | 1
Spreadsheet: 31981d1228085695-automatically-sort-information-into-different-sheets-running-sheet
Sheet: Sheet1

Sales Rep | Amount | Delivery Date
[NAME] | 20 | 2009-01-01 00:00:00
[NAME] | 50 | 2009-05-02 00:00:00
[NAME] | 46 | 2008-12-12 00:00:00
[NAME] | 80 | 2009-05-06 00:00:00
[NAME] | 46 | 2009-01-05 00:00:00
[NAME] | 85 | 2009-02-06 00:00:00
[NAME] | 90 | 2009-04-07 00:00:00
[NAME] | 355 | 2009-01-01 00:00:00
This is the sheet where each sale gets recorded as it comes in, I then want it to throw the relevant
data into each Reps individual sheet. See individual sheets.
Spreadsheet: 376359d1423579027-can-this-be-done-calculate-only-selected-cells-carton-size-and-weight-calculation
Sheet: Sheet1

Total Items |  |  |  |  |  |  | Total Cu In. | Total Weight
 | Item Number | Something | [NAME] | Weight | Something | Something | Cu In. | Selected Wts.
x | 456565 | sfsf | 12x11x22 | 12 lbs | sfsfs | [NAME]
x | 456556 | jhjhj | 13"x21"x14" | 13 lbs | jgjgjgj | sfsfsf
x | 656545 | hfhfhfh | 12x15x12 | 22 lbs. | fsfsfsf | jfghj
x | 348675 | [NAME] | 14" x 13" x 12" | 10 | hkhkhk | jgjgj
Spreadsheet: 54432d1254411288-high-scores-and-tiebreaker-forestry-sample
Sheet: Sheet1

School | Sawlogs | Pulpwood | Tree ID | Thinning | [NAME] | Compass | Ind | Team | Rank
CHS |  |  |  |  |  |  |  | 578 | 4
Adam | 28 | 14 | 79 | 44 | 35 | 6 | 206
Tyler | 26 | 18 | 85 | 38 | 30 | 4 | 201
Carly | 12 | 12 | 85 | 40 | 10 | 12 | 171
[NAME] | 33 | 12 | 20 | 38 | 0 | 16 | 119
 |  |  |  |  |  |  | 0
School | Sawlogs | Pulpwood | Tree ID | Thinning | [NAME] | Compass |  | Team | Rank
DoHS |  |  |  |  |  |  |  | 382 | 6
Gavin | 0 | 6 | 30 | 20 | 0 | 0 | 56
[NAME] | 9 |  | 53 | 40 | 0 | 0 | 102
[NAME] | 9 | 17 | 23 | 42 | 35 | 6 | 132
[NAME] | 16 | 18 | 45 | 38 | 25 | 6 | 148
School | Sawlogs | Pulpwood | Tree ID | Thinning | [NAME] | Compass |  | Team | Rank
DuHS |  |  |  |  |  |  |  | 678 | 3
[NAME] | 53 | 15 | 95 | 40 | 35 | 21 | 259
[NAME] | 51 | 10 | 55 | 40 | 35 | 18 | 209
Savannah | 29 | 16 | 26 | 34 | 50 | 7 | 162
Summer | 51 | 27 | 69 | 36 | 25 | 2 | 210
 |  |  |  |  |  |  | 0
School | Sawlogs | Pulpwood | Tree ID | Thinning | [NAME] | Compass |  | Team | Rank
JHHS |  |  |  |  |  |  |  | 212 | 8
Geogre Palmer | 0 | 2 | 5 | 24 | 0 | 0 | 31
[NAME] | 13 | 6 | 88 | 26 | 0 | 2 | 135
[NAME] | 0 | 2 | 5 | 38 | 0 | 1 | 46
 |  |  |  |  |  |  | 0
School | Sawlogs | Pulpwood | Tree ID | Thinning | [NAME] | Compass |  | Team | Rank
LPCA |  |  |  |  |  |  |  | 167 | 9
[NAME] | 0 | 2 | 0 | 36 | 0 | 0 | 38
Ricarrio | 0 | 4 | 0 | 28 | 0 | 0 | 32
Damon | 13 | 8 | 5 | 22 | 0 | 0 | 48
Jimace | 6 | 12 | 5 | 34 | 0 | 24 | 81
 |  |  |  |  |  |  | 0
School | Sawlogs | Pulpwood | Tree ID | Thinning | [NAME] | Compass |  | Team | Rank
QHS |  |  |  |  |  |  |  | 476 | 5
[NAME] | 29 | 12 | 26 | 26 | 0 | 20 | 113
Nick | 14 | 15 | 56 | 42 | 30 | 15 | 172
Justin | 18 | 30 | 48 | 42 | 45 | 8 | 191
[NAME] | 29 | 34 | 18 | 30 | 0 | 2 | 113
School | Sawlogs | Pulpwood | Tree ID | Thinning | [NAME] | Compass |  | Team | Rank
RHS |  |  |  |  |  |  |  | 763 | 1
Will | 46 | 27 | 112 | 48 | 35 | 6 | 274
Brenden | 50 | 12 | 63 | 44 | 45 | 18 | 232
Savannah | 44 | 12 | 80 | 42 | 45 | 24 | 247
Adam | 53 | 35 | 63 | 44 | 40 | 7 | 242
School | Sawlogs | Pulpwood | Tree ID | Thinning | [NAME] | Compass |  | Team | Rank
SHS |  |  |  |  |  |  |  | 234 | 7
Garrett | 24 | 15 | 40 | 28 | 0 | 3 | 110
[NAME] | 2 | 2 | 7 | 24 | 0 | 2 | 37
[NAME] | 14 | 8 | 5 | 40 | 15 | 5 | 87
 |  |  |  |  |  |  | 0
School | Sawlogs | Pulpwood | Tree ID | Thinning | [NAME] | Compass |  | Team | Rank
WHS |  |  |  |  |  |  |  | 719 | 2
Isaacc | 54 | 14 | 88 | 38 | 45 | 14 | 253
Justin | 44 | 6 | 88 | 32 | 50 | 8 | 228
[NAME] | 33 | 10 | 112 | 44 | 35 | 4 | 238
[NAME] | 41 | 13 | 53 | 32 | 20 | 6 | 165
Overall High Individual
Sawlogs
Pulpwood
Tree ID
Thinning
[NAME]
Compass
Spreadsheet: 703458d1605009427-countif-range-of-cells-contains-text-from-column-a-countif-range-2-
Sheet: Hoja2

 | One way | Another way |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Jornada 6 | Jornada 7 | Jornada 8 | Jornada 9 | Jornada 10 | Jornada 11 | Jornada 12 | Jornada 13 | Jornada 14 | Jornada 15 | [NAME] 16 | Jornada 17 | Jornada 18
1 José (P) |  |  |  | Alboraya 0 - 0 Alzira | Villarreal 4 - 0 Alboraya
2 Pau |  |  |  | 1 José (P) | 1 José (P)
3 [NAME] |  |  |  | 2 Pau | 2 Pau
4 Elies |  |  |  | 3 [NAME] | 3 Jacob (C)
5 Antoni |  |  |  | 4 Elies | 4 Antoni
6 Yassine |  |  |  | 5 Antoni | 5 Elies  79'
7 Rubén Asaf  86' |  |  |  | 6 Yassine | 6 [NAME]
8 Martin |  |  |  | 7 Rubén Asaf  86' | 7 Tomas  79'
9 [NAME]  76' |  |  |  | 8 Martin | 8 Yassine
10 Hyoki  59' |  |  |  | 9 [NAME]  76' | 9 [NAME]  58'
11 Jacob (C) |  |  |  | 10 Hyoki  59' | 10 Hyoki  58'
12 Pepe |  |  |  | 11 Jacob (C) | 11 Martin  61'
13 [NAME] |  |  |  | Suplentes
14 [NAME] |  |  |  |  | Alboraya U.D. "A"
15 Roberto |  |  |  | 12 Pepe | 12 Pepe
16 Francesco |  |  |  | 13 [NAME] | 13 Sergio
17 [NAME]  59' |  |  |  | 14 [NAME] | 14 [NAME]
18 Alejandro |  |  |  | 15 Roberto | 15 Roberto
19 [NAME]  76' |  |  |  | 16 Francesco | 16 Francesco
20 Pablo Rafael |  |  |  | 17 [NAME]  59' | 17 Rubén Asaf  58'
 |  |  |  | 18 Alejandro | 18 [NAME]  79'
 |  |  |  | 19 [NAME]  76' | 19 [NAME]  58'
 |  |  |  | 20 Pablo Rafael | 20 Pablo Rafael  61'
 |  |  |  | Suplentes - Entrado
 |  |  |  | 14 [NAME] | 14 [NAME]
 |  |  |  | 17 [NAME]  59' | 17 Rubén Asaf  58'
 |  |  |  |  | 18 [NAME]  79'
 |  |  |  | 19 [NAME]  76' | 19 [NAME]  58'
 |  |  |  |  | 20 Pablo Rafael  61'
Spreadsheet: 786477d1657207308-payroll-formulas-needed-for-hours-pto-and-per-diem-payroll-data-report
Sheet: PTO

Date | First Name | Last Name | Total | Paid | Type | Description
Sun, Jun 19, 2022 | Mark | Eveland | 00:00:00 | Yes | Other | [NAME]
Mon, Jun 20, 2022 | [NAME] | Walker | 00:00:00 | No | Sick
Mon, Jun 20, 2022 | Jared | Hitomi | 08:00:00 | Yes | Other | [NAME]
Mon, Jun 20, 2022 | Julian | Cuevas | 00:00:00 | No | Personal | Appointment to gather important documents
Mon, Jun 20, 2022 | Mark | Eveland | 08:00:00 | Yes | Other | [NAME]
Tue, Jun 21, 2022 | Jared | Hitomi | 08:00:00 | Yes | Other | [NAME]
Tue, Jun 21, 2022 | Mark | Eveland | 08:00:00 | Yes | Other | [NAME]
Wed, [NAME], 2022 | Jared | Hitomi | 08:00:00 | Yes | Other | [NAME]
Wed, [NAME], 2022 | Mark | Eveland | 08:00:00 | Yes | Other | [NAME]
Thu, Jun 23, 2022 | Jared | Hitomi | 08:00:00 | Yes | Other | [NAME]
Thu, Jun 23, 2022 | Mark | Eveland | 08:00:00 | Yes | Other | [NAME]
Fri, [NAME], 2022 | Mark | Eveland | 08:00:00 | Yes | Other | [NAME]
Mon, Jun 27, 2022 | [NAME] | Hinrichsen | 00:00:00 | No | Personal | Will be out of town.
Mon, Jun 27, 2022 | Jorge | Rodriguez | 08:00:00 | Yes | Personal
Tue, Jun 28, 2022 | Jorge | Rodriguez | 08:00:00 | Yes | Personal
Wed, Jun 29, 2022 | Jorge | Rodriguez | 08:00:00 | Yes | Personal
Thu, Jun 30, 2022 | Jorge | Rodriguez | 08:00:00 | Yes | Personal
Fri, Jul 1, 2022 | J [NAME] | [NAME] | 00:00:00 | No | Personal
Fri, Jul 1, 2022 | Jorge | Rodriguez | 08:00:00 | Yes | Personal
Fri, Jul 1, 2022 | [NAME] | Blake | 00:00:00 | No | Personal
Spreadsheet: 710232d1608794997-need-a-change-in-if-formula-to-get-the-exact-result-in-house-production-tracking-with-completion-
Sheet: DATE TRACK

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-23 00:00:00
CHOOSE P.O. NO. | 4191 |  |  |  |  |  |  |  |  |  |  |  |  | DAILY PRODUCTION REPORT |  |  |  |  |  |  |  |  | DECEMBER |  |  |  |  |  |  |  |  |  | TO
 |  |  | TOTAL METER | ORG. ORDER | STOCK | FINAL ORDER | ORDER DATE | ORDER START DATE | PENDING ORDER | ORDER END DATE | EXTENDED DATE | EXTENDED DAYS | AVG PROD.
QUALITY | P.O. NO. | WIDTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORDER | ORDER DATE | LEAD TIME | TOTAL | DIFFERENCE | DAILY EXPECTED | END DATE | AVG PROD. | EXTENDED DATE | EXTENDED DAYS | TOTAL | ORDER START DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 193 | 135.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 | 106 |  | 494 | 391 | 510 | 183.5 | 166 | 94 | 190.5 |  |  | 41 |  | 154 | 144 | 486 |  | 233
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100.5 | 140 |  | 208 | 63 | 166 | 99 | 97 | 9.5 |  |  |  | 48 | 98 | 134 | 148 | 297.5 |  | 127 | 16