Results 1 to 7 of 7

Thread: Experts need help to make a sheet or develop a simple program

  1. #1
    waqasgull is offline Junior Member
    Last Online
    15th April 2016 @ 12:08 PM
    Join Date
    24 Feb 2016
    Gender
    Male
    Posts
    6
    Threads
    2
    Credits
    0
    Thanked
    0

    Default Experts need help to make a sheet or develop a simple program

    Assalam o Alaikum,
    Mein incentive ki ek sheet design kar raha hon lekin excel pe mene koshish ki magr locking system me nhi kr pa raha hon, or access pe mujhe command nhi, ager koi expert mere liye ye programing kr day mere liye bohat asani hojaegi, excel ki ek sample sheet mein post kr raha hon for reference, ye hay Macro enable workbook, q k isme mene kch VBA ki coding use ki hay, lekin site pe allow nhi hy thats why isko xls pe save kr k post kr raha hon.

    thank you so much all in advance
    Attached Files Attached Files

  2. #2
    DesertRose84 is offline Member
    Last Online
    8th March 2017 @ 11:44 AM
    Join Date
    21 Jan 2016
    Gender
    Male
    Posts
    790
    Threads
    45
    Thanked
    29

    Default

    Quote waqasgull said: View Post
    Assalam o Alaikum,
    Mein incentive ki ek sheet design kar raha hon lekin excel pe mene koshish ki magr locking system me nhi kr pa raha hon, or access pe mujhe command nhi, ager koi expert mere liye ye programing kr day mere liye bohat asani hojaegi, excel ki ek sample sheet mein post kr raha hon for reference, ye hay Macro enable workbook, q k isme mene kch VBA ki coding use ki hay, lekin site pe allow nhi hy thats why isko xls pe save kr k post kr raha hon.

    thank you so much all in advance
    Bhai sb apke attached file maine check ke hai lekin mujhe to 10% bhi samjh nahi aye hai (may be meri field differnt hai thats why) but i would like to suggest ke aap please thore aur details de ke particular field mai data kitna aana chahiye aur kaha se aana chahiye (then i and other expert will try to input formula) aur koshesh karai ke excel file mai mazeed data input karai....... in other words aap ne jo IPS input kia hai oske saamne OUTPUT or INCENTIVE change aaraha hai to kese ? iske thori mazeed wazahat karai InshaALLAH we will try our level best to assist you.........

  3. #3
    waqasgull is offline Junior Member
    Last Online
    15th April 2016 @ 12:08 PM
    Join Date
    24 Feb 2016
    Gender
    Male
    Posts
    6
    Threads
    2
    Credits
    0
    Thanked
    0

    Default

    Quote DesertRose84 said: View Post
    Bhai sb apke attached file maine check ke hai lekin mujhe to 10% bhi samjh nahi aye hai (may be meri field differnt hai thats why) but i would like to suggest ke aap please thore aur details de ke particular field mai data kitna aana chahiye aur kaha se aana chahiye (then i and other expert will try to input formula) aur koshesh karai ke excel file mai mazeed data input karai....... in other words aap ne jo IPS input kia hai oske saamne OUTPUT or INCENTIVE change aaraha hai to kese ? iske thori mazeed wazahat karai InshaALLAH we will try our level best to assist you.........
    Thank you so much Bhai for your response.
    first of all mujhe lag raha hy k ye sheet programming pe jarahi hay, or ye microsoft access pe zyada best banegi, lekin microsoft access pe mujhe command nhi, khair thori or wazahat kr leta hon apni sheet ki.
    mere pas kuch database hen jese k
    1. Employee database
    2. IP's database (you can called orders database)
    3. Layout database (daily-wise)
    and than mere pas daily sheet hay incentive ki (JIS ME SARI WORKING HONI HAY)

    1. Employee database me mene sara data put krdia, jese k employee card numbers, names, line, designation, locations
    2. IP's database me mene saray orders put kardiye.
    3. Layout pe mene pooray month ki daily wise layout put krdia, kis line me kitnay employee kis din honay chahye hen (allowed employees) jese k first date ko itnay operators, itnay helpers, itnay checkers (daily wise may be change in this layout)

    now come to the Main sheet (working sheet)
    mene daily sheet pe vlookup laga k data utha lia employee sheet se employees ka.
    1. IPs k column me day wise mein entry kronga k is employee ne is IP ka itna output dia.. ab is daily production ko wo link karay IP's Database se, ager ek IP hai 1234 or is ki qty hay 5000.. first day ek location hay (Assembly) is se 5 operators ne 5000 pcs (OUTPUT) di, OUTPUT column me daily kitni production kis employee ne di ye entry hogi. order ASSEMBLY se close hogaya, ab 5000 pcs baki locations se b anay chahye ager kisi line k ek location pe 5000 pcs diye or kisi location pe 5050 to its not allowed. q k order se zyada de raha hay.
    now come to the incentive column, jesa k mene BASE OUTPUT or BASE AMMOUNT dia hay... ager koi operator 500 pcs per day deta hay than usko 70 rupay milengay, ager koi 70 se 1 pc barha k dega than hum after 700 pcs us operator ko 0.2 paisa per pc dengay as a (incentive). but mein chah raha hon k yahan pe formula lagay k base output 700 hay ager koi is k 70% se above jata hay than usko incentive milay per pcs 0.2. ek column add kr k percantage se formula laga k b lia jaskta hay.
    Layout Master sheet me mene pooray month ki day-wise layout diye hongay k line 1 me is date ko itnay operators,helper,packer honay chahye.. Daily sheet me ye lock hona chahye k ager mujhe Layout Master me date-1 ko 30 operators or mein daily sheet me 31 operators ka data put kron to wo mujhe highlight kray k mein excess jaraha hon layout se.

    thats all..

    Thanks to you all in advance. is k liye ek pori programing design krni paregi i know its not that simple. but thanks in advance if someone can help me.

  4. #4
    DesertRose84 is offline Member
    Last Online
    8th March 2017 @ 11:44 AM
    Join Date
    21 Jan 2016
    Gender
    Male
    Posts
    790
    Threads
    45
    Credits
    1,777
    Thanked
    29

    Default

    I checked your attached file but it is very difficult to manage in excel.. I would suggest you to conact some local software programmer for the same... or may be some other expert help......

  5. #5
    waqasgull is offline Junior Member
    Last Online
    15th April 2016 @ 12:08 PM
    Join Date
    24 Feb 2016
    Gender
    Male
    Posts
    6
    Threads
    2
    Credits
    0
    Thanked
    0

    Default

    Quote DesertRose84 said: View Post
    I checked your attached file but it is very difficult to manage in excel.. I would suggest you to conact some local software programmer for the same... or may be some other expert help......
    Thanks Bhai, thats why i posted this problem in expert zone.. may be can someone help in this.

  6. #6
    waqasgull is offline Junior Member
    Last Online
    15th April 2016 @ 12:08 PM
    Join Date
    24 Feb 2016
    Gender
    Male
    Posts
    6
    Threads
    2
    Credits
    0
    Thanked
    0

    Default

    koi bhi programmer bhai help nhi krega is me meri? kia koi moderator please is thread ko access help me move kr dega plz? yaa phr oracle yaa sql me?

  7. #7
    waqasgull is offline Junior Member
    Last Online
    15th April 2016 @ 12:08 PM
    Join Date
    24 Feb 2016
    Gender
    Male
    Posts
    6
    Threads
    2
    Credits
    0
    Thanked
    0

    Default

    no one?

Similar Threads

  1. Simple Maths Program
    By Omer27 in forum General Discussion
    Replies: 105
    Last Post: 16th October 2016, 12:56 PM
  2. Write a C++ program to MAke Simple calculator
    By MoqaddasAli in forum C++
    Replies: 7
    Last Post: 2nd January 2016, 06:51 AM
  3. v.b6 main simple mark sheet ki coding chahiye
    By patner in forum Ask an Expert
    Replies: 2
    Last Post: 23rd December 2011, 11:08 PM
  4. Mobile Application Develop Experts I need My Nokia 6300 cemra As a Web cam...
    By blank in forum Mobile phones problems and Help Zone
    Replies: 2
    Last Post: 3rd June 2011, 08:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •