tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 829680d1684389291-excel-formula-to-calculate-period-in-months-and-days-between-two-dates-vat-before-registration
Sheet: Sheet1

 | Kindly asking for excel formula that calculate the period between two dates in months and days as shown in desired solution in column E and F
 | Purchese | Date of Purchase | Date of VAT Registration | Number of months | Within 6 months
 | Stationery | 2021-06-02 00:00:00 | 2022-01-01 00:00:00 | 6 months, 30 days | No input tax credit
 | Double cab vehicle | 2021-09-09 00:00:00 | 2022-01-01 00:00:00 | 3 months, 23 days | Claim input tax credit
 | Computer desk | 2021-06-16 00:00:00 | 2022-01-01 00:00:00 | 6 months, 16 days | No input tax credit
 | 20 Laptops | 2021-09-09 00:00:00 | 2022-01-01 00:00:00 | 3 months, 23 days | Claim input tax credit
 | Office cartridges | 2021-09-30 00:00:00 | 2022-01-01 00:00:00 | 3 months, 2 days | Claim input tax credit
Spreadsheet: 740228d1626249316-how-to-average-the-probability-severity-and-risk-of-a-group-of-data-how-to-average-the-probability-severity-and-risk-of-a-group-of-data-edit
Sheet: Accident List

Accident Reference | Accident Title | Accident Description | Associated Hazard
A01 | Electrocution | Acc Des 1
A02 | Blast Injury (non-OME) | Acc Des 2
A03 | Burns | Acc Des 3
A04 | Musculosketel Injury (Acute) | Acc Des 4
A05 | Health Issues (Chronic Conditions) | Acc Des 5
 |  |  | AAA_H07 - Handling of Equipment (In Use)
 |  |  | AAA_H12 - Repetitive tasks
A06 | Lacerations & Bruises | Acc Des 6
 |  |  | AAA_H06 - Handling of Equipment (Transit)
 |  |  | AAA_H07 - Handling of Equipment (In Use)
 |  |  | AAA_H08 - Trap & Pinch Points
 |  |  | [NAME]
A07 | Trap / Crush / Impact Injury | Acc Des 7
A08 | Eye Irritation / Eye Damage | Acc Des 8
 |  |  | AAA_H03 - Materials & Substances used during Manufacture and Maintenance
 |  |  | AAA_H04 - Ionising & Non-ionising Radiation
A09 | Respiratory Injury | Acc Des 9
 |  |  | AAA_H03 - Materials & Substances used during Manufacture and Maintenance
 |  |  | AAA_H04 - Ionising & Non-ionising Radiation
A10 | Skin Irritation | Acc Des 10
 |  |  | AAA_H04 - Ionising & Non-ionising Radiation
 |  |  | AAA_H07 - Handling of Equipment (In Use)
A11 | Blast Injury (OME) | Acc Des 11
Spreadsheet: 808262d1670373667-product-of-two-columns-if-column-a-is-entry-is-text-get-value-from-another-column-s666-pq-product-of-two-columns-if-column-a-is-entry-is-text-get-value-from-another-column
Sheet: Sheet1

 | any number | get this if column B is text |  |  |  | product
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Column1 | Column2 | Column3 | Result
Column1 | Column2 | Column3 |  |  |  |  |  | <- problem if column is text , get value from column D |  |  |  |  |  | abc | 2 | 3 | 6
abc | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 |  | 6
2 | 3 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 |  | 12
3 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 5 |  | 20
4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 6 |  | 12
2 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 7 |  | 21
3 | 7 |  | column B x column E |  |  |  |  |  |  |  |  |  |  | 4 | 8 |  | 32
4 | 8 |  |  |  |  |  | expected output |  |  |  |  |  |  | Total
 |  |  | single shot fromula
Spreadsheet: dana_davis__4474__CANADA - 46L - A
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 46L
COMPANY NAME:  SUNDANCE ECT CANADA ACCOUNTING ENTITY
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
FOR THE 3 MONTHS ENDED 3-31-2000
PREPARED BY:  ROSALYN LUM
EXTENSION: [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-99 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other
Gross PP & E
Accumulated DD & A
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
 |  |  |  |  |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: 844557d1696337228-hi-i-need-a-few-things-adding-or-changing-on-this-fishing-results-workbook-please-golborne-results
Sheet: 4

Name | lbs | oz | Oz (total) | Points
 | 21421
 | 443251
 | 5315
 | 5
 | 5415
 | 541
 | 351
 | 15
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 859123d1707578265-not-sure-if-this-data-validation-and-if-argument-is-even-possible-but-test-4-
Sheet: data

 |  |  |  | part code |  | std | enh
 |  |  |  | 1 |  | 1 | 2
 | range |  |  | 1e |  | 2 | 3
 |  |  |  | 2 |  | 2 | 3
 | standard |  |  | 2e |  | 3 | 4
 | paint to order |  |  | 3 |  | 3 | 4
 |  |  |  | 3e |  | 4 | 5
 |  |  |  | 4 |  | 4 | 5
 |  |  |  | 4e |  | 5 | 6
 |  |  |  | 5 |  | 5 | 6
 |  |  |  | 5e |  | 6 | 7
 |  |  |  | 6 |  | 6 | 7
 |  |  |  | 6e |  | 7 | 8
 |  |  |  | 7 |  | 7 | 8
 |  |  |  | 7e |  | 8 | 9
 |  |  |  | 8 |  | 8 | 9
 |  |  |  | 8e |  | 9 | 10
 |  |  |  | 9 |  | 9 | 10
 |  |  |  | 9e |  | 10 | 11
Spreadsheet: 0f7e94b7-0281-4ce0-8619-6a87e7b9b619
Sheet: Sheet1

International Programs Grant - Student Travel Budget | Unnamed: 1
Please be as detailed as possible and provide relevant documentation.  [NAME] additional lines as necessary.
Student name:                                         Dates of travel:
Item | Amount
1. Transportation – provide information on travel to and from and within course country/countries
Outbound/inbound travel:
In-country travel:
Mileage to & from airport and/or airport parking, shuttle, etc.
Other (departure tax, etc.):
Total transportation | 0
2. Accommodation - provide name of hotel(s) and rates for each; if not staying in hotel, please describe.
name:  ___ nights @ $_______ per night
name:  ___ nights @ $_______ per night
Total accommodation | 0
3. Meals - estimate food costs; www.lonelyplanet.com may be helpful
___ days @ $________ per day
___ days @ $________ per day
Total meals | 0
4. Other - please itemize (e.g. immunizations, visa fees, etc.)
Insurance* (iNext required @ $1.40 per day + $5.00 per month)
Total other | 0
TOTAL BUDGET | 0
5. If receiving funding from other sources, list source and amount.
Amount requested from International Programs | 0
* insurance form will be sent to you upon awarding of grant
Spreadsheet: 26d408c7-1c18-49a3-8e60-cc55d4866954
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
[NAME]。
所在单位： |  | 姓名： | 联系电话：
培训类别 | [NAME] | 内容简介 | 承办部门 | 培训地点 | 拟选主讲人 | 是否有兴趣参加（打√） | 教师希望的培训时间 | 备注
教学能力 | Teaching Methods in Western Universites | 由来自西方高校的教授带来展示，共同探讨其在课堂教学实践中的一些先进经验 | 教师发展中心 | 待定 | [NAME]
 | 培养思辨能力、跨文化能力和互动课堂教学工作坊 | 计划与美国高等教育价值观学会（Society for Values in Higher Education）合作举办，在2013年6-7月，面向校内外教师举办研讨会，探讨课堂中组织促进学生思辨性、跨文化式互动活动等教学方面的先进理念 | 教师发展中心、英文学院、英教学院、继续教育学院
 | [NAME] | 主要介绍升级后新BB系统的使用入门；基本功能；课件制作、工具设置与使用；交流工具使用；学生作业与试题管理使用；新增功能以及移动平台的使用方法、用户管理及资源库使用等等 | 教育技术中心 | 北校区、南校区 | BB公司讲师、教育技术中心工作人员
教学能力 | 卫星录播系统的使用 | 卫星录播系统的软件安装，操作使用，资源利用，录制和上传节目申请，教学课件的制作与上传，常见问题的解决，教师权限的开通。 | 教育技术中心 | 北校区、南校区 | 张若珣、陈远祥
 | 数字语言实验室授课及考试系统（2003型） | 北校语言实验室2003型数字语言实验室系统日常授课使用及考试的方法 | 教育技术中心 | 北校区 | 郑燕
 | 数字语言实验室授课及考试系统（2009型） | 北校语言实验室2009型数字语言实验室系统日常授课使用及考试的方法 | 教育技术中心 | 北校区 | 李苏梅
 | 同声传译实验室的小型会务应用 | 同声传译实验室的日常使用及做为小型会议会场使用的方法 | 教育技术中心 | 北校区 | [NAME]
 | ERP沙盘模拟系统实践 | ERP沙盘模拟课程是集知识性、趣味性、对抗性于一体的企业管理技能训练课程。内容涉及企业整体战略、产品研发、生产、市场、销售、财务管理、团队协作等多个方面。 | 教育技术中心 | 南校区 | 张晓明、李别
 | 数字语言实验室授课系统 | 介绍newclass及蓝鸽语音系统课堂授课操作，对各功能特点进行详细说明，帮助授课教师充分利用软件提供的各项功能。利用数字化语言实验室进行自主学习，包括音频、视频、文本、软件字典等资源的使用 | 教育技术中心 | 南校区 | 黄伟波
教学能力 | 语言实验室手动与自动考试系统 | 介绍考试系统的功能及试卷制作、导入、考试、收卷及阅卷等各项操作流程，方便授课老师随堂测试及期末考试。 | 教育技术中心 | 南校区 | 黄伟波、陈春回
 | 音频资源的采集与处理 | 本课题针对语言类专业的老师，在教学中常常需要处理和利用各种音频资源的技术问题，介绍基于普通电脑及音频处理软件进行的音频资源采集处理技术以满足教师日常教学资源应用需求。课题主要介绍内容包括：电脑软件录音、采集各种数字媒体和网络资源的声音、声音格式的转换、声音基本编辑、声音效果处理等。 | 教育技术中心 | 南校区 | 梁俏
科研水平 | OPAC系统使用 |  | 图书馆
 | [NAME] |  | 图书馆
 | 如何利用SSCI等分析数据库进行课题申报与科研创新 |  | 图书馆
 | 国际学术规范类讲座 | 通过邀请专家开办讲座，旨在帮助我校教师了解国际学术研究惯例，提高国际化科研水平和符合国际学术论文写作规范的能力 | 教师发展中心
科研水平 | 各级科研项目申报技巧培训 | 针对教师在申报科研项目时常见误区进行讲解，并邀请有经验教师对申报技巧进行传授 | [NAME]
 | 国家级重大项目团队负责人经验交流会 |  | [NAME]
 | 申报各级科研项目经验交流会 |  | [NAME]
 | 科研创新团队经验交流会 |  | [NAME]
 | 出国留学英语培训班 | 旨在全面提高我校教师英语听、说、读、写的能力，为出国留学、参与国家学术交流提前做好准备 | 人事处、教师发展中心、国际学院
 | 统计学基础 | 讲授统计学基本知识，培养教师掌握科学研究方法和统计分析意识 | 教师发展中心
 | 高级统计方法在科学研究中的运用 | 针对具备一定统计学基础的教师，重点讲授科学统计方法在实际中的运用，如结构方程等 | 教师发展中心
 | 中青年教师科研能力提升系列讲座 | 邀请校内外专家围绕国际学术研究规范和标准的主题举办讲座，如论文规范化写作等 | 教师发展中心
通识教育 | 著名教授论坛 | 邀请国内外著名专家、学者进行多个领域的学术讲座 | 人事处、教师发展中心
职业幸福感 | 教师心理援助服务 | 采取一对一的交流形式，旨在为教师提供心理援助，及时疏导负面情绪，提升正能量 | 教师发展中心、心理健康教育与咨询中心 |  |  |  |  | 每周四晚7:30-9:30，采取预约制
 | 教师健康知识讲座 | 针对目前许多教师的身体状况处于亚健康状态的情况，结合教师的职业特点，定期开办健康讲座，促使教师关注自己的身心健康 | 教师发展中心
 | 女性健康讲堂 | 帮助我校女性教师获得如何在重压下调整心情，掌握健康生活的秘诀；如何更好地爱护自己，关心自己，掌握幸福的主动权 | 教师发展中心
 | 嗓子保护技巧培训班 | 培训内容主要包括：口语发声基础理论；气息要求及用气发声训练；声音美化与共鸣的运用；语气表达与声音弹性的训练等。 | 教师发展中心 |  |  |  |  | 聘请星海学院彭莉佳教授任教
 | 青年教师职业规划辅导 | 通过邀请职业规划领域的专家以及个人专业发展特别优秀及突出的教师，帮助青年教师明确自身发展方向和不同阶段职业特点，促进青年教师更快成长 | 教师发展中心
其他 | 岗前培训 | 针对新来校教职工，进行校情培训，了解学校校史、校情，并进行政策解析 | 人事处、教师发展中心
 | 云山教师沙龙 | 定期发布、规模灵活、形式多样、自由参与，旨在提升教师专业素养，促成学术小团体的形成与发展 | 教师发展中心 |  |  |  |  | 3月份举办“退休老校长的期望——与青年教师商榷”沙龙活动，特邀黄建华老校长参加
 | 摄影入门和后期制作 | 活动、会议摄像的基本操作和注意事项，后期编辑的基本思路和方法 | 教育技术中心 | 北校区 | 叶柳青、郭子儒
 | 办公软件实际操作（高级班） | 旨在提高教职工对常用办公软件（如office等）的应用能力和操作水平 | 教师发展中心、教育技术中心
 | 专家学者提升媒体运用能力讲座 | 聘请校内外专家来校讲座，旨在使专家学者适应全媒体时代的需要，提升以专业知识服务社会的能力 | 宣传部 | 待定 | 知名媒体人
 |  |  |  |  |  |  |  | 如您还有其他希望获得的培训内容，请在空白处列出。当达到一定人数，教师发展中心将会贯彻“自助式”培训模式精神，为有需要的教师组织开办相关培训项目
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635
3531 | -151832 | -80910
60667
60749 | 202523 | 65990
61206
61334 | -25143
62960
INDEX
2001-07-31 00:00:00 |  |  | 727828
2001-08-06 00:00:00
CBS Volume
 |  |  | 88624
Spreadsheet: theresa_staab__39602__North Finn email
Sheet: Summary

in |  | [NAME] To: |  |  | Remit To:
 |  |  |  |  | North Finn LLC | Verification Date:
 |  | Enron North America Corp. |  |  | Hilltop National Bank | 2001-12-06 00:00:00
 |  |  |  |  | Routing #10230119
 |  |  |  |  | Account #021674 | Due Date:
 |  |  |  |  | Country Club Rd. | 2001-12-26 00:00:00
 |  |  |  |  | Casper, WY  82609
 |  |  |  |  |  | Payment Method:
 |  | Contact:  [NAME] |  |  | Attn:  [NAME] | Wire
 |  | Tel:  (303) 575-6485 |  |  | Phone:  (307) 237-7854 | Terms:
Enron North America Corp. |  | Fax: (303) 534-0552 |  |  | E-mail:  [EMAIL] | On or before 25th of month
2001-12-06 14:50:31.580000
Delivery Period: | Contract # | Meter # / Meter Name
2001-11-01 00:00:00 | [NAME] | 0814042-Palomino #3 Discharge Mtr
 | Index | Discount / Premium | Price/MMBtu | Mcf Quantity | MMBtu Quantity | Amount Due
11/01/01 - 11/30/01 | CIG GD | -0.646 | 1.142798246473354 | 21764.39878288885 | 20416 | 23331.369
11/01/01 - 11/30/01 |  | Fuel Loss | $             0.00 | 2059.601217111151 | 1932 | $                                        0.00
 |  |  |  | 24077.19124463194 | 22348 | 23331.369
 |  |  | TOTAL PAYMENT |  |  | 23331.369
Spreadsheet: dutch_quigley__9412__NymexPos
Sheet: Crude Futures

CRUDE FUTURES
2001-12-01 00:00:00
2002-01-01 00:00:00 | -1445
2002-02-01 00:00:00 | -4037
2002-03-01 00:00:00 | -1693
2002-04-01 00:00:00 | -1015
2002-05-01 00:00:00 | -747
2002-06-01 00:00:00 | -2660
2002-07-01 00:00:00 | -81
2002-08-01 00:00:00 | -141
2002-09-01 00:00:00 | -7
2002-10-01 00:00:00 | -173
2002-11-01 00:00:00 | -63
2002-12-01 00:00:00 | -1393
2003-01-01 00:00:00 | -1043
2003-02-01 00:00:00 | 200
2003-03-01 00:00:00 | -250
2003-04-01 00:00:00 | 0
2003-05-01 00:00:00 | -25
2003-06-01 00:00:00 | -78
2003-07-01 00:00:00 | -15
2003-08-01 00:00:00 | -15
2003-09-01 00:00:00 | 85
2003-10-01 00:00:00 | -15
2003-11-01 00:00:00 | -15
2003-12-01 00:00:00 | -771
2004-06-01 00:00:00 | 100
2004-12-01 00:00:00 | -285
2005-12-31 00:00:00 | 1024
2006-12-01 00:00:00 | -725
2007-12-31 00:00:00 | 284
TOTAL
Spreadsheet: 680238d1590868249-cell-refrencing-another-sheet-using-variables-my-workbook-example-1-
Sheet: Sheet1

Item number: | Description / name | units | cost | sub total | Item cost
 | // bellow is a name that I can be looking for (b4)
1 | Car:
 | chassis | 1 | 500
 | body | 1 | 300
 | headligts | 2 | 50
 | // same here (b10)
2 | Bike:
 | frame |  | ___
 | handlebar |  | ___
 | lights |  | ___
3 | Another name
4
Spreadsheet: 69990d1270651949-how-to-change-cell-values-based-on-a-set-number-2009-8teams-
Sheet: WEEK 5B

MUV | BET TEAM | VS TEAM | GAME 1 | [NAME] | G1 $ Win | [NAME] | G1 $ Risk | G1   Result | GAME 2 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G2 Result | GAME 3 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G3 Result | TOT Units Risked | TOT Units Won | TOT Units Lost | TOT Unit Profit | TOT $$$ Profit
0 | NYY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | BOS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | MIN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | CHC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | WAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | PIT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | KC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | SD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
RETURN TO MLB OVERALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT L | 0 | 0
WEEK 5B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT W | 0
Spreadsheet: 830035d1684655738-need-simple-formula-that-sums-up-balances-based-on-date-sample30
Sheet: Sheet1

 |  | Table 1 |  |  | Table 2
 |  | Date | Amount |  | Column1 | Total | Answer |  | Date | sum
 |  | 2023-04-15 00:00:00 | 11.01 |  | Jan |  |  |  | balandis | 278.09
 |  | 2023-04-17 00:00:00 | 101.55 |  | Feb |  |  |  | gegužė | 1165.17
 |  | 2023-04-23 00:00:00 | 76.31 |  | Mar
 |  | 2023-04-28 00:00:00 | 89.22 |  | Apr |  | 278.09
 |  | 2023-05-02 00:00:00 | 505.97 |  | May |  | 1165.17
 |  | 2023-05-05 00:00:00 | 404.21
 |  | 2023-05-07 00:00:00 | 21.09
 |  | 2023-05-08 00:00:00 | 33.39
 |  | 2023-05-12 00:00:00 | 41.91
 |  | 2023-05-15 00:00:00 | 101.83
 |  | 2023-05-18 00:00:00 | 56.77
Spreadsheet: 798252d1664381259-making-a-cell-blank-if-adjacent-cell-is-blank-while-still-keeping-the-formula-excelforum-help-aligw
Sheet: Sheet1

 |  |  | Results
PLT-3101-00 | 1 |  | PLT-3101-00
PLT-15506-00 | 1 |  | PLT-15506-00
PLT-20076-00 | 2 |  | PLT-20076-00
PLT-22578-00 | 1 |  | PLT-20076-00
PLT-22579-00 | 1 |  | PLT-22578-00
PLT-22584-00 | 1 |  | PLT-22579-00
PLT-22589-00 | 1 |  | PLT-22584-00
PLT-22600-00 | 1 |  | PLT-22589-00
Spreadsheet: 868064d1714761506-formula-spill-book1
Sheet: Sheet1

PRODUCT CODE | PRODUCT NAME |  |  |  |  |  |  | PRODUCT CODE | PRODUCT NAME
AAA |  |  |  |  |  |  |  | AAA | 100
BBB |  |  |  |  |  |  |  | BBB | 200
CCC |  |  |  |  |  |  |  | CCC | 300
DDD |  |  |  |  |  |  |  | DDD | 400
 |  |  |  |  |  |  |  | EEE | 500
Spreadsheet: 753082d1635240785-index-match-with-multiple-criteria-exact-for-text-and-greater-than-value-for-number-test-index-match-problem
Sheet: Feuil1

Date | Time | Description | No of trays
2021-06-07 00:00:00 | 12:00:16 | Verrines | 28 |  | Criteria
2021-06-07 00:00:00 | 12:05:16 | Verrines | 32 |  | 1 | DATE | 2021-06-08 00:00:00
2021-06-07 00:00:00 | 12:10:16 | Verrines | 4 |  | 2 | FORMAT | GN 1/3*
2021-06-07 00:00:00 | 12:15:16 | GN 1/3 SLOW | 0 |  | 3 | NO OF TRAYS | >0
2021-06-08 00:00:00 | 12:20:16 | GN 1/3 SLOW | 6
2021-06-08 00:00:00 | 12:25:16 | GN 1/3 QUICK | 0
2021-06-08 00:00:00 | 12:30:16 | GN 1/3 QUICK | 0 |  | Formula 1 | TIME
2021-06-09 00:00:00 | 12:30:37 | Print manual | 0 |  | Formula 2 | TIME
2021-06-09 00:00:00 | 12:35:16 | GN 1/3 SLOW | 3
Spreadsheet: 848215d1698979193-how-to-calculate-a-pay-rate-that-is-affected-by-2-different-pay-conditions-pay-calculator_normal-pay-without-extra-days
Sheet: Weekly Pay Sheet

EMPLOYEE NAME : |  |  |  | STAFF # :
PAY PERIOD FROM : |  |  |  | TO :
PAY SUMMARY SHEET FOR WEEK 1 |  |  |  | PAY SUMMARY SHEET FOR WEEK 2 |  |  |  | COMBINED 2 WEEK PAY PERIOD
1. NORMAL WORK PAYMENT | Hrs. Paid | Value ($) |  | 1. NORMAL WORK PAYMENT | Hrs. Paid | Value ($) |  | 1. NORMAL WORK PAYMENT | Hrs. Paid | Value ($)
Ordinary Hours Worked : |  |  |  | Ordinary Hours Worked : |  |  |  | Ordinary Hours Worked :
ADO Time Deducted : |  |  |  | ADO Time Deducted : |  |  |  | ADO Time Deducted :
Balance of Hours To Be Paid : |  |  |  | Balance of Hours To Be Paid : |  |  |  | Balance of Hours To Be Paid :
2. PLUS ADDITIONAL PAYMENTS | Hrs. Paid | Value ($) |  | 2. PLUS ADDITIONAL PAYMENTS | Hrs. Paid | Value ($) |  | 2. PLUS ADDITIONAL PAYMENTS | Hrs. Paid | Value ($)
Voluntary Overtime 150% : |  |  |  | Voluntary Overtime 150% : |  |  |  | Voluntary Overtime 150% :
Voluntary Overtime 200% : |  |  |  | Voluntary Overtime 200% : |  |  |  | Voluntary Overtime 200% :
Early-Late Penalty 15% : |  |  |  | Early-Late Penalty 15% : |  |  |  | Early-Late Penalty 15% :
Broken Shift Penalty 150% : |  |  |  | Broken Shift Penalty 150% : |  |  |  | Broken Shift Penalty 150% :
Broken Shift Penalty 200% : |  |  |  | Broken Shift Penalty 200% : |  |  |  | Broken Shift Penalty 200% :
High Capacity Allowance : |  |  |  | High Capacity Allowance : |  |  |  | High Capacity Allowance :
Travelling Time : |  |  |  | Travelling Time : |  |  |  | Travelling Time :
Public Holiday - Work : |  |  |  | Public Holiday - Work : |  |  |  | Public Holiday - Work :
Public Holiday : |  |  |  | Public Holiday : |  |  |  | Public Holiday :
RDOC-1st. 3 hrs : |  |  |  | RDOC-1st. 3 hrs : |  |  |  | RDOC-1st. 3 hrs :
RDOC-After 3 hrs : |  |  |  | RDOC-After 3 hrs : |  |  |  | RDOC-After 3 hrs :
ADOC-1st. 3 hrs : |  |  |  | ADOC-1st. 3 hrs : |  |  |  | ADOC-1st. 3 hrs :
ADOC-After 3 hrs : |  |  |  | ADOC-After 3 hrs : |  |  |  | ADOC-After 3 hrs :
Annual Leave : |  |  |  | Annual Leave : |  |  |  | Annual Leave :
[NAME] Loading : |  |  |  | [NAME] Loading : |  |  |  | [NAME] Loading :
Sick Day : |  |  |  | Sick Day : |  |  |  | Sick Day :
Build-Up Time Payment : |  |  |  | Build-Up Time Payment : |  |  |  | Build-Up Time Payment :
VALUE : |  |  |  | VALUE : |  |  |  | VALUE :
TOTAL PAID FOR WEEK 1 : |  |  |  | TOTAL PAID FOR WEEK 2 : |  |  |  | TOTAL FOR 2 WEEK PERIOD :
Spreadsheet: 732014d1620743148-how-do-i-remove-duplicates-from-multiple-columns-so-that-only-unique-ones-remain-duplicates
Sheet: Sheet1

Customernumber | Name | Product
1112 | [NAME] | ABC
1112 | [NAME] | ABC
1112 | [NAME] | BCD
1113 | [NAME] | AFF
1113 | [NAME] | AKJ
1113 | [NAME] | AFF
1114 | [NAME] | FBB
1114 | [NAME] | PJJ
1114 | [NAME] | PJJ
Spreadsheet: 164311d1340724955-different-days-equals-different-price-answerstore-sub-purchase-form-trial
Sheet: Rentals

Transaction Record - RENTAL
Company Name: |  |  | Number | 28
Employee Name: |  |  | Date: | 2012-04-09 00:00:00
Item # | Item Description | # of Days | [NAME] | Rate/day | Total Cost
 | Hitachi NV50A1 2" coil Nailer | 1 | 1 |  |  |  | See the Yellow Cell [NAME]
 | Hitachi NV50A1 2" coil Nailer | 7 | 1
 |  |  |  | Subtotal
 |  |  |  | GST
 |  |  |  | Total
Signature: |  |  |  | Date:
Spreadsheet: mary_fischer__25622__87P
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 087P |  | (Please print)  PREPARED BY: | [NAME]
COMPANY NAME  EFS Water Treatment Services
E-SCHEDULES CHECK LIST
For the period ending: 06/30/2001 |  | REVIEWED BY: | [NAME]
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | Completed
E-2 * | 195 | Other Current Assets | Completed
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | N/A
E-5 | 344 | Goodwill | N/A
E-6 * | TOT_PPE | Property, Plant & Equipment | N/A
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | Completed
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | N/A
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | N/A
E-21 |  | Lease Expense & Future Lease Commitments | N/A
E-31 | TOT_SHARE_EQU | Reconciliation of Stockholders' Equity and Investment in Sub | Completed
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: 87567d1287456149-combining-multiple-if-and-look-up-statements-part-2-sample-sohest
Sheet: FSC SUMMARY

 | ↓  PLEASE ENTER INFORMATION  ↓
 | SEARCH BY FS CODE |  | OSS% SIMULATION | << Please include "%"
 | F4101052 |  | 0% | ESTIMATES
 |  |  |  | 0 | 55890 | 131200 | 84100 | 12815 | 90000 | 14400 | 0 | 0 | 0 | 0 | 0 | 0 | 105154
 | [NAME] |  | CAMPAIGN | [NAME] | Nov Bk 1 | Nov Bk 2 | [NAME] | [NAME] | [NAME] | [NAME] | Feb Bk 1 | Feb Bk 1 | Feb Bk 2 | Mar Bk1 | Mar Bk2
 | NAT APP&GRAPE GFTHBL 250 |  | R3611 [NAME] Set | 26240 | 85280.84999999999 | 19680.15
 |  |  | R3611 [NAME] Set |  | 16820 | 54665.84999999999 | 12615.15
 |  |  | 0 |  |  | 2563 | 8330.6 | 1922.4
 |  |  | 0 |  |  |  | 18000 | 58500.84999999999 | 13500.15
 | PLANNER CODE |  | 0 |  |  |  |  | 2880 | 9360.85 | 2160.15
 | 4P |  | 0 |  |  |  |  |  | 0 | 0.85 | 0.15
 |  |  | 0 |  |  |  |  |  |  | 0 | 0.85 | 0.15
 | PLANNER |  | 0 |  |  |  |  |  |  |  | 0 | 0.85 | 0.15
 | [NAME] |  | 0 |  |  |  |  |  |  |  |  | 0 | 0.85 | 0.15
 |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 | 0.85 | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.85
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21030.8
 |  |  |  | 0 | 0 | R3611 [NAME] Set | R3611 [NAME] Set | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL NEED |  |  | 26240 | 102100.85 | 74345.99999999999 | 115430.15 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1
 | TMA |  | 105154
 | TOTAL MS PLOTTING |  | -105154 | -78914 | 102100.85 | 74345.99999999999 | 115430.15 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 4
 |  |  |  | 0 | 0 | 131200 | 84100 | 0 | 0 | 0 | 0
 |  |  |  | 55890 | 0 | 0 | 12815 | 90000 | 14400 | 0 | 0
 |  |  |  | 0 | 0 | 12815 | 90000 | 14400 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 12815 | 90000 | 14400 | 0
 |  |  |  | 26240 | 85280.84999999999 | 19680.15 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 16820 | 54665.84999999999 | 12615.15 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0%
 | F4101052 |  |  | 26240