tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5367__hpl0715
Sheet: Sheet1

HPLN0715.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective July 15 thru 17, 2000
 |  |  |  |  |  | ** Sat./Sun. | ** Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 7/15-7/16 | 2000-07-17 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 60  0900hrs | 0 to 60  0900hrs | 0 to 60  0900hrs
 |  |  |  |  | 60  to 0 2100hrs | 60  to 0 2100hrs | 60  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Texoma |  | ENA | 20 | 15 | 15
Enron (S) |  | Oasis Sealy |  | ENA | 40 | 40 | 40
Enron (S) |  | LS HPL KATY IC |  | ENA | 10 | 0 | 0
Enron (S) |  | Oasis Turbine |  | ENA | 8 | 0 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | TOG 3 |  | Empire | 1.4 | 1.4 | 1.4
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 3.6 | 3.6 | 3.6
Empire (Enron) |  | Sterling Plant |  | Empire | 5 | 5 | 5
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: phillip_m_love__30080__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 3/22/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Casco Inc. | QY6450.1 | F | NG | [NAME]
Indeck Pepperell Power Associates | QY5028.1 | P | NG | [NAME]
New Counterparty | QY3918.C | P | SHRC | [NAME]
New Counterparty | QY5241.1/2/3/4/5/6/7/8 | P | SHRC | [NAME]
New Counterparty | QY5604.1 | F | NG | [NAME]
New Counterparty | QY6093.1/2/3/4/5/6/7 | P | SCRC | [NAME]
New Counterparty | [NAME] | P | SCRC | [NAME]
New Counterparty | QY5042.1/2 | P | NWSP NW45 | [NAME]
Noble Americas Corp. | QY6464.1 | F | MTBE | Brant Reves
Petro-Canada Hydrocarbons Inc. | QY3869.1 | F | NG | [NAME]
Prior Energy Corp. | QY5366.1/2 QY5885.1 | F | NG | [NAME]
[NAME], Inc. | QY6611.1 | F | NGGJ | [NAME]
[NAME], Inc. | QY6327.1/2 | P/F | NG | [NAME]
SGL CANADA INC. | QY5824.1 | F | NG | [NAME]
Slater Steel Inc. | QY6485.1 | F | NGGJ | [NAME]
Stahlschmidt Trading Limited | [NAME] | P | SCRC | [NAME]
Tampa Electric Company | QY1203.3 | P | NG | Brant Reves
WTG Gas Marketing, Inc. | QY5895.1 | F | NG | [NAME]
Westport Oil & Gas Company, Inc. | QY6476.1 | P | NG | [NAME]
Wynn-Crosby 1998, Ltd. | QY6497.2 | F | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Chase Manhattan Corporation, The | QY5823.1 | F | NG | The Chase Manhattan Bank
Coral Energy Resources, L.P. | QY4149.1 QY5332.1 | F | NG | Coral Energy Holding, L.P.
Dynegydirect Inc. | QY5237.1 | F | NG | Dynegy Marketing and Trade
[NAME]Islands Corp. | QY6098.1 | F | 61NY | Hess Energy Trading Company LLC
TransCanada Energy Financial Products | QY5096.1 QY6289.1 QY6495.1 | F | NG | TransCanada Energy Financial Products (w/ECC)
TransCanada Energy Ltd. | QY6556.1 | F | NG | TransCanada Energy Financial Products (w/ECC)
Spreadsheet: 36094d1233855820-vlookup-multiple-rows-to-one-worksheet1
Sheet: One Row

Product # | Comp1 | Comp2 | [NAME] | Comp4 | Comp5 | Comp6 | Comp7
 | 106219 | 106222 | 106160 | 106162 | 100001 | 108710 | 108720
57 | 20 | 80
129 |  | 100
701 |  | 76 | 11 | 13
703 |  |  | 0.5 |  | 3.98 | 3.98 | 91.54
Spreadsheet: 215458d1361384503-offset-example-dd
Sheet: BEFORE

DATE:
 |  |  | 100422/7 |  |  |  | 100423/5 |  |  |  | 100424/6 |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small |  |  |  |  |  | Large |  |  |  | Medium |  |  |  | Small
 |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  |  |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit |  | Entrance | Middle | Exit
STAGE 3
STAGE 4
STAGE 5
LANDING 5-6
STAGE 6
STAGE 7
STAGE 8
STAGE 9
STAGE 10
AIR BLOW OFF
BEFORE BLOW OFF
DRY OFF OVEN
CURE OVEN
SUM OF COLUMN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data |  | or | Data
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Organized either way but the data in the red cells in the above data field need to be placed into their own column. The data would represent more than what is currently highlighted.
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-11-P-0024

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-11-P-0024 |  |  | 1P
W912LP-11-P-0024 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: b982d6e2-e20b-4f51-ac9a-d292b70a09c0
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
ALU | Test | ALU | Aluminum, 24 Hour, [NAME] | Aluminum, 24 Hr, U | Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine container with no metal cap or glued insert Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections. 3. High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours.   Urine Preservative Collection Options Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3	No Toluene 	Yes 6N HNO3	Yes Boric Acid	No Thymol	No | 0.3 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-20 mcg/specimen Reference values apply to all ages | Tuesday, Friday 5 p.m. | 1 day | 5 days | 1 | 82108 |  |  |  |  | Rochester
ALU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
ALU | Order Question | TM15 | Collection Duration |  | Plain Text
ALU | Order Question | VL13 | [NAME] |  | Plain Text
ALU | Result | 8828 | Aluminum, 24 Hr, U | Aluminum, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 26707-0
ALU | Result | TM15 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9
ALU | Result | VL13 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28009-9
ALU | Result | 861 | [NAME] | [NAME] | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 6929-4
Spreadsheet: 29167d1224006870-automatic-data-selection-orders
Sheet: Data Sheet

 | Colour | colour 2 | Description | Part Number
 | Red | Red | Fine nib | rd123
 | Blue |  | Medium nib | rd234
 | Black |  | Thick nib | rd345
 | Green
 |  | Blue | Fine nib | bl123
 |  |  | Medium nib | bl234
 |  |  | Thick nib | bl345
 |  | Black | Fine nib | bk123
 |  |  | Medium nib | bk234
 |  |  | Thick nib | bk345
 |  | Green | Fine nib | gr123
 |  |  | Medium nib | gr234
 |  |  | Thick nib | gr345
Spreadsheet: 102468d1300392381-excel-2007-lookup-of-rounded-number-fails-for-certain-numbers-test-lookup
Sheet: Sheet1

Test value | -0.103702
Rounded
Rounded+Truncated
Rounded = Rounded+Truncated?
Lookup [Rounded]
Lookup [Rounded+Truncated]
[NAME]?
Lookup Table | -0.11 | H
 | -0.108 | G
 | -0.106 | F
 | -0.104 | E
 | -0.102 | D
 | -0.1 | C
 | -0.098 | B
 | -0.096 | A
Spreadsheet: 687599d1595306944-vlookup-with-ceiling-that-jumps-to-next-larger-variable-if-n-is-variable-1-sample_list
Sheet: Sheet1

Trans/Mo | $
251000
[NAME] | Execution_C
0 | 0
50000 | 5000
100000 | 9500
150000 | 13200
200000 | 16200
250000 | 18750
300000 | 20700
350000 | 22400
400000 | 23600
450000 | 24300
500000 | 25000
1000000 | 48000
2000000 | 61333.33333333333
Spreadsheet: 707214d1607099451-convert-a-cell-from-text-to-number-then-carry-out-a-formula-book2
Sheet: Program

Current Build Stage |  | Kitchen |  |  | Heating |  |  | Appliances
 |  |  | Possible between |  |  | Possible between |  |  | Possible between
 |  | > | 1 | Likely< | No > | 1 | Likely< | No> | 5 | Likely<
 | Stage | 3 | 3 | 1 | 3 | 3 | 1 | 10 | 10 | 5
12 - 1st Fix | 12
12 - 1st Fix | 12
13 - Plasterboard | 13
13 - Plasterboard | 13
13 - Plasterboard | 13
15 - 2nd Fix 1 | 15
16 - 2nd Fix 2 | 16
17 - Paint 1 | 17
18 - Paint 2 | 18
19 - Final Snagging | 19
19 - Final Snagging | 19
19 - Final Snagging | 19
2 - BWK To DPC | 2
2 - BWK To DPC | 2
2 - BWK To DPC | 2
2 - BWK To DPC | 2
Spreadsheet: 876043d1722687815-list-members-of-each-team-by-team-number-learning-the-ropes-book3-38-aligw
Sheet: Sheet1

Player Number | First Name | Last Name | Assigned Team # |  | Team Number
 |  |  |  |  |  | TEAM MEMBERS
1 | Afera | Quick | 4 |  | 1
2 | Al | Knol | 6 |  |  | [NAME]
3 | Barb | Tamp | 9 |  | 2 | [NAME]
4 | Barb | Pine | 1 |  |  | Nate Late
5 | [NAME] | [NAME] | 10 |  | 3 | [NAME]
6 | [NAME] | Stout | 2 |  |  | Mac  Long
7 | [NAME] | Smith | 3 |  | 4 | Afera Quick
8 | [NAME] | Dime | 5 |  |  | [NAME]
9 | [NAME] | Radcliff | 6 |  | 5 | [NAME]
10 | George | Plum | 8 |  |  | [NAME]
11 | [NAME] | [NAME] | 10 |  | 6 | [NAME]
12 | [NAME] | Slow | 1 |  |  | [NAME]
13 | [NAME] | [NAME] | 7 |  | 7 | [NAME]
14 | Mac | Long | 3 |  |  | [NAME]
15 | Nate | Late | 2 |  | 8 | [NAME]
16 | Ned | Brow | 5 |  |  | Shelly Early
17 | Ray | Erskine | 9 |  | 9 | Barb Tamp
18 | Shelly | Early | 8 |  |  | [NAME]
19 | [NAME] | Ready | 4 |  | 10 | [NAME]
20 | Sue | Baxter | 7 |  |  | [NAME]
Spreadsheet: 851993d1702102213-how-to-get-cumulative-time-owed-timesheets-3-
Sheet: Sheet1

Balance of 39.5 extra paid out in May, start June nil bal
 |  |  |  |  | Sum calculated | manually calculated | Running Balance
2023-06-05 00:00:00 | 30.2 |  | 30 | 29.6
2023-06-12 00:00:00 | 30 |  | 30 | 29.6
2023-06-19 00:00:00 | 32.1 |  | 30 | 29.6
2023-06-26 00:00:00 | 30.25 |  | 30 | 29.6
 |  | [NAME]:
2023-07-03 00:00:00 | 24.5 |  | 30 | 29.6
2023-07-10 00:00:00 | 31.5 |  | 30 | 29.6
2023-07-17 00:00:00 | 27.1 |  | 30 | 29.6
2023-07-24 00:00:00 | 30.15 |  | 30 | 29.6
2023-07-31 00:00:00 | 31.1 |  | 30 | 29.6
 |  | JULY: |  |  |  | -4.45 | -1.4
2023-08-07 00:00:00 | 30.1 |  | 30 | 29.6
2023-08-14 00:00:00 | 33.4 |  | 30 | 29.6
2023-08-21 00:00:00 | 31.2 |  | 30 | 29.6
2023-08-28 00:00:00 | 29.5 |  | 30 | 29.6
 |  | AUG: |  |  |  | 5
2023-09-04 00:00:00 | 28.25 |  | 30 | 29.6
2023-09-11 00:00:00 | 27.4 |  | 30 | 29.6
2023-09-18 00:00:00 | 30 |  | 30 | 29.6
2023-09-25 00:00:00 | 24.35 |  | 30 | 29.6
 |  | SEP: |  |  |  | -9.2 | -6
2023-10-02 00:00:00 | 35.5 |  | 30 | 29.6
2023-10-09 00:00:00 | 31.25 |  | 30 | 29.6
2023-10-16 00:00:00 | 32.25 |  | 30 | 29.6
2023-10-23 00:00:00 | 38.25 |  | 30 | 29.6
2023-10-30 00:00:00 | 35 |  | 30 | 29.6
 |  | OCT:
2023-11-06 00:00:00 | 37.05 |  | 30 | 29.6
2023-11-13 00:00:00 | 29.4 |  | 30 | 29.6
2023-11-20 00:00:00 | 34.15 |  | 30 | 29.6
2023-11-27 00:00:00 | 29.2 |  | 30 | 29.6
 |  | NOV:
2023-12-04 00:00:00 | 30.05 |  | 30 | 29.6
2023-12-11 00:00:00 | 30 |  | 30 | 29.6
2023-12-18 00:00:00 | 30 |  | 30 | 29.6
 |  | DEC:
Spreadsheet: 871007d1717483304-all-data-in-one-line-needs-to-be-sorted-into-separate-entries-of-the-same-id-for-excel-forum
Sheet: Tab 2 - Format I need

RecordID
1 | QU_1 | I love this website | Agree |  |  | QU_1 | I love this website | Agree
1 | QU_2 | I  am a fan of bonjovi | Disagree |  | 1 | QU_2 | I  am a fan of bonjovi | Disagree
1 | QU_3 | I live in the UK | Agree |  | 1 | QU_3 | I live in the UK | Agree
1 | QU_4 | I do not get sea sick | Disagree |  | 1 | QU_4 | I do not get sea sick | Disagree
1 | QU_5 | I am dog lover | Agree |  | 1 | QU_5 | I am dog lover | Agree
1 | QU_6 | I drive a car | Agree |  | 1 | QU_6 | I drive a car | Agree
1 | QU_7 | I love my job | Agree |  | 1 | QU_7 | I love my job | Agree
1 | QU_8 | I have a smarphone | Not sure |  | 1 | QU_8 | I have a smarphone | Not sure
1 | QU_9 | my laptop is old | Agree |  | 1 | QU_9 | my laptop is old | Agree
1 | QU_10 | I love going to the cinemas | Agree |  | 1 | QU_10 | I love going to the cinemas | Agree
2 | QU_1 | I love this website | Disagree |  | 2 | QU_1 | I love this website | Disagree
2 | QU_2 | I  am a fan of bonjovi | Not sure |  | 2 | QU_2 | I  am a fan of bonjovi | Not sure
2 | QU_3 | I live in the UK | Disagree |  | 2 | QU_3 | I live in the UK | Disagree
2 | QU_4 | I do not get sea sick | Not sure |  | 2 | QU_4 | I do not get sea sick | Not sure
2 | QU_5 | I am dog lover | Agree |  | 2 | QU_5 | I am dog lover | Agree
2 | QU_6 | I drive a car | Not sure |  | 2 | QU_6 | I drive a car | Not sure
2 | QU_7 | I love my job | Not sure |  | 2 | QU_7 | I love my job | Not sure
2 | QU_8 | I have a smarphone | Not sure |  | 2 | QU_8 | I have a smarphone | Not sure
2 | QU_9 | my laptop is old | Agree |  | 2 | QU_9 | my laptop is old | Agree
2 | QU_10 | I love going to the cinemas | Disagree |  | 2 | QU_10 | I love going to the cinemas | Disagree
3 | QU_1 | I love this website | Agree |  | 3 | QU_1 | I love this website | Agree
3 | QU_2 | I  am a fan of bonjovi | Disagree |  | 3 | QU_2 | I  am a fan of bonjovi | Disagree
3 | QU_3 | I live in the UK | Disagree |  | 3 | QU_3 | I live in the UK | Disagree
3 | QU_4 | I do not get sea sick | Disagree |  | 3 | QU_4 | I do not get sea sick | Disagree
3 | QU_5 | I am dog lover | Disagree |  | 3 | QU_5 | I am dog lover | Disagree
3 | QU_6 | I drive a car | Not sure |  | 3 | QU_6 | I drive a car | Not sure
3 | QU_7 | I love my job | Disagree |  | 3 | QU_7 | I love my job | Disagree
3 | QU_8 | I have a smarphone | Agree |  | 3 | QU_8 | I have a smarphone | Agree
3 | QU_9 | my laptop is old | Agree |  | 3 | QU_9 | my laptop is old | Agree
3 | QU_10 | I love going to the cinemas | Agree |  | 3 | QU_10 | I love going to the cinemas | Agree
4
4
4
4
4
4
4
4
4
4
5
5
5
5
5
5
5
5
5
5
6
6
6
6
6
6
6
6
6
6
Spreadsheet: 173092d1344436885-show-totals-with-data-table-test
Sheet: Sheet1

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Total:
[NAME] | 12 |  | 26 | 8 |  | 38 | 14 | 98
[NAME] | 8 | 8 | 12 | 19 | 21 |  |  | 68
[NAME] |  | 27 | 21 | 18 | 6 |  | 27 | 99
[NAME] | 12 |  | 25 | 10 | 10 | 11 | 3 | 71
Total: | 32 | 35 | 84 | 55 | 37 | 49 | 44 | 336
Spreadsheet: 841878d1694009516-bisectional-method-using-recursive-lambda-recursive-bisection-method-lambda-3
Sheet: Test of Bisectional Method 2

Solving the equation 3*X=555 with Bisectional method in normal formulas
Min | [NAME] | X | Calculation | Goal | Diff | Termination
11 | 500 | 200 |  | 555
Spreadsheet: 763718d1642345551-date-stamp-needed-when-data-is-entered-into-a-column-by-external-workbook-book1
Sheet: Sheet1

Interval |  |  | Is there a formula that will put the current date in row 2  above the data being submitted (Column B) from a different workbook each time a column data has been entered.
08:00:00 | 0
08:15:00 | 0.0030899
08:30:00 | 0.0054074
08:45:00 | 0.0063515
09:00:00 | 0.0092698
09:15:00 | 0.0048065
09:30:00 | 0.0146771
09:45:00 | 0.0100422
10:00:00 | 0.0092698
10:15:00 | 0.0148315
10:30:00 | 0.0146771
10:45:00 | 0.0169945
11:00:00 | 0.0162221
11:15:00 | 0.0133038
11:30:00 | 0.0185395
11:45:00 | 0.0287362
12:00:00 | 0.0216122
12:15:00 | 0.0208569
12:30:00 | 0.0169945
12:45:00 | 0.0247193
13:00:00 | 0.0200845
13:15:00 | 0.0154496
13:30:00 | 0.0281869
13:45:00 | 0.019312
14:00:00 | 0.0347616
14:15:00 | 0.0254918
14:30:00 | 0.0278093
14:45:00 | 0.0224019
15:00:00 | 0.0339891
15:15:00 | 0.0301267
15:30:00 | 0.0239469
15:45:00 | 0.035534
16:00:00 | 0.0301267
16:15:00 | 0.0363065
16:30:00 | 0.0332166
16:45:00 | 0.0208569
17:00:00 | 0.0278093
Spreadsheet: 771439d1646672189-periodic-table-excel-template-not-working-many-formulas-display-unknown-periodic-table-excel
Sheet: Elements

 | Compare elemental properties
 | Use the table below to add elemental properties and compare them.
 |  | Click the icon next to an element to view more data about it.
 |  | To add more columns of information, select an element and then click on the Add Column icon in the top right corner of the list.
 | Blank | Element | Atomic symbol
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
Spreadsheet: 79169d1279456271-pulldown-menu-drilldowns
Sheet: Sheet1

red |  | yellow |  | blue |  | green |  |  | list 1 |  |  | list 2 |  |  | list 3 |  | list 4
 |  |  |  |  |  |  |  |  | red |  | 0 | blue |  | 1 | blue |  | green
 |  |  |  |  |  |  |  |  | blue |  | 2 | yellow |  | 0 | green
 |  |  |  |  |  |  |  |  | yellow |  | 3 | green |  | 3
 |  |  |  |  |  |  |  |  | green |  | 4
Spreadsheet: jonathan_mckay__16902__EnronDirect Deal Sheet-Area Managers
Sheet: Triwood

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Triwood Community Association |  |  |  | Deal Date: | 2001-05-30 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 385 | 0
 | February | 540 | 0
 | March | 755 | 0
 | April | 307 | 0
 | May | 205 | 0
 | June | 180 | 0
 | July | 95 | 0
 | August | 84 | 0
 | September | 118 | 0
 | October | 217 | 0
 | November | 288 | 0
 | December | 448 | 0
 | TOTAL:
Spreadsheet: 798152d1664334653-spill-error-when-converting-to-table-spill-error-when-converting-to-table
Sheet: Sheet1

 |  |  |  |  |  |  |  | Dropdown | Paid
 |  | No | Place | Status
 |  | 1 | Place 1 | Pending
 |  | 2 | Place 2 | Paid
 |  | 3 | Place 3 | Paid
 |  | 4 | Place 4 | Pending |  |  | Without table is working fine below: |  |  | Spill Error when converting to table below: [NAME] applied by added the Index but it returns only first value = Place 2 instead of all
 |  | 5 | Place 5 | Pending
 |  | 6 | Place 6 | Pending |  |  | PLACE | Status |  | PLACE | Status
 |  | 7 | Place 1 | Pending
 |  | 8 | Place 3 | Pending |  |  | Place 3
 |  | 9 | Place 3 | Pending |  |  | Place 12
 |  | 10 | Place 3 | Paid |  |  | Place 13
 |  | 11 | Place 3 | Paid |  |  | Place 14
 |  | 12 | Place 12 | Paid |  |  | Place 4
 |  | 13 | Place 13 | Paid |  |  | Place 20
 |  | 14 | Place 14 | Paid |  |  | Place 30
 |  | 15 | Place 4 | Pending
 |  | 16 | Place 4 | Pending
 |  | 17 | Place 4 | Paid
 |  | 18 | Place 4 | Pending
 |  | 19 | Place 19 | Pending
 |  | 20 | Place 20 | Paid
 |  | 21 | Place 30 | Paid
Spreadsheet: 772099d1647006225-count-results-per-week-and-month-samplesample
Sheet: Week summary

 | Week | Count
 | 1 | 6
 | 2 | 20
 | 3 | 15
 | 4 | 42
 | 5 | 21
 | 6 | 25
 | 7 | 22
 | 8 | 35
 | 9 | 30
 | 10 | 7