tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 63088d1264046743-sumif-reference-to-date-attendancesummary2
Sheet: DailyAttendance

[NAME] |  |  |  |  | Training Totals:
 |  |  |  |  | [NAME]: |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Day1 |  |  |  | Day2 |  |  |  |  | Day1 |  |  |  | Day2 |  |  |  |  | Day1 |  |  |  | Day2 |  |  |  |  | Day1 |  |  |  | Day2 |  |  |  |  | Day1 |  |  |  | Day2
Total Training Sessions: 2 Days;   Trainee per Class: 6 |  |  |  |  | Training Dates: |  |  |  |  |  |  |  | 2010-01-17 00:00:00 |  |  |  | 2010-01-18 00:00:00 |  |  |  |  | 2010-01-19 00:00:00 |  |  |  | 2010-01-20 00:00:00 |  |  |  |  | 2010-01-21 00:00:00 |  |  |  | 2010-01-22 00:00:00 |  |  |  |  | 2010-01-25 00:00:00 |  |  |  | 2010-01-26 00:00:00 |  |  |  |  | 2010-01-27 00:00:00 |  |  |  | 2010-01-28 00:00:00
PROVIDER | AREA ID | AREA | Early Start Training Date | Early End Training Date | Scheduled Trainee | [NAME] | tempd1 | Day1 | Day2 | Total Trainee Variance | [NAME] | Certified  Total | Expected | Actual1 | [NAME] | Attd Pect | Expected | Actual2 | Variance2 | Attd Pect | Certified | Expected | Actual1 | [NAME] | Attd Pect | Expected | Actual2 | Variance2 | Attd Pect | Certified | Expected | Actual1 | [NAME] | Attd Pect | Expected | Actual2 | Variance2 | Attd Pect | Certified | Expected | Actual1 | [NAME] | Attd Pect | Expected | Actual2 | Variance2 | Attd Pect | Certified | Expected | Actual1 | [NAME] | Attd Pect | Expected | Actual2 | Variance2 | Attd Pect | Certified
ProviderA | 1 | AMBER | 2010-01-18 00:00:00 | 2010-02-04 00:00:00 |  |  |  |  |  |  |  |  | 6 | 6 |  |  | 6 | 5 |  |  | 4 | 6 | 4 |  |  | 6 | 4 |  |  | 4 | 6 | 3 |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6
ProviderC | 2 | BASIL | 2010-01-18 00:00:00 | 2010-01-26 00:00:00 |  |  |  |  |  |  |  |  | 6 | 5 |  |  | 6 | 5 |  |  | 3 | 5 | 5 |  |  | 5 | 5 |  |  | 4 |  |  |  |  |  |  |  |  |  | 6 |  |  |  | 5
ProviderB | 3 | BATER | 2010-01-18 00:00:00 | 2010-01-28 00:00:00 |  |  |  |  |  |  |  |  | 6 | 4 |  |  | 6 | 4 |  |  | 4 | 6 | 4 |  |  | 6 | 4 |  |  | 4 | 5 | 5 |  |  | 5 |  |  |  |  | 5 |  |  |  | 5 |  |  |  |  | 2 |  |  |  | 2
ProviderC | 4 | BABEL | 2010-01-18 00:00:00 | 2010-01-28 00:00:00 |  |  |  |  |  |  |  |  | 6 | 1 |  |  | 6 | 0 |  |  | 0 | 5 | 5 |  |  | 5 | 4 |  |  | 3 | 2 | 2 |  |  | 2 |  |  |  |  | 4 |  |  |  | 4 |  |  |  |  | 4 |  |  |  | 4
ProviderB | 5 | BARREL | 2010-01-18 00:00:00 | 2010-01-30 00:00:00 |  |  |  |  |  |  |  |  | 6 | 5 |  |  | 6 | 4 |  |  | 3 | 5 | 5 |  |  | 6 | 4 |  |  | 3 | 6 | 5 |  |  | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6
ProviderC | 6 | TOWER | 2010-01-18 00:00:00 | 2010-01-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 |  |  | 5 | 4 |  |  | 4 | 2 | 3 |  |  | 2 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6
ProviderB | 7 | DUMMY | 2010-01-18 00:00:00 | 2010-01-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 |  |  | 4 | 4 |  |  | 3 | 4 | 5 |  |  | 4 |  |  |  |  | 3 |  |  |  | 3
Spreadsheet: bd735ba6-3343-4a0c-a267-1e828f1c6731
Sheet: Sheet1

2010 official [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
State of North Dakota Results
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
Downloaded at 5/25/2013 10:35:17 AM
 | [NAME] | write-in  - NON
School Board Member Rhame Area School District (Vote for candidates from all areas)  - NON | 658 | 6
TOTAL | 658 | 6
 | [NAME] | [NAME] | [NAME]  - NON | [NAME] | write-in  - NON
School Board Member Bowman Area School District (Vote for candidates from all areas) - NON | 326 | 286 | 358 | 424 | 1
TOTAL | 326 | 286 | 358 | 424 | 1
 | [NAME] | write-in  - NON
School Board Member [NAME] (Vote for candidates from all areas) - NON | 637 | 4
TOTAL | 637 | 4
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 803076d1667237048-picking-out-average-minimum-values-controlled-by-2-different-variables-excel_ex-eastby91-
Sheet: Station 1

 | Referensförhållande
 | Månad | Månad | MLQ
 | Januari | 1
 |  | 2
 | [NAME] (2010-2020)
 | Datum | Total naturlig vattenföring [m³/s] | Month | Year
 | 2010-01-01 | 1.46
 | 2010-01-02 | 1.41
 | 2011-01-03 00:00:00 | 1.38
 | 2012-01-04 00:00:00 | 1.35
 | 2012-01-05 00:00:00 | 1.31
 | 2012-01-06 00:00:00 | 1.46
 | 2013-01-07 00:00:00 | 1.22
 | 2014-01-08 00:00:00 | 1.18
 | 2015-01-09 00:00:00 | 1.14
 | 2016-01-10 00:00:00 | 1.1
 | 2017-01-11 00:00:00 | 1.57
 | 2018-01-12 00:00:00 | 2.04
 | 2019-02-13 00:00:00 | 5.54
 | 2020-03-14 00:00:00 | 10.8
Spreadsheet: 144800d1331141511-vlookup-not-returning-the-correct-value-in-cell-paycheck-calculator-b
Sheet: Paycheck

 |  |  | Pre-Tax | Facility ID: | GFK
 |  |  | Post Tax | Facility Name: | Little Rock ATCT/TRACON
Annual Salary | 59294 |  | Taxes
Your Pay Consists Of | Current | YTD | [NAME] | Tax Information | [NAME] | Exemptions
Gross Pay: | 2432.5505 | 2432.5505 | Level: | Federal | M | 3
Taxable Amount: | 2152.7625 | Step Grade: | Level 7 | State - IN | N/A | 3
Total Deductions: | 754.2454049999999 | Dev2 | Locality % | Age |  | 33
Net Pay: | 1678.305095 | 1678.305095 | 0.1416 | Pay Period | 4
 |  | EARNINGS
Type | Rate |  | Adjusted | Adj Hours | Hours | Current
Regular | 28.41 |  |  |  | 80 | 2272.8
Night Differential | 2.87 |  |  |  | 16.15 | 46.35049999999999
Sunday Premium | 7.1 |  |  |  | 16 | 113.6
Holiday | 28.41 |  |  |  | 0 | 0
Other Rate |  |  |  |  |  | 0
 |  |  |  |  |  | -0.2
 |  | DEDUCTIONS
Type | Rate | Adj. Current | Type |  | Rate | Adj. Current
FERS Retirement | 0.013 | 29.5464 | Social Security Tax |  | 0.042 | 91.38000000000001
Medicare Tax | 0.0145 | 31.54 | State Tax - IN |  |  | 94.27100500000002
FEGLI - Regular |  | 9.299999999999999 | FEGLI - Optional |  |  | 7.4
Thrift Savings Plan (TSP) | 0.01 | 22.728 | Federal Income Tax |  |  | 176.93
Health Insurance |  | 131.73 | Dental/Vision |  |  | 48.41
 |  |  | FSA HC |  |  | 76.92
 |  |  | Union Dues |  |  | 34.09
EVV Payband Steps: | 2011 | 2012
D1 | No D1 | No D1
D2 | 55201 | 59294
D3 | 61642 | 67780
CPC | 68083 | 76267
Spreadsheet: vkaminski__40790__CASH_Elba_04112000wML
Sheet: PF1

SUMMARY OF NET INCOME AND CASH FLOW ($000) |  |  |  |  | ELBA ISLAND WITH HOEGH GALLEON
 |  |  |  |  | Option 1: Resell Capacity to Third Party after Year 5 (20% Probability)
 | ECONOMICS AT 17% DISC RT ($[NAME]): |  |  |  | ASSUMPTIONS:
 |  |  |  |  | Elba Fixed COS: |  |  | MM/Yr
 |  |  |  |  | Variable Cost / MMBtu: |  |  | + Fuel Costs
 |  |  |  |  | ENE Marketing Costs: |  | 1 | MM/Yr
 |  |  |  |  | SPOT | # of Cargoes | [NAME] | # of Cargoes | [NAME]
 |  |  |  |  | [NAME] | [NAME] | [NAME] | Yrs 6-20 | Yrs 6-20
 |  |  |  |  | Algeria |  |  | 0 | N/A
 |  |  |  |  | Middle East |  |  | 0 | N/A
 |  |  |  |  | Total |  |  |  | N/A
Calendar Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-17 AVG
Elba Island Months of Operation |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 0
Elba Island Contract Year
Algeria Spot LNG Throughput (TBTU/Yr)
Abu Dhabi Spot LNG Throughput (TBTU/Yr)
Total Spot LNG Throughput (TBTU/Yr)
REVENUES
LESS: TERMINALING & MKTG COSTS
PROJECT PRE-TAX INCOME AND CASH FLOW ($000)
Spreadsheet: 224a0e82-ff84-4b50-bc49-7345974e0ce1
Sheet: Sheet1

Table 5--Corn: Food, seed, and industrial use (million bushels), 5/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Mkt year and qtr 1/ |  | High-fructose corn syrup (HFCS) | Glucose and dextrose | Starch | Alcohol for fuel | Alcohol for beverages and manufacturing | Cereals and other products | Seed | Total food, seed, and industrial use
2010/11 | Q1 Sep-Nov | 126.248 | 65.111 | 66.286 | 1240.169 | 33.02 | 49.115 | 0 | 1579.949
 | [NAME] | 116.275 | 59.718 | 62.534 | 1257.314 | 34.588 | 48.575 | 0 | 1579.004
 | [NAME] | 138.897 | 70.856 | 64.409 | 1259.428 | 36.164 | 49.655 | 20.24 | 1639.649
 | [NAME] | 139.635 | 76.694 | 64.697 | 1264.303 | 31.228 | 49.655 | 2.76 | 1628.972
 | MY Sep-Aug | 521.055 | 272.379 | 257.926 | 5021.214 | 135 | 197 | 23 | 6427.574
2011/12 | Q1 Sep-Nov | 119.607 | 77.97 | 64.635 | 1268.554 | 32.9 | 50.1 | 0 | 1613.766
 | [NAME] | 114.999 | 71.005 | 62.018 | 1304.439 | 34.5 | 50.1 | 0 | 1637.061
 | MY Sep-Aug | 495 | 300 | 250 | 5000 | 135 | 200.7 | 24.3 | 6405
2012/13 | MY Sep-Aug | 500 | 300 | 265 | 5000 | 135 | 202 | 23 | 6425
1/ September-August.  Latest data may be preliminary or projected. Source: Calculated by USDA, Economic Research Service.
Date run: 5/11/2012
Spreadsheet: 138165d1327538404-hyperlink-with-a-vlookup-for-web-addresses-excel-test-sheetvladz
Sheet: Training Plan

Q2 Sales Training Plan
[NAME] for Q2:
Class Name | Category | Focus Area/Objectives | Required or Optional | Course/Registraiton Link or [NAME] | Credits
Business Code | General
FGHJ | Technical
RTFD | Various
Road Show | Portfolio
New Course Offerings for Q2
Business |  | 1 |  | Business | Web
Accounting |  | 1 |  | Accounting | Class
Spreadsheet: 682320d1592002597-indexing-entire-tables-from-multiple-sheets-in-one-excel-sheet-file-anxious-
Sheet: OCTOBER 

 | PARTICULARS | AMOUNTS(SHS) | AMOUNTS(SHS)2
 | Revenue from sustainable projects | 111111
 | Revenue from shows | 222222
 | Revenue from gardens | 220000
 | Total revenue | 293333.333333333
 | Operations Expenses | 347777.833333333
 | Restaurant expenses | 1400500
 | Coffee bar expenses | 1122185.27777778
 | Sauna expenses | 1319240.87301588
 | Accommodation expenses | 1516296.46825397
 | Garden maintenance | 1713352.06349207
 | Water | 1910407.65873016
 | Cosmetology | 2107463.25396826
 | GYM | 2304518.84920635
 | Sub total | 2501574.44444445
 | GENERAL EXPENSES | 2698630.03968254
 | Feeding of OVC home | 2895685.63492064
 | Amani dance troupe | 3092741.23015873
 | Electricity OVC | 3289796.82539683
 | Medication OVC | 3486852.42063492
 | Advance payment | 3683908.01587302
 | Office equipment | 3880963.61111111
 | Firewood | 4078019.20634921
 | Advertisement | 4275074.8015873
 | Fuel | 4472130.3968254
 | Salaries | 4669185.9920635
 | Facilitation | 4866241.58730159
 | Motor vehicle | 5063297.18253969
 | Sub total | 5260352.77777778
 | Total expenses
 | Surplus/deficit
 | Tax |  | 0
 | NET PROFITS
Spreadsheet: 801718d1666339572-find-if-a-cell-has-a-value-then-return-left-most-with-text-book21-professions-aligw
Sheet: Sheet1

 | [NAME] | Adam | Blake |  | [NAME] | Adam | Blake
Pilot | 8 |  | 2
Lawyer | 6 | 4 |  |  | Lawyer | Sales | Teacher
Teacher | 3 |  | 7 |  | Teacher
Sales |  | 5
Original Data |  |  |  |  | Desired result is above
Spreadsheet: 808095d1670283724-filter-function-how-to-combined-multiple-row-result-into-1-filter
Sheet: Sheet1

MaterialNumber | MaterialDescription | UnitOfMeasure |  |  | Filter [NAME] spill to 2 columns |  |  | Desired Result should be in 1 column |  |  |  | Data Validation
70000000 | ITEM a | EA |  |  |  | ITEM a
70001494 | item 17 | EA |  |  | 70001494 | item 17
70003952 | item 741 | STD |  |  | 70003952 | item 741
70003953 | item 88 | STD |  |  | 70003953 | item 88
70003954 | item 618 | EA |  |  | 70003954 | item 618
70003962 | item 848 | M2 |  |  | 70003962 | item 848
70003963 | item 757 | TO |  |  | 70003963 | item 757
70003964 | item 52 | L |  |  | 70003964 | item 52
70003965 | item 516 | M3 |  |  | 70003965 | item 516
70003966 | item 222 | EA |  |  | 70003966 | item 222
70004002 | item 88 | TO |  |  | 70004002 | item 88
70004022 | item 929 | TO |  |  | 70004022 | item 929
Spreadsheet: 544839d1509048813-changing-color-of-line-chart-with-source-data-chart-samples
Sheet: CS 2 Series 1 Target Each

 |  |  |  |  |  | F9 to randomize data
# | Series 1 | Series 2 | Target 1 | Target2 | Met Target1 | Met Target2
1 |  |  | 7 | 5
2 |  |  | 7 | 5 |  |  |  |  | use second axis when more than 1 series
3 |  |  | 7 | 5
4 |  |  | 7 | 5
5 |  |  | 7 | 5
6 |  |  | 7 | 5
7 |  |  | 7 | 5
8 |  |  | 7 | 5
Spreadsheet: 9fd3dd05-a3c3-4b06-b886-fcdbc92f0782
Sheet: 3.2

Cuadro 3.2
[NAME]
Matrimonios registrados, según [NAME], 2010
[NAME] | Matrimonios
Total País
Distrito Nacional | 5785
Azua | 423
Baoruco | 202
Barahona | 558
Dajabón | 104
Duarte | 1502
[NAME] | 44
El Seibo | 217
Espaillat | 1151
[NAME] | 86
[NAME] | 2989
[NAME] | 1024
[NAME] | 1942
María [NAME] | 540
Monte Cristi | 369
Pedernales | 35
Peravia | 599
Puerto Plata | 1887
[NAME] | 609
Samaná | 437
San Cristóbal | 2218
San Juan | 316
[NAME] | 1274
[NAME] | 476
Santiago | 6557
Santiago Rodríguez | 247
[NAME] | 667
[NAME] | 897
[NAME] | 468
Hato Mayor | 216
[NAME] | 133
Santo [NAME] | 9825
Nota: Elaborado con datos registrados en las oficialías del estado civil. Junta Central Electoral
Fuente: Oficina Nacional de Estadística, (ONE)
Spreadsheet: 119921d1314864344-timesheet-and-subtracting-constants-hours_temp
Sheet: Sheet1

 |  |  | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY |  | TOTAL | CARRIED
 | P | WK | START | FINISH | START | FINISH | START | FINISH | START | FINISH | START | FINISH | START | FINISH | START | FINISH
 | 4 | 14 | 09:05:00 | 17:50 | 09:00:00 | 17:45:00 | 08:45:00 | 18:00:00 | 00:00:00 | 00:00:00 | 08:45:00 | 17:15:00 | 07:45:00 | 14:15:00 | 00:00:00 | 00:00:00
HRS PAID |  |  |  |  |  |  |  |  | 00:00:00 |  |  |  |  |  | 00:00:00
 |  | 15 | 00:00:00 | 00:00:00 | 07:45:00 | 16:15:00 | 07:15:00 | 16:15:00 | 07:45:00 | 13:45:00 | 00:00:00 | 00:00:00 | 07:45:00 | 17:15:00 | 08:45:00 | 17:15:00
HRS PAID |  |  | 00:00:00 |  |  |  |  |  |  |  | 00:00:00
 |  | 16 | 09:00:00 | 17:00:00 | 07:45:00 | 16:15:00 | 00:00:00 | 00:00:00 | 07:45:00 | 15:15:00 | 07:45:00 | 16:15:00 | 07:45:00 | 16:30:00 | 00:00:00 | 00:00:00
HRS PAID |  |  |  |  |  |  | 00:00:00 |  |  |  |  |  |  |  | 00:00:00
 | 5 | 17 | 00:00:00 | 00:00:00 | 07:15:00 | 16:00:00 | 07:15:00 | 15:00:00 | 08:30:00 | 17:00:00 | 08:30:00 | 17:00:00 | 00:00:00 | 00:00:00 | 09:00:00 | 17:15:00
HRS PAID |  |  | 00:00:00 |  |  |  |  |  |  |  |  |  | 00:00:00
 |  | 18 | 08:30:00 | 16:15:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 07:45:00 | 16:15:00
HRS PAID |  |  |  |  | 00:00:00 |  | 00:00:00
 |  | 19
HRS PAID
 |  | 20
HRS PAID
Spreadsheet: 541374d1507246222-cant-unhide-rows-weekly-scorecard-template-copy
Sheet: P12

WEEKLY AREA SCORECARD |  |  |  |  |  |  | 2017
THIS FORM MUST BE EMAILED TO AREA COACH BY WEDNESDAY BY 10:00 AM EACH WEEK
Store: |  |  | Food Cost Goal: |  | Labor Goal:
Period #/ Week # | P12 / W1 |  | P12 / W2 |  | P12 / W3 |  | P12 / W4
Dates | 11/1 - 11/7 |  | 11/8 - 11/14 |  | 11/15 - 11/21 |  | 11/22 - 11/28
Customer
GES Overall Satisfied %
# of Surveys
Drive Thru OTD (#.##)
DT Menu Time (#.##)
DT Window Time (#.##)
Front Counter OTD (#.##)
Building Great Teams
Turn Over ( List Names at Bottom of  Sheet)
Crew Hires ( List Names at Bottom of Sheet)
Staffing Target
Current Staffing total
Learningzone Overall Team  %
Learningzone Food Safety %
ACT LIKE OWNERS
Net Sales | 1 |  | 4
Last Year Sales
YOY Sales Growth %
2017 YTD Sales
2016 YTD Sales
YTD Sales Growth %
1 GFS invoice total
2 GFS invoice total
3 GFS invoice total
4 GFS invoice total
1 Pepsi invoice total
2 Pepsi invoice total
Total COS
Food Cost %
$ [NAME] From Target
Hours Used
Labor $
Sales Per Man Hour
Labor %
Labor -/+$$
Overtime $
Refunds $ | 0 |  | 0 |  | 0 |  | 0
Discounts $
Cash +/- $
1 Terminated Team Member Name
Phone Number
2 Terminated Team Member Name
Phone Number
3 Terminated Team Member Name
Phone Number
New Hires This Week
1 New Hire Name
2 New Hire Name
3 New Hire Name
4 New Hire Name
Spreadsheet: 210782d1359563006-find-duplicate-values-based-on-2-separate-columns-book1
Sheet: Sheet1

Column A | Column B
1 | 1979-01-01 00:00:00
1 | 1987-07-03 00:00:00
1 | 1990-10-15 00:00:00
2
2 | 1999-05-04 00:00:00
2 | 1979-01-01 00:00:00
3 | 1999-05-04 00:00:00
1 | 1988-02-03 00:00:00
1 | 1999-05-04 00:00:00
1 | 1979-01-01 00:00:00
2 | 1987-07-03 00:00:00
2 | 2004-06-19 00:00:00
2 | 1988-02-03 00:00:00
3 | 2004-06-19 00:00:00
3 | 1979-01-01 00:00:00
1 | 1992-08-04 00:00:00
1 | 2004-06-19 00:00:00
2 | 1988-02-03 00:00:00
2 | 1932-06-04 00:00:00
3 | 1992-08-04 00:00:00
3 | 1932-06-04 00:00:00
3 | 1988-02-03 00:00:00
1
1 | 1932-06-04 00:00:00
2 | 1992-08-04 00:00:00
2 | 1990-10-15 00:00:00
3
3 | 1990-10-15 00:00:00
3 | 1992-08-04 00:00:00
3 | 1987-07-03 00:00:00
Spreadsheet: 862318d1710063901-xlookup-with-comma-delimited-pm-assignment-3
Sheet: Normal Project

Normal Project
Computations
Step | Successors | Early Start | Early Finish | Late Start | Late Finish | Float / Slack
 |  |  |  | 1
B |  |  |  | 2 |  |  |  | #N/A
 |  |  |  | 3
 |  |  |  | 99
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 30
Network Diagram
Spreadsheet: 799188d1664977614-extract-telephone-number-and-phone-number-extract-tele-nos
Sheet: Sheet2

To Extract telephone and phone numbers
code | Address /contact details | Address /contact details | Expected Answer | Expected Answer | Expected Answer
1015 | POST BOX # 119311 -TEL: +971 04 8842242 | TEL: +971 04 8942240 ,PH: 971 11 2939763 , FAX: 971 04 2959763 | TEL: +971 04 8842242 | TEL: +971 04 8942240 | PH: 971 11 2939763
951 | POST BOX # 118887 | PH: 971 04 8329811 , FAX: 971 04 8329211 | PH: 971 04 8329811
968 | BILL TO:EMAAR BUSINESS PARK-SHK ZAYED RD | TEL: +971 04 4430035 - FAX: +971 04 4432421 | TEL: +971 04 4430035
871 | POST BOX # 45200 | PH: 971 02 6979444 , PH: 971 02 6443989,FAX: 971 02 6979085 | PH: 971 02 6979444 | PH: 971 02 6443989
703 | TEL: +971 04 8142322 | FAX: +971 04 -PH: 971 02 6979444 | TEL: +971 04 8142322 | PH: 971 02 6979444
 |  |  |  | 971 04 8942240 | 971 11 2939763
 | 1. Check for either [NAME]: or Ph: in cell B and cell C of each row
 | 2 Need to extract [NAME]: and Ph: in separate columns in the sequence it reflects in those columns
 | 3. which means if in one column you have two Tel: , the it will appear in two separate columns , ie D and E |  |  | 971 02 6443989
 | 4. Same logic for PH: as well |  |  | 971 02 6979444
Spreadsheet: 839265d1691772073-a-column-that-repeats-a-plate-5-times-and-adds-a-different-letter-after-each-plate-example-mn
Sheet: DataSet

MN Acct # | MN State | MN Plate | [NAME] | MN VIN | [NAME] | MN Year
511435 | MN | STA2044 | 2810014 | 1GRAA5614BB701524 | Great Dane | 2011
511435 | MN | 6659STR | 8881600 | 1GRAA5616BB701525 | Great Dane | 2011
511435 | MN | 5129STP | 3616033 | 1GRAA7221GE700895 | Great Dane | 2016
511435 | MN | 1500STV | 3617034 | 1GRAA7221HE702826 | Great Dane | 2017
Spreadsheet: 854255d1704202085-adding-blank-columns-demo-data
Sheet: Sheet3

 | 2 | 3 | 4 |  |  |  |  | 18P | sa | 17S | 11CL
 |  | 75 | The American Insurance Company Limited. |  |  |  |  | 41 |  | 52000 | 300000
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  |  |  |  | 25 |  | 30000
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd |  |  |  |  | 325.3 |  | 0 | 0
 | 7 | 9 | [NAME] ([NAME] (Main)) |  |  |  |  | 4000 |  | 45500 | 600000
 | 8 |  | Myselfi & Associates Trading Pvt.Ltd |  |  |  |  | 11000 |  | 900 | 20000
 |  |  | [NAME].Ltd. |  |  |  |  | 105300 |  | 80900
 |  |  | Agraj Foods Pvt.Ltd,Kathmandu |  |  |  |  | 75430.4 |  | 354000
 |  |  | Alive Pharmaceutical Pvt. Ltd.,Nrt |  |  |  |  | 98430.6 |  | 46005
 |  |  | Nirvana Plastic Corp |  |  |  |  | 190000 |  | 0
Spreadsheet: sally_beck__33962__linkage
Sheet: Unit

Enron Wholesale Services
Project Linkage
by
Business Unit
 |  | Enron | Enron Industrial | Enron Global | Enron
Projects |  | Americas | Markets | Markets | Networks | RAC
Credit Risk Management (Phase I) |  |  |  |  |  | X
Financial Operations (Phase I) |  | X | X | X | X
Market Risk Management |  |  |  |  |  | X
Database System Management Review |  | X | X | X | X | X
Investment Compliance/Due Diligence |  |  |  |  |  | X
Related Party & Affiliate |  | X | X | X
Operational Analysis |  | X
Rate Server Applications |  | X | X | X
Paper & Steel Trading |  |  | X
Weather Derivatives Trading |  |  |  | X
Enron Online |  | X | X | X | X
Risk Controls Group |  | X | X | X
Market Data Network |  | X | X | X | X
Capital Structuring |  | X
Canada Trading |  | X
Coal Trading |  |  |  | X
Origination & Structuring |  | X | X | X
Natural Gas Trading |  | X
GRMS/ RisktRAC |  |  |  |  |  | X
South America Trading |  | X
Liquids Trading |  |  |  | X
Equity/Debt Trading |  |  |  | X
Model Development |  | X | X | X |  | X
Portfolio Management |  | X
Global Database Applications |  | X | X | X | X | X
Power Trading |  | X
Financial Settlements |  | X | X | X
Flash to Actual |  | X | X | X
Underwriting |  |  |  |  |  | X
Financial Operations (PhaseII) |  | X | X | X
F/X - Interest Rate Trading |  |  |  | X
Credit Risk Management (Phase II) |  |  |  |  |  | X
Standards Audit (IT) |  | X | X | X | X | X
Investment Valuation |  |  |  |  |  | X
Financial Business Analysis & Reporting |  | X
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: DBP

Raw Material |  | DBP
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 448.044
2023-10-02 00:00:00 |  |  |  |  | 42.5
2023-10-03 00:00:00 |  |  |  |  | 42.5
2023-10-04 00:00:00 |  |  |  |  | 42.5
2023-11-10 00:00:00 |  | 1 | 200
2023-11-21 00:00:00 |  |  |  |  | 8.64
2023-11-22 00:00:00 |  |  |  |  | 13
2023-11-23 00:00:00 |  |  |  |  | 13
2023-11-23 00:00:00 |  |  |  |  | 13
2023-11-24 00:00:00 |  |  |  |  | 13
2023-11-24 00:00:00 |  |  |  |  | 13
2023-11-24 00:00:00 |  |  |  |  | 8.64
2023-11-25 00:00:00 |  |  |  |  | 13
2023-11-25 00:00:00 |  |  |  |  | 13
2024-01-08 00:00:00 |  |  |  |  | 12.96
2024-01-09 00:00:00 |  |  |  |  | 8.64
2024-01-27 00:00:00 |  |  |  |  | 12.96
2024-01-28 00:00:00 |  |  |  |  | 12.96
2024-01-29 00:00:00 |  |  |  |  | 12.96
2024-01-30 00:00:00 |  |  |  |  | 12.96
2024-02-20 00:00:00 | SRN # 7658 |  |  |  | 12.96
2024-02-28 00:00:00 | SRN # 7659 |  |  |  | 12.96
Total
Spreadsheet: 39217d1237404634-list-data-validation-order
Sheet: Order

 |  | [NAME]
 |  |  |  |  |  |  | 2009-03-18 00:00:00
Type | Sub | Item | Quantity | Unit Price | Deposit |  | Total Cost
Wine | Import | Corona | 1 | 1.5 | 0.1 |  | 1.6
 |  | Order Total | 1 | 1.5 | 0.1 |  | 1.6