Check Availability
Mar 2, 2007
I am doing a program for a car rent company (made up one).
What my problem is when a customer reserves a vehicle and another customer also wants to that same vehicle they should click on check availaility button to see if that vehicle is available or not.
way it should work is once one customer has reserved a vehicle with a specific start date and end date the button checks the vehicle, start date and end date and give a message to the customer tell them if the vechicle is available or not.
I have started it off but i am stuck in creating this function.
Here is the link to my program
[url]
View 9 Replies
ADVERTISEMENT
Apr 16, 2007
Has anyone got a spreadsheet that will calculate the availability of a server based on its hrs of service. Currently my spreadsheet will give me the availability of a server who's service hours are 24/7 however I have servers that are only supported 5 days a week between 07:30 and 18:30 and so only want to calculate failures that occur during that time when it comes to Availability.
I would of thought there would be a program on the market that does this but I haven't come across it and our company are kean on ITIL.
So to summarise, I key in downtimes every day what ever time of day they are but I want calculations on availability to only take in to account failures between 07:30 and 18:30 on certain servers.
View 10 Replies
View Related
Jul 5, 2014
I modified an employee schedule that I found on here to meet my needs but I am needing one more thing:
I need a field (or separate worksheet in the workbook) where I can enter employee availability and if they are unavailable for a specific day, it will auto update in the calendar stating they are unavailable for that day.
View 7 Replies
View Related
Dec 11, 2008
Attached is an excel file (test.xls) which shows work schedule (Week wise) of a person for two projects.
Now by looking at the sheet we can see the John is available from Work Week 8 (WW 8) onwards. The cells which have "1" in them indicate that John is busy.
Now I would like to achieve this (showing when John will be available) by using a formula in Cell B22. For example, if the formula can show somehow "WW8" in cell B22 it would suffice.
View 8 Replies
View Related
May 7, 2008
I am working on a Property Management spreadsheet to track the availability of vacant units (and upcoming vacant units). I'm trying to write a formula to count the number of current units that are listed as vacant, so that I can ultimately report on the overall unit availability as of any given period (today, 15, 30, 60, 90-days out). All of the data in this spreadsheet is dynamic and each field can change at any time. There are also a lot of blank fields as well. I am using Excel 2003.
Here are the fields/data that I am using for my analysis:
Column A - (Reporting Period Dates): A2 = 5/20/08, A3 = 6/5/08, A4 = 6/20/08, etc.
Column B - (Unit Status: V=Vacant, O=Occupied): B2 = V, B3 = V, B4 = V, B5 = V, B6 = V, B7 = V, B8 = O, B9 = O, B10 = O, B11 = O, B12 = O, B13 = O
Column C - (M/O Date. These dates represent when the current resident will move out) - Cells C2:C13 contain dates for when each tenant will move out
Column D - (M/I Date. These dates represent when the future resident will move in) - Cells D2:D13 contain dates when the future tenant will move in
If my reporting period is 5/20/08 (cell A2), then I need to calculate how many Vacant units (B2:B13) I will have as of 5/20. The formula will need to count all of the current Vacant units (B2:B13), plus it will also have to take into account any Move Outs (C2:C13) during the reporting period. For example, let's say we have an Occupied unit that is scheduled to move out on 5/15/08. The cell will show this as "O" but the formula will need to determine if the M/O date is <= the Reporting Date of 5/20/08 (A2). If so, then Excel would count this unit as a Vacant for the period.
In addition to this, I also need the formula to look at upcoming Move IN dates (D2:D13). The formula will also have to determine if the MI date is <= the Reporting date (A2). If the MI date falls prior to the Reporting Date, then this unit should be considered as Occupied and should NOT be added to the total available units. NOTE - there are quite a few cells in column D that are blank and don't have MI dates. If there isn't a MI date, then the formula should assume that those units are Vacant if it is past the prior tenants MO date.
I'm assuming that Excel can handle multiple conditions like this, however, I am not smart enough to figure it out.
View 9 Replies
View Related
Jun 7, 2007
In the sheet I'm currently working on I have a column (column C) that uses a validation so that users can select from a number of call types (data tracking in a call center). I allowed for an "Other" option, with a free-form column (column D) dedicated to the "other" reason in case the list doesn't cover the type, but I'm running into a problem where people use the other column to describe call types already listed. Is there anyway to lock the Other column (column D) unless Other is selected in the drop down in the Call Type column (column C)? The sheet I'm working with contains confidential data so I can't post it, but if this isn't clear enough I can draw up a mock sheet.
View 5 Replies
View Related
Nov 27, 2009
My company uses 4 types of barcodes 8, 12, 13, & 14 number barcodes for our products my problem is that I can't figure out how to force the barcode to format properly no matter how somebody enters it if they don't use spaces or put them in the wrong spots, I can't use custom formats because there is 4 different layouts
8 digit should be "#### ####"
12 digit should be "###### ######"
13 digit should be "# ###### ######"
14 digit should be "# ## ##### ######"
these barcodes are in columns L, M, & N also right now 'm using a formula in another cell to verify the barcodes by calculating the check digit and comparing it to the check digit typed the formula i'm using is
View 9 Replies
View Related
Aug 10, 2012
I have data in Row 53 that spans 7 columns, but stays in the same row. I want to design a loop to select every 7th cell in that row and check if it is empty. If not, add onto a "counter" then display the final number of occupied cells (the value of the counter) at the end. This is what I have so far, but I get all sorts of errors.
Code:
Sub Tester()
Dim WB As Workbook
Dim WS As Worksheets
Dim modCounter As Long
Dim Cell As Range
Set WB = Workbook("Transverse Series.xlsm")
Set WS = WB.Sheets(BM18)
[Code] ......
View 1 Replies
View Related
Nov 3, 2008
I am using this code
View 5 Replies
View Related
Jul 4, 2014
I want to have 1 check box affect 3 others in the following way: check box 1 if checked, allow check/uncheck of check boxes 2, 3, 4 if unchecked, uncheck boxes 2, 3, 4 and do not allow checking check box 1 is linked to D1 which starts with a value of false. cell E1 is if condition to have value 1 when D1 has value of true.
I have attempted to attach an example worksheet.
Test check control.xlsx
View 1 Replies
View Related
Sep 9, 2007
I am creating a userform with 10 checkboxes. The first 9 checkboxes are user options. I want the 10th check box to be a "Select All" option i.e. if the 10th checkbox is checked all the other 9 options are deemed to have been selected.
The way I want the display to work is that if the 10th checkbox is ticked all other checkboxes are cleared. Also if the 10th checkbox is ticked and any of the other check boxes is selected then the 10th checkbox should be selected.
I have tried coding this up but the checkboxes don't seem to operate as desired. I placed some code on the click event for the last option button to set the vlaue for all other buttons to false. This works but the 10th check box doesn't get ticked itself. When I try to code up the other bit I get similar issues.
View 9 Replies
View Related
Aug 20, 2009
When I press a command button I want to:
Uncheck a checkbox made with Control Toolbox
Check a particular Option Button within a group box made with the Forms Toolbar.
EDIT: Clarification, I want both things to happen when I click one button.
View 3 Replies
View Related
Jul 28, 2006
I have numerous hyperlinks in cells on a worksheet, next to these I have checkboxes. I am looking for a macro that will check if the boxes are checked and if not ignore them and if so run a certain macro.
View 6 Replies
View Related
Oct 31, 2011
Users can start an automatic copying process (active row from active sheet to sheet 2) by simply putting a date in a cell in column K. The activecell.row is copied over.
As part of the copying process, the value in cell D on the active row (the serial number) is copied to sheet 2.
Before this happens, I would like a checking procedure added to the code which will stop the same row being copied more than once, thus avoiding duplicates.
I have tried InStr and also worksheet.CountIf but can't figure this out.
Code snippet below.
If InStr(1, Sheets("Sheet!2").Range("A:A" & lngLastRow), TempRef) Then
Where the value in TempRef (the serial number) is searched for in Sheet 2 col A.
View 2 Replies
View Related
Mar 5, 2008
I have a sheet with 2329 rows. Row 1 & 2 should be the same number, then rows 3 & 4 should be the same, then 5 & 6, etc (see example below). This should result in an even number of rows, so either 2328 or 2330. So somewhere in this sheet, I either have a number repeated twice instead of just once, or a number that's not repeated at all. Is there an easy way to highlight where the error is without having to manually scan all 2329 cells?
23059
23059
23069
23069
23099
23099
23109
23109
23128
23128
View 9 Replies
View Related
Oct 21, 2009
I am trying to create a basic spreadsheet in MSExcel used to collect standard info (Name, address blah blah blah). The people who will complete this will need to classify the people they are listing into groups (Group A, Group B etc. 5 groups total) and each group will be listed on a separate tab of the workbook (maybe this isn't the best way?).
As they enter the people they will need to decide if the person they are adding is to receive the welcome kit. Each company is limited to 50 welcome kits. My thought is to use a check box for them to indicate yes or no on the welcome kit.
Is there a way to display the number of welcome kits that are remaining on whatever tab they happen to be on?
Is there a way to give a clear indicator next to each name that 'yes' has been selected (colored box, text?).
View 9 Replies
View Related
Mar 4, 2007
Is there a VBA function using which i can check for the existence if a particular value on an Excel ?
View 4 Replies
View Related
Jun 15, 2013
I am using an array from another application for option buttons. I have attempted to adapt this code for checkboxes but with no success.
VB:
Option Explicit
Private Sub cmdadd_click()
Dim wrs As Worksheet, i As Long, x As Long
[Code]......
View 5 Replies
View Related
Apr 21, 2014
I have a number of rows that contains data (normally numeric):
0 | 0 | 0 | 0 | ... |True
1 | 0 | 0 | 0 | ... |False
0 | 1 | 0 | 1 | ... |False
What's the formula that gives the True/False answers? I could go IF(AND(A1=0,B1=0,etc...),TRUE,FALSE) that gets the results, but can it be done in a smarter method or can it done via array method?
View 4 Replies
View Related
Nov 20, 2009
Is there a formula that I can use to check that all the depths are in a range of 1 to 5. If one depth is say 6 then this must be flagged up
View 4 Replies
View Related
Nov 30, 2009
I need two formulas that can do the folowing:
• check whether a cell contains text, if so, then trim all spaces and get result. If it doesn't contain text then set the result as blank.
• check whether THE CELL T13 contains text, if it does then check the adjected cell (U13) if it contains text, if so, then concatenate the two cells with a space between them and remove any other spaces. If the T13 doesn't contain text, the set the result as blank. Also, I have another question: how could I use the counta formula without counting spaces?
View 2 Replies
View Related
Oct 19, 2007
what is the vba code to check this conditon.
my excel file .sheet name "abc" . if cell "a3" have any value . and cell x3 values >=cell x10 ,then it show the input box to call new password "1234"
msgbox showned " true password you can work it now"
if user put wrong password .the workbook is cloesd with the msgbox "wrong password" then the application closed exit.
-cell x3 is datetime values "now" to compare with the cell x10 is the datetime "01012009 8:00" to check the outof date of the application
View 11 Replies
View Related
Jun 18, 2008
I am working on a sheet in Excel 2007 and am having trouble with Excel toggling with a checkbox. What I want is for a cell to have "A" in it if the box is checked and a "B" if it isn't. The code I have is:
Sub CheckBox6_Click()
If CheckBox6 = True Then
Range("B20") = "A"
Else
Range("B20") = "B"
End If
End Sub
View 9 Replies
View Related
Aug 17, 2008
Is there a way to test if let's say range a1:a10 contains a value of cell b1.
I would be thankful to get the VBA code to do that
View 9 Replies
View Related
Sep 22, 2008
I have a problem with my Excel Sheet, i am trying to write a macro that it checks the ids under the id column
Example:
ID | Ast Code | Ast 1 | Ast 2 | Ast 3
----------------------------------------
Id1 | Ast 1 | 1 | empty | empty
Id1 | Ast 2 |empty | 1 | empty
Id2 | Ast 3 |empty |empty | 1
Id3 | Ast 3 |empty |empty | 1
Id3 | Ast 1 | 1 |empty |empty
Than it must check for the duplicates ids what Ast Code they have, than at the result it must write from the previous one or from the after one take the Ast Code and write it near it..
For Example:
ID | Ast Code | Ast 1 | Ast 2 | Ast 3
----------------------------------------
Id1 | Ast 1 | 1 | 1 | empty
Id1 | Ast 2 | 1 | 1 | empty
Id2 | Ast 3 |empty | empty | 1
Id3 | Ast 3 | 1 |empty | 1
Id3 | Ast 1 | 1 |empty | 1
View 11 Replies
View Related
Oct 13, 2008
I have is that the code does call the spell-check up and it goes through the motions.
However, when you perform this manually (as in from the toolbar), the spell-check accepts the items as you put in the text bar at the top if you change it.
When doing it via the VBA macro code, it will not accept the user amended-suggestions unless you highlight the (top) text bar area/row/cell to get it to accept some things - otherwise it just accepts the suggestion the checker gives n the section below - not the text you have amended.
View 6 Replies
View Related
Oct 14, 2008
how to check whether an ocx is already registered when template is opened in excel?
this is to register an ocx control used in the xlt.
View 2 Replies
View Related
Nov 3, 2008
I am using a menu button to run a macro. Before running a particular Macro, I would like excel to check if the cell A1 of a worksheet named 'MC_1921' contains the phrase 'Master Curve' ...if it does then the macro runs otherwise gives an error message.
View 4 Replies
View Related
Dec 16, 2008
I have about 1500 check boxes and I don't know how to select all and deselect all. Check boxes are on a user form and I really need them all because each on of them represent one daily activity which I use for prediciting future activities.
View 2 Replies
View Related
Mar 11, 2009
for example, is it possible to check if a Reference to Set a reference to Microsoft Internet Controls (shdocvw.dll) has been enabled in user Reference settings. And if not set, then set it via VBA
View 4 Replies
View Related
