tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 715922d1611923875-column-linking-between-sheets-choral-library-sample
Sheet: Sheet1

CALL # | TITLE | TITLE2 | COMP ARR LAST | COMP ARR FIRST | VOICING | STYLE PERIOD | NO. OF COPIES | PUBLISHER | PUBLISHER NUMBER | [NAME] | [NAME] | Currently Checked Out | Updated 2019
0001 | [NAME]'s Canon |  | [NAME] | [NAME] | SATB | Romantic | 37 | Broude Brothers | B.B. 117 | Secular |  |  | X
0002 | Sometimes I Feel Like A Motherless Child |  | [NAME] | [NAME] | SATB | 20th Century | 47 | Hal Leonard Publishing Corporation | 08603701 | Sacred |  |  | X
0003 | Rejoice In The Lord |  | Eddleman | [NAME] | SATB | 20th Century | 110 | Jenson Publications Inc. | 422-18014 | Sacred |  |  | X
0004 | Holy Is God |  | [NAME] | C.P.E. | SATB | Classical | 86 | Concordia Publishing House | 97-6223 | Sacred |  |  | X
0005 | Forth From Jesse Sprang A Rose |  | [NAME] | [NAME] | SATB | Romantic | 88 | Boosey & Hawkes Inc. | 5405 | Sacred |  |  | X
0006 | I Thought That Love Had Been A Boy |  | Byrd | [NAME] | SATB | Renaissance | 19 | [NAME] | 12583-3 | Secular |  |  | X
0008 | Nenia |  | [NAME] | Johannes | SATB | Romantic | 35 | [NAME] | 6111 | Secular |  |  | X
W0001 | [NAME] |  | [NAME] | M. | SSA | 20th Century | 29 | [NAME] | 42555 or 471-7 | Secular
W0002 | Let There Be Peace On Earth |  | Ades | Hawley | SSA | 20th Century | 30 | Shawnee Press Inc | E-38 | Sacred
W0003 | Beloved It Is Morn |  | Lucas | Clarence | SSA | 20th Century | 22 | Chapell-Harms INC. | C6614 | Sacred
W0004 | Call, The |  | [NAME] | Mark | SSA | 20th Century | 44 | G Shirmer INC. | 21526c | Secular
W0011 | [NAME] (from Cantata No. 140) |  | [NAME] | [NAME] | SSA | Baroque | 23 | [NAME] | Sleepytime bach 11 | Sacred
W0012 | Lovliest Of Trees | (from Three Songs In Praise Of Spring) | [NAME] | [NAME] | SSA | 20th Century | 37 | Caveat Music Publishers INC | 3476-124 | Secular
W0013 | Jesu, Joy of Man's Desiring |  | [NAME] | J.S. | SSA | Baroque | 29 | E.C. Shirmer Music Co. | E.C.S. No. 320 | Sacred
M0001 | Bells Of St Mary's, The |  | Lucas | Clarence | TTB | 20th Century | 16 | Chappell & Co., Inc. | 1001 | Secular
M0002 | [NAME] |  | [NAME] | Mark | TTB | 20th Century | 8 | H.W. Gray Co. | 31 | Secular
M0003 | Sea Fever |  | [NAME] | Mark | TTB | 20th Century | 4 | [NAME], Inc. | 6834 | Secular
M0004 | Blow The Wind Southerly |  | [NAME] | [NAME] | TTB | 20th Century | 25 | Boosey & Co., Ltd. | 5234 | Secular
M0005 | Ave [NAME] |  | Arcadelt | [NAME] | TTB | Renaissance | 30 | E.C. Schirmer Music Co. | 526 | Sacred
M0006 | Smiles |  | Ades | Hawley | TTB | 20th Century | 26 | Shawnee Press, Inc. | C-253 | Secular
M0007 | And Now 'tis Time To Go | MISSING | Diack | [NAME] | TTB | Baroque |  |  |  | Secular
Spreadsheet: 679211d1590255630-tricks-for-using-concatenate-result
Sheet: Sheet1

Name | Data I | Data II | Data III
[NAME] | text B2, text B3 | text II | text III
[NAME] | text B3 | text II | text III
[NAME] | text B4 | text II | text III
[NAME] | text B5 | text II | text III
[NAME] | text B6, text [NAME], text B8 | text II | text III
George | text B7 | text II | text III
[NAME] | text B8 | text II | text III
[NAME] | text B9 | text II | text III
[NAME] | text B10 | text II | text III
1) Want to enter into B2 cell: concatenation of B2 and B3 with a , between the values. Result = text B2, text B3.
2) Want to enter into [NAME] cell: concatenation of B6, [NAME] and [NAME] with a , between the values. Result = text [NAME], text [NAME], text B8.
3) Need to quickly insert a similar formula (of each 2 or 3 concatenation) in various different cells in this large spreadsheet.
4) Enter a concatenation forumula in a cell here (say B17)  that would insert the concatenated values from a different Excel sheet. [NAME] concatenated data of remote cell G546, remote cell G547, remote cell G548
 | remote cell G546, remote cell G547, remote cell G548
Spreadsheet: 467163d1466600688-how-to-calculate-how-many-sums-of-an-increasing-number-fits-into-another-number-kopia-example
Sheet: Sheet1

 |  |  | Maximum weapon upgrade
 | Level | Gold | Sword | Bow | Axe |  |  |  | Weapon upgrades cost
 | 1 | 500 |  |  |  |  |  | Upgrade | Sword | Bow | Axe
 | 2 | 600 |  |  |  |  |  | 1 | 100 | 300 | 500
 | 3 | 700 |  |  |  |  |  | 2 | 200 | 500 | 800
 | 4 | 800 |  |  |  |  |  | 3 | 300 | 700 | 1100
 | 5 | 900 |  |  |  |  |  | 4 | 400 | 900 | 1400
 | 6 | 1000 |  |  |  |  |  | 5 | 500 | 1100 | 1700
 | 7 | 1100 |  |  |  |  |  | Base (upg1) | 100 | 300 | 500
 | 8 | 1200 |  |  |  |  |  | Each UP+ | 100 | 200 | 300
 | 9 | 1300
 | 10 | 1400
Spreadsheet: 677563d1589397445-pivot-table-filter-deearo-
Sheet: Sheet3

38
I WOULD LIKE THIS COOLUM TO PULL UP ALL FILTERS FOR 38 | I WOULD LIKE THIS COOLUM TO SUM UP THE TOTAL FOR EACH FILTER
IF REPAIRS 38 DOESN’T WORK IN A FORMULA  - I CAN DO THIS MANUALLY
I WOULD LIKE TO EDIT OUT [NAME] *20% IF NEEDED
I DON’T MIND EDITING THE FILTER CRITERIA WITHIN THE FORMULA
INFORMATION GATHER FROM SHEET 1
HOUSE | OUT
TOTAL
Spreadsheet: jeff_dasovich__14187__E204-Harrus Feeding
Sheet: Harrus

Harrus Feeding Company
 |  |  |  |  | Total Cost
Cost / lb. | 60 | 40 | 35 | 5
 | Corn | Wheat | Barley | Hay
Pounds | 0 | 0 | 0 | 0 |  | = | 24
 |  |  |  |  | Total lbs.
 | Units of Nutrient |  |  |  |  |  | Daily
 | per Pound of Feedstuff |  |  |  | Nutrient |  | Requirement
 | Corn | Wheat | Barley | Hay | Total
[NAME] | 2 | 1 | 3 | 4 |  | <= | 100
Fat Min | 2 | 1 | 3 | 4 |  | >= | 25
[NAME]. Min | 20 | 15 | 15 | 10 |  | >= | 400
Iron Min | 4 | 7 | 6 | 5 |  | >= | 125
Cal. Min | 200 | 400 | 300 | 500 |  | >= | 6000
Spreadsheet: 202617d1356647335-how-can-i-create-a-point-system-for-attendance-tardies-absents-etc-absent-moo
Sheet: DASHBOARD

 | 2012-10-01 00:00:00 | 2012-10-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-11-01 00:00:00 | 2012-11-01 00:00:00
Employees | Tardies | Excused Call-ins | Unexcused call-ins | Tardies | Excused call-ins | Unexcused call-ins |  | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | Total
[NAME]
[NAME]
[NAME]
Sue
Spreadsheet: kate_symes__18911__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-03-23 00:00:00 |  | 240.51 | 624 | 143.75 | 880
 | 2001-03-22 00:00:00 |  | 282.93 | 464 | 175.42 | 2032 | 299.77 | 1910 | 211.67 | 1390
 | 2001-03-21 00:00:00 |  | 353.67 | 1024 | 220.45 | 880 | 351.62 | 4153 | 259.99 | 1589
 | 2001-03-20 00:00:00 |  | 323.59 | 624 | 221.88 | 1600 | 281.92 | 1957 | 245.43 | 1616
 | 2001-03-19 00:00:00 |  | 291.72 | 1024 | 197.04 | 1272 | 197.2 | 635 | 225 | 20
 | 2001-03-18 00:00:00 |  | 220 | 0 | 182.5 | 0 | 149.33 | 1225 | 119.19 | 980
 | 2001-03-17 00:00:00 |  | 204.13 | 1008 | 134.76 | 2888 | 180.48 | 2250 | 127.55 | 570
 | 2001-03-16 00:00:00 |  | 204.13 | 1008 | 134.84 | 2864 | 209.71 | 1442 | 126.88 | 1046
 | 2001-03-15 00:00:00 |  | 180.74 | 2160 | 109.85 | 2184 | 189 | 2490 | 123.8 | 1881
 | 2001-03-14 00:00:00 |  | 163.59 | 1024 | 89.3 | 696 | 152.63 | 4365 | 107.38 | 1787
 | 2001-03-13 00:00:00 |  | 166.63 | 2064 | 81.94 | 1392 | 154.62 | 2586 | 118.47 | 1995
 | 2001-03-12 00:00:00 |  | 172.81 | 1424 | 102.15 | 1696 | 159.9 | 3783 | 116.27 | 2115
 | 2001-03-11 00:00:00 |  | 145 | 160 | 95 | 0 | 118.53 | 2962 | 105.52 | 2029
 | 2001-03-10 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 103.36 | 1254 | 105.49 | 1840
 | 2001-03-09 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 155.44 | 2180 | 106.38 | 1520
 | 2001-03-08 00:00:00 |  | 180 | 400 | 99 | 1000 | 173.53 | 731 | 126.23 | 1620
 | 2001-03-07 00:00:00 |  | 271.07 | 448 | 177.36 | 1664 | 205.39 | 1019 | 146.01 | 1746
 | 2001-03-06 00:00:00 |  | 302.29 | 944 | 166.83 | 1072 | 202.39 | 2764 | 134.22 | 1696
 | 2001-03-05 00:00:00 |  | 280 | 800 | 172.5 | 800 | 189.65 | 2226 | 131.16 | 1376
 | 2001-03-04 00:00:00 |  | 230 | 0 | 170 | 400 | 171.88 | 2765 | 131.78 | 1320
 | 2001-03-03 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 170.84 | 1909 | 147.7 | 685
 | 2001-03-02 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 204.08 | 1930 | 128.66 | 1229
 | 2001-03-01 00:00:00 |  | 267.19 | 512 | 141.82 | 880 | 233.33 | 777 | 144.63 | 726
 | 2001-02-28 00:00:00 |  | 170 | 320 | 112.22 | 1800 | 230.04 | 274 | 158.91 | 659
 | 2001-02-27 00:00:00 |  | 171 | 64 | 113.75 | 1600 | 176.51 | 603 | 108.24 | 1877
 | 2001-02-26 00:00:00 |  | 177.86 | 224 | 133.56 | 1392 | 157.54 | 2280 | 111.96 | 1798
 | 2001-02-25 00:00:00 |  | 147.5 | 0 | 135 | 280 | 131.22 | 2999 | 108.91 | 2383
 | 2001-02-24 00:00:00 |  | 174.29 | 224 | 115.26 | 1560 | 148.66 | 1535 | 132.09 | 1146
 | 2001-02-23 00:00:00 |  | 174.29 | 224 | 115.54 | 1480 | 166.64 | 2128 | 118.23 | 893
 | 2001-02-22 00:00:00 |  | 201.14 | 224 | 118.5 | 1312 | 160.02 | 656 | 90.98 | 787
 | 2001-02-21 00:00:00 |  | 210 | 224 | 148.86 | 560 | 161.32 | 1192 | 89.98 | 1296
Spreadsheet: 0f05b788-4497-4e9e-a8d7-71ed8a579a37
Sheet: 9c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis* | 58295 | 50838 | 132719 | <1,000 |  |  |  |  |  | 241852
FRA |  |  | 432775 | 138052 |  | 315037 |  | 926509 |  | 1812373
IRS- [NAME] | 1993972 | 1991364 | 1358799 | 95466 |  | 238664 | 428501 | 795209 | 373346 | 7275321
OIS |  | 127817 | 72600 |  |  |  |  |  |  | 200417
VNS |  |  |  |  |  |  |  |  |  | 0
Zero Coupon |  | <1,000 |  |  |  |  |  | <1,000 |  | <1,000
TOTAL | 2052267 | 2170019 | 1996893 | 233518 | 0 | 553701 | 428501 | 1721718 | 373346 | 9529963
Estimated gross notional amount outstanding, November 30 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 552482d1513607841-index-match-formula-not-returning-expected-result-example2
Sheet: Daily

Month | May 2017
Date | Tx | Time | Tn | Time | Dr | Fd | R | Rmr | Time | Rd | S | W | Wmm | Time | Wmg | Time | Cw | BP | BPx | Time | BPn | Time | RH | RHx | Time | RHn | Time | DPx | Time | DPn | Time | 09 Tx | Time | 09 Tn | Time | 09 R | Time | SF | SL | TH | HA | FG
2017-05-01 00:00:00
Spreadsheet: 677258d1589269443-count-how-many-child-id-who-has-false-3-consecutive-days-student-attendance
Sheet: Children Attendance

Attendance ID | Child ID | Attendance Date | Child is Present?
1 | 11 | 2020-05-06 00:00:00 | False
2 | 12 | 2020-05-06 00:00:00 | True
3 | 13 | 2020-05-06 00:00:00 | True
4 | 14 | 2020-05-06 00:00:00 | True
5 | 11 | 2020-05-07 00:00:00 | False
6 | 12 | 2020-05-07 00:00:00 | False
7 | 13 | 2020-05-07 00:00:00 | True
8 | 14 | 2020-05-07 00:00:00 | True
9 | 11 | 2020-05-08 00:00:00 | False
10 | 12 | 2020-05-08 00:00:00 | True
11 | 13 | 2020-05-08 00:00:00 | False
12 | 14 | 2020-05-08 00:00:00 | False
13 | 11 | 2020-05-09 00:00:00 | True
14 | 12 | 2020-05-09 00:00:00 | False
15 | 13 | 2020-05-09 00:00:00 | False
16 | 14 | 2020-05-09 00:00:00 | False
17 | 11 | 2020-05-11 00:00:00 | True
18 | 12 | 2020-05-11 00:00:00 | True
19 | 13 | 2020-05-11 00:00:00 | True
20 | 14 | 2020-05-11 00:00:00 | False
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 137CE

137CE
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-10-28 00:00:00 |  |  | RJS | N/A | N/A | N/A | JAD |  | 2008-05-14 00:00:00 | 2010-09-08 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
DEEMER |  | 2010-09-08 00:00:00 |  | THIS ACCOUNT HAS CAT B AUTHORIZATIONS; ASSETS ARE MAINTAINED IN BASE STOCK. NO AM427G COUNT SHEET IS REQUIRED. THE SIGNED RESULTS LETTER FULFILLS THE REQUIREMENT FOR A QUARTERLY INVENTORY.
GENERAL ACCOUNT INFORMATION / NOTES
AIR FORCE RESERVE [NAME] ACCOUNT… NO ASSETS ON HAND BUT STILL HAS CAT B AUTHORIZATIONS. A QUARTERLY ACCOUNT REVIEW MFR PACKAGE IS EMAILED TO CUSTODIAN EVERY QUARTER.  17Nov10-Rennhack--Talked with [NAME], sent him a blank 68 and their current one as a reference.  I stressed the urgency of getting it completed ASAP
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: 1ab74776-5903-4c30-a8df-279a340763ac
Sheet: Sheet1

Table 5--Cottonseed meal:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Imports | Production | Total |  | Domestic | Exports | Total | stocks
 |  |  |  | 1,000 short tons
2010/11 | 54.233 | 0 | 1163 | 1217.233 |  | 1079.705 | 92.528 | 1172.233 | 45
2011/121 | 45 | 0.2 | 1090 | 1135.2 |  | 990.2 | 95 | 1085.2 | 50
2012/132 | 50 | 0.2 | 1170 | 1220.2 |  | 1085.2 | 85 | 1170.2 | 50
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2012-10-17 11:37:51.870000
Spreadsheet: 159264d1338563775-creating-a-quotation-by-selecting-items-on-another-page-in-the-same-workbook-poundsy-excelexamplequote
Sheet: Quick Quote

Example Quick Quote Sheet
Quantity | Part No. | Part Description | Ext Price | Unit Price
 |  | Section 1
5 | 1
 | 2
1 | 3
2 | 4
 |  | Section 2
 | 5
2 | 6
 | 7
 | 8
 |  | Section 3
10 | 9
 | 10
 | 11
 | 12
 |  | Section 4
 | 13
 | 14
 | 15
10 | 16
 | 17
 | 18
 | 19
 | 20
 |  | Section 5
 | 21
 | 22
 | 23
 |  | Section 6
2 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 |  | Section 7
1 | 33
 | 34
 | 35
 | 36
1 | 37
1 | 38
 |  | Section 8
2 | 39
 | 40
 |  | Section 9
 | 41
 | 42
1 | 43
1 | 44
 | 45
 | 46
 | 47
1 | 48
 | 49
 | 50
 |  | Total
Spreadsheet: larry_campbell__20967__Preliminary Costs - Sun Devil
Sheet: Sheet1

Transwestern Project Sun Devil
ENSR Cost Estimate for Environmental Support
Project Manager: [NAME]
 |  | Phase I |  | Phase II
 |  | thru 3/2002 |  | thru 12/2002
TASKS |  | SUBTOTAL |  | SUBTOTAL
1 | Data Collection and Review | 30000
2 | Agency Consultation | 30000 |  | 10000
3 | Route Selection | 30000
4 | Wildlife Habitat/Land Use Field Surveys | 30000
5 | T&E Species Surveys |  |  | 160000
6 | Wetland Delineation and Report | 120000
7 | Cultural Resources Survey and Report | 400000 |  | 100000
8 | Cultural Resources Testing/Mitigation |  |  | 300000
9 | FERC Resource Reports | 100000
10 | Response to FERC Data Requests |  |  | 20000
11 | Biological Assessment | 30000
12 | Map/Alignment Sheet Review | 15000
13 | Section 404 Permits |  |  | 25000
14 | Air Quality Permits | 20000 |  | 20000
15 | Water Withdrawal/Discharge Permits |  |  | 25000
16 | Agency/Public Meetings | 30000 |  | 20000
17 | Coordination Meetings | 30000 |  | 30000
18 | Project Management | 75000 |  | 75000
19 | GIS Web Page Set Up & Maintenance | 20000 |  | 30000
 | ENSR PROJECT TOTAL
Third-Party Contractor |  | 150000 |  | 350000
 |  | Phase I |  | Phase II
 | PROJECT GRAND TOTAL
Spreadsheet: 131100d1322741507-different-number-formatting-in-dynamic-chart-graph-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Set 1 |  | Set 2 |  |  | Set 3
 |  |  |  |  |  |  |  |  |  | No | Base | Mean | Median | Base | Mean % | Median % | Base
 |  |  |  |  |  |  |  |  | 2009 | 20 | 10 | 10 | 8 | 12 | 0.14 | 0.12 | 14
 |  |  |  |  |  |  |  |  | 2010 | 30 | 8 | 16 | 15 | 9 | 0.18 | 0.16 | 9
 |  |  |  |  |  |  |  |  | Set 1 | Set1 | 1
 |  |  |  |  |  |  |  |  | Set 2 | Set2 | 2
 |  |  |  |  |  |  |  |  | Set 3 | Set3 | 2
 |  |  |  |  |  |  |  |  | 1 | Set1 | 1 | <------------------ this is the range selected for chart
 |  |  |  |  |  |  |  |  |  | 2009 | 2010 | <----------------- this is the data actually used for chart
 |  |  |  |  |  |  |  |  | No | 20 | 30 | <----------------- either 1 or 2 rows (base is not charted)
 |  |  |  |  |  |  |  |  | Base | 10 | 8
Spreadsheet: 58349d1258625508-count-sum-bi-weekly-screeninglog
Sheet: MTHLY REPORTING

Screening
Subjects
- No of malaria | 3
- No of viral meningitis (Lab) | 0
- No of viral meningitis (Clinical) | 0
- No of bacterial meningitis (Lab) | 0
- No of bacterial meningitis (Clinical) | 0
- Total discharges | 3
- Total runaways | 1
- Total deaths | 1
- Total lost to followup | 1
Spreadsheet: 740279d1626266296-sequence-numbers-based-on-condition-of-more-than-one-cell-wo-ser-wip
Sheet: Serials

Customer | Customer PO | Date | Works Order | Job Number | Qty | S/N Rqd? | Start Ser No | End Ser No | Notes: USE QTY 1 FOR CUSTOMER SPECIFIC SER NOS AND A RECORD DETAILS ON APPROPRIATE SHEET
A | 12110355 | 2021-06-25 00:00:00 | 2021-06-0045 | HCD1829 | 6 | Y | 186301
B | 102234B | 2021-06-28 00:00:00 | 2021-06-0046 | HCD5114 | 7 | N
C | 102233 | 2021-06-28 00:00:00 | 2021-06-0047 | HCD5054 | 5 | Y
D | 37658 | 2021-07-01 00:00:00 | 2021-07-001 | HCD4994 | 15 | Y
E | 36758 | 2021-07-01 00:00:00 | 2021-07-002 | HCD4993 | 10 | n
F | [NAME] | 2021-07-02 00:00:00 | 2021-07-003 | HCD3252 | 2 | Y
G | [NAME] | 2021-07-06 00:00:00 | 2021-07-005 | HCD5042 | 3 | Y
H | [NAME] | 2021-07-06 00:00:00 | 2021-07-006 | HCD5044 | 30 | Y
D | E56341 | 2021-07-06 00:00:00 | 2021-07-007 | HCD2843 | 60 | Y
 |  |  |  |  | 1 | y
 |  |  |  |  | 1 | y
Spreadsheet: 775098d1648820910-if-function-using-and-with-dates-example
Sheet: Sheet1

Entry | Exit |  | IF1 -  Entry >= 1/1/22 | IF2 - Entry <= 31/1/22 | AND (IF1,IF2)
2021-11-26 00:00:00 | 2021-12-22 00:00:00
2021-11-26 00:00:00 | 2021-12-22 00:00:00 |  | 0 | True
2021-12-03 00:00:00 | 2021-12-11 00:00:00 |  | 0 | True
2021-12-22 00:00:00 | 2022-02-10 00:00:00 |  | 0 | True
2022-01-06 00:00:00 | On |  | True | True
2022-01-07 00:00:00 | 2022-01-22 00:00:00 |  | True | True
2022-01-07 00:00:00 | On |  | True | True
2022-01-07 00:00:00 | 2022-01-24 00:00:00 |  | True | True
2022-01-07 00:00:00 | 2022-01-24 00:00:00 |  | True | True
2022-01-07 00:00:00 | 2022-01-28 00:00:00 |  | True | True
2022-01-07 00:00:00 | 2022-01-24 00:00:00 |  | True | True
2022-01-07 00:00:00 | 2022-01-25 00:00:00 |  | True | True
2022-01-07 00:00:00 | 2022-01-24 00:00:00 |  | True | True
2022-01-07 00:00:00 | 2022-01-22 00:00:00 |  | True | True
2022-01-08 00:00:00 | 2022-02-04 00:00:00 |  | True | True
2022-01-11 00:00:00 | 2022-01-31 00:00:00 |  | True | True
2022-01-13 00:00:00 | 2022-03-02 00:00:00 |  | True | True
2022-02-01 00:00:00 | 2022-03-18 00:00:00 |  | True | 0
2022-02-04 00:00:00 | On HFH |  | True | 0
2022-02-07 00:00:00 | 2022-02-23 00:00:00 |  | True | 0
Spreadsheet: 270112d1381385768-please-help-adding-negative-time-timesheet-example-copy
Sheet: Sheet1

Date | Start time | [NAME] | [NAME] | Finish Time | Hours Worked | Hours required | Comments | Time to bank/ extra hours to be worked | End of week accrual
2013-10-14 00:00:00 | 08:00:00 | 12:00:00 | 12:30:00 | 17:00:00 |  | 08:10:00
2013-10-15 00:00:00 | 08:00:00 | 12:00:00 | 12:40:00 | 17:30:00 |  | 08:10:00
2013-10-16 00:00:00 | 08:10:00 | 12:00:00 | 12:30:00 | 17:00:00 |  | 08:10:00
2013-10-17 00:00:00 | 08:00:00 | 12:00:00 | 12:40:00 | 17:00:00 |  | 08:10:00
2013-10-18 00:00:00 | 08:00:00 | 12:00:00 | 12:40:00 | 17:00:00 |  | 08:10:00
Weekly Total
2013-10-21 00:00:00 | 08:00:00 | 12:00:00 | 12:30:00 | 13:00:00 |  | 08:10:00
2013-10-22 00:00:00 | 08:00:00 | 12:00:00 | 12:40:00 | 14:00:00 |  | 08:10:00
2013-10-23 00:00:00 | 08:10:00 | 12:00:00 | 12:30:00 | 15:00:00 |  | 08:10:00
2013-10-24 00:00:00 |  |  |  |  |  | 08:10:00 | Sick
2013-10-25 00:00:00 |  |  |  |  |  | 08:10:00 | Sick
Weekly Total
2013-10-28 00:00:00 |  |  |  |  |  | 08:10:00 | Annual Leave
2013-10-29 00:00:00 |  |  |  |  |  | 08:10:00 | Annual Leave
2013-10-30 00:00:00 |  |  |  |  |  | 08:10:00 | Annual Leave
2013-10-31 00:00:00 |  |  |  |  |  | 08:10:00 | Annual Leave
2013-11-01 00:00:00 |  |  |  |  |  | 08:10:00 | Annual Leave
Weekly Total
Spreadsheet: 595438d1540440364-extracting-data-in-rows-extracting-data-in-rows
Sheet: LOOKS LIKE THIS

2008-07-31 | USGS-414501111520001 | Carbon dioxide | 14 | mg/l
2008-07-31 | USGS-414501111520001 | Hardness, Ca, [NAME] | 214 | mg/l CaCO3
2008-07-31 | USGS-414501111520001 | Sodium adsorption ratio [(Na)/(sq root of 1/2 [NAME])] | 0.52 | None
2008-07-31 | USGS-414501111520001 | Sodium, percent total cations | 15 | %
2008-07-31 | USGS-414501111520001 | Total dissolved solids | 292 | mg/l
2008-07-31 | USGS-414501111520001 | Total dissolved solids | 0.43 | tons/ac ft
2008-07-31 | USGS-414501111520001 | Alkalinity, total | 222 | mg/l CaCO3
2008-07-31 | USGS-414501111520001 | Fluoride | 0.29 | mg/l
2008-07-31 | USGS-414501111520001 | Silica | 21.5 | mg/l
2008-07-31 | USGS-414501111520001 | Iron
2008-07-31 | USGS-414501111520001 | Manganese
2008-07-31 | USGS-414501111520001 | Molybdenum | 0.666 | ug/l
2008-07-31 | USGS-414501111520001 | Selenium | 0.17 | ug/l
2008-07-31 | USGS-414501111520001 | Gross-Uranium | 0.615 | ug/l
2008-07-31 | USGS-414501111520001 | Total dissolved solids | 318 | mg/l
2008-07-31 | USGS-414501111520001 | Specific conductance | 496 | uS/cm @25C
2008-07-31 | USGS-414501111520001 | Arsenic | 1.3 | ug/l
2008-07-31 | USGS-414501111520001 | Sulfate | 21.1 | mg/l
2008-07-31 | USGS-414501111520001 | Chloride | 14.6 | mg/l
2008-07-31 | USGS-414501111520001 | Potassium | 5.34 | mg/l
2008-07-31 | USGS-414501111520001 | Calcium | 51.7 | mg/l
2008-07-31 | USGS-414501111520001 | Magnesium | 20.7 | mg/l
2008-07-31 | USGS-414501111520001 | Sodium | 17.4 | mg/l
2008-07-31 | USGS-414501111520001 | pH | 7.5 | std units
2008-07-31 | USGS-414501111520001 | Temperature, water | 20.8 | deg C
2008-07-31 | USGS-414501111520001 | Specific conductance | 496 | uS/cm @25C
Spreadsheet: 3b17dda4-f4cb-42f1-ab8c-cb840a522a5d
Sheet: Communication

Please indicate the most effective method for improving faculty awareness and use of Starfish (select one):
 | Response | %
Scheduled training sessions | 20 | 0.23
Department meetings | 22 | 0.26
All faculty meetings | 5 | 0.06
Website | 12 | 0.14
[NAME] | 22 | 0.26
Other | 5 | 0.06
Total | 86 | 1
Spreadsheet: 537401d1505050633-forumal-assistance-2017-to-2018-emails-one-on-one
Sheet: Emails Performance Tracking

Performance Discussion
Employee Name:
Employee Number:
Team Leader Name:
Topic of discussion:
Date of Discussion:
Performance Area | Target | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Quality | 0.9
PKA | 0.9
TAT | 4 | 6
VOC | 0.8
Productivity | 0.95
Compliance | 0.9
Key Performance Target Ratings
Performance Area |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Quality
PKA
TAT
VOC
Productivity
Compliance
Compliance assessments
Leave management
Compliance
Areas of Strength |  | Comments
Quality
PKA
TAT
VOC
Productivity
Areas of Development
Team Leader Comments:
Agent Comments:
Spreadsheet: 686275d1594469111-problem-with-formula-to-display-blank-cells-or-running-balance-sample-accounts-balance-problem-no-blanks-1-aligw
Sheet: Sheet1

Date | Payee | Description | Full cost | RS share | Cumulative total
2020-03-28 00:00:00 | Butcher | Groceries | 12.05 | 6.03
2020-03-28 00:00:00 | Waitrose | Groceries | 60.58 | 30.29
2020-03-28 00:00:00 | Shell | Groceries | 31.93 | 15.97
2020-04-04 00:00:00 | Sainsburys | Groceries | 49.79 | 29.9
2020-04-04 00:00:00 | [NAME] | Prescription charge for BP prescription | 18.3 | 18.3
2020-04-06 00:00:00 | M&S | Groceries | 13.13 | 6.57
 | Diet Chef | 1 month supply ordered by RS | -275 | -137.5
2020-04-10 00:00:00 | EB | Balance paid |  | 30.44
2020-04-11 00:00:00 | Bansted Fruiterers | Fruit & Veg | 8.59 | 4.27
2020-04-09 00:00:00 | Sainsburys | Groceries |  | 34
2020-04-10 00:00:00 | BP | Groceries & newspapers (no newsagent delivery) | 11.93
 |  |  | 17 | 5
 |  |  | 25 | 7
 |  |  | 25 | 17
Total