tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 466796d1466447217-report-formula-query-profitability-may-2016
Sheet: Total 2016

 | 2016 Projects Profitability
 | Project | Value based on Cost Values | Value Based on Chargeability Values | Invoiced | Profitability % | Overservicing %
1 | 0 | 0 | 0 | 0 | 0 | 1
 | Project | Value based on Cost Values | Value Based on Chargeability Values | Invoiced | Profitability % CH | Overservicing %
1 |  |  |  |  | 0 | 1
2 |  |  |  |  | 0 | 1
3 |  |  |  |  | 0 | 1
4 |  |  |  |  | 0 | 1
5 |  |  |  |  | 0 | 1
6 |  |  |  |  | 0 | 1
7 |  |  |  |  | 0 | 1
8 |  |  |  |  | 0 | 1
9 |  |  |  |  | 0 | 1
10 |  |  |  |  | 0 | 1
11 |  |  |  |  | 0 | 1
12 |  |  |  |  | 0 | 1
13 |  |  |  |  | 0 | 1
14 |  |  |  |  | 0 | 1
15 |  |  |  |  | 0 | 1
16 |  |  |  |  | 0 | 1
17 |  |  |  |  | 0 | 1
18 |  |  |  |  | 0 | 1
19 |  |  |  |  | 0 | 1
20 |  |  |  |  | 0 | 1
21 |  |  |  |  | 0 | 1
22 |  |  |  |  | 0 | 1
23 |  |  |  |  | 0 | 1
24 |  |  |  |  | 0 | 1
25 |  |  |  |  | 0 | 1
26 |  |  |  |  | 0 | 1
27 |  |  |  |  | 0 | 1
28 |  |  |  |  | 0 | 1
29 |  |  |  |  | 0 | 1
30 |  |  |  |  | 0 | 1
31 |  |  |  |  | 0 | 1
32 |  |  |  |  | 0 | 1
33 |  |  |  |  | 0 | 1
34 |  |  |  |  | 0 | 1
35 |  |  |  |  | 0 | 1
36 |  |  |  |  | 0 | 1
37 |  |  |  |  | 0 | 1
38 |  |  |  |  | 0 | 1
39 |  |  |  |  | 0 | 1
40 |  |  |  |  | 0 | 1
41 |  |  |  |  | 0 | 1
42 |  |  |  |  | 0 | 1
43 |  |  |  |  | 0 | 1
44 |  |  |  |  | 0 | 1
45 |  |  |  |  | 0 | 1
46 |  |  |  |  | 0 | 1
47 |  |  |  |  | 0 | 1
48 |  |  |  |  | 0 | 1
49 |  |  |  |  | 0 | 1
50 |  |  |  |  | 0 | 1
51 |  |  |  |  | 0 | 1
52 |  |  |  |  | 0 | 1
53 |  |  |  |  | 0 | 1
54 |  |  |  |  | 0 | 1
55 |  |  |  |  | 0 | 1
56 |  |  |  |  | 0 | 1
57 |  |  |  |  | 0 | 1
Spreadsheet: 862834d1710421628-need-help-totaling-based-on-selections-mix-id-calculator-tier_addres
Sheet: Residential Select Tab

Residential Mix ID Calculator
Tier | Mix ID | Add On |  |  |  |  |  |  |  |  |  | Distance | Total
T1
 |  | Air | HRWR | 3/8 Agg | [NAME] | 1%Retard | 2%Retard | 3%Retard | Fiber | SRA | SS
 | COM301510 | False | False | False |  |  | False | False | False | False | False | 1-10
Spreadsheet: 827857d1683077759-pull-data-from-one-sheet-to-another-from-last-data-entered-in-a-column-and-the-12-24-above-ak-sample3-gcb
Sheet: COVER-24

 | AK |  |  |  |  |  | unlock 1111 |  |  |  |  |  |  | combo | Cover
Well No. | 12H | 13H | 14H | 15H | Total |  |  |  |  |  |  |  |  | combo
Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Online/Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Choke |  |  |  |  |  |  |  |  |  |  |  |  |  | lt f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | lt p
Casing PSI |  |  |  |  |  |  | Copy and paste table into email body |  |  |  |  |  |  | fork
Surface Csg |  |  |  |  |  |  |  |  |  |  |  |  |  | lift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | trash
Water / Day |  |  |  |  |  | Clear | enter water totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | ft
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ft
Oil / Day |  |  |  |  |  |  | enter oil totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
[NAME] to sales |  |  |  |  |  |  |  |  |  |  |  |  |  | plug C
Gas / Day |  |  |  |  |  |  | enter gas totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
Inj / Day | off | off | off |  |  |  |  |  |  |  |  |  |  | st
 |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Yesterday Lact |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Notes: |  |  |  |  |  |  | gfhghcghghgvhvgvgvhgvhvghvgvgh
 | PM
 | 12H | 13H | 14H | 15H
GAS
WATER
OIL
 | AM |  |  |  |  |  | lact total
 | 12H | 13H | 14H | 15H |  |  | 0430 | 24 b4 |  |  |  |  | IF(g28-h28<0,0,g28-h28)
GAS |  |  |  |  |  | 750 |  | 118029
WATER |  |  |  |  |  | 760
OIL |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 676799d1588971698-extract-info-from-workbook-and-make-a-list-search-for-extra
Sheet: Travel

 | Hotels |  |  |  |  |  |  | Trains |  |  |  |  |  |  | Car
 | Item | Comment | Amount | Price | Total |  |  | Item | Comment | Amount | Price | Total |  |  | Item | Comment | Amount | Price | Total
 | Day 1 |  | 45 | 150 |  |  |  | George |  | 1 | 22 |  |  |  | [NAME] | Extra 10% | 14 | 11
 | Day 2 |  | 67 | 150 |  |  |  | Anna | Sponsor:100% | 1 | 91 |  |  |  | Fred |  | 87 | 11
 | Day 3 | Extra: 10% | 34 | 150 |  |  |  | [NAME] |  | 1 | 35 |  |  |  | [NAME] |  | 46 | 11
Spreadsheet: 769474d1645550943-extract-text-between-parentheses-cost-center
Sheet: Sheet1

WO | District | LeadTech | Amount | Cost Center |  |  |  | WO | District | LeadTech | Amount | Cost Center
 | Administration(920): |  |  |  |  |  |  |  | Administration(920):
A00100 | North | [NAME] | 360 |  |  |  |  | A00100 | North | [NAME] | 360 | 920
A00101 | South | Lopez | 90.0416 |  |  |  |  | A00101 | South | Lopez | 90.0416 | 920
A00102 | Central | [NAME] | 120 |  |  |  |  | A00102 | Central | [NAME] | 120 | 920
A00103 | South | Lopez | 16.25 |  |  |  |  | A00103 | South | Lopez | 16.25 | 920
A00104 | Northwest | [NAME] | 45.2374 |  |  |  |  | A00104 | Northwest | [NAME] | 45.2374 | 920
A00105 | South | Lopez | 97.6263 |  |  |  |  | A00105 | South | Lopez | 97.6263 | 920
A00106 | Central | [NAME] | 29.13 |  |  |  |  | A00106 | Central | [NAME] | 29.13 | 920
A00107 | South | Lopez | 35.1 |  |  |  |  | A00107 | South | Lopez | 35.1 | 920
A00108 | Northwest | [NAME] | 76.7 |  |  |  |  | A00108 | Northwest | [NAME] | 76.7 | 920
A00109 | Central | [NAME] | 374.0794 |  |  |  |  | A00109 | Central | [NAME] | 374.0794 | 920
A00110 | West | [NAME] | 832.1583 |  |  |  |  | A00110 | West | [NAME] | 832.1583 | 920
 | [NAME]): |  |  |  |  |  |  |  | [NAME]):
A00111 | South | Lopez | 70.213 |  |  |  |  | A00111 | South | Lopez | 70.213 | 821
A00112 | West | [NAME] | 150 |  |  |  |  | A00112 | West | [NAME] | 150 | 821
A00113 | Central | [NAME] | 275 |  |  |  |  | A00113 | Central | [NAME] | 275 | 821
A00114 | Northwest | [NAME] | 938 |  |  |  |  | A00114 | Northwest | [NAME] | 938 | 821
A00115 | South | Lopez | 61.2497 |  |  |  |  | A00115 | South | Lopez | 61.2497 | 821
A00116 | West | [NAME] | 48 |  |  |  |  | A00116 | West | [NAME] | 48 | 821
A00117 | Northwest | [NAME] | 204.284 |  |  |  |  | A00117 | Northwest | [NAME] | 204.284 | 821
A00118 | Northwest | [NAME] | 240 |  |  |  |  | A00118 | Northwest | [NAME] | 240 | 821
 | Administration(554): |  |  |  |  |  |  |  | Administration(554):
A00130 | Southwest | [NAME] | 155.3931 |  |  |  |  | A00130 | Southwest | [NAME] | 155.3931 | 554
A00131 | Northwest | [NAME] | 204.284 |  |  |  |  | A00131 | Northwest | [NAME] | 204.284 | 554
A00132 | Northwest | [NAME] | 37.9174 |  |  |  |  | A00132 | Northwest | [NAME] | 37.9174 | 554
A00133 | West | [NAME] | 88.4057 |  |  |  |  | A00133 | West | [NAME] | 88.4057 | 554
A00134 | West | [NAME] | 202.2864 |  |  |  |  | A00134 | West | [NAME] | 202.2864 | 554
A00135 | Northwest | [NAME] | 120 |  |  |  |  | A00135 | Northwest | [NAME] | 120 | 554
Spreadsheet: b5e44b8a-a66c-4aaf-ab17-944b9968a0d8
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
42493211 | 2014-07-28 20:32:11 | ALLIES | 1 | 5 | 2 | 1610766 | Cannon1195 | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
Spreadsheet: 825962d1681694926-struggling-with-overnight-shift-info-on-gantt-baseline-chart-type-for-planning-purposes-overnight_dummydata-helpplease
Sheet: Totals

Desired Input | For desired input, I want to only use a single formula so I don't drag it to the right in case times extend.
 | Date |  | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
 | 2023-04-18 00:00:00
 | 2023-04-19 00:00:00
 | 2023-04-20 00:00:00
 | 2023-04-21 00:00:00
 | 2023-04-22 00:00:00
 | 2023-04-23 00:00:00
Spreadsheet: 0268e56d-5d3b-4893-8a66-beaa9a99bb88
Sheet: TSP - Kansas

Vendor Information
 | AT&T |  |  | Address: 12851 [NAME], St. Louis, MO 63131 |  |  | Contact Name: [NAME] |  | GSA Region 6 LSA         Solicitation # 6QTC-11-SH-001
Phone number:         [PHONE] |  |  | Fax number:  NA |  |  |  | Email: [EMAIL]
CLIN | Services Offered | Geographic Area Served | MINUS 10%   Month To Month | Month To Month | One-Time Installation Price | MINUS 10% One-Time Installation Price | Service Pricing Notes |  | Tariff
 | Telecommunications Service Priority (TSP)
K005O | Priority Level Change (PR8PX) | Kansas | N/A | N/A |  | 50 |  |  | ACCESS SVCS - SEC 10
K005P | Priority Installation (enrollment) (P1APX) | Kansas | N/A | N/A |  | 50 |  |  | FCC 73 - SEC 10
K005Q | Priority Restoration  (PR5PX) | Kansas | 5 |  |  | 51 |  |  | FCC 73 - SEC 10
Note 1:
Spreadsheet: 581027d1531058832-compare-2-sheets-and-show-balance-bbsn
Sheet: ENTRY

CODE | Customer Name | Address | DATE | MONTH | YEAR | Date of Keeping | Serial Number | Item Name | Gross Weight | Net Weight | Amount | Remarks
AS1 | Ranjana | Khabam | 20 | 12 | 2018 |  | 2 | [NAME] | 3 san | 2 san | 20000
AS2 | Samida | [NAME] | 1 | 12 | 2018 |  | 3 | lei |  |  | 10000
AS3 | Samida | [NAME] | 7 | 7 | 2018 |  | 4 | lik |  |  | 5000
AS4 | Jahida | khabam | 23 | 7 | 2018 |  | 5 | baltin mana | 4 san | 3 san | 25000 | received 200 int
[NAME] | L Bobby | mantripukri | 2 | 9 | 2017 |  | 6 | nl |  |  | 3500
[NAME] | L Bobby | [NAME] | 3 | 10 | 2017 |  | 7 | matek |  |  | 1500
AS7 | Sheetalit | moirang | 29 | 11 | 2016 |  | 8 | jantra |  |  | 1800
Spreadsheet: 437721d1451485809-help-with-sorting-adresses-example
Sheet: Ark1

THE LIST AS I GET IT
Zip code | City | Street | Info #1 | Info #2 | Name | Phone number | Misc
1234 | Oslo | Oslostreet 1 | Yes | No | [NAME] | 12345678 | Insert comments here
5678 | Bergen | Bergenstreet 2 | No | Yes | [NAME] | 87654321 | Witty comment
2468 | Hamar | Hamarstreet 3 | No | No | [NAME] | 24681012 | Not so witty comment
AFTER RUN IT THROUGH SOFTWARE TO ROUTE IT MOST EFFICIENTLY I GET A CSV FILE LIKE THIS
Hamarstreet 3, 2468, Hamar
Oslostreet 1, 1234, Oslo
Bergenstreet 2, 5678, Bergen
SO I THEN MANUALLY CUT AND PASTE THE CORRECT ORDER
Zip code | City | Street | Info #1 | Info #2 | Name | Phone number | Misc
2468 | Hamar | Hamarstreet 3 | No | No | [NAME] | 24681012 | Not so witty comment
1234 | Oslo | Oslostreet 1 | Yes | No | [NAME] | 12345678 | Insert comments here
5678 | Bergen | Bergenstreet 2 | No | Yes | [NAME] | 87654321 | Witty comment
This is all well and easy for 3 adresses, but I'm anywhere from 400-700 adresses I need to do this. Based on this information, can I make it automatically?
Spreadsheet: 697812d1601553650-solved-help-analyzing-data-in-a-table-shared-expense-who-owes-whom-splitting-costs-tactics-pq
Sheet: Data (table)

Date | Credit | Debit | Amount | Project
2018-11-17 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2019-03-15 00:00:00 | [NAME] | Ellen | 280 | Proj-6
2017-04-10 00:00:00 | Adam | [NAME] | 150 | Proj-8
2018-12-07 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2017-06-10 00:00:00 | Adam | [NAME] | 320 | Proj-5
2019-08-15 00:00:00 | Ellen | Emily | 700 | Proj-8
2019-04-20 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2020-04-30 00:00:00 | Adam | [NAME] | 200 | Proj-3
2019-02-15 00:00:00 | Adam | [NAME] | 2000 | Proj-5
2019-01-09 00:00:00 | [NAME] | Ellen | 1700 | Proj-2
2018-08-26 00:00:00 | [NAME] | Adam | 500 | Proj-5
2017-04-10 00:00:00 | Adam | [NAME] | 180 | Proj-8
2019-11-28 00:00:00 | Ellen | [NAME] | 400 | Proj-9
2018-08-02 00:00:00 | Emma | Adam | 920 | Proj-10
2017-06-04 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2018-11-23 00:00:00 | Ellen | Adam | 1500 | Proj-6
2017-06-02 00:00:00 | Adam | [NAME] | 280 | Proj-1
2018-09-27 00:00:00 | [NAME] | Adam | 1170 | Proj-5
2018-04-15 00:00:00 | [NAME] | [NAME] | 1000 | Proj-5
2020-04-22 00:00:00 | Adam | [NAME] | 400 | Proj-3
2018-07-12 00:00:00 | [NAME] | Adam | 495 | Proj-5
2019-11-13 00:00:00 | Emily | [NAME] | 650 | Proj-9
2019-08-19 00:00:00 | Ellen | [NAME] | 500 | Proj-8
2018-04-15 00:00:00 | [NAME] | Adam | 500 | Proj-5
2017-06-10 00:00:00 | Adam | [NAME] | 1000 | Proj-5
2019-08-19 00:00:00 | Ellen | Emily | 300 | Proj-8
2018-02-09 00:00:00 | [NAME] | Ellen | 400 | Proj-6
2019-02-05 00:00:00 | Emma | Ellen | 3400 | Proj-7
2018-08-12 00:00:00 | Ellen | Adam | 500 | Proj-6
2018-07-12 00:00:00 | Adam | [NAME] | 350 | Proj-5
2018-11-07 00:00:00 | Adam | Emily | 185 | Proj-6
2019-11-20 00:00:00 | Adam | [NAME] | 300 | Proj-9
2019-03-15 00:00:00 | [NAME] | Emily | 360 | Proj-6
2018-08-04 00:00:00 | [NAME] | Emily | 250 | Proj-1
2018-08-15 00:00:00 | Adam | [NAME] | 2000 | Proj-5
2020-04-26 00:00:00 | Adam | [NAME] | 250 | Proj-3
2019-11-20 00:00:00 | Adam | [NAME] | 450 | Proj-9
2018-07-09 00:00:00 | [NAME] | [NAME] | 350 | Proj-5
2018-10-05 00:00:00 | Emma | Adam | 550 | Proj-5
2019-11-25 00:00:00 | Ellen | [NAME] | 300 | Proj-9
2019-11-24 00:00:00 | [NAME] | Emily | 650 | Proj-4
2017-04-10 00:00:00 | Adam | [NAME] | 105 | Proj-10
2017-07-10 00:00:00 | Adam | [NAME] | 2000 | Proj-5
2018-10-31 00:00:00 | [NAME] | Adam | 1500 | Proj-5
2019-11-05 00:00:00 | Ellen | [NAME] | 400 | Proj-3
2018-02-13 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2018-04-24 00:00:00 | [NAME] | Adam | 495 | Proj-5
2018-04-11 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2019-12-23 00:00:00 | Ellen | [NAME] | 150 | Proj-1
2018-06-28 00:00:00 | [NAME] | [NAME] | 1000 | Proj-5
Spreadsheet: 887585d1737825155-generating-1-column-of-data-into-a-calendar-reviews-calendar-test_3
Sheet: Mar

 |  |  | 2025-02-24 00:00:00 | 2025-02-25 00:00:00 | 2025-02-26 00:00:00 | 2025-02-27 00:00:00 | 2025-02-28 00:00:00 | 2025-03-01 00:00:00
 |  |  | 2025-03-03 00:00:00 | 2025-03-04 00:00:00 | 2025-03-05 00:00:00 | 2025-03-06 00:00:00 | 2025-03-07 00:00:00 | 2025-03-08 00:00:00
 |  |  | 2025-03-10 00:00:00 | 2025-03-11 00:00:00 | 2025-03-12 00:00:00 | 2025-03-13 00:00:00 | 2025-03-14 00:00:00 | 2025-03-15 00:00:00
 |  |  | 2025-03-17 00:00:00 | 2025-03-18 00:00:00 | 2025-03-19 00:00:00 | 2025-03-20 00:00:00 | 2025-03-21 00:00:00 | 2025-03-22 00:00:00
 |  |  | 2025-03-24 00:00:00 | 2025-03-25 00:00:00 | 2025-03-26 00:00:00 | 2025-03-27 00:00:00 | 2025-03-28 00:00:00 | 2025-03-29 00:00:00
 |  |  | 2025-03-31 00:00:00 | Notes
Spreadsheet: benjamin_rogers__1054__Consolidated 6 Peaker-062000
Sheet: Wilton

INCOME STATEMENT - WILTON
('000 $)
Revenue
Fixed Price Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Energy Payment
Start Charge
Amortization of Power Contract
Merchant Period:
Demand Payment | 0 | 0 | 0
Variable Revenue | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major [NAME]
Owner's Expense
Property Taxes Liability | 572 | 583.4 | 595.1 | 607 | 619.1 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - WILTON
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA less Amortization of Power Contract
Plus Property Tax Liability
Less Property Tax Expense | -333.7
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & FRANCHISE TAX - WILTON
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Paid-In-Capital
State Franchise Tax Rate
State Franchise Tax Liability
STATE TAXES
Pretax Book Income less Amortization of Power Contract
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Spreadsheet: 585380d1533738203-count-no-of-time-a-date-occure-in-column-no-of-date
Sheet: AUG 18

DATE IN /TIME | DATE OUT /TIME |  |  |  |  |  | no of entries on date
2018-08-01 10:30:00 | 2018-08-01 15:30:00 |  |  |  |  | 2018-08-01 00:00:00 |  | how to count No of entries of date irrespective of time (column A)1/8/18 in column H
2018-08-01 14:35:00 | 2018-08-02 06:20:00 |  |  |  |  | 2018-08-02 00:00:00
2018-08-01 15:35:00 | 2018-08-03 14:10:00 |  |  |  |  | 2018-08-03 00:00:00
2018-08-01 17:40:00 | 2018-08-03 10:10:00 |  |  |  |  | 2018-08-04 00:00:00
2018-08-01 14:30:00 | 2018-08-05 14:30:00 |  |  |  |  | 2018-08-05 00:00:00 |  | 0
2018-08-01 19:35:00 | 2018-08-02 06:45:00 |  |  |  |  | 2018-08-06 00:00:00
2018-08-01 20:00:00 | 2018-08-02 16:05:00 |  |  |  |  | 2018-08-07 00:00:00
2018-08-02 04:00:00 | 2018-08-02 19:20:00 |  |  |  |  | 2018-08-08 00:00:00 |  | 0
2018-08-02 08:15:00 | 2018-08-02 18:00:00 |  |  |  |  | 2018-08-09 00:00:00
2018-08-02 20:15:00 | 2018-08-03 02:50:00 |  |  |  |  | 2018-08-10 00:00:00
2018-08-02 20:40:00 | 2018-08-02 22:15:00 |  |  |  |  | 2018-08-11 00:00:00
2018-08-02 23:00:00 | 2018-08-03 08:40:00 |  |  |  |  | 2018-08-12 00:00:00
2018-08-02 23:45:00 | 2018-08-03 08:35:00 |  |  |  |  | 2018-08-13 00:00:00
2018-08-02 23:55:00 | 2018-08-03 07:50:00 |  |  |  |  | 2018-08-14 00:00:00
2018-08-03 07:00:00 | 2018-08-03 21:00:00 |  |  |  |  | 2018-08-15 00:00:00
2018-08-03 14:30:00 | 2018-08-04 08:50:00 |  |  |  |  | 2018-08-16 00:00:00
2018-08-03 16:50:00 | 2018-08-04 10:50:00 |  |  |  |  | 2018-08-17 00:00:00
2018-08-03 18:00:00 | 2018-08-04 12:25:00 |  |  |  |  | 2018-08-18 00:00:00
2018-08-03 19:15:00 | 2018-08-04 16:15:00 |  |  |  |  | 2018-08-19 00:00:00
2018-08-03 20:10:00 | 2018-08-04 20:10:00 |  |  |  |  | 2018-08-20 00:00:00
2018-08-03 20:20:00 | 2018-08-04 16:35:00 |  |  |  |  | 2018-08-21 00:00:00
2018-08-03 20:30:00 | 2018-08-04 20:00:00 |  |  |  |  | 2018-08-22 00:00:00
2018-08-03 21:40:00 | 2018-08-05 13:30:00 |  |  |  |  | 2018-08-23 00:00:00
2018-08-03 22:30:00 | 2018-08-04 11:20:00 |  |  |  |  | 2018-08-24 00:00:00
2018-08-03 22:30:00 | 2018-08-04 10:50:00 |  |  |  |  | 2018-08-25 00:00:00
2018-08-03 22:46:00 | 2018-08-04 22:00:00 |  |  |  |  | 2018-08-26 00:00:00
2018-08-03 23:30:00 | 2018-08-05 19:30:00 |  |  |  |  | 2018-08-27 00:00:00
2018-08-03 23:25:00 | 2018-08-06 12:30:00 |  |  |  |  | 2018-08-28 00:00:00
2018-08-03 23:35:00 | 2018-08-04 08:40:00 |  |  |  |  | 2018-08-29 00:00:00
2018-08-03 23:30:00 | 2018-08-04 08:40:00 |  |  |  |  | 2018-08-30 00:00:00
2018-08-03 23:30:00 | 2018-08-04 08:40:00
Spreadsheet: 115480d1311085614-formula-to-auto-number-reftest
Sheet: Sheet1

Total Collected |  | Reference Number
0
0
8.78 |  | 1
2277.25 |  | 2
0.03 |  | 3
0
0
1836.39 |  | 4
0
8399.54 |  | 5
7595.86 |  | 6
193.73 |  | 7
392.27 |  | 8
440.4 |  | 9
116.01 |  | 10
22431.53 |  | 11
0.8 |  | 12
3067.28 |  | 13
254.91 |  | 14
65.04 |  | 15
0
0
0
0
0
299.49 |  | 16
2.56 |  | 17
475.11 |  | 18
1474.82
553.34
0.36
152.18
300.1799999999999
895.3100000000001
988.12
1.61
6.79
101.87
2.71
4633.31
71376.78000000001
211.72
0
70.91000000000001
1.27
157.5
258.64
1162.62
46.23
0
127.02
335.5
2117.35
1.68
3.85
0.76
7.12
52.14
1.68
17.5
904.62
0
113.18
286.58
1494.15
8222.62
65.97
8165.44
1814.97
0
276.08
101.38
315.52
510.99
0
0
10841.17
484.21
1156.9
23.81
0
0
0
8098.76
338.01
0
664.78
424.96
2.65
21.53
199.52
0
0
105.9
0
389.14
198.35
11.44
30.21
231.91
5.88
411.11
0.17
13.91
0
0.17
0
0
0.04
0
0
0.56
0
178844.44
Spreadsheet: 346822fe-30c6-478f-8728-a6dd5a727739
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
 |  |  |  | AGENCIA NACIONAL DE REGULACIÓN Y CONTROL DE TRANSPORTE TERRESTRE, TRÁNSITO Y SEGURIDAD VIAL
FORMULARIO PARA EL INCREMENTO DE CUPO Y/O UNIDADES VEHICULARES
TRANSPORTE PÚBLICO, COMERCIAL
[NAME] |  |  |  | ____ /____ / _____ | DATOS DE LA ORGANIZACIÓN
TIPO DE SOLICITUD
INCREMENTO DE CUPO/ UNIDADES VEHICULARES |  |  |  |  | NOMBRE DE LA ORGANIZACIÓN O RAZÓN SOCIAL |  |  |  |  |  |  | RUC |  |  |  | COMPAÑÍA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COOPERATIVA
RELACIÓN E IDENTIFICACIÓN DE SOCIOS/ACCIONISTAS Y VEHÍCULOS
SOCIOS / ACCIONISTAS |  |  |  |  |  |  |  | VEHÍCULOS
No. | CÉDULA DE  IDENTIDAD | APELLIDO PATERNO | APELLIDO  MATERNO | NOMBRES | LICENCIA [NAME] (*) | [NAME]. [NAME] (*) | FECHA  ACEPTACIÓN (*) | PLACA | MARCA/ MODELO | AÑO. FAB | N°. CHASIS | N°. MOTOR | CILINDRAJE | CAPAC. CARGA Ton. | CARROCERIA-MARCA | N°. PASAJEROS | CLASE VEHIÍULO | TIPO VEHÍCULO
1
2
3
4
5
6
7
8
9
10
REPRESENTANTE LEGAL
 |  |  |  |  |  |  |  | NOMBRE
 |  |  |  |  |  |  |  | FIRMA Y SELLO
REQUISITOS PARA INCREMENTO DE CUPO
1. [NAME] Vehicular ([NAME]) firmado y sellado por el Jefe de Títulos Habilitantes, 6 meses [NAME]. Para automotores nuevos, [NAME], no se requerirá la constatación de la flota vehicular y se presentará copias legibles y a color de la factura y demás documentos del vehículo notariados, los mismos que tendrán validez hasta 6 meses de emitida la factura.
2.Copias legibles de documentos personales  : [NAME], papeleta de votación actualizada  y  [NAME] (*)
3.Copias [NAME] : [NAME], copia del contrato notariado de compra/venta. Para automotores nuevos, se presentará copia [NAME]  por la casa comercial o copia notariada, SOAT vigente, y copia [NAME] carrocería [NAME] microbuses, minibuses y buses.
4. [NAME], certificada por [NAME] ( [NAME]) o Listado actualizado (últimos 2 meses) de accionistas emitido por la Superintendencia de Compañías (para [NAME])
5. Copia del permiso de operación.
6. [NAME] (legible y a color) de la operadora.
7. [NAME] juramentada del dueño [NAME]no ser miembro activo [NAME], tampoco vigilante, autoridad o empleado civil que trabaje en los organismos relacionados con el tránsito y transporte terrestre o ha dejado [NAME] hace 2 años o mas.
8.  [NAME] vehículo es nuevo debe constar en el listado de productos homologados de la ANT. [NAME] microbuses, minibuses y buses nuevos deben constar tanto [NAME] chasis como su carrocería en el listado de productos homologados de la ANT.
El peticionario es el único responsable del origen de las firmas y documentos ingresados [NAME].[NAME]  se reserva el derecho de iniciar la acción legal pertinente, en caso de que se detecte cualquier adulteración en los documentos. (*) [NAME]
Spreadsheet: 838952d1691550258-match-cells-between-sheets-and-copy-other-cells-if-match-inventoryexample
Sheet: Last Year Inventory

 |  | Last Year Stock on Hand | Last Year Unit of Measure
Product 1 | 352700 | 47 | Lbs
Product 2 | 325325 | 105 | Oz
Product 3 | 351500 | 645 | Feet
Product 4 | 284150 | 3000 | Pound
Product 5 | 274503 | 1250 | Pieces
Product 6 | 822030 | 23 | Lbs