tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 685789d1594199306-2-fold-problem-data-issue-and-multiple-countif-with-exclusions-sales-funnel-help
Sheet: Raw Field Guide Log

 | [NAME] | Calc 1 | ohr | Affected user | Event context | Event name
 |  |  | 3/07/20, 07:30 | X | Course: Tabbed Subsection | Course module viewed
 |  |  | 3/07/20, 07:29 | X | Course: Tabbed Subsection | Course viewed
 |  |  | 3/07/20, 07:28 | X | System | User has logged in
 |  |  | 3/07/20, 05:14 | X | Category: Working Courses | Category viewed
 |  |  | 3/07/20, 02:44 | X | Front page | Course module viewed
 |  |  | 3/07/20, 00:00 | Y | Other | User deleted
 |  |  | 3/07/20, 00:00 | Y | Course: Phase 2 | Respond | User unenrolled from course
 |  |  | 3/07/20, 00:00 | Y | Course: Phase 2 | Respond | Role unassigned
 |  |  | 3/07/20, 00:00 | Y | Course: Field Guide | User unenrolled from course
 |  |  | 3/07/20, 00:00 | Y | Course: Field Guide | Course module viewed
 |  |  | 3/07/20, 00:00 | Y | Course: Field Guide | Role unassigned
 |  |  | 3/07/20, 00:00 | Y | Course: Phase 2 | Respond | Course module viewed
 |  |  | 3/07/20, 00:00 | Y | Course: Phase 1 | Re-Act | User unenrolled from course
 |  |  | 3/07/20, 00:00 | Y | Course: Phase 2 | Respond | Role unassigned
 |  |  | 3/07/20, 00:00 | Y | Course: Phase 2 | Respond | User unenrolment updated
 |  |  | 3/07/20, 00:00 | Y | Course: Phase 1 | Re-Act | Role unassigned
 |  |  | 1/07/20, 13:16 | Y | Course: Phase 2 | Respond | User unenrolment updated
 |  |  | 1/07/20, 13:16 | Y | Course: Phase 1 | Re-Act | Course module viewed
 |  |  | 1/07/20, 13:16 | Z | Course: Field Guide | User unenrolled from course
 |  |  | 1/07/20, 13:16 | Z | Course: Field Guide | Role unassigned
 |  |  | 1/07/20, 11:00 | Z | Course: Field Guide | Item deleted
 |  |  | 30/06/20, 15:36 | Z | Guide: Content: What SMEs can do to repair their balance sheet | Chapter viewed
 |  |  | 30/06/20, 15:36 | Z | Guide: Content: What SMEs can do to repair their balance sheet | Course module viewed
 |  |  | 30/06/20, 15:35 | Z | Course: Field Guide | Course viewed
 |  |  | 30/06/20, 15:35 | Z | Course: Field Guide | Course viewed
 |  |  | 30/06/20, 15:35 | Z | Guide: Content: Forecast for and manage investors | Chapter viewed
 |  |  | 30/06/20, 15:24 | Z | Guide: Content: Forecast for and manage investors | Chapter viewed
 |  |  | 30/06/20, 15:23 | Z | Guide: Content: Forecast for and manage investors | Chapter viewed
 |  |  | 30/06/20, 15:23 | Z | Guide: Content: Forecast for and manage investors | Course module viewed
 |  |  | 30/06/20, 15:23 | A | Guide: Content: Forecast for and manage investors | Chapter viewed
 |  |  | 30/06/20, 15:23 | A | Guide: Content: Forecast for and manage investors | Course module viewed
 |  |  | 30/06/20, 15:22 | A | Course: Field Guide | Course viewed
 |  |  | 30/06/20, 15:22 | A | Course: Field Guide | Course viewed
 |  |  | 30/06/20, 15:20 | A | Course: Field Guide | Course viewed
Spreadsheet: 438189f3-29aa-4bc3-961f-8e6cdf2aa3b6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-10-07 09:33:04.870000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.375 | 101.453 | 101.328 | 101.203 | 100.828 |  | and are added to price quote
4.25 | 100.734 | 100.609 | 100.484 | 100.109
4.125 | 100.319 | 100.194 | 100.069 | 99.694 |  | Note: | Refer To Price [NAME]
4 | 99.872 | 99.747 | 99.622 | 99.247 |  |  | For all Price Adjs
3.875 | 99.295 | 99.17 | 99.045 | 98.42
3.75 | 98.312 | 98.187 | 98.062 | 97.437
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.402 | 101.277 | 101.152 | 100.777
3.75 | 100.902 | 100.777 | 100.652 | 100.277
3.625 | 100.456 | 100.331 | 100.206 | 99.831
3.5 | 100.125 | 100 | 99.875 | 99.5
3.375 | 99.715 | 99.59 | 99.465 | 98.84
3.25 | 99.142 | 99.017 | 98.892 | 98.267
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-10-21 09:33:04.870000
30 DAY | 2011-11-05 09:33:04.870000
45 DAY | 2011-11-20 09:33:04.870000
60 DAY | 2011-12-05 09:33:04.870000
90 DAY | 2012-01-04 09:33:04.870000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 99525d1298137684-sumproduct-division-returning-div-0-765135_flizzn
Sheet: Sheet1

 |  |  | PM | SP | LE
 |  | - | 8 | 1 | 2
 |  | -
 |  | -
 | R | I | PM | SP | LE
 | 0.28 |  | 1 | 2 | 2
 | 0.22 |  |  | 1 | 1
 | 0.2
 | 0.2
 | 0.2 |  | 2 | 1 | 1
 | 0.44 |  | 3 | 3 | 3
 | 0.1
 | 0.2
 | 0.2
 | 0.4 |  | 2 | 1 | 1
 | 0.09
 | 0.22 |  |  | 2 | 2
 | 0.21 |  | 1 | 3 | 3
 | 0.12
 | 0.03
 | 0.41 |  | 1 | 3 | 3
 | 0.33
 | 0.27
 | 0.2 |  | 2 | 2 | 2
 | 0.2
 | 0.2 |  | 3 | 3 | 3
 | 0.4 |  | 2 | 2 | 2
 | 0.1 |  | 4 | 4 | 4
 | 0.2
 | 0.17
 | 0.2
 | 0.09
 | 0.02
 | 0.01 |  | 4 | 4 | 4
 | 0.01
 | 0.01 |  | 2 | 3 | 3
 | 0.2 |  | 3 | 3 | 3
Spreadsheet: 846074d1697371396-power-query-how-to-extract-the-status-for-each-workbook-test-book-2
Sheet: Sheet1

 | Overall Status: | Ok
 | [NAME] | Range | Description | Status
 | [NAME] | [NAME] | [NAME] | Ok
 | [NAME] | [NAME] | [NAME] | Ok
 | [NAME] | [NAME] | [NAME] | Ok
 | [NAME] | [NAME] | [NAME] | Ok
 | [NAME] | [NAME] | [NAME] | Ok
Spreadsheet: 717522d1612710946-create-a-bar-chart-by-name-manager-and-scorll-bar-hhh
Sheet: Sheet1

 | A | B | C | sum |  | 2
Book | 1 | 2 | 3 |  |  | link to scroll
Car | 4 | 5 | 6
sum
 |  |  |  |  |  |  | Please without vb& helper columns
 |  |  |  |  |  |  | Need to creat with Name Manager
Spreadsheet: 121624d1316200264-count-unique-occurrences-in-one-column-based-on-criteria-another-column-sample-worksheet
Sheet: Sheet1

No. | Join Date | Join Month | New or Existing (N/E) | First Name | Last Name | Sex | Age | ID | March-11 | April-11 | May-11 | June-11 | Jul-11 | Total
 | 2011-03-01 00:00:00 |  | E | [NAME] | Doe | F | 45 | 06-0001 | 6 | 10 | 10 | 5
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 37 | 06-0023 | 15
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 22 | 06-0001 | 15 |  |  |  |  |  |  |  | 2011-04-01 00:00:00
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 27 | 06-0023 | 15
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 51 | 06-0003 | 20
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 33 | 06-0004 | 15
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | M | 17 | 06-0005 | 10
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 27 | 06-0023 | 15 | 5
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 26 | 06-0001 | 20
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 15 | 06-0023 | 15
 | 2011-03-11 00:00:00 |  | N | [NAME] | Doe | F | 36 | 06-0003 | 14 |  |  | 30
 | 2011-04-01 00:00:00 |  | E | [NAME] | Doe | F | 24 | 06-0004 |  | 80
 | 2011-04-01 00:00:00 |  | E | [NAME] | Doe | M | 17 | 06-0005 |  | 80
 | 2011-04-01 00:00:00 |  | E | [NAME] | Doe | F | 26 | 06-0023 |  | 10
 | 2011-04-01 00:00:00 |  | E | [NAME] | Doe | F | 16 | 06-0007 |  | 20
 | 2011-04-01 00:00:00 |  | E | [NAME] | Doe | F | 53 | 06-0010 |  | 2
 | 2011-04-01 00:00:00 |  | E | [NAME] | Doe | M | 27 | 06-0010 |  | 50
2011-01-01 00:00:00 | 25
2011-02-01 00:00:00 | 25 |  | 2011-01-01 00:00:00
2011-03-01 00:00:00 | 50 |  |  |  |  |  |  |  | <==Count unique occurences of "ID" where Join Month = 3
2011-04-01 00:00:00 | 25
2011-05-01 00:00:00 | 25
2011-06-01 00:00:00 | 25
2011-07-01 00:00:00 | 25
Spreadsheet: 584240d1533051016-excel-filling-one-table-with-data-from-another-table-d-ploiements-clients
Sheet: Data - X

Nom du client | [NAME] | Client Existant | Commercial | Revendeur | Adresse | Ville | Fournisseur | Type d'accès | Débit | NB de paires | Zone Tarifaire | [NAME] | [NAME] | Type Modem | [NAME] | Ariane | IP Publique dédiée | Nb Ip publiques | Adresse [NAME] | Facturation Equipements | Audit | Date Audit | Resultat Audit | Facturation Audit | Date commande | Référence Fournisseur | Date [NAME] | Numéro de suivi transporteur | [NAME] | Coût port | Date [NAME] | RDV Installation | Date convenue | Date effective  [NAME] | Date [NAME] | [NAME]
Client 1 | En cours | NON | ID | ADER | 9 avenue de l Industrie | [NAME] | Orange | SDSL | 4Mbts | 2 | [NAME] |  | En preparation |  |  |  |  |  |  | A faire | OUI | 2018-07-24 00:00:00 | 2018-07-25 00:00:00 | A faire | 2018-07-26 00:00:00 | 0043UJA9 | 2018-07-10 00:00:00 |  |  |  |  |  |  |  |  | A FAIRE
Client 2 | En cours | NON | TR | Ouest Consulting | ZA de l Espérance | Quessoy | Orange | Fibre | 10Mbts |  | [NAME] |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-18 00:00:00 | 0043SZN3 | 2018-05-05 00:00:00 |  |  |  |  |  | 2018-09-12 00:00:00 |  |  | A FAIRE
Client 3 | En cours | NON | TR | Ouest Consulting | ZA de l Espérance | Quessoy | Orange | SDSL | 4Mbts |  | [NAME] |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-18 00:00:00 | 0043TEK1 | 2010-08-01 00:00:00 |  |  |  |  |  | 2018-09-12 00:00:00 |  |  | A FAIRE
Client 4 | En cours | NON | TR | Ouest Consulting | ZA de l Espérance | Quessoy | Orange | ADSL | 10Mbts |  | [NAME] |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-18 00:00:00 | 0043TFB6 | 2018-09-04 00:00:00 |  |  |  |  |  | 2018-09-12 00:00:00 |  |  | A FAIRE
Client 5 | En cours | NON | TR | Ouest Consulting | ZA de l Espérance | Quessoy | Orange | Fibre | 4Mbts |  | [NAME] |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-18 00:00:00 | 0043TCP3 | 2018-07-06 00:00:00 |  |  |  |  |  | 2018-09-12 00:00:00 |  |  | A FAIRE
Client 6 | En cours | NON | TR | UnifyTelecom | 20 rue ANDRE DESSAUX | Fleury les Aubrais | Orange | Fibre | 100Mbts |  |  | [NAME] | Prêt |  | Partielle | fcecda40fddf |  |  |  | Inclus | NON |  |  |  | 2018-04-11 00:00:00 | 0043BZB2 | 2018-07-24 00:00:00 | 1ZW52F356894961686 |  | 14.22 | 2018-07-25 00:00:00 |  | 23 et 27/07/2018 |  |  | A FAIRE
Client 7 | En cours | NON | AVH |  | 9Bis Avenue de Iena | Paris | Orange | SDSL | 4Mbts | 1 | [NAME] |  |  |  |  |  |  |  |  | Inclus | OUI | 2018-07-24 00:00:00 | 2018-07-25 00:00:00 | Inclus | 2018-07-26 00:00:00 | 0043UGL3 |  |  |  |  |  |  |  |  |  | A FAIRE
Client 8 | En cours | NON | AVH |  | 9Bis Avenue de Iena | Paris | Orange | SDSL | 4Mbts | 1 | [NAME] |  |  |  |  |  |  |  |  | Inclus | OUI | 2018-07-24 00:00:00 | 2018-07-25 00:00:00 | Inclus | 2018-07-25 00:00:00 | 0043UKM4
Client 9 | En cours | NON | ID | Hexacom | 999 Chemin de Sauvecanne | Bouc Bel Air | Orange | SDSL | 4Mbts | 4 |  |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-23 00:00:00 | 0043EEL8 F59070230718 |  |  |  |  | 2018-08-06 00:00:00 |  | 2018-08-06 00:00:00
Spreadsheet: michelle_lokay__26805__imbalsumm
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | 154 | 30000 | 88235 | 59991
2 | 263 | 30000 | 79721 | 53107
3 | 29620 |  | 599 | 30000
4 | 36064 |  | 0 | 35395
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2000-07-31 00:00:00 |  |  |  | 32559
 | 2000-08-04 00:00:00
Spreadsheet: 79956d1280219899-delete-duplicates-based-on-multiple-column-data-mailing-list-exampledata
Sheet: Sheet1

[NAME] College AB10 1FE | 0
Gilcomstoun Primary School AB10 1PG | 0
[NAME] School for Girls AB10 1RU | 0
Broomhill Primary School AB10 6JF | 0
Ashley Road Primary School AB10 6RU | 0
Kaimhill Primary School AB10 7HR | 0
Ferryhill Primary School AB11 6TT | 0
Walker Road Primary School AB11 8DL | 0
Tullos Primary School AB11 8FJ | 0
[NAME] AB11 8HD | 0
Victoria Road Primary School AB11 9NT | 0
Charleston School AB12 3FH | 1
Loirston Primary School AB12 3HE | 1
Portlethen Primary School AB12 4PT | 1
Fishermoss Primary School AB12 4UF | 2
Kirkhill Primary School AB12 5BS | 0
Abbotswell Primary School AB12 5QX | 0
Pupil Support Service (Primary) AB12 5ST | 1
Banchory-Devenick Primary School AB12 5XQ | 0
Banchory-Devenick School AB12 5XQ | 0
International School of Aberdeen AB13 0AB | 0
Milltimber Primary School AB13 0DX | 0
Linn Moor Residential School AB14 0PJ | 0
Culter Primary School AB14 0RX | 0
Albyn School for Girls AB15 4PB | 0
The Hamilton School AB15 4YE | 0
[NAME] RC Primary School AB15 4YL | 0
Mile-End Primary School AB15 5LY | 0
Raeden Centre (Nursery School) AB15 5PD | 0
Oakbank School AB15 5XP | 0
Fernielea Primary School AB15 6HD | 0
[NAME] AB15 6HD | 0
Holy Family RC Primary School AB15 6HE | 0
Aberdeen City Council AB15 6JA | 1
Hazlewood School AB15 6JU | 0
Braeside Infant & Nursery School AB15 7TX | 0
[NAME] AB15 7UU | 0
Airyhall Primary School AB15 8AD | 0
Spreadsheet: monika_causholli__28281__Price Forecast
Sheet: Recovered Paper

Recovered Paper Forecast |  |  | $
Firm/Analyst | Units | Current | 2000 | 1Q01 | 2Q01 | 3Q01 | 4Q01 | 2001E | 1Q02 | 2Q02 | 3Q02 | 4Q02 | 2002E | 2003E |  | Date |  | Notes
[NAME] | sh.ton |  |  |  |  |  |  | 45 |  |  |  |  | 45 |  |  | 2001-09-05 00:00:00
CIBC Securities
CS First Boston -OCC | sh.ton | 35 | 72 |  | 33 | 35 | 35 | 34 | 35 |  |  |  | 44 |  |  | 2001-10-25 00:00:00
Deutsche Bank - OCC |  | 35-45 | 82 | 41 | 39 | 40 | 40 | 40 | 40 | 45 | 55 | 65 | 51 | 80 |  | 2001-11-15 00:00:00 |  | Midwest Cost of OCC is 35 vs. West coast is 45
Deutsche Bank - DLK |  |  | 102 | 54 | 52 | 52 | 50 | 52q | 50 | 60 | 75 | 85 | 68q | 105 |  | 2001-09-25 00:00:00 |  | 2001E decreased by $3 - 2002E decreased from 90 to 68
Deutsche Bank - ONP |  |  | 60 | 60 | 53 | 46 | 45 | 51q | 40 | 35 | 35 | 40 | 38q | 55 |  | 2001-09-25 00:00:00 |  | 2001E decreased by $1 - 2002E decreased from 60 to 38
First Associate Investment Inc.
Goldman Sachs OMG | mt |  | 80 |  |  |  |  | 74 |  |  |  |  |  |  |  | 2001-06-24 00:00:00
Goldman Sachs OCC | sh.ton |  | 70 |  |  |  |  | 80 |  |  |  |  |  |  |  | 2001-03-15 00:00:00
JP Morgan
[NAME]
[NAME]
Merrill Lynch
Morgan Stanley
ONP (8) | sh.ton | 51 | 83 |  |  |  |  | 53 |  |  |  |  | 62 | 81 |  | 2001-10-31 00:00:00
ONP (6) | sh.ton | 34 | 59 |  |  |  |  | 36 |  |  |  |  | 39 | 54 |  | 2001-10-31 00:00:00
OCC (11) | sh.ton | 43 | 80 |  |  |  |  | 41 |  |  |  |  | 60 | 92 |  | 2001-10-31 00:00:00
Dbl.  [NAME] (13) | sh.ton | 51 | 96 |  |  |  |  | 51 |  |  |  |  | 81 | 124 |  | 2001-10-31 00:00:00
Mixed Paper (1) | sh.ton | 23 | 50 |  |  |  |  | 24 |  |  |  |  | 29 | 41 |  | 2001-10-31 00:00:00
Magazines (10) | sh.ton | 48 | 70 |  |  |  |  | 52 |  |  |  |  | 53 | 66 |  | 2001-10-31 00:00:00
Boxboard (4) | sh.ton | 39 | 60 |  |  |  |  | 38 |  |  |  |  | 47 | 60 |  | 2001-10-31 00:00:00
Envelope Cuttings (31) | sh.ton | 210 | 373 |  |  |  |  | 228 |  |  |  |  | 230 | 307 |  | 2001-10-31 00:00:00
Hard White Shavings (30) | sh.ton | 193 | 335 |  |  |  |  | 206 |  |  |  |  | 206 | 281 |  | 2001-10-31 00:00:00
White News Blanks (24) | sh.ton | 166 | 149 |  |  |  |  | 161 |  |  |  |  | 165 | 164 |  | 2001-10-31 00:00:00
Sorted Office Paper (37) | sh.ton | 76 | 145 |  |  |  |  | 82 |  |  |  |  | 86 | 130 |  | 2001-10-31 00:00:00
Coated Book Stock (43) | sh.ton | 77 | 144 |  |  |  |  | 84 |  |  |  |  | 88 | 131 |  | 2001-10-31 00:00:00
Salomon Smith Barney
Scotiabank
TD Securities
Spreadsheet: 708961d1608113266-look-up-value-in-range-and-perform-action-with-data-on-that-row-bpm-tax-online
Sheet: Afschrijving

BPM berekening | 2017 |  |  |  |  |  |  |  |  |  |  | 2018 | 2019 | 2020
datum eerste toelating |  |  |  |  |  |  |  |  |  |  | datum eerste toelating
datum op naam |  |  |  |  |  |  |  |  |  |  | datum op naam
afschrijvingspercentage: |  |  |  |  |  | uitkomst moet worden 32,332% |  |  |  |  | afschrijvingspercentage:
[NAME] | [NAME] minder [NAME] | afschr % | plus voor iedere maand die helemaal of voor een deel verstreken is sinds de periode uit de 1e kolom
0 | 1 | 0 | 8
1 | 3 | 8 | 3
 | 5 | 14 | 2.5
 | 9 | 19 | 2.25
 | 18 | 28 | 1.444
 | 30 | 41 | 0.917
 | 42 | 52 | 0.833
 | 54 | 62 | 0.75
 | 66 | 71 | 0.416
 | 78 | 76 | 0.416
 | 90 | 81 | 0.333
 | 102 | 85 | 0.333
 | 114 | 89 | 0.25
 | 9999 | 92 | 0.083
Spreadsheet: 117685d1312963889-problems-with-if-statements-planner-holidays
Sheet: Days Used

 |  | Director | Contracts Department |  |  |  |  |  | Administration |  |  | Garage |  | HSE
 | Type of Leave | P Rushton | D Byrne | D Kemp | C Newell | A Brunton | S Hodgson | D Kerry | K Wilson | H Sockett | S Sturman | M Griffiths | D Wood | B Green
 | Holiday
 | Authorised
 | Sick
 | Unpaid
 | Maternity
 | Paternity
 | Parental
 | Suspension
 | Training
Spreadsheet: 766409d1643889027-formula-to-determine-operating-date-starting-time-example
Sheet: Sheet1

 |  |  |  | Time | [NAME] |  |  | Currently, Excel "sorts" times with midnight (00:00) being the starting point
 |  |  |  | 0:00:00 |  |  |  | Ideal formula would evaluate cell B5 to determine new "starting point" that would "replace" midnight
 |  |  |  | 1:00:00 |  |  |  | I would assume some sort of "if" statement would be needed, I'm just not sure how
 | Starting Time |  |  | 2:00:00
 | 20:00:00 |  |  | 3:00:00 |  |  |  | So in this example, the new sorted data would show |  |  |  |  |  |  | Or, if [NAME] said 17:00, then the new order would be
 |  |  |  | 4:00:00
 |  |  |  | 5:00:00 |  |  |  | 20:00:00 |  |  |  |  |  |  | 17:00:00
 |  |  |  | 6:00:00 |  |  |  | 21:00:00 |  |  |  |  |  |  | 18:00:00
 |  |  |  | 7:00:00 |  |  |  | 22:00:00 |  |  |  |  |  |  | 19:00:00
 |  |  |  | 8:00:00 |  |  |  | 23:00:00 |  |  |  |  |  |  | 20:00:00
 |  |  |  | 9:00:00 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  |  | 21:00:00
 |  |  |  | 10:00:00 |  |  |  | 1900-01-01 01:00:00 |  |  |  |  |  |  | 22:00:00
 |  |  |  | 11:00:00 |  |  |  | 1900-01-01 02:00:00 |  |  |  |  |  |  | 23:00:00
 |  |  |  | 12:00:00 |  |  |  | 1900-01-01 03:00:00 |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  | 13:00:00 |  |  |  | 1900-01-01 04:00:00 |  |  |  |  |  |  | 1900-01-01 01:00:00
 |  |  |  | 14:00:00 |  |  |  | 1900-01-01 05:00:00 |  |  |  |  |  |  | 1900-01-01 02:00:00
 |  |  |  | 15:00:00 |  |  |  | 1900-01-01 06:00:00 |  |  |  |  |  |  | 1900-01-01 03:00:00
 |  |  |  | 16:00:00 |  |  |  | 1900-01-01 07:00:00 |  |  |  |  |  |  | 1900-01-01 04:00:00
 |  |  |  | 17:00:00 |  |  |  | 1900-01-01 08:00:00 |  |  |  |  |  |  | 1900-01-01 05:00:00
 |  |  |  | 18:00:00 |  |  |  | 1900-01-01 09:00:00 |  |  |  |  |  |  | 1900-01-01 06:00:00
 |  |  |  | 19:00:00 |  |  |  | 1900-01-01 10:00:00 |  |  |  |  |  |  | 1900-01-01 07:00:00
 |  |  |  | 20:00:00 |  |  |  | 1900-01-01 11:00:00 |  |  |  |  |  |  | 1900-01-01 08:00:00
 |  |  |  | 21:00:00 |  |  |  | 1900-01-01 12:00:00 |  |  |  |  |  |  | 1900-01-01 09:00:00
 |  |  |  | 22:00:00 |  |  |  | 1900-01-01 13:00:00 |  |  |  |  |  |  | 1900-01-01 10:00:00
 |  |  |  | 23:00:00 |  |  |  | 1900-01-01 14:00:00 |  |  |  |  |  |  | 1900-01-01 11:00:00
 |  |  |  |  |  |  |  | 1900-01-01 15:00:00 |  |  |  |  |  |  | 1900-01-01 12:00:00
 |  |  |  |  |  |  |  | 1900-01-01 16:00:00 |  |  |  |  |  |  | 1900-01-01 13:00:00
 |  |  |  |  |  |  |  | 1900-01-01 17:00:00 |  |  |  |  |  |  | 1900-01-01 14:00:00
 |  |  |  |  |  |  |  | 1900-01-01 18:00:00 |  |  |  |  |  |  | 1900-01-01 15:00:00
 |  |  |  |  |  |  |  | 1900-01-01 19:00:00 |  |  |  |  |  |  | 1900-01-01 16:00:00
Spreadsheet: 4252ec8b-32fa-4475-9455-4133901d6a97
Sheet: Sheet1

GENERAL | 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
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  |  | Approval Deadline |  | Reason
Reducing and increasing appropriations in the Capital Improvement |  |  |  |  | Public Service Allocation
and authorizing contract with MARC for Green Impact Zone.
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | City Manager
 | Authrizing transfer of $750,000 in the Capital Improvements
 | Fund from the Capital Improvements Department  account
 | to the Public Works Department Street Preservation account |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  |  | City Manager
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 | This ordinance appropriates $750,000 from the
 | Unappropriated Fund Balance of the General Fund to fund |  |  |  | Staff
 | ongoing activities in the Green Impact Zone. Such activities |  |  |  | Recommendation |  |  |  | For
 | hiring and deployment of outreach workers into the zone,
 | implementation of a neighborhood leadership program |  |  |  |  |  |  |  | Against
 | within the zone, and establishment and operation of
 | neighborhood improvement crews within the zone to develop |  |  |  |  |  | Reason Against
 | job skills and practices for young adults and to do exterior
 | work to homes and public properties.
 | Transferring $750,000.00 from NC 3 contingency money
 | from its location in Capital Improvements Department to
 | Public Works Department for Street Preservation.
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  |  |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  |  |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
 |  |  |  |  |  |  |  |  | 12-1000-101450-B
Applicable Dates:
Reviewed by:
Reference Numbers
Spreadsheet: a9120d0d-ee9b-4d16-a5b1-349ce50dc962
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME | PROGRAM
4486 | 10412 | [NAME] | Beven | AUS | 0 |  |  |  |  |  | 1 |  | Elite Men
4485 | 5384 | Rina | Hill | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | [NAME] | Elite Women
4485 | 15305 | Sabine | [NAME] | GER | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:05:40 | Elite Women
4485 | 10228 | [NAME] | Rose | NZL | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:06:21 | Elite Women