tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30653__9903_OA
Sheet: CE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | 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 | 48251606 | 79685777
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 15397109 | 26714108
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 63648715 | 106399885
 | Purchases:
6 |  | 3rd Party / Inter Enron | -40688416 | -66254041 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -22756832 | -38801752
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 288222 | 472017
 | Total Purchases: |  | -63157026 | -104583776
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 2478409 | 4536179
14 |  | Cash Out | -2343582 | -4825471.823323231
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | 134827 | -289292.8233232312
 | Storage:
17 |  | Injection (Sales to Stg) | 4148 | 6616
18 |  | W/D (Purchase from Stg) | -249256 | -391334
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -249256 | -391334
 | Total Storage: |  | -245108 | -384718
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | -288222 | -472017
 | Transport Expense:
24 |  | Commodity | 0 | -110726
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -110726
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | -91871.28
31 |  | Prior Month Book Balance | 0 | -2563659
 |  | Total MTM Income | 0 | -2655530.28
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 80635.94117647059
34 |  | Originations | 0 | 76850
35 |  | Broker Fees | 0 | -8190
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 39003
 |  | TOTAL
Spreadsheet: 43889d1242516607-reverse-data-in-columns-sample-a-symptoms-b-remedies
Sheet: Sheet1

hungry | Big Bad Relief●Small good Relief●Big/Small Elixer●Small good elixer●Big/Small Elixer
thirsty | Big elixer●Small Reliever●Small elixer●Big Bad Relief
itchy | Big Bad Relief●Small good Releif●Big/Small Elixer
smelly | Big Bad Relief●Small good Releif●Big/Small Elixer● Big Bad Relief●Small good elixer
tired | Big Bad Relief●Small good Releif●Big/Small Elixer●Big/Small Elixer
awake | Big/Small Elixer●Small good Releif
pain | Small good Releif●Big/Small Elixer
irritated | Small good Releif●Big/Small Elixer●Small good Releif●Big/Small Elixer
redness | Big Bad Relief●Small good Releif●Big/Small Elixer
restless | Big Bad Relief●Big/Small Elixer
discontent | Small good Relief●Small good elixer
unaware | Big/Small Elixer●Big/Small Elixer
soreness | Big Bad Relief●Small good Releif●Big/Small Elixer●Small good elixer●Big/Small Elixer
aches | Small good Releif●Big/Small Elixer●Small good elixer●Big/Small Elixer
Big Bad Relief | hungry●thirsty●itchy●smelly●tired●redness●restless●soreness
Big Elixer | thirsty
Big Bad Relief | hungry●thirsty●itchy●smelly●tired●redness●restless●soreness
Big/Small Elixer | hungry●itchy●smelly●tired●awake●pain●irritated●redness●restless●unaware●soreness●aches
Small Good Relief | hungry●discontent
Small Reliever | thirsty
Small Good Elixer | hungry●smelly●discontent●soreness●aches
Small Elixer | hungry●thirsty●itchy●smelly●tired●awake●pain●irritated●redness●restless●unaware●soreness●aches
Spreadsheet: 664319f1-16d9-45c7-9413-ba371d89b835
Sheet: Airside Vehicle Permit

 | APPLICATION  FORM  FOR  AIRSIDE ACCESS VEHICLE PERMIT
Single Application |  |  |  | Fleet Application
Name and Address of registered owner of the vehicle |  |  |  | Telephone No:
Name and Address of Employer / Company |  |  |  | Tel No:
 |  |  |  | Mobile No:
 |  |  |  | e-mail address
 |  |  |  | 24 Hour Contact Telephone No:
DETAILS OF VEHICLE
Fleet Number |  |  |  | Registration Number
Vehicle Type |  |  |  | Call Sign
Make |  |  |  | Licence Type Required
Model |  |  |  | Year Of Aquisition
Colour |  |  |  | Fuel Type
Height |  |  |  | Weight
* Applications for Fleet Vehicles may be attached to this application |  |  |  |  |  |  | YES | NO
Permit Access |  |  |  | Ramp
 |  |  |  | Aeroclub
 |  |  |  | Ramp + Aeroclub
Detailed Reasons for requiring an Airside Access Vehicle Permit. |  |  |  | New Vehicle
(Applications for privately owned vehicles will not be authorised) |  |  |  | Insurance
 |  |  |  | Amber [NAME]
 |  |  |  | Company Livery
 |  |  |  | Permanently Painted
 |  |  |  | [NAME]
 |  |  |  | NCT Certificate
Will you have a requirement to service aircraft within the manoeuvring area?
The Airside Vehicle Access Permit remains the property of Cork Airport and may be withdrawn on request.                                             The permit must be returned to the AMU Support Officer, AMU, Old Terminal, Cork Airport, Kinsale Road, Cork on completion of the contract or expiry of the permit.
Print Name: |  |  |  |  |  | OFFICE USE ONLY
 |  |  |  |  |  | PERMIT NO:
Signature
Date: |  |  |  |  |  | DATE ISSUED:
Approved by:                                                                       (Authorised Signatory)
 | (Print Name - Line Manager) |  |  |  |  | DATE EXPIRED:
 | (Signature - Line Manager)
Date: |  |  |  |  |  | SIGNED:
Spreadsheet: 07d05e02-6e5b-446d-ac16-1f98d621f695
Sheet: FURNITURE & FIXTURES (Pg. 5)

FURNITURE, FIXTURES & LEASEHOLD |  |  |  |  |  |  |  |  |  |  | YES
[NAME] | ACQUISTION COST | YEAR  ACQUIRED | ECONOMIC LIFE | DEPRECIATE YES / NO | [NAME] | MARKET VALUE |  | OFFICE USE ONLY |  |  | NO
Spreadsheet: 709186d1608201473-change-countif-combined-with-index-to-a-sumproduct-file-2
Sheet: Sheet1

Parameter 1
Q
W
E
R
T
Y
Q
E
R
T
R
E
R
T
Y
T
R
E
W
Q
W
E
R
Spreadsheet: b6f82958-7603-4b8e-abe4-e1316d63dcae
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME] im ländlichen Raum Südliche Oberlausitz - Variante 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 29129 | 29211 | 27597 | 25261
20 - 40 | 41282 | 36311 | 31696 | 27703
40 - 60 | 62292 | 56604 | 50197 | 43546
60 - 80 | 53379 | 53967 | 53024 | 55516
80 und mehr | 15277 | 16612 | 19905 | 20152
Insgesamt | 201359 | 192705 | 182419 | 172178
%
unter 20 | 14.46620215634762 | 15.15840273993929 | 15.12835833986591 | 14.67144466772758
20 - 40 | 20.50169100958984 | 18.84279079421914 | 17.37538304672211 | 16.08974433435166
40 - 60 | 30.93579129812921 | 29.37339456682494 | 27.5174186899391 | 25.29126833857984
60 - 80 | 26.50936883874076 | 28.0049817077917 | 29.06714761072037 | 32.24337604107377
80 und mehr | 7.586946697192576 | 8.620430191224928 | 10.91169231275251 | 11.70416661826714
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 684477d1593391440-optimum-stock-based-on-supplier-terms-supplier-terms-optimum-order
Sheet: Sheet1

need to turn over stock within 120 days of making payments due to trade finance/cash flow
what is the optimum stock to bring in each order so its clears through under 120 days?
 | product turnover from payment | deposit on PO | leadtime from PO to dispatch (days) | final payment from dispatch (days) | arrival from dispatch (days) | optimum stock to order (days)
supplier 1 | 120 | 0 | 30 | 30 | 30 | 120 | *example 100% payment is paid when stock arrives so in theory each order I place I can bring in 120 days worth of stock*
supplier 2 | 120 | 0 | 45 | 45 | 30 | 135 | *have 15 days extra due too payment after stock arrival*
supplier 3 | 120 | 0.3 | 60 | 15 | 30 | ?
supplier 4 | 120 | 0.3 | 30 | 0 | 30 | ?
supplier 5 | 120 | 0 | 30 | 0 | 30 | 90 | *based on paying 100% 30 days before arrival I assume I can bring in 90 days stock*
what effect does the deposit have and how to calculate the end result?
Spreadsheet: 769642d1645627124-delete-every-5th-row-year_temp3
Sheet: indexQuarterly

 | Q1-12 | Q2-12 | Q3-12 | Q4-12 | Q1-13 | Q2-13 | Q3-13 | Q4-13 | Q1-14 | Q2-14 | Q3-14 | Q4-14 | Q1-15 | Q2-15 | Q3-15 | Q4-15 | Q1-16 | Q2-16 | Q3-16 | Q4-16 | Q1-17 | Q2-17 | Q3-17 | Q4-17 | Q1-18 | Q2-18 | Q3-18 | Q4-18 | Q1-19 | Q2-19 | Q3-19 | Q4-19 | Q1-20 | Q2-20 | Q3-20 | Q4-20
Flip-flops
Jeans
Shoes
High heels
Suit
[NAME]
Swimsuit
Jacket
Spreadsheet: 152903d1335579687-how-to-merge-to-columns-into-one-putting-them-into-every-other-cell-ntnu-trykk_2_cols_to_1_27apr12_02
Sheet: Sheet1

USERNAME | PASSWORD |  | USERNAME / PASSWORD |  |  | USERNAME / PASSWORD
ABC | 12
DEF | 34
GHI | 56
JKL | 78
Spreadsheet: 150122d1334301904-auto-detect-the-last-two-months-to-forecast-remaning-months-by-offset-formula-forecasting-by-offset
Sheet: 2012 ADSL

 |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4 |  |  |  | Q1 TOTAL | Q2 TOTAL | Q3TOTAL | Q4 TOTAL | YEAR END
 |  | December | January | February | March | April | May | June | July | August | September | October | November | December |  |  |  |  |  | TOTAL
 | Start | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
 | End | 2011-12-31 00:00:00 | 2012-01-31 00:00:00 | 2012-02-29 00:00:00 | 2012-03-31 00:00:00 | 2012-04-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-31 00:00:00 | 2012-09-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-30 00:00:00 | 2012-12-31 00:00:00
 | Total Days | 22
 | Actual Days | 22
 | Remaing Days
PRODUCT | Total Sales | 1290 | 1097 | 1837 | 3111 | 2000
 | Forecast
 | Target |  | 4360 | 4450 | 4450 | 4750 | 4160 | 4560 | 4060 | 3770 | 4750 | 5250 | 5250 | 5630
 | IF(H$7=0;H10;IF(H$6=0;(SUM($F10)/SUM($F6))*H$7;IF(H$6<=5;(((H10+G10)/(H$6+G$6))*H$7)+H10;((H10/H$6*H$7)+H10))))
 | For the red highligheted part
 | if the 6th row (actual days)  is = "0"
 | ((Previous month's total sales/total days*0,7)+(two prevous month's total sales/total days)*0,3)*actual days of the months will be forecasted
 | For instance ; we are in APRIL and to forecast MAY
 | ((G10/G6*0,7)+(F10/F6*0,3))*H5
 | To forecast [NAME]
 | ((G10/G6*0,7)+(F10/F6*0,3))*I5
 | When we are in JUNE, to forecast JULY to DEC
 | ((H10/H6*0,7)+(G10/G6*0,3))J5  , ((H10/H6*0,7)+(G10/G6*0,3))K5  , ((H10/H6*0,7)+(G10/G6*0,3))L5 .....
 | I want to use Offset formula to auto detect the last to months to forecast all others months , from actual month to december
Spreadsheet: 877796d1724722702-combined-x-y-list-combined-x-y-list
Sheet: Sheet1

 |  | Role | Honda | Toyota | Ford
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Results
 |  | [NAME] | Honda
 |  | [NAME] | Toyota
 |  | [NAME] | Ford
 |  | [NAME] | Honda
 |  | [NAME] | Toyota
 |  | [NAME] | Ford
 |  | [NAME] | Honda
 |  | [NAME] | Toyota
 |  | [NAME] | Ford
Spreadsheet: andy_zipper__192__DYNEGY-ICE VOL May22
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
ICE CRUDE PRODUCTS VOLUME: |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 1 | 1825000 |  | Fischer, M | Firm-LD Peak | MWhs | 1 | 10400
[NAME], G | NG Fin BS, LD1 for IF | MMBtus | 1 | 1230000 |  | [NAME], R | Firm-LD Peak | MWhs | 2 | 33600
 | NG Fin BS, LD1 for NGI | MMBtus | 1 | 1510000 |  | Motley, M | Firm-LD Peak | MWhs | 1 | 122800
 | NG [NAME], ID, GDM | MMBtus | 1 | 300000 |  | Stalford, R | Firm-LD Peak | MWhs | 1 | 16800
Pimenov, V | NG [NAME], FP | MMBtus | 2 | 15000 |  | Grand Total |  |  | 5 | 183600
Grand Total |  |  | 6 | 4880000
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12873 | 10932
2 | 13275 | 10932
3 | 15491 | 10932 | -1
4 | 14090 | 10897 | -2
5 | 14451 | 10932 | -6
6 | 13027 | 10932 | -56
7 | 11185 | 10932 | -97
8 | 10651 | 10866 | -111
9 | 10898 | 10932 | -36
10 | 11139 | 10932 | -13
11 | 11928 | 10932 | -37
12 | 11557 | 10157 | -23
13 | 10718 | 10157 | -36
14 | 11228 | 10157 | -64
15 | 11959 | 10157 | -98
16 | 10946 | 10157 | -89
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  | 392389.58
2001-12-16 00:00:00
CBS Volume
 |  |  | -260608
Spreadsheet: 50056d1249469967-a-problem-with-serial-numbers-in-cells-serial-issue
Sheet: Sheet1

 | Currently |  |  |  |  |  | Required result
 | Name | Product | Serial |  |  |  | Name | Product | Serial
 | [NAME] | A | 1 |  |  |  | [NAME] | A | 1
 | [NAME] | B |  |  |  |  | [NAME] | B | 1
 | [NAME] | A | 2 |  |  |  | [NAME] | A | 2
 | [NAME] | B |  |  |  |  | [NAME] | B | 2
 | [NAME] | A | 3 |  |  |  | [NAME] | A | 3
 | [NAME] | B |  |  |  |  | [NAME] | B | 3
Spreadsheet: 679610d1590517767-identify-duplicates-in-2-columns-duplicates
Sheet: Sheet1

[NAME] | 100000 | [NAME] | 100000
[NAME] | 0.7 | [NAME] | 4140
[NAME] | 75903.8 | [NAME] | 62384 |  |  |  | Should not show row number because the month is not match
[NAME] | 0 | [NAME] | 13519.8
[NAME] | 4140 | [NAME] | 5759 |  |  |  | Should not show row number because the month is not match
[NAME] | 10000 | APRIL | 50000
[NAME] | 0.5 | APRIL | 2896 |  |  |  | Result should show 10 because the month is match
[NAME] | 50000 | APRIL | 0.7
APRIL | 5759 | APRIL | 2896
APRIL | 2896 | APRIL | 5759 |  |  |  | Should not show row number because the month is not match
MAY | 62384 | MAY | 5759
MAY | 22910 | MAY | 22910
MAY | 4140 | MAY | 4140
MAY | 86099.1 | MAY | 200000
MAY | 0.5 | [NAME] | 1234 |  |  |  | Result should show 16 because the month is match
[NAME] | 1234 | [NAME] | 0
JULY | 5759
Spreadsheet: scott_neal__38005__RHounds_sched_rev2
Sheet: Rev 2

[NAME]
Day |  | Date |  | Time |  | Activity |  | Opponent |  | Location
Saturday |  | 2001-02-10 00:00:00 |  | 9:00-10:30 |  | Practice |  |  |  | SF #2
Monday |  | 2001-02-12 00:00:00 |  | 5:00-6:00 |  | Batting Cage Practice (optional) |  |  |  | SF #2
Tuesday |  | 2001-02-13 00:00:00 |  | 7:30-9:00 |  | Practice |  |  |  | SF #2
Saturday |  | 2001-02-17 00:00:00 |  | 8:40-10:30 |  | Practice |  |  |  | SF #2
Tuesday |  | 2001-02-20 00:00:00 |  | 7:30-9:00 |  | Practice |  |  |  | SF #2
Thursday |  | 2001-02-22 00:00:00 |  | 6:00-7:00 |  | Pitchers Practice (optional) |  |  |  | SF #2
Friday |  | 2001-02-23 00:00:00 |  | 4:30-5:30 |  | Batting Cage Practice (optional) |  | (come & go) |  | SF #2
Saturday |  | 2001-02-24 00:00:00 |  | 8:40-10:30 |  | Practice |  |  |  | SF #2
Tuesday |  | 2001-02-27 00:00:00 |  | 7:30-9:00 |  | Practice |  |  |  | SF #2
Friday |  | 2001-03-02 00:00:00 |  | 4:30-5:15 |  | Batting Cage Practice (optional) |  | (come & go) |  | SF #2
Saturday |  | 2001-03-03 00:00:00 |  | 8:30-10:30 |  | Practice |  |  |  | SF #2
Monday |  | 2001-03-04 00:00:00 |  |  |  | no game
Tuesday |  | 2001-03-06 00:00:00 |  | 6:00-7:45 |  | 1st Pre-Season Game |  | Rockies |  | MM #3
Wednesday |  | 2001-03-07 00:00:00 |  |  |  | no game
Thursday |  | 2001-03-08 00:00:00 |  | 8:00- 9:45 |  | 2nd Pre-Season Game |  | Hitmen |  | SF #2*
Saturday |  | 2001-03-10 00:00:00 |  | 8:40-10:00 |  | practice |  |  |  | SF #2
Tuesday |  | 2001-03-13 00:00:00 |  |  |  | No practice - Spring Break |  |  |  | SF #2
Saturday |  | 2001-03-17 00:00:00 |  |  |  | No practice - Spring Break |  |  |  | SF #2
Monday |  | 2001-03-19 00:00:00 |  | tba |  | GAMES BEGIN |  | tba |  | tba
May |  |  |  | POST SEASON TOURNAMENT |  |  |  |  |  | TBA
SF = Spring Forest |  |  |  |  |  | *  Rockhounds are home team
SW = Spring Woods  (at the corner of Hammerly & Parana, by SW Middle School)
MM = [NAME] school fields - behind [NAME] Ford
 | TIMES SHOWN ARE ACTUAL GAME TIME  - PLEASE BE
 | AT THE FIELD 30 MINUTES PRIOR TO START OF GAME
League Rain-Out Number   =   tba
Note - Preseason tournament dates not yet announced, anticipated that it will be during two of following dates -Mon/Tue/Wed/Thurs (Mar 5-8)
Spreadsheet: 147152d1332538248-how-to-get-rid-of-value-book123-1-
Sheet: Sheet1

GIVE | COST | SOLD | TOTAL | SP | MBI PRO
12S |  | 6S |  | 330
12S |  | 7S |  | 330
12S |  | 12S |  | 330
12S |  | 14S |  | 330
Spreadsheet: 33475d1229905715-excel-2007-bar-graph-help-monthly-gas-reports-2009-test
Sheet: Monthly Avg

 |  | YTD:
 |  | [NAME]. Monthly:
 |  | Highest User for year
Technician |  | Yearly Technician Total | Average/Week | January |  |  |  | Totals | February |  |  |  | Totals | March |  |  |  | Totals | April |  |  |  | Totals | May |  |  |  |  | Totals | June |  |  |  | Totals | July |  |  |  | Totals | August |  |  |  |  | Totals | September |  |  |  | Totals | October |  |  |  | Totals | November |  |  |  |  | Totals | December |  |  |  |  | Totals
 |  |  |  | WE 1/11 | WE 1/18 | WE 1/25 | WE 2/1 |  | WE 2/8 | WE 2/15 | WE 2/22 | WE 3/1 |  | WE 3/8 | WE 3/15 | WE 3/22 | WE 3/29 |  | WE 4/5 | WE 4/12 | WE 4/19 | WE 4/26 |  | WE 5/3 | WE 5/10 | WE 5/17 | WE 5/24 | WE 5/31 |  | WE 6/7 | WE 6/14 | WE 6/21 | WE 6/28 |  | WE 7/5 | WE 7/12 | WE 7/19 | WE 7/26 |  | WE 8/2 | WE 8/9 | WE 8/16 | WE 8/23 | WE 8/30 |  | WE 9/6 | WE 9/13 | WE 9/20 | WE 9/27 |  | WE 10/4 | WE 10/11 | WE 10/18 | WE 10/25 |  | WE 11/1 | WE 11/8 | WE 11/15 | WE 11/22 | WE 11/29 |  | WE 12/6 | WE 12/13 | WE 12/20 | WE 12/27 | WE 1/3
1 | [NAME]
2 | Jon
3 | [NAME]
4 | [NAME]
5 | [NAME]
6 | Scott
7 | Shannon
8 | Harvey
9 | Gene
10 | [NAME]
11 | [NAME]
12 | [NAME]
13 | [NAME]
14 | [NAME]
15 | [NAME]
16 | [NAME]
17 | a
18 | b
19 | c
20 | d
21 | e
22 | f
23 | g
24 | h
25 | i
 |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  |  | Total: |  |  |  |  |  | Total:
 |  |  |  |  | Highest  user |  |  |  |  | Highest  user |  |  |  |  | Highest  user |  |  |  |  | Highest  user |  |  |  |  |  | Highest  user |  |  |  |  | Highest  user |  |  |  |  | Highest  user |  |  |  |  |  | Highest  user |  |  |  |  | Highest  user |  |  |  |  | Highest  user |  |  |  |  |  | Highest  user |  |  |  |  |  | Highest  user
Spreadsheet: 79539d1279785112-lookup-xy-axis-xy-axis-lookup
Sheet: Ark1

 | 1 | 5 | 25 |  | X-axis
14598 | 2.58 | 4.52 | 8.587
25874 | 20.58 | 54.2 | 100.8
56984 | 69.5 | 487.5 | 900.57
Y-axis
X-axis values | Y-axis Values | Returned Value
1 | 14598 | 2.58
5 | 14598 | 4.52
25 | 14598 | 8.587
1 | 25874 | 20.58
5 | 25874 | 54.2
25 | 25874 | 100.8
1 | 56984 | 69.5
5 | 56984 | 487.5
25 | 56984 | 900.57
Spreadsheet: 752586d1634838888-index-match-formula-to-produce-monthly-payment-schedule-p4-form
Sheet: Payment schedule

Kindly asking for index and match formula to produce monthly payment schedule as shown in the desired solution. Please note that
the schedule only includes employees whose employee number starts with S.
Monthly Payment Schedule of Employees: |  |  | 2021-09-01 00:00:00
Desired Solution
Employee No. | Employee Name | Period | Age | Basic Salary | Amount
SA1 | Ginger | 9 | 31 | 9578 | 862.02
SA2 | DIET | 9 | 34 | 7800 | 702
SA4 | COKE | 9 | 25 | 7392 | 665.28
[NAME] | Nust | 9 | 46 | 7800.32 | 702.0287999999999
SA11 | Free | 9 | 45 | 7800.32 | 702.0287999999999
 | Ginger | 9 | 31 | 9578 | 862.02
SA2 | DIET | 9 | 34 | 7800 | 702
SA4 | COKE | 9 | 25 | 7392 | 665.28
[NAME] | Nust | 9 | 46 | 7800.32 | 702.0287999999999
SA11 | Free | 9 | 45 | 7800.32 | 702.0287999999999
 | Ginger | 9 | 31 | 9578 | 862.02
SA2 | DIET | 9 | 34 | 7800 | 702
SA4 | COKE | 9 | 25 | 7392 | 665.28
[NAME] | Nust | 9 | 46 | 7800.32 | 702.0287999999999
SA11 | Free | 9 | 45 | 7800.32 | 702.0287999999999
Spreadsheet: 802419d1666842971-print-data-vertically-based-on-data-table-cliqck
Sheet: Sheet1

1 | A | 2
 | B | 1
 | C | 3
 | D | 2
 |  |  |  |  |  | Output
Spreadsheet: 08f19d95-a2c4-4bef-9cf9-e3f24f8db403
Sheet: Sheet1

Fort Hays State University | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Hays Baymont Inn & Suites Room Reservation Form
Reservation Form Required to receive Special Room Rate - $59.00 Per Night
(Completed Credit Card Agreement Must Already Be on File with Hotel)
Telephone ~ [PHONE] . . .  FAX ~[PHONE]
Use the TAB key to complete the form below . . .
Check In Date: |  |  | ** Cancellation:  Deadline 6:00P
Check Out Date:
Guest Name:
Bed Type:
Smoking Preference:
Confirmation #:
Guest Name:
Bed Type:
Smoking Preference:
Confirmation #:
Guest Name:
Bed Type:
Smoking Preference:
Confirmation #:
FHSU Contact (Individual Making Reservation):
Name: |  |  | FHSU FAX #:
Department: |  |  | FHSU Phone #:
College: |  |  | BPC Last 5 Digits:
 |  |  | [NAME] Personally:
Please Print and FAX The Form To  ~ [PHONE]
Hays Baymont Inn & Suites:  Please Confirm Reservation
Limited To Bed Rate And Lodging Taxes Only
No Additional Charges Allowed
FHSU is Exempt from Sales Tax ~ [NAME]
Spreadsheet: 33475d1229905715-excel-2007-bar-graph-help-monthly-gas-reports-2009-test
Sheet: 6-22 thru 6-28

 |  |  |  |  |  | Corp:
 |  |  | 2009-06-22 00:00:00 |  | Thru
 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Technician |  | 2008-06-22 00:00:00 |  |  |  |  |  |  | Total
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
 |  |  |  |  |  |  | Total:
Spreadsheet: 121444d1316059528-how-to-calculate-daily-available-balance-taking-into-account-yesterdays-ending-bal-excel-available-balance-help-1-
Sheet: Sheet1

Date | ETA | Origin | DEST CITY/ST/CTRY | DEST  CUST | ITEM | Pack Type | QTY Shipped | Daily Prod PROG | Daily Prod Actual | Available Balance
2010-09-19 00:00:00 |  | MI | Program | Program | Balloon | Red |  |  | 0
2010-09-20 00:00:00 |  | MI | Program | Program | Balloon | Red |  |  | 123
2010-09-21 00:00:00 |  | MI | Program | Program | Balloon | Red |  |  | 162
2010-09-22 00:00:00 |  | MI | Program | Program | Balloon | Red |  |  | 156
2010-09-23 00:00:00 |  | MI | Program | Program | Balloon | Red |  | 200 | 153
2010-09-23 00:00:00 | FRI | MI | TX | Sample Co 1 | Balloon | Red | 240
2010-09-24 00:00:00 |  | MI | Program | Program | Balloon | Red |  | 220 | 230
2010-09-25 00:00:00 |  | MI | Program | Program | Balloon | Red |  | 220 | 261
2010-09-26 00:00:00 |  | MI | Program | Program | Balloon | Red |  | 220 | 198
2010-09-26 00:00:00 | WED | MI | CHG | XYG co | Balloon | Red | 803 |  | 0
2010-09-27 00:00:00 |  | MI | Program | Program | Balloon | Red |  | 861 | 845
2010-09-28 00:00:00 |  | MI | Program | Program | Balloon | Red |  | 925 | 1325
2010-09-29 00:00:00 |  | MI | Program | Program | Balloon | Red |  | 1400 | 2012
2010-09-29 00:00:00 | SUN | MI | CHG | Sample Co 2 | Balloon | Red | 2640
2010-09-30 00:00:00 |  | MI | Program | Program | Balloon | Red |  | 2250 | 2291
2010-10-01 00:00:00 |  | MI | Program | Program | Balloon | Red |  | 2250 | 2901
2010-10-02 00:00:00 |  | MI | Program | Program | Balloon | Red |  | 2750 | 4179
2010-10-02 00:00:00 | TUE | MI | CHG | Sample Co 2 | Balloon | Red | 2880
2010-10-02 00:00:00 | WED | MI | DC | Sample Co 3 | Balloon | Red | 2160
2010-10-02 00:00:00 | WED | MI | DC | Sample Co 3 | Balloon | Blue | 480