tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 811664d1672735356-grade-should-not-show-for-the-subjects-for-which-marks-obtained-are-empty-book7
Sheet: Sheet1

Subject | Marks Obtained | Total Marks | % | Grade | Expected Results
Urdu | 53 | 75 | 70.66666666666667 |  | B
English | 50 | 75 | 66.66666666666667 |  | C+
S.Study |  |  | 0
Maths | 0 | 75 | 0 |  | F
Chemistry | 26 | 60 | 43.33333333333334 |  | E
Islamyat | 27 | 50 | 54 |  | D
Quran | 31 | 50 | 62 |  | C
Physics | 26 | 60 | 43.33333333333334 |  | E
Biology |  |  | 0
Computer | 37 | 50 | 74 |  | B
Total: | 250 | 495 | 50.50505050505051 |  | D
Spreadsheet: 152663d1335464725-adding-x-no-of-rows-to-cell-references-indirect
Sheet: Sheet4

 | Cell 1 |  |  | Cell 2 |  |  | Difference |  | Check
 | Sheet1! | A33 |  | Sheet2! | B2 |  | 66 |  | 100 | 34 | 66
 | Sheet1! | A63 |  | Sheet2! | B3 |  | 0
 | Sheet1! | A93 |  | Sheet2! | B4 |  | 0
Spreadsheet: 851826d1701961834-how-can-i-use-if-formula-in-a-pivot-table-test-1-
Sheet: PIVOT TABLE

Row Labels | Sum of QUANTITY | <14 |  |  | Result that I want |  |  |  | [NAME] that I used
T-shirt | 15 |  |  |  |  |  |  |  | IF(B4<14,True,False)
Shoes | 14
Pants | 13
Suit | 12
Dress | 10
Spreadsheet: 101562d1299674963-vlookup-problem-copy-of-practice-payroll
Sheet: Salary

25.58 |  |  |  |  |  |  |  |  | 3 days, 8:00:00 | 80
 |  |  |  |  |  |  |  |  | 3 days, 0:00:00 | 72
 |  |  |  |  |  |  |  |  | 2 days, 16:00:00 | 64
 |  |  |  |  |  |  |  |  | 2 days, 8:00:00 | 56
 |  |  |  |  |  |  |  |  | 2 days, 0:00:00 | 48
 |  |  |  |  |  |  |  |  | 1 day, 16:00:00 | 40
 |  |  |  |  |  |  |  |  | 1 day, 8:00:00 | 32
 |  |  |  |  |  |  |  |  | 1 day, 0:00:00 | 24
 |  |  |  |  |  |  |  |  | 16:00:00 | 16
 |  |  |  |  |  |  |  |  | 8:00:00 | 8
Spreadsheet: 886070d1736052306-sum-or-filter-question-testfile
Sheet: Agent Charges

Agent Charges
 |  |  |  |  | **Note: Goal to leave out columns that have all '0.00' charges. (Done)
Assesorial Charges by Agent: |  |  | AGT-2
 | Client | Job # | POL | POD | Final Dest | # Pieces | Gross Wght (kgs) | CBM | [NAME] | Agent | Agent Total Chgs | Carrier | Ocean Freight (Collect) | VGM/Solas (weighing)Handling Fee | FOB | Liability | Wharfage Tax | Warehouse Charge | AMS Security Fee | ISF 10+2 | THC/ Handling @ Origin | Pick-up/ Trucking Charge | [NAME] | Customs Clearance | Customs Clearance Doc | [NAME]
2023-09-26 00:00:00 | Client-1 | 3 | Barcelona | NY | Boston | 9-box | 2136 | 2.458 | LCL | AGT-2 | 1016.48 | ZIM | 285.13 | 37.32 | 136.44 | 6.93 | 0 | 12.06 | 100.65 | 85.52 | 154.4 | 188.6 | 9.43 | 0 | 0 | 0
2023-10-04 00:00:00 | Client-1 | 4 | Barcelona | NY | Boston | 5-box | 1735 | 2.021 | LCL | AGT-2 | 902.24 | ZIM | 234.44 | 36.88 | 134.81 | 6.84 | 7.95 | 0 | 99.45 | 84.5 | 101.71 | 186.34 | 9.32 | 4 | 5 | 6
2023-08-04 00:00:00 | Client-2 | 10 | Shanghai | NY | Boston | 1-pallet | 84 | 0.5 | LCL | AGT-2 | 0 | Ever | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 687682d1595349277-sumproduct-if-conditions-are-met-countrows_with_criteria
Sheet: Sheet1

 | Prelim | Prelim | Classification | Classification | Classification | Classification |  | V026 | Prelim
Location | Core Logging | Core Photography | Natural Moisture Content | Bulk & Dry Density | [NAME] (4 Point Method) | PSD (wet sieve to 63 micron) |  | V026 | Classification
V026 | 0.8 | 1 | 1 | 1 |  | 1
V026 | 0.2
V026 | 0.8 |  | 2 | 2 |  | 1
V026 | 0.2
V026 | 0.7999999999999998 |  | 2 | 2 | 1 | 1
V026 | 0.2000000000000002
V026 | 1 |  | 1 | 1 |  | 1
V026 | 1
V030 | 0.72 | 1 | 1 | 1 |  | 1
V030 | 0.2000000000000001
V030 | 0.7999999999999999 |  | 2 | 2 |  | 1
V030 | 0.2
V030 | 0.8000000000000003 |  | 2 | 2 |  | 1
V030 | 0.1999999999999997
V030 | 1.14 |  | 2 | 2
V033 | 0.8 | 1 | 1 | 1 |  | 1
V033 | 0.2
V033 | 0.8 |  | 2 | 2 |  | 1
V033 | 0.2
V033 | 0.7999999999999998 |  | 2 | 2 |  | 1
V033 | 0.2000000000000002
V033 | 1 |  | 1 | 1
V033 | 1.02
V034 | 0.8 | 1 | 1 | 1 |  | 1
V034 | 0.2
Spreadsheet: kate_symes__18210__Deal Correction 3-9
Sheet:  Current Day

Adjustment date | Date of applied calc | Deal Date | Desk | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
2001-03-09 00:00:00 | 2001-03-09 00:00:00 | 2001-03-06 00:00:00 | STCA | Prebon | Houston | Prebon | CTPY: from Duke to EPME | Broker checked out with incorrect CTPY | 538928 | NP-15 | Q4-01 | On [NAME] | 25 | 205 | El Paso
 |  |  | Grand Count
Spreadsheet: 142456d1329845933-hlook-or-vlook-function-currency
Sheet: Sheet2

 | USD | CAD | DHM | EUR |  |  |  |  |  |  |  | USD | CAD | DHM | EUR
[NAME] | 10 |  |  |  |  |  |  |  |  |  | [NAME] | 10 | 120 | 10 | 316
Mark | 24 |  |  |  |  |  |  |  |  |  | Mark | 24 | 2000 | 90 | 311
susan | 360 |  |  |  |  |  |  |  |  |  | susan | 360 | 300 | 241 | 420
[NAME] |  | 120
Mark |  | 2000
[NAME] |  | 300
[NAME] |  |  | 10
Mark |  |  | 90
susan |  |  | 241
[NAME] |  |  |  | 316
Mark |  |  |  | 311
[NAME] |  |  |  | 420
Spreadsheet: 268391d1380617771-seperate-a-info-in-a-cell-with-formula-or-script-seperate-value-1-
Sheet: Sheet1

This is a collumn given by the export i run from a system. So hard data and also the first "code" of the link in cell [NAME] with an additional space | This is a collumn given by the export i run from a system. So hard data and i want to remove the letters from it (if it contains any) and have the output in cell C7 | This is what the formula for me should do. So remove the letters and version (if it contains any)
[NAME] | Link | Without letters
5348 A | 5348A-5360E
4360 A | 4360A-9067C
10477 G | 5698-854
4684 A | 4684A-9056A-3
11296 B | 28521-1066
9095 B | 9095B-11071Z-2
Spreadsheet: 844539d1696330106-hi-i-need-a-few-things-adding-or-changing-on-this-fishing-results-workbook-please-fishing-competition-results-1-
Sheet: 1

Croft Fisheries | Huyton 1 | 18th September 2016
Name | lbs | oz | Oz (total) | Points
 | 16 | 1
 | 14 | 3
 | 7 | 10
 | 5 | 10
 | 3 | 9
 | 3 | 8
 | 2 | 4
 | 18 | 12
 | 1 | 10
 | 1 | 7
 | 1 | 5
 | 0 | 10
Spreadsheet: 851284d1701509608-how-to-calculate-fibonacci-retracements-ratio-by-excel-formula-fibonacci-retracement
Sheet: Fibonacci Retracement 

High | Low | Close | Fibonacci Retracement % |  |  |  |  | Remarks
116 | 73 | 116 |  |  |  |  |  | The share price range are  116 to 73  which is fixed.( Ie. Column A:B maximum 116 and minimum 73)
116 | 73 |  |  |  |  |  |  | The share price Column C are not  fixed. As dynamically it will be changed based on stock exchange live feed.
116 | 73 | 99.6
116 | 73 | 83.1
116 | 73 | 73
116 | 73 | 93
116 | 73 | 80
Spreadsheet: 751134d1633918908-daily-totals-every-week-lander
Sheet: Blad1

day | hours | totaal | less complex
2021-10-01 00:00:00 | 5
2021-10-02 00:00:00 | 5.5
2021-10-03 00:00:00 | 4
2021-10-04 00:00:00 | 8
2021-10-05 00:00:00 | 4.5
2021-10-06 00:00:00 | 9.5
2021-10-07 00:00:00 | 4.5
2021-10-08 00:00:00 | 2
2021-10-09 00:00:00 | 3
2021-10-10 00:00:00 | 2
2021-10-11 00:00:00 | 1
2021-10-12 00:00:00 | 4.5
2021-10-13 00:00:00 | 2
2021-10-14 00:00:00 | 9
2021-10-15 00:00:00 | 1
2021-10-16 00:00:00 | 5
Spreadsheet: 144800d1331141511-vlookup-not-returning-the-correct-value-in-cell-paycheck-calculator-b
Sheet: Rate

0 | 0.3
Rates for Option C - Family
1 Multiple = $5,000 For A Spouse
1 Multiple = $2,500 For Each Eligible Dependent Child
Employee's Age Group | Biweekly | Monthly, per multiple
Under 35 | 0.22 | 0.48
35-39 | 0.29 | 0.63
40-44 | 0.42 | 0.91
45-49 | 0.63 | 1.37
50-54 | 0.94 | 2.04
55-59 | 1.52 | 3.29
60-64 | 2.7 | 5.85
65-69 | 3.14 | 6.8
70-74 | 3.6 | 7.8
75-79 | 4.8 | 10.4
80 and over | 6.6 | 14.3
Rates for Option B - Additional
Age Group | Biweekly | Monthly, per $1,000
Under 35 | 0.02 | 0.043
35-39 | 0.03 | 0.065
40-44 | 0.05 | 0.108
45-49 | 0.08 | 0.173
50-54 | 0.13 | 0.282
55-59 | 0.23 | 0.498
60-64 | 0.52 | 1.127
65-69 | 0.62 | 1.343
70-74 | 1.14 | 2.47
75-79 | 1.8 | 3.9
80 and over | 2.4 | 5.2
Rates for Option A - Standard
Age Group | Biweekly | Monthly
Under 35 | 0.3 | 0.65
35-39 | 0.4 | 0.87
40-44 | 0.6 | 1.3
45-49 | 0.9 | 1.95
50-54 | 1.4 | 3.03
55-59 | 2.7 | 5.85
60+ | 6 | 13
Spreadsheet: 182531d1348517129-merging-2-self-updating-columns-into-1-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Employees | Hours Volunteered | Hours Worked |  | Under 40 |  | 40 or Over |  |  |  |  |  |  |  | Rank | Hours Volunteered Descending | Employee | Hours Worked |  | Employee | Under 40 | 40 or Over |  |  | Under 40 |  |  | 40 or Over
Lydia | 10 | 52 |  | [NAME] |  | Lydia |  | Lydia |  |  |  |  |  | 1 | 21 | [NAME] | 31 |  | [NAME] | 21 | 0 |  |  | [NAME] | 21 |  | Lydia | 10
[NAME] | 2 | 67 |  | [NAME] |  | [NAME] |  | [NAME] |  |  |  |  |  | 2 | 15 | [NAME] | 39 |  | [NAME] | 15 | 0 |  |  | [NAME] | 15 |  | [NAME] | 9
[NAME] | 7 | 24 |  | [NAME] |  | Shane |  | Shane |  |  |  |  |  | 3 | 12 | [NAME] | 21 |  | [NAME] | 12 | 0 |  |  | [NAME] | 12 |  | Shane | 8
[NAME] | 5 | 36 |  | [NAME] |  | [NAME] |  | [NAME] |  |  |  |  |  | 4 | 10 | Lydia | 52 |  | Lydia | 0 | 10 |  |  | [NAME] | 7 |  | [NAME] | 2
[NAME] | 12 | 21 |  | [NAME] |  |  |  | [NAME] |  |  |  |  |  | 5 | 9 | [NAME] | 46 |  | [NAME] | 0 | 9 |  |  | [NAME] | 6
[NAME] | 15 | 39 |  | [NAME] |  |  |  | [NAME] |  |  |  |  |  | 6 | 8 | Shane | 42 |  | Shane | 0 | 8 |  |  | [NAME] | 5
Sophie | 1 | 15 |  | Sophie |  |  |  | [NAME] |  |  |  |  |  | 7 | 7 | [NAME] | 24 |  | [NAME] | 7 | 0 |  |  | Sophie | 1
[NAME] | 9 | 46 |  |  |  |  |  | [NAME] |  |  |  |  |  | 8 | 6 | [NAME] | 19 |  | [NAME] | 6 | 0
[NAME] | 6 | 19 |  |  |  |  |  | [NAME] |  |  |  |  |  | 9 | 5 | [NAME] | 36 |  | [NAME] | 5 | 0
[NAME] | 21 | 31 |  |  |  |  |  | [NAME] |  |  |  |  |  | 10 | 2 | [NAME] | 67 |  | [NAME] | 0 | 2
Shane | 8 | 42 |  |  |  |  |  | Sophie |  |  |  |  |  | 11 | 1 | Sophie | 15 |  | Sophie | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p
Spreadsheet: 168170d1342277989-conditional-formatting-for-staff-roster-staff-roster
Sheet: Roster

 | Weekly Schedule
Staff | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Remarks
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun
Goldie | N | N | N | SD
[NAME] | N | N | N | DO
[NAME] | N | N | N | N | N | N | N
[NAME] | N | N |  | SD
Sheryl | N | N |  | DO
Maria
 | D=6am-2pm |  |  | E=2pm-9pm |  | N=8.30pm-8am
 | SD=Sleeping Day |  |  | DO=Day Off |  | O=Others
 | M=7am-2.30pm
 |  |  |  |  |  |  |  | If adjacent cell (B4:D4) has 3 consecutive "N", and E4=SD. OK
Spreadsheet: 99950d1298474614-excel-2007-using-the-data-in-one-spreadsheet-to-fill-a-column-in-another-modules
Sheet: Sheet1

Module Code | Tutor | Tutor ID
IDCT01 | [NAME]
IDSD02 | [NAME]
IDBO03 | [NAME]
IDBC04 | [NAME]
IDTSOPT1 | [NAME]
IDPGOPT2 | [NAME]
IDIMOPT3 | [NAME]
IDECOPT4 | [NAME]
[NAME] | [NAME]
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: Red Butte- Sun

Hour
Ending |  |  |  |  |  |  | hourly non-firm | hourly non-firm
Pacific | Mona physical | PNM |  | PAC | PAC(t) |  | NEVP(t) | NEVP(t) | Balance
Standard | position | Purchase |  | Purch | [NAME]/RB |  | RB/Mead | RB/Mead
(PST)
 |  |  |  | 19.75 |  |  | 27648
100 |  |  |  | 25 |  |  | -25
200 |  |  |  | 25 |  |  | -25
300 |  |  |  | 25 |  |  | -25
400 |  |  |  | 25 |  |  | -25
500 |  |  |  | 25 |  |  | -25
600 |  |  |  | 25 |  |  | -25
700 |  |  |  | 25 |  |  | -25
800 |  |  |  | 25 |  |  | -25
900 |  |  |  | 25 |  |  | -25
1000 |  |  |  | 25 |  |  | -25
1100 |  |  |  | 25 |  |  | -25
1200 |  |  |  | 25 |  |  | -25
1300 |  |  |  | 25 |  |  | -25
1400 |  |  |  | 25 |  |  | -25
1500 |  |  |  | 25 |  |  | -25
1600 |  |  |  | 25 |  |  | -25
1700 |  |  |  | 25 |  |  | -25
1800 |  |  |  | 25 |  |  | -25
1900 |  |  |  | 25 |  |  | -25
2000 |  |  |  | 25 |  |  | -25
2100 |  |  |  | 25 |  |  | -25
2200 |  |  |  | 25 |  |  | -25
2300 |  |  |  | 25 |  |  | -25
2400 |  |  |  | 25 |  |  | -25
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -1880 | -3499
2 | -2029 | -3500
3 | -2037 | -3500
4 | -2033
5 | -2050 | -2818
6 | -2079 | -2139
7 | -1523 | -2139
8 | -2085 | -2139
9 | -1910 | -3500
10 | -2018 | -3500
11 | -2065 | -3500
12 | -2122 | -2139
13 | -1863 | -2139
14 | -762 | 4
15 | -848 | -2139
16 | -1259 | -2453
17 | -1932 | -2453
18 | -1963 | -2453
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | -304459
2001-06-18 00:00:00
Spreadsheet: 75857d1276467365-problems-with-sumproduct-amount-employees
Sheet: Blad1

Datum van vandaag: |  |  |  | 0 | 0
[NAME] in een jaar: | 365.25 |  |  | 15000 | 0.02
[NAME] 1: | 23.95 |  |  | 20000 | 0.05
[NAME] artikel 2: | 21.15 |  |  | 25000 | 0.08
Name Salesmen | Geboorte-datum | Leeftijd | [NAME] aan- tallen artikel 1 | [NAME] aan- tallen artikel 2 | Total amount | [NAME]
[NAME] | 1982-05-26 00:00:00 |  | 158 | 604
An De Schepper - f | 1984-02-28 00:00:00 |  | 95 | 1204
[NAME] | 1979-06-05 00:00:00 |  | 107 | 703
[NAME] | 1983-09-22 00:00:00 |  | 73 | 405
[NAME] | 1980-10-15 00:00:00 |  | 124 | 689
[NAME] | 1977-03-20 00:00:00 |  | 142 | 948
[NAME] | 1975-11-28 00:00:00 |  | 87 | 721
Aantal verkopers die meer [NAME] |  | 100 | [NAME] 1 verkochten:
Aantal verkopers die meer [NAME] |  | 800 | [NAME] 2 verkochten:
Aantal verkopers die een [NAME]:
Total amount of all [NAME] (f) Salesmen
Total amount of all MALE (m) Salesmen
Spreadsheet: 876744d1723477429-functions-solving-data-1-
Sheet: Sheet2

Quantity | Volume
3 | 3
3 | 1
3 | 4 |  |  |  |  | volume
4 | 3 |  |  |  | quantity | 1 | 2 | 3 | 4
2 | 1 |  |  |  | 1 | 1 | 2 | 3 | 4
4 | 4 |  |  |  | 2 | 2 | 2 | 3 | 4
3 | 3 |  |  |  | 3 | 2 | 3 | 3 | 4
3 | 1 |  |  |  | 4 | 3 | 3 | 4 | 4
3 | 4
1 | 3
1 | 1
3 | 4
3 | 3
1 | 1
3 | 4
4 | 3
1 | 1
1 | 4
Spreadsheet: 138055d1327503052-excel-count-text-values-based-on-date-example
Sheet: Sheet1

EXAMPLE 1
 |  |  |  |  | Date of App | Date of Contract |  |  | Date of Phone |  | Date of Hearing |  |  |  | Date of Start | App to Contract | Contract to Phone | Phone to Hearing | Hearing to Start
[NAME] |  |  |  |  | 2011-11-02 00:00:00 | 2011-11-09 00:00:00 |  |  | - |  | - |  |  |  | -
[NAME] |  |  |  |  | 2011-11-09 00:00:00 | - |  |  | - |  | - |  |  |  | -
[NAME] |  |  |  |  | 2011-11-08 00:00:00 | 2011-11-24 00:00:00 |  |  | 2011-12-01 00:00:00 |  | 2011-12-05 00:00:00 |  |  |  | 2011-12-22 00:00:00
[NAME] |  |  |  |  | - | 2011-11-10 00:00:00 |  |  | - |  | -
[NAME] |  |  |  |  | 2011-11-08 00:00:00 | 2011-11-10 00:00:00 |  |  | 2011-11-28 00:00:00 |  | 2011-12-01 00:00:00 |  |  |  | 2012-01-02 00:00:00
[NAME] |  |  |  |  | 2011-11-10 00:00:00 | 2011-11-10 00:00:00 |  |  | 2011-12-15 00:00:00 |  | 2011-12-16 00:00:00 |  |  |  | 2011-12-30 00:00:00
Spreadsheet: 58382d1258640011-using-userform-to-update-cells-tlotm1
Sheet: Weightings

January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult |  | Priv Ult | e | Priv Ult | 6 | Priv Ult | 6 | Priv Ult | 6 | Priv Ult
Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB |  | Priv NB
Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren |  | Priv Ren
Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT |  | Priv MT
Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP |  | Priv MLP
Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC |  | Priv GHC
DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult |  | DL Ult
DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB |  | DL NB
DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP |  | DL MLP
DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC |  | DL GHC
[NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W |  | H+W
Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance |  | Compliance
Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit |  | Audit
QM |  | QM |  | QM |  | QM |  | QM |  | QM |  | QM |  | QM |  | QM |  | QM |  | QM |  | QM
Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation |  | Ultilisation
Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort |  | Comfort
Spreadsheet: 860992d1709011906-formula-based-on-cell-value-formula-based-on-cell-value
Sheet: Sheet1

Start Date | Required Until | Status | Condition
2022-06-14 00:00:00 | 2025-05-13 00:00:00 | Ongoing
2022-06-14 00:00:00 | 2025-05-13 00:00:00 | Ongoing
2022-06-14 00:00:00 | 2025-05-13 00:00:00 | Ongoing
2019-06-16 00:00:00 | 2024-02-29 00:00:00 | Ongoing
2022-04-26 00:00:00 | 2023-10-15 00:00:00 | Expired
2021-04-13 00:00:00 | 2022-11-30 00:00:00 | Expired
2021-09-04 00:00:00 | 2024-02-29 00:00:00 | To Renew | Cell B8  less than 15 days, status column should be "To Renew"
2020-07-27 00:00:00 | 2024-02-29 00:00:00 | To Renew | Cell B9  less than 15 days, status column should be "To Renew"
2022-06-01 00:00:00 | 2024-02-29 00:00:00 | To Renew | Cell B10  less than 15 days, status column should be "To Renew"
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: East Power

 | East Power
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | of Total |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600 | 2
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800 | 2
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  |  |  | Sr. Specialist | 78000
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000
 |  |  |  |  |  |  |  |  | Director | 156000
 | Headcount |  |  |  |  |  |  |  | Sr. Director | 180000
 |  |  |  |  |  |  |  |  | VP | 216000
 | Analyst & Associate Headcount |  |  |  |  |  |  |  | MD | 240000 | 2
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 524067
 |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: mary_fischer__25633__31P
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031P
COMPANY NAME    Limbach Holdings, Inc.
ANALYSIS OF OTHER DEFERRED CREDITS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
 |  | 0
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 539748d1506354333-convert-poorly-formatted-vendor-data-into-usable-data-vendor-test
Sheet: Result

ID: | Vendor: | Status: | Address | Work Order Style: | [NAME]'s Comp: | Liability Insurance: | Tax Name: | Tax ID: | 1099: | Invoice Check Memo: | Invoices per Check Limit: | Default Bill Code: | Discount Percentage: | Discount Flat Amount: | Discount Days: | Phone Numbers | [NAME]
AABGARAGE | AAB Garage Door Inc | Active | 25333 Pennsylvania Ave. Lomita, CA 90277 | Standard |  | 2017-05-25 00:00:00 | AAB Garage Door, Inc | 111111111 | No |  |  |  |  |  |  | Day: [PHONE]  Cell: [PHONE]
Spreadsheet: 143972d1330643307-conditional-formatting-help-excel-2010-example_bri
Sheet: Sheet1

30.99 |  | 42
36.99 |  | 48
49.99 |  | 65
18.99 |  | 34
34.59 |  | 52
21.99 |  | 35
42.99 |  | 57
31.99 |  | 48
42.99 |  | 57
144.99 |  | 135
434.99 |  | 379
99.99 |  | 105
841.99 |  | 750
999.99 |  | 858
133.99 |  | 134
26.99 |  | 38
20.29 |  | 35
42.99 |  | 68
54.99 |  | 76
174.99 |  | 184
77 |  | 102
36.99 |  | 51
26.99 |  | 41
31.99 |  | 45
26.99 |  | 41
26.99 |  | 41
28.99 |  | 43
33.99 |  | 47
28.99 |  | 43
28.99 |  | 43
28.99 |  | 43
28.99 |  | 43
28.99 |  | 43
39.99 |  | 52
32.99 |  | 48
41.99 |  | 51
83.99 |  | 82
44.99 |  | 60
29.99 |  | 47
96.99 |  | 102