tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 32734d1228913873-find-a-date-datelookup
Sheet: Overview

Project | Initial Design | Design Review | Design Modification | Client Review | Send Drawings To Contractor | Pre-Start Meeting | Sign Off
Site 1 | 2008-05-03 00:00:00 | 2008-07-06 00:00:00 | 2008-07-21 00:00:00 | 2008-10-30 00:00:00 | 2008-11-04 00:00:00 | 2008-12-16 00:00:00 | 2008-12-20 00:00:00
Site 2 | 2008-05-16 00:00:00 | 2008-07-19 00:00:00 | 2008-08-03 00:00:00 | 2008-11-12 00:00:00 | 2008-11-17 00:00:00 | 2008-12-29 00:00:00 | 2009-01-02 00:00:00
Site 3 | 2008-07-03 00:00:00 | 2008-09-05 00:00:00 | 2008-09-20 00:00:00 | 2008-12-30 00:00:00 | 2009-01-04 00:00:00 | 2009-02-15 00:00:00 | 2009-02-19 00:00:00
Site 4 | 2008-02-21 00:00:00 | 2008-04-25 00:00:00 | 2008-05-10 00:00:00 | 2008-08-19 00:00:00 | 2008-08-24 00:00:00 | 2008-10-05 00:00:00 | 2008-10-09 00:00:00
Site 5 | 2008-03-05 00:00:00 | 2008-05-08 00:00:00 | 2008-05-23 00:00:00 | 2008-09-01 00:00:00 | 2008-09-06 00:00:00 | 2008-10-18 00:00:00 | 2008-10-22 00:00:00
Site 6 | 2008-04-22 00:00:00 | 2008-06-25 00:00:00 | 2008-07-10 00:00:00 | 2008-10-19 00:00:00 | 2008-10-24 00:00:00 | 2008-12-05 00:00:00 | 2008-12-09 00:00:00
Site 7 | 2007-12-11 00:00:00 | 2008-02-13 00:00:00 | 2008-02-28 00:00:00 | 2008-06-08 00:00:00 | 2008-06-13 00:00:00 | 2008-07-25 00:00:00 | 2008-07-29 00:00:00
Site 8 | 2007-12-24 00:00:00 | 2008-02-26 00:00:00 | 2008-03-12 00:00:00 | 2008-06-21 00:00:00 | 2008-06-26 00:00:00 | 2008-08-07 00:00:00 | 2008-08-11 00:00:00
Site 9 | 2008-02-10 00:00:00 | 2008-04-14 00:00:00 | 2008-04-29 00:00:00 | 2008-08-08 00:00:00 | 2008-08-13 00:00:00 | 2008-09-24 00:00:00 | 2008-09-28 00:00:00
Site 10 | 2007-09-30 00:00:00 | 2007-12-03 00:00:00 | 2007-12-18 00:00:00 | 2008-03-28 00:00:00 | 2008-04-02 00:00:00 | 2008-05-14 00:00:00 | 2008-05-18 00:00:00
Spreadsheet: 84732d1284730716-column-consolidation-column-consolidation-macro
Sheet: Depatment 2

Department | Postion | Status 1 | Status 2 | Status 3 | Status 4 | HC postion | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
Ac | GM | Expat | China | Bejeing | JB | 1 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
Ac | GM | Expat | China | Bejeing | DT | 0 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
Ac | DGM | Expat | China | Bejeing | JB | 1 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75
Ac | DGM | Expat | China | Bejeing | DT | 0 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
Ac | FM | Expat | China | Bejeing | JB | 1 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6
Ac | FM | Expat | China | Bejeing | DT | 0 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4
Ac | CM | Local | China | Bejeing | JB | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Ac | CM | Local | China | Bejeing | DT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ac | OM | Expat | UK | London | JB | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Ac | OM | Expat | UK | London | DT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 68120d1268676909-return-a-yes-no-value-for-dat-tolerance-tolerance
Sheet: Sheet2

[NAME] Above 50 | [NAME] Below 50
50.2 | 49.99 |  |  | Tolerance of 0.1 or -0.1
50.4 | 49.07
50.02 | 47
50 | 49
50.01 | 49.09
50.2 | 49.99
50.1 | 49.99
52.08 | 49.95
50.01 | 48.08
52 | 49.8
50.09 | 48.08
50.9 | 49.99
53 | 49.07
52 | 49.99
50.04 | 47.99
50.06 | 47
50.07 | 49.99
52 | 49.93
50.12 | 49.99
50.13 | 49.96
51 | 49.6
50.15 | 48.99
50.23 | 49.99
Total comparisons
Total Yes
% Yes
Spreadsheet: 672515d1586895214-calculating-total-of-repeating-columns-due-to-day-date-gl-tap-ex
Sheet: FLAG

 | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Tech EOF Total for Month:
 | 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
TECHNICIAN | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH | FH
A | 2 | 2 | 2 |  |  | 13
B | 0 | 0 | 8 | 0 |  | 2.5
C | 1.7 | 2.1 | 0 | 0 |  | 0
D | 2.5 | 0.3 | 3.2 | 0 |  | 0.4
E | 0 | 0.5 | 2.5 | 0 |  | 5.3
F | 0 | 2 | 0 | 0 |  | 3.5
G | 0 | 0 | 1.8 | 3 |  | 1.8
H
I
J
K
L
M
N
O
Total Day %
Spreadsheet: 828908d1683791667-search-a-text-from-an-array-of-values-fetch-object
Sheet: Data

Text | Find Object | Cheese | Expected Result
1.  Hours and [NAME] (P311221) |  |  | P311221
1. RMA Revisions - P400511 (ZJDE0001) |  |  | P400511
6. Preference Profile (R40400) |  |  | R40400
12. Specify P4113 version to use (Recognize blank LOTS) custom PO's from P4113 to hold TO_LOCATION lot status even though it is blank.   Note - this option is used inline with above PO option value -1.    Default - ZJDE0001 |  |  | P4113
2. Enter Version for R04110ZA |  |  | R04110ZA
1. Enter Version for R47011 : |  |  | R47011
3.  Enter the version for [NAME] (cvt to .txt) to call.       Blank = Version XBX0002 with the country        code defined here. |  |  | [NAME]
12. P42101 [NAME] |  |  | P42101
1. R42565 Version |  |  | R42565
Spreadsheet: jeff_king__14269__Curve Sheet
Sheet: Sheet1

 |  | Curves as of:
 |  |  |  | Bal-Jan | Feb
 |  | Peak Positions |  | Curve | Curve
 |  | CINERGY | Peak | 20.55 | 21.3
 |  | COMED | Peak | 20.35 | 21
 |  | ENTERGY | Peak | 19.3 | 19.35
 |  | NEPOOL | Peak | 31 | 31.25
 |  | PJM | Peak
 |  | ERCOT | Peak
 |  | TVA | Peak
 |  |  |  | Bal-Jan | Feb
 |  | Off-Peak Positions |  | Curve | Curve
 |  | CINERGY | [NAME] | 16 | 16.75
 |  | NEPOOL | [NAME] | 25.75 | 26
 |  | PJM | [NAME]
Spreadsheet: 144895d1331197965-copying-from-1-sheet-to-many-sheets-sales-records-sample
Sheet: JOHN CLARKE

SALES SETTLEMENTS & RECEIPTS RECONCILIATION
2012
[NAME]
Date | Invoice No | Client Name | Accounting Code | Model | Delivery Date | Qty | [NAME] | Ex-Stock / On Order | Amount | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Balance |  |  |  |  | DELIVERED | DEPOSIT OF | CHECKING IF DEPOSIT IS EQUAL TO  60%
 |  |  |  |  |  |  |  |  |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  |  |  |  |  |  | SALAH
 |  |  |  |  |  |  |  |  |  | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No |  |  |  |  |  | ON:
 |  |  |  |  |  |  |  |  | € | € |  | € |  | € |  | € |  | € |  | € |  | € |  | € |  | €
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 669250d1585262785-conditional-format-data-in-horizontal-criteria-from-vertical-book1
Sheet: Sheet1

 |  |  |  | B [NAME]
 | B | C
 | ABCDEF1 |  |  | ABCDEF1 | ABCDEF2 | ABCDEF3 | ABCDEF4 | ABCDEF5 | ABCDEF6 | ABCDEF7 | ABCDEF8 | ABCDEF9 | ABCDEF10
 | ABCDEF2
 | ABCDEF3 | y |  | Conditional format for E4:N4 marked "y" in C4:C13
 | ABCDEF4
 | ABCDEF5
 | ABCDEF6 | y
 | ABCDEF7
 | ABCDEF8 | y
 | ABCDEF9
 | ABCDEF10
Spreadsheet: 106113d1303327285-data-comparison-assignment-help
Sheet: Assignments

Staff Name | Assigned Patient Number
Kertz, Fred | 16347
Kertz, Fred | 16323
Kertz, Fred | 16373
Kertz, Fred | 16230
Young, [NAME] | 16320
Young, [NAME] | 14922
Young, [NAME] | 16515
Young, [NAME] | 15716
Thompson, [NAME] | 16435
Thompson, [NAME] | 16500
Thompson, [NAME] | 15914
Thompson, [NAME] | 14863
Chambers, Caroline | 16249
Chambers, Caroline | 15673
Spreadsheet: 114233d1310033362-match-two-lists-and-sum-compare2
Sheet: Sheet1

A | 2
B | 3 |  |  | SUM OF ARRAY
C | 4 |  |  | E
D | 4 |  |  | N
E | 5 |  |  | K
F | 6 |  |  | V
G | 7 |  |  | Y
H | 8
I | 9 |  |  | FORMULA 1 | REQUIRED ANSWER
J | 0 |  |  |  |  | 12
K
L | 2
M | 3
N | 4
O | 4 |  |  |  | FORMULA 2 | REQUIRED ANSWER
P | 5 |  |  | SUM OF ARRAY {E,N,K,V,Y} |  | 12
Q | 6
R | 7
S | 8 |  |  |  | Here:
T | 9
U | 0
V | A
W | 9
X | 6
Y | 3
Z | 1
Spreadsheet: 693512d1598998827-excel-formula-function-help-needed-mock-upv2
Sheet: extracted from Database

SSN | Network | Account | Group | ID | Code | First Name | Last Name | Gender | DOB | From Date | End Date
093865135 | ABC123 | OPEN | 8525JK | 96385214743 | 04 | Trance | Pung | M | 1950-02-08 00:00:00 | 2019-01-01 00:00:00 | 2019-04-30 00:00:00
093865135 | ABC123 | OPEN | 8526JK | 52085496321 | 04 | Trance | Pung | M | 1950-02-08 00:00:00 | 2019-02-01 00:00:00 | 2019-07-31 00:00:00
093865135 | ABC123 | RETIREE | 8528LM | 96548963212 | 06 | Trance | Pung | M | 1950-02-08 00:00:00 | 2020-09-01 00:00:00 | 2039-12-31 00:00:00
Spreadsheet: 96112d1295552336-alternative-to-vlookup-excel-problem
Sheet: Overview

[NAME] | City | Contact Name | [NAME] | Status | Material 1 Code | Material 1  Desciption | Material 2 Code | Material 2  Desciption | Material 3 Code | Material 3  Desciption | Material 4 Code | Material 4  Desciption | Material 5 Code | Material 5  Desciption | Material 6 Code | Material 6  Desciption | Material 7 Code | Material 7  Desciption | Material 8 Code | Material 8 Desciption | Material 9 Code | Material 9  Desciption
Supplier 1 | Grinsted | [NAME]
Supplier 2 | Philadelphia | Simone
Supplier 3 | Cheshire | [NAME]
Supplier 4 | Kessel-Statie | [NAME]
Supplier 5 | Selangor Darul Ehsan | [NAME]
Supplier 6 | Confienza | Nick
Supplier 7 | Bedfordshire | Bernardita
Supplier 8 | Plainsboro | Regina
Supplier 9 | Ulm | Carrie
Supplier 10 | Leeuwarden | Simone
Supplier 11 | Dortmund | [NAME]
Supplier 12 | [NAME] | [NAME]
Supplier 13 | Mierlo | [NAME]
Supplier 14 | Bremen | Glyn
Supplier 15 | Norfolk | Carrie
Supplier 16 | London | Simone
Supplier 17 | Suffolk | Pam
Supplier 18 | Chile | Michel
Supplier 19 | Baden-Wurttenberg | Sales Team
Supplier 20 | Cheshire | [NAME]
Supplier 21 | Hameln | [NAME]
Supplier 22 | Chester | Nick
Supplier 23 | London | Guy
Supplier 24 | Antwerpen | Viviane
Supplier 25 | Kent | [NAME]
Supplier 26 | Buckinghamshire | [NAME]
Supplier 27 | Milton keynes | [NAME]
Supplier 28 | Stowmarket | [NAME]
Supplier 29 | Bagsvaerd | [NAME]
Supplier 30 | West Sacramento | Glyn
Supplier 31 | Lakeville | Carrie
Supplier 32 | Oreye | Simone
Supplier 33 | Lyon | Pam
Spreadsheet: 50281d1249652323-lookup-and-index-sample
Sheet: Construction Fees

 | NAME | LOAN # | Date | CR Amt | Draw Date | Draw Amt | Draw Date | Draw Amt | Draw Date | Draw Amt | Draw Date | Draw Amt | Draw Date | Draw Amt | Draw Date | Draw Amt | Balance
 | d | 4
 | g | 7
Spreadsheet: 806388d1669276591-remove-time-from-date-remove-time-from-date
Sheet: Sheet3

Date |  | Date
9/9/2022, 12:17 AM |  | 2022-09-09 00:00:00
9/7/2022, 7:40 PM |  | 2022-09-07 00:00:00
9/7/2022, 7:30 PM |  | 2022-09-07 00:00:00
9/7/2022, 10:54 PM |  | 2022-09-07 00:00:00
9/7/2022, 10:29 PM |  | 2022-09-07 00:00:00
8/3/2022, 3:36 PM |  | 2022-08-03 00:00:00
8/11/2022, 10:01 AM |  | 2022-08-11 00:00:00
8/10/2022, 10:59 AM |  | 2022-08-10 00:00:00
7/20/2022, 11:50 PM |  | 2022-07-20 00:00:00
7/20/2022, 11:30 PM |  | 2022-07-20 00:00:00
6/7/2022, 3:22 PM |  | 2022-06-07 00:00:00
6/7/2022, 3:13 PM |  | 2022-06-07 00:00:00
6/7/2022, 2:29 PM |  | 2022-06-07 00:00:00
6/7/2022, 1:59 PM |  | 2022-06-07 00:00:00
5/17/2022, 2:16 PM |  | 2022-05-17 00:00:00
Spreadsheet: 23e68f75-fbc0-4395-82ac-83d5b0dd7796
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8465 | 41151 | [NAME] | Wersy | FRA | 0 | 00:10:28 | 00:03:40 | 00:41:36 | 00:00:59 | 00:20:34 | 1 | 01:17:17
8465 | 13699 | [NAME] | Averesch | GER | 0 | 00:11:47 | [NAME] | [NAME] | 00:00:59 | [NAME] | 2 | 01:19:23
8465 | 41073 | [NAME] | Seemann | GER | 0 | 00:09:01 | 00:07:40 | 00:39:29 | 00:00:59 | [NAME] | 3 | 01:24:59
8465 | 63496 | Markus | [NAME] | GER | 0 | 00:16:47 | 00:07:21 | 00:51:37 | 00:00:59 | 00:24:57 | 4 | 01:41:41
8465 | 27354 | Sven | Niebergall | GER | 0 | 00:24:25 | 00:07:34 | 00:47:54 | 00:00:59 | 00:27:26 | 5 | 01:48:19
8465 | 63498 | [NAME] | Binder | GER | 0 | 00:24:22 | 00:09:13 | 00:55:07 | 00:00:59 | [NAME] | 6 | 02:06:31
Spreadsheet: 180167d1347497850-copy-text-to-different-tab-depending-on-pull-down-selection-ef187_excelexperts
Sheet: Master Summary 

 | SUMMARY OF COMPLAINTS
seq |  | Name on Acct | Acct # | State | Agent | Received from | Notes
 |  | [NAME] | 25 | ca | timmy | AG
 |  | [NAME] | 28 | ga | kimmy | BBB
 |  | [NAME] | 100 | UT | [NAME] | Phone
 |  | [NAME] | 150 | OH | [NAME] | Web
 |  | test1 | 1001 | NY | Fred | AG | notes1
 |  | test2 | 1002 | NY | Fred | AG
 |  | test3 | 1003 | NY | Fred | AG
 |  | test4 | 1004 | WA | [NAME] | Web | [NAME]
 |  | [NAME] | 101 | UT | [NAME] | Phone
 |  | [NAME] | 102 | UT | [NAME] | Phone | notes3
Spreadsheet: john_lavorato__16544__Inc Statements 1992 - 2001
Sheet: Sheet1

Enron Canada Corp.
Gross Margin and EBIT (in US$)
Income (Loss)
 | Enron Canada Corp. |  |  | Enron Canada Power Corp. |  |  | Total
Year | Gross Margin | EBIT |  | Gross Margin | EBIT |  | Gross Margin | EBIT
10 months ended October 31, 2001 | 252370517.200001 | 219646626 |  | 125071299.39 | 129871069.84
12 months ended December 31, 2000 | 15272567.3500004 | -1383522.22999962
12 months ended December 31, 1999 | 94956676 | 73801857
12 months ended December 31, 1998 | 68316215.1199999 | 53217161.5799999
12 months ended December 31, 1997 | 61274060.3800001 | 54594918.6800001
12 months ended December 31, 1996 | 27026393.77 | 17059425.95
12 months ended December 31, 1995 | 25464971.6904684 | 18734307.420048
12 months ended December 31, 1994 | 11897927 | 6390580
12 months ended December 31, 1993 | 981651 | -400839
4 months ended December 31, 1992 | 583429 | -6519
Spreadsheet: darrell_schoolcraft__7809__imbalsumm0108
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 320046 | 326630 | 68213 | 62006 | 60282 | 67308 | 134575 | 120400 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 322443 | 342258 | 80613 | 62006 | 65523 | 61458 | 114858 | 123670
3 | 339003 | 356730 | 65345 | 62006 | 62518 | 57038 | 133408 | 135294 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 | 330189 | 334992 | 71515 | 62006 | 68003 | 60854 | 121528 | 122443 |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 | 325424 | 357543 | 76506 | 45334 | 60101 | 61458 | 122124 | 116046 |  |  |  | 2001-02-01 00:00:00 | 15193330 | 15256233 |  | 5.61
6 | 338716 | 363512 | 73883 | 62006 | 63277 | 61458 | 128438 | 126142 |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 | 307409 | 329009 | 81561 | 62006 | 61385 | 66177 | 128949 | 116696 |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 | 335665 | 339813 | 69904 | 62006 | 64156 | 66309 | 123188 | 131814 |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 | 339468 | 343257 | 62256 | 62006 | 68558 | 62714 | 133641 | 126893 |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.45
10 | 325004 | 326102 | 61460 | 62006 | 56382 | 53686 | 141587 | 135180 |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 | 348691 | 329322 | 39888 | 62006 | 62036 | 61116 | 154963 | 154094
12 | 343074 | 331485 | 41056 | 62006 | 63625 | 61306 | 145898 | 141767
13 | 329776 | 327012 | 46642 | 59179 | 62952 | 61308 | 138478 | 126232
14 | 326625 | 336221 | 37103 | 26877 | 56806 | 58064 | 133830 | 131396
15 | 336681 | 332244 | 61849 | 62006 | 56541 | 57130 | 149355 | 149369
16 | 330403 | 330339 | 63183 | 62006 | 56691 | 58312 | 153223 | 151210
17 | 334818 | 346212 | 81572 | 62006 | 63376 | 65126 | 135420 | 142145
18 | 366455 | 357416 | 64878 | 62006 | 59007 | 58705 | 125144 | 131878
19 | 297258 | 320201 | 63849 | 62006 | 57721 | 60383 | 126422 | 129766
20 | 322632 | 322211 | 62973 | 62006 | 57755 | 56963 | 119641 | 119045
21 | 338791 | 340947 | 64404 | 60467 | 52773 | 50154 | 128561 | 132981
22 | 322113 | 321612 | 62032 | 62005 | 59462 | 53971 | 124463 | 122727
23 | 317312 | 313150 | 62012 | 60837 | 54209 | 52721 | 140828 | 137994
24 | 280757 | 274743 | 68585 | 82867 | 51834 | 49477 | 139939 | 138872
25 | 305788 | 302147 | 64078 | 62006 | 47855 | 55810 | 117719 | 111618
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  |  |  |  |  | 310268
2001-08-25 00:00:00
CBS Dollars
 |  |  | 1379269.57
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
Spreadsheet: 288e4882-eab3-434c-85b0-dd327942d908
Sheet: Todo (4)

 | TO DO LIST
 | Name : | [NAME]
 | Progress
 | No | To Do | Status
 | 1 | To Do 1 | Done
 | 2 | To Do 2 | Done
 | 3 | To Do 3 | Done
 | 4 | To Do 4 | Done
 | 5 | To Do 5 | Done
 | 6 | To Do 6 | Done
 | 7 | To Do 7 | Done
 | 8 | To Do 8 | Done
 | 9 | To Do 9
 | 10 | To Do 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
Spreadsheet: 845094d1696630805-formula-for-total-to-stop-at-0-distro-example
Sheet: Distro List 

 |  |  |  |  |  |  |  |  |  |  | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE
 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 5 | 6 | 9 | 14 | 17 | 18 | 21 | 22 | 30 | 32 | 36 | 42 | 43 | 46 | 50 | 51 | 52 | 57 | 80 | 12 | 13 | 19 | 29 | 35 | 39 | 41 | 44 | 47 | 55 | 56 | 59 | 65 |  | total | ATS | REMAINING
SIZE | Item | Style Description | material |  |  |  | a | b | c | d | A | b | b | a | c | b | a | b | c | c | a | c | a | b | c | c | b | c | a | c | c | a | a | a | a | b | a | b | a | b | a | a | b | a
 | Cards
 | Cards |  |  |  |  |  | 300 | 250 | 250 |  |  |  |  |  |  |  |  |  |  | 300
 | Items
 | SNAP WALLET: 1
 | SNAP WALLET: 2
 | SNAP WALLET: 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 708254d1607697320-arrange-data-in-columns-b-and-c-against-a-linear-timeline-in-column-a-colmatchsample
Sheet: Sheet1

Timeline | SourceDate | SourceValue |  | PastedSourceDate | PastedSourceValue
2019-01-01 00:00:00 |  |  |  | 2019-01-03 00:00:00 | 6abf
2019-01-02 00:00:00 |  |  |  | 2019-01-04 00:00:00 | c89d
2019-01-03 00:00:00 |  |  |  | 2019-01-06 00:00:00 | 34df
2019-01-04 00:00:00 |  |  |  | 2019-01-08 00:00:00 | f561
2019-01-05 00:00:00 |  |  |  | 2019-01-09 00:00:00 | bbac
2019-01-06 00:00:00
2019-01-07 00:00:00
2019-01-08 00:00:00
2019-01-09 00:00:00
2019-01-10 00:00:00
Expected results:
Timeline | SourceDate | SourceValue
2019-01-01 00:00:00
2019-01-02 00:00:00
2019-01-03 00:00:00 | 2019-01-03 00:00:00 | 6abf
2019-01-04 00:00:00 | 2019-01-04 00:00:00 | c89d
2019-01-05 00:00:00
2019-01-06 00:00:00 | 2019-01-06 00:00:00 | 34df
2019-01-07 00:00:00
2019-01-08 00:00:00 | 2019-01-08 00:00:00 | f561
2019-01-09 00:00:00 | 2019-01-09 00:00:00 | bbac
2019-01-10 00:00:00
Spreadsheet: darrell_schoolcraft__7746__LinksPhoneList02
Sheet: Sheet1

LINKS MEETING LIST 2002
 | [NAME] |  | [PHONE] |  | NNG/TW |  | Houston
 | [NAME] |  | [PHONE] |  | NNG |  | Houston
 | [NAME] |  | [PHONE] |  | NNG |  | Ogden
 | [NAME] |  | [PHONE] |  | NNG |  | Amarillo
 | [NAME] |  | [PHONE] |  | NNG |  | Omaha
 | [NAME] |  | [PHONE] |  | NNG |  | Omaha
 | [NAME] |  | [PHONE] |  | NNG |  | Hugoton
 | [NAME] |  | [PHONE] |  | NNG |  | Mullinville
 | [NAME] |  | [PHONE] |  | NNG |  | Hugoton
 | [NAME] |  | [PHONE] |  | NNG |  | Holcomb
 | Ike Halling |  | [PHONE] |  | NNG |  | Burdett
 | [NAME] |  | [PHONE] |  | NNG |  | Mullinville
 | [NAME] |  | [PHONE] ext. 201 |  | NNG |  | Macksville
 | [NAME] |  | [PHONE] |  | NNG |  | Sublette
 | [NAME] |  | [PHONE] |  | NNG |  | Holcomb Field
 | [NAME] |  | [PHONE] |  | NNG |  | Hugoton Field
 | [NAME] |  | [PHONE] |  | NNG |  | Texas Co.
 | [NAME] |  | [PHONE] |  | NNG |  | Texas Co.
 | [NAME] |  | [PHONE] |  | NNG |  | Ashland
 | [NAME] |  | [PHONE] |  | Exxon/Mobil |  | Hugoton
 | [NAME] |  | [PHONE] |  | Exxon/Mobil |  | Hugoton
 | [NAME] |  | [PHONE] |  | Exxon/Mobil |  | Hugoton
 | [NAME] |  | [PHONE] |  | OFS |  | Bushton
 | [NAME] |  | [PHONE] |  | OFS |  | Bushton
 | [NAME] |  | [PHONE] |  | Oneok |  | Liberal
 | [NAME] |  | [PHONE] |  | Oneok |  | Liberal
 | [NAME] |  | [PHONE] ext. 226 |  | Oneok |  | Liberal
 | [NAME] |  | [PHONE] ext. 227 |  | Oneok |  | Liberal
 | [NAME] |  | [PHONE] |  | Oxy USA |  | Sublette
Spreadsheet: 853262d1703152557-conditional-format-highest-value-in-previous-28-cells-cf-offset
Sheet: WEEKLY CHARTS

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
 |  | Date | TRAYS IN | SUPPS IN | TOTAL IN | TOTAL ITEMS IN | TRAYS OUT | SUPPS OUT | TOTAL OUT | TRAY CONTENTS TOTAL OUT | TOTAL ITEMS OUT | ALL PRIORITIES (Mon - Sun) | % ITEMS GIVEN PRORITY | PRIORITIES <24HRS | % PRIORITIES RETURNED <24HRS (PRIORITIES) | % PRIORITIES RETURNED <24HRS (ALL ITEMS) | DIRTY | DIRTY % | BYPASSED | BYPASSED % | RUSTY | RUSTY % | TOTAL | TOTAL % | TURNAROUND TIME | [NAME] | [NAME] | Booked On | Expected Booked On | Clean Tech | Clean Man Hours | Items Autoclaved | Expected Autoclaved
 |  | 2023-12-18 00:00:00
 |  | +/-
 |  | % Difference
 |  | +/-
 |  | % Difference
 |  | +/-
 |  | % Difference