tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 6105d5e8-a906-4636-94d7-d83f361612e0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Request For New Agency Account
Name of Account
Purpose of Account (include description of organization and funding source)
Departmental/Student Contact |  |  |  |  |  | Faculty Contact
Name: |  |  |  |  |  | Name:
[NAME]: |  |  |  |  |  | [NAME]:
E-Mail: |  |  |  |  |  | E-Mail:
Box Number: |  |  |  |  |  | Box Number:
[NAME] (Request will not be processed otherwise)
Organizational/Departmental Representative |  |  |  |  |  | Faculty Contact
Student Senate Treasure (If Student Association Account) |  |  |  |  |  | Student Activities Representative (If student [NAME])
Business Office Use
Date Received |  |  |  |  |  | Account Number
Date Processed |  |  |  |  |  | Added by
Spreadsheet: 219264d1362694216-need-formula-to-sum-all-missing-items-in-concurrent-events-concurrenteventstotalmissing
Sheet: Sheet1

Event Open | Event Close | Missing | Concurrent Events | Concurrent Events Total Missing
2013/01/17 15:39:34 | 2013/01/18 01:25:45 | -43 |  | -43
2013/01/17 18:42:40 | 2013/01/18 01:26:17 | -13 |  | -56
2013/01/17 18:59:35 | 2013/01/18 01:27:08 | -4 |  | -60
2013/01/18 14:32:43 | 2013/01/18 14:47:46 | -6 |  | -6
2013/01/20 23:08:35 | 2013/01/21 01:54:47 | -8 |  | -8
2013/01/20 23:08:58 | 2013/01/21 01:54:47 | -5 |  | -13
2013/01/21 15:42:31 | 2013/01/22 04:11:34 | -44 |  | -44
2013/01/21 15:44:49 | 2013/01/22 04:15:42 | -14 |  | -58
2013/01/21 15:47:52 | 2013/01/22 04:11:41 | -44 |  | -102
2013/01/21 16:02:09 | 2013/01/22 04:15:35 | -16 |  | -118
2013/01/21 16:13:57 | 2013/01/22 04:11:48 | -34 |  | -152
2013/01/23 01:48:41 | 2013/01/23 09:58:02 | -37 |  | -37
2013/01/23 01:49:22 | 2013/01/23 10:09:59 | -37 |  | -74
2013/01/23 15:44:02 | 2013/01/23 17:41:48 | -7 |  | -7
2013/01/24 [NAME] | 2013/01/24 07:55:55 | -11 |  | -11
2013/01/24 06:45:49 | 2013/01/24 07:55:55 | -7 |  | -18
2013/01/24 14:37:13 | 2013/01/25 09:42:35 | -61 |  | -61
2013/01/24 14:38:08 | 2013/01/25 09:42:34 | -57 |  | -118
2013/01/24 15:06:56 | 2013/01/25 04:13:21 | -14 |  | -132
2013/01/25 08:03:47 | 2013/01/25 09:41:37 | -31 |  | -149
2013/01/25 08:23:30 | 2013/01/25 09:41:42 | -16 |  | -165
2013/01/25 08:50:33 | 2013/01/25 09:41:47 | -4 |  | -169
2013/01/28 [NAME] | 2013/01/28 14:24:48 | -32 |  | -32
2013/01/29 16:15:39 | 2013/01/29 19:27:19 | -17 |  | -17
2013/01/30 09:44:52 | 2013/02/04 19:00:17 | -180 |  | -180
2013/01/30 10:36:42 | 2013/02/04 19:00:27 | -171 |  | -351
2013/01/30 15:05:58 | 2013/01/31 07:01:34 | -21 |  | -372
2013/01/31 16:28:58 | 2013/02/04 13:10:55 | -130 |  | -481
2013/02/01 09:59:38 | 2013/02/01 11:39:35 | -8 |  | -489
2013/02/01 10:01:19 | 2013/02/01 11:39:35 | -3 |  | -492
2013/02/04 04:57:05 | 2013/02/04 12:57:15 | -18 |  | -499
2013/02/04 04:58:02 | 2013/02/04 12:57:29 | -18 |  | -517
2013/02/04 05:33:00 | 2013/02/04 12:57:22 | -15 |  | -532
2013/02/04 14:10:18 | 2013/02/04 19:00:36 | -9 |  | -360
2013/02/04 14:11:42 | 2013/02/04 19:00:47 | -11 |  | -371
Spreadsheet: 26283968-c366-4e62-8711-e165a5abdd3c
Sheet: Sheet1

Supplementary Table 5.  Primers used. | Unnamed: 1 | Unnamed: 2
Primer Name | Sequence (5'-3') | Description
M13_F | CGCCAGGGTTTTCCCAGTCACGAC | Amplify KanMX6 from pFA6
M13_R | AGCGGATAACAATTTCACACAGGA | Amplify KanMX6 from pFA6
GSP16 | GGAGAAGGGTCGTTTTGAGTA | Velvet node 5 forward
GSP17 | GGAAAAAAGGCGTATAGGTGC | Velvet node 5 forward
GSP18 | [NAME] | Velvet node 14 forward
GSP19 | TAGCGAATTTTCTAGAGGGGG | Velvet node 14 forward
GSP20 | CAAACTTGCCAAGAATGTTGTGT | Velvet node 17 forward
GSP21 | GCTCCACAAATTTGAATGTTAATGG | Velvet node 17 forward
GSP22 | TATCGAGCCTGGTGTTCCAA | Velvet node 22 forward
GSP23 | TGATTACTAATACGGTGAGAGACCC | Velvet node 22 forward
GSP24 | AAAGTGCGACCAACTCAAACT | Velvet node 23 forward
GSP25 | ATTTAACTTGGGGATAGGCCC | Velvet node 23 forward
GSP26 | CAATGGTGAAAGCCCTTCAA | Velvet node 37 forward
GSP27 | CTACAATCCGATAAACAAGTCTCAG | Velvet node 37 forward
GSP28 | TTTTGCTATCGAGCCTGGTGTT | Velvet node 40 forward
GSP29 | CAACATGTTTTTTGAACAGGAGA | Velvet node 40 forward
GSP30 | TTAGTGGGACCCCTAGATCAAGA | Velvet node 40 forward
GSP31 | GCATTTTGGAATGAGAGCCA | Velvet node 40 forward
GSP32 | TGGGCACAAGTTGTACCTTCCT | Velvet node 41 forward
GSP33 | TCATCTACGTCCTATGGCCATT | Velvet node 41 forward
GSP34 | ACACGTTTATCTGAGCTATTACCCC | Velvet node 70 forward
GSP35 | GGATATCGAGCTCTTCAGCA | Velvet node 70 forward
GSP36 | ATAAGAATGCGGCCGCCCTGTGCCCTACTTAAGATTTGC | XDH1 cloning forward, contains NotI site
GSP37 | ATAAGAATGCGGCCGCCAGGCGAATATCCTTGCATT | XDH1 cloning reverse, contains NotI site
GSP38 | CCTGTGCCCTACTTAAGATTTGC | xdh1Δ construction, 5' homology forward
GSP39 | GTCGTGACTGGGAAAACCCTGGCGAAGCTGTTATTTGCCCATCTG | xdh1Δ construction, 5' homology reverse, contains M13F sequence
[NAME] | TCCTGTGTGAAATTGTTATCCGCTGGCGATTAGTTTAGATGCTTGTATC | xdh1Δ construction, 3' homology forward, contains M13R sequence
GSP41 | TCAAAGCACAAATCTATGGGG | xdh1Δ construction, 3' homology reverse
GSP42 | CCAATCAAGCTAGGTAGGCAAT | xdh1Δ confirmation reverse, outside of 3' homology region
GSP43 | GATACAGTTCTCACATCAC | xdh1Δ confirmation forward, inside KanMX
GSP44 | ATGGCTCCAATCGAAAATCC | XDH1 colony PCR forward
GSP45 | TCAGGCCCAAAAATAATGGT | XDH1 colony PCR reverse
GSP46 | TGGTATGTTCTAGCGCTTGCA | [NAME] colony PCR control forward
GSP47 | TTGTGGTGAACGATAGATGGA | [NAME] colony PCR control reverse
GSP48 | AGAGATATAGTATAAGTGGAAAAAAGAAACATCAAACAATCAACAAGAAAAAATACTAAAAAAAAAAATTGAAAAATATGCGGATCCCCGGGTTAATTAA | sor1/2Δ construction forward
[NAME] | [NAME] | sor1/2Δ construction forward
GSP50 | GTGATGTGAGAACTGTATC | Deletion confirmation reverse, inside KanMX
[NAME] | GTTCATTGCCATAAGTTGC | sor1/2Δ confirmation forward
GSP52 | TCTTCAGCAAGCGACGCAGG | xks1Δ confirmation forward
GSP53 | ACGCATCACATGCCATTCG | xyl2Δ confirmation forward
GSP54 | TCCGTCGTGTCGATATGAG | yjr096wΔ confirmation forward
GSP55 | [NAME] | ypr1Δ confirmation forward
GSP56 | GTTGTCAGTGCAATCCTTCAAG | gre3Δ confirmation forward
GSP57 | CTTGATTCAGGATGAGAGC | gcy1Δ confirmation forward
GSP58 | CCACACCTAGGATCTCCTTTAC | ydl124wΔ confirmation forward
Spreadsheet: 138728d1327867272-count-based-on-criteria-0test
Sheet: Sheet1

 | Car Numbers | Lap Times |  | 2
 | 81 | 00:03:00
 | 24 | 00:02:00 |  | 2
 |  | 00:01:00
 | 81 |  | DNF
 | 26 | 00:01:00 |  | 2
 | 89 | 00:01:30
 | #NA | 00:03:00
 | 31 | 00:08:31
 | 81 | 00:08:00
 | Trying to get the count of how many times a certain car posts a time. As you can see, sometimes they get a DNF (did not finish)
 | So in the case above, I want a formula that will tell me how many times car number 81 posted a time
 | Ie, the Result would be two, even though he had three lap times, he only completed two.
Spreadsheet: phillip_allen__28891__second_lien
Sheet: Sheet1

Carry a second lien
Sales Price |  | 750000
1st [NAME] |  | 475000
2nd [NAME] |  | 200000
Cash Required
NOI |  | 115000
1st [NAME]
2nd [NAME] |  |  | 10%,20 year amort
Cash flow
Cash on Cash
Spreadsheet: fletcher_sturm__11025__VaR Template
Sheet: Rob

[NAME]
 |  |  | 95 | 99 | 10d-99
Portfolio #1
 |  |  | 1227650 | 1705103
Portfolio #2
 |  |  | 1248669 | 1794731 |  |  | Gas Shorts are driving risk
 |  |  | 1668736 | 2402134 |  |  | Gas alone w/o power
 |  |  |  |  |  |  | PJM-NG Corr: |  | 0.65
Portfolio #2a |  |  | 1019674 | 1393244 |  |  | With 2/3 of the original gas position
Portfolio #2b |  |  | 979064 | 1340217 |  |  | With 1/2 of the original gas position
Portfolio #3
 |  |  | 699183 | 1039045 |  |  | PJM-NY Zone A Corr: |  | 0.84
500 N-Q02 Cin
30K/d J-V02 NX |  |  |  | -1000000 | -800000
NG-R4 |  |  | 0.65 | 0.65 | 0.65
Combined
Spreadsheet: 144332d1330928889-macro-for-copy-paste-and-store-macro_help
Sheet: Sheet1

 | APPLE | GRAPES | BANANA | W.MELON | MANGO | PINEAPPLE | …
TOTAL SOLD | 25 |  | 35 | 40 |  | 10
TOM | 5 |  | 10 | 20 |  | 2
MARK | 15 |  | 10 | 10 |  | 3
[NAME] | 3 |  | 15 | 5 |  | 2
SUSAN | 2 |  | 0 | 5 |  | 3
STORED DATA
TOM | 5 |  | 10 | 20 |  | 2
MARK | 15 |  | 10 | 10 |  | 3
[NAME] | 3 |  | 15 | 5 |  | 2
SUSAN | 2 |  | 0 | 5 |  | 3
Spreadsheet: 105451d1302794012-build-a-consolidation-list-from-array-abc
Sheet: DATA

 |  | 2011-04-09 00:00:00 | 2011-04-10 00:00:00 | 2011-04-11 00:00:00 | 2011-04-12 00:00:00 | 2011-04-13 00:00:00 | 2011-04-14 00:00:00 | 2011-04-15 00:00:00 | 2011-04-16 00:00:00 | 2011-04-17 00:00:00 | 2011-04-18 00:00:00 | 2011-04-19 00:00:00 | 2011-04-20 00:00:00
 | PRODUCT 1 |  | 6
 | PRODUCT 2 |  |  |  |  |  |  |  |  | 9
 | PRODUCT 3
 | PRODUCT 4 |  |  |  |  |  |  |  |  | 5 |  | 76
8 | PRODUCT 5 |  |  |  | 2 |  | 24
 | PRODUCT 6 |  | 4
 | PRODUCT 7
11 | PRODUCT 8 |  |  |  |  | 8 | 36 |  |  | 9
 | PRODUCT 9 |  | 3 |  |  |  |  |  |  |  | 6
 | PRODUCT 10 | 2 |  |  | 45 |  |  | 2
 | PRODUCT 11
 | PRODUCT 12
 | PRODUCT 13 |  |  |  | 4
17 | PRODUCT 14 |  |  |  |  |  | 9 |  | 8
18 | PRODUCT 15 |  |  |  |  |  | 5 |  |  | 5
 | PRODUCT 16
20 | PRODUCT 17 |  |  |  |  |  | 6
 | PRODUCT 18 |  | 2 |  |  | 5
 | PRODUCT 19 |  |  |  |  |  |  |  |  |  | 5
 | PRODUCT 20 | 3 |  |  |  |  |  |  | 3
 | PRODUCT 21
25 | PRODUCT 22 |  |  | 4 |  |  | 4
 | PRODUCT 23 |  |  |  |  | 32
 | PRODUCT 24
28 | PRODUCT 25 |  |  |  |  |  | 6
 | PRODUCT 26
Spreadsheet: 680031d1590753900-sum-values-based-upto-a-given-date-formula-to-sum-upto-a-referenced-date
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Date : | 2020-06-07 00:00:00
 | Item | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Total Upto
 | aaaa | 12 | 34 | 5 | 6 | 89 | 25 | 70 | 18 | 24 | 56 | 34
Spreadsheet: mark_taylor__24701__epgofferanalysis (11-21-00)
Sheet: Contingent

El Paso Offer Analysis
Annual Proposal
Payment Dates |  |  |  | 2000-12-31 00:00:00 | 2001-11-15 00:00:00 | 2002-02-15 00:00:00 | 2002-05-15 00:00:00 | 2002-08-15 00:00:00 | 2002-11-15 00:00:00 | 2003-02-15 00:00:00 | 2003-05-15 00:00:00 | 2003-08-15 00:00:00 | 2003-11-15 00:00:00 | 2004-02-15 00:00:00 | 2004-05-15 00:00:00 | 2004-08-15 00:00:00 | 2004-11-15 00:00:00 | 2005-02-15 00:00:00 | 2005-05-15 00:00:00 | 2005-08-15 00:00:00 | 2005-11-15 00:00:00 | 2006-02-15 00:00:00 | 2006-05-15 00:00:00 | 2006-08-15 00:00:00 | 2006-11-15 00:00:00 | 2007-02-15 00:00:00 | 2007-05-15 00:00:00 | 2007-08-15 00:00:00 | 2007-11-15 00:00:00 | 2008-02-15 00:00:00 | 2008-05-15 00:00:00 | 2008-08-15 00:00:00 | 2008-11-15 00:00:00 | 2009-02-15 00:00:00 | 2009-05-15 00:00:00 | 2009-08-15 00:00:00 | 2009-11-15 00:00:00 | 2010-02-15 00:00:00 | 2010-05-15 00:00:00 | 2010-08-15 00:00:00 | 2010-11-15 00:00:00 | 2011-02-15 00:00:00 | 2011-05-15 00:00:00 | 2011-08-15 00:00:00 | 2011-11-15 00:00:00 | 2012-02-15 00:00:00 | 2012-05-15 00:00:00 | 2012-08-15 00:00:00 | 2012-11-15 00:00:00 | 2013-02-15 00:00:00 | 2013-05-15 00:00:00 | 2013-08-15 00:00:00
Deferred Payments |  |  |  | 0 | 41927.13864291751
 | Payment Escalator |  |  | 0.05
 |  |  |  |  |  | 2000-09-25 00:00:00
 | PV |  |  |  |  | 162292
 |  |  |  | 377805 |  | 153637
Scheduled Payments |  |  |  | 0 | 0 | 0 | 0
 | PV |  |  |  |  | 14685
 |  |  |  |  |  | 14441
New Contingent Payment Dates |  |  |  |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 |  | 2013-12-31 00:00:00
Available Restructuring MW's
 | Linden |  |  |  | 678 | 678 | 678 | 678 | 678 | 678 | 678 | 678 | 678 | 678 | 678 | 678
 | Bayonne |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Camden |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total
Restructuring Payment $/kw
 | Payment Escalator |  |  |  |  | 0.12 | 0.12 | 0.12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
New Contingent Payments |  |  |  | 0
 | PV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Offer Value
Probability
Probablilty Adjusted
9/25/2000 |  |  | 0.0825 | 206616
 |  |  | 0.0925 | 197718
Exercie Price Computation |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Implied Exercise Price Immediately
 | Following Payment |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 838521d1691089463-formula-that-capture-proportion-in-month-sample_benefit
Sheet: Values

HealthFirst
2023 Scorecard Realization
Property of Impact Advisors ©2023
Pay Period End Date | Value. | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00
2023-03-11 00:00:00 | 296389.148987563
2023-03-25 00:00:00 | 357574.6908805788
2023-04-08 00:00:00 | 434309.5884562506
2023-04-22 00:00:00 | 499630.3851183052
2023-05-06 00:00:00 | 451390.3556327077
2023-05-20 00:00:00 | 555372.5416376019
2023-06-03 00:00:00 | 497078.0948986675
2023-06-17 00:00:00 | 521576.6559827184
2023-07-01 00:00:00 | 544892.9764539846
2023-07-15 00:00:00 | 694229.204299228
2023-07-29 00:00:00 | 433334.7414073994
2023-08-12 00:00:00 | 533157.6399720978
2023-08-26 00:00:00 | 477194.9711027208
2023-09-09 00:00:00 | 500713.5897434097
2023-09-23 00:00:00 | 523097.2573958252
2023-10-07 00:00:00 | 666460.0361272589
Spreadsheet: kate_symes__18319__04-04
Sheet: Sheet1

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | SELL PRICE
2001-04-04 00:00:00 |  |  | 11 |  |  | SP15 | EES | 5 |  |  | 155 | SOLD
2001-04-04 00:00:00 |  |  | 12 |  |  | SP15 | EES | 5 |  |  | 155 | SOLD
2001-04-04 00:00:00 |  |  | 13 |  |  | SP15 | EES | 5 |  |  | 155 | SOLD
2001-04-04 00:00:00 |  |  | 14 |  |  | SP15 | EES | 4 |  |  | 155 | SOLD
2001-04-04 00:00:00 |  |  | 15 |  |  | SP15 | EES | 4 |  |  | 155 | SOLD
2001-04-04 00:00:00 |  |  | 16 |  |  | SP15 | EES | 4 |  |  | 155 | SOLD
2001-04-04 00:00:00 |  |  | 17 |  |  | SP15 | EES | 5 |  |  | 155 | SOLD
Spreadsheet: 59ba6ab2-7382-4a65-82d1-72546e368b59
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
260966 | 50531 | Moises | Osuna | ESP |  | 00:36:31 | 00:07:09 | 03:08:25 | 00:01:39 | 01:50:43 | 1 | 05:44:27
260966 | 56085 | Evangelos | Barlas | GRE |  | 01:00:24 | 00:10:52 | [NAME] | 00:01:58 | 02:27:46 | 2 | 07:13:36
Spreadsheet: 162684d1340032007-excel-formulas-seem-to-stop-working-at-a-certain-range-camp-sign-up-spreadsheet-test
Sheet: Camp Birch Week 

 | Name | Age | Emergency Contact | Phone Number
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 3e130cea-42da-40b0-90ed-a2db36b917b2
Sheet: Nitrats. Font AGUAS VALENCIA

2013-10-08 00:00:00 | 54
2013-09-18 00:00:00 | 57
2013-09-11 00:00:00 | 49
2013-09-11 00:00:00 | 55
2013-08-14 00:00:00 | 58
2013-07-17 00:00:00 | 59
2013-07-10 00:00:00 | 57
2013-06-12 00:00:00 | 56
2013-05-24 00:00:00 | 57
2013-05-15 00:00:00 | 56
2013-04-10 00:00:00 | 62
2013-03-27 00:00:00 | 58
2013-03-21 00:00:00 | 62
2013-03-13 00:00:00 | 66
2013-02-12 00:00:00 | 67
2013-01-15 00:00:00 | 65
2013-01-08 00:00:00 | 54
2012-12-11 00:00:00 | 54
2012-11-20 00:00:00 | 52
2012-11-12 00:00:00 | 59
2012-10-17 00:00:00 | 56
2012-09-17 00:00:00 | 70
2012-09-10 00:00:00 | 56
2012-08-14 00:00:00 | 62
2012-08-14 00:00:00 | 58
2012-07-17 00:00:00 | 58
2012-07-10 00:00:00 | 57
2012-06-12 00:00:00 | 56
2012-05-22 00:00:00 | 66
2012-05-15 00:00:00 | 55
2012-04-11 00:00:00 | 64
2012-04-11 00:00:00 | 60
2012-03-21 00:00:00 | 64
2012-03-11 00:00:00 | 61
2012-02-15 00:00:00 | 60
2012-01-16 00:00:00 | 62
2012-01-09 00:00:00 | 61
2011-12-13 00:00:00 | 58
2011-10-10 00:00:00 | 61
2011-09-20 00:00:00 | 60
2011-09-13 00:00:00 | 62
2011-08-10 00:00:00 | 57
2011-07-12 00:00:00 | 61
2011-07-11 00:00:00 | 57
2011-06-14 00:00:00 | 56
2011-05-17 00:00:00 | 70
2011-05-10 00:00:00 | 62
2011-04-12 00:00:00 | 64
2011-04-10 00:00:00 | 62
2011-04-05 00:00:00 | 68
2011-03-21 00:00:00 | 64
2011-03-14 00:00:00 | 61
2011-02-14 00:00:00 | 62
2011-02-14 00:00:00 | 63
2011-01-17 00:00:00 | 66
2011-01-10 00:00:00 | 64
Spreadsheet: 692884d1598620413-averageif-function-correct-for-what-i-want-book6-1
Sheet: Categories

[NAME] | WK | 0 | n/a | 1
Beaumont | Slip | 1 | 1 | 0
Fackrell | Short third | -1 | 0 | Dolly
Freeborn | Third | 2 |  | [NAME]
[NAME] | Point | -2 |  | [NAME]
Graves | Deep point | 3 |  | Drop Dolly
Harmer | Cover | -3 |  | [NAME]
[NAME] | Deep cover | 4 |  | Drop Dolly
Kbryce | Extra | -4 |  | Run Out
Kellogg | Mid off | 5 |  | Close - Run Out Chance
[NAME] | Long off | -5 |  | Miss - Run Out Chance
Pai | Mid on |  |  | Game Changer
Presland | Long on |  |  | Key point
[NAME] | Cow
Sims | Mid-wicket
 | [NAME]-wicket
 | Square leg
 | Deep square leg
 | Short fine
 | Short fine leg
Spreadsheet: 792174d1660760698-use-the-results-from-one-formula-to-find-the-answer-on-a-different-sheet-examplefile-08-17
Sheet: Adds

VIN | Account Number | Customer Equipment ID | Device | Equipment Travel Type | Vehicle Reference Number | Declared Weight | IFTA | IRP | Expiration Date | Make Year | Make | Plate Number | State | Country
Spreadsheet: 684088d1593137015-help-with-transforming-a-string-into-date-time-format-sampleworkbook
Sheet: H052027A_2011to2014

Tide DT | Reading
10120110000 | 1.329
10120110010 | 1.324
10120110020 | 1.322
10120110030 | 1.334
10120110040 | 1.35
10120110050 | 1.38
10120110100 | 1.414
10120110110 | 1.455
10120110120 | 1.504
10120110130 | 1.563
10120110140 | 1.631
10120110150 | 1.708
10120110200 | 1.795
10120110210 | 1.886
161120141600 | 1.153
161120141610 | 1.29
161120141620 | 1.425
161120141630 | 1.562
161120141640 | 1.699
161120141650 | 1.833
161120141700 | 1.954
161120141710 | 2.082
161120141720 | 2.208
161120141730 | 2.328
161120141740 | 2.447
161120141750 | 2.567
161120141800 | 2.69
Spreadsheet: 178491d1346809488-need-help-with-a-formula-to-exclude-test
Sheet: Sheet1

a | b | c | a | b | c | a | b | c | a | b | c | a | b | c | a | b | c | a | b | c | a | b | c | a | b | c | a | b | c | a | AF | c | a | b | AJ | a | b | c | AN | b | c | a | AR | c | a | b | AV | a | b | c | AZ | b | c | a | G | BE | I | J | BH | L | M | BK | P | Q | BN | S | T | BQ | V | W | BT | W | Z
0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 198202d1354705465-i-need-help-ugent-how-can-i-connect-one-number-to-an-entire-row-excel-help
Sheet: Hoja1

 |  | This number below in blue would be the main number, when I cange this one, all number below automatically changes. As well with the 30.000..
[NAME] | 30000 | 500 | Total
1 | 15.000 + 30.000
2 | 30000
3 | 30000
4 | 30000
5 | 30000
6 | 30000
7 | 30000
8 | 30000
9 | 30000
10 | 30000 - 15000
Spreadsheet: 146590d1332264139-totals-for-components-in-a-table-dummy-chart
Sheet: Sheet2

Total Required | Part | Component | #of Component in part
40 | bolt
40 | nut
80 | washer
24 | z-clip
24 | screw
40 | plate
12 | board
20 | link plate | bolt | 2
 |  | nut | 2
 |  | washer | 4
 |  | plate | 2
2 | plank assembly | link plate | 8
 |  | board | 4
1 | table top | plank assembly | 2
 |  | link plate | 4
 |  | z-clip | 8
 |  | screw | 8
4 | table leaf | board | 1
 |  | z-clip | 4
 |  | screw | 4
1 | table | table top | 1
 |  | table leaf | 4
Spreadsheet: 854257d1704204655-adding-blank-columns-demo-data-1-
Sheet: Sheet3

 | 2 | 3 | 4 |  |  |  |  | 18P | sa | 17S | 11CL
 |  | 75 | The American Insurance Company Limited. |  |  |  |  | 41 |  | 52000 | 300000
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  |  |  |  | 25 |  | 30000
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd |  |  |  |  | 325.3 |  | 0 | 0
 | 7 | 9 | [NAME] ([NAME] (Main)) |  |  |  |  | 4000 |  | 45500 | 600000
 | 8 |  | Myselfi & Associates Trading Pvt.Ltd |  |  |  |  | 11000 |  | 900 | 20000
 |  |  | [NAME].Ltd. |  |  |  |  | 105300 |  | 80900
 |  |  | Agraj Foods Pvt.Ltd,Kathmandu |  |  |  |  | 75430.4 |  | 354000
 |  |  | Alive Pharmaceutical Pvt. Ltd.,Nrt |  |  |  |  | 98430.6 |  | 46005
 |  |  | Nirvana Plastic Corp |  |  |  |  | 190000 |  | 0
 |  | 75 | The American Insurance Company Limited. |  |  |  |  | 41 |  | 52000 | 300000
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  |  |  |  | 25 |  | 30000
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd |  |  |  |  | 325.3 |  | 0 | 0
 | 7 | 9 | [NAME] ([NAME] (Main)) |  |  |  |  | 4000 |  | 45500 | 600000
 | 8 |  | Myselfi & Associates Trading Pvt.Ltd |  |  |  |  | 11000 |  | 900 | 20000
 |  |  | [NAME].Ltd. |  |  |  |  | 105300 |  | 80900
 |  |  | Agraj Foods Pvt.Ltd,Kathmandu |  |  |  |  | 75430.4 |  | 354000
 |  |  | Alive Pharmaceutical Pvt. Ltd.,Nrt |  |  |  |  | 98430.6 |  | 46005
 |  |  | Nirvana Plastic Corp |  |  |  |  | 190000 |  | 0
Spreadsheet: 838053d1690649412-shorten-formula-using-array-approach-example
Sheet: Example

Value of each project | 10000 |  |  | checks
Pattern for spreading  values
Time point from start (month) |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Return percentage |  | 0.08 | 0.08 | 0.08 | 0.08 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.05 | 0.05 | 0.1 | 0.1 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.05 | 0.03
Calendar
Offset |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7
Calendar month |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
Projects starting by cal. month |  | 1 | 2 | 1 | 3 | 0 | 0 | 0 | 0 |  |  | projects
Total value of projects |  |  |  |  |  |  |  |  |  |  |  | total value
 | Calendar month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
Projects starting in cal. month | Total value
1
2
3
4
Spreadsheet: 806363d1669256991-help-with-formula-test-workbook
Sheet: Caribbean Worksheet

CARIBBEAN WORKSHEET
Date | 2023-12-30 00:00:00
Ship
Departure Port
# Nights
Ports of Call
B5 | Date is Entered here
B6 | Populate a Drop Down Menu that may contain multiple options if there are ships that depart on the same sail date
B7 | Would Populate Departure Port based on sail date and Ship
B8 | Would Populate Departure Port based on sail date and Ship
B9 | Would Populate Departure Port based on sail date and Ship
Spreadsheet: joe_parks__14753__ITM 03 Positions
Sheet: Financial Book Position

TIME BUCKET/KEY: |  |  | REPORT REGION | RISK TYPE | 1 |  | 2 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22
(Positions in Cont. [NAME].)     From: | Post ID |  |  |  | 2002-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ECT
To: | Order |  |  |  | 2002-12-01 00:00:00 |  | Index
Int-the-money Live Financial 2003
Physical | NG-Price Exotics |  | NGEXOTIC | P |  |  | 0
Index | 2 |  | NGHEDGE | P | 0
Gas Daily |  |  |  |  | 0
Gas Daily Index |  |  |  |  |  |  | 0
Basis - Notional | 3 |  | NGLTX | P | 0
Basis - Equivalent | 4 |  | NGFPL | P | 0
Price | 5 |  | NGFPL | D | 0
TOTAL:
Basis Roll-off
Spreadsheet: 743362d1628442602-copying-rows-on-one-sheet-to-another-sheet-based-on-criteria-from-one-column-testjackpot
Sheet: Times ROUND 2

Team # | INC Team | Header | Heeler | Round 1 | Helper Column | Round 2 |  | Total on 2
 |  |  |  |  |  | 3.9
 |  |  |  |  |  | 100
 |  |  |  |  |  | 6.1
 |  |  |  |  |  | 6.8
 |  |  |  |  |  | 5.2
 |  |  |  |  |  | 100
 |  |  |  |  |  | 100
 |  |  |  |  |  | 6.7
 |  |  |  |  |  | 9
 |  |  |  |  |  | 7.2
 |  |  |  |  |  | 13.8
 |  |  |  |  |  | 5.7
 |  |  |  |  |  | 6.4
 |  |  |  |  |  | 3.9
 |  |  |  |  |  | 5.7
 |  |  |  |  |  | 100
 |  |  |  |  |  | 6.5
 |  |  |  |  |  | 7.1
 |  |  |  |  |  | 6.4
 |  |  |  |  |  | 100
 |  |  |  |  |  | 7.6
 |  |  |  |  |  | 5.9
 |  |  |  |  |  | 4.9
 |  |  |  |  |  | 5.8