+ Reply to Thread
Results 1 to 2 of 2

Interactive Spreadsheet?

  1. #1
    Registered User
    Join Date
    04-25-2008
    Posts
    1

    Interactive Spreadsheet?

    Ok, so my boss requested an Excel spreadsheet broken down into three sheets: one master, and one for each of the two sites we are working on. I was able to accomplish that with a great deal of work using forumlas and other tricks school really should teach students...

    Anyway, I was wondering if there was a way all of the project managers could be able to all access at a minimum their campus site sheet on the workbook and update it, even though they would be at different locations miles apart, and for the project executive to be able to view the master.

    Would this require a website? Or is it possible through some of the other microsoft programs?

    Thank you for your time and any help you can lend!

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Quote Originally Posted by Dougal Rendarck
    Ok, so my boss requested an Excel spreadsheet broken down into three sheets: one master, and one for each of the two sites we are working on. I was able to accomplish that with a great deal of work using forumlas and other tricks school really should teach students...

    Anyway, I was wondering if there was a way all of the project managers could be able to all access at a minimum their campus site sheet on the workbook and update it, even though they would be at different locations miles apart, and for the project executive to be able to view the master.

    Would this require a website? Or is it possible through some of the other microsoft programs?

    Thank you for your time and any help you can lend!
    Are are the locations networked to your main site where the data is held? If so you'd be better using a relational database like Microsoft Access. The principal advantage is that it is a multi-user system, which means several people can be updating it at the same time.

    Excel is essentially a single user system. That doesn't mean that several users can't open the same file at the same time, but generally speaking only the first one to open the file can make and save changes. Excel does have the ability to do what they call 'sharing' a workbook, but you still have to reconcile any conflicts where people want to change the same data.

    If you're not networked then your next best option is to allow sites to have their own standard xl templates which they forward to you, and you then arrange for macros in the main workbook to upload these and put the data in the appropriate place.

    If you do it this way I'd be inclined to arrange it so that as you load the supporting workbooks you build up a simple flat two dimensional database containing all the data rows, rather than just keeping the original template sheets. Keep these as well if you want all the wizzy formatting stuff with colours and borders etc., but don't rely on these if you're going to need any sort of overall master summary analysis.

    HTH

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.05335 seconds
  • Memory Usage 8,851KB
  • Queries Executed 14 (?)
More Information
Template Usage (32):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (2)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (2)postbit_legacy
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (46):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1