tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a6a6dbe8-0e83-4a4d-876d-87037694536e
Sheet: TTM Recon Q3FY12

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended December 31, 2011
 | GAAP Results |  | Acquisition-related expenses |  | Amortization of debt discount |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Licensed Intellectual Property Commitment (COGS) |  | Gain on Strategic Investments |  | Restructuring charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 3865 |  | 0 |  | 0 |  | 339 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 4204
Cost of goods sold | 1552 |  | -28 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -1 |  | 0 |  | 1523
Gross profit | 2313 |  | 28 |  | 0 |  | 339 |  | 0 |  | 0 |  | 0 |  | 1 |  | 0 |  | 2681
Operating expenses:
Marketing and sales | 825 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -23 |  | 0 |  | 802
General and administrative | 335 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -37 |  | 0 |  | 298
Research and development | 1256 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -106 |  | 0 |  | 1150
Acquisition-related contingent consideration | 16 |  | -16 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 50 |  | -50 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 16 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -16 |  | 0 |  | 0 |  | 0
Total operating expenses | 2498 |  | -66 |  | 0 |  | 0 |  | 0 |  | 0 |  | -16 |  | -166 |  | 0 |  | 2250
Operating income (loss) | -185 |  | 94 |  | 0 |  | 339 |  | 0 |  | 0 |  | 16 |  | 167 |  | 0 |  | 431
 | 2498 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Gain on strategic investments | -185 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0.92
Interest and other income (expense), net | -9 |  | 0 |  | 9 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Income (loss) before provision for (benefit from) income taxes | -194 |  | 94 |  | 9 |  | 339 |  | 0 |  | 0 |  | 16 |  | 167 |  | 0 |  | 431
Provision for (benefit from) income taxes | -21 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 141 |  | 120
Net income (loss) | -173 |  | 94 |  | 9 |  | 339 |  | 0 |  | 0 |  | 16 |  | 167 |  | -141 |  | 311
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Diluted | -0.54 |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.92
Spreadsheet: 485525d1476929365-computing-a-range-of-cells-from-another-different-workbook-link-data-question-homework
Sheet: Sheet1

 | Results | Date Conducted |  | Date | Number of Alarms | Passed | Failed | Percentage/Pass | Total Alarms | Total Days
 | Passed | 2016-10-10 00:00:00
 | Failed | 2016-10-10 00:00:00
 | Passed | 2016-10-12 00:00:00
 | Passed | 2016-10-12 00:00:00
 | Failed | 2016-10-15 00:00:00
 | Failed | 2016-10-15 00:00:00
 | Failed | 2016-10-15 00:00:00
 | Failed | 2016-10-20 00:00:00
 | Failed | 2016-10-20 00:00:00
 | Passed | 2016-10-20 00:00:00
 | Passed | 2016-10-20 00:00:00
 | Passed | 2016-10-20 00:00:00
 | Passed | 2016-10-20 00:00:00
Spreadsheet: 436a39d2-0dd1-4a72-983f-42fb0d2ac2af
Sheet: Dr. Garcia, DDS  

Dr. [NAME], DDS
362 Third Street Suite #2
Laguna Beach, 92651
Main Phone Line: (949) 809-5700
Main Fax: (949) 809-5779
Name and Title | Role | Contact Email | Contact Phone Number | Fax Number
Dr. [NAME], DDS | Dentist | N/A | (949) 809-5700 | N/A
Areli | Office Manager | N/A | (949) 809-5700 | N/A
Spreadsheet: 289109d1389394169-how-do-i-sum-up-all-vallues-in-colum-b-if-column-a-equals-to-xyz-book1
Sheet: Sheet1

2014-05-25 00:00:00 | interest paid |  | 1
2014-05-26 00:00:00 |  |  | 2
2014-05-27 00:00:00 | interest paid |  | 3
2014-05-28 00:00:00 | interest paid |  | 4
2014-05-29 00:00:00 |  |  | 5
2014-05-30 00:00:00 | interest paid |  | 6
2014-05-31 00:00:00 | interest paid |  | 7
2014-06-01 00:00:00 |  |  | 8
2014-06-02 00:00:00 | interest paid |  | 9
2014-06-03 00:00:00 | interest paid |  | 10
2014-06-04 00:00:00 |  |  | 11
2014-06-05 00:00:00 | interest paid |  | 12
2014-07-01 00:00:00 | interest paid |  | 13
2014-07-02 00:00:00 |  |  | 14
2014-07-03 00:00:00 | interest paid |  | 15
Spreadsheet: 4f2d0050-94cb-4f02-937d-8a28a3f54aac
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | Unnamed: 38 | Unnamed: 39 | Unnamed: 40
HOJA DE INSCRIPCIÓN
CLUBES Y EQUIPOS LIGAS NACIONALES
TEMPORADA 2010/2011
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
 | [NAME]: |  |  |  |  | 0 |  |  |  |  |  |  | [NAME]: |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | RENUNCIA:
SÓLO HAY QUE PONER EL NÚMERO DE EQUIPO. Este número se obtiene en el listado de equipos
El resto de datos si disponemos de ellos saldrán automaticos. [NAME] lo que sea necesario.
 | DATOS EQUIPO
 | NOMBRE OFICIAL:
 | NOMBRE COMERCIAL:
 | NOMBRE CORTO:
 | DOMICILIO:
 | POBLACIÓN: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TELÉFONO: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CODIGO POSTAL:
 | PROVINCIA: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FAX:
 | LOCAL DE JUEGO
 | NOMBRE:
 | DOMICILIO:
 | POBLACIÓN: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TELÉFONO: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CODIGO POSTAL:
 | PROVINCIA: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FAX:
 | RESPONSABLE
 | NOMBRE: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TELÉFONO MÓVIL:
 | EMAIL:
 | MATERIAL
 | MESA |  |  | MARCA: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MODELO: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COLOR:
 | PELOTA |  |  |  | MARCA: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COLOR:
 | CAMISETA |  |  |  |  | 1ª EQUIPACION COLOR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2ª EQ. COLOR:
 | COMPETICIÓN
 | DÍA PREFERIDO: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HORARIO SÁBADO: |  |  |  |  |  |  |  |  |  |  |  |  | HORARIO DOMINGO:
 | DESPLAZAMIENTO DOBLE:
 | OBSERVACIONES:
 | ENVIADO POR:
Spreadsheet: 1ace5fa8-c811-4c4d-a633-83631f3cbf85
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. MATH) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom Survey = Face  OR  Online Survey = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. MATH, CAM) | PSY | MATH | MATH | MATH | MATH | MATH | MATH
Discipline codes: MATH = 2700                                      (4 digits) | 4200 | 2700 | 2700 | 2700 | 2700 | 2700 | 2700
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
Local Code for CAM 2305, MATH 1302, 1303, 1324, 1325, 1332, 1561, 2305, 2331, 2332, & 2513 = 0600   or  Honors = 0601 Local Code for Math 1351, CAM 1351 = 0200 Local Code for Math 130C(9)  = 1250
Long (L)  Forms | L | L | L | L | L | L | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: daren_farmer__5480__BKRQST74
Sheet: Sheet1

To: | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
From: | Regina Perkins |  |  |  | Department: | Sitara Development
Subject: | New Portfolio Request |  |  |  | Date:
 | This is to notify you that a new [NAME] needs to be set up:
 | COUNTERPARTY | Associated Entity |  | GLOBAL COMMON CODES |  |  | Reporting -Subledger
 | COUNTERPARTY LEGAL NM | COUNTERPARTY LEGAL NM | MSA CO NO | DATA CD | DATA DESC |  | MTM | Prud | Realized
Note 1 | ENA - FT Cleburne | Enron North America Corp. (Duns #1305) | 413 | FTCL
 | Should be included with same Desk Security as Texas Desk
 | Any questions, please contact me
 | Regina Perkins (39222)
Spreadsheet: 586530d1534433682-formula-working-in-reverse-oii-ctr_opg-cvx-angola-flexible-pipeline-2
Sheet: Deliverables 

[NAME]
Section | Title | Work Breakdown | hrs
1.1 | Flowline Analysis | Lay Analysis
 |  | Overboarding Analysis
 |  | Pull-in Analysis
 |  | Basis of Analysis
 |  | Results report
1.2 | Pipe Manufacturer interface | Meetings
 |  | Connector interface |  |  |  |  |  | [NAME]:
 |  | Packing & marking Plan
 |  | Reel loadout |  |  |  |  |  | Detailed Engineering
 |  | [NAME] |  |  |  |  |  | Interface with pipe manufacturer- Flanges, [NAME] design???? Meetings
 |  | Reel transportation DL |  |  |  |  |  | Product (reel) load out from supplier’s yard and transportation to contractor’s in-country staging area.-vessel loadout, layouts, seafastening
1.3 | Installation Package | [NAME]
 |  | Seafastening |  |  |  |  |  | Installation pipe lay engineering -Orcaflex: lay, pull- in, overboarding
 |  | Seafastening report (MWS) |  |  |  |  |  | Procedures
 |  | Rigging
 |  | Lifting Plans |  |  |  |  |  | Procurement of Installation Aides
 |  | Route Layout |  |  |  |  |  | Procurement / Sourcing of pipelay spread
 |  | pull-in drawings |  |  |  |  |  | Project Execution-offshore time??
 |  | Overboarding drawings |  |  |  |  |  | Mobilization and installation of the pipelay spread-shipping layouts, seafastening, sourcing, spread analysis, etc
 |  | lay charts, pull in charts |  |  |  |  |  | Mobilization and installation of TCP and associated installation aids
 |  | Equipment sourcing |  |  |  |  |  | Mobilization of vessel and execution of pipelay scope-offshore/mobe time??
1.4 | Procedures | Procedures workpacks |  |  |  |  |  | Hook-up and pre-commissioning of installed pipe
1.5 | installation Aids | Equipment modifications, connection aids, hangoff frames, etc |  |  |  |  |  | Commissioning scope and start up assistance.
1.6 | Equipment Mobe | deck layouts |  |  |  |  |  | Demobilization of vessel, pipelay spread and personnel
 |  | seafastening |  |  |  |  |  | Provision of as-built reports
 |  | load out plans |  |  |  |  |  | Closeout
 |  | return shipping
 |  | Warranty surveyor packets
1.7 | installation vessel mobe | mobe time estimate
1.8 | offhsore time | offshore time estimate
Spreadsheet: 820734d1678274504-show-a-value-if-between-multiple-date-ranges-value-between-multiple-data-ranges
Sheet: Sheet1

Resource Name | Start Date 1 | Finish Date 1 | Start Date 2 | Finish Date 2 | Start Date 3 | Finish Date 3 | 2023-02-27 00:00:00 | 2023-03-06 00:00:00 | 2023-03-13 00:00:00 | 2023-03-20 00:00:00 | 2023-03-27 00:00:00 | 2023-04-03 00:00:00 | 2023-04-10 00:00:00 | 2023-04-17 00:00:00 | 2023-04-24 00:00:00 | 2023-05-01 00:00:00 | 2023-05-08 00:00:00 | 2023-05-15 00:00:00 | 2023-05-22 00:00:00 | 2023-05-29 00:00:00 | 2023-06-05 00:00:00 | 2023-06-12 00:00:00 | 2023-06-19 00:00:00 | 2023-06-26 00:00:00 | 2023-07-03 00:00:00 | 2023-07-10 00:00:00 | 2023-07-17 00:00:00 | 2023-07-24 00:00:00 | 2023-07-31 00:00:00 | 2023-08-07 00:00:00 | 2023-08-14 00:00:00 | 2023-08-21 00:00:00 | 2023-08-28 00:00:00 | 2023-09-04 00:00:00 | 2023-09-11 00:00:00 | 2023-09-18 00:00:00 | 2023-09-25 00:00:00 | 2023-10-02 00:00:00 | 2023-10-09 00:00:00 | 2023-10-16 00:00:00 | 2023-10-23 00:00:00 | 2023-10-30 00:00:00 | 2023-11-06 00:00:00 | 2023-11-13 00:00:00 | 2023-11-20 00:00:00 | 2023-11-27 00:00:00 | 2023-12-04 00:00:00 | 2023-12-11 00:00:00 | 2023-12-18 00:00:00 | 2023-12-25 00:00:00 | 2024-01-01 00:00:00 | 2024-01-08 00:00:00 | 2024-01-15 00:00:00 | 2024-01-22 00:00:00 | 2024-01-29 00:00:00 | 2024-02-05 00:00:00 | 2024-02-12 00:00:00 | 2024-02-19 00:00:00 | 2024-02-26 00:00:00 | 2024-03-04 00:00:00 | 2024-03-11 00:00:00
Resource 1 | 2023-03-01 00:00:00 | 2023-05-01 00:00:00 | 2023-07-01 00:00:00 | 2023-10-01 00:00:00
Resource 2 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00
Resource 3 | 2023-03-01 00:00:00 | 2023-05-15 00:00:00 | 2023-08-01 00:00:00 | 2023-11-01 00:00:00
Resource 4 | 2023-03-01 00:00:00 | 2023-05-01 00:00:00 | 2023-08-01 00:00:00 | 2023-11-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00
Spreadsheet: 873344d1719851062-how-to-extract-the-number-of-working-hours-for-all-employees-and-extract-the-start-and-end-time
Sheet: ورقة1

Name | Date | Time
[NAME] | 01/06/2024 | 19:02:34 |  |  |  | Name | 01/06/2024 |  |  | 30/06/2024
Name1 | 01/06/2024 | 15:56:10 |  |  |  |  | Start Time | End Time | Total Work | Start Time | End Time | Total Work
Name1 | 01/06/2024 | 14:55:58 |  |  |  | Name1
Name1 | 01/06/2024 | 11:46:18 |  |  |  | [NAME]
[NAME] | 01/06/2024 | 11:07:58
Name1 | 01/06/2024 | 09:04:48
[NAME] | 30/06/2024 | 18:48:37
Name1 | 30/06/2024 | 22:20:22
Name1 | 30/06/2024 | 19:14:58
Name1 | 30/06/2024 | 19:12:38
[NAME] | 30/06/2024 | 10:45:21
Name1 | 30/06/2024 | 10:09:28
Spreadsheet: 852184d1702290721-grid-data-reference-formula-sample3
Sheet: GridData

 |  |  | Projected POT - Early Speed V Back Odds
 |  |  | Early Speed
 |  | Back Odds | 17.5 | 17.4 | 17.3 | 17.2 | 17.1 | 17.0 | 16.9 | 16.8 | 16.7 | 16.6
 | Back Odds | >20
 |  | <=20
 |  | <=18
 |  | <=16
 |  | <=14
 |  | <=12
 |  | <=10
 |  | <=9
 |  | <=8
Spreadsheet: 784071d1655403156-data-extracting-sorting-and-organizing-book2
Sheet: Sheet1

BEGIN:VCARD | N:Smoe;Joe;Dave;Mr.;Sr. | FN:Mr. [NAME], Sr. | TEL;CELL:+[PHONE] | TEL;WORK;FAX:(201) 555-2222 | TEL;TYPE=HOME;TYPE=FAX:555 3333 | TEL;TYPE=PAGER:[PHONE] | END:VCARD
BEGIN:VCARD | N:Doe;Jane;Marie;; | FN:Ms. [NAME] Doe\, | NICKNAME:MayJo | TEL;TYPE=CELL:+[PHONE] | TEL;TYPE=HOME:(201) 555 6666 | TEL;TYPE=WORK:[PHONE] | TEL;TYPE=VOICE:5558888 | TEL;TYPE=WORK;TYPE=FAX:555-9999 | TEL;TYPE=HOME;TYPE=FAX:[PHONE] | TEL;TYPE=PAGER:+[PHONE] | TEL;TYPE=Custom:666 1111 | TEL;TYPE=PREF:6662222 | TEL;TYPE=AnotherCustom:[PHONE] | TEL;TYPE=CELL:[PHONE] | EMAIL;TYPE=WORK:[EMAIL] | ORG:Microsoft | TITLE:CEO | END:VCARD
Spreadsheet: 2ac3642d-c5d4-4567-9c69-47dc5825bfe2
Sheet: Sheet1

Whatcom Community College
[NAME]
THIS IS NOT A PURCHASE ORDER. FORWARD FORM TO THE BUSINESS OFFICE
Initiated by:
SUGGESTED VENDOR |  |  |  |  | DATE NEEDED | DATE | Deliver items to attention of:
CATALOG # |  | [NAME] |  |  |  | QUANTITY | UNIT | UNIT PRICE | AMOUNT
 |  | To be ordered by Business Office
 |  | Fax # ______________________
 |  | WebSite ___________________
 |  | Ordered by initiator (invoice to follow)
 |  | Reimburse to initiator (receipt attached)
**** VERIFICATION OF RECEIPT OF GOODS OR SERVICES **** |  |  |  |  |  |  |  | SUB-TOTAL
Each invoice must be signed and dated as acknowledgement |  |  |  |  |  |  |  |  | 0
that all items as invoiced have been received. |  |  |  |  |  |  |  | SHIPPING
 |  |  |  |  |  |  |  | *TAX-8.7%
To be completed by the budget manager of the department to be charged
 |  |  |  |  |  |  |  | TOTAL
ACCOUNT CODE |  |  |  |  |  |  |  | * TAX RATES
 |  |  |  |  |  |  |  | Wash. State - 8.7%
EXPENDITURE APPROVED |  |  |  |  |  |  |  | Out of State - 8.5%
 |  | Budget Manager Signature |  |  |  | Print Name
SUPPLIES, MATERIALS, OR EQUIPMENT NOT TO BE PROVIDED WITHOUT PURCHASE ORDER NUMBER
Approved for Payment |  |  |  |  | Voucher # |  |  | Check #
Spreadsheet: 95120d1294790992-sum-value-based-on-2-ranges-banking
Sheet: Savings

Date | Number | Description | Debit | Credit | Balance
2011-01-01 00:00:00 |  | [NAME]
Spreadsheet: 713851d1610977999-date-range-has-date-in-or-not-several-ranges-and-not-unique-id-datestamp_range
Sheet: RangeResult

User ID | Sdate | Edate | Is there a Date Stamp in this range for this user? Yes/No | Expected result
1125 | 2020-11-02 00:00:00 | 2020-11-02 00:00:00 |  | Yes
1125 | 2020-11-05 00:00:00 | 2020-11-05 00:00:00 |  | No
1125 | 2020-11-07 00:00:00 | 2020-11-07 00:00:00 |  | No
1125 | 2020-11-13 00:00:00 | 2020-11-14 00:00:00 |  | No
1125 | 2020-11-17 00:00:00 | 2020-11-18 00:00:00 |  | No
1266 | 2020-10-30 00:00:00 | 2020-10-31 00:00:00 |  | No
1266 | 2020-11-03 00:00:00 | 2020-11-07 00:00:00 |  | Yes
1266 | 2020-11-10 00:00:00 | 2020-11-10 00:00:00 |  | Yes
1266 | 2020-11-12 00:00:00 | 2020-11-13 00:00:00 |  | No
1266 | 2020-11-17 00:00:00 | 2020-11-17 00:00:00 |  | Yes
1266 | 2020-11-19 00:00:00 | 2020-11-20 00:00:00 |  | No
1327 | 2020-10-30 00:00:00 | 2020-10-30 00:00:00 |  | No
1327 | 2020-11-02 00:00:00 | 2020-11-06 00:00:00 |  | Yes
1327 | 2020-11-10 00:00:00 | 2020-11-10 00:00:00 |  | No
1327 | 2020-11-12 00:00:00 | 2020-11-12 00:00:00 |  | No
1327 | 2020-11-17 00:00:00 | 2020-11-17 00:00:00 |  | No
1327 | 2020-11-19 00:00:00 | 2020-11-19 00:00:00 |  | No
1327 | 2020-11-26 00:00:00 | 2020-11-27 00:00:00 |  | No
Spreadsheet: 867904d1714659959-look-across-4-tables-return-top-of-each-table-unless-they-are-a-repeat-winner-book1
Sheet: 1

 |  |  |  |  |  |  |  |  | 3rd  DEF
 |  |  |  |  |  |  |  |  |  | P | W | L | D | F | A | [NAME] | Pts
 |  |  | [NAME] |  |  |  | DEF |  | [NAME] | 3 | 1 | 1 | 1 | 5 | 7 | -2 | 4
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 1 | 2 | 0 | 5 | 6 | -1 | 3
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 1 | 2 | 0 | 5 | 7 | -2 | 3
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 0 | 3 | 0 | 0 | 8 | -8 | 0
 |  |  |  |  |  |  |  |  | 3rd  ADEF
 |  |  | [NAME] |  |  |  | ADEF |  |  | P | W | L | D | F | A | [NAME] | Pts
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 1 | 1 | 1 | 5 | 7 | -2 | 4
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 1 | 2 | 0 | 5 | 6 | -1 | 3
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 1 | 2 | 0 | 6 | 8 | -2 | 3
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 1 | 2 | 0 | 5 | 7 | -2 | 3
 |  |  |  |  |  |  |  |  | 3rd  ABC
 |  |  | [NAME] |  |  |  | ABC |  |  | P | W | L | D | F | A | [NAME] | Pts
 |  |  |  |  |  | Should be [NAME] |  |  | [NAME] | 3 | 1 | 2 | 0 | 6 | 7 | -1 | 3
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 1 | 2 | 0 | 6 | 8 | -2 | 3
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 1 | 2 | 0 | 5 | 7 | -2 | 3
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 0 | 3 | 0 | 0 | 0 | -8 | 0
 |  |  |  |  |  |  |  |  | 3rd  ABCD
 |  |  |  |  |  |  |  |  |  | P | W | L | D | F | A | [NAME] | Pts
 |  |  | [NAME] |  |  |  | ABCD |  | [NAME] | 3 | 1 | 2 | 0 | 6 | 7 | -1 | 3
 |  |  |  |  |  | Should be [NAME], but if [NAME] had come 2nd in ABC it'd be John |  |  | [NAME] | 3 | 1 | 2 | 0 | 6 | 8 | -2 | 3
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 1 | 2 | 0 | 5 | 7 | -2 | 3
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 0 | 0 | 3 | 0 | 8 | -8 | 0
Spreadsheet: 356662d1415181655-column-sort-without-chaning-formulae-jc-booking-september-2014
Sheet: 22nd

Date |  |  |  |  |  |  |  |  |  |  |  | DAY SHEET
Job No | Due | Contact | 1 | Car | Imax | 13 Pax | 20 Pax | 24 Pax | 29 Pax | 44 Pax | FROM | TO | Retn | Price  $ | Dep  $ | Bal | Mode | Pax | Trailer | Con | Bus | Des | Driver
 | 0815 | Adelaide Secondary School of English | [NAME] |  |  | 1 |  |  |  |  | Adelaide Secondary School of English | Tyndale Christian School Fern Grove Blvd Sals East | y | 77 | 0 |  | acct | 7 |  |  |  |  | sully
 | 1400 | Adelaide Secondary School of English | [NAME] 83403733 Fax Order 5432 |  |  | 1 |  |  |  |  | Tyndale Christian School Fern Grove Blvd Sals East | Adelaide Secondary School of English | n | 77 | 0 |  | acct | 7 |  |  |  |  | sully
 | 1115 | Danni Vadoulis | [PHONE] |  |  | 1 |  |  |  |  | Northern Sound System 73 [NAME] way [NAME] | [NAME] | y | 110 | 110 |  | C/card | 12 |  |  |  |  | dean
 | 1415 | Danni Vadoulis | [PHONE] |  |  | 1 |  |  |  |  | [NAME] | Northern Sound System 73 [NAME] way [NAME] | n | 110 | 110 |  | C/card | 12 |  |  |  |  | [NAME]
 | 0830 | [NAME] E2KF495373 | GTA |  | 1 |  |  |  |  |  | VA 1384 | Grand Chancellor Hindley | n | 55.25 | 0 |  | acct | 2 |  |  |  |  | [NAME]
 | 0930 | M/M Brown 413800 | Anzcro |  | 1 |  |  |  |  |  | [NAME] | Airport | n | 37.5 | 0 |  | acct | 2 |  |  |  |  | [NAME]
 | 0730 | [NAME] |  |  |  |  |  |  |  |  | 24 seat hire 4 days | $300 day + $40 per day Trailer + $100 Delivery | n | 1460 | 0 |  | acct | 24 |  |  |  |  | Cancelled
 | 1100 | Port Power |  |  |  |  |  |  |  | 1 | Alberton | [NAME] | y | 646 | 0 |  | acct | 57 |  |  |  |  | Buses R US
 | 1700 | Port Power |  |  |  |  |  |  |  | 1 | [NAME] | Alberton | n | 646 | 0 | 646 | acct | 57 |  |  |  |  | Buses R US
 |  | Port Power |  |  |  |  |  |  |  |  | Cleaning Fee |  |  | 180 | 0 |  | acct |  |  |  |  |  | Cleaning Fee
 | 0745 | [NAME] | [PHONE] |  |  | 1 |  |  |  |  | Torrens Rowing Club City | Loreto College | n | 68 | 0 |  | acct | 12 |  |  |  |  | [NAME]
9575 | 1115 | [NAME] | [PHONE] |  |  |  |  | 1 |  |  | Marryatville High School | Ice Arena | y | 99 | 0 |  | acct | 24 |  |  |  |  | [NAME]
 | 1320 | [NAME] | [PHONE] |  |  |  |  | 1 |  |  | Ice Arena | Marryatville High School | n | 99 | 0 |  | acct | 24 |  |  |  |  | [NAME]
 | 0815 | Underdale High | Demi [PHONE] |  |  |  | 1 |  |  |  | Underdale High School | [NAME] | y | 120 | 0 |  | acct | 21 |  |  |  |  | [NAME]
 | 1430 | Underdale High | Demi [PHONE] |  |  |  | 1 |  |  |  | [NAME] of [NAME] | Underdale High | n | 99 | 0 |  | acct | 21 |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Air Asia x - 0800 Hotel
 |  |  |  |  |  |  |  |  |  |  | Air Asia x - 0900 Apt
 |  |  |  |  |  |  |  |  |  |  | Malaysia 0715  -Apt
 |  |  |  |  |  |  |  |  |  |  | Malaysia 1230 - Hotel
TOTAL
Spreadsheet: 802621d1666946363-if-and-value-exists-or-empty-or-do-something-else-combined-if-and-or-sample
Sheet: Sheet1

Task Description | End Date | Status | % | Formula Area | Target
Task 1 |  | Done | 1 | =[NAME]","")
Task 2 |  |  |  | =IF(C3="Done","",IF(OR(D3>100%,B3<TODAY()),"Overdue"))
Task 3 |  | Done | 1 | Insert Date | < If [NAME] is not Done, then [NAME]
Task 4 | 2022-10-27 00:00:00 |  | 1.01 | Overdue | < If [NAME] is not Done, then [NAME]