batch - How can I type certain days (such as Monday, Wednesday) in an easy way for the next 5 months without typing them one by one?

06
2014-04
  • Elysium

    I am trying to input in a libreoffice calc file only Mondays and Wednesdays for the next 5 months, but I dont wanna do it typing the dates one by one. So..I thought I would type 4 dates like this:

    17. Mar. 2014   Monday  
19. Mar. 2014   Wednesday  
24. Mar. 2014   Monday  
26. Mar. 2014   Wednesday

    Then I thought highlighting these dates and dragging them would give me all the Mondays and Wednesdays up to the a point where I drag it....but this is what I get:

    17. Mar. 2014   Monday
19. Mar. 2014   Wednesday
24. Mar. 2014   Monday
26. Mar. 2014   Wednesday
18. Mar. 2014   Thursday
20. Mar. 2014   Friday
25. Mar. 2014   Saturday
27. Mar. 2014   Sunday

    Is there a way for me to put only Mondays and Wednesdays in a fairly simple way instead of typing them one by one?

    • Answers
  • Wally

    Write the first 2 days that you want, say 17 Mar 2014 and 19 Mar 2014 and the associated day-of-week in the cells beside them.

    Cell A3 is =A1+7

    Cell A4 is =A2+7

    Drag and repeat.


    • Related Question

    batch - on Windows XP, how can I remove (NOT hide) a system tray icon without closing the process?
  • user48721

    So I leave uTorrent running on the system tray when I go to work, but every time my brother gets on the pc he closes it. So by the time I get back I've lost 7-8 hours of download. Most infuriating.

    I want a way to remove the icon from the system tray, while maintaining the process running.

    For self-educational purposes, I'd like to end up with something like this:

    A batch file that when executed, checks whether some registry key is true or false or whatever, and depending on that it launches one or other .reg file that would have some effect on the icon. The practical consequence would be that launching the bat file would toggle the icon's existence on and off.

    Any help?

    (BTW, I want to be able to do this same thing with other programs, like eMule, or even the nvidia control panel icon, just for fun)


    • Related Answers
  • BloodPhilia

    Well the trouble would be that all these programs would implement systray notifications (Things you know as System Tray icons) in a different manner and thus can not be universally removed. (Merely hidden)

    However, for your uTorrent problem, the boss-key (wiki: what is a boss-key?) might be a solution for you...

  • subanki

    To disable system tray icons on Windows XP / Vista

    alt text

    1. Open up regedit.exe on Run box option.
    2. Navigate down to following registry key : HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer
    3. check if the DWORD entry NoTrayItemsDisplay is already available in the left panel,if NoTrayItemDisplay available. Change the value of NoTrayItemDisplay to “1″if don’t have NoTrayItemDisplay, Then create NoTrayItem display entry and set the value as ” 1 “.
    4. After completed modify or create the registr, Restart the computer then you will see the effect that all system icons tray will be hidden.

    For Windows System timer, you can remove the system clock by right-clicking on the taskbar and choosing Properties and turn off ” show on clock ” option.

    Note: to restore the system tray icons, just navigate to windows registry and delete the ” NoTrayItemDisplay ” entry. Or create registry file or batch file one that enables and the other disables.

    If you want me to tell how to create a reg or bat file for this then please leave a comment EDIT: To disable utorrent tray icon , simply open your utorrent, then go to Options, select Preferences, under UI settings uncheck "Always show try icon"

    Disadvanntage: If your brother is smart enough or he finds this post while surfing in the internet , I am sure he will simply close the utorrent or any other program from the Task-Manager process list

    So to workaround this you might wanna consider Disabling your task manager as well

    here is how you can disable task-manager

    Hive: HKEY_CURRENT_USER Key: Software\Microsoft\Windows\CurrentVersion\Policies\System Name: DisableTaskMgr Type: REG_DWORD Value: 1=Enablethis key, that is DISABLE TaskManager Value: 0=Disablethis key, that is Don't Disable, Enable TaskManager

    Your Brother can still outsmart this by just killing the utorrent process using a batch script or something else.

    According to me the possible solution would be to disable him from using your computer. This can be done by locking your system using a 3rd party software called Desktop Lock . For more information on Desktop-Lock go here http://www.toplang.com/desktoplock.htm