tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 782515d1654092513-count-specific-data-with-info-needed-from-other-columns-as-well-question-example
Sheet: Sheet1

8 | Active
1 | Lapsed |  |  |  |  | Active | Renewal overdue | Lapsed | Pending New | Pending Renewal
5 | Renewal overdue |  |  |  | 1
9 | Lapsed |  |  |  | 2
9 | Pending New |  |  |  | 3
5 | Active |  |  |  | 4
3 | Pending Renewal |  |  |  | 5
10 | Active |  |  |  | 6
8 | Pending Renewal |  |  |  | 7
6 | Pending New |  |  |  | 8
9 | Pending New |  |  |  | 9
10 | Active |  |  |  | 10
5 | Active
10 | Active
3 | Lapsed
9 | Lapsed
1 | Pending New
6 | Active
9 | Pending New
6 | Active
3 | Active
8 | Pending Renewal
9 | Pending Renewal
8 | Pending New
1 | Active
5 | Active
2 | Active
6 | Active
3 | Active
1 | Active
8 | Active
3 | Active
6 | Lapsed
10 | Lapsed
1 | Pending New
4 | Active
Spreadsheet: 854934d1704699666-creating-a-3rd-sheet-with-allowed-ids-and-associated-information-from-a-pivot-table-beispiel
Sheet: Final

Debitor | Buchungsdatum | Belegart | Belegnummer | Belegdatum | Fälligkeitsdatum | Beschreibung | Betrag
200001 | 2023-12-05 00:00:00 | Rechnung | 666666 | 2023-12-10 00:00:00 | 2024-01-09 00:00:00 | Rechnung | 253.53
200003 | 2023-03-31 00:00:00 | Rechnung | 123123 | 2023-12-06 00:00:00 | 2024-02-06 00:00:00 | Rechnung | 5000
200003 | 2022-08-12 00:00:00 | Rechnung | 421565 | 2023-08-12 00:00:00 | 2022-10-26 00:00:00 | Rechnung | -213
Debitor | Buchungsdatum | Belegart | Belegnummer | Belegdatum | Fälligkeitsdatum | Beschreibung | Betrag
 | 2023-12-05 00:00:00 | Rechnung | 666666 | 2023-12-10 00:00:00 | 2024-01-09 00:00:00 | Rechnung | 253.53
200003 | 2023-03-31 00:00:00 | Rechnung | 123123 | 2023-12-06 00:00:00 | 2024-02-06 00:00:00 | Rechnung | 5000
Spreadsheet: 101035a7-9b4a-416a-ae40-947f5b49c215
Sheet: Sheet1

2010-09-14 00:00:00 | State Senate District 1 - Democratic | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
page 1 of 2 | [NAME], d | Gallus, r | [NAME]
Albany | 30 |  | 1
Atkinson and [NAME]. Gt. | 0
[NAME] | 98 |  | 2
Bean's Grant | 0
Bean's Purchase | 0
[NAME] | 112 | 3
[NAME] | 158 | 5 | 2
[NAME] 3 | 154 | 5
[NAME] 4 | 147 | 3 | 1
Bethlehem | 100 |  | 2
Cambridge | 0
Carroll | 31 |  | 1
[NAME]'s Purchase | 0
[NAME] | 10
Colebrook | 48 | 2 | 2
Columbia | 10
Crawford's Purchase | 0
Cutt's Grant | 0
[NAME] | 30
Dix's Grant | 0
Dixville | 3
Dummer | 8
Errol | 10 | 1 | 1
Erving's Location | 0
Franconia | 97 |  | 2
[NAME] | 159 | 6 | 5
Green's Grant | 0
Hadley's Purchase | 0
Hale's Location | 6
Hart's Location | 5
[NAME] | 81
[NAME] | 39
Kilkenny | 0
Lancaster | 108 | 1
Lincoln | 47 | 2
Lisbon | 32 |  | 1
Littleton | 180 | 1 | 2
Livermore | 0
Low and Burbank's Grant | 0
[NAME] | 32
Martin's Location | 0
Milan | 58
[NAME] | 0
Northumberland | 87 | 5
[NAME] | 0
[NAME]'s Grant | 0
Pittsburg | 17
 | State Senate District 1 - Democratic
page 2 0f 2 | [NAME], d | Gallus, r | [NAME]
Randolph | 41
Sargent's Purchase | 0
Second College Grant | 0
Shelburne | 25
[NAME] | 12
Stewartstown | 0
[NAME] | 16
Success | 0
[NAME] | 41
Thompson & Meserve's Purchase | 0
Waterville Valley | 28
Wentworth's Location | 0
[NAME] | 93 | 3 | 1
Totals | 2153 | 37 | 23
Spreadsheet: 697933d1601624885-comparing-and-defining-3-exact-digits-in-type-and-number-in-two-different-sheets-compare-exact
Sheet: Sheet1

90 | 10 | 0
73 | 27 | 0
22 | 56 | 22
100 | 0 | 0
73 | 27 | 0
82 | 18 | 0
60 | 40 | 0
80 | 20 | 0
0 | 10 | 90
100 | 0 | 0
40 | 30 | 30
73 | 27 | 0
89 | 0 | 11
100 | 0 | 0
0 | 18 | 82
78 | 11 | 11
56 | 44 | 0
67 | 11 | 22
40 | 40 | 20
82 | 18 | 0
73 | 27 | 0
22 | 56 | 22
0 | 10 | 90
89 | 0 | 11
100 | 0 | 0
0 | 18 | 82
78 | 11 | 11
0 | 0 | 0
Spreadsheet: 827859d1683079923-3-criteria-lookup-in-excel-2021-match3-1-
Sheet: Sheet1

 |  |  | Tulip | < [NAME]
Criteria 3
 | Profit | Loss | < [NAME]
Lion
Parrot
Apple
Mango
Total
Spreadsheet: 823560d1680015813-first-three-characters-in-cell-should-be-alpha-if-not-mark-as-fail-alpha-comparison-tms
Sheet: Sheet1

 | TMS 1 | TMS 2 | TMS 3 | CS
ABC1234XYZ
ABc1234XYZ
AbC1234XYZ
[NAME]
Abc1234XYZ
abC1234XYZ
ABCD1234XYZ
ABCd1234XYZ
ABcd1234XYZ
Spreadsheet: 851983d1702091051-need-help-with-combining-percentages-and-linking-names-evaluation-test
Sheet: Sheet1

 |  | Evaluation of Cost: |  | 0.05 |  |  |  | Evaluation of Cost: Financial Rationale and Planning |  |  |  |  | 0.15
 |  | provider 1 | provider 2 | provider 3 |  |  |  | provider 1 |  | provider 2 |  | provider 3 |  |  | Evaluation of Cost Result |  | 0.05
 |  |  |  |  |  |  |  | 0-5 |  | 0-5 |  | 0-5 |  | Ranking | Percentage | Name | Column1
 |  |  |  |  |  |  |  | AM |  | AM |  | AM |  | 1
 |  | 5 | 6 | 7 |  |  |  | 3 |  | 2 |  | 1 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0.1 | Provider 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Evaluation of Cost Result |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Ranking | Percentage | Name | Column1
 | Total Cost |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | Percentage Score |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | Ranking
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Score
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Ranking | Percentage | Name
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Ranking | Percentage | Name
 |  |  |  |  |  |  |  |  |  |  |  |  |  | provider 2 | 0.1016666666666667 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | provider 3 | 0.06571428571428573 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Provider 4 | 0.1 | 3
Spreadsheet: 829758d1684425122-need-to-add-cells-j9-j16-for-all-icoy-working-capital-inside-ifna-formula-feb23-trial-balances-lse-test
Sheet: 211 Bank Rec

 | Bank Name | Bank of America
 | Account Number | 4451319184
 | Month Ending | 2022-08-31 00:00:00
 | Company Name | 211 North Harbor Drive Owner LLC
 | Account Name | 211 North Harbor Drive Owner LLC
 | Trial Balance Account | 311102 / 311127
 | Opening Balance Per Trial Balance - Aug 2022
 | CIBC Bank USA |  | -10000
 | Lendlease Development Inc. |  | -7945.67
 | Restoration Hardware Inc |  | -21124.48
 | DM Luxury LLC |  | -10000
 | The Peoples Gas |  | -30650.13
 | Levenfeld Pearlstein LLC |  | -6670
 | Levenfeld Pearlstein LLC |  | -4477.5
 | Span Studio LLC |  | -749
 | Span Studio LLC |  | -14459
 | Span Studio LLC |  | -9021.5
 | Span Studio LLC |  | -4274
 | EarthCam Inc |  | -2486.3
 | Near North National Title LLC |  | -285
 | Program Maintenance Inc DBA Service One Inc |  | -5680
 | Scrub King Group LLC |  | -3502
 | CIBC Bank USA |  | -10000
 | CIBC Bank USA |  | -10000
 | Cirrus Condominium Association |  | -207849.67
 | Community Management Systems LLC |  | -756.76
 | [NAME] dba Wolf Residential Group LLC |  | -6627.65
 | [NAME] dba Wolf Residential Group LLC |  | -20000
 | [NAME] dba Wolf Residential Group LLC |  | -5416.67
 | [NAME] dba Wolf Residential Group LLC |  | -18000
 | H.M. Witt & Co. Signs |  | -1715.7
 | H.M. Witt & Co. Signs |  | -6667.9
 | H.M. Witt & Co. Signs |  | -412.43
 | H.M. Witt & Co. Signs |  | -2956.31
 | Knightsbridge Strategies Ltd |  | -10600
 | Lendlease Development Inc. |  | -2206.59
 | [NAME] DBA McGuire Architectural Interiors LLC |  | -1317.08
 | Span Studio LLC |  | -2010.1
 | [NAME] |  | -3440
 | Riemer & Braunstein LLP |  | -21805
 | Lendlease Platform Development LLC |  | -235478.46
 | Magellan Project Services II LLC |  | -78492.82
 | June 2022 Bank Fees |  | -492.52
 | July 2022 Bank Fees |  | -421.32
 | Draw # 45 |  | 620636.86
 | North Harbor Settlement - July 2022 |  | 5103115.14
 | Closing Trial Balance - Aug 2022
 | Known Reconciling Items - GL (Service Fee)
 | N Harbor Settlement (Move to Loan Account) |  | -5103115.14
 | Total
 | Balance Per Bank: |  | 447607.24
 | Difference
 | Known Reconciling Items - Bank (Unpresented Checks)
 | Near North National Title LLC |  | -285
 | Program Maintenance Inc DBA Service One Inc |  | -5680
 | Scrub King Group LLC |  | -3502
 | Total
 | Unknown Reconciling Difference
Spreadsheet: 125953d1319429741-which-function-to-copy-data-from-many-sheets-to-a-sheet-in-same-file-data-from-many-sheets-to-one-sheet
Sheet: 2011

 | Type | Code | Size | Amount | Price
 | Shoe | RC1071 | 110 | 1 | 2800000
 | Belt | 1585 | 7.5 | 1 | 25000000
 | Shoe | RC1071 | 110 | 1 | 2800000
 | Belt | 1585 | 7.5 | 1 | 25000000
 | Shoe | 1331 | 42 | 1 | 2000000
Spreadsheet: 648412d1573040298-calculate-based-on-month-and-country-code-test-data
Sheet: Actuals

MONTH_NUM | COUNTRY_CODE | TOTAL_HRS | Actual FTE
7 | 709 | 8
7 | 710 | 9
8 | 709 | 9
8 | 712 | 10
8 | 713 | 6
8 | 714 | 33
9 | 709 | 45
9 | 716 | 11
9 | 717 | 17
9 | 718 | 8
10 | 719 | 18
10 | 720 | 10
10 | 721 | 45
11 | 722 | 18
11 | 723 | 45
12 | 709 | 87
12 | 627 | 15
Spreadsheet: jeff_dasovich__14197__PS_3
Sheet: 8.19

8.19
 | (a)-(c) | Objective:  Minimize annual shipping miles
 |  | Carpet Mill Locations | X         Coordinate | Y         Coordinate
 |  | Tower | 12.41156278007282 | 29.69962381142105 | Distance to plant | Maximum Alllowed | # of deliveries | Changing cells are outlined in bold
 |  | [NAME] | 9 | 43 |  | 50 | 130
 |  | Rome | 2 | 28 |  | 50 | 75
 |  | Canton | 51 | 36 |  | 50 | 90
 |  | Kennesaw | 19 | 4 |  | 50 | 80
 |  |  |  | Total |  | <====Target cell to minimize
 |  |  |  | # of shipping miles
 |  | [NAME]
 |  | Need to be within 50 miles of each location.
 | (d)
 |  | Carpet Mill Locations | X         Coordinate | Y         Coordinate
 |  | Tower | 12.41156278007282 | 29.69962381142105 | Distance to plant | Maximum Alllowed | # of deliveries | Changing cells are outlined in bold
 |  | [NAME] | 9 | 43 |  | 50 | 130
 |  | Rome | 2 | 28 |  | 50 | 75
 |  | Canton | 51 | 36 |  | 50 | 90
 |  | Kennesaw | 19 | 4 |  | 50 | 80
 |  |  |  | Total
 |  |  |  | [NAME]. |  | <====Target cell (minimize)
 |  |  |  | # of shipping miles
 | (e)
 |  | Carpet Mill Locations | X         Coordinate | Y         Coordinate
 |  | Tower | 27.21015259947551 | 27.65031241617399 | Distance to plant | Maximum Alllowed | # of deliveries | Changing cells are outlined in bold
 |  | [NAME] | 9 | 43 |  | 50 | 130
 |  | Rome | 2 | 28 |  | 50 | 75
 |  | Canton | 51 | 36 |  | 50 | 90
 |  | Kennesaw | 19 | 4 |  | 50 | 80
 |  |  |  | Total
 |  |  |  | [NAME]. |  | <====Target cell
 |  |  |  | # of shipping miles
Spreadsheet: 208905d1358959840-copy-ranges-of-data-from-master-sheet-to-slave-sheets-time-off-2013
Sheet: January

January 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Personal |  |  | Sick |  |  | Vacation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Has | Used | Remaining | Has | Used | Remaining | Has | Used | Remaining
EMPLOYEE | 1 | 2 | 3 | 4 | 5 | 6 | 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
 | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th
Drivers
Employee 01 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 7 |  |  | 20
Employee 02 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 7 |  |  | 20
Employee 03 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 7 |  |  | 25
Employee 04 | H |  | S | S |  |  | S | S | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 7 |  |  | 15
Employee 05 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 7 |  |  | 20
Employee 06 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P |  | S |  |  |  |  |  |  |  |  | 6 |  |  | 7 |  |  | 15
Employee 07 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 7 |  |  | 20
Warehouse/Attendant
Employee 08 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 7 |  |  | 20
Employee 09 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 7 |  |  | 10
Employee 10 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 7 |  |  | 5
Mechanics
Employee 11 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V | V | V | V | V |  |  |  |  |  |  | 6 |  |  | 7 |  |  | 20
Employee 12 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 7 |  |  | 5
Employee 13 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 7 |  |  | 5
KEY
Name (Weeks Vacation, Departmental Seniority Rank)
P=Personal Day
S=Sick Day
J=Jury Duty
V=Vacation Day
H=Holiday
Spreadsheet: 752879d1635059996-find-1st-nearest-values-of-10-24102021-nearest-value-sample-file
Sheet: sample1

CEOI | STRIKE PRICE | PEOI | Ratio |  |  | Break even | 18114.9
5016 | 16000 | 36438
244 | 16100 | 975 |  |  |  | 2543 | 17400 | 29878 |  | Lower limit
383 | 16200 | 1930
502 | 16300 | 7003
424 | 16400 | 2095 |  |  |  | 111087 | 18400 | 18638 |  | Upper limit
8458 | 16500 | 41438
608 | 16600 | 5443
1360 | 16700 | 9274
699 | 16800 | 18875
1121 | 16900 | 14819
10634 | 17000 | 71491
1163 | 17100 | 16730
2441 | 17200 | 29798
2507 | 17300 | 29293 |  | 2nd highest nearest value
2543 | 17400 | 29878 |  | 1st nearest value of 10
12804 | 17500 | 77307
6084 | 17600 | 35145
10562 | 17700 | 38557
15884 | 17800 | 54089
12240 | 17900 | 45247
45133 | 18000 | 72252
39033 | 18100 | 47283
128297 | 18200 | 66434
109825 | 18300 | 33657
111087 | 18400 | 18638 |  | 1/10th lowest nearest value
122095 | 18500 | 36373
65408 | 18600 | 16462
64751 | 18700 | 1570 |  | 2nd Lowest nearest value
86762 | 18800 | 1321
35975 | 18900 | 271
130140 | 19000 | 9359
68167 | 19100 | 138
Spreadsheet: 737145d1624230981-some-formulas-outside-the-table-will-not-update-when-new-records-added-to-table-journal1
Sheet: summary

 |  |  |  | Last
 |  |  |  |  | 3
 |  |  |  |  |  | x
 |  |  |  |  |  | x
 |  |  |  |  |  | x
 |  |  |  |  |  | x
 |  |  |  |  |  | Always work
 |  |  |  |  |  | Always work
 |  |  |  |  |  | Always work
 |  |  |  |  |  | x
 |  |  |  |  |  | x
 |  |  |  |  |  | x
 |  |  |  |  |  | x
 |  |  |  |  |  | x
Spreadsheet: 826904d1682363242-sumifs-formula-help-book1
Sheet: Formula Tab

18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
18888174.5
Spreadsheet: phillip_m_love__30649__9907_OA
Sheet: ONT_GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
REGION:  ONTARIO
REGION:  ONTARIO
 |  |  | Total |  | Reclasses |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  | -30253 | -3054 | -399408 | 5192 |  |  |  |  | 0 | 0
2 |  | Liquidations
3 |  | Interdesk |  |  |  |  | 3846962 | 8853966 | -2751261 | -6319175 |  |  | 785663 | 1812633 | 1057025 | 2431534 | 908573 | 2075008
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  | -15312983 | -35399006 | 41911 | -114796 |  | 145500 | -587530 | -9277
7 |  | Liquidations
8 |  | Interdesk |  |  |  |  | 0 | 0 |  |  |  |  | -785663 | -1812633 | -1057025 | -2431534 | 1842688 | 4244167
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  | -1107871 | -2891543 | 1107871 | 2891543 | 0 | -933471 | -473130 | 933471
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage |  |  |  |  |  |  |  |  |  |  |  | -933471
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  | 0 | 1631732 | 4258821 | 399408 | 1042455 | 1060660 | 2768323 | 0 | 0 | -2751261 | -7180791 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
23 | Fuel: |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  |  |  | 0
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  | 0 |  | 0
34 |  | Originations
35 |  | Broker Fees |  |  |  |  |  |  |  |  |  | -440
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | 0 |  | 0
 |  | TOTAL
FT-Ontario
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | -144165 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | -10208.76 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 862589d1710265938-how-to-pull-data-from-the-next-available-date-if-the-date-isnt-an-exact-match-problem-sample-workbook
Sheet: analysis

date | actual | expected | last | Match | Index | [NAME]
2020-05-12 00:00:00 | -0.008 | -0.008 | -0.004
2020-04-10 00:00:00 | -0.004 | -0.003 | 0.001
2020-03-11 00:00:00 | 0.001 | 0.002 | 0.001
Spreadsheet: stacey_white__38968__2001 Audit Issues Resolution Database-S White
Sheet: Sheet1

2001 Audit Issue Resolution
Report Name | Findings | Action Steps | [NAME] | Responsible Party | Monitoring Comments | Resolution
Power Trading Audit Observations | Short power and gas positions of 1.6 MMwh and 2.1 Bcf, respectively, were executed during first and second quarter 2001.  These transactions did not qualify for hedge accounting under SFAS 133, but were not properly marked to market during the appropriate accounting period, resulting in a cumulative misstatement to earnings of $42 million.  In addition, Financial Operations personnel was not aware of these omitted transactions nor were daily P&L reports being prepared for senior management. | The following minimum steps should be taken to ensure that non mark to market transactions are accounted for properly:       · Immediate communication with Financial Operations and RAC personnel via adequate deal documentation (deal ticket, deal “write-up”, etc.);                                        · Documentation of basis for accrual accounting (i.e. hedge accounting, affiliate position, etc.);                                                     · Daily/Weekly/Monthly reporting of P&L to senior management; and                             · Maintenance of accrual positions within RiskTrac. | 2001-08-31 00:00:00 | [NAME]
C | As a result of the anomalies in the West market, management has not consistently accounted for transmission contracts.  Currently, management accounts for these contracts on an accrual basis | Transmission contracts should be accounted for at fair value  in accordance with EITF 98-10 since they qualify as energy-trading contracts.  If anomalies exist that cause management to question valuation, justifiable adjustments may be made, but must also be documented. | 2001-12-31 00:00:00 | [NAME]       [NAME]
D | Due to the absence of a correlation matrix as well as the addition to and changes in curves traded in the East,  transmission deals are currently not accounted for under mark-to-market accounting. | Transmission contracts should be accounted for at fair value in accordance with EITF 98-10 since they qualify as energy-trading contracts.  Management should consider putting in place a correlation matrix to properly value these deals. | 2001-12-31 00:00:00 | [NAME]       [NAME]
E | Management is currently involved in TCC contracts and previously FTR contracts.  These contracts  should normally be accounted for under mark-to-market accounting, however as there is no liquid market for them, they are unable to be marked.  Although, the risk exposure is rigorously monitored by reviewing congestion patterns and other daily market information, these contracts expose the company to risk that can not be monitored within the standard, preestablished risk and VAR limits | All levels of management should be aware of the risks created from these contracts.  In addition, management should determine how these risks should be appropriately captured and reported | 2001-09-30 00:00:00 | [NAME]
Spreadsheet: 07204fac-550d-413b-8a85-e5c551e57dd8
Sheet: Sheet1

SEATTLE UNIVERSITY | 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
TEMPORARY  EMPLOYEE TIME REPORT
PAY PERIOD: 11TH THROUGH THE 25TH, 26TH THROUGH THE 10TH OF THE FOLLOWING MONTH
NAME: |  |  |  |  | DEPT: |  |  | (Use 4 letter-code as shown on paystub under DEPT)
Datatel ID Number:
Pay Period: |  |  |  | TO |  |  |  | (example: 9/10/12-9/25/12)
Regular Pay |  |  |  | RP
Sick Pay |  |  |  | SP
TOTAL |  |  |  |  | 0 |  |  |  | Employee Signature |  |  |  | Date
Overtime (1.5 rate)
 | (If total hours worked (Sunday-Saturday) is above 40)
TOTAL |  |  |  |  |  |  |  |  | Supervisor Signature |  |  |  | Date
 | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 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
Spreadsheet: 131efada-6a6c-4c22-9e27-dc1b3e5363fd
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 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29
 | (m.p.) |  |  | L i s t a    p ł a c   n r : |  |  |  | [NAME], rok |  |  |  |  | u w a g i  :
 | Lp. | Imię i nazwisko Nr identyfikacyjny |  | [NAME] tytułu umowy zlecenie |  | Podstawa naliczania  składek na ubezpieczenia społeczne |  | Odliczenia od dochodu składki na ubezpieczenia społeczne |  |  |  |  | [NAME]  uzyskania przychodu |  | Podstawa wymiaru na ubezpieczenia społeczne |  | Podstawa naliczania podatku dochodowego |  | Potrącona zaliczka na podatek dochodowy 19% |  | Składka na ubezpieczenie zdrowotne |  | Składka na ubezpieczenie zdrowotne podlegająca odliczeniu od zaliczki na podatek dochodowy |  | [NAME] na podatek dochodowy do wpłaty do US |  | Składka na ubezpieczenie zdrowotneniepodlegająca odliczeniu od zaliczki  na podatek dochodowy |  | Do wypłaty
 |  |  |  |  |  |  |  | Emerytalne | Rentowe | Chorobowe | Razem
 | 1 | 2 |  | 3 |  | 4 |  | 5 | 6 | 7 | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17
 |  |  |  |  |  |  |  | 9,76% x kol. 4 | 6,5% x kol. 4 | 2,45% x kol. 4 | Kol. 5 + 6 + 7 |  | (kol. 4 - kol. 8) 0,20 |  | Kol. 4 - 8 |  | Kol. 4 - 8 - 9 |  | Kol. 11 x 0,19 |  | 8,50% x kol. 10 |  | 7,75% x kol. 10 |  | Kol. 12 - 14 |  | Kol. 13 - 14 |  | Kol. 4 - 8 - 13 - 15
 | © www.signform.pl Sp. z o.o., e-mail: [EMAIL], tel. (0-22) 337-11-51, fax: (0-22) 337-11-52 |  |  |  |  |  |  |  |  |  |  |  | © www.signform.pl Sp. z o.o., e-mail: [EMAIL], tel. (0-22) 337-11-51, fax: (0-22) 337-11-52