tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 106013d1303247701-merge-2-sheets-with-common-id-column-add2sheetsby-id2
Sheet: Sheet3

Combined Both Sheets | Sht1 | Sht2
1 | Stuff1 | Others1 |  | The combined column needs
2 | Stuff2 | Others2 |  | to be all ID's from both and
3 | Stuff3 | Others3 |  | then delete duplicates.
4 | Stuff4 | Others4
5 | Stuff5 | Others5
6 | Stuff6 | Others6
7 | Stuff7 | Others7
8 | Stuff8 | Others8
9 | Stuff9 | Others9
10 |  | Others10
11 |  | Others11
12
13
Spreadsheet: 69195d1269706793-find-4-consecutive-occurrences-re-swab-report
Sheet: SWABS 2010

Environmental Swab Re-testing
Date of Original Positive Swab | Complete? | Sample | Test | Swab Site |  | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th
 | Yes or No | code | point # | [NAME] | AREA | Re-test Date and Result | Re-test Date and Result | Re-test Date and Result | Re-test Date and Result | Re-test Date and Result | Re-test Date and Result | Re-test Date and Result | Re-test Date and Result | Re-test Date and Result | Re-test Date and Result | Re-test Date and Result | Re-test Date and Result | Re-test Date and Result
2010-02-26 00:00:00 | No | 2010-02-26 00:00:00 | 11 | TEST AREA 1 | Investigate | 3/3 N | 3/13 N | 3/19 N | 3/27 N |  |  |  |  |  |  |  |  |  |  |  | Investigate
2010-03-06 00:00:00 | No | 2010-03-06 00:00:00 | 20 | TEST AREA 2 | Investigate | 3/13 N | 3/19 N |  |  |  |  |  |  |  |  |  |  |  |  |  | Packaging/Pasteurized
2010-03-13 00:00:00 | No | 2010-03-13 00:00:00 | 18 | TEST AREA 3 | Raw/Inedible | 3/19 P |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Raw/Inedible
2010-03-19 00:00:00 | No | 2010-03-19 00:00:00 | 19 | TEST AREA 4 | Raw/Inedible |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Warehouse/Traffic
 |  |  |  |  | XXXX
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 21

कार्यक्रम PROGRAM |  |  | एसडब्ल्यूओ के  तलए [NAME] कार्यक्रम - पााँचर्ााँ चरण 5th PHASE OF INDUCTION TRAINING FOR SWOs | PROGRAM CODE
 |  |  |  | IT 1054
तर्षर् समूह/ SUBJECT GROUP |  |  | HR, MARKETING, CUSTOMER SERVICE & COMPLIANCE
उद्देश्य/OBJECTIVE |  |  | TO IMPART TECHNOLOGY SKILLS, AND JOB KNOWLEDGE TO ENABLE     PARTICIPANTS     TO     PERFORM     THE     DUTIES EFFECTIVELY
लतक्षि समूह/TARGET GROUP |  |  | SWOs
अर्तध/DURATION |  |  | 1 WEEK (5 DAYS)
DAY | SESSION | CONTENTS
Day 1 | I | Registration/Inauguration and Entry Test
 | II | Financial Statement Analysis/Ratio Analysis
 | III & IV | Case study on Financial Statement/Ratio Analysis
Day 2 | I & III | Working Capital Assessment – Case Study
 | III & IV | Term Loan Assessment with case study
Day 3 | I | Follow-up, Supervision & Monitoring of advances
 | II | Disbursement,   Analysis   of   Stock   Statement,   Drawing   Power Calculation
 | III & IV | Legal Aspects of Documentation  & Mortgage
Day 4 | I | Introduction to Agriculture Lending – Various Products of the Bank
 | II | Govt. Sponsored Schemes &Case Study on KCC/KOD
 | III | Session on Official Language Guidelines
 | IV | Session on Motivation and Team Management
Day 5 | I | Recovery  Management/  IRAC  Norms/SMA  concept/Legal  and  Non Legal Recovery Measures
 | II | SARFAESI and OTS (Case study on Settlement)
 | III | Preventive Vigilance
 | IV | Valediction
Spreadsheet: 91132d1290832124-index-match-to-get-desired-bonus-based-on-2-criteria-copy-of-bonus
Sheet: Sheet1

Date | Line # | UPH | UPH/PP | Total Units | Hours | Pickers | Errors | Comments | Bonus | Hours/Line
2010-12-01 00:00:00 | 1 | 4000 | 800 | 32000 | 8 | 5 | 0 |  | 0 | 40
 | 2 | 4250 | 850 | 34000 | 8 | 5 | 1 |  | 0 | 40 |  |  | Errors | Bonus | UPH/PP
 | 3 | 5187.5 | 1037.5 | 41500 | 8 | 5 | 2 |  | 1 | 40 |  |  | 0 | 0 | 0 |  |  |  |  | 0
 | 4 | 4625 | 925 | 37000 | 8 | 5 | 0 |  | 2 | 40 |  |  | 0 | 1 | 832 |  |  |  |  | 832
 | 5 | 5250 | 1050 | 42000 | 8 | 5 | 0 |  | 3 | 40 |  |  | 0 | 2 | 910 |  |  |  |  | 910
 | 6 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 | 3 | 993 |  |  |  |  | 993
 | 7 | 4562.5 | 912.5 | 36500 | 8 | 5 | 1 |  | 1 | 40 |  |  | Errors | Bonus | UPH/PP |  |  | 910 |  | #N/A
 | 8 | 4375 | 875 | 35000 | 8 | 5 | 0 |  | 1 | 40 |  |  | 1 | 0 | 0 |  |  | 3 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 832 |  |  |  |  | #N/A
 | 1 | 4000 | 800 | 32000 | 8 | 5 | 0 |  | 0 | 40 |  |  | 1 | 1 | 910
 | 2 | 4250 | 850 | 34000 | 8 | 5 | 1 |  | 0 | 40 |  |  | 1 | 2 | 993
 | 3 | 5187.5 | 1037.5 | 41500 | 8 | 5 | 2 |  | 1 | 40 |  |  | Errors | Bonus | UPH/PP
 | 4 | 4625 | 925 | 37000 | 8 | 5 | 0 |  | 2 | 40 |  |  | 2 | 0 | 0
 | 5 | 5250 | 1050 | 42000 | 8 | 5 | 0 |  | 3 | 40 |  |  | 2 | 0 | 832
 | 6 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 2 | 0 | 910
 | 7 | 4562.5 | 912.5 | 36500 | 8 | 5 | 1 |  | 1 | 40 |  |  | 2 | 1 | 993
 | 8 | 4375 | 875 | 35000 | 8 | 5 | 0 |  | 1 | 40 |  |  | Errors | Bonus | UPH/PP
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0+
 | IF(VALUE($C2)=0,"",IF($H2>=3,0,INDEX(OFFSET($O$4,$H2*5,0,4,1),(MATCH(D2,OFFSET($P$4,$H2*5,0,4,1),1)))))
 |  |  |  | 0 | 0 |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 90244d1290002592-data-all-over-the-sheet-to-be-cleaned-prepforpivot
Sheet: Pivot Table List

Number | Name | Amount | Group
111111111 | [NAME] | 200 | AAA
111111111 | [NAME] | 300 | AAA
222222222 | [NAME] | 400 | AAA
333333333 | Jake | 255 | AAA
444444444 | [NAME] | 200 | AAA
555555555 | [NAME] | 300 | AAA
666666666 | [NAME] | 400 | AAA
777777777 | Pauline | 200 | AAA
666666666 | [NAME] | 300 | AAA
888888888 | Timmy | 400 | AAA
999999999 | [NAME] | 255 | AAA
777777777 | Pauline | 200 | BBB
666666666 | [NAME] | 300 | BBB
888888888 | Timmy | 400 | BBB
999999999 | [NAME] | 255 | BBB
777777777 | Pauline | 200 | BBB
666666666 | [NAME] | 6554 | BBB
888888888 | Timmy | 554 | BBB
999999999 | [NAME] | 255 | BBB
111111111 | [NAME] | 200 | CCC
111111111 | [NAME] | 300 | CCC
222222222 | [NAME] | 400 | CCC
333333333 | Jake | 255 | CCC
111111111 | [NAME] | 200 | CCC
111111111 | [NAME] | 300 | CCC
222222222 | [NAME] | 400 | CCC
333333333 | Jake | 255 | CCC
444444444 | [NAME] | 200 | CCC
555555555 | [NAME] | 300 | CCC
666666666 | [NAME] | 400 | CCC
777777777 | Pauline | 200 | CCC
666666666 | [NAME] | 300 | CCC
888888888 | Timmy | 400 | CCC
999999999 | [NAME] | 255 | CCC
777777777 | Pauline | 200 | DDD
666666666 | [NAME] | 300 | DDD
888888888 | Timmy | 400 | DDD
999999999 | [NAME] | 255 | DDD
777777777 | Pauline | 200 | DDD
666666666 | [NAME] | 6554 | DDD
888888888 | Timmy | 554 | DDD
999999999 | [NAME] | 255 | DDD
111111111 | [NAME] | 200 | DDD
111111111 | [NAME] | 300 | DDD
222222222 | [NAME] | 400 | DDD
333333333 | Jake | 255 | DDD
Spreadsheet: 818632d1676977693-calculate-downtime-per-week-month-year-sample-test_v1
Sheet: Sheet1

 | Repair Start YEAR | Repair Start MONTH | Repair Start WEEK | Repair Start Date | Repair Start Time |  | Repair End YEAR | Repair End MONTH | Repair End WEEK | Repair End Date | Repair End Time |  | Start | End | Total Hours | Downtime Hours TOTAL
Example 1 |  |  |  | 2023-09-02 00:00:00 | 11:40:00 |  |  |  |  | 2023-10-02 00:00:00 | 13:00:00
Example 2 |  |  |  | 2023-02-04 00:00:00 | 07:58:04 |  |  |  |  | 2023-02-07 00:00:00 | 08:58:04
Example 3 |  |  |  | 2022-12-31 00:00:00 | 01:00:00 |  |  |  |  | 2023-01-03 00:00:00 | 02:00:00
Example 1 |  |  | Example 2 |  |  |  | Example 3
Downtime MONTH 9 | 22 days, 16:20:00 |  | Downtime MONTH 2 | 2 days, 10:00:00 |  |  | Downtime MONTH 12 (2022) | 23:00:00
Downtime MONTH 10 | 1 day, 3:00:00 |  | Downtime WEEK 5 | 1 day, 11:01:56 |  |  | Downtime MONTH 1 (2023) | 1 day, 14:00:00
Downtime WEEK 35 | 1 day, 7:20:00 |  | Downtime WEEK 6 | 22:58:04 |  |  | Downtime WEEK 52 (2022) | 23:00:00
Downtime WEEK 36 | 5 days, 13:00:00 |  |  |  |  |  | Downtime WEEK 1 (2023) | 1 day, 14:00:00
Downtime WEEK 37 | 5 days, 13:00:00
Downtime WEEK 38 | 5 days, 13:00:00
Downtime WEEK 39 | 5 days, 13:00:00
Downtime WEEK 40 | 8:00:00
Spreadsheet: 844590d1696357083-xlookup-with-multiple-if-criteria-cc-kpi-test
Sheet: CC KPI

Platform | Acc Status | Card Opened | Card Closed | Card No | Name | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00
 | Closed | 2015-07-15 00:00:00 | 2023-07-05 00:00:00 | 1234 | HoneyCrisp | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | must be formula here
 | Open | 2015-11-17 00:00:00 |  | 5678 | Braeburn | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Open | 2022-11-01 00:00:00 |  | 9876 | Pink Lady | must be formula here |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1
 | Closed | 2022-12-01 00:00:00 | 2023-06-05 00:00:00 | 5432 | Golden Delicious | must be formula here |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Requirments
 |  | Before the card is open - return blank
 |  | After the card is closed - return blank (unless there is spend but should be none)
 |  | Between the dates that the card is opened and closed, but the lookup returns nothing, then "0"
 |  | Should look like the above example
 |  | If a card has no spend, it will not appear in that month, but as long as the card is open according to B & C then it must show 0 despite not appearing in the statement.
 |  | Example March, [NAME] does not appear, but should still return 0
 |  | =IF($G$1>C3,XLOOKUP(E3&F3,'Aug 22'!$A$1:$A$2&'Aug 22'!$B$1:$B$2,'Aug 22'!$C$1:$C$2,0),"")
 |  | My formula will return blank if the header date is before the card opened date, return 0 if there is no spend in the month, but I can't expand on it to return blank when the card is shut
Spreadsheet: 691412d1597682528-need-count-sum-formula-based-on-three-3-criteria-rawdata
Sheet: Data

Raw Data |  |  |  |  |  | Unique Account (to be achieved with formula)
nv | Date (EOM) | Type | State | Count |  | Date (EOM) | Type | State | Count |  | Date (EOM) | Type | State | Sum of Count
2020-01-08 00:00:00 |  | A | FL | 1 |  |  |  |  |  |  | 31-Jan | A | FL | 1
2020-01-15 00:00:00 |  | C | FL | 1 |  |  |  |  |  |  | 31-Jan | A | TX | 1
2020-01-23 00:00:00 |  | C | FL | 1 |  |  |  |  |  |  | 31-Jan | B | CA | 1
2020-01-27 00:00:00 |  | B | CA | 1 |  |  |  |  |  |  | 31-Jan | B | TX | 1
2020-01-27 00:00:00 |  | C | CA | 1 |  |  |  |  |  |  | 31-Jan | C | CA | 3
2020-01-30 00:00:00 |  | C | CA | 1 |  |  |  |  |  |  | 31-Jan | C | FL | 2
2020-01-31 00:00:00 |  | C | CA | 1 |  |  |  |  |  |  | 31-Jan | D | TX | 2
2020-01-17 00:00:00 |  | B | TX | 1 |  |  |  |  |  |  | 29-Feb | A | CA | 1
2020-01-19 00:00:00 |  | A | TX | 1 |  |  |  |  |  |  | 29-Feb | B | CA | 2
2020-01-25 00:00:00 |  | D | TX | 1 |  |  |  |  |  |  | 29-Feb | B | FL | 1
2020-01-28 00:00:00 |  | D | TX | 1 |  |  |  |  |  |  | 29-Feb | C | CA | 1
2020-02-01 00:00:00 |  | A | CA | 1 |  |  |  |  |  |  | 29-Feb | C | TX | 2
2020-02-03 00:00:00 |  | C | CA | 1 |  |  |  |  |  |  | 29-Feb | D | FL | 4
2020-02-04 00:00:00 |  | B | CA | 1 |  |  |  |  |  |  | 29-Feb | E | CA | 1
2020-02-07 00:00:00 |  | B | CA | 1 |  |  |  |  |  |  | Grand Total |  |  | 23
2020-02-11 00:00:00 |  | E | CA | 1
2020-02-12 00:00:00 |  | B | FL | 1
2020-02-12 00:00:00 |  | D | FL | 1
2020-02-15 00:00:00 |  | D | FL | 1
2020-02-21 00:00:00 |  | D | FL | 1
2020-02-22 00:00:00 |  | D | FL | 1
2020-02-23 00:00:00 |  | C | TX | 1
2020-02-24 00:00:00 |  | C | TX | 1
Spreadsheet: 172833d1344351498-can-the-if-function-leave-a-cell-empty-book1
Sheet: Sheet1

Data A | Data B | Formula 1 | Formula 2
1 | 4 |  | 0
1 | 4 |  | 0
1 | 4 |  | 0
1 | 1 | 1
1 | 1 | 1
2 | 1 |  | 0
2 | 1 |  | 0
2 | 1 |  | 0
2 | 2 | 1
2 | 2 | 1
3 | 2 |  | 0
3 | 2 |  | 0
3 | 2 |  | 0
3 | 3 | 1
3 | 3 | 1
4 | 3 |  | 0
4 | 3 |  | 0
4 | 3 |  | 0
4 | 4 | 1
Spreadsheet: darrell_schoolcraft__7317__imball0202
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 348740 | 348593 | 44952 | 39832 | 34864 | 38368 | 138449 | 132994 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 326868 | 331402 | 44933 | 40489 | 36801 | 38316 | 105582 | 103708 |  |  |  | [NAME] |  |  | -34361 |  | 25006
3 | 327137 | 330848 | 45018 | 40410 | 34501 | 39399 | 111726 | 105510 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 | 327600 | 330450 | 31087 | 40426 | 42627 | 39399 | 126063 | 126994 |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 | 305375 | 307821 | 35408 | 35617 | 42536 | 40399 | 135758 | 134714 |  |  |  | 2001-02-01 00:00:00 | 15256233 | 15290953 |  | 5.61
6 | 328360 | 331758 | 32048 | 35617 | 44703 | 37058 | 132131 | 131043 |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 |  |  |  |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 |  |  |  |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 |  |  |  |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.58
10 |  |  |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 |  |  |  |  |  |  |  |  |  |  |  | 2001-08-01 00:00:00 | 17850737 | 17815859 |  | 2.61
12 |  |  |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 16552948 | 16508018 |  | 1.73
13 |  |  |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 | 17924814 | 17872479 |  | 2.06
14 |  |  |  |  |  |  |  |  |  |  |  | 2001-11-01 00:00:00 |  |  |  | 1.98
15 |  |  |  |  |  |  |  |  |  |  |  | 2001-12-04 00:00:00
16
17
18
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.98
20 |  |  |  |  |  |  |  |  |  |  |  |  | 1378106 | 1316146
21 |  |  |  |  |  |  |  |  |  |  |  |  | 9216070 | 9272400
22 |  |  |  |  |  |  |  |  |  |  |  |  | 3546065 | 3512740
23 |  |  |  |  |  |  |  |  |  |  |  |  | 1623705 | 1620245
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  | 3060
2002-02-06 00:00:00
CBS Dollars
 |  |  | 6334
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
 |  |  | 2444.99
 |  |  | 250
Spreadsheet: 59057d1259461253-dynamic-pivot-chart-based-on-pivot-table-pivot-table-_chart
Sheet: Data

S.No | [NAME] | Value Date | Description | Cr/Dr | Dr.Amt | Cr.Amt | Bal
1 | SB9946 | 19/10/2006 | By Cash | Cr |  | 100 | 100
2 | SB9989 | 20/10/2006 | By Other income | Cr |  | 1500 | 1600
3 | SB4659 | 2006-05-11 00:00:00 | To Water Expenses | Dr | 1000 |  | 600
4 | SB4494 | 2006-06-11 00:00:00 | By Other income | Cr |  | 100 | 700
5 | SB4624 | 2006-09-11 00:00:00 | To Printing Expenses | Dr | 300 |  | 400
6 | SB4772 | 14/11/2006 | To Printing Expenses | Dr | 300 |  | 100
7 | SB4976 | 24/11/2006 | By Cash | Cr |  | 1100 | 1200
8 | SB5679 | 27/11/2006 | By Other income | Cr |  | 400 | 1600
9 | SB7337 | 2006-12-12 00:00:00 | To Electricity Expenses | Dr | 300 |  | 1300
10 | SB3333 | 18/12/2006 | By Cash | Cr |  | 2000 | 3300
 |  |  |  | TOTAL | 1900 | 5200 | 10900
Spreadsheet: 745194d1629801940-conditional-formatting-duplicates-within-rows-and-text-matches-in-a-table-sample-schedule
Sheet: Approved People

Name | Host | Media | Attendant |  |  | [NAME] |  | Zoom Media |  | [NAME]
Person 01 | ✔ | ✔ | ✔ |  |  | Person 01 |  | Person 01 |  | Person 01
Person 02 | ✔ | ✔ | ✔ |  |  | Person 02 |  | Person 02 |  | Person 02
Person 03 | ✔ | ✔ | ✔ |  |  | Person 03 |  | Person 03 |  | Person 03
Person 04 | ✔ | ✔ | ✔ |  |  | Person 04 |  | Person 04 |  | Person 04
Person 05 |  |  | ✔ |  |  | Person 08 |  | Person 08 |  | Person 05
Person 06 |  |  | ✔ |  |  | Person 09 |  | Person 09 |  | Person 06
Person 07 |  |  | ✔ |  |  | Person 11 |  | Person 11 |  | Person 07
Person 08 | ✔ | ✔ |  |  |  | Person 12 |  | Person 12 |  | Person 09
Person 09 | ✔ | ✔ | ✔ |  |  | Person 13 |  | Person 13 |  | Person 10
Person 10 |  |  | ✔ |  |  | No Assignment |  | No Assignment |  | Person 11
Person 11 | ✔ | ✔ | ✔ |  |  |  |  |  |  | Person 12
Person 12 | ✔ | ✔ | ✔ |  |  |  |  |  |  | Person 13
Person 13 | ✔ | ✔ | ✔ |  |  |  |  |  |  | No Assignment
Spreadsheet: 808981d1670831569-finding-average-for-last-5-10-games-closing-line-76ers
Sheet: Sheet3

Models | qty |  |  | Models | Number
Model1 | 109 |  |  | Model5 | 2
Model1 | 374
Model1 | 376
Model1 | 269
Model1 | 308
Model1 | 339
Model1 | 155
Model2 | 283
Model2 | 375
Model2 | 274
Model2 | 474
Model2 | 223
Model3 | 141
Model3 | 412
Model3 | 32
Model3 | 13
Model3 | 21
Model4 | 445
Model4 | 62
Model4 | 373
Model4 | 112
Model5 | 25
Model5 | 256
Model5 | 462
Model5 | 103
Model6 | 377
Model6 | 301
Model6 | 403
Model6 | 275
Model7 | 178
Model7 | 98
Model7 | 240
Model7 | 210
[NAME]
{=AVERAGE(IF(IF($A$2:$A$34=E2,ROW($A$2:$A$34)-1,"")<>"",IF(IF($A$2:$A$34=E2,ROW($A$2:$A$34)-1)>=LARGE(IF($A$2:$A$34=E2,ROW($A$2:$A$34)-1),F2),$B$2:$B$34,""),""))}
Spreadsheet: 3e63091a-1f30-4aaf-aa50-baf6709dc863
Sheet: Sheet1

Substance Abuse Entity Inventory | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  | Federal Substance Abuse Entity Inventory |  |  |  |  |  |  | State Substance Abuse Entity Inventory |  | Total
 |  |  | SAPT Block Grant For Prevention Services |  | SAPT Block Grant for Women's Services |  |  | SAPT Other Services | Total | State Funds | Total
 |  | Total
Spreadsheet: 683283d1592591963-time-card-calculation-time_card2c-revised
Sheet: Flex Employee

Employee: |  |  |  |  |  |  |  |  |  |  | Year | 2020 |  |  |  |  |  |  |  |  |  |  |  |  | OPTIONS |  | OVERTIME OPTIONS
Employee Number: |  |  |  |  |  |  |  |  |  |  | Month |  |  |  |  |  |  | Su | M | [NAME] | W | Th | F | Sa | YES | DAILY | YES
Cost Center: |  |  |  | DEPT. # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | AFTER | 8 | HRS
SUPERVISOR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BREAK TIME | WEEKLY | YES
WEEK STARTING: | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | AFTER | 40 | HRS
WEEK ENDING: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
Day of Week | Time In | Time In 2 | [NAME] (minutes) | Time Out | Time Out 2 | Total Hours hide | Total Hours | Regular Hours hide | Regular Hours | Overtime | Overtime | Sick Time Hrs | Sick Time Hrs. hide | Holiday Hrs. | Holiday Hrs. hide | Vacation Hrs. | Vacation Hrs. hide |  |  |  |  |  |  |  | 45
 |  | hidden |  |  | hidden |  |  |  |  | Hours hide | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 | 0700 |  | 30 | 1530
 | 0700 |  | 30 | 1537
 | 0700 |  | 30 | 1555
 |  |  |  | Total  Hrs.
 |  |  |  | Total  Hrs.
TOTAL HOURS WORKED: |  |  |  | Biweekly Total  Hrs.
Grand Total Pay: |  |  |  |  |  |  | Rate / Hour: |  | 52
Grand Total Pay w/ Shift Differential: |  |  |  |  |  |  | Total Pay:
Spreadsheet: joe_parks__14620__POSTIONTRAX_NOV
Sheet: POSTION

 | MTM |  | POSTION | ROLL OFF | NEW DEAL | MTM | NET |  | ROLLOFF VALUE |  | change | PRIOR POSTION | CHANGE
 | 2.637 | DEC |  |  |  |  |  |  |  | 2.676 |  | -46.5 |  | 2001-06-01 00:00:00
 |  | JAN |  |  |  |  |  |  |  | 2.884 |  | -9.3 |  | 2001-06-02 00:00:00
 |  | FEB |  |  |  |  |  |  |  | 2.932 |  | -3.1 |  | 2001-06-03 00:00:00
 |  | MAR |  |  |  |  |  |  |  | 2.924 |  | 0 |  | 2001-06-04 00:00:00
 |  | Z-H |  |  |  |  |  |  |  | 2.854 |  | 0 |  | 2001-06-05 00:00:00
 |  | J-V |  |  |  |  |  |  |  | 3.031 |  | 1
 |  | CAL2 |  |  |  |  |  |  |  | 3.074 |  | 2
 |  | HH_SWAP |  |  |  |  |  |  | 1.72 | 2.28 |  | -69.7 |  | 2001-06-06 00:00:00
 |  | HSC_SWAP |  |  |  |  |  |  | 1.58 | 2.25 |  | 0 |  | 2001-06-07 00:00:00
 |  | KATY_SWAP |  |  |  |  |  |  |  | 2.2 |  | 15.5 |  | 2001-06-08 00:00:00
 |  | WAHA_SWAP |  |  |  |  |  |  | 1.385 | 1.98 |  | 0 |  | 2001-06-09 00:00:00
 |  | [NAME] |  |  |  |  |  |  |  | 2.065 |  | 0 |  | 2001-06-10 00:00:00
 |  | KATY_PHYS |  |  |  |  |  |  |  | 2.2 |  | 58.9 |  | 2001-06-11 00:00:00
 |  | TOTAL |  |  |  |  |  |  |  |  |  | -54.2 |  | 2001-06-12 00:00:00
 |  | [NAME]_ AUG |  |  |  |  |  |  |  |  |  | 0 |  | 2001-06-13 00:00:00
 |  | HH_AUG | KA |  |  |  |  |  | 3.447 |  |  | 0 |  | 2001-06-14 00:00:00
 |  | Hsc_AUG |  |  | basis |  |  |  | 3.51 |  |  | 0 |  | 2001-06-15 00:00:00
 |  |  |  |  |  |  |  |  | 3.475 |  |  |  |  | 2001-06-16 00:00:00
 |  | TOTAL |  |  |  |  |  |  | 3.39 |  |  | 75.65 |  | 2001-06-17 00:00:00 | 25000
 |  |  |  |  |  |  |  |  | 3.39 |  |  |  |  | 2001-06-18 00:00:00 | 25000
 |  | NUMBER OF DAYS |  | 14 | 1 |  |  |  | 3.475 |  |  |  |  | 2001-06-19 00:00:00 | 25000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-06-20 00:00:00 | 25000
 |  |  |  |  |  |  |  | PRIOR |  |  |  |  |  | 2001-06-21 00:00:00 | 25000
 |  | 2001-12-01 00:00:00 | 2.637 |  |  |  |  | 3.397 |  |  |  |  |  | 2001-06-22 00:00:00 | 25000
1 | 3.446 | 2002-01-01 00:00:00 | 2.85 |  |  |  | 2.552 | 2.369 |  |  |  |  |  | 2001-06-23 00:00:00 | 25000
2 | 3.397 | 2002-02-01 00:00:00 | 2.903 |  |  |  | 2.902 | 2.753 |  |  |  |  |  | 2001-06-24 00:00:00 | 25000
3 | 3.422 | 2002-03-01 00:00:00 | 2.898 |  |  |  | 3.252 | 3.125 |  |  |  |  |  | 2001-06-25 00:00:00 | 25000
 |  | 2002-04-01 00:00:00 | 2.878 |  |  |  | 3.422 | 3.303 |  |  |  |  |  | 2001-06-26 00:00:00 | 25000
 |  | 2002-05-01 00:00:00 | 2.921 |  |  |  | 3.394 | 3.28 |  |  |  |  |  | 2001-06-27 00:00:00 | 25000
 |  | 2002-06-01 00:00:00 | 2.966 |  |  |  | 3.325 | 3.215 |  |  |  |  |  | 2001-06-28 00:00:00 | 25000
 |  | 2002-07-01 00:00:00 | 3.009 |  |  |  | 3.232 | 3.125 |  |  |  |  |  | 2001-06-29 00:00:00 | 25000
 |  | 2002-08-01 00:00:00 | 3.052 |  |  |  | 3.252 | 3.15 |  |  |  |  |  | 2001-06-30 00:00:00 | 25000
 |  | 2002-09-01 00:00:00 | 3.064 |  |  |  | 3.285 | 3.185 |  |  | ,30 |  |  |  | 25000
 |  | 2002-10-01 00:00:00 | 3.104 |  |  |  | 3.325 | 3.225
 |  | 2002-11-01 00:00:00 | 3.297 |  |  |  | 3.362 | 3.262
 |  | 2002-12-01 00:00:00 | 3.495 |  |  |  | 3.36 | 3.26
 |  |  |  |  |  |  | 3.372 | 3.272
 |  |  |  |  |  |  | 3.532 | 3.432
 |  |  |  |  |  |  | 3.695 | 3.595
Spreadsheet: 869295d1715882216-how-to-get-a-summary-of-total-expenses-nuwara-eliya-project-expenses
Sheet: Total Expenses

Total Expenses
Date | Description | Amount
2024-05-08 00:00:00 | Fuel-Anuruddha
2024-05-08 00:00:00 | Fuel-Dinesh
2024-05-08 00:00:00 | Food
2024-05-08 00:00:00 | Legal Fees
2024-05-08 00:00:00 | Commission
2024-05-09 00:00:00 | Fuel-Anuruddha
2024-05-09 00:00:00 | Fuel-Dinesh
Spreadsheet: 104623d1302161380-searching-data-through-out-the-worksheet-stock-statement-on-7-4-2011
Sheet: SHEETS

S.No | [NAME] | SIZE | SERIAL NO | QTY
1 | Subtex Ceiling Tiles | 595mm X 595 mm/ 15mm TH |  | 54
2 | Armstrong Ultra Black Sheets | 2/2   600 X 600 X20mm |  | 30
3 | Armstrong Ultra Black Sheets  with Cloth | 2/2 600 X 600 X20mm |  | 12
4 | Armstrong Optra Black Sheets | 1200X600X15mm  4x2 |  | 16
5 | Armstrong optra black | 1200 x 600 x 20mm |  | 9
6 | Metro SR 03, SH-285 | 31mts |  | 1
7 | Finlay 12 SR-19 Cloth | 31mts |  | 1
8 | [NAME] pf 10x50 Glasswool (1 reel) | 100095x50mm |  | 36mts
9 | [NAME] pf 10x50 Glasswool (1 reel) |  |  | 2reels
 | BACK
Spreadsheet: 688104d1595573013-vlookup-from-2-different-points-to-return-value-from-different-sheets-sample
Sheet: Monday

 |  |  |  | carrier
 |  | Truck 01 |  | aaaa
 |  | Truck 02 |  | bbbb
 |  | Truck 03 |  | aaaa
 |  | Truck 04 |  | dddd
 |  | Truck 05 |  | rrrrr
 |  | Truck 06 |  | aaaa
 |  | Truck 07 |  | abc123
 |  | Truck 08
 |  | Truck 09 |  | abc123
 |  | Truck 10 |  | dddd
 |  | Truck 11
 |  | Truck 12 |  | abc123
 |  | Truck 13
 |  | Truck 14 |  | bbbb
 |  | Truck 15
 |  | Truck 16 |  | aaaa
 |  | Truck 17
 |  | Truck 18 |  | aaaa