tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 695701d1600351880-according-to-the-year-and-points-formula-for-calculating-the-corresponding-grade-0917
Sheet: Sheet3

Years | Points | Corresponding grade |  |  |  | Years | 1 | Years | 2 | Years | 3 | Years | 4 | Years | 5 | Years | 6
1 | 1745 | silver |  |  |  | Points | Corresponding grade | Points | Corresponding grade | Points | Corresponding grade | Points | Corresponding grade | Points | Corresponding grade | Points | Corresponding grade
2 | 642 | silver |  |  |  | 0 | silver | 0 | silver | 0 | gold | 0 | gold | 0 | gold | 0 | gold
3 | 4280 | Platinum |  |  |  | 500 | silver | 1500 | silver | 2200 | gold | 2900 | gold | 3300 | gold | 3700 | gold
4 | 2750 | gold |  |  |  | 600 | silver | 1750 | silver | 2450 | gold | 3150 | gold | 3550 | gold | 3950 | gold
5 | 6204 | Black diamond |  |  |  | 700 | silver | 2000 | gold | 2700 | gold | 3400 | gold | 3800 | gold | 4200 | Platinum
6 | 5200 | diamond |  |  |  | 800 | silver | 2250 | gold | 2950 | gold | 3650 | gold | 4050 | Platinum | 4450 | Platinum
7 | 5220 | diamond |  |  |  | 900 | silver | 2500 | gold | 3200 | gold | 3900 | gold | 4300 | Platinum | 4700 | Platinum
8 | 6260 | Black diamond |  |  |  | 1000 | silver | 2750 | gold | 3450 | gold | 4150 | Platinum | 4550 | Platinum | 4950 | diamond
9 | 4624 | Platinum |  |  |  | 1100 | silver | 3000 | gold | 3700 | gold | 4400 | Platinum | 4800 | diamond | 5200 | diamond
 |  |  |  |  |  | 1200 | silver | 3250 | gold | 3950 | gold | 4650 | Platinum | 5050 | diamond | 5450 | diamond
 |  |  |  |  |  | 1300 | silver | 3500 | gold | 4200 | Platinum | 4900 | diamond | 5300 | diamond | 5700 | diamond
 |  |  |  |  |  | 1400 | silver | 3600 | gold | 4300 | Platinum | 5000 | diamond | 5400 | diamond | 5800 | diamond
 |  |  |  |  |  | 1500 | silver | 3700 | gold | 4400 | Platinum | 5100 | diamond | 5500 | diamond | 5900 | diamond
 |  |  |  |  |  | 1600 | silver | 3800 | gold | 4500 | Platinum | 5200 | diamond | 5600 | diamond | 6000 | Black diamond
 |  |  |  |  |  | 1700 | silver | 3900 | gold | 4600 | Platinum | 5300 | diamond | 5700 | diamond | 6100 | Black diamond
 |  |  |  |  |  | 1800 | silver | 4000 | Platinum | 4700 | Platinum | 5400 | diamond | 5800 | diamond | 6200 | Black diamond
 |  |  |  |  |  | 1900 | silver | 4100 | Platinum | 4800 | diamond | 5500 | diamond | 5900 | diamond | 6300 | Black diamond
 |  |  |  |  |  | 2000 | gold | 4200 | Platinum | 4900 | diamond | 5600 | diamond | 6000 | Black diamond | 6400 | Black diamond
 |  |  |  |  |  | 2100 | gold | 4300 | Platinum | 5000 | diamond | 5700 | diamond | 6100 | Black diamond | 6500 | Black diamond
 |  |  |  |  |  | 2200 | gold | 4400 | Platinum | 5100 | diamond | 5800 | diamond | 6200 | Black diamond | 6600 | Black diamond
 |  |  |  |  |  | 2300 | gold | 4500 | Platinum | 5200 | diamond | 5900 | diamond | 6300 | Black diamond | 6700 | Black diamond
Spreadsheet: john_arnold__15179__SSDSTF Datatables 97 June 00
Sheet: Table 3

TABLE 3
USE A SEPARATE SHEET FOR METRO & COUNTY
LEADING EMPLOYERS
BY
ALL SECTORS & INDIVIDUAL SECTORS
PROVIDE SEPARATE TABLES FOR EACH:
25 FOR AREAS OVER 1 MILLION
20 FOR AREAS 500,000 - 999,999
15 FOR AREAS 100,000 - 499,000
10 FOR AREAS LESS THAN 10,000
Sector | Company | Location |  | Product/Service | Function 1 | SIC Code | Employment | % of Union Workers
 |  | City | County |  |  | 2
All Sectors
Manufacturing
Distribution
FIRE
Back Offices
Across All
Sectors
You may want to include hospitals, county, city, telephone company, school, city, government, county government, large hospital & largest university.
1  Headquarters, regional office, back office, distribution center, branch manufacturing plant, branch assembly plant and R & D center
2  Two digit SIC Code
Spreadsheet: 117677d1312957753-arrange-data-shown-in-rows-accordingly-temp-book1
Sheet: Sheet1

Area | Thane | Mumbai | Belapur | Thane | Belapur | Mumbai | Thane | Thane
Name | Singh | R Kumar | [NAME] | [NAME] | Mishra | Verma | K Singh | Menon
Target | 2011-07-12 00:00:00 | 2011-07-12 00:00:00 | 2011-03-12 00:00:00 | 2011-04-12 00:00:00 | 2011-03-12 00:00:00 | 2011-07-12 00:00:00 | 2011-06-12 00:00:00 | 2011-04-12 00:00:00
Spreadsheet: 58489d1258726538-vlookup-query-retrievebydatesample
Sheet: Sheet2

Name | Address | City | State | Zip | Phone | Order # | PO# | Date | Key
Name1 | Address1 | City1 | State1 | Zip1 | Ph1 | 12345 | 44331 | 2009-11-15 00:00:00 | 0
[NAME] | Address2 | City2 | State2 | Zip2 | Ph2 | 12345 | 44331 | 2009-11-16 00:00:00 | 0
Name3 | Address3 | City3 | State3 | Zip3 | Ph3 | 12345 | 44331 | 2009-11-17 00:00:00 | 0
Name4 | Address4 | City4 | State4 | Zip4 | Ph4 | 12345 | 44331 | 2009-11-20 00:00:00 | 1
Name5 | Address5 | City5 | State5 | Zip5 | Ph5 | 12345 | 44331 | 2009-11-19 00:00:00 | 1
Name6 | Address6 | [NAME] | State6 | Zip6 | Ph6 | 12345 | 44331 | 2009-11-20 00:00:00 | 2
Name7 | Address7 | City7 | State7 | Zip7 | Ph7 | 12345 | 44331 | 2009-11-21 00:00:00 | 2
Name8 | Address8 | City8 | State8 | Zip8 | Ph8 | 12345 | 44331 | 2009-11-20 00:00:00 | 3
Name9 | Address9 | City9 | State9 | Zip9 | Ph9 | 12345 | 44331 | 2009-11-23 00:00:00 | 3
Name10 | Address10 | City10 | State10 | Zip10 | Ph10 | 12345 | 44331 | 2009-11-24 00:00:00 | 3
Name11 | Address11 | City11 | State11 | Zip11 | Ph11 | 12345 | 44331 | 2009-11-20 00:00:00 | 4
Name12 | Address12 | City12 | State12 | Zip12 | Ph12 | 12345 | 44331 | 2009-11-26 00:00:00 | 4
Name13 | Address13 | City13 | State13 | [NAME] | Ph13 | 12345 | 44331 | 2009-11-20 00:00:00 | 5
Name14 | Address14 | City14 | State14 | Zip14 | Ph14 | 12345 | 44331 | 2009-11-28 00:00:00 | 5
Spreadsheet: chris_germany__2056__MCV Invoice Analysis 4-29-02
Sheet: Invoice Rec2

APRIL INVOICE ANALYSIS
Invoice w/o PEPL |  |  | This is what the invoice should have been without the PEPL Volume
MCV Payment |  |  | This is what MCV Actually paid
Short Pay |  |  | Based on what invoice should have been, amount of short pay
MCV Claimed LD | 384975 |  | MCV charging us for April non-deliveries
Balance |  |  | Thus explains shortpay
Invoice for PEPL | 381300 |  | What we should have invoiced for PEPL
1 Day of Swing Gas | ???
[NAME] for April | ???? |  | Should be the PEPL volumes plus the day's worth of swing
Spreadsheet: 733680d1621702801-extract-cells-from-one-sheet-and-display-result-on-another-sheet-according-to-criteria-filter
Sheet: Filter

Name | Tue | Wed | Thu | Fri | Sat | Mon |  | Booked | Sat
[NAME] | Booked |  |  |  |  | Booked
[NAME] |  | Booked | Booked |  | Booked | Booked |  | [NAME] | Booked |  | [NAME]
[NAME] | Booked | Booked | Booked | Booked | Booked |  |  | [NAME] | Booked |  | Mat
Mat | Booked |  |  | Booked | Booked | Booked |  | Mat | Booked |  | [NAME]
[NAME] | Booked |  | Booked |  | Booked |  |  | [NAME] | Booked
[NAME] |  | Booked |  | Booked |  | Booked |  | [NAME]
[NAME] |  | Booked | Booked | Booked |  | Booked |  | [NAME]
Spreadsheet: 57443d1257570188-transpose-or-vlookup-book
Sheet: DATA

idform:*AA01* | idform:*AA02* | idform:*AA03*
Date:1/1/2009 | Date:1/1/2009 | Date:1/1/2009
ITEM | ITEM | ITEM
GSM03 | GSM03 | Sub Total-0.0
160.00 	2.00 	320.00 | 160.00 1.00 160.00 | GrandTotal-0.00
Sub Total-2.0 | GSM10
GrandTotal-320.00 | 160.00 	2.00 	320.00
 | Sub Total-3.0
 | GrandTotal-480.00
Spreadsheet: benjamin_rogers__1066__NewCo-7-15-00
Sheet: ENA_BS

[NAME] SHEET
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Check
Assets:
Cash and cash equivalents | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Accounts Receivable | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Inventories | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Deferred Tax Assets
Other Current Assets | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Property, plant and equipment
Cost
Accumulated depreciation
Property, plant, and equipment, net
Total Assets
Liabilities:
Accounts Payable | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Payable | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other Payables
Deferred Tax Liability
Long-term debt
Other liabilities
Total liabilities
Stockholders' equity:
Capital Stock
Retained earnings
Total stockholders' equity
Total liabilities and stockholders' equity
[NAME]:
Spreadsheet: 79681d1279889134-vlookup-and-multiple-sheets-summaryvlookup
Sheet: Jan

Date | Customer | Reject Item | Bought | Returned | ITEM
2010-02-03 00:00:00 | [NAME] co. | 103F | 1000 | 20 | 103F | 1500 | 30 | 0.02
2010-03-03 00:00:00 | Vengaboys | 192C | 1200 | 10 | 192C | 1200 | 10 | 0.008333333333333333
2010-05-03 00:00:00 | [NAME]'s | 103F | 500 | 10
Date(Column A), every customer (column B) reject item (Column C) (drop down list from the Items sheet) is noted with the quantity
he bought (Column D) & quantity returned (Column E). Based on that, I have a pivot table in Column F that provides me Each IT
Each ITEM summary, Total bought (column G), Total Rejected(Column H). In (Column I), i use the formula to find % Reject in the row item.
Spreadsheet: 845819d1697155542-find-quantity-on-orders-looking-up-part-code-and-order-refs-on-separate-sheets-label-stock-example
Sheet: Packaging size guide

 | Eco Belly Band | Tablet Belly Band | Belly Band | Basic Swing Tag | Standard Swingtag | Bundle Packaging | [NAME]
 | 8mm | 8mm | 8mm | 8mm | 8mm | 16mm | 8mm
 | AAA0001 | AAA0004 | AAA0007 | AAA0014 | AAA0016 | [NAME] | [NAME]
 | AAA0002 | AAA0005 | AAA0008 | AAA0015 | AAA0017 | AAA0066 | AAA0069
 | AAA0003 | AAA0006 | AAA0009 |  | [NAME] | AAA0067 | AAA0070
 |  |  | AAA0010 |  | [NAME] |  | AAA0071
 |  |  | AAA0011 |  | AAA0020 |  | AAA0072
 |  |  | AAA0012 |  | AAA0021 |  | AAA0073
 |  |  | AAA0013 |  | AAA0022 |  | AAA0074
 |  |  |  |  | AAA0023 |  | AAA0075
 |  |  |  |  | AAA0024 |  | AAA0076
 |  |  |  |  | AAA0025 |  | AAA0077
 |  |  |  |  | AAA0026 |  | AAA0078
 |  |  |  |  | AAA0027 |  | AAA0079
 |  |  |  |  | AAA0028 |  | AAA0080
 |  |  |  |  | AAA0029 |  | AAA0081
 |  |  |  |  | [NAME] |  | AAA0082
 |  |  |  |  | AAA0031
 |  |  |  |  | AAA0032
 |  |  |  |  | AAA0033
 |  |  |  |  | AAA0034
 |  |  |  |  | AAA0035
 |  |  |  |  | AAA0036
 |  |  |  |  | [NAME]
 |  |  |  |  | AAA0038
 |  |  |  |  | AAA0039
 |  |  |  |  | AAA0040
 |  |  |  |  | AAA0041
 |  |  |  |  | AAA0042
 |  |  |  |  | AAA0043
 |  |  |  |  | AAA0044
 |  |  |  |  | AAA0045
 |  |  |  |  | AAA0046
 |  |  |  |  | AAA0047
 |  |  |  |  | AAA0048
 |  |  |  |  | [NAME]
 |  |  |  |  | AAA0050
 |  |  |  |  | AAA0051
 |  |  |  |  | AAA0052
 |  |  |  |  | AAA0053
 |  |  |  |  | AAA0054
 |  |  |  |  | [NAME]
 |  |  |  |  | AAA0056
 |  |  |  |  | AAA0057
 |  |  |  |  | AAA0058
 |  |  |  |  | AAA0059
 |  |  |  |  | AAA0060
 |  |  |  |  | [NAME]
 |  |  |  |  | AAA0062
 |  |  |  |  | [NAME]
 |  |  |  |  | AAA0064
Spreadsheet: 119478d1314438499-collating-data-problem1
Sheet: Problem2

Input1 | Input2 | Input3 | Input4 | Output
2345 | 5 | 567 | 9876 | 2345;5;567;9876
4534 | 4563 | 789 | 45639 | 4534;4563;789;45639
45327 | 78945 | 46373 | 12 | 45327;78945;46373;12
user will input data herein col a b c d |  |  |  | This is what I'm looking at
Spreadsheet: 138826d1327935065-excel-2007-solidify-data-from-another-sheet-faturamento-help
Sheet: Preview Global

 | EMPRESA GLOBAL |  | EMPRESA GLOBAL |  |  |  | Product Extra |  |  |  |  |  |  |  |  |  |  |  |  | EXTRA
# | Cod. Client | First Name | Bank Slip # | Expiration | Monthly Value ($) | Discount ($) | Product A | Product B | Product C | Product D | Product E | Product F | Product G | Product H | Product I | Product J | [NAME] | Product L | Product M | Extra 1 | Extra 2
1 | 61921 | [NAME] | 619211201 | 01/01/12 | 350 | 0 | 295.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 245.8 | 0 | 0
2 | 66431 | [NAME] | 664311201 | 01/01/12 | 300 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 245.8 | 0 | 0
3 | 67181 | [NAME] | 671811201 | 01/01/12 | 300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 245.8 | 0 | 0
4 | 66641 | [NAME] | 666411201 | 01/01/12 | 400 | 0 | 321.5 | 321.5 | 0 | 0 | 0 | 0 | 160 | 0 | 160 | 0 | 0 | 0 | 0 | 0 | 0
5 | 67091 | Felipe | 670911201 | 01/01/12 | 500 | 0 | 209.6 | 209.6 | 0 | 0 | 209.6 | 0 | 104.8 | 104.8 | 104.8 | 104.8 | 0 | 0 | 786 | 0 | 0
 |  | Total Alunos Global |  |  | 1850 | 30 | 826.3000000000001 | 531.1 | 0 | 0 | 209.6 | 0 | 264.8 | 104.8 | 264.8 | 104.8 | 0 | 0 | 1523.4 | 0 | 0
 |  | G-Global
1 | 66951 | [NAME] | 669511201 | 01/01/12 | 300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 67061 | [NAME] | 670611201 | 01/01/12 | 300 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 64871 | Jaime | 648711201 | 01/01/12 | 300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 62711 | Wagner | 627111201 | 01/01/12 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total Alunos Global |  |  | 1300 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total |  |  | 3150 | 45 | 826.3000000000001 | 531.1 | 0 | 0 | 209.6 | 0 | 264.8 | 104.8 | 264.8 | 104.8 | 0 | 0 | 1523.4 | 0 | 0
Spreadsheet: 97700d1296812798-excel-2007-how-to-add-next-column-value-for-consecutive-patterns-test
Sheet: Sheet1

 | code | value
 | 1 | 2 |  |  | value  of [NAME] of code 0 | =7
 | 0 | 3
 | 1 | 3 |  |  | Value of [NAME] of code 1 | =11 | (not 9)
 | 1 | 1
 | 1 | 2
 | 1 | 3
 | 0 | 4
 | 0 | 4
 | 1 | 2
 | 0 | 3
 | 0 | 2
 | 0 | 2
 | 1 | 2
 | 1 | 4
 | 1 | 4
 | 1 | 1
Spreadsheet: 126163d1319552934-generating-a-parts-list-report-with-subcategories-in-excel-2003-example_parts_list
Sheet: Modules in ROOM1

Serial No | Sub Module Serial Numbers |  |  |  |  |  |  |  |  |  |  |  |  | Module Build Record |  | Comments
 | Phone | Laptop | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  | Build Date | Built By
MD01 | S001 | S006 | S110 | S005 |  |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | Archie
MD02 | S002 | S005 | S078 | S010 |  |  |  |  |  |  |  |  |  | 2011-01-02 00:00:00 | Archie
MD03 | S003 | S007 | S079 | S011 |  |  |  |  |  |  |  |  |  | 2011-01-03 00:00:00 | Archie
MD04 | S004 | S008 | S088 | S012 |  |  |  |  |  |  |  |  |  | 2011-01-04 00:00:00 | Archie
Spreadsheet: 676489d1588839100-how-to-conditional-format-a-symbol-trading-dashboard
Sheet: Chart Info

[NAME] |  |  |  |  | Pie Chart
 |  |  | Balance |  | Cost
2020-04-27 00:00:00 | 0 | 25000 |  |  | Profit/Loss
 |  |  |  |  | ROI
 |  |  |  |  | Bar Chart
Spreadsheet: 749622d1632933840-finding-most-recent-data-based-on-several-criteria-book1
Sheet: Sheet1

Entered | Item | Location | Amount |  |  | Date | Site | Item | Most Recent Amount
2021-09-10 00:00:00 | A2 | West | 40 |  |  | 2021-09-13 00:00:00 | West | A1 | 76
2021-09-10 00:00:00 | A2 | East | 48 |  |  | 2021-09-14 00:00:00 | West | A1 | 76
2021-09-13 00:00:00 | A1 | West | 76 |  |  | 2021-09-15 00:00:00 | West | A1 | 96
2021-09-14 00:00:00 | A2 | East | 19 |  |  | 2021-09-16 00:00:00 | West | A1 | 96
2021-09-14 00:00:00 | A1 | West | 99 |  |  | 2021-09-17 00:00:00 | West | A1 | 96
2021-09-15 00:00:00 | A1 | West | 96 |  |  | 2021-09-18 00:00:00 | West | A1 | 96
2021-09-15 00:00:00 | A2 | East | 76 |  |  | 2021-09-19 00:00:00 | West | A1 | 96
2021-09-16 00:00:00 | A1 | East | 46 |  |  | 2021-09-20 00:00:00 | West | A1 | 20
2021-09-17 00:00:00 | A2 | East | 60 |  |  | 2021-09-21 00:00:00 | West | A1 | 20
2021-09-17 00:00:00 | A2 | West | 63 |  |  | 2021-09-22 00:00:00 | West | A1 | 72
2021-09-20 00:00:00 | A1 | East | 28
2021-09-20 00:00:00 | A1 | West | 20
2021-09-21 00:00:00 | A2 | East | 83
2021-09-21 00:00:00 | A2 | West | 58
2021-09-22 00:00:00 | A1 | West | 72
2021-09-23 00:00:00 | A2 | West | 31
2021-09-23 00:00:00 | A1 | East | 36
2021-09-24 00:00:00 | A1 | West | 62
2021-09-24 00:00:00 | A2 | East | 41
2021-09-27 00:00:00 | A1 | West | 90
Spreadsheet: 818360d1676765147-excel-formula-client-profiles-copy-tms
Sheet: Lists

Client | Entity Type | Tax Return | Software | Access | Services | Payroll Provider | CPA Firm
Client 1 | Corporation | 1040, [NAME] | Bill.com | Client Server | 1099's | ADP | Brixey & Meyer
Client 2 | Limited Liability Corporation (LLC) | 1065 Partnership | [NAME] | KES | Bookkeeping | Ally | Burke & Schindler
Client 3 | Partnership | 1120 Corporation | MS Excel | Online | CAT Tax Filing | In House | [NAME], [NAME]
Client 4 | S Corporation | 1120S S Corporation | Quickbooks Desktop (QBD) | On-site | Financial Statements | Intuit | Fermann Staun & Company
Client 5 | Sole-Proprietorship | 990 Non-Profit | Quickbooks Online (QBO) |  | Sales Tax Filing | Paychex | [NAME]
Client 6 |  |  | Sage / Peachtree |  | Waste Tax Filing | Paycor
Client 7 |  |  | TMS |  | Year End Close | Payroll Partners
Client 8
Client 9
Client 10
Client 11
Client 12
Client 13
Client 14
Client 15
Client 16
Client 17
Client 18
Client 19
Client 20
Client 21
Client 22
Spreadsheet: bd4a1c30-f006-4a2b-9b85-2dcdfd36ff5e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | 战略供应链
 |  | 【报名详情】
 |  | 【培训时间】2012年5月26-27日上海
 |  | 【承办单位】企 业 学 习 网
 |  | 【培训对象】董事长、总经理、供应链总监
 |  | 【培训费用】4800元/人（仅培训费,不含餐费）
 |  | 【热线电话】[PHONE]
 |  | 【深圳/市场部】０７５５-６１２８９８２０【上海/市场部】　０２１-５１８７０６１２
 |  | 【北京/市场部】　０１０-５１２９５４０９【广州/市场部】　０２０-６１１３３７７５
 |  | 【课程背景】
 |  | 供应链经营是全新的模式，逐步从制造型、服务型经济转向供应链经济
 |  | 供应链战争：你早已身在其中，但你却从未理解
 |  | ►多数企业对供应链的理解相当狭窄，往往局限在采购、仓储和物流环节。如果你不懂供应链
 |  | 运作，那么你索性别去竞争了——杰克韦尔奇
 |  | ►为什么同在供应链末端，代工企业台积电价格在比对手高10%～30%情况下，仍获得了源源不
 |  | 断订单。中小代工企业如何参与供应链竞争？
 |  | ►模仿者如何不懂得ZARA、苹果、沃尔玛的背后都是供应链竞争，那么结果必将是：高库存、
 |  | 高成本、高缺货而失败。
 |  | ►为什么很多德、日中小企业，一辈子只做几个配件却能百年不衰，而中国的中小企业平均寿
 |  | 命不过三年？如何发挥优势支点，撬动供应链杠杆？
 |  | [NAME]
 |  | 业，而是深入到上下游对物流、信息流、资金流的重组、衔接，实现差异化竞争，以降低成本、创
 |  | 新价值、加快交付。
 |  | 供应链分得越细，你就能够更加激活整个供应链，中小企业可以更好的参与全球竞争。如果大
 |  | 象仍然自以为是的想控制一切而又迟钝，那么很快就会失败。供应链经营已经成为最主要的竞争手
 |  | 段。
 |  | 【课程收益】
 |  | ►参加本次课程你将重新认识这个世界的商业运作,重新认识企业是如何参与竞争,重新定义你的
 |  | 竞争对手，重新审视你企业存在形态！如果你不认识到这些新的变化，那么萎缩、衰退必将到来！
 |  | ►你已经在营销上想尽了办法，在生产上严格控制了成本，下一步你向哪里要利润空间？向哪里
 |  | 要成本下降空间？你应拆除工厂的藩篱和企业的边界, 进入供应链所有环节重新衔接,将带来无限
 |  | 价值空间。
 |  | ►如果你对未来竞争无所适从，你想成为行业未来领袖。那么,本次课程将带你走进IBM智慧地球，
 |  | 你将提前感知未来人类生活、社会运作模式带给供应链天翻地覆的变化、IBM供应链解决方案带给
 |  | 企业竞争的革命性改变。
 |  | 【课程前言】
 |  | 在今天，供应链将是大部分企业异军突起的核心杠杆
 |  | 在扁平化的供应链竞争中，恰恰给与了中小型企业参与世界性竞争的机会
 |  | ►【无烟工厂】美国一家零售商需要订十万件衬衫，利丰集团十年前做法：找一家最好的工厂，
 |  | 请它准时按质生产，收取一定佣金，然后把衬衫交给顾客。而今天，纱线从韩国工厂采购, 编织和
 |  | 印染从台湾两家工厂采购，剪裁用泰国的三家工厂。十年前可能要三个月交付。 现在,最短十天之
 |  | 内。你能面对这样的供应链竞争吗？
 |  | ►【谁是对手】一条街两面各有一家百货店，有人说这是面对面竞争。 [NAME]
 |  | 争。所有的基础设施、物流、设计等，零售商店其实是这条供应链最后一个环节，或是十几个步骤
 |  | 中的最后一个过程而已。现在这种竞争将不再是个体企业之间的竞争，而是供应链之间的竞争。与
 |  | 供应商对抗和压价最终失败的是你自己！
 |  | ►【[NAME]；
 |  | 使企业走向成长“终点”：订单增长带来的利润，规模效益带来的实际生产成本的下降， 最终会
 |  | 被无序管理所带来的快速增长的预防成本抵消掉。销售部和生产部却经常因交货期问题， 相互冲
 |  | 突。为什么一方面库存堆积如山，但却又经常缺货？
 |  | ►【模仿之痛】任何一家ZARA模仿者都会被告知,在快速供应链下保持低库存是快时尚模式盈利的
 |  | 基础。海澜之家因高存货备受质疑，2011年末公司存货达38.63亿元，占总流动资产高达56.82%；
 |  | 2010年存货周转率仅为0.88。凡客诚品不断引进多元化的新品，从而导致库存增加。应对客户多批
 |  | 少量的需求，没有供应链管理能力一切都是空谈！
 |  | 【导师简介】[讲师团队]
 |  | 韩永生:雅戈尔、百丽、顾家工艺供应链项目主导者中科院博士生导师；
 |  | 刘伯欣:IBM供应链专家；
 |  | 【课程大纲】
 |  | 第一模块：跳出边界，赢得客户订单
 |  | ►针对问题1、一个在供应链各个环节完全没有优势的企业凭什么重新赢得客户青睐？
 |  | ►针对问题2、你的支点是什么？如何去协作供应链这个杠杆，去撬动自己的整体竞争力？
 |  | ►针对问题3、如果你是供应链主导者，那么你应该如何领导供应链各个成员协作参与竞争？
 |  | 第二模块：以最低成本准时交付订单
 |  | ►针对问题1、如何深入到上下游环节，做到"不动企业一枪一炮"下实现利润倍增？
 |  | ►针对问题2、如何改善和破除各部门"各自为重"现象实现企业整体利润的最大化？
 |  | ►针对问题3、上下游,出于“安全库存”的考虑,需求在各个环节都被放大，如何低库存快交？
 |  | 第三模块：从未来世界找战略性机会
 |  | 1、智慧的地球是指我们能把智慧嵌入系统和流程之中，使服务的交付、产品开发、制造、采购和
 |  | 销售得以实现更敏捷和智能。
 |  | 2、大量的计算资源都能以一种规模小、数量多、成本低的方式嵌入各类非电脑的物品中：如汽车、
 |  | 电器、公路、铁路、电网、服装等，或嵌入全球供应链。有哪些机会？你该如何参与竞争？
Spreadsheet: 762149d1641410064-is-there-a-built-in-formula-timclarke
Sheet: Worksheet A

GBP |  |  |  |  |  | USD
0 | 8.03 | 7.56 | 6.61 | 6.05 | 6.05 | 0 | 11.64 | 10.96 | 9.59 | 8.77 | 8.77
0 | 6.98 | 6.57 | 5.75 | 5.26 | 5.26 | 0 | 10.12 | 9.53 | 8.34 | 7.62 | 7.62
0 | 7.15 | 6.74 | 5.91 | 5.42 | 5.42 | 0 | 10.36 | 9.77 | 8.58 | 7.86 | 7.86
0 | 7.31 | 6.98 | 6.08 | 5.59 | 5.59 | 0 | 10.6 | 10.12 | 8.81 | 8.1 | 8.1
0 | 25.71 | 20.87 | 16.43 | 16.43 | 16.43 | 0 | 37.27 | 30.27 | 23.82 | 23.82 | 23.82
0 | 38.27 | 30.92 | 24.55 | 24.55 | 24.55 | 0 | 55.49 | 44.84 | 35.59 | 35.59 | 35.59
0 | 61.66 | 49.87 | 39.43 | 39.43 | 39.43 | 0 | 89.4 | 72.31 | 57.17 | 57.17 | 57.17
0 | 8.03 | 7.56 | 6.61 | 6.05 | 6.05 | 0 | 11.64 | 10.96 | 9.59 | 8.77 | 8.77
0 | 8.22 | 7.75 | 6.8 | 6.23 | 6.23 | 0 | 11.92 | 11.23 | 9.86 | 9.04 | 9.04
0 | 8.41 | 8.03 | 6.99 | 6.43 | 6.43 | 0 | 12.19 | 11.64 | 10.14 | 9.31 | 9.31
0 | 29.57 | 24 | 18.89 | 18.89 | 18.89 | 0 | 42.86 | 34.81 | 27.39 | 27.39 | 27.39
0 | 44.01 | 35.56 | 28.23 | 28.23 | 28.23 | 0 | 63.81 | 51.57 | 40.93 | 40.93 | 40.93
Spreadsheet: 101355d1299512426-merging-two-excel-sheet-with-a-common-variable-consolidatedscores
Sheet: Sheet1

Identity # | total score 1
312000 | 3
33098 | 2
33456 | 2
Identity # | total score 2
31201 | 4
33098 | 2
33456 | 2
Identity # | total score 3
312000 | 3
31201 | 4
33098 | 2
Spreadsheet: 85959d1285944603-excel-2007-how-to-apply-if-circumstances-dummy-workbook-1
Sheet: Choice C

78.5
 | Weight |  | 0 |  |  |  |  |  |  |  |  | [NAME]
 | holes |  | 0 |  |  |  |  |  |  |  |  | 1.57
 | cuts* |  | 0
 | laser* |  | 0
 | grooves* |  | 0
 | twists* |  | 0
 | Customized Orders
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 1 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 2 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 3 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 4 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 5 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 6 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
 | "Larger" sizes
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 1 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 2 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 3 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 35
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 4 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25