tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 59006d1259332432-sumproduct-not-all-employees-are-working-testsumproduct
Sheet: Sumproduct

Dates | Salaries | Employees | Cost Center |  |  | From | To | Cost Center |  | Salaries
2010-01-01 00:00:00 | 12 | [NAME] | bb |  |  | 2010-01-01 00:00:00 | 2010-06-01 00:00:00 | bb |  | 72
2010-02-01 00:00:00 | 12 | [NAME] | bb
2010-03-01 00:00:00 | 12 | [NAME] | bb
2010-04-01 00:00:00 | 12 | [NAME] | bb
2010-05-01 00:00:00 | 12 | [NAME] | bb
2010-06-01 00:00:00 | 12 | [NAME] | bb
2010-07-01 00:00:00 | 12 | [NAME] | bb |  |  | You can change your dates and your
2010-08-01 00:00:00 | 12 | [NAME] | bb |  |  | cost center to get the Total Salaries
2010-09-01 00:00:00 | 12 | [NAME] | bb
2010-10-01 00:00:00 | 12 | [NAME] | bb
2010-11-01 00:00:00 | 12 | [NAME] | bb
2010-12-01 00:00:00 | 12 | [NAME] | bb
2010-01-01 00:00:00 | 20 | Debbie | aa
2010-02-01 00:00:00 | 20 | Debbie | aa
2010-03-01 00:00:00 | 20 | Debbie | aa
2010-04-01 00:00:00 | 20 | Debbie | aa
2010-05-01 00:00:00 | 20 | Debbie | aa
2010-06-01 00:00:00 | 20 | Debbie | aa
2010-07-01 00:00:00 | 20 | Debbie | aa
2010-08-01 00:00:00 | 20 | Debbie | aa
2010-09-01 00:00:00 | 20 | Debbie | aa
2010-10-01 00:00:00 | 20 | Debbie | aa
2010-11-01 00:00:00 | 20 | Debbie | aa
2010-12-01 00:00:00 | 20 | Debbie | aa
2010-01-01 00:00:00 | 10 | Mark | aa
2010-02-01 00:00:00 | 10 | Mark | aa
2010-03-01 00:00:00 | 10 | Mark | aa
2010-04-01 00:00:00 | 10 | Mark | aa
2010-05-01 00:00:00 | 10 | Mark | aa
2010-06-01 00:00:00 | 10 | Mark | aa
2010-07-01 00:00:00 | 10 | Mark | aa
2010-08-01 00:00:00 | 10 | Mark | aa
2010-09-01 00:00:00 | 10 | Mark | aa
2010-10-01 00:00:00 | 10 | Mark | aa
2010-11-01 00:00:00 | 10 | Mark | aa
2010-12-01 00:00:00 | 10 | Mark | aa
Spreadsheet: 223068d1364039479-auto-populating-cell-values-from-list-based-on-criteria-source-separate-excel-file-customertool
Sheet: Account Planning Tool

Customer tool
Choose City, Product or Indication
 |  | City | Product | Indication
 |  | Herlev
Name | Product | Indication | City | stdTimeStampStart |  | 1st qtr activity | 2nd qtr activity | 3rd qtr activity | 4th qtr activity
[NAME] | Product1 | Indication1 | Herlev | 2013-01-14 14:00:00 |  | Afdelingsmøde | 0 | 0 | 0
[NAME] | Product1 | Indication1 | Herlev | 2013-02-15 12:00:00 |  | [NAME] | 0 | 0 | 0
[NAME] | Product2 | Indication4 | Herlev | 2013-02-11 15:00:00 |  | Gruppebesøg | 0 | 0 | 0
[NAME] | Product2 | Indication4 | Herlev | 2013-02-26 13:00:00 |  | Spontant møde på kundens anmodning (Canvas) | 0 | 0 | 0
[NAME] | Product2 | Indication4 | Herlev | 2013-01-11 14:47:00 |  | [NAME] | 0 | 0 | 0
[NAME] | Product2 | Indication4 | Herlev | 2013-02-26 13:30:00 |  | Besøg efter aftale | 0 | 0 | 0
[NAME] | Product3 | Indication2 | Herlev | 2013-02-21 13:00:00 |  | Spontant møde på kundens anmodning (Canvas) | 0 | 0 | 0
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0121

 | Date: | 2013-01-21 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 5 | 28.6
 | 11:00:00 | 48 | 337.53
 | 12:00:00 | 60 | 439.96
 | 13:00:00 | 69 | 450.34
 | 14:00:00 | 45 | 321.96
 | 15:00:00 | 38 | 213.62
 | 16:00:00 | 28 | 167.89
 | 17:00:00 | 35 | 289.18
 | 18:00:00 | 38 | 278.29
 | 19:00:00 | 31 | 238.56
 | 20:00:00 | 19 | 122.75
 | 21:00:00 | 18 | 111.94
 | 22:00:00 | 17 | 118.17
 | 23:00:00 | 11 | 70.31
 | 1900-01-01 00:00:00 | 5 | 36.53
 | 1900-01-01 01:00:00 | 0 | 0
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 72619d1273316198-excel-2007-split-data-from-a-single-column-to-plot-a-two-line-chart-728407
Sheet: Sheet1

Master Position | Master DOH | Master Percent | Group2 |  |  | [NAME] |  | G2 |  | AxisLabels
1 | 1969-03-10 00:00:00 | 0.076 |  |  |  |  |  |  | 0 | 13
2 | 1966-02-28 00:00:00 | 0.153 | G2 |  |  |  |  |  | 0 | 12
3 | 1969-03-17 00:00:00 | 0.231 |  |  |  |  |  |  | 0 | 11
4 | 1969-03-17 00:00:00 | 0.307 |  |  |  |  |  |  | 0 | 10
5 | 1966-04-11 00:00:00 | 0.384 | G2 |  |  |  |  |  | 0 | 9
6 | 1969-04-07 00:00:00 | 0.461 |  |  |  |  |  |  | 0 | 8
7 | 1966-06-27 00:00:00 | 0.538 | G2 |  |  |  |  |  | 0 | 7
8 | 1969-05-08 00:00:00 | 0.615 |  |  |  |  |  |  | 0 | 6
9 | 1978-01-09 00:00:00 | 0.692 |  |  |  |  |  |  | 0 | 5
10 | 1972-10-02 00:00:00 | 0.769 | G2 |  |  |  |  |  | 0 | 4
11 | 1978-01-09 00:00:00 | 0.846 |  |  |  |  |  |  | 0 | 3
12 | 1978-01-09 00:00:00 | 0.923 |  |  |  |  |  |  | 0 | 2
13 | 1970-08-17 00:00:00 | 1 | G2 |  |  |  |  |  | 0 | 1
Spreadsheet: 709444d1608306358-conditional-format-if-a-different-cell-has-strikethrough-cf-strikethrough-aligw
Sheet: Sheet1

Importance | Item | Status
1 | Task A | DONE | <------ | current progress
1 | Task B | waiting for bob to sign
1 | Task C
3 | Task D | DONE | <------ | What I'm looking for
3 | Task E
5 | Task F
5 | Task G
Spreadsheet: 773203d1647690284-cell-formula-needing-different-outcome-text-docusign
Sheet: Sheet1

Name | Job Title | Dept. | Start Date | Location | Offer Date | Offer Accepted | Docusign Sent | Folder Created | Contract Sent | [NAME] | Signed Contract Uploaded
[NAME] | Rocket Scientist | Research & Development | 2022-02-21 00:00:00 | [NAME] | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | Yes |  | Yes | Yes
[NAME] | Administrator | Central Services | 2022-02-28 00:00:00 | [NAME] | 2022-01-05 00:00:00 | 2022-01-07 00:00:00 | Yes | Yes
[NAME] | Engineer | Enviornmental Engineering | 2022-02-28 00:00:00 |  | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | N/A | Yes
Spreadsheet: 858077d1706853289-problemas-com-segmenta-o-devolu__o-x-novas-loca__es-teste-dash_24-teste-ii
Sheet: BASE DINAMICA

VALOR DEVOLVIDO |  |  | VALOR PRO RATA |  |  | QTD DEVOLUÇÃO GERAL |  |  |  | ESTADOS
MÊS | VALOR |  | MÊS | VALOR |  | MÊS | VALOR |  | MÊS | QUANTIDADE
JAN | 66526.46 |  | JAN | 3833.13 |  | JAN | 68262.92 |  | JAN | 36
FEV | 34869.44 |  | FEV | 10186.16 |  | FEV | 77029.66 |  | FEV | 22
MAR | 85248.34999999999 |  | MAR | 9655.17 |  | MAR | 51846.09 |  | MAR | 45
ABR | 85405.62 |  | ABR | 4492.1 |  | ABR | 64991.05 |  | ABR | 38
MAI | 73702.48 |  | MAI | 10483.11 |  | MAI | 99088.66 |  | MAI | 33
JUN | 63778.16 |  | JUN | 18284.22 |  | JUN | 64293.6 |  | JUN | 31
JUL | 56587.53 |  | JUL | 10475.12 |  | JUL | 47114.53 |  | JUL | 29
AGO | 91073.97 |  | AGO | 17824.35 |  | AGO | 113656.65 |  | AGO | 25
SET | 87998.77 |  | SET | 58694.92000000001 |  | SET | 115964.4 |  | SET | 34
OUT | 68132.54000000001 |  | OUT | 16311.85 |  | OUT | 32714.21 |  | OUT | 31
NOV | 117135.14 |  | NOV | 93742.13 |  | NOV | 52161.6 |  | NOV | 43
DEZ | 159929.48 |  | DEZ | 28174.71 |  | DEZ | 22140.13 |  | DEZ | 47
TOTAL | 990387.9399999998 |  | TOTAL | 282156.97 |  | TOTAL | 809263.5 |  | TOTAL | 414
 | MODO DEVOLUÇÃO |  |  |  |  | VALOR FRETE
MÊS | Total | Parcial | RMA |  | MÊS | CLIENTE | RICARDO | TRANSP.
JAN | 22 | 10 | 4 |  | JAN | 0 | 0 | 0
FEV | 10 | 10 | 2 |  | FEV | 0 | 0 | 0
MAR | 29 | 10 | 6 |  | MAR | 0 | 0 | 0
ABR | 24 | 13 | 1 |  | ABR | 0 | 0 | 0
MAI | 17 | 14 | 2 |  | MAI | 0 | 0 | 0
JUN | 20 | 9 | 2 |  | JUN | 0 | 0 | 0
JUL | 20 | 5 | 4 |  | JUL | 0 | 0 | 0
AGO | 13 | 10 | 2 |  | AGO | 0 | 0 | 0
SET | 24 | 8 | 2 |  | SET | 0 | 0 | 0
OUT | 21 | 8 | 2 |  | OUT | 0 | 0 | 0
NOV | 27 | 11 | 5 |  | NOV | 0 | 0 | 0
DEZ | 32 | 14 | 1 |  | DEZ | 0 | 0 | 0
TOTAL | 259 | 122 | 33 |  | TOTAL | 0 | 0 | 0
 | QTD FRETE |  |  |  | QTD DEVOLUÇÃO GERAL |  |  | QTD DEVOLUÇÃO GERAL
MÊS | CLIENTE | RICARDO | TRANSP. |  | MÊS | QUANTIDADE |  | MÊS | QUANTIDADE
JAN | 11 | 13 | 12 |  | JAN | 36 |  | JAN | 21
FEV | 8 | 8 | 6 |  | FEV | 22 |  | FEV | 29
MAR | 1 | 36 | 8 |  | MAR | 45 |  | MAR | 21
ABR | 5 | 24 | 9 |  | ABR | 38 |  | ABR | 25
MAI | 17 | 2 | 14 |  | MAI | 33 |  | MAI | 23
JUN | 8 | 17 | 6 |  | JUN | 31 |  | JUN | 16
JUL | 15 | 5 | 9 |  | JUL | 29 |  | JUL | 27
AGO | 15 | 4 | 6 |  | AGO | 25 |  | AGO | 25
SET | 8 | 17 | 9 |  | SET | 34 |  | SET | 23
OUT | 14 | 10 | 7 |  | OUT | 31 |  | OUT | 10
NOV | 2 | 38 | 3 |  | NOV | 43 |  | NOV | 15
DEZ | 14 | 17 | 16 |  | DEZ | 47 |  | DEZ | 10
TOTAL | 118 | 191 | 105 |  | TOTAL | 414 |  | TOTAL | 245
Spreadsheet: 804472d1668094274-ref-error-customer-forcast-sheet
Sheet: Part 2

Supplier Release Planning Schedule
Customer Part Number: |  | Part 2
Vendor Part Number:
Customer:
Ship To ID: |  |  |  |  | Purchase Order Number: |  | 223794
Ship To Name: |  |  |  |  | Release Number: |  | ABC
Ship To Address: |  |  |  |  | Date: |  | 2022-11-08 00:00:00
 |  |  |  |  | Release Type: |  | Replace
 |  |  |  |  | Model Year:
Buyer:
Standard Pack Size: |  | 1000 | EA
[NAME]: |  | 0 | Last Shipment ID: |  | 123
Last Receipt Date: |  | 2022-01-03 00:00:00 | Cum YTD Required: |  | 0
 |  |  | Cum YTD Received: |  | 0
Part Release Status: |  |  | Late Quantity: |  | 0
Raw Material YTD Cum: |  | 0 | Fabrication YTD Cum: |  | 0
 |  |  | Revision Level:
Delivery Date | Net Required | Cum Quantity | Period | Auth Type | End Date | Previous Release | Net Change
2022-11-08 00:00:00 | 0 | 0 | Day | Firm |  | 0 | 0
2022-11-09 00:00:00 | 0 | 0 | Day | Firm |  | 0 | 0
2022-11-10 00:00:00 | 0 | 0 | Day | Firm |  | 0 | 0
2022-11-11 00:00:00 | 0 | 0 | Day | Firm |  | 0 | 0
2022-11-12 00:00:00 | 0 | 0 | Day | Firm |  | 0 | 0
2022-11-13 00:00:00 | 0 | 0 | Day | Firm |  | 0 | 0
2022-11-14 00:00:00 | 0 | 0 | Day | Firm |  | 0 | 0
2022-11-15 00:00:00 | 0 | 0 | Day | Firm |  | 0 | 0
2022-11-16 00:00:00 | 0 | 0 | Day | Firm |  | 0 | 0
2022-11-17 00:00:00 | 0 | 0 | Day | Firm |  | 0 | 0
2022-11-18 00:00:00 | 0 | 0 | Day | Firm |  | 0 | 0
2022-11-19 00:00:00 | 0 | 0 | Day | Firm |  | 0 | 0
2022-11-20 00:00:00 | 0 | 0 | Day | Firm |  | 0 | 0
2022-11-21 00:00:00 | 0 | 0 | Day | Fab |  | 0 | 0
2022-11-28 00:00:00 | 0 | 0 | Week | Fab |  | 0 | 0
2022-12-05 00:00:00 | 0 | 0 | Week | Fab |  | 0 | 0
2022-12-12 00:00:00 | 0 | 0 | Week | Raw |  | 0 | 0
2022-12-19 00:00:00 | 0 | 0 | Week | Raw |  | 0 | 0
2022-12-26 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
2023-01-02 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
2023-01-09 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
2023-01-16 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
2023-01-23 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
2023-01-30 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
2023-02-06 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
2023-02-13 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
2023-02-20 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
2023-02-27 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
2023-03-06 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
2023-03-13 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
2023-03-20 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
2023-03-27 00:00:00 | 0 | 0 | Week | Forecast |  | 0 | 0
Special Notes
Upon renewals or change in status,
copies of your quality certification:
It is the vendors responsibility to verify that th
not match, please call me immediately at
Cums are expected to be verified on a weekly basis
It is the vendors responsibility to ship to schedu
e the responsibility of the supplier.  Failure to
ult in a SNCR issued.  Any missed shipments must b
ediately.    If you are going to miss a shipment,
, with as much advance warning as po
release are delivery dates, NOT ship dates.
Spreadsheet: 102415d1300360553-charting-horizontal-data-dynamically-768576
Sheet: Chart

 |  |  |  |  | Date | Production |  |  |  |  |  |  | Date | Quality
Date: | 2011-03-07 00:00:00 | 2011-03-08 00:00:00 | 2011-03-09 00:00:00 | 2011-03-10 00:00:00 | 2011-03-11 00:00:00 | 2011-03-12 00:00:00 | 2011-03-13 00:00:00 | 2011-03-14 00:00:00 | 2011-03-15 00:00:00 | 2011-03-16 00:00:00 | 2011-03-17 00:00:00 | 2011-03-18 00:00:00
Production: | 1000 | 1200 | 1400 | 1600 | 1800 | 2000 | 2200 | 2400 | 2600
Quality: | 0.985 | 0.95 | 0.99 | 1 | 0.975 | 0.985 | 0.985 | 0.975 | 0.99
Errors: | 2 | 5 | 1 | 0 | 3 | 2 | 2 | 3 | 1
Hours: | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
Spreadsheet: 96b9029e-01c2-4025-874c-8b54447b28f4
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
HLA15 | Test | HLA15 | HLA-B 1502 Genotype, Carbamazepine Hypersensitivity | HLAB 1502 Genotype, [NAME] | Allele-Specific Polymerase Chain Reaction (PCR) Amplification (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Lavender-top (EDTA) Tube: EDTA |  |  | 3 | mL | Multiple whole blood EDTA genotype tests can be performed on a single specimen after a single extraction. See Multiple Whole Blood EDTA Genotype Tests in Special Instructions for a list of tests that can be ordered together.  Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions: Send specimen in original tube. Additional Information: Transfusions will interfere with testing for up to 4 to 6 weeks. DNA obtained from white cells may not provide useful information for patients who received a recent transfusion of blood that was not leukocyte-reduced. Wait 4 to 6 weeks until transfused cells have left the patient's circulation before drawing the patient's blood specimen for genotype testing. 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. | 0.3 mL | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Tuesday, Friday | 1 day | 5 days | 1 | 81381 |  |  |  |  | Rochester
HLA15 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
HLA15 | Result | 89347 | HLA-B 1502 Result | HLA-B 1502 Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57979-7
HLA15 | Result | 29317 | HLA-B 1502 Interpretation | HLA-B 1502 Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
HLA15 | Result | 29318 | HLA-B 1502 Reviewed by | HLA-B 1502 Reviewed by | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 138619d1327768574-excel-2007-performing-calculations-in-cells-2012-income
Sheet: last apr

2011-04-26 00:00:00
0 |  | yes | Amount | Taxable Merch | Shipping Taxable | Sales Tax Payable | Non- taxable Merch | Shipping Non-Taxable | Income tax Income | MiscellaneousNon- Taxable | Owner Loan
Received From | Check No | Invoices Paid | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 488813d1478844914-automate-calculations-on-a-database-vlookup_hb47
Sheet: Data

Name | City | Address | Mobile Number
Mark | New York | 24, abc | 1111111111
AAA | Aaaaa | 25 agh | 1111111112
BBB | [NAME] | 26 abd | 1111111113
CCC | Caaa | 27 adg | 1111111114
DDD | Ddddd | 28 djdjd | 1111111115
EEE | Eeeee | 29 pdod | 1111111116
FFF | [NAME] | 30 djdiem | 1111111117
GGG | Gggg | 31 ddfdfd | 1111111118
HHH | Hhhhhh | 32 dfdfojf | 1111111119
JJJ | Jjjjj | 33 fjafi | 1111111120
Spreadsheet: 820994d1678377093-formula-to-work-out-hours-worked-with-parameters-sample_median
Sheet: Sheet1

 | Date of Work | Start Time | End Time | Hours worked in hours 08:00 -18:00 | Hours worked out of hours 18:00-08:00 & Weekends | Total
 | 2022-05-01 00:00:00 | 05:00:00 | 16:00:00
 | 2022-05-02 00:00:00 | 16:00:00 | 22:00:00
 | 2022-05-03 00:00:00 | 23:00:00 | 06:00:00
 | 2022-05-04 00:00:00 | 15:00:00 | 19:00:00
 | 2022-05-05 00:00:00 | 07:00:00 | 12:00:00
Spreadsheet: eric_saibi__9959__110801R
Sheet: Hay Road 04 ST

Owner Name |  | [NAME]
Station Name |  | Hay Road Power Station
Unit Name |  | Unit 04 ST
NERC Region |  | MAAC
State |  | DE
Fuel Type |  | Waste Heat
Capacity |  | 160 MW
Start Date |  | 2001-11-10 00:00:00
End Date |  | 2001-12-07 00:00:00
Prv. Start Date |  | 2001-11-09 00:00:00
Prv. End Date |  | 2001-12-06 00:00:00
Comments |  | High Pressure Turb Insp.
SIC |  | 4931
Plant ID |  | 1008431
Unit ID |  | 1008387
Outage ID |  | 17262
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 14d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other |  | IG | Other
Index Tranche | 41 | 98 | 47 | 11 | 76 | 13
Index | 2081 | 2606 | 3292 | 3202 | 2217 | 2174
OTHER* | - | - | 199 | - | - | 149
TOTAL | 2122 | 2704 | 3538 | 3213 | 2293 | 2336
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 701270d1603676839-looking-for-a-formula-to-count-the-number-of-times-a-specific-value-appears-in-sequence-in-sample-5
Sheet: Sample

Positive | Negative | False/Fail | 1 | [NAME] | Expected Answers
 | 1
1
 |  | 1
 |  | 1
 | 1
 | 1
 |  | 1
 | 1 |  |  |  | 3
1
 | 1
 |  | 1
 |  | 1
 |  | 1 |  |  | 1
1
 | 1
 |  | 1
 | 1
 | 1 |  |  |  | 3
1
1
 | 1
 | 1
 | 1
 |  | 1
 | 1
 | 1
 | 1 |  |  |  | 6
1
 | 1
 | 1
 | 1
 | 1
 |  | 1
 | 1 |  |  |  | 5
1
 |  | 1
 |  | 1
 | 1
 | 1 |  |  |  | 2
1
Spreadsheet: 875581d1722188877-how-to-make-index-work-after-drag-solved-test
Sheet: юни

№ | Name | 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
 |  | RED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BROWN
Spreadsheet: 219404d1362750487-copying-a-formula-but-changing-a-row-reference-sample080313
Sheet: Data

 |  | January |  | February
 | Sales table 1 | Target Jan | Actual Jan | Target Feb | Actual  Feb
 | Metric 1 | 1 | 2 | 29 | 28
 | Metric 2 | 2 | 3 | 30 | 29
 | Metric 3 | 0.03 | 0.04 | 0.31 | 0.3
 | Metric 4 | 4 | 5 | 32 | 31
 | Metric 5 | 5 | 6 | 33 | 32
 | Metric 6 | 6 | 7 | 34 | 33
 | Metric 7 | 7 | 8 | 35 | 34
 | Metric 8 | 8 | 9 | 36 | 35
 | Metric 9 | 0.09 | 0.1 | 0.37 | 0.36
 | Metric 10 | 10 | 11 | 38 | 37
 | Metric 11 | 11 | 12 | 39 | 38
 | Metric 12 | 12 | 13 | 40 | 39
 | Metric 13 | 13 | 14 | 41 | 40
 | Metric 14 | 14 | 15 | 42 | 41
 | Metric 15 | 15 | 16 | 43 | 42
 | Metric 16 | 16 | 17 | 44 | 43
 | Metric 17 | 17 | 18 | 45 | 44
 | Metric 18 | 18 | 19 | 46 | 45
 | Metric 19 | 19 | 20 | 47 | 46
 | Metric 20 | 20 | 21 | 48 | 47
 | Metric 21 | 21 | 22 | 49 | 48
 | Metric 22 | 22 | 23 | 50 | 49
 | Metric 23 | 23 | 24 | 51 | 50
 | Metric 24 | 24 | 25 | 52 | 51
 | Metric 25 | 25 | 26 | 53 | 52
 | Metric 26 | 26 | 27 | 54 | 53
 | Metric 27 | 27 | 28 | 55 | 54
 | Sales table 2 | Target Jan | Actual Jan | Target Feb13 | Actual Feb13
 | Metric 1 | 1 | 2 | 29 | 28
 | Metric 2 | 2 | 3 | 30 | 29
 | Metric 3 | 0.03 | 0.04 | 0.31 | 0.3
 | Metric 4 | 4 | 5 | 32 | 31
 | Metric 5 | 5 | 6 | 33 | 32
 | Metric 6 | 6 | 7 | 34 | 33
 | Metric 7 | 7 | 8 | 35 | 34
 | Metric 8 | 8 | 9 | 36 | 35
 | Metric 9 | 0.09 | 0.1 | 0.37 | 0.36
 | Metric 10 | 10 | 11 | 38 | 37
 | Metric 11 | 11 | 12 | 39 | 38
 | Metric 12 | 12 | 13 | 40 | 39
 | Metric 13 | 13 | 14 | 41 | 40
 | Metric 14 | 14 | 15 | 42 | 41
 | Metric 15 | 15 | 16 | 43 | 42
 | Metric 16 | 16 | 17 | 44 | 43
 | Metric 17 | 17 | 18 | 45 | 44
 | Metric 18 | 18 | 19 | 46 | 45
 | Metric 19 | 19 | 20 | 47 | 46
 | Metric 20 | 20 | 21 | 48 | 47
 | Metric 21 | 21 | 22 | 49 | 48
 | Metric 22 | 22 | 23 | 50 | 49
 | Metric 23 | 23 | 24 | 51 | 50
 | Metric 24 | 24 | 25 | 52 | 51
 | Metric 25 | 25 | 26 | 53 | 52
 | Metric 26 | 26 | 27 | 54 | 53
 | Metric 27 | 27 | 28 | 55 | 54
Spreadsheet: 73976d1274551539-drop-down-list-query-validation-list
Sheet: All in One with Formula

[NAME] | <<<<<<<<
Names |  |  | Remove Blanks | Unique Values | Sotring Values |  |  | Sorted Unique Values in one Column
[NAME] |  |  | [NAME] | [NAME] | 8 | [NAME] |  | [NAME]
 |  |  | [NAME] | [NAME] | 7 | [NAME] |  | [NAME]
[NAME] |  |  | [NAME] | [NAME] | 4 | [NAME] |  | [NAME]
[NAME] |  |  | [NAME] | [NAME] | 9 | [NAME] |  | [NAME]
MOBIL 1 |  |  | [NAME] | [NAME] | 5 | [NAME] |  | [NAME]
 |  |  | [NAME] | [NAME] | 1 | MOBIL 1 |  | MOBIL 1
[NAME] |  |  | [NAME] | [NAME] | 2 | [NAME] |  | [NAME]
[NAME] |  |  | [NAME] | [NAME] | 10 | [NAME] |  | [NAME]
 |  |  | [NAME] | [NAME] | 3 | [NAME] |  | [NAME]
[NAME] |  |  | [NAME] | MOBIL 1 | 6 | [NAME] |  | [NAME]
 |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | MOBIL 1
 |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 751003d1633773604-vloopup-formula-not-working-properly-please-help-hyd_set1
Sheet: Sheet1

S No | Vehicle Register Number | Information requied for Period
1 | AP01A1121 | 01.01.2017 to till date
2 | AP01A1234 | 01.01.2017 to till date
3 | AP01A3311 | 01.01.2017 to till date
4 | AP01A4332 | 01.01.2017 to till date
5 | AP01A4587 | 01.01.2017 to till date
6 | AP01A9876 | 01.01.2017 to till date
7 | AP01T1294 | 01.01.2017 to till date
8 | AP01T2033 | 01.01.2017 to till date
9 | AP01T6588 | 01.01.2017 to till date
10 | AP01T6858 | 01.01.2017 to till date
11 | AP01T6957 | 01.01.2017 to till date
12 | AP01T7128 | 01.01.2017 to till date
13 | AP01TA0508 | 01.01.2017 to till date
14 | AP01TA1301 | 01.01.2017 to till date
15 | AP01TA1364 | 01.01.2017 to till date
16 | AP01TB0266 | 01.01.2017 to till date
17 | AP01TJ1654 | 01.01.2017 to till date
18 | AP01U1235 | 01.01.2017 to till date
19 | AP01U2565 | 01.01.2017 to till date
20 | AP01U4048 | 01.01.2017 to till date
21 | AP01U4559 | 01.01.2017 to till date
Spreadsheet: 851281d1701507210-excel-trendline-formula-errors-excelforum
Sheet: Sheet1

Given x | Given Y |  | X | Forecasted Y based on trendline formula
2019 | 85243 |  | 2019
2020 | 75055 |  | 2020
2021 | 71190 |  | 2021
2022 | 86123 |  | 2022
2023 | 104309 |  | 2023
 |  |  | INT
 |  |  | SLOPE
Spreadsheet: 692560d1598433824-vlookup-a-specific-word-vlookup-word
Sheet: Sheet1

 | Job No. | [NAME] required in this column |  |  |  |  |  | Job No.
 | 1234 | Cleared |  |  |  |  |  | 1234 | SIP PCNF
 | 2345 | Cleared |  |  |  |  |  | 2345 | CIP SIP RKPD
 | 3456 | Yet to clear |  |  |  |  |  | 3456 | EOP  NREL NSHP
 | 4567 | Yet to clear |  |  |  |  |  | 4567 | CIP SIP RKSP
 | 5678
 | 1. [NAME] to find SIP in column J and if found, the text to be appeared as "Cleared".   2. If the job no. is existing and not having SIP, the text to be appeared as "Yet to Clear".  3. If the column J is having SIP and also RKSP, the text to be appeared as "Yet to Clear"  4. If Job No. not matching, the field to remain blank. (Solution filled in Col.C for your ready reference)
Spreadsheet: 773634d1647966248-suggestions-with-random-groups-stdev-add-on-to-nicks-worksheet
Sheet: Sheet1

Student | Score | Quartile |  |  | Q1 | Q2 | Q3 | Q4 | Test
a | 90 |  |  | Group1
b | 86 |  |  | Group2
c | 39 |  |  | Group3
d | 27 |  |  | Group4
e | 38 |  |  | Group5
f | 51
g | 49
h | 87 |  |  |  | Using [NAME] work, I've added scores for each team to the right
i | 78 |  |  |  | Then Sum the teams scores and look at the yellow cell to see
j | 5 |  |  |  | how close each team is to equal.  [NAME] many times to find the
k | 17 |  |  |  | smallest yellow value.  That would be the best arrangement.
l | 85
m | 74
n | 25
o | 47
p | 36
q | 16
r | 76
s | 2
t | 39