tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86971d1286904237-count-uniques-countuniques_dependent
Sheet: Formula3

 | ID | State |  |  | Unique IDs | Count of Unique States
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alaska |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alaska |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alaska |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arkansas |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alaska |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alaska |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arkansas |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona
 | [PHONE]-[PHONE] | Arkansas
 | [PHONE]-[PHONE] | American Samoa
 | [PHONE]-[PHONE] | Arizona
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | American Samoa
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | Arizona
 | [PHONE]-[PHONE] | Arkansas
 | [PHONE]-[PHONE] | Alabama
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | Arkansas
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | Arizona
 | [PHONE]-[PHONE] | Arizona
 | [PHONE]-[PHONE] | Arkansas
 | [PHONE]-[PHONE] | Arkansas
Spreadsheet: 57620d1257845404-range-of-numbers-in-single-cell-range
Sheet: Sheet 1 - Table 2

Minimum | Maximum/Equal | Output (Range)
50
10 | 50
5 | 10
1 | 5
0 | 1
 | 0
0.5 | 1
0.2 | 0.5
0.1 | 0.2
0.02 | 0.1
 | 0.02
Spreadsheet: tracy_geaccone__40246__TW-2001&2002
Sheet: TW Ops

 |  | 2002 CAPITAL PLAN
 |  | TRANSWESTERN
 |  |  | Incl AFUDC at % |  | 0.02
 |  |  | Incl 2001 Overhead at % |  | 0.15
 |  |  | Incl 2002 Overhead at % |  | 0.15 |  | Excludes AFUDC / Overhead
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 2002 Plan |  |  | 2003 Plan
Budget |  |  | 2001 |  | 2001 |  | 2001 Adj. |  | 2002 |  | 2002 Plan to |  | Non- |  |  | Non-
Code | Description | Categories | Original Plan |  | 2nd CE |  | 2nd CE |  | Plan |  | 2001 Adj. CE |  | Discretionary | Discretionary |  | Discretionary | Discretionary
 |  | Codes & Safety Compliance Total | 2563 |  | 3009 |  | 2498 |  | 1250 |  |  |  | 1250 | 0 |  | 1250 | 0
 |  | Compression Total | 3240 |  | 2283 |  | 1894 |  | 1549 |  |  |  | 40 | 1509 |  | 40 | 1509
 |  | Corrosion Total | 235 |  | 251 |  | 208 |  | 241 |  |  |  | 241 | 0 |  | 241 | 0
 |  | Environmental Total | 1100 |  | 1055 |  | 876 |  | 2249 |  |  |  | 1996 | 253 |  | 1996 | 253
 |  | IT Capital - Operations Total | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 | 0 |  | 0 | 0
 |  | Maintain Pipeline Total | 92 |  | 82 |  | 68 |  | 218 |  |  |  | 0 | 218 |  | 0 | 218
 |  | Measurement Total | 197 |  | 214 |  | 177 |  | 171 |  |  |  | 0 | 171 |  | 0 | 171
 |  | Pipeline Integrity Total (Excludes Pigging Project) | 690 |  | 1057 |  | 877 |  |  |  |  |  | 0 |  |  | 0 | 12000
 |  | Pipeline Total | 68 |  | 27 |  | 23 |  | 23 |  |  |  | 0 | 23 |  | 0 | 23
 |  | Revenue Enhancement Total | 0 |  | 200 |  | 166 |  | 0 |  |  |  | 0 | 0 |  | 0 | 0
 |  | Sub-Total Projects
 |  | AFUDC Total |  |  |  |  | 134 | 0 | 348 | 0 | 214 | 0 | 69 | 279 | 0 | 66 | 279
 |  | Overheads Total |  |  |  |  | 1018 | 0 | 2678 | 0 | 1660 | 0 | 552 | 2126 | 0 | 529 | 2126
 |  | Total including AFUDC and Overhead
 |  | General Plant Total | 3600 |  | 2920 |  | 2920 |  | 2903 |  | -17 |  | 0 | 2903 |  | 0 | 2903
 |  | Standby Total | 1025 |  | 1033 |  | 1033 |  | 1164 |  | 131 |  | 0 | 1164 |  | 0 | 1164
 |  | Interconnects Total | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0
 |  | Total Operations Capital without AFUDC and Overhead
 |  | Total Operations Capital with AFUDC and Overhead
 |  | Overhauls - Deferred Total | 1605 | 0 | 490 | 0 | 490 | 0 | 2113 | 0 | 1623 | 0 | 0 | 2113 | 0 | 0 | 2113
 |  | Total Operations
 |  | IT Capital |  |  |  |  |  |  |  |  |  |  | 201 | 728
 |  | Total Capital
 |  | 2002 Depreciation on Assets in Sevice in 2001 (assumed in-service date 12/31/01)
 |  | 2002 Depreciation on 2001 Assets in Service in 2002 (assumed in-service date 04/01/02) |  |  |  |  |  |  |  |  |  |  | 0 | 2
 |  | 2002 Depreciation on 2002 Assets in Service in 2002 (assumed in-service date 07/01/02) |  |  |  |  |  |  |  |  |  |  | 26 | 175
 |  | Total Operations 2002 Incremental Depreciation:
2002 CAPITAL SUMMARY |  | Total 2002 IT Incremental Depreciation |  |  |  |  |  |  | 100 |  |  |  | 100 | 0
 |  | Total 2002 Incremental Depreciation:
 |  | *  Excludes Pipeline Pigging Program - $12M per year
Spreadsheet: 03928b0c-5c77-41f1-a4ed-22bbc69a8f70
Sheet: Early

Early Childhood - Lesson Planning
 | Fall 2011 | Sp 2012 | Fall 2012 | Sp 2013 | Fall 2013 | Sp 2014
A list of questions that teachers can use to foster oral language and communication to determine if students understand the concepts being taught | 4.4 | 4.5 | 4.6 | 4.5 | 4..8 | 4.7
Goals, objectives, and assessment should correlate to support early childhood development and learning. | 4.5 | 4.4 | 4.6 | 4.6 | 4.8 | 4.7
Formal and informal daily evaluations, unit evaluation and how the assessments may be used to impact and extend a partnership with the families. | 4.6 | 4.6 | 4.7 | 4.4 | 4.8 | 4.6
Narrative explanation of how special needs will be met | 4.5 | 4.7 | 4.5 | 4.5 | 4.8 | 4.7
Narrative to describe ways in which you plan to inform parents and students of progress in the unit. | 4.4 | 4.5 | 4.8 | 4.6 | 4.5 | 4.5
Primary content area of lessons are; Reading, Language,  and Math. | 4.5 | 4.6 | 4.5 | 4.7 | 4.5 | 4.7
Interdiscipinary Connections | 4.6 | 4.7 | 4.6 | 4.5 | 4.6 | 4.8
Intergration of Technology | 4.5 | 4.5 | 4.5 | 4.6 | 4.5 | 4.7
Lesson Materials and Resources | 4.4 | 4.4 | 4.7 | 4.4 | 4.7 | 4.5
Introductory Activities | 4.5 | 4.8 | 4.5 | 4.5 | 4.5 | 4.4
Learning Activities | 4.7 | 4.5 | 4.6 | 4.6 | 4.6 | 4.7
Higher Level Thinking Skills | 4.6 | 4.6 | 4.5 | 4.7 | 4.5 | 4.8
Relevance / Rationale | 4.8 | 4.4 | 4.6 | 4.8 | 4.8 | 4.5
Accomodations / Modifications | 4.5 | 4.6 | 4.7 | 4.8 | 4.8 | 4.4
Reproducible Materials | 4.4 | 4.5 | 4.5 | 4.7 | 3.8 | 4.1
Spreadsheet: 815819d1675220233-formula-to-sort-a-list-test
Sheet: Sheet1

Name |  |  | Times | Success % |  |  | Name |  |  | Times | Success %
jay |  |  | 1 | 1 |  |  | hector |  |  | 9 | 0.43
[NAME] |  |  | 2 | 1 |  |  | griffin |  |  | 5 | 0.8
karen |  |  | 2 | 1 |  |  | garridee |  |  | 5 | 0.8
bill |  |  | 2 | 1 |  |  | [NAME] |  |  | 4 | 0.75
vasili |  |  | 1 | 1 |  |  | [NAME] |  |  | 3 | 1
[NAME] |  |  | 3 | 1 |  |  | [NAME] |  |  | 3 | 0.6666666666666666
[NAME] |  |  | 1 | 1 |  |  | [NAME] |  |  | 3 | 0.3333333333333333
kyler |  |  | 1 | 1 |  |  | [NAME] |  |  | 2 | 1
yordan |  |  | 2 | 0.5 |  |  | karen |  |  | 2 | 1
ceasar |  |  | 1 | 0 |  |  | bill |  |  | 2 | 1
cezar |  |  | 1 | 1 |  |  | yordan |  |  | 2 | 0.5
will |  |  | 1 | 1 |  |  | gracie |  |  | 2 | 0
[NAME] |  |  | 3 | 0.6666666666666666 |  |  | jay |  |  | 1 | 1
maria |  |  | 1 | 0 |  |  | vasili |  |  | 1 | 1
[NAME] |  |  | 3 | 0.3333333333333333 |  |  | [NAME] |  |  | 1 | 1
[NAME] |  |  | 1 | 1 |  |  | kyler |  |  | 1 | 1
gracie |  |  | 2 | 0 |  |  | cezar |  |  | 1 | 1
griffin |  |  | 5 | 0.8 |  |  | will |  |  | 1 | 1
garridee |  |  | 5 | 0.8 |  |  | [NAME] |  |  | 1 | 1
axel |  |  | 1 | 1 |  |  | axel |  |  | 1 | 1
[NAME] |  |  | 1 | 0 |  |  | ceasar |  |  | 1 | 0
[NAME] |  |  | 4 | 0.75 |  |  | maria |  |  | 1 | 0
hector |  |  | 9 | 0.43 |  |  | [NAME] |  |  | 1 | 0
^What I Have |  |  |  |  |  |  | ^What I Want to Return to Another Page in Workbook
I need a formula (VBA not allowed in my envoronment) to sort the chart on the left first by column D, then by column E to get the chart to look like the one in columns H-L
Spreadsheet: 854194d1704162394-function-to-track-gain-loss-for-weight-bf-bmi-bone-mass-etc-body-measurement-tracker
Sheet: Sheet1 (2)

DATE | WEIGHT | BF % | MUSCLE % | PROTEIN MASS lbs | B M I | BONE MASS lbs | VISCERAL INDEX | FAT MASS | METABOLIC AGE
2024-01-01 00:00:00 | 190.5 | 30.8 | 65.5 | 28.4 | 27.6 | 7.1 | 9 | 58.6 | 59
2024-01-15 00:00:00
2024-02-01 00:00:00
2024-02-15 00:00:00
2024-03-01 00:00:00
2024-03-15 00:00:00
2024-04-01 00:00:00
GOAL | 155 | 0.23 | <70 | <45 | <22 | >5.7 | 9 | <55 | <55
DIFFERENCE
^^^^^Enter formulas here w/red as a loss in weight and black for a gain, using the start weight at 01/01/2024 as the constant.^^^^^
Spreadsheet: 94268d1294135292-automatic-number-and-date-sorting-formula-number_n_category_answer_done-sorting-output-donkeyv2
Sheet: Output

BA Number |  | Account Number |  | Supplier
687921
 |  | REPORT TEMPLATE
Date | : | 2011-01-04 00:00:00
SUPPLIER | : | Supplier Company name
Dear Sir,
Kindly be informed of our Banker Acceptance (BA) for payment to our supplier.
Your immediate action is required.
OUR REF | : | BA 801102
DATE | : | 2010-11-29 00:00:00
SUPPLIER | : | Supplier Company name
BANK AC | : | SupplierBank
BANK ACC # | : | SuppBankAcc9558
BA period | : | 120 Days
INVOICE DATE |  |  | INVOICE NO |  | AMOUNT (RM)
2010-11-06 00:00:00 |  |  | 20923 RI
2010-11-09 00:00:00 |  |  | 20925 RI
2010-11-12 00:00:00 |  |  | 20928 RI
2010-11-15 00:00:00 |  |  | 20935 RI
 |  |  |  | Total (RM) :
Thank you.
With regards,
Spreadsheet: 356707d1415190380-extract-and-sum-test
Sheet: Sheet1

 | No | Late | Week 1 | Week 2
 | 1
 | 2 | FS266893-05 : 29-10-2014 : 25;
 | 3
 | 4 |  | FS267437-03 : 100; FS267438-05 : 125; | FS267876-04 : 150;
 | 5 |  | FS267437-04 : 200; | FS268169-05 : 200;
 | 6 |  | FS267437-03 : 100; FS267438-05 : 125; FS268169-10 : 25; | FS268169-10 : 25;
 | 7
 | 8 | FS266544-03 : 22-10-2014 : 25; |  | FS268670-03 : 25;
 |  | DESIRED RESULT
 | No | Late | Week 1 | Week 2
 | 1
 | 2 | 25
 | 3
 | 4 |  | 225 | 150
 | 5 |  | 200 | 200
 | 6 |  | 250 | 25
 | 7
 | 8 | 25 |  | 25
Spreadsheet: 717381d1612624160-rota-in-excel-formula-for-creating-daily-overview-based-on-shifts-times-weekly-rota-master-calculator
Sheet: Daily

2021-02-01 00:00:00 | 08-16D | SPA | 14-23L | NIGHT
1
2
3
4
5
6
7
8
9
10
A1 | Blank
E1 to X1 | Dr Name
A2 | Date
B2 | Day
D | Blank
E2 to X2 | Shifts
E2 to P2 | This rota
CC rota | Rota
Spreadsheet: 113526d1309401146-large-small-index-match-formula-combos-topbottom5
Sheet: Formulas

Top 5 Rising Keywords
Position Increase | Keyword | Position | Search Engine
Display highest number (or largest position increase) for only URL type primary | Display corresponding row record - keyword | Display corresponding row record - position | Display corresponding row record - search engine
Top 5 Falling Keywords
Position Decrease | Keyword | Position | Search Engine
Display lowest number (or largest position decrease) for only URL type primary | Display corresponding row record - keyword | Display corresponding row record - position | Display corresponding row record - search engine
Spreadsheet: michelle_lokay__26832__Oct00pnr
Sheet: Summary

Transwestern Pipeline Company
Park n Ride Service
Actual Billing Summary
Billing Month | Buyer | Purchase Order # | Contract | POI | Volume | Rate | Imputed Rate | Rate_Type Daily/Total | Invoice Amount
2000-10-01 00:00:00 | PNM Gas Services | 27267 | 25672 | 500617 | 40000 | 0.05 |  | D | 6300 | No charge for Oct. 31st due to rail accident
 | Richardson Products | 27249 | 26954 | 500622 | 18000 | 0.03 |  | D | 940.02
 | Duke Energy Trading | 27266 | 27108 | 500622 | 25000 | 0.05 |  | D | 3750
 | USGT | 27268 | 25556 | 500622 | 40000 | 0.05 |  | D | 3544.35
 |  |  |  | TOTAL
Spreadsheet: 34932d1232390524-recognizing-counting-and-displaying-duplicates-gymmembernumbers
Sheet: Weekly Data

Gym Member Appointment No-shows
Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3
2009-02-02 00:00:00 | 2009-02-03 00:00:00 | 2009-02-04 00:00:00 | 2009-02-05 00:00:00 | 2009-02-06 00:00:00 | 2009-02-07 00:00:00 | 2009-02-08 00:00:00 | 2009-02-02 00:00:00 | 2009-02-03 00:00:00 | 2009-02-04 00:00:00 | 2009-02-05 00:00:00 | 2009-02-06 00:00:00 | 2009-02-07 00:00:00 | 2009-02-08 00:00:00 | 2009-02-02 00:00:00 | 2009-02-03 00:00:00 | 2009-02-04 00:00:00 | 2009-02-05 00:00:00 | 2009-02-06 00:00:00 | 2009-02-07 00:00:00 | 2009-02-08 00:00:00
1531 | 154 | 1514 | 154 | 1531 | 154 | 1531 | 1531 | 154 | 1514 | 154 | 1531 | 154 | 1531 | 1531 | 154 | 1514 | 154 | 1531 | 154 | 1531
151 | 354 | 248 | 354 | 151 | 354 | 151 | 151 | 354 | 248 | 354 | 151 | 354 | 151 | 151 | 354 | 248 | 354 | 151 | 354 | 151
235 | 236 | 235 | 236 | 235 | 236 | 235 | 235 | 236 | 235 | 236 | 235 | 236 | 235 | 235 | 236 | 235 | 236 | 235 | 236 | 235
1584 | 1585 | 1584 | 1585 | 1584 | 1585 | 1584 | 1584 | 1585 | 1584 | 1585 | 1584 | 1585 | 1584 | 1584 | 1585 | 1584 | 1585 | 1584 | 1585 | 1584
1835 | 1837 | 1843 | 1837 | 1835 | 1837 | 1835 | 1835 | 1837 | 1843 | 1837 | 1835 | 1837 | 1835 | 1835 | 1837 | 1843 | 1837 | 1835 | 1837 | 1835
1864 | 1846 | 8484 | 1846 | 1864 | 1846 | 1864 | 1864 | 1846 | 8484 | 1846 | 1864 | 1846 | 1864 | 1864 | 1846 | 8484 | 1846 | 1864 | 1846 | 1864
8484 | 2183 | 1864 | 2183 | 8484 | 2183 | 8484 | 8484 | 2183 | 1864 | 2183 | 8484 | 2183 | 8484 | 8484 | 2183 | 1864 | 2183 | 8484 | 2183 | 8484
6843 | 2481 | 1835 | 2481 | 6843 | 2481 | 6843 | 6843 | 2481 | 1835 | 2481 | 6843 | 2481 | 6843 | 6843 | 2481 | 1835 | 2481 | 6843 | 2481 | 6843
1843 | 1848 | 1843 | 1848 | 1843 | 1848 | 1843 | 1843 | 1848 | 1843 | 1848 | 1843 | 1848 | 1843 | 1843 | 1848 | 1843 | 1848 | 1843 | 1848 | 1843
1834 | 3544 | 235 | 3544 | 1834 | 3544 | 1834 | 1834 | 3544 | 235 | 3544 | 1834 | 3544 | 1834 | 1834 | 3544 | 235 | 3544 | 1834 | 3544 | 1834
248 | 4842 | 151 | 4842 | 248 | 4842 | 248 | 248 | 4842 | 151 | 4842 | 248 | 4842 | 248 | 248 | 4842 | 151 | 4842 | 248 | 4842 | 248
1514 | 2468 | 1531 | 2468 | 1514 | 2468 | 1514 | 1514 | 2468 | 1531 | 2468 | 1514 | 2468 | 1514 | 1514 | 2468 | 1531 | 2468 | 1514 | 2468 | 1514
Spreadsheet: 544375d1508872172-conditionally-summing-across-a-varying-number-of-worksheets-copy-of-example-book-allisonns-
Sheet: 3

Stock = | Stock 3 |  |  |  |  | Type = | Fund Type
Date |  | Event |  | Units |  | Transaction amount |  |  | Year
2015-01-01 00:00:00 |  | Buy |  | 5689 |  | 20000
2015-01-20 00:00:00 |  | Dividend |  | 0 |  | 300
2015-05-01 00:00:00 |  | Buy |  | 652 |  | 685
2015-03-20 00:00:00 |  | Dividend |  | 0 |  | 310
2015-04-20 00:00:00 |  | Dividend |  | 0 |  | 310
2016-05-02 00:00:00 |  | Sell |  | 2844 |  | 10248
2016-05-20 00:00:00 |  | Dividend |  | 0 |  | 160
2016-06-20 00:00:00 |  | Dividend |  | 0 |  | 160
2016-07-20 00:00:00 |  | Dividend |  | 0 |  | 160
2016-08-05 00:00:00 |  | Sell |  | 2845 |  | 10248
2016-08-20 00:00:00 |  | Dividend |  | 0 |  | 40
2016-09-20 00:00:00 |  | Dividend |  | 0 |  | 40
2016-10-20 00:00:00 |  | Dividend |  | 0 |  | 40
2016-11-20 00:00:00 |  | Dividend |  | 0 |  | 40
2016-12-20 00:00:00 |  | Dividend |  | 0 |  | 40
Spreadsheet: 708936d1608102304-combine-data-feom-2-rows-in-2-comlumns-into-one-row-and-column-d-and-p-ans2
Sheet: Apr

name | bol date | am/pm | d/p |  |  | total
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7
[NAME] | 2020-04-05 00:00:00 | am | p
Spreadsheet: 738377d1624992521-vlookup-to-retrieve-specific-sub-cell-value-pricing
Sheet: Product

Merged |  |  |  | Duration
Product | Color | Type | Offer
ABC | Green | Casual | List price | 7.49
 |  |  | [NAME] | 1
 |  |  | Price after revert | 6.49
ABCD | Blue | Casual | List price | 8.49
 |  |  | [NAME] | 1
 |  |  | Price after revert | 7.49
ABCDE | Yellow | Casual | List price | 7.49
 |  |  | [NAME] | 1
 |  |  | Price after revert | 6.49
ABCDEF | Orange | Formal | List price | 10.49
 |  |  | [NAME] | 1
 |  |  | Price after revert | 9.49
ABCDEFG | red | Casual | List price | 13.49
 |  |  | [NAME] | 1
 |  |  | Price after revert | 12.49
Spreadsheet: 703612d1605085200-extract-cell-by-reference-to-adjacent-cell-values-excel-example
Sheet: Sheet1

Project | Description | Value | Prospect | Origination | Status | Action | Updated |  |  | Prospect
Test 1 | Example | 10 | 👍 Won | TG | xx | yy | 2020-09-10 00:00:00 |  |  |  |  |  | Stale Prospects
Test 2 | Example | 20 | 🔥 Hot | TG | xx | yy | 2020-01-01 00:00:00 |  |  | 👍 Won |  |  | Project | Updated
Test 3 | Example | 30 | ☠ Dead | TG | xx | yy | 2020-02-03 00:00:00 |  |  | ☠ Dead
Test 4 | Example | 40 | ☠ Dead | TG | xx | yy | 2020-10-10 00:00:00 |  |  | ❄ Cold
Test 5 | Example | 50 | [NAME]/DPS | TG | xx | yy | 2020-03-01 00:00:00 |  |  | ♨ Warm
Test 6 | Example | 60 | 👍 Won | AM | xx | yy | 2020-06-27 00:00:00 |  |  | 🔥 Hot
Test 7 | Example | 70 | ❄ Cold | RG | xx | yy | 2020-07-08 00:00:00 |  |  | [NAME]/DPS
Test 8 | Example | 26 | 🔥 Hot | TG | xx | yy | 2020-08-09 00:00:00
Test 9 | Example | 22 | 👍 Won | TG | xx | yy | 2020-04-21 00:00:00
Test 10 | Example | 31 | ❄ Cold | TG | xx | yy | 1981-01-08 00:00:00
Test 11 | Example | 1 | ❄ Cold | TG | xx | yy | 1997-07-08 00:00:00
Test 12 | Example | 34 | 👍 Won | TG | xx | yy | 2018-12-27 00:00:00
Test 13 | Example | 100 | [NAME]/DPS | TG | xx | yy | 2004-01-01 00:00:00
Test 14 | Example | 2 | ☠ Dead | TG | xx | yy | 1990-05-01 00:00:00
Spreadsheet: 731012d1620117713-conditional-max-and-rank-of-18-digit-text-numbers-using-dynamic-array-formulas-maxifs
Sheet: MAXIFS

Category | Numbers to be ranked | Last 15 digits from numbers to be run through MAXIFS and RANKIFS | MAXIFS | RANKIFS
15022505 | 100000000000421730 |  |  |  |  |  | 1. Numbers (in text format) to be run through MAXIFS and RANKIFS consist of 18 digits, but Excel only keeps the 15 first digits, while turning the rest into zeroes except when the string is kept as text format.
15022505 | 100000000000421731 | 421731 | 421734 |  | 1 |  | 2. A formula to output a dynamic array with the results seen in column E is needed, and without the use of helper columns C and D.
15022505 | 100000000000421731 | 421731 | 421734 |  | 1 |  | 3. LET function not yet available.
15022505 | 100000000000421731 | 421731 | 421734 |  | 1
15022505 | 100000000000421732 | 421732 | 421734 |  | 1
15022505 | 100000000000421732 | 421732 | 421734 |  | 1
15022505 | 100000000000421732 | 421732 | 421734 |  | 1
15022505 | 100000000000421733 | 421733 | 421734 |  | 1
15022505 | 100000000000421733 | 421733 | 421734 |  | 1
15022505 | 100000000000421733 | 421733 | 421734 |  | 1
15022505 | 100000000000421734 | 421734 | 421734 |  | 1
15022505 | 100000000000421734 | 421734 | 421734 |  | 1
15022505 | 100000000000421734 | 421734 | 421734 |  | 1
15022507 | 100000000000421864 | 421864 | 421869 |  | 2
15022507 | 100000000000421865 | 421865 | 421869 |  | 2
15022507 | 100000000000421865 | 421865 | 421869 |  | 2
15022507 | 100000000000421865 | 421865 | 421869 |  | 2
15022507 | 100000000000421866 | 421866 | 421869 |  | 2
15022507 | 100000000000421866 | 421866 | 421869 |  | 2
15022507 | 100000000000421866 | 421866 | 421869 |  | 2
15022507 | 100000000000421866 | 421866 | 421869 |  | 2
15022507 | 100000000000421867 | 421867 | 421869 |  | 2
15022507 | 100000000000421867 | 421867 | 421869 |  | 2
15022507 | 100000000000421867 | 421867 | 421869 |  | 2
15022507 | 100000000000421867 | 421867 | 421869 |  | 2
15022507 | 100000000000421868 | 421868 | 421869 |  | 2
15022507 | 100000000000421868 | 421868 | 421869 |  | 2
15022507 | 100000000000421868 | 421868 | 421869 |  | 2
15022507 | 100000000000421868 | 421868 | 421869 |  | 2
15022507 | 100000000000421869 | 421869 | 421869 |  | 2
15022507 | 100000000000421869 | 421869 | 421869 |  | 2
15022507 | 100000000000421869 | 421869 | 421869 |  | 2
Spreadsheet: 96627d1295982382-data-massage-problem
Sheet: Bad Data

First Name | [NAME] | City | Pleasantville
Last name | Doe | State | FL
Address | 1122 Nice Street | Zip | 00000
First Name | [NAME] | City | Pleasantville
Last name | Jones | State | FL
Address | 1122 Nice Street | Zip | 00000
First Name | [NAME] | City | Pleasantville
Last name | Guns | State | FL
Address | 21 Jump Street | Zip | 00000
Spreadsheet: 677169d1589224921-using-xlookup-vlookup-formula-into-a-validated-cell-to-return-a-value-into-that-cell-validation-vlookup
Sheet: Validated

 | UKMOB (11 digits)
[NAME]
[NAME]
carrie
[NAME]
esther
fred
greg
[NAME]
ian
[NAME]
[NAME]
lily
[NAME]
[NAME]
olivee
[NAME]
quentin
[NAME]
[NAME]
Spreadsheet: 164576d1340811888-cell-in-1-sheet-to-refer-to-string-in-another-and-use-row-information-to-calc-help-fulldailymold-copy
Sheet: Disa 1

Date:  _______________ |  |  |  | DAILY MODLING PRODUCTION |  |  |  |  | PAGE: |  | OF
EMP.NO: |  |  | NAME: |  |  |  | SHIFT: |  | WORK CTR: |  | MACH.NO: | 4000
START TIME | END TIME | OPER. NO. | PATTERN NO. | MOLDS MADE | MOLDS DESTROYED | MOLDS CLOSED | PART NO. | M.O. | PART RATE | IMP | PCS. MADE | DOWNTIME  (MINS) | CORED (Y/N)
20:00:00 | 20:10:00 | 5040
21:00:00 | 21:30:00 | 5040