I'm attending a class on Business statistics and found reference to MegaStat add-in in the very first chapter of my statistical techniques in Business Economics, peeked my interest in downloading or as referred to, add-in to my current 2003 Office Excell program Subscribe for Weekly Excel Tips and TricksHelpful tutorials delivered to your email!Similar Topics
I need a formula to calculate Turn Around Time. Find below the sample data and details for your reference. Received Date & Time: 10/29/2010 3:27:00 PM Completed Date & Time: 11/1/2010 3:57:32 AM Business Hours: 08:00 AM to 05:00 PM Non Business hours: 05:00 PM to 08:00 AM Weekdays : Monday to Friday Weekends: Saturday & Sunday If I calculate TAT for this time period it should show me 1 hour 33 minutes, why because business hours are closing by 5:00 PM on 10/29 so it should not calculate duration after 5:00 PM to until 08:00 AM on next day, however 10/29 is Friday so formula should calculate the duration from 10/29 Friday 3:37 PM to 10/29 5:00 PM and again it should calculate from 8:00 AM on 11/01 Monday and formula should skip Saturday & Sunday. In this scenario I have completed the task before 8:00 AM on 11/01 so it should show duration of 1hour 33 minutes. Please let me know if you need any more details
A previous poster explained what I also need; there were no responses, so I thought I would try again. Does anyone know of an Excel template--or a small stand-alone program--that will calculate the interest/principal breakdown when payments are varied in amount and frequency? Free or low-cost, please. I need one that will work on my Mac/Office 2004. I will need to print out periodic reports. Here is the way the previous poster described it: 'Excel template: Loan Amortization for random/irregular payments, figures days between payment dates. I have a loan with a variable beginning balance and irregular payments with annual large payment. (based on collections) Would like to enter payment and date. then Excel would figure days since last payment, interest amount, principal amount, Ending Principal balance. And total interest paid, total pricipal paid If I change the starting principal, excel would recalculate all entries.' Thanks very much. Dear All, I have around 250 Employees Payroll and i am preparing the Payslip in Excell manully. I have all the Salary details in Sheet1 and in Sheet2 is Payslip. I request all of you to please help me so that i can take the printout of all the employees in sheet1 by at a time. Now im entering one by one employees code and then taking the prinout.. Please provide me with any Formulas as micros are disable in my Computer..... Waiting for an early reply....... I recently moved into a new office and I am using a brand new computer on our network. When trying to edit an existing file, I'm not able to select a single cell and type. After clicking on a cell, if I move the mouse at all (even without pressing the left button) it just continues highlighting cells no matter where I move the mouse. I am also not able to click on the tool bars at all. I have to actually Ctrl-Alt_del to get out of the program. I'm sure this is something simple, but I don't know that much about this program. Any help would be greatly appreciated.
Ok, guys, new to this forum and I need some help with a business invoice. I know how to create a drop down list. But what I want to do is create a Drop-Down list with customers names, say cell A11. After selecting a customer name from the list, It would be able to populate the address in cells A12 and A13. Is this possible? I have a problem sometimes. I will click on a cell to add information. The cell turns blue and then wherever I move, it highlights those to. No matter where I go on the page. If I Alt-Tab and work in another program on my computer, that excel page keeps highlighting wherever I move even in those other programs (I know this sounds confusing). When I return to excel thousands and thousands of cells are blue. The biggest problem is that the highlighting won't turn off, no matter what. I can't select anything from the tool bars, do any work on the sheet or close the program. I can close it only with the task manager but when I open it again, the cursor is still stuck in the highlighting mode and won't perform any other functions. Do you think this is a problem with my computer, the excel program? I have changed my mouse and this didn't help. Is there some shortcut to turn off this highlight feature other than restarting my computer. Which is the only current way I can get rid of it. Thanks for any advice,
I run a small business. I want to start keeping track of inventory using a barcode system. I know Excel 'ok', but I don't know programming.' I'd like to be able to do something very simple (for now)... For example...if I had PRODUCT / CODE / INV VALUE A - CODE A - 5 B - CODE B - 11 C - CODE C - 14 I would want to be able to click a button (or scan a code for) : ADD +1 or REMOVE -1 ...then scan the barcode on the product (A) and have it add or remove one, respectively. So, if the row for A is: A - CODE A - 5 I choose 'ADD' (with a button or scan code), then scan the barcode, and the spreadsheet automatically finds the code in the sheet, and changes the corresponding inventory value: A - CODE A - 6 Does that make sense? How might I go about doing that?
Hello I'm quite experienced Excel user. I've never come across this problem but tinkering in every conceivable way within Excel settings and the solution has eluded me. I have added a worksheet created elsewhere (it is a form I need printing, with the data coming from 2 sheets I have created from scratch) which has pre formatted cells for Date and Client Name etc. When I try to reference the cell in this added sheet from my 2 sheets, instead of the result, it always displays the formula, not the result. I have tried doing it from one of my sheets to reference to this new, and that displays the result and not formula. I can't imagine why it's doing this and I've never seen it happen before. Formatting cells, giving cells names rather than the usually adequate of reference to the Cell Number doesn't change things. I wonder if I've picked up some legacy protection from the original form but can't see anywhere in the tools etc that's obvious. There's about 50+ cells that need referencing and I got to get this done for work. Please help me. This is my first need to post on a Excel Forum as I've always found help or answers from other peeps or internet but this one is making me scratch my head big time. Hi, I'm trying to get some macros to combine data from two open workbooks, and I can't figure out the commands to switch from the active workbook to the other open workbook and back. I'm new to VBA and just learning the ropes. All I can figure out is how to switch to another workbook with an exact name. If I record the macro to go to a recent file, for example Window > 1 (filename), the code that I get in VBA is Windows('filename').Activate. This doesn't translate to when I have two different workbooks with different filenames open. Make sense? I'm a bit confused myself. Maybe just a list of basic workbook-switching techniques or commands would be useful. - Michael I have a VBMacro Excel file loaded on a Server that numerous people access. A Macro in this file creates a Copy of a specific Sheet within the Active Workbook and I want to Save it to the individual's Desktop. How do I find out what the current User's desktop folder path is each time the Marco is run by a different User? Example User's path: 'C:Documents and SettingsjfarcDesktop' Where 'jfarc' is the name of the current User which, will of course change with every different User that runs the Macro. Also, is there a way to pull out of Excel what is the current User's 'Options | General | Default File Location' entry? Which may differ from the above directory. I am familiar with and use the following coding for Opening/Saving files to the current directory of the opened workbook, but it only gives the path of the existing Excel workbook and not the current User's Directory Path: Dim wbThis As Workbook Set wbThis = ThisWorkbook ChDir wbThis.Path Happy Day to all, Can you please help me, A1= time in B1= time out C1= time in D1= time out I want to calculate the late and under time, Office start at 9:am w/30 mins Grace period, The break time is one hour only, please include over breaktime in calculation. End of office hours 6:00 pm, strickly no over time
Hello , Here is my issue: I have a list of SKUs in Excel and I need to add one same word to 500 cells that have pre-existing text in the cells. See example below: 1) List of SKU's in cells: 34 35 39 55 2) text that needs to be added IN FRONT of every number: DF So the result would be: DF34 DF35 DF39 etc. How do I do that in a formula and not manually? I found another similar thread and I understand how to do it from the instructions there but the same text goes on the back and the result is: 34DF but I need it to be like: DF34. I am using Office 2007 for mac. Thank you for the help, Chris
I use a excel file through the course of the day and need to insert the current date in one column and the current time in the next column. I want to be able to just highlight the selected range of cells I need to insert into and hit a macro button and have the date and time inserted into just the cells I have highlighted. I'm not sure how to make this work with just the cells I've highlighted. Any help any one can give me would be greatly appreciated. Thanks! Mike
I have an image or picture within a worksheet. I want to be able to reference it from a cell so that depending on a validation list a different picture is shown. Is this possible in Microsoft Exec 2000
I have a template that automatically populates the date field with the current date when opened, using today(). Users then Save As to have an archive copy of their spreadsheet. However, when they go back to access their saved sheet, the date changes from the created date to the current date. How do I stop this in Excel? I know that Word lets you do this by changing the code from {DATE} to {CREATEDATE}, but I can't find a similar setting in Excel. Please help and thank you! I'm trying to open a pdf file from within excel vba. I have tried using the followhyperlink method but adobe acrobat opens very briefly then immediately closes Code: So then I tried to create an instance of acrobat by setting a reference to the acrobat object but I can't get this to work either! The code I'm using is Code: Any ideas what could be wrong with either approach? Thank-you Below is the code I am using. I am trying to change the subject to show the value of a cell. Code: When it sends it does not show the name in c5. It just reads 'Attrition for' Should there be a different code? I have created an excel spreadsheet to track attendance of an exercise class I am teaching. I would like to know each person's current percent attendance. (so if we have had 5 classes and they have attended 4 of those classes then it should show 80%). I would like it to keep a running tab, so as I add in the person's attendace it will continue that count, up to the 26 classes that are being offered. I thought if I did a sumif/countif I could get it to work, but it doesn't. Here is what I tried: =sumif($e$4:$ad:4,'>0')/countif($e$4:$ad$4,'>1'). Do you have a suggestion that would work? Thanks!
Hi, Someone once showed me how if you have a a reference to a cell in one sheet you could double click on the cell and it would jump to the referenced cell in the reference cell's sheet. For example. Cell With Reference Referenced Cell in other Sheet A1 <--double click sheet1 cell A1 takes you to --> =Sheet2!A1 I have workbook in which I want to save a specific worksheet to a new file with only the values saved - all data in this worksheet are references to cells on another worksheet, which is using VLOOKUP to pull data from a database. Found the following code and it gets me close, but it copies the cell references, not the values. It also allows me to specify the file name from a cell reference. I want the new workbook file to simply be saved, not opened, and a message box to display stating where the file was saved (will always be in the same location on the LAN). What modifications do I make to this to get this to work per above requirements? Sub CopyMe() Dim SaveMeAs As String SaveMeAs = Sheets('Sheet1').Range('B2').Text Sheets('Sheet3').Copy ActiveWorkbook.SaveAs Filename:='C:My Documents' & SaveMeAs End Sub I get the error message 'reference is not valid' each time I open my spreadsheet. I get this message three times, and once I am done clicking ok on all three of them, my spreadsheet works just fine. The problem is, I have to send it to a bunch people. I havea sheet with raw dataa sheet with pivot tablesa sheet with a dashboardand a simple macro I don't have any #REF cells either. Someone has any idea of what could be the problem? thanks NA
Also, I cannot move the Pivot Table from the new Worksheet it is created in, to my existing Worksheet. I am running Excel 2011 for Mac. I have a Worksheet with a small amount of data, and when I click the Pivot Table button it automatically creates the Pivot Table in a new Worksheet. The Pivot Table data is fine, but I want it to display alongside the source data. I've tried using the Move Pivot Table option and choosing to Create Pivot Table in Existing Worksheet and choosing a source cell alongside my current data, but nothing appears. Also, I checked in Edit menu and found that the Pivot Table appears to have not even been created/moved because there is no option to undo it. Appreciate any help, let me know if you have any further questions. Hunter Hi all, The following code is placed in workbook 'A' and is used to open workbook 'B'. These workbooks will now always be housed in the same directory and i want to change the code to use a relative path reference by determining the path of workbook 'A'. here's what I had: Sub income_statement() Application.WindowState = xlMaximized Application.Workbooks.Open 'C:Documents and Settings.....workbook B.xls', UpdateLinks:=xlUpdateLinksAlways End Sub could you suggest how to change this to use a relative path reference?
Suddenly, I lost the ability to use copy and paste by right clicking my mouse. Using Office 2000. Can you help? Thank you!!! I have found similar posts on the forum, but nothing without use of a userform. I have the following code: Code: This works, but I want to hide the text as it is entered. Is there a way I can enter this as a property? i.e. inputbox.text.property = ... or something?? I've tried what seems intuitive, but nothing works. Help! |
Download megastat add-in for excel 2016 for free. Office Tools downloads - MegaStat by J. Orris and many more programs are available for instant and free download.
- Click the link below to download the MegaStat (version 10.4) software. There is both a Windows and Mac version available for download, and the required files are packaged as a ZIP file. After saving the file to your hard drive, decompress it using one of the many utility applications available for both Windows and Macintosh computers.
- Download megastat for excel for free. Office Tools downloads - MegaStat by J. Orris and many more programs are available for instant and free download.
- Run Macro using Visual Basic 1. Click on the Developer tab. Then click on Visual Basic. On the following screen (Microsoft Visual Basic for Application), click on MegaStat (Megastat.xla) on the left, then click on the right arrow (hover your.
- Download
Thank you for using our software portal. Use the link given below and proceed to the developer's website in order to download MegaStat free.
However, we must warn you that downloading MegaStat from an external source releases FDM Lib from any responsibility. Please carefully check your downloads with antivirus software. FDM Lib takes it upon itself to provide free download links and inform users when the developing company starts providing a version of MegaStat for direct download.
Often downloaded with
Download Megastat For Mac Excel Shortcut
- Mega AI PredictorGiMeSpace Mega AI predictor is a program that is using past historical data to...$199.95DOWNLOAD
- TilEd 2002TilEd 2002 is an advanced, feature-rich tile editor with a modern...DOWNLOAD