tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 456229d1460709526-plot-all-dates-only-for-particular-given-year-plot-dates-for-particular-given-year-150416
Sheet: Sheet1

2015-01-23 00:00:00 |  | Input | 2016 |  | 2016-01-01 00:00:00 |  | Plot dates only for particular given year
 |  |  |  |  | 2016-01-08 00:00:00
 |  |  |  |  | 2016-01-15 00:00:00 |  | Hello Friends
 |  |  |  |  | 2016-01-22 00:00:00
 |  |  |  |  | 2016-01-29 00:00:00 |  | Please find the attached file (Plot dates for particular given year 150416.xlsx).
 |  |  |  |  | 2016-02-05 00:00:00
 |  |  |  |  | 2016-02-12 00:00:00 |  | I need to plot the all dates only in the given year in a vertical list of dates in light yellow cells.
 |  |  |  |  | 2016-02-19 00:00:00
 |  |  |  |  | 2016-02-26 00:00:00 |  | thanks in advance
 |  |  |  |  | 2016-03-04 00:00:00
 |  |  |  |  | 2016-03-11 00:00:00
 |  |  |  |  | 2016-03-18 00:00:00
 |  |  |  |  | 2016-03-25 00:00:00
 |  |  |  |  | 2016-04-01 00:00:00
 |  |  |  |  | 2016-04-08 00:00:00
 |  |  |  |  | 2016-04-15 00:00:00
 |  |  |  |  | 2016-04-22 00:00:00
 |  |  |  |  | 2016-04-29 00:00:00
 |  |  |  |  | 2016-05-06 00:00:00
 |  |  |  |  | 2016-05-13 00:00:00
 |  |  |  |  | 2016-05-20 00:00:00
 |  |  |  |  | 2016-05-27 00:00:00
 |  |  |  |  | 2016-06-03 00:00:00
 |  |  |  |  | 2016-06-10 00:00:00
 |  |  |  |  | 2016-06-17 00:00:00
 |  |  |  |  | 2016-06-24 00:00:00
 |  |  |  |  | 2016-07-01 00:00:00
 |  |  |  |  | 2016-07-08 00:00:00
 |  |  |  |  | 2016-07-15 00:00:00
 |  |  |  |  | 2016-07-22 00:00:00
 |  |  |  |  | 2016-07-29 00:00:00
 |  |  |  |  | 2016-08-05 00:00:00
 |  |  |  |  | 2016-08-12 00:00:00
 |  |  |  |  | 2016-08-19 00:00:00
 |  |  |  |  | 2016-08-26 00:00:00
 |  |  |  |  | 2016-09-02 00:00:00
 |  |  |  |  | 2016-09-09 00:00:00
 |  |  |  |  | 2016-09-16 00:00:00
 |  |  |  |  | 2016-09-23 00:00:00
 |  |  |  |  | 2016-09-30 00:00:00
 |  |  |  |  | 2016-10-07 00:00:00
 |  |  |  |  | 2016-10-14 00:00:00
 |  |  |  |  | 2016-10-21 00:00:00
 |  |  |  |  | 2016-10-28 00:00:00
 |  |  |  |  | 2016-11-04 00:00:00
 |  |  |  |  | 2016-11-11 00:00:00
 |  |  |  |  | 2016-11-18 00:00:00
 |  |  |  |  | 2016-11-25 00:00:00
 |  |  |  |  | 2016-12-02 00:00:00
 |  |  |  |  | 2016-12-09 00:00:00
 |  |  |  |  | 2016-12-16 00:00:00
 |  |  |  |  | 2016-12-23 00:00:00
 |  |  |  |  | 2016-12-30 00:00:00
Spreadsheet: 710668d1609175635-find-and-return-values-based-off-of-multiple-conditions-return-multiple-matches-with-multiple-conditions-jacc-2
Sheet: REQUEST

PRODUCT | QTY REQ | TAG 1 | TAG 2 | TAG 3 | TAG 4 | TAG 5 | TAG 6 | TAG 7 | TAG 8 | TAG 9 | TAG 10
39573004420 | 420
39573004420 | 125
40887501820 | 290
40887501820 | 345
40887501820 | 200
43341404020 | 40
Spreadsheet: 678941d1590133901-formula-that-results-in-data-input-moving-down-a-column-based-on-another-column-cell-data-moving-down-cell
Sheet: Sheet1

Col.1 | Col.2 | Col.3
2 | #3 | #3
3 | #9
4 | #10
1 | #11
Spreadsheet: 716256d1612123466-have-a-text-value-with-sumifs-forum-excel-31-jan-2021
Sheet: Archive

 | Revenus et dépenses mensuelles par Mois / Année / Catégorie |  |  |  |  |  |  | Revenu individuel par [NAME] |  |  |  | Dépense individuelle par [NAME]
 | Choisissez une option d’affichage |  | Choisissez une année de départ |  | [NAME] affichée:
 | Année financière |  | 2020
 |  |  |  |  |  |  |  | Aimerais-tu voir les revenus globaux? |  |  |  | Aimerais-tu voir les dépenses globales?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Moy. Mois
 | Soldes des comptes par mois, année et compte |  |  |  |  |  |  | Solde comptes individuel
 | Choisissez une option d’affichage |  | Choisissez une année de départ |  | [NAME] affichée: |  |  |  |  | Argent métal |  | FTQ (REER)
 | Année financière |  | 2020 |  |  |  |  |  |  | [NAME] (CÉLI) |  | Urgence
Spreadsheet: darron_c_giron__7977__midland_cogen
Sheet: firm9708

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1997-08-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.11 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 2.13
IFGMR (PEPL/TX/OK) |  |  | 2.06
IFGMR (ANR/LA) |  |  | 2.12
IFGMR (HENRY HUB) |  |  | 2.19
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001 | 3.93
 | 1993 | 2.4 | 2002 | 4.23
 | 1994 | 2.51 | 2003 | 4.73
 | 1995 | 2.61 | 2004 | 5.07
 | 1996 | 2.53 | 2005 | 5.43
 | 1997 | 2.65 | 2006 | 5.82 | JAN-SEP
 | 1998 | 2.67 | 2006 | 5.95 | OCT-DEC
 | 1999 | 2.9 | 2007 | 6.37
 | 2000 | 3.33
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 2b2c6622-8172-41e9-8034-a39667bac4aa
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 | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | 1,000 short tons
2012/131 | 50 | 1125 | 0 | 1175 |  | 1012.163 | 112.837 | 1125 | 50
2013/142 | 50 | 900 | 0 | 950 |  | 797 | 103 | 900 | 50
2014/152 | 50 | 990 | 0 | 1040 |  | 887 | 103 | 990 | 50
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2014-06-13 08:18:41.470000
Spreadsheet: phillip_m_love__30683__onsys forms 0003
Sheet: TXU

TXU Fuel Company
Contract: various | 2000-03-01 00:00:00
 | CPR estimate | Actual Payment | [NAME] | UA 4 RATE
[NAME] | 2063331
VALUE | 5514720.95
NET RATE |  |  |  | 2.54
Volume Variance:
 |  | =D8 (Volume Variance) * (B12-E12) CPR Price less UA 4 Rate
Rate Variance:
 |  | =(B8+D8) Actual [NAME] * (C12-B12) Actual Price less CPR Price
 | TOTAL IMPACT TO INCOME:
 |  | =Volume [NAME]
 |  | Check Figure = ((D10/D8) less E12 UA 4 Rate) * D8
CHECK FIGURE |  | ($1,526,969)/(446,480) LESS $1.947 (UA4 RATE) BY (446,480MMBTU)
Note:
How much  should be deferred?
Spreadsheet: 82740d1282760163-multiplying-a-cell-number-by-a-user-input-number-food-nutrients-counter
Sheet: Fats and Oils

 | Food Nutrients Counter
Fats and Oils | Saturated | [NAME] | Polyun | Total | Calories | Description
Extra Virgin Olive Oil | 11 | 60 | 8 |  | 0 | 100g
Extra Virgin Olive Oil |  |  |  |  | 0 | Table Spoon
[NAME] |  |  |  |  | 0 | 100g
 |  |  |  |  | 0 | 100g
 |  |  |  |  | 0 | 100g
 |  |  |  |  | 0 | 100g
 |  |  |  |  | 0 | 100g
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 760511d1640258074-return-unique-random-in-order-based-on-the-first-2-letters-range-and-letters-from-criteria-return-random-unique-shortcode
Sheet: Sheet1

List |  |  | Name | Criteria | [NAME]
ADD |  |  | Alexis Holand |  | AH3
ADW |  |  | [NAME] |  | AH4
AEF |  |  | [NAME] |  | AFM
AEG |  |  | [NAME] |  | AFO
AEJ |  |  | Argo Force |  | AFP
AFM |  |  | [NAME] |  | ADD
AFO
AFP
AFQ
AFR
AFT
AFV
AFW
AFX
AFZ
AG1
AG4
AG5
AG7
AG8
AG9
AGC
AGE
AGF
AGG
AGH
AGJ
AGK
AGQ
AGW
AGX
AH3
AH4
AH6
AH7
AH8
AH9
AHD
AHE
AHF
AHG
AHH
AHJ
Spreadsheet: 265859d1379426571-sales-ledger-formatting-how-to-insert-an-item-description-without-cut-paste-25k-rows-visual-reference-09172013-post
Sheet: Sheet1

Item Number |  | Item Description
INV# | Date | Customer ID | Customer Name | QTY | Unit Price | Ext Price
ABC Item Number |  | ABC Item Description
Invoice Number 123 | 2013-09-17 00:00:00 | Walmart#123 | Walmart | 100 | 1
Invoice Number 1234 | 2013-09-17 00:00:00 | [NAME] | Walmart | 500 | 1
 |  | Item Total:
ABC Item Number |  | ABC Item Description
Invoice Number 123 | 2013-09-17 00:00:00 | Walmart#123 | Walmart | 100 | 1
Invoice Number 1234 | 2013-09-17 00:00:00 | [NAME] | Walmart | 500 | 1
 |  | Item Total:
Spreadsheet: 799332d1665049616-date-and-time-extraction-in-seperate-columns-excel-formula-required-date-and-time-extraction-excel-formula
Sheet: Sheet2

StartInter | v | al
2022-09-13 00:00:00 | T | 13:30:00 | .000+02:00
2022-09-13 00:00:00 | T | 10:00:00 | .000+02:00
2022-09-13 00:00:00 | T | 11:00:00 | .000+02:00
2022-09-13 00:00:00 | T | 14:30:00 | .000+02:00
2022-09-13 00:00:00 | T | 16:30:00 | .000+02:00
2022-09-13 00:00:00 | T | 11:30:00 | .000+02:00
2022-09-13 00:00:00 | T | 09:30:00 | .000+02:00
2022-09-13 00:00:00 | T | 09:30:00 | .000+02:00
2022-09-13 00:00:00 | T | 08:30:00 | .000+02:00
2022-09-13 00:00:00 | T | 08:30:00 | .000+02:00
2022-09-13 00:00:00 | T | 08:30:00 | .000+02:00
Spreadsheet: 702453d1604354359-lookup-if-time-between-lookup-shift-1-
Sheet: find shift

lookup table |  |  |  |  | data entry | data entry | calc |  | expected result
area | min | [NAME] | shift |  | area | time | shift
a | 600 | 1800 | 1 |  | b | 0615
b | 620 | 1820 | 1 |  | c | 0630 |  |  | 1
c | 630 |  | 1 |  | a | 1830 |  |  | 3
d | 530 |  | 1 |  | d | 1731 |  |  | 3
e | 550 |  | 1 |  | d | 1200 |  |  | 1
 |  |  |  |  | e | 1830 |  |  | 3
if shift (D) not =1, return 3 |  |  |  |  | a | 2200 |  |  | 3
 |  |  |  |  | c | 0625 |  |  | 3
 |  |  |  |  | b | 1020 |  |  | 1
 |  |  |  |  | c | 0815 |  |  | 1
 |  |  |  |  | e | 1430 |  |  | 1
 |  |  |  |  |  | if time (G) between min (B) & max ( C)
 |  |  |  |  |  | lookup area (F) from (A)
 |  |  |  |  |  | result (D) in (H)
Spreadsheet: 726757d1617432809-search-a-string-of-text-for-values-from-a-list-and-return-adjacent-value-search-aligw-help
Sheet: Sheet2

1 Each of 523089_Allsop Monitor/Printer Stand, [NAME], Pearl Black
2 Ream of 675041_Neenah Astrobrights Bright Color Paper, Letter [NAME] (8 1/2in x 11in), 24 [NAME], 30% Recycled, FSC Certified, [NAME], Ream Of 500 Sheets,2 Ream of 420919_Neenah Astrobrights Bright Color Paper, Letter [NAME] (8 1/2in x 11in), 24 [NAME], FSC Certified, Pulsar Pink, Ream Of 500 [NAME] of 255815_Neenah Astrobrights Bright Color Paper, Letter [NAME] (8 1/2in x 11in), 24 [NAME], FSC Certified, Cosmic Orange, Ream Of 500 Sheets,2 Ream of 364065_Neenah Astrobrights Bright Color Paper, Letter [NAME] (8 1/2in x 11in), 24 [NAME], FSC Certified, Terra Green, Ream Of 500 Sheets
20 Each of 197901_CUTTER FOR WIRE TWIST SEALS   #0165-0105  C-7 (REPLACING 197906)
30 Set of 575034_Office Depot Brand Insertable Dividers With Big Tabs, White, Clear Tabs, Set Of 8,12 Each of 211519_Office Depot Brand Heavy-Duty D-Ring View Binder, 1in Rings, Red,12 Each of 211159_Office Depot Brand Heavy-Duty Round-Ring View Binder, 1/2in Rings, Black,12 Each of 208900_Office Depot Brand Durable View Round-Ring Binder, 1 1/2in Rings, 61% Recycled, Black,12 Each of 209809_Office Depot Brand Durable View Round-Ring Binder, 3in Rings, 61% Recycled, [NAME] of 1385587_Cosco Jiffi-Cutter Utility Knives, 1 1/2in, Pack Of 12,12 Pack of 477727_Office Depot Brand Wood Clipboards, [NAME], 100% Recycled,Pack Of 3,2 Dozen of 258971_Avery Marks A Lot Desk-Style Dry Erase Markers, Chisel Tip, Black - Chisel Marker Point Style - Black - 12 / Dozen,6 Pack of 877678_Office Depot Brand Pen-Style Highlighters, 100% Recycled, Assorted Colors, Pack Of 6 Highlighters,5 Pack of 398114_Office Depot Brand Correction Tape With Mini-Roller Head, 394in, White, Pack Of 2,30 Pack of 308114_Office Depot Brand Paper Clips, Jumbo, Silver, Nonskid Finish, 100 Clips Per Box, Pack Of 10 Boxes,30 Pack of 308353_Office Depot Brand Paper Clips, No. 1 Regular, Silver, Nonskid Finish, 100 Clips Per Box, Pack Of 10 Boxes,50 Dozen of 728919_Office Depot Brand Tinted Ballpoint Stick Pens, Medium Point, 1.0 mm, [NAME], Black Ink, Pack Of 12,15 Each of 495390_Bostitch Ergonomic Contemporary Desktop Stapler, Black
20 Each of LPS400_SCALE, PORTABLE BENCH WITH STAINLESS STEEL PLATFORM, 400LB CAPACITY
5 Each of 10961871_( ONLY) PG250RTU-55 LUBRICANT 55GL ALCHEMY SMART SOLUTIONS POLY GUARD 250 RTU BLU 1DR     PG250RTU-55
Spreadsheet: 549963d1512008634-conditional-formatting-question-parking-calendar
Sheet: Data

 |  |  |  |  |  | Total # |  | Cumulative |  | Row | Registration / Name | Individual Dates | Date Ref # |  | Formulae (in green) in columns G-I need to be copied down at least as far as the data in columns A-E (copied to row 100 in example file)
Registration | Name | StartDate | EndDate | Apt # |  | Days |  | 0 |  |  |  |  |  |  | Formulae (in blue) in columns K-N already copied down to row 300 - copy further as required
GA:  BKJ-543 | [NAME] | 2017-04-10 00:00:00 | 2017-04-15 00:00:00 | 221
NC: [NAME] | [NAME] | 2017-04-10 00:00:00 | 2017-04-10 00:00:00 | 443
GA:  DFG76B | Cousland | 2017-04-13 00:00:00 | 2017-04-13 00:00:00 | 158
AL:  789FRG | Georges | 2017-04-13 00:00:00 | 2017-04-17 00:00:00 | 216
CA:  723KYV | Cousland | 2017-04-13 00:00:00 | 2017-04-13 00:00:00 | 158
CA:  925DZY | Jeromes | 2017-04-14 00:00:00 | 2017-04-14 00:00:00 | 118
CA:  221BSL | [NAME] | 2017-04-14 00:00:00 | 2017-04-14 00:00:00 | 231
NJ:  GGB729 | Cousland | 2017-04-15 00:00:00 | 2017-04-16 00:00:00 | 158
MI:  87JH81 | Atwin | 2017-04-15 00:00:00 | 2017-04-15 00:00:00 | 104
FL:  BVN543 | [NAME] | 2017-04-15 00:00:00 | 2017-04-18 00:00:00 | 119
Spreadsheet: 80661d1280868739-data-entry-simplification-cost-detail
Sheet: Sheet1

 |  |  |  |  |  | * Select each product type from dropdown (this was done using data validation on the data tab of your bar above).
 |  |  | COST DETAIL
A | Lense Costs |  |  |  |  | Product (A) | Cost (A) |  | Product (B) | Cost (B) |  | Product ( C ) | Cost ( C ) |  | TOTAL COST
 |  | Lense #1 | 100 |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  | Lense #2 | 200 |  |  | Lense #1 | 100 |  | Material #1 | 50 |  | Other #2 | 50 |  | 200
 |  | etc. |  |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
B | Material Costs |  |  |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  | Material #1 | 50 |  |  | Lense #2 | 200 |  | Material #1 | 50 |  | Other #2 | 50 |  | 300
 |  | Material #2 | 100 |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  | etc. |  |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
C | Other Costs |  |  |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  | Other #1 | 25 |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  | Other #2 | 50 |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  | etc. |  |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  |  |  |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  |  |  |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  |  |  |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  |  |  |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  |  |  |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  |  |  |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  |  |  |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
 |  |  |  |  |  | Lense #1 | 100 |  | Material #2 | 100 |  | Other #2 | 50 |  | 250
Spreadsheet: 883692d1732336935-vlookup-for-salaries-yearly-salary-increment-based-on-anniversay-date-forecasting-salary-forecasting
Sheet: Sheet1

 | As April budget year |  | Month | Update
Employee Name | Level | Step | Anniversary | 2024-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Total Year |  | Spend | Budget
Employee A |  | 8
Employee B
Employee C
Employee D
Employee E
 | Level & Step as at April of the year for which the budget is. |  |  |  |  |  |  |  |  |  |  |  | [NAME] referencing table 2
 | Update annually on 'Patrice Test' sheet, or hardcode above.
 | Step Increases (anniversary & agreement) applied to the month FOLLOWING the month with the anniversary
April 1, 2024 | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 | Step 6 | Step 7 | Step 8
IT-01 | 60000 | 61000 | 62000 | 63000 | 64000 | 65000 | 66000 | 67000
IT-02 | 80000 | 81000 | 82000 | 83000 | 84000 | 85000 | 86000 | 87000
IT-03 | 100000 | 102000 | 104000 | 106000 | 108000 | 110000 | 112000 | 114000
IT-04 | 120000 | 122000 | 124000 | 126000 | 128000 | 130000 | 132000 | 134000
Dec 22, 2024 | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 | Step 6 | Step 7 | Step 8
IT-01 | 61500 | 62500 | 63500 | 64500 | 65500 | 66500 | 67500 | 68500
IT-02 | 81000 | 82000 | 83000 | 84000 | 85000 | 86000 | 87000 | 88000
IT-03 | 101500 | 103500 | 105500 | 107500 | 109500 | 111500 | 113500 | 115500
IT-04 | 121500 | 123500 | 125500 | 127500 | 129500 | 131500 | 133500 | 135500
Spreadsheet: 200665d1355714827-how-to-calculate-days-elapsed-since-initial-record-on-a-per-unique-record-basis-example2
Sheet: DateExample

PID_VAL | PID_ENCID | DATE_VISIT | Days_Since_Last_Visit | Total Duration | Total_MD_Wt_Duration | Total_MD_WT_VisitTimeSinceInitial | PROV_LAST | PROV_FIRST | SBP | DBP | HT | WT | BMI
46 | 46.01 | 2010-04-14 00:00:00 |  |  | 742 |  | Glitter | [NAME] | 95 | 63 |  | 109.5
46 | 46.02 | 2010-10-13 00:00:00 |  |  | 742 |  | Glitter | [NAME] | 91 | 62 |  | 110.5
46 | 46.03 | 2010-12-15 00:00:00 |  |  | 742 |  | Glitter | [NAME] | 93 | 68 |  | 109.8
46 | 46.04 | 2011-06-29 00:00:00 |  |  | 742 |  | Glitter | [NAME] | 95 | 59 | 64 | 109 | 18.6
46 | 46.05 | 2011-10-12 00:00:00 |  |  | 742 |  | Glitter | [NAME] | 87 | 57 | 64.0117756568483 | 109.8 | 18.84
46 | 46.06 | 2011-12-21 00:00:00 |  |  | 742 |  | Glitter | [NAME] | 99 | 61 | 64.02157349556799 | 110.3 | 18.92
46 | 46.07 | 2012-04-25 00:00:00 |  |  | 742 |  | Glitter | [NAME] | 102 | 61 | 64.00716812638014 | 110.6 | 18.98
59 | 59.01 | 2011-05-20 00:00:00 |  |  | 395 |  | Bills | Buffalo | 144 | 65 | 63 | 286 | 50.7
59 | 59.07 | 2011-08-12 00:00:00 |  |  | 395 |  | Bills | Buffalo | 137 | 63 | 63 | 283.7 | 50.3
59 | 59.1 | 2011-10-21 00:00:00 |  |  | 395 |  | Bills | Buffalo | 123 | 60 | 63 | 283.1 | 50.2
59 | 59.11 | 2012-02-06 00:00:00 |  |  | 395 |  | Bills | Buffalo | 112 | 53 | 64 | 289.1 | 49.6
59 | 59.12 | 2012-06-04 00:00:00 |  |  | 395 |  | Bills | Buffalo | 129 | 65 | 64.5 | 279.4 | 47.24
59 | 59.13 | 2012-06-18 00:00:00 |  |  | 395 |  | Bills | Buffalo | 108 | 50 | 64.488 | 279 | 47.17
65 | 65.02 | 2011-03-09 00:00:00 |  |  | 462 |  | Glitter | [NAME] | 115 | 74 |  | 137.8
65 | 65.03 | 2011-08-31 00:00:00 |  |  | 462 |  | Glitter | [NAME] | 103 | 73 | 62.01114825612162 | 140.4 | 25.67
65 | 65.04 | 2011-12-21 00:00:00 |  |  | 462 |  | Glitter | [NAME] | 126 | 75 | 62.24847078492262 | 135.8 | 24.64
65 | 65.05 | 2012-06-13 00:00:00 |  |  | 462 |  | Glitter | [NAME] | 109 | 69 | 61 | 134.5 | 25.43
Spreadsheet: 6ad60779-11f2-4cfe-9c9d-992494a7b6c4
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
LPS | Test | LPS | Lipase, Serum | Lipase, S | Colorimetric Rate Reaction | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.5 mL | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | > or =16 years: 10-73 U/L Reference values have not been established for patients that are <16 years of age. | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 83690 |  |  |  |  | Rochester
LPS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
LPS | Result | LPS | Lipase, S | Lipase, S | Numeric |  |  |  |  | U/L |  |  |  |  |  |  |  |  |  | 3040-3
Spreadsheet: 857078d1706156276-help-using-a-lookup-function-with-mutiple-criteria-job-schedule-dataset-ws-pq-solution-1-
Sheet: Sheet4

 |  |  |  | Job # | Bay # | Phase 60 | Phase 65 | Phase 70 | Phase 80 | Phase 90 |  | Bay # | Date
 |  |  |  | 8000 | 25 | 2023-01-31 00:00:00 | 2023-02-02 00:00:00 | 2023-02-12 00:00:00 | 2023-02-28 00:00:00 | 2023-03-14 00:00:00 |  | 5 | 2023-02-10 00:00:00
 |  |  |  | 7999 | 24
 |  |  |  | 7998 | 5
 |  |  |  | 7997 | 4 |  |  |  |  |  |  | Job # | Bay # | Attribute | Value
 |  |  |  | 7996 | 3 |  |  |  |  |  |  | 7998 | 5 | Phase 60 | 2023-02-10 00:00:00
Spreadsheet: chris_germany__2631__CES Invoice Jan2000
Sheet: Billing

Type | Delivery_Start_Date | Delivery_End_Date | Pipeline_Id | Point_Name | Sitara # | Item_Description | Quantity | Quantity_Unit_Id | Unit_Price | Extended_Amount
Manual Billing Items
Manual | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | TGT | Texas Gas Zone 4 | 146044 | Cost of Gas | 88319 | MMBtu | 2.53
Manual | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | CGAS | CGAS Pool | 149785 | Cost of Gas | 221898 | MMBtu
Manual | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | CGAS | CGAS Pool | 145328 | Cost of Gas | 105555 | MMBtu
Manual | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | CGAS | CGAS City Gate | 143768 | Cost of Gas | 3750 | MMBtu | 2.82
Manual | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | CGAS | CGAS City Gate | 143769 | Cost of Gas | 780 | MMBtu | 2.82
Manual | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | CGAS | CGAS City Gate | 145482 | Cost of Gas | 7616 | MMBtu | 2.74
Manual | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | CGULF | [NAME] | 144289 | Cost of Gas | 490172 | MMBtu | 2.319
Manual | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | CGAS | Cove Point Gas |  | Cost of Gas | 141915 | MMBtu | 7.2303
Manual | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | CGAS | CGAS Citygate at FT Commodity |  | Cost of Gas | 4413132 | MMBtu | 2.5741
Manual | 2000-01-01 00:00:00 | 2000-01-31 00:00:00 | CGAS | CGAS Citygate at IT Commodity |  | Cost of Gas | 74358 | MMBtu | 2.7837
Other Billing Items
 |  |  |  | CES Transport Demand Charges |  |  |  |  |  | 2148138
 |  |  |  | ENA Scheduling Fee |  |  |  |  |  | 20000
Questions
 | Missing deal 144289, CGLF Onshore EFP.  Price = 2.319, volume = 490,172 dth.
Spreadsheet: 266506d1379632986-need-to-apply-conditional-formatting-of-a-cell-base-on-text-in-multiple-other-cells-ftftracker-2
Sheet: FTF ACTIONS

 |  | Admin /Actions
Failures | Last Passed | LOC Given | LOR Given | CC - LOR Given | Jag - LOR
Blackman | 2012-11-28 00:00:00 | Another Unit | 2013-08-16 00:00:00 |  |  |  |  | Awaiting Action
Carreon | 2013-02-14 00:00:00 | 2012-05-05 00:00:00 | 2013-09-07 00:00:00
[NAME] | 2012-12-09 00:00:00 | 2013-07-27 00:00:00 | Awaiting Action
Escalante | 2012-01-22 00:00:00 | 2012-08-19 00:00:00 | 2019-05-19 00:00:00 | Awaiting Action
Hill | BMT | Awaiting Action
Munoz | 2013-03-24 00:00:00 | Awaiting Action
Neabors | 2011-11-20 00:00:00 | 2013-07-24 00:00:00 | Awaiting Action
Ramos | 2013-02-24 00:00:00 | 2012-01-22 00:00:00 | N/A | Awaiting Action
Randles | 2013-02-24 00:00:00 | 2012-01-22 00:00:00 | 2012-12-08 00:00:00 | Awaiting Action
[NAME] | 2013-02-24 00:00:00 | 2013-07-27 00:00:00 | Awaiting Action
Saldana | 2012-09-26 00:00:00 | 2013-08-03 00:00:00
Thompson | 2012-04-22 00:00:00 | Another Unit | 2013-08-03 00:00:00
Zink | 2013-02-24 00:00:00 | 2012-06-08 00:00:00 | 2013-09-07 00:00:00
Spreadsheet: 60243d1260820371-conditional-formatting-to-find-non-unique-values-conditional
Sheet: Sheet1

Product ID | Vendor ID | Vendor
J567 | A1 | [NAME]
V365 | A2 | Greg
M292 | A2 | Greg
G497 | A3 | [NAME]
G363 | A3 | [NAME]
V445 | A4 | Daryl
What it should look like after conditional formating
Product ID | Vendor ID | Vendor
J567 | A1 | [NAME]
V365 | A2 | Greg
M292 | A2 | Greg
G497 | A3 | [NAME]
G363 | A3 | [NAME]
V445 | A4 | Daryl