tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 33961d1230929158-new-idea-on-creating-excel-files-to-automatically-determine-proper-entry-john-eastland-example-sheet-with-edward-bentley-sum-if-function-revised
Sheet: Hours Worked By Month

Employee | 2003-01-01 00:00:00 | 2003-02-01 00:00:00 | 2003-03-01 00:00:00 | 2003-04-01 00:00:00 | 2003-05-01 00:00:00 | 2003-06-01 00:00:00 | 2003-07-01 00:00:00 | 2003-08-01 00:00:00 | 2003-09-01 00:00:00 | 2003-10-01 00:00:00 | 2003-11-01 00:00:00 | 2003-12-01 00:00:00 | 2004-01-01 00:00:00 | 2004-02-01 00:00:00 | 2004-03-01 00:00:00 | 2004-04-01 00:00:00 | 2004-05-01 00:00:00 | 2004-06-01 00:00:00 | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 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
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160
Spreadsheet: vkaminski__40657__ENA Weather & Research_Lanier 5722_KM~02-08-2000~IR
Sheet: High Vol~Color @ 22 CPM 

[NAME] {22 CPM} Production COLOR  COPIER  PRICING
All $ amounts quoted exclude taxes + If [NAME] is under Lease contract, there will be an Annual Property Tax too.
36 Month Lease {Prelim Pricing = Awaiting  $ Confirmation on Maintenance}
Machine |  |  | Maintenance
Model | LANIER 5722          {22 Copies per Minute} on 36 Month [NAME] |  | $ [NAME] | [NAME] INCLUDED |  | Cost Per Image**
Base Machine | 541.28 |  | [NAME] | 28.75 |  | 10,000 images |  | 5,000 images
RDF | 23.4 |  | NO Included Images {This # is for comparison purposes ONLY} | 5000 |  | 20,000 images |  | **NOTE: This CPI pricing is based on the Lanier 36 month Lease plan with the invoicing being sent directly to the person who orders the equipment.
Sorter/Staple | 65 |  | Overage $ | 0.11 |  | Total Monthly Payment for Machine, 5K images Maintenance INCLUDING Toner/Developer SUPPLIES
Monthly Payment for [NAME] |  |  | Maintenance on 5K images including base maint/cost
 |  |  | NO Included Images {This # is for comparison purposes ONLY} | 10000
 |  |  | Overage $ | 0.11
 |  |  | Maintenance on 5K images including base maint/cost
 |  |  | ***NOTE: Maintenance includes Toner, Developer, Parts, Labor and drum. Paper & Staples supplies are NOT included.
Spreadsheet: lindy_donoho__21969__TW2010ProjCap&Rev
Sheet: Hist Ave

HISTORICAL AVERAGES | 1Qtr | 2Qtr | 3Qtr | 4Qtr | Annual
West | 0.2577395738036288 | 0.2556540614556103 | 0.262556423525552 | 0.2499368055220567
East | 0.07765127986911959 | 0.05354242068597122 | 0.05169424094639299 | 0.05369964655378881
[NAME] | 0.04427150301078417 | 0.04449944721939635 | 0.04326539005011056 | 0.0392327525316379
San Juan | 0.1041950912069369 | 0.1041509866477608 | 0.1049705386976516 | 0.1039459391648738
Assume historical 2000 & 2001 averages for capacity rolling-off 2002 thru 2010.
Spreadsheet: 747392d1631464585-formula-help-to-help-build-a-stock-inventory-excel-help-om-edited
Sheet: Requirements

Candle 1 |  |  |  |  | Candle 2
Oil | OM005 | 10 | ml |  | Oil | OM005 | 10 | ml
Wick | [NAME] | 1 | piece |  | Wick | OM002 | 1 | piece
Wax | OM015 | 165 | g |  | Wax | OM014 | 170 | g
Vessel | OM017 | 1 | piece |  | Vessel | OM017 | 1 | piece
Label | OM022 | 1 | piece |  | Label | OM023 | 1 | piece
[NAME] | OM032 | 1 | piece |  | [NAME] | OM033 | 1 | piece
Candle Guard | OM041 | 1 | piece |  | Candle Guard | OM041 | 1 | piece
[NAME] | OM042 | 1 | piece |  | [NAME] | OM043 | 1 | piece
Spreadsheet: a4b2a8cb-480e-46cb-863c-26b2e4380cef
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
TXBU | Test | TXBU | 11-Dehydro-Thromboxane B2, [NAME] | 11-Dehydro-Thromboxane B2, U | TXBU: Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) AACT: Enzymatic Colorimetric Assay | Plastic, urine tube: PlUrTb |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 10 mL Collection Instructions:  1. Collect a random urine specimen. 2. No preservative. Additional Information: Patient should not have taken nonsteroidal anti-inflammatory drugs within 72 hours or aspirin within 2 weeks prior to collection of a specimen. | 5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | > or =18 years: 0-2,211 pg/mg creatinine Reference values have not been established for patients who are <18 years of age. Reference intervals apply to patients not taking agents known to influence platelet function (aspirin or other nonsteroidal anti-inflammatory drugs, thienopyridines, etc). Healthy individuals taking aspirin typically have 11-dehydro-thromboxane B2 concentrations below 500 pg/mg creatinine using this method. | Thursday; 8 a.m. | 2 days | 9 days | 1 | 84431 |  |  |  |  | Rochester
TXBU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
TXBU | Result | 83335 | 11-Dehydro-Thromboxane B2, U | 11-Dehydro-Thromboxane B2, U | Numeric |  |  |  |  | pg/mg Cr |  |  |  |  |  |  |  |  |  | 50686-5 | 11-Dehydro thromboxane beta 2/Creatinine:MRto:Pt:[NAME]:Qn:
TXBU | [NAME] | AACT | Creatinine, [NAME] | Creatinine, U | Enzymatic Colorimetric Assay |  |  |  | 1 |  | 1.0 mL in a 6-mL tube (supply T465) | 1.0 mL | Specimens Other Than: NA Anticoagulants Other Than: NA Hemolysis: NA Thawing: NA Lipemia: NA |  | Monday through Sunday; Continuously | 1 day | 1 day |  |  |  |  | Yes | No
AACT | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
Spreadsheet: 692829d1598600301-multiple-spreadsheet-values-required-and-data-returned-over-48hrs-excel-forum
Sheet: 17.08.2020

Emp No | Employee Name | Other Projects | Project Hours Total | Presence Hours | Absence Hours | Scheduled Hours
1 | [NAME] | Smith |  |  | 0 | 37
2 | [NAME] | Jones |  | 37 | 0 | 0
3 | Bobbi | [NAME] |  | 48 | 0 | 0
4 | [NAME] | Singh |  | 35.2 | 0 | 0
5 | [NAME] | [NAME] |  | 53 | 0 | 0
6 | Bertie | Davies |  | 47.5 | 0 | 0
7 | Obi | Stanley |  | 49.23 | 0 | 0
8 | Bobba | [NAME] |  | 39 | 0 | 0
9 | [NAME] | Bloggs |  | 56 | 0 | 0
10 | Sue | Toms |  | 52
11 | [NAME] | [NAME] |  | 76
12 | [NAME] | [NAME] |  | 49
Spreadsheet: 845921d1697212630-need-help-if-friday-date-jump-to-monday-date-only-weekdays-in-one-cell-test1
Sheet: Sheet1

WEIGHT: |  | LEAVE @ 3AM | Driver: | CHRIS | 00
Supervisor sign off on load:
WO # | PICK UP | CUSTOMER NAME | WEIGHT | STOP # | CITY | NOTES | LD/BY
[NAME]
SC/VA/GA MILEAGE IN |  |  | SC/VA/GA MILEAGE OUT
SC/VA/GA MILEAGE IN |  |  | SC/VA/GA MILEAGE OUT
MILEAGE AM |  |  | MILEAGE PM
BEGINNING TIME |  |  | ENDING TIME
START LOADING |  |  | [NAME]
COMMENTS
THIS MUST BE TURNED IN DAILY
Spreadsheet: 58097d1258409548-creating-a-sports-table-sportstable
Sheet: Fixtures

FIRST HALF
Match # | Week # | Date | Home Team | Score |  | Away Team | Venue
1 |  |  |  | 2 | 1
 |  |  |  | 2 | 0
 |  |  |  | 1 | 2
 |  |  |  | 2 | 1
Spreadsheet: 876205d1722881123-calculated-item-in-pivot-table-returning-unexpected-rows-calculated_item_example
Sheet: pivot

State | Program | Element | Sum of Actual | Sum of Budget | Sum of Budget Var
Indiana | Hotdoggers | Operating Margin | 0 | 0 | 0
Indiana | Little Leaguers | Operating Margin | 0 | 0 | 0
Indiana | [NAME] | Cost | 4588 | 5000 | -412
Indiana | [NAME] | Revenue | 13565 | 15000 | -1435
Indiana | [NAME] | Operating Margin | 8977 | 10000 | -1023
Indiana | Underhanders | Cost | 3600 | 5000 | -1400
Indiana | Underhanders | Revenue | 9100 | 15000 | -5900
Indiana | Underhanders | Operating Margin | 5500 | 10000 | -4500
Ohio | Hotdoggers | Cost | 4875 | 5000 | -125
Ohio | Hotdoggers | Revenue | 16509 | 15000 | 1509
Ohio | Hotdoggers | Operating Margin | 11634 | 10000 | 1634
Ohio | Little Leaguers | Cost | 4955 | 5000 | -45
Ohio | Little Leaguers | Revenue | 15777 | 15000 | 777
Ohio | Little Leaguers | Operating Margin | 10822 | 10000 | 822
Ohio | [NAME] | Operating Margin | 0 | 0 | 0
Ohio | Underhanders | Operating Margin | 0 | 0 | 0
Spreadsheet: 134801d1325635137-help-with-if-statement-mockup1
Sheet: 2

ID | Name | Class |  | ID | Name | Date | Gross Period BNAV | Beginning Net Capital Change | [NAME] BNAV
Smith_P | [NAME] | A_A2
Jones_A | [NAME] | A_B
Andrews_W | [NAME] | A_B
Smith_P | [NAME] | A_SP2
Jones_A | [NAME] | A_SP2
Andrews_W | [NAME] | A_SP5
Smith_P | [NAME] | A_SP6
Jones_A | [NAME] | A_SP7
Andrews_W | [NAME] | A_SP7
Blue will remain constant from sheet to sheet
Spreadsheet: 131829d1323348508-how-to-copy-information-from-non-consecutive-lines-into-consecutive-lines-example-v2
Sheet: Original table

 |  |  | Jan | Feb | Mar | Q1
 | Group 1 | Customer A | 100 | 30 | 40 | 170
 |  |  | 200 | 20 | 50 | 270
 |  |  | 0 | 30 | 100 | 130
 |  | Sum A | 300 | 80 | 190 | 570
 |  | Customer B | 50 | 100 |  | 150
 |  |  | 300 | 40 | 60 | 400
 |  |  | 0 |  | 0 | 0
 |  | Sum B | 350 | 140 | 60 | 550
 |  | Total Group 1 | 650 | 220 | 250 | 1120
 | Group 2 | Customer C | 20 | 30 | 40 | 90
 |  |  | 50 | 60 | 70 | 180
 |  |  | 100 | 90 | 80 | 270
 |  | Sum A | 170 | 180 | 190 | 540
 |  | Customer D | 90 | 50 | 40 | 180
 |  |  | 90 | 20 | 20 | 130
 |  | Sum B | 180 | 70 | 60 | 310
 |  | Customer E | 100 | 50 | 30 | 180
 |  |  | 20 | 40 | 0 | 60
 |  |  | 50 | 40 | 50 | 140
 |  |  | 20 | 70 |  | 90
 |  | Sum B | 190 | 200 | 80 | 470
 |  | Total Group 1 | 540 | 450 | 330 | 1320
 |  | TOTAL | 1190 | 670 | 580 | 2440
Spreadsheet: 162639d1340019844-need-helpformulating-the-price-with-various-condition-and-counting-sample
Sheet: TOTAL

DEMAND CODE | 1 |  | 1 |  | 2 |  | 3
Names | Code A | Code B | Code C | Code D | Code E | Code F | TOTAL PRICES
ABC
DEF
GHI
JKL
MNO
PQR
STU
Spreadsheet: 677000d1589137628-array-formula-daily
Sheet: daily

Date | Open | High | Low | Close |  |  | Constant | 25
2020-03-11 00:00:00 | 10334.299805 | 10545.099609 | 10334 | 10458.400391
2020-03-12 00:00:00 | 10039.950195 | 10040.75 | 9508 | 9590.150391
2020-03-13 00:00:00 | 9107.599609 | 10159.400391 | 8555.150391 | 9955.200195
2020-03-16 00:00:00 | 9587.799805 | 9602.200195 | 9165.099609 | 9197.400391
2020-03-17 00:00:00 | 9285.400391 | 9403.799805 | 8915.599609 | 8967.049805
2020-03-18 00:00:00 | 9088.450195 | 9127.549805 | 8407.049805 | 8468.799805
2020-03-19 00:00:00 | 8063.299805 | 8575.450195 | 7832.549805 | 8263.450195
2020-03-20 00:00:00 | 8284.450195 | 8883 | 8178.200195 | 8745.450195
2020-03-23 00:00:00 | 7945.700195 | 8159.25 | 7583.600098 | 7610.25
2020-03-24 00:00:00 | 7848.299805 | 8036.950195 | 7511.100098 | 7801.049805
2020-03-25 00:00:00 | 7735.149902 | 8376.75 | 7714.75 | 8317.849609
2020-03-26 00:00:00 | 8451 | 8749.049805 | 8304.900391 | 8641.450195
2020-03-27 00:00:00 | 8949.099609 | 9038.900391 | 8522.900391 | 8660.25
2020-03-30 00:00:00 | 8385.950195 | 8576 | 8244 | 8281.099609
2020-03-31 00:00:00 | 8529.349609 | 8678.299805 | 8358 | 8597.75
2020-04-01 00:00:00 | 8584.099609 | 8588.099609 | 8198.349609 | 8253.799805
2020-04-03 00:00:00 | 8356.549805 | 8356.549805 | 8055.799805 | 8083.799805
2020-04-07 00:00:00 | 8446.299805 | 8819.400391 | 8360.950195 | 8792.200195
2020-04-08 00:00:00 | 8688.900391 | 9131.700195 | 8653.900391 | 8748.75
2020-04-09 00:00:00 | 8973.049805 | 9128.349609 | 8904.549805 | 9111.900391
2020-04-13 00:00:00 | 9103.950195 | 9112.049805 | 8912.400391 | 8993.849609
2020-04-15 00:00:00 | 9196.400391 | 9261.200195 | 8874.099609 | 8925.299805
2020-04-16 00:00:00 | 8851.25 | 9053.75 | 8821.900391 | 8992.799805
2020-04-17 00:00:00 | 9323.450195 | 9324 | 9091.349609 | 9266.75
2020-04-20 00:00:00 | 9390.200195 | 9390.849609 | 9230.799805 | 9261.849609
2020-04-21 00:00:00 | 9016.950195 | 9044.400391 | 8909.400391 | 8981.450195
2020-04-22 00:00:00 | 9026.75 | 9209.75 | 8946.25 | 9187.299805
2020-04-23 00:00:00 | 9232.349609 | 9343.599609 | 9170.150391 | 9313.900391
2020-04-24 00:00:00 | 9163.900391 | 9296.900391 | 9141.299805 | 9154.400391
2020-04-27 00:00:00 | 9259.700195 | 9377.099609 | 9250.349609 | 9282.299805
2020-04-28 00:00:00 | 9389.799805 | 9404.400391 | 9260 | 9380.900391
2020-04-29 00:00:00 | 9408.599609 | 9599.849609 | 9392.349609 | 9553.349609
2020-04-30 00:00:00 | 9753.5 | 9889.049805 | 9731.5 | 9859.900391
2020-05-04 00:00:00 | 9533.5 | 9533.5 | 9266.950195 | 9293.5
2020-05-05 00:00:00 | 9429.400391 | 9450.900391 | 9190.75 | 9205.599609
2020-05-06 00:00:00 | 9226.799805 | 9346.900391 | 9116.5 | 9270.900391
2020-05-07 00:00:00 | 9234.049805 | 9277.849609 | 9175.900391 | 9199.049805
2020-05-08 00:00:00 | 9376.950195 | 9382.650391 | 9238.200195 | 9251.5
Spreadsheet: louise_kitchen__22842__Hot List Update 06-18-01
Sheet: Compression -50

Deal Description Sheet - 6/18/01
Compression Services
Project Name | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Project Seebreeze Phase II B | TBD | Additional gas procurement into NGL system benefiting Enron net profit interest. | $3.00 MM | N/A | 0.25 | 2001-08-01 00:00:00 | Negotiating with counterparites for wellhead contracts.
Cross Timbers | Cross Timbers | 6,200 HP of Gathering Compression | $500 M (early) | 2001-05-10 00:00:00 | 0.25 | 2001-08-01 00:00:00 | Developing structure.  Waiting for technical estimates.
Project Chile | ENAP | Chilean field redevelopment - 30,000 + HP. | $2.00 MM | 2001-06-12 00:00:00 | 0.25 | 2001-09-01 00:00:00 | Submitted revised engagement letter; data gathering.
Unocal | Unocal | 7,000 HP grass roots station. | $0.50 MM | 2001-05-04 00:00:00 | 0.25 | 2001-11-01 00:00:00 | Customer is reviewing proposal.
Capline | Equilon | 225,000 (+) HP Pipeline System HP-Hr structuring. | $500 M (early) | 2001-06-04 00:00:00 | 0.25 | 2001-11-01 00:00:00 | Waiting for customer to provide more information.
Crestone | Northern Border Pipeline | 15,000 HP greenfield for NBP expansion. | $500 M (early) | 2001-06-05 00:00:00 | 0.25 | 2001-12-01 00:00:00 | Initial information presented to customer, waiting on customer feedback.
Spreadsheet: 703701d1605118555-help-with-formula-to-remove-decimals-book4
Sheet: Sheet1

Entry Price | Stop Price | Current Price | Current Points | Current Profit/Loss | Latest Stop | Stop Distance | Value Per Pip/Point | Long/Short | Risk Taken | Status | [NAME].
426.87 | 354.84 | 437.02 |  |  |  | 72.03 | 0.03 | Long | 0.01
1061 | 889 | 1012 |  |  |  | 172 | 1.16 | Long | 0.01
246.2 | 309.76 | 265.39 |  |  |  | 6356 | 0.03 | Short | 0.01
EXAMPLE OF HOW
Entry Price | Stop Price | Current Price | Current Points | Current Profit/Loss | Latest Stop | Stop Distance | Value Per Pip/Point | Long/Short | Risk Taken | Status | [NAME].
426.87 | 354.84 | 437.02 |  |  |  | 72.03 | 0.03 | Long | 0.01
1061 | 889 | 1012 |  |  |  | 172 | 1.16 | Long | 0.01
246.2 | 309.76 | 265.39 |  |  |  | 6356 | 0.03 | Short | 0.01
Spreadsheet: 241022d1370496444-copy-and-paste-function-messes-up-because-of-custom-sort-filter-test-for-excelforum
Sheet: Sheet1

Things | Numbers | What It Actually Copied
pencil | 123 | 123
pencil | 123 | 123
pencil | 123 | 123
pencil | 123 | 123
pencil | 123 | 123
pencil | 123 | 123
pencil | 123 | 123
pencil | 123 | 123
pencil | 123 | 123
pencil | 123 | 123
pencil | 123 | 123
rock | 123 | 123
rock | 123 | 123
rock | 123 | 123
rock | 456 | 456
rock | 456 | 456
rock | 456 | 456
rock | 456 | 456
rock | 456 | 456
rock | 456 | 456
rock | 456 | 456
paper | 456 | 789
paper | 456 | 789
paper | 456 | 789
paper | 456 | 789
paper | 456 | 789
paper | 456 | 789
bird | 456 | 789
bird | 456 | 789
bird | 456 | 789
bird | 789 | 789
bird | 789 | 789
paper | 789 | 845
paper | 789 | 845
paper | 789 | 845
monster | 789 | 845
monster | 789 | 845
monster | 789 | 845
monster | 789 | 845
monster | 789 | 845
monster | 789 | 845
monster | 789 | 845
monster | 789 | 845
monster | 789 | 845
monster | 789 | 845
monster | 789 | 845
pikachu | 145
pikachu | 145
pikachu | 145
pikachu | 145
pikachu | 145
pikachu | 145
pikachu | 145
pikachu | 145
pikachu | 145
pikachu | 145
pikachu | 145
pikachu | 145
pikachu | 145
pikachu | 145
pikachu | 145
battery | 845
battery | 845
battery | 845
battery | 845
battery | 845
battery | 845
battery | 845
battery | 845
battery | 845
battery | 845
battery | 845
battery | 845
battery | 845
battery | 845
Spreadsheet: 149883d1334172668-copying-data-to-another-worksheet-test-tracker
Sheet: Instructors

FIRST NAME | LAST NAME | TEST # COMPLETED | DATE
[NAME] | [NAME] |  | 2012-04-11 00:00:00
[NAME] | Whitehall |  | 2012-04-11 00:00:00
[NAME] | Jones |  | 2012-04-11 00:00:00
[NAME] | Smith |  | 2012-04-11 00:00:00
[NAME] | [NAME] | 2 | 2012-04-11 00:00:00
[NAME] | Whitehall | 2 | 2012-04-11 00:00:00
[NAME] | Jones | 2 | 2012-04-11 00:00:00
[NAME] | Smith | 2 | 2012-04-11 00:00:00
[NAME] | [NAME] | 3 | 2012-04-11 00:00:00
[NAME] | Whitehall | 3 | 2012-03-18 00:00:00
[NAME] | Jones | 3 | 2012-03-20 00:00:00
[NAME] | Smith | 3 | 2012-03-22 00:00:00
[NAME] | [NAME] | 4 | 2012-03-23 00:00:00
[NAME] | Whitehall | 4 | 2012-03-25 00:00:00
[NAME] | Jones | 4 | 2012-03-26 00:00:00
[NAME] | Smith | 4 | 2012-03-27 00:00:00
[NAME] | [NAME] | 5 | 2012-03-23 00:00:00
[NAME] | Whitehall | 5 | 2012-03-25 00:00:00
[NAME] | Jones | 5 | 2012-03-26 00:00:00
[NAME] | Smith | 5 | 2012-03-27 00:00:00
Spreadsheet: 714363d1611191304-lookup-with-exact-match-and-date-range-book1
Sheet: Sheet2

Item Code | Valid From | Valid To | Price
12345678 | 2009-01-01 00:00:00 | 2009-03-01 00:00:00 | 10
12345678 | 2009-04-01 00:00:00 | 2009-06-30 00:00:00 | 11
12345678 | 2009-07-01 00:00:00 | 2009-09-30 00:00:00 | 9
12345678 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 | 12
87654321 | 2009-01-01 00:00:00 | 2009-03-01 00:00:00 | 20
87654321 | 2009-04-01 00:00:00 | 2009-06-30 00:00:00 | 19
87654321 | 2009-07-01 00:00:00 | 2009-09-30 00:00:00 | 21
87654321 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 | 23
12348765 | 2009-01-01 00:00:00 | 2009-03-01 00:00:00 | 5
12348765 | 2009-04-01 00:00:00 | 2009-06-30 00:00:00 | 4
12348765 | 2009-07-01 00:00:00 | 2009-09-30 00:00:00 | 6
12348765 | 2009-10-01 00:00:00 | 2009-12-31 00:00:00 | 3
Spreadsheet: 093b2018-a5e8-4322-a687-aca6f71e507e
Sheet: Travel Worksheet

TRAVEL BUDGET
Please complete fields hightlighted in yellow to calculate expenses.
DOMESTIC TRAVEL YEAR 1
 | DESTINATION:
 | PURPOSE:
 | # Travelers |  | Days
35 | Per Day Per Diem
0 | Per Night Hotel
0 | Registration
0 | Mileage @$.5/mile
0 | Ground Transportation
0 | [NAME], per day
0 | Airfare
 | Total Estimated Trip Cost
DOMESTIC TRAVEL YEAR 2
 | DESTINATION:
 | PURPOSE:
 | # Travelers |  | Days
35 | Per Day Per Diem
0 | Per Night Hotel
0 | Registration
0 | Mileage @$.5/mile
0 | Ground Transportation
0 | [NAME], per day
0 | Airfare
 | Total Estimated Trip Cost
DOMESTIC TRAVEL YEAR 3
 | DESTINATION:
 | PURPOSE:
 | # Travelers |  | Days
35 | Per Day Per Diem
0 | Per Night Hotel
0 | Registration
0 | Mileage @$.5/mile
0 | Ground Transportation
0 | [NAME], per day
0 | Airfare
 | Total Estimated Trip Cost
DOMESTIC TRAVEL YEAR 4
 | DESTINATION:
 | PURPOSE:
 | # Travelers |  | Days
35 | Per Day Per Diem
0 | Per Night Hotel
0 | Registration
0 | Mileage @$.5/mile
0 | Ground Transportation
0 | [NAME], per day
0 | Airfare
 | Total Estimated Trip Cost
DOMESTIC TRAVEL YEAR 5
 | DESTINATION:
 | PURPOSE:
 | # Travelers |  | Days
35 | Per Day Per Diem
0 | Per Night Hotel
0 | Registration
0 | Mileage @$.5/mile
0 | Ground Transportation
0 | [NAME], per day
0 | Airfare
 | Total Estimated Trip Cost
FOREIGN TRAVEL YEAR 1
 | DESTINATION:
 | PURPOSE:
 | # Travelers |  | Days
35 | Per Day Per Diem
0 | Per Night Hotel
0 | Registration
0 | Mileage @$.5/mile
0 | Ground Transportation
0 | [NAME], per day
0 | Airfare
 | Total Estimated Trip Cost
FOREIGN TRAVEL YEAR 2
 | DESTINATION:
 | PURPOSE:
 | # Travelers |  | Days
35 | Per Day Per Diem
0 | Per Night Hotel
0 | Registration
0 | Mileage @$.5/mile
0 | Ground Transportation
0 | [NAME], per day
0 | Airfare
 | Total Estimated Trip Cost
FOREIGN TRAVEL YEAR 3
 | DESTINATION:
 | PURPOSE:
 | # Travelers |  | Days
35 | Per Day Per Diem
0 | Per Night Hotel
0 | Registration
0 | Mileage @$.5/mile
0 | Ground Transportation
0 | [NAME], per day
0 | Airfare
 | Total Estimated Trip Cost
FOREIGN TRAVEL YEAR 4
 | DESTINATION:
 | PURPOSE:
 | # Travelers |  | Days
35 | Per Day Per Diem
0 | Per Night Hotel
0 | Registration
0 | Mileage @$.5/mile
0 | Ground Transportation
0 | [NAME], per day
0 | Airfare
 | Total Estimated Trip Cost
FOREIGN TRAVEL YEAR 5
 | DESTINATION:
 | PURPOSE:
 | # Travelers |  | Days
35 | Per Day Per Diem
0 | Per Night Hotel
0 | Registration
0 | Mileage @$.5/mile
0 | Ground Transportation
0 | [NAME], per day
0 | Airfare
 | Total Estimated Trip Cost
Spreadsheet: 043562a3-40d8-4bec-ad4a-5568bc1c6f34
Sheet: Sheet1

a | 9000 | ft
b | 1000 | ft
S | 0.005
T | 5000 | ft^2/day
4T/S
2T/S
 |  |  |  | Pumping | 2-ps | 3-1s | 6-4s | 7-5s | 9-8s
a mult |  |  |  | 1 | 1 | 3 | 3 | 5 | 5
b mult |  |  |  | 0 | 2 | 2 | 4 | 4 | 6 | 6
 |  |  |  | 1 | -1 | 1 | -1 | 1 | -1 | 1
distance
sdf
t (days) | River_a | River_b | Sum | 1 |  |  |  |  |  | 7
10
This section switches a & b to get the response to river b.
 |  |  |  | Pumping | 2-ps | 3-1s | 6-4s | 7-5s | 9-8s
a mult
b mult
distance
sdf
t | river b |  |  | 1 |  |  |  |  |  | 7
10