Statistics Spreadsheet for your iPad

stats144We have a new app coming out soon, a spreadsheet especially for anyone interested in doing statistical analysis. It is our popular statistics app, using lots of useful functions especially designed to analysis. Here are the list of what we have added, with more functions coming soon.

AVEDEV – Find the average deviation
STDDEV – Find the standard deviation
NORMDIST – Find the normal distribution (x,mean,stddev,cumulative)
NORMSDIST – Returns the standard normal cumulative distribution function. With a mean=0, stddev=1
ZTEST – one-tailed probability-value of a z-test (array,μ0,sigma)
COMBIN – Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.
BINOMDIST – Returns the individual term binomial distribution probability. BINOMDIST(number_s,trials,probability_s,cumulative)
CORREL – Returns the correlation coefficient of the array1 and array2 cell ranges. Use the correlation coefficient to determine the relationship between two properties.
CONFIDENCE – Returns a value that you can use to construct a confidence interval for a population mean.

And of course all our regular spreadsheet functions are also included.
SUM – Sum a range of cells
AVG – Average of a range of cells
DAT – Put date
MIN – The minimum value in a range of cells
MAX – The maximum value in a range of cells
ABS – Absolute value
CEIL – Rounds a number to the nearest integer
FLOOR – Rounds a number down, toward zero
COS – Cosine
SIN – Sine
TAN – Tangent
RAD – Convert degrees to radians
DEG – Convert radians to degrees
PI – Pi or Π
ACOS – Arccosine
ASIN – arcsine
ATAN – arctangent
EVEN – Rounds number up to the nearest even number
ODD – Rounds number up to the nearest odd number
INT – Rounds number up to the nearest integer
LN – Returns the natural logarithm of a number
LOG – Returns the logarithm of a number to a specified base
LOG10 – Returns the base-10 logarithm of a number
GRAPH – Create the graph using the graph button
SQRT – Square root of number
COUNT – Counts fields
TRUNC – Truncates number to whole number

Expect it out soon!

Scrum Smart v1.1 is out

Scrum Smart v1.1 is out, is loads of new features, to make it even easier to manage your scrum project. We love using this app, and think you will too. And the reason we keep improving it, is because as we use it, we find new things that would be useful, little shortcuts that make it easier to add tasks, or indicators to show how well a project is doing. In the same way, you can help us improve by emailing us anything that you think would help.IMG_0436

How to delete a target in XCode 5

Everything has changed in XCode 5, mostly for the better. One thing it took me for a while to figure out is how to delete a target. When you start a new project you will automatically have a test target added, and this might not be something you need. This is how you do it, click on your xcode project, the very top item in File List view on the left. On the image below it is called Project, with an arrow point down. Then in the next view on the right, you will see a little arrow on the top left, pointing right. Click this to reveal a list of Projects and Targets, right click and you can delete the target you don’t want.DeleteTasksfromyourXcodeProject

Looking for somewhere to eat in Melbourne

There are so many great places to eat, and here is a list of some of the more popular places:

Smash burger @ Rockwell & Sons
Vue De Monde Level 55 of the Rialto Tower if your budget permits it.
Nobu at Crown is quite nice, overlooks the Yarra River.
Chin Chin and Gill’s Diner
Hutong in the CBD is way better than the cheap student oriented dumplings you find on little burke street.
Laksa King in Newmarket.
Addis Abebba, african food in footscray
The Moroccan Soup Bar on St Georges Road.

Scrum Smart version 1.1

MorePersonDetailsWe have a big update coming out to Scrum Smart, to help you manage your project. Here is a guide to a few of the things you are going to see.

We have added information on what each person is involved in. Each backlog and task can be assigned to a particular person, and this will help you see what they are involved with. Since you add the person in the backlog or task section, this is very helpful in collecting all that information in one location.

MoreBacklogDetailsWe have also added a lot more information to the backlog screen. We show include a visual line on how much is left to do, and you can also see who is assigned to the backlog item. All on one page. And if you scroll down, you will see a breakdown on how many days each backlog item will take.

It is now even easier to see how well you are doing in completing the project, as well as how much each backlog item should takeMoreSpringDetails.

We have also included more info on each sprint. The sprint is the main unit of work in Agile development, and you now get a timeline on when the project started, when it will finish, and how long you are through the sprint.

The app is out now, and the update should be out in a few days. Download Scrum Smart here.

New features of iOs7

Here are some random things things that you probably didn’t know in iOS7.

Go into landscape while in the Music app to access album view. You can pinch in or out to reveal/hide more albums.

While in Compass, tap the inside the compass to show the difference of how many degrees you are currently at to when you tapped the screen.

The tabs in Safari use the gyroscope to create a parallax-like effect when viewing all tabs.

You can open MultiTasking, Control Center and Notification Center while the Camera app is open to partially conceal the screen for some incognito snapshots.

While typing in the URL field in Safari, the .com key from iOS6 seems to have disappeared. Hold down the period key to reveal .com, .net, .ca and the other address endings.

Tap the alarm clock icon in the Reminders app to open a Schedule-like List View for your reminders.

Teach Siri how to pronounce names by saying, “Learn how to pronounce X.” You can also teach Siri how people are related to you by saying, “X is my brother/mother/etc.” This can also be done manually in Contacts>Contact name>Edit>Add related name. This wasn’t implemented in iOS7 but hey, I thought it was pretty cool.

I don’t know if this was in iOS6 but whatever. Swipe left or right on the number display in the Calculator app to backspace one number.

You can control which of your apps use Cellular Data. Go to Settings>Cellular to see a list of apps that you can turn off data usage for. Not all apps that use data are there however. To turn it off you need to use the app while data is on to retrieve or send any amount of data. This will put the app on your list and you can now turn off data usage for it. Personally, I use this to not have any apps use data, while still being able to use Siri for Music and Calling.

Tap the temperature in the Weather app to reveal the Humidity, Chance of Rain, Wind and Feels Like.

Apple Maps has an extremely accurate 3D buildings mode accessed by tapping the “3D” icon at the bottom. Slide two fingers up or down in order to change the angle of your view. Again, not sure if this was implemented before iOS7.

Go to Settings>Privacy>Location Services>System Services>Frequent Locations to view a list of places that you frequently go to.

When a picture in your Photos app is selected (when the back and edit buttons at the top), you can pinch to close it. While you’re pinching, you can manipulate the size and rotation of the photo by keeping bot fingers on the screen but moving them around. You can make your photos do flips ‘n’ shit.

While choosing a wallpaper, if the area of the image that is around the Lock Screen’s time is primarily white or a light colour, the time will be in black and if the portion of the area is in any other deep colour the time will be in white.

Not sure if implemented in iOS7. In the Now Playing in the Music app, tap the song’s title or album artwork to rate the song.

You can now edit what you say to Siri by tapping on the text that it recognized.

Scrum Project is out now

Scrum project is now available on the app store.

scum72@2xThere is no better way to manage your latest agile project that with Scrum Project. We have compared it to the others, and it is not only the fastest, but easiest to use as well. But despite this, it is still an incredibly powerful produce, where you can manage as many projects as you want, deal with 100s of members of your team, and 100s of tasks as well. This will get your project going, guaranteed.