tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 65171d1265892586-adding-up-stock-records
Sheet: Adidas (SS)

OPTH | Company | Range | Model | Colour | Size | Single Cost | Actual Price | Current Balance
S/S | Silhouette | Adidas | 162/50 | 6056 | One Size | 1 | 11 | 0
S/S | Silhouette | Adidas | a134/00 | 6054 | One Size | 1 | 11 | 1
S/S | Silhouette | Adidas | a126/00 | 6087 | One Size | 1 | 11 | 1
S/S | Silhouette | Adidas | a126/00 | 6077 | One Size | 1 | 11 | 1
S/S | Silhouette | Adidas | a126/00 | 6078 | One Size | 1 | 11 | 0
S/S | Silhouette | Adidas | a136/00 | 6052 | One Size | 1 | 11 | 1
S/S | Silhouette | Adidas | a136/00 | 6059 | One Size | 2 | 12 | 1
S/S | Silhouette | Adidas | a136/00 | 6051 | One Size | 2 | 12 | 1
S/S | Silhouette | Adidas | a143/00 | 6053 | One Size | 2 | 12 | 1
S/S | Silhouette | Adidas | a143/00 | 6050 | One Size | 2 | 12 | 1
S/S | Silhouette | Adidas | a147/00 | 6050 | One Size | 2 | 12 | 2
S/S | Silhouette | Adidas | a162/50 | 6050 | One Size | 3 | 13 | 1
S/S | Silhouette | Adidas | a164/00 | 6053 | One Size | 3 | 13 | 1
S/S | Silhouette | Adidas | a165/00 | 6052 | One Size | 3 | 13 | 0
S/S | Silhouette | Adidas | a166/00 | 6055 | One Size | 3 | 13 | 1
S/S | Silhouette | Adidas | a170/00 | 6054 | One Size | 3 | 13 | 1
S/S | Silhouette | Adidas | a171/00 | 6054 | One Size | 4 | 14 | 0
S/S | Silhouette | Adidas | a267/00 | 6068 | One Size | 4 | 14 | 1
S/S | Silhouette | Adidas | a267/00 | 6065 | One Size | 4 | 14 | 1
 |  |  |  |  | Totals | 43 | 233 | 16
Spreadsheet: 128716d1321230114-vlookup-in-different-coumns-hooves-world-racing-syndicate-1
Sheet: LEADERBOARD

POS | MEMBERS |  |  |  | TOTAL
1
Spreadsheet: eric_saibi__9857__101101R
Sheet: Sommers 02

Owner Name |  | San Antonio City Public Service Board
Station Name |  | O W Sommers Power Station
Unit Name |  | Sommers 02
NERC Region |  | ERCOT
State |  | TX
Fuel Type |  | Natural Gas
Capacity |  | 446 MW
Start Date |  | 2001-10-12 00:00:00
End Date |  | 2001-12-06 00:00:00
Prv. Start Date |  | 2001-10-05 00:00:00
Prv. End Date |  | 2001-11-29 00:00:00
Comments |  | Control Upgrade
SIC |  | 4911
Plant ID |  | 1002208
Unit ID |  | 1005825
Outage ID |  | 15811
Spreadsheet: 688260d1595672046-password-generator-conversion-to-xl2003-example1794
Sheet: Create a password (3)

 | Series | Type | Characters | Random Number | Index | Characters
 | 1st | Random Number | 4 | 5.0003 | 5 | 6 |  | Password | 6fX)Y4j-
 |  | Random Uppercase Letter | Y | 3.0004 | 3 | f
 |  | Random Lowercase Letter | f | 6.0005 | 6 | X |  | [NAME] to regenarate
 |  | [NAME] | - | 8.0006 | 8 | )
 | 2nd | Random Number | 6 | 2.0007 | 2 | Y
 |  | Random Uppercase Letter | X | 1.0008 | 1 | 4
 |  | Random Lowercase Letter | j | 7.0009 | 7 | j
 |  | [NAME] | ) | 4.001 | 4 | -
 |  | 33 | ! | 91 | [
 |  | 34 | " | 92 | \
 |  | 35 | # | 93 | ]
 |  | 36 | $ | 94 | ^
 |  | 37 | % | 95 | _
 |  | 38 | & | 96 | `
 |  | 39 | '
 |  | 40 | (
 |  | 41 | )
 |  | 42 | *
 |  | 43 | +
 |  | 44 | ,
 |  | 45 | -
 |  | 46 | .
 |  | 47 | /
Spreadsheet: 834870d1688126979-auto-populate-cell-based-on-criteria-with-date-range-sample-worksheet
Sheet: Sheet1

 | PRICE |  | Effective Date of Price
 | PRODUCT | CATEGORY | 04/15/2023 | 06/28/2023 | 06/30/2023
 | PEN | OFFICE SUPPLIES | 5 | 7 | 10
 | PENCIL | OFFICE SUPPLIES | 5 | 8 | 9
 | PAPER | OFFICE SUPPLIES | 2 | 3 | 5
 | ALCOHOL | CLINIC SUPPLIES | 100 | 120 | 125
 | FACE MASK | CLINIC SUPPLIES | 10 | 20 | 25
 | SALES
 | DATE | PRODUCT | PRICE
 | 2023-04-15 00:00:00 | PEN
 | 2023-06-30 00:00:00 | ALCOHOL
Spreadsheet: 97040d1296240367-reference-within-another-worksheet-reference-team-stats-sheet
Sheet: Merlin Usage

 | [NAME]
 | Name |  | Week |  |  |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  |  |  | Week |  |  |  |  |  |  |  |  |  | Week
 | First | Surname | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | A | Doe
 | B | Doe
 | C | Doe
 | D | Doe
 | E | Doe
 | F | Doe
 | G | Doe
 | H | Doe
 | I | Doe
 | J | Doe
 | K | Doe
 | L | Doe
 | M | Doe
 | N | Doe
 | O | Doe
 | P | Doe
 | Q | Doe
 | R | Doe
 | S | Doe
 | Target | 0.85
Spreadsheet: 552309d1513450985-hlookup-issue-duplicates-hlookup-help-pcb-
Sheet: Sheet1

Name | High Score
 |  |  |  | 100 | 200 | 100 | 300 | 200
 |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: phillip_m_love__30155__9902_OA
Sheet: EAST-CON-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / LRC
REGION:  EAST
 |  |  | 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 | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
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:
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
FT-East
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 824846d1680886777-array-formula-keep-using-the-1st-row-as-reference-question
Sheet: Sheet1

 |  |  | D |  |  |  | 100
A | 10
B | 20 |  |  |  | 70 | 60 | <----- Why this still show 60? Y it still show F2? How to make it use its own cells instead?
B | 30 |  |  |  | 80 | 60 | <----- Why this still show 60? Y it still show F2? How to make it use its own cells instead?
C | 40 |  |  |  | 90 | 60 | <----- Why this still show 60? Y it still show F2? How to make it use its own cells instead?
C | 50
D | 60
D | 70
D | 80
D | 90
Spreadsheet: 873033d1719477065-help-with-formulas-to-populate-from-one-sheet-with-dynamic-data-to-another-sheet-as-a-list-philip_188-auto-list-1-aligw
Sheet: Sheet3

Name | Helpful column CP | Helpful Column NP | Helpful Column NP123 | Position | Activity | Arrived | Sailed | Cargo | Quantity O/B
Alpha |  |  |  | a | Load | 2024-04-12 00:00:00 | 2024-04-15 00:00:00 | Fertilizers
Alpha |  |  |  | b | Load | 2024-04-15 00:00:00 | 2024-04-16 00:00:00 | Fertilizers
Alpha |  |  |  | c | Discharge | 2024-06-09 00:00:00 | 2024-06-11 00:00:00 | Fertilizers
Alpha |  |  |  | d | Discharge | 2024-06-22 00:00:00 | 2024-06-23 00:00:00 | Fertilizers
Alpha |  |  |  | e | Load | 2024-06-28 00:00:00 | 2024-06-30 00:00:00
Alpha |  |  |  | f | Load | 2024-07-01 00:00:00 | 2024-07-02 00:00:00
Alpha |  |  |  | g | Discharge | 2024-07-04 00:00:00 | 2024-07-08 00:00:00
Bravo |  |  |  | previous | Load | 2024-06-25 00:00:00 | 2024-06-25 00:00:00 | Candy | 200
Bravo |  |  |  | start | Discharge | 2024-06-25 00:00:00 | 2024-06-28 00:00:00 | Candy | 200
Bravo |  |  |  | a | Load | 2024-06-25 00:00:00 | 2024-06-28 00:00:00 | Candy | 300
Bravo |  |  |  | b | Discharge | 2024-07-10 00:00:00 | 2024-07-11 00:00:00 | Candy | 500
Bravo |  |  |  | c | Load | 2024-07-15 00:00:00 | 2024-07-18 00:00:00
Bravo |  |  |  | d | Discharge | 2024-07-30 00:00:00 | 2024-08-01 00:00:00
Bravo |  |  |  | e | Load | 2024-08-02 00:00:00 | 2024-08-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | delta:display?file=PortScheduleLiftingPopup.VMVOY.html&target=popup&41104=5229&41600=MGO
 |  |  |  |  |  |  |  |  |  |  |  |  |  | delta:display?file=PortScheduleLiftingPopup.VMVOY.html&target=popup&41104=5242&41600=MGO
 |  |  |  |  |  |  |  |  |  |  |  |  |  | delta:display?file=PortScheduleLiftingPopup.VMVOY.html&target=popup&41104=5440&41600=MGO
 |  |  |  |  |  |  |  |  |  |  |  |  |  | delta:display?file=PortScheduleLiftingPopup.VMVOY.html&target=popup&41104=5245&41600=MGO
Spreadsheet: 41471d1239944759-dynamic-range-help-solution-dynamic-range-help-example
Sheet: Solution

Department | Account | Rate | OT % | Hours | Total (Rate*Hour) | Total
Z | Exempt | 0 | 0 | 0 | 0 | 0
Z | [NAME] | 0 | 0 | 0 | 0 | 0
Z | Resident Care Coord | 0 | 0 | 0 | 0 | 0
Z | RNs | 27.6143 | 0.03 | 110 | 3037.573 | 3037.573
Z | LPNs | 25.1732 | 0.05 | 470 | 11831.404 | 11831.404
Z | CNAs | 12.7411 | 0.05 | 1096 | 13964.2456 | 13964.2456
Z | [NAME] | 15.3161 | 0.05 | 236.992 | 3629.7931712 | 3629.7931712 |  |  |  | http://www.excelforum.com/excel-general/680019-dynamic-range-help.html
Z | [NAME] | 13.1428 | 0.05 | 112 | 1471.9936 | 1471.9936
Z | Other Nurses | 0 | 0.03 | 0 | 0 | 0
Z | Training | 16.9538 | 0 | 30 | 508.614 | 508.614
Z | [NAME] | 0 | 0 | 0 | 1635.99900856 | 1635.99900856
Q | Exempt | 19.38 | 0 | 80 | 1550.4 | 1550.4
Q | [NAME] | 0 | 0.02 | 0 | 0 | 0
Q | Chefs | 0 | 0 | 0 | 0 | 0
Q | Cooks | 12.1176 | 0.05 | 118.72 | 1438.601472 | 1438.601472
Q | Utility Workers | 0 | 0.03 | 0 | 0 | 0
Q | Servers | 0 | 0.03 | 0 | 0 | 0
Q | Bussers | 10.0674 | 0.06 | 382.13 | 3847.055562 | 3847.055562
Q | Training | 10.9752 | 0 | 2 | 21.9504 | 21.9504
Q | [NAME] | 0 | 0 | 0 | 302.75340732 | 302.75340732
L | Exempt | 17 | 0 | 40 | 680 | 680
L | [NAME] | 0 | 0 | 0 | 0 | 0
L | HouseKeepers | 10.4854 | 0.05 | 160 | 1677.664 | 1677.664
L | Laundry | 10.197 | 0.05 | 112 | 1142.064 | 1142.064
L | Training | 10.3824 | 0 | 5 | 51.91200000000001 | 51.91200000000001
L | [NAME] | 0 | 0 | 0 | 140.9864 | 140.9864
A | Exempt | 0 | 0 | 0 | 0 | 0
A | [NAME] | 18.87475 | 0.06 | 120 | 2264.97 | 2264.97
A | [NAME] | 0 | 0 | 0 | 135.8982 | 135.8982
 |  |  |  |  |  |  | [NAME] any news deparment and see it will work
 |  |  |  |  | 34443.6233712
Spreadsheet: 09b2d619-8e6d-49fb-b298-6b97d0e2b8e3
Sheet: Sheet1

MT. SAN JACINTO COMMUNITY COLLEGE
Fiscal Year 2012-2013 Fixed Costs & Health & Welfare Calculations
Fixed Costs (Taxes) and Health & Welfare (Benefits) object codes
[NAME]
Fixed costs are person specific.  Please contact Business Services for assistance.
If fund 11 - please contact [NAME] extension 3024.
If fund 12 - please contact [NAME] extension 3022.
If fund 33 - please contact [NAME] extension 3609.
A person can only be in one retirement system - either STRS or PERS.  They cannot be in both.
A person participating in the STRS system will not have the FICA (Social Security) fixed cost.
A student worker (expenditure object code 2331) will only have the worker's compensation
fixed cost object code 3620.
Hourly, temporary, overtime, and stipend payments will not have a health and welfare (34xx)
benefit cost.  The last two digits of these object codes will end in 30, 40, 60, or 70.
Classified hourly, temporary, overtime, substitutes, and out of class payments will not have
any PERS retirement costs.  These object codes will start with 23xx.
Classified overtime (2340) expenses will not have PERS retirement costs.
Classified professional experts will not have any PERS retirement costs or health and welfare
(34xx) benefit costs.  These object codes will start with 23xx or 24xx.
Health and welfare benefits are person specific which is dependent upon the medical health
plan that the employee chooses.
In regard to budget transfers, please remember to check Galaxy to ensure that there is sufficient
budget allocated in the fixed cost (3xxx) object code that you are wanting to remove budget from.
In regard to expense transfers, please remember to check Galaxy to ensure that there is sufficient
expenses posted in the fixed cost (3xxx) object code that you are wanting to transfer out of.
These percentages are for use during the 2012-2013 fiscal year only.
The APPLE program is an alternative fixed cost which replaces the FICA (Social Security) fixed
cost.  Participation in the APPLE program is mandatory for some groups of employees.
Employees participating in the APPLE program will not have the PERS or STRS fixed cost.
Permanent employees are not eligible to participate in the APPLE program.
Prepared/revised by Business Services on 7/31/2012
Spreadsheet: 729349d1619032204-find-maximum-value-matching-specific-names-with-multiple-entries-data-sample-nm
Sheet: Sheet1

ClubId | CourseName | Slope | MarkerName
30232 | Achill | 95 | White |  | Achill | 95 | White
30232 | Achill | 95 | White B9 |  | Athenry | 122 | White B9
30232 | Achill | 94 | White F9 |  | Athlone | 126 | Blue
30398 | Athenry | 122 | White B9
30398 | Athenry | 121 | White
30398 | Athenry | 121 | Green B9
30398 | Athenry | 119 | White F9
30398 | Athenry | 118 | Green
30398 | Athenry | 114 | [NAME]
30400 | Athlone | 126 | Blue
30400 | Athlone | 126 | Blue B9
30400 | Athlone | 126 | Blue F9
30400 | Athlone | 126 | White F9
30400 | Athlone | 125 | White
30400 | Athlone | 123 | White B9
30400 | Athlone | 123 | [NAME]
30400 | Athlone | 121 | Yellow
30400 | Athlone | 118 | [NAME]
30400 | Athlone | 117 | [NAME]
30400 | Athlone | 116 | Green
30400 | Athlone | 116 | Green B9
Spreadsheet: vkaminski__40790__CASH_Elba_04112000wML
Sheet: Common Assumpt

ASSUMPTIONS
March 30, 2000
Curves: |  | 1999
[NAME]
Lake Charles Basis |  | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07 | -0.07
[NAME]
[NAME]
 | Elba Island Assumptions:
 | ENE Share of Facility Capacity |  |  |  |  | TBtu/Yr | 62.9
 |  |  |  |  |  | Bcf/Yr | 58
 | Cargo Assumptions:
 | Capacity of 1 Mystic Lady Cargo |  |  |  | 2.047982820208814 | Tbtu/Cargo
 | Capacity of 1 NewBuild Cargo |  |  |  |  | Tbtu/Cargo
 | Shipping Costs:
 | Esc as % of CPI:
 | Escalation begins in 2003 |  |  |  |  |  |  |  | Ttl Cost | Var Cost Only
 |  | Elba Shipping Costs |  |  | Ship Used | Flat Charter | O&M Charter | Voyage Cost | Total Cost
 |  | Algeria (Arzew) |  |  | Mystic Lady
 |  | Abu Dhabi via Suez Canal |  |  | Newbuild
 |  | Lake Ch Shipping Costs |  |  | Ship Used | Flat Charter | O&M Charter | Voyage Cost | Total Cost
 |  | Algeria (Arzew) |  |  | Newbuild
 |  | Abu Dhabi via Suez Canal |  |  | Newbuild
 | Margin:
 |  | Lake Charles ($/MMBtu): |  |  | 0.02
 | Terminaling Costs:
 | Esc as % of CPI:
 | Escalation begins in 1999
 |  | Elba Island: |  |  | Adjustment | 1 |  |  | [NAME]:
 |  |  |  |  |  | All Yrs |  |  |  |  |  |  | All Yrs
 |  | Flat Cost ($[NAME]/Yr) |  |  |  |  |  |  | Flat Cost ($/MMBtu)
 |  | Esc Cost ($[NAME]/Yr) |  |  |  |  | Esc'd |  | Fuel Cost (% of Prev Yr FOB)
 |  | Other Var Cost ($/MMBtu) |  |  |  |  | Esc'd
 |  | Fuel Cost (% of Prev Yr FOB)
 | Portion of Savings Given to Enron (vs [NAME]) ($/MMBtu):
 | ENA Marketing Costs on Non-VZ Volumes ($/MMBtu): |  |  |  |  |  |  |  | Esc. Fr 99 as % of CPI:
 | Conversion Factor:
 | MMBtu/MMScfd |  | 1082.9
 | Discount Rate for PV calculations: |  |  |  | 0.17
 | Probability of Exit Scenarios
 | Option 1:  Resell Unutilized Capacity to Third Party |  |  |  |  | 0.2
 | Option 2:  Pay Full Cost of Service |  |  |  |  | 0.2
 | Option 3:  Spot Cargoes Forever |  |  |  |  | 0.6
 | Option 3: Spot Cargoes Received (relative to Gas Price)
 |  | 1.5 | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 3 | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 6
Spreadsheet: 854305d1704230408-cell-number-formatting-issue-in-excel-example
Sheet: Sheet 1

Table 1
 |  | PARTICIPANT AGE
 |  | 45056
 |  | 45244
 |  | 45056
 |  | 14-19
 |  | 45056
 |  | 45056
 |  | 45056
 |  | 45056
 |  | 45056
 |  | 45056
 |  | 45056
 |  | 45056
 |  | 45056
 |  | 45056
 |  | 45056
 |  | 45056
 |  | 45244
 |  | 45056
 |  | 14-19
 |  | 45056
 |  | 45056
 |  | 45056
 |  | 45244
 |  | 45056
 |  | 45244
 |  | 45056
 |  | 45056
Spreadsheet: andy_zipper__298__NYMEX Straddles
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | H | 210 | 24 | 24.5 | 0.6200500000000055 | -0.03119999999999656
 | J | 215 | 33 | 33.5 | 0.5359999999999994 | -0.02624999999999711
 | K | 225 | 38.5 | 40.5 | 0.4816000000000009 | -0.01889999999999792
 | M | 230 | 43.5 | 45.5 | 0.4473500000000025 | -0.01604999999999823
 | N | 235 | 50 | 52 | 0.4502999999999852 | -0.01379999999999848
 | Q | 240 | 57 | 60 | 0.4582999999999848 | -0.01859999999999795
 | U | 240 | 62 | 64 | 0.4593499999999847 | -0.009599999999998943
 | V | 245 | 68 | 70 | 0.4623499999999844 | -0.01019999999999888
 | X | 265 | 78 | 80.5 | 0.4632499999999843 | -0.01019999999999888
 | Z | 285 | 89 | 92 | 0.4681999999999837 | -0.007499999999999174
 | F | 295 | 98 | 100 | 0.4741500000000073 | -0.01139999999999874
 | G | 290 | 99 | 100.5 | 0.4695000000000078 | -0.01589999999999825
 | H03 | 285 | 94 | 98 | 0.4444999999999995 | -0.005399999999999405
 | M03 | 280 | 84 | 88.5 | 0.3694000000000017 | -0.01049999999999884
 |  |  | 2002-02-06 14:37:31.540000
 |  |  | Crude Oil Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | H | 2000 | 120 | 128 | 0.5891999999999868 | -0.02699999999999703
 | J | 2000 | 235 | 245 | 0.4677999999999977 | -0.008549999999999058
 | K | 2050 | 315 | 322 | 0.4483499999999982 | -0.02279999999999749
 | M | 2050 | 370 | 380 | 0.4466499999999958 | -0.01109999999999878
 | N | 2050 | 415 | 430 | 0.4353999999999949 | -0.005099999999999438
 | Q | 2050 | 440 | 460 | 0.4180499999999956 | -0.004799999999999471
 | U | 2050 | 460 | 480 | 0.4088000000000001 | 0.002399999999999736
 | V | 2050 | 470 | 490 | #[NAME]! | #[NAME]!
 | X | 2050 | 480 | 500 | #[NAME]! | #[NAME]!
 | Z | 2050 | 485 | 505 | 0.356099999999989 | -0.00299999999999967
 | F | 2050 | 490 | 510 | 0.3437999999999904 | -0.002099999999999769
 | G | 2100 | 495 | 525 | #[NAME]! | #[NAME]!
 | M03 | 2100 | 535 | 545
 |  |  | 2002-02-06 14:48:34.160000
Spreadsheet: 887354d1737581142-override-conditional-formating-row-highlight-to-manual-highlight-mock-excel
Sheet: Sheet1

ORDER DATE | CUSTOMER | PRODUCT | QUANTITY | # OF PIECES | SHIP DATE | P/U TIME | DELIVERY DATE | DIS-PATCHED? | REP | NOTES
 |  |  |  |  |  |  |  |  | Salesman 1
 |  |  |  |  |  |  |  |  | Salesman 2
 |  |  |  |  |  |  |  |  | Salesman 3
 |  |  |  |  |  |  |  |  | Salesman 1
 |  |  |  |  |  |  |  |  | Salesman 2
 |  |  |  |  |  |  |  |  | Salesman 3
 |  |  |  |  |  |  |  |  | Salesman 3
 |  |  |  |  |  |  |  |  | Salesman 2
 |  |  |  |  |  |  |  |  | Salesman 1
 |  |  |  |  |  |  |  |  | Salesman 1
 |  |  |  |  |  |  |  |  | Salesman 2
 |  |  |  |  |  |  |  |  | Salesman 2
 |  |  |  |  |  |  |  |  | Salesman 3
 |  |  |  |  |  |  |  |  | Salesman 1
Spreadsheet: 1a8fe9c9-4c42-45a4-8564-a10c05f8794e
Sheet: Sheet1

 | Position Authorization Form
Date: |  |  |  |  |  |  |  |  |  |  |  | UNIT ID#_______________
From |  |  |  |  |  | email |  |  |  |  |  | Phone
Dept |  |  |  |  | supervisor |  |  |  |  |  |  | Zip
AAC |  |  |  |  |  | email |  |  |  |  |  | Phone
Position Request
 |  |  |  |  |  |  |  |  |  | On Hiring Plan
 |  | Reactivate PCN |  |  |  | PCN#
 |  | Fill Vacant Position |  |  |  | PCN# |  |  |  | Person Replacing
 |  |  |  |  |  |  |  |  |  |  |  | Location:
 |  | Change Position |  |  |  | PCN# |  |  |  |  |  | Previous Title
 |  |  |  |  |  |  |  |  |  |  |  | New Title
 | Create New Position |  |  |  |  |  | Permanent [NAME] |  |  |  |  | 00 Suffix |  | 01 Suffix
Approval to Create a New Position: |  |  |  |  |  |  | Temporary PCN |  |  |  |  | 01 Suffix
Executive Director of Planning and Budget |  |  |  |  |  |  | Date
Rationale:
Status of Position
1) |  | Permanently budgeted position |  |  |  |  |  |  |  |  |  | Temporarily budgeted position
2) |  | Faculty |  |  |  |  | Exempt |  |  |  |  |  |  | Classified
 |  | Tenure Track |  | Non-tenure track
 | Rank |  |  |  |  |  | Title |  |  |  |  |  |  | Pay Grade
3) |  | Full Time |  |  |  |  |  |  |  |  |  | Part-time |  |  | %
4) |  | Fiscal Year appt |  |  |  |  | Academic Year appt |  |  |  | Appointment Dates
Funding Sources |  |  |  | [NAME]: $
Allocation |  |  |  | % |  | Amount |  |  |  |  | Comments
 |  |  |  |  |  | $
 |  |  |  |  |  | $
 |  |  |  |  |  | $
 |  |  |  | Total Annual Salary |  | $
Approvals |  |  |  |  |  |  |  |  |  |  |  | PBUD:
 |  |  |  |  |  |  |  |  |  |  |  | MIN:
 |  |  |  |  |  |  |  |  |  |  |  | MID:
 | Manager/Supervisor |  |  |  |  |  |  |  |  |  |  | MAX:
 | Dept Chair/Head; Center/joint/interdisciplinary appointments require joint signatures |  |  |  |  |  |  |  |  |  |  |  |  | Date
 | [NAME]/Director; Center/joint/interdisciplinary appointments require joint signatures |  |  |  |  |  |  |  |  |  |  |  |  | Date
 | Vice President/Provost/President |  |  |  |  |  |  |  |  |  |  |  |  | Date
 |  |  |  |  |  |  |  |  |  |  |  | Revised 4/09/2013
Spreadsheet: 78147d1278563230-sumproduct-dual-condition-expense-type-query-example
Sheet: Sheet1

 | Date | Type | Account 1 | Account 2 | Account 3
 | 2010-07-01 00:00:00 | fuel |  |  | -15
 | 2010-07-05 00:00:00 | fuel |  | -17.67
 | 2010-07-05 00:00:00 | food |  | -5.67
 | 2010-07-07 00:00:00 | fuel |  | -31.67
 | 2010-07-08 00:00:00 | fuel |  | -14.84
 | Analysis | Jul | Aug | Sep | Oct | Nov
 | Fuel | -64.18
 | Expense Type |  | SUMPRODUCT((TEXT($B$3:$B$7,"MMM")=C$9)*($C$3:$C$7=$B10),--($E$3:$E$7))
 | 1. Reads month from the month input row in Analysis table, uses column range B3:B7
 | 2. Reads expense type from the input column in Analysis table, uses column C3:C7
 | 3. Sums all the corresponding expense type for that month
 | PROBLEM:
 | Works fine if only one account is being used to pay for the specific expense type
 | REALITY:
 | Expense can be paid from all three accounts
 | SOLUTION?
 | How can the formula be modified such that it reads all 3 accounts and return the correct value
 | Which in this case is -64.18 + -15 = -79.18
 | NOTE:
 | Expense is noted as a negative number
 | Income is noted as a positive number