tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 851329d2-9772-4b84-8b21-4119ee1323de
Sheet: Sheet1

الأمم المتحدة | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
اللجنة الاقتصادية والاجتماعية لغربي آسيا
UNITED NATIONS |  | NATIONS UNIES
Economic and Social Commission for Western Asia ESCWA |  | Commission économique et sociale pour l’Asie occidentale
FAX: (961-1) 981510 - TEL: (961-1) 981301, 981311, 981401
[NAME]  11-8575 - Beirut, lebanon
UN ESCWA QUESTIONNAIRE ON |  | استبيان اللجنة الاقتصادية والاجتماعية لغربي [NAME] (إسكوا) حول
SECTORAL  STATISTICS /Section Environment |  | الاحصاءات القطاعية  / جزء البيئة
In collaboration with UNSD and UNEP/ROWA |  | بالتعاون مع شعبة الاحصاء بالامم المتحدة (UNSD) وبرنامج الامم [NAME] (UNEP )
Year: 2006 |  | السنة 2006
Please fill the information and questionnaire and return to: |  | الرجاء تعبئة المعلومات وتكملة الاستبيان المرافق واعادته  الى:
Economic and Social Commission for Western Asia (ESCWA) |  | اللجنة الاقتصادية والاجتماعية لغربي [NAME] (إسكوا)
FAX: (961-1) 981510 |  | [NAME]:  981510 1 (961)
Address:  [NAME]   11-8575 |  | العنوان: ص. ب  8575 11
Beirut, Lebanon |  | بيروت, لبنان
Replying Country: |  | الدولة المجيبة:
Replying office |  | المكتب المجيب:
Contact person : |  | اسم  الموظف :
Official Position |  | [NAME]:
Address |  | [NAME] الدائم:
Tel: |  | [NAME] :
Fax |  | [NAME]:
email: |  | البريد الإلكتروني:
For information, Contact  WAFA ABOUL HOSN, |  | للاستفسار الرجاء الاتصال ب: وفاء ابو الحسن
Official Position:   Team Leader,  Sectoral Statistics |  | [NAME]: رئيس فريق - الاحصاءات القطاعية
TEL:   961-1- 978-519 |  | [NAME]  978519  1 (961 )
FAX: (961-1) 981510 |  | [NAME]: 981510 1  (961)
email:  [EMAIL] |  | البريد الإلكتروني:  [EMAIL]
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 136208 | 142148
2 | 91841 | 120259
3 | 95240 | 97445
4 | 116769 | 114074
5 | 108530 | 114453
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-07-31 00:00:00 |  |  | 54872
2001-08-05 00:00:00
CBS Dollars
 |  |  | 411725
Spreadsheet: 718029d1612959200-how-to-extract-values-from-excel-into-outlook-outlook-picking-data-from-excel
Sheet: Sheet1

ID | NAME | [NAME]
1000156845 | [NAME]
1000157739 | [NAME]
1000156419 | LEO
1000157086 | UCHE
1000157745 | FRANK
110151143 | VICTOR
1000157321 | ANGEL
1000157159 | AUGUSTINE
1000156474 | ATHAN
1000156544 | LION
Spreadsheet: 840237d1692602125-extract-data-using-vlookup-sample
Sheet: Sheet1

S/N | MOBILE | SIM NUMBER | VEHICLE PLATE NUMBER | REGION / PLACE | PAGE | Serial NUMBER
1 | NA | 1009184017141 | 551 | NA | NA | 8921101009184017141
2 | NA | 1009184017158 |  | NA | NA | 8921101009184017158
3 | NA | 1009184017166 | 2788 | NA | NA | 8921101009184017166
4 | NA | 1009184017174 | 8291 | NA | NA | 8921101009184017174
5 | NA | 1009184017182 | 75064 | NA | NA | 8921101009184017182
6 | NA | 1009184017190 | 27289 | NA | NA | 8921101009184017190
7 | NA | 1009184017208 | 75049 | NA | NA | 8921101009184017208
8 | NA | 1009184017216 | 154 | NA | NA | 8921101009184017216 | 00154
9 | NA | 1009184017224 | 8245 | NA | NA | 8921101009184017224
10 | NA | 1009184017232 | 75052 | NA | NA | 8921101009184017232
11 | NA | 1009184017240 | 75075 | NA | NA | 8921101009184017240
12 | NA | 1009184017257 | 28113 | NA | NA | 8921101009184017257
13 | NA | 1009184017265 | 25387 | NA | NA | 8921101009184017265
14 | NA | 1009184017273 | 1582 | NA | NA | 8921101009184017273 | 01582
15 | NA | 1009184017281 | 5154 | NA | NA | 8921101009184017281
Spreadsheet: 103348d1301078246-sumifs-sumifs_sample
Sheet: Master

ISE |  | SE | ISE/SE | SM/DSM | SM/GM/DSM
Training Dates
ISE Training | Training City | SE Training | Training City | DSM Training | Training City
 |  | 2010-11-15 00:00:00 | Philadelphia
 |  |  |  | 2010-06-01 00:00:00
 |  | 2010-03-15 00:00:00
 |  | 2010-08-01 00:00:00
 |  | 2010-11-10 00:00:00
2010-02-01 00:00:00
 |  | 2010-11-10 00:00:00
 |  | 2010-03-15 00:00:00
 |  | 2010-06-22 00:00:00 |  | 2010-06-01 00:00:00
 |  | 2010-06-22 00:00:00
2010-02-01 00:00:00
 |  | 2010-05-01 00:00:00
 |  |  |  | 2010-06-01 00:00:00
 |  | 2011-02-22 00:00:00
 |  | 2010-11-15 00:00:00
 |  | 2010-08-01 00:00:00
 |  | 2010-06-15 00:00:00
 |  | 2010-06-15 00:00:00
 |  | 2010-11-10 00:00:00
Spreadsheet: 3bb20dce-5395-46db-b6c8-bb864f5bd7a7
Sheet: Central Stores Order Form

KIBSD |  | Central Stores Order
Phone 481-2283
Fax 481-6108
Please email form to: |  | [NAME]
SITE/ORDERED BY |  | ACCOUNT NUMBER | DELIVERY TO:
QTY | ITEM # | [NAME] | UNIT PRICE | LINE TOTAL
 |  |  | TOTAL
 |  |  |  | Date
Spreadsheet: 693643d1599066403-mmult-with-non-adjacent-discontinuous-columns-sample-dataset
Sheet: Sheet1

 |  | Asset allocation
 |  | Product 1 | Product 2 | Product 3 | Product 4
 | Stock 1 | 0.5 | 0.05 | 0.15 | 0.1
 | Stock 2 | 0.1 | 0.2 | 0.15 | 0.1
 | Stock 3 | 0.1 | 0.15 | 0.15 | 0.1
 | Stock 4 | 0.2 | 0.1 | 0.15 | 0.1
 | Stock 5 | 0.1 | 0 | 0.05 | 0.1
 | Stock 6 | 0 | 0 | 0.05 | 0.1
 | Stock 7 | 0 | 0 | 0.05 | 0.1
 | Stock 8 | 0 | 0.05 | 0.05 | 0.1
 | Stock 9 | 0 | 0.1 | 0.1 | 0.1
 | Stock 10 | 0 | 0.35 | 0.1 | 0.1
 |  | Investor A's portfolio
 |  | Product 1 | Product 3 | Product 4
 |  | 0.25 | 0.5 | 0.25
 |  |  | <-- Incorrect result, because it includes product 2 but not product 4
 |  | 0.225 | <-- Correct result
Spreadsheet: 118047d1313401513-percentage-test
Sheet: Retail

Business Area | Month | Anual Ref Value | Savings
Retail | 2011-01-01 00:00:00 | 0 | 0
Retail | 2011-01-01 00:00:00 | 76287.7030162413 | 0
Retail | 2011-01-01 00:00:00 | 160556.8445475638 | 0
Retail | 2011-01-01 00:00:00 | 30751.29930394431 | 0
Retail | 2011-01-01 00:00:00 | 3010440.835266822 | 949840
Retail | 2011-01-01 00:00:00 | 63336.42691415313 | 0
Spreadsheet: 865331d1712351645-repeat-character-based-on-value-in-adjacent-cell-repeat-cells-based-on-value-in-adjacent-column-excelforum
Sheet: Sheet1

 | A | 2 |  | A | 1 |  |  | 1
 | B | 3 |  | A | 2 |  | A | 2
 | C | 4 |  | B | 1 |  | B | 1
 |  |  |  | B | 2 |  | B | 2
 |  |  |  | B | 3 |  | B | 3
 |  |  |  | C | 1 |  | C | 1
 |  |  |  | C | 2 |  | C | 2
 |  |  |  | C | 3 |  | C | 3
 |  |  |  | C | 4 |  | C | 4
Spreadsheet: kate_symes__18643__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-14 00:00:00 |  | 319.81 | 40656 | 284.13 | 14112
 | 2001-02-13 00:00:00 |  | 284.75 | 33888 | 247.23 | 14448
 | 2001-02-12 00:00:00 |  | 252.44 | 33552 | 233.02 | 14640
 | 2001-02-11 00:00:00 |  |  |  |  |  | 233.02 | 43920
 | 2001-02-10 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-09 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-08 00:00:00 |  | 274.83 | 37456 | 223.07 | 17808
 | 2001-02-07 00:00:00 |  | 251 | 44352 | 218.57 | 14240
 | 2001-02-06 00:00:00 |  | 201.06 | 29952 | 192.99 | 12024
 | 2001-02-05 00:00:00 |  | 180.21 | 10352 | 164.84 | 1008
 | 2001-02-04 00:00:00 |  |  |  |  |  | 166.31 | 4200
 | 2001-02-03 00:00:00 |  | 211.99 | 15456 | 193.3 | 7832
 | 2001-02-02 00:00:00 |  | 215.28 | 26256 | 190.89 | 11032
 | 2001-02-01 00:00:00 |  | 280.34 | 28432 | 276.27 | 13400
 | 2001-01-31 00:00:00 |  | 333.27 | 24800 | 306.35 | 12400
 | 2001-01-30 00:00:00 |  | 314.59 | 22400 | 287.77 | 12784
 | 2001-01-29 00:00:00 |  | 286.67 | 15600 | 277.58 | 9504
 | 2001-01-28 00:00:00 |  |  |  |  |  | 278.94 | 33912
 | 2001-01-27 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-26 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-25 00:00:00 |  | 264 | 18800 | 197.99 | 8440
 | 2001-01-24 00:00:00 |  | 272.42 | 7920 | 181.28 | 4440
 | 2001-01-23 00:00:00 |  | 281.71 | 13600 | 186.9 | 3680
 | 2001-01-22 00:00:00 |  | 320.08 | 14960 | 201.71 | 5240
 | 2001-01-21 00:00:00 |  |  |  |  |  | 235 | 29400
 | 2001-01-20 00:00:00 |  | 506.48 | 4320 | 236.31 | 8400
 | 2001-01-19 00:00:00 |  | 505.66 | 4384 | 247.42 | 5032
 | 2001-01-18 00:00:00 |  | 429.29 | 7920 | 278.82 | 6440
 | 2001-01-17 00:00:00 |  | 252.4 | 8000 | 204.13 | 4600
 | 2001-01-16 00:00:00 |  | 186.75 | 10720 | 158.7 | 4400
 | 2001-01-15 00:00:00 |  | 186.75 | 10720 | 158.7 | 4400
Spreadsheet: 135885d1326293144-change-shape-of-data-in-excel-sample
Sheet: Finished

 | Code | Sizes
 | 01927 | 14 | 14.5 | 15 | 15.5 | 16 | 16.5 | 17 | 17.5 | 18 | 18.5 | 19 | 19.5
 | 02504 | 14 | 14.5 | 15 | 15.5 | 16 | 16.5 | 17 | 17.5 | 18 | 18.5 | 19 | 19.5
 | 02642 | L | M | S | XL | XXL | XXXL
 | 02940 | L | M | XL | XXL
 | 03298 | 14 | 14.5 | 15 | 15.5 | 16 | 16.5 | 17 | 17.5 | 18 | 18.5 | 19 | 19.5 | 20 | 21 | 22
 | 03457 | 13 | 14 | 14.5 | 15 | 15.5 | 16 | 16.5 | 17 | 17.5 | 18 | 18.5 | 19 | 19.5 | 21 | 21.5 | 22 | SPEC
Spreadsheet: 859479d1707847463-combining-unique-value-search-within-a-countif-search-unique-count-etaf
Sheet: Sheet1

 |  |  |  |  | 3 because A as a blank is counted as 1 unique value
a | open
a | closed
a | open
b | closed
b | open
b | closed
c | closed
c | closed
 | open
 | open
Spreadsheet: 870602d1717083711-if-refund-then-lookup-corresponding-order-in-same-table-and-return-a-fee-value-refund-order-table-example
Sheet: Sheet1

 |  |  | Type | ID | SKU | Quantity | Sales | Shipping Credits | Handling Fees | Service Fees
 |  |  | Order | 1234 | ABCD | 1 | 24.98 | 8.56 | 0 | =IF([@Type]="order",if([@[Handling Fees]]<0,([@[Handling Fees]]+[@[Shipping Credits]])/[@Quantity],IF(AND([@[Handling Fees]]=0,[@[Shipping Credits]]=0),-3.98,0)),IF(AND([@Type]="Refund",[@[Shipping Credits]]=0),?????XLOOKUP(1,([Type]="Order")*([ID]=[@ID])*([SKU]=[@SKU]),????
 |  |  | Refund | 1234 | ABCD | 1 | -24.98 | 0 | 0
 |  |  | Order | 1234 | MNOP | 1 | 36 | 4 | 0
 |  |  | Order | 1234 | NOPQ | 1 | 14 | 0 | 0
 |  |  | Order | 2345 | BCDE | 1 | 84.99 | 11.57 | 0
 |  |  | Refund | 2345 | BCDE | 1 | -84.99 | 0 | 0
 |  |  | Order | 3456 | CDEF | 1 | 119.99 | 12.75 | -21.22
 |  |  | Refund | 3456 | CDEF | 1 | -119.99 | -12.75 | 12.75
 |  |  | Order | 3456 | JKLM | 1 | 40 | 3.98 | 6
 |  |  | Order | 4567 | DEFG | 1 | 75.91 | 9.18 | 0
 |  |  | Refund | 4567 | DEFG | 1 | -75.91 | 0 | 0
 |  |  | Order | 5678 | HIJK | 101 | 3731.95 | 0 | 0
 |  |  | Refund | 5678 | HIJK | 4 | -147.8 | 0 | 0
 |  |  | IF its an order then if its Handling Fees < 0 then (Handling Fees + Shipping Credits)/quantity, if not then if [NAME] fees are zero and shipping fees are 0 then -$3.98 is the charge, if they aren't then $0
 |  | Order
 | IF
 |  | Refund | IF it a refund AND shipping credits = 0 then we need to find the corresponding "order" by matching SKU and ID and if for that matching "order" Shipping credits < 0 then the Service fee refund would be $0, in all other cases the service refund would be the opposite of the service fee charged for the corresponding order
Spreadsheet: f7ae9708-9b0b-4103-a10c-46b71308ef7c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4347 | 15293 | Remy | Rampteau | FRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00
Spreadsheet: 761958d1641314810-add-new-event-if-it-doesnt-exist-budgettracker-tunitime-
Sheet: Budget

 | BUDGET | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00
INCOME
Spreadsheet: 85904d1285900298-combine-two-rows-of-data-into-one-row-row_combine
Sheet: end result

413 | 09/19/10 | 06:00:00 | PM | user1 | [423] | [NAME] | Corporate Challenge - September | 10 | 10 | 1 | 5
414 | 09/19/10 | 06:17:00 | PM | user2 | [424] | [NAME] | Corporate Challenge - September | 10 | 10 | 1 | 5
416 | 09/20/10 | 08:36:00 | AM | user3 | [118] | [NAME] | Corporate Challenge - September | 10 | 10 | 1 | 5
433 | 09/27/10 | 12:11:00 | PM | user4 | [438] | [NAME] | Corporate Challenge - September | 10 | 10 | 1 | 5
Spreadsheet: chris_germany__1860__Enron Supply -TGP
Sheet: Tenn

TGP SUPPLY FROM ENRON
From:  [NAME]  [PHONE]
To:  [NAME] ([EMAIL])
Phone:   [PHONE]  clarissa
Phone:  [PHONE]  [NAME]
Fax:   [PHONE]
 |  | Tennessee
LDC | MTR # | CONTRACT #
 |  |  | 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 | TOTAL
Bay State | 020193 |  | 31
Berkshire | 020292 |  | 50
Boston | 020118 |  | 75
Ct. Natural | 020205 |  | 25
No. Utilities | 020206 |  | 353
So. Conn. | 020126 |  | 1200
Yankee | 020125 |  | 10
Yankee | 020127 |  | 10
Spreadsheet: 878416d1725479303-formula-multiple-criteria-with-date-range-and-adding-sample
Sheet: Sheet1

USERTYPE | First Name | Last Name | Middle Name | Full Name | UserID | OfflineFlag | Tran DateTime | Post DateTime | Account Number | Account Type Name | [NAME] | ConvertedTran Amount | Card Number
TypeA | First1 | Last1 | Mi1 | First 1 Last 1 | 123456 | T | 2024-01-10 00:00:00 | 2024-01-20 00:00:00 | 2371 | SVACC | -200 | 200 | 123456
TypeA | First1 | Last1 | Mi1 | First 1 Last 1 | 123456 | F | 2024-02-24 00:00:00 | 2024-02-24 00:00:00 | 2371 | SVACC | 4 |  | 123456
TypeA | First1 | Last1 | Mi1 | First 1 Last 1 | 123456 | T | 2024-03-20 00:00:00 | 2024-04-20 00:00:00 | 2371 | SVACC | 10 |  | 123456
TypeA | First1 | Last1 | Mi1 | First 1 Last 1 | 123456 | T | 2024-01-10 00:00:00 | 2024-04-20 00:00:00 | 2371 | SVACC | 5 |  | 123456
TypeA | First2 | Last2 | Mi2 | First 2 Last 2 | 2587441 | T | 2024-02-24 00:00:00 | 2024-04-20 00:00:00 | 2371 | SVACC | 6 |  | 123456
TypeA | First1 | Last1 | Mi1 | First 1 Last 1 | 123456 | T | 2024-03-20 00:00:00 | 2024-04-20 00:00:00 | 2371 | SVACC | 97 |  | 123456
TypeA | First1 | Last1 | Mi1 | First 1 Last 1 | 123456 | F | 2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 2371 | SVACC | 5 |  | 123456
TypeA | First2 | Last2 | Mi2 | First 2 Last 2 | 2587441 | F | 2024-02-24 00:00:00 | 2024-02-24 00:00:00 | 2371 | SVACC | 7 |  | 123456
TypeA | First1 | Last1 | Mi1 | First 1 Last 1 | 123456 | F | 2024-03-20 00:00:00 | 2024-03-20 00:00:00 | 2371 | SVACC | 7 |  | 123456
TypeA | First1 | Last1 | Mi1 | First 1 Last 1 | 123456 | F | 2024-03-20 00:00:00 | 2024-03-20 00:00:00 | 2371 | SVACC | 88 |  | 123456
TypeA | First2 | Last2 | Mi2 | First 2 Last 2 | 2587441 | F | 2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 2371 | SVACC | 7 |  | 2587441
TypeA | First3 | [NAME] | Mi3 | First 3 Last 3 | 159753 | F | 2024-02-24 00:00:00 | 2024-02-24 00:00:00 | 2371 | SVACC | 5 |  | 159753
TypeA | First5 | Last5 | Mi5 | First 5 Last 5 | 1558543 | F | 2024-03-20 00:00:00 | 2024-03-20 00:00:00 | 2371 | SVACC | 15 |  | 111555
TypeA | First5 | Last5 | Mi5 | First 5 Last 5 | 1558543 | T | 2024-03-20 00:00:00 | 2024-04-20 00:00:00 | 2371 | SVACC | 23 |  | 1558543
TypeA | First6 | Last6 | Mi6 | First 6 Last 6 | 4654655 | T | 2024-01-10 00:00:00 | 2024-01-20 00:00:00 | 2371 | SVACC | -100 |  | 4654655
TypeA | First5 | Last5 | Mi5 | First 5 Last 5 | 1558543 | T | 2024-02-24 00:00:00 | 2024-04-20 00:00:00 | 2371 | SVACC | 12 |  | 12313218
TypeA | First5 | Last5 | Mi5 | First 5 Last 5 | 1558543 | T | 2024-03-20 00:00:00 | 2024-04-20 00:00:00 | 2371 | SVACC | 58 |  | 11255448
TypeA | First9 | [NAME] | Mi9 | First 9 Last 9 | 9877582 | T | 2024-03-20 00:00:00 | 2024-04-20 00:00:00 | 2371 | SVACC | 15 |  | 9877582
TypeA | First3 | [NAME] | Mi3 | First 3 Last 3 | 159753 | F | 2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 2371 | SVACC | 9 |  | 121212121
TypeA | First3 | [NAME] | Mi3 | First 3 Last 3 | 159753 | F | 2024-02-24 00:00:00 | 2024-02-24 00:00:00 | 2371 | SVACC | 7 |  | 121212121
Spreadsheet: 763111d1641996930-count-based-on-entry-uk-prod-lt-holiday-calendar-2022-copy-v-2
Sheet: Feb 22

 | Absence Type Key | V | Vacation |  |  | H | Public Holiday |  |  | S | Sick |  | ML/PL | Maternity/ Paternity leave |  |  | BD | Birthday |  |  | T | Training
 | 2022-02-01 00:00:00 | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022
 |  | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon
 | Employee Name | 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 | Total Days | V | H | S | ML/PL | BD | T
 | [NAME] | V |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | T | T | T
 | Fran |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V | V | V | V | V
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V | V
 | Jo
 | Maria
 | Mark
 | Michelle
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Zak | V | V
Spreadsheet: 853553d1703420232-retrieving-and-moving-transferring-data-glenn-new-problem-1-
Sheet: Wk1

1
Spreadsheet: 741236d1626929093-calculating-tenure-based-on-start-date-and-end-date-calculating-tenure-based-on-start-date-and-end-date
Sheet: Sheet2

Employee number | Department | Job Title | Start date | Departure Date | Termination Reason
185 | Marketing | Events Coordinator | 2017-10-19 00:00:00 | 2020-02-07 00:00:00 | Voluntary - Higher Compensation
148 | Customer Solutions | Business Analyst | 2017-06-04 00:00:00 | 2019-03-19 00:00:00 | Voluntary - Higher Compensation
114 | Customer Solutions | Senior [NAME] Manager | 2019-11-10 00:00:00
53 | Customer Solutions | Senior Product Manager | 2019-11-13 00:00:00 | 2020-04-12 00:00:00
56 | Customer Solutions | Technical Associate | 2019-10-25 00:00:00 | 2020-04-16 00:00:00
90 | Engineering | Senior Interface Engineer | 2018-12-31 00:00:00 | 2020-05-19 00:00:00
137 | Customer Solutions | Senior Consultant, Client Services | 2019-01-09 00:00:00 | 2019-08-21 00:00:00
115 | Customer Solutions | Business Analyst | 2019-12-30 00:00:00 | 2020-09-29 00:00:00
159 | Customer Solutions | Resolution Specialist | 2017-06-01 00:00:00 | 2020-10-08 00:00:00
188 | Customer Solutions | Consultant, Client Services | 2020-02-22 00:00:00
181 | Engineering | Data Analyst | 2020-02-28 00:00:00
186 | Marketing | Senior Designer | 2019-07-16 00:00:00
183 | Customer Solutions | Associate Product Manager | 2019-07-18 00:00:00
187 | Engineering | QA Team Lead | 2019-07-18 00:00:00
178 | Customer Solutions | Manager, Support | 2009-07-16 00:00:00 | 2019-03-27 00:00:00
Spreadsheet: 802384d1666816226-check-to-see-if-a-date-is-within-a-range-is-missing-some-book2
Sheet: Sheet1

Transition Begins | Transition Ends | Travel Start Date | Travel End Date | Begin Compare | End Compare | Overlap/No Overlap | Overlap/No Overlap
2021-12-01 00:00:00 | 2022-02-01 00:00:00 | 2021-12-08 00:00:00 | 2021-12-09 00:00:00 | 0 | 0 | 0 | No Overlap
2021-12-01 00:00:00 | 2022-02-01 00:00:00 | 2021-12-08 00:00:00 | 2021-12-09 00:00:00 | 0 | 0 | 0 | No Overlap
2021-12-01 00:00:00 | 2022-02-01 00:00:00 | 2021-12-10 00:00:00 | 2021-12-12 00:00:00 | 0 | 0 | 0 | No Overlap
2021-12-01 00:00:00 | 2022-02-01 00:00:00 | 2021-12-10 00:00:00 | 2021-12-12 00:00:00 | 0 | 0 | 0 | No Overlap
2021-12-01 00:00:00 | 2022-02-01 00:00:00 | 2021-12-10 00:00:00 | 2021-12-12 00:00:00 | 0 | 0 | 0 | No Overlap
Spreadsheet: 63943d1264791933-employees-project-report-summary-explain-new
Sheet: Susan

Here where the description is the employees will be putting the name of the project that they are working on and every week they will be using a different spreadsheet (some examples are displayed below) They will be located between A13:A18 in all worksheets and workbooks. | in this column the employee will put the amount of hours that had to spent on Monday on the projects | in this column the employee will put the amount of hours that had to spent Tuesday on the projects | in this column the employee will put the amount of hours that had to spent On Wedn on the projects | in this column the employee will put the amount of hours that had to spent on thursday on the projects | in this column the employee will put the amount of hours that had to spent on Friday on the projects | In the final colom will be the total of the amount of hours that was spent for a project for a week. This sum will be located ONLY on G13:G18 in all the worksheets and workbooks
Sue
Description |  |  |  |  |  | Total Hours per project
 | Hours | Hours | Hours | Hours | Hours
 | Monday | Tuesday | Wednesday | Thursday | Friday
CR005 |  | 2 | 1 | 2 | 1 | 6 | this number in cell G13 tells us that [NAME] spent 6 hours in total on project [NAME] for this week
CR004 |  | 2 |  |  | 2 | 4 | this number in cell G14 tells us that [NAME] spent 4 hours in total on project CR004 for this week
CR008 | 1 |  |  | 1 | 2 | 4 | this number in cell [NAME] tells us that [NAME] spent 4 hours in total on project [NAME] for this week
CR003 | 1 | 1 | 4 | 3 | 1 | 10 | this number in cell G16 tells us that [NAME] spent 10 hours in total on project CR003 for this week
 |  |  |  |  |  | 0
CR001 | 4 | 2 |  | 3 |  | 9 | this number in cell G18 tells us that [NAME] spent 9 hours in total on project CR001 for this week
Spreadsheet: 189310d1351155359-use-the-table-to-calculate-differetn-quantities-libro11
Sheet: Bulb size&weight

E27 Bulbs |  |  |  |  |  |  |  |  |  |  | E14 Bulbs
Number | Product |  | Ounces | Inside Box(oz.) |  | Diameter and [NAME] |  |  |  |  | Number | Product |  | Ounces | Inside Box(oz.) |  | Diameter and [NAME]
1 | MCOB4 |  | 2.55 | 3.41 |  | Φ57.5 x 107.35 |  |  |  |  | 1 | HQ0305 |  | 1.23 | 1.98 |  | Φ34.6x119
2 | MCOB7 |  | 2.55 | 3.39 |  | Φ57.5 x 107.35 |  |  |  |  | 2 | HQ0306 |  | 1.86 | 2.41 |  | Φ42x108
3 | MCOB9 |  | 2.84 | 3.68 |  | Φ57.5 x 107.35
4 | 108 LED Corn |  | 2 | 2.56 |  | Φ35.63 x 111.17
5 | 166 LED Corn |  | 3.04 | 3.62 |  | Φ49.28 x 123.08
6 | 263 LED Corn |  | 5.97 | 5.73 |  | Φ60 x  146.7
7 | HQ0301 |  | 3.77 | 4.82 |  | [NAME]
8 | HQ0304 |  | 2.53 | 3.15 |  | Φ48.8x96.5
9 | HQ0307 |  | 2.09 | 2.67 |  | Φ48.8x85.3
10 | HQ0308 |  | 4.11 | 5.82 |  | Φ79.1 x 140.9
11 | HQ0502 |  | 4.07 | 5.13 |  | Φ58.17x110.2
12 | HQ0503 |  | 2.85 | 3.6 |  | Φ58.8x92.5
13 | HQ0506 |  | 5.58 | 7.29 |  | [NAME] 134.5
14 | HQ0507 |  | 4.27 | 5.03 |  | Φ59.5 x 108
15 | HQ0701 |  | 7.26 | 8.93 |  | Φ76.3 x 132
16 | HQ0901 |  | 9.59 | 11.28 |  | Φ69.6 x 157.3
Spreadsheet: 024cfce4-acbd-4941-8881-36ae25fbf1ce
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
 | SERIE REGULAR 2011
 | TABLA DE POSICIONES
 | Seccion Este |  |  |  |  |  |  |  |  | Seccion Norte
 | POS | EQUIPO |  | JJ | G | P | % | JV |  | POS | EQUIPO |  | JJ | G | P | % | JV
 | 1 | y Ceiba |  | 12 | 9 | 3 | 0.75 | - |  | 1 | x Barceloneta |  | 10 | 8 | 2 | 0.8 | -
 | 2 | x  San Lorenzo |  | 12 | 9 | 3 | 0.75 | 0 |  | 2 | x Orocovis* |  | 10 | 7 | 3 | 0.7 | 1
 | 3 | x Humacao* |  | 11 | 4 | 7 | 0.3636363636363636 | 4.5 |  | 3 | x Hatillo |  | 12 | 8 | 4 | 0.6666666666666666 | 1
 | 4 | Naguabo |  | 11 | 3 | 8 | 0.2727272727272727 | 5.5 |  | 4 | x Toa Alta |  | 12 | 6 | 6 | 0.5 | 3
 | 5 | Yabucoa |  | 12 | 3 | 9 | 0.25 | 6 |  | 5 | Florida |  | 11 | 0 | 11 | 0 | 8.5
 | Seccion Sureste
 | POS | EQUIPO |  | JJ | G | P | % | JV
 | 1 | y Maunabo |  | 12 | 8 | 4 | 0.6666666666666666 | -
 | 2 | x Guayama** |  | 12 | 7 | 5 | 0.5833333333333334 | 1
 | 3 | x Aguas Buenas |  | 12 | 7 | 5 | 0.5833333333333334 | 1
 | 4 | x Patillas |  | 12 | 7 | 5 | 0.5833333333333334 | 1
 | 5 | Villalba |  | 12 | 5 | 7 | 0.4166666666666667 | 3
 | 6 | Salinas |  | 11 | 1 | 10 | 0.09090909090909091 | 6.5
 | x- ASEGURO PASE A LA POST TEMPORADA
 | y- ASEGURO LA PRIMERA POSICION
 | *DE SER NESESARIO SE CONTINUARA EN LA SEGUNDA ENTRADA
 | **GUAYAMA ASEGURA EL SEGUNDO LUGAR AL PERMITIR MENOS CARRERAS ANTE AGUAS BUENAS Y PATILLAS
Spreadsheet: b0bf5020-42ef-4d1a-a572-80d4f76286e0
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8445 | 40701 | [NAME] | Rodriguez | ESP | 1 | 00:13:26 | 00:02:30 | 00:33:06 | [NAME] | 00:26:33 | 1 | 01:16:25