tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 693034d1598706957-sum-result-of-formula-for-each-cell-in-range-rota-sample-
Sheet: JUL 20

 |  | KEY
 |  | HOLIDAY | OFF
 |  | CONCIERGE | DUTY MANAGER
 |  | FITNESS CONC. | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Shift Cover
 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Chloe | [NAME] | Emily | [NAME] | [NAME] | Damon |  | AM | MID | PM |  | Notes
 | 2020-07-01 00:00:00
 | 2020-07-02 00:00:00
 | 2020-07-03 00:00:00
 | 2020-07-04 00:00:00
 | 2020-07-05 00:00:00
 | 2020-07-06 00:00:00
 | 2020-07-07 00:00:00
 | 2020-07-08 00:00:00
 | 2020-07-09 00:00:00
 | 2020-07-10 00:00:00
 | 2020-07-11 00:00:00
 | 2020-07-12 00:00:00
 | 2020-07-13 00:00:00
 | 2020-07-14 00:00:00
 | 2020-07-15 00:00:00
 | 2020-07-16 00:00:00
 | 2020-07-17 00:00:00
 | 2020-07-18 00:00:00
 | 2020-07-19 00:00:00
 | 2020-07-20 00:00:00
 | 2020-07-21 00:00:00
 | 2020-07-22 00:00:00
 | 2020-07-23 00:00:00 | 08:00 - 17:00 | IN | IN | OFF | IN | OFF | IN | SICK | OFF | IN | IN |  | - | - | -
 | 2020-07-24 00:00:00 | 08:00 - 17:00 | IN | IN | IN | OFF | IN | OFF | SICK | IN | OFF | OFF |  | - | - | -
 | 2020-07-25 00:00:00 | 12:00 - 20:30 | 07:30 - 16:30 | OFF | 11:30 - 20:30 | 07:30 - 16:30 | 11:30 - 20:30 | 07:30 - 16:30 | SICK | 11:30 - 20:30 | 11:30 - 20:30 | 07:30 - 16:30
 | 2020-07-26 00:00:00 | 10:00 - 19:00 | OFF | OFF | 11:30 - 20:30 | 07:30 - 16:30 | 09:30 - 18:30 | 07:30 - 16:30 | SICK | 11:30 - 20:30 | 11:30 - 20:30 | 07:30 - 16:30
 | 2020-07-27 00:00:00 | 07:00 - 16:00 | 13:30 - 22:30 | 05:30 - 14:30 | 13:30 - 22:30 | 05:30 - 14:30 | 13:30 - 22:30 | 05:30 - 14:30 | SICK | OFF | OFF | OFF
 | 2020-07-28 00:00:00 | OFF | 13:30 - 22:30 | 05:30 - 14:30 | 13:30 - 22:30 | 05:30 - 14:30 | OFF | 05:30 - 14:30 | SICK | OFF | 13:30 - 22:30 | OFF
 | 2020-07-29 00:00:00 | OFF | 13:30 - 22:30 | 05:30 - 14:30 | OFF | OFF | 05:30 - 14:30 | OFF | 07:30 - 16:30 | 13:30 - 22:30 | 13:30 - 22:30 | 05:30 - 14:30
 | 2020-07-30 00:00:00 | 07:00 - 16:00 | 13:30 - 22:30 | OFF | 13:30 - 22:30 | OFF | 05:30 - 14:30 | OFF | 05:30 - 14:30 | 13:30 - 22:30 | OFF | 05:30 - 14:30
 | 2020-07-31 00:00:00 | 08:00 - 17:00 | 13:30 - 22:30 | OFF | 13:30 - 22:30 | OFF | OFF | 05:30 - 14:30 | 05:30 - 14:30 | 13:30 - 22:30 | OFF | 05:30 - 14:30
 | 2020-08-01 00:00:00 |  | OFF | 07:30 - 16:30 | OFF | 11:30 - 20:30 | OFF | 11:30 - 20:30 | OFF | 07:30 - 16:30 | 11:30 - 20:30 | 07:30 - 16:30
 | 2020-08-02 00:00:00 |  | OFF | 07:30 - 16:30 | OFF | 11:30 - 20:30 | 07:30 - 16:30 | OFF | 11:30 - 20:30 | 07:30 - 16:30 | 11:30 - 20:30 | OFF
 | Hours Worked Totals
 | HRS | - | 40 | 40 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32
 | TOTAL HRS | - | 54 | 27 | 54 | 36 | 45 | 45 | 27 | 45 | 36 | 45
 | +/- | -
 | Weekday Shift Totals
 | AM
 | MID
 | PM
 | TOTAL
 | Weekend Shift Totals
 | AM
 | MID
 | PM
 | TOTAL
 | Off Shift Totals
 | OFF
 | SICK
 | LIEU
 | HOLIDAY
Spreadsheet: 128215d1320857655-month-vs-month-vs-month-2009-10-11-upload
Sheet: 2011

CUSTOMER | JAN | FEB | MAR | APRIL | MAY | [NAME] | JULY | AUGUST | SEPT | OCT | NOV | DEC |  | TOTAL
B | 16928.18 | 12043 | 15379.66 | 332 | 33 | 13640.56 | 14305.51 | 16198.91 | 6461.98 | 6445
A | 5243.6 | 7517 | 12493.6 | 34323 | 3233 | 15780 | 242342 | 11522.5 | 17691.36 | 3242424
E | 10351.18 | 3128 | 3242432 | 3699.45 | 3 | 5250.7 | 3115.07 | 5038.29 | 17744.59 | 2424
 |  |  |  | 625
C | 7 | 6 | 7126 | 9660.5 | 5198.5 | 3354546 | 566 | 10038.4 | 9428.15 | 2344242
 |  |  | 47
D | 56556 | 7904 | 2523.9 | 8554.8 | 4633.6 | 10473 | 6289.2 | 6795.8 | 4254.34 | 4646
Spreadsheet: 59999d1260527463-vlookup-price_list
Sheet: Sheet1

Currently
A004 | 1.75 | 5.95 |  |  |  |  |  |  |  |  |  | A004 | 1.85 | 6.05
A005 | 1.65 | 5.61 |  |  |  |  |  |  |  |  |  | A005 | 1.75 | 5.81
A006 | 1.79 | 6.09 |  |  |  |  |  |  |  |  |  | A006 | 1.89 | 6.29
A007 |  |  |  |  |  |  |  |  |  |  |  | A007 | 2.35 | 7.85
Would like
A004 | 1.85 | 6.05
A005 | 1.75 | 5.81
A006 | 1.89 | 6.29
A007 | 2.35 | 7.85
A004
A005
A006
A007
 | or
A004
A005
A006
A007
Spreadsheet: 783860d1655210676-nested-if-statements-returning-true-rather-than-a-value-help_forums
Sheet: Heating Calculation

Pipe Diameter (in.) | 1/2" STEEL-STD |  | Pipe Diameter (in.) | 'Heating Calculation'!A1
Inlet Temperature (°F) | 40 |  | Outer Diameter (in.) | 'Heating Calculation'!E11
Inlet Pressure (PSIG) | 500 |  | Inside Diameter (in.) | 'Heating Calculation'!E13
Outlet Pressure (PSIG) | 80 |  | Wall Thickness (in.) | 'Heating Calculation'!E15
Q (ft3/hr) | 21000 |  | Surface Area of a Single Heater (ft2) | 'Heating Calculation'!E17
Heater Capacity (btu/hr) | 9000 |  | Surface Area of a Dual Heater (ft2) | 'Heating Calculation'!E19
Length (ft) | 1 |  | Heat Flux (btu/hr*ft2) | 'Heating Calculation'!E21
Number of Heaters | 2 |  | ṁ (lbm/hr) | 'Heating Calculation'!E23
Effeciency Factor | 0.75 |  | ∆T Regulator (°F) | 'Heating Calculation'!E25
ρ (lbm/ft3) | 0.044 |  | Temperature out (°F) | 'Heating Calculation'!E27
Cp (btu/lbm*R) | 0.58 |  | Temperature Final (°F) | 'Heating Calculation'!E29
 |  |  | Corrected Final Temperature (°F) | 'Heating Calculation'!E31
Spreadsheet: 830863d1685182916-vlookup-not-working-when-substituted-with-nested-if-statements-petrol-conveyance-calculation
Sheet: PETROL CONVEYANCE

 | DATE | Kilometer | Rate | Amount |  |  | PRICE CHART
 | 2022-07-01 00:00:00 | 1100 |  |  |  |  | Kilometer | Price
 | 2022-07-04 00:00:00 | 485 |  |  |  |  | 0-120 | 2.75
 | 2022-07-05 00:00:00 | 48 |  |  |  |  | 120-240 | 1.95
 | 2022-07-06 00:00:00 | 85 |  |  |  |  | 240-350 | 1.75
 | 2022-07-07 00:00:00 | 449 |  |  |  |  | 350-1000 | 1.5
 | 2022-07-08 00:00:00 | 249 |  |  |  |  | >1000 | 1.4
 | 2022-07-11 00:00:00 | 425
 | 2022-07-12 00:00:00 | 297
 | 2022-07-13 00:00:00 | 229
 | 2022-07-14 00:00:00 | 50
 | 2022-07-15 00:00:00 | 651
 | 2022-07-18 00:00:00 | 349
 | 2022-07-19 00:00:00 | 320
 | 2022-07-20 00:00:00 | 280
 | 2022-07-21 00:00:00 | 919
 | 2022-07-22 00:00:00 | 903
 | 2022-07-25 00:00:00 | 132
 | 2022-07-26 00:00:00 | 108
 | 2022-07-27 00:00:00 | 46
 | 2022-07-28 00:00:00 | 1010
 | 2022-07-29 00:00:00 | 577
Spreadsheet: andy_zipper__287__Mar Apr straddle spread
Sheet: Sheet3

March | April | Srike | Int | yield | vol | t | type | Ret | Value | Intrinsic | Spread settle | P/L
 | 4.5 | 2 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
Spreadsheet: 585156d1533646202-customer-data-multiple-rows-into-1-row-example-data-1
Sheet: Sheet1

Account No | Service | Service Address | Status | Customer Name | Water Status | Sewer Status | USDA Status
101 |  | 80 Main Street |  | Firt, Last
 | WATER |  | ACTIVE
 | SEWER |  | ACTIVE
 | USDA |  | INACTIVE
102 |  | 54 Left Drive |  | Firt, Last
 | WATER |  | INACTIVE
 | SEWER |  | INACTIVE
 | USDA |  | INACTIVE
 | MAIN |  | INACTIVE
506 |  | 10 Oak Street |  | Firt, Last
 | WATER |  | INACTIVE
 | USDA |  | INACTIVE
907 |  | 36 Muscle Avenue |  | Firt, Last
 | No Services |  | INACTIVE
560 |  | 999 [NAME] |  | Firt, Last
 | WATER |  | INACTIVE
 | USDA |  | INACTIVE
Spreadsheet: 805648d1668803668-formula-split-complete-description-to-their-respective-headers-sample-test
Sheet: SAMPLE

 | EXPECTED REDULTS
description | [NAME] | CODE | PAYS
COUVRE VOLANT COUTURES 38 CM Nomenclature douaniere 39269097 Pays d'origine CHINE | COUVRE VOLANT COUTURES 38 CM | 39269097 | CHINE
COUVRE VOLANT BIMATIERE SPORT 38 Nomenclature douantere 39269097 Pays d'origine CHINE | COUVRE VOLANT BIMATIERE SPORT | 39269097 | CHINE
HOUSSE DE PROTECTION MOTO-L Nomenclature douantere 63079098 Pays d'origine CHINE | HOUSSE DE PROTECTION MOTO-L | 63079098 | CHINE
ARBRE MAGIQUE PARFUM SPORT Nomenclature douaniere 33074900 Pays d'origine SUISSE | ARBRE MAGIQUE PARFUM SPORT | 33074900 | CHINE
ARBRE MAGIQUE PARFUM BUBBLE GUM Nomenclature douaniere 33074900 Pays d'origine SUISSE | ARBRE MAGIQUE PARFUM BUBBLE GUM | 33074900 | CHINE
Spreadsheet: f3703712-1433-4375-b038-db805f51a3dd
Sheet: 7

 | Jul 12 | Jul 19 | Jul 26 | Aug 2 | Aug 9
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap dollar volumes by asset class and cleared status (value of all trades in millions of USD), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 625250d1558422386-help-calendar-correction-employee-absence-schedule-current-v2
Sheet: May

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | May | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee 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 |  |  |  | Vacation Days Available | Total Vacation  Days Taken | Total Days Picked up | Total Sick Days
 | [NAME] |  |  | V | V | V | V |  |  |  |  |  |  | V |  |  | s | s |  | p |  | s | s | p | p | p | p
 | Lynda |  |  |  |  | S | S |  |  |  |  | P |  |  |  |  |  |  |  |  | S |  |  | v |  | V | V | V
 | [NAME] |  |  | P | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s |  |  |  | s | s | s | s | s | S
 | Heather |  |  |  |  |  |  | P |  |  |  |  |  |  |  |  |  |  |  | V | V | V
 | [NAME] | v | v | v |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | v | V
 | Emili |  |  |  |  | v
 | Amber
 | Meredith
 | Julie
Spreadsheet: 456434d1460850995-ability-to-grab-the-correct-price-on-a-dynamic-range-table-bazz1
Sheet: Sheet1

CABINETS | MODEL | PRICE/EACH | QUANTITY | TOTALS | COLOR
 |  |  |  |  | Coffee
BASE SINK | SB30 |  | 4
 |  |  | SUBTOTAL
 |  |  | DISCOUNT - | 0.5
 |  |  | TAX
 |  |  | TOTAL
Spreadsheet: 750415d1633444092-first-match-and-return-cell-to-left-excel-forum-help
Sheet: Sheet1

Month 1 | 0.85 | Month 2 | 0.9 | Month 3 | 0.95 | Month 4 | 1 | Month 5 | 1 | Month 6 | 1 | Month 7 | 1 | Month 8 | 1 | Month 9 | 1 | Month 10 | 1
 |  | Find first value in row1 that has 100% and give Month# (one cell to left)
 |  | For this example, the result would be Month4
 |  | Forumla here >
 |  | Desired Result > | 4
Spreadsheet: phillip_m_love__30151__9906_OA
Sheet: WE-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  WEST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -16176 | -29113.44
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -54 | -100
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16230 | 33758
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 583967d1532857674-how-to-exclude-weekends-in-employee-absence-tracker-count-copy-of-holiday-and-absence-planning-keebellah-
Sheet: Sept

 | Employee Holiday & Absence Scheduling
E  m  p  l  o  y  e  e | Absence Type Key |  | X | Vacation |  |  | T | Official Travel |  |  |  | S | Sick |  |  | M | Maternity |  |  | p | Parental |  |  |  | C | Compensation |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holiday |  |  |  | Holiday
 | 2018-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Days
 | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation | Official Travel | Sick | Maternity | Parental | Compensation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | T | S | M | P | C
 | Employee 1
 | Employee 2
 | Employee 3
 | Employee 4
 | Employee 5
 | Employee 6
 | Employee 7
 | Employee 8
 | Employee 9
 | Employee 10
 | Employee 11
 | Employee 12
 | Employee 13 |  | x | x | x | x | x | x | x | x | x | x | x | x
 | Employee 14
 | Employee 15
 | Employee 16
 | Employee 17
 | Employee 18
 | Employee 19
 | Employee 20
 | Employee 21
 | Employee 22
 | Employee 23 | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m
 | Employee 24
 | Employee 25
 | Employee 26
 | Employee 27
 | Employee 28
Spreadsheet: 049108f9-f364-458f-959b-19aa50a4f3eb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6302.0 Average Weekly Earnings, Australia
 | TABLE 5. Average Weekly Earnings, Private Sector - Australia (Dollars) - Seasonally Adjusted
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Earnings; [NAME]; Full Time; Adult; Ordinary time earnings ;  Private sector ; |  |  | Seasonally Adjusted | A2777821T | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Full Time; Adult; Total earnings ;  Private sector ; |  |  | Seasonally Adjusted | A2777824X | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Total earnings ;  Private sector ; |  |  | Seasonally Adjusted | A2777830V | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Ordinary time earnings ;  Private sector ; |  |  | Seasonally Adjusted | A2777822V | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Total earnings ;  Private sector ; |  |  | Seasonally Adjusted | A2777825A | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Total earnings ;  Private sector ; |  |  | Seasonally Adjusted | A2777831W | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Private sector ; |  |  | Seasonally Adjusted | A2777823W | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  Private sector ; |  |  | Seasonally Adjusted | A2777826C | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  Private sector ; |  |  | Seasonally Adjusted | A2777832X | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
© Commonwealth of Australia  2013
Spreadsheet: 99890d1298417454-best-4-of-6-results-bridge-1-
Sheet: Sheet1

 | Round 1 | Round 2 | Round 3 | Round 4 | Round 5 | Round 6 |  | Rank |  | Average
Pair 1 | 0.453 |  |  |  |  |  | 0.453 |  |  | 0.453 | [NAME]
Pair 2 | 0.657 | 0.453 |  |  |  |  | 1.11 |  |  | 0.555
Pair 3 | 0.435 | 0.657 | 0.453 |  | 0.6 | 0.536 | 2.246 | 1 |  | 0.5615
Pair 4 | 0.625 | 0.435 | 0.657 | 0.453 |  |  | 2.17 | 2 |  | 0.5425
Pair 5 |  | 0.625 | 0.435 | 0.657 |  |  | 1.717 |  |  | 0.5723333333333334
Pair 6 |  |  | 0.625 | 0.435 |  |  | 1.06 |  |  | 0.53
Pair 7 |  |  |  | 0.625 |  |  | 0.625 |  |  | 0.625
Column H should show the average of the best 4 of 5 or more non-blank scores or the average of all non-blank scores if less than 5
Column I should show the ranking of averages in column H, preferably expressed as 1st, 2nd etc.
Not all pairs will compete in all rounds.  Only pairs with 4 or more non-blank scores will be eligible.
Spreadsheet: 774831d1648676211-combining-2-countif-formulas-test12-etaf
Sheet: Sheet1

 | Type | Status | ID |  |  |  |  |  |  |  |  |  | Expires | Valid | New? | Expected | Old Only | NEW Formula
 | OT | ISSUED | 568154112108 |  |  |  |  |  |  |  |  |  | 2021-11-13 10:49:36 |  |  | New
 | OT | ISSUED | 568154112108 |  |  |  |  |  |  |  |  |  | 2021-11-13 10:49:36 |  |  | New
 | OT | ISSUED | 568154112108 |  |  |  |  |  |  |  |  |  | 2023-11-12 08:38:03 |  |  | New
 | OT | ISSUED | 568154112108 |  |  |  |  |  |  |  |  |  | 2023-11-12 08:38:03 |  |  | New
 | OT | RENEWED | 560828464107 |  |  |  |  |  |  |  |  |  | 2021-02-19 12:46:35
 | GMP | RENEWED | 561448899106 |  |  |  |  |  |  |  |  |  | 2023-03-18 08:53:48 |  |  | Old
 | GMP | RENEWED | 561448899106 |  |  |  |  |  |  |  |  |  | 2023-03-18 08:53:48 |  |  | Old
 | OT | ISSUED | 77404689042 |  |  |  |  |  |  |  |  |  | 2018-04-06 10:20:51 |  |  | New
 | OT | ISSUED | 77404689042 |  |  |  |  |  |  |  |  |  | 2019-09-12 09:35:30 |  |  | New
 | GMP2 | RENEWED | 77404689042 |  |  |  |  |  |  |  |  |  | 2021-06-11 10:12:51 |  |  | New
 | GMP | RENEWED | 77404689042 |  |  |  |  |  |  |  |  |  | 2023-06-10 09:35:53 |  |  | New
 | GMP | ISSUED | 77404689042 |  |  |  |  |  |  |  |  |  | 2020-07-17 10:29:32 |  |  | New
 | OT | ISSUED | 77404689042 |  |  |  |  |  |  |  |  |  | 2022-06-27 14:09:07 |  |  | New
 | GMP | ISSUED | 563269721104 |  |  |  |  |  |  |  |  |  | 2023-02-22 10:00:04 |  |  | Old
 | OT | EXPIRED | 563269721104 |  |  |  |  |  |  |  |  |  | 2020-02-08 13:11:40 |  |  | Old
Spreadsheet: 750712d1633603881-compare-1-value-whether-it-is-either-1st-2nd-or-3rd-largest-with-multiple-criterias-compare-with-3-largest-values-with-multiple-criteria
Sheet: Main

Branchwise Business Summary
Branch | Location Head | [NAME] | Amt
Mumbai | Mumbai Total | M1
[NAME] | P-1 | M1 | 20
[NAME] | P-2 | M1 | 80 |  | T1
Vishwas [NAME] | P-3 | M1 | 40
Mumbai Unaccounted | Mumbai Unaccounted | M1 | 10
M1 Total
Bangalore | Bangalore Total | M2
Pradesh [NAME] | P-4 | M2 | 35
D [NAME] | P-5 | M2 | 60 |  | T3
Bangalore Unaccounted | P-6 | M2 | 70 |  | T2
M2 Total
PAN INDIA
Spreadsheet: 716228d1612112843-problem-in-solver-execution-tsaeed-80_solver-in-excel-2-
Sheet: Sheet5

 |  |  |  |  |  |  | Customer | [NAME] |  | Payments | [NAME] | Tesla | The Boring Company | Neuralink
 | Orders |  |  |  |  |  | Amt to Reconcile | 302277 |  |  | 156751 | 186913 | 488093 | 318207
 |  |  |  |  |  |  | Sum of F Amts |  |  |  | 322300 | 682775 | 176712 | 325325
 | Customer | Amount | Reconciled | Flag | F Amt |  | Difference |  |  |  | 302277 |  | 356003 | 408977
 | [NAME] | 70380 | 0 | 1
 | Tesla | 172707 | 0 | 0
 | The Boring Company | 96702 | 0 | 0
 | Neuralink | 99266 | 1 | 0
 | [NAME] | 183119 | 1 | 0
 | The Boring Company | 174710 | 1 | 0
 | Tesla | 123415 | 0 | 0
 | Tesla | 72535 | 0 | 0
 | The Boring Company | 80010 | 0 | 0
 | Neuralink | 161168 | 0 | 0
 | [NAME] | 149623 | 0 | 1
 | [NAME] | 91258 | 1 | 0
 | The Boring Company | 140416 | 1 | 0
 | Neuralink | 124269 | 0 | 0
 | Neuralink | 151596 | 0 | 0
 | Neuralink | 123540 | 0 | 0
 | [NAME] | 65493 | 1 | 0
 | Tesla | 132448 | 0 | 0
 | The Boring Company | 172967 | 1 | 0
 | [NAME] | 139181 | 1 | 0
 | Neuralink | 173729 | 0 | 0
 | The Boring Company | 159639 | 0 | 0
 | Tesla | 114378 | 0 | 0
 | Tesla | 111536 | 0 | 0
 | The Boring Company | 196364 | 0 | 0
 | Tesla | 142669 | 0 | 0
 | Neuralink | 154531 | 1 | 0
 | [NAME] | 82274 | 0 | 1
 | Neuralink | 64410 | 1 | 0
Spreadsheet: chris_germany__2339__2001new03
Sheet: Spot wENA

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Comment | Price | Amount |  | Comment | Price | Amount |  | Comment | Price | Amount |  |  | Price | Amount |  |  | Price | Amount |  |  | Price | Amount |  | Spot Sells
1 | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
31
Spreadsheet: 123627d1317762670-date-range-look-up-stuck
Sheet: Sheet1

location | start | end | Type |  |  | location | Date | Type
1 | 2011-02-13 00:00:00 | 2011-02-25 00:00:00 | grass |  |  | 1 | 2011-04-06 00:00:00 |  | should be"weeds"
1 | 2011-04-05 00:00:00 | 2011-04-08 00:00:00 | weeds |  |  | 2 | 2011-07-11 00:00:00 |  | should be"grass"
1 | 2011-07-10 00:00:00 | 2011-07-29 00:00:00 | trees |  |  | 2 | 2011-08-15 00:00:00 |  | should be blank
2 | 2011-02-13 00:00:00 | 2011-02-25 00:00:00 | weeds
2 | 2011-04-05 00:00:00 | 2011-04-08 00:00:00 | weeds
2 | 2011-07-10 00:00:00 | 2011-07-29 00:00:00 | grass
Spreadsheet: b89d7dc0-1c92-4662-a5c5-6745c03912ad
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
SFC | Test | SFC | Crystal Identification, Synovial Fluid | Crystal ID, Synovial Fl | Compensated Polarized Light Microscopy Includes cytospin prep. | EDTA (lavender-top) tube: EDTA OR Green-Top Tube (Sodium Heparin): GrnNaHp OR |  |  | 2 | mL | Container/Tube: Preferred: Lavender top (EDTA) Acceptable: Green top (heparin) [NAME]: 2 mL | 0.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | None seen If present, crystals are identified. | Monday through Sunday; Continuously | 1 day | 1 day | 1 | 89060 |  |  |  |  | Rochester
SFC | [NAME] | BODYFL | Body Fluid |  |  |  | Refrigerated
SFC | Result | SFCID | Crystal ID, Synovial Fl | Crystal ID, Synovial Fl | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5781-0 | Crystals:Prid:Pt:Synv fld:Nom:Microscopy.light
SFC | Result | REV28 | Reviewed By: | Reviewed By: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process