tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139768d1328455918-excel-2007-totalling-selected-cells-cabbie
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Quarter | 1 | change this cell to the quarter you want.
 |  |  |  |  |  |  |  |  |  |  | Total Bookings
 |  | Year | Quarter | Month | Week | Day | Date | Bookings
 |  |  |  |  |  |  | 2012-02-27 00:00:00 | 847.25
 |  |  |  |  |  |  |  | 125
 |  |  |  |  |  |  |  | 795
 |  |  |  |  |  |  |  | 321
 |  |  |  |  |  |  |  | 852
 |  |  |  |  |  |  |  | 654
 |  |  |  |  |  |  |  | 123
 |  |  |  |  |  |  |  | 456
 |  |  |  |  |  |  |  | 321
 |  |  |  |  |  |  |  | 123
 |  |  |  |  |  |  |  | 753
 |  |  |  |  |  |  |  | 951
 |  |  |  |  |  |  |  | 958
 |  |  |  |  |  |  | 2012-04-01 00:00:00 | 758
 |  |  |  |  |  |  |  | 256
 |  |  |  |  |  |  |  | 254
 |  |  |  |  |  |  | 2012-05-01 00:00:00 | 3214
 |  |  |  |  |  |  |  | 265
 |  |  |  |  |  |  |  | 445
 |  |  |  |  |  |  | 2012-07-01 00:00:00 | 665
 |  |  |  |  |  |  |  | 226
 |  |  |  |  |  |  |  | 224
 |  |  |  |  |  |  |  | 885
 |  |  |  |  |  |  |  | 774
 |  |  |  |  |  |  |  | 745
 |  |  |  |  |  |  |  | 965
Spreadsheet: 864213d1711469680-how-do-i-find-the-sum-total-amount-products-dj
Sheet: Book1

Product | Apple |  | Orange |  | [NAME] |  | [NAME] |  | QTD | SUBTOTAL
Price | 20000 |  | 40000 |  | 80000 |  | 50000
[NAME] |  |  |  |  | 1 | 2024-03-26 00:00:00
[NAME] | 2 | 2024-03-26 00:00:00 | 10 | 2024-03-26 00:00:00 |  |  |  |  | 12 | 440000
George | 5 | 2024-03-26 00:00:00 | 8 | 2024-03-26 00:00:00 |  |  | 25 | 2024-03-26 00:00:00 | 38 | 1670000
Spreadsheet: 880610d1728422796-transform-output-file-into-usable-data-layout-cjshoe2
Sheet: format_needed

ITEM | COST UM | LIST | UM | STANDARD | WALK IN | GOOD | BETTER | MGR APPRV | UM2 | BASIS | WMUL | GMUL | BMUL | MMUL
[NAME] | 329.170 EA | 638.18 | EA | 638.18 | 457.55 | 421.34 | 391.71 | 365.38 | EA | MC | 1.39 | 1.28 | 1.19 | 1.11
JNK15A-8PDCS/DVS DU | 843.400 EA | 1686.8 | EA | 1686.8 | 1172.33 | 1062.68 | 1003.65 | 936.17 | EA | MC | 1.39 | 1.26 | 1.19 | 1.11
JNK15E-8P-DCS-DVS-DU | 1406.380 EA | 2519.58 | EA | 2519.58 | 1954.87 | 1757.98 | 1645.46 | 1561.08 | EA | MC | 1.39 | 1.25 | 1.17 | 1.11
[NAME] | 1357.540 EA | 2459.03 | EA | 2459.03 | 1886.98 | 1696.93 | 1615.47 | 1506.87 | EA | MC | 1.39 | 1.25 | 1.19 | 1.11
Spreadsheet: 232829d1367529824-list-of-names-that-needs-to-be-identical-and-updated-in-different-tables-across-sheets-example-spreadsheet
Sheet: Table 3

 |  |  | Product Name | tier | owner | problems
 |  |  | Product1 | 56 | words | fill
 |  |  | Product2 | 4 | text | filler
 |  |  | Product3 | 6 | stuff | just
 |  |  | Product4 | 3 | more stuff | filling
 |  |  | Product5 | 367 | things | in
 |  |  | Product6 | 36 | stuff | the
 |  |  | Product7 | 78 | text | space
 |  |  | Product8 | 568 | words | to
 |  |  | Product9 | 64 | [NAME] | have
 |  |  | Product10 | 35 | blahbla | info
 |  |  | Product11 | 356 | des | in
 |  |  | Product12 | 68 | you | each
 |  |  | Product13 | 57 | get | row
 |  |  | Product14 | 46 | the | and
 |  |  | Product15 | 25 | point | sort
Spreadsheet: 229317d1366366931-dependent-drop-down-lists-based-on-dynamic-data-range-book2
Sheet: Data

Year | Quarter | Month | dReceievedDate | Source | OrderItemSKU | Brand | OrderItemQuantity
 | Q1 |  | 2013-02-13 00:00:00 | AZN | SDS-1941-Black | SDS | 2
 | Q1 |  | 2013-02-14 20:26:16 | AZN | SDS-1941-Black | SDS | 3
 | Q1 |  | 2013-02-15 16:20:51 | AZN | MLPD-200-Black-XXL | Belts | 1
 | Q4 |  | 2013-12-13 13:00:47 | AZN | SST-Insoles-11 | SST | 2
Spreadsheet: 270560d1381522948-list-dates-that-correspond-to-employee-id-numbers-from-a-different-sheet-example4-oeldere-
Sheet: Sheet1

date | choise
2013-08-15 00:00:00 | 31
2013-08-15 00:00:00 | 32
2013-08-15 00:00:00 | 33
2013-08-15 00:00:00 | 33
2013-08-15 00:00:00 | 8
2013-08-15 00:00:00 | 8
2013-08-15 00:00:00 | 8
2013-08-15 00:00:00 | 7
2013-08-15 00:00:00 | 31
2013-08-15 00:00:00 | 32
2013-08-15 00:00:00 | 31
2013-08-22 00:00:00 | 8
2013-08-22 00:00:00 | 8
2013-08-22 00:00:00 | 31
2013-08-22 00:00:00 | 33
2013-08-22 00:00:00 | 32
2013-08-22 00:00:00 | 8
2013-08-30 00:00:00 | 31
2013-08-30 00:00:00 | 32
2013-08-30 00:00:00 | 33
2013-08-30 00:00:00 | 7
2013-08-30 00:00:00 | 8
2013-08-30 00:00:00 | 8
Spreadsheet: 34259d1231421485-xl-charting-problem-667726
Sheet: example chart

Minor accidents
2004/2005 | August | 2
 | September | 2
 | October | 5
 | November | 1
 | December | 4
 | January | 0
 | February | 2
 | March | 2
 | April | 0
 | May | 4
 | June | 1
 | July | 5
2005/2006 | August | 3
 | September | 1
 | October | 3
 | November | 2
 | December | 2
 | January | 1
 | February | 2
 | March | 3
 | April | 0
 | May | 2
 | June | 1
 | July | 4
2006/2007 | August | 0
 | September | 4
 | October | 1
 | November | 1
 | December | 2
 | January | 0
 | February | 0
 | March | 2
 | April | 3
 | May | 1
 | June | 3
 | July | 0
2007/2008 | August | 1
 | September | 4
 | October | 1
 | November | 1
 | December | 3
 | January | 2
 | February | 6
 | March | 0
 | April | 0
 | May | 1
 | June | 2
 | July | 2
2008/2009 | August | 0
 | September | 1
 | October | 0
 | November | 3
 | December | 0
 | January
 | February
 | March
 | April
 | May
 | June
 | July
2009/2010 | August
 | September
 | October
 | November
 | December
 | January
 | February
 | March
 | April
 | May
 | June
 | July
Spreadsheet: 545488d1509494006-final-salary-to-show-in-a-different-cell-final-payout-to-be-placed-in-a-different-sheet
Sheet: Final Payout

name | final payout | Tier
[NAME] | 417.11 | Tier 9
Ringo | 434.78 | Tier 9 |  | PREFERRED RESULTS:
[NAME] | 413.94 | Tier 9 |  | The Column B2 in the Final Payout sheet would  get the value from the [NAME] sheet Column I18.
George | 415.36 | Tier 9 |  | The [NAME] sheet computes the salary of each employee after the user types its name in Salary sheet Column C1
[NAME] |  |  |  | After the user sees the final payout, [NAME] sheet I18, the user would manually type it in Final Payout sheet  Column B2.
Stuart |  |  |  | Is there a way to do this using formula without manually typing the final salary of each emloyee since it would be in hundreds?
[NAME]
 |  |  |  | Then is should also write the Tier  as well to Column C2 coming from Final Payout H21, H22.
Spreadsheet: 214913d1361188940-need-help-with-populating-worksheet-with-rows-from-other-sheet-based-on-criteria-2013-pinto-schedule-1-
Sheet: A's

 |  |  | A's |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Field | Date | Day | Start Time | Away | AC | HC | Home
Field | Date | Day | Start Time | Away | AC | HC | Home |  | Code | Team | Manager | # of Away | # of Home | Total | vs. A's | Cubs | Dodgers | Phillies | Pirates | Tigers | Yankess
 |  |  |  |  |  |  |  |  | 1 | A's | Hinds |  |  |  | X
 |  |  |  |  |  |  |  |  | 2 | Cubs | Okmin |  |  |  |  | X
 |  |  |  |  |  |  |  |  | 3 | Dodgers | Manheim |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  | 4 | Phillies | [NAME] |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  | 5 | Pirates | Myers |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  | 6 | Tigers | Grakal |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  | 7 | Yankees | Mitchell |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  | On the right side yellow  column X to AG
 |  |  |  |  |  |  |  |  | column AF that the number pick up from Pinto sheet =IFERROR(MATCH($D$1&"_"&ROWS(AF$2:AF2),Pinto!J:[NAME]:AF2),Pinto!K:K,0),""))
 |  |  |  |  |  |  |  |  | Cell D1 need a name team in order [NAME] and row pick up from Pinto sheet
 |  |  |  |  |  |  |  |  | And last thing on the left side column A to H is close the gap from column X to AG pick up column AG.
 |  |  |  |  |  |  |  |  | Column M3:N9
 |  |  |  |  |  |  |  |  | I use this =SUMPRODUCT(($E$3:$E$30=$K3)*ISNUMBER($F$3:$F$30)) column M. Column N is this =SUMPRODUCT(($H$3:$H$30=$K3)*ISNUMBER($G$3:$G$30))
 |  |  |  |  |  |  |  |  | Cheer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hide Them
Spreadsheet: 541296d1507211946-need-something-to-find-duplicates-across-sheets-inventory-accuracy-template
Sheet: US Compliant SC's

Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operation Count Delta | Status | Location Type | Last Wall To Wall
 |  |  | US Totals
Spreadsheet: 47386d1246424501-finding-unique-records-ef0701a
Sheet: Sheet1

 |  |  | Name | Value | Is First Row
 |  |  | ABC | 10 | 1
 |  |  | CDEE | 11 | 1
 |  |  | ABC | 12 | 0
 |  |  | DEFFF | 13 | 1
 |  |  | BATTTT | 14 | 1
 |  |  | CDEE | 15 | 0
 |  |  | DEFFF | 16 | 0
Spreadsheet: 742228d1627601354-formulas-not-remaining-with-correct-rows-after-sort-sample
Sheet: Cycle Time

 | CLICKING THE BUTTON ABOVE RUNS A MACRO TO REFRESH THE DATA |  |  |  |  |  |  |  |  | Hover over column headers to see additional information about the data in the cells in the each column
 | DEPARTMENT YTD TOTALS / AVERAGES |  |  |  |  | TOTAL |  |  |  | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL | AVG | AVG | AVG | TOTAL | TOTAL | TOTAL | TOTAL |  |  |  | TOTAL | TOTAL | TOTAL | TOTAL
 |  |  |  |  | YTD Total # of Deployments
 | Primary County | Primary State | Primary Cat Code Being Handled | Primary Loss Type Being Handled | Claim Rep | Supervisor | 1st Day Claims Rec'd | (Arrive) 1st Work Day | ([NAME]) 1st Travel Day | Meeting, Training, Travel, PTO, Off Days During Tour | Count of Days                   Able to Inspect | Days Onsite to Date | Days Remaining Onsite | Count of Received | Count of Contacted | Count of Inspected | Count of Returned | Average Days to Contact | Average Days to Inspect | Average Days to Return | Contacted %                            of Received | Inspected %                                  of Received | Returned %                              of Inspected | Returned %                              of Received | Date of First Assignments Received | Date of First  Contact | Date of First Inspection | Count of Estimated                             Onsite | % of Claims                           Estimated Onsite | Count of Paid                             Onsite | % of Claims                                Paid Onsite | NOTES
1
2
3
4
5
6
Spreadsheet: 709420d1608298991-check-for-non-consecutive-duplicates-book1
Sheet: Sheet1

1
2
3
3
3
6
7
8
3
10
11
11
11
14
15
16
17
18
19
20
21
Spreadsheet: 678601d1589976906-find-date-end-for-unique-value-example
Sheet: Arkusz1

Name | Value | Date_start | Date_end
Name1 | Value1 | 2020-05-01
Name1 | Value1 | 2020-05-02 |  | <-- when date_end was found then leave it empty
Name1 |  | 2020-05-03
Name1 | Value1 | 2020-05-04
Name1 |  | 2020-05-05
Name1 | Value2 | 2020-05-06
Name1 |  | 2020-05-07
Name1 | Value2 | 2020-05-08
Name1 | Value2 | 2020-05-09
[NAME] | Value1 | 2020-05-01
[NAME] | Value1 | 2020-05-02
[NAME] | Value1 | 2020-05-03
[NAME] | Value1 | 2020-05-04
[NAME] | Value1 | 2020-05-05
[NAME] |  | 2020-05-06
[NAME] |  | 2020-05-07
[NAME] |  | 2020-05-08
[NAME] | Value2 | 2020-05-09
Name3 | Value1 | 2020-05-01
Name3 | Value1 | 2020-05-02
Name3 | Value1 | 2020-05-03
Name3 | Value3 | 2020-05-04
Name3 | Value3 | 2020-05-05
Name3 |  | 2020-05-06
Name3 |  | 2020-05-07
Name3 |  | 2020-05-08
Name3 |  | 2020-05-09
Spreadsheet: 695766d1600381936-set-kpi-for-my-import-and-export-shipment-tracker-kpi-1-neha20-
Sheet: Sheet1

Sl. No. | Job No. | Customer | Import/Export | Mode of Shipment | Country | Order confirmation date | BRN/ Cntr release from port | Vessel Departure Date | Vessel [NAME] date | Documents sent to WSS | Check (ED) - HIDE THIS COLUMN | ED received from WSS | COLUMN TO BE HIDDEN | [NAME] to Port | BL from Liner | Docs uploaded in V-motion | Invoiced Date | No. of Units Damaged | Remarks/ Comments | STATUS
1 |  | AMS | EXPORT | SEA | MOM/DAR/DUR | 2020-08-25 00:00:00 | 2020-08-31 00:00:00 | 2020-09-16 00:00:00 | - | 2020-09-18 00:00:00 |  | 2020-09-14 00:00:00 |  | 2020-09-03 00:00:00 | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-14 00:00:00 |  |  | Completed
2 |  | AMS | IMPORT | SEA | JAPAN | NA | NA | 2020-09-14 00:00:00 | 2020-08-28 00:00:00 | 2020-08-24 00:00:00 |  | 2020-08-31 00:00:00 |  | 2020-09-05 00:00:00 | NA | 2020-09-14 00:00:00 | 2020-09-14 00:00:00 |  |  | Completed
3
Spreadsheet: 807644d1669981743-is-there-a-fortnight-formula-like-eomonth-loan-amortisation-schedule1
Sheet: Loan Schedule

 |  | Loan Amortisation Schedule
 | Enter Values |  |  |  |  | Loan Summary
 | Loan amount |  |  | 5000 |  | Scheduled payment
 | Annual interest rate |  |  | 0.04 |  | Scheduled number of payments
 | Loan period in years |  |  | 1 |  | Actual number of payments
 | Number of payments per year |  |  | 12 |  | Total early payments
 | Start date of loan |  |  |  |  | Total interest
 | Optional extra payments |  |  | 100 |  | Lender name |  | Woodgrove Bank
 | Payment Number | Payment Date | Beginning Balance | Scheduled Payment | Extra Payment | Total Payment | Principal | Interest | Ending Balance | Cumulative Interest
Spreadsheet: 95ea1fd4-3d8a-4fe0-aa6b-778a1b045b7c
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
 | Time Series Workbook
 | 6345.0 Labour Price Index, Australia
 | Table 4b. Total Hourly Rates of Pay Excluding Bonuses: Public Sector by State, Original (Quarterly Index Numbers)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  New South Wales ;  Public ;  All industries ; |  |  | Original | A2599999R | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Victoria ;  Public ;  All industries ; |  |  | Original | A2609309R | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Queensland ;  Public ;  All industries ; |  |  | Original | A2601329C | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  South Australia ;  Public ;  All industries ; |  |  | Original | A2610639C | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Western Australia ;  Public ;  All industries ; |  |  | Original | A2607979R | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Tasmania ;  Public ;  All industries ; |  |  | Original | A2602659L | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Northern Territory ;  Public ;  All industries ; |  |  | Original | A2606649F | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  Public ;  All industries ; |  |  | Original | A2605319W | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Public ;  All industries ; |  |  | Original | A2603989W | 1997-09-01 00:00:00 | 2011-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 773367d1647826677-find-string-and-prefix-zero-for-0-9-sample_data
Sheet: Sheet1

Summary | [NAME] | [NAME] | [NAME] | [NAME]
Site: TN | Node Outage | [NAME]
Site: TN | Node Outage | C1N16
Site: BGL | [NAME] | C1N02
Site: BGL| Node outage | C2M1N03
Site: TEL | [NAME] | C02N09
Site: AP | [NAME] | C01N04
Site: BGL | [NAME] | C02N04
Site: SDGE Escondido 3 | [NAME] | C01M02N01
Spreadsheet: vkaminski__40982__CapitalTemplate1
Sheet: Summary

 | Totals
 |  |  |  |  |  |  |  |  | Total |  | Physical Deals |  |  | Financial Deals
 | Counterparty | Total Notional | Net Open Position | Total Physical Notional | Total Physical Net Open Position | Total Financial Notional | Total Financial Net Open Position | P&L for Price Move | Collateral Posted by Us for Price Move | P&L for Price Move | Collateral Posted by Us for Price Move | Collateral Posted to Us for Price Move | P&L for Price Move | Collateral Posted by Us for Price Move | Collateral Posted to Us for Price Move
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 89146d1288894543-vlookup-2-sheets-and-return-values-in-rows-vlookup-3-sheets
Sheet: Sheet2

 |  |  |  |  | LOOKUP TABLE | VALUES TO RETURN TO SHEET 1
 |  |  |  |  | R1 | A | A1 | A2
 |  |  |  |  | R2 | B | B1 | B2
 |  |  |  |  | R3 | C | C1 | C2
 |  |  |  |  | R4 | D | D1 | D2
 |  |  |  |  | R5 | E | E1 | E2
 |  |  |  |  | R6 | F | F1 | F2
 |  |  |  |  | R7 | G | [NAME] | G2
 |  |  |  |  | R8 | H | H1 | H2
 |  |  |  |  | R9 | I | I1 | I2
 |  |  |  |  | R10 | J | J1 | J2
Spreadsheet: 70fd369d-ec39-46ba-b589-9b2f0ef98302
Sheet: Sheet1

KULBA Hartwachsöl | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Leistungsverzeichnis
KULBA Hartwachsöl ist ein wasserabweisendes, aber wasserdampfdurchlässiges Holzwachs für den [NAME] auf Basis von Carnauba- und [NAME] mit [NAME]. Es ist offenporig und verfügt über ein sehr gutes Eindringvermögen. KULBA Hartwachsöl ist unempfindlich gegen Bier, Fruchtsäfte und [NAME].
Position | Menge | Leistung |  |  | Einheits- | [NAME]
 | Einheit |  |  |  | preis | preis
1 | m² | Oberflächenvorbehandlung:
 |  | [NAME] muss vor [NAME] der [NAME] trocken,
 |  | sauber und tragfähig sein. Vorarbeiten unter
 |  | Beachtung der VOB, [NAME], DIN 18363, Abschnitt 3,
 |  | [NAME].
 |  | [NAME], Dickschichtsysteme, alle porenschließenden
 |  | Altanstriche durch abschleifen oder abbeizen
 |  | vollständig entfernen.
2 | m² | Oberflächenbehandlung:
 |  | [NAME]: ___________
 |  | KULBA Hartwachsöl wird in der [NAME] bis zur
 |  | vollständigen Sättigung des Holzes mit dem [NAME]
 |  | oder im [NAME] auftragen.
 |  | Nach ca. 5 bis 10 Minuten das überschüssige
 |  | KULBA Hartwachsöl mit einem Lappen abnehmen.
 |  | Nach 10 Minuten mit einem Lappen oder Polierfilz
 |  | aufpolieren.
 |  | Eine mehrmalige Anwendung ergibt einen intensiveren [NAME].
 |  | Wirkt auf verschiedenen [NAME] (Holzinhaltsstoffe), daher ist eine Musterfläche erforderlich.
 |  | Verbrauch
 |  | Je nach Rauheit und Saugfähigkeit der Holzoberfläche
 |  | ca. 70-100 ml/m² pro [NAME]. Bei stark saugenden,
 |  | ausgewitterten oder sehr rauhen Flächen,
 |  | Mehrbedarf berücksichtigen
 |  | [NAME] beachten!
Spreadsheet: 128755d1321261971-display-named-range-showrange
Sheet: Sheet2

q | a | a | martin1
w | s | b | [NAME]
e | d | c | martin3
r | f | d
t | g | e
y | h | f
 |  | g
 |  | h
 |  | i
 |  | j
 |  | k
 |  | l
 |  | m
Spreadsheet: 706231d1606549039-match-data-in-1-column-and-count-unique-data-in-another-column-based-on-matches-match-unique-count
Sheet: Sheet1

 |  | expected result | [NAME]
1970001295 | 910357395 | 2
1970001295 | 910357395 | 2
1970001295 | 910357396 | 2
1970001655 | 910345466 | 1
1970001655 | 910345466 | 1
1970001655 | 910345466 | 1
1970001655 | 910345466 | 1
1976001972 | 910344997 | 1
1976001972 | 910344997 | 1
1976001972 | 910344997 | 1
1978000658 | 910350447 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
1978000658 | 910350432 | 3
1978000658 | 910350433 | 3
1978000674 | 910365195 | 1
1978000674 | 910365195 | 1
1978000674 | 910365195 | 1
1978000674 | 910365195 | 1
1978000674 | 910365195 | 1
1978002213 | 910357608 | 1
1978002213 | 910357608 | 1
1978002213 | 910357608 | 1
1978002213 | 910357608 | 1
1978002213 | 910357608 | 1
1978003125 | 910352388 | 1
1978003125 | 910352388 | 1
1978003125 | 910352388 | 1
1978003331 | 910340585 | 2
1978003331 | 910340585 | 2
1978003331 | 910340585 | 2
1978003331 | 910340585 | 2
1978003331 | 910340586 | 2
1979000863 | 910360526 | 2
1979000863 | 910360526 | 2
1979000863 | 910360526 | 2
1979003592 | 910367424 | 1
1979003592 | 910367424 | 1
1979003592 | 910367424 | 1
1979003592 | 910367424 | 1
1979003592 | 910367424 | 1
1980001307 | 910358491 | 1
1980001307 | 910358491 | 1
1980001307 | 910358491 | 1
Spreadsheet: 539693d1506337063-populate-error-message-collection-schedule
Sheet: Menu

TIME | Location | Day | Desk | Duration
10:00:00 | A | 1 | 1 | 00:30:00
10:30:00 | B | 2 | 2 | 01:00:00
11:00:00 |  | 3 | 3 | 01:30:00
11:30:00 |  | 4 | 4 | 02:00:00
12:00:00 |  | 5 |  | 02:30:00
12:30:00 |  |  |  | 03:00:00
13:00:00 |  |  |  | 03:30:00
13:30:00 |  |  |  | 04:00:00
14:00:00 |  |  |  | 04:30:00
14:30:00 |  |  |  | 05:00:00
15:00:00 |  |  |  | 05:30:00
15:30:00 |  |  |  | 06:00:00
16:00:00 |  |  |  | 06:30:00
16:30:00 |  |  |  | 07:00:00
17:00:00
Spreadsheet: 96942d1296172130-please-help-condensing-spreadsheet-test-spreadsheet-1
Sheet: Sheet1

Whse | Product | Description | Entered | Vendor #
co | 9BROGT541USED | BROTHER GT-541 USED      GARMENT PRINTER | 2010-12-06 00:00:00 | 3068
or | 9BROGT541USED | BROTHER GT-541 USED      GARMENT PRINTER | 2010-11-10 00:00:00 | 3068
ca | 9BROGT782 | BROTHER GARMENT PRINTER  GT-782 DEMO UNIT | 2010-03-30 00:00:00 | 1293
co | 9BROGT782 | BROTHER GARMENT PRINTER  GT-782 DEMO UNIT | 2010-03-30 00:00:00 | 1293
mn | 9BROGT782 | BROTHER GARMENT PRINTER  GT-782 DEMO UNIT | 2010-03-30 00:00:00 | 1293
mo | 9BROGT782 | BROTHER GARMENT PRINTER  GT-782 DEMO UNIT | 2010-03-30 00:00:00 | 1293
ne | 9BROGT782 | BROTHER GARMENT PRINTER  GT-782 DEMO UNIT | 2010-03-30 00:00:00 | 1293
or | 9BROGT782 | BROTHER GARMENT PRINTER  GT-782 DEMO UNIT | 2010-03-30 00:00:00 | 1293
ut | 9BROGT782 | BROTHER GARMENT PRINTER  GT-782 DEMO UNIT | 2010-03-30 00:00:00 | 1293
wa | 9BROGT782 | BROTHER GARMENT PRINTER  GT-782 DEMO UNIT | 2010-03-30 00:00:00 | 1293
wi | 9BROGT782 | BROTHER GARMENT PRINTER  GT-782 DEMO UNIT | 2010-03-30 00:00:00 | 1293
co | 9EFIH650 | H650 4  COLOR WITH WHITE TOP LEVEL RASTEK | 2010-07-09 00:00:00 | 2360
mn | 9EFIH650 | H650 4  COLOR WITH WHITE TOP LEVEL RASTEK | 2010-07-09 00:00:00 | 2360
mo | 9EFIH650 | H650 4  COLOR WITH WHITE TOP LEVEL RASTEK | 2010-07-09 00:00:00 | 2360
ne | 9EFIH650 | H650 4  COLOR WITH WHITE TOP LEVEL RASTEK | 2010-07-09 00:00:00 | 2360
or | 9EFIH650 | H650 4  COLOR WITH WHITE TOP LEVEL RASTEK | 2010-07-09 00:00:00 | 2360
ut | 9EFIH650 | H650 4  COLOR WITH WHITE TOP LEVEL RASTEK | 2010-07-09 00:00:00 | 2360
wa | 9EFIH650 | H650 4  COLOR WITH WHITE TOP LEVEL RASTEK | 2010-07-09 00:00:00 | 2360
wi | 9EFIH650 | H650 4  COLOR WITH WHITE TOP LEVEL RASTEK | 2010-07-09 00:00:00 | 2360
ca | 9EFIH652 | H652 4  COLOR WITH WHITE TOP LEVEL RASTEK DEMO | 2010-07-30 00:00:00 | 2360
co | 9EFIH652 | H652 4  COLOR WITH WHITE TOP LEVEL RASTEK DEMO | 2010-07-30 00:00:00 | 2360
mn | 9EFIH652 | H652 4  COLOR WITH WHITE TOP LEVEL RASTEK DEMO | 2010-07-30 00:00:00 | 2360
mo | 9EFIH652 | H652 4  COLOR WITH WHITE TOP LEVEL RASTEK DEMO | 2010-07-30 00:00:00 | 2360
ne | 9EFIH652 | H652 4  COLOR WITH WHITE TOP LEVEL RASTEK DEMO | 2010-07-30 00:00:00 | 2360
or | 9EFIH652 | H652 4  COLOR WITH WHITE TOP LEVEL RASTEK DEMO | 2010-07-30 00:00:00 | 2360
ut | 9EFIH652 | H652 4  COLOR WITH WHITE TOP LEVEL RASTEK DEMO | 2010-07-30 00:00:00 | 2360
wa | 9EFIH652 | H652 4  COLOR WITH WHITE TOP LEVEL RASTEK DEMO | 2010-07-30 00:00:00 | 2360
wi | 9EFIH652 | H652 4  COLOR WITH WHITE TOP LEVEL RASTEK DEMO | 2010-07-30 00:00:00 | 2360
MN | 9EFIH700 | H700 4  COLOR WITH WHITE TOP LEVEL RASTEK | 2010-03-26 00:00:00 | 2360