tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 65437d1266162671-conditional-formatting-for-calendar-calendar
Sheet: Blad1

 |  |  |  |  |  |  | Month | Match
 |  |  |  |  |  |  | Week | 9 |  |  |  |  |  |  | 10 |  |  |  |  |  |  | 11 |  |  |  |  |  |  | 12
 |  |  | From | Days | To |  | Day | 2010-03-01 00:00:00 | 2010-03-02 00:00:00 | 2010-03-03 00:00:00 | 2010-03-04 00:00:00 | 2010-03-05 00:00:00 | 2010-03-06 00:00:00 | 2010-03-07 00:00:00 | 2010-03-08 00:00:00 | 2010-03-09 00:00:00 | 2010-03-10 00:00:00 | 2010-03-11 00:00:00 | 2010-03-12 00:00:00 | 2010-03-13 00:00:00 | 2010-03-14 00:00:00 | 2010-03-15 00:00:00 | 2010-03-16 00:00:00 | 2010-03-17 00:00:00 | 2010-03-18 00:00:00 | 2010-03-19 00:00:00 | 2010-03-20 00:00:00 | 2010-03-21 00:00:00 | 2010-03-22 00:00:00 | 2010-03-23 00:00:00 | 2010-03-24 00:00:00 | 2010-03-25 00:00:00 | 2010-03-26 00:00:00 | 2010-03-27 00:00:00 | 2010-03-28 00:00:00
 |  |  | 2010-03-04 00:00:00 | 5
Spreadsheet: 792157d1660755953-amalgamating-and-deleting-rows-dpa-for-forum-sanitised-large-data
Sheet: Sheet3

 | Counts | 10 |  | 10 | 10 | 10 | 10 | 10
Passenger Assist List |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-04 00:00:00
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Departure
Job | Assigned To | Name | HIP | VIP | W/C | BR W/C | Mob Imp | [NAME] | Time | Head Code | From | [NAME] | Time | Head Code | Destination | [NAME] | Additional Comments
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Spreadsheet: 160982d1339351792-excel-2008-find-lower-price-from-multiple-sheets-book1-shokarta-oeldere2-
Sheet: Sheet4

shop: | name3 | sheet 4
id | price
4 | 3 | sheet 4
2 | 1 | sheet 4
3 | 4 | sheet 4
5 | 11 | sheet 4
6 | 45 | sheet 4
Spreadsheet: 853897d1703852653-how-to-count-specified-data-from-sheet-template-3-2-
Sheet: December

STATES | PRODUCT
Alabama | LAPTOP
Alaska | MOBILE
Arizona | LAPTOP
Arkansas | PC
California | PC
Colorado | PC
Alabama | MOBILE
Delaware | LAPTOP
Alabama | LAPTOP
Georgia | MOBILE
California | MOBILE
Alabama | MOBILE
Illinois | TV
Indiana | TV
Alabama | TV
Alabama | TV
California | LAPTOP
Louisiana | LAPTOP
California | PC
California | PC
Massachusetts | MOBILE
Michigan | MOBILE
Alabama | TV
North Dakota | TV
California | TV
Alabama | TV
California | MOBILE
Alabama | MOBILE
New Hampshire | TV
New Jersey | TV
California | TV
New York | TV
North Carolina | MOBILE
North Dakota | MOBILE
Ohio | MOBILE
North Dakota | TV
Oregon | TV
North Dakota | TV
Rhode Island | TV
North Dakota | LAPTOP
North Dakota | LAPTOP
Spreadsheet: 140093d1328622649-daily-food-calculator-feb-food-total-values
Sheet: 2-6-12

 |  | Breakfast | Food Item | Cost | Daily Points
 |  |  | 1 Cup Cheerios | 0.19 | 5
 |  |  | 1/2 Cup Milk | 0.19 | 1
 |  | Lunch | Food Item | Cost | Daily Points
 |  |  | 1 English Muffin | 0.28 | 4
 |  |  | 24 [NAME] | 0.192 | 2.8
 |  |  | 28 [NAME] TJ Turkey | 0.42 | 1
 |  |  | 1/2 Cucumber | 0.67 | 0
 |  | Gym | 1/2 Cup Milk | 0.19 | 1
 |  | Dinner | Food Items | Cost | Daily Points
 |  |  | 1 curry chicken | 1.31 | 12
 |  |  | 1 piece chocolate | 0 | 2
 |  |  | 1 tea | 0.08 | 0
Spreadsheet: 0d6a4786-16d2-4a68-8f17-308fea87cdea
Sheet: Sheet1

Table 2--Feed and residual use of wheat and coarse grains, 6/14/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Market year and quarter 1/ |  | Corn  (million metric tons) | Sorghum  (million metric tons) | Barley  (million metric tons) | Oats  (million metric tons) | Feed grains  (million metric tons) | Wheat  (million metric tons) | Energy feeds  (million metric tons) | Grain consuming animal units  (millions) | Energy feeds per grain consuming animal unit  (tons)
2011/12 | Q1 Sep-Nov | 46.36464663783633 | 1.125526280695738 | -0.04624466235028046 | 0.3373031748753299 | 47.78123143105712 | -0.4361019712222776 | 47.34512945983484
 | [NAME] | 39.12698684853912 | 0.144685120623853 | 0.2708709248116004 | 0.2283448137594563 | 39.77088770773403 | 1.192639826691378 | 40.96352753442541
 | [NAME] | 21.78890349456733 | 0.3898827100518819 | 0.02449399488891973 | 0.2052333688042665 | 22.40851356831239 | -1.866224686136671 | 20.54228888217572
 | [NAME] | 8.177732055653985 | 0.1344738463101611 | 0.9865092519261807 | 0.7466332096840183 | 10.04534836357435 | 11.66425809050259 | 21.70960645407694
 | MY Sep-Aug | 115.4582690365968 | 1.794567957681634 | 1.23562950927642 | 1.517514567123071 | 120.0059810706779 | 10.55457125983502 | 130.5605523305129 | 92.63541811668705 | 1.409402094629226
2012/13 | Q1 Sep-Nov | 52.32498269544622 | 1.999784089970979 | 0.0731989429480428 | 0.3741566581481998 | 54.77212238651344 | -0.8283324760435123 | 53.94378991046992
 | [NAME] | 27.3857994703854 | 0.2440545363332127 | 0.2257366568962843 | 0.3444291130180139 | 28.20001977663291 | 0.2446133622906784 | 28.44463313892359
 | MY Sep-Aug | 111.7651914931449 | 2.540117988480565 | 1.944061158783683 | 1.581475645258008 | 117.8308462856671 | 7.930937820633198 | 125.7617841063003 | 91.31942363555041 | 1.377163577030524
2013/14 | MY Sep-Aug | 132.0861354009894 | 3.048141586176679 | 0.9982663694728622 | 1.589846776315193 | 137.7223901329541 | 5.170954476549722 | 142.8933446095039 | 90.93066233366199 | 1.571453907210853
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Data run: 6/14/2013
Spreadsheet: 50985d1250593001-excel-2007-colour-the-right-answer-ponudbe
Sheet: Var. Žica

VAR. ŽICE | MIG 308LSi | MIG 316LSi | TIG 308LSi |  |  |  | TIG 316LSi
Dimenzije | [NAME] | [NAME] | [NAME] | Ø1.60 | Ø2.0 | Ø2.40 | [NAME] | Ø1.60 | Ø2.0 | Ø2.40 | Ø3.20
Mibra €/Kg | 5.4 | 6.8 | 12.98 | 5.9 | 6.9 | 5.5 | 14.5 | 7.1 | 6.89 | 6.8 | 8.5
Pagatti €/Kg | 5.38 | 6.29 |  | 5.65 | 5.37 | 5.25 |  | 6.62 | 6.34 | 6.29 | 6.14
[NAME] €/Kg
Spreadsheet: 113850d1309748068-averageif-function-sumproducesubforaverageifs
Sheet: Sheet1

Numbers | Names | Sum | Count | Average | All Together |  |  | Or like you want |  | Average ifs
2 | [NAME] |  |  |  |  |  |  | [NAME]
6 | Fred |  |  |  |  |  |  | Fred
8 | [NAME] |  |  |  |  |  |  | [NAME]
5 | [NAME]
7 | Fred |  |  |  |  |  |  |  |  | ^^ AverageIfs formula above
4 | [NAME]
8 | [NAME]
9 | Fred
6 | [NAME]
5 | [NAME]
1 | Fred
6 | [NAME]
Spreadsheet: 858002d1706808605-index-small-repeatation-excel-test
Sheet: Statement

 | Customer Name | Customer 3
 | Month of Claim | March
 |  |  |  | Total:
 | Account Number | Ref No | Month | Discount | Usage in KWH | Total Value | [NAME] | Sub Total.
 |  | 8830684905
 | [NAME] | 8830684905
 | [NAME] | 8830684905
 | [NAME] | 8830684905
 | [NAME] | 8830684905
 | [NAME] | 8830684905
 | AN731 | 8918273605
 | AN731 | 8918273605
 | AN731 | 8918273605
 | AN731 | 8918273605
 | AN731 | 8918273605
 | AN731 | 8918273605
Spreadsheet: 36481d1234364260-invoice-address-query-invoice-test
Sheet: INVOICE

INVOICE
Invoice Date |  | Invoice Number |  | Terms
 |  |  |  | 7 Days
Ref:
Invoice To | Mr A
Ref | Description |  |  |  |  |  |  |  | Cost
 |  |  |  |  |  |  | Nett Total
 |  |  |  |  |  |  | VAT @ 15%
A. A.Price t/a Anthony Price and Sons |  |  |  |  |  |  | Total
Spreadsheet: 766088d1643745368-averaging-values-based-on-multiple-conditions-sample-10-
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 |  |  | Start row | 3
A | 1 | 78 |  |  |  |  |  |  | Start column | C
A | 2 | 99 |  | 83 |  |  |  |  | End row | 5
A | 3 | 72 | 93 |  | 79 | 85 |  |  | End Column | E
A | 4 | 83 | 89 |  |  | 75
B | 1 | 89 |  | 82
B | 2 |  |  |  | 93 | 96
B | 3 | 81 |  | 72
B | 4 |  |  |  |  | 91
C | 1 | 77
C | 2 |  | 91 | 79
C | 3 |  |  |  | 89
C | 4 | 92 |  | 84 | 78
Spreadsheet: 882568d1730966193-input-1-to-maybe-7-sku-numbers-to-return-groups-of-rows-find-groups-with-components-jt-
Sheet: Sheet1

Case SKU | Material description | Component | Material description | Ratio
9800001245 | ASTMNTS CRL SHPR X48 | [PHONE] | ASTMNTS CRL 8.56OZX12 | 48 |  | To unmerge cells and fill empty cells with texts above
123456789 | ASTMNTS 240CT | 9800006353 | Red | 80 |  | With cursor anywhere inside the source data > Ctrl+A to select entire range > Unmerge cells
 |  | 9800006357 | Blue | 80 |  | > Ctrl+G > Special > Blanks > OK > Type "=" (without double quotes) then move cursor up 1 time (row) > Ctrl+Enter
 |  | 9800006356 | Yellow | 40 |  | > Ctrl+A to select the entire range again > Ctrl+C > Ctrl+Alt+V > Paste Values > OK
 |  | 9800008635 | Green | 40
9800033873 | ASTMNTS X276 | 9800015503 | Purple | 276
9800056677 | ASTMNTS X216 | 9800030528 | teal | 216
9800028774 | ASTMNTS X288 | 9800015535 | orange | 288
9800078993 | ASTMNTS X36 | 9800019446 | beige | 36
9800063993 | ASTMNTS  X144 | 9800023584 | white | 144
987654321 | ASTMNTS 960ct | 9800006353 | Red | 320
 |  | 9800006357 | Blue | 320
 |  | 9800006356 | Yellow | 160
 |  | 9800008635 | Green | 160
986271658 | ASTMNTS X33 | 9862540320 | crunch | 15
 |  | 9862775537 | space | 18
9862710566 | ASTMNTS X36 | 9864121325 | nature | 18
 |  | 9862710138 | butter | 18
9862781065 | ASTMNTS RX33 | 9867770325 | grass | 18
 |  | 9801126984 | fiber | 32
9800028932 | ASTMNTS X156 | 9804423144 | flake | 72
 |  | 9804427010 | giant | 84
654321987 | ASTMNTS CRL 120CT | 9800006353 | Red | 40
 |  | 9800006357 | Blue | 40
 |  | 9800006356 | Yellow | 20
 |  | 9800008635 | Green | 20
9800024446 | ASTMNTS X36 | 9805523856 | snack | 18
 |  | 9800445403 | snacks | 18
Spreadsheet: 766611d1643965091-using-a-data-table-to-replace-time-values-with-points-values-hav-time-sheets-demo
Sheet: Demo

2022-01-01 00:00:00 | 1 |  | 2 |  | 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 |  | 30 |  | 31
Grinders | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins | Hrs | Mins
100-180mm |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 30 | 2 |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 30
220-300mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 15
Flap disc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 7 |  | 1 | 30
Needle scaler |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
Nibbler / beveller |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
ELV (400pts [NAME])
Spreadsheet: 806043d1669071812-formula-to-sum-values-in-different-range-sizes-new-microsoft-excel-worksheet-6-
Sheet: Sheet1

82 | 131 | 137
130 | 201 | 238
96 | 122 | 176 |  | Both B2 and C2 are red. Sum column A until a green row appears in either column B or C. Only 2 rows are to be sumed up.
108 | 146 | 234
102 | 224 | 174
112 | 109 | 189
141 | 131 | 174
135 | 121 | 169
89 | 115 | 176
74 | 153 | 155
109 | 141 | 135
94 | 78 | 59
122 | 157 | 143
92 | 22 | 73
116 | 115 | 132
83 | 241 | 199 |  | Both B10 and C10 are green. Sum column A until a red row appears in either column B or C. Now there are 7 rows are to be sumed up in column A.
104 | 183 | 149
125 | 160 | 164
103 | 143 | 132
99 | 167 | 139
164 | 176 | 138
103 | 191 | 131
76 | 2115 | 120 |  | Both B18 and C18 are green. Sum column A until a red row appears in either column B or C. Now there are 5 rows are to be sumed up in column A.
122 | 22 | 148
Spreadsheet: 217638d1362137923-list-all-items-depending-on-drop-list-value-schedule-2
Sheet: Job Card TEMPLATE - DO NOT USE

INSI Precision Ltd |  |  |  |  |  |  |  | Production Job Card
WON |  |  | Customer |  |  | Customer PO
PO Date |  |  |  |  |  | Due Date
Drawing No |  |  | Desc |  |  |  | Qty
MATERIAL DETAILS
Material Spec & Size |  |  |  |  |  |  | Qty
Operation |  | √ | Time Taken |  |  | Qty | Completed By
Lathe
Milling
W/J
Sub contract
Sub contract
Total Labour-Hours
Date Comp |  |  |  | Notes
 |  |  |  |  |  |  |  | Quality Check Sheet
Part No. |  | QTY. | Notes |  |  |  |  | Checked
Tools used to Check
[NAME]? | □ |  | □ |  | □ |  | □
Reason for Non-Conformance
Checked By - |  |  | Signature |  |  |  | Date
Spreadsheet: fletcher_sturm__10919__0517 Cash Sheet
Sheet: Sheet1

2001-05-17 00:00:00
Cinergy |  |  |  | Entergy
 | bid | offer |  |  | bid | offer
 | 0 | 0 |  |  | 0 | 0
2001-05-18 00:00:00 | 41 | 43 |  | 2001-05-18 00:00:00 | 48 | 52
May 21-31, 2001 | 41 | 43 |  | May 21-31, 2001 | 49.5 | 52.5
May 21-25, 2001 | 41 | 42 |  | May 21-25, 2001 | 47.5 | 48.5
 | 0 | 0 |  |  | 0 | 0
June, 2001 | 0 | 0 |  | June, 2001 | 0 | 0
July/August, 2001 | 88.75 | 93.25 |  | July/August, 2001 | 99.75 | 103.25
September, 2001 | 38.25 | 38.75 |  | September, 2001 | 44.75 | 45.25
Oct/Nov/Dec, 2001 | 36.75 | 37.25 |  | Oct/Nov/Dec, 2001 | 39.25 | 40.25
Jan/Feb 2002 | 40.5 | 42 |  | Jan/Feb 2002 | 42 | 43.5
Cal 2002 | 44.75 | 46 |  | Cal 2002 | 46 | 47.5 | 52.5
March/April , 2002 | 35 | 36.5 |  | March/April , 2002 | 36.75 | 38.25
May, 2002 | 41.5 | 43 |  | May, 2002 | 42.5 | 44
June, 2002 | 54.75 | 56.25 |  | June, 2002 | 56.75 | 58.25
July/August, 2002 | 73.75 | 76.25 |  | July/August, 2002 | 76.75 | 78.75
Sept, 2002 | 34.5 | 36 |  | Sept, 2002 | 35.75 | 37.25
Q4, 2002 | 33.75 | 35.25 |  | Q4, 2002 | 33.75 | 35.25
Cal 2003 | 39.75 | 41.5 |  | Cal 2003 | 40.25 | 41.75
Comed |  |  |  | TVA
 | bid | offer |  |  | bid | offer
 | 0 | 0 |  |  | 0 | 0
2001-05-18 00:00:00 | 38 | 39 |  | 2001-05-18 00:00:00 | 50 | 54
May 21-31, 2001 | 0 | 0 |  | May 21-31, 2001 | 43 | 45
May 21-25, 2001 | 31 | 32.75 |  | May 21-25, 2001 | 41 | 44
 | 0 | 0 |  |  | 0 | 0
June, 2001 | 0 | 0 |  | June, 2001 | 62 | 64
July/August, 2001 | 0 | 0 |  | July/August, 2001 | 93.5 | 97
September, 2001 | 0 | 0 | 117 | September, 2001 | 40.5 | 41.25
Oct/Nov/Dec, 2001 | 0 | 0 |  | Oct/Nov/Dec, 2001 | 37.75 | 38.75
Jan/Feb 2002 | 0 | 0 |  | Jan/Feb 2002 | 0 | 0
Cal 2002 | 0 | 0 |  | Cal 2002 | 45 | 46.5
March/April , 2002 | 34.5 | 36 |  | March/April , 2002 | 35.5 | 37
May, 2002 | 39.75 | 41.25 |  | May, 2002 | 41.5 | 43
June, 2002 | 0 | 0 |  | June, 2002 | 55.75 | 57.25
July/August, 2002 | 0 | 0 |  | July/August, 2002 | 76 | 78
Sept, 2002 | 34.25 | 35.75 |  | Sept, 2002 | 35.25 | 36.75
Q4, 2002 | 0 | 0 |  | Q4, 2002 | 33.75 | 35.25
Cal 2003 | 0 | 0 |  | Cal 2003 | 0 | 0
PJM
 | bid | offer
 | 0 | 0
June, 2001 | 60 | 61
July/August, 2001 | 86.5 | 90
September, 2001 | 41.5 | 42.25
Oct/Nov/Dec, 2001 | 37.75 | 38.75
Jan/Feb 2002 | 43.5 | 44.25
Cal 2002 | 45.75 | 46.75
March/April , 2002 | 36.25 | 38.25
May, 2002 | 41 | 42.5
June, 2002 | 54.25 | 56.25
July/August, 2002 | 74 | 76 | 91
Sept, 2002 | 35.25 | 36.75
Q4, 2002 | 34.5 | 36
Cal 2003 | 41.25 | 42.75
Spreadsheet: 843068d1695038728-index-match-by-worksheet-name-test-2
Sheet: Main File

Global Filter 1 | Global Filter 2 | Country | State | City | Business Code | Business Center | Unique Identifier/Business Sub product | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Asset Management | Asset under AUM 300B |  |  |  |  |  | 1
Asset Management | Asset under AUM 100B |  |  |  |  |  | 2
Trading | BAC Trade |  |  |  |  |  | 3
Trading | [NAME] |  |  |  |  |  | 1
Mortgage | Private Client |  |  |  |  |  | 2
Mortgage | ETF |  |  |  |  |  | 3
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 12c

Product | AUD* | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending February 15, by product type and major currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 704808d1605763206-index-match-dynamic-lookup-help-index-match
Sheet: Sheet1

Sample 1 |  |  |  |  | Lookup from Sample 1
 | Math | Physic | Chemistry |  | Table 1
[NAME] | 90 | 40 | 23 |  |  | Math | Physic | Chemistry
[NAME] | 80 | 934 | 34 |  | [NAME]
[NAME] | 70 | 45 | 24 |  | [NAME]
King | 60 | 66 | 53 |  | [NAME]
Queen | 50 | 242 | 63 |  | King
 |  |  |  |  | Queen
Spreadsheet: 705439d1606129212-vlookup-with-data-validation-vlookup-with-data-validation
Sheet: File 1

 | FILE 1
 | Student | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00
 | A | 1 | 0 | 1 | 0 | 4 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0
 | B | 1 | 0 | 1 | 0 | 5 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0
 | C | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0
 | Teacher |  |  | 2020-11-01 00:00:00 |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00
 | D | 1 | 0 | 5 | 1 | 0 | 5 |  | 0 | 5 | 5 | 5 | 5 | 5 | 5
 | Gardener |  |  |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00
 | A | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | B | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
Spreadsheet: 135430d1326053592-sum-across-worksheets-mtg-cards
Sheet: Battle Royale Box Set

Name | Rarity | # Owned | Total # Owned
[NAME] | U
[NAME] | C
Air Elemental | U
[NAME] | C
[NAME] | C
[NAME] | U
Armored Pegasus | C
Azure Drake | U
Blinking Spirit | R
Broken Fall | C
Cackling Fiend | C
Catastrophe | R
Cinder Marsh | U
Control Magic | U
Counterspell | C
Crazed Skirge | U
Curfew | C
[NAME] | C
Dirtcowl Wurm | R
Disenchant | C
Disruptive Student | C
Drifting Meadow | C
Elvish Lyrist | U
[NAME] | C
Fecundity | U
Fertile Ground | C
Fire Ants | U
Flood | C
Forest | L
Giant Growth | C
Gorilla Warrior | C
[NAME] | C
[NAME] | C
Hurricane | U
Infantry Veteran | C
Island | L
Land Tax | U
Lhurgoyf | R
Lightning Elemental | C
Living Death | R
Llanowar Elves | C
Mana Leak | C
Maniacal Rage | C
Man-o'-War | C
Manta Riders | C
Master [NAME] | C
[NAME] | U
Mountain | L
Nekrataal | U
Opportunity | U
Pacifism | C
Pestilence | U
[NAME] | C
[NAME] | C
Plains | L
Plated Rootwalla | C
[NAME] | C
[NAME] | C
Raging Goblin | C
Ray of Command | C
Reanimate | U
Remote Isle | C
River Boa | U
Rolling Thunder | C
Sadistic Glee | C
Sanctum Custodian | C
Sanctum Guardian | U
Sandstorm | C
Scaled Wurm | C
[NAME] | C
Seasoned Marshal | U
Seeker of Skybreak | C
[NAME] | U
Sewer Rats | C
Shower of Sparks | C
[NAME] | U
Slippery Karst | C
[NAME] | C
Songstitcher | U
[NAME] | C
Spike Colony | C
[NAME] | U
Spike Weaver | R
[NAME] | C
Steam Blast | U
Subversion | R
Sun Clasp | C
Swamp | L
Swords to Plowshares | U
Symbiosis | C
[NAME] | C
Terror | C
[NAME] | U
Tranquility | C
Trumpeting Armodon | U
Unnerve | C
Uthden Troll | U
[NAME] | U
Village Elder | C
Wall of Heat | C
Weakness | C
Wildfire Emissary | U
Wind Drake | C
Windfall | U
Wrath of God | R
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: Dec 21

Enter 1st of Month Here -> | 2021-12-01 00:00:00 | Controller | Volunteer 1 | Volunteer 2 | Volunteer 3 | Volunteer 4 | Volunteer 5 | Volunteer 6
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
Sat
Sun
Spreadsheet: 694190d1599422152-sum-and-match-formula-sum-and-match-formula
Sheet: PAYSLIP

 | I am kindly asking for a formula which can match  and basic salary , Over time and Transport and House allowance with Period (C7) and code number (C9). Please not that on C7 and C9 |  |  |  |  |  |  |  |  |  |  | 1 | CA1
 | there is drop down list to select periods and employee code numbers. And also formula for cumulative basic salary ( C24).
 | Please note that Olivia was paid her period 1 salary: $5000  on 20/1/20 and then the other $5000 on 20/2/20. Total basic salary for period 1 is $10000.
 | CURRENT OUTCOME |  |  |  |  |  |  |  |  |  | DESIRED OUTCOME | 2 | CA2
 |  |  | TNS P/L |  |  |  |  |  |  |  |  |  | TNS P/L
 | 2020-09-06 00:00:00 |  |  |  |  |  |  |  |  |  | 2020-09-06 00:00:00
 | Period | 1 |  |  |  |  |  |  |  |  | Period | 1
 | Code | CA1 |  |  |  | Desgnation |  |  |  |  | Code | CA1 |  |  |  | Desgnation
 | Name |  |  |  |  |  |  |  |  |  | Name
 | Eearnings | Over time Hours | Rate | Amount |  | Deductions | Amount |  |  |  | Eearnings | Over time Hours | Rate | Amount |  | Deductions | Amount
 |  |  |  |  |  | Pension |  |  |  |  |  |  |  | 10000 |  | Pension
 |  |  |  |  |  | Nssa |  |  |  |  |  |  |  |  |  | Nssa
 |  |  |  |  |  | Nec |  |  |  |  |  |  |  |  |  | Nec
 |  |  |  |  |  | Medical Aid |  |  |  |  |  |  |  |  |  | Medical Aid
 |  |  |  |  |  | PAYE |  |  |  |  |  |  |  |  |  | PAYE
 |  |  |  |  |  | Aids Levy |  |  |  |  |  |  |  |  |  | Aids Levy
 |  |  |  |  |  | Net Salary |  |  |  |  |  |  |  |  |  | Net Salary
 |  | #N/A |  |  |  |  |  |  |  |  |  | #N/A
 | Cummulative |  |  |  |  |  |  |  |  |  | Cummulative
 | Basic Salary |  |  |  |  |  |  |  |  |  | Basic Salary | 10000
Spreadsheet: 294785d1391512780-how-to-pair-concatenate-values-of-first-column-with-each-other-combi
Sheet: Sheet2

 |  | Column A |  | Column A | Column B | Column C | Column D
 |  | A |  | AB | ABC | ABCD | ABCDE
 |  | B |  | AC | ABD | ABCE
 |  | C |  | AD | ABE | BCDE
 |  | D |  | AE | BCD
 |  | E |  | BC | BCE
 |  |  |  | BD | CDE
 |  |  |  | BE
 |  |  |  | CD
 |  |  |  | CE
 |  |  |  | DE
 |  | Table1. Input data |  |  | Table2. Output data
Spreadsheet: 113126d1309099509-split-rows-equally-in-columns-cooksterni_mi
Sheet: Sheet1

WWW.SIM-STOX.CO.UK F2 MEETING INFO CREATOR
PASTE BOOKING LIST HERE
Name | Number | Grade |  | Total drivers
BigDave | 606 | white
JayJay | 747 | white |  | No. Heats
[NAME] | D06 | white |  | Format
Kane-429 | 429 | white
sivvy632 | 632 | white |  | Position
Southwell | 177 | white |  | on Grid | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Stox246 | 246 | white |  | Heat 1
ryan48 | 48 | yellow
[NAME] | H552 | yellow |  | Heat 2
craig12 | 12 | blue
Martin23 | 23 | blue |  | Heat 3
CooksterNI979 | NI979 | red
Jack-249 | 249 | red |  | Heat 4
lithgow62 | 62 | red
Rich24 | 24 | red
Southy277 | 277 | red
fordy688 | 688 | superstar
Peter84 | H84 | superstar
Spreadsheet: 781959d1653657457-count-the-number-of-unique-values-in-a-column-book1
Sheet: Sheet1

ID | Column2 | Column3 | Column4 | Date | Expectation | Column7 | Column8 | Column9
M4453 |  |  |  | 2022-05-04 00:00:00 | 2022-05-04 00:00:00
M4453 |  |  |  | 2022-05-04 00:00:00 | 2022-05-04 00:00:00
5438 |  |  |  | 2022-05-08 00:00:00 | 2022-05-08 00:00:00
5438 |  |  |  | 2022-05-07 00:00:00 | 2022-05-07 00:00:00
M0010 |  |  |  | 2022-05-04 00:00:00 | 2022-05-04 00:00:00
M0010 |  |  |  | 2022-05-08 00:00:00 | 2022-05-08 00:00:00