tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lynn_blair__24318__Nov01pnr
Sheet: Duke 500622

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components | [NAME] | Ride Amount
 | Duke Energy Trading & Mktg | 27266 | 2001-03-01 00:00:00 | 500622 | PnR |  |  |  | 0
1 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
2 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
3 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
4 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
5 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
6 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
7 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
8 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
9 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
10 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
11 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
12 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
13 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
14 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
15 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
16 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
17 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
18 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
19 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
20 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
21 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
22 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
23 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
24 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
25 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
26 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
27 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
28 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
29 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
30 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
31 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absolute [NAME]
 |  |  |  | Total Injection |  |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total W/D
Spreadsheet: 7bf26fe3-c486-4a90-b443-7e4cb066c3cc
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5203 | 30685 | [NAME] | [NAME] | GBR | 0 | 00:27:55 | [NAME] | 01:09:08 | 00:01:37 | [NAME] | 1 | 02:16:58
5203 | 30373 | [NAME] | Cuvillier | FRA | 0 | 00:29:57 | 00:02:04 | 01:07:47 | 00:01:25 | 00:38:26 | 2 | 02:19:40
5203 | 30797 | [NAME] | [NAME] | GBR | 0 | 00:32:37 | 00:01:24 | 01:11:15 | 00:01:51 | 00:35:47 | 3 | [NAME]
5203 | 17485 | Alberto | Ceriani | ITA | 0 | 00:30:15 | 00:02:03 | [NAME] | 00:01:44 | 00:38:42 | 4 | 02:24:41
Spreadsheet: 94150d1294032229-formula-for-sport-rankings-wrestlingleage
Sheet: 285

Weight | Ranking | First Name | Last Name | School | Section | Grade
285 | 1 | Gavin | [NAME] | Granite Bay | SJ | 11 | 2010 CIF 5
285 | 2 | [NAME] | Elor | College Park | NC | 12
285 | 3 | [NAME] | [NAME] | Servite | SS | 12 | 2010 CIF t12
285 | 4 | [NAME] | Wood | Lemoore | CS | 12 | reno 2
285 | 5 | [NAME] | Case | Rancho [NAME] | SD | 12
285 | 6 | [NAME] | [NAME] | Vista | SD | 12
285 | 7 | Dominick | [NAME] | Homestead | CC | 11
285 | 8 | [NAME] | Fusi | Corona | SS | 12
285 | 9 | Brain | [NAME] | Diamond Bar | SS | 12
285 | 10 | [NAME] | Rocha | [NAME] | SJ | 12 | reno t12
285 | 11 | Zach | Smith | [NAME] | SS | 12 | reno t12
285 | 12 | Narciso | [NAME] | Sanger | CS | 11 | reno t12
285 | 13 | Nick | Nevills | Clovis | CS | 9 | zink 1
Spreadsheet: 831770d1685881399-calculate-difference-between-times-based-on-multiple-criteria-calculate-the-difference-between-times
Sheet: Sheet1

 | Headway | Trip | From | To | Start | End | Direction | In-S |  | EXPECTED RESULTS
 |  | 5957 | DTABA | ABA3 | 4:49:00 | 4:52:00 | 1 | 0
 |  | 1003 | ABA3 | KIT2 | 4:55:00 | 5:08:16 | 1 | 0 |  |  | *Dynamically Calculate the time difference between the end time of trip and the end time of the previous trip within the same direction and In-S = 1
 |  | 5870 | DTABA | ABA3 | 5:04:00 | 5:07:00 | 1 | 0
 |  | 6171 | DTSLM | ADM1 | 5:07:00 | 5:13:00 | 1 | 0 |  |  | For example
 |  | 3050 | ABA3 | CFR2 | 5:10:00 | 5:12:35 | 2 | 0
 |  | 5441 | DTABA | ABA3 | 5:11:00 | 5:14:00 | 1 | 0 |  |  | 107 | ADM1 | KIT2 | 5:15:00 | 6:02:16
 |  | 101 | ABA3 | KIT2 | 5:15:00 | 5:30:46 | 1 | 1 |  |  | 109 | ADM1 | KIT2 | 5:24:06 | 6:11:22
 |  | 102 | CFR2 | ADM2 | 5:15:00 | 5:43:56 | 2 | 1
 |  | 104 | KIT2 | ADM2 | 5:15:00 | 6:01:27 | 2 | 1
 |  | 103 | ABA3 | KIT2 | 5:26:00 | 5:41:46 | 1 | 1
 |  | 3000 | DTSLM | ADM1 | 5:17:06 | 5:23:06 | 1 | 0
 |  | 5442 | DTABA | ABA3 | 5:22:00 | 5:25:00 | 1 | 0
 |  | 105 | ABA3 | KIT2 | 5:37:00 | 5:52:46 | 1 | 1
 |  | 107 | ADM1 | KIT2 | 5:15:00 | 6:02:16 | 1 | 1
 |  | 2990 | DTSLM | ADM1 | 5:26:06 | 5:32:06 | 1 | 0
 |  | 5443 | DTABA | ABA3 | 5:33:00 | 5:36:00 | 1 | 0
 |  | 109 | ADM1 | KIT2 | 5:24:06 | 6:11:22 | 1 | 1
 |  | 2942 | DTSLM | ADM1 | 5:33:51 | 5:39:51 | 1 | 0
 |  | 106 | KIT2 | ADM2 | 5:36:45 | 6:23:12 | 2 | 1
 |  | 111 | ADM1 | KIT2 | 5:33:06 | 6:20:22 | 1 | 1
 |  | 3069 | DTSLM | ADM1 | 5:38:06 | 5:44:06 | 1 | 0
 |  | 113 | ADM1 | KIT2 | 5:40:51 | 6:28:07 | 1 | 1
 |  | 5696 | ADM2 | ADM5 | 5:44:54 | 5:46:21 | 2 | 0
 |  | 108 | KIT2 | ADM2 | 5:48:00 | 6:34:27 | 2 | 1
 |  | 115 | ADM1 | KIT2 | 5:48:06 | 6:35:22 | 1 | 1
 |  | 5697 | ADM5 | ADM1 | 5:48:51 | 5:50:18 | 1 | 0
 |  | 6022 | DTSLM | ADM3 | 5:54:36 | 6:00:36 | 1 | 0
 |  | 117 | ADM1 | KIT2 | 5:54:51 | 6:42:07 | 1 | 1
 |  | 110 | KIT2 | ADM2 | 5:58:30 | 6:44:57 | 2 | 1
 |  | 119 | ADM3 | KIT2 | 6:01:36 | 6:48:52 | 1 | 1
 |  | 3655 | ADM2 | ADM5 | 6:02:27 | 6:03:54 | 2 | 0
 |  | 3656 | ADM5 | ADM1 | 6:06:04 | 6:07:31 | 1 | 0
 |  | 121 | ADM1 | KIT2 | 6:08:21 | 6:55:37 | 1 | 1
Spreadsheet: 725764d1616843821-monthly-to-cusotm-date-report-sample
Sheet: Backenddata

Model | Leather | Color | Article | Code | Sell Price | Product Cost
ALVA | SHEEP | BLACK | OLPAY | 66 241912 . 25 . 01 | 129 | 45.5
ALVA | SHEEP | BROWN | BUGAT | 66 241912 . 25 . 01 | 99 | 46
ANELLI | SHEEP | TAN | OLPAY | 66 251912 . 35 . 08 | 99 | 45
ANELLI | SHEEP | BLACK | WAXY | 66 251912 . 35 . 08 | 99 | 45
CLARA | SHEEP | YELLOW | OLPAY | 66 251912 . 35 . 06 | 99 | 44.75
ELIN | SHEEP | COGNAC | OLPAY | 66 241912 . 44 . 03 | 119 | 53
ELIN | SHEEP | BLACK | OLPAY | 66 241912 . 44 . 03 | 119 | 53
EDWIN | SHEEP | NAVY BLUE | OLPAY | 67 241912.  65.02 | 129 | 52.5
HEDDA | SHEEP | RED | OLPAY | 66 241912 . 25 . 05 | 99 | 44
HEDDA | SHEEP | COGNAC | OLPAY | 66 241912 . 25 . 05 | 99 | 44
AMADO | COW | BROWN | CRAZY HORSE |  | 129 | 30
EVRARD | COW | BROWN | PULL UP |  | 129 | 30
INGA(HOODY) | SHEEP | BROWN | BUGAT |  | 129.45 | 48
INGA (HOODY) | SHEEP | GREEN | OLPAY |  | 129.45 | 48
HINRIK | SHEEP | BLACK | BASCO |  | 199 | 60
ELIO | COW | BROWN |  |  | 129 | 30
ZALE /B 07 | SHEEP | NAVY | SOFY |  | 199 | 60
MADDY | SHEEP | BLACK | WAXY |  | 129 | 54
LIAM | SHEEP | BROWN | BUGAT |  | 149 | 53.75
Size
S
M
L
XL
2XL
3XL
 |  | leather
 |  | Sheep
 |  | Cow
 |  | Buffalo
Model |  | Goat
ADAMA CRAZY
ADAMO |  |  |  | Color
ALVA |  |  |  | BROWN
AMADO |  |  |  | TAN
ANELLI |  |  |  | BLACK
CLARA |  |  |  | YELLOW
EDWIN |  |  |  | COGNAC
ELIN |  |  |  | NAVY BLUE
EVRARD |  |  |  | RED
HEDDA |  |  |  | GREEN
HINRIK
INGA (HOODY)
INGA(HOODY)
LIAM
ELIO
MADDY
ZALE /B 07
Spreadsheet: 741335d1626976152-parts-list-with-subassemblies-formula-needed-bom
Sheet: Sheet1

Assembly Item Name | Component Item Name | Component Item Qty
RM-2-6048 | RM-012-2B | 1
RM-2-6048 | RM-012-3 | 1
RM-2-6048 | 06-2006-4 | 1
RM-2-6048 | 06-2005-8 | 1
RM-2-6048 | RM-012-6 | 1
RM-2-6049 | RM-2-6048 | 1
RM-2-6049 | RM-012-3 | 1
RM-2-6049 | 06-2005-4 | 1
RM-2-6049 | 06-2005-8 | 1
RM-2-6049 | RM-012-6 | 1
RM-2-6050 | RM-012-2B | 1
RM-2-6050 | RM-012-3 | 1
RM-2-6050 | 06-2006-11 | 1
RM-2-6050 | 06-2005-8 | 1
RM-2-6050 | RM-012-6 | 1
RM-2-6060 | [NAME] | 1
RM-2-6060 | RM-012-3S | 1
RM-2-6060 | 06-2006-4 | 1
RM-2-6060 | 06-2005-8 | 1
RM-2-6060 | RM-012-6 | 1
RM-2-6060 | F-2 | 0.54167
RM-2-6061 | RM-2-6048 | 1
RM-2-6061 | RM-012-3S | 1
RM-2-6061 | 06-2005-4 | 1
RM-2-6061 | 06-2005-8 | 1
RM-2-6061 | RM-012-6 | 1
RM-2-6061 | F-2 | 0.54167
Spreadsheet: 45501d1244224043-vlookup-order-list-test-5
Sheet: Order for FEDEX

WholeSale Order Form
Customer ID: |  |  | Name: |  |  |  | Date:
Shipping Information:
Attention:
Address:
City: |  | State: |  | Zip Code: |  | Country:
Phone Number: |  |  |  | [NAME]:
 | Order No. | Product Name | Weight (kg) | Unit Price | Quantity | Total Price | Total Weight(kg)
 | 1 | iPhone 3G 16GB (BLACK) | 1 | 735.7512953367876 | 1 | 735.7512953367876 | 1
 | 2 | iPhone 3G 16GB (BLACK) [LOGO] | 1 | 760.3626943005181 | 11 | 8363.9896373057 | 11
 | 3 | PLV-Z700C | 14 | 1476.683937823834 | 1 | 1476.683937823834 | 14
 | 4
 |  |  |  |  | Total Price: | 10576.42487046632 | 26
 | Bank Account Information |  |  |  | Country to Ship |  | Total Weight (kg)
 | Bank Name: |  |  |  | Japan |  | 26
 | Account No: |  |  |  | Price of Weight: | #N/A
 | Verifiy code: |  |  |  | Sum | #N/A
 |  |  |  |  | Declare Value:
Our Account Information |  |  |  |  | Type of Content: | [NAME] | Sample
Bank Name: |  | HSBC Hong Kong |  |  |  | Please delete the inapporiated option
Bank Address: |  | 1 Queen's Road Central, Hong Kong
Bank Code: |  | 004
SWIFT Address: |  | HSBCHKHHHKH
Spreadsheet: 849742d1700143542-help-to-analyse-30-past-lottery-draws-30-ms
Sheet: Plan1

10 | 23 | 30 | 31 | 49 | 56
11 | 17 | 23 | 36 | 47 | 51
14 | 32 | 41 | 43 | 48 | 60
13 | 23 | 26 | 29 | 45 | 59
6 | 23 | 35 | 36 | 37 | 59
9 | 18 | 29 | 37 | 39 | 58
6 | 11 | 26 | 32 | 46 | 56
20 | 44 | 45 | 46 | 56 | 59
9 | 33 | 39 | 43 | 50 | 54
18 | 28 | 30 | 39 | 41 | 58
8 | 22 | 34 | 42 | 51 | 59
4 | 17 | 22 | 28 | 30 | 49
2 | 10 | 29 | 31 | 56 | 59
8 | 13 | 31 | 33 | 49 | 50
9 | 24 | 34 | 39 | 45 | 50
4 | 8 | 10 | 27 | 28 | 32
2 | 8 | 11 | 22 | 48 | 49
9 | 30 | 34 | 44 | 54 | 55
1 | 2 | 10 | 32 | 34 | 59
5 | 16 | 38 | 42 | 43 | 48
6 | 11 | 29 | 37 | 56 | 58
8 | 27 | 28 | 32 | 48 | 56
2 | 23 | 25 | 33 | 45 | 54
5 | 10 | 27 | 38 | 56 | 57
14 | 26 | 36 | 39 | 50 | 53
14 | 18 | 22 | 26 | 31 | 38
11 | 32 | 35 | 40 | 41 | 48
5 | 14 | 32 | 40 | 53 | 54
13 | 25 | 31 | 43 | 57 | 58
1 | 9 | 13 | 16 | 52 | 59
Spreadsheet: 98011d1297110039-return-number-from-range-if-in-tolerance-replace-number-if-within-toler
Sheet: Sheet1

 |  | 32.66 | 32.67
 |  | 32.65 | 32.67
 |  | 32.68 | 32.67 |  |  | Description of process desired:
32.67 |  | 70.33 | 70.34 |  |  | I want to check the numbers in Col-C one at a time against the numbers within the range (A1:A12)i n Col-A. If the Col-B number is within a tolerance of any Col-A number, I want to store the Col-A number in Col-D. If the Col-B number not within the tolerance of any number in Col-A, then store the Col-C number in Col-D.
 |  | 70.35 | 70.34
 |  | 85.33 | 85.33
32.67 |  | 85.32 | 85.33
85.33 |  | 85.34 | 85.33
 |  | 70.33 | 70.34
 |  | 70.35 | 70.34
70.34 |  | 32.66 | 32.67
 |  | 32.65 | 32.67
 |  | 32.68 | 32.67 |  |  | Note:
 |  | 85.33 | 85.33 |  |  | There are duplicate numbers in Col-A and not all cells in Col-A range have numbers in them. The Col-C numbers will always be filled with numbers.
 |  | 85.32 | 85.33
 |  | 100 | 100
source |  | #'s to chg | results
Spreadsheet: 27e3ffbe-4c6d-47d0-a11f-a5355c57dd55
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | 注塑|零缺陷|高级技|术研|修班
 |  | ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
 |  | 时-间-地-点：2011年9月17-18日上海    9月24-25日深圳
 |  | 参-加-对-象：注塑企业总经理、注塑厂长、副总、注塑部经理/主管、注塑品质经理/主管、              注塑工程经理 /主管、注塑试模工程师、注塑生产工程师、注塑品质工程师、              注塑组长/领班/技术员等
 |  | 学-习-费-用：￥2600 /人（包括资料费、午餐及上下午茶点等）
 |  | 会-务-组-织：环v球d企r业r培v训r网h
 |  | 联-系-电-话：上海联系：O2l-3lOOl076 深圳联系：O755-6l28Ol79
 |  | ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
 |  | 课-程-背-景：
 |  | 注塑生产过程中经常出现各种品质缺陷和异常现象；长期以来，大多数注塑工作者仅凭
 |  | 经验处理，盲目调机时间长，原料浪费大，对一些问题缺乏科学系统地分析。注塑加工
 |  | 是一门知识面广、技术性强的行业，仅凭经验是不够的。" 注塑缺陷原因分析与解决方
 |  | 案"高级学术讲座是专为学习处理各种注塑缺陷和异常问题处理方法、提高分析问题/处
 |  | 理问题能力的注塑技术/管理人员而开设。
 |  | 内容独特:
 |  | 1.基于美国注塑成型专业训练多媒体，全面集中国内外注塑成型工艺、注塑成型机械及
 |  | 塑胶材料方面的企业、专家和学者的智惠与经验；
 |  | 2.高度智能化的互动式多媒体平台，同时具有声音、图片和文字表达效果；
 |  | 3.宏观与微观的全方位解析，过程的动态显示，全真展现成型现场所不能看到的内容
 |  | ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
 |  | 课-程-特-色：
 |  | 1. 全面融合模型具设计与注塑现场生产技能,为企业培养模具与注塑的技术专家。学员
 |  | 可以自带样品参加课程，课程中选出有代表性的案例进行详细解答；
 |  | 2. [NAME]~练多媒体，全面集中国内外注塑模具、注塑成型工艺、注
 |  | 塑成型机械及塑料材料方面的企业、专家和学者的智能与经验；
 |  | 3. 高度智能化的交互式多媒体平台，同时具有声音、图片和文字表达效果；
 |  | 4. 宏观与微观的全方位解析，过程的动态显示，全真展现成型现场所不能看到的内容。
 |  | ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
 |  | 讲-师-简-介：[邓-益-善]
 |  | 邓益善先生中国杰出注塑技术、模具设计优化技术培训实战专家，硕士，先后在美、德、
 |  | 台资外企、从事相关工作多年，历任工程师、主管、经理等职务，在设计生产一线多年
 |  | 摸爬滚打，并在咨询顾问中积累了丰富的经验，尤其深谙注塑缺陷原因分析与解决方案、
 |  | 模具设计优化技术，对注塑机械、塑料材料具有相当的技术功底，形成了独具特色的实
 |  | 干型模具/注塑技术方法和体系。邓老师实践经验丰富、讲授过程列举大量案例 特别强
 |  | 调实用性和可操作性，深受听课人员的好评和尊敬。至今李老师为满足企业的实际需要，
 |  | 先后举办了注塑技术、模具设计优化技术方面的内训、公开课程共计600多场，参训企业
 |  | 4000家左右，培养了一大批优秀的企业技术人才 目前主要分布在上海、深圳、广东、江
 |  | 浙地区大中型生产型企业 为国内企业生产技术培训工作做出了突出贡献，实实在在为企
 |  | 业解决了设计与生产难题。
 |  | ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
 |  | 课-程-大-纲：
 |  | 第一部分：注塑成型工艺基础
 |  | 1.温度、压力、速度与冷却控制的目的、操作与结果；
 |  | 2.注塑机设定的调整如何影响工艺与品质；
 |  | 3.优化螺杆控制设定；
 |  | 4.多段充填与多段保压控制；结晶、非结晶与分子/纤维排向对工艺及品质的影响；
 |  | 5.内应力、冷却速度、塑料收缩对塑件品质的影响；
 |  | 6.塑料流变力学：塑料如何流动、排向与改变粘度，剪切与分子/纤维排向关系；
 |  | 7.浇注系统、冷却系统、模具结构与注塑工艺之间的关系。
 |  | 第二部分：模塑现场问题分析与解决对策
 |  | 缩孔、缩水、不饱模、毛边、熔接痕、银丝、喷痕、烧焦、翘曲变形、开裂/破裂、尺寸
 |  | 超差及其它常见注塑问题描述、原因分析，以及在模具设计、成型工艺控制 、产品设计
 |  | 及塑料材料等方面之解决对策。
 |  | 1. 注塑件周边缺胶、不饱模的原因分析及解决对策；
 |  | 2. 批锋（毛边）的原因分析及解决对策；
 |  | 3. [NAME]；
 |  | 4. 银纹（料花、水花）、烧焦、气纹的原因分析解决对策；
 |  | 5. 注塑件表面水波纹、流纹（流痕）的原因分析及解决对策；
 |  | 6. 注塑件表面夹水纹（熔接痕）、喷射纹（蛇纹）的原因分析及解决对策；
 |  | 7. 注塑件表面裂纹（龟裂）、顶白（顶爆）的原因分析及解决对策；
 |  | 8. 注塑件表面色差、光泽不良、混色、黑条、黑点的原因分析及解决对策；
 |  | 9. 注塑件翘曲变形、内应力开裂的原因分析及解决对策；
 |  | 10. 注塑件尺寸偏差的原因分析及解决对策；
 |  | 11. 注塑件粘模、拖花（拉伤）、拖白的原因分析及解决对策；
 |  | 12. 注塑件透明度不足、强度不足（脆断）的原因分析及解决对策；
 |  | 13. 注塑件表面冷料斑、起皮（分层）的原因分析及解决对策；
 |  | 14. [NAME]；
 |  | 15. 喷嘴流涎（流涕）、漏胶、水口拉丝、喷嘴堵塞、开模困难的原因分析及改善措施；
 |  | 16. 利用CAE模流分析技术快速地有效解决注塑现场问题。
 |  | 第三部分：模具优化设计与使用
 |  | 1. [NAME]；
 |  | 2. 浇注系统（浇口、流道、冷料井等）优化设计；
 |  | 3. 冷却系统（水路、隔水片、铍筒等）优化设计；
 |  | 4. 缩水率的设定与调整；
 |  | 5. 浇注系统、冷却系统、模具结构与注塑工艺之间的关系；
 |  | 6. 模具的安装、调试工作和维护保养；
 |  | 7. 利用CAE模流分析技术进行模具优化设计。
 |  | 第四部分：模塑新工艺相关
 |  | 1. 热流道技术应用及相关问题解决；2.双色成型技术应用及相关问题解决；
 |  | 2. 气体辅助成型技术应用及相关问题解决；
 |  | 第五部分：案例分析
 |  | 如您不需要此类邮件,请发送“取消”至：[EMAIL] 我们将尽快为您删除！
Spreadsheet: 876356d1723041319-issues-with-conditional-formatting-xxblankxx-helpsample
Sheet: Sheet1

Start Time | Run Time | End Time | 01:00:00 | 01:15:00 | 01:30:00 | 01:45:00 | 02:00:00 | 02:15:00 | 02:30:00 | 02:45:00 | 03:00:00 | 03:15:00 | 03:30:00 | 03:45:00 | 04:00:00 | 04:15:00 | 04:30:00 | 04:45:00 | 05:00:00 | 05:15:00
01:00:00 | 1.25
02:15:00 | 2
04:15:00 | 1
Spreadsheet: sally_beck__33707__Metrics 0616
Sheet: Energy Capital Res.

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | Energy Capital Resources
Results based on Activity through June 16, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 11
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  | 0 | 11 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0
- Exits |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
- Executions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending
 | Dollar Value of Transactions
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Average
Postings Rollforward:
Beginning |  | 100.5
+ Entrances |  | 0 | 14.3 | 1
- Exits |  | 0 | 0 | 0
+/- [NAME] |  | 0 | 0 | -13
- Executions |  | 0 | 0 | 0
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 1 | 0.1 |  | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | 0.8 |  |  | 2.325 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 1 | 0 |  |  | 5 | 0 |  | 6 | 0 |  |  |  |  | 0 | 0
Identified Margin
Budget |  | 10.3
$ Coverage
$ millions
Spreadsheet: 697721d1601489865-need-help-to-make5-functions-in-same-cell-operation-account
Sheet: CUSTOMER CODES

 |  |  | CUSTOMER CODES
 |  |  | NAME | CODE | MOBILE | Column1 | Column2 | NAME3 | CODE4 | Column5 | Column6 | Column7
 |  |  | PAYMENT | 10000
 |  |  | [NAME] | 1001
 |  |  | fatn | 1002
 |  |  | world | 1003
 |  |  | [NAME] | 1004
 |  |  | sha3ban | 1006
 |  |  | madi | 1005
 |  |  | soli | 1007
 |  |  | uni | 1009
 |  |  | zai | 1008
Spreadsheet: 714734d1611339898-using-index-match-and-match-and-return-the-value-between-two-numbers-index-match-match-sample
Sheet: Sample

 |  | New Sku # |  |  |  |  |  | Price Break Quantities
 |  |  |  |  |  |  |  | 10 | 20 | 30 | 40 | 50 |  |  | Sku # | Quantity | Price
 |  | APPLE |  |  |  |  |  | 0.1 |  |  |  |  |  |  | APPLE | 10
 |  | ORANGE |  |  |  |  |  |  |  |  |  |  |  |  | APPLE | 15
 |  | BANANA |  |  |  |  |  |  |  |  |  |  |  |  | APPLE | 20
 |  | LEMON |  |  |  |  |  |  |  |  |  |  |  |  | LEMON | 30
 |  | LIME |  |  |  |  |  |  |  |  |  |  |  |  | LIME | 55
 |  | GRAPEFRUIT
 |  | GRAPES
 |  | KIWI
 |  | WATERMELON
 |  | STRAWBERRY
Spreadsheet: 78836d1279132914-weighted-average-in-a-pivot-table-example-pivot-table
Sheet: Raw - Data

 |  | Scores given from Customer on Tech (1-10 Scale)
Work Order # | Tech # | Statusing | Appearance | Clean Up | Verify System | Explain Basic
24175643600002001 | 010434315 | 10 | 10 | 10 | 10 | 10
24558261600083001 | 010439230 | 10 | 10 | 10 | 10 | 10 |  | This data are the true scores, but when the Technicians get their average, it is actually a weighted average.  Everything below 7 is counted as a 0.
24426165200063010 | 010439857 | 10 | 10 | 10 | 7 | 10
24426622000007011 | 010436895 | 10 | 10 |  |  | 5
24426220700008013 | 010434011 | 10 | 10 | 10 | 10 | 10
24416420000077001 | 010439857 | 10 | 10 | 10 | 10 | 10
24572613900000013 | 010439889 | 10 | 8 | 10 | 10 | 10
24055600200006001 | 010436895 | 8 | 8 | 8 | 9 | 8
24151374105032017 | 010438940 | 10 | 10 |  |  | 10
24112763400004024 | 010438940 | 10 | 10 | 10 | 10 | 10
24426540300018021 | 010434011 | 1 | 10 | 8 | 10 | 10
24501551100018001 | 010436687 | 10 | 10 | 10 | 10 | 10
24065352600014001 | 010432971 | 6 | 6 | 6 | 6 | 6
24153544400012001 | 010439568 | 10 | 10 | 10 | 10 | 10 |  | We want to retain the actual score on the raw data sheet, that is not to be lost, but when it is put into the pivot table, the 0-6 need to count as 0, while the 7 counts as a 7 and the 8 as an 8 ect up to 10.
24153161000038001 | 010434315 | 10 | 10 | 10 | 10 | 10
24577304000010007 | 010439230 | 6 | 5 | 5 | 2 | 5
24416454400029004 | 010439568 | 10 | 10 | 10 | 10 | 10
24572262700040004 | 010432971 | 10 | 8 |  |  | 8
24055305900017002 | 010430500 | 10 | 10 |  |  | 10
24055600200014001 | 010430500 | 10 | 10 | 10 | 10 | 10
24104354400014006 | 010439829 | 10 | 10 | 10 | 10 | 10
24065351400002001 | 010439568 | 10 | 10 | 10 | 10 | 10
24121522200019001 | 010439829 | 10 | 10 | 3 | 10 | 4
23934241000010001 | 010439230 | 10 | 10 | 10 | 10 | 10
24416200400067001 | 010434011 | 10 | 10 | 10 | 10 | 10
24450713100005007 | 010434011 | 10 | 8 |  |  | 1
24426751900001039 | 010436687 | 10 | 8 | 10 | 10 | 10
24563213805160001 | 010439889 | 7 | 10 | 10 | 10 | 10
24502130100008001 | 010436895 | 10 | 10 | 10 | 10 | 10
24141808600005003 | 010436835 | 10 | 10 | 10 | 10 | 10
23947504500005004 | 010439230 | 10 | 10 |  |  | 10
24416120705066005 | 010434011 | 10 | 10 | 10 | 10 | 10
24502281000072001 | 010431849 | 10 | 10 | 9 | 10 | 10
24502220000027002 | 010434315 | 3 | 4 | 5 | 6 | 7
24502163700039004 | 010436524 | 10 | 10 |  |  | 10
24517103600024003 | 010436524 | 10 | 10 |  |  | 10
24092372400001012 | 010436895 | 10 | 10 |  |  | 10
24092393500003001 | 010436895 | 10 | 10 | 10 | 10 | 10
24018373300007046 | 010436895 | 10 | 10 | 10 | 10 | 10
24067570800012012 | 010434315 | 10 | 10 |  |  | 10
24175626500005030 | 010432971 | 10 | 10 | 10 | 10 | 10
24426751900001040 | 010434011 | 10 | 10 |  |  | 10
Spreadsheet: 87149d1287019966-detect-if-entries-have-duplicate-criteria-detect-duplicate-criteria-v3
Sheet: Sheet1

Item | AppGroup | OK to treat like app? |  |  | Item | AppGroup | App | [NAME] | Supported By | HIDE COLUMNS
1 | BIEM | Y | should be Y |  | 1 | BIEM | Excel | [NAME] | [NAME] | MS SupportJoe | 3
2 | Maximo | Y | should be N |  | 2 | BIEM | Word | [NAME] | [NAME] | MS SupportJoe | 3
 |  |  |  |  | 3 | Maximo | [NAME] | [NAME] | [NAME] | MS SupportJoe | 3
 |  |  |  |  | 4 | Maximo | [NAME] | [NAME] | [NAME] | [NAME] | 1
 |  |  |  |  | 5 | Maximo | Alon | IBM Support | [NAME] | IBM SupportJane | 1
Spreadsheet: 781809d1653560249-trying-to-find-formula-to-correctly-calculate-shift-crossing-midnight-sample-duty-crossing-midnight-copy
Sheet: Sheet1

start | end | how many hours before midnight | how many hours after midnight | total hours | adding hours before mn to hours after mn | [NAME] for Hours before Midnight | [NAME] for hours after midnight | does shift cross midnight | if after midnight
20:00:00 | 1900-01-01 00:00:00 | 4 | 0 |  |  |  |  |  |  | not after midnight
17:00:00 | 23:00:00 | 6 | 0
17:00:00 | 02:00:00 | 7 | 2
02:00:00 | 04:00:00 | 0 | 2
23:00:00 | 00:00:00 | 1 | 0 |  |  |  |  |  |  | not after midnight
14:00:00 | 21:00:00 | 7 | 0
19:00:00 | 00:00:00 | 5 | 0 |  |  |  |  |  |  | not after midnight
00:00:00 | 01:00:00 | 0 | 1
20:00:00 | 06:00:00 | 4 | 6
Spreadsheet: 13cddb96-6606-4951-83e3-138b542b5354
Sheet: Sheet1

Table 3--U.S. monthly average farm prices and marketings | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  | 2012/13 |  |  |  | 2011/12 |  |  |  | 2010/11
Month |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August |  | 14.6 |  | 10856 |  | 13.6 |  | 11434 |  | 11.7 |  | 10691
September |  | 14.3 |  | 10630 |  | 14.4 |  | 12704 |  | 11 |  | 15095
October |  | 14.2 |  | 14547 |  | 14.9 |  | 12070 |  | 11.5 |  | 17131
November |  | 14.4 |  | 15772 |  | 15.3 |  | 11404 |  | 12.6 |  | 16929
December |  | 14.6 |  | 15163 |  | 15 |  | 14624 |  | 13.9 |  | 19137
January |  | 14.5 |  | 18693 |  | 15.2 |  | 15053 |  | 14 |  | 21806
February |  | 14.8 |  | 14029 |  | 14.1 |  | 13555 |  | 13.4 |  | 14847
March |  | 15 |  | 13775 |  | 14.1 |  | 14682 |  | 13 |  | 15844
April |  | 15.2 |  | 12444 |  | 14.4 |  | 13311 |  | 13.1 |  | 12727
May |  | 15.3 |  | 11143 |  | 14.1 |  | 13127 |  | 12.7 |  | 14227
June |  | 15.4 |  | 10123 |  | 14.2 |  | 10510 |  | 12.1 |  | 11317
July |  | 15.4 |  | 1/ |  | 14.4 |  | 11380 |  | 12.9 |  | 12369
Average price to date |  | 14.80833333333334 | 2/
Season average farm price |  | 14.9 | 3/ |  |  | 14.5 |  |  |  | 12.7
Average Marketings |  |  |  | 13379.54545454545 |  |  |  | 12821.16666666667 |  |  |  | 15176.66666666667
Total volume marketed |  |  |  | 147175 |  |  |  | 153854 |  |  |  | 182120
N/A = Not available.
1/ Mid-month only.  2/ Simple average.  3/ Mid-point of season-average farm price projection range.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated August 12, 2013.