tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 737856d1624628141-find-maximum-for-every-5-rows-finalchoicesetexample
Sheet: Sheet1

Respondent | Choiceset | Alternative | Choice | Probability Prediction | Maximum | Predicted correctly
1146 | 1 | 1 | 0 | 0.1253469 | 0.2890968
1146 | 1 | 2 | 0 | 0.1944772 | 0.3940507
1146 | 1 | 3 | 1 | 0.2890968 | 0.37475
1146 | 1 | 4 | 0 | 0.2255877 | 0.5648751
1146 | 1 | 5 | 0 | 0.1654914 | 0.3909876 | Yes
1146 | 2 | 1 | 0 | 0.0417012 | 0.3783129 | Yes
1146 | 2 | 2 | 0 | 0.1339172 | 0.4457806
1146 | 2 | 3 | 1 | 0.3449135 | 0.4086733 | Yes
1146 | 2 | 4 | 0 | 0.3940507 | 0.4755266 | Yes
1146 | 2 | 5 | 0 | 0.0854175
1146 | 3 | 1 | 0 | 0.0457048
1146 | 3 | 2 | 0 | 0.1574961
1146 | 3 | 3 | 0 | 0.3380672
1146 | 3 | 4 | 1 | 0.37475
1146 | 3 | 5 | 0 | 0.0839818
1146 | 4 | 1 | 0 | 0.0267933
1146 | 4 | 2 | 0 | 0.0924478
1146 | 4 | 3 | 0 | 0.2916102
1146 | 4 | 4 | 1 | 0.5648751
1146 | 4 | 5 | 0 | 0.0242736
1146 | 5 | 1 | 0 | 0.0389354
1146 | 5 | 2 | 0 | 0.1544882
1146 | 5 | 3 | 1 | 0.3713331
1146 | 5 | 4 | 0 | 0.3909876
1146 | 5 | 5 | 0 | 0.0442557
1146 | 6 | 1 | 0 | 0.0460409
1146 | 6 | 2 | 0 | 0.1618849
1146 | 6 | 3 | 1 | 0.3783129
1146 | 6 | 4 | 0 | 0.367652
1146 | 6 | 5 | 0 | 0.0461093
1146 | 7 | 1 | 0 | 0.058521
1146 | 7 | 2 | 0 | 0.1395181
1146 | 7 | 3 | 1 | 0.3081291
1146 | 7 | 4 | 0 | 0.4457806
1146 | 7 | 5 | 0 | 0.0480512
1146 | 8 | 1 | 0 | 0.0424551
1146 | 8 | 2 | 0 | 0.1558215
1146 | 8 | 3 | 1 | 0.3429192
1146 | 8 | 4 | 0 | 0.4086733
1146 | 8 | 5 | 0 | 0.050131
1146 | 9 | 1 | 0 | 0.0281882
1146 | 9 | 2 | 0 | 0.1154203
1146 | 9 | 3 | 1 | 0.3381637
1146 | 9 | 4 | 0 | 0.4755266
1146 | 9 | 5 | 0 | 0.0427012
Spreadsheet: 10f379ff-850d-45e3-a63f-44c149617869
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-01-28 09:22:51.800000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.75 | 102.719 | 102.594 | 102.469 | 102.094
4.625 | 102.24 | 102.115 | 101.99 | 101.615 |  | Note: | Refer To Price [NAME]
4.5 | 101.338 | 101.213 | 101.088 | 100.713 |  |  | For all Price Adjs
4.375 | 100.396 | 100.271 | 100.146 | 99.521
4.25 | 99.741 | 99.616 | 99.491 | 98.866
4.125 | 98.942 | 98.817 | 98.692 | 98.067
4 | 97.956 | 97.831 | 97.706 | 97.081
3.875 | 96.925 | 96.8 | 96.675 | 96.05 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.492 | 102.367 | 102.242 | 101.867
3.75 | 101.956 | 101.831 | 101.706 | 101.331
3.625 | 101.556 | 101.431 | 101.306 | 100.931
3.5 | 100.983 | 100.858 | 100.733 | 100.108
3.375 | 100.229 | 100.104 | 99.979 | 99.354
3.25 | 99.427 | 99.302 | 99.177 | 98.552 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-02-11 09:22:51.800000
30 DAY | 2014-02-26 09:22:51.800000
45 DAY | 2014-03-13 09:22:51.800000
60 DAY | 2014-03-28 09:22:51.800000
90 DAY | 2014-04-27 09:22:51.800000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 8adfe551-b5b6-4b7c-aeb7-b71753d5bf36
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - Primary Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Belknap County Offices - Democratic
2012-09-11 00:00:00 | Sheriff |  |  | Attorney |  |  | Treasurer
 | Wiggin, r |  | [NAME] | [NAME], r |  | [NAME] | Muzzey, r |  | [NAME]
Alton | 4 |  | 5 | 12 |  | 4 | 2 |  | 4
Barnstead | 2 |  | 12 |  |  | 2 |  |  | 2
Belmont | 4 |  | 9 |  |  | 5 |  |  | 4
Center Harbor | 1 |  | 3
Gilford | 13 |  | 8 | 1 |  | 12 |  |  | 3
Gilmanton | 1 |  | 4 | 2 |  | 5 |  |  | 2
[NAME] | 6 |  | 1 | 1 |  |  | 1
[NAME] | 4 |  | 1 | 2 |  | 3 | 1 |  | 2
[NAME] 3 | 2 |  | 1 |  |  | 2
[NAME] | 2 |  | 1 |  |  | 1 | 1 |  | 1
[NAME] | 3 |  | 1 |  |  |  |  |  | 1
[NAME] 6 | 3 |  | 4 |  |  | 5
Meredith | 2 |  | 8 | 1 |  | 7 |  |  | 5
New Hampton | 1 |  | 3 | 1 |  |  |  |  | 1
Sanbornton | 2 |  | 10 |  |  | 9 | 1 |  | 6
[NAME] | 2 |  | 14 |  |  | 6 |  |  | 7
TOTALS | 52 |  | 85 | 20 |  | 61 | 6 |  | 38
 | Reg. of Deeds |  |  |  |  | Reg. Of Probate
 | Ahlgren, d | Luther, r | [NAME] |  |  | Shartar-Howe, d | Brickner, r | [NAME]
Alton | 183 |  | 1 |  |  | 182 |  | 1
Barnstead | 249 |  | 1 |  |  | 251 |  | 1
Belmont | 252 |  | 1 |  |  | 252
Center Harbor | 56 |  |  |  |  | 59
Gilford | 427 |  | 8 |  |  | 429 | 2
Gilmanton | 199 | 1 |  |  |  | 202
[NAME] | 137 | 3 |  |  |  | 131 | 1
[NAME] | 101 | 2 |  |  |  | 102
[NAME] 3 | 137 | 5 |  |  |  | 131 | 1
[NAME] | 96 | 2 |  |  |  | 91
[NAME] | 94 | 2 | 1 |  |  | 96
[NAME] 6 | 140 | 4 |  |  |  | 137 |  | 1
Meredith | 308 | 2 | 3 |  |  | 309 | 1 | 1
New Hampton | 135 | 1 |  |  |  | 135 |  | 2
Sanbornton | 231 | 3 |  |  |  | 231 | 1
[NAME] | 231 | 2 |  |  |  | 224 | 1
TOTALS | 2976 | 27 | 15 |  |  | 2962 | 7 | 6
 | County Commissioners
 | District 1 |  |  | District  2 |  | District 3
 | Philpot, d | [NAME], r | [NAME] | NO ELECTION |  | Nedeau, r |  | [NAME]
Alton |  |  |  |  |  | 2 |  | 4
Barnstead
Belmont
Center Harbor |  |  |  |  |  |  |  | 3
Gilford |  |  |  |  |  |  |  | 16
Gilmanton
[NAME] | 165 |  | 1
[NAME] | 110 | 1
[NAME] 3 | 165
[NAME] | 112 |  | 1
[NAME] | 165
[NAME] 6 | 163 | 1
Meredith |  |  |  |  |  | 9 |  | 10
New Hampton | 140 |  | 1
Sanbornton | 231 | 5 | 1
[NAME]
TOTALS | 1251 | 7 | 4 |  |  | 11 | 0 | 33
Spreadsheet: paul_y'barbo__28522__Fuel Inventory Report
Sheet: Sheet1

EcoEléctrica, L.P.
Fuel Inventory Report
 | In accordance with Article 7.0, Section 7.7 of the PPOA
 |  |  |  |  |  | 2001-05-11 00:00:00
 |  |  | LNG |  | LPG |  | Fuel Oil
Fuel (barrels) - Inventory |  |  | 296218 |  | 72159 |  | 68536
Fuel (MMBTU) - Inventory
Fuel (barrels) in excess of XDL |  |  |  |  | N/A |  | N/A
Fuel (MMBTU) in excess of XDL |  |  | 28000 |  | N/A |  | N/A
Projected Delivery date (s) |  |  | 2001-05-16 00:00:00
Projected Delivery quantities (MMBTU) |  |  | 2040000
Projected Delivery quantities (barrels)
Excess LNG spot fuel price ($/MMBTU HHV) |  |  | 5.8
Backup Fuel Spot fuel price ($/MMBTU HHV)
Date and time submitted by EcoEléctrica |  |  | 2001-05-11 00:00:00 |  | [NAME]
Submitted by (EcoEléctrica) |  |  | [NAME], Plant Manager
Received by (PREPA)
Distribution:
PREPA |  |  | EcoEléctrica
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
 |  |  | J. Sanabria
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | D. Master
Spreadsheet: lynn_blair__24414__NNGWKednotes
Sheet: October 27 & 28, 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-10-27 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI
 | 8:00 AM Final Storage
 | Gas Day: | SAT
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN
 | 11:30 A.M. Timely
 | Gas Day: | SUN
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps. |  |  |  |  |  | 6:30 - 3:30
 |  |  |  |  |  |  | 6:30 - 3:30
 |  |  |  |  |  |  | 1:00 - 10:00
 |  |  |  |  |  |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT
 | 8:00 AM Final Storage
 | Gas Day: | SUN
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON
 | 11:30 A.M. Timely
 | Gas Day: | MON
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps: |  |  |  |  |  | 6:30 - 3:30
 |  |  |  |  |  |  | 6:30 - 3:30
 |  |  |  |  |  |  | 1:00 - 10:00
 |  |  |  |  |  |  | 1:00 - 10:00
Spreadsheet: 167482d1342011078-matching-entries-in-different-columns-test-worksheet
Sheet: Sheet1

will | 0.76 |  | ball | 0.34
all | 0.54 |  | keen | 0.23
keen | 0.12 |  | cool | 0.99
done | 1.3 |  | will | 0.12
aspect | 2.4 |  | cool | 0.34
cool | 1.2 |  | keep | 0.12
Spreadsheet: phillip_m_love__30658__9910_OA
Sheet: ONT_GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
REGION:  ONTARIO
REGION:  ONTARIO
 |  |  | Total |  | Reclasses |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | 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 |  |  |  |  |  |  |  |  | -2863 | -9110
2 |  | Liquidations |  |  |  |  |  |  |  | 681178.39
3 |  | Interdesk |  |  |  |  | 3054942 | 8054746 | 235701 | 652860 | -3054942 | -8054746
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  | -6319
7 |  | Liquidations |  |  |  |  |  |  |  | 0
8 |  | Interdesk |  |  |  |  | -1097382 | -2953905 | -1028219 | -2768905 | 1097382 | 2953905
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 |  |  |  |  | 169965 | 531990 | -291156 | -911318 | 8709 | 27258
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: |  |  |  |  |  |  | 0 | 1006547 | 3150492 | 1958033 | 6128643 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | Fuel: |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  | -574371 |  | -46100 | 0
25 |  | Demand |  |  |  |  |  | 0
 | 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 |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 57337
34 |  | Originations
35 |  | Broker Fees |  |  |  |  |  |  |  | -340
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | 0 |  | 0
 |  | TOTAL
FT-Ontario
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | -241634 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 713857d1610981134-match-function-looking-up-number-value-20210718_su2xl_kalk-update_xl-help-2
Sheet: KALK

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MLxML2 | ML2xMIN | MLxMIN | MLxML | ML2=0 | ML2=MIN | [NAME] | CODE | CL | CB | CH | L | B | H | B-Z-A | EBENE
Spreadsheet: 123339d1317582016-how-do-i-use-the-address-match-function-to-return-an-entire-range-reference-ie-c-c-address-match-attempt-example
Sheet: Sheet1

Animal | Dog | Cat | Bird | Rabbit | Lizard | Fish | Sum Criteria | Sold
Bought | 8 | 7 | 2 | 15 | 12 | 30
Sold | 5 | 3 | 2 | 3 | 11 | 20
Donated | 3 | 4 | 0 | 12 | 1 | 10
 |  |  |  |  |  |  | Reference field/lookup value | Lizard
 |  |  |  |  |  |  | Match Function (Gives proper Column #)
 |  |  |  |  |  |  | Address Function that doesn't work |  | If I leave row blank or = to 0 it gives me an error, what I want it to return is the entire column range based on the reference value, So in the case of "Lizard" it should return $F:$F
 |  |  |  |  |  |  | Address works if row field populated, but doesn't give me column range absent row reference |  | I want F:F
 |  |  |  |  |  |  | Address match combo |  | What I want is to combine the match function with the address function (Or some other function) to return the entire column range $?:$? Or even row range depending on what I'm looking for, I want it to be like Hey you are looking for lizard, that's in column/range "F:F"
 |  |  |  |  |  |  | works if row field populated |  | again if the row field is filled in it works but not the way I want it to, I don't want the row referenced, just the column range
 |  |  |  |  |  |  | Sumif formula I'm trying to get to work | =SUMIF(A:A, J1, ADDRESS(,MATCH(J5,1:1, 0),,,)) | The goal is to get it so that I have a sum if formula where the sum range isn't static but is based off of whatever value I have in the reference field.  So in this example, if the lookup is Lizard, the sum range should be $F:$F, if the lookup is bird the sum range should be $D:$D and so on
Spreadsheet: 125461d1319041391-comparing-cells-and-if-equal-then-copy-different-cell-to-different-worksheet-mileage
Sheet: Route Calculations

[NAME] | Miles End | Total Miles
Alpental | West | 1.8
Alpental | Central | 2.9
Alpental | East | 4.8
Alpental | Silver Fir | 3.8
Alpental | Tubing | 3.1
West | Alpental | 1.8
West | Central | 1.1
West | East | 3
West | Silver Fir | 2
West | Tubing | 1.3
Central | West | 1.1
Central | Alpental | 2.9
Central | East | 1.9
Central | Silver Fir | 0.9
Central | Tubing | 0.2
East | Central | 1.9
East | West | 3
East | Alpental | 4.8
East | Silver Fir | 1
East | Tubing | 1.7
Silver Fir | East | 1
Silver Fir | Central | 0.9
Silver Fir | West | 2
Silver Fir | Alpental | 3.8
Silver Fir | Tubing | 0.7
Tubing | Silver Fir | 0.7
Tubing | East | 1.7
Tubing | Central | 0.2
Tubing | West | 1.3
Tubing | Alpental | 3.1
Spreadsheet: 749514d1632845961-comparing-two-column-to-calculate-overdue-overdue
Sheet: Sheet1

 |  | 2021 Plan
 | Column1 | # | Title | Column2 | Date Planned | Date Completed | Column3
 | 1 | 2021_0079 | Apples 1 | e | 2021-03-04 00:00:00 | 2021-04-15 00:00:00 |  |  |  |  |  |  | Both of these show up as overdue in F19 like they should
 | 1 | 2021_0080 | [NAME] | e | 2021-04-15 00:00:00 | 2021-06-13 00:00:00
 | 1 | 2021_0081 | Apples 3 | s | 2021-05-20 00:00:00 | 2021-07-20 00:00:00
 | 1 | 2021_0082 | [NAME] | p | 2021-05-20 00:00:00 | 2021-07-20 00:00:00 |  |  |  |  |  | This date should show up in F19
 | 1 | 2021_0083 | Oranges 1 | e | 2021-07-26 00:00:00 | 2021-07-26 00:00:00
 | 1 | 2021_0084 | Oranges 2 | e | 2021-08-01 00:00:00 |  |  |  |  |  |  | This date should be overdue (add today in to the formula)
 | 1 | 2021_0085 | Oranges 3 | e | 2021-09-30 00:00:00
 | 1 | 2021_0086 | Bananas 1 | e | 2021-09-30 00:00:00 | 2021-10-15 00:00:00
 | 1 | 2021_0087 | Pear | p | 2021-10-15 00:00:00
 | 1 | 2021_0088 | [NAME] | s | 2021-10-25 00:00:00
 | 1 | 2021_0089 | Blueberry | e | 2021-11-06 00:00:00 | 2021-12-15 00:00:00 |  |  |  |  |  | This date should show up in F19
 | 1 | 2021_0090 | Bananas 2 | e | 2021-11-15 00:00:00
 |  |  |  |  |  | total
 |  |  |  |  |  | s
 |  |  |  |  |  | p
 |  |  |  |  |  | existing
 |  |  |  |  |  | overdue "e" |  |  |  |  |  | Show show a count of 6 (G3, G4, G6, G8, and G13)
 |  |  |  |  |  | upcoming
 |  |  |  |  |  |  |  |  |  |  |  | only looking for the e's
 |  |  | compare two list with count ifs
 |  |  |  |  |  |  |  |  |  | column H is not really used, I was playing around with different formulas. This will be deleted in the final version, not used.
 |  |  |  |  |  |  |  |  |  | upcoming are shipments not completed but not yet overdue
Spreadsheet: 853404d1703262921-formula-for-pro-rating-given-values-pto-calculator-1-
Sheet: Employee PTO Load

Name | Anniversary Date | 2024 PTO
[NAME] | 2014-04-20 00:00:00
[NAME] | 2014-10-31 00:00:00
Name | Anniversary Date |  |  | Copy down |  | Dynamic
[NAME] | 2014-04-20 00:00:00
[NAME] | 2014-10-31 00:00:00
From (yr) | Rate (days)
0 | 16
3 | 21
5 | 26
10 | 31
1. Time must be used in 0.5 increments, and is always rounded DOWN
2. An employee accrues time MONTHLY
For example, if an employee has a start date of April 14th, 2014 - he will not have any accrual for April.
For employees who are terminated, if they leave mid-month, they do not accrue time for the current month.
Spreadsheet: jeff_dasovich__14229__e206 Ford calculations
Sheet: Sheet1

Ford Motor Company | [NAME]
 |  | In Millions $
Ford's total 1996 Revenues |  | 62710
Ford's two major lines of business
Automotive % revenue | 0.93
Non-automotive % revenue | 0.07
Ford's total 1996 Net Income
Automotive % operating income | 1.05
Non-automotive % operating income | -0.05
North American Automotive Operations (NAAO)
Ford's total USA revenues |  | 50000 | (page 302 company background)
[NAME] | 0.77
Luxury %
Ford's 1986 market share USA % | 0.253
Derived USA total market size
Options
1. Do nothing: lose 1.5 to 1.75% market share
Revenue that would be lost | 0.0175
Warranty costs would go down since less cars are sold.
2. Match GM
Revenue/market share stay stable
Warranty costs go up
3. Exceed GM
Revenue/market share would go up. |  | Note - Ford is currently capacity constrained (for the past 29 months).
Warranty costs up |  | (Note page 303 top right.)
 |  | They would need to build more factories to have capacity to take
 |  | advantage of a market share gain.
4. Do less than GM but match Chrysler
Revenue/market share would go up.
Warranty costs up
5. [NAME] approach
Revenue/market share would go up.
Warranty costs up
Spreadsheet: 09a4376a-027f-4551-8c76-44a275803817
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (11 Entries):
 | 5 Laboratory apparatus 5.4 Laboratory technology and equipment 5.4.7 Laboratory equipment 5.4.7.7 Water-purification systems
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Adrona | Latvia | Latvija, Riga | 1006 | A1.131
2 | Labconco Corporation | USA | Kansas City | MO 64034 | B2.125
3 | membraPure GmbH | Germany | Hennigsdorf | 16761 | A1.213
4 | Merck Millipore | Germany | Darmstadt | 64293 | A1.408
5 | Siemens AG, I IA WT HUB EUR | Germany | Barsbüttel | 22885 | B1.417
6 | Telstar Technologies S.L. | Spain | Terrassa, Barcelona | 08227 | B2.205
7 | Thermo Scientific | Germany | Dreieich | 63303 | B1.101/202
8 | VWS Deutschland GmbH ELGA LabWater | Germany | Celle | 29227 | B1.340
9 | [NAME] GmbH | Germany | Leverkusen | 51381 | B1.217
10 | YL Instrument Co., Ltd. | South Korea | Anyang, 431-836 |  | A1.428
11 | Zefa-Laborservice GmbH | Germany | [NAME] | 85630 | B1.121/220
Spreadsheet: 703068d1604727538-calculate-cumulative-sums-and-obtain-highest-value-based-on-it-sample-data-copy
Sheet: Sheet1

Concatenate | Month | Agent | Data1 | Data2 |  |  | 2020 |  | JAN
 | 2020 JUL | [NAME] | 9 | 481
 | 2020 JUL | [NAME] | 5 | 344
 | 2020 JUL | [NAME] | 20 | 971
 | 2020 JUL | Reeve | 8 | 85 |  |  | I need to obtain values based on a large data table. The sample data table is a small portion of the data extending from 2012 to 2020
 | 2020 JUL | [NAME] | 2 | 182
 | 2020 JUL | Clementine | 13 | 542
 | 2020 JUL | Brett | 10 | 211 |  |  | For the first requirement, I need to:
 | 2020 JUL | Chase | 11 | 766 |  |  | 1. get CUMULATIVE SUMS of each agent's Data1 value (except TOTAL), if "Month" column includes both the separate cell values H1 and J1
 | 2020 JUL | Sean | 12 | 1828 |  |  | 2. based on above, find the highest Data1 value of all agents, AND which agent achieved that
 | 2020 JUL | Olive | 13 | 324
 | 2020 JUL | [NAME] | 8 | 716 |  |  | The second requirement, is a slightly simpler version of the first, without the condition to match [NAME]
 | 2020 JUL | [NAME] | 26 | 440
 | 2020 JUL | TOTAL | 137 | 6890 |  |  | The third requirement, is a slightly simpler version of the first, without the condition to match both H1 or J1
 | 2019 AUG | [NAME] | 10 | 218
 | 2019 AUG | [NAME] | 3 | 227
 | 2019 AUG | [NAME] | 16 | 929
 | 2019 AUG | Reeve | 3 | 50 |  |  | It is preferred if no additional helper columns are used. The concatenate column already exists in the original table, and can be used if needed.
 | 2019 AUG | [NAME] | 3 | 132
 | 2019 AUG | Clementine | 6 | 347
 | 2019 AUG | Brett | 15 | 188
 | 2019 AUG | Chase | 8 | 827
 | 2019 AUG | Sean | 6 | 1276
 | 2019 AUG | Olive | 6 | 357
 | 2019 AUG | [NAME] | 5 | 423
 | 2019 AUG | [NAME] | 15 | 392
 | 2019 AUG | TOTAL | 96 | 5366
 | 2018 JUL | [NAME] | 9 | 354
 | 2018 JUL | [NAME] | 3 | 320
 | 2018 JUL | [NAME] | 21 | 943
 | 2018 JUL | Reeve | 20 | 227
 | 2018 JUL | [NAME] | 1 | 320
 | 2018 JUL | Clementine | 9 | 454
 | 2018 JUL | Brett | 20 | 234
 | 2018 JUL | Chase | 22 | 857
 | 2018 JUL | Sean | 12 | 1758
 | 2018 JUL | Olive | 5 | 355
 | 2018 JUL | [NAME] | 5 | 436
 | 2018 JUL | [NAME] | 13 | 163
 | 2018 JUL | TOTAL | 140 | 6421
Spreadsheet: 837677d1690351638-find-the-latest-po-number-from-the-same-item-with-index-match-and-helper-column-book2
Sheet: Summary

Item Family | Item No | Item Description | Base UOM | Inventory Posting Group | [NAME] | Transfer Multiple | DSP / DC | Store Code | QOH | QOH Date | PO No | PO Date | PO Quantity | PR Quantity | Qty Fulfilment %
D3 - Grocery | 10006666 | 100 PLUS 1L | UNIT | OUTRIGHT | 12 | 0 | DC | VXX | 0 | 24/07/2023 |  |  |  |  |  | Should show PO-5 instead