Question about Compilers & Programming Tools

2 Answers

SPREADSHEETS I've set up a spreadsheet that will allow me to track numerous items daily and give me the totals at the end of the week. Is it possible to set my sheet up to reset itself up to 5 times for the month so I can get a monthly total for reports, without have to set up 5 different weekly pages, to get totals for one month, then have to set up 12 pages to report for the year. I guess that i'm looking for a way to make the first week page reset itself but move to the 2 week and so on, with that process i'll be able to repeat for the months. Hope someone can help!!

Posted by on

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 205 Answers

I believe you could accomplish this with VBA (Visual Basic for Applications). There's lots of help and examples on using VBA available on the web.

Posted on Dec 08, 2007

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert that has over 500 points.


    An expert who has answered 200 questions.

  • Expert
  • 326 Answers

Excel is not able to be programed like that and still retain the data. Create 12 monthly spreadsheets and use them as they are needed.

Posted on Dec 08, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:


Convert Blu-ray and standard DVD to iPad, iPad Blu-ray disc/standard DVD Ripper...

Convert Blu-ray and standard DVD to iPad, iPad Blu-ray disc/standard DVD Ripper


Because of its 9.7-inch 1024×768 high resolution multi-touch screen, iPad is convenient and comfortable for users to read newspapers, magazines, books, view photos, experience the web, touch emails, and watch any kind of video, from HD movies and TV shows to podcasts, music videos and more. Also because there is no distracting keypad or buttons on iPad, you will totally concentrate on this big screen, and feel completely immersed in whatever you’re watching. You can imagine how wonderful it is to watch your HD Blu-ray and DVD movies on this little gadget. Are you ready to do so? If so, this article will give you a solution to the problem of how to convert Blu-ray and standard DVD movies to a compatible format with iPad. If you are looking for such a solution, just read on to get the detailed steps and the optimal playback settings for iPad.

The software you will need is Pavtube Blu-ray to iPad Ripper(for Mac: Mac Blu-ray to iPad Ripper).

Before that, go to see the iPad supported video formats as below:

H.264 video up to 720p, 30 frames per second, Main Profile level 3.1 with AAC-LC audio up to 160 Kbps, 48kHz, stereo audio in .m4v, .mp4, and .mov file formats;

MPEG-4 video, up to 2.5 Mbps, 640 by 480 pixels, 30 frames per second, Simple Profile with AAC-LC audio up to 160 Kbps, 48kHz, stereo audio in .m4v, .mp4, and .mov file formats;

Motion JPEG (M-JPEG) up to 35 Mbps, 1280 by 720 pixels, 30 frames per second, audio in ulaw, PCM stereo audio in .avi file format
Well, it is obviously that Blu-ray and DVD movies are out of the above categories, and then please follow the following guide to do format conversion before your playback.


Step 1: Add Blu-ray or DVD movies into this program
Click “DVD Rom”, “DVD Folder”, or “IFO/ISO” icon to load Blu-ray or standard DVD movies.

Step 2: Select subtitle and audio track
Click on the dropdown list of “Subtitle” and “Audio” respectively to select your needed subtitle and audio track.

Step 3: Select “iPad” as output format
Click the pull down menu at the end of “Format” to select an output format for iPad. Here I choose “iPad Video MPEG-4 (*.mp4)” for instance.


Step 4: Click “Settings” button to adjust audio and video parameters
You are allowed to adjust codec, aspect ratio, bit rate, frame rate, sample rate and audio channel in the popup window to optimize the output file quality. Following are the recommended settings to get best playback quality.

Codec: h264
Size: 640*480
Bitrate: 2500kbps
Frame rate: 30fps

Codec: aac
Sample rate: 48khz
Bitrate: 160kbps
Channels: Stereo


Step 5: Click “Convert” button to start conversion.
Once finished, you can get the output files for your iPad via clicking on “Open” button effortlessly. Afterwards, connect your iPad to your PC, and then sync the videos to iPad via iTunes.

Learn more: Convert/rip DVD and HD Video to your iPod,iPad,iPhone
Portable Media Device

on Apr 29, 2010 | Compilers & Programming Tools

1 Answer

Need to write a simple (no array allowed) to take three inputs from a user and sort it numerically. Not just provide the MAXNUM. via Javascript

in pCode

Var1 = Input1
Var2 = input2
Var3 = input3

If Var1 > Var2 and Var3
Then Var1 is Max
If Var1 > Var2 and < Var3
then Var3 is Max
Else Var2 is Max

If Var1 is Max and Var 2 > Var3
Then Var1 = Max
Var2 = Mid
Var3 = Min

if Var2 is Max and Var >1 Var3
Then Var2 = Max
Var1 = Mid
Var3 = Min

Repeat the various possibilities and you have got your result without arrays

Oct 05, 2009 | Compilers & Programming Tools

1 Answer

Vb projects

One of the assignments given for a masters
was to provide an input box for english postcodes (zip fer other places) that would filter out ANY invalid input in as few lines as possible.

With entirely numeric that is simple as it is just a string length
but some countries use alpha numeric and the letters have to be in the correct places eg. wf15 9lf or WF15 9LF or W15 would all be valid but W15 9LF would not..

Again minimal code would show an attention to detail because anyone can write a 100 lines of code to do that try get it in 15 or much less and it becomes more impressive

Specific alpha numeric data input and format sorting always seems to go down well with professors.

I havent given you everything to write the abstract bu the bare bones are there and it gives you an idea of the types of thing looked for.

After all if I gave you the whole thing it would not have been your work.

Aug 25, 2009 | Microsoft Compilers & Programming Tools

1 Answer

Rating Teachers Behavior Inventory

You could assemble a simple Excel spreadsheet and then total, average, find the mean, standard deviation, trend or a host of other answers or information. You can lock the spreadsheet so no one can tamper with it or change the structure. That would be much easier than creating a special program unless there is a specific reason to do so.

Mar 21, 2009 | Microsoft Compilers & Programming Tools

1 Answer

Insertion sort

Function InsertionSort(ByVal TempArray As Variant) As Variant
' Written By Louis Sutherland
' 1/25/99
' will be the sorted arrary when finishe
' d
Dim SortedList As Variant
Dim x, y As Integer
Dim NumSorted As Integer
'This Set up SortedList as an Array
SortedList = TempArray
'This zeroizes the new array

For x = 1 To UBound(SortedList)
SortedList(x) = 0
Next x
'sets the Total num counted to 1
NumSorted = 1
' Processes first element
SortedList(1) = TempArray(1)

For x = 2 To 5000
' insertion loop

For y = NumSorted To 1 Step -1
' if current value is <= then insert in
' next place

If TempArray(x) >= SortedList(y) Then
SortedList(y + 1) = TempArray(x)
'This Breaks the loop
y = 1
Exit For

If y = 1 Then
SortedList(y + 1) = SortedList(y)
SortedList(y) = TempArray(x)
Exit For
' save the value to the next spot
SortedList(y + 1) = SortedList(y)
End If
End If
Next y
'advance total num sorted
NumSorted = NumSorted + 1
Next x
InsertionSort = SortedList
End Function

Mar 17, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

Sorting string and numeric

One simple way to achieve this is using radio button function. Give the user flexibility to change sorting via String or Numeric. As the user clicks on String the result bottom of this option will change the sorting method using String. Otherwise, Numeric.

By the way, please be specific in posting your question. Include the development tools that you use. For example, MS Access 2003.


Feb 04, 2009 | Intelligent Computer Compilers &...

1 Answer

Need help in Special Formatting Number

Here is one solution. You might consider adding more robust error handling.
if the decimal numbers passed to the div function are multiples i will be a non-zero number of that multiple otherwise i will be zero.

Dim i As Integer
i = div(12, 0)
If i = 0 Then
'not multiple
' do this
' is multiple
' do something else
End If

Function div(ByVal numerator As Object, ByVal denominator As Object) As Integer
dim n , d decimal
Dim result As Decimal
Dim remainder As Decimal

If IsNumber(numerator) Is True _
And IsNumber(denominator) Is True Then
If numerator <> 0 Then
n = numerator
d = denominator
GoTo error1
End If
GoTo error1
End If
result = Decimal.divide(n, d)
remainder = Decimal.remainder(n, d)
If remainder = 0 Then
div = result
div = 0
End If

Exit Function
msgbox("Numbers must be non-zero numerics", , "Multiple check error")
div = 0
End Function

End Function

Aug 06, 2008 | Compilers & Programming Tools

1 Answer

Want to update the dates in excel spreadsheet

Try inserting seperate entry for furture day number and then reference that entry address for program math. You will have to either use same number of days to repeat (automatic) this math or accept that it would be a single shot type math. Depending on which version of excel you are using the alert can be a sound or color change. If 97 or older, there is no alert available. 2000 isn't much better.
Easier to set furture date in orginial date block right from the start. Unless you are running the excel program continuously in the background, program will only check date when running.

Good Luck,

Jan 16, 2008 | Compilers & Programming Tools

Not finding what you are looking for?
Compilers & Programming Tools Logo

Related Topics:

78 people viewed this question

Ask a Question

Usually answered in minutes!

Top Compilers & Programming Tools Experts

Robin Hill
Robin Hill

Level 3 Expert

1251 Answers


Level 3 Expert

18259 Answers


Level 3 Expert

733 Answers

Are you a Compiler and Programming Tool Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides