tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-13-F-0002

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-13-F-0002 | 10250977 |  | 1P
W912LP-13-F-0002 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 116029d1311522312-selective-columns-handicap-template-midshires
Sheet: pd

Pennington. Carol |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: sally_beck__33954__Weekly Operating Report 2-15
Sheet: Weekly Report

Principal Projects / Deals: |  |  |  |  |  |  |  | New Deals |  |  |  |  |  |  |  | Physical Volume of New Deals
Accelerated Solutions Environment - Commercialization of Operations |  |  |  |  |  |  |  |  | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1 | 2/2 -2/8 | 2/9 -2/15 | Total |  |  | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1 | 2/2 -2/8 | 2/9 -2/15 | Total
 | Conducted the ASE on February 12 and 13 in Dallas, TX. |  |  |  |  |  |  | EA |  |  |  |  |  |  |  | EA (in millions)
 | This two day event was attended by the management |  |  |  |  |  |  | Gas |  |  |  |  |  |  |  | Gas
 | of energy operations and other business units. |  |  |  |  |  |  | Power |  |  |  |  |  |  |  | Power
 | The findings of the ASE and the potential commercialization |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EGM (in thousands)
 | of operations will be finalized during the next several weeks. |  |  |  |  |  |  | EGM |  |  |  |  |  |  |  | Liquids
 |  |  |  |  |  |  |  | IR/FX |  |  |  |  |  |  |  | Coal
 |  |  |  |  |  |  |  | Liquids |  |  |  |  |  |  |  | Emissions
HPL Monetization: |  |  |  |  |  |  |  | Coal |  |  |  |  |  |  |  | EIM Total*
 | -  maintain operations and staff effectiveness through |  |  |  |  |  |  | Weather |  |  |  |  |  |  |  | Newsprint
 | transfer date |  |  |  |  |  |  | Emissions |  |  |  |  |  |  |  | Pulp
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lumber
 |  |  |  |  |  |  |  | EIM |  |  |  |  |  |  |  | Steel
 |  |  |  |  |  |  |  | Newsprint |  |  |  |  |  |  |  | * Breakout of EIM volumes not available at this time
 |  |  |  |  |  |  |  | Pulp |  |  |  |  |  |  |  |  | New Counterparties
Management information regarding PG&E |  |  |  |  |  |  |  | Lumber |  |  |  |  |  |  |  |  |  | 1/19 - 1/25 | 1/26 - 2/2 | 2/2 -2/8 | 2/9 -2/15
 |  |  |  |  |  |  |  | Steel |  |  |  |  |  |  |  | E-Commerce |  | 14 | 8 | 13 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non E-Commerce |  | 22 | 33 | 13 | 26
Spreadsheet: 724832d1616410782-sumifs-using-months-and-years-from-a-normal-date-book1
Sheet: sales

Sell-to Customer No. | Customer Name | Document No. | Posting Date | Type | No. | Description | Quantity | Unit [NAME]. VAT | Amount | Unit Cost (LCY) | Unit Cost | Original Order Qty.
C000503 | daveshop | SI196118 | 2020-01-02 00:00:00 | Item | 12345 | a product | 120 | 0.6 | 72 | 0.41 | 0.41 | 120
C000503 | daveshop | SI196118 | 2020-02-03 00:00:00 | Item | 12345 | a product | 120 | 0.6 | 72 | 0.41 | 0.41 | 120
C000503 | daveshop | SI196118 | 2020-02-03 00:00:00 | Item | 12345 | a product | 120 | 0.6 | 72 | 0.41 | 0.41 | 120
C000503 | daveshop | SI196118 | 2020-02-03 00:00:00 | Item | 12346 | a product | 120 | 0.6 | 72 | 0.41 | 0.41 | 120
C000503 | daveshop | SI196118 | 2020-02-03 00:00:00 | Item | 12345 | a product | 120 | 0.6 | 72 | 0.41 | 0.41 | 120
C000503 | daveshop | SI196118 | 2020-02-03 00:00:00 | Item | 12346 | a product | 120 | 0.6 | 72 | 0.41 | 0.41 | 120
C000503 | daveshop | SI196118 | 2020-03-08 00:00:00 | Item | 12345 | a product | 120 | 0.6 | 72 | 0.41 | 0.41 | 120
C000503 | daveshop | SI196118 | 2020-03-08 00:00:00 | Item | 12345 | a product | 120 | 0.6 | 72 | 0.41 | 0.41 | 120
C000503 | daveshop | SI196118 | 2020-03-08 00:00:00 | Item | 12346 | a product | 120 | 0.6 | 72 | 0.41 | 0.41 | 120
Spreadsheet: 58288d1258561222-counting-a-value-based-on-a-range-of-dates-excel-forum-query-181109
Sheet: Sheet1

Date Opened | Category |  | All Category 1: |  |  | 3 | COUNTIF(B:B, "1")
2009-06-12 00:00:00 | 2 |  | All Category 2: |  |  | 4 | COUNTIF(B:B, "2")
2009-06-15 00:00:00 | 1 |  | All Category 3: |  |  | 3 | COUNTIF(B:B, "3")
2009-06-29 00:00:00 | 2
2009-06-29 00:00:00 | 3 |  | All June 2009 |  |  | 4 | COUNTIF(A:A, ">31/05/2009")-COUNTIF(A:A, ">30/06/2009")
2009-07-01 00:00:00 | 2 |  | All July 2009 |  |  | 6 | COUNTIF(A:A, ">30/06/2009")-COUNTIF(A:A, ">31/07/2009")
2009-07-08 00:00:00 | 1
2009-07-08 00:00:00 | 3 |  | June 2009 Category 1???
2009-07-09 00:00:00 | 2 |  | June 2009 Category 2???
2009-07-20 00:00:00 | 1 |  | June 2009 Category 3???
2009-07-20 00:00:00 | 3 |  | July 2009 Category 1???
 |  |  | July 2009 Category 2???
 |  |  | July 2009 Category 3???
Spreadsheet: 224914a3-bd3d-4186-896c-b2b5634132af
Sheet: Sheet1

Smoking Prevalence: 2010 | Unnamed: 1 | Unnamed: 2
Cigarette Smoking Prevalence, Adults Aged 16 and Over, by English Government Office Region
Government Office Region | Sex | Cigarette Smoking Prevalence
England | Male | 0.2
 | Female | 0.19
East Midlands | Male | 0.15
 | Female | 0.17
East of England | Male | 0.2
 | Female | 0.17
London | Male | 0.19
 | Female | 0.16
North East | Male | 0.17
 | Female | 0.25
North West | Male | 0.23
 | Female | 0.22
South East | Male | 0.21
 | Female | 0.18
South West | Male | 0.18
 | Female | 0.17
West Midlands | Male | 0.21
 | Female | 0.21
Yorkshire & the Humber | Male | 0.24
 | Female | 0.22
Prepared by Cancer Research UK
Original data sources:
Office for National Statistics. General [NAME] 2010. Accessed March 2012.
http://www.ons.gov.uk/ons/rel/ghs/general-lifestyle-survey/2010/index.html
Spreadsheet: 879442d1726965100-how-to-leave-out-any-columns-that-have-all-0-00-in-them-testfile
Sheet: Agent Charges

Agent Charges
 |  |  |  |  | **Note: Goal to leave out columns that have all '0.00' charges.
Assesorial Charges by Agent: |  |  | AGT-1
Date | Client | Job # | POL | POD | Final Dest | # Pieces | Gross Wght (kgs) | CBM | [NAME] | Agent | Agent Total Chgs | Carrier | Profit Share/ Commission | 100% Profit Share (WWL) | Ocean Freight Quote Rate: | Ocean Freight (Pre-Paid) | Ocean Freight (Collect) | Peak Season Surcharge - PSS | VGM/Solas (weighing)Handling Fee | FOB | Liability | Port Charges (Origin) | Wharfage Tax | Warehouse Charge | AMS Security Fee | ISF 10+2 | HBL Fee | [NAME] | [NAME] of Lading | Telex Release Fee | Seal Fee | Lashing Charge | Non-Stackable Charge | [NAME] | Cargo Handling Charge (CHC) | Ancillaries | THC/ Handling @ Origin | Printed Matter & Forms/ Handling Charge or Quay | Processing | DOC Charge | CFS Charge | Dest Delivery Charge | Pick-up/ Trucking Charge | Inland Trans,P/U @ Shippers | Inland Drayage | Chassis Usage Charge (CUC) | Bunker Adjustment Factor - Fuel (BAF) | [NAME] | CO2 Safety Emissions Env Fee | Energy Adjustment Levy - EAL | Comm Inspection Fee | Compliance Charge | Customs Clearance | Customs Clearance Doc | [NAME] | (Port Security) I.S.P.S. Fee | Fixed Costs | Co-Loader Chgs pre-pd (WWL)
 | Client-1 | 1 | Barcelona | NY | Boston | 1-pallet | 68 | 0.315 | LCL | AGT-1 | 604 | CMA | 0 | 0 | 0 | 0 | 132 | 0 | 38.45 | 140.56 | 7.14 | 0 | 4.14 | 0 | 103.69 | 88.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 53.02 | 0 | 0 | 0 | 0 | 0 | 35.82 | 0 | 0 | 0 | 0 | 1.08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-09-15 00:00:00 | Client-1 | 2 | Barcelona | NY | Boston | 1-pkg | 92 | 0.24 | LCL | AGT-1 | 578.87 | ZIM | 0 | 0 | 0 | 0 | 116 | 0 | 38.04 | 139.06 | 7.06 | 0 | 4.1 | 0 | 102.59 | 87.16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 52.46 | 0 | 0 | 0 | 0 | 0 | 30.86 | 0 | 0 | 0 | 0 | 1.54 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-07-26 00:00:00 | Client-2 | 9 | qingdao | NY | Boston | 1-pallet/ 24-bags | 630 | 1 | LCL | AGT-1 | 0 | Ever | 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: 691718d1597840665-monthly-payroll-time-sheet-formula-help-me-payroll
Sheet: Sheet 1

HINDAS ENTERPRESIES - SALARY SHEET
Trading Division
Month : | Novebmer.2020 |  |  |  |  | Empolyee No : |  |  | AZ099
Name  : | M Roger |  |  |  |  | Designation  : |  |  | Sales
Days for the month : |  | 30 |  | Days Absent: |  |  |  | Days worked :
Salary |  |  |  |  |  | Over Time
Basic   : |  |  |  | 3000 |  | Total  : |  |  |  | 44
Per Day : |  |  |  |  |  | Per hour  :
Gross Salary  : |  | SR.
Over Time July: |  | SR.
Food Allowance  : |  | SR. |  | 350
Adjustments  : |  | SR. |  | 1000
Net Salary  : |  |  |  |  |  | Received by :
Details of Adjustments:-
Sales Commission
HINDAS ENTERPRESIES - SALARY SHEET
Trading Division
Month : | [NAME] |  |  |  |  | Empolyee No : |  |  | AZ099
Name  : | M Roger |  |  |  |  | Designation  : |  |  | Salesman
Days for the month : |  | 31 |  | Days Absent: |  |  |  | Days worked :
Salary |  |  |  |  |  | 8
Basic   : |  |  |  | 3000 |  | Total  : |  |  |  | 47
Per Day : |  |  |  |  |  | Per hour  :
Gross Salary  : |  | SR.
Over Time Feb: |  | SR.
Food Allowence |  | SR.
Adjustments  : |  | SR. |  | 850
Net Salary  : |  |  |  |  |  | Received by :
Details of Adjustments:-
Spreadsheet: 101572d1299680937-excel-2007-obtaining-data-from-a-different-tab-weaponx2011
Sheet: Adrian

# | Position | Player | Cost | Years
1 | C | [NAME] | 0.25 | 1
2 | 1B | [NAME] | 3 | 1 |  | Adrian |  |  | C | 1B | 2B
3 | 2B | Chase Utley | 15.25 | 1 |  | Roster: |  |  | [NAME] | [NAME] | Chase Utley
4 | 3B | [NAME] | 16 | 1 |  | C: | 2 |  | Tyler Flowers | [NAME] | #N/A
5 | SS | [NAME] | 8 | 1 |  | 1B: | 2 |  | #N/A | #N/A | #N/A
6 | OF | [NAME] | 5 | 1 |  | 2B: | 1 |  | #N/A | #N/A | #N/A
7 | OF | [NAME] | 8.5 | 1 |  | SS: | 1
8 | OF | Hunter Pence | 3 | 1 |  | 3B: | 2 |  | 3B | SS | OF
9 | C | Tyler Flowers | 0.25 | 2 |  | OF: | 3 |  | [NAME] | [NAME] | [NAME]
10 | 1B | [NAME] | 0.5 | 1 |  | SP: | 8 |  | [NAME] | #N/A | [NAME]
11 | 3B | [NAME] | 0.25 | 1 |  | RP: | 2 |  | #N/A | #N/A | Hunter Pence
12 | FARM | Wilmer Flores | 0.5 | 1 |  | FARM: | 4 |  | #N/A | #N/A | #N/A
13 | FARM | [NAME] | 0.25 | 1 |  | DH: | 0 |  |  |  | #N/A
14 | SP | [NAME] | 1 | 1 |  |  |  |  |  |  | #N/A
15 | SP | [NAME] | 20.25 | 1 |  | Spent: | 103.75 |  |  |  | #N/A
16 | SP | [NAME] | 15 | 1 |  | Available: | 21.25
17 | SP | [NAME] | 1 | 1 |  | Farm Spent | 1.5 |  | SP | RP | FARM
18 | SP | Edison Volquez | 1 | 2 |  | Farm Available | 8.5 |  | [NAME] | [NAME] | Wilmer Flores
19 | RP | [NAME] | 1 | 1 |  | Farm Over $2 | 0 |  | [NAME] | [NAME] | [NAME]
20 | SP | [NAME] | 0.5 | 1 |  |  |  |  | [NAME] | #N/A | [NAME]
21 | SP | [NAME] | 1.25 | 2 |  | Players / Roster |  |  | [NAME] |  | [NAME]
22 | SP | [NAME] | 0.75 | 2 |  | Total Players | 25 |  | Edison Volquez |  | #N/A
23 | RP | [NAME] | 0.5 | 1 |  | Farm Players | 4 |  | [NAME] |  | #N/A
24 | FARM | [NAME] | 0.5 | 2 |  | Players Remaing | 15 |  | [NAME] |  | #N/A
25 | FARM | [NAME] | 0.25 | 1 |  |  |  |  | [NAME] |  | #N/A
26 |  |  |  |  |  | Per Player Stats |  |  | #N/A |  | #N/A
27 |  |  |  |  |  | Per Player Remain | 1.416666666666667 |  | #N/A |  | #N/A
28 |  |  |  |  |  | [NAME] for one: | 17.75 |  | #N/A |  | #N/A
29 |  |  |  |  |  |  |  |  | #N/A |  | #N/A
30 |  |  |  |  |  | Dead Contracts | 0 |  | #N/A
31 |  |  |  |  |  |  |  |  | #N/A | DH
32 |  |  |  |  |  |  |  |  | #N/A | #N/A
33 |  |  |  |  |  |  |  |  |  | #N/A
34
35
36
37
38
39
40
Spreadsheet: 823415d1679950282-minimize-formula-too-long-for-a-cell-excelforum
Sheet: Sheet1

 |  |  | Jan | Feb | Mar | Apr | May | Jun |  | Aug | Sep | Oct | Nov | Dec
 | Food cost
 |  | 2023-04-01 00:00:00 | FRESH CAFE HAMILTON ON |  | -2.89
 |  | 2023-04-01 00:00:00 | FRESH CAFE HAMILTON ON |  | -61.29
 |  | 2023-05-01 00:00:00 | THE HOME DEPOT #7007 ANCASTER ON |  | -49.31
 |  | 2023-05-01 00:00:00 | THE HOME DEPOT #7007 ANCASTER ON |  | 22.58
 |  | 2023-06-01 00:00:00 | FOOD BASICS 687 HAMILTON ON |  | -39.44
 |  | 2023-08-01 00:00:00 | Amazon.ca Prime [NAME] |  | -11.29
 |  | 2023-08-01 00:00:00 | FOOD BASICS 836 HAMILTON ON |  | -57.75
 |  | 2023-08-01 00:00:00 | ESSO CIRCLE K HAMILTON ON |  | -70.66
 |  | 2023-08-01 00:00:00 | FARM BOY #16 HAMILTON ON |  | -23.9
 |  | 2023-09-01 00:00:00 | CDN TIRE STORE #00177 HAMILTON ON |  | -158.37
 |  | 2023-09-01 00:00:00 | BEACH ROAD STEEL SALES |  | -63.88
 |  | 2023-09-01 00:00:00 | VALUE VILLAGE # 2045 HAMILTON ON |  | -30.43
 |  | 2023-10-01 00:00:00 | METRO 208 HAMILTON ON |  | -29.32
 |  | 2023-11-01 00:00:00 | MANCHU WOK WOK037 GRIMSBY ON |  | -15.42
 |  | 2023-11-01 00:00:00 | FOOD BASICS 836 HAMILTON ON |  | -37
 |  | 1/13/2023 | BEACH ROAD STEEL |  | -28.1
 |  | 1/14/2023 | FOOD BASICS 836 |  | -95.87 |  |  |  |  |  | food
 |  | 1/14/2023 | VALUE VILLAGE # 2045 |  | -81.3 |  |  |  |  |  | farm
 |  | 1/17/2023 | ESSO CIRCLE K |  | -73.88 |  |  |  |  |  | metro
 |  | 1/18/2023 | LA LUNA RESTAURANT |  | -29.99
 |  | 1/19/2023 | TELEPHONE |  | -207.92
 |  | 1/20/2023 | FOOD BASICS 687 HAMILTON ON |  | -38.92
Spreadsheet: 82764d1282781170-competition-template-if-statement-problems-demo
Sheet: Requirements

I have tried to sort this out using only the 1st Event, and thought that it would be a difficult IF statement, but simply cant get it quite right!
Therefore, hope you guys can help me!!!
Here is what I what to happen:
There are two options which are part and parcel for each event…they are:
Doubles? And [NAME]?  Each of these has 3 options which are applied via data validation…they are No, Yes, N/A
Players are entered in Column A (from A7 To A202).
If there is text in Ax then a tic is displayed in Bx via worksheet change.
Clearly if the Doubles option is selected (Yes) then there must be a Partner written in the corresponding column D (Cannot be repeated more than once…
again done via data validation!)
Additionally, if there is a seeding event then the [NAME] option must be "Yes" and there cannot be any repeats
PROBLEM 1:  If the doubles comp is selected then the combined total CANNOT contain something like Fred /
How can I flag this as a error or as "Player Required"
Problem 2: If doubles is not "Yes" then the combined column just shows the orginal player I.e. column A
And of course if column B is not ticked (a) then the combined column must be blank and not 0
Please note the combined column contains a PROPER function to keep it tidy.
I have added a helper column to nearly get this working but I would rather not have it, as I'm sure that this is possible without it!
I cannot get my head around an udf to do this…especially as this needs to be replicated for each of the 20 events!!!
Finally, I would really like each event to have a final column named [NAME] which would automatically update each event with an list
starting from the highest seed down to the lowest seed and then all the unseeded guys alphabetically from A:z
I have spent sometime on this, and I really hope you guys can help….Many thanks for looking.  Skyping
Spreadsheet: 196769d1354104584-lookup-in-multiple-sheets-222-2
Sheet: Sheet1

Dept | Project No | Request Date | Request No | Date | Low | Medium | High | Potential Suppliers | Currency | item # | Description | Unit Price
1 | 12-EG-LB-000 | 2012-10-10 00:00:00 | 12-HO-QUR-001-A | 2012-10-20 00:00:00 |  |  | X | zzzzz | USD | 1 | [NAME] or 800 and [NAME] | 60
1 | 12-EG-LB-000 | 2012-10-11 00:00:00 | 12-HO-QUR-001-B | 2012-10-21 00:00:00 |  |  | X | xxxxx | USD | 2 | Logitech Wireless Desktop MK220 920-003160 | 10
1 | 12-EG-LB-000 | 2012-10-12 00:00:00 | 12-HO-QUR-001-C | 2012-10-22 00:00:00 |  |  | X | sssss | USD | 3 | [NAME] Keybord 8000x & [NAME] | 20
 |  |  | 12-HO-QUR-001-DD |  |  |  |  |  |  |  | [NAME] or 800 and [NAME]
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
Spreadsheet: 705405d1606112299-calculate-hours-per-month-based-on-start-and-end-date-book1
Sheet: Sheet1

Task Name | StartDate | EndDate | Hours |  | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00
Task 1 | 2020-07-30 00:00:00 | 2020-08-31 00:00:00 | 13.8
Task 2 | 2020-07-30 00:00:00 | 2021-01-05 00:00:00 | 136.8
Task 3 | 2020-08-18 00:00:00 | 2020-08-24 00:00:00 | 72
Task 4 | 2020-08-25 00:00:00 | 2020-08-31 00:00:00 | 48
Task 5 | 2020-09-01 00:00:00 | 2020-10-15 00:00:00 | 326.6999984741211
Task 6 | 2020-10-16 00:00:00 | 2020-11-16 00:00:00 | 26.4
Task 7 | 2020-10-16 00:00:00 | 2020-12-13 00:00:00 | 147.6
Task 8 | 2020-10-16 00:00:00 | 2021-01-05 00:00:00 | 278.4
Task 9 | 2020-11-16 00:00:00 | 2020-11-29 00:00:00 | 60
Task 10 | 2020-12-14 00:00:00 | 2021-01-05 00:00:00 | 10.2
Grand Total |  |  | 1119.899998474121
Spreadsheet: 864782d1711903892-create-new-list-of-matching-records-sample-workbook-38-aligw
Sheet: Background

FOCUS PRODUCTS SOLD OVER THE WEEK
Item | Category | Weight | Price | Remarks
Fish | Other | 120 | 10 | Hallibut
Fish | Other | 140 | 12.3 | Skate
Candy | Snacks | 30 | 1.4 | [NAME]
Candy | Snacks | 34 | 120 | Reese's Peanut Butter Cups
Fish | Other | 150 | 12.9 | Cod
Fish | Other | 120 | 10 | Shrimps
Fish | Other | 140 | 12.3 | Crayfish
Candy | Snacks | 30 | 1.4 | M&Ms
Candy | Snacks | 34 | 120 | Mike & Ikes
Fish | Other | 150 | 13.4 | Monkfish
 | Other | 120 | 10 | Hallibut
Fish | Other | 140 | 12.3 | Skate
Candy | Snacks | 30 | 1.4 | [NAME]
Candy | Snacks | 34 | 120 | Reese's Peanut Butter Cups
Fish | Other | 150 | 12.9 | Cod
Fish | Other | 120 | 10 | Shrimps
Fish | Other | 140 | 12.3 | Crayfish
Candy | Snacks | 30 | 1.4 | M&Ms
Candy | Snacks | 34 | 120 | Mike & Ikes
Fish | Other | 150 | 13.4 | Monkfish
Spreadsheet: 12584ee7-7669-4af4-a751-e005a0aaf796
Sheet: Sheet1

Engineering and Electronics Technology* | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Associate of Applied Science Degree
Name |  |  | Student ID Number |  |  |  | Date Entered:
Address |  |  | Phone: |  |  |  | Proposed Graduation Date:
 |  |  | [NAME]:
 |  |  | Student Signature: |  |  |  |  | Date:
 |  |  | Advisor Signature: |  |  |  |  | Date:
 |  |  | Authorizing Signature: |  |  |  |  | Date:
Remedial Courses As Needed |  |  |  | Grade | Semester Taken
010 RDG + 12 DRE - Intro. to [NAME]
020 RDG + 101 GE - Improved College Reading
030 RDG + 101 GE (if not already completed)
090 ENC - Foundations of College Writing I
091 ENC - Foundations of College Writing II
055 MT - Pre-Algebra
065 MT - Elemtary Algebra
120 MT - Intermediate Algebra
General Education Courses (Core Curiculum) |  |  |  |  | Credit  Hours | Grade | Semester Taken | Note
ENG101 - Writing I |  |  |  |  | 3
Communications Course |  |  |  |  | 3
Mathematics Course (MT 150 or MAT 126) |  |  |  |  | 3
Heritage/Humanities Course |  |  |  |  | 3
Social Science Course |  |  |  |  | 3
Physics Course (PHY 171 or higher level) |  |  |  |  | 3-4
Total Gen. [NAME]. Semester Hours |  |  |  |  | 18-19
Technical Core Courses |  |  |  |  | Credit  Hours | Grade | Semester Taken | Note
ELT 110 | Circuits I |  |  |  | 5
ELT 114 | Circuits II |  |  |  | 5
ELT 210 | Devices I |  |  |  | 4
ELT 120 | Digital I |  |  |  | 3
CAD 100 | Introduction to Computer Aided Design OR |  |  |  | 3
 | Equivalent course with consent of APC |  |  |  | 3
 | Computer Literacy Course |  |  |  | 3
ELT289 | ELT Capstone Course |  |  |  | 1
Total Technical Core Hours |  |  |  |  | 24
Mechanical Specialization Courses |  |  |  |  | Credit Hours | Grade | Semester Taken | Note
ELT122 | Mechanical Power Transmission Systems & |  |  |  | 3 |  |  | Technical Electives:
ELT124 | MPT Systems Lab |  |  | OR | 1 |  |  | See Advisor
IMT150 | Maintaining Industrial Equipment I |  |  | AND | 3
IMT151 | Maintaining Industrial Equipment I Lab |  |  |  | 2
ELT265 | Applied Fluid Power |  |  |  | 3
BRX120 | Basic Blueprint Reading |  |  |  | 3
CAD200 | Intermediate Computer Aided Drafting |  |  |  | 4
Technical Electives - see program coordinator |  |  |  |  | 8
Total Specialization Hours |  |  |  |  | 22-23
*This curriculum is to be followed by students entering this program beginning Fall 2011 or after.
Spreadsheet: 869663d1716276426-propotionally-assign-condition-total-condition
Sheet: Sheet1

Object code | Object | Condition | Area size | Total area | Total condition
AIAHARIDUSKESK_3 | PARGISAREVERE | 4 | 2406.1 |  | 3
AIAHARIDUSKESK_3_1 | PARGISAREVERE | 3 | 3000 |  | 3
ADALA2D | ADALA2D | 5 | 392.1 |  | 5
ADALA2D01 | ADALA2D | 2 | 0 |  | 5
ADALA2D02 | ADALA2D | 2 | 0 |  | 5
ADALA2D03 | ADALA2D | 5 | 624.7 |  | 5
ADALA2D04 | ADALA2D | 5 | 1265.7 |  | 5
ADALA2D05 | ADALA2D | 4 | 1013.4 |  | 5
ADALA4E_1 | ADALA2D | 3 | 569 |  | 5
ADALA4E_2 | ADALA2D | 3 | 128.1 |  | 5
ADALA4E_3 | ADALA2D | 2 | 453.8 |  | 5
ADALA4E_4 | ADALA2D | 2 | 1000.1 |  | 5
Spreadsheet: 220165d1363086724-finding-text-in-cell-comp-points
Sheet: Sheet1

 | Competition Grade |  |  |  |  | Grade |  | Points
 | Group 1 |  |  |  |  | Class | Group 1 | 10
Rider | Class | Points |  |  |  |  | Group 2 | 8
 |  |  |  |  |  |  | Group 3 | 6
week 1 | [NAME] |  |  |  |  |  | Grade 1 | 5
week 2 | [NAME] |  |  |  |  |  | [NAME] | 4
week 3 | 0 |  |  |  |  |  | [NAME] | 3
week 4 | 0 |  |  |  |  |  | [NAME] | 2
 |  |  |  |  |  |  | Mixed 4/5 | 2
 |  |  |  |  |  |  | Grade 5 | 1
 | =
Spreadsheet: 183889d1349087137-consectutive-numbers-0a1_fot_f1-1-
Sheet: Φύλλο1

1992-03-07 00:00:00
1992-03-08 00:00:00
1992-03-09 00:00:00
1992-03-10 00:00:00 |  |  |  | It ranges between 33670 & 44853
1992-03-11 00:00:00
1992-03-12 00:00:00 |  |  |  | Fotis - It does work thanks, as your example cannily reflects mine there is often a gap of more than 1 number, so for instance 33670 might then be followed by 33678, so just putting the one ticket number only highlights a gap. What might actually be better is if i can count the number of tickets missing between the two numbers and insert that value?
1992-03-13 00:00:00
33781
33680
1992-03-16 00:00:00
1992-03-17 00:00:00
1992-03-18 00:00:00
1992-03-19 00:00:00
1992-03-20 00:00:00
41125
1992-03-22 00:00:00
1992-03-23 00:00:00
1992-03-24 00:00:00
1992-03-25 00:00:00
1992-03-26 00:00:00
42895
43555
42785
1992-03-30 00:00:00
1992-03-31 00:00:00
1992-04-01 00:00:00
1992-04-02 00:00:00
1992-04-03 00:00:00
1992-04-04 00:00:00
1992-04-05 00:00:00