tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 28080d1221926549-transfering-data-to-new-source-copy-of-transferring-crystal-to-excel
Sheet: Sheet1

Time | Ntr
1900-01-01 00:00:00 | 3
00:15:00 | 1
00:30:00 | 1 |  |  |  |  |  | 1
00:45:00 | 2 |  | sum of b2:[NAME]
01:00:00 | 1 |  | 7
02:00:00 | 3
03:00:00 | 1 |  | This counts as an entire hour. The issue is (if you look at 2am-3am) there is only
03:15:00 | 1 |  | one entry for the hour. I am trying to sum up everything at hourly time periods, so
04:00:00 | 1 |  | I'm wondering if I could make it do a search of times (2:00,2:15, 2:30, 2:45) first -
04:15:00 | 1 |  | then give me the results of those cells. So it would look like this
04:30:00 | 1
05:15:00 | 1 |  | 7 | 1 | 3 | 2
05:30:00 | 1 |  | 1900-01-01 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00
05:45:00 | 1
06:00:00 | 1
07:00:00 | 2
07:30:00 | 2
07:45:00 | 1
08:00:00 | 3
08:15:00 | 4
08:30:00 | 3
08:45:00 | 6
09:00:00 | 3
09:15:00 | 6
09:30:00 | 10
09:45:00 | 5
10:00:00 | 5
10:15:00 | 3
10:30:00 | 2
10:45:00 | 4
11:00:00 | 2
11:15:00 | 2
11:30:00 | 1
11:45:00 | 4
12:00:00 | 2
12:15:00 | 3
12:30:00 | 5
12:45:00 | 5
13:00:00 | 3 |  |  | 1
13:15:00 | 4
13:30:00 | 4
13:45:00 | 3
14:00:00 | 5
14:15:00 | 5
14:30:00 | 3
14:45:00 | 3
15:00:00 | 8
15:15:00 | 5
15:30:00 | 9
15:45:00 | 13
16:00:00 | 5
16:15:00 | 3
16:30:00 | 5
16:45:00 | 1
17:00:00 | 3
17:15:00 | 7
17:30:00 | 3
17:45:00 | 5
18:00:00 | 1
18:15:00 | 1
18:45:00 | 3
19:00:00 | 3
19:15:00 | 2
19:30:00 | 2
19:45:00 | 2
20:00:00 | 5
20:30:00 | 6
20:45:00 | 1
21:00:00 | 2
21:15:00 | 1
21:30:00 | 1
22:00:00 | 3
22:15:00 | 2
22:45:00 | 3
23:00:00 | 1
23:15:00 | 3
23:30:00 | 4
Spreadsheet: 349202d1412248217-hyperlinks-to-filtered-data-example
Sheet: Link

Name | Value
a | 4
a | 8
b | 5
c | 6
a | 3
c | 6
b | 4
c | 6
a | 7
c | 2
c | 5
a | 3
c | 8
c | 5
b | 1
b | 4
b | 1
b | 2
c | 7
c | 1
a | 2
c | 6
a | 9
c | 7
b | 5
c | 4
Spreadsheet: 76335d1276847733-how-do-i-return-value-i-want-test
Sheet: Sheet2

ID | Action | DateTime | Comment
1 | Comment | 2010-06-09 09:07:26 | [NAME]
4 | [NAME] | 2010-05-28 11:18:01
2 | Comment | 2010-05-25 13:06:34 | [NAME]
5 | [NAME] | 2010-05-25 13:07:29
1 | Area Move | 2010-04-26 14:09:43
6 | Area Move | 2010-05-18 10:54:27
7 | Area Move | 2010-05-05 13:40:42
9 | Area Move | 2010-03-02 15:03:35
3 | Area Move | 2010-03-02 15:03:10
10 | Area Move | 2010-05-28 14:37:49
1 | Area Move | 2010-06-10 09:37:23
5 | [NAME] | 2010-04-19 12:44:38
6 | Area Move | 2010-06-14 13:48:40
6 | Area Move | 2010-05-10 12:24:26
8 | Area Move | 2010-06-03 13:48:47
8 | [NAME] | 2010-05-20 15:34:10
9 | [NAME] | 2010-03-23 09:54:40
3 | [NAME] | 2010-06-11 08:05:13
5 | [NAME] | 2010-05-18 16:11:59
6 | Area Move | 2010-03-15 11:00:05
1 | Comment | 2010-05-04 09:12:12 | [NAME]
2 | Area Move | 2010-03-30 14:40:17
5 | [NAME] | 2010-04-22 09:55:24
3 | [NAME] | 2010-06-14 09:45:18
2 | [NAME] | 2010-04-19 10:02:50
8 | Area Move | 2010-04-09 09:20:30
7 | Comment | 2010-06-14 13:35:32 | [NAME]
1 | Comment | 2010-06-14 13:37:32 | Test Comment
Spreadsheet: 54923d1254966399-excel-2007-count-highlighted-cells-temp
Sheet: WK 5

Favorite | Spread | Underdog |  |  | ROY JR | CARLOS
SUNDAY
MIN | 10.5 | STL |  |  | MIN
DAL | 8.5 | KC |  |  | DAL
CAR | 3.5 | WSH |  |  | WSH
PHI | 13.5 | TB |  |  | PHI
NYG | 15.5 | OAK |  |  | NYG
BUF | 6 | CLE |  |  | CLE
BAL | 8.5 | CIN |  |  | CIN
PIT | 10.5 | DET |  |  | PIT
49R | 2.5 | ATL |  |  | ATL
NEP | 3.5 | DEN |  |  | DEN
AZ | 5.5 | HOU |  |  | HOU
JAX | 3.5 | SEA |  |  | SEA
IND | 4 | TEN |  |  | IND
Monday
NYJ | 1.5 | MIA |  |  | NYJ
Tie Breaker Points |  |  |  |  | 34
Please Hand in your picks before Friday If you don't pay by Friday don't expect to be a winner Tuesday.
Spreadsheet: 121b66e9-db4f-4a3c-aeee-2152db8d79f2
Sheet: 7

 | Dec 28 | Jan 4 | Jan 11 | Jan 18 | Jan 25
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap dollar volumes by asset class and cleared status (value of all trades in millions of USD), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 0166c94d-0129-4730-a113-fd63e3513471
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | K-State Research & Extension
2011-11-14 00:00:00 | Budget Data for Fiscal Year 2012
file:c\2012\budget data FY12.xls
 |  | Amount | Percent |  | FTE's
Agricultural Experiment Station
State Appropriation |  | 30050379 | 0.3838 |  | 337.20079
Federal Appropriation (Hatch, RRF, [NAME]) |  | 4088000 | 0.0522 |  | 68.28200000000001
Main Campus Allocation |  | 2815497 | 0.036 |  | 14.92469
Grants, Contract, Other Funds |  | 41332451 | 0.528 |  | 169.84883
Total Agricultural Experiment Station |  | 78286327 | 1 |  | 590.25631
Cooperative Extension
State Appropriation |  | 18600461 | 0.5074 |  | 240.50153
Federal Appropriation (3b&c, Special Needs) |  | 5350000 | 0.146 |  | 39.95204
Main Campus Allocation |  | 1718666 | 0.0469 |  | 12.28117
Grants, Contract, Other Funds |  | 10986668 | 0.2997 |  | 144.18456
Total State & Federal Budget |  | 36655795 | 1 |  | 436.9193
Funds Provided by Counties\Districts
Agent Salary & Benefits |  | 11642317 | 0.5142 |  | 173.49315
Office Professional Salary & Benefits |  | 5500000 | 0.2429 |  | 0
Operating Support |  | 5500000 | 0.2429 |  | 0
Total County Budget |  | 22642317 | 1 |  | 173.49315
Total Cooperative Extension |  | 59298112 |  |  | 610.41245
Total K-State Research & Extension |  | 137584439 |  |  | 1200.66876
K-State Research & Extension
Combined FY 2011 Budget
State Appropriation (AES & CES) |  | 48650840 | 0.4233 |  | 577.70232
Federal Appropriation (AES\CES) |  | 9438000 | 0.0821 |  | 108.23404
Main Campus Allocation |  | 4534163 | 0.0394 |  | 27.20586
Subtotal General-Use Funds |  | 62623003 | 0.5448000000000001 |  | 713.1422200000001
Grants & Services |  | 52319119 | 0.4552 |  | 314.0333899999999
Total State & Federal Budget |  | 114942122 | 1 |  | 1027.17561
Funds Provided by Counties\Districts
Agent Salary & Benefits |  | 11642317 | 0.5142 |  | 173.49315
Clerical Support |  | 5500000 | 0.2429 |  | 0
Operating Support |  | 5500000 | 0.2429 |  | 0
Total County Budget |  | 22642317 | 1 |  | 173.49315
Total K-State Research & Extension |  | 137584439 |  |  | 1200.66876
Budget by Classification |  | Amount | Percent |  | FTE's
General-Use State and Federal Fund
Faculty & Administrative Salaries & Benefits |  | 45834151 | 0.7319 |  | 541.71022
Classified & Student Salaries & Benefits |  | 9191815 | 0.1468 |  | 171.432
Operating Expenditures |  | 7597037 | 0.1213 |  | 0
Total General-Use State and Federal Fund |  | 62623003 | 1 |  | 713.1422200000001
Spreadsheet: 23c6ca8d-c7a8-4c98-93c7-d6ab9371a31c
Sheet: Dates Times

Start Date | End Date | Number of Days
29452 | 2009-03-19 00:00:00
35435 | 2007-12-31 00:00:00
Start Time | End Time | Total Hours
08:00:00 | 17:00:00
09:15:00 | 18:30:00
07:35:00 | 16:55:00
Start Time | [NAME] | Lunch End | End | Total Hours
08:00:00 | 12:00:00 | 13:00:00 | 17:00:00
07:30:00 | 12:00:00 | 13:00:00 | 16:00:00
08:15:00 | 11:30:00 | 14:00:00 | 17:00:00
08:00:00 | 11:30:00 | 13:10:00 | 16:30:00
Spreadsheet: 734426d1622147975-conditional-formatting-and-color-cells-with-formula-kopieplanning
Sheet: vlist 

project | datum | Vertrek | Aankomst | begeleider | tijd | weg | wacht | uren | km | land | verkoop | Wacht2 | inkoop | [NAME] | Wacht3 |  | Verschil alles | prijs nl | prijs d | [NAME] <50 | km NL 50-100 | [NAME]500 | [NAME]50 | km d 50-100 | km d 100-500 | km d >500 | Wacht
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42.5 | 1.15 | 150 | 2.8 | 1.8 | 300 | 4.5 | 1.65 | 1.3 | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5259
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | als J=nl;I:I | als J=nl; K:K | als J=d;I:I | als J=d:K:K | wacht
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5235
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal
Spreadsheet: 224057d1364424771-updating-subsequent-rows-on-a-different-sheet-example-1
Sheet: Sheet2

Date | Time | Issue | Agent | Response | Date completed | Time completed
2013-03-23 00:00:00 | 09:44:00 | Unable to solve problem | [NAME] | Doctor called | 2013-03-23 00:00:00 | 10:23:00
2013-03-23 00:00:00 | 09:50:00 | black eye | Greg | 1st aid | 2013-03-23 00:00:00 | 10:45:00
2013-03-23 00:00:00 | 10:14:00 | broken toe | Teigan | 1st aid | 2013-03-23 00:00:00 | 13:40:00
2013-03-24 00:00:00 | 08:36:00 | bruised hip | [NAME] | Pain killer administered | 2013-03-24 00:00:00 | 09:00:00
2013-03-25 00:00:00 | 14:22:00 | ingrown toenail | [NAME] | Doctor called | 2013-03-25 00:00:00 | 18:35:00
2013-03-26 00:00:00 | 12:01:00 | psoriasis | [NAME] | Doctor called | 2013-03-26 00:00:00 | 12:15:00
2013-03-26 00:00:00 | 18:30:00 | scar tissue | Greg | Doctor called | 2013-03-26 00:00:00 | 19:00:00
2013-03-27 00:00:00 | 11:23:00 | liver spots | Greg | consultant discussion | 2013-03-27 00:00:00 | 11:30:00
2013-03-28 00:00:00 | 13:52:00 | possible cancer | Greg | Doctor called | 2013-03-29 00:00:00 | 04:00:00
Spreadsheet: 29747222-1c16-4c39-8fec-d36d57194b30
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7560 | 56992 | Soile | Koskela | FIN | 0 | 00:20:56 | 00:00:49 | 00:37:35 | 00:01:25 | 00:21:55 | 1 | 01:22:44
Spreadsheet: 125587d1319116771-excel-2007-vlookup-and-sum-forum
Sheet: Total

Food | Total |  |  |  | What I am looking for
 |  |  |  |  | Food | Total
 |  |  |  |  | Chicken | 40
 |  |  |  |  | Beef | 20
 |  |  |  |  | Pork | 20
 |  |  |  |  | Lamb | 18
 |  |  |  |  | Salad | 5
 | How would I automatically determine the names in common between the two tabs named [NAME] and Dinner and Get the total of the orders from the Dinner and [NAME] tab for each food item . Also if the name is not common it also appears on the Total List with the food total order.
Spreadsheet: chris_germany__2914__02 2000 GELP OIL BY VENDOR
Sheet: GELP OIL DELIVERY SHEET #2

GELP #2 FUEL OIL RECEIPTS FOR THE MONTH
Delivery Date | Beginning Flow counter reading | Ending Flow counter reading | Plant Recorded Delivery |  | BP AMOCO       Quantity on B/L-Gross | Marathon Ashland Quantity on B/L-Gross | CITGO Quantity on B/L-Gross | B/L #
 |  |  | Due from previous sheet
 |  |  | Any additional ordered | 0 | (ordered on the 19th)
 |  |  | TOTAL DELIVERED
 |  |  | OWED TO GELP/ (OVER DELIVERED)
Spreadsheet: 830080d1684682257-need-help-with-index-match-indexmatch-v2
Sheet: 10May2023

Item Number | Item Description | QTY To Order | Last PO Vendor | Vendor Part #
01914265 | Vial, [NAME], 2mL/1.8mL 12x32mm | 3 CS/12 | Fisher Scientific | 03-377B
01-914-265 | Decon CiDehol ST Sterile Isopropyl Alcohol 32 oz | 1 CS/12 | Fisher Scientific | 04-355-85
02-003-656 | Tip, 100-5000 Bulk, 5 bags of 100 | 5 PK/5 | Fisher Scientific | 05-403-62
Spreadsheet: 583228d1532331848-count-by-column-entry-countif
Sheet: Sheet1

Account | Orders | Order lines |  |  |  | Customer Code | [NAME]. | [NAME] lines
102121 | 10949773 | 1 |  |  |  | 102121 | 3 | 6
102121 | 10949773 | 1 |  |  |  | 102132 | 1 | 1
102121 | 10949773 | 1 |  |  |  | 102156 | 2 | 8
102121 | 10965209 | 1 |  |  |  | 800697 | 2 | 8
102121 | 10965209 | 1
102121 | 10982622 | 1
102132 | 10945883 | 1
102156 | 10941989 | 1
102156 | 10941989 | 1
102156 | 10941989 | 1
102156 | 10941989 | 1
102156 | 10941989 | 1
102156 | 10941989 | 1
102156 | 10941989 | 1
102156 | 10943000 | 1
800697 | 21655829 | 1
800697 | 21655829 | 1
800697 | 21655829 | 1
800697 | 21655829 | 1
800697 | 21655829 | 1
800697 | 21655829 | 1
800697 | 21656664 | 1
800697 | 21656664 | 1
BEFORE |  |  |  |  |  | AFTER
Spreadsheet: 0277b763-c3da-4605-bb90-31670a24bf45
Sheet: Sheet1

Evaluation Criteria | Evaluation Scores | VENDOR 1 | Unnamed: 3 | VENDOR 2 | Unnamed: 5 | VENDOR 3 | Unnamed: 7
 | Quantitative Points | [NAME] |  | Horizon Surface Systems |  | Marathon Engineering
 | Price Method I
A1 | GRAND TOTAL I | 359982 |  | 262782 |  | 371463
 | PERCENTAGE/ POINTS | 0.37 | 25 | 0 | 40 | 0.41 | 22.5
C1 | TIME OF COMPLETION I | 41 Days | 24 | 36 Days | 29 | 35.5 Days | 30
 | I QUANTITATIVE POINTS | 49 |  | 69 |  | 52.5
 | Price Method II
A2 | GRAND TOTAL II | 332442 |  | 265231 |  | 269029
 | PERCENTAGE/ POINTS | 0.25 | 27.5 | 0 | 40 | 0.01 | 37.5
C2 | TIME OF COMPLETION II Days/ Pts | 39 Days | 27 | 32 Days | 30 | 32 Days | 30
 | II  QUANTITATIVE POINTS | 54.5 |  | 70 |  | 67.5
 | Price Method III
A3 | GRAND TOTAL III | 366629 |  | 297937 |  | 371463
 | PERCENTAGE/ POINTS | 0.23 | 27.5 | 0 | 40 | 25 | 27.5
[NAME] | TIME OF COMPLETION III | 45 Days | 20 | 40 Days | 25 | 35.5 Days | 30
 | III QUANTITATIVE POINTS | 47.5 |  | 65 |  | 57.5
 | SUB TOTAL A + C                                                  Three price method points combined | 151 |  | 204 |  | 177.5
 | Evaluators submitted a score for each pricing method above.
 | EVALUATOR I | 16 |  | 6 |  | 29
B |  | 19 |  | 10 |  | 29
 |  | 21 |  | 12 |  | 29
 | EVALUATOR II | 20 |  | 7 |  | 28
B |  | 20 |  | 10 |  | 28
 |  | 24 |  | 12 |  | 28
 | EVALUATOR III | 18 |  | 6 |  | 30
B |  | 24 |  | 8 |  | 30
 |  | 24 |  | 14 |  | 30
 | TOTAL SCORE A, B, C | 289 |  | 267 |  | 378.5
Spreadsheet: 472302d1469536446-validate-month-consistent-book1
Sheet: Sheet1

ENTITY_ID | ACTIVITY_DATE | Consistency
80001872 | 05-JAN-11 | 0
80001872 | 14-FEB-11 | 0 |  | There is a consistent between previous month to this month therefore this is counted as "1"
80001872 | 11-MAR-11 | 0
80001872 | 13-APR-11 | 0
80001872 | 01-JUN-11 | 1 |  | There is no Activity date for May 2011 therefore there is no consistency and it is counted as "1"
80001872 | 12-JUL-11 | 0
80001872 | 19-AUG-11 | 0
80001872 | 20-SEP-11 | 0
80001872 | 25-OCT-11 | 0
80001872 | 09-DEC-11 | 1 |  | There is no Activity date for May 2011 therefore there is no consistency and it is counted as "1"
80001872 | 20-JAN-12 | 0
80001872 | 15-MAR-12 | 1 |  | There is no Activity date for May 2011 therefore there is no consistency and it is counted as "1"
80001872 | 17-APR-12 | 0
80001872 | 16-MAY-12 | 0
80001872 | 02-JUN-12 | 0
80001872 | 28-JUN-12 | 0
80001872 | 09-AUG-12 | 1 |  | There is no Activity date for May 2011 therefore there is no consistency and it is counted as "1"
80001872 | 11-SEP-12
80001872 | 11-OCT-12
80001872 | 11-NOV-12
80001872 | 04-DEC-12
80001872 | 01-JAN-13
80001872 | 31-JAN-13
80001872 | 02-APR-13
80001872 | 01-MAY-13
80001872 | 31-MAY-13
80001872 | 04-JUL-13
80001872 | 30-JUL-13
80001872 | 23-AUG-13
80001872 | 26-SEP-13
80001872 | 20-NOV-13
80001872 | 08-JAN-14
80001872 | 07-FEB-14
80001872 | 09-APR-14
80001872 | 07-MAY-14
80001872 | 03-JUN-14
80001872 | 03-JUL-14
80001872 | 08-AUG-14
80001872 | 05-SEP-14
80001872 | 02-OCT-14
80001872 | 05-NOV-14
80001872 | 04-DEC-14
80001872 | 06-JAN-15
80001872 | 06-FEB-15
80001872 | 05-MAR-15
80001872 | 04-APR-15
80001872 | 29-APR-15
80001872 | 29-MAY-15
80001872 | 26-JUN-15
80001872 | 25-JUL-15
80001872 | 26-AUG-15
80001872 | 22-SEP-15
80001872 | 30-OCT-15
80001872 | 28-NOV-15
80001872 | 31-DEC-15
80001872 | 28-JAN-16
80001872 | 27-FEB-16
80001872 | 31-MAR-16
Spreadsheet: rick_buy__32782__Daily Treas By BU Q3
Sheet: Sept

 | Net Cash Source / (Use)
 | Current Day and Month to Date
 | Sept 2001
 |  |  |  |  | Total
 |  |  |  |  | Month to Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00
 | Enron Transportation Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.7 | 0 | 0 | -0.4 | 1.3 | -0.8 | -1.2 | 0 | 0 | 0
 | Portland General Electric |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 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 Distribution
 | Enron North America |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -18.1 | 0 | 0 | 93.5 | 269.8 | -3 | 136.9 | 0 | 0 | 0
 | Enron South America |  |  |  |  | 0 | 0 | 0 | 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 Americas
 | Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -26.7 |  |  | -16.2 | 0.9 | -10 | -7.9
 | Global Markets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  |  | -7.7 | 43.5 | -28.3 | -6.1
 | Industrial Markets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2 |  |  | -3 | -0.7 | -1.4 | 2.6
 | Networks |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2.8 |  |  | -0.9 | -0.7 | -1.2 | -1.1
 | Other |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.1 | -0.2 | 0 | 0
 | Total Traditional Wholesale
 | Enron Broadband Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1 |  |  | -0.1 | -0.8 | -1.1 | -0.8
 | EGEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.2 |  |  | -0.2 | 6.8 | 0 | 0.4
 | Other Wholesale (EE&CC) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -9.7 |  |  | -12 | -6 | -7.4 | 9
 | Total Wholesale
 | Enron Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38.1 |  |  | 9.7 | -13.9 | 2.2 | 9.6
 | Enron Global Assets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.9 | 0.2 | 1.1 | -0.8 | 0 | 0 | 0
 | Corp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -955.1 |  |  | -9.3 | -29.1 | 12.7 | -92.4 | 0.1
 | Other |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 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 Enron
 | ONLY includes cash movement monitored from Houston.
 | Does NOT include Canada, London or any other banking center.
 | Certain items such as payroll that is paid by Corp on behalf of a business unit has NOT been allocated to the business units
Spreadsheet: 887797d1738124439-fixed-asset-depreciation-josephteh-fixed-asset-depreciation
Sheet: Solution

 | Year 1 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total
 | Net Book Value b/f |  | 0
 | Addition |  | 500000
 | Initial Depreciation | 0.2
 | Annual Depreciation | 0.1
 | Net Book Value c/f
 | Year 3 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total
 | Net Book Value b/f |  | 0
 | Addition |  |  |  | 300000
 | Initial Depreciation | 0.2
 | Annual Depreciation | 0.1
 | Net Book Value c/f
 | Need a generic formula for Initial Depreciation and Annual Depreciation.
 | Asset bought in Year 1
 | - Initial Depreciation = $500,000 x 20% = $100,000 in Year 1
 | - Annual Depreciation = $500,000 x 10% = $50,000 per year from Year 1 to Year 8
 | Asset bought in Year 3
 | - Initial Depreciation = $300,000 x 20% = $60,000 in Year 3
 | - Annual Depreciation = $300,000 x 10% = $30,000 per year from Year 3 to Year 10
Spreadsheet: 751178d1633953894-search-value-match-and-add-it-to-corresponding-value-in-different-sheet-test1
Sheet: Sheet1

XS | 101 |  | XSD | 101C
XS | 102 |  | XSD | 102L
XS | 153 |  | XSD | 153C
XS | 153 |  | XSD | 153C
XS | 154 |  | XSD | 154D
XS | 154 |  | XSD | 154D
XS | 167 |  | XSD | 167H
XS | 167 |  | XSD | 167H
XS | 168 |  | XSD | 168Q
XS | 168 |  | XSD | 168Q
XS | 187 |  | XSD | 187R
XS | 187 |  | XSD | 187R
XS | 188 |  | XSD | 188U
XS | 188 |  | XSD | 188U
XS | 201 |  | XSD | 201N
XS | 202 |  | XSD | 202Z
XS | 207 |  | XSD | 207P
XS | 208 |  | XSD | 208Z
XS | 209 |  | XSD | 209P
XS | 210 |  | XSD | 210P
XS | 211 |  | XSD | 211Y
XS | 212 |  | XSD | 212
XS | 225 |  | XSD | 225Y
XS | 226 |  | XSD | 226
XS | 231 |  | XSD | 231E
XS | 232 |  | XSD | 232L
Spreadsheet: 848415d1699142358-how-to-calculate-a-pay-rate-that-is-affected-by-2-different-pay-conditions-pay-calculator_normal-pay-without-extra-days_rev-03
Sheet: Data Validation Lists

SHIFT [NAME]
 | ADD-ON #1 | ADD-ON #2 | ADD-ON #3 | PAY CLASSIFICATION
NIL | Nil | Nil | Nil | Bus Operator
ADO | ADOC | High Capacity Allowance | No Build-Up Time | Duty Officer
Annual Leave | Public Holiday |  | Travel Time | HDBOY
[NAME] | Public Holiday+Work |  |  | Relief Yard Supervisor
Day Off - No Pay | RDOC |  |  | Senior Bus Operator
Long Service Leave |  |  |  | Trainee Bus Operator
Normal/Straight |  |  |  | [NAME]
RDO |  |  |  | Trainer
Sick Day
Sick Day With No Pay
Spreadsheet: 471361d1468969718-excel-calculation-problem-of-the-pi-value-nnsw-roadbase-blends-2014-15-16-1-
Sheet: 60 30 10 CHCC

DGB20 for Coffs Council
 | % Passing Sieve |  |  |  |  |  |  | % Passing | Passing Specification |  | Deviation | % Retained | [NAME] |  | Deviation
Sieve mm | 1005/1 | 2010-3 MB20 | 2005 | 10mm | Crun 210513 | Ammd 20mm Scalps | ROSA | Blend Result | Lower | Upper | Passing | Blend Result | Lower | Upper | Retained
26.5 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
19 | 100 | 98 | 98 | 100 | 99 | 100 | 100 | 98 | 95 | 100 | 0 | 2
13.2 | 87 | 86 | 100 | 100 | 89 | 90 | 100 | 97.2 | 78 | 92 | 5.200000000000003 | 0.7999999999999972 | 6 | 18 | -5.200000000000003
9.5 | 74 | 68 | 100 | 87 | 75 | 72 | 100 | 93.6 | 63 | 83 | 10.59999999999999 | 3.600000000000009 | 7 | 17 | -3.399999999999991
6.7 | 71 | 62 | 70 | 28 | 59 | 57 | 100 | 68.4 | 50 | 70 |  |  | 10 | 21
4.75 | 52 | 42 | 100 | 7 | 45 | 46 | 100 | 88.4 | 44 | 64 | 24.40000000000001 | 5.199999999999989 | 13 | 25 | -7.800000000000011
2.36 | 42 | 33 | 42 | 2 | 26 | 30 | 100 | 40.2 | 35 | 55 | 0 | 48.2 | 7 | 19 | 29.2
0.425 | 11 | 17 | 65 | 0 | 8 | 8 | 100 | 55.4 | 14 | 23 | 32.4 | -15.2 | 14 | 30 | -29.2 |  | 137.8109452736318
0.075 | 5.5 | 12 | 35 | 0 | 3 | 4 | 100 | 30.4 | 7 | 14 | 16.4 | 25 | 6 | 13 | 12 |  | 54.87364620938629 | 0.5487364620938628
0.0135 | 3.5 | 6 | 17 | 0 | 1 | 2 | 40 | 14.8 | 3 | 7 | 7.800000000000001 | 15.6 | 3 | 8 | 7.599999999999998 |  | 48.68421052631579
PI | 7 | 0 | 7 |  |  |  |  | 6.570397111913358 | 0 | 6 | 0.5703971119133575
Ratio | 0 | 20 | 80 | 0 | 0 | 0 | 0 | 100
 | Raw Feed | Dust | White | Pit Fines
 | 48 | 12 |  | 10
 | 25 |  | 5
 | 73 | 12 | 5 | 10
 | 14.6 | 2.4 | 1 | 2
 | 15 | 2 | 1 | 2 | 20
 | 75 | 10 | 5 | 10 | 100
 | 25 |  | 25
 | 50
 | 60 |  | 30 | 10 | 100
Spreadsheet: 34939d1232396264-finding-closest-date-between-two-arrays-excelforum_2003_upload
Sheet: Sheet1

Date | Data1 | Date2 |  |  | Date | Data1
2009-01-15 13:00:00 | a | x |  |  | 2009-01-15 13:10:00 | x
2009-01-15 17:45:00 | b | NA |  |  | 2009-01-15 22:00:00 | y
2009-01-19 10:30:00 | c | b |  |  | 2009-01-19 11:03:00 | a
 |  |  |  |  | 2009-01-19 10:00:00 | b