tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 865252d1712303522-trying-to-tell-excell-to-do-one-thing-if-the-tick-box-is-ticked-and-another-if-the-tick-investment-property-spreadsheet-copy
Sheet: Proposed Analysis - PI

POTENIAL PROPERTY ANALYSIS
 | MINIMUM INPUTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VIC
 |  | Proposed Property Address: |  |  |  |  |  | Enter the address |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QLD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NSW
 |  | Proposed Purchase Price: |  |  |  |  |  | 600000 |  |  |  |  |  | State: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WA
 |  | Proposed Loan Amount: |  |  |  |  |  | 540000 |  |  |  |  |  | Proposed LVR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NT
 |  | Proposed Rental Amount: |  |  |  |  |  | 550 |  | Per Week
 | OPTIONIAL INPUTS
 |  | Capital Growth Rate: |  |  |  |  |  | 0.06 |  |  |  | Consumer Price Index: |  |  |  |  |  | 0.03
 |  |  |  | Property Expenses: |  |  |  |  |  |  |  |  |  | Loan Interest Rate: |  |  |  | 0.065
 | STATISTICS
 |  | Today |  | Year 1 |  | Year 2 |  | Year 3 |  | Year 4 |  | Year 5 |  | Year 6 |  | Year 7 |  | Year 8 |  | Year 9 |  | Year 10
 | Property Value:
 | Equity In Property:
 | Property Growth %: | 0
 | LVR:
 | Loan Balance: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cell E46 is the figure coming from sheet4 Cell E19  Cell [NAME] is the figure coming from sheet4 Cell E31 And so on until you have completed all 10 years.  I have used the same colour for the cells in Sheet4 that it is pulling the data from
 | Surplus to reinvest:
 | Purchase Power: | 0
 | Rental Income:
 | [NAME] Yield:
 | Net Rental Yield:
 | DEDUCTIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cell E64 is the figure coming from sheet4 Cell C19  Cell G64 is the figure coming from sheet4 Cell C31 And so on until you have completed all 10 years.  I have used the same colour for the cells in Sheet4 that it is pulling the data from
 | Property Expenses:
 | Loan Interest Payments:
 | Loan P & I Payments:
 | Pre-Tax Cashflow p/a:
 | Pre-Tax cashflow p/w:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cell E66 is the figure coming from sheet4 Cell [NAME]  Cell G66 is the figure coming from sheet4 Cell [NAME] And so on until you have completed all 10 years.  I have used the same colour for the cells in Sheet4 that it is pulling the data from
 | NON - CASH DEDUCTIONS
 | Depreciation:
 | FINAL ANALYSIS
 | Total Deductions:
 | Net Profit or Loss:
 | Tax Refund:
 | Land Tax:
 | After-Tax Cashflow p/a:
 | After-Tax cashflow p/w:
Spreadsheet: 881675d1729796181-four-linked-index-match-worksheets-and-col-a-misalignment-with-manually-entered-data-grant-tracker-2024-design-v2
Sheet: Progress Reports (4, into 3)

 |  |  |  |  | Progress Reports: Enter Each PR submitted sequentially, left to right; DO NOT overwrite previous entry dates.
Grant/Award Name | Assigned To | Comments | Submission Date 1 | Submission Date 2 | Submission Date 3 | Submission Date 4 | Submission Date 5 | Submission Date 6 | Submission Date 7 | Submission Date 8 | Submission Date 9 | Submission Date 10 | Submission Date 11 | Submission Date 12 | Submission Date 13 | Submission Date 14 | Submission Date 15 | Submission Date 16 | Submission Date 17 | Submission Date 18 | Submission Date 19 | Submission Date 20 | Submission Date 21 | Submission Date 22 | Submission Date 23 | Submission Date 24 | Submission Date 25
 |  |  | 2024-07-15 00:00:00 | 2024-10-15 00:00:00
 |  |  | 2024-09-15 00:00:00
 |  |  | 2024-08-15 00:00:00 | 2024-09-15 00:00:00
Spreadsheet: 54641d1254688978-excel-2007-calculating-sales-won-in-a-week-excel-test
Sheet: Sheet1

week | [NAME] | company | revenue |  | Week | Total Sales
1 | [NAME] | Fred's Bowling | 1000 |  | 1
1 | [NAME] | Ranch Auto | 3000 |  | 2
1 | [NAME] | Euro Hair | 7000 |  | 3
2 | [NAME] | Sponges | 500 |  | 4
2 | [NAME] | Total Security | 750 |  | 5
3 | [NAME] | [NAME] | 10000
3 | [NAME] | Cheapo Tyres | 12000
3 | [NAME] | [NAME] | 1000
3 | [NAME] | Jim's Diner | 1350
4 | [NAME] | Big Cars | 3456
4 | [NAME] | Used Car Centre | 2750
5 | [NAME] | [NAME] | 509
5 | [NAME] | [NAME]'s Car Wash | 50
5 | [NAME] | Computer Repairs Fast | 25000
5 | [NAME] | CCT | 12
5 | [NAME] | Changes Surgery | 2
5 | [NAME] | Dicks Dental | 9999
Spreadsheet: 862883d1710449892-cant-group-dates-cant-group-pt-dates
Sheet: Pivot

Row Labels | Sum of Count
01/02/2024 | 26
01/03/2024 | 40
01/04/2024 | 40
01/05/2024 | 35
01/06/2024 | 3
01/08/2024 | 55
01/09/2024 | 59
01/10/2024 | 54
01/11/2024 | 43
01/12/2024 | 40
01/13/2024 | 11
01/16/2024 | 48
01/17/2024 | 49
01/18/2024 | 77
01/19/2024 | 64
01/20/2024 | 14
01/22/2024 | 83
01/23/2024 | 98
01/24/2024 | 58
01/25/2024 | 69
01/26/2024 | 65
01/27/2024 | 13
01/29/2024 | 87
01/30/2024 | 64
01/31/2024 | 72
02/01/2024 | 72
02/02/2024 | 58
02/03/2024 | 18
02/05/2024 | 71
02/06/2024 | 85
02/07/2024 | 81
02/08/2024 | 77
02/09/2024 | 79
02/10/2024 | 15
02/12/2024 | 79
02/13/2024 | 83
02/14/2024 | 69
02/15/2024 | 80
02/16/2024 | 79
02/17/2024 | 21
02/19/2024 | 65
02/20/2024 | 71
02/21/2024 | 94
02/22/2024 | 69
02/23/2024 | 70
02/24/2024 | 20
02/26/2024 | 99
02/27/2024 | 86
02/28/2024 | 93
02/29/2024 | 84
03/01/2024 | 56
03/02/2024 | 16
03/04/2024 | 102
[NAME] | 102
03/06/2024 | 90
03/07/2024 | 99
03/08/2024 | 75
03/09/2024 | 18
03/11/2024 | 114
03/12/2024 | 101
03/13/2024 | 85
03/14/2024 | 6
09/08/2023 | 3
09/12/2023 | 1
09/13/2023 | 4
09/15/2023 | 2
09/18/2023 | 4
09/19/2023 | 2
09/20/2023 | 1
09/22/2023 | 1
09/28/2023 | 1
09/29/2023 | 1
10/10/2023 | 1
10/16/2023 | 1
10/18/2023 | 1
10/24/2023 | 1
10/25/2023 | 2
10/27/2023 | 1
10/31/2023 | 1
11/06/2023 | 2
11/07/2023 | 1
11/13/2023 | 2
11/15/2023 | 1
11/16/2023 | 49
11/17/2023 | 6
11/18/2023 | 7
11/20/2023 | 47
11/21/2023 | 6
11/22/2023 | 43
11/24/2023 | 15
11/27/2023 | 11
11/28/2023 | 51
11/29/2023 | 18
11/30/2023 | 49
12/01/2023 | 65
12/02/2023 | 16
12/04/2023 | 83
12/05/2023 | 82
12/06/2023 | 58
12/07/2023 | 84
12/08/2023 | 51
12/09/2023 | 4
12/11/2023 | 56
12/12/2023 | 83
12/13/2023 | 32
12/14/2023 | 35
12/15/2023 | 54
12/16/2023 | 18
12/18/2023 | 61
12/19/2023 | 47
12/20/2023 | 52
12/21/2023 | 37
12/22/2023 | 18
12/23/2023 | 4
12/24/2023 | 1
12/26/2023 | 30
12/27/2023 | 49
12/28/2023 | 31
12/29/2023 | 25
12/30/2023 | 4
Grand Total | 5265
Spreadsheet: 196840d1354120908-spreadsheet-to-show-the-results-of-golf-competitions-golf-league-table-including-reults
Sheet: Instruct

Sheet | What it Does
Golfers | Here you can enter the names of upto 50 golfers
 | The rest of "Golfers" is automatically filled in using MATCH to find the position that player placed in that tournament
Course Sheets | You can use dropdown list or type the golfer name in.  The [NAME] name needs to be on "Golfers" before Excel will allow you to enter it on a Course Sheet
 | Manually enter handicaps, points, etc
Leadership | This table is automatically filled in from the "Calculation" sheet
WHAT YOU NEED TO DO
 | All you need to do is to put in the names of the golfers onto the GOLFERS sheet
 | Then as each Course is played Enter the information for each player
 | The Leadership board and Golfers Sheet will update automatically
NOTES | There are some hidden sheets
 |  | Calculations: Used to perform intermediate calculations to come up with Rankings
 |  | C1 thru C4: Additional sheets for tournaments
 |  |  | Columns containing these sheets are hidden on the Calculation Sheet (not important) and on the [NAME] and
 |  |  | Leaderboard Sheets.  You'll need to unhide these as you use them
Spreadsheet: stacey_white__39048__10222001WestPrice
Sheet: Daily Peak and Off Peak

West Daily Off Peak Prices
Spreadsheet: 172180d1344015132-how-do-i-create-an-equation-to-produce-an-auto-fill-test
Sheet: Sheet3

Activity Durations |  |  | Labor
Hours | Days |  | Qty per  Day | Laborers | Subtotal | Qty per  Day | Operator | Subtotal | Qty per  Day | Supervisor | Subtotal | Total Labor
 |  |  | 1 |  |  |  | 0 |  |  | 0 |  | 0
16 | 2 |  |  |  |  |  | 0 |  |  | 0 |  | 0
 |  |  |  |  | 0 |  |  | 0 |  |  | 0 | 0
40 | 5 |  |  |  |  |  | 0 |  |  | 0 |  | 0
32 | 4 |  |  |  |  |  | 0 |  |  | 0 |  | 0
56 | 7 |  |  |  |  |  | 0 |  |  | 0 |  | 0
40 | 5 |  |  |  |  |  | 0 |  |  | 0 |  | 0
 |  |  |  |  | 0 |  |  | 0 |  |  | 0 | 0
Spreadsheet: 100873d1299094559-add-figures-based-on-3-criteria-from-test-data-sheet-bdm-test2
Sheet: Result

Depot
 |  |  |  | ==IF(A10="","",SUMPRODUCT(Test!$C$9:$Z$30,(Test!$A$9:$A$30=$A10)*(Test!$B$9:$B$30="Budget")*ISNUMBER(MATCH(Test!$C$7:$Z$7,{"July","August","September","October","November","December","January","February"},0))))
A |  |  |  | I also want to be able to apply same conditions to work on second formula but this I want to add the sum of (multiply c10*d10 and so on)  to achive the result
B
C
D
Targeted branches
E
F
G
H
I
Other branches
Total
Spreadsheet: 190933d1351858208-macro-to-merge-the-text-in-b2-with-the-text-in-b1-if-a2-is-blank-test2
Sheet: Sheet1

Time:  10/31/2012 1:46:40 PM
PO Number: 4200360
Item No: | Description: | [NAME]: | Qty: | Price: | Total:
WHI W10124096 | w1234 | Phoenix | 1 | 73.11 | 73.11
 | w5678
GE W10124097 | e310122 | Phoenix | 1 | 73.11 | 73.11
 | f14566
WHI W10124098 | w19010 | Phoenix | 1 | 73.11 | 73.11
 | f23454
FRI W10124099 | e27898 | Phoenix | 1 | 73.11 | 73.11
 | r32342
WHI W10124100 | t36786 | Phoenix | 1 | 73.11 | 73.11
 | f41230
What I need to do is:
1 | [NAME] into B9 with a "," between the text, do this all the way down to b16.
 | Then remove the empty rows, B8,B10,B12,B14,B16
 | C28 has to stay at C28 as part of my Macro uses that Cell Number.
2 | Remove just the Date from A2 ant past it in B2
3 | Remove just the PO Number and past it in B3
CC | 'COFFEE:WR32X10398 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APC |  |  |  |  |  |  |  | 0 | N | N | 0 | N | N |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0
CC | 'COFFEE:WE3M26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | N | N | 0 | N | N |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0
CC | '011A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | N | N | 1 | N | N |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0
CC | '011A:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | N | N | 0 | N | N |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0
CC | '011A:[PHONE]:L304433208 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | N | N | 0 | N | Y |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0
CC | '011A:C_HOOKUP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | N | N | 0 | N | N |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0
CC | '011A:C_HOOKUP:59936 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRUE VALUE HARDWARE |  |  |  |  |  |  |  | 0 | N | N | 0 | N | N |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0
CC | '011A:C_HOOKUP:GC100-48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRU TEMP EQUIPMENT |  |  |  |  |  |  |  | 0 | N | N | 1 | N | N |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0
CC | '011A:C_HOOKUP:GC75-48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRU TEMP EQUIPMENT |  |  |  |  |  |  |  | 0 | N | N | 1 | N | N |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0
CC | '011A:Dishwasher Hookups |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | N | N | 0 | N | Y |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0
Spreadsheet: 674553d1587909915-unique-value-count-based-of-multiple-criteria-sample
Sheet: BONOUS

CUSTOMER CODE --->> |  | 0026628X
 |  |  | TOTAL COUNT | SUM | UNIQUE COUNT |  |  |  | unique count(unique DOB in NB sheet) in Col.F6 if C2 satisfies below mentioned contidions:-
20190401 | 20200331 |  |  |  |  |  |  |  | IF(NB!A:A,"NB"and NB!M:M,C2 and NB!F:F>=A6 and NB!F:F<=&B6, nb!L:L (UNIQUE DOB)
20180401 | 20190331
20170401 | 20180331 |  |  |  |  |  |  |  | EXPECTED ANSWER IN WRITTEN IN COL F6 AND F14
20160401 | 20170331
20150401 | 20160331
20140401 | 20150331 |  |  |  |  |  |  | 1 | Total record for 0026628X in sheet NB >=F6(i.e. >=20190401) and <=B6(i.e. 20200331)
20130401 | 20140331 |  |  |  |  |  |  | 2 | are 7 out of which one record(seria; number 7) has "ND" flag so it does not satisfy condition NB!A:A="NB"
20120401 | 20130331 |  |  |  |  |  |  |  | Out of 6 records which satifies  condition 1 & 2 four records(in red color) are duplicates)
20110401 | 20120331 |  |  |  |  |  |  |  | so the answer in col. F6 should be 5
20100401 | 20110331
20090401 | 20100331 |  |  |  |  |  |  |  | Simalarly answer in F14 should be 6
20080401 | 20090331
20070401 | 20080331
20060401 | 20070331
SUM(--(FREQUENCY(IF(NB!A:A,"NB")*(NB!M:M,C2)*(NB!F:F,">="&A6)*(NB!F:F,"<="&B6),NB!L:L),NB!L:[NAME]))))
Spreadsheet: 464104d1464876915-filter-data-in-3-levels-workbook-test-plan
Sheet: Sheet1

Test | Expected result
test 1 | result 1
test 2 | result 2
test 3 | result 3
test 4 | result 4
test 5 | result 5
test 6 | result 6
test 7 | result 7
test 8 | result 8
test 9 | result 9
test 10 | result 10
Spreadsheet: 718809d1613368345-extract-a-range-based-on-a-value-sample
Sheet: Sheet2

EG740F
Power (kW) | Engine LS | Power take-off (rpm) | (Nm) |  | 70
70 | 900
70
70
70
Power (kW) | Engine HS | Power take-off (rpm) | (Nm)
70 | 700
70
Power (kW) | Engine LS | Power take-off (rpm) | (Nm)
100 | 1200
100
100
Power (kW) | Engine HS | Power take-off (rpm) | (Nm)
100 | 1300
 |  |  |  |  |  |  | TRUE Answer | Power (kW) | Engine LS | Power take-off (rpm) | (Nm)
 |  |  |  |  |  |  |  | 70 | 900 | 1485 | 450.1683501683502
 |  |  |  |  |  |  |  | 70 | 1000 | 1650 | 405.1515151515151
 |  |  |  |  |  |  |  | 70 | 1100 | 1815 | 368.3195592286501
 |  |  |  |  |  |  |  | 70 | 1200 | 1980 | 337.6262626262626
 |  |  |  |  |  |  |  | Power (kW) | Engine HS | Power take-off (rpm) | (Nm)
 |  |  |  |  |  |  |  | 70 | 700 | 1428 | 468.1372549019608
 |  |  |  |  |  |  |  | 70 | 800 | 1632 | 409.6200980392157
Spreadsheet: 734042d1621952083-dependency-drop-down-based-on-values-from-another-cell-eh_prm_test-part-1
Sheet: Data_Do Not Use

Attribution​ - Product Attribution |  | Attribution​_Product Attribution | Attribution_Hierarchy | Attribution​_Purchase Attribution | Attribution​_Retailer Attribution
Attribution​ - Hierarchy |  | Attribute (Amend Existing) | Market Scope (Amend Existing)
Attribution​ - Purchase Attribution |  | Attribute (Create New) | Market Scope (Create New)
Attribution​ - Retailer Attribution |  | Attribute Product Coding Extract | True Hierarchy (Amend Existing) & User Permissions: Yes
 |  | Attribute alignment (New Alignment) | True Hierarchy (Create New) & User Permissions: No
 |  | Attribute alignment (Re-Alignment) | False Hierarchy (Amend Existing) & User Permissions: Yes
 |  | Volume Equivalence (Amend Existing) | False Hierarchy (Create New) & User Permissions: No
 |  | Volume Equivalence (Create New) | Retailer Hierarchy (Amend Existing) & Request client: Yes
 |  |  | Retailer Hierarchy (Create New) & Request client: No
Spreadsheet: 176321d1345814776-num-error-in-formula-num-error
Sheet: Sheet1

 | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
AAS | 29953.78 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JAN
CBL | 135224.21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB
CDH | 13248.13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAR
DBL | 1376772.74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APR
ESL | 513840.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY
FABL | 181936.58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUN
FBSL | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUL
GCSL | 226971.66 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUG
HFC | 133890.98 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEP
ICS | 192264.14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCT
LC | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOV
MSL | 197581.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEC
NTHC | 325416.36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ROW NO | 1
NWS | 76556.4
PSL | 21286.1
SAS | 0
SDC | 145144.03
SICFSL | 138324.6
SIMS | 130751
WSL | 0
Spreadsheet: 134261d1325150659-excel-2007-sorting-data-automatically-and-plotting-into-graph-sling-calculation-2
Sheet: Sheet1

Grommet Efficiency
0.3056 | x ln (D/d) + | 1.042 | ASB
 |  |  |  |  | Strength (t)
[NAME] (mm) | Rope Dia (mm) | [NAME] (t) | D/d Factor | Grommet Efficiency | Single Leg | Grommet |  | [NAME] (mm) | [NAME] (t)
40.6 |  |  |  |  |  |  |  | 2.5 | 0.73
54.1 |  |  |  |  |  |  |  | 3 | 1.1
63.5 |  |  |  |  |  |  |  | 4 | 1.8
79.5 |  |  |  |  |  |  |  | 5 | 2.4
95.3 |  |  |  |  |  |  |  | 6 | 3.9
114 |  |  |  |  |  |  |  | 8 | 6.2
121 |  |  |  |  |  |  |  | 9 | 8.9
150 |  |  |  |  |  |  |  | 11 | 10.8
205 |  |  |  |  |  |  |  | 12 | 15.4
264 |  |  |  |  |  |  |  | 14 | 18.4
320 |  |  |  |  |  |  |  | 16 | 24
340 |  |  |  |  |  |  |  | 18 | 29.2
370 |  |  |  |  |  |  |  | 20 | 37.2
400 |  |  |  |  |  |  |  | 22 | 41.2
420 |  |  |  |  |  |  |  | 24 | 49.4
440 |  |  |  |  |  |  |  | 26 | 59.6
460 |  |  |  |  |  |  |  | 28 | 67.1
530 |  |  |  |  |  |  |  | 30 | 75
580 |  |  |  |  |  |  |  | 32 | 83.6
 |  |  |  |  |  |  |  | 34 | 93.2
 |  |  |  |  |  |  |  | 36 | 103
 |  |  |  |  |  |  |  | 38 | 115
 |  |  |  |  |  |  |  | 40 | 128
 |  |  |  |  |  |  |  | 42 | 139
 |  |  |  |  |  |  |  | 44 | 152
 |  |  |  |  |  |  |  | 48 | 173
 |  |  |  |  |  |  |  | 50 | 190
 |  |  |  |  |  |  |  | 52 | 207
 |  |  |  |  |  |  |  | 56 | 244
 |  |  |  |  |  |  |  | 60 | 267
 |  |  |  |  |  |  |  | 64 | 300
 |  |  |  |  |  |  |  | 68 | 333
 |  |  |  |  |  |  |  | 72 | 377
 |  |  |  |  |  |  |  | 76 | 417
 |  |  |  |  |  |  |  | 80 | 457
 |  |  |  |  |  |  |  | 82 | 508
 |  |  |  |  |  |  |  | 86 | 531
 |  |  |  |  |  |  |  | 88 | 662
 |  |  |  |  |  |  |  | 92 | 738
 |  |  |  |  |  |  |  | 96 | 825
 |  |  |  |  |  |  |  | 104 | 920
 |  |  |  |  |  |  |  | 110 | 1019
 |  |  |  |  |  |  |  | 112 | 1117
 |  |  |  |  |  |  |  | 120 | 1220
 |  |  |  |  |  |  |  | 128 | 1329
 |  |  |  |  |  |  |  | 134 | 1444
 |  |  |  |  |  |  |  | 146 | 1562
 |  |  |  |  |  |  |  | 152 | 1618
 |  |  |  |  |  |  |  | 156 | 1681
 |  |  |  |  |  |  |  | 158 | 1805
 |  |  |  |  |  |  |  | 164 | 1934
 |  |  |  |  |  |  |  | 168 | 2068
 |  |  |  |  |  |  |  | 178 | 2203
 |  |  |  |  |  |  |  | 184 | 2348
 |  |  |  |  |  |  |  | 190 | 2493
 |  |  |  |  |  |  |  | 194 | 2642
 |  |  |  |  |  |  |  | 196 | 2676
 |  |  |  |  |  |  |  | 204 | 2792
Spreadsheet: 842563d1694607063-countifs-giving-0-value-when-total-is-known-training_report-forum-etaf
Sheet: Instructions

Instructions
Step 1
Delete columns A, B, D, E, F, G, H, I, P, Q, R, S, T, U, W, AE, AF, AG, AK from DRUID report
Important: before deleting columns U, W, AG and AK, add the course number before [NAME]
Step 2
Cut column A (name) and move it between columns E and F
Step 3
Move the course columns in the following order:
TD1599-001 Health & Safety for Emp. - Only one time | TD1599-006 COVID-19 Health & Safety for Emp. - Only one time | TD1807-000 [NAME] - Only one time | COR310 Security Awareness - Every 5 years | WMT101 Preventing Harassment and Violence in the Workplace | TD1528-000 Code of Ethics & Conduct - Only one time | GS9170-034 Underst. Pay Cycle - Only one time | GS9170-035 HR-to-Pay Interfac - Only one time | TD1599-003 Health & Safety for Mgrs - Only one time (managers only) | TD1582-001 PM&You - Only one time (managers only) | TD1578-002 UMA workshop - Only one time (managers only) | TD1808-000 System Access Mgt (SAM) - Every 5 years (managers only)
Step 4
Select from the second row (first name) to the last row
Step 5
Copy and paste values into the second row of the Master Data tab (right below the headers)
Step 6
Type the report date at the top of the master data tab
Spreadsheet: sally_beck__35756__MgmtSum-Q1-0222
Sheet: CapChrg-AllocExp

PLAN2000
CAP_CHRG | ENRON NORTH AMERICA
TOT_ALLOCATION | 1ST QUARTER 2000 CAPITAL CHARGE & ALLOCATED EXPENSES
2000-03-01 00:00:00
M.QTD
ENA
 |  |  | Capital Charge |  |  |  |  |  |  | Allocated Expense
 | Business Team |  | Forecast | Plan | [NAME] | Explanation |  |  |  | Forecast | Plan | [NAME] | Explanation
[NAME] | Gas Trading
[NAME] | Power Trading
IR_FX | Financial Drift
[NAME] | Financial Trading
CANADA | Canada |  | 207
COAL | Coal |  | 618 |  |  | Merlin (American Coal, Dakota, [NAME])
WEATHER | Weather
SO2 | Emissions
INSURANCE | Insurance Group
EXEC_TRD | Executive Trading
 | Total Trading & Risk Mgmt
E_ORG | East Midstream
W_ORIG | West Midstream |  | 1377 |  |  | Big Horn investment
PAPER | Industrial Downstream - Paper |  | 285 |  |  | Merlin (City Forest, Oconto Falls) & Repap sale 2 months early
DWNSTRM_IND_ORIG | Industrial Downstream - Chemicals |  | 76 |  |  | Lower 1999 investing activity
MDSTRM_IPP_ORIG | Midstream IPP
PROD_FIN | Upstream E&P |  | 5696 |  |  | Merlin (HV Marine, LSI, Ridgelake) & Iguana (Mariner)
ENVR_ENGY | Asset Management |  | 1308 |  |  | Merlin (CanFibre, Heartland, Kafus Bridge) & Condor (Heartland)
MEXICO | Mexico
EXEC_ORIG | Executive Origination
 | Total Origination
GENCOS | Genco
N_BS_DEV | Generation Investments |  | 3239 |  |  | Iguana (East Coast Power)
ASST_ORIG | Gas Assets |  | 8242 |  |  | Hurricane delay & Nahanni credit
ASST_TRD | Gas Assets - Trading
 | Total Assets
EQUITY | Principal Investing |  | 1016 |  |  | Condor (Quanta)
RESTRUCTURING | Restructuring |  | 1477 |  |  | Carrizo sale
FIN | Canada - Investing
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman
 | Capital Charge Offset
 | Total Commercial
GROUP | Group
 | Total
Spreadsheet: 207870d1358592559-checklist-test
Sheet: LCI-2

[NAME]
 |  |  | Completed | Applicable | Not applicable
Check alignment between all objects all and STID  change notices               (LCI/DCC) |  |  |  |  |  |  | 1
LCI-2 documentation imported to STID                                                              (DCC) |  |  |  |  |  |  | 2
Commissioning procedure imported to STID                         (Commissioning/DCC) |  |  |  |  |  |  | 3
All comments on teamsite regarding LCI answered/verified.                  (LCI) |  |  |  |  |  | Ref. Procosys guideline 5.2 | 4
3D model report sent to company                                                                        (LCI) |  |  |  |  |  | Ref. TIME guideline 4.2.7 | 5
All M5 tasks related to relevant com-pck checked and completed (LCI/SAP) |  |  |  |  |  | Ref. teamsite guideline | 6
Demolition tags  in SAP  disconnected                                                (LCI/SAP) |  |  |  |  |  |  | 7
FV-program removed from demolition tags in SAP                          (LCI/SAP) |  |  |  |  |  | Ref. SAP guideline 3 | 8
EOD M5 completed  for the relevant system                                     (LCI/SAP) |  |  |  |  |  | Ref. SAP guideline 3.5.1 | 9
MCCR list completed in Procosys                                                                          (LCI) |  |  |  |  |  |  | 10
All DCR evaluated and completed for LCI                                                           (LCI) |  |  |  |  |  |  | 11
Date | LCI responsible signature