tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838880d1691493484-simplifying-speeding-up-an-indirect-formula-weekly-sales-yoy-by-customer-test
Sheet: C

 |  |  |  | 2023-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | JAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUN |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEC |  |  | TOTAL YEARLY
 |  |  |  | 2022-01-03 00:00:00 | 2023-01-02 00:00:00 | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference | 2022 | 2023 | Difference
C | 1195
 |  |  | 2023-05-01 00:00:00
 |  |  | 2023-05-03 00:00:00
 |  |  | 2023-05-22 00:00:00
 |  |  | 2023-05-24 00:00:00
 |  |  | 2023-06-05 00:00:00
 |  |  | 2023-08-02 00:00:00
 |  |  | 2023-06-06 00:00:00
 |  |  | 2023-05-22 00:00:00
 |  |  | 2023-06-20 00:00:00
 |  |  | 2023-05-05 00:00:00
 |  |  | 2023-06-07 00:00:00
 |  |  | 2023-06-06 00:00:00
 |  |  | 2023-06-21 00:00:00
 | C's TOTAL
KEY
 | Sampling
 | New customer
abcd | Closed
Spreadsheet: 287707d1388951662-adding-365-text-chunks-into-a-calendar-template-_calendar_2014_week_2_demo_excel_version
Sheet: DruckWochenblatt

Leitdatum |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sprache (D/E, d/e) |  | [NAME]
2014-01-06 00:00:00 |  |  |  | <--- Hier ein Datum der anvisierten Woche einsetzen! '[NAME]' sollte genügen. |  |  |  |  |  |  |  |  |  |  |  | [NAME] einsetzen! Kleinbuchstabe wählt Kurzform! ---> |  | E |  |  | Entwicklung
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monatsnamen fehlen:
 | bis |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sprachenbereich und [NAME]
 |  |  |  | Psalm 106,4 |  | Jesaja 9,4 |  | Jesaja 42,10 |  | 3.Mose 25,14 |  | Psalm 103,13 |  | Psalm 10,1 |  | Hesekiel 39,29
 |  |  |  | HERR, gedenke meiner nach der [NAME], die du deinem [NAME] verheißen hast; erweise an uns deine Hilfe. |  | [NAME], [NAME] dahergeht, und jeder Mantel, durch [NAME] geschleift, wird [NAME] und vom Feuer verzehrt. |  | Singet dem HERRN ein neues Lied, [NAME] an den Enden der [NAME]. |  | Wenn du deinem [NAME] etwas [NAME] etwas abkaufst, [NAME] [NAME] übervorteilen. |  | [NAME] sich ein Vater über Kinder erbarmt, so erbarmt sich der [NAME] über die, die ihn fürchten. |  | HERR, warum stehst du so ferne, verbirgst dich zur Zeit der Not? |  | Ich will [NAME] nicht mehr vor ihnen verbergen; denn ich habe meinen Geist über [NAME] ausgegossen, spricht Gott der [NAME]. |  |  |  | Wort 'bis' als Festeintrag; sollte über [NAME] laufen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] im [NAME]
 |  |  |  | [NAME] |  | [NAME] |  | Lukas 1,67-68 |  | Römer 12,10 |  | 1.Johannes 4,10 |  | Johannes 11,32 |  | Apostelgeschichte 10,45 |  |  |  |  | Auswahl und [NAME] der passenden Termine
 |  |  |  | Herr, nun lässt du deinen Diener in Frieden fahren, wie du gesagt hast; denn meine Augen haben deinen Heiland gesehen. |  | So steht nun fest, umgürtet an euren [NAME] mit Wahrheit und angetan mit dem Panzer der [NAME] und an den [NAME] gestiefelt, bereit einzutreten für das Evangelium des Friedens. |  | [NAME] wurde vom [NAME] erfüllt, weissagte und sprach: [NAME] sei der [NAME], der [NAME]! Denn er hat besucht und [NAME]. |  | Liebt einander [NAME] als Brüder und Schwestern, und ehrt euch gegenseitig in zuvorkommender [NAME]. |  | Darin besteht die Liebe: nicht dass wir Gott geliebt haben, sondern dass er uns geliebt hat und gesandt seinen Sohn zur Versöhnung für unsre Sünden. |  | [NAME] dahin kam, wo [NAME] war, und sah ihn, fiel sie ihm zu Füßen und sprach zu ihm: [NAME], wärst du hier gewesen, [NAME] wäre [NAME]. |  | Die gläubig gewordenen Juden, die mit Petrus gekommen waren, entsetzten sich, weil auch auf die Heiden die Gabe des Heiligen Geistes [NAME]. |  |  |  | [NAME] der [NAME]  fehlt, da jeweils nur der erste  [NAME]. 3en eingeholt wird.
 |  | 24
 |  | 24
Spreadsheet: 327747d1403676278-creating-an-attendance-tracker-help-employee-attendance-tracker1
Sheet: Settings

 | List of Employees | Date of Hire |  |  | Type of Infractions
 | Employee 1 | 2014-01-01 00:00:00 |  |  | RTLE
 | Employee 2 | 2014-01-01 00:00:00 |  |  | CO
 | Employee 3 | 2014-02-02 00:00:00 |  |  | NCNS
 | Employee 4 | 2014-02-02 00:00:00 |  |  | AL
 | Employee 5 | 2014-02-02 00:00:00 |  |  | Type of Winback
 | SAM, SAMPLE | 2014-02-02 00:00:00 |  |  | WDO
 | TEST, TESTER | 2014-02-02 00:00:00 |  |  | ELH
 | DOE, [NAME] | 2014-02-02 00:00:00 |  |  | ES
 | DOE, [NAME] | 2014-02-02 00:00:00 |  |  | PRO
 |  |  |  |  | Disciplinary
 |  |  |  |  | WW
 |  |  |  |  | 2DAY
Spreadsheet: 157773d1337870166-what-formula-to-use-the-multiplication-ashraf
Sheet: Sheet1

S.No. | Particulars | Qty | Unit | Rate | Amount
1 | [NAME] | 5 | Each | 6250
a | item1a |  |  | 3000
 | item2 | 12 | Each | 1000
a | item2a |  |  | 850
3 | Item3 | qro | Each | 2500
a | Item3a |  |  | 500
 | item4 | 4 | Each | 820
a | item4a |  |  | 500
 | [NAME] | 8 | Each | 5500
a | item5a |  |  | 750
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Nicholas

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 118642d1313821119-shorten-formula-to-avoid-maxing-of-cpu-master-budget
Sheet: Supplier breakdown

Supplier | Total Ex GST | Date Payment 1 | Date Payment 2 | Date Payment 3
Copyshop |  |  |  |  |  |  |  | Named Range >>> |  | Preliminaries
QBSA |  |  |  |  |  |  |  |  |  | Baseworks
HIA |  |  |  |  |  |  |  |  |  | Frame
Qleave |  |  |  |  |  |  |  |  |  | Enclosed
Electrician |  |  |  |  |  |  |  |  |  | Fixing
Electrical supplies |  |  |  |  |  |  |  |  |  | Practical Completion
[NAME]
Coastal fasteners
Direct line timbers
Bebrok
Daniels earthmoving
Concretor
[NAME] concrete
ARCREO
Landscape supplies
Formwork
Fabrication
Termite treatment
Swimming pool
Carpenters
Austral bricks
Blocklayer
Kelly green
Trusses
Windows supplier
Suncoast stairs
Waterproofer
Plumber
Plumber PC
Telstra
Plasterer
Solid plasterer
Cabinetmaker
Balustrading
Tile store
Tiler
Shower screen/ Mirror supplier
Garage door supplier
Painter
Carpets
[NAME]
Driveway
Spreadsheet: chris_germany__1977__lonestarnom2
Sheet: May 7, 2002

[NAME]
[NAME]
Dallas, TX  75201-5696
Attention: | Wilma Easter - Scheduling Department |  |  | From: | Enron Capital & Trade
Fax: | 214/875-3810 |  |  |  | [NAME]
Phone: | 214/875-3296 |  |  |  | 713/853-4743 (Phone)
Backup:  [NAME] 214/875-2674 |  |  |  |  | 713/646-3037 (Fax)
Contract #LS-MC-1671 |  |  | Start Date: | 2002-05-07 00:00:00 |  | End Date: | 2002-05-31 00:00:00
RECEIPT POINT INFORMATION:
STATION # | [NAME] | UPSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY | Changes
17-1201-11 | [NAME] | 01T957 | 0 | 0.01
17-1240-50 | NNG Sprayberry | 107903 | 10000 | 0.01
17-1240-50 | NNG Sprayberry | 108466 | 0 | 0.01
17-7462-50 | [NAME] | 5268 | 0 | 0.01
17-3000-00 | [NAME] | 2880600203 | 0 | 0.01 |  | **
17-1201-11 | [NAME] | REM | 25000 | 0.01 |  | **
DELIVERY POINT INFORMATION:
STATION # | [NAME] | UPSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY
25-0002-00 | Kleburne Plant | 1671
FYI:  Buy/Sell Information
17-1201-11 | [NAME] | #01T957 | 0 | 0 |  | sold to TXU K501
17-1201-11 | [NAME] | #01T957 | 0 | 0 |  | sold to TXU K1901 **
 | Supply moved 10,000 dth per day from Sid Rich to Oasis Mi Vida (not on Lone Star Pipeline)
Spreadsheet: 116187d1311662737-formula-to-retrieve-data-for-multiple-worksheets-from-one-master-data-sheet-example2
Sheet: SF

SF | Jan | Feb | March | May | June | July | Aug | Sept | Oct | Nov | Dec
Population | 1500 | 1852 | 1200 | 1369 | 1136 | 1158 | 1426 | 1325 | 1302 | 1300 | 1345
Average Temperature | 60 | 62 | 60 | 70 | 80 | 88 | 100 | 86 | 60 | 70 | 69
Avg. Income | 50000 | 45000 | 55000 | 56000 | 57000 | 57500 | 60000 | 65000 | 66000 | 65362 | 67555
Avg. Expense | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Kids | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 784410d1655724426-help-with-index-small-and-row-example2
Sheet: Tabelle1

data table
 | name | division
 | example name 1 | AB1 |  | a | text3 | text2 | text3 | text4 | text5 | text5 | text5 | text4 | a
 | example name 2 | AB2 |  | text2 | a | text4 | a | text5 | a | text4 | text2 | a | a
 | example name 3 | AB1 |  | text4 | text5 | text2 | a | text5 | text2 | text5 | text4 | text4 | a
 | example name 4 | AB1 |  | a | text2 | text5 | a | text5 | a | text5 | text3 | text4 | a
 | user input
 | division: | AB1 | AB2 | AB 1 | AB2 | AB1 | AB2
 | date: | 2022-06-20 00:00:00 | 2022-06-20 00:00:00 | 2022-06-21 00:00:00 | 2022-06-21 00:00:00 | 2022-06-29 00:00:00 | 2022-06-29 00:00:00
 | desired output:
 | list of names, who have "a" as status: | example name 1 |  |  | example name 2 | example name 1 | example name 2
 |  | example name 4 |  |  |  | example name 3
 |  |  |  |  |  | example name 4
Spreadsheet: 857020d1706116995-need-help-with-table-functions-book2
Sheet: Sheet1

Number | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 1 | 2 | 3 | 4 | 5
Set 1 | d | d | a | d | a | x | a | d | a | d | d | a
Set 2 | a | x | a | d | z | x | x | a | d | a | x | a
Set 3 | a | x | a | d | z | x | x | a | d | a | x | a
Spreadsheet: diana_scholtes__8577__Letter Log 01-31
Sheet: Termination

 | Events of Default/Termination
 | As of January 31, 2002
Term | Counterparty | Attorney Assigned | Enron Entity | Amount (if applicable) | Early Termination Date | Nature of Default (if any) | Contract Type(s) | Comments | Margin: (Posted by Enron)/Posted to Enron
 | Logan & Kanawha Coal Co., Inc. |  | ENA |  | 2002-01-31 00:00:00 | bankruptcy | deal no. Y5274.1 | L&K will calculate amount due
 | Risk Management & Trading Corp. |  | Enron MW, L.L.C. |  | 2002-01-30 00:00:00 | failure to pay or deliver | ISDA (02/09/2000) | RMT will calculate amount due
 | River Trading Company |  | ENA |  | 2002-01-25 00:00:00 | bankruptcy | deal no. VX2437.1 | RTC will calculate amount due
 | US Brick Co. |  | ENA |  |  | bankruptcy | swaps - deal nos. V48090.1 (04/20/2001) and [NAME] (04/20/2001) | US Brick is offering $200,000 to terminate and fully satisfy obligations of both parties; if not accepted, this is a demand for performance assurance
 | Vanguard Petroleum Corporation |  | EGLI |  | 2002-01-09 00:00:00 | failure to deliver | deal nos. VA7084.1, VH3709.1, VA4577.1 | pursuant to the confirmations, Vanguard has no further obligation or liability to EGLI
Spreadsheet: 39612ac3-f483-4dbf-b1f8-4e03476a14f2
Sheet: Sheet1

[NAME] | Units are no longer allowed to bring their own firewood to camp. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 2014-10-22 00:00:00
CHARTS ARE UPDATED DAILY. FOR UP TO THE MINUTE AVAILABILITY CALL (716)512-6216 OR E-MAIL [EMAIL]
SCHOELLKOPF |  |  |  | 2015 | 2015 | 2015 | 2015
 | Capacity | Code | FEE | [NAME] 6 - 8 | [NAME] 13 - 15 | [NAME] 20 - 22 | [NAME] 27 - 29
District/Council Events |  |  |  |  |  |  | IOLST
**Phillip (Lower) | 8 | S,W,E | 48
**Schoellkopf (Upper) | 12 | S,W,E | 72
Schwartz | 14 | S,W | 70
Score | 18 | S,W,E | 108 |  |  |  | IOLST
**Self | 12 | S,W,E | 72
Sikes | 16 | S,W,E,C | 96
**Toulmin | 18 | S,W,E | 108
Lean-To's
**Art Wood (Flats) | 12 | W | 48
**[NAME] (Northwoods) | 12 | W | 48
**Seibel (Northwoods) | 12 | W | 48
**Faso (Meyer Village) | 12 | W | 48
**[NAME] (Meyer Village) | 12 | W | 48
**[NAME] (Meyer Village) | 12 | W | 48
Troop 7 Shelter | 20 | S,W,E | 96 |  |  | T1776
**Szymkowiak lean-to | 12 | W, E | 72
Tenting   $2 per person,per night |  |  |  |  |  |  | IOLST                      Open Skies
Tenting   $2 per person,per night
Tenting   $2 per person,per night
Day Hike $2 per person
**SEASONAL [NAME] MAY BE CLOSED FOR VEHICLE TRAFFIC, PLEASE CONTACT THE RANGER AT [PHONE]
SCOUTHAVEN |  |  |  | 2015 | 2015 | 2015 | 2015
 | Capacity | CODE | FEE | [NAME] 6 - 8 | [NAME] 13 - 15 | [NAME] 20 - 22 | [NAME] 27 - 29
District/Council Events |  |  |  |  |  | MAPLE SUGAR DAY | CAMP CLOSED
[NAME] | 20 | S,W,E | 120 |  |  | P336 W | XXXX
Loegler 1 | 20 | C,S,W,E | 120 |  | T431 1/4W |  | XXXX
Loegler 2 | 20 | C,S,W,E | 120 | T735 W |  |  | XXXX
[NAME] | 30 | C,S,W,E | 180 | T42 W | T618 1/4 W | [NAME] | XXXX
Lean-To's |  |  |  |  |  |  | XXXX
#1 Eagle | 12 | W | 48 |  |  | T173 W | XXXX
#2 Whitetail | 12 | W | 48 |  |  |  | XXXX
#3 Dziedzic | 12 | W | 48 |  |  |  | XXXX
Moose | 10 | W | 40 |  |  |  | XXXX
Boss | 12 | W | 48 |  |  |  | XXXX
Tenting   $2 per person,per night |  |  |  |  |  |  | XXXX
Tenting   $2 per person,per night |  |  |  |  |  |  | XXXX
Day Hike $2 per person |  |  |  |  |  |  | XXXX
[NAME] |  |  |  | 2015 | 2015 | 2015 | 2015
 | Capacity | CODE | FEE | [NAME] 6 - 8 | [NAME] 13 - 15 | [NAME] 20 - 22 | [NAME] 27 - 29
District/Council Events
Cabin #1 | 24 | S,W,E | 144
Cabin #2 | 24 | S,W,E | 144
Leader's Lodge | 28 | S,W,E | 168 |  |  | P58 W
[NAME] | 30 | C,S,W,E | 180 |  |  | T58 W
Lean-To's
Stone Lean-To | 6 | [NAME] | 24
Troop 107 lean-to | 8 | W | 30
Ganosote Lean-To | 12 | W | 48
[NAME] | 12 | W | 48
[NAME] To | 12 | W | 48
Tenting   $2 per person,per night
Tenting   $2 per person,per night
Day Hike $2 per person
Code: S=Cooking Stove; W=Wood Heating Stove; E=Electricity; C=Co-Ed Ready
Firewood is $50.00 per 1/2 face.
Spreadsheet: 802958d1667178317-formula-to-match-mutiple-items-and-detect-exception-book-2
Sheet: Expected Result

Store | Item | Rev | Cost | Result
651899 | A - Cost | 0 | 5.56
651899 | B - Cost | 0 | 21.35 | Missing Revenue
651899 | A - Cost | 0 | 81
651899 | B - Cost | 0 | 128 | Missing Revenue
651899 | A - Cost | 0 | 198
651899 | A - Rev | -380 | 0
651899 | C - Rev | -35 | 0 | Missing Cost
651899 | F - Cost | 0 | 24.15 | Missing Revenue
960829 | A - Rev | -343.4 | 0
960829 | C - Rev | -45 | 0 | Missing Cost
960829 | B - Rev | -120 | 0 | Missing Cost
960829 | E - Rev | -31 | 0
960829 | D - Rev | -15.85 | 0 | Missing Cost
960829 | A - Cost | 0 | 230.6
960829 | E - Cost | 0 | 50
960829 | A - Cost | 0 | 31
960829 | F - Cost | 0 | 54
960829 | F - Rev | -100
173245 | A - Rev | -1172.6 | 0
173245 | C - Rev | -135 | 0 | Missing Cost
173245 | B - Rev | -210 | 0 | Missing Cost
173245 | A - Cost | 0 | 459.78
173245 | F - Cost | 0 | 162 | Missing Revenue
173245 | D - Cost |  | 200 | Missing Revenue
Spreadsheet: 648891d1573260900-data-from-one-range-to-another-return-an-error-if-more-than-1-entry-per-column-book100
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 |  | 1 | 0 | 3 | 2 | 4 | 1 | 5 | 2 | 2
 | 1 | A1 | A2 |  |  |  |  |  |  |  |  |  | A1 |  |  | A2
 | 2 | K7 |  | F3 |  |  |  | K7 |  | F3
 | 3 |  | Error |  |  |  |  |  |  |  | D4 |  |  |  | [NAME]
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
Spreadsheet: 872996d1719432256-help-creating-a-formula-quality-start-date-tenure-skillling
Sheet: Tenure and Skilling 

Team Leader | CSC |  | Start Date | Tenure | Current Role | Current Role Start Date | Current Role Start Date | LH GNR | LX GNR | 4Y GNR | OS GNR | .COM | MAM | HON
Gillian | [NAME], [NAME] |  | 2019-10-28 00:00:00 |  | GNR
Gillian | [NAME], [NAME] |  | 2023-10-13 00:00:00 |  | GNR
Gillian | Anthrakeus, [NAME] |  | 2022-06-06 00:00:00 |  | TQS
Gillian | Azim, Amedullah |  | 2021-08-09 00:00:00 |  | GNR
Gillian | Cheema, Shazia |  | 2018-03-21 00:00:00 |  | GNR
Gillian | Dessalegn, Bruck |  | 2024-01-26 00:00:00 |  | GNR
Gillian | Gies, Tatjana |  | 2024-01-26 00:00:00 |  | GNR
Gillian | [NAME], [NAME] |  | 2019-04-22 00:00:00 |  | GNR
Gillian | Kapoor, Himanshi |  | 2017-05-15 00:00:00 |  | GNR
Gillian | Luettig, Ralf |  | 2021-12-06 00:00:00 |  | GNR
Gillian | [NAME], [NAME] |  | 2024-01-26 00:00:00 |  | GNR
Gillian | Okello-Okello, Jeremy |  | 2024-01-26 00:00:00 |  | GNR
Gillian | Ott, [NAME] |  | 2024-01-26 00:00:00 |  | GNR
Gillian | Ponnudurai, Abirami |  | 2022-04-25 00:00:00 |  | GNR
Gillian | Racco, [NAME] |  | 2024-01-26 00:00:00 |  | GNR
Gillian | Siddhu, Tashifa |  | 2024-01-26 00:00:00 |  | GNR
Gillian | Ugurlu, Seher |  | 2023-10-13 00:00:00 |  | GNR
Spreadsheet: 69220d1269735611-all-worksheets-grand-total-of-a-cell-on-a-new-sheet-book-1
Sheet: PT01

 | PT01
 | Material | Description | Book Bal.
PT0150100-10J-7700 | 50100-10J-7700 | BODY COMPLETE FRAME (PNTD) CD (W.STAY) | 0
PT0150100-198-7400 | [PHONE] | FRAME BODY CD - PRE Y-2K | 0
PT0150100-198-7700 | [PHONE] | BODY COMPLETE FRAME (PAINTED) CD | 13
PT0150100-198-D000 | 50100-198-D000 | BODY COMP.FRAME(PAINTED) | 38
PT0150100-198-D100 | 50100-198-D100 | BODY COMPLETE FRAME (PAINTED) CD | 0
PT0150100-198-D110 | 50100-198-D110 | BODY COMPLETE FRAME (PAINTED) CD | 0
PT0150100-KAG-9100 | 50100-KAG-9100 | BODY COMPLETE FRAME (PAINTED) SLEEK | 0
PT0150100-KCC-6900 | 50100-KCC-6900 | FRAME BODY COMP. PASSION PLUS Y2K | 1162
PT0150100-KCC-7100 | 50100-KCC-7100 | BODY COMPLETE FRAME (PTD) SPP-Y2K5 | 0
PT0150100-KCC-7310 | 50100-KCC-7310 | FRAME BODY COMP. PASSION PLUS (OLD) | 42
PT0150100-KCC-8300 | 50100-KCC-8300 | BODY COMPLETE FRAME (PAINTED) SPP | 0
PT0150100KCC8300060 | 50100KCC8300060 | FRAME BODY (UPTO FINE BORING) -SPL MMC | 0
PT0150100-KCC-8310 | 50100-KCC-8310 | BODY COMPLETE FRAME (PAINTED) SPP | 72
PT0150100-KCC-9000 | 50100-KCC-9000 | FRAME BODY SPL - PRE Y-2K | 0
PT0150100KCC9000010 | 50100KCC9000010 | FRAME BODY SPL(WELDED) - PRE Y-2K | 0
PT0150100-KCC-9400 | 50100-KCC-9400 | BODY COMPLETE FRAME (PAINTED) KCC | 0
PT0150100KCC9400010 | 50100KCC9400010 | BODY COMPLETE FRAME (WELDED) KCC | 0
PT0150100-KST-8700 | 50100-KST-8700 | BODY COMP.FRAME DLX CND (CDN3- DLX) SELF | 0
PT0150100-KST-9000 | 50100-KST-9000 | BODY COMPLETE FRAME (PAINTED) CDN | 0
PT0150100KST9000060 | 50100KST9000060 | FRAME BODY (UPTO FINE BORING) -CDN | 0
PT0150100-KST-9200 | 50100-KST-9200 | BODY COMP.FRAME STD CDD | 0
PT0150100-KST-9300 | 50100-KST-9300 | BODY COMP.FRAME DLX CDD | 0
PT0150100-KST-9400 | 50100-KST-9400 | BODY COMP.FRAME STD CNS (CDN3- STD) | 282
PT0150100-KST-9500 | 50100-KST-9500 | BODY COMP.FRAME DLX CND (CDN3- DLX) | 1057
PT0150100-KTC-9000 | 50100-KTC-9000 | FRAME BODY COMP. | 0
PT0150100-KTC-9200 | 50100-KTC-9200 | FRAME BODY ( SELF ) | 0
PT0150100-KTC-A000 | 50100-KTC-A000 | FRAME BODY SPS MMC ( SELF ) | 289
[NAME] | 50100-KVH-9010 | BODY COMP.FRAME STD CNS (SPN) | 0
PT0150100-KWH-9000 | 50100-KWH-9000 | BODY COMPLETE FRAME (PTD) SPP NEW | 1898
PT0150100KWH900070 | 50100KWH900070 | FRAME BODY COMP  WITH  FINE BORING | 0
PT0150100-P14-9000 | 50100-P14-9000 | BODY COMPLETE FRAME (PAINTED) CD100SS | 14
 |  | Grand Total
Spreadsheet: 59086d1259527726-summarizing-data-example-pike
Sheet: Sheet1

CUSTOMER | ITEM1 | ITEM2 | ITEM3 | ITEM4
[NAME] | STAPLER | PAPER
SUZY B GOOD | CHAIR | STAPLER
SUZY B GOOD | ERASER | PEN | RED PEN | BLUE PEN
[NAME] | NOTEPAD | STAPLER
SUZY B GOOD | NOTEPAD | STAPLER
[NAME] | PAPER | RED PEN |  | BLUE PEN
[NAME] | PAPER CLIP | NOTEPAD
[NAME] | SCISSORS | BLACK PEN |  | BLUE PEN
ANON Y MOUSE | STAPLER | SCISSORS
[NAME] | ERASER |  | PEN | MOUSEPAD
[NAME] | PAPER CLIP | NOTEPAD
[NAME] | SCISSORS | BLACK PEN |  | RED PEN
[NAME] | STAPLER | SCISSORS
[NAME] | ERASER |  | PEN | MOUSEPAD
SUZY B GOOD | NOTEPAD | STAPLER
[NAME] | STAPLER | PAPER
SUZY B GOOD | TABLE | STAPLER
SUZY B GOOD | ERASER | PEN |  | RED PEN
[NAME] | NOTEPAD | STAPLER
SUZY B GOOD | NOTEPAD | STAPLER
[NAME] | PAPER | BLUE PEN |  | BLACK PEN
[NAME] | PAPER CLIP | NOTEPAD
[NAME] | SCISSORS | RED PEN |  | BLUE PEN
ANON Y MOUSE | STAPLER | SCISSORS
[NAME] | ERASER | PENCIL | PEN | MOUSEPAD
[NAME] | PAPER CLIP | NOTEPAD
SUZY B GOOD | ERASER | PENCIL | PEN
SUZY B GOOD | NOTEPAD | STAPLER
[NAME] | ERASER | PENCIL | PEN | MOUSEPAD
Spreadsheet: 867626d1714457043-need-attendace-sheet-for-saleman-visited-diffrent-regions-with-different-items-book4-12-aligw
Sheet: Sheet1

 |  | Salesman | Items | Region
 |  | Salesman101 | Item-1 | REG-1
 |  | Salesman101 | Item-2 | REG-3
 |  | Salesman101 | Item-3 | REG-3
 |  | Salesman111 | Item-1 | [NAME]
 |  | Salesman111 | Item-2 | REG-3
 |  | Salesman111 | Item-3 | REG-1
 |  | Salesman111 | Item-4 | REG-3
 |  | Salesman111 | Item-5 | REG-3
 |  | Salesman111 | Item-6 | [NAME]
 |  | Salesman111 | Item-7 | REG-3
 |  | Salesman111 | Item-8 | REG-5
 |  | Salesman111 | Item-9 | [NAME]
Salesmen | Items | REG-1 | [NAME] | REG-3 | REG-4 | REG-5 | [NAME] |  |  |  |  |  | Salesmen | REG-1 | [NAME] | REG-3 | REG-4 | REG-5 | [NAME]
Salesman101 | Item-1 |  |  |  |  |  |  |  |  |  |  |  | Salesman101 | 0.33 |  | 0.67
Salesman101 | Item-2 |  |  | 0.3333333333333333 |  |  |  |  |  |  |  |  | Salesman111 | 0.11 |  | 0.56 |  | 0.11 | 0.22
Salesman101 | Item-3 |  |  | 0.3333333333333333 |  |  |  |  |  |  |  |  | Salesman121 |  | 0.5 |  | 0.5
Salesman111 | Item-1 |  |  |  |  |  | 0.1111111111111111
Salesman111 | Item-2 |  |  | 0.1111111111111111
Salesman111 | Item-3 | 0.1111111111111111
Salesman111 | Item-4 |  |  | 0.1111111111111111 |  |  |  |  |  |  |  |  |  | REG-1 | [NAME] | REG-3 | REG-4 | REG-5 | [NAME]
Salesman111 | Item-5 |  |  | 0.1111111111111111 |  |  |  |  |  |  |  |  | Salesman101 | 0.3333333333333333 |  | 0.6666666666666666
Salesman111 | Item-6 |  |  |  |  |  | 0.1111111111111111 |  |  |  |  |  | Salesman111 | 0.1111111111111111 |  | 0.4444444444444444 |  | 0.1111111111111111 | 0.3333333333333333
Salesman111 | Item-7 |  |  | 0.1111111111111111 |  |  |  |  |  |  |  |  |  | 0.2222222222222222 |  | 0.5555555555555556 |  | 0.05555555555555555 | 0.1666666666666667
Salesman111 | Item-8 |  |  |  |  | 0.1111111111111111
Salesman111 | Item-9 |  |  |  |  |  | 0.1111111111111111
Spreadsheet: 796088d1663092213-google-sheets-add-values-based-on-top-2-numbers-in-separate-column-scorecalc1
Sheet: Sheet1

Name | Total Score | AN | AD | AS | BN | BD | BS | CN | CD | CS
Jon |  | 1 | 2 |  | 4 | 5 |  | 7 | 8