tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 861515d1709396023-vlookup-fomula-is-not-working-vlookup-formula-error
Sheet: Vlookup

Opening Date | LC Number | LC Value(Foreign) | Status | Debit |  |  | Vlopkup [NAME] | Index and [NAME]
2023-10-19 00:00:00 | [PHONE] | 188394.1146 | Pending | 22510248.8668
2023-10-19 00:00:00 | [PHONE] | 261806.0508 | Pending | 31447486.44
2023-10-17 00:00:00 | [PHONE] | 118660.4099 | Complete | 15080238.49815
2023-10-03 00:00:00 | [PHONE] | 219045.9972 | Pending | 17425074.9975
2023-10-08 00:00:00 | [PHONE] | 330851.8079 | Pending | 39500870.97480001
2023-10-03 00:00:00 | [PHONE] | 293684.4369 | Pending | 29704335.08815 |  | LC Number | Status | Status
2023-08-08 00:00:00 | [PHONE] | 877932.62 | Complete | 107360555.6854 |  | [PHONE]
2023-10-02 00:00:00 | [PHONE] | 153649.8248 | Pending | 18406506.0596 |  | [PHONE]
2023-09-12 00:00:00 | [PHONE] | 172351.1347 | Complete | 20535716.0962 |  | [PHONE]
2023-08-31 00:00:00 | [PHONE] | 142897.172 | Complete | 17138279.366 |  | [PHONE]
2023-08-29 00:00:00 | [PHONE] | 121683.56 | Pending | 14656296.99 |  | [PHONE]
2023-08-20 00:00:00 | [PHONE] | 289990.8 | Pending | 33544706.17000001
2023-08-22 00:00:00 | [PHONE] | 278487.566 | Complete | 32455876.769
2023-09-21 00:00:00 | [PHONE] | 245786.0019 | Pending | 118983.35
2023-09-10 00:00:00 | [PHONE] | 216520.112 | Complete | 25768595.3925
2023-08-22 00:00:00 | [PHONE] | 285458.37 | In Progress | 32808115.065
2023-09-10 00:00:00 | [PHONE] | 400122.3147 | In Progress | 47901696.41903
2023-09-05 00:00:00 | [PHONE] | 215727.188 | Pending | 25812693.0034
2023-10-08 00:00:00 | [PHONE] | 689509.92 | Pending | 82859851.935
2023-07-08 00:00:00 | [PHONE] | 616371.24 | Pending | 74548396.54600003
2023-07-25 00:00:00 | [PHONE] | 200316.08 | In Progress | 23918161.114
2023-07-12 00:00:00 | [PHONE] | 547562.92 | Complete | 66404524.67
2023-07-10 00:00:00 | [PHONE] | 196296.3807 | In Progress | 23484553.48769999
Spreadsheet: 841784d1693936671-same-name-with-different-values-and-sum-of-them-sample
Sheet: Sheet1

 |  |  |  |  |  | The Result should be Like
 | Date | Company | Quantity |  |  | Date | Company | Quantity
 | 2023-08-05 00:00:00 | ABC LTD | 3000 |  |  | 2023-08-05 00:00:00 | ABC LTD
 | 2023-08-05 00:00:00 | ABC LTD | 92109 |  |  | 2023-08-05 00:00:00 | EFG LTD
 | 2023-08-05 00:00:00 | ABC LTD | 250000 |  |  | 2023-08-05 00:00:00 | JKL LTD
 | 2023-08-05 00:00:00 | ABC LTD
 | 2023-08-05 00:00:00 | ABC LTD
 | 2023-08-05 00:00:00 | ABC LTD
 | 2023-08-05 00:00:00 | EFG LTD | 5000
 | 2023-08-05 00:00:00 | EFG LTD | -3000
 | 2023-08-05 00:00:00 | EFG LTD | 7000
 | 2023-08-05 00:00:00 | JKL LTD | -9000
 | 2023-08-05 00:00:00 | JKL LTD | 10000
 | 2023-08-05 00:00:00 | JKL LTD | 5000
Spreadsheet: 103453d1301186502-multiplying-letters-and-numbers-another-way
Sheet: Sheet1

[NAME] | Compound Participation |  | Reaction Formula
carbon monoxide | 0 |  | -1*glucose + 1*acetone + 2*ethanol + 2*carbon dioxide
hydrogen | 0 |  | -1*glucose +
formic acid | 0 |  | 1*acetone +
acetic acid | 0 |  | 2*ethanol +
propanoic acid | 0 |  | 2*carbon dioxide
acetone | 1 | 6.194690265486726
formaldehyde | 0
acetaldehyde | 0
oxaldehyde | 0
glycol aldehyde | 0
acetal | 0
cellulose acetate | 0
cellobiose | 0
fructose | 0
glucose | -1 | -14.15929203539823
furfurol | 0
[NAME] (5-Hydroxymethyl-2-furaldehyde) | 0
furan-2-carbaldehyde | 0
phenol | 0
isoeugenol | 0
eugenol | 0
cresol | 0
xylose | 0
furfural | 0
furfuryl alcohol | 0
methyl furan | 0
tetrahydrofurfural | 0
levulinic acid | 0
[NAME] | 0
gamma valerolactone | 0
1,3-pentanediol | 0
1-pentanol | 0
2-pentanol | 0
methanol | 0
methane | 0
ethane | 0
propane | 0
n-butane | 0
n-octane | 0
[NAME] | 0
propene | 0
but-1-ene | 0
but-2-ene | 0
benzene | 0
toluene | 0
p-xylene | 0
m-xylene | 0
o-xylene | 0
o-cresol | 0
p-cresol | 0
m-cresol | 0
indane | 0
tetralin | 0
n-nonane | 0
n-decane | 0
n-undecane | 0
n-dodecane | 0
n-tridecane | 0
2-methyltetrahydrofuan | 0
ethanol | 2 | 107.9646017699115
n-pentane | 0
n-hexane | 0
carbon dioxide | 2 | 113.2743362831858
water | 0
glycerol | 0
[NAME] | 0
Wood | 0
BioOil | 0
[NAME] | 0
Pyrolysis Gas | 0
cellulose | 0
hemicellulose | 0
lignin | 0
biomass(woody) | 0
coumaryl alcohol | 0
coniferyl alcohol | 0
sinapyl alcohol | 0
[NAME]-phenylpentanoate | 0
1-Hexene | 0
Propan-1-ol | 0
n-Butanol | 0
CycloHexane | 0
[NAME] | 0
Parrafin | 0
MTBE (tert-Butyl methyl ether ) | 0
Spreadsheet: john_arnold__15192__Book33
Sheet: Sheet1

2000-11-01 00:00:00 |  | 5.23
2000-12-01 00:00:00 |  | 5.33
2001-01-01 00:00:00 |  | 5.29
2001-02-01 00:00:00 |  | 5.07
2001-03-01 00:00:00 |  | 4.82
2001-04-01 00:00:00 |  | 4.57
2001-05-01 00:00:00 |  | 4.49
2001-06-01 00:00:00 |  | 4.47
2001-07-01 00:00:00 |  | 4.47
2001-08-01 00:00:00 |  | 4.47
2001-09-01 00:00:00 |  | 4.46
2001-10-01 00:00:00 |  | 4.46
2001-11-01 00:00:00 |  | 4.57
2001-12-01 00:00:00 |  | 4.68
2002-01-01 00:00:00 |  | 4.66
2002-02-01 00:00:00 |  | 4.46
2002-03-01 00:00:00 |  | 4.26
2002-04-01 00:00:00 |  | 4.05
2002-05-01 00:00:00 |  | 3.98
2002-06-01 00:00:00 |  | 3.97
2002-07-01 00:00:00 |  | 3.98
2002-08-01 00:00:00 |  | 3.99
2002-09-01 00:00:00 |  | 3.99
2002-10-01 00:00:00 |  | 4
2002-11-01 00:00:00 |  | 4.1
2002-12-01 00:00:00 |  | 4.2
2003-01-01 00:00:00 |  | 4.2
2003-02-01 00:00:00 |  | 4.02
2003-03-01 00:00:00 |  | 3.84
2003-04-01 00:00:00 |  | 3.65
Spreadsheet: 50955d1250542331-conditional-large-formula-salesroup-20large-1-
Sheet: Sheet1

Sales | Group |  | 30 | [NAME] | Maximum sale
100 | 25 |  |  | 145 | 145
200 | 25 |  |  | 145
200 | 17
100 | 16
150 | 25
125 | 30
145 | 30
Spreadsheet: 781311d1653210760-help-with-determining-the-right-formula-to-use-sample-worksheet-bar-tab
Sheet: Data Validation 

Happy Hour |  | Method of Payment |  | Guest/Room
Yes |  | [NAME] |  | Room 2
No |  | Cash |  | Room 3
 |  | [NAME] |  | Room 4
 |  |  |  | Room 5
 |  |  |  | Room 6
 |  |  |  | Room 7
 |  |  |  | Room 8
 |  |  |  | Room 9
 |  |  |  | Room 10
 |  |  |  | Room 11
 |  |  |  | Outside Guest 1
 |  |  |  | Outside Guest 2
 |  |  |  | Outside Guest 3
 |  |  |  | Outside Guest 4
 |  |  |  | Outside Guest 5
 |  |  |  | Table 1
 |  |  |  | Table 2
 |  |  |  | Table 3
 |  |  |  | Table 4
Spreadsheet: 292755d1390773505-trying-to-create-a-functional-spreadsheet-overhead-map-for-trailer-yard-excelforumtrailerinventory-2014-01-26-16-57
Sheet: List

Unit# | Vin# | Insp Date | Row | Errors | Comments
123456 | 1PNV01PT432123432 | 2012-01-13 00:00:00 | B |  | light issues
321098 | 1GRAA0622WL765432 | 2013-02-12 00:00:00 | A |  | damage to LF corner
654321 | 1GRAA0622WL654321 | 2013-03-13 00:00:00 | N/A | M | MISSING (not on map)
765432 | 1JJV532WL12345678 | 2013-04-13 00:00:00 | A |  | door damage
987654 | 1GRAA0622WL123456 | 2013-05-13 00:00:00 | C
6543210 | N/A |  | B | A | ADDITIONAL (not in unit# list)
A11111 | 1JJV532WL98765432 | 2014-01-01 00:00:00 | C |  | Row 7 on Sheet 'Data'
765432 | 1JJV532WL12345678 | 2013-04-13 00:00:00 | A
321098 | 1GRAA0622WL765432 | 2013-02-12 00:00:00 | A |  | damage to LF corner
765432 | 1JJV532WL12345678 | 2013-04-13 00:00:00 | A
865432 | 1JJV532WL12345678 | 2013-04-13 00:00:00 | A |  | Not on map or on Internal Report
 |  |  |  | Reference | http://www.excelforum.com/excel-general/982843-trying-to-create-a-functional-spreadsheet-overhead-map-for-trailer-yard.html
 |  |  |  |  | NOTE: 6543210 was a typo on the [NAME], 654321 was the correct #
 |  |  |  |  | this was caught by the program and displayed in Col E as an error
 |  |  |  |  | Items in '[NAME]' were added by [NAME] for testing purposes.
Spreadsheet: 92262d1291889795-how-can-we-use-countif-on-number-format-to-count-any-part-of-the-number-search-any-part-of-number-format
Sheet: Sheet1

Code | Name | Payment
1122 | A | 1 |  |  | Search by | Name | A
2211 | B | 2 |  |  | Code | Name | Payment |  | NOTE | The countif criteria "*" at the beginning and the end should be included
2314 | C | 3 |  |  |  |  |  |  |  | because I want to search text in all part. For Example Search by Name Work properly
2354 | D | 4
1566 | E | 5 |  |  |  |  |  |  |  | Problem is when I Search by Code or Payment which is NOT text format
4654 | F | 6 |  |  |  |  |  |  |  | How can I search Number format in any part of it (must have "*"&&"*")
6541 | G | 7
1563 | H | 8
8691 | I | 9
156 | J | 10
1122 | A | 1
2211 | B | 2
2314 | C | 3
2354 | D | 4
1566 | E | 5
4654 | F | 6
6541 | G | 7
1563 | H | 8
8691 | I | 9
156 | J | 10
1122 | A | 1
2211 | B | 2
2314 | C | 3
2354 | D | 4
1566 | E | 5
4654 | F | 6
6541 | G | 7
1563 | H | 8
8691 | I | 9
156 | J | 10
Spreadsheet: 50674d1250154802-matrix-transpose-695516_stianabra
Sheet: Sheet5

Row | Column | Value
a | a | 500
a | b | 121
a | c | 353
a | d | 2321
a | e | 21
b | a | 203
b | b | 232
b | c | 1231
b | d | 123
b | e | 12
c | a | 120
c | b | 0.2222
c | c | 42342
c | d | 124
c | e | 1242
d | a | 320
d | b | 303
d | c | 121
d | d | 145
d | e | 41
e | a | 12
e | b | 233
e | c | 454
e | d | 675
e | e | 896
Spreadsheet: 145455d1331586879-populate-row-information-based-on-start-end-dates-resourceload_test
Sheet: Sheet1

 |  |  | Std Hours > | 24 | 40 | 40 | 40 | 40 | 40 | 40 | 40
 |  |  | St Week> | 2012-02-01 00:00:00 | 2012-02-05 00:00:00 | 2012-02-12 00:00:00 | 2012-02-19 00:00:00 | 2012-02-26 00:00:00 | 2012-03-04 00:00:00 | 2012-03-11 00:00:00 | 2012-03-18 00:00:00
 |  |  | En Week> | 2012-02-04 00:00:00 | 2012-02-11 00:00:00 | 2012-02-18 00:00:00 | 2012-02-25 00:00:00 | 2012-03-03 00:00:00 | 2012-03-10 00:00:00 | 2012-03-17 00:00:00 | 2012-03-24 00:00:00
Name | Start | End | [NAME]
Person A | 2012-02-01 00:00:00 | 2013-01-31 00:00:00 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
Person B | 2012-02-01 00:00:00 | 2012-02-18 00:00:00 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
 |  |  |  |  |  |  | Hours should stop for Person B after 2/18/2012
Spreadsheet: 751561d1634177497-need-a-formula-for-the-column-letter-to-use-in-indirect-ytd-formula-v2
Sheet: Sheet1

 | 5
 |  | 2020-07-31 00:00:00 | 0.01
 |  | 2020-08-31 00:00:00 | 0.01
 |  | 2020-09-30 00:00:00 | 0.01
 |  | 2020-10-31 00:00:00 | 0.01
 |  | 2020-11-30 00:00:00 | 0.01
 |  | 2020-12-31 00:00:00 | 0.01
 |  | 2021-01-31 00:00:00 | 0.01 |  | 0.01
 |  | 2021-02-28 00:00:00 | 0.01 |  | 0.01
 |  | 2021-03-31 00:00:00 | 0.01 |  | 0.01
 |  | 2021-04-30 00:00:00
 |  | 2021-05-31 00:00:00
 |  | 2021-06-30 00:00:00
 |  | 2021-07-31 00:00:00
 |  | 2021-08-31 00:00:00
 |  | 2021-09-30 00:00:00
 |  | 2021-10-31 00:00:00
 |  | 2021-11-30 00:00:00
 |  | 2021-12-31 00:00:00
 |  | 2022-01-31 00:00:00
 |  | 2022-02-28 00:00:00
 |  | 2022-03-31 00:00:00
 |  |  |  |  |  | replaces match row
 |  |  |  |  |  | replaces range number for product formula
 |  |  |  |  |  | replaces the column letter (to count how many months)
 |  |  | beg of year date | 2021-01-31 00:00:00 |  | range needs to start at A1
Spreadsheet: 85427d1285529905-autofill-vlookup-function-stats-aggregate-example
Sheet: Week 12

TEAM AWESOME | ACW | Not Ready | Transfers | Hold | [NAME] | Unplanned Break |  | CSAT
1-2-1 = Done
1-2-1 = Ready
Week 12       Targets: | 00:00:20 | 0.15 | 0.15 | 00:01:10 | 0.07 | 0.005 |  | 4
user 1
user 2 | 0:00:28.730000 | 0.1230623629619615 | 0.1557377049180328 | 0:02:07.906000 | 0.08214934427482262 | 0.01580088997572259
user 3
user 4 | 0:00:30.814000 | 0.2090162514293634 | 0.2571428571428571 | 0:01:09.643000 | 0.06306524827610104 | 0.03801240514224331
user 5 | 0:00:50.607000 | 0.1625920471281296 | 0.25 | 0:01:34.339000 | 0.06588119783996073 | 0.03449517263950254
user 6 | 0:00:16 | 0.09907467436789061 | 0.3241758241758242 | 0:02:52.137000 | 0.08091196636608318 | 0.007337773324689103
user 7 | 0:00:16.971000 | 0.09616123894777308 | 0.3333333333333333 | 0:00:34.804000 | 0.07067933439507935 | 0.007633587786259542 |  |  |  | Customer Install:
user 8 |  |  |  |  |  |  |  |  |  | ACW=20s
user 9 | 0:00:12.852000 | 0.1843185583585659 | 0.1441048034934498 | 0:00:47.769000 | 0.08336937981016429 | 0.008088013254221519 |  |  |  | Not Ready=15%
user 10 | 0:00:09.056000 | 0.1448237596005023 | 0.2144469525959368 | 0:00:40.223000 | 0.1061764448208393 | 0.004614081710130538 |  |  |  | Total Transfers=15% or less
user 11 |  |  |  |  |  |  |  |  |  | Hold=1min, 10sec
user 12
user 13 | 0:01:02.962000 | 0.1281404839219325 | 0.3571428571428572 | 0:04:06.967000 | 0.07120335074591745 | 0.01885130728841021
user 14 | 0:01:01.146000 | 0.1471730686232197 | 0.1219512195121951 | 0:01:51.439000 | 0.1195843431492978 | 0.004083529763288071
user 15 | 0:00:12.094000 | 0.08839347058684167 | 0.2924528301886792 | 0:01:52.217000 | 0.07017460731123694 | 0.01634722452557512
user 16 | 0:00:10.010000 | 0.1304448693793763 | 0.1951219512195122 | 0:01:28.617000 | 0.07174292061528079 | 0.02556874103652878
user 17
user 18 | 0:00:31.204000 | 0.1365415802376014 | 0.3782894736842105 | 0:02:01.188000 | 0.05598340561946068 | 0.01344144823684707
Spreadsheet: 0c5c5892-b142-4bc0-bbf7-bea3e5b57f07
Sheet: Sheet1

NUCOR CORP | 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
8-K
07/19/2012
NO TITLE
TONNAGE DATA
(in thousands)
 |  |  | Three Months (13 Weeks) Ended |  |  |  |  |  | Six Months (26 Weeks) Ended
 |  |  | June 30, 2012 |  | July 2, 2011 |  | Percentage Change |  | June 30, 2012 |  | July 2, 2011 |  | Percentage Change
Steel mills production |  |  | 5061 |  | 4667 |  | 8% |  | 10320 |  | 9886 |  | 4%
Steel mills total shipments |  |  | 5202 |  | 4864 |  | 7% |  | 10437 |  | 10064 |  | 4%
Sales tons to outside customers:
 | Steel mills |  | 4264 |  | 4052 |  | 5% |  | 8688 |  | 8470 |  | 3%
 | Joist |  | 75 |  | 70 |  | 7% |  | 139 |  | 137 |  | 1%
 | Deck |  | 76 |  | 79 |  | -4% |  | 141 |  | 151 |  | -7%
 | Cold finished |  | 132 |  | 129 |  | 2% |  | 270 |  | 263 |  | 3%
 | Fabricated concrete
 | reinforcing steel |  | 322 |  | 275 |  | 17% |  | 572 |  | 496 |  | 15%
 | Other |  | 1056 |  | 993 |  | 6% |  | 2036 |  | 2059 |  | -1%
 |  |  | 5925 |  | 5598 |  | 6% |  | 11846 |  | 11576 |  | 2%
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 77863d1278363654-filter-and-automatically-calculate-only-the-filtered-data-book1
Sheet: Sheet1

 | Consumers | Date | products ordered | cost per unit | Units ordered | TAX | Total Cost
 | Consumer 1 | 2010-01-02 00:00:00 | computer | 300 | 5 | 0.1 | 150
 | Consumer 2 | 2010-02-02 00:00:00 | scaner | 50 | 6 | 0.1 | 30
 | Consumer 3 | 2010-03-02 00:00:00 | printer | 60 | 7 | 0.1 | 42
 | Consumer 4 | 2010-04-02 00:00:00 | calculator | 5 | 100 | 0.1 | 50
 | Consumer 5 | 2010-05-02 00:00:00 | computer | 300 | 5 | 0.1 | 150
 | Consumer 6 | 2010-06-02 00:00:00 | scaner | 50 | 6 | 0.1 | 30
 | Consumer 7 | 2010-07-02 00:00:00 | printer | 60 | 7 | 0.1 | 42
 | Consumer 8 | 2010-08-02 00:00:00 | calculator | 5 | 100 | 0.1 | 50
 | Consumer 9 | 2010-09-02 00:00:00 | computer | 300 | 5 | 0.1 | 150
 | Consumer 10 | 2010-10-02 00:00:00 | scaner | 50 | 6 | 0.1 | 30
 | Consumer 11 | 2010-11-02 00:00:00 | printer | 60 | 7 | 0.1 | 42
 | Consumer 5 | 2010-01-03 00:00:00 | calculator | 5 | 100 | 0.1 | 50
 | Consumer 6 | 2010-02-03 00:00:00 | computer | 300 | 5 | 0.1 | 150
 | Consumer 7 | 2010-03-03 00:00:00 | scaner | 50 | 6 | 0.1 | 30
 | Consumer 8 | 2010-04-03 00:00:00 | printer | 60 | 7 | 0.1 | 42
 | Consumer 9 | 2010-05-03 00:00:00 | calculator | 5 | 100 | 0.1 | 50
 | Consumer 10 | 2010-06-03 00:00:00 | computer | 300 | 5 | 0.1 | 150
 | Consumer 11 | 2010-07-03 00:00:00 | scaner | 50 | 6 | 0.1 | 30
 | Consumer 12 | 2010-08-03 00:00:00 | printer | 60 | 7 | 0.1 | 42
 |  |  | Totals | 2070 | 490 |  | 1310 | 1660 | 472 |  | 1088
Spreadsheet: 27610d1220992324-counting-cells-in-a-row-that-are-less-than-0-test
Sheet: BSBS_RMBS_Survey

-0.005121239340913197 | -0.002372449317468906 | -0.002117779000007074 | -0.001513217137930241 | 0.016275496289513 | 0.0116004822452974 | -0.00918434884660284 | -0.010381616648928 | -0.00669829651427882 | -0.00486805928372544 | -0.00419592791751927 | -0.0006735040632067 | -0.002282442090020951 | -0.00243768417525529 | -0.0141234682388684 |  | 4
0.0126408740481108 | 0.01592330473734043 | 0.01666128221088077 | 0.01776050171592318 | 0.03639039722061309 | 0.03211219594485099 | 0.03012911556876856 | 0.03182771487956775 | 0.02853483851141098 | 0.02713727939410769 | 0.02692840184538555 | 0.02379661594634229 | 0.02123528257935493 | 0.02652567703324019 | 0.03895047160453396 |  | 0
Spreadsheet: 2b72fec7-3378-4878-9bfb-17524d641f0c
Sheet: Sheet1

Colorado Department of Human Services - Domestic Violence Program | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
2012 Special Projects Application for Funding - Budget Form
Applicant Name:
Total Request Amount:
PERSONNEL
Position 1 Title:
 | Total Expense | Amt Requested from DVP | DVP %
Salary
Fringe/Benefits
Position 2 Title:
 | Total Expense | Amt Requested from DVP | DVP %
Salary
Fringe/Benefits
Position 3 Title:
 | Total Expense | Amt Requested from DVP | DVP %
Salary
Fringe/Benefits
Position 4 Title:
 | Total Expense | Amt Requested from DVP | DVP %
Salary
Fringe/Benefits
Position 5 Title:
 | Total Expense | Amt Requested from DVP | DVP %
Salary
Fringe/Benefits
Personnel Narrative: Fully explain and justify the need for the request including how staff will perform activities associated with the proposed project(s).
GENERAL OPERATING
 | Total Expense | Amt Requested from DVP | DVP %
Printing
Office Supplies
Postage
Communications
Rent
Utilities
Equipment Rental
Maintenance/Repair
Insurance
Program Supplies
Other:
Other:
Other:
General Operating Narrative: Fully explain and justify the need for the request including how expenses will be used to directly support the proposed project(s).
Travel
 | Total Expense | Amt Requested from DVP | DVP %
Mileage
Overnight Lodging
Perdiem
Airfare
Other:
Other:
Other:
Travel Narrative: Fully explain and justify the need for the request including how expenses will be used to directly support the proposed project(s).
Events
 | Total Expense | Amt Requested from DVP | DVP %
Meeting Space Rental
Food
Audiovisual
Publicity
Speaker Fees
Translators/Interpre.
Other:
Other:
Other:
Events Narrative: Fully explain and justify the need for the request including how expenses will be used to directly support the proposed project(s).
OTHER/MISC
 | Total Expense | Amt Requested from DVP | DVP %
Other/Misc Narrative: Fully explain and justify the need for the request including how expenses will be used to directly support the proposed project(s).
Spreadsheet: 146722d1332328687-sum-if-on-named-cells-sample
Sheet: Sch 2 - Exp Detail

 |  | Project Name |  | 0
 |  | Project Code - once available |  | 0
 |  | Project Period |  | 0
 |  | Start Date of Project |  | 0
 |  | [NAME] |  | 0
 |  | Programme Manager - if applicable |  | 0
 |  | Project Manager |  | 0
 |  | Account Code | Account Description |  |  |  |  |  |  |  | Total |  |  |  |  | Q1 | Q2 | Q3 | Q4 | Total | Q1 | Q2 | Q3 | Q4 | Total | Q1 | Q2 | Q3 | Q4 | Total | Q1 | Q2 | Q3 | Q4 | Total | Q1 | Q2 | Q3 | Q4 | Total | Total | Check
 |  |  | BUDGET YEAR |  |  |  |  |  |  |  |  |  |  |  |  | 2011/2012 |  |  |  | 2011/2012 | 2012/2013 |  |  |  | 2012/2013 | 2013/2014 |  |  |  | 2013/2014 | 2014/2015 |  |  |  | 2014/2015 | 2015/2016 |  |  |  | 2015/2016
 |  |  | Expense Category
 |  | 81100 | Salaries |  |  |  |  |  |  |  | 67200 |  |  |  |  | 10000 | 21000 | 24000 | 24000 | 79000 |  |  |  |  | 17000 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 96000 | -28800
 |  | 81200 | NICS & Pensions |  |  |  |  |  |  |  | 10800 |  |  |  |  | 500 | 2300 | 2700 | 2700 | 8200 |  |  |  |  | 2600 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 10800 | 0
 |  | 81250 | Pension Costs - FRS17 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81300 | Other Employment Costs |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81400 | Temporary Staff Costs |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81500 | Travel & Subsistence Expenses |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81600 | Entertaining |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81700 | Car Costs |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81800 | Delegate Costs to Conf/Festivals |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81900 | Volunteers & Members |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81910 | Trustees |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81950 | Efficiency Savings |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  |  | Staff and Related Costs |  |  |  |  |  |  |  | 78000 |  |  |  |  | 10500 | 23300 | 26700 | 26700 | 87200 | 0 | 0 | 0 | 0 | 19600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 106800 | -28800
Spreadsheet: 848048d1698855342-remove-duplicates-from-one-column-and-concat-data-from-another-column-forum-query-example
Sheet: Sheet1

column 1 | column 2 | column 3 | Column 4
abc1 | abc2 | 1234 | a
abc1 | abc2 | 5678 | g
bce2 | bce3 | 4556 | h
def3 | def4 | 5678 | j
Spreadsheet: darrell_schoolcraft__7323__imball0202
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 |  | -38202
9238 |  | -19000
56422 |  | -1440522
58710 | -4946 | -31715
60921 |  | -1364036
78026 |  | 10450
500084 |  | -57000
500085 | -3596
500097 |  | -78961
INDEX
2002-01-31 00:00:00 |  |  | 835344.24
2002-02-19 00:00:00
CBS Volume
 |  |  | 340221
Spreadsheet: 4ca47a74-0bd5-4d8c-abaf-94c089385c26
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2105 | 8149 | [NAME] | Fossum | USA | 206 | 00:42:31 | 00:02:53 | 01:31:34 | 00:02:13 | [NAME] | 1 | 03:22:44
2105 | 8177 | [NAME] | Stuart | USA | 234 | 00:39:07 | 00:03:13 | 01:27:13 | 00:02:45 | 01:20:16 | 2 | 03:32:33
2105 | 8157 | Eleanor | Kitagawa | USA | 214 | 00:55:35 | 00:02:39 | 01:32:52 | 00:01:58 | 01:08:35 | 3 | 03:41:37
2105 | 8152 | Molly | [NAME] | USA | 209 | 00:43:50 | 00:03:51 | 01:43:54 | 00:01:41 | [NAME] | 4 | 03:54:12
2105 | 8145 | [NAME] | Dorion | USA | 202 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
Spreadsheet: darrell_schoolcraft__7824__imbalsumm0110
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 15647 | 15382 | -17185 | -15000
2 | 16345 | 16343 | -32009 | -31880
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
2001-09-30 00:00:00 |  |  |  |  | 122493
2001-10-02 00:00:00
CBS Dollars
 |  |  | 323932