tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 882961d1731433441-need-formula-that-automatically-adjusts-to-rows-and-columns-aligw-spreadsheet
Sheet: ranking

 | 2024-10-08 00:00:00 |  |  |  |  |  |  |  |  |  | 2024-10-08 00:00:00 | Line |  | Line |  | Line |  | Line |  | Line |  | Line |  | Line |  | Line |  | Line |  | Line | 2024-10-08 00:00:00 |  |  |  |  |  |  |  |  |  | sum weighted scores | Weeks Played | Weeks Played/Total Weeks | Final Score |  | average score
 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 2 |  | 2 |  | 2 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 3 |  | 3 |  | 3 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 3 |  | 3 |  | 3 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 2 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4 |  | 5 |  | 4 |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4 |  | 5 |  | 4 |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACTUAL SCORE |  |  |  |  |  |  |  |  | L1 | L2 | L3 | [NAME] | L5 |  |  | WEIGHTED SCORE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | 1.3 | 1.1 | 0.9 | 0.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7
Spreadsheet: 30756e73-8437-48ce-bb7d-f90401ea469c
Sheet: MathSciNet

MathSciNet
2007-2008
 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | Total | 2007-2008 Price | Price per search
MathSciNet
Sessions | 277 | 313 | 652 | 734 | 1363 | 1144 | 727 | 537 | 861 | 563 | 504 | 411
Searches | 389 | 512 | 817 | 910 | 1523 | 1313 | 928 | 710 | 1021 | 697 | 629 | 510 |  | 7384
COUNTER-Compliant?: | No
Spreadsheet: 758569d1638953773-column-c-lists-all-missing-dates-missing-dates-aligw
Sheet: Sheet1

Date |  | Column B  lists all missing dates
2021-12-01 00:00:00
2021-12-02 00:00:00
2021-12-03 00:00:00
2021-12-06 00:00:00
2021-12-07 00:00:00
2021-12-08 00:00:00
2021-12-09 00:00:00
2021-12-10 00:00:00
2021-12-12 00:00:00
2021-12-13 00:00:00
2021-12-18 00:00:00
2021-12-19 00:00:00
2021-12-22 00:00:00
2021-12-23 00:00:00
2021-12-26 00:00:00
2021-12-28 00:00:00
2021-12-29 00:00:00
2021-12-30 00:00:00
2021-12-31 00:00:00
Spreadsheet: 47071d1245964558-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: MIS - CS-SPD PACKS #4

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS/SPD PACKS #4
FACILITY: | MISERICORDIA
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: |  | X | X | X | X |  | X
 | *NO STAT HOLIDAYS
** If more/less linen required please fax in this order by 7:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
DELIVERY PACK |  |  |  | CP0004 |  | 10
2-LEGGINGS |  |  |  | SP0002 |  | 1
MAYO COVER |  |  |  | SP0003 |  | 16
SM SPLIT DRAPE |  |  |  | SP0009 |  | 1
LG SPLIT DRAPE |  |  |  | SP0010 |  | 12
LAP DRAPE |  |  |  | SP0018 |  | 2
HALF SHEET |  |  |  | SP0015 |  | 15
3/4 SHEET |  |  |  | SP0020 |  | 50
FULL SHEET |  |  |  | SP0021 |  | 1
MED BARRIER |  |  |  | SP0016 |  | 5
TABLE COVER |  |  |  | SP0019 |  | 3
CHEST/BREAST DRAPE |  |  |  | SP0035 |  | 1
2-HUCK TOWEL |  |  |  | SP0081 |  | 30
BABY BLANKET |  |  |  | SP0011 |  | 6
BACK PROTECTOR |  |  |  | GP0017 |  | 10
UPDATED:
June 17th 2009
Spreadsheet: 468443d1467298260-combinations-of-options-on-the-table-copy-of-excel-forum-upload-ndm
Sheet: Sheet2

Criteria 1 | [NAME] | Criteria 3 | [NAME] | Criteria 5 | Criteria 6 | combinations | no.
0 | 0 | 0 | 0 | 0 | 0
1 | 0 | 0 | 0 | 0 | 0
0 | 1 | 0 | 0 | 0 | 0
0 | 0 | 1 | 0 | 0 | 0
0 | 0 | 0 | 1 | 0 | 0
0 | 0 | 0 | 0 | 1 | 0
0 | 0 | 0 | 0 | 0 | 1
1 | 0 | 0 | 0 | 0 | 0
1 | 1 | 0 | 0 | 0 | 0
0 | 1 | 1 | 0 | 0 | 0
0 | 0 | 1 | 1 | 0 | 0
0 | 0 | 0 | 1 | 1 | 0
0 | 0 | 0 | 0 | 1 | 1
1 | 0 | 0 | 0 | 0 | 0
1 | 1 | 0 | 0 | 0 | 0
1 | 1 | 1 | 0 | 0 | 0
0 | 1 | 1 | 1 | 0 | 0
0 | 0 | 1 | 1 | 1 | 0
0 | 0 | 0 | 1 | 1 | 1
1 | 0 | 0 | 0 | 0 | 0
1 | 1 | 0 | 0 | 0 | 0
1 | 1 | 1 | 0 | 0 | 0
1 | 1 | 1 | 1 | 0 | 0
0 | 1 | 1 | 1 | 1 | 0
0 | 0 | 1 | 1 | 1 | 1
1 | 0 | 0 | 0 | 0 | 0
1 | 1 | 0 | 0 | 0 | 0
1 | 1 | 1 | 0 | 0 | 0
1 | 1 | 1 | 1 | 0 | 0
1 | 1 | 1 | 1 | 1 | 0
0 | 1 | 1 | 1 | 1 | 1
1 | 0 | 0 | 0 | 0 | 0
1 | 1 | 0 | 0 | 0 | 0
1 | 1 | 1 | 0 | 0 | 0
1 | 1 | 1 | 1 | 0 | 0
1 | 1 | 1 | 1 | 1 | 0
1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 0 | 0 | 0 | 0
0 | 1 | 1 | 0 | 0 | 0
0 | 0 | 1 | 1 | 0 | 0
0 | 0 | 0 | 1 | 1 | 0
0 | 0 | 0 | 0 | 1 | 1
0 | 0 | 0 | 0 | 0 | 1
1 | 1 | 1 | 0 | 0 | 0
0 | 1 | 1 | 1 | 0 | 0
0 | 0 | 1 | 1 | 1 | 0
0 | 0 | 0 | 1 | 1 | 1
0 | 0 | 0 | 0 | 1 | 1
0 | 0 | 0 | 0 | 0 | 1
1 | 1 | 1 | 1 | 0 | 0
0 | 1 | 1 | 1 | 1 | 0
0 | 0 | 1 | 1 | 1 | 1
0 | 0 | 0 | 1 | 1 | 1
0 | 0 | 0 | 0 | 1 | 1
0 | 0 | 0 | 0 | 0 | 1
1 | 1 | 1 | 1 | 1 | 0
0 | 1 | 1 | 1 | 1 | 1
0 | 0 | 1 | 1 | 1 | 1
0 | 0 | 0 | 1 | 1 | 1
0 | 0 | 0 | 0 | 1 | 1
0 | 0 | 0 | 0 | 0 | 1
1 | 1 | 1 | 1 | 1 | 1
0 | 1 | 1 | 1 | 1 | 1
0 | 0 | 1 | 1 | 1 | 1
0 | 0 | 0 | 1 | 1 | 1
0 | 0 | 0 | 0 | 1 | 1
0 | 0 | 0 | 0 | 0 | 1
Spreadsheet: benjamin_rogers__1309__site_visit_schedule for Ross & Fred
Sheet: Confirm - Allegheny

 |  | Company | Allegheny
 |  | Company Contact & Number | [NAME] (724) 838-6488
 |  | Site | Lincoln
 |  | Site Visit Date | Friday October 20th
 |  | Directions to Hotels/Site | See DealBench - Due Diligence List/Plant Pictures Section
 |  | Meeting Time/Place | Friday Morning
 |  |  | Lincoln Energy Center
 |  |  | 27150 South Kankakee Rd.
 |  |  | Manhattan, IL 60442
 |  | Enron Site Visit Coordinator | [NAME]
 |  |  | Work: (713) 853-5406 / Cell: (713) 412-4612
 |  |  | [NAME]
 |  |  | Work: (713) 646-7071 / (281) 450-2844
 |  |  | Lincoln - [NAME] (Plant Manager)
 |  |  | Work (815) 478-3852
 |  | Company Site Visit Team
Spreadsheet: 844934d1696527764-timestamp-issues-test
Sheet: Sheet1

This is what it is exported as |  |  |  |  |  |  | Expected results
Timestamp |  |  |  |  |  |  | Date | Time
10/4/2023 12:06:53 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:06:53
10/4/2023 12:05:41 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:05:41
10/4/2023 12:05:10 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:05:10
10/4/2023 12:04:28 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:04:28
10/4/2023 12:03:25 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:03:25
10/4/2023 1:38:27 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 01:38:27
10/4/2023 12:15:33 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:15:33
10/4/2023 12:14:31 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:14:31
10/4/2023 12:13:24 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:13:24
10/4/2023 12:11:12 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:11:12
10/4/2023 12:10:51 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:10:51
10/4/2023 12:10:11 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:10:11
10/4/2023 12:09:10 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:09:10
10/4/2023 12:09:02 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:09:02
10/4/2023 12:07:57 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:07:57
10/4/2023 12:07:22 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:07:22
10/4/2023 12:21:00 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:21:00
10/4/2023 12:20:29 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:20:29
10/4/2023 12:19:52 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:19:52
10/4/2023 12:19:07 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:19:07
10/4/2023 12:18:49 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:18:49
10/4/2023 12:17:44 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:17:44
10/4/2023 12:17:07 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:17:07
10/4/2023 12:16:04 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:16:04
10/4/2023 12:16:40 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:16:40
10/4/2023 12:14:54 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:14:54
10/4/2023 12:31:08 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:31:08
10/4/2023 12:26:52 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:26:52
10/4/2023 12:26:09 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:26:09
10/4/2023 12:25:06 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:25:06
Spreadsheet: 36639d1234511488-how-to-change-a-series-of-rows-changevaluesort
Sheet: Sheet1

Actaul Data |  |  | Result Wanted
PUMP A | PUMP B
1.41 | 1.55
1.85 | 2.49
2.22 | 2.71
2.88 | 3.36
3.64 | 4.17
4.7 | 4.94
5.6 | 5.01
6.98 | 5.83
7.64 | 6.55
8.47 | 7.37
9.68 | 7.64
10.79 | 8.7
11.9 | 8.93
12.9 | 9.64
14.06 | 10.84
14.78 | 11.27
17.2 | 12.01
18.98 | 12.23
21 | 12.29
22.07 | 13.3
23.12 | 14.31
24.5 | 14.75
25.75 | 15.14
27 | 16.97
28 | 17.96
29.69 | 18.21
30.84 | 19.29
32.58 | 18.87
33.49 | 20.52
34.09 | 20.94
35.88 | 22.72
37.13 | 23.9
38.27 | 25.1
39.35 | 26.11
40.61 | 27.41
41.54 | 28.32
42.85 | 29.55
44 | 30.77
45.13 | 31.89
46.37 | 33.04
47.4 | 34.14
48.36 | 35.06
50.74 | 35.32
51.34 | 36.36
53.14 | 36.78
55.21 | 36.96
56.87 | 37.53
58.72 | 37.91
60.01 | 38.99
61.04 | 40.07
62.49 | 41.5
63.7 | 42.65
64.86 | 43.82
65.86 | 44.76
67.09 | 46.03
68.38 | 47.26
69.9 | 48.77
71.4 | 50.38
72.68 | 51.63
73.72 | 52.67
74.96 | 53.89
76.36 | 55.35
77.6 | 56.59
79.17 | 58.124317
80.3 | 59.85
81.66 | 61.25
82.7 | 62.68
84.28 | 63.85
85.76 | 65.32
87.18 | 66.73
88.08 | 69.51
89.62 | 71.07
91.08 | 72.49
92.14 | 73.58
93.71 | 75.15
95.26 | 76.68
98.45 | 79.78
99.03 | 80.37
101.1 | 82.86
102.65 | 83.96
104.12 | 85.14
106.1 | 87.38
107.57 | 88.83
109.14 | 90.39
110.83 | 91.91
112.26 | 93.53
113.67 | 94.33
115 | 96.67
116.34 | 98.71
118.04 | 99.7
119.45 | 101.06
121.31 | 102.38
122.62 | 104.24
124.16 | 105.82
125.85 | 107.43
127.31 | 108.83
128.71 | 110.32
130.41 | 111.35
132.22 | 113.77
133.66 | 115.23
135.41 | 116.09
136.93 | 118.43
137.76 | 120.3
139.27 | 122.35
140.92 | 123.99
142.73 | 125.77
144.19 | 127.27
145.83 | 128.91
146.68 | 131.36
148.26 | 132.96
148.37 | 136.1
149.96 | 137.73
151.4 | 140.32
152.9 | 141.83
154.36 | 143.27
155.6 | 145.21
157.25 | 146.82
158.94 | 148.52
160.72 | 150.28
161.45 | 152.65
163.21 | 154.43
164.67 | 156.41
166.34 | 158.12
166.47 | 161.28
168.12 | 162.92
170.02 | 164.81
171.85 | 166.63
173.45 | 168.18
175.05 | 169.8
176.53 | 171.33
178.08 | 173.31
178.96 | 176.34
180.52 | 177.87
181.38 | 178.73
184.38 | 181.74
186.02 | 183.36
187.59 | 185.06
189.6 | 187.02
190.15 | 189.91
192.13 | 191.83
194.08 | 193.82
194.33 | 197.35
196.18 | 199.12
197.65 | 200.83
199.91 | 202.82
201.81 | 204.76
203.51 | 207.09
204.58 | 208.23
207.47 | 211.48
209.66 | 213.27
210.83 | 216.41
213.24 | 218.72
213.68 | 221.82
215.49 | 223.59
217.45 | 225.58
219.21 | 227.28
221.23 | 229.35
223.28 | 231.39
225.37 | 233.46
226.91 | 235.01
228.58 | 236.63
230 | 239.63
231.98 | 241.84
Spreadsheet: 745880d1630335716-find-which-array-a-value-belongs-to-sampledata-2-ans
Sheet: Sheet1

Sales per day |  |  |  |  |  |  |  |  |  | Top Sales
Week | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  |  | 1 |  | 2 |  | 3
1 | 32478 | 23541 | 23813 | 12512 | 52353 | 83134 | 74112
2 | 54234 | 33255 | 43233 | 46235 | 75423 | 91235 | 123422
3 | 45252 | 35235 | 34555 | 53523 | 46432 | 81312 | 78712 |  |  |  |  |  |  |  |  |  | > Want to know what days these values come from
4 | 41341 | 53234 | 43231 | 32123 | 53134 | 75312 | 98123
Spreadsheet: 767281d1644391719-connection-to-be-built-in-2-dynamic-values-in-different-columns-sample-file-1-1-
Sheet: Sheet2

S. No | Column 1 | Column 2 | Column 3 | Column 4 | Column 5
1 | A | 20 | 17 | 9 | 20
2 | C | 15 | 6 | 14 | 15
3 | B | 15 | 10 | 13 | 15
4 | F | 9 | 15 | 15 | 9 |  |  |  |  |  | Example 2
5 | E | 9 | 9 | 8 | 9
6 | G | 9 | 1 | 8 | 9
7 | J | 9 | 7 | 1 | 9
8 | I | 1 | 4 | 8 | 1
9 | H | 18 | 13 | 10 | 18
10 | J | 17 | 2 | 9 | 17
for example: formula found G in column 1 at 7th row, now it shows value of column 2 that is 9 in column 5.
Spreadsheet: 166171d1341493504-excel-2007-count-using-and-and-multiple-or-criteria-seminar_example
Sheet: Sheet1

Company | Delegate | Mon | Tue | Wed |  |  |  | Air-code! | Answer should be:
CompanyA | Jon | x |  |  |  | Companies invited |  | COUNT DISTINCT [Companies] | 3
CompanyA | Fred |  | x | x |  | Companies attending |  | COUNT DISTINCT [Companies] WHERE OR ([Mon]="x",[Tue]="x",[Wed]="x") | 3
CompanyA | [NAME] |  | x |  |  | Passes needed:
CompanyA | Sue | x |  | x |  | CompanyA |  | COUNT WHERE [Companies] = RC[-2] AND (OR([Mon]="x",[Tue]="x",[Wed]="x")) | 4
CompanyB | Helen | x | x |  |  | CompanyB |  | COUNT WHERE [Companies] = RC[-2] AND (OR([Mon]="x",[Tue]="x",[Wed]="x")) | 3
CompanyB | [NAME] |  |  |  |  | CompanyC |  | COUNT WHERE [Companies] = RC[-2] AND (OR([Mon]="x",[Tue]="x",[Wed]="x")) | 5
CompanyB | [NAME] | x |  |  |  | CompanyD |  | COUNT WHERE [Companies] = RC[-2] AND (OR([Mon]="x",[Tue]="x",[Wed]="x")) | 0
CompanyB | [NAME] |  | x | x
CompanyC | [NAME] | x | x | x
CompanyC | [NAME] |  | x
CompanyC | [NAME] | x |  | x
CompanyC | [NAME] | x | x
CompanyC | [NAME] |  | x | x
CompanyC | [NAME]
CompanyD | Ray
Spreadsheet: 6a034750-e141-4cd1-a6bf-68881f5273a9
Sheet: Totals

 |  |  | B&W MFP | Color MFP | B/W MFD | Color MFD |  |  | B&W  MFP | Color  MFP |  | [NAME] | Duplex
 |  | MFP:
 |  |  | B&W  Printer | Color  Printer | B/W Printer | Color Printer |  |  | B&W  Printer | Color  Printer
 |  | Printer:
 |  |  | Total B&W | Total  Color | Total B&W | Total  Color |  |  | Total B&W | Total  Color
 |  | Total:
 |  |  |  |  | Total This Invoice: |  |  |  | Total This Invoice:
 |  |  |  |  | HP Toner: |  |  |  | Total Invoice w/ HP Toner:
 |  |  |  |  | Invoice Total
 |  | MFP
 |  | Printer
 |  |  |  |  | Printer Total:
 |  |  |  |  | MFP Total:
 |  |  |  |  | Device Total:
Spreadsheet: 694362d1599567977-copy-names-from-one-sheet-to-other-workbook-sheets-sample-scoring-spreadsheet1
Sheet: ORG 4

ESCF PROPOSAL EVALUATION SCORING
ORGANISATION NAME: |  | FIRST ROUND RESULT
NAME OF PROPOSAL:
 | Potential Impact - minimum threshold 42% | SCORE | NOTES
 | a)    Relevance and extent of the specific social challenge - What is the scale of the social challenge in the geographic area where the planning will take place? (15%)
 | b)   Potential impact on the challenge - What is the extent of the potential impact of this innovation on this social challenge in this geographic area? (15%)
 | c)    Evidence - What robust national and international evidence exists to support the model or innovation in terms of its effectiveness? What is the evidence on the cost implications of the model compared to alternative approaches? (20%)
 | d)   Scope of potential impact geographically - What is the evidence that the innovation is relevant across EU Member [NAME]? What evidence is there that the approach is relevant in Central and Eastern European Countries? To what extent has the innovation been applied in other countries in Europe? (10%)
 | e)    Promotion of citizen-centred approaches - Does the innovation support service users and end beneficiaries to be self-directed and to be involved in plans to scale social service innovations? (10%)
 | Potential Impact Total
 | Capacities - minimum threshold 12% | SCORE | NOTES
 | a)    Capacities of the applicants - Do the organisation(s) applying have the capacities to produce the plan for scaling the innovation? (10%)
 | b)   Networks and linkages - What is the evidence that key partners (public, private, non-profit, philanthropic) are open to collaborating on developing the plan in the geographic area where the planning will take place and what are the current linkages between the proposers and these organisations? Do the applicants have strong international linkages that could assist with this planning? (10%)
 | Capacities Total
 | Quality of the application to develop the plan - minimum threshold 6% | SCORE | NOTES
 | a)    Activities - Description of activities, timeframe, methodology, risk management. (5%)
 | b)   Budget - Are expenditures associated with the proposed planning activities reasonable and well-substantiated? (5%)
 | Quality of the application to develop the plan Total
 | Total Score | 0
Spreadsheet: 880591d1728402760-trying-to-create-a-count-of-parts-like-a-stock-check-parts-count
Sheet: Sheet1

 | Early Version Changes in bold
 | Part | Type | Qty | No of Pins | Circuit section | Function
 | Semiconductors
 | 23 | 74LS20 | 1 |  | RAM
 | 24 | 74LS10 | 1 |  | RAM
 | 25 | 74LS32 | 1 |  | RAM
 | 26 | 74LS612 | 1 |  | Ebus (Memory)
 | 27 | 74LS04 | 1 |  | RAM
 | 28 | 74LS27 | 1 |  | RAM
 | 29 | 74LS27 | 1 |  | RAM
 | 30 | 74LS02 | 1 |  | RAM
 | 31 | 74LS00 | 1 |  | RAM
 | 32 | TMS4500 | 1 |  | RAM | [NAME] controller
 | 33 | 74LS139 | 1 |  | RAM
 | 34 | 74LS138 | 1 |  | RAM
 | 35 | 74LS138 | 1 |  | RAM
 | IC36-43 | TMS4164 | 8 |  | RAM | Main RAM
 | 44 | 74LS245 | 1 |  | RAM
 | IC45-47 | TMS2564 | 3 |  | RAM | EPROM
 | 48 | TMS9929 | 1 |  | Video | VDP
 | IC49-56 | 4816 | 8 |  | Video | Video RAM
 | 57 | 4016B | 1 |  | Video
 | 58 | 4016B | 1 |  | Video
 | 59 | LM1889 | 1 |  | Video
 | 60 | 4013 | 1 |  | Video
 | Miscellaneous
 | IC socket nn Way
 | 14
 | 16
 | 18
 | 20
 | 28
 | 40
Spreadsheet: 142068d1329617389-making-3-combo-boxes-dependent-on-each-other-book1
Sheet: Sheet1

Blank | England | Scotland | Spain | Italy | Germany
Please select a country. |  |  |  |  |  |  |  | Pick the range to place into second ComboBox
 | Premier League | Premier League | Primera League | Serie A | Bundesliga | 1
 | Championship | First Division | Segunda [NAME] | Serie B | 2. Bundesliga | 2 | England
 | League One | Second Division | Segunda [NAME] |  | Liga | 3 | Scotland
 | League Two | Third Division |  |  |  | 4 | Spain
 |  |  |  |  |  | 5 | Italy
 | FA Cup | scotcup1 | spaincup1 | italycup1 | germancup1 | 6 | Germany
 | League Cup | scotcup2 | spaincup2 | italycup2 | germancup2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 2 |  | 1 |  |  | 3
 |  |  |  |  |  |  |  |  | 2 | League
 |  |  |  |  |  |  |  |  | 3 | Cup
Spreadsheet: 697516d1601390385-last-5-occurrences-lastocc
Sheet: Sheet1

PRODUCT  NAME | DATE | QTY |  | INPUT | LAST FIVE OCCURENCES |  | Helper
A | 2020-10-01 00:00:00 | 4 |  | A
B | 2020-10-02 00:00:00 | 5
C | 2020-10-02 00:00:00 | 6
A | 2020-10-03 00:00:00 | 7
C | 2020-10-04 00:00:00 | 8
D | 2020-10-05 00:00:00 | 9
E | 2020-10-06 00:00:00 | 1
A | 2020-10-06 00:00:00 | 2
G | 2020-10-07 00:00:00 | 3
A | 2020-10-08 00:00:00 | 5
U | 2020-10-08 00:00:00 | 8
A | 2020-10-08 00:00:00 | 9
Spreadsheet: 267708d1380144115-help-with-solver-as-solver-gives-wrong-answer-help
Sheet: Q5

[NAME] to Distributor | Distributors
Factories | P | Q | R | S | T
A | 100 | 140 | 200 | 150 | 35
B | 50 | 65 | 60 | 70 | 80
C | 40 | 150 | 100 | 90 | 130
Distributors | Monthly demand
P | 1000
Q | 1600
R | 1500
S | 2000
T | 1400
Factories | Max Monthly Production
A | 4000
B | 2000
C | 1500
Respective Number of Units Sent From Factory to Distributor | Distributors |  |  |  |  | Total
Factories | P | Q | R | S | T
A | 0 | 0 | 600 | 2000 | 1400 |  |  | 1000 | 1600 | 0 | 0 | 1400
B | 0 | 1100 | 900 | 0 | 0 |  |  | 0 | 0 | 1500 | 500 | 0
C | 1000 | 500 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 1500 | 0
Total
Respective Number of Trucks Sent From Factory to Distributor | Distributors
Factories | P | Q | R | S | T
A
B
C
Total
Total Shipping Costs for Respective Distributors
P |  | 11000
Q |  | 22100
R |  | 11100
S |  | 19300
T |  | 7000
Total Shipping Costs for All Distributors |  | 70500
Spreadsheet: 290272d1389826160-data-challenge-turning-massive-amounts-of-sales-order-data-into-summarized-customer-data-eforum-example2
Sheet: DesiredX

Account |  | Net Sales
100000 | Total | 1827.63
100000 | # of Orders | 3
100000 | [NAME] | 609.2100016276041
100000 | Orders < $25 | 0
100000 | Orders of $25+ | 0
100000 | Orders of $50+ | 0
100000 | Orders of $100+ | 0
100000 | Orders of $200+ | 1
100000 | Orders of $500+ | 2
100005 | Total | 6868.1
100005 | # of Orders | 19
100005 | [NAME] | 361.4789782072368
100005 | Orders < $25 | 1
100005 | Orders of $25+ | 1
100005 | Orders of $50+ | 0
100005 | Orders of $100+ | 2
100005 | Orders of $200+ | 9
100005 | Orders of $500+ | 6
100010 | Total | 70032.42
100010 | # of Orders | 162
100010 | [NAME] | 432.2988040123457
100010 | Orders < $25 | 11
100010 | Orders of $25+ | 2
100010 | Orders of $50+ | 12
100010 | Orders of $100+ | 29
100010 | Orders of $200+ | 64
100010 | Orders of $500+ | 44
100018 | Total | 20.5
100018 | # of Orders | 4
100018 | [NAME] | 5.125000476837158
100018 | Orders < $25 | 4
100018 | Orders of $25+ | 0
100018 | Orders of $50+ | 0
100018 | Orders of $100+ | 0
100018 | Orders of $200+ | 0
100018 | Orders of $500+ | 0
#N/A | #N/A | #N/A
Spreadsheet: 697849d1601569497-find-count-last-number-whitout-zero-value
Sheet: Sheet1

A1 | A2 | A3 | A4 | A5 | A6 | A7 | A8 | Result
2 | 0 | 4 | 8 | 0 | 0 | 0 | 0 | 4
6 | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 3
77 | 0 | 0 | 0 | 9 | 9 | 0 | 0 | 6
0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2
1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
66 | 7 | 0 | 1 | 0 | 7 | 7 | 0 | 7
5 | 6 | 7 | 0 | 4 | 0 | 0 | 1 | 8
Spreadsheet: 864736d1711858476-last-entry-by-year-and-spill-error-for-xlookup-last-entrry
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | total Columns f and g | First entry for Jan by year in column f or g | Last entry by year in column f and g, if entry in both columns, they are added together.
c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | c9
2022-07-15 00:00:00 | p | 45 | 6.8 |  |  |  |  |  | 2022-12-31 00:00:00
2022-07-16 00:00:00 | d | 21 | 7.4 |  |  |  |  |  | 2023-12-31 00:00:00 | 2023
2022-08-05 00:00:00 | d | 15 | 7.37 |  |  |  |  |  | 2024-12-31 00:00:00 | 2024
2023-01-10 00:00:00 | d |  |  |  |  | 67.46
2023-11-20 00:00:00 | p | 19 | 6.97
2023-12-15 00:00:00 | d | 18 | 7.05
2023-12-30 00:00:00 | d |  |  |  |  | 55.14 |  |  |  | Correct values
2024-01-15 00:00:00 | p | 19 | 6.87 |  |  |  |  |  |  | 2022
2024-01-29 00:00:00 | d | 18 | 6.95 |  |  |  |  |  |  | 2023
2024-03-15 00:00:00 | d | 19 | 7.15 |  |  | 15.97 |  |  |  | 2024