tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 03e42918-8e3e-4983-a258-44dda05c3050
Sheet: Budget Entry

 | The University of North Carolina at Chapel Hill
 | ACCOUNTING SERVICES BUDGET ENTRY REQUEST
 | Revenue and Expense Budgets
 | Athletics, recharge centers, internal service funds
 |  |  |  |  | FY |  |  | ______
 |  |  |  |  | Date (MM/DD/YY): |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR______________
 |  |  |  |  | Dept Name:
 |  |  |  |  | Dept Number: |  |  |  |  |  |  |  |  |  |  |  |  |  | CB# | ________________
 |  |  |  |  | Dept Contact Person:
 |  |  |  |  | Phone Number:
 |  |  |  |  | Account Number: |  |  |  |  |  |  |  |  |  |  |  |  |  | ABR Method:_____________
 |  |  |  |  | Dept assign any alpha-numeric combination for BR number
 |  |  |  |  | One account number per request
 |  |  |  |  | Use whole dollars only
 | REVENUES
 | Account Number |  |  |  |  |  |  |  |  |  |  | Description |  |  |  |  |  |  |  |  | Amount |  | D/C
1
2
3
4
5
6
7
8
9
10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Revenues
 | EXPENDITURES
 |  |  |  |  | D= debit, increases expenditure budget line
 |  |  |  |  | [NAME] credit, decreases expenditure budget line
 | Account Number |  |  |  |  |  |  |  |  |  |  | Description |  |  |  |  |  |  |  |  | Amount |  | D/C
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Expenditures
 | EXPLANATION:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Change in Fund Balance
 | ____________________________________ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ____________________________________
 | Prepared by |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  |  |  |  | Department Approval |  | Date
 | ____________________________________
 | Dean's Office Approval |  |  |  |  |  |  |  |  |  |  |  | Date
Spreadsheet: 858000d1706808414-formula-to-place-worksheet-name-in-cell-on-another-worksheet-sample-sheet
Sheet: DRG Roll Up

 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 |  |  |  | Team Score
 |  |  |  | Updated 12/27/23
Spreadsheet: 836976d1689766333-time-addition-w-shift-pattern-test7
Sheet: Sheet1

SingleTime | SFDC | NewStart | NewEnd |  |  | Start | Finish
6:49:29 |  |  |  |  |  | 08:00:00 | 16:00:00
0:52:30
4:11:45
8:35:00
0:15:30
0:15:30
1:15:00
4:25:00 |  |  |  |  |  | 1001011
11:21:40
0:30:00
2:53:20
1:15:00
2:25:05
1:39:18
0:17:36
1:05:00
0:42:39.600000
Spreadsheet: 473736d1470359436-index-match-on-two-worksheets-with-duplicate-names-domy-index-match
Sheet: Sheet3

[NAME] | GNY
[NAME] | CRI
[NAME] | BRB
[NAME] | US
[NAME] | RD
[NAME] | US
[NAME] | PR
[NAME] | US
[NAME] | JP
[NAME] | PR
[NAME] | BRB
[NAME] | US
Sylka | VNZ
Vivian | PR
Spreadsheet: 045dc4ce-bacb-46a2-9e65-dc85f55467d3
Sheet: QUAERO

YEAR | EUR | 20080328 | ENPLANED DOM | ENPLANED INT | ENPLANED COM | ENPLANED TOT | TOTAL PAX | TOTAL INTL | TRANSIT PAX | NON-REV PAX | [NAME] | DEPLANED FRT | TOT FREIGHT | ENPLANED ML | DEPLANED ML | TOT FRT/ML | INTL FRT | DOM PAX A/C | DOM ALL CGO | INT PAX A/C | INT ALL CGO | COMMUTER | GA | MILITARY | TOT A/C OPS | EnpDom-1 | EnpInt-1 | EnpCom-1 | EnpTot-1 | TotPax-1 | TotInt-1 | Transit-1 | NonRev-1 | EnpFrt-1 | DepFrt-1 | TotFrt-1 | EnpMail-1 | DepMail-1 | TotF/M-1 | INTLFRT-1 | DomPaxAC-1 | DomAll-1 | IntPax-1 | IntAll-1 | Commuter-1 | GA-1 | Mili-1 | TotA/COps-1 | STATE | INTLML | INTLML-1 | ENTRYDATE | DATEMODIFIED
IATA | YEAR | MONTH | C37 | C38 | C39 | C36 | C27 | C41 | C45 | C44 | C57 | C58 | C46 | C69 | C70 | C48 | C60 | [NAME] | C19 | C4 | C20 | C22 | C24 | C25 | C1 | L37 | L38 | L39 | [NAME] | L27 | [NAME] | L45 | L44 | L57 | [NAME] | L46 | L69 | L70 | L48 | L60 | L3 | L19 | [NAME] | L20 | L22 | L24 | [NAME] | L1 |  | C67 | L67 | END
Spreadsheet: 876514d1723216168-sort-data-by-2-criteria-sample-v3
Sheet: Sheet2

Answer:
City | Sales | Classification | Grade
NY | 5 | VS | A+ |  |  | 5 | VS | A+
London | 1.5 | VS | A+ |  | London | 1.5 | VS | A+
Berlin | 4.5 | VS | A |  | Berlin | 4.5 | VS | A
Hong Kong | 0.5 | VS | C |  | Seattle | 0.3 | VB | A
Seattle | 0.3 | VB | A |  | LA | 3 | VB | A-
LA | 3 | VB | A- |  | Paris | 1.2 | VB | B
Paris | 1.2 | VB | B |  | Milan | 1 | VB | B
Milan | 1 | VB | B |  | Toronto | 0.7 | VB | B-
Toronto | 0.7 | VB | B- |  | Madrid | 2 | VB | C
Madrid | 2 | VB | C |  | Hong Kong | 0.5 | VS | C
Spreadsheet: 800918d1665996090-formula-to-get-value-according-date-copy-of-book1
Sheet: Sheet1

 |  |  |  |  |  |  | Date | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-15 00:00:00 | 2022-10-15 00:00:00 | 2022-10-15 00:00:00 | 2022-10-15 00:00:00 | 2022-10-15 00:00:00
 |  |  |  |  |  |  |  | Math | Science | Geo | History | English | Math | Science | Geo | History | English | Math | Science | Geo | History | English
 |  |  |  |  |  |  | George | A | A | A | P | P | A | A | A | A | A | A | A | P | A | A
 |  |  |  |  |  |  | [NAME] | P | P | P | P | P | A | A | A | A | A | P | P | P | P | A
 |  |  |  |  |  |  | Leen | A | A | A | A | P | P | P | P | P | P | P | P | P | P | A
 |  |  |  |  |  |  | [NAME] | A | P | P | A | A | P | A | A | A | A | A | A | A | A | A
 |  |  |  |  |  |  | [NAME] | A | A | A | A
 |  |  |  |  |  |  | Sara | A | A | A |  |  | A | A | A | A | A | P | P | P | P | P
 |  |  |  |  |  |  | Toni | A | A | A | P | P |  | A | A | A | A
 |  |  |  |  |  |  | [NAME] | A | A | A | A | A | P | P | P | P | P
 |  |  |  |  |  |  | Rachel | A | A | A | A | P | A | A | A | A | A | A | A | A | A | P
 |  |  |  |  |  |  | Dima | A | A | A | A | A | P | A | A | A | A | P | A | A | A | A
 |  |  |  |  |  |  | each date has five hours for five subject along the year
 |  |  |  |  |  |  | I need formula to search for the name that has at least one letter A as ( Absent ) and get the five letter (A and P)  according the date I entered below
 |  |  |  |  |  |  | and ignore the name that has letter P as (Present) in the five hours in that date
 |  |  |  |  |  |  | Example
 |  |  |  |  |  |  | Date | 2022-10-13 00:00:00 |  |  |  |  |  | if date I cell I25 = 15-10-2022
 |  |  |  |  |  |  |  |  | A | A | P | P
 |  |  |  |  |  |  |  |  | A | A | A | P
 |  |  |  |  |  |  |  |  | P | P | A | A
 |  |  |  |  |  |  |  |  | A | A | A
 |  |  |  |  |  |  |  |  | A | A
 |  |  |  |  |  |  |  |  | A | A | P | P
 |  |  |  |  |  |  |  |  | A | A | A | A
 |  |  |  |  |  |  |  |  | A | A | A | P
 |  |  |  |  |  |  |  |  | A | A | A | A
Spreadsheet: 154786d1336565569-run-an-if-statement-of-a-dependent-drop-down-list-application-master_john_v2
Sheet: data Sheet

Ticket/Case # | Date | Application Name | Sev | Incident Start Time | Incident End Time | Incidnet Duration in hours | Indicent Start Date | Indicent End Date | Duration in days | Description of Issue/Impact | Immediate Fix | Issue Category (Need a Name) | Issue Sub Category | Other | [NAME] if  applicable | RCA Requested | RCA Requested Date | Prbolem Record Complete Y or N | Owner of problem Record From IBM | Last Contact Date | Long Term Corrective Action | Timeline for LTCA | Owner of LTCA | Related Change Request or Incident
IN1115454 | 2012-05-04 00:00:00 | Care Planner | 1 | 08:30:00 | 09:05:00 |  | 2012-01-01 00:00:00 | 2012-01-10 00:00:00 |  | Descrption | Descrption |  |  |  |  | Y |  | Y
 |  | MCPS | 2 |  |  |  |  |  |  |  |  |  |  |  |  | N |  | N
 |  | TPS | 3
 |  | NASCO
 |  | RTMS
 |  | Outlook
 |  | 5010
 |  | Blue Squard
Spreadsheet: 274828d1383231497-how-to-show-values-less-than-or-equal-to-another-value-in-drop-down-list-data-validation-marbles-2-
Sheet: Sheet1

Number of marbles |  | validation is here |  |  |  |  |  |  | Bag | Capacity of bag | validation calc
70 |  |  |  |  |  |  |  | Red | 1 | 60
 |  |  |  |  |  |  |  | Orange | 2 | 300
 |  |  |  |  |  |  |  | Yellow | 3 | 450
 |  |  |  |  |  |  |  | Green | 4 | 150
 |  |  | in name manager
 |  |  | insert a named formula of
 |  |  | myrange | =Sheet1!$L$2:INDEX(Sheet1!$L$2:$L$5,COUNTIF(Sheet1!$L$2:$L$5,"<>0"))
Spreadsheet: 105893d1303161048-unable-to-countif-values-with-conditions-from-second-column-book2
Sheet: Sheet1

Type | Days
Dog | 0 |  |  | < 1 Day | 2 - 3 Days | 4 - 7 Days | 8 - 14 Days | > 14 Days
Cat | 0
Dog | 0
Cat | 2
Dog | 1
[NAME] | 1
Cat | 2
Dog | 3
Cat | 1
 |  |  |  |  | Examples of what the final data should be (not part of the data)
 |  |  |  |  | Days | 0 | 1 | 2 | 3
 |  |  |  |  | Final value | 1 | 2 | 2 | 0
Spreadsheet: 698520d1602015483-countif-lookup-formula-question-book2
Sheet: Template

 |  |  |  |  |  |  |  |  |  | Last Pay Date | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-04-15 00:00:00 | 46.7 | *
Docket #: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To Match:
[PHONE]-DEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-03-18 00:00:00 | 2.6 | *
[PHONE]-DEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-03-18 00:00:00 | 2.6 | *
[PHONE]-DEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-04-15 00:00:00 | 9.38 | *
[PHONE]-DEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-03-18 00:00:00 | 0.64 | *
[PHONE]-DEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-04-15 00:00:00 | 15.64 | *
[PHONE]-REP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-03-18 00:00:00 | 2.6 | *
[PHONE]-DEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-04-15 00:00:00 | 8.71 | *
[PHONE]-DEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-04-15 00:00:00 | 12.97 | *
[PHONE]-DES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-05-18 00:00:00 | 1200 | *
[PHONE]-DES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-03-30 00:00:00 | 1100 | *
Spreadsheet: 785584d1656503432-combining-lookups-sample
Sheet: Hárok1

Main database
Customer number | Standard QTY | Standard price |  |  | Customer number | Actual QTY | Price
220115 | 10000 | 110 |  |  | 220115 | 13584 | 110 | Find closest qty to standard in collumn B and use that price. For each customer separately.
220115 | 20000 | 105 |  |  | 220120 | 14389 | 110
220115 | 30000 | 100 |  |  | 220130 | 59123 | 30
220115 | 40000 | 95
220120 | 5000 | 120
220120 | 15000 | 110
220120 | 23000 | 100
220120 | 45000 | 80
220130 | 18000 | 75
220130 | 22000 | 60
220130 | 34000 | 45
220130 | 58000 | 30
Spreadsheet: 44591d1243365299-sorting-issue-book1
Sheet: Sheet1

Report | Date | Job | Rec'd | by | Rec'd | by
Number | Completed | [NAME] | Documents
65478 | 08/16/09 | 08/16/09 | 5-22-09sf
65455 | 09/14/09 | 09/14/09 | 5-2-09sf
58745 | 2009-05-07 00:00:00 | 2009-05-07 00:00:00 | 5-22-09sf
58458 | 03/19/09 | 03/19/09 | 5-20-09sf
52145 | 04/18/09 | 04/18/09 | 5-22-09sf
45214 | 04/15/09 | 04/15/09 | 5-21-09sf
23696 | 05/23/09 | 05/23/09 | 5-22-09sf
10000 | 05/22/09 | 05/22/09 | 5-22-09sf
Spreadsheet: 57267d1257380033-unable-to-make-match-certain-values-sanitized-calc
Sheet: CPIRate

CPI | [NAME]
0 | 0.75
0.01 | 0.75
0.02 | 0.75
0.03 | 0.75
0.04 | 0.75
0.05 | 0.75
0.06 | 0.75
0.07 | 0.75
0.08 | 0.75
0.09 | 0.75
0.1 | 0.75
0.11 | 0.75
0.12 | 0.75
0.13 | 0.75
0.14 | 0.75
0.15 | 0.75
0.16 | 0.75
0.17 | 0.75
0.18 | 0.75
0.19 | 0.75
0.2 | 0.75
0.21 | 0.74
0.22 | 0.73
0.23 | 0.72
0.24 | 0.71
0.25 | 0.7
0.26 | 0.69
0.27 | 0.68
0.28 | 0.67
0.29 | 0.66
0.3 | 0.65
0.31 | 0.64
0.32 | 0.63
0.33 | 0.62
0.34 | 0.61
0.35 | 0.6
0.36 | 0.59
0.37 | 0.58
0.38 | 0.57
0.39 | 0.56
0.4 | 0.55
0.41 | 0.54
0.42 | 0.53
0.43 | 0.52
0.44 | 0.51
0.45 | 0.5
0.46 | 0.49
0.47 | 0.48
0.48 | 0.47
0.49 | 0.46
0.5 | 0.45
0.51 | 0.44
0.52 | 0.43
0.53 | 0.42
0.54 | 0.41
0.55 | 0.4
0.56 | 0.39
0.57 | 0.38
0.58 | 0.37
0.59 | 0.36
0.6 | 0.35
0.61 | 0.34
0.62 | 0.33
0.63 | 0.32
0.64 | 0.31
0.65 | 0.3
0.66 | 0.29
0.67 | 0.28
0.68 | 0.27
0.69 | 0.26
0.7 | 0.25
0.71 | 0.24
0.72 | 0.23
0.73 | 0.22
0.74 | 0.21
0.75 | 0.2
0.76 | 0.19
0.77 | 0.18
0.78 | 0.17
0.79 | 0.16
0.8 | 0.15
0.81 | 0.14
0.82 | 0.13
0.83 | 0.12
0.84 | 0.109999999999999
0.85 | 0.0999999999999991
0.86 | 0.0899999999999991
0.87 | 0.0799999999999991
0.88 | 0.0699999999999991
0.89 | 0.0599999999999991
0.9 | 0.049999999999999
0.91 | 0.039999999999999
0.92 | 0.029999999999999
0.93 | 0.019999999999999
0.94 | 0.00999999999999901
0.95 | -9.99200722162641e-16
0.96 | -9.99200722162641e-16
0.97 | -9.99200722162641e-16
0.98 | -9.99200722162641e-16
0.99 | -9.99200722162641e-16
1 | -9.99200722162641e-16
Spreadsheet: daren_farmer__6608__TransportFlash
Sheet: 0002

February 2000 Transport Expense Flash
Company | Company Number |  | Commodity Expenses |  | Demand Charges |  | Payable To Pipeline | Contract Numbers | Data Source
HPLC | 12 |  | 44356 |  |  |  | Black Marlin | 96022051 | Unify Expense Report - Settlements
HPLC | 12 |  |  |  |  |  | Houston Pipeline Company | 96021987/ 96021988 | CPR (Basis Adj) Report - Includes Accrual expense and estimated intra-zone transport expense
HPLC | 12 |  | 8017 |  |  |  | Gulf Energy Pipeline |  | CPR (Basis Adj) Report
HPLC |  |  | 540 |  |  |  | [NAME] |  | CPR Report
HPLC |  |  |  |  |  |  | Coastal States Gas Transmission |  | CPR Report
HPLC |  |  | 3584 |  |  |  | Florida Gas Transmission |  | CPR Report
HPLC | 12 |  |  |  |  |  | Humble Gas Pipeline |  | CPR (Basis Adj) Report
HPLC | 12 |  |  |  |  |  | MidCon Texas Pipeline Corp. | 96006770 | Unify Expense Report - Settlements
HPLC | 12 |  | 13917 |  |  |  | Southland Energy Corporation | 96008703 | Unify Expense Report - Settlements
ECT/Texas | 16 |  | 1008.59 |  |  |  | Northern Natural Gas/Black Marlin | 96020553 | Unify Expense Report - Settlements
ECT/Texas | 16 |  | 133652.17 |  |  |  | Oasis Pipe Line Co. | 96015445/ 96016667 | Unify Expense Report - Settlements
ECT/Texas | 16 |  | 435 |  |  |  | Pan Grande Pipeline, LLC | 96019628 | Unify Expense Report - Settlements
ECT/Texas | 16 |  | 123138.56 |  |  |  | PG&E Texas Pipeline, L.P. | 96006479/ 96009903/ 96011842 | Unify Expense Report - Settlements
ECT/Texas | 16 |  |  |  | 98300 |  | Centana Storage Demand Charge | 96019236 | Unify Expense Report - Settlements
ECT/Texas | 16 |  |  |  |  |  | Houston Pipeline Company | 96007846/ 96007849 | CPR (Basis Adj) Report -includes  $179,405 for Entex
Totals
DEMAND CHARGE NOTES: |  |  |  | $93,300 demand charge is in line 36 of OA Flash Page
NOTE:
Spreadsheet: 1a9bc696-a97c-416a-89fa-af14b34e1557
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7495 | 11440 | Team I | France | FRA
7495 | 13684 | Team I | Germany | GER
7495 | 11832 | Team I | Great Britain | GBR
7495 | 11830 | Team I | Italy | ITA
7495 | 14117 | Team I | South Africa | RSA
Spreadsheet: 728217d1618371421-automatic-copy-data-to-other-sheet-based-on-date-value-samplefilehpr
Sheet: Mar-03

DAILY REPORT SHIPPING COSTS
RS NUMBER   : |  | 1 | /SB/III/2021
No | Trans Date | Ship Date | Cust 1 | Driver Name | No Pol | Type | Cust 2 | City 2 | Cust 3 | City 3
1
2
3
4
5
6
7
8
9
10
 | SUB TOTAL
 | Cilegon, | 2021-03-03 00:00:00
Spreadsheet: 155440d1336841792-make-solver-go-through-certain-numbers-used-in-index-match-test_mod
Sheet: Advanced

min | [NAME]
1 | 3 | 2 | < this is real cell for solver input
 | < this cell is used to omit invalid results (like negative numbers, numbers >3, text, etc.). It is lookup number in MATCH function
 | < this is objective cell, it needs to be maximum possible
1 | 2 | 3 | < this is lookup array
55 | 65 | 78
 |  |  |  |  |  | 55 |  | 1
 |  |  |  |  |  | 65 |  | 2
 |  |  |  |  |  | 78 |  | 3
 |  |  |  |  | Object f. |  |  | [NAME].
Spreadsheet: 292110d1390493753-dependant-list-not-working-youth-exp-form-version-3-
Sheet: Data Entry

Please complete the table below in accordance with the Expenses Guidance Notes and submit to the Admin Department. Where |  |  |  |  |  |  |  |  |  | Millage
Pastoral Support has taken place give the reason for meeting and the number of persons present. For [NAME] claims plaese |  |  |  |  |  |  |  |  |  | Please complete the table below for millageundertaken in the course of business. Please give a full description for the purpose
complete the form overleaf. Thanks you. |  |  |  |  |  |  |  |  |  | of each journey. Thank You
Date | Item | Area | Exp Cat | Budget Item | Cost | Budget Code | Dept Code | Recipt (office use) |  | Date | Journey From | Journey to | Reason for journey | Total Miles | Total @ 45p/mile | Area | Exp Cat / Budget Code | Dept Code | Checked (office use)
 |  | Services | [NAME] | na |  |  |  |  |  |  |  |  |  |  |  | Pastoring | Youth Admin
 |  | Subtotal |  |  |  |  |  |  |  |  |  |  | Total [NAME]
 |  | Plus Total Business Mileage
 |  | Grand Total
 |  |  |  |  |  |  |  |  |  | Signed .......................................    Date |  |  |  |  |  | Authorised .....................................Date            /              /
Signed .......................................    Date |  |  |  |  | Authorised .....................................Date            /              /
Spreadsheet: 116095d1311598504-pull-text-from-a-text-string-excel-forum-1-
Sheet: db101

[NAME] | 14
[NAME] | 14
[NAME] | NON
[NAME] | OFF
[NAME] | 47
[NAME] | 47
[NAME] | MAX
[NAME] | ON
[NAME] | 0
[NAME] | 0
[NAME] | NON
[NAME] | OFF
[NAME] | 34
[NAME] | 34
[NAME] | NON
[NAME] | OFF
[NAME] | 0
Split 1 Phase 5 Primary | 0
[NAME] | NON
[NAME] | OFF
[NAME] | 61
[NAME] | 61
[NAME] | MAX
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | NON
[NAME] | OFF
[NAME] | 34
[NAME] | 34
[NAME] | NON
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
[NAME] 14 Time | 0
[NAME] | 0
[NAME] 14 Mode | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] 15 Mode | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
Spreadsheet: 71573d1272354774-vlookup-if-blank-do-vlokup-to-a-different-column-test-file
Sheet: Service No

Differential Details | Servicetag | Hostname
 | 8221KN7Z202V
 | CZC34603ZS
 | CZC34603V2
 | CZC347106Q
 | CZC3471069
 | 8134FHGZ0DTT
 | 8944CV620246
 | 8938CV623896
 | 8944CV620246
 | 8938CV623896
 | 5TZK92J
 | 7F6JL2J
 | 40KGK3J
 | 3VPGK3J
 | 2WPGK3J
Spreadsheet: 108716d1305720675-populating-a-top-ten-list-book2
Sheet: Sheet1

Name-- | -Department-- | --Useless Stat-- | ---Useful Stat--- | Ranking
Sally--- | 3 | 0.71 | 0.84 | 1
Joe----- | 2 | 0.92 | 0.78 | 2
[NAME] | 1 | 0.56 | 0.76 | 3
John--- | 2 | 0.95 | 0.67 | 4
Danny- | 1 | 0.54 | 0.65 | 5
Joe----- | 2 | 0.96 | 0.63 | 6
Billy---- | 1 | 0.78 | 0.44 | 7
Spreadsheet: 867530d1714388001-using-array-formula-and-relative-referencing-most-efficiently-sample-data
Sheet: Sheet1

 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
Spreadsheet: 31757d1227709227-add-cells-with-color-only-generic-hours-and-miles_2008
Sheet: Year End

YEAR END | Year Total
 | HOURS | [NAME]
 |  | 45
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
AB Hours /Job | 0
 |  | 15
AB-CD /Job
 | 0
Spreadsheet: 141376d1329238492-can-only-select-a-drop-down-option-once-0201_b
Sheet: Sheet1

Name | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 |  |  |  |  |  |  |  |  |  |  |  |  | Arsenal | 1 | Arsenal
[NAME] | Wigan Athletic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 3 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 4 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chelseaa | 5 | Chelseaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Evertona | 6 | Evertona
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fulham | 7 | Fulham
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Liverpool | 8 | Liverpool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manchester City | 9 | Manchester City
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 10 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Newcastle United | 11 | Newcastle United
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Norwich City | 12 | Norwich City
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Queens Park Rangers | 13 | Queens Park Rangers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stoke City | 14 | Stoke City
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunderland | 15 | Sunderland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Swansea City | 16 | Swansea City
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 17 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | West Bromwich Albion | 18 | West Bromwich Albion
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wigan Athletic |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
Spreadsheet: 874103d1720669862-sla-in-minutes-exclude-non-working-days-weekend-and-public-holidays-and-specific-datetime-excel-formula__
Sheet: Sheet1

Ticket Update DateTime | Ticket Solve DateTime | Expected Result |  |  |  | Public Holiday |  | Start Hour | End Hour
2024-06-02 18:33:22 | 2024-06-19 18:25:30 | 5940 |  |  |  | 2024-06-03 00:00:00 |  | 09:00:00 | 18:00:00
2024-06-19 18:25:30 | 2024-06-28 16:10:00 | 3670 |  |  |  | 2024-06-17 00:00:00
2024-06-02 10:57:46 | 2024-06-28 16:08:02 | 9608
2024-06-02 12:02:41 | 2024-06-14 14:06:03 | 4626
2024-06-06 12:50:16 | 2024-06-28 16:07:05 | 8217