tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 73583d1274218856-sorting-by-score-copy-of-1st-grade-team-math-lip-yearly-progress_1
Sheet: Sheet1

1st Grade MAHT LIP Progress Report 2009-1010
End of Unit Assessments Data Comparison
Teachers: Hilary Hamlett & Kelly Fitzpatrick
Teacher: | Student Name: | Unit 1: Story Problems | Unit 2: Addition | Unit 2: Subtraction | Unit 3: Story Problems | Unit 4: Addition | Unit 4: Subtraction | Unit 5: Geometry
[NAME] | Adriana | --- | --- | --- | --- | 2 | 2 | 3
[NAME] | Aiyana | 3 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] | [NAME] | 3 | 3 | 1 | 2 | 3 | 3 | 3
[NAME] | Ariana | 3 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] | [NAME] | 3 | 2 | 1 | 3 | 2 | 2 | 3
[NAME] | Bradley | 3 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] | Bryanna | 3 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] | [NAME] | 3 | 3 | 1 | 3 | 3 | 3 | 3
[NAME] | Jordan | 3 | 3 | 2 | 3 | 3 | 3 | 3
[NAME] | [NAME] | 2 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] | Kendall | 3 | 1 | 1 | 3 | 3 | 2 | 3
[NAME] | [NAME] | 2 | 1 | 1 | 3 | 2 | 2 | 2
[NAME] | [NAME] | 2 | 3 | 3 | 3 | 2 | 2 | 3
[NAME] | [NAME] | 2 | 3 | 1 | 3 | 3 | 3 | 3
[NAME] | Kylie | 3 | 3 | 1 | 3 | 2 | 3 | 3
[NAME] | Liberty | 3 | 3 | 3 | 3 | 2 | 3 | 3
[NAME] | Lucas | --- | 1 | 1 | 1 | 2 | 2 | 3
[NAME] | Makcenzie | 3 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] | Makayla | 2 | 3 | 2 | 3 | 3 | 3 | 2
[NAME] | [NAME] | 3 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] | [NAME] | 3 | 3 | 3 | 3 | 3 | 2 | ---
[NAME] | Nathan | 3 | 3 | 3 | 2 | 3 | 2 | 3
[NAME] | [NAME] | 3 | 2 | 1 | 3 | 3 | 3 | 3
[NAME] | [NAME] | --- | --- | --- | --- | 2 | 2 | 3
[NAME] | Toby | 3 | 3 | 1 | 3 | 3 | 3 | 2
[NAME] | [NAME] | 3 | 3 | 3 | 3 | 3 | 3 | 3
Fitzpatrick | Adam | 3 | 3 | 1 | 2 | 2 | 2 | 3
Fitzpatrick | Autumn | 3 | 3 | 3 | 3 | 3 | 3 | 3
Fitzpatrick | Caleb | 3 | 3 | 3 | 3 | 3 | 3 | 3
Fitzpatrick | Emma | 3 | 1 | 1 | 3 | 2 | 2 | 2
Fitzpatrick | [NAME] | 3 | 3 | 1 | 3 | 3 | 2 | 3
Fitzpatrick | Gracie | 3 | 3 | 3 | 3 | 3 | 3 | 2
Fitzpatrick | [NAME] | 3 | 3 | 1 | 2 | 2 | 2 | 3
Fitzpatrick | Jessica | 3 | 3 | 3 | 3 | 3 | 3 | 3
Fitzpatrick | Mason | 3 | 1 | 1 | 1 | 2 | 2 | 2
Fitzpatrick | Racheal | 3 | 3 | 3 | 3 | 3 | 3 | 3
Fitzpatrick | Reese | 3 | 3 | 3 | 3 | 3 | 3 | 3
Fitzpatrick | Ricky | 2 | 3 | 3 | 3 | 3 | 3 | 3
Fitzpatrick | Riley | 3 | 2 | 1 | 3 | 3 | 3 | 3
Fitzpatrick | [NAME] | 2 | 1 | 1 | 3 | 3 | 2 | 3
Fitzpatrick | Zach | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | Benchmark
 | Strategic
 | Intensive
Spreadsheet: 33fe5235-14e8-4da6-bcc9-ccc664f79f18
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - Primary Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
2012-09-11 00:00:00 | Governor - Republican
Strafford County | Ovide Lamontagne, r | [NAME], r | [NAME], r | [NAME], d | [NAME], d | [NAME], d | [NAME]
[NAME] | 495 | 203 | 13 | 11 |  | 1 | 2
[NAME] | 127 | 57 | 5 |  | 1 |  | 1
[NAME] | 133 | 61 | 3
[NAME] | 288 | 111 | 5 | 6
[NAME] | 230 | 99 | 3 | 5
[NAME] | 209 | 42 | 0 |  | 1
[NAME] 6 | 179 | 106 | 10 | 1 | 1 |  | 1
[NAME] | 232 | 96 | 6 |  | 2
Farmington | 263 | 127 | 8 | 1 |  |  | 1
[NAME] | 174 | 89 | 5 | 9 | 3 | 2 | 1
Madbury | 82 | 48 | 2 | 3 | 4 | 1
[NAME] | 89 | 73 | 2 | 2
Milton | 216 | 87 | 4 | 6 | 1 | 2 | 1
New Durham | 201 | 83 | 4 |  | 1 |  | 1
Rochester Ward 1 | 268 | 117 | 5 | 4 | 4 |  | 1
[NAME] | 343 | 128 | 2 | 7 | 1 |  | 1
[NAME] 3 | 273 | 92 | 12 | 2 | 2
Rochester Ward 4 | 247 | 78 | 8 |  | 2
Rochester Ward 5 | 260 | 93 | 13 | 8 |  |  | 1
Rochester Ward 6 | 178 | 66 | 9 | 1 |  |  | 1
[NAME] | 122 | 54 | 2 | 1
[NAME] | 87 | 40 | 3 | 2 | 2
[NAME] | 79 | 20 | 1
[NAME] 3 | 73 | 40 | 1 |  | 1
[NAME] | 63 | 35 | 4 |  | 1
[NAME] 5 | 27 | 22 | 1 | 2 |  | 1
Strafford | 271 | 121 | 4 | 3 | 2 | 1
TOTALS | 5209 | 2188 | 135 | 74 | 29 | 8 | 12
Sullivan County | Ovide Lamontagne, r | [NAME], r | [NAME], r | [NAME], d | [NAME], d | [NAME], d | [NAME]
Acworth | 42 | 21 | 1
Charlestown | 136 | 76 | 1 | 1 | 1 |  | 1
Claremont Ward 1 | 113 | 49 | 2 | 2 |  | 1 | 1
Claremont Ward 2 | 227 | 115 | 7 | 2 | 2 |  | 1
Claremont Ward 3 | 140 | 74 | 7 | 2
Cornish | 94 | 32 | 1
Croydon | 58 | 21 |  | 1 |  | 1
Goshen | 59 | 19 | 1 | 2 | 3
Grantham | 189 | 66 | 3 |  |  |  | 1
Langdon | 27 | 29 | 0 | 1
Lempster | 75 | 24 | 2
Newport | 309 | 107 | 5 |  | 1 |  | 1
Plainfield | 80 | 26 | 4 | 1 |  |  | 1
Springfield | 110 | 30 | 0
Sunapee | 339 | 117 | 5
Unity | 71 | 41 | 3 | 1
Washington | 71 | 34 | 1 |  |  |  | 1
TOTALS | 2140 | 881 | 43 | 13 | 7 | 2 | 7
Spreadsheet: 693783d1599147938-excel-formula-for-tax-law-changes-1544-tax-calculations
Sheet: PAYE

 | PAY AS YOU EARN PAYE TABLE |  |  |  |  |  |  |  |  | PAY AS YOU EARN PAYE TABLE
 |  | Month | Period |  |  |  |  |  |  |  | Month | Period
 |  | 2020-01-01 00:00:00 | 1 |  |  |  |  |  |  |  | 2020-08-01 00:00:00 | 8
 |  | $ |  | $ |  | Rates |  | $ |  |  | $ |  | $ |  | Rates |  | $
 | From | 0 | to | 70 | multiply by rate | 0 | Deduct | 0 |  | From | 0 | to | 2000 | multiply by rate | 0 | Deduct | 0
 | From | 70.01 | to | 300 |  | 0.2 |  | 14 |  | From | 2000.01 | to | 4000 |  | 0.2 |  | 14
 | From | 300.01 | to | 1000 |  | 0.25 |  | 29 |  | From | 4000.01 | to | 7000 |  | 0.25 |  | 29
 | From | 1000.01 | to | 2000 |  | 0.3 |  | 79 |  | From | 7000.01 | to | 10000 |  | 0.3 |  | 79
 | From | 2000.01 | to | 3000 |  | 0.35 |  | 179 |  | From | 10000.01 | to | 15000 |  | 0.35 |  | 179
 | From | 3000.01 | and above |  |  | 0.4 |  | 329 |  | From | 15000.01 | and above |  |  | 0.4 |  | 329
I want the tax  formula(D17) to include the month so that when tax changes the formuala keeps working accurate. The current formula does not take care of tax changes in August, insteady of resetting the formula
 | Current |  |  |  | Desired
Period | Name | Salary | Tax |  | Period | Name | Salary | Tax
1 | TOMY | 70 |  |  | 1 | TOMY | 70
1 | CRAIG | 200 |  |  | 1 | CRAIG | 200
1 | YOLANDA | 1500 |  |  | 1 | YOLANDA | 1500
1 | KIMBERLY | 2300 |  |  | 1 | KIMBERLY | 2300
1 | GABRIEL | 3000 |  |  | 1 | GABRIEL | 3000
1 | ASHTON | 3100 |  |  | 1 | ASHTON | 3100
8 | TOMY | 70 |  |  | 8 | TOMY | 70
8 | CRAIG | 200 |  |  | 8 | CRAIG | 200
8 | YOLANDA | 1500 |  |  | 8 | YOLANDA | 1500
8 | KIMBERLY | 2300 |  |  | 8 | KIMBERLY | 2300
8 | GABRIEL | 3000 |  |  | 8 | GABRIEL | 3000
8 | ASHTON | 3100 |  |  | 8 | ASHTON | 3100
Spreadsheet: 69228d1269758259-selectively-sum-values-in-a-table-based-on-a-value-in-a-second-table-summarize-some-data
Sheet: Data

Date | Person | Hours | Cost | Role
2009-05-04 00:00:00 | [NAME] | 3 | 750 |  |  |  |  | Person | Role
2009-05-05 00:00:00 | [NAME] | 4 | 1000 |  |  |  |  | [NAME] | PA
2009-05-06 00:00:00 | [NAME] | 3 | 750 |  |  |  |  | [NAME] | TA
2009-05-07 00:00:00 | [NAME] | 8 | 1600 |  |  |  |  | [NAME] | PM
2009-05-08 00:00:00 | [NAME] | 8 | 2000 |  |  |  |  | [NAME] | TA
2009-05-09 00:00:00 | [NAME] | 5 | 1200
Role | Totals
TA
PM
Spreadsheet: 680889d1591239127-retrieve-data-from-column-while-skipping-blanks-ef-lookup
Sheet: Sheet1

 | NAME | [NAME] | ADDRESS | CITY | PHONE
 | [NAME] | [EMAIL] | 14510 124th ave, #A6 | Kirkland, WA 98034
 | [NAME] | [EMAIL] | 14510 124th ave, #A6 | Kirkland, WA 98041 | 4259886346
 | [NAME] |  | 14524 124th ave, #A6 | Kirkland, WA 98048 |  |  |  |  | lookup
 | [NAME] |  | 14531 124th ave, #A6 | Kirkland, WA 98055 | 3066598794 |  |  | Person: |  | lookup value
 | [NAME] |  | 14511 124th ave, #A6 | Kirkland, WA 98035 | 3543265976
 | [NAME] | [EMAIL]
 | [NAME] |  | 14525 124th ave, #A6 | Kirkland, WA 98049 | 3531546467
 | [NAME] | [EMAIL] | 14532 124th ave, #A6 | Kirkland, WA 98056 | 6431113313
 | [NAME] | [EMAIL]
 | [NAME] |  | 14514 124th ave, #A6 | Kirkland, WA 98038
 | [NAME] | [EMAIL] | 14521 124th ave, #A6 | Kirkland, WA 98045 | 4679135648 |  |  |  | retrieve
 | [NAME] |  |  |  |  |  |  | email:
 | [NAME] | [EMAIL] | 14513 124th ave, #A6 | Kirkland, WA 98037 |  |  |  | address
 | [NAME] |  |  |  | 8979874636 |  |  | city
 | [NAME] | [EMAIL] | 14527 124th ave, #A6 | Kirkland, WA 98051 | 6565465413 |  |  | phone
 | Brooklyn Odonnell |  | 14514 124th ave, #A6 | Kirkland, WA 98038
 | Brooklyn Odonnell | [EMAIL] | 14521 124th ave, #A6 | Kirkland, WA 98045 | 5646546544
 | Brooklyn Odonnell | [EMAIL] | 14528 124th ave, #A6 | Kirkland, WA 98052
 | [NAME] | [EMAIL]
 | [NAME] |  | 14523 124th ave, #A6 | Kirkland, WA 98047 | 5647891445
 | [NAME] | [EMAIL]
 | [NAME] |  | 14516 124th ave, #A6 | Kirkland, WA 98040
 | [NAME] | [EMAIL] | 14523 124th ave, #A6 | Kirkland, WA 98047 | 6548931464
 | [NAME] | [NAME] | 14530 124th ave, #A6 | Kirkland, WA 98054
Spreadsheet: 289b27f3-ee27-41ed-9e56-88012f6c3301
Sheet: $ serials totals

Total Serials Expenditures by [NAME] FY11 and FY12
[NAME], Library Budget Only (No Endowments):
Library | FY11 | FY12 | % change | % of total FY12 expend.
Kingston serials funds | 2891248.79 | 3021619.98
[NAME] (pelp) | 9719.39 | 4437.11
CCE (ccep) | 3411.96 | 2828.4
TOTALS
Total Serials Endowment & Other Funds Expenditures
Fund code | Fund | FY11 | FY12 | % change
xbwp | B.Woods serials | 196.43 | 200.02
xcap | Carr fund serials | 8639.66 | 8612.73
xclp | Cloudman serials | 10329.4 | 7857.25
xgap | Galanti serials | 3393.01 | 3479.7
xiip | Ind.Ins.Agt serials | 16879.43 | 11444.62
 | TOTALS
Total Serials Expenditures (Including Endowments & Other Funds):
University Libraries | FY11 | FY12 | % change | % of total FY12 expend.
All branches | 2904380.14 | 3028885.49
Endowments | 39437.93 | 31594.32
TOTALS
Spreadsheet: 0738b5e4-0756-4b23-a343-ed823e4489d7
Sheet: Sheet1

Fraud | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | 1993
Age Group | Total | Male | Female
12 and under | 1.905232468688057 | 2.47343054972906 | 1.309386535609549
13-14 | 55.81767673316273 | 75.2545262225656 | 35.40500363618269
15 | 127.9228638552692 | 185.8572983673331 | 66.87123216519514
16 | 120.1167613603519 | 177.1665688297896 | 59.62230741919002
17 | 171.8205891402301 | 248.2606803007779 | 90.4417507117159
18 | 295.8786818430926 | 381.5095257086201 | 205.8468951533625
19 | 389.1688523429369 | 480.4979546853501 | 293.9301744707533
20 | 444.9585637858121 | 524.8511168390461 | 361.5644713998181
21 | 466.6682524415997 | 534.4288784124603 | 395.9472632525874
22 | 473.8198581305082 | 528.5723740941196 | 417.1717046572015
23 | 475.0519383658557 | 536.5467080227388 | 411.6680956204973
24 | 465.5513357312681 | 520.8486353911771 | 408.7930034526156
25-29 | 405.4554456682717 | 462.3999746722213 | 348.0894542483061
30-34 | 319.1539396931298 | 369.4891428088915 | 269.0956473017755
35-39 | 249.2112239059124 | 291.6523645686293 | 207.2377686399666
40-44 | 176.2516099799264 | 210.4177318260563 | 142.8978214263114
45-49 | 114.3638231281439 | 145.1397961426182 | 84.69650519084884
50-54 | 70.14768622631873 | 90.72414038658845 | 50.67856409564168
55-59 | 41.8610879494498 | 54.9922476011687 | 29.7625053306687
60-64 | 23.44904958945945 | 33.36366521634648 | 14.678746286599
65 and over | 7.235620640452663 | 11.20300391137205 | 4.53076034285693
Spreadsheet: 196663d1354061240-vlookup-off-of-two-values-columns-a-and-c-instead-of-one-and-returning-a-0-if-in-neither-test-scores-idea-bb-
Sheet: Sheet1

HOME TEAM | HOME SCORE | AWAY TEAM | AWAY SCORE | INITIAL RATING HOME | INITIAL RATING AWAY | NEW RATING HOME | NEW RATING AWAY
NY Giants | 17 | Dallas | 24 | 0 | 0 | 8.5 | 12
Chicago | 41 | Indianapolis | 21 | 0 | 0 | 20.5 | 10.5
Minnesota | 26 | Jacksonville | 23 | 0 | 0 | 13 | 11.5
NY Jets | 48 | Buffalo | 28 | 0 | 0 | 24 | 14
Houston | 30 | Miami | 10 | 0 | 0 | 15 | 5
Tennessee | 13 | New England | 34 | 0 | 0 | 6.5 | 17
Detroit | 27 | St. Louis | 23 | 0 | 0 | 13.5 | 11.5
Green Bay | 22 | San Francisco | 30 | 0 | 0 | 11 | 15
Arizona | 20 | Seattle | 16 | 0 | 0 | 10 | 8
Tampa Bay | 16 | Carolina | 10 | 0 | 0 | 8 | 5
Denver | 31 | Pittsburgh | 19 | 0 | 0 | 15.5 | 9.5
Baltimore | 44 | Cincinnati | 13 | 0 | 0 | 22 | 6.5
Oakland | 14 | San Diego | 22 | 0 | 0 | 7 | 11
TEAM | RATING 1 | RATING 2 | HOME/AWAY
Arizona | 0 | 10 | HOME
Atlanta | 0 | 0
Baltimore | 0 | 22 | HOME
Buffalo | 0 | 0
Carolina | 0 | 0
Chicago | 0 | 20.5 | HOME
Cincinnati | 0 | 0
Cleveland | 0 | 0
Dallas | 0 | 0
Denver | 0 | 15.5 | HOME
Detroit | 0 | 13.5 | HOME
Green Bay | 0 | 11 | HOME
Houston | 0 | 15 | HOME
Indianapolis | 0 | 10.5 | AWAY
Jacksonville | 0 | 11.5 | AWAY
Kansas City | 0 | 0
Miami | 0 | 5 | AWAY
Minnesota | 0 | 13 | HOME
New England | 0 | 17 | AWAY
New Orleans | 0 | 0
NY Giants | 0 | 8.5 | HOME
NY Jets | 0 | 24 | HOME
Oakland | 0 | 7 | HOME
Philadelphia | 0 | 0
Pittsburgh | 0 | 9.5 | AWAY
San Diego | 0 | 11 | AWAY
San Francisco | 0 | 15 | AWAY
Seattle | 0 | 8 | AWAY
St. Louis | 0 | 11.5 | AWAY
Tampa Bay | 0 | 8 | HOME
Tennessee | 0 | 6.5 | HOME
Washington | 0 | 0
Spreadsheet: 724584d1616249103-i-need-some-help-on-sum-diferent-criterios-centro-de-custos-2021
Sheet: Vale - Hi Lift

 |  | CENTROS DE CUSTOS
 |  | Vale - Hi Lift
 |  | Data | [NAME] | Req. / Fact nº | Valor - Mzn | TAG | Observação
 |  | 2021-02-09 00:00:00 | Combustivel | 55568 | 7540.8 | EQ028 | Compressor
 |  | 2021-02-11 00:00:00 | Combustivel | 55581 | 7540.8 | EQ028 | Compressor
 |  | 2021-02-13 00:00:00 | Combustivel | 55621 | 7540.8 | EQ028 | Compressor
 |  | 2021-02-17 00:00:00 | Combustivel | 55622 | 7540.8 | EQ028 | Compressor
 |  | 2021-02-19 00:00:00 | Combustivel | 55632 | 1357.8 | EQ028 | Gerador
 |  | 2021-02-23 00:00:00 | Combustivel | 55661 | 7540 | EQ028 | Compressor
Spreadsheet: jim_schwieger__14290__Centana_Renewal_Proposal
Sheet: Sheet1

CENTANA STORAGE
 | CAPACITY | REVISED INJECTION & WITHDRAW CAPACITY
 | STORAGE | INJECTION |  | WITHDRAWAL
[NAME]: | MMBtu | MMBtu/d |  | MMBtu/d
AUGUST | 1500000 | 45000 |  | 185000
SEPTEMBER | 1500000 |  |  | 185000
OCTOBER | 1500000 |  |  | 185000
NOVEMBER | 1500000 |  |  | 90000
DECEMBER | 1500000 |  |  | 240000
JANUARY | 1500000 |  |  | 300000
FEBRUARY | 1500000 |  |  | 300000
[NAME] | 1500000 |  |  | 150000
APRIL | 1500000 |  |  | 15000
MAY | 1500000 |  |  | 15000
[NAME] | 1500000 |  |  | 15000
JULY | 1500000 |  |  | 120000
GENERAL TERMS:
TERM: | THREE YEARS  (AUGUST 1, 2001 THROUGH JULY 31, 2004)
FIRM CAPACITY DEMAND CHARGE |  | 0.075 | PER MMBtu PER MONTH
FIRM DELIVERABILITY DEMAND CHARGE |  | 0.183 | PER MMBtu PER MONTH
FIRM INJECTION & WITHDRAWAL COMMODITY |  | 0 | PER MMBtu
FIRM INJECTION - FUEL RETENTION |  | 0.01
TRANSPORTATION CHARGE |  | 0 | PER MMBtu TO & FROM FIRM & INTERRUPTIBLE POINTS
RECEIPT & DELIVERY POINTS: |  | RECEIPT POINT |  |  |  | DELIVERY POINT
POINT [NAME] | METER NUMBER | FIRM / INTER |  | MMBtu/d |  | FIRM / INTER |  | MMBtu/d
MIDCON TEXAS | NEW METER | FIRM |  | 45000 |  | FIRM |  | 50000
HPLC-SPINDLETOP | 77264
HPLC-NEW METER | 77001 | FIRM |  | 45000 |  | FIRM |  | 150000
HPLC | 77719
MOBIL | 77455 |  |  |  |  | FIRM |  | 50000
GULF STATES UTILITIES | 77351 |  |  |  |  | FIRM |  | 100000
 |  |  |  |  |  | INTERRUPTIBLE |  | 100000
CHEVRON CLARK POINT | 77382 |  |  |  |  | FIRM |  | 30000
FLORIDA | 77441 | FIRM |  | 25000
FLORIDA | 77441 | INTERRUPTIBLE |  | 30000
FLORIDA | 77444 |  |  |  |  | FIRM |  | 25000
FLORIDA | 77444 |  |  |  |  | INTERRUPTIBLE |  | 30000
TETCO (STX) | 77435 | FIRM |  | 30000
TETCO (STX) | 77435 | INTERRUPTIBLE |  | 30000
TETCO (STX) | 77438 |  |  |  |  | FIRM |  | 25000
TETCO (STX) | 77438 |  |  |  |  | INTERRUPTIBLE |  | 30000
TETCO (WLA) | ?????? | FIRM |  | 30000
TETCO (WLA) | ?????? |  |  |  |  | FIRM |  | 30000
TEJAS / AMOCO | 77235 | INTERRUPTIBLE |  | 15000
CHANNEL | 77420 | INTERRUPTIBLE |  | 15000
MIDCON TEXAS | 77489
NGPL - SABINE PASS | 77525 | INTERRUPTIBLE |  | 30000
NGPL | 77526 |  |  |  |  | INTERRUPTIBLE |  | 30000
SABINE PIPELINE | 77461 | FIRM |  | 20000
SABINE PIPELINE | 77461 | INTERRUPTIBLE |  | 30000
SABINE PIPELINE | 77464 |  |  |  |  | FIRM |  | 20000
SABINE PIPELINE | 77464 |  |  |  |  | INTERRUPTIBLE |  | 30000
TEJAS | ??????? | FIRM |  | 45000 |  | FIRM |  | 50000
TEJAS - SPINDLETOP | 77485 | INTERRUPTIBLE |  | 15000
TEJAS - NECHES | 77710 | INTERRUPTIBLE |  | 15000
TEJAS - ORANGE CO. | 77283 | INTERRUPTIBLE |  | 15000
TEJAS - SPINDLETOP | 77529 |  |  |  |  | INTERRUPTIBLE |  | 15000
OTHER:
DAILY SCHEDULING REQUIREMENTS: |  | EC&T SHALL NOMINATE BY 11:30 ON THE PREVIOUS DAY FOR THE NEXT DAY'S GAS FLOW
 |  | EC&T SHALL BE ALLOWED FOUR INTRADAY NOMINATION CHANGES.  CHANGES MUST HAVE
 |  | TWO HOUR NOTICE.  CIPCO ON A BEST EFFORTS BASIS SHALL ACCOMMODATE NOTICE
 |  | WITHIN ONE HOURS.
Spreadsheet: 230605d1366818226-time-card-spread-sheet-help-time-sheet
Sheet: Pivot Table

Name | Pay Period | Data | Total
[NAME] | 12012 | Sum of Regular Hrs | 15:00:00
 |  | Sum of Overtime | 1:30:00
 |  | Sum of Weekend | 0:00:00
 |  | Sum of Total Hours | 16:30:00
[NAME] of Regular Hrs |  |  | 15:00:00
[NAME] of Overtime |  |  | 1:30:00
[NAME] of Weekend |  |  | 0:00:00
[NAME] of Total Hours |  |  | 16:30:00
[NAME] | 12012 | Sum of Regular Hrs | 16:00:00
 |  | Sum of Overtime | 6:25:00
 |  | Sum of Weekend | 0:00:00
 |  | Sum of Total Hours | 22:25:00
[NAME] of Regular Hrs |  |  | 16:00:00
[NAME] of Overtime |  |  | 6:25:00
[NAME] of Weekend |  |  | 0:00:00
[NAME] of Total Hours |  |  | 22:25:00
[NAME] | 12012 | Sum of Regular Hrs | 13:30:00
 |  | Sum of Overtime | 0:00:00
 |  | Sum of Weekend | 0:00:00
 |  | Sum of Total Hours | 13:30:00
[NAME] Sum of Regular Hrs |  |  | 13:30:00
[NAME] Sum of Overtime |  |  | 0:00:00
[NAME] Sum of Weekend |  |  | 0:00:00
[NAME] Sum of Total Hours |  |  | 13:30:00
[NAME] | 12012 | Sum of Regular Hrs | 16:00:00
 |  | Sum of Overtime | 4:30:00
 |  | Sum of Weekend | 0:00:00
 |  | Sum of Total Hours | 20:30:00
[NAME] of Regular Hrs |  |  | 16:00:00
[NAME] of Overtime |  |  | 4:30:00
[NAME] of Weekend |  |  | 0:00:00
[NAME] of Total Hours |  |  | 20:30:00
[NAME] | 12012 | Sum of Regular Hrs | 15:00:00
 |  | Sum of Overtime | 4:00:00
 |  | Sum of Weekend | 0:00:00
 |  | Sum of Total Hours | 19:00:00
[NAME] |  |  | 15:00:00
[NAME] of Overtime |  |  | 4:00:00
[NAME] of Weekend |  |  | 0:00:00
[NAME] Total Hours |  |  | 19:00:00
Total Sum of Regular Hrs |  |  | 3 days, 3:30:00
Total Sum of Overtime |  |  | 16:25:00
Total Sum of Weekend |  |  | 0:00:00
Total Sum of Total Hours |  |  | 3 days, 19:55:00
Spreadsheet: 06e00fcd-7234-4511-a05d-a74a3c955e10
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
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 84. Value of Building Approved, Chain Volume Measures, Original - Tasmania
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total houses ;  New ; |  |  | Original | A590527L | 1985-09-01 00:00:00 | 2011-09-01 00:00:00 | 105 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total other residential building ;  New ; |  |  | Original | A590528R | 1985-09-01 00:00:00 | 2011-09-01 00:00:00 | 105 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  New ; |  |  | Original | A590529T | 1985-09-01 00:00:00 | 2011-09-01 00:00:00 | 105 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590530A | 1985-09-01 00:00:00 | 2011-09-01 00:00:00 | 105 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590531C | 1985-09-01 00:00:00 | 2011-09-01 00:00:00 | 105 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590532F | 1985-09-01 00:00:00 | 2011-09-01 00:00:00 | 105 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590533J | 1985-09-01 00:00:00 | 2011-09-01 00:00:00 | 105 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2011
Spreadsheet: 329659d1404378732-collate-data-problem-solving-sample-work-book
Sheet: Tab 4

 |  |  |  |  |  |  |  | Price [NAME]
 | Labour | Grade | Cost | Personnel | Days | Hr/Day
 | Travel and Subsistence | Basis
 | Materials and Subcontract | Basis | Cost
 | Pricing
 | Total labour
 | Total T&S
 | Total materials
Spreadsheet: 006cf945-6aaa-4b66-8932-4b55a1a6b500
Sheet: Sheet1

Ref # | Part # | Description | Notes
AG2 | 016338-Z | HANDLEBAR ASSEMBLY | Includes HPS and HR wire assembly
AN5 | 014926-AB | FRAME CONSOLE ASSEMBLY
CNS | 071871 | CNS FS7 | Includes COS,N11,N13,N14,N60N62,N65,N67
COS | 062361-ZUP | OVERLAY CONSOLE ASSEMBLY FOLDING SIMPLE | Includes overlay, and N62
HPS | 026768-Z | GRIP HEART RATE
[NAME] | 007806-D | PLATE CONTACT HR
G52 | 004706-A | [NAME]
G55 | 004339-00 | [NAME] [NAME]
G56 | 004880-00 | NUT M3
N01 | 063231-AAX | COVER CONSOLE UPPER FOLDING
N02 | 063232-AAX | COVER CONSOLE LOWER FOLDING
N11 | 001485-BA | REED SWITCH BRACKET
N12 | 001961-D2 | REED SWITCH
N13 | 000890-AA | RACK READING INSERTS
[NAME] | 000799-BA | HOLDER BOTTLE
N16 | 004612-AB | SCREW BH M3X8
N17 | 004612-00 | BOLT BH M3X8 TAPPING
N18 | 004351-00 | [NAME]
N19 | 004612-AB | SCREW BH M3X8
N20 | 005091-Z | WASHER FT 4X10X1.2
N50 | 004369-00 | SCREW BH M5X15
N51 | 004860-AB | SCREW BH M4X0.7X8L OVERSIZE
N60 | 057764-AAX | UPPER BOARD SIMPLE
N62 | 056524-A | KEYPAD MEMBRANE 19 KEY
N65 | 038132-BBX | BOARD RECEIVER HR CONTACT
N70 | 002337-A | WIRE HRT CONNECTING TCPD6
V01 | 064225-AX | DECAL VF MOTOR COVER
V10 | 006130-AX | DECAL SAFETY KEY TCPD6
NOT SHOWN | 013860-B | SAFETY KEY ASSEMBLY
NOT SHOWN | 006719-00 | CARD WARRANTY
NOT SHOWN | 063277-AX | MANUAL ASSEMBLY FOLDING CONSOLE
NOT SHOWN | 056835-AX | MANUAL OWNERS
NOT SHOWN | 002480-A | CABLE CONSOLE JUMPER 810MM-8 PIN
NOT SHOWN | 002464-B | CABLE CONSOLE JUMPER 750MM-6-PIN
NOT SHOWN | 003567-B2 | JACKS DATA 8-PIN CONSOLE LARGE
NOT SHOWN | 003568-B2 | JACKS DATA 6-PIN CONSOLE SMALL
Spreadsheet: 866371d1713299954-formula-to-retun-multiple-values-rate
Sheet: cuurent rate

Main table 1
name | id | effective date | rate
[NAME] | 134406 | 2021-09-30 00:00:00 | 26.5
[NAME] | 134406 | 2021-10-11 00:00:00 | 29.32
[NAME] | 463904 | 2021-09-30 00:00:00 | 39.04
mie | 131205 | 2021-10-05 00:00:00 | 39.88
drake | 127029 | 2021-09-30 00:00:00 | 39.97
drake | 132599 | 2021-10-30 00:00:00 | 39.04
drake | 130861 | 11/13/201 | 37.22
table 2
name | id | start date | rate
[NAME] | 134406 | 9/31/2021
[NAME] | 134406 | 2021-10-22 00:00:00
[NAME] | 463904 | 9/31/2021
mie | 131205 | 2021-10-05 00:00:00
drake | 127029 | 9/31/2021
drake | 132599 | 2021-10-31 00:00:00
drake | 130861 | 11/31/2021
I would like to fill in the rate vaule  in D18-D24
the formula should look at the effective date in main table 1.  if the start date in table 2 is equal or after the start date in main table one then that rate should be applied.
for example
in table 2, the row with [NAME] with a start date of 9/31, based on the main table,  26.50 should be applied in cell D18
in the following row [NAME] has a start date of 10/22.  based on the main table.  Cell D19 Should have 29.32
Spreadsheet: 149266d1333789475-excel-2003-when-printing-add-1-record-of-deliverys
Sheet: Department 001

Record of Deliverys
Referance Number | Date | Time | Name of [NAME] | Number of Boxes / Pallets | Delivery Note Y/N | Name | Sign | Notes
Dep01-001
Dep01-002
Dep01-003
Dep01-004
Dep01-005
Dep01-006
Dep01-007
Dep01-008
Dep01-009
Dep01-010
Dep01-011
Dep01-012
Dep01-013
Dep01-014