Survey
177
en
gid
sid
group_name
group_order
description
language
randomization_group
grelevance
28
41614
G1
0
en
29
41614
G2
1
en
qid
parent_qid
sid
gid
type
title
question
preg
help
other
mandatory
question_order
language
scale_id
same_default
relevance
1248
0
41614
28
:

# an

Enter some numbers and see some calculations about them in the Help section
<table border="1" cellpadding="1" cellspacing="1" style="width: 500px; "> <thead> <tr> <th scope="col"> Purpose</th> <th scope="col"> Equation</th> <th scope="col"> Result</th> </tr> </thead> <tbody> <tr> <td> # answered</td> <td> count(self)</td> <td> {count(self)}</td> </tr> <tr> <td> grand total</td> <td> sum(self)</td> <td> {sum(self)}</td> </tr> <tr> <td> # answered in column C</td> <td> count(self.sq_C)</td> <td> {count(self.sq_C)}</td> </tr> <tr> <td> sum of column C</td> <td> sum(self.sq_C)</td> <td> {sum(self.sq_C)}</td> </tr> <tr> <td> sum of columns B-D</td> <td> sum(self.sq_B.sq_C.sq_D)</td> <td> {sum(self.sq_B.sq_C.sq_D)}</td> </tr> <tr> <td> # of negative values</td> <td> countifop("lt",0,self)</td> <td> {countifop("lt",0,self)}</td> </tr> <tr> <td> sum of positive values</td> <td> sumifop("gt",0,self)</td> <td> {sumifop("gt",0,self)}</td> </tr> <tr> <td> count of even numbers</td> <td> countifop("RX","/[02468]$/",self)</td> <td> {countifop("RX","/[02468]$/",self)}</td> </tr> <tr> <td> sum of odd numbers</td> <td> sumifop("RX","/[13579]$/",self)</td> <td> {sumifop("RX","/[13579]$/",self)}</td> </tr> </tbody> </table> <p> </p>
N
N
0
en
0
0
1
1249
0
41614
29
X

# result

<table border="1" cellpadding="1" cellspacing="1" style="width: 500px; "> <thead> <tr> <th scope="col"> Purpose</th> <th scope="col"> Equation</th> <th scope="col"> Result</th> </tr> </thead> <tbody> <tr> <td> # answered</td> <td> count(that.an)</td> <td> {count(that.an)}</td> </tr> <tr> <td> grand total</td> <td> sum(that.an)</td> <td> {sum(that.an)}</td> </tr> <tr> <td> # answered in column C</td> <td> count(that.an.sq_C)</td> <td> {count(that.an.sq_C)}</td> </tr> <tr> <td> sum of column C</td> <td> sum(that.an.sq_C)</td> <td> {sum(that.an.sq_C)}</td> </tr> <tr> <td> sum of columns B-D</td> <td> sum(that.an.sq_B.sq_C.sq_D)</td> <td> {sum(that.an.sq_B.sq_C.sq_D)}</td> </tr> <tr> <td> # of negative values</td> <td> countifop("lt",0,that.an)</td> <td> {countifop("lt",0,that.an)}</td> </tr> <tr> <td> sum of positive values</td> <td> sumifop("gt",0,that.an)</td> <td> {sumifop("gt",0,that.an)}</td> </tr> <tr> <td> count of even numbers</td> <td> countifop("RX","/[02468]$/",that.an)</td> <td> {countifop("RX","/[02468]$/",that.an)}</td> </tr> <tr> <td> sum of odd numbers</td> <td> sumifop("RX","/[13579]$/",that.an)</td> <td> {sumifop("RX","/[13579]$/",that.an)}</td> </tr> </tbody> </table> <p> </p>
N
N
0
en
0
0
1
qid
parent_qid
sid
gid
type
title
question
preg
help
other
mandatory
question_order
language
scale_id
same_default
relevance
1250
1248
41614
28
T

# 1

1st sub-question
N
N
1
en
0
0
1251
1248
41614
28
T

# 2

2nd sub-question
N
N
2
en
0
0
1252
1248
41614
28
T

# 3

3rd sub-question
N
N
3
en
0
0
1253
1248
41614
28
T

# 4

4th sub-question
N
N
4
en
0
0
1254
1248
41614
28
T

# 5

5th sub-question
N
N
5
en
0
0
1255
1248
41614
28
T

# A

Column A
N
N
1
en
1
0
1256
1248
41614
28
T

# B

Column B
N
N
2
en
1
0
1257
1248
41614
28
T

# C

Column C
N
N
3
en
1
0
1258
1248
41614
28
T

# D

Column D
N
N
4
en
1
0
1259
1248
41614
28
T

# E

Column E
N
N
5
en
1
0
qid
attribute
value
language
1248
answer_width
1248
array_filter
1248
array_filter_exclude
1248
array_filter_style
0
1248
em_validation_q
1248
em_validation_q_tip
1248
em_validation_sq
1248
em_validation_sq_tip
1248
exclude_all_others
1248
hidden
0
1248
hide_tip
0
1248
input_boxes
1
1248
max_answers
1248
maximum_chars
1248
min_answers
1248
multiflexible_checkbox
0
1248
multiflexible_max
1248
multiflexible_min
1248
multiflexible_step
1248
page_break
0
1248
public_statistics
0
1248
random_group
1248
random_order
0
1248
reverse
0
1248
scale_export
0
1249
hidden
0
1249
hide_tip
0
1249
page_break
0
1249
random_group
1249
time_limit
1249
time_limit_action
1
1249
time_limit_countdown_message
en
1249
time_limit_disable_next
0
1249
time_limit_disable_prev
0
1249
time_limit_message
en
1249
time_limit_message_delay
1249
time_limit_message_style
1249
time_limit_timer_style
1249
time_limit_warning
1249
time_limit_warning_2
1249
time_limit_warning_2_display_time
1249
time_limit_warning_2_message
en
1249
time_limit_warning_2_style
1249
time_limit_warning_display_time
1249
time_limit_warning_message
en
1249
time_limit_warning_style
sid
admin
expires
startdate
adminemail
anonymized
faxto
format
savetimings
template
language
additional_languages
datestamp
usecookie
allowregister
allowsave
autonumber_start
autoredirect
allowprev
printanswers
ipaddr
refurl
publicstatistics
publicgraphs
listpublic
htmlemail
sendconfirmation
tokenanswerspersistence
assessments
usecaptcha
usetokens
bounce_email
attributedescriptions
emailresponseto
emailnotificationto
tokenlength
showxquestions
showgroupinfo
shownoanswer
showqnumcode
bouncetime
bounceprocessing
bounceaccounttype
bounceaccounthost
bounceaccountpass
bounceaccountencryption
bounceaccountuser
showwelcome
showprogress
questionindex
navigationdelay
nokeyboard
alloweditaftercompletion
googleanalyticsstyle
googleanalyticsapikey
41614
N
G
N
default
en
N
N
N
Y
0
N
N
N
N
N
N
N
N
Y
Y
N
N
D
N
15
Y
B
Y
X
N
Y
Y
0
0
N
N
surveyls_survey_id
surveyls_language
surveyls_title
surveyls_description
surveyls_welcometext
surveyls_endtext
surveyls_url
surveyls_urldescription
surveyls_email_invite_subj
surveyls_email_invite
surveyls_email_remind_subj
surveyls_email_remind
surveyls_email_register_subj
surveyls_email_register
surveyls_email_confirm_subj
surveyls_email_confirm
surveyls_dateformat
surveyls_attributecaptions
email_admin_notification_subj
email_admin_notification
email_admin_responses_subj
email_admin_responses
surveyls_numberformat
attachments
41614
en
countifop and sumifop test
Tests countifop() and sumifop() functions
Invitation to participate in a survey
Dear {FIRSTNAME},<br /><br />you have been invited to participate in a survey.<br /><br />The survey is titled:<br />"{SURVEYNAME}"<br /><br />"{SURVEYDESCRIPTION}"<br /><br />To participate, please click on the link below.<br /><br />Sincerely,<br /><br />{ADMINNAME} ({ADMINEMAIL})<br /><br />----------------------------------------------<br />Click here to do the survey:<br />{SURVEYURL}<br /><br />If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />{OPTOUTURL}
Reminder to participate in a survey
Dear {FIRSTNAME},<br /><br />Recently we invited you to participate in a survey.<br /><br />We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.<br /><br />The survey is titled:<br />"{SURVEYNAME}"<br /><br />"{SURVEYDESCRIPTION}"<br /><br />To participate, please click on the link below.<br /><br />Sincerely,<br /><br />{ADMINNAME} ({ADMINEMAIL})<br /><br />----------------------------------------------<br />Click here to do the survey:<br />{SURVEYURL}<br /><br />If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />{OPTOUTURL}
Survey registration confirmation
Dear {FIRSTNAME},<br /><br />You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.<br /><br />To complete this survey, click on the following URL:<br /><br />{SURVEYURL}<br /><br />If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.
Confirmation of your participation in our survey
Dear {FIRSTNAME},<br /><br />this email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.<br /><br />If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.<br /><br />Sincerely,<br /><br />{ADMINNAME}
1
Response submission for survey {SURVEYNAME}
Hello,<br /><br />A new response was submitted for your survey '{SURVEYNAME}'.<br /><br />Click the following link to reload the survey:<br />{RELOADURL}<br /><br />Click the following link to see the individual response:<br />{VIEWRESPONSEURL}<br /><br />Click the following link to edit the individual response:<br />{EDITRESPONSEURL}<br /><br />View statistics by clicking here:<br />{STATISTICSURL}
Response submission for survey {SURVEYNAME} with results
<style type="text/css"> .printouttable { margin:1em auto; } .printouttable th { text-align: center; } .printouttable td { border-color: #ddf #ddf #ddf #ddf; border-style: solid; border-width: 1px; padding:0.1em 1em 0.1em 0.5em; }

.printouttable td:first-child { font-weight: 700; text-align: right; padding-right: 5px; padding-left: 5px;

} .printouttable .printanswersquestion td{ background-color:#F7F8FF; }

.printouttable .printanswersquestionhead td{ text-align: left; background-color:#ddf; }

.printouttable .printanswersgroup td{ text-align: center; font-weight:bold; padding-top:1em; } </style>Hello,<br /><br />A new response was submitted for your survey '{SURVEYNAME}'.<br /><br />Click the following link to reload the survey:<br />{RELOADURL}<br /><br />Click the following link to see the individual response:<br />{VIEWRESPONSEURL}<br /><br />Click the following link to edit the individual response:<br />{EDITRESPONSEURL}<br /><br />View statistics by clicking here:<br />{STATISTICSURL}<br /><br /><br />The following answers were given by the participant:<br />{ANSWERTABLE}
0