tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0c1b91d7-4dad-4ff1-bd94-fb551ec1a65e
Sheet: Aug09

 |  | NORTH CAROLINA CENTRAL UNIVERSITY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Period
 |  | Time and [NAME] for SPA Employees-Temporary Appointments* |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From: | 2009-07-26 00:00:00
 |  | *Timesheets are due to the Payroll Office on the 26th of each month. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To: | 2009-08-25 00:00:00
 |  | Department Name:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Departmental Information |  |  |  |  | [NAME]
 |  | LEGAL NAME ONLY**                             **refers to name on record with the                                                      Social Security Administration |  |  |  | Last Name |  |  |  |  |  | First Name |  |  |  |  |  |  | MI |  | Org Code |  |  | Fund |  | Telephone Extension
 |  | Workweek 1 |  |  |  |  |  |  | Workweek 2 |  |  |  |  |  | Workweek 3 |  |  |  |  |  | Workweek 4 |  |  |  |  | Workweek 5
 |  | Work | Day of | Hours Worked |  |  |  |  | Day of | Hours Worked |  |  |  |  | Day of | Hours Worked |  |  |  |  | Day of | Hours Worked |  |  |  | Day of | Hours Worked
 |  | Day | Month | NSPP | CSPP |  |  |  | Month | NSPP | CSPP |  |  |  | Month | NSPP | CSPP |  |  |  | Month | NSPP | CSPP |  |  | Month | NSPP | CSPP
 | 1 | Sun | 2009-07-26 00:00:00
 | 2 | Mon | 2009-07-27 00:00:00
 | 3 | Tue | 2009-07-28 00:00:00
 | 4 | Wed | 2009-07-29 00:00:00
 | 5 | Thu | 2009-07-30 00:00:00
 | 6 | Fri | 2009-07-31 00:00:00
 | 7 | Sat | 2009-08-01 00:00:00
 |  | Column Totals:
 |  |  |  |  |  | 1.666666666666667 |  |  |  |  |  | 1.666666666666667 |  |  |  |  |  | 1.666666666666667 |  |  |  |  |  | 1.666666666666667 |  |  |  |  | 1.666666666666667
 |  |  |  | Hours Worked
 |  | Monthly Totals In Hrs and Mins |  | NSPP |  | CSPP |  |  | Total Worked
 |  | Monthly Totals In Hundredths of Hrs |  | NSPP |  | CSPP |  |  | Hours Worked
 |  | Employee / Supervisor Certification
 |  | If you worked for any other University department or any other State agency during this pay period, please indicate below:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMMENTS:
 |  | I certify that all "HOURS WORKED" have been recorded accurately.
 |  | Employee's Signature |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
 |  | [NAME]'s Signature |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
Spreadsheet: 781734d1653503957-how-to-validate-a-physical-address-that-is-contained-in-one-single-cell-sample
Sheet: Sheet1

Current Data | Validated address
527 Oak St Gainesville, GA 30501 | 527 OAK ST GAINESVILLE GA 30501-3505
1111 Broadway Ave Braselton, GA 30517
2451 Hilton Court Suite C Gainesville, GA 30501
630 GA Hwy 211 Winder, GA 30680
5887 Spout Springs Rd Flowery Branch, GA 30542
103 Lumpkin Campground Rd N Dawsonville, GA 30534
6901 Peachtree Industrial Blvd H Norcross, GA 30092
PO Box 1058 Buford, GA 30515
140 [NAME], GA 30533
4816 Old [NAME], GA 30554
100 [NAME], GA 30504
2118 Centennial Dr [NAME], GA 30504
54 Breakston Drive Dahlonega, GA  30533
3553 [NAME], GA 30519
2560 Flintridge Rd NE Gainesville, GA 30501
1030 Parkway Industrial Park Dr Buford, GA 30518
1400 Buford Hwy NE Suite L7 Sugar Hill, GA 30518
891 Dawsonville Hwy #140 Gainesville, GA 30501
Spreadsheet: 678519d1589931578-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example
Sheet: 09 March 20 - 14 March 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-03-09 00:00:00 | 2020-03-10 00:00:00 | 2020-03-11 00:00:00 | 2020-03-12 00:00:00 | 2020-03-13 00:00:00 | 2020-03-14 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 09/03/2020 - 14/03/2020
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Dameon | ❌
[NAME] | ✓ | ✓ | ❌ | ✓ | ✓ |  | 0.2 | 0.8 |  | [NAME] | ❌
[NAME] | AWAY | AWAY | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Harley | ✓
[NAME] | ✓ | ✓ | ❌ | ✓ | ✓ |  | 0.2 | 0.8 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Nathan | ✓
[NAME] | ✓ | AWAY | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Tyson | ✓
Will | AWAY | AWAY | ✓ | ✓ | ✓ |  |  | 1 |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  |  | ❌
 | ✓ | AWAY | AWAY | ✓ | AWAY |  |  |  |  |  | ❌
 | ✓ | [NAME] | ✓ | ✓ | ✓ |  | 0.2 | 0.8 |  |  | ✓
Edge Protection [NAME] |  |  | 09/03/2020 - 14/03/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 09/03/2020 - 14/03/2020
8 Cable Street |  |  | ✓ |  |  |  |  |  |  | Dameon | ✓
Northlink |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
Canterbury Linen Services |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Nathan | ❌
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | ✓
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ✓
 |  |  |  |  |  |  |  |  |  |  | ✓
 |  |  |  |  |  |  |  |  |  |  | ✓
Spreadsheet: phillip_m_love__30158__OntFRED
Sheet: AVar

Financial Liquidation Variances
GL Perspective: Economics to Review
TAGG | GL Amount | [NAME] | [NAME] |  | Desk Adjustment | GL Adjustment/Reclass | Comments
EW4045.A | -330298.7715 | 0
NI0331.2 | -34100 | 0
NS2550.1 | -27899.876 | 0
NS6767.1 | -11624.845 | 0
NR3878.2 | -0.031 | 0
NS9352.1 | 74622.7049 | 0
NI0331.1 | 183953.97 | 0
Spreadsheet: 865413d1712460161-need-unique-rank-that-restart-every-time-the-item-changes-restartrank
Sheet: Sheet1

ID number | average | flag | Row number when ID changes | id repeated until | rank
ID1 | 20
ID1 | 15
ID1 | 30
ID2 | 25
ID2 | 20
ID3 | 10
ID3 | 15
ID3 | 30
ID4 | 23
Spreadsheet: 767326d1644414822-help-splitting-underscores-underscores_ali
Sheet: Sheet1

12345_v1.0_TEST Name [12345]_01.01.2022.html
12345_v1.0_TEST_Name [12345]_01.01.2022.html
12345_v1.0_TESTName [12345]_01.01.2022.xlsx
12345_v1.0_TEST Name [12345]_01.01.2022.png
12345_v1.0_TEST Name [12345]_01.01.2022.xlsx
Spreadsheet: 59748d1260311211-conditionally-populating-a-sheet-from-mulitple-sheets-draft-workbook
Sheet: 2007

 | Beging Balance | Income | Payments | Net
1 | 150000 | 25000 | -25650 | 149350
2 | 10000 | 1400 | -25000 | -13600
3 | 25000 | 4000 | -1650 | 27350
4 | 5000 | 500 | -4000 | 1500
Month | Day | Year | Fiscal Year | Entity | Transaction | Payment Type | Payed To | Amount | Intrest Rate %
January | 15 | 2007 | 2006 | 1 |  | a | [NAME] | 25000 | 0.05
January | 15 | 2007 | 2007 | 2 |  | b | 1 | 25000
January | 20 | 2007 | 2007 | 3 |  | c | 2 | 1400
January | 27 | 2007 | 2007 | 4 |  | f | 3 | 4000
Febuary | 15 | 2007 | 2006 | 1 |  | e | 4 | 500
Febuary | 15 | 2007 | 2007 | 3 |  | f | 5 | 250
Febuary | 15 | 2007 | 2006 | 1 |  | g | 6 | 150 | 0.05
Spreadsheet: 845405d1696937995-counting-unique-values-with-a-criterion-across-multiple-sheets-formula-problem-for-forums
Sheet: Sheet1

Client ID | Support Type
Sheet 1
1 | A
1 | B
2 |  |  | Unique Clients who have received support
3 | A |  | 4
4 | B
4 | C
5
Sheet 2
1 | A
1 | D
6
6
6
7 | D
7 | C
3 | A
Sheet 3
3 | D
3 | F
4 | E
7 | A
7 | B
8
8
Spreadsheet: 47579d1246623632-categorizing-and-sorting-data-payroll-summary-sample
Sheet: Sheet1

COMPANY NAME
Payroll Summary
06/25/2009 - 06/25/2009
Date | Name | Net Amt | Hours | Taxes Withheld | Total Deductions | Company Contributions | Total Pay | Employer Taxes | Total Cost | Check Num | Dept
2009-06-25 00:00:00 | Name1 | 1000 |  | 100 |  |  |  |  |  |  | HR
2009-06-26 00:00:00 | [NAME] | 1001 |  | 101 |  |  |  |  |  |  | HR
2009-06-27 00:00:00 | Name3 | 1002 |  | 102 |  |  |  |  |  |  | Accnt
2009-06-28 00:00:00 | Name4 | 1003 |  | 103 |  |  |  |  |  |  | Accnt
2009-06-29 00:00:00 | Name5 | 1004 |  | 104 |  |  |  |  |  |  | Accnt
2009-06-30 00:00:00 | Name6 | 1005 |  | 105 |  |  |  |  |  |  | HR
2009-07-01 00:00:00 | Name7 | 1006 |  | 106 |  |  |  |  |  |  | Shipping
2009-07-02 00:00:00 | Name8 | 1007 |  | 107 |  |  |  |  |  |  | Shipping
2009-07-03 00:00:00 | Name9 | 1008 |  | 108 |  |  |  |  |  |  | [NAME]
2009-07-04 00:00:00 | Name10 | 1009 |  | 109 |  |  |  |  |  |  | [NAME]
2009-07-05 00:00:00 | Name11 | 1010 |  | 110 |  |  |  |  |  |  | [NAME]
2009-07-06 00:00:00 | Name12 | 1011 |  | 111 |  |  |  |  |  |  | Sales
2009-07-07 00:00:00 | Name13 | 1012 |  | 112 |  |  |  |  |  |  | Sales
2009-07-08 00:00:00 | Name14 | 1013 |  | 113 |  |  |  |  |  |  | Sales
2009-07-09 00:00:00 | Name15 | 1014 |  | 114 |  |  |  |  |  |  | Sales
 | Totals | 15105
 |  | Dept | Net | Taxes
 |  | HR | 3006 | 306
 |  | Accnt | 3009 | 309
 |  | Shipping | 2013 | 213
 |  | [NAME] | 3027 | 327
 |  | Sales | 4050 | 450
Spreadsheet: kate_symes__18472__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-18 00:00:00 |  | 481.44 | 21424 | 392.14 | 5112
 | 2001-01-17 00:00:00 |  | 272.66 | 29824 | 248.16 | 6312 | 428.17 | 196 | 285.3 | 495
 | 2001-01-16 00:00:00 |  | 179.29 | 23760 | 158.21 | 3800 | 422.32 | 6337 | 190 | 50
 | 2001-01-15 00:00:00 |  | 179.29 | 23760 | 158.21 | 3800 | 205.96 | 83 | 210 | 22
 | 2001-01-14 00:00:00 |  | 158.5 | 0 | 152.5 | 0 | 175.38 | 920 | 157.2 | 820 |  | 152.44 | 15000
 | 2001-01-13 00:00:00 |  | 158.65 | 17648 | 151.85 | 6600 | 180.04 | 1330 | 158.51 | 865
 | 2001-01-12 00:00:00 |  | 171.71 | 16368 | 147.69 | 5432 | 181.08 | 185 | 149.35 | 575
 | 2001-01-11 00:00:00 |  | 171.43 | 15360 | 147.59 | 5936 | 157.64 | 254 | 119.48 | 1146
 | 2001-01-10 00:00:00 |  | 157.57 | 15328 | 144.37 | 5680 | 149.25 | 499 | 120.6 | 712
 | 2001-01-09 00:00:00 |  | 152.13 | 22160 | 145.73 | 6400 | 148.76 | 1729 | 123.36 | 640
 | 2001-01-08 00:00:00 |  | 147.54 | 22800 | 130.49 | 6480 | 115.32 | 470 | 102.22 | 1125
 | 2001-01-07 00:00:00 |  | 140 | 0 | 130 | 0 | 119.61 | 888 | 82.66 | 800 |  | 130.49 | 19440
 | 2001-01-06 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 103.18 | 1305 | 98.34 | 1325
 | 2001-01-05 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 134.44 | 1345 | 120.8 | 1155
 | 2001-01-04 00:00:00 |  | 152.95 | 20280 | 139.1 | 5544 | 143.03 | 190 | 127.53 | 415
 | 2001-01-03 00:00:00 |  | 175.7 | 14400 | 163.68 | 3800 | 156.14 | 485 | 127.71 | 648
 | 2001-01-02 00:00:00 |  | 185.67 | 14400 | 176.33 | 3000 | 142.46 | 2097 | 126.6 | 1453
 | 2001-01-01 00:00:00 |  | 187.5 | 0 | 175 | 0 | 111.05 | 95 | 110 | 300 |  | 176.33 | 9000
 | 2000-12-31 00:00:00 |  | 167.5 | 0 | 157.5 | 0 | 150.12 | 2630 | 110 | 450 |  | 164.5 | 19440
 | 2000-12-30 00:00:00 |  | 171.7 | 19408 | 160.7 | 5608 | 146.38 | 705 | 145.32 | 1175
 | 2000-12-29 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 214.02 | 1107 | 166.68 | 674
 | 2000-12-28 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 190.98 | 1381 | 158.36 | 802
 | 2000-12-27 00:00:00 |  | 394.68 | 12400 | 267.17 | 3320 | 165.54 | 2855 | 159.35 | 1123
 | 2000-12-26 00:00:00 |  | 451.15 | 10624 | 428.32 | 2712 | 182.26 | 2772 | 177.14 | 934
 | 2000-12-25 00:00:00 |  | 410 | 32 | 315 | 200 | 201.38 | 12441 | 207.74 | 775 |  | 377.09 | 5160
 | 2000-12-24 00:00:00 |  |  |  | 315 | 200 | 225.8 | 1588 | 225.35 | 855 |  | 377.09 | 5160
 | 2000-12-23 00:00:00 |  | 462.41 | 8224 | 382.64 | 1912 | 325.41 | 4915 | 244.19 | 2400
 | 2000-12-22 00:00:00 |  | 463 | 8624 | 382.94 | 1712 | 349.16 | 4653 | 309.33 | 2630
 | 2000-12-21 00:00:00 |  | 463 | 8624 | 384.75 | 2112 | 425 | 150 | 350 | 50
 | 2000-12-20 00:00:00 |  | 463.54 | 9424 | 386.4 | 1912 | 411.71 | 1117 | 365.63 | 240
 |  |  |  |  |  | ..
Spreadsheet: 125831d1319235207-matching-on-name-to-phone-email-addresses-sample
Sheet: Email Addresses

Name First | Name Last | Phone/E-mail [NAME]
[NAME] | Nakama | [EMAIL]
(Joel) Bradley | King | [EMAIL]
A. Jerard | Bryant | [EMAIL]
[NAME] | Green | [EMAIL]
[NAME] | Arce | [EMAIL]
[NAME] | Ayala | [EMAIL]
[NAME] | [NAME] | [EMAIL]
[NAME] | Buxbaum | [EMAIL]
Spreadsheet: 839897d1692285060-index-and-match-function-not-working-123-abc
Sheet: Sheet1 (2)

ألأسم | العمر | الفئة | الفئة | Age Category | Count
Name | Age | Category | Category |  |  |  | 1-5 | 6-10 | 11-15 | 16-20 | 21-25 | 26-30 | 31-35 | 36-40 | 41-45 | 46-50 | 51-55 | 56-60 | 61-65 | 66-70 |  |  |  |  | [NAME]
محسن منذر | 16 |  |  |  | 6
محمود إيمان | 15 |  |  | 6-10 | 7
سليم صابر | 15 |  |  | 11-15 | 3
فؤاد جمال | 3 |  |  | 16-20 | 5
موسى منصور | 4 |  |  | 21-25 | 7
مهيبة طيب | 5 |  |  | 26-30 | 5
إحسان عذاب | 1 |  |  | 31-35 | 7
[NAME] | 2 |  |  | 36-40 | 5
شهيد سراج | 4 |  |  | 41-45 | 5
شيماء حكيم | 16 |  |  | 46-50 | 4
صديق زكريا | 20 |  |  | 51-55 | 4
حكيم آيات | 18 |  |  | 56-60 | 5
ريحانة شعيب | 20 |  |  | 61-65 | 2
وحيد اخلاص | 23 |  |  | 66-70 | 4
فرج علي | 23
ميمونة بصير | 23
[NAME] | 24
فؤاد أماني | 21
يعقوب بشير | 24
سمية عزيز | 22
ساجد خليل | 26
سراج شهيد | 29
مرجان نور | 27
[NAME] | 28
قمر خليل | 26
عبدالله سمير | 35
منى منتصر | 31
معمر أحلام | 33
ضياء أحلام | 35
إيناس منير | 64
بحر ناصر | 31
منير مبارك | 66
رغد إبراهيم | 33
حسن لطيف | 34
يعقوب مطر | 40
ابرار اسحاق | 38
سلوى داوود | 38
ناصح عزيز | 37
[NAME] | 38
حبيب جهاد | 42
داوود ناصح | 45
عزيز ناصح | 44
اسراء منتصر | 41
بديع سليمان | 44
لطيف حسن | 47
[NAME] | 50
رقية آدم | 48
بصير شهيد | 49
أحلام معمر | 54
بصير إكرام | 53
سلمى موسى | 53
إشراق هادي | 55
قارون بشير | 70
اسحاق أنعام | 64
مروى معمر | 57
[NAME] | 59
عيسى منذر | 69
آدم [NAME] | 68
يوسف علي | 7
[NAME] | 10
طيب اسلام | 6
سعيد نجم | 6
أمينة مرشد | 10
لميس ضياء | 57
داليا حسن | 8
جميل جواد | 59
إبراهيم جواد | 9
آيات ضياء | 13
جلال فضل | 58
Spreadsheet: 160600d1339135663-vlookup-duplicates-excel-forum-answer
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | 9 | H |  |  |  | H |  |  |  |  |  |  |  |  |  |  | 2
 | 8 | G |  |  |  | G |  |  |  |  |  |  |  |  |  |  | 3
 | 7 | C |  |  |  | C |  |  |  |  |  |  |  |  |  |  | 4
 | 7 | F |  |  |  | F |  |  |  |  |  |  |  |  |  |  | 5
 | 4 | E |  |  |  | E |  |  |  |  |  |  |  |  |  |  | 6
 | 3 | B |  |  |  | B |  |  |  |  |  |  |  |  |  |  | 7
 | 3 | D |  |  |  | D |  |  |  |  |  |  |  |  |  |  | 8
 | 3 | I |  |  |  | I |  |  |  |  |  |  |  |  |  |  | 9
 | 2 | J |  |  |  | J |  |  |  |  |  |  |  |  |  |  | 10
 | 1 | A |  |  |  | A
Spreadsheet: 845140d1696665127-generate-a-receipt-from-repeat-customer-file-hotel-2-aligw
Sheet: Data

Direct |  | 1 |  | BACS
Booking |  | 2 |  | Cheque |  | 2 [NAME] |  | 2
 |  | 3 |  | Cash |  | 3 [NAME]
 |  | 4 |  |  |  | 4 Karen Douglas
 |  | 5 |  |  |  | 5 [NAME]
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
Spreadsheet: 97040d1296240367-reference-within-another-worksheet-reference-team-stats-sheet
Sheet: Team

 |  |  |  |  |  |  |  |  |  |  | 1 | D
 | Team Details |  |  |  |  |  |  |  |  |  | 2 | E
 |  |  |  |  |  |  |  |  |  |  | 3 | F
 | Name |  | Details |  |  |  |  |  |  |  | 4 | G
 | First | Surname | Payroll | ID | Shift |  |  |  |  |  | 5 | H
 | A | Doe |  |  |  |  |  |  |  |  | 6 | I
 | B | Doe |  |  |  |  |  |  |  |  | 7 | J
 | C | Doe |  |  |  |  |  |  |  |  | 8 | K
 | D | Doe |  |  |  |  |  |  |  |  | 9 | L
 | E | Doe |  |  |  |  |  |  |  |  | 10 | M
 | F | Doe |  |  |  |  |  |  |  |  | 11 | N
 | G | Doe |  |  |  |  |  |  |  |  | 12 | O
 | H | Doe |  |  |  |  |  |  |  |  | 13 | P
 | I | Doe |  |  |  |  |  |  |  |  | 14 | Q
 | J | Doe |  |  |  |  |  |  |  |  | 15 | R
 | K | Doe |  |  |  |  |  |  |  |  | 16 | S
 | L | Doe |  |  |  |  |  |  |  |  | 17 | T
 | M | Doe |  |  |  |  |  |  |  |  | 18 | U
 | N | Doe |  |  |  |  |  |  |  |  | 19 | V
 | O | Doe |  |  |  |  |  |  |  |  | 20 | W
 | P | Doe |  |  |  |  |  |  |  |  | 21 | X
 | Q | Doe |  |  |  |  |  |  |  |  | 22 | Y
 | R | Doe |  |  |  |  |  |  |  |  | 23 | Z
 | S | Doe |  |  |  |  |  |  |  |  | 24 | AA
 |  |  |  |  |  |  |  |  |  |  | 25 | AB
 |  |  |  |  |  |  |  |  |  |  | 26 | AC
 |  |  |  |  |  |  |  |  |  |  | 27 | AD
 |  |  |  |  |  |  |  |  |  |  | 28 | AE
 |  |  |  |  |  |  |  |  |  |  | 29 | AF
 |  |  |  |  |  |  |  |  |  |  | 30 | AG
 |  |  |  |  |  |  |  |  |  |  | 31 | AH
 |  |  |  |  |  |  |  |  |  |  | 32 | AI
 |  |  |  |  |  |  |  |  |  |  | 33 | AJ
 |  |  |  |  |  |  |  |  |  |  | 34 | AK
 |  |  |  |  |  |  |  |  |  |  | 35 | AL
 |  |  |  |  |  |  |  |  |  |  | 36 | AM
 |  |  |  |  |  |  |  |  |  |  | 37 | AN
 |  |  |  |  |  |  |  |  |  |  | 38 | AO
 |  |  |  |  |  |  |  |  |  |  | 39 | AP
 |  |  |  |  |  |  |  |  |  |  | 40 | AQ
 |  |  |  |  |  |  |  |  |  |  | 41 | AR
 |  |  |  |  |  |  |  |  |  |  | 42 | AS
 |  |  |  |  |  |  |  |  |  |  | 43 | AT
 |  |  |  |  |  |  |  |  |  |  | 44 | AU
 |  |  |  |  |  |  |  |  |  |  | 45 | AV
 |  |  |  |  |  |  |  |  |  |  | 46 | AW
 |  |  |  |  |  |  |  |  |  |  | 47 | AX
 |  |  |  |  |  |  |  |  |  |  | 48 | AY
 |  |  |  |  |  |  |  |  |  |  | 49 | AZ
 |  |  |  |  |  |  |  |  |  |  | 50 | BA
 |  |  |  |  |  |  |  |  |  |  | 51 | BB
 |  |  |  |  |  |  |  |  |  |  | 52 | BC
Spreadsheet: 875320d1721910264-month-wise-leave-accruls-need-to-calculate-te
Sheet: Data

Emp No | Name | 2023-01-01 00:00:00 |  |  |  |  | 2023-02-01 00:00:00 |  |  |  |  | 2023-03-01 00:00:00
 |  | V | PH | S | U | A | V | PH | S | U | A | V | PH | S | U | A
00001 | [NAME] | 1 | 2 | 3 | 0 | 1 | 1 | 2 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | 0
00002 | Demian | 4 | 0 | 0 | 0 | 0 | 4 | 3 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0
00005 | [NAME] | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0
00015 | MOHAMMAD | 0 | 0 | 0 | 0 | 0 | 9 | 2 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0
00018 | MEGZARI | 2 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 19 | 0 | 0 | 1 | 0
Spreadsheet: 678965d1590143622-calculate-night-shift-hours-inventory-service-team-timesheet-2020-copy-autosaved-
Sheet: May

 | Employee Time Sheet
 | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES | 2015-12-01 00:00:00 | 31 | 1
 | SAP ID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | 2016-01-01 00:00:00 | 31 | 0
 | Month |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Excused | 2016-02-01 00:00:00 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-03-01 00:00:00 | 31
 | Date | Day | Time In | Time Out | Hours Worked | Holiday/ Vacation/Day-Off | Shift duty | Normal Working Hours | OT | Regular OT | Weekend OT | Shift Hours | Remarks | Shift start | Shift Hours | Shift Hours>11 |  | 2016-05-01 00:00:00 | 31
 | 2020-05-01 00:00:00 | Fri | 20:01:00 | 05:00:00 |  | NO | YES |  |  |  |  |  |  | 18:00:00 |  |  |  | 2016-06-01 00:00:00 | 30
 |  | Sat | 18:00:00 | 03:00:00 |  | NO | YES |  |  |  |  |  |  | 18:00:00 |  |  |  | 2016-07-01 00:00:00 | 31
 |  | Sun | 19:00:00 | 03:00:00 |  | NO | YES |  |  |  |  |  |  | 18:00:00 |  |  |  | 2016-08-01 00:00:00 | 31
 |  | Mon |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 |  |  |  | 2016-09-01 00:00:00 | 30
 |  | Tue |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 |  |  |  | 2016-10-01 00:00:00 | 31
 |  | Wed |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00 |  |  |  | 2016-11-01 00:00:00 | 30
 |  | Thu |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00 |  |  |  | 2016-12-01 00:00:00 | 31
 |  | Fri |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 |  |  |  | 2017-01-01 00:00:00 | 31
 |  | Sat |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Sun |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Mon |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Tue |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Wed |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00
 |  | Thu |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00
 |  | Fri |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Sat |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Sun |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Mon |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Tue |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Wed |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00
 |  | Thu |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00
 |  | Fri |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Sat |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Sun |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Mon |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Tue |  |  |  | Excused | NO |  |  |  |  |  |  | 18:00:00
 |  | Wed |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00
 |  | Thu |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00
 |  | Fri |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Sat |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 |  | Sun |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00
 | COMMENTS
 | EMPLOYEE'S SIGNATURE |  |  |  |  |  |  |  | MANAGER/SUPERVISOR APPROVAL
Spreadsheet: 680117d1590783578-have-data-automatically-build-new-list-based-on-criteria-from-a-specific-column-budget-example
Sheet: January

2021
2021-01-01 00:00:00
 |  |  |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
Input | Description | Amount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 775
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense
Spreadsheet: kam_keiser__17980__113001 Officials
Sheet: Sheet1

 | 1425429
 | 1425430
 | 1425431
 | 1425441
 | 1425443 |  | Denver_Regs
 | 1425432
 | 1425433
 | 1425442
 | 1425444
 | 1425445
 | 1425178
 | 1425180
 | 1425181
 | 1425182
 | 1425183
 | 1425184
 | 1425185 |  | Rox
 | 1425192 |  | Mgmt
 | 1425193
 | 1425194
 | 1425195
 | 1425196
 | 1425197
 | 1425186
 | 1425187
 | 1425188
 | 1424915
 | 1424930
 | 1424932
 | 1424944
 | 1424946 |  | WC-CAL
 | 1424947
 | 1424978
 | 1424979
 | 1424980
 | 1425029
 | 1425032
 | 1424727
 | 1424728
 | 1424731
 | 1424732
 | 1424733
 | 1424734 |  | Socal_Nocal
 | 1424735
 | 1424736
 | 1424739
 | 1424740
 | 1424741
 | 1424742
 | 1424833
 | 1424835
 | 1424836 |  | Perm
 | 1424837
 | 1424839
 | 1424840
 | 1424111
 | 1424114
 | 1424045
 | 1424046
 | 1424047
 | 1424048 |  | SJ
 | 1424049
 | 1424050
 | 1424282
 | 1424283
 | 1424284
 | 1424285
 | 1425485
 | 1425491
 | 1425492 |  | WT-CAL
 | 1425493
 | 1425496
 | 1425497
 | 1424645
 | 1424646
 | 1424647
 | 1424649 |  | WT-SOCAL
 | 1424650
 | 1424651
 | 1424652
 | 1424653
Spreadsheet: 525638d1498819583-conditional-formatting-icon-sets-conditformatwithiconsets
Sheet: Sheet1

Value
1
867
362
380
570
70
700
94
978
398
54
655
568
180
609
149
293
22
484
Spreadsheet: 100070d1298541399-3d-cell-referencing-help-bracknell-start
Sheet: Bracknell and Wokingham

Bracknell + Wokingham
 |  | Europe | Australia | Asia | America | Africa
 |  | 53000 | 45000 | 32000 | 49000 | 11000
 |  | 91000 | 77000 | 58000 | 83000 | 8000
 |  | 78000 | 38000 | 38000 | 56000 | 15000
 |  | 89000 | 72000 | 37000 | 66000 | 13000
 |  | 82000 | 74000 | 31000 | 68000 | 14000
 |  | 97000 | 82000 | 44000 | 75000 | 19000
 |  | 54000 | 68000 | 39000 | 73000 | 10000
 |  | 51000 | 49000 | 29000 | 51000 | 9000
 |  | 96000 | 75000 | 60000 | 81000 | 18000
 | Total for each region | 691000 | 580000 | 368000 | 602000 | 117000
 | min | 8000
 | [NAME] | 97000
 | average | 52400