tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1198__Calpine version 3
Sheet: IDC

IDC CALCULATIONS
Total Construction & Other Costs (000$):
No. of Construction Months:
Interest During Construction:
 |  | Annual | Daily (360-Day)
 |  |  | Turbine Cost | Construction &
IDC Calculations |  |  | including [NAME] | Other Cost | Principal | Balance | Interest | Cum. Interest
Month | Date | % Drawn | (000$) | (000$) | (000$) | (000$) | (000$) | (000$)
1 | 2000-04-01 00:00:00 |  |  |  |  |  | 0 | 0
 | 2000-05-01 00:00:00 |  | 0
 | 2000-06-01 00:00:00 |  | 0
 | 2000-07-01 00:00:00 |  | 0
 | 2000-08-01 00:00:00 |  | 0
 | 2000-09-01 00:00:00 |  | 0
 | 2000-10-01 00:00:00 |  | 0
 | 2000-11-01 00:00:00 |  | 0
 | 2000-12-01 00:00:00 |  | 0
 | 2001-01-01 00:00:00 |  | 0
 | 2001-02-01 00:00:00 |  | 0
 | 2001-03-01 00:00:00 |  | 0
 | 2001-04-01 00:00:00 |  | 0
 | 2001-05-01 00:00:00 |  | 0
 | 2001-06-01 00:00:00 |  | 0
 | 2001-07-01 00:00:00 | 0 | 0
 | 2001-08-01 00:00:00 | 0 | 0
 | 2001-09-01 00:00:00 | 0 | 0
 | 2001-10-01 00:00:00 | 0 | 0
TURBINE DELIVERY SCHEDULE
 |  |  |  |  | *Rough Estimate by [NAME]. Please double-check for deal specific
 |  |  |  |  |  | Turbine No. | 2 | 3 | 4 | 5 | 6
Unit | Turbines | Delivery | LD'S |  | Month | No. of Months | 7 | 7.5 | 8 | 8.5 | 9
Number | Delivered | Schedule | Enforced On |  | 1 |  | 0.1 | 0.1 | 0.12 | 0.1 | 0.1
1-3 | 3 | 2000-07-30 00:00:00 | 2000-10-30 00:00:00 |  | 2 |  | 0.04 | 0.04 | 0.12 | 0.04 | 0.04
4-6 | 3 | 2000-08-30 00:00:00 | 2000-10-30 00:00:00 |  | 3 |  | 0.08 | 0.08 | 0.1 | 0.08 | 0.08
7-8 | 2 | 2000-09-30 00:00:00 | 2000-10-30 00:00:00 |  | 4 |  | 0.12 | 0.12 | 0.13 | 0.1 | 0.1
9-11 | 3 | 2000-10-30 00:00:00 | 2000-10-30 00:00:00 |  | 5 |  | 0.12 | 0.12 | 0.13 | 0.11 | 0.1
12-13 | 2 | 2000-11-30 00:00:00 | 2000-11-30 00:00:00 |  | 6 |  | 0.12 | 0.12 | 0.11 | 0.11 | 0.1
14-15 | 2 | 2000-12-30 00:00:00 | 2000-12-30 00:00:00 |  | 7 |  | 0.1 | 0.1 | 0.14 | 0.1 | 0.08
16-18 | 3 | 2000-01-30 00:00:00 | 2000-01-30 00:00:00 |  | 8 |  | 0.08 | 0.08 | 0.15 | 0.08 | 0.08
19-20 | 2 | 2001-02-28 00:00:00 | 2001-02-28 00:00:00 |  | 9 |  | 0.06 | 0.06 | 0 | 0.06 | 0.06
21-22 | 2 | 2001-03-30 00:00:00 | 2001-03-30 00:00:00 |  | 10 |  | 0.06 | 0.06 | 0 | 0.06 | 0.06
23-24 | 2 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 |  | 11 |  | 0.03 | 0.03 | 0 | 0.03 | 0.03
 |  |  |  |  | 12 |  | 0.04 | 0.04 | 0 | 0.04 | 0.04
 |  |  |  |  | 13 |  | 0.05 | 0.05 | 0 | 0.04 | 0.04
Summary (000$): |  |  |  |  | 14 |  | 0 | 0 | 0 | 0.05 | 0.04
Basis Per Turbine |  |  | 13950 |  | 15 |  | 0 | 0 | 0 | 0 | 0.05
Carry Cost Per Turbine |  |  | 289.6162739983738 |  | Sum
WestLB Structuring, Restructuring & Legal Fees |  |  | 20.83333333333331
Total Price
Spreadsheet: 06eb42e2-c194-4f90-bb77-ad87f4e5e286
Sheet: Sheet1

Unnamed: 0 | Apache District Committee - 2011-2012 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Position | Name | Work | Home | eMail
District Chairman | [NAME] | [PHONE] | [PHONE] | [EMAIL]
Past District Chairman | [NAME] | [PHONE] | [PHONE] | [EMAIL]
District Commissioner | [NAME] | [PHONE] | [PHONE] | [EMAIL]
District Director | [NAME] | [PHONE] |  | [EMAIL]
Senior District Executive | [NAME] | [PHONE] |  | [EMAIL]
Program Chairman | Open
Activities Chairman | Lon Nigro |  | [PHONE] | [EMAIL]
Popcorn Chairman | [NAME] | [PHONE] | [PHONE] | [EMAIL]
Scouting For Food Chairman | [NAME] | [PHONE] | [PHONE] | [EMAIL]
Cub Scout Day Camp Director | [NAME] |  | [PHONE] | [EMAIL]
Cub Scout Day Camp Program Director | [NAME] |  | [PHONE] | [EMAIL]
Boy Scout Camporee Chairman | Open
Cub-O-Ree Chairman | Open
Advancement Chairman | [NAME] |  | [PHONE] | [EMAIL]
Camping Chairman | [NAME] | [PHONE] | [PHONE] | [EMAIL]
Training Chairman | [NAME] | [PHONE] |  | [EMAIL]
Membership Chairman | [NAME] | [PHONE] | [PHONE] | [EMAIL]
Fall Round-up Chairman | [NAME] |  | [PHONE] | [EMAIL]
Marketing Chairman | Trainor Critz | [PHONE] |  | [EMAIL]
[NAME] | [NAME] | [PHONE] | [PHONE] | [EMAIL]
Finance Chairman | [NAME] | [PHONE] |  | [EMAIL]
Patron Chairman | [NAME] | [PHONE] | [PHONE] | [EMAIL]
Leadership Dinner Chairman | [NAME] | [PHONE] | [PHONE] | [EMAIL]
Family Friends of Scouting Chairman | [NAME] | [PHONE] |  | [EMAIL]
Community FOS Chairman | [NAME] | [PHONE] | [PHONE] | [EMAIL]
OA Chapter Advisor | [NAME] | [PHONE] |  | [EMAIL]
Communications Chairman | [NAME] | [PHONE] | [PHONE] | [EMAIL]
Nominating Committee Chairman | Open
Updated 5/13/2011
Spreadsheet: 853375d1703245502-master-sheet-that-edits-child-sheets-employee-tracker
Sheet: BLANK EMPLOYEE

 | Employee Name
 | Games Master
 | Lateness |  |  |  |  | [NAME] |  |  |  |  |  | Property Log
 | Date | Late by | Type | Addressed By |  | Total Minor |  | Training |  |  |  | Item | Quantity
 |  |  |  |  |  | Total Major |  |  |  |  |  | Uniform - Black T-Shirt
 |  |  |  |  |  | Total Absence |  |  |  |  |  | Keys etc |  |  |  | Informal Verbal
 |  |  |  |  |  | Total Sickness |  |  |  |  |  |  |  |  |  | Formal Verbal
 |  |  |  |  |  | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  | Written
 |  |  |  |  |  | Phone | [PHONE] |  |  |  |  |  |  |  |  | Final Written
 |  |  |  |  |  | Birthday | 2000-01-01 00:00:00 | Age |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | //Base Pay field uses this with Overview Pay Rates to calculate correct rate automatically.
 |  |  |  |  |  | Start Date | 2000-01-01 00:00:00 | Tenure
 |  |  |  |  |  | Employee ID | ###
 |  |  |  |  |  | Base Pay
 |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Next of Kin | Name |  | (Relationship)
 |  |  |  |  |  |  | Contact
 |  |  |  |  |  | Disciplinary Record
 |  |  |  |  |  | Date | Type |  | In Attendance |  | Notes
Spreadsheet: 69191d1269705411-find-4-consecutive-occurrences-find-four-consecutive-occurences
Sheet: Sheet1

Satus | Yes
Date | 2010-03-01 00:00:00 | 2010-03-02 00:00:00 | 2010-03-03 00:00:00 | 2010-03-04 00:00:00 | 2010-03-05 00:00:00 | 2010-03-06 00:00:00 | 2010-03-07 00:00:00 | 2010-03-08 00:00:00
Result | N | Y | N | N | N | N
 |  |  |  | 0 | 0 | 1
Spreadsheet: 170732d1343384572-ranking-formula-help-query4
Sheet: Sheet1

 | RM_Code
MCC_Code | R05 | R10 | R12 | R13 | R14 | MCC Description
5621
5655
5712
5968
5999
6010
6012
6211
6300
7399
7941
7997
8675
8999
0742
4722
5065
5192
5211
5271
5411
5499
5511
5611
5651
5691
5712
5714
5732
5812
5940
5941
5944
5968
5999
6300
7011
7299
8021
8071
8999
0742
1520
1799
3716
4722
5045
5065
5072
5074
5211
5251
5261
5411
5499
5511
5521
5532
5533
5571
5599
5611
5621
5691
5712
5713
5714
5719
5722
5732
5733
5812
5813
5933
5941
5942
5944
5946
5947
5948
5949
5964
5970
5971
5977
5983
5995
5999
6012
6300
7011
7033
7230
7299
7399
7531
7538
7629
7922
7941
7991
7997
8062
8220
8351
8699
8911
8999
0742
4111
4121
4131
4214
4722
4816
5211
5251
5511
5521
5533
5599
5621
5699
5712
5719
5812
5813
5943
5944
5947
5968
5999
6051
6300
7011
7230
7299
7399
7538
7922
7997
8220
0742
4722
5065
5211
5251
5261
5441
5499
5511
5533
5571
5621
5655
5691
5712
5713
5722
5812
5813
5814
5921
5932
5940
5941
5942
5944
5945
5968
5971
5992
5995
5999
6300
7011
7230
7298
7299
7399
7512
7538
7623
7922
7933
7991
7997
8062
8111
8220
8911
8999
9399
Spreadsheet: 96281d1295688437-excel-2007-trying-to-use-data-validation-example-spreadsheet
Sheet: Price List

Part# | Style | Size | Color | Price per
1000 | Shirt | S | Red | 3
1001 | Shirt | S | Blue | 3
1002 | Shirt | S | Green | 3
1003 | Shirt | S | White | 2
1004 | Shirt | S | Black | 3
Spreadsheet: 227246d1365642016-if-a-cell-contains-codes-listed-i-a-column-it-will-show-its-equivalent-description-delivery-order-format
Sheet: LIST OF PRODUCTS

ITEM CODE | [NAME] | LIST PRICE
 |  | CASE | PIECE
LPP150 | LO-PATIS POUCH 48X150ML | 398.1 | 8.293750000000001
LPGG350 | LO-PATIS GGLASS 24X350ML | 407.43 | 16.97625
LPGP350 | LO-PATIS GPLASTIC 24X350ML | 419.11 | 17.46291666666667
LP1L | LO-PATIS LITER 12X1000ML | 549.95 | 45.82916666666667
LPHG | LO-PATIS H.GALLON 6X1892ML | 500.58 | 83.42999999999999
LPG | LO-PATIS GALLON 4X3785ML | 584.01 | 146.0025
LCP370 | LO-CHILI PATIS 24X370ML | 476.51 | 19.85458333333333
LPP200 | LO-PREMIUM PATIS 24X200ML | 912 | 38
LSOGG350 | LO-SOYSAUCE GGLASS 24X350ML | 305 | 12.70833333333333
LSOGP350 | LO-SOYSAUCE GPLASTIC 24X350ML | 335.4 | 13.975
LSO1L | LO-SOYSAUCE LITER 12X1000ML | 388.8 | 32.4
LSUGG350 | LO-SUKA SASA GGLASS 24X350ML | 235.62 | 9.8175
LSUGP350 | LO-SUKA SASA GPLASTIC 24X350ML | 279.93 | 11.66375
LSU1L | LO-SUKA SASA LITER 12X1000ML | 318.78 | 26.565
LSUG | LO-SUKA SASA GALLON 4X3785ML | 356.69 | 89.1725
LBS11 | LO-BALAYAN SAUCE 24X11OZ | 541.2 | 22.55
LBSG11 | LO-BALAYAN SAUCEW/GINGER 24X11OZ | 567.6 | 23.65
LBSGC11 | LO-BALAYAN W/GINGERCHILI 24X11OZ | 594 | 24.75
LAG8 | LO-ALAMANG GUISADO 24X8OZ | 1651.86 | 68.8275
FTCM400 | FILTASTE COCONUT MILK 24X400ML | 1269.6 | 52.9
FTTT8 | FILTASTE TABA TALANGKA 24X8OZ | 2448 | 102
LBP | LORINS BUDGET PACK | 335 | 41.875
Spreadsheet: 172238d1344055919-list-of-expired-members-only-expired-members-listings-01
Sheet: Sheet1

MEMBER LIST | MEMBERSHIP START DATE | Expires next month | Expired
AA | 2012-08-31 00:00:00 |  | Need list of Expired members else let me know the procedure to obtain this.. Is there any reference which can be used ?
BB | 2012-09-22 00:00:00 |  |  | This column show all expird members names
CC | 2012-07-28 00:00:00
DD | 2012-10-05 00:00:00
EE | 2012-07-15 00:00:00 |  | This column shows ONLY members expiring next month
FF | 2012-07-10 00:00:00
GG | 2012-11-07 00:00:00
HH | 2012-07-22 00:00:00
II | 2012-11-24 00:00:00
Spreadsheet: 59757d1260318114-league-spreadsheet-vs2_league_spreadsheet_test
Sheet: Schedule

Schedule
 |  |  |  |  |  |  |  | On the setup Sheet, specify how many pairings happen each week
week | team no | team name | vs | team no | team name |  |  | E.g. 20 teams per week would be 10 pairings
1 | 10 | mauve |  | 1 | Blue |  |  | Then, create that many lines per week
1 | 9 | amber |  | 2 | red_team |  |  | and enter the team numbers in the yellow cells
1 | 8 | chartreuse |  | 3 | yellow |  |  | leave no blank lines.
1 | 7 | pink |  | 4 | green |  |  | use formatting to separate weeks by color
1 | 6 | orange |  | 5 | purple
1 | 5 | purple |  | 6 | orange |  |  | The purple cells have formulas and must be copied down
1 | 4 | green |  | 7 | pink
1 | 3 | yellow |  | 8 | chartreuse |  |  | There should always be the same number of pairings per week
1 | 2 | red_team |  | 9 | amber
1 | 1 | Blue |  | 10 | mauve |  |  | The number of pairings per week must be the same as the number
2 | 9 | amber |  | 10 | mauve |  |  | entered on the Setup Sheet.
2 | 8 | chartreuse |  | 9 | amber
2 | 7 | pink |  | 8 | chartreuse |  |  | color key
2 | 6 | orange |  | 7 | pink |  |  | data entry
2 | 5 | purple |  | 6 | orange |  |  | calculated
2 | 4 | green |  | 5 | purple
2 | 3 | yellow |  | 4 | green
2 | 2 | red_team |  | 2 | red_team
2 | 1 | Blue |  | 3 | yellow
2 | 10 | mauve |  | 2 | red_team
Spreadsheet: daren_farmer__5605__Equistar Activity 092000
Sheet: OCT00

 | EQUISTAR  ACTIVITY for OCTOBER, 2000 |  |  |  |  |  | file name: Equistar Activity 092000.xls
 | Effective 10/1/00
 | Meter # |  | Deal # | Price ($) | Volume | Matrix
 | 1062
 | 1334 |  |  |  | 0
 | 1373 |  |  | Greater of $2.64 or Index - $.03 | 0 | ENA
 | 1373 | ENA | 380735 | 4.35 or Index-$.10 | 9000 | HPLC
 | 1373 |  | 165373 | Greater of $2.15 | 10000 | HPLC
 | 1373 |  | 128806 | Greater of $2.05 or Index - $.055 | 5000 | HPLC
 | 1384 | ENA | 240061 | $2.20 or Index -$.05 | 5000 | HPLC
 | 1399 |  | 165372 | $2.11or Index -$.07 | 5000 | HPLC
 | 1552 |  | 202387 | $2.21 or Index -$.07 | 5000 | HPLC
 | 1552 | ENA | 380735 | 4.35 or Index-$.10 | 0 | HPLC
 | 1552
 | 1553 |  | 380735 | 4.35 or Index-$.10 | 1000 | HPLC
 | 8024 | ENA | 240061 | $2.20 or Index -$.05 | 5000 | HPLC
 | 1266/1165 |  |  |  | 0 | HPLC
 |  |  |  |  |  | Less: Phillips {0.0/d}, [NAME] {15.0/d}
 |  |  |  |  |  | Third Party ( Sempra; 20.0/d )
NOTE:  Highlighted rows mean changes. |  |  |  |  |  | Note:   Channel / Syngas :    = 20.0/d
 |  |  |  |  | Mcnic ;  10.0 HPL & 5.0 ENA
Spreadsheet: 164139d1340656143-pulling-multiple-results-from-one-column-that-correspond-to-a-second-column-book4-nbvc-oeldere-
Sheet: 2010

2010
Spreadsheet: 689708d1596609820-if-function-exceeding-8000-character-limit-need-help-on-shorter-formula-au-and-nz-vendor-margin-analysis-fy20-ytd-test
Sheet: YTD NZ Sales

New Zealand Margin and Sales by Vendor - YTD
Vendor | Sales | Margin $ | Margin %
F5
Tenable
NetApp
MobileIron
Palo Alto Networks
Ribbon
Infoblox
FireEye
Riverbed
Extreme Networks
Arista
AlgoSec
Gigamon
Cylance
Nutanix
Channel Services
ForeScout
Cohesity
CS Vendors
Avaya
Grand Total
Spreadsheet: 727701d1618043601-filtering-data-without-view-changing-for-rest-of-sheet-example
Sheet: Sheet1

Name | Company | Department | Stationary | Qty
[NAME] | Company 1 | [NAME] | Pens | 12
[NAME] | Company 1 | Sales | Pens | 5 |  |  | Companies Trading With
[NAME] | Company 2 | Sales | Pens | 3
[NAME] | Compnay 3 | Recruitment | Pens | 2
[NAME] | Company 4 | Finance | Pens | 5 |  |  |  |  | Pens
[NAME] | Company 1 | [NAME] | Books | 65 |  |  |  |  | Books
[NAME] | Company 1 | Sales | Books | 3 |  |  |  |  | Pencils
[NAME] | Company 2 | Sales | Books | 4 |  |  |  |  | [NAME]
[NAME] | Compnay 3 | Recruitment | Books | 2 |  |  |  |  | Drawing Pins
[NAME] | Company 4 | Finance | Books | 1 |  |  |  |  | Post Its
[NAME] | Company 1 | [NAME] | Pencils | 4 |  |  |  |  | Erasers
[NAME] | Company 1 | Sales | Pencils | 6
[NAME] | Company 2 | Sales | Pencils | 3
[NAME] | Compnay 3 | Recruitment | Pencils | 1
[NAME] | Company 4 | Finance | Pencils | 1
[NAME] | Company 1 | [NAME] | [NAME] | 1
[NAME] | Company 1 | Sales | [NAME] | 1
[NAME] | Company 2 | Sales | [NAME] | 88
[NAME] | Compnay 3 | Recruitment | [NAME] | 65
[NAME] | Company 4 | Finance | [NAME] | 43
[NAME] | Company 1 | [NAME] | Drawing Pins | 3
[NAME] | Company 1 | Sales | Drawing Pins | 3
[NAME] | Company 2 | Sales | Drawing Pins | 5
[NAME] | Compnay 3 | Recruitment | Drawing Pins | 756
[NAME] | Company 4 | Finance | Drawing Pins | 7
[NAME] | Company 1 | [NAME] | Post Its | 8
[NAME] | Company 1 | Sales | Post Its | 9
[NAME] | Company 2 | Sales | Post Its | 2
[NAME] | Compnay 3 | Recruitment | Post Its | 7
[NAME] | Company 4 | Finance | Post Its | 3
[NAME] | Company 1 | [NAME] | Erasers | 2
[NAME] | Company 1 | Sales | Erasers | 7
[NAME] | Company 2 | Sales | Erasers | 2
[NAME] | Compnay 3 | Recruitment | Erasers | 2
[NAME] | Company 4 | Finance | Erasers | 2
Spreadsheet: ad4f4b2f-f0d6-4294-a9df-ad0a56338701
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
5427 | 9955 | [NAME] | Bethaz | ITA | 0 | 00:15:33 | 00:00:36 | 00:15:32 | 00:01:03 | 00:18:13 | 1 | 00:50:59
5427 | 10264 | Ivo | [NAME] | CZE | 116 | 00:16:24 | 00:00:43 | 00:15:41 | 00:01:02 | 00:17:55 | 2 | 00:51:44
5427 | 7722 | Philip E.c. | Schadler | LIE | 120 | 00:18:54 | 00:01:10 | 00:18:25 | 00:01:06 | 00:20:06 | 3 | 00:59:42
5427 | 14202 | [NAME] | Gudalov | RUS | 115 | 00:18:54 | 00:01:06 | 00:18:35 | 00:01:37 | 00:20:42 | 4 | 01:00:55
5427 | 39392 | Stephen | Gray | GBR | 117 | 00:19:16 | 00:01:03 | [NAME] | 00:02:09 | 00:36:07 | 5 | 01:18:12
Spreadsheet: larry_campbell__21439__TSC Calculator 2000 11
Sheet: Calculator

 |  |  |  | Volume | 57
Generator | NYISO_LBMP_REFERENCE
Bus_Name | PJM_LOAD_KEYSTONE
Data | TO_Name | TO_TSC_Rate_$/Mwhr | Total | Rate | Volume
Sum of TSC_Cost_$/Mwhr | CONSOLIDATED EDISON | 5.58 | 2.8556
 | NEW YORK STATE ELECTRIC AND GAS | 0 | 0
 | NIAGARA MOHAWK | 2.732 | 0.3757
 | NYPA | 1.78 | 0.3403
Sum of Resultant_Dfax | CONSOLIDATED EDISON | 5.58 | -0.4923
 | NEW YORK STATE ELECTRIC AND GAS | 0 | -0.232
 | NIAGARA MOHAWK | 2.732 | -0.0844
 | NYPA | 1.78 | -0.1913
Total Sum of TSC_Cost_$/Mwhr |  |  | 3.5716
Total Sum of Resultant_Dfax |  |  | -1
Spreadsheet: michelle_lokay__26805__imbalsumm
Sheet: summary

Index is high - payback should be done on Dollar Valued payables
- payback should be done on Volumetric receivable
- payback should not be done on Dollar valued receivables
- payback should not be done on Volumetric payables
Positive = due [NAME]
Negative = due operator
 | Dollars | Volume | As of Date
 |  |  |  |  |  |  | Index Price
Duke - Crawford* |  |  |  | Dollar Valued |  |  | SJ
NNG |  |  |  | Dollar Valued |  |  | AVG
El Paso |  |  |  | Volumetric
Northwest |  |  |  | Volumetric
[NAME] |  |  |  | Volumetric
SoCal |  |  |  | Volumetric |  |  |  |  |  |  |  | 72.5
Conoco |  |  |  | Dollar Valued |  |  |  |  |  |  | 720 | 15.25
Amoco |  |  |  | Volumetric
Due Operators
PG&E TX |  |  |  | Dollar Valued
PG&E |  |  |  | Volumetric
Lonestar |  |  |  | Volumetric
Duke - Pyote* |  |  |  | Dollar Valued
Duke - Pecos Diamond* |  |  |  | Dollar Valued
Amoco Abo |  |  |  | Dollar Valued
Oasis |  |  |  | Volumetric
Westar Ward |  |  |  | Dollar Valued
Mewborne |  |  |  | Dollar Valued
TransColorado |  |  |  | Dollar Valued
Agave |  |  |  | Dollar Valued
NGPL |  |  |  | Volumetric
PNM |  |  |  | Dollar Valued
Red Cedar |  |  |  | Dollar Valued
Due TW
Total Net Due / (Owed)
* Net Duke =
Spreadsheet: 798101d1664299932-sumifs-with-days-since-entered-date-sumif-example-1-
Sheet: Sheet1

 | [NAME]
 | Statement Date: | 2022-08-31 00:00:00
 |  | 1-30 Days | 31-60 Days | 60-90 Days | 90+ Days | Subtotal | Deposits | Total Dues
 | [NAME]
 | Bermuda
 | Bermuda Clean Ups
 | Sudan
 | Wheat Straw
 | Totals:
2022 ALFALFA HAY
Stack # | Baled  Date | Small bales | Big bales | Est Bale Weight | [NAME] | Price | Company |  | Date sold | Estimated Amount due | Days
1 | 2022-01-03 00:00:00 | 999 |  | 120 |  | 260 | [NAME] |  | 2022-02-07 00:00:00
2 | 2022-03-30 00:00:00 | 3059 |  | 120 |  | 367 | [NAME] |  | 2022-03-29 00:00:00
3 | 2022-04-06 00:00:00 | 933 |  | 120 |  | 367 | [NAME] |  | 2022-04-06 00:00:00
4 | 2022-04-06 00:00:00 | 2000 |  | 120 |  | 370 | [NAME] |  | 2022-04-06 00:00:00
5 | 2022-04-06 00:00:00 | 1842 |  | 120 |  | 370 | [NAME] |  | 2022-04-06 00:00:00
6 | 2022-04-16 00:00:00 | 1893 |  | 120 |  | 370 | [NAME] |  | 2022-04-19 00:00:00
7 | 2022-05-07 00:00:00 |  | 320 | 1600 |  | 355 | [NAME] |  | 2022-08-08 00:00:00
8 | 2022-05-12 00:00:00 |  | 68 | 1600 |  | 375 | [NAME] |  | 2022-05-12 00:00:00
9 | 2022-05-13 00:00:00 | 2144 |  | 95 |  | 375 | [NAME] |  | 2022-05-13 00:00:00
Spreadsheet: 819154d1677248749-auto-calculation-formula-help-excel-forum-sample-ot
Sheet: Sheet1

DATA |  |  |  |  | This information will be hidden, as the President does not want anyone seeing this top level of info showing individual salary.  Is there a way to take the information in this first set of data to automatically populate down below by using a drop box solution?  More information below
Name | Salary | OT Hourly Rate | Effective
[NAME] |  |  | 2023-01-01 00:00:00
[NAME] | 50000 |  | 2023-01-01 00:00:00
[NAME] | 75000 |  | 2023-01-01 00:00:00
[NAME] | 87000 |  | 2023-01-01 00:00:00
[NAME] | 82000 |  | 2023-01-01 00:00:00
STANDARD | OVERNIGHT | 25 | 2023-01-01 00:00:00
DATA
Week Beginning | Name | OT Hours | OT Payment | # [NAME] | ON Amount | Total | Payout Date | Comments
2023-02-13 00:00:00 | [NAME] | 5 |  | 5 |  |  | [NAME] | [NAME]
2023-02-13 00:00:00 | [NAME]
2023-02-13 00:00:00 | [NAME]
Spreadsheet: 2d1e9608-c593-498c-83f5-d2a2dbc75145
Sheet: Sheet1

 |  |  |  |  | Week 3    December 8-14
 |  |  |  |  | Team Name
Points per 30 minutes | Activity | (Member) | (Member) | (Member) | (Member) | (Member) | Team Total
3 | High Cardio (Spinning, RIPPED, TRX, Running)
2 | Medium Cardio (Zumba, Elliptical,  Stationary Bike, Jogging)
2 | [NAME]
2 | [NAME] (Chisel & Sculpt, Gravity)
1 | Flexibility (Yoga, [NAME], Stretching)
2 | Outside Work  hard (Scraping Ice, [NAME])
1 | Outside Work medium (Walking Dog, Walking)
 | Bonus Points
2 | Ate at three balanced meals a day
1 | Went to bed at a decent time
-1 | Gave in and had fast food for lunch
 |  |  |  |  |  | Week Total
 |  |  |  | Number of Team Members |  |  | 0
 |  | Weekly Total Divided by Number of Team Members
Spreadsheet: 78781d1279105095-progress-meter-in-excel-2007-gradedformatting2007
Sheet: Sheet1

Target | Achieved | Percent Attained | Progress Indicator
10 | 1
10 | 2
10 | 3
10 | 4
10 | 5
10 | 6
10 | 7
10 | 8
10 | 9
10 | 10
5 | 1
3 | 2
Spreadsheet: 770002d1645777646-formula-for-percentage-value
Sheet: Sheet1

 | Value | % | Tax1 | Tax2 | Tax3
 | 98397.59 |  | 0 | 0 | 17711.57
 | 34536.5 |  | 3108 | 3108 | 0
 | 77028.41 |  | 0 | 0 | 13865.11
 | 9674.2 |  | 871 | 871 | 0
Spreadsheet: eric_saibi__9833__100201R
Sheet: Helms 02

Owner Name |  | Pacific Gas & Electric
Station Name |  | [NAME]
Unit Name |  | Hydro 02
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Hydro
Capacity |  | 404 MW
Start Date |  | 2001-10-02 00:00:00
End Date |  | 2002-02-02 00:00:00
Prv. Start Date |  | 2001-11-28 00:00:00
Prv. End Date |  | 2002-02-28 00:00:00
Comments |  | [NAME]
SIC |  | 4911
Plant ID |  | 1033602
Unit ID |  | 1009755
Outage ID |  | 9429
Spreadsheet: 682080d1591894887-deriving-result-from-multiple-data-points-across-multiple-ranges-ice-sheet
Sheet: Sheet1

ICE Worksheet - TxDOT Pour
 |  |  |  |  |  |  |  |  |  |  |  |  | 50lbs of ice= 6 gallons of water
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Cool Off Temp by 10 Degrees |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 4 | 5 | 6 | 7 | 8 | 10
 |  |  |  |  |  |  |  |  |  |  | Temp Reduction |  | 2 | 24 | 47 | 57 | 67 | 77 | 94 | 114
50lbs of ice is 6 gallons of water |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 54 | 94 | 114 | 134 | 154 | 188 | 228
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 68 | 118 | 143 | 163 | 183 | 236 | 276
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 135 | 235 | 285 | 335 | 385 | 470 | 570
Ice | 35lb [NAME] |  |  |  |  |  |  |  |  |  |  |  | 15 | 203 | 353 | 428 | 503 | 578 | 706 | 856
Laborers | 2ea @ $17/hr each |  |  |  |  | 350 | Yardage Being Poured |  |  |  |  |  | 20 | 270 | 470 | 570 | 670 | 770 | 940 | 1040
 |  |  |  |  |  | 13 | Gallons of Batch Water per Yard
 |  |  |  |  |  | 10 | Temperature Reduction
 |  |  |  |  |  | 10 | Total Yards per Truck
 |  |  |  |  |  |  | Total [NAME]
 |  |  |  |  |  |  | Total Pounds Ice Req'd
 |  |  |  |  |  |  | Total [NAME]
 |  |  |  |  |  |  | Total 35# [NAME] per Truck
Spreadsheet: 694639d1599731631-trying-to-create-a-competition-for-the-6-nations-rugby-tournament-prediction-sheet-2021
Sheet: Sheet1

 |  |  |  |  |  | GUINNESS 6 NATIONS 2021
 |  |  |  |  |  | PREDICTION COMPETITION
 | MATCHES |  |  |  |  |  |  |  |  |  |  | 6 NATIONS STANDINGS
 | Match | Date |  | Time |  | MATCH SCORE |  |  | Venue |  |  | Country | P | W | D | L | PD | BP | Pts
 | Week 1 of Matches |  |  |  |  |  |  |  |  |  |  | Italy | 0 | 0 | 0 | 0 |  | 0
 | 1 | Sat, February 6th |  | 17:15:00 | Italy | 3 | 2 | France | [NAME]
 | 2 | Sat, February 6th |  | 18:45:00 | England | 1 | 2 | Scotland | [NAME] |  |  | France | 0 | 0 | 0 | 0 |  | 0
 | 3 | Sun, February 7th |  | 17:00:00 | Wales | 1 | 2 | Ireland | Principality Stadium
 | Week 2 of Matches |  |  |  |  |  |  |  |  |  |  | England | 0 | 0 | 0 | 0 |  | 0
 | 4 | Sat, February 13th |  | 16:15:00 | England | 1 | 2 | Italy | [NAME]
 | 5 | Sat, February 13th |  | 18:45:00 | Scotland | 1 | 2 | Wales | BT Murrayfield |  |  | Scotland | 0 | 0 | 0 | 0 |  | 0
 | 6 | Sun, February 14th |  | 17:00:00 | Ireland | 1 | 2 | France | Aviva Stadium
 | Week 3 of Matches |  |  |  |  |  |  |  |  |  |  | Wales | 0 | 0 | 0 | 0 |  | 0
 | 7 | Sat, February 27th |  | 17:15:00 | Italy | 1 | 2 | Ireland | [NAME]
 | 8 | Sat, February 27th |  | 18:45:00 | Wales | 1 | 2 | England | Principality Stadium |  |  | Ireland | 0 | 0 | 0 | 0 |  | 0
 | 9 | Sun, February 28th |  | 18:00:00 | France | 1 | 2 | Scotland | [NAME]
 | Week 4 of Matches
 | 10 | Sat, March 13th |  | 17:15:00 | Italy | 1 | 2 | Wales | [NAME]
 | 11 | Sat, March 13th |  | 18:45:00 | England | 1 | 2 | France | [NAME]
 | 12 | Sun, March 14th |  | 17:00:00 | Scotland | 1 | 2 | Ireland | BT Murrayfield
 | Week 5 of Matches |  |  |  |  |  |  |  |  |  |  | ENTRANTS NAME :
 | 13 | Sat, March 20th |  | 16:15:00 | Scotland | 1 | 2 | Italy | BT Murrayfield
 | 14 | Sat, March 20th |  | 20:45:00 | Ireland | 1 | 2 | England | Aviva Stadium |  |  | ENTRANTS E-MAIL ADDRESS :
 | 15 | Sat, March 20th |  | 23:00:00 | France | 1 | 2 | Wales | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | SEND ENTRY TO : |  |  |  | [EMAIL]
 |  | Total Tries Scored =