tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 676666d1588924585-index-based-on-date-and-value-index-based-on-date-and-value-3-
Sheet: Sheet1

 | Value1 | Value2 |  |  |  |  |  |  | DATA
2019-09-02 00:00:00 |  |  | Index all values from the DATA |  |  |  |  | Date | Descritpion | Value
 |  |  |  |  |  |  |  | 2019-09-05 00:00:00 | Week1 | Value1
 |  |  |  |  |  |  |  | 2019-09-10 00:00:00 | Week2 | Value1
 |  |  |  |  |  |  |  | 2019-09-24 00:00:00 | Week4 | Value1
 |  |  |  |  |  |  |  | 2019-09-30 00:00:00 | Week5 | Value1
 |  |  |  |  |  |  |  | 2019-10-11 00:00:00 | Week6 | Value1
 |  |  |  |  |  |  |  | 2019-10-19 00:00:00 | Week7 | Value1
 |  |  |  |  |  |  |  | 2019-10-22 00:00:00 |  | Value1
 |  |  |  |  |  |  |  | 2019-10-29 00:00:00 | Week9 | Value1
 |  |  |  |  |  |  |  | 2019-11-07 00:00:00 | Week10 | Value1
 |  |  |  |  |  |  |  | 2019-09-05 00:00:00 | Week2 | Value2
 |  |  |  |  |  |  |  | 2019-09-10 00:00:00 |  | Value2
 |  |  |  |  |  |  |  | 2019-09-24 00:00:00 | Week5 | Value2
 |  |  |  |  |  |  |  | 2019-09-30 00:00:00 | Week6 | Value2
 |  |  |  |  |  |  |  | 2019-10-11 00:00:00 |  | Value2
 |  |  |  |  |  |  |  | 2019-10-19 00:00:00 | Week8 | Value2
 |  |  |  |  |  |  |  | 2019-10-22 00:00:00 | Week9 | Value2
 |  |  |  |  |  |  |  | 2019-10-29 00:00:00 | Week10 | Value2
 |  |  |  |  |  |  |  | 2019-11-07 00:00:00 | Week11 | Value2
Spreadsheet: 101831d1299864310-index-within-date-range-example
Sheet: Sheet1

Period | Beginning Date | Ending Date |  |  |  | Date | Period
1 | 2010-01-01 00:00:00 | 2010-01-08 00:00:00 |  |  |  | 2010-01-12 00:00:00
2 | 2010-01-08 00:00:00 |  |  |  |  | 2010-03-24 00:00:00
3 | 2010-01-15 00:00:00 |  |  |  |  | 2010-02-16 00:00:00
4 | 2010-01-22 00:00:00 |  |  |  |  | 2010-04-01 00:00:00
5 | 2010-01-29 00:00:00 |  |  |  |  | 2010-02-18 00:00:00
6 | 2010-02-05 00:00:00 |  |  |  |  | 2010-01-23 00:00:00
7 | 2010-02-12 00:00:00
8 | 2010-02-19 00:00:00
9 | 2010-02-26 00:00:00
10 | 2010-03-05 00:00:00
11 | 2010-03-12 00:00:00
12 | 2010-03-19 00:00:00
13 | 2010-03-26 00:00:00
14 | 2010-04-02 00:00:00
15 | 2010-04-09 00:00:00
Spreadsheet: 114639d1310393161-conditional-formatting-help-sales-by-fiscal-week-dummy
Sheet: stockout lost sales

 | wk1 | wk2 | wk3
store 1 |  | 0 | 0 | 0 | 0 | 0
store 2 |  | 114.5 | 0 | 0 | 0 | 0
store 3 |  | 15.5 | 0 | 31 | 0 | 0
Spreadsheet: 140133d1328630755-array-parameters-test-17-
Sheet: Sheet1

 |  | sizes | 0.5 | 1 | 1.5 | 2 | 2.5 | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7
 |  | These numbers input by user | 1 | 2 | 3 | 8 | 15 | 24 | 14 | 5 | 4 | 4 | 5 | 0 | 0 | 1
 |  |  |  |  | x = | 1.5 |  |  |  |  |  | x is a variable
 |  | 0
 |  | Parameters | < half x | =Half x | < x  but          > half | same as x | > X  but        < 2* X | =2 * X | > 2* X
 |  | Frequency
 |  | I need a formula to fill in the 'frequency' boxes, I've made a start with the same as, 2 * and divided by 2 boxes, although the divided by doesn’t work properly for some reason.
 |  | I need to sum the values in the red boxes that fall within the parameters described.
 |  | x will not always match the | sizes exactly when divided by two
Spreadsheet: kevin_presto__19986__EAST SUMMARY TOP COUNTERPARTIES ALL REGIONS 2
Sheet: Nepool SummeryDec 27th-Jan2nd

PEAK |  | 2001-12-27 00:00:00 | 2001-12-28 00:00:00 | 2001-12-29 00:00:00 | 2001-12-30 00:00:00 | 2001-12-31 00:00:00 | 2002-01-01 00:00:00 | 2002-01-02 00:00:00
VEPCO |  | -200 | -200 |  |  | -200 | 300 | -250
SELECT |  | -175 | -175 | -75 | -75 | -175 | -350 | -275
HQ |  | -650 | -650 | 100 | 100 | -650 | 0 | 200
BECO |  | -50 | -50 |  |  | -50
TAUNTONMUN |  |  |  |  |  |  | -25 | -25
TXU |  | 100 | 100 | 0 | 0 | 100 | 0 | 150
CMPC |  | -275 | -275 | -275 | -275 | -275 | -275 | -275
UI |  | -695 | -695 | -695 | -695 | -695 | -695 | -695
NSTAR |  | -62 | -62 | -62 | -62 | -62 | -62 | -62
 | Total Position
 | Market Price | 35 | 35 | 25 | 25 | 35 | 30 | 40
 | Cost
OFF-PEAK
HQ |  | 100 | 100 | 100 | 100 | 100 | 0 | 0
SELECT |  | -75 | -75 | -75 | -75 | -75 | -350 | -350
TAUNTON |  |  |  |  |  |  | -25 | -25
VEPCO |  |  |  |  |  |  | 300 | 300
CMPC |  | -275 | -275 | -275 | -275 | -275 | -275 | -275
UI |  | -695 | -695 | -695 | -695 | -695 | -695 | -695
NSTAR |  | -62 | -62 | -62 | -62 | -62 | -62 | -62
 | Total Position
 | Market Price | 25 | 25 | 25 | 25 | 25 | 30 | 30
 | Cost
 |  |  |  |  |  |  | Total Cost in Nepool
Spreadsheet: cd5678b3-bb89-4d74-b126-af65221c3a06
Sheet: Clinical

Dept No. | Department Name | Manager | Phone | Manager [NAME] | Manager [NAME] | Chair/Dean/Director | Phone | Chair Email | Department Address | Division
4215 | Urology | [NAME] | 445-5298 | [NAME] | [NAME] | Raj Pruthi | 843-9330 | [EMAIL] | 2113 Physicians Office Building | Clinical
4216 | Pathology | [NAME] | 966-4676 | [EMAIL] | [NAME] | [NAME] | 966-4676 | [EMAIL] | 301 Brinkhous Bullitt Building | Clinical
4222 | UNC Center for Heart & Vascular Care | [NAME] | 843-5429 | [EMAIL] | [NAME] | [NAME] | 843-6477 | [EMAIL] | 101 Manning Drive | Clinical
4228 | Medicine | Bruce Wicks  [NAME] | 843-[PHONE] | [EMAIL]  [EMAIL] | [NAME] | Marschall Runge | 966-4468 | [EMAIL] | 125 MacNider Hall | Clinical
4229 | Dermatology | [NAME] | 843-4911 | [EMAIL] | [NAME] | [NAME] | 843-6756 | [EMAIL] | 405 [NAME] | Clinical
4230 | Neurology | [NAME] | 966-5548 | [EMAIL] | [NAME] | [NAME] | 966-5522 | [EMAIL] | Physicians Office Building, 170 Manning Drive | Clinical
4232 | Family Medicine | [NAME] | 966-3102 | [EMAIL] | [NAME] | [NAME] | 966-3711 | [EMAIL] | 590 Manning Drive | Clinical
4233 | Neurosurgery | [NAME] | 962-5099 | [EMAIL] | [NAME] | [NAME] | 966-1374 | [EMAIL] | Physicians Office Building, 170 Manning Drive | Clinical
4236 | Obstetrics & Gynecology | [NAME] | 966-8938 | [EMAIL] | [NAME] | [NAME] | 966-5281 | [EMAIL] | 3009 Old Clinic Building | Clinical
4238 | Otolaryngology (ENT) | [NAME] | 966-3342 | [EMAIL] | [NAME] | [NAME] | 966-8926 | [EMAIL] | Physicians Office Building, Room G-190 | Clinical
4244 | Ophthalmology | [NAME] | 966-5296 | [EMAIL] | [NAME] | [NAME] | 843-0297 | [EMAIL] | 5151 Bioinformatics Building | Clinical
4248 | Pediatrics | [NAME] | 843-8748 / 843-8747 | [EMAIL] | [NAME] | [NAME] | 966-9145 | [EMAIL] | 260 MacNider Hall | Clinical
4256 | Psychiatry | [NAME] | 966-8485 | [EMAIL] | [NAME] | [NAME] | 966-4738 | [EMAIL] | 10617 Neurosciences Hospital | Clinical
4260 | Radiology | [NAME] | 966-3521 | [EMAIL] | [NAME] | [NAME] | 966-4406 | [EMAIL] | 2006 Old Clinic Builidng | Clinical
4262 | Radiation Oncology | [NAME] | 966-0400 | [EMAIL] | [NAME] | [NAME] | 966-0400 | [EMAIL] | 101 [NAME], [NAME], Room CB325 | Clinical
4264 | Surgery | [NAME] | 843-1236 | [EMAIL] | [NAME] | [NAME] | 966-4320 | [EMAIL] | 4001 Burnett-Womack Building | Clinical
4265 | Orthopaedics | vacant |  |  | [NAME] | [NAME] | 966-9066 | [EMAIL] | 3147 Bioinformatics Building | Clinical
4266 | Emergency Medicine | [NAME] | 843-2611 | [EMAIL] | [NAME] | [NAME] | 843-3045 | [EMAIL] | Physicians Office Building, 170 Manning Drive | Clinical
4268 | Anesthesiology | [NAME] | 966-6182 | [EMAIL] | [NAME] | [NAME] | 966-5136 | [EMAIL] | N2198 UNC Hospitals | Clinical
4273 | Allied Health | [NAME] | 843-4828 | [EMAIL] | [NAME] | [NAME] | 966-5171 | [EMAIL] | 3108 Bondurant Hall | Clinical
4296 | Physical Medicine & Rehabilitation | [NAME] | 966-0316 | [EMAIL] | [NAME] | [NAME] | 966-5164 | [NAME] | [NAME] 7009 UNC [NAME] | Clinical
Spreadsheet: 153479d1335933113-index-match-help-example-2
Sheet: Rail Operations

[NAME] Event Detail
 |  |  |  |  | RAIL OPERATIONS (1902878)
Reported Date | Claim ID | Division (FLEET DATA LEVEL_06_NODE_DS) | Name | Location | Event Description | Accident Date
IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN X ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN Q ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN J ON 'FLEET DATA ACC DETAIL' |  | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN AB ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN V ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN W ON 'FLEET DATA ACC DETAIL'
DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN
Spreadsheet: 0100b462-c164-42c7-b86f-59a8836a8c42
Sheet: Sheet1

13-009 Plant Protection Tabulation Sheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  |  | Vendor Notes
Item | Quantity | Description | Requested Packing | Unit Price | UOM | Extended
 | INSECTICIDES
1. | 128 oz | Merit 75 (or equivalent) WG, WP | 4 x 1.6 oz packets |  | case
2. | 100 LBS | Acephate 75 wg | 1 LB cans |  | case
3. | 150 LBS | Advion fire ant bait | 2 lb canisters |  | case
4. | 20 gals | [NAME] (or equivalent) | 2.5g bottle |  | case
 | HERBICIDES
5. | 150 gal. | Round Up/Pro | 2.5 gal. |  | case
6. | 80 bottles | Sedge-Hammer | 1.3 oz |  | bottle
7. | 150 gals. | 3-Way (24D) | 2.5 gal. |  | case
8. | 500 gal. | Aqua-Master | 2.5 gal |  | case
9. | 200 grams | Monument | 5 x 5-gram packets |  | box
10. | 100 lbs. | Sure-Guard | 5 lbs bottle |  | case
 | Additives  &  Aquatics
11. | 500  gal. | Spi-Max Blue Dye Indicator | 2.5 gal. |  | case
12. | 1000 lbs | GreenClean Pro Algaecide | 50 lb. [NAME] |  | bag
13. | 500 gal. | Aquatic Surfactant  - Red River | 1 gal |  | case
14. | 750 gal. | Surfactant  - Surf-AC 820 | 1 gal |  | case
Spreadsheet: 50c0393f-8f3b-4a37-8277-55c461d48a2b
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
IONCG | Test | IONCG | Calcium, Ionized, Serum | Calcium, Ionized, S | Ion-Selective Electrode (ISE) | Serum Gel Tube: SGT |  |  |  | Varies | Container/Tube: Serum gel [NAME]: Full tube Collection Instructions: 1. Allow blood to clot for 30 minutes. 2. Centrifuge with stopper in place for 10 minutes at 2,000 rpm to ensure that the gel barrier separates the serum and cells. 3. Keep specimen anaerobic (do not transfer). | Serum gel tube must be >50% fill | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; [NAME] OK Icterus	NA Other	[NAME] in plastic vial | Males <1 year: not established 1-19 years: 4.90-5.50 mg/dL > or =20 years: 4.65-5.30 mg/dL Females <1 year: not established 1-17 years: 4.90-5.50 mg/dL > or =18 years: 4.65-5.30 mg/dL | Monday through Friday, Sunday; Available STAT | 1 day | 2 days | 1 | 82330 |  |  |  |  | New England
IONCG | [NAME] | SST | Serum SST |  |  |  | Refrigerated | 7 days
IONCG | Result | 11304 | Calcium, Ionized, S | Calcium, Ionized, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 17863-2
Spreadsheet: 723852d1615917843-need-a-formula-to-read-a-range-of-cell-sample
Sheet: Sheet1

 | B16:E21 |  | 3 | 4
 |  |  | Q1 Actual | Q1 EST
 |  |  |  |  |  | Need a formula in D7 to read the range in cell B3
 | License |  |  |  |  | VLOOKUP($B7, $[NAME], D$3, 0)
 | Maint
 | Service
 | Subscriptions
 | Support
 | Total
 | License |  | 40 | 835.8715100000001
 | Maint |  | 0 | 0
 | Service |  | 0 | 0
 | Subscriptions |  | 99 | 755.75248
 | Support |  | 0 | 188.02177
 | Total
 | License |  | 736 | 4558
 | Maint |  | 90 | 0
 | Service |  | 855 | 0
 | Subscriptions |  | 255 | 95
 | Support |  | 463 | 4445
 | Total
Spreadsheet: 0e30daf1-5d56-45c4-aa73-8c45f5a05b6e
Sheet: Budget 2 F-K

*ORGANIZATIONAL DUNS:
*Budget Type: |  | Project: |  | Subaward/Consortium:
*Name of Organization:
*Start Date: |  |  | *End Date: |  |  | *Budget Period: | 2
F. Other Direct Costs |  |  |  |  |  |  |  | *Funds Requested ($)
1. | Materials and Supplies |  |  |  |  |  |  | 0
2. | Publication Costs |  |  |  |  |  |  | 0
3. | Consultant Services |  |  |  |  |  |  | 0
4. | ADP/Computer Services |  |  |  |  |  |  | 0
5. | Subawards/Consortium/Contractual Costs |  |  |  |  |  |  | 0
6. | Equipment or Facility Rental/User Fees |  |  |  |  |  |  | 0
7. | Alterations and Renovations |  |  |  |  |  |  | 0
8. |  |  |  |  |  |  |  | 0
9. |  |  |  |  |  |  |  | 0
10. |  |  |  |  |  |  |  | 0
 |  |  |  |  | Total Other Direct Costs
G.  Direct Costs |  |  |  |  |  |  |  | Funds Requested ($)
 |  |  |  |  |  | Total Direct Costs (A thru F)
H. Indirect Costs
 | Indirect Cost Type |  |  |  |  | *Indirect Cost Rate (%) | *Indirect Cost Base ($) | *Funds Requested ($)
1. |  |  |  |  |  | 0 | 0
2. |  |  |  |  |  | 0 | 0
3. |  |  |  |  |  | 0 | 0
4. |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | Total Indirect Costs
Cognizant Federal Agency
(Agency Name, POC Name, and POC Phone Number)
I.  Total Direct and Indirect Costs |  |  |  |  |  |  |  | Funds Requested ($)
 |  |  |  | Total Direct and Indirect Institutional Costs (G + H)
[NAME] |  |  |  |  |  |  |  | Funds Requested ($)
 |  |  |  |  |  |  |  | 0
K.  *Budget Justification |  |  | (Only attach one file)
 | * Required Field
Spreadsheet: 68975d1269511707-rounding-to-a-value-from-a-list-price_conversion_2
Sheet: Sheet1

Exchange rate | 0.86 |  |  | Round up from this percentage from lower number: | 0.4
Original Price | Converted Price | Adjusted prices |  | Limits | Psychological Prices
2.95 |  |  |  | 0 | 2.7
3.95 |  |  |  |  | 3.6
4.95 |  |  |  |  | 4.6
5.95 |  |  |  |  | 5.5
6.95 |  |  |  |  | 6.3
7.95 |  |  |  |  | 6.9
8.95 |  |  |  |  | 7.9
9.95 |  |  |  |  | 8.9
12.95 |  |  |  |  | 11.9
14.95 |  |  |  |  | 13.9
16.95 |  |  |  |  | 14.9
17.95 |  |  |  |  | 15.9
19.95 |  |  |  |  | 17.9
21.95 |  |  |  |  | 19.9
24.95 |  |  |  |  | 22.9
26.95 |  |  |  |  | 24.9
29.95 |  |  |  |  | 26.9
34.95 |  |  |  |  | 31.9
39.95 |  |  |  |  | 35.9
44.95 |  |  |  |  | 40.9
49.95 |  |  |  |  | 44.9
54.95 |  |  |  |  | 49.9
59.95 |  |  |  |  | 53.9
64.95 |  |  |  |  | 59.9
69.95 |  |  |  |  | 62.9
74.95 |  |  |  |  | 67.9
79.95 |  |  |  |  | 71.9
84.95 |  |  |  |  | 76.9
89.95 |  |  |  |  | 79.9
94.95 |  |  |  |  | 85.9
99.95 |  |  |  |  | 89.9
109.95 |  |  |  |  | 99.9
119.95 |  |  |  |  | 109.9
124.95 |  |  |  |  | 112.9
129.95 |  |  |  |  | 119.9
134.95 |  |  |  |  | 121.9
139.95 |  |  |  |  | 129.9
144.95 |  |  |  |  | 130.9
149.95 |  |  |  |  | 135.9
154.95 |  |  |  |  | 139.9
159.95 |  |  |  |  | 143.9
164.95 |  |  |  |  | 149.9
169.95 |  |  |  |  | 149.9
179.95 |  |  |  |  | 159.9
189.95 |  |  |  |  | 169.9
199.95 |  |  |  |  | 179.9
209.95 |  |  |  |  | 189.9
219.95 |  |  |  |  | 199.9
229.95 |  |  |  |  | 209.9
239.95 |  |  |  |  | 219.9
249.95 |  |  |  |  | 229.9
259.95 |  |  |  |  | 239.9
269.95 |  |  |  |  | 245.9
279.95 |  |  |  |  | 249.9
289.95 |  |  |  |  | 259.9
299.95 |  |  |  |  | 269.9
Spreadsheet: john_griffith__15648__05_09_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 420 | 39 | 43
N01-P/C | 425 | 67 | 72
Q01-P/C | 435 | 88 | 92
U01-P/C | 440 | 106 | 107.5
V01-P/C | 445 | 118 | 123
X01-P/C | 460 | 139.5 | 140
[NAME]-P/C | 475 | 159 | 163
F02-P/C | 485 | 174.5 | 176
G02-P/C | 470 | 178 | 180
H02-P/C | 450 | 162 | 165
J02-P/C | 425 | 124 | 128
K02-P/C | 420 | 111 | 121
M02-P/C | 430 | 113 | 123
U02-P/C | 435
Spreadsheet: 110593d1307206936-consolidate-multiple-data-tables-appendsourcetomasterpt
Sheet: Source2

Date | Amount
2011-06-14 00:00:00 | 25
2011-09-05 00:00:00 | 170
2011-07-29 00:00:00 | 8
2011-09-06 00:00:00 | 52
2011-06-28 00:00:00 | 15
2011-08-17 00:00:00 | 117
2011-08-11 00:00:00 | 10
2011-07-18 00:00:00 | 73
2011-07-13 00:00:00 | 82
2011-09-09 00:00:00 | 151
2011-06-18 00:00:00 | 14
2011-08-09 00:00:00 | 194
2011-08-22 00:00:00 | 63
2011-06-16 00:00:00 | 163
2011-08-17 00:00:00 | 150
2011-08-11 00:00:00 | 141
2011-07-21 00:00:00 | 119
2011-09-04 00:00:00 | 104
2011-08-28 00:00:00 | 46
2011-07-21 00:00:00 | 180
2011-07-25 00:00:00 | 85
2011-07-07 00:00:00 | 14
2011-07-13 00:00:00 | 151
2011-08-15 00:00:00 | 193
2011-08-02 00:00:00 | 105
2011-08-03 00:00:00 | 94
2011-08-21 00:00:00 | 142
2011-08-30 00:00:00 | 104
2011-06-10 00:00:00 | 190
2011-09-04 00:00:00 | 80
2011-06-29 00:00:00 | 129
2011-06-30 00:00:00 | 127
2011-07-24 00:00:00 | 45
2011-08-12 00:00:00 | 83
2011-07-08 00:00:00 | 183
2011-09-10 00:00:00 | 111
2011-07-23 00:00:00 | 146
2011-09-08 00:00:00 | 149
2011-08-29 00:00:00 | 101
2011-08-09 00:00:00 | 109
2011-08-02 00:00:00 | 84
2011-07-19 00:00:00 | 114
2011-09-02 00:00:00 | 192
2011-07-31 00:00:00 | 80
2011-07-11 00:00:00 | 153
2011-08-07 00:00:00 | 171
2011-06-26 00:00:00 | 133
2011-08-03 00:00:00 | 172
2011-06-14 00:00:00 | 162
2011-09-05 00:00:00 | 20
2011-07-20 00:00:00 | 133
2011-06-27 00:00:00 | 31
2011-08-27 00:00:00 | 113
2011-07-07 00:00:00 | 64
2011-08-24 00:00:00 | 56
2011-07-14 00:00:00 | 39
2011-06-15 00:00:00 | 46
2011-08-24 00:00:00 | 195
2011-08-19 00:00:00 | 36
2011-08-27 00:00:00 | 166
2011-06-16 00:00:00 | 193
2011-08-10 00:00:00 | 132
2011-06-21 00:00:00 | 66
2011-08-31 00:00:00 | 55
2011-07-03 00:00:00 | 14
2011-08-24 00:00:00 | 88
2011-07-05 00:00:00 | 50
2011-06-09 00:00:00 | 74
2011-06-14 00:00:00 | 21
2011-06-13 00:00:00 | 165
2011-06-19 00:00:00 | 163
2011-08-05 00:00:00 | 51
2011-08-31 00:00:00 | 35
2011-07-21 00:00:00 | 23
Spreadsheet: 32571d1228763541-relative-formula-copied-across-worksheets-example01
Sheet: 2

 |  | 6 | 7 |  |  | 8 | 9
 |  | 6 | 7 |  |  | 8 | 9
 |  | 6 | 7 |  |  | 8 | 9
 |  | 6 | 7 |  |  | 8 | 9
 |  | 6 | 7 |  |  | 8 | 9
Total to day |  | 30 | 35 |  |  | 40 | 45
Total to Date |  | 40 | 50 |  |  | 60 | 70
 | I want to copy the formula in cell  C12  to sheets 3, 4, & 5. Where the blue highlight is. But if I copy as is all the sheets will refer to the cell on sheet 1. What I want is to copy it and have the address change value representing sheet 1, which is  1, to change to sheet 2, sheet 3, sheet 4, sheet 5. All I am doing is totaling numbers, having the cell below that total represent the Total to Date    Total to Date
Spreadsheet: 70814d1271506736-names-to-numbers-mileagelog-2-
Sheet: Names & miles

date added | Name | [NAME] | Comments
 | [NAME] | 40 |  | 40
 | Bethan | 10
 | Chenga | 35
 | Gwyneth | 20
 | [NAME] | 60
 | Marcol | 100
 | Mario | 45
 | Rachelle | 35
 | Shahima | 35
 | martin | 50
 | fred | 1000
Spreadsheet: 0afe58b7-9e29-4a91-88f0-ab9f339fab56
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 41. OPERATING LEASE FINANCE COMMITMENTS, 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 | A2413817T | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2413818V | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2413819W | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2413820F | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2413821J | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2413823L | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2413824R | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2413825T | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2413826V | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Public Administration ; |  |  | Original | A2413827W | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2413828X | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2413829A | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413830K | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 72593d1273271195-match-data-dummya
Sheet: Sheet1

Company |  | 2.45 | 1.3 |  |  |  |  | Murphys | Whiskey house | topples | spinning wheel | the edge | Coalmans | Flannerys | The pit | Beer house | stewarts |  |  |  |  |  |  |  |  | pubs
Whiskey house |  | 4.8 | 0.88 |  |  |  |  | 1.4 | 2.45 | 2.41 | 1.3 | 6.63 | 1.59 | 1.01 | 2.09 | 3.05 | 2.95 |  |  |  |  |  |  |  |  | Murphys
topples |  | 1.79 | 1.76 |  |  |  |  | 0.86 | 4.8 | 1.87 | 0.88 | 2.43 | 0.84 | 2.81 | 2.84 | 1.48 | 1.51 |  |  |  |  |  |  |  |  | Whiskey house
spinning wheel |  | 4.42 | 1.48 |  |  |  |  | 1.73 | 1.79 | 0.77 | 1.76 | 2.74 | 1.78 | 1.72 | 3.3 | 1.42 | 2.15 |  |  |  |  |  |  |  |  | topples
The Edge |  | 2.72 | 0.73 |  |  |  |  | 1.45 | 4.42 | 3.46 | 1.48 | 1.49 | 1.42 | 1.47 | 2.9 | 7.01 | 3.42 |  |  |  |  |  |  |  |  | spinning wheel
Coalmans |  | 2.89 | 2.82 |  |  |  |  | 0.7 | 2.72 | 6.7 | 0.73 | 0.77 | 2.29 | 2.76 | 0.88 | 1.2 | 2.47 |  |  |  |  |  |  |  |  | The Edge
Flannerys |  | 5.5 | 0.51 |  |  |  |  | 2.8 | 2.89 | 1.22 | 2.82 | 2.84 | 2.81 | 2.83 | 0.98 | 3.21 | 3.04 |  |  |  |  |  |  |  |  | Coalmans
The Pit |  | 4.1 | 3.12 |  |  |  |  | 0.5 | 5.5 | 8.5 | 0.51 | 0.99 | 2.1 | 0.56 | 1.98 | 4.5 | 4.43 |  |  |  |  |  |  |  |  | Flannerys
Beer House |  | 2.53 | 2.58 |  |  |  |  | 3.1 | 4.1 | 1.33 | 3.12 | 3.15 | 0.9 | 3.16 | 5.9 | 2.2 | 1.65 |  |  |  |  |  |  |  |  | The Pit
Stewarts |  | 1.18 | 1.17 |  |  |  |  | 2.5 | 2.53 | 3.31 | 2.58 | 5.59 | 2.53 | 2.55 | 6 | 1.19 | 2.97 |  |  |  |  |  |  |  |  | Beer House
Murphys |  | 2.41 | 6.63 |  |  |  |  | 1.1 | 1.18 | 1.13 | 1.17 | 1.19 | 1 | 2 | 3.08 | 0.91 | 1.93 |  |  |  |  |  |  |  |  | Stewarts
 |  | 1.87 | 2.43
 |  | 0.77 | 2.74
 |  | 3.46 | 1.49 |  | if I pick a2(whiskey house) then c1:c10 will equal j2:j11 and if I pick a3(topples) then
 |  | 6.7 | 0.77 |  | c11:c20 equals k2:k11.But if I change a2 to (spinning wheel) then c1:c10 will change to
 |  | 1.22 | 2.84 |  | l2:l11.
 |  | 8.5 | 0.99
 |  | 1.33 | 3.15
 |  | 3.31 | 5.59
 |  | 1.13 | 1.19
Spreadsheet: mike_carson__27572__KOCH
Sheet: Sheet1

 | Power for delivery 1/5/02
 | On-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total
 |  | Postion | Price |  | Fee | COST | Dollars
 | Entergy | 100 | 21.05 |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -700 | 24.88 |  | 1
 | Comed | -100 | 24.15 |  | 1
 | Off-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total
 |  | Postion | Price |  | Fee |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 17.14 |  | 1
 | Comed | 0 |  |  | 1
 |  |  |  |  | Grand |  | Wire Amount
 |  |  |  |  | Total | >>>>>>
Spreadsheet: lisa_gang__22306__ENA_PGE_MAY 28_2002
Sheet: LOSSES

From: | EPMI
To: | PGE System Transactions
Date: | 2002-05-28 00:00:00
HE
ENDING | TOTAL |  | TOTAL
Pacific
Prevailing
Time
(PPT)
0100 | 0
0200 | 0
0300 | 0
0400 | 0
0500 | 0
0600 | 0
0700 | 6
0800 | 6
0900 | 6
1000 | 6
1100 | 6
1200 | 6
1300 | 6
1400 | 6
1500 | 6
1600 | 6
1700 | 6
1800 | 6
1900 | 6
2000 | 6
2100 | 6
2200 | 6
2300 | 0
2400 | 0
 | BPA(G)SYS | PGE | PGE
 | GAC | PGE LOSSES | [NAME] [NAME]
 | GAC(T)BPASYS/PGESYS | PGE | PGE
 | GAC
 | AVISTA
 | EPMI
 | PGE(L)SYS
 | NEW COLUMN