tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 873503d1720008196-how-to-combine-daily-sales-remaining-stock-into-one-table-how-to-combine-daily-sales-remaining-stock-into-one-table
Sheet: Table

Warehouse stock
Date | Order Number | Name | Channel | Stock in |  |  | Stock Out |  |  | Remaining Stock |  |  | Price | Transport fee | TOTAL
 |  |  |  | Orange | [NAME] | Mango | Orange | [NAME] | Mango | Orange | [NAME] | Mango
2024-06-30 00:00:00 |  | Remaning Stock in june |  | 51 | 51 | 51
2024-07-01 00:00:00 | 33-1525 | [NAME] |  |  |  |  | 9 | 9 |  |  |  |  | 1980000 | 546000
2024-07-01 00:00:00 | 33-1526 | [NAME] |  |  |  |  | 3 | 3 | 3 |  |  |  | 999000 | 24000
2024-07-01 00:00:00 | 33-1527 | [NAME] |  |  |  |  | 6 | 6 | 6 |  |  |  | 1980000 | 200000
2024-07-01 00:00:00 | 33-1528 | Amazon |  |  |  |  | 9 | 9 |  |  |  |  | 1980000 | 546000
2024-07-01 00:00:00 | 33-1529 | Alibaba |  |  |  |  | 3 | 3 | 3 |  |  |  | 999000 | 24000
2024-07-02 00:00:00 | 33-1530 | [NAME] |  |  |  |  | 3 | 3 | 3
2024-07-02 00:00:00 | 33-1531 | veronia |  |  |  |  |  | 6
2024-07-02 00:00:00 | 33-1532 | olivia |  |  |  |  | 12 |  | 12
2024-07-02 00:00:00 | 33-1533 | Amazon |  |  |  |  | 3 | 3
2024-07-02 00:00:00 |  | Restocking |  | 80 | 80 | 80
2024-07-02 00:00:00 | 33-1534 | Alibaba |  |  |  |  |  |  | 9
2024-07-03 00:00:00 | 33-1535 | [NAME] |  |  |  |  | 3 | 3 | 3
2024-07-03 00:00:00 | 33-1536 | phei |  |  |  |  |  | 6 | 6
2024-07-03 00:00:00 | 33-1537 | [NAME] |  |  |  |  |  | 10 | 9
2024-07-03 00:00:00 | 33-1538 | Amazon |  |  |  |  | 9
2024-07-04 00:00:00 | 33-1540 | [NAME] |  |  |  |  | 6
2024-07-04 00:00:00 | 33-1541 | [NAME] |  |  |  |  |  | 3
2024-07-04 00:00:00 | 33-1542 | [NAME] |  |  |  |  |  | 3
2024-07-04 00:00:00 | 33-1543 | Amazon |  |  |  |  |  | 6
2024-07-04 00:00:00 | 33-1544 | Alibaba |  |  |  |  | 3
2024-07-05 00:00:00 | 33-1545 | [NAME] |  |  |  |  | 6
2024-07-05 00:00:00 | 33-1546 | phei |  |  |  |  | 3 | 3 | 9
2024-07-05 00:00:00 | 33-1547 | [NAME] |  |  |  |  | 6
2024-07-05 00:00:00 | 33-1548 | Amazon |  |  |  |  |  | 3
2024-07-05 00:00:00 | 33-1549 | Alibaba |  |  |  |  | 24 | 12 | 12
Warehouse stock
Date | Order Number | Name |  | Stock in |  |  | Stock Out |  |  | Remaining Stock
 |  |  |  | Orange | [NAME] | Mango | Orange | [NAME] | Mango | Orange | [NAME] | Mango
2024-06-30 00:00:00 |  | Remaning Stock in june |  | 51 | 51 | 51
2024-07-01 00:00:00
2024-07-01 00:00:00
2024-07-01 00:00:00
2024-07-01 00:00:00
2024-07-01 00:00:00
2024-07-02 00:00:00
2024-07-02 00:00:00
2024-07-02 00:00:00
2024-07-02 00:00:00
2024-07-02 00:00:00
2024-07-02 00:00:00
2024-07-03 00:00:00
2024-07-03 00:00:00
2024-07-03 00:00:00
2024-07-03 00:00:00
2024-07-04 00:00:00
2024-07-04 00:00:00
2024-07-04 00:00:00
2024-07-04 00:00:00
2024-07-04 00:00:00
2024-07-05 00:00:00
2024-07-05 00:00:00
2024-07-05 00:00:00
2024-07-05 00:00:00
2024-07-05 00:00:00
Spreadsheet: 11a177d5-5f98-45f2-bfe1-b64228f60bec
Sheet: Block 5

Block 5
Sub-mainline Sizing and Pressure
 | 150 | C-value for PVC ID > 5"
 | 145 | C-value for PVC 1.5" < = ID < =  5"
 | 140 | C-value  for PVC < 1.5"
 | 10 | feet, Total Elevation Drop
 | 670.3 | feet, Length of Sub-mainline
 |  | ft/ft, Change in Elevation
 | 0.5 | GPH/emitter
 |  | GPM/emitter
 | 3.045 | ft, emitter spacing
 | Chg. Elev = Length * ft/ft (elevation change worst case)
 | Chg. P = Chg. Elev + Hf
Section A
Row | Row Length ft | GPM per Row | Pressure PSI | Length ft | GPM | Pipe ID, in | Velocity, ft/sec | C-Value | Hf (psi) | Chg. Elev (psi) | Chg. P (psi)
Inlet | 0 | 0 | 25 | 0 | 52 | 2.193
1 | 17.7 |  |  | 19.2 |  | 2.193
 | 35.7 |  |  | 19.6 |  | 2.193
 | 53.7 |  |  | 19.6 |  | 2.193
 | 71.7 |  |  | 19.6 |  | 2.193
 | 89.7 |  |  | 19.6 |  | 2.193
 | 107.7 |  |  | 19.6 |  | 2.193
 | 125.7 |  |  | 19.6 |  | 2.193
 | 143.7 |  |  | 19.6 |  | 2.193
 | 161.7 |  |  | 19.6 |  | 2.193
 | 179.8 |  |  | 19.6 |  | 2.193
 | 197.8 |  |  | 19.6 |  | 2.193
Section B
 | 213.7 |  |  | 18.4 |  | 2.193
 | 211 |  |  | 8.2 |  | 2.193
 | 208.4 |  |  | 8.2 |  | 2.193
 | 205.7 |  |  | 8.2 |  | 2.193
 | 203 |  |  | 8.2 |  | 2.193
 | 200.4 |  |  | 8.2 |  | 2.193
 | 197.7 |  |  | 8.2 |  | 2.193
 | 195 |  |  | 8.2 |  | 2.193
 | 195.8 |  |  | 8.2 |  | 2.193
 | 197.5 |  |  | 8.2 |  | 2.193
 | 199.3 |  |  | 8.2 |  | 2.193
 | 201 |  |  | 8.2 |  | 2.193
 | 202.7 |  |  | 8.2 |  | 2.193
 | 204.5 |  |  | 8.2 |  | 2.193
 | 206.2 |  |  | 8.2 |  | 2.193
 | 207.9 |  |  | 8.2 |  | 2.193
 | 209.7 |  |  | 8.2 |  | 2.193
 | 211.4 |  |  | 8.2 |  | 2.193
 | 213.1 |  |  | 8.2 |  | 2.193
 | 218 |  |  | 8.2 |  | 2.193
 | 234.2 |  |  | 8.2 |  | 2.193
 | 250.4 |  |  | 8.2 |  | 2.193
 | 266.6 |  |  | 8.2 |  | 2.193
 | 282.8 |  |  | 8.2 |  | 2.193
 | 299 |  |  | 8.2 |  | 2.193
 | 315.1 |  |  | 8.2 |  | 2.193
 | 331.1 |  |  | 8.2 |  | 2.193
 | 347.5 |  |  | 8.2 |  | 2.193
 | 363.7 |  |  | 8.2 |  | 2.193
 | 379.9 |  |  | 8.2 |  | 2.193
 | 396.1 |  |  | 8.2 |  | 2.193
 | 412.3 |  |  | 9.2 |  | 2.193
Section C
 | 434 |  |  | 10 |  | 1.72
 | 462.2 |  |  | 12.1 |  | 1.72
 | 490.5 |  |  | 12.1 |  | 1.72
 | 518.7 |  |  | 12.1 |  | 1.72
 | 546.9 |  |  | 12.1 |  | 1.72
 | 575.2 |  |  | 12.1 |  | 1.72
 | 603.4 |  |  | 12.1 |  | 1.72
 | 631.7 |  |  | 12.1 |  | 1.72
 | 660 |  |  | 12.1 |  | 1.72
 | 688.2 |  |  | 12.1 |  | 1.72
 | 716.4 |  |  | 12.1 |  | 1.72
 | 744.7 |  |  | 12.1 |  | 1.72
 | 772.9 |  |  | 12.1 |  | 1.72
 | 801.2 |  |  | 12.1 |  | 1.72
 | 829.4 |  |  | 12.1 |  | 1.72
 |  | Min P |  | PSI
 |  | [NAME] |  | PSI
 |  | Avg. P, PSI
 |  | Total GPM
 |  | Sub-Main Length, ft
Spreadsheet: 218729d1362562711-how-to-calculate-total-bags-in-monthwise-sheet-1
Sheet: Sheet1

H
K
A
S # | Date | Column1 | [NAME] | [NAME] |  | Month | K | H | A
1 | 2013-01-15 00:00:00 |  | 140 | H |  | Jan
2 | 2013-01-15 00:00:00 |  | 140 | H |  | Feb
3 | 2013-01-15 00:00:00 |  | 120 | H |  | Mar
4 | 2013-01-18 00:00:00 |  | 340 | H |  | Apr
5 | 2013-01-19 00:00:00 |  | 279 | H |  | May
6 | 2013-01-20 00:00:00 |  | 200 | K |  | Jun
7 | 2013-01-22 00:00:00 |  | 200 | H |  | Jul
8 | 2013-01-22 00:00:00 |  | 420 | H |  | Aug
9 | 2013-01-24 00:00:00 |  | 340 | H
10 | 2013-01-25 00:00:00 |  | 330 | H
11 | 2013-01-28 00:00:00 |  | 340 | H
12 | 2013-01-28 00:00:00 |  | 200 | K
13 | 2013-01-31 00:00:00 |  | 340 | H
14 | 2013-02-02 00:00:00 |  | 200 | K
15 | 2013-02-02 00:00:00 |  | 220 | K
16 | 2012-02-06 00:00:00 |  | 340 | H
17 | 2013-02-08 00:00:00 |  | 200 | K
18 | 2013-02-11 00:00:00 |  | 310 | H
19 | 2013-02-14 00:00:00 |  | 654 | H
20 | 2013-02-14 00:00:00 |  | 340 | H
21 | 2013-02-15 00:00:00 |  | 340 | H
22 | 2013-02-16 00:00:00 |  | 200 | K
23 | 2013-02-17 00:00:00 |  | 200 | K
24 | 2013-02-19 00:00:00 |  | 340 | H
25 | 2013-02-20 00:00:00 |  | 200 | K
26 | 2013-02-21 00:00:00 |  | 200 | K
27 | 2013-02-22 00:00:00 |  | 340 | A
28 | 2013-02-23 00:00:00 |  | 680 | A
29 | 2013-02-23 00:00:00 |  | 200 | K
30 | 2013-02-23 00:00:00 |  | 680 | A
31 | 2013-02-25 00:00:00 |  | 200 | K
32 | 2013-03-01 00:00:00 |  | 200 | K
33 | 2013-03-01 00:00:00 |  | 200 | K
34 | 2013-03-04 00:00:00 |  | 340 | H
35 | 2013-03-04 00:00:00 |  | 200 | K
36 | 2013-03-06 00:00:00 |  | 200 | K
Spreadsheet: robert_badeer__33101__EnergyBillSummary
Sheet: MonthlyData

 | YearNum | MonthNum |  | PXDayAheadBill | ExpostBill | AncillaryServiceBill
 | 1998 | 4 |  | 333.8918996333 | 7.38791436650943 | 19.6732793789062
 | 1998 | 5 |  | 183.666224944217 | 3.22559609575602 | 19.4755450273437
 | 1998 | 6 |  | 207.831543932533 | 1.05848880004882 | 59.6571121127929
 | 1998 | 7 |  | 681.325471675781 | 17.0377411390771 | 121.332452535156
 | 1998 | 8 |  | 833.048632054687 | 48.6051892387049 | 120.829314104736
 | 1998 | 9 |  | 625.392079453125 | 34.5102277392497 | 63.2231201439819
 | 1998 | 10 |  | 408.918593727226 | 20.3555678537845 | 14.7581238457946
 | 1998 | 11 |  | 387.706896226562 | 10.7217579475288 | 1.44696054601287
 | 1998 | 12 |  | 470.46148946875 | 13.4808444179611 | 52.1876287788085
 | 1999 | 1 |  | 335.214183015625 | 7.20862522542572 | 25.0623674513778
 | 1999 | 2 |  | 259.420045070312 | 4.58962980253791 | 15.9620561455078
 | 1999 | 3 |  | 299.999589789062 | 7.95360992561318 | 21.24268794458
 | 1999 | 4 |  | 354.310371515624 | 9.69415852077388 | 35.2084368349609
 | 1999 | 5 |  | 374.521552135673 | 2.66620107780647 | 42.7148530786132
 | 1999 | 6 |  | 415.592589041479 | 8.85375864195346 | 42.7589960775756
 | 1999 | 7 |  | 636.214370226562 | 19.3444070374815 | 55.8475351269531
 | 1999 | 8 |  | 695.151812296875 | 32.5501226128729 | 40.2127526569824
 | 1999 | 9 |  | 606.783869515625 | 27.3427587513275 | 31.4228731352539
 | 1999 | 10 |  | 844.224435718749 | 25.1235632929161 | 46.4311743730468
 | 1999 | 11 |  | 578.582014789062 | 24.2445479182662 | 21.669129677246
 | 1999 | 12 |  | 478.69484571875 | 19.8696383711297 | 10.3912561020507
 | 2000 | 1 |  | 493.153157109375 | 15.1792043618685 | 11.5662010429687
 | 2000 | 2 |  | 401.349459374999 | 7.6421199013462 | 10.2595927436523
 | 2000 | 3 |  | 429.553384781249 | 12.2617540478897 | 11.1410098823242
 | 2000 | 4 |  | 413.713374945312 | 24.4803263050142 | 16.0215210878906
 | 2000 | 5 |  | 818.71284746875 | 77.5790543085939 | 62.3875554926757
 | 2000 | 6 |  | 2066.97625043749 | 252.310415993309 | 395.882972221679
Spreadsheet: 1102ab37-8505-404c-aea2-ce6d01d9aba2
Sheet: Sheet1

Texas A&M International University
Program Budget
 | Camp Name: |  |  |  | Year:
 | Department: |  |  |  | Submitted by:
 | FAMIS Account #: |  |  |  | Back up FAMIS Acct# *:
 |  |  |  |  | * Account to cover program expenses that exceed revenue.
 | Revenue: |  |  | Fixed Expense: |  | Project Profit:
 |  |  |  | Variable Expense:
Projected Revenues
Line | Item |  | Description/Justification |  |  |  | Qty. | Unit Sale/Rate | Total
R1 | Registration Fees |  |  |  |  |  | 0 | 0
R2 | [NAME] |  |  |  |  |  | 0 | 0
R3 | Other Donations |  |  |  |  |  | 0 | 0
R4 |  |  |  |  |  |  | 0 | 0
R5 |  |  |  |  |  |  | 0 | 0
Total
Budget for Fixed Expenses
Line | Item |  | Description/Justification |  |  |  | Qty. | Unit Cost/Rate | Total
F1 | Salaries/Wages |  |  |  |  |  | 0 | 0
F2 | Courseware purchase |  |  |  |  |  | 0 | 0
F3 | Technical equipment |  |  |  |  |  | 0 | 0
F4 | Train-the-trainer |  |  |  |  |  | 0 | 0
F5 | Hardware purchase |  |  |  |  |  | 0 | 0
F6 | Facility rental |  |  |  |  |  | 0 | 0
F7 | Instructional materials |  |  |  |  |  | 0 | 0
F8 | Technical equipment |  |  |  |  |  | 0 | 0
F9 | Consulting fees |  |  |  |  |  | 0 | 0
[NAME] | Instructor fees (Contracts) |  |  |  |  |  | 0 | 0
F11 | Content acquisition |  |  |  |  |  | 0 | 0
F12 | Employee Travel |  |  |  |  |  | 0 | 0
F13 | Background Checks |  |  |  |  |  | 0 | 5
F14 | Admin. Cost to Cont. [NAME]. |  | For ALL EMPLOYEES |  |  |  | 1 | 100
F15 | Registration Fee per Participant |  | For All Particpants |  |  |  | 0 | 2
F16 |  |  |  |  |  |  | 0 | 0
F17 |  |  |  |  |  |  | 0 | 0
F18 |  |  |  |  |  |  | 0 | 0
F19 |  |  |  |  |  |  | 0 | 0
F20 |  |  |  |  |  |  | 0 | 0
Total
Budget for Variable Expenses
Line | Item |  | Description/Justification |  |  |  | Qty. | Unit Cost/Rate | Total
V1 | Consumable Supplies |  |  |  |  |  | 0 | 0
V2 | Instructional materials |  |  |  |  |  | 0 | 0
V3 | Insurance  Sport Type |  | Accident & Medical Per Day; Day Programs= $0.40 Night Programs= $0.65 (Safety Bills) |  |  |  | 0 | 0
V4 | Insurance  Non- Sport Type |  | Accident & Medical Per Day; Day Programs= $0.20 Night Programs= $0.55 (Safety Bills) |  |  |  | 0 | 0
V5 | Meals/Snacks |  |  |  |  |  | 0 | 0
V6 | Transportation |  |  |  |  |  | 0 | 0
V7 | Lodging |  |  |  |  |  | 0 | 0
V8 | SWAG/Gifts to Participants |  |  |  |  |  | 0 | 0
V9 | Cleaning/Damages |  |  |  |  |  | 0 | 0
V10 | Background Checks |  | For Volunteers |  |  |  | 0 | 5
V11 | Credit Card Processing Fees |  | 3% of Credit Card Fees (Qty. = # of Particpants) (Unit Cost/ Rate = Registration Fee X 3%) |  |  |  | 0 | 0
V12 | Form Penalty |  | Registration NOT Submitted Electronically |  |  |  | 0 | 3
V13 | Missing Paperwork (per Form) |  | CPM Documentation |  |  |  | 0 | 5
V14 |  |  |  |  |  |  | 0 | 0
V15 |  |  |  |  |  |  | 0 | 0
V16 |  |  |  |  |  |  | 0 | 0
V17 |  |  |  |  |  |  | 0 | 0
V18 |  |  |  |  |  |  | 0 | 0
V19 |  |  |  |  |  |  | 0 | 0
V20 |  |  |  |  |  |  | 0 | 0
Total
Spreadsheet: 830320d1684854901-trying-to-fill-dates-with-formula-andre-test-yearly-schedule
Sheet: Sheet1

Date | name | shift | Start Date
 | [NAME] | Off Shift | 2023-05-23 00:00:00
 | [NAME]
 | [NAME] |  | Look at formulas in A2 and [NAME] for my answer.
 | Xavier
 | Ziad | Off shift
 | [NAME]
 | [NAME]
 | [NAME]
 | Xavier
 | Ziad
 | [NAME]
 | [NAME] | Off Shift
 | [NAME] | Off Shift
 | Xavier
 | Ziad
 | [NAME]
 | [NAME]
 | [NAME]
 | Xavier
 | Ziad
 | [NAME]
 | [NAME]
 | [NAME]
 | Xavier
 | Ziad
 | [NAME]
 | [NAME]
 | [NAME]
 | Xavier
 | Ziad
Spreadsheet: 156269d1337247607-excel-2007-meeting-criteria-in-a-range-example-4-
Sheet: Sheet1

Column A | Column B
1 | A
4 | J
7 | A
4 | B
6 | A
6 | E
5 | E
8 | D
9 | F
8 | F
Does 5 and A or 8 and D appear on same row within the range
CRITERIA 1 | CRITERIA 2
4 | b
8 | b
7 | b
8 | b
1 | b
Spreadsheet: 698079d1601729161-accumulated-numbers-are-generated-by-four-conditions-help-1003
Sheet: Sheet2

Start | 1 | End | 12 | increase a nos. | 2 | increase each time | 2
 | Accumulated numbers are generated by four conditions
 | Formular Starting from J2, the four conditions are B1, D1, F1, H1
 | J2 cell how to write the formula down
 | B1 is starting first number
 | D1 is Ending number
 | F1 increase a nnumbers
 | H1 increase each time
Spreadsheet: 825049d1681079151-exclude-data-in-hidden-columns-max-weekly-history
Sheet: Max Weekly History

 | Hide | Hide |  |  |  | Hide |  |  |  | Subtoal is not working
 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | Average | [NAME]
January |  | 13233 | 18452 | 19680 | 17116 | 20057 | 14686 | 22123 | 21873
February |  | 14313 | 18349 | 23201 | 18748 | 25222 | 16415 | 25552 | 21405
March |  |  | 2985 | 18239 | 21288 | 23740 | 19442 | 25408 | 19795
April |  | 9654 | 20663 | 21242 | 21606 |  | 17455 | 29419 | 18390
May |  |  | 9352 | 19960 | 22784 |  | 19807 | 21765
June |  | 13424 | 23641 | 19838 | 18177 |  | 20825 | 26414
July |  | 2842 | 24023 | 18444 | 19010 |  | 22693 | 23504
August |  | 16090 | 21851 | 18371 | 21742 | 15875 | 23989 | 26046
September |  |  | 23335 | 22760 | 22080 | 16808 | 24765 | 22784
October | 4628 | 16987 | 20848 | 18539 | 21922 | 14112 | 6828 | 26938
November | 11504 | 16059 | 22338 | 16328 | 25503 | 15988 | 7044 | 24686
December |  |  | 19893 | 17895 | 25880 | 14490 | 7595 | 29300
 |  | I would like to hide Rows 2015, 2016 and 2020 to see the new Average and [NAME] values in colums K and L respectively.
Spreadsheet: 5337db58-643b-4fa3-81a6-60f5c828ff19
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8601 | 14169 | Team I | United States | USA | 0 | 4th Position | 00:00:00 | 6th Position | 00:00:00 | 15th Position | 1 | 25 Points
8601 | 14038 | Team I | Japan | JPN | 0 | 2nd Position | 00:00:00 | 7th Position | 00:00:00 | 25th Position | 2 | 34 Points
8601 | 11827 | Team I | Poland | POL | 0 | 10th Position | 00:00:00 | 13th Position | 00:00:00 | 14th Position | 3 | 37 Points
8601 | 11573 | Team I | Czech Republic | CZE | 0 | 5th Position | 00:00:00 | 19th Position | 00:00:00 | 26th Position | 4 | 50 Points
8601 | 14104 | Team I | Canada | CAN | 0 | 12th Position | 00:00:00 | 18th Position | 00:00:00 | 20th Position | 5 | 50 Points
8601 | 14100 | Team I | Singapore | SIN | 0 | 35th Position | 00:00:00 | 36th Position | 00:00:00 | 37th Position | 6 | 108 Points
Spreadsheet: 215211d1361306175-find-lowest-value-in-corresponding-cells-on-multiple-worksheets-return-value-and-location-book1
Sheet: Trial 2

 | Val A | Val B
 | 8 | 6
 | 4 | 8
 | 8 | 4
 | 9 | 7
 | 9 | 5
 | 6 | 5
 | 10 | 10
 | 9 | 3
 | 8 | 2
Spreadsheet: 117263d1312588148-using-and-to-check-2-conditions-conditionals
Sheet: data

dates | district | location | sublocation | species | livecount | carcass count | visibility | area surveyed | accuracy | observer
2011-06-21 00:00:00 | Southern | Blue Volvo | Bay | diesel | 502 | 45 | excellent | completely | yes | [NAME]
2011-06-21 00:00:00 |  | Red Citroen |  | electric | 581 | 67
2011-06-23 00:00:00 |  | [NAME] |  | gasoline | 887 | 6
2011-06-23 00:00:00 |  | [NAME] |  | diesel | 799 | 92
2011-06-23 00:00:00 |  | Silver Toyota |  | electric | 673 | 14
2011-06-23 00:00:00 |  | [NAME] |  | diesel | 928 | 68
2011-06-28 00:00:00 |  | Blue Volvo |  | corn oil | 496 | 98
2011-06-28 00:00:00 |  | Red Citroen |  | electric | 381 | 86
2011-06-28 00:00:00 |  | [NAME] |  | electric | 116 | 23
2011-06-28 00:00:00 |  | [NAME] |  | diesel | 525 | 18
2011-07-02 00:00:00 |  | [NAME] |  | electric | 961 | 19
2011-07-02 00:00:00 |  | Silver Toyota |  | electric | 522 | 82
2011-07-02 00:00:00 |  | [NAME] |  | diesel | 148 | 16
2011-07-02 00:00:00 |  | [NAME] |  | corn oil | 562 | 27
2011-07-03 00:00:00 |  | [NAME] |  | diesel | 783 | 50
2011-07-03 00:00:00 |  | Blue Volvo |  | gasoline | 934 | 53
2011-07-12 00:00:00 |  | [NAME] |  | electric | 156 | 21
2011-07-30 00:00:00 |  | Red Citroen |  | diesel | 206 | 55
2011-08-02 00:00:00 |  | [NAME] |  | corn oil | 925 | 1
2011-08-03 00:00:00 |  | Silver Toyota |  | gasoline | 685 | 1
2011-08-05 00:00:00 |  | [NAME] |  | diesel | 705 | 47
2011-08-09 00:00:00 |  | Blue Volvo |  | diesel | 863 | 76
2011-08-10 00:00:00 |  | [NAME] |  | electric | 147 | 63
2011-08-11 00:00:00 |  | [NAME] |  | electric | 241 | 69
2011-08-16 00:00:00 |  | [NAME] |  | diesel | 870 | 35
2011-08-21 00:00:00 |  | [NAME] |  | electric | 950 | 1
2011-08-22 00:00:00 |  | Silver Toyota |  | gasoline | 426 | 57
2011-08-23 00:00:00 |  | [NAME] |  | corn oil | 975 | 86
2011-08-29 00:00:00 |  | [NAME] |  | electric | 287 | 44
2011-10-04 00:00:00 |  | [NAME] |  | electric | 903 | 31
2011-10-10 00:00:00 |  | Blue Volvo |  | electric | 483 | 46
2011-10-19 00:00:00 |  | [NAME] |  | corn oil | 218 | 57
2011-10-21 00:00:00 |  | Red Citroen |  | diesel | 582 | 40
Spreadsheet: darrell_schoolcraft__7608__imball0201
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 41789 | 35858 | 30108 | 32000
2 | 37927 | 35858 | 30887 | 32000 |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 32549 | 35858 | 32901 | 32000 |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 30654 | 35620 | 34690 | 31782 |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 | 33190 | 33700 | 30637 | 30158 |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 |  |  |  |  |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
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
2001-12-31 00:00:00 |  |  |  |  | 460431.19
2002-01-05 00:00:00
CBS Volume
 |  |  | 41311
Spreadsheet: 86999d1286921932-conditional-counting-example
Sheet: Sheet1

Edition | Top 50
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 0
AS | 1
AS | 1
AS | 0
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 0
AS | 1
AS | 1
AS | 1
AS | 0
AS | 1
AS | 1
AS | 0
AS | 0
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 1
AS | 0
AS | 1
AS | 1
AS | 1
AS | 0
AS | 1
AS | 1
AS | 1
AS | 1
AS | 0
AS | 1
AS | 1
AS | 1
AS | 0
AS | 1
AS | 0
AS | 0
AS | 0
AS | 1
AS | 1
AS | 0
AS | 0
AS | 0
DE | 0
DE | 0
DE | 1
DE | 0
DE | 1
DE | 1
DE | 1
DE | 0
DE | 1
DE | 1
DE | 1
DE | 1
DE | 1
DE | 0
DE | 1
DE | 0
DE | 1
DE | 0
DE | 0
DE | 1
DE | 0
DE | 1
DE | 1
DE | 1
DE | 0
DE | 0
DE | 0
DE | 0
DE | 1
DE | 1
DE | 1
DE | 0
DE | 0
DE | 1
DE | 0
DE | 1
DE | 1
DE | 1
DE | 0
DE | 0
DE | 0
DE | 0
DE | 0
DE | 1
DE | 0
DE | 1
DE | 1
DE | 1
DE | 1
DE | 0
DE | 0
DE | 0
DE | 1
DE | 1
DE | 0
DE | 0
DE | 1
DE | 0
DE | 0
DE | 0
DE | 1
DE | 0
DE | 1
DE | 0
DE | 1
DE | 0
DE | 0
DE | 0
DE | 1
DE | 0
DE | 0
DE | 0
DE | 0
DE | 1
DE | 0
DE | 0
DE | 0
DE | 0
DE | 1
DE | 0
DE | 1
DE | 0
DE | 1
DE | 1
DE | 1
DE | 0
DE | 0
DE | 1
DE | 1
DE | 1
DE | 0
DE | 1
DE | 1
DE | 0
DE | 1
DE | 0
DE | 0
DE | 1
DE | 0
DE | 1
DE | 1
DE | 1
DE | 0
DE | 0
EU | 0
EU | 0
EU | 0
EU | 1
EU | 0
EU | 1
EU | 0
EU | 0
EU | 0
EU | 1
EU | 1
EU | 1
EU | 1
EU | 0
EU | 0
EU | 0
EU | 1
EU | 1
EU | 1
EU | 1
EU | 1
EU | 0
EU | 0
EU | 1
EU | 1
EU | 1
EU | 0
EU | 0
EU | 0
EU | 0
EU | 1
EU | 1
EU | 1
EU | 1
EU | 1
EU | 1
EU | 0
EU | 0
EU | 1
EU | 0
EU | 0
EU | 1
EU | 0
EU | 1
Spreadsheet: 07d2e1d2-b3eb-4ceb-b067-8c1598c75294
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
 | Resumen de Costos Anuales por Componente y Subcomponente
Componente | Sub-Componente | Area | Tipo de Costo | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | TOTAL COSTO | TOTAL AREA | TOTAL SUBCOMPONENTE | TOTAL COMPONENTE
[NAME] | Creación y Consolidación | Marino | Inversión | 500 | 273635 | 264210 | 30575 | 0 | 0 | 568920 | 728920 | 1017000 | 1017000
 |  |  | Recurrente | 0 | 0 | 40000 | 40000 | 40000 | 40000 | 160000
 |  | Terrestre | Inversión | 48000 | 103130 | 103540 | 31540 | 1870 | 0 | 288080 | 288080
 |  |  | Recurrente | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Planes de Manejo | Marino | Inversión | 139500 | 186000 | 139500 | 279000 | 232500 | 0 | 976500 | 976500 | 1576500 | 14243600
 |  |  | Recurrente | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Terrestre | Inversión | 225000 | 150000 | 125000 | 0 | 100000 | 0 | 600000 | 600000
 |  |  | Recurrente | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | Marino | Inversión | 10000 | 0 | 0 | 0 | 0 | 0 | 10000 | 31000 | 324600
 |  |  | Recurrente | 0 | 4200 | 4200 | 4200 | 4200 | 4200 | 21000
 |  | Terrestre | Inversión | 41000 | 0 | 0 | 11000 | 0 | 0 | 52000 | 293600
 |  |  | Recurrente | 11200 | 35200 | 48800 | 48800 | 48800 | 48800 | 241600
 | Mejorar el Manejo | Marino | Inversión | 0 | 14000 | 0 | 0 | 0 | 0 | 14000 | 1928000 | 4445500
 |  |  | Recurrente | 0 | 0 | 478500 | 478500 | 478500 | 478500 | 1914000
 |  | Terrestre | Inversión | 15000 | 0 | 0 | 0 | 0 | 0 | 15000 | 2517500
 |  |  | Recurrente | 0 | 500500 | 500500 | 500500 | 500500 | 500500 | 2502500
 | Control y Protección | Marino | Inversión | 0 | 0 | 60000 | 50000 | 0 | 0 | 110000 | 2890000 | 3052000
 |  |  | Recurrente | 0 | 508000 | 508000 | 588000 | 588000 | 588000 | 2780000
 |  | Terrestre | Inversión | 0 | 72000 | 40000 | 40000 | 10000 | 0 | 162000 | 162000
 |  |  | Recurrente | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Equipos e infraestructura | Marino | Inversión | 0 | 0 | 0 | 2200000 | 1700000 | 945000 | 4845000 | 4845000 | 4845000
 |  |  | Recurrente | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Terrestre | Inversión | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Recurrente | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  |  | Inversión | 96500 | 135500 | 127000 | 0 | 0 | 0 | 359000 | 359000 | 359000 | 359000
 |  |  | Recurrente | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  |  | Inversión |  |  |  |  |  |  | 0 | 2400000 | 2400000 | 2400000
 |  |  | Recurrente | 400000 | 400000 | 400000 | 400000 | 400000 | 400000 | 2400000
 |  | TOTAL SIN ASOCIACION | Inversión | 575500 | 934265 | 859250 | 2642115 | 2044370 | 945000 | 8000500 | 15619600 | 15619600 | 15619600
 |  |  | Recurrente | 11200 | 1047900 | 1580000 | 1660000 | 1660000 | 1660000 | 7619100
 |  | TOTAL CON ASOCIACION | Inversión | 575500 | 934265 | 859250 | 2642115 | 2044370 | 945000 | 8000500 | 18019600 | 18019600 | 18019600
 |  |  | Recurrente | 411200 | 1447900 | 1980000 | 2060000 | 2060000 | 2060000 | 10019100