Archive

Posts Tagged ‘row’

X-cart Data Feed. (price Per Each Row.)

January 30th, 2012 Comments off

We are looking for an individual or company experienced in X-Cart Excel data feed work. We would like to pay a per-product price, that is a price per spreadsheet row.

Payment is to be made only after successful data feed upload.

We will need only a few rows to begin. As these are completed, we will send product details for more.

Please bid if you have experience with these data feeds. We are ready to assist as needed but we are not willing to provide any extensive training.

Please …

Innerhtml Issue With Ie (2)

January 28th, 2012 Comments off

Works in FF but not IE — I believe this is the piece of code that needs some IE magic

function tableAddRow(num, text, style) {
var table = document.getElementById(‘resultsTable’);

var row = table.insertRow(num);
row.className = style;
row.innerHTML = text;
}

Innerhtml Issue With Ie

January 28th, 2012 Comments off

Works in FF but not IE — I believe this is the piece of code that needs some IE magic

function tableAddRow(num, text, style) {
var table = document.getElementById(‘resultsTable’);

var row = table.insertRow(num);
row.className = style;
row.innerHTML = text;
}

Script To Rename Duplicate Fields In Mysql

January 13th, 2012 Comments off

I’d like to resquest a PHP script that works the following:

I have a field called “title” in a table “my_table”. I have noticed there are some duplicate titles in diferent rows and I need to modify them for SEO purposes.
I need a script that will search for all duplicate titles in a way that it will add numbers to the duplicate titles, as exampled below:

Title to be verified: “Laptop computers” row #1
Number of duplicates found (same titles): 5 occurences (row #69, row #666, row #1009, …

Mysql Php

January 7th, 2012 Comments off

I have two databases on same server.

I need a simple php script to check if a value is in a column.
If it is copy the row excluding the primary key (id) to another database on the same server ( same column structure) and insert it as a new row.

Then delete the initial row in the first database.

I need you to do it and just give me the code – that’s it.

Just use these details

database 1
dbusername = “john”;
dbpassword = “56789″;
dbserver = “localhost”;
dbname = “soft”;

Tab…

Categories: MySQL, PHP Tags: , , , , ,

A Java Function To Change Single Table Row Appearance

December 22nd, 2011 Comments off

I prepared a demo that illustrates the goal of this project:
A single row table appearance (border color and button) must change when a radio button is selected. Solution to be simple, cross browser and PHP-5, HTML-5, CSS-3 compliant.

The demo can be found on reverd d0t c0m slash test slash search_results_2 d0t php

(it will be a form)
Unselected radio button table has grey border and light yellow placeholder for button
Selected radio button table has black border and yellow working butt…

Categories: CSS, Java, PHP Tags: , , , , , ,

Multiline Grid Control – Ms Dynamics Crm 2011 Online

November 19th, 2011 Comments off

Add a grid control with a row height of 8 lines . I have an entity called NTES – related to contacts. Add a grid control to the CONTACT form to display the NTES .
Display the first 8 lines of the DESCRIPTION field. Each row will be 8 lines high.
Must have the ability to:
- vertical scroll on “description” field
- Change row height and save it
- The grid data columns are based on CRM views and associated views – ability to filter the view – sort the view – change the columns – select the…

Categories: Crm, Editing Tags: , , , , , ,

Data Entry

November 11th, 2011 Comments off

I run a recruitment company and have circa 3400 CV’s that need the details (Name, Address, Position, Telephone numbers etc) adding to an excel sheet (See the attached sheet and CV’s for example)

The Industry row can be left blank, the Location row is the same of the County row.

Each CV will be in a folder marked either: Sales, Commercial, Land, Construction, Finance, Operations, Managing Director (MD). Which ever folder the CV is in, will be added into the Sector row (eg: if the CV is in the Commercial folder, “Commercial” will be entered into the Sector row).

I have had a data entry project before which was a disaster as the work too 4 times longer than expected and 70% of it was incorrect and I spent most of the time doing the work and checking it, so please only bid on this if you are 100% serious and can complete to the highest standard.

I would like an excel sheet done for each folder (sales, commercial, construction etc)

Php-mysql-mobile

September 27th, 2011 Comments off

We want to build single php page or 3 pages which would perform following depending on parameter passed
1. Insert or Update “personcodes.csv” file to Mysql database both on same hosting server(Table Structure – personcode, passwd, type, flags, csvfile, lastupdatedate)
2. Retrieve “personcodes.csv” file and display 3 fields (personcode, mobileno, message – in each line fo the file) in HTML table as below on mobile web browsers – attractive colors, alternate changing colors for ease of use since the table rows would be in hundreds. It would be better if each row is displayed as 2 rows of the HTML Table. On first row – personcode, mobileno and on second row message
3. If the mobileno. is clicked, it should send SMS thru mobile (The application on mobile device should run on different companies handsets)

Additionally, we need 2 more pages for password with encryption
4. Login page to access above pages
5. Change Password page

We would have all IPRs for the source and binary code delivered to us

Reporting Script — Pulling From Mysql

August 30th, 2011 Comments off

I have a mysql database where each row stores a field with a date and a field that contains a pipe-delimited series of IDs that are associated with a contact record.

Each row is one month. There are 24 months worth of data.

I want a report created in php that will go through each month and tell me how many months each of those contact IDs is in their consecutively. (i.e. if they are in month 1, month 2, month 3, but not month 4, that would return a value of 3 for that ID).

If It’s easier to have a script that creates another table based on the original table but with a row for each contact ID, then that would be an option too.

Multiline Grid Control – Ms Dynamics Crm 2011 Online

August 24th, 2011 Comments off

Add a grid control with a row height of 8 lines . I have an entity called NTES – related to contacts. Add a grid control to the CONTACT form to display the NTES .
Display the first 8 lines of the DESCRIPTION field. Each row will be 8 lines high.
Must have the ability to:
- vertical scroll on “description” field
- Change row height and save it
- The grid data columns are based on CRM views and associated views – ability to filter the view – sort the view – change the columns – select the view
- allow for opening of the record for editing
- Allow for grid to be placed on on a collapsible tab on the form (much like you can do with any CRM tab on the form)
- Performance – do not slow down the opening of the CONTACT form by more than 1 second

DISPLAY THE FIRST 8 LINES OF EACH ROW ON NTES GRID

Categories: Crm, Editing Tags: , , , , , ,

Multi-member Site For 24 Personality Test Questions

July 24th, 2011 Comments off

I have a detailed listing of personality test questionnaires, which depending on the answer that user has chosen, he will skip adhoc to a distant question far behind in the questionnaire. All in all, he will answer only 24 questions out of 900, which means programmer needs to enable him to skip to the right question depending on the answer he has picked. This is a system of 5 Multiple-Choice answers to each question, for him to choose.

Note, however, after answering 4 questions each time, he will be assigned 2 letters of the alphabet, and you are to store this in one row in the database according to the user’s id.

So, 6 sets of 4 questions (since 6*4=24 questions), and he will be assigned 2 letters of the alphabet 6 times. Store these 6 pairs of alphabetical letters in one row in the database. The next user id will have corresponding next row of 6 pairs of alphabetical letters, corresponding to each set.

Also, I want the user’s answers picked and the question number that he was directed to answer (out of this list of 900 questions) stored in a separate table or database. The best is 1 row of 24 columns indicating values for the question number in one table, and 1 row of 24 columns indicating values for the MCQ answer he has chosen.

Then only the next member id will be the next row on each table.

So, got it? So, this will be a members’ site, for many members to attempt 24 questions, and have their answers and question number stored , as well as the 6 pairs of alphabetical letters.

So, all in all, 3 tables only required. But different rows or observations will corresponding with the next member and so on, as this is a multi-member site.

Expect no mistakes, as I am a busy person and am hardpressed for time to pinpoint errors to programmer. Programmer expected to be independent, highly accurate in your coding, as I am very busy.

Interactive Web Script/program

June 27th, 2011 Comments off

WHAT I HAVE SO FAR:
I have an HTML form of 48 textbox fields. Each box represents the user’s preference for something I will be asking him about. The user can choose to enter as many as 48 preferences or leave as many blank as he wants (so the range for textboxes with values is 0 to 48).

WHAT I WANT TO CONTRACT YOU FOR:

I want to develop a script or small web program to allow users to do the following 3 things while they are still on my web page. This is what I have in my head but I am open to your expertise if there is a better way.

1. Transfer only the textboxes with non-null values into a two-column table, leaving out the null textboxes. So if the user only filled out 350 of the 48 values then the table will only have 30 rows. The first column of the table will just have numbers from 1 to n, with n being whatever number of textboxes were passed to the table. You are welcome to just generate the table client-side because I’d like it to be anonymous anyway. You don’t even have to hide the table because the user will find it useful to print out the preferences table after it is generated.

Example:

TABLE
———————
1. | Preference 1
2. | Preference 2
… |
n. | Preference n
———————

2. At this point, I want to present the user with forced choices between his preferences (sort of like how personality tests force you to choose an answer). I would prefer to have the user presented with just one face-off at a time, perhaps he can click on one of two buttons and then those buttons disappear and the next face-off appears. If this is too complicated for the price I’m asking then you could spit out radio-button faceoffs all at once, but I would prefer to avoid that if possible. I envision this as sort of a rapid-fire presentation, where the user sees the two choices and clicks based on his initial reaction.

So,

Row 1′s Preference vs. Row 2′s Preference (User Clicks Choice)
Row 1′s Preference vs. Row 3′s Preference (User Clicks Choice)

Row 1′s Preference vs. Row n’s Preference (User Clicks Choice…etc.)

Then
Row 2′s Preference vs. Row 3′s Preference
Row 2′s Preference vs. Row 4′s Preference

Row 2′s Preference vs. Row n’s Preference

Then Row 3 versus all remaining preferences, then Row 4, etc. until all preferences have been compared with each other just 1 time.

This is called “forced ranking” and is used in the field of human resources, but I am applying it to something else here. I realize that this will be over 1000 choices but I have already cut down the fields from 80 so I don’t think I can go lower.

3. After the user has been forced to make choices between each preference, I would like to give him some very basic output that shows the counts for how many times he chose each preference. This could be a simple ranked list with the count numbers in parentheses or a table. No need for other stats. This can all be done right on the web page.

Please let me know if you have questions or better ideas about how to do all of this. I would definitely like it to be on the web page and not a stand-alone program though.

Graph Operations (array Storage Of Matrix)

June 3rd, 2011 Comments off

STEP 1: Adjacency Matrix in an Array

Write pseudocode (comments in your program) for how you can determine the degree of a vertex given the adjacency matrix.

Download Math233 iLab5.zip (or in Doc Sharing). This contains the shell C++ weighted graph data structure class and test program (TestWtgraph.cpp) and sample input file(a.dat). Make sure to notice in the WtGraph constructor it allocates the adjacency matrix as a one-dimensional array large enough to store an NxN two-dimensional matrix.

adjMatrix = new int [ maxSize*maxSize ];

Then the WtGraph “edge” function is used to access or update a row,column position using “offset” in the one-dimensional array.

edge ( int row, int col ) //Note that, for example edge(0,3), represents the row 0 column 3 entry of the edge matrix
// Gets/sets adjMatrix[row][col].
{
return adjMatrix[maxSize*row+col];
}

Note that, when running the program, instead of loading the above file, you may also insert vertices one at a time with the commands:
+a
+b
.
.
.
+i

The weights can also be inserted one at a time:
=0 1 10
inserts a weight of 10 to to the edge joining v(0)=a and v(1)=b.

STEP 2: Count Odd and Even Degree Vertices

Write a new member function “degree” for the Wtgraph C++ class given. The “degree” function should determine and output how many even degree vertices and how many odd degree vertices a weighted, undirected graph has. The .cpp source code has a marker where you are to insert your code.

An idea is if you think of the edge matrix above as a weighted adjacency matrix where
M(i,j) = the number of edges joining v(i) & v(j), with the exception that for M(i,i) count each loop twice.
this will guarantee that the sum of row i is the degree of v(i).

Some general notes:
________________________________________________________________________________________

You will only add code to the
void WtGraph:: degree()
portion of the .cpp file. That will be the only portion of the program where you will do modifications.

________________________________________________________________________________________

For each row you want to:
(i) add up all its entries.
e.g., row 0 in up above is
0 10 0 5 0 0 1 0 0
Add them: 0 +10+ 0+ 5 + 0 + 0 + 1 + 0 + 0 = 16
(Thus, vertex 0 has degree 16)

(ii) determine if that sum is odd or even
e.g., for row 0 it is even, since 16 is even <—-row 0 has even degree
i.e.
16%2 =0 <———————————–16/2 has remainder 0

Then determine how many rows have an even sum and how many have an odd sum. This will involve keeping track and counting the number of even sums and the number of odd sums.
________________________________________________________________________________________

The variable declared as
int size;
in the .cpp program is the number of vertices and thus it is the number of rows (and columns, too).

The variable declared as
int& edge ( int row, int col );
in the .cpp program is the actual matrix that you see in the iLab itself.

Thus, edge(0,6) would represent the 0,6 element of the matrix.
Note that up above edge(0,6)=1

________________________________________________________________________________________

Note this command in the .cpp file
infiniteEdgeWt = 9999;

A use for infiniteEdgeWT is that blank, in this case 0, entries are preset to infiniteEdgeWT. Hence, in the matrix up above we have:
edge(0,2)= 9999

Thus, you will need a condition so that blank entries are not added to the sum. Here is one idea for what can be inserted inside the innermost nested for loop:
if (edge(i,j) < infiniteEdgeWt) // this is needed because blank entries are preset to 9999 and not 0 in this program, do not want to add 9999 to the sum
then add edge(i,j) to the sum.

SAMPLE OUTPUT:

Command: L (user input)
Enter filname: a.dat (user input)
Graph loaded from a.dat

Vertex list :
0 a
1 b
2 c
3 d
4 e
5 f
6 g
7 h
8 i

Edge matrix :
0 1 2 3 4 5 6 7 8

0 – 10 – 5 – – 1 – -

1 10 – 4 – – – – – -

2 – 4 – – – 2 – – 8

3 5 – – – 5 – 4 – -

4 – – – 5 – 3 – – -

5 – – 2 – 3 – – – 2

6 1 – – 4 – – – 6 -

7 – – – – – – 6 – 6

8 – – 8 – – 2 – 6 -

Command: D
Number of Even Degree Vertices = 7
Number of Odd Degree Vertices = 2

(Note: If you choose to load a.dat as above, make sure your .cpp file and a.dat files are in the same folder where your current .cpp file exists.)

Categories: C/C++, Modification Tags: , , , , , ,

Copy Email Address 3

May 13th, 2011 Comments off

I am looking for someone to copy email address from the following sites;

see attatchement for website

Navigage to them, extract the email, copy and paste to excel in the first row, with the recond row showing company name, third row phone number

Thanks

Copy Email Address 3

May 11th, 2011 Comments off

I am looking for someone to copy email address from the following sites;

see attatchement for website

Navigage to them, extract the email, copy and paste to excel in the first row, with the recond row showing company name, third row phone number

Thanks

Copy Email Address 2

May 9th, 2011 Comments off

I am looking for someone to copy email address from the following sites;

see attatchement for website

Navigage to them, extract the email, copy and paste to excel in the first row, with the recond row showing company name, third row phone number

Thanks

Simple Tab Style App With Table View And Detailed View

May 9th, 2011 Comments off

I need a very simple iPhone/iPad universal app.

This should be coded in Xcode only, all views should have their own individual nibs so I can edit in Interface Builder.

The app will have 3 tabs.

1st tab will be blank, I will edit but still need a nib so that I can edit myself via Interface Builder.

2nd tab is where most all the work will be done. This tab will have a table view. This table view must have a small icon on the left and then enough space for a row of text. This table must be customizable, meaning where I can add my own table row image and a background behind the table.

Each row when clicked will lead to another set of table view rows. These will be a little wider rows because they will hold more text per row than the previous table. There should still be a icon on the left side and then at least space enough for 5 rows of text.

Clicking on any of these rows simply opens a url link.

This info for the 2nd tab will load all thru a xml file that comes from my server. Each time the app opens it should check to see if there is a new update to the xml file, if not, then it uses the existing info. The xml file should hold the text for each row and the link. The individual row images will be held in the app itself.

3rd tab will load a webview with google.com. I need a forward & back button for the webview and activity indicator. It should as well check for internet connectivity.

Excel Guru Needed For 3 Urgent Excel Macros

May 7th, 2011 Comments off

I urgently need for today (Sunday) the following three macros for the attached Excel file:

1) a macro assigned to the button

Copy Email Address

April 29th, 2011 Comments off

I am looking for someone to copy email address from the following sites;

see attatchement for website

Navigage to them, extract the email, copy and paste to excel in the first row, with the recond row showing company name, third row phone number

Thanks

Divide By Zero

March 15th, 2010 Comments off

I have some perl/sql code where I want the 3rd column a percent which will be the result of 2rd column divided by the 1st column.

I think someting like
my $percentage = ($row[1] ne

Categories: Perl/CGI, SQL, Writing Tags: , , , , , ,

Customize Phpmotion 3.5

February 20th, 2010 Comments off

Please give pricing for each component separately.

1. Customize so that category covers all forms of media. For instance, if you look up the topic Finance, the page should show a row of videos with thumbnails on this topic and an arrow to view more. Under that a row of audios on this topic with arrow to view more. And under that a row of blogs on this topic.

2. Create more ad slots.

3. Possibly a news feed with headlines on the left side of each category page. This feed should be content-relevant. For instance, if the category is finance, then the headlines should be about finance.

4. Maybe create a new skin using the default template. Right now, I bought a template, but maybe it is best to just customize the default to ensure compliance when the PHPMotion script is updated.

5. If using the current template, fix to ensure it works correctly.

Simple Csv Editor

February 11th, 2010 Comments off

I need a standalone program writing to edit CSV files. It can be a simple program with an import/export/convert function.

Editing rules:
See attached file. In column ‘reference’ there are multiple items per row. For example, line 10 has values “C2, C10″ which is in effect two different products. I need the file writing out with just one product per row, so line 10 would in effect be duplicated, one with C2 in the column, and once with C10.

If you look at row 27, you will see here that there are 4 products on one line, so this again needs the file writing out with 4 individual lines.

Row 8 is a little more complicated, because it is actually continued onto row 9. Again, all 13 of these products need their own line in the exported file.

In the example, multiple products are seperated by commas. However, i also need the export to handle multiple products using this fashion “C15-18″ which would mean uindividual lines for C15, C16, C17, C18.

The number, and position, of columsn and rows will vary on each file.

The CSV needs importing, and displaying in columns on screen. Each columns to have a ‘tickbox’ next to it, and the user then unticks which columns he doesn;t want on export.

The user needs to be able to select how many rows at the top of the file can be ignored (and not written out on export)

the user needs to be able to select the exported file as either comma delimted, space delimited or tab delimited

The rpogram needs all normal browse/save/save as features.

Categories: Programming Tags: , , , , , ,

Database Call

February 3rd, 2010 Comments off

Results pulled in a table to show daily totals from queries will probably run with cron
example:
User Tab Tab Index Date
3000 5000 02-01-2010
2499 4588 02-02-2010

I would think all queries could be in one statement but not neccesary

1.

<?php
$query = “SELECT sum(DISTINCT price) FROM user_tab where status=’active’”;
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
$price = number_format($row['sum(DISTINCT price)'], 2,’.’ , ”);
echo “$price”;}?>
<td>
2.

<?php
$query = “SELECT sum(price) FROM tab_index”;
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
$price = number_format($row['sum(price)'], 2,’.’ , ”);
echo “$price”;}?>
<td>
3.<?php
$query = “SELECT DISTINCT datetime FROM tab_index”;
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
$date= date( ‘m-d-Y’, strtotime( $row['datetime'] ) );
echo “$date”;echo “<br>”;
}
?>
</table><br>

Categories: MySQL, PHP Tags: , , , , , ,

Excel 07 Documentation

February 2nd, 2010 Comments off

Looking for someone that can write a training guide for Microsoft Outlook 2007 on the 40 “how to” items listed below.

The documentation should include step-by-step instructions along with relevant screen shots.

First draft must be complete no later than 2.19.10.

How to select an entire worksheet
How to add new worksheets
How to delete a worksheet
How to name a work sheet
How to insert a row
How to insert a column
How to insert a cell
How to increase or decrease the size of a row
How to increase or decrease the size of a column
How to autofit a column width
How to autofit a row height
How to format cells for font size, color
How to add gridlines to an entire worksheet
How to add a border
How to space text across several columns
How to top, middle and bottom align text in a cell
How to wrap text in a cell
How to indent text in a cell
How to find and replace text
How to insert a picture
How to sort a column from A to Z or Z to A
How to sort a column from A to Z or Z to A
How to sort the contents of an entire worksheet by just the data in one column
How to create a simple formula (For example: Number of Hours Worked * Rate
How to create a formual to sum a column of numbers
How to format cells for currency, text, dates, numbers, time and percentages
How to create a header and footer
How to insert a hyperlink
How to create a column, pie or bar chart
How to change the margin sizes and do a custom margin size
How to change the orientation from landscape to portrait
How to set and clear a print area
How to insert a page break
How to print entire document to 1 page
How to print the same top row on each page
How to print the same first column on each page
How to freeze panes
How to freeze the top row
How to freeze the first column
How to separate the contents of one cell into multiple cells (for exampe; a column that has first and last names that is split into 2 colums

Categories: Writing Tags: , , , , , ,

Ms Excel 2007 Scripting 2

February 1st, 2010 Comments off

I have a spreadsheet that I would like to have a button that automatically populates data from that row and puts it onto another workbook, and then prints that workbook. I included a sample so you can see what I’m looking for. The first worksheet needs to have a button on each row to print data from that row onto specific fields on worksheet # 2. Please let me know if you have any questions. Thanks!!!

Ms Excel 2007 Scripting

January 29th, 2010 Comments off

I have a spreadsheet that I would like to have a button that automatically populates data from that row and puts it onto another workbook, and then prints that workbook. I included a sample so you can see what I’m looking for. The first worksheet needs to have a button on each row to print data from that row onto specific fields on worksheet # 2. Please let me know if you have any questions. Thanks!!!

Excel Macro Needed

January 28th, 2010 Comments off

I need an excel macro which extracts websites from google m*a*p*s.

I will provide keywords in the first row.

Excel macro has to extract the websites listed in google m*a*p*s for that search term and listed the first 100 (non-duplicates) just below that keyword in excel.

For example, if I give : Mortgage Brokers,CA and run the macro, it has to bring the first 100 websites (non-duplicates) websites from the google m*a*p*s and paste it one by one from row 2 to row 101.

I may have many keywords in the same excel file in the first row each of them in separate column.

The macro has to process all the keywords.

Demo needed before awarding the project. (You may limit the results first 10 or 20 only in the demo)

Joomla Table Customisation

January 17th, 2010 Comments off

Hello,

You will only be able to see the requirements of this project if you do the following

1. go to www.reelafrica.co.ke
2. Click on ‘Members’ Login’
3. Login with MCMuckle/martpass (second menu will appear)
4. Roll over ‘Records’ and click on the first dropdown menu item ‘Freshwater All Tackle’

You will see a table. The left column has weights and the top row has fish.

This project is in 2 parts, one easy and one tricky…

1. Each of the blank cells in the table need to be divided into 3 rows with the following letters at the left of each row

M
W
J

2. The left row has to be locked when scrolling left and right ONLY
3. The top row has to be locked when scrolling up and down ONLY

IE. When scrolling left and right the left column stays visible but the top row moves

When scrolling up and down the top row stays visible but the left column moves.

Both left and column and top row should both always be visible in order to be able to cross reference each of the cells.

Any questions please PMB

Thanks

Conditional Formating Excel

January 15th, 2010 Comments off

Hello
This is about appling conditional format to a excel workbook.
I need this in VBA (only VBA) module in excel that will execute when opening and/or with a button.
It will run in excel 2003/2003.

Very easy to do, just read carefully, you will need 4 if clauses to do this.

ONLY VBA!!

Steps

you have to apply this format starting in column A and going rigth (stop in the last column wit data). Now it is the column “CD”, but this can change, so search fotr a null value in row “3″.

Also apply it from row 4 to the last row with data (this will be when you find a null value in column A”). The number of rows will change, so you need to search for the first null value.

If column “L” has the value “Real”, then apply the coluor you see in exsample (gray). Apply this gray colour but only from column “A” and stoping in the last cell that has a value. See example, it must look like the excel file. Do not consider the column with the tittle “total dias”.

Important: the number of column may change, so you must identify it by the label.

After this, look column “A”, there you will have the id of the “obra”. For each “obra” you will have 2 rows. The first is the schedulle (in column “f” the value is “previsto”) and the second is the “final data” (the value in column “L” is “Real”). We need you to compare the value “real” and “previsto”. So, for each “obra”, read the columns with the label “fecha inicio” and compare the value in the row “real” with the value in the row “previsto”.
For each cell move up to find the value you have to compare with
if “real” >= (“previsto” +8) /// apply the red colour
if “real” is null and, “previsto”< now() // apply the red colour

Do the same but for the columns with the label “fecha fin”

Finally, if “real” <= “previsto apply the green colour (for both “fecha inicio” and fecha fin”)

Remember, the number of columns may change, you will read up to the last column with value.
There are a couple of wexample of the colour in the sheet.

Thanks

Categories: Visual Basic Tags: , , , , , ,

Rm Online Postage Automation

January 14th, 2010 Comments off

See link to Royal Mail Online Postage here:
http://www.royalmail.com/portal/rm/jump2?catId=400046&mediaId=26800663&keyname=ONLINEPOST

I need a plugin for Firefox which will load my orders in from a CVS (comma separated value) file or similar and allow me to click on each row/ each column in the row and copy it into the address fields on the website.

Each row should be displayed on the left hand side (or you should be able to expand the “list” or rows) along with a button to insert into the page (where the cursor is).

Should also be possible to do an (intelligent) insert. I can give you the cell references and field names in the site it should automatically use, but it should be possible to customise these.

Firefox plugin should be xplatform compatible (i.e. Mac, Linux, Windows).

Vba/macro: Xls Data Into Ppt

January 9th, 2010 Comments off

Have some rows of data, a selection of cells in each row need to be copy/paste or inserted into a location on consecutive ppt slides. The values in each row are different and there will be several hundred slides with each specific row of data.
Need someone to be able to program the macro to copy the excel data row from a single file and have it placed on each individual slide in the ppt. The ppt will have to have a new slide inserted for each b/c it starts off with just the first slide. So there has to be a macro that inserts a new slide and copies the excel row in the specific location and then inserts the next slide etc. etc. That’s all. The slides are otherwise blank. The rows of data just really need to be on separate slides because the slides will be printed on specific documents such that the row of data serves as a label on each document. There may be a mail merge or some such to do this as well.
Work must be done ASAP.
Compensation for the time it takes to do programming and for file to be completed at takes to complete a file of ppt with multiple slides (for programming task that should hopefully and ostensibly not take much time for anyone who knows what he/she’s doing).
Anticipating the work to take no more than an hour or two b/c task to write this up should be simple.

Database For Classes

January 5th, 2010 Comments off

I need to a “sample” database that allows users to view class schedule, price and other key factors seamlessly integrated into a webpage. The admin must be able to add and delete and set preferences.
*This not the final product its just used as a test model project.

sample layout-

1. 6 column/ 3 rows
2. 1st row is orange/2nd blue/ 3rd grey
3. columns types are – class type|start date|day(s)| course| time|price|register or request

Rules-

-1 st row -By default “start date” displays “flexible” or “Any” and “course length” displays “Varies” or “3 days”
-2nd row show give user options for “start date” and “days”
-3rd row gives administrator options to show “start date” or “Call For dates” and for Day(s) it allow admin to display “day(s) or “TBD” -

other rules

- allows user to input price, time of course, course length, days of course, start date and class type

-for all the final columns ” register/request” by default the first two columns will display “register”. The last row will display “register” or “request” based on the Admins preference.

When it displays “Call for dates” and “TBD” it displays “Request” if “Start date and “Days” appear it displays “Register”

All rows doest have to display all at once. it can drop down to all three

Categories: Ajax, mSQL, MySQL, PHP Tags: , , , , , ,

Database For Classes 2

January 4th, 2010 Comments off

I need to a “sample” database that allows users to view class schedule, price and other key factors seamlessly integrated into a webpage. The admin must be able to add and delete and set preferences.
*This not the final product its just used as a test model project.

sample layout-

1. 6 column/ 3 rows
2. 1st row is orange/2nd blue/ 3rd grey
3. columns types are – class type|start date|day(s)| course| time|price|register or request

Rules-

-1 st row -By default “start date” displays “flexible” or “Any” and “course length” displays “Varies” or “3 days”
-2nd row show give user options for “start date” and “days”
-3rd row gives administrator options to show “start date” or “Call For dates” and for Day(s) it allow admin to display “day(s) or “TBD” -

other rules

- allows user to input price, time of course, course length, days of course, start date and class type

-for all the final columns ” register/request” by default the first two columns will display “register”. The last row will display “register” or “request” based on the Admins preference.

When it displays “Call for dates” and “TBD” it displays “Request” if “Start date and “Days” appear it displays “Register”

All rows doest have to display all at once. it can drop down to all three

Categories: Ajax, mSQL, MySQL, PHP Tags: , , , , , ,

Database For Classes 2

January 3rd, 2010 Comments off

I need to a “sample” database that allows users to view class schedule, price and other key factors seamlessly integrated into a webpage. The admin must be able to add and delete and set preferences.
*This not the final product its just used as a test model project.

sample layout-

1. 6 column/ 3 rows
2. 1st row is orange/2nd blue/ 3rd grey
3. columns types are – class type|start date|day(s)| course| time|price|register or request

Rules-

-1 st row -By default “start date” displays “flexible” or “Any” and “course length” displays “Varies” or “3 days”
-2nd row show give user options for “start date” and “days”
-3rd row gives administrator options to show “start date” or “Call For dates” and for Day(s) it allow admin to display “day(s) or “TBD” -

other rules

- allows user to input price, time of course, course length, days of course, start date and class type

-for all the final columns ” register/request” by default the first two columns will display “register”. The last row will display “register” or “request” based on the Admins preference.

When it displays “Call for dates” and “TBD” it displays “Request” if “Start date and “Days” appear it displays “Register”

All rows doest have to display all at once. it can drop down to all three

Categories: Ajax, mSQL, MySQL, PHP Tags: , , , , , ,

Database For Classes

January 2nd, 2010 Comments off

I need to a “sample” database that allows users to view class schedule, price and other key factors seamlessly integrated into a webpage. The admin must be able to add and delete and set preferences.
*This not the final product its just used as a test model project.

sample layout-

1. 6 column/ 3 rows
2. 1st row is orange/2nd blue/ 3rd grey
3. columns types are – class type|start date|day(s)| course| time|price|register or request

Rules-

-1 st row -By default “start date” displays “flexible” or “Any” and “course length” displays “Varies” or “3 days”
-2nd row show give user options for “start date” and “days”
-3rd row gives administrator options to show “start date” or “Call For dates” and for Day(s) it allow admin to display “day(s) or “TBD” -

other rules

- allows user to input price, time of course, course length, days of course, start date and class type

-for all the final columns ” register/request” by default the first two columns will display “register”. The last row will display “register” or “request” based on the Admins preference.

When it displays “Call for dates” and “TBD” it displays “Request” if “Start date and “Days” appear it displays “Register”

All rows doest have to display all at once. it can drop down to all three

Categories: Ajax, mSQL, MySQL, PHP Tags: , , , , , ,

Rm Online Postage Automation

December 31st, 2009 Comments off

See link to Royal Mail Online Postage here:
http://www.royalmail.com/portal/rm/jump2?catId=400046&mediaId=26800663&keyname=ONLINEPOST

I need a plugin for Firefox which will load my orders in from a CVS (comma separated value) file or similar and allow me to click on each row/ each column in the row and copy it into the address fields on the website.

Each row should be displayed on the left hand side (or you should be able to expand the “list” or rows) along with a button to insert into the page (where the cursor is).

Should also be possible to do an (intelligent) insert. I can give you the cell references and field names in the site it should automatically use, but it should be possible to customise these.

Firefox plugin should be xplatform compatible (i.e. Mac, Linux, Windows).

Database For Classes

December 28th, 2009 Comments off

I need to a “sample” database that allows users to view class schedule, price and other key factors seamlessly integrated into a webpage. The admin must be able to add and delete and set preferences.
*This not the final product its just used as a test model project.

sample layout-

1. 6 column/ 3 rows
2. 1st row is orange/2nd blue/ 3rd grey
3. columns types are – class type|start date|day(s)| course| time|price|register or request

Rules-

-1 st row -By default “start date” displays “flexible” or “Any” and “course length” displays “Varies” or “3 days”
-2nd row show give user options for “start date” and “days”
-3rd row gives administrator options to show “start date” or “Call For dates” and for Day(s) it allow admin to display “day(s) or “TBD” -

other rules

- allows user to input price, time of course, course length, days of course, start date and class type

-for all the final columns ” register/request” by default the first two columns will display “register”. The last row will display “register” or “request” based on the Admins preference.

When it displays “Call for dates” and “TBD” it displays “Request” if “Start date and “Days” appear it displays “Register”

All rows doest have to display all at once. it can drop down to all three

Categories: Ajax, mSQL, MySQL, PHP Tags: , , , , , ,

Excel File Modification

September 30th, 2009 Comments off

We have included 2 sample excel files, to give you an idea on what the program or vb macro needs to do.

The first file is called nj.csv. This is the sample of a file we will be using that needs to be manipulated.

The second file is called SICTranslator.xls . This is a file your program will be using as a reference.

==================

We need a program, that can take any excel file in the format of the nj.csv file included.

It looks at the last column titled “SIC Code”

It compares the first 4 character of the data in the column and checks to see if there is a match with any of the first four characters in any row of Column B of the other excel file named SICTranslator. xls

If there is a match with the first four character of ANY row in Column B of SICTranslator.xls, then keep the row in the first excel file. Otherwise Delete the entire row and shift the other rows up.

====================

This program should then have another option in which it looks at the first excel file, nj.csv and can find all the unique rows of the last column titled “SIC Code” and create another excel file with all the unique rows of just that column.

Arcade Website Template Phpas

August 23rd, 2009 Comments off

This project is for a custom template, designed and coded for a an arcade website, running the PHPAS v4 (PHP Arcade Script v 4) script.

This isn’t as complicated as it may seem when you first read the description, because PHPAS v4 is very powerful, and it makes customization very easy, as long as you’re familiar with PHP.

Low bids with verifiable experience will be given preference.

By bidding, you agree that I own all rights to the script, template, and artwork, and that I may use, modify, or sell it, as I see fit.

I will pay immediately via PayPal upon completion of the project, after I have tested it as admin, and user. No deposits, no escrow, no exceptions.

I will give a feedback rating of 10, if this is done to specifications and on time.

This template MUST function properly with the PHPAS v4 script, and it MUST be able to be plugged into PHPAS v4, as a template, just like the normal templates, that come with the script.

If you’re interested in the project, but are unfamiliar with the PHPAS v4 Script and it’s templates, glancing over this page may help you to quickly understand how it functions:

http://www.8hourarcade.com/hour-6/the-template-files/

There is a free template for the PHAS V4 script, available for download at the link below:

http://www.8hourarcade.com/hour-6/php-arcade-script-templates/

Here is an example of that template in use:

http://www.yourarcade.org/

The template for this project, must feature custom graphics and a custom banner at the top of the page.
All artwork used MUST be original.

The name of the site must be very visible and legible, on the banner. The web address (displayed in this format “sitename.com”), must be on the banner, or somewhere at the top of the site.

I have an idea of what I want for the layout.

Most arcade sites are very generic looking, which is what I want to avoid.

I want something colorful, and for this, I really like the modern vector retro grunge type of stuff that’s hot right now, as long as it’s bright, and not too “dark” themed. For this, I really like that style mixed with vibrant glow effects.

I want it to be visually appealing, and to look more “exciting” than the other typical arcade sites.

Here are some example graphics, each containing some elements that I like, please look at them:

http://www.neurosoftware.ro/programming-blog/wp-content/plugins/wp-o-matic/cache/df8ea_516681193689193.jpg

http://o-ze.com/wp-content/uploads/2008/08/tanimura-midnight.jpg

http://behance.vo.llnwd.net/profiles/77748/projects/143036/777481225666153.jpg

http://behance.vo.llnwd.net/profiles/53667/projects/46585/536671194094505.jpg

http://behance.vo.llnwd.net/profiles/54171/projects/89854/541711209965882.jpg

Those effects can be obtained pretty easily, by anyone with a little skill, using Photoshop brushes like the ones found here:

http://qbrushes.com/photoshop-abstract-brushes/ecol-brushes/
http://qbrushes.com/photoshop-abstract-brushes/explosion-brush/
http://qbrushes.com/photoshop-abstract-brushes/cs4-brushes/

but if you’re right for the job, you should already know that, or have someone on your team that already knows how, and who has experience doing this style of artwork.

It’s VERY IMPORTANT that the artwork looks good. It needs to be intriguing, eye catching, positive, and exciting.

Now, on to the structure of the layout.

The template must feature a navigation bar, just below the header graphic, with links to all 16 game categories (genres).

Most sites that I see with the PHPAS v4 templates, look really cluttered, and that’s bad. I mean the way the game titles and descriptions are displayed, it’s just really inefficient and unattractive, especially in the sections displaying the games of category.

Here is a demo site, running the default template, for the PHPAS v4 script:

http://www.phparcadesite.com/

I think it’s actually rather boring and ugly, but please look at it if you’re unfamiliar with the PHPAS v4 script, or arcade sites in general, as knowing the general layout, will help you to picture the layout that I want, from what I am going to describe below.

I want a 3 column layout, with the main game categories in the center. I want 16 categories, which are:

The 12 basic PHPAS v4 categories (Action, Adventure, Board, Casino, Customize, Dress Up, Driving, Fighting, Puzzle, Shooting, Sports) + 4 these categories – “Girly Games”, “Kissing Games”, “Sonic Games”, and “Mario Games”.

I want a background image which fills the background of the entire site, which looks good with a style like I described above for the artwork, as the background should fit in with the artwork and the theme of the site. It’s also necessary that this background image looks good displayed on both standard monitors, and widescreen monitors (meaning that the background fills the entire screen, even for those viewing the site on large widescreen monitors).

It’s important that this image loads in the background as one full image, rather than being sliced, so that if I want to later change the background, and replace it with a different image, I could do so easily.

I’d like each section in the layout, to be in containers, partially transparent, with a black glass frost look, so that the background is partially visible through the containers, like in this picture:

http://tutorials.tm-creative.org/manialink/pictures/ingame-browser.jpg

The look of the Containers for the Categories sections for each Game Genre, in addition to the basic transparent black containers, should also have a clear glass trim on the outside edges, possibly with a glow effect, surrounding the container, for each category (by” category” I mean the sections displaying “Adventure Games”, “Action Games”, etc, are all separate “categories”). This really isn’t as complicated as it sounds, for an example of the glass and glow trim, see the this image:

http://img20.imageshack.us/img20/5996/screenshotouy.jpg

For each game genre category box/section/container I want 2 categories per row, in this center column, and each category should display 2 games at the top, side by side, with a picture displayed for each of these games, and also displaying the title for each, above the corresponding picture. Under each game should be a very short description. (The PHPAS v4 script makes it easy to control how the games are displayed, including specifications for picture, title, description, etc).

Then there should be 5 more games displayed in each category, displayed like a list or table, with 1 game / title per row, and these should be displayed beneath the two games at the top. For these 5 games, only Titles should be displayed, no pictures or descriptions. And then a “view more” button, for the genre, in each category. The games should of course load properly from the appropriate categories in the backend of the PHPAS v4 script.

The Title bar for each genre/category needs to look attractive, and the text/font needs to be legible.

Above The 3 columns in the layout, I want a row, just beneath the navigation bar, that runs a horizontal ad (which will be featuring 100 x 100 pixel game images, with the title displayed below each image) from entraffic.com. I just want to be able to insert the code for the banner/ad generated by entraffic.com in that row.

I also want some kind of “featured” box near the top, and I definitely want it to display an image and at least a “title” for each game, and maybe a description, depending on the style of the featured box, and what you feel is the most appropriate, for the overall look of this section.

I really dislike displays that show only an image, without displaying the game title. The featured box, should display games that I specify from the backend of the PHPAS v4 arcade script.

I want the user registration box, to be at the top of the left column, with a “top players” box under that.

I also want sections for “top rated games”, “most popular games”, and “random games”, each in their own section, in the right column of the site. The games in these sections should of course load properly from the appropriate categories in the backend of the PHPAS v4 script. The categories in the right column should each feature from 10 to 20 games, and only the title should be displayed for each game.

I want space to insert ads, in the side columns, and at least 1 space in each side column, big enough to fit the long vertical Google Adsense ads. It would be cool if I also had a few spots to insert those 100 x 100 pixel ads, that look like game thumbnail preview, for traffic trading.

There should also be a search box, somewhere on the site, that lets the user run a search, for all of the games on in the database on my site (PHPAS v4 makes it easy to do this).

Please only bid if you agree to the terms as stated and can complete this within 7 days.

If you have any questions, please ask.

Categories: Graphic Design, PHP, Website Design, XHTML Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
Bear