tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 834789d1688073505-need-max-values-from-separated-cells-multiple-sheets-workout-log-sample-bigpappa1-
Sheet: 6-26

Day 1
Exercise | Warmup |  | Set 1 |  | Set 2 |  | Set 3 |  | Set 5 |  |  | Set 6 |  |  | Notes
 | Weight | Reps | Weight | Reps | Weight | Reps | Weight | Reps | Weight | Reps | Cmpnd? | Weight | Reps | Cmpnd? | Ketp to two sets on the bigger stuff this week. Pushed very well.
Barbell Squat | 135 | 8 | 185 | 7 | 185 | 6 | NA | 0 |  |  |  |  |  |  | Pushed pretty hard, only did two sets
Barbell Hip Thrust | 150 | 18 | 180 | 9 | 180 | 10 | NA | 0
Barbell Bench Press | 135 | 7 | 155 | 7 | 155 | 8 |  | 8
Seated Cable Row | 13 | 16 | 14 | 10 | 14 | 10 | 14 | 10
Dumbbell Arnold Press | 40 | 8 | 35 | 9 | 40 | 7 |  | 9
Seated Lat Pull Down - Wide Grip |  |  | 14 | 10 | 14 | 9
Core
Day 2
Exercise | Warmup |  | Set 1 |  | Set 2 |  | Set 3 |  | Set 5 |  |  | Set 6 |  |  | Notes
 | Weight | Reps | Weight | Reps | Weight | Reps | Weight | Reps | Weight | Reps | Cmpnd? | Weight | Reps | Cmpnd?
Front Squat | 95 | 6 | 135 | 8 | 135 | 8 | NA | 0 |  |  |  |  |  |  | fg
Romanian Dead-Lift | 135 | 6 | 185 | 8 | 185 | 8 | NA | 0 |  |  |  |  |  |  | Felt better than last time, probably could have done more but just felt like I was over-taxing a bit on the lower back and overall fatrigue
High Cable Cross-Over | 5 | 10 | 7 | 8 | 7 | 8 | 7 | 7 |  |  |  |  |  |  | Increased towards end just to really burn out
Inverted Barbell Row | 45 | 10 | 95 | 7 | 95 | 9 | 95 | 9 |  |  |  |  |  |  | Again, more problem with overall fatigue rather than muscle-specific fatigue -  maybe adjust to something else
Barbell Overhead Press |  |  | 95 | 7 | 95 | 6 | 95 | 7 |  |  |  |  |  |  | No warmup these sets
Seated Lat Pull Down - Narrow Grip |  |  | 15 | 8 | 15 | 5 | 14 | 7 |  |  |  |  |  |  | No warmup these sets
Core
Day 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notes
Exercise | Warmup |  | Set 1 |  | Set 2 |  | Set 3 |  | Set 5 |  |  | Set 6 |  |  | Notes
 | Weight | Reps | Weight | Reps | Weight | Reps | Weight | Reps | Weight | Reps | Cmpnd? | Weight | Reps | Cmpnd?
Standing Leg Extensions |  |  | 5 | 13 | 6 | 7 | 7 | 7 |  |  |  |  |  |  | can do much more with left leg - adjusted weight to that
Cable Pull-Through |  |  | 10 | 12 | 10 | 10 | 12 | 8 |  |  |  |  |  |  | Not the best exercise - better to just do a hip thrust
Incline Barbell Bench Press |  |  | 155 | 7 | 155 | 7 | 155 | 5
Face Pulls |  |  | 9 | 10 | 10 | 8 | 10 | 9
Dumbbell Arnold Press |  |  | 35 | 6 | 35 | 6 | 35 | 5 |  |  |  |  |  |  | done seated
[NAME] |  |  | 9 | 6 | 9 | 8 | 10 | 8 |  |  |  |  |  |  | other muscles than back made this [NAME] out quicker
Core
Day 4
Exercise | Warmup |  | Set 1 |  | Set 2 |  | Set 3 |  | Set 5 |  |  | Set 6 |  |  | Notes
 | Weight | Reps | Weight | Reps | Weight | Reps | Weight | Reps | Weight | Reps | Cmpnd? | Weight | Reps | Cmpnd?
[NAME]
[NAME]
[NAME]
Horizontal Pull
Vertical Push
Vertical Pull
Core
Spreadsheet: 778278d1650975554-formula-like-a-vlookup-but-to-bring-back-multiple-results-formula-help-2
Sheet: Sheet1

code | Name | discount | Discount | Discount | Nominal | Nominal | Nominal |  |  | Code | Discount | Nominal
A001 | Smith |  |  |  |  |  |  |  |  | A001 | Award 20% | 12345
B002 | Jones |  |  |  |  |  |  |  |  | A001 | Award 5% | 12346
D001 | Davies |  |  |  |  |  |  |  |  | E002 | Award 35% | 12344
E002 | [NAME] |  |  |  |  |  |  |  |  | E002 | Sale 40% | 21244
 |  |  |  |  |  |  |  |  |  | A001 | Sale 10% | 21245
 |  | I want to populate the yellow cells based on the data in the orange section.
 |  | I have typed in the results I would expect for the first line.
Spreadsheet: 329342d1404280380-bands-for-incentive-payments-140702-incentive-calculator
Sheet: Under

 | Force Incentive and Performance Prgram for ASM: [NAME]
 |  |  | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Total |  |  |  | Period | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | Grand Total
 |  | Target | 166666.6666666667 | 166666.6666666667 | 166666.6666666667 | 166666.6666666667 | 166666.6666666667 | 145000 | 155000 | 188333.3333333332 | 166666.6666666667 | 166666.6666666667 | 170000 | 175000 |  |  |  |  | Target | 100000 | 100000 | 100000 | 100000 | 120000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000
 |  | Actual | 166667 | 140000 | 100000 | 185000 | 140000 | 100000 | 175000 | 140000 | 100000 | 195000 | 135000 | 100000 |  |  |  |  | Actual | 49000 | 55000 | 75000 | 95000 | 100000 | 110000 | 120000 | 100000 | 100000 | 100000 | 100000 | 100000
 |  | % Act vs Target |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % of Target achieved
 | [NAME]
 | % Target | Incentive
First | 0.5 | 0.015 | 1500 | 1250 | 1250 | 1250 | 1250 | 1087.5 | 1162.5 | 1412.499999999999 | 1250 | 1250 | 1275 | 1312.5
Next | 0.2 | 0.03 | 1000.002 | 1000 | 500.0000000000001 | 1000 | 1000 | 825 | 930 | 1129.999999999999 | 500.0000000000001 | 1000 | 1020 | 375
Next | 0.2 | 0.06 | 2000.004 | 1400.04 | 0 | 2000 | 1400.04 | 0 | 1860 | 1400.04 | 0 | 2000 | 960 | 0
Next | 0.1 | 0.08 | 1333.336 | 0 | 0 | 1333.333333333333 | 0 | 0 | 1240 | 0 | 0 | 1333.333333333333 | 0 | 0
Above | Above | 0.1 |  | 0 | 0 | 1833.333333333334 | 0 | 0 | 2000 | 0 | 0 | 2833.333333333334 | 0 | 0
 |  | Total Incentive
 |  | Cumulative Incentive
 |  | Total Incentive %
Spreadsheet: 1590c1cf-0bb1-46aa-af09-615249593d6e
Sheet: In School

 | In-School
Total Students | 666 |  |  |  |  |  | Notable Days for one incident: In-School
Total Suspensions | 1113 |  |  |  |  |  | 12 | No Services Provided
 | Services |  | No Services |  |  |  | 14
Students | 108 |  | 1005 |  |  |  | 15
 |  |  |  |  |  |  | 20
 | 10 Days or Less |  | 11+ Days |  |  |  | 45
 | Services | No Services | Services | No Services |  |  | 45
Total Incidences | 108 | 995 | 0 | 10 |  |  | 45
 |  |  |  |  |  |  | 48
 |  |  |  |  |  |  | 100
 |  |  |  |  |  |  | 219
Spreadsheet: 47222d1246196602-conditional-sum-with-merged-cells-avoid-merged-cells
Sheet: Sheet1

 |  |  |  |  | using -- | using "*"
 | x | a | 1 |  | 20 | 20
 | x | b | 2
 | x | c | 3
 | x | d | 4
 | x | e | 5
 | y | a | 12
 | y | b | 65
 | y | c | 24
 | y | d | 26
 | y | e | 24
 | x | a | 15
 | x | b | 18
 | x | c | 87
 | x | d | 24
 | x | e | 36
Spreadsheet: 839983d1692344323-spilling-arrays-and-substitute-substitute-1-
Sheet: Feuil1

list |  | exclude list |  | list input |  | exclude from list list |  |  | list output EXPECTED RESULT
a!aa |  | ! |  |  |  |  |  |  | aaa
bbb |  | , |  | bbb |  | , |  |  | bbb |  | bbb
ccc, |  | % |  | ccc, |  | % |  |  | [NAME] |  | [NAME]
[NAME] |  | ( |  | [NAME] |  | ( |  |  | ddd |  | ddd
eee |  | ) |  | eee |  | ) |  |  | eee |  | eee
Spreadsheet: 136632d1326750248-excel-2007-problem-using-begins-with-parameter-in-excel-query-picked-orders-begins-with
Sheet: Details

SO_ID | SO_LINE_NO | PART_ID | OPERATOR_ID | PICK_DATE | PICK_DATE | QTY | SHIPPED_QTY | REV_ORDER_QTY | BALANCE_DUE | SO_LINE_STATUS | BATCH_NUMBER | STORES_CODE
831790 | 17 | [NAME] | armandof | 2011-10-12 00:00:00 |  | 1 | 0 | 1 | 1 | O | 346239 | DR
833272 | 6 | DSMABETA52BD | armandof | 2011-10-22 00:00:00 |  | 1 | 0 | 1 | 1 | O | 346877 | DR
831790 | 16 | DSMAD112BD | armandof | 2011-10-12 00:00:00 |  | 1 | 0 | 1 | 1 | O | 346239 | DR
827849 | 18 | DSMAINEX | armandof | 2011-12-01 00:00:00 |  | 1 | 0 | 1 | 1 | O | 349162 | DR
841258 | 1 | DSMAXL57SDRF | ivanp | 2012-01-06 00:00:00 |  | 1 | 0 | 1 | 1 | O | 350969 | DR
840711 | 2 | DSMAXL57SDRF | enriquea | 2012-01-09 00:00:00 |  | 1 | 3 | 6 | 3 | O | 351055 | DR
840711 | 2 | DSMAXL57SDRF | enriquea | 2012-01-09 00:00:00 |  | 1 | 3 | 6 | 3 | O | 351055 | DR
840711 | 2 | DSMAXL57SDRF | enriquea | 2012-01-09 00:00:00 |  | 1 | 3 | 6 | 3 | O | 351055 | DR
Spreadsheet: 186583d1350089712-combining-several-duplicate-rows-summing-one-column-and-removing-original-duplicates-todedupe2
Sheet: Desired

Category | SKU | Title | D | Image # | Brand | Fabric | Color/Description** | [NAME] | Euro | Retail Price | Price | Qty | Clearance (Y) | Tack Room
Dress Shirts | Dshrt-4387 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 15.5 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4388 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 15.75 |  | 495 | 149 | 3 | Y |  | Medium Spread | Barrel | No
Dress Shirts | [NAME] |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 16 |  | 495 | 149 | 5 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4395 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 16.5 |  | 495 | 149 | 4 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4399 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 17 |  | 495 | 149 | 2 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4400-2 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 17.5 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Spreadsheet: 858233d1706966464-yoy-delta-with-varying-values-yoy-2022-vs-2023
Sheet: Sheet1

 |  | 2023 |  | 2022 |  |  | 2023 Avg. |  | 2022  [NAME].
 |  | Tests | Score | Tests | Score |  | Avg. Score |  | Avg. Score |  | Delta
[NAME] |  | 8 | 741 | 4 | 154
[NAME] |  | 21 | 2513 | 16 | 944
[NAME] |  | 2 | 33 | 3 | 31
[NAME] |  | 44 | 12277 | 40 | 7536
[NAME] |  | 17 | 4335 | 15 | 2636
[NAME] |  | 25 | 5976 | 28 | 5343
[NAME] |  | 20 | 2158 | 13 | 1200
[NAME] |  | 13 | 617 | 14 | 585
[NAME] |  | 31 | 11557 | 34 | 11247
[NAME] |  | 10 | 1618 | 10 | 1491
[NAME] |  | 21 | 12892 | 12 | 7388
Gina |  | 47 | 11267 | 45 | 10962
Eda |  | 31 | 6802 | 25 | 6657
[NAME] |  | 20 | 1474 | 22 | 2070
[NAME] |  | 23 | 5944 | 36 | 14275
Rod |  | 20 | 1681 | 21 | 2729
[NAME] |  | 8 | 264 | 6 | 388
[NAME] |  | 2 | 287 | 2 | 640
Mark |  | 4 | 46 | 4 | 115
Lorne |  | 4 | 134 | 1 | 200
George |  | 2 | 11 | 7 | 930
[NAME] |  | 1 | 1 | 1 | 520
Spreadsheet: michelle_lokay__26750__imball0112
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 | 115 | 240
2 | 58 | 240
3 | 44 | 240
4 | 2 | 240
5 | 35 | 240
6 | 41 | 240
7 | 245 | 240
8 | 171 | 240
9 | 114 | 240
10 | 149 | 240
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 173805.23
2001-12-10 00:00:00
CBS Volume
 |  |  | 76238
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: New Backhoe

New Excavator |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 160362d1339066153-excel-2007-format-entire-columns-based-on-date-at-head-of-column-cake-orders-test-sheet
Sheet: Orders

Date | 2012-05-18 00:00:00 | 2012-05-19 00:00:00 | 2012-06-13 00:00:00 | 2012-06-30 00:00:00 | 2012-07-22 00:00:00 | 2012-10-20 00:00:00 | 2012-12-28 00:00:00 | 2013-06-21 00:00:00
Latest del time |  | 3.00 | Collecting | 12.30 |  |  |  | 12.00
Venue | Hotel California | Dartington Hall | Collecting | Falcon Hotel | Kitley House | [NAME] | Southernhay House | Headland Hotel
Contact
Town
Postcode
Cust Name1 | [NAME] | [NAME] | [NAME] | Delennyk | Nicola | Vicky | Rebecca | Emma
Cust Name2 |  |  | [NAME] |  | [NAME]
Mobile
Other Tel
email
Postcode
Design type | Choc Flake |  | Sophie | Chocolate curl | Chocolate Rose | cupcakes +  top | as photo supplied | as photo supplied
Shape | heart |  | round | round | round | round | round | round
Size "/"/" | 12/10/8 |  | 10" | 10/8/6 | 10/7/5 | 80cupcakes/6" top | 10/8/6 | 5/7/9
Mix / / / | choc/choc/choc |  | Fruit | choc/choc/choc | sponge/choc/lemon & orange | [NAME] | choc/choc/choc | fruit/fruit/fruit
Fillings | [NAME] jam |  | n/a | buttercream | jam&b'cream/choc b'cream/drizzle | buttercream topping | buttercream | n/a
Icing type |  |  | Royal | white chocolate curls | White chocolate icing | b/cream / fondant | chocolate
Icing colour |  |  | Ivory |  | White chocolate | ivory/aubergine/ivory | as photo supplied
Dec col |  |  | Ivory/Pink | red roses - sugar |  | aubergine | as photo supplied
Portions |  |  | 40 | 40 | 50 | 100 tbc | 50 | 50
Topper/Other |  |  | Bride & Groom topper | red roses - sugar
Stand/Knife? |  |  | no/no | no/no
Details
Cake price |  |  | 80 | 250 |  |  | 270
Topper/Other |  |  | 6
Stand/Knife
Delivery |  |  |  |  |  |  | 30
Total |  |  |  |  |  | 265
Deposit paid |  |  |  | 60 | 100 | 100 | 70
Balance Due
Spreadsheet: 7cf7489a-8052-4faf-9399-31c98da336f8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4972 | 11296 | Kairi | [NAME] | EST | 353 | 00:19:46 | 00:01:00 | 02:04:42 | 00:00:50 | 00:50:42 | 1 | 03:16:59
Spreadsheet: 014308c8-40de-4b5b-8ed0-99a6a07bef0a
Sheet: Sheet1

Serials Expenditures Summary | 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
 | 1995/96 | 1996/97 | 1997/98 | 1998/99 | 1999/00 | 2000/01 | 2001/02 | 2002/03 | 2003/04 | 2004/05 | 2005/06 | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11
Total serials expenditures (Kingston only) | 1308829 | 1422136 | 1296426 | 1325766.56 | 1368680.63 | 1616304.74 | 1557733.22 | 1775296.63 | 1806542.7 | 2098057 | 2279503.76 | 2329907 | 3122275 | 2602491 | 2726389 | 2891249
Total serials purchased (includes online) |  | 9028 | 7601 | 5396 |  |  |  |  | 6872 |  | 7096 | 10242 | 18742 | 19351 | 24392 | 27048
Total serials purchased (online-only) |  |  |  |  |  |  |  |  |  |  | 4796 | 8038 | 17272 | 18641 | 23671 | 26471
Online-only as percentage of total |  |  |  |  |  |  |  |  |  |  | 0.6758737316798196 | 0.7848076547549306 | 0.9215665350549568 | 0.963309389695623 | 0.9704411282387668 | 0.978667553978113
Total unique titles available online (includes aggregators) |  |  |  |  |  |  |  |  |  |  | 19474 | 20079 | 29164 | 31321 | 43196 | 48949
Total serials expenditures (all libraries) | 1490512 | 1612120 | 1470633 | 1537964.4 | 1666000 | 1799917 | 1801694 | 1999567 | 1994861.8 | 2290000 | 2414365 | 2402928 | 3203494 | 2633950 | 2741386 | 2904380
Total materials expenditures (all libraries) | 1759394 | 2008986 | 1916799 | 1947539.08 | 2048225 | 2200277 | 2202054 | 2379852 | 2347634.9 | 2622697 | 2922697 | 2723952 | 3661442 | 2937096 | 3098809 | 3248522
Serials as % of total materials expenditures | 0.8471735154263343 | 0.8024545716097573 | 0.7672338101178058 | 0.7896962971341248 | 0.813387201113159 | 0.8180410920988584 | 0.8181879281797813 | 0.8402064498128455 | 0.8497325542400141 | 0.8731469933431121 | 0.8260743416098213 | 0.8821477030432254 | 0.8749268730735049 | 0.8967871666435145 | 0.8846579443908934 | 0.8940619764926943
U.S. Periodical Price Index (1984=100) | 271.9 | 301.3 | 331.1 | 365.2 | 403.2 | 439.4 | 475.8 | 513.6 | 552.3 | 597.5 | 636.3 | 686 | 735.7 | 794.8 | 851.1 | 905.3
CPI-U (1982/84=100) | 152.4 | 156.9 | 160.5 | 163 | 166.6 | 172.2 | 177.1 | 179.9 | 184 | 188.9 | 195.3 | 201.6 | 207.3 | 215.3 | 214.5 | 218.1
* Total materials budget is for all libraries (Kingston, [NAME], CCE). Equals sum of money spent on monographs + serials.
Sources:
The Bowker Annual Library and Book Trade Almanac, various years, for U.S. Periodical Price Index
Bureau of Labor Statistics, http://data.bls.gov/cgi-bin/surveymost and ftp://ftp.bls.gov/pub/special.requests/cpi/cpiai.txt
University of Rhode Island Library
Compiled:
[NAME]
2006-10-31 00:00:00
Updated: December 2010, January 2012 ajr
Spreadsheet: 189717d1351291490-divide-and-distribute-costs-to-multiple-participants-based-on-individual-amount-owed-vacation-cost-calculator
Sheet: Family2

Family2 |  |  |  |  | Receipts for Group Items | Cost | Total Paid
Family Members at Parker | 0 |  |  |  |  |  | 0
Family Days at Parker | 0
Family Members: | Days at Parker
Family_Member1 | 0
Family_Member2 | 0
Family_Member3 | 0
Family_Member4 | 0
Family_Member5 | 0
Spreadsheet: 708287d1607705008-how-can-i-use-index-and-match-to-populate-dropdown-list-with-multiple-values-partial-and-universal-indexing-using-index-aggregate-alexsr700-
Sheet: Sheet1

Searchstring
* |  |  |  |  | Dropdown:
 |  |  |  |  | 5
 | A | 1
 | B | 2
 | C | 3
 | A | 4
 | A | 5
 | D | 6
 | F | 7
Spreadsheet: 820019d1677822968-split-column-nowy-microsoft-excel-worksheet-2-
Sheet: Arkusz1

1 | 2 | 3 | 4 | 5
looks like this | Looks like this |  | Should look like this COLUMN | OR EVEN BETTER TO LOOK LIKE THIS COLUMN
41-203 | SŁONECZNA 14 SOSNOWIEC | →→ | SŁONECZNA 14
40-315 | AL. ROŹDZIEŃSKIEGO 210 KATOWICE | →→ | AL. ROŹDZIEŃSKIEGO 210
40-315 | GEN. [NAME] PSZCZYNA | →→ | GEN. [NAME]
43-500 | 1 MAJA 7 GOLESZÓW | →→ | 1 MAJA 7
40-212 | ROLNA 14 KATOWICE | →→ | ROLNA 14
Spreadsheet: 482998d1475414848-using-excel-to-write-wiring-connection-plan-sorting-wire-connection-by-caplja
Sheet: terminal block

1 | 2 | 3 | 4 |  |  |  |  |  |  |  |  | Tarminal block | Teminal connection
Date | Approved | Checked | Draw |  |  | Cable : H07-red | Cable : H07-red | Cable : H07-black | Cable : H07-black |  |  | X220 |  |  |  | Cable : H07-black | Cable : H07-black | Cable : H07-black | Cable : H07-black
 |  |  |  |  |  | 2.5 | 1.5 | 2.5 | 1.5 | Apparatus | Terminal |  | Terminal number | Apparatus | Terminal | 2.5 | 1.5 | 2.5 | 1.5
 |  |  | Drawn title |  |  |  |  |  |  |  |  |  | 1 | K7 | 11 |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | K11 | 21 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | S1 | 1 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 13 | S1 | 2 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 21 | X2 | 53 |  |  |  | X
SOME DATA , same on every page |  |  | DRAWN TITLE |  |  |  |  |  |  |  |  |  | 22 | X2 | 66 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  | X | K4 | 59 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  | 26 | K7 | 12 |  |  | X
SOME DATA , same on every page |  |  | TERMINALS X220
SOME DATA , same on every page |  |  | DRAWN TITLE
1 | 2 | 3 | 4 |  |  |  |  |  |  |  |  | Tarminal block | Teminal connection
Date | Approved | Checked | Draw |  |  | Cable : H07-red | Cable : H07-red | Cable : H07-black | Cable : H07-black |  |  | X300 |  |  |  | Cable : H07-black | Cable : H07-black | Cable : H07-black | Cable : H07-black
 |  |  |  |  |  | 2.5 | 1.5 | 2.5 | 1.5 | Apparatus | Terminal |  | Terminal number | Apparatus | Terminal | 2.5 | 1.5 | 2.5 | 1.5
 |  |  | Drawn title |  |  |  |  |  |  |  |  |  | 1 | X50 | 11 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | X50 | 12 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | X50 | 21 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | X50 | 22 |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | X51 | 11 |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | X51 | 12 |  |  | X
SOME DATA , same on every page |  |  | DRAWN TITLE |  |  |  |  |  |  |  |  |  | 67 | X51 | 21 |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | 68 | X51 | 22 |  |  | X
SOME DATA , same on every page |  |  | TERMINALS X221
SOME DATA , same on every page |  |  | DRAWN TITLE
1 | 2 | 3 | 4 |  |  |  |  |  |  |  |  | Tarminal block | Teminal connection
Date | Approved | Checked | Draw |  |  |  |  |  |  |  |  | X500 |  |  |  | Elka wire red | Elka wire black
 |  |  |  |  |  |  |  |  |  | Apparatus | Terminal |  | Terminal number | Apparatus | Terminal | 2.5 | 1.5
 |  |  | Drawn title |  |  |  |  |  |  |  |  |  | 150 | S102 | 1 | x
 |  |  |  |  |  |  |  |  |  |  |  |  | 151 | S102 | 2 |  | x
SOME DATA , same on every page |  |  | DRAWN TITLE
SOME DATA , same on every page |  |  | TERMINALS X222
SOME DATA , same on every page |  |  | DRAWN TITLE
Spreadsheet: 689973d1596787946-the-number-of-the-row-which-all-cells-is-value-true-row12
Sheet: Sheet1

RESULT | ?? | the result is the number of which all cells in the row are true: 12. Please help me. How do I enter the formula? Thank you
True | False | False | False | True
False | True | True | False | True
True | False | False | False | False
False | False | True | False | False
False | False | True | True | True
False | True | False | False | True
False | True | True | False | True
False | False | False | True | False
True | True | False | False | False
True | True | True | True | True
True | True | True | True | False
True | False | False | False | True
True | False | False | True | False
False | True | False | True | False
Spreadsheet: 164719d1340866601-excel-2007-help-on-vlookup-funtion-data
Sheet: DATA

Date | Particulars | Amount
2012-04-07 00:00:00 | COMMN_6347B9_0406_25100 | 25100
2012-04-07 00:00:00 | COMMN_6347B7_0406_14000 | 14000
2012-04-07 00:00:00 | COMMN_6347B5_0406_14200 | 14200
2012-04-07 00:00:00 | COMMN_6347B4_0406_46000 | 46000
2012-04-07 00:00:00 | COMMN_6347C9_0406_1850 | 1850
2012-04-07 00:00:00 | COMMN_6347B8_0406_8495 | 8495
2012-04-07 00:00:00 | COMMN_6347C2_0402_3500 | 3500
Spreadsheet: 491415d1480460628-populate-automatic-rota-by-date-rota-dummy
Sheet: Tracker

 |  | WC = | 2016-11-28 00:00:00
Department | Manager | Name | Shift | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Customer Service | [NAME] | [NAME] | E1 | in | in | in | in |  | Off
Back Office | [NAME] | [NAME] | PT12 | in | sick | Off | in |  | Off
Complaints | [NAME] | [NAME] | M2 | in | in | in | in | 7.5 | Off
Sales | [NAME] | [NAME] | E3-Mon | RDO | in | in | in
Headcount
[NAME]
Holiday Count