tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30669__200002_OA
Sheet: TX-HPLC-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  [NAME]
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 36900025 | 94911803
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 2977937 | 7717976
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 39877962 | 102629779
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -49170850 | -123832756
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -1026352 | -2529624
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 10222 | 25174
 | Total Purchases: |  | -50186980 | -126337206
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 71769462 | 185679535
12 |  | Purchases | -68413427 | -176861650
 | Total Intra CTS Sales / Purchases |  | 3356035 | 8817885
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 9366761 | 23686243
18 |  | W/D (Purchase from Stg) | -11877403 | -30653457
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -11877403 | -30653457
 | Total Storage: |  | -2510642 | -6967214
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 9463625 | 23807132.80701241
 |  |  | 0 | 0
23 | Fuel: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -1384131
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -1384131
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | -98300
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 43113d1241708665-nesting-various-formulas-using-dates-and-salary-example
Sheet: Data

 | Name | Salary | Dept | Status | Term Date | Paid Through Date
 | x | 100000 | Acctg | T | 2009-01-15 00:00:00 | 2009-05-22 00:00:00
 | y | 50000 | Mktg | A | NA | NA
 | z | 80000 | Eng | A | NA | NA
Spreadsheet: 35163d1232689560-sorting-issues-off-season-09
Sheet: The Blue Legume

Pos | Batters |  | H/AB | R | HR | RBI | SB | BB | K | AVG | OBP | SLG | TLR
C | [NAME] | (SF - C) | 155/530 | 46 | 16 | 95 | 0 | 19 | 38 | 0.292 | 0.322 | 0.445
1B | [NAME] | (KC - 1B,3B) | 128/493 | 72 | 16 | 59 | 9 | 66 | 120 | 0.26 | 0.351 | 0.432
2B | [NAME] | (ChC - 2B,SS) | 178/580 | 85 | 1 | 38 | 22 | 73 | 58 | 0.307 | 0.387 | 0.359
3B | [NAME] | (Was - 3B) | 121/428 | 51 | 14 | 51 | 1 | 31 | 71 | 0.283 | 0.333 | 0.442
SS | [NAME] | (Ari - SS) | 178/611 | 91 | 21 | 67 | 3 | 41 | 109 | 0.291 | 0.333 | 0.502
OF | [NAME] | (ChC - 1B,2B,3B,OF) | 144/505 | 103 | 21 | 87 | 6 | 69 | 106 | 0.285 | 0.376 | 0.481
OF | [NAME] | (NYY - OF) NA | 180/609 | 100 | 20 | 100 | 22 | 73 | 109 | 0.296 | 0.371 | 0.471
OF | [NAME] | (Tex - OF) NA | 133/414 | 78 | 22 | 77 | 5 | 80 | 112 | 0.321 | 0.436 | 0.563
Util | [NAME] | (NYY - 1B) | 113/458 | 68 | 32 | 96 | 2 | 76 | 111 | 0.247 | 0.373 | 0.502
Util | [NAME] | (NYM - OF) | 172/606 | 116 | 27 | 112 | 25 | 92 | 96 | 0.284 | 0.376 | 0.5
BN | [NAME] | (StL - 1B) | 187/524 | 100 | 37 | 116 | 7 | 104 | 54 | 0.357 | 0.462 | 0.653
BN | Jacoby Ellsbury | (Bos - OF) | 155/554 | 98 | 9 | 47 | 50 | 41 | 80 | 0.28 | 0.336 | 0.394
DL | [NAME] | (Cin - 2B) DL | 146/559 | 80 | 21 | 78 | 23 | 39 | 93 | 0.261 | 0.312 | 0.442
Pos | Pitchers |  | IP | W | L | SV | BB | K | HLD | ERA | WHIP | K/9 | TLR
SP | [NAME] | (LAA - SP) | 219 | 16 | 7 | 0 | 47 | 214 | 0 | 3.49 | 1.12 | 8.79
SP | [NAME] | (SF - SP) | 217.2 | 8 | 14 | 0 | 91 | 186 | 0 | 3.76 | 1.36 | 7.69
SP | [NAME] | (ChC - SP) | 148 | 10 | 2 | 0 | 61 | 181 | 0 | 2.07 | 1.06 | 11.01
SP | [NAME] | (Bos - SP,RP) | 88.1 | 6 | 5 | 0 | 40 | 68 | 3 | 3.16 | 1.22 | 6.93
RP | [NAME] | (LAD - RP) | 69 | 3 | 5 | 14 | 27 | 88 | 13 | 3.13 | 1.17 | 11.48
RP | [NAME] | (Pit - RP) | 53.2 | 2 | 3 | 21 | 5 | 39 | 0 | 3.02 | 0.97 | 6.54
RP | [NAME] | (CWS - RP) | 61.2 | 3 | 1 | 30 | 17 | 38 | 0 | 2.63 | 1.1 | 5.55
P | [NAME] | (CWS - RP) | 67.1 | 5 | 3 | 1 | 19 | 77 | 20 | 2.67 | 1 | 10.29
BN | [NAME] | (Min - SP) | 172.1 | 11 | 4 | 0 | 42 | 141 | 0 | 3.45 | 1.18 | 7.36
BN | [NAME] | (CWS - SP) | 195 | 12 | 9 | 0 | 57 | 159 | 0 | 3.32 | 1.23 | 7.34
Spreadsheet: 600689d1543913724-monster-conditional-formatting-dummy-data
Sheet: Current

 | Start
 | Sun | [NAME] | Earth | Mars | Delivered To | From
 |  |  |  |  |  |  | Starts like this
 | Step 1
 | Sun | [NAME] | Earth | Mars | Delivered To | From
 |  |  |  |  |  | [NAME] | User enters data
 | Step 2
 | Sun | [NAME] | Earth | Mars | Delivered To | From
 |  |  |  |  | Sun | [NAME] | User enters data
 | Step 3
 | Sun | [NAME] | Earth | Mars | Delivered To | From
 |  | -1 |  |  | Sun | [NAME] | User enters data
 | Step 4
 | Sun | [NAME] | Earth | Mars | Delivered To | From
 | 1 | -1 |  |  | Sun | [NAME] | User enters data
Spreadsheet: louise_kitchen__24242__JulYTD Orig w notes
Sheet: East Gas

East Gas
Originator |  | Commodity |  | Team |  | Total |  | %Total
DePaolis |  | Gas |  | East
[NAME] |  | Gas |  | East
Kaiser |  | Gas |  | East |  | 1459732
Ferries |  | Gas |  | East
Muhl |  | Gas |  | East |  | 756363
Concannon |  | Gas |  | East |  | 550919
Barbe |  | Gas |  | East
Smith,[NAME] |  | Gas |  | East
DeMoes |  | Gas |  | East |  | 150517
Hodge |  | Gas |  | East |  | 100279.16
Singer |  | Gas |  | East
[NAME] |  | Gas |  | East
Goodell |  | Gas |  | East |  | 20657
Martinez |  | Gas |  | East |  | 232
Miscellaneous |  | Gas |  | East |  | -10927
Total
Spreadsheet: 3c7c4268-a590-4041-8d02-51de4ae62dfa
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MORP | Test | MORP | [NAME], Unconjugated, Serum | [NAME], Unconjugated, S | Gas Chromatography-Mass Spectrometry Using Selected Ion Monitoring (GC-MS SIM) | Plain, Red-Top Tube: Red |  |  | 5 | mL | Container/Tube: Red top [NAME]: 5 mL | 2.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Therapeutic: 70-450 ng/mL Tolerant patients: <1,500 ng/mL Toxicity: >700 ng/mL | Thursday; 8 a.m. | 2 days | 8 days | 1 | 83925 |  |  |  |  | Rochester
MORP | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
MORP | Result | 83132 | [NAME], Unconjugated, S | [NAME], Unconjugated, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3827-3
Spreadsheet: benjamin_rogers__1164__FPL
Sheet: Charts

FPL Asset Characteristics (only for Facilities that are in Operations or in Construction)
* Source: Powerdat |  |  |  |  | * Source: Power Dat
 | FPL Energy |  |  | FPL Energy
 | Grid Profile (By Net MW) |  |  | [NAME] (By Net MW)
 | PJM |  |  | Wind
 | NEPOOL |  |  | Gas
 | CAMX |  |  | Geo Thermal
 | SERC |  |  | Waste | 20
 | MAPP |  |  | Solar
 | NWPA |  |  | Hydro
 | ERCOT |  |  | Fossil
 | Total |  |  | Total
 | FPL (Regulated) |  |  | FPL (Regulated)
 | Grid Profile (By Net MW) |  |  | [NAME] (By Net MW)
 | SERC |  |  | Gas
 | FRCC |  |  | Oil
 | Total |  |  | Gas/Oil
 |  |  |  | Oil/Gas
 |  |  |  | Coal
 |  |  |  | Coal/Petroleum
 |  |  |  | Nuclear
 |  |  |  | Total
Spreadsheet: 769297d1645457135-combine-if-function-and-sum-countif-indirect-testing
Sheet: Sheet1

NAME | DATE | [NAME] |  |  |  | NAME | NORMAL DAYS | WEEKEND DAYS | Holly days
RAMI | 2022-01-01 00:00:00 |  |  |  |  | RAMI |  |  |  |  | RAMI | 2022-01-01 00:00:00
NASSIM | 2022-01-02 00:00:00 |  |  |  |  | NASSIM |  |  |  |  | NASSIM | 2022-01-02 00:00:00
 |  |  |  |  |  | FARID |  |  |  |  | FARID | 2022-01-03 00:00:00
 |  |  |  |  |  | KARIM |  |  |  |  | KARIM | 2022-01-04 00:00:00
 |  |  |  |  |  | KHALED |  |  |  |  | KHALED | 2022-01-05 00:00:00
 |  |  |  |  |  | NIHAL |  |  |  |  | NIHAL | 2022-01-06 00:00:00
 |  |  |  |  |  | DJAMAL |  |  |  |  | DJAMAL | 2022-01-07 00:00:00
 |  |  |  |  |  | ALI |  |  |  |  | ALI | 2022-01-08 00:00:00
 |  |  |  |  |  | [NAME] |  |  |  |  | [NAME] | 2022-01-09 00:00:00
Spreadsheet: 785225d1656260938-conditional-lookup-based-on-two-cells-cadet-tracker
Sheet: Menu

CADET | Abinitio | FO |  | Sponsorship
[NAME] | Waiting for SIM | Assessment |  | MOHE
SIM Phase - Advanced | Flight School Foundation -CK043 | Ground Introduction |  | Self
SIM Phase - Intermediate | Flight School Night -CK044-047 | SIM
SIM Phase - Basic | [NAME] | [NAME] 1
Flight School CK51 - CK70 | Final Check | [NAME] 2
Flight School CK31 - CK50 |  | Completion Date
Flight School CK01 - CK30
Ground School
Spreadsheet: 152906d1335585627-excel-2007-formula-or-vba-programing-to-find-and-get-cell-value-on-comparing-two-text-strings-example
Sheet: Sheet1

Have to check from | Check with | Split 1 | Geo | Result
Airliners.net IPad | Bear In Heaven | ar I |  | DM - IC - Jagjaguwar Bear In Heaven
Answerbag - RightMedia | A Lonely Place To Die | Lone |  | DM - IC - MPI - Lonely Place to Die
AdX - Quickmeme | Drake GEO NYC | ake | NYC | DM - IC - Live Nation Drake GEO NYC
DM - IC - Jagjaguwar Bear In Heaven | Drake GEO LA | ake | LA | DM - IC - Live Nation Drake LA GEO
DM - IC - MPI - Lonely Place to Die | Kaskade GEO CT | [NAME] | CT | DM - IC - Live Nation Kaskade CT GEO
DM - IC - Live Nation Drake GEO NYC
DM - IC - Live Nation Drake LA GEO
DM - IC - Live Nation Kaskade CT GEO
Spreadsheet: 158251d1338114651-excel-vlookup-issue-testsetup-3-
Sheet: Sheet1

 |  |  |  | Size | 54" 9'
Name | CH | LF | OP | Pan | Net Pan | Yds
WC-q | 8 | 453 | 1 | 109.6056133559158 | 110 | 300
 |  |  |  | note since all these values are the same the result will never change
Size | Result | Result2
54" 8' | 4.333 | /11*30
54" 9' | 4.133 | /9*30
54" 10' | 4.333 | /8*30
Spreadsheet: 751322d1634047132-letters-to-represent-value-timesheet-example
Sheet: Sheet1

Name: |  |  |  |  |  |  |  |  |  |  |  |  | Standard Hours | 37.5
Week Commencing | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Weekly Tot | Weekly +/- | Running Total | Notes | Manager and Staff initials
2021-08-23 00:00:00 | 11.25 |  | 11.25 |  | 11.25
2021-08-30 00:00:00 |  | 11.25 | 11.25 | 11.25
2021-09-06 00:00:00 | 11.25 |  | 11.25 | 11.25 | 11.25
2021-09-13 00:00:00 |  | 11.25 | 11.25 | 11.25 | 11.25
2021-09-20 00:00:00
2021-09-27 00:00:00
2021-10-04 00:00:00
2021-10-11 00:00:00
2021-10-18 00:00:00
2021-10-25 00:00:00
2021-11-01 00:00:00
2021-11-08 00:00:00
2021-11-15 00:00:00
2021-11-22 00:00:00
2021-11-29 00:00:00
2021-12-06 00:00:00
2021-12-13 00:00:00
2021-12-20 00:00:00
2021-12-27 00:00:00
2022-01-03 00:00:00
2022-01-10 00:00:00
2022-01-17 00:00:00
2022-01-24 00:00:00
2022-01-31 00:00:00
2022-02-07 00:00:00
2022-02-14 00:00:00
2022-02-21 00:00:00
2022-02-28 00:00:00
2022-03-07 00:00:00
2022-03-14 00:00:00
2022-03-21 00:00:00
2022-03-28 00:00:00
2022-04-04 00:00:00
2022-04-11 00:00:00
2022-04-18 00:00:00
2022-04-25 00:00:00
2022-05-02 00:00:00
2022-05-09 00:00:00
2022-05-16 00:00:00
2022-05-23 00:00:00
2022-05-30 00:00:00
2022-06-06 00:00:00
2022-06-13 00:00:00
2022-06-20 00:00:00
2022-06-27 00:00:00
2022-07-04 00:00:00
2022-07-11 00:00:00
2022-07-18 00:00:00
2022-07-25 00:00:00
2022-08-01 00:00:00
2022-08-08 00:00:00
2022-08-15 00:00:00
2022-08-22 00:00:00
2022-08-29 00:00:00
2022-09-05 00:00:00
2022-09-12 00:00:00
2022-09-19 00:00:00
2022-09-26 00:00:00
2022-10-03 00:00:00
2022-10-10 00:00:00
2022-10-17 00:00:00
2022-10-24 00:00:00
2022-10-31 00:00:00
2022-11-07 00:00:00
2022-11-14 00:00:00
2022-11-21 00:00:00
2022-11-28 00:00:00
2022-12-05 00:00:00
2022-12-12 00:00:00
2022-12-19 00:00:00
2022-12-26 00:00:00
2023-01-02 00:00:00
2023-01-09 00:00:00
2023-01-16 00:00:00
2023-01-23 00:00:00
2023-01-30 00:00:00
2023-02-06 00:00:00
2023-02-13 00:00:00
2023-02-20 00:00:00
2023-02-27 00:00:00
2023-03-06 00:00:00
2023-03-13 00:00:00
2023-03-20 00:00:00
2023-03-27 00:00:00
2023-04-03 00:00:00
2023-04-10 00:00:00
2023-04-17 00:00:00
2023-04-24 00:00:00
2023-05-01 00:00:00
2023-05-08 00:00:00
2023-05-15 00:00:00
2023-05-22 00:00:00
2023-05-29 00:00:00
2023-06-05 00:00:00
2023-06-12 00:00:00
2023-06-19 00:00:00
2023-06-26 00:00:00
2023-07-03 00:00:00
Spreadsheet: stacey_white__39000__Power CBO 2002 Plan Expense
Sheet: Assumptions

 |  |  |  | Enron Net Works
 |  |  |  | 2002 Plan
(In Dollars) |  |  |  |  |  |  |  |  | = input in highlighted cells
COST CENTER OWNER:
COST CENTER:
 |  |  |  |  | MONTHLY |  | TOTAL
 |  |  |  |  | AMOUNT |  | 2002 |  | ASSUMPTIONS
Direct Expenses
52001500 | Club Dues
52002000 | Tuition Reimbursement
52002500 | Other Employee Expenses
52003000 | Overtime/Working Meals
52003500 | Client Meals & entertainment
52004000 | Employee Memberships & Dues
52004500 | Travel
52004xxx | Lodging
 | Subtotal Employee Expenses
52503500 | Communication Expenses
52502000 | Infrastructure Passthrough
52507400 | Outside Services - IT |  |  |  |  |  |  |  | Fed straight from Headcount sheet
52507500 | Outside Services - Other
52508100 | Postage & Freight Expense
52508500 | Subscriptions & Periodicals
53500000 | Materials and Supplies - Stock
53500500 | Materials and Supplies - Non Stock
53600000 | Office Supplies
 | Subtotal Office Supplies
52500500 | Advertising Expenses
52504100 | Charitable Contributions
53800000 | Equipment Rental - Personal (Copiers, Fax, etc.)
53801000 | Rent - Office, Warehouse, & Tower - Real
 | Subtotal Rent (3rd Party)
52504500 | Computer Expense |  |  |  |  |  |  |  | From Project Assumptions Sheet
54000000 | Transportation
52502500 | EPSC Allocation |  |  |  |  |  |  |  | $500/mo/FTE or refer to EPSC tab for detailed calculation
5XXXXXXX | A&A/GTT Allocation |  |  |  |  |  |  |  | Fed straight from Headcount sheet
52505500 | Fees & Permits
54005000 | General Business & Admin Expenses
52504200 | Political Contributions
52506500 | Insurance
52506000 | Fines & Penalties
52503000 | Allocations - Other
52504000 | Company Membership & Dues
 | Subtotal Other Expense
57200000 | Depreciation
57000000 | Amortization
 | Subtotal Depreciation & Amortization
59099900 | Taxes Other than Income
 | TOTAL DIRECT EXPENSES |  |  |  |  |  |  |  |  |  |  | Check
Allocated Expenses: (Budgeted by Financial Operations)
 | ENA E-Source |  |  |  | 0
 | ENA HR |  |  |  | 0
 | ENA Internal Support |  |  |  | 0
 | ENA Legal |  |  |  | 0
 | ENA PR |  |  |  | 0
 | ENA Tax |  |  |  | 0
 | ENA Transaction Support |  |  |  | 0
 | Energy Ops |  |  |  | 0
 | ENW Accounting |  |  |  | 0
 | ENW Corporate |  |  |  | 0
 | ENW Graphics Productions |  |  |  | 0
 | ENW HR |  |  |  | 0
 | IT e-Commerce |  |  |  | 0
 | IT Infrastructure - Assessment |  |  |  | 0
 | Other Allocations
 | TOTAL ALLOCATED EXPENSES
TOTAL EXPENSES
Spreadsheet: 770921d1646336171-help-with-royalty-scale-calculation-royalty
Sheet: 2021

 |  |  |  |  |  |  |  |  |  | 2021
article | EAN | publishing date | retail price | net retail price | title | original title | series | printed copies | remaining copies from 2020 | sold copies | gross turnover at net retail price HUF | royalty up to 6000 copies: 8% on gross turnover HUF | royalty up to 6000 copies: 8% on gross turnover EUR | royalty up to 12.000 copies: 10% on gross turnover HUF | royalty up to 12.000 copies: 10% on gross turnover EUR | royalty thereafter: 12% on gross turnover HUF | royalty thereafter: 12% on gross turnover EUR | royalty total HUF | royalty total EUR | royalty advance paid (remaining from 2020) | royalty to be paid
 |  |  | 1699 |  | one title |  |  |  |  | 1162 |  | 0
 |  |  | 1699 |  | second title |  |  |  |  | 74 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021 Total:
2021 | exchange rate (EUR/HUF): |  |  | 358.52
Spreadsheet: 149250d1333779531-conditional-calculation-nfl-statistics
Sheet: Wins & Losses

Year | Wins | Losses | Ties | W/L %
2011 | 6 | 10 |  | 0.375
2010 | 7 | 9 |  | 0.4375
2009 | 7 | 9 |  | 0.4375
2008 | 11 | 5 |  | 0.6875
2007 | 1 | 15 |  | 0.0625
2006 | 6 | 10 |  | 0.375
2005 | 9 | 7 |  | 0.5625
2004 | 4 | 12 |  | 0.25
2003 | 10 | 6 |  | 0.625
2002 | 9 | 7 |  | 0.5625
2001 | 11 | 5 |  | 0.6875
2000 | 11 | 5 |  | 0.6875
1999 | 9 | 7 |  | 0.5625
1998 | 10 | 6 |  | 0.625
1997 | 9 | 7 |  | 0.5625
1996 | 8 | 8 |  | 0.5
1995 | 9 | 7 |  | 0.5625
1994 | 10 | 6 |  | 0.625
1993 | 9 | 7 |  | 0.5625
1992 | 11 | 5 |  | 0.6875
1991 | 8 | 8 |  | 0.5
1990 | 12 | 4 |  | 0.75
1989 | 8 | 8 |  | 0.5
1988 | 6 | 10 |  | 0.375
1987 | 8 | 7 |  | 0.5333333333333333
1986 | 8 | 8 |  | 0.5
1985 | 12 | 4 |  | 0.75
1984 | 14 | 2 |  | 0.875
1983 | 12 | 4 |  | 0.75
1982 | 7 | 2 |  | 0.7777777777777778
1981 | 11 | 4 | 1 | 0.8214285714285714
1980 | 8 | 8 |  | 0.5
1979 | 10 | 6 |  | 0.625
1978 | 11 | 5 |  | 0.6875
1977 | 10 | 4 |  | 0.7142857142857143
1976 | 6 | 8 |  | 0.4285714285714285
1975 | 10 | 4 |  | 0.7142857142857143
1974 | 11 | 3 |  | 0.7857142857142857
1973 | 12 | 2 |  | 0.8571428571428571
1972 | 14 | 0 |  | 1
1971 | 10 | 3 | 1 | 0.75
1970 | 10 | 4 |  | 0.7142857142857143
1969 | 3 | 10 | 1 | 0.25
1968 | 5 | 8 | 1 | 0.3928571428571428
1967 | 4 | 10 |  | 0.2857142857142857
1966 | 3 | 11 |  | 0.2142857142857143
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 7d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 226668784 | 98018154 | 24564275 | 44724960
FRA | 85662076 | 12708032 | 8514102 | 3285718
OIS | 47997218 | 13905016 | 7400069 | 4924709
OTHER* | 11621189 | 73867900 | 1059515 | 21709379
TOTAL
*OTHER variable includes the following products: Basis, Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 881454d1729525932-help-to-check-2-columns-against-2-columns-in-a-separate-tab-excel-help
Sheet: Tab 1

Column1 | Column2
a | 1
b | 1
c | 2
d | 2
e | 3
f | 4
g | 5
h | 6
i | 6
Spreadsheet: 102762d1300725786-excel-2007-help-with-if-function-letter-grade-example
Sheet: StudentScores

Name | Test1 | Test2 | Test3 | Test4 | Final Exam | Overall Score | Letter Grade
[NAME] | 0.72 | 0.68 |  |  |  | 0.7 | B-
[NAME] | 0.88 | 0.76 |  |  |  | 0.8200000000000001 | A-
[NAME] | 0.61 | 0.69 |  |  |  | 0.6499999999999999 | C-
[NAME] | 0.46 | 0.87 |  |  |  | 0.665 | C-
Spreadsheet: 131046d1322703531-formulas-referencing-my-month-year-dropdown-list-copy-of-sales_rev_-_samplev2
Sheet: Sales

 | Client | Invoice Date | Revenue | Job Function | Position | Consultant | Days to Closure | Remarks
 | AB1 | 2011-01-24 00:00:00 | 3800 | Accounting  - Audit |  | Eunice
 | AB1 | 2011-01-14 00:00:00 | 4328 | Accounting  - Accounts / Finance Manager |  | Sydney
 | AB3 | 2011-01-17 00:00:00 | 2344 | Accounting  - Credit Control |  | Claudia
 | AB4 | 2011-02-21 00:00:00 | 934 |  |  | Claudia
 | AB1 | 2011-02-09 00:00:00 | 8534 |  |  | Sydney
 | AB6 | 2011-02-21 00:00:00 | 8323 |  |  | Claudia
 | AB3 | 2011-03-02 00:00:00 | 12312 |  |  | Claudia
 | AB8 | 2011-04-01 00:00:00 | 345 |  |  | Julia
 | AB9 | 2011-04-04 00:00:00 | 4353 |  |  | Julia
 | AB3 | 2011-04-15 00:00:00 | 9034 |  |  | Claudia
 | AB1 | 2011-04-25 00:00:00 | 943 |  |  | Sydney
 | AB12 | 2011-05-06 00:00:00 | 1231 |  |  | Sydney
 | AB13 | 2011-06-01 00:00:00 | 8233 |  |  | Ernest
 | AB3 | 2011-06-14 00:00:00 | 4221 |  |  | Sydney
 | AB3 | 2011-09-26 00:00:00 | 2341 |  |  | Julia
 | AB16 | 2011-10-11 00:00:00 | 2132 |  |  | Serene
 | AB17 | 2011-10-24 00:00:00 | 2111 |  |  | Claudia
 | AB3 | 2011-10-31 00:00:00 | 4332 |  |  | Julia
 | AB19 | 2011-11-03 00:00:00 | 3432 |  |  | Claudia
 | AB3 | 2011-11-21 00:00:00 | 4532 |  |  | Serene
 | AB3 | 2011-11-28 00:00:00 | 4222 |  |  | Serene
 | AB22 | 2011-12-01 00:00:00 | 2133 |  |  | Claudia
 | [NAME] | 2011-12-05 00:00:00 | 4211 |  |  | Claudia
Spreadsheet: 811818d1672819858-identify-last-entry-and-display-data-staff-work-allocations-2023-v2-1-
Sheet: 2023

 |  |  | WRAPPING (R) |  | Wrapping (%) |  | AUTOCLAVE (A) | AUTOCLAVE (%) |  | BOOKING ON (B) | BOOKING ON (%) |  | WASH EMPTY (E) | WASH EMPTY (%) |  | PORTERING (P) | PORTERING (%) |  | WASH (W) | WASH (%) |  | JANUARY
SURNAME | FIRST NAME |  |  | Last Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  | 2023-01-02 00:00:00 |  | 2023-01-03 00:00:00 |  | 2023-01-04 00:00:00 |  | 2023-01-05 00:00:00 |  | 2023-01-06 00:00:00 |  | 2023-01-07 00:00:00 |  | 2023-01-08 00:00:00 |  | 2023-01-09 00:00:00 |  | 2023-01-10 00:00:00
aaaa | aaaaa
aaaaa | aaaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r |  | a |  | b |  | w |  | e |  |  | r |  |  | r
Spreadsheet: 835887d1688961541-formula-to-look-at-evey-3-days-and-sum-excel
Sheet: Sheet1

Date | Daily Value | 3 Consecutive days value
1/1/1890 | 0
1/2/1890 | 0
1/3/1890 | 0
1/4/1890 | 0
1/5/1890 | 0
1/6/1890 | 0
1/7/1890 | 0
1/8/1890 | 0
1/9/1890 | 0
1/10/1890 | 0
1/11/1890 | 0
1/12/1890 | 0
1/13/1890 | 0
1/14/1890 | 0
1/15/1890 | 0
1/16/1890 | 0
1/17/1890 | 0
1/18/1890 | 0
1/19/1890 | 0
1/20/1890 | 0
1/21/1890 | 0
1/22/1890 | 0
1/23/1890 | 0
1/24/1890 | 0
1/25/1890 | 1.306
1/26/1890 | 0.1319
1/27/1890 | 0.0141
1/28/1890 | 0.03142
1/29/1890 | 0.003586 | 0
1/30/1890 | 0.0006693 | 0
1/31/1890 | 0.0002845
2/1/1890 | 0.0001807 | 0
2/2/1890 | 0.0001247 | 0
Spreadsheet: 793005d1661261399-formula-for-date-conversation-in-the-specific-format-get-days-ans
Sheet: Sheet2

 | Customer name | Dates |  | Customer | Date visited
 |  |  |  | Dominos | 1,7,11
 |  |  |  | Kfc | 2,9
 |  |  |  | [NAME] | 3,10
 |  |  |  | Burger king | 4,8,12
 |  |  |  | la pinoz | 5
 |  |  |  | pizza king | 6,13
Spreadsheet: 188668d1350953647-how-to-make-1-perfected-formula-manpower-cost
Sheet: test

Manpower Cost |  |  | Assumption 1: Based on Project Value
 |  |  | Project Manpower Allocation for Indirect labour
CEO Office | 200000 |  | Project | Value | % | CEO | COO | Finance | Procurement | CS | TS | QAQC | Contract | Estimating | Production | MarineC | MarineG | HSSE | Yard Operation | Warehouse | Total
COO Office | 100000 |  | Attribute to Project |  |  | 0.6 | 0.8 | 0.9 | 1 | 0.7 | 0.9 | 0.9 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Finance | 75000 |  | Project A | 5500000
Procurement | 55000 |  | Project B | 1000000
Corporate Service | 20000 |  | Project C | 7000000
Technical Service | 50000 |  | Project D | 8000000
QACC | 50000 |  | Project E | 9000000
Contract | 25000 |  | Project F | 2000000
Estimating | 35000 |  | Project G | 1000000
Production | 50000 |  | Project H | 7000000
MarineC | 100000 |  | PROJECT I | 200000
MarineG | 150000 |  | Project J | 250000
HSSE | 50000
Yard Operation | 30000
Warehouse | 50000 |  | Total
 |  |  |  | Total Project Manpower Cost
 |  |  |  | Total Corporate Overhead