tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 132573d1323821321-pdf-text-to-excel-spreadsheet-travelleisure
Sheet: Page_5

 |  |  |  | Media Outlet Results
Outlet Name | Outlet City | Outlet State | Outlet Type  Outlet Website |  |  | Outlet E-mail |  | Outlet Phone Number Outlet Circulation Keyword Outlet Source  AudienceRelevance
Panorama: The | Boston | MA | [NAME] |  | http://www.p |  |  | (617) 423-3400 | 30,076 | 20 | S
Official Guide to |  |  | zine, |  | anoramama
Boston |  |  | consu |  | gazine.com
 |  |  | [NAME]
TFS: Total Food | Greenwich | CT | [NAME] |  | http://www.t | tfs@totalfoo |  | (203) 661-9090 | 29,973 | 56 | S
Service |  |  | zine, |  | otalfood.co | d.com
 |  |  | trade/ |  | m
 |  |  | indust
 |  |  | ry
Club & Resort | Westlake | OH | [NAME] |  | http://www.c | editor@club |  | (440) 250-1583 | 28,026 | 18 | S
Business |  |  | zine, |  | lubandresor | andresortbu
 |  |  | trade/ |  | tbusiness.c | siness.com
 |  |  | indust |  | om/
 |  |  | ry
Sunbelt | Gainesville | GA | [NAME] |  | http://www.s | pr@shelbyp |  | (770) 534-8380 | 27,826 | 16 | S
Foodservice |  |  | zine, |  | helbypublis | ublishing.co
 |  |  | trade/ |  | hing.com | m
 |  |  | indust
 |  |  | ry
Meetings South | San Francisco | CA | Onlin |  | [NAME]. |  |  | (415) 788-2005 | 25,236 | 38 | S
 |  |  | e, |  | [NAME]
 |  |  | trade/ |  | dia.com/
 |  |  | indust
 |  |  | ry
Foodservice and | North York | ON | [NAME] |  | [NAME].F |  |  | (416) 447-0888 | 24,094 | 30 | S
Hospitality |  |  | zine, |  | oodservice
 |  |  | trade/ |  | World.com
 |  |  | indust
 |  |  | ry
Hispanic | Houston | TX | [NAME] |  | http://www.h | angela.rowe |  | (281) 333-1881 | 23,678 | 23 | S
Meetings & |  |  | zine, |  | ispanicmeet | @hispanicm
Travel Magazine |  |  | news |  | ingstravel.c | eetingstrave
 |  |  | and |  | om | l.com
 |  |  | busin
 |  |  | ess
Page: 5 |  |  |  |  |  |  |  |  |  |  | 12/13/2011
Spreadsheet: 769332d1645474521-change-cell-reference-to-a-column-when-copying-formula-in-a-row-productivity-score
Sheet: Example 3

Week | # of Calls | # of Cases | # of Hours | Productivity Score
2022-02-14 00:00:00 | 111 | 78 | 41
Spreadsheet: 9416fa43-8eef-4848-b832-be73fb83cdfd
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Redningstjenester
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Norsk Folkehjelp Mo lag | Søderlundmyra 49 | 8622 | Mo i Rana | 75 15 52 54
Kvinnherad Auto |  | 5463 | Uskedalen | 926 40 546
Bærum Kranservice AS | Durudveien 1-3 | 1344 | Haslum | 67 80 11 00
Stavern Dykkersenter | [NAME] 9 | 3290 | Stavern | 33 11 67 70
[NAME] | Safirvegen 2 | 9022 | Krokelvdalen | 913 66 008
Geir Ivars Bilhjelp AS | Salhusmarka 13 | 8907 | Brønnøysund | 911 06 000
[NAME] | Granittveien 19 | 1890 | Rakkestad | 908 42 265 | 69 31 87 93
[NAME] | [NAME] | 3290 | Stavern | 33 12 78 54
Kongsberg Bilberging AS | Numedalsveien 76 | 3617 | Kongsberg | 32 73 04 10
[NAME] | Industriveien 9 | 3430 | Spikkestad | 31 28 88 88
Rov & Dykkerservice AS | Bjørndalsheia 5 | 4633 | Kristiansand | 909 27 205
Falck (Redningsverket AS) | Dyreveien 100 | 1525 | Moss | 69 26 67 71
Redningsverket AS | Dyreveien 100 | 1525 | Moss | 69 26 67 71 | 69 26 67 72
Hordaland Tungberging AS | Jørgen Moes gate 22 | 5053 | Bergen | 954 57 000
Mørland & Karlsen AS | Kystveien 114 | 4842 | Arendal | 37 01 66 00
JP & Thygesen | Lillesandsveien 29 | 4877 | Grimstad | 37 25 29 30
Bø Bilberging | [NAME] 382 | 3803 | Bø i Telemark | 971 77 000
Kasin Johannes | Hagaliavegen 1 | 3677 | Notodden | 35 01 08 20
Martiniussens Bilservice AS | Industriveien 6 | 1820 | Spydeberg | 480 01 100
Skogly Bil AS | [NAME] 10 | 2443 | Drevsjø | 62 45 66 60
Hjelper`n Kirkenes | Hessengveien | 9912 | [NAME] | 78 99 50 60
Viking Redningstjeneste avd. Stavanger | Tjodolvs gate 9 | 4010 | Stavanger | 51 53 88 88
Haugesund Redning AS | Vahaugvegen 39 | 5542 | [NAME] | 52 83 10 00 | 52 83 19 40
HydroSenteret Åfjord | Åvegen 7 | 7170 | Åfjord | 72 53 03 00
Eid Motor AS | Malakoff 2B | 6770 | Nordfjordeid | 57 86 01 88
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 492143d1480931337-3-level-dependent-drop-down-list-in-excel-multiple-drop-down-example
Sheet: Sheet2

List1 | [NAME] | ListB | [NAME] | [NAME] | LIstF | [NAME]
A | D | F | S | U | W | Y
B | E | G | T | V | X | Z
Spreadsheet: 0bcd5ad7-934f-4994-970e-0b8702bcabb7
Sheet: 12a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis
 | FRA
 | Exotic
 | Inflation
 | IRS- [NAME]
 | OIS
 | VNS
 | Zero Coupon
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | N/A*** | N/A | N/A
Estimated swap dollar volumes, week ending May 24, by product type and cleared status (value of all trades in millions of USD), all participant types and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 275083d1383323971-inserting-blank-line-after-a-group-of-numbers-book1-solution
Sheet: Sheet1

 |  | Before |  | After |  | Row To Pull | [NAME]
NumberRange: |  | 25789 |  | 25789 |  |  |  |  |  | StartingRow: | 2
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 25789 |  | 25789
 |  | 35784
 |  | 35784 |  | 35784
 |  | 35784 |  | 35784
 |  | 35784 |  | 35784
 |  | 35784 |  | 35784
 |  | 35784 |  | 35784
 |  | 99654 |  | 35784
 |  | 99654
 |  | 99654 |  | 99654
 |  | 99654 |  | 99654
 |  | 99654 |  | 99654
 |  | 99654 |  | 99654
 |  | 78458 |  | 99654
 |  | 78458 |  | 99654
 |  | 78458
 |  | 78458 |  | 78458
 |  | 78458 |  | 78458
 |  | 78458 |  | 78458
 |  | 78458 |  | 78458
 |  |  |  | 78458
 |  |  |  | 78458
 |  |  |  | 78458
Spreadsheet: 744826d1629472347-updating-formula-for-report-based-on-pivot-table-update
Sheet: Trial Balance

Kindly asking for a formula that can update if I click cell G2. I'm trying to avoid going through Data and Refresh all.
 |  |  |  |  |  | UPDATE
Sum of ZWL | Column Labels
Row Labels | Credit | Debit | (blank) | Grand Total |  |  |  | Debit
Accounts Payable | 528718.77 |  |  | 528718.77 |  |  |  | 0
Accruals - Salaries | 1000 |  |  | 1000 |  | Accruals - Salaries | 1000 | 0
Advertising & Marketing |  | 350 |  | 350 |  | Advertising & Marketing | 0 | 350
Bank Charges |  | 70 |  | 70 |  | Bank Charges | 0 | 70
Cash |  | 24400 |  | 24400 |  | Cash | 0 | 24400
Donations |  | 100 |  | 100 |  | Donations | 0 | 100
Electricity |  | 70 |  | 70 |  | Electricity | 0 | 70
Fuel & Oils |  | 379 |  | 379 |  | Fuel & Oils | 0 | 379
Furniture & Fittings |  | 2045.5 |  | 2045.5 |  | Furniture & Fittings | 0 | 2045.5
Insurance & Licence |  | 240 |  | 240 |  | Insurance & Licence | 0 | 240
Inventory |  | 1200 |  | 1200 |  | Inventory | 0 | 1200
Land and Buildings |  | 550487.77 |  | 550487.77 |  | Land and Buildings | 0 | 550487.77
Loan | 26607 |  |  | 26607 |  | Loan | 26607 | 0
Prepaid Expenses |  | 600 |  | 600 |  | Prepaid Expenses | 0 | 600
Printing & Stationery |  | 301 |  | 301 |  | Printing & Stationery | 0 | 301
Purchases |  | 8000 |  | 8000 |  | Purchases | 0 | 8000
Purchases Returns |  | 800 |  | 800 |  | Purchases Returns | 0 | 800
[NAME] | 17807.5 |  |  | 17807.5 |  | [NAME] | 17807.5 | 0
Sales | 3900 |  |  | 3900 |  | Sales | 3900 | 0
[NAME] |  | 500 |  | 500 |  | [NAME] | 0 | 500
Share Capital | 4000 |  |  | 4000 |  | Share Capital | 4000 | 0
(blank)
Grand Total | 582033.27 | 589543.27 |  | 1171576.54
Spreadsheet: 757790d1638459056-need-help-creating-formula-to-calculate-sum-of-columns-from-down-to-up-direction-sum_down-to-up_sample_sheet
Sheet: Solution_SUM_Upwards & Downward

 | PRICE | QTY | SUM -- DOWNWARDS | SUM -- UPWARDS | AVERAGE OF COLUMN B↓↓ | AVERAGE OF COLUMN B↑↑
FORMULA INCLUDES UP TO ROW NUMBER 30 | 5.143e-05 | 302575
IN CASE YOU NEED TO ADD MORE ROWS | 5.119e-05 | 221470
JUST DRAG/MODIFY THE FORMULA | 5.1e-05 | 343003
 | 5.1e-05 | 461840
 | 5.085e-05 | 419297
 | 5e-05 | 209503
 | 4.9e-05 | 437699
 | 4.95e-05 | 582651
 | 4.87e-05 | 256320
 | 4.85e-05 | 566922
 | 4.8e-05 | 428255
 | 4.7e-05 | 538646
 | 4.6e-05 | 550450
 | 4.575e-05 | 544771
 | 4.5e-05 | 547874
 |  | 228240
 |  | 530787
 |  | 354135
 |  | 438002
↓↓↓↓↓↓
Is it possible to make the formulas for unlimited rows down?
Spreadsheet: 315bf0e8-a158-4fc1-938c-5ce638d2309a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | ENGINEERING & TECHNICAL (INCORPORATED)
 |  |  |  |  |  |  | BRANCH: BRISBANE
 |  |  |  |  |  |  | PAYROLL queries: Ph 1300 853 100
 |  |  |  |  |  |  | [NAME] approved timesheets to: [EMAIL]
 |  |  |  |  |  | or | FAX: 1800 652 808 before 9am Monday
Incorporated Contractor Time Sheet
Week ending day & date |  |  |  |  | Client Name
Company Name
[NAME] |  |  |  |  | Client Address
Contractor Position
Client Cost Centre |  |  |  |  | Supervisor's Name
[NAME] |  |  |  |  | Supervisor's Title
Contractor's Signature |  |  |  |  | [NAME]'s Signature
By signing this, you are verifying the hours worked, and agree to send an accompanying tax invoice. |  |  |  |  | By signing this, you are verifying the hours worked, that you are satisfied with the work completed and that you accept the Chandler Macleod Terms of Business. If you have not been provided with the Chandler Macleod Terms of Business, please contact your Consultant.
Day | Date | Time Start use AM/PM or use 24hr clock | Time Finish use AM/PM or use 24hr clock | Less Lunch | Hours Worked |  |  |  |  |  |  | Allowances
 |  |  |  |  | Ordinary | Shift | T 1/2 | T 2 | T 2 1/2 | Public Holiday | Total Hours or Days | Meal | Travel | Other:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
 |  |  | Total Hours or Days
Send original receipts and client approval to Chandler Macleod Payroll, 200 Greenhill Road, EASTWOOD SA 5063
August 2010
Spreadsheet: c3e810fb-7369-45d2-8c71-5c5231893c96
Sheet: Sheet1

CAPITAL PROJECT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Cooperative agreement with the City of Gladstone to complete a portion of the Shoal
 | Creek trail.
Is this ordinance for the following: |  |  |  | X | New Construction
 |  |  |  |  | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  | X | Yes
 |  |  |  |  |  |  | FY | 2011
 | If no, please detail the reasons why this project was not included and need for present funding request.
Please identify source of funds below.
 | Non-City source and amount.
 | Source of Funds: |  |  |  | grant
 | Fiscal Year Funded |  |  |  | 2011
 | Amount of Non-City Funds: |  |  | $ | 411039.87
 | City source and amount.
 | Acct #: |  |  |  | 3090-898101
 | Name of Fund: |  |  |  | Capital Improvement
 | Fiscal Year Funded |  |  |  | 2011
 | Amount of City Funds: |  |  | $ | 157500
If ordinance is for new construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  | $ | 568539.87
 | Estimated lifespan of project in years |  |  | $ | 15
 | Estimated annual operating and maintenance costs |  |  | $
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please please provide source of funds.
 | If no, please identify year in which additional operating and maintenance costs will be needed. |  |  |  |  |  |  |  |  |  | FY
Reference Numbers: (Previously approved legislation):
Reviewed by:
 |  |  |  |  |  | OMB Approval Date
Spreadsheet: 744032d1628871439-formula-result-not-accurate-weld-weight-calculation-v2
Sheet: Calculation

 |  |  |  |  |  |  |  | 262.11
 | Number of Robots | Pi | [NAME] 1' to mm | [NAME] 1" to [NAME] | Density | Weld Size | Wire Diameter | IPM | Efficiency | lbs/hr | Steel lbs/Inch³ (Constant) | Inch weld Volume (Cubic Inches) | Weight (lbs) Per Inch | Weld Distance in Hour (Inches) | Steel lbs/Inch³ (Constant) | 8mm x Foot weld Volume (Cubic Inches) | Weight (lbs) Per Foot | Weld Distance in Hour (Feet) | Travel Speed (IPM)
 | 34 | 3.1415 | 304.8 | 25.4 | 13.1 | 8 | 0.052 | 350 | 0.98 |  | 0.2833 |  |  |  | 0.2833
 | Number of Robots | Pi | [NAME] 1' to mm | [NAME] 1" to [NAME] | Density | Weld Size | Wire Diameter | IPM | Efficiency | lbs/hr | Steel lbs/Inch³ (Constant) | Inch weld Volume (Cubic Inches) | Weight (lbs) Per Inch | Weld Distance in Hour (Inches) | Steel lbs/Inch³ (Constant) | 8mm x Foot weld Volume (Cubic Inches) | Weight (lbs) Per Foot | Weld Distance in Hour (Feet) | Travel Speed (IPM)
 | 34 | 3.1415 | 304.8 | 25.4 | 13.1 | 8 | 0.045 | 350 | 0.98 |  | 0.2833 |  |  |  | 0.2833
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Robot (34) Time Difference | Difference in lbs/hr (Weld Wire) | Difference of Inches in Hour | Minutes Decreased (Per Hour) | Shift Hours | Time Change  Per Robot Per Shift | Travel Speed Increase (IPM)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 134d8f41-c9da-48e1-8616-5ee09194fa54
Sheet: Narrative

1.  TDG Project Overall Status
 | Green | Yellow | Red | Explanation of and Reason for Deviation (Summary)
 | (No Deviations) | (Limited / Controlled Deviations) | (Material Deviations)
Scope
Schedule
Budget
2.  TDG Project Scope
Please provide sufficient detail to define deviations adequately:
Deviations to Scope of Work
·         [NAME] and explain any deviations from the agreed upon scope.
3.  TDG Project Schedule
Please provide sufficient detail to define delays and/or exposures to delays adequately:
Project Completion Percentage
·         Provide overall plan completion percentage vs. latest plan percentage.
External Dependencies
·         [NAME] and list any dependencies between scheduled tasks.
Assumptions
·         [NAME] and list any project assumptions.
Constraints
·         [NAME] and list any project constraints.
4.  TDG Project Cost
Please provide sufficient detail to define project costs and/or variances adequately:
·          Total cost (forecast) vs. baseline budget deviation explanations.  [NAME] rows as needed.
Date | Current Forecast Amount | Most Recent Prior Amount | Baseline / Grant Agreement Amount | Expended to Date | Explanation of Deviations, Impacts, and Recovery Efforts
·          Federal disbursements, deviation explanations.  [NAME] rows as needed.
Date | Federal (planned) |  | Federal (actual) | Comments
·          TIFIA disbursements, deviation explanations.  [NAME] rows as needed.
Date | TIFIA (planned) |  | TIFIA (actual) | Comments
·          Non-federal project disbursements, deviation explanations.  [NAME] rows as needed.
Date | Non-federal (planned) |  | Non-federal (actual) | Comments
5.  TDG Project – Significant Issues
Please provide sufficient detail to define any relevant project issues adequately:
·          Identify major contract awards or completions; items identified as deficient quality; project safety matters; problems with federal project requirements; or any other topics.  [NAME] bullet points as needed.
Spreadsheet: 849878d1700241559-confuse-with-formula-test-sudbhavani-
Sheet: pull data

 |  |  | A.samuel
 |  |  |  |  |  | Enter The Number
S.No | Submission ID | Respondent ID | Submitted at | Agent Name | [NAME] / சைக்கிள் பாய்பெயர் | Mobile / ஏஜென்ட் மொபைல் எண் | Shop Name / கடையின் பெயர் | Shop Address / கடையின் முகவரி | சாலை/தெரு | பகுதி/ஏரியா | அஞ்சல் குறியீடு (Pincode) | கடையின் மொபைல் எண் | Shop Category / கடையின் வகை | வகையை உள்ளீடுக | Shop Photo / கடையின் புகைப்படம்
Spreadsheet: 32042d1228164953-adding-names-and-showing-on-all-sheets-generic-hours-and-miles_2008
Sheet: March

[NAME] | Month Total | Month Total | 08XXXX | City
CD? Then "Y" |  | CD
 | HOURS | [NAME] | HOURS | CD [NAME]
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
AB Hours /Job | 0 |  | 0
AB-CD /Job |  | 0
 | 0
Spreadsheet: 482994d1475410773-count-of-appearances-book1-gk
Sheet: Sheet1

Member ID | Created On | On Track | Lost Track
G1289603X | 2016-07-21 10:17:39
G1289603X | 2016-07-21 00:00:00
G1289603X | 2016-07-23 00:00:00 |  | 1
G1289603X | 2016-08-12 00:00:00
G1289603X | 2016-08-12 00:00:00
G1289603X | 2016-08-12 00:00:00
S9117361A | 2016-07-21 10:21:36
HMBR-[PHONE] | 2016-07-21 10:24:59
HMBR-[PHONE] | 2016-07-21 12:23:56
S9177922F | 2016-07-21 12:31:35
S8435089C | 2016-07-21 12:32:10
S8431026C | 2016-07-21 12:33:29
S7863862A | 2016-07-21 12:34:08
S7863862A | 2016-07-22 00:00:00 |  | 1
Spreadsheet: rick_buy__32698__DOUG
Sheet: 1199

4
POWER PLANTS  ACCOUNTS RECEIVABLE AGING
AS OF NOVEMBER 30, 1999
 |  |  | CURRENT |  | 1-30 |  | 31-60 |  | 61-90 |  | OVER 90 |  | TOTAL | COMMENTS
SMITH ENRON | A/R |  | 3971478.74 |  | 3856970.57 |  | 3961806.98 |  | 3551416.52 |  |  |  |  | TOTAL INCLUDES PAYMENTS FOR INTEREST
 | PER CENT |  |  |  |  |  | 0 |  | 0 |  |  |  |  | WE WILL BE WIRING TO EI EQUALS $2,410,727.74
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALSO $6,513,871.14 WAS WIRED ON 12-1
PUERTO QUETZAL | A/R |  |  |  | 2804400.03
463 | PER CENT
HAINAN MEINAN | A/R |  |  |  |  |  |  |  |  |  | 68695.76
416 | PER CENT
DABHOL POWER CO | A/R |  | 144874.81 |  | 144874.81 |  | 144874.81 |  |  |  |  |  |  | PAYMENTS TOTALING $227,563.27
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | CAME IN ON 12-2 AND 12-3
EMPRESA ENERGETICA | A/R |  |  |  | 2587123.06 |  | 546126.27
 | PER CENT
EGEMINSA | A/R |  | 430539.24 |  | 3127805.71 |  | 1229839.52 |  | 150.56 |  | 26234.56
 | PER CENT
TOTALS | A/R
 | PER CENT
Spreadsheet: 180e6fbd-7b88-4698-967d-52d4e197819d
Sheet: Sheet1

Vendor Payments | Unnamed: 1 | Unnamed: 2 | Each individual payment using ARRA (Recovery Act) funding to a vendor must be reported each quarter. When possible, the vendor [NAME] should be requested. If the vendor DUNS information is not available, then the vendor name and ZIP+4 of the vendor headquarters location is required. | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
[NAME]: Fiscal Agent and Police Dept Support  Award #: 2009-SB-B9-1187A |  |  |  |  |  |  |  |  |  | Project Start Date: // |  |  | Quarter: 1  Year:  2010
Purchase Order Date |  | [NAME] |  | Vendor [NAME] |  | Vendor [NAME] |  | Payment Date |  | Description |  |  |  | Amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | Total Amount |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Total Payments |  | 1
"I HEREBY ATTEST THAT THE ABOVE SCHEDULE IS AN ACCURATE RECORD OF THE PAYMENTS MADE FOR THE TIME PERIOD INDICATED."  Please attach invoices and/or accounting records as documentation for the above payments made.
Signature: |  |  |  | Date:  3/31/10 |  | Reviewed by: |  |  |  |  |  |  |  | Date:  3/31/10
Organization Head |  |  |  |  |  | Project Manager |  |  |  |  | Title
[NAME]: Fiscal Agent and Police Dept Support  Award #: 2009-SB-B9-1187A
[NAME]: Delhi Township Law Enforcement Activity  Award #: 2009-SB-B9-1187B
[NAME]: Forest Park Police Law Enforcement Activity  Award #: 2009-SB-B9-1187C
[NAME]: Golf Manor Law Enforcement Activities  Award #: 2009-SB-B9-1187D
[NAME]: Hamilton County Law Enforcement Activities  Award #: 2009-SB-B9-1187E
[NAME] of Lockland Law Enforcement Activities  Award #: 2009-SB-B9-1187F
[NAME] of Loveland Law Enforcement Activities  Award #: 2009-SB-B9-1187G
[NAME] of Mt Healthy Law Enforcement Activities  Award #: 2009-SB-B9-1187H
[NAME] of Norwood Law Enforcement Activities  Award #: 2009-SB-B9-1187I
[NAME] North College Hill Law Enforcement Activities  Award #: 2009-SB-B9-1187J
[NAME] of Reading Law Enforcement Activities  Award #: 2009-SB-B9-1187L
[NAME] of Sharonville Law Enforcement Activities  Award #: 2009-SB-B9-1187M
[NAME]: Springfield Township Law Enforcement Activities  Award #: 2009-SB-B9-1187N
[NAME] of Springdale Law Enforcement Activities  Award #: 2009-SB-B9-1187O
[NAME] of St. Bernard Law Enforcement Activities  Award #: 2009-SB-B9-1187P
[NAME] in Reducing Crime  Award #: 2009-RA-E01-2229
[NAME]: Sex Offender Monitoring Program  Award #: 2009-RA-A02-2094
[NAME] Post Booking and Jail Mental Health Diversion Program  Award #: 2009-RA-C01-2048
Spreadsheet: 1b25b2ed-7cff-4243-8917-6139f1a16798
Sheet: One-time, FV-PV

Discount Factor Table for One-time Fund
Present Value (PV) --> Future Value (FV) |  |  |  |  |  |  |  |  | Column: discount rate (r%), Row: Year (n)
 |  |  |  |  |  |  |  |  | [NAME]: 1/(1+r%)^n
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Spreadsheet: 837924d1690516723-serial-number-formula-with-condition-serial-numbers-formula-with-condition
Sheet: Sheet1

Job No. | Load No. | Carry forward [NAME]. | Desired Load No. |  | Need formula to put [NAME] number for each job. [NAME] put in Col. [NAME]
[NAME] |  |  | 1 |  | The requirement is: If there are any loads dispatched in previous year, the Load Number to continue from Carry forward Load Number (Column C).
[NAME] |  | 12 | 13 |  | Moreover if I put "x" in Col.C, the load number should not be counted for next Load number.
HY-03456 |  | 6 | 7 |  | The desired result shown in Col.D for ready reference.
[NAME] |  |  | 2 |  | Pl. help putting formula
[NAME] |  |  | 14
[NAME] |  |  | 3
[NAME] |  |  | 15
[NAME] |  |  | 16
[NAME] |  |  | 4
HY-03456 |  | x
HY-03456 |  |  | 8
HY-03456 |  |  | 9
[NAME] |  |  | 5
[NAME] |  |  | 6
Spreadsheet: 52961d1252875052-subtracting-dates-date-problem
Sheet: Sheet1

INPUT DATA |  |  |  |  |  | CALCULATED DATA
Date booked in | Date Completed |  |  |  |  | Days spent in |  |  |  | Total Time
 | Design | Stress | Aero | Cooling |  | Design | Stress | Aero | Cooling |  |  | Min | [NAME]
2009-09-01 00:00:00 | 2009-09-05 00:00:00 | 2009-09-10 00:00:00 | 2009-09-18 00:00:00 | 2009-09-24 00:00:00 |  | 4 | 5 | 8 | 6 | 23 |  | 2009-09-05 00:00:00 | 2009-09-18 00:00:00
2009-09-01 00:00:00 | 2009-09-10 00:00:00 | 2009-09-05 00:00:00 | 2009-09-18 00:00:00 | 2009-09-06 00:00:00 |  | 4 | 4 | 8 | 1 | 17 |  | 2009-09-05 00:00:00 | 2009-09-18 00:00:00
2009-09-01 00:00:00 | 2009-09-18 00:00:00 | 2009-09-05 00:00:00 | 2009-09-10 00:00:00 | 2009-09-12 00:00:00 |  | 6 | 4 | 5 | 2 | 17 |  | 2009-09-05 00:00:00 | 2009-09-18 00:00:00