tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 71018d1271773371-validation-load-error-on-trying-to-publish-an-excel-spreadsheet-sample-worksheet
Sheet: Sheet1

Month | Classification | Item
2010-03-01 00:00:00 | Frequent | E
 |  |  | 2010-01-01 00:00:00 | Regular | A
 |  |  | 2010-02-01 00:00:00 | Frequent | B
 |  |  | 2010-03-01 00:00:00 | Isolated | C
 |  |  | 2010-04-01 00:00:00 |  | D
 |  |  | 2010-05-01 00:00:00 |  | E
 |  |  | 2010-06-01 00:00:00 |  | F
 |  |  | 2010-07-01 00:00:00 |  | G
 |  |  | 2010-08-01 00:00:00
 |  |  | 2010-09-01 00:00:00
 |  |  | 2010-10-01 00:00:00
 |  |  | 2010-11-01 00:00:00
 |  |  | 2010-12-01 00:00:00
 |  |  | 2011-01-01 00:00:00
 |  |  | 2011-02-01 00:00:00
 |  |  | 2011-03-01 00:00:00
 |  |  | 2011-04-01 00:00:00
 |  |  | 2011-05-01 00:00:00
 |  |  | 2011-06-01 00:00:00
 |  |  | 2011-07-01 00:00:00
 |  |  | 2011-08-01 00:00:00
 |  |  | 2011-09-01 00:00:00
 |  |  | 2011-10-01 00:00:00
 |  |  | 2011-11-01 00:00:00
 |  |  | 2011-12-01 00:00:00
Spreadsheet: 80086d1280313309-pivot-table-with-calculated-field-p-table-example
Sheet: Pivot Table

Current Pivot Table
 | Data | Forecast dataset
 | Sum of July |  | Sum of August |  | Sum of Sept |  | Sum of Oct |  | Sum of Nov |  | Total Sum of July | Total Sum of August | Total Sum of Sept | Total Sum of Oct | Total Sum of Nov
Account | July Forecast | June Forecast | July Forecast | June Forecast | July Forecast | June Forecast | July Forecast | June Forecast | July Forecast | June Forecast
Cost of Sales | 350 | 332 | 410 | 412 | 260 | 256 | 300 | 317 | 370 | 352 | 682 | 822 | 516 | 617 | 722
Payroll | 710 | 700 | 700 | 700 | 690 | 700 | 700 | 700 | 700 | 700 | 1410 | 1400 | 1390 | 1400 | 1400
Sales | 1700 | 1550 | 1560 | 1560 | 990 | 990 | 1350 | 1320 | 1560 | 1550 | 3250 | 3120 | 1980 | 2670 | 3110
Sundries | 1 | 1 | 2 | -5 | 4 | 4 | 11 | 3 | 19 | 19 | 2 | -3 | 8 | 14 | 38
Travel | 55 | 55 | 45 | 50 | 102 | 102 | 40 | 40 | 50 | 52 | 110 | 95 | 204 | 80 | 102
Grand Total | 2816 | 2638 | 2717 | 2717 | 2046 | 2052 | 2401 | 2380 | 2699 | 2673 | 5454 | 5434 | 4098 | 4781 | 5372
Desired End State (but as a dynamic pivot table)
 | Data | Forecast dataset
 | Sum of July |  |  | Sum of August
Account | July Forecast | June Forecast | July less June | July Forecast | June Forecast | July less June
Cost of Sales | 350 | 332 | 18 | 410 | 412 | -2 | etc
Payroll | 710 | 700 | 10 | 700 | 700 | 0
Sales | 1700 | 1550 | 150 | 1560 | 1560 | 0
Sundries | 1 | 1 | 0 | 2 | -5 | 7
Travel | 55 | 55 | 0 | 45 | 50 | -5
Grand Total | 2816 | 2638 | 178 | 2717 | 2717 | 0
Spreadsheet: 3098f3f4-24f8-4131-b876-fd9e6e7dde59
Sheet: Sheet1

 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | GYRATORY MIXING AND COMPACTION TEMPERATURES
As of August, 19 2010
 | SUPPLIER RECOMMENDATIONS |  |  |  |  | 2010
 |  |  |  |  |  | Shipping
UDOT APPROVED | BINDER | MIXING | COMPACTION | SPECIFIC | Lbs. per [NAME] | Approval ??
SUPPLIER | GRADE | TEMP. °F | TEMP. °F | GRAVITY, 60.0°F | at  60.0°F
[NAME] | PG58-22
[NAME] | PG58-28
[NAME] | PG64,-28 | 313 - 325 | 279 - 297 | 1.032 | 8.6124573408 | Yes
[NAME] | PG64,-34 | 316 - 329 | 284 - 302 | 1.028 | 8.579075723199999 | Yes
[NAME] | PG70,-28 | 318 - 331 | 284 - 302 | 1.034 | 8.6291481496 | Yes
[NAME] | PG58,-34 | 306 - 320 | 275 - 293 | 1.024 | 8.545694105599999 | Yes
[NAME] | [NAME] | 295 - 305 | 275 - 283 | 1.034 | 8.6291481496 | Yes
Ergon | [NAME] | 292-304 | 269-279 | 1.0305 | 8.599939234199999 | Yes
Ergon | PG58,-34 | 290-305 | 275-290 | 1.026 | 8.562384914399999 | Yes
Ergon | PG64,-28 | 298-315 | 287-302 | 1.0291 | 8.588255668039999 | Yes
Ergon | PG64,-34 | 290-305 | 275-290 | 1.026 | 8.562384914399999 | Yes
Ergon | PG64,-34S | 300-315 | 285-300 | 1.0226 | 8.534010539439999 | Yes
Ergon | PG70,-28S | 310-325 | 295-310 | 1.0278 | 8.57740664232 | Yes
Staker Parsons | [NAME] | 298-309 | 278-285 | 1.021 | 8.5206578924 | Yes
Staker Parsons | PG58,-34 | 306-313 | 286-294 | 1.011 | 8.4372038484 | Yes
Staker Parsons | PG64,-28 | 313-325 | 290-300 | 1.029 | 8.587421127599999 | Yes
Staker Parsons | PG64,-34 | 306-313 | 286-294 | 1.011 | 8.4372038484 | Yes
Staker Parsons | PG70,-28 | 318-326 | 297-305 | 1.021 | 8.5206578924 | Yes
Idaho Asphalt Supply | PG58,-34 | 306 - 320 | 275 - 293 | 1.024 | 8.545694105599999 | Yes
Idaho Asphalt Supply | PG64,-28 | 313 - 325 | 279 - 297 | 1.032 | 8.6124573408 | Yes
Idaho Asphalt Supply | PG64,-34 | 316 - 329 | 284 - 302 | 1.028 | 8.579075723199999 | Yes
Idaho Asphalt Supply | PG70,-28 | 318 - 331 | 284 - 302 | 1.034 | 8.6291481496 | Yes
Idaho Asphalt Supply | [NAME] | 295 - 305 | 275 - 283 | 1.034 | 8.6291481496 | Yes
Mountain States Asphalt | [NAME] | 300-312 | 280-290 | 1.035 | 8.637493553999999 | Yes
Mountain States Asphalt | PG64,-22 | 312-325 | 291-302 | 1.043 | 8.704256789199999 | Yes
Mountain States Asphalt | PG64,-34 | 310-320 | 285-295 | 1.026 | 8.562384914399999 | Yes
Suncor | PG58,-34 |  |  | 1.034 | 8.6291481496 | Yes
Suncor | PG64,-28 | 313-321 | 292-300 | 1.031 | 8.604111936399999 | Yes
Suncor | PG64,-34 | 301-309 | 281-289 | 1.025 | 8.554039509999999 | No
Suncor | PG76,-28 | 321-329 | 300-308 | 1.027 | 8.570730318799999 | Yes
Paramount (Frenley, NV) | PG58,34 | 329-339 | 311-319 | 1.012 | 8.4455492528 | Yes
Paramount (Frenley, NV) | PG64,-34 | 328-338 | 308-317 | 1.0115 | 8.4413765506 | Yes
Paramount (Frenley, NV) | PG64,-22 | 302-312 | 283-291 | 1.028 | 8.579075723199999 | Yes
Paramount (Frenley, NV) | [NAME] | 283-292 | 265-273 | 1.031 | 8.604111936399999 | Yes
Paramount (Frenley, NV) | PG64,-28UT | 321-330 | 302-310 | 1.0222 | 8.53067237768 | Yes
Paramount  (LA, CA) | PG 70-28 | 317-328 | 280-284 | 1.024 | 8.545694105599999 | Yes
Spreadsheet: 161328d1339499822-excel-2007-i-need-a-formula-which-when-dates-match-transfer-the-data-from-the-entire-row-data-transfer
Sheet: 1st Time period

 |  | 2012-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holidays11
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-06 00:00:00 | Fixed Date | 2
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-27 00:00:00 | Non Fixed Date | 3
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-25 00:00:00 | Fixed Date | 4
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-13 00:00:00 | Non Fixed Date | 5
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-16 00:00:00 | Non Fixed Date | 6
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00 | Fixed Date | 7
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-04 00:00:00 | Non Fixed Date | 8
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-15 00:00:00 | Fixed Date | 9
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-28 00:00:00 | Fixed Date | 10
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-24 00:00:00 | Fixed Date | 11
 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-25 00:00:00 | Fixed Date | 12
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-26 00:00:00 | Fixed Date | 13
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
Spreadsheet: sally_beck__35758__MgmtSum-Q1-0313
Sheet: Summary

ENRON NORTH AMERICA
1ST QUARTER 2000 EARNINGS ESTIMATE
Results based on Activity through March 10, 2000
 |  | Plan |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Margin | Expenses* | EBT |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
Gas Trading
Power Trading
Financial Drift
Financial Trading
Canada
Coal
Weather
Emissions
Insurance Group
Executive Trading
Total Trading & Risk Mgt.
East Midstream
West Midstream
Industrial Downstream - Paper
Industrial Downstream - Chemicals
Midstream IPP
Mexico
Executive Origination
Total Origination
Genco
Generation Investments
Gas Assets
Gas Assets - Trading
Total Assets
Principal Investing
Upstream E&P
Investment Management
Restructuring
Canada - Investing
Total Investing
Commercial Transactions Group
Office of the Chairman
Total Commercial
Group |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other Interest Related Charges
Capital Charge Offset
Overview |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
ENA EBIT
Interest Expense/(Income) |  |  | 12000 |  |  |  |  |  |  |  |  | 1500
[NAME]
 |  |  |  | MPR Change:
* Includes Capital Charge & Operating, Direct, and Allocated Expenses
Spreadsheet: 881810d1730010026-why-is-small-not-returning-only-one-value-even-with-unique-attached-test-book
Sheet: Sheet1

Account List | Dates
A22.8UE | 2024-10-24 00:00:00 |  | Account
A22.8UE | 2024-10-25 00:00:00 |  | A22.8UE
A24.TA4 | 2024-10-26 00:00:00
A24.TA4 | 2024-10-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
A22.8UE | 2024-10-28 00:00:00 |  | Result |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
A23.9BB | 2024-10-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
A23.9BB | 2024-10-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
A23.9BB | 2025-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
A24.TA4 | 2025-01-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
A22.8UE | 2025-01-07 00:00:00
A24.TA4 | 2025-01-08 00:00:00
A23.9BB | 2025-01-09 00:00:00
Spreadsheet: 124917d1318717458-ge-discription-from-numbers-get-description-from-number
Sheet: Invoice

Cash
Check |  |  |  |  |  |  |  |  |  |  | PO NO. | 01
Credit
Other
 |  |  | 123 Where ever Road |  |  |  |  |  |  | PURCHASE ORDER
 |  | SUPPLIER |  |  |  |  |  |  |  |  | Misc
 |  | Name | The Other Guy |  |  |  |  |  | DATE |  | DATE
 |  | Address
 |  | City |  | Prov. |  |  |  |  |  |  | PURCHASER | V.Morrison
 |  | Phone
 |  |  |  |  |  |  |  |  | Delivery Date
 |  | ITEM NO. | [NAME] |  |  |  |  |  |  | QTY | UNIT PRICE | TOTAL
 |  | 400 |  |  |  |  |  |  |  | 100
 |  | 500 |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  |  |  |  | SubTotal
 |  |  |  |  |  |  |  |  |  |  | Shipping
 |  | Payment | Check |  |  |  |  |  | Tax Rate(s) |  | 0.07
 |  |  |  |  |  |  |  |  |  |  | 0.05
 |  | Comments |  |  |  |  |  |  |  |  | TOTAL
 |  | Name
 |  | CC # |  |  |  |  |  |  | Office Use Only
 |  | Expires
 |  | COMMENTS:
 |  |  | We thank you for your business
Spreadsheet: 80911d1281059739-chart-showing-actuals-vs-3-targets-chart-showing-act-v-target
Sheet: Sheet1

TARGETS | Min | Target | Stretch |  | Actuals | Daily
Monday | 5 | 10 | 15 |  | Monday | 7
Tuesday | 5 | 10 | 15 |  | Tuesday | 7
Wednesday | 5 | 10 | 15 |  | Wednesday | 12
Thursday | 5 | 10 | 15 |  | Thursday | 8
Friday | 5 | 10 | 15 |  | Friday | 6
Saturday | 5 | 10 | 15 |  | Saturday | 5
Sunday | 5 | 10 | 15 |  | Sunday | 5
Monday | 5 | 10 | 15 |  | Monday | 5
Tuesday | 5 | 10 | 15
Wednesday | 5 | 10 | 15
Thursday | 5 | 10 | 15
Total | 40 | 80 | 120 |  | Total | 55
 | 40 | 80 | 120 |  |  | 0
 | 40 | 80 | 120 |  |  | 55
 |  |  |  |  |  | 0
Spreadsheet: sally_beck__33873__EGM_MgmtSum-Q4-1214
Sheet: QTD Mgmt Summary

Enron Global Markets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4TH QTR 2000 EARNINGS ESTIMATE
 |  | Margin |  |  |  | Expenses (1) |  |  |  | EBIT |  |  |  | Weekly Change - Fav / (Unfav)
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Margin | Expenses (1) | Total
Liquids
Coal
Emissions
Weather
Global Risk Markets
Financial Trading
Transportation
Overview |  |  |  |  |  | 0 | 0
Office of the Chairman
Subtotal Commercial
LNG
Middle East
Puerto Rico
Subtotal LNG / ME / PR
Total Commercial
Group Support Cost |  | 0 | 0
Support Cost Allocated to Teams |  | 0 | 0
Other Interest Related Charges
Capital Charge Offset
Global Markets EBIT
Interest Expense/(Income)
Global Markets Pre-tax Income
(1) Includes Capital Charge & Operating, Direct, and Allocated Expenses
 |  | Margin change from: 10/26/00 |  |  |  | Expense changes from: 10/26/00
 |  | DPR Change |  |  |  | Operating Expense
 |  | MPR Change |  |  |  | Commercial Expense
 |  | Other Margin Changes |  |  |  | Other
 |  | Total Change |  |  |  | Total Change
 |  | Total Margin - QTD |  |  |  | Total Expense
 |  | Prior Week: |  |  |  | Prior Week:
 |  | This Week: |  |  |  | This Week:
 |  | Change: |  |  |  | Change:
Spreadsheet: 693201d1598858141-how-to-apply-filter-formula-for-multiple-conditions-copy-of-processing-efficiency
Sheet: fh

 | SS LOOMTEX
Spreadsheet: 37609d1235658217-find-and-sum-based-on-criteria-bok2
Sheet: Ark1

Line | Product | Amount
1 | 3 | 605
1 | 4 | 15375
1 | 14 | 1789
1 | 23 | 10
1 | 31 | 0
1 | 67 | 4025
2 | 3 | 581918.4
2 | 4 | 944001.8
2 | 6 | 1245
2 | 10 | 4460
2 | 13 | 1432
2 | 14 | 81357
2 | 23 | 3624
2 | 31 | 0
2 | 43 | 1122
2 | 44 | 225
2 | 53 | 14385.6
2 | 54 | 1632
2 | 66 | 9440
2 | 67 | 3845
2 | 70 | 1435
2 | 75 | 4285
2 | 80 | 800
2 | 114 | 51100
2 | 115 | 18630
5 | 3 | 28513
5 | 4 | 86474.4
5 | 14 | 7713
5 | 23 | 150
5 | 31 | 0
5 | 53 | 3480
5 | 66 | 2410
5 | 67 | 9185
5 | 69 | 685
5 | 70 | 2410
6 | 3 | 8543
6 | 4 | 485
6 | 14 | 269
6 | 23 | 50
6 | 53 | 168
1 | 3 | 880
1 | 4 | 9430
1 | 13 | 825
1 | 14 | 1266
1 | 31 | 0
1 | 67 | 980
Products that not shall be included.
3
23
31
 |  |  |  | Line | [NAME]/out excluded products
1. I. E: How to sum all the Line 1 amounts except product 3,23 and 31. |  |  |  | 1 | 33690
2. I.E How to sum only product 66 |  |  |  |  | 11850
Spreadsheet: 271721d1382027346-get-the-top-5-values-and-associated-names-deals-data
Sheet: Management - Snapshot

 | Lifetime | No. of Deals
 | [NAME] | Won | Lost | Pending | Won % | Lost % | Pending %
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  | 1 |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Over Alll Sales Funnel
 | Lifetime | No. of Deals
 | [NAME] | Won | Lost | Pending | Won % | Lost % | Pending %
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 785422d1656408903-adding-values-in-a-table-based-on-two-criteria-sumproduct-matrix-aligw
Sheet: Sheet1

 | Mon | [NAME] | Wed | Thur | Fri | Mon | [NAME] | Wed | Thur | Fri |  |  |  | [NAME] | Wed | Thur | Fri
Proj-1 | 5 | 6 | 7 | 4 | 3 | 1 | 2 | 3 | 3 | 3
Proj-2 | 1 | 7 | 4 | 3 | 1 | 2 | 3 | 3 | 3 | 1 |  | Proj-2
Proj-3 | 7 | 4 | 3 | 1 | 2 | 3 | 3 | 3 | 1 | 2 |  | Proj-3
Spreadsheet: 731491d1620369318-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league
Sheet: LINDA

S.N. | Particulars | Bought  Units | Unit or LINDA Price | Bought/ Sold Price  ($US) | Bought/ Sold Price (ETH) | Token Unit Price During Txn | Activity  Date | Received  Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated  Price ($US) | Status | Notes
1 | [NAME] 1 (Bought for 10.001 LTC) | 291814.58136359 | 5.7e-07 |  | -0.16666698 | 14477.5 | 2018-01-09 00:00:00 | 2018-01-09 00:00:00 |  |  |  |  | SOLD
2 | [NAME] | -241814.58136359 | 8.2e-07 |  | 0.19789137 | 14477.5 | 2018-01-09 00:00:00 | 2018-01-09 00:00:00
3 | [NAME] | -50000 | 5.9e-07 |  | 0.029441 | 14176.4 | 2018-01-13 00:00:00
4
5
6
7
8
9
 | Next Buy
 | [NAME] in [NAME] | 0
 | [NAME] in Bittrex | 0
 | [NAME] in Cryptopia | 0
 | Total Investment Loss/Profit ($US)
 | Website:
 | Contract address:
 | Symbol:
 | Decimals:
 | About/Idea
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: 804567d1668164968-finding-the-correct-value-sewer_solver
Sheet: Sewer exsercise

 | Danes
 |  | Contribution area |  |  |  | Sewer quantity  Fecal sewage
 |  | Oznaka | Area | Residents | Normal consumption | Qh | Qi | [NAME] | Qf | Qr,T | Qs | Qt | QgesT
 |  |  | [ha] | [os] | [liter/resident/day] | [liter/s] | [liter/s] | [liter/s] | [liter/s] | [liter/s] | [liter/s] | [liter/s] | [liter/s]
 | Sewer | Channel S |  |  | 150 |  | 0 | 0
 |  | Channel S1 | 0.1 |  | 150 |  | 0 | 0
 |  | Channel S2 | 0.084 |  | 150 |  | 0 | 0
 |  | Channel S3 | 0.058 |  | 150 |  | 0 | 0
 |  | Channel S4 | 0.065 |  | 150 |  | 0 | 0
 | Sum:
 | Channel | pipe diameter | filling angle | slope of the channel | filled area of pipe [A] | height filling | Manning koeficient | Manning | velocity | auxiliary angle for calculation | wet perimeter | corrected wet perimeter | hydraulic radius | partial height | percentage of filling
 |  | [mm] | [°] | [‰] | [m²] | [NAME] | nG | Q [l/s] | [m/s] | [°] | [m] | [m] | [m] | [NAME] | %
 | Channel S - max flow | 250 | 19 | 30 |  |  | 0.013
 | Channel S - dry season flow | 250 | 12 | 30 |  |  | 0.013
Spreadsheet: 195604d1353578792-cannot-get-indirect-function-to-work-with-sumifs-inv-summary-test
Sheet: Summary

 |  |  |  |  |  |  |  | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
Sheet 1 | Qtr1 | Qtr2 | Qtr3 | Qtr4 | Total |  | Sheet 1 | 1287.84 | 2181.37 | 0 | 815.0799999999999 | 2240.3 | 2837.8 | 4016.66 | 14389.51 | 12972.58
2004 |  |  |  |  |  |  | Sheet 2
2005 |  |  |  |  |  |  | Sheet 3
2006 |  |  |  |  |  |  | Sheet 4 |  | [NAME] to copy column F totals to row
2007 |  |  |  |  |  |  | Sheet 5
2008 |  |  |  |  |  |  | Sheet 6
2009 |  |  |  |  |  |  | Sheet 7
2010 |  |  |  |  |  |  | Sheet 8
2011 |  |  |  |  |  |  | Sheet 9
2012
Sheet 2 | Qtr1 | Qtr2 | Qtr3 | Qtr4 | Total |  | SUMIFS('Sheet 1'!$D:$D,'Sheet 1'!$C:$C,">="&DATE(2011,9,1)&"",'Sheet 1'!$C:$C,"<="&DATE(2011,12,31)&"")
2004
2005
2006 |  |  |  |  |  |  | Instead of manual input of sheet name, use indirect function for sheet name which will change every 12 rows??
2007 |  |  |  |  |  |  |  |  |  |  |  |  | INDIRECT("'"&A2&"'!
2008
2009
2010
2011
2012
Sheet 3 | Qtr1 | Qtr2 | Qtr3 | Qtr4 | Total
2004
2005
2006
2007
2008
2009
2010
2011
2012
Spreadsheet: 716425d1612204722-personal-budget-tracker-help-needed-sumif-budget-tracker-2021
Sheet: PERSONAL BUDGET

Create a Simple Personal Budget in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started.
Title of this worksheet is in cell at right. Enter year in cell Q2. Next instruction is in cell A4. | PERSONAL BUDGET
[NAME] are in cells C4 through P4. |  | REVENUE | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR
Enter details in Income table starting in cell C5. Next instruction is in cell A11. |  | INCOME | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline
 |  | Wages | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500
 |  | Interest/Dividends | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Miscellaneous | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total
 |  | Total Expenses
 |  | [NAME]
[NAME] are in cells C11 through P11. |  | EXPENSES | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR
Enter Home expenses in table starting in cell C12. Next instruction is in cell A20. |  | HOME | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline
 |  | Electric
 |  | Internet
 |  | Cable
 |  | Water
 |  | Planet Fitness
 |  | Car Payment
 |  | Car Insurance
 |  | Groceries
 |  | Optavia
 |  | Dining out
Enter Daily expenses in table starting in cell C20. Next instruction is in cell A29. |  | Total
 |  | DEBT | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline
 |  | WGU - Tuition
 |  | 401K Loan
 |  | Student Loans
Enter Transportation expenses in table starting in cell C29. Next instruction is in cell A38. |  | Total
 |  | WEDDING | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline
 |  | Flights
 |  | VRBO
 |  | Cake
 |  | Flowers
 |  | Suit
 |  | Dress
Enter Entertainment expenses in table starting in cell C38. Next instruction is in cell A45. |  | Reception Dinner
 |  | Photographer
 |  | Transporation to airport
 |  | Car rental
 |  | Officiant
 |  | Hair/Makeup
 |  | Nails
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total
Enter Health expenses in table starting in cell C45. Next instruction is in cell A55.
 |  | TOTALS | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR | SPARKLINE
 |  | Total expenses
 |  | Cash short/extra
Spreadsheet: jonathan_mckay__16926__Area Managers
Sheet: West Hillhurst

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | West Hillhurst Community Association |  |  |  | Deal Date: | 2001-05-23 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 1102.1
 | February | 1030.4
 | March | 894.3
 | April | 769.7
 | May | 305.5
 | June | 209.2
 | July | 104.7
 | August | 73.6
 | September | 336.7
 | October | 472.7
 | November | 862
 | December | 1040.2
 | TOTAL:
Spreadsheet: 47130d1246034525-how-do-you-make-a-cell-remain-blank-if-there-are-no-values-in-the-necessary-cells-work-form-sheet
Sheet: Work Form Sheet

 |  |  |  |  |  |  |  |  | Phone :
 |  |  |  |  |  |  |  |  | Job Name or No. :
 | For : |  |  |  |  |  |  |  | Job Invoice No. :
 |  |  |  |  |  |  |  |  | Job Location :
 |  |  |  |  |  |  |  |  | Start Date :
 |  |  |  |  |  |  |  |  | End Date :
 | Totals |  |  |  |  |  |  |  |  | Date |  | Payments |  | Total Payments
 | Materials |  | Labor |  | Job |  | Balance |  |  |  |  |  |  | 0
 | 0 |  | 0 |  | 0 |  | 0
 | Total Billable HR |  |  | Discounts
 |  |  |  | 0
 | Labor Estimation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Description |  |  |  | Unit | # Men | No. Of Units |  | Labor Per Unit |  | Total Labor Per |  | Total Est. Labor |  | Xtra Men |  |  | Me |  | Employee
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  | 35 |  | 8.5
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | Actual Labor
 | Date |  | # of Men |  | Start |  | End |  | Off Hours |  | Billable Hours |  | Labor Charge |  | Xtra Men
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  | Totals |  | 0 |  | 0
 | Expenses
 | Date |  | Vendor/ Supplier |  |  |  |  | Net Amount |  | Sales Tax Paid |  | Total Materials |  | Total Mat. & Labor
 |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  |  | Discount |  | Discount Total
 |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 886276d1736317908-creating-a-data-base-ppe-register
Sheet: FIND

 |  | Enter employee number below
 | Emp No | 171
 | Name
 | PPE | History
 |  | Shoe | Helmet | Jacket | Overall | Goggle | Spectacle
 | Issue Dates