tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 329732d1404393548-how-to-sort-month-and-year-into-oldest-to-new-a-z-order-book-raysrains
Sheet: Aging

Row Labels | Sum of Sterling Value
INTERCO | 2106113.96
Aug-14 | 300326.6199999998
Dec-14 | 23636
Dec-20 | 0
Jan-15 | 496859
Jul-14 | 741469.7100000004
Jun-14 | 88725.01999999999
May-14 | 10562.02
Nov-14 | 2647.17
Oct-14 | 313858.46
Sep-14 | 128029.96
REAL | 7083402.370000001
Apr-14 | 3070
Apr-15 | 7548
Aug-14 | 1152722.3
Dec-14 | 489520.7300000002
Dec-15 | 1110791.72
Feb-15 | 7548
Jan-14 | 1818
Jan-15 | 46718.5
Jul-14 | 2508826.610000001
Jun-14 | 165106.39
Mar-15 | 7548
May-14 | 27364
May-15 | 7548
Nov-14 | 59028.64
Oct-14 | 426863.9700000001
Oct-15 | 3800
Sep-14 | 1057579.51
Grand Total | 9189516.33
How to sort BELOW month and year into oldest to new (A-Z)
 |  |  |  | New figures Can place below
INTERCO
Spreadsheet: 390084d1429493510-copying-filtered-data-into-another-worksheet-docs
Sheet: Información de Liga

Players | Team | Liga | Posición | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Jornada 6 | Jornada 7 | Jornada 8 | Jornada 9 | Jornada 10 | Jornada 11 | Partidos Jugados | Puntos de Experiencia | Media
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 11a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis | 556 |  | 556
 | FRA | 17168 |  | 17168
 | Exotic
 | Inflation
 | IRS- [NAME] | 29393 |  | 29393
 | OIS | 1606 |  | 1606
 | VNS | <100 |  | <100
 | Zero Coupon | 132 |  | 132
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | 48855 | N/A*** | 48855
Estimated swap transaction volumes, week ending February 15, by product type and tenor (millions of USD), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 785300d1656335166-formula-required-to-identify-presence-of-activity-by-type-by-individual-per-month-test-files
Sheet: Sheet1

 |  |  | Caller ID | Contact 1 | Contact 1 Result | Contact 2 | Contact 2 Result | Contact 3 | Contact 3 Result | Contact 4 | Contact 4 Result | Contact 5 | Contact 5 Result
 |  |  | 1 | 2022-06-27 00:00:00 | Hang up | 2022-06-28 00:00:00 | Hang up | 2022-07-04 00:00:00 | Purchased
 |  |  | 2 | 2022-05-28 00:00:00 | Purchased | 2022-06-29 00:00:00 | Hang up | 2022-07-02 00:00:00 | Purchased | 2022-07-04 00:00:00 | Purchased | 2022-07-05 00:00:00 | Call back
 |  |  | 3 | 2022-06-29 00:00:00 | Purchased | 2022-06-30 00:00:00 | Purchased | 2022-07-01 00:00:00 | Hang up | 2022-07-02 00:00:00 | Purchased | 2022-08-03 00:00:00 | Hang up
 |  |  | 4 | 2022-06-30 00:00:00 | Call back | 2022-07-01 00:00:00 | Purchased | 2022-07-04 00:00:00 | Purchased | 2022-08-05 00:00:00 | Call back
 |  |  | 5 | 2022-07-01 00:00:00 | Hang up | 2022-07-02 00:00:00 | Call back | 2022-07-03 00:00:00 | Purchased
 |  |  | This is the data I would like
 |  |  | Number of callers hang up in July |  |  | 2
 |  |  | Number of callers Purchased in July |  |  | 5
 |  |  | Number of callers Call back in July |  |  | 2
 |  |  | This is the data I do not want
 |  |  | Number of hang up in July |  |  | 2
 |  |  | Number of Purchased in July |  |  | 7
 |  |  | Number of Call back in July |  |  | 2
Month | Activity | Count
June | Hang up | 3
July | Purchased | 7
May | Purchased | 1
July | Call back | 2
June | Purchased | 2
July | Hang up | 2
August | Hang up | 1
June | Call back | 1
August | Call back | 1
Spreadsheet: 0588b004-ce88-4a31-81ff-a3a60b353cb8
Sheet: Flowchart

 |  |  |  |  |  |  |  |  |  |  |  |  | Student Name:
 |  |  |  |  |  |  |  |  |  |  |  |  | Student Number:
 |  |  |  |  |  |  |  |  |  |  |  |  | Class year:
 |  |  |  |  |  |  |  |  |  |  |  |  | Advisor:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mag factor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.63 | Want
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.79 |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.75 |  | 24
 | Pre-calculus
 |  |  |  |  |  |  |  |  | Senior standing
 |  |  |  |  |  |  |  |  | Permission of academic advisor
 |  |  |  |  | Steps to your goal:
 |  |  |  |  |  |  |  |  | Key
 |  |  |  |  |  |  |  |  | Pre-requisite:
 |  |  |  |  |  |  |  |  | Co-requisite
 |  |  |  |  |  |  | Our mission is to prepare exceptional engineers!
Spreadsheet: 44510d1243266221-vlookup-problem-vlookup-problem
Sheet: Sheet1

w |  | 2a | 3c
1 |  | 1b | 1a
2c |  | 2c | 2b
2b |  | #N/A | #N/A
2a |  | #N/A | #N/A
3 |  | 3b | 3a
w | w | 1c | 1c | 1b | 1b
1 | 1b | 1a | 1a | 2c | 2c
2c | 2c | 2b | 2b | 2a | 2a
2b | 2b | 2a | 2a | 3c | 3c
2a | 2a | 3c | 3c | 3b | 3b
3 | 3b | 3a | 3a | 4c | 4c
Spreadsheet: 728461d1618478097-formula-for-match-report-02
Sheet: WK01

Week 01
KPI |  |  | Delivery Performance
Service Type |  |  | TA |  |  | AM |  |  | A |  |  | True A (A - TA & AM) |  |  | B-D |  |  | Total Performance
Depot Number | Region | On [NAME] | Due | Suc. | % | Due | Suc. | % | Due | Suc. | % | Due | Suc. | % | Due | Suc. | % | Due | Suc. | %
Overall | N/A | N
001 - Depot 01 | H | Y
002 - Depot 02 | H | Y
003 - Depot 03 | M | Y
004 - Depot 04 | P | Y
005 - Depot 05 | H | Y
006 - Depot 06 | P | N
007 - Depot 07 | H | Y
008 - Depot 08 | M | Y
009 - Depot 09 | M | N
010 - Depot 10 | M | N
Spreadsheet: 483877d1475907766-how-to-lookup-a-cell-that-is-both-along-a-vertical-and-horizontal-logon-report
Sheet: Raw Data

1066 - Reggie Tillar
Time logged on |  |  | 09:01:00
Time in status not ready |  |  | 59mins
Time logged off |  |  | 18:03:00
1200 - Billy Bob
Time logged on |  |  | 08:30:00
Time in status not ready |  |  | 47mins
Time logged off |  |  | 16:37:00
1069 - [NAME]
Time logged on |  |  | 10:00:00
Time in status not ready |  |  | 61mins
Time logged off |  |  | 19:00:00
Spreadsheet: 874898d1721402666-array-with-a-delayed-sequence-array-count-full
Sheet: Logistics (2)

 |  | ANSWER PROVIDED BY windknife
 |  | 0 |  | 4 | 7 | 2 | 5
 |  |  | 1 | 4 | 7 | 2 | 5
 |  |  | 1 | 4 | 7 | 2 | 5
 |  |  | 1 | 4 | 7 | 2 | 5
 |  |  | 1 | 5 | 7 | 2 | 6
 |  |  | 1 | 5 | 7 | 2 | 6
 |  |  | 1 | 5 | 7 | 2 | 6
 |  |  | 2 | 5 | 8 | 3 | 6
 |  |  | 2 | 5 | 8 | 3 | 6
 |  |  | 2 | 5 | 8 | 3 | 6
 |  |  | 2 | 5 | 8 | 3 | 6
 |  |  | 2 | 6 | 8 | 3 | 7
 |  |  | 2 | 6 | 8 | 3 | 7
 |  |  | 2 | 6 | 8 | 3 | 7
 |  |  | 3 | 6 | 1 | 4 | 7
 |  |  | 3 | 6 | 1 | 4 | 7
 |  |  | 3 | 6 | 1 | 4 | 7
 |  |  | 3 | 6 | 1 | 4 | 7
 |  |  | 3 | 0 | 1 | 4 | 0
 |  |  | 3 | 0 | 1 | 4 | 0
 |  |  | 3 | 0 | 1 | 4 | 0
 |  |  | 4 | 0 | 0 | 5 | 0
 |  |  | 4 | 0 | 0 | 5 | 0
 |  |  | 4 | 0 | 0 | 5 | 0
 |  | Formual in D6 to check against range>> | 4 | 3 | 3 | 4 | 3
 |  |  |  | [NAME] in Column E should exclude 4 because it has already started in column D
 |  |  |  | when comparing to E31. In other words it should only count 5 and 6
 |  |  |  | and then a sequence of 7s should be included and only pause thereafter
Spreadsheet: 85629d1285699897-appear-disappear-series-in-chart-oinot-select-series-to-display-1-
Sheet: Graph Data

Data for graphing goes here. Do not enter any actual data on this sheet, enter it on "Raw Data"
Check with an X series to display:
 | True | False | False | False | False | False
Spreadsheet: 841309d1693496958-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-ef-file
Sheet: 3-5 Night

 | CR1 | Priority | Headcount
1 | Alinity RV | High | 0.25
2 | Alinity RV | High | 0.25
3 | Alinity RV | High | 0.25
4 | Alinity RV | High | 0.25
5 | Alinity RV | High | 0.25
12 | Baxter neck | Low
13 | Baxter cap | High | 0.25
9 | Architect RV | High | 0.25
15 | [NAME] | High | 0.5
16 | Architect RV | High | 0.25
17 | Alinity RV | High | 0.25
50 | Baxter SIV Assy | Medium
31 | Architect RV | High | 0.25
8 | Alinity RV | High | 0.25
10 | Architect RV | High | 0.25
11 | [NAME] | Low
18 | Architect RV | High | 0.25
19 | Architect RV | High | 0.25
20 | [NAME] | Med/High | 1 | run for 6 hours and pack off later
21 | Architect RV | High | 0.25
22 | Architect RV | High | 0.25
23 | Architect RV | High | 0.25
30 | Architect RV | High | 0.25
7 | Architect SC | Med/High | 0.5
Total
 | CR2 | Priority
71 | PP4 | High | 0.25
72 | 8ul | High
73 | PP1 | High | 0.25
74 | 6ul | High | 0.25
76 | PP3 ES
77 | Base Cassette | High | 1
78 | Side Cassette B | High | 0.25
79 | [NAME] | High | 0.25
87 | Top Frame A | High | 0.25
52 | Architect RV | High | 0.25
53 | Architect RV | High | 0.25
54 | Siemens KS860 | High | 0.5
59 | Architect RV | High | 0.25
61 | [NAME] trays | High | 0.5
66 | [NAME] | High | 0.5
83 | Over [NAME] | Medium
84 | Ceph MB#1 | * |  | Shutdown at night if running
86 | [NAME] | Med/High
62 | NP227 | Low
63 | NP Birdcage | Low
64 | Siemens 1ML | High
67 | [NAME] | High | 0.25
69
88 | Side Pump | High | 0.25
89 | Top Frame B | High | 0.25
95 | Beckman Unicel E | Low
96 | Beckman Unicel F | Low
106
107 | Snap Ring | Medium
108 | [NAME] shell | High | 0.25
109
Total
 | [NAME] |  | 1.25
 | [NAME] |  | 1
 |  |  |  |  |  | 15
Spreadsheet: 07fa19e2-8ed1-4adf-b6c6-914928463d66
Sheet: Sheet1

Ingenuity Canonical Pathways | Unnamed: 1 | -Log(P-value) | Ratio | Molecules
Endocytosis |  | 3.73 | 0.0494 | [NAME], [NAME], ACTA1, ITGB3
Clatrin-mediated Endocytosis |  | 3.62 | 0.0303 | FGF2, [NAME], [NAME], ACTA1, ITGB3
[NAME] |  | 3.22 | 0.0259 | [NAME], [NAME], MAP2K1, ACTA1, ITGB3
[NAME] |  | 3.09 | 0.0225 | FGF2, [NAME], [NAME], MAP2K1, ACTA1
VEGF Signaling |  | 2.42 | 0.0326 | [NAME], MAP2K1, ACTA1
EGF Signaling |  | 1.9 | 0.0426 | SRF, MAP2K1
Spreadsheet: 874632d1721195478-sla-in-minutes-exclude-non-working-days-weekend-and-public-holidays-and-specific-datetime-sla-in-minutes-exclude-non-working-days-weekend-and-public-holidays-and-specific-datetime
Sheet: JT

Ticket Update DateTime | Ticket Solve DateTime |  |  | JT |  | Public Holiday |  | Start Hour | End Hour |  | 1st Workday | Last Workday | # Workdays | 1st Work Hours | Last Work Hours | Mid Day Hours | Total Hours | Combined Formula
2024-06-02 18:33:22 | 2024-06-17 08:00:00 |  |  |  |  | 2024-06-03 00:00:00 |  | 09:00:00 | 18:00:00
2024-06-19 18:25:30 | 2024-06-28 16:10:00 |  |  |  |  | 2024-06-17 00:00:00
2024-06-02 10:57:46 | 2024-06-28 16:08:02
2024-06-02 12:02:41 | 2024-06-14 14:06:03
2024-06-06 12:50:16 | 2024-06-28 16:07:05
Total Working Minutes |  |  |  | In C2, copy down:
 | 0
 | 0
 |  |  |  | SLA (in minutes) Exclude non-working Days, Weekend & Public Holidays & specific Datetime
 |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1426111-sla-in-minutes-exclude-non-working-days-weekend-and-public-holidays-and-specific-datetime.html#post5965980
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 781559d1653414946-averageif-across-multiple-sheets-q1-agents-metrics-copy
Sheet: Agents

Agent | Session | System | Working | Wrap | Idle | Talk In | Talk Out | Set | Holds | Tot. Talk
LESLEY BROWN
LESIA HAWKINS
NICHELLE RAINES
TRICIA CHAMBERS
[NAME]
ANNE SLONE
PATRICIA CHAMBERS
AKIRA CROSS
KIMBERLY BEAVERS
EBONY RICHARDSON
PATRICIA WILLYARD
SHIRLEY LYALLS
AMANDA THOMPSON
CARLY ALLGOOD
[NAME]
KEANDRIA DUBLIN
CHASITY DAVIS
ELLI-GRACE PROVENCE
MIRANDA RICHMOND
JALEAHA ROBINSON
[NAME]
NATASHA WIDEMAN
TRAINER LESLEY
Spreadsheet: 783998d1655338737-owed-time-between-sheets-owed-time
Sheet: working time

Date | Agent Name | Agent ID | Unavailable Code | [NAME] | Team Name | Handle Time | Inbound Hold Time | Inbound Active Talk Time | Inbound Conference Time | Inbound Handle Time | Outbound Active Talk Time | Outbound Conference Time | Outbound Handle Time | Outbound Hold Time | Unavailable Time minus ACW | ACW Time | Unavailable Codes Time | Available Time | Working Time | [NAME]
2022-06-13 00:00:00 | Caceres, Cristian | 30313196 |  |  | SAL_CF |  |  |  |  |  |  |  |  |  | 50.91 |  |  | 6716.82 | 6716.82 | 6767.74
2022-06-13 00:00:00 | Caceres, Cristian | 30313196 |  | CF_General | SAL_CF | 1783.84 |  | 1783.84 |  | 1783.84 |  |  |  |  |  |  |  |  | 1783.76 | 1783.76
2022-06-13 00:00:00 | Caceres, Cristian | 30313196 |  | CF_Plus | SAL_CF | 9405 | 446.42 | 8958.58 |  | 9405 |  |  |  |  |  |  |  |  | 8978.18 | 8978.18
2022-06-13 00:00:00 | Caceres, Cristian | 30313196 |  | OB_ChoiceDigital | SAL_CF | 425.04 |  |  |  |  | 425.04 |  | 425.04 |  |  |  |  |  | 426.65 | 426.65
2022-06-13 00:00:00 | Caceres, Cristian | 30313196 | Break |  | SAL_CF |  |  |  |  |  |  |  |  |  | 611.83 |  | 611.83 |  |  | 611.83
2022-06-13 00:00:00 | Caceres, Cristian | 30313196 | InboundPending |  | SAL_CF |  |  |  |  |  |  |  |  |  | 768.21 |  |  |  |  | 768.21
2022-06-13 00:00:00 | Caceres, Cristian | 30313196 | OutboundPending |  | SAL_CF |  |  |  |  |  |  |  |  |  | 0.04 |  |  |  |  | 0.04
2022-06-13 00:00:00 | Caceres, Cristian | 30313196 | Personal |  | SAL_CF |  |  |  |  |  |  |  |  |  | 300.14 |  | 300.14 |  |  | 300.14
2022-06-13 00:00:00 | Caceres, Cristian | 30313196 | Refused | CF_Plus | SAL_CF |  |  |  |  |  |  |  |  |  | 223.94 |  |  |  |  | 223.94
2020-06-13 00:00:00 | [NAME], [NAME] | 23654596 | Break |  | SAL_CF |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 426.84
2020-06-13 00:00:00 | [NAME], [NAME] | 23654596 | Personal |  | SAL_CF | 1783.84 |  | 1783.84 |  | 1783.84 |  |  |  |  |  |  |  |  | 1783.76 | 2868.8
2020-06-13 00:00:00 | [NAME], [NAME] | 23654596 | Break |  | SAL_CF | 9405 | 446.42 | 8958.58 |  | 9405 |  |  |  |  |  |  |  |  | 8978.18 | 365.76
2020-06-13 00:00:00 | [NAME], [NAME] | 23654596 | InboundPending |  | SAL_CF | 425.04 |  |  |  |  | 425.04 |  | 425.04 |  |  |  |  |  | 426.65 | 2547.3
2020-06-13 00:00:00 | [NAME], [NAME] | 23654596 | InboundPending |  | SAL_CF |  |  |  |  |  |  |  |  |  | 611.83 |  | 611.83 |  |  | 4587.54
Spreadsheet: 159436d1338645606-how-to-look-up-two-cells-and-display-a-result-but-the-cells-to-look-up-are-not-constant-development_indirect-vlookup-_swing-ticket-test
Sheet: SwingTicketOrderForm

Ship To Name |  | [NAME] |  |  |  |  | Contact | [NAME]
Address 1 |  | [NAME] |  |  |  |  | Phone | 852-22339922
Address 2 |  | Happy Street |  |  |  |  | Fax | 852-22339900
Address 3 |  | Shatin |  |  |  |  | [NAME] | [EMAIL]
City |  | Hong Kong |  |  |  |  | Order Date: |  | 2012-05-31 00:00:00
State |  |  |  |  |  |  | Ship Method: |  | REGULAR
Zip |  | 00000 |  |  |  |  | Date Required:
Country |  | ANTARCTICA |  |  |  |  | Total Order Qty: |  | 100
Department No. |  | T32 Shapewear & Separates |  |  |  |  | Stroke No. |  | 5089
[NAME] |  | DIR FOOK WAH CHINA |  |  |  |  | Supplier No. |  | 8254
Lead Factory |  |  | ABC Factory
PO Number |  |  | 1063710
MSRP (GBP) |  |  | 25
Ticket/Label Name |  |  | ST/M2102OT - Standard Barcode Swing Ticket (test)
Country of Origin |  |  | China
Line# | Colour |  | Primary Size |  | Pantone | Secondary [NAME] |  | UPC |  | [NAME] |  |  | Qty
1 | T1 - GREY MIX |  | 35 |  | 134C | MINI |  | 8202635 |  |  |  |  | 100
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 770013d1645780665-n-a-error-with-complex-nested-offset-functions-s1_my-file
Sheet: hourly data

Arithmetic mean from 11/02/2022 at  12:56:26 to 14/02/2022  08:26:26 -  hourly data - sample interval 3,20
 | Indoor Thermocouple | Outdoor Thermocouple | Heat Flux Sensor
Time | cDAQ3Mod1/ai0 | cDAQ3Mod1/ai11 | cDAQ3Mod2/ai0
00:00:00
01:00:00
02:00:00
03:00:00
04:00:00
05:00:00
06:00:00
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
16:00:00
17:00:00
18:00:00
19:00:00
20:00:00
21:00:00
22:00:00
23:00:00
00:00:00
01:00:00
02:00:00
03:00:00
04:00:00
05:00:00
06:00:00
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
16:00:00
17:00:00
18:00:00
19:00:00
20:00:00
21:00:00
22:00:00
23:00:00
00:00:00
01:00:00
02:00:00
03:00:00
04:00:00
05:00:00
06:00:00
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
16:00:00
17:00:00
18:00:00
19:00:00
Spreadsheet: 231504d1367098248-two-misaligned-cells-16-team-planning-bracket
Sheet: 106

az106 | Aztec | 1
bl106 | Bloomfield
cib106 | Cibola
cle106 | Cleveland
far106 | Farmington
gal106 | Gallup
[NAME] | Grants | 8
[NAME] | [NAME]
miy106 | Miyamura | 5
new106 | Newcomb
pv106 | Piedra Vista
rr106 | Rio Rancho
sf106 | Santa Fe
ship106 | Shiprock
vv106 | [NAME] | 4
win106 | Wingate
 |  | 3
Paste Value - CTRL-N
 |  | 6
 |  | 7
 |  | 2
Spreadsheet: 786564d1657272296-return-value-or-address-which-is-not-ok-question
Sheet: Sheet1

[NAME] Y (3155 mm) |  |  |  |  |  |  |  |  |  |  |  |  | MP01
Side | MP | Deviation | BL | Deviation | Misalignment |  |  |  |  |  |  |  |  |  |  |  | user will first choose which elements MP01 vs BL08 in this case
Left | 3151 |  | 3152.9
Right | 3145 |  | 3157.3 |  |  |  |  |  |  |  |  |  | MP BL
 |  |  |  |  |  |  |  |  |  |  |  | MP [NAME] and BL Stabbing Pins Tangential Distances
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] Y (3155 mm)
 | I would like for Excel to give me the address and/or value which is not OK hence NOK. In this case F4 or 12.3 |  |  |  |  |  |  |  |  |  |  | Side | MP | Deviation | BL | Deviation | Misalignment
 |  |  |  |  |  |  |  |  |  |  |  | Left | 3151 | -4 | 3152.87 | -2.130000000000109 |  |  | according to the choice of the user, the values on the MP and BL columes here will change
 |  |  |  |  |  |  |  |  |  |  |  | Right | 3145 | -10 | 3157.33 | 2.329999999999927 |  |  | then the misalignment is calculated, more than 10 is not good
 |  |  |  |  |  |  |  |  |  |  |  | Upper Supports X ( ±1573 [NAME]; ±2 MP; ±3 mm BL) |  |  |  |  |  |  | so in some cases the NOK may be on R12 or R22 etc.
 |  |  |  |  |  |  |  |  |  |  |  | Side | MP | Deviation | BL | Deviation | Misalignment
 |  |  |  |  |  |  |  |  |  |  |  | Left | -1572 | 1 | -1574.4 | -1.400000000000091 |  |  | so Excel searches for a NOK on column S, then returns value and/or address in this case 12.3 or R9
 |  |  |  |  |  |  |  |  |  |  |  | Right | 1572 | -1 | 1570.74 | -2.259999999999991
 |  |  |  |  |  |  |  |  |  |  |  | Lower Supports Y (3445 mm)
 |  |  |  |  |  |  |  |  |  |  |  | Side | MP | Deviation | BL | Deviation | Misalignment
 |  |  |  |  |  |  |  |  |  |  |  | Left | 3441 | -4 | 3444.62 | -0.3800000000001091
 |  |  |  |  |  |  |  |  |  |  |  | Right | 3437 | -8 | 3445.38 | 0.3800000000001091
 |  |  |  |  |  |  |  |  |  |  |  | Lower Supports X ( ±900 mm; ±2 MP; ±3 mm BL)
 |  |  |  |  |  |  |  |  |  |  |  | Side | MP | Deviation | BL | Deviation | Misalignment
 |  |  |  |  |  |  |  |  |  |  |  | Left | -899 | 1 | -899.74 | 0.2599999999999909
 |  |  |  |  |  |  |  |  |  |  |  | Right | 899 | -1 | 899.74 | -0.2599999999999909
Spreadsheet: 856700d1705920155-pivot-table-from-different-sheets-not-in-a-nice-large-data-table-attendance-missed-session-catch-up-log-test
Sheet: Learner9

 | Attendance |  |  |  | Additional support plans
Name | P3 | P6 | P9 | P12 | Declared but Declined | University Learning Support Plan from DDSS | Departmental Support plan | Return to Learning Support Plan | Functional Skills training and progress
Learner9
Session missed | Module | Tutor(s) | How missed work was caught up |  |  | Auto completed by Att spreadsheet
2023-09-05 00:00:00 | MGT61102 | Tutor 1 | (tutor to complete) |  |  | PS to link
2023-09-06 00:00:00 | MGT61102 | Tutor 2 | (tutor to complete) |  |  | PS to complete
2023-09-11 00:00:00 | MGT61100 | Tutor 3 | (tutor to complete) |  |  | tutor to complete
2023-10-02 00:00:00 | MGT61104 | Tutor 4 | (tutor to complete)
2023-10-03 00:00:00 | MGT61104 | Tutor 4 | (tutor to complete)
2023-10-30 00:00:00 | MGT61104 | Tutor 4 | (tutor to complete)
2023-10-31 00:00:00 | MGT61104 | Tutor 4 | (tutor to complete)
Spreadsheet: 173320d1344515649-excel-formula-for-ip-address-ips-location-lookup
Sheet: Locations

Locations | IP |  |  |  |  | Eaxmples
<[NAME] | 10.138.132.107 |  |  |  |  |  | Locations | IP
<[NAME] | 10.138.132.109 |  |  |  |  |  | B | 10.138.132.107
<[NAME] | 10.138.132.11 |  |  |  |  |  | B | 10.138.132.109
<[NAME] | 10.139.120.5 |  |  |  |  |  | B | 10.138.132.11
<[NAME] | 10.139.118.32 |  |  |  |  |  | LT | 10.139.120.5
<[NAME] | 10.139.104.24 |  |  |  |  |  | L | 10.139.118.32
<[NAME] | 10.139.102.7 |  |  |  |  |  | H | 10.139.104.24
<[NAME] | 10.139.119.63 |  |  |  |  |  | N | 10.139.102.7
<[NAME] | 10.139.119.63 |  |  |  |  |  | L | 10.139.119.63
<[NAME] | 10.139.119.76 |  |  |  |  |  | L | 10.139.119.63
<[NAME] | 10.139.101.2 |  |  |  |  |  | L | 10.139.119.76
 |  |  |  |  |  |  | T | 10.139.101.2
Spreadsheet: louise_kitchen__24243__SepYTD Orig w notes Revised
Sheet: Mariner

Mariner
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
MPR Activity
Thompson/Josey |  | Mariner Combined Debt, Interest Component |  | Mariner
Thompson/Josey |  | Mariner Combined Debt, Fair Value Component |  | Mariner
Thompson/Josey |  | MEGS (Strategic) |  | Mariner |  | 0
Thompson/Josey |  | Mariner Combined Debt, Commodity Component |  | Mariner
Thompson/Josey |  | Treasury Swap A |  | Mariner
Total
Spreadsheet: kevin_ruscitti__20261__OPEN11b
Sheet: gdcalc

 | Hhub Basis |  | [NAME] |  |  | bid | offer
march | -1.25 | -0.75 | -0.75 | -0.25
april | -0.25 | 0.25 | -0.25 | 0.25
Apr Oct | -0.25 | 0.25 | 0
nov mar |  |  |  |  |  |  |  | mids
 | ANR basis |  | [NAME] |  |  | Bid | Offer
march | -10.75 | -10.25 | -1 | 0
april | -9 | -8 | -0.25 | 0.25
Apr Oct | -7.25 | -6.25 | -0.25 | 0.25
nov mar
 | NGPLLA Basis |  | NGPL LA GD/D IX
march | -10 | -9.5 | -1 | 0
april | -8.5 | -7.5 | -0.25 | 0.25
Apr Oct | -6.75 | -5.75 | 0.5 | 1
nov mar
 | TxOk Basis |  | TxOkGD/D IX
march | -9.75 | -9.25 | -2.5 | -0.5
april | -7.5 | -7 | -0.75 | -0.25
Apr Oct | -6.75 | -6.25 | 0.25 | 0.75
nov mar
 | [NAME] |  | [NAME]
march | -13 | -12.5 | -5 | -45
april | -11 | -10.5 | -0.5 | 0.5
Apr Oct | -10 | -9.5 | 0.75 | 1.25
nov mar
 | Relt E |  | [NAME]
march | -8 | -7.5 | -2 | -1
april | -8.5 | -8 | -0.5 | 0
Apr Oct | -8 | -7.5 | 0.25 | 0.75
nov mar
 | CHIC
Spreadsheet: 166447d1341587475-filling-a-table-using-a-database-while-finding-the-nearest-value-for-two-parameter-ph
Sheet: Sheet1

 |  |  | X
 |  |  | 10 | 20 | 30 | 40 | 50 | 60
 | Y | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  |  |  |  |  |  |  |  |  |  | X | Y | Ph
 |  |  |  |  |  |  |  |  |  |  | 10 | 3
 |  |  |  |  |  |  |  |  |  |  | 20 | 5
 |  |  |  |  |  |  |  |  |  |  | 34 | 7
 |  |  |  |  |  |  |  |  |  |  | 42 | 3
 |  |  |  |  |  |  |  |  |  |  | 59 | 4
Spreadsheet: 470219d1468399919-date-format-change-date-format
Sheet: Sheet1

VersionDate
Feb  3 2016  5:44PM
Jun  3 2014  5:51PM
Apr  9 2015  9:23PM
Mar 17 2016 12:35PM
Jun  9 2016 12:13PM
Jun 16 2016  7:14PM
Apr  9 2015  9:23PM
Apr  9 2015  9:23PM
Apr  9 2015  9:23PM
Mar 17 2016 12:35PM
Mar 17 2016 12:35PM
Mar 17 2016 12:35PM
Jan 25 2016  [NAME]
Feb 13 2014  3:22PM
Feb 11 2014  2:42PM
Sep 29 2014  7:01PM
Sep 24 2015  6:06PM
Nov 26 2014  9:55PM
Sep 24 2014 11:49AM
Spreadsheet: 93821d1293606303-if-formula-to-replace-initials-with-numbers-randoms-calculator
Sheet: Sheet1

Ranking | [NAME]
1 | JF |  | Fin | Dr | [NAME] | Gr Age | Rating | Earnings |  |  |  |  |  |  |  |  |  | Lbs | [NAME] | LBW | Random
2 | JS |  |  |  |  | Sex
3 | [NAME] |  | 1 | 4 | Ace Mc Shane | G2 5F | 99 | US$142.33 | 19 | 11 | 3 | 10 | 6 | 4 | 1 | 0 | 0 | 108 | MC | 0
4 | PO |  | 2 | 2 | Patient Apostle | G2 7M | 100 | US$209.20 | 23 | 10 | 3 | 17 | 6 | 6 | 0 | 0 | 0 | 120 | BA | 1.68
5 | HN |  | 3 | 3 | Milin | G2 6M | 103 | US$123.53 | 23 | 10 | 3 | 6 | 3 | 2 | 1 | 0 | 1 | 120 | EM | 2.55
6 | MH |  | 4 | 1 | Summary View | G2 4M | 100 | US$103.33 | 14 | 4 | 3 | 18 | 13 | 0 | 0 | 0 | 0 | 120 | TK | 3.05
7 | MC
8 | AT
9 | KA
10 | LW
11 | AM
12 | YC
13 | BA
14 | KB
15 | TR
16 | RP
17 | TK
18 | KR
19 | ZH
20 | LT
21 | GB
22 | ND
23 | ZA
24 | JP
25 | SB
26 | TL
27 | EM
28 | HB
29 | AL
30 | ML
31 | TJ
32 | CS
33 | YM
34 | LF