tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 758599d1638965923-data-validation-with-logic-data-validation-with-logic
Sheet: Entry

Contractor | Activity Number | Date | Job No. | [NAME]. | Ph. | Part Mark | Qty. | CONCATENATED (D+E+F+G Columns) | Activities | Force Entry | Operation
ABC | 22 | 2021-11-26 00:00:00 | HY-06217 | B1 | 99 | [NAME] | 1
ABC | 22 | 2021-11-26 00:00:00 | HY-06217 | B1 | 99 | HRL14 | 1
CCC | 2 | 2021-12-03 00:00:00 | HY-06217 | B1 | 99 | [NAME] | 1
AAA | 2 | 2021-12-03 00:00:00 | HY-06217 | B1 | 99 | HRL14 | 1 |  |  | 1
BBB | 2 | 2021-12-03 00:00:00 | HY-06217 | B1 | 99 | HRL15 | 1
There are 3 tables in three different sheets in the file.
Entry Sheet is used for contractors to raise the bill for the work done
BOM Sheet consists of all the Part Marks.  In Each Job (Col.D) there may be multiple buildings and each building may have multiple phases and each phase have several Part Marks (Combination of Job No., [NAME]., [NAME] and Part Mark gives a unique identification code (Col.I), which can be used for lookup)
Activities Sheet consists of different activities and each activity given one number for identification.   All the activities are categorized as per the type of OPERATION
Part marks (Col.G) are carried out by different contractors (Col.A)
OPERATIONS for each part mark can be FABRICATION or PAINTING or Both)
Requirement:
Need Data Validation formula (in Col.H) where
1) The Qty. entered for a part mark cannot be more than the BOM qty. for each OPERATION.
i.e. If the BOM qty. is 2, Fabrication cannot be of more than 2 Nos. and Painting cannot be more than 2 Nos.
2) If we put 1 in Force Entry column (Col.K) then that particular row should allow more qty. than the BOM qty.
3) Qty. column should not allow any entry in a blank row also.
Spreadsheet: 778082d1650853807-automatic-ranking-standings-bouwcenter-poule-f1-2022-v1a-clau46-
Sheet: Standings B

# | Name | Total points | Points behind
 | [NAME] |  | Leader | Previous |  |  | Leader | Previous
 | [NAME]
 | Cor
 | [NAME]
 | [NAME]
 | Karel
 | Marcel
 | Jan
 | [NAME]
 | Floor
 |  |  | 256
 |  |  | 131
Spreadsheet: 751489d1634136824-unique-count-how-many-times-a-number-changes-in-a-column-by-date-label-changes-by-day
Sheet: Sheet1

Start Date | Item Number | Description | [NAME] |  | Desired Result
2021-10-12 00:00:00 | 1234 | Apples |  |  | 1
2021-10-13 00:00:00 | 1235 | Bannana |  |  | 2
2021-10-13 00:00:00 | 1235 | Bannana |  |  | 2
2021-10-13 00:00:00 | 1236 | Orange |  |  | 2
2021-10-13 00:00:00 | 1236 | Orange |  |  | 2
2021-10-14 00:00:00 | 1236 | Orange |  |  | 0
2021-10-15 00:00:00 | 1237 | Pear |  |  | 3
2021-10-15 00:00:00 | 1236 | Orange |  |  | 3
2021-10-15 00:00:00 | 1237 | Pear |  |  | 3
2021-10-16 00:00:00 | 1237 | Pear |  |  | 0
Spreadsheet: 124151d1318190326-product-and-quantity-price-break-input-into-invoice-quantity-discount-example
Sheet: Invoice

Cash
Check |  |  |  |  |  |  |  |  |  |  | Invoice No. | 01
Credit
Other
 |  |  | 123 Where ever Road |  |  |  |  |  |  |  |  | INVOICE
 |  |  |  |  |  |  |  |  |  |  | GST #12345678 RT
 |  | Customer |  |  |  |  |  |  |  |  | Misc
 |  | Name | This Guy |  |  |  |  |  | Invoice Date |  |  | 2011-10-09 00:00:00
 |  | Address | 17 Summit Pointe Dr R.R.1 |  |  |  |  |  |  |  | Order No.
 |  | City | Dewinton | Prov. | Ab |  | T0L 0X0 |  |  |  | Rep | V.Morrison
 |  | Phone | [PHONE] Fax 201-4235 | T0L 0X0 | T0L 0X0 | T0L 0X0 | T0L 0X0
 |  |  |  |  |  |  |  |  | Delivery Date
 |  | Qty | Description |  |  |  |  |  |  |  | Unit Price | TOTAL
 |  | 2 | the other 1 |  |  |  |  |  |  |  | 30 | 60
 |  |  |  |  |  |  |  |  |  |  | SubTotal | 60
 |  |  |  |  |  |  |  |  |  |  | Shipping
 |  | Payment | Check |  |  |  |  |  | Tax Rate(s) |  | 0.05 | 3
 |  |  |  |  |  |  |  |  |  |  | 0
 |  | Comments |  |  |  |  |  |  |  |  | TOTAL | 63
 |  | Name
 |  | CC # |  |  |  |  |  |  | Office Use Only
 |  | Expires
 |  | There is 2% quick pay if invoice is paid with in 15 days of day of invoice .Term of invoice is 30 days from date of invioce .
 |  |  | We thank you for your business
Spreadsheet: 218127d1362361497-pulling-date-from-9-sheets-to-be-displayed-on-front-sheet-packing-list-final
Sheet: RH Freight

Nisha |  | [NAME]
 |  | [NAME]
Packing No. | Collection Date | Packed | Collected | date | Collections Key | Collections Key
4452 | 2013-03-03 00:00:00 | Y
4476 | 2013-03-03 00:00:00
4486 | 2013-03-04 00:00:00
4496 | 2013-03-04 00:00:00
5245 | 2013-02-27 00:00:00
5242
5240 | 2013-02-28 00:00:00
5231
5230
5177
5139
5049
5002
4928 | 2013-02-28 00:00:00
Spreadsheet: 806974d1669703659-distribution-of-data-base-on-dates-with-mutiple-duplicates-collection-vs-deposites-vladyexcelforum-file
Sheet: Merge

 |  |  | Collection
 |  |  | Deposit
 |  |  | 0 | Date | Type | Date.Cnt | No |  | Rank | DR | CR | Value
 |  | Insert_Row
Spreadsheet: 141580d1329339790-help-with-countifs-using-mulitple-named-ranges-spectest
Sheet: Sheet1

 |  |  |  |  |  | specvar | 0.05 |  | Weight Lower | 5
Count |  |  |  |  |  |  |  |  | Weight Uppper | 6
 |  |  |  | 5.86
 |  |  |  | 5.71
 |  |  |  | 6.03
 |  |  |  | 5.94
 |  |  |  | 4.81
 |  |  |  | 5.81
 |  |  |  | 5.33
 |  |  |  | 5.79
 |  |  |  | 5.56
 |  |  |  | 5.84
 |  |  |  | 5.18
 |  |  |  | 5.44
 |  |  |  | 5.94
 |  |  |  | 5.01
 |  |  |  | 5.43
 |  |  |  | 6.34
 |  |  |  | 5.27
 |  |  |  | 5.66
 |  |  |  | 5.47
 |  |  |  | 5.26
 |  |  |  | 5.52
 |  |  |  | 5.31
 |  |  |  | 5.52
 |  |  |  | 5.92
 |  |  |  | 5.81
 |  |  |  | 5.28
 |  |  |  | 5.45
 |  |  |  | 5.36
 |  |  |  | 5.92
 |  |  |  | 5.94
 |  |  |  | 4.95
 |  |  |  | 6.04
 |  |  |  | 5.8
 |  |  |  | 5.57
 |  |  |  | 5.66
 |  |  |  | 4.89
 |  |  |  | 5.37
 |  |  |  | 5.35
 |  |  |  | 5.97
 |  |  |  | 5.15
 |  |  |  | 5.18
 |  |  |  | 5.16
 |  |  |  | 5.73
 |  |  |  | 5.48
 |  |  |  | 5.97
 |  |  |  | 5.91
 |  |  |  | 5.77
 |  |  |  | 5.67
 |  |  |  | 5.59
 |  |  |  | 5.34
 |  |  |  | 5.71
 |  |  |  | 5.65
 |  |  |  | 5.59
 |  |  |  | 5.17
 |  |  |  | 5.46
 |  |  |  | 5.81
 |  |  |  | 5.71
 |  |  |  | 5.67
 |  |  |  | 5.56
 |  |  |  | 5.58
 |  |  |  | 5.81
 |  |  |  | 5.5
 |  |  |  | 5.32
 |  |  |  | 5.72
 |  |  |  | 5.32
 |  |  |  | 5.39
 |  |  |  | 5.33
 |  |  |  | 5.54
 |  |  |  | 5.76
 |  |  |  | 5.37
 |  |  |  | 5.55
 |  |  |  | 5.97
 |  |  |  | 6.33
 |  |  |  | 5.55
 |  |  |  | 5.32
 |  |  |  | 5.78
 |  |  |  | 5.85
 |  |  |  | 5.84
 |  |  |  | 5.28
 |  |  |  | 5.08
 |  |  |  | 5.45
 |  |  |  | 5.61
 |  |  |  | 5
 |  |  |  | 6.22
Spreadsheet: 9429f91b-4f7e-43fe-8597-e8b1033a97df
Sheet: Month 4

Student Name and Site:
[NAME]
School Counseling Log
 | Week 13 | Week 14 | Week 15 | Week 16
Activity | From: | From: | From: | From: | Totals | Semester
 | To: | To: | To: | To: |  | Total
Individual Counseling (including career, academic & personal/social) | 0
Group Counseling | 0
Group Classroom Guidance | 0
Testing: Administration and Interpretation
Other Direct | 0
Indirect hours (e.g. paperwork, observations, meetings, consultation, etc.) | 0
Individual/Triadic Supervision | 0
Group Supervision | 0
Total
Monthly Totals | Direct
 | Nondirect
 | Supervision
 | Direct Individual/Group
Semester Totals | Direct
 | Nondirect
 | Supervision
 | Direct Individual/Group
 | TOTAL HRS
Intern's Signature: |  |  |  |  |  |  |  | Date:
Site [NAME]'s Signature: |  |  |  |  |  |  |  | Date:
Spreadsheet: darrell_schoolcraft__7302__imball0201
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 |  |  | 23592 | 24000
2 |  |  | 24358 | 24000
3 |  |  | 24506 | 24000
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 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -183024 | -128596
2001-12-31 00:00:00 | Balance | -1033425 |  | -571848
2001-01-03 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 | 0 | Zia |  |  | 22864
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia |  |  | 20379 | 2979
 |  |  |  | 26357 |  | [NAME] |  |  | 26357
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME] |  |  | 21544 | 36108
 |  |  |  | 24532 | -1132591.35 | 500211,500212,500219,500230 - Coburn points |  |  | 24532 | -139694
 |  |  |  | Duke
20379
24532
21544
26357
22864
23995
22051
21665
22664
24361
26393
24268
Spreadsheet: 04e35715-b9b1-4c62-be73-df9ed5dcc97b
Sheet: Page 3

 |  | Purchasing Card Cycle Transaction Log
PURCHASING SERVICES |  |  |  |  |  |  |  |  |  | Page 3
[1] Cardholder: |  | [2] Dept/Unit: | [3] Card Number: xxxx-xxxx-xxxx- |  |  |  |  | [4] Purchasing Cycle Date:
[5] | [6] | [7] | [8] | [9] | [10] | [11] | [12] | [13] | [14] | [15]
Trans Date | Supplier/Vendor | Description Goods/Services Ordered | Sub-Total | Cost of Goods  (Use Tax applicable) | Use/ | Sales Tax | Use Tax | Shipping Costs | Total Cost | Travel TA/TP Document Number
 |  | /Public Purpose : |  |  | Sales Tax |  | Rate: 5.6%
 |  |  |  |  | Exempt
 |  | Purchasing Card Transaction Totals:
With my signature below, I certify that I, as the cardholder, personally made all purchases identified on this Purchasing Card Cycle Transaction Log, have not received or requested reimbursement for these same transactions, that they serve the public purpose indicated to further the goals of the University, were conducted in accordance with the policies and procedures set forth by the University and the Arizona Board of Regents and I acknowledge understanding of ARS §35-301, specifically, that a public officer or other person, including justices of the peace and constables, charged with the receipt, safekeeping, transfer or disbursement of public money is guilty of a class 4 felony who without authority of law, appropriates it, or any portion thereof, to his own use, or to the use of another.
[16] Cardholder Signature: |  |  |  |  |  |  |  |  |  | Date:
With my signature below, I certify that, to the best of my knowledge, the items purchased on this claim are correct, serve a public purpose and that no duplicate reimbursement payments have been made.
[17] Dept/Unit Fiscal Liaison Signature:                                                                                                                        *Approval and reconciliation shall not be completed by the Cardholder. |  |  |  |  |  |  |  |  |  | Date:
Spreadsheet: 299042d1392990839-array-formula-for-top-10-how-to-deal-with-duplicate-values-top-10-formula
Sheet: Sheet2

Project Number | Project Title | Accounting Centre Code | Accounting Centre Name | Project Director [NAME] | Parent Practice Description | Group Code | Period Profitability | Period Cashflow | Period PB Bad Debts | Cum. [NAME] | Period Total Invd Excl. Tax | Cum. Total [NAME]. Tax | Work Outstanding | Work In Progress | Financial % Complete | 0-30 days Total Excl. Tax | 31-60 days Total Excl. Tax | 61-90 days Total Excl. Tax | 91-120 days Total Excl. Tax | 121-150 days Total Excl. Tax | 151-183 days Total Excl. Tax | Over 6 Months Total Excl. Tax | Total Debts Excl. Tax | Fcst. Total Income | Fcst Income Previous Month | Mvmt | Increase | SR | SR + PP |  | Missing from Last Month?
23096400 | PADDINGTON NEW YARD | 1212 | Trans. & Civil Eng. NW & Yorks | [NAME] | Infrastructure | GD16 | 8593.22 | 25271.92 | 0 | 0 | 143249.8 | 143249.8 | 206743.39 | -1059.19 | 40.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 348934 | 148934 | 200000 | Increase | NW & Yorkshire | Infrastructure NW & Yorkshire
23413600 | CP - MOBILISATION PHASE | 1123 | Economics & Planning South | [NAME] | Consulting | GD41 | 2869.5 | 52007.15 | 0 | 0 | 161105 | 161105 | 136640 | -97745 | 31.68 | 51105 | 0 | 0 | 0 | 0 | 0 | 0 | 51105 | 200000 | 0 | 200000 | Increase | Planning South | Consulting Planning South |  |  | I want this value
Spreadsheet: 843899d1695724005-extract-texts-from-list-a-to-list-b-tesd
Sheet: 5.6.23

LIST A
NAMES
SOLITARY FOOD
AL SAFA 01 / AAM
[NAME] NIKKU
ALI TRADERS 165 / SHAKIR SONU
SHAHALAM G 78
AL ABUZAR TRADERS 163 / MEHARBAN
TIJARAT EXPORTS C/O ALTAMASH SRE 436
H INAM MUZ OP 03
AZAIB SRE OP 06
HAROON BULANDSHEHAR PUR 315
AL ABUZAR TRD / MEHARBAN G PB 431
ISLAM G OP 07
ALI TRADERS / SHAKIR SONU PB 433
AL SAFA / AAM PB 430
AL ASHRAF FOOD / ZISHAN NG PB 434
KABEER TRADERS 116 / BILAL FAISAL
MURSALEEN BSP PURCHASE AC 289
Y S AGRO / H SADIK MUZ PB 432
R A ENTERPRISES 187 / ABUZAR
CH SALEEM / AMJAD SRE TRUCK AC
[NAME]
AL SALAM FOOD 356
LALA CH 173
[NAME] 95
SHAHZAD DL 218
H RAEESU MRT PUR 317
KASHU BULANDSHEHAR PUR 336
FAIZ GANGOH 313
H NIKKU MUZ PUR COM AC
ABUZAR [NAME] 128
WAKEEL PUR SRE 175
MOHSIN HM 307
MURSALEEN BSP PUR COM AC
H NOUSHAD RAJISTHAN 383
ARIES TRADING COMPANY
BABU ISLAM G PUR 344
T KALA LOCAL PURCHASE
KALLU MRT 153
ABID AMB NIGHT
Spreadsheet: 151771d1335113397-copy-just-numbers-coursework
Sheet: ev_HiddenInfo

Goal (Cell, Statistic, Parameter), E1: RO Formula to Optimize |  |  |  |  | [NAME] |  |  | Compatibility with Old Versions (4 trips pre-v5 versions) | 3 |  | RISKOpt Tag | True |  | Out. Stats
[NAME] (Type, Target Value) | 1 | 0 |  |  | Start (enabled, macro) | False |  | Formula Conversion Cell (not used in v5) |  |  | #Iterations ([NAME]) |  |  | Mean |  |  | Creation Version | 5.7.1 |  | Constraint Solver, number of Latin Hypercube stratifications, for reproducing results with Actual Convergence
Trial Count Stopping (enabled, trial count) | True | 20000 |  |  | Before Recalc (enabled, macro) | False |  | Number Formatting Cell (introduced in v5) |  |  | [NAME]. Stopping Mode, Tolerance |  |  | Std. [NAME]. |  |  | Required Version | 4.0.0 |  | Constraint Solver, total of adjustable cell values, to only pass number of stratifications if model hasn't changed
[NAME] (enabled, trial count) | False | 5 | 2 |  | After [NAME] (enabled, macro) | False |  |  |  |  | Same Seed Each Simulation |  |  | Min |  |  | Recommended Version | 4.0.0
[NAME] (enabled, trial count, [NAME] change, change is percent) | False | 100 | 0.01 | True | After Storage (enabled, macro) | False |  |  |  |  | Sampling Type |  |  | [NAME] |  |  | Last Modified by Version | 5.7.1
[NAME] (enabled, formula) | False |  |  |  | Finish (enabled, macro) | False |  |  |  |  | Macro Before Simulation (enabled, macro)
Population Size | 50 |  |  |  |  |  |  |  |  |  | Macro After Simulation (enabled, macro)
UNUSED | UNUSED |  |  |  | Seed (Is Auto, Value) | True | 1
Ev4/RO1: Update Display (replaced by Show Excel Recalcs in v5) | 3 |  |  |  | Minimize Excel on Startup | False
Stop on Errors (before v5: Pause on Errors) | False
[NAME] (if cell has anything other than False consider True, since Evolver 4 didn't have this setting) | True
Ev4/RO1: Graph Progress | False |  |  |  | Show Excel Recalcs (replaces "Update Display" used before v5) | 2
# [NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # Constraints | 0
Method + #Operators | Mutation Rate | [NAME] | Description | # Time Blocks/All Groups Must Be Present | Constraint Range | #Ranges | Adj. Range | Min Val or Range | [NAME] Or Range | Flags |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HARD CONSTRAINT DEV |  |  |  |  |  | Type (Hard/Soft) | Entry Mode | [NAME] | Description | Left Val Or Range | Left Operator | Constrained Cells | Right Operator | Right Val Or Range | Penalty Function | RO Eval Time (Iter/Sim) | RO Statistic to Constrain | RO Statistic Parameter
SCHEDULE_x0001_4 | 0.01 | 0.9 |  | 5 |  | 1
DEFAULT PARENT SELECTION
[NAME]
DEFAULT CROSSOVER
DEFAULT BACKTRACK
Spreadsheet: 43544d1242188962-solving-an-equation-683301-solve-formula
Sheet: Sheet1

a | 1.05007
b | 0.948061
d | 2.75394
e | 3.07675
x | y(x)
2.76 | -2.700841402709993
2.78 | -1.256077443576018
2.8 | -0.6499642373323191
2.82 | -0.2369601884511943
2.84 | 0.09067018602607702
2.86 | 0.3724532184155358
2.88 | 0.6280160880244058
2.9 | 0.8692569356143613
2.92 | 1.104770265392517
2.94 | 1.341991976264751
2.96 | 1.588694258467592
2.98 | 1.854661041549603
3 | 2.154581943355502
3.02 | 2.51488699800539
3.04 | 2.995551234857331
3.06 | 3.804550220298514
x(y) | y
3.054099836831913 | 3.5 | << Enter y
Spreadsheet: 678519d1589931578-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example
Sheet: 04 May 20 - 09 May 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-05-04 00:00:00 | 2020-05-05 00:00:00 | 2020-05-06 00:00:00 | 2020-05-07 00:00:00 | 2020-05-08 00:00:00 | 2020-05-09 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 04/05/2020 - 09/05/2020
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Dameon | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Nathan | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Tyson | ✓ | AWAY | ✓ | ✓ | ✓ |  |  | 1 |  | Tyson | ✓
Will | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Will | ✓
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  |  | ❌
 | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  |  | ✓
Edge Protection [NAME] |  |  | 04/05/2020 - 09/05/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 04/05/2020 - 09/05/2020
Laminex |  |  | ❌ |  |  |  |  |  |  | Dameon | ✓
Wilson |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
Canterbury Linen Services |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
[NAME] |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | ✓
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | ✓
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ✓
 |  |  |  |  |  |  |  |  |  |  | ✓
Spreadsheet: 129699d1321824955-excel-2007-calculate-retirement-date-in-excel-forum
Sheet: Sheet1

Sl. No. | Name | Designation | Date of Birth | Date of appointment | Date of Retirement | Length of Service
1 | A | ABC | 1973-11-01 00:00:00 | 1996-12-19 00:00:00
2 | B | DEF | 1973-11-02 00:00:00 | 1996-12-19 00:00:00
3 | c | GHI | 1973-01-01 00:00:00 | 1996-12-19 00:00:00
 | Find herewith an attachment of my workbook I am trying to working out the calculation of date of retirement in column F2 and F3, the default age is 58 years in reference to date of birth in column D2 and D3. But I could not work the calculation with the mentioned logic.
Spreadsheet: scott_neal__37841__STOR9787
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9787
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2000-07-07 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 432 | 458
(TX, LA, OK, KS, MS)
Market Area - East |  | 856 | 919
Market Area - West |  | 348 | 356
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 0c722490-44ff-4d04-af75-180092c8ce6f
Sheet: Calculations

Parameters for a small wind turbine
Wind Turbine Electricity Potential (kW) | 20
Minimum Wind Speed (mph) | 4.5
Wind Speed to Reach Potential (mph) | 26
Maximum Wind Speed (mph) | 50
Capacity Factor | 0.35
Your Annual Average School Energy Use (kWh/year) | 390000 | <-- Enter value for your school here if you only have annual data; Sample is based on average energy usage for a Wisconsin school
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Monthly Averaged Energy Usage by Your school (kWh/month) |  |  |  |  |  |  |  |  |  |  |  |  | <-- Replace with actual monthly energy usage for your school if you have that information; otherwise monthly values will be computed from annual energy use
Days per month | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31
Monthly Averaged Wind Speed At 50 m Above The Surface Of The Earth (m/s) | 6.62 | 6.64 | 7.25 | 7.16 | 6.75 | 6.47 | 6.07 | 5.8 | 6.29 | 6.34 | 6.62 | 6.49 | <-- copy from the POWER data you accessed for your location
Monthly Averaged Wind Speed At 50 m Above The Surface Of The Earth (mph)
% Difference between 50 m and 10 m windspeed | -35 | -35 | -35 | -35 | -35 | -35 | -35 | -35 | -35 | -34 | -35 | -34 | <-- copy from the POWER data you accessed for your location
Monthly Averaged Wind Speed at 10 m about the surface (mph)
Windspeed available for producing electricity |  |  |  |  |  |  |  |  |  |  |  |  | <-- Automatically determines whether windspeeds are below minimum threshold, between minimum threshold and minimum windspeed to reach potential, or above maximum windspeed cutoff
Monthly Averaged Electricity Produced by [NAME] (kWh)
Percentage of School Electricy Usage that a single Wind Turbine Can Fulfill
Spreadsheet: 700643d1603277862-sumproduct-when-a-letter-is-interrupting-the-data-sumproduct-issue-example
Sheet: Sheet1

 |  | 1 |  | 5 | 5 | 5 | 5
 |  | 2 |  | 5 | 5 | 5 | 5
 |  | 3 |  | H | 5 | 5 | 5
 |  | 1 |  | 5 | 5 | 5 | 5
 |  | 2 |  | 5 | 5 | 5 | 5
 |  | 3 |  | 10 | 10 | H | 10
 |  | 1 |  | 10 | 10 | 10 | 10
 |  | 2 |  | 10 | 10 | 10 | 10
 |  | 3 |  | 20 | 20 | 20 | 20
 |  | 1 |  | 20 | 20 | 20 | 20
 |  | 2 |  | 20 | 20 | 20 | 20
 |  | 3 |  | 20 | 20 | 20 | 20
Spreadsheet: vkaminski__40659__PutsDeal2D
Sheet: Sheet1

 | Pricing Model for Bermudan Deal - Two Factor
 |  | Valuation date | 1999-12-31 00:00:00
 |  |  |  |  |  | Maturity |  | Exercise Restriction |  |  | R |  | 0.06
 |  |  |  |  | Strike | Date | Years | Date | Years |  | Steps |  | 200
Strike0 | a | Enron 5-year put, [NAME] exercise |  |  | 56.125 | 2004-06-29 00:00:00 |  | 2001-06-01 00:00:00 |  |  | Exercise Frequency |  | 2
 |  |  |  |  |  |  |  |  |  |  | RTHM / ENE correl. |  | 0.2
 | b | LJM long 2.5-year put |  | Low Strike |  | 2002-01-14 00:00:00
Strike1 | c | Enron long 2.5-year put |  | High Strike | 65 |  | 2.16
Strike2 | d | LJM long call |  | Low Strike
Strike3 | e | Enron long call |  | High Strike | 81
 |  |  |  |  |  | RTHM | RTHM | RTHM
 |  |  | RTHM Options |  | Quantity | Price | Volatility | Div. Yield
 |  |  |  |  | 5393258 | 31 | 1.05 | 0
 |  |  | ENE Shares |  |  | ENE | ENE | ENE
 |  |  |  |  | Quantity | Price | Volatility | Div. Yield
 |  |  |  |  | 3114356 | 44.375 | 0.4 | 0.018
 |  | Option Value per Share
 |  | Option Value
 |  | Enron Shares
 |  | Difference
 |  | Cash |  | 3750018
 |  | Total