tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 328468d1403904070-sumifs-with-multiple-criteria-and-sumranges-book2-solution
Sheet: Sheet1

YTD Spend
Category | Department | Account | Jul | Aug | Sep | Oct | Nov | Dec | current period total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
Consulting | 340 | 84100 | 3239.985872854265 | 3239.985872854265 | 3239.985872854265 | 3239.985872854265
[NAME] | 150 | 55000 | 1215 | 1215 | 1215 | 1215
Consulting | 250 | 89000 | 17500 | 0 | 0 | 0
Consulting | 150 | 83250 | 5953.06375 | 5953.06375 | 5953.06375 | 5953.06375
[NAME] | 150 | 51210 | 1286.8325 | 1286.8325 | 1286.8325 | 1286.8325
Consulting | 160 | 87000 | 144.80125 | 144.80125 | 144.80125 | 144.80125
[NAME] | 120 | 51410 | 280.89125 | 280.89125 | 280.89125 | 280.89125
Consulting | 150 | 88654 | 659.5775 | 659.5775 | 659.5775 | 659.5775
[NAME] | 150 | 51110 | 5953.06375 | 5953.06375 | 5953.06375 | 5953.06375
T&M | 180 | 61600 | 1286.8325 | 1286.8325 | 1286.8325 | 1286.8325
[NAME] | 150 | 51310 | 144.80125 | 144.80125 | 144.80125 | 144.80125
T&M | 280 | 61400 | 280.89125 | 280.89125 | 280.89125 | 280.89125
[NAME] | 150 | 51510 | 659.5775 | 659.5775 | 659.5775 | 659.5775
Current Period | 3
I want to know how muuch has been spent on [NAME] by dept 150 YTD which in this case would be for Jul-Sep
Is there a formula that would say look up everything through current period for [NAME] and dept 150, maybe a sumifs? I can do sumifs with offset but only for one period.
Spreadsheet: 709982d1608649670-help-using-table-formula-etc-to-highlight-the-best-price-in-multiple-rows-cells-example-2
Sheet: Sheet1

Agent | Country | Town | 0.5 | 1 | 1.5 | 2 | 2.5 | 3 | 3.5 | 4 | 4.5 | 5
Impact | Afghanistan | All | 19.51 | 22.69 | 24.8 | 26.82 | 30.26 | 32.34 | 34.52 | 36.6 | 38.78 | 40.87
Norsk | Afghanistan | All | 23.33 | 25.48 | 27.72 | 29.87 | 32.11 | 34.26 | 36.5 | 38.65 | 40.89 | 43.04
Viva | Afghanistan | All | 15.46 | 20.82 | 24.88 | 28.84 | 32.9 | 40.19 | 43.62 | 46.97 | 50.41 | 53.84
Impact | Albania | All | 15.03 | 16.92 | 18.12 | 19.23 | 21.35 | 22.37 | 23.48 | 24.51 | 25.62 | 26.62
Norsk | Albania | All | 17.23 | 18.91 | 20.68 | 22.36 | 24.13 | 25.81 | 27.58 | 29.26 | 31.03 | 32.71
Viva | Albania | All | 15.46 | 20.82 | 24.88 | 28.84 | 32.9 | 40.19 | 43.62 | 46.97 | 50.41 | 53.84
Impact | Algeria | All | 19.51 | 22.69 | 24.8 | 26.82 | 30.26 | 32.34 | 34.52 | 36.6 | 38.78 | 40.87
Norsk | Algeria | All | 23.33 | 25.48 | 27.72 | 29.87 | 32.11 | 34.26 | 36.5 | 38.65 | 40.89 | 43.04
Viva | Algeria | All | 15.46 | 20.82 | 24.88 | 28.84 | 32.9 | 40.19 | 43.62 | 46.97 | 50.41 | 53.84
Impact | American Samoa | All | 19.51 | 22.69 | 24.8 | 26.82 | 30.26 | 32.34 | 34.52 | 36.6 | 38.78 | 40.87
Norsk | American Samoa | All | 23.33 | 25.48 | 27.72 | 29.87 | 32.11 | 34.26 | 36.5 | 38.65 | 40.89 | 43.04
Viva | American Samoa | All | 15.46 | 20.82 | 24.88 | 28.84 | 32.9 | 40.19 | 43.62 | 46.97 | 50.41 | 53.84
Spreadsheet: 300644d1393526512-formatting-graphs-and-charts-with-data-in-cells-groom-workbook
Sheet: DIM. STATS

Dim. # : | 260
Dim.
Dim. Type:
Dim. Feature 1
[NAME]
 |  |  |  |  |  | P1 | P2 | P3 |  | P1 | P2 | P3 |  | P1 | P2 | P3 |  | P1 | P2 | P3
 |  |  |  |  | Sample 1
 |  |  |  |  | Sample 2
 |  |  |  |  | Sample 3
 |  |  |  |  | Average
 |  |  |  |  | Range
 |  |  |  |  |  | 1
 |  |  |  |  |  | 0
Spreadsheet: 108533d1305588663-emt-needs-help-with-database-ambulance-data-base-play-copy
Sheet: Sheet2

# | Date | Name | Times | Person | Person | Unit/Driver | Destination | Location
 |  | Age |  | Received | Requested | Attendants |  | Reason
 |  | Sex |  | Call | Ambulance | Code
 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 |  |  | 0 |  | 0
1 | 1900-01-01 00:00:00 | 0 | 0 |  |  | 0
 |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 |  |  | \ |  | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 |  |  | 0 |  | 0
6 | 1900-01-01 00:00:00 | 0 | 0 |  |  | 0
 |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 |  |  | \ |  | 0
Spreadsheet: 133811d1324647114-vlookup-formula-dnsiaec0093r-11
Sheet: Sheet1

Sum of INV_AMT
COST CTR | Total
EBM203 | 1983.6
EBM204 | 2009.37
EBM215 | 432.74
EBM218 | 1075.27
EIM306 | 183.21
EIM318 | 2829.7
EIM324 | 2288.43
EIM423 | 3718.13
ELM210 | 1963.65
EMT301 | 356.38
EQC408 | 382.92
EWS201 | 251.76
Grand Total | 17475.16
Spreadsheet: 107886d1305030089-vlookup-for-case-with-identical-lookup-values-test
Sheet: Sheet1

RANK | TYPE |  |  | RANK | TYPE |  |  |  |  | RANK | TYPE
5 | aaa |  |  | 1 | [NAME] |  |  |  |  | 1 | [NAME]
6 | bbb |  |  | 2 | [NAME] |  |  |  |  | 2 | [NAME]
2 | [NAME] |  |  | 2 | #N/A |  |  |  |  | 2 | ddd
2 | ddd |  |  | 4 | #N/A |  |  |  |  | 4 | iii
6 | eee |  |  | 5 | #N/A |  |  |  |  | 5 | aaa
1 | [NAME] |  |  | 6 | #N/A |  |  |  |  | 6 | bbb
6 | ggg |  |  | 6 | #N/A |  |  |  |  | 6 | eee
9 | hhh |  |  | 6 | #N/A |  |  |  |  | 6 | ggg
4 | iii |  |  | 9 | #N/A |  |  |  |  | 9 | hhh
 |  |  |  |  |  |  |  |  |  | Desired Result
Spreadsheet: 840731d1692944897-formula-needed-for-different-price-when-brought-at-different-qty-book2
Sheet: Sheet1

No of apple | Price | Average Price |  |  |  |  |  |  | Manual Trial & Error |  | [NAME] | Apple Left
1 | 6 |  |  |  |  |  |  | No of apple | Multiple | Amount
3 | 17 |  |  |  | No of Apples | 87 |  | 13 | 6
5 | 25 |  |  |  | Price | ??????? |  |  | 1
12 | 55 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Total Price
 |  |  |  |  |  |  |  | Is it possible to compute in a single formula?
Spreadsheet: 168191d1342288362-vlookup-or-hlookup-help-roiperdatesample
Sheet: ROI PER DAY

Date | ROI
Spreadsheet: 021cb127-f73e-4d8d-9570-6fccc49680a9
Sheet: Sheet1

RFP # 13-012 ICGC CREEKS COURSE BUNKER RENOVATION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | [NAME] | TDI GOLF | DUININCK, INC. | FLEETWOOD SERVICES | LANDCONSTRUCTORS, INC.
Description
Mobilization
Moving equipment on site | 20000 | 23135.1 | 45000 | 5000 | 11500
Section Total | 20000 | 23135.1 | 45000 | 5000 | 11500
Excavation/Shaping
Excavate sand/Klingstone  and bury within bunker cavity | 17521 | 27332.76 | 28030 | 12615 | 23127.72
Modify bunker slopes to a maximum slope  limits and for proper installation of bunker liner | 59571.4 | 36443.68 | 70075 | 42050 | 62374.76
Section Total | 77092.4 | 63776.44 | 98105 | 54665 | 85502.48000000001
Drainage Installation
Remove existing drainage gravel and pipe and salvage  pipe | 2743 | 8037 | 4500 | 1680 | 4905
Install salvaged pipe and encase in new approved pea gravel | 23210 | 29021.55 | 4500 | 17640 | 24525
Section Total | 25953 | 37058.55 | 9000 | 19320 | 29430
Bunker Liner and Sand Installation
Procurement of washed and approved 3/8" pea gravel | 16119.32 | 18922.68 | 17518.75 | 20772.7 | 16820.16
Install washed and approved 3/8" pea gravel at a depth of 2" and as required by Better Billy Bunker Specifications | 15418.48 | 30136.12 | 14015 | 16820 | 19623.52
Procurement of Better [NAME] liner polymer | 74989.88 | 93912.56 | 56060 | 75690 | 71766.02
Installation of Better [NAME] liner polymer | 5606.72 | 19623.52 | 80586.25 | 29435 | 8410.08
Procurement of approved  Bunker Sand | 57221.05 | 53908.46 | 48000 | 61094.04 | 56100
Install approved  [NAME] in bunkers and compact to a depth of 4" | 29435.28 | 30136.12 | 17518.75 | 25230 | 50110.06
Section Total | 198790.73 | 246639.46 | 233698.75 | 229041.74 | 222829.84
Grassing
Procurement of 419 [NAME] grass sod | 2200 | N/B | 800 | 2100 | 3975
Installation of 419  Bermuda grass sod on all disturbed areas | 1100 | N/B | 400 | 1500 | 5250
Section Total | 3300 |  | 1200 | 3600 | 9225
GRAND TOTAL ALL SECTIONS | 325136.13 | 370609.55 | 387003.75 | 311626.74 | 358487.32
COST PER SQUARE FOOT | 4.64 | 5.288 | 5.52 | 3.71 | 5.115
Spreadsheet: 845088d1696628127-convert-based-on-range-value-gravity-to-density-bvj-
Sheet: Sheet1

 |  |  |  |  |  |  | from gravity to density
 |  |  |  |  |  |  | gravity |  | density
 |  | gravity | density | C-D | Subtrahend from lookup table | Therefore the formula is: |  |  | subtract
 | example | 0.7512 | 0.751 |  |  |  | 0.654 | 0.683 | 0.0001
 | example | 0.9533 | 0.9527 |  |  |  | 0.684 | 0.756 | 0.0002
 |  |  |  |  |  |  | 0.757 | 0.785 | 0.0003
 |  |  |  |  |  |  | 0.786 | 0.851 | 0.0004
 |  |  |  |  |  |  | 0.852 | 0.941 | 0.0005
 |  |  |  |  |  |  | 0.942 | 1.032 | 0.0006
 |  |  |  |  |  |  | 1.003 | 1.075 | 0.0007
Spreadsheet: 142047d1329601546-sumproduct-condition-to-avoid-duplicates-duplicate-test
Sheet: Sheet1

 | BUID | ORDER_NUM | CASE_ID | Order Date Week | Status
 | 4747 | 390131977 | 16793172 | 201245 | Pending
 | 7878 | 389174384 | 16768143 | 201244 | Confirmed
 | 7878 | 386472799 | 17275173 | 201244 | Confirmed
 | 7878 | 394607923 | 17275173 | 201244 | Confirmed
 | 3232 | 389711672 | 16793172 | 201245 | Pending
 | 7878 | 395261795 | 17221810 | 201245 | Confirmed
 | 7878 | 387159908 | 16582637 | 201245 | Pending
 | 3232 | 390029304 | 16787467 | 201245 | Pending
 | 3232 | 396236176 | 16793172 | 201245 | Pending
 | 3232 | 387361553 | 16589484 | 201245 | Confirmed
 | 3232 | 396493272 | 17393829 | 201244 | Pending
 | 3232 | 396061129 | 17275173 | 201244 | Confirmed
 |  |  |  |  |  |  |  |  | I | J
 |  |  |  |  |  |  |  |  | 201244 | 201245
 |  |  |  |  |  |  | 17 | Confirmed
 |  |  |  |  |  |  | 18 | Pending
Spreadsheet: 134547d1325442385-help-with-formulas-to-cross-referencing-codes-to-match-categories-and-items-food-db
Sheet: database

Col A | Col B | Col C | Col D
 | mutton |  | lot55
ret12 | vegetable | category
 | cake |  | fop15
fop15 | bakery | category
 | carrot |  | ret12
 | chicken |  | lot55
 | biscuit |  | fop15
lot55 | meat | category
 | cucumber |  | ret12
Spreadsheet: 717897d1612891364-create-unicqe-cequence-value-unique-sequence
Sheet: Sheet1

Name | Sale |  |  | unique sequence | Average |  |  | Name | Average Sales
A | 191 |  |  | A
A | 162 |  |  | B
A | 179 |  |  | C
B | 133 |  |  | D
B | 182 |  |  | A
C | 158 |  |  | E
C | 178 |  |  | B
C | 158
C | 185
D | 179
D | 178
A | 154
A | 185
E | 191
E | 181
E | 176
B | 155
B | 105
B | 108
Spreadsheet: 802676d1666967203-copy-information-from-multiple-tables-to-a-sheet-bwp-invoices
Sheet: Table 10

 |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  | Invoice #
 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-20 00:00:00 |  |  |  | 80024
 | [NAME] |  |  |  |  |  |  |  |  | Ship To
 | BW Papersystems Company P.O. Box 4717 [EMAIL] Timonium, MD 21094-4717 |  |  |  |  |  |  |  |  | BW Papersystems Co. 10615 Beaver Dam Road Hunt Valley, MD 21030-2204
P.O. Number |  |  | Terms |  | Rep |  | Ship |  | Via |  | F.O.B. |  |  | Project
PN45441 |  |  | 2%10NET45 |  | HOUSE |  | 2022-10-20 00:00:00 |  | UPS |  | Richmond, VA
Quantity |  | Item Code |  | Description |  |  |  |  |  |  |  | Price Each |  |  |  | Amount
4 4 |  | 41522 8MATERIAL |  | EXTENSION, AIR CYL FLEXO MODEL 15 Material Surcharge |  |  |  |  |  |  |  | 9.50 8.00 |  |  |  | 38.00 32.00
 |  |  |  |  |  |  |  |  |  |  |  | Total                               $70.00
Payments/Credits                 $0.00 |  |  |  |  |  |  |  | Balance Due |  |  |  |  |  |  | 70
Spreadsheet: 73d8ff84-5afe-470e-8bed-6a54bba60d68
Sheet: Sheet1

Early and Adequate Prenatal Care by Maternal Race and Ethnicity,  Births to 15-44 Year Old Maine Women, 2002-2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | Live Births for which Mother Received  Early and Adequate Prenatal Care*
 |  | Average Annual Number | %† | 95% CI
Maine Total |  | 11788 | 86.3 | 85.8 - 86.9
Maternal Race
 | White | 11277 | 86.8 | 86.3 - 87.3
 | Black or African American | 213 | 73.7 | 70.4 - 77.1
 | American Indian | 87 | 78.3 | 72.9 - 84.0
 | Asian or Pacific Islander | 182 | 81.7 | 77.8 - 85.8
 | Other | 13 | 79.7 | 65.8 - 95.8
Maternal Ethnicity
 | Not Hispanic | 11617 | 86.4 | 85.9 - 86.9
 | Hispanic | 155 | 80.5 | 76.3 - 84.8
* Defined as an adequate or adequate-plus rating on the Kotelchuck Adequacy of Prenatal Care Utilization Index.
† Percents are based on live births with known prenatal care initiation and adequacy.
CI: Confidence Interval.
Note: Group totals might not equal overall total because some births were missing group information. For example, births with missing maternal race were excluded from the maternal race analysis.
Data Source: Birth certificate datasets obtained from the Office of Data, Research and Vital Statistics, Maine Center for Disease Control and Prevention.
Spreadsheet: 782186d1653894022-bring-two-different-rows-to-same-line-test-19-aligw
Sheet: Tabelle1

Main Mail adresses | Comparing | Fix AliGW |  | Expected Result
A | BB
B | DD
C | K
D | X
E | V
F | HH
G | O
H | P
I | S
J | EE |  |  |  | bringing them in a same lane
K |  |  |  | K
L
M
N
O |  |  |  | O
P |  |  |  | P
R
S |  |  |  | S
T
U
W
Y
Z
X |  |  |  | X
AA
BB |  |  |  | BB
CC
DD |  |  |  | DD
EE |  |  |  | EE
KK
Spreadsheet: michelle_lokay__26583__TW EOL
Sheet: Sheet1

Transwestern / EOL | Global Counterparty ID
Agave Energy Company | 45648
Aquila Energy Marketing Corporation | 18
Arizona Public Service Company | 5225
Barrett Resources Corporation | 687
BP Energy Company | 12
Burlington Resources Trading, Inc. | 49935
Calpine
CIG
Citizens
Conoco Inc. | 3497
Coral Energy Resources, L.P. | 45515
Duke/GPM
Dynegy
Enron Energy Services, Inc. | 57956
El Paso Field Services Company | 52671
El Paso Merchant Energy - Gas Company | 49675
El Paso Natural Gas
Elmridge Resources
ENA
Coastal Merchant Energy, L.P. | 53727
EOG Resources, Inc. | 71318
[NAME]
[NAME]
Marathon
North Star Steel
NWPL
Oneok Energy Trading & Marketing Company, LP | 31699
Occidental Energy Marketing, Inc. | 63665
[NAME]
PanCanadian Energy Services Inc. | 61839
PG&E
PG&E Trading
Phillips
PNM
Pogo
PPL Global
Questar
Red Cedar Gathering Co. | 60866
Reliant
Southern Company Energy Marketing, L.P. | 56264
San Diego Gas & Electric Company | 187
Sempra Energy
[NAME]
SMUD
Southern California Gas Company | 2872
Southwest Gas Corporation | 2907
SPS/ePrime
Tenaska Markeing Ventures | 208
Texaco Natural Gas Inc. | 3022
Trans Colorado Gas Transmission Co. | 37705
TXU
USGT/Aquila, L.P. | 76789
Western Gas Resources Inc. | 232
Williams Energy Marketing & Trading | 64245
Spreadsheet: 01ed928d-5fe4-486b-ad2f-e95a46266d9b
Sheet: $ serials by vendor

Serials Expenditures by Vendor FY10 and FY11
Library | Code | Vendor | FY10 | FY11 | % change | % of total FY11
[NAME] | nebs | [NAME] | 10051.59 | 8657.19
URI | saea | [NAME] | 735 | 735
URI | sams | [NAME] | 5018 | 5136.2
URI | sasce | [NAME] | 383 | 406
URI | sben | [NAME] | 15086.98 | 6720.44
URI | sbna | URI Bureau of Nat Aff | 1630 | 1695
URI | sbow | URI Bowker Reed | 3001.05 | 3140.26
URI | schc | URI Choice | 425 | 445
URI | sdood | [NAME] | 149.5 | 149.5
URI | sebs | URI EBSCO | 705217.42 | 675542.33
URI | sgale | [NAME] (serials) | 6653.45 | 3903.16
URI | [NAME] | URI Harrassowitz | 141.6 | 134.51
URI | shel | URI HELIN | 1990607.2 | 2220702.46
URI | sicp | URI ICPSR | 8750 | 0
URI | sinfo | URI Information Today | 1087.2 | 337.55
URI | [NAME] | [NAME] | 3438.09 | 3490.77
URI | snap | URI National Archive Publishing Company | 1733.42 | 1182.07
URI | snone | URI no vendor ([NAME]) | 0 | 285.14 | N/A
URI | spete | [NAME]'s | 299.38 | 292.53
URI | sproq | URI ProQuest I&L | 5770.01 | 5873.01
URI | sscd | URI Science Direct | 7690 | 0
URI | suip | [NAME] of Illinois | 829 | 0
URI | susbe | URI Serials USBE | 150 | 0
URI | swes | [NAME] | 1112.5 | 1841.5
URI | swil | [NAME] | 2205 | 1161
CCE | xcqp | CCE CongressQuart | 400.7 | 187.85
CCE | xebs | CCE EBSCO | 3166.82 | 2808.11
CCE | xproj | CCE Providence Journal | 363.5 | 416
CCE | xwil | CCE Wilson | 429 | 0
 |  | TOTAL
Spreadsheet: phillip_platter__31382__Closing 112001 cert debtor
Sheet: Cert Dec-00

 | Certification for Market Settlement November 29, 2001
 | For the Trade Month of December 2000
ISO Creditors to whom amounts are Owed:
# | Customer Name | Trade Month |  |  | Amount Owed | % of total owed to Creditors
 | Total Due to 48 SCs (Creditors) |  |  |  | 1471079852.9
Amounts owed by [NAME] that remain unpaid:
Preliminary and final invoices were provided in March's certification.
# | Customer Name | Date | Inv # | Type | Unpaid Balance | % of total due from Debtors
1243 | California Power Exchange (a) | 2001-02-27 00:00:00 | 14163 | Mkt | 1430114437.65
1243 | California Power Exchange (a) | 2001-03-15 00:00:00 | 14323 | Mkt | 54594957.95
2769 | California Power Exchange (a) | 2001-02-27 00:00:00 | 14126 | Mkt | 12171363.36
2769 | California Power Exchange (a) | 2001-03-15 00:00:00 | 14286 | Mkt | 235652.69
1011 | Pacific Gas and Electric (b) | 2001-02-27 00:00:00 | 14183 | Mkt | 11335555.36
1008 | Salt River Project | 2001-03-15 00:00:00 | 14345 | Mkt | 1540434
1010 | Southern California Edison | 2001-03-15 00:00:00 | 14344 | Mkt | 3337442.11
2465 | Strategic Energy | 2001-03-15 00:00:00 | 14298 | Mkt
 | Total Due From SCs (Debtors)
 | (a) - amounts attributable to PG&E pre-bankruptcy activity not available.
 | (b) - pre-bankruptcy activity
 | Summary of activity for Trade Month of December 2000:
 | Due from SCs
 | Preliminary Invoices |  |  |  | 1503186210.21
 | Final Invoices |  |  |  | 72817565.78
 | Total Invoiced
 | Collected 3/5/01
 | Collected 3/9/01 |  |  |  | 1095680.05
 | Collected 3/22/01 |  |  |  | 4668657.91
 | Collected 4/20/01
 | Total Collected
 | Offset against Nov-00 Market AP
 | Cancelled Dec-00 Market AR invoice |  |  |  | 147750
 | Offset against Dec-00 Market AP
 | Offset against Jan-01 GMC
 | Offset against Jan-01 Market AP
 | Offset against Feb-01 Market AP
 | Offset against Mar-01 Market AP
 | Offset against Apr-01 Market AP |  |  |  | 24782.38
 | Offset against May-01 Market AP
 | Offset against Jun-01 Market AP |  |  |  | 434861.71
 | Offset against Jul-01 Market AP |  |  |  | 199009.41
 | Offset against Aug-01 Market AP |  |  |  | 8877.58
 | Total Adjustments
 | Balance Due from SCs
 | Due to SCs
 | Preliminary Invoices
 | Final Invoices |  |  |  | 81563642.97
 | Total Invoiced
 | Paid 3/7/01 |  |  |  | 45426874.33
 | Paid 3/97/01 |  |  |  | 1095680.05
 | Paid 3/23/01 |  |  |  | 4660365.5
 | Paid 3/27/01 |  |  |  | 8292.41
 | Paid 4/23/01 |  |  |  | 1243.61
 | Total Paid
 | Offset against Dec-00 GMC
 | Offset against Dec-00 Market AR
 | Cancelled Dec-00 Market AP invoices
 | FERC ordered reduction Dec-00 Market AP |  |  |  | 1291405.14
 | Offset against Jan-01 Market AR
 | Offset against Feb-01 Market AR |  |  |  | 33196.74
 | Offset against Mar-01 Market AR |  |  |  | 2962776.9
 | Total Adjustments
 | Balance Due to SCs
Spreadsheet: 130288d1322151757-pivot-grand-total-sandeep
Sheet: Sheet1

Original data
Year | Spend
2010 | 25
2010 | 26
2010 | 27 |  |  |  |  |  |  | Column Labels
2011 | 28 |  |  |  |  |  |  | 2011 | 2010 | Grand Total
2011 | 29 |  |  |  |  |  | Sum of Spend | 87 | 78 | 165 | Change 165 to a difference between 2011 and 2010.
2011 | 30
My solution
Year | Spend |  |  |  |  |  | Values
2010 | 1 |  |  |  |  |  | Sum of 2011 | Sum of 2010 | Difference | Calculated field to get the difference
2010 | 2 |  |  |  |  |  | 33 | 6 | 27
2010 | 3
2011 | 10
2011 | 11
2011 | 12
 |  |  |  |  |  |  | Row Labels | Sum of Spend
 |  |  |  |  |  |  | 2010
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 2011 | 27
 |  |  |  |  |  |  | 10 | #N/A
 |  |  |  |  |  |  | 11 | #N/A
 |  |  |  |  |  |  | 12 | #N/A
 |  |  |  |  |  |  | Grand Total
Spreadsheet: 117304d1312649871-custom-number-formatting-generate1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | PBDU2338842
 |  |  |  |  |  | Criteria |  | this |  | or maybe this
 |  | PBDU2338842001 | 001 |  |  | 9 |  | PBDU2338842001 |  |  | PBDU2338842001
 |  | PBDU2338842002 | 002 |  |  |  |  | PBDU2338842002 |  |  | PBDU2338842002
 |  | PBDU2338842003 | 003 |  |  |  |  | PBDU2338842003 |  |  | PBDU2338842003
 |  | PBDU2338842004 | 004 |  |  |  |  | PBDU2338842004 |  |  | PBDU2338842004
 |  | PBDU2338842005 | 005 |  |  |  |  | PBDU2338842005 |  |  | PBDU2338842005
 |  | PBDU2338842006 | 006 |  |  |  |  | PBDU2338842006 |  |  | PBDU2338842006
 |  | PBDU2338842007 | 007 |  |  |  |  | PBDU2338842007 |  |  | PBDU2338842007
 |  | PBDU2338842008 | 008 |  |  |  |  | PBDU2338842008 |  |  | PBDU2338842008
 |  | PBDU2338842009 | 009 |  |  |  |  | PBDU2338842009 |  |  | PBDU2338842009
 |  | PBDU2338842010 | 010
Spreadsheet: 64732357-d86a-40f7-8947-d8c3f53c38e0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-09-30 09:23:07.080000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.375 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.25 | 101.419 | 101.294 | 101.169 | 100.794
4.125 | 101.096 | 100.971 | 100.846 | 100.471 |  | Note: | Refer To Price [NAME]
4 | 100.68 | 100.555 | 100.43 | 100.055 |  |  | For all Price Adjs
3.875 | 100.163 | 100.038 | 99.913 | 99.288
3.75 | 99.194 | 99.069 | 98.944 | 98.319
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.875 | 101.75 | 101.625 | 101.25
3.75 | 101.518 | 101.393 | 101.268 | 100.893
3.625 | 101.081 | 100.956 | 100.831 | 100.456
3.5 | 100.743 | 100.618 | 100.493 | 100.118
3.375 | 100.37 | 100.245 | 100.12 | 99.495
3.25 | 99.834 | 99.709 | 99.584 | 98.959
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-10-14 09:23:07.080000
30 DAY | 2011-10-29 09:23:07.080000
45 DAY | 2011-11-13 09:23:07.080000
60 DAY | 2011-11-28 09:23:07.080000
90 DAY | 2011-12-28 09:23:07.080000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 1d3fc63e-80bd-4949-bab7-208bc6910e0e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
265139 | 6851 | Ewa | Bugdol | POL |  | 00:41:49 | 00:48:00 | 02:05:21 | 00:53:00 | 01:26:58 | 1 | 04:15:49
265139 | 13364 | Ewa | Komander | POL |  | 00:44:06 | 00:53:00 | [NAME] | 00:42:00 | 01:29:19 | 2 | 04:18:14
265139 | 80052 | Aleksandra | Sypniewska | POL |  | 00:47:55 | 01:01:00 | 02:11:04 | 00:52:00 | 01:25:13 | 3 | 04:26:05
Spreadsheet: 1e6cce0b-2348-4966-bb3f-8a6a81c01091
Sheet: Grades

Student | Quiz1 | Exam1 | Quiz2 | Exam2 | Grade
[NAME] | 96 | 97 | 90 | 82
[NAME] | 59 | 55 | 71 | 94
[NAME] | 69 | 71 | 98 | 98
[NAME] | 99 | 90 | 59 | 79
[NAME] | 56 | 86 | 65 | 74
[NAME] | 57 | 61 | 84 | 67
[NAME] | 55 | 86 | 59 | 86
[NAME] | 89 | 91 | 91 | 81
Anne | 55 | 77 | 91 | 86
Spreadsheet: 708726d1607986009-lookup-a-specific-word-from-a-list-and-generating-a-newlist-example
Sheet: Input

ID | Comment | Location
ID1 | My password doesn't work | USA
ID2 | My video keeps stalling | France
ID3 | when I refresh, I lose my passwords | Canada
ID4 | Video sux | France
ID5 | Video is laggy | USA
ID6 | I lost my password | Canada
ID7 | need better video quality | USA
ID8 | need better video quality | Canada
ID9 | new passwords | Canada
ID10 | my text is wrap | USA