tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 179226d1347076955-reference-lookup-to-another-excel-file-test
Sheet: Sheet1

Invoice | Inv Date | Customer PO | ItemNumber | Validate
E108183 | 2012-06-27 00:00:00 | 7243 | 1530-2441
E108046 | 2012-06-27 00:00:00 | RMA7237 | 5189-1768
E108167 | 2012-06-27 00:00:00 | RMA7240 | CA254-02702
E108167 | 2012-06-27 00:00:00 | RMA7240 | CA354-02241
E108046 | 2012-06-27 00:00:00 | RMA7237 | CA397-04060
E108740 | 2012-06-27 00:00:00 | [NAME] | CT245-20211
E108240 | 2012-06-29 00:00:00 | RMA7242 | CA297-00060
E108240 | 2012-06-29 00:00:00 | RMA7242 | CA354-02241
Spreadsheet: 864218d1711472498-collect-data-from-multiple-excel-workbooks-and-create-a-excel-spreadsheet-with-these-data-sj_example-file
Sheet: Sheet1

 | Question: How I can collect data from multiple Excel workbooks into one Excel spreadsheet.
 | Example (what I have):
 | Work Book-1 |  |  |  |  |  |  |  |  | Work Book-2 |  |  |  |  |  |  |  |  | Work Book-3 |  |  |  |  |  |  |  |  | Work Book-4
 |  | Café-1 |  |  |  |  |  |  |  |  | Café-2 |  |  |  |  |  |  |  |  | Café-3 |  |  |  |  |  |  |  |  | Café-4
 | Pie |  | 3 |  | Bun |  | 5 |  |  | Pie |  | 1 |  | Bun |  | 3 |  |  | Pie |  | 8 |  | Bun |  | 7 |  |  | Pie |  | 4 |  | Bun |  | 6
 | Cake |  | 2 |  | Tea |  | 4 |  |  | Cake |  | 8 |  | Tea |  | 4 |  |  | Cake |  | 4 |  | Tea |  | 5 |  |  | Cake |  | 2 |  | Tea |  | 7
 | Eggs |  | 1 |  | Juice |  | 6 |  |  | Eggs |  | 2 |  | Juice |  | 5 |  |  | Eggs |  | 1 |  | Juice |  | 3 |  |  | Eggs |  | 4 |  | Juice |  | 3
 | Example (what I want to do):
 |  |  |  |  | Pie |  |  | Bun |  |  | Cake |  |  | Tea |  |  | Eggs |  |  | Juice
 | Cafa-1 |  |  |  | 3 |  |  | 5 |  |  | 2 |  |  | 4 |  |  | 1 |  |  | 6
 | Cafa-2 |  |  |  | 1 |  |  | 3 |  |  | 8 |  |  | 4 |  |  | 2 |  |  | 5
 | Cafa-3 |  |  |  | 8 |  |  | 7 |  |  | 4 |  |  | 5 |  |  | 1 |  |  | 3
 | Cafa-4 |  |  |  | 4 |  |  | 6 |  |  | 2 |  |  | 7 |  |  | 4 |  |  | 3
 | Total:
 | Notes:
 |  | 1. In reality there are a total of 42 workbooks, each a 8.5x11 inch sheet, to be sent to individual places to fill out. I did not bunch them all as 42 sheets in one workbook so that I can send them separately to each place.
 |  | 2.  All workbooks have exactly the same fields for a total of about 40 fields. Except for a few fields which are texts (like the Café Names in the example), all fields are to receive numerical values.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
Spreadsheet: f8fab628-0b63-4719-9328-401a56b9046e
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
 | [NAME] Društva koja  će privatizovati putem javnog tendera
 | 1.a) | Društva za [NAME] u toku
 | br | Društvo |  |  | % [NAME] privatizaciju | struktura [NAME] privatizaciju
 |  |  |  |  |  | [NAME] | Fond PIO | [NAME] | Fond za razvoj
 | 1 | "[NAME] brodogradilište" AD, Bijela |  |  | 0.615749 |  | 0.224311 | 0.07477 | 0.316668
 | 2 | N.I.G. "Pobjeda"  AD Podgorica |  |  | 0.51 | 0.51
 | 3 | "Montepranzo-Bokaprodukt" AD, Tivat |  |  | 0.750557 |  | 0.177459 | 0.059088 | 0.5140100000000001
 | 1.b)  [NAME] za koja će se objaviti [NAME]
 | br | Društvo |  |  | % [NAME] privatizaciju | struktura [NAME] privatizaciju
 |  |  |  |  |  | [NAME] | Fond PIO | [NAME] | Fond za razvoj
 | 1 | "[NAME] kombinat" AD, Podgorica |  |  | 0.511046 |  | 0.184179 | 0.043409 | 0.283458
 | 2 | Institut "Dr Simo Milošević"AD, Igalo |  |  | 0.564806 | 0.294243 |  | 0.034102 | 0.236461
 | 3 | "EPCG" AD Nikšić -male hidroelektrane
 | 4 | EI "Obod" AD Cetinje |  |  | 0.518013 | 0.22787 | 0.15117 | 0.05039 | 0.088583
 | 1.c)  [NAME] koja će se privatizovati u skladu sa tačkom 1.3. Odluke o planu privatizacije
 | br | Društvo |  |  | % kapitala | struktura [NAME]
 |  |  |  |  |  | [NAME] | Fond PIO | [NAME] | Fond za razvoj
 | 1 | HTP "Budvanska rivijera" AD, [NAME] |  |  | 0.587334 | 0.416353 | 0.128236 | 0.042745
 | 2 | HTP "Ulcinjska rivijera" AD Ulcinj |  |  | 0.607311 | 0.096954 | 0.241827 | 0.08061 | 0.18792
 | 3 | "Institut crne metalurgije" AD, Nikšić |  |  | 0.511159 | 0.20427 | 0.190368 | 0.063456 | 0.053065
 | 4 | AD "Marina", Bar |  |  | 0.522831 | 0.183953 | 0.126664 | 0.042222 | 0.169992
 | 5 | "Barska plovidba", Bar |  |  | 0.5144000000000001 | 0.183953 | 0.126664 | 0.042221 | 0.161562
 | 6 | DOO "Montenegro bonus" Cetinje
 | 7 | "[NAME]" DOO Berane
 | 1.d)  [NAME] koja će se privatizovati u skladu sa tačkom 1.4. Odluke o planu privatizacije
 | br | Društvo |  |  | % kapitala | struktura [NAME]
 |  |  |  |  |  | [NAME] | Fond PIO | [NAME] | Fond za razvoj
 | 1 | "Luka Bar"AD, Bar |  |  | 0.540527 | 0.540527
 | 2 | "Željeznice [NAME]" AD, Podgorica |  |  | 0.689518 | 0.637523 | 0.038305 | 0.012768 | 0.000922
 | 3 | "Montenegro airlines", DOO Podgorica
Spreadsheet: 888912d1739536841-excel-outlook-and-auto-follow-up-appointments-follow-up-appointment
Sheet: Sheet1

Location | Task | Appointment | Date | Time
123 Happiness Walk | Block Inspection | Original | 2025-02-02 00:00:00 | 10.00am
123 Happiness Walk | Block Inspection | FollowUp |  | 10.00am
234 Wonderment Drive | Wall Check | Original | 15/02/2025 | 2.00pm
234 Wonderment Drive | Wall Check | Original |  | 1.30pm
4 Bungle Crescent | Meeting Tradesperson | FollowUp | 2022-02-22 00:00:00 | 1.30pm
4 Bungle Crescent | Meeting Tradesperson | FollowUp |  | 2.00pm
Spreadsheet: 181c2e68-dbe8-498b-ae21-89a55d981ca9
Sheet: Sheet1

Pool, Static | Unnamed: 1
Administration
Before the competition:
Please read all the rules, even if you are only the organizer
Announce the comp to your AIDA national and send it to [EMAIL] at least 14 days in advance  and save the confirmation.
Create a competition web page and keep it updated.
After the competition:
Pay AIDA 2 euro per athlete
Send results lists to [EMAIL] and rankingaidainternational.org
Please include the following in the results: Full name, nationality, sex, discipline, AP, RP, penalties, total points,remarks (DQ reason).
Considerations | Remarks
Size of pool
Temperature
Pool depth (shallow enough to stand?)
Duration of pool time required
Number of lanes needed
Number of safetys needed
Do we need a shuttle?
Schedule for shuttle (if needed)
Internet
Media
Do we need a permit/ insurance?
Accommodations for athletes/support staff
Competition fee
Staff | Remarks
Judges who and how many depending on number of competition lanes
Safetys;1 per warm-up zone and 2 additional
Safetys;1 per competition zone and 2 additional
Doctor/medic
Announcer
Timekeeper; 1 per lane
Office staff and PC
Secretary/paperwork staff
Registrars (min, 2)
Cameramen (1 per zone plus 2 additional)
Registrars-60 min. Check-in (min 2 persons)
Shuttle driver(s)
Starter
General helpers and assistant staff
Media
Food/catering staff
Costs | Remarks
Pool rental
Parking
Judges
Safetys
Medic/doctor
Staff
Food
Drinks
Accomodations
Cameras ,videos, and supplies
Microphone
Office equipment
Medals/awards/prizes
Room for award ceremony
Doping kits
Internet
Permits/insurance
Color-coded shirts
Cameras ,videos, and supplies
Microphone/megaphone
[NAME] talkies/cell phones
Venue | Remarks
Registration area
Pool
Office
Room for general comp. Staff
Room for judges;review and rest area
Room for award ceremony
Event committee area
Items needed | Remarks
Paper
Pens
Markers/sharpies (waterproof)
Large waterproof marker/pen
Duct tape
Barrier tape
Laptops
Stop watches
Food
Drinks
Color-coded shirts
Cameras,videos, batteries, etc.
Microphone/megaphone
Walkie talkies.cell phones
Medals, prizes
Doping kits
Spreadsheet: 34073d1231186635-extracting-bad-data-keep-email-address
Sheet: Sheet1

Long List |  |  |  |  |  |  |  |  |  | Short List
[EMAIL] | Delete | << Double click the little black square in the bottom right corner of cell C2 |  |  |  |  |  |  |  | [EMAIL]
[EMAIL] | Delete |  |  |  |  |  |  |  |  | [EMAIL]
[EMAIL] | Delete |  | Extracting Bad Data - Excel Help Forum |  |  |  |  |  |  | [EMAIL]
[EMAIL] | Delete |  |  |  |  |  |  |  |  | [EMAIL]
[EMAIL] | Delete |  |  |  |  |  |  |  |  | [EMAIL]
[EMAIL] | Delete |  |  |  |  |  |  |  |  | [EMAIL]
[EMAIL] | Delete
[EMAIL] | Delete
[EMAIL] | Delete
[EMAIL] | Delete
[EMAIL] | Keep
[EMAIL] | Delete
[EMAIL] | Keep
[EMAIL] | Keep
[EMAIL] | Delete
Spreadsheet: eric_saibi__9678__121801R
Sheet: Shearon Harris 01

Owner Name |  | Carolina Power and Light
Station Name |  | [NAME]
Unit Name |  | [NAME] 01
NERC Region |  | SERC
State |  | NC
Fuel Type |  | Nuclear
Capacity |  | 951 MW
Start Date |  | 2001-09-21 00:00:00
End Date |  | 2002-01-04 00:00:00
Prv. Start Date |  | 2001-09-21 00:00:00
Prv. End Date |  | 2001-12-19 00:00:00
Comments |  | Refuel
SIC |  | 4911
Plant ID |  | 1013749
Unit ID |  | 1004820
Outage ID |  | 5362
Spreadsheet: cd7aaae7-b390-4fd4-aa9b-6dcc9b8735f4
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
 |  | for AA/EEO ,  Federal Labor Standards and [NAME]:
Submit this form to: |  | Contract Compliance & Business Development
 |  | 15 West Kellogg Blvd, Room 280
 |  | [NAME], MN 55102-1681
 |  | (651)266-8900, Fax (651)266-8919
PROJECT: |  |  |  | BID #: |  |  | EST. CONSTRUCTION COST: |  |  |  |  |  |  | VOP GOAL: | $ |  | %
Please Identify all sub-contractors (including material suppliers) you intend to utilize on this project.  [NAME] all suppliers with an    (S),  Identify Minority Owned, Women Owned and Small business with MBE, WBE, or SBE respectively.  Please Identify Certified Vendors. Form must be updated and submitted when you add, delete, or make other changes to the list.
 |  |  |  |  |  |  | W/M/S/BE |  | CERTIFIED |  |  |  |  | DATE WORK |  | DATE WORK |  | CONTRACT
 | NAME, ADDRESS, CONTACT PERSON AND PHONE NUMBER |  |  |  |  |  |  |  | VENDOR |  | NATURE OF WORK |  |  | TO BEGIN |  | COMPLETED |  | AMOUNT
PRIME:
SUBS: 1.
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Spreadsheet: 678728d1590042790-exact-if-not-formula-for-weight-weight-formula
Sheet: WEIGHT

Total weight (KGs) | OUTPUT FORMULA
410 | 201 to 500 Kg
410 | 201 to 500 Kg
140 | 101 to 200 Kg
60 | 51 to 100 Kg
60 | 51 to 100 Kg
40 | Up to 50 Kg
140 | 101 to 200 Kg
430 | 201 to 500 Kg
488 | 201 to 500 Kg
140 | 101 to 200 Kg
410 | 201 to 500 Kg
330 | 201 to 500 Kg
180 | 101 to 200 Kg
100 | 51 to 100 Kg
150 | 101 to 200 Kg
453 | 201 to 500 Kg
150 | 101 to 200 Kg
490 | 201 to 500 Kg
300 | 201 to 500 Kg
200 | 101 to 200 Kg
500 | 201 to 500 Kg
400 | 201 to 500 Kg
500 | 201 to 500 Kg
200 | 101 to 200 Kg
830 | 501 to 1000 Kg
650 | 501 to 1000 Kg
780 | 501 to 1000 Kg
910 | 501 to 1000 Kg
1050 | 1001 to 2000 Kg
1500 | 1001 to 2000 Kg
1200 | 1001 to 2000 Kg
1658 | 1001 to 2000 Kg
1980 | 1001 to 2000 Kg
2050 | 2001 to 3000 Kg
2305 | 2001 to 3000 Kg
2854 | 2001 to 3000 Kg
2950 | 2001 to 3000 Kg
2760 | 2001 to 3000 Kg
2500 | 2001 to 3000 Kg
Spreadsheet: 220548d1363190283-using-lookup-to-return-column-header-or-index-function-to-return-revised-pay-rate-grid-jacc
Sheet: Sheet2

 |  |  | Previous Grid |  |  |  |  | Revised Grid
 |  | Standard Hours | Start | 1 | 2 | 3 | 4 | Start | 1 | 2 | 3 | 4
502010 | Management Support - Exective Assistant |  | 21.94 | 22.6 | 23.27 | 23.97 | 24.69 | 22.37 | 23.05 | 23.74 | 24.45 | 25.18
502020 | Management Support - Human Resources Generalist |  | 21.94 | 22.6 | 23.27 | 23.97 | 24.69 | 22.37 | 23.05 | 23.74 | 24.45 | 25.18
502030 | Management Support - Scheduling & Payroll Assistant |  | 19.8 | 20.39 | 21.01 | 21.64 | 22.29 | 20.2 | 20.8 | 21.43 | 22.07 | 22.73
511010 | Group D - Accounting Clerk |  | 15.89 | 16.42 | 16.94 | 17.47 | 18 | 16.21 | 16.75 | 17.28 | 17.82 | 18.36
511050 | Group D - General Office |  | 13.98 | 14.51 | 15.03 | 15.56 | 16.08 | 14.26 | 14.8 | 15.33 | 15.87 | 16.4
Helper cell
 | Group D - Accounting Clerk | 17.47
Spreadsheet: tracy_geaccone__40591__CF_GPG_CONS
Sheet: MayYTD

Enron Gas Pipeline Group
Statement of Consolidated Cash Flows
For the 5 months ended May 31, 2000
 | CONSOLIDATED |  |  |  |  |  |  | HPLO | HPL | LRC | LIQUIDS | GATHER | LIQUIDS | SERVICE |  |  | TOTAL
(In Thousands) | GPG & EOTT |  | GPG | NNG | TW | EC | NP | 543 | 584 | 583 | DOMESTIC |  | GROUP | COS | OTHER |  | EOTT
Operating Cash Inflows (Outflows)
Net income before financing costs
Financing costs
NI after financing costs (excluding cons subs equity earn)
Depreciation, depletion and amortization
Deferred income taxes
Gains on sales of assets and investments
Dividends on pref securities of subsidiary cos.
Equity earnings
Equity/partnership distributions |  |  |  | 833 |  |  | 1632
Other, net |  |  |  |  |  | 0 |  | 1 | -139 | -1 | -2034 |  |  | 476 | -48
Funds Flow
Changes in components of working capital
Receivables |  |  |  | 30768 | -1148 |  | -134 | 12 | -768 | 260 | 26 |  |  | -13868 | -22
A/R, A/P - Intercompany |  |  |  | 2874 | -3610 |  |  | -2 | 109 | -674 | 3210 |  |  | -8447 | 311
Inventories |  |  |  | 51 | 128 |  |  |  |  |  | 173
Prepayments |  |  |  | 0 | 4
Payables |  |  |  | -9382 | -1598 |  | 122 |  | -1091 | -2 | -110 |  |  | -1071 | -106
Exchange Rec/Payable |  |  |  | 318 | -742 |  | -1
Accrued taxes |  |  |  | 1048 | -990 |  |  |  | -2 | -1 | -1262 | 0 |  | -8
Accrued interest |  |  |  | 5875 | -2107
Other working capital |  |  |  | -11374 | -25 |  | -96 |  |  | 0 | 3 |  |  | -2403
Total changes in components of working capital
Net Cash Provided by Operating Activities
Investing Cash Inflows (Outflows)
Proceeds from sale of assets and investments |  |  |  | 5464
Capital Expenditures |  |  |  | -13325 | -10131
Underground Storage,Salvage & Removal Costs
EOTT Revolver and API's
Other investing activities - intercompany
Other investing activities, net |  |  |  | -3
Net Cash Provided by Investing Activities
Cash Flows From Financing Activities
Net increase (decrease) in short-term borrowings
Issuance of long-term debt |  |  |  | 0 | 150000
Repayment of long-term debt |  |  |  |  | -123000
Other financing activities - I/C
Other financing activities, net
Net Cash Provided by Financing Activities
INC (DEC) IN CASH & CASH EQUIV, I/C CASH FROM CORP
INC (DEC) IN CASH & CASH EQUIV |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
INC (DEC) INTERCOMPANY CASH FROM CORPORATE
Change in other obligations |  |  |  | -33 | -27000 | 0 | 0 | 173 | -231 | 57 | 0 | 0 |  | 0 | 0 |  | 0
Change in total obligations
Spreadsheet: 6fb07acd-9736-457c-b886-07c2e6e27726
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
FVZD | Test | FVZD | Varicella [NAME], DFA | Varicella [NAME], DFA | Direct Fluorescent Antibody Stain |  |  |  |  |  | Submit only 1 of the following:   Swab or specimen in suitable viral transport media (VTM), VCM transport medium or equivalent. Vesicular lesion, fluid of lesion, swab of lesion, swab of fluid Acceptable: Air dried smear, eye swab | 3 mL VTM, 1 swab in VTM or 1 sli | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	[NAME] or broken slides; dried swabs; specimens received past stability or at unacceptable temperature conditions; nucleic acid transport; gel swabs. | Not Detected   Test Performed by:	Focus Diagnostics, Inc.                                     5785 Corporate Ave.                                     Cypress, CA  90630-4750 | Monday through Sunday | 1-2 days | 3 - 6 days | 1 | 87290 |  |  |  |  | Focus Diagnositics, Inc.
FVZD | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 72 hours
FVZD | Order Question | [NAME] | Source |  | Plain Text
FVZD | Result | Z0558 | VZV AG, DFA | VZV AG, DFA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 837088d1689844439-lookup-for-value-within-tolerance-from-two-columns-giwi342-xlookup-with-tolerance
Sheet: Sheet1

Compare this |  |  | To this |  |  | If both within range of X, return this |  |  |  | km
Longitude | Latitude |  | Longitude | Latitude |  | ID |  |  | X | 10
24.625272 | 59.405251 |  | 24.61024014 | 59.42884049 |  | 1
24.898454 | 59.44571 |  | 24.61118004 | 59.43042055 |  | 6
24.898512 | 59.445643 |  | 24.6073425 | 59.43094134 |  | 77
24.898384 | 59.445796 |  | 24.63748214 | 59.42330986 |  | 15
24.746022 | 59.436453 |  | 24.63764335 | 59.42378331 |  | 3
24.746032 | 59.436492 |  | 24.63780914 | 59.42430388 |  | 4
Spreadsheet: 142532d1329892245-text-to-show-in-merged-cells-from-a-different-sheet-5-bid-fee-tabulation
Sheet: Contract Numbers

Discipline | Company | Phase I                                         Survey, Prelim / Design Development |  | Phase II                                         CD's | Phase III                                         CA | Reimbursables | TOTAL
Architectural
 | Arch | 0 | 0 | 0 | 0 | 0 | 0
 | Estimated Reimbursables
Mechanical, Electrical & Plumbing
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Civil
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Structural
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Fire Protection
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Landscape
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Geotechnical
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
0
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
0
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
0
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
0
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
0
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
 | Reimbursable Sub-total Per Phase | 0 | 0 | 0 | 0
 | SUB-TOTALS PER PHASE | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Additional Services NOT INCLUDED in Base Contract
SUB TOTAL | 0
REIMBURSABLES | 0
GRAND TOTAL | 0
Spreadsheet: 0f5d1feb-673f-48ff-af58-740d1807e773
Sheet: 1.5

Table 1.5: Population etimates by age groups, nationality, residence and sex in Morocco,  2012
 | Nationals |  | Non- Nationals |  | Urban |  | Rural |  | Total
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | … | … | … | … | … | … | … | … | 1421000 | 1484000 | 2905000
5-9 | … | … | … | … | … | … | … | … | 1391000 | 1451000 | 2842000
10-14 | … | … | … | … | … | … | … | … | 1435000 | 1486000 | 2922000
15-19 | … | … | … | … | … | … | … | … | 1525000 | 1578000 | 3103000
20-24 | … | … | … | … | … | … | … | … | 1563000 | 1597000 | 3160000
25-29 | … | … | … | … | … | … | … | … | 1494000 | 1470000 | 2964000
30-34 | … | … | … | … | … | … | … | … | 1373000 | 1297000 | 2670000
35-39 | … | … | … | … | … | … | … | … | 1179000 | 1086000 | 2264000
40-44 | … | … | … | … | … | … | … | … | 1040000 | 946000 | 1986000
45-49 | … | … | … | … | … | … | … | … | 953000 | 872000 | 1825000
50-54 | … | … | … | … | … | … | … | … | 859000 | 837000 | 1696000
55-59 | … | … | … | … | … | … | … | … | 650000 | 686000 | 1336000
60-64 | … | … | … | … | … | … | … | … | 485000 | 491000 | 976000
65-69 | … | … | … | … | … | … | … | … | 353000 | 309000 | 662000
70-74 | … | … | … | … | … | … | … | … | 314000 | 264000 | 578000
75+ | … | … | … | … | … | … | … | … | 373000 | 335000 | 708000
Not stated | … | … | … | … | … | … | … | … | … | … | …
Total | … | … | … | … | … | … | … | …
Spreadsheet: sally_beck__33920__Global Hot List 0125
Sheet: Hotlist - Completed

E N R O N   G L O B A L   M A R K E T S  -  H O T  L I S T |  |  |  |  |  |  |  |  |  |  |  | 1Q01 DEALS COMPLETED
 |  | Crude & Products
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | SUBTOTAL
 |  |  |  |  |  |  |  | SUBTOTAL
 |  | Coal Origination & Finance
 |  | Deal |  | Value |  |  |  | Global Risk Markets
 |  |  |  |  |  |  |  | Deal |  | Value
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  |  |  |  |  |  |  | TOTAL DEALS COMPLETED
Spreadsheet: 44774d1243529117-excel-2007-if-function-vlookup
Sheet: List1

 | Šifra | Naziv | [NAME] | Kval. | Dim.(mm) | Kol.(Kg) | [NAME]) | Kos
 | 10001 | Cev | Nr. [NAME] | 1.4301 | 12x2
 | 10002 | Cev | Nr. [NAME] | 1.4301 | 17.2x2.35
 | 10003 | Cev | Nr. [NAME] | 1.4301 | 60.3x4
 | 10004 | Cev | Nr. [NAME] | 1.4301 | 8x1.5
 | 10005 | Cev | Nr. [NAME] | 1.4404 | 71x7.5
 | 10006 | Cev | Nr. šivna kvadratna | 1.4301 | 1.5x25
 | 10007 | Cev | Nr. šivna kvadratna | 1.4301 | 2x40
 | 10008 | Cev | Nr. šivna okrogla | 1.4301 | 104x2
 | 10009 | Cev | Nr. šivna okrogla | 1.4301 | 16x1.5
 | 10010 | Cev | Nr. šivna okrogla | 1.4301 | 168.3x3
 | 10011 | Cev | Nr. šivna okrogla | 1.4301 | 20x1.5
 | 10012 | Cev | Nr. šivna okrogla | 1.4301 | 204x2
 | 10013 | Cev | Nr. šivna okrogla | 1.4301 | 21.3x2
 | 10014 | Cev | Nr. šivna okrogla | 1.4301 | 26.9x2
 | 10015 | Cev | Nr. šivna okrogla | 1.4301 | 33.7x2
 | 10016 | Cev | Nr. šivna okrogla | 1.4301 | 40x1.5
 | 10017 | Cev | Nr. šivna okrogla | 1.4301 | 42.4x2
 | 10018 | Cev | Nr. šivna okrogla | 1.4301 | 48.3x2
 | 10020 | Cev | šivna okrogla | ST-37 | 48.3x2 | 0 | 0 | 0
Spreadsheet: 43272d1241869631-split-numbers-and-split-words-splitt-numbers2
Sheet: Sheet1

 | FN |  | MN |  | EN
 | 333 | + | 333 | + | 333 | =
 |  | + |  | + |  | =
 |  | + |  | =
 | FN |  | MN |  | EN
 | 1 | + | 0 | + | 9 | =
 |  | + |  | + |  | =
 |  | + |  | =
 | FN |  | MN |  | EN
 | 5 | + | 0 | + | 8 | =
 |  | + |  | + |  | =
 |  | + |  | =
 | How i did it… But this dos not work!
 | FN |  | MN |  | EN
 | 5 | + | 0 | + | 8 | =
 |  | + |  | + |  | =
 |  |  |  |  | This… | Is the problem with only 2 numbers "13", on the 3 spot it dos not get a value, there is no 3 number.
 |  | + |  | = |  | So how do i get it to put "0" if there is NOT 3 number
 |  |  | This…
Spreadsheet: 794192d1661937539-combined-data-showing-affiliation-with-two-columns-h831
Sheet: Sheet1

A | B | C | D |  |  | Father | Son
YFHQ |  |  |  |  |  | YFHQ | A0
 | A0 |  |  |  |  | YFHQ | A000
 |  | A000 |  |  |  | YFHQ | A001
 |  | A001 |  |  |  | YFHQ | A002
 |  | A002 |  |  |  | YFHQ | A002_I
 |  | A002_I |  |  |  | YFHQ | A0029110
 |  |  | A0029110 |  |  | YFHQ | A0029120
 |  |  | A0029120 |  |  | YFHQ | A0029130
 |  |  | A0029130 |  |  | YFHQ | A0029140
 |  |  | A0029140 |  |  | YFHQ | A0029150
 |  |  | A0029150 |  |  | YFHQ | A0029160
 |  |  | A0029160 |  |  | YFHQ | A0029170
 |  |  | A0029170 |  |  | YFHQ | A0029180
 |  |  | A0029180 |  |  | YFHQ | A0029190
 |  |  | A0029190 |  |  | YFHQ | A0020000
 |  |  | A0020000 |  |  | YFHQ | A003
 |  | A003 |  |  |  | YFHQ | A0_Layer2ADJ
 |  | A0_Layer2ADJ |  |  |  | A0 | A000
[NAME] |  |  |  |  |  | A0 | A001
 | A1 |  |  |  |  | A0 | A002
 |  | A100 |  |  |  | A0 | A002_I
 |  | A1_Layer2ADJ |  |  |  | A0 | A0029110
YFW |  |  |  |  |  | A0 | A0029120
 | A2 |  |  |  |  | A0 | A0029130
 |  | A000 |  |  |  | A0 | A0029140
 |  | A001 |  |  |  | A0 | A0029150
 |  | A002 |  |  |  | A0 | A0029160
 |  |  |  |  |  | A0 | A0029170
 |  |  |  |  |  | A0 | A0029180
 |  |  |  |  |  | A0 | A0029190
 |  |  |  |  |  | A0 | A0020000
 |  |  |  |  |  | A002_I | A0029110
 |  |  |  |  |  | A002_I | A0029120
 |  |  |  |  |  | A002_I | A0029130
 |  |  |  |  |  | A002_I | A0029140
 |  |  |  |  |  | A002_I | A0029150
 |  |  |  |  |  | A002_I | A0029160
 |  |  |  |  |  | A002_I | A0029170
 |  |  |  |  |  | A002_I | A0029180
 |  |  |  |  |  | A002_I | A0029190
 |  |  |  |  |  | A002_I | A0020000
 |  |  |  |  |  | [NAME] | A1
 |  |  |  |  |  | [NAME] | A100
 |  |  |  |  |  | [NAME] | A1_Layer2ADJ
 |  |  |  |  |  | A1 | A100
 |  |  |  |  |  | A1 | A1_Layer2ADJ
 |  |  |  |  |  | YFW | A2
 |  |  |  |  |  | YFW | A000
 |  |  |  |  |  | YFW | A001
 |  |  |  |  |  | YFW | A002
 |  |  |  |  |  | A2 | A000
 |  |  |  |  |  | A2 | A001
 |  |  |  |  |  | A2 | A002