tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 198551d1354812232-filter-emails-from-doc-with-mixed-info-example-mixed-data
Sheet: Hoja1

[NAME].: 0032-2-513 0199
E-Mail.: [EMAIL]
E-Mail.: [EMAIL]
[NAME].: 0032-2521 7088
E-Mail.: [EMAIL]
[NAME].: 0032-2 742 33 34
E-Mail.: [NAME]
[NAME].: 0032-2511-9077
E-Mail.: [EMAIL]
[NAME].: 0032-26499982
E-Mail.: [EMAIL]
[NAME].: 0032 2 567 94 34
E-Mail.: [EMAIL]
[NAME].: 0032-2-977 00 66
E-Mail.: [EMAIL]
WWW: www.vokneels.be
[NAME].: 0032-2-6787275
[NAME].: 0032-2-537 0992
E-Mail.: [EMAIL]
WWW: www.tire-noisettes.be
[NAME].: 0032-2-661 8611
E-Mail.: [EMAIL]
[NAME].: 0032-2-661 3026
E-Mail.: [EMAIL]
[NAME].: 0032-10-275137
E-Mail.: [EMAIL]
Spreadsheet: 62669d1263570461-auto-populate-the-selection-from-the-database-selected-data_a
Sheet: Lookup

State ID Lookup | Nevada
State ID | Product ID | Quantity | Gross Sales | Net Sales | Cost | Number of Orders
Nevada | Product 1 | 106 | 10600 | 8692 | 7950 | 2
Nevada | Product 15 | 52 | 52000 | 42640 | 39000 | 1
Nevada | Product 17 | 60 | 114000 | 93480 | 85500 | 2
Nevada | Product 18 | 100 | 10000 | 8200 | 7500 | 1
Nevada | Product 2 | 51 | 10200 | 8364 | 7650 | 1
Nevada | Product 3 | 51 | 510 | 418 | 357 | 1
Nevada | Product 4 | 50 | 1000 | 820 | 750 | 1
Nevada | Product 7 | 418 | 4180 | 3427 | 2926 | 2
Nevada | Product 8 | 630 | 12600 | 10330 | 9450 | 3
Nevada | Product 9 | 5 | 3500 | 2835 | 2625 | 1
Spreadsheet: 47429d1246464063-vexxing-lookup-problem-lookup-problem
Sheet: Sheet2

 | Longevity Differential |  | Union | Local | 3 | 5 | 6 | 9 | 10 | 12 | 15 | 18 | 20
 | 40491-0 | [NAME] | DC37 | 1407 | 1208 | 2944 | --- | --- | --- | 4140 | --- | --- | ---
 | 40491-1 | [NAME] | DC37 | 1407 | 1208 | 2944 | --- | --- | --- | 4140 | --- | --- | ---
 | 40526-1 | Bookkeeper I | DC37 | 1407 | 1208 | 2944 | --- | --- | --- | 4140 | --- | --- | ---
 | 40526-2 | Bookkeeper II | DC37 | 1407 | 1208 | 2944 | --- | --- | --- | 4140 | --- | --- | ---
 | 10251-1 | Clerical Assoc IA | DC37 | 1549 | --- | --- | --- | --- | --- | --- | --- | --- | ---
 | 10251-2 | Clerical Assoc II | DC37 | 1549 | --- | --- | 728 | 1456 | --- | 2189 | 2583 | 3426 | ---
 | 10251-3 | Clerical Assoc III | DC37 | 1549 | --- | --- | 728 | 1456 | --- | 2189 | 2583 | 3426 | ---
 | 10251-4 | Clerical Assoc IV | DC37 | 1549 | --- | --- | 728 | 1456 | --- | 2189 | 2583 | 3426 | ---
 | 10124-1 | PAA I | CWA | 1180 | --- | --- | --- | --- | 600 | --- | --- | --- | ---
 | 10124-2 | PAA II | CWA | 1180 | --- | --- | --- | --- | 600 | --- | --- | --- | ---
 | 10124-3 | PAA III | CWA | 1180 | --- | --- | --- | --- | 600 | --- | --- | --- | ---
 | 40510-0 | Accountant | DC37 | 1407 | 2121 | 5234 | --- | --- | --- | 8079 | 8458 | --- | ---
 | 40491-1 | [NAME] | DC37 | 1407 | --- | --- | --- | --- | --- | --- | 379 | --- | ---
 | 40517-0 | [NAME] | DC37 | 1407 | 2121 | 5687 | --- | --- | --- | 8534 | 8913 | --- | ---
 | 40493-1 | [NAME] I | DC37 | 1407 | 1092 | 4209 | --- | --- | --- | 7262 | 7641 | --- | ---
 | 40493-2 | [NAME] | DC37 | 1407 | 1092 | 4664 | --- | --- | --- | 7714 | 8093 | --- | ---
 | 40493-3 | [NAME] | DC37 | 1407 | 1092 | 4664 | --- | --- | --- | 7714 | 8093 | --- | ---
 | 12627-0 | [NAME] Staff Analyst | OSA | OSA | --- | --- | --- | --- | --- | --- | --- | --- | 1049
 | 40526-1 | Bookkeeper I | DC37 | 1407 | --- | --- | --- | --- | --- | --- | 379 | --- | ---
 | 40526-2 | Bookkeeper II | DC37 | 1407 | --- | --- | --- | --- | --- | --- | 379 | --- | ---
 | 40925-0 | Investment Analyst | DC37 | 1407 | 1092 | 4209 | --- | --- | --- | 7262 | 7641 | --- | ---
 | 40502-0 | [NAME] | DC37 | 1407 | 2121 | 5234 | --- | --- | --- | 8079 | 8458 | --- | ---
 | 40926-0 | Senior [NAME] Analyst | DC37 | 1407 | 1092 | 4664 | --- | --- | --- | 7714 | 8093 | --- | ---
 | 12626-1 | Staff Analyst I | OSA | OSA | --- | --- | --- | --- | --- | --- | --- | --- | 1049
 | 12626-2 | Staff Analyst II | OSA | OSA | --- | --- | --- | --- | --- | --- | --- | --- | 1049
 | 40927-0 | [NAME] Analyst | DC37 | 1407 | 1092 | 4664 | --- | --- | --- | 7714 | 8093 | --- | ---
 | 11702-2 | OMA II | DC37 | 1549 | --- | --- | --- | --- | --- | --- | --- | --- | ---
 | 12200-0 | Stock Worker | IBT | 237 | --- | --- | --- | --- | --- | --- | --- | --- | ---
 | 12202-0 | Supervisor of Stock Workers | IBT | 237 | --- | --- | --- | --- | --- | --- | --- | --- | ---
Spreadsheet: 134111d1325017050-simplified-report-for-equipment-maintenance-equipment-cost-report
Sheet: 5342

AMC No. | 09-04 | EQUIPMENT COST REPORT
Unit Number | OTV 5342 |  | Start Date | 24/07/2011 |  |  |  | [NAME] |  | 888
Employee Name: |  |  | End Date | 06/08/2011 |  |  |  | Hour [NAME] |  | 8
Date | Receipt Number | Vendor | Fuel |  | [NAME] |  | Motor Oil |  | [NAME]. Cost | Total Cost | Odometer | PRINT NAME
 |  |  | Quantity | Cost | Quantity | Cost | Quantity | Cost
 |  |  |  |  |  | Hour [NAME] |  |  |  | Odometer End
Service Record
[NAME] | [NAME] | Vendor | Receipt Number
Filter Changed |  |  |  |  |  | NOTES
Oil Changed
Greased
Other
Supervisor Signature: __________________________________________
Spreadsheet: 1ba645bd-33b2-481e-ad0f-3b1b9e75bc1d
Sheet: Sheet1

Reviewed | Team | ODL | Attributes | Attributes.1 | Attributes.2 | Attributes.3 | Attributes.4 | Attributes.5 | Attributes.6
2010-07-22 00:00:00 | CMU | Medication Taking
 | CMU | Meal Preparation
 | CMU | Making a Phone Call | number dialed | dialing attempts | dialing error type | dialing time | [NAME] remembered | unique user ID | timestamp
 | CMU | Receiving a Phone Call
 | CMU | Restlessness Sitting in Bed
2010-07-20 00:00:00 | RTI | Peak-flow Rates | poss. Biomonitor
 | RTI | Controller Medication Adherence | self-report
 | RTI | Use of rescue meds | self-report
 | RTI | Levels/Types of Phys Activity (or limits) | sensor:accelerometer
 | RTI | Subjective Levels of Symptoms | self-report
2010-07-07 00:00:00 | SFSU | Photo Food | food pick list or custom | date/time eaten | meal/snack category | reminder text | reminder date/time | summary view | reflection
 | SFSU | [NAME] | two-dimension mood map | unidimension scale for stress, anger, happiness, sadness |  | reminder text | reminder date/time
 | SFSU | Social Network Integration/Isolation | interaction target | interaction type | intensity | quality rating | comment | reminder text | reminder date/time
 | SFSU | Physical Activity | activity log; poss auto
2010-06-29 00:00:00 | UC-B | Weight | A&D weight scale
 | UC-B | Abdominal Pain | visual analog scale
 | UC-B | # of Bowel Movements | Cypak report card
 | UC-B | Stress Level
 | UC-B | Tiredness/Fatigue
 | UC-B | Hours Slept
 | UC-B | Overall How I Feel Today (Depression)
 | UC-B | [NAME]
 | UC-B | Activities Interrupted
2010-07-11 00:00:00 | UC-I | Weight | sensor enabled scale | patient record ID | numeric in lbs & oz | computed certainty | weight image
 | UC-I | Diapers | self-report, image analysis
 | UC-I | Appointments | calendar/scheduling
 | UC-I | Caregiver Stress & Mood | self-report
 | UC-I | Infant temperament & interactions | self-report via mobile phone
 | Medication Taking | CMU, RTI
 | Weight | UC-B, UC-I
 | [NAME] | SFSU, UC-B, UC-I
 | Physical Activity | RTI, SFSU, UC-B
Spreadsheet: daren_farmer__6515__egmnom-Jan
Sheet: EGM 60

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-207106-02-010
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-01-01 00:00:00
Fax: | (713)207-0054 | Stop:
 |  | 2000-01-31 00:00:00
RECEIPTS |  |  | JAN
METER # | [NAME] | SUPPLIER | 1
644 | LONE STAR KATY | DUKE | 10000
644 | LONE STAR KATY | RICHARDSON
4132 | EXXON KATY | ECT | 20000
4132 | EXXON KATY | COKINOS | 0
XXXX | IMBALANCE | ENTEX/HPL | 0
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
1563 | COGEN | DYNEGY
1373 | [NAME] | CES
1485 | OXY BATTLEGROUND | OXY
1505 | DEER PARK | DUPONT
1506 | RHOM & HAAS DEER PARK | RHOM & HAAS | 5000
1394 | HILL PETRO | DYNEGY
8001 | AIR LIQUIDE | AIR LIQUIDE | 10000
XXXX | IMBALANCE | ENTEX/HPL | 0
 |  | DELIVERY TOTAL
Spreadsheet: 438212d1451857065-summing-row-by-row-data-from-one-worksheet-into-a-single-row-in-another-worksheet-fb-stats-file-excerpt-for-excelforum-1-3-16-
Sheet: Offense Summary

 | PASSING |  |  |  |  |  |  |  |  | RECEIVING |  |  |  |  | RECEIVING |  |  |  |  | RUSHING |  |  |  |  | RUSHING
 | QB | ATT. | COMP. | % | YDS. | INT. | IRY | TDs |  | RECEIVER | REC. | YDS. | TDs |  | RECEIVER | REC. | YDS. | TDs |  | RUSHER | ATT. | YDS. | TDs |  | RUSHER | ATT. | YDS. | TDs
 | FIRST QUARTER |  |  |  |  |  |  |  |  | FIRST QUARTER |  |  |  |  | THIRD QUARTER |  |  |  |  | FIRST QUARTER |  |  |  |  | THIRD QUARTER
 | [NAME] | 10 | 7
 | [NAME] | 6 | 4
 | [NAME] | 4 | 2
 | [NAME] | 2 | 1
 | SECOND QUARTER
 | FIRST HALF
 |  |  |  |  |  |  |  |  |  | SECOND QUARTER |  |  |  |  | FOURTH QUARTER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SECOND QUARTER |  |  |  |  | FOURTH QUARTER
 | All QBs
 | THIRD QUARTER
 | FOURTH QUARTER
 | SECOND HALF
 |  |  |  |  |  |  |  |  |  | FIRST HALF |  |  |  |  | SECOND HALF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIRST HALF |  |  |  |  | SECOND HALF
 | GAME
 | All QBs
 | PLAYS
 | TYPE | NO. | YDS. | YPP |  |  |  |  |  | [NAME], Tiquest |  |  |  |  | [NAME], Tiquest
 | 1st. QTR. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GAME
 | Rushes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RECEIVING
 | Passes |  |  |  |  |  |  |  |  | All Receivers |  |  |  |  | All Receivers |  |  |  |  | GAME RECEIVING
 | 2nd. QTR. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RECEIVER | REC. | YDS. | TD
 | Rushes
 | Passes |  |  |  |  | FIRST DOWNS
 | FIRST HALF |  |  |  |  | RUN | PASS
 | Rushes |  |  |  |  | 1st. QTR.
 | Passes
 | 3rd. QTR. |  |  |  |  | 2nd. QTR.
 | Rushes
 | Passes |  |  |  |  | 1ST. HALF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Rushers
 | 4th. QTR.
 | Rushes |  |  |  |  | 3rd. QTR.
 | Passes
 | 2ND. HALF |  |  |  |  | 4th. QTR.
 | Rushes
 | Passes |  |  |  |  | 2ND. HALF |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Tiquest
 | GAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FUMBLES
 | Rushes |  |  |  |  | GAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLAYER | LOST | RECOV.
 | Passes |  |  |  |  |  |  |  |  | FUMBLES |  |  |  |  | FUMBLES |  |  |  |  | All Receivers
 |  |  |  |  |  |  |  |  |  | PLAYER | LOST | RECOV. |  |  | PLAYER | LOST | RECOV.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FUMBLES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLAYER | LOST | RECOV.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Ball Carriers
Spreadsheet: 861817d1709648214-help-having-trouble-with-formulas-mock-1-ans
Sheet: Sheet1

 |  |  |  |  | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00
 |  |  |  | Days of month
 | DAILY COST | OFFHIRE REF | OFFHIRE DATE |  | Monthly projected costs
unit 1 | 6.7 |  | 2024-02-28 00:00:00
Unit 2 | 6.7 |  | 2024-03-03 00:00:00
Unit 3 | 6.7 |  | 2024-01-29 00:00:00
Unit 4 | 6.7 |  | 2025-03-15 00:00:00
Unit 5 | 6.7
Unit 6 | 6.7
Unit 7 | 6.7
Unit 8 | 6.7
Unit 9 | 6.7
Unit 10 | 6.7
Unit 11 | 6.7
Unit 12 | 6.7 |  | 2024-06-06 00:00:00
Unit 13 | 6.7
Unit 14 | 6.7
 |  |  | Expected result
 |  |  |  |  | Data should not be here as it should have gell out on the months stated at offhire
 |  |  |  |  | Data should be here as the offhire is not until 2025
 |  |  |  |  | Can you change the fields to capture IF currency is £, $, € then to change the currency in monthly projected costs fields (F to S)
Spreadsheet: 769332d1645474521-change-cell-reference-to-a-column-when-copying-formula-in-a-row-productivity-score
Sheet: Example 2

Week | # of Calls | # of Cases | # of Hours | Productivity Score
2022-02-14 00:00:00 | 60 | 89 | 40
Spreadsheet: f79dd30b-fd05-492d-a9ef-32253cb25f6b
Sheet: Sheet1

Organism | # NPS genes | # C. heterostrophus C5 orthologs | NPS1a | NPS2b | NPS3 | NPS4 | NPS5 | NPS6 | NPS7 | NPS8 | NPS9 | [NAME] | NPS11 | NPS12-1c | NPS12-2c | NPS13
[NAME] brassicicola | 7 | 5 | - | + (4) | - | + | - | + | - | - | - | + | - | - | + | -
Baudoinia compniacensis | 2 | 2 | - | + (3) | - | - | - | - | - | - | - | + | - | - | - | -
Cladosporium fulvum | 12 | 2 | - | + (3) | - | - | - | - | - | - | - | + | - | - | - | -
Cochliobolus heterostrophus C4 | 14 | 14 | + | + (4) | + | + | + | + | + | + | + | + | + | + | + | +
Cochliobolus heterostrophus C5 | 14 | 14 | + | + (4) | + | + | + | + | + | + | + | + | + | + | + | +
Cochliobolus sativus | 19 | 9 | - | + (4) | + | + | - | + | + | - | - | + | + | + | + | -
Dothistroma septosporum | 7 | 2 | - | + (3) | - | - | - | - | - | - | - | + | - | - | - | -
Hysterium pulicare | 10 | 4 | - | + (4) | - | + | - | + (46) | - | - | - | + | - | - | - | -
Leptosphaeria maculans | 8 | 5 | - | + (4) | - | + | - | + | - | - | - | + | - | + | - | -
Mycosphaerella fijiensis | 11 | 2 | - | + (3) | - | - | - | - | - | - | - | + | - | - | - | -
Mycosphaerella graminicola | 9 | 2 | - | - | - | - | - | - | - | - | - | + | - | - | - | +
[NAME] teres | 44 | 7 | - | + (4) | - | + | - | + | - | - | + | + | - | + | + | -
[NAME] | 16 | 6 | - | + (4) | - | + | - | + x2 | - | - | - | + | - | + | + | -
[NAME] rufulum | 15 | 3 | - | + (4) | - | - | - | + | - | - | - | + | - | - | - | -
Mycosphaerella populorum | 10 | 1 | - | + (3) | - | - | - | - | - | - | - | + | - | - | - | -
Mycosphaerella populicola | 9 | 2 | - | + (3) | - | - | - | - | - | - | - | + | + | - | - | -
Setosphaeria turcica | 15 | 6 | - | + (4) | - | + | - | + | - | - | - | + | - | + | + | -
Stagospora nodorum | 10 | 5 | - | + (4) | - | + | + | + | - | - | - | + | - | - | - | -
a +/- = presence/absence of the C. heterostrophus strain C5 ortholog.
b for NPS2 number in parentheses refers to the number of AMP domains in the protein
c NPS12-1, NPS12-2 refer to C. heterostrophus strain C5 NPS12 proteins 118012 and 116719
x2 indicates two representatives
cutoff is greater than 48% identity at the amino acid level with the exception of H. pulicare NPS6 which is 46%
Spreadsheet: 94d7755c-c1e9-48b3-a8e5-1ff23034cc92
Sheet: Sheet1

Protein | RELATIVE AMOUNTS IN DIFFERENT STAGES | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Sporozoite | Ring | Trophozoite | Schizont | Merozoite
actin (PF11_0114) | 6 | 0 | 0 | 0 | 2
actin (PF14_0124) | 6 | 174 | 22 | 11 | 31 |  | THIS DATASET FOR PROTEIN ABUNDANCES IS DERIVED FROM LeRoch et al. (ref #41)
[NAME] (PFA0190c) | 2 | 0 | 0 | 0 | 0
[NAME] (PF14_0218) | DATA NOT AVAILABLE
a-tubulin II (PFD1050w) | 35 | 29 | 3 | 19 | 72
a-tubulin (PFI0180w)) | 80 | 34 | 3 | 21 | 86
b-tubulin (PF10_0084) | 179 | 47 | 7 | 126 | 105
g-tubulin (PF08_0125) | 0 | 0 | 0 | 1 | 0
tubulin putative (PF14_0725) | DATA NOT AVAILABLE
centrin (PF14_0443) | 1 | 8 | 10 | 32 | 14
centrin (PFA0345w) | 0 | 0 | 0 | 7 | 0
Centrin (PF10_0271) | DATA NOT AVAILABLE
centrin (PF11_0066) | DATA NOT AVAILABLE
Protein
 | Sporozoite | Ring | Trophozoite | Schizont | Merozoite
[NAME] (PF07_0029) | 4 | 125 | 303 | 115 | 90
Grp94 (PFL1070c) | 19 | 111 | 217 | 97 | 182
Hsp70 (PF08_0054) | 19 | 304 | 404 | 228 | 252
BiP (PFI0875w) | 25 | 198 | 323 | 164 | 318
Hsp60 (PF10_0153) | 1 | 12 | 67 | 17 | 6
Hsp101 (PF11_0175) | 3 | 78 | 34 | 6 | 22
Spreadsheet: a5072422-37e4-4764-91bd-8d2fae9d0703
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
PCPU | Test | PCPU | Phencyclidine Confirmation, [NAME] | Phencyclidine Confirmation, U | PCPU/80371: Immunoassay/Gas Chromatography-Mass Spectrometry (GC-MS) Confirmation with Quantitation ADULT/29345: Spectrophotometry (SP) | Plastic, urine bottle: [NAME] |  |  | 30 | mL | Container/Tube: Plastic, 60-mL urine bottle [NAME]: 20 mL Collection Instructions:  1. Collect a random urine specimen. 2. No preservative.  Additional Information: 1. No specimen substitutions.  2. No STATS are accepted for this procedure.  3. For situations where chain-of-custody is required, a Chain-of-Custody Kit (Supply T282) is available. For chain-of-custody information, see COCH/9426 Chain-of-Custody Processing. 4. Additional drug panels and specific requests are available. Call Mayo Medical Laboratories at [PHONE] or [PHONE]. | 5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Negative Positives are reported with a quantitative GC-MS result. [NAME] concentrations Immunoassay screen: <25 ng/mL Phencyclidine by GC-MS: <10 ng/mL | Monday | 2 days | 8 days | 1 | 83992 |  |  |  |  | Rochester
PCPU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
PCPU | Result | 6672 | Immunoassay Screen | Immunoassay Screen | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19659-2
PCPU | Result | 6673 | Phencyclidine-by GC/MS | Phencyclidine-by GC/MS | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 16254-5
PCPU | Result | 21192 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69050-3
PCPU | Result | 21193 | Chain of Custody | Chain of Custody | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PCPU | [NAME] | ADULT | Adulterants Survey, [NAME] | Adulterants Survey, U |  |  |  |  |  |  | This test is only orderable as a reflex. |  |  |  | Monday through Sunday | Same day/1 day | 2 days |  |  |  |  | Yes | No
ADULT | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
ADULT | Result | 20606 | Creatinine, U | Creatinine, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | In Process
ADULT | Result | 22312 | Specific Gravity | Specific Gravity | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5811-5
ADULT | Result | 23509 | pH | pH | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2756-5
ADULT | Result | 23511 | Oxidants | Oxidants | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
ADULT | Result | 23510 | Nitrites | Nitrites | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 32710-6
ADULT | Result | 30914 | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8
Spreadsheet: 696522d1600872504-lookup-value-with-multiple-criteria-to-report-back-another-value-lookup-value-for-multiple-values
Sheet: Sheet1

 | A | B | C | D | E | AxB | AxC | AxD | AxE | BxC | BxD | BxE | CxD | CxE | DxE | AxBxC | AxBxD | AxBxE
 | -1 | -1 | -1 | -1 | -1 | 1 | 1 | 1 | 1 | -1 | -1 | -1 | -1 | 1 | 1 | -1 | -1 | -1
 | -1 | -1 | -1 | -1 | 1 | 1 | 1 | 1 | -1 | -1 | -1 | -1 | 1 | 1 | 1 | -1 | -1 | -1
 | -1 | -1 | -1 | -1 | -1 | 1 | 1 | 1 | 1 | -1 | -1 | -1 | -1 | 1 | 1 | -1 | -1 | -1
 | -1 | -1 | -1 | -1 | 1 | 1 | 1 | 1 | -1 | -1 | -1 | -1 | 1 | 1 | 1 | -1 | -1 | -1
 | -1 | -1 | 1 | -1 | -1 | 1 | -1 | 1 | 1 | -1 | 1 | -1 | 1 | -1 | -1 | -1 | 1 | -1
 | -1 | -1 | 1 | -1 | 1 | 1 | -1 | 1 | -1 | -1 | 1 | -1 | -1 | -1 | -1 | -1 | 1 | -1
 | -1 | -1 | 1 | -1 | -1 | 1 | -1 | 1 | 1 | -1 | 1 | -1 | 1 | -1 | -1 | -1 | 1 | -1
 | -1 | -1 | 1 | -1 | 1 | 1 | -1 | 1 | -1 | -1 | 1 | -1 | -1 | -1 | -1 | -1 | 1 | -1
 | A | B | C | D | E | AxB | AxC | AxD | AxE | BxC | BxD | BxE | CxD | CxE | DxE | AxBxC | AxBxD | AxBxE
 | -1 | -1 | -1 | -1 | -1
 | -1 | -1 | -1 | -1 | 1
 | -1 | -1 | -1 | -1 | -1
 | -1 | -1 | -1 | -1 | 1
 | -1 | -1 | 1 | -1 | -1
 | -1 | -1 | 1 | -1 | 1
 | -1 | -1 | 1 | -1 | -1
 | -1 | -1 | 1 | -1 | 1
 | Problem: How to lookup the first letter of the cell in row 2 (blue) to match that letter to the letter on the left side (green).
 | Step 2: From that matched letter, depedning on what column the letter has matched to, report the value in the same row that the formula is in.
 | Example: | Lookup Cell G2 for either A,B,C,D,E, but only the first character (i.e. in "AxB" only report back "A", maybe a LEFT(G1,1) function?)
 |  | Match this lookup value to the array of B2:E2, in this case, A matches column B
 |  | Report the value to the Value that the fromula row is on, in this case B3 matches cell [NAME] for row, therefore report back cell B3
 | IF POSSIBLE | Multiply this lookup value by the letter in the second part of cell G2, so the third character
 |  | Match this lookup value to the array of B2:E2, in this case, A matches column C
 |  | Report the value to the Value that the fromula row is on, in this case C3 matches cell [NAME] for row, therefore report back cell [NAME]
 |  | Multiply the two lookedup values together to achieve a result. This formula should be able to be copied along the whole grid for the 1x1 parts.
 |  | If possible a formula which can encompass the 1x1x1 parts of the grid.
Spreadsheet: 861339d1709223867-irr-true-ups-for-minimum-return-thresholds-irr-true-ups
Sheet: XNPV

 |  |  |  |  | The investor needs to make 12%, no matter the cash flows or timing. We need to tell the customer at any given point in time how much the payoff amount would be to make the IRR 12% based on a set of projections
 |  |  |  |  | How do I automatically find the payoff in each period to make the IRR equal to a target value instead of goal seeking every value highlighted in yellow?
 |  |  |  |  |  |  |  | Payoff Date
 |  |  |  |  | Target IRR |  | 0.06 | 2024-10-31 00:00:00 |  |  | Cumulative
 |  |  |  |  | Example 1 |  |  |  |  |  | Discounted | Discount
Period | Date | Cash Flow | Spot IRR |  | Period | Date | Cash Flow | Payoff | Net Cash Flow | Target IRR | Net Cash Flow | Factor | Payoff
0 |  | -100 |  |  | 0 |  | -100
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
 |  | 5
Spreadsheet: 697726d1601490861-numbers-appearing-in-raw-data-wont-convert-to-an-excel-value-numbervalue
Sheet: Sheet1

 |  |  |  |  |  | $1,040
 |  |  |  |  |  | ‐$540
 |  |  |  |  |  | $1,040.00
 |  |  |  |  |  | $520
Spreadsheet: ba35d6c0-af4c-47f6-9d8a-bccf100d9833
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38710085 | 2013-11-26 01:11:32 | ALLIES | 0 | 2 | 6 | 692398 | Morgiliath | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
Spreadsheet: 720855d1614327468-finding-specific-occurances-question
Sheet: Sheet1

[NAME] |  |  |  | ANSWER |  |  |  | Doesn't work with duplicate number
1 | 12 | 14
3 | 7 | 118
118 | 3 | 7
14 | 15 | 16
14 | 15 | 16
15 | 15 | 15
18 | 15 | 12
1 | 12 | 14