tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 206245d1358117664-deduct-partial-vacation-hours-taken-from-a-date-or-date-range-accrual-balance-and-vacation-records-ver1
Sheet: Vacation_Records

 | Enter all Vacation Days Taken
Emp No | EmpName | Vacation Start Date | Vacation End Date | Days Taken | HoursTaken | Year Taken | WeekNum
56654 | Smith, [NAME] | 2013-01-09 00:00:00 | 2013-01-09 00:00:00 | 1 | 8 | 2013 | 2
56656 | [NAME], [NAME] | 2013-02-04 00:00:00 | 2013-02-06 00:00:00 | 3 | 24 | 2013 | 6
58624 | [NAME], [NAME] | 2013-01-01 00:00:00 | 2013-01-03 00:00:00 | 2 | 16 | 2013 | 1
56656 | [NAME], [NAME] | 2013-03-11 00:00:00 | 2013-03-15 00:00:00 | 5 | 40 | 2013 | 11
56654 | Smith, [NAME] | 2013-01-11 00:00:00 | 2013-01-15 00:00:00 | 3 | 24 | 2013 | 2
58624 | [NAME], [NAME] | 2011-10-27 00:00:00 | 2011-10-27 00:00:00 | 1 | 8 | 2011 | 44
58624 | [NAME], [NAME] | 2013-01-22 00:00:00 | 2013-01-25 00:00:00 | 4 | 32 | 2013 | 4
56654 | Smith, [NAME] | 2013-04-03 00:00:00 | 2013-04-05 00:00:00 | 3 | 24 | 2013 | 14
56656 | [NAME], [NAME] | 2013-03-28 00:00:00 | 2013-04-01 00:00:00 | 2 | 16 | 2013 | 13
56654 | Smith, [NAME] | 2013-07-01 00:00:00 | 2013-07-07 00:00:00 | 4 | 32 | 2013 | 27
Spreadsheet: 729068d1618899375-average-last-8-values-of-a-columns-as-new-numbers-entering-count-or-percentage-of-a-value-last-8-rows
Sheet: Sheet1

Number | Persnatge in last 8 rows | data 1 | data 2 | data 3 | data 4 | data 5 | data 6
20 |  | 10 | 20 | 30 | 40 | 50 | 60 |  |  | count how many time a number repeated in last 8 entries
10 |  | 20 | 40 | 60 | 80 | 100 | 120
5 |  | 10 | 20 | 30 | 40 | 50 | 60
1 |  | 5 | 10 | 15 | 20 | 25 | 30
 |  | 1 | 2 | 3 | 4 | 5 | 6
 |  | 10 | 10 | 20 | 40 | 40 | 40
 |  | 20 | 20 | 40 | 80 | 80 | 80
 |  | 10 | 10 | 20 | 40 | 40 | 40
 |  | 5 | 5 | 10 | 20 | 20 | 20
 |  | 1 | 1 | 2 | 4 | 4 | 4
 |  | 10 | 20 | 10 | 40 | 40 | 40
 |  | 20 | 40 | 20 | 80 | 80 | 80
 |  | 10 | 20 | 10 | 40 | 40 | 40
 |  | 5 | 10 | 5 | 20 | 20 | 20
 |  | 1 | 2 | 1 | 4 | 4 | 4
Spreadsheet: 91712d1291384325-vlookup-problem-test-database
Sheet: Test Quote

 |  | Date | 2010-12-03 21:44:57
 |  |  |  |  |  |  |  |  | Quotation Charge Out Rate |  | 90
 |  | Quotation Reference |  |  |  |  | New Quotation |  | Actual Hourly Cost Rate |  | 75
 |  |  |  |  |  |  |  |  | Base Hourly Rate |  | 35
 |  |  |  |  |  |  |  |  | Profit |  | 0
 |  |  |  |  |  |  |  |  | Total of Quotation |  | 0
 |  | Job Name
 |  | Job Address |  |  |  |  |  |  | [NAME] |  | 0.2
 |  | Suburb |  |  |  |  |  |  | Material Total |  | 0
 |  |  |  |  |  |  |  |  | Labour Total |  | 0
 |  |  |  |  |  |  | Old Quotation |  | Profit |  | 0
 |  |  |  |  |  |  |  |  | Sub Cost |  | 0
 |  |  |  |  |  |  |  |  | Superannuation |  | 0
 |  |  |  |  |  |  |  |  | Workers Compensation |  | 0
 |  |  |  |  |  |  |  |  | Payroll Tax |  | 0
 |  |  |  |  |  |  |  |  | PLSL |  | 0
 |  |  |  |  |  |  |  |  | Quotation Total |  | 0
Add | BOQ No: | Category | Product | Oty | Unit | Price | Material Total | Labour | Labour Total | Line Total | Est Hours
 |  | Roofing
Add | BOQ No: | Category | Product | Oty | Unit | Price | Material Total | Labour | Labour Total | Line Total | Est Hours
Add | BOQ No: | Catergory | Product | Oty | Unit | Price | Material Total | Labour | Labour Total | Line Total | Est Hours
Add | BOQ No: | Catergory | Product | Oty | Unit | Price | Material Total | Labour | Labour Total | Line Total | Est Hours
 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
 |  |  | Total
Spreadsheet: 848179d1698952906-find-value-multiple-criteria-authersheet
Sheet: Sheet1

 |  |  | Definition of Weights
 |  |  | Author Rank
 |  | Number of authors | 1 | 2 | 3 | 4 | 5
 |  | 1 | 1
 |  | 2 | 0.6 | 0.4
 |  | 3 | 0.4 | 0.35 | 0.25
 |  | 4 | 0.35 | 0.3 | 0.2 | 0.15
 |  | 5 | 0.35 | 0.3 | 0.15 | 0.1 | 0.1
 |  | Author rank
Sno | Author code | Author Position | Total Authors | Publication Year | Journal Category | Quartile | Impact Factor | Citations | Word Count | Effective Publication Score | Effective Word Count
1 | A1 | 1 | 2 |  |  |  |  |  |  | 0.6
2 | A1 | 2 | 2 |  |  |  |  |  |  | 0.35
3 | A1 | 2 | 4 |  |  |  |  |  |  | 0.3
Spreadsheet: 679988d1590727293-counting-cells-only-if-adjacent-cell-is-filled-excel-example
Sheet: Sheet1

Projected Expense Amount | Actual Expense Amount
84.47 | 84.47
1000 | 500
1000 | 1000
250 | 0
539.8 | 539.8 |  |  |  |  |  | Criteria
 | 1300 |  | Criteria-2
2054
50
Projected Expenses to Date | 2124.27
Projected Expense Amount | Actual Expense Amount
84.47 | 84.47
1000 | 500
1000 | 1000
250 | 0
539.8 | 539.8
250 | 1300
2054
50
Projected Expenses to Date | 3424.27 |  | Criteria-1
Spreadsheet: 81687d1281810431-vlookup-shortage-presentation-template-1-
Sheet: Shortages Presentation

DJ | System | Item | Description | QTY | NBD | State | Plan Ship DT | Plan Start DT | Due DT | Prev. Commit | Commit DT | System Comments | Meeting Comments | Actions
1234 | A | 1234-RB | VACCUM | 1 |  |  | 2010-08-17 00:00:00 | 2010-08-05 00:00:00 | 2010-08-04 00:00:00
23132 | B | 15783-FI | TUBE | 1 |  |  | 2010-08-18 00:00:00 | 2010-08-06 00:00:00 | 2010-08-05 00:00:00
13213 | C | 476578CMP | HEATER | 3 |  |  | 2010-08-18 00:00:00 | 2010-08-06 00:00:00 | 2010-08-05 00:00:00
21321 | D | 23876TDK | VACUUM BOLT | 1 |  |  | 2010-08-19 00:00:00 | 2010-08-09 00:00:00 | 2010-08-08 00:00:00
1231 | G | 2387980RB | HEATER BOLT | 2 |  |  | 2010-08-19 00:00:00 | 2010-08-09 00:00:00 | 2010-08-08 00:00:00
21321 | A | 7986875CMP | HT COVER | 1 |  |  | 2010-08-19 00:00:00 | 2010-08-09 00:00:00 | 2010-08-08 00:00:00
213 | M | 23478FI | PROC | 1 |  |  | 2010-08-18 00:00:00 | 2010-08-10 00:00:00 | 2010-08-09 00:00:00
131331 | B | 8645CPI | SWITCH | 1 |  |  | 2010-08-19 00:00:00 | 2010-08-10 00:00:00 | 2010-08-09 00:00:00
13213 | C | 28672RB | FILM | 2 |  |  | 2010-08-18 00:00:00 | 2010-08-06 00:00:00 | 2010-08-05 00:00:00
1323 | M | 0040-1234 | TEMP | 1 |  |  | 2010-08-26 00:00:00 | 2010-08-17 00:00:00 | 2010-08-16 00:00:00
1323 | D | 0040-1235 | COOLER SYS | 1 |  |  | 2010-08-26 00:00:00 | 2010-08-17 00:00:00 | 2010-08-16 00:00:00
Every morning I export shortage report from our database, name it as [NAME], and prepared the shortage presentation every M-W-F for meeting. Right now, I have to cut and paste data from "Today Shortage", "Yesterday Shortage" and "Planning Schedule" to Shortage Presentation. The planning schedule is placed in the server and is mannually updated by the lead person.  All three sheets contain common fields such as "DJ", System", [NAME]", and "Description".  I would like to make a template "Shortages Presentation" that would pull information from Today Shortages, Yesterday Shortages, and Planning Schedule easily.  Would Vlook-up be an idea and how? I appreciate any suggestions you can give me.
Spreadsheet: 208997d1358978890-reorganizing-data-please-help-exforsas
Sheet: Sheet1

Date | IN:MNM | IN:CEC | IN:3II | IN:3MI | IN:EOI
1990-12-05 00:00:00 | NA | 23.33 | NA | 21 | NA
1990-12-06 00:00:00 | NA | 23.33 | NA | NA | 21
1990-12-07 00:00:00 | NA | NA | NA | 3 | NA
1990-12-10 00:00:00 | NA | 24.33 | NA | NA | NA
1990-12-11 00:00:00 | 1 | 24.67 | 12 | NA | 43
Spreadsheet: a389502b-66d3-4979-aaac-f848c311e023
Sheet: 9-12 Sample

MENU - 9-12
Requirements |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Weekly Total MET Yes/No |  |  | Decimal Equivalents
 |  | [NAME] |  | [NAME] |  | [NAME] Fish Nuggets |  | Reduced fat sausage pizza |  | Beef  Taco  Meat |  |  |  |  | 1/8 Cup | 0.125
 |  | [NAME] |  | [NAME] |  | [NAME] |  | with whole wheat crust |  | on [NAME] |  |  |  |  | 1/4 Cup | 0.25
 |  | Sweet Potato Fries |  | Broccoli |  | Mashed Potatoes |  | Romaine Lettuce |  | Salsa |  |  |  |  | 3/8 Cup | 0.375
 |  | [NAME] |  | Carrots |  | Green Beans |  | Sliced tomato |  | [NAME] |  |  |  |  | 1/3 Cup | 0.333
 |  | [NAME] |  | Kiwi |  | Peaches |  | Pineapple |  | Corn |  |  |  |  | 1/2 Cup | 0.5
 |  | Fresh orange |  |  |  | Fresh Apple |  | 1/4 c. raisins |  | Cantaloupe |  |  |  |  | 5/8 Cup | 0.625
 |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  |  |  |  | 2/3 Cup | 0.666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/4 cup | 0.75
Mt/MA (2 oz eq per day)  (10-12 oz eq per week) |  | 3.2 oz USDA  deli turkey, 5 oz cheese |  | 3/4 C teriyaki = 3 oz meat |  | 6 nuggets = 2.25 M/MA and 0.75 G/B |  | 1 sl = 2 oz M/MA and 2 G/B |  | Taco meat |  |  |  |  | 7/8 cup | 0.875
 |  | 2.5 | Oz Eq | 3 | Oz Eq | 2.25 | Oz Eq | 2 | Oz Eq | 2 | Oz Eq
Vegetables (1 Cup per day)    (5 Cups per week) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 cup leafy  greens  = 1/2 cup vegetable
[NAME]  (1/2 Cup per week) |  |  |  | Broccoli (1/2c) |  |  |  | Romaine-1 cup
 |  |  | Cup | 0.5 | Cup |  | Cup | 0.5 | Cup |  | Cup
Red/Orange  (1 1/4 Cup per wk) |  | Sweet Potato Fries |  | Carrots  (1/2 c) |  |  |  | Tomato
 |  | 0.75 | Cup | 0.5 | Cup |  | Cup | 0.5 | Cup |  | Cup |  |  |  | 1/4 cup dried fruit  = 1/2 cup fruit
Beans/Peas (Legumes) (1/2 Cup per week) |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Cup |  | Cup |  | Cup |  | Cup | 0.5 | Cup
Starchy  (1/2 Cup per week) |  |  |  |  |  | Mashed Potatoes |  |  |  | Corn
 |  |  | Cup |  | Cup | 0.5 | Cup |  | Cup | 0.5 | Cup
Other  (3/4 per week) |  | [NAME] |  |  |  | Green Beans |  |  |  | Salsa
 |  | 0.5 | Cup |  | Cup | 0.5 | Cup |  | Cup | 0.25 | Cup
Daily total
Additional Vegetable to reach [NAME] (1 1/2 Cup per week)
Grains(2 oz eq day) (10-12 oz eq per week) |  | [NAME] |  | 1 c. brown rice |  | Breading & 2 oz roll |  | Pizza crust |  | Tortilla
 |  | 2.5 | Oz Eq | 2 | Oz Eq | 2.75 | Oz Eq | 2 | Oz Eq | 1.5 | Oz Eq
Fruits (1 Cup per day) (5cups per week) |  | 1/2 c. strawberries and fresh orange |  | 3 whole  kiwi |  | 1/2 c. peaches and fresh apple |  | 1/2 c. pineapple 1/4 c. raisins |  | 1 c. cantaloupe
 |  | 1 | Cup | 1 | Cup | 1.5 | Cup | 1 | Cup | 1 | Cup
[NAME] (1 Cup per day)  (5 a week) |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 %
 |  | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup
Spreadsheet: 750290d1633369115-simple-index-match-with-three-conditions-returens-ref-when-only-one-cell-schanged-error
Sheet: Schedule - A330-200 - CCC

 |  |  |  | A330-200 - CCC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flight dates
CPT | STN | Sector 1 |  |  | STN | DUR | Sector 2
Dry Operating Weight Weight Kg | 116610.8843537415
[NAME] | 12784.24 |  |  |  | [NAME]
ZFW  Kg | 116610.8843537415 |  |  |  | ZFW  Kg
[NAME] | 69349 |  |  |  | [NAME]
[NAME] | 185959.8843537415 | [NAME] |  |  | [NAME] |  | [NAME]
ZFW Under Load | 53360.02086167801 | 47.00023854875285 |  |  | ZFW Under Load
MLD Weight | 181968.7074829932 |  |  |  | MLD Weight | 181968.7074829932
MAX ZFW | 169970.9052154195 |  |  |  | MAX ZFW | 169970.9052154195
MTOW | 232960.1229024943 |  |  |  | MTOW | 232960.1229024943
Burn Per [NAME] | 5590 |  |  |  |  | 5590
Flight Time | 11:09:06.623000 |  |  |  |  | 11:09:07
 |  |  |  |  | [NAME]
 |  |  |  |  | Contingency
 |  | 69349 |  |  | Alternative |  | 69349
 |  |  |  |  | Reserve
 |  |  |  |  | Taxi
Total Sector Fuel |  |  |  |  | Total Sector Fuel
Block Speed Kt | 470.3023758099352 |  |  |  | Block Speed Kt | 470.3023758099352
Pax & baggage weight [NAME] |  |  |  |  | Pax & baggage weight [NAME]
Male 0.7% | 109 | 9415.42 |  |  | Male % | 109 | 9415.42
Female 0.3% | 91 | 3368.82 |  |  | [NAME] | 91 | 3368.82
Avg pax weight | 74.18181818181817 |  |  |  | Avg pax weight | 74.18181818181817
Trip Passengers | 123.4 | 12784.24 |  |  | Trip Passengers | 123.4 | 12784.24
APS weight | 116610.8843537415 | 1582 |  |  | APS weight
Pilots & Engineer | 4 | 436 |  |  | Pilots & Engineer | 4
Cabin Crew & Equipment | 6 | 546 |  |  | Cabin Crew & Equipment | 6
 |  | 982
Galley | 2 | 600 |  |  | Galley | 2 | 600
Total |  | 1582 |  |  | Total
Aircraft Basic Empty Weight |  | 116610.8843537415 |  |  | Aircraft Basic Empty Weight |  | 116610.8843537415
Spreadsheet: 163351d1340284505-excel-2007-hide-empty-cells-when-plotting-a-graph-dynamic-chart-range
Sheet: Data

 | Calculations
 | Selected Chart Option | Region
 | Data for the chart
 | Year | London | Midlands | North | South | London | East Midlands | East of England | West Midlands | North East | North West | Yorkshire | South Central | South East Coast | South West
 | 2010/2011 | 46704307.29212753 | 50142351.29886874 | 49619394.79394341 | 55403361.00466315 | 46704307.29212753 | 12845499.70187608 | 14990824.85 | 22306026.74699266 | 7688393.465270543 | 26133402.7890979 | 15797598.53957497 | 21001351.99 | 15324286.45 | 19077722.56466315
 | 2011/2012 | 48800844.15600471 | 57315497.70278163 | 50751672.59733258 | 62151668.135717 | 48800844.15600471 | 16532260.47882961 | 18576811.47395201 | 22206425.75 | 8423577.889591439 | 25827768.25774114 | 16500326.45 | 20761504.23571699 | 18373706.9 | 23016457
 | Data for the chart
 |  | Region | Region | Region | Region | Area | Area | Area | Area | Area | Area | Area | Area | Area | Area
 | Year
 | 2010/2011
 | 2011/2012
 | Year | 2010/2011 | 2011/2012 | [NAME]
 | Year | 2010/2011 | 2011/2012
Spreadsheet: 704243d1605460408-sumifs-between-dates-and-times-vendas-online-2020
Sheet: Sales Between Times-Dates

Sales Channel | Date | Hour Lower | Hour Upper | Total | Nº Sales
Fnac | 2020-11-01 00:00:00 | 00:00:00 | 07:00:00
Fnac |  | 07:00:01 | 10:00:00
Fnac |  | 10:00:01 | 13:00:00
Fnac |  | 13:00:01 | 16:00:00
Fnac |  | 16:00:01 | 19:00:00
Fnac |  | 19:00:01 | 22:00:00
Fnac |  | 22:00:01 | 23:59:59
Fnac |  |  |  |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00
[NAME] |  | 00:00:00 | 07:00:00 |  |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00
[NAME] |  | 07:00:01 | 10:00:00 |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00
[NAME] |  | 10:00:01 | 13:00:00 |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00
[NAME] |  | 13:00:01 | 16:00:00 |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00
[NAME] |  | 16:00:01 | 19:00:00 |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00
[NAME] |  | 19:00:01 | 22:00:00 |  |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00
[NAME] |  | 22:00:01 | 23:59:59 |  |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00
Direto |  | 00:00:00 | 07:00:00 |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00
Direto |  | 07:00:01 | 10:00:00 |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
Direto |  | 10:00:01 | 13:00:00
Direto |  | 13:00:01 | 16:00:00
Direto |  | 16:00:01 | 19:00:00
Direto |  | 19:00:01 | 22:00:00
Direto |  | 22:00:01 | 23:59:59
Direto
Outra |  | 00:00:00 | 07:00:00
Outra |  | 07:00:01 | 10:00:00
Outra |  | 10:00:01 | 13:00:00
Outra |  | 13:00:01 | 16:00:00
Outra |  | 16:00:01 | 19:00:00
Outra |  | 19:00:01 | 22:00:00
Outra |  | 22:00:01 | 23:59:59
Outra
Spreadsheet: 218167d1362379812-index-or-vlookup-sample1
Sheet: Sheet2

SUMMARY | TAC
 |  |  | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun
PC Name | CNT | SUM | 2013-03-01 00:00:00 | 2013-03-02 00:00:00 | 2013-03-03 00:00:00 | 2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00 | 2013-03-07 00:00:00 | 2013-03-08 00:00:00 | 2013-03-09 00:00:00 | 2013-03-10 00:00:00 | 2013-03-11 00:00:00 | 2013-03-12 00:00:00 | 2013-03-13 00:00:00 | 2013-03-14 00:00:00 | 2013-03-15 00:00:00 | 2013-03-16 00:00:00 | 2013-03-17 00:00:00 | 2013-03-18 00:00:00 | 2013-03-19 00:00:00 | 2013-03-20 00:00:00 | 2013-03-21 00:00:00 | 2013-03-22 00:00:00 | 2013-03-23 00:00:00 | 2013-03-24 00:00:00 | 2013-03-25 00:00:00 | 2013-03-26 00:00:00 | 2013-03-27 00:00:00 | 2013-03-28 00:00:00 | 2013-03-29 00:00:00 | 2013-03-30 00:00:00 | 2013-03-31 00:00:00
Sample 1 | 0 | 0 | 0.0256 | 0 | 0 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 3 | 0 | 0.01 | 0 | 0 | 0.01 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 5 | 0 | 0.01 | 0.01 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sample 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 492317d1481033080-conditional-formatting-formula-forum-file1
Sheet: DASH H

 | P R A T A P   K U M A R   K
 | MODE | OPENING | DEBIT | CREDIT | CLOSING
 | CASH | 3782
 | SBI | 6811.87
 | IB | 10300.71
 | GRAND CLOSING
 | PARTY | OPENING | BALANCE
 | RAMBABU | 0
 | VARA LAKSHMI | -8581
 | ESWAR | 0
 | VASU | 0
 | BAVA | 0
 | CASH | 0
 | IB | 0
 | SBI | 0
 | DANIEL | 0
 | ESWAR | 0
 | MD NAGARAJU | -30
 | MRF | 0
 | NAGARAMESH | 0
 | PHONEPE | 0
 | POORI | 0
 | RAMBABU YS | 0
 | SADAR | 0
 | SUBBALAKSHMI M | 0
 | PRIVATE | 0
 | BETA | 0
 | NANI BAVA | 0
Spreadsheet: 18ce0a06-a0c7-4c1d-9466-394032a71762
Sheet: Sheet1

Lifetime Prescription Drug Misuse Among Middle School Students, by Selected Demographics,  Maine, 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Weighted  Number |  | % |  | 95% CI
Maine Total 2011 |  | 1712 |  | 6.4 |  | 6.0 - 6.8
Maine Total 2009 |  |  |  | 9.1 |  | 8.6 - 9.6
Gender
 | Male | 918 |  | 6.9 |  | 6.3 - 7.5
 | Female | 761 |  | 5.9 |  | 5.4 - 6.3
Race **
 | American Indian or [NAME] | 36 |  | 8.7 |  | 6.9 - 10.4
 | Asian | 12 |  | 7.2 |  | 4.3 - 10.1
 | Black or African American | 27 |  | 12.2 |  | 7.9 - 16.5
 | Hispanic | 70 |  | 17.4 |  | 14.4 - 20.3
 | Native Hawaiian or Other Pacific Islander | 4 |  | 10.2 |  | 3.7 - 16.6
 | White | 1314 |  | 5.9 |  | 5.4 - 6.3
 | Multiple races | 45 |  | 10.3 |  | 8.3 - 12.3
County
 | Androscoggin | 129 |  | 6.6 |  | 5.4 - 7.8
 | Aroostook | 84 |  | 5.6 |  | 4.5 - 6.8
 | Cumberland | 338 |  | 6.3 |  | 5.0 - 7.5
 | Franklin | ^ |  | ^ |  | ^
 | Hancock | 61 |  | 6.4 |  | 4.8 - 8.0
 | Kennebec | 152 |  | 6.1 |  | 5.1 - 7.1
 | Knox | 46 |  | 7.7 |  | 5.9 - 9.6
 | Lincoln | 42 |  | 5.6 |  | 2.8 - 8.5
 | Oxford | 103 |  | 7.3 |  | 6.5 - 8.1
 | [NAME] | 178 |  | 6.2 |  | 4.7 - 7.6
 | Piscataquis | 22 |  | 5.7 |  | 3.4 - 8.0
 | Sagadahoc | 56 |  | 7.8 |  | 4.4 - 11.2
 | Somerset | 77 |  | 5.7 |  | 4.1 - 7.2
 | [NAME] | 60 |  | 8.4 |  | 6.9 - 9.9
 | Washington | 22 |  | 3.7 |  | 1.4 - 5.9
 | York | 305 |  | 7 |  | 6.3 - 7.6
Public Health District
 | Aroostook | 84 |  | 5.6 |  | 4.5 - 6.8
 | Central | 229 |  | 5.9 |  | 5.1 - 6.8
 | Cumberland | 338 |  | 6.3 |  | 5.0 - 7.5
 | Downeast | 85 |  | 5.5 |  | 4.1 - 6.9
 | [NAME] | 209 |  | 7.6 |  | 6.2 - 8.9
 | Penquis | 201 |  | 6.1 |  | 4.9 - 7.4
 | Western | 266 |  | 6.7 |  | 6.0 - 7.5
 | York | 305 |  | 7 |  | 6.3 - 7.6
Data Source:  Maine Integrated Youth Health Survey. Middle school survey includes 7th and 8th grades. Based on students who reported having ever taken a prescription drug without a doctor's permission All percentagess are weighted to be more representative of the population of Maine students and to adjust for non-response.  95% CI = 95% Confidence Interval. ** All racial categories are non-Hispanic except for "Hispanic." ^ Results are not reported because weighted data are not available due to low response rates.
Spreadsheet: 84692f9c-4a88-42c7-9a73-5a7b2f77898c
Sheet: WPR

 |  | Diet and Physical Activity for the Prevention of Non Communicable Diseases in Low and Middle-Income Countries: A Systematic Policy Review
 |  | Lachat et al. Plosmed
 |  | Table S1: Availability of national policy documents and strategies for NCD prevention in low- and middle- income countries by WHO region
 |  | Western Pacific Region
 |  | Short name | Full name | Classification | WHO region | Policy status assessed | County with policy elibigle for review | Reason for exclusion from review | Language | Type of policy | Classification code | NCD Strategies
 |  |  |  |  |  |  |  |  |  |  |  | Salt | Fat | FV | PA | Number of strategies
 | 1 | Cambodia | the Kingdom of Cambodia | Low income | WPR | yes | yes |  | English | NCD | 4 | yes | yes | yes | yes
 | 2 | China | the People’s Republic of China | Lower middle income | WPR | yes | yes |  | Chinese/English | NCD | 4 | yes | yes |  | yes
 | 3 | Fiji | the Republic of Fiji | Upper middle income | WPR | yes | yes |  | English | NP | 4 |  |  | yes
 | 4 | Kiribati | Republic of Kiribati | Lower middle income | WPR | yes | no | Published before 2004 |  |  | 2
 | 5 | Lao PDR | the Lao People’s Democratic Republic | Low income | WPR | yes | yes |  | English | NP | 3
 | 6 | Malaysia | Malaysia | Upper middle income | WPR | yes | yes |  | English | NP | 4 | yes | yes | yes | yes
 | 7 | Marshall Islands | Republic of the Marshall Islands | Lower middle income | WPR | no |  |  |  |  | 1
 | 8 | Micronesia, Fed. [NAME]. | Federated States of [NAME] | Lower middle income | WPR | no |  |  |  |  | 1
 | 9 | Mongolia | Mongolia | Lower middle income | WPR | yes | yes |  | English | NCD | 4 | yes | yes | yes | yes
 | 10 | Palau | Republic of Palau | Upper middle income | WPR | no |  |  |  |  | 1
 | 11 | [NAME] | [NAME] | Lower middle income | WPR | yes | no | Published before 2004 |  |  | 2
 | 12 | Philippines | the Republic of the Philippines | Lower middle income | WPR | yes | yes |  | English | NCD | 4 | yes | yes | yes | yes
 | 13 | Samoa | the Independent State of Samoa | Lower middle income | WPR | yes | yes |  | English | HP | 4 |  |  | yes | yes
 | 14 | Solomon Islands | Solomon Islands | Low income | WPR | yes | yes |  | English | HP | 4 |  |  |  | yes
 | 15 | Tonga | Kingdom of Tonga | Lower middle income | WPR | no |  |  |  |  | 1
 | 16 | Tuvalu | Tuvalu | Lower middle income | WPR | yes | no | Policy not officially endorsed |  |  | 2
 | 17 | [NAME] | [NAME] | Lower middle income | WPR | yes | no | Published before 2004 |  |  | 2
 | 18 | Vietnam | the Socialist Republic of Viet Nam | Lower middle income | WPR | yes | yes |  | English | NP | 4 |  |  | yes | yes