Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BridgestoneGal

    Excel NPV formula

    Sorry about that Carrr. I totally missed the link you left there. Yes, it does give a good explanation. Thanks!
  2. BridgestoneGal

    Excel NPV formula

    Thanks for the warning. I plan to add the previous year's cash flow to the NPV formula. NPV(x,x:x)+x I'm confused about all the variables and how to organize my information.
  3. BridgestoneGal

    Excel NPV formula

    Please explain to me the steps to calculating Net Present Value. I know Excel has a formula for this, but I need further explanation. Please give detail like listed below. For example here is an IRR calcualtion: In an excel spreadsheet... 1) Input your total costs for the project in one...
  4. BridgestoneGal

    VBA code to append the current date to a table name

    Terry, Maybe you can recommend I do something else. I know it says programmer next to my name, but I program in MIMI (a proprietary language) not VBA. Here's what I am trying to do. I want to create a report to measure forecast accuracy using the following 3 text files: Actual Orders -...
  5. BridgestoneGal

    VBA code to append the current date to a table name

    Thanks for your recommendation. I believe this is the answer I was looking for. I found it on a google search. Action: Rename New Name: "Table1_" & Format$(Date, "MMDD") Object Type: "Table" Old Name: "Table1" Save the macro, then run it. Notice...
  6. BridgestoneGal

    VBA code to append the current date to a table name

    I have a table T_Statistical_Forecast and would like to append the current month to the table name. For example: T_Statistical_Forecast_April or T_Statistical_Forecast_4 Please advise me. Thanks.
  7. BridgestoneGal

    How to rename table referencing DateUpdate field

    Please tell me how to rename a Table (in a way that can be run from a Macro) to incorporate the DateUpdate field. I would ideally like to append the current Month to a table name as it is being imported. Thanks!

Part and Inventory Search

Back
Top