tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 46959d1245870396-combine-several-spreadsheets-into-one-vendor-documents-register-p01-20090622
Sheet: CPM

No. | P.O. No. | Submitted Date | Tansmittal No. | [NAME]) | Vendor Document No. | Document Title | Latest Version | Vendor | Status | Comments (Y,N) | Transmittal Returned By Eng.Dept | Status | Date | Transmittal Returned by Company | Status | Date | Remarks
1 | 3435-510-PO-0040A | 2008-05-08 00:00:00 | WIP-PCU-ENG-TN-0028 | 3435-510-P-PL-CPP-0001 |  | Manufacturing schedule for Pig Launching and Receiving trap | P00 | CPM | A | Y | WIP-PCU-ENG-TN-0028 Comments | D | 2008-05-09 00:00:00
2 | 3435-510-PO-0040A | 2008-05-13 00:00:00 | WIP-PCU-ENG-TN-0035 | 3435-510-P-QB-CPP-0002 |  | Inspection and Test Plan for Pig Launching and Receiving Traps | P00 | CPM | A | Y | WIP-PCU-ENG-TN-0028 Comments | D | 2008-05-09 00:00:00
3 | 3435-510-PO-0040A | 2008-06-08 00:00:00 | WIP-PCU-ENG-TN-0058 | 3435-D100-P-CA-CPPM-00002 |  | Calculation Sheet for 16”×12” [NAME] | P02 | CPM | A | Y | WIP-PCU-ENG-TN-0058 Comments | D | 2008-06-13 00:00:00
4 | 3435-510-PO-0040A | 2008-06-08 00:00:00 | WIP-PCU-ENG-TN-0058 | 3435-B100-P-CA-CPPM-00003 |  | Calculation Sheet for 16”×12” [NAME] | P02 | CPM | A | Y | WIP-PCU-ENG-TN-0058 Comments | D | 2008-06-13 00:00:00
5 | 3435-510-PO-0040A | 2008-06-08 00:00:00 | WIP-PCU-ENG-TN-0058 | 3435-510-P-CA-CPPM-00004 |  | Calculation Sheet for 18”×16” [NAME] | P02 | CPM | A | Y | WIP-PCU-ENG-TN-0058 Comments | D | 2008-06-13 00:00:00
6 | 3435-510-PO-0040A | 2008-06-08 00:00:00 | WIP-PCU-ENG-TN-0058 | 3435-E110-P-CA-CPPM-00005 |  | Calculation Sheet for 18”×16” [NAME] | P02 | CPM | A | Y | WIP-PCU-ENG-TN-0058 Comments | D | 2008-06-13 00:00:00
7 | 3435-510-PO-0040A | 2008-06-08 00:00:00 | WIP-PCU-ENG-TN-0058 | 3435-S510-P-CA-CPPM-00006 |  | Calculation Sheet for 28”×24” [NAME] | P02 | CPM | A | Y | WIP-PCU-ENG-TN-0058 Comments | D | 2008-06-13 00:00:00
8 | 3435-510-PO-0040A | 2008-06-08 00:00:00 | WIP-PCU-ENG-TN-0058 | 3435-510-P-CA-CPPM-00007 |  | Calculation Sheet for 28”×24” [NAME] | P02 | CPM | A | Y | WIP-PCU-ENG-TN-0058 Comments | D | 2008-06-13 00:00:00
9 | 3435-510-PO-0040A | 2008-06-08 00:00:00 | WIP-PCU-ENG-TN-0058 | 3435-D100-P-DA-CPPM-00010 |  | Assembly Drawing for 12”×16” Crude Oil Pig Launching | P02 | CPM | A | Y | WIP-PCU-ENG-TN-0058 Comments | C | 2008-06-13 00:00:00
Spreadsheet: 780139d1652298284-return-blank-when-the-dates-from-to-are-not-within-those-dates-range-formula
Sheet: Payroll Week

Payroll Week
TASKS LIST | 2022-05-09 00:00:00
Missing Comp Plan (HX_TL_EMP_MISSING_COMPPLAN_ENR)
Spreadsheet: 122665d1317054057-countif-between-sheets-datacollectionsample
Sheet: Data

Mentor Program Data Collection
Student | Identified | Extra | Other | Dropped | Total Grades
Name | MS | Curricular | Variables | Program | Core D | Core SF | Core F | Elec D | Elec SF | Elec F
Student 1 | X |  |  |  |  |  |  |  |  |  |  | KEY:
Student 2 | X |  |  |  |  |  |  |  |  |  |  | D = 60-69 | Other Variables:
Student 3 | X |  |  |  |  |  |  |  |  |  |  | SF =  45-59 | A - Outside Tutoring
Student 4 | X |  |  |  |  |  |  |  |  |  |  | F = or > 44 | B - Outside Counseling
Student 5 | X |  |  |  |  |  |  |  |  |  |  |  | C - Does not self advocate
Student 6 | X
Student 7 | X
Student 8 | X
Student 9 | X
Student 10 | X
Student 11 | X
Student 12 | X
Student 13 | X
Student 14 | X
Student 15 | X
Student 16 | X
Student 17 | X
Student 18
Student 19
Student 20
Student 21
Student 22
Student 23
Student 24
Student 25
Student 26
Student 27
Student 28
Student 29
Student 30
Spreadsheet: 158278d1338138741-creating-a-grid-to-display-store-closings-storelogtest-1-
Sheet: Sheet4

 | 1 | 2 | 3 | 4
 | 2 | 3 | 4 | 5
 | 3 | 4 | 5 | 6
 | 4 | 5 | 6 | 7
 | 5 | 6 | 7 | 8
 | 6 | 7 | 8 | 9
 | 7 | 8 | 9 | 10
 | 8 | 9 | 10 | 11
 | 9 | 10 | 11 | 12
 | 10 | 11 | 12 | 13
 | 11 | 12 | 13 | 14
 | 12 | 13 | 14 | 15
 | 13 | 14 | 15 | 16
 | 14 | 15 | 16 | 17
 | 15 | 16 | 17 | 18
 | 16 | 17 | 18 | 19
 | 17 | 18 | 19 | 20
 | 18 | 19 | 20 | 21
 | 19 | 20 | 21 | 22
 | 20 | 21 | 22 | 23
 | 21 | 22 | 23 | 24
 | 22 | 23 | 24 | 25
 | 23 | 24 | 25 | 26
 | 24 | 25 | 26 | 27
 | 25 | 26 | 27 | 28
 | 26 | 27 | 28 | 29
 | 27 | 28 | 29 | 30
 | 28 | 29 | 30 | 31
 | 29 | 30 | 31 | 32
 | 30 | 31 | 32 | 33
 | 31 | 32 | 33 | 34
 | 32 | 33 | 34 | 35
 | 33 | 34 | 35 | 36
 | 34 | 35 | 36 | 37
 | 35 | 36 | 37 | 38
 | 36 | 37 | 38 | 39
 | 37 | 38 | 39 | 40
 | 38 | 39 | 40 | 41
 | 39 | 40 | 41 | 42
 | 40 | 41 | 42 | 43
 | 41 | 42 | 43 | 44
 | 42 | 43 | 44 | 45
 | 43 | 44 | 45 | 46
 | 44 | 45 | 46 | 47
 | 45 | 46 | 47 | 48
 | 46 | 47 | 48 | 49
 | 47 | 48 | 49 | 50
 | 48 | 49 | 50 | 51
 | 49 | 50 | 51 | 52
 | 50 | 51 | 52 | 53
 | 51 | 52 | 53
 | 52 | 53
 | 53
Spreadsheet: 538761d1505821629-why-i-get-n-a-when-value-exist-getna
Sheet: Sheet2

num | date | MS17-011 | KB
4012213 | 42808 | MS17-011 | 4013076
4013429 | 42808 | MS17-011 | 4013076
4013429 | 42808 | MS17-011 | 4013076
4012583 | 42808 | MS17-011 | 4013076
4012583 | 42808 | MS17-011 | 4013076
4015547 | 2017-04-11 | Windows Server 2012 R2 | Windows
4019111 | 2017-05-09 | Microsoft .NET Framework 3.5
Spreadsheet: 840099d1692427355-copy-all-data-to-a-summary-sheet-on-a-per-date-basis-copy-of-new-microsoft-excel-worksheet
Sheet: DAILY TARGET

 |  |  |  |  | DATE:
FLACKER MACHINE |  |  |  | MDM (20kgs)
NO. | OPERATOR | TIME START | TIME END | TARGET CARTONS | ACTUAL | REMARKS
1 |  |  |  | 300
2
3
4
5
FILLER MACHINE |  |  |  | BARREL
NO. | OPERATOR | TIME START | TIME END | TARGET TROLLEY | ACTUAL | REMARKS
1 |  |  |  | 30
2
3
4
5
PACKING
NO. | PACKERS | TIME START | TIME END | TARGET TROLLEY | ACTUAL | REMARKS
1 |  |  |  | 30
2
3
4
5
6
7
8
9
10
Spreadsheet: 813380d1673707126-lookup-and-count-values-across-multiple-tables-problem-example-2
Sheet: Sheet1

 |  |  |  |  |  |  |  | Alternative View of Crosstab
 | Group | Person 1 | Person 2 | Person 3 | Person 4 | Person 5 |  | Person | Group |  | Group | Characteristic |  | Table1.Person | C1 | C2 | [NAME] | C4 | C5
 | Group A | X |  | X |  |  |  | Person 1 | Group A |  | Group A | C1 |  | Person 1 | 1 | 1 | 1
 | Group B |  | X | X |  |  |  | Person 2 | Group B |  | Group A | C2 |  | Person 2 | 1 |  |  | 1
 | Group C |  |  |  | X |  |  | Person 3 | Group A |  | Group A | [NAME] |  | Person 3 | 2 | 1 | 1 | 1
 |  |  |  |  |  |  |  | Person 3 | Group B |  | Group B | C1 |  | Person 4 |  | 1 |  | 1 | 1
 |  |  |  |  |  |  |  | Person 4 | Group C |  | Group B | C4
 |  |  |  |  |  |  |  | Person 5 |  |  | Group C | C2
 |  |  |  |  |  |  |  |  |  |  | Group C | C4
 |  |  |  |  |  |  |  |  |  |  | Group C | C5
 | Correct Output:
 | Characteristic | Person 1 | Person 2 | Person 3 | Person 4 | Person 5
 | C1 | 1 | 1 | 2
 | C2 | 1 |  | 1 | 1
 | [NAME] | 1 |  | 1
 | C4 |  | 1 | 1 | 1
 | C5 |  |  |  | 1
 | C6
 | Solution 1 (by [NAME])
 | Characteristic | Person 1 | Person 2 | Person 3 | Person 4 | Person 5
 | C1
 | C2
 | [NAME]
 | C4
 | C5
 | C6
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 13a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | - | 1052678 | 1052678
Europe | - | 484587 | 484587
North America/Asia | - | 568091 | 568091
Other | - | - | -
Index | 2038937 | 5536817 | 7575754
Asia | - | 115052 | 115052
Europe | 868570 | 2635633 | 3504203
North America | 1152836 | 2528985 | 3681821
Other | 17531 | 257147 | 274678
Other | - | 669204 | 669204
Exotic | - | 49113 | 49113
Swaptions | - | 619853 | 619853
Total Return Swap | - | 238 | 238
TOTAL | 2038937 | 7258699 | 9297636
Spreadsheet: 771750d1646832076-what-function-to-use-to-show-a-value-based-on-drop-down-list-test-1-
Sheet: Sheet1

USD Rate: | 22.02
Hour Rate: | 22
ManDay Rate
CAPEX category | Item | Unit type | no. of units | Price per unint | Pcs Price | Cost
 |  | Hrs | 10
 |  | MD | 10
 |  | Pcs | 10 |  | 5
Spreadsheet: 776843d1649943624-display-start-time-and-end-time-overlapping-overlapping-times-jbl0703-
Sheet: Feuil3

Start reference time | End reference time |  |  |  |  | Start reference time | End reference time
09:00:00 | 11:00:00 |  |  |  |  | 21:00:00 | 02:00:00
Schedule |  |  |  |  |  | Schedule |  |  |  |  |  | What I need
Start time | End time |  | Start overlap time | End overlap time |  | Start time | End time |  | Start overlap time | End overlap time
07:00:00 | 08:00:00 |  |  |  |  | 19:00:00 | 20:00:00 |  |  |  |  | no overlap | no overlap |  | no overlap | no overlap
07:00:00 | 09:00:00 |  |  |  |  | 19:00:00 | 21:00:00 |  |  |  |  | no overlap | no overlap |  | no overlap | no overlap
07:00:00 | 10:00:00 |  |  |  |  | 19:00:00 | 22:00:00 |  |  |  |  | 09:00:00 | 10:00:00 |  | 21:00:00 | 22:00:00
07:00:00 | 11:00:00 |  |  |  |  | 19:00:00 | 00:00:00 |  |  |  |  | 09:00:00 | 11:00:00 |  | 21:00:00 | 00:00:00
07:00:00 | 13:00:00 |  |  |  |  | 19:00:00 | 01:00:00 |  |  |  |  | 09:00:00 | 11:00:00 |  | 21:00:00 | 01:00:00
09:00:00 | 13:00:00 |  |  |  |  | 19:00:00 | 02:00:00 |  |  |  |  | 09:00:00 | 11:00:00 |  | 21:00:00 | 02:00:00
10:00:00 | 13:00:00 |  |  |  |  | 19:00:00 | 04:00:00 |  |  |  |  | 10:00:00 | 11:00:00 |  | 21:00:00 | 02:00:00
11:00:00 | 13:00:00 |  |  |  |  | 21:00:00 | 04:00:00 |  |  |  |  | no overlap | no overlap |  | 21:00:00 | 02:00:00
12:00:00 | 13:00:00 |  |  |  |  | 22:00:00 | 04:00:00 |  |  |  |  | no overlap | no overlap |  | 22:00:00 | 02:00:00
 |  |  |  |  |  | 01:00:00 | 04:00:00 |  |  |  |  |  |  |  | 01:00:00 | 02:00:00
 |  |  |  |  |  | 02:00:00 | 04:00:00 |  |  |  |  |  |  |  | no overlap | no overlap
 |  |  |  |  |  | 03:00:00 | 04:00:00 |  |  |  |  |  |  |  | no overlap | no overlap
Spreadsheet: 133538d1324472380-excel-2007-combine-multiple-files-to-one-table-2009-2010
Sheet: 2010 total

Account | 2010-04-29 00:00:00 | 2010-05-17 00:00:00 | 2010-07-02 00:00:00 | 2010 total
0 | 0 | 0 | 0
842 | 0 | 0 | 0
1065 | 0 | 0 | 0
1066 | 1548 | 708 | 0
1105 | 0 | 0 | 0
1163 | 1653 | 560 | 0
1340 | 0 | 0 | 0
1646 | 0 | 0 | 0
1667 | 2032 | 283 | 0
10493 | 0 | 0 | 0
10555 | 210 | 0 | 0
10571 | 0 | 0 | 0
10716 | 0 | 0 | 0
10952 | 0 | 0 | 0
Spreadsheet: 62053d1262952432-vlookup-713075-vlookup
Sheet: LIST

 |  |  |  | DAILY TRANSACTION COUNT |  |  |  | 2010-01-09 01:06:45
 |  |  |  | DEAL REFERENCE
 |  |  |  | XYZ | 4 |  | TUV | 6
 | TIME | NUMBER |  | CLIENT | REFERENCE |  | CLIENT | REFERENCE | REMARKS
 |  | 1 |  | ABC | 58883
 |  | 2 |  |  |  |  | JDD | 442
 |  | 3 |  | ABC | 77781
 |  | 4 |  |  |  |  | LOP | 45
 |  | 5 |  | DEF | 5520
 |  | 6 |  |  |  |  | ABC | 2
 |  | 7 |  |  |  |  | HEG | 44
 |  | 8 |  |  |  |  | SJHAF | 11
 |  | 9 |  |  |  |  | SKL | 88
 |  | 10 |  | DEF | 651485
Spreadsheet: 273829d1382929120-lookup-like-function-and-double-linear-interpolation-need-help-look-up-and-double-linear-interpolation
Sheet: Sheet1

 |  |  |  |  | B
Pressure | 20
Temperature | 10 |  |  |  |  |  | Pressure (psi)
Volume |  |  |  |  |  |  | 10 | 20 | 30 | 40
 |  |  |  |  |  | 10 | 5 | 6 | 7 | 8
 |  |  |  |  | Temperature | 20 | 6 | 7 | 8 | 9
 |  |  |  |  | (deg C) | 30 | 8 | 9 | 10 | 11
 |  |  |  |  |  | 40 | 10 | 12 | 14 | 16
 | Double Linear Interpolation
Spreadsheet: 68263d1268791276-show-billing-cycle-for-a-month-data
Sheet: Data Entry

S.No | Transaction Date | Month | Amount | Billing  Cycle | Billed Date | Due Date | Remarks
1 | 2007-05-19 00:00:00 | [NAME] | 6767 | 21/04/07 - 20/05/07 | 21/05/2007 | Due date is 15 days post to Billed date
2 | 2007-05-19 00:00:00 | [NAME] | 203.01
3 | 2007-05-24 00:00:00 | [NAME] | 25.09
4 | 2007-06-24 00:00:00 | [NAME] | 250
5 | 2007-06-24 00:00:00 | [NAME] | 2255.66
6 | 2007-07-24 00:00:00 | July'2007 | 2255.67
7 | 2007-08-24 00:00:00 | August'2007 | 2255.67
8 | 2007-09-23 00:00:00 | September'2007 | 11990
9 | 2007-10-13 00:00:00 | October'2007 | 760
10 | 2007-10-24 00:00:00 | October'2007 | 2132
11 | 2007-12-02 00:00:00 | December'2007 | 1373.28
12 | 2007-12-02 00:00:00 | December'2007 | 1263.34
13 | 2007-12-12 00:00:00 | December'2007 | 788
14 | 2007-12-18 00:00:00 | December'2007 | 1147
15 | 2008-04-05 00:00:00 | April'2008 | 1395
16 | 2008-04-21 00:00:00 | April'2008 | 141.68
17 | 2008-04-21 00:00:00 | April'2008 | 17.51
18 | 2008-05-05 00:00:00 | May'2008 | 895
19 | 2008-05-21 00:00:00 | May'2008 | 14.4
20 | 2008-08-13 00:00:00 | August'2008 | 3290
21 | 2008-09-24 00:00:00 | September'2008 | 414
22 | 2008-09-25 00:00:00 | September'2008 | 3290
23 | 2008-09-25 00:00:00 | September'2008 | 250
24 | 2008-11-16 00:00:00 | November'2008 | 1216.51
25 | 2008-11-16 00:00:00 | November'2008 | 1216.51
26 | 2008-11-16 00:00:00 | November'2008 | 208.69
27 | 2008-11-16 00:00:00 | November'2008 | 208.69
28 | 2008-11-16 00:00:00 | November'2008 | 1350.89
29 | 2008-11-16 00:00:00 | November'2008 | 1350.89
30 | 2008-11-16 00:00:00 | November'2008 | 683.08
31 | 2008-11-30 00:00:00 | November'2008 | 950
32 | 2008-11-30 00:00:00 | November'2008 | 2350
33 | 2008-11-26 00:00:00 | November'2008 | 402
34 | 2009-01-01 00:00:00 | January'2009 | 11526
Spreadsheet: 140002d1328582856-excel-2007-graph-just-needs-to-be-a-monthly-top-3-list-in-a-table-format-sampledata
Sheet: Sheet1

Correction Month | OrigDesc | NewDesc | Total
2011-08-01 00:00:00 | RMAWAR | Out of Warranty | 733
2011-08-01 00:00:00 | NTF | Other | 493
2011-08-01 00:00:00 | Out of Warranty | Scrap | 472
2011-09-01 00:00:00 | NTF | Other | 761
2011-09-01 00:00:00 | RMAWAR | Out of Warranty | 522
2011-09-01 00:00:00 | NTF | Cosmetic | 402
2011-10-01 00:00:00 | NTF | Other | 743
2011-10-01 00:00:00 | RMAWAR | Out of Warranty | 614
2011-10-01 00:00:00 | NTF | Cosmetic | 526
2011-11-01 00:00:00 | NTF | Other | 858
2011-11-01 00:00:00 | Scrap | Out of Warranty | 584
2011-11-01 00:00:00 | NTF | Cosmetic | 491
2011-12-01 00:00:00 | NTF | Other | 1076
2011-12-01 00:00:00 | RMAWAR | Out of Warranty | 926
2011-12-01 00:00:00 | NTF | Cosmetic | 912
Spreadsheet: joe_parks__14939__BridgeDPR0419
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1346.10412 | 1346.10412 | 6637.10412
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1346.10412 | 1346.10412 | 6637.10412
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: john_griffith__15779__10_19_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL X1 | EXP |  |  | 63.1 | 74 | 0.95 | 2001-10-16 14:40:00
 | CL Z1 | 21.5 | 255 | 270 | 55.9 | 59.2 | 0.78 | 2001-10-19 10:06:00
 | CL F2 | 22 | 355 | 370 | 52 | 54.2 | 0.73 | 2001-10-19 10:06:00
 | CL G2 | 22 | 423 | 435 | 49.4 | 50.8 | 0.69 | 2001-10-19 10:06:00
 | CL H2 | 22 | 460 | 475 | 46.8 | 48.4 | 0.66 | 2001-10-19 10:06:00
 | CL J2 | 22 | 485 | 505 | 44.4 | 46.2 | 0.63 | 2001-10-19 10:06:00
 | CL K2 | 22 | 505 | 525 | 41.9 | 43.6 | 0.59 | 2001-10-19 10:06:00
 | CL M2 | 22 | 520 | 535 | 40.3 | 41.4 | 0.57 | 2001-10-19 10:06:00
 | CL N2 | 22 | 525 | 540 | 38 | 39.1 | 0.53 | 2001-10-19 10:06:00
 | CL Q2 | 22 | 530 | 542 | 36.3 | 37.2 | 0.51 | 2001-10-19 10:06:00
 | CL U2 | 22 | 535 | 548 | 35 | 35.8 | 0.49 | 2001-10-19 10:06:00
 | [NAME] | 22 | 535 | 550 | 33.3 | 34.3 | 0.47 | 2001-10-19 10:06:00
 | [NAME] | 21.5 | 535 | 555 | 31.7 | 32.9 | 0.44 | 2001-10-19 10:06:00
 | CL M3 | 21.5 | 530 | 560 | 26.7 | 28.2 | 0.37 | 2001-10-19 10:06:00
 | CL Z3 | 21.5 | 530 | 565 | 23.8 | 25.4 | 0.33 | 2001-10-19 10:06:00
Spreadsheet: 748567d1632219038-top-three-data-with-xlookup-fb-sheet
Sheet: Sheet1

Product | Cust | QTY
urea | A1 | 0
urea | B1 | 10 |  |  |  |  |  |  |  | Row Labels | Sum of QTY
urea | A2 | 5 |  | DAP |  |  |  |  |  | DAP | 1007
urea | A3 | 100 |  | TOP1 |  |  |  |  |  | A1 | 85
urea | A1 | 55 |  | TOP2 |  | C2 |  |  |  | A2 | 20
urea | B2 | 1 |  | TOP3 |  | C1 |  |  |  | A4 | 10
urea | A4 | 99 |  |  |  |  |  |  |  | A5 | 80
DAP | A5 | 80 |  |  |  |  |  |  |  | A6 | 74
DAP | A6 | 74 |  | Urea |  |  |  |  |  | B1 | 65
DAP | C1 | 108 |  | TOP1 |  |  |  |  |  | C1 | 108
DAP | C2 | 110 |  | TOP2 |  | A3 |  |  |  | C2 | 110
DAP | [NAME] | 13 |  | TOP3 |  | A2 |  |  |  | [NAME] | 13
urea | A4 | 17 |  |  |  |  |  |  |  | d | 2
DAP | A4 | 10 |  |  |  |  |  |  |  | f | 23
urea | C2 | 15 |  |  |  |  |  |  |  | h | 65
DAP | A2 | 20 |  |  |  |  |  |  |  | kr | 3
urea | A2 | 79 |  |  |  |  |  |  |  | s | 31
DAP | A1 | 85 |  |  |  |  |  |  |  | j | 4
DAP | B1 | 65 |  |  |  |  |  |  |  | v | 314
urea | A1 | 5 |  |  |  |  |  |  |  | urea | 386
DAP | d | 2 |  |  |  |  |  |  |  | A1 | 60
DAP | f | 23 |  |  |  |  |  |  |  | A2 | 84
DAP | h | 65 |  |  |  |  |  |  |  | A3 | 100
DAP | kr | 3 |  |  |  |  |  |  |  | A4 | 116
DAP | s | 31 |  |  |  |  |  |  |  | B1 | 10
DAP | j | 4 |  |  |  |  |  |  |  | B2 | 1
DAP | v | 314 |  |  |  |  |  |  |  | C2 | 15
 |  |  |  |  |  |  |  |  |  | (blank)
 |  |  |  |  |  |  |  |  |  | Grand Total | 1393
Spreadsheet: 85936d1285933188-a-potential-bug-in-excel-2010-with-tables-and-if-commands-budget
Sheet: In vs. Out

 | Out |  |  |  | In
 | Rent (350) | 350 |  |  | Bursary | 202.75
 | Food (130) | 130 |  |  | RED Office
 | Phone (20) | 20 |  |  | PT | 30
 | Internet (11) | 11
 | Bills (30) | 30
 | CTAX (50) | 50
 | Gym (43.95) | 43.95
 | Total |  |  |  | Total |  |  |  | Disposable Income
Spreadsheet: 135774d1326224813-production-capacity-planning-required-hrs-per-week-per-department-planning-report
Sheet: HOrg

 | Customer | Qty |  |  |  |  |  |  | Ship Date |  |  | W/O | PART# |  | KIT |  | CUT START | CUT HRS
2 | cust #1 | 42 |  |  |  |  |  |  | 2012-01-19 00:00:00 |  |  | WO0061180 / 0 | 1127354/002 | COMP | YES | COMP | 2011-07-22 00:00:00 | 119.8399999999998 |  | CUTTING
2 | cust #1 | 57 |  |  |  |  |  |  | 2012-03-01 00:00:00 |  |  | [NAME] / 0 | 1127354/002 | COMP | NO | 2011-09-21 00:00:00 | 2011-07-03 00:00:00 | 162.6399999999998 |  | # of Cutters Available = |  |  |  | 10
2 | cust #1 | 45 |  |  |  |  |  |  | 2012-02-02 00:00:00 |  |  | WO0061578 / 0 | 1127354/002 | COMP | NO | 2011-09-25 00:00:00 | comp |  |  | Week Starting | Week Ending | Required Hrs | Available Hrs | [NAME]
2 | cust #1 | 52 |  |  |  |  |  |  | 2012-02-09 00:00:00 |  |  | WO0061510 / 0 | 1127437/002 | COMP | NO | 2011-10-09 00:00:00 | 2011-09-01 00:00:00 | 67.86 |  | Backlog
1 | cust #2 | 10 |  |  |  |  |  |  | 2012-02-01 00:00:00 |  |  | WO0061853 / 0 | E12672442 | COMP | NO | 2011-10-19 00:00:00 | 2011-09-28 00:00:00 | 28.78
2 | cust #2 | 41 |  |  |  |  |  |  | 2012-01-26 00:00:00 |  |  | WO0061579 / 0 | 1127437/002 | COMP | YES | COMP | comp
1 | cust #2 | 5 |  |  |  |  |  |  | 2011-12-09 00:00:00 |  |  | WO0058470 / 0 | E12636826 | COMP | YES | COMP | 2012-01-12 00:00:00 | 4.308333333333335
1 | cust #2 | 1 |  |  |  |  |  |  | 2011-12-09 00:00:00 |  |  | WO0059052 / 0 | E12671579 | COMP | YES | COMP | 2012-01-12 00:00:00 | 2.40857142857143
1 | cust #2 | 1 |  |  |  |  |  |  | 2011-12-09 00:00:00 |  |  | WO0058468 / 0 | E12636826 | COMP | YES | COMP | 2012-01-12 00:00:00 | 0.861666666666667
Spreadsheet: 3a02f0ce-801f-4e00-aac8-384b00308415
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
RNAUR | Test | RNAUR | Sodium, Random, [NAME] | Sodium, Random, U | Potentiometric, Indirect Ion-Selective Electrode | [NAME]: Urine |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect a random urine specimen. 2. No preservative. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | No established reference values | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 84300 |  |  |  |  | Rochester
RNAUR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
RNAUR | Result | RNAUR | Sodium, Random, U | Sodium, Random, U | Numeric |  |  |  |  | mmol/L |  |  |  |  |  |  |  |  |  | 2955-3 | Sodium:SCnc:Pt:[NAME]:Qn:
Spreadsheet: 809505d1671119556-looking-up-currency-and-returning-usd-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | FX Rates | 1 USD equals
 | Currency | Jan | Feb | Mar | USD Jan | USD Feb | [NAME] |  | USD | 1
 | USD | 2000 | 1000 | 500 |  |  |  |  | GBP | 0.82
 | GBP | 0 | 500 | 500 |  |  |  |  | EUR | 0.94
 | EUR | 1000 | 0 | 200 |  |  |  |  | AUD | 1.49
 | AUD | 50 | 200 | 0 |  |  |  |  | HKD | 7.77
 |  |  |  |  |  |  |  |  | SGD | 1.36
Spreadsheet: 101308d1299473373-excel-2007-excel-2007-search-fields-and-multiple-values-in-results-temp
Sheet: Overview

 |  | Air Freight - Lookup Airlines & Airports
 |  | BY AIRLINE NAME | Airline 2-Letter Code | Airline 3-Digit Code
 |  |  | Fill in Airline Name Above | Fill in Airline Name Above
 |  | BY AIRLINE ABBR. | Airline Name | Airline 3-Digit Code
 |  |  | Fill in Airline Abbr. Above | Fill in Airline Abbr. Above
 |  | BY AIRLINE NUMBER | Airline Name | Airline 2-Letter Code
 |  |  | Fill in Airline Number Above | Fill in Airline Number Above
 |  | AIRPORT LOOKUP | Code --> Airport Name | Name --> Airport Code
 |  |  | Fill in Airport Code Above | Fill in Airport Code Above
 | Note:
 | -Look in column C to determine which row you should use. For example, you have 180, insert it in D14 or E14 to find missing info.
 | -Best usage is with exact codes. For example: ICN, 180, KE etc.
 | -Searches have to be exact match with the database, otherwise, it will not find what you are looking for.
 | -Manual Searches can be done by accessing the different worksheets tabs below and pressing CTRL+F.
 | -This was a small project to refresh my Excel skills and to help me out with my work.