tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 887028d1737113454-vlookup-match-over-multiple-tabs-in-worksheet-multi-tab-example
Sheet: MAIN

[NAME] | Type | Description | Colour | Fabric | Shell | FIA/Non FIA | Standard/Signature | UK |  | Variation | Parent Part |  | Classic models | Recliner Models | [NAME]
CLASSIC | Seat | Classic & Headrest - Black Leather | Black | Leather |  | Non FIA | Standard |  |  | CLH-L-BK | CLH-L-BK
CLASSIC | Seat | Classic & Headrest - Black Leather Facings/Black Vinyl Back | Black |  |  | Non FIA | Standard | 360 |  | CLH-L-M-BK | CLH-L-M-BK
CLASSIC | Seat | Classic & Headrest - Black Spacer Fabric | Black | Spacer |  | Non FIA | Standard | 310 |  | CLH-S-BK | CLH-S-BK
DAYTONA | Seat | Daytona - Black Spacer Fabric all over - Anthracite [NAME] patches | Black | Spacer |  | Non FIA | Standard | 900 |  | DAY-S-BK | DAY-S-BK
DAYTONA | Seat | Daytona - Blue Spacer Fabric all over - Anthracite [NAME] patches | Blue | Spacer |  | Non FIA | Standard | 920 |  | DAY-S-BL | DAY-S-BL
DAYTONA | Seat | Daytona - Grey Spacer Fabric all over - Anthracite [NAME] patches | Grey | Spacer |  | Non FIA | Standard | 910 |  | DAY-S-GY | DAY-S-GY
IMOLA T (STD W) | Seat | Imola Profit STD Width Black Spacer GRP FIA Homologated | Black | Spacer |  | FIA | Standard | 700 |  | IMPF-S-BKS-GRP | IMPF-S-BKS-GRP
IMOLA T (STD W) | Seat | Imola Profit STD Width Blue Spacer GRP FIA Homologated | Blue | Spacer |  | FIA | Standard | 710 |  | IMPF-S-BLS-GRP | IMPF-S-BLS-GRP
IMOLA T (STD W) | Seat | Imola Profit STD Width Grey Spacer GRP FIA Homologated | Grey | Spacer |  | FIA | Standard | 810 |  | IMPF-S-GYS-GRP | IMPF-S-GYS-GRP
MONACO SPORT (NRW W) | Seat | [NAME] Black Spacer Fabric all over | Black | Spacer |  | Non FIA | Standard | 510 |  | MNLS-S-BK | MNLS-S-BK |  | Supplied with Anthracite Suede Tec Wear Patches as standard
MONACO SPORT (NRW W) | Seat | [NAME] all over | Blue | Spacer |  | Non FIA | Standard | 525 |  | MNLS-S-BL | MNLS-S-BL |  | Supplied with Anthracite Suede Tec Wear Patches as standard
MONACO SPORT (NRW W) | Seat | [NAME] all over | Grey | Spacer |  | Non FIA | Standard | 515 |  | MNLS-S-GY | MNLS-S-GY |  | Supplied with Anthracite Suede Tec Wear Patches as standard
Spreadsheet: 883408d1732029145-dynamic-drop-down-using-tables-testworkbook-alexhen-
Sheet: Invoice Creator

 |  | Select Job to Invoice / Receipt
 |  | Job-100005 - Cust No:100004 - Isobel Hunt : - General House Improvements and fixes
 |  | INVOICE
 |  | Job Number | Customer Number | Total Cost |  | Customer Name | Invoice Date | Customer Address |  | Full Name and Address |  | Job Description |  | Job Rate | Receipt? | PartPayment | Balance
 |  | Job Tasks | Description |  |  | Materials |  | [NAME]) | Rate | Total
Spreadsheet: 161923d1339673730-lock-unlock-rows-based-on-values-in-cell-protect-unprotect
Sheet: Sheet1

Work? | Name | Age | Salary | DOJ
ok | [NAME] | 18 | 1000 | 2010-10-22 00:00:00
OK | [NAME] | 20 | 2000 | 2019-10-22 00:00:00
Amendment | [NAME] | 20 | 2000 | 2019-10-22 00:00:00
requirements
I will enter all the details and send to my colligue
I need a macro to protect all the rows of Column B,C & E( from row 2)
If anything has to be changed in any of the rows in Column B,C & E, the values in column A has to be changed to "Amendment" only then that particular rows should be unlocked
again the value is changed to OK, then lock the cells back.
** cells marked in yellow are always to be protected if values in column A is "OK" & should be unlocked if values in Column A is "Amendment"
Spreadsheet: 727015d1617652290-multiple-sheet-data-search-and-result-book2
Sheet: Master

Building | Unit | Vehicle # | License Plate
2700 | A | 1 | ABC123
2700 | B | 1 | DEF456
2700 | C | 1 | GHI789
2700 | C | 2 | 123ABC
2715 | A | 1 | 456DEF
2715 | B | 1 | 789GHI
2715 | B | 2 | XYZ987
2715 | C | 1 | TUV654
2720 | A | 1 | LMN321
2720 | B | 1 | 987XYZ
2720 | C | 1 | 654TUV
2720 | D | 1 | 321LMN
Spreadsheet: 141797d1329457227-stacked-bar-chart-excel-2011-test1
Sheet: Sheet1

 | start | completed | outstanding | end
aaa | 2011-01-12 00:00:00 | 88 | 98 | 2011-07-17 00:00:00
bbb | 2011-05-03 00:00:00 | 73 | 68 | 2011-09-21 00:00:00
[NAME] | 2011-07-07 00:00:00 | 86 | 84 | 2011-12-24 00:00:00
ddd | 2011-09-09 00:00:00 | 52 | 62 | 2012-01-01 00:00:00
Spreadsheet: 148986d1333639851-how-can-i-pull-data-from-one-tab-to-another-if-a-date-is-entered-into-a-certain-field-candidate-tracker
Sheet: IPT Lead - Project Manager

Candidate | Job Title | Date [NAME] | Sent to | Status | Int. Requested | Int. Date | Offer Date | Start date | Notes
Candidate E | Stress Engineer | 2012-01-01 00:00:00 | Mark A | OfferAccept | Yes | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-05 00:00:00
Candidate F | Stress/Thermal Engineer | 2012-03-09 00:00:00 | [NAME] | Interviewreject | Yes | 2012-03-11 00:00:00
Candidate G | Stress Engineer | 2012-03-10 00:00:00 | [NAME] | OfferAccept | Yes | 2012-03-12 00:00:00 | 2012-03-13 00:00:00 | 2012-04-16 00:00:00
Spreadsheet: louise_kitchen__22664__2002 EGF Alloc ENA
Sheet: Sheet2

Enron Global Finance
2002 Allocations |  |  |  | Enron North America
 |  |  |  | 2001 |  | 2002
106188 | Schnapper | Corp Finance |  | 1176558 | 0.2499999468789582 | 828496 | 0.129999955541945
106189 | Perkins | Treasury |  | 695173 | 0.2394001402294639 | 759376 | 0.2512200525415193
106190 | Kopper | Structured Finance |  | 1187449 | 0.25 | 0 | 0
106191 | [NAME] | Commercial Support |  | 0 | 0 | 0 | 0
106192 | Glisan | Treasury VP |  | 84839 | 0.07999973597135666 | 466032 | 0.3087999968194459
106193 | Boots | Investor/Debt Relations |  | 422586 | 0.2500002957981284 | 462982 | 0.3499997480105432
106194 | [NAME] | Legal |  | 383433 | 0.1500004694446314 | 651319 | 0.2422998657029021
106195 | [NAME] | Capital Market Equity |  | 259773 | 0.1699994961000104 | 462555 | 0.2999997405716158
106196 | EGF | G&A |  | 0 | 0 | 0 | 0
106285 | Fastow | Executive |  | 91020 | 0.07999985937181389 | 88678 | 0.100000526251294
107038 | EGF | Projects |  | 0 | 0 | 0 | 0
140411 | Glisan | Intl Asset Structures |  | 0 | 0 | 0 | 0
 |  | Total |  |  | 0.114 |  | 0.103
Spreadsheet: kevin_hyatt__19634__Contact List
Sheet: Cell List

Contact List
[NAME] | [PHONE] | :c
[NAME] | [PHONE] | :c
[NAME] | [PHONE] | :c
[NAME] | [PHONE] | :c
[NAME] | [PHONE] | :c
[NAME] | [PHONE] | :c
[NAME] | [PHONE] | :c
[NAME] | [PHONE] | :h
[NAME] | [PHONE] | :c
[NAME] | [PHONE] | :c
[NAME] | [PHONE] | :c
[NAME] | [PHONE] | :c
Spreadsheet: 870420d1716934060-barclays-premier-league-best-11-for-2024-toty-23-24-premier-league-alif
Sheet: Team of the Year 23-24 (Chaps)

 |  |  |  |  |  | Team of the Year 2023 - 2024
 |  |  |  |  |  |  |  |  | GK | Club
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 5
 |  |  | RB | Club |  | RCB | Club |  |  |  |  | LCB | Club |  | LB | Club
 |  | 1 |  |  | 1 |  |  |  |  |  | 1 |  |  | 1
 |  | 2 |  |  | 2 |  |  |  |  |  | 2 |  |  | 2
 |  | 3 |  |  | 3 |  |  |  |  |  | 3 |  |  | 3
 |  | 4 |  |  | 4 |  |  |  |  |  | 4 |  |  | 4
 |  | 5 |  |  | 5 |  |  |  |  |  | 5 |  |  | 5
 |  |  |  |  |  |  |  |  | CM | Club
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  | CM | Club |  |  |  |  | CM | Club
 |  |  |  |  | 1 |  |  |  |  |  | 1
 |  |  |  |  | 2 |  |  |  |  |  | 2
 |  |  |  |  | 3 |  |  |  |  |  | 3
 |  |  |  |  | 4 |  |  |  |  |  | 4
 |  |  |  |  | 5 |  |  |  |  |  | 5
 |  |  | RW | Club |  |  |  |  |  |  |  |  |  |  | LW | Club
 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | 3 |  |  |  |  |  |  |  |  |  |  |  | 3
 |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | ST | Club
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  | Signing of the season |  |  |  |  |  | 5
 |  |  | Player | Club
 |  | 1
 |  | 2
 |  | 3
 |  | 4 |  |  |  | Make sure PLAYERS you have selected have transferred to their teams this season please!!!
 |  | 5
 |  | Worst Signing of the season
 |  |  | Player | Club
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | Best player of the season
 |  |  | Player | Club
 |  | 1
 |  | 2
 |  | 3 |  |  |  | Can be any PLAYER
 |  | 4
 |  | 5
 |  | Worst player of the season
 |  |  | Player | Club
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
Spreadsheet: 2eb3ad96-c443-47c0-b67e-ecbec8e4ac4a
Sheet: Region 2

Early Scholars by Region
Inputs: |  | Compensatory Multiplier | 0.39
 |  |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O
 |  |  |  |  |  |  |  |  |  | Enrollment |  |  |  | Portion of
 |  |  |  |  |  |  | Enrollment |  | Capped | Adjusted |  | Initial | Cumulative | Available | Pathway II
 |  |  |  |  |  |  | KGN |  | Poverty | For Low |  | Scholarship | Scholarships | Pathway II | Total Amount | Existence of
 |  |  |  | Enrollment | Enrollment | Enrollment | Low | Poverty | Portion | Income | Compensatory | Count | Until [NAME] of | Scholarships | for all 4 Star | City of 1st Class (C),
 |  |  |  | KGN | KGN | KGN | Income | Concentration | = Lesser of | Portion | Multiplier | =Greater of |  | After Adjusting | Programs within | FY13 Scholarships (S), |  | Parent
District # | Type | District Name | EconDev | Total | Free | Reduced | =E+F*0.5 | =D/A | E or .8 | =D*F | * G | 10 or G | is [NAME] | for [NAME] | District Boundary | or Priority School (P) | County | Aware
162 | 1 | BAGLEY PUBLIC SCHOOL DISTRICT | 02 | 100 | 53 | 9 |  |  |  |  |  |  |  |  |  | S | [NAME] | 12
2311 | 1 | CLEARBROOK-GONVICK SCHOOL DISTRICT | 02 | 28 | 13 | 4 |  |  |  |  |  |  |  |  |  | S | [NAME] | 12
38 | 1 | RED LAKE PUBLIC SCHOOL DISTRICT | 02 | 169 | 144 | 3 |  |  |  |  |  |  |  |  |  | P | Beltrami | 14
432 | 1 | MAHNOMEN PUBLIC SCHOOL DISTRICT | 02 | 47 | 33 | 2 |  |  |  |  |  |  |  |  |  | P | Mahnomen | 12
36 | 1 | KELLIHER PUBLIC SCHOOL DISTRICT | 02 | 20 | 13 | 4 |  |  |  |  |  |  |  |  |  |  | Beltrami | 14
435 | 1 | WAUBUN PUBLIC SCHOOL DISTRICT | 02 | 47 | 33 | 4 |  |  |  |  |  |  |  |  |  |  | Mahnomen | 12
32 | 1 | BLACKDUCK PUBLIC SCHOOL DISTRICT | 02 | 48 | 27 | 9 |  |  |  |  |  |  |  |  |  |  | Beltrami | 14
309 | 1 | PARK RAPIDS PUBLIC SCHOOL DISTRICT | 02 | 125 | 59 | 11 |  |  |  |  |  |  |  |  |  |  | Hubbard | 15
31 | 1 | BEMIDJI PUBLIC SCHOOL DISTRICT | 02 | 420 | 195 | 40 |  |  |  |  |  |  |  |  |  |  | Beltrami | 14
308 | 1 | NEVIS PUBLIC SCHOOL DISTRICT | 02 | 42 | 19 | 4 |  |  |  |  |  |  |  |  |  |  | Hubbard | 15
390 | 1 | LAKE OF THE WOODS SCHOOL DISTRICT | 02 | 37 | 14 | 3 |  |  |  |  |  |  |  |  |  |  | Lake of the Woods | 15
306 | 1 | LAPORTE PUBLIC SCHOOL DISTRICT | 02 | 23 | 5 | 5 |  |  |  |  |  |  |  |  |  |  | Hubbard | 15
Spreadsheet: 024f0463-c88e-4e6c-906d-6010e1e646e2
Sheet: Operating Costs

Service Center Calculations
ANNUAL BUDGETED OPERATING COSTS
Purpose: To detail non-salary and non-equipment costs associated with the service center services
Sheet Instructions
Fill in only the yellow highlighted areas
You may insert additional lines as necessary.
 |  | SERVICE 1 |  | SERVICE 2
Travel
Description | Annual Amt | % | Amount | % | Amount
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
SUBTOTAL TRAVEL
SUBSIDY - AMOUNT THAT WILL NOT BE CHARGED TO CUSTOMERS | 0 | 0 |  | 0
TOTAL TRAVEL
 |  | SERVICE 1 |  | SERVICE 2
Operating Expenses
Description | Annual Amt | % | Amount | % | Amount
0 | 0 | 0 |  | 0
0 | 0 | 0 |  | 0
0 | 0 | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
SUBTOTAL OPERATING EXPENSES
SUBSIDY - AMOUNT THAT WILL NOT BE CHARGED TO CUSTOMERS | 0 | 0 |  | 0
SUBTOTAL OPERATING EXPENSES
 |  | SERVICE 1 |  | SERVICE 2
Equipment < $5,000*
Description | Annual Amt | % | Amount | % | Amount
Equipment - non R&R | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
SUBTOTAL EQUIPMENT <$5,000
SUBSIDY - AMOUNT THAT WILL NOT BE CHARGED TO CUSTOMERS | 0 | 0 |  | 0
SUBTOTAL EQUIPMENT <$5,000>
Equipment >$5,000 - See next worksheet
Spreadsheet: 163083d1340188755-changing-a-formula-in-a-cell-by-entering-a-number-in-another-cell-is-it-possible-0rhrp-demo
Sheet: Sunday

Department Daily Schedule
Sun | 0600 | 0615 | 0630 | 0645 | 0700 | 0715 | 0730 | 0745 | 0800 | 0815 | 0830 | 0845 | 0900 | 0915 | 0930 | 0945 | 1000 | 1015 | 1030 | 1045 | 1100 | 1115 | 1130 | 1145 | 1200 | 1215 | 1230 | 1245 | 1300 | 1315 | 1330 | 1345 | 1400 | 1415 | 1430 | 1445 | 1500 | 1515 | 1530 | 1545 | 1600 | 1615 | 1630 | 1645 | 1700 | 1715 | 1730 | 1745 | 1800 | 1815 | 1830 | 1845 | 1900 | 1915 | 1930 | 1945 | 2000 | 2015 | 2030 | 2045 | 2100 | 2115 | 2130 | 2145 | 2200 | 2215 | 2230 | 2245 | 2300 | 2315 | 2330 | 2345 | Total
Nicola |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Total
Allowed Hours |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Variance +/-
Tills Open |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0800-1300 |  |  | 1300-1700 |  |  | 1700-2200 |  |  | 2200-0800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ideal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual
Spreadsheet: 419465d1442405129-how-to-count-cricket-overs-sample-sheet-2-
Sheet: Sheet2

 |  |  | OVERS
 |  |  | BOWLING
 |  |  |  | BOWLLER'S NAME |  | OVER DETAILS
 |  |  | 1 | ABCD |  | 1 | 2 | 4
 |  |  |  |  |  | 1 | 3 | 1
 |  |  | 2 | OPQR |  | 1 | 0 | 0
 |  |  |  |  |  | 1 | WKT | 0
 |  |  | 3 | 12234 |  | 3 | WKT | WKT
 |  |  |  |  |  | 3 | 5 | NO
 |  |  | 4 | XYZ |  |  | 6 | 3
 |  |  | IF I SELECT FIGURE OR CHARATER FROM CELL "G6 TO I13 IT GETS COUNTED IN OVERS CELL
 |  |  | IF IT IS A FOUR OVER MATCH, THE LEGAL BALLS DELIVERED ARE 16 THEN THE CELL SHOULD SHOW AS 2.4 OVERS
 |  |  | IT SHOWS 16 BALLS
 |  |  | "NO & WIDE" FROM ABOVE CELLS SHOULD NOT BE GET COUNTED
Spreadsheet: 59968d1260482126-vlookup-or-conditional-lookup-red-or-green-master-with-contest-
Sheet: CONTEST

Clinton Champions Cup
 |  |  |  | Leader board
Weight of Categories |  |  |  | 1st
Activations | 0.25 |  |  | 2nd
Features | 0.25 |  |  | 3rd
VOC | 0.25 |  |  | 4th
PHP | 0.1 |  |  | 5th
Upgrade | 0.1 |  |  | 6th
Accessories | 0.05 |  |  | 7th
Activations |  | Features |  | VOC |  | PHP |  | Upgrade |  | Accessories
 | 1.375 |  | 75 |  | 1 |  | 0.79 |  | 0.7922535211267606 |  | 2.215116279069767
 | 1.375 |  | 71 |  | 1 |  | 0.75 |  | 0.528169014084507 |  | 1.677631578947368
 | 0.875 |  | 47 |  | 0.68 |  | 0.74 |  | 0.4807692307692308 |  | 1.176315789473684
 | 0.7894736842105263 |  | 38 |  | 0 |  | 0.59 |  | 0.4225352112676056 |  | 0.8763157894736842
 | 0.75 |  | 35 |  | 0 |  | 0.57 |  | 0.3697183098591549 |  | 0.8210526315789474
 | 0.7258064516129032 |  | 26 |  | 0 |  | 0.36 |  | 0.2884615384615384 |  | 0.4484029484029484
 | 0.1209677419354839 |  | 0 |  | 0 |  | 0.17 |  | 0.2853260869565217 |  | 0.1604651162790698
Rep | Activations | Features | VOC | PHP | Upgrade | Accessories
[NAME] | 1.375 | 38 | 0.68 | 0.57 | 0.3697183098591549 | 1.677631578947368
[NAME] | 0.1209677419354839 | 0 | 0 | 0.75 | 0.2884615384615384 | 0.1604651162790698
Axel | 0.75 | 75 | 0 | 0.36 | 0.528169014084507 | 0.8763157894736842
Kaleb | 1.375 | 26 | 0 | 0.74 | 0.7922535211267606 | 0.8210526315789474
[NAME] | 0.875 | 47 | 1 | 0.17 | 0.4225352112676056 | 1.176315789473684
Jordyn | 0.7258064516129032 | 71 | 1 | 0.59 | 0.4807692307692308 | 2.215116279069767
[NAME] | 0.7894736842105263 | 35 | 0 | 0.79 | 0.2853260869565217 | 0.4484029484029484
Spreadsheet: 106966d1304100746-combining-search-and-conditional-color-formatting-for-a-small-database-darkspore-squad-overview
Sheet: Squad Info

Squad 1 |  |  |  |  |  |  |  | Bio | Cyber | Necro | Plasma | Quantum |  | Sentinel
Zrin | S | Sage | T | Titan | S |  | Squad 1 | B | C |  | P |  |  | Ravager
 |  |  |  |  |  |  | Squad 2 |  |  | N | P | Q |  | Tempest
Squad 2 |  |  |  |  |  |  | Squad 3 | B | C |  | P
Krel | R | Maldri | R | Arakna | R
Squad 3
Blitz | R | Savage | S | SRS-42 | T
Spreadsheet: 584919d1533530371-same-formula-but-getting-different-results-book2-rev2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | DiscCode | Disc |  | Fixed Fee
 |  |  |  |  |  |  |  |  |  | A1 | 0.05 |  | Test1 | 0.1
 |  |  |  |  |  |  |  |  |  | A2 | 0.055 |  | Test2 | 0.15
 |  |  |  |  |  |  |  |  |  | A3 | 0.06 |  | Test3 | 0.2
 |  |  |  |  |  |  |  |  |  | A4 | 0.07 |  | Test4 | 0.175
 |  |  |  |  |  |  |  |  |  | A5 | 0.075 |  | Test5 | 0.18
 |  |  |  |  |  |  |  |  |  | A6 | 0.08 |  | Test6 | 0.19
 |  |  |  |  |  |  |  |  |  | A7 | 0.085 |  | [NAME] | 0.2
 |  |  |  |  |  |  |  |  |  | A8 | 0.09 |  | Test8 | 0.25
 |  |  |  |  |  |  |  |  |  | A9 | 0.095 |  | Test9 | 0.3
 |  |  |  |  |  |  |  |  |  | A10 | 0.1 |  | Test10 | 0.33
 |  |  | FixedFee
 |  |  | Test1
 |  | NoDisc | DiscCode
 | 1000 |  | A1
 |  | I want to get result in cell E15 using formula :
 |  | B15 * cell L2 (if cell D15 match cell K2) * cell [NAME] (if cell D13 match cell N2)
 |  | B15 * cell L2 (if cell D15 match cell K3) * cell [NAME] (if cell D13 match cell N2)
 |  | B15 * cell L2 (if cell D15 match cell [NAME]) * cell O4 (if cell D13 match cell N2)
 |  | 1000, less 5%, less 10% = 855
 |  | Result in cell E15 is 905 …. But what I need is 855 (as above)
 |  | Sorry, my english is not good…I hope the above explaination is good. Thank you.
Spreadsheet: mary_fischer__25615__32L
Sheet: E11.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032L
COMPANY NAME   Jovinole Associates
ANALYSIS OF OTHER CURRENT LIABILITIES
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-11
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Current Liabilities
(must tie to Hyperion account 655) | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Income Accts:  DR/(CR)
Reverse signs from Hyperion
Spreadsheet: 721292d1614628864-formula-based-on-several-variables-example_v1
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00
Week Nbr | Date | Name | Shift | Delivery | Pick-up | Cancel | Change |  |  | Day Shift
 | 2021-01-01 00:00:00 | Anna | Day | 1 | 1 | 2 | 1 |  |  | Delivery
 | 2021-01-01 00:00:00 | Becky | Day | 0 | 2 | 5 | 1 |  |  | Pick-up
 | 2021-01-01 00:00:00 | Carie | Swing | 1 | 0 | 0 | 2 |  |  | Cancel
 | 2021-01-01 00:00:00 | Eddie | Swing | 3 | 2 | 3 | 2 |  |  | Change
 | 2021-01-01 00:00:00 | [NAME] | Night | 0 | 2 | 9 | 3 |  |  | Swing Shift
 | 2021-01-01 00:00:00 | George | Night | 1 | 0 | 2 | 1 |  |  | Delivery
 | 2021-01-02 00:00:00 | Anna | Day | 0 | 1 | 4 | 1 |  |  | Pick-up
 | 2021-01-02 00:00:00 | Becky | Day | 0 | 3 | 1 | 2 |  |  | Cancel
 | 2021-01-02 00:00:00 | Carie | Swing | 4 | 1 | 0 | 1 |  |  | Change
 | 2021-01-02 00:00:00 | Eddie | Swing | 0 | 3 | 0 | 4 |  |  | Night Shift
 | 2021-01-02 00:00:00 | [NAME] | Night | 0 | 4 | 2 | 2 |  |  | Delivery
 | 2021-01-03 00:00:00 | George | Day | 2 | 2 | 3 | 2 |  |  | Pick-up
 | 2021-01-03 00:00:00 | Anna | Day | 0 | 0 | 0 | 1 |  |  | Cancel
 | 2021-01-03 00:00:00 | Becky | Swing | 3 | 3 | 1 | 0 |  |  | Change
 | 2021-01-03 00:00:00 | Carie | Swing | 2 | 0 | 5 | 0
 | 2021-01-03 00:00:00 | Eddie | Night | 1 | 0 | 3 | 2
 | 2021-01-04 00:00:00 | [NAME] | Day | 2 | 3 | 1 | 1
 | 2021-01-04 00:00:00 | George | Day | 0 | 2 | 1 | 3
 | 2021-01-04 00:00:00 | Anna | Swing | 1 | 2 | 3 | 4
 | 2021-01-04 00:00:00 | Becky | Swing | 4 | 4 | 2 | 2
 | 2021-01-04 00:00:00 | Carie | Night | 3 | 0 | 1 | 3
 | 2021-01-05 00:00:00 | Eddie | Day | 7 | 4 | 2 | 1
 | 2021-01-05 00:00:00 | [NAME] | Day | 1 | 1 | 1 | 0
 | 2021-01-05 00:00:00 | George | Swing | 4 | 5 | 2 | 5
 | 2021-01-05 00:00:00 | Carie | Swing | 5 | 3 | 1 | 3
 | 2021-01-05 00:00:00 | Anna | Night | 2 | 1 | 1 | 2
Spreadsheet: 491364d1480438204-is-my-excel-sheet-affected-by-invisible-formatting-properties-representative-
Sheet: Help to buy equity loan calc

 |  | percentage | =
 | Property value
 | Mortgage
 | deposit | 5 | 60000
 | equity loan | 75
Spreadsheet: eric_saibi__9959__110801R
Sheet: Northport 01

Owner Name |  | KeySpan Energy Company Inc.
Station Name |  | Northport Power Station
Unit Name |  | Northport 01
NERC Region |  | NPCC
State |  | NY
Fuel Type |  | Coal
Capacity |  | 387 MW
Start Date |  | 2001-09-24 00:00:00
End Date |  | 2001-12-11 00:00:00
Prv. Start Date |  | 2001-09-24 00:00:00
Prv. End Date |  | 2001-12-24 00:00:00
Comments |  | Boiler O/H
SIC |  | 4911
Plant ID |  | 1512112
Unit ID |  | 1004550
Outage ID |  | 18499
Spreadsheet: mike_grigsby__27820__HS_WESTall1029
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEST NATURAL GAS BASIS POSITIONS
 | West Region Basis Notional
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1
 | West Region Basis Notional
 | NGI-PGE/CG |  |  |  | NGI-PGE/CG |  | GDP-PG&E/CITIGA | NGI-PGE/CG | GDP-PG&E/LG-PKG |  |  |  | M | D
 | NGI-MALIN |  |  |  | NGI-MALIN |  | GDP-MALIN-CTYGA | NGI-MALIN |  |  |  |  | M | D
 | NGI-SOCAL |  |  |  | NGI-SOCAL | IF-SOCAL | GDP-CAL BORDER | NGI-SOCAL |  |  |  |  | M | D
 | TOPOCK |  |  |  | NGI-SOBDR-PG&E |  | NGI-SOBDR-PG&E |  |  |  |  |  | M | D
 | NWPL-ROCKIES |  |  | NW-STANFIELD | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-WYOMING | GDP-KERN/OPAL | GDP-NW STANFIEL | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-NWPL_ROCKYM | M | D
 | CIG-ROCKIES | IF-CIG/WINDRVR | IF-CIG/WIC | IF-CIG/RKYMTN | IF-CIG/SOUTHERN | IF-CIG/GLENROCK | IF-CIG/ROCKPORT | GDP-CIG/RKYMTN | GDP-CIG/CHEYENN | IM-CIG/SOUTHERN | IM_WINDRIVER |  | M | D
 | PERMIAN |  | IF-TW/PERMIAN |  | IF-ELPO/PERMIAN | IF-NNG/TOK | GDP-ELPO/PERM2 | IF-ELPO/PERMIAN | IF-TW/PERMIAN |  |  |  | M | D
 | SAN JUAN |  | IF-BONDAD(100%) | IF-ELPO/SJ | IF-EPSJ(BONDAD) |  | GDP-ELPO/SANJUA |  | IM-TW/SJ | IF-EPSJ(BONDAD) |  |  | M | D
 | KINGSGATE |  |  |  | CGPR-KINGSGATE |  | CGPR-KINGSGATE |  |  |  |  |  | M | D
 | WAHA |  |  |  | IF-WAHA-TX | IF-WAHA | WAHA KCBT | GDP-WAHA |  |  |  |  | M | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL
 | Western Canada Region Notional
 | SUMAS |  |  |  | IF-NTHWST/CANBR |  | SUMAS-US/IM | GDP-NTHWST/CANB | IF-NTHWST/CANBR |  |  |  | m | D
 | AECO/EMPRESS/STA2 |  |  |  | CGPR-AECO/BASIS |  | GD-CGPR-AECO/AV | GD-AECOCD/FRWKD | GD-AECOUS/FRWKD | [NAME] | GDP-AECO |  | m | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | p
 | West Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 |  | 2001-11-01 00:00:00 |  | Dec-01/Mar-02 |  | Apr-02/Oct-02 |  | Nov-02/Mar-03 |  | Apr-03/Mar-29
 | CALIFORNIA
 | Socal
 | PG&E CTYG & TOPOCK
 | Malin
 | NorthWest
 | Sumas
 | Aeco & Kingsgate
 | Rockies (NW & CIG)
 | SouthWest
 | San Juan
 | Permian
 | Waha