rotation

  1. C

    Can anyone help completing this working code?

    I asked chatgpt to produce code and after trial and error it gave something that actually works. however it produced one that is not discriminating by judge types as I requested. I told it judges from 1 to 8 are ordinary while 9 to 12 are special, and to assign a new judge in the third column...
  2. I

    Ongoing Schedule - Rotating Staff Leave (6 weeks on 2 weeks off rotation)

    Hi All, Majority of our staff work a rotation of 6 weeks on and 2 weeks off. We have multiple teams, that work multiple different schedules (Mon - Friday vs 3 -2-2 vs Tue - Sat, etc). This obviously does not change whether or not they are here. I can build the schedules as recurring and...
  3. T

    How to find degree value between two numbers

    Dear Friends and fellows, Yesterday I asked one question which is not clear. it's because of my lack English knowledge. Kindly you all pardon me for that. Here is the clear question. If we take from 1 to 9 as complete 360° rotation. from 1-4 how much degree rotation. kindly write clear...
  4. G

    If statement or vba code requirement

    I run a report giving me the shift patterns of colleagues. I need to break down what shift pattern they are on so forexample we have the following. So in the 1st columns I have in A 1and then in B & C I have those starting 1 then 2 in B and in C will bethose starting on 2 then 1 and then the 3...
  5. V

    Rotate Image within ShowPic Function

    Hi all. I've been using and adjusting an original function that came from this forum and have searched if someone has had this requirement before but coming up blank. I'm looking to add a rotation to the displayed images and wonder if someone can help with the code? Here is what i have...
  6. T

    Rotation and translation of coordinates

    I would like to ask “SHG” a question as it relates to an old post of his, namely: https://www.excelforum.com/excel-formulas-and-functions/927663-3d-coordinate-translation-and-rotation-formulas-for-excel.html This was a very nice solution to the posted problem, however I also saw this as a...
  7. R

    Replacing one value to multiple values in rotations

    Hi I would like to replace one value with multiple values in rotation, In sheet 1, I have a value "DATA 10" in column A, row 2, 5, 7, 10, 15, 20, 23 and so on. How can i replace this value (DATA 10) with multiple values (10 LADY, 10 CHILDREN, 10 MAN and 10 HAZMAT) in rotation, so that row 2...
  8. T

    Calculating What Months a Date Range Covers

    Good evening. I am developing a trend analysis of data that has a start and end date. I need to count the number of rotations that were active every month that falls within the start and end date range. A rotation starts 1 Oct 16 and ends 4 Apr 17. When I go to count how many active...
  9. S

    Rotation of 3D surface

    Hello all, I seem to be having an issue with rotating a 3D surface. I have an grid of elevation values that I have plotted to a 3D surface. I want to be able to use 2 ActiveX spin buttons to rotate the surface in the X and Y planes, in order to get a better look at the surface elevations...
  10. B

    Macro to rotate through list of names (advanced)

    if you look at the table below, there is a date column and a name column. in a perfect world, i want to copy a list of names to my clipboard and run this macro. the macro will paste the contents to sheet1, convert as many names as i paste to a table, then on sheet 2, create these two columns for...
  11. S

    Show current week of rotation between two dates?

    I'm looking for a formula that will let me see the current week of a rotation based on two dates. Basically, I have a sync date, and a new sync date with a set number of weeks in the rotation--say, 2-weeks, 4-weeks, 12-weeks (whatever) that a routing computer uses to send my technicians to...
  12. P

    3D Pie Chart Formatting Issue

    Hello, I have a 3D Pie Chart with 6 slices and one of the slices, when rotating, appears below/behind the others at a specific degree of rotation (usually when it is in the front). The Pie Chart is linked via a drop down menu which consists of 60 cities to reset the chart's data. This issue...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top