tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 135925d1326308942-conditional-formatting-multiple-rows-and-columns-book2
Sheet: Sheet1

[NAME], [NAME] | RFT | 2011-11-14 00:00:00 | 3000-01-01 00:00:00
[NAME], [NAME] | RFT | 2005-12-17 00:00:00 | 2011-09-20 00:00:00
[NAME], [NAME] | RFT | 2011-09-21 00:00:00 | 2011-11-13 00:00:00
[NAME], Olivia | FTT | 2009-07-13 00:00:00 | 2009-08-11 00:00:00
[NAME], Olivia | FTT | 2009-07-13 00:00:00 | 2009-08-11 00:00:00
[NAME], Olivia | FTT | 2009-07-13 00:00:00 | 2009-08-11 00:00:00
[NAME], Olivia | PRN | 2009-05-07 00:00:00 | 2009-07-12 00:00:00
[NAME], Olivia | PRN | 2009-05-07 00:00:00 | 2009-07-12 00:00:00
[NAME], Olivia | PRN | 2009-05-07 00:00:00 | 2009-07-12 00:00:00
[NAME], Olivia | PRN | 2009-08-12 00:00:00 | 3000-01-01 00:00:00
[NAME], Olivia | PRN | 2009-08-12 00:00:00 | 3000-01-01 00:00:00
[NAME], Olivia | PRN | 2009-08-12 00:00:00 | 3000-01-01 00:00:00
[NAME], [NAME] | RFT | 2011-04-18 00:00:00 | 2011-04-18 00:00:00
[NAME], [NAME] | PRN | 2006-05-15 00:00:00 | 2007-06-24 00:00:00
[NAME], [NAME] | RFT | 2007-06-25 00:00:00 | 2010-10-20 00:00:00
[NAME], [NAME] | RFT | 2010-10-21 00:00:00 | 2011-04-17 00:00:00
[NAME], [NAME] | RFT | 2008-08-07 00:00:00 | 2009-07-27 00:00:00
[NAME], [NAME] | RFT | 2008-08-07 00:00:00 | 2009-07-27 00:00:00
[NAME], [NAME] | RFT | 2009-09-08 00:00:00 | 3000-01-01 00:00:00
[NAME], [NAME] | RFT | 2009-09-08 00:00:00 | 3000-01-01 00:00:00
[NAME], [NAME] | PRN | 2008-07-28 00:00:00 | 2008-08-06 00:00:00
[NAME], [NAME] | PRN | 2008-07-28 00:00:00 | 2008-08-06 00:00:00
[NAME], [NAME] | RFT | 2009-07-28 00:00:00 | 2009-09-07 00:00:00
[NAME], [NAME] | RFT | 2009-07-28 00:00:00 | 2009-09-07 00:00:00
Spreadsheet: 842261d1694406324-trying-to-reference-same-cell-from-different-sheets-using-indirect-function-indirect-issue
Sheet: 3

 | 5240 W 46 Street
 |  | 1
 |  | 2023-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual
 | Starting Balance | 0
 | Income
 | Rent Up | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1550 | 1550 | 1550 | 1550
 | Rent Down | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Security Deposit | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1550 | 0 | 0 | 0 | 0
 | Total Income
 | Expenses
 | Sewer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -167.02
 | Water |  |  |  |  |  |  |  |  | -65.89
 | Insurance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Repairs |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CAPEX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Expenses
 | Debt Service | 0 |  |  |  |  |  |  |  |  |  | -1036.88
 | Cash Flow | 0
 | Ending Balance
 | Itemized Repairs & CAPEX
 | August
 | [NAME]
Spreadsheet: 102767d1300726871-sort-and-redisplay-list-multiplereturnrowtocolumn1
Sheet: Sheet1

Item | Location |  | Unique List | Results
Beer | Fridge |  | Fridge | Beer | Water | Juice
Belt | Waist |  | Waist | Belt
Garbage | Basket |  | Basket | Garbage
Water | Fridge |  | Head | Brain
Brain | Head
Juice | Fridge
Spreadsheet: 714955d1611480281-determine-number-of-staff-using-countifs-on-shift-gk
Sheet: Sheet1

 | Start time | End time |  | Time | Number of staff on |  | By my calculations should be:
 | 10:00:00 | 18:00:00 |  | 10:00:00 |  |  | 2
 | 10:00:00 | 18:00:00 |  | 11:00:00 |  |  | 2
 | 12:00:00 | 00:00:00 |  | 12:00:00 |  |  | 7
 | 12:00:00 | 00:00:00 |  | 13:00:00 |  |  | 7
 | 12:00:00 | 00:00:00 |  | 14:00:00 |  |  | 8
 | 12:00:00 | 18:00:00 |  | 15:00:00 |  |  | 8
 | 12:00:00 | 22:00:00 |  | 16:00:00 |  |  | 12
 | 14:00:00 | 00:00:00 |  | 17:00:00 |  |  | 13
 | 16:00:00 | 00:00:00 |  | 18:00:00 |  |  | 18
 | 16:00:00 | 00:00:00 |  | 19:00:00 |  |  | 18
 | 16:00:00 | 00:00:00 |  | 20:00:00 |  |  | 19
 | 16:00:00 | 00:00:00 |  | 21:00:00 |  |  | 19
 | 16:20:00 | 00:20:00 |  | 22:00:00 |  |  | 17
 | 18:00:00 | 00:00:00 |  | 23:00:00 |  |  | 17
 | 18:00:00 | 00:00:00 |  | 00:00:00 |  |  | 0
 | 18:00:00 | 00:00:00 |  | 01:00:00 |  |  | 0
 | 18:00:00 | 00:00:00 |  | 02:00:00 |  |  | 0
 | 18:00:00 | 00:00:00
 | 18:00:00 | 00:00:00
 | 18:00:00 | 00:00:00
 | 18:00:00 | 00:00:00
 | 18:00:00 | 22:00:00
 | 20:00:00 | 00:00:00
Spreadsheet: darrell_schoolcraft__7303__imball0201
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 10708 | 11500 | 8161 | 8800 |  | 7800
2 | 10744 | 11500 | 7789 | 8800 | 70 | 7800
3 | 10863 | 11500 | 7744 | 8800 | 3642 | 7800
4 | 10242 | 11500 | 8002 | 8800 | 5606 | 7800
5 | 10778 | 10500 | 8365 | 7800 | 7664 | 7800
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | 4885
2002-01-05 00:00:00
CBS Volume
 |  |  | -125383
Spreadsheet: 1156f9ed-e7a4-47e0-8b31-a47a8a7e86e5
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 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Str.
 |  |  | pieczęć |  |  |  | [NAME] spisu z natury - uniwersalny
 |  |  |  |  |  |  | Rodzaj inwentaryzacji
 |  |  |  |  |  |  | [NAME] prowadzenia
 | (nazwa i adres jednostki inwentaryzowanej) |  |  |  |  |  |  |  |  | (imię i nazwisko osoby [NAME])
 | [NAME] [NAME] (zespołu spisującego) |  |  |  |  |  |  |  |  | Inne osoby obecne przy spisie:
 | (imię, nazwisko i stanowisko służbowe) |  |  |  |  |  |  |  |  | (imię, nazwisko i stanowisko służbowe)
 | spis rozpoczęto dnia |  |  |  |  | o godz. |  |  |  | [NAME] |  |  |  |  |  |  | o godz.
 | Lp. | KTM - symbol indeksu |  |  | Nazwa (określenie) przedmiotu spisywanego |  |  |  |  |  | J.m. | Ilość stwierdzona |  | Cena |  | Wartość |  | Uwagi
 | 1 | 2 |  |  | 3 |  |  |  |  |  | 4 | 5 |  | 6 |  | 7 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | Suma strony
 | © www.signform.pl Sp. z o.o., e-mail: [NAME], tel./fax. (0-22) 626 92 95, (0-22) 626 92 97
Spreadsheet: 330578d1404805468-plotting-year-wise-maximum-value-and-occurance-date-the-input-date-is-in-text-format-plotting-year-wise-maximum-value-and-date-
Sheet: analysis

Yearwise | [NAME]. Value | [NAME]. Date | [NAME]. Day | Min. Value | Min. Date | Min. Day
2007
2008
2009
2010
2011
2012
2013
2014
Answer for cross verification
2007 | 345.6 | 20070504 |  | 239.55 | 20070203
2008 | 387.35 | 20080702
2009 | 347.15 | 20091231
2010 |  | 20101111
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 15c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | 0 | 438 | 0 | 25
Index/OTHER* | 277291 | 11030 | 233152 | 3268
TOTAL | 277291 | 11468 | 233152 | 3293
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 840174d1692533814-text-to-column-delimited-with-multiple-dash-sample
Sheet: Sheet1

Brake Line Braided 2-3 Inch 50-75mm Front Each - GQBRBRL3F
Brake Line Braided 2-3 Inch 50-75mm Rear Each - GQBRBRL3R
[NAME] 4-5 Inch 100-125mm Front Each - GQBRBRL5F
[NAME] 4-5 Inch 100-125mm Rear Each - GQBRBRL5R
[NAME] 6 Inch 150mm Front Each - GQBRBRL6F
[NAME] 6 Inch 150mm Rear Each - GQBRBRL6R
[NAME] Each - GQBRBRLSF
[NAME] Each - GQBRBRLSR
[NAME] Rubber 2-3 Inch 50-75mm Front Each - GQRBRL3F
[NAME] Rubber 2-3 Inch 50-75mm Rear Each - GQRBRL3R
[NAME] Rubber 4-5 Inch 100-125mm Front Each - GQRBRL5F
[NAME] Rubber 4-5 Inch 100-125mm Rear Each - GQRBRL5R
[NAME] Rubber 6 Inch 150mm Front Each - GQRBRL6F
[NAME] Rubber 6 Inch 150mm Rear Each - GQRBRL6R
Caliper Lines Braided Front Coil Pair - GQBRCLLFC
Caliper Lines Braided Front Leaf Pair - GQBRCLLFL
Caliper Lines Braided Rear Coil Pair - GQBRCLLRC
Caliper Lines Braided Rear Leaf Pair - GQBRCLLRL
Caliper Lines Rubber Front Pair - GQCRBRLF
Caliper Lines Rubber Rear Pair - GQCRBRLR
Spreadsheet: 3243af72-f687-4c33-8aec-50a935cc328e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CABB | Test | CABB | Cabbage, IgE | Cabbage, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CABB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CABB | Result | CABB | Cabbage, IgE | Cabbage, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7169-6
Spreadsheet: 0c442de7-a4cd-44fd-a47e-26f574f3da15
Sheet: Sheet1

 | First Name | Last Name | City | Country | club
1 | Yamile | Abouzaid | [NAME] | Mexico
2 | Christian | [NAME] | Aiseau | Belgique
3 | [NAME] | Barbosa | [NAME] | France
4 | Alexiane | BAUDOT TEUX | Bègles | France
5 | [NAME] | Beetles | Bristol | United Kingdom
6 | [NAME] | [NAME] | London | United Kingdom
7 | Emmanuelle | Blanquart | PARIS | France
8 | Simone | Boehm | Frankfurt/Main | Germany
9 | Astrid | Boje-Kumpf | Strande | Germany
10 | [NAME] | [NAME] | Bayswater | Australia
11 | Michelle | Boyes | [NAME] | Australia
12 | Sophie | Caillens | soustons | France
13 | Christine | Couture | Liévin | France
14 | Cara | Cunniff | [NAME] | France
15 | Alexandra | Field | High wycombe | United Kingdom
16 | Camilla | Franks | Vejbystrand | Sweden
17 | [NAME] | [NAME] | peschiera borromeo | Italy
18 | Katell | Guillemot | Le Trévoux | France
19 | [NAME] | GUINOISEAU | Issy les moulineaux | France
20 | [NAME] | [NAME] | Kilmaurs | United Kingdom
21 | [NAME] | Holbrook | Cowes | United Kingdom
22 | Katia | [NAME] | [NAME] | Belgique
23 | Helen | [NAME] | Chesterfield | United Kingdom
24 | Sandrine | Kranck | Rossemaison | Suisse
25 | [NAME] | Lamarre | Bend | United States
26 | Debbie | Lammiman | Portchester | United Kingdom
27 | Helena | [NAME] | Copenhagen | Denmark
28 | Nathalie | LE PICARD | LAGORD | France
29 | Christelle | Lelievre | Le touquet Paris plage | France
30 | Kimberly | Lerman | Atlanta | United States
31 | [NAME] | [NAME] | Luton | United Kingdom
32 | [NAME] | Lochkovitch | La Roche Noire | France
33 | [NAME] | [NAME] | agnez les duisans | France
34 | Sonja | Massing-Steiner | Kaindorf | Austria
35 | Candice | McDonald | London | United Kingdom
36 | Helene | [NAME] | TREIZE-SEPTIERS | France
37 | [NAME] | [NAME] | Sausset les Pins | France
38 | [NAME] | Saunder | Prahran | Australia
39 | Astrid | Schmitz | Schoeneck | France
40 | BELINDA | SECCOMBE | Aroona | Australia
41 | [NAME] | Suter | Abergavenny | United Kingdom
42 | Soazig | [NAME] | Paris | France
43 | Tara | Truman | Dursley | United Kingdom
44 | Matilde | Vazquez | london | United Kingdom
45 | CHRISTINE | VIRIEUX | BIOT | France
46 | Géraldine | [NAME] | NICE | France
47 | Debs | White | Yarm | United Kingdom
48 | [NAME] | Wilkinson | London | United Kingdom
 | 48 | 48 | 48 | 48
Spreadsheet: 131290d1322844561-excel-2007-sorting-by-array-copy-of-sample-two-sorts-by-array
Sheet: infosheet

Name | Month | Dollar Amt
Shawn | 27 | 26623
[NAME] | 33 | 26513
[NAME] | 17 | 14325
[NAME] | 32 | 34466
[NAME] | 25 | 23938
[NAME] | 32 | 23790
[NAME] | 22 | 18343
[NAME] | 34 | 31587
[NAME] | 27 | 20644
[NAME] | 33 | 30999
[NAME] | 27 | 22788
[NAME] | 46 | 36258
[NAME] | 33 | 26408
Ulrich | 29 | 20925
[NAME] | 52 | 37187
[NAME] | 33 | 27930
Justin | 25 | 22287
[NAME] | 14 | 11982
[NAME] | 22 | 16321
[NAME] | 11 | 10735
Jermaine | 23 | 18417
[NAME] | 28 | 20470
[NAME] | 34 | 20037
Jerrel | 19 | 18886
[NAME] | 23 | 21186
[NAME] | 57 | 44453
Nathan | 13 | 12587
[NAME] | 8 | 7080
[NAME] | 2 | 2113
[NAME] | 0 | 0
Todd | 0 | 0
[NAME] | 0 | 0
[NAME] | 0 | 0
Shane | 0 | 0
[NAME] | 0 | 0
[NAME] | 0 | 0
Spreadsheet: 120826d1315551623-adding-multiple-columns-with-similar-criteria-excelforum
Sheet: Sheet2

 | Red | Blue | Yellow | Green | Purple | Orange | Pink | [NAME] | Gray
Name1
[NAME]
Name3
Name4
Name5
Name6
Name7
Name8
Name9
Name10
Name11
Name12
Spreadsheet: 217933d1362256110-make-a-unique-list-from-data-table-unique-list_from_data_table
Sheet: Sheet1

 |  |  |  | ID |  |  | ID
 |  |  |  | 158 | <----ID comes from Data Validation |  | 153
 | DATA TABLE |  |  | SUM TABLE |  |  | 158
 | ID | Name |  | Name |  |  | 160
 | 158 | n1 |  | n1 | [NAME] will place from here to bottom |  | 161
 | 158 | n2 |  | n2 |  |  | 178
 | 160 | n1 |  | n3 |  |  | 188
 | 153 | n2 |  | n4 |  |  | 190
 | 158 | n3 |  | blank
 | 161 | n2 |  | blank
 | 178 | n5 |  | blank
 | 158 | n4 |  | blank
 | 158 | n3 |  | blank
 | 160 | n6 |  | blank
 | 158 | n1 |  | blank
 | 158 | n4 |  | blank
 | 160 | n3 |  | blank
 | 178 | n2 |  | blank
 | 160 | n3 |  | blank
 | 188 | n2 |  | blank
 | 190 | n1 |  | blank
 | 158 | n4 |  | blank
 | 153 | n3 |  | blank
 | 160 | n3 |  | blank
 |  |  |  | Names
 |  |  |  | will come only I2 cell refferenced names
 |  |  |  | example: if I2 = 158
 |  |  |  | in SUM TABLE "n1" "n2" "n3" "n4"  will be listed
 |  |  |  | as a unique list ( one time to be placed)
 |  |  |  | NOT n5 and n6
 |  |  |  | From H5 to H24  a FORMULA needed
 |  |  |  | to replace the Names from Data Table to SUM table
Spreadsheet: 748735d1632319356-work-out-daily-amount-to-target-31-day-figures
Sheet: 8th

 |  |  |  | TURNOVER |  |  |  |  | REVENUE
 | AREA 3 |  |  | Target | Needed Daily | Actual | [NAME] |  | Target | Needed Daily | Actual | [NAME] |  | [NAME]'s | ATV |  | [NAME] | SALT £ |  | TMC |  | BB+ |  | Errors
 | Asda - Aintree
 | Asda - Huyton
 | Asda - Hunts Cross
 | Asda - Horwich
 | Asda - Leigh
 | Asda - Burnley
 | Asda - Westbrook
 | Asda - Widnes
 | Asda - Bromborough
 | Asda - Accrington
 | Asda - Colne
 | Asda - Clayton Green
 | Asda - Runcorn
 | Asda - Blackburn
 | Asda - Walton
 | Asda - Blackpool
 | Asda - Wigan
 | Asda - Preston
Spreadsheet: 713393d1610692465-data-presentation-in-a-column-orders_export-sample
Sheet: Sheet1

Jew | 2-scrap-AW | No | OOJHK | 450 | 27 | 0.1
Jew | R&K-AW | No | OOJHK | 450 | 30 | 0.1
Jew | R&K-AW | No | OOJHK | 1750 | 160 | 0.1
Jew | R&K-AW | No | OOJHK | 2550 | 80 | 0.1
Leather | R&K-AW | Yes |  | 600 | 120
Jew | R&K-AW | No |  | 2550 | 80
Watch | R&K-AW | Yes |  | 1950 | 390
Sunglasses | R&K-AW | Yes |  | 880 | 176
Jew | 2-scrap-AW | No |  | 498 | 30
Watch | R&K-AW | Yes |  | 4000 | 800
Watch | R&K-AW | Yes |  | 4500 | 900
Sunglasses | R&K-AW | Yes |  | 860 | 172
Jew | 2-scrap-AW | No |  | 1100 | 80
Leather | R&K-AW | Yes |  | 650 | 130
Jew | R&K-AW | No |  | 1750 | 80
Watch | R&K-AW | Yes |  | 1500 | 300
Jew | R&K-AW | No |  | 2300 | 80
Spreadsheet: ebefff19-afae-4c1b-b66f-c4916ce64f4b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
35929073 | 2013-05-13 21:44:45 | AXIS | 1 | 7 | 2 | 268146 | JML1 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
35929354 | 2013-05-13 22:02:25 | ALLIES | 1 | 7 | 5 | 268146 | JML1 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
36033166 | 2013-05-20 21:35:49 | AXIS | 0 | 2 | 6 | 1330337 | Unrealik193 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
36033478 | 2013-05-20 21:55:33 | ALLIES | 0 | 5 | 6 | 1330337 | Unrealik193 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
36047158 | 2013-05-21 21:11:09 | ALLIES | 0 | 4 | 6 | 3120 | gonzalan | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
36047606 | 2013-05-21 21:32:58 | AXIS | 1 | 6 | 2 | 3120 | gonzalan | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
36076280 | 2013-05-23 20:53:02 | ALLIES | 1 | 6 | 1 | 761625 | Gateam | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
Spreadsheet: 870607d1717084862-if-refund-then-lookup-corresponding-order-in-same-table-and-return-a-fee-value-refund-order-table-example-aligw
Sheet: Sheet1

 |  |  | Type | ID | SKU | Quantity | Sales | Shipping Credits | Handling Fees | Service Fees
 |  |  | Order | 1234 | ABCD | 1 | 24.98 | 8.56 | 0
 |  |  | Refund | 1234 | ABCD | 1 | -24.98 | 0 | 0
 |  |  | Order | 1234 | MNOP | 1 | 36 | 4 | 0
 |  |  | Order | 1234 | NOPQ | 1 | 14 | 0 | 0
 |  |  | Order | 2345 | BCDE | 1 | 84.99 | 11.57 | 0
 |  |  | Refund | 2345 | BCDE | 1 | -84.99 | 0 | 0
 |  |  | Order | 3456 | CDEF | 1 | 119.99 | 12.75 | -21.22
 |  |  | Refund | 3456 | CDEF | 1 | -119.99 | -12.75 | 12.75
 |  |  | Order | 3456 | JKLM | 1 | 40 | 3.98 | 6
 |  |  | Order | 4567 | DEFG | 1 | 75.91 | 9.18 | 0
 |  |  | Refund | 4567 | DEFG | 1 | -75.91 | 0 | 0
 |  |  | Order | 5678 | HIJK | 101 | 3731.95 | 0 | 0
 |  |  | Refund | 5678 | HIJK | 4 | -147.8 | 0 | 0
 |  |  | IF its an order then if its Handling Fees < 0 then (Handling Fees + Shipping Credits)/quantity, if not then if [NAME] fees are zero and shipping fees are 0 then -$3.98 is the charge, if they aren't then $0
 |  | Order
 | IF
 |  | Refund | IF it a refund AND shipping credits = 0 then we need to find the corresponding "order" by matching SKU and ID and if for that matching "order" Shipping credits < 0 then the Service fee refund would be $0, in all other cases the service refund would be the opposite of the service fee charged for the corresponding order
Spreadsheet: 858572d1707213494-identify-and-count-consecutive-negative-figures-in-a-dataset-book1
Sheet: Sheet1

2002-04-10 00:00:00 | -25.89999
2002-04-11 00:00:00 | -23.78478
2002-04-12 00:00:00 | -9.33111
2002-04-13 00:00:00 | -0.58254
2002-04-14 00:00:00 | 3.33667
2002-04-15 00:00:00 | 8.56847
2002-04-16 00:00:00 | 12.43831
2002-04-17 00:00:00 | 11.18699
2002-04-18 00:00:00 | 9.47207
2002-04-19 00:00:00 | 7.91838
2002-04-20 00:00:00 | -1
2002-04-21 00:00:00 | -2
2002-04-22 00:00:00 | 4.1068
2002-04-23 00:00:00 | 2.70522
2002-04-24 00:00:00 | 1.4354
2002-04-25 00:00:00 | 0.29924
2002-04-26 00:00:00 | -1.01067
2002-04-27 00:00:00 | -2.00181
2002-04-28 00:00:00 | -3.15657
2002-04-29 00:00:00 | -4.19175
2002-04-30 00:00:00 | -5.51461
2002-05-01 00:00:00 | -6.15286
2002-05-02 00:00:00 | -6.99173
2002-05-03 00:00:00 | -7.81675
2002-05-04 00:00:00 | -8.58129
2002-05-05 00:00:00 | -9.12188
Spreadsheet: 867088d1713973590-if-cell-then-return-a-list-s1-science-practical-skills-level-4-23-24-aligw
Sheet: Raw data

Id | Start time | Completion time | [NAME] | Name | Pupil choice | Class | Class1 | 1.1 | 1.2 | 1.3 | 1.4 | 1.5 | 1.6 | 1.7 | 1.8 | 1.9 | 1.10 | 1.11 | Investigation completed
PROTECTED | PROTECTED | PROTECTED | PROTECTED | [NAME] | Whole class | 1.1 |  |  |  |  |  |  |  |  |  |  |  |  | Elodea bubbles
PROTECTED | PROTECTED | PROTECTED | PROTECTED | [NAME] | Whole class | 1.4 |  |  |  |  |  |  |  |  |  |  |  |  | The model gut
PROTECTED | PROTECTED | PROTECTED | PROTECTED | [NAME] | Whole class | 1.2 |  |  |  |  |  |  |  |  |  |  |  |  | Microorganisms
Spreadsheet: 42ccf008-b7d8-4231-a7f9-56ab31e845b2
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
Prospetto di qualificazione (I parte) |  |  |  |  |  | LAVORI ANALOGHI |  |  |  |  | [NAME]. 22.2 lettera b)
Importo lavori nel quinquennio
 | cifra in lavori |  |  |  |  |  |  |  | classe | Euro |  | doppio
anno | dichiarata |  | % manodopera |  |  |  |  |  | I | 258228 |  | 516457
2004 |  |  |  |  |  |  |  |  | II | 516457 |  | 1032913
2005 |  |  |  |  |  |  |  |  | III | 1032913 |  | 2582284
2006 |  |  |  |  |  |  |  |  | IV | 2582284 |  | 5164569
2007 |  |  |  |  |  |  |  |  | V | 5164569 |  | 10329138
2008
totali
Prospetto dei lavori eseguiti
numero | periodo | committente |  | oggetto |  | importo contabilizzato |  |  |  | documento attestante l'esecuzione |  | note
 |  |  |  |  |  | dichiarato |  | [NAME]
Istruzioni per la compilazione del prospetto
numero: numero progressivo del documento da riportare sulla documentazione allegata a comprova
periodo: indicare [NAME] e fine lavori; se i lavori [NAME] e o termine in anni diversi da quelli relativi [NAME], scomputare gli importi non attribuibili
committente: indicare denominazione, ragione sociale e sede del soggetto committente
[NAME] per contratti affidati da [NAME], SeTA SpA, Brenta Servizi S.pA, Altopiano Servizi Srl, inserire, se noto, [NAME] (P….) o [NAME]
importo dichiarato: [NAME] [NAME] dell'I.V.A
documento attestante l'esecuzione: es.: [NAME]; collaudo; fattura quietanzata dal committente; SAL del committente
l'importo deve essere dichiarato [NAME] lavorazioni affidate in subappalto
CON RIFERIMENTO A QUANTO RIPORTATO AGLI ARTT. 23.1.b, 23.2.b E 23.3.b DEL REGOLAMENTO, SI SPECIFICA CHE LA  VERSIONE DEDICATA AI CONSORZI DIFFERISCE NEL SENSO CHE DEVE ESSERE COMPILATO UN SINGOLO PROSPETTO PER OGNI IMPRESA INTERESSATA ALLA QUALIFICAZIONE E FACENTE PARTE DEL CONSORZIO O DEL RAGGRUPPAMENTO TEMPORANEO D'IMPRESE
NB: Se le caselle da compilare non sono sofficienti per inserire tutti i dati necessari, stampare e compilare più volte la parte del prospetto. Le istruzioni possono essere cancellate
Spreadsheet: 710383d1608910878-getting-dates-from-main-sheet-to-sub-sheet-loop-different-variables-to-consider-excel-file
Sheet: Sheet 2

 |  | ID | [NAME] |  |  |  |  |  | 1 |  |  |  |  |  | ???
 |  |  | -
 |  | 4 | ELEMENT 1
 | 1 | 5 | ELEMENT 2 |  |  |  |  | last row | weeks
 |  | 6 | ELEMENT 3 |  |  |  |  |  | 1
 |  | 7 | ELEMENT 4
 |  | 8 | ELEMENT 5
 |  | 9 | ELEMENT 6
 |  | 10 | ELEMENT 7
 |  | 11 | ELEMENT 8
 |  | 12 | ELEMENT 9
 |  | 13 | ELEMENT 10
 |  | 14 | ELEMENT 11
 |  | 15 | ELEMENT 12
 |  | 16 | ELEMENT 13
 |  | 17 | ELEMENT 14
 |  | 18 | ELEMENT 15
 |  | 19 | ELEMENT 16
 |  | 20 | ELEMENT 17
 |  | 21 | ELEMENT 18
 |  | 22 | ELEMENT 19
 |  | 23 | ELEMENT 20
 |  | 24 | ELEMENT 21
 |  | 25 | ELEMENT 22
 |  | 26 | ELEMENT 23
 |  | 27 | ELEMENT 24
 |  | 28 | ELEMENT 25
 |  | 29 | ELEMENT 26
 |  | 30 | ELEMENT 27
 |  | 31 | ELEMENT 28
 |  | 32 | ELEMENT 29
 |  | 33 | ELEMENT 30
 |  | 34 | ELEMENT 31
 |  | 35 | ELEMENT 32
 |  | 36 | ELEMENT 33
 |  | 37 | ELEMENT 34
 |  | 38 | ELEMENT 35