tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 271555d1381977128-need-formula-to-find-the-match-then-copy-and-paster-number-needformula
Sheet: Sheet2

ColumnA | ColumnA | ColumnA | ColumnA | ColumnA | ColumnA | Part | ColumnA | ColumnA | Com | Ds | ColumnA | Qty1 | Qty2 | Qty3 | Qty4 | Qty5 | Num1 | Num2 | Num3 | Num4 | Num5
1 |  |  |  |  |  | Hon1 |  |  | com Hon1 | 1 |  | 1 |  |  |  |  | 293
2 |  |  |  |  |  | Hon1 |  |  | com Hon1 | 2 |  | 5 |  |  |  |  | 283
3 |  |  |  |  |  | Hon1 |  |  | com Hon1 | 3 |  | 10 |  |  |  |  | 272
4 |  |  |  |  |  | Hon2 |  |  | com Hon2 | 4 |  | 1 |  |  |  |  | 75.69
5 |  |  |  |  |  | Hon3 |  |  | com Hon3 | 5 |  | 1 |  |  |  |  | 125
6 |  |  |  |  |  | Hon3 |  |  | com Hon3 | 6 |  | 5 |  |  |  |  | 119
7 |  |  |  |  |  | Hon3 |  |  | com Hon3 | 7 |  | 10 |  |  |  |  | 115
8 |  |  |  |  |  | Hon4 |  |  | com Hon4 | 8 |  | 1 |  |  |  |  | 308
9 |  |  |  |  |  | Hon4 |  |  | com Hon4 | 9 |  | 3 |  |  |  |  | 303
10 |  |  |  |  |  | Hon4 |  |  | com Hon4 | 10 |  | 5 |  |  |  |  | 299
11 |  |  |  |  |  | Hon4 |  |  | com Hon4 | 11 |  | 10 |  |  |  |  | 291
12 |  |  |  |  |  | Hon5 |  |  | com Hon5 | 12 |  | 1 |  |  |  |  | 52.38
13 |  |  |  |  |  | Hon5 |  |  | com Hon5 | 13 |  | 5 |  |  |  |  | 48.54
14 |  |  |  |  |  | Hon5 |  |  | com Hon5 | 14 |  | 10 |  |  |  |  | 46.39
15 |  |  |  |  |  | Hon6 |  |  | com Hon6 | 15 |  | 1 |  |  |  |  | 59.06
16 |  |  |  |  |  | Hon6 |  |  | com Hon6 | 16 |  | 2 |  |  |  |  | 56.25
17 |  |  |  |  |  | Hon6 |  |  | com Hon6 | 17 |  | 5 |  |  |  |  | 43.71
18 |  |  |  |  |  | Hon6 |  |  | com Hon6 | 18 |  | 10 |  |  |  |  | 43.31
19 |  |  |  |  |  | Hon6 |  |  | com Hon6 | 19 |  | 25 |  |  |  |  | 43
Spreadsheet: 877806d1724733657-how-to-list-column-without-duplicates-by-formula-list-all-sn-without-duplicates
Sheet: Sheet1

 | 203217303051017418151142 |  |  |  | in this way I do not know why not all SN added there are 3 not exist |  | this way it is working to add all but if there is duplicate values it is removing all of it I want to keep just 1
 | 202917303051017417549365
 | 190802203051017408043796
 | 190802203051017408042864 | x
 | 320612455
 | 320693287
 | 332303365
 | 202967303051017417658014
 | 190802203051017408043425 | x
 | 190802203051017408043681 | x
 | 211417303061211220933148
 | 190552203051017407962314
 | CND1202BT5
 | 211437303061211220954484
 | 202917303051017417549365
 | 202967303051017417658014
 | 202917303051017417549365
Spreadsheet: 52303972-8ea6-46af-a04e-36d0d0216bef
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7656 | 55904 | Christian | Troger | AUT | 82 | 01:23:43 | [NAME] | 03:57:37 | 00:03:47 | 04:03:08 | 1 | 09:33:27
Spreadsheet: 731711d1620521916-formula-to-pick-a-value-from-reference-table-based-on-a-condition-book1
Sheet: Sheet1

Start | End | Value |  | Enter#: | 25 | 13 | 6 | 7 | 33
0 | 10 | Low |  | Result:
11 | 20 | Medium
21 | 30 | High
Spreadsheet: 06dff74d-cae9-4e7a-9fe8-a013746fdcd7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | LAMPIRAN 1c : | KEPUTUSAN BERSAMA
 |  |  | KEPALA PERPUSTAKAAN NASIONAL [NAME]
 |  |  | KEPALA BADAN KEPEGAWAIAN NEGARA
 |  |  | [NAME]: 23 Tahun 2003
 |  |  | [NAME]: 21 Tahun 2003
 |  |  | [NAME]  : 13 Juni 2003
DAFTAR USUL PENETAPAN ANGKA KREDIT
JABATAN PUSTAKAWAN PENYELIA
 | NOMOR  :
Masa Penilaian Tanggal  :                     s/d
 | KETERANGAN PERORANGAN
1 | Nama
2 | NIP
3 | [NAME] KARPEG
4 | Tempat [NAME]
5 | [NAME]
6 | [NAME] Diperhitungkan Angka Kreditnya
7 | Pangkat / Golongan Ruang/TMT
8 | [NAME]/[NAME]
9 | Masa [NAME] | Lama
 |  | Baru
10 | Unit [NAME]
Spreadsheet: 877292d1724079080-count-available-employees-in-employee-break-schedule-based-on-color-copy-of-breaks
Sheet: 05-18-24 Staffing List

Position | Emp# | Employee | Time | Cause | From | To
 |  |  | Code | Code
DSP-SUPD | 3635 | Wilson, [NAME] T | OV | OPEN | 07:00:00 | 19:00:00
DSP-1D | 7092 | [NAME], [NAME] |  |  | 07:00:00 | 19:00:00
DSP-2D | 7132 | Webb, Samantha J |  |  | 07:00:00 | 19:00:00
DSP-3D | 7834 | [NAME], [NAME] | OF | SP | 07:00:00 | 19:00:00
DSP-4D | 5851 | Doval, [NAME] | XW |  | 07:00:00 | 19:00:00
DSP-5D | 7728 | Mojica, Zyali |  |  | 07:00:00 | 19:00:00
DSP-6D | 7263 | Koop, [NAME] |  |  | 07:00:00 | 19:00:00
DSP-7D | 7134 | [NAME], [NAME] |  |  | 07:00:00 | 19:00:00
DSP-7TD | 7963 | [NAME], [NAME] |  |  | 07:00:00 | 19:00:00
DSP-8D | 7977 | Thompson, Nathan |  |  | 07:00:00 | 19:00:00
DSP-9D | 6865 | Mudge, [NAME] D | EH | OPEN | 07:00:00 | 13:00:00
DSP-10D | 5077 | [NAME], [NAME] | OV | OTHER | 07:00:00 | 19:00:00
NIGHT SHIFT
DSP-SUPN | 3635 | Wilson, [NAME] T |  |  | 19:00:00 | 07:00:00
DSP-1N | 7266 | Cherness, [NAME] D |  |  | 19:00:00 | 07:00:00
[NAME] | 5077 | [NAME], [NAME] | OV | OPEN | 19:00:00 | 07:00:00
DSP-3N | 7834 | [NAME], [NAME] |  |  | 19:00:00 | 07:00:00
[NAME] | 7134 | [NAME], [NAME] | OF | SP | 19:00:00 | 07:00:00
DSP-5N | 7961 | [NAME], [NAME] |  |  | 19:00:00 | 07:00:00
[NAME] | 7728 | Mojica, Zyali | OFC | OPEN | 19:00:00 | 07:00:00
DSP-7N | 5851 | Doval, [NAME] | OFC | OPEN | 19:00:00 | 07:00:00
Spreadsheet: 89fb5aca-4174-4d0e-afc6-514cd58090d6
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
C3FX | Test | C3FX | [NAME], Functional, Serum | [NAME], Functional, S | Turbidimetry | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Immediately after drawing the specimen, place the tube on wet ice. 2. Spin down and separate serum from clot. 3. Immediately freeze specimen. Additional Information: Fasting preferred. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	Serum gel tube | 21-50 U/mL | Monday through Saturday; [NAME] with a 3 p.m. cutoff | Same day/1 day | 3 days | 1 | 86161 |  |  |  |  | Rochester
C3FX | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
C3FX | Result | C3FX | [NAME], Functional, S | [NAME], Functional, S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0116

 | Date: | 2013-01-16 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 7 | 20.6
 | 11:00:00 | 64 | 405.13
 | 12:00:00 | 85 | 414.86
 | 13:00:00 | 62 | 329.3
 | 14:00:00 | 48 | 223.74
 | 15:00:00 | 43 | 226.43
 | 16:00:00 | 36 | 309.1
 | 17:00:00 | 68 | 483.49
 | 18:00:00 | 59 | 500.92
 | 19:00:00 | 40 | 301.96
 | 20:00:00 | 35 | 201.37
 | 21:00:00 | 28 | 184.82
 | 22:00:00 | 25 | 148.91
 | 23:00:00 | 18 | 95.98
 | 1900-01-01 00:00:00 | 14 | 87.3
 | 1900-01-01 01:00:00 | 0 | 0
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 67bbed64-404d-4cd5-871c-e65def2bbe4d
Sheet: Example 4.3-b

Example 4.3 - Compute vapr pressure deficit for the table on page 97
Given | We know the time, [NAME], T.  We truncated the temperature
 | es = exp ( 16.78 T - 116.9 / T + 237.3 )
 | [NAME] (RH/100)
 | VPdeficit = es - ed
Hour | T deg C | [NAME] (es) | RH | Actual VP (ed) | [NAME]
01:00:00 | 16 |  | 96.6
02:00:00 | 15 |  | 98.4
03:00:00 | 14 |  | 99
04:00:00 | 14 |  | 99.3
05:00:00 | 14 |  | 99.7
06:00:00 | 13 |  | 100
07:00:00 | 13 |  | 100
08:00:00 | 14 |  | 100
09:00:00 | 16 |  | 94.7
10:00:00 | 20 |  | 81.6
11:00:00 | 23 |  | 71.8
12:00:00 | 26 |  | 62.9
13:00:00 | 28 |  | 50.2
14:00:00 | 29 |  | 49.3
15:00:00 | 30 |  | 46.6
16:00:00 | 30 |  | 45.7
17:00:00 | 30 |  | 46.9
18:00:00 | 30 |  | 47.8
19:00:00 | 30 |  | 50.4
20:00:00 | 29 |  | 58.7
21:00:00 | 27 |  | 69.8
22:00:00 | 23 |  | 83.2
23:00:00 | 21 |  | 89.4
1900-01-01 00:00:00 | 20 |  | 93.5
The average hourly vapor pressure deficit is |  |  |  |  | kPa
Method 1: Use the average daily temperature and the average dew point temperature.
 | (es - ed) = (es_tave - es_Td)
Tave = |  | C
We know that the dewpoint is between 13 and 14 degrees.  Therefore es_Td is given below
es_Td = |  | Kpa
es_tave = |  | Kpa
(es - ed) = |  | Kpa
Error =
Therefore, the average temperature and dewpoint method overpredicts by 23%
Spreadsheet: monika_causholli__28291__October Flash Report
Sheet: October

October
 | NORTH AMERICAN NEWSPRINT STATISTICS
 |  |  |  |  |  |  |  | October |  |  |  |  |  | Year-to-date
 |  |  |  |  |  | 2001 |  | 2000 |  | % change |  | 2001 |  | 2000 |  | % change
 | North America
 | (000s tonnes)
 |  | Production |  |  |  | 1212 |  | 1375 |  |  |  | 12066 |  | 13277
 |  | Operating Rate |  |  |  | 0.85 |  | 0.98 |  |  |  | 0.9 |  | 0.97
 |  | Shipments - Total |  |  |  | 1204 |  | 1374 |  |  |  | 11917 |  | 13321
 |  |  | To US |  |  | 916 |  | 1029 |  |  |  | 8656 |  | 9768
 |  |  | To Canada |  |  | 109 |  | 108 |  | 0.015 |  | 1013 |  | 1038
 |  |  | Overseas |  |  | 179 |  | 237 |  |  |  | 2248 |  | 2515
 |  | Imports from Overseas |  |  |  | 15 | e | 19 |  | -0.204 |  | 160 | p | 194
 |  | Total Demand |  |  |  | 1040 | p | 1155 |  |  |  | 9829 | p | 11000
 | United States
 |  | Total Consumption |  |  |  | 980 | p | 1081 |  |  |  | 8813 | p | 9961
 |  | Consumption by Dailies |  |  |  | 768 | p | 861 |  |  |  | 7127 | p | 7947
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Change from
 | Newsprint Inventories |  |  |  |  | 2001-10-01 00:00:00 |  | 2001-09-01 00:00:00 |  | Aug-01 |  | 2000-10-01 00:00:00 |  | month ago |  | year ago
 | (000s tonnes at month end)
 |  | NA Mills |  |  |  | 483 |  | 476 | r | 503 | r | 364
 |  |  | Canadian Mills |  |  | 363 |  | 352 | r | 374 | r | 307 |  | 11
 |  |  | US Mills |  |  | 121 |  | 124 |  | 129 |  | 57 |  | -3
 |  | All US Users |  |  |  | 1235 | p | 1284 | r | 1361 |  | 1300 |  |  |  | -66
 |  | US Dailies |  |  |  | 906 | p | 956 | r | 1042 |  | 968 |  |  |  | -62
 |  | Days of Supply - All US Users |  |  |  | 40 | p | 41 |  | 44 |  | 39 |  |  |  | 1
 |  | Days of Supply - US Dailies |  |  |  | 38 | p | 39 | r | 43 |  | 36 |  |  |  | 2
 | e= estimated |  |  | r= revised |  |  |  |  |  |  |  |  |  |  | Source: PPPC
 | p= preliminary |  |  | n.a.= not available
Spreadsheet: 696766d1600962843-nested-if-function-morte1974-example
Sheet: verloren 

Sofiproteol | SarL | LC | Diensten | nog invullen | nog invullen | Potential sales bestaande klant | [NAME] | 2016-06-01 00:00:00 | 2015-06-01 00:00:00 | 2015-12-31 00:00:00 |  | 25000 | 0.2 | Maandelijks achteraf
[NAME] | SarL | LC | Sustainable sourcing Pilot | n.v.t. | n.v.t. | Potential sales Prospect | [NAME] |  | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 |  | 25000 |  | Maandelijks achteraf | Offerte maken [NAME] 2014
ATIBT | SarL | LC | Licenties | nog invullen | n.v.t. | Potential sales Prospect | [NAME] |  | 2015-08-01 00:00:00 | 2015-12-31 00:00:00 |  | 20000 | 0.4 | Maandelijks achteraf
Spreadsheet: d99cd443-8961-4e72-a798-d7b9308e69d5
Sheet: Sheet1

State [NAME] (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Downloaded at 7/29/2014 11:59:34 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 102886
2008 Primary Election - OFFICIAL RESULTS
District | [NAME] | [NAME] | [NAME] | Whitney Hauz | TOTALS
District 02 | 1 | 0 | 0 | 0 | 1
District 03 | 0 | 0 | 0 | 0 | 0
District 04 | 0 | 0 | 0 | 0 | 0
District 05 | 0 | 1 | 0 | 0 | 1
District 06 | 0 | 0 | 0 | 0 | 0
District 11 | 0 | 0 | 0 | 0 | 0
District 13 | 0 | 0 | 0 | 0 | 0
District 20 | 0 | 0 | 0 | 0 | 0
District 21 | 0 | 0 | 0 | 0 | 0
District 22 | 0 | 0 | 0 | 0 | 0
District 27 | 0 | 0 | 0 | 0 | 0
District 36 | 0 | 0 | 0 | 0 | 0
District 37 | 0 | 0 | 0 | 0 | 0
District 38 | 0 | 0 | 0 | 0 | 0
District 40 | 0 | 0 | 0 | 0 | 0
District 41 | 0 | 0 | 0 | 0 | 0
District 44 | 1 | 0 | 1 | 1 | 3
District 45 | 0 | 0 | 1 | 0 | 1
District 46 | 0 | 0 | 0 | 0 | 0
TOTAL | 2 | 1 | 2 | 1 | 6
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 794986d1662456216-formula-for-counting-the-record-of-a-football-manager-given-certain-criteria-book1
Sheet: Sheet1

Record above FL 4th Tier |  |  |  |  |  |  |  |  |  |  |  |  | manager | division | result
 | FL 1st Tier |  |  | FL 2nd Tier |  |  | FL 3rd Tier |  |  | FL 4th Tier
 | W | D | L | W | D | L | W | D | L | W | D | L | ALEC ADAMS | FL 4th Tier | W
ALEC ADAMS |  |  |  |  |  |  |  |  |  |  |  |  | BILLY BEST | FL 2nd Tier | W
BILLY BEST |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | FL 4th Tier | W
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | DANNY DAWSON | FL 3rd Tier | W
DANNY DAWSON |  |  |  |  |  |  |  |  |  |  |  |  | EDDIE ECHO | FL 4th Tier | D
EDDIE ECHO |  |  |  |  |  |  |  |  |  |  |  |  | ALEC ADAMS | FL 1st Tier | D
 |  |  |  |  |  |  |  |  |  |  |  |  | BILLY BEST | FL 4th Tier | D
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | FL 3rd Tier | D
 |  |  |  |  |  |  |  |  |  |  |  |  | DANNY DAWSON | FL 4th Tier | L
 |  |  |  |  |  |  |  |  |  |  |  |  | EDDIE ECHO | FL 4th Tier | L
 |  |  |  |  |  |  |  |  |  |  |  |  | ALEC ADAMS | FL 2nd Tier | L
 |  |  |  |  |  |  |  |  |  |  |  |  | BILLY BEST | FL 4th Tier | L
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | FL 3rd Tier | W
 |  |  |  |  |  |  |  |  |  |  |  |  | DANNY DAWSON | FL 4th Tier | D
 |  |  |  |  |  |  |  |  |  |  |  |  | EDDIE ECHO | FL 4th Tier | L
 |  |  |  |  |  |  |  |  |  |  |  |  | ALEC ADAMS | FL 4th Tier | W
 |  |  |  |  |  |  |  |  |  |  |  |  | BILLY BEST | FL 3rd Tier | D
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | FL 4th Tier | L
 |  |  |  |  |  |  |  |  |  |  |  |  | DANNY DAWSON | FL 2nd Tier | D
 |  |  |  |  |  |  |  |  |  |  |  |  | EDDIE ECHO | FL 4th Tier | D
Spreadsheet: 064aa954-3bbe-482b-821d-44d0b1173cec
Sheet: Sheet1

Supplement 1. Site history, disturbance and management for 14 natural areas in Marion County, Indiana, U.S.A.
 | All sites have invasive species present.
Site | Year Protected | Historical Disturbance Level | Portion cleared for agriculture | Selectively logged and grazed | Portions mined for gravel | Landscaped estate | Private nature preserve | Off road vehicles | Army manuvers | Current/Recent Disturbance level | Trails | High volume of visitors | Deer browse | Mountain bikes | High tension utilitiy lines | Current Management Effort
ANP | 1972 | High | x |  | x |  |  |  |  | High | x | x |  |  |  | High
CSS | Estate 1923, under ecological management 1998 | High |  |  |  | x |  |  |  | Low | x |  |  |  |  | Med.
ECNP | 1962, state nature preserve 1991 | Low |  | x |  |  | x |  |  | Low | x |  | x |  |  | High
ECNC | 1962 | Med. |  | x |  |  | x |  |  | Med. | x | x | x |  |  | Med.
FHSP | Army base 1903, state park 1995 | Med. |  | x |  |  |  |  | x | Med. | x |  | x |  |  | Med.
JSP | City park 1971 | Med. |  | x |  |  |  |  |  | Med. | x |  |  |  |  | High
MCC | 1995 | Med. | x | x |  |  |  |  |  | Low |  |  |  |  |  | Med.
MPMT | 1990's | Med. | x | x |  |  |  |  |  | Med. | x | x |  |  |  | Low
MPNP | City park 1945, state nature preserve 1987 | Low |  | x |  |  |  |  |  | Low | x |  |  |  |  | High
MUEL | Estate in 1914,  college in 1936, ecol. man. 2000 | High |  |  |  | x |  |  |  | Med. | x |  |  |  |  | High
SPNP | 1962, state nature preserve 1987 | Low |  | x |  |  | x |  |  | Low |  |  | x |  |  | High
SWWP | 1961 | Med. | x | x |  |  |  | x |  | Med. | x |  |  | x | x | High
TRSP | 2000 | High | x | x | x |  |  |  |  | High | x | x |  | x |  | Med.
WGP | 1919 | Low |  | x |  |  |  |  |  | Low |  |  | x |  |  | Med.
Spreadsheet: 474864d1470936295-sum-all-grouped-items-from-each-category-expenses-list
Sheet: Sheet2

Category | Item | Why | Date | Cost
[NAME] |  |  |  | 1
Garage |  |  |  | 1 |  | Data List
Hiddent Garbage Dump |  |  |  | 1
Water Damage |  |  |  | 1 |  | Category | Total by Category
Damaged Home Items |  |  |  | 1 |  | [NAME]
[NAME] |  |  |  | 1 |  | Damaged Home Items
[NAME] |  |  |  | 1 |  | Garage
Garage |  |  |  | 1 |  | Garbage Dump #1
 |  |  |  |  |  | Garbage Yard
 |  |  |  |  |  | Hiddent Garbage Dump
 |  |  |  |  |  | Late Home Handover
 |  |  |  |  |  | Water Damage
Spreadsheet: 34384d1231605166-excel-search-marcus-czerny-losas
Sheet: Caso 4

1 | 1.05 | 1.1 | 1.15 | 1.2 | 1.25 | 1.3 | 1.35 | 1.4 | 1.45 | 1.5 | 1.55 | 1.6 | 1.8 | 2
1.15 | 1.15 | 1.15 | 1.14 | 1.14 | 1.14 | 1.13 | 1.13 | 1.12 | 1.12 | 1.11 | 1.11 | 1.1 | 1.1 | 1.1
0.26 | 0.27 | 0.28 | 0.29 | 0.3 | 0.32 | 0.34 | 0.36 | 0.38 | 0.4 | 0.42 | 0.44 | 0.46 | 0.46 | 0.46
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1.05 | 1.1 | 1.15 | 1.2 | 1.25 | 1.3 | 1.35 | 1.4 | 1.45 | 1.5 | 1.55 | 1.6 | 1.8 | 2
40.2 | 38.3 | 36.8 | 34.6 | 34.8 | 34.2 | 33.8 | 33.6 | 33.5 | 33.4 | 33.3 | 33.3 | 33.4 | 34.8 | 35.8
40.2 | 43.1 | 46.2 | 49.4 | 52.8 | 57 | 61.9 | 66.7 | 71.3 | 75.5 | 79.6 | 83.8 | 88 | 114 | 120
14.3 | 14.1 | 14 | 13.9 | 13.8 | 13.8 | 13.9 | 13.9 | 14 | 14.2 | 14.4 | 14.7 | 15.1 | 16 | 16.8
14.3 | 14.6 | 15 | 15.3 | 15.7 | 16.1 | 16.6 | 17.1 | 17.6 | 18.1 | 18.6 | 19.1 | 19.6 | 21.8 | 24.4
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 847941d1698776987-formula-to-capture-attendance-login-shift-adherence
Sheet: Attendance (Shift Adherence)

 |  |  |  | Expected Results
Date | Agent Name | Agent ID | Shift Start Time | [NAME] | Last Logout Time | Attendance | Delayed By | Total [NAME] | Off Login Hrs
2023-09-27 00:00:00 | A | 1234 | 10:00:00 |  |  |  |  |  | 00:25:00
2023-09-27 00:00:00 | B | 4567 | 12:00:00 |  |  |  |  |  | 01:37:00
2023-09-27 00:00:00 | C | 2345 | 17:30:00 |  |  |  |  |  | 00:48:04
2023-09-27 00:00:00 | D | 6789 | 10:30:00 |  |  |  |  |  | 02:42:02
2023-09-27 00:00:00 | E | 1000 | 11:00:00 |  |  |  |  |  | 02:25:42
Spreadsheet: 798402d1664463233-excel-calculate-working-days-between-2-dates-monthly-absence
Sheet: Working days

 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Bank Holidays: |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | New Year's Day | 2022-01-03 00:00:00 |  |  |  | Start date | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
 | Good Friday | 2022-04-15 00:00:00 |  |  |  | End date | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00
 | Easter Monday | 2022-04-18 00:00:00 |  |  |  | Working days
 | Early May bank holiday | 2022-05-02 00:00:00
 | Spring bank holiday | 2022-06-02 00:00:00 |  |  | Date of absence
 | Platinum Jubilee bank holiday | 2022-06-03 00:00:00 |  |  | Start | End | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Summer bank holiday | 2022-08-29 00:00:00 |  | [NAME] | 2022-01-10 00:00:00 | 2022-05-05 00:00:00
 | Funeral of Queen Elizabeth II | 2022-09-19 00:00:00 |  | [NAME] | 2022-03-30 00:00:00 | 2022-07-07 00:00:00
 | Boxing Day | 2022-12-26 00:00:00 |  | [NAME] | 2022-04-01 00:00:00 | 2022-09-29 00:00:00
 | Christmas Day (Substitute) | 2022-12-27 00:00:00 |  | Ang | 2022-05-15 00:00:00 | 2022-07-06 00:00:00
 |  |  |  | [NAME] | 2022-08-01 00:00:00 | 2022-08-12 00:00:00
Spreadsheet: tracy_geaccone__40277__Non recurring Q3 2001-asset sales
Sheet: Summary

Azurix Corp.
Potential Third Quarter 2001 Non-recurring Charges
Loss On Assets Held For Disposal
 | Azurix North America / Azurix Industrials |  |  |  | (a)
 | Azurix Brazil
 | Mendoza
 | [NAME] (IASA)
 | [NAME]
 | Lurgi
 | Madera Ranch
 | Swiss Combi |  |  | -4
 | Sub-total Assets Held For Disposal Impairments
Azurix Corp. PP&E Impairments
Synagro Litigation Settlement |  |  |  | -8 | (b)
Severances
Other
 | Total Non-Recurring Charges - Pre-tax
 | Total Non-Recurring Charges - Net of Tax
(a) - This amount assumes that [NAME] does not receive $10mm to be placed in escrow.
(b) - Settlement agreement and amount are final.
Updated: September 13, 2001
Spreadsheet: 1ae57919-9494-4b36-bd3c-0474122fee65
Sheet: Sheet1

Simulation of the Cost and Impact of a NJTC for 2009 and 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Year | Threshold and StdDev of growth & size of NJTC | GDP w/o stimulus 'billions' | Baseline Nominal Private Industry Compen- sation | Baseline Nominal Private industry   W & S | Base for NJTC if threshold XX % of 2008 | Revenue cost of NJTC S=.124 recap=.3 in billions | Incr Priv Industry Compensa due to NJTC Elast =-.15  in billions | First Round Bang per Buck | Extra FTE Jobs in '000s | 1st Round Cost per job. Cost is half this if Keynsian multiplier | Revenue cost of NJTC divided by baseline GDP | [NAME] % impact of NJTC on baseline GDP
2006 | actual | 13178.4 | 6105.124 | 5004.2
2007 | actual | 13807.5 | 6656.32 | 5456
2008 | actual | 14326 | 6710 | 5500
 | Baseline simulation
2009 | [NAME] s=.14 | 14326 | 6710 | 5500 | 520.9567274999993 | 45.21904394699994 | 77.78503754999998 | 1.720183152062432 | 1207.842197981366 | 37437.87393963656 | 0.003156431938224204 | 0.01085928208153008
2010 | [NAME] | 15193 | 7116 | 5833 | 626.1282427 | 54.34793146636 | 78.71648040000001 | 1.448380430977829 | 1185.489162650603 | 45844.30898115083 | 0.003577169187544263 | 0.01036220369907194
 | Lower growth threshold by 5 percentage points
2009 | [NAME] s=.14 | 14326 | 6710 | 5500 | 724.753656 | 62.90861734079999 | 85.89197232 | 1.365345098187271 | 1333.72627826087 | 47167.5623148331 | 0.004391219973530643 | 0.0119910613318442
2010 | [NAME] | 15193 | 7116 | 5833 | 823.9816289449992 | 71.52160539242593 | 88.52065614 | 1.23767714181335 | 1333.142411746988 | 53648.88609214822 | 0.004707536720359766 | 0.01165282118607253
 | Increase NJTC by 50%
2009 | T=95 s=.14 | 14326 | 6710 | 5500 | 552.8358412499996 | 71.97922653074994 | 116.677556325 | 1.620989304117552 | 1811.763296972049 | 39728.82475930871 | 0.005024377113691885 | 0.01628892312229513
2010 | [NAME] | 15193 | 7116 | 5833 | 658.3902740500002 | 85.72241368131003 | 118.0747206 | 1.377407792540304 | 1778.233743975904 | 48206.49364669328 | 0.005642230874831174 | 0.01554330554860791
t
Spreadsheet: 681393d1591542786-grouping-continuous-dates-dates-example
Sheet: Sheet1

Tenant | Property | From | To | Method 1 | What it should be
A | House1 | 2011-09-01 00:00:00 | 2012-08-31 00:00:00 |  | 1
A | House2 | 2012-09-01 00:00:00 | 2013-08-31 00:00:00 |  | 2
B | House4 | 2012-09-01 00:00:00 | 2013-08-31 00:00:00 |  | 1
A | House3 | 2014-09-01 00:00:00 | 2015-08-31 00:00:00 |  | 3
A | House3 | 2016-09-01 00:00:00 | 2017-08-31 00:00:00 |  | 4
B | House4 | 2016-09-01 00:00:00 | 2017-08-31 00:00:00 |  | 2
B | House4 | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 |  | 2
A | House4 | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 |  | 5
B | House4 | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 |  | 2
A | House4 | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 5
C | House5 | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 1
A | House4 | 2020-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 5