tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 871747d1718174161-prepare-an-outstanding-sheet-test
Sheet: Sheet1

Inv | Date | Decription | Debit | Credit | Amt
 | 2022-12-31 00:00:00 | selfi dep | FIXED DEP | Security Deposit | 500000
 | 2022-12-31 00:00:00 | Global gf | FIXED DEP | Security Deposit | 100000
 | 2022-12-31 00:00:00 | global 1 | FIXED DEP | Security Deposit | 47000
 | 2022-12-31 00:00:00 | global 2 | FIXED DEP | Security Deposit | 44000
 | 2022-12-31 00:00:00 | global 3 | FIXED DEP | Security Deposit | 30000
 | 2022-12-31 00:00:00 | dec rent | Selfi |  | 16500
 | 2022-12-31 00:00:00 | dec rent | Major |  | 8124
 | 2022-12-31 00:00:00 | dec rent | Global GF |  | 88000
 | 2022-12-31 00:00:00 | dec rent | Global1 |  | 13068
 | 2022-12-31 00:00:00 | dec rent | Global 2 |  | 5400
 | 2022-12-31 00:00:00 | dec rent | Global 3 |  | 6500
 | 2022-12-31 00:00:00 | dec rent | Capital Mall |  | 76327
 | 2023-01-01 00:00:00 | rent jan | Selfi | Rental Income | 16500
 | 2023-01-01 00:00:00 | rent jan | Major | Rental Income | 7800
 | 2023-01-01 00:00:00 | rent jan | Tax | Major | 975
 | 2023-01-01 00:00:00 | rent jan | Global GF | Rental Income | 11000
 | 2023-01-01 00:00:00 | rent jan | Global1 | Rental Income | 6534
 | 2023-01-01 00:00:00 | rent jan | Global 2 | Rental Income | 5400
 | 2023-01-01 00:00:00 | rent jan | Global 3 | Rental Income | 6500
 | 2023-01-01 00:00:00 | rent jan | Capital Mall | Rental Income | 19409
 | 2023-01-01 00:00:00 | dec paid | SBI | Global 3 | 6500
 | 2023-01-03 00:00:00 | dec paid | SBI | Selfi | 16500
 | 2023-01-07 00:00:00 | dec paid | SBI | Global 2 | 5400
 | 2023-01-12 00:00:00 | sep rent | IDBI | Capital Mall | 15604
 | 2023-01-12 00:00:00 | Capital Mall | Maintenanace | Capital Mall | 2000
 | 2023-01-12 00:00:00 | Capital Mall | Tax | Capital Mall | 1000
 | 2023-01-24 00:00:00 | JUN JUL RENT | SBI | Global GF | 22000
 | 2023-02-01 00:00:00 | feb rent | Selfi | Rental Income | 16500
 | 2023-02-01 00:00:00 | feb rent | Major | Rental Income | 8124
 | 2023-02-01 00:00:00 | feb rent | Tax | Major | 624
 | 2023-02-01 00:00:00 | feb rent | Global GF | Rental Income | 11000
 | 2023-02-01 00:00:00 | feb rent | Global1 | Rental Income | 6534
 | 2023-02-01 00:00:00 | feb rent | Global 2 | Rental Income | 5400
 | 2023-02-01 00:00:00 | feb rent | Global 3 | Rental Income | 6500
 | 2023-02-01 00:00:00 | feb rent | Capital Mall | Rental Income | 19415
 | 2023-02-04 00:00:00 | jan rent | SBI | Selfi | 16500
 | 2023-02-04 00:00:00 | jan rent | SBI | Global 2 | 5400
 | 2023-02-04 00:00:00 | nov dec | SBI | Global1 | 13068
Spreadsheet: 810282d1671651365-indirect-function-returning-ref-error-example
Sheet: Weekly Detail

REP | 2022-11-28 00:00:00 | 2022-11-29 00:00:00 | 2022-11-30 00:00:00 | 2022-12-01 00:00:00 | 2022-12-02 00:00:00 | Totals | Avg Accts per Day | Hours Worked | Avg Accts per Hour | Notes |  | [NAME] | Available | [NAME] | Total time
Ah, Tar |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  | 40.54
 |  |  |  |  |  |  |  | 40.13
 |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  | 40.04
 |  |  |  |  |  |  |  | 32.08
 |  |  |  |  |  |  |  | 37.19 |  | My Health Messages
 |  |  |  |  |  |  |  | 31.04 |  | Printing, faxes, etc.
 |  |  |  |  |  |  |  | 40.24
 |  |  |  |  |  |  |  | 0 |  | Not available in My Time (contractor)
 |  |  |  |  |  |  |  | 40.02
 |  |  |  |  |  |  |  | 30.92
Spreadsheet: 156066d1337170583-using-sumifs-formula-and-or-condition-simultaneously-tracker
Sheet: Raw Data

 |  |  |  |  |  |  |  | VIEWS | APPS | TOTAL REG |  | NEW REG |  | SHORTLISTED |  | INTERVIEWED |  | PLACED
Client | Job Title | Location | Region | Vacancy No. | Disc. | Rank | Platform | No. | No. | No. | Ratio | No. | Ratio | No. | Ratio | No. | Ratio | No. | Ratio | ROI
Client 1 | Job | [NAME] | UK | 12345 | OPS | SEN | RWJ | 308 | 15 | 14 |  | 5 |  | 0 |  | 0 |  | 0 |  | 0
Client 1 | Job | [NAME] | UK |  | MER | MID | RWJ | 82 | 4 | 4 |  | 4 |  | 0 |  | 0 |  | 0 |  | 0
Client 1 | Job | [NAME] | EU |  | OPS | MID | RWJ | 56 | 4 | 4 |  | 4 |  | 0 |  | 0 |  | 0 |  | 0
Client 1 | Job | [NAME] | EU |  | OPS | MID | RWJ | 65 | 2 | 2 |  | 2 |  | 0 |  | 0 |  | 0 |  | 0
Client 2 | Job | [NAME] | UK |  | OPS | MID | RWJ | 80 | 2 | 1 |  | 1 |  | 0 |  | 0 |  | 0 |  | 0
Client 3 | Job | [NAME] | UK |  | OPS | MID | RWJ | 86 | 4 | 2 |  | 2 |  | 0 |  | 0 |  | 0 |  | 0
Client 3 | Job | [NAME] | UK |  | OPS | MID | RWJ | 108 | 9 | 7 |  | 5 |  | 0 |  | 0 |  | 0 |  | 0
Client 4 | Job | [NAME] | IN |  | OPS | MID | RWJ | 118 | 17 | 15 |  | 12 |  | 1 |  | 0 |  | 0 |  | 0
Client 4 | Job | [NAME] | ME |  | MER | MID | RWJ | 114 | 12 | 8 |  | 6 |  | 1 |  | 0 |  | 0 |  | 0
Client 4 | Job | [NAME] | EU |  | OPS | SEN | RWJ | 462 | 16 | 14 |  | 7 |  | 0 |  | 0 |  | 0 |  | 0
Client 5 | Job | [NAME] | EU |  | OPS | MID | RWJ | 52 | 5 | 5 |  | 4 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: louise_kitchen__23016__NYMEX Margin103101
Sheet: 1031 (2)

FUTURES MARGIN REQUIREMENTS
2001-11-01 00:00:00
2001-10-31 00:00:00
 |  |  |  |  |  | CANADIAN $$$
Broker | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin | Line of Credit Covering Realized/Unrealized Gains & Losses |  | OTE | Initial Margin
ABN-Amro Inc | 365200 |  | 365200 | 0 |  |  |  | 0
ADM INVESTOR | 0 |  | 0
BANK ONE | 0 |  | 0
CARR FUTURES (NG) | 0 |  | 0
CARR FUTURES INC. | 2717262.56 |  | 2717262.56
CREDIT SUISSE FIRST BOSTON | 2390310 |  | 2390310
EDF MAN   (see note below) | 31141475 | 25000000 | 6141475 | 0
FIMAT * | 10270958 | (A) | (A) | 0
HSBC - US$ | 379061 |  | 379061
HSBC - Canadian |  |  | 0 |  |  | -114950 | 326320
JP Morgan | 436520 |  | 436520
[NAME] | 0 |  | 0
PARIBAS | 36046052 | 36046052 | 0 | 0
PRUDENTIAL SI | 378620 |  | 378620
REFCO, INC | 0 |  | 0
R J O'BRIEN | 91000 |  | 91000
SAUL STONE & COMPANY | 117000 |  | 117000
SMITH BARNEY, INC ** | 5662492 | 5662492 | 0 | 0
SMITH BARNEY, INC ** (Financial) | 86400 |  | 86400
TOTAL EXCLUDING MID-DAY CALLS | 90082350.56 | 67830554.94 | 22251795.62 | 0 |  | -114950 | 326320
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann
TOTAL INCLUDING MID-DAY CALLS
(A)  [NAME] is in the process of reconciling FIMAT initial margin.
** Smith Barney Initial Margin does not include Delivery Margin of |  |  |  | 0
Credit Lines: | Line | Used Line | Unused Line
Smith Barney | 50000000 | 5662492 | 44337508
Paribas | 75000000 | 36046052 | 38953948
EDF | 25000000 | 25000000 | 0
Fimat | 20000000 | 1122010.94 | 18877989.06
 | 170000000 | 67830554.94 | 102169445.06
Note:  EDF Man - Positive Net Option value is collateral for futures requirement.
Initial Margin |  |  | 31141475
Option value used to cover Margin |  |  | 0
Initial Margin less positive option value |  |  | 31141475
[NAME] of Credit Analysis:
Initial Margin |  |  | 31141475
OTE |  |  | 0 | (limit 20,000,000)
Net Option Value |  |  | 28252060.40000004
Line of Credit Balance |  |  | 25000000 | (limit 50,000,000)
Paribas Line of Credit Limit is $75,000,000
Spreadsheet: 42211d1240818800-ranking-text-ranking-text-
Sheet: Sheet1

ID | Code | Rank | Helper column | Rank
123 | feata | 1
123 | feata | 2 | 1.000003
123 | featb | 3 | 3.000004
567 | feata | 1 | 1.000005
567 | featc | 2 | 2.000006
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Hoy&Latsha

 |  |  |  |  |  |  | 2013 Hoy & Latsha F.E.
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | 1st & 3rd Thursdays.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: benjamin_rogers__1178__ENRON_$orion_1099
Sheet: Performance

Orion Performance Summary 10/12/99: (Expect Update to this by 10/29/99)
 |  |  |  | No Chilling |  | with [NAME] |  | with [NAME]
 |  |  |  | No STG Upgrade |  | No STG Upgrade |  | with STG Upgrade
 |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Ambient | RH | [NAME] | Output * | Heat Rate | Output * | Heat Rate | Output * | Heat Rate
Load | Temp (F) | (%) | 7/LM/Stg | (mwe) | (btu/kwe) | (mwe) | (btu/kwe) | (mwe) | (btu/kwe)
Peak | -20 | 60 | 162 F
Peak | 20 | 60 | 162 F
Peak | 60 | 60 | 162 F
Peak | 80 | 40 | 162 F
Peak | 95 | 34.5 | 162 F
Peak | 105 | 27 | 162 F
Swing | 20 | 60 | 162 N
Swing | 40 | 60 | 162 N
Swing | 60 | 60 | 162 N
Swing | 80 | 40 | 162 N
Swing | 95 | 34.5 | 162 N
Min | -20 | 60 | 101 N
Min | 20 | 60 | 101 N
Min | 60 | 60 | 101 N
Min | 80 | 40 | 101 N
Min | 95 | 34.5 | 101 N
* Includes 6% for general parasitic and transformer losses plus chiller parasitic loads depending on the amount of chilling being done.
Spreadsheet: 6a477148-d5f4-4dcd-a4e5-4317be7cc6aa
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
43583872 | 2014-10-14 22:51:58 | ALLIES | 1 | 5 | 3 | 752090 | lespieuch | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
43584090 | 2014-10-14 23:05:57 | AXIS | 0 | 4 | 5 | 752090 | lespieuch | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
Spreadsheet: drew_fossum__8691__gallup mods-k
Sheet: GALLUP MODS K FILING

 |  | 128a | 128b | 129 | 131 |  |  |  |  |  |  |  |  |  |  |  | 148 | 149
Description | Total Cost | Inservice | Status of | Project | Information | Right of |  |  |  | Engineering & |  |  | Telecomm. |  |  |  | Other Services | Regulatory
 |  | Date | Construction | Number | Reported | Way | Surveys | Materials | Labor | Inspection | Taxes | Freight | Equip | Overheads | AFUDC | Contingencies | and Costs | Fees
GALLUP DRIVE MODS | 2971000 |  |  |  | 1 | 0 | 0 | 1002000 | 945000 | 282000 | 40000 | 20000 | 0 | 254000 | 127000 | 301000
GRAND TOTAL
 | [NAME]: THE MOTOR WILL BE A 15,000 H.P. DRIVE WITH A 1.2 SERVICE FACTOR.
[NAME]: IF THE SERVICE FACTOR IS NOT CORRECT, PLEASE LET DONNA KNOW THE CORRECT FACTOR
Freight & tax amounts reduced and $$ moved into material and labor cat. (These items included in invoices for vendors and contractors and not broken out in accounting)
Spreadsheet: eric_saibi__9697__010202R
Sheet: Cooper 01

Owner Name |  | Nebraska Public Power
Station Name |  | Cooper Nuclear Station
Unit Name |  | Cooper 01
NERC Region |  | MAPP
State |  | NE
Fuel Type |  | Nuclear
Capacity |  | 836 MW
Start Date |  | 2001-11-03 00:00:00
End Date |  | 2002-12-26 00:00:00
Prv. Start Date |  | 2001-11-03 00:00:00
Prv. End Date |  | 2002-01-06 00:00:00
Comments |  | Refuel
SIC |  | 4911
Plant ID |  | 1014366
Unit ID |  | 1008642
Outage ID |  | 7457
Spreadsheet: 839270d1691774795-return-different-matches-that-contains-part-of-the-searched-text-excel-formula-help
Sheet: Sheet1

apple | apple1 | apple1
melon | melon1 | apple2
pear | pear1 | [NAME]
apple | apple2 | apple4
melon | [NAME] | apple5
melon | #N/A | pear1
melon | #N/A | pear2
pear | pear2 | pear3
apple | [NAME] | melon1
 |  | [NAME]
 |  | apple6
 |  | [NAME]
Spreadsheet: 766674d1643992340-populating-cells-with-data-from-another-sheet-using-dropdown-managementcoveragesample
Sheet: Overlap

Select Supervisor Below | List |  | Name | Schedule | Overlap
[NAME] | [NAME] |  |  |  | 80
 | [NAME] |  |  |  | 70
 |  |  |  |  | 70
 |  |  |  |  | 50.5
 |  |  |  |  | 45
Spreadsheet: b2e97c42-0da7-4b1d-a6fd-6a8d7dee9798
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Patuxent River for 2010
Indicator | 2010
Chlorophyll a | 5.866
Aquatic Grasses | 11.87
[NAME] | 67.444
[NAME] | 24
Water Clarity | 4.87
Phytoplankton Index | 28.41
Water Quality Index | 26.06
Biotic Index | 21.42666667
Bay Health Index | 23.74333333
Spreadsheet: 38624d1236777051-cant-paste-formulas-through-cells-vlookup-check
Sheet: Sheet5

CODE | ID
00 | TR126128
AA1
N28 | DM108529
N35 | RB0030
N37 | DB129819
N94 | CR108114
N95 | CR108114
N96 | CR108114
N97 | CR108114
N99 | DL104514
NA1 | NC120464
NA2 | CR108114
NA3 | CR108114
NA4 | CR108114
NA5 | CR108114
NA6 | CR108114
NA7 | NC120464
NA8 | NC120464
NB1 | PM129398
NB2 | RW0397
NB3 | AB1498
NC1 | TW134811
NC2 | AG120172
NC3 | AG120172
NC6 | NC120464
ND1 | DM108529
ND6 | DL104514
ND7 | DL104514
ND8 | DM108529
ND9 | DL104514
NE2 | DM108529
NE6 | DL104514
NE7 | DL104514
NF5 | NC120464
NF6 | CR108114
NF7 | CR108114
NF8 | NC120464
NF9 | CR108114
NG1 | DL104514
NG3 | DL104514
NG4 | DM108529
NH1 | DM108529
[NAME] | DM108529
NH3 | DL104514
NH7 | DL104514
NH8 | DM108529
NI1 | DL104514
NI2 | DL104514
NI4 | DL104514
NJ1 | DK134482
NK1 | IG1011
S01 | RA113722
S02 | RA113722
S03 | RA113722
S04 | RA113722
S05 | SR0574
S06 | RA113722
S21 | RA113722
S22 | RM106037
S23 | RM106037
S79 | RM106037
SB6 | SC0472
SF3 | RM106037
SJ2 | RA113722
TA1 | FB0696
TA2 | FB0696
TA4 | FB0696
TA5 | FB0696
[NAME] | FB0696
[NAME] | FB0696
TB3 | FB0696
TB4 | FB0696
TB5 | FB0696
TB6 | FB0696
TB7 | FB0696
TB9 | FB0696
TC1 | FB0696
TC2 | BS0907
TC3 | FB0696
TC4 | FB0696
TC5 | FB0696
TC6 | FB0696
TC7 | FB0696
TC8 | FB0696
TC9 | FB0696
TD1 | FB0696
TD2 | FB0696
TD3 | FB0696
TD4 | FB0696
TD7 | FB0696
W01 | MW120109
W02 | MW120109
[NAME] | JJ134793
W04 | AG128967
[NAME] | AG128967
W06 | LB107311
W07 | LB107311
W08 | AG128967
W09 | AG128967
W10 | LB107311
W11 | LB107311
W12 | GB1008
W13 | GB1008
W14 | BM0256
W15 | BM0256
W16 | AF0115
W17 | AF0115
W18 | MW120109
W19 | MW120109
W20 | AW129409
W21 | TR126128
[NAME] | NW135546
W23 | TR126128
W24 | NS134404
W25 | SH1045
W26 | NW135546
[NAME] | RH1655
W28 | RH1655
W29 | FP0462
W30 | TR126128
W31 | RH1655
W32 | RH1655
W33 | JH134430
[NAME] | TR126128
W38 | PS0465
W39 | MW120109
W41 | JM123855
W42 | LB107311
W43 | JM123855
W44 | JM123855
W45 | TA0012
W46 | TA0012
W47 | LB107311
[NAME] | FP0462
[NAME] | TR126128
W50 | GB1008
W51 | NW1026
W52 | GB1008
W53 | GB1008
W54 | ES1083
W55 | GB1008
W56 | LB107311
W57 | LB107311
W58 | ES1083
W59 | ES1083
W60 | AF0807
W61 | MW120109
W62 | AF0115
W63 | MW120109
W64 | GG120177
W65 | AF0115
W66 | JJ134793
W67 | MW120109
[NAME] | AG128967
W69 | AG128967
W70 | AG128967
W71 | AG128967
W72 | JT0359
W73 | PS0465
W75 | TA0012
[NAME] | MG0142
W77 | TA0012
W80 | NC2317
W81 | LB107311
W83 | BM0256
W84 | TL122190
W85 | NW135546
W86 | TL122190
W87 | JH134430
W88 | BL0801
W90 | RW127880
W91 | JM123855
W92 | BM0256
W93 | BM0256
W98 | RH1655
W99 | PS0340
WA2 | RJ0630
WA4 | RJ0630
WA9 | BB113389
WB2 | MW128629
WC0 | MG0142
WC3 | GB1008
WC4 | RJ0630
WC6 | JL127250
WC7 | GB1008
WC8 | GB1008
WC9 | TA0012
WD2 | CH114360
WD3 | FP0462
WD4 | JL127250
WD5 | JD105719
WD6 | GB1008
WE1 | MG0142
WE2 | TR126128
WE3 | ES1083
WE4 | HD0239
WE5 | JF102178
WE8 | GB1008
WF1 | AB0025
WFP | FP0462
WFS | AG128967
WG1 | NW135546
WG7 | RM0234
WG9 | PS108517
WH5 | TA0012
WH9 | JL127250
WJ1 | BL0801
WJL | JL127250
WK1 | AF0115
WK2 | MW120109
WOT | FB0696
Spreadsheet: 1f7df3c1-ca37-4456-b394-b5b43ffa6166
Sheet: vols added monographs

Monograph Volumes Added FY09 and FY10
Monograph Volumes Added by Acquisition Type FY09 and FY10 (Kingston only)
Acquisition Type | FY09 | FY10 | % change | % of total FY10 vols.
Approval Plan (Strand) | 4224 | 3908
Firm orders | 3037 | 3507
Standing orders | 168 | 218
Gifts | 2370 | 3899
TOTALS
Average Price of Monograph FY09 and FY10 (Kingston only)
 | FY09 | FY10 | % change
Amount spent | 315017.47 | 347375.7
[NAME] purchased
Average price paid per volume
Spreadsheet: 122851d1317207241-excel-2007-using-indirect-formula-properly-stock-dummy
Sheet: Expenditure

Product | Code | Date | Unit Cost | Quantity | VAT ? | Total Cost (no VAT) | Total Cost inc VAT | Total Expenditure |  | Stock update
[NAME] | TF03 | 2011-09-23 00:00:00 | 2.48 | 4 | y
[NAME] | DC51 | 2011-09-24 00:00:00 | 2.19 | 3 | y
[NAME] | TF07 | 2011-09-24 00:00:00 | 2.48 | 6 | y
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W91QUZ-07-D-0009-9L29

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W91QUZ-07-D-0009-9L29 | 4504976709 | 1KH72 | 1F | 1 | 4 | [NAME] | 2013-01-28 00:00:00 | 2013-01-29 00:00:00 |  | 5080.64 |  | 5100797579 |  |  |  |  |  |  |  |  |  | Waiting 105
 |  |  |  | 2 | 4 | [NAME] | 2013-01-28 00:00:00 | 2013-01-29 00:00:00 |  |  |  | 5100797579
 |  |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | Free for Payment
RETURN
Spreadsheet: 806046d1669075517-check-qualification-based-on-multiple-criteria-using-a-table-with-logic-operators-qualification-test-jdutle-
Sheet: Sheet2

Tier 1 - Must have at least $1m in current business
-AND
--1. - At least 10 new client sales worth at least $250,000 in new sales
--OR
--2. - At least $500,000 in new sales
[NAME] have less than $1m in current business
-AND
--1. - At least 10 new client sales worth at least $100,000 in new sales
--OR
--2. - At least $250,000 in new sales
Current Amounts (Input) |  |  |  | Output
Current Business | New Clients | New Sales $ |  | Tier | Sub-Tier
1000000 | 10 | 500000
 |  | Check against input |  |  |  | Check against input |  |  |  | Check against input |  |  | [NAME]
Symb.1 | Current Business $ | Test | Operator1 | Symb.2 | New Clients | Test2 | Operator2 | [NAME] | New Sales $ | Test3 | Tier | Sub-Tier | [NAME] | [NAME]
>= | 1000000 |  | AND | >= | 10 |  | AND | > | 250000 |  | Tier 1 | 1
>= | 1000000 |  | AND | >= | N/A |  | OR | > | 500000 |  | Tier 1 | 2
< | 1000000 |  | AND | >= | 10 |  | AND | > | 100000 |  | [NAME] | 1
< | 1000000 |  | AND | >= | N/A |  | OR | > | 250000 |  | [NAME] | 2
 |  |  |  | Output
 |  |  |  | Tier | Sub-Tier
Symb.1 | Current Business $ | Test | Operator1 | Symb.2 | New Clients | Test2 | Operator2 | [NAME] | New Sales $ | Test3 | Tier | Sub-Tier | [NAME] | [NAME]
>= | 1000000 |  | AND | >= | 10 |  | AND | > | 250000 |  | Tier 1 | 1
>= | 1000000 |  | AND | >= | 0 |  | OR | > | 500000 |  | Tier 1 | 2
> | 0 |  | AND | >= | 10 |  | AND | > | 100000 |  | [NAME] | 1
> | 0 |  | AND | >= | 0 |  | OR | > | 250000 |  | [NAME] | 2
Spreadsheet: 9f5d407c-35f1-4789-8cee-d5f90c159667
Sheet: SW801

SW | SUV | PS# | Ln | Item | Description | UOM | $ | Cat | Cat Desc
SW801 | Kiamichi | 2193 | 1 |  |  |  | 13.9 |  | Condoms
Spreadsheet: 190100d1351525109-find-the-sum-of-12-non-blank-cells-example
Sheet: Sheet1

1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1
 |  | 11
sum of | A2 to M2
sum of | A3 to C6
Spreadsheet: 194965d1353372460-help-with-bar-charts-or-something-better-to-compare-two-year-sales-charting-query-compare-2011-vs-2012
Sheet: PRODUCTS

Line Text | Corneal
Sales org. | 3580
Sold-to Name | (Multiple Items)
Sum of   Netinv.sls | Period
Brand Text | 1.2011 | 2.2011 | 3.2011 | 4.2011 | 5.2011 | 6.2011 | 7.2011 | 8.2011 | 9.2011 | 10.2011 | 11.2011 | 12.2011 | Grand Total
Blink ' n' Clean | 157.92 | 52.64 | 217.14 | 78.96 | 52.64 | 118.44 | 65.8 |  | 118.44 | 19.74 | 263.2 |  | 1144.92
Blink Contacts | 22.35 |  | 7.45 |  |  | 39.48 | 44.7 |  | 44.7 | 13.16 | 19.74 | 19.74 | 211.32
[NAME] | 10.89 |  | 199.44 | 43.56 | 21.78 | 56.16 | 10.89 | 21.78 | 36.3 | 36.3 | 83.49 | 67.05 | 587.64
Complete B Minus | 63.78 | 155.28 | 406.86 | 310.56 | 1009.32 | 191.76 | 155.28 | 323.5 | 561.72 | 658.57 | 491.72 | 32.1 | 4360.45
Complete Upgrade B | 888.25 | 224.4 | 1009.8 | 673.2 | 561 | 673.2 | 374 | 785.4 | 1122 | 673.2 | 1009.8 | 673.2 | 8667.45
Lens Plus Ocupure | 115.2 |  | 57.6 | 14.4 | 124.8 |  | 9.6 | 33.6 | 24 | 28.8 | 72 | 96 | 576
Omnicare | 614.32 |  | 394.92 |  |  | 263.28 | 65.82 | 175.52 | 21.94 | 263.28 |  | 263.28 | 2062.36
[NAME] |  |  |  |  |  | 715.32 | 402.12 | 155.4 |  | 12 | 149.22 |  | 1434.06
Total Care 1 | 204.96 |  | 102.48 |  | 153.72 | 204.96 |  |  | 187.88 | 8.54 | 128.1 | 111.02 | 1101.66
Ultrazyme Enzyme | 189.93 |  |  | 175.32 | 14.61 | 87.66 |  |  |  | 29.22 | 58.44 | 87.66 | 642.84
Grand Total | 2267.6 | 432.32 | 2395.69 | 1296 | 1937.87 | 2350.26 | 1128.21 | 1495.2 | 2116.98 | 1742.81 | 2275.71 | 1350.05 | 20788.7
Line Text | (All)
Sales org. | (All)
Sold-to Name | (Multiple Items)
Sum of  Netinv.sls | Period
Brand Text | 1.2012 | 2.2012 | 3.2012 | 4.2012 | 5.2012 | 6.2012 | 7.2012 | 8.2012 | 9.2012 | 10.2012 | Grand Total
Blink ' n' Clean | 157.92 | 78.96 |  | 39.48 | 223.72 | 78.96 | 39.48 |  |  |  | 618.52
Blink Contacts | 39.48 |  | 39.48 |  | 59.22 | 78.96 |  |  | 39.48 |  | 256.62
[NAME] | 21.78 | 135.81 | 49.86 | 90.54 | 10.89 | 43.56 | 21.78 |  | 21.78 |  | 396
Complete B Minus | 176.68 | 310.56 | 182.03 | 492.59 | 675.99 | 497.94 | 653.22 | 155.28 | 1358.7 | 310.56 | 4813.55
Complete Upgrade B | 836.4 | 617.1 | 224.4 |  |  |  |  |  |  |  | 1677.9
Lens Plus Ocupure | 62.4 | 110.4 | 81.6 | 28.8 | 57.6 | 57.6 | 57.6 |  | 14.4 |  | 470.4
Omnicare | 197.46 |  |  | 43.88 | 131.64 | 263.28 | 329.1 |  |  |  | 965.36
[NAME] | 0 | 155.69 | 18 | 47.61 | 76.5 |  | 54 |  |  |  | 351.8
Total Care |  |  |  |  |  | 0 |  |  |  |  | 0
Total Care 1 |  | 128.1 |  |  | 51.24 | 102.48 |  |  |  |  | 281.82
Ultrazyme Enzyme | 58.44 | 116.88 | 14.61 |  | 146.1 |  | 175.32 | 87.66 | 29.22 |  | 628.23
Grand Total | 1550.56 | 1653.5 | 609.98 | 742.9 | 1432.9 | 1122.78 | 1330.5 | 242.94 | 1463.58 | 310.56 | 10460.2
Spreadsheet: kevin_hyatt__19614__SunDevil01CostSummary
Sheet: EPSunDevil

El Paso Sun Devil Competitor Analysis
 |  |  |  | Low End Cost | High End Cost | Comments
Case 1 | San Juan Junction to Phoenix (new pipe) | [NAME] | 440 |  |  | This option assumes El Paso is currently full and to get gas from San Juan they would have to build out like we are.
 |  | Added Compression | 25000
 |  | Total Cost:
Case 2 | Waha, Texas to Phoenix (Line 2000 orig. empty) | [NAME] | 570 | 0 | 0 | This case is more to serve as a benchmark since Line 2000 is already slated to handle some capacity in a looping capacity, of El Paso's southern, low pressure line.  No p/l cost since purchase price is sunk.
 |  | Added Compression | 32000
 |  | Total Cost:
Case 3 | Waha, Texas to Phoenix (Line 2000, 450 added to existing est. 320 mm/d) | [NAME] | 570 | 0 | 0 | This case assumes that El Paso's Line 2000 is already in partial use and that the incremental 450 mm/d would have to come on top of the existing flows (estimated at 320 mm/d).  Takes the line to 770 mm/d.  This is also at the [NAME] capabilities of this line without looping.
 |  | Added Compression | 220000
 |  | Total Cost: