tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 854345d1704266627-copying-data-from-one-sheet-to-another-based-on-matching-year-cash
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | [NAME] | 45/1939 | 16500 | 16500 | 16500 | 16500 | 16500 | 16500 | 16500 | 16500 | 16500 | 18150
 | MAJOR | 45/1945 |  | 16500 | 16500 | 16500 | 16500 | 16500 | 16500 | 16500 | 16500 | 18150 | 18150 | 18150
 | GLOBAL GF | 45/1943
 | GLOBAL 1 | 45/1942
 | GLOBAL 2 | 45/1946
 | GLOBAL 3 | 45/1938
 | CAPITAL MALL | 45/1941
Spreadsheet: 5cee5e33-648a-4685-9565-52a118341160
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
BGABS | Test | BGABS | Beta-Galactosidase, Blood Spot | Beta-Galactosidase, BS | Fluorometric Enzyme Assay | Whatman filter paper: WFP |  |  | 2 | Blood spots | Container/Tube:  Preferred: Whatman Protein Saver 903 Paper Acceptable: Ahlstrom 226 filter paper, Supplemental Newborn Screening Card (Supply T493)  [NAME]: 2 blood spots Collection Instructions:  1. An alternative blood collection option for a patient >1 year of age is fingerstick. 2. Let blood dry on the filter paper at ambient temperature in a horizontal position for 3 hours.  3. Do not expose specimen to heat or direct sunlight. 4. Do not stack wet specimens. 5. Keep specimen dry. Additional Information: Provide a reason for referral with each specimen. Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | Blood spot: 1 | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Blood spot specimen that shows serum rings or has multiple layers | > or =5.0 nmol/h/mL An interpretive report will be provided. | Friday; morning | 8 days | 15 days | 1 | 82657 |  |  |  |  | Rochester
BGABS | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 28 days
BGABS | Result | 60986 | Beta-Galactosidase, BS | Beta-Galactosidase, BS | Numeric |  |  |  |  | nmol/h/mL |  |  |  |  |  |  |  |  |  | 55916-1 | Beta galactosidase:CCnc:Pt:Bld.dot:Qn:
BGABS | Result | 34430 | Interpretation | Interpretation | Alphanumeric
BGABS | Result | 34429 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
BGABS | Result | 34431 | Reviewed By | Reviewed By | Numeric
Spreadsheet: 117735d1312994273-substitute-lookup-isnumber-help-schedule_example
Sheet: Sheet1

RAW DATA
LV1 |  |  | 1 | 0000-00-00 | 105-C | 0 | HR | 105-C | 0
LV3 |  |  | 1 | 0000-00-00 | 120-3 | 0 | LV2 | 120-3 | 0
LV2 |  |  | 1 | 0000-00-00 | 80-N | 0 | PE1 | 80-N | 0
LV1 |  |  | 1 | 0000-00-00 | 90-N | 0 | PE1 | 90-N | 0
LV5 |  |  | 1 | 0000-00-00 | 105-4 | 0 | AB2 | 105-4 | 0
LV3 |  |  | 1 | 0000-00-00 | 105-3 | 0 | PD2 | 105-3 | 0
LV4 |  |  | 1 | 0000-00-00 | 105-4 | 0 | [NAME] | 105-4 | 0
LV |  |  | 1 | 0000-00-00 | 135 | 0 | BR | 135 | 0
MANIPULATED FINAL DATA
LV |  |  | 1 | 0000-00-00 | 105#1 | 0 | HR | 105#1 | 0
LV |  |  | 1 | 0000-00-00 | 120#3 | 0 | LV2 | 120#2 | 0
LV |  |  | 1 | 0000-00-00 | 80#2 | 0 | PE1 | 80#1 | 0
LV |  |  | 1 | 0000-00-00 | 90#1 | 0 | PE1 | 90#1 | 0
LV |  |  | 1 | 0000-00-00 | 105#5 | 0 | AB2 | 105#2 | 0
LV |  |  | 1 | 0000-00-00 | 105#3 | 0 | PD2 | 105#2 | 0
LV |  |  | 1 | 0000-00-00 | 105#4 | 0 | [NAME] | 105#2 | 0
LV |  |  |  |  | 105#1 |  | HR | 105#1
LV |  |  |  |  | 120#3 |  | LV | 120#2
LV |  |  |  |  | 80#2 |  | PE | 80#1
LV |  |  |  |  | 90#1 |  | PE | 90#1
LV |  |  |  |  | 105#5 |  | AB | 105#2
LV |  |  |  |  | 105#3 |  | PD | 105#2
LV |  |  |  |  | 105#4 |  | LP | 105#2
LV |  |  |  |  | #N/A |  | BR | #N/A
Spreadsheet: 138240d1327582389-help-with-min-max-formula-copy-of-vsum-min-max-1
Sheet: Sheet2

Budget line | Max PO Value | Min PO Value | Mode |  |  | SUMIF…………..
1005 | 0 | 0 | 0 |  |  | 1005 | 0
1006 | 0 | 0 | 0 |  |  | 1006 | 0
1010 | 4623612.23 | 37.5 | 0 |  |  | 1010 | 4743249.390000001
1018 | 0 | 0 | 0 |  |  | 1018 | 0
1022 | 699983.81 | 0 | 0 |  |  | 1022 | 1680852.87
1028 | 0 | 0 | 0 |  |  | 1028 | 0
1034 | 253711.54 | 16.9 | 0 |  |  | 1034 | 291652.38
1042 | 0 | 0 | 0 |  |  | 1042 | 0
Spreadsheet: 91422d1291150741-making-a-suffix-from-variables-example1
Sheet: Sheet1

EQUIPMENT_FC | EQUIPMENT_ID | INITIAL_POS | DESIRED_POS | Needs to be
00000B9999:OFF:OFF | 00000B9999 | OFF | OFF | 00000B9999-FTSP | 00000B9999-FTRD
00000B9999:ON:OFF | 00000B9999 | ON | OFF | 00000B9999-FTSP | 00000B9999-FTSP
00000B9999:AVAILABLE:AVAILABLE | 00000B9999 | AVAILABLE | AVAILABLE | 00000B9999-FTRA | 00000B9999-FTRA
00000B9999:ON/STANDBY:ON | 00000B9999 | On/Standby | ON | 00000B9999-FTR | 00000B9999-FTRE
00000B9999:CLOSED: OPEN | 00000B9999 | CLOSED | OPEN | 00000B9999-FTO | 00000B9999-FTO
00000B9999 OPEN: CLOSED | 00000B9999 | OPEN | CLOSED | 00000B9999-FTC | 00000B9999-FTC
00000B9999 ENERGIZED: DEENERGIZED | 00000B9999 | ENERGIZED | DEENERGIZED | 00000B9999-FTDE | 00000B9999-?
00000B9999 OPEN: OPEN | 00000B9999 | OPEN | OPEN | 00000B9999-FTRO | 00000B9999-FTRO
00000B9999 CLOSED: CLOSED | 00000B9999 | CLOSED | CLOSED | 00000B9999-FTRC | 00000B9999-FTRC
Spreadsheet: frank_ermis__11206__HS_WESTminusPA1115
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEST NATURAL GAS FIN IDX POSITIONS
 | West Region Basis Notional
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1Y |  | 2Y |  | 3Y |  | 4Y |  | 5Y |  | 6Y
 | West Region Basis Notional
 | NGI-PGE/CG |  |  |  | NGI-PGE/CG |  | GDP-PG&E/CITIGA | NGI-PGE/CG | GDP-PG&E/LG-PKG |  |  |  | M | D
 | NGI-MALIN |  |  |  | NGI-MALIN |  | GDP-MALIN-CTYGA | NGI-MALIN |  |  |  |  | M | D
 | NGI-SOCAL |  |  |  | NGI-SOCAL | IF-SOCAL | GDP-CAL BORDER | NGI-SOCAL |  |  |  |  | M | D
 | TOPOCK |  |  |  | NGI-SOBDR-PG&E |  | NGI-SOBDR-PG&E |  |  |  |  |  | M | D
 | NWPL-ROCKIES |  |  | NW-STANFIELD | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-WYOMING | GDP-KERN/OPAL | GDP-NW STANFIEL | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-NWPL_ROCKYM | M | D
 | CIG-ROCKIES | IF-CIG/WINDRVR | IF-CIG/WIC | IF-CIG/RKYMTN | IF-CIG/SOUTHERN | IF-CIG/GLENROCK | IF-CIG/ROCKPORT | GDP-CIG/RKYMTN | GDP-CIG/CHEYENN | IM-CIG/SOUTHERN | IM_WINDRIVER |  | M | D
 | PERMIAN |  | IF-TW/PERMIAN |  | IF-ELPO/PERMIAN | IF-NNG/TOK | GDP-ELPO/PERM2 | IF-ELPO/PERMIAN | IF-TW/PERMIAN |  |  |  | M | D
 | SAN JUAN |  | IF-BONDAD(100%) | IF-ELPO/SJ | IF-EPSJ(BONDAD) |  | GDP-ELPO/SANJUA |  | IM-TW/SJ | IF-EPSJ(BONDAD) |  |  | M | D
 | KINGSGATE |  |  |  | CGPR-KINGSGATE |  | CGPR-KINGSGATE |  |  |  |  |  | M | D
 | WAHA |  |  |  | IF-WAHA-TX | IF-WAHA | WAHA KCBT | GDP-WAHA |  |  |  |  | M | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | SUMAS |  |  |  | IF-NTHWST/CANBR |  | SUMAS-US/IM | GDP-NTHWST/CANB | IF-NTHWST/CANBR |  |  |  | m | D
 | AECO/EMPRESS/STA2 |  |  |  | CGPR-AECO/BASIS |  | GD-CGPR-AECO/AV | GD-AECOCD/FRWKD | GD-AECOUS/FRWKD | [NAME] | GDP-AECO |  | m | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | p
 | West Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 |  |  |  |  |  | Apr-02/Oct-02 |  | Nov-02/Mar-03 |  | Apr-03/Mar-29
 | CALIFORNIA
 | Socal
 | PG&E CTYG & TOPOCK
 | Malin
 | NorthWest
 | Sumas
 | Aeco & Kingsgate
 | Rockies (NW & CIG)
 | SouthWest
 | San Juan
 | Permian
 | Waha
Spreadsheet: 674505d1587886331-excel-large-data-to-summary-table-example
Sheet: Result

Length |  | Type
Start | End
0 | 900 | B
 | 2600 | A |  | Start and End to come in table for each type
 | 9600 | E
 | 9620 | C
 | 9640 | B
 | 10150 | A
 | 12590 | E
 | 50780
Spreadsheet: 82762d1282777169-connect-two-columns-together-riskregistertest
Sheet: List

Impact | Likelihood | Severity | Resolution Plan Effectiveness | Occur |  |  | Risk Cat | Technical | Operational | Organizational | External Factors
Select … | Select … | Select … | Select … | Select … | Select … | Select … | Select … | Select … | Select … | Select … | Select …
H | H | H | H | January | 1 | 2010 | Technical | Parts Discontinued | Sponsor/User Scope Changes | Senior Staff Change | Environmental Issues
M | M | M | M | February | 2 | 2011 | Operational | Software Maintenance | Project Management / Scheduling | Inappropriate or lack of organizational structure | Design Standards
L | L | L | L | March | 3 | 2012 | Organizational | Lack Of enough Tools | [NAME] | Lack Of Coordination | Site Location
 |  |  |  | April | 4 | 2013 | External Factors | [NAME] | Safety | Lack of skilled Personnel | Pricing
 |  |  |  | May | 5 | 2014 |  | [NAME] | Cost/Availability Of New Tools | Labor Shortage | Economics
 |  |  |  | June | 6 | 2015 |  | Lack Of access | [NAME]  scope are not clear | Labor Productivity | Demand including Customer rejection
 |  |  |  | July | 7 | 2016 |  |  | Lack Of efficiency |  | Competition
 |  |  |  | August | 8 | 2017 |  |  | Lack of appropriate policies or procedures |  | Special Requirement( Wheel Chair)
 |  |  |  | September | 9 | 2018 |  |  |  |  | Accident
 |  |  |  | October | 10 | 2019
 |  |  |  | November | 11 | 2020
 |  |  |  | December | 12 | 2021
 |  |  |  |  | 13 | 2022
 |  |  |  |  | 14 | 2023
 |  |  |  |  | 15 | 2024
 |  |  |  |  | 16 | 2025
 |  |  |  |  | 17 | 2026
 |  |  |  |  | 18 | 2027
 |  |  |  |  | 19 | 2028
 |  |  |  |  | 20 | 2029
 |  |  |  |  | 21 | 2030
 |  |  |  |  | 22 | 2031
 |  |  |  |  | 23 | 2032
 |  |  |  |  | 24 | 2033
 |  |  |  |  | 25 | 2034
 |  |  |  |  | 26 | 2035
 |  |  |  |  | 27 | 2036
 |  |  |  |  | 28 | 2037
 |  |  |  |  | 29 | 2038
 |  |  |  |  | 30 | 2039
 |  |  |  |  | 31 | 2040
Spreadsheet: 160088d1338968331-excel-2007-chart-to-update-automatically-by-macro-to-next-cell-every-day-chart-to-update-automatically
Sheet: Sheet1

Days | 2012-01-06 00:00:00 | 2012-02-06 00:00:00 | 2012-03-06 00:00:00 | 2012-04-06 00:00:00 | 2012-05-06 00:00:00 | 2012-06-06 00:00:00 | 2012-07-06 00:00:00 | 2012-08-06 00:00:00 | 2012-09-06 00:00:00 | 2012-10-06 00:00:00 | 2012-11-06 00:00:00 | 2012-12-06 00:00:00
IDS | 1 | 4 | 6 | 6 | 7 | 8 | 9 | 19 | 11 | 18 | 11 | 14
IIM | 8 | 9 | 10 | 11 | 34 | 9
IED | 38 | 58 | 78 | 99 | 40 | 50
FNE | 11 | 34 | 45 | 56 | 67 | 11 | 7 | 8 | 11 | 12 | 14 | 18
Spreadsheet: 855348d1704950146-find-value-return-sheet-colum-and-row-name-searchexample_excelforum
Sheet: Sheet1

 | A | B | C | D | E | F | G | H | I | J
1 | 1394 | 1548 | 1540 | 2027 | 2807 | 9129 | 9720 | 8057 | 5268 | 5864
2 | 6410 | 5642 | 6548 | 1618 | 3468 | 9258 | 1943 | 4804 | 2233 | 4759
3 | 5570 | 1141 | 1379 | 7683 | 5485 | 4609 | 8181 | 4194 | 2512 | 2243
4 | 6608 | 3309 | 5170 | 2002 | 7981 | 9131 | 7645 | 7429 | 8482 | 3373
5 | 3299 | 3395 | 5297 | 5794 | 7227 | 6288 | 3578 | 3539 | 7193 | 4961
6 | 5662 | 7866 | 6939 | 4337 | 6956 | 2949 | 1913 | 7661 | 2944 | 9145
7 | 8404 | 8227 | 1355 | 6204 | 5354 | 4565 | 1299 | 6897 | 4825 | 9066
8 | 7628 | 4159 | 8063 | 2220 | 6649 | 8648 | 1318 | 5853 | 3164 | 6986
9 | 6459 | 7984 | 1266 | 1456 | 9911 | 5641 | 7048 | 9940 | 6047 | 1543
10 | 5191 | 8792 | 7022 | 8174 | 7685 | 9845 | 8537 | 4893 | 4564 | 7931
 |  |  |  | Look for… | 6649 |  |  |  |  | Blue = formula goes here!
 |  |  |  | Look for… | 549 |  |  |  |  | Yellow = Enter search term here!
Spreadsheet: 145441d1331581677-put-information-on-next-row-skipping-spaces-example
Sheet: Input

ID | Step | Seconds | Used?
1 | Step 1 | 4 | Yes
2 | Step 2 | 6 | No
3 | Step 3 | 1 | No
4 | Step 4 | 3 | Yes
5 | Step 5 | 8 | Yes
Spreadsheet: 43999d1242665561-need-formula-help-converting-military-time-in-time-card-abc-timecard
Sheet: NOVEMBER

 | NAME: | xxx |  |  |  | EMPLOYEE #: |  | xxx |  | MONTH/YR: | 2009-11-01 00:00:00
 | Day | Date | Time In | Time Out | Time In | Time Out | REG HRS | Trng Hours | OT Hours | OT PAY | Comp Time | VAC Used | SICK Used | COMP Used | Sub
OCT
 | Sun | 25 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 26 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 27 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 28 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 29 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 30 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 31 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
NOV |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Sun | 1 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 2 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 3 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 4 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 5 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 6 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 7 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 8 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 9 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 10 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 11 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 12 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 13 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 14 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 15 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 16 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 17 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 18 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 19 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 20 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 21 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 22 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 23 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 24 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | TOTALS: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | OT Pay | C | V | S | CU
NOTES: |  |  |  |  |  |  |  |  |  | Vac |  | Sick |  | Comp
 |  |  |  |  |  |  |  |  | Balance Forward | 60 |  | 120 |  | 0
 |  |  |  |  |  |  |  |  | Used this month | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  | Accumulated |  |  |  |  | 0 |  | *
 |  |  |  |  |  |  |  |  | New Balance Forward | 60 |  | 120 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *this # includes time & a half
 |  |  |  |  |  |  |  | I CERTIFY THAT THE ABOVE HOURS ARE CORRECT.
Personal Day Off |  |  |  |  |  |  |  | EMPLOYEE: |  |  |  |  | DATE:
Initial for Pay ________ |  |  |  |  |  |  |  | SUPERVISOR: |  |  |  |  | DATE:
Spreadsheet: 779537d1651845509-pull-sizes-from-line-of-copy-pull-out-sizes-aligw
Sheet: Sheet1

10 Pt Pro FBB Brt C1S 52-3/4 x 47-3/4; 647 MWT |  |  |  |  |  |  |  |  |  |  | 47.75
10 Pt Pro FBB Brt C1S 38-1/2 x 46-3/4; 461 MWT |  |  |  |  |  |  |  |  |  |  | 46.75
10 Pt Pro FBB Brt C1S 37-3/4 x 50-1/2; 489 MWT |  |  |  |  |  |  |  |  |  |  | 50.5
10 Pt Pro FBB Brt C1S 47-1/4 x 39-1/4; 475 MWT |  |  |  |  |  |  |  |  |  |  | 39.25
10 Pt Pro FBB Brt C1S 49-1/4 x 47-1/4; 596 MWT |  |  |  |  |  |  |  |  |  |  | 47.25
10 Pt Pro FBB Brt C1S 48-1/4 x 52-1/2; 651 MWT |  |  |  |  |  |  |  |  |  |  | 52.5
10 Pt Pro FBB Bright C1S 31-3/4 x 62" - (506 MWT) |  |  |  |  |  |  |  |  |  |  | 62
10 Pt Pro FBB Brt C1S 48-1/4 x 52-1/2; 651 MWT |  |  |  |  |  |  |  |  |  |  | 52.5
10 Pt Pro FBB Brt C1S 36-1/2 x 38-1/2 360 MWT |  |  |  |  |  |  |  |  |  |  | 38.5
10 Pt Pro FBB Brt C1S 44-1/2 x 35-1/2 Short Grain 405MWT |  |  |  |  |  |  |  |  |  |  | 35.5
10 Pt Pro FBB Brt C1S 25-1/4 x 38 246MWT |  |  |  |  |  |  |  |  |  |  | 38
10 Pt Pro FBB Brt C1S 27 x 38-1/2 266MWT |  |  |  |  |  |  |  |  |  |  | 38.5
Spreadsheet: 871796d1718206445-dashboard-without-pivot-tables-only-formula-and-functions-dummy_data
Sheet: progression

1. Settings
2. Tasks
3. Activity Tracker
5. [NAME] |  |  | AHT
 |  |  | Advisor | P06W1 | P06W2 | P06W3 | P06W4 | P07W1 | P07W2 | P07W3 | P07W4 | P07W5 | P08W1 | P08W2 | P08W3 | P08W4 | P09W1
 |  |  | Aston Bran
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  | ID | 0 |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | AVG
 |  | 1 |  |  |  | 592 | 511 | 566 | 542 | 618 | 575 | 555 | 533 | 600 | 570 | 620 | 625
 |  |  |  |  |  | 267 | 216 | 263 | 269 | 227 | 293 | 284 | 233 | 231 | 275 | 256 | 238
 |  |  | 0 |  |  | 195 | 188 | 198 | 191 | 200 | 200 | 191 | 191 | 187 | 196 | 182 | 185
Spreadsheet: 888218d1738690764-additional-ifs-or-another-approach-additional-ifs-or-another-approach
Sheet: Results

 | Gender | Team | 100m | 200m | 400m | 800m | M | F
[NAME] | M | Eagles | 9.99 | 19.9 | 44.92 | 106.5
Olivia | F | Falcons | 10.01 | 20 | 45 | 106.66
[NAME] | M | Dragons | 10.05 | 20.1 | 45.08 | 106.82
Emma | F | Bears | 10.1 | 20.2 | 45.16 | 106.98
[NAME] | M | Eagles | 10.15 | 20.3 | 45.24 | 107.14
Ava | F | Falcons | 10.2 | 20.4 | 45.32 | 107.3
[NAME] | M | Dragons | 10.25 | 20.5 | 45.4 | 107.46
Sophia | F | Bears | 10.3 | 20.6 | 45.48 | 107.62
Lucas | M | Eagles | 10.35 | 20.7 | 45.56 | 107.78
[NAME] | F | Falcons | 10.4 | 20.8 | 45.64 | 107.94
[NAME] | M | Dragons | 10.45 | 20.9 | 45.72 | 108.1
[NAME] | F | Bears | 10.5 | 21 | 45.8 | 108.26
[NAME] | M | Eagles | 10.55 | 21.1 | 45.88 | 108.42
[NAME] | M | Falcons | 10.6 | 21.2 | 45.96 | 108.58
[NAME] | M | Dragons | 10.65 | 21.3 | 46.04 | 108.74
Harper | F | Bears | 10.7 | 21.4 | 46.12 | 108.9
[NAME] | M | Eagles | 10.75 | 21.5 | 46.2 | 109.06
[NAME] | F | Falcons | 10.8 | 21.6 | 46.28 | 109.22
[NAME] | M | Dragons | 10.85 | 21.7 | 46.36 | 109.38
[NAME] | F | Bears | 10.9 | 21.8 | 46.38 | 109.54
[NAME] | M | Eagles | 10.95 | 21.9 | 46.4 | 109.7
Ella | F | Falcons | 10 | 22 | 46.41 | 109.86
[NAME] | M | Dragons | 10.02 | 22.1 | 46.42 | 110.02
[NAME] | F | Bears | 10.07 | 22.2 | 46.43 | 110.18
[NAME] | M | Eagles | 10.12 | 22.25 | 46.43 | 110.34
Spreadsheet: 40816d1239210246-dependent-data-validation-special-case-book1
Sheet: Sheet1

2009-02-15 00:00:00 | Pen | Start date: | 2009-02-15 00:00:00
2009-03-01 00:00:00 | Pencil
2009-03-02 00:00:00 | [NAME]
2009-03-19 00:00:00 | Eraser
2009-03-23 00:00:00 | Sheetbook
2009-04-04 00:00:00 | Ledger
2009-04-18 00:00:00 | Diluter
2009-04-22 00:00:00 | other
2009-05-06 00:00:00 | else
Spreadsheet: 317967d1399996373-gathering-values-based-off-critieria-and-in-turn-forming-a-list-auto-list
Sheet: Sheet1

 |  |  |  |  |  | There is another page in the real excel file that is using a vlook of column B with the Historical data on the other sheet. If the historical data can't find whats in column B. it will say "error". Which tells me we haven't purchased that [NAME] before and its new and needs to be entered in.
List # | Identifier | Discription | Amount |  |  |  |  |  |  |  |  | Error List
1 | q234r456 | green | 20 | error |  |  | The list to auto populate |  |  | ----> | 1
2 | w234e345 | red | 30 |  |  |  |  |  |  |  | 2
3 | g5678w12 | yellow | 40 |  |  |  |  |  |  |  | 3
4 | j8907ki42 | black | 35 |  |  |  |  |  |  |  | 4
5 | ssehbfuef | white | 90 | error
6 | 2387bv36 | purple | 120
7 | 387ghrd23 | orange | 110 | error
8 | e3rf7983 | blue | 65 |  |  |  |  | There are a lots of tabs with direct formulas off this page, so sorting the data would be easy but would throw off all these formulas.
9 | 98ashfw3 | teal | 70
10 | fo3h993f | violet | 83
11 | 30r03pq2p | gray | 47
50000 | 30r0j30fef | hazel | 51 | error
Spreadsheet: 731651d1620481030-formula-to-search-compare-data-from-multiple-sheets-search-for-terms-from-a-list-in-a-cell-macdoc-
Sheet: Register

All_Fem_Catalog No. | Description | Company | All_Tib_Catalog No. | Description | Company | All_Inl_Catalog No. | Description | Company
6307-00-020
Spreadsheet: 714146d1611117420-formula-to-fill-cells-based-on-date-and-drop-down-status-copy-of-gantt-2021-template
Sheet: Together Detailed Roadmap

Details |  |  | Timeline |  |  |  |  | 2021-01-01 00:00:00 |  |  |  | 2021-02-01 00:00:00 |  |  |  | 2021-03-01 00:00:00 |  |  |  |  | 2021-04-01 00:00:00 |  |  |  | 2021-05-01 00:00:00 |  |  |  | 2021-06-01 00:00:00 |  |  |  |  | 2021-07-01 00:00:00 |  |  |  | 2021-08-01 00:00:00 |  |  |  | 2021-09-01 00:00:00 |  |  |  |  | 2021-10-01 00:00:00 |  |  |  | 2021-11-01 00:00:00 |  |  |  |  | 2021-12-01 00:00:00
 |  |  |  |  |  |  |  | 2021-01-04 00:00:00 | 2021-01-11 00:00:00 | 2021-01-18 00:00:00 | 2021-01-25 00:00:00 | 2021-02-01 00:00:00 | 2021-02-08 00:00:00 | 2021-02-15 00:00:00 | 2021-02-22 00:00:00 | 2021-03-01 00:00:00 | 2021-03-08 00:00:00 | 2021-03-15 00:00:00 | 2021-03-22 00:00:00 | 2021-03-29 00:00:00 | 2021-04-05 00:00:00 | 2021-04-12 00:00:00 | 2021-04-19 00:00:00 | 2021-04-26 00:00:00 | 2021-05-03 00:00:00 | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | 2021-05-24 00:00:00 | 2021-05-31 00:00:00 | 2021-06-07 00:00:00 | 2021-06-14 00:00:00 | 2021-06-21 00:00:00 | 2021-06-28 00:00:00 | 2021-07-05 00:00:00 | 2021-07-12 00:00:00 | 2021-07-19 00:00:00 | 2021-07-26 00:00:00 | 2021-08-02 00:00:00 | 2021-08-09 00:00:00 | 2021-08-16 00:00:00 | 2021-08-23 00:00:00 | 2021-08-30 00:00:00 | 2021-09-06 00:00:00 | 2021-09-13 00:00:00 | 2021-09-20 00:00:00 | 2021-09-27 00:00:00 | 2021-10-04 00:00:00 | 2021-10-11 00:00:00 | 2021-10-18 00:00:00 | 2021-10-25 00:00:00 | 2021-11-01 00:00:00 | 2021-11-08 00:00:00 | 2021-11-15 00:00:00 | 2021-11-22 00:00:00 | 2021-11-29 00:00:00 | 2021-12-06 00:00:00 | 2021-12-13 00:00:00 | 2021-12-20 00:00:00 | 2021-12-27 00:00:00 | 2022-01-03 00:00:00
ID | Product | Main Tabs | Start Date | End Date | W. Days | Weeks | Status | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53
1 | Product | Product 1 | 2021-02-15 00:00:00 | 2021-03-13 00:00:00 |  | 3 | False
1 | Product | Product 1 | 2021-02-08 00:00:00 | 2021-03-01 00:00:00 |  | 3 | NOT STARTED
1.01 | Product | Sub-Product 1 | 2021-03-11 00:00:00 | 2021-06-10 00:00:00 |  | 13 | IN PROGRESS
1.02 | Product | Sub-Product 2 | 2021-03-05 00:00:00 | 2021-03-10 00:00:00 |  | 0 | [NAME]
2 | Product | Product 2 | 2021-03-10 00:00:00 | 2021-03-15 00:00:00 |  | 0 | DELAYED