tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 795264d1662585024-pull-value-from-other-workbooks-value-range-proposed-values-example
Sheet: Sheet1

Abbrv | Community | Pace | 2022-09-30 00:00:00 | BuildPro Cost Center (e.g., 493510000) | JDE Lot # | Lot # | Street Address: |  | Plan # | Elevation | BuildPro Start Date | Frame Start Date | PO's in BP | Sep | Com # | HS # | True Up  Amount | Status in BP
LNBM | [NAME] | 1 | 129 | 1649510000 | 0129 | 129 | 8790 | [NAME] | 1438 | A | 2022-08-05 00:00:00 | 2022-09-08 00:00:00 | 31339.38 | 17752.9396131375 | 164951
164951 | [NAME] | 2 | 130 | 1649510000 | 0130 | 130 | 8798 | [NAME] | 2013 | C | 2022-08-12 00:00:00 | 2022-09-15 00:00:00 | 40778.09 | 24894.23417000624 | 164951
 | [NAME] | 3 | 131 | 1649510000 | 0131 | 131 | 8814 | [NAME] | 2185 | B | 2022-08-19 00:00:00 | 2022-09-22 00:00:00 | 36796.98 | ???? | 164951
 | [NAME] | 4 | 132 | 1649510000 | 0132 | 132 | 8822 | [NAME] | 2013 | A | 2022-08-26 00:00:00 | 2022-09-29 00:00:00 | 39214.54 | ???? | 164951
LNIS | [NAME] | 1 | 20 | 68122510000 | 0020 | 20 | 1736 | Casias Lane | 1438 | C | 2022-08-01 00:00:00 | 2022-09-06 00:00:00 | 36970.77 | 20041.68763728 | 6812251
6812251 | [NAME] | 2 | 21 | 68122510000 | 0021 | 21 | 1732 | Casias Lane | 2185 | B | 2022-08-08 00:00:00 | 2022-09-13 00:00:00 | 40850.88 | ???? | 6812251
 | [NAME] | 3 | 33 | 68122510000 | 0033 | 33 | 1729 | [NAME] | 2185 | A | 2022-08-15 00:00:00 | 2022-09-20 00:00:00 | 36253.29 | ???? | 6812251
 | [NAME] | 4 | 32 | 68122510000 | 0032 | 32 | 1725 | [NAME] | 1438 | C | 2022-08-22 00:00:00 | 2022-09-27 00:00:00 | 31598.05 | ???? | 6812251
Spreadsheet: 225a7a23-9dd4-4258-b92f-d9bbabee6fe4
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
EEPC | Test | EEPC | Eastern Equine Encephalitis Antibody Panel, IgG and IgM, Spinal Fluid | East Equine Enceph Ab Panel, CSF | Immunofluorescence Assay (IFA) | [NAME], round-bottom, plastic vial: ScwRBPl |  |  | 0.5 | mL | Container/Tube: Sterile vial [NAME]: 0.5 mL Additional Information: This test is not available for specimens originating in New York. | 0.2 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | IgG: <1:10 IgM: <1:10 Reference values apply to all ages. | Monday through Friday; 9 a.m. | Same day/1 day | 4 days |  | Profile |  |  |  |  | Rochester
EEPC | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
EEPC | Result | 26369 | East [NAME], IgG, CSF | East [NAME], IgG, CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10897-7 | Eastern equine encephalitis virus [NAME].IgG:Titr:Pt:CSF:Qn:IF
EEPC | Result | 26370 | East [NAME], IgM, CSF | East [NAME], IgM, CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10899-3 | Eastern equine encephalitis virus Ab.IgM:Titr:Pt:CSF:Qn:IF
Spreadsheet: 59851d1260385056-find-if-lookup-rockies
Sheet: Lookup

Title | Area
Finance | Finance/Accounting
Training | Finance/Accounting
Audit | Finance/Accounting
Chief [NAME] | Finance/Accounting
CFO | Finance/Accounting
Tax | Finance/Accounting
Accounting | Finance/Accounting
Sales | Sales/Marketing/Business Development
Growth | Sales/Marketing/Business Development
Marketing | Sales/Marketing/Business Development
Develop | Sales/Marketing/Business Development
Operation | Operations/Manufacturing
Chief Operat | Operations/Manufacturing
COO | Operations/Manufacturing
Manufact | Operations/Manufacturing
Tech | Technology/R&D/Engineering
IT | Technology/R&D/Engineering
R&D | Technology/R&D/Engineering
Research | Technology/R&D/Engineering
Engin | Technology/R&D/Engineering
Project | Project Development
Project | Project Development
Chief Exec | Chief Executive/President/Owner
CEO | Chief Executive/President/Owner
President | Chief Executive/President/Owner
Owner | Chief Executive/President/Owner
Vice | VP/SVP/EVP/GM
VP | VP/SVP/EVP/GM
SVP | VP/SVP/EVP/GM
EVP | VP/SVP/EVP/GM
GM | VP/SVP/EVP/GM
General Manager | VP/SVP/EVP/GM
Corporate | Corporate Development/Strategy
Strategy | Corporate Development/Strategy
Administrative | Administrative/Human Resources/Communications
PR | Administrative/Human Resources/Communications
Training | Administrative/Human Resources/Communications
Public Rel | Administrative/Human Resources/Communications
Human | Administrative/Human Resources/Communications
HR | Administrative/Human Resources/Communications
Assistant | Administrative/Human Resources/Communications
Legal | Legal
Law | Legal
Title | Area
Audit | Finance/Accounting
Training | Administrative/Human Resources/Communications
Ecucation | Administrative/Human Resources/Communications
Client | Administrative/Human Resources/Communications
Administration | Administrative/Human Resources/Communications
Communications | Administrative/Human Resources/Communications
Events | Administrative/Human Resources/Communications
Information | Administrative/Human Resources/Communications
CPA | Finance/Accounting
Equity | Finance/Accounting
Financ | Finance/Accounting
Capital | Finance/Accounting
VC | Finance/Accounting
Acquisition | Finance/Accounting
Merger | Finance/Accounting
M&A | Finance/Accounting
Securities | Finance/Accounting
Web | Technology/R&D/Engineering
Software | Technology/R&D/Engineering
Litigation | Legal
Regulat | Legal
Govern | Legal
Litigation | Legal
Antitrust | Legal
Intellectual | Legal
Intelligence | Corporate Development/Strategy
Strateg | Corporate Development/Strategy
Spreadsheet: 100884d1299099213-generate-an-average-based-on-text-average-number-of-clocks-per-rep
Sheet: May 2011 (2)

BN | [NAME] |  |  | Average # of Clocks Per Contract
LD | [NAME] |  |  | Average # of Clocks Per Contract
Rep | # of Clocks
LD | 1
BN | 2
LD | 1
BN | 1
LD | 1
BN | 1
LD | 2
BN | 1
LD | 1
BN | 1
LD | 1
BN | 10
LD | 1
BN | 2
LD | 1
BN | 1
LD | 4
BN | 1
LD | 1
BN | 1
LD | 1
BN | 2
LD | 4
BN | 1
LD | 7
BN | 1
LD | 1
BN | 1
LD | 1
BN | 1
LD | 1
BN | 5
LD | 1
BN | 1
LD | 1
BN | 1
LD | 1
BN | 1
LD | 1
BN | 1
LD | 1
BN | 1
LD | 1
BN | 1
LD | 1
BN | 1
LD | 10
BN | 1
LD | 1
BN | 1
LD | 1
BN | 3
LD | 8
BN | 1
LD | 1
BN | 2
LD | 1
BN | 1
LD | 1
BN | 1
LD | 1
BN | 1
LD | 2
BN | 1
LD | 2
BN | 1
LD | 1
BN | 2
LD | 2
BN | 1
LD | 1
BN | 1
Spreadsheet: 874632d1721195478-sla-in-minutes-exclude-non-working-days-weekend-and-public-holidays-and-specific-datetime-sla-in-minutes-exclude-non-working-days-weekend-and-public-holidays-and-specific-datetime
Sheet: WK

Ticket Update DateTime | Ticket Solve DateTime | Expected Result |  |  |  | Public Holiday |  | Start Hour | End Hour
 |  |  |  |  |  | 2024-06-03 00:00:00 |  | 09:00:00 | 18:00:00
 |  |  |  |  |  | 2024-06-17 00:00:00
Spreadsheet: 234474d1368111685-using-sumproduct-with-conditions-example-mf
Sheet: Sheet1

 | 2000 |  |  |  |  |  | 2001
 | NAME | Position | A.Return | G.Return | Weight |  | NAME | Position | A.Return | G.Return | Weight
 | a | 1 |  |  |  |  | f | 2
 | b | 3 |  |  |  |  | g | 1
 | c | 2 |  |  |  |  | i | 3
 | d | 1 |  |  |  |  | l | 3
 | e | 3 |  |  |  |  | p | 3
 | f | 3 |  |  |  |  | s | 2
 | g | 3 |  |  |  |  | t | 1
 | h | 1 |  |  |  |  | u | 2
 | i | 1 |  |  |  |  | v | 1
 | j | 2 |  |  |  |  | w | 1
 | k | 3 |  |  |  |  | x | 2
 | l | 2 |  |  |  |  | y | 1
 |  |  |  |  |  |  | z | 3
 |  | Portfolio | 2000 |  | 2001
 |  |  | A.Return | G.Return | A.Return | G.Return
 |  | 1
 |  | 2
 |  | 3
Spreadsheet: 828299d1683371407-need-formula-for-blank-cells-to-copy-previous-cell-data-new-microsoft-excel-worksheet-7-
Sheet: Sheet1

date | maths | science |  |  | date | maths | science
2022-05-01 00:00:00 | 80 | abs
2022-06-01 00:00:00 | abs | 86
2022-07-01 00:00:00 | 86 | 54
2022-08-01 00:00:00 | 76 | 75
2022-09-01 00:00:00 |  | 65
2022-10-01 00:00:00 | 46 | 34
Spreadsheet: 847921d1698764770-summarize-data-on-multiple-sheets-to-one-sheet-corrected-sample
Sheet: Plants Delivery

Date | Name | Qty | Price | Amount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | QTY | PRICE | AMOUNT
2023-10-01 00:00:00 | Asparagus | 20 | 2
2023-10-02 00:00:00
2023-10-03 00:00:00
2023-10-04 00:00:00
2023-10-05 00:00:00
2023-10-06 00:00:00
2023-10-07 00:00:00
2023-10-08 00:00:00
2023-10-09 00:00:00
2023-10-10 00:00:00
2023-10-11 00:00:00
2023-10-12 00:00:00 | Peppers | 200 | 2
2023-10-13 00:00:00
2023-10-14 00:00:00
2023-10-15 00:00:00
2023-10-16 00:00:00
2023-10-17 00:00:00
2023-10-18 00:00:00
2023-10-19 00:00:00
2023-10-20 00:00:00
2023-10-21 00:00:00
2023-10-22 00:00:00
2023-10-23 00:00:00
2023-10-24 00:00:00
2023-10-25 00:00:00
2023-10-26 00:00:00
2023-10-27 00:00:00
2023-10-28 00:00:00
2023-10-29 00:00:00
2023-10-30 00:00:00
2023-10-31 00:00:00
Spreadsheet: 742684d1627965234-reverse-vlookup-based-on-an-account-mask-wildcard-project
Sheet: Sheet1

Purpose: | To determine which buyers would have which account codes routed to them.
 |  | Masks
 | Buyer 1 | ???.???.4???.????.???
 | Buyer 1 | ???.???.????.66??.???
 | Buyer 2 | ???.???.????.67??.???
 | Buyer 2 | ???.???.????.63??.???
 | Buyer 3 | ???.???.4???.63??.???
 | Buyer 3 | ???.???.????.66??.???
 | Account codes
 | [PHONE].6450.500
 | [PHONE].6330.500
 | [PHONE].6610.500
 | [PHONE].6737.500
 | [PHONE].6890.100
 | TEXT TO COLUMNS |  |  |  |  | & STATEMENT | Buyer 1 | Buyer 2 | Buyer 3
 | 610 | 100 | 4000 | 6450 | 500
 | 630 | 100 | 4000 | 6330 | 500
 | 001 | 100 | 2600 | 6610 | 500
 | 610 | 100 | 1000 | 6737 | 500
 | 525 | 100 | 1000 | 6890 | 100
Spreadsheet: 776060d1649474344-need-formula-to-get-data-based-on-multiple-criteria-increment
Sheet: Sheet1

 |  | [NAME] (in lakhs) | Rating | 2 | 3 | 4 | 5
 | Up to | 4 |  | 9 | 10 | 11 | 12
 |  | 9 |  | 5 | 6 | 7 | 8
 |  | 14 |  | 1 | 2 | 3 | 4
 |  |  |  | Light Green values are the proposed increment based on the rating and the salary
Salary | Rating | [NAME]
2 | 5 | 12
7 | 5 | 8
11 | 3 | 2
Spreadsheet: 667315d1584176491-help-to-create-a-new-sum-if-formula-spread
Sheet: Sheet2

Code |  |  | Merchant |  |  | Date
OT
Vessel | Species | Presentation | Grade | Number of Boxes | [NAME] | Unit Price | Total Value |  |  | WT | [NAME]
 |  |  |  |  |  |  |  |  |  | WC | [NAME]
 |  |  |  |  |  |  |  |  |  | HD | [NAME]
 |  |  |  |  |  |  |  |  |  | JPL | JPL Shellfish
 |  |  |  |  |  |  |  |  |  | BL | Bells Seafood
 |  |  |  |  |  |  |  |  |  | PWELL | Pierowall Fish
 |  |  |  |  |  |  |  |  |  | ICEW | [NAME]
 |  |  |  |  |  |  |  |  |  | WL | Whitelink Seafoods
 |  |  |  |  |  |  |  |  |  | CS | Caithness Smoke House
 |  |  |  |  |  |  |  |  |  | OT | Fish In Crieff
 |  |  |  |  |  |  |  |  |  | CPM | Campbells Prime Meat
Spreadsheet: kate_symes__18707__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-23 00:00:00 |  | 194.65 | 20624 | 152.04 | 7328
 | 2001-02-22 00:00:00 |  | 253.75 | 17824 | 217.96 | 5880 | 190.34 | 576 | 143.24 | 795
 | 2001-02-21 00:00:00 |  | 291.88 | 11824 | 261.34 | 6928 | 295 | 50 | 220.57 | 485
 | 2001-02-20 00:00:00 |  | 326.7 | 22224 | 310.97 | 5328 | 275 | 78 | 222.94 | 375
 | 2001-02-19 00:00:00 |  | 326.67 | 22624 | 310.97 | 5328 | 335.35 | 174 | 259.78 | 115
 | 2001-02-18 00:00:00 |  | 325 | 800 | 310 | 0 | 275.26 | 476 | 266.22 | 555 |  | 336.69 | 11784
 | 2001-02-17 00:00:00 |  | 349.98 | 15824 | 336.58 | 3800 | 347.69 | 281 | 332.5 | 0
 | 2001-02-16 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 397.28 | 230 | 350 | 40
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 348.8 | 1693 | 398.23 | 784
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 | 2001-02-12 00:00:00 |  | 302.64 | 12624 | 279.2 | 4528 | 271.84 | 1346 | 324.32 | 544
 | 2001-02-11 00:00:00 |  | 285 | 0 | 270 | 0 | 312.37 | 316 | 326.04 | 96 |  | 278.81 | 12600
 | 2001-02-10 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 322.06 | 790 | 309.3 | 328
 | 2001-02-09 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 341.87 | 3340 | 307.19 | 1050
 | 2001-02-08 00:00:00 |  | 381.43 | 15120 | 316.79 | 3376 | 341.12 | 2521 | 320.97 | 373
 | 2001-02-07 00:00:00 |  | 274.49 | 8688 | 253.14 | 4024 | 294.97 | 2143 | 251.02 | 216
 | 2001-02-06 00:00:00 |  | 213.71 | 10784 | 195.79 | 4096 | 259.92 | 63 | 196.16 | 307
 | 2001-02-05 00:00:00 |  | 200.43 | 11824 | 196.63 | 3968 | 204.52 | 1904 | 179.61 | 727
 | 2001-02-04 00:00:00 |  | 200 | 0 | 185 | 0 | 181.95 | 1513 | 175.11 | 1100 |  | 196.25 | 10704
 | 2001-02-03 00:00:00 |  | 222.8 | 15824 | 195.9 | 7648 | 185 | 35 | 199.94 | 233
 | 2001-02-02 00:00:00 |  | 222.8 | 15824 | 195.9 | 7648 | 203.95 | 380 | 200 | 48
 | 2001-02-01 00:00:00 |  | 355.71 | 7984 | 306.05 | 3728 | 255.73 | 1202 | 198.09 | 315
 | 2001-01-31 00:00:00 |  | 409.15 | 12656 | 342.56 | 3280 | 313.68 | 3766 | 275 | 70
 | 2001-01-30 00:00:00 |  | 468.99 | 11456 | 403.48 | 2872 | 383.47 | 304 | 351 | 25
 | 2001-01-29 00:00:00 |  | 420.48 | 19824 | 407.62 | 3832 | 383.33 | 4070 | 304.86 | 1442
 | 2001-01-28 00:00:00 |  | 450 | 800 | 350 | 0 | 488.38 | 355 | 460.46 | 416 |  | 408.68 | 12240
 | 2001-01-27 00:00:00 |  | 294.85 | 19024 | 254.41 | 4032 | 456.54 | 845 | 457.01 | 236
 | 2001-01-26 00:00:00 |  | 295.64 | 17424 | 254.65 | 3832 | 369.4 | 402 | 350 | 75
 | 2001-01-25 00:00:00 |  | 319.38 | 15024 | 295.88 | 1272 | 296.66 | 437 | 234.61 | 965
 | 2001-01-24 00:00:00 |  | 307.59 | 18224 | 261.91 | 2872 | 290.03 | 291 | 291.18 | 807
 |  |  |  |  |  | ..
Spreadsheet: 115474d1311084007-excel-2007-return-all-values-for-multiple-identifying-factors-excel-problem-example-sarah
Sheet: List

 |  |  | ID | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 |  |  | Section | 1 | 4 | 16 | 17-N2,SE | 17-S2,NE | 18 | 19 | 20 | 21 | 40-W2 | 40-N2NE | 40-NESE,S2SE | 40-NWSE | 40-S2NE
 |  |  | Lease | 306 | 307 | 292 | 292 | 1 | 292 | 301 | 301 | 301 | 312 | 311 | 310 | 308 | 309
 |  |  |  |  |  | 293 | 293 | 292 | 293 | 302 | 302 | 302
 |  |  |  |  |  | 294-298 | 299 | 293 | 294-298 | 303 | 303 | 303
 |  |  |  |  |  | 299 | 300 | 299 | 299 | 304 | 304 | 304
 |  |  |  |  |  | 431-432 | 301 | 300 | 431-432 | 305 | 305 | 305
 |  |  |  |  |  | 300 | 302 | 301 | 300 | 404-407 | 404-407 | 404-407
 |  |  |  |  |  | 301 | 303 | 302 | 301
 |  |  |  |  |  | 302 | 304 | 303 | 302
 |  |  |  |  |  | 303 | 305 | 304 | 303
 |  |  |  |  |  | 304 | 433 | 305 | 304
 |  |  |  |  |  | 305 | 294-298 | 433 | 305
 |  |  |  |  |  | 433 | 431-432 | 294-298 | 433
 |  |  |  |  |  | 274 |  | 431-432 | 1
 |  |  |  |  |  | 432
 |  |  |  |  |  | 424
 |  |  |  |  |  | 428
 |  |  |  |  |  | 2
Lease # | 1 | 2 | 274 | 292 | 293 | 299 | 300 | 301 | 302 | 303 | 304 | 305 | 306 | 307 | 308 | 309 | 310 | 311 | 312 | 423 | 424 | 428 | 433 | 294-298 | 404-407 | 431-432
Legal ID | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 1 | 2 | 13 | 14 | 12 | 11 | 10 | 3 | 3 | 3 | 3 | 3 | 7 | 3
 | 6 |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  |  |  |  |  |  |  |  |  |  | 4 | 4 | 8 | 4
 |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 9 | 5
 |  |  |  | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 |  |  |  |  |  |  |  |  |  |  | 6 | 6 |  | 6
 |  |  |  |  |  |  |  | 7 | 7 | 7 | 7 | 7
 |  |  |  |  |  |  |  | 8 | 8 | 8 | 8 | 8
 |  |  |  |  |  |  |  | 9 | 9 | 9 | 9 | 9
 |  |  |  |  |  | This formula returns all the names which have a #3 designation from column A on the '2011 Schedule' tab (referenced in cell E32).
 |  |  |  |  |  | What I WANT it to do is return all the wells which have not only a #3, but also 4,5, or 6 designation (i.e. all numbers within E27:E30).
 |  |  |  |  |  | And ideally it would place them in date order (i.e. column C on '2011 Schedule'), regardless of the identifying # designation.
Spreadsheet: cb61d5cf-08c0-4e2c-82e4-dbfa822af3c5
Sheet: Sheet1

Table S2. Correlation table using the Spearman rank correlation coefficient | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 |  | Correlation | P-value
 | RCI-G vs RCI'-G | 0.9642857 | 0.002778
 | RCI-F vs RCI'-F | 0.0360375 | 0.9389
 | RCI-O vs RCI'-O | 0 | 1
 | RCI-G vs RCI-F | 0.1982062 | 0.6701
 | RCI-G vs RCI-O | 0.5 | 0.2667
 | RCI-F vs RCI-O | 0.8288625 | 0.02117
 | RCI'-G vs RCI'-F | -0.75 | 0.06627
 | [NAME] | -0.6071429 | 0.1667
 | RCI'-F vs RCI'-O | 0.8571429 | 0.02381
 | RCI-G vs NodesG | 0.4303767 | 0.3351
 | RCI'-G vs NodesG | 0.5052248 | 0.2474
 | RCI-F vs NodesF | 0.1926687 | 0.679
 | RCI'-F vs NodesF | -0.8728716 | 0.01032
 | RCI-O vs NodesO | 0.755929 | 0.04931
 | RCI'-O vs NodesO | -0.3779645 | 0.4032
Spreadsheet: 887253d1737496096-data-not-sorting-or-flowing-correctly-emp_test-dru12233-
Sheet: WK2

Emoloyee ID | Office | Name | Tues Hours
773 | LOG | [NAME], [NAME] | 6
235 | ACC | [NAME], [NAME] | 9
Emoloyee ID | Office | Last | First | [NAME] | M | TU | W | TH | F
235 | ACC | Edwards | [NAME] | 9
773 | LOG | [NAME] | Cathy | 6
123 | NEW | [NAME] | [NAME] | 8
Spreadsheet: 276910d1384107360-same-name-in-cells-is-formatted-differently-how-can-i-replace-with-a-consistent-format-for-excel-forum-wk-10-11-10-13
Sheet: 1. Basic info I want to add to

[NAME] |  |  |  |  |  | ROS | Chad | [NAME] | Age
Player | YTD Pts | Bye | Drafted | Trade?
Manning, Eli NYG QB | 152.25 | 9 | 12.12 | Trade
Newton, Cam CAR QB | 191.15 | 4 | 6.12 | Trade
[NAME], [NAME] WAS RB | 75.5 | 5 | 13.01 | Trade
McGahee, [NAME] | 35.4 | 10 | FA | Trade
Mendenhall, Rashard ARI RB (P) | 62.7 | 9 | 7.01 | Trade
[NAME], Adrian MIN RB | 178.9 | 5 | 1.01 | Trade |  | 3 | 8 | 7 | 28
[NAME], [NAME] | 107.7 | 7 | 9.01 | Trade
Woodhead, [NAME] | 131.4 | 8 | 8.12 | Trade
Beasley, Cole DAL WR | 55.3 | 11 | FA | Trade
[NAME], [NAME] | 41.6 | 9 | FA | Trade
Cobb, Randall GBP WR (I) | 86.6 | 4 | 2.12 | Trade
Decker, [NAME] (P) | 130.9 | 9 | 5.01 | Trade
Fitzgerald, [NAME] | 113.4 | 9 | 3.01 | Trade
Garcon, [NAME] WAS WR | 160.3 | 5 | 4.12 | Trade
Harvin, Percy SEA WR (O) | - | 12 | 17.01 | Trade
[NAME], Darrius IND WR (P) | 48.8 | 8 | 12.08 | Trade
Clay, [NAME] | 109.8 | 6 | FA | Trade
Pettigrew, Brandon DET TE | 67.5 | 9 | 10.12 | Trade
Forbath, Kai WAS PK | 44 | 5 | 20.09 | Trade
Saints, New Orleans NOS Def | 69 | 7 | FA | Trade
20 Total Players
Yellow. This is the basic format to which I would like to add information from the attached worksheets
Blue.  In one of the columns to the right of [NAME], I want to search the "ROS" spreadsheet, and input "3" (See Sheet 2)
Green.  In one of the columns to the right of [NAME], I want to search the "Chad's Rankings" spreadsheet, and input "8" (See Sheet 3)
Green.  In one of the columns to the right of [NAME], I want to search the "Ryan's Rankings" spreadsheet, and input "7" AND "28" (See Sheet 4)
Spreadsheet: 117383d1312752055-filtering-lookup-array-question-filtered
Sheet: 44012

CONTROL CABLE
CORE CARD
Location
Cable Number |  | 44012
Number of cores |  | 12
Spare cores |  | 1
Core size |  | 2.5mm2
Cable Type |  | Cu, PVC, SWA
Drawing References
Cable Service |  | CB482 status
Panel Number | T44 PP |  | Panel Number |  | [NAME]
Cable Insulation resistance >100MΩ
Core Number | Ferrule Number |  | T44 PP | INITIAL | [NAME] | INITIAL
1 | 20/ADY441130 |  | TBX5:14 |  | 24
2 | 20/ADY441138 |  | TBX5:15 |  | 29
3 | 20/ADY441162 |  | TBY5:5 |  | 69
4 | Spare
5 | 06/BAC1210 |  | ?? |  | 38
6 | 06/BAC1215 |  | ?? |  | 43
7 | 06/BAC1216 |  | ?? |  | 58
8 | 06/BAC1221 |  | ?? |  | 63
9 | 05/BAC1051 |  | ?? |  | 138
10 | 05/BAC1052 |  | ?? |  | 147
11 | 05/BAC1053 |  | ?? |  | 140
12 | 05/BAC1054 |  | ?? |  | 149
13
14
15
16
17
18
19
20
21
22
23
24
Termination Notes
Edition Notes | 2011-08-02 00:00:00 | Was cable 4512 |  |  |  | DJC
 |  | Cable location appears to have moved from VTC to ODJB
 |  | Cable requires confirmation from controlled drawings
Spreadsheet: 833812d1687265282-consolidate-a-range-based-on-four-columns-consolidation
Sheet: Sheet1

From Jn | To Jn | Chainage | Chainage | Length
A | B | 100 | 110 | 10
A | B | 110 | 120 | 20
A | B | 122 | 140 | 20
A | B | 140 | 160 | 20
A | B | 160 | 180 | 20
B | D | 100 | 110 | 10
B | D | 110 | 120 | 20
B | D | 124 | 140 | 20
B | D | 140 | 160 | 20
B | D | 160 | 180 | 20
A | B | 100 | 120
A | B | 122 | 180
B | D | 100 | 120
B | D | 124 | 180
Spreadsheet: 472349d1469546181-sum-based-on-working-days-pauldaddyadams-asset-creations-2016
Sheet: Data

 |  | Note bank holidays:
 |  | 2016-05-02 00:00:00
 |  | 2016-05-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | WD
 |  | Company Code | Asset | Asset Class | Created by | Created on | Acquisition yr | First acq.per. | First acq. on | Capitalized on |  | Work Day |  | on or Before WD-5 | WD -4 to -3 | WD -1 to -2
 |  |  | 10116622 | 11000 |  | 2016-05-03 00:00:00
 |  |  | 10116623 | 11000 |  | 2016-05-03 00:00:00
 |  |  | 10116624 | 11000 |  | 2016-05-04 00:00:00
 |  |  | 10116625 | 11000 |  | 2016-05-05 00:00:00
 |  |  | 10116626 | 11000 |  | 2016-05-06 00:00:00
 |  |  | 10116627 | 11000 |  | 2016-05-09 00:00:00
 |  |  | 10116628 | 11000 |  | 2016-05-09 00:00:00
 |  |  | 10116629 | 11000 |  | 2016-05-10 00:00:00
 |  |  | 10116630 | 11000 |  | 2016-05-11 00:00:00
 |  |  | 10116631 | 11000 |  | 2016-05-12 00:00:00
 |  |  | 10116632 | 11000 |  | 2016-05-13 00:00:00 |  |  |  |  |  |  |  | `
 |  |  | 10116633 | 11000 |  | 2016-05-16 00:00:00
 |  |  | 10116634 | 11000 |  | 2016-05-17 00:00:00
 |  |  | 10116635 | 11000 |  | 2016-05-18 00:00:00
 |  |  | 10116636 | 11000 |  | 2016-05-18 00:00:00
 |  |  | 10116637 | 11000 |  | 2016-05-19 00:00:00
 |  |  | 10116638 | 11000 |  | 2016-05-20 00:00:00
 |  |  | 10116639 | 11000 |  | 2016-05-23 00:00:00
 |  |  | 10116640 | 11000 |  | 2016-05-24 00:00:00
 |  |  | 10116641 | 11000 |  | 2016-05-25 00:00:00
 |  |  | 10116642 | 11000 |  | 2016-05-26 00:00:00
 |  |  | 10116643 | 11000 |  | 2016-05-27 00:00:00
 |  |  | 10116644 | 11000 |  | 2016-05-31 00:00:00
 |  |  | 10116645 | 11000 |  | 2016-05-31 00:00:00
 |  |  | 10116646 | 11000 |  | 2016-05-31 00:00:00
 |  |  | 10116647 | 11000 |  | 2016-05-31 00:00:00
 |  |  | 10116648 | 11000 |  | 2016-05-31 00:00:00
Spreadsheet: 39402d1237557244-producing-automatic-reports-with-2-variables-example-44
Sheet: Coupon Recording

 | Today |  |  | 2009-03-20 13:46:38
 | Marketing Conversion Cummulative YTD
 |  |  |  |  | Outcome
 | Source Code | Coupon |  | Outcome 1 |  | Outcome 2 |  | Outcome 3 |  | Outcome 4 |  | Outcome 5 |  | Outcome 6 |  | Outcome 7 |  | Outcome 8 |  | Outcome 9 |  | Outcome 10
 |  | % | No | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | %
Spreadsheet: 146416d1332174016-overall-average-using-the-result-of-the-average-without-referencing-back-to-the-raw-data-avg
Sheet: Sheet1

 |  |  |  | Overall Average
[NAME] | 0.9999999999999994 |  |  | RubyLee Average
[NAME] | 0.9999999999999994 |  |  | [NAME]
[NAME] | 0.9999999999999998 |  |  | Is there a formula that will result unto the overall average using only the average data from RubyLee & Michael?
[NAME] | 0.9999999999999998 |  |  | I mean using the 99.23% and 97.83% and will result to 98.72%... Without referencing back to the raw data
[NAME] | 0.9999999999999998
[NAME] | 0.9999999999999994
[NAME] | 0.9999999999999998
[NAME] | 0.9999999999999998
[NAME] | 0.9999999999999999
[NAME] | 0.9999999999999998
[NAME] | 0.9999999999999998
[NAME] | 0.9999999999999994
[NAME] | 0.9999999999999999
[NAME] | 0.8919999999999998
[NAME] | 0.9519999999999998
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 0.8739999999999999
[NAME] | 0.9999999999999994