tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 881163d1729085883-conditional-formatting-with-a-range-wip-crop-work-targets-and-misses-jt-
Sheet: Targets

Cultivar | Room | Cycle | Plug | [NAME] | Pinch | Pinch | 1st Touch | 1st Touch | 2nd Touch | 2nd Touch | 3rd Touch | 3rd Touch | 4th Touch | 4th Touch | 5th Touch | 5th Touch | Final | Final Defol
 |  |  | Date | Date | Target | Actual | target | Actual | Target | Actual | Target | Actual | Target | Actual | Target | Actual | Target | Actual
Equiposa
Spreadsheet: 862698d1710348445-worksheet-expressed-as-a-variable-inside-a-formula-book1
Sheet: Sheet1

 |  | a2 | b2 | c2 | d2 | e2
 | worksheet 1
 | Actual Week | 2 | 2 | 2 | 2 | 2
 | worksheet 2
 | Actual Week | 1 | 0 | 2 | 3 | 5
 | worksheet 3
 | Actual Week | 3 | 2 | 1 | 7 | 4
Spreadsheet: 04cf6079-2572-440f-8027-56a1ae1977db
Sheet: T21

الجدول 21: السكان في السودان بحسب [NAME] تعداد 2008
Table 21: Population of Sudan by age groups, 2008 census
 | Nationals | المواطنون | Non-nationals | [NAME] | Urban | حضر | Rural | ريف | Total | المجموع | المجموع
[NAME] | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | [NAME]
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | … | … | … | … | … | … | … | … | 3005746 | 2840245 | 5845991
5-9 | … | … | … | … | … | … | … | … | 3023603 | 2778173 | 5801776
10-14 | … | … | … | … | … | … | … | … | 2689626 | 2346411 | 5036037
15-19 | … | … | … | … | … | … | … | … | 2151401 | 2024954 | 4176355
20-24 | … | … | … | … | … | … | … | … | 1740076 | 1796936 | 3537012
25-29 | … | … | … | … | … | … | … | … | 1466418 | 1648548 | 3114966
30-34 | … | … | … | … | … | … | … | … | 1207987 | 1295976 | 2503963
35-39 | … | … | … | … | … | … | … | … | 1134069 | 1180296 | 2314365
40-44 | … | … | … | … | … | … | … | … | 905533 | 868298 | 1773831
45-49 | … | … | … | … | … | … | … | … | 689233 | 614447 | 1303680
50-54 | … | … | … | … | … | … | … | … | 581191 | 513515 | 1094706
55-59 | … | … | … | … | … | … | … | … | 350041 | 285760 | 635801
60-64 | … | … | … | … | … | … | … | … | 380847 | 310256 | 691103
65-69 | … | … | … | … | … | … | … | … | 227674 | 168614 | 396288
70-74 | … | … | … | … | … | … | … | … | 229753 | 185942 | 415695
75+ | … | … | … | … | … | … | … | … | 290779 | 222142 | 512921
غير محدد    Not stated | … | … | … | … | … | … | … | … | … | … | …
المجموع    Total | … | … | … | … | … | … | … | … | 20073977 | 19080513 | 39154490
Spreadsheet: 686806d1594820593-calculate-overlapping-leave-for-different-categories-overlapping_leave_powerquery_chris
Sheet: Sheet1

 |  |  |  |  |  | LEAVE CATEGORY |  | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | 2020-07-03 00:00:00 | 2020-07-04 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | 2020-07-09 00:00:00 | 2020-07-10 00:00:00 | 2020-07-11 00:00:00 | 2020-07-12 00:00:00 | 2020-07-13 00:00:00 | 2020-07-14 00:00:00 | 2020-07-15 00:00:00 | 2020-07-16 00:00:00 | 2020-07-17 00:00:00 | 2020-07-18 00:00:00 | 2020-07-19 00:00:00 | 2020-07-20 00:00:00 | 2020-07-21 00:00:00 | 2020-07-22 00:00:00 | 2020-07-23 00:00:00 | 2020-07-24 00:00:00 | 2020-07-25 00:00:00 | 2020-07-26 00:00:00 | 2020-07-27 00:00:00 | 2020-07-28 00:00:00 | 2020-07-29 00:00:00 | 2020-07-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-01 00:00:00 | 2020-08-02 00:00:00 | 2020-08-03 00:00:00 | 2020-08-04 00:00:00 | 2020-08-05 00:00:00 | 2020-08-06 00:00:00 | 2020-08-07 00:00:00 | 2020-08-08 00:00:00 | 2020-08-09 00:00:00 | 2020-08-10 00:00:00 | 2020-08-11 00:00:00
 |  |  | Expected output on 1 July as example |  |  | TEACHER |  | 2
 |  |  |  |  |  | STUDENT |  | 0
 |  |  |  |  |  | PAINTER |  | 1
STAFF NO | NAME | START DATE | END DATE | CATEGORY
1 | Mr. [NAME] | 2020-07-01 00:00:00 | 2020-07-20 00:00:00 | TEACHER |  |  |  | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L
2 | Mr. [NAME] | 2020-07-04 00:00:00 | 2020-07-10 00:00:00 | TEACHER |  |  |  |  |  |  | L | L | L | L | L | L | L
3 | Mr. [NAME] | 2020-08-01 00:00:00 | 2020-08-10 00:00:00 | STUDENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | L | L | L | L | L | L | L | L | L
4 | Mr. [NAME] | 2020-07-01 00:00:00 | 2020-08-04 00:00:00 | PAINTER |  |  |  | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L
5 | Mr. [NAME] | 2020-07-01 00:00:00 | 2020-07-05 00:00:00 | TEACHER |  |  |  | L | L | L | L | L
Spreadsheet: 136533d1326712048-excel-2007-help-linking-to-spreadsheets-by-adding-a-update-option-example-raw-material
Sheet: Sheet1

Stock Code | Description | Cost Price | Unit of Sale | equivelents | Order Quantity | Date updated | Order Number
CB3000 | PB29-ULTRAMARINE BLUE DRM PREMIER | 3.67 | KG | 11 |  | 2009-01-01 00:00:00
CB3001 | PB29-ULTRAMARINE BLUE NUBIPERF H-77 | 3.19 | KG | 11 |  | 2009-01-01 00:00:00
CB3002 | PB15:3-PIGMERON BLUE BFP | 5.3 | KG | 11 | Based on 600kg £50 surcharge for less | 2011-02-24 00:00:00
CB3002A | MEGAHFAST BLUE 909KNP | 6.17 | KG | 11 |  | 2011-07-28 00:00:00
Spreadsheet: 134331d1325212496-lookup-one-value-in-a-range-and-then-lookup-another-value-beneath-it-multiple-lookup-problem
Sheet: Sheet1

 | Person/Project | Time (decimal)
 | Person A | 7.101111111111111
 | Project 1 | 3.756388888888889
 | Project 2 | 2.118888888888889
 | Project 3 | 1.225833333333333
 | Person B | 17.16666666666667
 | Project 2 | 17.16666666666667
 | Person C | 16
 | Project 1 | 14
 | Project 4 | 1
 | Project 5 | 1
 | Person D | 1.5
 | Project 1 | 1.5
Spreadsheet: 76432d1276950573-concatenation-needed-in-table-array-section-of-vlookup-formula-concatinate-vlookup
Sheet: Chart

 |  |  | Messed up [NAME]
 |  | JZ1Cur | #N/A | VLOOKUP(C$2,$C$5:$J$13,3,FALSE)
 |  |  |  | I need the table_array part, $C$5 to pull together [NAME] and D5 in a concantination and then do a :$J$3
 |  | JZ1 | Cur | 10 | 12.5 | 15.625 | 19.53125 | 24.4140625 | 30.517578125
 |  | JZ1 | [NAME] | 11 | 13.75 | 17.1875 | 21.484375 | 26.85546875 | 33.5693359375
 |  | JZ1 | Pln | 12.1 | 15.125 | 18.90625 | 23.6328125 | 29.54101562500001 | 36.92626953125
 |  | JZ2 | Cur | 13.31 | 16.63750000000001 | 20.796875 | 25.99609375000001 | 32.49511718750001 | 40.618896484375
 |  | JZ2 | [NAME] | 14.641 | 18.30125000000001 | 22.8765625 | 28.59570312500001 | 35.74462890625001 | 44.68078613281251
 |  | JZ2 | Pln | 16.1051 | 20.13137500000001 | 25.16421875 | 31.45527343750001 | 39.31909179687502 | 49.14886474609376
 |  | JZ3 | Cur | 17.71561000000001 | 22.14451250000002 | 27.68064062500001 | 34.60080078125002 | 43.25100097656253 | 54.06375122070315
 |  | JZ3 | [NAME] | 19.48717100000001 | 24.35896375000002 | 30.44870468750001 | 38.06088085937503 | 47.57610107421878 | 59.47012634277347
 |  | JZ3 | Pln | 21.43588810000001 | 26.79486012500002 | 33.49357515625001 | 41.86696894531253 | 52.33371118164067 | 65.41713897705083
Spreadsheet: 183537d1348853987-average-ifs-multiple-criteria-sample
Sheet: XXX Summary Northeast

[NAME]
[NAME] | [NAME]
Pharmacy | Survey #'s | Average | Accounts Surveyed
CCRX [NAME] |  |  | 0
CCRX Newport |  |  | 1
[NAME] |  |  | 3
OCR Edison |  |  | 5
OCR Greensburg |  |  | 9
[NAME] of Prussia |  |  | 7
OCR Pittsburgh |  |  | 1
OCR Scranton |  |  | 0
OCR Southern NJ |  |  | 12
[NAME] |  |  | 10
OCR of Williamsport |  |  | 2
REGION TOTAL
 | CCRX [NAME] | CCRX Newport | [NAME] | OCR Edison | OCR Greensburg | [NAME] of Prussia | OCR Pittsburgh | OCR Scranton | OCR Southern NJ | [NAME] | OCR of Williamsport | REGION AVE.
Pharmacy Average
Ease of ordering (e.g. fax, phone) process
Medication accuracy (i.e. Right Drug/Right Patient)
Routine scheduled deliveries are on time
Stats are delivered within an appropriate timeframe
Medical Records are accurate
Medical Records are received by the agreed upon date
Pharmacy billing statements are accurate
Overall rating of the pharmacy's ability to meet your needs
Expertise of infusion (IV) services personnel
Expertise of consultant pharmacist
Expertise of other pharmacy services (ie: nursing, QA tech, customer service)
Staff education
Drug information provided by Pharmacists is useful
Assistance in resolving facility or patient concerns
Timely response to facility or patient concerns
Understanding of facility or patient concerns
Courtesy of pharmacy staff
Clear explanation and timely communication about medications that are not available for your order
Overall rating of the pharmacy's ability to meet your expectations
Recommendation "Yes"
Recommendation  "No"
Recommendation "na"
Total
Spreadsheet: 708363d1607764304-convert-multiple-columns-to-multiple-rows-sample_columns-to-rows
Sheet: Sheet4

EE Name | tin | tout |  |  | EE Name | Local Time | Type
[NAME] | 12/08/2020 08:00:00 | 12/08/2020 17:00:00
[NAME] | 12/09/2020 08:00:00 | 12/09/2020 17:00:00
Trump | 13/09/2020 08:00:00 | 12/09/2020 17:00:00
Trump | 13/09/2020 08:00:00 | 12/09/2020 17:00:00
Biden | 14/09/2020 08:00:00 | 12/09/2020 17:00:00
Biden | 14/09/2020 08:00:00 | 12/09/2020 17:00:00
Spreadsheet: 65952d1266577879-excel-2007-what-if-im-out-of-ifs-example
Sheet: Sheet1

 |  |  |  |  | Example |  |  |  |  | Working
 |  | [NAME] | Multiplier |  | Reformated | Kg | Calcs | Should Be |  | Kg | Should Be
 |  | 0-49 | 1.45 |  | N/A | N/A | N/A | N/A |  | N/A | N/A
 |  | 50-99 | 1.35 |  | 5.3 | 5.30 |  |  |  | 5.30 | 7.685
 |  | 100-249 | 1.25 |  | 5.11 | 5.11 |  |  |  | 5.11 | 7.4095
 |  | 250-1000 | 1.15 |  | 6.33 | 6.33 |  |  |  | 6.33 | 9.1785
 |  |  |  |  | 8.77 | 8.77 |  |  |  | 8.77 | 12.7165
 | Notes: |  |  |  | 3.71 | 3.71 |  |  |  | 3.71 | 5.3795
 | Column G is formatted as imported, text! |  |  |  | 3.54 | 3.54 |  |  |  | 3.54 | 5.133
 | Column F is reformated as a number |  |  |  | 3.13 | 3.13 |  |  |  | 3.13 | 4.5385
 |  |  |  |  | 3.13 | 3.13 |  |  |  | 3.13 | 4.5385
 | Main Issues: |  |  |  | 2.91 | 2.91 |  |  |  | 2.91 | 4.2195
 | Need to run formula without reformatting G:G |  |  |  | 2.7 | 2.70 |  |  |  | 2.70 | 3.915
 | Some calc correct other wrong |  |  |  | 1.71 | 1.71 |  |  |  | 1.71 | 2.4795
 | Red has calculated incorrectly |  |  |  | 15.03 | 15.03 |  |  |  | 15.03 | 21.7935
 |  |  |  |  | 61.04 | 61.04 |  |  |  | 61.04 | 82.40400000000001
 |  |  |  |  | 4.99 | 4.99 |  |  |  | 4.99 | 7.2355
Spreadsheet: 844364d1696097434-combine-week-sheets-into-week1-blank-workouttracker
Sheet: Additional Macro Calculations

 |  |  | Calculate your LBM Here: (lbs) |  |  |  |  |  | BW: (lbs) |  | 175 |  |  |  |  | LBM: (lbs) |  | 175
 |  |  | BW: (lbs) | 175 |  |  |  |  | [NAME]: |  | 2445 |  |  |  |  | [NAME]: |  | 2445
 |  |  | BF: (%) | 28 |  |  |  |  | Protein per gram: (lb) |  | 1.277777777777778 |  |  |  |  | Protein per gram: (lb) |  | 1.452020202020202
 |  |  | LBM = |  |  |  |  |  | Fat per gram: (lb) |  | 0.4444444444444445 |  |  |  |  | Fat per gram: (lb) |  | 0.505050505050505
 |  |  |  |  |  |  |  |  |  | Fat | Protein | Remaining Calories |  |  |  |  | Fat | Protein | Remaining Calories
 |  |  | This section is for people calculating macronutrient needs based off of Pounds. (English system) |  |  |  |  |  | Calories |  |  |  |  |  |  | Calories
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | ***Only Enter #'s where Font is Red***
 |  |  | Calculate your LBM Here: (kgs) |  |  |  |  |  | BW: (kgs) |  | 81.6 |  |  |  |  | LBM: (kgs) |  | 71.85
 |  |  | BW: (kgs) | 81.6466266 |  |  |  |  | [NAME]: |  | 2100 |  |  |  |  | [NAME]: |  | 2100
 |  |  | BF: (%) | 12 |  |  |  |  | Protein per gram: (kg) |  | 2.818627450980392 |  |  |  |  | Protein per gram: (kg) |  | 3.201113430758525
 |  |  | LBM = |  |  |  |  |  | Fat per gram: (kg) |  | 0.9803921568627452 |  |  |  |  | Fat per gram: (kg) |  | 1.113430758524704
 |  |  |  |  |  |  |  |  |  | Fat | Protein | Remaining Calories |  |  |  |  | Fat | Protein | Remaining Calories
 |  |  | This section is for people calculating macronutrient needs based off of Kilograms. (Metric system) |  |  |  |  |  | Calories |  |  |  |  |  |  | Calories
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
 | These calculations can be used for people who want to calculate their Protein and Fat goals for the day and choose to use the remaining calories left over from their Caloric Goal to spread out however they wish. If you wish to calculate your Carb goal for the day by using the remaining calories - just divide that number by 4.
Spreadsheet: 146706d1332323706-sum-if-on-named-cells-sample
Sheet: Sch 2 - Exp Detail

 |  | Project Name |  | 0
 |  | Project Code - once available |  | 0
 |  | Project Period |  | 0
 |  | Start Date of Project |  | 0
 |  | [NAME] |  | 0
 |  | Programme Manager - if applicable |  | 0
 |  | Project Manager |  | 0
 |  | Account Code | Account Description |  |  |  |  |  |  |  | Total |  |  |  |  | Q1 | Q2 | Q3 | Q4 | Total | Q1 | Q2 | Q3 | Q4 | Total | Q1 | Q2 | Q3 | Q4 | Total | Q1 | Q2 | Q3 | Q4 | Total | Q1 | Q2 | Q3 | Q4 | Total | Total | Check
 |  |  | BUDGET YEAR |  |  |  |  |  |  |  |  |  |  |  |  | 2011/2012 |  |  |  | 2011/2012 | 2012/2013 |  |  |  | 2012/2013 | 2013/2014 |  |  |  | 2013/2014 | 2014/2015 |  |  |  | 2014/2015 | 2015/2016 |  |  |  | 2015/2016
 |  |  | Expense Category
 |  | 81100 | Salaries |  |  |  |  |  |  |  | 67200 |  |  |  |  | 0 | 5000 | 8000 | 8000 | 79000 |  |  |  |  | 17000 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 96000 | -28800
 |  | 81200 | NICS & Pensions |  |  |  |  |  |  |  | 10800 |  |  |  |  | 0 | 500 | 900 | 900 | 8200 |  |  |  |  | 2600 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 10800 | 0
 |  | 81250 | Pension Costs - FRS17 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81300 | Other Employment Costs |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81400 | Temporary Staff Costs |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81500 | Travel & Subsistence Expenses |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81600 | Entertaining |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81700 | Car Costs |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81800 | Delegate Costs to Conf/Festivals |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81900 | Volunteers & Members |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81910 | Trustees |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  | 81950 | Efficiency Savings |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 | 0 | 0
 |  |  | Staff and Related Costs |  |  |  |  |  |  |  | 78000 |  |  |  |  | 0 | 5500 | 8900 | 8900 | 87200 | 0 | 0 | 0 | 0 | 19600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 106800 | -28800
Spreadsheet: 80940d1281182485-count-countif-how-to-count-a-portion-of-a-list-countbetweenzero
Sheet: Sheet1

numbers | count |  |  | note there must be a 0 immediatly after the last number for this to work
0 | 0
0 | 0
1 | 5
2 | 5
3 | 5
4 | 5
5 | 5
0 | 0
0 | 0
1 | 3
2 | 3
3 | 3
0 | 0
0 | 0
54 | 10
23 | 10
8 | 10
39 | 10
70 | 10
101 | 10
132 | 10
163 | 10
194 | 10
225 | 10
0
Spreadsheet: 489097d1479088196-formula-required-vlookup-temp-hrs-test
Sheet: Sheet1

Empl./Appl.Name | Pers.No. | Date | Hours | Time type descript. | Cost Ctr | Org. Unit | Org. Unit2 | Pers. subarea | Job key | EE subgroup | EE subgrp | Subarea | TmType | Work schedule rule (short) | End Date | Position | Week | Month | Day | Yr | Shift | Section 1 | Section 2 | Sub | Count | HERE | TEMP HRS START | TEMP HRS STOP
[NAME] | 123 | 2016-10-01 00:00:00 | 8 | Regular Hours | 417 | 864 | OPS | [NAME] | CLK | CP Temporary(CUPW) | 7F | 0221 | 9310 | TEMP | 9999-12-31 00:00:00 | 83 | 44 | Nov | 01 | 16 | HERE | OPS | MGR. | TEMP | 1 | NC
[NAME] | 123 | 2016-10-02 00:00:00 | 2 | Approved Overtime @ 1.5 | 417 | 864 | OPS | [NAME] | CLK | CP Temporary(CUPW) | 7F | 0231 | 3040 | TEMP | 2016-11-05 00:00:00 | 83 | 44 | Nov | 01 | 16 | HERE | OPS | MGR. | TEMP | 1 | NC
[NAME] | 123 | 2016-10-03 00:00:00 | 0.75 | Approved Overtime @ 2.0 | 417 | 864 | OPS | [NAME] | CLK | CP Temporary(CUPW) | 7F | 0231 | 3042 | TEMP | 2016-11-06 00:00:00 | 83 | 44 | Nov | 01 | 16 | HERE | OPS | MGR. | TEMP | 1 | NC
[NAME] | 123 | 2016-10-04 00:00:00 | 8 | Regular Hours | 417 | 864 | OPS | [NAME] | CLK | CP Temporary(CUPW) | 7F | 0231 | 9310 | TEMP | 2016-11-07 00:00:00 | 83 | 44 | Nov | 01 | 16 | HERE | OPS | MGR. | TEMP | 1 | NC
[NAME] | 123 | 2016-10-05 00:00:00 | 8 | Regular Hours | 417 | 864 | OPS | [NAME] | CLK | CP Temporary(CUPW) | 7F | 0231 | 9310 | TEMP | 2016-11-08 00:00:00 | 83 | 44 | Nov | 01 | 16 | HERE | OPS | MGR. | TEMP | 1 | NC
[NAME] | 123 | 2016-10-06 00:00:00 | 3 | Regular Hours | 417 | 864 | OPS | [NAME] | CLK | CP Temporary(CUPW) | 7F | 0231 | 9310 | TEMP | 2016-11-10 00:00:00 | 83 | 44 | Nov | 01 | 16 | HERE | OPS | MGR. | TEMP | 1 | NC
[NAME] | 123 | 2016-10-06 00:00:00 | 1 | Approved Overtime @ 2.0 | 417 | 864 | OPS | [NAME] | CLK | CP Temporary(CUPW) | 7F | 0231 | 9310 | TEMP | 2016-11-11 00:00:00 | 83 | 44 | Nov | 01 | 16 | HERE | OPS | MGR. | TEMP | 1 | NC
 |  | In Col. E and at Regular Hours only and if Col. O reads TEMP I need the start and end times from Sheet 2, Col. K + L, to be pulled into this sheet, Col. AA + Col. AB
Spreadsheet: 111026d1307544282-database-list-system-development-draft-1
Sheet: DATA - DO NOT EDIT

Data/calculations for auto-fill function:
 | FCAC | Member | CRM | Other | Total
Count | 5 | 6 | 2 | 3 | 16
Lists:
Methods of Notice: | Statuses:
FCAC | Incomplete
Member | In Progress
CRM | Complete
Other
Spreadsheet: 41607d1240147740-comparing-and-deleting-data-in-2-columns-test-data
Sheet: FINAL Results Expected

UniqueId | ReferenceNo | cardnumber | carddesc | designation | department | LastDoor | SwipeDate
28110 | 5 | 4167 | A Belatreche | Senior SHO | Oral Maxfax | 6 OPT Entrance [121] | 2005-05-19 00:00:00
14975 | 2 | 3290 | A K Narayansamy | SHO | Anaes | 5 Trust HQ [31] | 2006-02-02 00:00:00
139764 | 7 | 8991 | [NAME] | SHO | T&O |  | 00:00:00
This table shows the results I would like to achieve - i.e. Original db list minus the Filter results list
Spreadsheet: vkaminski__40934__American
Sheet: Sheet1

 | American Put Option Valuation on Forward Contract
 |  | Premium (US$)
 |  | Premium (%)
 |  | Valuation Date
 |  | Expiration Date
 |  | Years to expiry |  | 4
 |  |  | ENE Screen Price |  | 62.05
 |  |  | Forward Price
 |  |  | Strike Price on Fwd
 |  |  | Volatility |  | 0.43
 |  |  | IR |  | 0.05
 |  |  | Div. Yield
 |  |  | Div. US$ |  | 0.5
 |  |  | Days to [NAME]
 |  |  | Call Flag (Put = 0) |  | 0
 |  |  | Ret Type (Premium = 0) |  | 0
Spreadsheet: 376891d1423741281-conditional-sum-book1
Sheet: Sheet1

Designation | Shift | Bus | Cab
Senior Consultant | 39600 |  |  |  |  | Designation | Shift | Bus | Cab | Total
Consultant |  |  |  |  |  | Senior Consultant | Yes | Yes | No | 39600+27000+0 | If H7 = "Yes" add the "Senior Consultant" shift value from "B", "C", "D"columns else Zero
Associate Consultant |  |  |  |  |  | Consultant |  |  |  |  | same way for Bus and [NAME] totals
Specialist |  |  |  |  |  | Senior Specialist
Senior Engineer |  |  |  |  |  | Senior Design Engineer
Engineer |  |  |  |  |  | Consultant
 |  |  |  |  |  | Specialist
 |  |  |  |  |  | Consultant
 |  |  |  |  |  | Senior Design Engineer
 |  |  |  |  |  | Senior Design Engineer
 |  |  |  |  |  | Senior Design Engineer
 |  |  |  |  |  | Design Engineer
 |  |  |  |  |  | Design Engineer
 |  |  |  |  |  | Senior Specialist
 |  |  |  |  |  | Team Leader
 |  |  |  |  |  | Design Engineer
Spreadsheet: 833968d1687363299-check-that-multiple-column-values-are-unique-across-a-range-untitled-spreadsheet
Sheet: Sheet1

Full Name | Player 1 | Player 2 | Player 3 | Player 4 | Player 1 Odds | Player 2 Odds | Player 3 Odds | Player 4 Odds | Odds Total | Unique Team |  | Paid
 | Wyndham [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | Jon Rahm | [NAME] | [NAME]
 | [NAME] | Jon Rahm | [NAME] | [NAME]
Odds | Palyer | Column1
9 | [NAME] | 9
9 | Jon Rahm | 9
9 | [NAME] | 9
14 | [NAME] | 14
18 | [NAME] | 18
18 | [NAME] | 18
18 | [NAME] | 18
20 | [NAME] | 20
20 | [NAME] | 20
20 | [NAME] | 20
20 | [NAME] | 20
25 | [NAME] | 25
25 | [NAME] | 25
25 | [NAME] | 25
30 | [NAME] | 30
33 | [NAME] | 33
33 | Shane Lowry | 33
33 | [NAME] | 33
40 | [NAME] | 40
40 | [NAME] | 40
40 | [NAME] | 40
50 | [NAME] | 50
50 | [NAME] | 50
50 | Sung-Jae Im | 50
50 | Wyndham [NAME] | 50
66 | [NAME] | 66
66 | [NAME] | 66
80 | [NAME] | 80
80 | [NAME] | 80
80 | [NAME] | 80
80 | [NAME] | 80
80 | [NAME] | 80
80 | [NAME] | 80
80 | [NAME] | 80
80 | [NAME] | 80
80 | [NAME] | 80
80 | [NAME] | 80
100 | [NAME] | 100
100 | [NAME] | 100
100 | [NAME] | 100
125 | [NAME] | 125
125 | [NAME] | 125
125 | [NAME] | 125
125 | Seamus Power | 125
125 | Talor Gooch | 125
150 | [NAME] | 150
150 | Harris English | 150
150 | [NAME] | 150
150 | [NAME] | 150
175 | Adrian Meronk | 175
175 | [NAME] Poulter | 175
175 | [NAME] | 175
175 | [NAME] | 175
175 | [NAME] | 175
175 | [NAME] | 175
200 | [NAME] | 200
200 | [NAME] | 200
200 | [NAME] | 200
200 | [NAME] | 200
200 | [NAME] | 200
200 | [NAME] | 200
200 | [NAME] | 200
200 | [NAME] | 200
200 | [NAME] | 200
200 | [NAME] | 200
200 | [NAME] | 200
200 | [NAME] | 200
200 | [NAME] | 200
250 | [NAME] | 250
250 | [NAME] | 250
250 | [NAME] | 250
250 | [NAME] | 250
250 | [NAME] | 250
250 | Dean Burmester | 250
250 | [NAME] | 250
250 | Pablo Larrazabal | 250
250 | [NAME] | 250
300 | [NAME] | 300
300 | [NAME] | 300
300 | [NAME] | 300
300 | [NAME] | 300
300 | [NAME] | 300
300 | [NAME] | 300