tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 90999d1290683439-shift-range-down-by-x-amount-of-rows-shift-rows-ex
Sheet: Source Data

Account | Product | Week | Account Manager
abc123 | 123456 | 47 | Rita
abc246 | 456789 | 47 | [NAME]
zyx123 | 789123 | 46 | Sue
[NAME] | 753159 | 46 | Too
Spreadsheet: darrell_schoolcraft__7310__imball0201
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 898267 | 890978
78311 | 332066 | 329852 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 740969 | 812467 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 831402 | 767781
500293 | 503405 | 560521
500302 |  | 8562
500303 |  | 286966
500305 | 1443798 | 1344603
500307 | 86050 | 34048
500313 |  | 1616
500314
500655 | 205458
500657 | 149053 | 189988
INDEX
2001-12-31 00:00:00 |  |  | 40609.26
2002-01-28 00:00:00
CBS Volume
 |  |  | 31706
Spreadsheet: 477145d1472146395-formula-to-add-row-data-if-blank-then-data-from-different-sheet-with-reference-criteria-sumofthings
Sheet: Plan

 |  | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | C Holcom | 40.5 | 81 | 162 | 270 | 607.5 | 810 | 1728 | 162 | 162 | 270 | 432 | 1890
 | A Ivanson | 54 | 162 | 270 | 432 | 1080 | 1728 | 1728 | 229.5 | 229.5 | 378 | 540 | 1890
 | B Risuto | 54 | 229.5 | 378 | 540 | 1215 | 1890 | 1728 | 162 | 162 | 270 | 432 | 1890
 | M Franklin | 54 | 229.5 | 378 | 540 | 1215 | 1890 | 1728 | 229.5 | 229.5 | 378 | 540 | 1890
Spreadsheet: 135957d1326326288-how-to-use-sumif-over-multiple-worksheets-book1
Sheet: Sheet3

 |  |  | Sumif | 13 |  | 4 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 5 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 5 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 5 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 5 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 5 |  |  | 1
 |  |  |  |  |  | 5 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 5 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 5 |  |  | 1
 |  |  |  |  |  | 4 |  |  | 1
 |  |  |  |  |  | 2 |  |  | 1
 |  |  |  |  |  | 5 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 3 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  | 5 |  |  | 1
 |  |  |  |  |  | 5 |  |  | 1
 |  |  |  |  |  | 5 |  |  | 1
 |  |  |  |  |  | 5 |  |  | 1
Spreadsheet: 786869d1657523708-formula-should-take-range-from-cells-for-selection-in-a-column-difference-within-a-range
Sheet: Sheet1

 |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  | [NAME] Column G
 |  |  |  |  |  |  | Values to Compare | Expected Results |  | [NAME] From this Row# | Sequence Ends on this Row#
 |  |  |  |  |  | 10 | 10 |  |  | 6 | 15
 |  |  |  |  |  | 11 | 11 |  |  | 7 | 15
 |  |  |  |  |  | 9 | 9 |  |  | 8 | 15
 |  |  |  |  |  | 12
 |  |  |  |  |  | 11
 |  |  |  |  |  | 8
 |  |  |  |  |  | 8
 |  |  |  |  |  | 13
 |  |  |  |  |  | 9
 |  |  |  |  |  | 10
 |  |  |  |  |  | 7
 |  |  |  |  |  | 5
Spreadsheet: 328316d1403870081-multiple-true-statements-but-need-one-to-override-the-other-example-workbook-for-forum-jacc2
Sheet: TEKNE CUTTING SHEET Jacc2 Table

ITEM | [NAME] | QTY | LENGTH | WIDTH | THKNS | MATERIAL | P/S | COMMENTS | L+ | W+ | THK+ | LENGTH2 | WIDTH3 | THK | LENGTH4 | WIDTH5 | THKNS6
1 | PANEL 1 | 1 | 500 | 44 | 18 | MDF |  |  |  |  |  |  |  |  |  |  |  |  | After Material Name
2 | TIE RAIL S/WOOD | 1 | 500 | 44 | 19 | SOFTWOOD
3 | PANEL 1 EDGING | 1 | 500 | 18 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | < = Adds 100mm  TO LENGTH
4 | Oak post | 1 | 500 | 44 |  | oak |  |  |  |  |  |  |  |  |  |  |  |  | > = For tennons this adds 2x material width & rounds up to the nearest 100mm TO LENGTH
5 | worktop | 1 | 500 | 44 |  | zebrano >
6 | door lipping | 1 | 500 | 42 | 3 | poplar
7 | oak edging | 1 | 500 | 44 |  | oak
8 |  | 1 | 500 | 44
9 |  | 1 | 500 | 44
10 |  | 1 | 500 | 44
11 |  | 1 | 500 | 44
12 |  | 1 | 500 | 44
13 |  | 1 | 500 | 44
14 |  | 1 | 500 | 44
15 |  | 1 | 500 | 44
16 |  | 1 | 500 | 44
Spreadsheet: 842404d1694499320-formula-to-determine-of-years-with-a-purchase-for-each-customer-count-of-years-purchasing
Sheet: Sheet1

PersonID | FirstName | PurchaseDate | Price | #YrsWithPurchase
235 | [NAME] | 2005-06-15 00:00:00 | 86 | 1
234 | Amber | 2005-06-15 00:00:00 | 212 | 1
235 | [NAME] | 2006-06-21 00:00:00 | 20 | 2
234 | Amber | 2006-06-21 00:00:00 | 43 | 2
235 | [NAME] | 2007-05-18 00:00:00 | 195 | 3
234 | Amber | 2007-05-18 00:00:00 | 98 | 3
123 | [NAME] | 2008-11-21 00:00:00 | 27 | 1
124 | Bettie | 2008-11-21 00:00:00 | 48 | 1
123 | [NAME] | 2008-12-15 00:00:00 | 127 | 1
124 | Bettie | 2008-12-15 00:00:00 | 228 | 1
235 | [NAME] | 2009-06-21 00:00:00 | 68 | 4
234 | Amber | 2009-06-21 00:00:00 | 194 | 4
123 | [NAME] | 2010-03-15 00:00:00 | 18 | 2
124 | Bettie | 2010-03-15 00:00:00 | 81 | 2
235 | [NAME] | 2010-05-18 00:00:00 | 161 | 5
234 | Amber | 2010-05-18 00:00:00 | 198 | 5
123 | [NAME] | 2011-04-21 00:00:00 | 228 | 3
124 | Bettie | 2011-04-21 00:00:00 | 85 | 3
235 | [NAME] | 2012-04-15 00:00:00 | 154 | 6
234 | Amber | 2012-04-15 00:00:00 | 118 | 6
123 | [NAME] | 2012-05-15 00:00:00 | 199 | 4
124 | Bettie | 2012-05-15 00:00:00 | 84 | 4
235 | [NAME] | 2013-04-25 00:00:00 | 88 | 7
234 | Amber | 2013-04-25 00:00:00 | 43 | 7
235 | [NAME] | 2014-04-18 00:00:00 | 37 | 8
234 | Amber | 2014-04-18 00:00:00 | 153 | 8
123 | [NAME] | 2016-05-21 00:00:00 | 107 | 5
124 | Bettie | 2016-05-21 00:00:00 | 25 | 5
Spreadsheet: 103138d1300936888-sumproduct-and-wildcard-characters-example
Sheet: Sheet3

Unit | Settlement
ICU | Apr
Emerge | Apr
Pysch | Refused
ICU | May
Rehab | Apr
Emerge | Cancelled
ICU | Jun
ICu | Cancelled
Emerge | May
ICU | Refused
Pysch | Jun
ICU | Cancelled
 |  |  |  | Settlements | Cancellations | Refusals
 |  |  | ICU | 0 | 2 | 1
 |  |  | Emerge | 0 | 1 | 0
 |  |  | Pysch | 0 | 0 | 1
 |  |  | Rehab | 0 | 0 | 0
Spreadsheet: 819390d1677488067-unique-filter-formula-automatically-getting-converted-into-an-array-formula-in-o365-test_file_forum_2
Sheet: SUMMARY

Viewing Count By | Monthly Summary
 | Total user feedbacks received: |  |  | Pages with total feedbacks
 | Organizations:
 | [NAME]:
 | Rated Very Happy 😃:
 | Rated Happy 🙂:
 | Rated Neutral 😐:
 | Rated Sad 🙁:
 | Rated Very Sad 😫:
Please visit 2nd and 3rd tab for the feedback details.
Spreadsheet: 704553d1605621964-unique-formula-with-several-columns-excel-question-123567
Sheet: Sheet1

 |  | A | B |  |  |  | FORMULA
 |  | 1 | 1 |  |  |  |  | 1
 |  | 1 | 1 |  | 2 |  | 1 | 12 |  | 12
 |  | 1 | 1 |  | 3 |  | 2 | 2 |  | 2
 |  | 1 | 12 |  | 5 |  | 2 | 3 |  | 3
 |  | 2 | 2 |  | 12 |  | 23 | 3 |  | 23
 |  | 2 | 2 |  | 23 |  | 5 | 3 |  | 5
 |  | 2 | 3
 |  | 23 | 3
 |  | 5 | 3
 |  | 5 | 3
 |  | 5 | 3
 |  | 5 | 3
 |  | 5 | 3
 |  | 5 | 3
Spreadsheet: 771212d1646514968-sort-filter-data-based-on-id-number-and-date-entered-closest-to-end-of-month-test_data_02_a
Sheet: Sheet1

Date | ID Number | Amount | Timestamp
2021-01-13 00:00:00 | 12 | 900 | 2021-01-13 00:00:00
2021-01-14 00:00:00 | 12 | 42 | 2021-01-14 00:00:00
2021-01-15 00:00:00 | 12 | 99 | 2021-01-15 00:00:00
2022-02-02 00:00:00 | 12 | 108 | 2022-02-02 00:00:00
2022-02-03 00:00:00 | 12 | 50 | 2022-02-03 00:00:00
2022-02-04 00:00:00 | 12 | 63 | 2022-02-04 00:00:00
2022-01-02 00:00:00 | 67 | 525 | 2022-01-02 00:00:00
2022-01-03 00:00:00 | 67 | 584 | 2022-01-03 00:00:00
2022-01-30 00:00:00 | 67 | 777 | 2022-01-30 00:00:00
2022-01-27 00:00:00 | 67 | 50 | 2022-01-27 00:00:00
2022-01-24 00:00:00 | 67 | 25 | 2022-01-24 00:00:00
2022-02-01 00:00:00 | 67 | 22 | 2022-02-01 00:00:00
2022-02-04 00:00:00 | 67 | 13 | 2022-02-04 00:00:00
2022-02-05 00:00:00 | 67 | 218 | 2022-02-05 00:00:00
2022-03-01 00:00:00 | 67 | 5 | 2022-03-01 00:00:00
2022-02-18 00:00:00 | 67 | 18 | 2022-02-18 00:00:00
Spreadsheet: 472468d1469612901-productivity-depending-on-different-type-of-work-test-6-
Sheet: Table

Week n: | 31 |  | Days: | 2
 |  |  |  |  |  |  | 2:20:00 | 1:00:00 | 1:10:00 | 3:30:00 | 4:40:00 | 1:30:00
Name | Days Per Week | Hours Per Day | Actual Time | Actual Available Days | PRODUCTIVITY | Work Type 1 | Work Type 2 | Work Type 3 | Work Type 4 | Work Type 5 | Work Type 6 | Work Type 7
Employee 1 | 5 | 7.5
Employee 2 | 5 | 7.5
Employee 3 | 3 | 7.5
Employee 4 | 4 | 7.5
Employee 5 | 5 | 7.5
Employee 6 | 5 | 4
Spreadsheet: 186924d1350300000-data-validation-searching-problem-in-and-out-details
Sheet: Sheet2

Row Labels | Sum of Qty
BREAST B/L S/L (COPAGRILL)-AQF | 350
CHICKEN GRILLER-1000-NAT-RN | 100
[NAME] | 230
CHICKEN GRILLER-900-NAT-RN | 50
CHICKEN LIVER-9KG-NAT-RN | 25
CHICKEN SHAWARMA-10KG-NAT-RN | 50
CHICKEN WINGS 3 JOINT-1x15xKG-CARRER-ADM | 80
CKN BREAST-12KG-TYSON-RN | 25
LAMB FORES-1x1KG-ALLIANCE-RN | 4
RIB FISH 10UP-10KG-CRYSTAL-OCEAN | 152
RIB FISH 5/7-10KG-CRYSTAL-OCEAN | 7
RIB FISH 7/10-10KG-CRYSTAL-OCEAN | 302
RIB FISH H/L 1000UP-10KG-OCEAN | 16
RIB FISH H/L 5/7-10KG-OCEAN | 283
RIB FISH H/L 7/10-10KG-OCEAN | 102
RIB FISH WHOLE-3/5-10KG-CRYSTAL | 1
RIBBON FISH MIX-OCEAN | 60
(blank)
Grand Total | 1837
Spreadsheet: 726601d1617310689-counting-number-of-times-mentioned-fruit-company
Sheet: Sheet1

 |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 | Total |  | Apple | [NAME] | Apple |  | Orange | Apple | Apple
Apple | 4 |  | Orange | Grapes
Orange | 3 |  |  | Orange
Grapes | 1
[NAME] | 1
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 4

 | January 3 | January 10 | January 17 | January 24 | January 31
Total Interest Rate* | 21434 | 58219 | 45331 | 42518 | 34267
SDs and MSPs** | 10286 | 32725 | 24855 | 21695 | 15181
Other | 11148 | 25494 | 20476 | 20823 | 19086
Total Cross-Currency | 894 | 2714 | 2964 | 3176 | 1012
SDs and MSPs | 551 | 2112 | 2355 | 2092 | 684
Other | 343 | 602 | 609 | 1084 | 328
Total Credit | 6716 | 13600 | 13618 | 14865 | 23803
SDs and MSPs | 3390 | 7638 | 7461 | 7199 | 12421
Other | 3326 | 5962 | 6157 | 7666 | 11382
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 29044 | 74533 | 61913 | 60559 | 59082
Weekly total, swap ticket volumes by asset class and participant type (number of new trades), all products and tenors, cleared and uncleared. For cleared swaps, the creation of each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, each trade is attributed to both swap counterparties. All price-forming trade events, including new trades, terminations, amendments, and novations, are included in ticket volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Ticket Volume by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type 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: 89207d1288959236-conditional-formatting-comparing-value-to-previous-cell-in-column-formatting-example
Sheet: Sheet1

 | Reading 1 | Reading 2 | Mean
2007-02-01 00:00:00 | 184.45 | 184.46
2007-05-01 00:00:00 | 515.43 | 516.02
2008-04-01 00:00:00 | 179.17 | 179.13
2008-12-01 00:00:00 | 201.28 | 201.21
2008-08-12 00:00:00 | 180.7 | 180.74
2008-12-01 00:00:00 | 590.21 | 590.62
2009-04-01 00:00:00 | 622.98 | 623.53
2009-08-01 00:00:00 | 497.52 | 496.84
2009-12-01 00:00:00 | 254.59 | 254.53
2009-12-01 00:00:00 | 123.83 | 124.44
2010-04-01 00:00:00 | 123.07 | 123.67
2010-04-24 00:00:00 | 576.43 | 577.7
2010-05-05 00:00:00 | 645.06 | 644.83
Spreadsheet: 45446d1244175797-if-statement-simplification-inv97-03
Sheet: eBay Fees

 |  |  | CODE | CATEGORY |  | LISTING FEE | CLOSING FEE | > $50.00 | > $1000.00 | > $3000.00
 |  |  | ELCTR | Consumer Electronics, Video Game Systems, Cameras & Photo |  | 0.35 | 0.08 | 0.045 | 0.01 | 0
 |  |  | COMP | Computers & Networking |  | 0.35 | 0.06 | 0.0375 | 0.01 | 0
 |  |  | CLOTH | Clothing, Shoes & Accessories |  | 0.35 | 0.12 | 0.09 | 0.02 | 0
 |  |  | MEDIA | Books, Music, DVDs & Movies, Video Games |  | 0.15 | 0.15 | 0.05 | 0.02 | 0
 |  |  | OTHER | All other categories |  | 0.35 | 0.12 | 0.06 | 0.02 | 0
 |  |  |  | PayPal |  | 0.3 | 0.029 | 0 | 0 | -0.004
Spreadsheet: 576401d1528090695-min-and-max-max-and-min
Sheet: Sheet1

Before :- |  |  |  |  |  |  |  | After :-
Country | Ref |  |  |  |  |  |  | Country | Start | End
India | A1 |  |  |  |  |  |  | India | A1 | A5
Israel | B1 |  |  |  |  |  |  | Israel | B1 | B5
Hong Kong | C1 |  |  |  |  |  |  | Hong Kong | C1 | C5
India | A2
Israel | B2
Hong Kong | C2
India | A3
Israel | B3
Hong Kong | [NAME]
India | A4
Israel | B4
Hong Kong | C4
India | A5
Israel | B5
Hong Kong | C5
Spreadsheet: 55686d1255834067-racing-leader-board-leaderboard
Sheet: leaderboard

overall standings | driver name | points
1 | driver 12 | 18
2 | driver 19 | 13
3 | driver 2 | 10
4 | driver 8 | 10
5 | driver 11 | 10
6 | driver 15 | 9
7 | driver 13 | 8
8 | driver 9 | 7
9 | driver 10 | 7
10 | driver 20 | 6
11 | driver 5 | 4
12 | driver 6 | 4
13 | driver 3 | 3
14 | driver 17 | 3
15 | driver 7 | 2
16 | driver 14 | 2
17 | driver 1 | 1
18 | driver 4 | 0
19 | driver 16 | 0
20 | driver 18 | 0
Spreadsheet: 0dbb2607-e853-4c8c-9b67-deadf350e64f
Sheet: 통계표6

6. OECD국가의 [NAME])
 |  |  |  |  |  |  |  |  | (단위: OECD 표준인구 10만명당)
 | 연도 | 전체 | 암 (악성신생물) |  | 당뇨병 | 뇌혈관 질환 | 만성 간질환 | 육상운수사고 (교통사고) | 자살
 |  |  |  | 폐암
한국 | 2010 | 778.6 | 193.7 | 43.5 | 31.1 | 86 | 13.7 | 15.3 | 33.5
 | 2009 | 783.7 | 193.8 | 43 | 30.4 | 87.8 | 14 | 16.5 | 33.8
 | 2008 | 825.2 | 199.5 | 44.6 | 33.3 | 99.6 | 15.3 | 17.2 | 29
 | 2007 | 865.2 | 203.6 | 45 | 38.1 | 109.5 | 16.3 | 18.6 | 28.7
 | 2006 | 897.7 | 204.1 | 45.9 | 39.9 | 116.3 | 17.5 | 19.9 | 26.2
호주 | 2010 | 678.2 | 201.7 | 38.8 | 18.8 | 53 | 5.2 | 6.7 | 10.6
오스트리아 | 2010 | 785.5 | 203.5 | 38.2 | 30.2 | 51.3 | 15.7 | 6.6 | 13.9
벨기에 | 2006 | 859.4 | 220.9 | 54.4 | 13.7 | 63.6 | 10 | 10.4 | 17.7
캐나다 | 2009 | 714.1 | 213.6 | 57.7 | 20.9 | 42.6 | 7.7 | 7.7 | 11.1
칠레 | 2009 | 848.3 | 206.5 | 23 | 31.3 | 80.6 | 24.4 | 14.4 | 13.3
체코 | 2010 | 1026.3 | 250.3 | 48.1 | 18.6 | 117 | 16.8 | 8.4 | 13.5
덴마크 | 2006 | 967.2 | 271.9 | 65.6 | 22.7 | 81.3 | 15.3 | 6.2 | 11.6
에스토니아 | 2010 | 1089.7 | 236.3 | 42 | 10.3 | 92.9 | 19.6 | 7 | 15.8
핀란드 | 2010 | 815.4 | 182.5 | 34.4 | 7.3 | 67.4 | 19.3 | 6.4 | 17.3
프랑스 | 2009 | 713.4 | 213.3 | 42.9 | 14.6 | 40.8 | 11.1 | 7.2 | 16.2
독일 | 2010 | 811.1 | 206 | 40.7 | 21.5 | 57.2 | 14.2 | 4.7 | 10.8
그리스 | 2009 | 850 | 203.3 | 47.2 | 7.8 | 123 | 6.2 | 14.2 | 3.2
헝가리 | 2009 | 1231.5 | 295.5 | 75.6 | 24.5 | 135.2 | 43.8 | 10.7 | 23.3
[NAME] | 2009 | 749.3 | 209.3 | 49.5 | 10.2 | 60.3 | 2.2 | 4.2 | 11.8
아일랜드 | 2010 | 775.4 | 221.7 | 45.8 | 14.5 | 60.5 | 7.3 | 4.3 | 11
이스라엘 | 2009 | 719.9 | 186.2 | 30.4 | 45.6 | 41 | 5.1 | 5.8 | 6.2
이탈리아 | 2009 | 723.2 | 210.6 | 42.4 | 25 | 74.9 | 10.8 | 7.9 | 5.9
일본 | 2010 | 622.4 | 186.1 | 36 | 7.4 | 62.7 | 7.7 | 4.8 | 21.2
룩셈부르크 | 2009 | 785.3 | 218.5 | 48.9 | 8.8 | 75.1 | 11.8 | 9.4 | 11.3
멕시코 | 2010 | 1019.5 | 121 | 12.6 | 152.1 | 66.6 | 39.8 | 17.5 | 4.8
네덜란드 | 2010 | 789.5 | 240.1 | 57.3 | 17.4 | 51.8 | 4.3 | 4.3 | 9.2
뉴질랜드 | 2008 | 801.1 | 228.2 | 44 | 23.9 | 73.5 | 3.7 | 11.4 | 12.4
노르웨이 | 2010 | 774.9 | 212.7 | 43.1 | 13.1 | 58 | 4.1 | 5.4 | 11.2
폴랜드 | 2010 | 1058.7 | 245.1 | 57.9 | 18.1 | 101.6 | 15.6 | 11.5 | 15.9
포르투갈 | 2010 | 870.3 | 202 | 29.5 | 37.7 | 117.2 | 11.3 | 8.9 | 9.3
[NAME] | 2010 | 1188.5 | 247.2 | 42 | 14.2 | 136.7 | 24.8 | 9.3 | 11.3
슬로베니아 | 2010 | 851.7 | 257.3 | 48.3 | 11.2 | 91.6 | 26.6 | 7.9 | 18.6
스페인 | 2010 | 704.2 | 197.5 | 40.8 | 17.6 | 54 | 9.6 | 5.4 | 6.3
스웨덴 | 2010 | 757 | 189.1 | 31.7 | 16.1 | 61.4 | 5.5 | 3.2 | 11.7
스위스 | 2007 | 712.5 | 190.6 | 36.3 | 16.5 | 47.1 | .. | 5.4 | 16.9
영국 | 2010 | 795.8 | 227 | 50.4 | 8.7 | 68.3 | 11.5 | 3.6 | 6.7
미국 | 2008 | 868 | 203.1 | 57.8 | 25.2 | 47.1 | 10.3 | 14.2 | 12
* 출처: OECD Health Data 2012
OECD Health Data 2012부터 2010년 총 OECD 인구를 기준인구로 사용
이전에는 1980년 총 OECD 인구를 기준인구로 사용
Spreadsheet: 599691d1543254731-copy-cell-if-cells-in-a-range-contain-specific-text-vba-for-columns-ans
Sheet: Sheet1

DATE | CLIENT | HOURS | STAFF |  |  |  |  |  | TIME | EACH
2018-11-27 00:00:00 | STEVE | 2:00:00 | DM | KJ |  |  |  |  |  |  |  |  |  | DM |  |  |  | KJ |  |  |  | RL |  |  |  | DM |  |  |  | SM
2018-11-27 00:00:00 | JULIE | 6:00:00 | RL | LH |  |  |  |  |  |  |  |  |  | DAY | CLIENT | HOURS |  | DAY | CLIENT | HOURS |  | DAY | CLIENT | HOURS |  | DAY | CLIENT | HOURS |  | DAY | CLIENT | HOURS
2018-11-27 00:00:00 | JO | 2:00:00 | RL | LH |  |  |  |  |  |  |  |  |  | TUES | STEVE | 1
2018-11-27 00:00:00 | DANNY | 2:30:00 | SM |  |  |  |  |  |  |  |  |  |  | TUES | SFA | 2.5
2018-11-27 00:00:00 | MARY | 2:00:00 | SM |  |  |  |  |  |  |  |  |  |  | TUES | CCA | 2
2018-11-27 00:00:00 | [NAME] | 3:00:00 | SM | LB |  |  |  |  |  |  |  |  |  | WED | DAVE | 1.25
2018-11-27 00:00:00 | R&R'S | 2:30:00 | TB |  |  |  |  |  |  |  |  |  |  | WED | LESLEY | 2
2018-11-27 00:00:00 | SFA | 2:30:00 | DM |  |  |  |  |  |  |  |  |  |  | WED | KIRSTY | 1.25
2018-11-27 00:00:00 | CCA | 2:00:00 | DM
2018-11-27 00:00:00 | SARAH | 3:00:00 | LB
2018-11-27 00:00:00 | LAURA | 3:00:00 | LB
2018-11-27 00:00:00 | [NAME] | 2:00:00 | LH
2018-11-27 00:00:00 | SYLVIA | 2:00:00 | RL
2018-11-27 00:00:00 | ALEX | 4:00:00 | TB | LH | SM
2018-11-27 00:00:00 | JUSTIN | 1:30:00 | RL
2018-11-28 00:00:00 | DAVE | 2:30:00 | KJ | DM
2018-11-28 00:00:00 | [NAME] | 2:30:00 | RL | LH
2018-11-28 00:00:00 | SHIRLEY | 2:00:00 | RL
2018-11-28 00:00:00 | ALAN | 3:00:00 | SM
2018-11-28 00:00:00 | BOB | 3:00:00 | SM
2018-11-28 00:00:00 | REBECCA | 2:00:00 | LB
2018-11-28 00:00:00 | SARA | 2:00:00 | TB
2018-11-28 00:00:00 | LESLEY | 2:00:00 | DM
2018-11-28 00:00:00 | KIRSTY | 2:30:00 | DM | LB
2018-11-28 00:00:00 | OWEN | 2:00:00 | LB
2018-11-28 00:00:00 | MADDIE | 3:00:00 | LB
2018-11-28 00:00:00 | DAWN | 2:00:00 | TK
2018-11-28 00:00:00 | EMMA | 6:00:00 | RL
2018-11-28 00:00:00 | DAN | 2:30:00 | TB | SM
2018-11-28 00:00:00 | [NAME] | 2:30:00 | RL
Spreadsheet: 783297d1654710975-filter-instead-of-index-and-small-sample
Sheet: GivenTable

Date | Time | Courses / Classrooms | 10A | 11A | 10B | 11B | 10C
2020-11-04 00:00:00 | 12:00:00 | Literature | Name1 | Name4 | [NAME] | Name7 | Name11
2020-11-05 00:00:00 | 12:00:00 | German | [NAME] | Name5 | Name9 | Name1 | Name12
2020-11-06 00:00:00 | 12:00:00 | Biology | Name3 | Name6 | Name4 | Name10 | Name7
2020-11-11 00:00:00 | 12:00:00 | Chemistry | Name1 | Name4 | [NAME] | Name7 | Name11
2020-11-12 00:00:00 | 12:00:00 | English | [NAME] | Name5 | Name1 | Name9 | Name12
2020-11-13 00:00:00 | 10:30:00 | Geografy | Name3 | Name6 | Name4 | Name10 | Name7
2020-11-25 00:00:00 | 12:00:00 | Physics | Name1 | Name4 | [NAME] | Name7 | Name11
2020-11-26 00:00:00 | 12:00:00 | History | [NAME] | Name5 | Name1 | Name9 | Name12
2020-11-27 00:00:00 | 12:00:00 | Math | Name3 | Name6 | Name4 | Name10 | Name7
2020-11-27 00:00:00 | 12:40:00 | Art | Name3 | Name6 | Name4 | Name10 | Name7
2020-12-02 00:00:00 | 12:00:00 | Geometry | Name11 | Name4 | [NAME] | Name7 | Name1
2020-12-04 00:00:00 | 12:00:00 | Drama | Name3 | Name6 | Name4 | Name10 | Name7
Spreadsheet: 714788d1611371237-how-to-find-offset-of-value-found-in-matrix-example
Sheet: Sheet1

 |  | Customer | Total [NAME] |  |  |  |  |  |  |  |  |  |  |  | Option 1 | Option 2 | Option 3 | Cost 1 | Cost 2 | Cost 3
 |  | [NAME] | 0 | Apple |  |  | Ford |  |  |  |  |  |  | ABC Co. | Apple | Samsung | [NAME] | 1000 | 800 | 750
 |  | [NAME] | 0 |  | Fruit | Blue |  |  |  |  |  |  |  | DEF Co. | Chocolate | Fruit | Pastry | 0.8 | 1.75 | 1.35
 |  | [NAME] | 0 | [NAME] | Chocolate |  | GMC |  |  |  |  |  |  | GHI Co. | Red | Blue | Yellow | 5 | 8 | 3
 |  | Sidney | 0 |  | Pastry | Red |  | Small |  |  |  |  |  | JKL Co. | GMC | Ford | Dodge | 300 | 100 | 200
 |  | Samantha | 0 |  |  |  | GMC |  |  |  |  |  |  | MNO Co. | Small | Normal | Large | 20 | 30 | 40
Spreadsheet: 174740d1345166109-monthly-row-data-into-quarterly-data-example1
Sheet: Sheet1

2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00
121.8 | 121.8 | 121.9 | 122 | 122 | 122 | 123 | 123 | 123 | 124 | 124 | 124
2012-09-01 00:00:00 | 2012-12-01 00:00:00 | 2013-03-01 00:00:00 | 2013-06-01 00:00:00
something automatic as opposed to =A3+B3+C3
Spreadsheet: 148134d1333146965-function-to-calculate-actual-rent-keeps-pulling-the-amount-occupied-or-not-xxexploring_e07_grader_eoc2
Sheet: Summary

Search Engine
Search For Ranking:
Result Development:
Summary Statistics
Apartment Complex | Total Units | Occupied Units | Occupancy Rate | Rank by [NAME] | Potential Rent | Actual Rent | % of Potential Rent
Lakeview Apartments
Mountaintop View
Oak Tree Living
[NAME]
Sunset Valley
 |  |  |  |  | Total Rent:
List of Rental Property
Seq No. | Apartment Complex | Unit # | # Bed | Rental Price | Occupied | [NAME] | Recommendation
1 | [NAME] | 101 | 1 | 750 | Yes | 2004
2 | Lakeview Apartments | 11 | 1 | 875 | No | 2008
3 | Lakeview Apartments | 12 | 1 | 875 | No | 2001
4 | Mountaintop View | A | 1 | 875 | No | 2004
5 | Mountaintop View | B | 2 | 950 | No | 2010
6 | Mountaintop View | C | 3 | 1200 | Yes | 2010
7 | Sunset Valley | 101 | 1 | 550 | Yes | 2010
8 | Sunset Valley | 102 | 1 | 550 | No | 2010
9 | Sunset Valley | 103 | 1 | 550 | No | 2003
10 | Sunset Valley | 201 | 1 | 550 | Yes | 2003
11 | Oak Tree Living | 21 | 1 | 1000 | Yes | 2004
12 | Oak Tree Living | 22 | 1 | 1000 | Yes | 2004
13 | Oak Tree Living | 23 | 2 | 1200 | No | 2004