tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 782472d1654073024-i-need-to-get-a-spread-sheet-to-automatically-look-up-new-data-as-it-is-enterd-endeavour-hours-log-aligw
Sheet: Hours Run

Asset Location & Hours Run Log
Asset Serial Number |  | 345678
Asset Type |  | Bearing Frame
Date Supplied
Replacement Due Date
Position Installed |  |  | 1 | 1 | 4 | 4 | 4 | 3 | 3 | 3 | 2 | 2
[NAME] reading |  |  | 2 | 4 | 6 | 8 | 9 | 5 | 6 | 7 | 10 | 15
Hours Run Total |  |  | 0
 |  | I need this cell to show the latest hours run reading which will be calculated and displayed here when we enter the position here and hours run meter reading here
 |  |  |  |  |  |  |  |  |  |  | If possible can the value in these cells be blank until there is a value in the Position and [NAME] cells above
Spreadsheet: 674452d1587849992-extrapolate-a-list-of-names-extrapolate-list-of-names-ex-1
Sheet: Sheet1

Name | Dat of Completion | Status
[NAME] | 2020-01-01 00:00:00 | complete
[NAME] | 2020-01-02 00:00:00 | incomplete |  |  |  | Names of people who have an incomplete AND complete status to show below as written
[NAME] | 2020-01-03 00:00:00 | incomplete
[NAME] | 2020-01-04 00:00:00 | complete |  |  |  | [NAME]
[NAME] | 2020-01-05 00:00:00 | incomplete |  |  |  | [NAME] 6
[NAME] 6 | 2020-01-06 00:00:00 | complete |  |  |  | [NAME]
[NAME] | 2020-01-07 00:00:00 | incomplete |  |  |  | [NAME]
[NAME] | 2020-01-08 00:00:00 | complete
[NAME] | 2020-01-09 00:00:00 | incomplete
[NAME] | 2020-01-10 00:00:00 | complete
[NAME] | 2020-01-11 00:00:00 | complete
[NAME] | 2020-01-12 00:00:00 | incomplete
[NAME] | 2020-01-13 00:00:00 | complete
[NAME] | 2020-01-14 00:00:00 | complete
[NAME] | 2020-01-15 00:00:00 | incomplete
[NAME] 6 | 2020-01-16 00:00:00 | incomplete
[NAME] | 2020-01-17 00:00:00 | incomplete
[NAME] | 2020-01-18 00:00:00 | incomplete
[NAME] | 2020-01-19 00:00:00 | complete
[NAME] | 2020-01-20 00:00:00 | complete
Spreadsheet: 743712d1628682768-create-a-regular-vertical-database-database
Sheet: Sheet7

 | Data |  |  |  |  | Expected Result
Name | Blue | Green |  | Name | Quntity | Amount | Color
A | 11 | 12
A | 101 | 102
B | 13 | 14
B | 103 | 104
C | 15 | 16
C | 105 | 106
Spreadsheet: 668503d1584881559-vlookup-value-is-in-time-series-in-one-cell-vlookup_issue
Sheet: VLookup issue

Input |  | Output
Invoice No |  | Client | [NAME] | Assistent | Due BD |  |  |  | Invoice No | Invoices | Client | [NAME] | Assistent | Due BD
1368260 |  |  |  |  |  |  |  |  | 113332 |  | IBM | [NAME] | [NAME] | 5
1919622 |  |  |  |  |  |  |  |  | 158634 |  | Partners Group | [NAME] | [NAME] | 3
9700819 |  |  |  |  |  |  |  |  | 1368260 |  | Deerdrive LLC | [NAME] | [NAME] | 6
 |  |  |  |  |  |  |  |  | AA1348562 | 109363;1688560;1938562 | Flatline Corp. | [NAME] | [NAME] | 3
 |  |  |  |  |  |  |  |  | AA1266948 | 145948;1919622;3766273;472937 | Coca Cola | [NAME] | [NAME] | 10
 |  |  |  |  |  |  |  |  | 314222 |  | Gravity Inc. | [NAME] | [NAME] | 11
 |  |  |  |  |  |  |  |  | 9700819 |  | Svenks Water | [NAME] | [NAME] | 5
 |  |  |  |  |  |  |  |  | 1511299 |  | Xylem | [NAME] | [NAME] | 2
 |  |  |  |  |  |  |  |  | AA1885473 | 1765473;1995721 | Microsoft | [NAME] | [NAME] | 15
Spreadsheet: 579824d1530213808-excel-sheet-reference-book1-hwall85-
Sheet: Copy

Rec # | CH1 | CH2 | CH3 | Complete
Spreadsheet: 859754d1708010544-dynamic-named-range-last-x-number-of-items-goal-dashboard
Sheet: 2022 Dashboard

2022
 |  |  |  |  |  |  |  | Key Area 1 |  |  |  |  |  |  |  |  |  | Key Area 5 |  |  |  |  |  |  |  |  |  | Key Area 9 |  |  |  |  |  |  |  |  |  | Key Area 13
 |  |  |  |  |  |  |  | Notes: |  |  |  |  |  |  |  |  |  | Notes: |  |  |  |  |  |  |  |  |  | Notes: |  |  |  |  |  |  |  |  |  | Notes:
 |  |  |  |  |  |  |  | Key Area 2 |  |  |  |  |  |  |  |  |  | Key Area 6 |  |  |  |  |  |  |  |  |  | Key Area 10 |  |  |  |  |  |  |  |  |  | Key Area 14
 |  |  |  |  |  |  |  | Notes: |  |  |  |  |  |  |  |  |  | Notes: |  |  |  |  |  |  |  |  |  | Notes: |  |  |  |  |  |  |  |  |  | Notes:
 |  |  |  |  |  |  |  | Key Area 3 |  |  |  |  |  |  |  |  |  | Key Area 7 |  |  |  |  |  |  |  |  |  | Key Area 11 |  |  |  |  |  |  |  |  |  | Key Area 15
 |  |  |  |  |  |  |  | Notes: |  |  |  |  |  |  |  |  |  | Notes: |  |  |  |  |  |  |  |  |  | Notes: |  |  |  |  |  |  |  |  |  | Notes:
 |  |  |  |  |  |  |  | Key Area 4 |  |  |  |  |  |  |  |  |  | Key Area 8 |  |  |  |  |  |  |  |  |  | Key Area 12
 |  |  |  |  |  |  |  | Notes: |  |  |  |  |  |  |  |  |  | Notes: |  |  |  |  |  |  |  |  |  | Notes:
Spreadsheet: 97582d1296728353-sum-months-worth-of-purchases-from-pivot-table-purchase-orders-log
Sheet: Statistics

Monthly Spending - Maintanance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maintanance purchases |  |  |  | Toolroom purchases |  |  |  | Maintanance Monthly
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product of Price | Section |  |  | Product of Price | Section
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | M |  |  | Date | T |  |  | Date | Price |  | Sum of M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-09 00:00:00 | 125.5 |  |  | 2011-01-15 00:00:00 | 85 |  |  | 2011-01-01 00:00:00 | 0 |  | Date | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-22 00:00:00 | 23.45 |  |  |  |  |  |  | 02/2011 | #N/A |  | 2011-01-09 00:00:00 | 125.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-12 00:00:00 | 75.25 |  |  |  |  |  |  | 2011-03-01 00:00:00 |  |  | 2011-01-22 00:00:00 | 23.45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-04-01 00:00:00 |  |  | 2011-02-12 00:00:00 | 75.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-05-01 00:00:00 |  |  | Grand Total | 224.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-01 00:00:00
Spreadsheet: 175997d1345699024-how-to-return-indexed-items-based-on-a-condition-drop-down-menu-example-drop-down-menu-condition
Sheet: Tab1

Name | ID | Address |  | Name of the range
AAAAA | 100 | GGGGG |  | NamedRange1 |  |  |  | Drop-down:
BBBBB | 300000 | HHHHH
CCCCC | 120 | IIIII
DDDDD | 450000 | JJJJJ |  |  |  |  |  | what I want to do is to only return entries with 6 digits on the drop-down menu above
EEEEE | 7777 | KKKKK
FFFFF | 1000000 | LLLLL
Spreadsheet: 682155d1591930163-help-investment-tracker-with-foreign-currency-excel-spreadsheet-portfolio
Sheet: PERFORMANCE

Start. | -2994.9 | -2314.55 | 3211.48
Quarter | Portfolio G/L | Portfolio Currency G/L | Dividends | Inflows/Outflows | Amount Invested: Stocks | Amount Invested: Bonds | Amount Invested: Alternatives | Beginning Portfolio Amount | End Portfolio Amount | [NAME] | Total G/L | [NAME] | ASX200 | Difference | Report Date @ Close of Financial Markets
2020-06-01 00:00:00 |  |  |  |  |  |  |  | 232442.25 |  |  |  |  |  |  |  | Q1 | Jan- March | 31st March
2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q2 | April - June | 30th June
2020-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3 | July - September | 30th September
2020-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q4 | October - December | 31st December
2020-10-01 00:00:00
2020-11-01 00:00:00
2020-12-01 00:00:00
Spreadsheet: chris_germany__2647__day_mar
Sheet: Sheet1

 | Deal
 | 209176 | [NAME] |  |  | 209176 | PEPL Curve |  |  | 213981 | TGT Curve |  |  | 220762 | ANR ML7 |  |  | 218781 | ANR ML7 |  |  | 219408 | ANR ML7 |  |  | 213999 | TGT Curve |  |  | 209178 | [NAME] |  |  |  | Daily Vol
1 |  | 2.595 |  |  |  | 2.55 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 2.78
 | -3000 | 2.655 |  |  | -9000 | 2.635 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 11428 | 2.845
 | -3000 | 2.73 |  |  | 0 | 2.705 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 3000 | 2.94
 | -3000 | 2.65 |  |  | 0 | 2.605 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 2927 | 2.865
 | -3000 | 2.65 |  |  | 0 | 2.605 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 2927 | 2.865
 | -3000 | 2.65 |  |  | 0 | 2.605 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 2927 | 2.865
 | 0 | 2.69 |  |  | 0 | 2.655 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 2.85
 | 0 | 2.71 |  |  | 0 | 2.69 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 2.89
 | -3000 | 2.68 |  |  | 0 | 2.67 |  |  | -2000 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 2000 | 0 |  |  | 2970 | 2.84
 | -3000 | 2.625 |  |  | -9000 | 2.63 |  |  | -2818 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 1418 | 0 |  |  | 11747 | 2.815
 | -3000 | 2.685 |  |  | 0 | 2.695 |  |  | -2818 | 0 |  |  | -6000 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 2818 | 0 |  |  | 9118 | 2.885
 | -3000 | 2.685 |  |  | 0 | 2.695 |  |  | -2818 | 0 |  |  | -6000 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 2818 | 0 |  |  | 9118 | 2.885
 | -3000 | 2.685 |  |  | 0 | 2.695 |  |  | -2818 | 0 |  |  | -6000 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 2818 | 0 |  |  | 9118 | 2.885
 | -3000 | 2.725 |  |  | -9000 | 2.715 |  |  | -2818 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 2818 | 0 |  |  | 11777 | 2.935
 | 0 | 2.77 |  |  | 0 | 2.745 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 2.945
 | -3000 | 2.715 |  |  | 0 | 2.71 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | -10000 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 12865 | 2.86
 | -3000 | 2.78 |  |  | -9000 | 2.765 |  |  | -2818 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | -10000 | 0 |  |  | 2818 | 0 |  |  | 21468 | 2.96
 | -3000 | 2.76 |  |  | -9000 | 2.735 |  |  | -2818 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | -10000 | 0 |  |  | 2818 | 0 |  |  | 21468 | 2.96
 | -3000 | 2.76 |  |  | -9000 | 2.735 |  |  | -2818 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | -10000 | 0 |  |  | 2818 | 0 |  |  | 21468 | 2.96
 | -3000 | 2.76 |  |  | -9000 | 2.735 |  |  | -2818 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | -10000 | 0 |  |  | 2818 | 0 |  |  | 21468 | 2.96
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 836660d1689575003-using-index-formula-to-summarise-training-database-index
Sheet: IR

CÔNG TY TNHH GE-SHEN VIỆT NAM |  |  |  |  |  |  |  |  |  | Form  :  HR-F02
GE-SHEN (VIETNAM) CO., LTD. |  |  |  |  |  |  |  |  |  | Rev    :  C
GHI CHÉP ĐÀO TẠO CÁ NHÂN/ NHÓM
GROUP / INDIVIDUAL TRAINING RECORD
Emp. No.: | 100027 |  |  |  | Name:
Dept: |  |  |  |  | Position:
Date Joined: |  |  |  |  | Year:
TT No. | Int/ Ext | Date |  |  | Time |  |  | Khóa đào tạo Training Course | Trained by | Ghi chú Remarks
1 | Int | 2022-01-05 00:00:00 | - | 2022-01-05 00:00:00 | 14:00:00 | - | 14:40:00 | 6S Training | TRẦN THỊ KHUYÊN |  |  | B7 | manually key in
2 | Ext | 2022-01-10 00:00:00 | - | 2022-01-10 00:00:00 | 14:00:00 | - | 14:40:00 | ISO9001 Training | [NAME] No |  |  | B8 | [NAME] in Employee name sheet, Column C
3 |  |  |  |  |  |  |  |  |  |  |  | B9 | [NAME] in Employee name sheet, Column E
4 |  |  |  |  |  |  |  |  |  |  |  | H7 | [NAME] in Employee name sheet, Column B
5 |  |  |  |  |  |  |  |  |  |  |  | H8 | [NAME] in Employee name sheet, Column D
6 |  |  |  |  |  |  |  |  |  |  |  | H9 | is it possible to tabulate data below base on year, i.e. if I keyed in 2022, the data will be show for year 2022 only, then if I change the year for 2023, it will tabulate the data for 2023
7 |  |  |  |  |  |  |  |  |  |  |  | B13 | list of training attended by by [NAME], lookup value in Database, Column D
8 |  |  |  |  |  |  |  |  |  |  |  | C13 | start date for 1st list training attended by by [NAME], lookup value in Database, Column E
9 |  |  |  |  |  |  |  |  |  |  |  | B14 to G42 | Other list of training attended by B7
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 218804d1362585279-football-league-table-database
Sheet: Sumário - Tabela 2-3-1-1-1-1-17

Jornada | 18
Wigan Athletic | 0 | 1 | Arsenal
Manchester City | 1 | 0 | Reading
Newcastle United | 1 | 0 | Queen Parks Rangers
Southampton | 0 | 1 | Sunderland
[NAME] | 0 | 0 | Stoke City
West Bromwich Albion | 2 | 1 | Norwich City
West Ham United | 1 | 2 | Everton
Liverpool | 4 | 0 | Fulham
Swansea City | 1 | 1 | [NAME]
Chelsea | 8 | 0 | [NAME]
Spreadsheet: daren_farmer__6615__egmnom-Mar
Sheet: EGM 60

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-207106-02-010
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-03-01 00:00:00
Fax: | (713)207-0054 | Stop:
 |  | 2000-03-31 00:00:00
RECEIPTS |  |  | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR | MAR
METER # | [NAME] | SUPPLIER | 1
644 | LONE STAR KATY | DUKE
644 | LONE STAR KATY | RICHARDSON
4132 | EXXON KATY | ECT | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
4132 | EXXON KATY | Kn Marketing |  |  |  |  |  |  |  |  |  |  | 5000 | 5000
XXXX | IMBALANCE | ENTEX/HPL
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
1563 | COGEN | DYNEGY
1373 | [NAME] | MORGAN STANLEY | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
1485 | OXY BATTLEGROUND | OXY | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
1511 | Port Arthur - Clark | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1505 | DEER PARK | DUPONT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1506 | RHOM & HAAS DEER PARK | RHOM & HAAS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1394 | HILL PETRO | DYNEGY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8001 | AIR LIQUIDE | AIR LIQUIDE
XXXX | IMBALANCE | ENTEX/HPL
 |  | DELIVERY TOTAL
Spreadsheet: 833207d1686836822-numbering-duplicate-occurrences-of-unique-concatenations-sampleworkbook
Sheet: Sheet1

Current |  |  |  |  | Desired
 | AL | 2023 | SVN |  | AL2023SVN001 |  | AL | 2023 | SVN
 | AL | 2023 | WVR |  | AL2023WVR001 |  | AL | 2023 | WVR
 | AL | 2022 | WVR |  | AL2022WVR001 |  | AL | 2022 | WVR
 | OH | 2023 | WVR |  | OH2023WVR001 |  | OH | 2023 | WVR
 | AL | 2023 | SVN |  | AL2023SVN002 |  | AL | 2023 | SVN
 | WI | 2015 | SLI |  | WI2015SLI001 |  | WI | 2015 | SLI
 | MI | 2015 | SLI |  | MI2015SLI001 |  | MI | 2015 | SLI
 | KY | 2023 | SVN |  | KY2023SVN001 |  | KY | 2023 | SVN
 | AL | 2023 | SVN |  | AL2023SVN003 |  | AL | 2023 | SVN
 | OH | 2023 | WVR |  | OH2023WVR002 |  | OH | 2023 | WVR
Highlighted values are duplicates. Note the numbering I added in the Desired column to differentiate between each instance of a duplicate.
Spreadsheet: 160566d1339112647-ref-or-other-errors-when-linking-two-files-report
Sheet: Report

 | Sample Report File for "#[NAME]! Error When Linking Files" Post
 | Shaded cells represent formulas which link to the file "Source.xls"
 | These formulas work perfectly when both files are open.
 | But sometimes when the source file is closed, these formulas return #[NAME]! O or $0
 | Select Region | Select Month | Revenue | Expense | Profit
 | East | 2012-01-01 00:00:00 | 439 | 321 | 118
 | West | 2012-01-01 00:00:00 | 394 | 636 | -242
 | South | 2012-01-01 00:00:00 | 213 | 63 | 150
 | Central | 2012-01-01 00:00:00 | 166 | 213 | -47
 | Canada | 2012-01-01 00:00:00 | 661 | 1009 | -348
 | Total |  | 1873 | 2242 | -369
Spreadsheet: 162065d1339704897-pivot-table-sort-by-month-not-6-14-12-problem-report-log_jpr73
Sheet: PT_Summary of Log

Date | (Tous) |  |  |  | Date | (Tous)
 | Données |  |  |  | Nombre de Person
Department | Count | Percentage |  |  | Person | Total
Sales | 179 | 0.5474006116207951 |  |  | [NAME] | 1
Outside Sales | 9 | 0.02752293577981652 |  |  | Amber | 32
Shop | 45 | 0.1376146788990826 |  |  | [NAME] | 2
Accounting | 31 | 0.09480122324159021 |  |  | [NAME] | 33
Materials | 48 | 0.1467889908256881 |  |  | Anne | 1
Executive | 10 | 0.03058103975535168 |  |  | Annette | 9
Building 5 | 3 | 0.009174311926605505 |  |  | [NAME] | 3
Building 6 | 2 | 0.006116207951070336 |  |  | [NAME] | 4
Total général | 327 | 1 |  |  | Carol | 9
 |  |  |  |  | Cassie | 7
 |  |  |  |  | [NAME] | 6
 |  |  |  |  | [NAME] | 1
 |  |  |  |  | [NAME] | 13
 |  |  |  |  | [NAME] | 1
 |  |  |  |  | [NAME] | 10
 |  |  |  |  | [NAME] | 4
 |  |  |  |  | [NAME] | 7
 |  |  |  |  | Joy | 21
 |  |  |  |  | [NAME] | 2
 |  |  |  |  | [NAME] | 4
 |  |  |  |  | [NAME] | 8
 |  |  |  |  | [NAME] | 3
 |  |  |  |  | Lauren | 20
 |  |  |  |  | [NAME] | 9
 |  |  |  |  | [NAME] | 9
 |  |  |  |  | [NAME] | 12
 |  |  |  |  | Marge | 2
 |  |  |  |  | [NAME] | 5
 |  |  |  |  | [NAME] | 2
 |  |  |  |  | [NAME] | 19
 |  |  |  |  | [NAME] | 1
 |  |  |  |  | [NAME] | 2
 |  |  |  |  | [NAME] | 7
 |  |  |  |  | Nicole | 6
 |  |  |  |  | Nina | 3
 |  |  |  |  | [NAME] | 3
 |  |  |  |  | [NAME] | 10
 |  |  |  |  | [NAME] | 2
 |  |  |  |  | [NAME] | 19
 |  |  |  |  | Scot | 10
 |  |  |  |  | Stacy E | 2
 |  |  |  |  | [NAME] | 3
 |  |  |  |  | Total général | 327
Spreadsheet: darrell_schoolcraft__7477__imball0202
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 8109 | 7700 | 7524 | 8000 |  | 3500 | 5621 | 3500
2 | 7487 | 7700 | 8454 | 8000 |  |  | 5644 | 7000
3 | 7329 | 7700 | 8774 | 8000 |  |  | 5629 | 7000
4 | 7232 | 7700 | 8619 | 8000 |  |  | 6650 | 7000
5 | 7130 | 7700 | 8498 | 8000 |  |  | 6285 | 7000
6 | 8341 | 7700 | 8747 | 8000 |  |  | 5673 | 7000
7 | 9046 | 7700 | 5199 | 8000 |  |  | 1107
8 | 8490 | 7700 | 4470 | 8000
9 | 7931 | 7700 | 8850 | 8000
10 | 7777 | 7700 | 8458 | 8000
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  | 18846.61
2002-02-10 00:00:00
CBS Volume
 |  |  | -118658
Spreadsheet: 676116d1588667323-multiple-sums-by-date-multiple-sums
Sheet: Sheet1

Opening |  | 539 |  |  |  |  | 621 |  |  |  |  | 67 |  |  |  |  | 199
 |  | UK Standard |  |  |  |  | UK Oversized |  |  |  |  | Export Standard |  |  |  |  | Export Oversized
 | Weekending | In | Customer | DN Number | Out | Balance | In | Customer | DN Number | Out | Balance | In | Customer | DN Number | Out | Balance | In | Customer | DN Number | Out | Balance
2020-05-04 00:00:00 |  | 20 |  |  |  |  | 21 | Becton | D022353 | 16 |  |  |  |  |  |  | 5 | Becton | D022334 | 33
2020-05-04 00:00:00 |  |  |  |  |  |  |  | Becton | D022354 | 16 |  |  |  |  |  |  |  | Compiegne | D022351 | 3
2020-05-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Compiegne | D022352 | 2
2020-05-05 00:00:00 |  |  | Apollo | D022357 | 1 |  |  | Becton | D022359 | 16 |  |  |  |  |  |  |  | Becton | D022356 | 33
2020-05-05 00:00:00 |  |  | Apollo | D022358 | 2 |  |  | Becton | D022360 | 16
2020-05-05 00:00:00 |  |  | Leeds | D022361 | 26
2020-05-05 00:00:00 |  |  | Leeds | [NAME] | 26
2020-05-05 00:00:00 |  |  | Spotspot | D022363 | 1
2020-05-05 00:00:00
Spreadsheet: 828459d1683532116-problem-with-countif-formula-sample
Sheet: Final_Results

Given the option, which language would you feel most comfortable being trained in? | Column1 | Are you familiar with what Information Management is? | Column2 | In your opinion who is responsible for Information Management? | Column3
English |  | Yes |  | HoM/ HoD
French |  | Somewhat |  | ICT Department
Arabic |  | No |  | Information Management team
Spanish |  |  |  | All staff members
Other |  |  |  | Other
Spreadsheet: 3db3f72f-28ed-40b0-8a37-fc09949eb9df
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
42225364 | 2014-07-09 10:54:26 | ALLIES | 1 | 6 | 5 | 568608 | airstrike | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42225544 | 2014-07-09 11:16:16 | AXIS | 0 | 3 | 6 | 568608 | airstrike | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42253373 | 2014-07-11 12:25:56 | ALLIES | 1 | 6 | 1 | 1602000 | Stipo | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42253539 | 2014-07-11 12:46:43 | AXIS | 1 | 6 | 3 | 1602000 | Stipo | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42312393 | 2014-07-15 14:59:36 | ALLIES | 1 | 6 | 4 | 901544 | manu76 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42312673 | 2014-07-15 15:19:20 | AXIS | 0 | 4 | 6 | 901544 | manu76 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42337612 | 2014-07-17 11:05:01 | ALLIES | 0 | 2 | 5 | 1606131 | Cobraniqus | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42337730 | 2014-07-17 11:21:01 | AXIS | 0 | 4 | 5 | 1606131 | Cobraniqus | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42350960 | 2014-07-18 12:47:53 | AXIS | 1 | 6 | 3 | 1605436 | pjorlt | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42351134 | 2014-07-18 13:18:13 | ALLIES | 0 | 3 | 7 | 1606351 | player1606351 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42352990 | 2014-07-18 16:09:04 | ALLIES | 1 | 6 | 1 | 220477 | baby68 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42392036 | 2014-07-21 11:23:02 | ALLIES | 1 | 6 | 2 | 471986 | Tartaras | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42406405 | 2014-07-22 11:43:13 | ALLIES | 1 | 6 | 3 | 1602000 | Stipo | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42406605 | 2014-07-22 11:53:51 | AXIS | 1 | 6 | 1 | 1602000 | Stipo | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]