tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 153225d1335808721-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: mar 12

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2012-03-12 00:00:00 | 2012-03-13 00:00:00 | 2012-03-14 00:00:00 | 2012-03-15 00:00:00 | 2012-03-16 00:00:00 | 2012-03-17 00:00:00
[NAME] | off | 9:30-5:30 | 8:00-5:00 | 8:00-5:00 | 8:30-5:30 | 9:15-5:15
 |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 38
[NAME] | 8:30-5:30 | 8:30-5:30 | 9:30-5:30 | 8:30-5:30 | 9:30-5:30 | off
 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 |  | 38
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | 8:00-4:00 | off
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 |  | 38
Mark | 8:00-5:00 | 9:00-4:00 | 8:30-5:30 | 8:30-5:30 | off | 9:00-5:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 |  | 1:00-2:00 | 38
[NAME] | 8:30-5:30 | off | 8:30-5:30 | 7:00-4:00-HOMER | 9:00-5:00 | 9:15-5:15-ctr
ctr 12-2 | 11:00-12:00 | off | 11:00-12:00 | 1ub | 11:00-12:00 | 11:00-12:00 | 38
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: 3f376b1f-b0b4-48f0-bbfb-27871c6911b8
Sheet: Table S8

Supplementary Table 8. List of dual-luciferase reporter vectors
ID | Parent vector | Gene | Feature description | Note
pOKY001 | psiCheck2* |  | No UTR | Has LIC tag for cloning 3' UTR of interest
pOKY002 | pOKY001 | SV40 | SV40 late polyA signal
pOKY006 | pOKY001 | IRF5 | 3' UTR + 100 bp downstream sequence from GM10860 | prox PAS=AATAAA, distal PAS=AATAAA, WT ARE
pOKY034 | pOKY006 | IRF5 | 3' UTR + 100 bp downstream sequence from GM10860 | prox PAS=AATGAA (mutated from pOKY006), distal PAS=AATAAA, WT ARE
pOKY015 | pOKY006 | IRF5 | 3' UTR + 100 bp downstream sequence from GM10860 | prox PAS=AATAAA, distal PAS=AATAAA, mutant ARE
pOKY016 | pOKY015 | IRF5 | 3' UTR + 100 bp downstream sequence from GM10860 | prox PAS=AATGAA (mutated from pOKY015), distal PAS=AATAAA, mutant ARE
pOKY010 | pOKY001 | EIF2A | 3' UTR + 100 bp downstream sequence from GM17220 | prox PAS=ATTAAA, distal PAS=AATAAA
pOKY011 | pOKY001 | EIF2A | 3' UTR + 100 bp downstream sequence from GM17253 | prox PAS=ATTAAA, distal PAS=AACAAA, Sequence identical with pOKY010 except one nucleotide in distal PAS
pOKY012 | pOKY001 | DIP2B | 3' UTR + 100 bp downstream sequence from GM10860 | prox PAS=ATTAAA, distal PAS=AATAAA, WT miR-101 binding site
pOKY033 | pOKY012 | DIP2B | 3' UTR + 100 bp downstream sequence from GM10860 | prox PAS=ACTAAA (mutated from pOKY012), distal PAS=AATAAA, WT miR-101 binding site
pOKY078 | pOKY012 | DIP2B | 3' UTR + 100 bp downstream sequence from GM10860 | prox PAS=ATTAAA, distal PAS=AATAAA, mutant miR-101 binding site
pOKY080 | pOKY033 | DIP2B | 3' UTR + 100 bp downstream sequence from GM10860 | prox PAS=ACTAAA, distal PAS=AATAAA, mutant miR-101 binding site
pOKY025 | pOKY001 | NAB1 | 3' UTR + 100 bp downstream sequence from GM17220 | prox PAS=AATAAA, distal PAS=AATAAA, WT ARE
pOKY036 | pOKY025 | NAB1 | 3' UTR + 100 bp downstream sequence from GM17220 | prox PAS=GATAAA (mutated from pOKY025), distal PAS=AATAAA, WT ARE
pOKY081 | pOKY025 | NAB1 | 3' UTR + 100 bp downstream sequence from GM17220 | prox PAS=AATAAA, distal PAS=AATAAA, mutant ARE
pOKY083 | pOKY036 | NAB1 | 3' UTR + 100 bp downstream sequence from GM17220 | prox PAS=GATAAA, distal PAS=AATAAA, mutant ARE
* From [NAME]
Spreadsheet: 122071d1316604796-using-sumif-to-count-win-and-loss-where-2-teams-play-each-other-from-the-fixture-list-nfl-example3
Sheet: Sheet1

 | Table 1 is ok |  |  |  |  |  |  |  | These columns will run to include the whole season
Table 1 |  | Wins | Loss | Home Win | Home Loss | Road Win | Road Loss
 |  |  |  |  |  |  |  |  | Week 3
 | Jacksonville | 2 | 1 | 0 | 1 | 2 | 0 |  | Jacksonville | 24 | 23 | Carolina
 | San Francisco | 2 | 1 | 1 | 1 | 1 | 0 |  | San Francisco | 28 | 7 | Cincinatti
 | New England | 3 | 0 | 1 | 0 | 2 | 0 |  | New England | 30 | 16 | Buffalo
 | Denver | 0 | 3 | 0 | 2 | 0 | 1 |  | Denver | 3 | 9 | Tennessee
 | Carolina | 2 | 1 | 0 | 1 | 2 | 0
 | Cincinatti | 0 | 3 | 0 | 2 | 0 | 1 |  | Week 12
 | Buffalo | 1 | 2 | 0 | 1 | 1 | 1 |  | Carolina | 20 | 10 | San Francisco
 | Tennessee | 2 | 1 | 2 | 0 | 0 | 1 |  | Jacksonville | 42 | 35 | Cincinatti
 |  |  |  |  |  |  |  |  | Buffalo | 19 | 22 | Tennessee
 |  |  |  |  |  |  |  |  | New England | 13 | 9 | Denver
 |  |  |  |  |  |  |  |  | Week 17
 |  |  |  |  |  |  |  |  | Carolina | 6 | 3 | Jacksonville
 |  |  |  |  |  |  |  |  | Cincinatti | 28 | 35 | San Francisco
 |  |  |  |  |  |  |  |  | Tennessee | 19 | 22 | New England
 |  |  |  |  |  |  |  |  | Buffalo | 13 | 9 | Denver
 | In table 2 I just want to pick out the wins and losses where Jacksonville and Carolina play each other
Table 2 | So table 2 should read like this
 | v's Carolina | Wins | Loss
 | Jacksonville | 1 | 1
Spreadsheet: 668447d1584828630-ascending-order-first-column-contains-blank-cells-and-second-column-does-not-ascending-order
Sheet: First solution if possibel

Fruit Mango | Mango |  |  | Fruit Mango
Car Toyota | Mango |  |  | Fruit Mango
Fruit Apple | Mango |  |  | Fruit Mango
 | Mango |  |  | Fruit Mango
 | Mango |  |  | Fruit Mango
 | Mango |  |  | Fruit Mango
 | Mango |  |  | Fruit Mango
 | Mango |  |  | Fruit Mango
 | Mango |  |  | Fruit Mango
 | Mango | Needed > |  | Fruit Mango
 | Mango | if partially matched, |  | Fruit Mango
 | Mango | then change text |  | Fruit Mango
 | Mango | I know it can be done |  | Fruit Mango
 | Mango | with Cntrl + H |  | Fruit Mango
 | Mango | But I have 100k colums |  | Fruit Mango
 | Mango | and do not want to |  | Fruit Mango
 | Mango | remove duplicates |  | Fruit Mango
 | Mango |  |  | Fruit Mango
 | Mango |  |  | Fruit Mango
 | Mango |  |  | Fruit Mango
 | Mango |  |  | Fruit Mango
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Toyota |  |  | Car toyota
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
 | Apple |  |  | Fruit Apple
Spreadsheet: 880318d1727951449-pull-data-from-a-sheet-using-2-different-pull-down-lists-basic-version
Sheet: B and C Capital list

 |  | Investment Fund
Index 1 | Index 2 | Index 3 | Index 4 | Index 5 | Index 6 | Index 7 | Index 8 | Index 9 | Index 10
Project Number 1 | Project Description 1 | Cost A 1 | Cost B 1 | Cost C 1 | Planned | Health & Safety | A | Engineer 1 | Comment 1
Project Number 2 | Project Description 2 | Cost A 2 | Cost B 2 | Cost C 2 | Committed | Legislation | B | Engineer 2 | Comment 2
Project Number 3 | Project Description 3 | Cost A 3 | Cost B 3 | Cost C 3 | Committed | Environmental | C | Engineer 3 | Comment 3
Project Number 4 | Project Description 4 | Cost A 4 | Cost B 4 | Cost C 4 | Committed | Production | C | Engineer 4 | Comment 4
Project Number 5 | Project Description 5 | Cost A 5 | Cost B 5 | Cost C 5 | Planned | Engineering | C | Engineer 5 | Comment 5
Project Number 6 | Project Description 6 | Cost A 6 | Cost B 6 | Cost C 6 | Planned | Innovation | C | Engineer 6 | Comment 6
Spreadsheet: 78275d1278663498-move-cell-values-using-excel-functions-sample-1-
Sheet: Sheet1

GROUP | VALUE | STATE
Spreadsheet: 754277d1636050371-add-a-cell-to-a-formula-nascondere
Sheet: Foglio1

 | 100
 |  |  |  |  |  | in G1 must be 100+10+50 = 160
gen | 10 | 20 |  | 50 |  |  | =IF(AND(B3=0,C3=0),"",SUM(B1,D3,E3))
feb | 0 | 0 |  | 85 |  |  | =IF(AND(D3=0; $B$1>0 ); SUM(B1;D3;E3); "")
[NAME] | 0 | 0
apr | 0 | 0
mag | 0 | 0
[NAME] | 0 | 0
lug | 0 | 0
ago | 0 | 0
set | 0 | 0
ott | 0 | 0
nov | 0 | 0
dic | 0 | 0
Spreadsheet: kevin_hyatt__19593__USGTEasttoEastUsage
Sheet: Sheet1

[NAME]
MTD USGT CONTRACT #27161
 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | 2001-01-01 00:00:00 | Total
SOCAL/NOM | 959391 | 666072 | 1050832 | 2001862 | 2109476 | 1434998 | 1579637 | 942892 | 1356286 | 1771273
SOCAL/SCHED | 66243 | 241764 | 113921 | 137405 | 180488 | 243210 | 318423 | 110757 | 512768 | 906089
MOJAVE/NOM | 0 | 60200 | 1204355 | 0 | 393577 | 256701 | 162907 | 90000 | 746667 | 191089
MOJAVE/SCHED | 0 | 60200 | 1102737 | 0 | 268921 | 217008 | 159574 | 26666 | 407606 | 130194
PG&E/NOM | 30000 | 71733 | 0 | 493114 | 596504 | 745686 | 615988 | 225860 | 123286 | 0
PG&E/SCHED | 30000 | 71733 | 0 | 374456 | 282470 | 417491 | 500298 | 58354 | 40749 | 0
TOTAL NOM
TOTAL SCHED
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: STAT

Old course number | New course number
STAT-361 | STAT-2700
STAT-362 | STAT-3700
STAT-468 | STAT-4720
STAT-520 | STAT-5520 and STAT-4219
STAT-520 | [NAME] and STAT-6219
STAT-611 | STAT-6110
STAT-810 | STAT-8400
STAT-820 | STAT-8820
STAT-860 | STAT-8260
Spreadsheet: 27925ad6-1e73-4858-8361-6f0365065c8d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | ICI Paints
 | Neutral Gray Tint Data
 | D65 | 10 Degrees
 |  |  |  | ICI Supplied RGB Values
 | Tint Name | Tint Code | R | G | B |  | X | Y | Z |  | L* | a* | b*
 | Snowfield | 00NN 72/000 | 196 | 191 | 200 |  | 67.58 | 71.41 | 77.07 |  | 87.68 | -0.3 | -0.3
 | [NAME] | 00NN 62/000 | 183 | 179 | 188 |  | 58.57 | 61.85 | 66.85 |  | 82.83 | -0.21 | -0.37
 | Veil | 00NN 53/000 | 168 | 164 | 171 |  | 48.84 | 51.52 | 55.43 |  | 76.99 | -0.02 | -0.11
 | [NAME] | 00NN 45/000 | 154 | 152 | 157 |  | 41.01 | 43.26 | 46.71 |  | 71.73 | -0.04 | -0.28
 | Granite Gray | 00NN 37/000 | 142 | 140 | 145 |  | 34.26 | 36.14 | 39.03 |  | 66.62 | -0.02 | -0.28
 |  |  |  |  |  |  |  |  |  |  |  |  | RGB Values Recalculated Using EasyRGB (D65, 10 Degrees)
 | Tint Name | Tint Code |  |  |  |  | R | G | B |  | R | G | B
 | Snowfield | 00NN 72/000 |  |  |  |  | 219 | 220 | 219 |  | 219 | 220 | 219
 | [NAME] | 00NN 62/000 |  |  |  |  | 206 | 206 | 205 |  | 205 | 206 | 205
 | Veil | 00NN 53/000 |  |  |  |  | 190 | 190 | 189 |  | 190 | 190 | 189
 | [NAME] | 00NN 45/000 |  |  |  |  | 175 | 176 | 175 |  | 175 | 176 | 175
 | Granite Gray | 00NN 37/000 |  |  |  |  | 162 | 162 | 161 |  | 162 | 162 | 161
 |  |  |  |  |  |  |  |  |  |  |  |  | RGB Values Recalculated Using Lindbloom CIE Calculator (D65, sRGB, [NAME])
 | Tint Name | Tint Code |  |  |  |  | R | G | B |  | R | G | B
 | Snowfield | 00NN 72/000 |  |  |  |  | 219 | 220 | 219 |  | 219 | 220 | 220
 | [NAME] | 00NN 62/000 |  |  |  |  | 206 | 206 | 205 |  | 205 | 206 | 207
 | Veil | 00NN 53/000 |  |  |  |  | 190 | 190 | 189 |  | 190 | 190 | 190
 | [NAME] | 00NN 45/000 |  |  |  |  | 175 | 176 | 175 |  | 175 | 176 | 176
 | Granite Gray | 00NN 37/000 |  |  |  |  | 162 | 162 | 161 |  | 162 | 162 | 162
Spreadsheet: 144918d1331211677-look-up-formulas-bedford-division-example-1-
Sheet: Low Bidder

Division 4 - Masonry
Low Bidder
Activity | Quantity | Unit | Labor Cost | Material Cost | Sub-Contract | Total Cost
Sub Total
Spreadsheet: 777360d1650352210-excel-subtract-value-from-number-each-day-of-the-month-loan-payment-schedule-aligw
Sheet: Sheet1

 | Payments | Loan | 2022-02-27 00:00:00
 | 500 | 6000
Spreadsheet: 761296d1640804261-sumif-using-multiple-sheet-references-1-stucco-remediation-bid-sheet
Sheet: Materials List

Job Name:
 | FASTENERS & TAPE
 | Siding Nails (box) - 3600 per box
 | [NAME] Staples
 | [NAME] (box) - 1125 per box
 | 4" G Tape
 | [NAME] ft. per roll
 | Hydro Gap
 | [NAME] 7"
 | [NAME] Shakes
 | Caulk - tube (Lap Siding Color)
 | Caulk - tube (Shake Siding Color)
 | Caulk - tube (Board & Batten Siding Color)
 | Caulk - tube (For PVC Trim - White)
 | Light Blocks
Spreadsheet: 754257d1636046285-return-dyn-spill-rng-using-criteria-based-stdev-p-func-sample-sheet-20211104
Sheet: Sheet1

 | MEAN |  |  | DYNAMIC SPILL RANGES
 | STDEV |  |  |  |  |  | IF SAMPLE (n) is 1 then $A$2, | example output values without the desired outcome of a spill range
[NAME] |  |  |  |  |  |  | Else STDEV.P([range if Table_3{Seg. No.) is equal to column E seg. no.])
OFF | Z | Seg. No. |  | Seg. No. | MEAN | SAMPLE (n) | STDEV | STDEV
0.1729943925233644
0.0939833770778653
0.1400423572744014
0.1555915492957747
0.05158362369337979
0.0447282608695652
0.02978628673196793
0.08376207199297626
0.07283319002579539
0.1927070707070708
0.1180487380330722
0.1155101143359718
-0.03206915887850463
-0.04442910101946242
-0.03003787878787876
0.0509730412805392
0.05786493288590605
-0.04140909090909095
0.132878729547642
0.1343963355834138
0.1330796890184647
Spreadsheet: 9cf63e17-d54b-4813-8669-24ad1a6db471
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | State Senate District 7 - Republican
2012-09-11 00:00:00 | Grimm, r | Youssef, r | Hosmer, d | [NAME]
Andover | 112 | 117 |  | 1
Belmont | 226 | 351
[NAME] | 159 | 132
Canterbury | 131 | 97 |  | 1
[NAME] | 172 | 82 | 5 | 2
[NAME] | 86 | 45 |  | 6
[NAME] | 128 | 89
Gilford | 455 | 608 | 6 | 1
[NAME] | 114 | 178 | 2
[NAME] | 72 | 145 | 1
[NAME] 3 | 123 | 173 | 1
[NAME] | 69 | 150 | 1
[NAME] | 44 | 105
[NAME] 6 | 142 | 196 | 12 | 1
Northfield | 199 | 157 | 1 | 1
Salisbury | 80 | 50
[NAME] | 110 | 77 | 1
Totals | 2422 | 2752 | 30 | 13
 | State Senate District 8 - Republican
 | Odell, r | Wallenstein, d | [NAME]
Acworth | 61 |  | 1
Antrim | 179
Bennington | 110 |  | 2
Bradford | 196
Croydon | 76 |  | 2
Deering | 168
Francestown | 165
Goshen | 76
Grantham | 222 |  | 1
Hillsborough | 346 |  | 2
Langdon | 56 |  | 1
Lempster | 92
Marlow | 77 | 1
New London | 536 | 1 | 2
Newbury | 240 |  | 2
Newport | 393 |  | 4
Springfield | 126
Stoddard | 125
Sunapee | 414 |  | 2
Sutton | 189 |  | 1
Unity | 103 |  | 1
Weare | 591
Windsor | 22
Washington | 102
Totals | 4665 | 2 | 21
Spreadsheet: 0901c355-d156-4006-a7a8-89311497ff88
Sheet: masked_gender

DIST_OF_RES_IRN | gender | read_result | math_result | sci_result
000176 | Female | NC | NC | NC
000476 | Female | 93.8 | 59.4 | 53.1
053702 | Female | 100 | 92.2 | 86.3
053983 | Female | NC | NC | NC
055749 | Female | NC | NC | NC
055814 | Female | 86.1 | 66.7 | 23.6
055822 | Female | 70.3 | 32.8 | 7.81
055855 | Female | NC | NC | NC
055913 | Female | 47.3 | 12.7 | 3.64
055947 | Female | 58.3 | 18.8 | 4.17
056010 | Female | 67.9 | 41.1 | 8.93
056036 | Female | 43.3 | 13.3 | 0
056051 | Female | 61.4 | 25 | 9.09
056069 | Female | 59.6 | 32.7 | 15.4
056127 | Female | 72.6 | 38.7 | 24.2
056143 | Female | 88.6 | 65.7 | 20
056192 | Female | 77.3 | 60.2 | 23.9
056242 | Female | 61.4 | 36.4 | 9.09
056267 | Female | 37.1 | 14.6 | 1.12
056275 | Female | 62.2 | 34.6 | 10.3
056283 | Female | 58.6 | 28.6 | 11.4
056309 | Female | 71.8 | 28.2 | 15.4
056358 | Female | 80.6 | 45.2 | 12.9
060343 | Female | 71.4 | 42.9 | 9.52
060384 | Female | 57.6 | 15.2 | 0
062562 | Female | 65.9 | 31.9 | 8.79
068189 | Female | NC | NC | NC
087809 | Female | 80 | 30 | 10
097683 | Female | NC | NC | NC
126607 | Female | 64.3 | 21.4 | 4.29
134478 | Female | NC | NC | NC
000476 | Male | 100 | 80 | 80
052662 | Male | 95 | 60 | 55
053983 | Male | NC | NC | NC
055749 | Male | NC | NC | NC
055814 | Male | 82.2 | 71.1 | 22.2
055822 | Male | 67.3 | 30.6 | 12.2
055913 | Male | 34.2 | 15.8 | 5.26
055947 | Male | 47.2 | 30.6 | 0
056010 | Male | 68.8 | 50 | 18.8
056036 | Male | 28.6 | 16.7 | 0
056051 | Male | 45.6 | 24.1 | 10.1
056069 | Male | 55.6 | 24.4 | 4.44
056127 | Male | 63.2 | 35.1 | 15.8
056143 | Male | 89.7 | 92.3 | 28.2
056192 | Male | 68.6 | 54.3 | 18.6
056242 | Male | 62.5 | 35 | 15
056267 | Male | 40 | 18.8 | 1.25
056275 | Male | 48.1 | 33.8 | 11.9
056283 | Male | 61.7 | 35 | 13.3
056309 | Male | 71.7 | 34 | 9.43
056358 | Male | 76.9 | 59 | 10.3
060343 | Male | 79.2 | 62.5 | 12.5
060384 | Male | 48.4 | 19.4 | 6.45
062562 | Male | 55.7 | 39.3 | 6.56
068189 | Male | NC | NC | NC
087809 | Male | NC | NC | NC
097683 | Male | NC | NC | NC
126607 | Male | 54.9 | 15.7 | 11.8
134478 | Male | NC | NC | NC
Spreadsheet: 796794d1663540298-average-formula-using-table-references-instead-of-ranges-with-unconventional-data-table-test-hd
Sheet: Collate

 |  |  | Section | Year | Something | Average
 |  |  | 1 | 2016-2017 |  |  |  | 2016-2017
 |  |  | 2 | 2017-2018 |  |  |  | 2017-2018
 |  |  | 3 | 2018-2019 |  |  |  | 2018-2019
 |  |  | 4 | 2019-2020 |  |  |  | 2019-2020
 |  |  | 5 | 2020-2021 |  |  |  | 2020-2021
 |  |  | 6 | 2021-2022 |  |  |  | 2021-2022
Spreadsheet: 223012d1363991997-creating-a-list-of-just-unique-values-cf-washout-answer-3
Sheet: Sheet1

Field 1 | Field 2
16 | 15 | 0
20 | 31 | 0
10 | 10 | 1
11 | 11 | 1
12 | 12 | 1
13 | 13 | 1
14 | 14 | 1
17 | 17 | 1
18 | 18 | 1
19 | 19 | 1
4 | 18 | 1
20 | 10 | 1
20 | 20 | 3
Spreadsheet: 8a72ac69-2854-42af-a1d8-2840f373e9fb
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Business Services | 1 | Improve Contract Process | None | -- Pick One -- | 1.1.r1 | Clerical Assistant I | OnGoing | 31000 | 40000 | 32000 | 40000 | 33500 | 40000 | 0 | 0
Business Services | 1 | Improve Contract Process | None | -- Pick One -- | 1.1.r2 | Association Membership | OnGoing | 200 | 50000 | 200 | 50000 | 200 | 50000 | 0 | 0
Business Services | 2 | Improve Requisition Process | None | -- Pick One -- | 1.2.r1 | Storekeeper I | OnGoing | 17500 | 25000 | 18300 | 25000 | 19250 | 25000 | 0 | 0
Business Services | 2 | Improve Requisition Process | None | -- Pick One -- | 1.2.r2 | Job-Specific Training | OnGoing | 1000 | 50000 | 1000 | 50000 | 1000 | 50000 | 0 | 0
Business Services | 2 | Improve Requisition Process | None | -- Pick One -- | 1.2.r3 | Association Membership | OnGoing | 500 | 50000 | 500 | 50000 | 500 | 50000 | 0 | 0
Business Services | 1 | Expand Information Resources | None | -- Pick One --
Business Services | 2 | Improve communications and customer service | None | -- Pick One -- | 2.2.r1 | Customer Service Training | OneTime | 2000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 872260d1718646433-dashboard-without-pivot-tables-only-formula-and-functions-dummy_data-sakram3ntum-
Sheet: progression

1. Settings
2. Tasks
3. Activity Tracker
 |  |  | [NAME]
5. [NAME] |  |  | Logged In Time
 |  |  | Advisor | P06W1 | P06W2 | P06W3 | P06W4 | P07W1 | P07W2 | P07W3 | P07W4 | P07W5 | P08W1 | P08W2 | P08W3 | P08W4 | P09W1
 |  |  | Aston Bran
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 118543d1313753977-help-with-moving-data-on-criteria-tlgltest
Sheet: New Deficiency list

Last Name | First Name | Occp | Dept | Team | Shift | BPD | [NAME] | Interview | Math | Written | Comments | Test Taken On:
Aguilar | [NAME] | T103 | 1701 | 1801 | 1 | 82 | 85 | 75 | 80 | 50 | 2,4,5,7,10 | 2010-11-08 00:00:00
Arriaga | [NAME] | T103 | 1102 | 1302 | 2 |  |  |  |  |  | benefits
Babler | [NAME] | T203 | 5001 | 1201 | 1 |  |  |  |  |  | committeeman
Spreadsheet: eric_saibi__9686__122001
Sheet: Watts Bar 01

Owner Name |  | Tennessee Valley Authority
Station Name |  | Watts Bar Nuclear Power Station
Unit Name |  | Watts Bar 01
NERC Region |  | SERC
State |  | TN
Fuel Type |  | Nuclear
Capacity |  | 1,270 MW
Start Date |  | 2001-12-20 00:00:00
End Date |  | 2001-12-21 00:00:00
Comments |  | Turbine pump problem.  Expected to be on line tomorrow, and be at full power in a couple of days.
SIC |  | 4911
Plant ID |  | 1000407
Unit ID |  | 1003708
Outage ID |  | 19260
Spreadsheet: 33125d1229424906-conditional-formatting-fill-colour-with-weekday-colour-fill-cells-with-dayname-colour
Sheet: Sheet1

The question |  |  |  |  |  |  | The solution
FirstName | Surname | Birthdate |  | WeekdayOrder | Colour |  | FirstName | Surname | Birthdate
Teddy | Bar | 1990-02-01 00:00:00 |  | 5 | Orange |  | Teddy | Bar | 1990-02-01 00:00:00
[NAME] | Lord | 1991-04-03 00:00:00 |  | 4 | Green |  | [NAME] | Lord | 1991-04-03 00:00:00
[NAME] | More | 1971-06-05 00:00:00 |  | 7 | Purple |  | [NAME] | More | 1971-06-05 00:00:00
[NAME] | Sander | 1988-10-11 00:00:00 |  | 3 | Pink (or [NAME]) |  | [NAME] | Sander | 1988-10-11 00:00:00
Balm | [NAME] | 1981-06-12 00:00:00 |  | 6 | [NAME] (Or Aqua) |  | Balm | [NAME] | 1981-06-12 00:00:00
June | Wern | 1985-04-01 00:00:00 |  | 2 | Yellow |  | June | Wern | 1985-04-01 00:00:00
[NAME] | Loo | 1971-11-28 00:00:00 |  | 1 | Red |  | [NAME] | Loo | 1971-11-28 00:00:00
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 15c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | 120 | 3149 | - | 3273
Index
Asia | - | 1925 | - | 1370
Europe | 107871 | 42737 | 57452 | 31518
North America | 106037 | 87021 | 47978 | 60062
Other | 1562 | 1882 | 572 | 1228
OTHER* | 10379 | 20056 | 4745 | 17470
TOTAL
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 142678d1329957181-find-exact-match-in-two-collumn-please-help-find-exact-match
Sheet: Sheet1

Item # | Quantity
0040-02098 | 1 |  | Item highlighted in yellow is current update of quatity needed, [NAME] in white is what I have on my order sheet.  I have to check line by line and compare to make correction on my order sheet when I am ready to submit.
0040-02098 | 2
0040-38957 | 1 |  | How do I find the exact duplicates and highlight the cell C in blue as seen here?  Your help is appreciated.
0040-38957 | 1
0040-38958 | 1
0040-38958 | 1
0040-84392 | 2
0040-84392 | 2
0041-00821 | 1
0041-00821 | 1
0041-14118 | 2
0041-14118 | 1
0051-02745 | 1
0051-02946 | 1
0051-02946 | 1
0051-03017 | 1
0051-03017 | 1
0051-03026 | 0
0051-03147 | 0
0051-03610 | 1
0051-03610 | 1
0051-03616 | 2
0051-03616 | 1
0051-03617 | 1
0051-03617 | 3
0051-03732 | 0
0051-03778 | 0
0051-04404 | 1
0051-04404 | 1
0051-05372 | 0
3860-00333 | 6
3860-00606 | 130
3860-00606 | 130
3860-00762 | 0
3860-01144 | 15
3860-01144 | 40
Spreadsheet: 73589d1274225927-excel-2007-help-with-formulas-to-reference-populated-cells-sample-sheet-2
Sheet: Sheet1

Date field 1 | 2010-05-21 00:00:00 |  |  |  |  |  |  | Amount field 1 | 10000
date field 2 |  |  |  |  |  |  |  | Amount field 2 | 0
1st day of period | 2010-05-14 00:00:00 |  |  |  |  |  |  | semi-monthly rate |  | I need to write this formula so that it picks up the value in either H1 or H3 (whichever one is populated at the time of entry)
last day of period | 2010-05-28 00:00:00 |  |  |  |  |  |  |  |  | =round(j1/24,2)
total days in period | 15
 | Days
Old Rate
New Rate |  | I need to write this formula so that it picks up the value in either B1 or B3 (whichever one is populated):  =b7-b1+1
Days employed in period