tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 96328d1295728013-conditional-formatting-football-predictions2
Sheet: Fixtures & Predictions

 |  | Prediction | Prediction | Prediction | Prediction | Prediction | Prediction | Prediction | Prediction | Prediction | Prediction | Prediction | Prediction | Prediction | Prediction | Prediction
Fixtures | Result | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | g'gunner | [NAME] | geordie | [NAME] | Magoo | Caroline | barcode | Jake | [NAME] | RKO | quakerman | N'Eagle | supermac | gb | [NAME]
Wolves - Liverpool | 0-3 | 1-2 | 2-1 | 2-1 | 2-2 | 0-3 | 1-1 | 2-1 | 1-2 | 2-1 | 0-2 | 0-1 | 0-0 | 0-2 | 3-2 | 1-1
Blackpool - Sunderland | 1-2 | 1-0 | 2-1 | 2-1 | 2-1 | 2-1 | 2-1 | 2-0 | 2-0 | 1-2 | 2-0 | 2-0 | 2-1 | 2-1 | 2-1 | 1-1
Man Utd - Birmingham | 5-0 | 3-1 | 2-0 | 2-1 | 2-0 | 2-0 | 2-0 | 3-0 | 3-1 | 2-1 | 2-1 | 2-0 | 3-0 | 2-0 | 3-0 | 3-1
Arsenal - Wigan | 3-0 | 3-1 | 4-1 | 3-0 | 3-1 | 2-1 | 2-1 | 2-0 | 2-0 | 3-0 | 3-0 | 3-1 | 3-0 | 3-1 | 4-0 | 3-1
Newcastle - Tottenham | 1-1 | 2-1 | 2-1 | 2-2 | 1-1 | 1-2 | 1-1 | 2-1 | 1-0 | 1-2 | 2-0 | 1-3 | 2-1 | 2-1 | 1-2 | 1-2
Fulham - Stoke | 2-0 | 1-1 | 1-1 | 1-1 | 2-1 | 1-0 | 2-1 | 1-2 | 2-0 | 2-0 | 1-0 | 1-1 | 1-1 | 2-1 | 1-1 | 1-1
Everton - West Ham | 2-2 | 2-1 | 1-0 | 2-1 | 2-1 | 2-1 | 2-0 | 2-1 | 2-1 | 2-0 | 2-1 | 2-1 | 2-0 | 3-1 | 2-0 | 2-0
[NAME] | 1-0 | 1-3 | 1-2 | 0-2 | 2-2 | 1-0 | 1-3 | 0-3 | 0-3 | 1-2 | 0-2 | 0-2 |  | 1-2 | 1-2 | 1-2
Derby - Nottm Forest | 0-1 | 1-2 | 1-2 | 0-3 | 2-2 | 1-2 | 0-2 | 0-2 | 0-2 | 1-1 | 0-2 | 0-3 | 2-1 | 1-3 | 1-2 | 1-2
Barnsley - Swansea | 1-1 | 0-1 | 2-2 | 2-1 | 1-2 | 2-1 | 2-2 | 1-2 | 1-2 | 0-1 | 1-2 | 2-1 | 1-1 | 1-1 | 0-1 | 1-1
Portsmouth - Leeds | 2-2 | 1-2 | 2-1 | 1-2 | 1-1 | 1-2 | 1-2 | 1-2 | 1-2 | 1-1 | 1-2 | 1-2 | 1-2 | 2-1 | 1-2 | 1-1
[NAME] | 1-2 | 1-1 | 2-1 | 1-2 | 1-1 | 1-1 | 1-2 | 2-1 | 2-1 | 1-1 | 2-1 | 1-2 | 0-2 | 1-1 | 2-1 | 1-2
Reading - Hull | 1-1 | 2-1 | 2-1 | 2-1 | 1-1 | 2-1 | 2-1 | 2-0 | 2-0 | 2-0 | 2-0 | 2-1 | 2-1 | 2-1 | 2-0 | 2-1
Cardiff - Watford | 4-2 | 3-2 | 3-2 | 2-2 | 2-1 | 2-1 | 2-1 | 1-1 | 0-1 | 2-0 | 0-1 | 2-2 | 2-0 | 2-1 | 2-2 | 2-1
C Palace - Bristol City | 0-0 | 1-2 | 0-3 | 1-3 | 2-1 | 1-2 | 1-1 | 2-1 | 2-1 | 2-1 | 2-1 | 1-3 | 2-1 | 1-1 | 1-1 | 1-1
Leicester - Millwall | 4-2 | 1-2 | 2-3 | 2-1 | 2-1 | 2-1 | 2-1 | 2-2 | 2-2 | 2-1 | 2-2 | 2-1 | 2-0 | 2-1 | 2-2 | 2-1
Ipswich - Doncaster | 3-2 | 0-3 | 1-2 | 1-2 | 3-1 | 1-1 | 1-2 | 1-0 | 1-0 | 2-1 | 1-0 | 1-2 | 0-1 | 2-2 | 1-1 | 1-2
Middlesbrough - Preston | 1-1 | 1-2 | 1-4 | 1-2 | 2-1 | 2-1 | 2-2 | 1-2 | 1-2 | 2-0 | 1-2 | 1-2 | 2-0 | 1-2 | 2-0 | 2-1
Scunthorpe - Burnley | 0-0 | 1-2 | 2-1 | 2-1 | 2-2 | 1-1 | 1-2 | 2-0 | 2-0 | 0-2 | 2-0 | 2-1 | 0-1 | 2-1 | 0-2 | 1-2
Tamworth - Darlington | 1-1 | 2-2 | 1-3 | 1-2 | 2-1 | 1-2 | 1-2 | 0-1 | 0-1 | 0-1 | 0-1 | 1-3 | 1-1 | 2-1 | 1-2 | 1-2
Hearts - Rangers | 1-0 | 1-2 | 1-3 | 0-3 | 1-1 | 1-3 | 1-3 | 1-2 | 0-2 | 1-2 | 0-2 | 0-3 | 0-3 | 0-3 | 1-2 | 1-3
Blackburn - West Brom |  | 1-1 | 2-1 | 1-1 | 2-0 | 1-1 | 2-1 | 1-2 | 1-2 | 2-1 | 1-2 | 1-1 | 2-0 | 1-1 | 2-0 | 3-1
 |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O
Total Scores
Spreadsheet: 136669d1326779278-value-error-book1
Sheet: Sheet1

1 | s
2 | m
3 | l | #N/A
4 | m | #N/A
5 | l | #N/A
6 | s | #N/A
20 | s | #N/A
50 | s | #N/A
100 | m | #N/A
150 | l | #N/A
200 | m | #N/A
Spreadsheet: 836216d1689176142-depreciation-calculator-depreciation-nsandeepv87-
Sheet: Sheet1 (2)

 | 2023-12-31 00:00:00
 | Purchase Date | Amount | Rate | Days | Depreciation | 2023-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Total | Diff
 | 2023-03-31 00:00:00 | 49000 | 0.31
 | 2009-12-06 00:00:00 | 49000 | 0.31
 | 2023-02-28 00:00:00 | 49000 | 0.31
 | 2023-04-20 00:00:00 | 49000 | 0.31
 | 2024-01-31 00:00:00 | 49000 | 0.31
Spreadsheet: 489387d1479227182-average-and-sum-with-a-condition-of-minimum-numbers-help13
Sheet: Sheet1

0:36:04 |  |  |  |  | Sample of results>>>> |  |  |  | ave | sum
0:30:48
0:33:56
0:33:20
0:35:04
0:36:20
0:35:01
0:37:51
0:39:23
0:45:03
0:39:48
0:34:59
0:33:20
0:34:58
0:39:46
0:38:13
0:35:43
0:37:23
0:44:47
0:40:20
0:29:25
0:35:42
0:39:37
0:25:19
0:37:43
0:38:33
0:26:27
0:35:23
0:34:23
0:29:13
0:30:41
0:39:42
0:32:14
0:37:00
0:41:43
0:37:20
0:36:23
0:32:53
0:29:03
0:35:11
0:39:44
0:38:01
0:31:01
0:35:48
0:34:09
0:43:35
0:39:08
0:38:05
0:36:42
0:30:54
0:36:40
0:34:37
0:37:30
0:37:30
0:30:19
0:40:29
0:36:49
0:30:23
0:36:00
0:37:38
Spreadsheet: 63317d1264221401-excel-2007-extend-pivot-selection-on-raw-data-without-applying-pivot-again-in-updated-raw-data-learning-1
Sheet: Sheet1

 |  | Example | Count
 |  | Test1 | 3
 |  | Test2 | 4
 |  | Test3 | 5
 |  | Test1 | 6
 |  | Test5 | 7
 |  | Test6 | 8
 |  | [NAME] | 9
 |  | Test8 | 10
 |  | Test9 | 11
 |  | [NAME] | 12
 |  | Test1 | 13
 |  | [NAME] | 14
Spreadsheet: 793788d1661721219-formula-to-consider-first-value-of-multiple-same-values-edit-formula-to-get-match
Sheet: Exp. Result in Remarks column

Line | As per | [NAME] | X | Invoice number | Date | IGST | CGST | SGST | EXACT MATCH CEFGHI | EXACT MATCH CEGHI | EXACT MATCH CGHI | APPROXIMATE MATCH CEFGHI | APPROXIMATE MATCH CEGHI | APPROXIMATE MATCH CGHI
7 | PORTAL | 29XXXTB0431R1XD |  | 78910 | 2019-05-22 00:00:00 |  | 100 | 100 |  |  |  |  |  |  |  | Solved by [NAME]
8 | PORTAL | 29XXXTB0431R1XD |  | 12355 | 2019-06-07 00:00:00 |  | 110 | 110
15 | TALLY | 29XXXTB0431R1XD |  | 12355 | 2019-06-07 00:00:00 |  | 110 | 110
17 | TALLY | 29XXXTB0431R1XD |  | 78910 | 2019-05-22 00:00:00 |  | 100 | 100
3 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001163 | 2019-06-05 00:00:00 | 660
4 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001164 | 2019-06-05 00:00:00 | 900
6 | PORTAL | 29XXXTB0431R1XD |  | 10012345 | 2019-06-05 00:00:00 |  | 450 | 450
12 | TALLY | 07XXXTB0431R1XD |  | 2019000893 | 2019-05-22 00:00:00 | 660
13 | TALLY | 07XXXTB0431R1XD |  | 2019001163 | 2019-06-05 00:00:00 | 900
14 | TALLY | 29XXXTB0431R1XD |  | 12345 | 2019-06-06 00:00:00 |  | 450 | 450
9 | PORTAL | 29XXXTB0431R1XD |  | 12356 | 2019-06-09 00:00:00 |  | 130 | 130
16 | TALLY | 29XXXTB0431R1XD |  | 12356 | 2019-06-08 00:00:00 |  | 129.75 | 129.75
2 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001162 | 2019-06-05 00:00:00 | 999
10 | TALLY | 07XXXTB0431R1XD |  |  | 2019-06-05 00:00:00 | 899
11 | TALLY | 07XXXTB0431R1XD |  | 2019001162 | 2019-06-05 00:00:00 | 998.5
5 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019001169 | 2019-06-05 00:00:00 | 1000
1 | PORTAL | 07XXXTB0431R1XD |  | 0000CR2019000893 | 2019-05-22 00:00:00 | 899.5
132 | PORTAL | 27DREPK9227D1ZQ |  | 2021-22464 | 14-04-2019 | 15.24
471 | TALLY | 27DREPK9227D1ZQ |  | 464 | 14-04-2019 | 15.24
733 | TALLY | 27DREPK9227D1ZQ |  | 3402 | 11-07-2019 | 15.24
1258 | PORTAL | 23ABCDK9227D1ZQ |  | 2019-20 /1234 | 2019-06-05 00:00:00 | 222
2158 | PORTAL | 23ABCDK9227D1ZQ |  | 2019-20 /1235 | 2019-06-05 00:00:00 | 222
2133 | TALLY | 23ABCDK9227D1ZQ |  | 234 | 2019-06-05 00:00:00 | 222
 |  |  | The cells colored as yellow should display blank.
Spreadsheet: 131351d1322908956-please-help-with-over-writing-into-the-next-colum-pic-attached-spillover
Sheet: Sheet1

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
Spreadsheet: 803766d1667670680-calling-data-from-sheets-xpvv
Sheet: 1

Sheet
2
3
4
5
Spreadsheet: 94270d1294136902-chart-data-table-info-doesnt-fit-758536
Sheet: GRAPH DATA

 |  |  |  | 3mo Libor | 1 Year | 2 Years | 3 Years | 5 Years | 30 Years | 10 Years
 |  |  | Jan 08 | 3.96 | 2.68 | 2.52 | 2.53 | 3.02 | 4.35 | 3.75
 |  |  | Feb | 3.13 | 1.92 | 1.97 | 2.15 | 2.77 | 4.5 | 3.72
 |  |  | Mar | 2.78 | 1.56 | 1.61 | 1.78 | 2.47 | 4.38 | 3.49
 |  |  | Apr | 2.8 | 1.75 | 2.02 | 2.21 | 2.83 | 4.44 | 3.65
 |  |  | May | 2.69 | 1.96 | 2.42 | 2.65 | 3.13 | 4.58 | 3.85
 |  |  | Jun | 2.77 | 2.37 | 2.75 | 3.05 | 3.47 | 4.69 | 4.08
 |  |  | Jul | 2.79 | 2.26 | 2.56 | 2.87 | 3.29 | 4.56 | 3.98
 |  |  | Aug | 2.81 | 2.15 | 2.4 | 2.67 | 3.13 | 4.5 | 3.88
 |  |  | Sep | 3.13 | 1.85 | 2.07 | 2.3 | 2.87 | 4.26 | 3.66
 |  |  | Oct | 4.11 | 1.35 | 1.58 | 1.85 | 2.7 | 4.12 | 3.74
 |  |  | Nov | 2.32 | 1.07 | 1.23 | 1.52 | 2.32 | 3.99 | 3.5
 |  |  | Dec | 1.79 | 0.47 | 0.82 | 1.07 | 1.52 | 2.86 | 2.4
 |  |  | Jan 09 | 1.23 | 0.41 | 0.79 | 1.1 | 1.57 | 3.06 | 2.44
 |  |  | Feb | 1.23 | 0.58 | 0.94 | 1.33 | 1.84 | 3.58 | 2.83
 |  |  | Mar | 1.27 | 0.63 | 0.93 | 1.31 | 1.82 | 3.64 | 2.81
 |  |  | Apr | 1.11 | 0.53 | 0.91 | 1.3 | 1.84 | 3.74 | 2.88
 |  |  | May | 0.82 | 0.47 | 0.91 | 1.38 | 2.12 | 4.22 | 3.28
 |  |  | June | 0.62 | 0.48 | 1.16 | 1.74 | 2.69 | 4.53 | 3.71
 |  |  | July | 0.52 | 0.45 | 0.98 | 1.52 | 2.43 | 4.4 | 3.53
 |  |  | Aug | 0.42 | 0.43 | 1.1 | 1.63 | 2.56 | 4.38 | 3.58
 |  |  | Sep | 0.29 | 0.38 | 0.95 | 1.47 | 2.36 | 4.19 | 3.39
 |  |  | Oct | 0.28 | 0.35 | 0.94 | 1.46 | 2.32 | 4.17 | 3.36
 |  |  | Nov | 0.24 | 0.29 | 0.8 | 1.31 | 2.22 | 4.31 | 3.39
 |  |  | Dec | 0.25 | 0.33 | 0.83 | 1.34 | 2.3 | 4.48 | 3.55
 |  |  | Jan 10 | 0.25 | 0.33 | 0.93 | 1.5 | 2.49 | 4.61 | 3.72
 |  |  | Feb | 0.25 | 0.32 | 0.84 | 1.39 | 2.35 | 4.62 | 3.67
 |  |  | Mar | 0.27 | 0.37 | 0.95 | 1.49 | 2.42 | 4.65 | 3.71
 |  |  | Apr | 0.31 | 0.42 | 1.04 | 1.63 | 2.57 | 4.7 | 3.83
 |  |  | May | 0.45 | 0.35 | 0.83 | 1.33 | 2.19 | 4.3 | 3.43
 |  |  | June | 0.54 | 0.29 | 0.72 | 1.17 | 2 | 4.14 | 3.21
 |  |  | July | 0.51 | 0.27 | 0.61 | 0.97 | 1.76 | 3.98 | 2.99
 |  |  | Aug | 0.36 | 0.24 | 0.51 | 0.77 | 1.46 | 3.8 | 2.69
 |  |  | Sept | 0.29 | 0.24 | 0.48 | 0.74 | 1.41 | 3.78 | 2.64
 |  |  | Oct | 0.29 | 0.21 | 0.37 | 0.57 | 1.18 | 3.85 | 2.51
 |  |  | Nov | 0.29 | 0.24 | 0.44 | 0.66 | 1.33 | 4.18 | 2.73
 |  |  | Dec | 0.3 | 0.28 | 0.61 | 0.98 | 1.91 | 4.41 | 3.26
Spreadsheet: 88934d1288737519-excel-2007-linking-multiple-cells-between-sheets-commongrndtest
Sheet: Sheet2

PARCEL ID | Units | widgets | thingamabobs | doodads | whosawhatsets
i | 1 | 5 | 67 | 6
f | 2 | 55 | 5 | 7
c | 3 | 1 | 6 | 3
d | 4 | 2 | 4 | 2
h | 5 | 2 | 3 | 4
b | 10 | 1 | 2 | 4
g | 55 | 5 | 6 | 4
e | 9 | 5 | 6 | 4
a | 8 | 5 | 6 | 1
Spreadsheet: 09e43f12-c5f8-4b85-b706-af2dced9bdd6
Sheet: Sheet1

Student's Name |  |  |  |  |  |  |  | Audit Completed by
PowerCampus ID |  |  |  |  |  |  |  | Date
CERTIFICATE IN PHARMACY TECHNOLOGY (41 Hours) Effective Fall 2010
 |  | Term | Year | School | Grade | Credits |  |  |  | Term | Year | School | Grade | Credits
1. GENERAL EDUCATION REQUIREMENTS (9 hrs) 1
English Composition (3)
ENGL 1001 |  |  |  |  |  | 3
Natural Sciences (3)
PHSC 1001 or |  |  |  |  |  | 3
CHEM 1001 or |  |  |  |  |  | 3
PHYS 1001 |  |  |  |  |  | 3
Humanities (3)
CMST 2060 |  |  |  |  |  | 3
Program Prerequisites (4)
HESC 1003 |  |  |  |  |  | 1
HESC 1400 |  |  |  |  |  | 3
2. MAJOR REQUIREMENTS (25 hrs)
HESC 1102 |  |  |  |  |  | 3
HESC 1110 |  |  |  |  |  | 3
HESC 1115 |  |  |  |  |  | 3
HESC 1116 |  |  |  |  |  | 3
HESC 1151 |  |  |  |  |  | 5
HESC 1152 |  |  |  |  |  | 5
HESC 1202 |  |  |  |  |  | 3
3. ELECTIVES (3)
HESC |  |  |  |  |  | 3
Health Science (Pharmacy) Elective
Notes
1 See list of approved courses in the General Education section of the LSUA Catalog.
Requirements for this certficate (ücompleted)
Students must make a grade of "C" or higher in all courses required by the curriculum.
Students must achieve an overall GPA of at least 2.0 on all college work attempted.
Students must be enrolled at LSUA during the semester the certificate is awarded.
Spreadsheet: 692231d1598201770-if-formulas-with-multiple-criterias-and-vlookup-test-formulas
Sheet: Sheet1

Client | Result wanted | [NAME] to find QTY TRANSIT for client 138 & 289 | [NAME] to find QTY TRANSIT for other clients | Status | Invoice | Product | QTY | Vlookup to include for Other clients
138 | 0 |  | IF(AND(NOT(OR(A2=138,A2=289))),IF(OR(LEFT(E2,3)="Rej",LEFT(E2,3)="Shi"),ISNA(VLOOKUP(F2,Sheet2!$A:$C,1,FALSE)"",Sheet1!H2)"",Sheet1!H2) | Shipment confirmed | 1001 | Apple | 2 | IF(ISNA(VLOOKUP(F2,Sheet2!$A:$C,1,FALSE)),"",H2)
138 | 0 |  |  | Shipment confirmed | 1001 | Oranges | 1
101 |  |  |  | Finance Approval | 1002 | Kiwi | 4
101 | 0 |  |  | Shipment confirmed | 1003 | Oranges | 3
314 |  |  |  | Logistic Picking | 1004 | Kiwi | 6
289 |  |  |  | Legalization | 1005 | Bananas | 1
289 |  |  |  | Finance Approval | 1005 | [NAME] | 1
289 | 0 |  |  | Shipment confirmed | 1006 | Peach | 3
289 |  |  |  | Logistic Picking | 1007 | Watermelon | 1
138 | 0 |  |  | Rejected | 1008 | Mango | 2
138 |  |  |  | Finance Approval | 1009 | Bananas | 2
138 |  |  |  | Legalization | 1010 | Apple | 1
138 | 0 |  |  | Shipment confirmed | 1011 | [NAME] | 1
138 | 0 |  |  | Rejected | 1012 | Kiwi | 1
138 |  |  |  | Logistic Picking | 1013 | Kiwi | 1
138 |  |  |  | Finance Approval | 1014 | Oranges | 1
101 | 0 |  |  | Rejected | 1015 | Kiwi | 1
101 |  |  |  | Legalization | 1016 | Bananas | 2
122 |  |  |  | Legalization | 1016 | [NAME] | 8
122 | 8 |  |  | Shipment confirmed | 1017 | Peach | 8
101 |  |  |  | Finance Approval | 1018 | Watermelon | 34
187 | 0 |  |  | Shipment confirmed | 1019 | Mango | 9
187 | 0 |  |  | Shipment confirmed | 1019 | Bananas | 7
300 |  |  |  | Logistic Picking | 1020 | Watermelon | 3
300 |  |  |  | Shipment confirmed | 1021 | Mango | 21
300 |  |  |  | Legalization | 1022 | Bananas | 2
300 |  |  |  | Finance Approval | 1023 | Apple | 5
289 |  |  |  | Legalization | 1024 | [NAME] | 2
289 | 0 |  |  | Shipment confirmed | 1025 | Kiwi | 5
289 |  |  |  | Legalization | 1026 | [NAME] | 8
289 | 0 |  |  | Rejected | 1027 | [NAME] | 3
289 |  |  |  | Logistic Picking | 1028 | Bananas | 8
289 | 2 |  |  | Legalization | 1029 | Pear | 2
323 | 0 |  |  | Rejected | 1030 | Peach | 1
123 | 5 |  |  | Shipment confirmed | 1031 | Oranges | 5
413 |  |  |  | Logistic Picking | 1031 | Watermelon | 3
Spreadsheet: darrell_schoolcraft__7470__MARKET2001
Sheet: JULY01

 |  |  |  | PERCENT
POI | SCHEDULED | ACTUAL | DEVIATION | [NAME]
71374 | 22715 | 23279
71393 | 7070 | 7034
71461 | 19260 | 20211
71463 | 7865 | 7880
71464 | 17110 | 18246
71465 | 15030 | 15584
71466 | 11945 | 12702
TOTAL
Spreadsheet: 116715d1312047062-transferring-results-and-drop-down-lists-runthenumbers
Sheet: PRA

145 | Line Number of Current Hospital |  |  |  |  | 0
 |  |  |  |  |  | 1.0114
 |  |  |  |  |  | 0
Hospital: | 0 |  |  | Date Prepared: |  | 2011-07-30 00:00:00
Hospital Number: | 145
 | 1900-01-01 00:00:00
 |  |  |  |  |  | 0
 |  |  |  |  |  | 1.0114 | Final
2010 Data 1 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 1.0114 | Final
2010 Data 2 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 1.0114 | Final
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 1.0114 | Final
 |  |  |  |  |  | 0
2010 Data 3 |  |  |  |  |  | 0
2010 Data 4 |  |  |  |  |  | 0
Not Applicable
2010 Data 5
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -4662 | -5000
2 | -17042 | -16843
3 | -17090 | -16843
4 | -10627 | -10000
5
6
7 | -9835 | -9656
8
9 | -12907 | -13000
10 | -6318 | -6000
11 | -5383 | -4262
12
13
14
15 |  | 10000
16 | -12589
17 | -25789 | -25000
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | -85517.91
2001-12-17 00:00:00
CBS Volume
 |  |  | -41313
Spreadsheet: chris_germany__2125__JanCohCHOICE-ENA
Sheet: Jan 19

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-01-19 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1351 |  | 1309 |  | 67694 |  |  |  |  |  | 23 | 1 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 2 | 25
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 4487 |  | 4808 |  | 67694 |  |  |  |  |  | 24 | 3 | 25
 |  |  |  |  |  |  |  |  | 6999 |  | 6999 |  | 68918 | 0 |  |  |  |  | 25 | 4 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 5 | 28
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2266 |  | 2393 |  | 67694 |  |  |  |  |  | 26 | 6 | 27
 |  |  |  |  |  |  |  |  | 2400 |  | 2400 |  | 68915 | 0 |  |  |  |  | 25 | 7 | 24
 |  |  |  |  |  |  |  |  | 500 |  | 500 |  | 69148 | 0 |  |  |  |  | 28 | 8 | 28
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 | 0 |  |  |  |  | 26 | 9 | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 15 | 31
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 16164 |  | 16164 |  | 67694 |  |  |  |  |  | 29 | 35 | 29
 |  |  |  |  |  |  |  |  | 85 |  | 85 |  | 68917 | 0 |  |  |  |  | 25 | 39 | 25
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69149 | 0
 |  |  |  |  |  |  |  |  | 1600 |  | 1600 |  | 69693 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2132 |  | 2033 |  | 67694 |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1272 |  | 1272 |  | 67694 |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 13199 |  | 13199 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 4006 |  | 3901 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4204 |  | 4204 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 5497 |  | 5210 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1554 |  | 1554 |  | 67694
 |  |  |  |  |  |  |  |  | 200 |  | 200 |  | 69708 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 41 |  | 41 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 69708 | 0
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  | 27835 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 216129d1361606540-workbook-if-formula-not-sure-if-correctly-used-edit_franpietrowski_ver2
Sheet: SHOP_PARTS_TRACKER

auto scrap- inventory log
Part Name/PN | IN-STOCK |  | FULL KITS RECEIVED |  |  |  |  |  | SENT UNITS |  |  | CURRENT INVENTORY/ WEEKLY
Large Backup Ring | 16 | 2 | 12115649R |  |  |  | 1 |  |  |  |  | Large Backup Ring | 16
N900004312 |  |  |  |  |  |  |  |  |  |  |  | N900004312
Small Backup Ring | 16 | 2 | 0 |  |  |  | 0 |  | 1A |  |  | Small Backup Ring | 14
N900004286 |  |  |  |  |  |  |  |  |  |  |  | N900004286
large O-Ring | 14 | 2 | 0 |  |  |  |  |  |  |  |  | large O-Ring | 14
N900000228 |  |  |  |  |  |  |  |  |  |  |  | N900000228
Small O-Ring | 14 | 2 | 0 |  |  |  |  |  |  |  |  | Small O-Ring | 14
N900000123 |  |  |  |  |  |  |  |  |  |  |  | N900000123
Inlet/Outlet O-RING | 14 | 2 | 0 |  |  |  |  |  |  |  |  | Inlet/Outlet O-RING | 14
N904000020 |  |  |  |  |  |  |  |  |  |  |  | N904000020
Hammer Union Seals | 28 | 4 | 0 |  |  |  |  |  |  |  |  | Hammer Union Seals | 28
10182792 |  |  |  |  |  |  |  |  |  |  |  | 10182792
Bearing [NAME] | 56 | 8 | 0 |  |  |  |  |  |  |  |  | Bearing [NAME] | 56
N056010825 |  |  |  |  |  |  |  |  |  |  |  | N056010825
Inlet/Outlet screws | 56 | 8 | 0 |  |  |  |  |  |  |  |  | Inlet/Outlet screws | 56
N900004386 |  |  |  |  |  |  |  |  |  |  |  | N900004386
[NAME] | 65 | 3 | 0 |  |  |  |  |  |  |  |  | [NAME] | 65
N900004265 |  |  |  |  |  |  |  |  |  |  |  | N900004265
[NAME] | 7 | 1 | 0 |  |  |  |  |  |  |  |  | [NAME] | 7
N900004824 |  |  |  |  |  |  |  |  |  |  |  | N900004824
[NAME] | 7 | 1 | 0 |  |  |  |  |  |  |  |  | [NAME] | 7
N900002990 |  |  |  |  |  |  |  |  |  |  |  | N900002990
Actuator [NAME] | 28 | 4 | 0 |  |  |  |  |  |  |  |  | Actuator [NAME] | 28
N900002058 |  |  |  |  |  |  |  |  |  |  |  | N900002058
Actuator Electrical Caps | 8 | 1 | 0 |  |  |  |  |  |  |  |  | Actuator Electrical Caps | 8
N900004119 |  |  |  |  |  |  |  |  |  |  |  | N900004119
CAN BUILD WITH PARTS AVAILABLE |  | 8
 |  | 8
Spreadsheet: 842487d1694555372-how-to-get-mutilple-search-results-using-index-and-match-formulas-shreenivas_automobiles_price_list-slatad-
Sheet: History_Details

Project Name: | Develop a Inventory Price Management tool
Sr.No | Date | Subject | Author
1 | 2023-03-14 00:00:00 | Initial version | [NAME]
2 | 2023-04-09 00:00:00 | Added few more entries | [NAME]
3 | 2023-04-17 00:00:00 | Added Dynamic listing | [NAME]
4 | 2023-09-05 00:00:00 | Added few more entries | [NAME]
Spreadsheet: 691564d1597759380-need-a-formula-if-in-total-column-if-there-is-value-it-will-be-visible-else-hide-total
Sheet: Sheet1

Total
Spreadsheet: 92974d1292491518-month-wise-datas-change-if-the-common-factor-change-power
Sheet: Sheet1

 | 2010-2011 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00
 | PLANT | HHHD
 | Power Cost/Veh.
 | Fuel Cost for Generation/Veh.
 | Other Fuel Cost/Veh.
 | Total Power and Fuel Cost/Veh
Spreadsheet: kate_symes__18189__EOL 12-20
Sheet: EOL Deals

EOL Deals | From: 12/1/2000   To: 12/20/2000 |  |  | EnPower Deals | From: 12/1/2000   To: 12/20/2000
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 558800 | 40 |  | EPMI Long Term California | 5384900 | 110
EPMI Long Term Northwest | 452800 | 32 |  | EPMI Long Term Northwest | 9787082 | 171
EPMI Long Term Southwest | 523600 | 17 |  | EPMI Long Term Southwest | 8047800 | 150
EPMI Short Term California | 185200 | 352 |  | EPMI Long Term West Management | 92400 | 3
EPMI Short Term Northwest | 65800 | 109 |  | EPMI Short Term California | 742840 | 99
EPMI Short Term Southwest | 528000 | 289 |  | EPMI Short Term Northwest | 330400 | 149
 |  |  |  | EPMI Short Term Southwest | 698600 | 174
Grand Total | 2314200 | 839
 |  |  |  | Grand Total | 25084022 | 856
EOL Deals | From: 12/20/2000   To: 12/20/2000
Desk | Total MWH | Total Deals |  | EnPower Deals | From: 12/20/2000   To: 12/20/2000
 |  |  |  | Desk | Total MWH | Total Deals
EPMI Long Term Southwest | 92400 | 3
EPMI Short Term California | 19200 | 24 |  | EPMI Long Term California | 261600 | 4
EPMI Short Term Northwest | 6000 | 5 |  | EPMI Long Term Northwest | 544800 | 6
EPMI Short Term Southwest | 9000 | 8 |  | EPMI Long Term Southwest | 92600 | 1
 |  |  |  | EPMI Short Term California | 6000 | 3
Grand Total | 126600 | 40 |  | EPMI Short Term Northwest | 6600 | 6
 |  |  |  | EPMI Short Term Southwest | 10800 | 9
 |  |  |  | Grand Total | 922400 | 29
Spreadsheet: 799327d1665046926-move-data-from-column-to-row-and-clear-duplicate-data-test_offset
Sheet: data

Question 1:  put data many columns to one row
A | B | C
J2 | K2 | L2 |  | J2 | K2 | L2 | J3 | K3 | L3 | J4 | K4 | [NAME] | J5 | K5 | L5
J3 | K3 | L3
J4 | K4 | [NAME]
J5 | K5 | L5
Question 2: only remove duplicate code (but still keep empty cell)
A123 |  |  |  | A123
B123 |  |  |  | B123
C444 |  |  |  | C444
A123
D222 |  |  |  | D222
C444
A123
Spreadsheet: 81112d1281375343-populate-averages-file-size-averages
Sheet: Summary

 |  |  |  |  |  |  | Part 1 | Part 2 | Part 3
 |  |  |  |  |  |  | Average
 |  | Section | Average | Min | [NAME] |  |  | Part 1-3 | Part 4 | Difference (%)
 | Part 1 | R10 |  | 5 | 20 |  | R10
 |  | R50 |  | 7 |  |  | R50
 |  | S12 |  | 7 |  |  | S12
 |  | Total |  | 19 |  |  | Total
 | Part 2 | R10 |  | 7
 |  | R50 |  | 7 |  |  | Draft - May not be useful for you - You can Delete it if you want
 |  | S12 |  | 8 |  |  |  | Part 1 | Part 2 | Part 3 | Part 4 | Difference (%)
 |  | Total |  | 22 |  |  | R10
 | Part 3 | R10 |  |  |  |  | R50
 |  | R50 |  |  |  |  | S12
 |  | S12 |  |  |  |  | Grand Total
 |  | Total
 | Part 4 | R10
 |  | R50 |  |  |  |  | [NAME] | Part 1-3
 |  | S12 |  |  |  |  | R10
 |  | Total |  |  |  |  | R50
 | Part 1-4 | R10 |  |  |  |  | S12
 |  | R50
 |  | S12
 |  | Total