tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sara_shackleton__37284__Delano2
Sheet: Sheet1

ISDA Master Swap Agreement Worksheet
 |  | ATTORNEY: | [NAME], x35620
DATE: |  | DEAL MAKER: | [NAME], (503) 464-3822
COUNTERPARTY: | Delano Energy Company, Inc. | CONTACT: | [NAME]
ADDRESS: | 81 Wyman Street | TITLE: | Attorney
 | Waltham, [NAME] | PHONE: | (781) 370-1500
 |  | FAX:
Incorporation State | Delaware Corporation | S&P Rating | n/a
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) | Thermo Ecotek Corporation (BBB) | Enron Corp. (BBB+)
LIMIT $ MILLIONS | 7000000 | 15000000
Incorporation State | DE | OR
COLLATERAL  THRESHOLD | 5000000 | 10000000
Specify Type of Debt: | Subordinated Debentures | Senior, Unsecured
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
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 | X | X
Debt Ratings Change | Subordinated Debentures | Senior, Unsecured
-Below = S&P/Moody's | BB+ | BBB- | Or is not rated by S&P to apply to both
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-EBITDA/Interest
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt
-Counterparty ($[NAME])
-Guarantor ($[NAME]) | 5 | 100
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO: x
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: x | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: x | NO:
OTHER COMMENTS:
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x3-0554
Spreadsheet: 694435d1599597299-add-a-variable-to-a-sumproduct-sumif-formula-de-pense-nouveaux-employe-s-exemple-sumproduct
Sheet: Listes déroulantes

Liste déroulante | Options | Prix | Type
Shotgun | Shotgun
 | Non | 0 | NUL
[NAME] | [NAME] | 0 | NUL
VPN | VPN | 0 | NUL
[NAME] | [NAME] | 0 | NUL
RV | RV | 0 | NUL
 | Non | 0 | NUL
Écran | Écran standard | 380 | CAPEX
 | Écran callibrable | 630 | CAPEX
 | [NAME] callibrable |  | CAPEX
[NAME]/clavier | [NAME]/clavier | 30 | CAPEX
 | Non | 0
Caméra | Caméra | 77 | CAPEX
 | Non | 0
Headset | Headset | 43 | CAPEX
 | Non | 0
Intous - On request | Intuos
 | Cintiq | 2895 | CAPEX
 | Cintiq - Stand ergo |  | CAPEX
 | Dockstation | 300 | CAPEX
amortissement : renouveller aux  3 ans | Workstation LOW
 | Workstation MID
 | Workstation HIGH
 | Macbook Air | 1600 | CAPEX
 | Macbook Air pro | 3249 | CAPEX
 | Laptop TI | 2600 | CAPEX
 | IMac
OS | Windows | 259 | CAPEX
 | Linux | 0 | NUL
 | Mac | 0 | NUL
 | Windows et Linux | 0 | NUL
 | Au choix | 0 | NUL
Logiciels | 3DsMax | 2110 | OPEX - An
 | 7-Zip (Free) | 0 | NUL
 | Adobe
 | Adobe reader pro
 | Araxis/Beyond compare | 269 | CAPEX
 | Backup/synch
 | BG renderer
 | Blue jeans
 | Bulk renamer | 0 | NUL
 | Cinema 4D
 | CineSynch | 3828 | OPEX - An
 | Cmake | 0 | NUL
 | Cyslice
 | Davinci resolve | 299 | OPEX - An
 | Deadline | 0 | NUL
 | Deadline (render farm access) | 0 | NUL
 | Direct folder
 | Drive stream
 | [NAME] performer | 12449 | OPEX - An
 | Eclipse | 0 | NUL
 | FFMpeg (Free) | 0 | NUL
 | Filezila | 0 | NUL
 | Firefox
 | Freecommander (Free) | 0 | NUL
 | Git
 | Git lab repo sstk_bundle_rig
 | [NAME]
 | Google chrome
 | Handbrake (compress video) | 0 | NUL
 | Houdini | 6763 | OPEX - An
 | [NAME] access
 | Krita | 0 | NUL
 | Libre Office (Free) | 0 | NUL
 | [NAME] | 811 | OPEX - An
 | [NAME] extension pack
 | Mattermost
 | Maya | 2110 | OPEX - An
 | Microsoft office | 25.6 | OPEX - Mois
 | Microsoft remote desktop
 | Motion builder | 2420 | OPEX - An
 | Mudbox | 110 | OPEX - An
 | Nico's code | 0 | NUL
 | Notepad++ (Free) | 0 | NUL
 | Nuke | 10758 | CAPEX
 | OBS (recording client call) | 0 | NUL
 | OpenShot (Free) | 0 | NUL
 | Optical flare/comp | 165 | CAPEX
 | Perforce
 | Permiere pro | 21 | OPEX - Mois
 | Photoshop
 | Pool (Nuke, Nuke studio, Houdini, [NAME])
 | Pycharm pro | 271 | OPEX - An
 | Python
 | Python 2.7 (Free) | 0 | NUL
 | Quicktime essential (Free) | 0 | NUL
 | Real smart motion blur
 | Reality capture | 11504 | OPEX - An
 | Redshift | 600 | CAPEX
 | RV (Free) | 0 | NUL
 | Shotgun
 | [NAME]) | 0 | NUL
 | Skype
 | Soup-dev
 | Storyboard pro 7 | 645 | OPEX - An
 | Sublime text | 88 | OPEX - An
 | Substance designer | 990 | OPEX - An
 | Substance Painter | 990 | OPEX - An
 | Sudo
 | Texture.com
 | Toonboom harmony | 645 | OPEX - An
 | [NAME]
 | Tunnelblick
 | Unreal Engine
 | UV layout | 541 | CAPEX
 | Vicon shogun
 | Visual assist | 279 | CAPEX
 | Visual studio code | 0 | NUL
 | VLC (Free) | 0 | NUL
 | VPN | 0 | NUL
 | VS code
 | WinSCP (Free) | 0 | NUL
 | World machine | 300
 | [NAME] fur
 | [NAME] | 179.95 | OPEX - 6 mois
 | Zoom | 20 | OPEX - Mois
Plugins | Color vibrance
 | Omino snake
 | Orb
 | Saber
 | Script DUIK
 | Unmult
Spreadsheet: 869414d1715978596-trying-to-sum-non-contiguous-cells-based-on-criteria-in-another-row-a-course-completion-sample-2024-05-17
Sheet: TrainingMatrix

Name | Level 3 Course A | Level 1 Course B | Level 3 Course C | Level 2 Course D | Level 1 Course E Retired | Level 3 Course F | Level 3 Course G | Level 1 Course H | Level 1 Course I | Level 2 Course J | Level 3 Course K | Level 2 Course L | Level 3 Course M | Level 1 Course N | Level 3 Course O | Level 2 Course P | Level 3 Course Q | Level 1 Course R | Level 1 Course S Retired | Level 2 Course T Retired | Level 1 Course U | Level 2 Course V | Level 3 Course W | Total Courses Completed | Total Hours Completed | Level 1 Courses Completed | Level 1 Hours Completed | Level 2 Courses Completed | Level 2 Hours Completed | Level 3 Courses Completed | Level 3 Hours Completed
 | 1.25 | 0.5 | 1 | 1 | 2.5 | 0.6 | 1 | 0.25 | 1 | 2 | 0.5 | 0.5 | 0.25 | 0.5 | 0.25 | 1.25 | 0.5 | 1 | 0.5 | 1 | 0.5 | 0.5 | 1
Employee 1 | 2023-06-16 00:00:00 | 2023-02-07 00:00:00 |  | 2023-05-02 00:00:00 | 2022-12-12 00:00:00 | 2023-06-04 00:00:00 | 2023-06-16 00:00:00 | 2022-12-19 00:00:00 | 2022-12-12 00:00:00 | 2023-05-01 00:00:00 | 2023-06-16 00:00:00 | 2023-05-19 00:00:00 | 2023-07-01 00:00:00 | 2022-12-19 00:00:00 |  | 2023-05-09 00:00:00 | 2023-07-01 00:00:00 |  | 2023-07-24 00:00:00 | 2022-12-26 00:00:00 | 2023-07-03 00:00:00 | 2023-05-16 00:00:00
Employee 2 | 2023-06-15 00:00:00 | 2022-11-12 00:00:00 | 2023-06-14 00:00:00 | 2023-01-31 00:00:00 | 2022-11-19 00:00:00 | 2023-05-23 00:00:00 | 2023-05-06 00:00:00 | 2022-11-13 00:00:00 | 2022-10-29 00:00:00 | 2023-01-16 00:00:00 | 2023-05-20 00:00:00 | 2023-02-20 00:00:00 | 2023-06-08 00:00:00 | 2022-11-13 00:00:00 | 2023-06-08 00:00:00 | 2023-01-31 00:00:00 | 2023-06-06 00:00:00 | 2022-11-15 00:00:00 | 2022-11-12 00:00:00 | 2022-11-15 00:00:00 | 2023-06-06 00:00:00 | 2023-02-22 00:00:00 | 2023-06-07 00:00:00
Employee 3 |  | 2022-10-29 00:00:00 |  |  | 2022-10-21 00:00:00 |  |  | 2022-10-14 00:00:00 | 2022-11-12 00:00:00 | 2023-01-20 00:00:00 |  | 2023-02-10 00:00:00 |  | 2022-11-05 00:00:00 |  | 2023-01-21 00:00:00 |  |  | 2022-11-04 00:00:00 | 2022-10-29 00:00:00 | 2023-04-07 00:00:00 | 2023-02-04 00:00:00
Employee 4 | 2023-03-14 00:00:00 | 2022-11-01 00:00:00 |  | 2023-01-22 00:00:00 | 2022-10-14 00:00:00 | 2023-05-14 00:00:00 | 2023-03-06 00:00:00 | 2022-10-26 00:00:00 | 2022-11-07 00:00:00 | 2023-01-20 00:00:00 | 2023-02-16 00:00:00 | 2023-02-03 00:00:00 | 2023-02-14 00:00:00 | 2022-11-06 00:00:00 |  | 2023-01-30 00:00:00 | 2023-02-20 00:00:00 | 2022-11-01 00:00:00 | 2022-11-01 00:00:00 | 2022-10-24 00:00:00 | 2023-04-25 00:00:00 | 2023-02-02 00:00:00
Employee 5 |  | 2024-01-19 00:00:00 |  |  | 2024-01-17 00:00:00 |  |  | 2024-01-18 00:00:00 | 2024-01-16 00:00:00 |  |  |  |  | 2024-01-19 00:00:00 |  |  |  |  |  |  | 2024-01-19 00:00:00
Spreadsheet: 134443d1325283182-vlookup-based-on-two-different-search-factors-but-how-diary-2011
Sheet: TW3 3AT

2011 | Reference | Expiry / Frequency | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | Totals
Mortgage (every 20th) | 10837155 |  | 185 | 185 | 185 | 185 | 185 | 185 | 185 | 185 | 185 | 185 | 185 | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | The yellow cell above should be displaying £185 from the other tab. Not sure what is wrong with the formula?
Spreadsheet: 218020d1362302115-cumulative-conditional-formatting-based-on-sum-cumulative-conditional-formatting
Sheet: Sheet1

Sales Consultant | Sales | % as sales | Cumalative Total |  | Required Outcome (MANUAL)
SC 1 | 33652272.79 |  |  |  | 0.2655920808160009
SC 2 | 12886356.71 |  |  |  | 0.3672944030960925
SC 3 | 10209985.89 |  |  |  | 0.4478741432684386
SC 4 | 7366728.66 |  |  |  | 0.5060141924064472
SC 5 | 7257277.14 |  |  |  | 0.5632904230105138
SC 6 | 7021274.02 |  |  |  | 0.6187040584754344
SC 7 | 6104649.25 |  |  |  | 0.6668834639817731
SC 8 | 5523772.94 |  |  |  | 0.7104784496234463
SC 9 | 5023564.44 |  |  |  | 0.7501256657582609
SC 10 | 4981297.28 |  |  |  | 0.7894392989863686
SC 11 | 4305521.07 |  |  |  | 0.8234195388089293
SC 12 | 3733627.35 |  |  |  | 0.8528862515943046
SC 13 | 3698162.32 |  |  |  | 0.8820730655694962
SC 14 | 2284763.6 |  |  |  | 0.9001049863994312
SC 15 | 2235139.74 |  |  |  | 0.9177452634221925
SC 16 | 2227928.57 |  |  |  | 0.9353286281033308
SC 17 | 2114316.27 |  |  |  | 0.9520153363431171
SC 18 | 2112692.28 |  |  |  | 0.968689227651161
SC 19 | 2001168.59 |  |  |  | 0.9844829463458359
SC 20 | 1966113.3 |  |  |  | 1
Spreadsheet: 886382d1736422662-need-formula-bedvel_csreddy
Sheet: Summary

 |  | S. No | Driver Name | RT1 |  |  | RT3-2 |  |  | RT4 |  |  | RT2 |  |  | RT3-1 |  |  | RT5 | RT5 | RT5
 |  |  |  | Route | Saving | Insentive | Route | Saving | Insentive | Route | Saving | Insentive | Route | Saving | Insentive | Route | Saving | Insentive | Route
 |  | 1 | A Sanjay | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 1 | 0 | 0
 |  | 2 | Achari |  |  |  |  |  |  |  |  |  | 1 | 11 | 129
 |  | 3 | Anil |  |  |  |  |  |  | 2 | 39 | 652 |  |  |  | 1 | 25 | 488
 |  | 4 | Anjaneyulu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0
 |  | 5 | [NAME] |  |  |  |  |  |  | 3 | 0 | 0
 |  | 6 | [NAME] |  |  |  |  |  |  | 4 | 66 | 1086
 |  | 7 | Chandu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 25 | 635
 |  | 8 | D.K.Yadav | 3 | 0 | 0
 |  | 1 | A Sanjay
 |  | 2 | Achari
 |  | 3 | Anil
 |  | 4 | Anjaneyulu
 |  | 5 | [NAME]
 |  | 6 | [NAME]
 |  | 7 | Chandu
 |  | 8 | D.K.Yadav
Spreadsheet: 606262d1547551926-need-something-more-efficient-for-preparing-company-budget-format
Sheet: Revenue

 |  | Total | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00
 | Production volume of customer
 | Motorcycle Model 1 |  | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
 | [NAME] |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 | [NAME] |  | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
 | Motorcycle Model 4 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 | [NAME] |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 | Motorcycle Model 6 |  | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
 | Motorcycle component 1
 | Quota of our company
 | Motorcycle Model 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] |  | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6
 | [NAME] |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
 | Motorcycle Model 4 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Motorcycle Model 6 |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2
 | Our production volume (this may include numbers from other sheets too other than the quantity calculated by the formula)
 | Motorcycle Model 1
 | [NAME]
 | [NAME]
 | Motorcycle Model 4
 | [NAME]
 | Motorcycle Model 6
 | Selling price per unit
 | Motorcycle Model 1 |  | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2100 | 2100 | 2100 | 2100 | 2100 | 2100
 | [NAME] |  | 2100 | 2100 | 2100 | 2100 | 2100 | 2100 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200
 | [NAME] |  | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3100 | 3100 | 3100 | 3100 | 3100 | 3100
 | Motorcycle Model 4 |  | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3600 | 3600 | 3600 | 3600 | 3600 | 3600
 | [NAME] |  | 3600 | 3600 | 3600 | 3600 | 3600 | 3600 | 3700 | 3700 | 3700 | 3700 | 3700 | 3700
 | Motorcycle Model 6 |  | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5100 | 5100 | 5100 | 5100 | 5100 | 5100
 | Revenue
 | Motorcycle Model 1
 | [NAME]
 | [NAME]
 | Motorcycle Model 4
 | [NAME]
 | Motorcycle Model 6
 | Revenue
 | Motorcycle component 2
Spreadsheet: 674352d1587779694-and-or-conditional-formatting-with-multiple-criteria-example-1-kirbstomp1287-
Sheet: Sheet1

 | Condition 1 |  | Condition 2 |  |  |  |  |  |  |  |  |  | Criteria 1 | [NAME] | Criteria 3 | [NAME]
 | -SHRA |  |  |  |  | <--- Table 1 shows -SHRA, Table 2 shows Null. Table 1 should be highlighted |  |  |  |  |  |  | -SHRA | -TSRA | BR | NSW
 |  |  | -SHRA |  |  | <--- Table 1 shows Null, Table 2 shows -SHRA. Table 1 should be highlighted |  |  |  |  |  |  | SHRA | TSRA | FG
 | -SHRA |  | -TSRA |  |  | <--- Table 1 shows -SHRA, Table 2 shows -TSRA. Table 1 should be highlighted |  |  |  |  |  |  | +SHRA | +TSRA | HZ
 | -SHRA |  | -RA |  |  | <--- Table 1 shows -SHRA, Table 2 shows -RA. Table 1 should not be highlighted |  |  |  |  |  |  | -RA | TSRAGR
 | -TSRA |  | HZ |  |  |  |  |  |  |  |  |  | RA | VCTS
 | -SHRA |  | NSW |  |  |  |  |  |  |  |  |  | +RA
 |  |  |  |  |  |  |  |  |  |  |  |  | DZ
 |  |  |  |  |  |  |  |  |  |  |  |  | VCSH
Spreadsheet: 162547d1339960277-keep-past-date-numbers-debt-to-ratio-calculator-tsig-2012
Sheet: year

2012
 |  | 2012-01-12 00:00:00 |  |  | 2012-02-12 00:00:00 |  |  | 2012-03-12 00:00:00 |  |  | 2012-04-12 00:00:00 |  |  | 2012-05-12 00:00:00 |  |  | 2012-06-12 00:00:00
 |  | Assits | Equity | Earnings | Assits | Equity | Earnings | Assits | Equity | Earnings | Assits | Equity | Earnings | Assits | Equity | Earnings | Assits | Equity | Earnings
TSEC |  | 0.7210918923081981 | 2.585411922540557 | 4.535193604359899 | 0.7210918923081981 | 2.585411922540557 | 2.614144618158035 | 0.597052224123082 | 1.481711685598499 | 1.365262845266587 | 0.5597195720268451 | 1.271279703718678 | 1.07905169275893
TSAC |  | 0.3439814433232465 | 0.5243494765748747 | 5.598965071151358 | 0.5822096888656483 | 1.393545214787001 | 5.724958263772955 | 0.4928496420421102 | 0.9718055694796832 | 3.036798727588201 | 0.706144937214963 | 2.403045372582676 | 3.866472926028926
TSCF |  | 0.6609875400733715 | 1.949755969753654 | -10.03204063078032 | 0.6215565464886739 | 1.642402691133014 | -7.534244628850745 | 0.571454038788129 | 1.333481729078025 | -2.468821359564377 | 0.5055299861071226 | 1.022367326437395 | -1.464705750073085
GPC |  | 0.5039461157076389 | 1.015910028456962 | 7.073928919182084 | 0.4486010968028806 | 0.8135690771269278 | 2.673726875909374 | 0.4401251645818385 | 0.7861155998844215 | 1.432769155000317 | 0.4035938960180521 | 0.6767098681979086 | 0.9624445841047679
TSIG |  | 2.983708609271523 | -1.504126382137706 | 40.29874776386404 | 2.249770523540112 | -1.800170931040008 | 52.3104384943733 | 2.205027114880196 | -1.829856845253993 | 14.29449196745253 | 1.530862534648131 | -2.883705650898616 | -2.883705650898616
TOTAL |  | 0.6934426077659586 | 2.262033995143551 | 5.272693124459764 | 0.6953381429316285 | 2.28232752738582 | 3.014346014500247 | 0.5895350475683263 | 1.436263182387488 | 1.53010637687513 | 0.5778645107219661 | 1.368908180457836 | 1.326004565721452
 |  | 2012-07-12 00:00:00 |  |  | 2012-08-12 00:00:00 |  |  | 2012-09-12 00:00:00 |  |  | 2012-10-12 00:00:00 |  |  | 2012-11-12 00:00:00 |  |  | 2012-12-12 00:00:00
 |  | Assits | Equity | Earnings | Assits | Equity | Earnings | Assits | Equity | Earnings | Assits | Equity | Earnings | Assits | Equity | Earnings | Assits | Equity | Earnings
TSEC
TSAC
TSCF
GPC
TSIG
TOTAL
Spreadsheet: mike_grigsby__27821__HS_WESTminusPA1029
Sheet: Run Query

Daily Hedge Strip
User ID:
Password:
Included Deals | ALL
Today
Days in Month | 30
Day of Month |  | 2001-10-29 00:00:00 | Update this cell daily
PromptMonth | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
StartRange | D4
Enter EASTMEX Date:
[NAME] | NXB2 | NX1
2001-10-25 00:00:00 | 2001-10-26 00:00:00 | 2001-10-29 00:00:00
Please Note:  Once the 'RUN ' button has been pressed, please do not disturb Excel.  Doing so will make you a bad person.
Book Type | Book
Type
D | ENA-FT-WC-CAL-BAS
D | ENA-FT-WT-CAL-BAS
D | ENA-FT-WC-ROX-BAS
D | ENA-FT-WT-SJ-BAS
D | ENA-FT-WC-SJ-BAS
D | ENA-FT-WT-ROX-BAS
D | FT-DENVER-BAS
D | FT-REGS-BAS
D | ENA-FT-WT-SOCAL-BAS
D | FT-WEST-OPT-BAS
DO | FT-NW-XL-OPT-BAS
DO | FT-WE-XL-OPT-BAS
DO | GD-NEW-XL-OPT-BAS
D | TRANS-WEST-BAS
M | ENA-FT-WC-CAL-GDL
M | ENA-FT-WT-CAL-GDL
M | ENA-FT-WC-ROX-GDL
M | ENA-FT-WT-SJ-GDL
M | ENA-FT-WC-SJ-GDL
M | ENA-FT-WT-ROX-GDL
M | FT-DENVER-GDL
M | FT-REGS-GDL
M | ENA-FT-WT-SOCAL-GDL
M | ENA-FT-WT-SCAN-GDL
PHY | ENA-IM-WC-CAL-PHY
PHY | ENA-IM-WT-CAL-PHY
PHY | ENA-IM-WC-ROX-PHY
PHY | ENA-IM-WT-SJ-PHY
PHY | ENA-IM-WC-SJ-PHY
PHY | ENA-IM-WT-ROX-PHY
PHY | INTRA-DENVER-PHY
PHY | ENA-FT-WT-SOCAL-PHY
I | ENA-FT-WC-CAL-IDX
I | ENA-FT-WT-CAL-IDX
I | ENA-FT-WC-ROX-IDX
I | ENA-FT-WT-SJ-IDX
I | ENA-FT-WC-SJ-IDX
I | ENA-FT-WT-ROX-IDX
I | FT-DENVER-IDX
I | FT-REGS-IDX
I | ENA-FT-WT-SOCAL-IDX
Spreadsheet: 868234d1714981536-tier-incentive-will-be-automatically-calculated-based-on-tier-doctors-calculation-april-2024-allan-sampling-of-doing-formula-copy-1-aligw
Sheet: Dr. Haifa Al Khodier

 |  |  | Total Revenue
 |  |  | Consumables | 0
 |  |  | LAB Fees -
 |  |  | The Clinics OR Fees
 |  |  | Dr. [NAME]
 |  |  | Lab Revenue | 0
 |  |  | Lab 10%
 |  |  | Net Payment
 |  |  | Service | Amount | OHE | % | Comm. % | Comm.
 |  |  | Consultation | 600 | 0.05 |  | 0.5
 |  |  | Referral | 0 | 0.05 |  | 0.1
 |  |  | Procedure | 1950 | 0.05 |  | 0.4
 |  |  | OR In the Clinics | 0 | 0.05 |  | 0.35
 |  |  | OR Outside the Clinics |  | 0.05 |  | 0.55
 |  |  | Other Exp.
 |  |  | Marketing (50-50) | 556
 |  |  |  |  | Doctor [NAME] ……………
Spreadsheet: 100723d1298995187-excel-2007-sum-and-and-skip-a-column-test_sum
Sheet: Plan1

 |  |  | 2012 |  | 2013 |  | 2014 |  | 2015 |  | 2016 |  | 2017 |  | 2018 |  | 2019 |  | 2020 |  | 2021
 |  |  | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd
 |  | steam | 7747.444696391081 | 7747.444696391081 | 8086.008029623371 | 8086.008029623371 | 8434.514975700136 | 8434.514975700136 | 8798.04257115281 | 8798.04257115281 | 9177.238205969494 | 9177.238205969494 | 9572.777172646778 | 9572.777172646778 | 9985.363868787854 | 9985.363868787854 | 10415.7330515326 | 10415.7330515326 | 10864.65114605366 | 10864.65114605366 | 11332.91761044857 | 11332.91761044857
 |  | pwr | 5897.228110855636 | 5897.228110855636 | 6154.936979300028 | 6154.936979300028 | 6420.214763107858 | 6420.214763107858 | 6696.926019397805 | 6696.926019397805 | 6985.56353083385 | 6985.56353083385 | 7286.641319012788 | 7286.641319012788 | 7600.695559862238 | 7600.695559862238 | 7928.285538492299 | 7928.285538492299 | 8269.994645201316 | 8269.994645201316 | 8626.431414409491 | 8626.431414409491
 |  |  | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018
 |  | ttl steam
 |  | ttl pwr
Spreadsheet: 818988d1677158441-countif-using-multiple-criteria-countif-against-multiple-criteria
Sheet: Sheet1

Order name | Type |  | Subject | Count of Resources Orders | Product names | Product names | Product names | Product names
Maths [NAME] [NAME] | Resources |  | Primary Extended Curriculum | 1 | Ext curr
[NAME] School Maths [NAME] | Qualifications |  | Primary Maths | 1 | Primary Maths
English KS3 London Academy | Resources |  | Primary English | 1 | Primary English
[NAME] | Resources |  | Secondary Maths | 1 | Maths KS3 | Maths GCSE | Maths GCE
History GCSE St Lukes | Resources |  | Secondary English | 2 | English KS3 | English GCSE | English GCE
[NAME] | Qualifications |  | Secondary Science | 3 | Science KS3 | Science GCSE | Science GCE | Science KS3 & GCSE
Geography GCE | Qualifications |  | Secondary MFL | 1 | MFL KS3 | MFL GCSE | MFL GCE
Geography GCE | Resources |  | Secondary History | 3 | History KS3 | History GCSE | History GCE
Geography KS3 | Resources |  | [NAME] | 2 | Geography KS3 | Geography GCSE | Geography GCE
English GCE Mr [NAME] | Resources
MFL KS3 | Resources
MFL KS3 | Qualifications
[NAME] Science KS3 & GCSE | Resources
Science KS3 & GCSE | Qualifications
Ext curr | Resources
Science KS3 & GCSE London Free School | Resources |  | Count conditions | Count in column E against relevant subject in column D when the following conditions are met: column B must say "Resources" and column A must contain one of the products listed against that subject in columns F:I
Science GCSE Birmingham Academy | Resources
History GCSE St Lukes | Qualifications
History KS3 Birmingham Academy | Resources
Primary English | Resources
Primary Maths | Resources
Spreadsheet: 875581d1722188877-how-to-make-index-work-after-drag-solved-test
Sheet: септември

№ | Name | 1 | 2 | 3 | 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 | 31
 |  | MAX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MIN
Spreadsheet: 555171d1515466420-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: Tournament 1

 |  |  | Tournament 1
 |  |  |  |  |  |  | Player | Points | Low Score
 |  |  | Player | Score | Points
 |  |  |  | 23
 |  |  |  | 25
 |  |  |  | 26 |  |  | To sort by Points select (Highlight) Range D6 to F56 then on the
 |  |  |  | 26 |  |  | Home Ribbon select '[NAME], 'Custom, Check the 'My Data has Headers box,
 |  |  |  | 26 |  |  | then select ' Sort by Points, 'Largest to Smallest.
 |  |  |  | 26
 |  |  |  | 27 |  |  | To clear the Player Names & Scores select the Range D7 to [NAME] then on the
 |  |  |  | 27 |  |  | Home Ribbon select 'Clear, 'Contents
 |  |  |  | 27
 |  |  |  | 28 |  |  | The [NAME]  that goes in F7 is =IFERROR(RANK(E7,$E$7:$E$56,0),0)
 |  |  |  | 28 |  |  | then filled down to F56
 |  |  |  | 29
 |  |  |  | 32 |  |  | The [NAME]  that goes in I6 is =MAX(F7:F56)
 |  |  |  | 33
 |  |  |  | 33 |  |  | The [NAME]  that goes in J6 is =MIN(F7:F56)
 |  |  |  | 34
 |  |  |  | 34
 |  |  |  | 38
 |  |  |  | 41
 |  |  |  | 44
 |  |  |  | 45
 |  |  |  | 46
 |  |  |  | 46
 |  |  |  | 47
 |  |  |  | 50
 |  |  |  | 51
 |  |  |  | 52
 |  |  |  | 52
 |  |  |  | 53
 |  |  |  | 55
 |  |  |  | 55
 |  |  |  | 56
 |  |  |  | 56
 |  |  |  | 59
 |  |  |  | 60
 |  |  |  | 60
 |  |  |  | 64
 |  |  |  | 65
 |  |  |  | 67
 |  |  |  | 67
 |  |  |  | 68
 |  |  |  | 69
 |  |  |  | 69
 |  |  |  | 69
 |  |  |  | 71
 |  |  |  | 71
 |  |  |  | 72
 |  |  |  | 75
 |  |  |  | 75
 |  |  |  | 75
 |  | x | x | x
Spreadsheet: 765573d1643390122-textjoin-array-using-if-with-nested-and-book1
Sheet: Calendar

[NAME] issue | 2022-02-01 00:00:00 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00 |  | Test formula just unit | Test formula Just date
Unit1
Unit2
Correct output
 | 2022-02-01 00:00:00 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00
Unit1 | a,b,c,d | d |  | h
Unit2 | l,k | m