tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f29aea9f-a53f-4da2-a7d0-b4330e3e345a
Sheet: Sheet1

United States Senator - REP (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 7/24/2014 7:59:19 AM
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
2010 Primary Election - OFFICIAL RESULTS
District | [NAME] | write-in | TOTALS
District 01 | 1570 | 1 | 1571
District 02 | 1209 | 4 | 1213
District 04 | 755 | 1 | 756
District 06 | 1249 | 0 | 1249
District 07 | 2075 | 3 | 2078
District 08 | 602 | 2 | 604
District 09 | 607 | 1 | 608
District 10 | 1782 | 1 | 1783
District 11 | 710 | 2 | 712
District 13 | 1506 | 4 | 1510
District 14 | 1355 | 2 | 1357
District 15 | 1723 | 2 | 1725
District 16 | 127 | 0 | 127
District 17 | 1293 | 5 | 1298
District 18 | 513 | 2 | 515
District 19 | 1186 | 2 | 1188
District 20 | 421 | 1 | 422
District 21 | 401 | 1 | 402
District 22 | 1494 | 2 | 1496
District 23 | 252 | 0 | 252
District 24 | 1648 | 1 | 1649
District 25 | 707 | 4 | 711
District 26 | 1172 | 0 | 1172
District 27 | 723 | 2 | 725
District 28 | 1866 | 2 | 1868
District 29 | 525 | 0 | 525
District 31 | 1529 | 4 | 1533
District 33 | 2345 | 2 | 2347
District 34 | 1050 | 2 | 1052
District 36 | 2250 | 5 | 2255
District 37 | 2309 | 4 | 2313
District 39 | 2570 | 3 | 2573
District 41 | 1067 | 1 | 1068
District 42 | 436 | 0 | 436
District 43 | 680 | 1 | 681
District 44 | 1070 | 7 | 1077
District 45 | 713 | 1 | 714
District 46 | 1125 | 4 | 1129
TOTAL | 44615 | 79 | 44694
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: b876e504-718b-4b1b-9d5e-76f385871e44
Sheet: Cashflow - 12 Quarters

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Unaudited Supplemental Financial Information
(in millions)
 |  |  |  | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3
CASH FLOW DATA |  |  |  | FY10 | FY11 | FY11 | FY11 | FY11 | FY12 | FY12 | FY12 | FY12 | FY13 | FY13 | FY13
 | Operating cash flow |  |  | 253 | -148 | -134 | 349 | 253 | -274 | -211 | 475 | 287 | -244 | -28 | 363
 | Operating cash flow - TTM |  |  | 152 | 332 | 192 | 320 | 320 | 194 | 117 | 243 | 277 | 307 | 490 | 378
 | Capital expenditures |  |  | 22 | 11 | 12 | 15 | 21 | 32 | 52 | 44 | 44 | 31 | 25 | 25
 | Capital expenditures - TTM |  |  | 72 | 75 | 61 | 60 | 59 | 80 | 120 | 149 | 172 | 171 | 144 | 125
 | Free cash flow |  |  | 231 | -159 | -146 | 334 | 232 | -306 | -263 | 431 | 243 | -275 | -53 | 338
 | Free cash flow - TTM |  |  | 80 | 257 | 131 | 260 | 261 | 114 | -3 | 94 | 105 | 136 | 346 | 253
Spreadsheet: 865595d1712653216-list-up-the-sheet1-to-sheet2-depend-on-condition-list-pump-use-
Sheet: WORKER 1

WORKER 1
no | location | customer | Status | worker 1 |  |  | Sub TransferData()
 |  |  |  |  |  |  | Dim ws1 As Worksheet
 |  |  |  |  |  |  | Dim ws2 As Worksheet
 |  |  |  |  |  |  | Dim lastRow As Long
 |  |  |  |  |  |  | Dim i As Long
 |  |  |  |  |  |  | Dim targetRow As Long
 |  |  |  |  |  |  | ' Set references to Sheet1 and Sheet2
 |  |  |  |  |  |  | Set ws1 = ThisWorkbook.Sheets("Sheet1")
 |  |  |  |  |  |  | Set ws2 = ThisWorkbook.Sheets("Sheet2")
 |  |  |  |  |  |  | ' Find the last row in Sheet1 column D
 |  |  |  |  |  |  | lastRow = ws1.Cells(ws1.Rows.Count, "D").End(xlUp).Row
 |  |  |  |  |  |  | ' Loop through each row in Sheet1 column D
 |  |  |  |  |  |  | For i = 2 To lastRow ' Assuming data starts from row 2
 |  |  |  |  |  |  | ' Check if the value in column E of the current row is not empty
 |  |  |  |  |  |  | If [NAME], "E").Value <> "" Then
 |  |  |  |  |  |  | ' Determine the target row in Sheet2
 |  |  |  |  |  |  | targetRow = ws2.Cells(ws2.Rows.Count, "D").End(xlUp).Row + 1
 |  |  |  |  |  |  | ' Copy the value from Sheet1 column D to Sheet2 column D
 |  |  |  |  |  |  | ws2.Cells(targetRow, "D").Value = ws1.Cells(i, "D").Value
 |  |  |  |  |  |  | End If
 |  |  |  |  |  |  | Next i
 |  |  |  |  |  |  | ' Inform user that the transfer is complete
 |  |  |  |  |  |  | MsgBox "Data transfer completed successfully!", vbInformation
 |  |  |  |  |  |  | End Sub
 |  |  |  |  |  |  | Instructions for using the macro:
 |  |  |  |  |  |  | Press Alt + F11 to open the Visual Basic for Applications (VBA) editor.
 |  |  |  |  |  |  | Go to Insert > Module to insert a new module.
 |  |  |  |  |  |  | Copy and paste the above code into the module window.
 |  |  |  |  |  |  | Close the VBA editor.
 |  |  |  |  |  |  | Press Alt + F8, select TransferData, and click Run.
Spreadsheet: 683026d1592444618-combining-3-array-formulas-to-one-sample
Sheet: Collections

Name | Phone | Date | Time | Quantity | Type | Paid | Balance Due | Confirmed | Collected
Spreadsheet: 168939d1342634167-summing-up-percentages-every-10-rows-by-categories-excel-help-question
Sheet: Sheet1

股东序号()_SHSer | 股东名单_SHlst | English name | Ownership | OWNERSHIP Type 1 | Ownership type 2 | 持股数占总股本比例()_Pcttotshr | GM % | GB% | SAMB% | MOE% | LMOE% | SC% | IF% | P% | F% | I% | [NAME] | S% | M% | TOTAL P% | C% | L%
1 | [NAME] | Shenzhen Investment Management Company | SAMB | S | L | 0.070838
2 | 深圳国际信托投资公司 | Shenzhen International Trust and Investment Corporation | SAMB | S | L | 0.05771431
3 | 深圳市社会保险公司 | Shenzhen Social Insurance | LMOE | M | L | 0.04025991
4 | 深圳中电投资股份有限公司 | Shenzhen Investment Co., Ltd. | LMOE | M | L | 0.03198988
5 | 海通证券股份有限公司 | Hai Tong Securities Co., Ltd. | SC | P | P | 0.01743452
6 | 申银万国证券股份有限公司 | SW Securities Co., Ltd. | SC | P | P | 0.01568011
7 | 深圳市城建开发集团公司 | Shenzhen Urban Construction Development Group | LMOE | M | L | 0.01323719
8 | 德隆国际战略投资有限公司 | Delong International Strategic Investment Co., Ltd. | IF | P | P | 0.01284804
9 | 中国农业银行深圳分行工会 | Agricultural Bank of China Shenzhen Branch of trade unions | WU | P | P | 0.00800049
10 | [NAME] | Shanghai Smart Real Estate Development Co., Ltd. | LMOE | M | L | 0.00566208
1 | [NAME] | Shenzhen Investment Management Company | SAMB | S | L | 0.070838
2 | 深圳国际信托投资公司 | Shenzhen International Trust and Investment Corporation | SAMB | S | L | 0.05771431
3 | 深圳市社会保险公司 | Shenzhen Social Insurance | LMOE | M | L | 0.04025991
4 | 深圳中电投资股份有限公司 | Shenzhen Investment Co., Ltd. | LMOE | M | L | 0.03198988
5 | 海通证券股份有限公司 | Hai Tong Securities Co., Ltd. | SC | P | P | 0.01743452
6 | 深圳市城建开发集团公司 | Shenzhen Urban Construction Development Group | LMOE | M | L | 0.01323719
7 | 德隆国际战略投资有限公司 | Delong International Strategic Investment Co., Ltd. | IF | P | P | 0.01284804
8 | 中国农业银行深圳分行工会 | Agricultural Bank of China Shenzhen Branch of trade unions | WU | P | P | 0.00800049
9 | 博时裕富证券投资基金 | [NAME] | SC | P | P | 0.00401882
10 | 深圳国债服务中心 | National debt service center in Shenzhen | GB | S |  | 0.00377253
1 | Newbridge Asia AIV Ⅲ,L.P. | Newbridge Asia AIV Ⅲ, L.P. | F | P |  | 0.1788978
Spreadsheet: 673455d1587394466-assign-a-specific-value-range-from-row-cell-data-to-new-column-example
Sheet: Sheet1

Subject | REF
Fwd: Your PO: 300742367 / Our REF: 105874528 / CABIN
O/N 300741942 P/N 30086-011  S/N Y10837 FROM AEM
Hydro-Aire Reminder for Customer Service Request No 983507 in PDF Format
Hydro-Aire Reminder for Customer Service Request No 982809 in PDF Format
RE: IMPORTANT FW: 303759766 - BX46085 - PO: 300738078
RE: 300717601 - West Star Aviation GJT - Quote - 50499
Hydro-Aire Reminder for Customer Service Request No 978895 in PDF Format
Hydro-Aire Reminder for Customer Service Request No 978569 in PDF Format
Quote 202313406 - Parker Germany Executive
Quote 300745491 - Parker Germany Executive
Quote 300739577 - Parker Germany Commercial
Repair Quotation Order nr 300744333 (our ref DOI 1202508)
Repair Quotation Order nr 300744439 (our ref DOI 1202509)
Action required – Quote [NAME] ; PO#:    [ ref:_00D30dWxY._5001B1S87gN:ref ]
QUOTATION 100077 // 300744693
300747762 Quote (85514)
QUOTATION 99289 // RO 70139382
QUOTATION 99271 // 300724250
QUOTATION FOR APPROVAL | EMBRAER ASIA PACIFIC | PO: 300743210 JN: 210041285 - 20 APRIL 2020
Spreadsheet: 101391d1299534613-excel-function-for-calculating-hours-in-a-week-for-several-employees-production-report
Sheet: Template

Week of | MMM DD-DD 2011
Client | Project | Account Manager | Staff | Time | Status
Monday | Monday | Monday | Monday | Monday
Tuesday | Tuesday | Tuesday | Tuesday | Tuesday
Wednesday | Wednesday | Wednesday | Wednesday | Wednesday
Thursday | Thursday | Thursday | Thursday | Thursday
Friday | Friday | Friday | Friday | Friday
Totals | Totals | Totals | Totals | Totals | Totals
 | Completed
 | WOS
 | WOC
 | Feedback
 | Push
 | Cancelled
 | Follow-up
 | FIRM
 | Empty
 | Total
Time Totals | Mon | [NAME] | Wed | Thur | Fri | Week
Erin
[NAME]
[NAME]
Jon
Justin
Victor
[NAME]
[NAME]
Variables - Don't touch anything in here!
R:Totals
R:Monday
R:Tuesday
R:Wed
R:Thur
R:Fri
Spreadsheet: 817861d1676472678-scan-barcode-split-by-order-location-and-check-by-location-scan-and-split-and-check
Sheet: database

barecode | store | order qty | total barecode/store
123 | store 1 | 3
123 | store 3 | 2
123 | store 4 | 3
456 | store 1 | 2
456 | store 2 | 2
456 | store 4 | 1
456 | store 5 | 3
456 | store 6 | 4
789 | store 1 | 3
789 | store 2 | 3
789 | store 3 | 2
789 | store 6 | 2
Spreadsheet: 863106d1710671499-extracting-unique-data-from-repeating-parameters-in-excel-dynamic-approach-needed-extracting-unique-data-ans-1-
Sheet: Sheet1

Parameter-a | Parameter-b | Data
a1 | b1 | c1
a1 | b1 | c2 |  |  | Parameter-a | Parameter-b | [NAME] | Custom.2 | Custom.3 | Custom.4 | Custom.5 | Custom.6 | Custom.7 | Custom.8 | Custom.9 | Custom.10 | Custom.11 | Custom.12 | Custom.13 | Custom.14 | Custom.15 | Custom.16 | Custom.17 | Custom.18 | Custom.19 | Custom.20 | Custom.21 | Custom.22 | Custom.23 | Custom.24 | Custom.25 | Custom.26 | Custom.27 | Custom.28 | Custom.29 | Custom.30 | Custom.31 | Custom.32 | Custom.33 | Custom.34 | Custom.35 | Custom.36 | Custom.37 | Custom.38 | Custom.39 | Custom.40 | Custom.41 | Custom.42 | Custom.43 | Custom.44 | Custom.45 | Custom.46 | Custom.47 | Custom.48 | Custom.49 | Custom.50 | Custom.51 | Custom.52 | [NAME] | [NAME] | Custom.55 | Custom.56 | Custom.57 | Custom.58 | Custom.59 | Custom.60
a1 | b2 | c3 |  |  | a1 | b1 | c1 | c2 | c1 | c2
a2 | b2 | c4 |  |  | a1 | b2 | c3 | c3 | c3 | c3 | c3 | c3 | c3 | c3
a2 | b2 | c5 |  |  | a2 | b2 | c4 | c5 | c9 | c10 | c11 | c4 | c5 | c9 | c10 | c11
a2 | b1 | c6 |  |  | a2 | b1 | c6 | c7 | c8 | c6 | c7 | c8
a2 | b1 | c7
a2 | b1 | c8
a2 | b2 | c9
a2 | b2 | c10
a2 | b2 | c11
a1 | b1 | c1
a1 | b1 | c2
a1 | b2 | c3
a2 | b2 | c4
a2 | b2 | c5
a2 | b1 | c6
a2 | b1 | c7
a2 | b1 | c8
a2 | b2 | c9
a2 | b2 | c10
a2 | b2 | c11
a1 | b2 | c3
a1 | b2 | c3
a1 | b2 | c3
a1 | b2 | c3
a1 | b2 | c3
a1 | b2 | c3
Spreadsheet: e113b80e-d1cf-4462-95b4-4bc8a74a2bdc
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
[NAME] | 38081396170 | [NAME] | [NAME] Songs | 2014-12-02 | Piano Folio | Na | 17.99 | Y | NYP
[NAME] | 38081475837 | Various | 2014 Greatest Christian Hits Deluxe Annual Edition | 2014-12-02 | Piano Folio | Na | 16.99 | Y | NYP
[NAME] | 38081475189 | Melody Bober | [NAME] Teens, Book 3 | 2014-09-02 | Piano Folio | Na | 7.99 | Y | Available
[NAME] | 38081475172 | Melody Bober | [NAME] Teens, Book 2 | 2014-09-02 | Piano Folio | Na | 7.99 | Y | Available
[NAME] | 38081475165 | Melody Bober | [NAME] Teens, Book 1 | 2014-09-02 | Piano Folio | Na | 6.99 | Y | Available
[NAME] | 38081447629 | [NAME] | The Worship Leader'S Christmas And Easter Guitar Book | 2014-09-02 | Guitar Book | Na | 16.99 | Y | Available
Spreadsheet: 148607d1333481171-count-the-number-of-odd-numbers-in-a-row-even-vs-odd
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
Odd nums | 11
Even Nums | 10
Spreadsheet: 1e777153-65cd-420d-a513-6e78aa4c907d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5600 | 13649 | [NAME] | Rodrigues | FRA | 0 | 00:30:42 | 00:05:50 | 01:04:37 | [NAME] | 00:43:19 | 1 | 02:27:51
5600 | 39131 | Georg | [NAME] | GER | 0 | 00:27:23 | 00:05:04 | 01:06:24 | 00:03:26 | 00:46:35 | 2 | 02:28:54
5600 | 30373 | [NAME] | Cuvillier | FRA | 0 | 00:36:08 | 00:05:18 | 01:08:56 | 00:02:56 | [NAME] | 3 | 02:39:42
5600 | 17485 | Alberto | Ceriani | ITA | 0 | 00:36:01 | 00:05:46 | 01:11:03 | 00:03:20 | 00:46:38 | 4 | 02:42:53
5600 | 25143 | [NAME] | Kiff | GBR | 0 | 00:46:52 | 00:06:40 | 01:16:25 | 00:04:29 | 00:54:38 | 5 | 03:09:05
Spreadsheet: jonathan_mckay__17192__June Index Summary
Sheet: Transco St 65

EOL Transaction Summary Report
Criteria: | Traders
 | [NAME]
 | Product:
 | US Gas Phy Fwd
EnronOnline Report | All Counterparties
Product | Date-Time | Volume | Price
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/29/2001 03:08 pm | 2483 | 3.765
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/29/2001 03:27 pm | 10000 | 3.785
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/29/2001 08:44 am | 10000 | 3.92
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/29/2001 09:34 am | 10000 | 3.925
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/29/2001 11:40 am | 840 | 3.905
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 01:39 pm | 5000 | 3.885
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 01:44 pm | 10000 | 3.91
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 03:01 pm | 8000 | 3.945
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 03:16 pm | 2891 | 3.94
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 03:48 pm | 10000 | 4.015
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 08:14 am | 5000 | 3.69
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 08:20 am | 2866 | 3.695
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 08:23 am | 2500 | 3.65
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 08:45 am | 2500 | 3.67
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 08:47 am | 7500 | 3.655
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 08:59 am | 2500 | 3.645
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 09:24 am | 3500 | 3.615
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 09:26 am | 616 | 3.61
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/30/2001 09:30 am | 135 | 3.64
US Gas Phy       Transco St.65           Jun01           USD/MM | 05/31/2001 08:06 am | 10000 | 3.8
 | TOTAL VOLUME
Weighted Average
Spreadsheet: 101397d1299536208-excel-function-for-calculating-hours-in-a-week-for-several-employees-productionreport
Sheet: Mar 21-27

Week of | Mar 21-27 2011
Client | Project | Account Manager | Staff | Time | Status
Monday | Monday | Monday | Monday | Monday
RCMP | send invitaitions to suppliers of RCMP | [NAME] | justin
Tuesday | Tuesday | Tuesday | Tuesday | Tuesday
Wednesday | Wednesday | Wednesday | Wednesday | Wednesday
Thursday | Thursday | Thursday | Thursday | Thursday
Friday | Friday | Friday | Friday | Friday
RCMP | Launch photo site | [NAME] | Jon | 2 | Push
Totals | Totals | Totals | Totals | Totals | Totals
 | Completed | 0 | 0
 | WOS | 0 | 0
 | WOC | 0 | 0
 | Feedback | 0 | 0
 | Push | 1 | -0.25
 | Cancelled | 0 | 0
 | Follow-up | 0 | 0
 | FIRM | 0 | 0
 | Empty | -5 | 1.25
 | Total | -4 | 1
Time Totals | Mon | [NAME] | Wed | Thur | Fri | Week
Erin | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Jon | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Justin | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Victor | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Variables - Don't touch anything in here!
R:Totals | 148
R:Monday | 3
R:Tuesday | 34
R:Wed | 65
R:Thur | 93
R:Fri | 123
Spreadsheet: eric_saibi__9955__110701R
Sheet: Eddystone 03

Owner Name |  | Exelon Power Company
Station Name |  | Eddystone Power Station
Unit Name |  | Eddystone 03
NERC Region |  | MAAC
State |  | PA
Fuel Type |  | Fuel Oil / Natural Gas
Capacity |  | 391 MW
Start Date |  | 2001-11-12 00:00:00
End Date |  | 2001-12-16 00:00:00
Prv. Start Date |  | 2001-11-03 00:00:00
Prv. End Date |  | 2001-12-07 00:00:00
Comments |  | Valve work and turbine section replacement.
SIC |  | 4931
Plant ID |  | 1014913
Unit ID |  | 1005489
Outage ID |  | 12673
Spreadsheet: 51053d1250623718-formatting-based-on-same-name-testpivot
Sheet: 7.13.09

WINET PATRON # | PATRON NAME | TOTAL CALC WIN | TOTAL ACTUAL
[PHONE] | ADAMS ,FAYE | 1459 | 2629 | 1
 |  |  |  | 1
 |  |  |  | 1
[PHONE] | BRAGG ,SANDY | 2 | 17 | 2
 |  |  |  | 2
 |  |  |  | 2
[PHONE] | CAUSER ,KARLA | 564 | 1179 | 3
[PHONE] | CAUSER ,KARLA | 29 | 61 | 3
[PHONE] | CAUSER ,KARLA | 29 | 56 | 3
 |  |  |  | 3
 |  |  |  | 3
[PHONE] | DEVINCENTIS ,MARIE | 481 | 563 | 4
[PHONE] | DEVINCENTIS ,MARIE | 0 | 0 | 4
 |  |  |  | 4
 |  |  |  | 4
[PHONE] | DEVINCENTIS ,PAUL | 1538 | 5174 | 5
[PHONE] | DEVINCENTIS ,PAUL | 0 | 0 | 5
 |  |  |  | 5
 |  |  |  | 5
[PHONE] | DUMONT ,[NAME] | 478 | 592 | 6
 |  |  |  | 6
 |  |  |  | 6
[PHONE] | FINN ,MARIAN | 50 | 150 | 7
[PHONE] | FINN ,MARIAN | 0 | 0 | 7
 |  |  |  | 7
 |  |  |  | 7
[PHONE] | FINN ,PAUL | 886 | 1054 | 8
[PHONE] | FINN ,PAUL | 0 | 0 | 8
 |  |  |  | 8
 |  |  |  | 8
[PHONE] | GRANT ,PHILIP | 1081 | 2058 | 9
 |  |  |  | 9
 |  |  |  | 9
[PHONE] | GRANT ,THYRA | 720 | 584 | 10
 |  |  |  | 10
 |  |  |  | 10
[PHONE] | HORGAN ,JUDITH | 29 | 101 | 11
[PHONE] | HORGAN ,JUDITH | 1487 | 3382 | 11
 |  |  |  | 11
 |  |  |  | 11
[PHONE] | HORGAN ,[NAME] | 21 | 70 | 12
[PHONE] | HORGAN ,[NAME] | 796 | -31 | 12
 |  |  |  | 12
 |  |  |  | 12
[PHONE] | HORTON ,ED | 15 | 101 | 13
[PHONE] | HORTON ,ED | 126 | 405 | 13
 |  |  |  | 13
 |  |  |  | 13
[PHONE] | KNIGHT ,BARBARA | 292 | 234 | 14
[PHONE] | KNIGHT ,BARBARA | 1 | 10 | 14
[PHONE] | KNIGHT ,BARBARA | 22 | 30 | 14
 |  |  |  | 14
 |  |  |  | 14
[PHONE] | LOGUE ,ALAN | 3235 | 5892 | 15
[PHONE] | LOGUE ,ALAN | 0 | 0 | 15
 |  |  |  | 15
 |  |  |  | 15
[PHONE] | MACISAAC ,[NAME] | 2465 | 3545 | 16
 |  |  |  | 16
 |  |  |  | 16
[PHONE] | MAHONEY ,BARBARA | 576 | -224 | 17
[PHONE] | MAHONEY ,BARBARA | 0 | 0 | 17
 |  |  |  | 17
 |  |  |  | 17
[PHONE] | MCELLIGOTT ,MARILYN | 99 | 308 | 18
[PHONE] | MCELLIGOTT ,MARILYN | 53 | -50 | 18
[PHONE] | MCELLIGOTT ,MARILYN | 9 | -1 | 18
 |  |  |  | 18
 |  |  |  | 18
[PHONE] | MCGANN ,RICHARD | 740 | 1803 | 19
 |  |  |  | 19
 |  |  |  | 19
[PHONE] | MCGANN ,THOMAS | 664 | 2058 | 20
 |  |  |  | 20
 |  |  |  | 20
[PHONE] | RAPCHUCK ,ANDREW | 67 | 129 | 21
[PHONE] | RAPCHUCK ,ANDREW | 0 | 0 | 21
 |  |  |  | 21
 |  |  |  | 21
[PHONE] | RAPCHUCK ,MARILYN | 4768 | 2647 | 22
[PHONE] | RAPCHUCK ,MARILYN | 314 | 332 | 22
[PHONE] | RAPCHUCK ,MARILYN | 0 | 0 | 22
 |  |  |  | 22
 |  |  |  | 22
[PHONE] | SAULENAS ,[NAME] | 116 | 85 | 23
[PHONE] | SAULENAS ,[NAME] | 12 | 59 | 23
[PHONE] | SAULENAS ,[NAME] | 0 | 0 | 23
 |  |  |  | 23
 |  |  |  | 23
[PHONE] | SCOPA ,CAROL | 727 | 1394 | 24
[PHONE] | SCOPA ,CAROL | 0 | 0 | 24
 |  |  |  | 24
 |  |  |  | 24
[PHONE] | SCOPA ,PAUL | 1006 | -1109 | 25
[PHONE] | SCOPA ,PAUL | 0 | 0 | 25
 |  |  |  | 25
 |  |  |  | 25
[PHONE] | SWEATT ,PATRICIA | 609 | 863 | 26
[PHONE] | SWEATT ,PATRICIA | 56 | -25 | 26
[PHONE] | SWEATT ,PATRICIA | 53 | 29 | 26
 |  |  |  | 26
 |  |  |  | 26
[PHONE] | VENTURA ,ALFRED | 22 | 97 | 27
[PHONE] | VENTURA ,ALFRED | 33 | 52 | 27
[PHONE] | VENTURA ,ALFRED | 390 | 1835 | 27
 |  |  |  | 27
 |  |  |  | 27
Spreadsheet: 703852d1605194736-count-days-by-month-in-a-date-range-days-by-month-in-date-range
Sheet: Tasks from to

 |  |  |  |  | Team Member 1 |  |  | Team Member 2 |  |  | Team Member 3
No. | Task | from | to | from-to | duration in months | start date | end date | duration in months |  |  | duration in months
1 | Task1 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 1 - 2 | 0.5 | 2021-01-01 00:00:00 | 2021-01-16 00:00:00 | 0.5 | 2021-01-01 00:00:00 | 2021-01-16 00:00:00 | 0.5 | 2021-01-01 00:00:00 | 2021-01-16 00:00:00
2 | [NAME] | 2021-01-16 00:00:00 | 2021-02-16 00:00:00 | 1 - 2 | 0 |  |  | 0 |  |  | 0.5 | 2021-01-16 00:00:00 | 2021-01-31 00:00:00
3 | Task3 | 2021-02-01 00:00:00 | 2021-03-16 00:00:00 | 2 - 3 | 0 |  |  | 0 |  |  | 0
4 | Task4 | 2021-01-01 00:00:00 | 2021-02-15 00:00:00 | 1 - 2 | 0 |  |  | 0 |  |  | 0.5 | 2021-01-31 00:00:00 | 2021-02-15 00:00:00
5 | Task5 | 2021-01-01 00:00:00 | 2021-03-02 00:00:00 | 1 - 3 | 0 |  |  | 0 |  |  | 0.5 | 2021-02-15 00:00:00 | 2021-03-02 00:00:00
6 | Task6 | 2021-01-01 00:00:00 | 2021-03-17 00:00:00 | 1 - 3 | 0 |  |  | 0 |  |  | 0.5 | 2021-03-02 00:00:00 | 2021-03-17 00:00:00
7 | Task7 | 2021-01-16 00:00:00 | 2021-03-01 00:00:00 | 1 - 3 | 0 |  |  | 0.5 | 2021-01-16 00:00:00 | 2021-01-31 00:00:00 | 0
8 | Task8 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 1 - 4 | 1 | 2021-01-16 00:00:00 | 2021-02-16 00:00:00 | 1 | 2021-01-31 00:00:00 | 2021-03-03 00:00:00 | 0.5 | 2021-03-17 00:00:00 | 2021-04-01 00:00:00
9 | Task9 | 2021-03-18 00:00:00 | 2021-04-18 00:00:00 | 3 - 4 | 0 |  |  | 0 |  |  | 0
10 | Task10 | 2021-02-01 00:00:00 | 2021-04-16 00:00:00 | 2 - 4 | 0.5 | 2021-02-16 00:00:00 | 2021-03-03 00:00:00 | 0.5 | 2021-03-03 00:00:00 | 2021-03-18 00:00:00 | 0.5 | 2021-04-01 00:00:00 | 2021-04-16 00:00:00
Spreadsheet: 785907d1656827222-create-a-list-of-non-duplicate-items-active-associate-send-filter-unique-aligw
Sheet: List

Name | Employee ID | Employee Dept |  | Name | Employee ID | Employee Dept
 | 9321 | Social |  | [NAME] | 9321 | Social
Loren Brooke | 49128 | [NAME] |  | Loren Brooke | 49128 | [NAME]
[NAME] | 230948 | Ore |  | [NAME] | 230948 | Ore
[NAME] | 294831 | Graphic |  | [NAME] | 294831 | Graphic
Spreadsheet: 092b583d-3bf2-4e5c-a1f3-3bb725b40c27
Sheet: Sheet1

# | [NAME] | [NAME] | min. | sec. | 2b s. | 2b ú. | 3b s. | 3b ú. | TH s. | TH ú. | DU | DO | DC | Bl | As | M+ | M- | F+ | F- | Val | b.
4 | Pechová | Martina | 34 | 12 | 9 | 2 | 1 | 0 | 0 | 0 | 2 | 7 | 9 | 0 | 0 | 1 | 5 | 0 | 4 | -3 | 4
5 | Mišurová | [NAME] | 3 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | -1 | 0
6 | Vokřínková | [NAME] | 16 | 10 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 0 | 2 | 4 | 0 | 2 | -2 | 0
7 | Vojtová | [NAME] | 36 | 46 | 9 | 3 | 0 | 0 | 14 | 9 | 4 | 5 | 9 | 0 | 0 | 2 | 6 | 9 | 2 | 16 | 15
9 | Helceletová | Ivana | 20 | 25 | 7 | 1 | 1 | 0 | 0 | 0 | 1 | 5 | 6 | 0 | 0 | 1 | 2 | 0 | 3 | -3 | 2
10 | Kreuzová | [NAME] | 26 | 6 | 3 | 1 | 2 | 2 | 2 | 2 | 0 | 3 | 3 | 0 | 1 | 0 | 4 | 4 | 4 | 8 | 10
11 | Bortelová | Veronika | 36 | 48 | 8 | 2 | 6 | 4 | 3 | 2 | 1 | 3 | 4 | 0 | 1 | 1 | 5 | 5 | 2 | 13 | 18
12 | Bednářová | Markéta | 10 | 39 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | -4 | 0
13 | Husáková | Lucie | 4 | 46 | 1 | 0 | 1 | 0 | 5 | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 3
14 | Maňáková | Petra | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | Vodrážková | [NAME] | 9 | 1 | 4 | 1 | 0 | 0 | 2 | 1 | 0 | 3 | 3 | 0 | 0 | 1 | 3 | 1 | 1 | 0 | 3
16 | Holubová | Vladimíra | 1 | 54 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | 0
 |  |  | 40 | 0 | 46 | 10 | 12 | 6 | 26 | 17 | 11 | 28 | 39 | 0 | 2 | 21 | 29 | 21 | 21 | 37 | 55
 |  |  |  |  | 22% |  | 50% |  | 65%