tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 708354d1607756232-functions-on-excel-search-and-copy-if-it-is-found-excel
Sheet: Report v2

Count | Datum | Incident number | DZC / Name | Affect. App | Issue Cat. | Issue Sub Category | Unknown Categories | Information
1 | 2020-12-03 00:00:00 | IR10540409 | DZCN3FP | MDA | Remote Air Conditioning | missing services in the app | missing services in app
2 | 2020-12-03 00:00:00 | IR10542216 | DZCN3FP | CWP & MDA | [NAME] | Unable to enroll
3 | 2020-12-03 00:00:00 | IR10540281 | DZCN3FP | MDA |  | missing text on the wizard of first time open app | wizard on first start of app
4 | 2020-12-03 00:00:00 | RR10126857 | DZCN3FP | CWP & MDA | [NAME] | SPIN issue additional info
5 | 2020-12-03 00:00:00 | IR10546491 | DZCN3FP | MDA | [NAME] | Login issue
6 | 2020-12-03 00:00:00 | IM77847102 | DZCN3FP | CWP | Login CWP | Unable to remove account CWP
7 | 2020-12-03 00:00:00 | RR10024138 | DZCN3FP | CWP | Login CWP | Unalbe to remove his account
8 | 2020-12-03 00:00:00 | IR10546122 | DZCN3FP | CWP & MDA | [NAME] | enrollment issue
9 | 2020-12-03 00:00:00 | IR10540281 | DZCN3FP | MDA |  | missing text on the wizard of first time open app
10 | 2020-12-04 00:00:00 | RR10024138 | DZCN3FP | CWP | Login CWP | Unalbe to remove his account
11 | 2020-12-04 00:00:00 | IR10550653 | DZCN3FP | MDA | RAH | unable to start RAH or any service
12 | 2020-12-04 00:00:00 | IR10540281 | DZCN3FP | MDA |  | missing text on the wizard of first time open app
13 | 2020-12-04 00:00:00 | IR10550468 | DZCN3FP | CWP & MDA | [NAME] | unable to enroll vehicle
14 | 2020-12-04 00:00:00 | IR10551414 | DZCN3FP | CWP & MDA | Registration MDA | Unable to add VIN in his APP/CWP
15 | 2020-12-04 00:00:00 | IR10540409 | DZCN3FP | MDA | Remote Air Conditioning | missing services in the app | missing services in app
16 | 2020-12-04 00:00:00 | IR10465302 | DZCN3FP | MDA | Registration MDA | Unable to enroll MOD1 via APP
17 | 2020-12-04 00:00:00 | IR10486970 | DZCN3FP | MDA | Registration MDA | unable to load garage
18 | 2020-12-04 00:00:00 | IR10557211 |  | CWP |  |  | routing ticket from CWP
19 | 2020-12-04 00:00:00 | RR10190286 |  | MDA | Driving Data | sees old data
20 | 2020-12-04 00:00:00 | IR10536817 |  | CWP & MDA | Login CWP | unable to login CWP and MDA
21 | 2020-12-04 00:00:00 | IR10546254 |  | MDA | RAH | Does not work
 |  | IR10536817
Spreadsheet: 880675d1728509589-formula-only-once-date-triggers-excel-help-bvj-
Sheet: Sheet1

Year Start | 2025-01-01 00:00:00
Schedule | Ramp Up |  | Product | [NAME] | Initial Production Date
Month 1 | 0.25 |  | Blue | 100 | 2025-01-01 00:00:00
Month 2 | 0.5 |  | Red | 150 | 2025-02-01 00:00:00 |  | 0
Month 3 | 0.75 |  | Green | 200 | 2025-06-01 00:00:00 |  | 0 | 0 | 0 | 0 | 0
Month 4+ | 1
Spreadsheet: 57238d1257357817-summing-total-per-customer-for-each-month-wnstar21
Sheet: Sheet1

Amount | Customer | Ship Date |  |  |  | A | B | C
18.343 | A | 2009-09-30 00:00:00 |  |  | 2009-09-01 00:00:00 | 54.249 | 0 | 0
18.198 | A | 2009-09-30 00:00:00 |  |  | 2009-10-01 00:00:00 | 162.299 | 39.26900000000001 | 0
17.708 | A | 2009-09-30 00:00:00 |  |  | 2009-11-01 00:00:00 | 0 | 0 | 0
19.623 | B | 2009-10-16 00:00:00
17.717 | A | 2009-10-08 00:00:00
15.004 | A | 2009-10-08 00:00:00
10.623 | A | 2009-10-08 00:00:00
10.913 | A | 2009-10-14 00:00:00 |  |  | Sum of Amount | Customer
10.004 | A | 2009-10-14 00:00:00 |  |  | Ship Date | A | B | C | Grand Total
10.958 | A | 2009-10-14 00:00:00 |  |  | Sep | 54.249 |  |  | 54.249
11.094 | A | 2009-10-14 00:00:00 |  |  | Oct | 180.424 | 39.26900000000001 | 16.066 | 235.759
15.837 | A | 2009-10-21 00:00:00 |  |  | Nov | 49.55928399999999 |  |  | 49.55928399999999
17.545 | A | 2009-10-21 00:00:00 |  |  | Grand Total | 284.232284 | 39.26900000000001 | 16.066 | 339.567284
11.004 | A | 2009-10-21 00:00:00
19.646 | B | 2009-10-30 00:00:00
15.8 | A | 2009-10-28 00:00:00
15.8 | A | 2009-10-28 00:00:00
18.125 | A | 2009-10-28 00:00:00
16.066 | C | 2009-10-30 00:00:00
18.107 | A | 2009-11-04 00:00:00
15.023 | A | 2009-11-04 00:00:00
16.429284 | A | 2009-11-11 00:00:00
Spreadsheet: 672224d1586797617-formula-add-degree-sign-min-sign-and-sec-sign-to-a-cell-degrees-minutes-seconds-display
Sheet: Sheet1

 |  |  |  |  |  |  |  | Way 1 | Way 2
 | Ket | 0 | 0 | 0 |  |  | Ket
 | Ven | 0 | 2 | 43 |  |  | Ven
 | Sun | 0 | 10 | 30 |  |  | Sun |  |  |  |  | ° | alt0176
 | [NAME] | 0 | 12 | 50 |  |  | [NAME]
 | Mar | 0 | 16 | 44 |  |  | Mar |  |  |  |  | ’ | [NAME]
 | Rah | 0 | 19 | 27 |  |  | Rah
 | Jup | 0 | 26 | 27 |  |  | Jup |  |  |  |  | ” | alt0148
 | Sat | 0 | 32 | 40 |  |  | Sat
 | Mer | 0 | 40 | 4 |  |  | Mer
 | Ven | 0 | 46 | 40 |  |  | Ven
 | Sun | 1 | 8 | 52 |  |  | Sun
 | [NAME] | 1 | 15 | 32 |  |  | [NAME]
 | Mar | 1 | 26 | 39 |  |  | Mar
 | Rah | 1 | 34 | 26 |  |  | Rah
 | Jup | 1 | 54 | 26 |  |  | Jup
 | Sat | 2 | 12 | 13 |  |  | Sat
 | Mer | 2 | 33 | 20 |  |  | Mer
 | Ket | 2 | 52 | 13 |  |  | Ket
 | Sun | 3 | 0 | 0 |  |  | Sun
 | [NAME] | 3 | 2 | 0 |  |  | [NAME]
 | Mar | 3 | 5 | 20 |  |  | Mar
 | Rah | 3 | 7 | 40 |  |  | Rah
 | Jup | 3 | 13 | 40 |  |  | Jup
 | Sat | 3 | 19 | 0 |  |  | Sat
 | Mer | 3 | 25 | 20 |  |  | Mer
 | Ket | 3 | 31 | 0 |  |  | Ket
 | Ven | 3 | 33 | 20 |  |  | Ven
 |  |  |  |  |  |  |  |  | I need help with a formula that will  copy from C2 add degree °sign
 |  |  |  |  |  |  |  |  | copy from D2 add min  ’sign and copy e2 add the sec ”
 |  |  |  |  |  |  |  |  | all these will appear in I2
Spreadsheet: 64556d1265378664-cross-referencing-materials
Sheet: Sheet1

Item Code | Size |  |  | Qty. | Material |  | SIZE | MATERIALS
EN25 | 114 | x | 235 | 360000 | Manilla 90 |  |  | Manilla 80 | Manilla 90 | White 80 | White 90 | White 100
RO059/5 | 114 | x | 229 | 2000000 | White 80 |  | 92 |  |  | 2000000
STW2200 | 120 | x | 235 | 60000 | White 90 |  | 102 | 50000
FXUK21916/2 | 162 | x | 240 | 240000 | White 80 |  | 110
DLENV-TNT | 120 | x | 235 | 2000000 | White 90 |  | 114 |  | 2247000 | 2050000
RML4175 | 162 | x | 235 | 40000 | White 90 |  | 120 | 8500 | 56000 |  | 2260000 | 490000
[NAME] | 114 | x | 235 | 50000 | White 80 |  | 155
BRE-508 | 102 | x | 216 | 50000 | Manilla 80 |  | 162 |  |  | 2390000 | 260000 | 10000
DLENV-CWC | 120 | x | 235 | 30000 | White 90
PAY0010 | 120 | x | 235 | 40000 | White 100 |  | In this example, white 80 appears as a material, 6 times in the list to the left and in 3 different sizes
RO059/6 | 92 | x | 210 | 2000000 | White 80 |  | The list above, has alloted the the TOTAL amount to each size.
EN246 | 114 | x | 225 | 1875000 | Manilla 90 |  | (If you select a result cell, you will see where the values have come from in the formula bar)
BUD0002 | 162 | x | 235 | 25000 | White 90
RML4174 | 162 | x | 235 | 10000 | White 100
PAY0004 | 120 | x | 235 | 150000 | White 90
PAY0005 | 120 | x | 235 | 450000 | White 100
RSR0007 | 162 | x | 235 | 70000 | White 90
RML4301 | 162 | x | 235 | 150000 | White 80
WIN002 | 120 | x | 235 | 20000 | White 90
GMC0003 | 162 | x | 235 | 75000 | White 90
GMC0007 | 162 | x | 235 | 50000 | White 90
RO059/5 | 162 | x | 229 | 2000000 | White 80
EN246E900 | 120 | x | 225 | 12000 | Manilla 90
EN246E901 | 120 | x | 225 | 8500 | Manilla 80
EN246E902 | 114 | x | 225 | 12000 | Manilla 90
EN246E903 | 120 | x | 225 | 44000 | Manilla 90
 | Only the first size (as in col B) is significant.
Spreadsheet: 465515d1465730508-dashboard-help-book46
Sheet: Dashboard

PM | Project Start KPI | Project Report KPI
[NAME] | 0 | 5
[NAME] T | 0 | 0
[NAME] A | 3 | 1
Laurne L | 3 | 7
[NAME] O | 9 | 0
[NAME] | 8 | 2
PM | 3 | 2
Ricky R | 2 | 7
Sundeep T | 1 | 0
Spreadsheet: 945ac3c2-6d01-421b-8c2e-1ac1817960f3
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
VITK1 | Test | VITK1 | [NAME], Serum | [NAME], S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) |  |  |  | 2 | mL | Collection Container/Tube: Red top Submission Container/Tube: Amber vial (Supply T192) [NAME]: 2 mL Collection Instructions: 1. Fasting-overnight (12-14 hours) (infants-draw prior to next feeding). 2. Send specimen in amber vial to protect from light. | 0.75 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK  Lipemia	Mild reject; Gross reject Icterus	NA Other	NA | > or =18 years: 0.10-2.20 ng/mL <18 years: not established | Monday through Friday; 1st shift | 2 days | 4 days | 1 | 84597 |  |  |  |  | New England
VITK1 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
VITK1 | Result | 62167 | [NAME], S | [NAME], S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 9622-2 | Phytonadione:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 689708d1596609820-if-function-exceeding-8000-character-limit-need-help-on-shorter-formula-au-and-nz-vendor-margin-analysis-fy20-ytd-test
Sheet: March NZ

Margin and Sales by Vendor - March 2020
Vendor | Sales | Margin $ | Margin %
F5 | 1 | 1
NetApp | 1 | 1
Palo Alto Networks | 1 | 1
Ribbon | 1 | 1
Riverbed | 1 | 1
Cylance | 1 | 1
Tenable | 1 | 1
Channel Services | 1 | 1
Cohesity | 1 | 1
Extreme Networks | 1 | 1
Avaya | 1 | 1
CS Vendors | 1 | 1
Grand Total
Spreadsheet: 159493d1338709158-formula-to-count-word-occurrence-for-every-nth-cell-book1
Sheet: Sheet1

2012-01-01 00:00:00 |  |  |  | 1 | M | 4
2012-01-02 00:00:00 |  |  |  | 2 | T | 4
2012-01-03 00:00:00 |  |  |  | 3 | W | 4
2012-01-04 00:00:00 |  |  |  | 4 | T | 4
2012-01-05 00:00:00 |  |  |  | 5 | F | 3
2012-01-06 00:00:00 |  |  |  | 6 | S | 3
2012-01-07 00:00:00 |  |  |  | 7 | S | 4
2012-01-08 00:00:00
2012-01-09 00:00:00
2012-01-10 00:00:00
2012-01-11 00:00:00
2012-01-12 00:00:00
2012-01-13 00:00:00
2012-01-14 00:00:00
2012-01-15 00:00:00
2012-01-16 00:00:00
2012-01-17 00:00:00
2012-01-18 00:00:00
2012-01-19 00:00:00
2012-01-20 00:00:00
2012-01-21 00:00:00
2012-01-22 00:00:00
2012-01-23 00:00:00
2012-01-24 00:00:00
2012-01-25 00:00:00
2012-01-26 00:00:00
Spreadsheet: errol_mclaughlin_jr__10058__Budget Temp
Sheet: Summary

E N R O N   N et Works
2 0 0 2   P L A N
 | SAP PROFIT CENTER: |  | Risk Mgmt
 | PROFIT CENTER OWNER: |  | Summary
 | SAP COST CENTER: |  |  |  |  |  |  |  |  |  |  |  | DUE DATE:
 | TOTAL HEADCOUNT - including Contractors
 | DIRECT EXPENSES |  | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | Total
 | Compensation
 | Benefits and Payroll Taxes
 | Employee Expenses
 | Communication Expense
 | Infrastructure
 | Outside Services - IT
 | Outside Services
 | Office Supplies
 | Advertising Expense
 | Charitable Contributions
 | Rent (3rd Party)
 | Technology
 | Transportation
 | EPSC Allocation
 | A & A Allocation
 | Other Expenses
 | Depreciation & Amortization
 | Taxes Other than Income
 | TOTAL DIRECT EXPENSES
 | TOTAL ALLOCATED EXPENSES
 | TOTAL EXPENSES
Spreadsheet: 26fe1ed3-b954-4f23-806d-743e4dd74abb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
EPA SPREADSHEET
SIN | Manufacturer | Manufacturer Part # | GSA or Dealer Part # | Product Description | Current Approved Commercial Price List | Proposed Commercial Price List | $ Change | % Change | [NAME] | [NAME] | Current GSA Price Including IFF | Proposed  GSA Price Including IFF | COO | Reason for Increase
302-49 | ACME | 123ABC | same | Ice Machine | 2000 | 2100 | 100 | 0.05 | 0.05 | 0.1 | 1813.60201511335 | 1904.282115869018
Spreadsheet: 861919d1709746497-update-vertical-price-tables-via-horizontal-price-sheet-please-see-below-data-examples-acme-test
Sheet: Price Sheet 

Part Number | MOQ QTY | PRICE 1 | Part Number | QTY | PRICE2 | Part Number | QTY | PRICE 3 | Part Number | QTY | PRICE 4
COL0809Z1 | 2000 | 0.5266 | COL0809Z1 | 5000 | 0.3435 | COL0809Z1 | 10000 | 0.3006 | COL0809Z1 | 25000 | 0.2195
COL1407Z1 | 2000 | 0.4841 | COL1407Z1 | 5000 | 0.2814 | COL1407Z1 | 10000 | 0.2433 | COL1407Z1 | 25000 | 0.2195
COL1409Z1 | 2000 | 0.4841 | COL1409Z1 | 5000 | 0.2814 | COL1409Z1 | 10000 | 0.2433 | COL1409Z1 | 25000 | 0.2195
COL1411Z1 | 2000 | 0.5266 | COL1411Z1 | 5000 | 0.3435 | COL1411Z1 | 10000 | 0.3006 | COL1411Z1 | 25000 | 0.2768
COL1413Z1 | 2000 | 0.552 | COL1413Z1 | 5000 | 0.3816 | COL1413Z1 | 10000 | 0.3342 | COL1413Z1 | 25000 | 0.3102
COL1415Z1 | 2000 | 0.5681 | COL1415Z1 | 5000 | 0.3748 | COL1415Z1 | 10000 | 0.3294 | COL1415Z1 | 25000 | 0.299
COL1417Z1 | 2000 | 0.6006 | COL1417Z1 | 5000 | 0.4113 | COL1417Z1 | 10000 | 0.3691 | COL1417Z1 | 25000 | 0.3172
COL4013Z1 | 1000 | 0.9494 | COL4013Z1 | 5000 | 0.7453 | COL4013Z1 | 10000 | 0.6879 | COL4013Z1 | 25000 | 0.6441
COL4015Z1 | 1000 | 1.0064 | COL4015Z1 | 5000 | 0.8148 | COL4015Z1 | 10000 | 0.7739 | COL4015Z1 | 25000 | 0.7578
COL4017Z1 | 1000 | 1.1009 | COL4017Z1 | 5000 | 0.933 | COL4017Z1 | 10000 | 0.8797 | COL4017Z1 | 25000 | 0.8358
COL4611Z1 | 1000 | 0.8779 | COL4611Z1 | 5000 | 0.6966 | COL4611Z1 | 10000 | 0.6488 | COL4611Z1 | 25000 | 0.6201
COL4613Z1 | 1000 | 0.9656 | COL4613Z1 | 5000 | 0.8011 | COL4613Z1 | 10000 | 0.7461 | COL4613Z1 | 25000 | 0.7133
COL4615Z1 | 1000 | 0.9829 | COL4615Z1 | 5000 | 0.8301 | COL4615Z1 | 10000 | 0.8205 | COL4615Z1 | 25000 | 0.792
COL4617Z1 | 1000 | 1.2019 | COL4617Z1 | 5000 | 0.963 | COL4617Z1 | 10000 | 0.8903 | COL4617Z1 | 25000 | 0.844
COL4809Z1 | 1000 | 0.8874 | COL4809Z1 | 5000 | 0.7348 | COL4809Z1 | 10000 | 0.7014 | COL4809Z1 | 25000 | 0.6823
COL4811Z1 | 1000 | 0.9542 | COL4811Z1 | 5000 | 0.8205 | COL4811Z1 | 10000 | 0.7824 | COL4811Z1 | 25000 | 0.7728
COL4813Z1 | 1000 | 0.9781 | COL4813Z1 | 5000 | 0.8779 | COL4813Z1 | 10000 | 0.835 | COL4813Z1 | 25000 | 0.8016
COL4815Z1 | 1000 | 0.9925 | COL4815Z1 | 5000 | 0.8874 | COL4815Z1 | 10000 | 0.8493 | COL4815Z1 | 25000 | 0.8111
COL4817Z1 | 1000 | 1.2175 | COL4817Z1 | 5000 | 1.0553 | COL4817Z1 | 10000 | 0.9962 | COL4817Z1 | 25000 | 0.9486
COL5209Z1 | 1000 | 0.8969 | COL5209Z1 | 5000 | 0.7824 | COL5209Z1 | 10000 | 0.7441 | COL5209Z1 | 25000 | 0.7157
COL5211Z1 | 1000 | 1.002 | COL5211Z1 | 5000 | 0.8874 | COL5211Z1 | 10000 | 0.8493 | COL5211Z1 | 25000 | 0.8301
COL5213Z1 | 1000 | 1.0496 | COL5213Z1 | 5000 | 0.9255 | COL5213Z1 | 10000 | 0.8588 | COL5213Z1 | 25000 | 0.8396
COL5215Z1 | 1000 | 1.0496 | COL5215Z1 | 5000 | 0.9255 | COL5215Z1 | 10000 | 0.8588 | COL5215Z1 | 25000 | 0.8396
CC 3313Z1 | 1000 | 0.5 | CC 3313Z1 | 5000 | 0.33 | CC 3313Z1 | 10000 | 0.29
CC 3315Z1 | 1000 | 0.56 | CC 3315Z1 | 5000 | 0.39
CC 3317Z1 | 1000 | 0.58 | CC 3317Z1 | 5000 | 0.42
CCV0509Z1 | 1000 | 0.29 | CCV0509Z1 | 5000 | 0.21 | CCV0509Z1 | 10000 | 0.19
CCV0511Z1 | 1000 | 0.29 | CCV0511Z1 | 5000 | 0.21 | CCV0511Z1 | 10000 | 0.19 | CCV0511Z1 | 25000 | 0.18
Spreadsheet: 687535d1595264987-budgeting-spreadsheet-2020-07-20-oeldere-mbradley84-687514d1595257494-budgeting-spreadsheet-example-1
Sheet: Sheet1

 |  | Date Paid
Paycheck #1 | 1000 | 15th
Paycheck #2 | 500 | 26th
Paycheck #3 | 1000 | 31st
 |  |  |  |  | Bills | Due Date | Paycheck #1 | Paycheck #2 | Paycheck #3
 |  |  |  |  | Mortgage
 |  |  |  |  | Car Payment
Bills | Due Date | Amount |  |  | Electric
Mortgage | 1st | 1000 |  |  | Gas
Car Payment | 10th | 500 |  |  | Water
Electric | 12th | 60 |  |  | Insurance
Gas | 13th | 50 |  |  | Credit Card
Water | 27th | 40 |  |  | Totals
Insurance | 4th | 75
Credit Card | 18th | 100
Step 1
In B2 through B4 person will enter amount of paycheck
Step 2
In C2 through C5 person will enter date paid
Step 3
In A10 through A16 person will enter bills and in the following columns they will enter due dates and the amount due.  I would like the formula to only place the amount due in that box if it falls before or after the date paid they selected. (Example, I do not want to have it list the "Water" bill in the Column for Paycheck #1 or Paycheck #3.  Make sense?
Step 4
In the boxes H7 through K13 I would like a formula that will put the amount due based on paycheck date and due date of the bills, and I would also like to split the payments up as to not consume the entire paychecks (Ex. Mortgage is $1000.00 and would like that split up between at least two paychecks.
Ultimate goal is to have this calculate how much money from each check should be set aside to cover the bills for the entire month.  Which means that the totals in columns H, I, and J, cannot exceed the amounts of each paycheck.  Is that even possible?
Spreadsheet: 49441d1248796329-tabulating-multiple-voters-w-multiple-categories-ballot-tabulation
Sheet: Sheet3

Mode | 250 | 251 | 252 | 253 | 250 | 251 | 252 | 253 | 251 | 252 | 253
Count | 5 | 5 | 6 | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5
Voters | Most Interesting | Most Want to Drive | Most Abused Tires | Best Under Hood | Best Interior | Best Survivor | Best Restored Vehicle | Best Custom Vehicle | Best Import | Best Domestic | Best of Show
1 | 250 | 251 | 252 | 253 | 250 | 251 | 252 | 253 | 251 | 252 | 253
2 | 252 | 253 | 250 | 251 | 252 | 253 | 250 | 251 | 253 | 250 | 251
3 | 250 | 251 | 252 | 253 | 253 | 251 | 252 | 253 | 251 | 252 | 253
4 | 252 | 253 | 250 | 251 | 252 | 253 | 250 | 251 | 253 | 250 | 251
5 | 250 | 251 | 252 | 253 | 250 | 251 | 252 | 253 | 251 | 252 | 253
6 | 252 | 253 | 252 | 251 | 253 | 253 | 250 | 251 | 253 | 250 | 251
7 | 250 | 251 | 252 | 253 | 250 | 251 | 252 | 253 | 251 | 252 | 253
8 | 252 | 253 | 250 | 251 | 252 | 253 | 250 | 251 | 253 | 250 | 251
9 | 250 | 251 | 252 | 253 | 250 | 251 | 252 | 253 | 251 | 252 | 253
10 | 252 | 253 | 250 | 251 | 252 | 253 | 250 | 251 | 253 | 250 | 251
Spreadsheet: 229837d1366613417-copy-paste-cf-from-sheet-to-sheet-copy-paste-cf-problem
Sheet: Clean Sheet

 |  | A | K | Q | J | T | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2
 | A
 | K
 | Q
 | J
 | T
 | 9
 | 8
 | 7
 | 6
 | 5
 | 4
 | 3
 | 2
Spreadsheet: 101078d1299238560-excel-2007-fetch-data-from-a-cell-address-when-the-address-is-user-supplied-problems-with-report-card
Sheet: report card

 | MOUNT HILL HIGH SCHOOL REPORT CARD
 |  |  |  |  | REPORT CARD
 |  | SESSION 2011-12 |  |  |  |  |  |  | CLASS - IX
NAME : |  |  |  |  |  |  |  |  | ROLL :
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ENTER ROLL NUMBER BELOW
 | FA1 | FA2 | TOTAL FA | SA1 | TOTAL 1 | FA3 | FA4 | TOTAL FA | SA2 | TOTAL 2 | PERCENTILE |  |  | 10
LANGUAGE I
LANGUAGE II
MATHEMATICS
SCIENCE
SOCIAL STUDIES
The highlighted yellow cells should contain data from "log sheet" according to the following criteria : Cell B11 must have data same as ='log sheet'!F61 [NAME] must have data same as ='log sheet'!F62   and so on ....  This cell address (F61) will however be dynamically supplied from the cell N13 on this sheet.  That is, when I enter a different roll number in the purple cell, say 15, the value of cell N13 will change to 91 and thereby the data fetching will be from cell F91 of logsheet
Spreadsheet: 140659d1328848730-excel-2007-how-to-grab-information-from-other-sheets-and-place-it-in-the-main-sheet-example
Sheet: RESULT

NAME | SEX | GOLF | TENNIS | RUBY | POKER | SNOOKER
test1 | F | L | L | L | S | L
test2 | F
test3 | M
test4 | M
test5 | F
test6 | F
[NAME] | F
test8 | M
test9 | M
test10 | M
test11 | M
test12 | M
test13 | M
test14 | M
test15 | M
Spreadsheet: 109cdb44-cfb8-4816-8a23-928e0e9288d7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8277 | 16444 | [NAME] | Onisseit | GER | 0 | 00:43:01 | 00:03:41 | [NAME] | 00:02:57 | [NAME] | 1 | 06:18:30
Spreadsheet: 92f7920f-aa41-453b-a016-987a5a2b2a47
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
PFR | Test | PFR | Porphyrins, Fractionation, [NAME] | Porphyrins, Fractionation | Only orderable as part of a reflex test. For further information see PEE / Porphyrins Evaluation, [NAME]. |  |  |  |  |  | Only orderable as part of a reflex test. For further information see PEE / Porphyrins Evaluation, [NAME]. | Whole blood: 3 mL washed and res |  | Only orderable as part of a reflex test. For further information see PEE / Porphyrins Evaluation, [NAME]. | Monday through Friday; 8 a.m. | 2 days (not reported on Saturday or Sunday) | 3 days | 1 | 82492 |  |  |  |  | Rochester
PFR | [NAME] | WRBC | Washed RBC |  |  |  | Frozen | 21 days
PFR | Result | 2340 | Uroporphyrin | Uroporphyrin | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 14180-4 | Uroporphyrin:MCnc:Pt:RBC:Qn:
PFR | Result | 2341 | Heptacarboxyl Porphyrins | Heptacarboxyl Porphyrins | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 9446-6 | Heptacarboxylporphyrin:MCnc:Pt:RBC:Qn:
PFR | Result | 2346 | Hexacarboxyl Porphyrins | Hexacarboxyl Porphyrins | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 16963-1 | [NAME]:MCnc:Pt:[NAME]:Qn:
PFR | Result | 2347 | Pentacarboxyl Porphyrins | Pentacarboxyl Porphyrins | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 18250-1 | Pentacarboxylporphyrins:MCnc:Pt:[NAME]:Qn:
PFR | Result | 2329 | Coproporphyrin | Coproporphyrin | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 18257-6 | Coproporphyrin:MCnc:Pt:[NAME]:Qn:
PFR | Result | 2328 | Protoporphyrin | Protoporphyrin | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 2896-9 | Protoporphyrin:MCnc:Pt:[NAME]:Qn:
PFR | Result | 29355 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: May 22

Enter 1st of Month Here -> | 2022-05-01 00:00:00 | Controller | Volunteer 1 | Volunteer 2 | Volunteer 3 | Volunteer 4 | Volunteer 5 | Volunteer 6
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
Sat
Sun