tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 860973d1708990914-averageiif-for-values-between-a-set-range-50-100-report-v2
Sheet: 50-100 Test.v2

Greater Than | Up To | [NAME] | Avg -Sht / +Lng | [NAME] From Pin
50 | 55
55 | 60 |  |  |  |  |  | The issue with the highlighted is that it includes the "0.0" values associated with rows 28-33 where there is no data. When no data, the cell calculates to 0.0 and thus is incorporated within the average. How to exclude rows when there is null values in column B and C?
60 | 65
65 | 70
70 | 75
75 | 80
80 | 85
85 | 90
90 | 95
95 | 100
Yards | -Lft / +Rgt | -Sht / +Lng | yrds from Pin
52 | -2 | 5
51 | 2 | -5
81 | 4 | -2.3
62 | -4 | -6.3
91 | 1 | 3
50 | 0 | 3.6
56 | 3 | 1.6
98 | 6 | 5
86 | 5 | -5
56 | -2 | -2.3
56 | 3 | -6.3
95 | -2 | 3
84 | -6 | 3.6
51 | -8 | 1.6
52
83
86
91
89
77
Spreadsheet: 868237d1714985056-tier-incentive-will-be-automatically-calculated-based-on-tier-hani-calculation-
Sheet: Dr. Nareman Suliman

Contract Terms (*)
 |  | Description | Commission
 |  | Consultation | 0.5
 |  | Lab & Ultra Sounds After Deducting Lab Fee | 10% & 5%
 |  | Procedure in Clinics After Deducting Hospital Fee | 0.05
 |  | Procedure in Clinics After Deducting Hospital Fee | 0.3
 |  | Procedure in Clinics | 0.5
Doctor Calculation
 |  | Gross Revenue
 |  | Consultation Revenue | 6615
 |  | OHE 5%
 |  | NET Consultation Revenue
 |  | Amount to be paid
 |  | Referral Revenue | 0
 |  | Amount to be paid
 |  | Procedure in the Clinics Revenue (5%) | 0
 |  | Amount to be paid
 |  | Procedure in the Clinics Revenue (5%) | 17630.34
 |  | Less: Hospital Fee/Lab | 0
 |  | OHE 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | Procedure in the Clinics Revenue (10%)
 |  | Less: Hospital Fee/Lab | 0
 |  | OHE 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | Procedure in the Clinics Revenue (0%) | 4800
 |  | Net Revenue
 |  | Amount to be paid
 |  | Procedure in the Clinics Revenue (30%) | 60637.5
 |  | Less: Hospital Fee
 |  | OHE 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | Procedure in the Clinics Revenue (50%) | 0
 |  | Amount to be paid
 |  | Laboratory Revenue (10%) | 3627
 |  | OHE 5%
 |  | Net Lab Revenue
 |  | Amount to be paid |  | 0.1
 |  | Ultra Sound Net Revenue 5% | 7192.5
 |  | OHE 5%
 |  | Net Ultra Sound Revenue
 |  | Amount to be paid
 |  | Total Amount to be Paid
 |  | Admin Fees (Including GOSI 3,741) | 3741
 |  | Less: Salary | 37846
 |  | Total Amount to be Paid / Received
Prepared By …................. |  |  |  | CFO:….............
Spreadsheet: david_delainey__8081__MP082800-DD
Sheet: Catalytica

Catalytica Combustion Systems Inc.
CCSI Expected Number of Shares Outstanding
Catalytica Ownership (current)
Enron Ownership (current) | 1339285 |  |  |  |  |  | 1339285
Employee Stock Options | 1072043 |  |  |  |  |  | 1072043
Planned IPO shares |  |  |  |  |  |  | 2000000
Enron Cashless Option Exercise
TOTAL
Enron Cashless Option Exercise
No. of option shares | 535714 |  |  |  |  |  | 535714
Strike Price | 26.88 |  |  |  |  |  | 26.88
Price at which Intrinsic Value is Calculated
Enron Intrinsic Value per option
No. of shares obtained based on Value
 |  |  |  |  |  |  |  |  | [NAME] | Calc RAROC
 | Purchased [NAME] | Marked-to-market |  | IPO Shares | Spin Off |  | RAROC Case |  |  | Not as exact as Rahul case b/c of option exercuse cash
Enron Shares Held |  |  |  |  |  |  |  |  | 1635314 | 1628198.514666952
Price | 22.40001194667304 |  |  |  | 69.60803302828428 |  | 69.60803302828428 |  | 59.9 | 59.92285879619136
Valued At |  | 46314000 |  |  |  |  |  |  |  | 97566309.6865563
Catalytica Ownership |  |  |  |  |  |  |  |  |  | 7500000
 |  |  |  |  |  |  |  |  |  | 1628198.514666952
Employee Stock Options | 0 | 0 |  |  |  |  |  |  |  | 1072043
Planned IPO shares | 0 | 0 |  |  | 0 |  | 0 |  |  | 2000000
Total No. of Shares Outstanding |  |  |  |  |  |  |  |  |  | 12200241.51466695
Enron's % Ownership |  |  |  |  |  |  |  |  |  | 0.1334562527069285
 |  |  |  | 0.1334562527069285 | 0.1596235258082627
CCSI Equity Market Valuation |  |  |  |  |  |  |  |  |  | 731073349.5628195
 |  |  |  |  |  |  |  |  | 728735000
Option |  |  |  | 0
Strike Price
Intrinsic Value per share | 0
Valued At |  |  |  | 0
Enron's Fair Value Write-up |  |  |  |  |  |  |  |  |  | 51566309.68655629
Enron's Cash on Cash Return |  |  |  |  |  |  |  |  |  | 51566309.68655629
 |  |  |  |  | 49556395.33614302
Spreadsheet: 675564d1588354443-show-total-spending-for-current-month-book1
Sheet: Sheet1

Invoice Sr .No | Date | Amount spend  (Inr)
1 | 01.04.2020 | 1000
2 | 22.04.2020 | 1000
3 | 21.04.2020 | 1000
4 | 24.04.2020 | 2000
5 | 06.05.2020 | 2000
6 | 24.03.2020 | 2000
7 | 18.12.2019 | 1500
8 | 01.04.2020 | 3000
9 | 22.04.2020 | 1000
10 | 21.04.2020 | 2000
11 | 24.04.2020 | 2000
12 | 06.05.2020 | 2000
13 | 24.03.2020 | 1500 |  |  | I WANT TOTAL SPENDING OF CURRENT MONTH AUTOMATICALLY
14 | 18.12.2019 | 2000 |  |  | MONTH ALSO SHOULD CHANGE AUTOMATICALLY EVERY MONTH
Spreadsheet: sara_shackleton__36423__TPTFund ISDA
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: |  | DEAL MAKER: | Per Sekse, [PHONE]
COUNTERPARTY: | Tudor Proprietary Trading, L.L.C. | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING)
LIMIT $ MILLIONS
Incorporation State
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | 0 | 0
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000
Return Amount
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor
Debt Ratings Change
-Below = S&P/Moody's
Financial Covenants
-Max Liabilities/NAV
-Minimum NAV
-Cash Flow/CMLTD
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt
-Counterparty ($[NAME]) | 2
-Guarantor ($[NAME]) |  | 100
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS: | Counterparty is hedge fund.
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x3-3559
Spreadsheet: 74862d1275409965-hide-column-when-epo-is-selected-in-my-combo-drop-down-box-help
Sheet: DDControls

Components | Employer | National, Key, HP | Plan Type | Funding-BH | Funding-EAP/WL | Billing | Benefit Year | Claims System | Non-Network Allowable | Order of Benefits | COB Rules | Benefit Period | EAP Model | EAP Benefit Period | EAP Auth | MHvSA | Account Type | Managed By-BH | Managed By-EAP | Contract Type | CAC Location | CAC Location | CA LAP | Yes/No
EAP/WL | EAP/WL | EAP/WL | CDHP | ASO | ASO | Direct | Calendar | COSMOS | Billed Charges | Birthday Rule | Standard | per Admit | Assess and [NAME] | Annually | Required | Same as MH | UBH Employer | Employer | Employer/Health Plan | Both (UBH & USBHPC, non-CA & CA Members | Atlanta | Atlanta | Please Select | Yes
EAP | EAP | EAP | EPO | Fully Insured | At Risk | Internal | Contract | Facets | Lesser of Eligible Expense or UBH Allowable | Gender Rules | Non-duplication | Annually | Enhanced | Monthly | Not Required |  | UHC National Accounts |  | UBH | HMO (only used for legacy PBH HMO) | [NAME] | [NAME] | No-CA LAP does not apply | No
WL | WL | WL | Idemnity |  |  |  | Rolling | Rios | MNNRP - Max Non-Network Reimb Program | Unknown | Reserve Bank | per Course of Treatment | Entitlement | Problem per Year |  |  | [NAME] |  | Optum | Insurance (UBH only, no CA members) | Chicago | Chicago | Yes-CA LAP does apply
FMHP-MHSUD | FMHP-MHSUD |  | POS |  |  |  |  | TPA from Rios | N/A |  | Other | Daily | Onsite | Weekly |  |  |  |  | USBHPC | Plan CA (USBHPC only, all members in CA) | Golden Valley | Golden Valley | Apply Override-CA LAP applies as an exception
FMHP-MHSUD/EAP/WL | FMHP-MHSUD/EAP/WL |  | PPO |  |  |  |  | UNet | NCR |  |  | per Lifetime | [NAME] Only |  |  |  |  |  |  |  | Houston | Houston
FMHP-MHSUD/EAP | FMHP-MHSUD/EAP |  |  |  |  |  |  |  | UCR |  |  | Monthly | Other |  |  |  |  |  |  |  | Member Specific | Member Specific
FMHP-MHSUD/WL | FMHP-MHSUD/WL |  |  |  |  |  |  |  |  |  |  | Rolling 24 Months |  |  |  |  |  |  |  |  | NSC | N/A (Virtual)
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | Salary |  |  |  |  |  |  |  |  | Philadelphia | NSC
MHSUD/EAP/WL | MHSUD/EAP/WL |  |  |  |  |  |  |  |  |  |  | per Visit |  |  |  |  |  |  |  |  | Portland | Philadelphia
MHSUD/EAP | MHSUD/EAP |  |  |  |  |  |  |  |  |  |  | Weekly |  |  |  |  |  |  |  |  | Rockville | Portland
MHSUD/WL | MHSUD/WL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | San Antonio | Rockville
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | San Diego | San Antonio
components list depends on Account Type |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | San Francisco | San Diego
if Emp use Employer list |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Seattle | San Francisco
if UHC Key, National, HP, use Health Plan list |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | St. Louis | Seattle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | St. Louis
Spreadsheet: 34262d1231422255-lookup-values-match-then-take-max-from-results-excelproblemo
Sheet: Sheet1

A | B | C
Come On Buckers | Wolverhampton
Digit | Wolverhampton
Fasliyanne | Wolverhampton
Intrepid Lady | Wolverhampton
West Leake | Wolverhampton
[NAME] | Wolverhampton
Celtic Rebel | Wolverhampton
[NAME] | Wolverhampton
[NAME] | Wolverhampton
[NAME] | Wolverhampton
Danzadil | Wolverhampton
Turn To Dreams | Wolverhampton
Cafe Fiore | Wolverhampton
Readily | Wolverhampton
Freepressionist | Wolverhampton
[NAME] | Wolverhampton
Our Wee Girl | Wolverhampton
Spreadsheet: 330107d1404540508-vlookup-formula-to-ingnore-perticular-data-vlookup
Sheet: Sheet1

1 | - |  |  |  | 1 | RED
3 | NA |  |  |  | 2 | BLUE
2 | - |  |  |  | 3 | GREEN
4 | - |  |  |  | 4 | PURPLE
5 | NA |  |  |  | 5 | WHITE
2 | -
Column C contains vlookup formula for Column A data. I want [NAME] and C5 to have word " un-analysed", bcoz B2 and B5 have word NA other than symbol "-"
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 9d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 557279 | 731081 | 1193143 | 179097
OTHER* | 82160 | 423975 | 48095 | 296424
TOTAL | 639439 | 1155056 | 1241238 | 475521
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, FRA, Fixed-Fixed, Inflation, OIS, and Swaption.
Spreadsheet: 866460d1713369063-looking-for-a-way-to-filter-a-text-variable-kansas-scheduler-v4-6-
Sheet: ALL JOBS

 |  |  | DO NOT EDIT THIS SHEET- IT IS A REFERENCE SHEET!  DATA IS PULLED HERE FROM DIGITAL AND FABRIC TABS.
Press | SchedTime | Due Date | Job# | Line# | Master [NAME] | QTY | H | W | Material | Sides | PrintMode | Kitting | #OfKits | Notes | DateRecieved | SqFt | LinearFT
Spreadsheet: 811602d1672681762-implicit-interest-rate-formula-calculation-interest-rate-working
Sheet: loan

Asset cost |  | 64732.83
Payment schedule:
36x £2,476.68 + VAT
Final payment | 647.33
Interest
Implicit interest rate
Date | B/fwd | Interest | Payment | C/fwd
2023-01-01 00:00:00 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -647.33
Spreadsheet: 2e761261-25fb-4270-b379-b195678fdf10
Sheet: FINAL

Reported Date | Incident details
2010-03-16 00:00:00 | Confidential document was left on the photocopier
2010-03-29 00:00:00 | Electronic confidential patient/staff information belonging to another service temporarily viewable by information governance team
2010-04-15 00:00:00 | Inadvertant forwarding of email which contained claim information  to incorrect recipient within PCT
2010-04-26 00:00:00 | Outcome of exceptional case request sent to incorrect patient
2010-05-25 00:00:00 | Diary stolen from staff member's home
2010-07-09 00:00:00 | Email circulated to Clinical Directorate in error including personal details of staff member
2010-07-12 00:00:00 | Patient identifiable information found on photocopier
2010-07-12 00:00:00 | Urgent care on call pack' left on photocopier containing home and mobile telephone numbers of chief executive & directors
2010-08-13 00:00:00 | Nursing assessment sent to patient's daughter in error as had same name
2010-08-24 00:00:00 | Screenshots containing patient information sent to National Connecting for Health team
2010-09-22 00:00:00 | [NAME] sent to one staff member containing confidential information relating to 6 other members of staff
2010-09-24 00:00:00 | An appointment letter had been sent to the wrong address
2010-10-13 00:00:00 | Patient identifiable information found on photocopier
2010-10-14 00:00:00 | Staff confidential information found jammed in photocopier
2010-11-05 00:00:00 | Patient assessment documentation sent to incorrect patient's next of kin
2010-12-16 00:00:00 | Staff member completed chronology for case review and discovered details for another patient
2011-03-02 00:00:00 | Missing staff personal file
2011-03-16 00:00:00 | Confidential electronic folders temporarily accessible to staff outside of department
2011-03-30 00:00:00 | Patient letter printed to incorrect printer
2011-03-31 00:00:00 | Confidential data relating to one patient found on printer
2011-06-07 00:00:00 | Patient identifiable information sent to incorrect recipient via nhs mail
2011-06-29 00:00:00 | Staff personal file missing
2011-09-05 00:00:00 | Breach of staff confidentiality, NMC pin number input onto patient record
2011-09-16 00:00:00 | Part of child health record missing
2011-10-24 00:00:00 | Confidential email intended for Medical Director was sent to a different GP in error (email deleted unread)
Spreadsheet: chris_germany__2129__FebCohCHOICE-ENA
Sheet: Feb 1

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-02-01 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | Upstream K# | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1375 |  | 1332 |  | 67694 |  |  |  |  |  |  | 27 | 1 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 2 | 32
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 7558 |  | 6597 |  | 67694 |  |  |  |  |  |  | 27 | 3 | 31
 |  |  |  |  |  |  |  |  | 3000 |  | 3000 |  | 68918 | 103722 | 0 |  |  |  |  | 30 | 4 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 5 | 32
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2676 |  | 2307 |  | 67694 |  |  |  |  |  |  | 27 | 6 | 32
 |  |  |  |  |  |  |  |  | 2000 |  | 2000 |  | 68915 | 103722 | 0 |  |  |  |  | 28 | 7 | 31
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 |  | 0 |  |  |  |  | 30 | 8 | 32
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0 |  |  |  |  | 30 | 9 | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 15 | 33
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 15725 |  | 13200 |  | 67694 |  |  |  |  |  |  | 30 | 35 | 33
 |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 68917 | 103722 | 0 |  |  |  |  | 30 | 39 | 31
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1636 |  | 1252 |  | 67694 |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1800 |  | 1723 |  | 67694 |  |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 68916 | 103722 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 13065 |  | 11280 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 4037 |  | 3511 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 3971 |  | 3743 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 4914 |  | 4633 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1379 |  | 1150 |  | 67694
 |  |  |  |  |  |  |  |  | 257 |  | 257 |  | 69708 | 53858 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 53858 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 39 |  | 37 |  | 67694 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20500 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 793650d1661609738-compare-two-lists-find-unique-non-duplicate-values-make-new-list-with-those-sampleworkbook-excellaborer-
Sheet: Completed Survey

Completed Survey |  |  | Not Completed Survey
First Name | Last Name |  | First name | Last Name | [NAME]
[NAME] | Lamare
[NAME] | [NAME]
Louis | [NAME]
[NAME] | [NAME]
Spreadsheet: john_griffith__16111__1_22_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | 55 | 270 | 330 | 48 | 58.7 | 1.84 | 2002-01-22 12:11:00
 | [NAME] | 56 | 650 | 725 | 47.8 | 53.4 | 1.78 | 2002-01-22 12:11:00
 | [NAME] | 63 | 975 | 1075 | 47.4 | 52.3 | 1.97 | 2002-01-22 12:11:00
 | [NAME] | 64 | 1150 | 1250 | 45.1 | 49.1 | 1.9 | 2002-01-22 12:11:00
 | [NAME] | 64 | 1275 | 1375 | 43.2 | 46.6 | 1.81 | 2002-01-22 12:11:00
 | HU N2 | 64 | 1325 | 1425 | 40.7 | 43.8 | 1.7 | 2002-01-22 12:11:00
 | [NAME] | 63 | 1380 | 1480 | 39.5 | 42.4 | 1.62 | 2002-01-22 12:11:00
 | HU U2 | 61 | 1400 | 1525 | 38.4 | 41.8 | 1.54 | 2002-01-22 12:11:00
 | [NAME] | 59 | 1375 | 1525 | 36.7 | 40.8 | 1.44 | 2002-01-22 12:11:00
 | [NAME] | 58 | 1375 | 1525 | 35.3 | 39.2 | 1.36 | 2002-01-22 12:11:00
 | [NAME] |  |  |  | 35.4 | 40.3 | 1.4 | 2001-11-29 15:00:00
 | HU F3 |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU H3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 37529d1235567549-speed-optimization-timer
Sheet: Sheet1

 |  | Average Time | Improvement | Calculation | [NAME]
 | Formula 1 | 0.1445481279981323 | 0 | 268.125
 | Formula 2 | 0.05978409599920269 | 0.5864069854991469 | 268.125
 | Formula 3 | 0.07135868000186747 | 0.5063327281361298 | 268.125
 | Formula 4 | -1 | 0
 | Formula 5 | -1 | 0
 | Iterations | 1000
 | Data 1 | 6
 | Data 2 | 10
 | Data 3 | 20
 | Data 4 | 30
 | Data 5 | 40
 | Data 6 | 50
 | Data 7 | 60
 | Data 8 | 70
 | Data 9
 | Data 10
 | Data 11
 | Data 12
Spreadsheet: 764478d1642764436-automatic-award-of-vacation-time-on-anniversary-vacation-hours
Sheet: 2022

 |  |  |  | VACATION SCHEDULE
CALENDAR YEAR 2022
NAME | HIRE DATE | 2021 CARRY OVER | 2022 HOURS AWARDED |  | PAYROLL PERIOD PAID | HOURS PAID | HOURS LEFT
Schmo, [NAME] | 2020-02-20 00:00:00 | 20
 |  |  |  |  | 2022-01-14 00:00:00 | 20
 | VACATION DAYS
 | Years of Service | Vacation Hours | Date Achieved
 | 0 | 0
 | 1 | 80
 | 5 | 120
 | 10 | 160
Spreadsheet: 703695d1605116327-extract-data-from-a-table-and-plot-graph-excel-help-1
Sheet: Sheet1

Test Readings
Category | Date | Time | Type | Reading | Notes |  |  | Fasting | PP1 | PP2 | PP3
Fasting | 2020-11-08 00:00:00 | 06:45:00 | FBS | 139 |  |  | 2020-11-08 00:00:00 | 139 | 239 | 103 | 231
PP1 | 2020-11-08 00:00:00 | 11:45:00 | PPBS | 239 |  |  | 2020-11-09 00:00:00 | 129 | 203 | 146 | 224
PP2 | 2020-11-08 00:00:00 | 15:30:00 | PPBS | 103 |  |  | 2020-11-10 00:00:00 | 133 | 157 | 178 | 193
PP3 | 2020-11-08 00:00:00 | 22:15:00 | PPBS | 231 |  |  | 2020-11-11 00:00:00 | 164 | 174 | 167 | 185
Fasting | 2020-11-09 00:00:00 | 05:30:00 | FBS | 129
PP1 | 2020-11-09 00:00:00 | 10:45:00 | PPBS | 203
PP2 | 2020-11-09 00:00:00 | 15:45:00 | PPBS | 146 |  |  | [NAME] to get above data
PP3 | 2020-11-09 00:00:00 | 22:30:00 | PPBS | 224 |  |  |  | Fasting | PP1 | PP2 | PP3
Fasting | 2020-11-10 00:00:00 | 05:30:00 | FBS | 133 |  |  | 2020-11-08 00:00:00
PP1 | 2020-11-10 00:00:00 | 11:10:00 | PPBS | 157 |  |  | 2020-11-09 00:00:00
PP2 | 2020-11-10 00:00:00 | 15:30:00 | PPBS | 178 |  |  | 2020-11-10 00:00:00
PP3 | 2020-11-10 00:00:00 | 22:20:00 | PPBS | 193 |  |  | 2020-11-11 00:00:00
Fasting | 2020-11-11 00:00:00 | 06:45:00 | FBS | 164
PP1 | 2020-11-11 00:00:00 | 11:30:00 | PPBS | 174
PP2 | 2020-11-11 00:00:00 | 15:45:00 | PPBS | 167
PP3 | 2020-11-11 00:00:00 | 22:20:00 | PPBS | 185
Spreadsheet: 37456d1235492380-permutations-and-combinationns-combin-chinese-menu
Sheet: Sheet1

 |  |  |  |  |  | Names and [NAME]
Cum: | 256 | 64 | 16 | 4 |  | Cum RefersToR1C1:
Count: | 4 | 4 | 4 | 4 |  | B2 and across: =PRODUCT(B3:$F3)
 | Item1 | Item2 | Item3 | Item4 |  | B3 and across: =COUNTA(INDEX(B4:B12, 2):INDEX(B4:[NAME], [NAME]:B12) - 2))
 | A | A | A | A |  | Cnt RefersToR1C1:
 | B | B | B | B |  | Symbols RefersToR1C1:
 | C | C | C | C
 | D | D | D | D
# | Permutations |  |  |  |  | Line RefersToR1C1:
1 | A | A | A | A |  | A13 and down: =ROW()-ROW(A$12)
2 | A | A | A | B |  | B13 and across and down: =INDEX(Symbols, [NAME]( (Line - 1) * Cnt / Cum), [NAME]) + 2)
3 | A | A | A | C
4 | A | A | A | D
5 | A | A | B | A
6 | A | A | B | B
7 | A | A | B | C
8 | A | A | B | D
9 | A | A | C | A
10 | A | A | C | B
11 | A | A | C | C
12 | A | A | C | D
13 | A | A | D | A
14 | A | A | D | B
15 | A | A | D | C
16 | A | A | D | D
17 | A | B | A | A
18 | A | B | A | B
19 | A | B | A | C
20 | A | B | A | D
21 | A | B | B | A
22 | A | B | B | B
23 | A | B | B | C
24 | A | B | B | D
25 | A | B | C | A
26 | A | B | C | B
27 | A | B | C | C
28 | A | B | C | D
29 | A | B | D | A
30 | A | B | D | B
31 | A | B | D | C
32 | A | B | D | D
33 | A | C | A | A
34 | A | C | A | B
35 | A | C | A | C
36 | A | C | A | D
37 | A | C | B | A
38 | A | C | B | B
39 | A | C | B | C
40 | A | C | B | D
41 | A | C | C | A
42 | A | C | C | B
43 | A | C | C | C
Spreadsheet: 769239d1645429323-conditional-composition-of-cells-16
Sheet: Sheet1

Data |  |  |  | Expected result
Product | Color |  | Product | Color
Book | colror1 |  | Book | colror1-colror4-colror7
pen | colror2 |  | pen | colror2-colror6
Pencel | [NAME] |  | Pencel | colror3-colror8-colror10
Book | [NAME] |  | Erase | colror5-colror9
Erase | colror5
pen | colror6
Book | colror7
Pencel | colror8 |  |  | Please, without VBA & helper column
Erase | colror9 |  |  | please, with formoul
Pencel | colror10
Spreadsheet: 705902d1606371790-average-last-n-rows-based-on-conditions-sampleb-1-ans1
Sheet: Sheet1

Player | Desc | Total | Workings | Divisor | Result |  | FORMULA | Expected Result
Player A |  | 2
Player A |  | 29
Player A |  | 3
Player A |  | 5
Player A |  | 3
Player A |  | 9
Player A |  | 8
Player A | NB | 3
Player A | NB | 1
Player A |  | 22
Player B | DNQ | 0
Player B |  | 0
Player B |  | 2
Player B |  | 5
Player B | DNQ | 0
Player B |  | 7
Player B |  | 0
Player B | DNQ | 0
Player B |  | 5
Player B |  | 1
Player B | DNQ | 0
Player B | DNQ | 0
Player B | DNQ | 0
Player B | NB | 3
Player B | NB | 12
Player B | NB | 12
Player B | NB | 16
Player B | NB | 4 |  |  |  |  |  | 0 | C29+C28+C27+C26+C25)/0
Player B | NB | 0 | 5 |  |  |  |  | 0 | C30+C29+C28+C27+C26/0
Player B | NB | 9 |  |  |  |  |  | 0 | C31+C30+C29+C28+C27/0
Player B |  | 0
Player B | NB | 1 | 2
Player B | DNQ | 0
Player B | DNQ | 0
Player B |  | 2 | 1
Player B |  | 0
Player B | DNQ | 0
Player B |  | 2
Player B | DNQ | 0