tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 06ff32dc-c0ad-43c0-9250-de08d33aa280
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
 | 5625.0 Private New Capital Expenditure and Expected Expenditure, Australia
 | TABLE 7A. Actual and Expected Capital Expenditure by Asset - Victoria:Current Prices $m
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Actual Expenditure ;  Victoria ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3517597T | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Actual Expenditure ;  Victoria ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3517639C | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Actual Expenditure ;  Victoria ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3517681J | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  Victoria ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3517599W | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  Victoria ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3517641R | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  Victoria ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3517683L | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  Victoria ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3517598V | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  Victoria ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3517640L | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  Victoria ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3517682K | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 31092d1226849356-word-to-excel-661985
Sheet: Output

Turn Number | Act | Location | Dep Time | Location | Arr Time | Days
LTP  DY  2114 | TAXI | Derby | 8.49 | Neville Hill T&R.S.M.D | 10.19 | Su
LTP  DY  2115 | TAXI | Derby | 12.48 | Neville Hill T&R.S.M.D | 14.18 | Su
Spreadsheet: 859164d1707633921-how-to-lookup-values-and-get-results-in-specific-formats-database
Sheet: Sheet1

PURCHASE DATA
EntryNo | EntryDate | SupplierAlias | Supplier | Location | TNo | RefNo | RefDate
WAMCP0001 | 24-01-2024 |  | ANNA ELECTRONICS CORPORATION | SPAIN | 24AKYEE1005F1ZD | 181/2023-24 | 22-01-2024
WAMCP0002 | 30-01-2024 |  | EUREKA FORBES LIMITED | USA | 24AMBCF3059R1Q3 | I24240078093 | 23-01-2024
WAMOP0103 | 03-02-2024 |  | INFINITI RETAIL LLC | USA | 20PPCCV1716H1ZK | SOA588357509144 | 22-01-2024
WSILCP0005 | 03-02-2024 |  | VERNON INC | INDIA | 19WACCV3726H1ZO | A-1073 | 22-01-2024
WJCP0022 | 03-02-2024 |  | PREETY G RETAIL | INDIA | 19UAACCY2226H1ZI | S04/23-24/11 | 22-01-2024
WJPI0119 | 2024-02-08 00:00:00 |  | PREETY G RETAIL | INDIA | 19UAACCY2226H1ZI | 23-24/09 | 2024-01-25 00:00:00
WSILPP9999 | 2024-02-07 00:00:00 |  | ORANGE ORG. | CANADA | 33LHACMS2006Z1TP | C-1244 | 2024-01-27 00:00:00
Spreadsheet: 798476d1664494332-how-to-populate-other-cells-based-on-drop-down-value-plus-a-couple-other-questions-sample-pd-sheet
Sheet: Holiday

PSID | Rcd | Name | PP | Fund | Dept | S/C | Acct | Monthly Base | Shift | Stipend | Earn ID | Calculated OT Rate | Hours | Amount Due
110350077 | 0 | Smith, VALERIE | 2022-09-22 00:00:00 | 48541 | 62485 | 00000 | 601933 | 3505 |  |  | HP HG6 |  | 5
105089348 | 0 | Jones, [NAME] | 2022-09-22 00:00:00 | 47205 | 62485 | 42513 | 601933 | 6548 |  |  | HP HG6 |  | 7
101016366 | 0 | Test, RICHARD | 2022-09-22 00:00:00 | 496E5 | 62485 | 42503 | 601933 | 4541 |  |  | HE OT5 |  | 6
14816 | 0 | Doe, MAYRA | 2022-09-22 00:00:00 | 90000 | 43425 | 42504 | 601933 | 4280 |  |  | HE OT5 |  | 2
Spreadsheet: 882474-detect-employee-actual-entry-data-and-exit-date-sample-data
Sheet: Sheet1

Employee Name | Entry Date | Exit Date | Entry Date2 | Exit Date |  | Actual Entry Date | Actualy Exit Date | Check | Check
A |  |  |  |  |  | 2021-06-01 00:00:00
A | 2021-10-01 00:00:00 | 2021-11-30 00:00:00 |  |  |  | 2021-06-01 00:00:00
A | 2021-06-01 00:00:00 | 2021-09-30 00:00:00 |  |  |  | 2021-06-01 00:00:00
A | 2020-01-01 00:00:00 | 2020-01-10 00:00:00 |  |  |  | 2020-01-01 00:00:00 | 2020-01-10 00:00:00
B | 2022-10-01 00:00:00 |  |  |  |  | 2021-03-01 00:00:00
B | 2021-10-15 00:00:00 | 2022-09-30 00:00:00 |  |  |  | 2021-03-01 00:00:00
B | 2021-03-01 00:00:00 | 2021-10-14 00:00:00 |  |  |  | 2021-03-01 00:00:00
C | 2024-08-01 00:00:00 | 2027-07-31 00:00:00 |  |  |  | 2024-08-01 00:00:00 | 2027-07-31 00:00:00
D | 2022-05-23 00:00:00 | 2023-04-30 00:00:00 |  |  |  | 2020-12-01 00:00:00 | 2023-04-30 00:00:00
D | 2020-12-01 00:00:00 | 2022-05-22 00:00:00 |  |  |  | 2020-12-01 00:00:00 | 2023-04-30 00:00:00
E |  |  |  |  |  | 2023-10-01 00:00:00
E | 2023-10-01 00:00:00 | 2023-11-10 00:00:00 |  |  |  | 2023-10-01 00:00:00
E | 2020-12-01 00:00:00 | 2022-05-31 00:00:00 |  |  |  | 2020-12-01 00:00:00 | 2022-05-31 00:00:00
Spreadsheet: 734001d1621943182-how-do-you-get-a-cell-in-excel-to-change-colour-when-a-date-is-about-to-expire-conditional-formatting-based-on-date-sharr76-
Sheet: Training Log

Health and Safety MASTER Training Matrix |  |  | Training Due
 |  |  | [NAME]
FREQUENCY OF TRAINING |  |  |  |  | 3 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | Once | 5 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | 5 Yearly | 5 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | 3 Yearly | 3 Yearly
Name
Name |  |  |  |  |  |  |  |  | 2019-06-05 00:00:00 |  |  |  |  |  |  |  |  | 2018-05-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-09-14 00:00:00
Spreadsheet: 217359d1362052773-evenly-amortise-value-over-financial-year-months-cashflowpere
Sheet: costs

 |  |  | 2013-07-31 00:00:00 | 2013-08-31 00:00:00 | 2013-09-30 00:00:00 | 2013-10-31 00:00:00 | 2013-11-30 00:00:00 | 2013-12-31 00:00:00 | 2014-01-31 00:00:00
 |  |  | 1
 |  | Job 1
 |  | Job 2
 |  | Job 3
Spreadsheet: 0c6338b9-baa5-48ba-a45d-c4ca070256c9
Sheet: Sheet1

Evaluation Criteria Maximum Points | A | 50 | COST | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | B | 25 | PLAN
 | C | 15 | PAST PROJECT REFERENCES & MANAGEMENT EXPERIENCE
 | D | 10 | NUMBER OF YEARS IN BUSINESS
Proposer |  |  | Evaluator 1 |  | Evaluator 2 |  | Evaluator 3 | R & R* | TOTALS**
McKenzie Construction | A |  | 50 |  | 50 |  | 50
 | B |  | 13 |  | 14 |  | 16
 | C |  | 12 |  | 7 |  | 13
 | D |  | 6 |  | 6 |  | 6
TOTAL |  |  | 81 |  | 77 |  | 85 | -2 | 241
Flores & Harper Construction | A |  | 45.5 |  | 45.5 |  | 45.5
 | B |  | 20 |  | 22 |  | 20
 | C |  | 13 |  | 9 |  | 13
 | D |  | 8 |  | 8 |  | 8
TOTAL |  |  | 86.5 |  | 84.5 |  | 86.5 | -1 | 256.5
[NAME] | A |  | 34 |  | 34 |  | 34
 | B |  | 25 |  | 24 |  | 23
 | C |  | 15 |  | 12 |  | 15
 | D |  | 10 |  | 10 |  | 10
TOTAL |  |  | 84 |  | 80 |  | 82 | 0 | 246
Florida Safety Contractors | A |  | 25.5 |  | 25.5 |  | 25.5
 | B |  | 25 |  | 22 |  | 25
 | C |  | 13 |  | 7 |  | 13
 | D |  | 8 |  | 8 |  | 8
TOTAL |  |  | 71.5 |  | 62.5 |  | 71.5 | -3 | 202.5
*Responsive & Responsible Vendor. Negative amount equals total of items missing from mandatory inclusions such as signatures, documents, licenses etc as required. See [NAME]'s Checklist.
**HIGH POINT TOTAL INDICATES RECOMMENDED AWARD
Spreadsheet: 741880d1627395110-resetting-a-value-in-a-field-and-hiding-fields-via-check-mark-travel-forms-request-or-voucher-test
Sheet: TRAVEL VOUCHER

 |  | TRAVEL VOUCHER WORKSHEET |  |  |  |  |  |  |  |  |  |  |  | TRAVEL ORDER NUMBER
 |  | TRAVELER NAME
 |  | CEFMS ID |  |  |  |  |  |  |  | VOUCHER STATUS
 |  | DID YOU INCUR TRAVEL CARD CHARGES? |  |  |  |  |  |  |  | YES
 |  | WHAT AMOUNT SHOULD BE PAID TO THE CARD? |  |  |  |  |  |  |  | ALL
 |  | [NAME]
 |  | SELECT THE MAIN MODE OF TRANSPORT |  |  |  |  |  | POV |  |  | # OF MILES IF DRIVING POV |  |  |  |  |  |  | (LEG 1)
 |  |  |  |  |  | YES | YES
 |  | DEPART DATE |  |  |  |  |  |  | DEPART FROM (LOCATION)
 |  | 2021-03-29 00:00:00 |  |  |  |  |  |  | DENISON TEXAS
 |  | ARRIVE DATE |  |  |  |  |  |  | ARRIVE (LOCATION)
 |  | 2021-04-15 00:00:00 |  |  |  |  |  |  | ATLANTA, GA
 |  | DAILY COST FOR LODGING |  |  |  |  |  |  |  | DAILY TAXES
 |  | SELECT THE MAIN MODE OF TRANSPORT |  |  |  |  |  | SELECT ONE |  |  | # OF MILES IF DRIVING POV |  |  |  |  |  |  | (LEG 2)
 |  |  |  |  |  | YES | YES
 |  | DEPART DATE |  |  |  |  |  |  | DEPART FROM (LOCATION)
 |  | 2021-03-29 00:00:00 |  |  |  |  |  |  | DENISON TEXAS
 |  | ARRIVE DATE |  |  |  |  |  |  | ARRIVE (LOCATION)
 |  | 2021-04-15 00:00:00 |  |  |  |  |  |  | ATLANTA, GA
 |  | DAILY COST FOR LODGING |  |  |  |  |  |  |  | DAILY TAXES
 |  | DEPART FROM (LOCATION)
 |  | ARRIVE DATE |  |  |  |  |  | (DDMMMYYYY)
 |  | # OF MILES IF DRIVING POV
 |  | REIMBURSABLE EXPENSES
 |  | COMM AIR BAGGAGE FEE |  |  |  |  |  |  |  |  | TRANS TAXI
 |  | GAS |  |  |  |  |  |  |  |  | TRANS SUBWAY
 |  | VICINITY MILEAGE |  |  |  | AMOUNT |  |  |  | # [NAME] | TOLLS
 |  | MILEAGE TO/FROM AIRPORT |  |  |  | AMOUNT |  |  |  | # [NAME] | IBA FEE |  |  |  | (Carlson Sato $21.07
 |  | PARKING FEES (AIRPORT) |  |  |  |  |  |  |  |  | TRANS AIRLINE |  |  |  | (Cost forTicket)
 |  | PARKING FEES (HOTEL) |  |  |  |  |  |  |  |  | OTHER
 |  | PARKING FEES (OTHER)
 |  | RENTAL CAR |  |  |  | AMOUNT |  |  |  | # [NAME]
 |  | REMARKS | POV MILEAGE RATE .56/MILE
 |  | *As of 1-OCT-14, laundry/dry cleaning, ATM Fees, Baggage/transportation tips and phone calls are not longer separately reimbursable.
 |  | These expenses are covered by the incidentals portion of the M&IE.
Spreadsheet: 04ac40d8-7e78-4352-97ce-9873fa4e62e3
Sheet: 5.4 Voc Course Enroll & Comp

Institution
Indicator 5: Course Enrollment and Completion
Table 5.4: Vocational Core Curriculum Course Enrollment and Successful Completion / AY 2010-11
Please enter [NAME] and Successful Completion data (passed with grade 'C' or better) for the courses listed in Table 5.3. Enter 'no' if the course is not offered that semester / quarter, or 'nr' if course is not required.
[NAME] and Successful Completion
Course | Number of Students |  | AY 2010-11
 |  | Summer 10 | Fall 10 | Spring 11
 | Enrolled | m | m | m
 | Success Comp. | m | m | m
 | Withdrew | m | m | m
 | Enrolled | m | m | m
 | Success Comp. | m | m | m
 | Withdrew | m | m | m
 | Enrolled | m | m | m
 | Success Comp. | m | m | m
 | Withdrew | m | m | m
 | Enrolled | m | m | m
 | Success Comp. | m | m | m
 | Withdrew | m | m | m
 | Enrolled | m | m | m
 | Success Comp. | m | m | m
 | Withdrew | m | m | m
 | Enrolled | m | m | m
 | Success Comp. | m | m | m
 | Withdrew | m | m | m
 | Enrolled | m | m | m
 | Success Comp. | m | m | m
 | Withdrew | m | m | m
 | Enrolled | m | m | m
 | Success Comp. | m | m | m
 | Withdrew | m | m | m
 | Enrolled | m | m | m
 | Success Comp. | m | m | m
 | Withdrew | m | m | m
 | Enrolled | m | m | m
 | Success Comp. | m | m | m
 | Withdrew | m | m | m
 | Enrolled | m | m | m
 | Success Comp. | m | m | m
 | Withdrew | m | m | m
Notes:
Please see note under table 5.3.;  we do not count vocational enrollment separately from general student enrollment.
Spreadsheet: 45740d1244558148-need-rearranging-data-data
Sheet: After

35
 | Name | DOB | Data1 | Data2 | Data3 | Data4
2 | [NAME] | 01/01/1990 | 1234567890
4 | [NAME] |  | 0 | Randomtext1234567891 | 9876543211
8 | [NAME] SMITH2 | 01/01/1992 | 9876543212 | 0
11 | [NAME] | 01/01/1993 | 1234567893 | Randomtext9876543213
14 | [NAME] | 01/01/1990 | 0 | 1234567890
17 | [NAME] |  | Randomtext1234567891 | 9876543211
20 | [NAME] SMITH2 | 01/01/1992 | 9876543212
22 | [NAME] | 01/01/1993 | 1234567893 | Randomtext9876543213
25 | [NAME] | 01/01/1990 | 1234567890
27 | [NAME] |  | Randomtext1234567891 | 9876543211
30 | [NAME] SMITH2 | 01/01/1992 | 9876543212 | 0
33 | [NAME] | 01/01/1993 | 1234567893 | Randomtext9876543213
36 | [NAME] | 01/01/1990 | 1234567890
38 | [NAME] |  | Randomtext1234567891 | 9876543211 | 0
42 | [NAME] SMITH2 | 01/01/1992 | 9876543212
44 | [NAME] | 01/01/1993 | 1234567893 | Randomtext9876543213
47 | [NAME] | 01/01/1990 | 1234567890
49 | [NAME] |  | Randomtext1234567891 | 9876543211
52 | [NAME] SMITH2 | 01/01/1992 | 9876543212
54 | [NAME] | 01/01/1993 | 1234567893 | Randomtext9876543213
57 | [NAME] | 01/01/1990 | 1234567890
59 | [NAME] |  | Randomtext1234567891 | 9876543211
62 | [NAME] SMITH2 | 01/01/1992 | 9876543212
64 | [NAME] | 01/01/1993 | 1234567893 | Randomtext9876543213
67 | [NAME] | 01/01/1990 | 1234567890
69 | [NAME] |  | Randomtext1234567891 | 9876543211 | 0
73 | [NAME] SMITH2 | 01/01/1992 | 9876543212
75 | [NAME] | 01/01/1993 | 1234567893 | Randomtext9876543213
78 | [NAME] | 01/01/1990 | 1234567890
80 | [NAME] |  | Randomtext1234567891 | 9876543211
83 | [NAME] SMITH2 | 01/01/1992 | 9876543212
85 | [NAME] | 01/01/1993 | 1234567893 | Randomtext9876543213
88 | [NAME] | 01/01/1990 | 1234567890
90 | [NAME] |  | Randomtext1234567891 | 9876543211
93 | [NAME] SMITH2 | 01/01/1992
94
Spreadsheet: jeff_dasovich__14070__m010508
Sheet: DWR purchases

 |  |  | CONTRACTED |  |  |  | NON CONTRACTED |  |  |  | CREDIT ACCUMULATION
 |  | Mwh | Cost (000) | Avg. Price |  | Mwh | Cost (000) | Avg. Price |  | Price delta | Cash Flow (000) | Cumulative
Q1 | 2001 |  |  |  |  | 13308090 | 3798465
Q2 | 2001 | 6835030 | 925468 |  |  | 10466630 | 3625020
Q3 | 2001 | 8241181 | 1139357 |  |  | 13009708 | 2533473
Q4 | 2001 | 7583534 | 943585 |  |  | 9910986 | 2145508
Q1 |  | 8874797 | 887776 |  |  | 4732711 | 948103
Q2 |  | 9736927 | 1036213 |  |  | 5341672 | 885326
Q3 |  | 12465863 | 1399825 |  |  | 9081049 | 1423856
Q4 |  | 11409290 | 1059733 |  |  | 6853444 | 1153909
Q1 |  | 12528689 | 1085230 |  |  | 3497698 | 479487
Q2 |  | 13882979 | 1211480 |  |  | 2669802 | 313163
Q3 |  | 18336722 | 1681729 |  |  | 5748729 | 689927
Q4 |  | 19737558 | 1593041 |  |  | 2574043 | 264705
Q1 |  | 21398531 | 1635107 |  |  | 245274 | 22338
Q2 |  | 20019949 | 1535004 |  |  | 841694 | 76644
Q3 |  | 21412396 | 1732516 |  |  | 4951489 | 421892
Q4 |  | 23182863 | 1704610 |  |  | 1476640 | 98683
Q1 |  | 20750188 | 1376546 |  |  | 384980 | 30962
Q2 |  | 19542403 | 1318901 |  |  | 924755 | 72706
Q3 |  | 20486838 | 1509107 |  |  | 6592204 | 465873
Q4 |  | 21060134 | 1371723 |  |  | 3624725 | 245600
Q1 |  | 21151029 | 1251999 |  |  | 798000 | 65676
Q2 |  | 19575129 | 1174242 |  |  | 1915266 | 150629
Q3 |  | 19753086 | 1322665 |  |  | 8560415 | 609070
Q4 |  | 19795707 | 1176044
Q1 |  | 19395819 | 1127605
Q2 |  | 18428604 | 1104039
Q3 |  | 19684263 | 1319151
Q4 |  | 19591520 | 1165055
Q1 |  | 19153515 | 1112997
Q2 |  | 18763391 | 1121144
Q3 |  | 19294144 | 1288971
Q4 |  | 18854006 | 1103942
Q1 |  | 18797465 | 1091076
Q2 |  | 18709911 | 1117245
Q3 |  | 19293801 | 1288045
Q4 |  | 18779557 | 1110135
Q1 |  | 16709260 | 1091325
Q2 |  | 18607505 | 1118705
Q3 |  | 18922185 | 1272959
Q4 |  | 18490208 | 1098610
 |  | Cost
Q1 | 2001
Q2 | 2001
Q3 | 2001
Q4 | 2001
Q1
Q2
Q3
Q4
Q1
Q2
Q3
Q4
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Financial - AA

 | Financial Gas Analysts/Associates
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  | 0 | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other |  |  |  |  | Quigley, [NAME] | ASSOCIATE | ENA FINANCIAL
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  |  |  |  |  | Maggi, [NAME] | DIRECTOR | ENA FINANCIAL
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | May, [NAME] | DIRECTOR | ENA FINANCIAL
ENAOUTSV | Outside Services |  |  |  |  |  |  |  |  |  |  |  | Griffith, [NAME] | MANAGER | ENA FINANCIAL
ENASUPP | Supplies Expense |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | VICE PRESIDENT | ENA FINANCIAL
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000 |  |  |  | Zipper, [NAME] | VICE PRESIDENT | ENA FINANCIAL
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0 |  |  | [NAME], [NAME] ([NAME]) | Specialist | ENA FINANCIAL
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 1
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 0
 |  |  |  |  |  |  |  | Director | 143000 | 0
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 0
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 812728d1673351503-i-need-to-develop-a-grid-that-shows-how-many-entries-are-duplicated-accross-the-set-values-example-hd-5-
Sheet: Sheet1

Input Data |  |  |  | Required Results (Manual Calc)
Referral Source | Client ID |  |  |  | CARS.CO.ZA | MOTUS.CARS WEBSITE | GROUP WEBSITE | FACEBOOK | AUTOTRADER | CARFIND
CARS.CO.ZA | 9899 |  |  | CARS.CO.ZA
CARS.CO.ZA | 9899 |  |  | MOTUS.CARS WEBSITE
MOTUS.CARS WEBSITE | 2981 |  |  | GROUP WEBSITE
GROUP WEBSITE | 2981 |  |  | FACEBOOK
FACEBOOK | 4748 |  |  | AUTOTRADER
FACEBOOK | 4748 |  |  | CARFIND
CARS.CO.ZA | 8000
CARS.CO.ZA | 8000
AUTOTRADER | 8000 |  |  |  | CARS.CO.ZA | MOTUS.CARS WEBSITE | GROUP WEBSITE | FACEBOOK | AUTOTRADER | CARFIND
AUTOTRADER | 5830 |  |  | CARS.CO.ZA
CARFIND | 5830 |  |  | MOTUS.CARS WEBSITE
FACEBOOK | 9216 |  |  | GROUP WEBSITE
FACEBOOK | 9216 |  |  | FACEBOOK
GROUP WEBSITE | 1375 |  |  | AUTOTRADER
GROUP WEBSITE | 1375 |  |  | CARFIND
FACEBOOK | 9638
FACEBOOK | 9638
Spreadsheet: 328348d1403876654-formula-to-add-up-totals-from-lots-of-worksheets-testings
Sheet: sheet1

 |  |  | Item | Location in Room | Date of PAT Test | [NAME] |  | [NAME] key
 |  |  | 2 | 1 | TBA |  |  | Test Due
 |  |  | 2 | 1 | TBA |  |  | Test in 30 days
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 |  | 2013-12-08 00:00:00
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 14 |  | 2013-12-08 00:00:00
 |  |  | 2 | 1 |  | 2013-12-08 00:00:00
 |  |  | 2 | 1 | 2014-01-30 00:00:00 | 2015-01-30 00:00:00
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | 2014-01-30 00:00:00 | 2015-01-30 00:00:00
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 |  | 2010-12-10 00:00:00
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 |  | 2013-02-26 00:00:00
 |  |  | 2 | 1 |  | 2013-02-26 00:00:00
 |  |  | 2 | 1 |  | 2013-02-26 00:00:00
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 |  | 2011-12-14 00:00:00
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 |  | 2013-02-26 00:00:00
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | 2014-01-30 00:00:00 | 2015-01-30 00:00:00
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 |  | 2013-02-26 00:00:00
 |  |  | 2 | 1
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 |  | 2013-02-26 00:00:00
 |  |  | 2 | 1 | 2014-01-30 00:00:00 | 2015-01-30 00:00:00
 |  |  | 2 | 1 |  | 2010-02-26 00:00:00
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | TBA
 |  |  | 2 | 1 | TBA
 |  |  | In need of first test:
 |  |  | Overdue for PAT test:
 |  |  | Total
Spreadsheet: chris_germany__1965__ENA-Reliant Prepay
Sheet: Summary

ENA Prepays to Reliant
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
 |  |  | Prepayment
 |  | Date | (Purchases) | Comments
 | Wed | 2002-02-06 00:00:00 | 22500
 | Fri | 2002-02-08 00:00:00 | 20000
 | Thu | 2002-02-14 00:00:00 | 26000
 | Thu | 2002-02-21 00:00:00 | 10000
 | Thu | 2002-02-28 00:00:00 | 19000
 |  | Total Prepays Feb 2002
 |  | Feb 2002 Swing Purchases
 |  | Cash Balance on 2/28/02
 | Wed | 2002-03-06 00:00:00 | 42000
 | Thu | 2002-03-14 00:00:00 | 25000
 | Thu |  | 30000 | 3/22/02 9:00AM  verified payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 40000 | To be applied to Prepayment for FGT and TRKL swing activity.  3/29/02  2:45 PM verfied payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 701760 | To be applied to Apr 2002 Baseload Purchase on Trunkline.  3/29/02 2:45 PM verified payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 989700 | To be applied to Apr 2002 Baseload Purchase on Florida.  3/29/02 2:45 PM verified payment with [NAME].
 |  | Total Prepays Mar 2002
 |  | Mar 2002 Swing Purchases
 |  | Cash Balance on 3/31/02
 | Thu | 2002-04-04 00:00:00 | 37000 | 4/8/02 1:45 PM verified payment with [NAME]
 | Fri |  | 22000 | 4/15/02 10:00 AM  verified payment with [NAME].
 | Thu |  | 0
 | Thu |  | 0
 |  | Total Prepays Apr 2002
 |  | Apr 2002 Baseload Purchase on Trunkline |  | Sitara #1202698
 |  | Apr 2002 Baseload Purchase on Florida |  | Sitara #1203148
 |  | Apr 2002 Swing Purchases |  | Sitara #1203186
 |  | Total Apr 2002 Purchases
 |  | Current Cash Balance
Notes: | 4/9/02  2:30 PM - Per [NAME] at Reliant - purchase formula for the March 1st is using [NAME] instead of GD + $.06.  Fixed formula in spreadsheet, total impact to cash balance is ($120.00)