tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 192065d1352299549-link-the-background-color-to-background-color-of-another-cell-longxin-conditional-formatting-for-dates-holidaysheetcalculations_template
Sheet: Q3

Jul |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol + ADV
 | 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
Alton
Dries
[NAME]
Stijn
Sven
[NAME]
Aug |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol + ADV
 | 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
Alton
Dries
[NAME]
Stijn
Sven
[NAME]
Sep |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol + ADV
 | 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
Alton
Dries
[NAME]
Stijn
Sven
[NAME]
Spreadsheet: 849370d1699887348-end-date-based-on-known-start-date-and-hours-worked-manufacturing-capacity-planning-excel-forum
Sheet: Resource Summary

 | Select Project |  |  |  |  | Month |  |  | 12 | Year |  | 2023
 | [NAME] | Role | Employee Holidays (Enter Hours)
Spreadsheet: 0114126d-b9ea-4680-b816-671175c9e413
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  | Petrol | Diesel
MODEL
 | Available grades |  |  | Mid / High | Base / Mid / High
 | Seating capacity |  | persons | 5 | 5
ENGINE
 | Engine code |  |  | VQ35DE | YD25
 | No. of cylinders, configuration |  |  | V6 | IL4
 | Valves per cylinder |  |  | 4 | 4
 | Engine capacity |  | cm³ | 3498 | 2488
 | Bore x stroke |  | [NAME] | 95.5 x 81.4 | 89.0 x 100.0
 | [NAME]. engine power |  | [NAME] | 188 (256ps) / 6000 | 140 (190ps) / 4000
 | [NAME]. torque |  | Nm/min-1 | 334 / 4400 | 450 / 2000
 | Compression ratio |  |  | 10.3 | 15.0
 | Fuel type |  |  | RON95 unleaded | Diesel
 | Fuel tank capacity |  |  | 82 | 82
DRIVE TRAIN |  |  |  | 4WD | 4WD
 | Transmission type |  |  | CVT | 6-speed Automatic
 | Gear ratio | 1st |  | 2.371 | 4.199
 |  | 2nd |  |  | 2.405
 |  | 3rd |  |  | 1.583
 |  | 4th |  |  | 1.161
 |  | 5th |  | 0.439 | 0.855
 |  | 6th |  |  | 0.685
 |  | Reverse |  | 1.766 | 3.457
 |  | Final Drive |  | 5.173 | 3.803
 | Driven wheels |  |  | 4WD | 4WD
CHASSIS
 | Suspension | front |  | Independent Strut Suspension
 |  | rear |  | Multi Link Independent Suspension
 | Steering |  |  | Engine speed-sensitive power assisted rack and pinion steering
 | Braking system |  |  | ventilated front and rear brakes
 | Wheel size (option) |  |  | 18 x 7.5J
 | Tyre size (option) |  |  | 235/65 R18 103H
WEIGHTS & DIMENSIONS
 | [NAME] weight min./max.  2) |  | [NAME] | 1790 / 1830 | 1895 / 1898
 | Gross Vehicle Weight |  | [NAME] | 2365 | 2495
 | [NAME]. pay load  2) |  | [NAME] | 467 | 447
 | [NAME] weight (PAW) | front | [NAME] | 1245 | 1370
 |  | rear | [NAME] | 1200 | 1185
 | [NAME]. trailer weight | braked | [NAME] | 1585 | 1585
 |  | unbraked | [NAME] | 750 | 750
 | [NAME] [NAME]. load on coupling point |  | [NAME] | 100 | 100
 | Overall length |  | [NAME] | 4860 | 4860
 | Overall width |  | [NAME] | 1885 | 1885
 | Overall height |  | [NAME] | 1720 | 1720
 | Wheelbase |  | [NAME] | 2825 | 2825
 | Track | front | [NAME] | 1610 | 1610
 |  | rear | [NAME] | 1610 | 1610
 | Min. turning circle (kerb to kerb) |  | m | 18in 11.4 20in 11.8 | 18in 11.4 20in 11.8
PERFORMANCE
 | Fuel consumption 3) | Urban cycle | [NAME] / mpg | 14.9 | 10.1
 |  | Extra-urban | [NAME] / mpg | 8.6 | 6.8
 |  | Combined | [NAME] / mpg | 10.9 | 8.0
 | CO2 mass emission (combined) |  | g/km | 261 | 210
 | [NAME]. speed |  | km/h / mph | 210 | 196
 | Acceleration 0 - 100 km/h |  | sec | 8.0 | 10.5
Spreadsheet: 732696d1621172797-dynamic-lookup-number-of-rows-vary-each-day-unique_list
Sheet: Sheet1

 | Unique List | Sorted A-Z |  | List 1 | List 2 |  | CORRECT RESULT TO BE PRODUCED
 |  |  |  | [NAME] | [NAME] |  | [NAME]
 |  |  |  | [NAME] | [NAME] |  | [NAME]
 |  |  |  | [NAME] | [NAME] |  | [NAME]
 |  |  |  | [NAME] | [NAME] |  | [NAME]
 |  |  |  | [NAME] | [NAME] |  | [NAME]
 |  |  |  | [NAME] | [NAME] |  | [NAME]
 |  |  |  | [NAME] | Cameron |  | [NAME]
 |  |  |  | Dominic | [NAME] |  | Cameron
 |  |  |  | Eddy | Dominic |  | [NAME]
 |  |  |  | [NAME] | [NAME] |  | Dominic
 |  |  |  |  | Eddy |  | [NAME]
 |  |  |  |  | [NAME] |  | Eddy
 |  |  |  |  |  |  | [NAME]
Spreadsheet: 816019d1675310859-newbie-question-countif-with-multiple-or-criteria-book1
Sheet: Template (2)

Month | SalesRep | Type | Amount |  | EXAMPLES OF USING EQUALITIES AND WILD CARDS
January | [NAME] | New | 85 |  | Name the Ranges as: Amount, Month, SalesRep, Type
January | [NAME] | New | 675
January | Brooks | New | 130 |  | 1) Aggregate, or sum, all sales made by Sales Rep, [NAME].
January | [NAME] | New | 1350 |  | 2) Aggregate, or sum, all sales made by Sales Reps whose names begins with "B."
January | [NAME] | Existing | 685 |  | 3) Aggregate, or sum, all sales made by Sales Reps whose names contain the letter "o."
January | Brooks | New | 1350 |  |  |  | SUMIF | SUMIFS
January | [NAME] | New | 475 |  | [NAME] |  |  |  | You should get 3,110
January | Brooks | New | 1205 |  | B…. |  |  |  | You should get 7,160
February | Brooks | Existing | 450 |  | ***o**** |  |  |  | You should get 12,337
February | [NAME] | New | 495 |  | SUMIFS, COUNTIFS, AVERAGEIFS | Additional Array Type Formula | Array | SUMIF, COUNTIF, AVERAGEIF | Description
February | [NAME] | New | 210 |  |  |  |  |  | Count where Amount >100 and <=200
February | [NAME] | Existing | 1050 |  |  |  | Not Possible |  | Sum Amounts >100 and <=200
February | [NAME] | New | 140 |  |  |  |  | Not Possible | Count January sales for Brooks that exceed $1,000
February | Brooks | New | 900 |  |  |  | Not Possible | Not Possible | Sum January sales for Brooks that exceed $1,000
February | Brooks | New | 900 |  |  |  |  |  | Count January and February sales
February | [NAME] | New | 95 |  |  |  |  |  | Count where January OR [NAME] OR Amount > 1000
February | [NAME] | New | 780 |  |  |  | Not Possible |  | Amount of January sales for Brooks or [NAME]
March | Brooks | New | 900
March | [NAME] | Existing | 875 |  |  |  | Why is this wrong -->
March | Brooks | New | 50
March | Brooks | New | 875
March | [NAME] | Existing | 225
March | [NAME] | New | 175
March | Brooks | Existing | 400
March | [NAME] | New | 840
March | [NAME] | New | 132
Spreadsheet: 467851d1467004228-timesheet-conditional-formatting-changing-the-colour-of-a-cell-base-on-time-worked-timesheet-sample
Sheet: Sheet1

Roster
Name | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 | 2016-06-27 00:00:00 |  | 2016-06-28 00:00:00 |  | 2016-06-29 00:00:00 |  | 2016-06-30 00:00:00 |  | 2016-07-01 00:00:00 |  | 2016-07-02 00:00:00 |  | 2016-07-03 00:00:00
 | Start |  | Start |  | Start |  | Start |  | Start |  | Start |  | Start
 | Finish |  | Finish |  | Finish |  | Finish |  | Finish |  | Finish |  | Finish
 | Start |  | Start |  | Start |  | Start |  | Start |  | Start |  | Start
 | Finish |  | Finish |  | Finish |  | Finish |  | Finish |  | Finish |  | Finish
 | Start |  | Start |  | Start |  | Start |  | Start |  | Start |  | Start
 | Finish |  | Finish |  | Finish |  | Finish |  | Finish |  | Finish |  | Finish
 | Start |  | Start |  | Start |  | Start |  | Start |  | Start |  | Start
 | Finish |  | Finish |  | Finish |  | Finish |  | Finish |  | Finish |  | Finish
 | Start |  | Start |  | Start |  | Start |  | Start |  | Start |  | Start
 | Finish |  | Finish |  | Finish |  | Finish |  | Finish |  | Finish |  | Finish
 | Start |  | Start |  | Start |  | Start |  | Start |  | Start |  | Start
 | Finish |  | Finish |  | Finish |  | Finish |  | Finish |  | Finish |  | Finish
Spreadsheet: 586042d1534175341-how-to-isolate-one-to-one-relationships-excel-forum-example
Sheet: Sheet1

Purch.Doc. | Delivery | Article
4501879764 | 368177104 | 1129457
4501879764 | 368177104 | 1129636
4501879764 | 368177104 | 1129633
4501879764 | 368177104 | 1122697
4501887045 | 371040471 | 1097146
4501900610 | 369255024 | 1106098
4501910018 | 368307623 | 1050078001
4501910018 | 368307623 | 1050078002
4501910018 | 368307623 | 1050078003
4501910018 | 368307623 | 1050078004
4501910018 | 368307623 | 1050078005
4501910018 | 368905681 | 1050123002
4501910018 | 368905681 | 1050123005
4501910021 | 369241847 | 1060658001
4501910021 | 369241847 | 1078665003
4501910021 | 369241847 | 1078665004
4501910021 | 369241847 | 1078665005
4501910021 | 369535643 | 1101849005
4501910021 | 369535643 | 1101849006
4501910021 | 369535643 | 1101849007
Spreadsheet: darrell_schoolcraft__7585__imball0112
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Measured | Scheduled | Measured | Scheduled
1 |  |  |  | -32563 |  | -33275
2 |  |  |  | -32563 |  | -32525
3 |  |  |  | -32563 |  | -32436
4 |  |  |  | -827 |  | -8093
5 |  |  |  | 4660
6 |  |  |  | -5816 |  | -791
7 |  |  |  | -5816
8 |  |  |  | -816
9 |  |  |  | -816
10 |  |  |  | -816
11 |  |  |  | -39554 |  | -38245
12 |  |  |  | -30816 |  | -30926
13 |  |  |  | -22622 |  | -22893
14 |  |  |  | -30816 |  | -31770
15 |  |  |  | -21316 |  | -20252
16 |  |  |  | -21316 |  | -21892
17 |  |  |  | -21316 |  | -20839
18 |  |  |  | -30816 |  | -29544
19 |  |  |  | -23816 |  | -22158
20 |  |  |  | -15816 |  | -15402
21 |  |  |  | -30816 |  | -30336
22 |  |  |  | -28054 |  | -28076
23 |  |  |  | -28054 |  | -27998
24 |  |  |  | -28054 |  | -28157
25 |  |  |  | -28054 |  | -27306
26
27
28
29
30
31
index
2001-11-30 00:00:00 |  |  |  |  | 389644.14
2001-12-25 00:00:00
CBS Volume
 |  |  | -7465
Spreadsheet: 800358d1665614049-counting-cells-in-a-row-based-on-settings-in-a-table-count-example
Sheet: Sheet1

Category | Count |  |  | Tool | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | What counts should be (want to do by formula to auto update as data is entered daily)
Up | Yes |  |  | ToolA | Up | Qual | Qual | Down | Maintenance | Up | Up |  | 5
Down | Yes |  |  | ToolB | Up | Down | Up | Up | Up | Up | Up |  | 7 |  | 7
Qual | No |  |  | ToolC | Qual | Down | Up | Up | Maintenance | Qual | Qual |  | 4 |  | 4
Maintenance | Yes |  |  | ToolD | Down | Down | Maintenance | Qual | Up | Up | Up |  | 6 |  | 6
 |  |  |  |  | Want to count all status that has "Yes" in the Category table to the left
 |  |  |  |  | For this example, "Qual" status should not be counted
Spreadsheet: 85820d1285854815-inputting-data-example
Sheet: Sheet1

Static | Variable | Static Start Range | Static End Range |  |  |  |  |  | Variable List
1 | 101 | 00 | 09 |  |  |  |  |  | 101
1 | 101 | 10 | 19 |  |  |  |  |  | 150
1 | 101 | 20 | 29 |  |  |  |  |  | 160
1 | 101 | 30 | 39 |  |  |  |  |  | 135
1 | 101 | 40 | 49 |  |  |  |  |  | 15
1 | 101 | 50 | 59 |  |  |  |  |  | 98
1 | 101 | 60 | 69 |  |  |  |  |  | 75
1 | 101 | 70 | 79 |  |  |  |  |  | 250
1 | 101 | 80 | 89 |  |  |  |  |  | 342
1 | 101 | 90 | 99 |  |  |  |  |  | 800
1 | 150 | 00 | 09 |  |  |  |  |  | ETC…
1 | 150 | 10 | 19
1 | 150 | 20 | 29
1 | 150 | 30 | 39
1 | 150 | 40 | 49
1 | 150 | 50 | 59
1 | 150 | 60 | 69
1 | 150 | 70 | 79
1 | 150 | 80 | 89
1 | 150 | 90 | 99
1 | 160 | 00 | 09
1 | 160 | 10 | 19
1 | 160 | 20 | 29
1 | 160 | 30 | 39
1 | 160 | 40 | 49
1 | 160 | 50 | 59
1 | 160 | 60 | 69
1 | 160 | 70 | 79
1 | 160 | 80 | 89
1 | 160 | 90 | 99
Spreadsheet: 683387d1592686707-time-card-calculation-time_card3c-revised
Sheet: Regular Employee 

Employee: |  |  |  |  |  |  |  |  |  |  | Year | 2020 |  |  |  |  |  |  |  |  |  |  |  |  | OPTIONS |  | OVERTIME OPTIONS
Employee Number: |  |  |  |  |  |  |  |  |  |  | Month |  |  |  |  |  |  | Su | M | [NAME] | W | Th | F | Sa | YES | DAILY | YES
Cost Center: |  |  |  | DEPT. # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | AFTER | 8 | HRS
SUPERVISOR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BREAK TIME | WEEKLY | YES
WEEK STARTING: | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | AFTER | 40 | HRS
WEEK ENDING: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
Day of Week | Time In | Time In 2 | [NAME] (minutes) | Time Out | Time Out 2 | Total Hours hide | Total Hours | Regular Hours hide | Regular Hours | Overtime | Overtime |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
 |  | hidden |  |  | hidden |  |  |  |  | Hours hide | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 | 0714 |  | 30 | 1530
 | 0700 |  | 30 | 1530
 | 0655 |  | 30 | 1538 |  |  |  |  |  |  |  |  | Rules
 | 2355 |  | 30 | 0830 |  |  |  |  |  |  |  |  | 1. Worker is given a 15 min. increment leeway, see examples on date 6/1 & 6/2 which is right.
 | 2359 |  | 30 | 0830 |  |  |  |  |  |  |  |  | 2. If a worker clocks out <8 minutes later a 15 minute overtime is not counted but if it hits 8 mins then a 15 min overtime is counted.
 |  |  |  |  |  |  |  |  |  |  |  |  | The correct examples are on dates 6/3,(your formula) and also on 6/8 (w/c  has a different formula).
 |  |  |  |  |  |  |  |  |  |  |  |  | 3. If a worker clocks in 8 mins early a 15 minute overtime is applied, if less than 8 it defaults to 0 mins. See example on date 6/9.
 |  |  |  | Total  Hrs. |  |  |  |  |  |  |  |  | The correct example is on date 6/9 w/c has a different formula on G19
 | 1600 |  | 30 | 0038 |  |  |  |  |  |  |  |  | Discrepancies:
 | 1614 |  | 30 | 0030 |  |  |  |  |  |  |  |  | 1. See date 6/4, Worker clocks in 5 min early but it's not suppose to get a 15 min. overtime.
 | 1629 |  | 30 | 0030 |  |  |  |  |  |  |  |  | 2. See date 6/5, worker clocks in 1 min early but it should not get a 15 min. overtime.
 | 1555 |  | 30 | 0030
 | 1552 |  | 30 | 0030
 | 1600 |  | 30 | 0037
 |  |  |  | Total  Hrs.
TOTAL HOURS WORKED: |  |  |  | Total  Hrs.
Spreadsheet: 144032d1330693149-excel-2007-import-data-from-a-worksheet-into-another-and-group-data-into-sections-generated-report
Sheet: Generated Report

BR ID | Requirement | Bug Description | BUG ID | [NAME] | Status | Resolution
PQ115 | PQ115-Login | [NAME] text xihllloloj | 43711 | 123 | RESOLVED | FIXED
PQ115 | PQ115-Login | [NAME] text hooouou0pu | 43712 | 124 | RESOLVED | FIXED
PQ116 | PQ116-Landing | [NAME] text ffghhhhnh | 43714 | 156 | RESOLVED | FIXED
PQ117 | PQ117-Create Order | [NAME] text hooouou0pu | 43718 | 199 | RESOLVED | FIXED
Spreadsheet: 50330d1249691735-retirement-plan-entry-file-revisited-john-eastland-revised-1
Sheet: 410 a Elig&Cov

 |  | Eligibiltiy and Coverage
 |  | Name of Employee | Date of Birth | Date of Hire | Date of Termination | Hours Worked | Date of Entry | OYFDOH | MON | JJ | Year | DOE | Anniv | D1 | D2 | D3 |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DOEIWKIECP | Eligible for Plan
 | 1 | [NAME] | 1980-07-20 00:00:00 | 2005-08-07 00:00:00 |  | 1000 | 1900-01-01 00:00:00 | 2006-08-07 00:00:00 | 8 | 1 | 2007 |  | 2006-08-07 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 3040 | 1920 | eligible
 | 1 | [NAME] | 1977-06-07 00:00:00 | 2005-01-02 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2006-01-02 00:00:00 | 1 | 7 | 2006 |  | 2006-01-02 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00
 | 1 | [NAME] | 1973-03-05 00:00:00 | 2005-06-01 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2006-06-01 00:00:00 | 6 | 7 | 2006 |  | 2006-06-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00
 | 1 | [NAME] | 1976-03-05 00:00:00 | 2005-03-01 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2006-03-01 00:00:00 | 3 | 7 | 2006 |  | 2006-03-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00
 | 1 | Richland | 1970-03-05 00:00:00 | 2004-08-01 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2005-08-01 00:00:00 | 8 | 1 | 2006 |  | 2005-08-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00
 | 1 | Rolette | 1969-03-05 00:00:00 | 2005-06-01 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2006-06-01 00:00:00 | 6 | 7 | 2006 |  | 2006-06-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00
 | 1 | Sargent | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | [NAME] | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Sioux | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Slope | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | [NAME] | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Steele | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Stutsman | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Towner | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Traill |  |  |  | 0
Total Ees | 15
 |  | Date of Hire plus one year nearest date of either July 1 or January 1
 |  | For example [NAME] 1, 2004 Date of Enty will be January 1 2006
 |  | For example DOH June 1, 2005 Date of Entry will be July 1 2006
Spreadsheet: 132549d1323810186-date-time-function-in-excel-day-month-year-and-time-copy-of-test-2
Sheet: Sheet1

Project | Key | Summary | Issue Type | Status | Priority | Resolution | Assignee | Reporter | Created | Updated | Resolved | Total Time (h:[NAME]) | Votes | Images | Original Estimate | Remaining Estimate | Time Spent | Work Ratio | Sub-Tasks | Issue Links | Environment | Description | Security Level | Progress | Σ Progress | Σ Time Spent | Σ Remaining Estimate | Σ Original Estimate | [NAME] | Business Requirement | Proposed Solution | Access by | APAC Country | Keep in SLA ? | Priority Order | Number of comments | Number of attachments | User picker | Solution | Environment | Estimated time | Co-Assignee3 | Co-Assignee4 | Actual Time spent | PlannedEnd | PlannedStart | T.I. Development ? | Gantt | Page | Solution | Justification of priority | Phone Number | Outstanding | Window Login Name | Title | [NAME] | Last Name | [NAME] | Business Impact | Country | Environment | Partner Impacted | Sales Origin | Modified Items | [NAME] Number | Support Tool Bar | First answer date | Last Update by | Request Type | First Name | Channel | Flagged | Effective Date | Epic/Theme | Power User Access? | Rank | Desired date | B2C Group Field | Participants | Reason of Reopening | Days since last comment | Web Site URL | Client Severity
XX | XX | XX | XX | Closed | Minor | XX | XX | XX | 2011-11-28 15:28:00 | 28/11/11 15:55 | 2011-11-28 15:53:00 | 01:37:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES |  | 1 | 0 |  |  |  |  |  |  |  |  |  | NOT APPLICABLE |  |  | B2C |  |  | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-28 15:55:00
Spreadsheet: 835453d1688587946-linking-values-into-an-adjacent-cell-to-choices-in-drop-down-process-calculations-copy
Sheet: mAb Capture

Monoclonal Antibody Batch Fed Process (Membrane Based Pro A)
Bioreactor Volume (L) | 25 |  | Titer (g/L) |  | 5 |  | Total Protein (g)
DSP Consumables
Rapid A Protein A Membrane | DBC (g/L) | 45 |  |  |  |  |  |  |  | Membrane Volume Required Total (L) if 1 Cycle
Rapid A Protein A Membrane (L) | Number of cycles
0.8
Process Step Buffer | [NAME] or MV | Buffer | Buffer Volume (L) Per Cycle |  | Volume of Buffer Total (L) |  |  | Flow Rate (MV/min) | [NAME] (mL/min) | Flow Rate (L/hr) | Process Step Time (min/cycle) | Process Step Time (min total) |  | Process Step Time (min total)
Equilibration | 10 |  |  |  |  |  |  | 5
Wash 1 | 10 |  |  |  |  |  |  | 10
Wash 2 | 10 |  |  |  |  |  |  | 10 |  |  |  |  |  | Process Step Time (hr total)
Elution | 10 |  |  |  |  |  |  | 10
Santization | 10 | NaOH |  |  |  |  |  | 10
Regeneration | 5 |  |  |  |  |  |  | 10 |  |  |  |  |  | Buffer Volume Total (L)
Re-Equilibration | 10 |  |  |  |  |  |  | 10
Monoclonal Antibody Batch Fed Process (Resin Based Pro A)
Bioreactor Volume (L) | 25 |  | Titer (g/L) |  | 5 |  | Total Protein (g)
[NAME]
mAb Select SuRe | DBC (g/L) | 45 |  |  |  |  |  |  |  | [NAME] (L) if 1 Cycle
[NAME] (L) | Number of cycles
Process Step Buffer | [NAME] | Buffer | Buffer Volume (L) Per Cycle |  | Volume of Buffer Total (L) |  |  | Flow Rate (MV/min) | [NAME] (mL/min) | Flow Rate (L/hr) | Process Step Time (min/cycle) | Process Step Time (min total) |  | Process Step Time (min total)
Equilibration | 10 |  |  |  |  |  |  | 5
Wash 1 | 10 |  |  |  |  |  |  | 10
Wash 2 | 10 |  |  |  |  |  |  | 10 |  |  |  |  |  | Process Step Time (hr total)
Elution | 10 |  |  |  |  |  |  | 10
Santization | 10 | NaOH |  |  |  |  |  | 10
Regeneration | 5 |  |  |  |  |  |  | 10 |  |  |  |  |  | Buffer Volume Total (L)
Re-Equilibration | 10 |  |  |  |  |  |  | 10
Resolute Auto Pak columns (i.d.) ([NAME]) | Bed Height (cm) | Volume (L) | Number of cycles to process 10000g | Linear Flow Rate (cm/hr) | [NAME] (L/hr)
40 | 10 |  |  | 300 | 377
60 | 10 |  |  | 300
80 | 10 |  |  | 300
100 | 10 |  |  | 300
120 | 10 |  |  | 300
40 | 20 |  |  | 300
60 | 20 |  |  | 300
80 | 20 |  |  | 300
100 | 20 |  |  | 300
120 | 20 |  |  | 300
Resolute [NAME] columns (i.d.) | Bed Height (cm) | Volume (L) | Number of cycles to process 10000g
30 | 10 |  |  | 300
40 | 10 |  |  | 300
45 | 10 |  |  | 300
60 | 10 |  |  | 300
63 | 10 |  |  | 300
80 | 10 |  |  | 300
30 | 20 |  |  | 300
40 | 20 |  |  | 300
45 | 20 |  |  | 300
60 | 20 |  |  | 300
63 | 20 |  |  | 300
80 | 20 |  |  | 300
Resolute ProChrom columns (i.d.) | Bed Height (cm) | Volume (L) | Number of cycles to process 10000g
15 | 10 |  |  | 300
20 | 10 |  |  | 300
30 | 10 |  |  | 300
45 | 10 |  |  | 300
60 | 10 |  |  | 300
80 | 10 |  |  | 300
100 | 10 |  |  | 300
15 | 20 |  |  | 300
20 | 20 |  |  | 300
30 | 20 |  |  | 300
45 | 20 |  |  | 300
60 | 20 |  |  | 300
80 | 20 |  |  | 300
100 | 20 |  |  | 300
Spreadsheet: 874109d1720675260-fill-automatically-the-cell-if-vinhas-livro8-aligw
Sheet: Folha1

 |  |  |  |  |  |  |  |  |  |  | SHEET 1
 |  |  |  |  |  |  |  |  |  |  | LETTER | [NAME] | NAME | MAIL
 |  |  |  |  |  |  |  |  |  |  | A | X | AAAAAA | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  | B |  | VVVVV | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  | C | X | VVVVV | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  | D |  | FFFFF | [EMAIL]
 |  |  |  |  |  |  |  |  |  |  | E | X | GGGGG
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | SHEET 2
 |  |  |  |  |  |  |  |  |  |  | DATE | D/C | [NAME] | AMOUNT | LETTER | SEND |  | AliGW
 |  |  |  |  |  |  |  |  |  |  | ZZZ | X |  |  | A
 |  |  |  |  |  |  |  |  |  |  | ZZZ |  |  |  | A
 |  |  |  |  |  |  |  |  |  |  | ZZZ | X |  |  | E
 |  |  |  |  |  |  |  |  |  |  | ZZZ |  |  |  | D
 |  |  |  |  |  |  |  |  |  |  | ZZZ |  |  |  | E
 |  |  |  |  |  |  |  |  |  |  | ZZZ |  |  |  | B
 |  |  |  |  |  |  |  |  |  |  | ZZZ | X |  |  | B
 |  |  |  |  |  |  |  |  |  |  | ZZZ |  |  |  | B