tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 330009d1404481627-hlookup-and-match-example2
Sheet: Sheet1

[NAME] |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
1953-04-02 00:00:00 | [NAME] |  | 1951-01-01 00:00:00 | Fred |  | 1957-01-01 00:00:00 | Alfred |  | 1900-01-01 00:00:00 | Alfred
1958-07-04 00:00:00 | [NAME] |  | 1953-04-02 00:00:00 | [NAME] |  | 1958-07-01 00:00:00 | [NAME] |  | 1900-01-01 00:00:00 | [NAME]
1960-01-01 00:00:00 | [NAME] |  | 1957-02-03 00:00:00 | [NAME] |  | 1958-07-04 00:00:00 | [NAME] |  | 1960-01-01 00:00:00 | [NAME]
1962-04-08 00:00:00 | [NAME] |  | 1962-04-08 00:00:00 | [NAME] |  | 1965-02-03 00:00:00 | [NAME]
Spreadsheet: 763927d1642460376-average-function-which-disregards-columns-year-months-average-3
Sheet: Sheet1

Years/Months | Years/Months | Average |  |  | Data | Years/Months | Data | Years/Months | Average
6/4 | 7/4 |  |  |  | 23.2 | 6/4 | 45.3 | 7/4
6/5 | 6/10 |  |  |  | 45.3 | 6/5 | 58 | 6/10
5/12 | 6/10 |  |  |  | 23 | 5/12 |  | 6/10
6/2 |  |  |  |  |  | 6/2 | 3.2
6/4 | 6/11 |  |  |  | 45 | 6/4 | 45.3 | 6/11
6/4 | 7/2 |  |  |  | 96 | 6/4 | 23 | 7/2
Spreadsheet: john_zufferli__16729__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 456739d1461030100-help-with-dates-in-row-vs-column-dates-match-then-put-a-tick-if-not-a-cross-test-example_-attendance-records
Sheet: Sheet4

February | Formuals Tried | IF(B:B<=DATEVALUE("29/02/2016"), "1", "0") |  |  |  |  | IFERROR(INDEX(B:B,MATCH(A7,C:C,0)),"Not Found")
 |  | AND(EXACT(A2:A11,B2:B11)) |  |  | IF(A1=B1, "0", "1") |  | IF(AND(B5:B748,C4:AE5), "0", "1")
 |  | 2016-02-01 00:00:00 | 2016-02-02 00:00:00 | 2016-02-03 00:00:00 | 2016-02-04 00:00:00 | 2016-02-05 00:00:00 | 2016-02-06 00:00:00 | 2016-02-07 00:00:00 | 2016-02-08 00:00:00 | 2016-02-09 00:00:00 | 2016-02-10 00:00:00 | 2016-02-11 00:00:00 | 2016-02-12 00:00:00 | 2016-02-13 00:00:00 | 2016-02-14 00:00:00 | 2016-02-15 00:00:00 | 2016-02-16 00:00:00 | 2016-02-17 00:00:00 | 2016-02-18 00:00:00 | 2016-02-19 00:00:00 | 2016-02-20 00:00:00 | 2016-02-21 00:00:00 | 2016-02-22 00:00:00 | 2016-02-23 00:00:00 | 2016-02-24 00:00:00 | 2016-02-25 00:00:00 | 2016-02-26 00:00:00 | 2016-02-27 00:00:00 | 2016-02-28 00:00:00 | 2016-02-29 00:00:00
Name | Date | 2016-02-01 00:00:00 | 2016-02-02 00:00:00 | 2016-02-03 00:00:00 | 2016-02-04 00:00:00 | 2016-02-05 00:00:00 | 2016-02-06 00:00:00 | 2016-02-07 00:00:00 | 2016-02-08 00:00:00 | 2016-02-09 00:00:00 | 2016-02-10 00:00:00 | 2016-02-11 00:00:00 | 2016-02-12 00:00:00 | 2016-02-13 00:00:00 | 2016-02-14 00:00:00 | 2016-02-15 00:00:00 | 2016-02-16 00:00:00 | 2016-02-17 00:00:00 | 2016-02-18 00:00:00 | 2016-02-19 00:00:00 | 2016-02-20 00:00:00 | 2016-02-21 00:00:00 | 2016-02-22 00:00:00 | 2016-02-23 00:00:00 | 2016-02-24 00:00:00 | 2016-02-25 00:00:00 | 2016-02-26 00:00:00 | 2016-02-27 00:00:00 | 2016-02-28 00:00:00 | 2016-02-29 00:00:00
[NAME] | 2016-02-01 00:00:00 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1
AMANDA | 2016-02-01 00:00:00 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1
AMANDA | 2016-02-02 00:00:00
[NAME] | 2016-02-02 00:00:00
AMANDA | 2016-02-03 00:00:00
[NAME] | 2016-02-03 00:00:00
AMANDA | 2016-02-04 00:00:00
[NAME] | 2016-02-04 00:00:00
AMANDA | 2016-02-05 00:00:00
[NAME] | 2016-02-05 00:00:00
[NAME] | 2016-02-10 00:00:00
[NAME] | 2016-02-11 00:00:00
[NAME] | 2016-02-12 00:00:00
AMANDA | 2016-02-15 00:00:00
[NAME] | 2016-02-15 00:00:00
AMANDA | 2016-02-16 00:00:00
[NAME] | 2016-02-16 00:00:00
AMANDA | 2016-02-17 00:00:00
[NAME] | 2016-02-17 00:00:00
AMANDA | 2016-02-18 00:00:00
[NAME] | 2016-02-18 00:00:00
AMANDA | 2016-02-19 00:00:00
[NAME] | 2016-02-19 00:00:00
AMANDA | 2016-02-22 00:00:00
[NAME] | 2016-02-22 00:00:00
AMANDA | 2016-02-23 00:00:00
[NAME] | 2016-02-23 00:00:00
AMANDA | 2016-02-24 00:00:00
[NAME] | 2016-02-24 00:00:00
[NAME] | 2016-02-25 00:00:00
AMANDA | 2016-02-25 00:00:00
[NAME] | 2016-02-26 00:00:00
AMANDA | 2016-02-26 00:00:00
[NAME] | 2016-02-27 00:00:00
AMANDA | 2016-02-29 00:00:00
[NAME] | 2016-02-29 00:00:00
Spreadsheet: kim_ward__20939__jobsearch
Sheet: headhunters

Co Name | Contact 1 | State | email | phone | Called? | Res Sent Date | Notes
Kappa Search | [NAME] | Chicago | [EMAIL] | [PHONE] | 2001-12-06 00:00:00 | 2001-12-06 00:00:00 | NRG - Minn./Western Resources - Kansas
STM Associates | [NAME] |  |  | [PHONE]
Wyndham Mills | [NAME] | Atlanta | I have this at home | [PHONE] | 2001-12-05 00:00:00 | 2001-12-05 00:00:00 | eprime - Denver/FPL - houston?
Kronkecolman | [NAME] | Dallas | [EMAIL] | [PHONE]
Prostaff | [NAME] | Houston | [EMAIL] | [PHONE]
Gelber & Associates | [NAME] | Houston | [EMAIL] | [PHONE] | 2001-12-05 00:00:00 | 2001-12-05 00:00:00 | IB's - Consulting - Utilites - | forward gas trader
[NAME] | [NAME] | NYC | [EMAIL] | [PHONE] | 2001-12-20 00:00:00 | 2001-12-20 00:00:00 | gas trading for power plants;tenaska or constellation
[NAME]'s
Kern-Search | [NAME] |  | [EMAIL] | [PHONE] |  |  |  |  |  | returned my call
Salado Resources Group International | [NAME] |  | [EMAIL] | [PHONE] | no | 2001-11-26 00:00:00 | Fill out form on home pc
[NAME] | [NAME] |  | [EMAIL] | Preng [PHONE] | yes, follow up week of 4th |  | Texaco, Utilicorp, EOTT, Pacificorp | [NAME]
TNP Worldwide | [NAME] |  |  | [PHONE] |  |  | Reliant
[NAME] | [NAME] |  |  | [PHONE] | lft msg? |  | El Paso, [NAME]
TMP Worldwide | [NAME] |  | [EMAIL] | p) [PHONE] | no | 2001-11-26 00:00:00 | f) [PHONE] contacted me off monster
[NAME] | [NAME] |  |  | [PHONE] | lft msg
Kern-Search | [NAME] |  | [EMAIL] | (713)621-8010 | yes |  | Friend of Cindy O and [NAME]
Rocky Mountain Recruiters |  |  | '[EMAIL]' |  |  | 2001-11-28 00:00:00
Spreadsheet: 840a0328-ed49-4c1d-ba6c-470b45e2b2b9
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
BETAS | Test | BETAS | Beta Hemolytic Strep Culture | Beta Hemolytic Strep Culture | Conventional Culture with Latex Grouping of Beta Strep Isolated | Varies: Var |  |  |  | Varies | [NAME] Sources: Vaginal/rectal  Container/Tube: Sterile container [NAME] Adequate amount Additional Information: For isolation of Strep Group B (Streptococci agalactiae) from pregnant women. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Negative (reported as positive or negative for beta-hemolytic streptococci group A or B) | Monday through Sunday; continuously | 2 days | 5 days | 1 | 87081 |  |  |  |  | Rochester
BETAS | [NAME] | VARIES | Varies |  |  |  | Ambient | 24 hours
BETAS | Order Question | Q00M0007 | [NAME] |  | Plain Text
BETAS | Result | BETAS | Beta Hemolytic Strep Culture | Beta Hemolytic Strep Culture | Alphanumeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: scott_neal__38663__eastseating
Sheet: Sheet1

 |  | East Gas Trading & Origination
 |  |  |  |  | 483
 | 481 | 482 | 483 | 484 | 485
 | east ops | east ops | east ops | east ops | east ops | east ops
 |  |  |  |  |  | 470
 |  |  |  |  |  | 463
 | east ops | [NAME] | [NAME] | [NAME] | [NAME] | east ops
 | F. Vickers | [NAME] | [NAME] | [NAME] | [NAME]
 | 461 |  |  |  |  | 456
 |  |  |  |  |  | 449
 | open- clerk | open - admin
Spreadsheet: 42970d1241593362-sum-across-multiple-sheets-demo2
Sheet: 2

 | Estimated | No.Sold | Free | Remarks
Apple | 26 | 24 | 5 | Free
Green | 15 | 12 | 6 | Free
Kashmiur | 17 | 15 | 10 | Free
Mango | 19 | 30 | 4 | Free
[NAME] | 28 | 19 | 9
Pine Apple | 28 | 20 | 8
Kiwi | 30 | 17 | 13
 |  |  |  |  |  |  |  | 1 | BET
 |  |  |  |  |  |  |  | 2 | BET
 |  |  |  |  |  |  |  | 3 | BET
 |  |  |  |  |  |  |  | 4 | BET
 |  |  |  |  |  |  |  | 5 | BET
 |  |  |  |  |  |  |  | 6 | BET
 |  |  |  |  |  |  |  | 7 | BET
 |  |  |  |  |  |  |  | 8 | BET
 |  |  |  |  |  |  |  | 8 | BET
 |  |  |  |  |  |  |  | 1 | BET
Spreadsheet: d31c2ab7-34bc-4cdb-8499-688165c59490
Sheet: Sheet1

Features of A. fumigatus-specific genes | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Orthologs |  | [NAME] |  | Expressed
Gene sets | Yes* | No | Yes** | No | Yes*** | No
No. of genes | 223 | 595 | 215 | 380 | 265 | 553
Mean gene length | 1190 | 656 | 1072 | 421 | 898 | 755
Mean No. introns | 1.73 | 1.21 | 1.93 | 0.79 | 1.45 | 1.3
% Without introns | 0.287 | 0.324 | 0.205 | 0.392 | 0.325 | 0.309
% Telomere-proximal | 0.479 | 0.323 | 0.46 | 0.245 | 0.38 | 0.358
% Expressed | 0.354 | 0.313 | 0.344 | 0.317 | 1 | 0
Legend
*Genes with orthologs are defined as Af293 genes that have at least one ortholog in A. oryzae,
A. nidulans, A. niger or A. terreus.
**Genes with paralogs are defined as Af293 genes that have at least one paralogs in Af293.
***The ‘expressed’ genes are defined as Af293 genes that showed differential expression in at least
one microarray study ([NAME], unpublished).
Spreadsheet: 845145d1696667599-conditional-formatting-or-formula-to-match-values-accounts-receivable-statements-exclude-paid-up-invoices_20231007_092726
Sheet: Report

Debit | Credit
2859.75 | 0
868.92 | 0
2269.16 | 0
3232.35 | 0
204.31 | 0
400.2 | 0
5545.03 | 0
220.57 | 0
648.6 | 0
3592.79 | 0
0 | 6867
2114.1 | 0
2483.66 | 0
2263.4 | 0
0 | 3592.79
0 | 4997.96
1360.7 | 0
2760.2 | 0
401.56 | 0
3270.9 | 0
903.62 | 0
3208.03 | 0
Spreadsheet: 52593d1252443177-adding-up-numbers-based-on-number-in-separate-column-book2-1-
Sheet: Sheet1

Gains |  |  |  | Possible | Total
42 | 3 |  |  | 11 | 9 | 9 |  | Column A and B are the raw data and E and F show what I would like to get from it
34 | 7 |  |  | 12
42 | 6 |  |  | 13
34 | 6 |  |  | 14
11 | 1 |  |  | 15
17 | 4 |  |  | 16
22 | 6 |  |  | 17 | 4 | 4
67 | 7 |  |  | 18
11 | 8 |  |  | 19
65 | 9 |  |  | 20
 |  |  |  | 21
 |  |  |  | 22 | 6 | 6
 |  |  |  | 23
 |  |  |  | 24
 |  |  |  | 25
 |  |  |  | 26
 |  |  |  | 27
 |  |  |  | 28
 |  |  |  | 29
 |  |  |  | 30
 |  |  |  | 31
 |  |  |  | 32
 |  |  |  | 33
 |  |  |  | 34 | 13 | 13
 |  |  |  | 35
 |  |  |  | 36
 |  |  |  | 37
 |  |  |  | 38
 |  |  |  | 39
 |  |  |  | 40
 |  |  |  | 41
 |  |  |  | 42 | 9 | 9
 |  |  |  | 43
 |  |  |  | 44
 |  |  |  | 45
 |  |  |  | 46
 |  |  |  | 47
 |  |  |  | 48
 |  |  |  | 49
 |  |  |  | 50
 |  |  |  | 51
 |  |  |  | 52
 |  |  |  | 53
 |  |  |  | 54
 |  |  |  | 55
 |  |  |  | 56
 |  |  |  | 57
 |  |  |  | 58
 |  |  |  | 59
 |  |  |  | 60
 |  |  |  | 61
 |  |  |  | 62
 |  |  |  | 63
 |  |  |  | 64
 |  |  |  | 65 | 9 | 9
 |  |  |  | 66
 |  |  |  | 67 | 7 | 7
 |  |  |  | 68
 |  |  |  | 69
 |  |  |  | 70
 |  |  |  | 71
 |  |  |  | 72
 |  |  |  | 73
 |  |  |  | 74
 |  |  |  | 75
 |  |  |  | 76
 |  |  |  | 77
 |  |  |  | 78
 |  |  |  | 79
 |  |  |  | 80
 |  |  |  | 81
 |  |  |  | 82
 |  |  |  | 83
 |  |  |  | 84
 |  |  |  | 85
 |  |  |  | 86
 |  |  |  | 87
 |  |  |  | 88
Spreadsheet: 746732d1630991231-how-to-calculate-commission-and-bonus-with-conditions-in-excel-formulas-or-vb-script-book1
Sheet: Sheet1

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

Site | Scheduling group | Tecnician | Scheduled
A | 1a | DM | 2021-06-09 00:00:00
B | 1a | DM | 2021-06-09 00:00:00
C | 3b | DM | 2021-06-19 00:00:00
D | 3b | DM | 2021-06-19 00:00:00
E | 5a | PD | 2021-05-19 00:00:00
F | 5a | PD | 2021-05-19 00:00:00
G | 5b | DM | 2021-05-20 00:00:00
H | 5b | DM | 2021-05-20 00:00:00
I | 5b | DM | 2021-05-20 00:00:00
J | 6a | BB | 2021-04-06 00:00:00
K | 6b | BB | 2021-04-07 00:00:00
L | 7a | PD | 2021-05-19 00:00:00
Spreadsheet: 674404d1587822869-can-a-worksheet-create-an-image-membership-card-generator2
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | FRONT OF CARD |  |  |  |  | BACK OF CARD
 |  |  |  |  |  |  |  |  |  |  |  | The bearer of this card is a member in good
 |  |  |  | Card Generation Number |  |  |  |  |  |  |  | standing with Gibraltar Scale Modeling Society.
 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | If you have any questions regarding your membership
 |  |  |  |  |  |  |  |  |  |  |  | or Society contact the Secretary  by visiting the
 |  |  |  |  |  |  |  |  |  |  |  | Society's Facebook Page:
 |  |  |  |  |  |  |  |  |  |  |  | www.facebook.com/groups/1118683841524009/
 | Card Generation Number | Member first name | Member Last Name | Member id Number | Role | Date Issued | [NAME] | Full Name
 | 1 | R | P | ******** | Society President | 2020-08-15 00:00:00 |  | R P
 | 2 | M | I | ******** | Society Secretary | 2020-08-15 00:00:00 |  | M I
 | 3 | A | C | ******** | Society Treasurer | 2020-08-15 00:00:00 |  | A C
 | 4 | I | B | ******** | Society Vice - President | 2020-08-15 00:00:00 |  | I B
 | 5 | R | C | ******** | Society Vice - Secretary | 2020-08-15 00:00:00 |  | R C
 | 6 | J | C | ******** | Society Committee Member | 2020-08-15 00:00:00 |  | J C
 | 7 | M | B | ******** | Society Committee Member | 2020-08-15 00:00:00 |  | M B
 | 8 | J | F | ******** | Society Member | 2020-08-15 00:00:00 |  | J F
 | 9 | G | O | ******** | Society Member | 2020-08-15 00:00:00 |  | G O
 | 10 | I | R | ******** | Society Member | 2020-08-15 00:00:00 |  | I R
 | 11 | M | V | ******** | Society Member | 2020-08-15 00:00:00 |  | M V
 | 12 | J | C | ******** | Society Member | 2020-08-15 00:00:00 |  | J C
 | 13 | M | M | ******** | Society Member | 2020-08-15 00:00:00 |  | M M
 | 14 | J | M | ******** | Society Member | 2020-08-15 00:00:00 |  | J M
Spreadsheet: 142526d1329889597-conditional-weighted-average-ignoring-n-a-values-weighted-average-conditionl-with-error-sample2
Sheet: Sheet1

Occupation | [NAME] | Sample Size | Skilled | 0.6690066225165564 | [NAME]: | =SUMPRODUCT(B2:B11,C2:C11,(D2:D11="Yes")+0)/SUMPRODUCT(C2:C11,(D2:D11="Yes")+0)
Customer Service Rep | 0.76 | 216 | No |  | Result:
Teller | 0.45 | 198 | No
Software Engineer | 0.88 | 250 | Yes |  | [NAME]: | {=SUM((B2:B11)*(C2:C11)*(D2:D11="Yes"))/SUM(C2:C11*(D2:D11="Yes"))}
#N/A | #N/A | #N/A | #N/A |  | Result:
#N/A | #N/A | #N/A | #N/A
Financial Manager | 0.65 | 651 | Yes
School Psychologist | 0.32 | 89 | Yes
Recreation Worker | 0.93 | 233 | No
#N/A | #N/A | #N/A | #N/A
Mapping Technician | 0.53 | 67 | Yes
 | 0.76 | 216 | No
 | 0.45 | 198 | No
 | 0.88 | 250 | Yes
 | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A
 | 0.65 | 651 | Yes
 | 0.32 | 89 | Yes
 | 0.93 | 233 | No
 | #N/A | #N/A | #N/A
 | 0.53 | 67 | Yes
Spreadsheet: 784978d1656057559-lookup-partial-string-match-in-excel-test
Sheet: Sheet5

Column1 | Column2 |  | String | Expected |  |  |  | String | Value
Ayanande |  |  | Ayanande | 1 |  |  |  | Aya | 1
Ayonande |  |  | Ayonande | #N/A |  |  |  | Tes | 2
Aviles |  |  | Aviles | #N/A |  |  |  | Bad | 3
Bade |  |  | Bade | 3
Bailer |  |  | Bailer | #N/A
Test |  |  | Test | 2
Spreadsheet: james_steffes__12976__SVP3and4
Sheet: SVP-3

Exhibit SVP-3
RECAP OF GENERATION COSTS--Cal-PX
CITY of SANTA CLARA dba SILICON VALLEY POWER
October 2000-June 2001
 |  |  | October 2000 | November 2000 | December 2000
GIANERA MARGINAL COSTS
 | Actual Marginal Natural Gas Price, per BP Amoco billings |  | 5.93 | 10.81 | 45.28
 | [NAME] @ 15,500 Btu/KWh BackBoneOut |  | 15.5 | 15.5 | 15.5
 | Marginal Fuel Cost
 | Operations & Maintenance |  | 6 | 6 | 6
 | Marginal Cost  - ($/MWh)
NOTE that none of the costs shown include provision for (a) fixed costs, (b) emissions credits or penalties, (c) credit
risk, or (d) inefficiencies associated with quick rampup and rampdown (when fuel is being burned without producing power).
NOTE also:  Santa Clara made no sales to the PX after December 2000.
Spreadsheet: 744298d1629136778-auto-populate-cells-on-a-spreadsheet-from-another-sheet-daily-plan-export-2
Sheet: Sheet1

Booking | Route Code | Leg ID | Bid ID | Status | Collect > Drop Code | Equipment Type | Stop 1 | Stop 1 Yard Arrival | Stop 1 Yard Departure | Stop 2 | Stop 2 Yard Arrival | Stop 2 Yard Departure | [NAME] | Yard 1 Departurel Time | [NAME] | From | To
B-2PHG7RBML | T-11356VSPK | 1113KP57Y |  | PLANNED | EUK5->MAN8 | Double [NAME] | EUK5 | 08/16/2021 16:00 | 08/16/2021 17:00 | MAN8 | 08/16/2021 20:30
B-2PHG7RBML | T-11356VSPK | 115VGRZM9 |  | PLANNED | MAN8->EUK5 | Double [NAME] | MAN8 | 08/16/2021 20:45 | 08/16/2021 21:16 | EUK5 | 08/17/2021 01:26
Spreadsheet: 126616d1319775978-using-reference-with-inserting-rows-sample-1-
Sheet: Actuals

 | ACTUALS
 |  | 4 | 4
 |  |  | 4
Spreadsheet: 847194d1698239290-last-record-in-adjacent-column-returned-to-cell-test
Sheet: Sheet1

Item | Type | Date | Document Number | Serial Numbers |  |  | Item | Type | Date | Document Number | PartNo
PartA |  |  |  |  |  |  | PartA
 | Order | 2023-10-25 00:00:00 | 123 |  |  |  |  | Order | 2023-10-25 00:00:00 | 123 | PartA
 | Order | 2023-10-25 00:00:00 | 124 |  |  |  |  | Order | 2023-10-25 00:00:00 | 124 | PartA
 | Order | 2023-10-25 00:00:00 | 125 |  |  |  |  | Order | 2023-10-25 00:00:00 | 125 | PartA
 | Order | 2023-10-25 00:00:00 | 126 |  |  |  |  | Order | 2023-10-25 00:00:00 | 126 | PartA
Total - PartA |  |  |  |  |  |  | Total - PartA
PartB |  |  |  |  |  |  | PartB
 | Order | 2023-10-25 00:00:00 | 127 |  |  |  |  | Order | 2023-10-25 00:00:00 | 127 | PartB
Total - PartB |  |  |  |  |  |  | Total - PartB
PartC |  |  |  |  |  |  | PartC
 | Order | 2023-10-25 00:00:00 | 128 |  |  |  |  | Order | 2023-10-25 00:00:00 | 128 | PartC
Total - PartC |  |  |  |  |  |  | Total - PartC
Spreadsheet: 180026d1347459543-leader-board-lookup-mick-score-sheet
Sheet: Patterns

 | PATTERNS
 | Teams | PAT 1 | PAT 2 | PAT 3 | PAT 4 | PAT 5 | PAT 6 | PAT 7 | PAT 8 | PAT 9 | PAT 10 | PAT 11 | PAT 12 | PAT 13 | PAT 14 | PAT 15 | PAT 16 | PAT 17 | PAT 18 | PAT 19 |  | TOTAL
 | IRISH ITF | 10
 | GASSOR TKD WALES | 15
 | EAST COAST TKD
 | BANNER MARTIAL ARTS
Spreadsheet: 729928d1619442772-group-and-total-duplicate-values-in-a-column-group-and-total-duplicate-values-in-a-column
Sheet: Sheet1

Customer Name | [NAME] |  |  | Customer | Total
YTC Ltd | 1 |  |  | YTC Ltd | 1
Yorkshire Purchasing Organisation - YPO | 1 |  |  | Yorkshire Purchasing Organisation - YPO | 1
YESSS Electrical | 1 |  |  | YESSS Electrical | 1
X L Technical Services | 1 |  |  | X L Technical Services | 1
Wirs (Wolverhampton) Ltd. | 1 |  |  | Wirs (Wolverhampton) Ltd. | 1
[NAME] | 1 |  |  | [NAME] | 1
[NAME] t/a Sunrise Bakery | 1 |  |  | [NAME] t/a Sunrise Bakery | 1
[NAME] | 1 |  |  | WICKES | 12
[NAME] 8080 | 1 |  |  | WHS Plastics Ltd | 1
WICKES Trowbridge 8275 | 1 |  |  | Wholesale POS Limited | 1
WICKES Swansea Extra 8323 | 1 |  |  | [NAME] | 1
WICKES Stowmarket 8493 | 1 |  |  | Walraven Ltd | 1
WICKES Brentwood 8409 | 1 |  |  | Wrights Plastics  Ltd | 2
WICKES Andover 8321 | 1 |  |  | Widney Manufacturing Ltd | 2
Wickes - WEST LONDON FULFILMENT | 1 |  |  | Zeus Media Ltd | 3
WHS Plastics Ltd | 1 |  |  | Westgate Global Ltd | 4
Wholesale POS Limited | 1 |  |  | Yours Clothing Ltd | 6
[NAME] | 1 |  |  | Wiggle Ltd - Citadel | 6
Walraven Ltd | 1 |  |  | XPO Transport Solutions UK Limited | 12
Wrights Plastics  Ltd | 2
Widney Manufacturing Ltd | 2
WICKES Boston 8355 | 2
WICKES Bedford 8264 | 2
Zeus Media Ltd | 3
Westgate Global Ltd | 4
Yours Clothing Ltd | 6
Wiggle Ltd - Citadel | 6
XPO Transport Solutions UK Limited | 12