tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 587713d1535196801-return-search-results-from-various-worksheets-into-one-worksheet-without-macros-monthly-report_trial-18
Sheet: PAYMENT SORT II

Date | Month Name | Particulars | Amount | HEAD | GROUP
2018-08-20 00:00:00 |  | PQR LIMited | 5000 | PHONES | COMMON
2018-08-21 00:00:00 |  | ALEX JONES | 3000 | [NAME] | COMMON
2018-08-22 00:00:00 |  | ASIAN PAINTS | 12500 | SITE | FRANKFURT
Spreadsheet: 128386d1320937664-conditional-formatting-using-seconds-cond-formating-by-seconds
Sheet: Sheet1

 | CLOSE |  |  | <<If I’ll choose"OPEN" in B1, then,change colour in D1, after>>> | 50 SECONDS
 |  |  |  | <<If I’ll choose"OPEN" in B1, then,change colour in [NAME], after>>> | 45 SECONDS
 |  |  |  | <<If I’ll choose"OPEN" in B1, then,change colour in D3, after>>> | 40 SECONDS
 |  |  |  | <<If I’ll choose"OPEN" in B1, then,change colour in D4, after>>> | 35 SECONDS
 |  |  |  | <<If I’ll choose"OPEN" in B1, then,change colour in D5, after>>> | 30 SECONDS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OPEN
 |  |  |  | <<If I’ll choose"OPEN" in B1, then,change colour in D6, after>>> | 25 SECONDS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CLOSE
 |  |  |  | <<If I’ll choose"OPEN" in B1, then,change colour in D7, after>>> | 20 SECONDS
 |  |  |  | <<If I’ll choose"OPEN" in B1, then,change colour in D8, after>>> | 15SECONDS
 |  |  |  | <<If I’ll choose"OPEN" in B1, then,change colour in D9, after>>> | 10 SECONDS
 |  |  |  | <<If I’ll choose"OPEN" in B1, then,change colour in D10, after>>> | 5 SECONDS
Spreadsheet: 720933d1614373446-value-error-in-avg-of-multiple-ratios-sample-ratio-formula
Sheet: National Ontario

 | Rolling Tracker List - ASKs - National Ontario
 | REGION | Number of Proposals | Company / Donor | Yes Response | Response | GCD | Ask to Yes [NAME] | Month | Total Amount Asked | Total Amount Confirmed
 | National Ontario | 20 | company 1 | 11 | Yes |  |  | January | 220000 | 140000
 | National Ontario | 22 | company 2 | 11 | Yes |  |  | February | 192000 | 162000
 | National Ontario | 25 | company 3 | 10 | Yes |  |  | March | 205000 | 155000
 | National Ontario |  | company 4 |  | Yes |  |  | -
 | National Ontario |  |  |  |  |  |  | -
 | National Ontario |  |  |  |  |  |  | -
 | National Ontario |  |  |  |  |  |  | -
 | National Ontario |  |  |  |  |  |  | -
 | National Ontario |  |  |  |  |  |  | -
 | National Ontario |  |  |  |  |  |  | -
 | National Ontario |  |  |  |  |  |  | -
 | National Ontario |  |  |  |  |  |  | -
 | Sub Total
 | TOTALS
Spreadsheet: gstorey__12025__Jan01
Sheet: Table1

NATURAL GAS EXPORTS - SUMMARY |  |  |  |  |  |  |  | Table 1
EXPORTATION DE GAZ NATUREL - SOMMAIRE
 |  | - - - - - - -Month/Mois- - - - - - |  | Variation |  | - - - - - - - Cumulative to date - - - - - - |  | Variation
 |  | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | % Change |  | 1999/11-2000/01 | 2000/11-2001/01 | % Change
Volume (Millions M3) | Long-term / Long terme | 2369.1 | 1854.6 | -0.217 |  | 6781 | 5862.3 | -0.135
 | Short-term / Court terme | 6317 | 8718 | 0.38 |  | 18801.6 | 24343.8 | 0.295
 | Total | 8686.1 | 10572.6 | 0.217 |  | 25582.6 | 30206 | 0.181
Revenue/Recettes (Millions $[NAME]) | Long-term / Long terme | 308.9 | 757.2 | 1.451 |  | 913.6 | 1844.7 | 1.019
 | Short-term / Court terme | 753.4 | 4502 | 4.976 |  | 2371.9 | 9758.3 | 3.114
 | Total | 1062.3 | 5259.2 | 3.951 |  | 3285.6 | 11603.1 | 2.532
Avg. price/Prix moyen ($CDN/GJ) | Long-term / Long terme | 3.44 | 10.77 | 2.129 |  | 3.56 | 8.3 | 1.335
 | Short-term / Court terme | 3.14 | 13.54 | 3.312 |  | 3.32 | 10.53 | 2.167
 | Total | 3.22 | 13.06 | 3.052 |  | 3.39 | 10.1 | 1.982
Volume (BCF) | Long-term / Long terme | 83.6 | 65.5 | -0.217 |  | 239.4 | 206.9 | -0.135
 | Short-term / Court terme | 223 | 307.8 | 0.38 |  | 663.7 | 859.4 | 0.295
 | Total | 306.6 | 373.2 | 0.217 |  | 903.1 | 1066.3 | 0.181
Revenue/Recettes (Millions $US) | Long-term / Long terme | 213.2 | 503.7 | 1.363 |  | 624.5 | 1214.1 | 0.944
 | Short-term / Court terme | 520 | 2995.1 | 4.76 |  | 1620.9 | 6431.6 | 2.968
 | Total | 733.2 | 3498.8 | 3.772 |  | 2245.4 | 7645.8 | 2.405
Avg. price/Prix moyen ($US/MMBTU) | Long-term / Long terme | 2.55 | 7.69 | 2.016 |  | 2.61 | 5.86 | 1.249
 | Short-term / Court terme | 2.33 | 9.67 | 3.156 |  | 2.44 | 7.45 | 2.054
 | Total | 2.39 | 9.32 | 2.906 |  | 2.48 | 7.14 | 1.875
Spreadsheet: 583226d1532331569-dependent-drop-down-or-vlook-ups-to-be-used-for-multiples-data-interconnected-naroda-project-costing
Sheet: COMPOUND AREA

PROJECT COSTING FOR MATERIAL RELATED TO COMPOUND AREA
SR NO | ITEMS DESCRIPTION | QTY REQD | VENDOR | SIZE | SPECIFICATION | COST PER PIECE | AMOUNT | GST % | GST AMOUNT | TOTAL COST
1 | LED HALOGEN LIGHTS FOR COMPOUND AREA
 | WALL FIXNG COMPOUND LIGHTS FOR LIGHT IN CAR PARKING SPACE
 | POSTER BOXES WITH LED LIGHTS AT COMPOUND WALL
 | WIRING FOR POSTER BOXES AT COMPOUND WALL |  |  |  |  |  |  | 0.18
 | PoE IP CAMERAS WITH VOICE RECORDING
 | PoE IP DOME CAMERAS
 | PoE IP BULLET CAMERAS
 | WIRING FOR CAMERAS AT COMPOUND WALL
 | HOARDINGS (20*10) OR (15*10) FOR MOVIE BANNERS
 | HOARDINGS FOR SALES & ADVERTISING
 | BRAND LOGO NEON (COMPOUND / TERRACE)
 | EITHER PAINTING ON WALL (PARKING AT OWNER RISK) OR PRINTING ON SUN BOARD
 | NOTICE BOARD RELATED TO PARKING
TOTAL COST OF EXPENSES FOR THE NEW PROJECT
Spreadsheet: 128170d1320836804-excel-2007-total-number-of-people-on-break-forum
Sheet: Sheet1

 |  |  |  |  | Total Number on Break =
 |  |  |  | Who is on Break? | Name | out time | in time | Total | out time | in time | Total | Break Total
 |  |  |  |  | A | 10:00:00
 |  |  |  |  | B | 10:00:00 | 10:20:00 |  | 11:00:00
 |  |  |  |  | C | 10:00:00 | 10:25:00 |  | 11:00:00 | 12:10:00
 |  |  |  |  | D
 |  |  |  |  | E | 10:00:00
Spreadsheet: phillip_m_love__30684__DenFRED
Sheet: all variances

Denver financial liquidation variances
TAGG | [NAME] | GL Amount | [NAME] | ABS |  | Desk Adjustment | GL Adjustment/Reclass | Comments
N67923.3 | 0 | -99375
N67923.4 | 0 | -11250
N66428.2 | 0 | -32995.62
N67923.2 | 0 | 43125
Spreadsheet: 274716d1383203182-randomly-select-from-a-table-with-blank-cell-aaaproblem
Sheet: Sheet1

 | WORLD ANNUAL NUMBER OF EARTHQUAKES FROM 5.0 TO 9.9 RICHTER
 |  | 1970 | 1980 | 1990 | 2000 | 2010
 | 0 | 1325 | 1418 | 1744 | 1505 | 2136
 | 1 | 1463 | 1271 | 1569 | 1361 | 1805
 | 2 | 1441 | 1520 | 1677 | 1341
 | 3 | 1439 | 1813 | 1575 | 1358
 | 4 | 1425 | 1678 | 1701 | 1672
 | 5 | 1569 | 1798 | 1521 | 1844
 | 6 | 1780 | 1760 | 1386 | 1865
 | 7 | 1788 | 1560 | 1249 | 2270
 | 8 | 1635 | 1586 | 1108 | 1948
 | 9 | 1479 | 1530 | 1238 | 2057
 | Source: http://www.johnstonsarchive.net/other/quake1.html
 | Source: US Geological Survey
Spreadsheet: 889507d1740349533-formula-needed-to-calculate-and-reduce-weights-weights
Sheet: Sheet1

1.5 | 0.5 | 1.5 | 0.5 | 0.25 | 0.25 | 0.25 | 0.75 | 0.5 | 0.5 | 1.75 | 1.5
Factors | ACL | AvgSpd | [NAME] | Prm Power | Post IV | RS IV | Surface | Distance | Track | $/race | Life Win% |  | Total
Spreadsheet: 160733d1339177448-excel-2007-look-up-question-lookup-from-multiple-tabs
Sheet: 108

Attendance Rules: 5 – 5.75   NoCorrective Action 6 – 7.00  No Corrective Action taken; Notice of Attendance Record 7.25 – 7.75   Verbal Warning 8 – 8.75  Written Warning 9 – 9.75  Final Written Warning with 120-day probation Next Point (10) - Review for Termination |  | Occurrence Rules: **Occurrences stay on the record for a rolling one year. **Occurrences stay on until an Approved FMLA letter is issued from UNUM. A doctors excuse does not remove an occurrence. 8-15 minutes tardy, early departure or shift interruption~.25 16 or more minutes tardy, early departure or shift interruption ~ .50 3 hours or more absent when scheduled to work ~ 1 2 consecutive work days absent (10 hours for part-time)~2 3 or more consecutive days absent (15 hours for part-time)~2.25 Call-off or no-show for scheduled & communicated overtime~1 |  |  |  |  |  |  |  | 0 | n/a
 |  |  |  |  |  |  |  |  |  | 1 | Applied for
 |  |  |  |  |  |  |  |  |  | 0.25 | Approved
 |  |  |  |  |  |  |  |  |  |  | Denied
Tech Name | [NAME] Doe #2 | Total Occurrences
Tech Number | 108 | Corrective Action Step
Date | Occurrence Issued | FMLA   Applied for/ Approved/Denied | Comments
2011-09-01 00:00:00 | 1 | n/a
2012-02-03 00:00:00 | 1 | n/a
2012-02-22 00:00:00 | 1 | n/a
Spreadsheet: 176f1505-d20a-43c0-a63e-9a8c52096839
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 17. COMMERCIAL FINANCE COMMITMENTS, Fixed Loans By Industry: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Agriculture, forestry and fishing ; |  |  | Original | A2414226J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2414227K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2414228L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2414229R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2414230X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | A2414231A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2414232C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2414233F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2414234J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2414235K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Public administration ; |  |  | Original | A2414236L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2414237R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2414238T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
TOTAL FIXED LOANS ; |  |  | Original | A2414239V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 198158d1354676707-if-two-values-are-equal-index-to-return-name-that-match-on-cell-range-score-board-vlady
Sheet: Sheet2

100 | 25
Place | Name | Country | Score
 | [NAME] | Norway | 500
 | [NAME] | Germany | 372
 | [NAME] | USA | 380
 | [NAME] | USA | 379
Spreadsheet: 138235d1327580580-text-to-numbers-addup
Sheet: Sheet1

 | 10.1 |  |  | 55.99999999999999
10.1 |  |  | 10.1
 |  |  |  |  | [NAME] |  | Copied and Pasted |  | sum | 31.7
$7.8 |  |  | 7.8 |  | $7.8 |  | 7.8
$1.9 |  |  | 1.9 |  | $1.9 |  | 1.9
$12.3 |  |  | 12.3 |  | $12.3 |  | 12.3
$3.3 |  |  | 3.3 |  | $3.3 |  | 3.3
$6.4 |  |  | 6.4 |  | $6.4 |  | 6.4
 |  |  |  |  |  |  | [NAME] to Number
$2.6 |  |  | 2.6
0 |  |  | 0
$9.5 |  |  | 9.5
$2.1 |  |  | 2.1
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
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
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
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
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
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
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
0
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 109557d1306387283-conditional-formatting-can-be-use-twice-in-a-work-sheet-book1-mod
Sheet: FOOD

BU | Application DATE | COMPANY | PRODUCTS | CONTROL | APPLICATION NO | PIC | REMARKS | DUE DATE
SGZ1 | 1999-01-01 00:00:00 | ABC
SGZ1 | 2011-05-05 00:00:00 | DEF
SGZ1 |  | GHI
SGZ1 |  | JKL
SGZ1 |  | MNO
SGZ2 |  | PQR
SGZ1 |  | STU
SGZ1 |  | VWZ
SGZ1 |  | SDG
Spreadsheet: 129133d1321464307-vlookup-over-multiple-sheets-copy-of-2011-barter-and-trade-test
Sheet: November

Customer | Net | [NAME] | Size | Rep
[NAME]'s Bakery | 1 | 1 | 1/3 Page Square | [NAME]
Mudtown Eat & Drink | 2 | 2 | 1/4 Page | [NAME]
[NAME] | 3 | 3 | 1/4 Page | [NAME]
Red Mountain Theatre Company | 4 | 4 | 2/3 Page | [NAME]
California Pizza Kitchen | 5 | 5 | 1/2 Page | [NAME]
[NAME] Center | 6 | 6 | 1/3 Page Square | [NAME]
[NAME] Center | 7 | 7 | 1/3 Page Square | [NAME]
[NAME]'s Flower Market | 8 | 8 | 1/4 Page | [NAME]
McWane Science Center | 9 | 9 | 1/2 Page | [NAME]
Books A Million | 10 | 10 | 1/3 Page Vertical | [NAME]
JAMM Entertainment Services | 11 | 11 | 1/3 Page Square | [NAME]
Roebuck Springs Historic Preservation Society | 12 | 12 | 1/3 Page Square | [NAME]
WELD for Birmingham | 13 | 13 | 1/3 Page Square | [NAME]
Al.com | 14 | 14 | 2/3 Page | [NAME]
[NAME] | 15 | 15 | 1/2 Page | [NAME]
Magic City Art Connection | 16 | 16 | 1/3 Page Square | [NAME]
Alabama Ballet | 17 | 17 | 2 Page Spread | [NAME]
Event Operations Group | 18 | 18 | 1/2 Page | [NAME]
Levite Jewish Community Center | 19 | 19 | 1/2 Page | [NAME]
Birmingham Mountain Radio | 20 | 20 | [NAME] | [NAME]
Cox Radio | 21 | 21 | [NAME] | [NAME]
Cultural Alliance of Greater Birmingham - Birmingham 365 | 22 | 22 | [NAME] | [NAME]
The Birmingham News | 23 | 23 | [NAME] | [NAME]
Boutwell Studios | 24 | 24 | 2 Page Spread | [NAME]
Spreadsheet: 785474d1656433069-auto-calculate-workdays-for-table-referrals-per-day-tracking-sheet_
Sheet: Sheet1

Month: | 2022-06-01 00:00:00 |  |  |  |  | Monthly Admission Goal: | 60
 |  |  |  |  |  | Month's Working Days:
 |  |  |  |  |  | Monthly Daily Referral Goal:
 |  |  |  |  |  | Referrals Still Needed to Meet Goal:
 |  |  |  |  |  | Adjusted Monthly Daily Referral Goal:
REFERRALS | Mon | Tue | Wed | Thu | Fri | Actual/week | Total goal/week
Week 1 |  |  | 4 | 4 | 4
Week 2 | 4 | 4 | 4 | 4 | 4
Week 3 | 4 | 4 | 4 | 4 | 4
Week 4 | 4 | 4 | 4 | 4 | 4
Week 5 | 4 | 4
 |  |  |  |  | TOTAL:
Spreadsheet: 739516d1625754694-vlookup-with-random-data-validation-drop-down-list-in-a-column-for-specific-rows-vlookup_with_dropdownlist
Sheet: Report

 | Date | Inv.No. | Amount | Person | Department | Expected Result
 | 2021-06-01 00:00:00 | 2258 | 120 | [NAME] |  | LOG
 | 2021-06-01 00:00:00 | 2259 | 50 | Palani |  | Damage | <-- To be selected from data validation dropdown list
 | 2021-06-02 00:00:00 | 2300 | 75 | Mic |  | FIN
 | 2021-06-02 00:00:00 | 2301 | 30 | Lyan |  | Repair | <-- To be selected from data validation dropdown list
 | 2021-06-03 00:00:00 | 2304 | 55 | Murug
 | 2021-06-03 00:00:00 | 2305 | 100 | Lyan |  | Maint. | <-- To be selected from data validation dropdown list
 | 2021-06-04 00:00:00 | 2412 | 250 | Palani |  | Maint. | <-- To be selected from data validation dropdown list
 | 2021-06-04 00:00:00 | 2415 | 225 | Chery
Spreadsheet: 4547bdc9-d899-42f0-b282-9085d641ac92
Sheet: 12. Land by Agency

FY 2013 Federal Real Property Charts
Land†
Agency | Owned Acres** | Owned Annual Operating Costs** | Leased Acres | Leased Annual Costs*
Agriculture | 119710.595 | 0 | 20103.304 | 2036629.74
Air Force*** | 8010800.54 | 0 | 386987.28 | 0
Army*** | 10067159.909 | 0 | 574668.963 | 0
Commerce | 7526.554 | 2343053 | 12035.135 | 3168261.7
Corps of Engineers*** | 7601602.635 | 35417.96 | 172376.17 | 292651.26
Defense/WHS*** | 947.56 | 0 |  | 0
Energy | 2219494.22 | 1084569 | 9123.78 | 2964026
Environmental Protection Agency | 603.86 | 4722740.23 | 24.57 | 6280297.33
General Services Administration | 2947.88 | 7259017.28 | 320.31 | 3305899
Health and Human Services | 4394.375 | 0 | 1407.51 | 215248.54
Homeland Security | 74511.01 | 6496837.28 | 5435.63 | 10195667.58
Interior | 6281291.800000001 | 716010.89 | 10210.802 | 1473519.809
Justice | 47456.924 | 701940 | 203.17 | 0
Labor | 4391.83 | 1458426.16 | 1681.66 | 10904
National Aeronautics And Space Administration | 186476.641 | 2999739 | 10.56 | 48763
National Science Foundation | 5814.440000000001 | 183478 | 6380.88 | 41927.05
Navy*** | 4137495.274 | 0 | 197852.776 | 0
State | 126061.775 | 27492969.26 | 884.345 | 25391678.98
State (USAID) | 54.45 | 493524.52 | 3.04 | 118487.25
Transportation | 57592.062 | 2989929.49 | 82337.008 | 14851509.96
Treasury | 167.065 | 581664 |  | 0
Veterans Affairs | 35800.46 | 77924798.49 | 130.42 | 5034141.53
Total
† All real property data from the CFO Act agencies required to submit data to the FRPP
*Includes operations and maintenance costs and rent
**includes federal government owned, foreign government owned, museum trust, state government owned, withdrawn land, and leased.  DOES NOT INCLUDE PUBLIC DOMAIN LAND
*** Department of Defense
Spreadsheet: 747471d1631529922-formula-to-show-volume-of-2nd-identifier-if-volume-of-1st-identifier-is-missing-sample-workbook-v3
Sheet: Sheet1

RM Code | CalendarQuarter | Volume | Identifier | Expected Result
APPLE | CY17Q1 | 10000 | 1 | 10000
APPLE | CY17Q2 | 5400 | 1 | 5400
APPLE | CY17Q3 | 3300 | 1 | 3300
APPLE | CY17Q4 | 2600 | 1 | 2600
APPLE | CY18Q2 | 12800 | 1 | 12800
APPLE | CY18Q3 | 20 | 1 | 20
APPLE | CY18Q4 | 40120 | 1 | 40120
APPLE | CY19Q1 | 20000 | 1 | 20000
APPLE | CY19Q2 | 4000 | 1 | 4000
APPLE | CY19Q3 | 14000 | 1 | 14000
APPLE | [NAME] | 32000 | 1 | 32000
APPLE | CY17Q1 | 100 | 2
APPLE | CY17Q2 | 9890 | 2
APPLE | CY17Q3 | 2020 | 2
APPLE | CY17Q4 | 500 | 2
APPLE | CY18Q1 | 21120 | 2 | 21120
APPLE | CY18Q2 | 24000 | 2
APPLE | CY18Q3 | 4.04 | 2
APPLE | CY18Q4 | 31860 | 2
APPLE | CY19Q1 | 6400 | 2
APPLE | CY19Q2 | 1.02 | 2
APPLE | CY19Q3 | 41280 | 2
APPLE | [NAME] | 10000 | 2
PEAR | CY17Q1 | 10000 | 1 | 10000
PEAR | CY17Q2 | 5400 | 1 | 5400
PEAR | CY17Q3 | 3300 | 1 | 3300
PEAR | CY17Q4 | 2600 | 1 | 2600
PEAR | CY18Q2 | 12800 | 1 | 12800
PEAR | CY18Q3 | 20 | 1 | 20
PEAR | CY18Q4 | 40120 | 1 | 40120
PEAR | CY19Q1 | 20000 | 1 | 20000
PEAR | CY19Q2 | 4000 | 1 | 4000
PEAR | CY19Q3 | 14000 | 1 | 14000
PEAR | [NAME] | 32000 | 1 | 32000
PEAR | CY17Q1 | 100 | 2
PEAR | CY17Q2 | 9890 | 2
PEAR | CY17Q3 | 2020 | 2
PEAR | CY17Q4 | 500 | 2
PEAR | CY18Q1 | 21120 | 2 | 21120
PEAR | CY18Q2 | 24000 | 2
PEAR | CY18Q3 | 4.04 | 2
PEAR | CY18Q4 | 31860 | 2
PEAR | CY19Q1 | 6400 | 2
PEAR | CY19Q2 | 1.02 | 2
PEAR | CY19Q3 | 41280 | 2
PEAR | [NAME] | 10000 | 2
Spreadsheet: 804435d1668079637-formula-to-match-row-number-and-then-offset-by-nth-blank-column-example
Sheet: Sheet1

PartNo | Wk1 | Wk2 | Wk3 | Wk4 | Wk5 | Wk6 | Wk7 | Wk8 | Wk9
Part1 | 0 | 5 | 0 | 15 | 0 | 1000 | 0 | 0 | 0
Part2 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 0 | 10
Part3 | 0 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 0
Part4 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 0 | 0
Manual |  |  |  |  |  | [NAME]
Part No | Week No | Qty |  |  |  | Part No | Week No | Qty
Part1 | Wk2 | 5 |  |  |  | Part1
Part1 | Wk4 | 15 |  |  |  | Part1
Part1 | Wk6 | 1000 |  |  |  | Part1
Part2 | Wk1 | 10 |  |  |  | Part2
Part2 | Wk3 | 10 |  |  |  | Part2
Part2 | Wk5 | 10 |  |  |  | Part2
Part2 | Wk7 | 10 |  |  |  | Part2
Part2 | Wk9 | 10 |  |  |  | Part2
Part3 | Wk2 | 10 |  |  |  | Part3
Part3 | Wk4 | 10 |  |  |  | Part3
Part3 | Wk6 | 10 |  |  |  | Part3
Part3 | Wk8 | 10 |  |  |  | Part3
Part4 | Wk5 | 1000 |  |  |  | Part4
Spreadsheet: 33086d1229368128-getting-accurate-period-averages-johns-ebico-from-04_12_2008
Sheet: Gas

 | GAS |  | GAS |  |  | GAS |  |  | GAS |  | GAS |  | GAS |  | GAS |  | GAS |  |  | GAS |  |  | GAS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VAT
 | Date |  | [NAME] |  |  | Date | Time |  | [NAME] |  | Used | Cubic | Correction | Calorific | [NAME] | Used | Inclusive |  | Gas Used | Running | Days |  | Daily |  | Projection
 | Period |  | Start |  |  | of | of |  | End |  | 100 cu ft | Meters | Factor | Factor | KWhrs | KWhrs | per KWhr |  | Cost | Total |  |  |  |  | Based on
 | Starts |  | Reading |  |  | Reading | Reading |  | Reading |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost |  | Daily
 |  |  |  |  |  |  | 24 hrs |  |  |  |  |  | 1.02264 | 39.3 | 3.6 |  | 3.7695 |  |  |  |  |  |  |  | Cost
 | dd/mm/yyyy |  |  |  |  | dd/mm/yyyy
 | 2008-12-04 00:00:00 |  | 1135.349 |  |  | 2008-12-04 00:00:00 | 8 |  | 1135.781
 |  |  |  |  |  | 2008-12-04 00:00:00 | 14 |  | 1138.9
 |  |  |  |  |  | 2008-12-04 00:00:00 | 19 |  | 1140.1
 |  |  |  |  |  | 2008-12-04 00:00:00 | 23.3 |  | 1141.1
 |  |  |  |  |  | 2008-12-05 00:00:00 | 8 |  | 1141.524
 |  |  |  |  |  | 2008-12-05 00:00:00 | 16.3 |  | 1145.756
 |  |  |  |  |  | 2008-12-05 00:00:00 | 19 |  | 1146
 |  |  |  |  |  | 2008-12-06 00:00:00 | 8 |  | 1148.12
 |  |  |  |  |  | 2008-12-06 00:00:00 | 23.3 |  | 1153.9
 |  |  |  |  |  | 2008-12-07 00:00:00 | 8 |  | 1154.381
 |  |  |  |  |  | 2008-12-07 00:00:00 | 21.45 |  | 1160.65
 |  |  |  |  |  | 2008-12-08 00:00:00 | 8 |  | 1161.668
 |  |  |  |  |  | 2008-12-08 00:00:00 | 23 |  | 1167.5
 |  |  |  |  |  | 2008-12-09 00:00:00 | 8 |  | 1167.9
 |  |  |  |  |  | 2008-12-09 00:00:00 | 15.3 |  | 1171.6
 |  |  |  |  |  | 2008-12-09 00:00:00 | 23.5 |  | 1173.75
 |  |  |  |  |  | 2008-12-10 00:00:00 | 8 |  | 1174.5
 |  |  |  |  |  | 2008-12-10 00:00:00 | 23 |  | 1180.5
 |  |  |  |  |  | 2008-12-11 00:00:00 | 8 |  | 1182.05
 |  |  |  |  |  | 2008-12-11 00:00:00 | 23.45 |  | 1187.35
 |  |  |  |  |  | 2008-12-12 00:00:00 | 8 |  | 1188.8
 |  |  |  |  |  | 2008-12-12 00:00:00 | 23 |  | 1193.7
 |  |  |  |  |  | 2008-12-13 00:00:00 | 8 |  | 1193.712
 |  |  |  |  |  | 2008-12-13 00:00:00 | 23 |  | 1198.89
 |  |  |  |  |  | 2008-12-14 00:00:00 | 8 |  | 1199.7
 |  |  |  |  |  | 2008-12-14 00:00:00 | 15.2 |  | 1202.95
 |  |  |  |  |  | 2008-12-14 00:00:00 | 23 |  | 1204.5
 |  |  |  |  |  | Totals | Actual |  | Gas |  |  | Projected |  | Gas
 |  |  |  |  |  |  | Actual |  | Electric |  |  | Projected |  | Electric
 |  |  |  |  |  |  | Actual |  | Both |  |  | Projected |  | Both
 |  | Enter date  > |  |  |  | DD/MM/YYYY |  |  |  |  |  |  | Days since your birth
 |  | Birth date |  |  |  | 1947-04-17 00:00:00 |  |  |  |  |  | You are >> |  |  |  | << Young
 |  | Enter a Date |  |  |  | 2008-11-28 00:00:00
 |  | Todays date |  |  |  |  |  |  |  | Press F9 to refresh date
Spreadsheet: 67798d1268322465-excel-2007-sumifs-with-criteria-sum-ranges-in-a-cell-drop-down-sumifs-dummy
Sheet: Sheet2

 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | Salad2 |  |  |  |  |  |  | Salad3
 |  |  |  |  |  |  |  | Size | Lettuce | Tomato | Cheese | Croutons |  |  | Size | Lettuce | Tomato | Cheese | Croutons |  |  | Size | Lettuce | Tomato | Cheese | Croutons
Type | Size | Lettuce | Tomato | Cheese | Croutons |  |  | 1 | 5 | 2 | 0 | 10 |  |  | 1 | 180 | 130 | 150 | 80 |  |  | 1 | 80 | 100 | 70 | 20
[NAME] | 4 |  |  |  |  |  |  | 2 | 7 | 3 | 1 | 15 |  |  | 2 | 230 | 165 | 190 | 100 |  |  | 2 | 100 | 130 | 90 | 25
 |  |  |  |  |  |  |  | 3 | 10 | 5 | 3 | 15 |  |  | 3 | 295 | 215 | 245 | 130 |  |  | 3 | 130 | 165 | 115 | 35
 |  |  |  |  |  |  |  | 4 | 15 | 8 | 5 | 20 |  |  | 4 | 375 | 275 | 315 | 170 |  |  | 4 | 170 | 210 | 145 | 40
 |  |  |  |  |  |  |  | 5 | 19 | 11 | 7 | 25 |  |  | 5 | 485 | 350 | 405 | 215 |  |  | 5 | 215 | 270 | 190 | 55
 |  |  | Cell I want to refer to for criteria/sum range
 |  |  | Cell for criteria
 |  |  | Named Ranges outlined in bold
 |  | Goal: | Return the sums of materials greater than size identified in B5 for the type identified in A5
Spreadsheet: 28c793b4-63e1-49de-908a-0ee0add93866
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Merch | 80688742171 | [NAME] | Stellar Kart Blue Ladies Bus Xlarge | 2008-02-26 | T-Shirt | Rock | 14.99 | N | To Be Retired
Merch | 80688742157 | [NAME] | Stellar Kart Blue Ladies Bus Large | 2008-02-26 | T-Shirt | Rock | 14.99 | N | To Be Retired
Merch | 80688742119 | [NAME] | Stellar Kart Blue Ladies Bus Medium | 2008-02-26 | T-Shirt | Rock | 14.99 | N | To Be Retired