tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 61099d1261733427-transfer-sums-in-one-column-based-on-date-to-another-cell-accounting-exception-tracking-sample-6b-
Sheet: Employee Search

6 Month Accounting Exception Tracking |  |  | Tracking Rolling 6 Months
Select Employee: | Employee #1 |  | Month | Exceptions | Points
Track Back: | 180 |  | 2009-01-01 00:00:00
Days with exceptions: |  |  | 2009-02-01 00:00:00
# of Exceptions: |  |  | 2009-03-01 00:00:00
Acception Policy Points: |  |  | 2009-04-01 00:00:00
 |  |  | 2009-05-01 00:00:00
Date | # of Exceptions |  | 2009-06-01 00:00:00
 |  |  | 2009-07-01 00:00:00
 |  |  | 2009-08-01 00:00:00
 |  |  | 2009-09-01 00:00:00
 |  |  | 2009-10-01 00:00:00
 |  |  | 2009-11-01 00:00:00
 |  |  | 2009-12-01 00:00:00
Spreadsheet: 37748d1235760196-flowing-month-data-into-a-chart-based-on-weeks-projectmanhours
Sheet: Project 1

 |  | Project |  | Example
 |  | Project Number |  | 1234500
 |  | Project Duration: |  | 50
 |  | Project Start: |  | 2009-01-01 00:00:00
 |  | Procurement Duration: |  | 24
 |  | Equipment Item Total: |  | 200
 |  | Requisition Total: |  | 26
 |  | Project Phase Ratio:
 |  |  |  | PHASE |  | WEEKS |  | MH RATIO |  | TOTAL
 |  |  |  | Proposal |  | 6 |  | 0 |  | 0
 |  |  |  | Estimate |  | 6 |  | 0.5 |  | 120
 |  |  |  | FEED |  | 24 |  | 1 |  | 960
 |  |  |  | DD |  | 6 |  | 0.5 |  | 120
 |  |  |  | Proc |  | 6 |  | 0.25 |  | 60
 |  |  |  | CloseOut |  | 2 |  | 0.12 |  | 9.6
 |  |  |  |  |  | 50 |  |  |  | 1269.6
 |  |  |  |  |  |  |  |  |  | REQ Man Hours: |  |  | 1300
 |  | [NAME] |  |  |  |  |  |  |  | Phase Man Hours: |  |  | 1269.6
 |  | Calculated Fields |  |  |  |  |  |  |  | Delta: |  |  | 0.02338461538461546
 |  |  |  |  |  |  |  |  |  | ADMIN Man Hours: |  |  | 190.44
 |  |  |  |  |  |  |  | TOTAL MAN HOURS: |  |  |  |  | 1460.04
 |  |  |  |  |  | January |  | 0
 |  |  |  |  |  | February |  | 0.5
 |  |  |  |  |  | March |  | 1
 |  |  |  |  |  | April |  | 0.5
 |  |  |  |  |  | May |  | 0.25
 |  |  |  |  |  | June |  | 0.12
Spreadsheet: 846967d1698090700-return-previous-friday-date-of-a-week-in-the-future-previous-friday-in-future-etaf
Sheet: Sheet1

 |  |  |  | Example #1:
 |  |  |  | Cell B23 = # of weeks in the future to go....let's use 9 weeks
 |  |  |  | 9 weeks * 7 days per week = 63 days
 |  |  |  | Today() = 10/23/2023
 |  |  |  | Today()+(B23*7)= Monday, 12/25/2023
 |  |  |  | Desired result = Friday, 12/22/2023
 |  |  |  | Example #2:
 |  |  |  | Cell B23 = # of weeks in the future to go....let's use 22.5 weeks
 |  |  |  | 22.5 weeks * 7 days per week = 157.5 days
 |  |  |  | Today() = 10/23/2023
 |  |  |  | Today()+(B23*7)= Thursday, 3/28/2024
 |  |  |  | Desired result = Friday, 3/22/2024
 | 9
 | 22.5
Spreadsheet: 819556d1677578453-conditional-format-help-on-highlighted-all-previous-past-dates-help-test-etaf
Sheet: Master View

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
 |  | Approved | Approved | Approved | Approved | 2023-04-30 00:00:00
 |  | Approved | 2022-08-16 00:00:00 | 2022-09-09 00:00:00 | 2023-03-31 00:00:00 |  |  |  |  |  |  | Reviews Next Month
 |  | Approved | Approved | Approved | 2023-03-31 00:00:00 | 2023-04-28 00:00:00
 |  | Approved | Approved | Approved | 2023-06-02 00:00:00 | 2023-07-03 00:00:00 |  |  |  |  |  | Approved
 |  | Approved | Approved | Approved | Approved | 2023-03-31 00:00:00
 |  | Approved | Approved | Approved | Approved | 2023-05-30 00:00:00 |  |  |  |  |  | Date Past
 |  | Approved | Approved | Approved | Approved | 2023-01-30 00:00:00
 |  | Approved | Approved | Approved | Approved | 2023-04-28 00:00:00 |  |  |  |  |  | PMO to Review
 |  | Approved | Approved | Approved | Approved | Approved
 |  | Approved | Approved | Approved | 2023-03-03 00:00:00 | 2023-03-31 00:00:00 |  |  |  |  |  | Submitted to Check Point
 |  | Approved | Approved | Approved | Approved
 |  | Approved | 2023-02-10 00:00:00 | 2023-03-17 00:00:00 | 2024-06-07 00:00:00 | 2024-11-22 00:00:00 |  |  |  |  |  | Submitted to Portfolio Board
 |  | Approved | Approved | Approved | Approved
 |  | Approved | Approved | Approved | 2024-10-14 00:00:00 | 2024-11-12 00:00:00
 |  | Approved | Approved | Approved | Approved | 2023-03-08 00:00:00
 |  | Approved | Approved | Approved | 2023-03-24 00:00:00 | 2023-04-28 00:00:00
 |  | Approved | Approved | Approved | 2023-04-12 00:00:00 | 2023-04-24 00:00:00
 |  | Approved | Approved | Approved | 2023-02-28 00:00:00 | 2023-03-31 00:00:00
 |  | Approved |  | 2022-06-29 00:00:00 | 2023-02-15 00:00:00 | 2023-03-01 00:00:00
 |  | Approved | Approved | 2023-01-31 00:00:00 | 2023-09-22 00:00:00 | 2023-10-31 00:00:00
 |  | Approved | Approved | Approved | 2023-08-16 00:00:00 | 2023-08-31 00:00:00
 |  | Approved | Approved | 2022-11-28 00:00:00 | 2023-12-22 00:00:00 | 2024-03-29 00:00:00
 |  | Approved | Approved | 2022-12-16 00:00:00 | 2023-10-25 00:00:00 | 2023-12-07 00:00:00
 |  | Approved | Approved | Approved | 2023-03-31 00:00:00 | 2023-05-12 00:00:00
 |  | Approved | PMO to Review | 2023-02-28 00:00:00 | 2023-06-23 00:00:00 | 2023-07-24 00:00:00
 |  | Approved | PMO to Review | PMO to Review | 2023-01-20 00:00:00 | 2023-02-20 00:00:00
 |  | 2022-07-01 00:00:00 | 2022-11-30 00:00:00 | 2022-12-16 00:00:00 | 2023-03-01 00:00:00
 |  | Approved
 |  | PMO to Review
Spreadsheet: 22798d1211957460-updating-contents-of-one-worksheet-based-on-criteria-in-another-worksheet-book1
Sheet: Sheet1

Customer ID | Salutation | Forename | Surname | 1st Address
275290 | Miss | [NAME] | [NAME] | 29 Royal Road
9564 | Mr | [NAME] | Arne-Rise | 65 Halton Road
80062 |  | Janeen | [NAME] | 89 [NAME]
3335 | Miss | [NAME] | Batt | 90 Hollyoaks
338546 | Mrs | [NAME] | Beale | 10 Moor Lane
45334 | Mr | [NAME] | Bell | 23 Main Street
643 | Miss | y | Cleves | 332 Low Road
231135 |  | D | Cole | 421 West Road
23452 |  | Will | Keating | 2 The Copse
75345 | Mrs | A. | Kenwright | 207 East Avenue
23489 | Mr | [NAME] | Littleton | 4 Long Marsh
22243 | Mr | [NAME] | [NAME] | 84 South Road
6675 |  | Leanne | Moore | 49 Kiln Road
87877 | Miss |  | [NAME] | 43 Bryony Close
765335 |  | [NAME] | Norton | 10 The Birches
23548 | Miss | Rebecca | [NAME] | 129 Holly Avenue
555 | Miss | [NAME] | Shostakova | 18 Crossley Drive
12 | Mrs | Kath | Sparrow | 99 Telford Rise
957763 | Mr | [NAME] | [NAME] | 9 Park Street
67456 | Mrs | Carol | [NAME] | 101 Central Drive
Spreadsheet: 200268d1355481071-pivot-table-refresh-vba-code-test1
Sheet: Sheet5

Count of Total Quantity (Kilos) |  | Stage
Fruits | Dealer | Stage 1 | Stage 2 | Stage 3 | (blank) | Grand Total
Apple | Dealer 1 |  | 1 |  |  | 1
 | Dealer 3 |  |  | 2 |  | 2
Chickoo | Dealer 1 | 1 |  |  |  | 1
 | Dealer 2 | 1 |  |  |  | 1
Mango | Dealer 1 | 2 |  | 1 |  | 3
 | Dealer 2 |  | 3 |  |  | 3
[NAME] | Dealer 1 |  | 1 | 1 |  | 2
 | Dealer 2 |  |  | 1 |  | 1
(blank) | (blank)
Grand Total |  | 4 | 5 | 5 |  | 14
Spreadsheet: 774488d1648499052-ranking-formula-which-ignores-zeros-has-both-positive-and-negative-values-countifs-and-no-zero
Sheet: Sheet1

 | Product |  |  | Qty | Price | £ | £ Inf
 | BLACK POTS (PIE LIFE) | 0.01 |  | 820 | 0.15 | 123 | 114.8
 | BUTTER (SALTED) 250GM | 1.2 |  | 440 | 1.560909090909091 | 686.8 | 158.8
 | BUTTER (UN-SALTED) 250GM | 41.35 |  | 29 | 49.37241379310345 | 1431.8 | 232.65
 | CORNFLOUR 3KG | 5.45 |  | 52 | 5.397692307692308 | 280.68 | -2.72
 | - | 2 |  | 73 | 1.972602739726027 | 144 | 0
 | GOLDEN SYRUP 7.26KG | 10.5 |  | 30 | 10.15 | 304.5 | -10.5
 | [NAME]) | 2.25 |  | 1686 | 2.330664294187426 | 3929.5 | 136
 | HORSERADISH SAUCE 2.25LTR | 11.95 |  | 4 | 8.95 | 35.8 | -12
 | LARGE CRUMB GLUTEN FREE 10KG (PANKO STYLE) | 32 |  | 32 | 38 | 1216 | 192
Spreadsheet: 216406d1361762284-showing-only-0s-after-decimal-not-true-numbers-worksheet
Sheet: Sheet1

Number of Characters | Line Count | Payment
5000 |  |  |  | Number of Characters per line
6200 |  |  |  | 65
4000 |  |  |  | Paymnet Per Line
7500 |  |  |  | 0.1
1100
1674
97600
124000
Spreadsheet: 153225d1335808721-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: MAY 9

DATE | MON | TUES | WED | THUR | FRI | SAT
 | 2011-05-09 00:00:00 | 2011-05-10 00:00:00 | 2011-05-11 00:00:00 | 2011-05-12 00:00:00 | 2011-05-13 00:00:00 | 2011-05-14 00:00:00
[NAME] |  | 9:30-5:30 | 8:00-5:00 | 9:00-5:00 | 8:30-5:30 | 9:15-5:15
 | off | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00
[NAME] | 8:30-5:30 | 8:30-5:30 | 9:30-5:30 | 8:30-5:30 | 9:30-5:30 | off
 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | off
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | 8:00-4:00
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | off
Mark | 8:30-5:30 | 9:00-5:00 | 8:30-5:30 | 8:30-5:30 |  | 9:00-5:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | off | 1:00-2:00
[NAME] | 8:00-4:00 | off | 8:30-5:30 | 7:00-4:00-HOMER | 8:00-5:00 | 9:15-5:15-ctr
 | 11:00-12:00 | off | 11:00-12:00 | 1ub | 11:00-12:00 | 11:00-12:00
Spreadsheet: 754114d1635952048-return-3-column-values-if-criteria-met-sample-workbook
Sheet: Sheet1

Member Code | Name | Destination | Week 1 | Week 2 | Week 3
1 | [NAME] | London | 1
1 | [NAME] | [NAME] |  | 2
2 | [NAME] | Reading | 1
3 | [NAME] | Edinburgh |  |  | 3
4 | [NAME] | Preston | 1
4 | [NAME] | Dawlish |  |  | 3
Current Week | 3
3 | [NAME] | Ediburgh
4 | [NAME] | Dawlish
Spreadsheet: 471afa5d-e89a-448b-b6b5-e64f668d19ea
Sheet: Weekly Year Planner

2012 |  | MON | TUE | WED | THU | FRI | SAT | SUN
Spreadsheet: 221028d1363351393-start-counting-if-date-is-not-in-past-book11
Sheet: Sheet1

Date Arived | Last day to finish | High | Days counting | Audit date | Should be
2013-02-19 00:00:00 | 2013-03-11 00:00:00 | no | 14 | 2013-06-30 00:00:00 | should be 18/07/2013 (14 working days) and [NAME] (5 working days)
2013-03-08 00:00:00 | 2013-03-15 00:00:00 | yes | 5 | 2013-04-30 00:00:00 | should be 20/05/2013 (14 working days), 07/05/2013 (5 working days0
2013-03-07 00:00:00 | 2013-03-27 00:00:00 | no | 14 | 2012-12-31 00:00:00 | is correct
Spreadsheet: 33962d1230929158-new-idea-on-creating-excel-files-to-automatically-determine-proper-entry-john-eastland-example-sheet-with-edward-bentley-sum-if-function-later-version-of-excel-revised
Sheet: Assets

 | Asset Review/Prohibited Transaction:
 |  |  |  |  |  |  |  | Value Per
 |  |  |  |  |  | Value Per |  | Schedule I
 |  |  |  |  |  | Statement |  | on 5500
 | Asset Description |  |  |  |  | @ 12/31/06 |  | @ 12/31/07
 |  | Description of Asset:
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  | Subtotal
 |  | Description of Asset:
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  | Subtotal
 |  | Total |  |  |  | 0 |  | 0
Spreadsheet: hunter_shively__12662__Nov_01 Volume Changes
Sheet: Nov 3-5

Pipeline | Producer | Zone | Current Volume | New Volume | Change | Index | GDA | Fixed | Comments
[NAME] | Forest | [NAME] | 0 | 207 |  |  | 207
NGPL | Orion | LA | 100 | 0 |  |  | -100
NGPL | Orion | TXOK | 500 | 0 |  |  | -500
SNAT | Forest | Z0 | 0 | 207 | 207 |  | 207
STINGRAY | Min Mgmt | Holly Beach | 65410 | 66139 | 271 |  | 271
STINGRAY | Flextrend | Holly Beach | 2500 | 1608 |  | -392 | -500 |  | Will be back up on 11/6 to 2500
TENN | Torch | ZN 0, 100 | 0 | 50 |  |  | 50
TENN | Cabot | ZL, 500 | 18000 | 16000 |  | -1000 | -1000
TETCO | W&T | WLA | 2600 | 2382 |  | -218
TRUNKLINE | Forest | ELA | 14164 | 15250 |  |  | 1086
 |  |  |  |  | Day Total
 |  |  |  |  | MTD Total | -32808 | -7006
Spreadsheet: 539104d1505964867-keeping-only-the-top-value-of-a-group-of-ids-countif-to-filter-our-dups-after-sort
Sheet: Sheet1

ID | [NAME] | Max of PROM | Helper |  |  |  |  |  | Helper |  | ID | [NAME] | Max of PROM | Helper |  |  |  |  | ID | [NAME] | Max of PROM
888888 | CR | 29 |  |  | 1 Add Helper Column with formula |  |  |  | 1 |  | 888888 | CR | 29 | 1 |  |  |  |  | 0002301 | CR | 12
0002301 | CR | 12 |  |  | 2. Sort data by [NAME] to Small |  |  |  |  |  | 0002301 | CR | 12 | 1 |  |  |  |  | 45646 | [NAME] | 9
444444 | [NAME] | 12 |  |  | 3. Do [NAME] using Helper = 1 |  |  |  |  |  | 444444 | [NAME] | 12 | 1 |  |  |  |  | 54645564 | [NAME] | 10
888888 | CR | 12 |  |  |  |  |  |  |  |  | 789456 | CR | 11 | 1 |  |  |  |  | 54888 | [NAME] | 10
789456 | CR | 11 |  |  |  |  |  |  |  |  | 54645564 | [NAME] | 10 | 1 |  |  |  |  | 123456 | CR | 4
54645564 | [NAME] | 10 |  |  |  |  |  |  |  |  | 54888 | [NAME] | 10 | 1 |  |  |  |  | 789456 | CR | 11
54888 | [NAME] | 10 |  |  |  |  |  |  |  |  | 456123 | CR | 10 | 1 |  |  |  |  | 456123 | CR | 10
456123 | CR | 10 |  |  |  |  |  |  |  |  | 45646 | [NAME] | 9 | 1 |  |  |  |  | 963963 | CR | 8
45646 | [NAME] | 9 |  |  |  |  |  |  |  |  | 963963 | CR | 8 | 1 |  |  |  |  | 444444 | [NAME] | 12
789456 | [NAME] | 8 |  |  |  |  |  |  |  |  | 777777 | PA | 8 | 1 |  |  |  |  | 777777 | PA | 8
963963 | CR | 8 |  |  |  |  |  |  |  |  | 123456 | CR | 4 | 1 |  |  |  |  | 888888 | CR | 29
777777 | PA | 8
123456 | CR | 4
123456 | [NAME] | 2
963963 | [NAME] | 2
45646 | CR | 1
456123 | PH | 1
Spreadsheet: 39153d1237351117-counting-data-from-columns-mlbbetsystem-version-5-
Sheet: Totals

Units Needed |  | 91 |  |  | [NAME]
 | Unit | 250
 | [NAME] | -165 | Gm 1 | Gm 2 | Gm 3 | Total | Avg Unit
 | Data Avg
 |  |  |  | 6 | months
 |  |  |  | 27 | games a month |  |  |  | [NAME]
 |  |  | total games |  | 162 | Avg W PCT |  |  | 2.38
 |  |  |  | Wins | 152
 |  |  |  | Losses | 10
 |  |  |  |  | Units Won
 |  |  |  |  | Cash Won
 |  |  |  |  | Per Month
 |  |  |  |  | Per Week
 |  |  |  |  | Per Series
Spreadsheet: 65123d1265854188-vlookup-with-potential-for-multiple-matches-mail-test-mod
Sheet: Team R

Emp Name | ID | Count | CN 1 | CN 2 | CN 3 | CN 4 | CN 5
 | LD0P | 2 | 156581530 | 156581531
 | MKNB | 2 | 156553737 | 156553738
 | MMFV | 0
 | [NAME] | 0
 | LWWB | 0
 | DZ8L | 0
 | MQFR | 0
 | L7C6 | 0
 | LTKP | 0
 | MP3V | 0
 | MDNY | 0
 | [NAME] | 0
 | [NAME] | 0
 | LLPX | 0
 | LS9H | 0
 | MX5M | 0
 | L3NM | 0
 | LXCR | 0
 | MP43 | 0
 | MQSY | 0
 | LPC1 | 0
 | L4RF | 0
 | MKPM | 0
 | MS9D | 0
 | MRGP | 0
 | MKM8 | 0
 | MGFN | 0
 | LTHS | 0
 | L79Y | 0
 | LXLT | 0
 | L069 | 0
 | MTK8 | 0
 | MX5N | 0
Spreadsheet: 153ea10a-9dc4-4b2e-8dd2-efeebd477453
Sheet: Sheet1

Department of Environment and Natural Resources: Hurricane XXXXXXX Damage Estimation Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  | TYPE OF DAMAGE
Division | Facility | County | Debris Removal | Emergency Work and Protective Measures | [NAME] | Dams Levees | Building or [NAME] | Public Utilities Water Electric | Recreation Facilities | Total Estimated Damage
Example
[NAME] | Umstead SP | Wake | 100000 | 0 | 50000 | 0 | 25000 | 0 | 0 | 175000
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Division Total |  |  | 100000 | 0 | 50000 | 0 | 25000 | 0 | 0 | 175000
Division Contact: |  |  |  |  |  | [NAME]:
Telephone Number: (w) |  |  |  |  |  | Telephone Number: (c)
Spreadsheet: 0e7ce6ab-e5d2-4b10-8ef1-6b3562ae904a
Sheet: Compendex(EI)

Compendex (Engineering Index)
2009-2010
COUNTER-Compliant?: | Yes (R2)
 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total | 2009-2010 Price | Price per unit
Compendex
Sessions | 55 | 27 | 69 | 91 | 435 | 61 | 19 | 44 | 74 | 67 | 188 | 167
Searches | 163 | 67 | 251 | 385 | 4112 | 243 | 77 | 186 | 228 | 222 | 38 | 46 |  | 16877
Spreadsheet: 677d79ba-5924-4b99-a7db-edb9cd8e2e19
Sheet: qRT-PCR primers

Primers used for qRT-PCR.
Gene ID | Primer Name | Sequence (5’ to 3’)
AAEL007768 | RT MyD88 F | GGCGAGGGTTGTTTCAAGTA
AAEL007768 | RT MyD88 R | TCCCATCTGTCGATTAAGCC
AAEL010083 | RT IMD F | TCATTCCGCGAAGGGCTGGC
AAEL010083 | RT IMD R | AGCGCAGAAACATCGTTCGCA
AAEL012471 | RT Dome 2F | AAACGGTGGCAAAATGAACT
AAEL012471 | RT Dome 2R | CTCCAGACCGGTGAGATTGT
AAEL006794 | RT Dcr2 F | CAATTGCTACCGTTGGGAGT
AAEL006794 | RT Dcr2 R | ATTGATCCCCCAAAAAGACC
AAEL011414 | RT HMGB F | CTGTGGCTCAACTCTGCCCGC
AAEL011414 | RT HMGB R | AGCTCACCACCTCGCTTGGC
AAEL010429 | [NAME] | ACGAAACGGTTGCTTTATTGCCTCT
AAEL010429 | [NAME] | GCCATCCACATCGAGTCCGTAGC
AAEL012819 | [NAME] | CAGCTGCTGGCCGCTGAGAA
AAEL012819 | [NAME] | TTTAGACGGCGGGCCTTGCG
AAEL002579 | RT HP2579 F | GACGTCCACGGGATATGCAA
AAEL002579 | [NAME] | TCATCCGTTTCCTTCGCACT
AAEL002430 | RT N-Gluc F | GTTACGGATGCCATTTCGGC
AAEL002430 | RT N-Gluc R | TTTAAGCGTGCCCTTCTGGT
AAEL010599 | RT a-Gluc F | ATCGTATAAGACGCGCAGCA
AAEL010599 | RT a-Gluc R | CCAACCAACTCTTCGTCGGA
AAEL012092 | RT LRRprot F | CCGGAGGTACCGAGAGCCCA
AAEL012092 | [NAME] | TCGTCCCCTAGCGGCTTCCA
AAEL015458 | RT Tsf F | TCGTGATGTCCGTCCGGCCT
AAEL015458 | [NAME] | CGCTGGTGGATGTTGCGGGT
AAEL002833 | RT CatL F | TGGAGCGACCGACAAGGGCT
AAEL002833 | RT CatL R | CCCCAGGTGGTTCCCCACGA
AAEL004758 | [NAME] | CCGATGGCCACCACCGCATT
AAEL004758 | [NAME] | TGGCGTGGTGAACTGGAGCC
AAEL009496 | [NAME] | GCAGACCACCATTGAACACA
AAEL009496 | [NAME] | CACGTCCGGTCAGCTTCTTG
Spreadsheet: 62840d1263843877-calculate-age-retire-date-calculate-age
Sheet: Sheet1

NAME | D,O,B | AGE NOW | RETIREMENT DATE
A | 1945-06-06 00:00:00 | 64 | 2010-06-05 06:00:00
F | 1947-06-28 00:00:00 | 62 | 2012-06-26 06:00:00 |  |  | Retirement date should be 27/06/2012
B | 1947-06-29 00:00:00 | 62 | 2012-06-27 06:00:00 |  |  | Retirement date should be 28/06/2012
C | 1950-06-01 00:00:00 | 59 | 2015-05-31 06:00:00
D | 1960-06-01 00:00:00 | 49 | 2025-05-31 06:00:00
E | 1980-09-20 00:00:00 | 29 | 2045-09-19 06:00:00
 | 1990-09-19 00:00:00
Spreadsheet: 823819d1680155160-copy-if-not-isblank-formula-in-multiple-cells-of-spreadsheet-at-one-time-matrix-excel-help-
Sheet: MasterList

1 | Test 1
2 | Test 2
3 | Test 3
4 | Test 4
5 | Test 5
6 | Test 6
7 | Test 7
8 | Test 8
9 | Test 9
10 | Test 10
11 | Test 11
12 | Test 12
13 | Test 13
14 | Test 14
15 | Test 15
16 | Test 16
17 | Test 17
18 | Test 18
19 | Test 19
20 | Test 20
21 | Test 21
22 | Test 22
23 | Test 23
24 | Test 24
25 | Test 25
26 | Test 26
27 | Test 27
28 | Test 28
29 | Test 29
30 | Test 30
Spreadsheet: 771880d1646905555-sensitivity-table-not-producing-the-right-figures-for-a-dcf-model-sensitivity-analysis-help
Sheet: Sheet1

[NAME]
Assumptions
Valuation Date | 2022-02-28 00:00:00
Discount rate | 0.15
Terminal growth rate | 0.03
Tax rate | 0
Discounted Cash Flow |  |  |  |  |  |  |  |  |  |  |  | Terminal Year
Start Date |  |  | 2023-01-01 00:00:00
End Date |  | 2022-12-31 00:00:00
Discount Period
Project 1 |  | 6800000
Project 2 |  | 14800000
Project 3 |  | 8300000.000000001
Project 4 |  | 8800000
Total Revenue
Total expenses
EBIT
Tax expense
NOPAT
D&A |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAPEX |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Change in net working capital |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Free cash flow to firm (FCFF)
Discount factor
Dicounted cash flow
Enterprise Value
Internal rate of Return
Terminal value/ Valuation
Non-operating item adjustments:
[OPEN]
Projection Assumptions
Revenue Growth |  |  | 0.7 | 0.5 | 0.3 | 0.2 | 0.1 | 0.08 | 0.06 | 0.04 | 0.03
EBIT Margin |  | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7
Sensitivity Analysis
 |  |  |  |  |  | Terminal growth rate
 |  |  |  |  | 628967769.4958 | 628967769.4958 | 643405297.1791521 | 678467864.4101499
 |  |  |  | 598257297.4327748 | 586302868.6951219 | 586302868.6951219 | 598257297.4327748 | 626947926.4031417
 |  | Discount rate |  | 598257297.4327748 | 586302868.6951219 | 586302868.6951219 | 598257297.4327748 | 626947926.4031417
 |  |  |  | 643405297.1791521 | 628967769.4958 | 628967769.4958 | 643405297.1791521 | 678467864.4101499
 |  |  |  | 754314824.6453079 | 732724288.9694335 | 732724288.9694335 | 754314824.6453079 | 808291163.8349938
Spreadsheet: 715735d1611846581-help-reducing-the-amount-of-formulas-to-show-the-sum-attendance-sample-for-excel-help
Sheet: Team Dashboard

Enter the year | à | YEAR |  | See Data Table More than 1 Time Entry |  |  |  |  | Holiday |  |  |  | Weekends |  |  |  |  | NA / Not Employed
 |  | 2021
Enter the month | à | MONTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTHLY SUMMARY
 |  | January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1> |  |  |  |  |  |  |  | Total Negative | Work Days
Spreadsheet: 704619d1605646545-trying-to-count-unique-values-in-every-nth-row-of-a-column-sample-file-for-uniques
Sheet: Sheet1

Bedragen | Vlag
1978166.926952917
19771.80324132372
0.0555 |  | What I'm trying to do is evaluate the values in every 3rd row of Column A
1898576.926952917 |  | (rows 1,4,7,10, and so on) and count the number of unique values in those cells.
19276.20324132372
0.04650000000000001 |  | If I did it right, I believe the correct answer should be 9 for the number of unique values in those cells
1989536.926952917
19842.60324132373
0.2445 |  |  |  | Manually Derived Answer
1870151.926952917 |  |  |  | by plucking every 3rd row value |  |  |  |  | Vlag | 2
19099.20324132372
0.0375 |  |  |  |  |  |  |  |  | Bedragen | Count of Bedragen |  | #[NAME]
2006591.926952917 |  |  |  | 1870151.926952917 |  |  |  |  | 1870151.926952917 | 1
19948.80324132372 |  |  |  | 1898576.926952917 |  |  |  |  | 1898576.926952917 | 1
0.0735 |  |  |  | 1909946.926952917 |  |  |  |  | 1909946.926952917 | 1
1921316.926952917 |  |  |  | 1921316.926952917 |  |  |  |  | 1921316.926952917 | 1
19417.80324132372 |  |  |  | 1961111.926952917 |  |  |  |  | 1961111.926952917 | 1
-0.02549999999999999 |  |  |  | 1978166.926952917 |  |  |  |  | 1978166.926952917 | 2
1909946.926952917 |  |  |  | 1978166.926952917 |  |  |  |  | 1989536.926952917 | 1
19347.00324132372 |  |  |  | 1989536.926952917 |  |  |  |  | 2000906.926952917 | 1
0.1725 |  |  |  | 2000906.926952917 |  |  |  |  | 2006591.926952917 | 1
1961111.926952917 |  |  |  | 2006591.926952917 |  |  |  |  | Grand Total | 10
19665.60324132373
0.0375 |  |  |  | Correct Answer equals 9
1978166.926952917
19771.80324132372
0.0735
2000906.926952917
19913.40324132373
-0.09299999999999999