tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7306__imball0201
Sheet: EPFS

 | El Paso/TW Eddy Rec |  |  | 27677
 | 78093
Day | Measured | Scheduled
1 | 30077 | 30013
2 | 30198 | 30013
3 | 30012 | 30013
4 | 28849 | 30013
5 | 29803 | 32012
6 | 29404 | 32012
7 | 29513 | 32012
8 | 29387 | 31955
9 | 31999 | 32012
10 | 33291 | 32013
11 | 35895 | 32013
12 | 33881 | 32013
13 | 34615 | 32013
14 | 33685 | 32013
15 | 25246 | 32013
16 | 37058 | 31127
17 | 36319 | 31127
18 | 32175 | 31127
19 | 30143 | 28727
20 | 27997 | 28727
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 85001.93
2002-01-20 00:00:00
CBS Volume
 |  |  | 54581
Spreadsheet: 5a40b446-5f6d-4982-95f7-fe04beee2668
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3840 | 26223 | [NAME] | Carroll | AUS | 0 | 00:37:13 | 00:01:24 | 01:20:55 | 00:01:16 | 00:21:03 | 1 | 02:21:53
3840 | 26224 | [NAME] | Winch | AUS | 0 | 00:36:40 | 00:01:24 | 01:25:25 | [NAME] | 00:20:47 | 2 | 02:26:01
3840 | 15951 | [NAME] | Walker | AUS | 0 | 00:39:52 | 00:00:59 | 01:23:54 | 00:01:27 | 00:22:32 | 3 | 02:28:46
3840 | 12227 | Mark | Dawson | AUS | 0 | 00:41:36 | 00:00:43 | 01:33:48 | 00:01:04 | 00:22:07 | 4 | 02:39:20
3840 | 26222 | Trevor | [NAME] | AUS | 0 | 00:44:35 | 00:01:37 | 01:30:21 | 00:02:08 | 00:26:19 | 5 | 02:45:02
Spreadsheet: 151013d1334759586-lookup-nearest-billing-cycle-and-count-days-prorated-billing-cycle
Sheet: Decription

No | Purchase Date(dd/mm/yyyy) | Billing Cycle(dd/mm/yyyy) | Total Days |  | Billing Cycle Fixed for every month:
1 | 2012-03-01 00:00:00 |  |  |  | 7th
2 | 2012-03-25 00:00:00 |  |  |  | 10th
3 | 2012-03-12 00:00:00 |  |  |  | 13th
4 | 2012-03-26 00:00:00 |  |  |  | 16th
5 | 2012-04-08 00:00:00 |  |  |  | 19th
 |  |  |  |  | 22nd
 |  |  |  |  | 25th
 |  |  |  |  | Example on no of days in the month of BC range
 |  |  |  |  | 1.       On 1st March, the nearest BC is 7th Mar, the proration calculation is based on 7th Feb to 6th Mar, therefore is no. of days is 29.
 |  |  |  |  | 2.       On 24th [NAME], the nearest BC is 25th Mar, the proration calculation is based on 25th Feb to 24th Mar, therefore the no. of days is 29
 |  |  |  |  | 3.       On 26th Mar, the nearest BC is 7th Apr, the proration calculation is based on 7th Mar to 6th April, therefore the no. of days is 31.
Spreadsheet: 236645d1368906331-conditional-formatting-highlight-cells-that-meet-a-criteria-but-ignore-blank-cells-testae042701_revised
Sheet: TESTAE042701_REVISED

Example:
1 |  |  | -0.933
3 |  |  | -0.934
5 |  | -1.128
7 |  | -1.118
9 |  |  | -0.922
11 |  |  | -0.995
13 |  | -1.129
15 |  | -1.14
17 |  | -1.137
19 |  | -1.114
21 |  | -1.108
23 |  |  | -0.944
25 |  |  | -0.951
27 |  | -1.151
29 |  | -1.151
31 |  | -1.12
33 |  | -1.129
35 |  | -1.129
37 |  |  | -0.942
39 |  | 0.004 | -0.943
41 |  |  | -0.96
43 |  | -1.154
45 |  | -1.154
47 |  | -1.151
49 |  | -1.146
51 |  | -1.145
53 |  |  | -0.953
55 |  | -1.178
57 |  | -1.042
59 |  | -1.157
61 |  | -1.153
63 |  | -1.145
65 |  |  | -0.934
67 |  |  | -0.963
69 |  | -1.148
71 |  | -1.145
73 |  | -1.163
75 |  | -1.167
77 |  |  | -1.403
Spreadsheet: 878140d1725134946-amortization-for-those-payday-loans-with-apr-300-samstam-sample-amortization
Sheet: Capital One

Loan amortization schedule without term
Name | Capital One
Loan Amount | 3091.61
APR | 0.2605
Monthly Payment | 100
Monthly Interest
Month | Beginning Balance | Payment | Interest | Principal | Ending Balance
2024-09-01 00:00:00
2024-10-01 00:00:00
2024-11-01 00:00:00
2024-12-01 00:00:00
2025-01-01 00:00:00
2025-02-01 00:00:00
2025-03-01 00:00:00
2025-04-01 00:00:00
2025-05-01 00:00:00
2025-06-01 00:00:00
2025-07-01 00:00:00
2025-08-01 00:00:00
2025-09-01 00:00:00
2025-10-01 00:00:00
2025-11-01 00:00:00
2025-12-01 00:00:00
2026-01-01 00:00:00
2026-02-01 00:00:00
2026-03-01 00:00:00
2026-04-01 00:00:00
2026-05-01 00:00:00
2026-06-01 00:00:00
2026-07-01 00:00:00
2026-08-01 00:00:00
2026-09-01 00:00:00
2026-10-01 00:00:00
2026-11-01 00:00:00
2026-12-01 00:00:00
2027-01-01 00:00:00
2027-02-01 00:00:00
2027-03-01 00:00:00
2027-04-01 00:00:00
2027-05-01 00:00:00
2027-06-01 00:00:00
2027-07-01 00:00:00
2027-08-01 00:00:00
2027-09-01 00:00:00
2027-10-01 00:00:00
2027-11-01 00:00:00
2027-12-01 00:00:00
2028-01-01 00:00:00
2028-02-01 00:00:00
2028-03-01 00:00:00
2028-04-01 00:00:00
2028-05-01 00:00:00
2028-06-01 00:00:00
2028-07-01 00:00:00
2028-08-01 00:00:00
2028-09-01 00:00:00
2028-10-01 00:00:00
2028-11-01 00:00:00
2028-12-01 00:00:00
Spreadsheet: 0583fdbb-7309-41eb-b242-2dcfeb8b99c4
Sheet: Pers Grow

Survey of all Currently enrolled students Fall 2012 -- Evaluate Personal Growth
The only question that fell below 90% satisfaction was Math abilities
EVALUATE PERSONAL GROWTH
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total |  |  | EVALUATE FRCC INSTRUCTION | [NAME] | Brighton | CCCS Onl | Larimer | FRCC Onl | Westminster | Total
Total
Percent of Satisfied or Very Satisfied
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total
Total
Percent of Satisfied or Very Satisfied
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total
Total
Percent of Satisfied or Very Satisfied
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total
Total
Percent of Satisfied or Very Satisfied
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total
Total
Percent of Satisfied or Very Satisfied
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total
Total
Percent of Satisfied or Very Satisfied
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total
Total
Percent of Satisfied or Very Satisfied
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total
Total
Percent of Satisfied or Very Satisfied
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total
Total
Percent of Satisfied or Very Satisfied
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total
Total
Percent of Satisfied or Very Satisfied
Spreadsheet: 834610d1687942677-maximum-drawdown-and-lambda-max-drawdown
Sheet: Sheet1

 | PRODUCT A | CUM | ROLL. MAX | DEV from MAX |  |  | START | END | MAX DRAWDOWN
2019-12-31 00:00:00 | -0.57861290846758 |  |  |  |  |  | 2020-12-31 00:00:00 | 2021-12-31 00:00:00
 | -3.590597718405362
 | 0.7494487010933701
 | 2.313996054078521
 | 1.594460980497281
 | -2.504119317371035
 | 0.5214285449261737
 | -3.582328339610863
 | -4.341948560645585
 | 2.809783807392531
 | -1.719229467161201
 | -0.6864038286669221
 | 2.224135315424497 | 0
 | -0.01527173662518511
 | 2.378054705894285
 | 4.661159681791649
 | -4.775167185182427
 | 3.361289721034016
 | -3.561089316044541
 | -2.141225804925138
 | 4.125163667556905
 | -4.607985322871996
 | 2.488004230679637
 | -3.23716843214557
 | 1.338640635336978
 | 4.460280898448705
 | -4.244273360102114
 | 1.235959366317568
 | -1.178230496554038
 | -0.5222887226825081
 | 3.25359450990716
 | 0.9190951134371517
 | -4.642195152033653
 | 3.767401082542253
 | 0.7683136638498169
 | -0.7538937858272714
 | 4.212158379213635
 | 0.5736298715738544
 | 3.18529571214351
 | -0.2011605325859058
 | 0.9084418826879217
 | 1.978766747909637
Spreadsheet: 328104d1403788061-weekly-numbers-rolled-up-to-monthly-numbers-330014857-dsny-budet-detail
Sheet: Hours Forecast

DSNY Budget |  | Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
Name | Rate | Budget | 2014-05-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | hi | Total
Porter | 285 | 500 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
[NAME] | 225 | 500 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 195 | 24 | 24 | 24 | 24 | 24
Vlad | 225 | 500 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 195 | 160 | 40 | 40 | 40 | 40 | 40
Sajid | 285 | 200 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 8 | 4
[NAME] | 285 | 200 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
DSNY Budget
Name | Rate | Budget | 2014-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | hi | Total
Porter | 285 | 500
[NAME] | 225 | 500
Vlad | 225 | 500
Sajid | 285 | 200
[NAME] | 285 | 200
Name | Rate | Hrs | Budget
Porter
[NAME]
Vlad
Sajid
[NAME]
 |  | Estimated
 |  | Remaining | 656221
 |  | Difference
Name | Rate | Hrs | Budget
Porter | 285 | 48
[NAME] |  | 80
Vlad |  | 160
Sajid |  | 80
[NAME] |  | 80
Est. Monthly Expense
Spreadsheet: daren_farmer__6552__0100allocations
Sheet: Sheet1

2000 Plan Allocations
TEXAS NATURAL GAS OPERATIONS
2000-01-01 00:00:00
 |  |  |  |  |  |  | Gas Network | Gas Network | Gas Network | Gas Network | Gas Network | [NAME] |  | ST Gas
RC# | RC Owner |  | [NAME] |  | East Orig | Executive | Services | Development | Trading | Engineering | Transportation | Origination | Central | East | TOTALS
122663 | Eiben |  | HPLC - Logistics - Unify Project |  |  |  |  |  |  |  | 0.2 | 0.8
122664 | Clynes |  | HPLC - Logistics |  |  |  | 0.15 |  | 0.5 |  | 0.35
688 | Csikos |  | Client Services - On Systems Settlements |  |  |  | 0.32 | 0.01 | 0.61 |  |  | 0.05 | 0.01
1160 | [NAME] |  | Volume Mgmt |  | 0 |  |  | 0.06 | 0.15 |  | 0.66 | 0.05 |  | 0.08
1497 | Farmer |  | Gas Logistics - Texas (Trading Support) |  |  |  | 0.15 | 0.01 | 0.84
1638 | Herod |  | Texas Gas Team - RISK |  | 0.03 |  | 0.2 | 0.05 | 0.52 |  | 0.2
2632 | Herod |  | Texas Operations Mgmt |  |  |  | 0.2 | 0.1 | 0.5 |  | 0.15 | 0.05
2675 | Venturatos |  | Regulatory Compliance |  |  |  | 0.25 |  | 0.06 |  | 0.54 |  | 0.05 | 0.1
2933 | Smith |  | Texas Transportation & Rate Management |  |  |  |  |  | 0.005 |  | 0.99 | 0.005
2939 | [NAME] |  | Global Contracts - Texas Operations |  |  | 0.1 | 0.2 |  | 0.04 | 0.1 | 0.36 | 0.2
2940 | [NAME] |  | Global Facilities - Texas Operations |  |  |  | 0.1 |  | 0.06 | 0.1 | 0.54 | 0.2
Spreadsheet: 073ef4c6-13bb-4c26-8783-d51dd6951bd9
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FPDM | Test | FPDM | Partial DMD Deletion/Duplication-Males only | Partial DMD Del/Dup Males | Dosage analysis of all exons on the DMD gene | EDTA (lavender-top) tube: EDTA |  |  | 30 | mL | 30 mL whole blood collected in a lavender-top (EDTA) tube(s). Send whole blood at ambient temperature.  Note:  Collection date is required. | 10 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | A final report will be attached in MayoAccess.   Test Performed By:  Athena Diagnostics                                         377 Plantation St.                                         Four Biotech Park                                         Worcester, MA  01605 | Monday, Thursday | 14-21 days | 15-22 days | 1 | 81161 |  |  |  |  | Athena Diagnostics
FPDM | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
FPDM | Result | Z0087 | Partial DMD Del/Dup Males | Partial DMD Del/Dup Males | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 478804d1473075318-copy-with-respect-to-row-head-puzzle-1
Sheet: Sheet1

S. No. | Color
1 | Black
2 | Blue
3 | Red
4 | Blue
5 | Red
6 | Green
7 | Black
8 | Red
9 | Blue
10 | Black
11 | Green
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: A10

[NAME]
Nom: | [NAME]
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-03-15 00:00:00
[NAME]: | 15
Réservé:
Prix: | 100
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: 788386d1658430491-find-particular-value-in-cell-after-a-certain-cell-value-example
Sheet: FRL

FRL
SALES PER EMPLOYEE
- Factory | -2.437961379310345 | -1.232678571428571 | -3.148943076923078 | -2.682687692307692 | -0.282624 | -2.4243936 | -5.508445 | -0.006135000000000002 | -7.210175 | 1.7466288 | -3.796889999999999 | -1.376235
- Fixed Support | -35.35044 | -17.2575 | -40.93626 | -34.87494 | -3.5328 | -30.30492 | -66.10134 | -0.07362000000000002 | -86.52210000000001 | 21.83286 | -45.56267999999999 | -16.51482
- Total Sales Per Employee | -2.280673548387097 | -1.1505 | -2.924018571428572 | -2.491067142857143 | -0.2616888888888889 | -2.244808888888889 | -5.084718461538461 | -0.005663076923076924 | -6.655546153846155 | 1.617248888888889 | -3.504821538461538 | -1.270370769230769
INVESTMENT
- Depreciation | 6.913789999999999 | 6.91374 | 6.815060000000001 | 6.96769 | 6.96786 | 6.968019999999999 | 6.967569999999999 | 6.96779 | 6.96788 | 6.88034 | 6.88029 | 7.334629999999999
Percent To Sales | -1.173471673902786 | -2.403734028683181 | -0.9988787446630445 | -1.198744427947403 | -11.83400135869565 | -1.379581929270891 | -0.6324443649705134 | -567.8720456397716 | -0.4831977032457603 | 1.890821449869601 | -0.9060428403245815 | -2.664744756527773
- Capital Spending (INPUT DATA) | 104 | 8 | 29 | 18 | 62 | 14 | 50 | 79 | 0 | 82 | 54 | 15
Spreadsheet: 720699d1614261842-trying-to-return-a-last-value-in-a-column-based-on-the-same-description-book1
Sheet: Sheet1

 | Date | Stock | Type | Units |  | Previous Units | Cumulative Units
 | 2021-02-24 00:00:00 | Gasoline | Buy | 16
 | 2021-02-24 00:00:00 | Financial | Buy | 13
 | 2021-02-25 00:00:00 | Gasoline | Sell | 1
 | 2021-02-25 00:00:00 | Financial | sell | 1
 | 2021-02-26 00:00:00 | Financial | sell | 1 |  |  |  | Does not work because a maxif value so selects an earlier value if higher - =MAXIFS(H$4:H8,C$4:C8,C9)
 | 2021-02-26 00:00:00 | Financial | sell | 1 |  |  |  | Does not work because a maxif value so selects an earlier value if higher - =MAXIFS(H$4:H9,C$4:C9,C10)
 |  | Financial | sell | 1 |  |  | 12 | Just doesn't work - =INDEX($B$4:$B$10,SUMPRODUCT(MAX(ROW($H$4:$H$10)*($C$11=$C$4:$C$10))-1))
 |  | Financial | sell | 1 |  |  |  | Works in google sheets but not Excel =IF($C12="","",IFERROR(IF(ROW()<>2,INDEX(arrayformula(FILTER($H$4:$H11,$C$4:$C11<>"",ROW($C$4:$C11)=MAX(IF($C$4:$C11=C12,ROW($C$4:$C11),0)))),1),0),0))
Spreadsheet: 192508d1352437562-look-up-using-4-criterias-look-up-using-4-criterias-v2
Sheet: Result

 |  | Jan | Feb |  |  | 4 criterias
 |  | 3000001 | 3000005 |  |  | 0010CARANZAU
0010CARANZAU | TECNIS | 0 |  |  |  | 3000001
0010CARANZNZ | TORIC |  |  |  |  | TECNIS
 |  |  |  |  |  | Jan
 |  | Answer is 25 | Answer is 105
LOOKUP Table
 |  |  | [NAME]
Criteria 1 | [NAME] | Criteria3 | Jan | Feb | Mar
0010CARANZAU | 3000001 | TECNIS | 25 | 35 | 25
0010CARANZNZ | 3000005 | TORIC | 30 | 105 | 56
Spreadsheet: 145278d1331484610-how-can-i-show-the-cell-values-in-one-cell-instead-of-summ-listing-matching-values-in-one-cell
Sheet: Sheet1

 |  |  |  | with =SUMIF($B$2:$B$23;D2;$A$2:$A$23) I am getting this result |  | I need to get the show cloumb a
1 | G29 |  | F64 | 65 |  | 13,16,17,19
2 | 820 |  | G29 | 58 |  | 1,8,11,18,20
3 | 830 |  | m05 | 41 |  | 12,14,15
4 | 820 |  | 820 | 42 |  | 2,4,6,9,21
5 | 830 |  | 830 | 47 |  | 3,5,7,10,22
6 | 820
7 | 830
8 | G29
9 | 820
10 | 830
11 | G29
12 | m05
13 | F64
14 | m05
15 | m05
16 | F64
17 | F64
18 | G29
19 | F64
20 | G29
21 | 820
22 | 830
Spreadsheet: 811860d1672842203-need-help-to-look-in-and-out-latest-entry-revised-example-1-
Sheet: Data

Emp. Number | Emp. Name | Designation | Department | Date | Time | Status |  | Expected Results |  |  |  |  | IN |  |  |  | OUT
123 | ABC | SUPERVISOR | [NAME] | 2022-11-24 00:00:00 | 08:05:00 | I |  | On Time IN |  |  |  |  | Start | End | Description |  | Start | End | Description
123 | ABC | SUPERVISOR | [NAME] | 2022-11-24 00:00:00 | 20:08:00 | O |  | On Time Out |  |  |  |  | 07:00:00 |  | On Time IN |  | 12:00:00 | 16:00:00 | Early Out
234 | ABCDE | SUPERVISOR | Store | 2022-11-24 00:00:00 | 08:02:44 | I |  | On Time IN |  |  |  |  | 08:31:00 | 11:59:00 | Late Arrivals |  | 16:01:00 | 22:00:00 | On Time Out
234 | ABCDE | SUPERVISOR | Store | 2022-11-24 00:00:00 | 12:06:43 | O |  | Early Out
345 | AB | SUPERVISOR | QA | 2022-11-24 00:00:00 | 08:02:09 | I |  | Double Entry
345 | AB | SUPERVISOR | QA | 2022-11-24 00:00:00 | 08:22:02 | O |  | Double Entry
345 | AB | SUPERVISOR | QA | 2022-11-24 00:00:00 | 08:23:48 | I |  | On Time IN |  |  |  |  | I= | IN
345 | AB | SUPERVISOR | QA | 2022-11-24 00:00:00 | 19:03:24 | O |  | On Time Out |  |  |  |  | O= | OUT
567 | [NAME] | HELPER | Finishing | 2022-11-24 00:00:00 | 07:45:38 | I |  | Double Entry
567 | [NAME] | HELPER | Finishing | 2022-11-24 00:00:00 | 07:53:01 | O |  | Double Entry |  |  |  |  | [NAME] first check by Employee Number that have both IN and OUT in the same date. Then show that the employee is on time or not. IF there are more than one entries of this type then the last entry should be considered like I highligted with [NAME]. If IN or OUT is missing then formula show me that this employee in this date one entry is missing
567 | [NAME] | HELPER | Finishing | 2022-11-24 00:00:00 | 07:56:32 | I |  | On Time IN
567 | [NAME] | HELPER | Finishing | 2022-11-24 00:00:00 | 19:00:47 | O |  | On Time Out
648 | ADON | SAMPLE MAKER | Sample | 2022-11-25 00:00:00 | 09:51:21 | I |  | Late Arrivals
648 | ADON | SAMPLE MAKER | Sample | 2022-11-25 00:00:00 | 17:00:32 | O |  | On Time Out
714 | KHAMI | SUPERVISOR | [NAME] | 2022-11-25 00:00:00 | 08:06:37 | I |  | On Time IN
714 | KHAMI | SUPERVISOR | [NAME] | 2022-11-25 00:00:00 | 19:57:12 | O |  | On Time Out
567 | [NAME] | HELPER | Finishing | 2022-11-25 00:00:00 | 07:56:32 | I |  | On Time IN, Out Missing
Spreadsheet: 781823d1653572656-pulling-data-from-one-tab-to-another-using-index-followup-requiredtraining2022-test-1-aligw
Sheet: Dashboard

Select Supervisor Below | SupervisorList |  | Employee Name | Class1 | Class2 |  | Monday1End | Monday2End | Tuesday1End | Tuesday2End | Wednesday1End | Wednesday2End | Thursday1End | Thursday2End | [NAME] | Friday2End
Supervisor, [NAME] | Supervisor, [NAME]
 | Supervisor, [NAME]
Spreadsheet: 837921d1690513616-need-help-with-average-and-if-statement-grade-level-tracker
Sheet: 3rd Grade

3rd Grade
[NAME] pack | First Name | Last  Name | EB | 504 | SPED | CSI | [NAME] | Dreambox [NAME] | Typing Quarterly Goal | [NAME] Goal | TELPAS
[NAME] | [NAME] | Milan | Y | N | Y | Y
[NAME] | [NAME] | [NAME] | Y | N | Y | Y
Timberwolves | [NAME] | Smith | N | N | N
 |  |  | N | N | N
% at Mastery
EL % at Mastery
SpED % at Mastery
Notes:
Spreadsheet: 329289d1404250763-index-match-smallest-return-sample
Sheet: Sheet1

Amount | Reason for Movement | 2250
-183.25 | 2150 | first smallest return
-366.61 | 2150 | second smallest return
-61.1 | 2154 | third smallest return
-91.65 | 2150
-4.34 | 2450
-12.7 | 2250
-2.98 | 2250
-2.98 | 2250
-69.37 | 2452
-0.6 | 2451
-4.49 | 2250
-4.49 | 2250
-4.14 | 2250
-4.7 | 2250
-4.55 | 2250
-4.85 | 2250
-1.41 | 2250
-14.11 | 2250
-8.47 | 2250
Spreadsheet: 153120d1335779512-how-to-calculate-the-average-cycle-time-aver
Sheet: Sheet1

Date | Time | Truck
2012-01-01 00:00:00 | 01:02:56 | Truck 1 |  |  | Average Cycle Time
2012-01-01 00:00:00 | 05:16:43 | Truck 1 |  |  | Truck 1
2012-01-01 00:00:00 | 11:46:56 | Truck 1 |  |  | Truck 2
2012-01-01 00:00:00 | 16:13:06 | Truck 1 |  |  | Truck 3
2012-01-01 00:00:00 | 20:43:27 | Truck 1
2012-01-01 00:00:00 | 01:02:56 | Truck 2
2012-01-01 00:00:00 | 05:16:43 | Truck 2
2012-01-01 00:00:00 | 11:46:56 | Truck 2
2012-01-01 00:00:00 | 16:13:06 | Truck 2
2012-01-01 00:00:00 | 20:43:27 | Truck 2
2012-01-01 00:00:00 | 05:16:43 | Truck 3
2012-01-01 00:00:00 | 11:46:56 | Truck 3
2012-01-01 00:00:00 | 16:13:06 | Truck 3
2012-01-01 00:00:00 | 20:43:27 | Truck 3
2012-01-02 00:00:00 | 01:32:41 | Truck 1
2012-01-02 00:00:00 | 07:55:28 | Truck 1
2012-01-02 00:00:00 | 13:40:10 | Truck 1
2012-01-02 00:00:00 | 18:23:30 | Truck 1
2012-01-02 00:00:00 | 23:50:00 | Truck 1
2012-01-02 00:00:00 | 01:32:41 | Truck 2
2012-01-02 00:00:00 | 07:55:28 | Truck 2
2012-01-02 00:00:00 | 13:40:10 | Truck 2
2012-01-02 00:00:00 | 18:23:30 | Truck 2
2012-01-02 00:00:00 | 23:50:00 | Truck 2
2012-01-02 00:00:00 | 01:32:41 | Truck 3
2012-01-02 00:00:00 | 07:55:28 | Truck 3
2012-01-02 00:00:00 | 13:40:10 | Truck 3
2012-01-02 00:00:00 | 18:23:30 | Truck 3
2012-01-02 00:00:00 | 23:50:00 | Truck 3
2012-01-03 00:00:00 | 05:31:51 | Truck 1
2012-01-03 00:00:00 | 09:12:23 | Truck 1
2012-01-03 00:00:00 | 05:31:51 | Truck 2
2012-01-03 00:00:00 | 09:12:23 | Truck 2
2012-01-03 00:00:00 | 05:31:51 | Truck 3
2012-01-03 00:00:00 | 09:12:23 | Truck 3
2012-01-04 00:00:00 | 00:14:55 | Truck 1
2012-01-04 00:00:00 | 04:00:18 | Truck 1
2012-01-04 00:00:00 | 09:41:56 | Truck 1
2012-01-04 00:00:00 | 13:21:40 | Truck 1
2012-01-04 00:00:00 | 18:25:03 | Truck 1
2012-01-04 00:00:00 | 22:16:30 | Truck 1
2012-01-04 00:00:00 | 00:14:55 | Truck 2
2012-01-04 00:00:00 | 04:00:18 | Truck 2
2012-01-04 00:00:00 | 09:41:56 | Truck 2
2012-01-04 00:00:00 | 13:21:40 | Truck 2
2012-01-04 00:00:00 | 18:25:03 | Truck 2
2012-01-04 00:00:00 | 22:16:30 | Truck 2
2012-01-04 00:00:00 | 00:14:55 | Truck 3
2012-01-04 00:00:00 | 04:00:18 | Truck 3
2012-01-04 00:00:00 | 09:41:56 | Truck 3
2012-01-04 00:00:00 | 13:21:40 | Truck 3
2012-01-04 00:00:00 | 18:25:03 | Truck 3
2012-01-04 00:00:00 | 22:16:30 | Truck 3
2012-01-05 00:00:00 | 02:20:37 | Truck 1
2012-01-05 00:00:00 | 02:20:37 | Truck 2
2012-01-05 00:00:00 | 02:20:37 | Truck 3
2012-01-07 00:00:00 | 10:51:59 | Truck 1
2012-01-07 00:00:00 | 14:56:49 | Truck 1
2012-01-07 00:00:00 | 19:34:06 | Truck 1
2012-01-07 00:00:00 | 23:22:09 | Truck 1
2012-01-07 00:00:00 | 10:51:59 | Truck 2
2012-01-07 00:00:00 | 14:56:49 | Truck 2
2012-01-07 00:00:00 | 19:34:06 | Truck 2
2012-01-07 00:00:00 | 23:22:09 | Truck 2
2012-01-07 00:00:00 | 10:51:59 | Truck 3
2012-01-07 00:00:00 | 14:56:49 | Truck 3
2012-01-07 00:00:00 | 19:34:06 | Truck 3
2012-01-07 00:00:00 | 23:22:09 | Truck 3
Spreadsheet: 848547d1699280110-array-to-multiple-2-column-base-on-criteria-and-also-subtotal-book2-edited-felix-
Sheet: Sheet1 (2)

Comm Rate | PIC | Sales Amt | District | Comm Amt |  |  | Etiquetas de fila | Suma de Comm Amt
0.05 | [NAME] | 900 | N |  |  |  | E | 16
0.045 | [NAME] | 800 | S |  |  |  | [NAME] | 16
0.05 | [NAME] | 930 | N |  |  |  | N | 91.5
0.05 | [NAME] | 68 | S |  |  |  | [NAME] | 46.5
0.05 | [NAME] | 320 | E |  |  |  | [NAME] | 45
0.04 | [NAME] | 1200 | W |  |  |  | S | 39.4
0.05 | [NAME] | 300 | W |  |  |  | [NAME] | 39.4
 |  |  |  |  |  |  | W | 63
 |  |  |  |  |  |  | [NAME] | 63
 |  |  |  |  |  |  | Total general | 209.9
Spreadsheet: 715504d1611745491-creating-a-condensed-list-using-formulas-forumans
Sheet: ENTRY

Sl.No | Farmer | Survey | Crop | Extent
1 | Kannan A | 63-1 | Cotton | 0.74 |  | Crop Group | CROPS | CROPS | CROPS | CROPS | CROPS | CROPS | CROPS | CROPS
 |  | 28-1 | Maize | 1.52 |  | Paddy | Paddy
 |  | 61-4 | Sugarcane | 1.25 |  | Cotton | Cotton
 |  | 68-2 | Black Gram | 0.52 |  | Pulses | [NAME] | Black Gram
 |  | 61-7 | [NAME] | 0.52 |  | Millets | Horsegram | Horsemillet | Maize
 |  | 63-A | Black Gram | 0.52 |  | Oilseeds | Gingelly | sunflower | palm
 |  | 61-4 | [NAME] | 0.52 |  | Others | Brinjal | Ladys finger | [NAME] | potato
 |  | 63-8 | Black Gram | 0.52
 |  | 61-4 | [NAME] | 0.52
 |  | 63-4 | Black Gram | 0.52
2 | [NAME] | 111-6 | [NAME] | 0.77
 |  | 55- | [NAME] | 2.4
3 | S.Chandrasekararajulu | 35-2 | [NAME] | 0.88
4 | Koussalya A | 19-1 | Cotton | 0.5
 |  | 34-1 | Maize | 1.54
 |  | 18-2 | Black Gram | 0.7
 |  | 95- | Maize | 1.92
 |  | 50-3 | Makka | 0.8
5 | Gurusamy M | 54-4 | Makka | 1.06
6 | J Jeyaseela | 23-2 | Black Gram | 0.21
 |  | 23-2 | [NAME] | 0.21
7 | [NAME] | 110-8 | maize | 0.89
8 | [NAME] | 101- | maize | 1.8
 |  | 102- | [NAME] | 0.2
 |  | 101- | Black Gram | 0.8