tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 751448d1634124116-convert-sumifs-to-sumproduct-or-similar-example-2-
Sheet: Project Projections 2021

 | From Date | To Date | Wallet Type | Wallet Quantity
 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | Wallet Print @ Home | 100
 | 2021-01-11 00:00:00 | 2021-01-14 00:00:00 | Wallet Clear Plastic -B/fly/A7 Slot | 300
 | 2021-01-13 00:00:00 | 2021-01-15 00:00:00 | No Wallets
 | 2021-01-17 00:00:00 | 2021-01-20 00:00:00 | Wallet Print @ Home | 300
 | 2021-01-19 00:00:00 | 2021-01-21 00:00:00 | Wallet [NAME]
 | 2021-01-22 00:00:00 | 2021-01-24 00:00:00 | Wallet A7 with Croc Clip | 35
 | 2021-01-27 00:00:00 | 2021-01-27 00:00:00 | Wallet Clear Plastic -B/fly/A7 Slot
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | Wallet Clear Plastic -B/fly/A7 Slot
 | 2021-02-15 00:00:00 | 2021-02-19 00:00:00 | Wallet Print @ Home
 | 2021-02-24 00:00:00 | 2021-02-24 00:00:00 | Wallet [NAME] | 600
 | 2021-03-01 00:00:00 | 2021-03-01 00:00:00 | No Wallets
 | 2021-03-01 00:00:00 | 2021-03-01 00:00:00 | No Wallets
 | 2021-03-04 00:00:00 | 2021-03-04 00:00:00 | No Wallets
 | 2021-03-05 00:00:00 | 2021-03-06 00:00:00 | No Wallets
 | 2021-03-09 00:00:00 | 2021-03-11 00:00:00 | No Wallets
 | 2021-03-09 00:00:00 | 2021-03-10 00:00:00 | No Wallets
 | 2021-03-10 00:00:00 | 2021-03-10 00:00:00 | No Wallets
 | 2021-03-16 00:00:00 | 2021-03-18 00:00:00 | No Wallets
 | 2021-03-20 00:00:00 | 2021-03-20 00:00:00 | No Wallets
 | 2021-03-22 00:00:00 | 2021-03-29 00:00:00 | No Wallets
 | 2021-03-24 00:00:00 | 2021-03-28 00:00:00 | No Wallets
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: AGarvey

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 456127d1460652232-how-to-use-vslookup-for-3-products-book3
Sheet: Sheet1

 | Brand | Flavour | Price |  |  |  | ice cream | [NAME] | [NAME] | bammer
 | [NAME] | w3642 |  |  |  |  | w0942 | 84 | 80 | 70
 |  |  |  |  |  |  | w1242 | 92 | 86 | 80
 |  |  |  |  |  |  | w1542 | 102 | 94 | 90
 |  |  |  |  |  |  | w1842 | 108 | 102 | 98
 |  |  |  |  |  |  | w2142 | 116 | 110 | 80
 |  |  |  |  |  |  | w2442 | 142 | 134 | 120
 |  |  |  |  |  |  | w2742 | 150 | 142 | 130
 |  |  |  |  |  |  | w3042 | 160 | 150 | 140
 |  |  |  |  |  |  | w3342 | 168 | 156 | 140
 |  |  |  |  |  |  | w3642 | 176 | 164 | 150
 |  |  |  |  |  |  | w3024 | 110 | 104 | 99
 |  |  |  |  |  |  | w3324 | 116 | 110 | 98
 |  |  |  |  |  |  | w3624 | 120 | 112 | 110
 |  |  |  |  |  |  | wdc2442 | 168 | 152 | 140
 |  |  |  |  |  |  | wea1242 | 88 | 82 | 80
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Scheduled | Measured | Scheduled | Measured
1 |  |  | 28261 | 32518
2 |  |  | 15248 | 16267
3 |  |  | 15248 | 16171
4 |  |  | 33781 | 36068
5 |  |  | 43200 | 42962
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-05-31 00:00:00 |  |  |  |  | 326781.87
2001-06-05 00:00:00
Spreadsheet: 165524d1341256558-getting-a-cell-to-populate-when-it-sees-a-name-airframe-sample-11
Sheet: Tech Log

G-BSGL                            Technical Log |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine
 |  |  | of Flight | Off | Off |  | ON | Time | Time | 2 days, 2:00:00 | Defects
2012-07-01 00:00:00 | G Smith | 2 | EGCV | 10:10:00 | 10:15:00 | 11:15:00 | 11:20:00
2012-07-02 00:00:00 | A Jones | 1 | EGCV | 11:00:00 | 11:05:00 | 11:55:00 | 12:00:00
2012-07-03 00:00:00 | A Jones |  |  | 13:00:00 | 13:05:00 | 13:55:00 | 14:00:00
2012-07-04 00:00:00 | G Smith |  |  | 12:07:00 | 12:09:00 | 14:34:00 | 14:45:00
2012-07-05 00:00:00 | G Smith |  |  | 12:27:00 | 12:28:00 | 12:29:00 | 12:30:00
G-BSGL                            Technical Log |  |  |  |  |  |  |  |  | [NAME]
G-BSGL                            Technical Log |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine
 |  |  | of Flight | Off | Off |  | ON | Time | Time | 2 days, 2:00:00 | Defects
G-BSGL                            Technical Log |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine
 |  |  | of Flight | Off | Off |  | ON | Time | Time | 2 days, 2:00:00 | Defects
G-BSGL                            Technical Log |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine
 |  |  | of Flight | Off | Off |  | ON | Time | Time | 2 days, 2:00:00 | Defects
Spreadsheet: 191280d1352041685-return-multiple-values-with-multiple-rows-and-multiple-columns-sample
Sheet: Sheet2

Emp Code | Name | Desg | Late | Absent | Holiday
1001 | Jone | Supervisor | 3,5,13,19 |  | 22,26
1002 | [NAME] | 1 officer |  |  | 26
1003 | [NAME] | 2 officer | 18,23,29
1004 | Jupiter | Sr Supervisor | 10
1005 | Candy | Supervisor | 14,17 | 29
1006 | Flower | 2 officer |  | 1 | 22
1007 | San | Sr Supervisor |  |  | 26
1008 | March | 1 officer |  |  | 22
1009 | Rose | 1 officer | 11 | 4 | 26
1010 | Lilly | 2 officer |  | 26,29
1011 | Seng | 1 officer |  | 2
1012 | [NAME] | Supervisor | 8 |  | 22
1013 | [NAME] | 2 officer
1014 | [NAME] | 2 officer |  | 3 | 22,26
1015 | [NAME] | 1 officer | 10 | 25
1016 | Mathew | 2 officer |  | 6 | 22
1017 | [NAME] | Sr Supervisor |  |  | 26
1018 | Nicky | 2 officer |  | 2,11,16 | 22
1019 | Roshan | Supervisor | 8,13
1020 | [NAME] | 1 officer |  |  | 22,26
Spreadsheet: 883305d1731904211-rolling-subtraction-of-numbers-ongoing-contribution-history-carry-forward-wip-
Sheet: Concessional

 | Summary | Client |  |  | Complete
 | Total CC Recorded |  |  |  | Reference
 | ATO Figure - Used |  |  |  | Calculated
 | Variance - Used
 | Status
 | Concessional Contribution Contribution History
 | Start Date | End Date | SG | Sal Sac | CC | Insurance [NAME] | NCC (Claimed NoI) | Total | [NAME] | Available | [NAME] | Space | ATO Portal Checked | ATO Figures (Used) | [NAME] | Total Super Bal SOP | [NAME] | Date Verified | Notes
 | 2024-07-01 00:00:00 | 2025-06-30 00:00:00 |  |  |  |  |  |  | 30000
 | 2023-07-01 00:00:00 | 2024-06-30 00:00:00 |  |  |  |  |  |  | 27500
 | 2022-07-01 00:00:00 | 2023-06-30 00:00:00 | 26293.51 |  |  |  |  |  | 27500
 | 2021-07-01 00:00:00 | 2022-06-30 00:00:00 | 57438.6 |  |  |  |  |  | 27500
 | 2020-07-01 00:00:00 | 2021-06-30 00:00:00 | 12319.1 |  |  |  |  |  | 25000
 | 2019-07-01 00:00:00 | 2020-06-30 00:00:00 | 783.63 |  |  |  |  |  | 25000
 | 2018-07-01 00:00:00 | 2019-06-30 00:00:00 | 24587.63 |  |  |  |  |  | 25000
 | Start Date | Year Ending | Contributions | Annual [NAME] | Excess to Annual [NAME] | Current Year Unused Cap | Last Year Unused Cap | Year 2 Unused [NAME] | Year 3 Unused Cap | Year 4 Unused [NAME] | Year 5 Unused [NAME]
 | 2024-07-01 00:00:00 | 2025-06-30 00:00:00
 | 2023-07-01 00:00:00 | 2024-06-30 00:00:00
 | 2022-07-01 00:00:00 | 2023-06-30 00:00:00
 | 2021-07-01 00:00:00 | 2022-06-30 00:00:00 |  |  |  |  | 7371.04 | 0 | 0
 | 2020-07-01 00:00:00 | 2021-06-30 00:00:00
 | 2019-07-01 00:00:00 | 2020-06-30 00:00:00
 | 2018-07-01 00:00:00 | 2019-06-30 00:00:00 |  |  |  |  | N/A
Spreadsheet: 212352d1360099917-data-on-one-sheet-sorted-on-another-testfinal
Sheet: Sheet2

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | s
a | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8
c | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5
g | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4
b | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
d | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
f | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
e | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
h | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Spreadsheet: 699551d1602662627-how-to-display-multiple-bills-from-a-budget-until-the-next-pay-date-new-budget-sheet-3-
Sheet: Main Budget

PAY | Monthly BILLS | DUE DATES |  | Date | PAY | Bi-Weekly | TYPE
2600 | Mortgage (3755): | ([NAME]) Auto - 1st |  | 2020-10-01 00:00:00 | 1300 | Mortgage (3755): | ([NAME]) Auto
90.98 | FuboTV | (6307 Discover) Auto - 3th |  | 2020-10-03 00:00:00 | 90.98 | FuboTV | (6307 Discover) Auto
85 | FedLoan: | (Main Chase Checking) Auto - 4th |  | 2020-10-04 00:00:00 | 85 | FedLoan: | (Main Chase Checking) Auto
13.93 | [NAME]: | (6307 Discover) Auto - 4th |  | 2020-10-04 00:00:00 | 13.93 | [NAME]: | (6307 Discover) Auto
0 | Discover (6195): | 5th |  | 2020-10-05 00:00:00 | 0 | Discover (6195):
0 | BlueCash CC (): | 7th |  | 2020-10-07 00:00:00 | 0 | BlueCash CC ():
0 | SavorOne (4972): | 8th |  | 2020-10-08 00:00:00 | 0 | SavorOne (4972):
493.18 | Ascent: | (Main Chase Checking) Auto - 9th |  | 2020-10-09 00:00:00 | 493.18 | Ascent: | (Main Chase Checking) Auto
250 | WJ Utilities: | (9486 Chase Credit) Auto - 10th |  | 2020-10-10 00:00:00 | 250 | WJ Utilities: | (9486 Chase Credit) Auto
76 | Dominion Gas: | (Main Chase Checking) Auto - 12th |  | 2020-10-12 00:00:00 | 76 | Dominion Gas: | (Main Chase Checking) Auto
65.16 | Auto Ins: | (6307 Discover) Auto - 16th |  | 2020-10-16 00:00:00 | 65.16 | Auto Ins: | (6307 Discover) Auto
0 | Citi CC (3588): | 21st |  | 2020-10-21 00:00:00 | 0 | Citi CC (3588):
0 | Chase Freedom CC (9486): | 21st |  | 2020-10-21 00:00:00 | 0 | Chase Freedom CC (9486):
50.5 | Xfinity Internet: | (6307 Discover) Auto - 21st |  | 2020-10-21 00:00:00 | 50.5 | Xfinity Internet: | (6307 Discover) Auto
140 | Rocky Power: | (Main Chase Checking) Auto - 29th |  | 2020-10-29 00:00:00 | 140 | Rocky Power: | (Main Chase Checking) Auto
5.35 | Apple Music: | (6307 Discover) Auto - 29th |  | 2020-10-29 00:00:00 | 5.35 | Apple Music: | (6307 Discover) Auto
140 | Koda School: | ([NAME]) - 30th |  | 2020-10-30 00:00:00 | 140 | Koda School: | [NAME]
1000 | Groceries (9786): |  |  |  | 500 | Groceries (9786):
180 | Gas (5138): |  |  |  | 90 | Gas (5138):
60 | Medical (9809): |  |  |  | 30 | Medical (9809):
300 | Shopping (9122): |  |  |  | 150 | Shopping (9122):
300 | Date Night (9528): |  |  |  | 150 | Date Night (9528):
0 | Extra (5321): |  |  |  | 0 | Extra (5321):
0 | [NAME] (6560): |  |  |  | 0 | [NAME] (6560):
0.1 | Tithing (5989): |  |  |  | 0.1 | Tithing (5989):
50 | [NAME] (0528): |  |  |  | 25 | [NAME] (0528):
50 | [NAME] (9927): |  |  |  | 25 | [NAME] (9927):
50 | Kenai Sav (0846): |  |  |  | 25 | Kenai Sav (0846):
20 | Emergency Sav (1501): |  |  |  | 10 | Emergency Sav (1501):
0 | Debts (0179): |  |  |  | 0 | Debts (0179):
 | TOTAL: |  |  |  |  | TOTAL:
Spreadsheet: 186227d1349963415-vlookup-between-dates-sample1
Sheet: Sheet1

CODE | DATE | VALUE
A | 2012-02-01 00:00:00 | 1
B | 2012-02-01 00:00:00 | 8
C | 2012-06-03 00:00:00 | 9
D | 2012-06-03 00:00:00 | 5
E | 2012-05-01 00:00:00 | 4
F | 2012-02-02 00:00:00 | 6
A | 2012-02-02 00:00:00 | 3
A | 2012-06-08 00:00:00 | 7
G | 2012-06-08 00:00:00 | 2
E | 2012-09-02 00:00:00 | 5
F | 2012-03-01 00:00:00 | 6
A | 2012-09-01 00:00:00 | 4
B | 2012-02-02 00:00:00 | 12
C | 2012-02-02 00:00:00 | 36
D | 20/02/212 | 5
Spreadsheet: 154543d1336481079-nested-if-ordering-issue-example
Sheet: Sheet1

 |  | selection |  |  |  |  |  | person | rate
 |  | abcdef |  |  |  |  |  | bob |  | //ok
 |  | [NAME] |  |  |  |  |  | bob |  | //not ok..should be 10
 |  | abcxyz |  |  |  |  |  | [NAME] |  | //not ok..should be 10
 |  |  |  |  |  |  |  |  |  | //break..chnage formula
 |  | abcxyz |  |  |  |  |  | jane |  | //ok
 |  | [NAME] |  |  |  |  |  | bob |  | //not ok..should be 10
 |  | [NAME] |  |  |  |  |  | jane |  | //not ok..should be 0
Spreadsheet: 822429d1679340480-filter-function-nested-if-multi-better-simpler-expression-combobox-filter-isnumber-independent-4-combo-az-
Sheet: SEARCH AZ

MAKE | MODEL | FUEL | TYPE | SEARCH < COMBO |  |  | DESIGN: HOW TO INSTRUCTIONS (EXCEL 2021 / 365)
PEU |  |  |  |  |  |  | DESC | TAB | CELL | FORMULA  / INSTRUCTIONS
 |  |  |  |  |  |  | DYN TABLE | DATA |  | SELECT DATA: INSERT > TABLE
 |  |  |  |  |  |  | UNIQUE | DATA | H2 | =IFERROR(INDEX(TableDiv[MAKE],MATCH(0,INDEX(COUNTIF($H$1:H1,TableDiv[MAKE]),),0)),"")
 |  |  |  |  |  |  | COL A DV:  MAKE | DATA | J2 | =SORT(UNIQUE(FILTER(TableDiv[MAKE],ISNUMBER(SEARCH(_MODEL,TableDiv[MODEL])+SEARCH(_FUEL,TableDiv[FUEL])+SEARCH(_TYPE,TableDiv[TYPE])))))
 |  |  |  |  |  |  | COL B DV: MODEL | DATA | K2 | =SORT(UNIQUE(FILTER(TableDiv[MODEL],ISNUMBER(SEARCH(_MAKE,TableDiv[MAKE])+SEARCH(_FUEL,TableDiv[FUEL])+SEARCH(_TYPE,TableDiv[TYPE])))))
 |  |  |  |  |  |  | COL C DV: FUEL | DATA | L2 | =SORT(UNIQUE(FILTER(TableDiv[FUEL],ISNUMBER(SEARCH(_MAKE,TableDiv[MAKE])+SEARCH(_MODEL,TableDiv[MODEL])+SEARCH(_TYPE,TableDiv[TYPE])))))
SEARCH RESULTS
MAKE | MODEL | FUEL | TYPE | Desc | IG |  | COL D DV: TYPE | DATA | M2 | =SORT(UNIQUE(FILTER(TableDiv[TYPE],ISNUMBER(SEARCH(_MAKE,TableDiv[MAKE])+SEARCH(_MODEL,TableDiv[MODEL])+SEARCH(_FUEL,TableDiv[TYPE])))))
 | 2O6 | DIESEL | GT Hdi | [NAME] | 7
Peugeot | 2O6 | DIESEL | Hdi | [NAME] | 7 |  | COMBO A SRCH | SRCH | A2 | DATA > DATA VALIDATION > LIST:   =DATA!J2#                               NOTE: PART WORD SEARCH
Peugeot | 2O6 | PETROL | GTI | Sporty | 10 |  | COMBO B SRCH | SRCH | B2 | DATA > DATA VALIDATION > LIST:   =DATA!K2#                               NOTE: PART WORD SEARCH
Peugeot | 2O7 | PETROL | Gti | OK | 15 |  | COMBO C SRCH | SRCH | C2 | DATA > DATA VALIDATION > LIST:   =DATA!L2#                               NOTE: PART WORD SEARCH
Peugeot | 3O6 | DIESEL | TD | [NAME] | 13 |  | COMBO D SRCH | SRCH | D2 | DATA > DATA VALIDATION > LIST:   =DATA!M2#                             NOTE: PART WORD SEARCH
Peugeot | 3O7 | DIESEL | Hdi | [NAME] | 11 |  | SRCH DYN 4 COMBO | A12 |  | =SORT(FILTER(TableDiv,ISNUMBER(SEARCH(_MAKE,TableDiv[MAKE]) +SEARCH(_MODEL,TableDiv[MODEL]) +SEARCH(_FUEL,TableDiv[FUEL]) +SEARCH(_TYPE,TableDiv[TYPE]))),{1,2,3,4})
Peugeot | 3O7 | DIESEL | Hdi | Super | 11
 |  |  |  |  |  |  | BLANK NO ZERO | DATA | AV:BA | SELECT BLANK CRITERIA RESULTS: FORMAT CELLS > CUSTOM: 0;-0;;@
Spreadsheet: 844609d1696370634-assembly-part-calculation-example
Sheet: Sheet2

[NAME] | Kiekis | įeina
Varztas1 | 4 | SB1
Detalė1 | 1 | SB1
Detalė2 | 2 | SB1
Varztas1 | 8 | SB2
Detalė1 | 1 | SB2
Detalė2 | 2 | SB2
Spreadsheet: 879665d1727230371-dept-and-date-to-auto-calculate-based-on-todays-date-example-9
Sheet: Shift per dept

 |  | Shift
 | Dept | 1 | 2 | 3
 | Grocery
 | Deli
 | Meat
 | Freezer
 | Produce
Spreadsheet: darron_c_giron__7955__inthemoney
Sheet: Sheet3

Deal Num | CounterParty | Exp Dt | Phy/Fin | [NAME] | Mid Value
YB7858.1 | COASTENEGRO | 2002-03-01 00:00:00 | f | -309551.9756 | -6191.0395
YF0948.2 | DYNEGYCAN | 2002-03-01 00:00:00 | f | -309551.9756 | 0.031
Y38011.3 | RG&E | 2002-04-01 00:00:00 | f | -299075.9965 | 0.0299
Y38011.3 | RG&E | 2002-03-01 00:00:00 | f | -309551.9756 | 3095.5507
Spreadsheet: 885459d1735065257-rank-students-according-to-marks-obtained-based-on-multiple-criteria-rank-function2
Sheet: RESULT

ABCD SCHOOL
TOTAL
Sl. No. | Name of the Student | Class | Sec. | Roll No. | Sex | Cat. | Status | Total Marks Obtained | Grade | % Marks Obtained | Exected Rank | Qualified / Not-qualified
 | [NAME] | X | A | 1 | G | SC | AP | 447 | 0D | 0.6385714285714286 | 1 | PASS
 | RIYA BARMAN | X | A | 2 | G | SC | AP | 447 | 0D | 0.5971428571428572 | 2 | PASS
 | [NAME] | X | A | 3 | G | GEN | AP | 447 | 3D | 0.6385714285714286 | 8 | PASS
 | [NAME] | X | A | 4 | G | GEN | AP | 300 | 0D | 0.5842857142857143 | 4 | PASS
 | [NAME] | X | A | 5 | B | GEN | AP | 447 | 2D | 0.4442857142857143 | 7 | PASS
 | [NAME] | X | A | 6 | G | SC | AP | 350 | 0D | 0.5642857142857143 | 3 | PASS
 | [NAME] | X | A | 7 | G | SC | AP | 447 | 4D | 0.4828571428571429 | 9 | PASS
 | KAKALI BARMAN | X | A | 8 | G | GEN | AP | 447 | 1D | 0.4728571428571429 | 6 | PASS
 | BARNALI BARMAN | X | A | 9 | G | SC | AP | 450 | 1D | 0.4642857142857143 | 5 | PASS
Spreadsheet: 679633d1590543759-sumif-trouble-with-unique-values-and-summing-the-max-values-sumif-trouble-visk92-
Sheet: Sheet1

 |  |  |  |  | [NAME] for all Unique Name/week combinations
Week | Name | Orders |  |  |  |  | Week | Name | Max of Orders
1 | [NAME] |  |  |  |  |  | 1 | [NAME] | 7000
1 | [NAME] |  |  |  |  |  |  | [NAME] | 1000
1 | [NAME] |  |  |  |  |  |  | [NAME] | 200
1 | [NAME] |  |  |  |  |  |  | Sum of Max | 8200
1 | [NAME]
1 | [NAME]
Spreadsheet: tracy_geaccone__40558__2002 Benefits Guidelines
Sheet: Sheet1

Enron Corp.
2002-2003 Benefit Guidelines
I. | Flex Dollars to Budget per Employee for Enron :
 |  |  |  |  | 2002 |  | 2003
 | U.S. Employees |  |  |  | 4800 |  | 5000
II. | Plus the following percent of annualized payroll for non-regulated companies (except EOTT)
 |  |  |  |  | 2002 |  | 2003
 |  | Cash Balance and SERP |  |  | 0.0375 |  | 0.036
 |  | FAS 106 |  |  | 0.0125 |  | 0.015
 |  | Savings Plan |  |  | 0.03 |  | 0.03
 |  | Other |  |  | 0.011 |  | 0.011
 |  | Total
III. | Plus the following percent of annualized payroll for regulated companies and EOTT.
 |  |  |  |  |  |  |  |  | 2002
 |  |  |  |  |  |  | Cash Balance |  | Savings
 |  |  |  |  |  |  | & SERP |  | Plan |  | FAS 106 |  | Other | Total
 |  | Transwestern |  |  |  |  | 0.0375 |  | 0.03 |  | 0.045
 |  | Florida Gas Transmission |  |  |  |  | 0.05 |  | 0.03 |  | 0.055
 |  | Citrus Corp. |  |  |  |  | 0.041 |  | 0.03 |  | 0.0125
 |  | Northern Plains Natural Gas Company |  |  |  |  | 0.0275 |  | 0.03 |  | 0.02
 |  | Northern Natural Gas |  |  |  |  | 0.08 |  | 0.03 |  | 0.07
 |  | Gas Pipeline Group |  |  |  |  | 0.025 |  | 0.03 |  | 0.012
 |  | EOTT |  |  |  |  | 0.04 |  | 0.03 |  |  |  | N/A
 |  |  |  |  |  |  |  |  | 2003
 |  |  |  |  |  |  | Cash Balance |  | Savings
 |  |  |  |  |  |  | & SERP |  | Plan |  | FAS 106 |  | Other | Total
 |  | Transwestern |  |  |  |  | 0.035 |  | 0.03 |  | 0.045
 |  | Florida Gas Transmission |  |  |  |  | 0.0475 |  | 0.03 |  | 0.06
 |  | Citrus Corp. |  |  |  |  | 0.0375 |  | 0.03 |  | 0.0125
 |  | Northern Plains Natural Gas Company |  |  |  |  | 0.025 |  | 0.03 |  | 0.02
 |  | Northern Natural Gas |  |  |  |  | 0.0775 |  | 0.03 |  | 0.072
 |  | Gas Pipeline Group |  |  |  |  | 0.025 |  | 0.03 |  | 0.014
 |  | EOTT |  |  |  |  | 0.0375 |  | 0.03 |  |  |  | N/A
 | Note to [NAME]:  This document is intended to provide guidelines for O&M budget.  Actual charges are dependent upon
 | employee elections, actual valuation results and 2002 plan pricing adjustments.
Spreadsheet: 72411d1273088602-formula-for-multiple-if-statements-and-lookup-functions-sample
Sheet: MD Tax Rates

County | County Transfer Tax | State Transfer Tax (see note 1) | Recordation Tax per $500 (see note 2) | Principal Residence Exemptions | County Transfer Tax Subtraction | County Variables
Allegany | 0.005 | 0.005 | 3.25
[NAME] | 0.01 | 0.005 | 3.5
Baltimore City | 0.015 | 0.005 | 5 | -22000 |  | First $22,000 used to calculate County tax is exempt if property [NAME].
Baltimore County | 0.015 | 0.005 | 2.5 |  | -330 | Subtract $330 from County Transfer Tax if the property is the principal residence.
[NAME] | 0 | 0.005 | 5
Caroline | 0.005 | 0.005 | 5 |  | -125 | Subtract $125 from County Transfer Tax if property is principal residence.
Carroll | 0 | 0.005 | 5
Cecil | 0 | 0.005 | 4.1
[NAME] | 0 | 0.005 | 5
Dorchester | 0.0075 | 0.005 | 5
[NAME] | 0 | 0.005 | 6
Garrett | 0.01 | 0.005 | 3.5
Harford | 0.01 | 0.005 | 3.3
[NAME] | 0.01 | 0.005 | 2.5
Kent | 0.005 | 0.005 | 3.3
Montgomery | 0.01 | 0.005 | 3.45 | -50000 |  | Rates apply to the first $500k of a transaction. Recordation Tax is $5.00 per $500 on any amount over $500k. First $50k used to calculate Recordation Tax is exempt if 'Yes' is selected for principal residence question.
[NAME] | 0.014 | 0.005 | 2.5 |  |  | Recordation Tax also charged on Refinances if property is not principal residence.
[NAME] | 0.005 | 0.005 | 4.95
St. Mary’s | 0.01 | 0.005 | 4
Somerset | 0 | 0.005 | 3.3
Talbot | 0.01 | 0.005 | 3.3
Washington | 0.005 | 0.005 | 3.8
Wicomico | 0 | 0.005 | 3.5
Worcester | 0.005 | 0.005 | 3.5
Notes:
1) If the buyer is a first time homebuyer, buyer pays no state transfer tax and the seller pays .25% of the purchase price.
2) For a refinance, typically only state recordation taxes are collected. These taxes are collected on the difference between the principal of the existing loan being paid off and the principal of the new loan.
3) If the deal is a Freddie Mac transaction, the [NAME] pays all applicable taxes. If the buyer is a first time homebuyer, they still pay the [NAME]'s .25% in taxes.
Spreadsheet: 59359d1259850445-creating-a-summary-tab-excel-question
Sheet: 1.0 Policy

Element 1.0 Policy & Organization
1.1 | EHS Policy
1.1.2 | Requirements for EHS Policy | Standard Met | Evidence
1.1.2 | Has the facility developed its EHS policy that is consistent with K-C Global EHS Policies? | Yes
1.1.2 | Is the senior leader responsible for defining, documenting, and maintaining the EHS policy? | Yes
1.1.3 | Requirements for Communicating the EHS Policy | Standard Met | Evidence
1.1.3 | Has the facility communicated the EHS Policy to employees? | No
1.1.3 | Is EHS Policy is signed and posted in locations that are accessible by employees?
1.1.3 | Is EHS Policy is included in employee manual and other policy manuals?
1.1.3 | Is EHS Policy is referenced in training materials? | Yes
1.1.3 | Is EHS Policy is communicated to new employee during orientation?
1.1.3 | Has the facility made its EHS policy available to the public upon request?
1.2 | Leadership Roles and Responsibilities
1.2.1 | Requirements for Leadership | Standard Met | Evidence
1.2.1 | Does the facility define and document the EHS requirements for each leadership position? | Yes
1.2.1 | Are roles and responsibilities of leadership including the following?
1.2.1 | Are leadership's position descriptions and assignments reviewed at least every three years?
1.2.2 | Required Management Activities | Standard Met | Evidence
1.2.2 | Have leadership personnel completed the following management activities? | No
 |  |  |  |  |  |  |  |  | 3.4
 |  |  |  |  |  |  |  |  | 3.5
 |  |  |  |  |  |  |  |  | 3.5.1
 |  |  |  |  |  |  |  |  | 3.5.2
 |  |  |  |  |  |  |  |  | 3.5.3
Spreadsheet: 328343d1403876063-multiple-true-statements-but-need-one-to-override-the-other-example-workbook-for-forum-jacc3
Sheet: TEKNE CUTTING SHEET Jacc2

ITEM | [NAME] | QTY | LENGTH | WIDTH | THKNS | MATERIAL | P/S | COMMENTS |  | L+ | W+ | THK+ |  | LENGTH | WIDTH | THK |  | LENGTH | WIDTH | THKNS
1 | PANEL 1 | 1 | 500 | 44 | 18 | MDF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | After Material Name
2 | TIE RAIL S/WOOD | 1 | 500 | 44 | 19 | SOFTWOOD
3 | PANEL 1 EDGING | 1 | 500 | 18 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < = Adds 100mm  TO LENGTH
4 | Oak post | 1 | 500 | 44 |  | oak |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | > = For tennons this adds 2x material width & rounds up to the nearest 100mm TO LENGTH
5 | worktop | 1 | 500 | 44 |  | zebrano >
6 | door lipping | 1 | 500 | 42 | 3 | poplar
7 | oak edging | 1 | 500 | 44 |  | oak
8 |  | 1 | 500 | 44
9 |  | 1 | 500 | 44
10 |  | 1 | 500 | 44
11 |  | 1 | 500 | 44
12 |  | 1 | 500 | 44
13 |  | 1 | 500 | 44
14 |  | 1 | 500 | 44
15 |  | 1 | 500 | 44
16 |  | 1 | 500 | 44