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

Timestamp:

10/28/15 10:53:31 (8 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/Importer/Excel

@@ -9 +9 @@
 
 == Lookup Lists ==
-# Simple L1s
+Simple L1s
 {{{
 =L1s
 }}}
-# Prevent modifying the L1 again if the L2 has been selected
+Prevent modifying the L1 again if the L2 has been selected
 {{{
 =IF(L2_Selected="", L1s, INDIRECT("FakeList"))
 }}}
-# Simple L2s based on L1
+Simple L2s based on L1
+* NB Dependent Lists must be sorted by dependency
 {{{
 =OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1)
 }}}
-# With prevention
+With prevention
 {{{
 =IF(L3_Selected="", OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1), INDIRECT("FakeList"))
 }}}
-# Simple L3s based on L2
-# @ToDo: Multi-level lookups (Where L2s not Unique!)
+Simple L3s based on L2
+* ToDo: Multi-level lookups (Where L2s not Unique!)
+* @ToDo: Can we prevent changes if any Fokontany selected?
 {{{
 =OFFSET(L3_Start,MATCH(L2_Selected,L2s_for_L3,0),0,COUNTIF(L2s_for_L3,L2_Selected),1)
 }}}
-# @ToDo: Can we prevent changes if any Fokontany selected?
-# Simple L4s based on L3
-# @ToDo: Multi-level lookups (Where L2s not Unique!)
+Simple L4s based on L3
+* @ToDo: Multi-level lookups (Where L2s not Unique!)
 {{{
 =OFFSET(L4_Start,MATCH(L3_Selected,L3s_for_L4,0),0,COUNTIF(L3s_for_L4,L3_Selected),1)
 }}}
-
-Dependent Lists must be sorted by dependency
-
 == Examples ==
 * [http://eden.sahanafoundation.org/raw-attachment/wiki/UserGuidelines/Importer/Excel/Volunteer%20Import%20Template%20(mg).xlsm Volunteers for Malagasy Red Cross]