tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 738684d1625171288-formula-to-extract-information-from-a-table-alternative-to-filter-formula
Sheet: Reports

User name and surname | Region | Job Function | Location | Training Title | Training Record Status
roberto | India | Commercial | Bangalore | Modern Slavery Act: Protecting Human Rights 2021 | Started / Overdue
pedro | Spain | Production | Madrid | Modern Slavery Act: Protecting Human Rights 2021 | Registered / Overdue
[NAME] | Spain | Commercial | Barcelona | Modern Slavery Act: Protecting Human Rights 2021 | Started / Overdue
[NAME] | Spain | Operations | Madrid | Modern Slavery Act: Protecting Human Rights 2021 | Registered / Overdue
jacobo | Spain | Operations | Barcelona | Data Protection Essentials 2021 | Registered / Overdue
alejandro | Spain | Operations | Barcelona | Modern Slavery Act: Protecting Human Rights 2021 | Registered / Overdue
alvaro | Spain | Operations | Barcelona | Data Protection Essentials 2021 | Registered / Overdue
pablo | Spain | Operations | Barcelona | Modern Slavery Act: Protecting Human Rights 2021 | Registered / Overdue
[NAME] | Spain | Operations | Sevilla | Data Protection Essentials 2021 | Registered / Overdue
[NAME] | Spain | Operations | Barcelona | Ethics Code 2021 | Registered / Overdue
german | Spain | Operations | Tarragona | Modern Slavery Act: Protecting Human Rights 2021 | Registered / Overdue
sofia | Spain | Production | Barcelona | Data Protection Essentials 2021 | Registered / Overdue
miguel | Spain | Production | Barcelona | Modern Slavery Act: Protecting Human Rights 2021 | Registered / Overdue
dario | Spain | Production | [NAME] | Data Protection Essentials 2021 | Registered / Overdue
[NAME] | Spain | Production | Barcelona | Ethics Code 2021 | Registered / Overdue
javier | Spain | Production | Murcia | Modern Slavery Act: Protecting Human Rights 2021 | Registered / Overdue
[NAME] | Spain | Commercial | Barcelona | Modern Slavery Act: Protecting Human Rights 2021 | Registered / Overdue
elena | Spain | Production | Murcia | Modern Slavery Act: Protecting Human Rights 2021 | Registered / Overdue
[NAME] | Spain | Commercial | Barcelona | Data Protection Essentials 2021 | Registered / Overdue
sara | Spain | Commercial | Murcia | Ethics Code 2021 | Registered / Overdue
gregorio | Spain | Commercial | Murcia | Modern Slavery Act: Protecting Human Rights 2021 | Registered / Overdue
pascual | Netherlands | Production | Bergeijk | Modern Slavery Act: Protecting Human Rights 2021 | Registered / Overdue
nestor | Netherlands | Commercial | Bergeijk | Modern Slavery Act: Protecting Human Rights 2021 | Registered / Overdue
olivia | Netherlands | Production | Bergeijk | Data Protection Essentials 2021 | Registered / Overdue
Spreadsheet: chris_stokley__4003__April 00 thru June 00 retro Enron Request
Sheet: 352

SORT COL | CONCAT | MONTH | SC ID | TIE POINT | adjusted total qty | RATE | FINAL ADJ $ AMOUNT | LATEST RATE | New $ | Refund | Effective Settlement Adjustment | Don’t use rate | MONTHMONTH | Retro Rate | Retro Effective Settlement Adjustment | Refund
26 | April 00EPMI | April 00 | EPMI | MALIN_5_RNDMTN | 2580 |  |  | 1.91 |  |  | 4927.8 | 1.91 | April 00 | 1.8 | 4644 | 283.8
26 | April 00EPMI | April 00 | EPMI | SYLMAR_2_NOB | 161 |  |  | 2.17 |  |  | 349.37 | 2.17 | April 00 | 2.07 | 333.27 | 16.1
28 | June 00EPMI | June 00 | EPMI | MALIN_5_RNDMTN | 13887 |  |  | 1.91 |  |  | 26524.17 | 1.91 | June 00 | 1.8 | 24996.6 | 1527.57
28 | June 00EPMI | June 00 | EPMI | SYLMAR_2_NOB | 375 |  |  | 2.17 |  |  | 813.75 | 2.17 | June 00 | 2.07 | 776.25 | 37.50000000000011
27 | May 00EPMI | May 00 | EPMI | MALIN_5_RNDMTN | 8931 |  |  | 1.91 |  |  | 17058.21 | 1.91 | May 00 | 1.8 | 16075.8 | 982.409999999998
Spreadsheet: 698050d1601708909-help-with-nested-if-formula-age-group-formula
Sheet: Sheet1

Age | Age Group | Result |  | These are the age groups or ranges: |  |  | 0-10 Days | 11-30 Days | 31-60 Days | 61-90 Days | 91-120 Days | >221 Days
-3 | <formula> | 0-10 DAYS
36.29 | <formula> | 31-60 DAYS
35.08 | <formula> | 31-60 DAYS
25.97 | <formula> | 11-30 DAYS
25.39 | <formula> | 11-30 DAYS
23.02 | <formula> | 11-30 DAYS
21.89 | <formula> | 11-30 DAYS
18.43 | <formula> | 11-30 DAYS
12.22 | <formula> | 11-30 DAYS
11.22 | <formula> | 11-30 DAYS
11.07 | <formula> | 11-30 DAYS
11.05 | <formula> | 11-30 DAYS
9.24 | <formula> | 0-10 DAYS
9.24 | <formula> | 0-10 DAYS
7.98 | <formula> | 0-10 DAYS
7.08 | <formula> | 0-10 DAYS
6 | <formula> | 0-10 DAYS
5.35 | <formula> | 0-10 DAYS
4.07 | <formula> | 0-10 DAYS
3.67 | <formula> | 0-10 DAYS
1.91 | <formula> | 0-10 DAYS
1.41 | <formula> | 0-10 DAYS
1.36 | <formula> | 0-10 DAYS
1.34 | <formula> | 0-10 DAYS
1.25 | <formula> | 0-10 DAYS
0.92 | <formula> | 0-10 DAYS
0.92 | <formula> | 0-10 DAYS
343.29 | <formula> | >211 DAYS
278.36 | <formula> | >211 DAYS
65 | <formula> | 61-90 DAYS
100 | <formula> | 91-120 DAYS
60 | <formula> | 31-60 DAYS
59 | <formula> | 31-60 DAYS
37 | <formula> | 31-60 DAYS
Spreadsheet: 200606d1355674191-vlookup-value-with-condition-of-another-cell-being-closest-to-specific-value-in-a-row-example
Sheet: Sheet1

SKU | STOCK | Value |  |  |  | Want | Value
stock1 | 8 | A |  |  | stock1 | C
stock1 | 7 | B |  |  | stock2 | B
stock1 | 11 | C |  |  | [NAME] | A
stock1 | 16 | D |  |  | stock4 | A
stock1 | 3 | E |  |  | stock5 | D
stock2 | 6 | A
stock2 | 7 | B
stock2 | 2 | C
[NAME] | 9 | A
[NAME] | 7 | B
[NAME] | 15 | C
[NAME] | 12 | D
stock4 | 10 | A
stock4 | 9 | B
stock4 | 11 | C
stock4 | 15 | D
stock4 | 14 | E
stock4 | 5 | F
stock5 | 8 | A
stock5 | 1 | B
stock5 | 3 | C
stock5 | 11 | D
stock5 | 12 | E
Spreadsheet: 806256d1669199915-extracting-missing-time-intervals-missing-times-ans
Sheet: Sheet1

 |  |  | Missing period
08:00:00 | 08:30:00 |  |  |  |  |  | 08:35:00
08:35:00 | 09:00:00 |  |  |  |  | 09:56:00 | 10:15:00
09:00:00 | 09:56:00
10:15:00 | 11:00:00
Spreadsheet: 855222d1704880410-help-to-find-latest-previous-related-value-book1-1-
Sheet: Sheet1

4 | [NAME]
No. | Name | Point
1 | [NAME] | 10
2 | [NAME] | 8
3 | [NAME] | 6
4 | [NAME] | 10
5 | [NAME] | 7
6 | [NAME] | 6
7 | [NAME] | 10
Spreadsheet: 657b2e6f-7bb3-43c2-81da-e9f4aa391d69
Sheet: Stmts. of Shareholders' Equity

 | HASBRO, INC. AND SUBSIDIARIES
 | Consolidated Statements of Shareholders' Equity
 | (Thousands of Dollars)
 |  |  |  |  |  |  |  |  | Accumulated
 |  |  |  |  | Additional |  |  |  | Other |  |  |  | Total
 |  |  | Common |  | Paid-in |  | Retained |  | Comprehensive |  | Treasury |  | Shareholders'
 |  |  | Stock |  | Capital |  | Earnings |  | (Loss) Earnings |  | Stock |  | Equity
 | Balance, December 27, 2009 …………………….. |  | 104847 |  | 467183 |  | 2720549 |  | 58631 |  | -1756438 |  | 1594772
 | Net earnings ………………….………………….. |  | – |  | – |  | 397752 |  | – |  | – |  | 397752
 | Other comprehensive loss …………………...... |  | – |  | – |  | – |  | -50482 |  | – |  | -50482
 | Stock-based compensation transactions…………………….. |  | – |  | 22971 |  | – |  | – |  | 86253 |  | 109224
 | Conversion of debentures……………………….. |  | – |  | 102792 |  | – |  | – |  | 204635 |  | 307427
 | Purchases of common stock……………………. |  | – |  | – |  | – |  | – |  | -636681 |  | -636681
 | Stock-based compensation expense…………………….. |  | – |  | 33015 |  | – |  | – |  | 377 |  | 33392
 | Dividends declared ……………..….…….……… |  | – |  | – |  | -139984 |  | – |  | – |  | -139984
 | Balance, December 26, 2010 …………………….. |  | 104847 |  | 625961 |  | 2978317 |  | 8149 |  | -2101854 |  | 1615420
 | Net earnings ………………….………………….. |  | – |  | – |  | 385367 |  | – |  | – |  | 385367
 | Other comprehensive loss …………………...... |  | – |  | – |  | – |  | -44092 |  | – |  | -44092
 | Stock-based compensation transactions…………………….. |  | – |  | -8266 |  | – |  | – |  | 37895 |  | 29629
 | Purchases of common stock……………………. |  | – |  | – |  | – |  | – |  | -423008 |  | -423008
 | Stock-based compensation expense…………………….. |  | – |  | 12349 |  | – |  | – |  | 114 |  | 12463
 | Dividends declared ……………..….…….……… |  | – |  | – |  | -158264 |  | – |  | – |  | -158264
 | Balance, December 25, 2011 …………………….. |  | 104847 |  | 630044 |  | 3205420 |  | -35943 |  | -2486853 |  | 1417515
 | Net earnings ………………….………………….. |  | – |  | – |  | 335999 |  | – |  | – |  | 335999
 | Other comprehensive loss …………………...... |  | – |  | – |  | – |  | -36364 |  | – |  | -36364
 | Stock-based compensation transactions…………………….. |  | – |  | 6695 |  | – |  | – |  | 51015 |  | 57710
 | Purchases of common stock……………………. |  | – |  | – |  | – |  | – |  | -100041 |  | -100041
 | Stock-based compensation expense…………………….. |  | – |  | 19204 |  | – |  | – |  | 230 |  | 19434
 | Dividends declared ……………..….…….……… |  | – |  | – |  | -186874 |  | – |  | – |  | -186874
 | Balance, December 30, 2012 …………………….. |  | 104847 |  | 655943 |  | 3354545 |  | -72307 |  | -2535649 |  | 1507379
See accompanying notes to consolidated financial statements.
Spreadsheet: 79976d1280231327-comparing-2-lists-for-indicating-where-data-appears-on-both-example
Sheet: Sheet1

70020003 | 1807613 |  | 3  ADAMSON COURT | Broadfield
70040003 | 1807739 |  | 3  ADRIAN COURT | Broadfield
 |  |  | 81  ALBANY ROAD | West Green
60630050 | 1801627 |  | 50  ARDEN ROAD | Furnace Green
61120004 | 1800989 |  | 4  ASHDOWN DRIVE | Tilgate
61120008 | 1800992 |  | 8  ASHDOWN DRIVE | Tilgate
61120063 | 1800879 |  | 63  ASHDOWN DRIVE | Tilgate
61120095 | 1800886 |  | 95  ASHDOWN DRIVE | Tilgate
Spreadsheet: 94901d1294670556-find-all-instances-of-a-selected-item-and-return-all-results-selectitemautofilter-1-
Sheet: Data

Number | Date | Company | Item
1 | 2008-12-14 00:00:00 | a | a1
2 | 2008-12-14 00:00:00 | b | a2
3 | 2008-12-14 00:00:00 | d | a3
4 | 2008-12-14 00:00:00 | c | a4
5 | 2008-12-15 00:00:00 | e | a5
6 | 2008-12-16 00:00:00 | r | 2a
7 | 2008-12-17 00:00:00 | t | 2a
8 | 2008-12-18 00:00:00 | a | 2a
9 | 2008-12-19 00:00:00 | b | 2a
10 | 2008-12-20 00:00:00 | c | 2a
11 | 2008-12-21 00:00:00 | d | b2
12 | 2008-12-21 00:00:00 | e | b3
13 | 2008-12-21 00:00:00 | r | b4
14 | 2008-12-21 00:00:00 | f | [NAME]
15 | 2008-12-21 00:00:00 | t | b6
16 | 2008-12-22 00:00:00 | y | v5
17 | 2008-12-23 00:00:00 | a | v6
18 | 2008-12-24 00:00:00 | b | v7
19 | 2008-12-25 00:00:00 | c | v8
20 | 2008-12-26 00:00:00 | d | v9
21 | 2008-12-26 00:00:00 | t | v10
22 | 2008-12-26 00:00:00 | y | v11
23 | 2008-12-26 00:00:00 | u | v12
24 | 2008-12-26 00:00:00 | i | v13
25 | 2008-12-27 00:00:00 | a | v14
Spreadsheet: 529850d1501031236-count-how-many-times-3-or-4-is-observed-in-a-sequence-tracking-bees-rwtasantenna
Sheet: Sheet1

Time | [NAME] | [NAME]
20170413T082042.394418+10 | 14 | 3
20170413T082042.394418+10 | 14 | 4
20170413T082042.660167+10 | 14 | 3
20170413T082042.660167+10 | 14 | 4
20170413T082042.919958+10 | 14 | 3
20170413T082043.180912+10 | 14 | 3
20170413T082043.180912+10 | 14 | 4
20170413T082043.439561+10 | 14 | 3
20170413T082043.439561+10 | 14 | 4
20170413T082043.695691+10 | 14 | 3
20170413T082045.888702+10 | 14 | 1
20170413T082045.888702+10 | 14 | 2
20170413T082046.142701+10 | 14 | 1
20170413T082046.391576+10 | 14 | 1
20170413T082046.391576+10 | 14 | 2
20170413T082046.649477+10 | 14 | 1
20170413T082046.649477+10 | 14 | 2
20170413T082621.054787+10 | 14 | 2
20170413T082621.570859+10 | 14 | 2
20170413T083131.803462+10 | 14 | 2
20170413T083132.282855+10 | 14 | 2
20170413T083134.888109+10 | 14 | 4
20170413T083135.088112+10 | 14 | 3
20170413T083135.088112+10 | 14 | 4
20170413T083135.342726+10 | 14 | 3
20170413T083135.342726+10 | 14 | 4
20170413T083229.188770+10 | 14 | 3
20170413T083229.477220+10 | 14 | 4
20170413T083229.720415+10 | 14 | 4
20170413T083229.919406+10 | 14 | 3
20170413T083229.919406+10 | 14 | 4
20170413T083230.174485+10 | 14 | 3
20170413T083230.174485+10 | 14 | 4
20170413T083230.432583+10 | 14 | 3
20170413T083230.432583+10 | 14 | 4
20170413T083230.697017+10 | 14 | 3
20170413T083230.697017+10 | 14 | 4
20170413T083230.954203+10 | 14 | 3
20170413T083233.184441+10 | 14 | 2
20170413T083233.690379+10 | 14 | 2
20170413T083233.943527+10 | 14 | 2
20170413T083518.272837+10 | 14 | 3
20170413T083518.272837+10 | 14 | 4
20170413T083518.538803+10 | 14 | 3
20170413T083518.538803+10 | 14 | 4
20170413T083519.015895+10 | 14 | 3
20170413T083519.015895+10 | 14 | 4
20170413T083519.285395+10 | 14 | 3
20170413T083519.285395+10 | 14 | 4
20170413T083519.539393+10 | 14 | 3
20170413T083522.229106+10 | 14 | 2
20170413T083522.454478+10 | 14 | 1
20170413T083522.454478+10 | 14 | 2
Spreadsheet: 268479d1380651290-finding-total-for-individuals-by-monthly-tab-and-unit-counts-bsr-teams-2013
Sheet: Aug

Daily Locked & Funded Loans AS 08/30/2013
 | Wholesale |  |  |  | Correspondent
Account Executive | Daily Locked | Active Locked | Daily Funded | MTD Funded | Daily Locked | Active Locked | Daily Purchased | MTD Purchased
[NAME] | $332,000 (1) | $6,397,650 (19) | $377,100 (1) | $5,796,700 (17) | - | - | - | -
[NAME] | - | $6,418,500 (18) | - | $5,254,700 (17) | - | - | - | -
[NAME] | - | $4,690,300 (13) | $225,600 (1) | $6,472,240 (21) | - | - | - | -
[NAME] | - | $1,371,500 (4) | - | $2,603,800 (10) | - | - | - | -
[NAME] | - | $9,398,850 (23) | $481,000 (1) | $8,268,250 (23) | - | - | - | -
[NAME] | - | $5,869,800 (13) | $455,000 (1) | $8,323,300 (20) | - | - | - | -
[NAME] | $703,000 (2) | $9,555,142 (31) | - | $10,545,400 (39) | - | - | - | -
[NAME] | - | $1,380,750 (4) | $474,500 (1) | $3,420,750 (10) | - | - | - | -
[NAME] | $375,400 (2) | $24,907,361 (71) | $1,262,500 (5) | $25,002,060 (70) | - | $6,656,000 (16) | - | $1,309,000 (4)
[NAME] | - | $4,376,350 (11) | - | $8,270,131 (20) | - | - | - | -
Kris Varia | - | $5,035,300 (12) | $625,500 (1) | $6,910,700 (21) | - | - | - | -
[NAME] | - | $8,380,750 (21) | - | $8,100,500 (21) | - | - | - | -
[NAME] | - | - | - | - | - | - | - | -
[NAME] | - | - | - | - | - | - | - | -
[NAME] | - | - | - | - | - | - | - | -
[NAME] | $176,000 (1) | $6,039,650 (15) | - | $14,777,305 (35) | - | - | - | -
[NAME] | - | $3,238,500 (9) | - | $3,228,500 (10) | - | - | - | -
[NAME] | - | $5,511,438 (14) | $154,500 (1) | $9,203,550 (27) | - | - | - | -
Subtotal | $1,586,400 (6) | $102,571,841 (278) | $4,055,700 (12) | $126,177,886 (361) | - | $6,656,000 (16) | - | $1,309,000 (4)
Daily HomeLending / Alan Locked & Funded Loans AS 08/30/2013
 | Retail |  |  |  | -
Account Executive | Daily Locked | Active Locked | Daily Funded | MTD Funded | - | - | - | -
[NAME] | - | $1,599,350 (3) | - | $673,000 (2) | - | - | - | -
Subtotal | - | $1,599,350 (3) | - | $673,000 (2) | - | - | - | -
Daily Locked & Funded Loans AS 08/30/2013
 | Wholesale / Retail |  |  |  | Correspondent
 | Daily Locked | Active Locked | Daily Funded | MTD Funded | Daily Locked | Active Locked | Daily Purchased | MTD Purchased
Total | $1,586,400 (6) | $104,171,191 (281) | $4,055,700 (12) | $126,850,886 (363) | - | $6,656,000 (16) | - | $1,309,000 (4)
Spreadsheet: 162037d1339697783-help-get-top-x-values-as-column-names-not-as-values-themselves-copy-of-book1-6
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Input: | 3
 |  |  |  |  |  |  |  |  |  |  | Hidden
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Spreadsheet: 828923d1683796416-search-a-text-from-an-array-of-values-fetch-object-aligw
Sheet: Data

Text | Find Object | Cheese | Expected Result | AliGW
1.  Hours and [NAME] (P311221) |  |  | P311221
1. RMA Revisions - P400511 (ZJDE0001) |  |  | P400511
6. Preference Profile (R40400) |  |  | R40400
12. Specify P4113 version to use (Recognize blank LOTS) custom PO's from P4113 to hold TO_LOCATION lot status even though it is blank.   Note - this option is used inline with above PO option value -1.    Default - ZJDE0001 |  |  | P4113
2. Enter Version for R04110ZA |  |  | R04110ZA
1. Enter Version for R47011 : |  |  | R47011
3.  Enter the version for [NAME] (cvt to .txt) to call.       Blank = Version XBX0002 with the country        code defined here. |  |  | [NAME]
12. P42101 [NAME] |  |  | P42101
1. R42565 Version |  |  | R42565
3. Test Results Revisions (P3711) |  |  | P3711
3.  [NAME] (P43512) |  |  | P43512
8. Tickler Version [P5900088] |  |  | P5900088
Spreadsheet: 02c1ce1f-8a44-4dce-9ea0-064982aff33e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FSCA6 | Test | FSCA6 | [NAME] (SCA) Type 6 | SCA 6 DNA | Polymerase Chain Reaction (PCR)/Fragment Analysis by Capillary Electrophoresis | EDTA (lavender-top) tube: EDTA |  |  | 20 | mL | 20 mL whole blood collected in a lavender-top (EDTA) tube(s). Send EDTA whole blood at ambient temperature.  Note:  Collection date is required. | 10 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | A final report will be faxed under separate cover.    Test Performed By:  Athena Diagnostics                                          377 Plantation St.                                         Four Biotech Park                                         Worcester, MA  01605 | Wednesday | 7-14 days | 8-15 days | 1 | 81479 |  |  |  |  | Athena Diagnostics
FSCA6 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
FSCA6 | Result | Z0097 | SCA 6 DNA | SCA 6 DNA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 165371d1341204676-multiple-row-and-column-based-record-to-linear-format-10-06-12-lost
Sheet: East Distt.

Control Room No | 6844 | State | DELHI
FIR Number | 159/12 | District | EAST DISTRICT
FIR Date | 2012-06-10 00:00:00 | Police Station | GEETA COLONY
Vehicle Type | TWO WHEELER | Registration Number | [NAME]
[NAME] | 2W - BAJAJ PULSAR | Engine Number | 75476
[NAME] | 2011 | Chasis Number | 95360
Vehicle Color | RED DARK | Phone Number | 9212121708
Complainant | RAJKUMAR | Address | HNO. 12/82 GEETA COLONY NEAR CHAWLA CHICKEN
Stolen From | HNO. 12/82 GEETA COLONY NEAR CHAWLA CHICKEN
Status | STOLEN/THEFT | Reporting Date/Time on ZIPNET | 2012-06-10 00:06:20.520000
Control Room No | 3324/DCR | State | DELHI
FIR Number | 436/12 | District | EAST DISTRICT
FIR Date | 2012-06-10 00:00:00 | Police Station | SHAKAR PUR
Vehicle Type | CAR | Registration Number | DL7CL6169
[NAME] | CAR - SANTRO | Engine Number | 10487
[NAME] | 2011 | Chasis Number | 89798
Vehicle Color | WHITE | Phone Number | 9811097560
Complainant | RAHUL SHARMA | Address | H NO-790, GURURRAM DAS NGR., EXT. LAXMI NGR.
Stolen From | SAMUDAI BHAVAN KE PAAS MCD KI PARKING ME LAXMI NAGAR
Status | STOLEN/THEFT | Reporting Date/Time on ZIPNET | 2012-06-10 00:12:12.060000
Spreadsheet: 88723d1288595013-find-certain-number-then-copy-it-and-4-other-cells-to-other-worksheet-example
Sheet: Sheet3

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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
Spreadsheet: darrell_schoolcraft__7774__imbalsumm0106
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | -13023 | -11000
2 | -20518 | -15000
3 | 0 | 0
4 | -6053 | -7500
5 | -27198 | -10000
6 | -20791 | -25000
7 | -20037 | -10000
8 | -26317 | -25000
9 | -65319 | -19998
10 | -17199 | -19199
11 |  | -19998
12 | -10287 | -35000
13 | -45271 | -60000
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | 57398.07
2001-06-13 00:00:00
Spreadsheet: 153257d1335831364-copy-column-data-from-one-shhet-to-another-test-1
Sheet: Sheet2

 | Daily Input Items | 2012-04-01 00:00:00
 | Dollar amounts from GSR
1 | Gross Wash Sales:
2 | Discounts/Coupons:
3 | ARM Plans Redeemed:
4 | Prepaids (Fast Pass):
5 | ARM Plans Sold(Total $ amount)
6 | ARM Plans Recharged(Total $ amount)
7 | ARM Plans Terminated(Total $ amount)
8 | XPT Cash/ Deposits:
9 | Credit Cards:
 | Daily Sales
10 | Car Count - Daily:
11 | Car Count - MTD:
12 | [NAME]) - Daily:
13 | [NAME]) - MTD:
14 | Over/Short(reason why):
15 | Explain # and $ of wash discounts:
16 | Referrals:
17 | Misc:
 | Labor
18 | No of Employees working:
19 | AM Supervisor:
20 | PM Supervisor:
21 | Labor dollars per car(All [NAME]):
22 | Labor %(All Paid):
 | New Community Member by Channels (#):
23 | Facebook:
24 | Tell a Friend:
25 | Share A Deal:
26 | Daily Deal:
27 | Google:
28 | Social Media:
29 | Quick Coupon:
30 | [NAME]:
31 | Other:
32 | Groupon:
33 | Gifting:
34 | XPT (On hold)
 | Community
35 | New ARM customers:
36 | New PAYG customers:
37 | New Rewards customers:
38 | Total New Community members:
39 | Total that left Community and why:
 | Misc
40 | Today's Weather(1-4) use chart on [NAME]
41 | If Rain did Greeter work and what did they do if so
42 | Upcoming weather events:
43 | Any misc info to add:
44 | Other customer issues:
45 | Questions or concerns:
 | Facilities
46 | Explain any non-wkg Equip:
47 | Chemical issues/concerns:
48 | [NAME]):
49 | Building Maintenance Issues:
Spreadsheet: 8ca78d5e-7798-4350-a3ab-202c5334cf0f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | MTP—中高层管理者技能提升训练
 |  | ----------向华为学管理
 |  | 【报名详情】
 |  | 【培训时间】2012年8月31-9月1日深圳、9月 8- 9日上海、11月23-24日深圳、11月29-30日上海
 |  | 【承办单位】企 业 学 习 网
 |  | 【[NAME]
 |  | 【培训费用】2800元/人（包括资料费、午餐及上下午茶点等）
 |  | 【热线电话】[PHONE]
 |  | 【深圳/市场部】０７５５-６１２８９８２０【上海/市场部】　０２１-５１８７０６１２
 |  | 【北京/市场部】　０１０-５１２９５４０９【广州/市场部】　０２０-６１１３３７７５
 |  | 【课程背景】
 |  | 中层管理者是企业的中流砥柱，他们是企业决策实施与落地的核心，是企业创新和进步的源泉，
 |  | 是企业文化的推动者。因此提升中层管理者的工作管理技能，是保证各项决策顺利实施的关键。然
 |  | 而，许多中层管理者在工作中常遇到以下困惑——
 |  | □如何界定管理者的角色定位和关键任务？
 |  | □如何提升自我管理和时间管理能力？
 |  | □如何建立绩效期望清晰的目标管理？
 |  | □如何实现有效的员工指导、授权和激励？
 |  | □如何提升沟通技能，优化团队管理？
 |  | 针对以上问题，我们特邀原华为人力资源副总监严明女士，与我们一同分享《向华为学习：MTP-
 |  | 中高层管理者技能提升训练》的精彩课程，帮助管理者重新树立角色认知，掌握管理者必备的基本
 |  | 人事和财务知识，以及自我管理的基本工具，树立合理的团队目标，建立团队规则，有效指导、激
 |  | 励、授权，以及同级沟通，下级领导、上级管理的良性沟通机制，持续提升团队绩效。
 |  | 【课程收益】
 |  | 1、陈述中层管理者的角色和自我定位
 |  | 2、描述团队管理者的三大关键任务
 |  | 3、运用自我管理（时间管理）的基本方法和工具
 |  | 4、运用MPRS模型实现目标管理和团队管理
 |  | 5、运用动力对话系统提升沟通技能
 |  | 【导师简介】[严明]
 |  | 严明 女士
 |  | 严明女士毕业于华中科技大学,复旦大学工商管理硕士，国际职业规划师（GCDF），高级心理
 |  | 咨询师,浙江大学、云南大学客座讲师。具有十五年以上企业内训和专业培训经验，是资深的培训
 |  | 师，长期为多个企业提供企业内训。
 |  | 在二十年的工作经历中，严明老师先后就职于正大集团、香港FAC设计公司、华为技术有限公
 |  | 司、UT斯达康通讯有限公司等大型企业,从事产品开发、销售、采购、行政管理、人力资源管理等
 |  | 工作，历任行政经理、地区销售主管、人力资源部总监、企业大学校长等职务,具备丰富的实践经
 |  | 验，并在近十年来坚持不断为中、大型企业提供人力资源管理、销售及领导力等培训及咨询。
 |  | 严明女士以丰富的实践经验为基础， 借鉴企业与个人成功经验，结合对现代企业与管理本质
 |  | 的思考，设计并担任《做富有激情的领导者》、 《高效执行的实践》、《团队的智慧》、《销售
 |  | 展示与呈现技巧》、《培训培训师》、《商务文书写作》、《时间管理与生命的效率》、 《沟通
 |  | 与人际关系的艺术》、《管理者的关键任务》等多门课程的培训， 其课程讲求内容的系统性、可
 |  | 操作性和实战指导性，理念与方法并重， 关注培训中学员的参与，通过案例分析、角色扮演、实
 |  | 践练习等互动式、启发式教学，深入浅出，学有所用，深受学员欢迎和好评。
 |  | 严明女士培训过的企业有中国电信、中国移动、中国联通、中国铁通、TCL、DELOITTE（德勤
 |  | ）咨询、富士康、华为技术有限公司、西门子、爱默生网络能源、拉法基、UT斯达康、 大唐光网
 |  | 络公司、达实智能、神威药业、美国生物应用、 金山软件、中大软件、文思软件、松下、中石油、
 |  | 中石化、中控集团、成飞集团、白云机场、光大银行、招商银行、民生银行、农业银行、 长城基
 |  | 金、长安福特马自达、东风集团、驰宏锌鍺、精工集团、安捷伦、恒生电子、四川长虹、 南方电
 |  | 网、国家电网、中原地产、深信服科技、 魏德曼、英提尔、优特公司、摩根凯龙、百大集团、沈
 |  | [NAME]。
 |  | 【课程大纲】
 |  | 【第一天上午】
 |  | 一、管理者对角色的认知决定管理行为
 |  | 1、我们的团队管理面临哪些挑战
 |  | 2、管理干部在企业中的现状是什么？
 |  | 3、企业的财务成功与职业经理人之间的关系
 |  | 4、领导力与管理力的关系
 |  | 二、管理者应担当的关键任务
 |  | 1、管理团队的关键任务
 |  | 2、团队管理者的三大关键任务
 |  | 3、管理者修炼领导力的完整模型
 |  | 抓住职位跨越按钮
 |  | 【第一天下午】
 |  | 三、管理者的自我管理
 |  | 1、经理人的日常工作效能管理
 |  | 2、在日常工作中平衡长期发展要求，提升个人生命的效能
 |  | 3、做一个勇担责任、让人信任的团队管理者
 |  | 四、让员工的感觉“好”起来
 |  | 1、分组研讨：“好”的感觉
 |  | 2、MPRS模型
 |  | 3、员工绩效的乘数
 |  | 4、管理者的魅力五角星
 |  | 5、值得信赖意味着什么？
 |  | 6、测试：你的可信度是多少？
 |  | 7、在团队中建立信任的方法——利人利己的思考习惯
 |  | 【第二天上午】
 |  | 五、从M到P：目标管理——建立清晰的绩效期望：
 |  | 1、目标管理的起源与其对于企业的意义
 |  | 2、企业基本管理、效率管理与价值管理的核心任务
 |  | 3、团队目标的三个层次
 |  | 4、从愿景目标到表现目标过程中常出现的问题及解决方法
 |  | 5、用参与式的目标管理创造团队的“生命体征”
 |  | 6、从表现目标走向行动目标
 |  | 7、用理性保证目标落实
 |  | 六、从P到R：消除绩效的障碍
 |  | 1、强化理论的实战应用
 |  | 2、管理者的指导障碍及解除
 |  | 3、如何安排工作与指导工作
 |  | 4、员工出错了如何指导
 |  | 【第二天下午】
 |  | 七、从R到S——你了解你的员工吗？
 |  | 1、相关激励理论的思考及实战修订（选读资料）
 |  | 2、是什么吸引与留住你的成员
 |  | 3、赞赏的力量
 |  | 4、符合人生发展的内在激励
 |  | 5、赞赏的时机
 |  | 6、视频示范：赞誉的作用
 |  | 八、从事倍功半到事半功倍——支持性的沟通方法
 |  | 1、从功能性沟通走向激励性沟通
 |  | 2、动力对话系统
 |  | 3、用提问技术有效提升自我觉察
 |  | 4、对理性表达的温习
 |  | [NAME]
 |  | 1、团队测试：不断反省自己的管理之路
 |  | 2、每天进步一点点，就是成功的开始
 |  | 3、行动计划：回去以后怎么做？