tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 877916d1724851734-index-and-match-function-not-working-help-aop-per-tech
Sheet: Dec

TECH | HOURS | AVG-PER DAY | OBJ RATE | % OF TOTAL HOURS | OBJECTIVE |  |  | Column1 | Column2
[NAME], |  |  |  |  |  |  |  | AOP $
[NAME], |  |  |  |  |  |  |  | ELR
[NAME], |  |  |  |  |  |  |  | AOP HOURS
DIEGO MERCADO, |  |  |  |  |  |  |  | WORKING DAYS
[NAME],
TYLER BIXLER, |  |  |  |  |  |  |  | TOTAL HOURS
MASON SHAWN,
TRAVIS GREGORY,
THOAI LE,
SHANE GILLESPIE,
GIANCARLO PACHECO,
[NAME],
CHASE FRY,
ANZOR KHATAEV,
[NAME],
[NAME],
FLORES GUARDADO,
[NAME],
[NAME],
COELLO VALLEJO,
TYLER MUNGER,
[NAME],
[NAME],
SIMON NELSON,
[NAME],
GUARDADO RODAS,
SHAWN GROOVER,
RYAN GUAGENTI,
[NAME],
[NAME],
[NAME],
[NAME],
DONOVAN OCONNOR,
WYLIE ROWE,
BRADLEY OLIVA,
[NAME],
GILBERTO GALENOCAMPOS,
SUBLET TECH,
BRANDON HAASE,
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: DX07 JJK

 |  |  |  |  | DX07 JJK
Registration number : | DX07 JJK |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  | 2007-06-25 00:00:00 | 12 Months + 1 Week | 2008-07-01 00:00:00 | £1224 + £50 (1st Reg)
Specification : | 6 x 2 A (3 Axle) |  | 2008-06-30 00:00:00 | 12 Months | 2009-07-01 00:00:00 | 1200
Type : | FTG XF 105.460 |  | 2009-06-30 00:00:00 | 12 Months | 2010-07-01 00:00:00 | 1200
1st Registered : | 24.06.07 |  | 2010-06-30 00:00:00 | 12 Months | 2011-07-01 00:00:00 | 1200
Engine : | MX 340 S212.9 litre |  | 2011-07-01 00:00:00 | 12 Months | 2012-07-01 00:00:00 | 1200
[NAME] : | 44,000kg
Back To Index
Spreadsheet: 08988d59-6d1c-4509-a46d-ecfb332480bf
Sheet: Sheet1

Spend over £25,000 - Publication template | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Payment
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | SMG | 2012-07-12 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 160036 | 28974.85
DCMS | SMG | 2012-07-12 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 160040 | 28974.85
DCMS | SMG | 2012-07-12 00:00:00 | Security | Security | [NAME] | 160058 | 32771
DCMS | SMG | 2012-07-12 00:00:00 | Security | Security | [NAME] | 160060 | 32309.75
DCMS | SMG | 2012-07-12 00:00:00 | Print Production | ScM Major projects | Go Agency Ltd | 160102 | 27802
DCMS | SMG | 2012-07-26 00:00:00 | Events | NMeM Brand | Bradford Council | 160163 | 55000
DCMS | SMG | 2012-07-26 00:00:00 | Maintenance | NRM Estates | Honeywell Controls Ltd | 160286 | 89942
DCMS | SMG | 2012-07-26 00:00:00 | Maintenance | NMEM Estates | Honeywell Controls Ltd | 160288 | 82858
DCMS | SMG | 2012-07-12 00:00:00 | Security | Security | [NAME] | 160343 | 151355.16
DCMS | SMG | 2012-07-26 00:00:00 | Build Construction | National MPG | [NAME] | 160381 | 64477.47
DCMS | SMG | 2012-07-12 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 160574 | 47665.3
DCMS | SMG | 2012-07-12 00:00:00 | Build Construction | National MPG | Link 51(Storage Products) | 160645 | 27697
DCMS | SMG | 2012-07-26 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 160867 | 28974.85
DCMS | SMG | 2012-07-26 00:00:00 | Security | Security | [NAME] | 160884 | 32771
DCMS | SMG | 2012-07-26 00:00:00 | Security | Security | [NAME] | 160889 | 32309.75
DCMS | SMG | 2012-07-24 00:00:00 | Plant & Machinery Maintenance | Retail | IMAX Corporation | 114881 | 41855.26
Spreadsheet: 830868d1685188396-combining-order-data-from-multiple-rows-into-single-row-multiplerows
Sheet: Sheet1

Current |  |  | Desired
Order | Item |  | Order | Item
ABC124 | milk
ABC124 | bread
ABC125 | cheese
ABC125 | meat
ABC125 | crackers
ABC125 | juice
ABC125 | cookies
ABC125 | bread
ABC125 | candy
ABC125 | pizza
ABC125 | milk
ABC126 | donuts
ABC127 | apples
ABC127 | oranges
Spreadsheet: 707684d1607422309-excel-2016-vlookup-issue-with-dropdown-raid-log
Sheet: Matrix

type | description | value |  | probability | impact | [NAME] |  | prob \ imp | insignificant | minor | moderate | major | severe
propability | almost certain | 5 |  | likely | minor |  |  | almost certain
propability | likely | 4 |  |  |  |  |  | likely
propability | possible | 3 |  |  |  |  |  | possible
propability | unlikely | 2 |  |  |  |  |  | unlikely
propability | rare | 1 |  |  |  |  |  | rare
impact | insignificant | 1
impact | minor | 2
impact | moderate | 3
impact | major | 4
impact | severe | 5
Probability |  |  |  |  |  |  | Impact
Descriptor | Level | Definition |  |  |  |  | Descriptor | Level | Definition
Rare | 1 | May occur somewhere, sometime (“once in a life time / once in a hundred years”) |  |  |  |  | Insignificant | 1 | Negligable impact
Unlikely | 2 | May occur over an extended period of time |  |  |  |  | Minor | 2 | Minor impact requiring minor adjustment to schedule, budget or scope
Possible | 3 | May occur several times over a period of time |  |  |  |  | Moderate | 3 | Will result in slight delay (1-2 Weeks) or moderate increase to budget. Will require escalation to CTO
Likely | 4 | May be anticipated multiple times over a period of time.  May occur once every few repetitions of the activity or event |  |  |  |  | Major | 4 | Wil result in Target milestone (scope, budget, timeline) being missed.  Will require escalation to project board
Almost Certain | 5 | Prone to occur regularly.  It is anticipated for each repetition of the activity of event |  |  |  |  | Severe | 5 | Will have major impact on project delivery. Project work likley to stop and will require immediate attention of project board
Probability | Impact
 | Insignificant | Minor | Moderate | Major | Severe |  | Descriptor | Definition
Almost Certain | 5 | 10 | 15 | 20 | 25 |  | Extreme | Notify Project Board immediately.   Corrective actions should be taken immediately. Cease associated activity.
Likely | 4 | 8 | 12 | 16 | 20 |  | High | Notify  Project Board immediately.  Corrective actions should be taken within 48 hours of notification.
Possible | 3 | 6 | 9 | 12 | 15 |  | Medium | Notify CTO  corrective action is taken within 7 days.
Unlikely | 2 | 4 | 6 | 8 | 10 |  | Low | Notify Project Manager.   Corrective action is taken within a reasonable time.
Rare | 1 | 2 | 3 | 4 | 5
Spreadsheet: 71433d1272147703-change-data-in-a-field-split
Sheet: Sheet1

 |  |  | 594202 - Book Dealers-Retail |  |  | =LEFT(D1,6) |  | =LEFT(D1,SEARCH("-",D1,1)-1)
 |  |  | 594201 - Book Dealers-Retail
 |  |  | 594202 - Book Dealers-Retail
 |  |  | 594201 - Book Dealers-Retail
 |  |  | 59420600 - Book Dealers-Retail
 |  |  | 594201 - Book Dealers-Retail
 |  |  | 594202 - Book Dealers-Retail
 |  |  | 594201 - Book Dealers-Retail
 |  |  | 594202 - Book Dealers-Retail
 |  |  | 594201 - Book Dealers-Retail
 |  |  | text10 - Book Dealers-Retail
 |  |  | 594201 - Book Dealers-Retail
 |  |  | 594202 - Book Dealers-Retail
 |  |  | text and nbr 594201 - Book Dealers-Retail
 |  |  | 594202 - Book Dealers-Retail
Spreadsheet: 842701d1694704283-counting-dates-before-a-specific-date-and-event-sample-data
Sheet: Sheet1

Emails sent |  |  |  | Items purchased
Person ID | SENT DATE |  |  | Person ID | Date purcased | Number of emails received before this purchase date
123 | 2022-08-09 00:00:00 |  |  | 123 | 2022-02-15 00:00:00 | 0 | No email were sent before this purchase date
123 | 2023-05-02 00:00:00 |  |  | 123 | 2023-01-31 00:00:00 | 0 | After the email which was sent on 09/08/2022, no further emails were sent before this purchase date
123 | 2023-06-22 00:00:00 |  |  | 123 | 2023-01-21 00:00:00 | 1 | The email sent on 09/08/2022 was sent before this purchase date
Spreadsheet: 89089d1288862381-networkdays-formula-example
Sheet: Triage Data

[NAME] | OrderTaken | DelDate |  | [NAME] | Revised End | Network Days |  | NewCalc
74388 | 2010-10-20 00:00:00 | 2010-10-20 00:00:00 |  | 2010-10-20 00:00:00 | 2010-10-20 00:00:00 | 0 |  | 0
71508 | 2010-10-06 00:00:00 | 2010-10-07 00:00:00 |  | 2010-10-06 00:00:00 | 2010-10-07 00:00:00 | 1 |  | 0
71835 | 2010-10-07 00:00:00 | 2010-10-07 00:00:00 |  | 2010-10-07 00:00:00 | 2010-10-07 00:00:00 | 0 |  | 0
71402 | 2010-10-07 00:00:00 | 2010-10-08 00:00:00 |  | 2010-10-07 00:00:00 | 2010-10-08 00:00:00 | 1 |  | 0
71905 | 2010-10-07 00:00:00 | 2010-10-08 00:00:00 |  | 2010-10-07 00:00:00 | 2010-10-08 00:00:00 | 1 |  | 0
72217 | 2010-10-08 00:00:00 | 2010-10-08 00:00:00 |  | 2010-10-08 00:00:00 | 2010-10-08 00:00:00 | 0 |  | 0
71016 | 2010-10-02 00:00:00 | 2010-10-04 00:00:00 |  | 2010-10-04 00:00:00 | 2010-10-04 00:00:00 | 0 |  | 2
72965 | 2010-10-14 00:00:00 | 2010-10-16 00:00:00 |  | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 | 1 |  | -3
71579 | 2010-10-06 00:00:00 | 2010-10-07 00:00:00 |  | 2010-10-06 00:00:00 | 2010-10-07 00:00:00 | 1 |  | 0
70852 | 2010-10-04 00:00:00 | 2010-10-05 00:00:00 |  | 2010-10-04 00:00:00 | 2010-10-05 00:00:00 | 1 |  | 0
71260 | 2010-10-05 00:00:00 | 2010-10-07 00:00:00 |  | 2010-10-05 00:00:00 | 2010-10-07 00:00:00 | 2 |  | 0
72227 | 2010-10-08 00:00:00 | 2010-10-18 00:00:00 |  | 2010-10-08 00:00:00 | 2010-10-18 00:00:00 | 6 |  | 0
72135 | 2010-10-08 00:00:00 | 2010-10-18 00:00:00 |  | 2010-10-08 00:00:00 | 2010-10-18 00:00:00 | 6 |  | 0
68560 | 2010-09-21 00:00:00 | 2010-10-08 00:00:00 |  | 2010-09-21 00:00:00 | 2010-10-08 00:00:00 | 13 |  | 0
70289 | 2010-10-01 00:00:00 | 2010-10-05 00:00:00 |  | 2010-10-01 00:00:00 | 2010-10-05 00:00:00 | 2 |  | 0
70553 | 2010-10-01 00:00:00 | 2010-10-02 00:00:00 |  | 2010-10-01 00:00:00 | 2010-10-01 00:00:00 | 0 |  | -3
69945 | 2010-10-01 00:00:00 | 2010-10-05 00:00:00 |  | 2010-10-01 00:00:00 | 2010-10-05 00:00:00 | 2 |  | 0
72421 | 2010-10-14 00:00:00 | 2010-10-17 00:00:00 |  | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 | 1 |  | -3
72885 | 2010-10-14 00:00:00 | 2010-10-17 00:00:00 |  | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 | 1 |  | -3
72635 | 2010-10-14 00:00:00 | 2010-10-17 00:00:00 |  | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 | 1 |  | -3
72767 | 2010-10-14 00:00:00 | 2010-10-17 00:00:00 |  | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 | 1 |  | -3
73433 | 2010-10-15 00:00:00 | 2010-10-17 00:00:00 |  | 2010-10-15 00:00:00 | 2010-10-15 00:00:00 | 0 |  | -3
73451 | 2010-10-16 00:00:00 | 2010-10-17 00:00:00 |  | 2010-10-18 00:00:00 | 2010-10-15 00:00:00 | -1 |  | -1
73149 | 2010-10-14 00:00:00 | 2010-10-17 00:00:00 |  | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 | 1 |  | -3
71317 | 2010-10-05 00:00:00 | 2010-10-06 00:00:00 |  | 2010-10-05 00:00:00 | 2010-10-06 00:00:00 | 1 |  | 0
74047 | 2010-10-21 00:00:00 | 2010-10-21 00:00:00 |  | 2010-10-21 00:00:00 | 2010-10-21 00:00:00 | 0 |  | 0
Spreadsheet: 861f2677-1b16-4873-a1cb-10d035402b40
Sheet: Sheet1

Release: State Leading Indexes | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=208
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-10-01 5:16 AM [NAME]
 | Real-Time | Period
Name: | Start | End
State Leading Indexes | 2011-02-01 00:00:00 | Current
Link:
http://www.philadelphiafed.org/research-and-data/regional-economy/indexes/leading/ | 2011-02-01 00:00:00 | Current
Source:
Federal Reserve Bank of Philadelphia | 2011-02-01 00:00:00 | Current
Notes:
The leading index for each state predicts the six-month growth rate of | 2011-02-01 00:00:00 | Current
the models include other variables that lead the economy: state-level
housing permits (1 to 4 units), state initial unemployment insurance
claims, delivery times from the Institute for Supply Management (ISM)
manufacturing survey, and the interest rate spread between the 10-year
Treasury bond and the 3-month Treasury bill.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-02-01 00:00:00
2011-03-22 00:00:00
2011-03-31 00:00:00
2011-04-28 00:00:00
2011-05-31 00:00:00
2011-06-28 00:00:00
2011-08-02 00:00:00
2011-08-30 00:00:00
2011-09-29 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2011-12-29 00:00:00
2012-02-02 00:00:00
2012-03-20 00:00:00
2012-04-03 00:00:00
2012-04-27 00:00:00
2012-05-29 00:00:00
2012-06-28 00:00:00
2012-07-31 00:00:00
2012-08-28 00:00:00
2012-10-02 00:00:00
2012-10-30 00:00:00
2012-12-04 00:00:00
2013-01-03 00:00:00
2013-01-31 00:00:00
2013-03-26 00:00:00
2013-04-04 00:00:00
2013-04-30 00:00:00
2013-05-28 00:00:00
2013-07-02 00:00:00
2013-07-30 00:00:00
2013-08-29 00:00:00
2013-10-01 00:00:00
2013-12-04 00:00:00
2014-01-02 00:00:00
2014-02-04 00:00:00
2014-03-24 00:00:00
2014-04-03 00:00:00
2014-04-28 00:00:00
2014-05-29 00:00:00
2014-06-27 00:00:00
2014-07-29 00:00:00
2014-08-29 00:00:00
2014-09-29 00:00:00
Spreadsheet: 39273d1237451382-transpose-2nd-column-based-on-repeats-in-1st-column-transpose-cities
Sheet: Cities transformed

State | Cities | State
Mississippi | [NAME] | Mississippi | 2 | 3 | 1 | [NAME]
Florida | Orlando | Florida | 3 | 8 | 5 | Orlando | Tampa | Jacksonville | Pensacola | Miami
Florida | Tampa | Georgia | 8 | 9 | 1 | Atlanta
Florida | Jacksonville | Louisiana | 9 | 11 | 2 | New Orleans | Baton Rouge
Florida | Pensacola | Alabama | 11 | 14 | 3 | Birmingham | Mobile | Montgomery
Florida | Miami
Georgia | Atlanta
Louisiana | New Orleans
Louisiana | Baton Rouge
Alabama | Birmingham
Alabama | Mobile
Alabama | Montgomery
 |  |  | To analyse as required:
 |  |  | Prepare list of unique cities in Column C (eg use Data, Filter, Advanced)
 |  |  | Enter formula in col D and E and copy down
 |  |  | Replace last cell in column E with formula as shown
 |  |  | Enter formula in F and copy down. Use this to find the [NAME] cols required in next step (eg as in F6)
 |  |  | Enter formula in F1, copy right to the maximum needed
 |  |  | Copy this range down as required.
 |  |  | In this example columns G:I represent the result and could be copied and pasted as values to another worksheet,
 |  |  | then saved as a csv file
Spreadsheet: 784437d1655734947-googlesheets-pulling-data-from-a-set-of-dynamic-data-sample
Sheet: ABITEX

Company Name: | Abitex | Start Date: | 2020-06-03 00:00:00 |  | Website Launch: | 2020-05-01 00:00:00
Website URL: | https://abitex.com.my/ | End Date: | 2021-06-03 00:00:00
Location: | Malaysia | Language: | English
Budget: | 13 | Promised Traffic: | 4,000/year
(MYR20/day - state if otherwise)
 |  |  |  | Back to Summary Sheet |  | No. of Enquiries
Month | No of. Traffic Delivered                   (month) | Remaining Traffic | No. of Google Ads Click | Ad Spent                   (month) | Total Enquiries | Phone Call | WhatsApp | [NAME] | Live Chat | Contact Form | Product Form | Click Tracking
2021-06-01 00:00:00 | 1168 | 2832 | 569 | 370 | 42 |  | 42
2020-07-01 00:00:00 | 1400 | 1432 | 612 | 391 | 30 |  | 24 |  |  | 2 | 4
2020-08-01 00:00:00 | 1317 | 115 | 565 | 354 |  |  | 44 |  |  | 14 | 8 | 10
2020-09-01 00:00:00 | 1470 |  | 564 | 373 |  |  | 49 |  |  | 8 | 7
2020-10-01 00:00:00 | 1627 |  | 542 | 367
2020-11-01 00:00:00 | 2238 |  | 657 | 365
2020-12-01 00:00:00 | 1871 |  | 550 | 388
2021-01-01 00:00:00 | 1794 |  | 700 | 393
2021-02-01 00:00:00 | 1600 |  | 604 | 395
2021-03-01 00:00:00 | 1900 |  | 554 | 395 |  | 1 | 43 | 12 | 5 | 3 | 36
2021-04-01 00:00:00 | 1900 |  | 540 | 393 |  |  | 42 | 4 | 20 |  | 17
2021-05-01 00:00:00 | 1800 |  | 619 | 366 |  |  | 4 | 1 | 7 |  | 4
2021-06-01 00:00:00
TOTAL |  | >4K
Spreadsheet: 4a766bf3-8937-44be-b716-c9385a11fb08
Sheet: DIG

Grant: |  | Title 1A District Improvement |  |  |  |  |  |  |  | Title 1A District Improvement
CFDA # |  | 84.010 |  |  |  |  |  |  |  | FY2012-13
GRANT NUMBER: |  | 5010
FISCAL YEAR: |  | 2012-13
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | [NAME]6389 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - November 13, 2013
Code | District Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | NOVEMBER 2012 | DECEMBER 2012 | JANUARY 2013 | FEBRUARY 2013 | MARCH 2013 | APRIL 2013 | MAY 2013 | JUNE 2013 | JULY 2013 | AUGUST 2013 | SEPTEMBER 2013 | OCTOBER 2013 | NOVEMBER 2013
0290-41 | [NAME] | 98930 |  |  |  |  |  |  |  |  |  |  | 41213 |  | 57717
0480-41 | Boulder Valley RE-2 | 100000 |  |  | 70598 |  | 12294 | 4074 | 13034
0770-41 | Crowley County School District RE1J | 99938 |  |  |  |  | 32823 |  |  | 5582 |  |  | 57679
1750-41 | Branson School District RE-82 | 32465 |  |  | 3065 | 5171
Spreadsheet: 65548d1266273456-find-a-value-across-multiple-sheets-in-another-workbook-sales-orders_2010
Sheet: SalesMar

Expected Sales Proceeds For JANUARY 2010
 |  |  |  |  |  |  | FX | 0.9135
 | INVOICE | INVOICE DATE | CUSTOMER | PRODUCT | Quantity | PRICE        USD / MT | AMOUNT (USD) | AMOUNT (AUD)
EXPORT
 | 100306 | 2010-03-12 00:00:00 | Customer1 | Product112 | 1000 | 2 | 2000 | 2189.381499726328
 | 100307 | 2010-03-13 00:00:00 | Customer2 | Product116 | 2000 | 2 | 4000 | 4378.762999452655
 | 100308 | 2010-03-14 00:00:00 | Customer3 | Product120 | 3000 | 2 | 6000 | 6568.144499178982
 | 100309 | 2010-03-15 00:00:00 | Customer4 | Product124 | 4000 | 2 | 8000 | 8757.52599890531
 | 100310 | 2010-03-16 00:00:00 | Customer5 | Product128 | 5000 | 2 | 10000 | 10946.90749863164
 | 100311 | 2010-03-17 00:00:00 | Customer6 | Product132 | 6000 | 2 | 12000 | 13136.28899835796
 | 100312 | 2010-03-18 00:00:00 | Customer7 | Product136 | 7000 | 2 | 14000 | 15325.67049808429
 | 100313 | 2010-03-19 00:00:00 | Customer8 | Product140 | 8000 | 2 | 16000 | 17515.05199781062
 | 100314 | 2010-03-20 00:00:00 | Customer9 | Product144 | 9000 | 2 | 18000 | 19704.43349753695
DOMESTIC
Spreadsheet: phillip_m_love__30154__9903_OA
Sheet: SE-CON-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  | May |  |  |  |  |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 863312d1710849950-using-operators-with-dates-in-cells-if-with-dates
Sheet: Sheet1

dates | 1st group | 2nd group |  | 1st group start | 1st group end | 2nd group start | 2nd group end
2020-10-18 00:00:00 | yes | no |  | 2020-01-01 00:00:00 | 2021-12-31 00:00:00 | 2022-01-01 00:00:00 | 2023-12-31 00:00:00
2022-04-07 00:00:00 | no | yes
2021-01-05 00:00:00 | yes | no
2021-08-07 00:00:00 | yes | no
2022-04-03 00:00:00 | no | yes
2020-06-06 00:00:00 | yes | no
2020-10-19 00:00:00 | yes | no
2022-06-12 00:00:00 | no | yes
2023-08-29 00:00:00 | no | yes
2021-01-27 00:00:00 | yes | no
2022-06-07 00:00:00 | no | yes
2023-02-03 00:00:00 | no | yes
2023-11-13 00:00:00 | no | yes
2021-05-14 00:00:00 | yes | no
2020-03-04 00:00:00 | yes | no
2022-04-09 00:00:00 | no | yes
2020-01-26 00:00:00 | yes | no
2020-06-15 00:00:00 | yes | no
2022-01-12 00:00:00 | no | yes
This is the formula I want to apply in the columns B&C, I do not want to insert date as a hard core edit inside the formula, but want to refer to the cells contains the dates and use operators only like <,>,=,<=,>=
=IF(A2"<="$F$2&">="$E$2,"yes","no")
Spreadsheet: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: Sanctions

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Management (Undercare)
Activity Name | Sanctions
Activity Description / Purpose | Penalizing the customer for non-compliance.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Record information in case notes
Update information in WMS
Redetermine eligibility
Apply sanction
Decision: Remain eligible? Now ineligible?
Close case if ineligible
Submit recovery of payment if necessary
Spreadsheet: 8598ff63-ab0a-49fd-a291-773298f27f08
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
DOGD | Test | DOGD | Dog Dander, IgE | Dog Dander, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
DOGD | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
DOGD | Result | DOGD | Dog Dander, IgE | Dog Dander, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6098-8 | Dog dander [NAME].IgE:ACnc:Pt:Ser:Qn: