tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: ef34ae31-ab6a-4106-91cd-e1f48238a392
Sheet: Sheet1

Windstream Corporation | 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
Reconciliations of Non-GAAP Financial Measures
Net Debt to OIBDA (net leverage ratio)
as of September 30, 2008
(Dollars in millions) |  |  |  |  |  | 2008
Long-term debt, including current maturities |  |  |  |  |  | 5395.7
Cash and short-term investments |  |  |  |  |  | -111.6
Net debt |  |  |  |  | (A) | 5284.1
Operating Income
for the twelve months ended September 30, 2008
(Dollars in millions)
Operating income previously reported under GAAP |  |  |  |  |  | 1158.3
Other operating income adjustment for wireless
 | discontinued operations (1) |  |  |  |  | -3.7
Operating income from continuing operations under GAAP |  |  |  |  |  | 1154.6
Pro forma adjustments:
 | Operating income adjustment for sale of directory publishing |  |  |  |  | -11
 | Merger and integration costs |  |  |  |  | 9.5
 | Impairment loss on assets held for sale |  |  |  |  | 6.5
Depreciation and amortization |  |  |  |  |  | 490.2
Pro forma OIBDA from current businesses |  |  |  |  | (B) | 1649.8
Net debt to OIBDA from current businesses |  |  |  |  | (A)/(B) | 3.202873075524306
Free Cash Flow
for the nine months ended September 30, 2008, as compared to the same period of 2007 |  |  |  |  |  | Nine Months Ended |  | Nine Months Ended
(Dollars in millions) |  |  |  |  |  | September 30, 2008 |  | September 30, 2007 |  | Increase | %
Net cash provided from operations |  |  |  |  |  | 729.8 |  | 683.8
Additions to property, plant and equipment |  |  |  |  |  | -219.5 |  | -268.3
Free cash flow |  |  |  |  |  | 510.3 |  | 415.5 |  | 94.8 | 0.228158844765343
Expected Dividend [NAME] |  |  |  |  |  | Operating Income
(Dollars in millions) |  |  |  |  |  | Under GAAP |  |  |  | Depreciation and Amortization |  |  |  | OIBDA
Consolidated operating income (2008 guidance range) |  |  |  |  |  | 1105 | to | 1170 |  | 500 | to | 505 |  | 1605 | to | 1675
Add:
 | Expected stock based compensation |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20
Subtract:
 | Expected cash paid for interest expense |  |  |  |  |  |  |  |  |  |  |  |  | 410 |  | 410
 | Expected cash taxes |  |  |  |  |  |  |  |  |  |  |  |  | 160 |  | 190
 | Expected capital expenditures |  |  |  |  |  |  |  |  |  |  |  |  | 320 |  | 300
Expected free cash flow |  |  |  |  |  |  |  |  |  |  |  |  |  | 735 |  | 795
Expected dividends paid on common shares |  |  |  |  |  |  |  |  |  |  |  |  |  | 445 |  | 445
Expected dividend payout ratio |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6054421768707483 |  | 0.559748427672956
Notes:
(1) Wireless income previously reported by Windstream under GAAP.
OIBDA is operating income before depreciation and amortization.
Spreadsheet: louise_kitchen__24046__East Power Consolidation
Sheet: Midwest Trading

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays | 100000
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount
 | Analyst & Associate Headcount |  |  | 2
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
 | Relocation | 11696
Spreadsheet: errol_mclaughlin_jr__10715__adjustment
Sheet: New Liquidation

deal_num | ref_period_dt | liqudation
YJ9214.1 | 2001-11-17 00:00:00 | -775
YJ9214.1 | 2001-11-18 00:00:00 | -775
YJ9214.1 | 2001-11-19 00:00:00 | -775
YJ9485.1 | 2001-11-17 00:00:00 | -1075
YJ9485.1 | 2001-11-18 00:00:00 | -1075
YJ9485.1 | 2001-11-19 00:00:00 | -1075
YJ9538.1 | 2001-11-17 00:00:00 | -41.82
YJ9538.1 | 2001-11-18 00:00:00 | -41.82
YJ9538.1 | 2001-11-19 00:00:00 | -41.82
YJ9564.1 | 2001-11-17 00:00:00 | -975
YJ9564.1 | 2001-11-18 00:00:00 | -975
YJ9564.1 | 2001-11-19 00:00:00 | -975
YJ9599.1 | 2001-11-17 00:00:00 | -2000
YJ9599.1 | 2001-11-18 00:00:00 | -2000
YJ9599.1 | 2001-11-19 00:00:00 | -2000
YJ9649.1 | 2001-11-17 00:00:00 | -1200
YJ9649.1 | 2001-11-18 00:00:00 | -1200
YJ9649.1 | 2001-11-19 00:00:00 | -1200
YJ9671.1 | 2001-11-17 00:00:00 | -2050
YJ9671.1 | 2001-11-18 00:00:00 | -2050
YJ9671.1 | 2001-11-19 00:00:00 | -2050
[NAME] | 2001-11-17 00:00:00 | -3050
[NAME] | 2001-11-18 00:00:00 | -3050
[NAME] | 2001-11-19 00:00:00 | -3050
Liquidation of new deals:
Spreadsheet: 845667d1697080830-how-to-calculate-penalty-time-if-work-finishes-after-midnight-early-late-penalty-calculator
Sheet: Notes

ISSUE TO BE ADDRESSED | STATUS
When the time finishes after midnight use:
Normal shift work hours is considered as 8hrs 15mins
then 1.5 for 1st. 3 hrs then 2.0 after that
Ot or in excess of 38 hrs in 1 week
Check shift build up time
check 34.4
If you have a day off on a Saturday, are you paid time and a half?
How many hours is the default hours paid
NOTE TO PENALTY RATE CALCULATOR Cells G19, M19,G25, M25 | completed
Penalty rate of 15% is paid for the whole shift if you sign on after 5:00pm and finish before 7:00am excluding Saturdays, Sundays and Public Holidays | To be changed-in progress
Converesly if you sign on before 5.00pm and finish after 8:00pm your are paid the 15% penalty rate for the whole shift. For example if you start work at 1:50pm and finish at 8:05pm you are paid the 15% rate for the whole shift.
However if you start work before 7:00am and finish after 7:00am you are only paid the 15% penalty rate for those hours worked before 7:00am. For example if you start at 2:18am and finish at 8:30am the 15% rate only applies to 4 hours and 42 mins and rounded to the nearest 15 minutes.
In cells G19, M19,G25, M25 *0 inserted in the formula as Sunday, Saturday and Public Holidays not subjected to 15% penalty rate |  | Start on a Friday | Hrs worked
 |  | 10:00PM | 9
 |  | then broken down or split as follows
That is take the normal work hours of 8:15mins. 2 hrs will attract the early/late penalty. |  |  | 08:15:00 | 1 | Super paid
 |  |  | 2 | 15% early/late penalty | Super paid
 |  |  | 06:15:00 | 0.5 | Super paid
 |  |  | 01:45:00 | 2 | Nil
Check hours build-up and how is it calculated | In progress
Is there such a thing as a broken shift penalty of 1.5 and 2.0? | In progress
ADO CANCELLATION IS PAID AT 1.5 FOR THE 1ST 3 HOURS AND 2.O AFTER THAT | In progress
See if i can get a copy of the State Transit Payroll Reference Manual
NOTE TO DAY OFF - Is it paid at the rate of 8 or 7.6 hrs
hrs
CHECK ALL THE HOURS ENTERED INTO CALCULATOR PARAMATERS
if you work longer than 8hr 15mins on a public holiday is the rate increased to double time
HOW TO CONVERT MINUTES TO A FRACTION OF HOUR
=A1*24
Make sure that the Pre-start entry made is picked up by all cells related to it
in column AU it conflicts with time and a half in overtime .. Time and a half This should be captued in column AU only
Satruday shift going into Sunday --need to do a separate sheet plus adjust superannuation as the time for Sunday does not draw a super payment
if you work a higher pay rate for a period of time within a shift you are only paid that higher rate for that time worked. For example if you have a broken shift and work between the 1st half and the second half as a HDBOY you only are paid at the HDBOY rates for the time worked but at OT rates
RE broken shifts. Any VOT is treated as separate from the penalty and does not attract super
Spreadsheet: 482879d1475302405-how-to-sort-the-data-data
Sheet: Sheet1

Date | Job Name | Job details | Qty | Cost
2016-12-09 00:00:00 | [NAME] | Table | 20 | 140000
 |  | Chair | 50 | 40000
 |  | Cupbord | 10 | 100000
 |  | Desk | 200 | 1600000
2015-04-06 00:00:00 | Gurukul | Laptop | 5 | 190000
 |  | Fan | 25 | 50000
 |  | BlackBord | 20 | 16000
 |  | Desk | 157 | 1256000
 |  | Chair | 20 | 16000
2016-05-07 00:00:00 | VidyaPrasar | Notebook | 200 | 2000
 |  | BlackBoard | 20 | 16000
2016-03-23 00:00:00 | Model | Laptop | 8 | 304000
2015-12-18 00:00:00 | New English | Laptop | 4 | 152000
 |  | Desk | 80 | 640000
 |  | Chair | 20 | 16000
2016-04-03 00:00:00 | Gurukul | Fan | 30 | 60000
 |  |  | total cost
Spreadsheet: 65785d1266443999-generating-scatter-data-with-excel-in-a-us-map-waypoint
Sheet: Sheet1

Waypoint | X | Y |  |  |  |  |  |  |  |  | X | Y
WP 1 | 1526 | 11062 |  |  |  |  |  |  | First | WP 2 | 851 | 9267 |  | select 2 waypoints
WP 2 | 851 | 9267 |  |  |  |  |  |  | Second | WP 17 | 9999 | 7271
WP 3 | 952 | 7605 |  |  |  |  |  |  | Distance | 9363.221667780806
WP 4 | 11367 | 9548
WP 5 | 10013 | 5607 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
WP 6 | 7831 | 3561
WP 7 | 4694 | 7012
WP 8 | 4630 | 7661
WP 9 | 1186 | 4021 |  |  |  |  |  |  | [NAME] | begin | 851 | 9267
WP 10 | 6860 | 2475 |  |  |  |  |  |  | [NAME] | eind | 9999 | 7271
WP 11 | 10742 | 1324
WP 12 | 8705 | 4681
WP 13 | 4123 | 6280
WP 14 | 4795 | 2400
WP 15 | 5897 | 4527
WP 16 | 885 | 9056
WP 17 | 9999 | 7271
WP 18 | 125 | 7610
WP 19 | 9596 | 5572
WP 20 | 1654 | 3147
Spreadsheet: 492604d1481178062-prepare-summary-by-using-formulas-sample-report
Sheet: Summary_AVK

Month | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
Hyd
Khm
Vij
[NAME]
Wgl
Spreadsheet: 94099d1293939271-excel-2007-populate-invoice-fields-based-on-invoice-number-sample-invoice
Sheet: Sheet1

Business Name
Date:
Invoice To
Address 1
Address2
Suburb/City
Postcode
 |  |  |  |  |  |  | TAX INVOICE NO:
 |  |  |  |  |  |  | Public Health Department No:
 |  |  |  |  |  |  | ABN:
Details |  |  |  |  | Amount:
 |  |  |  |  | GST @ 10%
 |  |  |  | INVOICE TOTAL
Please Note:
Should there be any reason that this invoice does not come under your agency's resposibility for payment, we would
appreciate your immediate advice to this office to enable us to change our records accordingly. If not, then we will assume
that your office accepts responsibility for payment.
If you prefer to make direct bank payments, our Bank details are as follows:
Please indicate your invoice number as a reference.
Bank:
Branch:
B S B:
Account No:
Account Name:
Terms:    On Settlement |  |  |  |  | Please note our New Bank Details above!
REMITTANCE ADVICE
INVOICE No.
Name:
Please return this slip with remittance to :
 |  |  |  |  |  | Amount:
Spreadsheet: 198633d1354835759-count-values-which-meet-specific-criteria-cake-orders
Sheet: December

01-07 December
Flavours | Sizes
 | 40 | 35 | 32 | 30 | 28 | 25 | 22 | 20 | 18 | 16 | 12 | 10 | 8
Chocolate Bar One
[NAME] One
[NAME]
Death By Chocolate
Low GI Carrot
Red-Velvet
Ruby - Vanilla
Fe'Ro' Che
French Vanilla-Pistachio Mousse
Tiramisu
[NAME]
Dukes Chocolate Mousse
Chocolate Nougat Baked Cheese
08-14 December
Flavours | Sizes
 | 40 | 35 | 32 | 30 | 28 | 25 | 22 | 20 | 18 | 16 | 12 | 10 | 8
Chocolate Bar One
[NAME] One
[NAME]
Death By Chocolate
Low GI Carrot
Red-Velvet
Ruby - Vanilla
Fe'Ro' Che
French Vanilla-Pistachio Mousse
Tiramisu
[NAME]
Dukes Chocolate Mousse
Chocolate Nougat Baked Cheese
15-21 December
Flavours | Sizes
 | 40 | 35 | 32 | 30 | 28 | 25 | 22 | 20 | 18 | 16 | 12 | 10 | 8
Chocolate Bar One
[NAME] One
[NAME]
Death By Chocolate
Low GI Carrot
Red-Velvet
Ruby - Vanilla
Fe'Ro' Che
French Vanilla-Pistachio Mousse
Tiramisu
[NAME]
Dukes Chocolate Mousse
Chocolate Nougat Baked Cheese
22-31 December
Flavours | Sizes
 | 40 | 35 | 32 | 30 | 28 | 25 | 22 | 20 | 18 | 16 | 12 | 10 | 8
Chocolate Bar One
[NAME] One
[NAME]
Death By Chocolate
Low GI Carrot
Red-Velvet
Ruby - Vanilla
Fe'Ro' Che
French Vanilla-Pistachio Mousse
Tiramisu
[NAME]
Dukes Chocolate Mousse
Chocolate Nougat Baked Cheese
Spreadsheet: c82401e2-3047-4e49-b1c3-963565a4352f
Sheet: Sheet1

Grant agreement number / title: | Unnamed: 1 | XXXXXXXXX | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Reporting period: |  | From dd/mm/yyyy to dd/mm/yyyy
 |  |  |  |  | Form 1
 | EXPENDITURE
a. Costs  eligible for action grant
[NAME] |  | Estimated budget | Adjusted estimated budget (*) | Adjustement % (**) | Actual costs
1.1 | Personnel (staff) costs | 100000 | 100000 | 0 | 16046.345
1.2 | 1 - Travel and subsistence | 15000 | 14410 | -0.03933333333333333 | 481.1342407320516
1.2 | 2 - Equipment | 5500 | 5700 | 0.03636363636363638 | 5630.390478519605
1.2 | 3 - Consumables | 3900 | 4290 | 0.1000000000000001 | 11738.81144534116
1.2 | 4 - Miscellaneous | 0 | 0 | 0 | 0
1.3 | Services subcontracted | 130000 | 130000 | 0 | 120000
2 | Indirect costs | 17780 | 17780 | 0 | 10772.7676815215
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | (A) Total eligible costs | 272180 | 272180 | 1 | 164669.4488461143
[NAME] costs
[NAME] |  | Forward expenditure |  |  | Actual costs
3 | Non eligible costs | 0 |  |  | 0
4 | Contributions in kind | 0 |  |  | 10000
 | (B) Total non-eligible costs | 0 |  |  | 10000
 | (C) TOTAL COSTS                        (C) = A + B | 272180 |  |  | 174669.4488461143
* : Indicate budget transfers between cost categories (headings) if allowed by the grant agreement.
** : The adjustement (transfer) per heading cannot exceed the percentage allowed in the grant agreement (usually 10%).
 | REVENUE
a. Revenue linked to eligible costs
[NAME] |  | FORWARD REVENUE | ACTUAL REVENUE
1 | Co-financing by the beneficiary | 81654 | 49400.84
2 | Other co-financers
3 | [NAME] financial contribution already received |  | 47631.5
4 | Direct revenues generated by the action
 | (D) TOTAL REVENUES LINKED TO ELIGIBLE COSTS | 81654 | 97032.34
[NAME] contribution
[NAME] |  | FORWARD EU CONTRIBUTION | ACTUAL EU CONTRIBUTION REUESTED (gross amount)
 | (E) DG ENTR contribution requested by beneficiary          (E) = C-D-F | 190526 | 67637.11
[NAME] linked to non eligible costs
 | [NAME] | FORWARD REVENUE | ACTUAL REVENUE
1 | Contributions in kind | 0 | 10000
2
3
4
 | (F) TOTAL REVENUES LINKED TO NON ELIGIBLE COSTS        (F) = (B) | 0 | 10000
 | (G) TOTAL REVENUE                 (G) = D + E + F = (C) | 272180 | 174669.45
 | Bank interests generated by pre-financing (***) |  | 0
***: To be declared only if pre-financing was higher than € 50,000 and not paid to Member State
 | The undersigned certifies that the information provided in the financial statement is full, reliable and true. The costs incurred can be considered eligible in accordance with the agreement, all receipts have been declared, and this financial statement is substantiated by adequate supporting documents that can be checked.
 | DATE:
 | SIGNATURE OF THE AUTHORISED LEGAL REPRESENTATIVE:
 | NAME:
 | TITLE:
 | Contact person:
 | Tel:
 | E-mail:
Spreadsheet: 6920a906-775f-4fd9-ad5d-a25b090ff648
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
36278439 | 2013-06-06 17:28:05 | ALLIES | 1 | 8 | 6 | 644778 | GeneralGram | 10818 | pacific | 1939-08-20 | 1939-08-20 | Battle of Khalkhin-Gol, Soviet counterattack
36290893 | 2013-06-07 14:06:42 | AXIS | 1 | 7 | 6 | 509176 | arsenal94 | 11461 | mediterranean | 1942-06-20 | 1944-06-20 | Attack on Tobruk | Prise de Tobrouk
36291201 | 2013-06-07 14:45:57 | ALLIES | 1 | 7 | 6 | 509176 | arsenal94 | 11461 | mediterranean | 1942-06-20 | 1944-06-20 | Attack on Tobruk | Prise de Tobrouk
36392820 | 2013-06-14 14:39:26 | ALLIES | 0 | 6 | 8 | 772737 | dwlandis | 8666 | eastern | 1945-04-14 |  | Frankfurt an der [NAME]
36393137 | 2013-06-14 15:07:43 | AXIS | 0 | 6 | 8 | 772737 | dwlandis | 8666 | eastern | 1945-04-14 |  | Frankfurt an der [NAME]
36435862 | 2013-06-17 15:18:52 | AXIS | 1 | 8 | 3 | 679790 | Hermann | 13344 | pacific | 1942-01-14 |  | Ambush at Gemas
36462750 | 2013-06-19 14:32:41 | AXIS | 0 | 2 | 8 | 806707 | Merlinade | 8666 | eastern | 1945-04-14 |  | Frankfurt an der [NAME]
36463118 | 2013-06-19 15:11:37 | ALLIES | 1 | 8 | 5 | 806707 | Merlinade | 8666 | eastern | 1945-04-14 |  | Frankfurt an der [NAME]
Spreadsheet: 734418d1622144585-coloring-cells-by-conditional-formating-with-fis-testkleur-rijen2-keebellah-
Sheet: vlist

project | Vertrek | Aankomst | begeleider | tijd | weg | wacht | uren | km | land | verkoop | Wacht2 | inkoop | [NAME] | Wacht3 |  | Verschil alles | prijs nl | prijs d | [NAME] <50 | km NL 50-100 | [NAME]500 | [NAME]50 | km d 50-100 | km d 100-500 | km d >500 | Wacht
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42.5 | 1.15 | 150 | 2.8 | 1.8 | 300 | 4.5 | 1.65 | 1.3 | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | als J=nl;I:I | als J=nl; K:K | als J=d;I:I | als J=d:K:K | wacht
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal
Spreadsheet: 856482d1705695855-if-then-vlookup-defined-names-test-travel
Sheet: TRAVEL REQUEST

 |  |  |  | TRAVEL REQUEST WORKSHEET |  |  |  |  |  |  |  |  |  |  |  |  | TRAVEL ORDER NUMBER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N2
 |  |  |  | OFFICE | OTHER
 |  |  |  | TRAVELER NAME | SELECT NAME |  |  |  |  |  |  |  |  |  |  |  | DATE OF REQUEST
 |  |  |  | EMPLOYEE ID
 |  |  |  | SPECIAL REQUESTS
 |  |  |  | SELECT IF APPLICABLE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | ``
 |  |  |  | SELECT IF APPLICABLE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | 2nd Mode Transport Check mark
 |  |  |  | DEPART FROM |  |  |  |  |  |  |  |  |  | DEPART DATE DD-MMM-YYYY
 |  |  |  | ARRIVAL LOCATION (TDY/ HOTEL LOCATION) |  |  |  |  |  |  |  |  |  | RETURN DATE DD-MMM-YYYY
 |  |  |  | Select Drop Down for ILPP Locations |  |  |  |  |  |  | SC - SHAW AFB, SUMTER (METRO AREA)
 |  |  |  | PURPOSE OF TRAVEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHECK IF A SECONDARY MAIN MODE OF TRANSPORT WILL BE USED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SELECT THE SECONDARY MODE OF TRANSPORT (if used)
 |  |  |  | TRANSPORTATION MODE
 |  |  |  | SELECT THE MAIN MODE OF TRANSPORT
 |  |  |  | POV |  |  |  |  |  |  |  | SELECT ONE
 |  |  |  | IF POV IS SELECTED ENTER ESTIMATED MILAGE IN THE ESTIMATED COST SECTION
 |  |  |  | TYPE / TDY CATEGORY
 |  |  |  | SELECT ONE
 |  |  |  | REIMBURSEMENT TYPE
 |  |  |  | SELECT ONE
 |  |  |  | ESTIMATED COSTS
 |  |  |  | ESTIMATED FLIGHT |  |  |  |  |  |  |  |  | POC-AUTO - NO GOV avail
 |  |  |  | ESTIMATED RENTAL CAR |  |  |  |  |  |  |  |  |  | $ per mile |  |  | POV COST
 |  |  |  | ESTIMATED POV MILEAGE |  |  |  |  |  |  |  | x
 |  |  |  | ESTIMATED POV VICINITY MILEAGE |  |  |  |  |  |  |  | x
 |  |  |  | OTHER COST (explain) |  |  |  |  |  |  |  | 1 | X
 |  |  |  | CEFMS TOTAL ESTIMATE
 |  |  |  | CEFMS TOTAL ESTIMATE
 |  |  |  | FUNDING INFORMATION
 |  |  |  | LOG IN TRAVEL & TRAINING : |  |  |  |  |  |  | ORDERING WORK ITEM:
 |  |  |  | TOTAL COST: |  |  |  |  |  |  | FUNDING WORK ITEM:
 |  |  |  |  |  |  |  |  |  |  | WORK CATEGORY :
 |  |  |  | REMARKS
Spreadsheet: 89613d1289392799-excel-2007-add-to-vba-command-555555-555rev11
Sheet: Data Entry

DATA ENTRY PAGE
Submit Information In Cells Below
Kit/Assy. Job Number: | 22222
Kit/Assy. Part Number
Kit/Assy. Description
Kit/Assy. Drawing Rev. | P0
Kit/Assy. Order Quantity
P.O. Number | [PHONE]-5
P.O. Rev Level | 555555-555 |  |  |  |  | 555555-555
Part 1 Job Number | 22222-1
Part 1 Number | 11
Part 1 Description
Part 1 Drawing Rev. | P0
Part 1 Order Quantity | 240
Part 1 Matl. Lot Number
Part 2 Job Number | 22222-2
Part 2 Number
Part 2 Description
Part 2 Drawing Rev. | P0
Part 2 Order Quantity | 240
Part [NAME]. Lot Number
Due Date
Material Description
Identification Type | I
Engraving | 55555-5
Spreadsheet: 845010d1696587121-running-total-that-outputs-0-if-the-sum-is-negative-and-applying-max-caps-aggregate-excess
Sheet: Sheet1 (2)

 |  |  | Stop Loss | Agg | [NAME]
Vehicle | Incident | CLAIMED AMOUNT | 250000 | 1500000
LDV | Accident | 350000
LDV | Accident | 75000
LDV | Accident | 110000
LDV | Accident | 435000
LDV | Accident | 0
LDV | Accident | 500000
LDV | Accident | 0
LDV | Accident | 0
LDV | Accident | 300000
LDV | Accident | 600000
LDV | Accident | 300000
LDV | Accident | 95000
Totals
Spreadsheet: 676708d1588943927-vlookup-using-range-of-dates-vlookup-using-range-of-dates
Sheet: Sheet1

AUTHORIZATIONS |  |  |  |  | SESSIONS
Patient ID | Auth Number | Start Date | End Date |  | Patient ID | Patient | Session Date | Auth Number | Manual Result
553052 | 1538632650 | 2020-05-18 00:00:00 | 2020-07-14 00:00:00 |  | 284027 | [NAME] | 2020-07-20 00:00:00 |  | 1538632666
284027 | 1538632666 | 2020-07-15 00:00:00 | 2020-08-29 00:00:00 |  | 553052 | [NAME] | 2020-05-20 00:00:00 |  | 1538632650
788398 | 1537340792 | 2020-08-30 00:00:00 | 2020-09-30 00:00:00 |  | 788398 | [NAME] | 2020-08-29 00:00:00 |  | #NA
788398 | 1537340881 | 2020-10-01 00:00:00 | 2020-11-15 00:00:00 |  | 902278 | [NAME] | 2020-10-15 00:00:00 |  | #NA
307459 | 1538543186 | 2020-01-13 00:00:00 | 2020-04-11 00:00:00 |  | 902104 | [NAME] | 2020-01-21 00:00:00 |  | #NA
338852 | 1538353023 | 2020-05-18 00:00:00 | 2020-07-14 00:00:00 |  | 338852 | [NAME] | 2020-06-01 00:00:00 |  | 1538353023
 |  |  |  |  | 200470 | [NAME] | 2020-06-01 00:00:00 |  | #NA
 |  |  |  |  | 307459 | [NAME] | 2020-05-20 00:00:00 |  | #NA
 |  |  |  |  | 788398 | [NAME] | 2020-10-15 00:00:00 |  | 1537340881
 |  |  |  |  | 553052 | [NAME] | 2020-07-20 00:00:00 |  | #NA
 |  |  |  |  | 307459 | [NAME] | 2020-03-05 00:00:00 |  | 1538543186
Spreadsheet: 723430d1615680037-removing-characters-from-different-cells-based-on-contents-in-a-separate-cell-example
Sheet: Sheet1

 |  | YJL | AC
 |  | IP, AC | NK, PS, IM
 |  | AM | AM
 |  | CD, BD, MA, IM | RPe (1-2pm), MA, IP (until 3pm)
 |  | NK | BD
 |  | CD
 |  | PS | RPe
 |  | US MSK - PS
 |  |  | JHi
 |  | NKa | NKa
 |  | NA, JMcC, RP, JB | JB
 |  | BD, NK, PS
Spreadsheet: 76380d1276880788-picking-numbers-from-a-list-732525-shims
Sheet: via Formula

 |  |  |  | Total Width Needed
 |  |  |  | 180 | 220 | 160 | 360 | 600 | 1000
 | [NAME] | # Of |  | Quantity to Use
 | 0 | xxx |  | 0 | 0 | 0 | 0 | 0 | 0 | << This row and col C can be hidden
 | 76.2 | 12 |  | 2 | 2 | 2 | 4 | 2 | 0
 | 75.95 | 8 |  | 0 | 0 | 0 | 0 | 5 | 3
 | 50.8 | 14 |  | 0 | 1 | 0 | 1 | 1 | 11
 | 50.55 | 6 |  | 0 | 0 | 0 | 0 | 0 | 4
 | 25.15 | 21 |  | 1 | 0 | 0 | 0 | 0 | 0
 | 18.8 | 19 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 18 | 6 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 17 | 8 |  | 0 | 0 | 0 | 0 | 1 | 0
 | 16 | 5 |  | 0 | 1 | 0 | 0 | 0 | 0
 | 15 | 3 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 14 | 9 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 13 | 3 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 12.44 | 19 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 11 | 1 |  | 0 | 0 | 0 | 0 | 0 | 1
 | 6.09 | 21 |  | 0 | 0 | 1 | 0 | 0 | 0
 | 5 | 5 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 4 | 5 |  | 0 | 0 | 0 | 1 | 0 | 0
 | 3 | 5 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2.91 | 25 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2.79 | 10 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2.76 | 10 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2.74 | 10 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2.71 | 10 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2.69 | 10 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2.66 | 10 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2.64 | 10 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2.62 | 9 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2.58 | 9 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2.56 | 6 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2.03 | 26 |  | 1 | 0 | 0 | 0 | 0 | 0
 | 2 | 5 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 1.27 | 12 |  | 0 | 0 | 1 | 0 | 0 | 0
 | 1 | 5 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | Actual |  | 179.58 | 219.2 | 159.76 | 359.6 | 599.9499999999999 | 999.8499999999999
 |  | Residual |  | 0.4199999999999875 | 0.8000000000000114 | 0.2399999999999807 | 0.3999999999999773 | 0.05000000000006821 | 0.1500000000000909