tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 160124d1338982074-if-cell-value-is-not-null-then-paste-the-table-row-in-another-sheet-last-empty-row-new-microsoft-office-excel-worksheet-2-oeldere-
Sheet: Sheet1

07:00:00 | 07:05:00 |  | + | 00:05:43.200000
07:30:00 | 07:31:00 |  | + | 00:01:43.200000
08:00:00 | 08:00:00 |  | +
09:30:00 | 09:30:00 |  | +
10:00:00 | 10:00:00 |  | +
10:30:00 | 10:30:00 |  | +
11:00:00 | 11:10:00 |  | + | 00:10:43.200000
11:30:00 | 11:30:00 |  | +
12:00:00 | 12:00:00 |  | +
12:30:00 | 12:30:00 |  | +
13:00:00 | 13:00:00 |  | +
13:30:00 | 13:30:00 |  | +
14:00:00 | 14:00:00 |  | +
14:30:00 | 14:30:00 |  | +
15:00:00 | 15:01:00 |  | + | 00:01:43.200000
17:00:00 | 17:00:00 |  | +
19:00:00 | 19:00:00 |  | +
21:00:00 | 21:00:00 |  | +
01:00:00 | 01:00:00 |  | +
09:00:00 | 09:00:00 |  | +
21:00:00 | 21:02:00 |  | + | 00:02:43.200000
09:00:00 | 09:00:00 |  | +
21:00:00 | 21:00:00 |  | +
09:00:00 | 09:00:00 |  | +
18:43:00 | 08:00:00 |  | - | 10:43:00
09:00:00 | 08:11:00 |  | - | 00:49:00
09:00:00 | 08:18:00 |  | - | 00:42:00
Spreadsheet: 152507d1335417262-latest-date-within-a-conditional-array-demo
Sheet: Sheet1

ACTNAME | JOBP | BILLNO | CLSDATE | BDSPDT | BILLAMT
XYZ | IA | 393796 | 2010-06-21 00:00:00 | 2010-06-28 00:00:00 | 8205
XYZ | IA | 393796 | 2010-06-21 00:00:00 | 2010-06-28 00:00:00
XYZ | IA | 393796 | 2010-06-21 00:00:00 | 2010-06-28 00:00:00
XYZ | IA | 393796 | 2010-06-21 00:00:00 | 2010-06-28 00:00:00
XYZ | IA | 393888 | 2010-07-24 00:00:00 | 2010-07-28 00:00:00 | 5000
XYZ | IA | 393888 | 2010-07-24 00:00:00 | 2010-07-28 00:00:00
XYZ | IA | 393888 | 2010-07-24 00:00:00 | 2010-07-28 00:00:00
ABC | XA | 393994 | 2010-07-21 00:00:00 | 2010-07-28 00:00:00 | 13000
ABC | XA | 393994 | 2010-07-21 00:00:00 | 2010-07-28 00:00:00
ABC | XA | 393994 | 2010-07-21 00:00:00 | 2010-07-28 00:00:00
Spreadsheet: 680000d1590736412-if-nested-formula-depending-on-a-data-validation-list-example
Sheet: Sheet1

NTP |  |  |  |  |  |  |  | T0
Contract Type | Resemnare/Contract NOU | Previous Fee | New FEE/Year | TPOSM | Min to be sold (crt) | Target proposal (crt) | OK/NOK | Last 3 Mo sales average
Platinum | Resemnare | 16000 | 20000 | Iridium |  |  |  | 240
In A3 cell I have a data validation [NAME] and I want to change the formula in F3 depending on the contract Type .  IF(A3="Target" then (D3/189)+I3,0)), IF(A3="Platinum" then (D3/189)*4.2), IF(A3="Gold" then (D3/189)*4.6),IF(A3="Silver"then(d3/189)*5)
Spreadsheet: 210804d1359566723-sort-data-from-name-list-for-one-name-to-appear-only-once-test5
Sheet: Sheet1

 |  | name | score
 |  | abc | 10
 |  | abc | 10
 |  | abc | 10
 |  | xyz | 10
 |  | ghy | 10
 |  | joi | 10
 |  | joi | 9
 |  | lmn | 9
 |  | plm | 8
 |  | ert | 8
Spreadsheet: ryan_slinger__33686__IDS Ready
Sheet: User ID's

 |  | IntercontinentalExchange
 |  | Completed User Sheet
 |  | This sheet is strictly for informational purposes, not for enrollment. If you need an enrollment form, please contact the ICE Helpdesk ([EMAIL])
 |  | User Information |  |  |  |  |  | Commodity Types
 | Date | First Name | Last Name | ICE ID | Phone | [NAME] |  | Financial Power | Physical Power | Emissions | Financial Gas | Physical Gas | Oil | Weather
1 | 2001-10-30 00:00:00 | [NAME] | Slinger | ryslinger | [PHONE] | [EMAIL] |  |  | User
2 | 2001-10-30 00:00:00 | [NAME] | [NAME] | bwilliams1 | [PHONE] | [EMAIL] |  |  | User
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 |  | Legal Entity Name |  |  | Enron Power Marketing Inc. |  |  | Access Types Description: Click on cells below for complete description
 |  |  |  |  |  |  |  | View Only
 |  |  |  |  |  |  |  | Accounting
 |  |  |  |  |  |  |  | User
 |  |  |  |  |  |  |  | Super User
 |  |  |  |  |  |  |  | Risk Manager
Spreadsheet: 35163d1232689560-sorting-issues-off-season-09
Sheet: I'm Glad Your Dead

Pos | Batters |  | H/AB | R | HR | RBI | SB | BB | K | AVG | OBP | SLG | TLR
C | [NAME] | (Min - C) | 176/536 | 98 | 9 | 85 | 1 | 84 | 50 | 0.328 | 0.413 | 0.451
1B | [NAME] | (Hou - 1B,OF) | 173/554 | 114 | 29 | 106 | 18 | 99 | 108 | 0.312 | 0.42 | 0.567
2B | [NAME] | (Atl - 2B) | 157/547 | 86 | 12 | 69 | 11 | 52 | 113 | 0.287 | 0.349 | 0.446
3B | [NAME] | (NYY - 3B) | 154/510 | 104 | 35 | 103 | 18 | 65 | 117 | 0.302 | 0.392 | 0.573
SS | [NAME] | (Hou - SS) | 179/632 | 92 | 13 | 66 | 7 | 24 | 72 | 0.283 | 0.314 | 0.415
OF | [NAME] | (KC - OF) | 158/598 | 66 | 20 | 97 | 2 | 23 | 106 | 0.264 | 0.3 | 0.438
OF | [NAME] | (Bos - OF) | 103/368 | 79 | 19 | 64 | 4 | 79 | 80 | 0.28 | 0.408 | 0.519
OF | [NAME] | (Mil - 3B,OF) | 91/404 | 50 | 15 | 55 | 5 | 37 | 124 | 0.225 | 0.293 | 0.396
Util | [NAME] | (Sea - OF) | 186/635 | 85 | 23 | 110 | 2 | 64 | 110 | 0.293 | 0.358 | 0.479
Util | [NAME] | (Min - OF) | 149/577 | 79 | 7 | 59 | 33 | 25 | 142 | 0.258 | 0.296 | 0.36
BN | [NAME] | (Fla - OF) | 89/351 | 54 | 15 | 51 | 3 | 48 | 82 | 0.254 | 0.364 | 0.47
BN | Curtis [NAME] | (Det - OF) | 155/553 | 112 | 22 | 66 | 12 | 71 | 111 | 0.28 | 0.365 | 0.494
BN | [NAME] | (Min - OF) | 62/249 | 30 | 3 | 36 | 5 | 25 | 40 | 0.249 | 0.33 | 0.369
Pos | Pitchers |  | IP | W | L | SV | BB | K | HLD | ERA | WHIP | K/9 | TLR
SP | [NAME] | (LAD - SP) | 211 | 14 | 11 | 0 | 45 | 147 | 0 | 3.24 | 1.13 | 6.27
SP | [NAME] | (Mil - SP) | 198.1 | 13 | 9 | 0 | 47 | 158 | 0 | 3.09 | 1.15 | 7.17
SP | [NAME] | (Col - SP) | 211.1 | 16 | 9 | 0 | 48 | 96 | 0 | 3.96 | 1.34 | 4.09
SP | CC Sabathia | (Mil - SP) | 253 | 17 | 10 | 0 | 59 | 251 | 0 | 2.7 | 1.11 | 8.93
RP | Mariano Rivera | (NYY - RP) | 70.2 | 6 | 5 | 39 | 6 | 77 | 0 | 1.4 | 0.67 | 9.81
RP | [NAME] | (SD - RP) | 45.1 | 3 | 6 | 30 | 9 | 46 | 0 | 3.77 | 1.04 | 9.13
RP | [NAME] | (KC - SP,RP) | 202.1 | 13 | 10 | 0 | 56 | 183 | 0 | 3.47 | 1.28 | 8.14
P | [NAME] | (Ari - RP) | 73.2 | 4 | 8 | 9 | 18 | 71 | 22 | 2.81 | 1.07 | 8.67
BN | [NAME] | (Tex - SP) | 171 | 14 | 8 | 0 | 65 | 127 | 0 | 4.74 | 1.46 | 6.68
DL | [NAME] | (SD - SP) | 102.1 | 7 | 6 | 0 | 48 | 93 | 0 | 3.96 | 1.29 | 8.18
Spreadsheet: 49737d1249053602-if-no-data-then-show-empty-cell-main-spreadsheet
Sheet: INVOICE

 | INVOICE
 | Invoice Date |  | Invoice Number |  | Terms
 | 2009-05-21 00:00:00 |  | 89231 |  | 7 Days |  |  |  |  |  |  |  |  |  | Select name
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Conk, Carol
 | Ref:
 | Invoice To: | Carol Conk
 |  | C1
 |  | C2
 |  | [NAME]
 |  | C4
 |  | CC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VAT RATE (%)
 | Ref | Description |  |  |  |  |  |  |  |  | Cost |  |  |  | 15
 | 1 | a |  |  |  |  |  |  |  |  | 100
 | 2 | b |  |  |  |  |  |  |  |  | 13
 | 3 | c |  |  |  |  |  |  |  |  | 234
 | 4 | Description |  |  |  |  |  |  |  |  | 50
 | 5 |  |  |  |  |  |  |  |  |  | 24
 | A. A.Price t/a Anthony Price and Sons |  |  |  |  |  |  | Nett Total |  |  | 421
 |  |  |  |  |  |  |  | VAT @ | 15 | % | 63.15
 |  |  |  |  |  |  |  | TOTAL |  |  | 484.15
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Legal

 | Legal
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Legal
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  |  | Per HC | New HC | Adj Comp |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  | 0 |  |  |  | Compensation | 0
 | Analyst & Assoicate | 0 |  |  | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  | 0 | 4200000 |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENARENT | Rent |  |  |  |  |  |  |  | [NAME] | 52800 | 2
ENATECH | Technology |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATRANS | Transportation |  |  |  |  |  |  |  | Specialist | 63000 | 3
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Associate | 97200 | 0
 |  |  |  |  |  |  |  |  | Manager | 132000 | 1
 | Headcount |  |  | 111 | 22 |  |  |  | General Counsel Asst | 178800 | 9
 |  |  |  |  |  |  |  |  | Sr Counsel | 195600 | 2
 | A&A Headcount |  |  |  |  |  |  |  | VP - Counsel | 217200 | 4
 |  |  |  |  |  |  |  |  | MD | 345600 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 24143776.43 |  | 32191701.90666667 |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
 |  |  |  |  |  |  |  | Outside Legal - $5,000,000
Spreadsheet: 58bb7291-16d7-4a5c-822a-8eecb7a2474e
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Offshoretjenester
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
4sea Energy Holding AS | [NAME] 6 | 4050 | Sola | 417 67 665
7ocean AS |  | 6010 | Ålesund | 957 45 517
AGR Subsea AS | Smålonane 14 | 5353 | [NAME] | 56 15 40 00
Abyss AS | Daleg. 71 | 6516 | Kristiansund | 71 58 06 00
Accpron AS | Karmsundgata 72 | 5529 | Haugesund | 51 21 72 00
Add Energy Group AS | Forusbeen 10 | 4031 | Stavanger | 51 87 44 80 | 51 87 44 51
Aeron AS | [NAME] 8 | 4400 | Flekkefjord | 38 32 78 00
Aggreko Norway AS | Dragonv. 44 | 2013 | [NAME] | 810 00 333
Agr Subsea AS | Smålonane 16 | 5353 | [NAME] | 56 13 71 81
[NAME] | Dalegata 71 | 6516 | Kristiansund | 852 70 000 | 852 70 001
[NAME] | Storåkeren 11 | 9411 | Harstad | 852 70 000
[NAME] | Brenneriveien 19-21 | 9600 | Hammerfest | 852 70 000
[NAME] avd Haugesund | [NAME] gate 72 | 5527 | Haugesund | 852 70 000
Aker MH AS | Nedre vei 8 | 3183 | Horten | 38 05 70 00
Aker Solutions Mmo AS avd Kristiansund | Omagata 124 | 6517 | Kristiansund | 67 51 30 00
Albatross Electro & HVAC AS | Skvadronvegen 22 | 4050 | Sola | 51 71 69 00 | 51 71 69 01
Alfa Nordic Service A/S | Tangen 2B | 4070 | Randaberg | 51 41 05 21 | 51 41 05 51
Align AS | Magnus Poulssons v 7 | 1366 | Lysaker | 51 71 93 00
Amflow Norge AS | Stokkabrautene 23 | 4023 | Stavanger | 922 19 656
Amundsen Carl J AS | Smedasundet 97B | 5525 | Haugesund | 52 70 22 00 | 52 71 16 89
Apply LQ Partner AS (tidl. [NAME]) | Årabrotsvegen 21 | 5515 | Haugesund | 52 70 87 00 | 52 70 87 01
Aqua Supply AS |  | 6919 | Tansøy | 950 51 935
[NAME] | Maskinveien 26 | 4033 | Stavanger | 51 50 43 00
[NAME] |  |  |  | 51 30 80 00
[NAME] | Travbaneveien 3 | 4031 | Stavanger | 51 30 80 00
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 276005d1383722483-formula-to-check-for-name-and-give-a-percentage-lolchamps
Sheet: %

Champ | LaneWin% | GameWin%
Irelia
[NAME]
Kog
[NAME]
Rene
Spreadsheet: 850181d1700569107-i-want-output-4-or-6-digits-dependable-question-excel
Sheet: question

Output
Relatiecode
 | I don't want the dash here
INPUT
Abonnee | Datum | Van | Naar | Tijd (sec) | [NAME] | Soort | BTW Percentage
Jip - 0000 | 2023-09-01 09:49:00 |  |  | 26 | 0.11 | Servicenummers | 21
Jip - 0000 | 2023-09-01 09:50:00 |  |  | 22 | 0.1 | Internationaal | 21
Jip - 101497 | 2023-09-01 10:19:00 |  |  | 488 | 0.35 | Servicenummers | 21
Jip - 0173 | 2023-09-01 10:41:00 |  |  | 793 | 1.33 | Servicenummers | 21
IPC - 0000 | 2023-09-01 11:10:00 |  |  | 867 | 1.44 | Mobiel | 21
IPC - 0173 | 2023-09-01 11:11:00 |  |  | 18 | 0.1 | Mobiel | 21
IPC - 0000 | 2023-09-01 11:14:00 |  |  | 50 | 0.15 | Mobiel | 21
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 26410 | 25458 | 24462 | 29000
2 | 25541 | 22355 | 22978 | 27000 |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 28508 | 22355 | 24466 | 27000 |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 24090 | 22355 | 25907 | 26998 |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 | 28040 | 24754 | 27188 | 22620 |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 | 26434 | 24755 | 27891 | 22620 |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
7 | 31240 | 26838 | 27614 | 25121
8 | 29266 | 24696 | 26038 | 26690
9 | 27433 | 24455 | 24746 | 26414
10 | 28683 | 24689 | 25767 | 26686
11 | 27118 | 24779 | 27800 | 26791
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  | 494173.81
2002-03-11 00:00:00
CBS Volume
 |  |  | 33900
Spreadsheet: 09eec516-9640-48ac-9740-65ff05b9f8d7
Sheet: gender

AY07-08 | AY08-09 | [NAME] | AY10-11 | AY11-12
2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  | F
 |  |  |  |  | M
 |  |  |  |  | (blank)
Spreadsheet: bfcde128-2405-4817-931b-07e7794ddd94
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42649746 | 2014-08-09 11:12:13 | ALLIES | 1 | 6 | 2 | 1604857 | BreakerMorant | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
42649876 | 2014-08-09 11:32:40 | AXIS | 1 | 6 | 5 | 1604857 | BreakerMorant | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
42653345 | 2014-08-09 18:21:01 | AXIS | 0 | 2 | 6 | 1600118 | Rhumhell37 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42653813 | 2014-08-09 18:54:41 | ALLIES | 1 | 6 | 1 | 1600118 | Rhumhell37 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42667298 | 2014-08-10 18:43:05 | ALLIES | 0 | 3 | 6 | 1058789 | svillas | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42667692 | 2014-08-10 19:12:12 | AXIS | 0 | 4 | 6 | 1058789 | svillas | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 837188d1689921520-lookup-by-multiple-conditions-ranking-topics-by-student-aligw
Sheet: Data

Student | Topic | Result |  |  |  |  | Topics
[NAME] | A | 0.43 |  |  | Output | Student | Highest Result | 2nd Highest Result | 2nd Lowest Result | Lowest Result
[NAME] | B | 0.74 |  |  |  | [NAME]
[NAME] | C | 0.75 |  |  |  | [NAME]
[NAME] | D | 0.73
[NAME] | E | 0.51
[NAME] | F | 0.27
[NAME] | A | 0.26
[NAME] | B | 0.27
[NAME] | C | 0.89
[NAME] | D | 0.82
[NAME] | E | 0.48
[NAME] | F | 0.37
Spreadsheet: 63972d1264809785-vlookup-and-sum-call-logs-template-work1
Sheet: Thursday

Public Que
8am - 12pm
Agent |  | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
Hicks | Rachel
Bellar | Marcus
Holder | [NAME]
[NAME] | [NAME]
[NAME] | Justin
Self | Cameron
[NAME] | Adam | 5
Daily Total |  |  | 0 |  |  | 00:04:10 |  |  | 00:01:02
Totals
12 - 5pm
Agent |  | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
[NAME] | [NAME] |  |  |  |  |  |  |  | 00:00:00
Kinney | Damon |  |  |  |  |  |  |  | 00:00:00
Donnelly | [NAME] |  |  |  |  |  |  |  | 00:00:00
Hirschi | Evin |  |  |  |  |  |  |  | 00:00:00
[NAME] | Jessica |  |  |  |  |  |  |  | 00:00:00
[NAME] | [NAME] |  |  |  |  |  |  |  | 00:00:00
Offutt | Tawney |  |  |  |  |  |  |  | 00:00:00
[NAME] | [NAME]
Daily Totals |  |  | 0 |  |  | 00:06:20 |  |  | 00:02:07
Totals
Inbound Que
8am - 12pm
Agent |  | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
Hicks | Rachel |  |  |  |  |  |  |  | 00:00:00
Bellar | Marcus |  |  |  |  |  |  |  | 00:00:00
Holder | [NAME] |  |  |  |  |  |  |  | 00:00:00
[NAME] | [NAME] |  |  |  |  |  |  |  | 00:00:00
[NAME] | Justin |  |  |  |  |  |  |  | 00:00:00
Self | Cameron |  |  |  |  |  |  |  | 00:00:00
[NAME] | Adam |  |  |  |  |  |  |  | 01:00:00
Daily Totals |  |  | 0 |  |  | 00:00:00 |  |  | 00:00:00
Totals
12pm - 5pm
Agent |  | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
[NAME] | [NAME] |  |  |  |  |  |  |  | 00:00:00
Kinney | Damon |  |  |  |  |  |  |  | 00:00:00
Donnelly | [NAME] |  |  |  |  |  |  |  | 00:00:00
Hirschi | Evin |  |  |  |  |  |  |  | 00:00:00
[NAME] | Jessica |  |  |  |  |  |  |  | 00:00:00
[NAME] | [NAME] |  |  |  |  |  |  |  | 01:00:00
Offutt | Tawney |  |  |  |  |  |  |  | 02:00:00
[NAME] | [NAME]
Daily Totals |  |  | 0 |  |  | 00:00:00 |  |  | 00:00:00
Totals
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: 0106

01/06/11  Performance Data
 |  | 1st Work |  |  |  | QC |  |  | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT SURNOTACKL MNBENMMIG SURDTHCERT | SURBENCSMG SURFRM SURVALDOD SURCUSFLUP SURSPLIGO SRSPNIGO SURBENSPLT RAIDPS RAIDNP/TAIDIN-IA FAID/FAIDWF IAID/FAIDCO SURINQ | SURBENRSCH SURBENUPDT RAIDPB RAIDAR | SURBENLEGL SURPAYLNPO | MNTBENMMIG SURSPLIGO SURSPNIGO SURBENSPLT RAIDPS FAID | SURBENRSCH (PASS) SURBENUPDT (PASS/FAIL) RAIDPB RAIDAR | SURBENRSCH (FAIL)
 |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint |  | 7 | 19 |  |  |  |  | 173 | 0.5 | board | 7.25 | 23.86206896551724
 | Dustin | 3 | 17 | 9 |  |  |  |  | 129 | 1 | trending | 7.75 | 16.64516129032258
 | Sharron | 16 | 5 | 12 |  |  |  |  | 143 |  |  | 9.5 | 15.05263157894737
 | Roxy | 3 | 13 | 12 |  |  |  |  | 141 |  |  | 9.25 | 15.24324324324324
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | Ana | 4 | 13 | 10 |  |  |  |  | 127 | 2 | [NAME] | 6.25 | 20.32
 |  |  |  |  |  |  |  |  | 0
 | [NAME] | 15 | 17 | 13 |  |  |  |  | 185 | 0.5 | CISS | 9 | 20.55555555555556
 | Petra | 6 |  | 1 |  |  | 7 |  | 76 | 2 | execcomp/[NAME] | 6.75 | 11.25925925925926
 | Regina |  |  |  |  |  | 5 |  | 40 | 6 | SWT | 2 | 20
 | Noy |  |  |  |  | 2 | 9 | 3 | 100 | 3 | SWT | 6.75 | 14.81481481481481
 | [NAME] |  | 7 |  |  | 18 | 10 |  | 137 |  |  | 10 | 13.7
 | [NAME] |  |  |  |  |  |  |  | 0 |  | SME | 0.01 | 0
 | Michelle |  |  |  |  |  |  |  | 0 |  | SME | 0.01 | 0
 | Keisha |  | 15 | 2 |  |  |  |  | 61 |  |  | 10.5 | 5.809523809523809
 | [NAME] |  | 18 | 9 |  |  |  |  | 126 |  |  | 8.5 | 14.82352941176471
TEAM TOTALS | Pts Earned: | 2 | 3 | 8 | 12 | 2 | 8 | 8 |  |  |  |  | 178.2622585171839
 | TASK VOLUME: | 47 | 112 | 87 | 0 | 20 | 31 | 3 | 1438 | 15 |  | 93.53 | 15.37474607077943
 | Pts Earned: | 94 | 336 | 696 | 0 | 40 | 248 | 24
 |  |  |  |  |  |  |  | Average PTS | 89.875625 |  | Total Task Volume |  | 300
 | MID-DAY PPH  16.25
Spreadsheet: 750797d1633636432-search-row-for-2-matches-and-sum-collumn-below-excel-help-forum
Sheet: Admin

 | Month 1 |  | Month 2 |  | Month 3 |  | Month 4
Branch 1 | 2022-01-05 00:00:00 | 259200 | 2022-02-01 00:00:00 | 268800 | 2022-03-01 00:00:00 | 446400.0000000001 | 2022-04-01 00:00:00 | 576000
Branch 2 | 2022-01-29 14:24:00 | 28800 | 2022-02-01 00:00:00 | 268800 | 2022-03-01 00:00:00 | 446400.0000000001 | 2022-04-01 00:00:00 | 576000
Branch 3 | 2022-02-23 04:48:00 | 57600 | 2022-03-01 00:00:00 | 297600 | 2022-04-01 00:00:00 | 432000.0000000001 | 2022-05-01 00:00:00 | 595200
Branch 4 | 2022-03-19 19:12:00 | 124800 | 2022-04-01 00:00:00 | 288000 | 2022-05-01 00:00:00 | 446400.0000000001 | 2022-06-01 00:00:00 | 576000
Branch 5 | 2022-04-13 09:36:00 | 172800 | 2022-05-01 00:00:00 | 297600 | 2022-06-01 00:00:00 | 432000.0000000001 | 2022-07-01 00:00:00 | 595200
Branch 6 | 2022-05-08 00:00:00 | 240000 | 2022-06-01 00:00:00 | 288000 | 2022-07-01 00:00:00 | 446400.0000000001 | 2022-08-01 00:00:00 | 595200
Branch 7 | 2022-06-01 14:24:00 | 0 | 2022-06-01 14:24:00 | 288000 | 2022-07-01 00:00:00 | 446400.0000000001 | 2022-08-01 00:00:00 | 595200
Branch 8 | 2022-06-26 04:48:00 | 48000 | 2022-07-01 00:00:00 | 297600 | 2022-08-01 00:00:00 | 446400.0000000001 | 2022-09-01 00:00:00 | 576000
Branch 9 | 2022-07-20 19:12:00 | 115200 | 2022-08-01 00:00:00 | 297600 | 2022-09-01 00:00:00 | 432000.0000000001 | 2022-10-01 00:00:00 | 595200
Spreadsheet: 140326d1328707364-help-creating-mileage-calculation-formula-with-blank-cells-multiple-lines-ifta_mln
Sheet: 41

Resource # | Date | Employee # | Job # | Department | Leave | Enter IL | Arrive at Job | Enter WI | Return | [NAME] | [NAME] | Total Miles | Fuel Added | Fuel Added Cost | Fuel Added Type | Notes
TRUCK 41 | 2012-01-01 00:00:00 | 1234 | LS11-0003 | Landscape | 10000 | 10011 | 10055 | 10065
TRUCK 41 | 2012-01-01 00:00:00 | 1234 | LS10-0002 | Landscape |  |  | 10075 | 10105 | 10116
TRUCK 41
TRUCK 41 | 2012-01-02 00:00:00 | 1234 | LS11-0004 | Landscape | 10000 |  | 10021
TRUCK 41 | 2012-01-02 00:00:00 | 1234 | LS10-0005 | Landscape |  |  | 10028
TRUCK 41 | 2012-01-02 00:00:00 | 1234 | LS11-0006 | Landscape |  | 10035 | 10045 | 10055 | 10068
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
Spreadsheet: 757669d1638387242-v-look-up-formula-not-working-consistently-vlookup-adaptive
Sheet: Zilicus

Zilicus
Calendaring frmCreateForm
Calendaring frmTransmittalReportViewer
EndDayTool CaseHistoryEOD
EndDayTool CaseSummary
EndDayTool EndDayTool
EndDayTool frmDocViewer
InfoService frmCreateForm
InfoService frmTransmittalReportViewer
JA Motion Setting
JUDGE_WB BenchWarrant
JUDGE_WB [NAME]
JUDGE_WB Consolidate
UDGE_WB Disposition
JUDGE_WB frmCapture/ TAB design transfer
JUDGE_WB frmCapture/ TAB design certnojail
JUDGE_WB frmCapture/ TAB design compentensy
JUDGE_WB frmCapture/ TAB design igninterlock
JUDGE_WB frmCapture/ TAB design impoundment
JUDGE_WB frmCapture/ TAB design custreapretrialserv
JUDGE_WB frmCapture/ TAB design recusal
JUDGE_WB frmCapture/ TAB design pschysic
JUDGE_WB frmDLAction
JUDGE_WB frmIgnInterlockmotion
JUDGE_WB frmIgnitionInterlock
JUDGE_WB frmJail
JUDGE_WB frmMoney
JUDGE_WB frmMotions
JUDGE_WB frmOmniView
JUDGE_WB frmRehab
JUDGE_WB frmSentenceConversion
JUDGE_WB frmSetReset
JUDGE_WB frmSpecialSet
JUDGE_WB frmStayDate
JUDGE_WB frmTollMotions
PJ frmPJMain
Precourt  [NAME]
Precourt  Search
SAOPD_WB frmMain
SAOPD_WB frmOmniView
SpiritLogon SpiritMain
UserProfile frmJaJudge
UserProfile frmJas
UserProfile  frmUpdatePrivileges
UserProfile frmUpdateQueues
UserProfile frmUserProfile
DriversHistory frmDriversHist
Forms frmReportViewer
MakeNotes frmMakeNotes
MakeNotes frmNotes.
ManualRoute  frmManualRouteBO
OtherCases frmOtherCases
[NAME]
ReportJA frmReportViewer
TisViewer dhsmvPDF
ViewCase DisplayImageCT
Message Message
JUDGE_WB frmDWLS
JUDGE_WB frmCapture/ TAB design TASC BEFORE