tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 128180d1320842010-excel-2007-tied-values-lookup-formula-tiedvalues
Sheet: Sheet1

 | Name | Score |  | Position | Name | Score
 | Pink | 50 |  | 1st
 | [NAME] | 60 |  |  |  |  | This is with the use of [NAME]
 | Yellow | 70 |  | 2nd
 | Purple | 75
 | Blue | 60 |  | 3rd
 | White | 70
 | Gold | 45
 | Red | 46 |  |  | I want it as below:
 |  |  |  | Position | Name | Score
 |  |  |  | 1st | Purple
 |  |  |  | 2nd | Yellow
 |  |  |  |  | White
 |  |  |  | 3rd | [NAME]
 |  |  |  |  | Blue
Spreadsheet: 836297d1689248355-dynamic-range-for-match-function-bonus-calculations
Sheet: INVOICES

Invoice For,
Phone:
Mobile:
[NAME]:
Vehicle,
PLate:
Chassis:
Current Milage :
Oil Type :
Covered Milage :
Invoice #8614
Invoice Date: 24-Jun-2023
Item | ID | Code | Unit Price | Unit | Total | Dis % | Net Total
------------Spare Parts
WASHER FLUID RESERVOIR | 4F0955452A | VW---3014 | 176 | 1 | 176 | 0.1 | 158.4
WASHER BOTTLE STRAINER | 8Z0955485 | VW---3015 | 53 | 1 | 53 | 0.1 | 47.7
WASHER FLUID BOTTLE RESERVOIR CAP | 1K0955455 | VW---2623 | 45 | 1 | 45 | 0.1 | 40.5
WIPER WASHER SPRAY HOSE | 4F0955953 | VW---3016 | 198 | 1 | 198 | 0.1 | 178.2
GAS OR FUEL | GAS91.1 | Fuel-Gas-2 | 1.02 | 60 | 61.2 | 0.1 | 55.08
OPERATING UNIT FOR MULTIMEDIA SYSTEM USED | 4F1919611M H77UU | VW-US-77 | 1600 | 1 | 1600 | 0.1 | 1440
------------Services
REMOVE AND INSTALL OPERATING UNIT FOR MULTIMEDIA | -- | -- | 600 | -- | 600 | 0.1 | 540
REPLACEMENT WASHER FLUID RESERVOIR AND HOSE | -- | -- | 400 | -- | 400 | 0.1 | 360
Invoice For,
Phone:
Mobile:
[NAME]:
Vehicle,
PLate:
Chassis:
Current Milage :
Oil Type :
Covered Milage :
Invoice #8576
Invoice Date: 15-Jun-2023
Item | ID | Code | Unit Price | Unit | Total | Dis % | Net Total
------------Spare Parts
RED COOLANT | A0009892825 | MR----780 | 88 | 2 | 176 | 0.05 | 167.2
DISTILLED WATER | W001 | OR-MS-11 | 40 | 1 | 40 | 0.05 | 38
------------Services
REMOVE AND INSTALL EXPANSION TANK | -- | -- | 400 | -- | 400 | -- | 400
CLEANING EXPANSION TANK | -- | -- | 350 | -- | 350 | -- | 350
Invoice For,
Phone:
Mobile:
[NAME]:
Vehicle,
PLate:
Chassis:
Current Milage :
Oil Type :
Covered Milage :
Invoice #8572
Invoice Date: 15-Jun-2023
Item | ID | Code | Unit Price | Unit | Total | Dis % | Net Total
------------Spare Parts
REPAIRING BOLT THREADS | TBH003 | OR-TR-9 | 160 | 1 | 160 | 0.15 | 136
BOLT | BT001 | OR-MS-32 | 25 | 1 | 25 | 0.15 | 21.25
------------Services
REPLACEMENT ENGINE OIL AND FILTER | -- | -- | 200 | -- | 200 | -- | 200
Invoice For,
Phone:
Mobile:
[NAME]:
Vehicle,
PLate:
Chassis:
Current Milage :
Oil Type :
Covered Milage :
Invoice #8468
Invoice Date: 28-May-2023
Item | ID | Code | Unit Price | Unit | Total | Dis % | Net Total
------------Spare Parts
AIR SPRING DAMPER REPAIRED FRONT RIGHT | 95835804000Kit | PR---234 | 2600 | 1 | 2600 | 0.1 | 2340
AIR SPRING DAMPER REPAIRED REAR LEFT | 95835801905Kit | PR---236 | 2800 | 1 | 2800 | 0.1 | 2520
AIR SPRING DAMPER REPAIRED REAR RIGHT | 95835802015Kit | PR---235 | 2800 | 1 | 2800 | 0.1 | 2520
[NAME] | 95834301820 | PR---228 | 297 | 3 | 891 | 0.1 | 801.9
REAR DOOR LOCK LEFT | 9A783911501 | PR---645 | 1082 | 1 | 1082 | 0.1 | 973.8
DOOR PANEL CLIP | 95555524300 | PR---957 | 9 | 5 | 45 | 0.1 | 40.5
------------Services
REPLACEMENT FRONT RIGHT AIR SPRING DAMPER | -- | -- | 800 | -- | 800 | 0.2 | 640
REPLACEMENT REAR RIGHT AIR SPRING DAMPER | -- | -- | 800 | -- | 800 | 0.2 | 640
REPLACEMENT REAR LEFT AIR SPRING DAMPER | -- | -- | 800 | -- | 800 | 0.2 | 640
REMOVE AND INSTALL REAR LEFT DOOR TRIM | -- | -- | 800 | -- | 800 | 0.2 | 640
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: Devon

 | Devon SFS Operating
 | POI 36289 - Bilbrey 28 Fed 1 C/P
Day | Measured | Scheduled
1 | 14 | 429
2 | 39 | 429
3 | 3 | 429
4 |  | 429
5 |  | 247
6 |  | 388
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 1032
2002-03-06 00:00:00
CBS Volume
 |  |  | 487
Spreadsheet: chris_germany__1832__DecCohCHOICE-ENA
Sheet: Dec 12

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-12 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1644 |  |  |  | 67694 |  |  |  |  |  | 12 | 1 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 2 | x
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 7076 |  |  |  | 67694 |  |  |  |  |  | 13 | 3 | x
 |  |  |  |  |  |  |  |  | 5000 |  |  |  | 68918 | 0 |  |  |  |  | 14 | 4 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 5 | x
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2776 |  |  |  | 67694 |  |  |  |  |  | 15 | 6 | x
 |  |  |  |  |  |  |  |  | 1535 |  |  |  | 68915 | 0 |  |  |  |  | 14 | 7 | x
 |  |  |  |  |  |  |  |  | 1540 |  |  |  | 69693 | 0 |  |  |  |  | 19 | 8 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 9 | x
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 18991 |  |  |  | 67694 |  |  |  |  |  | 24 | 15 | x
 |  |  |  |  |  |  |  |  | 673 |  |  |  | 69149 | 0 |  |  |  |  | 17 | 35 | x
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 68915 | 0 |  |  |  |  | 14 | 39 | x
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 68918 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2152 |  |  |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1683 |  |  |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  |  |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 16642 |  |  |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 2660 |  |  |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4839 |  |  |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 6190 |  |  |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1446 |  |  |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  |  |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 52 |  |  |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: tracy_geaccone__40403__EGS Returns
Sheet: Sheet1

Enron Global Services
$ in Millions
 | 2001 3rd Current Estimate |  |  |  |  |  |  |  |  | 2002 Plan
 |  |  |  |  |  |  | Operating
 |  |  |  |  | Average | Average | Return | Return |  |  |  |  |  | Average | Average | Return | Return
 |  |  | Funds | Total | Capital | Equity | On Capital | On Equity |  |  |  | Funds | Total | Capital | Equity | On Capital | On Equity
 | IBIT | Net | Flow | Obligations | Employed | Invested | Invested | Invested |  | IBIT | Net | Flow | Obligations | Employed | Invested | Invested | Invested
ETS | 0 | 0 | 0 | 0 | 1 | 1 |  |  |  | 0 | 0 | 0 | 0 | 1 | 1
PGE | 0 | 0 | 0 | 0 | 1 | 1 |  |  |  | 0 | 0 | 0 | 0 | 1 | 1
EGAS | 0 | 0 | 0 | 0 | 1 | 1 |  |  |  | 0 | 0 | 0 | 0 | 1 | 1
EREC | 0 | 0 | 0 | 0 | 1 | 1 |  |  |  | 0 | 0 | 0 | 0 | 1 | 1
AZX | 0 | 0 | 0 | 0 | 1 | 1 |  |  |  | 0 | 0 | 0 | 0 | 1 | 1
EEOS | 0 | 0 | 0 | 0 | 1 | 1 |  |  |  | 0 | 0 | 0 | 0 | 1 | 1
Totals
Capital  =
Spreadsheet: 774385d1648451294-lookup-rates-in-excelsheet-based-on-binning-buckets-instead-of-full-data-modification-grid-2022
Sheet: Rates

 | CHECK
 | LTV | 0.611 | Should be 2,28%
 | Rate
 | 0 | =<60% | =<80% | =<90% | =<100%
 | 0
10YR | 0.0216 | 0.0216 | 0.0228 | 0.0236 | 0.0245
Spreadsheet: ae45ef75-b6d8-4c1a-b14a-ce21650a5fc5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
To: Accounts Payable |  | Date:
Business Office
Remove Funds From |  |  | Add Funds To
Account #/Proj Code | Amount |  | Account #/Proj Code | Amount
Total: | 0 |  | Total: | 0
Reason for Transfer:
Transfer Requested By: |  |  | Transfer Authorized By:
Signature |  |  | Signature
Print Name |  |  | Print Name
Spreadsheet: 236470d1368801112-sequence-conundrum-sequence_problem
Sheet: Sheet1

GL Code | TB Group | Column Required
141001 | Cash | [NAME]
141001 | Cash | [NAME]
141002 | Cash | Cash2
148001 | Equalisation | Equalisation1
148002 | Equalisation | Equalisation2
148001 | Equalisation | Equalisation1
Spreadsheet: 49819d1249229282-excel-2007-formula-query-to-calculate-golf-handicaps-golf_shot_tracker
Sheet: Score_Card

 |  | Par |  | 70 | 70 | 70
 |  | SSS |  | 67 | 67 | 70
 |  | Hole |  | White yards | [NAME] | Red Yards |  | Par | Stroke Index
 |  | 1 |  | 146 | 137 | 130 |  | 3 | 15
 |  | 2 |  | 473 | 460 | 457 |  | 5 | 3
 |  | 3 |  | 336 | 322 | 319 |  | 4 | 7
 |  | 4 |  | 125 | 120 | 117 |  | 3 | 17
 |  | 5 |  | 332 | 319 | 314 |  | 4 | 11
 |  | 6 |  | 367 | 360 | 349 |  | 4 | 5
 |  | 7 |  | 389 | 385 | 367 |  | 4 | 1
 |  | 8 |  | 349 | 334 | 336 |  | 4 | 9
 |  | 9 |  | 261 | 258 | 242 |  | 4 | 13
 |  | 10 |  | 146 | 137 | 130 |  | 3 | 16
 |  | 11 |  | 473 | 460 | 457 |  | 5 | 4
 |  | 12 |  | 336 | 322 | 319 |  | 4 | 8
 |  | 13 |  | 125 | 120 | 117 |  | 3 | 18
 |  | 14 |  | 332 | 319 | 314 |  | 4 | 12
 |  | 15 |  | 367 | 360 | 349 |  | 4 | 6
 |  | 16 |  | 389 | 385 | 367 |  | 4 | 2
 |  | 17 |  | 349 | 334 | 336 |  | 4 | 10
 |  | 18 |  | 261 | 258 | 242 |  | 4 | 14
 |  |  | In
 |  |  | Out
 |  |  | Total
Spreadsheet: 2ab18f7b-c3bc-4ccf-aa0d-8efe3526742e
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43369525 | 2014-09-29 22:00:47 | AXIS | 0 | 5 | 6 | 452932 | JJAZ | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
43370133 | 2014-09-29 22:26:55 | ALLIES | 1 | 6 | 5 | 452932 | JJAZ | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
Spreadsheet: vkaminski__40901__CASH_EPE_0400MyCopy
Sheet: Project & Investor Returns

 |  |  |  |  | Value From 1997 Or 1998 ===> |  |  | 0
PROJECT / ENRON / NEW INVESTOR RETURNS
Current Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NPV
Calendar Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals | Recon
Project Returns
 | Allocation Of Cashflows
 | Original Quotas
 | Equity
 | Net A-T Cash Flow Distributed
 | Plus: Trapped Cash
 | Plus: Interest On Net Equity (INE)
 | Total Cash Flow - Original Quotas
 | 20 Year Running NPV  - Original Quotas
 | 20 Year Running IRR - Original Quotas
 | Project IRR w/o TC
 | Discounted Payback Year
 | Equity % - Original Quotas
 | Cashflow % - Original Quotas
 | Purchase Of Enron Selldown (Original Quotas)
 | Net A-T Cash Flow Distributed
 | Plus: Trapped Cash Loaned To Partners
 | Less: Interest Expense - Partner Loans |  | (1)
 | Plus: Interest On Net Equity (INE)
 | Less: W/H Tax - INE
0 | Less: Tax (Exp) / Benefit On (1)'s Above | 0
 | Total Cash Flow
 | 20 Year Running NPV
 | 20 Year Running IRR
 | Cashflow Before Subordinated Debt
 | Purchase Of Subordinated Debt (New Investor)
 | Subordinated Debt Repayment
 | Plus: Interest Income - Subordinated Debt |  | (3)
 | Purchase Preferred Shares ([NAME])
 | US Tax (Exp) / Benefit (3)'s Above
 | Total Cash Flow - w/ Subordinated Debt
 | 20 Year Running NPV
 | 20 Year Running IRR
 |  | Cumlulative | Individual
Spreadsheet: darrell_schoolcraft__7608__imball0201
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635
3531
60667 | -108557
60749
61206
61334
62960
INDEX
2001-12-31 00:00:00 |  |  | 58523
2002-01-05 00:00:00
CBS Volume
2001-12-31 00:00:00 |  |  | 26010
Spreadsheet: 816238d1675440284-cross-check-and-sum-sumproduct-med-sumif
Sheet: Sheet1

 |  |  |  | Product: | Adis1 | Adis5 | Adis6 | Adis2 | Adis7 | Adis9 | Adis10 | Adis11 | Adis12 | Adis13 | Adis3 | Adis14 | Adis8 | Adis15 | Adis16 | Adis17 | Adis4 | Adis18 | Adis19 | Adis20
 |  |  |  |  | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 10 | 10 | 10 | 0 | 10 | 1 | 10 | 10 | 10 | 0 | 10 | 10 | 10
 |  |  |  |  | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
Spreadsheet: 187104d1350335530-wildcard-w-cell-reference-book1
Sheet: Sheet2

 | First | Last | [NAME]
Company - MA | [NAME] | Smith | jsmith@
The Office People | [NAME] | Sue | marysue@
Capital MGMT | [NAME] | Parker | pparker@
Coal Miners | [NAME] | Wayne | brucewayne@
Extranneous Co. | [NAME] | Smith | email
WA State | [NAME] | Boberton | email1
WA State Dept of Agriculture | [NAME] | [NAME] | [NAME]
Spreadsheet: 02d3fbd7-9b81-4603-bef2-a4cedb5cad7d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6202.0 Labour Force, Australia
 | Table 20. Aggregate monthly hours worked by State - Trend and Seasonally adjusted
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Trend | A3591553W | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Trend | A3591554X | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Trend | A3591555A | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Trend | A3591556C | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Trend | A3591557F | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Trend | A3591558J | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NORTHERN TERRITORY ; |  |  | Trend | A3591559K | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  AUSTRALIAN CAPITAL TERRITORY ; |  |  | Trend | A3591560V | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Seasonally Adjusted | A3591544V | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Seasonally Adjusted | A3591545W | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Seasonally Adjusted | A3591546X | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Seasonally Adjusted | A3591547A | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Seasonally Adjusted | A3591548C | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Seasonally Adjusted | A3591549F | 1978-07-01 00:00:00 | 2012-11-01 00:00:00 | 413 | 000 Hours | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: dccfabbc-3cd1-4c6a-929d-872a51b439ce
Sheet: Sheet1

Unnamed: 0 | NSWQLD | QLDNSW | SAVIC | VICSA | NSWVIC | VICNSW
SRA Residue | 28269.88 | 3485565.5 | 272210.23 | 5102564.24 | 16479.78 | 7523122.3
Fees Charged | -2200 | -21600 | -3200 | -25200 | -6500 | -21000
Residue Paid | 26069.88 | 3463965.5 | 269010.23 | 5077364.24 | 9979.78 | 7502122.3
Adjustment Paid |  |  |  |  | 3020.22
Negative Residue | -1707.25 | -85371.54 | -425252.65 | -14211.92 | -1740712.54 | -1380.33
Unauctioned Residue | 1.2 | 136.01 | 0 | 254.43 | -68.97 | 752.25
Spreadsheet: 879463d1727005087-list-the-missing-number-in-2-columns-vice-versa-btk
Sheet: Sheet1

 |  |  |  |  |  | Need formula to list numbers here | Need formula to list numbers here |  | Need formula to list numbers here | Need formula to list numbers here
Column 1 | Column 2 |  | Column 3 | Column 4 |  | Missing - what numbers in Col 1 but not Col 3 | Missing - what numbers in Col 3 but not Col 1 |  | Missing - what numbers in Col 2 but not Col 4 | Missing - what numbers in Col 4 but not Col 2
2500 | 2678 |  | 0 | 0 |  | 555 | 796 |  | 17856 | 750
555 | 17856 |  | 0 | 0 |  | 456 |  |  | 2678 | 4639
0 | 0 |  | 2500 | 2678 |  | 2500
0 | 2678 |  | 966 | 0
649 | 0 |  | 0 | 14607
2500 | 0 |  | 0 | 2678
0 | 2678 |  | 2500 | 0
0 | 14607 |  | 649 | 0
2500 | 0 |  | 0 | 12828
966 | 0 |  | 0 | 2678
0 | 2678 |  | 2500 | 0
0 | 12828 |  | 910 | 0
456 | 0 |  | 0 | 13933
2500 | 0 |  | 0 | 2678
0 | 2678 |  | 2500 | 0
0 | 13933 |  | 597 | 0
910 | 0 |  | 0 | 3386
2500 | 0 |  | 0 | 2678
0 | 2678 |  | 2500 | 0
0 | 3386 |  | 745 | 0
597 | 0 |  | 0 | 2678
2500 | 0 |  | 0 | 16683
0 | 16683 |  | 2500 | 0
0 | 2678 |  | 815 | 0
745 | 0 |  | 0 | 5038
2500 | 0 |  | 0 | 2678
0 | 5038 |  | 2500 | 0
0 | 2678 |  | 924 | 0
2500 | 0 |  | 0 | 14797
815 | 0 |  | 0 | 750
924 | 14797 |  | 0 | 0
2500 | 0 |  | 0 | 4639
0 | 0 |  | 2500 | 2678
0 | 2678 |  | 796 | 0
Diff |  |  |  |  |  | Diff |  |  | Diff
Spreadsheet: 288501d1389205826-rank-to-the-right-function-or-macro-excel-exam
Sheet: Sheet1

84 | 0 | 42 | 46 | 60 | 88 | 194 | 154 | #REF!
79 | 0 | 39.5 | 51 | 60 | 90.5 | 201.5 | 149 | #REF!
84 | 65 | 74.5 | 46 | 125 | 55.5 | 226.5 | 158.5 | #REF!
0 | 0 | 0 | 63 | 63 | 130 | 256 | 134 | #REF!
68 | 0 | 34 | 62 | 70 | 96 | 228 | 128 | #REF!
0 | 0 | 0 | 77 | 77 | 130 | 284 | 106 | #REF!
67 | 45 | 56 | 83 | 83 | 74 | 240 | 103 | #REF!
0 | 0 | 0 | 86 | 86 | 130 | 302 | 88 | #REF!
19 | 49 | 34 | 81 | 129 | 96 | 306 | 83 | #REF!
28 | 39 | 33.5 | 91 | 129 | 96.5 | 316.5 | 72.5 | #REF!
1 | 0 | 0.5 | 130 | 129 | 129.5 | 388.5 | 1 | #REF!
#[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
#[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
61 | 62 | 61.5 | 53 | 67 | 68.5 | 188.5 | 140 | #REF!
58 | 75 | 66.5 | 55 | 70 | 63.5 | 188.5 | 141.5 | #REF!
1 | 24 | 12.5 | 61 | 61 | 117.5 | 239.5 | 138 | #REF!
69 | 70 | 69.5 | 60 | 73 | 60.5 | 193.5 | 139.5 | #REF!
65 | 65 | 65 | 63 | 63 | 65 | 191 | 134 | #REF!
60 | 42 | 51 | 64 | 64 | 79 | 207 | 132 | #REF!
63 | 64 | 63.5 | 62 | 66 | 66.5 | 194.5 | 132 | #REF!
52 | 64 | 58 | 63 | 67 | 72 | 202 | 130 | #REF!
66 | 48 | 57 | 63 | 75 | 73 | 211 | 124 | #REF!
60 | 58 | 59 | 69 | 69 | 71 | 209 | 122 | #REF!
63 | 57 | 60 | 67 | 87 | 70 | 224 | 123 | #REF!
50 | 52 | 51 | 78 | 100 | 79 | 257 | 103 | #REF!
#[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
#[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
64 | 70 | 67 | 46 | 46 | 63 | 155 | 168 | #REF!
82 | 77 | 79.5 | 48 | 52 | 50.5 | 150.5 | 161.5 | #REF!
66 | 77 | 71.5 | 50 | 50 | 58.5 | 158.5 | 160 | #REF!
67 | 74 | 70.5 | 51 | 51 | 59.5 | 161.5 | 158 | #REF!
1 | 1 | 1 | 53 | 53 | 129 | 235 | 154 | #REF!
72 | 79 | 75.5 | 51 | 67 | 54.5 | 172.5 | 154.5 | #REF!
71 | 79 | 75 | 51 | 67 | 55 | 173 | 154 | #REF!
79 | 65 | 72 | 49 | 74 | 58 | 181 | 153 | #REF!
75 | 61 | 68 | 49 | 67 | 62 | 178 | 149 | #REF!
62 | 0 | 31 | 57 | 57 | 99 | 213 | 146 | #REF!
69 | 52 | 60.5 | 59 | 62 | 69.5 | 190.5 | 139 | #REF!
1 | 73 | 37 | 57 | 91 | 93 | 241 | 112 | #REF!
81 | 40 | 60.5 | 130 | 74 | 69.5 | 273.5 | 60.5 | #REF!
83 | 54 | 68.5 | 130 | 98 | 61.5 | 289.5 | 68.5 | #REF!
#[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
#[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
70 | 58 | 64 | 49 | 49 | 66 | 164 | 162 | #REF!
77 | 74 | 75.5 | 48 | 57 | 54.5 | 159.5 | 157.5 | #REF!
75 | 60 | 67.5 | 53 | 53 | 62.5 | 168.5 | 154 | #REF!
5 | 68 | 36.5 | 55 | 55 | 93.5 | 203.5 | 150 | #REF!
78 | 69 | 73.5 | 49 | 80 | 56.5 | 185.5 | 154.5 | #REF!
72 | 67 | 69.5 | 57 | 57 | 60.5 | 174.5 | 146 | #REF!
76 | 60 | 68 | 54 | 71 | 62 | 187 | 144 | #REF!
20 | 45 | 32.5 | 48 | 72 | 97.5 | 217.5 | 140 | #REF!
Spreadsheet: 120739d1315491829-autopopulate-changing-info-in-one-sheet-to-a-new-one-copy-of-combined-working-w_matpremix
Sheet: Resin Traceability

 |  |  |  | [NAME] FORM
Job Order: |  | J1222
Description: |  | BOTTLE
Part Number: |  | 918872201
Quantity: |  | 6500
 | Base Resin P/N |  | -
 | Amount | Lot |  | Initials | Date
1
2
3
4
5
6
7
8
 | Running Total
 |  | Amount |  | Initials |  | Super
 | Required
1 | Issued
 | Balance
2 | Issued
 | Balance
3 | Issued
 | Balance
4 | Issued
 | Balance
 | Colorant | %:               P/N: | - |  |  | Additive | %:          P/N: | 899999999
 | Amount | Lot | Initials | Date |  | Amount | Lot | Initials | Date
1
2
3
4
5
6
7
8
 |  |  |  |  |  |  | Form QASFM0401312 Rev. A
 |  |  |  |  |  |  | Page 4 of 4
Spreadsheet: 132385d1323724507-cannot-use-if-isnumber-on-a-range-yes-no-trials
Sheet: YES NO

 |  |  |  |  |  | sum | isnumber | countblank
1 | 1 |  | 1 |  |  | 3 | yes | No
 |  |  |  |  |  |  | no | No
 | 1 |  |  |  |  | 1 | yes | No
 |  |  |  |  |  |  | no | No
 |  |  |  |  |  |  | no | No
 |  |  |  | 4 |  | 4 | yes | No
 |  |  |  |  |  |  | no | No
 |  | 1 |  |  |  | 1 | yes | No
4 |  |  |  |  |  | 4 | yes | No
 |  |  |  |  |  |  | no | No
4 |  |  | 1 |  |  | 5 | yes | No
1 |  |  |  |  |  | 1 | yes | No
 |  |  |  |  |  | 0 | yes | No
 | 1 |  |  |  |  | 1 | yes | No
 |  |  |  |  |  | 0 | yes | No
 |  | 1 |  | 1 |  | 2 | yes | No
 |  |  |  |  |  | 0 | yes | No
 |  |  |  |  |  | 0 | yes | No
Spreadsheet: eric_saibi__9758__012102R
Sheet: Encina 3

Owner Name |  | Cabrillo Power LLC
Station Name |  | Encina Power Station
Unit Name |  | Encina 03
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Natural Gas
Capacity |  | 110 MW
Start Date |  | 2002-01-04 00:00:00
End Date |  | 2002-01-23 00:00:00
Prv. Start Date |  | 2002-01-04 00:00:00
Prv. End Date |  | 2002-01-18 00:00:00
Comments |  | [NAME]
SIC |  | 4931
Plant ID |  | 1013264
Unit ID |  | 1006366
Outage ID |  | 19378