tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 42585d1241117860-calculate-stats-from-multiple-csv-files-fletch-755-fletch-755-_solution
Sheet: solution

Person | Question number | Question title | Total points | Scored | Auxiliary field |  | Question | Scored |  | % |  | Total Questions
Person 1 | 1 | Put them in order. | 4 | 1 | 11 |  |  | 0 | 1 | 0 | 1
Person 1 | 2 | True or False | 1 | 0 | 20 |  | 1 | 0 | 2 | 0 | 1 | 2
Person 1 | 3 | What one is Correct | 1 | 1 | 31 |  | 2 | 1 | 1 | 0.5 | 0.5 | 2
Person 2 | 1 | Put them in order. | 4 | 1 | 11 |  | 3 | 1 | 1 | 0.5 | 0.5 | 2
Person 2 | 2 | True or False | 1 | 1 | 21 |  | 4
Person 2 | 3 | What one is Correct | 1 | 0 | 30 |  | 5
Person 3 |  |  |  |  |  |  | 6
Person 3 |  |  |  |  |  |  | Totals | 2 | 4 |  |  | 6
Person 3 |  |  |  |  |  |  | Percentage | 0.3333333333333333 | 0.6666666666666666 |  |  | 1
Person N
Person N |  |  |  |  |  |  | Excel Spreadsheet Authors
Person N |  |  |  |  |  |  | Examples
 |  |  |  |  |  |  | For more examples and information about COUNTIF visit:
Total questions | 6 |  |  |  |  |  | http://www.excel-spreadsheet-authors.com/countif.html
 |  |  |  |  |  |  | For more information and best practice tips about Excel Functions visit:
 |  |  |  |  |  |  | http://www.excel-spreadsheet-authors.com/excel-functions.html
Spreadsheet: 676478d1588825359-select-dates-when-first-and-last-occurrence-of-a-value-below-date-row-occurs-workday-ranges
Sheet: Sheet1

 | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00 | 2020-06-11 00:00:00 | 2020-06-12 00:00:00 | 2020-06-13 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-16 00:00:00 | 2020-06-17 00:00:00 | 2020-06-18 00:00:00 | 2020-06-19 00:00:00 | 2020-06-20 00:00:00 | 2020-06-21 00:00:00 | 2020-06-22 00:00:00 | 2020-06-23 00:00:00 | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 | 2020-06-27 00:00:00 | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00
worker 1 | 24 | 24 | 24 | 24 |  |  |  |  |  | 24 | 24 | 24 | 24 |  |  | 24 | 24 | 24 |  |  |  |  | 24 | 24 | 24 | 24
worker 2 |  |  |  |  | 24 | 24 | 24 | 24 | 24 | 24 | 24 |  |  |  |  |  |  | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 |  |  |  |  | 24
 | Worker 1 |  | Worker 2
 | Start | End | Start | End
workdays range 1 |  | 2020-06-09 00:00:00 |  | 2020-06-04 00:00:00
workdays range 2 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-12 00:00:00 | 2020-06-17 00:00:00
workdays range 3 | 2020-06-19 00:00:00 | 2020-06-22 00:00:00 | 2020-06-26 00:00:00 | 2020-06-29 00:00:00
workdays range 4 | 2020-06-27 00:00:00 | 2020-06-30 00:00:00
DFP
DFP | 2020-06-02 00:00:00 |  | 2020-06-06 00:00:00
DFP | 2020-06-03 00:00:00 |  | 2020-06-07 00:00:00
DFP | 2020-06-04 00:00:00 |  | 2020-06-08 00:00:00
DFP | 2020-06-10 00:00:00 |  | 2020-06-09 00:00:00
DFP | 2020-06-11 00:00:00 |  | 2020-06-10 00:00:00
DFP | 2020-06-12 00:00:00 |  | 2020-06-11 00:00:00
DFP | 2020-06-13 00:00:00 |  | 2020-06-18 00:00:00
DFP | 2020-06-16 00:00:00 |  | 2020-06-19 00:00:00
DFP | 2020-06-17 00:00:00 |  | 2020-06-20 00:00:00
DFP | 2020-06-18 00:00:00 |  | 2020-06-21 00:00:00
DFP | 2020-06-23 00:00:00 |  | 2020-06-22 00:00:00
DFP | 2020-06-24 00:00:00 |  | 2020-06-23 00:00:00
DFP | 2020-06-25 00:00:00 |  | 2020-06-24 00:00:00
DFP | 2020-06-26 00:00:00 |  | 2020-06-25 00:00:00
DFP |  |  | 2020-06-30 00:00:00
Spreadsheet: gerald_nemec__11451__Project Cost and Projections thru September 11
Sheet: Sheet1

 |  |  | Approved | Work Orders | Work Orders | Work Orders | Work Orders Estimated |  | Work Orders
System Name | Account Number | System Number | Capital Cost | Capital Cost | Capital Cost | Capital Cost | Accrual for Mat.&Labor |  | Estimate at
 |  |  | RAROC | Approved | Thru June 30th | 6-30 to 9-11 | Thru 9-15 |  | Completion
House Creek | 11025 | 100 | 11944234 | 5151501 | 2930353 | 3800.93 | 5000 |  | 11944234
Caballo Lateral | 11026 | 200 | See Note 2 | 2511400 | 2703658 | 59226.71 | 10000 |  | 2800000
Caballo Compression | 11026 | 200 | 8062497 | 5740000 | 6498109 | 855571.69 | 83000 |  | 7900000
Clydesdale | 11027 |  | 3254256 | 3370675 | 933169 | 938918.85 | 750000 |  | 3254256
South Kitty | 11028 |  | 7462998 | 9413156 | 1500547 | 1728058.11 | 1500000 |  | 7462998
Hoe Creek | 11029 |  | 6735882 | 4661220 | 654157 | 133999.61 | 350000 |  | 6735882
[NAME] | 11030 | 400 | 6707026 | 7053775 | 7402549 | 207606.48 | 90000 |  | 7900000
Maverick | 11030 | 300 | 1650000 | See Note 1 | See Note 1 | See Note 1 | See Note 1 |  | See Note 1
Kudzu |  |  | 4729128 | 0 | 0 | 0 | 0 |  | 7153363
Fort Union Receipt Points |  |  | 676713 | 1194000 | 1104406 | 130511.65 | 12000 |  | 1325000
 |  | Grand Total =
Note 1:  All of Maverick's Capital cost is included in the Box Draw work order.
Note 2:  This cost was included in the Caballo Compression RAROC number.
The Following Contractors are currently providing services for the listed Work Orders.
1.La-Tex Associates under a Master Construction Agreement ("MCA") dated June 15, 1996 between La-Tex and Gulf Coast Operations, and billing in accordance with Affiliate [NAME] dated July 31, 2000
and the attached rate schedule.
2.ForeRunner Corporation under a MCA dated effective September 1, 1999 between ForeRunner and Enron Midstream Services, L.L.C. ("EMS"), billing in accordance with the applicable rate schedule
3.Flint Engineering & Construction Co. under MCA dated February 1, 1996 between Flint and Transwestern Pipeline Company, bulling pursuant to Affiliate [NAME] dated July 28, 2000
with a lump sum of $93,772.00.
4. Watkins Construction CO., Inc. under MCA dated December 15, 1999 between Watkins and EMS, billing under unit price schedule attached to [NAME] dated July 19, 2000.
5. Gas Gathering Specialist, Inc. under MCA dated January 1, 1995 between Gas Gathering and Florida Gas Transmission, et al, billing in accordance with Affiliate [NAME] dated June 29, 2000
and priced in accordance with the rate schedule.
6. Pacific Industrial Electric, Inc. under MCA dated April 15, 2000 between Pacific Industrial and EMS, billing in accordance to the rate schedule.
7. Okemah Construction, Inc. under MCA dated October 18, 1999 between Okemah and Northern Natural Gas Company, billing in accordance with the Affiliate Work offer dated July 10, 2000
for a lump sum of $535,774.50.
8. [NAME], Inc. contract and work offer in process and work to begin September 25, 2000.
Spreadsheet: gstorey__12026__Feb01
Sheet: Table1

NATURAL GAS EXPORTS - SUMMARY |  |  |  |  |  |  |  | Table 1
EXPORTATION DE GAZ NATUREL - SOMMAIRE
 |  | - - - - - - -Month/Mois- - - - - - |  | Variation |  | - - - - - - - Cumulative to date - - - - - - |  | Variation
 |  | 2000-02-01 00:00:00 | 2001-02-01 00:00:00 | % Change |  | 1999/11-2000/02 | 2000/11-2001/02 | % Change
Volume (Millions M3) | Long-term / Long terme | 2247.4 | 1668.4 | -0.258 |  | 9028.4 | 7506.9 | -0.169
 | Short-term / Court terme | 6012.3 | 6844.8 | 0.138 |  | 24813.9 | 31214.5 | 0.258
 | Total | 8259.7 | 8513.2 | 0.031 |  | 33842.3 | 38721.4 | 0.144
Revenue/Recettes (Millions $[NAME]) | Long-term / Long terme | 305.3 | 497.6 | 0.63 |  | 1218.9 | 2335.8 | 0.916
 | Short-term / Court terme | 764.4 | 2410.9 | 2.154 |  | 3136.3 | 12154.2 | 2.875
 | Total | 1069.7 | 2908.6 | 1.719 |  | 4355.3 | 14490 | 2.327
Avg. price/Prix moyen ($CDN/GJ) | Long-term / Long terme | 3.59 | 7.86 | 1.193 |  | 3.56 | 8.21 | 1.304
 | Short-term / Court terme | 3.35 | 9.22 | 1.753 |  | 3.33 | 10.22 | 2.068
 | Total | 3.41 | 8.95 | 1.623 |  | 3.39 | 9.83 | 1.898
Volume (BCF) | Long-term / Long terme | 79.3 | 58.9 | -0.258 |  | 318.7 | 265 | -0.169
 | Short-term / Court terme | 212.2 | 241.6 | 0.138 |  | 876 | 1101.9 | 0.258
 | Total | 291.6 | 300.5 | 0.031 |  | 1194.7 | 1366.9 | 0.144
Revenue/Recettes (Millions $US) | Long-term / Long terme | 210.4 | 327 | 0.554 |  | 834.9 | 1536.8 | 0.841
 | Short-term / Court terme | 526.8 | 1584.3 | 2.007 |  | 2147.8 | 8005.8 | 2.728
 | Total | 737.2 | 1911.3 | 1.593 |  | 2982.6 | 9542.6 | 2.199
Avg. price/Prix moyen ($US/MMBTU) | Long-term / Long terme | 2.65 | 5.54 | 1.091 |  | 2.62 | 5.8 | 1.213
 | Short-term / Court terme | 2.48 | 6.5 | 1.625 |  | 2.45 | 7.22 | 1.951
 | Total | 2.52 | 6.31 | 1.502 |  | 2.49 | 6.95 | 1.787
Spreadsheet: 804644d1668195490-i-need-a-formula-for-an-avg-of-a-data-set-found-on-multiple-sheets-but-must-exclude-zeroes-mmjj-drivosity-scores-test
Sheet: 1696

First | Last | 4 week Score Avg | 4 week Incident per [NAME] | Week 41 Score | Week 41 Incidents Per Mile | Week 42 Score | Week 42 Incidents Per Mile | Week 43 Score | Week 43 Incidents Per Mile | Week 44 Score | Week 44 Incidents Per Mile
Rebecca | Loera |  |  | 98 | 0.18 | 99 | 0.14 | 98 | 0.24 | 98 | 0.18
Jeremiah | Lopez |  |  | n/a | n/a | n/a | n/a | 94 | 0.67 | n/a | n/a
[NAME] | Steele |  |  | 88 | 1.79 | 91 | 1.7 | 87 | 1.97 | 83 | 1.75
 | Store Average
Spreadsheet: joe_parks__14753__ITM 03 Positions
Sheet: R5

[NAME] | R5!$D$4 | Sum = |  |  | Sum = |  | R5!$F$4:$F$31
 | Ref |  | Net | Net | RollOff | Final | Conversion | Converted | Liquidation
[NAME] | Period | Curve Code | Qty | Qty | Qty | Qty | Factor | Qty | (%)
 | 2002-04-01 00:00:00 | IF-CNG/APPALACH | -29.97842976
Spreadsheet: 08382feb-6552-4cf0-80ae-1c3d3712eb3e
Sheet: Sheet1

Table 6--U.S. rice imports  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Country | 2012/13 | 2011/12 | 2011/12 | 2010/11 | 2009/10 | 2008/09
or | through | through | market | market | market | market
region | January 2013 | January 2012 | year | year | year | year
 |  |  | 1,000 metric tons
ASIA | 329.943 | 285.361 | 541.563 | 529.833 | 563.943544 | 536.401387
China | 1.368 | 2.075 | 3.571 | 3.1 | 3.786815 | 3.951477
India | 67.234 | 48.593 | 110.58 | 96.454 | 94.809691 | 74.049801
Pakistan | 6.133 | 6.809 | 15.258 | 17.297 | 19.386689 | 16.851572
Thailand | 204.904 | 215.561 | 387.642 | 393.464 | 400.976938 | 422.132044
Vietnam | 48.576 | 10.846 | 21.664 | 15.601 | 41.55395 | 17.477892
Other | 1.728000000000002 | 1.476999999999979 | 2.84800000000007 | 3.916999999999916 | 3.429461 | 1.938601
EUROPE & FSU | 5.867 | 7.56 | 14.244 | 12.51 | 9.410672 | 7.566448
Italy | 3.858 | 4.136 | 8.201 | 7.53 | 6.220285 | 5.73241
Spain | 0.961 | 2.523 | 4.671 | 3.753 | 1.55218 | 0.419219
Russia | 0.023 | 0.014 | 0.024 | 0.034 | 0.032442 | 0.064456
United Kingdom | 0.112 | 0.039 | 0.039 | 0.009 | 0.126368 | 0.429608
Other | 0.9130000000000001 | 0.8479999999999993 | 1.309000000000001 | 1.183999999999997 | 1.479397 | 0.920755
WESTERN HEMISPHERE | 17.412 | 43.328 | 64.526 | 42.735403 | 42.735 | 31.065164
Argentina | 2.393 | 1.458 | 3.366 | 2.677 | 2.466583 | 1.121503
Brazil | 3.243 | 24.994 | 30.499 | 6.331 | 3.51007 | 3.902248
Canada | 5.235 | 8.245 | 16.323 | 17.067 | 15.357974 | 18.035834
Mexico | 0.524 | 0.645 | 1.085 | 1.264 | 6.120591 | 6.094151
Uruguay | 6 | 7.973 | 13.211 | 15.35 | 2.871551 | 1.710958
Other | 0.01699999999999768 | 0.01300000000000612 | 0.04199999999998738 | 0.045744 | 0.030665 | 0.20047
OTHER | 0.7540000000000155 | 0.4770000000000039 | 3.958000000000069 | 3.532636 | 5.470538 | 39.298261
Egypt | 0.184 | 0 | 0 | 0 | 0.644508 | 36.591199
United Arab Emirates | 0.144 | 0.283 | 0.522 | 3.03 | 4.441327 | 2.224564
Other | 0.4260000000000156 | 0.1940000000000039 | 4.2 | 0.5 | 0.384703 | 0.482498
TOTAL | 353.976 | 336.726 | 624.291 | 588.611 | 609.182188 | 614.33126
1/ Columns labeled "market year" are total August-July imports reported by the U.S. Census Bureau.
All data is reported on a product-weight basis.  Categories may not sum to total due to rounding.
Source: U.S. Census Bureau, Department of Commerce.
Last updated March 8, 2013.
Spreadsheet: 800201d1665539177-gantt-chart-showing-milestone-overdue-with-revised-date-gantt-chart-with-revised-date-2-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | 2022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023
 |  |  |  |  |  |  |  |  |  |  | Quarter 1 |  |  |  |  |  |  |  |  |  |  |  |  | Quarter 2 |  |  |  |  |  |  |  |  |  |  |  |  | Quarter 3 |  |  |  |  |  |  |  |  |  |  |  |  | Quarter 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May |  |  |  |  | June |  |  |  | July |  |  |  | Aug |  |  |  |  | Sept |  |  |  | Oct |  |  |  |  | Nov |  |  |  | Dec |  |  |  | Jan |  |  |  |  | Feb |  |  |  | Mar
PROJECT | ANNUAL  GOAL | [NAME] ID | MILESTONE | REPORTING CONTACT | START  DATE | END  DATE | REVISED DATE | # DAYS | %  DONE | CURRENT MIL STATUS | 2022-04-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If milestone OR project has minor deviations or major deviations, explain why, and specify how timelline changes.
Health Care Worker Mental Health & Addictions Supports Program | Sustain Health Care Worker Mental Health Supports Program | 1 | Develop new pathway to include referral or transfer of referral to OPA. | Monisha Patel | 2022-06-30 00:00:00 | 2022-10-19 00:00:00 | 2022-12-31 00:00:00 |  | 0.9 | On Track
 |  | 2 | Continue to provide timely (<7 days) access to 1:1 supports | Monisha Patel | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 2023-01-11 00:00:00 |  | 0.5 | On Track
 |  | 3 | Continue to sustain the program ​ | Monisha Patel | 2022-07-01 00:00:00 | 2023-03-31 00:00:00 |  |  | 0.5 | Minor Deviation
Youth Wellness Hubs Ontario | Support Expansion of Youth Wellness Hubs | 1 | Develop workplans with YWHO | TBD | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 |  |  | 1 | Complete
 |  | 2 | Issue funding letter to YWHO (via CAMH) | TBD | 2022-07-01 00:00:00 | 2022-09-30 00:00:00 |  |  | 1 | Complete
Mobile Mental Health & Addiction Clinics | Implement and evaluate MMHACs in Ontario | 1 | Receive ADM funding letter for up to 3 additional MMHACs | Monisha Patel | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 |  |  | 0.75 | On Track
 |  | 2 | Launch 4 MMHACs so they can start to accept referrals and see clients | Monisha Patel | 2022-04-01 00:00:00 | 2023-03-31 00:00:00 |  |  | 0.5 | Major Deviation
 |  | 3 | Complete the review process to onboard one additional MMHAC | Monisha Patel | 2022-04-01 00:00:00 | 2022-06-30 00:00:00
 |  | 4 | Issue funding agreements for up to 3 additional MMHACs | Monisha Patel | 2022-07-01 00:00:00 | 2022-09-30 00:00:00
 |  | 5 | Develop an evaluation framework | Monisha Patel | 2022-10-01 00:00:00 | 2023-03-31 00:00:00
 |  | 6 | Onboard the 4 approved MMHACs to be fully operational | Monisha Patel | 2022-10-01 00:00:00 | 2022-12-31 00:00:00
 |  | 7 | Collect baseline data | Monisha Patel | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
Spreadsheet: 142633d1329936124-how-to-create-a-formula-based-on-excel-data-already-inputed-3-inch-riser-tube-all-submergences_mahju
Sheet: Sheet3

 |  |  |  |  |  | The equation
 |  |  |  |  |  | Y=m1x1+m2x2+m3x3+b
 | Submergence | Lift | Air Supply | GPM |  | [NAME]
 | 44 | 1 | 20 | 45 |  | 1.078181818181818 | -10 | 0 | 34.77727272727272 | Equation
 | 44 | 1 | 22.5 | 49 |  | Air Supply | Lift | Submerge | b
 | 44 | 1 | 25 | 52 |  | X3 | X2 | X1
 | 44 | 1 | 27.5 | 56 |  | 30 | 2 | 44 | Input values
 | 44 | 1 | 30 | 59 |  | 47.12272727272727
 | 44 | 1 | 32.5 | 61
 | 44 | 1 | 35 | 64
 | 44 | 1 | 37.5 | 65
 | 44 | 1 | 40 | 67
 | 44 | 1 | 42.5 | 69
 | 44 | 1 | 45 | 71
 | 44 | 2 | 20 | 32
 | 44 | 2 | 22.5 | 38
 | 44 | 2 | 25 | 41
 | 44 | 2 | 27.5 | 45
 | 44 | 2 | 30 | 48
 | 44 | 2 | 32.5 | 53
 | 44 | 2 | 35 | 55
 | 44 | 2 | 37.5 | 57
 | 44 | 2 | 40 | 58
 | 44 | 2 | 42.5 | 60
 | 44 | 2 | 45 | 61
Spreadsheet: 843882d1695710901-create-a-dependent-drop-down-for-3-levels-dropdown2
Sheet: Sheet1

Master Data |  |  |  |  |  | 1st dropdown |  | DropDown |  |  |  |  | 2nd dropdown |  |  |  |  |  |  |  |  |  |  |  | 3nd dropdown
 |  |  |  |  |  | OFFICE |  |  |  |  |  | Blank Col | 1 |  |  |  |  |  |  |  |  |  |  | Blank Col | 1
OFFICE | DEPARTMENT | STAFF | OffDept |  |  |  |  | OFFICE | DEPARTMENT | STAFF
KUL | SALES | JESS |  |  |  |  |  | KOR | ACC | JOY
KUL | SALES | MIKE |  |  |  |  |  | KOR | HR | [NAME]
JPN | ADMIN | KEVIN |  |  |  |  |  | KOR
JPN | SALES | SUKI
JPN | HR | SAM
KOR | HR | JOY
KOR | HR | [NAME]
KOR | ACC | JAKE
IND | ACC | MAY
PHP | ADMIN | SUKI
 |  |  |  | End of data (add ' in the A14 : A14 is not blank)
Spreadsheet: 476873d1472052657-runrate-over-the-last-14-days-hlookup-offset-and-match-i-think-runrate
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st
New |  |  |  | 1 | 1 | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  | 1 | 2 | 1 | 2 |  | 1 | 2 | 1
Used | 1 | 3 |  |  | 1 | 1 | 2 | 3 | 4 |  | 1 | 2 | 2 | 1 | 3 |  | 2 | 5 | 3 | 1 | 2 |  | 3 | 1
 | Day of the month now
New run rate month to date |  |  |  |  |  |  |  | New run rate last 14 days |  |  |  |  |  |  |  |  | New forcast for month
Used run rate month to date |  |  |  |  |  |  |  | Used run rate last 14 days |  |  |  |  |  |  |  |  | Used forcast for month
 |  |  |  | I think I need to use an HLOOKUP then OFFSET then MATCH but cang get it right
Spreadsheet: 867824d1714626319-how-to-get-multiple-vlookup-values-in-to-dropdown-list-bank-interest-3_2-reimbursmnt-sample
Sheet: Loan Details

PF No | Name | Designation | Loan Number | Bank | Branch | Month | Helper
37224 | W.P.G. [NAME] | Accounting Assistant | 10292 | ***** | *****
37224 | W.P.G. [NAME] | Accounting Assistant | 231026 | ***** | *****
37224 | W.P.G. [NAME] | Accounting Assistant | 102922323 | ***** | *****
36224 | Anura | Chief [NAME] | 108024 | ***** | *****
36224 | Anura | Chief [NAME] | 22222222 | ***** | *****
41205 | [NAME] | [NAME] | 412650 | ***** | *****
Spreadsheet: 203739d1357234419-problem-with-date-formula-nse-holiday-2013
Sheet: Sheet1

Sr. No. | Date | Day | Description
1 | 2013-03-27 00:00:00 | Wednesday | Holi
2 | 2013-03-29 00:00:00 | Friday | Good Friday
3 | 2013-04-19 00:00:00 | Friday | [NAME]
4 | 2013-04-24 00:00:00 | Wednesday | [NAME]
5 | 2013-05-01 00:00:00 | Wednesday | May Day
6 | 2013-08-09 00:00:00 | Friday | Ramzan ID
7 | 2013-08-15 00:00:00 | Thursday | Independence Day
8 | 2013-09-09 00:00:00 | Monday | Ganesh Chaturthi
9 | 2013-10-02 00:00:00 | Wednesday | [NAME]
10 | 2013-10-16 00:00:00 | Wednesday | Bakri ID
11 | 2013-11-04 00:00:00 | Monday | Diwali-Balipratipada
12 | 2013-11-14 00:00:00 | Thursday | Moharram
13 | 2013-12-25 00:00:00 | Wednesday | Christmas
Spreadsheet: 80489d1280743863-grouping-results-using-multisheet-consolidation-testing2-1
Sheet: Results Required

 | County | State | Probability | Value | Month
 | Europe
 | Hungary |  | 0.9 | 10 | June
 | Sweden |  | 0.1 | 15 | June
 | US
 | USA | New York | 0.9 | 10 | June
 | USA | Florida | 0.1 | 15 | June
 | ME
 | Abu Dhabi |  | 0.9 | 10 | June
 | Oman |  | 0.2 | 100 | June
 | Dhubi |  | 0.3 | 25 | June
 |  |  |  |  |  |  |  |  |  | Choose Month | June
 |  |  |  |  |  |  |  |  |  | Choose probability
Spreadsheet: 1b184b78-700e-4e32-b1ee-6ccd5339e7b7
Sheet: Sheet1

Table 1--U.S. cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  | 2012/13
Item | 2011/12 |  | Jan. |  | Feb. |  | Mar.
 | Million acres
Upland:
Planted | 14.428 |  | 12.077 |  | 12.077 |  | 12.077
Harvested | 9.156 |  | 9.19 |  | 9.19 |  | 9.19
 | Pounds
Yield/harvested acre | 772 |  | 849 |  | 849 |  | 849
 | Million 480-lb. [NAME]
Beginning stocks | 2.572 |  | 3.081 |  | 3.081 |  | 3.081
Production | 14.722 |  | 16.25 |  | 16.25 |  | 16.25
Total supply   1/ | 17.307 |  | 19.336 |  | 19.336 |  | 19.336
[NAME] use | 3.278 |  | 3.38 |  | 3.38 |  | 3.38
Exports | 11.12 |  | 11.475 |  | 11.75 |  | 12
Total use | 14.398 |  | 14.855 |  | 15.13 |  | 15.38
Ending stocks  2/ | 3.081 |  | 4.516 |  | 4.241 |  | 3.941
 | Percent
Stocks-to-use ratio | 21.4 |  | 30.4 |  | 28 |  | 25.6
 | 1,000 acres
Extra-long staple:
Planted | 307.4 |  | 238.4 |  | 238.4 |  | 238.4
Harvested | 304.9 |  | 236.8 |  | 236.8 |  | 236.8
 | Pounds
Yield/harvested acre | 1340 |  | 1540 |  | 1540 |  | 1540
 | 1,000 480-lb. [NAME]
Beginning stocks | 28 |  | 269 |  | 269 |  | 269
Production | 851 |  | 760 |  | 760 |  | 760
Total supply   1/ | 885 |  | 1029 |  | 1029 |  | 1029
[NAME] use | 22 |  | 20 |  | 20 |  | 20
Exports | 594 |  | 725 |  | 750 |  | 750
Total use | 616 |  | 745 |  | 770 |  | 770
Ending stocks  2/ | 269 |  | 284 |  | 259 |  | 259
 | Percent
Stocks-to-use ratio | 43.7 |  | 38.1 |  | 33.6 |  | 33.6
1/ Includes imports.  2/ Includes unaccounted.
Sources: USDA, World Agricultural Outlook Board; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update:  03/12/13.
Spreadsheet: 11ecf49a-3032-4086-b7c1-8cd6f135e10c
Sheet: ILCC - Lakes Career Academy

Iowa Lakes Community College
2012-2013 Lakes Career Academy
Course Number | Course Title | Schedule | College Credit Hours | Contact Minutes | SCED Code           Replace 'uu' with sequencing | Comments
Health Sciences ( 20 credits)
Year 1 - Fall Semester
HSC 105 | [NAME] to [NAME]. | M-F 8:30-11:30am | 1 credit | 2492 | 14001C035uu
HSC 114 | Medical Terminolgoy | M-F 8:30-11:30am | 3 credits | 4604 | 14154C064uu
HSC 172 | Nurse Aid I | M-F 8:30-11:30am | 3 credits | 4500 | 14051C063uu
HSC 163 | Nutrition | M-F 8:30:-11:30am | 3 credits | 4604 | 08099C064uu
Year 1 - Spring Semester
SDV 103 | [NAME] | M-F 8:30-11:30am | 1 credit | 2492 | 22003C035uu
HSC 109 | Exploring Health Careers & Building Teams | M-F 8:30-11:30am | 3 credits | 4604 | 14001C064uu
MAP 515 | Pharmacology | M-F 8:30-11:30am | 3 credits | 4604 | 14253C064uu
HSC 177 | Nurse Aid II | M-F 8:30-11:30am | 3 credits | 4500 | 14051C063uu
Spreadsheet: mary_fischer__25623__31Y
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031Y
COMPANY NAME  The LINC Corp Holding Company
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other
Gross PP & E
Accumulated DD & A
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
 |  |  |  |  |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6