tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 469961d1468264148-creating-average-cost-per-claim-bins-and-dates-in-powerpivot-book7
Sheet: Sheet1

 | Claim | Expense | Status | Date
 | 1 | 12 | Paid | 2011-01-01 00:00:00 |  |  |  |  |  | Bins | # of
 | 1 | 20 | No | 2011-01-01 00:00:00 |  | Unique Claims | Sum |  |  | 1 to 50 | 1
 | 2 | 40 | No | 2011-02-01 00:00:00 |  | 1 | 12 |  |  | 51 to 150 | 1
 | 2 | 27 | No | 2011-02-01 00:00:00 |  | 3 | 163 |  |  | 151 to 200 | 3
 | 3 | 71 | Paid | 2011-03-01 00:00:00 |  | 4 | 63
 | 3 | 92 | Paid | 2011-03-01 00:00:00 |  | 8 | 192
 | 4 | 53 | Paid | 2011-04-01 00:00:00 |  | 9 | 158
 | 4 | 10 | Paid | 2011-04-01 00:00:00
 | 5 | 33 | Maybe | 2011-05-01 00:00:00
 | 6 | 45 | IDK | 2011-06-01 00:00:00
 | 7 | 19 | No | 2011-07-01 00:00:00
 | 8 | 42 | Paid | 2011-07-02 00:00:00
 | 8 | 83 | Paid | 2011-07-02 00:00:00
 | 8 | 67 | No | 2011-07-02 00:00:00
 | 9 | 70 | Paid | 2011-08-01 00:00:00
 | 9 | 14 | Paid | 2011-08-01 00:00:00
 | 9 | 74 | No | 2011-08-01 00:00:00
Spreadsheet: 778659d1651211333-shift-pattern-dropdown-list-and-auto-populate-calendar-scheduler-dynamic-filter
Sheet: Monthly Sched

 | MONTHLY SHIFT ROTATION
 | Date | Month | Year | Night | KEY
 |  | May | 2022 |  |  | DAY DUTY
 |  |  |  | Total Shift |  | NIGHT DUTY
 |  |  |  |  |  | DAY OFF
 | Female Required: 3
 | SR | BADGE NO | EMPLOYEE NAME | SHIFT
 | 1 |  |  | Shift A |  | Patrols All Floors Day | Block C 1st Floor Day |  | Block C 1st Floor Night
 | 2 |  |  | Shift B
 | 3 |  |  | Shift C
 | 4 |  |  | Shift D
 | 5 |  |  | Shift E
 | 6 |  |  | Shift F
 | 7 |  |  | Shift G | cctv
 |  |  |  |  |  |  |  |  |  |  |  |  | type here
 |  | Month | Month # | Year |  | Locations |  | Shift | Dynamic Filter |  |  | Search | a | Frequency | Final List
 |  | Jan | 1 | 2022 |  | Block B Access Control Day |  | Day
 |  | Feb | 2 | 2023 |  | Block C Access Control Day |  | Night | Block C Access Control Day
 |  | Mar | 3 | 2024 |  | Block C Access Control Night |  |  | Block C Access Control Night
 |  | Apr | 4 | 2025 |  | Block B 3rd Floor Day |  |  | Block B 3rd Floor Day
 |  | May | 5 | 2026 |  | Block C 1st Floor Day |  |  | Block C 1st Floor Day
 |  | Jun | 6 | 2027 |  | Block C 1st Floor Night |  |  | CCTV Operator Day
 |  | Jul | 7 | 2028 |  | CCTV Operator Day |  |  | CCTV Operator Night
 |  | Aug | 8 | 2029 |  | CCTV Operator Night |  |  | Simulator Access Control Night
 |  | Sep | 9 | 2030 |  | Simulator Access Control Night |  |  | Supervisor Contingency Post Day
 |  | Oct | 10 | 2031 |  | Supervisor Contingency Post Day |  |  | Tamouth Access Control Day
 |  | Nov | 11 | 2032 |  | Supervisor Contingency Post Night |  |  | Tamouth Access Control Night
 |  | Dec | 12 | 2033 |  | Tamouth Access Control Day |  |  | Patrols All Floors Day
 |  |  |  |  |  | Tamouth Access Control Night |  |  | Patrols All Floors Night
 |  |  |  |  |  | Patrols All Floors Day |  |  | Injazat Access Control Day
 |  |  |  |  |  | Patrols All Floors Night |  |  | Injazat Access Control Night
 |  |  |  |  |  | Injazat Access Control Day
 |  |  |  |  |  | Injazat Access Control Night
Spreadsheet: 727a7f35-eaeb-4575-b08b-6c950a35d9af
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
09/04/2004 | Football | EAST CAROLINA | W, 56-23
09/11/2004 | Football | at Central Florida | W, 45-20
09/18/2004 | Football | MARYLAND | W, 19-16 (OT)
09/25/2004 | Football | [NAME] | W, 45-10
10/02/2004 | Football | at Virginia Tech | L, 13-19
10/13/2004 | Football | at Connecticut | W, 31-19
10/21/2004 | Football | SYRACUSE | W, 27-6
10/30/2004 | Football | at Rutgers | W, 35-30
11/06/2004 | Football | TEMPLE | W, 42-21
11/13/2004 | Football | BOSTON COLLEGE | L, 17-36
11/25/2004 | Football | at Pitt | L, 13-16
01/01/2005 | Football | Florida State (Gator Bowl) | L, 18-30
Spreadsheet: 815028d1674696878-overtime-alert-for-full-time-part-time-full-part-time-ot-alert
Sheet: Vorarbeiterliste

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 month | equals | 4.34524 | wekks
[NAME]
[NAME].Nr. | [NAME] | Name | Vorname | Personalnummer | Eintritt | Austritt | Kategorie | AV Std pro Woche | Vertragsart | total hours per Month | Fulltime | Part Time | Mini Job | Alert |  |  |  |  |  |  | [NAME] hours per job/month
1 |  |  |  |  |  |  |  |  | Fulltime | 180 |  |  |  |  |  |  |  | Fulltime | 40 | Fulltime
2 |  |  |  |  |  |  |  |  | Part Time | 90 |  |  |  |  |  |  |  | Part Time | 20 | Part Time
3 |  |  |  |  |  |  |  |  | Mini Job | 45 |  |  |  |  |  |  |  | Mini Job | 10 | Mini Job
4 |  |  |  |  |  |  |  |  | Fulltime | 170
5 |  |  |  |  |  |  |  |  | Part Time | 80
6 |  |  |  |  |  |  |  |  | Mini Job | 40
7
8
Spreadsheet: 06c22432-70a1-4a90-82a8-c3cead0ed558
Sheet: Sheet1

Table 3--U.S. monthly average farm prices and marketings | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  | 2012/13 |  |  |  | 2011/12 |  |  |  | 2010/11
Month |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August |  | 14.4 |  | 10493 |  | 13.6 |  | 11384 |  | 11.7 |  | 10691
September |  | 14.3 |  | 10688 |  | 14.4 |  | 12507 |  | 11 |  | 15095
October |  | 14.3 |  | 13680 |  | 14.7 |  | 11777 |  | 11.5 |  | 17131
November |  | 14.7 | 1/ |  |  | 15 |  | 11615 |  | 12.6 |  | 16929
December |  |  |  |  |  | 14.7 |  | 14954 |  | 13.9 |  | 19137
January |  |  |  |  |  | 14.8 |  | 15387 |  | 14 |  | 21806
February |  |  |  |  |  | 14 |  | 13638 |  | 13.4 |  | 14847
March |  |  |  |  |  | 13.9 |  | 14783 |  | 13 |  | 15844
April |  |  |  |  |  | 14.1 |  | 13336 |  | 13.1 |  | 12727
May |  |  |  |  |  | 13.9 |  | 12960 |  | 12.7 |  | 14227
June |  |  |  |  |  | 14.1 |  | 10524 |  | 12.1 |  | 11317
July |  |  |  |  |  | 14.2 |  | 10199 |  | 12.9 |  | 13369
Average price to date |  | 14.425 | 2/
Season average farm price |  | 15 | 3/ |  |  | 14.3 |  |  |  | 12.7
Average Marketings |  |  |  | 11620.33333333333 |  |  |  | 12755.33333333333 |  |  |  | 15260
Total volume marketed |  |  |  | 34861 |  |  |  | 153064 |  |  |  | 183120
N/A = Not available.
1/ Mid-month only.  2/ Simple average.  3/ Mid-point of season-average farm price projection range.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated December 11, 2012.
Spreadsheet: 30804d1226500163-same-page-printed-but-with-changing-sequential-number-on-it-mrjennings-labels
Sheet: Data

Product 1 | barcode 1 | 2008-12-24 00:00:00 | Six weeks from today will be Wednesday 24 December 2008
Product 2 | barcode 2 | 2008-12-17 00:00:00 | Five weeks from today will be Wednesday 17 December 2008
Product 3 | barcode 3 | 2008-12-24 00:00:00 | Six weeks from today will be Wednesday 24 December 2008
Product 4 | barcode 4 | 2008-12-24 00:00:00 | Six weeks from today will be Wednesday 24 December 2008
Product 5 | barcode 5 | 2008-12-24 00:00:00 | Six weeks from today will be Wednesday 24 December 2008
The shaded areas shown are named areas, which are used when printing labels
Spreadsheet: 053ef7c5-aed4-43bb-abb6-f6a8c1a9fb9c
Sheet: WebSpirs

WebSPIRS ([NAME])
2005-2006
 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | Total | 2005-2006 Price | Price per search
Biological Abstracts
Sessions | 44 | 61 | 178 | 315 | 297 | 114 | 148 | 132 | 246 | 336 | 89 | 91
Searches | 144 | 155 | 518 | 1110 | 983 | 400 | 614 | 420 | 866 | 1181 | 347 | 284 |  | 22306
Turnaways | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 880570d1728373161-how-to-display-how-many-times-salary-revised-and-which-months-koolguys4u-sample-salary-revised-times-aggregate-2019-aligw
Sheet: Sheet1

[NAME] since Joining
[NAME] in
Month | Basic+Allow | Changed
SEP2024 | 12000 | 0
AUG2024 | 12000 | 5
JUL2024 | 11000 | 0
JUN2024 | 11000 | 0
MAY2024 | 11000 | 0
APR2024 | 11000 | 0
MAR2024 | 11000 | 0
FEB2024 | 11000 | 0
JAN2024 | 11000 | 4
DEC2023 | 10000 | 0
NOV2023 | 10000 | 0
OCT2023 | 10000 | 0
SEP2023 | 10000 | 3
AUG2023 | 8000 | 0
JUL2023 | 8000 | 0
JUN2023 | 8000 | 0
MAY2023 | 8000 | 2
APR2023 | 6000 | 0
MAR2023 | 6000 | 1
FEB2023 | 5000 | 0
JAN2023 | 5000 | 0
DEC2022 | 5000 | 0
Spreadsheet: 8397798d-c047-4673-ad07-103d42b1c251
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Image Entertainment | 628261124398 | Various | Adventures Of [NAME] (10-Disc Set) | 2012-10-02 | DVD | Children | 29.98 | Y | Available
Image Entertainment | 14381610628 | Various | Magical Christmas Collection | 2010-10-05 | DVD | Children | 14.98 | Y | Available
Image Entertainment | 14381635225 | Various | Knut & Friends | 2010-01-26 | DVD | Children | 14.98 | Y | Available
Spreadsheet: ad31d929-80f3-4685-be9b-124d7ec725f6
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42227913 | 2014-07-09 15:41:40 | AXIS | 0 | 4 | 5 | 759427 | luger | 7430 | mediterranean | 1942-05-27 | 1942-05-27 | 1st Armoured to the rescue | Engagement blindé
42228174 | 2014-07-09 16:02:56 | ALLIES | 0 | 4 | 5 | 759427 | luger | 7430 | mediterranean | 1942-05-27 | 1942-05-27 | 1st Armoured to the rescue | Engagement blindé
42270640 | 2014-07-12 17:23:33 | ALLIES | 0 | 3 | 5 | 377160 | docsteve | 7366 | mediterranean | 1942-05-27 | 1942-05-27 | Panzers [NAME] | Panzer contre [NAME]
42271002 | 2014-07-12 17:50:29 | AXIS | 1 | 5 | 4 | 377160 | docsteve | 7366 | mediterranean | 1942-05-27 | 1942-05-27 | Panzers [NAME] | Panzer contre [NAME]
42298874 | 2014-07-14 15:45:13 | ALLIES | 1 | 6 | 5 | 1515794 | Bodega28 | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
42299173 | 2014-07-14 16:03:48 | AXIS | 1 | 6 | 5 | 1515794 | Bodega28 | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
Spreadsheet: 840838d1693037153-pull-scores-from-text-pull-scores-form
Sheet: Sheet3

 | 46 | 10–8 | 319 | 1L:343-585:#2 | r18 | 343 | 585 | L
 | 28 | 10–7 | 561 | 2L:405-415:#116 | r17
 | 14 | 10–5 | 630 | 2W:581-380:#119 | r15
 | 25 | 9–5 | 429 | 1L:429-492:#6 | r14
 | 12 | 9–4 | 492 | 2L:421-456:#10 | r13
 | 6 | 9–3 | 527 | 2L:345-488:#14 | r12
 | 4 | 9–2 | 670 | 1L:447-472:#26 | r11
 | 1 | 9–1 | 695 | 2L:415-417:#25 | r10
 | 1 | 9–0 | 697 | 1W:414-362:#30 | r09
 | 1 | 8–0 | 645 | 1W:403-400:#81 | r08
 | 1 | 7–0 | 642 | 2W:381-317:#96 | r07
 | 2 | 6–0 | 578 | 1W:468-411:#33 | r06
 | 4 | 5–0 | 521 | 2W:428-365:#24 | r05
 | 5 | 4–0 | 458 | 1W:579-354:#31 | r04
 | 15 | 3–0 | 233 | 2W:442-363:#141 | r03
 | 28 | 2–0 | 154 | 1W:520-466:#41 | r02
 | 33 | 1–0 | 100 | 2W:400-300:#1 | r01
 | STANLEY NJOROGE
Spreadsheet: 271291d1381896641-sum-with-blank-cell-that-has-if-formula-wip-calculator
Sheet: August

***Balance Sheet is the "holder" of the WIP number.  It should always match report total.
Period 8 | August | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | J
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Over(-) or [NAME]) Status
 |  | Report Total
 |  | Once you have given your final invoice for a project, take the project off this report. |  |  |  |  |  | Report Status
 |  |  |  |  |  |  |  | Prior Period to adjust
Entries for BN Numbers
Period 8 | August |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab.
 |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab.
Journal Entries for Accounting Software
Period 8 | August |  | Journal Entry      Dated August 31
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated September 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | Journal Entry      Dated August 31
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated September 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
Spreadsheet: 834581d1687929498-randomly-but-equally-distribute-workload-among-a-list-of-workers-equal-random-distribution
Sheet: Sheet1

1
List of People | Number of Jobs Assigned | jobs | random | rank |  |  |  | Job Description | Job Assignee
Person A |  |  |  |  |  |  | 1 | Job 1
Person B |  |  |  |  |  |  | 2 | Job 2
Person C |  |  |  |  |  |  | 3 | Job 3
Person D |  |  |  |  |  |  | 4 | Job 4
Person E |  |  |  |  |  |  | 5 | Job 5
Person F |  |  |  |  |  |  | 6 | Job 6
Person G |  |  |  |  |  |  | 7 | Job 7
Person H |  |  |  |  |  |  | 8 | Job 8
Person I |  |  |  |  |  |  | 9 | Job 9
Person J |  |  |  |  |  |  | 10 | Job 10
Person K |  |  |  |  |  |  | 11 | Job 11
Person L |  |  |  |  |  |  | 12 | Job 12
 |  |  |  |  |  |  | 13 | Job 13
 |  |  |  |  |  |  | 14 | Job 14
 |  |  |  |  |  |  | 15 | Job 15
 |  |  |  |  |  |  | 16
 |  |  |  |  |  |  | 17
 |  |  |  |  |  |  | 18
 |  |  |  |  |  |  | 19
 |  |  |  |  |  |  | 20
 |  |  |  |  |  |  | 21
 |  |  |  |  |  |  | 22
 |  |  |  |  |  |  | 23
 |  |  |  |  |  |  | 24
 |  |  |  |  |  |  | 25
Spreadsheet: 786008d1656925661-help-with-some-mathematics-stuff-in-excel-timetempexample
Sheet: Blad1

Target | 1370
 |  | Time 1 | 0:03:00 |  | Temp 1 | 1406
 |  | Time 2 | 0:05:00 |  | Temp 2 | 1400
Difference in minutes
Time 1 in seconds
Time 2 in seconds
Difference in seconds
Difference in degrees
Degrees per minute
Time to target in seconds
Time to target in minutes | 00:15:00 | <-- Correct number should be 00:15:00
Spreadsheet: 823695d1680097639-sumif-formula-to-calculate-cells-in-between-sheets-based-on-cell-dropdown-r-and-ft-gk3
Sheet: Res 2023

 | RESOURCE TRACKER - YYYY
 | Date | Forecast Days (At Strategise/Shape) | Forecast Days (At Initiate) | Change Requests |  | TOTALS
 |  |  |  | Reference | Days
 | TOTALS
 | RESOURCES |  |  |  |  |  | MONTHLY ALLOCATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
 | Name | Business Area | [NAME] | Resource Requested Until | Resource Confirmed Until | Unit Amount | 2023-01-01 00:00:00 |  | 2023-02-01 00:00:00 |  | 2023-03-01 00:00:00 |  | 2023-04-01 00:00:00 |  | 2023-05-01 00:00:00 |  | 2023-06-01 00:00:00 |  | 2023-07-01 00:00:00 |  | 2023-08-01 00:00:00 |  | 2023-09-01 00:00:00 |  | 2023-10-01 00:00:00 |  | 2023-11-01 00:00:00 |  | 2023-12-01 00:00:00
 |  |  |  |  |  |  | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | TOTAL FORECAST | TOTAL FORECAST  TO DATE | TOTAL ACTUALS | TOTAL ACTUALS COST | [NAME]
 |  |  | BA Team Managers | JUN | APR | 500 | 2 | 10 | 1 | 10 | 1 | 10 | 1 | 10 | 1 | 1 | 1 |  | 1
 |  |  | BI Life |  |  |  | 1 | 1.3 | 1 | 1.3 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Automation test |  |  |  | 2 | 2.4 | 1 | 1.2 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | BillingCenter |  |  |  | 1 | 1.3 | 1 | 1.3 | 0.5 | 0.7 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Project Manager |  |  |  | 1 | 1.2 | 2 | 2.4 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | MI Tester |  |  |  | 1 | 1.3 | 1 | 1.3 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Technical Service Owner |  |  | 0 | 1 | 1.2 | 0.5 | 0.7 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | MDM |  |  |  | 1 | 1.3 | 1 | 1.3 | 0.5 | 0.7 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Print ISIS Papyrus |  |  | 500 | 10 | 0.7 | 11 | 1.2 | 12 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Test WSL |  |  |  | 1 | 1.3 | 0.5 | 0.7 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 | TOTALS DAYS
 | TOTALS IN £s
Spreadsheet: 120709d1315475201-lookup-multiple-returns-book2-version-1-
Sheet: Andy

Attribute | Postcode | Postcode | Postcode
E-A-09/01/1970-m | #N/A | #N/A | #N/A
C-A-02/02/1990-m | #N/A | #N/A | #N/A
V-A-26/06/1973-f | #N/A | #N/A | #N/A
C-A-15/08/1981-m | Unknown | UNKNOWN | UNKNOWN
D-B-14/11/1986-m | #N/A | #N/A | #N/A
D-B-13/11/1974-m | CF24 3AG | Unknown | Unknown
S-B-12/07/1979-m | #N/A | #N/A | #N/A
R-B-14/09/1975-m | #N/A | #N/A | #N/A
A-B-06/11/1984-m | CF24 2QJ | CF24 2QJ | CF24 2QJ
M-B-24/09/1974-m | #N/A | #N/A | #N/A
H-B-09/08/1973-m | #N/A | #N/A | #N/A
K-B-11/03/1963-f | CF24 4TY | #N/A | #N/A
L-C-09/07/1980-f | #N/A | #N/A | #N/A
R-C-01/08/1989-m | #N/A | #N/A | #N/A
P-C-11/09/1972-m | #N/A | #N/A | #N/A
A-C-26/02/1971-m | CF63 4QR | #N/A | #N/A
R-D-25/07/1982-m | #N/A | #N/A | #N/A
O-D-07/01/1989-f | #N/A | #N/A | #N/A
S-D-25/06/1974-m | #N/A | #N/A | #N/A
L-D-25/04/1976-m | #N/A | #N/A | #N/A
L-D-29/01/1976-m | #N/A | #N/A | #N/A
D-D-28/01/1981-m | unknown | Unknown | Unknown
R-E-16/05/1986-m | #N/A | #N/A | #N/A
S-E-13/06/1974-m | #N/A | #N/A | #N/A
A-E-07/12/1961-m | #N/A | #N/A | #N/A
C-E-24/02/1980-m | CF63 4AT | #N/A | #N/A
R-F-16/02/1982-m | #N/A | #N/A | #N/A
C-F-26/09/1972-m | CF24 3AT | CF11 8AH | CF11 8AH
D-F-08/03/1983-m
C-G-27/08/1970-m
A-G-14/12/1974-m
S-H-25/01/1974-m
S-H-17/12/1985-m
M-H-12/03/1974-m
A-H-26/01/1983-m
G-H-14/02/1976-m
D-H-05/11/1978-m
S-J-18/10/1980-m
P-K-15/11/1963-m
T-L-03/04/1981-m
C-L-17/12/1964-m
S-L-31/03/1990-m
[NAME]
L-M-06/01/1966-m
S-M-10/04/1974-m
C-M-02/03/1974-m
W-M-18/12/1985-m
M-N-13/11/1968-m
L-O-04/06/1977-m
H-O-08/11/1979-f
M-P-10/04/1981-m
J-P-18/05/1979-m
J-P-09/06/1972-m
P-R-25/01/1972-m
J-R-25/09/1983-m
D-R-16/02/1961-m
D-S-14/12/1987-m
P-S-09/01/1981-m
M-S-03/04/1985-m
D-T-06/02/1990-m
E-T-11/03/1969-m
C-V-29/09/1965-m
G-W-08/07/1976-m
J-W-21/01/1986-m
C-W-05/06/1977-m
A-W-23/03/1957-m
L-W-24/02/1990-m
R-W-30/06/1972-m
M-Y-02/01/1983-m
Spreadsheet: 785268d1656319855-sum-calculations-for-specific-data-in-another-column-voucher-tracker
Sheet: Dashboard

Voucher Tracker |  |  |  | Project Allocation
£10 Vouchers |  |  |  | W4Y | WW4E | FB | CL/FL
Issued | Remaining | Value issued
£20 Vouchers
Issued | Remaining | Value issued
Spreadsheet: 683937d1593061534-if-then-statement-to-output-tag-logic-update-to-account-for-dates-book1
Sheet: Sheet1

STATUS | DUE DATE | COMPLETE DATE | MAX | RECLASS | FORECAST | Result | expected value
B | 2017-12-22 00:00:00 |  |  | On Hold |  |  | N/A | If Column D is not present, output N/A
A | 2017-12-01 00:00:00 |  |  | On Hold |  |  | N/A | If Column D is not present, output N/A
B | 2020-01-10 00:00:00 |  | 2020-01-17 00:00:00 | On Hold |  |  | N/A | Column D has date in the past, output N/A -> Working as Expected
A | 2020-07-06 00:00:00 |  | 2020-06-01 00:00:00 | On Hold |  |  | N/A | Column D has date in the past in current month (June), output N/A instead of June-20
B | 2020-06-06 00:00:00 |  | 2020-06-27 00:00:00 | On Hold |  |  | June-20 | Column D has date in the in June (future date within current month), Working as Expected
A | 2020-06-10 00:00:00 |  | 2020-06-25 00:00:00 | On Hold |  |  | June-20 | Column D has date in the in June (future date within current month), Working as Expected
B | 2020-07-06 00:00:00 |  | 2020-06-01 00:00:00 | On Hold |  |  | N/A | Column D has date in the past in current month (June), output N/A instead of June-20
A | 2020-07-10 00:00:00 |  | 2020-07-10 00:00:00 | On Hold |  |  | N/A | Column D is in the future (July) -> output N/A. Working as expected
In-Process | 2020-07-02 00:00:00 |  | 2020-07-02 00:00:00 | In Process |  |  | N/A | Working as expected - future date in July
In-Process | 2020-06-26 00:00:00 |  | 2020-06-29 00:00:00 | In Process |  |  | June-20 | Working as expected - future date in June
Available | 2020-07-02 00:00:00 |  | 2020-07-02 00:00:00 | Available |  |  | N/A | Dates are in July (working as expected)
Available | 2020-06-26 00:00:00 |  | 2020-06-29 00:00:00 | Available |  |  | June-20 | Working as expected - future date in June
In-Process | 2020-06-02 00:00:00 |  | 2020-06-29 00:00:00 | In Process |  |  | June-20 | Working as expected - future date in June
In-Process | 2020-06-02 00:00:00 |  | 2020-06-22 00:00:00 | In Process |  |  | N/A | Dates are in the past in June
Available | 2020-06-02 00:00:00 |  | 2020-06-22 00:00:00 | Available |  |  | N/A | Dates are in the past in June
Available | 2020-06-02 00:00:00 |  | 2020-06-29 00:00:00 | Available |  |  | June-20 | Working as expected - future date within current month (June)
For Review | 2020-06-27 00:00:00 |  | 2020-07-10 00:00:00 | For Review |  |  | June-20 | Working as expected - future date within current month (June)
For Review | 2020-07-01 00:00:00 |  | 2020-07-10 00:00:00 | For Review |  |  | N/A | Working as expected
For Review | 2020-06-10 00:00:00 |  | 2020-07-10 00:00:00 | For Review |  |  | N/A | Dates are in the past in June
For Review | 2020-06-15 00:00:00 |  | 2020-07-10 00:00:00 | For Review |  |  | N/A | Dates are in the past in June
Spreadsheet: 809266d1670997691-attendance-tracker-pto-tracker-ex-ans
Sheet: January

 | Employee PTO
 | Dayoff Type |  | Holiday |  |  | X | PTO |  |  | N | NOT-APPROVED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year: |  | Month code
 |  | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023 |  | 1
 | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Changed formulas and formats in 5th and 6th row.
 | Total
Spreadsheet: sally_beck__35204__EGM_MgmtSum-Q4-1026
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON GLOBAL MARKETS
2000-12-01 00:00:00 | 4TH QUARTER 2000 DETAIL OF GROSS MARGIN
M.QTD
ENA
 |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Margin
 | Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME]
 | Liquids |  | -16704 | 0 | 0 | 0 | 0 |  |  | 0 |  | 30000
COAL | Coal |  | 3760 |  | 79.724 | 0 | 0 |  |  | 0
SO2 | Emissions |  | 664 | 0 | 0 | 0 | 0 |  |  | 0
WEATHER | Weather |  | 163.371 | 0 | 0 | 0 | 0 |  |  | 0
INSURANCE | Global Risk Markets |  | 0 | 0 | 0 | 0 | 0 |  |  | 0
ECT_INV_IRFX | Equity Trading |  | -1772.26056 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | FX / Int Rate Trading |  | -80.176 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Soft Commodities Trading |  | 65.33375 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Grain Trading |  | 56.3325 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Meat Trading |  | -33.3155 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Financial Trading
 | Transportation |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Office of the Chairman |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Overview |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 10100
 | Subtotal Commercial
 | LNG |  | 0 | 0 |  | 0 | 0 |  |  | 0
 | Middle East |  | 0 | 0 |  | 0 | 0 |  |  | 0 |  | 3965
 | Puerto Rico |  | 0 | 0 |  | 0 | 0 |  |  | 0
 | Subtotal LNG / ME / PR
 | Subtotal Gross Margin
 | Other Interest Related Charges |  | 0 | 0 | 0 | -520 | 0 |  |  | 0
 | EGM Gross Margin
 | (1) Excludes Cap. Charge & Operating Costs
Spreadsheet: 684681d1593499300-indentfying-a-number-between-field-example
Sheet: Lookup

SECTION_CO | Start Value Range | End Value Range | Slight
A34/B/01 | 200 | 300 | S
A34/B/01 | 400 | 422 | S
A34/D/01 | 0 | 100 | S
A34/D/01 | 400 | 500 | S
A34/D/01 | 500 | 600 | S
A34/D/01 | 800 | 900 | S
Spreadsheet: 206581d1358231884-000-zzz-range-in-excel-000-zzz
Sheet: Sheet2

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0