tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 194204d1353076400-graphs-with-large-data-test1
Sheet: Sept

 |  |  |  |  |  | BDML | ASDA | HERO | Virgin Money | Coverbox
PARTS
 |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME]
 | R1 | R2 | R3 | R4 | R5 | BDML-I | ASDA-I | HERO | VM-I
11 | 101 | 201 | 301 | 401 | 501 | X | X | X | X | P
12 | 101 | 201 | 301 | 401 | 501 | P | P | X | X | X
13 | 101 | 201 | 301 | 401 | 501 | X | X | X | X | X
14 | 101 | 201 | 301 | 401 | 501 | X | X | P | P | X
15 | 101 | 201 | 301 | 401 | 501 | O | O | X | X | X
16 | 101 | 201 | 301 | 401 | 501 | X | X | P | X
17 | 101 | 201 | 301 | 401 | 501 | X | X | P | X
18 | 101 | 201 | 301 | 401 | 501 | P | P | P | X | X
19 | 101 | 201 | 301 | 401 | 501 | O | O | O | X | X
20 | 101 | 201 | 301 | 401 | 501 | O | O | X | X | X
21 | 101 | 201 | 301 | 401 | 501 | O | O | X | X | X
22 | 101 | 201 | 301 | 401 | 501 | X | X | X
23 | 101 | 201 | 301 | 401 | 501 | P | O | P | X | X
24 | 101 | 201 | 301 | 401 | 501 | O | O | X | X | X
25 | 101 | 201 | 301 | 401 | 501 | P | x | X | X | P
26 | 101 | 201 | 301 | 401 | 501 | X | X | X | P | X
27 | 101 | 201 | 301 | 401 | 501 | X | X | X | X | X
28 | 101 | 201 | 301 | 401 | 501 | o | X | X | X | X
29 | 101 | 201 | 301 | 401 | 501 | O | X | X | X | X
30 | 101 | 201 | 301 | 401 | 501 | O | X | X | X | X
31 | 101 | 201 | 301 | 401 | 501 | X | X | X | X | P
32 | 101 | 201 | 301 | 401 | 501 | O | O | X | X | X
33 | 101 | 201 | 301 | 401 | 501 | O | O | X | X | X
34 | 101 | 201 | 301 | 401 | 501 | X | X | X
35 | 101 | 201 | 301 | 401 | 501 | P | P | P | P | X
36 | 101 | 201 | 301 | 401 | 501 | X | X | X | X
37 | 101 | 201 | 301 | 401 | 501 | X | X | X | P
38 | 101 | 201 | 301 | 401 | 501 | P | P | P | X | X
39 | 101 | 201 | 301 | 401 | 501 | P | P | P | X | X
40 | 101 | 201 | 301 | 401 | 501 | P | P | P | X | X
41 | 101 | 201 | 301 | 401 | 501 | P | P | X | X | X
42 | 101 | 201 | 301 | 401 | 501 | P | P | X | X | P
43 | 101 | 201 | 301 | 401 | 501 | X | X | P | P | X
44 | 101 | 201 | 301 | 401 | 501 | X | X | X | X | X
45 | 101 | 201 | 301 | 401 | 501 | P | P | P | X | X
46 | 101 | 201 | 301 | 401 | 501 | X | X | X | P
47 | 101 | 201 | 301 | 401 | 501 | X | X | P | X
48 | 101 | 201 | 301 | 401 | 501 | P | P | X | P | X
49 | 101 | 201 | 301 | 401 | 501 | P | P | P
50 | 101 | 201 | 301 | 401 | 501 | P | P | P | X | X
51 | 101 | 201 | 301 | 401 | 501 | P | P | P | P | X
52 | 101 | 201 | 301 | 401 | 501 | X | X | X | X | X
53 | 101 | 201 | 301 | 401 | 501 | P | X | P | X | X
54 | 101 | 201 | 301 | 401 | 501 | P | X | P | X | X
55 | 101 | 201 | 301 | 401 | 501 | P | P | P | X | X
56 | 101 | 201 | 301 | 401 | 501 | O | X | O | X | X
57 | 101 | 201 | 301 | 401 | 501 | X | X | X | X | X
58 | 101 | 201 | 301 | 401 | 501 | P | P | P | P | X
59 | 101 | 201 | 301 | 401 | 501 | X | X | X | X | P
60 | 101 | 201 | 301 | 401 | 501 | X | X | X | X | X
61 | 101 | 201 | 301 | 401 | 501 | P | P | P | X | X
62 | 101 | 201 | 301 | 401 | 501 | P | P | P | X | X
63 | 101 | 201 | 301 | 401 | 501 | P | X | P | X
64 | 101 | 201 | 301 | 401 | 501 | X | P | X | X | X
Spreadsheet: 229340d1366371637-dependent-drop-down-lists-based-on-dynamic-data-range-book2-1-
Sheet: Static Data For Dropdowns

Quarter1 | Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4 | Year1 |  | SKUDropDown |  |  | Jan | 1
Qtr 1 | Jan | Apr | Jul | Oct | 2013 |  | SDS-1941-Black |  |  | Feb | 2
Qtr 2 | Feb | May | Aug | Nov | 2012 |  | MLPD-200-Black-XXL |  |  | Mar | 3
Qtr 3 | Mar | Jun | Sep | Dec | 2011 |  | SST-Insoles-11 |  |  | Apr | 4
Qtr 4 |  |  |  |  | 2010 |  |  |  |  | May | 5
 |  |  |  |  |  |  |  |  |  | Jun | 6
 |  |  |  |  |  |  |  |  |  | Jul | 7
 |  |  |  |  |  |  |  |  |  | Aug | 8
 |  |  |  |  |  |  |  |  |  | Sep | 9
 |  |  |  |  |  |  |  |  |  | Oct | 10
 |  |  |  |  |  |  |  |  |  | Nov | 11
 |  |  |  |  |  |  |  |  |  | Dec | 12
 |  |  |  |  |  |  |  |  |  |  | The table above is necessary to create
 |  |  |  |  |  |  |  |  |  |  | the dynamic dates on the "dashboard" worksheet
Spreadsheet: 719530d1613709289-count-distinct-values-in-two-columns-where-the-third-matches-a-value-unique-count
Sheet: Sheet1

Month | id | Organisation |  |  |  | Jan | Feb | Mar
Jan | A | CNN |  |  | IBM
Jan | A | CNN |  |  | CNN
Feb | A | IBM |  |  | ABC
Feb | C | IBM
Mar | B | ABC
Mar | B | CNN
Spreadsheet: ca89a5d5-5087-45a1-bff2-c5931a332c5c
Sheet: Sheet1

Securities | % of Assets
Veresen Inc. | 3.30%
Capital Power Corp | 2.85%
BCE Inc. | 2.82%
Crescent Point Energy Crp | 2.73%
Northland Power Inc | 2.65%
National Bank of Canada | 2.63%
Emera Inc. | 2.55%
Enbridge Income Fund Hld | 2.55%
Canadian Oil Sands Ltd | 2.45%
Baytex Energy Corp. | 2.39%
Bank of Montreal | 2.38%
Pembina Pipeline Inc | 2.37%
Great-West Life Company | 2.36%
Fortis Inc. | 2.34%
Inter Pipeline Ltd. | 2.33%
Rogers Communications Inc | 2.32%
Cdn Imperial Bk of Commrc | 2.32%
Keyera Corp | 2.31%
Shaw Communicatn Cl B Nvs | 2.23%
TransCanada Corp. | 2.19%
Royal Bank of Canada | 2.18%
Thomson Reuters Corp | 2.18%
Freehold Royalties Ltd | 2.13%
Power Financial Corp. | 2.13%
Potash Corp of Saskatchwn | 2.10%
Sun Life Financial Inc. | 2.07%
Power Corporation Canada | 2.07%
Bank of Nova Scotia | 2.06%
TELUS Corp. | 1.97%
IGM Financial Inc. | 1.95%
Transcontinental Inc Cl A | 1.93%
Toronto-Dominion Bank | 1.91%
[NAME] Cl B Nvs | 1.78%
Cineplex Inc. | 1.70%
Genworth MI Canada Inc | 1.68%
Wajax Corporation | 1.64%
Vermilion Energy Inc. | 1.63%
ARC Resources Ltd | 1.63%
Enbridge Inc. | 1.60%
BROOKFIELD PROPERTY PTNER | 1.57%
AGF Management Ltd Cl B | 1.45%
Mullen Group Ltd. | 1.39%
CI Financial Corp | 1.39%
Husky Energy Inc. | 1.38%
Dorel Industries Inc Cl B | 1.33%
First Capital Realty Inc | 1.25%
Aimia Inc. | 1.15%
Ensign Energy Srvcs Inc | 0.86%
Teck Resources Ltd Cl B | 0.78%
Canexus Corporation | 0.55%
Cash | 0.52%
Total Holdings in Portfolio | 51
Spreadsheet: 72012d1272678071-array-formula-respective-stock-symbols-dr_forumsample
Sheet: Sheet2

 |  |  |  |  |  |  | TIF | Scale | Total Quantity | Total $ Amount | Limit Price | Stop Price | Trail Price | Data
 |  |  |  |  |  |  | O | 0.01 | 100 | 5000 | column C value |  |  | BETA
 |  |  |  |  |  |  | DAY | 0.02 | 200 | 10000 | Column D value |  |  | VOLAT
 |  |  |  |  |  |  | GTC | 0.03 | 300 | 15000 |  |  |  | ATR
 |  |  |  |  |  |  | MKT | 0.04 | 400 | 20000
 |  |  |  |  |  |  | MOC | 0.05 | 500 | 25000
 |  |  |  |  |  |  |  | 0.06 | 600 | 30000
 |  |  |  |  |  |  |  | 0.07 | 700 | 35000
 |  |  |  |  |  |  |  | 0.08 | 800 | 40000
 |  |  |  |  |  |  |  | 0.09 | 900 | 45000
 |  |  |  |  |  |  |  | 0.1 | 1000 | 50000
 |  |  |  |  |  |  |  | IF(BETA<=1),0.01,IF(BETA<=1.5),0.02,IF(BETA<=2),0.03,IF(BETA<=2.5),0.04,IF(BETA<=3),0.05,0.10) | (K/BETA) |  | IF(OR(G="B",G="Buy"),COLUMN C,IF(OR(G="S",G="Sell"),COLUMN D,IF(OR(G="T",G="Short"),COLUMN D,COLUMN B)))
 |  |  |  |  |  |  |  |  | 1000/BETA |  | or manual | (ORDER PRICE)+((((J/E)-1)*I)+0.01)
 |  |  |  |  |  |  |  |  |  |  | or formula | (ORDER PRICE)+((((J/E)-1)*I)+0.02)
 |  |  |  |  |  |  |  |  |  |  |  | (ORDER PRICE)+((((J/E)-1)*I)+0.03)
 |  |  |  |  |  |  |  |  |  |  |  | (ORDER PRICE)+((((J/E)-1)*I)+0.04)
 |  |  |  |  |  |  |  |  |  |  |  | (ORDER PRICE)+((((J/E)-1)*I)+0.05)
 |  |  |  |  |  |  |  |  |  |  |  | (ORDER PRICE)+((((J/E)-1)*I)+I)
 |  |  |  |  |  |  |  |  |  |  |  | (ORDER PRICE)+((J/E)*I)
 |  |  |  |  |  |  |  |  |  |  |  | or manual
 |  |  |  |  |  |  |  |  |  |  |  | or formula
Spreadsheet: 723897d1615934715-how-to-get-the-sheet-name-from-a-cell-value-example
Sheet: Supplier_1

Item | Name | PL-code | Price
A1111101 | TEST 1 | 23 | 58
A1111102 | TEST2 | 23 | 62
A1111103 | TEST 3 | 23 | 14
A1111104 | TEST 4 | 24 | 35
A1111105 | TEST 5 | 24 | 89
A1111106 | TEST 6 | 24 | 24
A1111107 | TEST 7 | 25 | 65
A1111108 | TEST 8 | 25 | 48
A1111109 | TEST 9 | 25 | 34
Spreadsheet: 718342d1613099899-something-is-wrong-in-this-index-calculation-how-to-correct-this-book1-index-sumif
Sheet: Sheet1

 | TIME | BUY/SELL |  |  | PRICE
 | 2021-02-11 14:52:04.230000 | -0.04099999999999682 | -0.09999999999999432 | 107.1332 | 88.4 | INDEX A=B2 |  |  |  |  | 88.4
 | 2021-02-11 14:52:06.200000 | -0.04814000000000362 | 0 | 107.18134 | 88.4 | INDEX LTP=B19 |  |  |  |  | 88.4
 | 2021-02-11 14:52:08.200000 | 0.002199999999987767 | 0.04999999999999716 | 107.18354 | 88.45
 | 2021-02-11 14:52:12.190000 | 0.002450000000010277 | 0 | 107.18599 | 88.45
 | 2021-02-11 14:52:14.200000 | -0.01069999999999993 | -0.04999999999999716 | 107.19669 | 88.4 |  |  |  |  |  | 88.4
 | 2021-02-11 14:52:16.200000 | 0.01239999999999952 | 0.04999999999999716 | 107.20909 | 88.45 |  |  | 88.45
 | 2021-02-11 14:52:18.200000 | 0.003919999999993706 | 0 | 107.21301 | 88.45 |  |  | 88.4
 | 2021-02-11 14:52:20.200000 | -0.003610000000008995 | -0.04999999999999716 | 107.21662 | 88.4 |  |  | 88.35
 | 2021-02-11 14:52:22.200000 | -0.02855999999999881 | 0 | 107.24518 | 88.4 |  |  |  |  |  | 88.4
 | 2021-02-11 14:52:24.210000 | -0.0102499999999992 | 0 | 107.25543 | 88.4 |  |  |  |  |  | 88.4
 | 2021-02-11 14:52:26.210000 | -0.006720000000001392 | 0 | 107.26215 | 88.4 |  |  |  |  |  | 88.4
 | 2021-02-11 14:52:28.210000 | 0.06047999999999831 | 0.04999999999999716 | 107.32263 | 88.45 |  |  |  |  |  | TOTAL
 | 2021-02-11 14:52:30.200000 | -0.002200000000001978 | -0.1000000000000085 | 107.32483 | 88.35
 | 2021-02-11 14:52:32.210000 | -0.06704999999999472 | 0 | 107.39188 | 88.35 | CELL H8  Should show 15 as manually calculated in k13
 | 2021-02-11 14:52:34.210000 | 0.004999999999995453 | 0.05000000000001137 | 107.39688 | 88.4 | CELL H9  Should show 15 as manually calculated in c21
 | 2021-02-11 14:52:36.200000 | 0.002780000000001337 | 0 | 107.39966 | 88.4 | HOW TO CORRECT THIS ?
 | 2021-02-11 14:52:38.210000 | -0.01170000000000471 | -0.05000000000001137 | 107.41136 | 88.35
 | 2021-02-11 14:52:42.190000 | -0.09420000000000073 | 0 | 107.50556 | 88.35
Spreadsheet: 744807d1629460808-display-only-filtered-values-from-sheet-1-to-sheet-2-text-and-numbers-book1
Sheet: Sheet1

 | name | number | ap | date | date | sum1 | sum2 | sum3 | sum4 | sum5 | sum6 | sum7
 | Paradise | 2 | A2 | 2020-11-07 00:00:00 | 2020-11-08 00:00:00 | 60.75 | 0 | 60.75 | 42.84 | 0 | 4.23 | -4.23
 | Paradise | 2 | A1 | 2020-12-31 00:00:00 | 2021-01-02 00:00:00 | 71.29 | 71.29 | 0 | 60 | 11.29 | 0 | 0
 | Big Blue | 2 | A1 | 2020-12-31 00:00:00 | 2021-01-02 00:00:00 | 127.5 |  |  |  | 0 | 0 | 0
 | Big Blue | 3 | A1 | 2021-03-16 00:00:00 | 2021-03-20 00:00:00 | 366.66 | 366.66 | 0 | 291.67 | 74.99 | 0 | 0
 | [NAME] | 9 | A1 | 2021-03-26 00:00:00 | 2021-03-28 00:00:00 | 230.4 | 193.31 | 0 | 156.44 | 0 | 14.1 | -14.1
 | Paradise | 2 | A2 | 2021-03-27 00:00:00 | 2021-04-05 00:00:00 | 733.32 | 0 | 733.32 | 633.32 | 0 | 100 | -100
 | Big Blue | 4 | A1 | 2021-04-09 00:00:00 | 2021-04-11 00:00:00 | 189 | 183.33 | 0 | 141.84 | 41.49 | 0 | 0
 | [NAME] | 2 | A2 | 2021-04-10 00:00:00 | 2021-04-11 00:00:00 | 45.5 | 38.17 | 0 | 30.84 | 0 | 0 | 0
 | Big Blue | 2 | A1 | 2021-04-11 00:00:00 | 2021-04-18 00:00:00 | 735 | 712.95 | 0 | 592.01 | 120.94 | 0 | 0
Spreadsheet: 693532d1599018709-formula-to-replace-numbers-with-specific-letters-workbook1
Sheet: Sheet1

Origianal Code | Replacement Code |  | Original Format | Replacement Format
1123 | AABC |  | 1 | A
1124 | AABD |  | 2 | B
1525 | AEBE |  | 3 | C
2035 | BJCE |  | 4 | D
2465 | BDFE |  | 5 | E
2960 | BIFJ |  | 6 | F
21-1234 | BA-1234 |  | 7 | G
25-2245 | BE-2245 |  | 8 | H
32-5565 | CB-5565 |  | 9 | I
101-2245 | AJA-2245 |  | 0 | J
165-5698 | AFE-5698
801-9007 | HJA-9007
Spreadsheet: 833447d1686968381-concatenation-by-condition-excel-2016-concatbytag
Sheet: Sheet1

Input |  |  | Helper |  | Output
# | Owner | Make |  |  | Owner | Car
1 | Jeremy | Ford
2 | [NAME] | Toyota
3 | [NAME] | Toyota
4 | [NAME] | Ford
5 | [NAME] | Holden
6 | [NAME] | Mazda
7 | [NAME] | Mercedes
8 | Sage | Toyota
9 | [NAME] | Toyota
10 | [NAME] | Tesla |  |  |  |  | Output must retain hierarchy that input has i.e. [NAME] must remain on top, [NAME] must remain the next, etc.
11 | [NAME] | Unknown
12 | Rain | Tesla
 |  |  |  |  |  | Thank you! :)
Spreadsheet: 0557b8ba-3ce4-450c-a859-62ee2bc37453
Sheet: Sheet1

Utah  State Supported Minimum School Program | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Charter School Summary
FY 2007 Final
Recipient: | Ogden Preparatory Academy
Value of  WPU: | 2417
Enrollment: | 564 |  | Amount
Recipient Number: | 68 | WPU | Generated
I:  BASIC SCHOOL PROGRAMS:
A:  REGULAR BASIC SCHOOL PROGRAMS
1.  Grades K-12 |  | 503.07 | 1215921
2.  Professional Staff |  | 18.614 | 44990
3. Administrative Costs |  | 0.737 | 1781
B.  RESTRICTED BASIC SCHOOL PROGRAM
1.  Special Education -- Add-On |  | 64 | 154688
2.  Special Education -- Self-Contained |  | 2 | 4834
3.  Special Education -- Pre-School |  | 0 | 0
4.  Extended Yr. Pgm. -- Severely Disabled |  | 0 | 0
5.  Special Education -- State Programs |  | 0 | 0
6.  CTE -- Add-On |  | 1.983 | 4792
7. CTE - Set Aside |  | 0 | 0
8.  Class [NAME] -- K - 8th Grade |  | 44.734 | 108122
 | TOTAL BASIC SCHOOL PROGRAM (A thru C): | 635.138 | 1535128
II.  RELATED TO BASIC PROGRAM
1.  Social Security/Retirement |  |  | 292202
5.  Quality Teaching Block Grant |  |  | 59413
6.  Local Discretionary Block Grant |  |  | 21303
7.  Interventions for Student Success Block Grant |  |  | 12796
8.  At-Risk - Regular Program |  |  | 7647
9.  At-Risk - Homeless and Minority |  |  | 1977
10.  At-Risk - MESA |  |  | 0
11.  At-Risk - Gang Prevention |  |  | 0
12.  Accelerated Learning - Gifted and Talented |  |  | 2124
13.  Accelerated Learning - Advanced Placement |  |  | 0
14.  Accelerated Learning - Concurrent Enrollment |  |  | 0
17.  School LAND Trust |  |  | 19392
18.  Local Replacement |  |  | 635387
19.  Charter Administrative Cost |  |  | 2948
20.  [NAME] |  |  | 24419
III.  ONE-TIME
1.  Classroom Supplies |  |  | 7038
2.  Charter Parity |  |  | 208318
3.  Charter Administrative Costs |  |  | 5896
4.  [NAME] and Supplies |  |  | 2033
 |  |  | 2838021
I:  NON-MINIUMUM SCHOOL PROGRAMS |  |  | Total
A.  Charter School Board
1.  New Charter Start Up |  |  | 0
2.  High Tech Schools |  |  | 0
B.  U-PASS Administration |  |  | 1614
 |  |  | 1614
 | Total |  | 2839635
Spreadsheet: abd25289-0d09-487c-8d3a-ae1c3e1b3167
Sheet: Sheet1

Lowe's Companies, Inc. | 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
Consolidated Statements of Current and Retained Earnings (Unaudited)
In Millions, Except Per Share Data
 |  |  |  | Three Months Ended |  |  |  |  |  |  |  | Years Ended
 |  |  |  | 2010-01-29 00:00:00 |  |  |  | 2009-01-30 00:00:00 |  |  |  | 2010-01-29 00:00:00 |  |  |  | 2009-01-30 00:00:00
Current Earnings |  |  |  | Amount | Percent |  |  | Amount | Percent |  |  | Amount | Percent |  |  | Amount | Percent
Net sales |  |  | $ | 10168 | 100 |  | $ | 9984 | 100 |  | $ | 47220 | 100 |  | $ | 48230 | 100
Cost of sales |  |  |  | 6614 | 65.05 |  |  | 6616 | 66.27000000000001 |  |  | 30757 | 65.14 |  |  | 31729 | 65.78999999999999
Gross margin |  |  |  | 3554 | 34.95 |  |  | 3368 | 33.73 |  |  | 16463 | 34.86 |  |  | 16501 | 34.21
Expenses:
Selling, general and administrative |  |  |  | 2763 | 27.18 |  |  | 2610 | 26.15 |  |  | 11688 | 24.75 |  |  | 11074 | 22.96
Store opening costs |  |  |  | 12 | 0.11 |  |  | 32 | 0.32 |  |  | 49 | 0.1 |  |  | 102 | 0.21
Depreciation |  |  |  | 401 | 3.95 |  |  | 397 | 3.97 |  |  | 1614 | 3.42 |  |  | 1539 | 3.19
Interest - net |  |  |  | 56 | 0.55 |  |  | 70 | 0.7 |  |  | 287 | 0.61 |  |  | 280 | 0.58
Total expenses |  |  |  | 3232 | 31.79 |  |  | 3109 | 31.14 |  |  | 13638 | 28.88 |  |  | 12995 | 26.94
Pre-tax earnings |  |  |  | 322 | 3.16 |  |  | 259 | 2.59 |  |  | 2825 | 5.98 |  |  | 3506 | 7.27
Income tax provision |  |  |  | 117 | 1.14 |  |  | 97 | 0.9699999999999998 |  |  | 1042 | 2.200000000000001 |  |  | 1311 | 2.72
Net earnings |  |  | $ | 205 | 2.02 |  | $ | 162 | 1.62 |  | $ | 1783 | 3.78 |  | $ | 2195 | 4.55
Weighted average common shares outstanding - basic |  |  |  | 1455 |  |  |  | 1462 |  |  |  | 1462 |  |  |  | 1457
Basic earnings per common share |  |  | $ | 0.14 |  |  | $ | 0.11 |  |  | $ | 1.21 |  |  | $ | 1.5
Weighted average common shares outstanding - diluted |  |  |  | 1458 |  |  |  | 1463 |  |  |  | 1464 |  |  |  | 1468
Diluted earnings per common share |  |  | $ | 0.14 |  |  | $ | 0.11 |  |  | $ | 1.21 |  |  | $ | 1.49
Cash dividends per share |  |  | $ | 0.09 |  |  | $ | 0.085 |  |  | $ | 0.355 |  |  | $ | 0.335
[NAME]
Balance at beginning of period |  |  | $ | 18236 |  |  | $ | 17012 |  |  | $ | 17049 |  |  | $ | 15345
Net earnings |  |  |  | 205 |  |  |  | 162 |  |  |  | 1783 |  |  |  | 2195
Cash dividends |  |  |  | -131 |  |  |  | -125 |  |  |  | -522 |  |  |  | -491
Share repurchases |  |  |  | -3 |  |  |  | 0 |  |  |  | -3 |  |  |  | 0
Balance at end of period |  |  | $ | 18307 |  |  | $ | 17049 |  |  | $ | 18307 |  |  | $ | 17049
Spreadsheet: 767327d1644413555-vba-compare-copy-and-delete-compare
Sheet: Rawdata after

Company A | Street | PO | City | Country | Phone | Mail | www | Text |  |  | This line is the one in Rawdata
Company A | Street | PO | City | Country | Phone | Mail | www | Text |  |  | This line is copied from Total, and then deleted in Total if possible
Company K |  |  |  |  |  |  |  |  |  |  | This line is the one in Rawdata without having an equal in Total
Company B | Street | PO | City | Country | Phone | Mail | www
Company B |  | PO | City | Country | Phone
Company L
Company D | Street | PO | City | Country | Phone | Mail | www
Company D | Street
Company F | Street | PO | City | Country | Phone | Mail | www
Company F |  | PO | City | Country | Phone | Mail | www | Text
Company M
Company H | Street | PO | City | Country | Phone | Mail | www
Company H | Street | PO | City |  | Phone
Company N
Company I | Street | PO | City | Country | Phone | Mail | www
Company I |  |  | City |  | Phone | Mail |  | Text
Company J | Street | PO | City | Country | Phone | Mail | www
Company J |  | PO | City |  | Phone | Mail |  | Text
Company O | Street | PO | City | Country | Phone | Mail |  | Text
Spreadsheet: 128931d1321361133-excel-2007-iferror-index-formula-returning-blank-cells-helpif-error-not-working1
Sheet: Sheet1

 | Task | Days | Contingncy
 |  |  |  | Bx
 |  |  |  | Bwa
 | Bx | 4 | 3
 | Data Enter |  |  | B1
 | Results
 | [NAME]? | =IFERROR(INDEX(C13:C20, [NAME], C13:C20<>"", 0)), "")
 |  | Works only at entering data into cell C12 ?????, Try D12, E 12 etc etc
Spreadsheet: 757355d1638201416-conditional-formatting-with-searching-for-values-book4
Sheet: Sheet1

Area | Organizational Entity | QMS Entity | Expert | DocumentID | Applicable in MAP | Current Implementation Method | Future Implementation Method
Cardiovascular | Cardiac Ablation Solutions [CAS] | Brazil, Sao Paulo |  | 001-F372 | Yes | Out of Scope | Out of Scope
Cardiovascular | Cardiac Ablation Solutions [CAS] | CA, Sunnyvale [CAS] |  | 003 | Yes | In Scope: Use Direct
Cardiovascular | Cardiac Ablation Solutions [CAS] | CA, Sunnyvale [CAS] |  | 003-G100 | Yes | In Scope: Use Direct
Cardiovascular | Cardiac Ablation Solutions [CAS] | CA, Sunnyvale [CAS] |  | 003-F133 | Yes | In Scope: Use Direct | In Scope: Use Direct
Cardiovascular | Cardiac Ablation Solutions [CAS] | CA, Sunnyvale [CAS] |  | 003-F133 | Yes | In Scope: Use Direct | In Scope: Use Direct
Cardiovascular | Cardiac Ablation Solutions [CAS] | Americas [Supply Chain] |  | 001-F372 | Yes | In Scope: Use Direct
Cardiovascular | Cardiac Ablation Solutions [CAS] | Americas [Supply Chain] |  | 003 | Yes | In Scope: Use Direct
Cardiovascular | Cardiac Ablation Solutions [CAS] | Canada, Montreal |  | 003 | Yes | In Scope: Use Direct
Cardiovascular | Cardiac Ablation Solutions [CAS] | Canada, Montreal |  | 003 | Yes | In Scope: Use Direct
Cardiovascular | Cardiac Ablation Solutions [CAS] | Canada, Montreal |  | 003-G100 | Yes | In Scope: Tailor | In Scope: Inactivate
Cardiovascular | Cardiac Ablation Solutions [CAS] | Canada, Montreal |  | 003-G100 | Yes | In Scope: Tailor | In Scope: Tailor
Cardiovascular | Cardiac Ablation Solutions [CAS] | Canada, Montreal |  | 003-G100 | Yes | In Scope: Tailor | In Scope: Tailor
Cardiovascular | Cardiac Ablation Solutions [CAS] | Canada, Montreal |  | 003-G100 | Yes | In Scope: Tailor | In Scope: Use Direct
Cardiovascular | Cardiac Ablation Solutions [CAS] | Australia, Sydney |  | 003-F133 | Yes | In Scope: Use Direct
Cardiovascular | Cardiac Ablation Solutions [CAS] | MN, [NAME] [CAS] |  | 003 | Yes | In Scope: Use Direct
Cardiovascular | Cardiac Ablation Solutions [CAS] | MN, [NAME] [CAS] |  | 003-F133 | Yes | In Scope: Use Direct
Cardiovascular | Cardiac Ablation Solutions [CAS] | Brazil, Sao Paulo |  | 001-F372 | Yes | Out of Scope | In Scope: Obsolesce
Cardiovascular | Cardiac Ablation Solutions [CAS] | OH, Cleveland |  | 003 | Yes | In Scope: Use Direct | In Scope: Tailor
Cardiovascular | Cardiac Ablation Solutions [CAS] | OH, Cleveland |  | 003 | Yes | In Scope: Use Direct | In Scope: Tailor
Spreadsheet: 219240d1362689875-highlight-rows-if-a-matches-but-b-is-different-ex-for-mcro
Sheet: Ex for Mcro

2013-02-27 00:00:00
Account Number | Status | Maxplan | Status Date Change | RFD Date
808962 | Dis - S |  | 2012-11-28 00:00:00 | 2012-12-05 00:00:00
773136 | Obtained | J Obt | 2013-02-22 00:00:00 | 2012-12-11 00:00:00
716985 | DS Generated | S | 2013-01-24 00:00:00 | 2012-12-13 00:00:00
744138 | Disc sent | DBA | 2013-02-12 00:00:00 | 2012-12-13 00:00:00
807046 | Complete - JP | Default2 | 2013-02-28 00:00:00 | 2012-12-13 00:00:00
811806 | Sent | Jsent | 2013-02-14 00:00:00 | 2012-12-14 00:00:00
760279 | Dis - C |  | 2012-12-24 00:00:00 | 2012-12-20 00:00:00
810824 | Sent | Jsent | 2013-02-05 00:00:00 | 2012-12-21 00:00:00
691899 | G Generated | JEnf | 2013-02-27 00:00:00 | 2012-12-27 00:00:00
800271 | Dis - S |  | 2013-03-01 00:00:00 | 2012-12-27 00:00:00
2013-03-05 00:00:00
Account Number | Status | Maxplan | Status Date Change | RFD Date
808962 | Dis - S |  | 2012-11-28 00:00:00 | 2012-12-05 00:00:00
773136 | Obtained | J Obt | 2013-02-22 00:00:00 | 2012-12-11 00:00:00
716985 | DS Generated | S | 2013-01-24 00:00:00 | 2012-12-13 00:00:00
744138 | Disc sent | DBA | 2013-02-12 00:00:00 | 2012-12-13 00:00:00
807046 | Complete - JP | S | 2013-02-26 00:00:00 | 2012-12-13 00:00:00
811806 | Sent | Jsent | 2013-02-14 00:00:00 | 2012-12-14 00:00:00
760279 | Dis - C |  | 2012-12-24 00:00:00 | 2012-12-20 00:00:00
810824 | Sent | Jsent | 2013-02-05 00:00:00 | 2012-12-21 00:00:00
691899 | G Generated | JEnf | 2013-02-27 00:00:00 | 2012-12-27 00:00:00
800271 | SF - OS | Filed | 2013-01-08 00:00:00 | 2012-12-27 00:00:00
Spreadsheet: 768779d1645117064-calc-or-conditional-format-sample-2
Sheet: Sheet1

 | 3 |  | Value |  |  |  |  | 0.0371 | DROP
 |  |  | 0.045 | 0.04 | 0.035 | 0.03 |  | 0.45 |  | 0.45 | 0.45 | 0.45 | 0.45 | 0.45
 | Volume | 0.3 | 22.5 | 67.5 | 112.5 | 225
 |  | 0.4 | 67.5 | 112.5 | 225 | 337.5
 |  | 0.45 | 112.5 | 225 | 337.5 | 450
 | 4 |  | Value |  |  |  |  | 0.8 | Auto
 |  |  | 0.625 | 0.65 | 0.675 | 0.7 |  | 0.55 | Mix
 | Volume | 0.4 | 22.5 | 67.5 | 112.5 | 225
 |  | 0.475 | 67.5 | 112.5 | 225 | 337.5
 |  | 0.55 | 112.5 | 225 | 337.5 | 450
Spreadsheet: 752107d1634583293-help-to-create-an-order-list-based-on-products-by-cheapest-supplier-price-comparison-test
Sheet: COMPARE

 | SUPPLIER | PRODUCT | FROM | PRICE | ORDER CODE | CHEAPEST PRICE | FROM
 | ABPAC | No. 1 [NAME]
 |  |  | BAKO |  |  |  |  |  |  |  |  | 7" Greaseproof bag
 |  |  | Bonds Packaging |  |  |  |  |  |  |  |  | Nesting Tray
 |  |  | BOOKER
 |  |  | Catering 24
 |  |  | Cups Direct
 |  |  | Enviropack
 |  |  | Enviropack 4+
 |  |  | Enviropack 5+
 |  |  | JMP
 |  |  | Mr Duffin
 |  |  | Next Day Coffee
 |  |  | Penningtons
 |  |  | SUMA
 |  |  | [NAME]
 |  | PRODUCT | SUPPLIER | PRICE | DATE CHECK | DIFFERENCE | PRODUCT CODE | NOTES