tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0f05b788-4497-4e9e-a8d7-71ed8a579a37
Sheet: 23

 |  | Transactions
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated swap transaction volumes, week ending November 30, by product type, participant type, and cleared status (in number of transactions), all tenors, currencies, and deliveries. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 118377d1313638842-matching-indexed-data-from-one-spreadsheet-to-another-example
Sheet: Records to Get

 |  |  | Record ID | [NAME] | Items to Get
 | 100 |  | 41000 | Record #1 | A
41000101 | 100 |  |  |  | B
41000102 | 100 |  |  |  | C
41000103 | 100 |  |  |  | D
41000104 | 100 |  |  |  | E
41000105 | 100 |  |  |  | F
41000106 | 100 |  |  |  | G
41000107 | 100 |  |  |  | H
41000108 | 100 |  |  |  | I
41005100 | 100 |  | 41005 | Record #2 | C
41005101 | 100 |  |  |  | B
41005102 | 100 |  |  |  | G
41005103 | 100 |  |  |  | J
111100100 | 100 |  | 111100 | Record #3 | A
111100101 | 100 |  |  |  | B
111100102 | 100 |  |  |  | D
Spreadsheet: 859605d1707931154-by-group-subtotal-groupby-sample-data-gk-1-
Sheet: Result

 |  | Account Name | Site | Core | Spend
 | ABC123 | The ABC Company | North | Non-Core | 6066.76
 | ABC123 | The ABC Company | North | Core | 69.41999999999999
 | Subtotal North |  |  |  | 6136.180000000001
 | ABC123 | The ABC Company | South | Non-Core | 38.51000000000001
 | ABC123 | The ABC Company | South | Core | 476.71
 | Subtotal South |  |  |  | 515.22
 | ABC123 | The ABC Company | East | Non-Core | 387.64
 | ABC123 | The ABC Company | East | Core | 85.61
 | Subtotal East |  |  |  | 473.25
 | ABC123 | The ABC Company | West | Core | 162.17
 | ABC123 | The ABC Company | West | Non-Core | 266.86
 | Subtotal West |  |  |  | 429.0300000000001
 | Grand Total |  |  |  | 7553.680000000005
Spreadsheet: 81253d1281486650-organizing-data-by-time-on-a-different-sheet-tourneyprogram
Sheet: Sheet2

Starting Time | Tee Number | Player 1 | Player 2 | Player 3 | Player 4
08:30:00 | 1
08:40:00 | 1 | [NAME] | Holmes, Doug |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ronhaar, [NAME] |  | [NAME], [NAME] |  | Clarke, Greg | Parsons, [NAME] | [NAME], [NAME] | Haugen, [NAME] |  | Course Slope= |  | Sorby, [NAME] |  | Burgess, Jim
08:50:00 | 1
09:00:00 | 1 | [NAME] | Bankhead, [NAME]
09:10:00 | 1
09:20:00 | 1 | Eastern, [NAME] | Sisson, [NAME]
09:30:00 | 1 | Fisher, [NAME] | Nakao, [NAME]
09:40:00 | 1 | [NAME], [NAME] | Colburn, [NAME]
09:50:00 | 1 | Likkel, [NAME] | [NAME], [NAME]
10:00:00 | 1
10:10:00 | 1 | Engstrom, [NAME] | [NAME], [NAME]
10:20:00 | 1
10:30:00 | 1 | Weil, [NAME] | McDowell, [NAME]
10:40:00 | 1
10:50:00 | 1 | Dworkis, Rich | Smith, [NAME]
11:00:00 | 1
11:10:00 | 1 | Fredrickson, [NAME]
11:20:00 | 1
11:30:00 | 1 | Primiani, [NAME]
11:40:00 | 1
11:50:00 | 1
12:00:00 | 1
12:10:00 | 1
08:30:00 | 10
08:40:00 | 10 | Campbell, [NAME] | Ronhaar, [NAME]
08:50:00 | 10
09:00:00 | 10 | Doherty, [NAME] | [NAME], [NAME]
09:10:00 | 10
09:20:00 | 10 | Clarke, Greg | [NAME], [NAME]
09:30:00 | 10 | Parsons, [NAME] | Dawson, [NAME]
09:40:00 | 10 | [NAME], [NAME] | [NAME], [NAME]
09:50:00 | 10 | Haugen, [NAME] | Fischer, [NAME]
10:00:00 | 10
10:10:00 | 10 | Course Slope= | Hunkapiller, [NAME]
10:20:00 | 10
10:30:00 | 10 | Sorby, [NAME] | Uno, Tosh
10:40:00 | 10
10:50:00 | 10 | Burgess, Jim | Alexander, Dennis
11:00:00 | 10
11:10:00 | 10
11:20:00 | 10
11:30:00 | 10
11:40:00 | 10
11:50:00 | 10
12:00:00 | 10
12:10:00 | 10
Spreadsheet: 124351d1318346365-trying-to-create-data-validation-for-2-different-options-excel-example_data-validation
Sheet: Sheet1

Item # | Quantity | Description | You will get |  |  | Item # | Description | Increments | Unit of Measure | Order in Increments of
 |  |  |  |  |  | 122094 | # 39 Brn Kraft, 12X15 Printed W/ Zip 78779-0001   (500 per box - order by box) | 500 | Boxes | 1
 |  |  |  |  |  | 130297 | # 38 Brn Kraft, 12X15 Printed No Zip (500 per box - order by box) | 500 | Boxes | 1
 |  |  |  |  |  | 142270 | VTR-22-A – Nonresident Sticker F/Move… | 1 | Each | 1
 |  |  |  |  |  | 142272 | VTR-71-1 – Auction Sales Receipt *Regions Only* (Order in increments of 100, Minimum order = 100) | 1 | Each | 100
 |  |  |  |  |  | 142304 | VTR-130-U – App. For [NAME]. Of Title  [Order in increments of 200 (min order = 200)] | 1 | Each | 200
 |  |  |  |  |  | 142347 | VTR-214 – App. For Disabled Person ID Placard & Or [Order in increments of 200 (minimum order = 200)] | 1 | Each | 200
 |  |  |  |  |  | 142772 | VTR-23-A – Temp Nonresident Sticker Pe… | 1 | Each | 1
Spreadsheet: 101294d1299454902-auto-sort-print-macro-example1
Sheet: Sheet1

Equipment | Quantity | Price | Total
Chair | 2 | 40 | 80
Table | 3 | 20 | 60
Desk | 4 | 30 | 120
Computer | 3 | 200 | 600
Phone | 2 | 10 | 20
Pencil | 9 | 3 | 27
Spreadsheet: 887723d1738054705-merging-data-from-multiple-workbooks-sorting-alphabetically-creating-new-workbooks-master-list-example
Sheet: P2 Phoneme to Grapheme

Rm | Surname | First Name | Write / Locate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Correct / 22
 |  |  | s | a | t | i | p | n | m | d | g | o | c | k | ck | e | u | r | h | b | f | l | ll | ss
Spreadsheet: 219339d1362726239-look-up-with-multiple-matches-propertiescompsample
Sheet: Contacts

ID | Contact | Contact Role | File As
2184810 | Leeds, [NAME] | Main Contact | (el Centro Apartments)
2184810 | [NAME], [NAME] | Other Contact | (el Centro Apartments)
2185037 | Kang, Grace | Main Contact | (the Studio)
2184709 | Tsvilik, Michael & Rachel | Main Contact | (villa Nova)
2184709 | Tsvilik, Michael & Rachel | Other Contact | (villa Nova)
2184748 | [NAME], Leo A | Main Contact | (Wilcox Plaza)
2181914 | Senatin, [NAME] | Main Contact | 1000 Coronado Ter
2181984 | Sue Y & Ralph N & Lew | Main Contact | 1000 [NAME]
2184155 | Maldonado, [NAME] | Main Contact | 1000 N Normandie Ave
2183975 | Rostami, Sohrab | Main Contact | 1000 N Oxford Ave
2182311 | Heffernan, [NAME] | Main Contact | 1000 W Edgeware Rd
2182249 | Firestone, Scott & Gia | Main Contact | 1000-1006 N Coronado St
2182291 | Bunchhoun, [NAME] | Main Contact | 1000-1006 W Kensington Rd
2183842 | Pelleg, Chaim & Dalia | Main Contact | 1001 Hyperion Ave
2184151 | [NAME] | Main Contact | 1001 N Alexandria Ave
2184226 | Ransford, [NAME] | Main Contact | 1001 N Berendo St
2184221 | [NAME], [NAME] | Main Contact | 1001 N Heliotrope Dr
2184090 | Tekeian [NAME] | Main Contact | 1001 N Normandie Ave
2185250 | Kevanian George & Sarkis | Main Contact | 1001 N Wilton Pl
2183845 | Bulosan, [NAME] | Main Contact | 1002 Sanborn Ave
2184143 | Petikyan Onik & Virginia | Main Contact | 1003 N Mariposa Ave
2184236 | Little, [NAME] | Main Contact | 1003 N New Hampshire Ave
2184225 | Ransford, [NAME] | Main Contact | 1005 N Berendo St
2183972 | Vogel, [NAME] | Main Contact | 1005-1009 N Serrano Ave
2182289 | Hernandez, [NAME] | Main Contact | 1006 Echo Park Ave
2184232 | Gallegos Herminia M | Main Contact | 1006 N Heliotrope Dr
2184732 | [NAME] | Main Contact | 1006 N Hudson Ave
2184239 | [NAME] | Main Contact | 1006 N New Hampshire Ave
2184738 | [NAME], Bianca | Main Contact | 1006 Wilcox Ave
Spreadsheet: 58104d1258416187-solver-add-in-not-iterating-poiseulles-viscosity-exp
Sheet: Red tube

height H (m) | time t (s) | mass m (kg) | volume V (m^3) | error in V | dV/dt | error dv/dt | expected dv/dt |  | Top/cm | Bottom/cm | D/cm | Mean | Stdev(D) | Sterror(D)
0.115 | 60 | 0.006099999999999994 | 6.111618186171907e-06 | 5.009524038994963e-08 | 1.018603031028651e-07 | 1.190636319926209e-09 | 1.038636e-07 |  | 4.14 | 4.239 | 0.0990000000000002 | 0.09849999999999995 | 0.002915475947422828 | 0.000921954445729345
0.105 | 60 | 0.005699999999999983 | 5.710856337898328e-06 | 5.009523920319464e-08 | 9.518093896497213e-08 | 1.151615504940382e-09 | 8.966999999999997e-08 |  | 4.137 | 4.24 | 0.1030000000000006
0.095 | 60 | 0.004199999999999982 | 4.207999406872446e-06 | 5.009523546944196e-08 | 7.013332344787409e-08 | 1.019150433394821e-09 | 7.547639999999999e-08 |  | 4.141 | 4.242 | 0.101
0.085 | 60 | 0.003799999999999998 | 3.807237558598894e-06 | 5.009523466486223e-08 | 6.345395930998157e-08 | 9.882832722222878e-10 | 6.128279999999998e-08 |  | 4.136 | 4.236 | 0.09999999999999964 |  | Mean  diameter (m) |  | 0.0009849999999999995
0.075 | 60 | 0.002799999999999997 | 2.805332937914973e-06 | 5.009523300541648e-08 | 4.675554896524955e-08 | 9.213596097355604e-10 | 4.708919999999999e-08 |  | 4.136 | 4.237 | 0.101 |  | Mean radius (m) |  | 0.0004924999999999998
 |  |  |  |  |  |  |  |  | 4.602 | 4.699 | 0.09699999999999953
 |  |  |  |  |  |  |  |  | 4.605 | 4.701 | 0.0959999999999992 |  | Error on radius (m) |  | 4.609772228646725e-06
 |  |  |  |  |  |  |  |  | 4.599 | 4.697 | 0.09799999999999986
 |  |  |  |  |  |  |  |  | 4.609 | 4.702 | 0.09299999999999997
 |  |  |  |  |  |  |  |  | 4.601 | 4.698 | 0.09700000000000042
 |  |  |  |  | error
 |  | temp degrees C |  | 21.5 |  |  |  |  | [NAME]
 |  | density (kg/m^3) |  | 998.099 | 0.005 |  |  |  | 2.830951205447064
 |  | mass of container (g) |  | 168.8 | 0.05 |  |  |  | 22.90003759918888
 |  | length of tube |  | 16 | 0.07 |  |  |  | 27.48566228504539
 |  |  |  |  |  |  |  |  | 4.826368672968185
 | LINEST | 1.419364879302217e-06 | -5.936284877552209e-08 |  |  | parameters |  |  | 0.1311374131413452
 |  | 1.502856931025888e-07 | 1.443446946066871e-08 |  |  | gradient | 1.41936e-06 | total | 58.17415717579087
 |  | gradient | intercept |  |  | intercept | -5.93628e-08
Spreadsheet: louise_kitchen__24044__Natural Gas Consolidated
Sheet: Derivatives

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays | 160000
 | Analyst & Associates | 414608.66
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 12
 | Analyst & Associate Headcount |  |  | 4
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
Spreadsheet: mary_hain__25833__4th qtr - 1999 FERC
Sheet: Exchange

 | 1999-10-01 00:00:00 | 1999-11-01 00:00:00 | 1999-12-01 00:00:00 | Total
Exchange Receipt
Hinson Power Company | 46190 | 0 | 0
Illinois Power Company | 0 | 0 | 0
[NAME] | 2980 | 2880 | 2976
Washington Water & Power | 0 | 0 | 0
Total
Exchange Delivery
Hinson Power Company | -46190 | 0 | 0
Illinois Power Company | 0 | 0 | 0
[NAME] | -2980 | -2880 | -2976
Washington Water & Power | 0 | 0 | 0
Total
Spreadsheet: 103d0210-8e01-42f2-a031-fcd72de00869
Sheet: Sheet1

Course Abbreviations Key:
BLS - Basic Life Support (CPR)
ACLS - Advanced Cardiac Life Support
PALS - Pediatric Advanced Life Support
NRP - Neonatal Resuscitation Program
PLEASE NOTE: Current BLS is required for all house staff (even if you already hold a current ACLS, PALS, or NRP card).
Department | Course Requirements
Anesthesiology | BLS, ACLS, PALS, NRP
Anesthesiology | BLS, ACLS, PALS, NRP
Cardiothoracic | BLS, ACLS, PALS, NRP
[NAME] | BLS, ACLS, PALS, NRP
Pain Management | BLS, ACLS, PALS
[NAME] | BLS, ACLS, (PALS encouraged)
Dentistry | BLS, ACLS, (PALS encouraged)
Dermatology | BLS, ACLS, (PALS encouraged)
Emergency Medicine Programs | BLS, ACLS and/or PALS, (NRP encouraged)
Emergency Medicine | BLS, ACLS, PALS
Pediatric Emergency Medicine | BLS, ACLS, PALS
Family Medicine Programs | BLS, ACLS, PALS, (NRP encouraged)
Family Medicine | BLS, ACLS, PALS, NRP
Family Medicine/Sports Medicine | BLS, ACLS
General [NAME] | BLS, ACLS, (PALS encouraged)
Abdominal Transplant/Kidney | BLS, ACLS
Internal Medicine Programs | BLS, ACLS
Internal Medicine | BLS, ACLS
Allergy & Immunology | BLS, ACLS
Cardiology | BLS, ACLS
Clinical Cardiac Electrophysiology | BLS, ACLS
Critical Care | BLS, ACLS
Endocrinology | BLS, ACLS
Gastroenterology | BLS, ACLS
Gerontology | BLS, ACLS
Hematology/Oncology | BLS, ACLS
Infectious Disease | BLS, ACLS
Interventional Cardiology | BLS, ACLS
Nephrology | BLS, ACLS
Palliative Care | BLS, ACLS
[NAME] | BLS, ACLS
Rheumatology | BLS, ACLS
Neurology Programs | BLS, ACLS
[NAME] | BLS, ACLS
Clinical Neurophysiology | BLS, ACLS
[NAME] | BLS, ACLS, PALS
[NAME] | BLS, ACLS
Sleep Medicine | BLS, ACLS, PALS
[NAME] | BLS, ACLS
Neurosurgery | BLS, ACLS, (PALS encouraged)
Nuclear Radiology | BLS, ACLS
Obstetrics & Gynecology | BLS, ACLS, NRP
Maternal -Fetal Health | BLS, ACLS, NRP
Ophthalmology | BLS, ACLS, (PALS encouraged)
[NAME] | BLS, ACLS, (PALS encouraged)
Orthopedics | BLS, ACLS, (PALS encouraged)
Orthopedics/Hand | BLS, ACLS, (PALS encouraged)
Orthopedics/Sports Medicine | BLS, ACLS, (PALS encouraged)
Otolaryngology | BLS, ACLS, (PALS encouraged)
Pathology Programs | BLS
Pathology | BLS
Cytopathology | BLS
Dermatopathology | BLS
Forsenic Pathology | BLS
Hematopathology | BLS
Pediatric Programs | BLS, PALS, NRP, (ACLS encouraged)
Pediatrics | BLS, PALS, NRP, (ACLS encouraged)
Neonatology | BLS, NRP, PALS
Plastic Surgery | BLS, ACLS, (PALS encouraged)
Psychiatry Programs | BLS, ACLS
Adult | BLS, ACLS
Child & Adolescent | BLS, PALS, (ACLS encouraged)
Radiation Oncology | BLS, ACLS, (PALS encouraged)
Radiology Programs | BLS, ACLS, (PALS encouraged)
Radiology/Diagnostic | BLS, ACLS, (PALS encouraged)
Abdominal Imaging | BLS, ACLS, (PALS encouraged)
Musculoskeletal Radiology | BLS, ACLS, (PALS encouraged)
Neuroradiology | BLS, ACLS, (PALS encouraged)
Surgical Critical Care | BLS, ACLS
Urology | BLS, ACLS, (PALS encouraged)
Vascular Surgery | BLS, ACLS, (PALS encouraged)
Spreadsheet: 193215d1352755505-visual-colourful-skill-matrix-visualskillmatrix
Sheet: Sheet1

 | Skill 1
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Current Skill
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Fred |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Over Qualified
Name | Skill |  |  |  | Target |  |  |  | Actual
[NAME] | Skill 1 |  |  |  | 3 |  |  |  | 2
[NAME] | Skill 1 |  |  |  | 3 |  |  |  | 3
Fred | Skill 1 |  |  |  | 4 |  |  |  | 1
[NAME] | Skill 2 |  |  |  | 4 |  |  |  | 4
[NAME] | Skill 2 |  |  |  | 2 |  |  |  | 4
Fred | Skill 2 |  |  |  | 4 |  |  |  | 3
[NAME] | Skill 3 |  |  |  | 4 |  |  |  | 4
[NAME] | Skill 3 |  |  |  | 3 |  |  |  | 3
Fred | Skill 3 |  |  |  | 4 |  |  |  | 1
[NAME] | Skill 4 |  |  |  | 4 |  |  |  | 4
[NAME] | Skill 4 |  |  |  | 2 |  |  |  | 4
Fred | Skill 4 |  |  |  | 4 |  |  |  | 1
 | Skill 1
[NAME]
[NAME]
Fred
Spreadsheet: 180375d1347570688-advanced-filter-results-dont-match-auto-filter-demo
Sheet: Combined Checklist

Y - ? - N | Code | Strategies | Scope | Tenant Improvements | Infrastructure Replacement | Cost | Difficulty | Benefit
 |  |  | ^
 |  |  | ^^
 |  |  | ^^^
 |  |  | ^ ^
 |  |  | ^^ ^^
 |  |  | ^^^ ^^^
 |  |  | ^ ^ ^
 |  |  | ^ ^^ ^
 |  |  | ^ ^^^ ^
 |  |  | ^^ ^ ^^
 |  |  | ^^ ^^ ^^
 |  |  | FireSuppr
Y - ? - N | Code | Strategies | Scope | Tenant Improvements | Infrastructure Replacement | Cost | Difficulty | Benefit
 | [NAME] | Use materials manufactured within 500 miles of site | Struct, Envl, Constr, Finish, Furnish | Constr, Finish, Furnish | Struct, Envl, Constr, Finish, Furnish | Low | Low | Very Good
 | C.1.2.A | Phase out CFCs in existing buildings and replace with new equipment or refrigerants | HVAC, FireSuppr |  | HVAC, FireSuppr | Low | Low | Very Good
 | C.1.2.C | Select new HVAC, refrigeration and fire suppression equipment with refrigerants that have low ozone depleting potential & low global warming potential | S&E, HVAC, FireSuppr |  | S&E, HVAC, FireSuppr | Low | Low | Very Good
 | M.2.1.A | Implement Construction Waste Management Plan | Demo, Site, Struct, Envl, Constr, Finish, S&E, Furnish, HVAC, Plumb, E&C, FireSuppr | Demo, Site, Struct, Envl, Constr, Finish, S&E, Furnish, HVAC, Plumb, E&C, FireSuppr | Demo, Site, Struct, Envl, Constr, Finish, S&E, Furnish, HVAC, Plumb, E&C, FireSuppr | Low | Low | Very Good
 | M.2.2.A | Designate convenient and appropriately sized recycle collection and storage | Constr, Finish, S&E, Furnish | Constr, Finish, S&E, Furnish | Constr, Finish, S&E, Furnish | Low | Low | Good
 | M.3.1.A | Retain a high percentage of interior elements of existing building | Struct, Constr, Finish, Furnish | Constr, Finish, Furnish | Struct, Constr, Finish | Low | Med | Very Good
 | [NAME] | Retain a high percentage of structural components of existing building | Struct | Struct | Struct | Low | Low | Very Good
 | IE.1.1.A | Use low-emitting adhesives & sealants | Struct, Envl, Constr, Finish | Struct, Envl, Constr, Finish | Struct, Envl, Constr, Finish | Low | Low | Good
 | IE.1.1.B | Use low-emitting paints & coatings | Constr, Finish | Constr, Finish | Constr, Finish | Low | Low | Good
 | IE.1.1.C | Use low-emitting systems furniture & seating | Furnish | Furnish |  | Low | Low | Good
Spreadsheet: 802046d1666616766-if-count-and-results-without-empty-spaces-formula-count-result-without-empty-cells
Sheet: Sheet1

 |  | expected results | incomplete formula
14 | 3 | 14
 | 14 | 23
23 |  | 1
 | 27
1 | 23
 | 6
 | 1
 | 17
 | 5
Spreadsheet: 679922d1590683895-sumproduct-across-multiple-rows-columns-criteria-test-workbook
Sheet: Sheet2

 |  |  |  |  |  |  |  | Funding Received in the Trailing Three Months
Draw Date | 2020-01-10 00:00:00 | 2020-02-20 00:00:00 | 2020-03-04 00:00:00 | 2020-04-16 00:00:00 | 2020-05-22 00:00:00
[NAME] | 241459.31 | 66523.82 | 64772.76 | 223801.17 | 635761.86
CM Fee | 15796.41 | 4352.03 | 3874.59 | 21251.56 | 41591.9 |  |  | Column A will always be in same order with the funding received one column below the funding date.
Funding Date | 2020-02-11 00:00:00 | 2020-03-04 00:00:00 | 2020-03-04 00:00:00 | 2020-04-16 00:00:00 | 2020-05-22 00:00:00 |  |  | I need to sum all the funding received amounts by funding date into the corresponding month.
Funding Received | 241459.31 | 66523.82 | 64772.76 | 223801.17 | 635761.86
Date CM Fee Paid | 2020-02-06 00:00:00 | 2020-03-05 00:00:00 | 2020-03-05 00:00:00 | 2020-04-16 00:00:00 | 2020-05-25 00:00:00 |  |  | 414805.25 | 578799.39 | 335199.85
Draw Date | 2020-01-28 00:00:00 |  |  | 2020-04-16 00:00:00
[NAME] | 93740.54 |  |  | 442333.26
CM Fee | 6132.56 |  |  | 28904.73
Funding Date | 2020-02-14 00:00:00 |  |  | 2020-05-13 00:00:00
Funding Received | 93740.54 |  |  | 440333.26
Date CM Fee Paid | 2020-02-14 00:00:00 |  |  | 2020-05-15 00:00:00
Draw Date |  | 2020-02-24 00:00:00 |  | 2020-04-02 00:00:00 | 2020-05-21 00:00:00
[NAME] |  | 448032.81 |  | 191504.08 | 136611.62
CM Fee |  | 29310.56 |  | 12528.3 | 8937.21
Funding Date |  | 2020-03-11 00:00:00 |  | 2020-04-29 00:00:00 | Pending
Funding Received |  | 447502.81 |  | 191004.08
Date CM Fee Paid |  | 2020-03-12 00:00:00 |  | 2020-04-29 00:00:00
Spreadsheet: 1689422a-e780-484b-9729-ba4309c4dab1
Sheet: Sheet1

Reg No. | Name | [NAME] | Tag | Tattoo | CED | CED Acc | BW | BW Acc | WW | WW Acc | YW | YW Acc | YH | YH Acc | Doc | Doc Acc | CEM | CEM Acc | Milk | Milk Acc | $EN | CW | CW Acc | Marb | Marb Acc | RE | RE Acc | Fat | Fat Acc | Wean Value($W) | Feedlot Value($F) | Grid Value ($G) | [NAME]) | Quality Grade($QG) | [NAME])
17133020 | NU Unique 1025Y | 2011-03-05 00:00:00 | 1025 | 1025Y | 10 | 0.2 | -0.9 | 0.33 | 38 | 0.22 | 80 | 0.2 | -0.2 | 0.34 | 10 | 0.26 | 9 | 0.09 | 16 | 0.11 | 7.590779 | 18 | 0.1 | 0.31 | 0.15 | 0.2 | 0.16 | 0.014 | 0.12 | 23.67 | 24.8 | 22.15 | 48.91 | 18.82 | 3.33
17133021 | UN Mainline 1044Y | 2011-03-09 00:00:00 | 1044 | 1044Y | 14 | 0.23 | -2.8 | 0.34 | 45 | 0.24 | 91 | 0.22 | -0.1 | 0.36 | -1 | 0.29 | 14 | 0.09 | 19 | 0.12 | -0.152039 | 28 | 0.12 | 0.48 | 0.17 | 0.2 | 0.18 | 0.036 | 0.14 | 28.12 | 33.62 | 23 | 59.14 | 25.04 | -2.04
17133022 | NU Mainline 1048Y | 2011-03-11 00:00:00 | 1048 | 1048Y | 8 | 0.23 | -0.2 | 0.34 | 49 | 0.24 | 88 | 0.22 | 0.5 | 0.35 | 3 | 0.28 | 9 | 0.09 | 20 | 0.12 | -0.800674 | 29 | 0.11 | 0.38 | 0.16 | 0.19 | 0.18 | 0.017 | 0.14 | 29.82 | 28.73 | 21.86 | 58.32 | 21.48 | 0.38
17133023 | NU Mainline 1071Y | 2011-03-16 00:00:00 | 1071 | 1071Y | 9 | 0.21 | 0 | 0.34 | 45 | 0.23 | 83 | 0.21 | 0.1 | 0.36 | 6 | 0.29 | 9 | 0.08 | 16 | 0.11 | 6.085762 | 22 | 0.09 | 0.37 | 0.15 | -0.15 | 0.16 | 0.019 | 0.12 | 27.35 | 25.1 | 17.14 | 47.8 | 21.07 | -3.93
17133024 | NU Mainline 1138Y | 2011-04-02 00:00:00 | 1138Y | 1138Y | 8 | 0.23 | 0.3 | 0.34 | 45 | 0.24 | 82 | 0.22 | 0.2 | 0.35 | 0 | 0.28 | 11 | 0.1 | 20 | 0.13 | 1.87604 | 25 | 0.12 | 0.15 | 0.17 | 0.03 | 0.19 | 0.004 | 0.15 | 28.51 | 24.06 | 12.57 | 45.61 | 12.01 | 0.56
17133025 | NU Unique 1142Y | 2011-04-02 00:00:00 | 1142 | 1142Y | 3 | 0.19 | 2.8 | 0.32 | 43 | 0.21 | 81 | 0.19 | 0.4 | 0.33 | -7 | 0.26 | 4 | 0.07 | 19 | 0.1 | 3.165375 | 20 | 0.08 | 0.43 | 0.13 | 0.01 | 0.15 | 0.021 | 0.11 | 22.25 | 23.83 | 22.34 | 50.97 | 23.33 | -0.99
17133026 | NU Unique 1026Y | 2011-03-05 00:00:00 | 1026 | 1026Y | 10 | 0.2 | 0.4 | 0.33 | 34 | 0.22 | 71 | 0.2 | 0 | 0.34 | 12 | 0.27 | 10 | 0.09 | 14 | 0.11 | 12.986849 | 13 | 0.1 | 0.35 | 0.15 | -0.19 | 0.16 | 0.005 | 0.13 | 21.26 | 17.21 | 20.2 | 41.36 | 20.43 | -0.23
17133027 | NU Mainline 1105Y | 2011-03-23 00:00:00 | 1105 | 1105Y | 14 | 0.22 | -2.2 | 0.34 | 49 | 0.23 | 88 | 0.21 | 0.1 | 0.36 | -3 | 0.28 | 14 | 0.08 | 17 | 0.11 | 3.033878 | 23 | 0.1 | 0.46 | 0.15 | -0.09 | 0.16 | 0.01 | 0.12 | 31.39 | 28.73 | 22.58 | 54.02 | 24.37 | -1.79
Spreadsheet: 842681d1694694359-extract-data-from-rows-to-column-order-file-aligw
Sheet: Output

Acct No | Qty | Price
M1 | 2 | 2 |  |  | 2 | 2
M4 | 3 | 1 |  | M4 | 3 | 1
M5 | 2 | 3 |  | M5 | 2 | 3
M2 | 5 | 1 |  | M2 | 5 | 1
M3 | 2 | 6 |  | M3 | 2 | 6
M1 | 3 | 3 |  | M1 | 3 | 3
M2 | 2 | 1 |  | M2 | 2 | 1
M3 | 3 | 1 |  | M3 | 3 | 1
M4 | 1 | 1 |  | M4 | 5 | 1