/    Sign up×
Community /Pin to ProfileBookmark

Create User Input Table and Add Total

Copy linkTweet thisAlerts:
Dec 01.2011

Hi All,

I am trying to modify the table found in the following Link (section 4, Post Event Calculated tonnes) to recreate an identical table that I require:[URL=”http://www.surveygizmo.com/s3/438787/OES-Special-Event-Follow-Up”]Special Event Follow Up[/URL]

Someone prior to me create this sheet and I would like to modify the formula and the headings in that specific table only. How can I recreate an identical table with different headings to represent the items I require. Any help would be greatly appreciated.

Thanks in advance for your help

to post a comment
JavaScript

1 Comments(s) ↴

Copy linkTweet thisAlerts:
@JMRKERDec 01.2011 — As as starting point, I believe this is the area you are looking to change.
<i>
</i>&lt;!DOC HTML&gt;
&lt;html&gt;
&lt;head&gt;
&lt;title&gt; Untitled &lt;/title&gt;

&lt;/head&gt;
&lt;body&gt;
&lt;div id="sgE-438787-1-340-box" class="sg-question sg-type-table sg-type-table-textbox"&gt;
&lt;input type="hidden" id="sgE-438787-1-340-meta" name="sgE-438787-1-340-meta" value="hidden=false&amp;amp;required=false" /&gt;

&lt;div class="sg-question-title"&gt;
Post-event Calculated Tonnage
&lt;/div&gt;

&lt;div class="sg-question-description sg-question-description-below"&gt;&lt;p&gt;Please calculate tonnage, as follows:&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: medium;"&gt;[# of pallets or bins] x [weight per pallet or bin]
= estimated weight in metric tonnes (MT)&lt;/span&gt;&lt;/p&gt;
&lt;/div&gt;

&lt;div class="sg-question-options"&gt;
&lt;table class="sg-table " cellpadding="0" cellspacing="0" border="0"&gt;
&lt;thead class="sg-header-row-first"&gt;
&lt;tr&gt;
&lt;th class="sg-first-cell"&gt;&lt;span class="sg-access-helper"&gt;Post-event Calculated Tonnage&lt;/span&gt;&lt;/th&gt;
&lt;th class="sg-second-cell"&gt;Number&lt;/th&gt;&lt;th class="sg-last-cell"&gt;Tonnage&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr class="sg-odd-row sg-first-row"&gt;
&lt;th class="sg-first-cell"&gt;Pallets (0.13 MT)&lt;/th&gt;
&lt;td class="sg-second-cell"&gt;
&lt;input type="text" class="sg-input sg-input-text"
title="Pallets (0.13 MT): Number" name="sgE-438787-1-341-10118" id="sgE-438787-1-341-10118" value="" size="5" /&gt;
&lt;/td&gt;
&lt;td class="sg-last-cell"&gt;
&lt;input type="text" class="sg-input sg-input-text"
title="Pallets (0.13 MT): Tonnage" name="sgE-438787-1-341-10119" id="sgE-438787-1-341-10119" value="" size="5" /&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class="sg-even-row sg-last-row"&gt;
&lt;th class="sg-first-cell"&gt;20 yd bins (2.5 MT)&lt;/th&gt;
&lt;td class="sg-second-cell"&gt;&lt;input type="text" class="sg-input sg-input-text"
title="20 yd bins (2.5 MT): Number" name="sgE-438787-1-342-10118" id="sgE-438787-1-342-10118" value="" size="5" /&gt;
&lt;/td&gt;
&lt;td class="sg-last-cell"&gt;
&lt;input type="text" class="sg-input sg-input-text"
title="20 yd bins (2.5 MT): Tonnage" name="sgE-438787-1-342-10119" id="sgE-438787-1-342-10119" value="" size="5" /&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class="sg-odd-row"&gt;
&lt;th class="sg-first-cell"&gt;30 yd bins (3.0 MT)&lt;/th&gt;
&lt;td class="sg-second-cell"&gt;
&lt;input type="text" class="sg-input sg-input-text"
title="30 yd bins (3.0 MT): Number" name="sgE-438787-1-343-10118" id="sgE-438787-1-343-10118" value="" size="5" /&gt;
&lt;/td&gt;
&lt;td class="sg-last-cell"&gt;
&lt;input type="text" class="sg-input sg-input-text"
title="30 yd bins (3.0 MT): Tonnage" name="sgE-438787-1-343-10119" id="sgE-438787-1-343-10119" value="" size="5" /&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr class="sg-even-row"&gt;
&lt;th class="sg-first-cell"&gt;40 yd bins (4.0 MT)&lt;/th&gt;
&lt;td class="sg-second-cell"&gt;
&lt;input type="text" class="sg-input sg-input-text"
title="40 yd bins (4.0 MT): Number" name="sgE-438787-1-344-10118" id="sgE-438787-1-344-10118" value="" size="5" /&gt;
&lt;/td&gt;
&lt;td class="sg-last-cell"&gt;
&lt;input type="text" class="sg-input sg-input-text"
title="40 yd bins (4.0 MT): Tonnage" name="sgE-438787-1-344-10119" id="sgE-438787-1-344-10119" value="" size="5" /&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;!-- /sg-question-options --&gt;
&lt;/div&gt;
&lt;!-- /sge-box --&gt;
&lt;/div&gt;
&lt;/body&gt;
&lt;/html&gt;

It is not formatted yet as I have not included the CSS references. Find the appropriate external files and reference them to see it prettier.

You should be able to change the headings to the desired words as a start.

It does not calculate yet because you need to find the events that do the calculations with the new formulas you intend to use.

These are probably located in one of the external JS files. I just have not had the time to look for them yet.
×

Success!

Help @Savio spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.17,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...