tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 843369d1695230236-count-of-occasions-row-goes-below-n-test-data
Sheet: Sheet1

 |  |  | Count # of occassions row goes below 1,000
 |  |  |  | 1200 | 1150 | 1125 | 1050 | 950 | 900 | 1300 | 1200 | 1150 | 1020 | 975 | 960 | 930 | 1100 | 900 | 850 | 820
 |  |  | Desired result: | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 0 | 3 | 3 | 3
Spreadsheet: 117160d1312480020-data-required-in-cells-engineering-shift-report-register-upload
Sheet: Shift Report Register

Date of Breakdown | Engineer | Equipment Type | Equipment Description | Start Time | End Time | Duration | Problem | Remedy | Parts used | Further Action | Status | Date Completed | Date of Breakdown + 30 | Date/Time Logged | User Details
2011-07-20 00:00:00 | [NAME] | Mobile Packing - PRP-01 | Pressure Pot, Tube Seal Tester | 08:30:00 | 11:00:00 | 02:30:00 | test | test |  |  |  |  | 2011-08-20 00:00:00
Spreadsheet: 713857d1610981134-match-function-looking-up-number-value-20210718_su2xl_kalk-update_xl-help-2
Sheet: ELEV

ELEV | EBENE | H
ELEV_11 | 11
ELEV_10 | 10
ELEV_09 | 9
ELEV_08 | 8
ELEV_07 | 7
ELEV_06 | 6
ELEV_05 | 5
ELEV_04 | 4
ELEV_03 | 3
ELEV_02 | 2
ELEV_01 | 1
ELEV_EG | 0
ELEV_U1 | -1
ELEV_U2 | -2
ELEV_U3 | -3
ELEV_U4 | -4
ELEV_U5 | -5
Spreadsheet: drew_fossum__8674__business plan
Sheet: Sheet1

NORTHERN NATURAL GAS COMPANY
2001 – 2003 OPERATING & STRATEGIC PLAN
BUSINESS PLAN
* Anticipate continuing changes in North American gas flows, pursue new market opportunities for natural gas, protect current markets,
and capture end-users in potential markets capable of by-pass.
* Continue evaluating NNG’s north-end and south-end asset operations to identify candidates for swap/sale.  Avoid stranded assets due
to changing markets and Canadian gas flows.
* Continue improvement of decision-making tools for valuing of long and short-term capacity and the profitability of individual deals.
* Significantly improve ability to optimize system operations to create capacity, to conserve fuel, and to reduce unaccounted-for gas.
Maintain flat O&M.
* Pursue identification, evaluation and possible implementation of viable acquisition, alliance, or joint venture opportunities.
* Improve customer service to solidify customer loyalty and develop a Company culture targeted at excellence in [NAME].
* Improve organizational effectiveness.
* Exploit advances in technology.
[NAME]
2001 – 2003 OPERATING & STRATEGIC PLAN
BUSINESS PLAN
* Anticipate continuing changes in North American gas flows, pursue new market opportunities for natural gas, protect current markets,
and capture end-users in potential markets capable of by-pass.
* Continue evaluating asset operations to identify candidates for swap/sale, and to capitalize on changing markets and gas flows.
* Continue improvement of decision-making tools for valuing of long and short-term capacity and the profitability of individual deals.
* Significantly improve ability to optimize system operations to create capacity, to conserve fuel, and to reduce unaccounted-for gas.
Maintain flat O&M.
* Pursue identification, evaluation and possible implementation of viable acquisition, alliance, or joint venture opportunities.
* Improve customer service to solidify customer loyalty and develop a Company culture targeted at excellence in [NAME].
* Improve organizational effectiveness.
* Exploit advances in technology.
Spreadsheet: 842587d1694616090-rolling-calculation-example
Sheet: Sheet1

Old Calculation
Region | Jul 2022 | Aug 2022 | Sep 2022 | Oct 2022 | Nov 2022 | Dec 2022 | Jan 2023 | Feb 2023 | Mar 2023 | Apr 2023 | May 2023 | June 2023 | Jul 2023 | Aug 2023 | Sep 2023 | Oct 2023 | Nov 2023 | Dec 2023 | Jan 2024 | Feb 2024 | Mar 2024 | VS Prior Month | VS PY | VS Prior 6 Months | VS Prior 12 Months
Territory 1 | 13866.8 | 15566.15 | 12332.76 | 4701.24 | 10391.29 | 21258.99 | 27468.18 | 23780.69 | 17731.87 | 16192.88 | 25715.57 | 20174.42 | 14675.03
Territory 2 | 4470.75 | 5215.81 | 6607.400000000001 | 4237.99 | 6890.700000000001 | 10547.65 | 13011.87 | 8891.01 | 8127.54 | 3126.86 | 9543.18 | 7807.09 | 3208.59
Territory 3 | 29411.62 | 47376 | 36669.96 | 49061.73000000001 | 43238.28 | 55431.38 | 39821.35 | 40313.39 | 47844.56999999999 | 41725.74 | 55882.24000000001 | 39610.24000000001 | 58051.82
Territory 4 | -2680 | 12052.98 | 9451.35 | 11647.6 | 4813.04 | 3700.04 | 2915.87 | 17794.52 | 16460.77 | 18204.09 | 27113.15 | 14826.94 | 19895.17
Territory 5 |  |  | 712.88 |  | 600 | 300 | 1320 | 1498 |  | 1632.95 |  | 1444.14
AliGW
Region | Jul 2022 | Aug 2022 | Sep 2022 | Oct 2022 | Nov 2022 | Dec 2022 | Jan 2023 | Feb 2023 | Mar 2023 | Apr 2023 | May 2023 | June 2023 | Jul 2023 | Aug 2023 | Sep 2023 | Oct 2023 | Nov 2023 | Dec 2023 | Jan 2024 | Feb 2024 | Mar 2024 | VS Prior Month | VS PY | VS Prior 6 Months | VS Prior 12 Months
Territory 1 | 13866.8 | 15566.15 | 12332.76 | 4701.24 | 10391.29 | 21258.99 | 27468.18 | 23780.69 | 17731.87 | 16192.88 | 25715.57 | 20174.42 | 14675.03 |  |  |  |  |  |  |  |  |  |  |  |  | This is OKAY
Territory 2 | 4470.75 | 5215.81 | 6607.400000000001 | 4237.99 | 6890.700000000001 | 10547.65 | 13011.87 | 8891.01 | 8127.54 | 3126.86 | 9543.18 | 7807.09 | 3208.59 |  |  |  |  |  |  |  |  |  |  |  |  | This is OKAY
Territory 3 | 29411.62 | 47376 | 36669.96 | 49061.73000000001 | 43238.28 | 55431.38 | 39821.35 | 40313.39 | 47844.56999999999 | 41725.74 | 55882.24000000001 | 39610.24000000001 | 58051.82 |  |  |  |  |  |  |  |  |  |  |  |  | This is OKAY
Territory 4 | -2680 | 12052.98 | 9451.35 | 11647.6 | 4813.04 | 3700.04 | 2915.87 | 17794.52 | 16460.77 | 18204.09 | 27113.15 | 14826.94 | 19895.17 |  |  |  |  |  |  |  |  |  |  |  |  | This is OKAY
Territory 5 |  |  | 712.88 |  | 600 | 300 | 1320 | 1498 |  | 1632.95 |  | 1444.14 |  |  |  |  |  |  |  |  |  |  |  |  |  | These don't match above
Spreadsheet: 39059d1237285697-stuck-with-plotting-a-graph-675728
Sheet: Sheet1

 | y = -0.123x2 + 2.071x + 0.174
Concentration | Absorbance Values | [NAME] | Difference
0 | 0 | 0.174 | -0.174
2 | 4.2 | 3.824 | 0.3759999999999999
4 | 6.4 | 6.490000000000001 | -0.09000000000000075
6 | 7.9 | 8.172000000000002 | -0.272000000000002
8 | 9 | 8.870000000000001 | 0.129999999999999
unk | 2.8 | #N/A | #N/A
1.381299262681222 | 2.8 | 2.799988291683517 | 1.170831648256154e-05
Spreadsheet: 6bfb9800-bdf6-403c-87f8-523db028dda0
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
FRFMD | Test | FRFMD | Rufinamide (Banzel) | Rufinamide (Banzel) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Plain, Red-Top Tube: Red |  |  | 2 | mL | Submit only 1 of the following specimens:   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 2 mL of serum refrigerated. Note: 1. Indicate serum on request form.          2. Label specimen appropriately (serum).          3. Trough levels are most reproducible.   [NAME] blood in a green-top (sodium heparin) tube(s). ([NAME] tube is not acceptable.) Spin down and send 2 mL of sodium heparin plasma refrigerated. Note: 1. Indicate plasma on request form.          2. Label specimen appropriately (plasma)          3. Trough levels are most reproducible. | 0.6 mL   Note: Submission of the | Specimens other than	Serum or [NAME] other than	Sodium heparin, red-top Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Expected plasma concentrations in patients taking recommended daily dosages: up to 60.0 ug/mL.   Test Performed by: Medtox Laboratories                              402 W. County Road D                              St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc
FRFMD | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FRFMD | Result | [NAME] | Rufinamide | Rufinamide | Alphanumeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: phillip_m_love__30138__200007_OA
Sheet: GD-CE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 286770 | 1210679
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 19787053 | 81455369
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 20073823 | 82666048
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -1966370 | -8170468 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -18134600 | -73143829
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 169252 | 618254
 | Total Purchases: |  | -19931718 | -80696043
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -140864 | -591276 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | -140864 | -591276
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -1241 | -5365.339400000001
 |  |  | 0 | 0
23 | Fuel: |  | -169252 | -618254
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -394846
25 |  | Demand | 0 | -1651518
 | Total Transport Expense: |  | 0 | -2046364
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 2363966.3221
31 |  | Prior Month Book Balance | 0 | 190000
 |  | Total MTM Income | 0 | 2553966.3221
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -1963284.1919
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -9486
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 904715
39 |  | Canada | 0 | 306233
40 |  | Miscellaneous | 0 | -3708
 |  | TOTAL INTRA-MTH
Spreadsheet: 1a933b72-0913-433f-b120-99eb964379a5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | Calculating Daily [NAME]
 |  |  | Enter weight in lbs
 |  |  |  |  |  |  | 100 | lbs
 |  | Enter Hours of Exercise/Day
 |  |  |  |  |  | Hours | 2 | hr(s)
 |  |  |  |  |  | Data | Total
 |  |  |  |  |  | [NAME] | 3
 |  |  |  |  |  | High CHO | 4
 |  | Your CHO needs are between
 |  |  |  | 300 | g |  | and | 400 | g
 |  | Calculating Daily [NAME]
 |  |  | Enter weight in kg
 |  |  |  |  |  |  | 85 | [NAME]
 |  | Enter Hours of Exercise/Day
 |  |  |  |  |  | Hours | 1 | hr(s)
 |  |  |  |  |  | Data | Total
 |  |  |  |  |  | [NAME] | 2.5
 |  |  |  |  |  | High CHO | 4
 |  | Your CHO needs are between
 |  |  |  | 468.48230675 | g | g | and | 650 | g
 |  | NOTE: Maximum amount of CHO per day is usually 650 grams.
Spreadsheet: 137517d1327174881-excel-2007-convert-xls-to-csv-book1
Sheet: Sheet1

COMPANY | Shipping Address | Billing Address | CITY | STATE | Industry | Member of | Type
B & B Specialties, Inc. | 1110 25th Ave. N. | PO Box 1615 | Kansas City | MO | Construction (Heavy) | AGC | Prospect
Hilton Construction Co. |  | PO Box 280 | Moorhead | MN | Construction (Heavy) | AGC | Prospect
Ag Drainage Systems | 6582 Co. Road #4W SW |  | Dallas | TX | Construction (Heavy) | AGC | Prospect
Aesa Energy | 3030 24th Ave. South |  | Moorhead | MN | Construction (Heavy) | AGC | Prospect
Galyon Seed and Supply, Inc. | 445 7th St. NW |  | Duluth | MN | Construction (Heavy) | AGC | Prospect
LME Corporation | 704 West Highway 14 & 34 | PO Box 697 | Aberdeen | SD | Construction (Heavy) | AGC | Prospect
Stone Industries | 800 Holiday Drive #240 | PO Box 1036 | Spokane | WA | Construction (Heavy) | AGC | Prospect
Resources, Inc. | 5621 53rd Ave. SW |  | Baltimore | MD | Construction (Heavy) | AGC | Prospect
Western, Inc. | 4010 Rifle Range Drive | PO Box 2319 | Boston | MA | Construction (Heavy) | AGC | Prospect
Aceo Construction, Inc. | 2520 N. Clermont St. | PO Box 12 | Milwaukee | WI | Construction (Heavy) | AGC | Prospect
Spreadsheet: 116957d1312362580-array-formula-or-possible-macro-to-match-and-calculate-between-multiple-sheets-testbook
Sheet: Dish Databse

Ingredient | Unit | Falafel Wrap | [NAME] | Shrimp Wrap | Salmon Wrap
Chickpeas | oz |  | ? | ? | ?
Carrots | oz | ? | ? | ? | ?
Butter | oz | ? | ? | ? | ?
Salt | oz | ? | ? | ? | ?
Sugar | oz | ? | ? | ? | ?
Spreadsheet: 773758d1648036785-duplicate-and-look-up-workbook
Sheet: Sheet1

source data - all projects (sheet 1) |  |  |  |  |  | source data - multi site projects  (sheet 2)
ID | Project | Site | Longditude | Latitude |  | ID | Project | Site | Longditude | Latitude
P1 | Project 1 | Site A | 50.1 | -0.7695 |  | P6 | Project 6 | Site A | 50.1 | -0.7695
P2 | Project 2 | Site B | 50.05 | -0.9654 |  | P6 | Project 6 | Site C | 50.205 | -0.8463
P3 | Project 3 | Site C | 50.205 | -0.8463 |  | P6 | Project 6 | Site D | 51.1023 | -0.5689
P4 | Project 4 | Site C | 50.205 | -0.8463 |  | P10 | Project 10 | Site C | 50.205 | -0.8463
P5 | Project 5 | Site A | 50.1 | -0.7695 |  | P10 | Project 10 | Site D | 51.1023 | -0.5689
P6 | Project 6 | Multi Sites | 50.05 | -0.9654
P7 | Project 7 | Site C | 50.1 | -0.7695
P8 | Project 8 | Site D | 51.1023 | -0.5689
P9 | Project 9 | Site A | 50.1 | -0.7695
P10 | Project 10 | Multi Sites | 51.1023 | -0.5689
this is the  table that needs to be automatically produced based on the source data above (sheet 3)
Site | Project | Project | Project | Project | Project
A |  |  |  |  |  | POST#6 formula
C
D
 |  |  |  |  |  | POST#8 formula
Spreadsheet: 732254d1620844229-matriculation-worksheet-stuck-sample1-2-
Sheet: Sheet1

 |  |  | Months from Opening
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | # of Clients | 7.68 | 15 | 23.04 | 30 | 30 | 30 | 30 | 40 | 40 | 50 | 50 | 50
 |  | New Clients | 7.68
CENTER 1 |  | 0 | 44409 | 44440 | 44470 | 44501 | 44551 | 44562 | 44593 | 44621 | 44652 | 44682 | 44713 | 2022-07-01 00:00:00
Census |  |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1
Spreadsheet: 84219d1284224065-how-to-sum-from-multiple-references-of-the-same-number-sum-query
Sheet: Sheet1

 | Cost | Number
 | 12.13 | 12
 | 13.34 | 10
 | 34.31 | 11
 | 56.67 | 13
 | 12.13 | 12
 | 13.34 | 10
 | 34.31 | 11
 | 56.67 | 13
 | 56.67 | 12
 | 10.19 | 10
 | 11.14 | 11
 | 12.45 | 13
 | Number | Earned
 | 10 | total amount of b3:b14
 | 11
 | 12
 | 13
Spreadsheet: 62122d1263038040-match-after-test
Sheet: Sheet1

Data |  | I want Like this
2
[NAME] |  | [NAME] | Sunrise | Sunset | Moonrise | Indian Month | [NAME] | Tithi | Naksjatra | Yog | Karana | Karana | Karana | Sun | [NAME]
Sunrise:07:18 |  | 0 | 07:18:00 | 17:32:00 | 19:31:00 | Pausha | 1900-01-01 00:00:00 | Dvitiya 17:43:24 | Pushya 25:11:16+ | Vaidhriti 17:44:48
Sunset:17:32
Moonrise:19:31
Indian Month : Pausha
[NAME] :
Tithi:Dvitiiya 17:43:24
[NAME]:Pushya 25:11:16+
Yog:Vaidhriti 17:44:48
Karana:Taitila 07:28:17
[NAME]:Garaja 17:43:24
Karana:Vanija 28:00:25+
Sun: Dhanus
[NAME]: [NAME]
Rahukalam:09:51-11:09
Yamakandam:13:41-14:59
GK:07:18-08:36
AJ:12:04-12:46
DM:07:18-08:00
DM:07:59-08:41
V:11:02-12:27
AK:19:32-20:57
Spreadsheet: 881702d1729846317-calculate-min-and-max-time-in-a-sequence-of-times-over-several-days-madinsdale-min-and-max-365-aligw
Sheet: Sheet1

Date | Time | MIN Time | MAX Time
03/06/2013 | 08:04:49
03/06/2013 | [NAME]
03/06/2013 | 08:36:39
03/06/2013 | 11:01:46
03/06/2013 | 11:02:16
[NAME] | [NAME]
[NAME] | 09:22:59
[NAME] | 09:23:58
[NAME] | 07:46:53
[NAME] | 07:46:56
[NAME] | 08:28:52
[NAME] | 09:31:42
[NAME] | 09:33:41
06/06/2013 | 10:58:50
06/06/2013 | 10:59:28
07/06/2013 | 08:12:55
07/06/2013 | 08:39:07
07/06/2013 | 09:54:34
07/06/2013 | [NAME]
Spreadsheet: 753a73e9-f354-43c0-b842-810abe50f2e1
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Curb Records | 715187915725 | Plumb | Beautiful History: A Hits Collection | 2009-11-03 | Compact Disc | Rock | 13.99 | Y | Available
Curb Records | 715187874022 | Plumb | Beautiful Lumps Of Coal | 2003-03-08 | Compact Disc | Pop | 7.99 | N | To Be Retired
Curb Records | 715187888227 | Plumb | Chaotic Resolve | 2006-02-28 | Compact Disc | Rock | 9.99 | N | To Be Retired
Curb Records | 715187897823 | Plumb | Blink | 2007-10-09 | Compact Disc | Rock | 9.99 | N | To Be Retired
Curb Records | 715187915428 | Plumb | Beautiful History: A Hits Collection (2 Disc Version) | 2009-11-03 | Compact Disc | Rock | 13.99 | N | To Be Retired
Curb Records | 715187931725 | Plumb | Need You Now | 2013-02-26 | Compact Disc | Rock | 13.99 | Y | Available
Spreadsheet: 00c45a41-9a7d-4fe7-adeb-f44769f3c804
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
 | 6427.0 Producer Price Indexes, Australia
 | Table 15. Metallic input to the Fabricated metal product manufacturing industry, index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  Iron and Steel ; |  |  | Original | A2312240V | 1985-09-01 00:00:00 | 2012-12-01 00:00:00 | 110 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Aluminium ; |  |  | Original | [NAME] | 1985-09-01 00:00:00 | 2012-12-01 00:00:00 | 110 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Copper and brass ; |  |  | Original | A2313779T | 1985-09-01 00:00:00 | 2012-12-01 00:00:00 | 110 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Zinc ; |  |  | Original | A2313782F | 1985-09-01 00:00:00 | 2012-12-01 00:00:00 | 110 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: 108549d1305603519-largest-date-until-sum-10-largestdatesample-mod
Sheet: Sheet1

 | Date | Color | Count |  | 10
 | 2010-01-11 00:00:00 | Red | 1
 | 2010-01-15 00:00:00 | Blue
 | 2010-01-15 00:00:00 | Blue
 | 2010-01-16 00:00:00 | Red
 | 2010-01-16 00:00:00 | Blue | 1
 | 2009-08-29 00:00:00 | Red
 | 2010-01-17 00:00:00 | Red | 1
 | 2010-01-26 00:00:00 | Blue | 3
 | 2010-01-26 00:00:00 | Red | 2
 | 2010-01-28 00:00:00 | Red
 | 2010-02-01 00:00:00 | Red | 1
 | 2010-02-11 00:00:00 | Blue | 3
 | 2010-03-13 00:00:00 | Blue
 | 2010-03-13 00:00:00 | Red
 | 2010-03-14 00:00:00 | Green | 4
 | 2010-03-19 00:00:00 | Blue
 | 2010-03-21 00:00:00 | Blue | 1
 | 2010-03-21 00:00:00 | Blue | 1
 | 2010-03-21 00:00:00 | Blue
 | 2010-04-15 00:00:00 | Red | 2
 | 2010-04-16 00:00:00 | Blue
Spreadsheet: 584009d1532919802-training-matrix-employee-records-management-copy-of-sample-data-trench3368-
Sheet: Course Query

Report for training outstanding / lapsed by course
[NAME] | Names
TC1
TC2
TC3
TC4
Spreadsheet: 858985d1707469272-no-border-for-empty-cells-excel-border-issue-cf
Sheet: Sheet1

 | DESIRED BORDERS, NO LINES FOR EMPTY CELLS |  |  |  |  |  |  |  | LINES FOR EVERY CELL
 |  |  | 2020 | 2021 | 2022 | 2023 | 2024 |  |  |  | 2020 | 2021 | 2022 | 2023 | 2024
 | North | Q1 |  |  |  |  |  |  | North | Q1
 |  | Q2 |  |  |  |  |  |  |  | Q2
 |  | Q3 |  |  |  |  |  |  |  | Q3
 |  | Q4 |  |  |  |  |  |  |  | Q4
 | South | Q1 |  |  |  |  |  |  | South | Q1
 |  | Q2 |  |  |  |  |  |  |  | Q2
 |  | Q3 |  |  |  |  |  |  |  | Q3
 |  | Q4 |  |  |  |  |  |  |  | Q4
 | West | Q1 |  |  |  |  |  |  | West | Q1
 |  | Q2 |  |  |  |  |  |  |  | Q2
 |  | Q3 |  |  |  |  |  |  |  | Q3
 |  | Q4 |  |  |  |  |  |  |  | Q4
 | East | Q1 |  |  |  |  |  |  | East | Q1
 |  | Q2 |  |  |  |  |  |  |  | Q2
 |  | Q3 |  |  |  |  |  |  |  | Q3
 |  | Q4 |  |  |  |  |  |  |  | Q4
 | CELLS WITH CF
 |  |  |  | 2020 | 2021 | 2022 | 2023 | 2024
 | North |  | Q1
 |  |  | Q2
 |  |  | Q3
 |  |  | Q4
 | South |  | Q1
 |  |  | Q2
 |  |  | Q3
 |  |  | Q4
 | West |  | Q1
 |  |  | Q2
 |  |  | Q3
 |  |  | Q4
 | East |  | Q1
 |  |  | Q2
 |  |  | Q3
 |  |  | Q4
 | NO LINE AT THE END
Spreadsheet: 66292d1266975174-print-macro-or-vb-code-print-example-100
Sheet: Sheet1

 |  | I'm looking for a print macro or VB code that would add a print button to a report, input would be the "Start Date" and "End Date" then you would pudh the "Print" button
 |  | The other option would be to enter the "Start Date" and "end date" and have the print button hide all of the rest of the columns and print only the visible columns. The spreadsheet is big, it has all 365 days as columns.
 |  |  | Enter Beginning Date |  | Enter End Date | Press Print Button
Print Range |  | Start Date |  | End Date |  | Print
id | Name | Time Type | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00
 |  | Daily Incidental | 1 | 3 | 4 | 4 | 9 | 7
Spreadsheet: 742483d1627805534-sumifs-with-date-as-one-criteria-budget-sample
Sheet: Cashflow

 | Date | Description | Position | Position | Amount
 | 2021-01-03 00:00:00 |  | Groceries |  | 200
 | 2021-01-04 00:00:00 |  | Groceries |  | 21
 | 2021-01-05 00:00:00 |  | Rent or Mortgage |  | 12.56
 | 2021-01-15 00:00:00 |  |  | Salary | 500
 | 2021-01-16 00:00:00 |  | Phone |  | 12
 | 2021-01-17 00:00:00 |  | Daily Supplies |  | 5.49
 | 2021-02-13 00:00:00 |  | Groceries |  | 12
 | 2021-02-14 00:00:00 |  |  | Salary | 400
 | 2021-02-15 00:00:00 |  | Groceries |  | 52
 | 2021-02-16 00:00:00 |  | Daily Supplies |  | 17
 | 2021-03-04 00:00:00 |  | Daily Supplies |  | 5
 | 2021-03-05 00:00:00 |  | Public Transport |  | 2.4
 | 2021-03-06 00:00:00 |  | Public Transport |  | 2.1
 | 2021-03-07 00:00:00 |  | Shopping |  | 69
 | 2021-03-08 00:00:00 |  | Other |  | 23
 | 2021-04-22 00:00:00 |  |  | Salary | 700
 | 2021-04-23 00:00:00 |  | Shopping |  | 20
 | 2021-04-25 00:00:00 |  | Insurance |  | 600
 | 2021-04-27 00:00:00