tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__965__Gas Position 2
Sheet: Sheet1

 | Gas Positions
 | US Gas Swap | Nymex
 | term | volume | notional qty | purchase price | curent price | curve shift
 | 2002-03-01 00:00:00 | 5231250 |  |  | 2.25
 | 2002-04-01 00:00:00 | 3562500 |  |  | 2.315
 | 2002-05-01 00:00:00 | 2751250 |  |  | 2.39
 | 2002-06-01 00:00:00 | 2662500 |  |  | 2.447
 | 2002-07-01 00:00:00 | 2751250 |  |  | 2.51
 | 2002-08-01 00:00:00 | 2751250 |  |  | 2.55
 | 2002-09-01 00:00:00 | 2662500 |  |  | 2.553
 | 2002-10-01 00:00:00 | 2751250 |  |  | 2.58
Spreadsheet: 841223d1693428093-need-help-with-my-formula-returning-values-in-different-structure-sample55
Sheet: Sheet1

COMPANY NAME |  | COMPANY NAME |  |  | LIST OF COMPANYS
ABC COOKIES INC |  | ABC COOKIES INC |  |  | COMPANY NAME | ADDRESS
 |  | 456 FOREST ST |  |  | ABC COOKIES INC | 456 FOREST ST LOS ANGELES, CA 90506
 |  | LOS ANGELES, CA 90506
BILL TO |  | BILL TO |  |  | LIST OF CUSTOMERS
TOMS MARKET CO. |  | TOMS MARKET CO. |  |  | COMPANY NAME | ADDRESS
 |  | 123 LULLABY BLVD |  |  | TOMS MARKET CO. | 123 LULLABY BLVD LOS ANGELES, CA 90506
 |  | LOS ANGELES, CA 90506
Spreadsheet: 856621d1705823908-xlookup-to-direct-cell-link-with-lambda-xlookup-to-direcet-cell-reference-h
Sheet: Sheet1

 |  |  |  |  |  |  | Result Should be
 | me | 2232 |  |  | me
 | shen | 34 |  |  | shen
 | is | 3 |  |  | is
 | isini | 4 |  |  | isini
 | chven | 343 |  |  | chven
 | shen | 343
Spreadsheet: 847430d1698351658-convert-inch-fractions-to-decimal-improve-formula-inch-fraction-to-mm
Sheet: Sheet1

Inches | Jacc inch | [NAME] |  |  | CONVERTER formula
1/8"
1/4"
3/8"
1/2"
5/8"
3/4"
1"
1 1/4"
1 1/2"
2"
2 1/2"
3"
3 1/2"
4"
5"
6"
8"
10"
12"
Spreadsheet: 674295d1587747437-counting-wildcard-matches-while-subtracting-wildcard-matches-of-the-previous-rows-example1
Sheet: Sheet1

a,b |  |  | a
a,d |  |  | b
c,d,b |  |  | c
a,b,c |  |  | d
c,a
d
b
a
a
c,a,b
a,d
b,c
Spreadsheet: 881058d1728983973-ifs-or-ifs-book1
Sheet: Exercise 4

 |  | Today's Date
 |  | 2010-05-01 00:00:00
 |  | Vendor | Amount | Due Date | No of Days | Ageing
 |  | UNUM Life Insurance Company | 200 | 2010-05-31 00:00:00
 |  | ADAPT SOLUTIONS Pvt Ltd | 500 | 2010-04-30 00:00:00
 |  | Terrapin Limited | 1400 | 2010-04-24 00:00:00
 |  | Cablevision | 10000 | 2010-03-31 00:00:00
 |  | CareFirst | 250 | 2010-01-01 00:00:00
 |  | Infinet Connections | 300 | 2009-05-01 00:00:00
 |  | Pre-emptive Solutions | 1200 | 2010-06-01 00:00:00
 |  | Chase Credit Card | 3000 | 2010-02-01 00:00:00
 |  | In the above table, calculate the number of days that the AP amount is due and fill in the Ageing detail as per the below table using a formula
 |  |  |  |  | <0 | Not Yet Due
 |  |  |  |  | >0  <30 | 0 - 30
 |  |  |  |  | >30 <60 | 30 - 60
 |  |  |  |  | >60 <90 | 60 - 90
 |  |  |  |  | >90 | Greater than 90 days
Spreadsheet: 225103d1364896744-help-with-timetable-lesson-planner
Sheet: 13 LESSONS

 |  | Week | Monday | Tuesday | Wednesday | Thursday | FRIDAY
 | 2011-09-05 00:00:00 | 1
 | 2011-09-12 00:00:00 | 2
 | 2011-09-19 00:00:00 | 3
 | 2011-09-26 00:00:00 | 4
 | 2011-10-03 00:00:00 | 5
 | 2011-10-10 00:00:00 | 6
 | 2011-10-17 00:00:00 | 7
 | 2011-10-24 00:00:00
 | 2011-10-31 00:00:00 | 8
 | 2011-11-07 00:00:00 | 9
 | 2011-11-14 00:00:00 | 10
 | 2011-11-21 00:00:00 | 11
 | 2011-11-28 00:00:00 | 12
 | 2011-12-05 00:00:00 | 13
 | 2011-12-12 00:00:00 | 14
 | 2011-12-19 00:00:00
 | 2011-12-26 00:00:00
 | 2012-01-02 00:00:00 | 15
 | 2012-01-09 00:00:00 | 16
 | 2012-01-16 00:00:00 | 17
 | 2012-01-23 00:00:00 | 18
 | 2012-01-30 00:00:00 | 19
 | 2012-02-06 00:00:00 | 20
 | 2012-02-13 00:00:00
 | 2012-02-20 00:00:00 | 21
 | 2012-02-27 00:00:00 | 22
 | 2012-03-05 00:00:00 | 23
 | 2012-03-12 00:00:00 | 24
 | 2012-03-19 00:00:00 | 25
 | 2012-03-26 00:00:00 | 26
 | 2012-04-02 00:00:00
 | 2012-04-09 00:00:00
 | 2012-04-15 00:00:00 | 27 |  | MOCK PROSE |  | MOCK UNSEEN
 | 2012-04-22 00:00:00 | 28 | CLASS DISCUSSION ESSAY TITLE:  What interests and fascinates us as readers of poems and novels is that revelation of character is as likely to repel as to attract.” | CLASS DISCUSSION ESSAY TITLE: ‘What is fascinating about the various voices in poems and novels is that they often inadvertently disclose what they would prefer to conceal.’ |  | FEEDBACK LESSON – prepare presentations
 | 2012-04-29 00:00:00 | 29 | PRESENTATION GROUP 1: Victorian context (AO4) | PRESENTATION GROUP 2: Use of food and meals in both novels (AO2/4) |  | PRESENTATION GROUP 3: [NAME]’ use of Newgate and other prisons (AO4)
 | 2012-05-06 00:00:00 | 30 | BANK HOL | PRESENTATION GROUP 4: Feminist readings (AO3) |  | PRESENTATION GROUP 5: The importance of marriage in both novels (AO3/4)
 | 2012-05-13 00:00:00 | 31 | TIMED ESSAY | PRESENTATION GROUP 6: Atkinson’s development of character through footnotes (AO2) |  | PRESENTATION GROUP 7: Interpretations of men in the novels: [NAME] and [NAME]; [NAME] and [NAME] (AO2/3/4)
 | 2012-05-20 00:00:00 | 32 | CLASS DISCUSSION ESSAY TITLE: “In life, we choose to face up to challenges or to run away from them.”  Literature is at its most successful when writers depict characters facing up to life’s challenges. | FEEDBACK LESSON
 | 2012-05-27 00:00:00 | 33 | HALF TERM
 | 2012-06-03 00:00:00
 | 2012-06-10 00:00:00 | 34
 | 2012-06-17 00:00:00 | 35
 | 2012-06-24 00:00:00 | 36
 | 2012-07-01 00:00:00 | 37
 | 2012-07-08 00:00:00 | 38
 | 2012-07-15 00:00:00
 | 2012-07-22 00:00:00 | 39
Spreadsheet: 703062d1604712867-count-quantity-of-varied-documents-by-month-jpfc-bt-count-dates
Sheet: FC Insights

[NAME] by Month | July | August | September | October | November | December | January | February | March | April | May | June | Total
SOA - Full
Scoped SOA - Complex
Scoped SOA - Simple
Scoped SOA - Hold |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April
ROA - Complex |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
ROA - Simple |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
ROA - Transactional |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
ROA - Hold |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January
EO |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
Research - Simple |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
Research - Complex |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March
Current Position |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
Discovery Profile |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
Nod - ROA Hold |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
Nod - ROA Simple |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
Nod - SOA Hold
Nod - SOA Simple
Total
 | 5 | 7 | 4 | 8 | 1
 | 1 | 1 | 0 | 2 | 0
 | 6 | 2 | 5 | 0 | 1
 | 0 | 0 | 0 | 0 | 0
 | 3 | 2 | 5 | 3 | 0
 | 10 | 10 | 6 | 13 | 0
 | 16 | 13 | 10 | 17 | 0
 | 0 | 1 | 0 | 18 | 3
 | 6 | 3 | 1 | 2 | 1
 | 2 | 0 | 1 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 | 1 | 1 | 0 | 2 | 0
 |  | 0 | 0 | 5 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
Spreadsheet: 130515d1322407271-excel-2007-spin-button-realtime28-11
Sheet: Sheet1

 | Real Time Vision Usage
 | Please enter every call you take, into the calculator, in order to get an accurate real time view of your vision
 | Total Calls |  | Total Used |  | Offers made
 |  | 0 |  | 0
 | Total Usage % |  | Offers % |  | £/CALL |  | Revenue
 | Moments |  | Upgrade |  | Apple care |  | HP Single |  | Hp combi |  | Accessories
 | 0 | 5.54 | 0 | 135.28 | 0 | 10.04 | 0 | 8.6 | 0 | 17.14 | 0 | 3
 | Iphone B |  | Iphone A |  | Iphone W |  | [NAME] 10 |  | Int Favs 20 |  | Int Extras 5
 | 0 | 12 | 0 | 24 | 0 | 40 | 0 | 80 | 0 | 160 | 0 | 10
 | [NAME] |  | Bberry A |  | [NAME] |  | Int Extras 10 |  | BLANK |  | BLANK
 | 0 | 12 | 0 | 24 | 0 | 40 | 0 | 20 | 0 | 0 | 0 | 0
 | Smart B |  | Smart A |  | Smart W |  | Spain |  | Europe |  | Travel Ins
 | 0 | 12 | 0 | 24 | 0 | 40 | 0 | 13.62 | 0 | 27.23 | 0 | 3.93
 | HBB Resign |  | HBB LLU |  | HBB Access |  | MBB |  | Direct Debit |  | PAYM New
 | 0 | 19.4 | 0 | 19.4 | 0 | 33.95 | 0 | 38.81 | 0 | 2.58 | 0 | 135.28
 | Home phone |  | HP Anytime |  | HP eve/week
 | 0 | 25.2 | 0 | 28.8 | 0 | 12
 | Designed by [NAME]
Spreadsheet: 648480d1573061003-add-arrows-whenvalue-of-cell-changes-book1
Sheet: Sheet1

16 | 12
15 | 5
10 | 6
3 | 2
6 | 3
6 | 3
5 | 1
Spreadsheet: 218199d1362398159-comibining-2-averageif-formula-book7
Sheet: Template

Mean Of Importance |  |  |  | Gender | Age
 |  | Total | 45-54
Spreadsheet: 683225d1592566827-time-card-calculation-time_card2c
Sheet: Flex Employee

Employee: |  |  |  |  |  |  |  |  |  |  | Year | 2020 |  |  |  |  |  |  |  |  |  |  |  |  | OPTIONS |  | OVERTIME OPTIONS
Employee Number: |  |  |  |  |  |  |  |  |  |  | Month |  |  |  |  |  |  | Su | M | [NAME] | W | Th | F | Sa | YES | DAILY | YES
Cost Center: |  |  |  | DEPT. # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | AFTER | 8 | HRS
SUPERVISOR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BREAK TIME | WEEKLY | YES
WEEK STARTING: | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | AFTER | 40 | HRS
WEEK ENDING: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
Day of Week | Time In | Time In 2 | [NAME] (minutes) | Time Out | Time Out 2 | Total Hours hide | Total Hours | Regular Hours hide | Regular Hours | Overtime | Overtime | Sick Time Hrs | Sick Time Hrs. hide | Holiday Hrs. | Holiday Hrs. hide | Vacation Hrs. | Vacation Hrs. hide |  |  |  |  |  |  |  | 45
 |  | hidden |  |  | hidden |  |  |  |  | Hours hide | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 | 0700 |  | 30 | 1530
 | 0700 |  | 30 | 1537
 | 0700 |  | 30 | 1555
 |  |  |  | Total  Hrs.
 |  |  |  | Total  Hrs.
TOTAL HOURS WORKED: |  |  |  | Biweekly Total  Hrs.
Grand Total Pay: |  |  |  |  |  |  | Rate / Hour: |  | 52
Grand Total Pay w/ Shift Differential: |  |  |  |  |  |  | Total Pay:
Spreadsheet: 883601d1732222824-making-an-automatic-on-call-board-recreation-of-the-on-call-board-automatic-2025
Sheet: April

 | April
 |  | 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
 | [NAME]
 | [NAME]
 | Romo
 | [NAME]
 | Orlando
 | Nick
 | [NAME]
 | Zach
 | Pando
 | [NAME]
 | Art
 | Manuel
 | [NAME]
Spreadsheet: 398ec275-4f92-46b4-89a5-a59a12cf7019
Sheet: New Table 9

Weekly Barge Rates for Major Grain Shipping Points on the Mississippi, Ohio, and Arkansas Rivers
Table 9
Weekly Barge Freight Rates:  Southbound Only
 |  | Twin         Cities | Mid-Mississippi | Lower Illinois         River | St. Louis | Cincinnati | Lower         Ohio | Cairo-Memphis
Rate1 | 2014-08-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  | -
$[NAME]
 |  | -
Current week % change from the same week:
 | Last year
 | 3-year avg. 2
Rate1 | September
 | November
1Rate = percent of 1976 tariff benchmark index (1976 = 100 percent); 24-week moving average; ton = 2,000 pounds;
Source:  Transportation & Marketing Programs/AMS/USDA
 |  | TWC | MM | ILL | ST LOUIS |  | LOH | CAR-MEM
[NAME] |  | 6.19 | 5.32 | 4.64 | 3.99 | 4.69 | 4.04 | 3.14
Spreadsheet: 66277d1266968996-excel-2007-assigning-a-label-to-an-item-and-then-totalling-mogul-expense-capital
Sheet: January 2010

FEDERAL MOGUL MCC - MONTHLY TIMESHEET
JANUARY 2010
 | CATEGORY | % ALLOCATED |  | RESOURCE NAME | AMOUNT
1 | Functional Specification Development | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Functional Specification Development |  |  |  | C
 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (GFD) Modifications |  |  |  | C
 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SIMATIC IT Knowledge Transfer to F-M |  |  |  | E
 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Support for Estimating & SOW |  |  |  | E
 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Release / Change Management |  |  |  | E
 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Readiness |  |  |  | E
 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Specification Modification |  |  |  | C
 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Standards Development |  |  |  | E
 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Technical Specification Development |  |  |  | C
 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Travel |  |  |  | E
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 | TOTALS
 | http://www.excelforum.com/
Spreadsheet: 779449d1651782396-formula-to-subtact-1st-piece-of-data-in-a-sting-from-last-in-each-data-set-data-string-help
Sheet: Sheet1

Data Set | Answer Im after
150.970001
149.460007 |  |  | Im wanting to subtract the first value in a string from the last bit of data in the string
150.619995 |  |  | Strings vary in length
152.550003 |  |  | The gaps between the strings vary as well
155.089996
152.679993
154.479996
152.229996
153.710007
153.619995
150.190002
150.559998
151.25
152.229996
160.690002
161.240005
161.220001
158.539993
157.449997
161.5
164.009995
164.669998
162.350006
161.110001
160.830002
162.660004
163.539993
161.850006
149.710007
152.860001
150.929993
150.639999
151.649994
160.440002
159.949997
159.720001
160.460007
159.490005
159.210007
158.5
159.190002
157.360001
159.860001
157.070007
158.160004
158.089996
157.679993
152.960007
152.979996
155.910004
161.179993
163.039993
166.979996
166.080002
165.949997
163.690002
167.130005
145.080002
144.949997
146.529999
147.919998
145.309998
146.610001
148.600006
151.149994
149.940002
148.699997
152.559998
153.070007
155.949997
156.600006
155.949997
153.919998
152.490005
154.720001
155
151.429993
152.139999
151.869995
148.690002
144.550003
147.970001
141.800003
136.449997
139.279999
138.289993
134.399994
129.210007
128.300003
133.440002
131.860001
128.889999
130.169998
132.479996
138.399994
140.149994
140.100006
139.649994
Spreadsheet: bd0bce3a-0219-445f-a34c-168c923e08c3
Sheet: Sheet1

State [NAME] (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Downloaded at 9/14/2014 9:00:20 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 102886
2008 Primary Election - OFFICIAL RESULTS
District | [NAME] | [NAME] | [NAME] | Whitney Hauz | TOTALS
District 02 | 1 | 0 | 0 | 0 | 1
District 03 | 0 | 0 | 0 | 0 | 0
District 04 | 0 | 0 | 0 | 0 | 0
District 05 | 0 | 1 | 0 | 0 | 1
District 06 | 0 | 0 | 0 | 0 | 0
District 11 | 0 | 0 | 0 | 0 | 0
District 13 | 0 | 0 | 0 | 0 | 0
District 20 | 0 | 0 | 0 | 0 | 0
District 21 | 0 | 0 | 0 | 0 | 0
District 22 | 0 | 0 | 0 | 0 | 0
District 27 | 0 | 0 | 0 | 0 | 0
District 36 | 0 | 0 | 0 | 0 | 0
District 37 | 0 | 0 | 0 | 0 | 0
District 38 | 0 | 0 | 0 | 0 | 0
District 40 | 0 | 0 | 0 | 0 | 0
District 41 | 0 | 0 | 0 | 0 | 0
District 44 | 1 | 0 | 1 | 1 | 3
District 45 | 0 | 0 | 1 | 0 | 1
District 46 | 0 | 0 | 0 | 0 | 0
TOTAL | 2 | 1 | 2 | 1 | 6
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 791726d1660566233-pay-as-you-earn-calculation-paye-calculator-hd1
Sheet: Sheet1

Tax start period | 2021-07-01 00:00:00 | 2021-07-01 00:00:00
Tax end period | 2022-06-30 00:00:00 | 2022-06-30 00:00:00
Gross earnings | 123000 | 345000
Pension fund (Tax Deductible | 1755 | 1755
Taxable pay
Annual Tax rebate (not more than 60 years of ages | 8200 | 8200
Annual Tax rebate (more than 60 years of ages | 10900 | 10900
The rates of Income Tax applicable are as follows:
RATES OF NORMAL TAX FOR INDIVIDUALS
Exceeds | Does not exceed
Taxable Income |  |  |  | Rates
0 | 100000 | 0 | 0.2 | E0           +  20% of the excess of E0 00
100000 | 150000 | 20000 | 0.25 | E20 000 + 25% of the excess of E100 000
150000 | 200000 | 32500 | 0.3 | E32 500 + 30% of the excess of E150 000
200000 |  | 47500 | 0.33 | E47 500 + 33% of the excess of E200 000
 | not more than 60 years | more than 60 years
Tac pro year
Taks pro month
Spreadsheet: andy_zipper__269__Broker detail 6-1-01
Sheet: FAILED DEALS SUMMARY

Failed Transactions:
LIFE TO DATE
FAILED TRANSACTION COUNT |  | Commodity
Broker | Failed Reason | Natural Gas | Power | Grand Total
APB Energy, Inc. | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no bid access to product | 1 | 9 | 10
 | [NAME]: counterparty has no offer access to product |  | 3 | 3
 | FAILURE: Limit price violated |  | 13 | 13
 | [NAME]: product violates counterparty term limit | 2 |  | 2
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 6 |  | 6
 | FAILURE: Volume not available for base product of hedge | 1 |  | 1
 | FAILURE: Order pended due to limit price violation | 25 | 4 | 29
APB Energy, Inc. Total |  | 36 | 29 | 65
Natsource LLC | FAILURE: counterparty exceeded credit limit | 2 | 5 | 7
 | [NAME]: counterparty has no bid access to product | 1 | 4 | 5
 | [NAME]: counterparty has no offer access to product |  | 5 | 5
 | FAILURE: Limit price violated | 1 | 13 | 14
 | [NAME]: product violates counterparty term limit |  | 3 | 3
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 1 | 9 | 10
 | FAILURE: Base product not active for hedge | 1 |  | 1
Natsource LLC Total |  | 6 | 39 | 45
Power Merchants Group, LLC | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no offer access to product | 2 |  | 2
 | FAILURE: Limit price violated | 10 |  | 10
 | [NAME]: product violates counterparty term limit | 1 |  | 1
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 3 |  | 3
 | FAILURE: Order pended due to limit price violation | 3 |  | 3
Power Merchants Group, LLC Total |  | 20 |  | 20
Amerex Natural Gas I, Ltd. | FAILURE: Limit price violated | 2 |  | 2
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 4 |  | 4
Amerex Natural Gas I, Ltd. Total |  | 6 |  | 6
Amerex Power, Ltd. | [NAME]: counterparty has no bid access to product |  | 5 | 5
 | FAILURE: Limit price violated |  | 1 | 1
 | [NAME]: product violates counterparty term limit |  | 2 | 2
 | [NAME]: counterparty has no access to product |  | 1 | 1
Amerex Power, Ltd. Total |  |  | 9 | 9
Prebon Energy, Inc. | FAILURE: Order pended due to limit price violation | 1 |  | 1
Prebon Energy, Inc. Total |  | 1 |  | 1
Grand Total |  | 69 | 77 | 146
Spreadsheet: 707515d1607331307-using-a-list-to-reduce-worksheets-midshires-master
Sheet: SC

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 377323d1423895843-tricky-problem-trying-to-find-data-in-the-furthest-right-cell-excel-question
Sheet: Simple

Full Name | Assessment 1 | Assessment 2 | Assessment 3 | Assessment 4 | Assessment 5 | Assessment 6 | Most Recent Assessment
Student 1 |  | 5b | 6c
Student 2 |  | 5B | 5B
Student 3 |  | 5A | 5A |  | 6C
Student 4 |  | 6B | 6B |  | 7B
Student 5 |  | 6B | 6B
Student 6 |  | 6B | 6B
Student 7 |  | 5B | 5B | 6C
Student 8 |  | 5C | 5C
Student 9 |  | 5A | 5A
Student 10 |  | 5B | 5B
Spreadsheet: 760664d1640370693-find-last-non-0-cell-in-table-and-do-some-calculations-how
Sheet: Blad1

 |  | datum | wissel | [NAME]
 |  | 2021-12-24 00:00:00 | 0 | 5
 |  | 2021-12-24 01:00:00 | 0 | 6
 |  | 2021-12-24 01:59:59.990000 | 0 | 3
 |  | 2021-12-24 02:59:59.985000 | 0 | 6
 |  | 2021-12-24 03:59:59.980000 | 0 | 3
 |  | 2021-12-24 04:59:59.975000 | 0 | 5
 |  | 2021-12-24 05:59:59.970000 | 0 | 9 |  |  | List is growing
 |  | 2021-12-24 06:59:59.965000 | 0 | 8 |  |  | Date of wissel from button up
 |  | 2021-12-24 07:59:59.960000 | 0 | 5 |  |  | kg from wissel til last cell
 |  | 2021-12-24 08:59:59.955000 | wissel | 6
 |  | 2021-12-24 09:59:59.950000 | 0 | 9
 |  | 2021-12-24 10:59:59.945000 | 0 | 3
 |  | 2021-12-24 11:59:59.940000 | 0 | 6
 |  | 2021-12-24 12:59:59.935000 | 0 | 9
 |  | 2021-12-24 13:59:59.930000 | 0 | 4
 |  | 2021-12-24 14:59:59.925000 | 0 | 1
 |  | 2021-12-24 15:59:59.920000 | 0 | 4
 |  | 2021-12-24 16:59:59.915000 | 0 | 5
 |  | 2021-12-24 17:59:59.910000 | 0 | 6
 |  | 2021-12-24 18:59:59.905000 | 0 | 5
 |  | 2021-12-24 19:59:59.900000 | 0 | 4
 |  | 2021-12-24 20:59:59.895000 | 0 | 8
 |  | 2021-12-24 21:59:59.890000 | 0 | 7
Spreadsheet: 453833d1459460310-formula-if-cell-3-is-blank-have-cell-1-calculate-if-cell-3-filled-have-cell-2-calculate-example_testing_etaf
Sheet: Sheet1

 | Days in Shop
 | MARK | NUMBER | Program? | Scheduled | [NAME] | COMMENTS | PID# | uncompleted | completed | Notification
1 | TILX | 270247 |  | 2016-02-10 00:00:00 | 2016-02-04 00:00:00 | [NAME] | 2411C |  |  | 2016-04-01 00:00:00
2 | TILX | 195917 |  |  | 2016-02-09 00:00:00 | [NAME] | 2726A
3 | TILX | 270275 |  |  | 2016-02-11 00:00:00 | [NAME] | 2411C |  |  | 2016-04-08 00:00:00
 | Currently column I(uncompleted) calculates days between current date and whichever date is later between columns E(Scheduled) and F(Arrived). I would like column I(uncompleted) to continue doing this unless there is a date in column K(Notification).  Once there is a Date in column K(Notification) I would like column I(uncompleted) to become blank and then I would like column J(completed) to calculate days between column K(Notification) and the later date between Columns E(Scheduled) and F(Arrived).
Spreadsheet: dan_hyvl__4897__ALAGASCO
Sheet: Sheet1

K# | K Type (Global) | K Title | K Date | Term Start | Term End | MDQ | MISC | Status
96029227 | Master Sale Firm & Spot | Natural Gas Sales Term Agreement | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 2000-11-30 00:00:00 | 20,000/Day | Demand Fee ($180,000.00/yr escalated 5% each yr after 12/1/91) | Pending termination per CP notice (Suspended to prevent future deals from attaching)
96029226 | Master Sale Firm & Spot | Natural Gas Sales Term Agreement | 1992-11-01 00:00:00 | 1992-11-01 00:00:00 | 2002-10-31 00:00:00 | 10,000/Day | Demand Fee ($15,250.00/month escalated 5% each yr after 11/1/93) | Active (Suspended to prevent future deals from attaching)
96029224 | Master Sale Firm & Spot | Natural Gas Sales Term Agreement | 1991-11-01 00:00:00 | 1991-11-01 00:00:00 | 2001-10-31 00:00:00 | 5,216/Day | Demand Fee ($58,460.00/yr escalated 5% each yr after 11/1/92) | Active (Suspended to prevent future deals from attaching)
96029223 | Master Sale Firm & Spot | Natural Gas Sales Term Agreement | 1991-01-01 00:00:00 | 1991-01-01 00:00:00 | 2000-12-31 00:00:00 | 20,000/Day | Demand Fee ($360,000.00/yr escalated 5% each yr after 1/1/92) | Pending termination per CP notice (Suspended to prevent future deals from attaching)
OUTSTANDING DEALS
Deal # | [NAME] | Daily Volume | Demand Fee |  |  | Misc Notes | K linked to in Sitara | Correct K
242653 | 8/1/00 - 3/31/01 | 10,000/Day (8/1/00 - 10/31/00) | No Demand Fees noted on deal |  |  |  | 96029223 |  | To be moved to new Enfolio with letter from CP
 |  | 15,000/Day (11/1/00 - 3/31/01)
250042 | 5/1/00 - 12/31/00 | 24,471/Day | Demand Fee |  |  | Noted as a CES deal | 96029223 | 96029223 | Volume should be 20,471 MMBTu/Day
250050 | 5/1/00 - 11/30/00 | 10,000/Day | Demand Fee |  |  | Noted as a CES deal | 96029223 | 96029227
250196 | 5/1/00 - 10/31/01 | 10,000/Day | Demand Fee |  |  | Noted as a CES deal | 96029223 | 96029224 | Volume to be editted to 5216 MMBTu/Day
271301 | 6/01/00 - 3/31/01 | 10,000/Day | No Demand Fees noted on deal |  |  |  | 96029226 |  | To be moved to new Enfolio with letter from CP
Spreadsheet: 70419d1271175539-excel-2007-holiday-planner-auto-update-paul-cooksey
Sheet: Sheet1

 |  |  |  |  |  | Employee Holiday
 |  |  |  |  |  | Record Form
Holiday year: 2010-2011 |  |  |  |  |  | Start Date:
Day Number: |  | Date Taken: |  | Day Number: |  | Date Taken:
 |  |  |  |  |  |  |  | Name
1 |  |  |  | 15
 |  |  |  |  |  |  |  | [NAME]
2 |  |  |  | 16
3 |  |  |  | 17
4 |  |  |  | 18
5 |  |  |  | 19
6 |  |  |  | 20
7 |  |  |  | 21 BH
8 |  |  |  | 22 BH
9 |  |  |  | 23 BH
10 |  |  |  | 24 BH
11 |  |  |  | 25 BH
12 |  |  |  | 26 BH
13 |  |  |  | 27 BH
14 |  |  |  | 28 BH