tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 734675d1622377160-filter-formula-excel-365-filter-formula
Sheet: Sheet1

T
Sales By Region |  |  |  |  |  | Sales greater than 10000 |  |  |  |  |  |  |  |  | January | Asia
Date | Name | Region | Sales |  |  | Name | Region | Sales |  |  |  |  |  |  | February | Canada
2021-01-01 00:00:00 | [NAME] | US | 11020 |  |  |  | US | 19534 |  |  |  |  |  |  |  | Brazil
2021-01-02 00:00:00 | [NAME] | Canada | 18385 |  |  | [NAME] | Canada | 18385 |  |  |  |  |  |  |  | US
2021-02-03 00:00:00 | Greg | US | 19534 |  |  | Sheen | US | 14552
2021-01-04 00:00:00 | Sheen | US | 14552 |  |  | Barb | Brazil | 11958
2021-02-01 00:00:00 | [NAME] | Asia | 11932 |  |  | [NAME] | Asia | 11932
2021-02-02 00:00:00 | [NAME] | US | 5306 |  |  | [NAME] | US | 11020
2021-01-03 00:00:00 | [NAME] | Asia | 8815 |  |  | [NAME] | Asia | 10396
2021-02-04 00:00:00 | [NAME] | Asia | 10396
2021-01-30 00:00:00 | [NAME] | Canada | 7763
2021-02-28 00:00:00 | Barb | Brazil | 11958
I am kindly asking for Filter [NAME] to produce monthly sales and monthly sales by Region using information on Sales by Region (A3:D13)
Note that C18 and H18 are a drop down list
Desired Solution |  |  |  |  |  | Desired Solution
Month |  | January |  |  |  | Region | US
Monthly sales |  |  |  |  |  | Monthly sales by Region
Date | Name | Region | Sales |  |  | Date | Name | Region | Sales
2021-01-01 00:00:00 | [NAME] | US | 11020 |  |  | 2021-01-01 00:00:00 | [NAME] | US | 11020
2021-01-02 00:00:00 | [NAME] | Canada | 18385 |  |  | 2021-01-04 00:00:00 | Sheen | US | 14552
2021-01-04 00:00:00 | Sheen | US | 14552
2021-01-30 00:00:00 | [NAME] | Canada | 7763
Spreadsheet: 81429d1281614302-graph-construction-help-needed-protocol-layout
Sheet: PSSLPoTT

 | PSS Layers Percentage of Total Time
 |  |  |  |  |  |  |  |  |  | Variable values |  |  | % of total |  | Variables total value
 | PSS Layers
 | Name |  | Abbr.
 | Needs |  | N
 | Value |  | V
 | [NAME] |  | D
 | Lifecycle activities |  | L
 | Actors |  | A
 | Core products |  | Cp
 | Periphery |  | P
 | Contract elements |  | Ce
 | Finance |  | F
Spreadsheet: 116240d1311693782-vlookup-with-conditions-book3
Sheet: Budget

 |  |  |  |  |  | 31 | 28 | 31
- |  | 40 | Budget Projection Tools |  |  | Budget | Budget | Budget
 | Account | Acct Ctr | Annual $ | Change % |  | Jan 2012 | Feb 2012 | March 2012
 |  |  |  | 0
 | 111296 |  | 0
 | 111297 |  | 0
 | 111298 |  | 0
 | 111299 |  | 0
 | 111301 |  | 0
 | 111302 |  | 0
 | 111303 |  | 0
 | 111304 |  | 0
 | 111305 |  | 0
Spreadsheet: 762144d1641408756-formula-for-totalling-based-on-a-drop-down-choice-sample-spreadsheet-01-1-
Sheet: Sheet1

 |  |  |  | Sandra | [NAME] | Beryl | [NAME]
 | December |  | Job B | 1 |  |  | 2
 |  |  | Job A | 3 | 3 | 3 | 3
 |  |  | Job C | 4 | 4 | 4 | 4
 |  |  | Job C | 2 | 2 | 2
 |  |  | Total Jobs Overall
 | Totals |  | Job A
 |  |  | Job B
 |  |  | Job C
Spreadsheet: 291287d1390237083-need-to-create-a-new-smaller-table-on-new-worksheet-from-a-large-table-jan20-excel-forum-example
Sheet: ALL CREDIT CARDS

RE/RO/RL | RUN DATE | CREDIT CARD NUMBER | EXP | NAME
N/A | N/A | 1111222233334444 | 08/16 | SMITH
RL | 4 | 5555666677778888 | 10/17 | JONES
N/A | N/A | 9999000011112222 | 2/16 | THOMAS
N/A | N/A | 3333444455556666 | 3/15 | RICH
RO | 5 | 7777888899990000 | 11/15 | PACKER
N/A | N/A | 4444555566667777 | 8/16 | CAMRY
RE | 4 | 8888999900001111 | 12/18 | EARLER
RO | 2 | 9999000099992222 | 6/16 | [NAME]
N/A | N/A | 0000111144443333 | 1/15 | WULF
N/A | N/A | 2222333344445555 | 10/16 | YOUNG
RE | 1 | 6666777788889999 | 4/16 | KIDDER
RL | 2 | 0000111122223333 | 5/17 | RANKIN
Spreadsheet: 144629d1331064419-matching-row-of-source-table-against-target-table-array-book1-modified-by-tigeravatar-
Sheet: Sheet1

 |  |  |  | SOURCE |  |  |  |  | TARGET
 |  |  | formula | Amount | Account | Date |  | formula | Amount | Account | Date
 |  |  |  | -3 | 37 | 2012-02-28 00:00:00 |  | 3 | -5 | 42 | 2012-03-01 00:00:00
 |  |  | 1 | 2 | 18 | 2012-03-03 00:00:00 |  |  | -4 | 54 | 2012-02-28 00:00:00
 |  |  | 2 | 4 | 37 | 2012-03-01 00:00:00 |  |  | 7 | 37 | 2012-02-28 00:00:00
 |  |  |  | 1 | 95 | 2012-03-02 00:00:00 |  | 9 | -2 | 42 | 2012-03-02 00:00:00
 |  |  | 3 | -5 | 42 | 2012-03-01 00:00:00 |  | 8 | -1 | 18 | 2012-03-05 00:00:00
 |  |  | 4 | 9 | 42 | 2012-02-28 00:00:00 |  |  | 1 | 18 | 2012-03-02 00:00:00
 |  |  | 5 | 7 | 18 | 2012-02-29 00:00:00 |  | 1 | 2 | 18 | 2012-03-03 00:00:00
 |  |  | 6 | 3 | 42 | 2012-02-28 00:00:00 |  | 6 | 3 | 42 | 2012-02-28 00:00:00
 |  |  | 7 | 6 | 37 | 2012-02-29 00:00:00 |  | 2 | 4 | 37 | 2012-03-01 00:00:00
 |  |  |  | -4 | 54 | 2012-03-05 00:00:00 |  |  | 5 | 37 | 2012-03-01 00:00:00
 |  |  |  | 8 | 18 | 2012-03-02 00:00:00 |  | 7 | 6 | 37 | 2012-02-29 00:00:00
 |  |  | 8 | -1 | 18 | 2012-03-05 00:00:00 |  | 5 | 7 | 18 | 2012-02-29 00:00:00
 |  |  |  | 5 | 54 | 2012-03-01 00:00:00 |  |  | 13 | 18 | 2012-03-02 00:00:00
 |  |  | 9 | -2 | 42 | 2012-03-02 00:00:00 |  | 4 | 9 | 42 | 2012-02-28 00:00:00
 |  |  |  |  |  |  |  |  | 10 | 42 | 2012-03-05 00:00:00
 |  |  |  |  |  |  |  |  | 11 | 18 | 2012-03-02 00:00:00
 |  |  |  |  |  |  |  |  | 12 | 54 | 2012-02-28 00:00:00
 |  |  |  |  |  |  |  |  | 13 | 95 | 2012-03-05 00:00:00
 |  |  |  |  |  |  |  |  | 14 | 54 | 2012-03-01 00:00:00
 |  |  |  |  |  |  |  |  | 15 | 42 | 2012-02-29 00:00:00
Spreadsheet: 1d144716-d01a-428f-839f-8bc1a0dca86e
Sheet: Sheet1

[NAME] | Prénom | Labo | [NAME] | Co-directeur | Date
Pion | [NAME] | LATP | [NAME] |  | 2008-01-21 00:00:00
Schoebel | [NAME] | LATP | [NAME] |  | 2008-02-28 00:00:00
Tran | Nam Van | LSIS | [NAME] | Bruasse-bac [NAME] | 2008-03-27 00:00:00
Cao | Yun | LATP | Golubev Youri |  | 2008-04-03 00:00:00
Bienvenu | Laurent | LIF | Durand Bruno | Shen [NAME] | 2008-04-04 00:00:00
Bommier | Helene | LATP | Youssfi [NAME] |  | 2008-04-04 00:00:00
Lunot | Vincent | INRIA | Baratchart Laurent |  | 2008-05-05 00:00:00
[NAME] | [NAME] | LSIS | Nacer M' Sirdi | Balmat [NAME] | 2008-07-03 00:00:00
[NAME] | Mathieu | LATP | [NAME] |  | 2008-10-15 00:00:00
Abou | Isabelle | LATP | [NAME] |  | 2008-10-22 00:00:00
Boughaci | Dalila | LSIS | Benhamou Belaid | Drias Habiba | 2008-10-30 00:00:00
[NAME]. [NAME] | Rui | LATP | Hamel François | [NAME] | 2008-11-14 00:00:00
Baati | Lassaad | LSIS | Frydman Claudia | [NAME] | 2008-11-15 00:00:00
Loustau | Sébastien | LATP | Cavalier Laurent |  | 2008-11-28 00:00:00
[NAME] | Yacine | LSIS | [NAME] |  | 2008-11-28 00:00:00
Grusea | Simona | LATP | Pardoux | Etienne | 2008-12-03 00:00:00
[NAME] | Gaétan | LIF | [NAME] |  | 2008-12-04 00:00:00
Belkhir | Walid | LIF | [NAME] |  | 2008-12-05 00:00:00
Seston | Morgan | LIF | [NAME] | Chepoi Victor | 2008-12-09 00:00:00
Colona | François-Marie | Lsis | [NAME] |  | 2008-12-08 00:00:00
Spreadsheet: 00248a95-9fc2-4f4d-a1ff-8e9735e6754a
Sheet: OCLCstatsFY2010

Fiscal Year 2010 Usage Report -- University of Rhode Island
Reporting Period | FY 2010 | July 2009- June 2010
Institution | UNIV OF RHODE ISLAND
Symbol | RIU
All Interfaces
 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | TOTALS
All WorldCat | 7746 | 5581 | 7430 | 7280 | 6840 | 7024 | 6829 | 6268 | 8820 | 7969 | 6738 | 7683
WorldCat Searches | 4235 | 2956 | 4090 | 3946 | 3973 | 3707 | 3601 | 3182 | 4689 | 4450 | 3783 | 4344
WorldCat Record Actions | 1371 | 1399 | 1311 | 1271 | 1044 | 1069 | 1223 | 1382 | 1880 | 1705 | 1458 | 1573
WorldCat Exports | 2138 | 1222 | 2020 | 2058 | 1823 | 2236 | 2005 | 1701 | 2249 | 1814 | 1496 | 1766
HPB Record Actions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Institution Record Actions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
All SCIPIO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
All Authority | 1743 | 1708 | 1601 | 1564 | 918 | 950 | 1057 | 2733 | 2132 | 1544 | 1946 | 2214
Authority Record Actions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Authority Exports | 128 | 248 | 204 | 128 | 108 | 78 | 118 | 225 | 218 | 138 | 186 | 552
Authority Searches | 1615 | 1460 | 1397 | 1436 | 810 | 872 | 939 | 2508 | 1914 | 1406 | 1760 | 1662
Spreadsheet: 104669d1302184674-summing-in-column-offset-countcontiguousnumbersi
Sheet: Sheet1

Test Column |  | CANAPONE | Fixed |  | Marcol |  | Last Row
0 |  |  |  |  |  |  | 22 |  | test
0
1 |  | 1 | 1 |  | 1
0
0
0
1 |  | 1 | 1 |  | 1
0
1 |  | 1 | 1 |  | 1
0
1 |  | 2 | 2 |  | 2
1
0
0
0
1 |  | 1 | 1 |  | 1
0
0
1 |  | 1 | 1 |  | 1
0
1 |  | #N/A | 1 |  | 1
Spreadsheet: 138731d1327869872-how-can-i-show-two-criteria-and-totals-in-pivot-table-pivotpuz
Sheet: Datasheet

REGION | ACD_VAL | SIGN | DROP | MIT | INFRINGE
NORTH | 1 | 1 |  | 1
NORTH | 4 | 4
NORTH |  | 4
NORTH |  |  | 4
NORTH |  |  |  |  | 1
SOUTH | 1
NORTH | 4 |  | 1
SOUTH | 4
SOUTH |  |  |  | 1
SOUTH | 1
SOUTH | 1
EN | 1 |  |  |  | 4
EN |  |  |  |  | 4
EN |  |  |  |  | 1
EN |  |  |  | 4
EN |  |  |  | 1
NORTH |  |  |  |  | 1
SOUTH |  |  | 4
SOUTH | 4 | 1 |  |  | 4
SOUTH | 4 | 1
EN |  | 1
NORTH |  | 1
NORTH |  | 1
NORTH |  | 1 |  | 1
Spreadsheet: 140448d1328750567-formulas-amanda
Sheet: Sheet1

Demo
date | km | 400 |  |  |  |  | 0
 | 256 | 144 |  | c4-b3 |  | 256 | 256
 | 22 | 122 |  |  |  | 22 | 278
 | 88 | 34 |  |  |  | 88
 | 18 | 16 |  |  |  | 18
 | 22 | -6 |  |  |  | 22
Spreadsheet: sara_shackleton__36845__Boeing ISDA
Sheet: Matrix

Collateral Threshold Matrix - Threshold based upon the lower of S&P and Moody's sr. unsecured debt ratings.
 |  |  | Counterparty |  |  | EPMI
 | S&P Rating | Moody's Rating |  | S&P Rating | Moody's Rating
 | AA- or above | Aa3 or above | 75000000 | AA- or above | Aa3 or above | 75000000
 | A or A+ | A2 or A1 | 60000000 | A or A+ | A2 or A1 | 60000000
 | BBB+ or A- | Baa1 or A3 | 50000000 | BBB+ or A- | Baa1 or A3 | 50000000
 | BBB- or BBB | Baa3 or Baa2 | 30000000 | BBB- or BBB | Baa3 or Baa2 | 30000000
 | BB+ or below | Ba1 or below | 0 | BB+ or below | Ba1 or below | 0
Spreadsheet: 875616d1722219422-how-to-keep-a-drop-down-table-list-from-changing-drogersdk-excel-drop-down-list
Sheet: MASTER

 |  | To Do: Input ALL square footage then back into painting and flooring price per square foot.
 |  | Purchase Price | 515000
 |  | Total Budget | 100000
 |  | All-In
 |  | Money Spent
 |  | Current All-In
 |  |  | Budgeted | Actual
 |  | Total Spent
 |  | Percent Spent
 |  | Remaining
 |  | Master Budget
 |  | Materials | Budget Cost | Actual Cost | Difference
 | Exterior | Garage Roof
 |  | Apartment Roof
 |  | Gutters, soffit, fascia
 |  | Siding
 |  | Exterior Painting
 |  | Decks and Porches
 |  | Concrete
 |  | Garage
 |  | Landscaping
 | Interior | Demo
 |  | Plumbing
 |  | Electrical
 |  | HVAC
 |  | Framing
 |  | Insulation
 |  | Drywall
 |  | Carpentry
 |  | Interior Painting
 |  | Appliances
 |  | Cabinets, Countertops, Backsplash
 |  | Flooring
 |  | Permits
 |  | Misc
 |  | Total
 |  |  |  |  |  |  |  | 0
 |  | Labor
 | Exterior | Garage Roof |  | <-- how to get sumif to expand when I insert a row???
 |  | Apartment Roof
 |  | Gutters, soffit, fascia
 |  | Siding
 |  | Exterior Painting
 |  | Decks and Porches
 |  | Concrete
 |  | Garage
 |  | Landscaping
 | Interior | Demo
 |  | Plumbing
 |  | Electrical
 |  | HVAC
 |  | Framing
 |  | Insulation
 |  | Drywall
 |  | Carpentry
 |  | Interior Painting
 |  | Appliances
 |  | Cabinets, Countertops, Backsplash
 |  | Flooring
 |  | Permits
 |  | Misc
 |  | Total
Spreadsheet: 039325ac-fa38-4d0e-953a-cc2ef3891c85
Sheet: Sheet1

8th Portuguese Open - Application Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Country
 | School / Gym
 | Instructor
 | Telephone
 | E-mail
 | Kid Male
 | Name | Surname | Date of Birth (day/month/year) | Height (cm) | Weight (kg) | Grade (Kup/Dan) | Age | Pattern (yes/no) | Sparring (yes/no)
1
2
3
4
5
6
7
8
9
10
 | Kid Female
 | Name | Surname | Date of Birth (day/month/year) | Height (cm) | Weight (kg) | Grade (Kup/Dan) | Age | Pattern (yes/no) | Sparring (yes/no)
1
2
3
4
5
6
7
8
9
10
 | Junior Male
 | Name | Surname | Date of Birth (day/month/year) | Height (cm) | Weight (kg) | Grade (Kup/Dan) | Age | Pattern (yes/no) | Sparring (yes/no)
1
2
3
4
5
6
7
8
9
10
 | Junior Female
 | Name | Surname | Date of Birth (day/month/year) | Height (cm) | Weight (kg) | Grade (Kup/Dan) | Age | Pattern (yes/no) | Sparring (yes/no)
1
2
3
4
5
6
7
8
9
10
 | Senior Male
 | Name | Surname | Date of Birth (day/month/year) | Height (cm) | Weight (kg) | Grade (Kup/Dan) | Age | Pattern (yes/no) | Sparring (yes/no)
1
2
3
4
5
6
7
8
9
10
 | Senior Female
 | Name | Surname | Date of Birth (day/month/year) | Height (cm) | Weight (kg) | Grade (Kup/Dan) | Age | Pattern (yes/no) | Sparring (yes/no)
1
2
3
4
5
6
7
8
9
10
 | Umpire
 | Name | Surname | Degree
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 7c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 2429268 | 1209346 | 2036895 | 3025932 | 4072553 | 1861960 | 1252616 | 100068 | 15988638
Fixed-Float | 12760031 | 8374590 | 15630946 | 31873285 | 69259558 | 49866452 | 22816183 | 2301734 | 212882779
FRA | 35270857 | 12831087 | 12302280 | 3300931 | 220490 | - | - | - | 63925645
OIS | 15663362 | 6249658 | 6904824 | 5761751 | 2227447 | 426585 | 223905 | 20323 | 37477855
Swaption | 4046766 | 1874488 | 2885945 | 3967091 | 5020269 | 2508366 | 1140351 | 16121 | 21459397
OTHER* | 2711016 | 788441 | 1534007 | 2286724 | 4895634 | 4102516 | 2505825 | 196226 | 19020389
TOTAL | 72881300 | 31327610 | 41294897 | 50215714 | 85695951 | 58765879 | 27938880 | 2634472 | 370754703
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: john_griffith__15982__EOL_Swap_Option_BW_v2
Sheet: Options

 | Daily Summary for Options
 | Date and Time | Date | Call or Put | Strike Price | Buy or [NAME] | Volume | Price | Counter Party
 | 2001-06-11 11:40:48 | 2001-07-01 00:00:00 | EP | 28.5 | B | 50000 | 0.21 | Physical Oil
 | 2001-06-11 11:41:05 | 2001-07-01 00:00:00 | EP | 28.5 | B | 50000 | 0.21 | Physical Oil
 | 2001-06-11 13:59:42 | 2001-07-01 00:00:00 | EC | 29.5 | S | 50000 | 0.28 | Phibro Inc.
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 7d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 217918819 | 92791360 | 20005167 | 44207489
FRA | 96678721 | 9111921 | 7959195 | 3626812
OIS | 50600486 | 10157831 | 5619059 | 3551472
OTHER* | 10248322 | 64853505 | 1013488 | 19491236
TOTAL | 375446348 | 176914617 | 34596909 | 70877009
*OTHER variable includes the following products: Basis, Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: phillip_m_love__30654__9902_OA
Sheet: ONT_GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
REGION:  ONTARIO
REGION:  ONTARIO
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  | 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
23 | Fuel: |  |  |  |  |  |  |  | 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
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  | 15705 |  | 604295 |  |  |  |  |  |  |  |  |  | -990
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense |  |  |  |  |  |  |  | 0
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | -140148 |  | 0 |  |  |  | 140148 |  |  |  |  |  | -620000
 |  | TOTAL
FT-Ontario
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 132179 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 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
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3049 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 39750d1238027049-sumif-with-multiple-criterias-book1
Sheet: Sheet1

E | first and goad to HD | 10
J | hello sunshine | 10
I | HD going out | 10
F | define working capital | 10
H | doing all HD well | 10
B | signing a song | 10
E | for all you HD people | 10
B | HD can and will go HD | 10
* I will need a formula that will basically say this:  If column A ="E" and column B = "*HD*" then give me the sum of column C.
* please note that I cannot split out the words in column B
Spreadsheet: ab85b180-17e4-4b3b-8e87-8a57fd710d6d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FGAKM | Test | FGAKM | [NAME] (FGA) Gene, Known Mutation | [NAME], Known Mutation | Polymerase Chain Reaction (PCR) Followed by DNA Sequence Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | VACUTAINER: VAC |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.   [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Plasma or serum | An interpretive report will be provided. | Friday, 10 am | 10 days | 16 days | 1 | 81479 |  |  |  |  | Rochester
FGAKM | [NAME] | VARIES | Varies |  |  |  | Ambient
FGAKM | Result | 33481 | [NAME] | [NAME] | Alphanumeric
FGAKM | Result | 33482 | [NAME] | [NAME] | Alphanumeric
FGAKM | Result | 33483 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
FGAKM | Result | 33484 | Order Date | Order Date | Alphanumeric
FGAKM | Result | 33485 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
FGAKM | Result | 33486 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
FGAKM | Result | 33487 | Result | Result | Alphanumeric
FGAKM | Result | 33488 | Interpretation | Interpretation | Alphanumeric
FGAKM | Result | 33489 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FGAKM | Result | 33490 | Reviewed By | Reviewed By | Alphanumeric
FGAKM | Result | 33491 | Release Date | Release Date | Alphanumeric
Spreadsheet: tracy_geaccone__40496__2002 Plan Template
Sheet: EquityAffiliates

DETAIL of EQUITY (EARNINGS)/LOSSES & EQUITY/PARTNERSHIP DISTRIBUTIONS
(Millions of Dollars)
 |  | 2002 Activities
 |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
Equity (Earnings)/Losses
Investment |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Total (line 97)
Equity/Partnership Distributions
Investment |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Total (line 98)
Net Equity Earnings/Distributions
Spreadsheet: 702604d1604425201-to-bring-row-cell-data-in-column-data-sample-7-
Sheet: Bil

 |  |  |  |  | Order No |  | BH001
 |  |  |  |  | Name
 |  |  |  |  | Sr No | Product ID | Product No | Quantity | Unit Price | Total
Spreadsheet: 88407d1288229052-pivot-dividing-by-count-of-text-in-calculated-field-query
Sheet: PIVOT

AREA | CHANNEL | CLASS | Count of ASSET TYPE | SALES | THROUGHPUT | Column F should Look Like this
DCM 2 | ENTERTAINMENT AND LE | A | 30 | 14917.361333333 | 14917.361333333 | 497.2453777777667
 | ENTERTAINMENT AND LE Total |  | 30 | 14917.361333333 | 14917.361333333 | 497.2453777777667
DCM 2 Total |  |  | 30 | 14917.361333333 | 14917.361333333 | 497.2453777777667
Grand Total |  |  | 30 | 14917.361333333 | 14917.361333333 | 497.2453777777667