tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 272291d1382345970-formula-for-giving-people-experience-against-tools-they-used-not-working-copy-of-competa_example
Sheet: Application

Application Code | WORKSHOP TECHNICIAN EQUIPMENT MATRIX
 | Application |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
 |  |  | IR | IR |  |  | JL | JL | SR | SR
Code | CASING TOOL Applications | Code | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |  | 1 |  | Has no experience in application
SCRP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | Has been  2nd man in this application
SCSS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | Has been main engineer 5 or less of this application
SCST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | Has been main engineer on 5 or more of this application
SCH
SCC
SCL
 | Multi - Set Packer Applications
SPCT
SPWS
SPCS
SPWS
 | Single Set Packer Applications
PRBP
PRCR
RRBP
RRCR
SSA
 | Other
SLPA
POFR
PRKT
IILH
CACR
 | Courses
 |  |  | Yes/No |  |  |  | Yes/No |  |  |  | Yes/No |  |  |  | Yes/No |  | Yes/No
 | Hydraulics Seminar |  | No |  |  |  | No |  |  |  | No |  |  |  | No |  | No
 | [NAME] |  | No |  |  |  | No |  |  |  | No |  |  |  | No |  | No
 | Thru Tubing Seminar |  | Yes |  |  |  | Yes |  |  |  | Yes |  |  |  | Yes |  | Yes
 | [NAME] |  | Yes |  |  |  | Yes |  |  |  | Yes |  |  |  | Yes |  | Yes
 | Posi- [NAME] |  | No |  |  |  | No |  |  |  | No |  |  |  | No |  | No
Spreadsheet: 0651866f-7224-4fd5-a7d0-223968d1f9d2
Sheet: teams

league | division | position in final league standings in 1986 | team | number of wins in 1986 | number of losses in 1986 | attendance for home games in 1986 | attendance for away games in 1986 | 1987 average salary
N | E | 1 | N.Y. | 108 | 54 | 2767601 | 2176615 | 526899
N | E | 2 | Phi. | 86 | 75 | 1933335 | 1721147 | 540930
N | E | 3 | St.L. | 79 | 82 | 2471974 | 1695738 | 445049
N | E | 4 | Mon. | 78 | 83 | 1128981 | 1926119 | 312959
N | E | 5 | Chi. | 70 | 90 | 1859102 | 1879706 | 556256
N | E | 6 | Pit. | 64 | 98 | 1000917 | 1651057 | 223730
N | W | 1 | Hou. | 96 | 66 | 1734276 | 1816220 | 430363
N | W | 2 | Cin. | 86 | 76 | 1692432 | 1849888 | 313194
N | W | 3 | S.F. | 83 | 79 | 1528748 | 1924802 | 326583
N | W | 4 | S.D. | 74 | 88 | 1805716 | 1779829 | 405340
N | W | 5 | L.A. | 73 | 89 | 3023208 | 2074970 | 580250
N | W | 6 | Atl. | 72 | 89 | 1387181 | 1837380 | 462188
A | E | 1 | [NAME]. | 95 | 66 | 2147641 | 2266765 | 552646
A | E | 2 | N.Y. | 90 | 72 | 2268030 | 2196697 | 551519
A | E | 3 | [NAME]. | 87 | 75 | 1899437 | 1821142 | 445978
A | E | 4 | Tor. | 86 | 76 | 2455477 | 1716243 | 423417
A | E | 5 | Cle. | 84 | 78 | 1471805 | 1727486 | 363073
A | E | 6 | [NAME]. | 77 | 84 | 1265041 | 1707552 | 266542
A | E | 7 | Bal. | 73 | 89 | 1973176 | 1737994 | 550229
A | W | 1 | Cal. | 92 | 70 | 2655872 | 1685439 | 408181
A | W | 2 | Tex. | 87 | 75 | 1692002 | 1670132 | 240250
A | W | 3 | K.C. | 76 | 86 | 2320794 | 1909566 | 405833
A | W | 4 | Oak. | 76 | 86 | 1314646 | 1614837 | 392951
A | W | 5 | Chi. | 72 | 90 | 1424313 | 1852893 | 371979
A | W | 6 | Min. | 71 | 91 | 1255453 | 1707440 | 432097
A | W | 7 | Sea. | 67 | 95 | 1029045 | 1558546 | 186146
Spreadsheet: 68782718-caa2-4aa3-8e81-d080804ada40
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259268 | 30573 | Oswald | [NAME] | RSA | 71 | 00:16:17 | 00:03:43 | 00:37:33 | 00:02:46 | [NAME] | 1 | 1:29:40
Spreadsheet: 40867154-4677-4fc0-8b31-f9e5b9e19852
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
19377 | Test | 19377 | PDGFRB/TEL Translocation 5;12 for Chronic Myelomoncytic Leukemia (CMML), FISH | PDGFRB/TEL, FISH |  |  |  |  | 5 | mL | Only to be ordered by internal pathology clients. |  |  |  | Samples processed Monday through Sunday.  Results reported Monday through Friday 8am-5pm CST |  |  |  | Profile |  |  |  |  | Rochester
19377 | Billing Component | 19377 |  | Cytogenetic Interp/Report |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88291
19377 | Billing Component | 19377 |  | Molecular gen, 100-300 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 88275
19377 | Billing Component | 19377 |  | [NAME],each |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 88271
Spreadsheet: f1baaeb4-f503-4113-9398-f9df74f99737
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
AMT | Test | AMT | Amitriptyline and [NAME], Serum | Amitriptyline and Nortriptyline, S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red |  |  | 3 | mL | Container/Tube: Red top [NAME]: 3 mL Collection Instructions: 1. Draw specimen immediately before next scheduled dose (minimum 12 hours after last dose). 2. Serum must be separated from cells within 2 hours of draw. | 1.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK  Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | AMITRIPTYLINE AND NORTRIPTYLINE Total therapeutic concentration: 80-200 ng/mL Total toxic concentration: > or =300 ng/mL   NORTRIPTYLINE ONLY Therapeutic concentration: 70-170 ng/mL Toxic concentration: > or =300 ng/mL Note: Therapeutic ranges are for specimens drawn at trough (ie, immediately before next scheduled dose). Levels may be elevated in non-trough specimens. | Monday through Friday; Varies | 2 days | 4 days |  | Profile |  |  |  |  | Rochester
AMT | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
AMT | Result | 8125 | Amitriptyline | Amitriptyline | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3333-2 | Amitriptyline:MCnc:Pt:Ser/Plas:Qn:
AMT | Result | 2450 | Nortriptyline | Nortriptyline | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3872-9 | Nortriptyline:MCnc:Pt:Ser/Plas:Qn:
AMT | Result | 2451 | Amitriptyline and Nortriptyline | Amitriptyline and Nortriptyline | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3335-7 | Amitriptyline+Nortriptyline:MCnc:Pt:Ser/Plas:Qn:
AMT | Billing Component | AMT |  | Nortriptyline |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 80182
AMT | Billing Component | AMT |  | Amitriptyline |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 80152
Spreadsheet: 270199d1381413525-count-values-between-dates-and-multiple-criteria-ecompassanalytics_3
Sheet: Sheet1

 |  |  |  |  | Week of | 2013-09-01 00:00:00 | 2013-09-08 00:00:00 | 2013-09-15 00:00:00 | 2013-09-22 00:00:00 | 2013-09-29 00:00:00 | 2013-10-06 00:00:00 | 2013-10-13 00:00:00 | 2013-10-20 00:00:00 | 2013-10-27 00:00:00 | 2013-11-03 00:00:00 | 2013-11-10 00:00:00 | 2013-11-17 00:00:00 | 2013-11-24 00:00:00
 |  |  |  |  | Week End | 2013-09-07 00:00:00 | 2013-09-14 00:00:00 | 2013-09-21 00:00:00 | 2013-09-28 00:00:00 | 2013-10-05 00:00:00 | 2013-10-12 00:00:00 | 2013-10-19 00:00:00 | 2013-10-26 00:00:00 | 2013-11-02 00:00:00 | 2013-11-09 00:00:00 | 2013-11-16 00:00:00 | 2013-11-23 00:00:00 | 2013-11-30 00:00:00
 |  |  |  |  | New Cases Assigned in the week
 |  |  |  |  | Cases closed in the week
 |  |  |  |  | EOW Cases Opened
Spreadsheet: 474740d1470882278-highlight-or-color-an-alphabetical-list-conditional_formatting_example
Sheet: Sheet1

a
a
a
b
c
d
d
e
f
g
h
h
h
h
h
h
h
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
Spreadsheet: 845538d1697023251-i-need-help-in-attached-excel-sheet-calculation-of-no-of-days-with-formula-excel-results-required-no-of-days-calculation-etaf
Sheet: Excel Help Required

Security  Code | Maturity Date | Customer Name | CCY | Issue Date | Face Value of Investment | Tenor of INPCs | Profit | No. of | PROFIT JUN 23 | Profit | No. of | PROFIT JUL 23 | Profit | No. of | PROFIT AUG 23 | Profit | No. of | PROFIT Sep 23 | Profit | No. of | PROFIT Oct 23 | TOTAL PROFIT
 |  |  |  |  |  |  |  |  | 2023-06-01 00:00:00 |  |  | 2023-07-01 00:00:00 |  |  | 2023-08-01 00:00:00 |  |  | 2023-09-01 00:00:00 |  |  | 2023-10-01 00:00:00
 |  |  |  |  |  |  | Rate % | Days | 2023-06-30 00:00:00 | Rate % | Days | 2023-07-31 00:00:00 | Rate % | Days | 2023-08-31 00:00:00 | Rate % | Days | 2023-09-30 00:00:00 | Rate % | Days | 2023-10-31 00:00:00
 |  |  |  |  |  |  | 2023-06-01 00:00:00 | 2023-06-01 00:00:00 |  | 2023-07-01 00:00:00 | 2023-07-01 00:00:00 |  | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 |  | 2023-09-01 00:00:00 | 2023-09-01 00:00:00 | 30 | 2023-10-01 00:00:00 | 2023-10-01 00:00:00 | 31 | TO DATE
393100-584 | 2024-06-05 00:00:00 | [NAME] | USD | 2023-06-05 00:00:00 | 5000 | 1-Year | 0.0651 |  |  | 0.0651 |  |  | 0.0649 |  |  | 0.065 |  |  | 0.065
373100-584 | 2023-09-09 00:00:00 | [NAME] | PKR | 2023-06-09 00:00:00 | 300000 | 3-Months | 0.1051 |  |  | 0.1051 |  |  | 0.1051 |  |  | 0.155 |  |  | 0.155
393100-584 | 2023-12-14 00:00:00 | [NAME] | GBP | 2023-06-14 00:00:00 | 5000 | 6-Months | 0.0651 |  |  | 0.0651 |  |  | 0.0649 |  |  | 0.065 |  |  | 0.065
393100-585 | 2026-06-19 00:00:00 | [NAME] | EUR | 2023-06-19 00:00:00 | 9000 | 3-Year | 0.0651 |  |  | 0.0651 |  |  | 0.0649 |  |  | 0.065 |  |  | 0.065
393100-585 | 2028-06-27 00:00:00 | Natasha | USD | 2023-06-27 00:00:00 | 5000 | 5-Year | 0.0651 |  |  | 0.0651 |  |  | 0.0649 |  |  | 0.065 |  |  | 0.065
 |  |  |  |  |  |  | Result req |  |  | Result req |  |  | Result req |  |  | Result req |  |  | Result req
 |  |  |  |  |  |  |  | I NEED A FORMULA FOR HAVING NUMBER OF DAYS IN EACH MONTH LIKE IF MONTH AFTER MATURITY IS JULY 31 DAYS, AUGUST 31 DAYS, SEPTEMBER 30 DAYS, …….. AND IN THE MONTH OF MATURITY THE REMAINING NUMBER OF DAYS DURING THAT CERTIFICATE WAS OUTSTANDING.  Other wise profit calculation on each month will be overstated. Also rate of profit in each month is keep on changing. Thus, we need excat number of days on monthly basis to calculate and disburse monthly profit on the basis of new monthly rate. Please see below stuff how we need no. of days month wise with the help of formula.
 |  |  |  |  |  |  |  | 26 |  |  | 31 |  |  | 31 |  |  | 30 |  |  | 31
 |  |  |  |  |  |  |  | 22 |  |  | 31 |  |  | 31 |  |  | 8 |  |  | 0
 |  |  |  |  |  |  |  | 17 |  |  | 31 |  |  | 31 |  |  | 30 |  |  | 31
 |  |  |  |  |  |  |  | 12 |  |  | 31 |  |  | 31 |  |  | 30 |  |  | 31
 |  |  |  |  |  |  |  | 4 |  |  | 31 |  |  | 31 |  |  | 30 |  |  | 31
Spreadsheet: 837540d1690219632-how-do-you-provide-points-based-on-a-defined-lookup-targets-table-points-based-on-value-solution-
Sheet: Hoja5

 |  | Target |  | Pts
[NAME] | Test | 0.1 | <= | 10 |  |  | Test3 | Pts
[NAME] | Test | 0.13 | <= | 5 |  | [NAME] | 110
[NAME] | Test | 0.17 | <= | 2 |  | [NAME] | 72 | 5
[NAME] | Test | 0.17 | > | 0 |  | [NAME] | 35 | 0
Area2 | Test | 0.12 | <= | 10 |  | [NAME] | 100 | 10
Area2 | Test | 0.15 | <= | 7 |  | [NAME] | 46 | 2
Area2 | Test | 0.19 | <= | 4 |  | [NAME] | 5 | 0
Area2 | Test | 0.19 | > | 0 |  | Area2 | 110 | 10
[NAME] | Test2 | 30 | <= | 10 |  | Area2 | 60 | 7
[NAME] | Test2 | 40 | <= | 5 |  | Area2 | 35 | 1
[NAME] | Test2 | 45 | <= | 2 |  | Area2 | 20 | 0
[NAME] | Test2 | 45 | > | 0
Area2 | Test2 | 20 | <= | 10
Area2 | Test2 | 30 | <= | 7
Area2 | Test2 | 35 | <= | 4
Area2 | Test2 | 35 | > | 0
[NAME] | Test3 | 100 | >= | 10
[NAME] | Test3 | 70 | >= | 5
[NAME] | Test3 | 45 | >= | 2
[NAME] | Test3 | 45 | < | 0
Area2 | Test3 | 100 | >= | 10
Area2 | Test3 | 60 | >= | 7
Area2 | Test3 | 35 | >= | 1
Area2 | Test3 | 35 | < | 0
Spreadsheet: 544839d1509048813-changing-color-of-line-chart-with-source-data-chart-samples
Sheet: CS 1 Series 3 Targets

 |  |  |  |  |  | F9 to randomize data
# | Series 1 | Series 2 | >=7 | 4 to 6 | <4
1
2
3
4
5
6
7
8
Spreadsheet: 215807d1361490629-help-needed-for-uni-project-number-of-column-formula-required-map1-21-02-2012-oeldere-
Sheet: Blad1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Never | seldom | sometimes | often | very often | always | AD3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Never | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | seldom | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sometimes | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | often | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | very often | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | always | 6
Spreadsheet: 125690d1319168767-filtering-values-in-a-pivot-table-sample
Sheet: Sheet1

Account | Company | Period | USD
3rd Party Creditors | 2876 | 005.2011 | -640
3rd Party Creditors | DE01 | 005.2011 | 0
3rd Party Creditors | GB02 | 005.2011 | 0
3rd Party Creditors | [NAME] | 005.2011 | -76369679
3rd Party Creditors | NL02 | 005.2011 | -5309422
3rd Party Creditors | PL01 | 005.2011 | -6601
3rd Party Creditors | TR01 | 005.2011 | -615
3rd Party Creditors | ZA01 | 005.2011 | 17
3rd Party Creditors | 2039 | 005.2011 | -2469
3rd Party Creditors | AE01 | 005.2011 | -226675
3rd Party Creditors | AU01 | 005.2011 | -628254
3rd Party Creditors | HK01 | 005.2011 | -4617658
3rd Party Creditors | JP01 | 005.2011 | -4031535
3rd Party Creditors | JP02 | 005.2011 | 0
3rd Party Creditors | KR01 | 005.2011 | 0
3rd Party Creditors | KR02 | 005.2011 | 0
3rd Party Creditors | PH01 | 005.2011 | 0
3rd Party Creditors | SG01 | 005.2011 | -6319649
3rd Party Creditors | SG02 | 005.2011 | -1936818
3rd Party Creditors | SG03 | 005.2011 | -6550411
3rd Party Creditors | SG04 | 005.2011 | -25712170
3rd Party Creditors | TH01 | 005.2011 | 0
3rd Party Creditors | VN01 | 005.2011 | 3272
3rd Party Creditors | 2254 | 005.2011 | -394000
3rd Party Creditors | CA01 | 005.2011 | -461645
3rd Party Creditors | CA02 | 005.2011 | -9444
3rd Party Creditors | USJ2 | 005.2011 | -6620957
3rd Party Creditors | GB01 | 005.2011 | 0
3rd Party Creditors | 2876 | 006.2011 | -614
3rd Party Creditors | DE01 | 006.2011 | -1
3rd Party Creditors | GB02 | 006.2011 | 0
3rd Party Creditors | [NAME] | 006.2011 | -53046774
3rd Party Creditors | NL02 | 006.2011 | -5429751
3rd Party Creditors | PL01 | 006.2011 | 0
3rd Party Creditors | TR01 | 006.2011 | -131150
3rd Party Creditors | ZA01 | 006.2011 | -4225
3rd Party Creditors | 2039 | 006.2011 | -1857
3rd Party Creditors | AE01 | 006.2011 | -462544
3rd Party Creditors | AU01 | 006.2011 | -114349
3rd Party Creditors | HK01 | 006.2011 | 3067
3rd Party Creditors | JP01 | 006.2011 | -202235
3rd Party Creditors | JP02 | 006.2011 | 0
3rd Party Creditors | KR01 | 006.2011 | 0
3rd Party Creditors | KR02 | 006.2011 | 0
3rd Party Creditors | PH01 | 006.2011 | 0
3rd Party Creditors | SG01 | 006.2011 | -6083175
3rd Party Creditors | SG02 | 006.2011 | -1702216
3rd Party Creditors | SG03 | 006.2011 | -7617703
3rd Party Creditors | SG04 | 006.2011 | -19837230
3rd Party Creditors | TH01 | 006.2011 | 0
3rd Party Creditors | VN01 | 006.2011 | 3272
3rd Party Creditors | 1155 | 006.2011 | 0
3rd Party Creditors | 1862 | 006.2011 | 0
3rd Party Creditors | 2254 | 006.2011 | -45000
3rd Party Creditors | CA01 | 006.2011 | -463
3rd Party Creditors | CA02 | 006.2011 | -29900
3rd Party Creditors | USJ2 | 006.2011 | -7715128
3rd Party Creditors | GB01 | 006.2011 | -786
Spreadsheet: rick_buy__32955__Raptor 3b
Sheet: Hawaii Summary

Summary of Hawaii Securitizations
Today
Series | Date | # of Warrants | Close Price | Notional | Debt | Debt O/S | Equity | Equity Rate | Days O/S | Equity O/S
A | 2000-03-31 00:00:00 | 33832 | 591 |  | 18023750 |  | 1976250 | 0.15
B/D | 2000-09-29 00:00:00 | 42291 |  |  | 86971504 |  | 3954146 | 0.15
C | 2000-08-28 00:00:00 | 13955 |  |  | 29111495 |  | 900355 | 0.15
Strike
Screen
Derivative Asset/Liability to Porcupine Summary
 | Receivable | Payable
A
B/D
C
TOTAL
Spreadsheet: 50534d1249994152-populating-data-from-another-sheet-sheet-b
Sheet: Sheet1

Distributor | Sold To Name | Sold To | PO | Order | Term | Order'd | Promise | Date In | Date Out | Status | Build Date | Package Date | Shipping Date
Company A |  | 497281 | ORAS #0818 A | 2240119 | A03 | 2009-03-10 00:00:00 | 2009-06-20 00:00:00 | 7/21pBO | BO | O/A | 2009-05-20 00:00:00 | 2009-06-18 00:00:00 | 2009-06-20 00:00:00
Company B |  |  | ORAS # [NAME] | 2262396 | A03 | 2009-06-03 00:00:00 | 2009-08-07 00:00:00 |  |  | O/A | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-06-03 00:00:00
Company C |  | 1199517 | ORAS # 0903C | 2255405 | A08 | 2009-05-08 00:00:00 | 2009-06-05 00:00:00 | 6/30p |  | CIA | 2009-04-01 00:00:00 | 2009-05-31 00:00:00 | 2009-06-05 00:00:00
Spreadsheet: 112424d1308575115-excel-2007-archive-data-into-next-empty-cell-book2
Sheet: Sheet1

ACTUAL DATA ENTRY |  |  |  | ARCHIVE ( example)
Qty | Type | Date |  | Qty | Type | Date
240000 | A | 2011-06-20 00:00:00 |  | 112000 | C |  |  | [NAME] or code needed to use archive button to populate data entry from A3 to C3 into the next blanks in columns E to G
 |  |  |  | 116000 | A
 |  |  |  | 118000 | B
 |  |  |  | 220000 | D
 |  |  |  | 235000 | C
 |  |  |  |  | etc
Spreadsheet: 483808d1475858152-client-data-in-columns-how-to-create-a-client-drop-down-sample-client-data-vlookup
Sheet: Sheet1

Name |  | Client A |  |  | Client A |  |  | Client B |  |  | Client C |  |  | Client D
 |  | Selection | Comments |  | Selection | Comments |  | Selection | Comments |  | Selection | Comments |  | Selection | Comments
Address |  |  |  |  | 1234 Main | None |  | 1234 Fourth | None |  | 1234 [NAME] | US |  | 1234 Rural | Change
Option |  |  |  |  | A | Please verify |  | B | Verify |  | C | Verify |  | D
Cost |  |  |  |  | 1 | Accepted |  | 2 | 3.5 |  | 3 | 1 |  | 4 | 2
[NAME] |  |  |  |  | 0.15 |  |  | 0.25 | 0.15 |  | 0.1 | 0.5 |  | 0.5 | 0.4
Discount |  |  |  |  | 0.5 |  |  | 0.5 | 0.25 |  | 0.5 | 0.5 |  | 0.5 | 0.5
AM |  |  |  |  | [NAME] | East coast |  | [NAME] | West coast |  | Ruben | MidWest |  | Marge | East coast
Network |  |  |  |  | X | Tentative |  | X | All |  | X | None |  | X | All
Rebates |  |  |  |  | Full |  |  | Shared | Shared |  | Full | None |  | Shared | Confirm
 |  | Data populated based on [NAME]
 |  | selection
Spreadsheet: darrell_schoolcraft__7876__SUNFLOWER - NNG1
Sheet: JAN

NORTHERN NATURAL GAS NOMINATION FORM
FOR SUNFLOWER ELECTRIC (S4 & S5)
ON BEHALF OF WEST PLAINS ENERGY
FOR MONTH OF: |  |  | JANUARY
TO: | JENNIFER MOSSER |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | FROM: | [NAME]
 | DICK CULSHAW |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE]
 | [NAME] |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | FAX: | [PHONE]
 | [NAME] |  | [PHONE]
FAX: | [PHONE]
 |  |  |  |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  |  | TOTAL
 | VOLUME |  |  |  |  | VOLUME |  |  |  |  | VOLUME |  |  |  |  | VOLUME
GAS | 1ST |  |  | CON | GAS | 2ND |  |  | CON | GAS | 3RD |  |  | CON | GAS | 4TH |  |  | CON | GAS
DAY | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE
1 | 0 | 2000-12-29 00:00:00 | 07:56:00
2 | 0 | 2000-12-29 00:00:00 | 07:56:00
3 | 0 | 2001-01-02 00:00:00 | 08:09:00
4 | 0 | 2001-01-03 00:00:00 | 07:59:00
5 | 0 | 2001-01-04 00:00:00 | 07:50:00
6 | 150 | 2001-01-05 00:00:00 | 07:54:00
7 | 150 | 2001-01-05 00:00:00 | 07:54:00
8 | 150 | 2001-01-05 00:00:00 | 07:54:00
9 | 150 | 2001-01-08 00:00:00 | 07:59:00
10 | 150 | 2001-01-09 00:00:00 | 06:37:00
11 | 150 | 2001-01-10 00:00:00 | 07:55:00
12 | 150 | 2001-01-11 00:00:00 | 07:56:00
13 | 150 | 2001-01-12 00:00:00 | 07:34:00
14 | 150 | 2001-01-12 00:00:00 | 07:34:00
15 | 150 | 2001-01-12 00:00:00 | 07:34:00
16 | 2000 | 2001-01-15 00:00:00 | 02:51:00
17 | 150 | 2001-01-16 00:00:00 | 07:30:00
18 | 150 | 2001-01-17 00:00:00 | 07:17:00
19 | 150 | 2001-01-18 00:00:00 | 07:52:00
20 | 150 | 2001-01-19 00:00:00 | 08:00:00
21 | 150 | 2001-01-19 00:00:00 | 08:00:00
22 | 150 | 2001-01-19 00:00:00 | 08:00:00
23 | 150 | 2001-01-22 00:00:00 | 08:03:00
24 | 150 | 2001-01-23 00:00:00 | 07:51:00 |  |  | 2500 | 2001-01-23 00:00:00 | 12:36:00 |  |  | 800 | 2001-01-24 00:00:00 | 16:26:00
25 | 150 | 2001-01-24 00:00:00 | 08:16:00
26 | 1500 | 2001-01-24 00:00:00 | 16:36:00 |  |  | 200 | 2001-01-26 00:00:00 | 11:31:00
27 | 150 | 2001-01-26 00:00:00 | 08:13:00
28 | 150 | 2001-01-26 00:00:00 | 08:13:00
29 | 150 | 2001-01-26 00:00:00 | 08:13:00
30 | 150 | 2001-01-29 00:00:00 | 08:08:00
31 | 150 | 2001-01-30 00:00:00 | 08:06:00
Spreadsheet: 854004d1703959044-vlookup-hyperlinks-weekly-cooking_small
Sheet: PICK IT

What Meal? |  |  |  |  | Ingredient List |  |  |  |  |  | Recipe
Oriental Beef Sir-fry
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 13a

 |  | Dealers** |  | Buyside |  | TOTAL
Product |  | Cleared | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Single - Name* | Corporate | 478906 | 6464135 | 479109 | 663407 | 958015 | 7127542
 | Loans |  | 10406 |  | <1,000 |  | 10406
 | Municipal |  | 40199 |  | 1921 |  | 42120
 | Recovery
 | Sovereign | 33858 | 2270398 | 33858 | 205497 | 67717 | 2475895
Index Tranche | Asia |  |  |  | <1,000 |  | <1,000
 | Europe |  | 535519 |  | 32313 |  | 567833
 | North America |  | 575878 |  | 28220 |  | 604098
Index | Asia | 3357 | 236722 | 3778 | 43946 | 7135 | 280668
 | Europe | 466757 | 2389305 | 545507 | 415863 | 1012264 | 2805168
 | North America | 552760 | 1366790 | 676847 | 328327 | 1229607 | 1695117
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL |  | 1535638 | 13889351 | 1739099 | 1719496 | 3274737 | 15608847
Estimated gross notional amount outstanding, October 25 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 174628d1345129514-if-statement-with-vlookup-nested-sample
Sheet: Sheet1

Code | Amount | Check |  | Code | Threshold | Vlookup Value
Shoe | 60 | Check |  | Shoe | 50 | Shoe50
Shoe | 110 | ok |  | Coat | 30 | Coat30
Scarf | 35 | Check |  | Hat | 60 | Hat60
Hat | 55 | ok |  | Scarf | 10 | Scarf10
Coat | 60 | Check
Shoe | 60.06 | Check
Scarf | 68.01 | Check
Hat | 21 | ok
Coat | 30 | ok
Spreadsheet: 82791d1282818665-v-lookup-question-helpme
Sheet: EDIT AUB

[NAME]
Date | Supplier | FPD Lot | Supplier Lot | Germ | TGW | [NAME] | Qty IN | Qty REMAINING | Job Date | Lot No | Qty USED | [NAME] | Sachet Price | Sachets IN | Sachets OUT | Sachets STOCK | VALUE
2008-11-21 00:00:00 | [NAME] | 193101 | [PHONE] |  |  |  | 2.6 |  | 2008-11-24 00:00:00 | 193101 | 1.65 | 20 |  | 16300
2009-02-27 00:00:00 | [NAME] | 203001 | 3830.0020 |  |  |  | 1 |  | 2008-11-24 00:00:00 | 193101 | 0.6 | 20 |  | 6000
2009-10-16 00:00:00 | Moles | 223801 | 20905G19000V |  | 4.26 |  | 2 |  | 2009-03-01 00:00:00 | 193101 | 0.272 | 20 |  | 1500
2009-05-16 00:00:00 | Moles | 223901 | 10905E1900V |  | 4.23 |  | 15 |  | 2009-02-22 00:00:00 | 203001 | 1.098 | 20 |  | 12200
2010-07-29 00:00:00 | PPZ | 249502 | 258145 | 90 | 4.375 |  | 8 |  | 2009-02-11 00:00:00 | 203001 | 0.24 | 20 |  | 3000
 |  |  |  |  |  |  |  |  | 2009-01-24 00:00:00 | 203001 | 11.8 | 20 |  | 1400
 |  |  |  |  |  |  |  |  | 2009-10-28 00:00:00 | 203001 | 2 | 20 |  | 90000
 |  |  |  |  |  |  |  |  | 2009-10-27 00:00:00 | 203001 | 0.7 | 20 |  | 15000
 |  |  |  |  |  |  |  |  | 2010-07-06 00:00:00 | 203001 | 0.7 | 20 |  | 7600
 |  |  |  |  |  |  |  |  | 2010-08-02 00:00:00 | 203001 | 2.79 | 20 |  | 20226