tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 125336d1318971826-multiple-if-statements-in-a-conditional-formatting-praccy
Sheet: Sheet1

 | Severity | Reported Date/Time | Response Date/Time | Resolved Date/Time | Response KPI | Resolved KPI | Comments
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
Spreadsheet: 268767d1380780070-indirect-function-to-pull-desired-no-of-cells-row-data-based-on-data-validation-in-input-file1
Sheet: M2

 | [NAME].Ltd.Siliguri |  | Period
SN | Name of Product | Type of Scheme | From | To | Minimum Sales Qty | Scheme given on sales per carton(in Rs) | Input field
1 | X | A | 2013-07-16 00:00:00 | 2013-08-16 00:00:00 | 200 |  | 8
2 | Y | A | 2013-07-16 00:00:00 | 2013-08-16 00:00:00 | 350 |  | 10
3 | Z | A | 2013-07-16 00:00:00 | 2013-08-16 00:00:00 | 500 |  | 12
1 | X | B |  | 2013-09-16 00:00:00 | 200 |  | 8
2 | Y | B |  | 2013-09-16 00:00:00 | 350 |  | 10
3 | Z | B |  | 2013-09-16 00:00:00 | 500 |  | 12
1 | X | C |  | 2013-10-17 00:00:00 | 200 |  | 8
2 | Y | C |  | 2013-10-17 00:00:00 | 350 |  | 10
3 | Z | C |  | 2013-10-17 00:00:00 | 500 |  | 12
1 | X | D |  | 2013-11-15 00:00:00 | 200 |  | 8
2 | Y | D |  | 2013-11-15 00:00:00 | 350 |  | 10
 | Z | D |  | 2013-11-15 00:00:00 | 500 |  | 12
Spreadsheet: 88682d1288520178-nested-if-statement-otv2-form
Sheet: Sheet1

Overtime Worksheet
Employee's name | [NAME] |  |  | Level |  | 5
Employee's number | 1234 |  |  | Step |  | 1
Travel Overtime | Date | Day | Holiday | Time In | convert | Time Out | convert | Overtime hours | Travel time hours | Overtime  Multiplier | Overtime Earned | Meal Allowance | ELIGIBLE? | hours eligible | Night Differential | Total Due
No | 2010-10-01 00:00:00 | Friday | 0 | 17:30:00 | 17.5 | 20:20:00 | 20.33333333333333 | 2.833333333333334 | 0 | 1.5 | 255.0000000000001 | 10 | 0 | 0 | 0 | 265.0000000000001
No | 2010-10-06 00:00:00 | Wednesday | 0 | 17:30:00 | 17.5 | 22:30:00 | 22.5 | 5.000000000000001 | 0 | 1.5 | 450.0000000000001 | 10 | 1 | 0.5 | 3 | 463.0000000000001
No | 2010-10-09 00:00:00 | Saturday | 0 | 08:00:00 | 8 | 19:22:00 | 19.36666666666667 | 11.36666666666667 | 0 | 1.5 | 1023 | 10 | 0 | 0 | 0 | 1033
No | 2010-10-10 00:00:00 | Sunday | 0 | 22:00:00 | 22 | 01:30:00 | 1.5 | 3.500000000000001 | 0 | 2 | 420.0000000000001 | 0 | 1 | 3.5 | 21 | 441.0000000000001
No | 2010-10-11 00:00:00 | Monday | 1 | 08:00:00 | 8 | 17:00:00 | 17 | 9.000000000000002 | 0 | 2 | 1080 | 0 | 0 | 0 | 0 | 1080
 |  |  |  |  |  |  |  | 31.7 | 0 | 8.5 | 3228.000000000001 | 30 |  |  | 24 | 3282.000000000001
 |  |  |  |  |  | Notes:
 |  |  |  |  |  | Travel overtime- |  | this pertains to time spent on travelling while rendering overtime.  Usually this happens if an employee is to partake
 |  |  |  |  |  |  |  | in a company-sponsored event within the city or out of the country
 |  |  |  |  |  |  |  | MAX number of hours to be claimed is 12 hours
 |  |  |  |  |  |  |  | this columns is the computation of number of travel time hours earned if "Yes" is selected from column A (Travel overtime)
 |  |  |  |  |  |  |  | I think my formula works just fine but I do not know how to include the maximum 12-hour condition.  Because there
 |  |  |  |  |  |  |  | are instances in which an employee may have longer than 12-hour flight (from North America to Asia)
 |  |  |  |  |  |  |  | Only employees hired before 05Jan05 are entitled to receive a $5 meal allowance
Travel Time |  |  |  |  |  |  |  | if an employee worked beyond 7pm during holidays and weekends, he gets $10 ($5*2)
Yes |  |  |  |  |  |  |  | If he works beyond 7pm on regular working days, he's just entitled to 1 meal allowance
No |  |  |  |  |  |  |  | Regular working days and time are Monday to Friday, 8-5pm
 |  |  |  |  |  |  |  | This is an enetilement if the overtime work is rendered from 10pm until 6 am the next day.
Travel Time Question |  |  |  |  |  | >> crucuial to the calculation! |  | The employee should have started before or exactly 10 pm for him to be eligible for this entitlement
Yes |  |  |  |  |  |  |  | This is equal to 10% of his hourly rate.
 |  |  |  |  |  |  |  | I do not exactly how to factor in the in-and-out time in the formula.
 |  |  |  |  |  |  |  | cell contents changed by JM
 |  |  |  | IF($G7>0.916667,VLOOKUP($G$3,Sheet2!$A$14:$K$18,(Sheet1!$G$4+1)*0.1,FALSE),0)
Spreadsheet: 135687d1326185558-excel-2007-vlookup-data-with-wildcard-lookup_example01
Sheet: TABLE2

SCHOOL | ENGINEERING | SCORE | RATE
SC001 | Y | 75 | 14
SC001 | N | 55 | 10
SC015 | * | 90 | 1
SC013 | * | 70 | 8
SC002 | Y | 75 | 14
SC002 | N | 90 | 10
Spreadsheet: 55628d1255719139-dual-lookup-vlookup-match-criteria-dual-lookup
Sheet: Brand GD

Name | ID | Instant | Overall | upsell 1 | upsell 2
[NAME] | FGTY | #N/A
[NAME] | HAQC
[NAME] | TMDF
[NAME] | SPKL
[NAME] | YXXX
[NAME] | WQBD
[NAME] | PPYH
Spreadsheet: 859773d1708019057-combine-all-tables-of-the-workbook-into-one-but-column-headers-are-different-option-2
Sheet: Batch D21

 |  | Summary of Assessment Outcome  Name of Programme: det  Name of Lecturer- Oluyinka Akingboju SSO Name- swa
 |  | Batch D21 result Sheet
 |  | Student ID | First Name | Surname | Result Unit 502  IV- tab | Result Unit 503   IV- tab | 1st Term Progression | Result Unit 417  IV- tab | Result Unit 506 IV- tab | Result Unit 423 IV- tab | 2nd Term Progression | Result Unit 426 IV- [NAME] | Result Unit 501 IV- [NAME] | 3rd Term Progression | Unit Pass        out of 7 units | Certificate Claimed Yes/No | Claimed by | Date of Certificate Recieving | Received by | Certificate Claim File | Incorrect Name | [NAME] only File | Correct Name As pe Passport | Checked by
 |  | 21093 | Emile | [NAME] | Pass | Pass | PP | Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  |  | yes
 |  | 21162 | KHANOM | Sania | Resit-Pass | Resit-Pass | PP | Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  |  | yes
 |  | 21141 | Ahmed | [NAME] | Resit-Pass | Pass | PP | Pass | Pass | Resit-Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  | yes
 |  | 21163 | [NAME] | Noorjahan | Resit-Pass | Pass | PP | Pass | Resit-Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  | 2022-11-14 00:00:00
 |  | 21179 | Madhanraja | Sinthuja | Resit-Pass | Resit-Pass | PP | Resit-Pass | Resit-Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  | can not find
 |  | 21155 | [NAME] | Wahidur | Pass | Pass | PP | Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  |  | yes
 |  | 21178 | [NAME] | KHANOM | Pass | Resit-Pass | WD | Withdrawn | Withdrawn | Withdrawn | WD | Withdrawn | Withdrawn | WD | 2 | WD
 |  | PP= Pass & Progress
 |  | PT= Progress with Trailing
 |  | Total Students |  |  | 26 | 26 |  | 25 | 25 | 25 |  | 25 | 25 | 25 | 8
 |  | Submission |  |  | 24 | 24 |  | 20 | 18 | 18 |  | 10 | 10
 |  | Submission Rate
 |  | Pass |  |  | 21 | 17 |  | 15 | 14 | 14 |  | 9 | 9
 |  | Refer |  |  | 3 | 7 |  | 5 | 4 | 4 |  | 1 | 1
 |  | Marking Pending |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0
 |  | Not Submitted
 |  | Passing rate |  |  |  |  |  |  |  |  |  |  |  | Overall achievement Rate
Spreadsheet: 839306d1691815991-return-different-matches-that-contains-part-of-the-searched-text-excel-formula-help
Sheet: Sheet1

apple |  | apple pie
melon |  | apple juice
pear |  | [NAME]
apple |  | apple4
melon |  | apple5
melon |  | pear1
melon |  | pear2
pear |  | pear3
apple |  | melon1
 |  | [NAME]
 |  | apple6
 |  | [NAME]
Spreadsheet: 66c6b76e-e2e9-4159-8e42-f107137c214e
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
Ehitushinnaindeksi muutus võrreldes eelmise kvartaliga, 2008–2011 (protsenti)
Presentage change of construction price index compared to the previous quarter, 2008–2011
 | I kvartal | II kvartal | III kvartal | IV kvartal
 | 1st quarter | 2nd quarter | 3rd quarter | 4th quarter |  |  |  |  | I | 1.115418064975742 | 6.010301606995057
 |  |  |  |  |  |  |  |  | II | 0.4293455254290848 | 4.242212701101352
2008 | 1.115418064975742 | 0.4293455254290848 | 0.4270908304246746 | -1.476778356769969 |  |  |  |  | III | 0.4270908304246746 | 3.073308178967537
2009 | -4.086812816564716 | -3.944602143984341 | -1.355020024864615 | -0.9188518465758762 |  |  |  |  | IV | -1.476778356769969 | 0.4771946832863705
2010 | -1.054053159610959 | -0.09197392457942044 | 1.165308309072088 | 0.6 |  |  |  |  | I | -4.086812816564716 | -4.692200598608849
2011 | -0.2 |  |  |  |  |  |  |  | II | -3.944602143984341 | -8.843092201930943
 |  |  |  |  |  |  |  |  | III | -1.355020024864615 | -10.46070069360626
 |  |  |  |  |  |  |  |  | IV | -0.9188518465758762 | -9.953649178704111
Ehitushinnaindeksi muutus  võrreldes eelmise [NAME] [NAME], 2008–2011 (protsenti) |  |  |  |  |  |  |  |  | I | -1.054053159610959 | -7.106397950315184
Presentage change of construction price index compared to the same period of the previous year, 2008–2011 |  |  |  |  |  |  |  |  | II | -0.09197392457942044 | -3.380584298538466
 |  |  |  |  |  |  |  |  | III | 1.165308309072088 | -0.9120080865286866
 |  |  |  |  |  |  |  |  | IV | 0.6 | 0.6
 | I kvartal | II kvartal | III kvartal | IV kvartal |  |  |  |  | I | -0.2 | 1.5
 | 1st quarter | 2nd quarter | 3rd quarter | 4th quarter
2008 | 6.010301606995057 | 4.242212701101352 | 3.073308178967537 | 0.4771946832863705
2009 | -4.692200598608849 | -8.843092201930943 | -10.46070069360626 | -9.953649178704111
2010 | -7.106397950315184 | -3.380584298538466 | -0.9120080865286866 | 0.6
2011 | 1.5
 | Ehitushinnaindeksi muutus võrreldes eelmise kvartaliga, 2008–2010 | Ehitushinnaindeksi muutus  võrreldes eelmise [NAME] [NAME], 2008–2010
I | 1.115418 | 6.010302
II | 0.429346 | 4.242213
III | 0.427091 | 3.073308
IV | -1.476778 | 0.477195
I | -4.086813 | -4.692201
II | -3.944602 | -8.843092 |  |  |  |  |  | 2008 | 2009 | 2010 | 2011
III | -1.35502 | -10.460701 |  |  |  |  | 1st quarter |  |  |  | 1.5
IV | -0.918852 | -9.953649 |  |  |  |  | 2nd quarter
I | -1.054053 | -7.106398 |  |  |  |  | 3rd quarter
II | -0.091974 | -3.380584 |  |  |  |  | 4th quarter
III | 1.165308 | -0.912008
Spreadsheet: 270680d1381585597-vlookup-not-working-example
Sheet: Before

100 | Yes | SS 316L | Yes | Yes | No | Yes | No | No |  | "=vlookup($L1:$L20,$A$1:$D$20,1,FALSE)"
30 | Yes | SS 316L | Yes | Yes | No | Yes | No | No
30 | Yes | SS 316L | No | No | No | No | No | No
100 |  | SS 316L | 18196.8 | Yes | 4692
30 |  | SS 316L | 9329.6 | Yes |  | No
10 | Yes | SS 316L | No | No | No | No | No | No
Spreadsheet: darrell_schoolcraft__7302__imball0201
Sheet: WTG inc

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  |  |  |  |  |  |  | -675 | -581
2 |  |  |  |  |  |  |  |  |  |  | -926 | -581
3 |  |  |  |  |  |  |  |  |  |  | -905 | -581
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 32494
2002-01-03 00:00:00
CBS Volume
 |  |  | 12039
Spreadsheet: 35970d1233705676-excel-2007-formatting-issue-when-linking-a-column-s-of-data-to-other-excel-files-discrete-measures
Sheet: SLw-rtoH

Level | 25PE | 25CS | 5PE | 5CS | 75PE | 75CS | 10PE | 10CS | 15PE | 15CS
Spreadsheet: 116673d1311975613-selective-columns-abbey-hill
Sheet: Pc

Pennington. C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  | 14
 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  | 12
 |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  | 4
 |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  | 6
 |  | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  | 8
 |  | 1
 |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
 |  | 13
 |  | 3
 |  | 11
 |  | 15
 |  | 5
 |  | 17
in
out
total
Spreadsheet: 773381d1647844653-is-there-a-less-complex-way-for-this-formula-conditional_forum-aligw
Sheet: Mehr_als_Conditional (2)

Datum | Added Weight in KG | Anzahl | [NAME] | [NAME] | [NAME] | Anzahl 5 | Anzahl 6 | [NAME] | Summe Tag | Delta Letzter Tag | Summe Woche
2022-03-01 00:00:00 |  | 10 | 10 |  | 10 |  | 10 | 10
2022-03-02 00:00:00 |  | 10 |  | 10 | 10 |  | 10 | 10
2022-03-03 00:00:00 |  | 10 | 10 |  | 10 | 10 | 10
2022-03-04 00:00:00 |  | 10 | 10 | 10 | 10 | 10 | 10
2022-03-05 00:00:00 |  | 10 |  | 10 |  |  | 10
Spreadsheet: 02f39c84-fead-4a24-ac63-991a1cdb4ac4
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
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 20. Number of Dwelling Units Approved in New Residential Buildings, Original - Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Total number of dwelling units ;  New ;  Houses ; |  |  | Original | A418403T | 1956-01-01 00:00:00 | 2013-10-01 00:00:00 | 694 | Number | FLOW | Month | 1
Total number of dwelling units ;  New ;  Semi-detached, row or terrace houses, townhouses - One storey ; |  |  | Original | A415785F | 1991-07-01 00:00:00 | 2013-10-01 00:00:00 | 268 | Number | FLOW | Month | 1
Total number of dwelling units ;  New ;  Semi-detached, row or terrace houses, townhouses - Two or more storeys ; |  |  | Original | A422926F | 1991-07-01 00:00:00 | 2013-10-01 00:00:00 | 268 | Number | FLOW | Month | 1
Total number of dwelling units ;  New ;  Semi-detached, row or terrace houses, townhouses - Total ; |  |  | Original | A416421K | 1991-07-01 00:00:00 | 2013-10-01 00:00:00 | 268 | Number | FLOW | Month | 1
Total number of dwelling units ;  New ;  Flats units or apartments - In a one or two storey block ; |  |  | Original | A423529V | 1991-07-01 00:00:00 | 2013-10-01 00:00:00 | 268 | Number | FLOW | Month | 1
Total number of dwelling units ;  New ;  Flats units or apartments - In a three storey block ; |  |  | Original | A424174L | 1991-07-01 00:00:00 | 2013-10-01 00:00:00 | 268 | Number | FLOW | Month | 1
Total number of dwelling units ;  New ;  Flats units or apartments - In a four or more storey block ; |  |  | Original | A424726X | 1991-07-01 00:00:00 | 2013-10-01 00:00:00 | 268 | Number | FLOW | Month | 1
Total number of dwelling units ;  New ;  Flats units or apartments - Total including those attached to a house ; |  |  | Original | A417063R | 1991-07-01 00:00:00 | 2013-10-01 00:00:00 | 268 | Number | FLOW | Month | 1
Total number of dwelling units ;  New ;  Total Other Residential ; |  |  | Original | A419138J | 1970-07-01 00:00:00 | 2013-10-01 00:00:00 | 520 | Number | FLOW | Month | 1
Total number of dwelling units ;  New ;  [NAME] ; |  |  | Original | A419824J | 1956-01-01 00:00:00 | 2013-10-01 00:00:00 | 694 | Number | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 888544d1739065268-update-needed-to-formula-to-only-show-data-for-month-sample-sheet-holger5
Sheet: February

 | Note: Rep names must be entered in exactly as they are shown in the survey report. Enter the supervisor name in the green boxes.
 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 | 2025-02-01 00:00:00 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | Raymi [NAME]
 | [NAME]
 | [NAME]
 | Ricardo Herrera
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 |  |  |  | Team Score
 | Sup 5
 |  |  |  | Team Score
 | Sup 6
 |  |  |  | DRG Score
 |  |  |  | Updated 11.15.24
Spreadsheet: 2b69e03a-1ab1-4fa1-b5aa-4a1c8ed18770
Sheet: Sheet1

CERTIFICATION TEST PASS RATES*  ([NAME] and Updated 11/7/11)
 | COMPLETION YEAR 2005 |  |  |  |  |  | COMPLETION YEAR 2006 |  |  |  |  |  | COMPLETION YEAR 2007 |  |  |  |  |  | COMPLETION YEAR 2008 |  |  |  |  |  | COMPLETION YEAR 2009 |  |  |  |  |  | COMPLETION YEAR 2010 |  |  | COMPLETION YEAR 2011
 | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | FINAL |  |  | FINAL
Name of Test | Tests Taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate
Mathematics (Secondary) | 1 | 1 |  | 1 | 1 |  | - | - | - | - | - | - | 1 | 1 |  | 1 | 1 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Mathematics 4-8 | 7 | 7 |  | 7 | 7 |  | 2 | 2 |  | 2 | 2 |  | 3 | 3 |  | 3 | 3 |  | 3 | 3 |  | 3 | 3 | 1 | 6 | 6 | 1 | 6 | 6 | 1 | 3 | 3 | 1 | 2 | 2 | 1
Mathematics 8-12 | 12 | 12 |  | 12 | 12 |  | 12 | 12 |  | 12 | 12 |  | 7 | 7 |  | 7 | 7 |  | 8 | 8 |  | 8 | 8 | 1 | 7 | 7 | 1 | 7 | 7 | 1 | 6 | 6 | 1 | 9 | 9 | 1
Mathematics/Science 4-8 | 1 | 1 |  | 1 | 1 |  | 4 | 4 |  | 4 | 4 |  | - | - | - | - | - | - | 3 | 3 |  | 3 | 3 | 1 | 2 | 2 | 1 | 2 | 2 | 1 | 3 | 3 | 1 | - | - | -
*Data obtained from Texas Education Agency's Accountability System for Educator Preparation (ASEP) report on pass rates sorted by Test.
*2010 Texas Education Agency starting using one yearly pass rate.
Spreadsheet: 270692d1381592584-formula-to-display-data-validation-results-on-another-sheet-based-on-data-chosen-test-workbook
Sheet: Data Sheet

 | NAME |  |  |  |  |  |  |  | DATA 1 | DATA 2 | DATA 3 | DATA 4 |  | --
 | [NAME] |  |  |  |  |  |  |  | YES | NO | YES | YES |  | YES
 | [NAME] |  |  |  |  |  |  |  | YES | YES | YES | YES |  | NO
 |  |  |  |  |  |  |  |  | -- | -- | -- | --
 |  |  |  |  |  |  |  |  | -- | -- | -- | --
 |  |  |  |  |  |  |  |  | -- | -- | -- | --
 |  |  |  |  |  |  |  |  | -- | -- | -- | --
 |  |  |  |  |  |  |  |  | -- | -- | -- | --
 |  |  |  |  |  |  |  |  | -- | -- | -- | --
 |  |  |  |  |  |  |  |  | -- | -- | -- | --
 |  |  |  |  |  |  |  |  | -- | -- | -- | --
 |  |  |  |  |  |  |  |  | -- | -- | -- | --
 |  |  |  |  |  |  |  |  | -- | -- | -- | --
 |  |  |  |  |  |  |  |  | -- | -- | -- | --
 |  |  |  |  |  |  |  |  | -- | -- | -- | --
 |  |  |  |  |  |  | $50-$249.99
 |  |  |  |  |  |  | $250-$999.99
 |  |  |  |  |  |  | $1000-$24,999.99
Spreadsheet: 854557d1704383658-power-query-excel-vlookup-and-replace-zeszyt1
Sheet: Arkusz1

source |  |  |  |  | final
name | code | Item 1 | Item 2 |  | name | code | Item 1 | Item 2
motorcycle | 111222 | aaaddd |  |  | motorcycle | 111222 | wheels
house | 2223334 | wwwrtt |  |  | house | 2223334 | door
car | 4556587 | aaaddd | wwwrtt |  | car | 4556587 | wheels | door
ball | 333455 | tytuli |  |  | ball | 333455 | vent
wheels | aaaddd |  |  |  | wheels | aaaddd
door | wwwrtt |  |  |  | door | wwwrtt
vent | tytuli |  |  |  | vent | tytuli
 |  |  |  |  | name | code | item 1 | item 2
 |  |  |  |  | car | 4556587 | wheels | door
 |  |  |  |  | motorcycle | 111222 | wheels
 |  |  |  |  | house | 2223334 | door
 |  |  |  |  | ball | 333455 | vent
 |  |  |  |  | wheels | aaaddd
 |  |  |  |  | door | wwwrtt
 |  |  |  |  | vent | tytuli
Spreadsheet: 119404d1314369820-excel-2007-how-do-i-get-multiple-values-form-a-vlookup-multiple-vlookups
Sheet: Sheet1

Date | Code | Arrived Time | Finish Time | A&B Concatenated | Unique A&B |  | Date | Code | Calls Attended | Arrived Time | Finish Time
2011-06-01 00:00:00 | A5PS | 14:29:00 | 14:32:00
2011-06-01 00:00:00 | TONE | 11:15:00 | 11:25:00
2011-06-01 00:00:00 | EEDS | 11:56:00 | 12:11:00
2011-06-02 00:00:00 | A4RS | 08:32:00 | 08:34:00
2011-06-01 00:00:00 | A4RS | 12:00:00 | 12:08:00
2011-06-01 00:00:00 | LAYS | 10:10:00 | 10:20:00
2011-06-01 00:00:00 | A6RH | 10:56:00 | 11:36:00
2011-06-23 00:00:00 | A6RH | 12:14:00 | 12:16:00
2011-06-01 00:00:00 | STER | 11:34:00 | 11:44:00
2011-06-01 00:00:00 | LAYS | 07:50:00 | 08:00:00
2011-06-01 00:00:00 | EEDS | 12:05:00 | 12:20:00
2011-06-02 00:00:00 | A8DG | 21:13:00 | 21:14:00
2011-06-08 00:00:00 | A3GL | 12:13:00 | 12:14:00
2011-06-01 00:00:00 | PSOM | 13:00:00 | 13:15:00
2011-06-01 00:00:00 | PSOM | 13:00:00 | 13:12:00
2011-06-01 00:00:00 | A3GL | 12:49:00 | 13:01:00
2011-06-02 00:00:00 | A3GL | 10:49:00 | 11:08:00
2011-06-01 00:00:00 | STER | 11:43:00 | 11:53:00
2011-06-02 00:00:00 | TONE | 07:20:00 | 07:35:00
2011-06-01 00:00:00 | A8DG | 14:04:00 | 14:45:00
2011-06-01 00:00:00 | A5PS | [NAME] | 09:56:00
Spreadsheet: daren_farmer__6637__hpl0328
Sheet: Sheet1

HPLN0328.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective March 28, 2000
 |  |  |  |  |  | ** Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-03-28 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM | VOLUME
HPL (FM) |  | LS HPL-KATY IC |  | HPL | 20 | 20
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | ENA | 5 | 10
Enron (ES) |  | Reklaw Master [NAME] |  | ENA | 0 | 30
Enron (ES) |  | Oasis Sealy |  | ENA | 0 | 5
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | Delhi TOG #3 |  |  | 1.25 | 1.25
Empire (Enron) |  | [NAME]. |  |  | 8 | 8
Empire (Enron) |  | Oasis Turine |  |  | 8.75 | 8.75
 |  | 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: 805783d1668915283-make-a-list-of-components-when-enter-quantity-of-product-bom-example
Sheet: product A

name | code | quantity | packing/box
glass A | 813 | 1 | 10
tube A | 753 | 1 | 20
ring A | 590 | 2 | 100
cover A | 342 | 2 | 25
bond | 110 | 4 | 100