tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 864839d1711983370-lookup-and-compare-part-numbers-and-quantities-from-2-sheets-sample-lookup
Sheet: Work Instructions

Part Number | Description | QTY | I-BOM Level 3  Part number | UAE2 BOM Part Number | UAE2 BOM Qty | BOM Qty Check
3879363C91 | CROSS MEMBER, RAD SUPT, LOWER ASSY | 1
3612451C93 | CROSS MEMBER, RAD SUPT, ASSY | 1
3877045C91 | SUPPORT, BRACKET WINCH | 1
30745R2 | BOLT, HEX FLG HD M12 X 35 | 4
28423R1 | WASHER FLAT 1/2""X1 3/8""X5/32 | 4
30755R1 | NUT, M12 FLANGED PHC TYPE 10 | 4
3861672C1 | CROSS MEMBER, RAD SUPT, UPPER ASSY | 1
3554702C1 | BOLT, HVY HEX FLG, M12 X 30, CL 10.9, TM | 2
3535858C1 | BOLT, HEX FLG HD METRIC* M12-1.75 X 40 | 6
3886080C1 | ELBOW,90 DEG-SAE ¾-16 W/FLARE TO ¼-18 NP | 2
312064C1 | ELBOW, FLARED TUBE*GIVE SIZE, 9 | 2
3507069C2 | ELBOW, PTC, 45 DEG ½ TUBE X 3/8 MPT | 2
3869541C1 | SUPPORT, [NAME], FRT | 2
31056R1 | BOLT, HEX FLG HD M8 X 30 10.9 PHC BLACK | 4
3544379C1 | NUT, HEX METRIC PREV TRQ M8 HEX FLANGE N | 4
Spreadsheet: 7140c93d-1b04-49bd-82f0-3f3d56e3736e
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
District Police Department | 1 | Increase Enforcement | None | -- Pick One -- | 1.1.r1 | New Positions | OnGoing | 602199 | 0 | 602199 | 0 | 602199 | 0 | 0 | 0
District Police Department | 1 | Increase Enforcement | None | -- Pick One -- | 1.1.r2 | New Vehicles | OneTime | 60000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
District Police Department | 2 | Add lighting and new cameras | None | -- Pick One -- | 2.1.r1 | Lights/Cameras | OneTime | 8000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
District Police Department | 3 | Update the web-site | None | -- Pick One --
Spreadsheet: 9c607612-5fae-43b5-86af-d140449b7e8a
Sheet: Sheet1

CERTIFICATION TEST PASS RATES*  ([NAME] and Updated 11/7/11)
 | COMPLETION YEAR 2005 |  |  |  |  |  | COMPLETION YEAR 2006 |  |  |  |  |  | COMPLETION YEAR 2007 |  |  |  |  |  | COMPLETION YEAR 2008 |  |  |  |  |  | COMPLETION YEAR 2009 |  |  |  |  |  | COMPLETION YEAR 2010 |  |  | COMPLETION YEAR 2011
 | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | FINAL |  |  | FINAL
Name of Test | Tests Taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate
Theatre Arts (Secondary) *Last 2006* | 1 | 0 |  | 1 | 0 |  | 3 | 2 |  | 3 | 2 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Theatre EC-12 *First 2006* | - | - | - | - | - | - | - | - | - | - | - | - | 1 | 1 |  | 1 | 1 |  | 1 | 1 |  | 1 | 1 | 1 | 2 | 2 | 1 | 2 | 2 | 1 | 2 | 2 | 1 | - | - | -
*Data obtained from Texas Education Agency's Accountability System for Educator Preparation (ASEP) report on pass rates sorted by Test.
*2010 Texas Education Agency starting using one yearly pass rate.
Spreadsheet: 229203d1366325108-how-do-i-take-a-two-digit-number-separate-the-two-digits-add-them-together-show-result-opc-code-algorythm-daddylonglegs
Sheet: Sheet2

 |  | Barcode numbers > | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | Result
 | Products> | HMC1.67AS | 1 | 0 | 3 | 0 | 0 | 6 | 3 | 4 | 5
 |  | Manually calculated Algorithm result for each digit in the barcode |  |  |  |  |  |  |  |  |  | 5
 |  | Daddylonglegs formula result in this line
 |  | Multiplus XL-S 1.50 | 1 | 0 | 3 | 0 | 0 | 4 | 4 | 3 | 4
 |  | Manually calculated Algorithm result for each digit in the barcode |  |  |  |  |  |  |  |  |  | 9
 |  | Daddylonglegs formula result in this line
 |  | Visel 1.50 | 0 | 7 | 3 | 0 | 1 | 1 | 1 | 7 | 5
 |  | Manually calculated Algorithm result for each digit in the barcode |  |  |  |  |  |  |  |  |  | 5
 |  | Daddylonglegs formula result in this line
Spreadsheet: 683156d1592518672-removing-rows-that-do-not-meet-a-condition-to-avoid-duplication-sample-for-babywadhwa
Sheet: Sheet1

A | B
2020-04-05 00:00:00 | 5
2020-04-06 00:00:00 | 5
2020-04-10 00:00:00 | 5
2020-04-10 00:00:00 | 8
2020-04-10 00:00:00 | 9
2020-04-13 00:00:00 | 9
2020-04-10 00:00:00 | 12
2020-04-10 00:00:00 | 12
2020-04-10 00:00:00 | 9
2020-04-10 00:00:00 | 3
Spreadsheet: 479141d1473250995-time-overlapping-in-excel-version-2016-copy-of-admin-exp
Sheet: Sheet1

Solids |  |  |  |  |  |  |  | Total hours Worked
Name | T.S | T.E | Hours |  |  |  |  | Name | Hours
[NAME] | 09:00:00 | 09:20:00 |  |  |  |  |  | [NAME]
[NAME] | 13:00:00 | 13:45:00 |  |  |  |  |  | Power
[NAME] | 14:10:00 | 14:45:00 |  |  |  |  |  | Percy
[NAME] | 14:30:00 | 15:05:00 |  |  |  |  |  | Mark
[NAME] | 15:00:00 | 15:40:00 |  |  |  |  |  | Fred
[NAME] | 15:50:00 | 16:20:00 |  |  |  |  |  | [NAME]
Luyanda | 10:00:00 | 10:05:00
Luyanda | 10:09:00 | 12:45:00
[NAME] | 08:20:00 | 08:50:00
[NAME] | 09:31:00 | 10:30:00
[NAME] | 11:01:00 | 11:30:00
[NAME] | 11:30:00 | 12:15:00
[NAME] | 11:45:00 | 12:30:00
[NAME] | 15:30:00 | 16:00:00
Mark | 09:51:00 | 10:25:00
Mark | 10:00:00 | 11:00:00
Mark | 10:10:00 | 11:10:00
Mark | 11:00:00 | 11:25:00
Mark | 10:52:00 | 11:40:00
Mark | 11:30:00 | 12:15:00
Mark | 12:25:00 | 13:30:00
Mark | 12:30:00 | 13:25:00
Mark | 13:25:00 | 14:10:00
Power | 08:10:00 | 08:25:00
Power | 09:10:00 | 11:00:00 |  | Overlap |  | 1.83 should be counted once
Power | 09:10:00 | 11:00:00
Power | 11:00:00 | 12:00:00 |  | Overlap |  | He was working from 11am to 1pm = 2 hours not 3
Power | 11:00:00 | 13:00:00
Power | 15:00:00 | 15:30:00 |  | Overlap |  | He was working from 3pm to 3:30 pm , 3pm to 3:20 should not be recorded
Power | 15:00:00 | 15:20:00
Power | 15:00:00 | 16:00:00 |  | Overlap |  | 30 minutes should be added here because he ended at 3:30 as above ^
Power | 14:00:00 | 14:45:00
Power | 15:00:00 | 16:00:00 |  | Overlap |  | This mixture was done at the same time as another, it should not be recorded.
Spreadsheet: 816974d1675929212-index-match-formula-error-across-2-files-test-file-1
Sheet: Sheet1

Date
2023-01-01 00:00:00
 | Month to Date |  |  |  | Year to Date
 | Actual | Budget | [NAME] |  | Actual | Budget | [NAME]
Case 1 | 100 |  |  |  | 1500
Case 2 | 125 |  |  |  | 2975
Case 3 | 50 |  |  |  | 2590
Spreadsheet: 218331d1362429446-lookup-a-value-and-display-all-data-multiple-rows-and-columns-fruits
Sheet: Sheet1

Fruit | Colors | Purchased | Cost per 1/1/13 | Total | Purchased | Cost per 1/2/13 | Total | Purchased | Cost per 1/2/13 | Total |  |  |  |  |  |  | 1
Apple | Green | 5 | 0.4 | 2 | 5 | 0.4 | 2 | 5 | 0.4 | 2
 | Yellow | 21 | 0.5 | 10.5 | 21 | 0.5 | 10.5 | 21 | 0.5 | 10.5
 | Red | 25 | 0.3 | 7.5 | 21 | 0.3 | 6.3 |  | 0.3 | 0
 | Blue |  | 0.36 | 0 | 21 | 0.36 | 7.56 | 6 | 0.36 | 2.16
 | [NAME] | 11 | 0.39 | 4.29 | 21 | 0.39 | 8.19 |  | 0.39 | 0
[NAME] | Green | 22 | 0.25 | 5.5 |  | 0.25 | 0 |  | 0.25 | 0
 | Yellow | 8 | 0.29 | 2.32 |  | 0.29 | 0 | 21 | 0.29 | 6.09
 | Blue |  | 0.36 | 0 | 21 | 0.36 | 7.56 | 6 | 0.36 | 2.16
 | [NAME] | 11 | 0.39 | 4.29 | 21 | 0.39 | 8.19 |  | 0.39 | 0
 | Enter Choice
 | 1
 | 2
Spreadsheet: 842135d1694188043-transform-certain-columns-to-rows-based-on-the-values-sample
Sheet: Sheet1

 |  |  |  |  | Question | Question | Question
Cat | Sub | Add | Add1 | Add2 | Percentage? | Time? | Effort?
Acct | Asst | SPB | [NAME] | Rep
Exp | [NAME] | LPB | [NAME] | InCo | 0 to 25%
Rev | CM | SPB | [NAME] | InCo | 50 to 75% | Planning | Analysis
Acct | Asst | SPB | [NAME] | Rep | 0 to 25% | Planning
Exp | [NAME] | LPB | [NAME] | InCo | 50 to 75% |  | Review
Rev | CM | SPB | [NAME] | InCo
Spreadsheet: 773986d1648143719-transpor-lines-columns-comb
Sheet: Planilha1

A | 1 | 4 | 9 | 10 | 15 |  |  |  | a | 1
B | 30 | 34 | 38 | 39 | 50 |  |  |  | a | 4
C | 102 | 110 | 122 | 134 | 160 |  |  |  | a | 9
D | 201 | 270 | 291 | 320 | 336 |  |  |  | a | 10
E | 420 | 428 | 456 | 488 | 521 |  |  |  | a | 15
 |  |  |  |  |  |  |  |  | b | 30
 |  |  |  |  |  |  |  |  | b | 34
 |  |  |  |  |  |  |  |  | b | 38
 |  |  |  |  |  |  |  |  | b | 39
 |  |  |  |  |  |  |  |  | b | 50
 |  |  |  |  |  |  |  |  | c | 102
 |  |  |  |  |  |  |  |  | c | 110
 |  |  |  |  |  |  |  |  | c | 122
 |  |  |  |  |  |  |  |  | c | 134
 |  |  |  |  |  |  |  |  | c | 160
 |  |  |  |  |  |  |  |  | d | 201
 |  |  |  |  |  |  |  |  | d | 270
 |  |  |  |  |  |  |  |  | d | 291
 |  |  |  |  |  |  |  |  | d | 320
 |  |  |  |  |  |  |  |  | d | 336
 |  |  |  |  |  |  |  |  | e | 420
 |  |  |  |  |  |  |  |  | e | 428
 |  |  |  |  |  |  |  |  | e | 456
 |  |  |  |  |  |  |  |  | e | 488
 |  |  |  |  |  |  |  |  | e | 521
Spreadsheet: 231504d1367098248-two-misaligned-cells-16-team-planning-bracket
Sheet: 170

az170 | Aztec | 1
bl170 | Bloomfield
[NAME] | Cibola
cle170 | Cleveland
far170 | Farmington
gal170 | Gallup
grt170 | Grants | 8
kc170 | [NAME]
[NAME] | Miyamura | 5
new170 | Newcomb
[NAME] | Piedra Vista
rr170 | Rio Rancho
sf170 | Santa Fe
ship170 | Shiprock
vv170 | [NAME] | 4
win170 | Wingate
 |  | 3
Paste Value - CTRL-N
 |  | 6
 |  | 7
 |  | 2
Spreadsheet: 696872d1601020700-sumproduct-with-indirect-mainsheet
Sheet: 6.FF

Particulars | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | FY-20 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | FY-21
Production Qty | 140
Production Cost
Material Cost
Fuel Cost
Power Cost | 30
Spreadsheet: 128551d1321040713-concatif-across-multiple-sheets-hours-test4upl
Sheet: Arnies Forman Ford

Unique ID | SSN | Employee  First Name | Employee  Last Name | Jan  Hours | Feb  Hours | Mar  Hours | April  Hours | May  Hours | June  Hours | July  Hours | Aug  Hours | Sept  Hours | Oct  Hours | Nov  Hours | Dec  Hours | Total Hours |  | Jan Pension | Feb Pension | [NAME] | Apr Pension | May Pension | Jun Pension | July Pension | August Pension | Sept Pension | Oct Pension | Nov  Pension | Dec  Pension | YTD  Pension | Arnies Forman Ford
ArringtonDa2269 | 2269 | [NAME] | [NAME] | 68.5 | 0 | 75.5 | 67.75 | 67 | 142 | 101.5 | 103.5 | 68 |  |  |  | 693.75 |  | 191.115 | 0 | 210.645 | 189.0225 | 186.93 | 396.18 | 283.185 | 288.765 | 189.72 | 0 | 0 | 0 | 1935.5625
 |  | Received Date |  | 2011-02-17 00:00:00 | 2011-03-17 00:00:00 | 2011-04-19 00:00:00 | 2011-09-19 00:00:00 | 2011-06-17 00:00:00 | 2011-07-18 00:00:00 | 2011-08-17 00:00:00 | 2011-09-19 00:00:00 | 2011-10-20 00:00:00
 |  | Check Date |  | 2011-02-15 00:00:00 | 2011-03-14 00:00:00 | 2011-04-14 00:00:00 | 2011-09-14 00:00:00 | 2011-06-15 00:00:00 | 2011-07-13 00:00:00 | 2011-08-15 00:00:00 | 2011-09-14 00:00:00 | 2011-10-12 00:00:00
 |  | Check Amount |  | 6852.25 | 5284.45 | 6766.45 | 7310.5 | 9040.15 | 8638.45 | 8256.25 | 7617.94 | 5430.04
 |  |  | H&W Hour | 5.01 | 5.01 | 5.01 | 5.01 | 5.01 | 5.01 | 5.01 | 5.01 | 5.01
 |  |  | Pension Hour | 2.79 | 2.79 | 2.79 | 2.79 | 2.79 | 2.79 | 2.79 | 2.79 | 2.79
 |  |  | SS Hour | 5.01 | 5.01 | 5.01 | 5.01 | 5.01 | 5.01 | 5.01 | 6.31 | 6.31
 |  |  | Check # | 104932 | 104971 | 105040 | 105103 | 105190 | 105247 | 105289 | 105342 | 105396
Spreadsheet: benjamin_rogers__1104__site_visit_schedule_100400_a
Sheet: Bidders

E2 [NAME]
 | [NAME] | Lincoln | Wheatland | [NAME] | Pastoria
AES |  |  |  | X | X
AEP |  |  |  | X
Allegheny | X | X | X
[NAME] | X | X | X
Calpine
Cinergy | X | X | X
Duke | X | X | X |  | X
Dynegy | X | X | X | X | X
Edison Mission |  |  |  |  | X
El Paso |  |  |  | X
Intergen |  |  |  |  | X
LG&E | X | X | X
PECO | X | X | X | X
PG&E |  |  |  |  | X
PSE&G | X | X | X
Pinnacle |  |  |  | X | X
Southern | X | X | X | X | X
Spreadsheet: 708233d1607684765-create-an-advanced-report-to-show-average-price-per-brand-sorted-by-country-cat-of-item-dashboard
Sheet: ALGERIA

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 221193d1363401805-time-adherence-sheet-for-excel-work-times
Sheet: Sheet1

 | Start | End | Time | Total Time
ACW | 08:30:00 | 09:00:00
ACW | 09:10:00 | 09:25:00
ACW | 09:30:00 | 09:45:00
This is what you asked for.
I would think it would be more like this.
 | Start | End | Time | Total Time
ACW | 08:30:00 | 09:00:00
ACW | 09:10:00 | 09:25:00
ACW | 09:30:00 | 09:45:00
 | 09:50:00 | 10:00:00
 |  |  |  |  | I would like it so that as you enter start times and end times down the rows, the elapsed time difference is reflected down column D. Column E would then add the total time from what ever row information was submitted for last.  [NAME], which poses the hardest obstacle ...would reflect the time used asthe percentage of time used from the 2 given hours in a day (which everyone in the job needs to keep above 75%) in other words, if you use all 2 hours given to you...You are at 75% adherence which is OK
Spreadsheet: 124831d1318629138-formula-to-determine-the-days-selected-amsgwp-example
Sheet: Sheet1

Monday | Tuesday | Wednesday | Thursday | Friday
x |  |  | x
 | x | x
x |  | x | x
 | x |  |  | x
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 12c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency TOTAL | 4151 | 2312 | 3526 | 11828 | 11693 | 17919 | 8201 | 386 | 60016
Spreadsheet: 0fb90f6a-ff59-418e-83b1-980d68d13139
Sheet: Sheet1

Last | First | Title | Salutation | Office | Phone | CoS | LD
Pelosi | [NAME] | Speaker | Madam Speaker | 235 Cannon | 225-4965 | [EMAIL]
[NAME] | [NAME] | Assistant to the Speaker | Representative [NAME] | 1742 Longworth | 225-0227 | [EMAIL] | [EMAIL]
Hoyer | Steny | Majority Leader | Representative Hoyer | 1705 Longworth | 225-4131 | [EMAIL] | [EMAIL]
Clyburn | [NAME] | Majority Whip | Representative Clyburn | 2135 Rayburn | 225-3315 | [EMAIL] | [EMAIL]
Larson | [NAME] | Chair, House Democratic Caucus | Representative Larson | 106 Cannon | 225-2265 | [EMAIL] | [EMAIL]
Becerra | Xavier | Vice-Chair, House Democratic Caucus | [NAME] | 1119 Longworth | 225-6235 | [EMAIL] | [EMAIL]
Spreadsheet: 1e6989b8-7270-4dd2-8278-057cfe0e7bd8
Sheet: 1995-96

Table C
Graduate Student Numbers by Faculty and Year Group
1995-96
Faculty | Year 1 | Year 2 | Year 3 | Year 4 | Year 5+ | Total
Arts and Humanities | 330 | 162 | 38 | 25 | 6
Built Environment | 456 | 89 | 33 | 25 | 16
Clinical Sciences | 170 | 133 | 67 | 24 | 11
Engineering | 313 | 80 | 56 | 29 | 4
Laws | 214 | 38 | 8 | 1 | 6
Life Sciences | 332 | 223 | 185 | 68 | 13
Mathematical and Physical Sciences | 298 | 137 | 113 | 31 | 10
Social and Historical Sciences | 327 | 103 | 60 | 29 | 7
Total
The Clinical Sciences total includes the Graduate Institutes of Child Health, Neurology and Ophthalmology and the Eastman Dental Institute.
Spreadsheet: 65139d1265871408-sum-product-or-sum-if-between-2-dates-2010-team-stimpson-summary-
Sheet: Existing Listing

EXISTING LISTING - SELLING SIDE OF LISTING
Property | Close Date | Sales Price | Total Sales Summary | Total Agent Sales Summary | Listing Agent | Selling Agent | [NAME] to Lexington | Selling Commssion [NAME] | Notes
2790 Fenmore Lane | 2010-01-01 00:00:00 | 197500 | 395000 | 395000 | Jeanne | Jeanne
2750 S. Falcon Hill | 2010-02-01 00:00:00 | 225000 | 450000 | 225000 | Michelle | Becky
 | 2010-05-02 00:00:00 | 125000 | 125000 | 125000
 | 2010-01-30 00:00:00 | 125000 | 125000 | 125000
 |  |  | 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
TOTALS |  | 672500 | 672500 | 672500 |  |  | 0 | 0
 |  | 2010-01-01 00:00:00 | 520000
 |  | 2010-02-01 00:00:00 | 450000
 |  | 2010-03-01 00:00:00 | 0
 |  | 2010-04-01 00:00:00 | 0
 |  | 2010-05-01 00:00:00 | 125000
 |  | 2010-06-01 00:00:00 | 0
 |  | 2010-07-01 00:00:00 | 0
 |  | 2010-08-01 00:00:00 | 0
 |  | 2010-09-01 00:00:00 | 0
 |  | 2010-10-01 00:00:00 | 0
 |  | 2010-11-01 00:00:00 | 0
 |  | 2010-12-01 00:00:00 | 0
Spreadsheet: 43104d1241700059-vlookup-or-macro-help-book1
Sheet: Sheet1

PART | Site 1 | Site 2 |  |  | Part 1 | Site 1 | 11 | (from SQL)
Part 1 | 11 | 33 |  |  | Part 2 | Site 1 | 22 | (from SQL)
Part 2 | 22 | 44 |  |  | Part 1 | Site 2 | 33 | (from SQL)
Part 3 | 0 | 0 |  |  | Part 2 | Site 2 | 44 | (from SQL)
Spreadsheet: 776996d1650052735-timesheets-help-timesheets-help
Sheet: TechHrs

 | PAYROLL PERIOD: | 2022-03-14 00:00:00 |  |  | THRU
Tech # | Employee Name | MON | TUE | WED | THR | FRI | SAT | SUN | Total Hours
1 | Employee 1
2 | Employee 2
3 | Employee 3
4 | Employee 4
6 | Employee 5
23
24
25
Spreadsheet: 597371d1541742089-counting-only-consecutive-days-worked-starting-from-a-user-defined-date-tazdude_samplefile
Sheet: Sheet1

DATE | CLOCK IN | CLOCK OUT | HOURS WORKED
2018-01-08 00:00:00 | 00:00:00 | 00:00:00
 | 00:00:00 | 00:00:00
 | 00:00:00 | 00:00:00
 | 01:00:00 | 00:00:00
 | 01:00:00 | 00:00:00
 | 00:00:00 | 00:00:00
 | 00:00:00 | 00:00:00
 | 01:00:00 | 00:00:00
 | 01:00:00 | 00:00:00
 | 00:00:00 | 00:00:00
 | 00:00:00 | 00:00:00
 | 00:00:00 | 00:00:00
CONSECUTIVE DAYS WORKED SINCE
 |  | 2018-01-19 00:00:00
Spreadsheet: 701614d1603850346-find-number-of-common-elements-from-two-groups-common_students
Sheet: Sheet1

 | Input |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Output
 | Course 1 | Course 2 | Course 3 | Course 4 | Course 5 |  |  |  | Student Name | Student ID |  |  |  |  |  | Output-1: 2 Course Combination in 2 columns |  | Output-2: Number of Common Students in the 2 courses
 | 726 | 946 | 965 | 683 | 407 |  |  |  | Student 1 | 726 |  | 1 |  |  |  | Course 1 | Course 2 | 8
 | 993 | 209 | 131 | 885 | 619 |  |  |  | Student 2 | 993 |  | 2 |  |  |  | Course 1 | Course 3 | 11
 | 718 | 15 | 18 | 802 | 423 |  |  |  | Student 3 | 718 |  | 3 |  |  |  | Course 1 | Course 4 | 12
 | 756 | 481 | 497 | 523 | 466 |  |  |  | Student 4 | 756 |  |  |  |  |  | Course 1 | Course 5 | 11
 | 21 | 270 | 682 | 234 | 684 |  |  |  | Student 5 | 21 |  |  |  |  |  | Course 2 | Course 3 | 11
 | 797 | 828 | 715 | 197 | 943 |  |  |  | Student 6 | 797 |  |  |  |  |  | Course 2 | Course 4 | 12
 | 497 | 993 | 726 | 726 | 726 |  |  |  | Student 7 | 946 |  |  |  |  |  | Course 2 | Course 5 | 12
 | 682 | 718 | 993 | 993 | 993 |  |  |  | Student 8 | 209 |  |  |  |  |  | Course 3 | Course 4 | 14
 | 715 | 756 | 946 | 946 | 946 |  |  |  | Student 9 | 15 |  |  |  |  |  | Course 3 | Course 5 | 15
 | 209 | 131 | 209 | 209 | 209 |  |  |  | Student 10 | 481 |  |  |  |  |  | Course 4 | Course 5 | 19
 | 15 | 18 | 15 | 15 | 15 |  |  |  | Student 11 | 270
 | 481 | 802 | 481 | 481 | 481 |  |  |  | Student 12 | 828
 | 683 | 523 | 270 | 270 | 270 |  |  |  | Student 13 | 965
 | 885 | 423 | 683 | 18 | 18 |  |  |  | Student 14 | 131
 | 423 | 466 | 885 | 497 | 497 |  |  |  | Student 15 | 18
 | 466 | 684 | 423 | 682 | 682 |  |  |  | Student 16 | 497
 |  |  | 466 | 715 | 715 |  |  |  | Student 17 | 682
 |  |  | 684 | 619 | 885 |  |  |  | Student 18 | 715
 |  |  |  | 423 | 802 |  |  |  | Student 19 | 683
 |  |  |  | 466 | 523 |  |  |  | Student 20 | 885
 |  |  |  | 684 |  |  |  |  | Student 21 | 802
 |  |  |  | 943 |  |  |  |  | Student 22 | 523
 |  |  |  |  |  |  |  |  | Student 23 | 234
 |  |  |  |  |  |  |  |  | Student 24 | 197
 |  |  |  |  |  |  |  |  | Student 25 | 407
 |  |  |  |  |  |  |  |  | Student 26 | 619
 |  |  |  |  |  |  |  |  | Student 27 | 423
 |  |  |  |  |  |  |  |  | Student 28 | 466
 |  |  |  |  |  |  |  |  | Student 29 | 684
 |  |  |  |  |  |  |  |  | Student 30 | 943
Spreadsheet: 73108d1273760067-comparing-two-sheets-on-one-spreadsheet-and-populating-with-figures-iserror-2-
Sheet: FullList

a | Not Available
b | Available
c | Available
d | Not Available
e | Available
f | Not Available
g | Not Available
h | Not Available
i | Not Available
j | Not Available
k | Not Available
l | Not Available
m | Available
n | Not Available
o | Not Available
p | Not Available
q | Not Available
r | Available
s | Not Available
t | Not Available
u | Not Available
v | Available | 23 | 24 | 25 | 26 | 27
w | Available
x | Available
y | Not Available
z | Not Available