Export Sunday Routes To Spreadsheet

Sunday Routes Export

For those who prefer to have the information in columns, Excel provides a tool that allows you to “flip” the orientation between rows <> columns. Here’s how to do it using the current CSV file as an example:[single]

  1. Left click cell A1
  2. Hold the Shift key down and left click cell R6
  3. The data area to be flipped has now been selected
  4. Right click anywhere within the area selected
  5. Choose “Copy” in the menu
  6. Right click cell A11 (or any cell NOT within the selected area)
  7. Left click “Paste Special” in the menu
  8. Left click “Transpose” checkbox
  9. Left click “OK”

(Tnx K0RC for the pivot tips above)

[cfdb-export-link form="Florida QSO Party Sunday" header="true" orderby="call" linktext="<h3>Open SUNDAY spreadsheet</h3>" show="fqpday,call,your-email,mode,mobile,menu01,menu02,menu03,menu04,menu05,menu06,menu07,menu08,menu09,menu10,menu11,menu12,menu13,menu14,menu15,menu16,menu17,menu18,menu19,menu20,menu21,menu22,menu23,menu24,menu25,menu26,menu27,menu28,menu29,menu30,menu31,menu32,menu33,menu34,menu35,menu36,menu37,menu38,menu39,menu40,menu41,menu42,menu43,menu44,menu45,menu46,menu47,menu48,menu49,menu50,menu51,menu52,menu53,menu54,menu55,menu56,menu57,menu58,menu59,menu60,menu61,menu62,menu63,menu64,menu65,menu66,menu67" headers="fqpday=DAY,call=CALL,your-email=EMAIL,mode=MODE,mobile=MOBILE,menu01=01,menu02=02,menu03=03,menu04=04,menu05=05,menu06=06,menu07=07,menu08=08,menu09=09,menu10=10,menu11=11,menu12=12,menu13=13,menu14=14,menu15=15,menu16=16,menu17=17,menu18=18,menu19=19,menu20=20,menu21=21,menu22=22,menu23=23,menu24=24,menu25=25,menu26=26,menu27=27,menu28=28,menu29=29,menu30=30,menu31=31,menu32=32,menu33=33,menu34=34,menu35=35,menu36=36,menu37=37,menu38=38,menu39=39,menu40=40,menu41=41,menu42=42,menu43=43,menu44=44,menu45=45,menu46=46,menu47=47,menu48=48,menu49=49,menu50=50,menu51=51,menu52=52,menu53=53,menu54=54,menu55=55,menu56=56,menu57=57,menu58=58,menu59=59,menu60=60,menu61=61,menu62=62,menu63=63,menu64=64,menu65=65,menu66=66,menu67=67" filter="submit_time>$_GET(submit_time)"]