tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: cfcf1cc7-3c8f-47c4-84b0-3c27d2e6c377
Sheet: Sheet1

COURT OF CHANCERY COURTROOM CALENDAR FOR THE WEEK OF DECEMBER 1, 2014 THROUGH DECEMBER 5, 2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
TIME | CASE # | JUDGE | PROCEEDING | CASE CAPTION | SITE
Monday, December 1, 2014
09:30:00 | CA#8283-VCG | Vice Chancellor Glasscock | Trial | Estate of George Reed, Jr.  v. [NAME] | Georgetown
02:00:00 | CA#9039-VCP | Vice Chancellor Parsons | Oral Argument | Laborers v. [NAME] | [NAME]
Tuesday, December 2, 2014
09:30:00 | CA#8283-VCG | Vice Chancellor Glasscock | Trial | Estate of George Reed, Jr.  v. [NAME] | Georgetown
10:00:00 | CA#8784-VCL | Vice Chancellor [NAME] | Oral Argument | Montgomery v. Erickson Air-Crane, Inc., et [NAME]. | [NAME]
10:00:00 | CA#9539-MA | Master [NAME] | Hearing | Cecil Bank v. [NAME] and Melody Gabard | [NAME]
02:00:00 | CA#6476-CB | Chancellor [NAME] | Hearing | In re Puda Coal Inc. | [NAME]
02:00:00 | CA#9873-MA | Master [NAME] | Hearing | Wells Fargo v. Barker | Dover
Wednesday, December 3, 2014
09:15:00 | CA#8031-VCL | Vice Chancellor [NAME] | Trial | Fox v. CDX Holdings, Inc. | [NAME]
09:30:00 | CA#8283-VCG | Vice Chancellor Glasscock | Trial | Estate of George Reed, Jr.  v. [NAME] | Georgetown
02:00:00 | CA#9380-VCP | Vice Chancellor Parsons | Oral Argument | CSH Theatres LLC v. [NAME] San Francisco | [NAME]
Thursday, December 4, 2014
09:15:00 | CA#8031-VCL | Vice Chancellor [NAME] | Trial | Fox v. CDX Holdings, Inc. | [NAME]
09:30:00 | CA#9448-ML | Master [NAME] | Hearing | Koeller v. [NAME] | [NAME]
10:00:00 | CA#8270-VCG | Vice Chancellor Glasscock | Oral Argument | The Sequoia Presidential Yacht Group v. FE Partners | Georgetown
10:30:00 |  | Master [NAME] | Guardianship Hearing |  | [NAME]
01:00:00 | CA#8476-VCG | Vice Chancellor Glasscock | Settlement Hearing | Hall v. Berry Petroleum Co. | Georgetown
Friday, December 5, 2014
09:15:00 | CA#8031-VCL | Vice Chancellor [NAME] | Trial | Fox v. CDX Holdings, Inc. | [NAME]
09:30:00 | CA#9047-ML | Master [NAME] | Trial | [NAME] v. Paolino | [NAME]
09:30:00 |  | Master [NAME] | KC Petitions |  | Georgetown
10:00:00 | CA#10052-CB | Chancellor [NAME] | Hearing | University of Delaware v. [NAME] | [NAME]
10:00:00 | CA#4353-VCP | Vice Chancellor Parsons | Oral Argument | Choice Hotels v. Columbus-Hunt Park | [NAME]
11:00:00 | CA#9985-CB | Chancellor [NAME] | PI Hearing | In re Family Dollar | [NAME]
01:00:00 | CA#10004-VCG | Vice Chancellor Glasscock | Oral Argument | WSFS v. Caesars Entertainment | Georgetown
Spreadsheet: eric_saibi__9869__101901R
Sheet: Duane Arnold 01

Owner Name |  | Alliant-IES Utilities Inc.
Station Name |  | [NAME]
Unit Name |  | [NAME] 01
NERC Region |  | MAIN
State |  | IA
Fuel Type |  | Nuclear
Capacity |  | 597 MW
Start Date |  | 2001-10-17 00:00:00
End Date |  | 2001-10-21 00:00:00
Prv. Start Date |  | 2001-10-17 00:00:00
Prv. End Date |  | 2001-10-20 00:00:00
Comments |  | Electrical problem.  Unit is hoping to come back on line on Sunday.
SIC |  | 4911
Plant ID |  | 1012744
Unit ID |  | 1004913
Outage ID |  | 18671
Spreadsheet: 868376d1715106361-how-to-set-a-minimum-value-that-uses-a-second-cell-if-the-theshold-isnt-met-sample-excel
Sheet: Sheet 1

# | Task | Billable  (in hour) | Unbillable  (in hour) | Frequency | Total B | Total [NAME]
1 |  | 1.5 | 1 | Once
2 |  | 0.75 | 0 | Weekly
3 |  | 0.5 | 0 | Weekly
4 |  | 0.5 | 0 | Weekly
5 |  | 1 | 0 | Weekly
6 |  | 2 | 3 | Once
7 |  | 0 | 0 | Part of 5
8 |  | 1 | 0 | Monthly
9 |  |  | 0 | Twice-a-month
10 |  | 4 | 0 | Once
11 |  | 1 | 1 | Once
Total
 | Contingency (+/-10%)
 |  |  |  | Grand Total (in hours) |  | Billable Hours
 |  | Parameters |  | Grand Total (in days) |  | Billable Days
 | Project Duration | 10 | Workdays
 | Calculated |  | Weeks
 | Calculated |  | Months
 | # of Team Members | 1 | Person |  | PM% (Billable only)
 | Total non-PM Effort | 40 | Hours
 |  |  |  |  | PM% (Billable + Unbillable)
Frequency Dropdown List
Once
Daily
Twice-a-week
MWF
Weekly
Bi-weekly
Monthly
Twice-a-month
None
Spreadsheet: 673082d1587148886-client-names-in-2-different-formats-how-to-match-them-sample-excel-forum
Sheet: Q2 2020 Report

Name | [NAME] | Quote
[NAME] | MK | 9.84
[NAME] and [NAME] | JW | 2845.76
[NAME] and [NAME] | MK | 192.08
[NAME] and [NAME] | JM | 1283.52
Davidson, Alan & Rosalee | JM | 134.3
Dirk & Gayle Taylordean | JM | 3858.05
Dr. and Mrs. [NAME] | JM | 208.22
Florence, Tim & Mary Ellen | JM | 745.89
[NAME] and [NAME], Jr. | JM | 1259.56
Hill, Charles & Eileen | MK | 434.96
[NAME] | CA | 8.55
[NAME] and [NAME] | MK | 3672.32
[NAME] | CA | 2486.82
[NAME] and [NAME] | JM | 4026
[NAME] | MK | 2365.46
Mr. [NAME] | MK | 1114.92
Mr. and  Mrs. [NAME] | CA | 3834.15
Spreadsheet: 97718ec6-30e0-4f79-bc82-e2ba01f9282d
Sheet: 1.2 Unemployment

1.2 Unemployment
Month | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014-15
Number unemployed (a) – '000
July | 603.182741 | 602.3246046 | 623.4746616 | 691.5330541 | 756.0662171
August | 600.1460406 | 609.8689971 | 629.5959317 | 693.3808402 | 764.1068613
September | 598.4260619 | 614.8089582 | 635.4038635 | 696.7527575
October | 596.9565557 | 617.10353 | 640.1820504 | 702.5843459
November | 594.4030424 | 616.8352078 | 644.8757459 | 709.8147841
December | 590.7835308 | 614.8448696 | 650.2869811 | 716.6711127
January | 587.0786073 | 612.7278321 | 656.6787954 | 721.1475607
February | 583.6972282 | 612.0487351 | 664.1138963 | 723.9035986
March | 581.6932278 | 611.7621136 | 672.3458967 | 726.8262598
April | 583.2268698 | 612.0165384 | 680.1329586 | 731.2842695
May | 587.8607831 | 614.0748069 | 685.5744956 | 738.2145547
June | 594.417421 | 618.155171 | 689.131516 | 747.0561297
Annual average | 590.6837662416666 | 613.8477528583334 | 656.180680075 | 715.4627143000001
Unemployment rate (a) – per cent
July | 5.1891878 | 5.0965262 | 5.2047929 | 5.6854103 | 6.1089818
August | 5.1491766 | 5.1527874 | 5.2510637 | 5.7003113 | 6.1611059
September | 5.1207975 | 5.1882293 | 5.2933892 | 5.7272386
October | 5.0962325 | 5.2029648 | 5.3254722 | 5.7721505
November | 5.0649034 | 5.1976702 | 5.3554219 | 5.8250739
December | 5.0272874 | 5.1774236 | 5.3903006 | 5.872204
January | 4.9914041 | 5.1542701 | 5.4331202 | 5.89852
February | 4.9603305 | 5.1410443 | 5.4844582 | 5.9112523
March | 4.9417676 | 5.1304925 | 5.5430582 | 5.9249138
April | 4.9522668 | 5.1250691 | 5.5997338 | 5.9496965
May | 4.9873324 | 5.1358899 | 5.6400023 | 5.9930104
June | 5.0367793 | 5.1648035 | 5.6668558 | 6.0505401
Annual average | 5.03240742626741 | 5.161626080658025 | 5.434741129533969 | 5.851508982704346
(a) Monthly figures are trend. Annual figures are from the original series.
 |  |  |  |  |  |  |  | Update
Source: ABS, Labour force, Cat. no. 6202.0 |  |  |  |  |  |  |  | 2014-10-10 00:00:00
Spreadsheet: kevin_presto__19790__proposed Enron transaction 7-2-01
Sheet: Entergy

Schedule of Entergy Transactions
 | DETM | EPMC |  | 7/09/01 to
 | MWs | MWs |  | 2001-08-31 00:00:00 |  | Jul/Aug '02 |  | Jul/Aug '03 |  | Jul/Aug '04
2001-07-09 00:00:00 | -250
 | -250
 | -200
 | -150
 | -150
 | -150
 | -100
2001-07-10 00:00:00 | 250
 | 250
 | 200
 | 200
 | 150
 | 100
 | 100
2001-07-11 00:00:00 | -250
 | -250
 | -200
 | -150
 | -150
 | -150
 | -100
2001-07-12 00:00:00 | 250
 | 250
 | 200
 | 200
 | 150
 | 100
 | 100
Spreadsheet: kimberly_watson__20556__imbalsumm0109
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 28554 | 33234 | 33359 | 35317
2 | 15625 | 16488 | 35760 | 37983 |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 28573 | 29845 | 33221 | 34952 |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 25754 | 30000 | 32149 | 33000 |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 |  |  |  |  |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 |  |  |  |  |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
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-08-31 00:00:00 |  | 441785.89 |  | 100797.53
2001-09-04 00:00:00
CBS Volume
 |  |  | 69826
Spreadsheet: 07a9d209-f8c0-4120-8ef6-53f972662669
Sheet: Sheet1

College Application Record | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | School Name | School Name | School Name | School Name | School Name
GENERAL INFORMATION
Location
City, suburban, small town
Size
Major
REQUIREMENTS
SAT minimum
SAT II?
GPA
Essay requirements
Other
APPLYING
Web address
Application fee
Application due date
Date transcript sent
Date application sent
Accepted?
FINANCES
Yearly tuition & fees
Room & board
Books & supplies
Miscellaneous
Estimated total | 0 | 0 | 0 | 0 | 0
FINANCIAL AID
Fin. aid forms required
Fin. aid. priority app. date
Spreadsheet: 730820d1619970323-find-the-percentage-a-cell-is-in-a-time-range-and-the-average-time-within-each-5x20-strategy-tms
Sheet: RESULTS (v2)

 | TIME TRADED %
 |  |  |  |  | Much shorter formula …
 | 06:00:00 | 08:59:00
 | 09:30:00 | 09:49:00
 | 09:50:00 | 10:29:00
 | 10:30:00 | 11:29:00
 | 11:30:00 | 14:59:00
 | 15:00:00 | 16:00:00
 | GAIN/LOSS
 | Trading Days Span |  | 53
 | Trading Days
 | Trading Days %
 | Total Wins
 | Total Points /share
 | Average Points /share |  |  |  | Excluding top 2 and bottom 2
 | Win/Loss % |  |  |  | Note, this is Win % on days there was a 5x20 strategy win
 | ENTRY REASON %
 | PM CONSOLIDATION
 | R2G
 | MOMO
 | CONSOLIDATION
 | PMH
 | BO
 | HIGHS %
 | Entry-High Ave |  |  |  | Percentage High above Entry
 | High-Close Ave |  |  |  | Percentage High above Close
Spreadsheet: benjamin_rogers__1193__Calpine version 1
Sheet: Debt

DEBT ISSUANCE | (This page is set up to solve for Debt Principal given DSCR, by using the Goal Seek Button)
('000 $)
EBITDA by Debt Fiscal Year
DSCR | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3
Target DS
Debt Principal | 76645.68252824584
Ending Balance at Maturity
 | 2001-04-01 00:00:00 | 2002-04-01 00:00:00 | 2003-04-01 00:00:00 | 2004-04-01 00:00:00 | 2005-04-01 00:00:00 | 2006-04-01 00:00:00 | 2007-04-01 00:00:00 | 2008-04-01 00:00:00 | 2009-04-01 00:00:00 | 2010-04-01 00:00:00 | 2011-04-01 00:00:00 | 2012-04-01 00:00:00 | 2013-04-01 00:00:00 | 2014-04-01 00:00:00 | 2015-04-01 00:00:00 | 2016-04-01 00:00:00 | 2017-04-01 00:00:00 | 2018-04-01 00:00:00 | 2019-04-01 00:00:00 | 2020-04-01 00:00:00 | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2023-04-01 00:00:00 | 2024-04-01 00:00:00 | 2025-04-01 00:00:00 | 2026-04-01 00:00:00 | 2027-04-01 00:00:00 | 2028-04-01 00:00:00 | 2029-04-01 00:00:00 | 2030-04-01 00:00:00 | 2031-04-01 00:00:00 | 2031-05-01 00:00:00
Beginning Balance
Addition |  | 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
Principal Payment
Interest Payment
Ending Balance
Pro-rata EBITDA
DSCR
(Debt Anniversary) | 2001-10-01 00:00:00 | 2002-10-01 00:00:00 | 2003-10-01 00:00:00 | 2004-10-01 00:00:00 | 2005-10-01 00:00:00 | 2006-10-01 00:00:00 | 2007-10-01 00:00:00 | 2008-10-01 00:00:00 | 2009-10-01 00:00:00 | 2010-10-01 00:00:00 | 2011-10-01 00:00:00 | 2012-10-01 00:00:00 | 2013-10-01 00:00:00 | 2014-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-10-01 00:00:00 | 2017-10-01 00:00:00 | 2018-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-10-01 00:00:00 | 2021-10-01 00:00:00 | 2022-10-01 00:00:00 | 2023-10-01 00:00:00 | 2024-10-01 00:00:00 | 2025-10-01 00:00:00 | 2026-10-01 00:00:00 | 2027-10-01 00:00:00 | 2028-10-01 00:00:00 | 2029-10-01 00:00:00 | 2030-10-01 00:00:00 | 2031-05-01 00:00:00
Beginning Balance
Addition | 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
Principal Payment
Interest Payment
Ending Balance
Pro-rata EBITDA
DSCR
Beginning Balance
Addition | 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
Interest Payment
Ending Balance
Debt Service
Principal Payments
Interest Expense
Net Debt Service
ACTUAL DSCR
Accrued Debt Service
Principal Payments
Interest Expense
Net Debt Service
 | Debt Summary
 | Treasury (%)
 | Spread (%)
 | All In Coupon Rate (%)
 | Term (years)
 | Average Life (years)
 | Total amount ($ '000)
 | DSCR |  | Average
 |  |  | Minimum
Time Factor | 0
Average Life
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 12a

Product1 | Cleared2 | Uncleared | TOTAL
Cross_Currency Basis | - | 6739 | 6739
Cross_Currency Fixed-Fixed | - | 1029 | 1029
Cross_Currency Fixed-Float | - | 714 | 714
TOTAL | - | 8482 | 8482
Spreadsheet: 552132d1513306447-issue-dealing-with-simple-excel-issue-formula-and-pivot-s666-exercise
Sheet: Pivot

Count of Customer |  |  |  | Count of Customer
Ind | Customer | Total |  | Ind | Customer | Total | [NAME]
ACAD | BMSI -Biomedical Sciences Institute | 4 |  | ACAD | BMSI -Biomedical Sciences Institute | 4
 | BMSI -Biomedical Sciences Institute R | 1 |  | ACAD | BMSI -Biomedical Sciences Institute R | 1
 | Nanyang Technological University | 3 |  | ACAD | Nanyang Technological University | 3
 | Nanyang Technological University-RRR | 1 |  | ACAD | Nanyang Technological University-RRR | 1
 | Singapore Polytechnic | 1 |  | ACAD | Singapore Polytechnic | 1
ACAD Total |  | 10 |  | ACAD Total |  | 10
OTRS | Cesco Environmental Technologies Pte Ltd | 4 |  | OTRS | Cesco Environmental Technologies Pte Ltd | 4
OTRS Total |  | 4 |  | OTRS Total |  | 4
PHAR | [NAME] | 2 |  | PHAR | [NAME] | 2
 | [NAME], Singapore Branch | 5 |  | PHAR | [NAME], Singapore Branch | 5
 | Fisher Scientific Pte Ltd | 6 |  | PHAR | Fisher Scientific Pte Ltd | 6
 | Fluidigm Singapore Pte Ltd | 3 |  | PHAR | Fluidigm Singapore Pte Ltd | 3
 | Illumina Singapore Pte Ltd | 3 |  | PHAR | Illumina Singapore Pte Ltd | 3
 | JMS Singapore Pte Ltd | 1 |  | PHAR | JMS Singapore Pte Ltd | 1
 | Lion TCR Pte Ltd | 2 |  | PHAR | Lion TCR Pte Ltd | 2
 | Lonza Biologics Tuas Pte Ltd | 2 |  | PHAR | Lonza Biologics Tuas Pte Ltd | 2
 | PPD Global Central Lab | 2 |  | PHAR | PPD Global Central Lab | 2
 | Tessa Therapeutics Pte Ltd | 1 |  | PHAR | Tessa Therapeutics Pte Ltd | 1
PHAR Total |  | 27 |  | PHAR Total |  | 27
SI | Cesco Pipeline Technologies Pte Ltd | 8 |  | SI | Cesco Pipeline Technologies Pte Ltd | 8
SI Total |  | 8 |  | SI Total |  | 8
TEST | Bio-Rad Laboratories (S) Pte Ltd | 1 |  | TEST | Bio-Rad Laboratories (S) Pte Ltd | 1
 | National Neuroscience Institute | 1 |  | TEST | National Neuroscience Institute | 1
TEST Total |  | 2 |  | TEST Total |  | 2
(blank) | (blank) |  |  | (blank) | (blank)
(blank) Total |  |  |  | (blank) Total
Grand Total |  | 51 |  | Grand Total |  | 51
Spreadsheet: 214787d1361122540-is-it-possible-to-make-a-formula-which-can-give-me-the-information-for-all-12-months-new-microsoft-office-excel-2007-workbook
Sheet: First

January
1 | 3 | 5 | 7 | 9
2 | 5 | 8 | 11 | 14
3 | 7 | 11 | 15 | 19
4 | 8 | 12 | 16 | 20
February
3 | 5 | 7 | 9 | 11
5 | 8 | 11 | 14 | 17
7 | 11 | 15 | 19 | 23
8 | 12 | 16 | 20 | 24
March
5 | 7 | 9 | 11 | 13
8 | 11 | 14 | 17 | 20
11 | 15 | 19 | 23 | 27
12 | 16 | 20 | 24 | 28
April
1 | 3 | 5 | 7 | 9
2 | 5 | 8 | 11 | 14
3 | 7 | 11 | 15 | 19
4 | 8 | 12 | 16 | 20
May
3 | 5 | 7 | 9 | 11
5 | 8 | 11 | 14 | 17
7 | 11 | 15 | 19 | 23
8 | 12 | 16 | 20 | 24
June
July
August
September
October
November
December
Spreadsheet: 862978d1710525367-calendar-formulas-and-conditional-formatting-annual-calendar-dj
Sheet: October

 |  |  |  |  |  |  |  |  | OCT
 | NOTES
 | Blackout dates
Spreadsheet: scott_neal__37936__STOR9819
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9819
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2001-02-16 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 267 | 257
(TX, LA, OK, KS, MS)
Market Area - East |  | 592 | 537
Market Area - West |  | 182 | 166
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 269162d1380997924-if-then-condition-met-then-copy-content-of-cells-into-anther-sheet-1billable-nonbillabletime
Sheet: Monthly Time

October | Billed | Non-Billed | Total |  | November | Billed | Non-Billed | Total |  | December | Billed | Non-Billed | Total
Totals |  |  |  |  | Totals |  |  |  |  | Totals
Spreadsheet: 878277d1725354394-calculating-the-time-difference-between-two-dates-working-hours-mode-delivery-delay
Sheet: Sheet1

Deadline | Finished | [NAME], Working Hours | Delivery Delay (24h mode) |  |  |  | WORKING DAY STARTS: | 09:00:00 | WORKING DAY ENDS: | 17:30:00
2024-03-20 14:15:00 | 2024-07-30 12:05:00
2024-05-07 11:15:00 | 2024-07-30 11:40:00
2024-01-03 13:00:00 | 2024-02-01 16:52:00
2024-03-08 15:30:00 | 2024-03-22 16:03:00
2024-06-18 12:15:00 | 2024-06-28 10:38:00
2024-04-16 14:15:00 | 2024-04-23 15:38:00
2024-07-03 09:00:00 | 2024-07-08 11:37:00
2024-05-03 10:00:00 | 2024-05-07 17:16:00
2024-03-22 15:45:00 | 2024-03-26 08:34:00
2024-08-14 14:45:00 | 2024-08-15 18:04:00
2024-04-30 14:45:00 | 2024-05-01 14:11:00
2024-03-19 11:15:00 | 2024-03-20 09:46:00
2024-02-01 16:00:00 | 2024-02-02 09:26:00
2024-06-17 17:00:00 | 2024-06-18 09:54:00
2024-03-11 17:30:00 | 2024-03-12 08:51:00
2024-05-14 18:15:00 | 2024-05-15 08:27:00
2024-06-27 11:45:00 | 2024-06-27 17:20:00
2024-02-14 11:00:00 | 2024-02-14 16:15:00
2024-03-28 14:00:00 | 2024-03-28 17:15:00
2024-06-27 14:15:00 | 2024-06-27 17:06:00
2024-04-15 11:00:00 | 2024-04-15 12:50:00
2024-03-26 15:00:00 | 2024-03-26 16:37:00
2024-05-22 09:45:00 | 2024-05-22 11:08:00
2024-04-22 11:00:00 | 2024-04-22 12:23:00
2024-06-17 14:15:00 | 2024-06-17 15:24:00
2024-06-13 16:45:00 | 2024-06-13 17:51:00
2024-04-30 15:00:00 | 2024-04-30 16:02:00
2024-02-12 14:45:00 | 2024-02-12 15:25:00
2024-07-09 16:00:00 | 2024-07-09 16:35:00
2024-03-07 15:15:00 | 2024-03-07 15:33:00
2024-06-11 09:00:00 | 2024-06-11 09:06:00
2024-02-05 13:45:00 | 2024-02-05 13:49:00
2024-06-06 09:00:00 | 2024-06-06 09:03:00
2024-07-09 15:30:00 | 2024-07-09 15:33:00
2024-01-15 10:00:00 | 2024-01-15 10:02:00
Spreadsheet: 89612d1289392049-counting-closures-during-selected-months-book1
Sheet: Sheet1

 |  |  | 4
ID | Status | Date Closed
1 | Closed | 2010-09-14 00:00:00 | Sep-10
2 | Prending
3 | Closed | 2010-09-14 00:00:00 | Sep-10
4 | Closed | 2010-05-14 00:00:00 | May-10
5 | Closed | 2010-10-14 00:00:00 | Oct-10
6 | Pending
7
8
9
10
Spreadsheet: 134142d1325040850-conditional-formatting-if-function-demo-all-patients
Sheet: Sheet1

 | NAME | MRN NUMBER | RED TEAM | GREEN TEAM | CLINICIAN 1 | CLINICIAN 2 | CLINICIAN 3 | CLINICIAN 4 | CLINICIAN 5 | CLINICIAN 6 | CLINICIAN 7 | CLINICIAN 8 | CLINICIAN 9 | CLINICIAN 10 | CLINICIAN 11 | CLINICIAN 12 | CLINICIAN 13 | CLINICIAN 14
 | NAME | 12345 | X
 | NAME | 67891 |  | X | 2011-01-15 00:00:00
 | NAME | 14532 | X |  |  |  | 2011-07-17 00:00:00
 | MANE | 98765 | X |  |  |  |  |  |  |  |  | 2011-05-08 00:00:00
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: Replace Costs-Results 6-10

Table 5.2.4.  Replacement Costs (Years 6 to 10)
 |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of Replacement Costs in Year:
Component | Unit Cost | Unit | Quantity | 6 | 7 | 8 | 9 | 10
 |  |  | Total Present Value of Replacement Costs (Years 6 to 10):
Spreadsheet: 703369d1604957813-looping-through-data-outputting-a-specific-value-sampg
Sheet: Sheet1

ID | JOB | FLOW | EXPECTED CALC:
1180634 | Job-172416 | NO | NO
1180634 | [NAME] | Final -> | Final ->
1180634 | [NAME] | Final -> | Final ->
1180634 | [NAME] | Final -> | Final ->
1180634 | [NAME] | Final -> | Final ->
1181121 | [NAME] | NO | NO
1181121 | [NAME] | NO | NO
1181121 | [NAME] | Final -> | Final ->
1181121 | [NAME] | Final -> | Final ->
1180803 | Job-174173 | 100 | 100
1180803 | Job-174173 | 100 | 100
1180803 | Job-174173 | 100 | 100
1180803 | Job-174173 | 100 | 100
Spreadsheet: 525999d1499075690-averageif-help-s666-operational-reporting-analyst-test-2
Sheet: Guide

 | You are an Operational Reporting Analyst support a global client called 'The Company'. You are about the create a new weekly report for them. You've already collected all the available data. (current and historical as well). They would like to see an overview of our service and highlighted trends.
 | NOTE** The client's financial year starts on 1st October and ends on 30th September,  so Q1 is October-November-December.
 | During your work please feel free to add columns to the Data sheet,  or new worksheet to the workbook if it helps.
 | Please complete the columns where the column header is red on the DATA tab.
 | Column J: Write a formula to automate the requisition status. The requisition can be 'Open' or 'Filled'. The role is considered as 'Filled' if it has Offer Accept date.
 | Column K: Here you should measure the Time to Hire or How many days the Role has been open. This is the difference between the Vacancy start date and the Verbal Offer Accept date for Filled roles, but for Open roles it would be time since Vacancy start date until current day. This formula should use only business days ( so excluding weekends).
 | Column L: Using the same theory as the above exercise, calculate the Time to Hire or Number of days the Role has been open but this time we want to include the weekends, not just the business days.
 | Column M: Use formula to determine the Year of the Verbal Offer Accept date.
 | Column N: Use formula to determine the Month of the Verbal Offer Accept date.
 | Column O: Use a formula to determine the Quarter when the offer was verbally accepted.
 | Column P: Use a formula to determine the Financial year when the offer was verbally accepted.
 | *Column M, N,O and P should be empty if the requisition status is 'Open'
 | *Please leave all formula in cells, do not paste as values*
 | Please complete the SUMMARY tab. ( make it formula driven, automated)
 | For Open Roles:
 | Current Open roles: number of the roles currently has the status 'Open'
 | Avg Days Open: for this calculation please use column K on the data tab
 | % Ageing Roles: all the open roles are opened more then 50 days age
 | Open roles by Region: You will find the Region for each and every role in column E on the Data tab.
 | CHART 1 : Create a chart which represent the open roles by department.
 | For Filled Roles:
 | Fill the data table. Filled roles by financial year, by quarter, by region.
 | The last 2 rows will be the Total Filled roles (sum of the regional data)
 | and the Average Time To Hire based on column K on the Data tab
 | CHART 2
 | Filled roles in Financial Year 2017 by Billing type
 | CHART 3
 | Filled roles in Financial Year 2017 by region