Basic Jobs

43 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Fixed-Price - Expert ($$$) - Est. Budget: $150 - Posted
I need the attached spreadsheet modified slightly with additional macros and pivot tables working correctly. 1. Can you take each of the recipes on the "recipe" sheet and move them each onto a separate worksheet rather than having them all on one sheet. 2. The "cook numbers" sheet tells all the "recipe" sheets how many portions to populate the recipe ingredients with and then the "kitchen print off" sheet populates with the ingredients for our chef to print off and put up in the kitchen. Can you setup the "kitchen print off" sheet so - It only prints one recipe per page, landscape - It only prints recipes that have greater than 0 portions chosen I imagine the print button will be a macro 3. Can we add a macro into the "cook numbers" sheet that will be a "add new recipe" button that will generate a new blank recipe worksheet for us to populate from the dropdown list of ingredients AND that will also add this recipe to the "cook numbers" sheet for determining total portions to be cooked. 4. The "order sheet" is the most important part of this whole spreadsheet, the macro button in the top left corner populates the pivot tables on this sheet to show all the ingredients that we need for that week from each different supplier. -1st priority is to make sure this is working properly with all the other changes you're making to the spreadsheet - Then is it at all possible to create a macro that will automatically populate a gmail email? - If not is it possible to create a macro that will automatically populate a word document with each of the tables listed out so it's easy to copy & paste into an email.
Skills: Visual Basic IMacros Microsoft Excel Microsoft Excel PowerPivot
Fixed-Price - Entry Level ($) - Est. Budget: $150 - Posted
I am looking to develop a data entry stand alone module What it needs to do • Windows 10 compatible • I need to be able to paste a list of words separated by comma or semicolon (, or ;) • I need to be able to type in words separated by comma or semicolon (, or ;) • On input duplicate words or phrases must be removed (regardless of capital letters). To clarify only rows that are an exact match to an existing row should be eliminated • Display the keywords in a column • Allow me to sort the rows of the column by drag and drop • A sort alphabetically button • Will display the number of rows (phrases) • Will display the number of characters • Will allow me to copy the list to the keyboard while inserting a comma (,) between each phrase In most cases the phrases will be of a single word in a few cases two words and rarely of three words for example : Pygoscelis papua, Gentoo penguin, Penguins, Animal behaviour, Animals, Antarctic, Marine biology, Antarctica, Aquatic, Biological, Biology, Bird, Birds, Chick, Coast, Coastal, Duo, Fauna, Flightless, Marine, Nature, Ornithological, colonies, colony, flock, Ornithology, Sea-bird, Penguin, Sea-birds, Seabird, Seabirds, Wildlife, Young, Zoological, Zoology, Adult, Animal, Living nature, Natural life, South pole, psi, Lilachw This stand alone software will, eventually, be part of a larger tool so I will need all rights to this application and the source code as well as the compiled ready to run windows 10 environment Additionally, I would like to know the cost of connecting this application to an English dictionary such as MS or Google and highlighting misspelt words (similar to MS-Word)
Skills: Visual Basic Java
Fixed-Price - Intermediate ($$) - Est. Budget: $50 - Posted
I need someone to develop a tool using access/excel which have three main function. 1. the tool can find product item list based on vendor, item no and part no. after chose all the three item, the tool will show two price. This price shows based on automatically calculation 2. the tool have two access, for group A only to view. Group B have all access specially for inputting manual item,brand,part no, etc. 3. The tool also have function to show buffer stock item. I will send you my sample if you want
Skills: Visual Basic Microsoft Access Programming Microsoft Excel
Hourly - Entry Level ($) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
Hi, I have an excel workbook with 5 different worksheets. I would like to develop an option for the user to click and export to word. I am not very technical, so am not sure if this is possible. Ideally, the option would allow the user to click a button and export the quantitative and qualitative information straight into a pre-defined template to word.
Skills: Visual Basic Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $500 - Posted
I have a restaurant pos system i need to add tablet order mainly 8" size please see the attachment UserID = GetUserIDByPassword(password) If userid > 0 then strRoleName = GetRoleNameByUserID(UserID) If RoleName = “Waiter” then Go to Order Page Else Go to waiter selection page > Select Waiter > Go to order Page End if End if Order Page TABLE NUMBERS CREATE TABLE [dbo].[tblTables]( [Table_Number] [int] NOT NULL, [Status] [nvarchar](20) NULL, [GroupID] [int] NOT NULL, CONSTRAINT [PK_tblTables] PRIMARY KEY CLUSTERED CREATE TABLE [dbo].[tblUser_tblGroup]( [UserID] [int] NOT NULL, [GroupID] [int] NOT NULL, CONSTRAINT [PK_tblUser_tblGroup] PRIMARY KEY CLUSTERED intGroupid = GetGroupIDByUserID(UserID) Each waiter will be assigned to to table group such as group 1,2 or 3 The waiter by default will see table that has been assigned if he/she want to select different tables other than one that has been assigned to he/she will click button that shows selected tables To show the tables("Get_Tables", intGroupID) Loop through If table status = “Occupied” then set button color to red To take on order: Add new order or add new item for existing order. To add new order he/she will select table (not occupied) i.e. table with no existing order. When let us say table 23 is clicked then you update table status to “Service” change the color disable table selection to avoid selecting other table number. Enter tblreceipt CREATE TABLE [dbo].[tblReceipt]( [Receipt_ID] [int] NOT NULL, [Receipt_Date] [date] NOT NULL, [Table_Number] [int] NOT NULL, [Amount] [real] NOT NULL, [Status] [nvarchar](30) NOT NULL, [Phone] [nvarchar](20) NULL, [Room_Number] [nvarchar](30) NULL, [UserID] [int] NOT NULL, [Company_ID] [int] NOT NULL, [IsSelected] [nchar](10) NULL, [Waiter] [nvarchar](30) NULL, [Receipt_Time] [time](7) NULL, [Is_From_Web] [int] NULL, [waiterID] [int] NULL, [Order_Nbr] [int] NULL, [Reset_Order] [nchar](10) NULL, CONSTRAINT [PK_tblReceipt] PRIMARY KEY CLUSTERED ( [Receipt_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblReceipt] ADD CONSTRAINT [DF_tblReceipt_Reset_Order] DEFAULT (N'No') FOR [Reset_Order] To get max Order_Nbr you use SELECT ISNULL(MAX(Order_Nbr) + 1, 1) AS id FROM tblReceipt WHERE(Reset_Order = N'No') You enter information for the tblreceipt intReceiptid = GetLastReceiptIDByUser To display the menu Here is the field for the table menu you don’t need to enter any information you just read menu from CREATE TABLE [dbo].[tblItems]( [Item_Number] [int] IDENTITY(1,1) NOT NULL, [Item_Name] [nvarchar](50) NOT NULL, [Price] [real] NOT NULL, [Category] [nvarchar](30) NOT NULL, [Rank] [int] NULL, [Status] [nvarchar](20) NULL, [Dept] [int] NULL, [Tab_Number] [int] NULL, [COGS_Item] [nchar](10) NULL, [Menu_Nbr] [nvarchar](20) NULL, CONSTRAINT [PK_tblItems] PRIMARY KEY CLUSTERED ( [Item_Number] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] To display the menu ALTER PROCEDURE [dbo].[Get_Mune_By_Tab_Number] -- Add the parameters for the stored procedure here @Var1 int AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT Item_Number, Item_Name, Price, Tab_Number ,Menu_nbr FROM tblItems WHERE (Status = N'Available') AND (Tab_Number = @Var1) ORDER BY Rank,Item_Name END Add receipt Details CREATE TABLE [dbo].[tblReceipt_Details]( [Receipt_DetailID] [int] IDENTITY(1,1) NOT NULL, [Receipt_ID] [int] NOT NULL, [Item_Number] [int] NOT NULL, [Quantity] [int] NOT NULL, [Price] [real] NOT NULL, [Sub Total] [real] NOT NULL, [Status] [int] NOT NULL, [Invoiced] [nchar](10) NULL, [Note] [nvarchar](50) NULL, CONSTRAINT [PK_tblReceipt_Details] PRIMARY KEY CLUSTERED ( [Receipt_DetailID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] When you click print you update this feils “UpdateTableStatus", "Occupied", intSelected_Table "UpdateReceiptStatusByID", "Open", ReceiptID “SetReciptTableIsSeletedByReceiptID", "Yes", ReceiptID UPDATE tblReceipt_Details SET Status = 2 FROM tblReceipt INNER JOIN tblReceipt_Details ON tblReceipt.Receipt_ID = tblReceipt_Details.Receipt_ID WHERE (tblReceipt.Receipt_ID = @Var1) To add new item for the existing order you select table number ReceiptID = ("GetReceiptNumberByTable", intSelected_Table, Waiterid) SELECT Receipt_ID, UserID FROM tblReceipt WHERE (Table_Number = @Var1) AND (Status = N'Open') AND (UserID = @Var2) END We print not printed receipt only i.e. receipt with status = 1 good luck
Skills: Visual Basic HTML5 Mobile UI Design
Hourly - Entry Level ($) - Est. Time: 3 to 6 months, 30+ hrs/week - Posted
Developer need to have been involved with desktop vb6 apps that have extensive gui layer that allowed users to customize grids, layouts, toolbars, etc And knows how to make vb6 apps to look modern by using themes Someone who codes very careful and bug free And does not write unoptimized code. If you find Mr right, let me know
Skills: Visual Basic
Fixed-Price - Intermediate ($$) - Est. Budget: $6 - Posted
I need to create a simple calculator in Visual Basic.
Skills: Visual Basic
Fixed-Price - Intermediate ($$) - Est. Budget: $5,000 - Posted
Must be experience with Microsoft Visual Basic VB6 and C#. Need to convert approximately 225,000 effective code lines of VB6 to C#.
Skills: Visual Basic C# SQL
Fixed-Price - Entry Level ($) - Est. Budget: $60 - Posted
I need a few minor updates made to an existing VB 6.0 application that was made about 15 years ago. Changes would include: 1 - A new App Icon 2 - Update an image within the application. 3 - Adjust a drop down lists that is currently hard-coded with selection options. We would like this to instead list all the sub-folder names within a folder, instead of utilizing hard-coded options. 4 - Re-package the application with an updated folder of images. Deliverables would include the updated source code with the new distribution.
Skills: Visual Basic