Changes between Version 5 and Version 6 of UserGuidelines/Importer/Excel
- Timestamp:
- 10/28/15 10:53:31 (8 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UserGuidelines/Importer/Excel
v5 v6 9 9 10 10 == Lookup Lists == 11 #Simple L1s11 Simple L1s 12 12 {{{ 13 13 =L1s 14 14 }}} 15 #Prevent modifying the L1 again if the L2 has been selected15 Prevent modifying the L1 again if the L2 has been selected 16 16 {{{ 17 17 =IF(L2_Selected="", L1s, INDIRECT("FakeList")) 18 18 }}} 19 # Simple L2s based on L1 19 Simple L2s based on L1 20 * NB Dependent Lists must be sorted by dependency 20 21 {{{ 21 22 =OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1) 22 23 }}} 23 #With prevention24 With prevention 24 25 {{{ 25 26 =IF(L3_Selected="", OFFSET(L2_Start,MATCH(L1_Selected,L1s_for_L2,0),0,COUNTIF(L1s_for_L2,L1_Selected),1), INDIRECT("FakeList")) 26 27 }}} 27 # Simple L3s based on L2 28 # @ToDo: Multi-level lookups (Where L2s not Unique!) 28 Simple L3s based on L2 29 * ToDo: Multi-level lookups (Where L2s not Unique!) 30 * @ToDo: Can we prevent changes if any Fokontany selected? 29 31 {{{ 30 32 =OFFSET(L3_Start,MATCH(L2_Selected,L2s_for_L3,0),0,COUNTIF(L2s_for_L3,L2_Selected),1) 31 33 }}} 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!) 34 Simple L4s based on L3 35 * @ToDo: Multi-level lookups (Where L2s not Unique!) 35 36 {{{ 36 37 =OFFSET(L4_Start,MATCH(L3_Selected,L3s_for_L4,0),0,COUNTIF(L3s_for_L4,L3_Selected),1) 37 38 }}} 38 39 Dependent Lists must be sorted by dependency40 41 39 == Examples == 42 40 * [http://eden.sahanafoundation.org/raw-attachment/wiki/UserGuidelines/Importer/Excel/Volunteer%20Import%20Template%20(mg).xlsm Volunteers for Malagasy Red Cross]