tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 453169d1459192298-how-can-i-use-nested-if-statements-in-combination-with-dropdowns-test-page-1
Sheet: Sheet1

SERVICE | TYPE | PRICE |  |  |  |  |  |  |  | SERVICE | TYPE
SPRING SERVICE | EXTRA | 250 |  |  |  |  |  |  |  | SPRING SERVICE | EXTRA
SUMMER SERVICE | EXTRA | 500 |  |  |  |  |  |  |  | SUMMER SERVICE | CONTRACT
FALL SERVICE | EXTRA | 300 |  |  |  |  |  |  |  | FALL SERVICE
 |  |  | START | FINISH |  | TOTAL
DATE | TYPE | SERVICE | TIME | TIME | PERSONS | TIME | VALUE
 | EXTRA | SPRING SERVICE | 14:00:00 | 15:00:00 | 2
Spreadsheet: 32904d1229074090-excel-file-and-hyperlinking-images-sample-database-file
Sheet: Sheet1

EMPLOYEE CODE | NAME | DESIGNATION | DEPARTMENT | BLOOD GROUP | DATE OF JOINING | DATE OF BIRTH | PHOTO
123 | TOM | [NAME] | [NAME] | [NAME] | 1988-05-12 00:00:00 | 1960-09-18 00:00:00 | H:\CARD PRINTING\A.V.V. [NAME] 31.jpg
234 | JERRY | MANAGER ADMIN | ADMIN | A+ | 1987-04-11 00:00:00 | 1970-05-14 00:00:00
456 | MATHEW | MANAGER STORES | STORES | O+ | 1985-06-23 00:00:00 | 1965-04-13 00:00:00
678 | JACK | MANAGER ACCOUNTS | ACCOUNTS | AB+ | 1984-02-14 00:00:00 | 1962-03-24 00:00:00
235 | MCDONALD | MANAGER STORES | STORES | A+ | 1985-06-24 00:00:00 | 1966-07-14 00:00:00
365 | PETER | MANAGER ACCOUNTS | ACCOUNTS | [NAME] | 1987-06-23 00:00:00 | 1969-03-16 00:00:00
478 | [NAME] | MANAGER PROJECTS | PROJECTS | [NAME] | 1989-05-24 00:00:00 | 1971-02-21 00:00:00
895 | KRIS | MANAGER FINANCE | FINANCE | O+ | 2001-04-13 00:00:00 | 1972-11-20 00:00:00
985 | [NAME] | MANAGER SECURITY | SECURITY | AB+ | 2005-05-14 00:00:00 | 1973-09-25 00:00:00
647 | GEORGE | ASST MANAGER WORKS | WORKS | A+ | 2008-09-18 00:00:00 | 1971-04-05 00:00:00
Spreadsheet: 847729d1698599056-summarize-data-on-multiple-sheets-to-one-sheet-sample
Sheet: Vegetable Delivery

Date | Name | Qty | Price | Amount |  |  |  |  |  | Name | QTY | PRICE
2023-10-01 00:00:00 | Lettuce | 30 | 2
2023-10-02 00:00:00
2023-10-03 00:00:00
2023-10-04 00:00:00
2023-10-05 00:00:00 | Eggplant | 25 | 3
2023-10-06 00:00:00
2023-10-07 00:00:00
2023-10-08 00:00:00 | Cabbage | 30 | 2
2023-10-09 00:00:00
2023-10-10 00:00:00
2023-10-11 00:00:00
2023-10-12 00:00:00
2023-10-13 00:00:00
2023-10-14 00:00:00
2023-10-15 00:00:00
2023-10-16 00:00:00
2023-10-17 00:00:00
2023-10-18 00:00:00
2023-10-19 00:00:00
2023-10-20 00:00:00
2023-10-21 00:00:00
2023-10-22 00:00:00
2023-10-23 00:00:00
2023-10-24 00:00:00
2023-10-25 00:00:00
2023-10-26 00:00:00
2023-10-27 00:00:00
2023-10-28 00:00:00
2023-10-29 00:00:00
2023-10-30 00:00:00
2023-10-31 00:00:00
Spreadsheet: 128952d1321373766-different-combinations-of-text-scratch-1-
Sheet: Sheet1

Cum: | 5 | 1 | 1 | 1 | 1 | 1 |  |  |  | [NAME] columns to left as needed
Cnt: | 5 | 1 | 1 | 1 | 1 | 1
 | Bin1 | Bin2
 | Stp | Stp | Shp | Ld | Geo | Gas |  |  |  | No interspersed blanks
 | Shp
 | Ld
 | Geo
 | Gas
# | Permutations |  |  |  |  |  |  |  |  | [NAME] rows above as needed
1 | Stp | Stp | Shp | Ld | Geo | Gas
2 | Shp | Stp | Shp | Ld | Geo | Gas
3 | Ld | Stp | Shp | Ld | Geo | Gas
4 | Geo | Stp | Shp | Ld | Geo | Gas
5 | Gas | Stp | Shp | Ld | Geo | Gas
6 | Stp | Stp | Shp | Ld | Geo | Gas
7 | Shp | Stp | Shp | Ld | Geo | Gas
8 | Ld | Stp | Shp | Ld | Geo | Gas
9 | Geo | Stp | Shp | Ld | Geo | Gas
10 | Gas | Stp | Shp | Ld | Geo | Gas
11 | Stp | Stp | Shp | Ld | Geo | Gas
12 | Shp | Stp | Shp | Ld | Geo | Gas
13 | Ld | Stp | Shp | Ld | Geo | Gas
14 | Geo | Stp | Shp | Ld | Geo | Gas
15 | Gas | Stp | Shp | Ld | Geo | Gas
16 | Stp | Stp | Shp | Ld | Geo | Gas
17 | Shp | Stp | Shp | Ld | Geo | Gas
18 | Ld | Stp | Shp | Ld | Geo | Gas
19 | Geo | Stp | Shp | Ld | Geo | Gas
20 | Gas | Stp | Shp | Ld | Geo | Gas
Spreadsheet: 07506aca-d6cf-4a30-abcc-b4b9ece0d100
Sheet: Sheet1

Unnamed: 0 | PRESIDENT AND VICE PRESIDENT OF THE UNITED STATES | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
2000-11-07 00:00:00
Summary By | [NAME] and | [NAME] and | Browne and | [NAME] and | Phillips and | [NAME] and | Miscellaneous
Counties | [NAME], r | [NAME], d | Olivier, [NAME] | LaDuke, gr | Frazier, con | [NAME], ind | Write-ins
Belknap | 14799 | 10719 | 88 | 977 | 14 | 124 | 74
Carroll | 12597 | 9852 | 131 | 1086 | 17 | 119 | 77
Cheshire | 13793 | 17382 | 152 | 1750 | 45 | 186 | 87
Coos | 7329 | 6570 | 69 | 463 | 11 | 133 | 25
[NAME] | 18092 | 18326 | 209 | 1783 | 32 | 210 | 81
Hillsborough | 80649 | 77625 | 811 | 5465 | 62 | 755 | 394
Merrimack | 30028 | 30622 | 286 | 2343 | 32 | 230 | 143
Rockingham | 65860 | 61628 | 626 | 5213 | 55 | 534 | 257
[NAME] | 21108 | 25400 | 286 | 2273 | 36 | 210 | 80
[NAME] | 9304 | 8224 | 99 | 845 | 24 | 114 | 58
TOTALS | 273559 | 266348 | 2757 | 22198 | 328 | 2615 | 1276
[NAME]libertarian
gr=green
con=constitution
ind=independence
Spreadsheet: 90170d1289931183-cannot-get-formulas-to-populate-a-protected-worksheet-when-inserting-rows-bcs-scope-list-template
Sheet: Building17

Building17
 | Reference No. | Year | Priority | BCS Reference | Items | Existing Conditions | Recommendations | New Const. | Additions | Alteration | Major Systems | Major Repair | Energy | Bond | Capital | Estimated Cost with Incidental
 |  | SITE ISSUES
 |  | ARCHITECTURAL ISSUES
 |  | MECHANICAL ISSUES
 |  | PLUMBING ISSUES
 |  | ELECTRICAL ISSUES
Spreadsheet: 08177d4a-6399-45dc-a82a-306d245e366e
Sheet: Sheet1

Potomac/Shenandoah Basin (1-) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 |  |  |  |  |  |  |  |  |  |  |  |  | (1)
 |  |  |  |  |  |  |  |  |  |  |  |  | (2 - ASPON)
 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  | 29
Spreadsheet: 772480d1647296790-trying-to-get-rate-from-shhet-when-matching-a-and-b-test2
Sheet: RATES

Terminal | Product | Transportation | Delivery | Additive injection | Blending | Lubricity | Red Dye | BIO
LA - LA-GATX | 122 [NAME] | 0.6309 | 0.4042 | 0.095 | 0.015 | 0 | 0 | 0
LA - LA-GATX | 504 Pipe | 0.6309 | 0.4042 | 0.095 | 0 | 0.014 | 0 | 0
LA - LA-GATX | 505 Pipe | 0.6309 | 0.4042 | 0.095 | 0 | 0.014 | 0.014 | 0
[NAME] | 599 Pipeline | 1.0876 | 0.4042 | 0.095 | 0 | 0 | 0 | 0
NC - Chico | 599 Pipeline | 1.0876 | 0.4042 | 0.095 | 0 | 0 | 0 | 0
NC - Fresno | 594 B99 /01 | 1.0876 | 0.4042 | 0.095 | 0 | 0.014 | 0 | 7.86
NC - San Jose | 127  Carbob/PIPE | 0.257 | 0.4042 | 0.095 | 0.015 | 0 | 0 | 0
NC - San Jose | 599 Pipeline | 0.257 | 0.4042 | 0.095 | 0 | 0 | 0 | 0
SD - San Diego | 599 Pipeline | 1.93 | 0.4042 | 0.095 | 0 | 0 | 0 | 0
 |  | 0.5 |  |  |  | 1
 |  | 0.5
 |  | 0.025
Spreadsheet: 240663d1370382018-duplicate-entries-in-rows-add-accompanying-data-to-new-columns-mergesample
Sheet: BEFORE

DOC | USER | DEPT | CLASS | BRAND | MODEL | PRICE | COST | BEGIN | END
46666 | 180 | 0 | 8 | LG | 42PN4500 | 499 | 449 | 06-02-2013 | 06-08-2013
46712 | 180 | 0 | 8 | LG | 42PN4500 | 489 | 449 | 06-09-2013 | 06-15-2013
46664 | 180 | 0 | 8 | SAMSUN | PN43F4500 | 399 | 349 | 06-02-2013 | 06-08-2013
46666 | 180 | 0 | 10 | LG | 50PN4500 | 599 | 519 | 06-02-2013 | 06-08-2013
46712 | 180 | 0 | 10 | LG | 50PN4500 | 589 | 519 | 06-09-2013 | 06-15-2013
46717 | 180 | 0 | 10 | LG | 50PN4500 | 579 | 519 | 2013-06-16 00:00:00 | 2013-06-25 00:00:00
47711 | 180 | 0 | 10 | LG | 60PN6500 | 699 | 599 | 06-09-2013 | 06-15-2013
Spreadsheet: 727001d1617644840-duplicate-lookup-and-sum-function-sample-lookup
Sheet: Sheet1

Student ID | Budget Allocation
145256 | 100
434334 | 100
756757 | 100
454666 | 100
866868 | 100
987654 | 100
675333 | 100
224353 | 30
435553 | 100
498849 | 100
313133 | 100
447839 | 100
224353 | 40
224353 | 30
Spreadsheet: 773927d1648121174-get-the-final-date-free-after-blockout-datefree
Sheet: Sheet1

DateAfterBlockout1 | [NAME] | [NAME] | DateActualFree2 | DateAfterBlockout3 | DateActualFree3 | DateAfterBlockout4 | [NAME] | [NAME] | DateActualFree5 | [NAME] | DateActualFree6 | Results
2021-02-26 00:00:00 | 2021-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2021-03-26 00:00:00
2021-02-27 00:00:00 | 2021-03-03 00:00:00 | 2021-03-04 00:00:00 | 2021-03-09 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-04 00:00:00
29/02/2021 | 2021-03-03 00:00:00 | 2021-03-04 00:00:00 | 2021-03-12 00:00:00 | 2021-03-15 00:00:00 | 2021-03-17 00:00:00 |  |  |  |  |  |  | 2021-03-15 00:00:00
Spreadsheet: 85851d1285869388-insert-variables-from-two-cells-in-a-formula-sample
Sheet: blank

October |  |  |  | DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  |  | TOTAL | COMMENTS
No. | NAME, SURNAME |  |  | 2010-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Good | Bad
1 | [NAME] | [NAME] | Agnese
2 | Jūlija | Ancāne | [NAME]
3 | [NAME] | Asmusa | Gunta
4 | [NAME] | Avdejeva | Elina
5 | Sigita | Bajāre | Zane
6 | Jūlija | Beļajeva | Angelica
7 | Nika | [NAME] | Alla
8 | Artūrs | Bogdanovs | Gints
9 | [NAME] | Bormeistere | Inese
10 | Jeļena | Černišova | Rita
11 | Diāna | Čubare | Sigita
12 | [NAME] | Donika | Baiba
13 | Elina | [NAME] | [NAME]
14 | [NAME] | [NAME] | Valters
15 | Eva | Emoliņa | Izabella
16 | Kristīna | Fadejeva | Vika
17 | Jeļena | Grigorjeva | Karina
18 | Egita | Grīnhofa | Dace
19 | Viktorija | Jansone | Kristine
20 | Jūlija | [NAME] | Elena
21 | Sandra | Jeršova | Inna
22 | Viktorija | Ježkova | Natalija
23 | Daiga | Kalniņa | Renate
24 | Ļubova | Kapustina | Skaidra
25 | Karina | Karjakina | Olivia
26 | Liva | Karlivāne | Sandra
27 | Neringa | Karnyšova | [NAME]
28 | Katažina | Koltane | Biruta
29 | Aija | Koliškina | [NAME]
30 | Diāna | Konopecka | Marta
31 | Margarita | Krutova | Ilze
32 | [NAME] | Kugaudo | Nastja
33 | Gunita | Kurdjukova | Vita
34 | Sanda | [NAME] | Margarita
35 | [NAME] | [NAME] | Darja
36 | Kristine | Ķikuta | Kristiana
37 | Nadežda | Lavrecka | Julija
38 | Antonina | Leonova | Antonia
39 | Signe | Licite | Magdalena
40 | Agita | Lubāne | Inga
41 | Valērija | [NAME] | Irina
42 | Kristina | [NAME] | Sandra
43 | Lāsma | Neļķe | Marija
44 | [NAME] | Ose | [NAME]
45 | Jeļena | [NAME] | Vija
46 | Liga | Percova | [NAME]
47 | Māra | Piķele | Lelde
48 | Jeļena | Platonova | [NAME]
49 | Evija | Putnina | [NAME]
50 | [NAME] | [NAME] | Edgars
51 | Baiba | Rağe | Ksenija
52 | Ināra | Rukmane | Sveta
53 | Katrīna | Ruskule | Una
54 | Santa | Samiņa | Nina
55 | Regīna | Šapale | [NAME]
56 | Jūlija | Šendereva | [NAME]
57 | Rasa | Sēne | Liga
58 | Inga | Ščerbinska | Melanija
59 | Alīna | Siņajeva | [NAME]
60 | Ieva | Skuja | Ella
61 | Ņina | [NAME] | [NAME]
62 | [NAME] | Stendere | Beate
63 | Irina | Stoļarova | Evija
64 | [NAME] | Suslova | Gunita
65 | Rūdolfs | Šmits | [NAME]
66 | Ieva | Tannenberga | Evita
67 | Jeļena | [NAME] | Liena
68 | Viktorija | Timofejeva | Aviva
69 | Nataļja | Tišina | Anna
70 | [NAME] | Trifonova | Una
71 | Ilze | Trukšāne | Aija
72 | Una | Upīte | Viktoria
73 | Lelde | [NAME] | Luiza
74 | Signe | Viļumsone | Liva
75 | Natālija | [NAME] | Valerija
76 | Sabīne | Visočenko | Sintija
77 | Gunita | Vimba | Greta
78 | Anastasija | Vītola | Aurelia
79 | Anna | Zalūkšne | [NAME]
80 | Lelde | [NAME] | Nanija
81 | [NAME] | Ziemele | Eva
82 | [NAME] | Zemīte | [NAME]
83 | [NAME] | Zvingule | Laila
84 | Jeļena | Žipre | Katja
 | Number of dealers
 | Average per dealer
Spreadsheet: 703774d1605170905-to-show-result-the-total-count-on-specific-character-formula-2
Sheet: TEAM B

 | Case | Likelihood | Impact | Risk Weight
 | A | 2 | 2 | Low
 | B | 5 | 5 | Extreme
 | C | 2 | 3 | Moderate
 | D | 1 | 4 | Moderate
 | E | 1 | 5 | High
Spreadsheet: 453382d1459288632-if-function-with-multiple-options-theatre-tech-charge-sheet
Sheet: Day1

Event
Date
Service | Base Arrival | Base Departure | Break Beginning | Break End | [NAME] |  |  |  |  |  | Base Hours | Base Over 8 | Base Over 8 Gross
Base
Group Note
 | [NAME] | Performance End |  | Attendance |  |  |  |  |  |  | Hours | Performances
Performance
Performance
Performance
Performance
Dark Day
Staff | [NAME] | Departure | Break Beginning | Break End | Technician Name |  |  |  |  |  | Standard | OT. | Total Hours
Tech.
Tech.
Tech.
Tech.
Tech.
Tech.
Unscheduled Tech.
Custodian
Custodian
Extended Custodial
Special Equipment Daily | Qty.
Bubbles |  | Notes
Fog- Chemical
Fog- Dry Ice
Piano
Snow
Extra Spotlight
Stage Deck
Total Wireless Channels Used
.
.
.
.
Additional Rooms | [NAME] | Departure | Break Beginning | Break End |  |  |  |  |  |  | Min. | Over Min. | Total Hours
[NAME]
Comstock Room
Gym
Sierra Room
Tahoe Room
Base Hours | Tech. Hours
Base Over 8 | Tech. Hours Over 8
Performances | Unscheduled Tech. |  | Wireless Channels
Dark Day | Custodial
Attendance | Custodial OT., ET.
Between 12am and 8am Adder
Spreadsheet: 270751d1381624783-vlookup-type-function-see-if-string-has-key-if-it-does-give-value-excelforumvlookup-2013-10-12-20-37
Sheet: Sheet1

FUMIYOSHI JAPANESE RESTUAVANCOUVER
PAYPAL *MICROSOFTCO      [PHONE]
SPIRITS OF MT SEYMOUR    NORTH VANC
TRANSLINK FARE PURCHASE  BURNABY
TRANSLINK FARE PURCHASE  BURNABY
TRANSLINK FARE PURCHASE  BURNABY
TRANSLINK FARE PURCHASE  BURNABY
TRANSLINK FARE PURCHASE  BURNABY
TRANSLINK FARE PURCHASE  BURNABY
STARBUCKS COFF00001511   [NAME]
TRANSLINK FARE PURCHASE  BURNABY
TRANSLINK FARE PURCHASE  BURNABY
TRANSLINK FARE PURCHASE  BURNABY
TRANSLINK FARE PURCHASE  BURNABY
DR PAUL WIGGINS DC       N VANCOUVE
SAPPORO RAMEN      QFF   [NAME]
STARBUCKS COFF00049197   N VANCOUVE
ESSO 106 W QUEENS ST     NORTH VANC
HELLY HANSEN GRANVILLE   [NAME]
TRANSLINK FARE PURCHASE  BURNABY
TRANSLINK FARE PURCHASE  BURNABY
FUMIYOSHI JAPANESE RESTUAVANCOUVER
THE GULL LIQUOR STORE    NORTH VANC
SEYCOVE MARINA LTD       N VANCOUVE
Spreadsheet: 599232d1542913983-formula-for-extracting-data-according-the-criteria-excel
Sheet: Sheet

 |  | code | RHG
 |  | days | 8
 |  | value | 5
 |  | % | 7
 |  |  | Chooise 1 | Chooise 2 | Chooise 3 | Chooise 4 | Chooise 5
 |  | Code
 |  | days
 |  | value | 30 | 25 | 10 | 90 | 60
 |  | Direction | + | - | + | + | +
 |  | % | 25 | 7 | 9 | 8 | 15
Spreadsheet: a337a5b6-5a4a-46a5-98c2-132196b089fa
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
4089 | 25203 | [NAME] | Toles | USA | 0 | 00:08:47 | 00:00:38 | 00:17:36 | 00:00:56 | [NAME] | 1 | [NAME]
4089 | 13196 | [NAME] | Syrop | USA | 0 | 00:10:16 | 00:00:48 | 00:20:02 | 00:00:50 | 00:12:26 | 2 | 00:44:22
4089 | 25202 | Lamar | Sepulveda | USA | 0 | 00:11:38 | 00:00:43 | 00:23:49 | 00:00:57 | 00:12:48 | 3 | 00:49:55
4089 | 17273 | Sergio | Ayala | MEX | 0 | 00:12:10 | 00:00:49 | 00:22:27 | 00:01:12 | 00:13:17 | 4 | 00:49:55
4089 | 25201 | Abelardo | Nuñez | MEX | 0 | 00:12:00 | [NAME] | 00:24:30 | [NAME] | [NAME] | 5 | 00:53:28
Spreadsheet: 462533d1464090640-selecting-a-specific-answer-based-on-two-conditions-then-export-to-a-different-sheet-test-calc
Sheet: Office

GRADE | LENGTH |  | WIDTH |  | THICKNESS |  | QTY
HD | 400 | x | 200 | x | 10 | [NAME] | 2000
GRADE | LENGTH |  | WIDTH |  | THICKNESS |  | QTY
 |  | x |  | x |  | [NAME] |  | STACKS | SLABS | PIECES | VOLUME
Spreadsheet: 271721d1382027346-get-the-top-5-values-and-associated-names-deals-data
Sheet: Rocio Escrina

Deal Initiated | Deal Won/Lost Date | Currency | Amount | Total Revenue in Pipeline [USD] | Percentage chances to close (%) | Total Revenue in bank [USD] | Advertiser | Brief Description of the deal | Status | Sales Life Cycle | Deal Run Date | Deal Initiated Month | Deal Won Month | CMP/CPC/CPA | Execution Geo | Stage
2013-08-09 00:00:00 |  | $ | 1000 |  | 0.2 |  | Adsfactor | AU trade - Adsfactor - Rev Share 60/40 | Pending |  | 2013-10-01 00:00:00 |  |  |  |  | S1
2013-08-21 00:00:00 |  | AU$ | 400 |  | 0.01 |  | Adinch | AU trade | Pending |  | 2013-10-01 00:00:00 |  |  |  |  | S1
2013-08-09 00:00:00 |  | $ | 6000 |  | 0.05 |  | Guru Online | Trade AU - Rev Share 60/40 | Pending |  | 2013-10-01 00:00:00 |  |  |  |  | S1
2013-07-09 00:00:00 |  | $ | 1000 |  | 0.1 |  | AdzCentral | Trade Aus - Video - Rev Share | Pending |  | 2013-11-01 00:00:00 |  |  |  |  | S1
2013-10-09 00:00:00 |  | $ | 1000 |  | 0.6 |  | Xapads | Display AU - Xapads - Arab - CPM | Pending |  | 2013-10-01 00:00:00 |  |  | CPM |  | [NAME]
2013-10-09 00:00:00 |  | $ | 500 |  | 0.7 |  | Tyroo | Display AU - Tyroo CPC | Pending |  | 2013-10-01 00:00:00 |  |  | CPC |  | S2
2013-10-02 00:00:00 |  | $ | 300 |  | 1 |  | AdIQuity | AdIQuity: Trade AU - AdIQuity - Rev Share | Lost |  | 2013-10-01 00:00:00
2013-10-15 00:00:00 |  | $ | 3000 |  |  |  | Empowered Media | [NAME] agency - CPC - $1.20 - Energy Aus - Regional SA and Vic | Pending |  |  |  |  |  |  | S1
Spreadsheet: 467476d1466718009-how-to-extract-multiple-datas-matching-to-a-cell-value-example-data2
Sheet: Sheet2

HoleID | From | To | Length | Cu | Au | CuEQ
CAR_0928_000003_EX | 0 | 1.0894 | 1.0894 | 5 | 2.302546296296296 | 6.61
CAR_0928_000003_EX | 1.0894 | 2.1788 | 1.0894 | 3.05 | 1.611782407407407 | 4.18
CAR_0928_000008_EX | 0 | 1.0894 | 1.0894 | 0.91 | 1.973611111111111 | 2.29
CAR_0928_000008_EX | 1.0894 | 2.1788 | 1.0894 | 0.97 | 0.8442669753086419 | 1.56
CAR_0950_000016_EX | 0 | 2 |  | 1.8 | 0.7565509259259259
Spreadsheet: 772612d1647400115-need-help-creating-formula-to-use-excess-funds-to-payoff-debt-in-order-pay-of-debt
Sheet: Sheet1

 |  |  | January | February | March | April | May | June | July | August | September | October | November | December
 |  | Rent/Ins/Util | - | - | - | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800
 |  | CC1 | 45000 | 39000 | 29000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000
 |  | CC2 | 4300 | 4300 | 4300 | 4300 | 4300 | 4300 | 4300 | 4300 | 4300 | 4300 | 4300 | 4300
 |  | CC3 | 800 | 800 | - | - | - | - | - | - | - | - | - | -
 |  | CC4 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
 |  | CC5 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350
 |  | CC6 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900
 |  | CC7 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250
 |  | CC8 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600
 |  | CC9 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
 |  | CC10 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300
 |  | CC11 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60
 |  | CC12 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70
 |  | CC13 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
 |  | CC14 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750
 |  | CC15 | - | - | - | - | - | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
 |  | CC16 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150
 |  | Total | 54730 | 48730 | 37930 | 25730 | 25730 | 26730 | 26730 | 26730 | 26730 | 26730 | 26730 | 26730
 |  | NET: | -12915 | -11230 | 6670 | 18370 | 17870 | 16370 | 15870 | 15370 | 14870 | 14370 | 13870 | 13370
 |  | 80% Availability
 |  | Reserves
 |  | Debt:
 |  | CC1 | - | 55000
 |  | CHASE | - | 6500
 |  | [NAME] | - | 10500
 |  | Union |  | 20000
 |  | SBA | 200000 | 200000
Spreadsheet: 215243d1361311639-merging-spreadsheet-data-ats-example
Sheet: Distribution

Item Code | Qty | Due Date | Comments
KI4D----RK2-X20 | 10601.00 | 04/02/13 | On time
KN02----4S2BS21 | 4316.00 | 03/07/13
KN0205004S2-S21 | 4535.00 | 03/07/13
KN04----K4DBN21 | 2092.00 | 02/27/13
KN100625K2BXNC1 | 78871.00 | 02/19/13 | On time
KN100625K2BXNC1 | 78871.00 | 03/27/13
[NAME] | 4999.00 | 03/22/13
[NAME] | 4999.00 | 04/12/13
KN2416704S4X553 | 20.00 | 01/09/13 | On time
KN4A----F6---90 | 1680.00 | 03/18/13
KN4A----F6---90 | 1680.00 | 03/25/13
KN4A----F6---90 | 1680.00 | 04/01/13 | On time
KN4C----3P1C-21 | 2285.00 | 02/20/13
[NAME] | 6417.00 | 03/01/13
[NAME] | 6417.00 | 03/08/13
[NAME] | 6417.00 | 04/10/13
Spreadsheet: 864691d1711780215-win-average-formula-round-by-round-aligw
Sheet: Sheet2

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  |  | Round | Board | Opp. # | Rating | Opponent Name | Won | Lost | Player
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Score | Opponent
 | 1 | 6 | 29 | 923 | Lightley, [NAME] | 1 | 0 | 521 | 352 | 169 |  | Round | 1 |  | Score | Spread
 | 2 | 8 | 8 | 1554 | [NAME], Justin | 1 | 1 | 388 | 429 | -41 |  | Board | 2
 | 3 | 3 | 14 | 1397 | Rea, Gwen | 2 | 1 | 504 | 332 | 172 |  | Opp. # | 3
 | 4 | 9 | 23 | 1169 | Kanshamba, Fred | 2 | 2 | 347 | 422 | -75 |  | Rating | 4
 | 5 | 6 | 7 | 1606 | Mpundu, [NAME] | 2 | 3 | 430 | 513 | -83 |  | Opponent Name | 5
 | 6 | 9 | 30 | 857 | [NAME], Rita | 3 | 3 | 467 | 268 | 199 |  | Won | 6
 | 7 | 12 | 9 | 1546 | [NAME], [NAME] | 4 | 3 | 465 | 436 | 29 |  | Lost | 7
 | 8 | 8 | 17 | 1342 | Kipkemoi, [NAME] | 5 | 3 | 470 | 377 | 93 |  | Score Player | 8
 | 9 | 7 | 16 | 1355 | [NAME], [NAME] | 6 | 3 | 390 | 388 | 2 |  | Score Oppo | 9
 | 10 | 4 | 1 | 1905 | Oyende, [NAME] | 6 | 4 | 450 | 511 | -61 |  | Spread | 10
Spreadsheet: 738476d1625055849-compare-column-from-two-sheet-and-fetch-differ-data-differ
Sheet: Differ data

Sheet 1-sheet2 diffrence | sheet2-sheet3 diffrence | sheet3-sheet4 diffrence
Spreadsheet: 68579d1269142456-auto-list-data-copy-of-auto-list-data
Sheet: Sheet1

 | ITEM | COLOUR | QTTY
 | DRESS | RED | 1 |  |  |  |  |  |  | Sum of QTTY | COLOUR
 | DRESS | BLUE | 1 |  |  |  |  |  |  | ITEM | BLUE | GREY | RED | YELLOW | Grand Total
 | [NAME] | GREY | 1 |  |  |  |  |  |  | CAP |  |  |  | 1 | 1
 | DRESS | BLUE | 1 |  |  |  |  |  |  | DRESS | 2 |  | 1 |  | 3
 | CAP | YELLOW | 1 |  |  |  |  |  |  | [NAME] |  | 1 |  |  | 1
 |  |  |  |  |  |  |  |  |  | Grand Total | 2 | 1 | 1 | 1 | 5
 | RESULT
 |  | RED | BLUE | GREY | YELLOW
 | DRESS | 1 | 2 | 0 | 0
 | [NAME] | 0 | 0 | 1 | 0
 | CAP | 0 | 0 | 0 | 1
Spreadsheet: 840936d1693206155-sum-variable-periods-and-variable-dates-offset-sumifs-book1-197-aligw
Sheet: Monthly Three Way

Profit & Loss (A$000)
Month Ended: | 2022-07-01 00:00:00
Type A Sales | 368 | 375 | 422 | 456 | 524 | 784 | 540 | 357 | 435 | 499 | 423 | 325
Type B Sales | 299 | 345 | 412 | 534 | 641 | 311 | 148 | 278 | 368 | 590 | 412 | 604
Total Revenue
Cost of Goods Sold | -528 | -540 | -625.5 | -742.5 | -873.75 | -821.25 | -516 | -476.25 | -602.25 | -816.75 | -626.25 | -696.75
Gross Profit
Other Income
Overhead Expenses | -155.66962 | -162.5200510997818 | -164.1224724354036 | -163.4002264405237 | -162.4265274634182 | -188.8609310805818 | -175.9274510433455 | -204.9003787873455 | -177.6911575137455 | -183.0672103009455 | -166.3562152545455 | -315.2818555300364
EBITDA
 | Period |  | YTD
 | 3
BOARD REPORT | Mos Ending |  | Mos Ending
 | 2022-12-01 00:00:00
Type A Sales
Type B Sales
Total Revenue
Cost of Goods Sold
Gross Profit
Other Income
Overhead Expenses
EBITDA
Spreadsheet: louise_kitchen__23089__portlandpower
Sheet: Portland Trading

Portland Trading
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Geir [NAME]
[NAME]
Spreadsheet: 859166d1707634802-rank-and-count-values-in-a-range-from-the-same-range-across-multiple-sheets-sample
Sheet: 5

Rep
[NAME]
Willow
August
[NAME]
[NAME]
Dahlia
[NAME]
[NAME]
Abigail1
Elara
Kai
Mark4
[NAME]
[NAME]
Carmen3
Tom5
[NAME]
Cleo
Hudson
Calliope