tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 824152d1680338583-calculating-an-amount-to-withhold-from-paycheck-deduction-calculator
Sheet: Sheet1

The rates of Shortages applicable are as follows:
RATES OF NORMAL SHORTAGES FOR INDIVIDUALS
Exceeds | Does not exceed
Shortages |  | Fixed Deduction | Rate on Excess | Rates
0 | 200 | 200 | 1 | E200 + 0% of the excess of 0
200 | 250 | 200 | 0.09 | E200 + 0% of the excess of 200
250 | 300 | 200 | 0.08 | E200 + 0% of the excess of 250
300 | 350 | 200 | 0.07 | E200 + 0% of the excess of 300
350 | 400 | 200 | 0.06 | E200 + 0% of the excess of 350
400 | 450 | 200 | 0.05 | E200 + 0% of the excess of 400
450 | 500 | 200 | 0.04 | E200 + 0% of the excess of 450
500 | 550 | 200 | 0.03 | E200 + 0% of the excess of 500
550 |  | 200 | 0.02 | E200 + 0% of the excess of 550
Examples
Shortage | Deduction Calculator
 | Fixed Deduction per Table | Excess | Rate on excess |  | Expected Deduction
200 |  |  | 0 |  | 200
250 | 200 | 50 | 0.09
350 | 200 | 150 | 0.06
450 | 200 | 250 | 0.04
500 and Above | 200 | excess of 200 | 0.02
Spreadsheet: 845207d1696730581-days-employees-projects-sums-employee-time-tracking
Sheet: Project Sum Sheet

 |  | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025
 |  | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December
 | Sum
[NAME]
Moonlight Sonata
Operation Quantum Leap
Operation Red Dawn II
Operation Red Sky
Operation Silver Lining
Operation Stardust III
Operation Starlight
Operation Thunder
Operation Thunderstrike
Operation Whiteout II
Project Andromeda
Project Avalon
Project Blackout II
Project Blue Moon II
Project Eclipse II
Project Infinity II
Project Nebula
Project [NAME]
Project Odyssey
Project [NAME]
Project Prometheus II
Project Serenity II
Project Terra
Project Thunderbolt II
Project Titan III
Project Ulysses II
Project Voyager
Project Zeta
Quantum Leap
Solaris Expedition
Spreadsheet: 151034d1334762288-conditional-formatting-problem-book1_brianfromla
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 |  | 1027.81 | 1027.81 | 1027.81 | 1027.81 | 1027.81 | 1027.81 | 1027.81 | 1027.81 | 1027.81 | 1027.81 | 1027.81 | 1027.81 | 1027.81 | 1027.81 | 1027.81 | 1027.81 | 1011.5
 |  | 1035.6 | 1035.6 | 1035.6 | 1035.6 | 1035.6 | 1035.6 | 1035.6 | 1035.6 | 1035.6 | 1035.6 | 1035.6 | 1035.6 | 1035.6 | 1035.6 | 1035.6 | 1035.6
 |  | 1029.02 | 1029.02 | 1029.02 | 1029.02 | 1029.02 | 1029.02 | 1029.02 | 1029.02 | 1029.02 | 1029.02 | 1029.02 | 1029.02 | 1029.02 | 1029.02 | 1029.02 | 1029.02 | 1050
 |  | 1034 | 1034 | 1034 | 1034 | 1034 | 1034 | 1034 | 1034 | 1034 | 1034 | 1034 | 1034 | 1034 | 1034 | 1034 | 1034
 |  | 1017 | 1017 | 1017 | 1017 | 1017 | 1017 | 1017 | 1017 | 1017 | 1019 | 1017 | 1017 | 1017 | 1017 | 1017 | 1017
 |  | 1031.56 | 1031.56 | 1031.56 | 1031.56 | 1031.56 | 1031.56 | 1031.56 | 1031.56 | 1031.56 | 1031.56 | 1031.56 | 1031.56 | 1031.56 | 1031.56 | 1031.56 | 1031.56
 |  | 992.5 | 992.5 | 992.5 | 992.5 | 992.5 | 992.5 | 992.5 | 992.5 | 992.5 | 992.5 | 992.5 | 992.5 | 992.5 | 992.5 | 992.5 | 992.5
 |  | 996.79 | 996.79 | 996.79 | 996.79 | 996.79 | 996.79 | 996.79 | 996.79 | 996.79 | 996.79 | 996.79 | 996.79 | 996.79 | 996.79 | 996.79 | 996.79
 |  | 994 | 994 | 994 | 994 | 994 | 994 | 994 | 994 | 994 | 994 | 994 | 994 | 994 | 994 | 994 | 994
 |  | 999 | 999 | 999 | 999 | 999 | 999 | 999 | 999 | 999 | 999 | 999 | 999 | 999 | 1000 | 1000 | 1000
 |  | 992.09 | 992.09 | 992.09 | 992.09 | 992.09 | 992.09 | 992.09 | 992.09 | 992.09 | 992.09 | 992.09 | 992.09 | 992.09 | 992.09 | 992.09 | 992.09
 |  | 1033.4 | 1033.4 | 1033.4 | 1033.4 | 1033.4 | 1033.4 | 1033.4 | 1033.4 | 1033.4 | 1033.4 | 1033.4 | 1033.4 | 1033.4 | 1033.4 | 1033.4 | 1033.4
 |  | 1003 | 1003 | 1003 | 1003 | 1003 | 1003 | 1003 | 1003 | 1003 | 1003 | 1003 | 1003 | 1003 | 1003 | 1003 | 1003
 |  | 1000.67 | 1000.67 | 1000.67 | 1000.67 | 1000.67 | 1000.67 | 1000.67 | 1000.67 | 1000.67 | 1000.67 | 1000.67 | 1000.67 | 1000.67 | 1000.67 | 1000.67 | 1000.67
Spreadsheet: 99683d1298295399-cross-reference-cell-update-question-update-demo-after
Sheet: Sheet1

product_id | name | price | manufacturer
1001 | [NAME] | 2 | dell
1002 | Hinge | 3 | microsoft
1003 | Lock | 5.5 | ibm
1004 | [NAME] | 4.4 | ibm
Spreadsheet: 139106d1328078259-how-to-calculate15-when-a-symbol-is-used-in-cells-fund-raising
Sheet: Sheet1

Name | Amount
[NAME] | `200
Rathinam | `150
Suresh | `100
Dhamu | `120
Naveen | `150
Susse | `250
Ramya | `200
[NAME] | `100
Bala | `100
Saranya | `150
Sajitha | `120
Sathish | `150
Nirosha | `200
[NAME] | `250
[NAME] | `200
Total
Spreadsheet: c447d6af-9b4b-4be9-a09e-bf698f21ea60
Sheet: Sheet1

Artist | Title | SubTitle | CatalogNumber | Category | Discs | [NAME] | Label | RetailPrice | UPC
VPI | [NAME] 33 RPM |  | S VPI 33 TUBE | Accessories for Record Cleaning Machines |  |  | Equipment | 30
VPI | Handled Brush for HW 16.5 |  | S VPI HB | Accessories for Record Cleaning Machines |  |  | Equipment | 40
VPI | [NAME] (HW 17) Not Handheld |  | S VPI RB | Accessories for Record Cleaning Machines |  |  | Equipment | 14
VPI | 3129 Complete 78 rpm [NAME] (10" discs) |  | S VPI 78KIT | Accessories for Record Cleaning Machines |  |  | Equipment | 72
Spreadsheet: 5c522ddd-323a-4c05-b79b-d4d62600c2f9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Construction Spending
 |  | Annual Rate for Total Construction: U.S. Total
 |  | Seasonally Adjusted Total Construction [Millions of Dollars]
 |  | Period: 2002 to 2012
 |  | Data Extracted on: May 23, 2013 (4:09 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2002 | 858654 | 862338 | 844551 | 858240 | 850935 | 846777 | 847129 | 839008 | 832134 | 839690 | 844697 | 855921
2003 | 863855 | 859225 | 851132 | 859459 | 866814 | 880865 | 891264 | 901839 | 911589 | 925732 | 925985 | 948491
2004 | 938826 | 938656 | 960946 | 967761 | 974158 | 983072 | 1006119 | 1013724 | 1012290 | 1015562 | 1023210 | 1037684
2005 | 1036187 | 1056492 | 1065262 | 1058365 | 1078586 | 1089505 | 1109691 | 1119782 | 1131739 | 1145663 | 1156977 | 1178305
2006 | 1183861 | 1199767 | 1213270 | 1183485 | 1180059 | 1172932 | 1165093 | 1158193 | 1151104 | 1139292 | 1137488 | 1153491
2007 | 1149899 | 1156008 | 1167402 | 1159124 | 1168195 | 1166892 | 1154018 | 1160593 | 1165162 | 1152511 | 1127558 | 1108958
2008 | 1106047 | 1092331 | 1094910 | 1091142 | 1091008 | 1074637 | 1066919 | 1057459 | 1056666 | 1050690 | 1029211 | 993515
2009 | 962704 | 959907 | 954984 | 929593 | 911241 | 901987 | 899601 | 889643 | 880259 | 869374 | 850732 | 832565
2010 | 816132 | 795808 | 805985 | 824008 | 816318 | 816302 | 788524 | 791653 | 798916 | 800266 | 798328 | 779895
2011 | 752638 | 746056 | 753433 | 755420 | 775837 | 786784 | 763468 | 786308 | 790294 | 795733 | 804046 | 820614
2012 | 824687 | 820677 | 817842 | 825133 | 838778 | 845072 | 846645 | 855916 | 862220 | 876213 | 892448 | 893634
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 | -1 | -7125
500046 |  | -428 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 | -246 | -287
500528
500529
500619
INDEX
2001-05-31 00:00:00 |  |  | -843943.02
2001-06-16 00:00:00
Spreadsheet: 48559d1247777095-text-lookup-sample
Sheet: Sheet1

RSA
SL. NO. | [NAME] | EMPTY IN YARD | BOOKING REFERENCE NO | CONTAINER NO. | SEAL NO. | SHIPPING LINE | DESTINATION PORT | FULL IN YARD | SUPPLIER / LOADING SITE / YARD | MATERIAL CODE | MATERIAL [NAME] | WEIGHT MT | TARE WT (MT) | PAY LOAD (MT) | TRANSPORTER | STORAGE SITE | PRICE ZAR PMT | PRICE USD PMT | IHC EMPTY ZAR | IHC FULL ZAR | IHC TOTAL ZAR (SUM U+V) | THC ZAR | WARFAGE ZAR | CTO FEE ZAR | DOC CHARGES ZAR | AGENCY FEES ZAR | W/B CHARGES ZAR | STORAGE ZAR | LIFT ON/OFF ZAR | X-HAUL ZAR | TOTAL FOBING COST ZAR | TOTAL FOB COST OF FULL CONTAINER | FOBING COST PER CONT USD | TOTAL FOBING COST PMT ON ACTUAL WT BASIS USD | TOTAL FOBING COST PMT ON 20 MT BASIS USD | EXCHANGE RATE | FOB COST PMT ON ACTUAL WT BASIS USD | FOB COST PMT ON 20 MT BASIS USD | OCEAN FRIEGHT USD | OCEAN FREIGHT ON 20 MT BASIS USD | OCEAN FREIGHT PMT ON ACTUAL WT BASIS USD | SELLING COST USD | TOTAL C&F COST ON 20 MT BASIS USD | USD PMT CNF ACTUAL WT | INSPECTED BY | REMARKS | VESSEL / VOYAGE NO. | CRS / BLI / SOB | OBL NUMBER | SOB DATE | ROTATION PERIOD | BLI NO.
UAE
S.NO | LOADING SITE | DATE CONT. PLACED IN YARD | GRN NO. | CONT. NO. | SEAL NO. | SHIPPING LINE |  | DATE LIFTED FROM YARD | NAME OF YARD | MATERIAL CODE | MATERIAL [NAME] | NET | TARE WT. | PAY LOAD |  |  | RATE | MATERIAL RATE IN USD
Spreadsheet: 05bd2c95-0328-4bdb-9b14-62ca30e6b6bd
Sheet: 2011-12

Table U
Student Numbers by Disability
2011-12
Disability | Undergraduate | Graduate | Total
Autistic Spectrum Disorder | 25 | 12
Blind / Are Partially Sighted | 15 | 15
Deaf / Have a Hearing Impairment | 18 | 29
Specific Learning Disability - e.g Dyslexia | 351 | 201
Mental Health Difficulties | 59 | 40
Multiple Disabilities | 14 | 24
Unseen Disability eg Diabetes, [NAME], [NAME] | 82 | 100
Wheelchair User / Have Mobility Difficulties | 20 | 20
Other Disability | 65 | 58
No Known Disability | 13019 | 10213
Not Known | 104 | 375
Total
The data in this table reflects disability information voluntarily provided by students at the time of application. Students who do not wish to declare their disability or subsequently develop or are diagnosed as having a disability while studying at UCL will remain in the "No Known Disability" or "Not Known" categories. Therefore, the actual number of students with disabilities registered at UCL will be higher than indicated in this table.
Spreadsheet: tracy_geaccone__40281__EMNNG01CE
Sheet: O&M

PRINT: O&M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st | 2nd | 3rd | 4th
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  |  |  |  | Quarter | Quarter | Quarter | Quarter |  | Total
Direct Costs
Commercial (Formerly Mrkting, Bus.Srv., [NAME].Affairs & Admin.) |  |  |  |  |  |  |  | 2000 | 1400 | 1300 | 2300 | 1500 | 1600
Gomez Sale |  | 0 | 0 | 0 | 0 | 0 | 0
Marketing Services |  |  |  |  |  |  |  | 400 | 400 | 500 | 300 | 400 | 500
Operations
KN Reimbursement |  | -31 | -30 | -31 | -31 | -31 | -30
Dodge Street Sublease |  | -10 | -10 | -10 | -10 | -10 | -10
Remediation Costs (60% Other) / Overhaul Accrual |  | 0 | 0 | 519 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Finance & Accounting
Variable Pay, Annual Incentive and PBA |  | 456
Severance and Relocation Amortization |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
O.I. Amortization | Link D.T. | 46 | 46 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Other (40% Other) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Functional vs. Entity Actual Variance |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Information Technology (Formerly Systems) |  |  |  |  |  |  |  | 1100 | 1000 | 1300 | 1200 | 1100 | 1400
Management Overview ("Stretch" Adjustment) |  | 0 | 0
Miscellaneous General & Administrative
Item 1 |  | 0 | 0 | 0 | 0 | 0
Item 2
Reorg. Incremental Factor (Restated vs. [NAME]) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Direct Costs
ETS Allocations
Legal |  |  |  |  |  |  |  | 200 | 200 | 200 | 200 | 100 | 200
Human Resources |  |  |  | 128 |  |  |  | 100 | 100 | 100 | 0 | 100 | 0
Executive & Other |  |  |  |  |  |  |  | 0 | 0 | -200 | 0 | 0 | 100
Executive (Co. 366)
Operations (Co. 1202)
Other ("Stretch" Adjustment)
Hyperion Timing Entry / Reversal
Total ETS Allocations
Corporate Direct & Allocated
Corporate Direct and Allocated
Other
Hyperion Timing / Reversal
Total Corporate Direct & Allocated
Total GPG / Corporate Allocation
TOTAL O&M EXPENSE
TOTAL RESTATED PLAN O&M EXPENSE |  | 14171 | 13745 | 11573 | 14768 | 14307 | 12558 | 15242 | 14376 | 11959 | 15122 | 14378 | 12949
CURRENT vs. RESTATED PLAN O&M VARIANCE
 |  | 12956 | 12697 | 18141 | 11575 | 12385 | 13491
Spreadsheet: 709950d1608638926-take-sort-data-from-a-table-and-place-it-into-a-cell-on-another-sheet-shift-schedule-test
Sheet: Sheet1

 | Employee Name | Employee  # | Shift | Job |  | Grave | Grave Supervisor
 | Employee 1 | 1234 | Grave | Grave Supervisor |  | Day | Day Supervisor
 | Employee 2 | 5678 | Day | Day Supervisor |  | Swing | Swing Supervisor
 | Employee 3 | 9012 | Swing | Swing Supervisor |  |  | Grave Assistant
 | Employee 4 | 3456 | Grave | Grave Assistant |  |  | Day Assistant
 | Employee 5 | 7890 | Grave | Grave Employee 1 |  |  | Swing Assistant
 |  |  |  |  |  |  | Grave Employee 1
 |  |  |  |  |  |  | Swing Eployee 1
 | Grave Shift |  | Emp # |  |  |  | Day Employee 1
 | Supervisor | EMP #1  here | Their #
 | Assistant | EMP #4 here | Their #
 | Employee | EMP #5 here | Their #
 | Day Shift |  | Emp#
 | Supervisor | EMP #2 here | Their #
 | Swing Shift |  | Emp #
 | Supervisor | EMP #3 here | Their #
Spreadsheet: 542411d1507839823-showing-sales-trend-in-pivot-table-sk_showing-sales-trend-in-pivot-table
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Item | 2017 | 2016 | [NAME]
 |  |  |  |  |  | Chair | 41.34 | 25.26 |  |  | Item | 2017 | 2016 | Sum of Differece
 |  |  |  |  |  | Table | 25.5 | 20 |  |  | Chair | 41.34 | 25.26 | 0.6365795724465558
 |  |  |  |  |  |  |  |  |  |  | Table | 25.5 | 20 | 0.275
 |  |  |  |  |  |  |  |  |  |  | Grand Total |  |  | 0.9115795724465559
Spreadsheet: 843738d1695563355-add-up-from-different-tabels-using-vlookup-xojakob-bsb-
Sheet: Sheet1

tbl1 Nr.1 |  |  | tbl Nr.2 |  |  | tbl Nr.3 |  |  | tbl Nr.4 |  |  | tbl Nr.5
Place | Participant |  | Place | Participant |  | Place | Participant |  | Place | Participant |  | Place | Participant
1 | [NAME] |  | 1 | [NAME] |  | 1 | Rebecca |  | 1 | [NAME] |  | 1 | [NAME]
2 | [NAME] |  | 2 | Rebecca |  | 2 | [NAME] |  | 2 | Rebecca |  | 2 | [NAME]
3 | Rebecca |  | 3 | Maja |  | 3 | Mark |  | 3 | Maja |  | 3 | Rebecca
4 | Maja |  | 4 | Mark |  | 4 | Maja |  | 4 | Mark |  | 4 | Maja
 | [NAME]
 | Maja
 | [NAME]
 | Rebecca
Spreadsheet: 55182d1255353070-how-to-automatically-alter-formula-when-filters-are-applied-malchemist-2
Sheet: 31576

Date of Order | Date of Order | Year Of Order | Month Of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20090403 | 2009-04-03 | 2009 | 4 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 93.75 | 134360 | 31576
20090403 | 2009-04-03 | 2009 | 4 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.5199999999999 | 134360 | 31576
20090403 | 2009-04-03 | 2009 | 4 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 134360 | 31576
20090403 | 2009-04-03 | 2009 | 4 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 134360 | 31576
Spreadsheet: 816541d1675690921-sum-non-zero-values-in-a-column-with-criteria-book1fdsfdsfdsfdsfdsfds
Sheet: Sheet1

2022-12-01 00:00:00 |  | date | amount |  | change
 |  | 2022-01-01 00:00:00 | 0 | 100 | 50
 |  | 2022-02-01 00:00:00 | 0 | 100 | 448
 |  | 2022-03-01 00:00:00 | 0 | 100 | 50
 |  | 2022-04-01 00:00:00 | 0 | 100 | 448
 |  | 2022-05-01 00:00:00 | 100 | 100 | 448
 |  | 2022-06-01 00:00:00 | 0 | 600 | 448
 |  | 2022-07-01 00:00:00 | 0 | 600 | 448
 |  | 2022-08-01 00:00:00 | 500 | 600 | 448
 |  | 2022-09-01 00:00:00 | 0 | 605 | 448
 |  | 2022-10-01 00:00:00 | 0 | 605 | 448
 |  | 2022-11-01 00:00:00 | 5 | 605 | 448
 |  | 2022-12-01 00:00:00 | 70 | 448 | 448
 |  | 2023-01-01 00:00:00 | 707 | 448 | 448
 |  | 2023-02-01 00:00:00 | 0 | 448 | 448
 |  | 2023-03-01 00:00:00 | 0 | 448 | 448
 |  | 2023-04-01 00:00:00 | 0 | 448 | 448
 |  | 2023-05-01 00:00:00 | 85 | 448 | 448
 |  | 2023-06-01 00:00:00 | 0 | 448 | 448
 |  | 2023-07-01 00:00:00 | 0 | 448 | 448
 |  | 2023-08-01 00:00:00 | 0 | 448 | 448
Spreadsheet: 888489d1738975066-adjusting-a-maxifs-to-second-largest-date-found-observation-tracking-sample-02
Sheet: FIN

FINANCE | OBSERVATION STATUS | PREVIOUS OBSERVATION | PREVIOUS TALLY | LAST OBSERVATION | LAST TALLY | NOTES
Employee #01
Employee #02
Employee #03
Employee #04
Employee #05
Employee #06
Employee #07
Employee #08
Spreadsheet: 266455d1379617698-sum-of-cells-with-same-value-help_please
Sheet: Blad1

Node name | Number of files | Physical space occupied (MB)
Node1 | 178 | 3,175.59 | Sum of C2:C4
Node1 | 10.688 | 64,171.12
Node1 | 674 | 1,780.28
Node2 | 19 | 20,783.10 | Sum of C5:C6
Node2 | 52 | 31,877.63
Node3 | 276.56 | 45,494.48 | Sum of C7:C8
Node3 | 26.335 | 6,360.23
Node4 | 2.179 | 699.75 | Sum of C9:C11
Node4 | 9.982 | 2,777.33
Node4 | 60.075 | 10,347.00
Spreadsheet: 820857d1678310236-find-exact-match-in-string-array-example_2
Sheet: Sheet1

To find | Code | Name | Check |  | [NAME] | Code | Name
7523M |  |  |  |  | =--ISNUMBER(MATCH(LEFT(TRIM([@[To find]]),255),TEXTSPLIT(TRIM([@Name]),," "),0)) | 17 | * 046300 VIS INOX A2 4,8 X 38 (200P)
7523L |  |  |  |  |  | 21 | * SEUIL DINAC 3M REF 207500
5535 |  |  |  |  | Result : | 19 | **obsolete**4X48,5ML KUNSTSTOFF-REPARATURMATERIAL 05901NEW DOPPELKARTUSCHEN-SET
2890S |  |  |  |  | 1 : TRUE | 23 | 2135 FILTRE P3 CATON DE 6 PAIRES
289A |  |  |  |  | 0 : FALSE | 10 | 3M 26034 PPS SERIES 2.0 ADAPTER,TYPE S-4
65170 |  |  |  |  |  | 20 | 3M 734 SCHUURPAPIER 25ST P240 01979
1639 |  |  |  |  | as a result, TRUE and FALSE are requested instead of 1 and 0 | 5 | 3M ACETAT AUSTAUSCHSCHEIBEN 289A
972 |  |  |  |  | delete the double dash (--) in front of the formula. | 30 | 3M BOLZEN DRUCKSCHLAUCH HOCHLEISTUNGSPISTOLE 26834
34240 |  |  |  |  |  | 33 | 3M CUBITRON II FEILENBAND 36+ 13 MM X 520 MM 33443
26034 |  |  |  |  |  | 34 | 3M CUBITRON II FEILENBAND 60+ 13 MM X 520 MM 33445
52025 |  |  |  |  |  | 11 | 3M CUBITRON II HOOKIT STREIFEN 737U 80X400MM 52025 P 400
8878 |  |  |  |  |  | 6 | 3M CUBITRON II [NAME], 76mm x 1mm x 8mm, PN65170
26811 |  |  |  |  |  | 32 | 3M CUBITRON II TRENNSCHEIBE 75 X 1,6 X 9,53 MM 33455
26814 |  |  |  |  |  | 28 | 3M DRUCKSCHLAUCH FÜR HOCHLEISTUNGSPISTOLE 26833
26818 |  |  |  |  |  | 31 | 3M ERSATZVISIER 5F-11
64698 |  |  |  |  |  | 3 | 3M FINISH-KONTROLSPRAY 55535
INOX |  |  |  |  |  | 18 | 3M HIGH PERFORMANCE CLOTH BLUE 02010HLBU
2010 |  |  |  |  |  | 13 | 3M HOCHLEISTUNGSDUESENKOPF HVLP 1,1 MM GELB 26811
5901NEW |  |  |  |  |  | 14 | 3M HOCHLEISTUNGSDUESENKOPF HVLP 1,4 MM ORANGE 26814
79 |  |  |  |  |  | 15 | 3M HOCHLEISTUNGSDUESENKOPF HVLP 1,8 MM TRANSPARENT 26818
750 |  |  |  |  |  | 27 | 3M HOCHLEISTUNGSLACKIERPISTOLE 26832
RET |  |  |  |  |  | 26 | 3M HOCHLEISTUNGSLACKIERPISTOLEN SYSTEM FLIESSBECHER 26778
 |  |  |  |  |  | 25 | 3M HOCHLEISTUNGSLACKIERPISTOLEN-SYSTEM INDUSTRIE 26878
 |  |  |  |  |  | 29 | 3M KUGELHAHN FÜR HOCHLEISTUNGSPISTOLE 26839
 |  |  |  |  |  | 9 | 3M Plastlagningslim 50 ml, 6 st/fp, 34240A
 |  |  |  |  |  | 7 | 3M PPS COLOR CORRECTIVE BULB 16399
 |  |  |  |  |  | 4 | 3M PREMIUM FULL VISION GLASSES 2890SA
 |  |  |  |  |  | 24 | 3M QUICK CONNECT PERFECT-IT III POLIERSCHAUM 150 MM LILA 33034
 |  |  |  |  |  | 16 | 3M SCOTCH BRITE VLIESBAND A CRS 13X457MM 64698
 |  |  |  |  |  | 2 | 3M STARTPAKET L A2/P3 (ers 06783) 7523LF
 |  |  |  |  |  | 1 | 3M STARTPAKET M 7523MF ERSÄTTER 06782
 |  |  |  |  |  | 12 | 3M STEINSCHLAGSCHUTZ WEIS.8878
 |  |  |  |  |  | 8 | FESTO FILTERSACK FUER CT 44 452972 3M 202616
 |  |  |  |  |  | 22 | LUNETTES SECURET FIT 400 GRISE VERSION SOLAIRE
Spreadsheet: 266978d1379885709-vlookup-for-finding-value-that-may-only-appear-on-one-of-seven-worksheets-supplier-pricing-sept-2013
Sheet: Weston 15796

 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year:
 |  |  |  |  |  |  |  | 15796
 |  |  |  | Vendor:
 |  |  |  | Calendar: |  |  |  | D |  |  |  |  |  |  |  |  |  | Period:
 |  |  |  | Date From: |  |  |  | 9/1/2013 |  |  |  | Date To: |  | 9/27/2013 |  |  |  | Week:
 |  |  |  | Item No.: |  |  |  |  |  |  |  | Item Description:
 |  |  |  | Reporting Level: |  |  |  | UnitNm
 |  |  |  | Reporting Entities: |  |  |  | 23143
 |  |  | Unit Name: VICTORIA HOSPITAL - FAYES - 23143
 |  |  | Row # |  | Item No. | Item Desc. |  |  |  |  |  |  |  |  | Brand |  | Pack Size |  | UOM |  |  | Item Price | Qty. Received | Total Item Amount |  |  | Vendor
 |  |  | 1 |  | 1975 | Food Service Texas White Sandwich Bread |  |  |  |  |  |  |  |  | Weston |  |  |  |  |  |  | 1.4 | 50 | 70 |  |  | WESTONS' BAKERIES
 |  |  | 2 |  | 1976 | Food Service Texas 100% W.W. Sandwich Bread |  |  |  |  |  |  |  |  | Weston |  |  |  |  |  |  | 1.4 | 50 | 70 |  |  | WESTONS' BAKERIES
 |  |  | 3 |  | 2002 | SAUSAGE BUN |  |  |  |  |  |  |  |  | DItaliano |  |  |  |  |  |  | 2.28 | 18 | 41.04 |  |  | WESTONS' BAKERIES
 |  |  | 4 |  | 2649 | CORNMEAL KAISER BUNS |  |  |  |  |  |  |  |  | WESTON |  | 1 |  | EA |  |  | 1.86 | 102 | 189.72 |  |  | WESTONS' BAKERIES
 |  |  | 5 |  | 758 | Country Harvest 12-Grain |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 1.95 | 40 | 78 |  |  | WESTONS' BAKERIES
Spreadsheet: 777805d1650625918-creating-lookup-formula-using-3-drop-down-selections-kalkulator_pompy
Sheet: Oferta POMPA

 |  |  |  |  |  |  |  |  |  |  |  | Szczegółowe zestawienie kosztów oraz komponentów pompy ciepła
 |  |  |  |  |  |  |  |  |  |  |  | PODSTAWOWE DANE
 |  |  |  |  |  |  |  |  |  |  |  | Moc pompy |  |  |  |  |  | kW
 |  |  |  |  |  |  |  |  |  |  |  | Klasa energetyczna
 |  |  |  |  |  |  |  |  |  |  |  | Prognozowane zużycie |  |  |  |  |  | kWh
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] pompy |  |  | [NAME]/woda
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] urządzenia
 |  |  |  |  |  |  |  |  |  |  |  | PODSTAWOWE DANE O POMPIE
 |  |  |  |  |  |  |  |  |  |  |  | Producent
 |  |  |  |  |  |  |  |  |  |  |  | Gwarancja
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] faz |  |  |  |  |  | faza
 |  |  |  |  |  |  |  |  |  |  |  | Czynnik chłodniczy
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] grzałek |  |  |  |  |  | kW
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Pojemność |  |  |  |  | Pojemność
 |  |  |  |  |  |  |  |  |  |  |  | OFERTA ZAWIERA
 |  |  |  |  |  |  |  |  |  |  |  | Sys. [NAME] |  |  | TAK
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | TAK
 |  |  |  |  |  |  |  |  |  |  |  | Demontaż istniejącego źrodła |  |  | TAK
 |  |  |  |  |  |  |  |  |  |  |  | Separatory/Termostat/Czujniki |  |  | TAK
 |  |  |  |  |  |  |  |  |  |  |  | Orurowanie/Zawory/Śrubunki |  |  | TAK
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] i uruchomienie |  |  | TAK
 |  |  |  |  |  |  |  |  |  |  |  | Suma [NAME] |  |  |  |  |  | [NAME] [NAME] rozwiązania [NAME] się z podzespołów o wysokiej [NAME] trwałości.
 |  |  |  |  |  |  |  |  |  |  |  | Podatek VAT |  |  | 0.08
 |  |  |  |  |  |  |  |  |  |  |  | Suma [NAME]