tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5806c012-ab83-4aa1-9af3-d0f899a6d1b1
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
PK | Test | PK | [NAME], [NAME] | [NAME], RBC | Kinetic Spectrophotometry (KS) | Yellow-Top (ACD) Tube: ACD |  |  | 4 | mL | Container/Tube: Preferred: Yellow top (ACD solution B) Acceptable: EDTA [NAME]: 6 mL Collection Instructions: Do not transfer blood to other containers. Forms: If not ordering electronically, please submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | 6.7-14.3 U/g hemoglobin | Monday through Saturday | 1 day | 4 days | 1 | 84220 |  |  |  |  | Rochester
PK | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 20 days
PK | Result | PK_ | [NAME], RBC | [NAME], RBC | Numeric |  |  |  |  | U/g Hb |  |  |  |  |  |  |  |  |  | 32552-2
Spreadsheet: 707158d1607075177-matching-a-substring-returning-value-from-matched-row-but-different-column-test_sheet
Sheet: Sheet1

INPUTS |  |  |  |  |  |  |  |  |  | OUTPUTS
Default | d01 | d02 | d03 | d04 |  |  |  |  |  | tom_version_1 |  |  |  |  | version_1 values
version_1 | v101 | v102 | v103 | v104 |  |  |  |  |  | kate_version_4 |  |  |  |  | version_4 values
version_2 | v201 | v202 | v203 | v204 |  |  |  |  |  | maria_new_version |  |  |  |  | Default values
version_3 | v301 | v302 | v303 | v304
version_4 | v401 | v402 | v403 | v404
Spreadsheet: 35970d1233705676-excel-2007-formatting-issue-when-linking-a-column-s-of-data-to-other-excel-files-discrete-measures
Sheet: SwT

Level | 25PE | 25CS | 5PE | 5CS | 75PE | 75CS | 10PE | 10CS | 15PE | 15CS
Spreadsheet: 74117d1274717988-excel-2007-need-a-formula-to-search-specific-worksheet-sample
Sheet: 27

SKU # | [NAME] | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE |  | Total
12456 | Chicken
Spreadsheet: robin_rodrigue__33364__IMPositions_070700
Sheet: Opt GD

OPTION GAS DAILY POSITIONS
SUMMARY OF POSITIONS - CONTRACTS
 |  | AECO-PHYOPT |  |  | GJOPTION |  |  | NGMR-AECO/C |  |  | TOTAL
July
Aug
TOTAL
DETAIL OF POSITIONS - CONTRACTS
July |  |  |  |  |  |  | 0 | 0 | 0
Aug |  |  |  |  |  |  | 0 | 0 | 0
Spreadsheet: 887841d1738168856-vlook-up-issue-updated_training_matrix
Sheet: Training Matrix

Job Title | Department | CSCS Required | ECS card required | Level 1 in construction safety | Electrical Installation Level 3 | AM2 | SSSTS | SMSTS | Domestic Ventilation | 2391 Inspection and Testing | EAL Solar PV | iHasco Manual Handling | [NAME] at Height | Solar PV Induction Training on-roof | Solar PV [NAME] | Solar PV training (Off Roof)
Lead Solar PV installer | Solar PV | Yes | No | Yes | No | No | Yes | No | No | No | No | Yes | Yes | Yes | Yes | No
Solar PV installer | Solar PV | Yes | No | Yes | No | No | No | No | No | No | No | Yes | Yes | Yes | No | No
Solar PV Electrician | Solar PV | No | Yes | No | Yes | Yes | Yes | No | No | No | Yes | Yes | Yes | No | No | Yes
[NAME] | Solar PV | No | Yes | No | Yes | Yes | Yes | No | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes
Electrician | Production | No | Yes | No | Yes | Yes | Yes | No | Yes | No | No
Apprentice Electrician | Production | No | Yes | No | No | No | No | No | No | No | No
Area Manager | Production | No | Yes | No | Yes | Yes | No | Yes | Yes | Optional | No
Regional Area Manager | Production | No | Yes | No | Yes | Yes | No | Yes | Yes | Yes | Yes
Regional Head of Production | Production | No | Yes | No | Yes | Yes | No | Yes | Yes | Yes | No
Acting Sub-Team Leader | Production | No | Yes | No | Yes | Yes | Yes | No | No | No | No
Customer Care Electrician | Customer Care | No | Yes | No | Yes | Yes | No | No | Yes | Yes | No | No | No | No | No | No
Group Technical Manager | Technical | No | Yes | No | Yes | Yes
Team Leader/Siite Supervisor | Production | No | Yes | No | Yes | Yes | Yes | No | Yes | No | No
Solar PV Technical Supervisor | Solar PV | No | Yes | No |  |  |  |  | No | No
Regional PV Manager | Solar PV | No | Yes | No |  |  |  |  | No | No
Technical Assistant | Technical | No | Yes | No | Yes | Yes
Spreadsheet: 6c0e347a-bbab-4edc-ab32-c9398c30e155
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
TRSF | Test | TRSF | Transferrin, Serum | Transferrin, S | Immunoturbidimetric Assay | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.6 mL | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | 200-360 mg/dL | Monday through Saturday; Continuously | Same day/1 day | 2 days | 1 | 84466 |  |  |  |  | Rochester
TRSF | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TRSF | Result | TRSF | Transferrin, S | Transferrin, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 863315d1710850628-conditional-formatting-help-needed-conditional-formating-ans2
Sheet: Sheet1

 |  | A | B | C | A | A | F | G |  | G
 | #01-001 | 1157 | 1046 | 1568 | 1332 | 1318 | 1384 | 1220 |  | #01-002 | *How do I Conditional Formating such if b2:b10=K2 and C1:I1[NAME], then it will highlight Yellow???
 | #01-002 | 1407 | 1729 | 1149 | 1568 | 1686 | 1797 | 1832
 | #01-003 | 1227 | 1452 | 1531 | 1561 | 1421 | 1759 | 1241
 | #01-004 | 1014 | 1742 | 1740 | 1506 | 1627 | 1322 | 1002
 | #01-001 | 1183 | 1973 | 1546 | 1057 | 1445 | 1465 | 1312 |  | [NAME] | =SUMPRODUCT((ROW(C2)=ROW($B$2:$B$10))*($K$2=$B$2:$B$10))+SUMPRODUCT((COLUMN(C2)=COLUMN($C$1:$I$1))*($K$1=$C$1:$I$1))=2
 | #01-001 | 1371 | 1956 | 1328 | 1811 | 1915 | 1635 | 1231
 | #01-001 | 1762 | 1683 | 1831 | 1651 | 1690 | 1430 | 1430
 | #01-003 | 1191 | 1603 | 1400 | 1433 | 1369 | 1248 | 1775
 | #01-004 | 1931 | 1438 | 1898 | 1464 | 1793 | 1338 | 1572
Spreadsheet: 216516d1361797480-quantity-formulas-between-sheets-formula-help-2
Sheet: START SHEET

Panel Position |  |  | PTA | PTB | PTC | PTD | PTE | PTF | PTG | PTH | PTJ
Panel Quantities |  |  | 3 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
Panel Rating |  |  | 630 | 0 | 0 | 0 | 0 | 1250 | 0 | 0 | 0
Spreadsheet: 28d243e1-f3b8-4f34-8a7e-10c1a83c8053
Sheet: Sheet1

MONTHLY TIME REPORT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
GRADUATE ASSISTANTS & GRADUATE STUDENT WORKERS
(REMINDER: ULM POLICY IS THAT GA'S CAN WORK A MAXIMUM OF 20 HOURS A WEEK)
NAME: |  |  |  |  |  |  |  |  |  | DEPT:
CWID: |  |  |  |  |  |  |  |  |  | PAY PERIOD: |  |  | APR 13 - MAY 9, 2014
[NAME] REPORT:
 | Apr 13 | Apr 14 | Apr 15 | Apr 16 | Apr 17 | Apr 18 | Apr 19 | Apr 20 | Apr 21 | Apr 22 | Apr 23 | Apr 24 | Apr 25 | Apr 26 | Apr 27
 |  |  |  |  |  | H |  |  | H
 | Apr 28 | Apr 29 | Apr 30 | May 1 | May 2 | May 3 | May 4 | May 5 | May 6 | May 7 | May 8 | May 9
I CERTIFY THAT I HAVE WORKED MY NORMAL EMPLOYMENT SCHEDULE EXCEPT AS REFLECTED ABOVE.
GRADUATE ASSISTANT:
APPROVED BY:
SUPERVISOR |  |  |  |  |  |  |  |  | GRADUATE COORDINATOR
SUPERVISOR (IF APPLICABLE)
INSTRUCTIONS FOR COMPLETING TIME REPORT
1 | Please enter name, CWID, department, and the pay period to which the report applies.
2 | Entries should be made to the dates only if the GA/GWS did not complete their normal work schedule
 | and a pay adjustment is required.
3 | Time reports are due in the Payroll Office by 12:00 p.m. on Monday, May 5, 2014.
 | The pay date is Monday, May 12, 2014.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rev. 1/14/2014
Spreadsheet: phillip_m_love__30654__9902_OA
Sheet: EAST-CON-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / LRC
REGION:  EAST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-East
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 726754d1617422677-eomonth-nightmare-cashflow
Sheet: Cashflow

=Summary!C13
Month 1 |  | Month 1
Spreadsheet: 863618d1711032292-converting-model-data-table-simulation-5
Sheet: Sheet10

Table 1 |  |  |  |  |  |  |  |  | Table 2 |  |  |  | Answer Table 2
Name | Item 1 | Item 2 | Item 3 | Item 4 | Total items due date on march 2024 | answer |  |  | Name | Item Type | Due date |  | Name | Item Type | Due date
a | 2024-03-19 00:00:00 |  |  |  |  | 1 |  |  |  |  |  |  | a | Item 1 | 2024-03-19 00:00:00
b |  | 2024-03-19 00:00:00 | 2024-03-30 00:00:00 |  |  | 2 |  |  |  |  |  |  | b | Item 2 | 2024-03-19 00:00:00
c | 2024-01-30 00:00:00 | 2024-03-12 00:00:00 |  |  |  | 1 |  |  |  |  |  |  | b | Item 3 | 2024-03-30 00:00:00
d |  |  |  |  |  | 0 |  |  |  |  |  |  | c | Item 1 | 2024-01-30 00:00:00
e |  |  | 2024-06-30 00:00:00 |  |  | 0 |  |  |  |  |  |  | c | Item 2 | 2024-03-12 00:00:00
f |  | 2024-06-30 00:00:00 | 2024-07-12 00:00:00 |  |  | 0 |  |  |  |  |  |  | e | Item 3 | 2024-06-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | f | Item 2 | 2024-06-30 00:00:00
Notes |  |  |  |  |  |  |  |  |  |  |  |  | f | Item 3 | 2024-07-12 00:00:00
every name has 4 items
every items has its own due date
count items that has due date on march 2024
convert table type from table 1 to table 2
Spreadsheet: 132329d1323703380-problem-pain-with-offset-looking-for-other-formula-example_micope21
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Week | 5
Calloffs | Week | Date | H Teams | BHpts | HS | AS | Bapts | A Teams |  | Calloffs | Date | H Teams | BHpts | HS | AS | Bapts | A Teams
 | 1 | 2011-10-20 00:00:00 | Sherwood S.C. |  |  |  |  | Bye |  |  | 2011-12-01 00:00:00 | [NAME] | 0 |  |  | 0 | Bye
 | 1 | 2011-10-20 00:00:00 | [NAME] |  | 7 | 3 |  | The [NAME] |  |  | 2011-12-01 00:00:00 | Spot on Badgers | 0 | 6 | 4 | 0 | [NAME]
 | 1 | 2011-10-20 00:00:00 | Riley's A |  | 4 | 6 |  | Winning Post |  |  | 2011-12-01 00:00:00 | [NAME] | 0 | 4 | 6 | 0 | Phoenix Master
 | 1 | 2011-10-20 00:00:00 | [NAME] |  | 5 | 5 | 1 | [NAME] |  |  | 2011-12-01 00:00:00 | [NAME] | 0 | 5 | 5 | 1 | Winning Post
 | 1 | 2011-10-20 00:00:00 | Spot on Badgers |  | 8 | 2 |  | Phoenix Master |  |  | 2011-12-01 00:00:00 | Riley's A | 0 | 3 | 7 | 0 | Phoenix One
 | 1 | 2011-10-20 00:00:00 | Phoenix One |  | 7 | 3 |  | [NAME] |  |  | 2011-12-01 00:00:00 | Sherwood S.C. | 1 | 5 | 5 | 0 | [NAME]
 | 2 | 2011-10-27 00:00:00 | [NAME] |  | 4 | 6 |  | Spot on Badgers |  | 1 | TBA | Winning Post | 0 | 0 | 0 | 0 | [NAME]
 | 2 | 2011-10-27 00:00:00 | [NAME] |  | 7 | 3 |  | Riley's A
 | 2 | 2011-10-27 00:00:00 | [NAME] |  | 7 | 3 |  | The [NAME]
 | 2 | 2011-10-27 00:00:00 | Bye |  |  |  |  | Phoenix One
 | 2 | 2011-10-27 00:00:00 | Phoenix Master |  | 8 | 2 |  | Sherwood S.C.
 | 3 | 2011-11-10 00:00:00 | The [NAME] |  |  |  |  | Bye
 | 3 | 2011-11-10 00:00:00 | Riley's A |  | 4 | 6 |  | [NAME]
 | 3 | 2011-11-10 00:00:00 | [NAME] |  | 2 | 8 |  | [NAME]
 | 3 | 2011-11-10 00:00:00 | Spot on Badgers |  | 4 | 6 |  | Winning Post
 | 3 | 2011-11-10 00:00:00 | Phoenix Master |  | 3 | 7 |  | [NAME]
 | 3 | 2011-11-10 00:00:00 | Sherwood S.C. |  | 2 | 8 |  | Phoenix One
 | 4 | 2011-11-24 00:00:00 | Winning Post |  | 3 | 7 |  | Phoenix Master
 | 4 | 2011-11-24 00:00:00 | [NAME] |  | 5 | 5 |  | [NAME]
 | 4 | 2011-11-24 00:00:00 | Bye |  |  |  |  | Riley's A
 | 4 | 2011-11-24 00:00:00 | Phoenix One |  | 4 | 6 |  | The [NAME]
 | 4 | 2011-11-24 00:00:00 | [NAME] |  | 6 | 4 |  | Sherwood S.C.
 | 4 | 2011-11-24 00:00:00 | Sherwood S.C. |  | 7 | 3 |  | The [NAME]
 | 5 | 2011-12-01 00:00:00 | [NAME] |  |  |  |  | Bye
 | 5 | 2011-12-01 00:00:00 | Spot on Badgers |  | 6 | 4 |  | [NAME]
 | 5 | 2011-12-01 00:00:00 | [NAME] |  | 4 | 6 |  | Phoenix Master
 | 5 | 2011-12-01 00:00:00 | [NAME] |  | 5 | 5 | 1 | Winning Post
 | 5 | 2011-12-01 00:00:00 | Riley's A |  | 3 | 7 |  | Phoenix One
 | 5 | 2011-12-01 00:00:00 | Sherwood S.C. | 1 | 5 | 5 |  | [NAME]
1 | 5 | TBA | Winning Post |  |  |  |  | [NAME]
Spreadsheet: 126937d1320069013-count-a-range-if-cell-meets-the-criteria-in-another-cell-dummy-sheet
Sheet: Summary

 | 2011-11-01 00:00:00
 | Date | # of serials
 | 2011-11-01 00:00:00 | This cell should give the count of serials on 1 Nov in Nov2011 tab which is 4
 | 2011-11-02 00:00:00
 | 2011-11-03 00:00:00
 | 2011-11-04 00:00:00
 | 2011-11-05 00:00:00
 | 2011-11-06 00:00:00
 | 2011-11-07 00:00:00
 | 2011-11-08 00:00:00
 | 2011-11-09 00:00:00
 | 2011-11-10 00:00:00
 | 2011-11-11 00:00:00
 | 2011-11-12 00:00:00
 | 2011-11-13 00:00:00
 | 2011-11-14 00:00:00
 | 2011-11-15 00:00:00
 | 2011-11-16 00:00:00
 | 2011-11-17 00:00:00
 | 2011-11-18 00:00:00
 | 2011-11-19 00:00:00
 | 2011-11-20 00:00:00
 | 2011-11-21 00:00:00
 | 2011-11-22 00:00:00
 | 2011-11-23 00:00:00
 | 2011-11-24 00:00:00
 | 2011-11-25 00:00:00
 | 2011-11-26 00:00:00
 | 2011-11-27 00:00:00
 | 2011-11-28 00:00:00
 | 2011-11-29 00:00:00
 | 2011-11-30 00:00:00
 | Total: | 0
Spreadsheet: 680134d1590795775-formatting-excel-waterfall-charts-waterfall-master
Sheet: Waterfall 7

 | Values | Ends | Before | After | [NAME] | Lines |  |  |  |  | Using up/down bars:
Initial | 500 |  |  |  |  |  |  |  |  |  | 1. create a line chart
First | 100 |  |  |  |  |  | Cell C2=B2 |  |  |  |  | select [NAME]:A8, Hold ctrl and select C1:e8
Second | 200 |  |  |  |  |  |  |  |  |  |  | select end series and convert it to a column chart
Third | 150 |  |  |  |  |  | Cell C8: =sum(b2:b7) |  |  |  |  | select before/after line series to convert to up/down bars
Fourth | 100 |  |  |  |  |  |  |  |  |  | 2. format bars to show no line and colors (green up, red down)
Fifth | -125 |  |  |  |  |  | Cell D3: =sum(b$2:b2) |  |  |  |  | format data series
Final |  |  |  |  |  |  |  |  |  |  |  | change gap width to point .75
 |  |  |  |  |  |  | Cell E3: =sum(b$2:B3)
Spreadsheet: phillip_m_love__30140__200005_OA
Sheet: EAST-MKT-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  LRC
 |  |  | 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 | 48299228 | 166492096
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 10792383 | 40494735
4 |  | Option Premiums | 0 | 29846.84
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 59091611 | 207016677.84
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -42546346 | -144657584
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -16633129 | -61754732
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 172145 | 632104
 | Total Purchases: |  | -59007330 | -205780212
 |  |  | 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 | 67871 | 241160
14 |  | Cash Out | 2174 | 6781
15 |  | Cash In | -2208 | -6887
16 |  | Synthetic Storage | 55110 | 4882
 | Total Imbalances: |  | 122947 | 245936
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 30856 | 100282
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 30856 | 100282
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -238084 | -772582.58
 |  |  | 0 | 0
23 | Fuel: |  | -172145 | -632104
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -358654
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -358654
 |  |  | 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 | 6919989.6063
31 |  | Prior Month Book Balance | 0 | -106722
 |  | Total MTM Income | 0 | 6813267.6063
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -2238915
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -821
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 8fa0bd46-8cc0-4b88-a09c-f91b34d5c447
Sheet: Action Items

 |  | Status | Count
 |  | In-Progress
 |  | Closed
 |  | On-Hold
ID | Description | Assigned To | Date Opened | Due Date | Date Closed | Status | Notes
1
2
3
4
5
6
7
8
9
Spreadsheet: 885548d1735233200-see-last-post-for-additions-need-help-with-autofilling-information-temp2
Sheet: Sheet1

SITE IP | SUBNET TYPE |  | Current Result IP | Current Result Hostname | Final Result Hostname
001 | 10.0. |  |  |  | N/A - Current result hostname is good
001 | 10.10. |  |  |  | Hostname1000111
025 | 10.0. |  |  |  | N/A - Current result hostname is good
025 | 10.10. |  |  |  | Hostname1002511
108 | 10.0. |  |  |  | N/A - Current result hostname is good
108 | 10.10. |  |  |  | Hostname1010811
Note:  Site IP should always be three digits |  |  | Note:  All IP address are good. I was able to remove the leading zeros by using sub/trim. | Note:   If I'm using subnet type 10.0., it shouldn't add the leading from the 2nd octect.  However, if 10.10 is selected it should add it after the hostnameXX10811.  What could I do achieve the final results hostname by using the subnet type?
Spreadsheet: 773081d1647610261-combining-if-and-counta-functions-book1
Sheet: Sheet1

 | Prospects | Sales Rep | Appointment Date
 | [NAME] | Doe, [NAME] | 2022-03-03 00:00:00
 | [NAME] | [NAME], [NAME]
 | Aly | Doe, [NAME] | 2022-03-06 00:00:00
 | Jake | [NAME], [NAME] | 2022-03-08 00:00:00
 | [NAME] | [NAME], [NAME]
 | Michelle | Doe, [NAME] | 2022-03-09 00:00:00
 | Lucas | [NAME], [NAME] | 2022-03-11 00:00:00
 | [NAME] | Doe, [NAME]
 | [NAME] | [NAME], [NAME] | 2022-03-10 00:00:00
 | [NAME] | Doe, [NAME]
Total |  |  |  | (counta)
 |  | Total Appt Scheduled %
 | Appts with | Doe, [NAME]
 | Appts with | [NAME], [NAME]
 | Appts with | [NAME], [NAME]
Spreadsheet: 216517d1361797803-how-to-add-fixed-time-with-now-formula-raw-data
Sheet: raw

MM/DD/YYYY HH:MM | MM/DD/YYYY HH:MM |  | ACTUAL FORMULA | I want like color data
2013-02-20 07:15:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-20 07:15:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00 | if date time formate is something like this no problem M/D/YYYY H:MM
2013-02-20 07:15:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-20 13:53:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-20 13:53:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-20 13:53:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-20 14:56:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-20 14:56:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-20 14:56:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-22 01:24:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-22 01:24:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-22 12:43:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-22 12:43:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-22 12:43:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-23 06:23:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-23 06:23:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-23 06:23:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-23 06:23:00 | 2413-02-24 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00
2013-02-24 00:07:00 | 2013-02-24 00:07:00 | 2013-02-23 00:07:00 | 2013-02-24 00:00:00
2013-02-24 00:07:00 | 2013-02-24 00:07:00 | 2013-02-23 00:07:00 | 2013-02-24 00:00:00
2013-02-24 00:07:00 | 2013-02-24 00:07:00 | 2013-02-23 00:07:00 | 2013-02-24 00:00:00
2013-02-24 00:07:00 | 2013-02-24 00:07:00 | 2013-02-23 00:07:00 | 2013-02-24 00:00:00
2013-02-24 00:07:00 | 2013-02-24 00:07:00 | 2013-02-23 00:07:00 | 2013-02-24 00:00:00
2013-02-24 00:07:00 | 2013-02-24 00:07:00 | 2013-02-23 00:07:00 | 2013-02-24 00:00:00
2013-02-24 00:16:00 | 2013-02-24 00:16:00 | 2013-02-23 00:16:00 | 2013-02-24 00:00:00
2013-02-24 00:16:00 | 2013-02-24 00:16:00 | 2013-02-23 00:16:00 | 2013-02-24 00:00:00