tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__33739__Metrics 0727
Sheet:  Upstream Originations

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | Upstream Originations
Results based on Activity through July 27, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 4
 |  | Weekly Summary - 2Q00 through 2Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-07-07 00:00:00
Postings Rollforward:
Beginning |  | 67
+ Entrances |  | 2 | 3 | 7 | 4
- Exits |  | 0 | 3 | 4 | 1
- Executions |  | 0 | 0 | 1 | 0
Ending
Postings Rollforward:
Beginning
+ Entrances
- Exits
+/- [NAME]
- Executions
Ending
Average Deal Size
 |  | Quarterly Summary ($ millions)
 |  |  |  |  |  |  |  | Forward Quarters
 | YTD |  |  | Current Quarter |  | Per |  |  |  |  | Total Year
 | 2000 |  |  | 3Q00 |  | Hot List |  | 4Q00 |  |  | 2000 |  |  | 1Q01 |  |  | 2Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions |  |  |  | 1 | 0.14 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0
DPR/MPR |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 0
Postings |  |  |  | 28 | 30.9 |  |  | 31 | 17.937 |  |  |  |  | 13 | 9.4 |  | 2 | 0.5
Identified Margin
Budget |  | 18.423
$ Coverage
Spreadsheet: 202665d1356682217-moving-data-from-single-to-multiple-columns-and-merging-file1
Sheet: Before

ID
Date
FileName
1
2012-01-01 00:00:00
one.txt
6
2012-02-15 00:00:00
test.txt
3
2012-01-08 00:00:00
random.rtf
4
2012-12-12 00:00:00
2
2012-12-13 00:00:00
two.txt
8
2011-10-10 00:00:00
5
2010-01-01 00:00:00
three.txt
Spreadsheet: larry_campbell__20981__Topock Pigging Program
Sheet: Page 5 

Revised |  | 2000-12-20 00:00:00 |  |  |  |  |  | Liquid
Date |  | Location | Type of Pig | Solvent | Solvent | Lateral | Sample I.D. | Volume | Analytical | Units | Comments
 |  | of Sample |  | Injected | Volume | Volume |  | Collected | Result
2000-10-30 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 295 mmcf |  | 0 |  |  | No liquid received with pig 97
2000-11-14 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 217 mmcf |  | 0 |  |  | No liquid received with pig 98
2000-11-27 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 261 mmcf |  | 0 |  |  | No liquid received with pig 99
2000-12-11 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 278 mmcf |  | 0 |  |  | No liquid received with pig 100
Spreadsheet: 720728d1614271092-formula-to-alter-calculation-dependant-on-drop-down-list-value-peters-version-of-tim-recording-sheet
Sheet: WEEK 2

 | Monday | Minute |  |  |  |  |  |  | Tuesday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50 |  | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6 |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  | 12
 | 13 |  |  |  |  |  |  |  | 13
 | 14 |  |  |  |  |  |  |  | 14
 | 15 |  |  |  |  |  |  |  | 15
 | 16 |  |  |  |  |  |  |  | 16
 | 17 |  |  |  |  |  |  |  | 17
 | 18 |  |  |  |  |  |  |  | 18
 | 19 |  |  |  |  |  |  |  | 19
 | Wednesday | Minute |  |  |  |  |  |  | Thursday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50 |  | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6 |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  | 12
 | 13 |  |  |  |  |  |  |  | 13
 | 14 |  |  |  |  |  |  |  | 14
 | 15 |  |  |  |  |  |  |  | 15
 | 16 |  |  |  |  |  |  |  | 16
 | 17 |  |  |  |  |  |  |  | 17
 | 18 |  |  |  |  |  |  |  | 18
 | 19 |  |  |  |  |  |  |  | 19
 | Friday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
Spreadsheet: 730059d1619530224-find-record-on-2-criteria-with-nearest-lowest-date-27042021-sample-file-for-excel-forum
Sheet: Sheet2

 |  | 2018-09-24 00:00:00 |  | 2020-07-05 00:00:00 |  | 2021-04-04 00:00:00 |  |  | Current Date | 2021-03-30 00:00:00
0 | 0.01 |  | 0.01 |  | 0.03 |  |  |  | Fees | 11127000
2500000 | 0.005 |  | 0.005 |  | 0.02
5000000 | 0.0025 |  | 0.0025 |  | 0.01 |  |  |  | Service Charges Amount
10000000 | 0.002 |  | 0.002 |  | 0.005
Spreadsheet: 41557d1240054006-ms-excel-standard-deviation-conditional-calculation-stdev
Sheet: Sheet1

Criteria |  |  | Yes | Yes | No | No | Yes | Yes | No | No | Yes | Yes | No | No | Yes | Yes | No | No | Yes | Yes | No | No | Yes | Yes | No | No
Value |  |  | 37 | 28.5 | 35.4 | 25 | 27.9 | 32.8 | 37.5 | 27.6 | 28.9 | 29.9 | 30.3 |  | 26.1 | 27.4 |  | 23.5 | 29.1 | 29.2 | 33.8 | 40.4 |  | 30.5 | 37.9 | 26.5
Manual Calculation Method:
Standard Deviation (All) | 4.653805406536105 |  | 37 | 28.5 | 35.4 | 25 | 27.9 | 32.8 | 37.5 | 27.6 | 28.9 | 29.9 | 30.3 |  | 26.1 | 27.4 |  | 23.5 | 29.1 | 29.2 | 33.8 | 40.4 |  | 30.5 | 37.9 | 26.5
Standard Deviation (Yes) | 2.961879010480912 |  | 37 | 28.5 |  |  | 27.9 | 32.8 |  |  | 28.9 | 29.9 |  |  | 26.1 | 27.4 |  |  | 29.1 | 29.2 |  |  |  | 30.5
Standard Deviation (No) | 5.997490215822683 |  |  |  | 35.4 | 25 |  |  | 37.5 | 27.6 |  |  | 30.3 |  |  |  |  | 23.5 |  |  | 33.8 | 40.4 |  |  | 37.9 | 26.5
STDEV (No) | 5.997490215822683
Conditional Calculation Method:
Standard Deviation (No) | 6.308951104911845 |  | The equation in cell B10 does not give the correct answer. The correct answer is in cell B7.
Note:
This is an example of my database. In the future, I will add more data columns, hence the formula looks upto column IV.
Spreadsheet: 328725d1404048086-excel-cell-color-background-shading-using-if-statements-school-form-2-june-
Sheet: June

 | Month | School Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. of Students:
June |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days:
 |  |  |  | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F
Name (Boys) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absents | Tardy |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
Total Enrollment for year to date:
Total Enrollment for month to date:
Attendance Totals: |  |  | AM
 |  |  | PM
 | Month | School Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. of Students:
June |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days:
 |  |  |  | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F
Name (Boys) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absents | Tardy |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
Total Enrollment for year to date:
Total Enrollment for month to date:
Attendance Totals: |  |  | AM
 |  |  | PM
Spreadsheet: james_steffes__12859__Utility and ISO Balances1
Sheet: Sheet1

Recap of Utility and ISO amounts due
 |  |  | Due From: |  |  |  |  |  |  |  | Reserves
 |  |  | PG&E |  | SCE |  | CA-ISO |  | CA-PX
Due To:
EPMI |  |  |  | * |  |  | 46000000 |  | 8000000 |  |  | Reserves associated with CA-ISO ($18.5) and CA-PX ($3.5)balances
ENA |  |  | 24138010.72 | *
ECC |  |  | 24209249.36 | *
 |  |  |  | *
ENA |  |  | 74190183.48 |  |  |  |  |  |  |  | -24000000
EES |  |  | 405927058.97 |  | 109711273.32 |  |  |  |  |  | -309000000
Total
* Intention is to net these three balances
Spreadsheet: 273027d1382587074-reversing-the-order-of-auto-updated-rows-into-a-new-sheet-hammertest-iv
Sheet: Sheet1

Reference | Name | Type | Value | Average | Report
vv | ww | xx | yy | zz | zzz
aa | bb | cc | dd | ee | ff
1 | J | A | 3 | 3 | G
4 | G | B | 4 | 6 | G
2 | L | C | 5 | 2 | G
Spreadsheet: larry_campbell__21311__LFC0700V1
Sheet: SJ-PGE E

Pipeline | Status | ProdYear | ProdMonth | LDCMeter | ReadDate | ReadUnit | Quantity | BillFrom | BillTo | BTU |  | CustomerName
SJG | E | 2000 | 7 | MERCURY |  | dth | 14291 | 2000-07-01 00:00:00 | 2000-07-31 00:00:00 |  |  | PG&E ENERGY SERVICES END USERS
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 102067 | 101181
2 | 100541 | 99669
3 | 113331 | 113022
4 | 75301 | 74820
5 | 74993 | 74822
6 | 77697 | 78322
7 | 83890 | 83066
8 | 85931 | 84822
9 | 85552 | 84822
10 | 84996 | 84822
11 | 94818 | 94822
12 | 98459 | 97797
13 | 68836 | 68429
14 | 66878 | 68575
15 | 76399 | 76575
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 8908.65
2001-12-15 00:00:00
CBS Volume
 |  |  | -51521
Spreadsheet: 814265d1674246025-pull-in-multiple-rows-of-data-searching-by-date-summary-sheet
Sheet: 18

[NAME]
[NAME] | Copy/Paste
 | 67680
 | 48380
 | 48200
 |  |  |  |  | Retentate Weighted Average
Sweet Cream Load outs | BF% | Protein | TS | PO#
 |  |  |  |  | Sweet Cream Weighted Average
Spreadsheet: 693602d1599053684-sumifs-by-ccy-fiscal-period-and-category-though-special-treatment-for-specific-categories-sumifs
Sheet: Monthly

Fiscal Period | 2020P9 | GBP | EUR | USD | CHF | AUD | SGD | HKD | [NAME] | AED | CAD | MYR
Currency | AR
 | [NAME]
 | APT
 | APNT Vendor
 | APNT Expenses
 | ECM
 | ECM Tax
 | ECM Pension/Other
 | IP Net Pay
 | IP Tax
 | IP Social
 | IP Other
 | Tax VAT
 | Tax CT
 | Tax Other
 | CoSec/Legal
 | [NAME]
 | Other
Spreadsheet: 733308d1621504784-daily-totals-matching-weekly-value-throwing-false-negatives-false-negatives
Sheet: FALSE NEGATIVES

Row | Daily Hours match weekly Totals | Weekly Total | Mon Total | Tue  Total | Wed  Total | Thu  Total | Fri  Total | CHECKSUM Day * Days
Section 1
167 |  | 4.285714285714286 | 0 | 1.428571428571428 | 0 | 1.428571428571428 | 1.428571428571428
1281 |  | 4.285714285714286 | 0 | 1.428571428571428 | 1.428571428571428 | 1.428571428571428 | 0
1737 |  | 0.9156626506024096 | 0 | 0.3052208835341365 | 0.3052208835341365 | 0.3052208835341365 | 0
Section 2
712 |  | 6.782608695652176 | 0 | 2.260869565217392 | 2.260869565217392 | 2.260869565217392 | 0
1836 |  | 3.348837209302325 | 1.116279069767442 | 1.116279069767442 | 1.116279069767442 | 0 | 0
Section 3
247 |  | 7.466666666666665 | 0 | 2.488888888888888 | 2.488888888888888 | 2.488888888888888 | 0
1093 |  | 0.5454545454545455 | 0 | 0.1818181818181818 | 0.1818181818181818 | 0.1818181818181818 | 0
Section 4
310 |  | 3.130434782608695 | 0 | 1.043478260869565 | 0 | 1.043478260869565 | 1.043478260869565
1931 |  | 3.384615384615385 | 1.128205128205128 | 1.128205128205128 | 1.128205128205128 | 0 | 0
All nine are "False" negatives
Spreadsheet: 717198d1612527813-look-up-and-return-using-dates-test-plastics
Sheet: RAW

 | AM | PM | N
2021-01-01 00:00:00 | 0 | 0
2021-01-02 00:00:00 | 0 | 0
2021-01-03 00:00:00 | 0 | 0
2021-01-04 00:00:00 | 0 | 0
2021-01-05 00:00:00 | 0 | 0
2021-01-06 00:00:00 | 3055 | 2650 | 3000
2021-01-07 00:00:00 | 9040 | 3075
2021-01-08 00:00:00 | 12901 | 1324
2021-01-09 00:00:00 | 0 | 0
2021-01-10 00:00:00 | 0 | 0
2021-01-11 00:00:00 | 5257 | 3818
2021-01-12 00:00:00 | 3415 | 5450
2021-01-13 00:00:00 | 5085 | 22010
2021-01-14 00:00:00 | 5983 | 7910
2021-01-15 00:00:00 | 5550 | 5419
2021-01-16 00:00:00 | 0 | 0
2021-01-17 00:00:00 | 0 | 0
2021-01-18 00:00:00 | 6890 | 3907
2021-01-19 00:00:00 | 5677 | 1521
2021-01-20 00:00:00 | 5078 | 1197
2021-01-21 00:00:00 | 5033 | 1622
2021-01-22 00:00:00 | 7720 | 483
2021-01-23 00:00:00 | 0 | 0
2021-01-24 00:00:00 | 0 | 0
2021-01-25 00:00:00 | 4722 | 3111
2021-01-26 00:00:00 | 5076 | 5734
2021-01-27 00:00:00 | 3737 | 8249
2021-01-28 00:00:00 | 5187 | 6630
Spreadsheet: 42667d1241205051-sorting-by-columns-with-blanks-columnsorts
Sheet: Expected after sorting

EnglishID | ChineseID | FrenchID | Segment | Title | Key Times | Duration | EOM
123456 |  |  | 1 | All about Cars | 00:29:29 | 0:29:28,24 | 0:28:10,22
 |  |  | 2 | All about Cars | 00:30:28 | 0:59:55,28 | 1:02:30,02
A12345 |  |  | 1 | Go Bikes | 00:34:20 | 1:02:30,02 | 0:28:56,22
 |  |  | 2 | Go Bikes | 00:34:20 | 1:02:30,02 | 1:02:58,02
B12345 |  |  | 1 | Buy Trucks | 00:40:35 | 1:38:54,01 | 0:29:28,24
 |  |  | 2 | Buy Trucks | 00:40:35 | 1:38:54,01 | 0:59:55,28
 |  |  | 3 | Buy Trucks | 00:40:35 | 1:38:54,01 | 1:26:44,26
 | 123456 |  | 1 | Trucks are neat | 00:28:11 | 0:28:10,22 | 1:02:17,06
 |  |  | 2 | Trucks are neat | 00:28:11 | 0:28:10,22 | 1:34:09,26
 | 123457 |  | 1 | Ride Cars | 00:28:46 | 0:28:45,12 | 0:31:03,13
 |  |  | 2 | Ride Cars | 00:29:34 | 0:58:19,12 | 1:02:37,20
 |  | A32154 | 1 | Sell Vehicles | 0:00:00,00 | 00:33:06 | 0:29:28,24
 |  |  | 2 | Sell Vehicles | 0:33:05,11 | 00:28:22 | 0:59:55,28
 |  |  | 3 | Sell Vehicles | 1:01:26,14 | 00:37:20 | 1:26:44,26
Spreadsheet: 176595d1345961279-want-to-get-highest-sales-qty-and-sales-person-name-within-specified-dates-example-sheet
Sheet: Sheet1

Sales person | Date | Product | Qty
[NAME] | 2012-08-01 00:00:00 | Pen | 10
[NAME] | 2012-08-02 00:00:00 | Pen | 10
Leo | 2012-08-02 00:00:00 | Pen | 20
Ram | 2012-08-02 00:00:00 | Pen | 15
Leo | 2012-08-03 00:00:00 | Pen | 15
Ravi | 2012-08-04 00:00:00 | Pen | 10
[NAME] | 2012-08-05 00:00:00 | Pen | 15
Ram | 2012-08-06 00:00:00 | Pen | 5
Leo | 2012-08-07 00:00:00 | Pen | 5
[NAME] | 2012-08-08 00:00:00 | Pen | 20
I want formula which will give highest sales qty of pen within specified dates and the name of sales person
 |  | Qty ? | Sale person name ?
2012-08-01 00:00:00 | 2012-08-08 00:00:00
Example - | [NAME] has sold total 55 pen so 55 should come in cell C15 and [NAME] name should come in D15
Spreadsheet: 853364d1703237703-copy-a-column-but-only-keep-the-values-excelproblem
Sheet: Sheet1

Numbers | desired result
55 | 55
 | 78
78 | 45
45 | 15
 | 6
 | 9
 | 5
15 | 11
6 | 18
9 | 17
5 | 55
 | 68
11 | 12
 | 48
18 | 54
17 | 2
 | 8
 | 89
 | 56
55
68
12
48
54
2
8
89
56
Spreadsheet: 4a5648fb-7d75-40ab-bbf6-342c39f85b5f
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
TIRU | Test | TIRU | Titanium, Random, [NAME] | Titanium, Random, U | Inductively Coupled Plasma-Optical Emission Spectrometry (ICP-OES) | [NAME]: NO Metal cap or glued insert |  |  | 2 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or clean, plastic aliquot container with no metal cap or glued insert  [NAME]: 2 mL Collection Instructions:  1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-2 mcg/L | Thursday; 5 p.m. | Same day/1 day | 7 days | 1 | 83018 |  |  |  |  | Rochester
TIRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
TIRU | Result | 89529 | Titanium, Random, U | Titanium, Random, U | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 90597d1290369920-prioritized-to-do-items-on-separate-worksheets-feed-into-master-worksheet-todo-template-example
Sheet: Sheet1

0 | Cat | SubCat | Task | Status/Due
5 | Character |  | Web research on various (see plan)
5 | Character |  | Family re case history, interventions; also supervision
2 | Finance | Budget | Buy latest [NAME]
2 | Finance | Budget | Add insurance premium increase to budget
2 | Finance | Budget | Return returnable bottles and cans vs. recycling them
1.3 | Job | Employees | Read supervision manual
1.4 | Job | Boss | Correct misimpression
5 | Job | Employees | Write thank you note
5 | People | Friends | [NAME] Friday works
2 | People | Friends | [NAME] decipher the Rosetta Stone
Spreadsheet: 68532d1269043520-formula-disappears-generic-version
Sheet: Rpt Revenue

test
0 |  |  | 0 |  |  | 0 | 0
0 |  |  | 0 |  |  | 0 | 0
0 |  |  | 0 |  |  | 0 | 0
0 |  |  | 0 |  |  | 0 | 0
0 |  |  | 0 |  |  | 0 | 0
TOTAL |  |  | 0 |  |  | 0 | 0
0 | How many?
0 | 0 | 0 |  | 0 | 0
Total |  |  | 0 |  |  | 0 | 0
Total |  |  | 0 |  |  | 0 | 0
Total |  |  | 0 |  |  | 0 | 0
Total |  |  | 0 |  |  | 0 | 0
Total |  |  | 0 |  |  | 0 | 0
Spreadsheet: 842206d1694288508-filter-named-range-and-other-results-based-on-criteria-filter-named-range-and-other-results-based-on-criteria
Sheet: Tables

 | Month | July |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June
 | Company | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount
 | Silver Leases
 | Streamline Rentals
 | Yogaluxe
 | Total
 | Current Month
 | Company | Number | Amount
 | Silver Leases
 | Streamline Rentals
 | Yogaluxe
 | Total
 | Total Fiscal Year | 2023 - 2024
 | Company | Number | Amount
 | Silver Leases
 | Streamline Rentals
 | Yogaluxe
 | Total
Spreadsheet: 56691d1256824190-moving-data-from-one-column-to-another-but-only-if-cell-is-blank-excel-query
Sheet: Sheet1

Approval Date | Part 4,4 Validation Review | Cancelled Date | ECC No
2000-08-31 00:00:00 |  |  | 119659
 |  | 2001-02-15 00:00:00 | 119724
2000-10-04 00:00:00 |  |  | 119780
2001-08-17 00:00:00 |  |  | 145532
 |  | 2002-02-05 00:00:00 | 145545
 |  | 2001-07-10 00:00:00 | 145609
2001-08-02 00:00:00 |  |  | 145622
2001-12-11 00:00:00 |  |  | 154276
 | 2002-09-11 00:00:00 |  | 154284
 | 2002-03-08 00:00:00 |  | 154376
 |  | 2001-10-29 00:00:00 | 154475
 | 2001-12-19 00:00:00 |  | 154515
2001-11-14 00:00:00 |  |  | 154516
Spreadsheet: 50459d1249918219-i-want-to-calculate-a-result-only-if-a-cell-in-a-previous-worksheet-is-populated-holidays-2009-staff-test
Sheet: December

 |  |  | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Name | Entitlement | Total Holiday's Used | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | Full days Booked | 1/2 Days Booked | Holiday's Used | Lateness | Sickness Absence (Current Months Total) | Sickness Absence (Days - Rolling 12 Months) | Sickness Absence Periods (Current Months Total) | Sickness Absence (Periods - Rolling 12 Months) | Bradford Index Score (Rolling 12 Months)
A.N.Other | 25 | 21.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 47 | 0 | 6 | 1692
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | H | 3 | 0
S 1 | L
S 2 | H
S 3 | 0.5
S 4 | AA
S 5 | UA
S 6 | TR
Spreadsheet: 446be26c-0199-4a77-a418-0ec19f529a4e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | College: ______________________________ | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
CLASSIFIED CIVIL SERVICE EMPLOYEE TIMESHEET
NAME: |  |  |  |  |  | TITLE:
CUNYFIRST EMPL ID: |  |  |  |  |  | SUPERVISOR:
PHONE: |  |  |  |  |  | TIMEKEEPER:
DEPARTMENT: |  |  |  |  |  | ASSIGNED WORK SCHEDULE:
LOCATION: |  |  |  |  |  | PERIOD BEGINNING: |  |  |  | 2013-09-28 00:00:00 | Enter Begin Date for Timesheet in the format shown
Instructions: Please see the attached detailed instructions for completing the time sheet.
The daily record of time and attendance is based on the 24-Hour Clock.  Please also see the attached 24-Hour Clock conversion chart.
Daily Record (Completed by Employee) |  |  |  |  |  |  | Used Accrued Time (Completed By Employee) |  |  |  | HR Use Only
 |  |  | LUNCH |  |  | HOURS | SICK | ANNUAL | UH | OTHER | OTHER | COMP | OVER
DAY and DATE |  | IN | OUT | IN | OUT | WORKED | LEAVE | LEAVE | LEAVE | LEAVE | LEAVE | TIME | TIME
2013-09-28 00:00:00 |  |  |  |  |  | 00:00:00
2013-09-29 00:00:00 |  |  |  |  |  | 00:00:00
2013-09-30 00:00:00 |  |  |  |  |  | 00:00:00
2013-10-01 00:00:00 |  |  |  |  |  | 00:00:00
2013-10-02 00:00:00 |  |  |  |  |  | 00:00:00
2013-10-03 00:00:00 |  |  |  |  |  | 00:00:00
2013-10-04 00:00:00 |  |  |  |  |  | 00:00:00
 |  |  |  | Total For The Week |  | 00:00:00 | 0 | 0 | 0 | 0
Daily Record (Completed by Employee) |  |  |  |  |  |  | Used Accrued Time (Completed By Employee) |  |  |  | HR Use Only
 |  |  | LUNCH |  |  | HOURS | SICK | ANNUAL | UH | OTHER | OTHER | COMP | OVER
DAY and DATE |  | IN | OUT | IN | OUT | WORKED | LEAVE | LEAVE | LEAVE | LEAVE | LEAVE | TIME | TIME
2013-10-05 00:00:00 |  |  |  |  |  | 00:00:00
2013-10-06 00:00:00 |  |  |  |  |  | 00:00:00
2013-10-07 00:00:00 |  |  |  |  |  | 00:00:00
2013-10-08 00:00:00 |  |  |  |  |  | 00:00:00
2013-10-09 00:00:00 |  |  |  |  |  | 00:00:00
2013-10-10 00:00:00 |  |  |  |  |  | 00:00:00
2013-10-11 00:00:00 |  |  |  |  |  | 00:00:00
 |  |  |  | Total For The Week |  | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  | Total For The Period |  | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  | Employee Certification: By signing below I hereby certify that the time reported is accurate.
 |  |  |  |  | Employee Signature:
 |  |  |  |  | Supervisor Signature:
 |  |  |  |  | Timekeeper Signature: