tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 719963d1613932644-formula-with-multiple-criteria-excelhelp2
Sheet: Data

Customer Name | Week | Ordered
Customer 1 | 7 | 5
Customer 1 | 7 | 21
Customer 1 | 6 | 3
Customer 2 | 10 | 42
Customer 2 | 10 | 42
Customer 2 | 7 | 105
Customer 2 | 7 | 105
Customer 2 | 9 | 105
Customer 2 | 9 | 105
Customer 3 | 7 | 21
Customer 3 | 10 | 42
Customer 4 | 10 | 42
Customer 4 | 5 | 105
Customer 4 | 6 | 105
Customer 4 | 7 | 105
Customer 4 | 10 | 105
Customer 4 | 10 | 105
Customer 4 | 10 | 105
Customer 4 | 10 | 2
Customer 5 | 10 | 45
Customer 6 | 7 | 6
Customer 7 | 7 | 1
Customer 7 | 10 | 30
Customer 7 | 10 | 2
Customer 8 | 10 | 1
Customer 8 | 8 | 105
Customer 8 | 10 | 420
Customer 8 | 10 | 420
Customer 9 | 10 | 20
Customer 9 | 10 | 20
Customer 9 | 10 | 20
Customer 10 | 8 | 63
Customer 10 | 8 | 105
Customer 10 | 9 | 42
Customer 10 | 10 | 21
Customer 10 | 10 | 21
Customer 10 | 10 | 21
Customer 10 | 10 | 21
Customer 10 | 10 | 105
Customer 10 | 10 | 105
Customer 10 | 10 | 105
Customer 10 | 10 | 126
Customer 10 | 10 | 105
Customer 10 | 10 | 21
Customer 10 | 10 | 42
Customer 10 | 10 | 10
Spreadsheet: 8e0cca29-52eb-4bb5-8aa7-ba411b0a468f
Sheet: Sheet1

Table S16. Sizes of selected protein families in V. inaequalis and other plant pathogens | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Protein family | V. inaequalis | F. graminearum | M. oryzae | B. cinerea | S. sclerotiorum
Fungal specific transcription factors | 102 | 253 | 95 | 114 | 95
Zinc finger transcription factors | 434 | 85 | 58 | 48 | 54
Major facilitator superfamily | 290 | 274 | 198 | 225 | 167
Cytochrome P450 | 171 | 112 | 137 | 129 | 93
Pth11-like G-protein coupled receptor | 0 | 51 | 60 | 22 | 23
Protein kinases | 481 | 149 | 135 | 127 | 169
Heterokaryon incompatibility | 49 | 88 | 41 | 59 | 34
Trypsin | 8 | 3 | 3 | 1 | 1
Subtilisin | 24 | 24 | 29 | 7 | 6
Aspartic protease | 0 | 18 | 19 | 14 | 21
Lipase | 31 | 31 | 23 | 28 | 25
Esterase/thioesterase | 27 | 70 | 64 | 70 | 58
Glycoside hydrolase | 345 | 219 | 235 | 171 | 171
Secondary metabolite backbone genes | 0 | 37 | 32 | 37 | 29
Transposases | 3 | 17 | 15 | 73 | 426
Cutinase | 12 | 12 | 18 | 11 | 8
Pectin lyase | 48 | 25 | 9 | 25 | 20
Spreadsheet: 118427d1313680849-countifs-using-multiple-criteria-one-being-any-date-vs-blank-excel-example3
Sheet: Sheet1

Date open | Date Closed | Current Status |  | 1 | [NAME]
2011-06-15 00:00:00 | 2011-07-01 00:00:00 | Payment Received |  | 2 | Order Processed
2011-06-16 00:00:00 |  | [NAME] |  | 3 | [NAME]
2011-06-17 00:00:00 |  | [NAME] |  | 4 | Order Received
2011-06-18 00:00:00 |  | [NAME] |  | 5 | Payment Received |  | I need this value to count is C:C = Payment [NAME] and B:B = any date
2011-06-19 00:00:00 |  | [NAME]
2011-06-20 00:00:00 | 2011-07-01 00:00:00 | Payment Received
2011-06-21 00:00:00 |  | Order Processed
2011-06-22 00:00:00 | 2011-07-01 00:00:00 | Payment Received
2011-06-23 00:00:00 |  | Order Processed
2011-06-24 00:00:00 |  | Order Processed
2011-06-25 00:00:00 |  | Order Processed
2011-06-26 00:00:00 | 2011-07-01 00:00:00 | Payment Received
2011-06-27 00:00:00 |  | Order Processed
2011-06-28 00:00:00 |  | Order Processed
2011-06-29 00:00:00 |  | Order Processed
2011-06-30 00:00:00 | 2011-07-01 00:00:00 | Payment Received
2011-07-01 00:00:00 |  | [NAME]
2011-07-02 00:00:00 |  | [NAME]
2011-07-03 00:00:00 |  | [NAME]
2011-07-04 00:00:00 |  | Order Received
2011-07-05 00:00:00 |  | Order Received
2011-07-06 00:00:00 |  | Order Received
Spreadsheet: john_lavorato__16464__eesbid2
Sheet: PEAK

PEAK
 |  | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00
LT [NAME] | NP |  | 92 | 12 |  |  |  | 14 | 14 | 39 | 10 | 10 | 10
 | SP |  |  |  | 15 | 15 | 15 |  |  |  | 50 | 50 | 50
LT NW | NP |  |  | 50 | 150 | 133 | 204 | 25 | 25 | 25
 | SP |  | 25 | 25 | 100 | 100 | 100 | 50 | 50 | 50 | 100 | 100 | 100
LT SW | NP |  |  |  | 25 | 25 | 100 | 50 | 50 | 125 | 50 | 50 | 50
 | SP |  | 175 | 75 | 200 | 200 | 225 |  |  |  | 150 | 150 | 150
LT West Mgt | NP |  |  |  |  |  |  |  |  |  | 25 | 25 | 25
 | SP |  |  |  |  |  |  |  |  |  | 25 | 25 | 25
ST [NAME] | NP |  | 50 |  | 25 | 25 | 25
 | SP |  | 75 | 25
ST NW | NP
 | SP
ST SW | NP |  |  |  | 25 | 25 | 25
 | SP |  | 50
WEST TOTAL | NP
 | SP
 | mw
mwhrs | NP
 | SP
curve shift | NP
 | SP
1/22 Curve | NP |  | 250 | 215 | 185 | 185 | 200 | 215 | 240 | 215 | 146 | 130 | 135
Last Trade | NP |  | 261 | 235 | 230 | 230 | 230 | 250 | 250 | 250
Offer | NP |  | 258 | 235 | 225 | 225 | 240 | 240 | 270 | 240 | 165 | 165 | 165
Note |  |  | 1 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5
1/22 Curve | SP |  | 240 | 210 | 193 | 203 | 238 | 240 | 265 | 225 | 143 | 128 | 119
Last Trade | SP |  | 255 |  | 250 | 250 | 250 | 260 | 260 | 260
Offer | SP |  | 253 | 225 | 250 | 250 | 250 | 260 | 260 | 260 | 165 | 165 | 165
Note |  |  | 6 | 6 | 7 | 7 | 7 | 8 | 8 | 8 | 5 | 5 | 5
 | SP | -11624.8458706184 | 62642.0911831992 | 17257.49214050811 | 41094.79962480489 | 40069.85890205622 | 27303.58064858314 | -8201.539488417417 | -10820.49872659304 | -6653.043285645803 | 44062.12690579527 | 43682.51450725044 | 47710.40726670178
 | NP | 6853.448895662565 | 65396.92491067534 | 122662.6100683442 | 95088.39591357294 | 85440.84021054965 | 62800.95402311342 | 35693.34011131643 | 37550.33099213755 | 52447.7131613319 | 70336.80223059791 | 80500.65557234753 | 87367.1410887741
 | hours |  | 384 | 432 | 400 | 416 | 416 | 400 | 432 | 384 | 432 | 400 | 400
Current Pos. | SP
 | NP
new nw | SP |  |  |  | 112.5 | 112.5 | 112.5 | 25 | 25 | 25 | 75 | 75 | 75
 | NP |  |  |  | 50 | 50 | 100
new sw | SP |  | 75 |  | 212.5 | 212.5 | 212.5 | 75 | 75 | 75 | 75 | 75 | 75
 | NP |  |  |  | 25 | 25 | 125
 |  | 1. Last trade done today.  EOL bid hit at $258 earlier today.
 |  | 2. Maintain consistent spread to February and Q2
 |  | 3.  Last trade done on Bloomberg today.  Kept shape from previous curve file.
 |  | 4.  Last trade done today.  Kept shape from previous curve file.
 |  | 5.  Current market is 163/178
 |  | 6.  We would be happy to keep the position at this price.
 |  | 7.  Last trade was in NP15 Q2.  Keeping the spread consistent.
 |  | 8.  Last trade was $260.
Spreadsheet: eric_saibi__9782__020102
Sheet: Callaway 01

Owner Name | AmerenUE
Station Name | Callaway Nuclear Power Station
Unit Name | Callaway 01
NERC Region | MAIN
State | MO
Fuel Type | Nuclear
Capacity | 1,236 MW
Start Date | 2002-01-31 00:00:00
End Date | 2002-02-06 00:00:00
Comments | Crack in the storage tank caused the unit to go down.
SIC | 4911
Plant ID | 1013178
Unit ID | 1004482
Outage ID | 19749
Spreadsheet: 96928d1296164312-excel-2007-getting-only-selcted-rows-to-transfer-to-a-new-sheet-for-printing-sample-sheet
Sheet: aug

Last Name | First Name | MI | Address | City | State | Zip | Phone | FAX | E-Mail | Salary | Insurance | 401K
Watkins | [NAME] | W | [NAME] | Bartow | FL. | 33830 | 8635326545 | 8636829865 | [EMAIL] | 65500 | No | Yes
[NAME] | Venston | W | 254 Frazier St. | Bartow | FL. | 33830 | 8635342654 | 8636659852 |  | 28500 | Yes | No
McGill | [NAME] | F | 140 Hampton St. | Bartow | FL. | 33830 | 8636465656 | 8636603514.54941 | [EMAIL] | 55600 | Yes | Yes
Ervin | Dallas | O | 936 Buttercup Ave. | Bartow | FL. | 33830 | 8635321478 | 8636497387.05929 | [EMAIL] | 60650 | Yes | Yes
Mills | Irish | M | 52 Lake Hunter Dr. | Bartow | FL. | 33830 | 8635321010 | 8636492333.36928 |  | 25300 | No | No
[NAME] | Georgia | A | 311 Lakeland Hills Blvd. | Bartow | FL. | 33830 | 8635369752 | 8636487279.67928 |  | 27500 | No | No
Spreadsheet: 871617d1718045021-transposing-year-in-excel-book6
Sheet: Sheet1

 | Existing format
 | YEAR | 2018 | 2019 | 2020 | 2021 | 2022
 | [NAME] | AGE | AGE | AGE | AGE | AGE
 | AB DYNAMICS PLC | 5.564383561643836 | 6.564383561643836 | 7.567123287671233 | 8.567123287671233 | 9.567123287671233
 | Required format
 | [NAME] | YEAR | AGE
 | AB DYNAMICS PLC | 2018 | 6
 | AB DYNAMICS PLC | 2019 | 7
 | AB DYNAMICS PLC | 2020 | 8
 | AB DYNAMICS PLC | 2021 | 9
 | AB DYNAMICS PLC | 2022 | 10
Spreadsheet: eric_saibi__9713__010702R
Sheet: Four Corners 05

Owner Name |  | Arizona Public Service Company
Station Name |  | Four Corners Power Station
Unit Name |  | Four Corners 05
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 818 MW
Start Date |  | 2002-01-06 00:00:00
End Date |  | 2002-03-05 00:00:00
Prv. Start Date |  | 2002-01-14 00:00:00
Prv. End Date |  | 2002-03-10 00:00:00
Comments |  | [NAME]
SIC |  | 4911
Plant ID |  | 1523368
Unit ID |  | 1007556
Outage ID |  | 8174
Spreadsheet: 266352d1379590118-extracting-text-and-numbers-for-this-spreadsheet-excel-problem-forum-upload
Sheet: BEFORE

Product | Pack Size |  |  |  |  | Price | V | RRP | Code
[NAME]
ESSENCE OF QUALITY
Quad Seal Stabilo Packs
Nut Kernels and Fruit & Nut Mixes |  |  |  |  |  |  |  |  |  | 0.925
Almonds | 12x150g | 12 | 150g |  |  | 17.969861 |  | 1.991659594166667 | 21347
Almonds | 12x400g | 12 | 400g |  |  | 42.478196 |  | 4.75 | 10469
Peanuts Roasted & Salted Medium | 12.5kg | 12.5kg |  |  |  | 34.8 | V | 2.78 | 2RB12
Peanuts Salted Jumbo | 3kg | 3kg |  |  |  | 9.386325000000001 | V | 3.13 | 2RR05
Pecans | 13.6kg | 13.6kg |  |  |  | 142.8 |  | 10.5 | 2NB30
Pecans SA | 3kg | 3kg |  |  |  | 32.42 |  | 10.81 | 2NR07
Pekkit [NAME], bag - RRP £1.35 | 12x1kg | 12 | 1kg |  |  | 10.03172 | V | 10.81 | 20100
High Energy Fat Balls, Tub (50x90g) - RRP £0.20 | 1s | 1s |  |  |  | 6.53 | V | 10.81 | 20109
High Energy Fat Ball (500g) - RRP £0.90 | 24s | 24s |  |  |  | 13.63 | V | 10.81 | 20112
NUTS IN SHELL
Peanuts in Shell, Chinese | 11.34kg | 11.34kg |  |  |  | 24.23 |  | 2.14 | 1PS25
Roasted Monkey Nuts in shell | 10kg | 10kg |  |  |  | 27.15 |  | 2.72 | 30400
[NAME] | 5x2kg | 5 | 2kg |  |  | 24.66 |  | 2.47 | 3MR52
[NAME] | 2kg | 2kg |  |  |  | 5.07 |  | 2.54 | 3MR02
Presse, Handmade Lemonade | 12x75cl | 12 | 75cl |  |  | 17.49 | V | 2.35 | 80254
Elderflower Still | 12x27.5cl | 12 | 27.5cl |  |  | 9.35 | V | 1.25 | 80261
[NAME] pudding | 6x(2x110g) | 6 | (2 | 110g) |  | 11.3 |  | 2.49 | 20140
Steak Seasoning | 6x40g box | 6 | 40g bo |  |  | 3.35 |  | 0.75 | 74779
Tandoori Masala | 6x40g box | 6 | 40g bo |  |  | 3.35 |  | 0.75 | 74758
Cayenne Pepper | 6x65g jar | 6 | 65g jar |  |  | 5.25 |  | 1.15 | 74833
Spreadsheet: 550575d1512439313-exact-match-formula-exact
Sheet: EXACT

 |  |  |  | GET | WANT
 |  | HAM TEMP LC PRIM |  |  | LTR CAR | NEED RESULT FOR EXACT MATCH OF LC
 |  | HAM TEMP LC PRIM |  |  | LTR CAR
 |  | HAM TEMP LC PRIM |  |  | LTR CAR
 |  | HAM TEMP LC PRIM |  |  | LTR CAR
 |  | HAM TEMP LC PRIM |  |  | LTR CAR
 |  | HAM TEMP LC PRIM |  |  | LTR CAR
 |  | RSMC ON CALL RELIEF (WATER LCD)
 |  | RSMC LCD ON CALL
 |  | [NAME]
Spreadsheet: 836019d1689053829-rank-multiple-criteria-not-repeating-sample-data-ranking
Sheet: Sheet1

 | FILTER # | CHANGEABLE CRITERIA | 2023 |  |  | TOP 10 ACCOUNTS/ DEALERS -
 | FILTER 1 | AE2 | A. SALES | [NAME] |  | RANK | KUNNR | KUNNR NAME | SALES | TARGET
 | FILTER 2 | [NAME] |  |  |  | 1 |  | EE | 384881.25 | 267787.3774096
 |  |  |  |  |  | 2 | [PHONE] | FF | 226188.5 | 595895.0667752009
 | [PHONE] | AA | 45552.08 | 114603.07385452 |  | 3 | [PHONE] | AA | 45552.08 | 114603.07385452
 | [PHONE] | BB | 24694.38 | 25774.79802798 |  | 4 | [PHONE] | GG | 29841.26 | 11646.7742636
 | [PHONE] | CC | 6721.8 | 17029.399244 |  | 5 | [PHONE] | BB | 24694.38 | 25774.79802798
 | [PHONE] | DD | 0 | 1283.94 |  | 6 | [PHONE] | CC | 6721.8 | 17029.399244
 | [PHONE] | EE | 384881.25 | 267787.3774096 |  | 7 | [PHONE] | DD | 0 | 1283.94
 | [PHONE] | FF | 226188.5 | 595895.0667752009 |  | 8 | [PHONE] | DD | 0 | 1283.94 | REPEATING
 | [PHONE] | GG | 29841.26 | 11646.7742636 |  | 9 | [PHONE] | DD | 0 | 1283.94 | REPEATING
 | [PHONE] | HH | 0 | 54.76300206000001 |  | 10 |  |  |  |  | REPEATING
 | [PHONE] | II | 0 | 8343.76159672 |  | OTHERS | BALANCE ACCOUNTS/ DEALERS |  | 0 | 5830.6445987802
 |  |  |  |  |  | TOTAL
Spreadsheet: 82370d1282388878-chart-data-and-axis-labels-project-analysus
Sheet: Sheet1

 | Analysis | sizes
 | Buiness Factor | Importance to project | Factor |  | Probability of occurance |  |  |  | X |  | Y
 |  |  |  |  |  |  |  |  | Neutral | 0 | Neutral | 0
 | eCatalogue | 1 | Opportunity high | 4 | Small | 2 |  |  | Opportunity Minor | 1 | Minor | 1
 | eInvoicing | 4 | Threat moderate | -3 | Exceptionally high | -6 |  |  | Opportunity low | 2 | Small | 2
 | Static Pricing | 5 | Threat low | -2 | Exceptionally high | -6 |  |  | Opportunity Moderate | 3 | Moderately low | 3
 | Storage Facility | 5 | Weakness low | -2 | Very little | -1 |  |  | Opportunity high | 4 | Low | 4
 | Brand Image | 3 | Opportunity high | 4 | High | -4 |  |  | Opportunity Significant | 5 | Very low | 5
 | Desktop delivery | 8 | Strength Minor | 1 | Minor | 1 |  |  | Opportunity exceptioanl | 6 | Exceptionally low | 6
 | Lead time disruption | 8 | Neutral | 0 | Neutral | 0 |  |  | Strength moderate | 3 | Very little | -1
 | Pricing increases | 1 | Weakness excceptional | -6 | Exceptionally low | 6 |  |  | Strength Low | 2 | Showing signs | -2
 | Insolvency potential | 4 | Strength Minor | 1 | Low | 4 |  |  | Strength Minor | 1 | Moderately high | -3
 | Trade references | 3 | Strength Minor | 1 | Moderately high | -3 |  |  | Strength High | 4 | High | -4
 | Dunn & Bradstreet | 5 | Weakness Significant | -5 | Very high | -5 |  |  | Strength Significant | 5 | Very high | -5
 | Geographic Location | 7 | Threat Minor | -1 | Moderately low | 3 |  |  | Strength exceptional | 6 | Exceptionally high | -6
 | Customer Service | 6 | Threat High | -4 | Very high | -5 |  |  | Threat moderate | -3
 | Poor Pick rates | 7 | Strength Minor | 1 | Low | 4 |  |  | Threat low | -2
 | Returns Policy | 6 | Threat low | -2 | Neutral | 0 |  |  | Threat Minor | -1
 | Business hours | 2 | Threat High | -4 | Moderately high | -3 |  |  | Threat High | -4
 |  |  |  |  |  |  |  |  | Threat Significant | -5
 |  |  |  |  |  |  |  |  | Threat exceptional | -6
 |  |  |  |  |  |  |  |  | Weakness moderate | -3
 |  |  |  |  |  |  |  |  | Weakness low | -2
 |  |  |  |  |  |  |  |  | Weakness Minor | -1
 |  |  |  |  |  |  |  |  | Weakness high | -4
 |  |  |  |  |  |  |  |  | Weakness Significant | -5
 |  |  |  |  |  |  |  |  | Weakness excceptional | -6
Spreadsheet: 154882d1336588098-if-statement-for-largest-number-in-series-zonesample-modified-by-tigeravatar-
Sheet: Sheet1

Route | Date | Driver | cust_code | Weight | SHIP_ZIP | ZONES
01 | 2011-12-01 00:00:00 | SANCHEZ | 2159 | 251.8 | 91303 | 3
01 | 2011-12-01 00:00:00 | SANCHEZ | 8173 | 587.13 | 91303 | 3
01 | 2011-12-01 00:00:00 | SANCHEZ | V12 | 0 | 91304 | 3
01 | 2011-12-01 00:00:00 | SANCHEZ | V24 | 1858.38 | 91306 | 3
01 | 2011-12-01 00:00:00 | SANCHEZ | 4711 | 452.55 | 91335 | 3
01 | 2011-12-01 00:00:00 | SANCHEZ | 6523 | 200 | 91356 | 3
01 | 2011-12-01 00:00:00 | SANCHEZ | 6805 | 453.85 | 91401 | 2
01 | 2011-12-01 00:00:00 | SANCHEZ | 9843 | 526.87 | 91405 | 2
01 | 2011-12-01 00:00:00 | SANCHEZ | 8872 | 218.8 | 91406 | 3
01 | 2011-12-01 00:00:00 | SANCHEZ | 1267 | 203.44 | 91601 | 2
01 | 2011-12-01 00:00:00 | SANCHEZ | 6288 | 390.5 | 91601 | 2
01 | 2011-12-01 00:00:00 | SANCHEZ | 8871 | 210.7 | 91605 | 2
01 | 2011-12-01 00:00:00 | SANCHEZ | V1 | 18.3 | 91606 | 2
01 | 2011-12-01 00:00:00 | SANCHEZ | V9 | 617.25 | 91606 | 2
01 Total |  |  |  | 5989.570000000001 |  |  | 3
02 | 2011-12-01 00:00:00 | MARQUEZ | TS4 | 631.2 | 91321 | 4
02 | 2011-12-01 00:00:00 | MARQUEZ | 2519 | 1161.8 | 91331 | 3
02 | 2011-12-01 00:00:00 | MARQUEZ | SG111 | 4000 | 91331 | 3
02 | 2011-12-01 00:00:00 | MARQUEZ | TS1 | 952.9 | 91331 | 3
02 | 2011-12-01 00:00:00 | MARQUEZ | V18 | 168 | 91331 | 3
02 | 2011-12-01 00:00:00 | MARQUEZ | 7618 | 366.9 | 91342 | 3
02 | 2011-12-01 00:00:00 | MARQUEZ | V7 | 987.6 | 91342 | 3
02 | 2011-12-01 00:00:00 | MARQUEZ | 8141 | 333.6 | 91402 | 3
02 Total |  |  |  | 8602 |  |  | 4
03 | 2011-12-01 00:00:00 | PEDRAZA | 7388 | 1033.29 | 93630 | 9
03 | 2011-12-01 00:00:00 | PEDRAZA | 8796 | 1686 | 93662 | 9
03 | 2011-12-01 00:00:00 | PEDRAZA | 2308 | 1240.08 | 93702 | 9
03 | 2011-12-01 00:00:00 | PEDRAZA | V29 | 3778.16 | 93726 | 9
03 | 2011-12-01 00:00:00 | PEDRAZA | V10 | 2908.62 | 93727 | 9
03 Total |  |  |  | 10646.15 |  |  | 9
Spreadsheet: 060d6a36-cf1f-4f54-89d9-895d9bbd9855
Sheet: Quarterly- Unit Sales Levels 

Quarterly Question: By roughly what percent are your firm's unit sales levels above/below “normal,” if at all?
 | Average percent above/below normal
 | Small firms (1-99 employees) | Mid size firms (100-499 employees) | Large firms (500+ employees) | All  (industry-weighted mean)
2012-09-14 00:00:00 | -0.096 | -0.096 | -0.049 | -0.076
2012-12-14 00:00:00 | -0.103 | -0.111 | -0.021 | -0.077
2013-03-15 00:00:00 | -0.122 | -0.068 | -0.033 | -0.077
2013-06-14 00:00:00 | -0.073 | -0.015 | -0.022 | -0.043
2013-09-13 00:00:00 | -0.074 | -0.066 | -0.025 | -0.05599999999999999
2013-12-09 00:00:00 | -0.086 | -0.022 | -0.038 | -0.048
2014-03-14 00:00:00 | -0.091 | -0.056 | -0.03 | -0.05681521045549931
Spreadsheet: 702932d1604614334-different-commission-rate-after-specific-sales-level-obtained-commissions-example
Sheet: Nov20

COMMISSIONS
Sales |  | 100000
NET SALES - OCTOBER |  |  | NET SALES - YTD
NAME |  | NOVEMBER | % | PAYMENT
Under $4 million net |  |  | 0.02 |  |  | **Should show $50,000
Over $4 million net |  |  | 0.03 |  |  | **Should show $50,000
Spreadsheet: 4074bd3b-78e1-46b3-bad8-b1434eb9beec
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
Please click on required table number:
Benefit Claimants |  | Definition
2.2.1 | Income Support Claimants - 2007: Localities | Click here for data definition
2.2.2 | Income Support Claimants - 2007: [NAME]
2.2.3 | Job Seekers Allowance Claimants - 2007: Localities | Click here for data definition
2.2.4 | Job Seekers Allowance Claimants - 2007: [NAME]
2.2.5 | Disability Living Allowance Claimants - 2007: Localities | Click here for data definition
2.2.6 | Disability Living Allowance Claimants - 2007: [NAME]
2.2.7 | Incapacity Benefit & Severe Disablement Allowance Claimants - 2007: Localities | Click here for data definition
2.2.8 | Incapacity Benefit & Severe Disablement Allowance Claimants - 2007: [NAME]
2.2.9 | Low Income Scheme Index (LISI) 2006/07 | Click here for data definition
Spreadsheet: 746077d1630493856-sum-alternate-columns-based-on-criteria-and-header-sum_alternate_columns_excel_free_workbook_xelplus
Sheet: Sum_Alternate_Columns

Cost center | Last name | First name | Sex | FTE | Base salary | Benefits | Bonus1 | Bonus | Kolumna1 | Kolumna2
325 | [NAME] | [NAME] | M | 0.8 | 45000 | 6750 |  | 3000
325 | [NAME] | [NAME] | M | 1 | 35000 | 5250
325 | [NAME] | [NAME] | M | 1 | 39000 | 5850 | 3000
325 | Rodriguez | [NAME] | M | 1 | 37000 | 5550
610 | Wilson | [NAME] | M | 1 | 34000 | 5100 |  |  |  |  |  |  | 809 | Base salary
610 | Martinez | [NAME] | F | 0.5 | 20000 | 3000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | criteria row |  |  | criteria columns
624 | [NAME] | [NAME] | M | 1 | 38000 | 5700 |  | 1000 |  |  |  |  | Using 2nd argument for Index: |  |  |  |  |  |  |  | 624 | Jones |  | *Bonus* |  |  | result
624 | [NAME] | [NAME] | M | 1 | 36000 | 5400 |  | 1000
624 | Jones | [NAME] | M | 1 | 65000 | 9750 | 1000 | 5000 |  |  |  |  | SUMPRODUCT:
720 | [NAME] | [NAME] | F | 1 | 40000 | 6000 | 1000 | 2000
720 | [NAME] | [NAME] | F | 1 | 42000 | 6300 | 5000 | 2000
720 | [NAME] | [NAME] | F | 1 | 38000 | 5700 | 2000
720 | Hernandez | [NAME] | F | 1 | 36000 | 5400 | 2000
720 | Moore | [NAME] | F | 0.8 | 25000 | 3750
805 | Martin | Maria | F | 1 | 60000 | 9000 |  | 4000
805 | [NAME] | [NAME] | F | 1 | 35000 | 5250
805 | Thompson | [NAME] | F | 0.75 | 32000 | 4800 | 4000
809 | Smith | [NAME] | M | 1 | 40000 | 6000 |  | 2000 |  |  |  |  | 809 | [NAME]
809 | [NAME] | [NAME] | M | 1 | 42000 | 6300 |  | 3000
809 | [NAME] | Thompson | M | 1 | 30000 | 4000 | 2000 | 2000
Spreadsheet: 873114d1719530817-formula-referencing-2-different-sheets-book1
Sheet: Summary

Totals |  |  | Fly State |  | Winds |  | [NAME]
Enteries |  |  | [NAME] |  | [NAME]
Total Flight Time | =[NAME]:B$20000) |  | Manual Takeoff |  | Moderate
Tips |  |  | PANO |  | (blank)
Warnings |  |  | P-GPS |  | Grand Total
Avg GPS |  |  | [NAME]
Min GPS |  |  | Starting Motors
[NAME] |  |  | (blank)
[NAME] |  |  | Grand Total
[NAME]
[NAME]
[NAME]
Min Battery Live
Spreadsheet: 42794d1241450183-how-to-select-largest-value-for-each-date-book3
Sheet: Sheet1

Date | SITE | POC | Concentration |  |  |  |  |  | Max of Concentration
2007-04-01 00:00:00 | 110010025 | 1 | 0.039 |  |  |  |  |  | Date | Total
2007-04-01 00:00:00 | 110010041 | 1 | 0.042 |  |  |  |  |  | 2007-04-01 00:00:00 | 0.044
2007-04-01 00:00:00 | 110010043 | 1 | 0.039 |  |  |  |  |  | 2007-04-02 00:00:00 | 0.055
2007-04-01 00:00:00 | 240090011 | 1 | 0.042 |  |  |  |  |  | Grand Total | 0.055
2007-04-01 00:00:00 | 240170010 | 1 | 0.044
2007-04-02 00:00:00 | 110010025 | 1 | 0.051
2007-04-02 00:00:00 | 110010041 | 1 | 0.048
2007-04-02 00:00:00 | 110010043 | 1 | 0.052
2007-04-02 00:00:00 | 240090011 | 1 | 0.053
2007-04-02 00:00:00 | 240170010 | 1 | 0.055
2007-04-02 00:00:00 | 240210037 | 1 | 0.055
Spreadsheet: 209833d1359247198-reversed-discounted-cash-flow-discounted-cash-flows
Sheet: Two-Stage DCF

FocusInvestor.com:  The Focused Few
Initial Cash Flow: | 100000
Years: | 1-5 | 6-10
Growth Rate: | 0.1 | 0.05
Terminal Growth Rate: | 0.01 |  | Discount Rate: | 0.15
Year | Flows | Growth | Value
1 | 110000 | 0.1 | 95652.17391304349
2 | 121000 | 0.1 | 91493.38374291117
3 | 133100 | 0.1 | 87515.41053669766
4 | 146410 | 0.1 | 83710.39268727602
5 | 161051 | 0.1 | 80070.81039652489
6 | 169103.55 | 0.05 | 73108.13123160967
7 | 177558.7275 | 0.05 | 66750.90242886102
8 | 186436.663875 | 0.05 | 60946.4761306992
9 | 195758.49706875 | 0.05 | 55646.78255411666
10 | 205546.4219221875 | 0.05 | 50807.93189723696
Terminal Year | 207601.8861414093
PV of Year 1-10 Cash Flows: |  |  | 745702.3955189767
Terminal Value: |  |  | 366542.937258638
Total PV of Cash Flows: |  |  | 1112245.332777615
Spreadsheet: 883486d1732103993-use-the-other-formula-instead-of-vlookup-formula-index_match-for-vehicle-duty-slip
Sheet: Form

 | ABC INTERNATIONAL COMPANY
 | OPERATIONAL VEHICLE DUTY SLIP No:
Date | 2024-11-11 00:00:00 |  | date
Employe No. |  |  | epi#
Name |  |  | name
Design |  |  | design
From |  |  | start time
to |  |  | end time
Place / Address where vehicle required: |  |  | PLACE
Purpose:- |  |  | PURPOSE
Vehicle No. |  |  | reg#
Type of Vehicle Required: |  |  | type
Make |  |  | make
Power(CC) |  |  | capacity
 |  |  | slip no.
 |  |  | date end
[NAME] at the start of duty:-- |  |  | start reading
at the end of duty |  |  | end reading
Total running of this visit:- |  |  | Total
Spreadsheet: 768337d1644930869-textjoin-concat-a-list-of-emails-if-they-are-in-a-specific-group-group_name
Sheet: A

ID | First Name | Last Name | Org | Group Name | email
Ab45 | Sue | Langdon | 12300 | Apple | [EMAIL]
Ab46 | Cameron | [NAME] | 12300 | Apple | [EMAIL]
Ab47 | [NAME] | [NAME] | 12300 | Apple | [EMAIL]
Ab48 | [NAME] | Young | 12300 | Apple | [EMAIL]
Ab49 | [NAME] | [NAME] | 12300 | Apple | [EMAIL]
Ab50 | Lauren | Hill | 12300 | Apple | [EMAIL]
Ab51 | Faith | Hudson | 12300 | Apple | [EMAIL]
Ab52 | [NAME] | [NAME] | 15000 | Orange | [EMAIL]
Ab53 | [NAME] | Morgan | 15000 | Orange | [EMAIL]
Ab54 | [NAME] | Hodges | 15000 | Orange | [EMAIL]
Ab55 | Jan | [NAME] | 15000 | Orange | [EMAIL]
Ab56 | [NAME] | Nash | 15000 | Orange | [EMAIL]
Ab57 | Kimberly | Black | 15000 | Orange | [EMAIL]
Ab58 | Virginia | King | 15000 | Orange | [EMAIL]
Ab59 | [NAME] | [NAME] | 15000 | Orange | [EMAIL]
Ab60 | [NAME] | [NAME] | 15000 | Orange | [EMAIL]
Ab61 | [NAME] | Short | 15000 | Orange | [EMAIL]
Ab62 | Jessica | Morrison | 15000 | Orange | [EMAIL]
Ab63 | Dominic | Mackenzie | 7600 | Pear | [EMAIL]
Ab64 | [NAME] | Hodges | 7600 | Pear | [EMAIL]
Ab65 | Emma | [NAME] | 7600 | Pear | [EMAIL]
Ab66 | Molly | [NAME] | 7600 | Pear | [EMAIL]
Ab67 | Jessica | [NAME] | 7600 | Pear | [EMAIL]
Ab68 | [NAME] | May | 7600 | Pear | [EMAIL]
Ab69 | [NAME] | Pullman | 7600 | Pear | [EMAIL]