tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0749ece0-3ffe-421f-a920-7b90e60ac684
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
 |  | Please return this form and your short letter to
 |  | the applicant in a sealed envelope.  Sign your
 |  | name across the flap.
 | Recommendation Form |  |  |  |  |  |  |  |  |  |  |  | SUNY Geneseo                   MS in Accounting
 | Candidate's Name
 | In accordance with the Family Educational Rights and Privacy Act, I |  |  |  |  |  |  |  |  |  | waive |  | do not waive
 | my rights to read this letter of recommendation.
 | Candidate's Signature |  |  |  |  |  |  |  |  | Date
 | To the recommender:  Please complete a short letter which responds to the questions set out below.
 | 1) | How long have you known the applicant, and in what capacity?
 | 2) | Comment on any outstanding aptitudes or abilities that the applicant has displayed.
 | 3) | Comment on ways in which the applicant has contributed to organizations of which he or she is a member.
 | 4) | Comment on any other aspect of the applicant's record which could have a material impact on
 |  | the admissions decision.
 |  |  |  | Outstanding Top 5% |  | Excellent Top 15% |  | Good Top1/3 |  | Average Middle 1/3 |  | Below Average Bottom 1/3 |  | Unable to Judge
 |  | Analytical ability
 |  | Written communication skills
 |  | Oral communication skills
 |  | Intitiative & work ethic
 |  | Integrity
 |  | Interpersonal and teamwork skills
 |  | Leadership
 |  |  |  |  |  |  | }
 |  | I strongly recommend |  |  |  |  |  |  | that this applicant be admitted to
 |  | I recommend |  |  |  |  |  |  | the SUNY-Geneseo MS in Accounting.
 |  | I recommend with some reservations
 |  | I do not recommend
 |  | Name |  |  |  |  |  | Address
 |  | Position / Title |  |  |  |  |  | City, State, Zip
 |  | Organization |  |  |  |  |  | Telephone Number
 |  | e-mail |  |  |  |  |  | Date
 |  | Signature of Evaluator
Spreadsheet: louise_kitchen__24091__NEWCO HEADCOUNT NAMES
Sheet: Canada Support

Canada Support
[NAME] | Logistics | VP
[NAME] | [NAME] | Admin Coordinator
Liknes | Documentation | [NAME]
Dawes | Accounting | Director
Marryott | Toronto | Director
[NAME] | Risk | Manager
Reeves | Risk | Manager
Hanslip | Accounting | Manager
[NAME] | Toronto | Manager
[NAME] | Risk | Spec
Unger | Risk | Spec
Moscoso | Documentation | Spec
Martin | IT | Spec
Ripley | Logistics | Spec.
[NAME] | Accounting | Spec.
Panchuk |  | Specialist
O'Neil | [NAME] | Sr. Admin
McCullough | [NAME] | Sr. Admin
[NAME] | Legal | Sr. Counsel
Keohane | Legal | Sr. Counsel
Johnston |  | Sr. Counsel
Seib | Documentation | Sr. Spec
[NAME] | Documentation | Sr. Spec
Prior | Logistics | Sr. Spec
[NAME] | IT | Sr. Spec
Donlevy-Lee | Accounting | Sr. Spec.
Quon | Accounting | Sr. Spec.
Vacancy | HR | Sr. Spec.
Luc | Risk | Staff
Punja | Volume Management | Staff
Tackney | Logistics | Staff
Scott | Accounting | VP
 |  | Total | 33
Spreadsheet: 95195d1294851771-merge-and-sort-non-adjacent-cells-excel-help
Sheet: Report I have

Employee | Date | [NAME] | Logout Date | Logout Time
A | 2011-01-03 00:00:00 | 06:59:00 | 2011-01-03 00:00:00 | 11:16:00
A | 2011-01-03 00:00:00 | 11:30:00 | 2011-01-03 00:00:00 | 12:35:00
A | 2011-01-03 00:00:00 | 13:19:00 | 2011-01-03 00:00:00 | 15:00:00
A | 2011-01-03 00:00:00 | 15:20:00 | 2011-01-03 00:00:00 | 16:15:00
B | 2011-01-03 00:00:00 | 07:57:00 | 2011-01-03 00:00:00 | 10:15:00
B | 2011-01-03 00:00:00 | 10:30:00 | 2011-01-03 00:00:00 | 13:10:00
B | 2011-01-03 00:00:00 | 13:54:00 | 2011-01-03 00:00:00 | 16:06:00
B | 2011-01-03 00:00:00 | 16:17:00 | 2011-01-03 00:00:00 | 16:45:00
C | 2011-01-03 00:00:00 | 06:57:00 | 2011-01-03 00:00:00 | 09:52:00
C | 2011-01-03 00:00:00 | 10:07:00 | 2011-01-03 00:00:00 | 12:42:00
C | 2011-01-03 00:00:00 | 13:27:00 | 2011-01-03 00:00:00 | 14:47:00
C | 2011-01-03 00:00:00 | 15:09:00 | 2011-01-03 00:00:00 | 15:45:00
D | 2011-01-03 00:00:00 | 08:38:00 | 2011-01-03 00:00:00 | 10:00:00
D | 2011-01-03 00:00:00 | 10:15:00 | 2011-01-03 00:00:00 | 12:19:00
D | 2011-01-03 00:00:00 | 13:10:00 | 2011-01-03 00:00:00 | 14:50:00
D | 2011-01-03 00:00:00 | 15:05:00 | 2011-01-03 00:00:00 | 17:20:00
E | 2011-01-03 00:00:00 | 08:09:00 | 2011-01-03 00:00:00 | 10:18:00
E | 2011-01-03 00:00:00 | 10:33:00 | 2011-01-03 00:00:00 | 10:57:00
E | 2011-01-03 00:00:00 | 12:03:00 | 2011-01-03 00:00:00 | 15:32:00
E | 2011-01-03 00:00:00 | 15:52:00 | 2011-01-03 00:00:00 | 17:16:00
F | 2011-01-03 00:00:00 | 06:48:00 | 2011-01-03 00:00:00 | 09:01:00
F | 2011-01-03 00:00:00 | 09:17:00 | 2011-01-03 00:00:00 | 11:03:00
F | 2011-01-03 00:00:00 | 11:46:00 | 2011-01-03 00:00:00 | 13:36:00
F | 2011-01-03 00:00:00 | 13:45:00 | 2011-01-03 00:00:00 | 15:45:00
Spreadsheet: sally_beck__35039__0417
Sheet: QTD Mgmt Summary

E N R O N   N O R T H   A M E R I C A |  |  |  |  |  |  |  |  |  |  |  | 2ND QTR 2000 EARNINGS ESTIMATE
 |  | Margin |  |  |  | Expenses |  |  |  | EBIT
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan* | [NAME] |  | Forecast | Plan | [NAME]
Gas Trading
Power Trading
Financial Drift
Financial Trading
Canada
Coal
GRM -  Weather
Emissions
GRM - New Products
Total Trading & Risk Mgt.
East Midstream
West Midstream
Industrial Downstream
Midstream IPP
Mexico
Total Origination
Generation Investments
Gas Assets
Gas Assets - Trading
Total Assets
Principal Investing
Energy Investments
CTG Assets
Total Investing
Commercial Transactions Group
Office of the Chairman
Overview
Total Commercial
Group Total |  | 0 | 0 |  |  | 0 | 0
Group Allocated to Teams |  | 0 | 0
Other Interest Related Charges
Capital Charge Offset |  | 0 | 0
ENA EBIT
Interest Expense/(Income) |  | 0 | 0
[NAME]
* Includes Capital Charge & Operating, Direct, and Allocated Expenses
Actual margin changes from: | 2000-04-07 00:00:00
Prior Week:
DPR Change:
MPR Change:
Other Margin Changes:
Total Change
This Week
Spreadsheet: 782484d1654075604-how-to-analyse-data-for-rows-not-columns-type-chart
Sheet: Sheet1

A\D | Magic | Might | Metal | Machine
Magic | 1 | 0.5 | 2 | 2
Might | 2 | 2 | 0.5 | 2
Metal | 0.5 | 2 | 0.5 | 2
Machine | 2 | 2 | 2 | 2
A/D | Normal | Fire | Water | Plant | Poision | Earth | Wicked | Divine | Amalgam | Pure
Normal | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 0.5 | 2
Fire | 1 | 2 | 2 | 2 | 2 | 0.5 | 0.5 | 1 | 0.5 | 2
Water | 1 | 2 | 1 | 1 | 2 | 2 | 0.5 | 1 | 0.5 | 2
Plant | 1 | 0.5 | 1 | 1 | 2 | 2 | 0.5 | 1 | 0.5 | 2
Poision | 1 | 0.5 | 2 | 2 | 1 | 2 | 0.5 | 1 | 0.5 | 2
Earth | 1 | 2 | 0.5 | 1 | 0.5 | 1 | 0.5 | 1 | 0.5 | 2
Wicked | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 0.5 | 2
Divine | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 0.5 | 2
Amalgam | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 2
Pure | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 0.5 | 2
Spreadsheet: 191320d1352063744-vigenere-cipher-can-encrypt-decryption-is-troublesome-book3
Sheet: Vigenere decrypt

Cipher Text | O | M | Y | X | V | R | X | X | X
Enter [NAME]: | VIGENERE
LENGTH OF KEYWORD
LENGTH OF CIPHER TEXT
 | 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 | 47 | 48 | 49 | 50
WRITE KEYWORD AS NO.
[NAME]
REMOVE NEGATIVE NUMS
DECRYPTED TEXT
Spreadsheet: 723304d1615620839-lookup-formula-to-return-sum-value-from-separate-workbook-daily-plod-tracker-test
Sheet: July

Date | Location | Program ID - if applicable | Work Type - Rehab/Clearing | Machine type | Hours | Timesheet Number | Rate | cost
 |  |  |  |  |  |  |  |  | Months Total
Spreadsheet: 779505d1651825764-how-to-transform-data-array-from-vertical-to-horizontal-layout-5f-06
Sheet: Sheet1

A | 1 |  |  | A | 1 | 6
A | 6 |  |  | B | 2 | 4 | 5
B | 2 |  |  | C | 8 | 5
B | 4 |  |  | D | 11 | 33
B | 5 |  |  | F | 22
C | 8
C | 5
D | 11
F | 22
D | 33
Spreadsheet: 877716d1724551851-formula-to-create-alert-based-on-a-key-word-telford-forklift-truck-pre-shift-inspection-checklist
Sheet: Inspections

Id | Start time | Completion time | [NAME] | Name | Date of Inspection | Inspectors Name | [NAME] | Comments | Picture (If Required) | Hydraulic [NAME] | Comments1 | Picture (If Required)1 | Hydraulic Fluid Levels1 | Comments2 | Picture (If Required)2 | Chains & Fixing Bolts | Comments3 | Picture (If Required)3 | Forks / Attachments | Comments4 | Picture (If Required)4 | Backrest / Extension | Comments5 | Picture (If Required)5 | Tyres / Wheels / Nuts | Comments6 | Picture (If Required)6 | Steering / Seat & Seat Belt | Comments7 | Picture (If Required)7 | Brakes | Comments8 | Picture (If Required)8 | Operating Controls | Comments9 | Picture (If Required)9 | Warning Lights | Comments10 | Picture (If Required)10 | Gauges / Instruments | Comments11 | Picture (If [NAME] | Lights / Beacon | Comments12 | Picture (If Required)12 | Horn / Alarms | Comments13 | Picture (If [NAME] | Safety Guards / Covers | Comments14 | Picture (If [NAME] | Bodywork / Cleanliness | Comments15 | Picture (If [NAME] | Cable Connections | Comments16 | Picture (If [NAME] | Battery Security | Comments17 | Picture (If Required)17
1 | 2024-08-23 14:54:40 | 2024-08-23 14:55:14 | anonymous |  | 2024-08-19 00:00:00 | [NAME] | OK |  |  | Repair | Hello |  | OK |  |  | Repair |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK
2 | 2024-08-23 15:04:09 | 2024-08-23 15:05:10 | anonymous |  | 2024-08-20 00:00:00 | [NAME] | OK |  |  | OK |  |  | Repair | Requires top up |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK
3 |  |  |  |  | 2024-08-21 00:00:00 |  |  |  |  | Repair
4 |  |  |  |  | 2024-08-22 00:00:00 |  |  |  |  |  |  |  | Repair | Urgent
Spreadsheet: 804287d1667987589-large-nested-if-statements-how-to-improve-test1-9-aligw
Sheet: Fees

ProcCode | ProcFeeB2C | ProcFeeB2B
0 | 0 | 0
1 | 1 | 2.25
2 | 2 | 3.25
3 | 4.5 | 4
4 | 3 | 4.25
5 | 4 | 5.25
6 | 5 | 6.25
7 | 6 | 7.25
8 | 7 | 8.25
9 | 8 | 9.25
10 | 9 | 10.25
11 | 10 | 11.25
12 | 2.5 | 12.25
Spreadsheet: 850817d1701169588-how-to-count-the-number-of-times-each-weekday-occurs-in-a-given-month-sample-file-how-many-mondays
Sheet: Sheet1

 |  |  | Nov-23 | Dec-23 | Jan-24 | Feb-24 | Mar-24 | Apr-24 | May-24 | Jun-24 | Jul-24 | Aug-24 | Sep-24 | Oct-24 | Nov-24 | Dec-24 | Jan-25 | Feb-25 | Mar-25 | Apr-25 | May-25 | Jun-25 | Jul-25 | Aug-25 | Sep-25 | Oct-25 | Nov-25 | Dec-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 | May-26 | Jun-26 | Jul-26 | Aug-26 | Sep-26 | Oct-26 | Nov-26 | Dec-26 | [NAME] | Feb-27 | Mar-27
 |  | Mondays | 4 | 4
Spreadsheet: 99715d1298308803-add-cells-in-excel-criteria-priceproductlist
Sheet: PrSales09

Product | Cost | Selling Price | jan | feb | [NAME] | apr | may | jun | jul | aug | sept | oct | nov | dec
1 | 0.5 | 0.625 | 132 | 262 | 89 | 346 | 100 | 258 | 75 | 170 | 262 | 124 | 29 | 149
2 | 4.9 | 6.125 | 294 | 58 | 164 | 255 | 348 | 275 | 327 | 326 | 331 | 345 | 309 | 46
3 | 2.87992 | 3.5999 | 70 | 40 | 162 | 228 | 289 | 155 | 133 | 297 | 260 | 306 | 110 | 281
4 | 2.87992 | 3.5999 | 340 | 142 | 100 | 136 | 56 | 243 | 247 | 273 | 231 | 34 | 115 | 89
5 | 2.75 | 3.4375 | 232 | 284 | 138 | 322 | 249 | 263 | 303 | 209 | 240 | 129 | 283 | 155
6 | 1.36 | 1.7 | 198 | 237 | 277 | 346 | 272 | 227 | 280 | 294 | 33 | 108 | 181 | 84
7 | 2.4 | 3 | 340 | 181 | 189 | 24 | 154 | 45 | 156 | 59 | 160 | 302 | 290 | 317
8 | 2.08 | 2.6 | 336 | 331 | 316 | 37 | 55 | 76 | 284 | 102 | 133 | 136 | 258 | 27
9 | 2.09 | 2.6125 | 213 | 208 | 276 | 211 | 127 | 95 | 83 | 226 | 89 | 273 | 76 | 256
10 | 3.02 | 3.775 | 180 | 270 | 267 | 238 | 153 | 263 | 129 | 165 | 90 | 279 | 211 | 240
11 | 3.99992 | 4.9999 | 256 | 37 | 294 | 125 | 128 | 189 | 94 | 272 | 327 | 276 | 178 | 165
12 | 4.8 | 6 | 261 | 26 | 175 | 39 | 273 | 194 | 152 | 56 | 241 | 266 | 178 | 281
13 | 1.12 | 1.4 | 338 | 83 | 196 | 207 | 49 | 288 | 111 | 148 | 139 | 340 | 113 | 235
14 | 1.24 | 1.55 | 48 | 32 | 173 | 163 | 67 | 135 | 300 | 86 | 241 | 331 | 211 | 324
15 | 1.4 | 1.75 | 47 | 41 | 72 | 117 | 132 | 107 | 298 | 314 | 333 | 348 | 126 | 311
16 | 1.44 | 1.8 | 341 | 227 | 55 | 137 | 229 | 94 | 302 | 121 | 342 | 313 | 110 | 260
17 | 3.2 | 4 | 317 | 210 | 189 | 149 | 350 | 49 | 82 | 347 | 112 | 86 | 276 | 124
18 | 1.24 | 1.55 | 199 | 38 | 48 | 263 | 255 | 87 | 65 | 38 | 107 | 238 | 337 | 80
19 | 1.68 | 2.1 | 276 | 217 | 216 | 272 | 299 | 91 | 147 | 304 | 231 | 223 | 308 | 249
20 | 1.8 | 2.25 | 190 | 43 | 69 | 39 | 138 | 76 | 304 | 293 | 265 | 141 | 341 | 280
21 | 1.96 | 2.45 | 89 | 200 | 69 | 265 | 147 | 350 | 50 | 293 | 188 | 310 | 289 | 247
22 | 2.04 | 2.55 | 279 | 288 | 73 | 227 | 102 | 179 | 59 | 233 | 236 | 27 | 177 | 84
23 | 1.68 | 2.1 | 308 | 65 | 125 | 332 | 297 | 55 | 167 | 309 | 172 | 273 | 294 | 110
24 | 3.4 | 4.25 | 139 | 104 | 66 | 109 | 173 | 291 | 271 | 66 | 256 | 79 | 340 | 24
Spreadsheet: 839431d1691980472-creation-of-a-parts-ordering-program-sunday-13082023-1150am
Sheet: CLASS A

BOARD NA-06354 | CLASS A SW |  |  |  |  |  |  |  |  |  | Mouser
PART # [NAME] | TEST RESULT | NEW PART # | COST EACH | VENDOR | VENDOR PART NUMBER |  |  |  |  | VENDOR PART NUMBER | COST EACH | QTY | TOTAL |  |  | VENDOR PART NUMBER | COST EACH | QTY | TOTAL
MICRO SWITCH 1 |  |  | 6.26 | MOUSER | 653-V-21-1C6 |  |  |  | MOUSER | 653-V-21-1C6 | 6.26 | 2 | 12.52 |  | MOUSER | 653-V-21-1C6 | 6.26 | 2 | 12.52
MICRO SWITCH 2 |  |  | 6.26 | MOUSER | 653-V-21-1C6
SOLDER |  | CARDAS QUAD CORE | 10.5
WIRE |  | BNTECHGO | 5.08
[NAME] | 6ea | TBD
CLEANING SUPPLIES |  |  | 10 | [NAME]
SHIPPING |  | TBD
Spreadsheet: 484809d1476457548-calculate-intakes-by-month-casse_massagno
Sheet: Kueng

NEW SUN (Massagno) |  |  | WOCHE |  |  | VON |  |  | BIS
DATUM |  | 1 1100 | 2 1100 | 3 600 | 4 900 | 5 900 | TOTAL COINS | Notes | Left | Net takings
 | 2016-10-03 00:00:00
week
 | % |  |  |  |  |  | + | Sun creams
 |  |  |  |  |  |  | - | Expenses
 |  |  |  |  |  |  |  | TOTAL DEPOSIT
 | List of expenses:
 | 2016-10-03 00:00:00 | Calc detergent |  |  |  | 3.9
Spreadsheet: 853114d1703057274-how-to-get-a-specific-result-using-if-formula-based-on-multiple-conditions-form-2-2-
Sheet:  Decommissioning Request Form

 |  |  |  |  |  | =IF(AND(COUNTA($C$5:$C$7)=3,$C$9<>"",$C$14<>"",$C$22<>"",$C$30<>"",COUNTA($C$33:$D$34)=4),1,0)
 |  |  |  |  |  | =IF(AND(LEN($C$10)=14,ISNUMBER($C$10+0)),1,0)
 |  |  |  |  |  | =IF(OR(AND($C$6="USA",$C$11<>""),AND($C$6<>"USA",$C$11="")),1,0)
To Be Completed by Requestor | Decommissioning Product | Enter Product Details |  |  |  | =IF(AND(C14="Partial Batch Decommissioning",C20<>"",E42="QUANTITY MATCH"),1,0)
 | Supply Site or Market Warehouse or LOC | GSK |  |  |  | =iF(AND(B19="SGTIN Level",C19<>""),1,0)
 | Market (Lead Market) | Sweden |  |  |  | =IF(AND(B19="Case Level",COUNT(C19:D19)=2),1,0)
 | Batch (Lot Number) | ASDFGH |  |  |  | =IF(AND(B19="Pallet [NAME])
 | SKU Code | 60987654789876 |  |  |  | =IF(AND(B19="Cases + Pallets",COUNT(D19,E19)=2),1,0)
 | SKU Description | PANADOL |  |  |  | =IF(AND(B19="SGTIN + Cases",COUNT(C19,D19)=2),1,0)
 | GTIN | 03456789876544 |  |  |  | =IF(AND(B19="SGTIN + Pallets",COUNT(C19,E19)=2),1,0)
 | Case GTIN (for US Market Only) |  |  |  |  | ,=IF(AND(B19="SGTIN + Cases + Pallets",COUNT(C19:E19)=3),1,0)
 | Types of Decommissioning | Choose Type of Decommissioning
 | [NAME] with Rework | Partial Batch Decommissioning
 | [NAME] without Rework
 | Partial Batch Decommissioning
 | Choose Decommissioning Level | Enter SGTIN Quantity | Enter Case Quantity | Enter Pallet Quantity
 | SGTIN Level | 3 | 1
 | Decommissioning Reason Codes | Choose Reason Code for Decommissioning |  | Description
 | FREE SAMPLE | DESTROYED
 | SAMPLE
 | DESTROYED
 | SUPPLIED
 | EXPORTED
 | OTHERS
 | [NAME]
 | RECALL
 | Decommissioning Comments (if any) | N/A
 | Role | MUD ID | Name
 | Data Provider | X | A
 | Quality Approver | X | B
 | SUMMARY |  |  | DRF Completion Status  (For details, refer row 20 in Instructions sheet)
To Be Completed by Requestor | Quantity of Serial Number/SGTINs Entered | Quantity of Cases Entered | Quantity of Pallets Entered | Verification: (For details, refer row 23 in Instructions sheet)
 | Enter Serial numbers / SGTINs to be decommissioned | Enter Case numbers (SGTINs / SSCCs) to be decommissioned | Enter [NAME] numbers (SSCCs) to be decommissioned
 | 17678987654345 | 1
 | 222
Spreadsheet: 834513d1687879511-compare-dynamic-arrays-spot-missing-items-compare-tables
Sheet: Feuil1

please ignore
table1 |  |  | table1 |  |  | expected result
test1 | a |  |  | a |  | UNKNOWN: test2/b, test3/j
test2 | b |  | test2 | b
test3 | j |  | test3 | j
table2 |  |  | table2
test2 | d,e,f |  |  | d,e,f
test1 | a,b,c |  | test1 | a,b,c
test3 | g,h,i |  | test3 | g,h,i
Spreadsheet: 154819d1336573572-pulling-two-lists-into-one-and-showing-duplicates-refren
Sheet: Jobs List

 | <--- Press this ONLY if NEW data is put into [NAME]! |  |  |  | Green = A Day or More Till Due Date                       Yellow = Due that Day                              Red = Late! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jobs List
 | SO # | Customer | Part  # | Description | Fulfillment Date | Needed | On Hand | Short | Days Till | Days Late | Priority | NCMR | Remarks
 | 34043 R03/16 | Dakota Systems, Inc. | K17013411 rev A | Post, Lock Replenishing Shelf | 2011-03-16 00:00:00 | 1 | 0 | 1
 | 34153 | Dakota Systems, Inc. | K40202739 | HDPE STORAGE CART, 300MM | 2011-03-23 00:00:00 | 4 | 0 | 4
 | 36077 | Nexx Systems, Inc. | K11200811 Rev A | ASSY, OUTPUT-DRAIN, MANIFOLD, RH | 2012-05-07 00:00:00 | 6 | 0 | 6
 | 36161 R05/07 | Nexx Systems, Inc. | K11200811 Rev A | ASSY, OUTPUT-DRAIN, MANIFOLD, RH | 2012-05-07 00:00:00 | 4 | 0 | 4
 | 34819 | Dakota Systems, Inc. | K17211132 Rev A | Cover, Edge, Anti-Drip, S300 Process Frame | 2011-08-11 00:00:00 | 1 | 0 | 1
 | 34964 | Dakota Systems, Inc. | Expedite Fee | Special Order - RUSH | 2011-08-25 00:00:00 | 1 | 0 | 1
 | 34516 | Dakota Systems, Inc. | K17203266 Rev A | PVDF Plate, Mounting, [NAME] | 2011-12-30 00:00:00 | 10 | 7 | 3
 | 34516 | Dakota Systems, Inc. | K17203253 [NAME] | Weld, PVDF Filter & Replenish Short | 2011-12-30 00:00:00 | 10 | 0 | 10
 | 34408 | Dakota Systems, Inc. | [NAME] Rev. B | Weldment, Filter & Replenishing Short, Stratus 200 | 2011-12-30 00:00:00 | 5 | 36
Spreadsheet: 774946d1648734550-help-with-sorting-alphabetically-by-row-and-keeping-data-on-other-tabs-saddle-creek-daily-attendance
Sheet: 2nd Q

[NAME], 2nd Quarter
 |  |  |  |  |  |  |  |  | CONFIDENTIAL
Employee Name | Worked Shifts | Excused | Late | Early Out | Call Out | Sick | NCNS | 4/1 | 4/2 | 4/3 | 4/4 | 4/5 | 4/6 | 4/7 | 4/8 | 4/9 | 4/10 | 4/11 | 4/12 | 4/13 | 4/14 | 4/15 | 4/16 | 4/17 | 4/18 | 4/19 | 4/20 | 4/21 | 4/22 | 4/23 | 4/24 | 4/25 | 4/26 | 4/27 | 4/28 | 4/29 | 4/30 | 5/1 | 5/2 | 5/3 | 5/4 | 5/5 | 5/6 | 5/7 | 5/8 | 5/9 | 5/10 | 5/11 | 5/12 | 5/13 | 5/14 | 5/15 | 5/16 | 5/17 | 5/18 | 5/19 | 5/20 | 5/21 | 5/22 | 5/23 | 5/24 | 5/25 | 5/26 | 5/27 | 5/28 | 5/29 | 5/30 | 5/31 | 6/1 | 6/2 | 6/3 | 6/4 | 6/5 | 6/6 | 6/7 | 6/8 | 6/9 | 6/10 | 6/11 | 6/12 | 6/13 | 6/14 | 6/15 | 6/16 | 6/17 | 6/18 | 6/19 | 6/20 | 6/21 | 6/22 | 6/23 | 6/24 | 6/25 | 6/26 | 6/27 | 6/28 | 6/29 | 6/30
Spreadsheet: 96016d1295494432-consolidation-of-multiple-columns-via-one-lookup-example
Sheet: Sheet1

Date | EMP_FIRST_NAME | PRJ_1 | PRJ_1_HRS | PRJ_2 | PRJ_2_HRS | PRJ_3 | PRJ_3_HRS |  | The name below can change to another rep eg. [NAME]
2011-01-07 00:00:00 | DANIEL |  |  |  |  |  |  |  | [NAME] | AAA | BBB | CCC | DDD
2011-01-08 00:00:00 | DANIEL |  |  |  |  |  |  |  | 2011-01-07 00:00:00
2011-01-09 00:00:00 | DANIEL |  |  |  |  |  |  |  | 2011-01-08 00:00:00
2011-01-10 00:00:00 | DANIEL |  |  |  |  |  |  |  | 2011-01-09 00:00:00
2011-01-11 00:00:00 | DANIEL | BBB | 4 | AAA | 2 | CCC | 1.5 |  | 2011-01-10 00:00:00
2011-01-12 00:00:00 | DANIEL | AAA | 5 |  |  |  |  |  | 2011-01-11 00:00:00 | 2 | 4 | 1.5
2011-01-13 00:00:00 | DANIEL | AAA | 2 |  |  |  |  |  | 2011-01-12 00:00:00 | 5
2011-01-14 00:00:00 | DANIEL |  |  |  |  |  |  |  | 2011-01-13 00:00:00 | 2
2011-01-15 00:00:00 | DANIEL |  |  |  |  |  |  |  | 2011-01-14 00:00:00
2011-01-16 00:00:00 | DANIEL |  |  |  |  |  |  |  | 2011-01-15 00:00:00
2011-01-17 00:00:00 | DANIEL | AAA | 5 |  |  |  |  |  | 2011-01-16 00:00:00
2011-01-18 00:00:00 | DANIEL | BBB | 5 |  |  |  |  |  | 2011-01-17 00:00:00 | 5
2011-01-19 00:00:00 | DANIEL | CCC | 5 |  |  |  |  |  | 2011-01-18 00:00:00 |  | 5
2011-01-20 00:00:00 | DANIEL | AAA | 5 |  |  |  |  |  | 2011-01-19 00:00:00 |  |  | 5
2011-01-07 00:00:00 | [NAME] |  |  |  |  |  |  |  | 2011-01-20 00:00:00 | 5
2011-01-08 00:00:00 | [NAME] |  |  |  |  |  |  |  | Summary Table - I have manually added in what the results should be.
2011-01-09 00:00:00 | [NAME]
2011-01-10 00:00:00 | [NAME] |  |  |  |  |  |  |  | [NAME] | AAA | BBB | CCC | DDD
2011-01-11 00:00:00 | [NAME] |  |  |  |  |  |  |  | 2011-01-07 00:00:00
2011-01-12 00:00:00 | [NAME] |  |  |  |  |  |  |  | 2011-01-08 00:00:00
2011-01-13 00:00:00 | [NAME] |  |  |  |  |  |  |  | 2011-01-09 00:00:00
2011-01-14 00:00:00 | [NAME] | AAA | 5 |  |  |  |  |  | 2011-01-10 00:00:00
2011-01-15 00:00:00 | [NAME] | AAA | 5 | CCC | 2 |  |  |  | 2011-01-11 00:00:00
2011-01-16 00:00:00 | [NAME] | AAA | 5 |  |  |  |  |  | 2011-01-12 00:00:00
2011-01-17 00:00:00 | [NAME] | AAA | 5 |  |  |  |  |  | 2011-01-13 00:00:00
2011-01-18 00:00:00 | [NAME] |  |  |  |  |  |  |  | 2011-01-14 00:00:00 | 5 |  | 2
2011-01-19 00:00:00 | [NAME] |  |  |  |  |  |  |  | 2011-01-15 00:00:00 | 5
2011-01-20 00:00:00 | [NAME] |  |  |  |  |  |  |  | 2011-01-16 00:00:00 | 5
 | Data Source - AAA, BBB, CCC are the codes for the various projects. |  |  |  |  |  |  |  | 2011-01-17 00:00:00 | 5
 |  |  |  |  |  |  |  |  | 2011-01-18 00:00:00
 |  |  |  |  |  |  |  |  | 2011-01-19 00:00:00
 |  |  |  |  |  |  |  |  | 2011-01-20 00:00:00
 |  |  |  |  |  |  |  |  | This is the same summary table as above, but a different name ([NAME]) has been entered.