tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0bd6b21c-1673-46c3-a45c-1f89e48e2055
Sheet: Sheet1

[NAME] of Northeast Texas GS GOLD AWARD PROJECT TIME LOG | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Submit this form to Council with your Final Report.  Keep a copy for you and your advisor.
Name:
Project Title:
Please keep in mind the following Timeline guidelines:
*Projects should total at least 80 hours
*Entries in the Timeline should be in 5 hour increments or less
*You may count up to 5 hours for time spent completing the proposal/final paperwork
*You may count up to 15 hours of pre-work. Activities in this category may include researching community needs, contacting/meeting with organizations to sponsor your project, securing a project advisor, etc.
*You may count up to 5 hours for travel time
*You may count up to 7 hours for money-earning projects
*You should clearly identify at least 20 hours of leadership.
*Events must be at least 8 hours in length, including set-up/clean-up.
*You may count up to 3 hours for set up/clean up. If you're doing multiple events, you may count up to 5 hours.
Directions:
*List your project steps in the order that they occurred
*Be as detailed as possible
*Hours should be in decimal format (ex.: 45 minutes = .75 hours)
*If the step involves leadership hours, list them separately in column (6)
*If the step involves volunteers, mark an "X" in column (7)
*Excel will automatically add up your entries
*Attach additional sheets as necessary or add additional rows above "Total PROJECT Hours"
(1)       Date | (2)                                                                                               Project Action Step | (3)            Time Start | (4) Time End | (5)                   Project Hrs | (6) [NAME] | (7)                      Volunteers Used
2010-01-01 00:00:00 | Ex.: Created Powerpoint to be used to ask for donations | 08:00:00 | 10:00:00 | 2 | - | -
2010-02-03 00:00:00 | Ex.: Taught volunteers how to sew blanket squares together | 09:00:00 | 12:00:00 | - | 3 | X
 | Total PROJECT Hours |  |  | 0
 | Total LEADERSHIP Hours (Min. 20) |  |  |  | 0
 | TOTAL HOURS (Min. 80) |  |  | 0
 | Girl Signature |  | Date
 | Project Advisor Signature |  | Date
 | Liasion Signature |  | Date
Spreadsheet: 38889554-0ced-4690-bccc-87518d6c3885
Sheet: Fields 5-8

Permit No.: |  |  | WQ0021289 |  |  | Facility Name: |  | Town of Hertford WWTF |  |  |  |  |  | County: | Perquimans |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 5 |  | Field Name: |  | 6 |  | Field Name: |  | 7 |  | Field Name: |  | 8
 |  |  |  |  |  | Area (acres): |  | 9.57 |  | Area (acres): |  | 8.4 |  | Area (acres): |  | 8.16 |  | Area (acres): |  | 8.51
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3
 |  |  |  |  |  | Annual Rate (in): |  | 48.3 |  | Annual Rate (in): |  | 51.6 |  | Annual Rate (in): |  | 51.9 |  | Annual Rate (in): |  | 58.4
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 121060d1315818955-unique-values-from-a-list-of-values-unique-value
Sheet: Sheet1

Data |  | Result
Person1 |  | Person1
Person3 |  | Person2
Person5 |  | Person3
Person4 |  | Person4
Person5 |  | Person5
Person2
Person3
Person4
Person3
Person4
Person5
Person1
Person2
Person3
Person5
Person1
Spreadsheet: 713824d1610962399-formula-to-sum-column-with-multi-criteria-in-other-columns-test
Sheet: KW 01 Gesamt

 | GEV Gesamt
 |  | KW | Uhrzeit | [NAME] | Gespräche | LC | An Extern
 |  | 1 | 0 - 1
 |  |  | 1 -2
 |  |  | 2 - 3
 |  |  | 3 - 4
 |  |  | 4 - 5
 |  |  | 5 - 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 - 20
 |  |  | 20 - 21
 |  |  | 21 - 22
 |  |  | 22 - 23
 |  |  | 23 - 24
 | Lost Calls Quote |  |  |  | Gesamt
 | Lost Calls Quote Randzeit |  |  |  | 24 - 07 Uhr
 | Lost Calls Quote Kernzeit |  |  |  | 07 - 16 Uhr
 | Lost Calls Quote Randzeit |  |  |  | 16 - 24 Uhr
 | GEV Gesamt Dedicated
 |  | KW | Uhrzeit | [NAME] | Gespräche | LC | An Extern
 |  | 1 | 0 - 1
 |  |  | 1 -2
 |  |  | 2 - 3
 |  |  | 3 - 4
 |  |  | 4 - 5
 |  |  | 5 - 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 - 20
 |  |  | 20 - 21
 |  |  | 21 - 22
 |  |  | 22 - 23
 |  |  | 23 - 24
 | Lost Calls Quote |  |  |  | Gesamt
 | Lost Calls Quote Randzeit |  |  |  | 24 - 07 Uhr
 | Lost Calls Quote Kernzeit |  |  |  | 07 - 17 Uhr
 | Lost Calls Quote Randzeit |  |  |  | 17 - 24 Uhr
 | GEV Gesamt Überlauf
 |  | KW | Uhrzeit | [NAME] | Gespräche | LC | An Extern
 |  | 1 | 0 - 1
 |  |  | 1 -2
 |  |  | 2 - 3
 |  |  | 3 - 4
 |  |  | 4 - 5
 |  |  | 5 - 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 - 20
 |  |  | 20 - 21
 |  |  | 21 - 22
 |  |  | 22 - 23
 |  |  | 23 - 24
 | Lost Calls Quote |  |  |  | Gesamt
 | Lost Calls Quote Randzeit |  |  |  | 24 - 07 Uhr
 | Lost Calls Quote Kernzeit |  |  |  | 07 - 17 Uhr
 | Lost Calls Quote Randzeit |  |  |  | 16 - 24 Uhr
Spreadsheet: 707885d1607525196-how-to-assign-a-country-to-a-specific-area-dashboard
Sheet: FRANCE

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: 29933d1225200881-vlookup-for-dynamic-ranges-vlookuphelp
Sheet: values

FRUIT | COST
Apple | 1.23
Orange | 0.3
[NAME] | 2.34
[NAME] | 2.45
Apple | 2.45
Apple | 1.55
Orange | 0.56
Apple | 1.17
Apple | 1.89
Orange | 0.76
Orange | 0.99
[NAME] | 1.99
Orange | 0.84
[NAME] | 2.01
[NAME] | 2.13
Spreadsheet: 759431d1639536956-if-nested-formula-book1-11-
Sheet: Sheet1

Sequence | Hours per day | Cumulative hours | Result
A | 190.7609504132232 | 190.7609504132232 |  | Staff | 100
B | 88.7633608815427 | 279.5243112947659
C | 85.32424242424243 | 364.8485537190083 |  | TOTAL HOURS
D | 80.58032467532468 | 445.428878394333
E | 78.18041958041957 | 523.6092979747525
F | 69.11005509641873 | 592.7193530711712
G | 60.85064029415494 | 653.5699933653261
H | 58.45733706932337 | 712.0273304346495
I | 43.09283746556473 | 755.1201679002141
J | 28.72897727272727 | 783.8491451729415
K | 29.275 | 813.1241451729414
L | 23.44808712121212 | 836.5722322941535
Spreadsheet: 161322d1339497047-conditional-formatting-not-automatically-changing-conditional-foramt
Sheet: Incoming

S.NO | CORRESPONDENCE NUMBER | RECEIVING DATE | DOCUMENTS TITLE / SUBJECT | REPLY. REQD. | DOC. TYPE | ACTION | Target Date | COMPANY REPLY NO | DATE OF REPLY | STATUS | REMARKS
1 | 12 | 2012-04-02 00:00:00 | A | Yes |  | PM | 2012-05-04 00:00:00
2 | 12 | 2012-04-16 00:00:00 | B | Yes |  | PM | 2012-04-19 00:00:00
3 | 12 | 2012-04-17 00:00:00 | B | No
4 | 12 | 2012-04-18 00:00:00 | B | Yes |  | PM
5 | 12 | 2012-04-19 00:00:00 | B | No |  |  |  |  |  | Closed
6 | 12 | 2012-04-22 00:00:00 | B | Yes |  | PM |  |  | 2012-05-21 00:00:00 | Closed
7 | 12 | 2012-04-24 00:00:00 | B | No |  |  |  |  |  | Closed
8 | 12 | 2012-04-25 00:00:00 | B | No |  | PM |  |  |  | Closed
9 | 12 | 2012-05-03 00:00:00 | B | Yes |  | PM | 2012-08-05 00:00:00
10 | 12 | 2012-05-06 00:00:00 | B | Yes |  | PM |  |  | 2012-05-20 00:00:00 | Closed
11 | 12 | 2012-05-08 00:00:00 | B | No |  |  |  |  |  | Closed
12 | 12 | 2012-05-08 00:00:00 | B | No
13 | 12 | 2012-05-08 00:00:00 | B | Yes |  | PM | 2012-05-13 00:00:00
14 | 12 | 2012-05-09 00:00:00 | B | No
15 | 12 | 2012-05-10 00:00:00 | B | No
 |  |  | Conditional Formatting | =AND($E4="Yes",$K4<>"Closed",$H4<TODAY(),$H4<>"")
Spreadsheet: sally_beck__33826__revenue2001
Sheet: Sheet1

 | CommodityLogic
 | 2001 Blue Sky Revenue Projections
 |  | Client |  | Monthly
 | Number | Type | Module | Subscription |  | Jan | Feb | Mar | Apr | May | June | July | Aug | Sep | Oct | Nov | Dec |  | Totals
 | 3 | Tier 1 | Contract Exchange (100 Pipes) | 70000
 |  |  | Confirm Central | 15000
 |  |  | Invoice Exchange | 15000
 |  |  | [NAME] (100 Pipes) | 25000
 |  |  | V@R | 10000
 |  |  | Credit Central | 10000
 |  |  | [NAME] | 5000
 | 20 | [NAME] | Contract Exchange (<20 Pipes) | 30000
 |  |  | Confirm Central | 15000
 |  |  | Invoice Exchange | 15000
 |  |  | [NAME] (<20 Pipes) | 15000
 |  |  | V@R | 10000
 |  |  | Credit Central | 10000
 |  |  | [NAME] | 5000
 | 20 | Tier 3 | Contract Exchange (<10 Pipes) | 15000
 |  |  | Confirm Central | 7500
 |  |  | Invoice Exchange | 7500
 |  |  | [NAME] (<10 Pipes) | 7500
 |  |  | V@R | 5000
 |  |  | Credit Central | 5000
 |  |  | [NAME] | 2500
 |  | All | Financial Management Module |  |  | 10000
Spreadsheet: 121943d1316520324-if-function-multiple-criteria-copy-of-trackernthat-1-
Sheet: Sheet1

RANGE | CE | PIC | Cost Sheet?
ADULT BEDDING | [NAME] | [NAME] | 2011-09-02 00:00:00
ARTS & CRAFTS | Sophy | Jemima | 2011-09-03 00:00:00
AUDIO | [NAME] | [NAME] | 2011-09-04 00:00:00
AUDIO ACCESSORIES | [NAME] | [NAME] | 2011-09-05 00:00:00
BATHROOM | Nikki | George | 2011-09-06 00:00:00
BATHROOM TEXTILES | Nikki | George | 2011-09-07 00:00:00
CAR ACCESSORIES | [NAME] | Zaberia | 2011-09-11 00:00:00
CLOCKS | Sarah/ [NAME] | Julie | 2011-09-12 00:00:00
COMPUTERS | [NAME] | [NAME] | 2011-09-13 00:00:00
CURTAINS/BLINDS/RUGS | [NAME] | George | 2011-09-14 00:00:00
CYCLES & ACCESSORIES | [NAME] | Julie | 2011-09-15 00:00:00
DIY | [NAME] | Zaberia
ELECTRIC BLANKETS | [NAME] | [NAME]
ELECTRICAL ACCESSORIES | [NAME] | Julie
FISHING | Sophy | [NAME]
FITTED KITCHEN | Nikki | Jemima | 2011-09-19 00:00:00
GARDEN POWER | [NAME] | [NAME] | 2011-09-20 00:00:00
GENTS GIFTS | [NAME] | Becky | 2011-09-21 00:00:00
GIRLS TOYS | Sian | [NAME] | 2011-09-22 00:00:00
HEATING & COOLING | Sophy | [NAME]
HOME FURNISHINGS | [NAME] | George
INFANT TOYS | Sian | [NAME] | 2011-09-16 00:00:00
IRONS | Nikki | Jemima
KITCHEN EQUIPMENT | Nikki | Zaberia
LADIES GIFTS | [NAME] | Becky
LAUNDRY | Eileen | Jemima
LIGHTING | Sarah/ [NAME] | George | 2011-09-17 00:00:00
LIVING AIDS | [NAME] | Jemima | 2011-09-18 00:00:00
LOUNGE | Eileen | [NAME]
LUGGAGE | Sian | Zaberia
MICROWAVES | Nikki | Zaberia
MOBILES | [NAME] | [NAME]
MUSICAL INSTRUMENTS | Sophy | [NAME]
NURSERY | [NAME] | Julie
OFFICE EQUIPMENT | [NAME] | [NAME]
OFFICE FURNITURE | Eileen | [NAME]
OFFICE SUPPLIES | [NAME] | [NAME]
OPTICAL | Sue | [NAME]
OUTDOOR TOYS | Sian | [NAME]
PERSONAL CARE | [NAME] | [NAME]
PETCARE | Sarah/ [NAME] | George
PHOTO ACCESSORIES | Sue | [NAME] | 2011-09-23 00:00:00
RADIO | [NAME] | [NAME] | 2011-09-24 00:00:00
SAT NAV | Sian | Julie | 2011-09-25 00:00:00
SDA | Nikki | Zaberia | 2011-09-26 00:00:00
SEWING | [NAME] | Jemima | 2011-09-27 00:00:00
SPORTS | [NAME] | Becky | 2011-09-28 00:00:00
STORAGE | Sian | Becky
TELEPHONES | Sarah/ [NAME] | [NAME]
TV | [NAME] | [NAME]
TV ACCESSORIES | [NAME] | [NAME]
UPHOLSTERY | Eileen | Becky
VGS | [NAME] | [NAME]
WATCHES | Sarah/ [NAME] | Julie
WHITE GOODS - COOKING | Sophy | Jemima
WHITE GOODS - REFRIGERATION | Sophy | Jemima
WHITE GOODS - WASHING | Sophy | Jemima
Spreadsheet: 775124d1648826807-if-function-using-and-with-dates-example-12-
Sheet: Sheet1

Entry | Exit |  | IF1 -  Entry >= 1/1/22 | IF2 - Entry <= 31/1/22 | AND (IF1,IF2) |  | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00
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: 412461d1439010853-calculate-difot-on-time-and-late-copy-of-difot-sample-calculations
Sheet: Sheet1

POQtyOrder | Required_Ship_Date | PO_Ship_Date | [NAME] 1 | PO_Ship_Date | [NAME] 2 | PO_Ship_Date | [NAME] 3 | Qty Not Shipped | Past Due Days Ship 1 | Past Due Days Ship 2 | Past Due Days Ship 3 | OT % Score Ship 1 | OT/Late 1 | OT % Score Ship 2 | OT/Late 2 | OT % Score Ship 3 | OT/Late 3 | Total qty Ship O/time | % line shipped on time | Total Qty Shipped Late | %line Not Shipped On time
800 | 2015-07-15 00:00:00 | 2015-07-20 00:00:00 | 680 | 2015-07-28 00:00:00 | 118 | 2015-08-04 00:00:00 | 2
800 | 2015-07-15 00:00:00 | 2015-07-20 00:00:00 | 228 | 2015-08-04 00:00:00 | 572
600 | 2015-07-15 00:00:00 | 2015-07-20 00:00:00 | 600
Based on Column M referencing Column J, Column O seems like it should reference values in Column K and Column Q should reference [NAME]
It seems that a more reliable formula for Column S would check whether Columns N,P and R are "OT" or not, as the cells in these column are already designed to check whether the percentage is zero or greater than zero.
Spreadsheet: 806764d1669560231-referencing-other-values-in-a-cell-roster-creation-cheat-sheet
Sheet: Sheet1

 | Hit-By-Pitch (HBP)
 | LIFEtime |  |  |  | Single-Season
 | (162 Gm. Avg.) |  |  |  |  |  |  | LIFETIME | 0.0074 | 0.0075 | 3.7 | 18.7 | 14.9 | 11.2 | 7.5 | 3.7 | 1.9 | 1.2 | 0.9 | 0.7
 | METHOD A |  |  |  | METHOD B |  |  | Year | Per AB | Pct per AB | 502 AB% | A | B | C | D | E | F | G | H | I
 | HBP | Rating |  | AB | HBP | 502 AB | Rating |  |  |  |  | "A" 5x | "B" 4x | "C" 3x | "D" 2x | "E" Avg. | "F" 1/2 avg. | "G" 1/3 avg. | "H" 1/4 avg. | "I" 1/5 avg.
 |  |  |  | 10876 | 285
 | Stolen Bases (SB)
 | LIFETime |  |  |  | Single-Season
 | Gam / Gam-P
 | Single-Season |  |  |  |  |  |  | LIFEtime
 | Tot. Games | Position (1-10) | Def. Gms. | Games@Pos. | Eligibility % |  |  | Gam |  |  | Gam-P
 | 77 | 7 | 64 | 7
 |  | Gam | Gam-P
 |  | [NAME]
 |  | Calculated Value
Spreadsheet: 773460d1647873350-vlookup-to-identify-gaps-in-dates-vlookup-problem
Sheet: Sheet1

Date and Time | Measurement |  |  | Date and Time | Measurement
2021-06-01 00:00:00 |  |  |  | 2021-06-01 00:00:00 | 116.1225967407227
2021-06-01 00:15:00 |  |  |  | 2021-06-01 00:15:00 | 66.80229187011719
2021-06-01 00:30:00 |  |  |  | 2021-06-01 00:30:00 | 81.7037124633789
2021-06-01 00:45:00 |  |  |  | 2021-06-01 00:45:00 | 85.09716796875
2021-06-01 01:00:00 |  |  |  | 2021-06-01 01:00:00 | 53.05245971679688
2021-06-01 01:15:00 |  |  |  | 2021-06-01 01:15:00 | 53.18647003173828
2021-06-01 01:30:00 |  |  |  | 2021-06-01 01:45:00 | 38.35390853881836
2021-06-01 01:45:00 |  |  |  | 2021-06-01 02:00:00 | 47.08364868164062
2021-06-01 02:00:00 |  |  |  | 2021-06-01 02:15:00 | 74.0843734741211
2021-06-01 02:15:00 |  |  |  | 2021-06-01 02:30:00 | 42.93661880493164
2021-06-01 02:30:00 |  |  |  | 2021-06-01 02:45:00 | 42.17866897583008
2021-06-01 02:45:00 |  |  |  | 2021-06-01 03:00:00 | 32.79460144042969
2021-06-01 03:00:00 |  |  |  | 2021-06-01 03:15:00 | 80.50261688232422
2021-06-01 03:15:00 |  |  |  | 2021-06-01 03:30:00 | 40.25936889648438
2021-06-01 03:30:00 |  |  |  | 2021-06-01 03:45:00 | 35.24710845947266
2021-06-01 03:45:00 |  |  |  | 2021-06-01 04:15:00 | 31.71821975708008
2021-06-01 04:00:00 |  |  |  | 2021-06-01 04:30:00 | 84.84075164794922
2021-06-01 04:15:00 |  |  |  | 2021-06-01 04:45:00 | 34.07133102416992
2021-06-01 04:30:00 |  |  |  | 2021-06-01 05:00:00 | 28.36838912963867
2021-06-01 04:45:00 |  |  |  | 2021-06-01 05:15:00 | 30.52338027954102
2021-06-01 05:00:00 |  |  |  | 2021-06-01 05:30:00 | 55.47647094726562
2021-06-01 05:15:00 |  |  |  | 2021-06-01 05:45:00 | 66.97250366210938
2021-06-01 05:30:00 |  |  |  | 2021-06-01 06:00:00 | 28.86564064025879
2021-06-01 05:45:00 |  |  |  | 2021-06-01 06:15:00 | 44.5170783996582
2021-06-01 06:00:00 |  |  |  | 2021-06-01 06:30:00 | 38.05426025390625
2021-06-01 06:15:00 |  |  |  | 2021-06-01 06:45:00 | 76.50193786621094
2021-06-01 06:30:00 |  |  |  | 2021-06-01 07:00:00 | 41.04663848876953
2021-06-01 06:45:00
2021-06-01 07:00:00
Spreadsheet: 74067d1274686992-charting-every-second-data-point-730360
Sheet: Sheet1

 | Yield1 | Yield2 | Rent1 | Rent2 |  | Rent1 | Rent2
2005-03-01 00:00:00 | 0.085 | 0.075 | 115 | 125 | 2005-06-01 00:00:00 | 115 | 125
2005-06-01 00:00:00 | 0.085 | 0.075 | 115 | 125 | 2005-12-01 00:00:00 | 115 | 125
2005-09-01 00:00:00 | 0.0825 | 0.075 | 115 | 125 | 2006-06-01 00:00:00 | 120 | 130
2005-12-01 00:00:00 | 0.08375 | 0.075 | 115 | 125 | 2006-12-01 00:00:00 | 120 | 130
2006-03-01 00:00:00 | 0.08 | 0.0775 | 115 | 125 | 2007-06-01 00:00:00 | 120 | 130
2006-06-01 00:00:00 | 0.08 | 0.0775 | 120 | 130 | 2007-12-01 00:00:00 | 120 | 130
2006-09-01 00:00:00 | 0.0775 | 0.075 | 120 | 130 | 2008-06-01 00:00:00 | 130 | 140
2006-12-01 00:00:00 | 0.0775 | 0.0725 | 120 | 130 | 2008-12-01 00:00:00 | 130 | 140
2007-03-01 00:00:00 | 0.075 | 0.08 | 120 | 130 | 2009-06-01 00:00:00 | 125 | 135
2007-06-01 00:00:00 | 0.0725 | 0.08 | 120 | 130 | 2009-12-01 00:00:00 | 125 | 135
2007-09-01 00:00:00 | 0.07 | 0.07 | 120 | 130
2007-12-01 00:00:00 | 0.065 | 0.0725 | 120 | 130
2008-03-01 00:00:00 | 0.07 | 0.075 | 120 | 130
2008-06-01 00:00:00 | 0.0788 | 0.08 | 130 | 140
2008-09-01 00:00:00 | 0.0788 | 0.0825 | 130 | 140
2008-12-01 00:00:00 | 0.0838 | 0.085 | 130 | 140
2009-03-01 00:00:00 | 0.0875 | 0.0875 | 125 | 135
2009-06-01 00:00:00 | 0.09 | 0.0875 | 125 | 135
2009-09-01 00:00:00 | 0.09 | 0.09 | 125 | 135
2009-12-01 00:00:00 | 0.0888 | 0.09 | 125 | 135
Mar-10 | 0.0888 | 0.09 | 125 | 135
Spreadsheet: 136616d1326743421-pull-data-if-columns-equal-a-range-test
Sheet: Sheet1

Item Id | Description | Qty | ITN | [NAME] | Date In | Days Old | PS Location | PO Number
Test123 | Test Equipment | 2 | 12345 | code 1 | Jan 12 2009 | 300 | 11111 | NVIR1111
Test123 | Test Equipment | 1 | 12345 | code 1 | Jan 12 2009 | 20 | 11111 | NVIR1111
Test123 | Test Equipment | 4 | 12345 | code 1 | Jan 12 2009 | 210 | 11111 | NVIR1111
Test123 | Test Equipment | 2 | 12345 | code 1 | Jan 12 2009 | 300 | 11111 | NVIR1111
Test123 | Test Equipment | 15 | 12345 | code 1 | Jan 12 2009 | 45 | 11111 | NVIR1111
Spreadsheet: 850972d1701264269-cf-on-date-fields-dbs-report
Sheet: Report

DBS Ref. Issued | Disclaimer 1 | Date completed | Disclaimer 2 | Date completed | DBS Renewal Date
2019-03-25 00:00:00 |  |  |  |  | 2022-03-25 00:00:00
2022-06-28 00:00:00 |  | 2023-11-15 00:00:00 |  |  | 2025-06-28 00:00:00
2023-10-20 00:00:00 |  |  |  |  | 2026-10-20 00:00:00
2022-08-31 00:00:00 |  | 2023-10-30 00:00:00 |  |  | 2025-08-31 00:00:00
2022-08-21 00:00:00 |  | 2023-11-01 00:00:00 |  |  | 2025-08-21 00:00:00
2021-10-17 00:00:00 |  | 2023-10-30 00:00:00 |  | 2023-10-30 00:00:00 | 2024-10-17 00:00:00
2023-01-30 00:00:00 |  |  |  |  | 2026-01-30 00:00:00
2021-07-27 00:00:00 |  |  |  |  | 2024-07-27 00:00:00
2022-02-24 00:00:00 |  | 2023-11-01 00:00:00 |  |  | 2025-02-24 00:00:00
2019-03-20 00:00:00 |  |  |  |  | 2022-03-20 00:00:00
2022-03-01 00:00:00 |  | 2023-11-18 00:00:00 |  |  | 2025-03-01 00:00:00
2023-10-23 00:00:00 |  |  |  |  | 2026-10-23 00:00:00
2020-11-18 00:00:00 |  |  |  |  | 2023-11-18 00:00:00
2022-02-17 00:00:00 |  | 2023-11-01 00:00:00 |  |  | 2025-02-17 00:00:00
2022-04-05 00:00:00 |  | 2023-11-17 00:00:00 |  |  | 2025-04-05 00:00:00
2022-05-25 00:00:00 |  |  |  |  | 2025-05-25 00:00:00
2022-01-20 00:00:00 |  | 2023-11-09 00:00:00 |  |  | 2025-01-20 00:00:00
2022-04-06 00:00:00 |  | 2023-11-09 00:00:00 |  |  | 2025-04-06 00:00:00
2023-02-09 00:00:00 |  |  |  |  | 2026-02-09 00:00:00
2022-02-14 00:00:00 |  | 2023-11-01 00:00:00 |  |  | 2025-02-14 00:00:00
2022-03-12 00:00:00 |  | 2023-10-31 00:00:00 |  |  | 2025-03-12 00:00:00
2022-02-14 00:00:00 |  | 2023-10-13 00:00:00 |  |  | 2025-02-14 00:00:00
2022-01-20 00:00:00 |  |  |  |  | 2025-01-20 00:00:00
2022-01-20 00:00:00 |  | 2023-10-31 00:00:00 |  |  | 2025-01-20 00:00:00
2023-10-10 00:00:00 |  |  |  |  | 2026-10-10 00:00:00
2023-02-27 00:00:00 |  |  |  |  | 2026-02-27 00:00:00
2023-10-25 00:00:00 |  |  |  |  | 2026-10-25 00:00:00
2022-12-07 00:00:00 |  | 2023-10-31 00:00:00 |  |  | 2025-12-07 00:00:00
2022-07-06 00:00:00 |  | 2023-10-30 00:00:00 |  |  | 2025-07-06 00:00:00
2020-07-30 00:00:00 |  |  |  |  | 2023-07-30 00:00:00
2014-04-01 00:00:00 |  |  |  |  | 2017-04-01 00:00:00