Dibatalkan

Turn an OpenOffice SpreadSheet into an Online WP Script

Need to create an ONLINE SCRIPT based in WordPress that will look and perform the same operations as the spreadsheet attached to this document. It was built in [url removed, login to view] format .ods, which is a free open source spreadsheet. I do not have a .xls version.

Items to be manually Input By User:

- KEYWORD CATEGORY NAME (editiable)

- TITLE (editiable)

- URL (editiable)

- DESC (editiable)

- H1 (editiable)

- KEYWORD (editable, and as many keywords as user wishes)

- KEYWORD VOLUME* (editiable)

- KEYWORD CPC* (editiable)

*If you know how to automatically import Google Keyword Volume and CPC, that would be a HUGE bonus to me and I will highly favor you when choosing a programmer. I DO NOT have an Adwords API

Items to be scraped:

Once user inputs keyword(s), the tool will scrape and input the following results from Google automatically:

- Broad Match count (non-editable, scraped result)

- Phrase Match count (non-editable, scraped result)

- allintitle count (non-editable, scraped result)

- allinurl count. (non-editable, scraped result)

The script will then define cell background colors by a set of rules as items are entered:

If VOLUME is “= or <” 499, than cell color will be RED

If VOLUME is “between” 500 - 999, than cell color will be YELLOW

If VOLUME is “= or >” 1000, than cell color will be GREEN

If CPC is “= or <” $0.59, than cell color will be RED

If CPC is “between” $0.60 - $0.99, than cell color will be YELLOW

If CPC is “= or >” $1.00, than cell color will be GREEN

If BROAD MATCH is “= or >” 5,000,000, than cell color will be RED

If BROAD MATCH is “between” 1,000,000 – 4,999,999, than cell color will be YELLOW

If BROAD MATCH is “= or <” 999,999, than color will be cell GREEN

If PHRASE MATCH is “= or >” 500,000, than cell color will be RED

If PHRASE MATCH is “between” 100,000 – 499,999, than cell color will be YELLOw

If PHRASE MATCH is “= or <” 99,999, than cell color will be GREEN

If ALLINTITLE is “= or >” 5000, than cell color will be RED

If ALLINTITLE is “between” 1000 – 4999, than cell color will be YELLOW

If ALLINTITLE is “= or <” 1000, than cell color will be GREEN

If ALLINURL is “= or >” 5000, than cell color will be RED

If ALLINURL is “between” 1000 – 4999, than cell color will be YELLOW

If ALLINURL is “= or <” 1000, than cell color will be GREEN

The home screen should begin with 4 KEYWORD CATEGORY groups, but have the following functions;

- ability to add/edit/delete/save keyword category groups

- ability to add/edit/delete/save new PROJECTS which contain keyword category groups

SPECIAL INSTRUCTIONS:

- You must have excellent design/css skills as I want you to make this look very professional.

- This is the start of a much larger project, however this is simply Task 1.

- If you do an outstanding job, I will likely rehire you to complete the next tasks on the job.

- If you understand this and have read the directions fully, please reply to this project with the words RAVEN BOX, so that I know you have read everything.

Kemahiran: CSS, MySQL, PHP, Pengikisan Web

Lihat lagi: wp programmer, wordpress org online, start as an online programmer, spreadsheet script google, spreadsheet script, spreadsheet google functions, spreadsheet functions google, script google spreadsheet, projects online free, programmer job from home, online job on google, online job c++ programmer, online job as programmer, online job as c++ programmer, online job as a programmer, online design tool free, need an online job, name design online free, job online as a programmer, job as programmer online

Tentang Majikan:
( 47 ulasan ) Sylvan Lake, Canada

ID Projek: #6863019

7 pekerja bebas membida secara purata $535 untuk pekerjaan ini

JoomlaVogue

Hello Sir, First of all, we would like to tell you how we will initialize the project with you. We insist to follow these steps before you award the project to us: - We (technical team) will review the job and Lagi

$400 CAD dalam 7 hari
(80 Ulasan)
7.1
fhasanbd

A proposal has not yet been provided

$526 CAD dalam 10 hari
(91 Ulasan)
6.3
swapnilchavan18

Please check [login to view URL] and [login to view URL] I am interested to work on this project and provide you best output. I have 5 years of experience in web development Lagi

$555 CAD dalam 10 hari
(45 Ulasan)
6.2
rajnish1579

Hi Sir, "I UNDERSTOOD ALL YOUR REQUIREMENTS 100%”, also available 24*7 for Support. I am technologies expert working in different technologies like php, wordpress, Joomla, Smarty , .net, Magento Commerce , Shop Lagi

$526 CAD dalam 10 hari
(36 Ulasan)
5.5
gwebdesignplus

Hi Sir/Ma'am, My name is Sunny, and I am a Website Developer by profession. I came across your project posting and thought of writing to you. I have read all your requirements and interested to develop ONLINE SC Lagi

$500 CAD dalam 20 hari
(12 Ulasan)
5.3
JeffLee21

Dear Sir, I'm very interested by your project. I am programmer with sincere and capable. I have developed many project. You can found good my projects in my work history. Particular, I have rich experien Lagi

$526 CAD dalam 15 hari
(14 Ulasan)
5.3
amisha90

Hi There, I will take only 12-13days to complete your project... I am totally confident to do your work properly... and 100% satisfaction I am an experienced web developer, proficient in algorithms and debugging Lagi

$555 CAD dalam 10 hari
(15 Ulasan)
4.9
GeorgeKazi

RAVEN BOX Hi! I have experience both in scraping and using various Google API's. I'd love the opportunity to complete this project for you and I can begin right away. Let's talk! Regards, Georg

$655 CAD dalam 10 hari
(13 Ulasan)
4.0
a2atech1

HI, It was awesome to see that your recently posted project is matching with my skill and knowledge. I have gone through your initial requirements. I have few issue. Please come to discuss for more specification. Tha Lagi

$421 CAD dalam 10 hari
(3 Ulasan)
1.3