Changes between Version 5 and Version 6 of UserGuidelines/Importer/Excel


Ignore:
Timestamp:
10/28/15 10:53:31 (8 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/Importer/Excel

    v5 v6  
    99
    1010== Lookup Lists ==
    11 # Simple L1s
     11Simple L1s
    1212{{{
    1313=L1s
    1414}}}
    15 # Prevent modifying the L1 again if the L2 has been selected
     15Prevent modifying the L1 again if the L2 has been selected
    1616{{{
    1717=IF(L2_Selected="", L1s, INDIRECT("FakeList"))
    1818}}}
    19 # Simple L2s based on L1
     19Simple L2s based on L1
     20* NB Dependent Lists must be sorted by dependency
    2021{{{
    2122=OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1)
    2223}}}
    23 # With prevention
     24With prevention
    2425{{{
    2526=IF(L3_Selected="", OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1), INDIRECT("FakeList"))
    2627}}}
    27 # Simple L3s based on L2
    28 # @ToDo: Multi-level lookups (Where L2s not Unique!)
     28Simple L3s based on L2
     29* ToDo: Multi-level lookups (Where L2s not Unique!)
     30* @ToDo: Can we prevent changes if any Fokontany selected?
    2931{{{
    3032=OFFSET(L3_Start,MATCH(L2_Selected,L2s_for_L3,0),0,COUNTIF(L2s_for_L3,L2_Selected),1)
    3133}}}
    32 # @ToDo: Can we prevent changes if any Fokontany selected?
    33 # Simple L4s based on L3
    34 # @ToDo: Multi-level lookups (Where L2s not Unique!)
     34Simple L4s based on L3
     35* @ToDo: Multi-level lookups (Where L2s not Unique!)
    3536{{{
    3637=OFFSET(L4_Start,MATCH(L3_Selected,L3s_for_L4,0),0,COUNTIF(L3s_for_L4,L3_Selected),1)
    3738}}}
    38 
    39 Dependent Lists must be sorted by dependency
    40 
    4139== Examples ==
    4240* [http://eden.sahanafoundation.org/raw-attachment/wiki/UserGuidelines/Importer/Excel/Volunteer%20Import%20Template%20(mg).xlsm Volunteers for Malagasy Red Cross]