tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 298819d1392914823-need-help-with-a-formula-to-change-text-to-the-proper-format-zywave-truckers-1-5
Sheet: Sheet1

CARRIER NAME
AC TRANSPORT
AC TRANSPORT
AC TRANSPORT
AGA TRANSPORTATION INC
AGA TRANSPORTATION INC
ALFA TRANSPORT
ALFA TRANSPORT
ALIC TRUCKING
ALIC TRUCKING
ANGULOS TRUCKING
ANGULOS TRUCKING
ATI
ATI
BIG DOG TRANSPORT
BIG DOG TRANSPORT
CARLOS TRUCKING
CARLOS TRUCKING
D AND P TRUCKING LLC
D AND P TRUCKING LLC
D AND R ENTERPRISES
D AND R ENTERPRISES
DAVIDS TRUCKING
DAVIDS TRUCKING
DOUBLE TIME EXPRESS
DOUBLE TIME EXPRESS
EAGLE EXPRESS TRANSPORT INC
EAGLE EXPRESS TRANSPORT INC
ESPINOSA TRUCKING
ESPINOSA TRUCKING
GARRETT TRUCKING
GARRETT TRUCKING
GM EXPRESS LLC
GM EXPRESS LLC
HENSON TRUCKING
HENSON TRUCKING
HERRERA TRUCKING
HERRERA TRUCKING
HERRERA TRUCKING
J AND D TRUCKING
J AND D TRUCKING
J AND E TRANSPORT
J AND E TRANSPORT
J AND J EXPRESS
J AND J EXPRESS
J AND J TRANSPORT
J AND J TRANSPORT
J AND R TRUCKING
J AND R TRUCKING
KENNEDY EXPRESS LLC
KENNEDY EXPRESS LLC
MIKES TRUCKING
MIKES TRUCKING
NAHAL TRUCKING
NAHAL TRUCKING
OCEAN EXPRESS
OCEAN EXPRESS
QUALITY TRANSPORT
QUALITY TRANSPORT
R AND B EXPRESS INC
R AND B EXPRESS INC
S AND S EXPRESS LLC
S AND S EXPRESS LLC
TOP GEAR TRUCKING INC
TOP GEAR TRUCKING INC
WESTERN TRANSPORTATION LLC
WESTERN TRANSPORTATION LLC
[NAME] TRUCKING
[NAME] TRUCKING
Spreadsheet: 723897d1615934715-how-to-get-the-sheet-name-from-a-cell-value-example
Sheet: Supplier_3

Item | Name | PL-code | Price
[NAME] | WHEEL1 | 45 | 58
C3333302 | WHEEL2 | 45 | 62
C3333303 | WHEEL3 | 45 | 14
C3333304 | WHEEL4 | 46 | 35
[NAME] | WHEEL5 | 46 | 89
C3333306 | [NAME] | 46 | 24
C3333307 | WHEEL7 | 47 | 65
C3333308 | WHEEL8 | 47 | 48
C3333309 | [NAME] | 47 | 34
Spreadsheet: joe_parks__14555__quotesheet
Sheet: 12-4 morning

Large Deal Quote Sheet (Generic)
Date & Time of Quote | Prompt Merc price, and commodity | Dealer/Third Party | Market/Location | Term | Notional Amount | Bid/Ask
2001-12-04 09:00:31.390000 | Jan '02 | Natsource | Permian | Jan - Mar '02 | 10,000/d | -.1375 @ -.13
2001-12-04 09:00:31.390000 | Jan '02 | Natsource | Waha | Jan - Mar '02 | 10,000/d | -.12 @ -.11
2001-12-04 09:00:31.390000 | Jan '02 | Natsource | HSC | Jan - Mar '02 | 10,000/d | -.02 @ -.015
2001-12-04 08:53:10.230000 | Jan '02 | APB | Permian | Jan - Mar '02 | 10,000/d | -.1325 @ -.1225
2001-12-04 08:53:10.230000 | Jan '02 | APB | Waha | Jan - Mar '02 | 10,000/d | -.115 @-.105
2001-12-04 08:53:10.230000 | Jan '02 | APB | HSC | Jan - Mar '02 | 10,000/d | -.02 @ -.015
2001-12-04 08:51:00.320000 | Jan '02 | Amerex | Permian | Jan - Mar '02 | 10,000/d | -.135 @ -.125
2001-12-04 08:51:00.320000 | Jan '02 | Amerex | Waha | Jan - Mar '02 | 10,000/d | -.115 @
2001-12-04 08:51:00.320000 | Jan '02 | Amerex | HSC | Jan - Mar '02 | 10,000/d | -.0175 @ -.015
Spreadsheet: 784782d1655956403-data-is-required-in-a-singale-row-sample
Sheet: Summary

 | Require Data
 |  |  |  |  |  |  | Flag
Sr. No | Emp Name | Date | Poster | Location | Gate | Purcpose | O | I
1 | xyz | 2022-05-12 00:00:00 | a | Other Official (Sangam | Malpani House | Register Office | 12.02 | 12.37
2 | xyz | 2022-06-20 00:00:00 | b | Other Official (Sangam | Malpani House | Bank Of Maharashtra | 14.44
 | abc | 2022-01-12 00:00:00 | c | Other Official (Sangam | [NAME] | official work | 16.08 | 16.42
 | abc | 2022-01-20 00:00:00 | d | Other Official (Sangam | [NAME] | official work |  | 16.42
Spreadsheet: 70903d1271670838-dropdown-menu-for-tables-cello
Sheet: Sheet1

 |  |  | When selecting table from the dropdown box, excel shoul collect data from the selected table and write it where the table A is now right next to dropdownbox
 | Dropdownbox
 | [NAME] |  | [NAME] | 1000 | 2000 | 3000 | 4000 | 5000 | 6000 | 7000 | 8000
 |  |  | 100 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 200 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 300 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 400 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 500 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 600 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 700 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 800 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TableB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TableC
All the three tables coul be in another sheet or just somewere not to be seen. |  |  | TableB | 500 | 1000 | 1500 | 2000 | 2500 | 3000 | 3500 | 4000
 |  |  | 50 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 100 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 150 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 200 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 250 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 300 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 350 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | 400 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645 | 5645
 |  |  | TableC | 2000 | 3000 | 4000 | 5000 | 6000 | 7000 | 8000 | 9000
 |  |  | 200 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 300 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 400 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 500 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 600 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 700 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 800 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | 900 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734 | 34734
 |  |  | [NAME] | 1000 | 2000 | 3000 | 4000 | 5000 | 6000 | 7000 | 8000
 |  |  | 100 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 200 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 300 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 400 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 500 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 600 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 700 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
 |  |  | 800 | 235 | 235 | 235 | 235 | 235 | 235 | 235 | 235
Spreadsheet: larry_campbell__20992__PCB Graphs
Sheet: 0.55B

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Lab
PGE Mile pt. |  |  | 1999-11-03 00:00:00 |  |  | 14 |  | Sherwood
0.55 B side |  |  | 1999-11-18 00:00:00 |  |  | 26 |  | Sherwood
 |  |  | 1999-11-24 00:00:00 |  |  | 44 |  | Sherwood
 |  |  | 1999-12-01 00:00:00 |  |  | 47 |  | Sherwood
 |  |  | 1999-12-08 00:00:00 |  |  | 30 |  | Sherwood
 |  |  | 1999-12-14 00:00:00 |  |  | 21 |  | Sherwood
 |  |  | 1999-12-29 00:00:00 |  |  | 29 |  | Sherwood
 |  |  | 2000-01-05 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-01-19 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-02-09 00:00:00 |  |  | 29 |  | Sherwood
 |  |  | 2000-03-01 00:00:00 |  |  | 23 |  | Sherwood
 |  |  | 2000-03-22 00:00:00 |  |  | 10 |  | Sherwood
 |  |  | 2000-04-05 00:00:00 |  |  | 20 |  | Sherwood
 |  |  | 2000-04-19 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-05-03 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-05-17 00:00:00 |  |  | 11 |  | Sherwood
 |  |  | 2000-05-31 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-06-14 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-06-21 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2000-06-27 00:00:00 |  |  | 19 |  | Sherwood
 |  |  | 2000-07-05 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-08-09 00:00:00 |  |  | 13 |  | Sherwood
 |  |  | 2000-09-20 00:00:00 |  |  | 8 |  | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 5 |  | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 5 |  | Sherwood
 |  |  | 2000-12-13 00:00:00 |  |  | 4 |  | Sherwood
 |  |  | 2001-02-14 00:00:00 |  |  | 3 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: andy_zipper__162__DYNEGY-ICE VOL Apr4
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-4-01 thru Apr-4-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-04-01 | 144953240 |  | Bought | NG Fin, FP for LD1 | [NAME] | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | AEP Energy Services, Inc. | 5.35 | USD / MMBtu | 2500 | Daily | 377500 | MMBtus | [NAME], J
Apr-04-01 | 122345508 |  | Sold | NG Fin, FP for LD1 | [NAME] | [NAME] | May-01-01 | Oct-31-01 |  |  |  | AEP Energy Services, Inc. | 5.24 | USD / MMBtu | 5000 | Daily | 920000 | MMBtus | [NAME], J
Apr-04-01  Deals
Spreadsheet: 0b106858-f810-4a98-959f-8ed217704ea5
Sheet: Instructions Sheet

FINANCIAL DISCLOSURE FORM INSTRUCTIONS SHEET
________________________ v. _______________________
Case Number ______________________________
Pages 1 through 4, 5 through 6 and 7 through 10 are mandatory.  Please fill out the number of pages used, if any, for the remaining supplemental sheets.
Page No. | Sheet Name |  |  |  |  |  |  | No. of Pages
Page 1 | General Information |  |  |  |  |  |  | 1
Page 2 | Income & Expense Summary |  |  |  |  |  |  | 1
Page 3 | Personal Gross Income Worksheet |  |  |  |  |  |  | 1
Page 4 | Personal Deductions Worksheet |  |  |  |  |  |  | 1
Page 5 | Personal Expense Worksheet Necessities |  |  |  |  |  |  | 1
Page 6 | Personal Expense Worksheet Discretionary Expenses |  |  |  |  |  |  | 1
Page 6(a) | Additional Real Property Worksheet (complete if you own real property not occupied by you or your spouse) |  |  |  |  |  |  | ______
Page 6(b) | Additional Vehicles Worksheet (complete if you own more than 2 vehicles) |  |  |  |  |  |  | ______
Page 6(c ) | Child(ren)'s Personal Expense Worksheet (complete if you have children of this relationship) |  |  |  |  |  |  | ______
Page 7 | Asset and Debt Worksheet |  |  |  |  |  |  | 1
Page 8 | Asset and Debt Worksheet |  |  |  |  |  |  | 1
Page 9 | Signature Page |  |  |  |  |  |  | 1
Page 10 | Certificate of Service |  |  |  |  |  |  | 1
TOTAL NUMBER OF PAGES ATTACHED
Spreadsheet: 793627d1661588302-help-for-lookup-value-of-multiple-criteria-for-two-date-range-23
Sheet: Data

 | Date from | Date to | Group | SEND TO PARTY | IN HAND
 | 2022-04-01 00:00:00 | 2022-04-15 00:00:00 | Group 1
 |  |  | Group 2
 |  |  | Group 3
 |  |  | Group 4
 |  |  | Group 5
 |  |  | Group 6
 |  |  | Group 7
 |  |  | Group 8
 |  |  | Group 9
 |  |  | Group 10
 |  |  | Group 11
 |  |  | Group 12
 |  |  | Group 13
 |  |  | Group 14
 |  |  | Group 15
 |  |  | Group 16
 |  |  | Group 17
 |  |  | Group 18
 |  |  | Group 19
 |  |  | Group 20
 |  |  | Group 21
 |  |  | Group 22
 |  |  | Group 23
 |  |  | Group 24
Spreadsheet: 743800d1628733074-conditional-function-with-arrays-issue-to-solve-a-problem-conditional-function-problem-josephteh
Sheet: example

 |  |  | Table 1 : Main data |  |  |  |  |  | Table 2 : Sequence of the work
 |  |  | Code Activity | Activity | Code  Worker | Worker | Number of Worker |  |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00
 |  |  | A1 | Lunch room | W4 | Painter | 2 |  | A1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0
 |  |  | A1 |  | W1 | Labourer | 3 |  | A2 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0
 |  |  | A1 |  | W3 | Electrician | 2 |  | A3 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0
 |  |  | A2 | Bathroom | [NAME] | Plumber | 2 |  | A4 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0
 |  |  | A2 |  | W1 | Labourer | 1 |  | A5 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  |  | A2 |  | [NAME] | Builder | 3
 |  |  | A3 | Lockers | W1 | Labourer | 3 |  | Table 3 : Total number of worker per month
 |  |  | A3 |  | [NAME] | Builder | 4
 |  |  | A4 | Kitchen | W3 | Electrician | 1 |  |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00
 |  |  | A4 |  | W4 | Painter | 1 |  | W1
 |  |  | A5 | Main room | W3 | Electrician | 1 |  | [NAME]
 |  |  | A5 |  | W1 | Labourer | 2 |  | W3
 |  |  | A5 |  | W4 | Painter | 1 |  | W4
 |  |  | A5 |  | [NAME] | Builder | 5 |  | W5
Spreadsheet: 163420d1340295219-using-a-not-modifier-within-search-weeble33_sumproduct_count_search_include_exclude_20jun12_01
Sheet: Sheet1

BR5-45WH-XL (SP1) | 15 |  | 13 |  | br5 | 45wh |  | 13 | >>>
BR5-45WH-5XLL | 20 |  | ↓ |  |  |  |  |  |  | the above is a CSE formula.
BR5-45WH-S | 13
BR5-45WH-8XL | 17 |  | the above is a regular formula.
BR6-49RB-5XLL | 22
Spreadsheet: 919ddfcf-dbd3-4338-87cf-59e0b8781f37
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-10-21 09:32:26.200000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.625 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.5 | 101.926 | 101.801 | 101.676 | 101.301
4.375 | 101.104 | 100.979 | 100.854 | 100.479 |  | Note: | Refer To Price [NAME]
4.25 | 100.587 | 100.462 | 100.337 | 99.962 |  |  | For all Price Adjs
4.125 | 99.819 | 99.694 | 99.569 | 98.944
4 | 98.859 | 98.734 | 98.609 | 97.984
3.875 | 97.844 | 97.719 | 97.594 | 96.969
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.125 | 102 | 101.875 | 101.5
3.625 | 101.977 | 101.852 | 101.727 | 101.352
3.5 | 101.462 | 101.337 | 101.212 | 100.837
3.375 | 100.71 | 100.585 | 100.46 | 100.085
3.25 | 99.986 | 99.861 | 99.736 | 99.111
3.125 | 99.206 | 99.081 | 98.956 | 98.331
3 | 98.674 | 98.549 | 98.424 | 97.799 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-11-04 09:32:26.200000
30 DAY | 2013-11-19 09:32:26.200000
45 DAY | 2013-12-04 09:32:26.200000
60 DAY | 2013-12-19 09:32:26.200000
90 DAY | 2014-01-18 09:32:26.200000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 773960d1648134201-vlookup-index-function-error-example-4
Sheet: By Employee

Employee ID | Task Order | Employee Name | 2021-12-15 00:00:00 | 2021-12-31 00:00:00 | 2022-01-15 00:00:00 | 2022-01-31 00:00:00 | 2022-02-14 00:00:00 | 2022-02-28 00:00:00 | 2022-03-15 00:00:00 | 2022-03-31 00:00:00 | 2022-04-15 00:00:00
 |  |  | 80 | 88 | 80 | 80 | 80 | 72 | 88 | 96 | 88
 | [NAME], [NAME] |  |  |  |  |  |  |  |  |  |  |  | Answer:
 |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | 01 AA.AD | [NAME], [NAME] | 0 | 0 | 0 | 5 | 0 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | 02 AC.AD | [NAME], [NAME] | 0 | 5 | 5 | 5 | 5 | 5 | 5
 |  | Total Hours:
 |  | Extra Hours: |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Extra Hours:
2403 | Doe, [NAME] |  |  |  |  |  |  |  |  |  |  |  | 2403 | Doe, [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 2403 | 01 AA.AD | Doe, [NAME] | 0 | 0 | 0 | 0 | 0 | 9 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 2403 | 02 AC.AD | Doe, [NAME] | 0 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | 2403 | 85 AC.AD | Doe, [NAME] | 0 | 10 | 10 | 10 | 10 | 10 | 10 |  |  | Row295
 |  | Total Hours: |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours:
 |  | Extra Hours: |  |  |  |  |  |  |  |  |  |  |  |  | Extra Hours:
 | Fisher, Mary
 |  | Total Hours:
 |  | Extra Hours:
1920 | [NAME], [NAME]
 |  | Total Hours:
 |  | Extra Hours:
Spreadsheet: eric_saibi__9690__122101
Sheet: Diablo Canyon 02

Owner Name |  | Pacific Gas & Electric
Station Name |  | Diablo Canyon Nuclear Power Station
Unit Name |  | [NAME]
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Nuclear
Capacity |  | 1,164 MW
Start Date |  | 2001-12-20 00:00:00
End Date |  | 2001-12-21 00:00:00
Comments |  | Unit was derated about 20% due to Pacific storm in the area. So they decreased power to prevent seaweed from clogging the intakes, However the storm was not as severe as anticipated. They are now powering back up to 100%.
SIC |  | 4911
Plant ID |  | 1016043
Unit ID |  | 1004944
Outage ID
Spreadsheet: 142596d1329924606-vlookup-and-col_index_num-issue-financial-statements_vlookup_question
Sheet: Actual v. Budget

 |  |  |  |  |  |  |  | Actual |  |  | Budget
 | Year | 2012 |  | Revenue
 | Month | 1 |  |  | A
 |  |  |  |  | B
 |  |  |  |  | C
 |  |  |  |  | D
 |  |  |  |  | E
 |  |  |  |  | F
 |  |  |  |  | G
 |  |  |  | Total Revenue
 |  |  |  | Cost of Goods Sold
 |  |  |  |  | 1
 |  |  |  |  | 2
 |  |  |  |  | 3
 |  |  |  |  | 4
 |  |  |  |  | 5
 |  |  |  |  | 6
 |  |  |  |  | 7
 |  |  |  |  | 8
 |  |  |  | Total COGS
 |  |  |  | Gross Margin
 |  |  |  | R&D Expense
 |  |  |  |  | Payroll
 |  |  |  |  | Bonus / Commission
 |  |  |  |  | Payroll Tax
 |  |  |  |  | Variable Expense
 |  |  |  |  | R&D Other Expense
 |  |  |  | Total R&D Expense
 |  |  |  | Sales Expense
 |  |  |  |  | Payroll
 |  |  |  |  | Bonus / Commission
 |  |  |  |  | Payroll Tax
 |  |  |  |  | Travel & Entertainment
 |  |  |  |  | Marketing
 |  |  |  |  | Software Expense
 |  |  |  | Total Sales Expsense
 |  |  |  | Administrative Expense
 |  |  |  |  | Payroll
 |  |  |  |  | Bonus / Commission
 |  |  |  |  | Payroll Tax
 |  |  |  |  | Recruiting Expense
 |  |  |  |  | Professional Fees
 |  |  |  |  | Insurance Expense
 |  |  |  |  | Rent Expense
 |  |  |  |  | Utilities Expense
 |  |  |  |  | Employee Benefit Plan Expense
 |  |  |  |  | Office Expense
 |  |  |  |  | Office Equipment
 |  |  |  |  | Office Supplies
 |  |  |  |  | Telephone & Internet Expense
 |  |  |  |  | Depreciation Expense
 |  |  |  |  | Bad Debt Expense
 |  |  |  |  | Other
 |  |  |  | Total Admin Expense
 |  |  |  | Total Operating Expense
 |  |  |  | Operating Profit (EBIT)
 |  |  |  | EBITDA
 |  |  |  | Net Income
Spreadsheet: 747431d1631502579-how-to-calculate-commission-and-bonus-with-conditions-in-excel-formulas-or-vb-script-book1
Sheet: Sheet1

Product ID | Product Name | Initial Date | Main Product (Product ID) | No. of Sub-Products | Category Name | Category Price | Commission | Bonus |  | Category Name | Category Price | Bonuse Amount | Product Level | Category1 Commissions | Category2 Commissions
394 | Products1 | 2021-04-30 00:00:00 | 0 |  | Category2 |  |  | 0 |  | Category1 | 100 | 10 | 1 | 30 | 50
395 | Products2 | 2021-04-30 00:00:00 | 394 |  | Category1 |  |  | 20 |  | Category2 | 450 | 20 | 2 | 20 | 40
396 | Products3 | 2021-09-01 00:00:00 | 395 |  | Category2 |  |  | 0 |  |  |  |  | 3 | 10 | 30
397 | Products4 | 2021-09-01 00:00:00 | 396 |  | Category2 |  |  | 20 |  |  |  |  | 4 | 5 | 20
398 | Products5 | 2021-09-02 00:00:00 | 397 |  | Category2 |  |  | 0
399 | Products6 | 2021-09-02 00:00:00 | 397 |  | Category1 |  |  | 0
400 | Products7 | 2021-09-03 00:00:00 | 397 |  | Category2 |  |  | 0
401 | Products8 | 2021-11-03 00:00:00 | 396 |  | Category1 |  |  | 0
402 | Products9 | 2021-11-04 00:00:00 | 394 |  | Category1 |  |  | 0
403 | Products10 | 2021-09-01 00:00:00 | 395 |  | Category2 |  |  | 0
404 | Products11 | 2021-09-01 00:00:00 | 395 |  | Category2 |  |  | 0
[NAME] in E2: =IF(A2>0,COUNTIF(D:D,A2),0)
Formula in G2: =IF(A2>0,VLOOKUP(F2,K:L,2,FALSE),0)
[NAME] in I2: =IF(E2>=2,VLOOKUP(F2,K:M,3,FALSE),0) |  |  |  |  |  |  |  |  | Notes:
 |  |  |  |  |  |  |  |  | Product ID is unique
 |  |  |  |  |  |  |  |  | More Products will be added in the future
 |  |  |  |  |  |  |  |  | Some products are under a main product (Sub-Product)
 |  |  |  |  |  |  |  |  | No. of Sub-Products are calculated automatically
 |  |  |  |  |  |  |  |  | Category Name is selected from a drop-down list from the right-side reference area
 |  |  |  |  |  |  |  |  | Category Price is automatically pulled from the reference area based on the selection of the Category Name
 |  |  |  |  |  |  |  |  | Challenges:
 |  |  |  |  |  |  |  |  | Commission should be calculated based on the Product Level and Category Name. Product Level depends on how many Products this Product has on top of it (e.g. Product1 has no Product on top of it (no main product) but Product5 has 4 products on top of it where Product4 on top of Product5 and Product3 on top of Product4 up to Product1) so the Product Level for Product5 is 4. Since Product5 is Category2 so the Category Commission for Product5 is $ 200 (From the reference area on the right side).
 |  |  |  |  |  |  |  |  | Bonus should be calculated based on the Category Name and must have atleast 2 Sub-Products with the same Category Name within 30 days as per the Initial Date (e.g. Product1 has 2 Sub-Products which are Product2 and Product9 (Both are Category1) but they are more than 30 days difference in the Initial date so Bonus should be 0 (zero). e.g. Product2 has more than 2 Sub-Products all under the same Category Name and within 30 days so Bonus should be $ 20). I have tried the formula inthe attached excel sheet but couldn't complete it. Please advise with a furmula with VB script which can do that.
Spreadsheet: daren_farmer__5646__HPLN1228
Sheet: Sheet1

HPLN1228.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - December 28, 2000
 |  |  |  |  |  | **Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-12-28 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL | 30 | 30
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | Enron | 10 | 10
Enron (S) |  | LS HPL [NAME] |  | Enron | 0 | 0
Enron (S) |  | Texoma |  | Enron | 30 | 0 | *
Enron (S) |  | Oasis Sealy |  | Enron | 20 | 60 | *
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher