tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 07ad565f-114d-4d96-aabb-220104baff1c
Sheet: Sheet1

WORLD SENIOR BADMINTON CHAMPIONSHIPS 2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
09-14 SEPTEMBER 2013, ANKARA-TURKEY
PRACTICE PROGRAMME
 | 07.09.2013  SATURDAY
 |  | Practice Hall
 | Time | Court 1 | Court 2 | Court 3 | Court 4 | Court 5 | Court 6 | Court 7
1 | 09.00-10.00 |  |  |  |  |  |  | England
2 | 10.00-11.00 |  |  |  |  |  |  | England
3 | 11.00-12.00
4 | 12.00-13.00 | Austria
5 | 13.00-14.00
6 | 14.00-15.00 | Canada | Canada
7 | 15.00-16.00 | Canada | Canada
8 | 16.00-17.00
9 | 17.00-18.00 | England | England | India | India | India | Germany | England
10 | 18.00-19.00 | Finland | Spain | India | India | India | Germany | England
11 | 19.00-20.00 |  |  |  |  |  | Germany | England
12 | 20.00-21.00 | Indonesia | Indonesia | France | France | France | Germany | England
13 | 21.00-22.00 | Sweden | Sweden | Russia | Russia | Estonia |  | England
 | 08.09.2013  SUNDAY
 |  | Practice Hall
 | Time | Court 1 | Court 2 | Court 3 | Court 4 | Court 5 | Court 6 | Court 7
1 | 09.00-10.00 | Russia | Russia | England | England | Indonesia | Denmark | Denmark
2 | 10.00-11.00 | Sweden | Sweden | Norway | Norway | Indonesia | Denmark | Denmark
3 | 11.00-12.00 | Turkey | Turkey | Norway | Norway | Turkey | Denmark | Denmark
4 | 12.00-13.00 | England | Enland | England | England | England | England | England
5 | 13.00-14.00
6 | 14.00-15.00 |  |  | Canada | Canada
7 | 15.00-16.00 | Czech Republic | [NAME] | Canada | Canada | Germany | Germany | [NAME]
8 | 16.00-17.00 | Tailand | Tailand | Hong Kong |  | Germany | Germany
9 | 17.00-18.00 | Tailand | Tailand | India | India | India | India | India
10 | 18.00-19.00 | India | India | Ukrain | France | France | France | France
11 | 19.00-20.00 | Qatar | England | Ukrain | Switzerland | Switzerland | Hungary | Malaysia
12 | 20.00-21.00 | Bulgaria | Bulgaria | Bulgaria | Bulgaria | Azerbaycan | Estonia | Chinese Taipei
13 | 21.00-22.00 | Indonesia | Indonesia | Finland | Finland | Italy | Mongolia | Crotia
Spreadsheet: 768623d1645047426-need-formula-to-count-cells-with-text-but-omits-duplicates-funding-log-excel-help-1-
Sheet: 2022

FUND DATE | AGREEMENT # | BORROWER | VENDOR | VENDOR CLASSIFICATION | VENDOR PAYMENTS
2022-01-04 00:00:00 | 202109.3995 | [NAME], M.D./ P.A. | VENDOR PAID BY TPO - MMP | CORP | 233746
2022-01-04 00:00:00 | 12819 | EXCAVATING NEW JERSEY LIMITED LIABILITY COMPANY | WOODCHIPS CONSTRUCTION, INC. | CORP | 93000
2022-01-04 00:00:00 | 103881 | HEAL N CURE S.C. | VENDOR PAID BY TPO - LEASEPOINT | LLC | 160745.63
2022-01-05 00:00:00 | 20211022 | [NAME], LLC | ULTRASOURCE LLC | LLC | 81092
2022-01-06 00:00:00 | 20211014 | DWELL & DÉCOR OUTDOOR LLC | THOMPSON TRACTOR, INC. | CORP | 325496
2022-01-07 00:00:00 | 20210818 | MASS-GRANITE INC. | SMARTROOF CAPITAL | SOLE PROP | 16625
2022-01-07 00:00:00 | 20210818 | MASS-GRANITE INC. | SMARTROOF CAPITAL | SOLE PROP | 49875
2022-01-07 00:00:00 | 20210818 | MASS-GRANITE INC. | PROVIDENCE SHORTFALL *-1374.12 | CORP | -929.12
2022-01-07 00:00:00 | 20073436-2 | [NAME], LLC | VENDOR PAID BY TPO - JULES & ASSOCIATES, INC. | CORP | 65462.92
Spreadsheet: 21043d1208086720-excel-import-stock-branches
Sheet: Summary Stock

Code | Name | Br 1 Qty | [NAME] | Br 3 Qty | BR 4 Qty | Br 5 Qty | TOTAL
1258 | PONDS | 5 | 0 | 0 | 0 | 0 | 5
130756 | BOYS SPORTS WATCH RMB TA431/9 | 1 | 0 | 0 | 0 | 0 | 1
130891 | 2 PIN JAPAN | 0 | 0 | 0 | 0 | 4 | 4
130895 | 3PIN TO 2PIN ADAPTOR | 0 | 0 | 0 | 0 | 6 | 6
150069 | MAJMUR A00003 | 0 | 0 | 0 | 1 | 0 | 1
150672 | 12Pcs CUP & SAUCER CHINA | 0 | 0 | 1 | 0 | 0 | 1
150991 | 11PCS MELAMINE PARTY SET 14 | 0 | 0 | 1 | 0 | 3 | 4
151661 | EGG BEATER STEEL 12 INCH-HAQ | 1 | 0 | 0 | 0 | 0 | 1
151674 | 12PC CUP & SAUCER SET WITH STAND-HF298 | 0 | 4 | 6 | 0 | 0 | 10
152123 | 11PCS MELAMINE PARTY SET 3501 | 0 | 2 | 4 | 0 | 3 | 9
152124 | 11PCS MELAMINE PARTY SET S811-15 Inch | 0 | 12 | 3 | 0 | 2 | 17
152268 | DOUBLE CIRCLE ALU.COFFEE POT-18CM | 1 | 0 | 0 | 0 | 0 | 1
152269 | DOUBLE ALU.KETTLE 3LTR-A3020W | 1 | 0 | 0 | 0 | 0 | 1
161726 | ATLAS LUNGY SHAMS 200x200 | 1 | 0 | 0 | 0 | 0 | 1
190695 | COLOUR BALLOONS 50Pcs RMB | 1 | 0 | 0 | 0 | 0 | 1
190852 | 22 KEYS ELECTRONIC KEYBOARD 3665 | 0 | 0 | 0 | 0 | 9 | 9
[PHONE] | 1 D AILLEURS SPRAY 125ML | 0 | 1 | 1 | 0 | 0 | 2
[PHONE] | DURACELL BATTERY AA (4) LR6 | 0 | 1 | 0 | 0 | 0 | 1
[PHONE] | 12PC MAGNET SET CARD-MG12 | 0 | 16 | 2 | 0 | 0 | 18
[PHONE] | 2A2 MEN SPRAY 100ml./FF | 0 | 0 | 0 | 0 | 4 | 4
[PHONE] | 202 ERA SPRAY 100ml./In Style | 0 | 0 | 0 | 0 | 5 | 5
[PHONE] | 10 WAY 13 AMP EXTENSION SOCKET 2111/13A/ | 0 | 0 | 1 | 0 | 0 | 1
[PHONE] | AL FELAIJ HAND BRUSH | 1 | 0 | 0 | 0 | 0 | 1
BEU003 | MAKE UP SET 8000 | 0 | 0 | 0 | 3 | 0 | 3
BEU011 | MAKE UP SET 8080 | 0 | 0 | 0 | 4 | 0 | 4
BEU012 | MAKE UP SET 979 | 0 | 0 | 0 | 2 | 0 | 2
BEU023 | MAKE UP SET 7070 | 0 | 0 | 0 | 3 | 0 | 3
BEU037 | MAKE UP SET 9292 | 0 | 0 | 0 | 2 | 0 | 2
BEU063 | MAKE UP SET 9090 | 0 | 0 | 0 | 1 | 0 | 1
COS100 | PERT PLUS 200 | 5 | 0 | 0 | 5 | 5 | 15
COS200 | PENTINE 200 | 6 | 6 | 6 | 0 | 6 | 24
COS550 | MAKE UP 220 | 0 | 0 | 0 | 5 | 0 | 5
DINS001 | 16 PCS DINNER SET SAIF | 0 | 2 | 0 | 0 | 0 | 2
ELE1268 | UNIVERSAL REMOTE CONTROL URC22 | 0 | 1 | 0 | 0 | 0 | 1
HOU1520 | 24 PCS SPOON SET METAL TRAY | 0 | 0 | 0 | 0 | 1 | 1
MAJ002 | ELECTRIC MAJMUR IBEX WOOD-MINI | 1 | 0 | 0 | 0 | 0 | 1
MAK014 | MAKE UP SET 9070 R | 0 | 0 | 0 | 2 | 0 | 2
MAK060 | MAKE UP SET 9595W | 0 | 0 | 0 | 1 | 0 | 1
RED1840 | BABY WEAR LUCKY BABY 3PCS | 1 | 0 | 0 | 0 | 0 | 1
RED3660 | 026 BOYS SEMILONG 6PC | 0 | 0 | 0 | 0 | 0 | 0
SPR007 | 16 PARIS SPRAY 100ml. | 0 | 1 | 0 | 0 | 0 | 1
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 676769d1588959916-finding-hourly-pay-rate-dd-earnings-log
Sheet: Sheet1

Date | Time Start | Time End | Time Total | Deliveries | Total Earnings | Avg. Per Delivery | Avg. Per hour
2020-04-26 00:00:00 | 10:56:00 | 15:12:00 |  | 8 | 63.61
2020-04-27 00:00:00 | 08:06:00 | 14:47:00 |  | 15 | 114.51
2020-04-28 00:00:00 | 11:02:00 | 16:14:00 |  | 10 | 76.05
2020-04-29 00:00:00 | 09:58:00 | 14:11:00 |  | 10 | 69.81
2020-04-30 00:00:00 | 11:03:00 | 15:17:00 |  | 11 | 72.35
2020-05-01 00:00:00 | 10:57:00 | 15:50:00 |  | 8 | 77.73
2020-05-04 00:00:00 | 11:08:00 | 13:38:00 |  | 5 | 38.13
2020-05-05 00:00:00 | 10:23:00 | 13:50:00 |  | 9 | 80.25
2020-05-05 00:00:00 | 14:01:00 | 16:32:00 |  | 4 | 35.24
2020-05-06 00:00:00 | 10:05:00 | 15:24:00 |  | 11 | 83.25
2020-05-07 00:00:00 | 10:19:00 | 15:01:00 |  | 11 | 76.99
Total
Spreadsheet: b5cc4fe5-44a3-48ea-ad16-4670c25e8ff5
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Brookside Storm Sewer Improvements Study, Amendment 4
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2004-05 |  |  | FY 2005-06
 | General Fund
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ | 0 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2004-05 |  |  | FY 2005-06
 | General Fund
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ | 514400 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 22e7844e-018c-4c8b-a56b-33cbe427bfd5
Sheet: Sheet1

Employment by class of worker and industry (based on NAICS)1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | December 2008 to January 2009 | January 2008 to January 2009 | December 2008 to January 2009 | January 2008 to January 2009
 | Seasonally adjusted
 | thousands |  | change in thousands |  | % change
Class of worker
Employees | 14452.6 | 14309.4 | -143.2 | -148.6 | -1 | -1
Self-employed | 2658.4 | 2672.6 | 14.2 | 60.1 | 0.5 | 2.3
Public/private sector employees
Public | 3446.7 | 3404.7 | -42 | 2.2 | -1.2 | 0.1
Private | 11005.9 | 10904.7 | -101.2 | -150.8 | -0.9 | -1.4
All industries | 17111 | 16982 | -129 | -88.6 | -0.8 | -0.5
Goods-producing sector | 3977.1 | 3856.6 | -120.5 | -160.2 | -3 | -4
Agriculture | 316.2 | 307.8 | -8.4 | -32.6 | -2.7 | -9.6
Natural resources | 343.9 | 341.7 | -2.2 | 1.3 | -0.6 | 0.4
Utilities | 149 | 144.4 | -4.6 | -2.1 | -3.1 | -1.4
Construction | 1217.5 | 1213.1 | -4.4 | 20.7 | -0.4 | 1.7
Manufacturing | 1950.5 | 1849.6 | -100.9 | -147.4 | -5.2 | -7.4
Service-producing sector | 13133.9 | 13125.3 | -8.6 | 71.5 | -0.1 | 0.5
Trade | 2661.7 | 2653.6 | -8.1 | -25.6 | -0.3 | -1
Transportation and warehousing | 869.7 | 839.8 | -29.9 | -14.3 | -3.4 | -1.7
Finance, insurance, real estate and leasing | 1083.7 | 1097.2 | 13.5 | 17.8 | 1.2 | 1.6
Professional, scientific and technical services | 1207.1 | 1210.6 | 3.5 | 26.2 | 0.3 | 2.2
Business, building and other support services | 670.1 | 648.5 | -21.6 | -58.3 | -3.2 | -8.2
Educational services | 1184.5 | 1178.5 | -6 | -18.1 | -0.5 | -1.5
Health care and social assistance | 1939.5 | 1970.3 | 30.8 | 95.2 | 1.6 | 5.1
Information, culture and recreation | 762.6 | 760.2 | -2.4 | -9.4 | -0.3 | -1.2
Accommodation and food services | 1063.4 | 1075.2 | 11.8 | 30.3 | 1.1 | 2.9
Other services | 756.9 | 768.6 | 11.7 | 15.5 | 1.5 | 2.1
Public administration | 934.7 | 922.8 | -11.9 | 12 | -1.3 | 1.3
http://www.statcan.gc.ca/daily-quotidien/090206/t090206a2-eng.htm
Spreadsheet: 30503d1226006580-making-excel-remember-a-pattern-based-on-variables-power-patch-sheet
Sheet: Sheet1

Fixture # | Fixture Type | Circuit Name | Circuit Number | Amps | Voltage | [NAME] | Draw Y Leg | Draw Z Leg | Soco Output
101 | Mac 700 | ML1 | 1 | 4.6 | 208v | 4.6 | 4.6 |  | A
102 | Mac 700 | ML1 | 2 | 4.6 | 208v | 4.6 | 4.6 |  | A
103 | Mac 700 | ML1 | 3 | 4.6 | 208v | 4.6 |  | 4.6 | A
104 | Mac 700 | ML1 | 4 | 4.6 | 208v | 4.6 |  | 4.6 | A
105 | Mac 700 | ML1 | 5 | 4.6 | 208v |  | 4.6 | 4.6 | A
106 | Mac 700 | ML1 | 6 | 4.6 | 208v |  | 4.6 | 4.6 | A
107 | Mac 2000 | ML2 | 1 | 5 | 208v | 4.6 | 4.6 |  | B
108 | Mac 2000 | ML2 | 2 | 5 | 208v | 4.6 | 4.6 |  | B
109 | Mac 2000 | ML2 | 3 | 5 | 208v | 4.6 |  | 4.6 | B
110 | Mac 2000 | ML2 | 4 | 5 | 208v | 4.6 |  | 4.6 | B
111 | Mac 2000 | ML2 | 5 | 5 | 208v |  | 4.6 | 4.6 | B
112 | Mac 2000 | ML2 | 6 | 5 | 208v |  | 4.6 | 4.6 | B
501 | Chroma Q Par | ML3 | 1 | 8 | 120v | 8 |  |  | C
502 | Chroma Q Par | ML3 | 2 | 8 | 120v |  | 8 |  | C
503 | Chroma Q Par | ML3 | 3 | 8 | 120v |  |  | 8 | C
504 | Chroma Q Par | ML3 | 4 | 8 | 120v | 8 |  |  | C
505 | Chroma Q Par | ML3 | 5 | 8 | 120v |  | 8 |  | C
506 | Chroma Q Par | ML3 | 6 | 8 | 120v |  |  | 8 | C
 |  |  |  |  |  | Total X Draw | Total Y Draw | Total Z Draw
 |  |  |  |  |  | 52.8 | 52.8 | 52.8
Spreadsheet: eab7eec1-c6a7-4256-a240-2e1c09ae25e3
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
42261454 | 2014-07-12 00:40:01 | ALLIES | 0 | 4 | 7 | 1009110 | HO-SA-KAI | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42261591 | 2014-07-12 01:01:28 | AXIS | 0 | 6 | 7 | 1009110 | HO-SA-KAI | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42274017 | 2014-07-12 21:38:06 | ALLIES | 1 | 7 | 4 | 1599538 | [NAME] | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42274241 | 2014-07-12 21:50:21 | AXIS | 1 | 7 | 4 | 1599538 | [NAME] | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42274397 | 2014-07-12 22:14:57 | ALLIES | 0 | 5 | 10 | 509176 | arsenal94 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42274680 | 2014-07-12 22:37:51 | AXIS | 1 | 10 | 6 | 509176 | arsenal94 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42274969 | 2014-07-12 22:52:17 | ALLIES | 0 | 4 | 6 | 509176 | arsenal94 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42275121 | 2014-07-12 23:02:33 | AXIS | 1 | 6 | 2 | 509176 | arsenal94 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
Spreadsheet: 272059d1382175388-if-cell-has-data-the-look-up-value-example-list-rovert7-191013_2
Sheet: Order List

Colour | 1st charm | 1st Letter | 2nd Charm | 2nd Letter | 3rd Charm | 3rd Letter | 3rd Letter | BOX | PILLOW | Price
grey | b'fly | M |  |  |  |  |  | box
aubergine | note | J |  |  |  |  |  | box | pillow
navy | heart | F |  | A |  | K
red | b'fly | M
hot pk | b'fly | N
Spreadsheet: 752351d1634729905-reduce-quantities-stock-quantities-example
Sheet: Sheet1

Stock ID | [NAME] | Order Date | Proposed Allocation | [NAME] |  |  |  |  | Stock ID | Available | [NAME]
23 | 100000 | 2021-04-01 00:00:00 | 100000 | 777 |  |  |  |  | 23 | 200000 | 777
23 | 150000 | 2021-05-01 00:00:00 | 100000 | 777 |  |  |  |  | 23 | 300000 | 666
 |  |  | 50000 | 666 |  |  |  |  | 24 | 100000 | 222
23 | 50000 | 2021-05-20 00:00:00 | 50000 | 666
23 | 25000 | 2021-05-26 00:00:00 | 25000 | 666
23 | 150000 | 2021-05-27 00:00:00 | 150000 | 666
24 | 80000 | 2022-08-01 00:00:00 |  | 222
Spreadsheet: 41486d1239961204-cell-value-based-on-three-references-cells-test
Sheet: Input data sheet

Ref: | 101 |  |  |  |  | Ref: | 102
Ref: | 201 | 202 | 203 | 204 | 205 | Ref: | 201 | 202 | 203 | 204 | 205
Date/Title
1989
1990 | 500 | 400 | 300 | 200 | 500 |  | 450 | 350 | 250 | 150 | 400
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006 | 600 | 500 | 400 | 300 | 300 |  | 350 | 650 | 700 | 300 | 600
2007
2008
2009
2010
2011
2012
2013
2014 | 300 | 200 | 100 | 500 | 200 |  | 600 | 500 | 100 | 330 | 400
Spreadsheet: 732148d1620796953-number-of-different-values-in-a-range-based-on-criteria-test1
Sheet: Sheet1

JAN | 2021-01-01 00:00:00 | AAA | hq
 | 2021-01-12 00:00:00 | AAA | hq
 | 2021-01-20 00:00:00 | AAA |  |  | 2x AAA, so desired value is "1"
FEB | 2021-02-03 00:00:00 | BBB | hq
 | 2021-02-17 00:00:00 | BBB | hq
 | 2021-02-18 00:00:00 | BBB
 | 2021-02-24 00:00:00 | AAA |  |  | 2x BBB, so desired value is "1"
MAR | 2021-03-03 00:00:00 | AAA | hq
 | 2021-03-07 00:00:00 | AAA | hq
 | 2021-03-08 00:00:00 | CCC
 | 2021-03-11 00:00:00 | CCC | hq
 | 2021-03-14 00:00:00 | CCC
 | 2021-03-21 00:00:00 | CCC
 | 2021-03-23 00:00:00 | CCC
 | 2021-03-29 00:00:00 | AAA | hq
 | 2021-03-30 00:00:00 | AAA | hq |  | 4x AAA & 1xCCC, so desired value is "2"
APR | 2021-04-02 00:00:00 | BBB
 | 2021-04-04 00:00:00 | BBB | hq
 | 2021-04-04 00:00:00 | AAA | hq
 | 2021-04-06 00:00:00 | CCC
 | 2021-04-08 00:00:00 | CCC | hq
 | 2021-04-18 00:00:00 | BBB | hq
 | 2021-04-20 00:00:00 | DDD
 | 2021-04-23 00:00:00 | DDD | hq
 | 2021-04-27 00:00:00 | DDD | hq
 | 2021-04-28 00:00:00 | AAA | hq
 | 2021-04-30 00:00:00 | DDD | hq |  | 2x AAA, 2xBBB, 1xCCC, 3xDDD, so desired value is "4"
MAY | 2021-05-02 00:00:00 | EEE
 | 2021-05-04 00:00:00 | AAA | hq
 | 2021-05-05 00:00:00 | CCC | hq
 | 2021-05-07 00:00:00 | CCC | hq
 | 2021-05-08 00:00:00 | BBB |  |  | 1xAAA, 2xCCC, so desired value is "2"
Spreadsheet: 840235d1692599731-extract-data-using-vlookup-sample
Sheet: Sheet1

S/N | MOBILE | SIM NUMBER | VEHICLE PLATE NUMBER | REGION / PLACE | PAGE | Serial NUMBER
1 | NA | 1009184017141 | 551 | NA | NA | 8921101009184017141
2 | NA | 1009184017158 |  | NA | NA | 8921101009184017158
3 | NA | 1009184017166 | 2788 | NA | NA | 8921101009184017166
4 | NA | 1009184017174 | 8291 | NA | NA | 8921101009184017174
5 | NA | 1009184017182 | 75064 | NA | NA | 8921101009184017182
6 | NA | 1009184017190 | 27289 | NA | NA | 8921101009184017190
7 | NA | 1009184017208 | 75049 | NA | NA | 8921101009184017208
8 | NA | 1009184017216 | 154 | NA | NA | 8921101009184017216
9 | NA | 1009184017224 | 8245 | NA | NA | 8921101009184017224
10 | NA | 1009184017232 | 75052 | NA | NA | 8921101009184017232
11 | NA | 1009184017240 | 75075 | NA | NA | 8921101009184017240
12 | NA | 1009184017257 | 28113 | NA | NA | 8921101009184017257
13 | NA | 1009184017265 | 25387 | NA | NA | 8921101009184017265
14 | NA | 1009184017273 | 1582 | NA | NA | 8921101009184017273
15 | NA | 1009184017281 | 5154 | NA | NA | 8921101009184017281
Spreadsheet: 73077d1273741615-excel-2007-how-to-get-columise-data-out-of-raw-data-copy-of-textparsesample-1-
Sheet: Sheet1

itemisation for 07970 708792
Date Day Time Number Place called Call Service plan Duration Cost
class element hr:min:sec
08/04/10 Thu 13:55 [PHONE] Orange talk CUG Calls 0:02:47 0.000
14:34 [PHONE] Orange talk CUG Calls 0:07:42 0.000
14:49 [PHONE] Orange talk CUG Calls 0:00:53 0.000
14:51 [PHONE] Orange talk CUG Calls 0:00:42 0.000
09/04/10 Fri 08:39 [PHONE] Orange talk CUG Calls 0:02:08 0.000
09:41 [PHONE] Orange talk CUG Calls 0:04:20 0.000
09:46 [PHONE] Orange talk CUG Calls 0:00:14 0.000
09:47 [PHONE] Orange talk CUG Calls 0:00:15 0.000
09:48 [PHONE] Orange talk CUG Calls 0:01:27 0.000
09:54 [PHONE] Orange talk CUG Calls 0:02:34 0.000
11:45 [PHONE] Orange talk CUG Calls 0:00:47 0.000
11:46 [PHONE] Orange talk CUG Calls 0:00:32 0.000
11:47 [PHONE] Orange talk CUG Calls 0:04:36 0.000
11:53 [PHONE] Orange talk CUG Calls 0:00:37 0.000
11:57 [PHONE] Orange talk CUG Calls 0:00:22 0.000
13:41 [PHONE] Orange talk CUG Calls 0:00:18 0.000
13:42 [PHONE] Orange talk CUG Calls 0:00:54 0.000
19:44 [PHONE] Orange talk CUG Calls 0:00:20 0.000
19:45 [PHONE] Orange talk CUG Calls 0:00:50 0.000
19:46 [PHONE] Orange talk CUG Calls 0:01:18 0.000
10/04/10 Sat 15:29 [PHONE] Orange talk CUG Calls 0:00:42 0.000
15:46 [PHONE] Orange talk CUG Calls 0:00:55 0.000
23:53 [PHONE] Orange talk CUG Calls 0:01:01 0.000
23:56 [PHONE] Orange talk CUG Calls 0:00:24 0.000
11/04/10 Sun 06:35 [PHONE] Orange talk CUG Calls 0:00:23 0.000
12:44 [PHONE] Manchester talk 500 mins 0:01:00 0.000
talk 500 mins 0:04:29 0.000
17:16 [PHONE] Orange talk CUG Calls 0:00:44 0.000
12/04/10 Mon 18:45 [PHONE] Orange talk CUG Calls 0:04:43 0.000
19:02 [PHONE] Other Mobile Network talk 500 mins 0:04:00 0.000
19:08 [PHONE] Other Mobile Network talk 500 mins 0:00:05 0.000
19:18 [PHONE] Other Mobile Network talk 500 mins 0:00:07 0.000
19:22 [PHONE] Manchester talk 500 mins 0:00:18 0.000
19:24 [PHONE] Other Mobile Network talk 500 mins 0:07:21 0.000
19:33 [PHONE] Orange talk CUG Calls 0:03:53 0.000
13/04/10 Tue 08:40 [PHONE] Other Mobile Network talk 500 mins 0:01:35 0.000
10:34 [PHONE] Orange talk CUG Calls 0:01:23 0.000
10:43 [PHONE] Orange talk CUG Calls 0:00:28 0.000
10:50 [PHONE] Orange talk CUG Calls 0:00:37 0.000
11:32 [PHONE] Orange talk CUG Calls 0:01:02 0.000
14:56 [PHONE] Orange talk CUG Calls 0:00:28 0.000
14:57 [PHONE] Orange talk CUG Calls 0:00:16 0.000
14/04/10 Wed 10:47 [PHONE] Orange talk CUG Calls 0:03:22 0.000
11:42 [PHONE] Orange talk CUG Calls 0:01:46 0.000
12:16 [PHONE] Orange talk CUG Calls 0:00:43 0.000
12:17 [PHONE] Orange talk CUG Calls 0:01:17 0.000
Sub total  £0.000
Continued overleaf
Spreadsheet: 299730d1393274347-conditional-format-to-highlight-anything-that-is-not-a-whole-number-whole-numbers
Sheet: Sheet1

1
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
2
2.1
2.2
2.3
2.4
2.5
2.6
2.7
2.8
2.9
3
3.1
Spreadsheet: 110280d1306983740-evenly-distribute-values-that-have-different-frequencies-fruit_salad
Sheet: Sheet1

Fruit | Quantity | Actual
Apples | 10 | 10
Oranges | 8 | 8
Bananas | 2 | 2
1 | Apples
2 | Oranges
3 | Apples
4 | Oranges
5 | Apples
6 | Oranges
7 | Apples
8 | Oranges
9 | Apples
10 | Oranges
11 | Apples
12 | Bananas
13 | Oranges
14 | Apples
15 | Oranges
16 | Apples
17 | Bananas
18 | Apples
19 | Oranges
20 | Apples
Spreadsheet: 835051d1688242775-locate-multiple-match-results-and-return-adjacent-cell-value-sample-49-
Sheet: Sheet1

 | ⤋  Source Data  ⤋ |  | ⤋  Trying to get Results  ⤋ |  |  |  | ⤋  Source Data  ⤋ |  | ⤋  Expected Result  ⤋
 |  |  |  |  | [NAME]
 | JobCost | JobName | JobCostSort | RowForIndex | JobNameSort1 |  | JobCost | JobName | JobCostSort | JobNameSort
 | 5 | Job 1 |  |  |  |  | 5 | Job 1 |  | Job 18 |  |  | Job 18
 | 7 | Job 2 |  |  |  |  | 7 | Job 2 |  | Job 20 |  | 21 | Job 20
 | 0 | Job 3 |  |  |  |  | 0 | Job 3 |  | Job 17 |  | 20 | Job 17
 | 6 | Job 4 |  |  |  |  | 6 | Job 4 |  | Job 19 |  | 17 | Job 19
 | 0 | Job 5 |  |  |  |  | 0 | Job 5 |  | Job 12 |  | 16 | Job 12
 | 12 | Job 6 |  |  |  |  | 12 | Job 6 |  | Job 7 |  | 15 | Job 7
 | 15 | Job 7 |  |  |  |  | 15 | Job 7 |  | Job 15 |  | 14 | Job 15
 | 3 | Job 8 |  |  |  |  | 3 | Job 8 |  | Job 13 |  | 13 | Job 13
 | 2 | Job 9 |  |  |  |  | 2 | Job 9 |  | Job 6 |  | 12 | Job 6
 | 5 | Job 10 |  |  |  |  | 5 | Job 10 |  | Job 14 |  | 9 | Job 14
 | 0 | Job 11 |  |  |  |  | 0 | Job 11 |  | Job 2 |  | 7 | Job 2
 | 16 | Job 12 |  |  |  |  | 16 | Job 12 |  | Job 4 |  | 6 | Job 4
 | 13 | Job 13 |  |  |  |  | 13 | Job 13 |  | Job 1 |  | 5 | Job 1
 | 9 | Job 14 |  |  |  |  | 9 | Job 14 |  | Job 10 |  | 5 | Job 10
 | 14 | Job 15 |  |  |  |  | 14 | Job 15 |  | Job 8 |  | 3 | Job 8
 | 0 | Job 16 |  |  |  |  | 0 | Job 16 |  | Job 9 |  | 2 | Job 9
 | 20 | Job 17 |  |  |  |  | 20 | Job 17 |  | Job 3 |  | 0 | Job 3
 | 25 | Job 18 |  |  |  |  | 25 | Job 18 |  | Job 5 |  | 0 | Job 5
 | 17 | Job 19 |  |  |  |  | 17 | Job 19 |  | Job 11 |  | 0 | Job 11
 | 21 | Job 20 |  |  |  |  | 21 | Job 20 |  | Job 16 |  | 0 | Job 16
Spreadsheet: 734073d1621966811-getting-week-and-month-number-based-on-week-number-week-and-month-number-based-on-week-number
Sheet: Sheet1

 |  |  |  |  |  |  |  | 2021-04-01 00:00:00
Type-1 |  | Type-2 |  |  |  |  |  | 1
START | [NAME] | START | [NAME] | Start Week | Complete Week | Duration (Weeks)
 |  |  | 2021-06-30 00:00:00 | 1 | 12
 |  |  | 2021-08-22 00:00:00 | 9 | 19
 |  |  | 2021-08-15 00:00:00 | 1 | 18
 |  |  |  | 1 | 2
 |  |  |  | 9 | 10
 |  |  |  | 13 | 24
 |  |  |  | 9 | 66