tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 138202d1327564777-filling-in-hlookup-formula-hlookup
Sheet: Sheet2

Name | PG | SG | SF | PF | C
Player 2 | 32 | 36 | 27 | 15 | 12
Player 3 | 63 | 20 | 18 | 16 | 14
Player 4 | 75 | 27 | 18 | 8 | 8
Player 5 | 36 | 22 | 31 | 9 | 7
Player 6 | 65 | 42 | 21 | 18 | 12
Player 7 | 32 | 29 | 27 | 19 | 15
Player 8 | 57 | 46 | 23 | 11 | 14
Player 9 | 67 | 50 | 41 | 13 | 12
Player 10 | 59 | 35 | 22 | 19 | 13
Player 11 | 75 | 44 | 41 | 20 | 14
Player 12 | 39 | 49 | 33 | 16 | 9
Player 13 | 36 | 42 | 22 | 19 | 10
Player 14 | 53 | 31 | 42 | 14 | 13
Player 15 | 43 | 25 | 37 | 20 | 13
Player 16 | 79 | 22 | 34 | 18 | 11
Player 17 | 44 | 40 | 23 | 12 | 13
Spreadsheet: 829040d1683880477-round-formula-problem-round_up_formula
Sheet: Φύλλο1

 | PRODUCT | VAT 6% | TOTAL VALUE |  | VERIFICATION
 | 115.44 |  |  | ü
 | 94.64 |  |  | ü
 | 107.4 |  |  | ü
 | 125.52 |  |  | ü
 | 125.52 |  |  | ü
 | 169.16 |  |  | ü
 | 30.71 |  |  | ü
 | 128.88 |  |  | ü
 | 136.28 |  |  | ü
 | 61.08 |  |  | WRONG
 | 29.53 |  |  | ü
 | 70.82 |  |  | ü
 | 72.16 |  |  | ü
 | 260.1 |  |  | ü
 | 121.82 |  |  | ü
 | 8.91 |  |  | WRONG
Spreadsheet: 757117d1638024843-cant-figure-out-how-apportion-earnings-in-a-period-to-daily-tried-sumifs-function-helpmeplease
Sheet: Sheet1

Worker | Start Date | End Date | Amount earned | Number of days worked | Amount earned per day
[NAME] | 2021-06-02 00:00:00 | 2021-06-04 00:00:00 | 350
[NAME] | 2021-06-02 00:00:00 | 2021-06-06 00:00:00 | 600
[NAME] | 2021-06-03 00:00:00 | 2021-06-08 00:00:00 | 692
[NAME] | 2021-06-04 00:00:00 | 2021-06-05 00:00:00 | 137
Desired Result
Date | Daily salary cost |  | Non working formula
2021-06-01 00:00:00 | 0 |  | =SUMIFS(F$2:F$5,B$2:B$5,=<B9,C2:C5,=>B9)
2021-06-02 00:00:00
2021-06-03 00:00:00
2021-06-04 00:00:00
2021-06-05 00:00:00
2021-06-06 00:00:00
2021-06-07 00:00:00
2021-06-08 00:00:00
2021-06-09 00:00:00 | 0
2021-06-10 00:00:00 | 0
2021-06-11 00:00:00 | 0
Spreadsheet: 878569d1725661053-need-formulas-to-get-average-of-monthly-productivity-per-person-alchavar-productivity-changes_v2-tms
Sheet: Monthly Average

Months | Person 1 | Months | Person 2 | Months | Person 3 | Person 4 | Person 5 | Person 6 | Person 7 | Person 8 | Person 9 | Person 10 | Person 11 | Person 12
2024-09-01 00:00:00 | 0.68 | 2024-09-01 00:00:00 |  | 2024-09-01 00:00:00
2024-10-01 00:00:00 | 0.43 | 2024-10-01 00:00:00 |  | 2024-10-01 00:00:00
2024-11-01 00:00:00 | 0.23 | 2024-11-01 00:00:00 |  | 2024-11-01 00:00:00
2024-12-01 00:00:00 | 0.22 | 2024-12-01 00:00:00 |  | 2024-12-01 00:00:00
2025-01-01 00:00:00 | 0.49 | 2025-01-01 00:00:00 |  | 2025-01-01 00:00:00
2025-02-01 00:00:00 | 0.82 | 2025-02-01 00:00:00 |  | 2025-02-01 00:00:00
TMS
 | 0.4321776800000002 |  | 0 |  | 0.97311828 | 0 | 0.7828947399999998 | 1 | 0 | 0.2458396499999998 | 0 | 0 | 0.8000000000000004 | 0
 | 0.2267930659999999 |  | 0 |  | 1 | 0 | 0.7828947399999998 | 1 | 0 | 0.2458396499999998 | 0 | 0 | 0.2711864390000001 | 0
 | 0.2206392199999999 |  | 0 |  | 1 | 0 | 0.7828947399999998 | 1 | 0 | 0.2458396499999998 | 0 | 0 | 0.2457627100000001 | 0
 | 0.4868486367741937 |  | 0.7741935483870968 |  | 1 | 1 | 1 | 1 | 1 | 0.5402593403225805 | 0.7741935483870968 | 1 | 0.4457627100000002 | 1
 | 0.8192307700000004 |  | 1 |  | 1 | 1 | 1 | 1 | 1 | 0.5490101999999998 | 1 | 1 | 0.5728813549999998 | 1
The_Snook
Spreadsheet: 60284d1260846108-adding-values-reference-to-date-today-sum_today
Sheet: sum_today

 |  |  |  | 2009-12-11 00:00:00 |  |  |  | 2009-12-12 00:00:00 |  |  |  | 2009-12-13 00:00:00 |  |  |  | 2009-12-14 00:00:00 |  |  |  | 2009-12-15 00:00:00
name | T Expected | Tactual | Tvariance | expected | actual | variance | % | expected | actual | variance | % | expected | actual | variance | % | expected | actual | variance | % | expected | actual | variance | %
[NAME] |  |  |  | 3 | 2 |  |  | 2 | 3 |  |  | 5 | 3 |  |  | 1 |  |  |  | 10
[NAME] |  |  |  | 2 | 2 |  |  | 3 | 3 |  |  | 4 | 3 |  |  | 5 | 4 |  |  | 6
Sum only up to todays date
Spreadsheet: 294512d1391419391-separating-text-and-numbers-in-different-columns-separating-text-and-columns
Sheet: Sheet1

38,084 Leighton Holdings Ltd. $ 841,060 |  | OUTPUT REQUIRED
70,219 NRW Holdings Ltd. ______3_0_1_,_8_5__6 |  | 70219 | NRW Holdings Ltd. | 301856
____1_,_1_4_2_,_9_1__6
340,773 HKC (Holdings) Ltd. _______1_8_,_4_3_1_
16,346 SNC-Lavalin Group, Inc. 654,365
12,643 Stantec, Inc. ______4_0_3_,_0_7__5
____1_,_0_5_7_,_4_4__0
638,188 China State Construction
International Holdings Ltd. ______5_9_4_,_1_7__5
899,260 China Communications
Construction Co., Ltd. 902,091
1,424,632 China Railway Group Ltd. ______4_5_6_,_8_0__4
____1_,_3_5_8_,_8_9__5
15,565 Orascom Construction Industries,
GDR ______6_7_5_,_0_5_4_
31,650 [NAME] ______6_8_0_,_4_5_4_
Spreadsheet: 147464d1332803237-comparing-dates-from-multiple-cells-testv2
Sheet: Formula

ID | Name | Start | End | [NAME] | Reference
123 | [NAME] | 2012-01-01 00:00:00 | 2012-03-01 00:00:00 |  | 123
123 | [NAME] | 2012-02-01 00:00:00 | Open |  | 123
123 | [NAME] | 2012-03-01 00:00:00 | 2012-05-01 00:00:00 |  | 123
456 | Angus | 2012-03-01 00:00:00 | Open |  | 456
Spreadsheet: chris_stokley__3971__Consumption Bands grid
Sheet: Sheet1

EES/EWS
Consumption Band Analysis
Invoicing |  |  | Collected | Captured | Unbilled | Unbilled | Billed
Group | Commodity | System(s) | Contracts | Terms | $ | Comments | $
CSC | Gas
 | Power
GNO | Gas
 | Power
Total Gas
Total Power
Grand Total
Questions?  [NAME] x35953 or [NAME] x55171
2001-09-04 00:00:00
Spreadsheet: 823353d1679922115-dont-know-how-to-formulate-fixture-congestion-ef1604_sample-champ-matches
Sheet: Sheet1

Home Team | Away Team | date | match
AFC Bournemouth | West Bromwich Albion | 2021-08-06 00:00:00
Barnsley | Coventry City | 2021-08-14 00:00:00
Barnsley | [NAME] | 2021-08-17 00:00:00
AFC Bournemouth | Blackpool | 2021-08-21 00:00:00
Barnsley | Birmingham | 2021-08-28 00:00:00
AFC Bournemouth | Barnsley | 2021-09-11 00:00:00
AFC Bournemouth | Queens Park Rangers | 2021-09-14 00:00:00
Barnsley | [NAME] | 2021-09-18 00:00:00
AFC Bournemouth | [NAME] | 2021-09-25 00:00:00
Barnsley | [NAME] | 2021-09-29 00:00:00
AFC Bournemouth | Sheffield United | 2021-10-02 00:00:00
Barnsley | Millwall | 2021-10-02 00:00:00
AFC Bournemouth | Huddersfield Town | 2021-10-23 00:00:00
Barnsley | Sheffield United | 2021-10-24 00:00:00
AFC Bournemouth | [NAME] | 2021-11-03 00:00:00
Barnsley | Derby County | 2021-11-03 00:00:00
AFC Bournemouth | Swansea City | 2021-11-06 00:00:00
Barnsley | Hull City | 2021-11-06 00:00:00
Barnsley | Swansea City | 2021-11-24 00:00:00
AFC Bournemouth | Coventry City | 2021-11-27 00:00:00
Barnsley | Huddersfield Town | 2021-12-04 00:00:00
AFC Bournemouth | [NAME] | 2021-12-11 00:00:00
Barnsley | West Bromwich Albion | 2021-12-17 00:00:00
AFC Bournemouth | Cardiff City | 2021-12-30 00:00:00
AFC Bournemouth | Hull City | 2022-01-22 00:00:00
Barnsley | AFC Bournemouth | 2022-01-29 00:00:00
Barnsley | Cardiff City | 2022-02-02 00:00:00
AFC Bournemouth | Birmingham | 2022-02-09 00:00:00
Barnsley | Queens Park Rangers | 2022-02-12 00:00:00
AFC Bournemouth | Stoke City | 2022-02-26 00:00:00
Barnsley | Middlesbrough | 2022-02-26 00:00:00
AFC Bournemouth | Peterborough United | 2022-03-08 00:00:00
Barnsley | Stoke City | 2022-03-08 00:00:00
AFC Bournemouth | Derby County | 2022-03-12 00:00:00
Barnsley | Fulham | 2022-03-12 00:00:00
AFC Bournemouth | Reading | 2022-03-15 00:00:00
Barnsley | Bristol City | 2022-03-15 00:00:00
AFC Bournemouth | Bristol City | 2022-04-02 00:00:00
Barnsley | Reading | 2022-04-02 00:00:00
AFC Bournemouth | Middlesbrough | 2022-04-15 00:00:00
Barnsley | Peterborough United | 2022-04-18 00:00:00
AFC Bournemouth | Fulham | 2022-04-23 00:00:00
Barnsley | Blackpool | 2022-04-26 00:00:00
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 2

 | Jan 18 |  | Jan 25 |  | Feb 1 |  | Feb 8
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate* | 385395440 | 385395440 | 388372022 | 388372022 | 395042431 | 395042431 | 391358938 | 391358938
SD/MSPs | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 17016046 | 17016046 | 16743138 | 16743138 | 16797419 | 16797419 | 16700745 | 16700745
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 20654755 | 20654755 | 20848248 | 20848248 | 21093582 | 21093582 | 20943010 | 20943010
Dealers** | 17466814 | 17468028 | 17607027 | 17604488 | 17811411 | 17815529 | 17717132 | 17714119
Buyside | 3187941 | 3186727 | 3241221 | 3243760 | 3282172 | 3278054 | 3225878 | 3228891
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL]
Spreadsheet: 6ccda76c-fe42-41d6-bc86-e95b79061628
Sheet: Salary Schedule

 | School District |  |  |  |  |  |  |  | District Code
 | School District
 | [NAME] for Certified Staff
 | FY 2013-2014
 | Directions:
 | Insert the BASE amount in cell C11
 | Insert the Step Increase amount (DOWN) in cell C12
 | Insert the Education Level increase amount (ACROSS) in cell C13
 | Insert the Step increase amount for Education Level at MA or higher (MA-DOWN) in cell C14
 | S D | BASE | 0
 | T O | DOWN | 0 |  | Note:  Do not change the size or location of this schedule, will impact linkage.
 | E W | ACROSS | 0
 | P N | MA-DOWN | 0
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | BA | BA+12 | BA+24 | BA+36 | BA+45 | MA | [NAME] | MA+24 | MA+36 | MA+45 | SPECED | ED
 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
 | 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
Spreadsheet: 698357d1601944842-how-to-create-a-vlookup-from-different-sources-vlookup
Sheet: SOURCE 2

SOURCE 2
BIL | FORM | NAME | NO 1 | NO 2 | RESULT 1 | RESULT 2 | RESULT 3 | RESULT 4 | RESULT 5 | RESULT 6 | RESULT 7 | RESULT 8 | RESULT 9 | RESULT 10
4 | 3A | SIMON | [PHONE] | BN11559 | 70 | 35 | 70 | 85 | 55 | 80 | 80 | 90 | 50 | 95
3 | 3A | [NAME] | [PHONE] | BN11558 | 85 | 60 | 65 | 45 | 35 | 30 | 70 | 80 | 35 | 80
1 | 3A | RAYMOND | [PHONE] | BN11556 | 85 | 40 | 60 | 80 | 75 | 85 | 90 | 90 | 75 | 90
2 | 3A | FELIX | [PHONE] | BN11557 | 75 | 45 | 65 | 75 | 35 | 50 | 60 | 70 | 40 | 85
Spreadsheet: 673977d1587619509-formula-to-list-all-cells-that-has-a-certain-value-text-book1
Sheet: Sheet1

District | Reject
115 | 0.00765278898691643
340 | 0.007180660152148994 |  | Listing 0.00%
241 | 0.006886924359764845 |  | Needed Output→ | No recorded Reject in District 224 and 789.
860 | 0.005518031269431262 |  | Output Formula→?
400 | 0.004475454065771059
704 | 0.003627006519898013
242 | 0.003385750179933342 |  | Listing No data
110 | 0.0004715936412289138 |  | Needed Output→ | No data in District 980, 981, 444, 805, 820, 310, 325 and 330.
224 | 1.479399870959185e-06 |  | Output Formula→?
780 | 0
980 | No data
981 | No data |  | NOTE: Data source is changing from time to time. So the number of 0.00% and No data is not fix. It will be more or less from the sample data source.
444 | No data
805 | No data
820 | No data
310 | No data
324 | No data
330 | No data
Spreadsheet: 685412d1593979302-sum-amounts-column-d-by-department-column-a-sample
Sheet: Sheet1

Jan
Department | Distributor | Invoice | Amount
PART | HUL | 5812 | 142.74
PART | HUL | 5822 | 48.37
PART | HUL | 6094 | 27.35
PART | HUL | 6100 | 99.3
PART | HUL | 6109 | 146.02
PART | HUL | 6118 | 15.6
PART | HUL | 6124 | 48.9
PART | HUL | 6016 | 551.69
PART | HUL | 6131 | 67.15
PART | HUL | 6149 | 121.7
PART | HUL | 6151 | 66.46
PART | HUL | 6156 | 102.82
PART | HUL | 6157 | 72.7
PART | WEB | 65940751 | 2283.24
PART | WEB | 65952121 | -807.88
PART | WEB | 65998737 | 805.64
PART | WEB | DISCOUNT | -41.58
PART | GRAG | 122683040 | 680.75
PART | GRAG | DISCOUNT | -12.84
PART | PAR | 1003790 | 12.73
PART | BRL | 171703 | 19.09
PART | RKM | 968032 | 3.19
RENT | TAYR | 23240003 | 24.86
TRASH | DEN |  | 45
TOOL | BRL | 171033 | 29.94
INS | NGM | CK# 2731 | 561.8
VEH | GFN |  | 524.3
LAB | SMD | WE142020 | 760
Spreadsheet: gstorey__12025__Jan01
Sheet: Table10

NATURAL GAS EXPORTS BY TERM, REGION, AND CUSTOMER TYPE |  |  |  |  |  |  |  |  |  |  |  | TABLE 10
EXPORTATIONS DE GAZ NATUREL PAR TERME, RÉGION, ET CLIENT
CALENDAR YEAR TO DATE
 |  |  |  | AVERAGE PRICE |  |  |  |  |  | AVERAGE PRICE
 | VOLUME |  |  | PRIX MOYEN |  |  | VOLUME |  |  | PRIX MOYEN
 | (MILLIONS M3) |  |  | ($CDN/GJ) |  |  | (BCF) |  |  | ($US/MMBTU)
 |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE
 | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | VARIATION | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | VARIATION | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | VARIATION | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | VARIATION
 | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 |  | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 |  | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 |  | 2000-01-01 00:00:00 | 2001-01-01 00:00:00
TERM/TERME
LONG-TERM (FIRM)/LONG TERME (GARANTI) | 2369.1 | 1854.6 | -21.7 | 3.44 | 10.77 | 213.1 | 83.6 | 65.5 | -21.7 | 2.55 | 7.69 | 201.8
SHORT-TERM (FIRM)/COURT TERME (GARANTI) | 4012.8 | 5058.3 | 26.1 | 3.15 | 13.01 | 313 | 141.7 | 178.6 | 26.1 | 2.33 | 9.29 | 298.1
SHORT-TERM/COURT TERME (INTERRUPTIBLE) | 2304.2 | 3659.8 | 58.8 | 3.13 | 14.25 | 355.9 | 81.3 | 129.2 | 58.8 | 2.31 | 10.17 | 339.5
TOTAL - TERM/TERME | 8686.1 | 10572.6 | 21.7 | 3.22 | 13.05 | 305 | 306.6 | 373.2 | 21.7 | 2.39 | 9.31 | 290.3
REGION/RÉGION
CALIFORNIA/CALIFORNIE | 1805.8 | 1602.2 | -11.3 | 2.98 | 13.14 | 340.9 | 63.7 | 56.6 | -11.3 | 2.21 | 9.38 | 325
MIDWEST/MIDWEST | 3226.9 | 4008.7 | 24.2 | 3 | 13.07 | 335.4 | 113.9 | 141.5 | 24.2 | 2.22 | 9.33 | 319.7
MOUNTAIN/ROCHEUSES | 66.2 | 38 | -42.6 | 2.82 | 9.08 | 221.8 | 2.3 | 1.3 | -42.6 | 2.09 | 6.48 | 210.2
NORTHEAST/NORD-EST | 2313 | 3502.1 | 51.4 | 3.78 | 12.43 | 229 | 81.7 | 123.6 | 51.4 | 2.8 | 8.87 | 217.1
PACIFIC NORTHWEST/NORD-OUEST PACIFIQUE | 1274.1 | 1421.7 | 11.6 | 3.14 | 14.5 | 361.8 | 45 | 50.2 | 11.6 | 2.33 | 10.35 | 345.1
TOTAL - REGION/RÉGION | 8686.1 | 10572.6 | 21.7 | 13.05 | 3.22 | 305 | 306.6 | 373.2 | 21.7 | 2.39 | 9.31 | 290.3
CUSTOMER TYPE/CLIENT
END-USER/UTILISATEURS ULTIMES | 651.4 | 640.5 | -1.7 | 3.68 | 8.42 | 128.6 | 23 | 22.6 | -1.7 | 2.73 | 6.01 | 120.3
LDC/SDL | 2305.6 | 2151.3 | -6.7 | 3.34 | 11.8 | 253.1 | 81.4 | 75.9 | -6.7 | 2.48 | 8.43 | 240.3
MARKETING CO./DISTRIBUTEURS | 5409.7 | 7656.4 | 41.5 | 3.15 | 13.81 | 338.7 | 191 | 270.3 | 41.5 | 2.33 | 9.86 | 322.9
PIPELINE/PIPELINES | 319.4 | 124.5 | -61 | 2.67 | 11.47 | 328.7 | 11.3 | 4.4 | -61 | 1.98 | 8.18 | 313.2
TOTAL - CUSTOMER TYPE/CLIENT | 8686.1 | 10572.6 | 21.7 | 3.22 | 13.05 | 305 | 306.6 | 373.2 | 21.7 | 2.39 | 9.31 | 290.3
NOTE: | THE AVERAGE PRICE IS THE WEIGHTED |  |  |  |  |  |  | NOTA: | LE PRIX MOYEN EST LE PRIX MOYEN PONDÉRÉ
 | AVERAGE PRICE AT THE INTERNATIONAL BORDER |  |  |  |  |  |  |  | À LA FRONTIÈRE INTERNATIONALE
Spreadsheet: 19e20213-5600-4876-89ac-571ef63df90a
Sheet: Sheet1

Table S2. Genotyping details for mutant alleles used in this study. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Genotype | Origin | Mutagen | Mutation position | Primers for genotyping
arf8-7 | this work | EMS | 1bp deletion in 12th exon (position 3106, AAT CTT TTG AAT), causes frameshift that introduces premature stop (AAT TTT TGA AT)
arf8-8 | this work | EMS | G→A in splice acceptor site at 5th intron/6th exon junction (ttgcagGAT) | CAPS: [NAME], [NAME] 2180R (EcoNI cuts wild type)
arf8-9 | this work | EMS | C→T in 10th exon, changes Ser329 (TCT) to Phe (TTT) | dCAPS: arf8-9 dCAPS F, arf8-9 dCAPS R (HindIII cuts arf8-9)
myb21-2 | SALK_042711 | T-DNA | 2nd intron | [NAME]: MYB21 F1, myb21 r1
 |  |  |  | T-DNA: JMLB1, MYB21 R1
myb21-4 | this work | EMS | A→G changes Trp106 (TGG) to stop (TAG) | CAPS: MYB21 ins-HindIII F, MYB21 ins-BamHI R
 |  |  |  | (XbaI cuts myb21-4)
myb21-5 | this work | EMS | G→A changes Trp45 (TGG) to stop (TGA) | CAPS: MYB21 -131F, MYB21 1370R
 |  |  |  | (EcoRI cuts wild type)
myb24-2 | SALK_030452 | T-DNA | 1st intron | WT: MYB24 F1, MYB24 R4
 |  |  |  | T-DNA: JMLB1, MYB24 R1
myb24-3 | SALK_017221 | T-DNA | 2nd intron | WT: MYB24 F1, MYB24 R4
 |  |  |  | T-DNA: JMLB1, MYB24R2
myb24-5 | SALK_038872 | T-DNA | 1st intron | WT: MYB24 F1, MYB24 R4
 |  |  |  | T-DNA: JMLB1, MYB24 F2
myb24-6 | SALK_065218 | T-DNA | 2nd intron | WT: MYB24 F1, MYB24 R4
 |  |  |  | T-DNA: JMLB1, MYB24-R2
myb57-1 | SALK_065776 | T-DNA | 3rd exon | WT: MYB57 F1, MYB57 R1
 |  |  |  | T-DNA: JMLB1, MYB57 R1
myb108-1 | SALK_056061 | T-DNA | 1st intron | WT: MYB108 F1, MYB108 R1
 |  |  |  | T-DNA: did not amplify (rearrangement?)
myb108-2 | SALK_024059 | T-DNA | 1st intron | WT: MYB108 F1, MYB108 R1
 |  |  |  | T-DNA: JMLB1, MYB108 F1
myb108-4 | SALK_044954 | T-DNA | 2nd intron | WT: MYB108 F1, MYB108 R1
 |  |  |  | T-DNA: JMLB1, MYB108 R1
aos-2 | SALK_017756 | T-DNA | 1st Exon | WT: AOS F1, AOS R1
 |  |  |  | T-DNA: JMLB1, AOS F1
coi1-1 |  |  |  | dCAPS: coi1-1 BamHI F, coi1-1 EcoRI R
 |  |  |  | EcoRI cuts coi1-1 product
Mutations for which genotyping information has been reported previously are not included here.  The positions of T-DNA insertions are based on end-sequencing provided by the SIGNAL database ([NAME], 2003).  Primer sequences are provided in Table S5.
Spreadsheet: 143998d1330661068-need-to-eliminate-blank-lines-in-vlookup-results-card
Sheet: Cards

Control # | Customer | date | card type | card number | balance | Verified Date | Verified By | paid | Notes | Sold to | Date Sold | $$ Sold | Date paid | Reallocated To | Reallocated Date
1 | [NAME] | 2012-02-01 00:00:00 | office depot | 123456 | 45 | 2012-02-01 00:00:00 | lc | 22 |  |  |  |  |  | Dale | 2012-02-17 00:00:00
 | [NAME] | 2012-02-01 00:00:00 | home depot | 2345436 | 99 |  |  | 68 |  | Plastic Jungle | 2012-02-20 00:00:00 | 100 | 2012-02-24 00:00:00
 | susan | 2012-02-01 00:00:00 | lowes | 5687 | 75 |  |  | 50 |  |  |  |  |  | Central | 2012-02-15 00:00:00
 | phillip | 2012-02-01 00:00:00 | tjmax | 563450897 | 68 |  |  | 32 |  | [NAME] | 2012-02-15 00:00:00 | 60
 | Mark | 2012-02-02 00:00:00 | home depot | 235780 | 150 |  |  | 90 |  | Plastic Jungle | 2012-02-15 00:00:00 | 145 | 2012-02-17 00:00:00
 | Vicky | 2012-02-04 00:00:00 | lowes | 2582610 | 125 |  |  | 75 |  |  |  |  |  | Dale | 2012-02-10 00:00:00
Spreadsheet: james_steffes__12853__CA rate exposure final 8-28 rev1
Sheet: New

NEW CUSTOMERS (DA for first time as of 10/1/01)
PG&E | Utility Undercollection |  |  |  |  | Bonds |  |  |  |  | Above Market Contract Cost |  |  |  |  | Weighted Avg. Total
 | Scenario | A | B | C |  | Scenario | A | B | C |  | Scenario | A | B | C
 | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted
 | Probability |  |  |  | Average | Probability |  |  |  | Average | Probability |  |  |  | Average
 | Factor | 1 | 1 | 0 |  |  | 1 | 1 | 0 |  |  | 1 | 1 | 0
Amortization (years)
5
7
10
12
15
Edison | Utility Undercollection |  |  |  |  | Bonds |  |  |  |  | Above Market Contract Cost
 | Scenario | A | B | C |  | Scenario | A | B | C |  | Scenario | A | B | C
 | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted
 | Probability |  |  |  | Avg | Probability |  |  |  | Avg | Probability |  |  |  | Avg
 | Factor | 1 | 1 | 0 |  | Factor | 1 | 1 | 0 |  | Factor | 1 | 1 | 0
Amortization (years)
5
7
10
12
15
SDG&E | Utility Undercollection |  |  |  |  | Bonds |  |  |  |  | Above Market Contract Cost
 | Scenario | A | B | C |  | Scenario | A | B | C |  | Scenario | A | B | C
 | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted
 | Probability |  |  |  | Avg | Probability |  |  |  | Avg | Probability |  |  |  | Avg
 | Factor | 1 | 1 | 0 |  | Factor | 1 | 1 | 0 |  | Factor | 1 | 1 | 0
Amortization (years)
5
7
10
12
15
Spreadsheet: 712137d1610066922-auto-filter-data-by-date-for-print-only-example
Sheet: PrintOnly

 |  |  |  |  | Date | 2021-01-01 00:00:00
S# | Name of Product | Quantity | Date | Buyers | Transit Co. | Delivery Agency
1 | Groceries | 600 | 44197 | [NAME] | SSL Trans. | Speedex
Short Note
2 | Hardware | 500 | 44197 | [NAME] | ACO Trans. | Leopard
Short Note
3 | Clothes | 200 | 44197 | [NAME] | PQ Trans. | TCS
Short Note
Spreadsheet: 543004d1508195691-array-question-s666-1204599-array-question
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Manual Solution
 |  |  | I need average difference between column A and column B.
Spreadsheet: 273609d1382784290-average-age-in-sports-team-average-sports-age-1
Sheet: Sheet1

 |  |  | Game's total time: | 93 |  |  | time increments
 |  |  | Age | Start time | End time | Average sports age | 0
 |  | Player A | 31 | 0 | 93
 |  | Player B | 34 | 0 | 70
 |  | Player C | 27 | 0 | 56
 |  | Player D | 25 | 0 | 93
 |  | Player E | 24 | 0 | 93
 |  | Player F | 18 | 70 | 93