Peter Birkholm-Buch

Freelance Cloud Architect

Side 2 af 10

Functions for calculated fields in SharePoint

ABS function

Article Returns the absolute value of a number. The absolute value of a number is the number without its sign. Syntax ABS ( number ) Number   is the real number of whic…

ACOS function

Article Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number . The returned angle is given in radians in the range …

ACOSH function

Article Returns the inverse hyperbolic cosine of a number. Number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosi…

AND function

Article Returns the logical value TRUE if all of the arguments are TRUE; returns FALSE if one or more arguments is FALSE. Syntax AND ( logical1 , logical2 , … ) Logic…

ASC function

Article For Double-byte character set (DBCS) languages, changes full-width (double-byte) characters to half-width (single-byte) characters. Syntax ASC ( text ) Text   …

ASIN function

Article Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number . The returned angle is given in radians in the range -pi/2 to…

ASINH function

Article Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value whose hyperbolic sine is number , so ASINH(SINH(number)) equals numb…

ATAN function

Article Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the rang…

ATAN2 function

Article Returns the arctangent, or inverse tangent, of the specified x- and y-coordinates. The arctangent is the angle from the x-axis to a line containing the origin (…

ATANH function

Article Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (excluding -1 and 1). The inverse hyperbolic tangent is the value whose hy…

AVEDEV function

Article Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set. Syntax AVEDEV ( number1 ,nu…

AVERAGE function

Article Returns the average (arithmetic mean) of the arguments. Syntax AVERAGE ( number1 , number2 , … ) Number1, number2, …   are 1 to 30 numeric arguments for wh…

AVERAGEA function

Article Calculates the average (arithmetic mean) of the values in the list of arguments. Unlike the AVERAGE functions, text and logical values such as TRUE and FALSE ar…

BETADIST function

Article Returns the cumulative beta probability distribution function. The cumulative beta probability distribution function is commonly used to study variation in the …

BETAINV function

Article Returns the inverse of the cumulative beta probability distribution function. That is, if probability = BETADIST(x,…), then BETAINV(probability,…) = x. The …

BINOMDIST function

Article Returns the individual term binomial distribution probability. Use BINOMDIST in problems with a fixed number of tests or trials, when the outcomes of any trial …

CEILING function

Article Returns number rounded up, away from zero, to the nearest multiple of significance. For example, if you want to avoid using pennies in your prices and your prod…

CHAR function

Article Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters. Synta…

CHIDIST function

Article Returns the one-tailed probability of the chi-squared distribution. The ?2 distribution is associated with a ?2 test. Use the ?2 test to compare observed and ex…

CHIINV function

Article Returns the inverse of the one-tailed probability of the chi-squared distribution. If probability = CHIDIST(x,…), then CHIINV(probability,…) = x. Use this f…

CHOOSE function

Article Uses index_num to return a value from the list of value arguments. Use CHOOSE to select one of up to 29 values based on the index number. For example, if value1…

CLEAN function

Article Removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your operatin…

CODE function

Article Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer. Syntax CODE ( text ) …

CONCATENATE function

Article In Microsoft SharePoint Services, use the CONCATENATE function to join several text strings into one string.

CONFIDENCE function

Article Returns the confidence interval for a population mean with a normal distribution. The confidence interval is a range on either side of a sample mean. For exampl…

COS function

Article Returns the cosine of the given angle. Syntax COS ( number ) Number   is the angle in radians for which you want the cosine. Remark If the angle is in degrees, …

COSH function

Article Returns the hyperbolic cosine of a number. Syntax COSH ( number ) Number   is any real number for which you want to find the hyperbolic cosine. Remark The formu…

COUNT function

Article Counts the number of arguments that contain numbers. Syntax COUNT ( value1 , value2 , … ) Value1, value2, …   are 1 to 30 arguments that can contain or refe…

COUNTA function

Article Counts the number of arguments that are not empty. Syntax COUNTA ( value1 , value2 , … ) Value1, value2, …   are 1 to 30 arguments representing the values …

CRITBINOM function

Article Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. Use this function for quality assurance…

DATE function

Article Returns the sequential serial number that represents a particular date. Syntax DATE ( year , month , day ) Year   The year argument can be one to four digits. …

DATEDIF function

Article Calculates the number of days, months, or years between two dates. This function is provided for compatibility with Lotus 1-2-3. Syntax DATEDIF ( start_date , e…

DATEVALUE function

Article Returns the serial number of the date represented by date_text. Use DATEVALUE to convert a date represented by text to a serial number. Syntax DATEVALUE ( date_…

DAY function

Article Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31. Syntax DAY ( serial_number ) Serial_number   is …

DAYS360 function

Article Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to…

DDB function

Article Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify. Syntax DDB ( cost , salv…

DEGREES function

Article Converts radians into degrees. Syntax DEGREES ( angle ) Angle   is the angle in radians that you want to convert. Example Formula Description (Result) =DEGREES(…

DEVSQ function

Article Returns the sum of squares of deviations of data points from their sample mean. Syntax DEVSQ ( number1 , number2 , … ) Number1,number2, …   are 1 to 30 argu…

DOLLAR function

Article Converts a number to text using currency format, with the decimals rounded to the specified place. The format used is $#,##0.00_);($#,##0.00). Syntax DOLLAR ( n…

EVEN function

Article Returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts ro…

EXACT function

Article Compares two text strings and returns the logical value TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive. Use EXACT to test text bein…

EXP function

Article Returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm. Syntax EXP ( number ) Number   is the expone…

EXPONDIST function

Article Returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For examp…

FACT function

Article Returns the factorial of a number. The factorial of a number is equal to 1*2*3*…* number. Syntax FACT ( number ) Number   is the nonnegative number you want t…

FALSE function

Article Returns the logical value FALSE. Syntax FALSE ( ) Remark You can also type the word FALSE directly into the formula, and it is interpreted as the logical valu…

FDIST function

Article Returns the F probability distribution. You can use this function to determine whether two data sets have different degrees of diversity. For example, you can e…

FIND function

Article Finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first charact…

FINV function

Article Returns the inverse of the F probability distribution. If p = FDIST(x,…), then FINV(p,…) = x. The F distribution can be used in an F-test that compares the …

FISHER function

Article Returns the Fisher transformation at x. This transformation produces a function that is approximately normally distributed rather than skewed. Use this function…

FISHERINV function

Article Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then F…

FIXED function

Article Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. Syntax FIXE…

FLOOR function

Article Rounds number down, toward zero, to the nearest multiple of significance. Syntax FLOOR ( number , significance ) Number   is the numeric value you want to round…

FV function

Article Returns the future value of an investment based on periodic, constant payments and a constant interest rate. Syntax FV ( rate , nper , pmt , pv , type ) For a m…

GAMMADIST function

Article Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution. The gamma distribution is commonly used in que…

GAMMAINV function

Article Returns the inverse of the gamma cumulative distribution. If p = GAMMADIST(x,…), then GAMMAINV(p,…) = x. You can use this function to study a variable whose…

GAMMALN function

Article Returns the natural logarithm of the gamma function, ?(x). Syntax GAMMALN ( x ) X   is the value for which you want to calculate GAMMALN. Remarks If x is nonnum…

GEOMEAN function

Article Returns the geometric mean of positive data. For example, you can use GEOMEAN to calculate average growth rate given compound interest with variable rates. Synt…

HARMEAN function

Article Returns the harmonic mean of a data set. The harmonic mean is the reciprocal of the arithmetic mean of reciprocals. Syntax HARMEAN ( number1 , number2 , … ) N…

HOUR function

Article Returns the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.). Syntax HOUR ( serial_number ) Serial_number  …

HYPGEOMDIST function

Article Returns the hypergeometric distribution. HYPGEOMDIST returns the probability of a given number of sample successes, given the sample size, population successes,…

IF function

Article Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. Use IF to conduct conditional tests on values and for…

INT function

Article Rounds a number down to the nearest integer. Syntax INT ( number ) Number   is the real number you want to round down to an integer. Example 1 Formula Descripti…

IPMT function

Article Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. For a more complete descrip…

IS functions

Article This article describes the eight functions used for testing the type of a value or column reference. Each of these functions, referred to collectively as the I…

ISPMT function

Article Calculates the interest paid during a specific period of an investment. Syntax ISPMT ( rate , per , nper , pv ) Rate   is the interest rate for the investment….

KURT function

Article Returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness or flatness of a distribution compared with the normal distribution. Positive…

LEFT function

Article LEFT returns the first character or characters in a text string, based on the number of characters you specify. Syntax LEFT ( text , num_chars ) Text   is the t…

LEN function

Article LEN returns the number of characters in a text string. Syntax LEN ( text ) Text   is the text whose length you want to find. Spaces count as characters. Example…

LN function

Article Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904). Syntax LN ( number ) Number   is the positive real…

LOG function

Article Returns the logarithm of a number to the base you specify. Syntax LOG ( number , base ) Number   is the positive real number for which you want the logarithm. B…

LOG10 function

Article Returns the base-10 logarithm of a number. Syntax LOG10 ( number ) Number   is the positive real number for which you want the base-10 logarithm. Examples Formu…

LOGINV function

Article Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. If p = LO…

LOGNORMDIST function

Article Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with the parameters mean and standard_dev. Use this function to analyze …

LOWER function

Article Converts all uppercase letters in a text string to lowercase. Syntax LOWER ( text ) Text   is the text you want to convert to lowercase. LOWER does not change c…

MAX function

Article Returns the largest value in a set of values. Syntax MAX ( number1 , number2 , … ) Number1,number2,…   are 1 to 30 numbers for which you want to find the ma…

MAXA function

Article Returns the largest value in a list of arguments. Text and logical values such as TRUE and FALSE are compared as well as numbers. MAXA is similar to MINA. For m…

Me function

Article Returns the current user name. Syntax Me Remark The Me function can be used only with default values; you cannot use the Me function in a calculated column.

MEDIAN function

Article Returns the median of the given numbers. The median is the number in the middle of a set of numbers; that is, half the numbers have values that are greater than…

MID function

Article MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. Syntax MID …

MIN function

Article Returns the smallest number in a set of values. Syntax MIN ( number1 , number2 , … ) Number1, number2,…   are 1 to 30 numbers for which you want to find the…

MINA function

Article Returns the smallest value in the list of arguments. Text and logical values such as TRUE and FALSE are compared as well as numbers. Syntax MINA ( value1 , valu…

MINUTE function

Article Returns the minutes of a time value. The minute is given as an integer, ranging from 0 to 59. Syntax MINUTE ( serial_number ) Serial_number   is the time that …

MOD function

Article Returns the remainder after number is divided by divisor. The result has the same sign as divisor. Syntax MOD ( number , divisor ) Number   is the number for wh…

MODE function

Article Returns the most frequently occurring, or repetitive, value in the argument list. Like MEDIAN, MODE is a location measure. Syntax MODE ( number1 , number2 , ……

MONTH function

Article Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December). Syntax MONTH ( serial_n…

NEGBINOMDIST function

Article Returns the negative binomial distribution. NEGBINOMDIST returns the probability that there will be number_f failures before the number_s-th success, when the c…

NORMDIST function

Article Returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypo…

NORMINV function

Article Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. Syntax NORMINV ( probability , mean , standard_dev ) Pr…

NORMSDIST function

Article Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in plac…

NORMSINV function

Article Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one. Syntax NORMSINV ( proba…

NOT function

Article Reverses the value of its argument. Use NOT when you want to make sure a value is not equal to one particular value. Syntax NOT ( logical ) Logical   is a value…

NPER function

Article Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. Syntax NPER ( rate , pmt , pv , fv , type ) F…

NPV function

Article Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values). Synta…

ODD function

Article Returns number rounded up to the nearest odd integer. Syntax ODD ( number ) Number   is the value to round. Remarks If number is nonnumeric, ODD returns the #VA…

OR function

Article Returns Yes if any argument is TRUE; returns No if all arguments are FALSE. Syntax OR ( logical1 , logical2 , … ) Logical1, logical2,…   are 1 to 30 conditi…

PI function

Article Returns the number 3.14159265358979, the mathematical constant pi, accurate to 15 digits. Syntax PI () Examples Formula Description (Result) =PI() Pi (3.1415926…

PMT function

Article Calculates the payment for a loan based on constant payments and a constant interest rate. Syntax PMT ( rate , nper , pv , fv , type ) For a more complete descr…

POISSON function

Article Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number o…

POWER function

Article Returns the result of a number raised to a power. Syntax POWER ( number , power ) Number   is the base number. It can be any real number. Power   is the exponen…

PPMT function

Article Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate. Syntax PPMT ( rate …

PRODUCT function

Article Multiplies all the numbers given as arguments and returns the product. Syntax PRODUCT ( number1 , number2 , … ) Number1, number2,…   are 1 to 30 numbers tha…

PROPER function

Article Capitalizes the first letter and any other letters that follow a non-letter character in a text string. Converts all other letters in the text string to lowerca…

PV function

Article Returns the present value of an investment. The present value is the total amount that a series of future payments is worth now. For example, when you borrow mo…

RADIANS function

Article Converts degrees to radians. Syntax RADIANS ( angle ) Angle   is an angle in degrees that you want to convert. Example Formula Description (Result) =RADIANS(270…

RATE function

Article Returns the interest rate per period of an annuity. RATE is calculated by iteration and can have zero or more solutions. If the successive results of RATE do no…

REPLACE function

Article REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string. Syntax REPLACE ( old_text , start_num , num…

REPT function

Article Repeats text a given number of times. Use REPT to add a number of instances of a text string. Syntax REPT ( text , number_times ) Text   is the text you want to…

RIGHT function

Article RIGHT returns the last characters in a text string, based on the number of characters you specify. Syntax RIGHT ( text , num_chars ) Text   is the text string c…

ROMAN function

Article Converts an arabic numeral to roman, as text. Syntax ROMAN ( number , form ) Number   is the arabic numeral you want converted. Form   is a number specifying t…

ROUND function

Article Rounds a number to a specified number of digits. Syntax ROUND ( number , num_digits ) Number  Is the number you want to round. Num_digits  Specifies the number …

ROUNDDOWN function

Article Rounds a number down, toward zero. Syntax ROUNDDOWN ( number , num_digits ) Number   is any real number that you want rounded down. Num_digits   is the number o…

ROUNDUP function

Article Rounds a number up, away from 0 (zero). Syntax ROUNDUP ( number , num_digits ) Number   is any real number that you want rounded up. Num_digits   is the number …

SEARCH function

Article SEARCH returns the number of the character at which a specific character or text string is first found, beginning with start_num. Use SEARCH to determine the lo…

SECOND function

Article Returns the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59. Syntax SECOND ( serial_number ) Serial_number   is the time…

SIGN function

Article Determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative. Syntax SIGN ( number ) Numb…

SIN function

Article Returns the sine of the given angle. Syntax SIN ( number ) Number   is the angle in radians for which you want the sine. Remark If your argument is in degrees, …

SINH function

Article Returns the hyperbolic sine of a number. Syntax SINH ( number ) Number   is any real number. Remark The formula for the hyperbolic sine is: Example set 1 Formul…

SKEW function

Article Returns the skewness of a distribution. Skewness characterizes the degree of asymmetry of a distribution around its mean. Positive skewness indicates a distribu…

SLN function

Article Returns the straight-line depreciation of an asset for one period. Syntax SLN ( cost , salvage , life ) Cost   is the initial cost of the asset. Salvage   is t…

SQRT function

Article Returns a positive square root. Syntax SQRT ( number ) Number   is the number for which you want the square root. Remark If number is negative, SQRT returns the…

STANDARDIZE function

Article Returns a normalized value from a distribution characterized by mean and standard_dev. Syntax STANDARDIZE ( x , mean , standard_dev ) X   is the value you want …

STDEV function

Article Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). Syntax…

STDEVA function

Article Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). Text a…

STDEVP function

Article Calculates standard deviation based on the entire population given as arguments. The standard deviation is a measure of how widely values are dispersed from the…

STDEVPA function

Article Calculates standard deviation based on the entire population given as arguments, including text and logical values. The standard deviation is a measure of how w…

SUM function

Article Adds all the numbers in the specified arguments. Syntax SUM ( number1 , number2 , … ) Number1, number2,…   are 1 to 30 arguments for which you want the tota…

SUMSQ function

Article Returns the sum of the squares of the arguments. Syntax SUMSQ ( number1 , number2 , … ) Number1, number2,…   are 1 to 30 arguments for which you want the su…

SYD function

Article Returns the sum-of-years’ digits depreciation of an asset for a specified period. Syntax SYD ( cost , salvage , life , per ) Cost   is the initial cost of the a…

T function

Article Returns the text referred to by value. Syntax T ( value ) Value   is the value you want to test. Remarks If value is or refers to text, T returns value. If valu…

TAN function

Article Returns the tangent of the given angle. Syntax TAN ( number ) Number   is the angle in radians for which you want the tangent. Remark If your argument is in deg…

TANH function

Article Returns the hyperbolic tangent of a number. Syntax TANH ( number ) Number   is any real number. Remark The formula for the hyperbolic tangent is: Examples Formu…

TDIST function

Article Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points …

TEXT function

Article Converts a value to text in a specific number format. Syntax TEXT ( value , format_text ) Value   is a numeric value, a formula that evaluates to a numeric valu…

TIME function

Article Returns the decimal number for a particular time. The decimal number returned by TIME is a value ranging from 0 (zero) to 0.99999999, representing the times fro…

TIMEVALUE function

Article Returns the decimal number of the time represented by a text string. The decimal number is a value ranging from 0 (zero) to 0.99999999, representing the times f…

TINV function

Article Returns the t-value of the Student’s t-distribution as a function of the probability and the degrees of freedom. Syntax TINV ( probability , degrees_freedom ) P…

TODAY function

Article Returns the serial number of the current date. The serial number is the date-time code used for date and time calculations. You can use the TODAY function only …

TRIM function

Article Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular sp…

TRUE function

Article Returns the logical value TRUE. Syntax TRUE () Remark You can enter the value TRUE directly without using this function. The TRUE function is provided primarily…

TRUNC function

Article Truncates a number to an integer by removing the fractional part of the number. Syntax TRUNC ( number , num_digits ) Number   is the number you want to truncate…

UPPER function

Article Converts text to uppercase. Syntax UPPER ( text ) Text   is the text you want converted to uppercase. Text can be a column reference or text string. Example For…

USDOLLAR function

Article Converts a number to text using currency format, with the decimals rounded to the specified place. The format used is $#,##0.00_);($#,##0.00). Syntax USDOLLAR (…

VALUE function

Article Converts a text string that represents a number to a number. Syntax VALUE ( text ) Text   is the text enclosed in quotation marks or a column reference containi…

VAR function

Article Estimates variance based on a sample. Syntax VAR ( number1 , number2 , … ) Number1,number2,…   are 1 to 30 number arguments corresponding to a sample of a p…

VARA function

Article Estimates variance based on a sample. In addition to numbers, text and logical values such as TRUE and FALSE are included in the calculation. Syntax VARA ( valu…

VARP function

Article Calculates variance based on the entire population. Syntax VARP ( number1 , number2 , … ) Number1,number2, …   are 1 to 30 number arguments corresponding t…

VARPA function

Article Calculates variance based on the entire population. In addition to numbers, text and logical values such as TRUE and FALSE are included in the calculation. Synt…

WEEKDAY function

Article Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default. Syntax WEEKDAY ( seria…

WEIBULL function

Article Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device’s mean time to failure. Syntax WEIBULL ( x , alpha…

YEAR function

Article Returns the year corresponding to a date. Syntax YEAR ( serial_number ) Serial_number   is the date of the year you want to find. Remarks Dates are stored as se…

Dansk selvbetjening skyder forbi de unge

I følge Dansk IT og den seneste IT i Praksis 2012 skyder de danske selvbetjeningsløsninger forbi de unge fordi de er mere vant til at bruge løsninger som Facebook, Twitter osv.

Jeg tror årsagen ligger et helt andet sted.

Selvbetjening hos Skat

Tillad mig at komme med et lille eksempel fra det virkelige liv. Hvis jeg f.eks. gerne vil kontakt med Skat skal jeg på forsiden hos Skat først vælge hvem jeg overhovedet er og hvordan jeg vil logge på?!
clip_image002
Hvis jeg så ved at jeg vil bruge NemId, ja så er det frem med det elskede lille papkort og igennem den velkendte logon dialog (hvor selvom jeg allerede har valgt at jeg vil bruge NemId alligevel kan vælge andre muligheder?).
clip_image004
Efter logon møder jeg så nedenstående oversigt fra Skat der kan tage pusten fra enhver. Her kunne Skat godt lære noget af kommunerne der efterhånden har opdaget det med vise information der passer på min siutation. Når jeg nu er logget på med NemId, hvorfor så ikke starte med at vise information der er relevant for mig lige nu udfra skats oplysninger om mig og datoen taget i betragtning.
clip_image006
Jeg tror ikke at man skal være en særlig stor ekspert indenfor UX før man kan sige at oplevelsen godt kan gøres bedre – både for unge, ældre og gamle.

Selvbetjening hos Danske Bank

Hvis jeg nu vil i kontakt med min bank (i dette tilfælde Danske Bank) i stedet for Skat, så tager jeg min SmartPhone op af lommen og starter Danske Mobil App’en.
Her mødes jeg med følgende skærmbilled:
clip_image008
Hvis jeg trykker på den grønne knap for at logge ind.
clip_image010
Kan jeg nøjes med at indtaste et brugerid og en pinkode som jeg har aftalt med banken. Jeg behøver slet ikke at have mit lille papkort med – jeg skal bare have min SmartPhone, og hvis jeg er mellem 18 og 40 år gammel så er der mere end 99% sandsynlighed at jeg har min telefon og ikke mit papkort i lommen.
Når jeg er logget ind kan jeg med fingeren navigere og vælge hvilken funktion jeg vil bruge.
clip_image012
Nu vælger jeg at se kurslister for danske kroner mod dollars.
clip_image014
Jeg kan også foretage se saldo på mine konti, betale regninger og alle de andre ting som man forventer af en netbank.

Ambitionsniveauet skal op

Forskellen på Danske Mobil og Skats selvbetjeningsløsninger kan ikke være større. Skat virker kun på en computer og kræver NemId, Danske Mobil virker på Apple og Android og kræver ikke NemId. Hvis Danske Bank har vurderet, at det ikke er nødvendigt med NemId for at gøre deres mobile netbank sikker, hvorfor kan Skat så ikke også? Skat har brugt millioner af skattekroner på det ene SOA projekt efter det andet, så man skulle da tro at der var en webservice eller to der kunne bruges som bagende til en Skat mobilselvbetjening. Det er lige før jeg vil tilbyde at implementere en løsning til Skat gratis hvis jeg så må få en krone bagefter for hver borger der bruger løsningen.
Jeg tror slet ikke at problemet med de unges forbrug af selvbetjeningsløsninger har noget at gøre med Facebook, Twitter eller sociale medier i det hele taget – jeg tror mere at de offentlige selvbetjeningsløsninger har for dårlig UX og så er de ikke til stede der hvor de unge er online, nemlig på telefon og ikke på computer. I Danmark er udbredelsen af SmartPhones ligeså høj som i Sydkorea og alligevel kan man stadig ikke betale med sin telefon (pånær Roskilde Festival) eller komme i kontakt med det offentlige med mindre man er på jagt efter et toilet.
Det handler om at hæve ambitionsniveauet i stedet for at lave løsninger der er kryblet på forhånd for at leve op til WCAG L2 og alle mulige andre tilgængelighedskrav der (retteligt) skal gøre det muligt for personer med diverse perceptionshandicap at bruge løsningerne i stedet for at bruge pengene på de 99% (mit bud, fra hoften) der rent faktisk ikke har nogen handicap.

Windows 8 – God mode

Just hit Windows+x

Windows 7 – God Mode

Go to your desktop, create new folder and call it …

GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

… yes you must name it with the full stop and guid.

SCRUM needs CRACK

Posted this on my internal blog at Traen:

A critical success factor for SCRUM projects is having access to customer representatives who are:

  • Collaborative
  • Representative
  • Authorized
  • Committed
  • Knowledgeable

If the customer representatives are not collaborative, they will sow discord and frustration, resulting in the loss of morale.

If the are not representative, they will lead the developers to deliver unacceptable products.

If they are not authorized, they will incur delays seeking authorization or, even worse, lead the project astray by making unauthorized commitments.

If they are not committed, they won’t do the necessary homework and won’t be there when the developers need them most.

If they are not knowledgeable, they will cause delays, unacceptable products or both.

So SCRUM needs customers who are CRACK!

From “Balacing Agility and Descipline: A Guide for the Perplexed

Actually it’s true for any kind of project based on any proces or methodology…

Læser rapport fra Devoteam om ESDH…

…og kan ikke forstå hvad nedenstående billede har med noget at gøre?

  • Der er koldt på toppen?
  • Nu går det nedad?
  • Hey, se et bjerg i Japan?
  • Er det forsvarligt at bruge kampesten som autoværn?
  • Find selv på flere…

Virtuel maskine på Windows Azure

I sidste måned lancerede Microsoft officielt IaaS på Windows Azure. Det var også på tide kan man sige, og det bliver spændende at se om Microsoft kan indhente noget af det forspring som andre spillere som Amazon og Rackspace allerede har.

Anyways, det skal selvfølgelig testes. Så jeg har aktiveret IaaS på min Windows Azure profil og får dermed muligheden for at starte virtuelle maskiner i skyen.

Processen er temmelig enkel. Fra Virtual Machines “tabben” i Windows Azure Portalen vælger man +New fra bunden af siden.

image

Derefter kan man så vælge om man vil konfigurere selv fra bunden eller om man vil vælge en skabelon.

image

Her kan man så vælge fra en række skabeloner herunder diverse Unix distroer og selvfølgelig Windows Server 2012.

image

Derefter skal man blot svare på en række standard spørgsmål som størrelse på maskine (small, medium, large eller x-large) hostname, dns-navn og kodeord til administrator.

Og 2 minutter senere har man en virtuel maskine.

image

Med virtuelt netværk er det muligt at forbinde maskinen direkte til en hjemmenetværk og dermed tilgå f.eks. med brugere fra et privat domæne.

Indtil videre har Amazon været min favorit til Iaas, men jeg må sige at det her faktisk ser bedre ud.

300 nordiske it-chefer: Fremtiden er mobil

Iflg. en undersøgelse der bl.a. er lagt på Version 2 er følgende IT-trends de vigtigste for IT-chefer i Danmark, Sverige og Norge:

  1. Mobilitet
  2. Virtualisering
  3. Cloud computing
  4. Sociale medier
  5. Outsourcing
  6. Grøn it
  7. Biometri

Et par umiddelbare observationer fra min side må være at:

  • Forskellen på virtualisering, cloud computing, outsourcing og grøn it sikkert er meget lille gående mod 0. I hvert fald set fra en IT-chef med ansvar for drift.
  • Fokus på mobilitet er på vej til at blive 10’ernes svar på 00’ernes SOA. Forskellen er bare at HTML5 næsten allerede har løst problemet.

Jeg ville nok proppe åben data og åbne data protokoller som OData på listen i stedet for, så kommer muligheden for mobilitet af sig selv.

Min liste vil så være:

  1. Cloud computing
  2. Åbne protokoller
  3. Sociale Medier
  4. Biometri

9 bud fra Nets om e-handel som de ikke engang selv magter at overholde

Faldt lige over et indlæg på Amino om e-handel. Øverst på siden var der en bannerreklame fra Nets om et indlæg med 9 bud for en god e-handelsbutik.

I indlægget er der bl.a. følgende gode råd:

image

image

image

image

Det er alle gode og fornuftige råd. I indlægget er der også et link til Nets nye betalingsmodul Netaxcept. Nedenfor er så produktsiden for Netaxcept hos Nets:

image

Jeg har med rødt markeret nogle afvigelser fra Nets egne gode råd.

I flæng kan nævnes:

  • Jeg klikker på et link I noget reklamemateriale fra Nets og lander på en side med adressen bbs.dk. Sidste gang jeg var på noget med bbs så var det noget helt andet og her brugte man Goldedit.
  • I banneret på siden står der godt nok Nets, men hvorfor er jeg så ikke på nets.dk (undskyld nets.eu, for de havde jo ikke lige sikret sig domænet til deres eget navn…).
  • I forhold til brugeroplevelse så er siden helt ude I hampen. Navigationsmenuen ligner svensk. Produktbeskrivelserne er både på dansk og norsk – altså samtidigt.
  • Og hvis man klikker på linket til priser kommer man til nets.no og en PDF på norsk.

Det er en ommer!

Ting der står i vejen for digitalisering #digdk

I medierne, på Digitaliseringsmessen 2012 og senest på IT-brancheforeningens årlige møde har politikerne nærmest stået i kø for at fortælle om hvordan man kan skabe kæmpe gevinster vha. digitalisering.

Det tror jeg sådan set også man kan, men der er lige et par sten på vejen som skal ryddes først. I prioriteret rækkefølge kan man nævne:

  1. Fix lovgivningen så man kan bruge cloud
  2. Fix NemID så den kan bruges på alle platforme
  3. Få så bygget det danske datakatalog – ring til USA og så en kopi af koden fra http://data.gov
  4. Invester besparelserne fra cloud i nye løsninger på ny teknologi
  5. Sæt borgeren i centrum når man designer digitale løsninger og brug de ekstra penge der skal til for at sikre god UX
  6. Ambitionerne på selvbetjeningsløsninger skal WAY op!

1. Fix lovgivningen så man kan bruge cloud

Den danske lovgivning omkring personfølsomme data er nødt til at blive lavet om, så det er muligt at bruge cloud computing. Alt andet giver  simpelthen ikke mening, hverken økonomisk eller teknisk.

Etableringen af en driftsorganisation i Statens IT er en kæmpe fejltagelse. Det har ikke været økonomisk forsvarligt at etablere drift på “jorden” i snart mange år og prisen på kapacitet (CPU, RAM og lager) i skyen rasler dagligt ned.

2. Fix NemID så den kan bruges på alle platforme

I danmark er udbredelsen af SmartPhones på niveau med Korean og Japan og ligner noget i omegnen af 70% af befolkningen. Alligevel har vi en statslig login løsning der ikke virker på NOGEN mobile platforme.

Hvis vi skal lykkes med tvangsdigitalisering af selvbetjeningsløsninger er vi nødt til at sikre at vores foretrukne håndholdte IT platform (læs: SmartPhone) virker ligeså let som pinkoden på et Dankort.

3. Få så bygget det danske datakatalog – ring til USA og så en kopi af koden fra http://data.gov

ALLE er enige om at der ligger en guldgrube begravet i at sætte data fri. Men guldet kan kun graves frem hvis data rent faktisk er tilgængeligt som beskrevet i de 8 bud for åben data.

Det er mig et mysterium at ingen har fundet på at ringe til USA og bede (pænt) om en kopi af koden til http://data.gov – men det ville måske være for let.

Nå jo, jeg skrev også om det her sidste år.

4. Invester besparelserne fra cloud i nye løsninger på ny teknologi

Når man nu sparer en bunke penge, indledningsvis på hosting af eksisterende løsninger i skyen, så invester pengene i nye web2.0-ificeringer i stedet for at kanalisere pengene over i overførselsindkomster.

Tænk hvis man havde sparet en mia. kr. som man så havde kastet efter initiativer som Code for America.

5. Sæt borgeren i centrum når man designer digitale løsninger og brug de ekstra penge der skal til for at sikre god UX

Alle, OK næsten alle, bruger sociale tjenester og har efterhånden en nogenlunde opfattelse af hvordan det med at sætte brugeren i centrum fungerer. Så hvorfor ikke også sætte brugeren/borgeren i centrum når man designer selvbetjeningsløsninger til det offentlige? Hvorfor skal selvbetjeningsløsninger være baseret på de samme paradigmer som de offentlige institutioner bruger internt?

Hvis man skal lave løsninger som er pæne, brugervenlige og gennemtænkt (med andre ord har god UX) så koster det lidt mere end ellers, fordi man er nødt til at have bemanding på et projekt og man er nødt til at bruge ekstra tid på forundersøgelser og brugertest og sådan noget…

Men man er bare nødt til at kaste sig i støvet for den salige Steve Jobs og give ham ret i at UX betyder ALT. Det er fuldstændig lige meget hvor smart et system er hvis det er grimt og svært at bruge.

6. Ambitionerne på selvbetjeningsløsninger skal WAY op!

Hvis det er muligt for en virksomhed som Danske Bank at skabe mobile selvbetjeningsløsninger for noget så kompleks og sikkerhedstungt som Netbank, der kan rykke 50% (eller også er det mere) af deres brugere fra web til mobil og tablet, så må det også være muligt for offentlige instititutioner af gøre det samme.

Men ambitionsniveauet er nødt til at komme WAY op hvis det skal kunne lade sig gøre. Cremen af mobile løsninger pt. er hul-i-vejen og tag-et-billed-af-min-fyldte-skraldespand.

Der er INGEN tekniske forhindringer tilbage, ansvaret ligger udelukkende hos vores politikere.

« Ældre indlæg Nyere indlæg »