tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 160144d1338986183-how-to-create-a-graph-in-the-chart-ticket_report_eswar
Sheet: Sheet3

Ticket Type | User Story
 | Column Labels
 | Completed |  | In Progress |  | Not Started |  | Ready To Test |  | Ready To Verify |  | Total No of Stories | Total Actual/Estimated Effort
Row Labels | No of Stories | Actual/Estimated Effort | No of Stories | Actual/Estimated Effort | No of Stories | Actual/Estimated Effort | No of Stories | Actual/Estimated Effort | No of Stories | Actual/Estimated Effort
Project Backlog | 10 | 80 |  |  | 103 | 913 |  |  |  |  | 113 | 993
Sprint 0 | 22 | 2 |  |  |  |  |  |  |  |  | 22 | 2
Sprint 1 | 8 | 42 |  |  |  |  |  |  |  |  | 8 | 42
Sprint 10 |  |  |  |  | 31 | 486 |  |  |  |  | 31 | 486
Sprint 11 |  |  |  |  | 41 | 396 |  |  |  |  | 41 | 396
Sprint 12 |  |  |  |  | 26 | 280 |  |  |  |  | 26 | 280
Sprint 13 |  |  |  |  | 4 | 116 |  |  |  |  | 4 | 116
Sprint 2 | 9 | 22 |  |  |  |  |  |  |  |  | 9 | 22
Sprint 3 | 11 | 92 |  |  |  |  |  |  |  |  | 11 | 92
Sprint 4 | 39 | 174 | 1 | 16 |  |  |  |  |  |  | 40 | 190
Sprint 5 | 21 | 239 |  |  |  |  |  |  | 1 | 16 | 22 | 255
Sprint 6 | 15 | 160 |  |  |  |  | 3 | 36 |  |  | 18 | 196
Sprint 7 | 1 | 16 | 13 | 260 | 15 | 206 | 5 | 46 | 5 | 67 | 39 | 595
Sprint 8 |  |  | 1 | 16 | 35 | 406 |  |  |  |  | 36 | 422
Sprint 9 |  |  |  |  | 36 | 348 |  |  |  |  | 36 | 348
Grand Total | 136 | 827 | 15 | 292 | 291 | 3151 | 8 | 82 | 6 | 83 | 456 | 4435
Spreadsheet: 70703d1271413922-excel-2007-compatibilty-problem-between-excel-versions-problem-workbook
Sheet: Graphs

 | 2008-01-15 00:00:00 | 2008-02-15 00:00:00 | 2008-03-15 00:00:00 | 2008-04-15 00:00:00 | 2008-05-15 00:00:00 | 2008-06-15 00:00:00 | 2008-07-15 00:00:00 | 2008-08-15 00:00:00 | 2008-09-15 00:00:00 | 2008-10-15 00:00:00 | 2008-11-15 00:00:00 | 2008-12-15 00:00:00 | 2009-01-15 00:00:00 | 2009-02-15 00:00:00 | 2009-03-15 00:00:00 | 2009-04-15 00:00:00 | 2009-05-15 00:00:00 | 2009-06-15 00:00:00 | 2009-07-15 00:00:00 | 2009-08-15 00:00:00 | 2009-09-15 00:00:00 | 2009-10-15 00:00:00 | 2009-11-15 00:00:00 | 2009-12-15 00:00:00 | 2010-01-15 00:00:00
TOTAL | 2008-01-15 00:00:00 | 2008-02-15 00:00:00 | 2008-03-15 00:00:00 | 2008-04-15 00:00:00 | 2008-05-15 00:00:00 | 2008-06-15 00:00:00 | 2008-07-15 00:00:00 | 2008-08-15 00:00:00 | 2008-09-15 00:00:00 | 2008-10-15 00:00:00 | 2008-11-15 00:00:00 | 2008-12-15 00:00:00 | 2009-01-15 00:00:00 | 2009-02-15 00:00:00 | 2009-03-15 00:00:00 | 2009-04-15 00:00:00 | 2009-05-15 00:00:00 | 2009-06-15 00:00:00 | 2009-07-15 00:00:00 | 2009-08-15 00:00:00 | 2009-09-15 00:00:00 | 2009-10-15 00:00:00 | 2009-11-15 00:00:00 | 2009-12-15 00:00:00 | 2010-01-15 00:00:00
 | 2008-01-15 00:00:00 | 2008-02-15 00:00:00 | 2008-03-15 00:00:00 | 2008-04-15 00:00:00 | 2008-05-15 00:00:00 | 2008-06-15 00:00:00 | 2008-07-15 00:00:00 | 2008-08-15 00:00:00 | 2008-09-15 00:00:00 | 2008-10-15 00:00:00 | 2008-11-15 00:00:00 | 2008-12-15 00:00:00 | 2009-01-15 00:00:00 | 2009-02-15 00:00:00 | 2009-03-15 00:00:00 | 2009-04-15 00:00:00 | 2009-05-15 00:00:00 | 2009-06-15 00:00:00 | 2009-07-15 00:00:00 | 2009-08-15 00:00:00 | 2009-09-15 00:00:00 | 2009-10-15 00:00:00 | 2009-11-15 00:00:00 | 2009-12-15 00:00:00 | 2010-01-15 00:00:00
[NAME]
MARGARET
 | 2008-01-15 00:00:00 | 2008-02-15 00:00:00 | 2008-03-15 00:00:00 | 2008-04-15 00:00:00 | 2008-05-15 00:00:00 | 2008-06-15 00:00:00 | 2008-07-15 00:00:00 | 2008-08-15 00:00:00 | 2008-09-15 00:00:00 | 2008-10-15 00:00:00 | 2008-11-15 00:00:00 | 2008-12-15 00:00:00 | 2009-01-15 00:00:00 | 2009-02-15 00:00:00 | 2009-03-15 00:00:00 | 2009-04-15 00:00:00 | 2009-05-15 00:00:00 | 2009-06-15 00:00:00 | 2009-07-15 00:00:00 | 2009-08-15 00:00:00 | 2009-09-15 00:00:00 | 2009-10-15 00:00:00 | 2009-11-15 00:00:00 | 2009-12-15 00:00:00 | 2010-01-15 00:00:00
[NAME]
MARGARET
Spreadsheet: 761241d1640766175-combine-columns-datas-for-identical-values-in-first-column-test3
Sheet: result

 | +ZX
185 | #[NAME]!
380 | #[NAME]!
10000 | #[NAME]!
10020 | +ZGuide(2)LIM(4)
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | ANC
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | +ZGuide(2)
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | +Z
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
#N/A | #[NAME]!
Spreadsheet: 741144d1626862873-lookup-formula-for-2-categories-pricecat
Sheet: PRODUCT

 | FRUIT | DISTRIBUTOR PRICE | TRADE PRICE | RETAIL PRICE
 | APPLE | 5 | 6 | 10
 | ORANGE | 7 | 8 | 14
 | MANGO | 7 | 8 | 15
 | STRAWBERRY | 10 | 13 | 20
Spreadsheet: 812622d1673285665-analyzing-a-specific-cell-book-4-1-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | End
 |  | Select Period |  | This Year |  |  |  |  |  |  |  |  |  | Use | 2023-01-01 00:00:00 | 2023-01-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Period | Start | End
 |  |  |  |  |  |  |  |  |  |  |  |  |  | This Year | 2023-01-01 00:00:00 | 2023-01-08 00:00:00
 |  | Date | Time | Open | High | Low | Close |  |  |  |  |  |  | Last Year | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 |  | 2023-01-02 00:00:00 | 18:30:00 | 80.57 | 80.78 | 80.2 | 80.29 |  |  |  |  |  |  | This Month | 2023-01-01 00:00:00 | 2023-01-08 00:00:00
 |  | 2023-01-02 00:00:00 | 19:00:00 | 80.29 | 80.5 | 80.17 | 80.44 |  |  |  |  |  |  | Last Month | 2022-12-01 00:00:00 | 2022-12-31 00:00:00
 |  | 2023-01-02 00:00:00 | 19:30:00 | 80.45 | 80.54 | 80.41 | 80.45 |  |  |  |  |  |  | This Week | 2023-01-08 00:00:00 | 2023-01-08 00:00:00
 |  | 2023-01-02 00:00:00 | 20:00:00 | 80.44 | 80.47 | 80.21 | 80.25 |  |  |  |  |  |  | Last Week | 2023-01-01 00:00:00 | 2023-01-07 00:00:00
 |  | 2023-01-02 00:00:00 | 20:30:00 | 80.25 | 80.38 | 79.38 | 79.49
 |  | 2023-01-02 00:00:00 | 21:00:00 | 79.48 | 79.7 | 79.44 | 79.59
 |  | 2023-01-02 00:00:00 | 21:30:00 | 79.6 | 79.65 | 79.32 | 79.61
 |  | 2023-01-02 00:00:00 | 22:00:00 | 79.61 | 79.95 | 79.61 | 79.95
 |  | 2023-01-02 00:00:00 | 22:30:00 | 79.95 | 80.12 | 79.8 | 80.04
 |  |  |  |  |  |  |  |  |  |  |  | Start Date/Open | End Date/close
 |  |  |  |  |  |  |  |  |  |  | This Year
 |  |  |  |  |  |  |  |  |  |  | Last Year
 |  |  |  |  |  |  |  |  |  |  | This Month
 |  |  |  |  |  |  |  |  |  |  | Last Month
 |  |  |  |  |  |  |  |  | The Colors are for Illustration only
Spreadsheet: 22239d1210863578-automatically-filling-in-cells-on-the-basis-of-a-dropdown-list-catg
Sheet: Catg Trials

Catg 1 | Catg 2 |  | Lists
REG | 1 |  |  |  | Fruits | Vegetables | Colors | REG | FRX
 | 2 |  | Fruits |  | Apple | Potato | Pink | 1 | 100
 | 3 |  | Vegetables |  | [NAME] | Pea | Blue | 2 | 101
 | 4 |  | Colors |  | Pear | Carrot | Red | 3 | 102
 | 5 |  | REG |  |  |  |  | 4 | 103
 | 6 |  | FRX |  |  |  |  | 5 | 104
 | 7 |  |  |  |  |  |  | 6 | 105
 | 8 |  |  |  |  |  |  | 7 | 106
 | 9 |  |  |  |  |  |  | 8 | 107
 | 10 |  |  |  |  |  |  | 9 | 108
 | 11 |  |  |  |  |  |  | 10 | 109
 |  |  |  |  |  |  |  | 11 | 110
 |  |  |  |  |  |  |  | 12 | 111
 |  |  |  |  |  |  |  | 13 | 112
 |  |  |  |  |  |  |  | 14 | 113
 |  |  |  |  |  |  |  | 15 | 114
 |  |  |  |  |  |  |  | 16 | 115
 |  |  |  |  |  |  |  | 17 | 116
 |  |  |  |  |  |  |  | 18 | 117
 |  |  |  |  |  |  |  | 19 | 118
 |  |  |  |  |  |  |  | 20 | 119
 |  |  |  |  |  |  |  | 21 | 120
 |  |  |  |  |  |  |  | 22 | 121
 |  |  |  |  |  |  |  | 23 | 122
 |  |  |  |  |  |  |  | 24 | 123
Spreadsheet: aae9866c-e0e9-4db5-ac30-818f81f4cf12
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
ACE | Test | ACE | [NAME], Serum | [NAME], S | Spectrophotometry (SP) | Serum Gel Tube: SGT |  |  | 2 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Additional Information: The use of angiotensin converting enzyme (ACE)-inhibiting antihypertensive drugs will cause decreased ACE values. | 0.5 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild reject; Gross reject Other	NA | > or =18 years: 8-53 U/L The reference interval for pediatric patients may be up to 50% higher than that of adults. | Monday through Saturday; Continuously | 1 day (not reported on Sunday) | 3 days | 1 | 82164 |  |  |  |  | Rochester
ACE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
ACE | Result | ACE | [NAME], S | [NAME], S | Numeric |  |  |  |  | U/L |  |  |  |  |  |  |  |  |  | 2742-5 | [NAME] converting enzyme:CCnc:Pt:Ser/Plas:Qn:
Spreadsheet: robin_rodrigue__33364__IMPositions_070700
Sheet: Houston

2000-01-25 00:00:00
TIME BUCKET/KEY: |  | REPORT REGION | RISK TYPE | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
(Positions in Cont. [NAME].)     From: |  |  |  | 2000-01-01 00:00:00 |  | 2000-02-01 00:00:00 |  | 2000-03-01 00:00:00 |  | 2000-04-01 00:00:00 |  | 2000-05-01 00:00:00 |  | 2000-06-01 00:00:00 |  | 2000-07-01 00:00:00 |  | 2001-01-01 00:00:00 |  | 2002-01-01 00:00:00 |  | 2003-01-01 00:00:00 |  | 37987 |  | 38353 |  | 40544 |  | 42370 |  | Total ECT |  | Prior Day |  |  |  | Total ECT
To: |  |  |  | 2000-01-01 00:00:00 |  | 2000-02-01 00:00:00 |  | 2000-03-01 00:00:00 |  | 2000-04-01 00:00:00 |  | 2000-05-01 00:00:00 |  | 2000-06-01 00:00:00 |  | 2000-12-01 00:00:00 |  | 2001-12-01 00:00:00 |  | 2002-12-01 00:00:00 |  | 2003-12-01 00:00:00 |  | 38322 |  | 2010-12-01 00:00:00 |  | 42339 |  | 45200 |  | Jan-00/Oct-23 |  | 36494 |  | Change |  | Dec-99/Mar-21
CANADA (INTRAMONTH)  (Lavorato)
Physical |  | IMCANADA | PHY | -23.6 |  | 412.4 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 388.8 |  | 368.5 |  | 20.3 |  | 388.8 |  | 20.3
Gas Daily |  | IMCANADA | G | 14.6 |  | -84.5 |  | -35.3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -105.2 |  | -173.9 |  | 68.7 |  | -105.2 |  | 68.7
Basis - Notional |  | IMCANADA | D | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Basis - Equivalent |  | IMCANADA | D | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Price |  | IMCANADA | P | 0 |  | -480.6 |  | 122.1 |  | 28.8 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -329.7 |  | -446.8 |  | 117.1 |  | -329.7 |  | 117.1
TOTAL: |  |  |  | -9 |  | -152.7 |  | 86.8 |  | 28.8 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -46.1 |  | -252.2 |  | 206.1 |  | -46.1 |  | 206.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Maturity/Gap Risk Position (Rolling 12 Months)  from | - | to | - | is | -346 |  | -346
Spreadsheet: 144089d1330706162-excel-2007-misunderstood-trendline-equation-sales-forecast
Sheet: Sheet1

 |  | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Customers Purchasing Products 2002-2006 | 1904966.94 | 2434852.851 | 2930920.44 | 3901252.69 | 4049054.03
 | Customers Purchasing Products 2007-2008 |  |  |  |  |  | 3921347.290000001 | 2542850.98
 | Forecasted 2007 and 2008 Sales
 | Lost 2007 & 2008 Sales
 | Net Lost Sales
Spreadsheet: 826670d1682148231-hardcode-text-to-spilled-array-spilled-range-aligw
Sheet: prices (2)

id | qty | expected_result | current_result
Al-100 | 50 | 1165 |  |  |  |  |  |  |  |  |  | Al-100 | 2023-04-17 00:00:00 | 30 | g | 1165 | USD
Al-100 | 100 | 1165 |  | 1165 |  |  |  |  |  |  |  | Al-100 | 2023-04-17 00:00:00 | 1000 | g | 922 | USD
[NAME] | 250 | 1200 |  | 1200 |  |  |  |  |  |  |  | [NAME] | 2023-04-17 00:00:00 | 30 | g | 1500 | USD
[NAME] | 500 | 1100 |  | 1100 |  |  |  |  |  |  |  | [NAME] | 2023-04-17 00:00:00 | 500 | g | 1100 | USD
[NAME] | 1000 | 865 |  | 865 |  |  |  |  |  |  |  | [NAME] | 2023-04-17 00:00:00 | 1000 | g | 865 | USD
Al-102 | 50 | 1000 |  | 1000 |  |  |  |  |  |  |  | Al-102 | 2023-04-17 00:00:00 | 30 | g | 1000 | USD
Al-102 | 100 | 1000 |  | 1000 |  |  |  |  |  |  |  | Al-102 | 2023-04-17 00:00:00 | 1000 | g | 830 | USD
Al-103 | 250 | 940 |  | 940 |  |  |  |  |  |  |  | Al-103 | 2023-04-17 00:00:00 | 30 | g | 940 | USD
Al-103 | 500 | 940 |  | 940 |  |  |  |  |  |  |  | [NAME] | 2023-04-17 00:00:00 | 100 | g | 1200 | USD
Al-104 | 1000 | 46 |  | 46 |  |  |  |  |  |  |  | Al-104 | 2023-04-17 00:00:00 | 1000 | g | 46 | USD
Al-105 | 50 | 33 |  | 33 |  |  |  |  |  |  |  | Al-105 | 2023-04-17 00:00:00 | 25000 | g | 33 | USD
Al-130 | 100 | 29 |  | 29 |  |  |  |  |  |  |  | Al-130 | 2023-04-17 00:00:00 | 25000 | g | 29 | USD
Al-111 | 250 | 71 |  | 71 |  |  |  |  |  |  |  | Al-111 | 2023-04-17 00:00:00 | 1000 | g | 71 | USD
Al-112 | 500 | 39 |  | 39 |  |  |  |  |  |  |  | Al-112 | 2023-04-17 00:00:00 | 1000 | g | 39 | USD
Al-113 | 1000 | 7 |  | 7 |  |  |  |  |  |  |  | AA7075-100 | 2023-04-17 00:00:00 | 500 | g | 130 | USD
Al-113 | 50 | 8 |  | 8 |  |  |  |  |  |  |  | Al-113 | 2023-04-17 00:00:00 | 1000 | g | 7 | USD
AA7075-100 | 100 | 120 |  | 130 |  |  |  |  |  |  |  | AA7075-100 | 2023-04-17 00:00:00 | 1000 | g | 120 | USD
AA7075-101 | 250 | 106 |  | 106 |  |  |  |  |  |  |  | AA7075-101 | 2023-04-17 00:00:00 | 1000 | g | 106 | USD
AA7075-102 | 500 | ALERT |  | ALERT |  |  |  |  |  |  |  | Al-113 | 2023-04-17 00:00:00 | 500 | g | 8 | USD
AA7075-103 | 1000 | ALERT |  | ALERT
AA7075-104 | 50 | ALERT |  | ALERT
Spreadsheet: 30604d1226210122-automatically-display-problem-present-absent
Sheet: Sheet1

 | Present | 1,2,4,6
1 | Present
2 | Present
3 | Absent
4 | Present
5 | Absent
6 | Present
7 | Absent
8 | Absent
9, | Absent
10, | Absent
11, | Absent
12, | Absent
13, | Absent
14, | Absent
15, | Absent
16, | Absent
17, | Absent
18, | Absent
19, | Absent
20, | Absent
Spreadsheet: 152299d1335333674-schedule-solution-schedule
Sheet: Sheet1

Teacher 1 | FRI | FRI | FRI | FRI | FRI |  | SAT | SAT | SAT | SAT | SAT |  | SUN | SUN | SUN | SUN |  | MON | MON | MON | MON |  | TUE | TUE | TUE | TUE |  | WED | WED | WED | WED |  | THU | THU | THU | THU
 | 1 | 8 | 15 | 22 | 29 |  | 2 | 9 | 16 | 23 | 30 |  | 3 | 10 | 17 | 24 |  | 4 | 11 | 18 | 25 |  | 5 | 12 | 19 | 26 |  | 6 | 13 | 20 | 27 |  | 7 | 14 | 21 | 28
8 > 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day | Date | Class | Chinese Teacher | Hour | Time | Room | FT
8 > 10
10 > 12
10 > 12
2 > 4
2 > 4
4 > 6
4 > 6
6 > 8 | ER
6 > 8 | ET
Teacher 2 | FRI | FRI | FRI | FRI | FRI |  | SAT | SAT | SAT | SAT | SAT |  | SUN | SUN | SUN | SUN |  | MON | MON | MON | MON |  | TUE | TUE | TUE | TUE |  | WED | WED | WED | WED |  | THU | THU | THU | THU
 | 1 | 8 | 15 | 22 | 29 |  | 2 | 9 | 16 | 23 | 30 |  | 3 | 10 | 17 | 24 |  | 4 | 11 | 18 | 25 |  | 5 | 12 | 19 | 26 |  | 6 | 13 | 20 | 27 |  | 7 | 14 | 21 | 28
8 > 10
8 > 10
10 > 12
10 > 12
2 > 4
2 > 4
4 > 6
4 > 6
6 > 8 | EB
6 > 8 | EV
Teacher 3 | FRI | FRI | FRI | FRI | FRI |  | SAT | SAT | SAT | SAT | SAT |  | SUN | SUN | SUN | SUN |  | MON | MON | MON | MON |  | TUE | TUE | TUE | TUE |  | WED | WED | WED | WED |  | THU | THU | THU | THU
 | 1 | 8 | 15 | 22 | 29 |  | 2 | 9 | 16 | 23 | 30 |  | 3 | 10 | 17 | 24 |  | 4 | 11 | 18 | 25 |  | 5 | 12 | 19 | 26 |  | 6 | 13 | 20 | 27 |  | 7 | 14 | 21 | 28
8 > 10
8 > 10
10 > 12
10 > 12
2 > 4
2 > 4
4 > 6
4 > 6
6 > 8
6 > 8
Spreadsheet: 049a7223-71cf-41a8-80c8-175a1fc7fdc8
Sheet: Sheet1

Table 11  -- Mexico: sugar production and supply, and sugar and HFCS utilization | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
Fiscal Year (Oct/Sept) | 2010/11 | 2011/12   1/ | 2012/13   1/
 | 1,000 metric tons, raw value
Beginning stocks | 973.0000000000034 | 805.50036 | 847.47
Production | 5494.51 | 5326.5 | 5618
Imports | 306.50854 | 405.49558 | 192.03702
Imports for consumption | 113.89488 | 224.05856 | 0
Imports for other uses (includes IMMEX) | 192.61366 | 181.43702 | 192.03702
Total supply | 6774.018540000004 | 6537.49594 | 6657.50702
Disappearance
Human consumption | 4186.98198 | 4346 | 4321.67194
Other deliveries (IMMEX) | 310.34574 | 300 | 300
Miscellaneous | -86.3512799999965
Total | 4410.976440000004 | 4646 | 4621.67194
Exports | 1557.54174 | 1042.96594 | 1193.1090517
Exports to the United States & Puerto Rico | 1517.74616 | 1032.365939999999 | 1182.5090517
Exports to other countries | 39.79557999999989 | 10.6 | 10.6
Total use | 5968.518180000004 | 5688.96594 | 5814.7809917
Ending stocks | 805.50036 | 847.47 | 842.7260283000002
 | 1,000 metric tons, actual weight
Beginning stocks | 917.92452830189 | 759.906 | 799.5
Production | 5183.5 | 5025 | 5300
Imports | 289.159 | 382.543 | 181.167
Imports for consumption | 107.448 | 211.376 | 0
Imports for other uses (includes IMMEX) | 181.711 | 171.167 | 181.167
Total supply | 6390.58352830189 | 6167.449 | 6280.667
Disappearance
Human consumption | 3949.983 | 4100 | 4077.049
Other deliveries (IMMEX) | 292.779 | 283.0188679245283 | 283.0188679245283
Miscellaneous | -81.46347169811042
Total | 4161.29852830189 | 4383.018867924528 | 4360.067867924528
Exports | 1469.379 | 983.9301320754712 | 1125.574577075472
Exports to the United States & Puerto Rico | 1431.836 | 973.9301320754712 | 1115.574577075472
Exports to other countries | 37.54299999999989 | 10 | 10
Total Use | 5630.67752830189 | 5367.949 | 5485.642445
Ending stocks | 759.906 | 799.5 | 795.0245550000001
Stocks-to-human consumption (percent) | 19.2382093796353 | 19.5 | 19.5
Stocks-to-Use (percent) | 13.4958181529741 | 14.89395670487928 | 14.4928249146942
HFCS Consumption (dry weight) | 1635.114 | 1720 | 1806
[NAME].
Source: USDA, WASDE and ERS, MTED, Sugar and Sweeteners Outlook.
 |  |  |  |  |  |  |  |  |  |  | 4692.74 | 22.67485608371645 | 1194.964915611857 | 5097 | 0.2344447548777431
 |  |  |  |  |  |  |  |  |  |  | 4861.74 | 22.05138788051045 | 1237.964915611857 | 5380 | 0.2301050029018321 | 2.010942709542895e-18 | 1.144264338361668e+17
 |  |  |  |  |  |  |  |  |  |  | 4713.227 | 28.70021590164625 | 1583.964915611857 | 5257 | 0.3013058618245875
 |  |  |  |  |  |  |  |  |  |  | 4648.878 | 32.342718500758 | 1785.964915611857 | 5260 | 0.3395370561999728
Spreadsheet: 689414d1596386435-dynamic-drop-down-lists-data-validation-drop-down-list
Sheet: Sheet2

Option 1 | Option 2 | Option 3 | List Items
A | C | E | Hat
A | C | E | Mat
A | C | E | Sat
A | C | E | Min
A | C | F | [NAME]
A | C | F | Cat
A | D | E | Fat
A | D | E | Din
A | D | F | Rat
A | D | F | Dog
A | D | F | Pin
A | D | F | Car
B | C | E | Far
B | C | E | Tar
B | C | F | [NAME]
B | C | F | Bog
B | C | F | Tin
B | D | E | Hog
B | D | E | Nog
B | D | E | Fog
B | D | E | Bin
B | D | F | Fin
B | D | F | Rar
B | D | F | Dar
Spreadsheet: 76057d1276632198-excel-formula-based-on-multiple-statements-formula-help-6-15-2010
Sheet: Sheet1

Quote Currency in JPY? | Lot Size | Long or Short | Quantity | Entry Price | Exit Price | Gross P&L | # PIPS
Y | 100000 | L | 1 | 93.985 | 94.048
Y | 100000 | S | 1 | 93.985 | 94.048
 | 100000 | L | 1 | 93.985 | 94.048
 | 100000 | S | 1 | 93.985 | 94.048
Spreadsheet: 797911d1664210815-only-show-rows-that-match-tab-name-until-a-new-row-value-sample-excel-zones
Sheet: Data

Data
Zone Group | Zone
North | a
North | b
North | c
North | d
North | e
North | f
North | g
East | 2
East | 4
East | 6
East | 8
South | r1
South | r2
South | r3
South | r4
South | r5
South | r6
South | r7
West | 1a
West | 2a
West | 3a
Spreadsheet: 844586d1696352347-hi-i-need-a-few-things-adding-or-changing-on-this-fishing-results-workbook-please-golborne-results-master-copy
Sheet: 3

Name | lbs | oz | Oz (total) | Points
 | 233
 | 435
 | 35
 | 66
 | 43
 | 466
 | 26
Spreadsheet: 30709d1226405416-excel-2007-finding-lowest-number-in-a-range-of-numbers-661777
Sheet: Sheet1

Part Number | List Price | AB | CD | EF | GH | IJ | KL | MN | OP | QR |  | Cheapest 1 | Account | Cheapest 2 | Account | Cheapest 3 | Account
123 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
456 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
789 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29
1011 |  | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39
1213 |  | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
1415 |  | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59
1617 |  | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69
1819 |  | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79
2021 |  | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89
2223 |  | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99
Spreadsheet: 698733d1602153896-proportional-distribution-upto-the-cap-test-13-ans1-4
Sheet: Iteration 1 

Example 1
 |  |  | Inventory Available |  | 7000
 | Total
 | Item |  | Required | [NAME] cap | Requirement with cap
 | A |  | 0 | 2000 | 0
 | B |  | 4000 | 2000 | 2000
 | C |  | 4500 | 5000 | 5000
 | D |  | 0 | 5000 | 0
 |  |  | Inventory Left |  | 0
 |  |  |  |  | Inventory Available 1 | Inventory Available 2 | Inventory Available 3 |  | I want a formula in F21 which do the three steps i.e., Step 1 - distribute the inventory on the basis of there requirement, Step 2- cap the distribution upto there [NAME]. cap and Step 3, distribute the delta arisen from the capped amount to remaining item
Example 2 |  |  | Total Inventory --> |  | 15500
 |  |  | Category |  | 1 | 2 | 3 |  | 1
 | Total |  |  |  |  |  |  |  | Step 1 | Step 2 | Step 3
 | Item | Category | Required | [NAME] cap | Requirement with cap for "1" | Requirement with cap for "2" | Requirement with cap for "3" |  | Distribution based on nomination | [NAME] the distribution | Distribute the Delta to other item upto there CAP |  |  | Requirement with cap for "1"
 |  |  |  |  |  |  |  |  |  |  | Delta | Distribute to item whose cap has not yet met
 | A | 1 | 2000 | 2000
 | B | 1 | 4000 | 2000
 | C | 1 | 4500 | 5000
 | D | 1 | 1000 | 5000
 | E | 3 | 2000 | 4000
 | F | 2 | 4500 | 3500
 | G | 2 | 1000 | 6000
Spreadsheet: 769186d1645374340-find-item-in-one-cell-and-return-value-from-another-401k-weekly-upload-to-pentegra-v4-help-file-2
Sheet: Hours

Hours Worked |  |  | Salaried Employees | Hours Worked
 |  |  |  | 40
 |  |  |  | 40
 |  |  |  | 20
 |  |  |  | 20
 |  |  |  | 40
 |  |  |  | 40
Spreadsheet: 549750d1511896491-sum-multiple-worksheets-lkk-pf-cycle-count-master
Sheet: AC

Date: |  | LKK Cycle Count | Location AC
Location | Code | Description | Count | Recount
AC-01-A-01 | 979 |  | 1
AC-01-A-02
[NAME]
[NAME]
[NAME]
AC-01-C-02
AC-02-A-01
AC-02-A-02
AC-02-B-01
AC-02-B-02
AC-02-C-01
AC-02-C-02
AC-03-A-01
AC-03-A-02
[NAME]
AC-03-B-02
AC-03-C-01
AC-03-C-02
AC-04-A-01
AC-04-A-02
AC-04-B-01
AC-04-B-02
AC-04-C-01
AC-04-C-02
AC-05-A-01
AC-05-A-02
AC-05-B-01
AC-05-B-02
AC-05-C-01
AC-05-C-02
AC-06-A-01
AC-06-A-02
[NAME]
[NAME]
[NAME]
AC-06-C-02
AC-07-A-01
AC-07-A-02
AC-07-B-01
AC-07-B-02
AC-07-C-01
AC-07-C-02
AC-08-A-01
AC-08-A-02
AC-08-B-01
AC-08-B-02
AC-08-C-01
AC-08-C-02
AC-09-A-01
AC-09-A-02
[NAME]
[NAME]
[NAME]
AC-09-C-02
AC-10-A-01
AC-10-A-02
AC-10-B-01
AC-10-B-02
AC-10-C-01
AC-10-C-02
AC-11-A-01
AC-11-A-02
AC-11-B-01
AC-11-B-02
[NAME]
AC-11-C-02
Location | Code | Description | Count
AC-12-A-01
AC-12-A-02
AC-12-B-01
AC-12-B-02
AC-12-C-01
AC-12-C-02
AC-13-A-01
AC-13-A-02
AC-13-B-01
AC-13-B-02
[NAME]
AC-13-C-02
AC-14-A-01
AC-14-A-02
AC-14-B-01
AC-14-B-02
AC-14-C-01
AC-14-C-02
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
AC-15-C-02