tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 832819d1686620899-find-the-longest-word-example-21-1-
Sheet: Sheet1

ARWEN | OLORIN |  |  |  |  |  |  | Available letters |  | A | L | D | F | V | A | N | G
GALADRIEL | SARUMAN
CELEBORN | GLAMDRING |  |  |  |  |  |  | RESULT
GANDALF | SHINE |  |  | GANDALF
PIPPIN | BAGGINS
TREEBEARD | GOLLUM
BARAHIR | SAURON
BILBO | ELROND
ARAGORN | LAVA |  |  |  | LAVA
SHELOB
ANDUIN
MITHRANDIR
Spreadsheet: 85147d1285197946-how-do-you-take-cell-data-from-18-different-worksheets-and-combine-them-in-another-sample-homework-list
Sheet: Teacher B

Teacher Name | Class | Period | Due Date | Student First Name | Student Last Name | Assignment
Teacher B | Math 11 | 2 | 2010-09-12 00:00:00 | Logan | Wolverine | Chapter 2
Teacher B | Math 11 | 2 | 2010-09-12 00:00:00 | Scott | Summers | Chapter 2
Teacher B | Math 11 | 2 | 2010-09-12 00:00:00 | [NAME] | Grey | Chapter 2
Teacher B | Math 11 | 2 | 2010-09-12 00:00:00 | Hank | McCoy | Chapter 2
Teacher B | Math 11 | 2 | 2010-09-12 00:00:00 | [NAME] | Parker | Chapter 2
Teacher B | Math 11 | 2 | 2010-09-12 00:00:00 | [NAME] | Rogers | Chapter 2
Teacher B | Math 11 | 2 | 2010-09-12 00:00:00 | [NAME] | Worthington | Chapter 2
Spreadsheet: 41262d1239748792-identify-list-and-sum-2-columns-test-time-sheet
Sheet: Dec 15-20

 | NAME: | JON
 |  |  |  |  | TOTAL HRS
DATE | TIME IN | TIME OUT | TOTAL HRS | JOB NO. | FOR DAY | JOB [NAME]
2008-12-15 00:00:00 | 02:00:00 | 04:00:00 | 2 | SHOP | 2
2008-12-16 00:00:00 | 06:00:00 | 12:00:00 | 6 | 28037 |  | CNC-M
 | 12:30:00 | 04:00:00 | 3.5 | SHOP | 9.5
2008-12-17 00:00:00 | 06:00:00 | 03:30:00 | 9 | SHOP | 9
2008-12-18 00:00:00 | 06:30:00 | 03:00:00 | 8 | SHOP | 8
2008-12-19 00:00:00 | 07:00:00 | 03:30:00 | 8 | SHOP | 8
 |  |  | 3.5 | VAC. | 3.5 | VACATION
 |  |  |  |  |  |  |  | VACATION 69 HRS
 |  | SHOP | 30.5
 |  | 28037 | 6
 |  | VACATION | 3.5
 |  |  | 40 | TOTAL | 40
Spreadsheet: 199189d1355139332-how-to-link-2-columns-from-one-sheet-to-another-example12
Sheet: Hoja1

 |  | I want to calculate the difference between these numbers and connect them with the other numbers on the other sheet…
 |  | 237733 |  | 45.5
 |  | 36633 |  | 29.611
 |  | 35566 |  | 28.749
 |  | 34531 |  | 27.911
 |  | 33525 |  | 27.098
 |  | 32548 |  | 26.309
 |  | 31600 |  | 25.543
 |  | 30680 |  | 24.799
 |  | 29786 |  | 24.076
 |  | 28612 |  | 11.113
Spreadsheet: 84941fa0-3e47-4ae4-b9bc-3ade5c94c2be
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
LH | Test | LH | Luteinizing Hormone (LH), Serum | Luteinizing Hormone (LH), S | Immunoenzymatic Assay | Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.6 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Males 0-14 days: not established 15 days-10 years: 0.3-2.8 IU/L 11 years: 0.3-1.8 IU/L 12 years: 0.3-4.0 IU/L 13 years: 0.3-6.0 IU/L 14 years: 0.5-7.9 IU/L 15-16 years: 0.5-10.8 IU/L 17 years: 0.9-5.9 IU/L > or =18 years: 1.8-8.6 IU/L   TANNER STAGES* Stage l: 0.3-2.7 IU/L Stage ll: 0.3-5.1 IU/L Stage lll: 0.3-6.9 IU/L Stage lV: 0.5-5.3 IU/L Stage V: 0.8-11.8 IU/L *Puberty onset occurs for boys at a median age of 11.5 (+/- 2) years. For boys there is no proven relationship between puberty onset and body weight or ethnic origin. Progression through Tanner stages is variable. Tanner stage V (adult) should be reached by age 18. Females 0-14 days: not established 15 days-3 years: 0.3-2.5 IU/L 4-6 years: < or =1.9 IU/L 7-8 years: < or =3.0 IU/L 9-10 years: < or =4.0 IU/L 11 years: < or =6.5 IU/L 12 years: 0.4-9.9 IU/L 13 years: 0.3-5.4 IU/L 14 years: 0.5-31.2 IU/L 15 years: 0.5-20.7 IU/L 16 years: 0.4-29.4 IU/L 17 years: 1.6-12.4 IU/L > or =18 years Premenopausal Follicular: 2.1-10.9 IU/L Midcycle: 20.0-100.0 IU/L Luteal: 1.2-12.9 IU/L Postmenopausal: 10.0-60.0 IU/L   TANNER STAGES* Stage I: < or =2.0 IU/L Stage II: < or =6.5 IU/L Stage III: 0.3-17.2 IU/L Stage IV: 0.5-26.3 IU/L Stage V: 0.6-13.7 IU/L *Puberty onset (transition from Tanner stage I to Tanner stage II) occurs for girls at a median age of 10.5 (+/- 2) years. There is evidence that it may occur up to 1 year earlier in obese girls and in African American girls. Progression through Tanner stages is variable. Tanner stage V (adult) should be reached by age 18.   Pediatric ranges derived for DXI method from analytic comparison to reference method in: Elmlinger MW, Kuhnel W, [NAME]: Reference ranges for serum concentrations of lutropin (LH), follitropin (FSH), estradiol (E2), prolactin, progesterone, sex hormone-binding globulin (SHBG), dehydroepiandrosterone sulfate (DHEAS), cortisol and ferritin in neonates, children and young adults. [NAME] 2002;40(11):1151-1160 | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | Same day/1 day | 3 days | 1 | 83002 |  |  |  |  | Rochester
LH | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
LH | Result | LH | Luteinizing Hormone (LH), S | Luteinizing Hormone (LH), S | Numeric |  |  |  |  | IU/L |  |  |  |  |  |  |  |  |  | 10501-5
Spreadsheet: 0b2c4dd4-7afd-435f-8458-fa7b5b183f8c
Sheet: 12c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending December 28, by product type and major currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors.  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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: hunter_shively__12719__fundy
Sheet: Sheet1

Gas Fundamentals
1 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Biliana Pehlivanova
 |  | Denver Plachy
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Special Assignment
1 |  | [NAME]
East Power
1 |  | [NAME]
 |  | [NAME]
 |  | Moises Benchluch
 |  | [NAME]
 |  | [NAME]
 |  | Gustavo Giron
 |  | [NAME]
 |  | [NAME]
West Power
1 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Spreadsheet: 20bdcf87-85f9-4644-8dcc-362984bdc737
Sheet: Sheet1

Table 4--Cottonseed:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | Supply |  |  |  |  | Disappearance
Year begin. | Beginning |  |  |  |  |  |  |  |  | Ending
Aug. 1 | stocks | Production | Imports | Total |  | Crush | Exports | Other | Total | stocks
 |  |  |  | 1,000 short tons
2009/10 | 514.089 | 4148.8 | 24.2 | 4687.089 |  | 1900.697 | 295.523 | 2149.268 | 4345.488 | 341.601
2010/111 | 341.601 | 6098.1 | 0 | 6439.701 |  | 2562.55107 | 275.111 | 2984.47593 | 5822.138 | 617.563
2011/122 | 617.563 | 5267 | 100 | 5984.563 |  | 2400 | 160 | 2994.563 | 5554.563 | 430
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2012-04-12 13:57:01.810000
Spreadsheet: 881407d1729502349-formula-to-extract-value-based-on-branch-and-account-number-sales-commissions-2024
Sheet: Journals

BR1 | September |  |  | 111444
837090 |  |  | 14520 |  | BR1
857090 |  |  | 3570 |  | BR1
867090 |  |  | 0 |  | BR1
877090 |  |  | 0 |  | BR1
896135 |  |  | 0 |  | BR1
995070 |  |  |  |  | BR1
995070 |  |  |  |  | BR1
 | Journal Balance
Spreadsheet: 815672d1675137521-how-to-return-multiple-match-values-s666-pq-how-to-return-multiple-match-values
Sheet: PQ

 | Date | Time | Subject Code | Semester /Tech | Semester /Tech2 | Semester /Tech3 | Semester /Tech4 | Semester /Tech5 | Semester /Tech6 | Semester /Tech7 |  | Date | Time | Semester /Tech
 | 2023-01-29 00:00:00 | 10:00:00 | 5941 |  |  |  |  |  |  |  |  | 2023-01-29 00:00:00 | 10:00:00 | 4CMT
 | 2023-01-29 00:00:00 | 10:00:00 | 66441 | 4/CT
 | 2023-01-29 00:00:00 | 10:00:00 | 66641 | 4/CMT |  |  |  |  |  |  |  | Result
 | 2023-01-29 00:00:00 | 10:00:00 | 66743 | 4/MT | 4/PT | 4/ENT |  |  |  |  |  | Subject Code
 | 2023-01-29 00:00:00 | 10:00:00 | 68641 | 4/EMT |  |  |  |  |  |  |  | 66641
 | 2023-01-29 00:00:00 | 10:00:00 | 25711 |  |  | 6/ET
 | 2023-01-29 00:00:00 | 02:00:00 | 5851
 | 2023-01-29 00:00:00 | 02:00:00 | 66651 |  | 4/CMT
 | 2023-01-29 00:00:00 | 02:00:00 | 66851
 | 2023-01-29 00:00:00 | 02:00:00 | 67051 | 4/MT
 | 2023-01-29 00:00:00 | 02:00:00 | 67151 | 4/MT |  |  |  |  |  | 6/PT
 | 2023-01-29 00:00:00 | 02:00:00 | 68651
Spreadsheet: 3362e1f5-904b-49cc-8cbf-a0d7ee6966b2
Sheet: Sheet1

Unnamed: 0 | US Municipal Bond Issuance | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Table | Description | Time Period | Currency | Value | Last Value | Last Updated
 | 1.1. | US Municipal Issuance, Bond (Go/Revenue), Bid (Competitive/Negotiated), and Coupon Type | A, M | USD | Billions | July 2014 | 2014-08-04 00:00:00
 | 1.2. | US Municipal Issuance, New Capital & Refunding | A, M | USD | Billions | July 2014 | 2014-08-04 00:00:00
 | 1.3. | US Municipal Issuance, Callable and Noncallable | A, M | USD | Billions | July 2014 | 2014-08-04 00:00:00
 | 1.4. | US Municipal Issuance, Average Maturity | A, M |  | Years | July 2014 | 2014-08-04 00:00:00
 | 2.1. | FAQ |  |  |  |  | 2012-07-12 00:00:00
 | Contact
 | [NAME] | [EMAIL]
 | All data are subject to revision.
 | The Securities Industry and Financial Markets Association (SIFMA) prepared this material for informational purposes only. [NAME] obtained this information from multiple sources believed to be reliable as of the date of publication; SIFMA, however, makes no representations as to the accuracy or completeness of such third party information. SIFMA has no obligation to update, modify or amend this information or to otherwise notify a reader thereof in the event that any such information becomes outdated, inaccurate, or incomplete.
 | The Securities Industry and Financial Markets Association (SIFMA) brings together the shared interests of hundreds of securities firms, banks and asset managers. [NAME]'s mission is to support a strong financial industry, investor opportunity, capital formation, job creation and economic growth, while building trust and confidence in the financial markets. SIFMA, with offices in New York and Washington, D.C., is the U.S. regional member of the Global Financial Markets Association (GFMA). For more information, visit www.sifma.org.
 | FAQ
 | Issuance | All issuance figures are based on deals with maturity of 13 months or greater.
 | Average Maturity | Average maturity is based on issuance, rather than outstanding, volumes.
 | Source: | Thomson Reuters
Spreadsheet: 802676d1666967203-copy-information-from-multiple-tables-to-a-sheet-bwp-invoices
Sheet: Table 1

 |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  | Invoice #
 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-27 00:00:00 |  |  |  | 80050
 | [NAME] |  |  |  |  |  |  |  |  | Ship To
 | BW Papersystems Company P.O. Box 4717 [EMAIL] Timonium, MD 21094-4717 |  |  |  |  |  |  |  |  | BW Papersystems Co. 10615 Beaver Dam Road Hunt Valley, MD 21030-2204
P.O. Number |  |  | Terms |  | Rep |  | Ship |  | Via |  | F.O.B. |  |  | Project
PN46188 |  |  | 2%10NET45 |  | HOUSE |  | 2022-10-27 00:00:00 |  | UPS |  | Richmond, VA
Quantity |  | Item Code |  | Description |  |  |  |  |  |  |  | Price Each |  |  |  | Amount
1 1 1 |  | 86302 Delivery Charges 150MATERIAL |  | SHAFT, SPANKER DRIVE Crate [NAME] |  |  |  |  |  |  |  | 1,398.00 135.00 150.00 |  |  |  | 1,398.00 135.00 150.00
 |  |  |  |  |  |  |  |  |  |  |  | Total                            $1,683.00
Payments/Credits                 $0.00 |  |  |  |  |  |  |  | Balance Due |  |  |  |  |  |  | 1683
Spreadsheet: 162803d1340080225-excel-2007-how-to-fix-if-index-match-mjc-registro-interactivo
Sheet: TABSR

 | Volver [NAME] |  |  | TABULACIÓN DE CADA NOTA  Segundo R
 | N1 |  | % |  | N2 |  | % |  | N3 |  | % |  | N4 |  | % |  | S1 |  | % |  | S2 |  | % |  | S3 |  | %
 | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90
 | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80
 | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70
 | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60
 | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0
 | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 | [NAME] |  | % |  | S5 |  | % |  | S6 |  | % |  | S7 |  | % |  | S8 |  | % |  | S9 |  | % |  | N5 |  | %
 | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90
 | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80
 | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70
 | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60
 | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0
 | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 | [NAME] |  | % |  | N7 |  | % |  | N8 |  | % |  | S10 |  | % |  | S11 |  | % |  | S12 |  | % |  | S13 |  | %
 | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90
 | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80
 | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70
 | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60
 | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0
 | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 | S14 |  | % |  | S15 |  | % |  | S16 |  | % |  | S17 |  | % |  | S18 |  | %
 | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90 |  |  |  | 100-90
 | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80 |  |  |  | 89-80
 | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70 |  |  |  | 79-70
 | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60 |  |  |  | 69-60
 | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0 |  |  |  | 59-0
 | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
Spreadsheet: 142154d1329692614-calculating-unique-days-in-from-a-series-of-ranges-unique-day-example
Sheet: Sheet1

Data |  |  |  |  |  | Unique Days
Person | Start Date | End Date |  |  | Person | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | etc…
A | 2011-01-23 00:00:00 | 2011-01-27 00:00:00 |  |  | A
A | 2011-01-27 00:00:00 | 2011-02-02 00:00:00 |  |  | B
B | 2011-01-28 00:00:00 | 2011-01-29 00:00:00 |  |  | C
C | 2011-01-30 00:00:00 | 2011-02-02 00:00:00
C | 2011-02-02 00:00:00 | 2011-02-02 00:00:00
B | 2011-02-04 00:00:00 | 2011-02-04 00:00:00
B | 2011-02-07 00:00:00 | 2011-02-15 00:00:00
A | 2011-02-10 00:00:00 | 2012-02-12 00:00:00
B | 2011-02-11 00:00:00 | 2011-02-27 00:00:00
 | This would go on and on…
Spreadsheet: 392419d1430483920-formula-to-calculate-occurrences-of-staff-absence-absence-tracking
Sheet: Sheet1

 | 2015-01-02 00:00:00 | 2015-01-03 00:00:00 | 2015-01-04 00:00:00 | 2015-01-05 00:00:00 | 2015-01-06 00:00:00 | 2015-01-07 00:00:00 | 2015-01-08 00:00:00 | 2015-01-09 00:00:00 | 2015-01-10 00:00:00 | 2015-01-11 00:00:00 | 2015-01-12 00:00:00 | 2015-01-13 00:00:00 | 2015-01-14 00:00:00 | 2015-01-15 00:00:00 | 2015-01-16 00:00:00 | 2015-01-17 00:00:00 | 2015-01-18 00:00:00 | 2015-01-19 00:00:00 | 2015-01-20 00:00:00 | 2015-01-21 00:00:00 | 2015-01-22 00:00:00 | 2015-01-23 00:00:00 | 2015-01-24 00:00:00 | 2015-01-25 00:00:00 | 2015-01-26 00:00:00 | 2015-01-27 00:00:00 | 2015-01-28 00:00:00 | 2015-01-29 00:00:00 | 2015-01-30 00:00:00 | 2015-01-31 00:00:00 | 2015-02-01 00:00:00 | Occurrences
Fred | 7.4 |  |  | 7.4 | 7.4 |  |  |  |  |  | 7.4 | 7.4 |  |  |  |  |  |  |  |  |  | 7.4 |  |  | 7.4
[NAME] | 7.4 |  |  | 7.4 | 7.4 |  | 7.4 | 7.4 |  |  | 7.3 | 7.4 |  | 7.4 |  |  |  |  |  |  |  | 7.4 |  |  | 7.4 | 7.4
[NAME] | 7.4 |  |  |  | 7.4 | 7.4 | 7.4 |  |  |  |  | 7.4 | 7.4 | 7.4 |  |  |  |  |  |  | 7.4 |  |  |  |  |  | 7.4
 |  | = Non Working Day
None of them works weekends
Fred's Occurences are correct = 3
[NAME] should show 2 Occurrences
[NAME] should show 3 Occurrences
 | Contracted Monthly & Daily Hours
 | Name | Role | Contracted Hours (Monthly) | Contracted Hours (Daily)
 |  |  |  | Mon | Tue | Wed | Thu | Fri
 | Fred |  |  | 7.4 | 7.4 | 7.4 | 7.4 | 7.4
 | [NAME] |  |  | 7.4 | 7.4 | NWD | 7.4 | 7.4
 | [NAME] |  |  | NWD | 7.4 | 7.4 | 7.4 | NWD
 |  | Mon | Tue | Wed | Thu | Fri
 |  | 2 | 3 | 4 | 5 | 6
Spreadsheet: 80719d1280933350-data-entry-simplification-pricing-example
Sheet: Feuil1

DATE | MOUNTED? | LENSE NAME | MATERIAL | EDGING | COATING | NUMBER OF LENSES | AMOUNT CHARGED PER LENSE | AMOUNT CHARGED FOR EDGING PER LENSE | AMOUNT CHARGED FOR COATING PER LENSE | EXTRA CHARGES | TOTAL | CATALOGUE PRICE FOR LENSE + COATING | EDGING | OTHER | TOTAL | DIFFERENCE
2010-04-12 00:00:00 | YES | VX PHYSIO 2.0 360 TL16 | PLASTIC 1,6 | METAL EDGE | CRIZAL FORTE | 2 | 118 | 0 | 46.5 | 0 | 329 | 164.5 | 0 | 0 | 329 | 0
2010-04-08 00:00:00 | YES | VX PHYSIO 2.0 SHT 360 TL16 TRANSITIONS | PLASTIC 1,6 | NYLON EDGE | CRIZAL FORTE D | 2 | 159 | 7.15 | 49.5 | 0 | 431.3 | 208.5 | 7.15 | 0 | 431.3 | 0
2010-05-12 00:00:00 | YES | ESSILOR ANTI-FATIGUE | PLASTIC 1,5 | METAL EDGE | CRIZAL SUN | 2 | 23 | 0 | 43 | 0 | 132 | 66 | 0 | 0 | 132 | 0
2010-04-16 00:00:00 | NO | VX PHYSIO 2.0 360 TL1,74 | PLASTIC 1,74 | METAL EDGE | CRIZAL AVANCE | 1 | 82.5 | 0 | 0 | 0 | 82.5 | 178 | 0 | 0 | 178 | -95.5
2010-04-09 00:00:00 | NO | VX ELLIPSE 360 AIRWEAR | POLY 1,59 - AIRWEAR | METAL EDGE | CRIZAL FORTE | 2 | 92 | 0 | 46.5 | 0 | 277 | 138.5 | 0 | 0 | 277 | 0
2010-04-01 00:00:00 | YES | ESSILOR ANTI-FATIGUE AIRWEAR | POLY 1,59 - AIRWEAR | METAL EDGE | CRIZAL FORTE | 2 | 29 | 0 | 46.5 | 0 | 151 | 75.5 | 0 | 0 | 151 | 0
2010-04-12 00:00:00 | YES | ESSILOR SV 360 TL1,67 | PLASTIC 1,67 | METAL EDGE | CRIZAL FORTE | 2 | 66 | 0 | 46.5 | 0 | 225 | 112.5 | 0 | 0 | 225 | 0
Spreadsheet: 103675d1301410056-formulas-inside-excel-charts-book2
Sheet: Settings

Set Up Variables |  |  | Months |  |  |  |  |  | Language |  |  |  | Dealers |  | KPI & Data Titles
Format |  |  | Months |  |  |  |  |  | Languages |  |  |  | Dealers |  | Titles
MonthName | February |  | Month No. | Month | TranslatedMonth | TranslatedMonth | TranslatedMonth |  | LanguageCode | LanguageName | Link |  | 1 |  | [NAME] | Data Titles | 1
MonthAbbr | Feb |  | 1 | January | January | Jan | J |  | EN | English | 1 |  | Dealer1 |  | KPI1 | CurrentMTH | Month
MonthLetter | F |  | 2 | February | February | Feb | F |  |  |  |  |  | Dealer2 |  | [NAME] | PreviousMTH | Year to Date
Mthno | 2 |  | 3 | March | March | Mar | M |  |  |  |  |  | Dealer3 |  | KPI3 | CurrentYtd | R12
Year | 2011 |  | 4 | April | April | Apr | A |  |  |  |  |  | Dealer4 |  | KPI4 | PreviousYtd
NoMonths |  |  | 5 | May | May | May | M |  |  |  |  |  | Dealer5 |  | KPI5 | CurrentR12
Deadline |  |  | 6 | June | June | Jun | J |  |  |  |  |  | Dealer6 |  | KPI6 | Previousr12
StartMonthNo | 1 |  | 7 | July | July | Jul | J |  |  |  |  |  | Dealer7 |  | KPI7
StartMonth | January |  | 8 | August | August | Aug | A |  |  |  |  |  | Dealer8 |  | KPI8
PrevStartMonthNo | 1 |  | 9 | September | September | Sep | S |  |  |  |  |  | Dealer9 |  | KPI9
Period | February 2010 - February 2011 |  | 10 | October | October | Oct | O |  |  |  |  |  | Dealer10
 |  |  | 11 | November | November | Nov | N
 |  |  | 12 | December | December | Dec | D
DefaultLanguageCode | EN
DefaultLanguageLink | 1
LanguageLink | 1
Language | English
Spreadsheet: 144009d1330669709-how-to-split-some-qty-with-respect-to-a-particular-constant-copy-of-capacity-check_ref
Sheet: Demand

Part Number | Description | CRD Date | CRD Qty | Day | Status
AAAAAAAAAA | A | 2012-05-23 00:00:00 | 412
BBBBBBBBBB | B | 2012-06-25 00:00:00
CCCCCCCCC | C | 2012-07-25 00:00:00
DDDDDDDDD | D | 2012-08-23 00:00:00
EEEEEEEEEE | E | 2012-09-24 00:00:00
Spreadsheet: 4fac76ca-d793-4672-9417-b29040372e6c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261343 | 57737 | Keiji | Nagai     B1 | JPN | 4 | 00:22:23 | 00:03:01 | [NAME] | 00:02:28 | 00:24:10 | 1 | 01:28:19
261343 | 71398 | [NAME] | Yoneoka   B1 | JPN | 6 | 00:25:59 | 00:04:29 | 00:36:47 | 00:02:14 | 00:21:23 | 2 | 01:30:52
261343 | 57736 | [NAME] | Yanagawa | JPN | 5 | 00:22:26 | 00:02:54 | 00:40:41 | [NAME] | [NAME] | 3 | [NAME]
Spreadsheet: 844030d1695829644-vlookup-function-i-think-grade-to-percentage
Sheet: Sheet1

Name | Grade | Percentage |  | Grade | Percentage
[NAME] | B | 75 |  | A+ | 95
[NAME] | A | 90 |  | A | 90
[NAME] | [NAME] | 80 |  | A- | 85
[NAME] | A+ | 95 |  | [NAME] | 80
[NAME] | B- | 70 |  | B | 75
[NAME] | [NAME] |  |  | B- | 70
[NAME] | C+ |  |  | C+ | 65
[NAME] | E |  |  | B | 60
[NAME] | C |  |  | C- | 55
[NAME] | D |  |  | [NAME] | 50
[NAME] | A |  |  | D | 45
[NAME] | B |  |  | D- | 40
[NAME] | [NAME] |  |  | E+ | 35
Xavier | D- |  |  | E | 30
[NAME] | C |  |  | E- | 25
[NAME] | A-
Fred | B-
[NAME] | C+
[NAME] | A-
Quinton | B
[NAME] | C
Spreadsheet: rick_buy__32739__0822_Violation
Sheet: Sheet1

 | To: |  | [NAME], [NAME] and [NAME]
 | Copy to: |  | Distribution
 | From: |  | Global Risk Management Operations
 | Date: |  | 2001-08-23 00:00:00
 | Re: |  | Limit Violations and Notifications for August 22, 2001
 |  |  |  |  | Loss Notification or Limit Violation |  |  |  |  |  | P/L RESULTS
 |  |  |  |  |  |  |  | Violation/
 |  |  |  |  | VaR | NOP or M/G | Type | Notification | Number |  | QTD |  | YTD
 | Business Unit |  | Commodity Group |  | Limit | Limit | Violation | Amount | YTD |  | P/L |  | P/L |  |  | Explanation
 |  |  |  |  | ($MMs) |  |  |  |  |  | ($MMs) |  | ($MMs)
1 | Enron Global Markets |  | EOL 24/7 Crude Trading | B |  | 2 Mil Bbl WTI | Net Open Position | (3.59) Mil Bbl WTI | 28 |  | -3181 |  | -31623 |  |  | Due to the $3 September 2001 price increase since July 19, both internal and external counter-parties have consistently bought from the EOL Crude portfolio, causing EOL to be increasingly short.
2 | Enron Global Markets |  | EOL 24/7 Crude Trading | B |  | 3 Mil Bbl WTI | Maturity Gap Risk | (3.59) Mil Bbl WTI | 20 |  | -3181 |  | -31623 |  |  | Due to the $3 September 2001 price increase since July 19, both internal and external counter-parties have consistently bought from the EOL Crude portfolio, causing EOL to be increasingly short.
 | B= Business Unit Violation |  | C= Concentration Violation
 | Distribution: |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]