tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 43087d1241689726-creating-a-drop-down-list-from-another-table-of-data-suppliersbymgr
Sheet: Sheet2

Suppliers | Manager | K1 |  | Q1
Supplier 1 | [NAME] | Dan1 |  | [NAME] | Jan | Feb | Mar | Apr | May | Jun | July | Aug | Sept | Oct | Nov | Dec
Supplier 2 | [NAME] | Dan2 |  | Supplier 23
Supplier 3 | [NAME] | Dan3 |  | Supplier 24
Supplier 4 | [NAME] | Dan4 |  | Supplier 25
Supplier 5 | [NAME] | Dan5 |  | Supplier 26
Supplier 6 | [NAME] | Dan6 |  | Supplier 27
Supplier 7 | [NAME] | Dan7 |  | Supplier 28
Supplier 8 | [NAME] | Dan8 |  | Supplier 29
Supplier 9 | [NAME] | [NAME] |  | Supplier 30
Supplier 10 | [NAME] | [NAME] |  | Supplier 31
Supplier 11 | [NAME] | James2 |  | Supplier 32
Supplier 12 | [NAME] | Chris1 |  | Supplier 33
Supplier 13 | [NAME] | Chris2 |  | Supplier 34
Supplier 14 | [NAME] | Chris3 |  | Supplier 35
Supplier 15 | [NAME] | Chris4 |  | Supplier 36
Supplier 16 | [NAME] | Chris5 |  | Supplier 37
Supplier 17 | [NAME] | Chris6
Supplier 18 | [NAME] | Jamie1 |  | Q1
Supplier 19 | [NAME] | Jamie2 |  | [NAME] | Jan | Feb | Mar | Apr | May | Jun | July | Aug | Sept | Oct | Nov | Dec
Supplier 20 | [NAME] | John1 |  | Supplier 38
Supplier 21 | Emma | Emma1 |  | Supplier 39
Supplier 22 | Emma | Emma2
Supplier 23 | [NAME] | Lisa1
Supplier 24 | [NAME] | Lisa2
Supplier 25 | [NAME] | Lisa3
Supplier 26 | [NAME] | Lisa4
Supplier 27 | [NAME] | Lisa5
Supplier 28 | [NAME] | Lisa6
Supplier 29 | [NAME] | [NAME]
Supplier 30 | [NAME] | Lisa8
Supplier 31 | [NAME] | Lisa9
Supplier 32 | [NAME] | Lisa10
Supplier 33 | [NAME] | Lisa11
Supplier 34 | [NAME] | Lisa12
Supplier 35 | [NAME] | Lisa13
Supplier 36 | [NAME] | Lisa14
Supplier 37 | [NAME] | Lisa15
Supplier 38 | [NAME] | Paul1
Supplier 39 | [NAME] | Paul2
Supplier 40 | Rachel | Rachel1
Supplier 41 | Rachel | Rachel2
Supplier 42 | [NAME] | Simon1
Supplier 43 | [NAME] | Simon2
Supplier 44 | [NAME] | Simon3
Supplier 45 | [NAME] | Simon4
Supplier 46 | [NAME] | Simon5
Supplier 47 | [NAME] | Simon6
Supplier 48 | [NAME] | Simon7
Supplier 49 | [NAME] | Simon8
Supplier 50 | [NAME] | Simon9
Supplier 51 | [NAME] | Simon10
Supplier 52 | [NAME] | Simon11
Supplier 53 | [NAME] | Jack1
Supplier 54 | [NAME] | [NAME]
Supplier 55 | [NAME] | [NAME]
Supplier 56 | [NAME] | Jack4
Supplier 57 | [NAME] | Jack5
Supplier 58 | [NAME] | Jack6
Supplier 59 | [NAME] | [NAME]
Supplier 60 | [NAME] | Jack8
Supplier 61 | [NAME] | Dean1
Supplier 62 | [NAME] | Dean2
Supplier 63 | [NAME] | Dean3
Supplier 64 | [NAME] | [NAME]
Supplier 65 | [NAME] | Dean5
Supplier 66 | [NAME] | Dean6
Supplier 67 | [NAME] | Dean7
Supplier 68 | [NAME] | Dean8
Supplier 69 | [NAME] | Dean9
Supplier 70 | [NAME] | Dean10
Supplier 71 | Template | Template1
Supplier 72 | Unknown | Unknown1
Supplier 73 | Unknown | Unknown2
Supplier 74 | Unknown | Unknown3
Supplier 75 | Unknown | Unknown4
Spreadsheet: 175338d1345492704-find-text-test-in-column-a1-a20-and-then-display-the-value-next-to-it-in-column-b-doc77
Sheet: Sheet1

test | 1
no | 4
no | 3
no | 1
no | 2
test | 3
no | 4
no | 5
no | 6
no | 4
test | 4
 |  |  |  | Value displayed here if "Test" is found in A1:A11  display value from column B
Spreadsheet: 69652d1270207848-formatting-problem-attaching-consolidate-target-updated
Sheet: PS

 | Innovative Private Limited |  | 2009-07-01 00:00:00
 | FORTNIGHT COLLECTION REPORT
 | power Solution
 | 2010-04-02 16:00:07 |  | 275.6667491898115
 | STATIONS | ACTUAL | TARGET | [NAME] | %AGE ACHIVED |  |  | ACTUAL | LAST YEAR AVG | [NAME] | %AGE
 | LHR | 20428889 | 60420109.41146554 | -39991220.41146554 | 0.3381140682959992 |  |  | 20428889 | 41554125.51797652 | -21125236.51797652 | 0.4916211987462559
 | KHI | 79511143.22 | 135945246.1757975 | -56434102.95579746 | 0.5848762311054279 |  |  | 79511143.22 | 76840061.7881301 | 2671081.431869894 | 1.034761573191271
 | ISB | 57817863.93 | 75525136.76433192 | -17707272.83433192 | 0.7655446439033197 |  |  | 57817863.93 | 34425881.43444239 | 23391982.49555761 | 1.679488266410934
 |  | 157757896.15 | 271890492.3515949 | -114132596.2015949 | 0.5802258651471914 |  |  | 157757896.15 | 152820068.740549 | 4937827.409450978 | 1.032311380633091
Spreadsheet: 137796d1327386952-help-with-vlookups-on-non-sorted-data-example
Sheet: Sheet2

ID | Wp | Wa | Total | Average | Tank | NL
1 | 100 | 110 |  |  |  | 30
2 | 110 | 120 |  |  |  | 30
3 | 120 | 154 |  |  |  | 30
4 | 200 | 236 |  |  |  | 30
5 | 300 | 320 |  |  |  | 30
6 | 150 | 262 |  |  |  | 30
7 | 52 | 232 |  |  |  | 30
8 | 325 | 328 |  |  |  | 30
9 | 30 | 50 |  |  |  | 30
10 | 130 | 170 |  |  |  | 30
11 | 50 | 60 |  |  |  | 30
Spreadsheet: 872088d1718442915-multiple-conditional-formatting-from-multiple-criteria-sample-292-cf-aligw
Sheet: Absence Data

First Name | Start Date | End Date | quantityInDays | quantityInHours
[NAME] | 2024-05-24 00:00:00 | 2024-05-24 00:00:00 | 1 | 8
[NAME] | 2024-05-24 00:00:00 | 2024-05-24 00:00:00 | 0.5 | 4
[NAME] | 2024-05-30 00:00:00 | 2024-05-30 00:00:00 | 0.5 | 4
[NAME] | 2024-05-23 00:00:00 | 2024-05-23 00:00:00 | 0.5 | 4
[NAME] | 2024-05-22 00:00:00 | 2024-05-22 00:00:00 | 0.5 | 4
[NAME] | 2024-05-17 00:00:00 | 2024-05-17 00:00:00 | 0.5 | 4
[NAME] | 2024-05-30 00:00:00 | 2024-05-30 00:00:00 | 0.5 | 4
[NAME] | 2024-05-24 00:00:00 | 2024-05-24 00:00:00 | 1 | 8
[NAME] | 2024-05-03 00:00:00 | 2024-05-03 00:00:00 | 1 | 8
[NAME] | 2024-05-29 00:00:00 | 2024-05-29 00:00:00 | 0.5 | 4
[NAME] | 2024-05-08 00:00:00 | 2024-05-08 00:00:00 | 0.5 | 4
[NAME] | 2024-05-17 00:00:00 | 2024-05-17 00:00:00 | 1 | 8
[NAME] | 2024-05-14 00:00:00 | 2024-05-14 00:00:00 | 1 | 8
[NAME] | 2024-05-07 00:00:00 | 2024-05-07 00:00:00 | 1 | 8
[NAME] | 2024-05-22 00:00:00 | 2024-05-23 00:00:00 | 2 | 16
[NAME] | 2024-05-13 00:00:00 | 2024-05-17 00:00:00 | 5 | 40
Spreadsheet: 782896d1654392299-how-to-use-filter-from-table-a-to-table-b-with-data-not-equal-to-null-followed-by-0-forumhelp6-5
Sheet: Sheet1

Table A
GRD | 85747485 | 85747485 | 85747485 | 85747485 | 85747485 | / | / | / | / | /
production line | Line1 | Line1 | Line1 | Line1 | Line1 | Line1 | Line1 | Line2 | Line2 | Line2
SKU | Product1 | Product2 | Product3 | Product4 | Product5 | Product6 | Product7 | Product8 | Product9 | Product10
1X | 0 | -1004 | 0 | 0 | 0 | -100 | 0 | 0 | 0 | 0
1Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2X | 0 | 0 | 103 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2Y | 0 | 0 | 0 | 208 | 0 | -1.5 | 0 | 0 | 0 | 0
3X | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3Y | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
4X | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TableB
GRD | 85747485 | 85747485 | 85747485 | / | /
production line | Line1 | Line1 | Line1 | Line1 | Line1
SKU | Product2 | Product3 | Product4 | Product6 | Product7
1X | -1004 | 0 | 0 | -100 | 0
2X | 0 | 103 | 0 | 0 | 0
2Y | 0 | 0 | 208 | -1.5 | 0
3Y | 0 | 0 | 0 | 0 | 1
Spreadsheet: 653763eb-604d-4d2e-b686-17eeb9425a43
Sheet: Diagnostics

Table 4 - Ratio of Reported Claims to Earned Premium
AY | 12
2002
Table 5 - Ratio of Reported Claims to On-Level Earned Premium
AY | 12
2002
Table 6 - Ratio of Paid Claims-to-Reported Claims
AY | 12
2002
Table 7 - Ratio of Cumulative Paid Claims to On-Level Earned Premium
AY | 12
2002
Table 10 - Ratio of Closed-to-Reported Claim Counts
AY | 12
2002
Table 12 - Average Reported Claim Development Table
AY | 12
2002
Table 13 - Average Paid Claim Development Table
AY | 12
2002
Table 14 - Average Case Outstanding Devlopment Triangle
AY | 12
2002
Spreadsheet: 817862d1676473023-calculating-remaining-months-from-date-column-remaining-month
Sheet: Sheet1

Start Date | Remaining Month | Cost to Com | Calculate |  | From 01/01/2022 | To 31/12/2022 | Minimum | Combined Formula
2022-06-10 00:00:00 |  | 424689
2022-04-01 00:00:00 |  | 57327
2023-02-01 00:00:00 |  | 15098
2022-11-10 00:00:00
2023-06-01 00:00:00
Spreadsheet: 04dac2eb-f679-4c98-9b3c-e66eb2c18e36
Sheet: Sheet1

Type of Injury | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
by Type of Weapon/Force Involved, 20111, 2
Type of Weapon/ Force Involved | Type of Injury
 |  | Murder and Nonnegligent Manslaughter3 | Apparent Broken Bones | Possible Internal Injury | Severe Laceration | Apparent Minor Injury | Other Major Injury | Loss of Teeth | Unconsciousness
Firearms | 73456 | 555 | 435 | 1612 | 1677 | 11785 | 6828 | 100 | 223
Firearm | 12652 | 167 | 90 | 429 | 321 | 2144 | 2260 | 15 | 40
Automatic Firearm | 1004 | 6 | 6 | 18 | 26 | 135 | 84 | 0 | 3
Handgun | 46257 | 284 | 267 | 960 | 1051 | 7038 | 3517 | 66 | 140
Automatic Handgun | 5193 | 27 | 20 | 64 | 77 | 819 | 363 | 6 | 16
Rifle | 2316 | 41 | 15 | 29 | 44 | 401 | 162 | 4 | 8
Automatic Rifle | 313 | 9 | 1 | 4 | 6 | 45 | 24 | 0 | 0
Shotgun | 3975 | 19 | 21 | 69 | 104 | 632 | 277 | 5 | 12
Automatic Shotgun | 96 | 0 | 1 | 1 | 3 | 15 | 6 | 1 | 0
Other Firearm | 1560 | 2 | 13 | 37 | 42 | 532 | 133 | 2 | 4
Automatic Other Firearm | 90 | 0 | 1 | 1 | 3 | 24 | 2 | 1 | 0
Knife/Cutting Instrument | 23311 | 77 | 213 | 1198 | 8833 | 13684 | 1531 | 44 | 200
Personal Weapons | 366049 | 29 | 5980 | 4715 | 5884 | 402819 | 6088 | 1557 | 3456
All Other | 70409 | 96 | 2574 | 3228 | 7630 | 61043 | 4735 | 505 | 1624
Blunt Object | 10049 | 32 | 1154 | 1237 | 4685 | 14982 | 1802 | 256 | 691
Motor Vehicle | 8526 | 9 | 405 | 553 | 291 | 3704 | 595 | 18 | 88
Poison | 101 | 0 | 1 | 37 | 0 | 62 | 26 | 1 | 2
Explosives | 158 | 0 | 1 | 4 | 1 | 30 | 9 | 0 | 0
Fire/Incendiary Device | 369 | 7 | 5 | 7 | 5 | 203 | 115 | 2 | 8
Drugs/Narcotics/Sleeping Pills | 329 | 0 | 3 | 73 | 2 | 93 | 24 | 2 | 42
Asphyxiation | 270 | 5 | 20 | 83 | 39 | 761 | 75 | 6 | 141
Other Weapon | 34346 | 26 | 532 | 707 | 1777 | 31910 | 1357 | 135 | 282
Unknown Weapons | 16261 | 17 | 453 | 527 | 830 | 9298 | 732 | 85 | 370
No Weapon/Force Involved | 65361 |  | 207 | 486 | 226 | 31096 | 325 | 48 | 144
1This table does not include totals because in the table a victim can be counted more than once since he/she can be connected to up to ten offense types per incident, up to five types of injury, and up to three weapons per offense type.
2Type Weapon/Force Involved is collected for 13 NIBRS offense types and Type of Injury is collected for 9 offense types.  This table does not include information for the offense types Negligent Manslaughter, Justifiable Homicide, and Weapon Law Violations even though the type of weapon/force information is available.  Although Murder and Nonnegligent Manslaughter is not typically included as a type of injury, it is included for informational purposes as it relates to the type of weapon/force used to commit the offense.  See Methodology for more information.
3The data value 99 = None (No Weapon/Force Involved) is not allowed for offense types 9A, 9B, and 9C, Homicide Offenses.
Spreadsheet: e2427d13-73ff-42b2-bea1-e88c928b5104
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
ENGTECH A/S | 3 etasje Ingeniør Rybergs gate 101 | 3027 | Drammen | 32 26 44 40
LYNIS KJØLEUTSTYR AS | Bergsagelveien 3 | 4016 | Stavanger | 51 58 94 73 | 51 58 23 73
A C Landgraff AS | [NAME] 13 | 1344 | Haslum | 67 52 60 00 | 67 53 88 12
BELIMO AUTOMATION NORGE AS | Brynsveien 18 | 0667 | Oslo | 22 70 71 71 | 22 70 71 70
FLOM KJETTING AS | Stokkevannsveien 17 | 3960 | Stathelle | 35 96 87 90 | 35 96 87 99
FRANKERING & KOPISERVICE AS | Skjoldens vei 9 | 1711 | Sarpsborg | 69 97 22 00 | 69 97 22 09
FUTURE SOLUTION AS | Kjelsbergtunet 29 | 4050 | Sola | 51 32 59 00 | 51 32 59 01
DINAIR EKONOMIFILTER AS | [NAME] 36 | 1081 | Oslo | 22 90 59 00 | 22 90 59 09
NERION AS | Pirsenteret | 7005 | Trondheim | 73 54 55 00 | 73 54 55 20
AS NORENCO MHS | [NAME] vei 68 | 0581 | Oslo | 22 72 76 10
Nortech AS | Unnelandsvegen 258 | 5268 | Haukeland | 55 39 06 10 | 55 28 70 60
RISHAUG RENHOLDSMASKINER AS | Haakon VII,s gate 23C | 7041 | Trondheim | 72 81 05 50 | 72 81 05 51
SCAN SECURE AS | Wirgenes vei 5A | 3157 | Barkåker | 33 03 05 50 | 33 03 05 58
IOS ENERGY AS | [NAME] nr 2 | 4029 | Stavanger | 51 83 66 60 | 51 83 66 66
DSI SYSTEMER AS | [NAME] vei 9 B | 0680 | Oslo | 22 57 03 00 | 22 57 03 01
SYNIGO AS | Øvre alle 5B | 7030 | Trondheim | 73 52 19 13
TVEITAN NORD AS | Fossegrenda 7 | 7038 | Trondheim | 07-887173
[NAME] | [NAME] | 1471 | Lørenskog | 67 92 60 00 | 67 92 42 95
IDS A/S | Furuveien 17C | 1356 | Bekkestua | 67 10 54 30 | 67 10 54 28
BRANDR GRUPPEN AS | [NAME] | 0277 | Oslo
KAFFEBRYGG AS | Lars Jordes veg 5 | 2615 | Lillehammer
CHANSON NORGE AS | Holmenveien 20 | 0374 | Oslo
[NAME] | [NAME] gate 50 | 0481 | Oslo | 23 40 04 00 | 23 40 04 01
BERGEN STORKJØKKENSENTER AS | [NAME] | 5042 | Bergen | 55 33 35 80 | 55 33 35 99
ELEKTRO KJØL AS | Industriv 4 | 9152 | Sørkjosen | 77 76 55 30 | 77 76 73 75
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 858905d1707401868-weekly-rent-payment-sheet-list-due-dates-and-tenant-based-on-tenant-and-duration-forum_example_dates-within-a-range
Sheet: Sheet1

Date | Category | Amount Agreed | [NAME] | Ten.Actual  Start | Ten. Actual End | Ten. Duration | PlannedTenancy End | Deposit Paid | Deposit Amoount | Dep.Returned Date | [NAME] | [NAME]
2023-01-01 00:00:00 | Rent Start Date | 110 | [NAME] |  | 2023-05-04 00:00:00 | 30 |  | 2024-02-02 00:00:00 | 1000 | 2023-09-16 00:00:00 | 800
2023-09-16 00:00:00 | Rent Start Date | 115 | [NAME] |  | 2023-09-16 00:00:00 | 30 |  |  | 0 |  | 0
2023-11-14 00:00:00 | Rent Start Date | 120 | [NAME] |  |  | 365 |  |  | 0 |  | 0
 |  | 0 |  |  |  |  |  |  | 0 |  | 0
 |  | 0 |  |  |  |  |  |  | 0 |  | 0
 |  | 0 |  |  |  |  |  |  | 0 |  | 0
 |  | 0 |  |  |  |  |  |  | 0 |  | 0
 |  | 0 |  |  |  |  |  |  | 0 |  | 0
 |  | 0 |  |  |  |  |  |  | 0 |  | 0
 |  | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00
 | RENT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | EXPENSES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PROFIT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Rent History
Due Date | Name | Amount Paid | Date paid | Amount Due | Due Date | Days Late | Arrears to Date
Spreadsheet: 781726d1653501869-filter-formula-with-multiple-conditions-2022-05-25-oeldere-mstgier-test2
Sheet: Sheet1

 | Person | Region | Responsible | District |  |  | Aantal van Responsible | Kolomlabels
 | A | R | Single | 11 |  |  | Rijlabels | Multi | Single | Eindtotaal
 | B | R | Multi | 11 |  |  | M | 1 | 3 | 4
 | C | R | Single | 11 |  |  | 12 |  | 3 | 3
 | D | M | Single | 12 |  |  | D |  | 1 | 1
 | E | M | Single | 12 |  |  | E |  | 1 | 1
 | F | U | Multi | 11 |  |  | J |  | 1 | 1
 | G | R | Multi | 12 |  |  | 14 | 1 |  | 1
 | H | U | Single | 14 |  |  | K | 1 |  | 1
 | I | R | Multi | 14 |  |  | R | 3 | 2 | 5
 | J | M | Single | 12 |  |  | 11 | 1 | 2 | 3
 | K | M | Multi | 14 |  |  | A |  | 1 | 1
 | L | U | Multi | 12 |  |  | B | 1 |  | 1
 |  |  |  |  |  |  | C |  | 1 | 1
 |  |  |  |  |  |  | 12 | 1 |  | 1
 |  |  |  |  |  |  | G | 1 |  | 1
 |  |  |  |  |  |  | 14 | 1 |  | 1
 |  |  |  |  |  |  | I | 1 |  | 1
 |  |  |  |  |  |  | U | 2 | 1 | 3
 |  |  |  |  |  |  | 11 | 1 |  | 1
 |  |  |  |  |  |  | F | 1 |  | 1
 |  |  |  |  |  |  | 12 | 1 |  | 1
 |  |  |  |  |  |  | L | 1 |  | 1
 |  |  |  |  |  |  | 14 |  | 1 | 1
 |  |  |  |  |  |  | H |  | 1 | 1
 |  |  |  |  |  |  | Eindtotaal | 6 | 6 | 12
Spreadsheet: 430268d1447445996-trying-to-combined-data-from-separate-sheets-combine-worksheets-into-master-worksheet
Sheet: Vendor 3

 | Item Number | Distributor | Description | UM | Size | Case Qty | Cost/ea | Cost/UM | Cost/Case | Type | Use | Frequency | Not Applicable
 | 1 | v3 | Cleaner 8 oz Can | can | 8 | 12 |  |  | 200.19 | [NAME] | Expendable | 2
 | 2 | v3 | Nitrile Glove | box | 100 | 10 |  |  | 50.87 | Glove | Expendable | 1
 | 3 | v3 | Paper 800ft | roll | 800 | 4 |  |  | 40.01 | Towel | Expendable | 3
 | 4 | v3 | 55 gallon thick | roll | 25 | 10 |  |  | 34.75 | [NAME] | Expendable | 1
 | 5 | v3 | Lobby broom plastic | ea | 1 | 1 |  |  | 5.68 | Broom | Non-Expendable | 0
 | 6 | v3 | 20 gallon [NAME] | roll | 50 | 10 |  |  | 34 | [NAME] | Expendable | 1
Spreadsheet: 491395d1480450736-vlookup-with-multiple-results-and-multiple-sheets-in-excel-phi_example-v2
Sheet: Invoice Lines

PO Number | Invoice # | Invoice Date | GL Date
1 | 5968 | 11/11/16 | 11/22/16
1 | ELA000357422 | 10/31/16 | 11/23/16
2 | 5968 | 11/11/16 | 11/22/16
2 | IN496171 | 08/25/16 | 08/26/16
3 | BBI017 | 07/15/16 | 07/15/16
4 | U011538WVUKAO | 04/06/16
6 | 5180621 | 01/04/16
GPO-0038731 | IN496171 | 08/25/16 | 08/26/16
GPO-0066281 | 5180621 | 01/04/16
GPO-0066282 | 5180621 | 01/04/16
GPO-0066283 | 5180621 | 01/04/16
GPO-0066284 | 5180621 | 01/04/16
GPO-0066285 | 5180621 | 01/04/16
GPO-0124321 | U011538WVUKAO | 04/06/16
[NAME] | U011538WVUKAO | 04/06/16
[NAME] | U011538WVUKAO | 04/06/16
GPO-0172471 | 440798 | 07/21/16 | 09/01/16
GPO-0172473 | 440798 | 07/21/16 | 09/01/16
GPO-0172474 | 440798 | 07/21/16 | 09/01/16
GPO-0204591 | BBI017 | 07/15/16 | 07/15/16
GPO-0204592 | BBI017 | 07/15/16 | 07/15/16
GPO-0227981 | 57609200 | 09/01/16 | 09/12/16
GPO-0227982 | 57609200 | 09/01/16 | 09/12/16
GPO-0275301 | BBI040 | 09/15/16 | 09/15/16
GPO-0275302 | BBI040 | 09/15/16 | 09/15/16
GPO-0275303 | BBI040 | 09/15/16 | 09/15/16
GPO-0293401 | 103116 | 10/31/16 | 11/11/16
GPO-0293402 | 103116 | 10/31/16 | 11/11/16
GPO-0293403 | 103116 | 10/31/16 | 11/11/16
GPO-0293404 | 103116 | 10/31/16 | 11/11/16
GPO-0295801 | 11201601 | 11/22/16 | 11/23/16
GPO-0295801 | 10201602 | 11/03/16 | 11/07/16
GPO-0295801 | 10201601 | 10/20/16 | 11/08/16
GPO-0295802 | 10201601 | 10/20/16 | 11/08/16
GPO-0302281 | 1 | 09/26/16 | 11/01/16
GPO-0302281 | 1 | 09/26/16 | 10/26/16
[NAME] | 37790 | 09/14/16 | 11/14/16
GPO-0306831 | 20498899US0AB | 10/14/16 | 11/07/16
GPO-0308541 | [NAME] | 11/01/16 | 11/08/16
GPO-0308851 | 3A | 11/17/16
GPO-0308851 | 31 | 11/17/16 | 11/22/16
GPO-0308851 | 2 | 11/03/16 | 11/22/16
GPO-0308851 | 3 | 11/17/16 | 11/18/16
GPO-0308851 | 1 | 09/26/16 | 11/08/16
GPO-0308852 | 3A | 11/17/16
[NAME] | 3A | 11/17/16
GPO-0318401 | 111316 | 11/13/16 | 11/21/16
Spreadsheet: 807953d1670183932-using-conditional-formatting-to-keep-track-efcf-s
Sheet: List

10 | 20 | 30
11 | 21 | 31
12 | 22 | 32
13 | 23 | 33
14 | 24 | 34
15 | 25 | 35
16 | 26 | 36
17 | 27 | 37
18 | 28 | 38
19 | 29 | 39
Spreadsheet: 73600d1274240007-move-duplicate-data-to-the-row-of-the-first-duplicated-data-upload
Sheet: Sheet1

A | B | c | d | e | f | g | h
Computer | Display | LCD
Video | [NAME] | LCD
Home Audio | Surrond Audio | Speakers
Home Speaker | Satellite Speaker | Speakers
 |  | LCD |  |  |  |  | Computer>>Display||Video>>Television
 |  | Speakers |  |  |  |  | Home Audio>>Surrond Audio || Home Speaker>>Satellite Speaker
Spreadsheet: 357159d1415310375-how-to-count-cells-by-color-num_of_colors
Sheet: Sheet1

 | DATA
1 | A | A | B | B | C | A | D | E | A | A
2 | A | B | B | B | B | B | F | E | I
3 | D | D | E | C | A | D | A
4 | C | E | F | H | I | F
5 | C | A | I | F
6 | F | B | F
7 | C | A
 | RESULT
 | Number of diff color cells
1 | 5
2 | 5
3 | 4
4 | 5
5 | 4
6 | 2
7 | 2
Spreadsheet: james_steffes__13047__Stranded Cost Analysis Structuring Confidential
Sheet: Overmarket Chart

 | DWR Contracts By Counter Party
 | Allegheny
 | Calpine
 | Clearwood
 | Coral
 | El Paso
Mi`` | Mirant
 | Alliant
 | Constellation
 | Dynegy
 | High Desert
 | IID
 | Morgan Stanley
 | PG&E Gen
 | [NAME]
 | Duke Energy
Spreadsheet: 887075d1737196910-required-formula-for-common-digits-any-3-col-and-4-col-remening-digits-in-0-9-any-3col-and-4-c-common-digits-1
Sheet: Sheet1

D1 | D2 | D3 | D4 | D5 |  | COMMON DIGITS IN ALL 5 UNIQUE DIGITS SET | REMANING DIGITS( NO FOUND ) IN ALL  5 UNIQUE DIGITS SET |  | COMMON DIGITS FOUND IN ANY 3 COULMNS UNIQUE DIGITS SET | REMENING DIGITS ( NO FOUND )IN ANY 3 COULMNS UNIQUE DIGITS SET |  | COMMON DIGITS FOUND IN ANY 4 COULMNS UNIQUE DIGITS SET | REMENING DIGITS ( NO FOUND )IN ANY 4 COULMNS UNIQUE DIGITS SET
49326 | 20354 | 67890 | 67890 | 24680 |  |  |  |  | 24689 | 37 |  | 0 | 5 | 5 digit found in b col, not found in other 4 col
52163 | 60215 | 12345 | 12345 | 13579 |  |  |  |  |  | 64 |  | 23 | 790
64381 | 32649 | 67890 | 67890 | 24680 |  |  |  |  | 90 | 234 |  | 78 | 1
81207 | 31062 | 45678 | 67890 | 24680 |  |  |  |  | 7 | 124 |  | 680 | 359
19476 | 14097 | 89012 | 67890 | 24680 |  |  |  |  | 1478 | 26 |  | 90
13057 | 36874 | 90123 | 90123 | 13579 |  |  |  |  | 790 | 25 |  | 1 | 468
 |  |  |  |  |  | This formula is Working Perfectly
 |  |  |  |  |  |  |  |  | Need This result from [NAME] |  |  | Need This result from [NAME]
Spreadsheet: 734164d1622024509-looking-up-by-month-and-retuning-information-book2
Sheet: Sheet2

 | DROP DOWN MENU
 | 2021-01-01 00:00:00
 | Uploaded on |  | I would like an indirect formula, so when I change the month, the information will change automatically
 | 227627 |  |  |  |  | 2021-01-01 00:00:00
 | 252810 |  | 263984 | 263984 |  | 2021-02-01 00:00:00
 | 263984 |  | 230265 | 230265 |  | 2021-03-01 00:00:00
 | 230265 |  | 213160 | 213160 |  | 2021-04-01 00:00:00
 | 213160 |  | 202792 | 202792 |  | 2021-05-01 00:00:00
 | 202792 |  | 201411 | 201411 |  | 2021-06-01 00:00:00
 | 201411 |  | 201415 | 201415 |  | 2021-07-01 00:00:00
 | 201415 |  |  |  |  | 2021-08-01 00:00:00
 |  |  |  |  |  | 2021-09-01 00:00:00
 |  |  |  |  |  | 2021-10-01 00:00:00
 |  |  |  |  |  | 2021-11-01 00:00:00
 |  |  |  |  |  | 2021-12-01 00:00:00