tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 747808d1631710120-compliance-actions-formula-risk-eba
Sheet: Sheet1

OPERATIONAL COMPLIANCE FRAMEWORK SUMMARY
RISK 1 ACCESS | COMPLIANCE
 | COMPLIANT | NON-COMPLIANT | CORRECTIVE ACTION
All professional visitors, domestic visitors, contractors and staff are screened through roto-turn |  | Y | Y
All personal belongings are carried in an approved clear, plastic bag
All personal gear is screened through an x-ray machine |  | N | N
Bypass door approved list provided to Gatehouse |  | Y
All staff produce current identification |  | Y | N
RISK 2 CONTROL | COMPLIANCE
 | COMPLIANT | NON-COMPLIANT | CORRECTIVE ACTION
All professional visitors, domestic visitors, contractors and staff are screened through roto-turn |  | Y | Y
All personal belongings are carried in an approved clear, plastic bag |  | Y | N
All personal gear is screened through an x-ray machine |  | Y | N
Bypass door approved list provided to Gatehouse |  | N | N
All staff produce current identification |  | Y | Y
COMPLIANCE RATING
Spreadsheet: 850968d1701263560-how-to-extract-and-transpose-from-multiple-rows-and-two-columns-spreadsheet-test
Sheet: Blad1

Label | Value
Date | 2023-11-24 |  |  | Name one | Address one | Phone one | [EMAIL] | ZIP code one & City one
Name | Name one |  | 2023-11-24 | Name two | Address two | Phone two | [EMAIL] | ZIP code two & City two
Address | Address one |  | 2023-11-24 | Name three | Address three | Phone three | [EMAIL] | ZIP code three & City three
Phone no | Phone one
Email address | [EMAIL]
ZIP Code & City | ZIP code one & City one
Date | 2023-11-24
Name | Name two
Address | Address two
Phone no | Phone two
Email address | [EMAIL]
ZIP Code & City | ZIP code two & City two
Date | 2023-11-24
Name | Name three
Address | Address three
Phone no | Phone three
Email address | [EMAIL]
ZIP Code & City | ZIP code three & City three
Spreadsheet: 806722d1669514092-calculate-golf-trend-by-combining-9-hole-rounds-to-make-18-golf-trend-sample
Sheet: Sheet1

 | 1 | 1 | 0.5 | 1 | 0.5 | 1 | 1 | 0.5 | 0.5 | 0.5 | 1 | 1 | 1 |  |  |  |  | results should be this:
[NAME] | 8/1/2021 | 8/8/2021 | 8/15/2021 | 8/22/2021 | 8/29/2021 | 9/5/2021 | 9/12/2021 | 9/19/2021 | 9/26/2021 | 10/3/2021 | 10/10/2021 | 10/17/2021 | 10/24/2021 |  | Average | last 4 trend |  | Sum of scores | # rounds | Scoring average
1 | 82 | 85 | 38 |  | 38 |  | 89 | 41 |  | 47 |  |  |  |  |  |  |  | 338 | 4 | 84.5
2 | 77 | 75 | 41 | 82 |  | 86 | 88 | 45 |  |  |  | 82 |  |  |  |  |  | 383 | 4.5 | 85.11
3 |  |  | 40 | 82 | 46 |  | 88 |  | 45 | 42 |  |  | 80 |  |  |  |  | 383 | 4.5 | 85.11
4 | 85 |  | 44 |  | 39 |  | 78 |  | 43 |  | 75 | 39 |  |  |  |  |  | 318 | 4 | 79.5
Spreadsheet: 803756d1667665227-need-an-alternative-to-vlookup-that-returns-all-values-found-spa-lista-de-estabelecimentos-dsavrlvt-29_07_2022
Sheet: Secção VIII

[NAME]. 1069/2009 Secção VIII – Unidades de Fabrico de Alimentos para Animais de Companhia
NCV (Approval Number) | Nome (Name) | Concelho (Municipality) | Categoria (Category) | Atividade (Activity) | Espécies / Produtos (Species / Products) | [NAME] (Associated Activities)
 | AVENAL PETFOOD, S.A. | [NAME] | 3 | Unidade de alimentos para animais de companhia que usa apenas subprodutos processados(PETPP) | PETP | FAC(AAINA), IAA(AAITR, AAVPAAR), SPONA(AAINPAT)
 | Sorgal - Sociedade de Óleos e Rações, S.A. | Torres Novas | 3 | Unidade de alimentos para animais de companhia que usa apenas subprodutos processados(PETPP) | PETP | FAC(AAINR)
 | PETMAXI, S.A. | Ferreira do Zêzere | 3 | Unidade de alimentos para animais de companhia que usa apenas subprodutos processados(PETPP) | PETP | FAC(AAINR), IAA(AAITR, AAVPAAR), IMPAA(AAIPR), SPONA(AAINPAT)
 | COOKA'S WORLD - Pet Services, Lda. | Sintra | 3 | Unidade de alimentos para animais de companhia que usa  subprodutos animais crus(PETPR) | PETR | FAC(AAINR), IAA(AAVPAAR)
Atividades:
Unidade de alimentos para animais de companhia que usa apenas subprodutos processados(PETPP)
Unidade de alimentos para animais de companhia que usa  subprodutos animais crus(PETPR)
Spreadsheet: 329017d1404161788-find-the-last-occurrence-of-a-value-in-multiple-columns-or-a-matrix-hymntrack
Sheet: Hymn Frequentness

Hymn # |  | Times Sung | [NAME] | Hymn # |  | Times Sung | [NAME] | Hymn # |  | Times Sung | [NAME] | Hymn # |  | Times Sung | [NAME] | Hymn # |  | Times Sung | [NAME]
1 |  |  |  | 71 |  |  |  | 141 |  |  |  | 211 |  |  |  | 281
Spreadsheet: 59686d1260273271-displaying-multiple-results-with-vlookup-copy-of-example
Sheet: Sheet2

Reg | Date | Owner | Vehicle | Amount
abc 123 | 1995-10-01 00:00:00 | G Smith | Ford | 199
bcd 234 | 1995-10-12 00:00:00 | T Gordon | BMW | 155
def 456 | 1999-01-02 00:00:00 | J [NAME] | Toyota | 120
abc 123 | 1997-05-20 00:00:00 | G Smith | Ford | 145
fed 567 | 2000-09-06 00:00:00 | K Peters | Mitsubishi | 110
ggh 789 | 2000-11-08 00:00:00 | [NAME] | V.W | 230
abc 123 | 2001-12-01 00:00:00 | G Smith | Ford | 212
abc 123 | 2007-02-27 00:00:00 | G Smith | Ford | 45
Spreadsheet: 121547d1316136484-how-do-i-automatically-attach-data-to-terms-i-copy-into-excel-stats
Sheet: Pitching

** DO NOT TYPE IN ANY CELL THAT HAS BLACK TEXT, THESE WILL BE AUTOMATICALLY CALCULATED
Player | IP | B's | S's | TP | API | Hits | BB's | HB | K's | ER | Won | Loss | Save | PO | BB\K | ERA | BA\Pit | %S's | RA
Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Team Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DEFINITIONS:
IP = [NAME]
B's = Balls Thrown |  |  |  |  |  |  |  |  |  |  |  |  | Baseball Almanac
S's = Strikes Thrown |  |  |  |  |  |  |  |  |  |  |  |  | www.baseball-almanac.com
TP = Total Pitches |  |  |  |  |  |  |  |  |  |  |  |  | Copyright © 2003 Sean Holtz
API = Average Pitches per Inning
Hits = Hits given up
HB = Hit Batter
BB's = Walks (Base on Balls)
K's = [NAME]
ER = Earned Runs
PO = Pick Offs
BB\K = Walk/ [NAME]
ERA = Earned Run Average
BA\Pit = Batting Average against the pitcher
%S's = Percentage of Strikes Thrown
RA = Runners Allowed On Base
Spreadsheet: barry_tycholiz__845__Noresco Gas Usage
Sheet: Sheet1

 |  |  | NORESCO Project
 |  |  | Projected Annual Gas Usage
 |  |  |  |  |  |  |  |  | Heat Rate | 9200 | btu/kWh
 |  |  |  |  | Power Plant Production - Electric |  |  |  | Power Plant Consumption - Gas
 |  |  |  |  | Monthly | Hourly | Hourly |  | Monthly | Hourly | Hourly | Daily
 |  |  |  |  | Total | Avg | Peak |  | Total | Avg | Peak | Avg
 |  |  | Hours | Month | (kWh) | (kW) | (kW) |  | (mmbtu) | (mmbtu/hr) | (mmbtu/hr) | (mmbtu)
 |  |  | 744 | 1 | 3296555 | 4431 | 8767 |  |  |  | 80.7
 |  |  | 672 | 2 | 4242290 | 6313 | 8853 |  |  |  | 81.5
 |  |  | 744 | 3 | 3855019 | 5181 | 8554 |  |  |  | 78.7
 |  |  | 720 | 4 | 3671560 | 5099 | 8525 |  |  |  | 78.4
 |  |  | 744 | 5 | 4052533 | 5447 | 8410 |  |  |  | 77.4
 |  |  | 720 | 6 | 3682085 | 5114 | 8271 |  |  |  | 76.1
 |  |  | 744 | 7 | 3797427 | 5104 | 7915 |  |  |  | 72.8
 |  |  | 744 | 8 | 3929387 | 5281 | 8508 |  |  |  | 78.3
 |  |  | 720 | 9 | 4381569 | 6086 | 8698 |  |  |  | 80
 |  |  | 744 | 10 | 3984602 | 5356 | 9089 |  |  |  | 83.6
 |  |  | 720 | 11 | 3887284 | 5399 | 8721 |  |  |  | 80.2
 |  |  | 744 | 12 | 4010325 | 5390 | 8496 |  |  |  | 78.2
 |  |  | Totals
Spreadsheet: 874768d1721292003-formula-scrambles-arguments-when-pulled-across-ron_ray-s3_dynamic_array_legacyformulas_issue_-aligw
Sheet: SUMIFS

SUMIFS & COUNTIFS with OR Condition (more than 1 criteria in one column)
 |  |  |  |  | 1. Create a summary table by Region and Division
Division | Region | App | Revenue
Game | Asia | Arcade | 4378 |  |  | Asia | North America | Europe
Game | Asia | Aviatrr | 5254 |  |  | Australia | South America
Game | Asia | Baden | 6130 |  | Division | Region 1 | Region 2 | Region 3
Game | Asia | deRamblr | 7443 |  |  |  | 22085 | 23168
Game | Asia | Fightrr | 13135 |  | Productivity | 6441 | 66798 | 37799
Game | Asia | Twistrr | 7443 |  | Utility | 7866 | 19336 | 0
Game | Australia | Arcade | 15890
Game | Australia | Aviatrr | 11917
Game | Australia | Baden | 1490
Game | Australia | Pes | 497
Game | Australia | Twistrr | 3476
Game | Europe | Arcade | 9267
Game | Europe | Aviatrr | 9731
Game | Europe | Kryptis | 927
Game | Europe | Perino | 463
Game | Europe | Pes | 463
Game | Europe | Twistrr | 2317
Game | North America | Arcade | 5361
Game | North America | Aviatrr | 5808
Game | North America | Pes | 4468
Game | North America | Twistrr | 1340
Game | South America | Arcade | 5108
Productivity | Asia | Halotot | 3513
Productivity | Asia | Inkly | 2928
Productivity | Europe | Blend | 911
Productivity | Europe | Dasring | 2277
Productivity | Europe | Didactic | 3188
Productivity | Europe | Flowrrr | 3643
Productivity | Europe | Halotot | 5465
Productivity | Europe | Right App | 5465
Productivity | Europe | Silvrr | 4554
Productivity | Europe | Sleops | 455
Productivity | Europe | Voltage | 911
Productivity | Europe | WenCaL | 10930
Productivity | North America | Blend | 1708
Productivity | North America | Dasring | 683
Productivity | North America | Didactic | 683
Productivity | North America | Flowrrr | 683
Productivity | North America | Halotot | 6148
Productivity | North America | Inkly | 1025
Productivity | North America | [NAME] | 683
Productivity | North America | Mirrrr | 1366
Productivity | North America | Pet Feed | 1708
Productivity | North America | Rehire | 6148
Productivity | North America | Right App | 7514
Productivity | North America | Silvrr | 683
Productivity | North America | Sleops | 342
Productivity | North America | Voltage | 3416
Productivity | North America | WenCaL | 1366
Productivity | South America | Blend | 1220
Productivity | South America | Dasring | 2732
Productivity | South America | Didactic | 9563
Productivity | South America | Sleops | 683
Productivity | South America | Voltage | 12979
Productivity | South America | WenCaL | 5465
Utility | Australia | Accord | 684
Utility | Australia | Amplefio | 4104
Utility | Australia | [NAME] | 0
Utility | Australia | Commuta | 1710
Utility | Australia | Infic | 684
Utility | Australia | Minor Liar | 684
Utility | North America | Minor Liar | 9723
Utility | South America | [NAME] | 2508
Utility | South America | Mosquit | 0
Utility | South America | Motocyco | 0
Utility | South America | Twenty20 | 7105
Spreadsheet: 84743d1284741376-conditional-formatting-cond_form-1-
Sheet: Sheet1

 | Month 1 | Month 2
Unit 1 | 0.7777777777777778 | 0.5
Unit 2 | 0.52 | 0.2631578947368421
Unit 3 | 0.2258064516129032 | 0.2941176470588235
Unit 4 | 0.6666666666666666 | 0.7692307692307693
Unit 5 | 0.55 | 0.65
Unit 6 | 0.2758620689655172 | 0.7619047619047619
Unit 7 | 0.4838709677419355 | 0.525
Unit 8 | 0.8421052631578947 | 0.8636363636363636
Unit 9 | 0.7 | 0.6363636363636364
Unit 10 | 0.6 | 0.3461538461538461
Unit 11 | 0.44 | 0.9333333333333333
Unit 12 | 0.7222222222222222 | 0.6060606060606061
Unit 13 | 0.75 | 0.6590909090909091
Unit 14 | 0.3333333333333333 | 0.6666666666666666
Unit 15 | 0.5 | 0.6086956521739131
Unit 16 | 0.3333333333333333 | 0.4375
Spreadsheet: 760530d1640272391-improve-formula-to-check-for-dates-within-a-range-leave-sample
Sheet: StaffName

STAFF ANNUAL LEAVE CARD
Name: |  | Staff Name |  |  | Tuesday - Thursday
 |  |  |  |  | Friday
Site: |  | Site 1 |  |  | Saturday
Entitlement (hours): 1 Jan - 31 Dec |  | 0
Leave C/F (hours): |  | 0 | TOTAL LEAVE: |  | REMAINING:
Date From | Date To | No. of working hours | Type of Leave | Balance Due | Approved By | Date Approved
2022-01-03 00:00:00 | 2022-01-06 00:00:00 |  | Annual Leave
2022-01-22 00:00:00 | 2022-01-22 00:00:00 |  | Annual Leave
2022-01-14 00:00:00 | 2022-01-15 00:00:00 |  | Annual Leave
2022-01-29 00:00:00 | 2022-02-03 00:00:00 |  | Annual Leave
Spreadsheet: 174074d1344908810-wildcard-for-time-practice-pay2
Sheet: Sheet1

Sign-In | Lunch out | Lunch In | Sign-Out | Hours Worked
07:45:00
08:00:00 |  |  | 13:00:00 | 05:00:00
07:45:00
08:00:00 |  |  | 13:00:00 | 05:00:00
07:00:00 |  |  | 15:30:00
07:30:00 |  |  | 16:00:00
07:00:00 | 08:00:00 | 15:00:00 | 18:00:00 | 4
07:00:00 | 08:00:00 | 15:00:00 | 18:00:00 | 4
 |  | 15:15:00 | 16:15:00 | 1
08:30:00
08:30:00
Spreadsheet: 96669d1296005335-excel-2007-need-to-lock-in-merged-cells-when-selecting-insert-table-example
Sheet: name3

Name | hhmmss.dd | data | hhmmss.dd | data
Name3 | time3 | data | time3 | data
 |  | more data |  | more data
 |  | even more data |  | even more data
Name3 | time3 | data | time3 | data
 |  | more data |  | more data
 |  | even more data |  | even more data
Spreadsheet: 844332d1696057617-how-to-calculate-bonus-based-on-year-of-service-bonus-etaf
Sheet: Bonus Scheme

Call Date | Year of Service | Service Bonus
0 | 0 | 0
2.8 | 3 | 1000
4.8 | 5 | 3000
7.8 | 8 | 3000
9.8 | 10 | 5000
14.8 | 15 | 8000
Spreadsheet: 157118d1337622864-unsolved-issue-daddy_fruits
Sheet: Sheet1

 |  |  | Qty Total | Qty Rejected | Name |  | Salvagable? | Cost |  |  |  |  | Top Fruits | Qty Total | Qty Rejected
 |  |  | 33 | 3 | Plums |  | S
 |  |  | 44 | 4 | Apples
 |  |  | 97 | 8 | Oranges |  | S
 |  |  | 55 | 4 | Oranges |  | S
 |  |  | 22 | 3 | Apples |  | S
 |  |  | 14 | 3 | Peaches |  | S
 |  |  | 51 | 24 | Apples |  | S
 |  |  | 656 | 1 | Apricots
 |  |  | 76 | 3 | Plums |  | S
 |  |  | 86 | 4 | Bananas |  | S
 |  |  | 66 | 6 | Bananas |  | S
 |  |  | 77 | 4 | Apricots
Spreadsheet: 84935d1285020962-display-cell-text-in-another-cell-automatically-copy-of-master-qoute
Sheet: Sheet1

 |  | Client Name: | [NAME] Jingleheimer [NAME]
 |  | Event Date:
 |  | Venue:
Proposal on all food considered
Guests | Food | Taxable | Unit Price | Subtotal | Tax | 18% Gratuity | Total
 |  | yes
 |  | yes
 |  | Yes
 |  | yes
 |  | yes
 |  | yes
 |  | yes
 |  | yes
 |  | Client Name:
 |  | Event Date:
 |  | Venue: |  |  |  |  | Mailing Address
Proposal on Service Considered
Quantity | Service Type | Time | Unit Price | Total
 | [NAME] |  | 15
 | Bartenders-we provide alcohol |  | 15
 | Bartenders-client providing alcohol |  | 20
1 | Set-up & Clean-up | 6 | 60
 | Delivery |  | 0.5
 | Dinner Plates |  | 0.25
 | [NAME] |  | 0.25
 | [NAME] |  | 0.25
 | [NAME], [NAME] |  | 0.4
 | Coffee mugs & saucers |  | 0.4
 |  | Service Totals
 |  | Food Totals
 |  | Subtotal
 |  | Deposit Required
 |  | Balance at Event
Spreadsheet: 749966d1633116915-how-to-return-top-values-based-on-cell-criteria-datereturn
Sheet: Sheet1

 | Beg Date |  |  |  | End Date
 | 2021-09-01 00:00:00 |  |  |  | 2021-11-30 00:00:00 |  | 13 |  | Dates to exclude
 |  |  |  |  |  |  |  |  | 2021-09-13 00:00:00
 |  |  |  |  |  |  |  |  | 2021-09-14 00:00:00
 |  |  |  |  |  |  |  |  | 2021-10-01 00:00:00
Spreadsheet: 489004d1478978043-using-dynamic-ranges-in-chart-copy-of-12-nov-2016
Sheet: Sheet1

Date | Value |  |  |  |  | Date | Value
2016-01-01 00:00:00 | 1 |  | Axis range | Data range
 |  |  | $A$12 | $b$2
 |  |  | $A$25 | $b$20
Spreadsheet: 808534d1670510011-2-formulas-subtract-from-specific-columns-formulatest
Sheet: Pivot

 |  |  | Values |  |  |  |  |  |  |  | Subtract | Subtract
Department | Name | Target | Sum of Jun-22 | Sum of Jul-22 | Sum of Aug-22 | Sum of Sep-22 | Sum of Oct-22 | Sum of Nov-22 | Sum of Dec-22 |  | Column J - Column I | Column J - Column C
DepC | Person19 | 68 | 1985 | 2456 | 2097 | 1839 | 2078 | 1929 | 2487
 | Person21 | 9 | 2235 | 2399 | 2237 | 1630 | 2450 | 2194 | 1694
 | Person23 | 4987 | 1832 | 2213 | 2367 | 1687 | 1762 | 1536 | 2301
 | Person25 | 9848 | 2163 | 2220 | 2169 | 1579 | 1684 | 2077 | 2367
 | Person27 | 18 | 2363 | 1788 | 1811 | 1594 | 2283 | 1927 | 2294
DepC Total |  |  | 10578 | 11076 | 10681 | 8329 | 10257 | 9663 | 11143
[NAME] | [NAME] | 897 | 1599 | 1708 | 2178 | 2116 | 2100 | 1521 | 2257
 | Person22 | 598 | 1513 | 2476 | 1870 | 2009 | 1662 | 2135 | 1526
 | Person24 | 98 | 1853 | 2053 | 2418 | 2217 | 1842 | 2450 | 1735
 | Person26 | 99 | 1775 | 2246 | 2177 | 1901 | 1521 | 1869 | 1894
 | Person28 | 9 | 2362 | 1729 | 1889 | 1903 | 1550 | 2217 | 2094
[NAME] |  |  | 9102 | 10212 | 10532 | 10146 | 8675 | 10192 | 9506
DeptA | Person1 | 1750 | 5562 | 5526 | 5285 | 5148 | 5435 | 6167 | 6418
 | Person11 | 1255 | 1641 | 2369 | 1657 | 2254 | 1698 | 1734 | 2083
 | [NAME] | 654 | 1963 | 2355 | 1675 | 1644 | 2422 | 1680 | 2202
 | Person15 | 651 | 1625 | 2191 | 1562 | 2163 | 2468 | 2361 | 1700
 | Person17 | 651 | 2380 | 1772 | 1572 | 1703 | 1709 | 1546 | 1685
 | Person7 | 2485 | 1956 | 1965 | 1583 | 1681 | 1927 | 2099 | 1959
 | Person9 | 251 | 1844 | 1818 | 2050 | 2175 | 1967 | 2442 | 2049
DeptA Total |  |  | 16971 | 17996 | 15384 | 16768 | 17626 | 18029 | 18096
DeptB | Person1 | 1750 | 2474 | 2064 | 2482 | 1876 | 1848 | 2308 | 1890
 | Person10 | 25455 | 2130 | 1676 | 2396 | 1534 | 1815 | 2379 | 2016
 | Person12 | 255 | 1831 | 2334 | 1966 | 2224 | 2087 | 2125 | 2047
 | Person14 | 654 | 2388 | 2083 | 1781 | 2287 | 1666 | 2333 | 2458
 | Person16 | 651 | 1589 | 2069 | 1861 | 2065 | 2477 | 1735 | 1520
 | Person18 | 651 | 1619 | 2145 | 2325 | 2471 | 2076 | 2177 | 1927
 | Person2 | 1300 | 1546 | 2373 | 2062 | 2005 | 2144 | 1533 | 2295
 | Person6 | 1250 | 2071 | 1625 | 1891 | 1875 | 1665 | 2222 | 1979
 | Person8 | 2552 | 1917 | 1767 | 1608 | 2228 | 1508 | 1646 | 1918
DeptB Total |  |  | 17565 | 18136 | 18372 | 18565 | 17286 | 18458 | 18050
Grand Total |  |  | 54216 | 57420 | 54969 | 53808 | 53844 | 56342 | 56795 |  |  |  | Here is my issue.
Spreadsheet: 18a1ff7e-cca5-4cbd-9e8b-1e2bbf7b5781
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
 | 5671.0 Lending Finance, Australia
 | TABLE 5. PERSONAL FINANCE COMMITMENTS, Revolving Credit Stocks and Flows: Australia, Original ($000)
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
New and increased credit limits - Secured ; |  |  | Original | A2413482A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
New and increased credit limits - Unsecured ; |  |  | Original | A2413483C | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
New and increased credit limits - Total ; |  |  | Original | A2413484F | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Cancellations and reductions ; |  |  | Original | A2413485J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Total credit limits at end of month ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Credit used at end of month ; |  |  | Original | A2413487L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: chris_stokley__3853__Harbor Cogen Payment 0700-0900 prod
Sheet: Sheet1

Harbor True-Up Action Itens
 |  |  |  |  |  | Day Ahead less Gas | ISO | Services Desk Profit | Total | Payments | Net
July '00
 |  |  |  |  |  |  | 1683012.18 |  |  | 3179331.16
 |  |  |  | Gas Annuity = |  | 1336995.67
 |  |  |  | Services Desk Annuity = |  | 12843.83
 |  |  |  | EnPower Net
Aug
1.  Enter annuity deal for Services Desk Profit |  |  |  |  |  |  | 2033138.06 | 143934.91 |  | 3412253.44
 |  |  |  | Gas Annuity = |  | 2211292.1
 |  |  |  | Services Desk Annuity =
 |  |  |  | EnPower Net
Sep
1  Wait on ISO completion later this week and enter in |  |  |  |  |  |  | 760530.99 | 73284.24 |  | 1032095.36
ISO deal |  |  |  | Gas Annuity = |  | 1696221.18
2.  Recalc Services Profit |  |  |  | Services Desk Annuity =
2.  Reverse annuity in system (#442268) |  |  |  | EnPower Net
3.  Enter annuity deal for Services Desk Profit
Oct |  |  |  |  |  |  | 163320.38 | 4554.8 |  | 371091.21
1.  Pay Day Ahead Amount less gas
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Nov |  |  |  |  |  |  | -364123 | 14135.28 |  | 410000
1.  Pay Day Ahead Amount less gas
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
5.  Reverse Annuity Deals(# 460487, 460482, 482864, 461206, 462174)
Dec
1.  Pay Day Ahead Amount less gas |  |  |  |  |  |  |  | 0 |  | 0
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Jan
1.  Pay Day Ahead Amount less gas |  |  |  |  |  |  | 16401.56 | 20495.69 |  | 669376.7
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Feb
1.  Pay Day Ahead Amount less gas |  |  |  |  |  |  | 11787 | 0 |  | 27298.16
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Spreadsheet: 166402d1341579394-annual-return-workbook3
Sheet: Sheet1

1 | 4
2 | 2.9
3 | 2.7
4 | 5
5 | 3
6 | 2
7 | 9
8 | 10.22
9 | 8.6
 | 7.3
 | 2.2
 | 1.9
 | 5.5
 | 6
 | 9.3
 | 3
 | 2.3
 | 2
 | 4.4
 | 1.2
 | 3.89
 | 2.99
 | 29
 | 3
Spreadsheet: 707295d1607158377-formula-to-breakdown-time-into-half-hour-segments-sample-etaf
Sheet: Sheet1

What I Have
 |  |  | 09:00:00
 |  |  | 15:00:00
What I Want
 |  |  | 09:00:00
 |  |  | 15:00:00
 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1