tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 854991d1704734200-filter-without-result-to-show-blank-for-vstack-filter-without-result
Sheet: Sheet2

Code | Start | End | Prorate |  |  | 2023-06-30 00:00:00 |  | Code | Start | End | Cost
#1 | 2023-05-12 00:00:00 |  | 500 |  |  |  |  |  | 2023-06-11 00:00:00 | 00:00:00 | 150 |  | Basically, I want the top to be Code that start in the Month (E1) and bottom to show Code that end in the Month (E1)
#2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600 |  |  |  |  | #4 | 2023-06-26 00:00:00 | 2023-09-16 00:00:00 | 3600 |  | However, the formula only work nicely if the filter is a valid for both Start and End.
#3 | 2023-06-11 00:00:00 |  | 150 |  |  |  |  | #2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600 |  | How do I make a Iferror, then it will show blank?
#4 | 2023-06-26 00:00:00 | 2023-09-16 00:00:00 | 3600
#5 | 2023-07-11 00:00:00 |  | 800 |  |  |  |  |  |  |  |  |  | *If the eomonth of START = G1, den ((G1-Start)/day(G1))*column D
#6 | 2023-09-01 00:00:00 |  | 300 |  |  |  |  |  |  |  |  |  | if eomonth of [NAME], den ((Day(end)/Day(g1))*column D
#7 | 2023-09-16 00:00:00 |  | 600
#8 | 2023-10-01 00:00:00 |  | 900
#9 | 2023-10-16 00:00:00 | 2023-12-31 00:00:00 | 7500
#10 | 2023-10-31 00:00:00 |  | 3000
 |  |  |  |  |  |  |  | Code | Start | End | Cost | Prorate
 |  |  |  |  |  |  |  |  | 2023-06-11 00:00:00 |  | 150 | 95
 |  |  |  |  |  |  |  | #4 | 2023-06-26 00:00:00 | 2023-09-16 00:00:00 | 3600 | 480
 |  |  |  |  |  |  |  | #2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600 | 20
 |  |  |  |  |  | 2023-05-31 00:00:00 |  |  |  |  |  |  |  | 2023-12-31 00:00:00
 |  |  |  |  |  |  | Expected |  |  |  |  |  |  |  | Expected
 |  |  |  |  |  |  |  | Code | Start | End | Cost |  |  |  |  | Code | Start | End | Cost
 |  |  |  |  |  |  |  | #1 | 2023-05-12 00:00:00 |  | 500 |  |  |  |  | #9 | 2023-10-16 00:00:00 | 2023-12-31 00:00:00 | 7500
 |  |  |  |  |  |  |  | #2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600
 |  |  |  |  |  |  |  | Code | Start | End | Cost | Prorate |  |  |  | Code | Start | End | Cost | Prorate
 |  |  |  |  |  |  |  | #1 | 2023-05-12 00:00:00 |  | 500 |  |  |  |  | #9 | 2023-10-16 00:00:00 | 2023-12-31 00:00:00 | 7500
 |  |  |  |  |  |  |  | #2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600
 |  |  |  |  |  | The month in G1 is like "For the Month of xxxxx". Not juz the day itself. Hence 31/5/2023 mean 1st to 31st May
 |  |  |  |  |  | *For the Prorate part, if [NAME] in the Month, the amt to prorate = ((Number of days in the month)-(Start Date)+1)/(Number of days in the month)* Monthly Rate
 |  |  |  |  |  | If it end on the month itself, then would be (Day end)/(Number of days in the month)* Monthly Rate
 |  |  |  |  |  | The formula is fine if the filter criteria is Valid for both Start and End (eg 30/06/2023), but it haywire if either one is error.
Spreadsheet: 147043d1332496340-conditional-formatting-dates-solved-sample
Sheet: review

 |  |  | 2nd Week Service Telephone Review
 |  | Todays Date
 |  | First Name of Service User | Last Name | Date Joined | Review Done
 |  |  |  | 2012-03-02 00:00:00 | 2012-03-23 00:00:00
 |  |  |  | 2012-03-07 00:00:00
 |  |  |  | 2012-03-22 00:00:00
 |  |  |  | 2012-01-01 00:00:00
 |  |  |  | 2012-03-01 00:00:00
 |  |  |  | 2012-03-21 00:00:00
 |  |  |  | 2012-03-08 00:00:00 | 2012-03-09 00:00:00
 |  |  |  | 2012-03-07 00:00:00
 |  |  |  | 2012-03-09 00:00:00
 |  |  |  | 2012-03-19 00:00:00
 |  |  |  | 2012-03-10 00:00:00
 |  |  |  | 2012-03-11 00:00:00
 |  |  |  | 2012-03-12 00:00:00
Spreadsheet: 116029d1311522312-selective-columns-handicap-template-midshires
Sheet: rb

Reynolds. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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: phillip_allen__28799__granhous1
Sheet: npv

 |  |  | herndon
 | Purchase price |  | 900000
 | Interest |  | 0.085
 | Years |  | 15
 | Downpayment
 | Financed Charges
 | Payment
 | Taxes
 | Water |  | -700
 | Insurance |  | -400
 | Maintenance |  | -2000
 | Total Expenses
 | Rent
 | Monthly Net
 | Annual Net
 | Annual Return
 |  |  | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
 |  | Rent
 |  | Taxes
 |  | Water
 |  | Insurance
 |  | Maintenance
 |  | rent-exp
 |  | cash outlay | -350000 |  |  |  |  | -40000 |  |  |  |  | -40000 |  |  |  |  | 950000
 |  | net cash
 |  | 15 year irr
 |  | Interest Exp.
 |  | Payments
 |  | Principal
 |  | Prin. Bal
Spreadsheet: 03e8cd72-2d64-4521-8c77-e4068b4c6aad
Sheet: Sheet1

2013 Approved Closing Agencies
Title Company | phone
Actual Title | [PHONE]
[NAME] | [PHONE]
Best Title Resources | [PHONE]
Canal Title | [PHONE]
Century Title | [PHONE]
Crescent Title | [PHONE]
Delta Title | [PHONE]
Flagship Title | [PHONE]
Gulf South Title | [PHONE]
Homestead Title | [PHONE]
[NAME]  / Granite Title | [PHONE]
Newman Title Insurance Agency | [PHONE]
[NAME] (Steeg Law Firm) | [PHONE]
Property Title | [PHONE]
Select Title | [PHONE]
Silverstein Title Agency | [PHONE]
Southeast Land Title | [PHONE]
Southern Title | [PHONE]
Sovereign Title | [PHONE]
[NAME] (1-5) | [PHONE]
Supreme | [PHONE]
Title Management Group | [PHONE]
True Title | [PHONE]
[NAME] | [PHONE]
Winters Title | [PHONE]
Spreadsheet: 150474d1334569592-list-and-count-all-duplicate-values-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | LIST |  |  | COUNT
 | 1-7 | 6-5 | 3-2 |  |  |  |  | 3-6 | 7-10 | 8-13 |  | 4.019
 | 3-6 | 7-10 | 8-13 |  |  |  |  | 1-7 | 6-5 | 3-2 |  | 3.017
 | 4-7 | 8-11 | 13-12 |  |  |  |  | 13-2 | 14-1 | 17-2 |  | 2.015
 | 1-7 | 6-5 | 3-2
 | 13-2 | 14-1 | 17-2
2.015 | 13-2 | 14-1 | 17-2
 | 3-6 | 7-10 | 8-13
3.017 | 1-7 | 6-5 | 3-2
 | 3-6 | 7-10 | 8-13
4.019 | 3-6 | 7-10 | 8-13
Spreadsheet: 728431d1618460011-if-cell-contains-certain-rule-then-copies-a-range-of-other-cells-to-another-tab-example
Sheet: Register

 | Job Number | Address | Job Description | Client | Permit  Number | Job Notes
 | ABC001 | Address 1 | Description 1 | Client 1 | 001/001/001
 | ABC002 | Address 2 | Description 2 | Client 2 | Required
 | ABC003 | Address 3 | Description 3 | Client 3 | 001/001/003
 | ABC004 | Address 4 | Description 4 | Client 4 | Required
 | ABC005 | Address 5 | Description 5 | Client 5 | Required
 | ABC006 | Address 6 | Description 6 | Client 6 | 001/001/006
 | ABC007 | Address 7 | Description 7 | Client 7 | 001/001/007
 | ABC008 | Address 8 | Description 8 | Client 8 | 001/001/008
 | ABC009 | Address 9 | Description 9 | Client 9 | 001/001/009
 | ABC010 | Address 10 | Description 10 | Client 10 | Required
 | ABC011 | Address 11 | Description 11 | Client 11 | Required
 | ABC012 | Address 12 | Description 12 | Client 12 | Required
 | ABC013 | Address 13 | Description 13 | Client 13 | Required
 | ABC014 | Address 14 | Description 14 | Client 14 | Required
 | [NAME] | Address 15 | Description 15 | Client 15 | Required
 | ABC016 | Address 16 | Description 16 | Client 16 | 001/001/016
 | ABC017 | Address 17 | Description 17 | Client 17 | 001/001/017
 | ABC018 | Address 18 | Description 18 | Client 18 | 001/001/018
 | ABC019 | Address 19 | Description 19 | Client 19 | 001/001/019
 | ABC020 | Address 20 | Description 20 | Client 20 | 001/001/020
Spreadsheet: 481969d1474821500-need-help-to-re-arrange-data-automatically-2d-index-match-multiple-results
Sheet: Sheet2

Date Range (auto-updates) | Buy Offers |  |  |  |  | Sell Offers
Spreadsheet: 5deae3c4-f45d-47bb-a8cc-e92654980e95
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7842 | 5577 | Ingrid | [NAME] | NED | 190 | 00:17:56 | [NAME] | 01:24:04 | [NAME] | 00:47:20 | 1 | 02:33:04
7842 | 58895 | Simone | Lankhuijzen | NED | 188 | 00:23:14 | 00:02:24 | 01:32:27 | 00:01:52 | 00:49:09 | 2 | 02:49:04
7842 | 58893 | [NAME] | Diephuis | NED | 187 | 00:25:38 | 00:02:18 | 01:47:55 | [NAME] | 00:59:11 | 3 | 03:17:02
Spreadsheet: 148998d1333642949-transferring-information-from-a-master-worksheet-into-secondary-worksheets-test-job-log-2012
Sheet: 2012 Job List

 | 2012 |  |  |  | 2012-03-26 00:00:00 |  |  |  | JOB LIST
PM | JOB # | Start Date | Completion Date | Closed Date | Contract Value | Invoice Amount | Invoice Date | PAID    Date | Description | P.O. # | Location | We Are | Customer | End User |  | Quote #
 | M11-
[NAME] | C11-181 | 2011-11-07 00:00:00 |  |  | 2811 | 2811 | 2012-02-15 00:00:00 | 2012-03-21 00:00:00 | Moisture Monitor Electrical | 4501379746 |  | Direct | CSSC | CSSC |  | QGD-1130
FE | C11-182 | 2011-11-14 00:00:00 |  |  | 11622 | 11622 | 2011-12-05 00:00:00 | 2012-03-21 00:00:00 | Warehouse Electrical Upgrade | 1975100 |  | Sub | RWC | Lamar |  | QGD-1125
[NAME] | C11-183 | 2011-11-17 00:00:00 |  |  | 1374 | 1374 | 2011-12-05 00:00:00 | 2012-01-12 00:00:00 | 1st Floor Conference Room | PS10020875 |  | Direct | CSSC | CSSC |  | QGD-1131
[NAME] | C11-184 | 2011-11-29 00:00:00 |  |  | 511 | 511 | 2011-12-29 00:00:00 | 2012-02-08 00:00:00 | 2nd Floor Electrical Outlet | PS10020900 |  | Direct | CSSC | CSSC |  | QGD-1137
FE | C12-185 | 2012-01-05 00:00:00 |  |  | 2720 | 2720 | 2012-01-16 00:00:00 | 2012-02-24 00:00:00 | CSSC 2nd Flr Conference Relocation | PS10021052 |  | Direct | CSSC | CSSC |  | QGD-1135
NW | C12-186 | 2012-01-12 00:00:00 |  |  | 665 |  |  |  | CSSC "Y" Epoxy Floor Upgrade | 4501502767 |  | Direct | CSSC | CSSC |  | QGD-1134
BR | C12-187 | 2012-02-29 00:00:00 |  |  | 3360 | 3360 | 2012-03-22 00:00:00 |  | CSSC Plant Manager's HVAC Feeder | 4501480628 |  | Sub | PAC | CSSC |  | QGD-12169
[NAME] | C12-188 | 2012-03-01 00:00:00 |  |  | 1199 | 1199 | 2012-03-14 00:00:00 |  | CSSC Excutive Administrators Office | PS10021264 |  | Direct | CSSC | CSSC |  | QGD-12183
FE | C12-189 | 2012-03-13 00:00:00 |  |  | 10942 | 10942 | 2012-03-22 00:00:00 |  | CSSC Prego Dumpers | 4501491635 |  | Direct | CSSC | CSSC |  | QGD-12199
[NAME] | C12-190 | 2012-03-26 00:00:00 |  |  | 600 |  |  |  | CSSC "AA" & "GG" Epoxy Floor Upgrade | 4501502694 |  | Direct | CSSC | CSSC |  | QGD-1132/1133
FE | T11-118 | 2011-10-27 00:00:00 |  |  | 16534 | 16534 | 2011-11-11 00:00:00 | 2011-12-01 00:00:00 | Consolidated Container - Duncanville | 1100-11 |  | Sub | SUMM | CC |  | QGD-102511-1
NW | T11-120 | 2011-12-28 00:00:00 |  |  | 985 | 985 | 2012-01-23 00:00:00 | 2012-02-27 00:00:00 | Cord/Cap on Compressor | 3729-0987 |  | Sub | C&E | TPP |  | n/a
Spreadsheet: 123386d1317638194-converting-cell-text-which-is-a-calculation-factors-excerpt
Sheet: factors of "binaries"

 |  | Number |  | Factors
 | 1 | 001 | 101 | 971*1031 | 1001101 | 1 |  |  |  |  |  |  |  |  |  |  |  | -1
 | 1 | 001 | 111 | 181*5531 | 1001111 | 1 |  |  |  |  |  |  |  |  |  |  |  | -1
 | 1 | 010 | 011 | 31^2*1051 | 1010011 | 1 |  |  |  |  |  |  |  |  |  |  |  | -1
 | 1 | 010 | 111 | 163*6197 | 1010111 | 1 |  |  |  |  |  |  |  |  |  |  |  | -1
Spreadsheet: cf8aaa23-556f-4f16-8654-aab6acd60b60
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | 080837 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Amending Chapter 2 of the Code of Ordinances regarding Volunteers
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2008-09 |  |  | FY 2009-10
 | General Fund |  |  |  | 0 |  |  | 0
 | Special Revenue |  |  |  | 0 |  |  | 0
 | Enterprise
 |  |  | Total: | $ | 0 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2008-09 |  |  | FY 2009-10
 | General Fund
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ | 0 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
 | This ordinance will create a policy governing the use of volunteers in City operations.  The ordinance
 | will require background checks for all volunteers (exceeding 1,000 per year) for total minimum
 | additional cost of $100,000 to the City as a whole.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date |  |  |  | 2008-09-02 00:00:00
Spreadsheet: 88459d1288273094-formula-to-return-text-on-a-set-condition-20101027-estimate-pack
Sheet: Labour budget

 |  |  |  |  |  |  |  | Estimate:
Labour costs
Employee |  |  |  | Days budgeted | Hours budgeted | Cost @ Standard rate (£25/hr)
Dig out footings
Concrete
Drainage
Brickwork to DPC
Backfill
Concrete oversite
Fit floor joists
Lay MOT and compact
Lay insulation and visqueon
Concrete slab
Cut cavities and fit wall starters
Built to first floor
Fit joists
Build to wall plate
Cut openings and fit padstones and lintels
Form roof
Complete brickwork
Fit gutters
Cover roof - felt / batton and tile
Paint fascias
Joinery 1st fix
Fit windows
Joinery 2nd fix
[NAME] final fix
Kitchen
Loft insulation
Flagging
Tiling
 |  |  |  | Total hours budgetted for job
 |  |  |  |  | Total labour cost
Spreadsheet: 0bcd5ad7-934f-4994-970e-0b8702bcabb7
Sheet: 9c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis* | 111743 | 60742 | 138691 | <1,000 |  | <1,000 |  | <1,000 |  | 311176
FRA |  |  | 400643 | 146071 |  | 359266 |  | 915751 |  | 1821731
IRS- [NAME] | 2341304 | 2600636 | 1341176 | 101320 |  | 262516 | 482392 | 948560 | 417713 | 8495617
OIS |  | 317676 | 69635 |  |  |  |  |  |  | 387311
VNS
Zero Coupon | 2993 | <1,000 |  |  |  |  |  | <1,000 |  | 2993
TOTAL | 2456040 | 2979054 | 1950145 | 247391 |  | 621782 | 482392 | 1864311 | 417713 | 11018828
Estimated gross notional amount outstanding, May 24 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 4eaa95a7-e890-488e-864e-c3bbe1e78da6
Sheet: Sheet1

FY 2012 AEA STATE AID PAYMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | ORIGINAL | SEPT-MAY | PAID THROUGH | AMOUNT
 |  | BUDGET | PAYMENT | MAY | REMAINING
1 | [NAME] 1 | 12173702 | 1217373 | 10956357 | 1217345
5 | PRAIRIE LAKES AEA 8 | 11932421 | 1193242 | 10739178 | 1193243
7 | AEA 267 | 25953086 | 2595314 | 23357826 | 2595260
9 | MISSISSIPPI BEND AEA 9 | 17943809 | 1794383 | 16149447 | 1794362
10 | GRANT WOOD AEA 10 | 25140991 | 2514103 | 22626927 | 2514064
11 | HEARTLAND AEA 11 | 45695987 | 4569599 | 41126391 | 4569596
12 | NORTHWEST AEA | 14971662 | 1497170 | 13474530 | 1497132
13 | GREEN HILLS AEA 13 | 14813279 | 1481329 | 13331961 | 1481318
15 | GREAT PRAIRIE AEA 15 | 13537748 | 1353777 | 12183993 | 1353755
 |  | 182162685 | 18216290 | 163946610 | 18216075
Spreadsheet: e89d76cf-04c0-4a67-a4be-2754c1d11d56
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 |  | Aeronáutica Civil de Colombia
 |  | Oficina de Transporte Aéreo
 |  | Grupo de Estudios Sectoriales
 |  | [NAME] y Demanda Septiembre 2011
 |  | [NAME]
 |  | Operación regular y no regular
 |  | Nivel Ocupación
 |  | Sin considerar la distancia de los trayectos
 |  | Novedades | Novedades y conceptos importantes [NAME] información.
 |  | Cuadro 2.1A | Comportamiento Oferta y Demanda [NAME] Regular y no Regular
 |  | Cuadro 2.1B | Comportamiento Oferta y Demanda [NAME] Regular y no Regular
 |  | Cuadro 2.2A | Oferta y demanda pasajeros nacionales por empresa
 |  | Cuadro 2.2B | Oferta y demanda pasajeros internacionales por empresa
 |  | Cuadro 2.3 | Oferta y Demanda Pasajeros - Principales Rutas Nacionales
 |  | Cuadro 2.3B | Oferta y Demanda [NAME] nacionales rutas troncales por empresa
 |  | Cuadro 2.4 | Oferta y Demanda Pasajeros - Principales rutas internacionales
 |  | Cuadro 2.5 | Oferta y Demanda [NAME] y empresa
 |  | Nivel Ocupación
 |  | [NAME] trayectos
 |  | Cuadro 2.6A | Comportamiento Oferta y Demanda [NAME]  y no Regular- Pax-Km y Sillas-Km
 |  | Cuadro 2.6B | Comportamiento Oferta y Demanda [NAME] Regular y no Regular- Pax-Km y Sillas-Km
 |  | Cuadro 2.7A | Oferta y demanda pasajeros nacionales por empresa - Pax-Km y Sillas-Km
 |  | Cuadro 2.7B | Oferta y demanda pasajeros internacionales por empresa - Pax-Km y Sillas-Km
 |  | Cuadro 2.8 | Oferta y Demanda Pasajeros - Principales Rutas Nacionales - Pax-Km y Sillas-Km
 |  | Cuadro 2.9 | Oferta y Demanda Pasajeros - Principales rutas internacionales - Pax-Km y Sillas-Km
 |  | Cuadro 2.10 | Oferta y Demanda [NAME] – Continente y empresa - Pax-Km y Sillas-Km
 |  | Edición
 |  | [NAME]
 |  | Estadístico Grupo de Estudios Sectoriales
 |  | [NAME]
Spreadsheet: 124648d1318523875-sum-non-consecutive-numbers-sum7rows
Sheet: Sheet1

1 | 28 | <<Look at this formula | 28
2 | 77 |  | 77
3 | 126
4 | 175
5 | 224
6 | 273
7 | 132
8 | 0
9 | 0
10 | 0
11 | 0
12 | 0
13 | 0
14 | 0
15 | 0
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
Spreadsheet: 721407d1614691446-call-column-for-the-data-from-the-same-group-fruits-group
Sheet: Sheet1

 |  |  |  |  |  | Fruit | Group
 | GroupA | GroupB | GroupC | GroupD |  | [NAME]
 | [NAME] | Orange | Grape | BlueBerry |  | Lychee | GroupA , GroupD
 | Lychee | Apple | Orange | Soursop |  | Strawbery | GroupA
 | Pomegranate | Pomegranate | Kiwi | Pomegranate |  | Orange | GroupB , GroupC
 | Strawbery | Mango | Avocado | Lychee |  | Apple | GroupB
 |  |  |  |  |  | Pomegranate | GroupA , GroupB , GroupD
 |  |  |  |  |  | Mango | GroupB
 |  |  |  |  |  | Grape | GroupC
 |  |  |  |  |  | Kiwi | GroupC
 |  |  |  |  |  | Avocado | GroupC
 |  |  |  |  |  | BlueBerry | GroupD
 |  |  |  |  |  | Soursop | GroupD
Spreadsheet: chris_germany__2125__JanCohCHOICE-ENA
Sheet: Jan 7

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-01-07 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 665 |  | 279 |  | 67694 |  |  |  |  |  | 27 | 1 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 2 | 33
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 3553 |  | 1947 |  | 67694 |  |  |  |  |  | 27 | 3 | 33 |  |  | 15
 |  |  |  |  |  |  |  |  | 6999 |  | 6999 |  | 68918 | 0 |  |  |  |  | 28 | 4 | 32 |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 5 | 34 |  |  | 15
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 285 |  | 0 |  | 67694 |  |  |  |  |  | 26 | 6 | 32 |  |  | 22
 |  |  |  |  |  |  |  |  | 2400 |  | 2400 |  | 68915 | 0 |  |  |  |  | 28 | 7 | 32 |  |  | 15
 |  |  |  |  |  |  |  |  | 500 |  | 500 |  | 69148 | 0 |  |  |  |  | 29 | 8 | 35 |  |  | 14
 |  |  |  |  |  |  |  |  | 1600 |  | 1600 |  | 69693 | 0 |  |  |  |  | 28 | 9 | 34 |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 15 | 41 |  |  | 16
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 10269 |  | 7673 |  | 67694 |  |  |  |  |  | 29 | 35 | 35 |  |  | 17
 |  |  |  |  |  |  |  |  | 85 |  | 85 |  | 68917 | 0 |  |  |  |  | 28 | 39 | 32 |  |  | 17
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69149 | 0 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1880 |  | 1283 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1039 |  | 731 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 11199 |  | 7487 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 3686 |  | 3047 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 2490 |  | 1807 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 4760 |  | 3901 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1554 |  | 1087 |  | 67694
 |  |  |  |  |  |  |  |  | 200 |  | 200 |  | 69708 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 38 |  | 33 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 69708 | 0
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  | 27835 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 866049d1712988517-subtract-one-value-from-multiple-others-subtraction-work-hours-vacation-ans
Sheet: Sheet1

Start |  |  |  | result
Work | [NAME] | Vacation
8 |  | 25
4
2
10
8
Column A - hours of action that an employee is performing in a week, per project
Column B - amount of hours of vacation in a week
I would like to gradually reduce the hours of work by the amount of vacation hours
Result
Work |  | Vacation
0 |  | 25
0
0
0
7
Spreadsheet: 785810d1656698172-how-to-stack-multiple-column-of-a-range-into-one-column-keeping-duplicate-values-intact-stack-multiple-column-of-a-range
Sheet: Sheet1

Before stack
301
302 | 302 | 302
303 | 303 | 303
304 | 304
305
306 | 306 | 306
RAC | RAC | RAC
Heat | Heat
Wood
201
202
Audi
After stacked :
 |  | 301
 |  | 302
 |  | 303
 |  | 304
 |  | 305
 |  | 306
 |  | RAC
 |  | Heat
 |  | Wood
 |  | 201
 |  | 202
 |  | Audi
 |  | 302
 |  | 303
 |  | 304
 |  | 306
 |  | RAC
 |  | Heat
 |  | 302
 |  | 303
 |  | 306
 |  | RAC
Spreadsheet: 150488d1334576661-show-top-salesmen-from-dynamic-range-sales-array
Sheet: Sheet1

S.no | [NAME] | Zone | Sales |  |  | [NAME] | Sales
1 | [NAME] | A | 75 |  | Zone A [NAME]
2 | Angie | C | 83 |  | Zone B [NAME]
3 | Anne | A | 150 |  | Zone C [NAME]
4 | [NAME] | B | 25
5 | Mairi-Claire | B | 15 |  | [NAME]
6 | [NAME] | C | 225